Page 137 - City of Westlake FY20 Budget
P. 137

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
      # WA Playground Equipment                tied to vision                  (5,000)                          ‐                    (5,000)                         ‐                  (5,000)                        ‐                 (40,000)
      # WA‐Plumbing Repair/Replacement         tied to vision                  (9,000)                    (9,000)                    (8,000)                   (5,000)                 (5,000)                  (5,000)                  (5,000)
      # WA‐Carpet/VCT Flooring                 tied to vision               (35,000)                  (35,000)                  (30,000)                 (15,000)               (15,000)                (15,000)                (15,000)
      # WA‐Envrnmt Bldg UG light/water         tied to vision               (10,000)                  (10,000)                    (8,000)                   (5,000)                 (5,000)                  (5,000)                  (5,000)
      # WA‐Refurbish Classrooms                tied to vision               (30,000)                  (30,000)                  (30,000)                 (25,000)               (25,000)                (25,000)                (25,000)
      # WA‐Interior Building R&M               tied to vision               (15,000)                  (15,000)                  (10,000)                 (15,000)               (15,000)                (15,000)                (15,000)
      # WA‐Exterior Paint & Wood R&M           tied to vision                  (4,500)                    (4,500)                  (12,000)                   (8,000)                 (8,000)                  (8,000)                  (8,000)
      # WA‐Roof Repairs                        tied to vision               (47,550)                  (47,550)                  (60,000)                 (30,000)               (25,000)                (25,000)                (25,000)
      # WA Facilities Allotment                tied to vision                       ‐                   (90,194)                          ‐                         ‐                        ‐                         ‐                         ‐
      # WA‐Mechanical Equipment                tied to vision               (25,000)                  (25,000)                          ‐                         ‐                        ‐                         ‐                         ‐
      # WA‐Furniture/Interior Bldg             tied to vision               (15,000)                    (7,500)                    (8,000)                 (10,000)               (10,000)                (10,000)                (10,000)
      # Dept 17 ‐ Westlake Academy Facilities                     (299,775)               (377,469)               (298,500)              (230,000)            (228,000)             (208,000)             (268,000)
      #
      # Trail Repairs and Maintenance          tied to vision               (10,000)                  (10,000)                  (30,000)                 (10,000)               (30,000)                (10,000)                (10,000)
      # Park Repairs and Maintenance           tied to vision               (10,000)                  (10,000)                  (33,029)                 (15,000)               (33,029)                (10,000)                (10,000)
      # Dept 19 ‐ Town Parks                                        (20,000)                 (20,000)                  (63,029)                (25,000)              (63,029)               (20,000)               (20,000)
      #
      # Servers & Network Storage              tied to vision               (40,000)                  (40,000)                  (40,000)                 (30,000)               (30,000)                (30,000)                (30,000)
      # Network Printers/Peripheal Dev         tied to vision                  (5,000)                    (5,000)                    (5,000)                   (5,000)                 (5,000)                  (5,000)                  (5,000)
      # Network Equipment                      tied to vision             (115,000)               (115,000)                  (25,000)                 (25,000)               (25,000)                (25,000)             (150,000)
      # Server Replacements                    tied to vision               (20,000)                  (20,000)                  (20,000)              (125,000)               (20,000)                (20,000)                (20,000)
      # Phone System/Peripheal Devices         tied to vision               (65,000)                  (65,000)                (100,000)                 (15,000)               (15,000)                (15,000)                (65,000)
      # Dept 20 ‐ Town IT Dept                                    (245,000)               (245,000)               (190,000)              (200,000)              (95,000)               (95,000)             (270,000)
      #
      # Town‐Irrigation R&M                    tied to vision                  (5,000)                    (5,000)                    (5,000)                   (5,000)                 (5,000)                  (5,000)                  (5,000)
      # Town Open Space Improvements           tied to vision                       ‐                           ‐                    (8,000)                 (20,000)                 (1,000)                  (8,000)                (10,000)
      # Town‐15 Ton Split HVAC System          tied to vision                       ‐                           ‐                          ‐                 (30,000)                 (5,000)                  (3,000)                  (3,000)
      # Town‐2 Ton Roof Top Units              tied to vision                       ‐                           ‐                    (3,000)                   (5,000)                 (5,000)                  (3,000)                  (3,000)
      # Town‐AC ton/7.5 ton server roo         tied to vision                       ‐                           ‐                    (3,000)                   (3,000)                 (8,000)                        ‐                   (3,000)
      # Town‐HVAC System Replacement           tied to vision                  (5,000)                    (5,000)                          ‐                   (5,000)                 (5,000)                  (5,000)                  (5,000)
      # Town‐Contract Landscaping              tied to vision                       ‐                           ‐                          ‐                   (5,000)                 (8,000)                  (3,000)                  (3,000)
      # Town‐Security System                   tied to vision                       ‐                           ‐                    (3,000)                   (5,000)                 (5,000)                (10,000)                  (5,000)
      # Town‐Security Cameras                  tied to vision                       ‐                           ‐                    (3,000)                   (5,000)               (12,000)                  (5,000)                  (5,000)
      # Town‐Safety Doors                      tied to vision                       ‐                           ‐                    (8,000)                   (8,000)               (10,000)                  (8,000)                (10,000)
      # Town‐Ground R&M                        tied to vision                       ‐                           ‐                    (4,000)                   (4,000)               (10,000)                  (5,000)                  (6,000)
      # Town‐Heater Boiler                     tied to vision                  (3,000)                    (3,000)                          ‐                   (3,000)                 (3,000)                  (3,000)                  (3,000)
      # Town‐Painting/Cloth Wall R&M           tied to vision                       ‐                           ‐                    (4,000)                   (4,000)               (10,000)                  (5,000)                  (6,000)
      # Town‐Signs and Signals                 tied to vision                       ‐                           ‐                    (4,000)                   (4,000)                 (4,000)                  (6,000)                  (6,000)
      # Town‐Environmental Improvement         tied to vision                       ‐                           ‐                          ‐                   (4,000)                       ‐                   (5,000)                        ‐
      # Town‐Parking Lot                       tied to vision                  (4,000)                    (4,000)                    (4,000)                   (4,000)                 (4,000)                  (4,000)                  (4,000)
      # Town‐Plumbing Repair/Replace           tied to vision                       ‐                           ‐                    (1,000)                   (2,000)                 (2,000)                  (2,000)                  (2,000)
      # Town‐Carpet/Flooring R&M               tied to vision                       ‐                           ‐                          ‐                         ‐                        ‐                   (5,000)                        ‐
      # Town‐Env Bldg UG light/water           tied to vision               (10,000)                  (10,000)                    (1,000)                 (10,000)               (10,000)                (10,000)                (10,000)
      # Town‐Interior Building R&M             tied to vision                       ‐                           ‐                    (5,000)                   (5,000)               (10,000)                  (5,000)                  (5,000)
      # Town‐Bldg Exterior Paint/R&M           tied to vision                       ‐                           ‐                          ‐                   (5,000)                 (5,000)                (10,000)                  (5,000)
      # Town‐Roof Repairs                      tied to vision                       ‐                           ‐                          ‐                   (6,000)                 (6,000)                  (6,000)                  (6,000)
      # Town‐Furniture/Interior Bldg           tied to vision                  (2,700)                  (10,200)                  (10,200)                   (3,000)                 (5,000)                  (3,000)                  (5,000)
      # Dept 26 ‐ Town Facilities (Fire Station)                    (29,700)                 (37,200)                  (66,200)              (145,000)            (133,000)             (119,000)             (110,000)
      #
      # TOTAL EXPENDITURES                                       (594,475)               (679,669)              (617,729)              (600,000)            (519,029)             (442,000)             (668,000)
      #
      #
      # NET CHANGE TO FUND BALANCE                                 414,614                 888,273               (379,120)                (90,576)            (109,605)               (32,576)             (258,576)
      # Beginning Fund Balance                                     122,794                  157,098              1,045,371                666,251               575,675               466,070                433,494
      # Ending Fund Balance                                        537,408              1,045,371                 666,251                575,675              466,070               433,494               174,918
      # Restricted/Committed/Assigned                              537,408              1,045,371                 666,251                575,675              466,070               433,494                174,918
      # Unassigned Ending Balance                        $                    ‐     $                       ‐     $                       ‐      $                     ‐     $                    ‐     $                     ‐     $                     ‐
      #
      #
      #
      #















                                                             125
   132   133   134   135   136   137   138   139   140   141   142