HSM 260
diabla69
phoenix_week_9-final_project_due_day_7.htmWeek 9-Final Project: Due Day 7
Posted: Sat 12/07/2013 08:35 PM , by: Jan Bridgeford-Smith (mailto:[email protected])Week Nine
Final Project
Due Day 7
·Calculate the following: Current ratio, long-term solvency ratio, contribution ratio, programs and expense ratio, general and management and expense ratio, and revenue and expense ratio for the years 2002, 2003 and 2004. Show how you arrived at the ratios and organize your final answers in the following manner:
|
Ratios |
2002 |
2003 |
2004 |
|
Current ratio |
|
|
|
|
Long-term solvency ratio |
|
|
|
|
Contribution ratio |
|
|
|
|
Program/Expense ratio |
|
|
|
|
General/Mgmt. ratio |
|
|
|
|
Revenue/Expense ratio |
|
|
|
PART 2 of FINAL PROJECT
|
Total Revenue |
$1,165,065.00 |
Fixed |
Var. |
$1,244,261.00 |
Fixed |
Var. |
$2,191,243.00 |
Fixed |
Var. |
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Customers |
5,962 |
|
|
6,821 |
|
|
11,822 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2002 |
|
|
2003 |
|
|
2004 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
BEP Customers # |
|
|
|
|
|
|
|
|
|
Calculate the fixed cost, variable costs, and number of customers which would be the break-even point for the XYZ Corporation for the years 2002, 2003 and 2004 listed in Appendix D. Show your work and organize your response so it is easy to follow.
PART 3 of FINAL PROJECT-Balance Sheet
Address the following based on all 3 years of the Balance Sheet:
· If you were a loan officer, would you extend a line of credit to this organization in 2005? Explain your decision by describing which RATIOS you would look at and what those RATIOS tell you about the financial management of the organization.
|
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 |
|
|
|
|
|
|
|
XYZ Corporation-Revenues
|
|
2002 (A) |
2003 (A) |
2004 (A) |
2005 Moving Average Forecast |
2005 Weighted Average |
|
|
|
|
|
|
|
|
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 |
|
|
1. Based on the data above, use the simple moving average to FORECAST each line item of revenue. Show your work.
- Based on the data above, use the weighted average method to FORECAST just the TOTAL REVENUE
PART 4 of FINAL PROJECT-Essay
· Essay #1- For each budget describe the purpose, advantages, disadvantages, of the following budget systems:
line item budget
performance budget
program budget
Jan Bridgeford-Smith Faculty University of Phoenix [email protected] alt: [email protected] (315)331-6575 eastern time zone
