Property Tax Data Property Tax Actual 1980-2012 Property Tax Revenue 31000 3957607 27277000 Property Tax Data Property Tax Actual 1980-2012 Property Tax Revenue 3.190.000 497691 53822 73181300 2 7474111 750123 11.6161806 13.711.833 2010 2011 2012 DOOR 14.500.000 14,945,770 15.894,445 1. Examine the 'overview of the city document, especially pages 22-27 From those pages, calculate the following: (a) Whether your department ran a surplus or deficit for Years I-V. Calculate the amount of the surplus/deficit for each year and construct a line graph in excel to show this amount. (b) The percentage of your department's surplus/deficit in relation to the entire size of the budget for Year's I-V. To do this, show a calculation for your departmental revenues and the total revenues contained in the budget, and show a calculation for your departmental expenditures and the total expenditures contained in the budget (i.e. see Wang pages 23-24). (c) Your department's per capita ratio in terms of revenues and expenditures. To calculate this, first determine the city's population in Years I-V. Each specific year of population will be the denominator in a division calculation with the numerator being revenues and in a separate calculation, expenditures). You should calculate ten ratios: five ratios for departmental revenues (for Years I-V), and five ratios for your departmental expenditures (for Years I-V). Notes Show your calculations in excel. I should be able to follow all calculations in your excel spreadsheet. You do not have to recreate the entire list of expenditures and revenues in your excel spreadsheet. However, it is probably a good idea to list the expenditures and revenues contained in your department. A few departments will have no revenues to show. That is okay. Report this as a 0 in your calculations. Some departments will have many revenues to show. That is, you will have multiple line items to show and calculate in your excel spreadsheet. G EXPENDITURE DATA ation 1.1.1.1.it L...ll.is.l.si Property Tax Data Property Tax Actual 1980-2012 Property Tax Revenue 31000 3957607 27277000 Property Tax Data Property Tax Actual 1980-2012 Property Tax Revenue 3.190.000 497691 53822 73181300 2 7474111 750123 11.6161806 13.711.833 2010 2011 2012 DOOR 14.500.000 14,945,770 15.894,445 1. Examine the 'overview of the city document, especially pages 22-27 From those pages, calculate the following: (a) Whether your department ran a surplus or deficit for Years I-V. Calculate the amount of the surplus/deficit for each year and construct a line graph in excel to show this amount. (b) The percentage of your department's surplus/deficit in relation to the entire size of the budget for Year's I-V. To do this, show a calculation for your departmental revenues and the total revenues contained in the budget, and show a calculation for your departmental expenditures and the total expenditures contained in the budget (i.e. see Wang pages 23-24). (c) Your department's per capita ratio in terms of revenues and expenditures. To calculate this, first determine the city's population in Years I-V. Each specific year of population will be the denominator in a division calculation with the numerator being revenues and in a separate calculation, expenditures). You should calculate ten ratios: five ratios for departmental revenues (for Years I-V), and five ratios for your departmental expenditures (for Years I-V). Notes Show your calculations in excel. I should be able to follow all calculations in your excel spreadsheet. You do not have to recreate the entire list of expenditures and revenues in your excel spreadsheet. However, it is probably a good idea to list the expenditures and revenues contained in your department. A few departments will have no revenues to show. That is okay. Report this as a 0 in your calculations. Some departments will have many revenues to show. That is, you will have multiple line items to show and calculate in your excel spreadsheet. G EXPENDITURE DATA ation 1.1.1.1.it L...ll.is.l.si