to be done in Excel

5. Using the information that is listed below, prepare a revenue estimate and revenue projection for Jefferson City in FY 2018 and FY 2019 respectively. Al of the changes to the FY 2019 budget are based on FY 2018 estimates Hit Complete each of the FY 2018 estimates, based on FY 2017 actuals, prior to beginning the FY 2019 projections. Round all data to the nearest dollar amount since these are estimates. (See Appendix 5E) 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 201 8. 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 2018 and 5% in FY 2019. Storm water management is expected to increase by 5% each year. Impact fees remain unchanged. Intergovernmental transfers are expected to increase 4% in FY 2018 and 2% in FY 2019. Funding State and Local Budgets Appendix 5A 151 Property Tax Estimate Walters Subdivision Jefferson City FY 2018 Number Individual Assessed Millage Total Est Value of Units Unit Value Items Two BR on 5 Acres Two BR on 20 Acres Rate Tax 12% 15 $80,000.00 15 85,000.00 12% Three BR on 75 Acres Four BR on 20 Acres 60 210,000.00 12% 15 170,000.00 12% 12% 1 85,000.00 Green Space and Park 12% 101 Total Millage Rate Jefferson City FY 2018 1372 Millage Tax Assessed Value $525,000.00 475,000.00 METR Market Value $625,000.00 575,000.00 Est Rate Business 4.0% Franklin's Clothing 4.0% Payton's Tax Service Stacie's Lawn Care 4.0% 175,000.00 285,000.00 4.0% 325,000.00 Eva's Finishing School Tiffany's Day Care Yiesha's Hair Care 400,000.00 4.0% 175,000.00 250,000.00 4.0% 300,000.00 370,000.00 4.0% 575.000.00 Myron's Boys Club TOTAL 650.000.00 $3,155,000.00 $2,550,000.00 5. Using the information that is listed below, prepare a revenue estimate and revenue projection for Jefferson City in FY 2018 and FY 2019 respectively. Al of the changes to the FY 2019 budget are based on FY 2018 estimates Hit Complete each of the FY 2018 estimates, based on FY 2017 actuals, prior to beginning the FY 2019 projections. Round all data to the nearest dollar amount since these are estimates. (See Appendix 5E) 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 201 8. 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 2018 and 5% in FY 2019. Storm water management is expected to increase by 5% each year. Impact fees remain unchanged. Intergovernmental transfers are expected to increase 4% in FY 2018 and 2% in FY 2019. Funding State and Local Budgets Appendix 5A 151 Property Tax Estimate Walters Subdivision Jefferson City FY 2018 Number Individual Assessed Millage Total Est Value of Units Unit Value Items Two BR on 5 Acres Two BR on 20 Acres Rate Tax 12% 15 $80,000.00 15 85,000.00 12% Three BR on 75 Acres Four BR on 20 Acres 60 210,000.00 12% 15 170,000.00 12% 12% 1 85,000.00 Green Space and Park 12% 101 Total Millage Rate Jefferson City FY 2018 1372 Millage Tax Assessed Value $525,000.00 475,000.00 METR Market Value $625,000.00 575,000.00 Est Rate Business 4.0% Franklin's Clothing 4.0% Payton's Tax Service Stacie's Lawn Care 4.0% 175,000.00 285,000.00 4.0% 325,000.00 Eva's Finishing School Tiffany's Day Care Yiesha's Hair Care 400,000.00 4.0% 175,000.00 250,000.00 4.0% 300,000.00 370,000.00 4.0% 575.000.00 Myron's Boys Club TOTAL 650.000.00 $3,155,000.00 $2,550,000.00