Page 145 - City of Westlake FY20 Budget
P. 145

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
      # FM1938 Pavement Repairs                                      (80,000)                          ‐                  (80,000)                         ‐                        ‐                         ‐                         ‐
      # SH 114 Service Rd Construction                                       ‐                   (48,000)                  (96,000)                         ‐                        ‐                         ‐                         ‐
      # GPS Opticom Traffic Control                                          ‐                           ‐                          ‐                 (70,000)                       ‐                         ‐                         ‐
      # ROAD and STREET IMPROVEMENTS           DEPT 16         (1,210,535)               (357,180)           (1,208,672)          (1,185,640)              (55,000)                           ‐                             ‐
      #
      # WA ‐ Pond Repairs                                            (82,000)                  (82,000)                          ‐                         ‐                        ‐                         ‐                         ‐
      # Maintenance and Storage Facility                                     ‐                     (5,000)                  (95,000)                         ‐                        ‐                         ‐                         ‐
      # FACILITY and GROUND IMPROVEMENTS       DEPT 17              (82,000)                 (87,000)                (95,000)                           ‐                            ‐                             ‐                             ‐
      #
      # Trail Connection at 114 & Solana                            (30,000)                          ‐                (193,860)                         ‐                        ‐                         ‐                         ‐
      # Trail ‐ Westlake Academy to Cemetery                                ‐                           ‐                          ‐              (319,006)                       ‐                         ‐                         ‐
      # Trail ‐ Dove/Pearson/Aspen                                (290,016)                          ‐                (313,217)                         ‐                        ‐                         ‐                         ‐
      # Wayfinding Signage                                        (229,500)                          ‐                (300,000)              (290,000)                       ‐                         ‐                         ‐
      # Cemetary Improvements                                        (50,000)                  (56,918)                          ‐                         ‐                        ‐                         ‐                         ‐
      # PARKS/TRAIL/CEMETERY IMPROVEMENTS      DEPT 19            (599,516)                 (56,918)              (807,077)              (609,006)                          ‐                             ‐                             ‐
      #
      # Cash (Fund Balance)                                                 ‐                           ‐                          ‐                         ‐                        ‐                         ‐                         ‐
      # Fiber Connectivity between Buildings                      (300,000)                  (25,000)                (275,000)                         ‐                        ‐                         ‐                         ‐
      # INFORMATION TECHNOLOGY IMPROVEMENTS                      (300,000)                 (25,000)              (275,000)                           ‐                            ‐                             ‐                             ‐
      #
      # TOTAL REVENUES AND TRANSFERS IN                         4,450,134              1,073,505                 939,865            2,054,351              381,545               335,105               335,105
      # TOTAL EXPENDITURES AND TRANSFERS OUT                  (2,192,051)               (526,098)            (2,385,749)           (1,794,646)              (55,000)                       ‐                        ‐
      # NET CHANGE TO FUND BALANCE                              2,258,083                 547,407            (1,445,884)                259,705              326,545               335,105               335,105
      # Beginning Fund Balance                                  1,590,074              1,976,880              2,524,287            1,078,403           1,338,108            1,664,653            1,999,758
      # Ending Fund Balance                                     3,848,157              2,524,287             1,078,403            1,338,108           1,664,653            1,999,758            2,334,863
      # Restricted/Committed/Assigned  Contributions/Grants/Bonds           3,848,157              2,524,287              1,078,403            1,338,108           1,664,653            1,999,758            2,334,863
      # Unassigned Ending Balance                        $                    ‐     $                       ‐     $                       ‐      $                     ‐     $                    ‐     $                     ‐     $                     ‐
      #
      #



















































                                                             133
   140   141   142   143   144   145   146   147   148   149   150