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.
Need help with writing Assignment 5?Get help