Use the data from 2002 in Appendix D to calculate each of the following: • Current ratio • Long-term solvency ratio • Contribution ratio • Programs and expense ratio • General and management and expense ratio • Revenue and expense ratio Post your final calculations as a Microsoft® Word attachment.
Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
Balance Sheet
|
|
| |
| XYZ NONPROFIT CORPORATION |
| BALANCE SHEET |
|
|
| 2002 (A) |
|
| 2003 (A) |
|
| 2004 (A) |
| ASSETS |
| Current assets |
| Cash |
|
| $2,576.00 |
|
| $20,904.00 |
| $86,971.00 |
| Investments |
|
| $12,000.00 |
$12,000.00 $12,000.00
| Accounts Receivables, net |
$88,764.00 |
$47,884.00 |
$199,905.00 |
| Prepaid expense |
$956.00 |
$1,270.00 |
$4,026.00 |
| Total Current Assets |
$104,296.00 |
$82,058.00 |
$302,902.00 |
| Property and equipment, net |
| Land |
$192,300.00 |
| $193,372.00 |
$193,372.00
| Furniture and equipment |
$59,135.00 |
$61,053.00 |
$92,267.00 |
| Leasehold improvements |
$35,539.00 |
$23,380.00 |
$110,463.00 |
| Total property and equipment |
$286,974.00 |
$277,805.00 |
$396,102.00 |
| TOTAL ASSETS |
| $391,270.00 |
| $359,863.00 |
| $699,004.00 |
|
| LIABILITIES |
AND
NET ASSETS |
LIABILITIES
| Current liabilities |
| Accounts payable |
$74,826.00 |
$39,951.00 |
$104,201.00 |
| Accrued payroll and related liabilities |
$57,888.00 |
$45,954.00 |
$66,359.00 |
| Note payable (current portion) |
$6,303.00 |
$8,070.00 |
$166,161.00 |
| Capital lease obligation (current portion) |
|
|
|
|
|
|
|
|
|
|
| $0.00 |
$0.00
$312.00 |
| Total current liabilities |
$139,017.00 |
$93,975.00 |
$337,033.00 |
| Note payable (long term) |
$0.00 $0.00
$1,904.00 |
| Capital lease obligation (long term) |
$171,229.00 |
$166,004.00 |
$0.00
| Total liabilities |
$310,246.00 |
$259,979.00 |
$338,937.00 |
NET ASSETS
| Unrestricted |
($38,418.00) |
($105,127.00) |
$27,202.00 |
| Temporarily restricted |
$119,442.00 |
$205,011.00 |
$332,865.00 |
| Total net assets |
$81,024.00 |
$99,884.00 |
$360,067.00 |
| TOTAL LIABILITIES AND NET ASSETS |
$391,270.00 $359,863.00 $699,004.00
Income Statement
| XYZ NON-PROFIT CORPORATION |
| INCOME STATEMENT |
2002 (A) 2003 (A) 2004 (A)
Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
| Revenue |
| Grant Income |
$617,169.00 |
$632,889.00 |
$1,078,837.00 |
| Customer Fees |
$506,788.00 |
$579,824.00 |
$1,004,874.00 |
|
| Other |
$39,567.00 |
$31,362.00 |
$107,370.00 |
| Interest |
$1,541.00 |
$186.00 |
$162.00 |
| Total Revenue |
$1,165,065.00 |
$1,244,261.00 |
$2,191,243.00 |
| Expenses |
| Program services |
| Payroll and benefits |
$417,004.00 |
$520,069.00 |
$915,787.20 |
| Supplies |
$125,101.20 |
$171,622.77 |
$320,525.52 |
| Rent and Utilities |
|
| $150,000.00 |
$150,000.00 $150,000.00
| Telephone |
|
| $24,000.00 |
$24,000.00 $24,000.00
Other
| $117,903.00 |
$79,888.00 |
$115,999.00 |
| Management and other |
$351,000.00 |
$371,101.00 |
$445,819.00 |
| Total Expenses |
$1,185,008.00 |
$1,316,681.00 |
$1,972,131.00 |
| Excess revenues of expenses |
| ($19,943.00) |
| ($72,420.00) |
| $219,112.00 |
| Customer Count |
5962 |
6821 |
11822 |
Statement of Cash Flows
| ASSOCIATE LEVEL MATERIAL: APPENDIX D |
XYZ NONPROFIT CORPORATION
| STATEMENT OF CASH FLOW |
2002 (A) 2003 (A) 2004 (A)
| CASH FLOW FROM OPERATING ACTIVITIES |
| Excess revenues over expenses |
($19,943.00) ($72,420.00) $219,112.00
| Adjustments to reconcile cash provided (used) in operations |
| Depreciation |
$21,311.00 |
$26,396.00 |
$36,452.00 |
| Decrease (increase) in accounts receivable |
($38,475.00) |
$132,160.00 |
($110,950.00) |
| Decrease (increase) in prepaid expenses |
$307.00 |
($314.00) |
($2,640.00) |
| Increase (decrease) in accounts payable |
$41,755.00 |
($34,875.00) |
$64,250.00 |
| Increase (decrease) in accrued payroll and related expenses |
$5,976.00 |
($11,934.00) |
$20,405.00 |
| Decrease (increase) in other assets |
$0.00 $0.00
($116.00) |
| Net cash provided (used) in operations |
$10,931.00 |
$39,013.00 |
$226,513.00 |
| CASH FLOW FROM INVESTING ACTIVITIES |
| Acquisition of capital items |
| ($248,787.00) |
| ($17,227.00) |
| ($154,649.00) |
| Net cash used by investing activities |
($248,787.00) ($17,227.00) ($154,649.00)
| CASH FLOW FROM FINANCING ACTIVITIES |
| Net proceeds from refinancing of loan |
$180,000.00 |
$3,539.00 |
$0.00
| Decrease in loans |
($2,468.00) |
($6,997.00) |
($7,913.00) |
| Capital lease obligations |
$0.00 $0.00
$2,243.00 |
| Principle payments on capital lease obligation |
$0.00 $0.00
($127.00) |
| Net cash provided (used) in financing activities |
$177,532.00 |
($3,458.00) |
($5,797.00) |
| Net increase (decrease) in cash |
($60,324.00) |
$18,328.00 |
$66,067.00 |
| Cash, beginning of year |
$62,900.00 |
$2,576.00 $20,904.00
| Cash, end of year |
$2,576.00 $20,904.00 $86,971.00
Order your essay today and save 25% with the discount code: STUDYSAVE
Turn in your highest-quality paper
Get a qualified writer to help you with
“ Use the data from 2002 in Appendix D to calculate each of the following:• Current ratio• Long-term solvency ratio• Contribution ratio• Programs and expense… ”
Get high-quality paper
NEW! AI matching with writer
