View the step-by-step solution to: XYZ NONPROFIT CORPORATION BALANCE SHEET 2002 (A) 2003

Use the data from 2002 in Appendix D to...
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. (note: You may post your work within the document for me to see. This way I can better correct any errors you may and give partial credit for answers based on parts of your calculation that are correct.)


hsm260_appendix_d(1) sophia.xls

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
  • 890,990,898

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • 890,990,898

    Flashcards

    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards