B3 — original pdf

Backup

Document 3 Water and Wastewater Commission Budget Subcommittee Meeting May 24, 2021 Financial Forecast – FY2022-26 Fund Summaries PDF Page 8Fund Summary - By Year - By Scenario (All Funds) - 5 Year Scenario 1: Rate Revenue Increase FY24 & FY26 FY20 Actuals FY21 CYE FY22 FY23 FY24 FY25 FY26 201,808,037 231,677,013 229,390,664 230,292,273 234,535,984 242,875,972 249,169,837 Beginning Balance Beginning Balances Revenues Revenues Water/Wastewater Revenue Other Revenue Interest Development Fees Other Fines Public Health Licenses, Permits, Inspections Property Sales Use of Property Total Revenues Transfers In Austin Water Utility Support Services/Infrastructure Funds Austin Resource Recovery Fund CIP Total Transfers In Requirements Program Requirements Operations Support Services Environmental, Planning, and Development Services Engineering Services Customer Experience Other Utility Program Requirements Reclaimed Water Services Environmental Affairs & Conservation Water Resources Management Total Program Requirements Other Requirements Utility Billing System Support Supplemental Retirement Contribution Accrued Payroll Interdepartmental Charges Trf to PID Fund Total Other Requirements 553,501,565 3,833,022 4,100,996 1,614,210 883,550 750,626 37,519 157,352 564,878,840 10,768,734 300,582 53,334 40,000,000 51,122,650 141,287,463 32,569,587 - 14,691,969 - 5,929,701 596,742 12,373,662 8,709,376 216,158,499 19,629,848 - 313,784 196,213 110,573 20,250,418 555,832,489 9,352,663 1,686,096 1,462,200 875,400 797,800 191,000 185,100 570,382,748 10,799,476 300,582 74,884 - 11,174,942 147,018,702 33,604,393 19,814,578 14,213,426 10,651,498 9,955,690 585,165 - - 235,843,452 19,825,622 808,610 294,467 241,059 75,000 21,244,758 566,690,818 12,151,915 1,235,887 1,429,447 771,840 830,270 211,494 167,238 583,488,910 10,721,123 300,582 74,884 55,000,000 66,096,589 153,050,320 36,043,214 21,196,942 16,030,109 10,903,201 10,165,523 829,404 - - 248,218,712 19,325,622 808,610 303,300 241,059 75,000 20,753,591 574,149,443 12,426,548 1,200,003 1,457,893 787,277 846,876 413,683 167,238 591,448,961 11,538,998 300,582 74,884 42,000,000 53,914,464 155,838,235 37,791,178 21,856,299 16,491,627 11,103,729 11,524,384 844,836 - - 255,450,289 21,025,630 808,610 312,399 241,059 75,000 22,462,698 597,899,069 12,565,726 1,286,044 1,487,051 802,944 863,813 215,984 167,238 615,287,868 11,856,873 300,582 74,884 38,000,000 50,232,339 158,966,233 39,574,277 22,529,135 17,421,489 11,308,578 10,470,283 860,578 - - 261,130,572 21,235,886 808,610 321,771 241,059 75,000 22,682,326 609,011,661 12,852,224 1,336,645 1,516,792 819,083 881,090 118,294 167,238 626,703,026 11,926,513 300,582 74,884 38,000,000 50,301,979 161,500,146 41,393,224 23,215,732 18,370,066 11,517,851 10,619,366 876,634 - - 267,493,019 21,448,245 808,610 331,424 241,059 75,000 22,904,338 631,651,838 13,109,269 1,419,173 1,547,127 835,465 898,711 120,660 167,238 649,749,481 11,843,401 300,582 74,884 39,000,000 51,218,867 164,773,883 43,248,743 23,916,382 19,337,739 11,731,651 10,771,713 893,012 - - 274,673,123 22,520,657 808,610 341,366 241,059 75,000 23,986,692 Total Available Funds 616,001,490 581,557,690 649,585,499 645,363,425 665,520,207 677,005,005 700,968,348 PDF Page 9Total Operating Requirements FY20 Actuals FY26 236,408,918 257,088,210 268,972,303 277,912,987 283,812,898 290,397,357 298,659,815 FY21 CYE FY22 FY23 FY24 FY25 Total Debt Service Requirements 172,692,447 171,971,108 170,653,621 167,060,212 167,532,671 177,852,595 175,158,625 Debt Service Requirements Trf to Util D/S Separate Lien Tfr to Utility D/S Sub Lien Commercial paper interest Trf to GO Debt Service Tfr to Util D/S Tax/Rev Bonds Interest Payment D/S Funds Total Debt Service Requirements Transfers Out Trf to General Fund Trf to Wastewater CIP Fund Trf to Water CIP Fund Administrative Support Trf to Reclaimed Water Fund CBC Transfer Out CTM Support Trf to Economic Development Trf to CIP Mgm - CPM Trf to Water Revenue Stab Rsv Workers' Compensation Trf to Reclaimed Water CIP Fnd Regional Radio System CTECC Support TRF CRF to Debt Defeasance TRF Operating to Debt Defeasance Total Transfers Out 159,211,322 9,986,155 1,138,793 1,694,532 661,645 - 172,692,447 164,491,870 3,799,500 1,721,315 1,288,699 669,724 - 171,971,108 160,149,398 5,315,335 3,642,027 883,179 663,681 - 170,653,621 160,063,143 5,054,470 769,069 506,961 666,568 - 167,060,212 158,660,955 4,978,154 2,874,839 353,827 664,896 - 167,532,671 168,398,909 4,005,201 4,622,844 156,969 668,673 - 177,852,595 172,955,973 - 1,443,466 155,181 604,005 - 175,158,625 47,485,805 30,000,000 29,000,000 13,125,973 5,500,000 - 4,438,823 4,000,466 2,130,021 2,073,217 1,025,506 750,000 449,218 8,852 40,000,000 - 179,987,881 46,544,409 40,000,000 29,000,000 13,984,357 5,750,000 5,000,000 3,816,719 3,726,094 2,656,300 2,069,687 966,723 750,000 500,599 19,834 - - 154,784,722 45,895,276 37,000,000 31,000,000 14,683,575 5,500,000 - 4,198,391 3,726,094 2,656,300 2,280,150 995,725 750,000 525,629 20,826 55,000,000 4,826,000 209,057,966 46,979,180 40,000,000 29,850,000 15,417,754 6,250,000 - 4,618,230 3,726,094 2,656,300 2,299,584 1,025,596 750,000 551,910 21,867 42,000,000 - 196,146,516 47,705,430 45,000,000 36,000,000 16,188,641 6,500,000 - 5,080,053 3,726,094 2,656,300 2,319,300 1,056,364 1,000,000 579,506 22,960 38,000,000 - 205,834,649 48,932,837 42,000,000 33,000,000 16,998,073 6,500,000 - 5,588,058 3,726,094 2,656,300 2,339,181 1,088,055 1,000,000 608,481 24,108 38,000,000 - 202,461,188 50,114,023 48,000,000 38,500,000 17,847,977 6,500,000 - 6,146,864 3,726,094 2,656,300 2,359,226 1,120,697 1,000,000 638,905 25,314 39,000,000 - 217,635,400 Total Requirements 589,089,246 583,844,040 648,683,889 641,119,714 657,180,219 670,711,140 691,453,839 Excess (Deficiency) of Total Available Funds Over Total Requirements Excess (Deficiency) of Total Available 26,912,244 (2,286,350) 901,610 4,243,710 8,339,988 6,293,865 9,514,509 Adjustment to GAAP Adjustment to GAAP Ending Balance Ending Balances Report generated Fri Mar 12, 2021 16:23:27 EST by Synario 2,956,732 - - - - - - 231,677,013 229,390,664 230,292,273 234,535,984 242,875,972 249,169,837 258,684,346 PDF Page 10Fund Summary - By Year - By Scenario (Water Fund) - 5 Year Scenario 1: Rate Revenue Increase FY24 & FY26 FY20 Actuals FY21 CYE FY22 FY23 FY24 FY25 FY26 108,390,892 122,002,567 122,299,786 128,816,458 133,994,881 141,819,111 145,027,354 Beginning Balance Beginning Balances Revenues Revenues Water/Wastewater Revenue Other Revenue Interest Development Fees Other Fines Public Health Licenses, Permits, Inspections Property Sales Use of Property Total Revenues Transfers In Austin Water Utility Support Services/Infrastructure Funds CIP Total Transfers In Requirements Program Requirements Operations Support Services Environmental, Planning, and Development Services Engineering Services Customer Experience Other Utility Program Requirements Environmental Affairs & Conservation Water Resources Management Total Program Requirements Other Requirements Utility Billing System Support Supplemental Retirement Contribution Accrued Payroll Interdepartmental Charges Trf to PID Fund Total Other Requirements 293,994,800 1,591,464 2,164,634 1,612,590 883,550 75,256 17,969 112,276 300,452,539 3,115,310 150,291 31,000,000 34,265,601 74,324,829 16,302,468 - 5,974,325 - 3,013,208 9,306,480 4,014,864 112,936,174 11,781,955 - 160,060 98,107 62,939 12,103,061 296,839,386 2,677,100 849,404 1,460,100 875,400 71,200 146,300 125,300 303,044,190 304,763,594 3,478,356 629,008 1,427,394 771,840 74,098 161,998 113,209 311,419,496 308,898,195 3,556,967 610,127 1,455,799 787,277 75,580 316,868 113,209 315,814,021 321,174,205 3,596,805 659,469 1,484,915 802,944 77,091 165,437 113,209 328,074,074 324,287,953 3,678,812 685,101 1,514,613 819,083 78,633 90,610 113,209 331,268,013 335,928,981 3,752,388 730,891 1,544,905 835,465 80,206 92,422 113,209 343,078,467 2,890,731 150,291 - 3,041,022 2,881,756 150,291 40,000,000 43,032,047 2,919,219 150,291 31,000,000 34,069,510 2,956,682 150,291 29,000,000 32,106,973 2,995,119 150,291 29,000,000 32,145,410 3,034,055 150,291 29,000,000 32,184,346 75,617,734 17,314,201 14,280,657 5,642,505 8,325,100 5,267,413 - - 126,447,610 11,799,072 418,301 173,379 120,530 37,500 12,548,782 78,670,154 18,882,302 15,190,579 6,195,078 8,519,657 5,377,523 - - 132,835,293 11,501,501 418,301 178,580 120,530 37,500 12,256,412 80,076,309 19,912,792 15,613,508 6,620,652 8,676,092 6,061,062 - - 136,960,416 12,619,712 418,301 183,937 120,530 37,500 13,379,980 81,514,618 20,964,036 16,045,160 7,054,781 8,835,967 5,538,365 - - 139,952,927 12,745,909 418,301 189,455 120,530 37,500 13,511,695 82,519,716 22,036,459 16,485,722 7,497,636 8,999,366 5,617,348 - - 143,156,246 12,873,368 418,301 195,139 120,530 37,500 13,644,838 84,024,878 23,130,491 16,935,385 7,949,395 9,166,374 5,698,051 - - 146,904,574 13,517,036 418,301 200,993 120,530 37,500 14,294,360 Total Available Funds 334,718,140 306,085,212 354,451,543 349,883,531 360,181,047 363,413,423 375,262,813 Total Operating Requirements 125,039,234 138,996,392 145,091,705 150,340,396 153,464,622 156,801,084 161,198,934 PDF Page 11Total Debt Service Requirements 91,065,132 89,535,636 85,028,499 85,169,483 84,158,670 90,221,567 83,213,022 p g q Debt Service Requirements Trf to Util D/S Separate Lien Tfr to Utility D/S Sub Lien Commercial paper interest Trf to GO Debt Service Tfr to Util D/S Tax/Rev Bonds Interest Payment D/S Funds Total Debt Service Requirements Transfers Out Trf to General Fund Trf to Water CIP Fund Administrative Support Trf to Reclaimed Water Fund CBC Transfer Out CTM Support Trf to Economic Development Trf to CIP Mgm - CPM Trf to Water Revenue Stab Rsv Workers' Compensation Regional Radio System CTECC Support TRF CRF to Debt Defeasance TRF Operating to Debt Defeasance Total Transfers Out , , FY20 Actuals , , FY21 CYE , , FY22 , , FY23 , , FY24 , , FY25 , , FY26 83,856,499 5,551,178 627,308 785,312 244,836 - 91,065,132 24,974,289 29,000,000 7,465,156 5,500,000 - 2,233,784 2,108,803 873,882 2,073,217 512,753 224,609 4,426 31,000,000 - 105,970,919 86,074,651 1,837,700 777,439 598,021 247,825 - 89,535,636 24,419,493 29,000,000 7,910,413 5,750,000 2,500,000 1,924,875 1,974,816 963,102 2,069,687 483,362 250,300 9,917 - - 77,255,965 80,245,847 2,570,793 1,539,963 426,307 245,589 - 85,028,499 81,951,372 2,444,624 272,968 253,862 246,657 - 85,169,483 80,727,025 2,407,713 600,980 176,914 246,038 - 84,158,670 87,056,353 1,937,139 902,155 78,484 247,436 - 90,221,567 82,613,651 - 298,274 77,591 223,506 - 83,213,022 24,102,212 31,000,000 8,305,934 5,500,000 - 2,117,363 1,974,816 963,102 2,280,150 497,863 262,815 10,413 40,000,000 800,000 117,814,667 25,007,710 29,850,000 8,721,230 6,250,000 - 2,329,099 1,974,816 963,102 2,299,584 512,799 275,956 10,933 31,000,000 - 109,195,229 25,427,591 36,000,000 9,157,292 6,500,000 - 2,562,009 1,974,816 963,102 2,319,300 528,183 289,754 11,480 29,000,000 - 114,733,526 26,111,741 33,000,000 9,615,156 6,500,000 - 2,818,209 1,974,816 963,102 2,339,181 544,028 304,241 12,054 29,000,000 - 113,182,529 26,654,267 38,500,000 10,095,914 6,500,000 - 3,100,030 1,974,816 963,102 2,359,226 560,349 319,453 12,657 29,000,000 - 120,039,815 Total Requirements 322,075,286 305,787,993 347,934,871 344,705,108 352,356,818 360,205,180 364,451,771 Excess (Deficiency) of Total Available Funds Over Total Requirements Excess (Deficiency) of Total Available 12,642,854 297,219 6,516,672 5,178,423 7,824,229 3,208,243 10,811,041 Adjustment to GAAP Adjustment to GAAP Ending Balance Ending Balances Report generated Fri Mar 12, 2021 16:24:53 EST by Synario 968,821 - - - - - - 122,002,567 122,299,786 128,816,458 133,994,881 141,819,111 145,027,354 155,838,395 PDF Page 12Fund Summary - By Year - By Scenario (Wastewater Fund) - 5 Year Scenario 1: Rate Revenue Increase FY24 & FY26 FY20 Actuals FY21 CYE FY22 FY23 FY24 FY25 FY26 91,738,625 106,289,529 103,086,142 97,202,807 96,015,500 96,554,804 100,499,829 Beginning Balance Beginning Balances Revenues Revenues Water/Wastewater Revenue Other Revenue Interest Development Fees Public Health Licenses, Permits, Inspections Property Sales Use of Property Total Revenues Transfers In Austin Water Utility Support Services/Infrastructure Funds Austin Resource Recovery Fund CIP Total Transfers In Requirements Program Requirements Operations Support Services Environmental, Planning, and Development Services Engineering Services Customer Experience Other Utility Program Requirements Environmental Affairs & Conservation Water Resources Management Total Program Requirements Other Requirements Utility Billing System Support Supplemental Retirement Contribution Accrued Payroll Interdepartmental Charges Trf to PID Fund Total Other Requirements 257,007,424 2,241,558 1,892,189 1,620 675,370 19,550 45,076 261,882,787 2,153,424 150,291 53,334 9,000,000 11,357,049 66,962,634 16,267,119 - 8,717,644 - 2,903,553 3,067,182 4,694,513 102,612,644 7,847,893 - 160,433 98,106 47,635 8,154,067 256,694,995 6,675,563 815,357 2,100 726,600 44,700 59,800 265,019,115 2,158,745 150,291 74,884 - 2,383,920 71,400,968 16,290,192 5,533,921 8,570,921 2,326,398 4,657,311 - - 108,779,711 8,026,550 386,642 120,251 120,529 37,500 8,691,472 259,503,318 8,673,559 584,554 2,053 756,173 49,496 54,029 269,623,182 2,339,367 150,291 74,884 15,000,000 17,564,542 74,380,166 17,160,912 6,006,363 9,835,031 2,383,543 4,754,932 - - 114,520,948 7,824,121 386,642 123,858 120,529 37,500 8,492,650 262,824,064 8,869,581 568,013 2,094 771,296 96,815 54,029 273,185,892 2,369,779 150,291 74,884 11,000,000 13,594,954 75,761,926 17,878,387 6,242,791 9,870,975 2,427,636 5,429,915 - - 117,611,630 8,405,918 386,642 127,574 120,529 37,500 9,078,163 274,295,162 8,968,921 602,944 2,136 786,722 50,547 54,029 284,760,461 2,400,191 150,291 74,884 9,000,000 11,625,366 77,451,615 18,610,241 6,483,975 10,366,708 2,472,611 4,898,491 - - 120,283,641 8,489,977 386,642 131,401 120,529 37,500 9,166,049 282,290,702 9,173,412 626,995 2,178 802,456 27,685 54,029 292,977,458 2,431,394 150,291 74,884 9,000,000 11,656,569 78,980,430 19,356,765 6,730,010 10,872,430 2,518,485 4,968,573 - - 123,426,694 8,574,877 386,642 135,343 120,529 37,500 9,254,891 293,286,535 9,356,880 662,092 2,222 818,506 28,238 54,029 304,208,503 2,309,346 150,291 74,884 10,000,000 12,534,521 80,749,005 20,118,252 6,980,997 11,388,345 2,565,277 5,040,197 - - 126,842,072 9,003,621 386,642 139,403 120,529 37,500 9,687,695 Total Available Funds 273,239,836 267,403,035 287,187,724 286,780,846 296,385,827 304,634,027 316,743,024 Total Operating Requirements 110,766,710 117,471,183 123,013,598 126,689,793 129,449,690 132,681,585 136,529,767 PDF Page 13Total Debt Service Requirements 76,978,518 76,941,782 80,166,923 75,698,285 76,922,472 80,367,738 83,773,668 p g q Debt Service Requirements Trf to Util D/S Separate Lien Tfr to Utility D/S Sub Lien Commercial paper interest Trf to GO Debt Service Tfr to Util D/S Tax/Rev Bonds Total Debt Service Requirements Transfers Out Trf to General Fund Trf to Wastewater CIP Fund Administrative Support CBC Transfer Out CTM Support Trf to Economic Development Trf to CIP Mgm - CPM Workers' Compensation Regional Radio System CTECC Support TRF CRF to Debt Defeasance TRF Operating to Debt Defeasance Total Transfers Out , , FY20 Actuals , , FY21 CYE , , FY22 , , FY23 , , FY24 , , FY25 , , FY26 70,795,524 4,434,977 421,988 909,220 416,810 76,978,518 73,033,210 1,961,800 834,195 690,678 421,899 76,941,782 74,681,725 2,744,542 1,865,691 456,873 418,092 80,166,923 71,984,169 2,609,846 431,260 253,099 419,911 75,698,285 71,716,436 2,570,441 2,039,825 176,914 418,857 76,922,472 74,376,562 2,068,062 3,423,394 78,484 421,237 80,367,738 82,239,672 - 1,075,907 77,591 380,498 83,773,668 22,362,161 30,000,000 5,531,936 - 2,202,877 1,846,730 1,098,355 512,753 224,609 4,426 9,000,000 - 72,783,847 21,945,962 40,000,000 5,932,677 2,500,000 1,888,982 1,704,662 1,477,597 483,361 250,299 9,917 - - 76,193,457 21,604,000 37,000,000 6,229,311 - 2,077,880 1,704,662 1,477,597 497,862 262,814 10,413 15,000,000 4,026,000 89,890,539 21,771,686 40,000,000 6,540,776 - 2,285,668 1,704,662 1,477,597 512,798 275,955 10,933 11,000,000 - 85,580,075 22,080,637 45,000,000 6,867,815 - 2,514,235 1,704,662 1,477,597 528,182 289,752 11,480 9,000,000 - 89,474,361 22,620,234 42,000,000 7,211,206 - 2,765,659 1,704,662 1,477,597 544,027 304,240 12,054 9,000,000 - 87,639,679 23,258,584 48,000,000 7,571,766 - 3,042,224 1,704,662 1,477,597 560,348 319,452 12,657 10,000,000 - 95,947,291 Total Requirements 260,529,075 270,606,422 293,071,059 287,968,153 295,846,523 300,689,002 316,250,726 Excess (Deficiency) of Total Available Funds Over Total Requirements Excess (Deficiency) of Total Available 12,710,761 (3,203,387) (5,883,335) (1,187,307) 539,304 3,945,025 492,298 Adjustment to GAAP Adjustment to GAAP Ending Balance Ending Balances Report generated Fri Mar 12, 2021 16:25:23 EST by Synario 1,840,143 - - - - - - 106,289,529 103,086,142 97,202,807 96,015,500 96,554,804 100,499,829 100,992,127 PDF Page 14Beginning Balance Beginning Balances Revenues Revenues Water/Wastewater Revenue Interest Total Revenues Transfers In Austin Water Utility Total Transfers In Requirements Program Requirements Other Utility Program Requirements Reclaimed Water Services Total Program Requirements Other Requirements Supplemental Retirement Contribution Accrued Payroll Total Other Requirements Debt Service Requirements Trf to Util D/S Separate Lien Commercial paper interest Total Debt Service Requirements Fund Summary - By Year - By Scenario (Reclaimed Water Fund) - 5 Year Scenario 1: Rate Revenue Increase FY24 & FY26 FY20 Actuals FY21 CYE FY22 FY23 FY24 FY25 FY26 1,678,520 3,384,917 4,004,736 4,273,009 4,525,602 4,502,058 3,642,654 2,499,341 44,173 2,543,514 2,298,108 21,335 2,319,443 2,423,906 22,325 2,446,231 2,427,184 21,863 2,449,047 2,429,702 23,631 2,453,333 2,433,006 24,549 2,457,555 2,436,321 26,190 2,462,511 5,500,000 5,500,000 5,750,000 5,750,000 5,500,000 5,500,000 6,250,000 6,250,000 6,500,000 6,500,000 6,500,000 6,500,000 6,500,000 6,500,000 Total Available Funds 8,043,514 8,069,443 7,946,231 8,699,047 8,953,333 8,957,555 8,962,511 Total Operating Requirements 602,973 620,635 867,000 882,798 898,586 914,688 931,113 12,940 596,742 609,682 - (6,709) (6,709) 30,966 585,165 616,131 33,067 829,404 862,471 33,407 844,836 878,243 33,426 860,578 894,004 33,445 876,634 910,079 3,667 837 4,504 3,667 862 4,529 3,667 888 4,555 3,667 915 4,582 3,667 942 4,609 33,464 893,012 926,476 3,667 970 4,637 4,559,300 89,497 4,648,797 5,384,009 109,680 5,493,689 5,221,826 236,373 5,458,199 6,127,602 64,842 6,192,444 6,217,495 234,034 6,451,529 6,965,995 297,295 7,263,290 8,102,649 69,285 8,171,934 Total Debt Service Requirements 4,648,797 5,493,689 5,458,199 6,192,444 6,451,529 7,263,290 8,171,934 PDF Page 15Transfers Out Trf to General Fund Administrative Support CTM Support Trf to Economic Development Trf to CIP Mgm - CPM Trf to Reclaimed Water CIP Fnd Total Transfers Out FY20 Actuals FY21 CYE FY22 FY23 FY24 FY25 149,355 128,881 2,162 44,933 157,784 750,000 1,233,115 178,954 141,267 2,862 46,616 215,601 750,000 1,335,300 189,064 148,330 3,148 46,616 215,601 750,000 1,352,760 199,784 155,747 3,463 46,616 215,601 750,000 1,371,211 197,202 163,534 3,809 46,616 215,601 1,000,000 1,626,763 200,862 171,711 4,190 46,616 215,601 1,000,000 1,638,980 FY26 201,172 180,296 4,609 46,616 215,601 1,000,000 1,648,294 Total Requirements 6,484,885 7,449,624 7,677,958 8,446,453 8,976,877 9,816,958 10,751,342 Excess (Deficiency) of Total Available Funds Over Total Requirements Excess (Deficiency) of Total Availa 1,558,629 619,819 268,273 252,594 (23,544) (859,403) (1,788,831) Adjustment to GAAP Adjustment to GAAP Ending Balance Ending Balances Report generated Fri Mar 12, 2021 16:25:53 EST by Synario 147,768 - - - - - - 3,384,917 4,004,736 4,273,009 4,525,602 4,502,058 3,642,654 1,853,824 PDF Page 16Document 44 Water and Wastewater Commission Budget Subcommittee Meeting May 24, 2021 Financial Forecast – FY2022-26 Revenue Assumptions PDF Page 17Projected Revenue Retail Customers Single Family Multifamily Commercial Large Volume Subtotal Retail Wholesale Customers Creedmoor- Maha WSC High Valley Manor, City of Marsha WSC Mid-Tex Utilities Morningside WSC Night Hawk WSC North Austin MUD #1 Northtown MUD Rivercrest WSC Rollingwood, City of Shady Hollow MUD Sunset Valley, City of Travis Co. WCID #10 Village of San Leanna Wells Branch MUD Southwest Water Subtotal Wholesale Total All Customers 5020-2200-9010 A/R Adjustments Projected Consumption Retail Customers Single Family Multifamily Commercial Large Volume Subtotal Retail Wholesale Customers Creedmoor- Maha WSC High Valley Manor, City of Marsha WSC Mid-Tex Utilities Morningside WSC Night Hawk WSC North Austin MUD #1 Northtown MUD Rivercrest WSC Rollingwood, City of Shady Hollow MUD Sunset Valley, City of Travis Co. WCID #10 Village of San Leanna Wells Branch MUD Southwest Water Subtotal Wholesale Average Accounts Retail Customers Single Family Multifamily Commercial Large Volume Subtotal Retail Water Revenue Forecast Estimated FY 2020-21 Year 1 FY 2021-22 Year 2 FY 2022-23 Year 3 FY 2023-24 Year 4 FY 2024-25 Year 5 FY 2025-26 $ $ 131,529,140 65,097,437 77,148,019 21,276,564 295,051,160 $ $ 125,952,769 67,301,636 76,045,954 21,326,884 290,627,243 $ $ 127,856,108 67,836,504 76,824,760 21,326,884 293,844,256 $ $ 129,528,695 68,383,611 77,611,360 21,326,884 296,850,550 $ $ 131,193,819 68,930,719 78,403,317 21,326,884 299,854,739 $ $ 132,880,150 69,477,826 79,200,399 21,326,884 302,885,259 $ $ $ $ $ $ 300,279 24,846 384 55,118 297,391 12,047 56,316 1,092,299 969,230 628,917 694,576 983,297 458,660 2,757,081 20,801 2,575,623 5,285 10,932,148 296,896 26,541 384 55,588 249,162 11,977 54,067 1,393,988 1,181,370 593,581 645,690 836,975 450,213 3,534,833 20,524 2,498,982 5,430 11,856,201 296,896 26,541 384 55,588 249,162 11,977 54,067 1,393,988 1,181,370 593,581 645,690 836,975 450,213 3,534,833 20,524 3,397,136 5,430 12,754,355 296,896 26,541 384 55,588 249,162 11,977 54,067 1,393,988 1,181,370 593,581 645,690 836,975 450,213 3,534,833 20,524 3,397,136 5,430 12,754,355 296,896 26,541 384 55,588 249,162 11,977 54,067 1,393,988 1,181,370 593,581 645,690 836,975 450,213 3,534,833 20,524 3,397,136 5,430 12,754,355 296,896 26,541 384 55,588 249,162 11,977 54,067 1,393,988 1,181,370 593,581 645,690 836,975 450,213 3,534,833 20,524 3,397,136 5,430 12,754,355 $ $ $ $ $ $ $ 305,983,309 $ 302,483,444 $ 306,598,611 $ 309,604,905 $ 312,609,094 $ 315,639,614 $ 2,218 $ - $ - $ - $ - $ - Grand Total $ 305,985,526 $ 302,483,444 $ 306,598,611 $ 309,604,905 $ 312,609,094 $ 315,639,614 15,765,210,400 10,255,199,400 11,003,784,100 3,744,640,400 40,768,834,300 15,393,763,000 10,174,513,500 10,744,002,200 3,754,561,000 40,066,839,700 15,591,632,600 10,255,373,300 10,854,035,200 3,754,561,000 40,455,602,100 15,792,050,300 10,338,085,100 10,965,169,900 3,754,561,000 40,849,866,300 15,995,074,500 10,420,796,900 11,077,053,100 3,754,561,000 41,247,485,500 16,200,651,100 10,503,508,700 11,189,673,200 3,754,561,000 41,648,394,000 68,298,900 5,585,900 3,000 12,625,000 72,150,700 2,145,100 12,959,900 327,639,256 317,213,299 131,138,800 135,817,300 144,631,400 94,759,300 833,697,472 4,440,700 893,086,900 1,043,300 3,057,236,227 67,429,300 6,024,100 3,000 12,745,000 60,387,600 2,131,200 12,383,200 313,912,300 285,086,000 123,015,700 125,304,400 139,244,600 92,767,000 797,792,500 4,372,400 863,609,700 1,078,800 2,907,286,800 67,429,300 6,024,100 3,000 12,745,000 60,387,600 2,131,200 12,383,200 313,912,300 285,086,000 123,015,700 125,304,400 139,244,600 92,767,000 797,792,500 4,372,400 863,609,700 1,078,800 2,907,286,800 67,429,300 6,024,100 3,000 12,745,000 60,387,600 2,131,200 12,383,200 313,912,300 285,086,000 123,015,700 125,304,400 139,244,600 92,767,000 797,792,500 4,372,400 863,609,700 1,078,800 2,907,286,800 67,429,300 6,024,100 3,000 12,745,000 60,387,600 2,131,200 12,383,200 313,912,300 285,086,000 123,015,700 125,304,400 139,244,600 92,767,000 797,792,500 4,372,400 863,609,700 1,078,800 2,907,286,800 67,429,300 6,024,100 3,000 12,745,000 60,387,600 2,131,200 12,383,200 313,912,300 285,086,000 123,015,700 125,304,400 139,244,600 92,767,000 797,792,500 4,372,400 863,609,700 1,078,800 2,907,286,800 All Customers 43,826,070,527 42,974,126,500 43,362,888,900 43,757,153,100 44,154,772,300 44,555,680,800 221,858 6,626 18,524 26 247,034 224,709 6,678 18,714 26 250,127 227,597 6,732 18,906 26 253,261 230,523 6,786 19,100 26 256,435 233,486 6,840 19,294 26 259,646 236,487 6,894 19,491 26 262,898 Wholesale Customers 48 50 50 50 50 50 Total Customers 247,082 250,177 253,311 256,485 259,696 262,948 FY 2021-22 WRF thru 0121_Forecast Submittal 5/12/2021 PDF Page 18Watewater Revenue Estimated FY 2020-21 Year 1 FY 2021-22 Year 2 FY 2022-23 Year 3 FY 2023-24 Year 4 FY 2024-25 Year 5 FY 2025-26 Wastewater Revenue Forecast $ $ $ $ $ $ $ $ 98,530,070 73,002,053 56,180,109 22,203,187 249,915,420 97,665,601 70,910,845 52,912,900 22,268,092 243,757,438 $ $ 100,257,238 71,054,159 53,405,899 22,268,092 246,985,388 $ $ 102,152,332 71,211,448 53,480,894 22,268,092 249,112,766 104,083,275 71,436,731 58,955,920 22,268,092 256,744,018 $ $ $ 548,822 986,896 1,060,108 239,626 698,514 396,312 34,552 593,987 1,607,122 324,236 221,889 6,712,065 555,852 1,040,758 989,230 240,866 508,407 369,490 35,931 703,872 1,519,090 312,524 190,300 6,466,316 555,852 1,040,758 989,230 240,866 508,407 369,490 35,931 703,872 1,519,090 312,524 190,300 6,466,316 555,852 1,040,758 989,230 240,866 508,407 369,490 35,931 703,872 1,519,090 312,524 190,300 6,466,316 555,852 1,040,758 989,230 240,866 508,407 369,490 35,931 703,872 1,519,090 312,524 190,300 6,466,316 $ $ $ $ $ $ 106,051,705 71,699,612 59,040,672 22,268,092 259,060,081 $ $ $ 555,852 1,040,758 989,230 240,866 508,407 369,490 35,931 703,872 1,519,090 312,524 190,300 6,466,316 Total All Customers $ 256,627,485 $ 250,223,754 $ 253,451,704 $ 255,579,082 $ 263,210,334 $ 265,526,397 Industrial Waste Surcharge $9,187,692 $9,279,564 $9,372,360 $9,466,080 $9,560,736 $9,656,340 Grand Total $ 265,815,176 $ 259,503,318 $ 262,824,064 $ 265,045,162 $ 272,771,070 $ 275,182,737 9,186,426,200 9,192,969,590 7,900,894,700 8,018,299,500 6,226,529,500 6,403,986,000 2,789,975,900 2,789,198,550 26,226,997,140 25,819,342,900 26,085,266,200 26,281,282,800 9,016,008,900 7,883,453,800 6,395,827,600 2,789,975,900 8,774,144,600 7,867,553,200 6,387,669,200 2,789,975,900 9,360,072,700 7,925,890,000 6,413,556,600 2,789,975,900 26,489,495,200 9,537,094,600 7,955,056,900 6,422,776,200 2,789,975,900 26,704,903,600 97,286,700 246,329,200 246,802,200 42,240,300 94,927,961 69,233,500 8,650,700 156,280,000 375,351,200 57,062,000 39,181,200 1,433,344,961 98,533,000 246,042,000 238,339,000 42,459,000 95,184,000 64,536,000 8,997,000 185,197,000 366,900,000 55,000,000 33,600,000 1,434,787,000 98,533,000 246,042,000 238,339,000 42,459,000 95,184,000 64,536,000 8,997,000 185,197,000 366,900,000 55,000,000 33,600,000 1,434,787,000 98,533,000 246,042,000 238,339,000 42,459,000 95,184,000 64,536,000 8,997,000 185,197,000 366,900,000 55,000,000 33,600,000 1,434,787,000 98,533,000 246,042,000 238,339,000 42,459,000 95,184,000 64,536,000 8,997,000 185,197,000 366,900,000 55,000,000 33,600,000 1,434,787,000 98,533,000 246,042,000 238,339,000 42,459,000 95,184,000 64,536,000 8,997,000 185,197,000 366,900,000 55,000,000 33,600,000 1,434,787,000 All Customers Flow 27,660,342,101 27,254,129,900 27,520,053,200 27,716,069,800 27,924,282,200 28,139,690,600 214,009 5,281 12,514 6 231,810 218,054 5,288 12,527 6 235,875 222,177 5,299 12,543 6 240,025 226,376 5,311 12,559 6 244,252 230,655 5,328 12,578 6 248,567 235,018 5,348 12,596 6 252,968 Wholesale Customers 11 11 11 11 11 11 Total Customers 231,821 235,886 240,036 244,263 248,578 252,979 Retail Customers Single Family Multifamily Commercial Large Volume Subtotal Retail Wholesale Customers Manor, City of North Austin MUD Northtown MUD Rollingwood, City of Shady Hollow Sunset Valley, City of WCID-17 Comanche Canyon WCID-17 Steiner Ranch Wells Branch MUD Westlake Hills, City of Mid-Tex Utilities (Avana Sub) Subtotal Wholesale A/R Adjustments Retail Customers Single Family Multifamily Commercial Large Volume Subtotal Retail Wholesale Customers Manor, City of North Austin MUD Northtown MUD Rollingwood, City of Shady Hollow Sunset Valley, City of WCID-17 Comanche Canyon WCID-17 Steiner Ranch Wells Branch MUD Westlake Hills, City of Mid-Tex Utilities (Avana Sub) Subtotal Wholesale Average Accounts Retail Customers Single Family Multifamily Commercial Large Volume Subtotal Retail PDF Page 19Projected Revenue Total Projected Revenue Projected Consumption Total ProjectedConsumption Reclaimed Water Revenue Forecast Estimated 2021 2,295,990 Year 1 2022 2,423,906 Year 2 2023 2,427,184 Year 3 2024 2,429,702 Year 4 2025 2,433,006 Year 5 2026 2,436,321 1,111,879,300 1,132,327,300 1,134,023,500 1,135,322,100 1,137,030,300 1,138,745,000 PDF Page 20