| Homework 1 |
| City of Miami General Fund Budget 2008-2016 |
| 2008 Budget | 2016 Budget | 2008-2016 Change |
| $ | % of Total | $ | % of Total | $ Change | % Change |
| Revenues |
| Property Tax | 52,242,954 | 78,519,348 |
| Motor Vehicle Tax | 9,081,400 | 9,408,238 |
| Sales Tax | 117,117,201 | 131,466,507 |
| Restaurant Tax | - 0 | 19,084,888 |
| Business Taxes | 29,634,895 | 33,775,353 |
| Licenses and Permits | 8,800,811 | 8,620,323 |
| Intergovernmental Revenues | 7,757,200 | 4,877,090 |
| Service Charges | 16,955,899 | 19,252,164 |
| Interest and Miscellaneous | 3,182,105 | 3,218,475 |
| Prior Year Fund Balance | 3,764,336 | 3,015,778 |
| TOTAL REVENUES |
| Expenditure Appropriations |
| General Government | 10,683,404 | 12,369,393 |
| Planning | 5,358,880 | 6,972,304 |
| Parks and Recreation | 14,907,520 | 17,688,172 |
| Fire | 63,670,372 | 66,914,984 |
| Police | 87,222,525 | 115,920,343 |
| Public Works | 14,676,418 | 17,322,527 |
| Convention & Tourism | 255,600 | - 0 |
| Library | 7,938,606 | 10,564,133 |
| Other Budgetary Accounts | 43,823,476 | 63,486,308 |
| TOTAL APPROPRIATIONS |
| Notes: |
| General Government includes Mayor, City Council, City Clerk, Law, Human Resources, |
| Human Rights and Relations, and Finance. |
| Other Budgetary Accounts includes Retiree Health Insurance, Workers' Compensation, |
| County Jail, 911, Information Technology Services, Lease Payments, and Misc. |
| Assignment: |
| 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 include $'s and %'s in your discussion, do not talk generally). |
Gus123
HomeworkAssignment1BudgetAnalysis.xlsx
