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

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
   119   120   121   122   123   124   125   126   127   128   129