The city of Chapel Hill, North Carolina is concerned about their financial condition. They have hired you to assess their current condition and provide any feedback that you can. They have provided you with a dataset of financial data from the past few years, but the dataset has not been well-maintained, and is sort of a mess.
ChapelHillData.xlsx Download 教堂山数据.xlsx
Work with this dataset to isolate some factors of interest:
Fixed Cost as a Percentage of Total Expenditures (as defined in lecture)
Operating Deficits
Intergovernmental Revenues as a Percentage of Gross Revenues
Calculate these values for all available years of data. For each measure, present the calculated values and discuss any trends that you see in the data over time. Are these values and trends indicators of improving or worsening fiscal condition? Do you have any recommendations for the city? Write up your results as a brief report (1 page) and include a spreadsheet with your calculated values.
