B2 — original pdf

Backup

Document 2 Water and Wastewater Commission Budget Subcommittee Meeting May 24, 2021 Financial Status Report – March 2021 Fund Summaries PDF Page 3City of Austin, Texas Austin Water FUND SUMMARY - COMBINED As of March 2021 2020-21 APPROVED 206,438,075 BUDGET ALLOTMENT 206,438,075 MTD ACTUAL W/ ENCUMB - YTD ACTUAL W/ ENCUMB 231,033,206 YTD VARIANCE 24,595,131 % VARIANCE 11.9% 294,768,529 256,694,995 2,070,857 4,526,636 2,298,108 4,132,769 797,800 875,400 0 120,300 64,800 191,000 1,462,200 568,003,394 127,422,431 120,780,251 924,181 2,263,318 874,219 2,066,385 398,900 437,702 0 60,148 32,402 95,498 731,102 256,086,536 35,000,000 5,049,476 5,750,000 300,582 74,884 46,174,942 0 2,524,738 2,875,000 300,582 74,884 5,775,204 20,591,705 24,714,730 165,411 (1,556,301) 177,765 40,713 71,235 0 32,457 0 11,000 485 90,311 44,339,512 0 605,207 475,417 0 0 1,080,624 130,614,281 127,263,650 956,981 5,100,054 994,098 495,269 415,945 323,895 32,457 0 33,000 15,562 593,606 266,838,798 0 3,229,159 2,852,502 300,582 74,884 6,457,127 3,191,851 6,483,399 32,800 2,836,736 119,879 (1,571,116) 17,045 (113,807) 32,457 (60,148) 598 (79,936) (137,496) 10,752,262 0 704,421 (22,498) 0 0 681,923 614,178,336 261,861,740 45,420,136 273,295,925 11,434,184 147,508,573 75,740,318 11,972,104 70,439,385 44,387,823 23,300,471 2,725,924 20,728,203 14,281,421 7,638,732 773,293 7,871,042 5,300,934 2,572,269 (232,310) 19,902,524 9,850,780 1,174,853 9,221,770 629,010 9,955,690 589,272 236,625,303 6,120,825 295,732 122,946,860 1,774,390 43,822 18,464,385 9,196,629 289,837 117,746,866 (3,075,804) 5,895 5,199,994 19,825,622 9,912,811 1,652,135 9,912,811 808,610 404,305 294,467 241,059 75,000 21,244,758 0 120,528 75,000 10,512,644 0 20,088 0 1,672,223 0 0 120,528 75,000 10,108,339 164,491,870 78,024,860 11,741,934 77,414,877 3,799,500 2,625,776 554,236 2,626,897 1,288,699 669,724 644,350 334,862 3,408,500 1,704,250 72,380 173,658,293 83,334,098 12,368,550 80,812,403 0 0 0 46,544,409 40,000,000 35,000,000 29,000,000 0 13,984,357 2,069,687 3,816,719 5,750,000 3,726,094 2,656,300 966,723 750,000 500,599 19,834 184,784,722 23,272,205 18,821,000 0 12,535,000 0 6,992,178 923,659 1,909,790 2,852,502 1,886,354 1,328,151 483,360 286,000 250,298 19,834 71,560,329 3,878,701 3,072,000 0 1,937,000 0 1,165,363 165,411 317,821 475,417 306,623 221,358 80,560 39,000 41,716 0 11,700,971 644,346 72,380 53,903 23,272,205 18,821,000 0 12,535,000 0 6,992,178 923,378 1,909,790 2,852,502 1,886,354 1,328,150 483,360 286,000 250,298 19,834 71,560,047 (0) 404,305 0 0 0 404,305 609,983 (1,121) 4 262,482 1,650,347 2,521,695 0 0 0 0 0 0 281 0 0 0 1 0 0 0 0 282 2.5% 5.4% 3.5% 125.3% 13.7% -76.0% 4.3% -26.0% 0.0% -100.0% 1.8% -83.7% (0) 4.2% 0.0% 27.9% -0.8% 0.0% 0.0% 11.8% 4.4% 7.0% 11.0% -3.0% 6.4% -50.3% 2.0% 4.2% 0.0% 100.0% 0.0% 0.0% 0.0% 3.8% 0.8% 0.0% 0.0% 78.4% 96.8% 3.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 2.8% BEGINNING BALANCE REVENUE Water Revenue Wastewater Revenue Reserve Fund Surcharge Other Revenue Reclaimed Revenue Interest Public Health Licenses, Permits, Inspections Other Fines Miscellaneous Franchise Fees Building Rental/Lease Land & Infrastructure Rental/Lease Scrap Sales Development Fees Total Revenue TRANSFERS IN CIP Community Benefit Charge Fund Austin Water Utility Fund Support Services/Infrastructure Funds Austin Resource Recovery Fund Total Transfers In TOTAL AVAILABLE FUNDS PROGRAM REQUIREMENTS Operations Support Services Engineering Services Environmental, Planning & Development Services Other Utility Program Requirements Reclaimed Water Services Total Program Requirements OTHER REQUIREMENTS Utility Billing System Support Supplemental Retirement Contribution Accrued Payroll Interdepartmental Charges Trf to PID Fund Total Other Requirements DEBT SERVICE REQUIREMENTS Trf to Util D/S Separate Lien Trf to Utility D/S Sub Lien Trf to GO Debt Service Trf to Util D/S Tax/Rev Bonds Commercial paper interest Total Debt Service Requirements TRANSFERS OUT Trf to General Fund Trf to Wastewater CIP Fund TRF CRF to Debt Defeasance Trf to Water CIP Fund TRF Operating to Debt Defeasance Administrative Support Trf to Water Revenue Stab Rsv CTM Support Trf to Reclaimed Water Fund Trf to Economic Development Trf to CIP Mgm - CPM (5460) Workers' Compensation Trf to Reclaimed Water CIP Fnd Regional Radio System CTECC Support Total Transfers Out TOTAL REQUIREMENTS EXCESS (DEFICIENCY) OF TOTAL AVAILABLE FUNDS OVER TOTAL REQUIREMENTS ENDING BALANCE 616,313,076 288,353,931 44,206,129 280,227,655 8,126,275 (2,134,740) (26,492,190) 1,214,007 (6,931,730) 19,560,460 73.8% 204,303,335 179,945,885 1,214,007 224,101,476 44,155,591 24.5% Note: Numbers above may not add due to rounding. DEBT SERVICE COVERAGE RATIO 1.72 1.40 1.62 PDF Page 4Environmental, Planning, and Development Services 14,335,708 7,225,312 784,972 6,487,449 737,863 City of Austin, Texas Austin Water FUND SUMMARY - WATER As of March 2021 2020-21 APPROVED 105,722,653 BUDGET ALLOTMENT 105,722,653 MTD ACTUAL W/ ENCUMB - YTD ACTUAL W/ ENCUMB 121,731,184 YTD VARIANCE 16,008,531 % VARIANCE 15.1% 294,768,529 2,070,857 1,877,100 1,460,100 875,400 2,109,652 0 64,800 60,500 71,200 146,300 303,504,438 26,000,000 2,890,731 150,291 29,041,022 127,422,431 924,181 938,550 730,052 437,702 1,054,826 0 32,402 30,250 35,600 73,148 0 131,679,142 0 1,445,366 150,291 1,595,657 20,591,705 165,411 (1,721,798) 90,311 0 20,423 32,457 11,000 0 7,356 243 0 19,197,108 0 322,522 0 322,522 130,614,281 956,981 (134,492) 592,517 323,895 253,952 32,457 33,000 0 38,719 7,781 0 132,719,091 0 1,790,670 150,291 1,940,961 3,191,851 32,800 (1,073,042) (137,535) (113,807) (800,874) 32,457 598 (30,250) 3,119 (65,367) 0 1,039,950 0 345,305 0 345,305 332,545,460 133,274,798 19,519,630 134,660,052 1,385,254 75,846,970 25,715,157 38,579,958 13,619,507 6,726,706 1,591,373 36,173,628 11,980,622 2,406,329 1,638,885 5,676,663 5,267,413 126,841,911 3,085,909 3,359,871 65,870,557 397,258 1,326,932 10,827,240 2,602,526 5,495,176 62,739,402 483,383 (2,135,305) 3,131,155 11,799,072 418,301 173,379 120,530 37,500 12,548,782 86,074,651 1,837,700 598,021 247,825 1,883,800 90,641,997 29,000,000 26,000,000 24,419,493 0 7,910,413 5,750,000 1,924,875 1,974,816 2,069,687 963,102 483,362 250,300 9,917 100,755,965 5,899,536 209,151 0 60,264 37,500 6,206,450 41,860,847 1,269,997 299,011 123,913 941,900 44,495,667 12,535,000 0 12,209,747 0 3,955,206 2,852,502 962,438 987,408 923,659 481,551 241,680 125,148 9,917 35,284,255 983,256 0 0 10,044 0 993,300 6,397,077 268,017 0 26,784 0 6,691,878 1,937,000 0 2,034,958 0 659,201 475,417 160,406 164,568 165,411 80,259 40,280 20,858 0 5,738,358 5,899,536 0 0 60,264 37,500 5,997,300 41,347,293 1,270,518 299,008 26,784 25,104 42,968,706 12,535,000 0 12,209,747 0 3,955,206 2,852,502 962,438 987,408 923,378 481,551 241,680 125,148 9,917 35,283,974 (0) 209,151 0 0 0 209,150 513,555 (521) 3 97,129 916,796 1,526,961 0 0 0 0 0 0 0 0 281 0 0 0 0 281 330,788,655 151,856,929 24,250,776 146,989,382 4,867,547 2.5% 3.5% -114.3% -18.8% -26.0% -75.9% 0.0% 1.8% -100.0% 8.8% -89.4% 0.0% 0.8% 0.0% 23.9% 0.0% 21.6% 1.0% 6.2% 12.0% 10.2% 15.7% -63.6% 4.8% 0.0% 100.0% 0.0% 0.0% 0.0% 3.4% 1.2% 0.0% 0.0% 78.4% 97.3% 3.4% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 3.2% BEGINNING BALANCE REVENUE Water Revenue Reserve Fund Surcharge Other Revenue Development Fees Other Fines Interest Miscellaneous Franchise Fees Land & Infrastructure Rental/Lease Building Rental/Lease Public Health Licenses, Permits, Inspections Scrap Sales Parking Revenue Total Revenue P TRANSFERS IN A CIP Community Benefit Charge Fund Support Services/Infrastructure Funds Total Transfers In TOTAL AVAILABLE FUNDS PROGRAM REQUIREMENTS Operations Support Services Engineering Services Other Utility Program Requirements Total Program Requirements OTHER REQUIREMENTS Utility Billing System Support Supplemental Retirement Contribution Accrued Payroll Interdepartmental Charges Trf to PID Fund Total Other Requirements In S DEBT SERVICE REQUIREMENTS T Trf to Util D/S Separate Lien Tfr to Utility D/S Sub Lien Trf to GO Debt Service Tfr to Util D/S Tax/Rev Bonds Commercial paper interest Total Debt Service Requirements TRANSFERS OUT Trf to Water CIP Fund TRF CRF to Debt Defeasance Trf to General Fund TRF Operating to Debt Defeasance Administrative Support Trf to Reclaimed Water Fund CTM Support Trf to Economic Development Trf to Water Revenue Stab Rsv Trf to CIP Mgm - CPM (5460) Workers' Compensation Regional Radio System CTECC Support Total Transfers Out TOTAL REQUIREMENTS EXCESS (DEFICIENCY) OF TOTAL AVAILABLE FUNDS OVER TOTAL REQUIREMENTS ENDING BALANCE Note: Numbers above may not add due to rounding. 1,756,805 (18,582,131) (4,731,146) (12,329,329) 6,252,802 33.6% 107,479,458 87,140,522 (4,731,146) 109,401,855 22,261,333 25.5% DEBT SERVICE COVERAGE RATIO 1.73 1.25 1.37 PDF Page 5BEGINNING BALANCE REVENUE P Wastewater Revenue Other Revenue Interest Public Health Licenses, Permits, Inspections Building Rental/Lease Scrap Sales Development Fees Total Revenue TRANSFERS IN A CIP Community Benefit Charge Fund Support Services/Infrastructure Funds Austin Resource Recovery Fund Total Transfers In TOTAL AVAILABLE FUNDS PROGRAM REQUIREMENTS Operations Support Services Engineering Services Other Utility Program Requirements Environmental, Planning, and Development Services Total Program Requirements OTHER REQUIREMENTS Utility Billing System Support Supplemental Retirement Contribution Accrued Payroll Interdepartmental Charges Trf to PID Fund Total Other Requirements In S DEBT SERVICE REQUIREMENTS T T C T T 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 Wastewater CIP Fund Trf to General Fund TRF CRF to Debt Defeasance TRF Operating to Debt Defeasance Administrative Support CTM Support Trf to Economic Development Trf to CIP Mgm - CPM (5460) Workers' Compensation Regional Radio System CTECC Support Total Transfers Out City of Austin, Texas Austin Water FUND SUMMARY - WASTEWATER As of March 2021 2020-2021 BUDGET MTD ACTUAL YTD ACTUAL YTD APPROVED ALLOTMENT W/ ENCUMB W/ ENCUMB VARIANCE % VARIANCE 97,567,843 97,567,843 - 105,917,346 8,349,503 8.6% 273,536,986 124,813,832 25,246,502 134,776,129 9,962,297 256,694,995 2,649,536 1,975,335 726,600 59,800 44,700 2,100 262,153,066 120,780,251 1,324,768 987,668 363,300 29,898 22,350 1,050 123,509,285 9,000,000 2,158,745 150,291 74,884 11,383,920 0 1,079,373 150,291 74,884 1,304,548 24,714,730 165,396 19,569 63,879 0 243 0 24,963,817 0 282,685 0 0 282,685 127,263,650 5,229,015 233,705 377,226 0 7,781 1,089 133,112,465 0 1,438,489 150,291 74,884 1,663,664 71,661,603 18,672,666 8,604,758 4,657,311 5,566,816 109,163,154 37,160,361 9,680,964 4,552,823 2,745,812 2,625,468 56,765,429 8,026,550 386,642 120,251 120,529 37,500 8,691,472 73,033,210 1,961,800 1,244,200 690,678 421,899 77,351,787 40,000,000 21,945,962 9,000,000 0 5,932,677 1,888,982 1,704,662 1,477,597 483,361 250,299 9,917 82,693,457 4,013,275 193,321 0 60,264 37,500 4,304,360 33,983,596 1,355,779 622,100 345,339 210,950 36,517,763 18,821,000 10,972,980 0 0 2,966,339 944,490 852,330 738,799 241,680 125,150 9,917 35,672,684 5,245,398 1,134,551 376,035 438,986 389,881 7,584,850 668,879 0 0 10,044 0 678,923 5,056,689 286,218 0 0 45,597 5,388,504 3,072,000 1,828,830 0 0 494,390 157,415 142,055 123,133 40,280 20,858 0 5,878,961 34,265,756 8,747,581 5,268,516 3,680,255 2,734,321 54,696,430 4,013,275 0 0 60,264 37,500 4,111,039 33,927,473 1,356,379 25,477 345,338 45,597 35,700,263 18,821,000 10,972,980 0 0 2,966,339 944,490 852,330 738,798 241,680 125,150 9,917 35,672,683 6,483,399 3,904,247 (753,963) 13,926 (29,898) (14,569) 39 9,603,181 0 359,116 0 0 359,116 2,894,605 933,384 (715,693) (934,443) (108,853) 2,068,999 (0) 193,321 0 0 0 193,321 56,123 (600) 596,623 1 165,353 817,500 0 0 0 0 0 0 0 1 0 0 0 1 5.4% 294.7% -76.3% 3.8% -100.0% -65.2% 3.7% 7.8% 0.0% 33.3% 0.0% 0.0% 27.5% 8.0% 7.8% 9.6% -15.7% -34.0% -4.1% 3.6% 0.0% 100.0% 0.0% 0.0% 0.0% 4.5% 0.2% 0.0% 95.9% 0.0% 78.4% 2.2% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 2.3% TOTAL REQUIREMENTS EXCESS (DEFICIENCY) OF TOTAL AVAILABLE FUNDS OVER TOTAL REQUIREMENTS 277,899,870 133,260,236 19,531,238 130,180,415 3,079,821 (4,362,884) (8,446,404) 5,715,264 4,595,714 13,042,118 154.41% ENDING BALANCE 93,204,959 89,121,439 5,715,264 110,513,060 21,391,621 24.0% Note: Numbers above may not add due to rounding. DEBT SERVICE COVERAGE RATIO 1.82 1.65 2.00 PDF Page 6BEGINNING BALANCE REVENUE Reclaimed Services Interest Other Revenue Total Revenue TRANSFERS IN A Austin Water Utility Total Transfers In TOTAL AVAILABLE FUNDS PROGRAM REQUIREMENTS Reclaimed Water Services Other Utility Program Requirements Total Program Requirements OTHER REQUIREMENTS In Accrued Payroll Supplemental Retirement Contribution Total Other Requirements DEBT SERVICE REQUIREMENTS T C Trf to Util D/S Separate Lien Commercial paper interest Total Debt Service Requirements TRANSFERS OUT T T Trf to Reclaimed Water CIP Fnd Trf to CIP Mgm - CPM (5460) Trf to General Fund Administrative Support Trf to Economic Development CTM Support Total Transfers Out City of Austin, Texas Austin Water FUND SUMMARY - RECLAIMED As of March 2021 2020-2021 BUDGET MTD ACTUAL YTD ACTUAL YTD APPROVED ALLOTMENT W/ ENCUMB W/ ENCUMB VARIANCE % VARIANCE 3,147,579 3,147,579 0 3,384,676 237,097 7.5% 2,298,108 47,782 0 2,345,890 5,750,000 5,750,000 8,095,890 589,272 30,966 620,238 837 3,667 4,504 5,384,009 280,500 5,664,509 750,000 215,601 178,954 141,267 46,616 2,862 1,335,300 874,219 23,891 0 898,110 2,875,000 2,875,000 3,773,110 295,732 15,142 310,874 0 1,834 1,834 2,180,418 140,250 2,320,668 286,000 107,801 89,478 70,634 46,616 2,862 603,390 177,765 721 100 178,586 475,417 475,417 654,003 43,822 8,472 52,294 0 0 0 288,169 0 288,169 39,000 17,967 14,913 11,772 0 0 83,652 994,098 7,612 5,532 1,007,241 2,852,502 2,852,502 3,859,743 289,837 21,198 311,035 0 0 0 2,140,111 3,322 2,143,433 286,000 107,801 89,478 70,634 46,616 2,862 603,390 119,879 (16,279) 5,532 109,131 (22,498) (22,498) 86,633 5,895 (6,056) (160) 0 1,834 1,834 40,306 136,928 177,234 0 0 0 0 0 0 0 13.7% -68.1% 0.0% 12.2% -0.8% -0.8% 2.3% 2.0% -40.0% -0.1% 0.0% 100.0% 100.0% 1.8% 97.6% 7.6% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 5.5% TOTAL REQUIREMENTS EXCESS (DEFICIENCY) OF TOTAL AVAILABLE FUNDS OVER TOTAL REQUIREMENTS 7,624,551 3,236,765 424,115 3,057,858 178,907 471,339 536,345 229,888 801,885 265,540 49.5% ENDING BALANCE 3,618,918 3,683,924 229,888 4,186,561 502,637 13.6% Note: Numbers above may not add due to rounding. DEBT SERVICE COVERAGE RATIO 0.28 0.21 0.27 PDF Page 7