Page 123 - Ord 866 Adopting a revised Fiscal Year 17-18 and new proposed Fiscal Year 18-19 budget

FIVE YEAR FINANCIAL FORECAST
ALL MUNICIPAL FUNDS

ESTIMATED PROPOSED 1 2 3 4
DESCRIPTION FY 17- 18 FY 18- 19 FY 19- 20 FY 20- 21 FY 21- 22 FY 22- 23

INTERNAL SERVICE - M&R FUNDS

FUND 510 - UTILITY MAINT/ REPLACE
Interest Income vision 16, 350 16, 350 14, 500 14, 500 14, 500 14, 500
Transfers In from UF 500 vision 0 5,000 5,000 5,000 5,000 5,000
Total Revenues & Transfers In 16, 350 21, 350 19, 500 19, 500 19, 500 19, 500
Sewer Easement Cleaning Machine vision 0 ( 45, 000) 0 0 0 0
Repaint Ground Storage Tank vision 0 ( 90, 000) 0 0 0 0
Pump Station Equipment vision 0 ( 90, 000) 0 0 0 0
Total Expenditures & Transfers Out 0 ( 225, 000) 0 0 0 0
NET CHANGE TO FUND BALANCE 16, 350 ( 203, 650) 19, 500 19, 500 19, 500 19, 500
Beginning Fund Balance 829, 333 845, 683 642, 033 661, 533 681, 033 700, 533
Ending Fund Balance 845, 683 642, 033 661, 533 681, 033 700, 533 720, 033
Restricted/ Committed/ Assigned 845, 683 642, 033 661, 533 681, 033 700, 533 720, 033
Unassigned Ending Balance ( projected) 0 0 0 0 0 0

FUND 600 - GENERAL MAINT/ REPLACEMENT
Firefighter Equipment Fees tied to vision 6,000 6,000 6,000 6,000 6,000 6,000
Interest Income tied to vision 2,290 2,290 2,165 2,165 2,165 2,165
WA Keller Police Sub- Station tied to vision 25, 000 0 0 0 0 0
Transfer in from GF tied to vision 387, 750 1,000, 799 579, 537 498, 660 447, 350 447, 350
Total Revenues & Transfers In 421, 040 1, 009, 089 587, 702 506, 825 455, 515 455, 515
WA- Irrigation System tied to vision ( 6,500)( 6,500)( 15,000)( 5,000)( 5,000)( 5,000)
WA- 15 Ton Split HVAC System tied to vision ( 6,500)( 14, 000)( 10, 000)( 25, 000)( 25, 000)( 25, 000)
WA- 2 Ton Roof Top Units tied to vision ( 7,500)( 7,500)( 15,000)( 10,000)( 10,000)( 10,000)
WA- AC ton/ 7.5 ton server room tied to vision ( 6,500)( 6,500) 0 ( 20, 000)( 20, 000)( 20, 000)
WA- HVAC System Replacement tied to vision ( 7,500)( 7,500) 0 ( 5,000)( 5,000)( 5,000)
WA- Update Security System tied to vision ( 2,750)( 2,750)( 5,000)( 8,000)( 8,000)( 8,000)
WA- Update Security Cameras tied to vision ( 10,300)( 10,300)( 2,000)( 12,000)( 12,000)( 12,000)
WA- Heater Boilers tied to vision ( 9,675)( 9,675) 0 ( 25, 000)( 25, 000)( 25, 000)
WA- Painting/ Cloth Wall R& M tied to vision ( 6,500)( 6,500)( 10,000)( 8,000)( 8,000)( 8,000)
WA- Ext Envrnmt Imprvmts Irrig tied to vision ( 7,500)( 7,500) 0 ( 12, 000)( 12, 000)( 12, 000)
WA- Parking Lot tied to vision 0 ( 25,000) 0 0 0 0
WA Playground Equipment tied to vision 0 ( 5,000) 0 0 0 0
WA- Plumbing Repair/ Replacement tied to vision ( 2,775)( 9,000)( 15,000)( 5,000)( 5,000)( 5,000)
WA- Carpet/ VCT Flooring tied to vision ( 25, 000)( 35, 000)( 15, 000)( 15, 000)( 15, 000)( 15, 000)
WA- Envrnmt Bldg UG light/ water tied to vision ( 2,750)( 10,000) 0 ( 5,000)( 5,000)( 5,000)
WA- Refurbish Classrooms tied to vision ( 21, 000)( 30, 000)( 35, 000)( 25, 000)( 25, 000)( 25, 000)
WA- Interior Building R& M tied to vision ( 5,500)( 15,000)( 10,000)( 15,000)( 15,000)( 15,000)
WA- Exterior Paint & Wood R& M tied to vision ( 4,500)( 4,500)( 4,000)( 8,000)( 8,000)( 8,000)
WA- Roof Repairs tied to vision ( 47,550)( 47,550)( 15,000)( 5,000)( 5,000)( 5,000)
WA- Mechanical Equipment tied to vision 0 ( 25, 000) 0 0 0 0
WA- Furniture/ Interior Bldg tied to vision ( 7,000)( 15,000) 0 0 0 0
WA- Keller Police Substation tied to vision ( 25, 000) 0 0 0 0 0
Dept 17 - Westlake Academy Facilities ( 212, 300)( 299, 775)( 151, 000)( 208, 000)( 208, 000)( 208, 000)
Trail Repairs and Maintenance tied to vision 0 ( 10,000)( 10,000)( 10,000)( 10,000)( 10,000)
Park Repairs and Maintenance tied to vision 0 ( 10, 000)( 10, 000)( 10, 000)( 10, 000)( 10, 000)
Dept 19 - Town Parks 0 ( 20,000)( 20,000)( 20,000)( 20,000)( 20,000)
Servers & Network Storage tied to vision ( 15,000)( 40,000)( 15,000)( 15,000)( 15,000)( 15,000)
Network Printers/ Peripheal Dev tied to vision ( 5,000)( 5,000)( 5,000)( 5,000)( 5,000)( 5,000)
Network Equipment tied to vision 0 ( 115, 000)( 25,000)( 25,000)( 25,000)( 25,000)
Server Replacements tied to vision ( 5,000)( 20, 000)( 12, 500)( 100, 000)( 12, 500)( 12, 500)
Phone System/ Peripheal Devices tied to vision ( 5,000)( 65,000)( 10,000)( 10,000)( 10,000)( 10,000)
Dept 20 - Town IT Dept ( 30, 000)( 245, 000)( 67, 500)( 155, 000)( 67, 500)( 67, 500)

109