Page 49 - CityofWataugaAdoptedBudgetFY25
P. 49

Water and Wastewater
                                                      Multi-Year Financial Plan



                                              Actual    Budget   Estimate     Budget    Projected  Projected  Projected
                                             2022-2023  2023-2024  2023-2024  2024-2025  2025-2026  2026-2027  2027-2028



            BEGINNING BALANCE                          2,813,192             3,200,000           3,312,618  *                3,154,204             2,669,614             1,917,183            2,655,108

            REVENUES



            Water Service                              5,143,839             4,950,000           5,150,000                 5,450,000             5,613,500             5,894,175            6,129,942





            Wastewater Service                         4,040,634             4,350,000           4,200,000                 4,600,000             5,168,560             5,478,674            5,807,394
            Proposed Increase in Revenues                  3.00%                  8.00%       8%        8%        6%

            Service Charges                                 83,620                  65,000                85,000                      90,000                    91,800                   93,636                 93,636



            EPA Fees                                      160,460                161,000              160,000                    160,000                163,200                 166,464                 166,464

            Penalties                                     172,728                175,000              185,000                    196,000                199,920                 203,918                 207,997

            Miscellaneous                                   62,880                  50,000                68,800                      54,000                  55,620                   57,289                   59,007


            Interest Income/Transfers In JUF                132,764                120,000              204,000                    175,000                176,750                 178,518                 180,303


            Total Revenues                             9,796,925             9,871,000         10,052,800               10,725,000           11,469,350             12,072,673          12,644,743
            EXPENSES
            Utility Billing                              (571,677)              (615,410)            (603,450)                   (610,030)              (622,231)               (634,675)             (647,369)
            Non-Departmental - Operating                 (598,960)              (794,980)            (745,580)                   (832,480)              (849,130)               (866,112)             (883,434)
            Information Technology                       (106,367)              (126,990)            (122,140)                   (142,990)              (145,850)               (148,767)             (151,742)
            Administration                               (169,799)              (185,200)            (184,550)                   (198,200)              (202,164)               (206,207)             (210,331)
                                                                      -                            -
            Water Distribution                       (2,592,204)           (2,865,830)         (2,706,130)                (2,912,840)           (3,062,875)            (3,148,003)          (3,235,549)

            Sewer Collection                         (2,861,740)           (3,284,614)         (3,504,364)                (3,676,050)           (3,557,553)            (3,628,704)          (3,701,278)

            Transfers - Capital                          (140,000)                           -                          -                                  -                              -                             -
            Transfers - JUF                                (40,752)                (60,000)              (60,000)                     (60,000)                (60,000)                 (60,000)               (60,000)
            G&A/Franchise Fee                            (440,000)              (440,000)            (440,000)                   (487,000)              (564,630)               (594,708)             (623,222)

            W&WW Debt                                (1,726,000)           (1,800,000)         (1,800,000)                (2,025,000)           (1,801,572)            (2,047,572)          (2,022,572)
            Proposed Positions - PIP                                  -                            -                             -                           -
            Operating Expenses                       (9,247,499)         (10,173,024)       (10,166,214)              (10,944,590)         (10,866,004)          (11,334,748)        (11,535,498)

            Capital Expenses (carryover)                              -                            -                          -                                  -                               -                             -                             -
            Total Expenses                           (9,247,499)         (10,173,024)       (10,166,214)              (10,944,590)         (10,866,004)          (11,334,748)        (11,535,498)


            Recommended  Reserves per Policy           (2,311,875)           (2,543,256)         (2,541,554) *               (2,736,148)           (2,716,501)            (2,833,687)          (2,883,875)
            Available for Supplemental Current Year                549,426               (302,024)            (113,414)                   (219,590)                603,346                 737,925            1,109,245

            Proposed Supplemental                                     -                            -                            -                                -                             -                               -                           -
            Remaining Supplemental                        549,426               (302,024)            (113,414)                   (219,590)                603,346                 737,925            1,109,245


            Additional Available for Capital w/ Fund bal requirements               501,317                656,744              771,065                    418,057                 (46,887)               (916,504)             (228,766)


            Total Available for Capital*               1,050,744                354,720              657,651                    198,467                556,459               (178,579)               880,478

            Proposed Equip Repl/Capital (1)                      (50,000)                (45,000)              (45,000)                   (265,000)                            -                             -                (50,000)

            Remaining Funds Available                  1,000,744                309,720              612,651                     (66,533)                556,459               (178,579)               830,478



            ENDING FUND BALANCE                        3,312,618             2,852,976           3,154,204  *                2,669,614             1,917,183             2,655,108            3,714,353


            % of operating                        36%       28%       31%          24%       18%       23%       32%
            Staffing Variable
            Full-time Positions  (2)             23.75     25.75     25.75        25.75     25.75     25.75     25.75
            Part-time positions                   0.00 Part-time positions   0.00  0.00      0.00      0.00      0.00
            (1)  Proposed Capital will only be funded if excess reserves are available.
                                                             41
   44   45   46   47   48   49   50   51   52   53   54