Loading...
HomeMy Public PortalAboutExhibit MSD 31B - CIRP Support Schedule for Rate Model Storm Dashboard TabOriginal Engineering EstimatesMetropolitan St. Louis Sewer DistrictCost of Service and Financial Planning ModelStormwater CIRPBudget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028Capital Improvement and Replacement Progam NeedsBase Scenario511051202,205,000 12,435,000 11,088,000 16,822,000 4,000,000 4,114,000 - - - - 5130- - - - - - - - - - 5563- - 400,000.00 - 1,500,000.00 - - 5564$40,000 $0 $0 $0 $0 - - 5565- - - - - 481,600 55661,534,000 3,559,000 582,000 $929,000 $0 - - 5569- - - - - 5571$829,000 $350,000 $0 $0 $0 - - 5574$0 $0 $240,000 $0 $0 - - 5576$485,000 $0 $0 $0 $0 - - 5579- - - - - 5580- - - - - 5583$560,000 $600,000 $0 $0 $0 - - 5584$0 $1,177,000 $1,195,000 $0 $0 - - 5587$0 $0 $0 $385,000 $0 - - 5589- - - - 190,000.00 5592$0 $0 $188,000 $0 $05593$750,000 $0 $0 $0 $0 - - 5594$350,000 $0 $0 $0 $0 - - Proposed SW Capital Rate- - 6,535,080 10,577,000 23,224,120 24,013,240 19,471,880 18,340,680 20,357,000 20,805,320 15,356,680 Total w/o 5110, 5120, 5130, Proposed SW Capital Rate4,548,000 5,686,000 2,605,000 1,314,000 1,690,000 - - - - - 481,600 Total6,753,000$ 18,121,000$ 20,228,080$ 28,713,000$ 28,914,120$ 28,127,240$ 19,471,880$ 18,340,680$ 20,357,000$ 20,805,320$ 15,838,280$ 5110 ‐ O&M Managed in CIRP100,000 100,000 100,000 100,000 100,000 100,000            100,000          100,000          100,000          100,000          100,000          5120 ‐ O&M Managed in CIRP 2,500,000         6,000,000        2,000,000        5,000,000        5,000,000        5,000,000         5,000,000       5,000,000       5,000,000       5,000,000       5,000,000       5130 ‐ O&M Managed in CIRP‐                    500,000            500,000             ‐                     ‐                     ‐                     ‐                    ‐                    ‐                    ‐                    ‐                    O&M Managed in CIRP 2,600,000         6,600,000        2,600,000        5,100,000        5,100,000        5,100,000         5,100,000       5,100,000       5,100,000       5,100,000       5,100,000       Total 5110100,000.00       100,000.00      100,000.00      100,000.00      100,000.00      100,000.00       100,000.00     100,000.00     100,000.00     100,000.00     100,000.00     Total 51204,705,000.00   18,435,000.0013,088,000.0021,822,000.009,000,000.00   9,114,000.00   5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 Total 5130‐                    500,000.00      500,000.00       ‐                     ‐                     ‐                     ‐                    ‐                    ‐                    ‐                    ‐                    Combined 5120 & 51304,705,000.00   18,935,000.0013,588,000.0021,822,000.009,000,000.00   9,114,000.00   5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00  Engineering Projections Adjusted for InflationMetropolitan St. Louis Sewer DistrictCost of Service and Financial Planning ModelStormwater CIRP012345678910Base Year2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028ENR Inflation RateInflation Rate100.00% 103.71% 107.55% 111.53% 115.67% 119.95% 124.40% 129.01% 133.79% 138.75% 143.89%Base ScenarioAsset Management ‐ Capacity5110‐                     ‐                    ‐                    ‐                    ‐                    ‐                      ‐                    ‐                    ‐                    ‐                    ‐                   5120 2,205,000         12,895,796     11,924,988     18,762,241     4,626,680       4,934,874          ‐                    ‐                    ‐                    ‐                    ‐                   5130‐                     ‐                    ‐                    ‐                    ‐                    ‐                      ‐                    ‐                    ‐                    ‐                    ‐                   5563‐                     ‐                   430,194           ‐                   1,735,005        ‐                      ‐                    ‐                    ‐                    ‐                    ‐                   5564 40,000                ‐                    ‐                    ‐                    ‐                    ‐                      ‐                    ‐                    ‐                    ‐                    ‐                   5565‐                     ‐                    ‐                    ‐                    ‐                    ‐                      ‐                    ‐                    ‐                    ‐                   692,963          5566 1,534,000         3,690,884       625,933          1,036,150        ‐                    ‐                      ‐                    ‐                    ‐                    ‐                    ‐                   5569‐                     ‐                    ‐                    ‐                    ‐                    ‐                      ‐                    ‐                    ‐                    ‐                    ‐                   5571 829,000            362,970           ‐                    ‐                    ‐                    ‐                      ‐                    ‐                    ‐                    ‐                    ‐                   5574‐                     ‐                   258,117           ‐                    ‐                    ‐                      ‐                    ‐                    ‐                    ‐                    ‐                   5576 485,000             ‐                    ‐                    ‐                    ‐                    ‐                      ‐                    ‐                    ‐                    ‐                    ‐                   5579‐                     ‐                    ‐                    ‐                    ‐                    ‐                      ‐                    ‐                    ‐                    ‐                    ‐                   5580‐                     ‐                    ‐                    ‐                    ‐                    ‐                      ‐                    ‐                    ‐                    ‐                    ‐                   5583 560,000            622,234           ‐                    ‐                    ‐                    ‐                      ‐                    ‐                    ‐                    ‐                    ‐                   5584‐                    1,220,615       1,285,206        ‐                    ‐                    ‐                      ‐                    ‐                    ‐                    ‐                    ‐                   5587‐                     ‐                    ‐                   429,406           ‐                    ‐                      ‐                    ‐                    ‐                    ‐                    ‐                   5589‐                     ‐                    ‐                    ‐                   219,767           ‐                      ‐                    ‐                    ‐                    ‐                    ‐                   5592‐                     ‐                   202,191           ‐                    ‐                    ‐                      ‐                    ‐                    ‐                    ‐                    ‐                   5593 750,000             ‐                    ‐                    ‐                    ‐                    ‐                      ‐                    ‐                    ‐                    ‐                    ‐                   5594 350,000             ‐                    ‐                    ‐                    ‐                    ‐                      ‐                    ‐                    ‐                    ‐                    ‐                   Proposed SW Capital Rate- - 7,028,386 11,796,946 26,862,641 28,804,648 24,222,672 23,660,938 27,235,332 28,866,601 22,096,371 4,548,000 5,896,702 2,801,641 1,465,556 1,954,772 Total6,753,000 18,792,498 21,755,015 32,024,743 33,444,093 33,739,522 24,222,672 23,660,938 27,235,332 28,866,601 22,789,334 3.7%2018Total w/o 5110, 5120, 5130, Proposed SW Capital Rate Engineering Projections Adjusted for Inflation and Project DelaysMetropolitan St. Louis Sewer DistrictCost of Service and Financial Planning ModelStormwater CIRP% Appropriated on Time2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028% Appropriated 1‐year DelayBase ScenarioAsset Management ‐ Capacity5110‐                     ‐                    ‐                    ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5120 2,205,000         11,719,808     12,031,777     18,010,143     6,181,591       4,900,973         542,836           ‐                    ‐                    ‐                    ‐                   5130‐                     ‐                    ‐                    ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5563‐                     ‐                   382,873          47,321             1,544,154       190,851             ‐                    ‐                    ‐                    ‐                    ‐                   5564 40,000              4,400                ‐                    ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5565‐                     ‐                    ‐                    ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                   616,737          5566 1,534,000         3,453,626       963,077          991,026          113,977           ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5569‐                     ‐                    ‐                    ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5571 829,000            414,233          39,927              ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5574‐                     ‐                   229,724          28,393              ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5576 485,000            53,350              ‐                    ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5579‐                     ‐                    ‐                    ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5580‐                     ‐                    ‐                    ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5583 560,000            615,388          68,446              ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5584‐                    1,086,348       1,278,101       141,373           ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5587‐                     ‐                    ‐                   382,171          47,235              ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5589‐                     ‐                    ‐                    ‐                   195,593          24,174                ‐                    ‐                    ‐                    ‐                    ‐                   5592‐                     ‐                   179,950          22,241              ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5593 750,000            82,500              ‐                    ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5594 350,000            38,500              ‐                    ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   Proposed SW Capital Rate- - 6,255,264 11,272,404 25,205,415 28,591,027 24,726,690 23,722,729 26,842,148 28,687,162 22,841,096 4,548,000 5,748,345 3,142,098 1,612,525 1,900,958 215,025 - - - - - Total6,753,000 17,468,154 21,429,138 30,895,073 33,287,965 33,707,025 25,269,526 23,722,729 26,842,148 28,687,162 23,457,833 89.0%11.0%Total w/o 5110, 5120, 5130, Proposed SW Capital Rate Engineering Projections Adjusted for Inflation, Project Delays, and LiquidationsMetropolitan St. Louis Sewer DistrictCost of Service and Financial Planning ModelStormwater CIRPYears Delayed2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028Liquidation %Base ScenarioAsset Management ‐ Capacity5110‐                     ‐                    ‐                    ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5120 2,205,000         11,719,808     11,173,838     17,800,007     5,064,694       3,754,345         (1,173,530)      (587,081)         (465,037)         (51,732)            ‐                   5130‐                    (18,660)           (206,772)          ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5563 446                   10,735             376,185          47,321             1,544,154       154,363            (4,510)             (147,158)         (18,188)            ‐                    ‐                   5564 (36,576)             (400,457)         (371,816)         (3,812)             (419)                  ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5565 4,248                525                  (74,834)            ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                   616,737          5566 1,305,813         3,175,833       628,867          844,836          (215,154)         (91,781)             (94,445)           (10,862)            ‐                    ‐                    ‐                   5569 2,893                (6,173)             (425)                  ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5571 730,418            110,051          (74,502)           (79,004)           (39,476)           (3,805)                ‐                    ‐                    ‐                    ‐                    ‐                   5574‐                     ‐                   229,724          28,393              ‐                   (21,893)             (2,706)              ‐                    ‐                    ‐                    ‐                   5576 455,449            (25,043)           (121,009)         (46,221)           (5,084)              ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5579 (37,828)             (4,675)              ‐                    ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5580‐                     ‐                    ‐                    ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5583 560,000            597,152          66,192             (53,368)           (58,646)           (6,523)                ‐                    ‐                    ‐                    ‐                    ‐                   5584 (29,380)             1,064,019       1,023,893       141,373          (103,529)         (121,803)           (13,473)            ‐                    ‐                    ‐                    ‐                   5587 (29,624)             (4,045)             (2,446)             382,171          47,235              ‐                    (36,421)           (4,501)              ‐                    ‐                    ‐                   5589‐                     ‐                    ‐                    ‐                   195,593          24,174                ‐                   (18,640)           (2,304)              ‐                    ‐                   5592‐                     ‐                   179,950          22,241              ‐                   (17,149)             (2,120)              ‐                    ‐                    ‐                    ‐                   5593 741,961            (2,378)             (8,042)             (71,475)           (7,862)              ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   5594 349,817            (10,546)           (6,062)             (33,355)           (3,669)              ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   Proposed SW Capital Rate- - 6,255,264 11,272,404 25,205,415 27,994,900 23,652,429 21,320,653 24,117,424 26,330,708 20,580,320 4,017,638 4,504,998 1,845,673 1,179,101 1,353,141 (84,417) (153,674) (181,161) (20,492) - 616,737 Total6,222,638 16,206,147 19,068,003 30,251,512 31,623,250 31,664,828 22,325,225 20,552,411 23,631,895 26,278,976 21,197,057 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 20285110 ‐ O&M Managed in CIRP 100,000            100,000          100,000          100,000          100,000          100,000            100,000          100,000          100,000          100,000          100,000          5120 ‐ O&M Managed in CIRP 2,500,000         6,000,000       2,000,000       5,000,000       5,000,000       5,000,000         5,000,000       5,000,000       5,000,000       5,000,000       5,000,000       5130 ‐ O&M Managed in CIRP‐                    500,000          500,000           ‐                    ‐                    ‐                     ‐                    ‐                    ‐                    ‐                    ‐                   O&M Managed in CIRP 2,600,000         6,600,000       2,600,000       5,100,000       5,100,000       5,100,000         5,100,000       5,100,000       5,100,000       5,100,000       5,100,000       Paste this row into the model for 5120+5130‐>4,705,000         18,201,149     13,467,066     22,800,007     10,064,694     8,754,345         3,826,470       4,412,919       4,534,963       4,948,268       5,000,000       Paste this row into the model for 6710‐>‐                         ‐                       6,255,264       11,272,404     25,205,415     27,994,900       23,652,429     21,320,653     24,117,424     26,330,708     20,580,320     Paste this row into the model for OMCI Funds‐>4,017,638         4,504,998       1,845,673       1,179,101       1,353,141       (84,417)             (153,674)         (181,161)         (20,492)            ‐                       616,737          Paste this row into the model for 5110‐>100,000            100,000          100,000          100,000          100,000          100,000            100,000          100,000          100,000          100,000          100,000          39.5%Total w/o 5110, 5120, 5130, Proposed SW Capital Rate