Page 135 - City of Westlake FY20 Budget
P. 135

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
      # Peak Payment              dept 16           2%             (409,500)               (409,500)                (456,879)              (466,017)            (475,337)             (484,844)             (494,541)
      # TRA‐Wastewater Treatment  dept 16           2%             (479,303)               (479,303)                (479,303)              (486,493)            (493,790)             (501,197)             (508,715)
      # Southlake‐Wastewater Treatment  dept 16     2%          (1,302,497)            (1,302,497)            (1,302,497)           (1,322,034)         (1,341,865)          (1,361,993)          (1,382,423)
      # Testing‐Water/Bacteria/Rgltry  dept 16      2%               (30,000)                  (30,000)                  (30,000)                 (30,450)               (30,907)                (31,370)                (31,841)
      # Utility Billing           dept 16           2%               (27,321)                  (27,321)                  (27,321)                 (27,731)               (28,147)                (28,569)                (28,998)
      # Line Location             dept 16           2%                  (5,660)                    (5,660)                    (5,660)                   (5,745)                 (5,831)                  (5,919)                  (6,007)
      # Application Software Maint.  dept 16        2%  $           (10,750) $              (10,750)  $              (11,985)  $            (12,165) $           (12,347) $            (12,532) $            (12,720)
      # Keller Waste Water        dept 16           2%                  (1,300)                    (1,300)                    (1,300)                   (1,320)                 (1,339)                  (1,359)                  (1,380)
      # Insurance General Liability  dept 16        2%                     (980)                       (835)                        (835)                      (848)                    (860)                     (873)                     (886)
      # Mobile Phone              dept 16           2%                  (1,000)                    (1,000)                    (1,000)                   (1,015)                 (1,030)                  (1,046)                  (1,061)
      # Misc Rental/Lease         dept 16           2%                     (500)                       (500)                    (1,500)                   (1,523)                 (1,545)                  (1,569)                  (1,592)
      # Printing                  dept 16           2%                  (1,130)                    (1,130)                    (1,130)                   (1,147)                 (1,164)                  (1,182)                  (1,199)
      # Courier Service           dept 16           2%                     (200)                       (200)                        (200)                      (203)                    (206)                     (209)                     (212)
      # Total Services                                        (3,306,555)            (3,307,793)            (3,466,618)           (3,526,106)         (3,586,636)          (3,648,227)          (3,710,898)
      #
      # Computer Eqpmt/Software   dept 16           2%                     (210)                       (210)                        (210)                      (213)                    (216)                     (220)                     (223)
      # Safety Supplies           dept 16           2%                     (100)                       (100)                        (100)                      (102)                    (103)                     (105)                     (106)
      # Misc Hand Tools           dept 16           2%                  (1,855)                    (1,855)                    (1,855)                   (1,883)                 (1,911)                  (1,940)                  (1,969)
      # Chemical Supplies         dept 16           2%                     (350)                       (350)                        (350)                      (355)                    (361)                     (366)                     (371)
      # Office Supplies           dept 16           2%                     (538)                       (538)                        (538)                      (546)                    (554)                     (563)                     (571)
      # Postage & Shipping        dept 16           2%                     (400)                       (400)                        (400)                      (406)                    (412)                     (418)                     (425)
      # Vehicle Fuel              dept 16           2%                  (3,000)                    (3,000)                    (3,000)                   (3,045)                 (3,091)                  (3,137)                  (3,184)
      # Uniforms                  dept 16           2%                     (587)                       (587)                        (587)                      (596)                    (605)                     (614)                     (623)
      # Total Supplies                                                (7,040)                    (7,040)                    (7,040)                   (7,146)                 (7,253)                  (7,362)                  (7,472)
      #
      # Travel Airfare            dept 16           2%                     (800)                       (800)                        (800)                      (812)                    (824)                     (837)                     (849)
      # Travel Car Rental/Parking  dept 16          2%                     (100)                       (100)                        (100)                      (102)                    (103)                     (105)                     (106)
      # Travel Lodging            dept 16           2%                  (1,560)                    (1,560)                    (1,560)                   (1,583)                 (1,607)                  (1,631)                  (1,656)
      # Travel Meals              dept 16           2%                       (77)                          (77)                          (77)                         (78)                       (79)                        (81)                        (82)
      # Travel Mileage            dept 16           2%                       (58)                          (58)                          (58)                         (59)                       (60)                        (61)                        (62)
      # Training/Seminars/Meetings  dept 16         2%                  (3,000)                    (3,000)                    (3,000)                   (3,045)                 (3,091)                  (3,137)                  (3,184)
      # Dues & Subscriptions      dept 16           2%                  (1,500)                    (1,500)                    (1,500)                   (1,523)                 (1,545)                  (1,569)                  (1,592)
      # Licenses/Registrations    dept 16           2%                     (700)                       (700)                        (700)                      (711)                    (721)                     (732)                     (743)
      # Total Travel & Training                                       (7,795)                    (7,795)                    (7,795)                   (7,912)                 (8,031)                  (8,151)                  (8,273)
      #
      # Transfer Out ‐ UMR Fund 510  dept 99  linked to UMR                  (5,000)                    (5,000)                    (5,000)                   (5,000)                 (5,000)                  (5,000)                  (5,000)
      # Transfer Out ‐ VMR Fund 505  dept 99  linked to VMR               (10,000)                  (10,000)                  (10,000)                   (5,000)                 (5,000)                  (5,000)                  (5,000)
      # Transfer Out ‐ GF 100 Impact Fees  dept 99  GF linked to this               (66,539)                  (66,539)                  (67,225)                   (6,181)                 (6,305)                  (6,431)                  (6,560)
      # Total Transfers Out                                         (81,539)                 (81,539)                  (82,225)                (16,181)              (16,305)               (16,431)               (16,560)
      #
      # Texas Water Development Board                                       ‐             (1,996,332)                          ‐                         ‐                        ‐                         ‐                         ‐
      # Total Capital Projects                                              ‐             (1,996,332)                          ‐                        ‐                       ‐                        ‐                        ‐
      # TOTAL EXPENSES                                        (6,347,244)           (6,630,617)           (4,875,165)          (4,762,730)        (4,836,108)         (4,909,096)         (4,983,701)

      # NET CHANGE TO FUND BALANCE                              1,175,257                 346,684                 774,863            1,021,737           1,041,529            1,063,884            1,102,340
      # Beginning Fund Balance                                     197,156                (424,904)              1,873,862            2,648,725           3,670,462            4,711,991            5,775,876

      # Prior Period Adjustment (Texas Water Development Board)                       ‐             1,952,082                         ‐                              ‐                          ‐                           ‐                         ‐
        Restated Beginning Fund Balance                            197,156              1,527,178              1,873,862            2,648,725           3,670,462            4,711,991            5,775,876
      # Ending Fund Balance                                     1,372,413              1,873,862             2,648,725            3,670,462           4,711,991            5,775,876            6,878,216
      # Restricted/Committed/Assigned Hillwood                     888,000                 888,000                 888,000                750,000              750,000               750,000                750,000
      # Restricted/Committed/Assigned Deposits                     186,130                  186,130                 186,130                186,130              186,130               186,130                186,130
      # Restricted/Committed/Assigned Other                                 ‐                           ‐                          ‐                         ‐                        ‐                         ‐                         ‐
      # Unassigned Ending Balance                                  298,283   $            799,732   $        1,574,595    $       2,734,332   $      3,775,861   $       4,839,746   $       5,942,086
      # Operating Expenses                                      6,347,244              6,630,617              4,875,165            4,762,730           4,836,108            4,909,096            4,983,701
      # Operating Cost Per Day                                        17,390                    18,166                   13,357                  13,049                 13,250                  13,450                  13,654
      # OPERATING DAYS                                                       79                         103                         198                       281                      356                       429                       504
      #
      #















                                                             123
   130   131   132   133   134   135   136   137   138   139   140