Page 119 - Ord 866 Adopting a revised Fiscal Year 17-18 and new proposed Fiscal Year 18-19 budget
P. 119
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
Planning & Development dept 12 0% 0 ( 490)( 490)( 490)( 490)( 490)
Fire Department dept 14 0%( 20, 495)( 27, 900)( 27, 900)( 27, 900)( 27, 900)( 27, 900)
Public Works dept 16 0% 0 ( 5,000)( 5,000)( 5,000)( 5,000)( 5,000)
Finance Department dept 18 0%( 900)( 1,800)( 1,800)( 1,800)( 1,800)( 1,800)
Parks & Recreations dept 19 0%( 520)( 520)( 520)( 520)( 520)( 520)
Total Capital Outlay ( 21, 915)( 35, 710)( 35, 710)( 35, 710)( 35, 710)( 35, 710)
Transfer Out - GMR Fund 600 linked to GMR ( 387, 750)( 1,000, 799)( 579, 537)( 498, 660)( 447, 350)( 447, 350)
Transfer Out - VMR Fund 605 linked to VMR ( 350, 000)( 460, 266)( 579, 537)( 498, 662)( 447, 350)( 447, 350)
Transfer Out - CP Fund 410 linked to CIP ( 300, 000)( 1,025, 000) 0 0 0 0
Total Non- Operating Transfers Out ( 1,037, 750)( 2,486, 065)( 1,159, 074)( 997, 322)( 894, 700)( 894, 700)
TOTAL NON- OPERATING EXPENDITURES ( 1, 059, 665) $ ( 2, 521, 775)( 1,194, 784)( 1,033, 032)( 930, 410)( 930, 410)
one times from fee tab 1,337, 276 3,550, 808 1,224, 138 1,115, 138 967, 701 967, 701
no xfrs from above 1,037, 750 2,486, 065 1,159, 074 997, 322 894, 700 894, 700
Left in General Fund 299, 526 1,064, 743 65, 064 117, 816 73, 001 73, 001
TOTAL PAYROLL, OPERATIONS, MAINTENANCE & NON- OPERATING EXPENDITURES ( 10, 330, 613) $ ( 12, 064, 992)( 11, 130, 004)( 11, 055, 456)( 11, 087, 180)( 11, 256, 827)
NET CHANGE TO FUND BALANCE ( 1,025, 667) 248, 618 ( 1,548, 677)( 1,288, 910)( 940, 672)( 849, 769)
Beginning Fund Balance 10, 242, 277 9,216, 610 9,465, 228 7,916, 551 6,627, 641 5,686, 969
Ending Fund Balance 9,216, 610 9,465, 228 7,916, 551 6,627, 641 5,686, 969 4,837, 200
Restricted/ Committed/ Assigned 304, 505 304, 504 304, 504 304, 504 304, 504 304, 504
Unassigned Ending Balance 8,912, 105 9,160, 724 7,612, 047 6,323, 137 5,382, 465 4,532, 696
Operating Expenditures 9,270, 948 9,543, 216 9,935, 220 10, 022, 424 10, 156, 770 10, 326, 417
Operating Cost per Day 25, 400 26, 146 27, 220 27, 459 27, 827 28, 292
OPERATING DAYS 351 350 280 230 193 160
105