Page 136 - City of Westlake FY20 Budget
P. 136

FIVE YEAR FINANCIAL FORECAST

        ALL MUNICIPAL FUNDS

                                                                            Revision 06
                                                        ADOPTED   ESTIMATED    ADOPTED    Projected    Projected    Projected    Projected
                                                        FY 18‐19   FY 18‐19    FY 19‐20    FY 20‐21    FY 21‐22    FY 22‐23    FY 23‐24
      #
      #        INTERNAL SERVICE ‐ M&R FUNDS
      #
      #
      #
      #
      #  FUND 505 ‐ UF VEHICLE MAINTENANCE/REPLACEMENT FUND
      #
      #
      # Interest Earned                        tied to vision  $                  350  $                  1,940  $                 1,940  $                   350  $                  350  $                   350  $                   350
      # Transfer in from GF                    tied to vision                       ‐                           ‐                      5,000                    5,000                   5,000                    5,000                    5,000
      # Transfer in from UF                    tied to vision                 10,000                    10,000                   10,000                    5,000                   5,000                    5,000                    5,000
      # TOTAL REVENUES                                               10,350                    11,940                   16,940                   10,350                 10,350                  10,350                  10,350
      #
      # Public Works Vehicle                   tied to vision                       ‐                           ‐                  (50,000)                         ‐                        ‐                         ‐                         ‐
      # TOTAL EXPENDITURES                                                     ‐                               ‐                   (50,000)                           ‐                            ‐                             ‐                             ‐
      #
      # NET CHANGE TO FUND BALANCE                                   10,350                    11,940                  (33,060)                  10,350                 10,350                  10,350                  10,350
      # Beginning Fund Balance                                        23,674                    23,759                   35,699                    2,639                 12,989                  23,339                  33,689
      # Ending Fund Balance                                          34,024                    35,699                     2,639                  12,989                 23,339                  33,689                  44,039
      # Restricted/Committed/Assigned                                 34,024                    35,699                      2,639                  12,989                 23,339                  33,689                  44,039
      # Unassigned Ending Balance                        $                    ‐     $                       ‐     $                       ‐      $                     ‐     $                    ‐     $                     ‐     $                     ‐
      #
      #
      #
      #
      #
      #  FUND 510 ‐ UTILITY MAINTENANCE/REPLACEMENT FUND
      #
      #
      # Interest Income                            vision  $            16,350  $                31,895  $               31,895  $              14,500 $             14,500 $              14,500  $              14,500
      # Transfers In from UF 500                   vision                   5,000                      5,000                      5,000                    5,000                   5,000                    5,000                    5,000
      # TOTAL REVENUES                                               21,350                    36,895                   36,895                   19,500                 19,500                  19,500                  19,500
      #
      # Sewer Easement Cleaning Machine            vision               (45,000)                          ‐                  (67,000)                         ‐                        ‐                         ‐                         ‐
      # Repaint Ground Storage Tank                vision               (90,000)               (276,200)                          ‐                         ‐                        ‐                         ‐                         ‐
      # Lift Station Pump Repairs                  vision                       ‐                           ‐                  (25,000)                         ‐                        ‐                         ‐                         ‐
      # Pump Station Equipment                     vision               (90,000)                          ‐                  (90,000)                         ‐                        ‐                         ‐                         ‐
      # TOTAL EXPENDITURES                                       (225,000)               (276,200)              (182,000)                           ‐                            ‐                             ‐                             ‐
      #
      # NET CHANGE TO FUND BALANCE                                (203,650)               (239,305)               (145,105)                  19,500                 19,500                  19,500                  19,500
      # Beginning Fund Balance                                     845,683                  778,190                 538,885                393,780              413,280               432,780                452,280
      # Ending Fund Balance                                        642,033                 538,885                 393,780                413,280              432,780               452,280               471,780
      # Restricted/Committed/Assigned                              642,033                  538,885                 393,780                413,280              432,780               452,280                471,780
      # Unassigned Ending Balance                        $                    ‐     $                       ‐     $                       ‐      $                     ‐     $                    ‐     $                     ‐     $                     ‐
      #
      #
      #
      #
      #
      #  FUND 600 ‐ GENERAL MAINTENANCE/REPLACEMENT FUND
      #
      #
      # Firefighter Equipment Fees  Dept 14    tied to vision  $               6,000  $                  6,000  $                 6,000  $                6,000  $               6,000  $                6,000  $                6,000
      # Interest Income           Dept 00      tied to vision                   2,290                      3,424                      3,424                    3,424                   3,424                    3,424                    3,424
      # Misc Revenue              Dept 00      tied to vision                       ‐                      1,980                          ‐                         ‐                        ‐                         ‐                         ‐
      # Sale of Surplus           Dept 00      tied to vision                       ‐                      2,545                          ‐                         ‐                        ‐                         ‐                         ‐
      # Transfer in from GF       Dept 88      tied to vision           1,000,799              1,463,799                 229,185                500,000              400,000               400,000                400,000
      # WA Facilities Allotment 50%  Dept 17                                ‐                    90,194                          ‐                         ‐                        ‐                         ‐                         ‐
      # TOTAL REVENUES                                          1,009,089              1,567,942                 238,609                509,424              409,424               409,424               409,424
      #
      # WA‐Irrigation System                   tied to vision                  (6,500)                    (6,500)                  (15,000)                   (5,000)                 (5,000)                  (5,000)                  (5,000)
      # WA‐15 Ton Split HVAC System            tied to vision               (14,000)                  (14,000)                  (10,000)                 (25,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)                (10,000)
      # WA‐AC ton/7.5 ton server room          tied to vision                  (6,500)                    (6,500)                    (1,500)                 (20,000)                       ‐                   (5,000)                  (5,000)
      # WA‐HVAC System Replacement             tied to vision                  (7,500)                    (7,500)                    (8,000)                   (5,000)                 (5,000)                  (5,000)                  (5,000)
      # WA‐Update Security System              tied to vision                  (2,750)                    (2,750)                  (20,000)                 (10,000)                 (8,000)                  (8,000)                  (8,000)
      # WA‐Update Security Cameras             tied to vision               (10,300)                  (10,300)                    (5,000)                 (12,000)               (12,000)                (12,000)                (12,000)
      # WA‐Heater Boilers                      tied to vision                  (9,675)                    (9,675)                    (3,000)                   (5,000)               (25,000)                  (5,000)                (25,000)
      # WA‐Painting/Cloth Wall R&M             tied to vision                  (6,500)                    (6,500)                  (10,000)                   (8,000)                 (8,000)                  (8,000)                  (8,000)
      # WA‐Ext Envrnmt Imprvmts Irrig          tied to vision                  (7,500)                    (7,500)                  (15,000)                 (12,000)               (12,000)                (12,000)                (12,000)
      # WA‐Parking Lot                         tied to vision               (25,000)                  (25,000)                  (25,000)                   (5,000)                 (5,000)                  (5,000)                  (5,000)



                                                             124
   131   132   133   134   135   136   137   138   139   140   141