View the step-by-step solution to:

City of Charlottesville, Virginia Comprehensive Annual Financial Report Fiscal Year Ended June 30, 2010 www.charlottesville.org CITY OF...

• https://blackboard.strayer.edu/bbcswebdav/pid-11091218-dt-content-rid-86183459_2/courses/PAD505004VA016-1132-001/Charlottesville_Annual_Financial_Report_2010%5B1%5D.pdf

• Review the document titled “City of Charlottesville 2010 Annual Comprehensive Plan” located in the course shell.
Write a three to four (3-4) page paperin which you:
• Review the“City of Charlottesville2010 Annual Comprehensive Plan” and then complete Exercise 1 on page 152 using Exhibits C and D in the Annual Report and Table 9.4 on page 148.Change the title headers to the agency name. Save the Excel File as the agency’s name and includethe Multiyear Plan.
• Analyze the comparison of ratios.
• Analyze the measures of liquidity.
• Analyze the long-term solvency.
Analyze asset management rations
TABLE 9.4
Financial Statement for a Small Nonprofit Organization
FY 2006
1. Current ratio Current assets $1,289,762 = 5.19Current liabilities $248,695
2. Working capital Current assets—current liabilities
$1,289,762 minus $248,695 = $1,041,067
3. Quick ratio Quick assets $1,121,492 = 4.51Current liabilities $248,695
4. Debt-to-asset ratio Total liabilities $630,153 = 0.17
5. Days payable ratio All accounts payable × 365 days $73,000,000 = 62.83 days NPS expenses $1,161,884
6. Profit margin ratio Surplus –$2,037 = –0.053%Revenue –$3,822,766
7. Common size ratio Line item amount Contributions $565,032 14.78%
Total amount Grants 1,182,215 30.93
Government contracts 1,459,639 38.18
Fees 529,243 13.84
Interest 86,637 2.27
$3,822,766 100.00%

1. Use the financial statements from Charlottesville, Virginia, to conduct
your own analysis. Two years are provided so that a comparison between
years can be made. Students are advised to use the format in the spread-
sheet in Table 9.4 and add an additional column for FY 2005 so that the
ratios can be compared side by side. (Please note that NPS used in the
days payable ratio is 20 percent of the total expenditures.)
When students compare the ratios, they should focus on measures of
liquidity, long-term solvency, and asset management ratios.

Background image of page 001
CITY OF CHARLOTTESVILLE, VIRGINIA Comprehensive Annual Financial Report Fiscal Year Ended June 30, 2010 Prepared by Department of Finance
Background image of page 002
Show entire document
Sign up to view the entire interaction

Recently Asked Questions

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.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    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