# View the step-by-step solution to: Use the data from 2002 in Appendix D to calculate each of the

Use the data from 2002 in Appendix D to calculate each of the following (Be sure to show your work so I can provide you with more detailed feedback):
o Current ratio
o Long-term solvency ratio
o Contribution ratio
o Programs/expense ratio
o General and management/expense ratio
o Fundraising and expense ratio
o Revenue/expense ratio
Also, you will have to use the first two spreadsheets of Appendix D (Balance Sheet and Income Statement) to solve for the ratios.

XYZ NONPROFIT CORPORATION
BALANCE SHEET
2002 (A)
2003 (A)
ASSETS
Current assets
Cash
Investments
Accounts Receivables, net
Prepaid expense
Total Current Assets
Property and equipment, net
Land
Furniture and equipment
Leasehold improvements
Total property and equipment
TOTAL ASSETS

2004 (A)

\$2,576.00
\$12,000.00
\$88,764.00
\$956.00
\$104,296.00

\$20,904.00 \$86,971.00
\$12,000.00 \$12,000.00
\$47,884.00 \$199,905.00
\$1,270.00
\$4,026.00
\$82,058.00 \$302,902.00

\$192,300.00
\$59,135.00
\$35,539.00
\$286,974.00

\$193,372.00 \$193,372.00
\$61,053.00 \$92,267.00
\$23,380.00 \$110,463.00
\$277,805.00 \$396,102.00

\$391,270.00

\$359,863.00 \$699,004.00

\$74,826.00
\$57,888.00
\$6,303.00
\$0.00
\$139,017.00

\$39,951.00 \$104,201.00
\$45,954.00 \$66,359.00
\$8,070.00 \$166,161.00
\$0.00
\$312.00
\$93,975.00 \$337,033.00

LIABILITIES AND NET ASSETS
LIABILITIES
Current liabilities
Accounts payable
Accrued payroll and related liabilities
Note payable (current portion)
Capital lease obligation (current portion)
Total current liabilities
Note payable (long term)
Capital lease obligation (long term)

\$0.00
\$171,229.00

\$0.00
\$166,004.00

Total liabilities

\$310,246.00

\$259,979.00 \$338,937.00

NET ASSETS
Unrestricted
Temporarily restricted

(\$38,418.00) (\$105,127.00) \$27,202.00
\$119,442.00 \$205,011.00 \$332,865.00

Total net assets
TOTAL LIABILITIES AND NET ASSETS

\$1,904.00
\$0.00

\$81,024.00

\$99,884.00 \$360,067.00

\$391,270.00

\$359,863.00 \$699,004.00

XYZ NON-PROFIT CORPORATION
INCOME STATEMENT
2002 (A)
2003 (A)

2004 (A)

\$617,169.00
\$506,788.00
\$39,567.00
\$1,541.00

\$632,889.00
\$579,824.00
\$31,362.00
\$186.00

\$1,078,837.00
\$1,004,874.00
\$107,370.00
\$162.00

\$1,165,065.00

\$1,244,261.00

\$2,191,243.00

\$417,004.00
\$125,101.20
\$150,000.00
\$24,000.00
\$117,903.00
\$351,000.00

\$520,069.00
\$171,622.77
\$150,000.00
\$24,000.00
\$79,888.00
\$371,101.00

\$915,787.20
\$320,525.52
\$150,000.00
\$24,000.00
\$115,999.00
\$445,819.00

\$1,185,008.00

\$1,316,681.00

\$1,972,131.00

(\$19,943.00)

(\$72,420.00)

\$219,112.00

5962

6821

11822

Revenue
Grant Income
Customer Fees
Other
Interest
Total Revenue
Expenses
Program services
Payroll and benefits
Supplies
Rent and Utilities
Telephone
Other
Management and other
Total Expenses
Excess revenues of expenses
Customer Count

AXIA COLLEGE 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
Decrease (increase) in accounts receivable
Decrease (increase) in prepaid expenses
Increase (decrease) in accounts payable
Increase (decrease) in accrued payroll and related expenses
Decrease (increase) in other assets

\$21,311.00 \$26,396.00
\$36,452.00
(\$38,475.00) \$132,160.00 (\$110,950.00)
\$307.00
(\$314.00)
(\$2,640.00)
\$41,755.00 (\$34,875.00)
\$64,250.00
\$5,976.00 (\$11,934.00)
\$20,405.00
\$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
Decrease in loans
Capital lease obligations
Principle payments on capital lease obligation

\$180,000.00
(\$2,468.00)
\$0.00
\$0.00

\$3,539.00
(\$6,997.00)
\$0.00
\$0.00

\$0.00
(\$7,913.00)
\$2,243.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

\$62,900.00

\$2,576.00

\$20,904.00

\$2,576.00

\$20,904.00

\$86,971.00

Cash, beginning of year
Cash, end of year

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.

### -

Educational Resources
• ## -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

Browse Documents