Page 124 - 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
Town- Irrigation R& M tied to vision 0 ( 5,000)( 5,000)( 5,000)( 5,000)( 5,000)
Town- HVAC System Replacement tied to vision 0 ( 5,000)( 5,000)( 5,000)( 5,000)( 5,000)
Town- Heater tied to vision 0 ( 3,000)( 3,000)( 3,000)( 3,000)( 3,000)
Town- Parking Lot tied to vision 0 ( 4,000)( 4,000)( 4,000)( 4,000)( 4,000)
Town- Env Bldg UG light/ water tied to vision 0 ( 10, 000)( 10, 000)( 10, 000)( 10, 000)( 10, 000)
Town- Furniture/ Interior Bldg tied to vision ( 36, 325)( 2,700) 0 0 0 0
Dept 26 - Town Facilities ( Fire Station)( 36, 325)( 29, 700)( 27, 000)( 27, 000)( 27, 000)( 27, 000)
Total Expenditures ( 278, 625)( 594, 475)( 265, 500)( 410, 000)( 322, 500)( 322, 500)

NET CHANGE TO FUND BALANCE 142, 415 414, 614 322, 202 96, 825 133, 015 133, 015
Beginning Fund Balance ( 19, 621) 122, 794 537, 408 859, 610 956, 435 1,089, 450
Ending Fund Balance 122, 794 537, 408 859, 610 956, 435 1,089, 450 1,222, 465
Restricted/ Committed/ Assigned 122, 794 537, 408 859, 610 956, 435 1,089, 450 1,222, 465
Unassigned Ending Balance 0 0 0 0 0 0

FUND 505 - UF VEHICLE MAINT / REPLACEMENT
Interest Earned tied to vision 350 350 350 350 350 350
Transfer in from UF tied to vision 6,250 10, 000 10, 000 10, 000 10, 000 10, 000
Total Revenues & Transfers In 6, 600 10, 350 10, 350 10, 350 10, 350 10, 350
Public Works Vehicle tied to vision 0 0 0 ( 50, 000) 0 0
Total Expenditures & Transfers Out 0 0 0 ( 50, 000) 0 0
NET CHANGE TO FUND BALANCE 6,600 10, 350 10, 350 ( 39, 650) 10, 350 10, 350
Beginning Fund Balance 17, 074 23, 674 34, 024 44, 374 4,724 15, 074
Ending Fund Balance 23, 674 34, 024 44, 374 4,724 15, 074 25, 424
Restricted/ Committed/ Assigned 23,674 34,024 44,374 4,724 15,074 25,424
Unassigned Ending Balance 0 0 0 0 0 0

FUND 605 - GF VEHICLE MAINT/ REPLACEMENT
Contribution for WA Buses dept 10 tied to vision 105, 000 0 150, 000 0 0 0
Interest Earned dept 10 tied to vision 2,490 2,490 2,450 2,450 2,450 2,450
Transfer In from GF dept 88 tied to vision 350, 000 460, 266 579, 537 498, 662 447, 350 447, 350
Total Revenues & Transfers In 457, 490 462, 756 731, 987 501, 112 449, 800 449, 800
Academy Buses dept 10 tied to vision ( 105, 000) 0 ( 150, 000) 0 0 0
Fire Dept Vehicles dept 14 tied to vision 0 0 0 0 ( 60,000)( 1,000, 000)
Fire Dept Vehicles - Ambulance dept 14 tied to vision 0 ( 260, 000) 0 0 0 0
Facilities Vehicles dept 17 tied to vision 0 0 0 ( 50,000) 0 0
Total Expenditures & Transfers Out ( 105, 000)( 260, 000)( 150, 000)( 50, 000)( 60, 000)( 1,000, 000)
NET CHANGE TO FUND BALANCE 352, 490 202, 756 581, 987 451, 112 389, 800 ( 550, 200)
Beginning Fund Balance 226, 358 578, 848 781, 604 1,363, 591 1,814, 703 2,204, 503
Ending Fund Balance 578, 848 781, 604 1,363, 591 1,814, 703 2,204, 503 1,654, 303
Restricted/ Committed/ Assigned 578, 848 781, 604 1,363, 591 1,814, 703 2,204, 503 1,654, 303
Unassigned Ending Balance 0 0 0 0 0 0

110