Question: 1. Calculate total revenues and expenditures for each year.
2. Calculate each revenue source and expenditure category as a percentage of the total budget for each year (for example, property tax for 2008 = 52,242,954/total revenue * 100).
3. Calculate the amount change from 2008 to 2016 for each revenue source and expenditure, and for total revenues and expenditures (=2008 amount - 2016 amount).
4. Calculate the % change from 2008 to 2016 for each revenue source and expenditure, and for total revenues and expenditures (= amount change/2008 amount * 100).
5. Write a brief analysis (two-three paragraphs). This should include the total amount of the budget, how much it has changed over time, the major revenue sources and which have experienced the greatest change, the major expenditure categories and which have experienced the most change (be sure to includes $s and %'s in your discussion, do not talk generally).
Information related to above question is enclosed below:
Attachment:- HomeworkAssignment1BudgetAnalysis.rar