# 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

Preparation

• 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.

• 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.

##### Looking for a Similar Assignment? Our Experts can help. Use the coupon code SAVE30 to get your first order at 30% off!

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp