B5 — original pdf

Backup

Document 6 Water and Wastewater Commission Budget Subcommittee Meeting May 24, 2021 Financial Forecast – FY2022-26 Debt Management Plan Summary PDF Page 24Austin Water Debt Management Plan Summary OPERATING FUND SOURCES IMPACT FEES DEBT SERVICE FUNDS FISCAL YEAR IMPACTS FY 2015-16 FY 2016-17 FY 2017-18 FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 FY 2025-26 FY 2027-41 Defeasance Savings PV Savings Savings COMBINED UTILITY: Defeasances: May 2018 May 2019 Refundings: Series 2015 Series 2016 Series 2017 Series 2020C May 2016 $ - $ 18,200,000 $ - $ - $ 618,213 $ 618,213 $ 4,318,212 $ 618,213 $ 618,213 $ 618,213 $ 5,505,713 $ 4,273,713 $ 2,612,213 $ 70,213 $ 1,545,531 $ 21,416,656 $ 21,416,656 March 2017 $ - $ 22,000,000 $ - $ - $ - $ 927,575 $ 11,527,575 $ 9,466,575 $ - $ - $ - $ - $ - $ - $ - $ 21,921,725 $ 21,921,725 $ 34,000,000 $ 30,000,000 $ - $ - $ - $ 26,610,016 $ 18,143,913 $ 12,379,556 $ 4,351,138 $ 4,036,756 $ 1,975,124 $ - $ - $ - $ - $ 67,496,503 $ 67,496,503 $ 11,000,000 $ 34,200,000 $ - $ - $ - $ - $ 5,636,213 $ 15,984,006 $ 12,101,275 $ 8,485,838 $ 2,340,775 $ 2,543,188 $ 617,656 $ 721,875 $ - $ 48,430,825 $ 48,430,825 April 2020 $ - $ 40,000,000 $ - $ - $ - $ - $ - $ 77,083 $ 4,290,625 $ 30,318,250 $ 5,519,625 $ - $ - $ - $ - $ 40,205,583 $ 40,205,583 Total Defeasance $ 45,000,000 $ 144,400,000 $ - $ - $618,213 $28,155,803 $39,625,912 $38,525,433 $21,361,250 $43,459,056 $ 15,341,237 $6,816,900 $3,229,869 $792,088 $ 1,545,531 $ 199,471,292 $ 199,471,291 PAR REFUNDED BONDS PAR REFUNDING BONDS $ - $ 310,270,000 $ 289,145,000 $ 11,095,024 $ 14,683,661 $ 20,328,033 $ 19,822,058 $ 7,446,937 $ (3,716,933) $ (3,718,020) $ (3,719,789) $ (3,716,931) $ (3,716,375) $ (3,718,133) $ (39,055,918) $ 12,013,616 $ 25,451,045 $ - $ 110,960,000 $ 92,885,000 $ (203,615) $ 448,924 $ 242,513 $ 242,513 $ 242,513 $ 242,513 $ 242,513 $ 242,513 $ 242,513 $ 242,513 $ 1,654,500 $ 19,711,844 $ 23,551,752 $ 16,822,415 FY 2015-16 FY 2016-17 FY 2017-18 FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 FY 2024-25 FY 2025-26 FY 2027-41 $ - $ 228,800,000 $ 205,820,000 $ - $ - $ 579,763 $ 1,136,638 $ 1,136,638 $ 2,545,513 $ 2,543,225 $ 2,040,788 $ 2,170,956 $ 2,340,416 $ 2,602,556 $ 19,733,703 Refunding Savings PV Refunding Savings 36,830,194 $ $ - $ 22,271,726 $ 29,045,226 $ 18,769,390 $ 58,170,000 $ 44,840,000 $ 438,604 $ 694,756 $ 1,114,006 $ 1,112,006 $ 1,113,881 $ 1,109,631 $ 16,688,841 Total Refundings $ - $ 708,200,000 $ 632,690,000 $ 10,891,409 $ 15,132,585 $ 21,150,309 $ 21,201,208 $ 8,826,087 $ (490,303) $ (237,526) $ (322,482) $ (191,456) $ (19,566) $ 1,648,555 $ 17,078,469 $ 94,667,289 $ 90,088,076 Total Plan Impacts $ 45,000,000 $ 852,600,000 $ 632,690,000 $ 10,891,409 $ 15,750,797 $ 49,306,112 $ 60,827,120 $ 47,351,520 $ 20,870,947 $ 43,221,530 $ 15,018,754 $ 6,625,444 $ 3,210,303 $ 2,440,643 $ 18,624,001 $ 294,138,580 $ 289,559,367 $19.M $45.9M $48.7M $60.6M $72.3M $78.3M $43.8M $58.5M Total Debt Service Requirements Comparison FY 2016 to Current - Budget Basis $70.5M $76.8M $260 $234 $208 $182 $156 $130 $104 $78 $52 $26 $0 ) s n o i l l i m n i ( e c i v r e S t b e D 2016-17 Actual 2017-18 Actual 2018-19 Actual 2019-20 Actual 2020-21 Estimate 2021-22 Forecast 2022-23 Forecast 2023-24 Forecast 2024-25 Forecast 2025-26 Forecast Current Debt Service Requirements Debt Svc Reduction 2016 Debt Service Requirements PDF Page 25