Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
Exhibit MSD 31B - CIRP Support Schedule for Rate Model Storm Dashboard Tab
Original 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