Assignment 5

Main requirement is to build this in EXCEL and provide a short one or two sentence analysis of each ratio.


The assignment worksheet is in the attachement.


Assignment 5: Multiyear Plans and Analysis

Due Week 10 and worth 100 points



  • Review the document titled “City of Charlottesville 2010 Annual Comprehensive Plan” located in the course shell.

Write a three to four (3-4) page paper in which you:

<!–[if !supportLists]–>1.      <!–[endif]–>Review the “City of Charlottesville 2010 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 include the Multiyear Plan.

<!–[if !supportLists]–>2.      <!–[endif]–>Analyze the comparison of ratios.

<!–[if !supportLists]–>3.      <!–[endif]–>Analyze the measures of liquidity.

<!–[if !supportLists]–>4.      <!–[endif]–>Analyze the long-term solvency.

<!–[if !supportLists]–>5.      <!–[endif]–>Analyze asset management rations.


Your assignment must follow these formatting requirements:

  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.



Question 7 is to calcualte the commom size Ration for each line item listed on the paper:


Line Item in the Revenues ledger  amount divided by the total amount of revenue.