Need this done by tonight - 21:00 EST
mes.amer
4e_-_12-18_template.xlsTransactions
| Problem 12-18 | |||||||||||||
| TEMPLATE | |||||||||||||
| Transactions Worksheet | |||||||||||||
| Assets | Liabilities | Net Assets | |||||||||||
| Cash | Pledges Receivable, net | Contract Receivables | Investments | Prepaid Expense | Equipment | Note Payable | Unrestricted | Temporarily Restricted | |||||
| Beginning Balance | |||||||||||||
| 1 | |||||||||||||
| 2 | |||||||||||||
| 3a | |||||||||||||
| 3b | |||||||||||||
| 4a | |||||||||||||
| 4b | |||||||||||||
| 5 | |||||||||||||
| 6 | |||||||||||||
| 7 | |||||||||||||
| 8 | |||||||||||||
| 9 | |||||||||||||
| 10 | |||||||||||||
| 11 | |||||||||||||
| 12 | |||||||||||||
| Ending Balance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Balance Sheet
| FYA | |||||||
| Balance Sheet | |||||||
| As of December 31, 2013 and December 31, 2012 | |||||||
| Assets | 2013 | 2012 | Liabilities | 2013 | 2012 | ||
| Current Assets | Current Liabilities | ||||||
| Cash | $0 | $0 | Note Payable | $0 | $0 | ||
| Pledges Receivable, net | 0 | 0 | Total Current Liabilities | $0 | $0 | ||
| Contracts Receivable | 0 | 0 | |||||
| Prepaid Expense | 0 | 0 | Net Assets | ||||
| Total Current Assets | $0 | $0 | Unrestricted Net Assets | $0 | $0 | ||
| Temporarily Restricted Net Assets | 0 | 0 | |||||
| Total Net Assets | $0 | $0 | |||||
| Long-Term Assets | |||||||
| Equipment | $0 | $0 | |||||
| Total Long-Term Assets | $0 | $0 | |||||
| TOTAL ASSETS | $0 | $0 | TOTAL LIAB. AND NET ASSETs | $0 | $0 |
Activity Statement
| FYA | ||||
| Statement of Activities | ||||
| For the Year Ending December 31, 2013 | ||||
| Revenues and Support | Unrestricted | Temporarily Restricted | Total | |
| Donation Revenue | $0 | |||
| Contract Revenue | $0 | |||
| Donated In-Kind Service | $0 | |||
| Released from Restrictions | $0 | |||
| Total Revenue | $0 | $0 | $0 | |
| Expenses | ||||
| Recreation | $0 | |||
| Counseling | 0 | |||
| Administrative | 0 | |||
| Interest | 0 | |||
| Donated In-Kind Service | 0 | |||
| Depreciation | 0 | |||
| Bad Debts | 0 | |||
| Total Expenses | $0 | $0 | $0 | |
| Change in Net Assets | $0 | $0 | $0 | |
| Net Assets, Beginning | 0 | |||
| Net Assets, Ending | $0 | $0 |
Cash Flow Statement
| FYA | ||
| Cash Flow Statement | ||
| For the Year Ending December 31, 2013 | ||
| Cash from Operating Activities | ||
| Change in Unrestricted Net Assets | ||
| Depreciation | ||
| Bad Debt Expense | ||
| Changes in Current Assets | ||
| Pledges Receivable, net | ||
| Contracts Receivable | ||
| Prepaid Expense | ||
| Net Cash from Operations | $0 | |
| Cash from Financing Activities | ||
| Restricted Cash | ||
| Note Payable | ||
| Net Cash from Financing | $0 | |
| Net Change in Cash | $0 | |
| Cash, Beginning | ||
| Cash, Ending | $0 |
