Question
Assignment Erewhons City Administrator needs revenue forecasts for the upcoming budget. The attached Excel file supplies actual historical data. Additionally, it provides an estimate for
Assignment
Erewhons City Administrator needs revenue forecasts for the upcoming budget. The attached Excel file supplies actual historical data. Additionally, it provides an estimate for the current fiscal year based on year to date actuals. Other factors that are likely to influence the upcoming fiscal year listed below.
(1) study the background provided here and provide estimates for next fiscal year in the spreadsheet provided, and (2) briefly summarize the key calculations and assumptions you made in the space provided on the spreadsheet.
Supporting Information
- Over the past 20 years, actual property taxes have increased by an average of 8% per year except for 2019, 2020 and the 2021 estimate. During 2019 and 2020 major industrial development and higher than usual housing construction were added to the tax base.
- The State in which Erewhon City is located forecasts a statewide sales tax increase of 4.7% for 2022. However, the City typically trails the State by about 0.5%.
- Transient occupancy taxes have averaged a modest 4% increase over the past 20 years with the exception of 2015 and 2016. In early 2015 there was a large flood that took out three hotels and spoiled two summer recreations seasons. The hotels have been rebuilt.
- Business license fees have grown at the rate of 2.1% over the last 20 years. However, the City Council increased the fee by 17.5% in 2018 to capture the cost of personnel associated with regulating and monitoring businesses.
- Building permit revenue fluctuates with the economy but historically averages an increase of 3.9% per year.
- The City installed parking meters in the central business district for the first time in 2019.
- The City maintains various reserves and cash balance accounts totaling an average of about $30 million. These funds are invested in money market accounts and 30-90-day secure investments. Over the last 20 years returns have averaged 3.2%.
- The Citys first beer garden was established in 2020 and generated $3,500 in net concession revenue. The City Council has authorized the establishment of a second beer garden in 2022 near Erewhon University.
- State shared revenue has grown by an average of 2.5% per year over the past twenty years with the exception of 2017 when the State legislature reduced it by 50% in response to budgetary pressures.
- Dante Village is small, but rapidly growing community adjacent to Erewhon City and began contracting for fire protection with the City in 2020. Dante Village would like to increase service levels by 50% in 2022.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started