to be done in excel format

5. Using the information that is listed below, prepare a reve revenue projection for Jefferson City in FY 2018 and FY 2019 te of the changes to the FY 2019 budget are based on FY 2018 Complete each of the FY 2018 estimates, based on FY 2017 actuale beginning the FY 2019 projections. Round all data to the nearest dolla since these are estimates. (See Appendix SE) pare a revenue estimate and FY 2019 respectively. All FY 2018 estimates. Hint FY 2017 actuals, prior to e nearest dollar amount User fees in FY 2018 are expected to increase 5%. In FY 2019 the fee will increase 5% due to an increase in the number of street meters. Franchise fees and permits are expected to increase 2% in FY 2018 and 1% in FY 2019 because of new development near the mall. Property tax collections have been quite stable. A modest 2% increase is expected in FY 2018 and a 3% increase in FY 2019. News alert: The new Kollipara subdivision will be com- pleted in FY 2018. So, property tax receipts should increase an additional 1% in FY 2019 for a total of 4% in FY 2019. Sales tax collections are also expected to increase 4% FY 2018 based on the expanded business sector. It is expected to increase 11% in FY 2019. Utility fees/charges are expected to decrease 5% in FY 2010 and 5% in FY 2019. Storm water management is expected to increase by 5% year. Impact fees remain unchanged. Intergovernmental transfers are expected to increase 4 2018 and 2% in FY 2019. ers are expected to increase 4% in FY 6. Jefferson City constructed a swimming pool in FY 2018 and you 018 and you have been Chapter Five 154 Appendix 5E Jefferson City Revenue Estimate FY 2018-FY 2019 FY 2018 (est.) FY 2019 (mi Items Property Taxes User Fees Franchise Fees Permits Utility Fees Intergovernmental Transfers Sales Taxes Impact Fees Storm Water Mgt. TOTAL FY 2017 (act.) $710,000.00 30,000.00 5,600.00 3,600.00 115,000.00 255,000.00 180,000.00 4,500.00 9.500.00 $1,313,200.00