AW Revised Budget Summary — original pdf

Backup

Austin Water Revised Revenue Budget Summary COMBINED WATER & WASTEWATER REVENUES Budget Submission May 2020 CYE FY21 Revised Budget CYE FY21 Variance in Revenue CYE FY21 Residential Multifamily Commercial $ $ $ 211,673,294 141,827,891 137,307,735 $ $ $ 218,278,348 137,112,442 144,979,127 214,690,857 $ 138,420,793 $ 117,476,077 $ 222,161,427 $ 130,532,275 $ 130,688,957 $ $ $ $ $ 3,017,563 (3,407,098) (19,831,658) (20,221,193) $ $ $ $ 3,883,079 (6,580,167) (14,290,170) (16,987,258) Increase Decrease Decrease Total Variance 1CYE Residential Revenue Forecast- REVISED BUDGET Water 2019-20 CYE Reduction % Reduction Revenue w/reduction 2019-20 CYE Reduction % Reduction Revenue w/reduction Wastewater October 15,126,017 November 10,072,802 December 8,250,120 January 7,964,213 February 6,858,922 March 6,930,381 April 7,639,572 May 9,394,867 June July 10,067,821 13,121,438 August 15,169,316 September 13,925,599 Total 124,521,068 - $ $ - $ - $ - $ - - $ $ - $ - $ - $ - $ - $ - $ - 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% $ 15,126,017 $ 10,072,802 $ 8,250,120 $ 7,964,213 $ 6,858,922 $ 6,930,381 $ 7,639,572 $ 9,394,867 $ 10,067,821 $ 13,121,438 $ 15,169,316 13,925,599 May 2020 Budget Submittal $ $ $ 124,521,068 124,667,604 October 7,677,864 November 7,324,988 December 7,228,556 January 7,225,881 February 6,928,563 March 6,994,665 April 7,547,009 May 7,478,944 June 7,728,976 July 7,936,687 August 8,408,726 September 7,688,930 Total 90,169,789 - $ $ - $ - $ - $ - - $ $ - $ - $ - $ - $ - $ - $ - 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% $ 7,677,864 $ 7,324,988 $ 7,228,556 $ 7,225,881 $ 6,928,563 $ 6,994,665 $ 7,547,009 $ 7,478,944 $ 7,728,976 $ 7,936,687 $ 8,408,726 7,688,930 May 2020 Budget Submittal $ $ $ 90,169,789 87,005,690 2019-20 CYE Total Combined Revenue Total Combined Reduction Total Combined Revenue w/Reduction 214,690,857 $ - $ 214,690,857 May 2020 Budget Submittal Increased Revenue from May 2020 Budget Submittal $ 211,673,294 $ 3,017,563 2CYE Multifamily Revenue Forecast-REVISED BUDGET Water 2019-20 CYE Reduction % Reduction Revenue w/reduction Wastewater 2019-20 CYE Reduction % Reduction Revenue w/reduction $ $ October 5,771,999 November 4,863,671 December 4,510,433 January 4,771,629 February 4,188,711 March 4,246,267 April May 4,502,536 4,535,737 June 5,838,549 July 6,084,121 August 6,376,798 September 6,633,301 Total 62,323,753 - $ 0% - $ 0% - $ 0% - - $ 0% 0% 0% 0% 0% 0% $ - $ - $ 0% - $ 0% - $ 0% $ 5,771,999 $ 4,863,671 $ 4,510,433 $ 4,771,629 $ 4,188,711 $ 4,246,267 $ 4,502,536 $ 4,535,737 $ 5,838,549 $ 6,084,121 6,376,798 $ 6,633,301 May 2020 Budget Submittal $ $ $ 62,323,753 64,101,256 October 6,307,377 November 5,871,709 December 5,973,666 January 11,016,849 February 5,991,445 March 5,966,089 April May 6,369,427 6,204,581 June 5,529,044 July 5,636,364 August 5,641,706 September 5,588,783 Total 76,097,040 - $ 0% - $ 0% - $ 0% - $ 0% - $ 0% - $ 0% - $ 0% - $ 0% - $ 0% - $ 0% - $ 0% - $ 0% $ 6,307,377 $ 5,871,709 $ 5,973,666 $ 11,016,849 $ 5,991,445 $ 5,966,089 $ 6,369,427 $ 6,204,581 $ 5,529,044 $ 5,636,364 - - - 5,641,706 $ 5,588,783 May 2020 Budget Submittal $ $ $ 76,097,040 77,726,635 2019-20 CYE Total Combined Revenue 138,420,793 Total Combined Reduction $ Total Combined Revenue w/Reduction $ 138,420,793 May 2020 Budget Submittal Reduced Revenue from May 2020 Budget Submittal $ 141,827,891 $ (3,407,098) 3CYE Commercial Revenue Forecast- REVISED BUDGET Water Fiscal Year 2019-20 CYE Total Revenue Reduction Revenue w/reduction % Reduction Wastewater Fiscal Year 2019-20 CYE Total Revenue Reduction Revenue w/reduction % Reduction October November December January February March April May June July August September Total 8,206,246 6,572,239 5,515,791 5,220,115 5,098,920 5,077,697 4,398,790 4,585,835 $ - $ - $ - $ - $ - $ - $ - $ - 6,841,518 1,778,795 $ 7,756,501 1,861,560 $ 8,361,676 1,839,569 $ 8,542,246 1,708,449 $ 76,177,574 7,188,373 $ $ 8,206,246 0% $ 6,572,239 0% $ 5,515,791 0% $ 5,220,115 0% $ 5,098,920 0% $ 5,077,697 0% $ 4,398,790 0% $ 4,585,835 0% $ 5,062,723 26% $ 5,894,941 24% $ $ 6,522,107 22% 6,833,797 20% May 2020 Budget Submittal $ 68,989,201 $ 79,307,703 October November December January February March April May June July August September Total 5,509,149 5,221,362 4,949,844 179,600 4,858,359 4,898,460 3,767,666 3,502,450 $ - $ - $ - $ - $ - $ - $ - $ - 5,250,104 1,785,035 $ 5,202,924 1,560,877 $ 5,595,355 1,398,839 $ 5,370,443 1,074,089 $ 54,305,716 5,818,840 $ $ 5,509,149 0% $ 5,221,362 0% $ 4,949,844 0% $ 179,600 0% $ 4,858,359 0% $ 4,898,460 0% $ 3,767,666 0% $ 3,502,450 0% $ 3,465,069 34% $ 3,642,047 30% $ $ 4,196,516 25% 4,296,354 20% May 2020 Budget Submittal $ 48,486,876 $ 58,000,032 2019-20 CYE Total Combined Revenue Total Combined Reduction 130,483,290 13,007,213 $ Total Updated Combined Revenue w/Reduction $ 117,476,077 May 2020 Budget Submittal Total Updated Combined Revenue w/Reduction and May 2020 Budget $ 137,307,735 $ (19,831,658) 4FY21 Residential Revenue Forecast- REVISED BUDGET Water 2020-21 Reduction % Reduction Revenue w/reduction 2020-21 Reduction % Reduction Revenue w/reduction Wastewater October 10,761,921 November 9,369,661 December 7,893,543 January 8,268,097 February 7,123,926 March 7,493,108 April 8,692,592 May June July 9,447,814 10,668,271 13,349,347 August 17,011,846 September 15,264,515 Total 125,344,641 - $ $ - $ - $ - $ - - $ $ - $ - $ - $ - $ - $ - $ - 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% $ 10,761,921 $ 9,369,661 $ 7,893,543 $ 8,268,097 $ 7,123,926 $ 7,493,108 $ 8,692,592 $ 9,447,814 $ 10,668,271 $ 13,349,347 $ 17,011,846 15,264,515 May 2020 Budget Submittal $ $ $ 125,344,641 125,961,303 October 7,762,647 November 7,867,742 December 7,741,233 January 7,916,831 February 7,742,068 March 7,777,946 April 8,449,323 May 8,268,627 June 8,290,547 July 8,380,975 August 8,745,432 September 7,873,415 Total 96,816,786 - $ $ - $ - $ - $ - - $ $ - $ - $ - $ - $ - $ - $ - 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% $ 7,762,647 $ 7,867,742 $ 7,741,233 $ 7,916,831 $ 7,742,068 $ 7,777,946 $ 8,449,323 $ 8,268,627 $ 8,290,547 $ 8,380,975 $ 8,745,432 7,873,415 May 2020 Budget Submittal $ $ $ 96,816,786 92,317,045 2020-21 Total Combined Revenue Total Combined Reduction Total Combined Revenue w/Reduction 222,161,427 $ - $ 222,161,427 May 2020 Budget Submittal Increased Revenue from May 2020 Budget Submittal $ 218,278,348 $ 3,883,079 5FY21 Multifamily Revenue Forecast- REVISED BUDGET Water 2020-21 Reduction % Reduction Revenue w/reduction 2020-21 Reduction % Reduction Revenue w/reduction Wastewater October 5,721,706 November 5,220,417 December 5,013,543 January 5,131,680 February 4,770,625 March 4,883,623 April 5,047,052 May 5,098,465 June 5,338,494 July 5,894,258 August 6,182,875 September 6,313,462 Total 64,616,200 - $ $ - $ - $ - $ - - $ $ - $ - $ - $ - $ - $ - $ - 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% $ 5,721,706 $ 5,220,417 $ 5,013,543 $ 5,131,680 $ 4,770,625 $ 4,883,623 $ 5,047,052 $ 5,098,465 $ 5,338,494 $ 5,894,258 $ 6,182,875 6,313,462 May 2020 Budget Submittal $ $ $ 64,616,200 64,449,412 October 5,503,424 November 4,962,673 December 5,189,685 January 4,924,221 February 5,189,182 March 4,668,923 April 6,038,768 May 5,837,811 June 5,827,572 July 5,940,092 August 5,945,721 September 5,888,003 Total 65,916,075 - $ $ - $ - $ - $ - - $ $ - $ - $ - $ - $ - $ - $ - 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% $ 5,503,424 $ 4,962,673 $ 5,189,685 $ 4,924,221 $ 5,189,182 $ 4,668,923 $ 6,038,768 $ 5,837,811 $ 5,827,572 $ 5,940,092 $ 5,945,721 5,888,003 May 2020 Budget Submittal $ $ $ 65,916,075 72,663,030 2020-21 Total Combined Revenue Total Combined Reduction Total Combined Revenue w/Reduction 130,532,275 $ - $ 130,532,275 May 2020 Budget Submittal Reduced Revenue from May 2020 Budget Submittal $ 137,112,442 $ (6,580,167) 6FY2021 Commercial Revenue Forecast- REVISED BUDGET Water Fiscal Year 2020-21 Total Revenue Reduction Revenue w/reduction % Reduction Wastewater Fiscal Year 2020-21 Total Revenue Reduction Revenue w/reduction % Reduction October November December January February March April May June July August September Total 7,421,296 1,187,407 $ 6,351,899 889,266 $ 5,669,207 680,305 $ 5,412,316 541,232 $ 5,105,057 408,405 $ 5,453,098 327,186 $ 5,835,658 233,426 $ 6,180,646 123,613 $ 6,823,194 136,464 $ 7,741,159 154,823 $ 8,341,386 166,828 $ 8,554,940 171,099 $ $ $ 78,889,856 5,020,053 $ 6,233,889 16% $ 5,462,633 14% $ 4,988,902 12% $ 4,871,084 10% $ 4,696,652 8% $ 5,125,912 6% $ 5,602,232 4% $ 6,057,033 2% $ 6,686,730 2% $ 7,586,336 2% $ $ 8,174,558 2% 8,383,841 2% May 2020 Budget Submittal $ 73,869,803 $ 79,040,606 October November December January February March April May June July August September Total 5,042,875 806,860 $ 4,871,958 682,074 $ 4,589,299 550,716 $ 4,615,851 461,585 $ 4,603,999 368,320 $ 4,572,452 274,347 $ 5,268,453 210,738 $ 5,245,210 104,904 $ 5,369,443 107,389 $ 5,321,408 106,428 $ 5,722,958 114,459 $ 5,492,927 109,859 $ $ $ 60,716,833 3,897,679 $ 4,236,015 16% $ 4,189,884 14% $ 4,038,583 12% $ 4,154,266 10% $ 4,235,679 8% $ 4,298,105 6% $ 5,057,715 4% $ 5,140,306 2% $ 5,262,054 2% $ 5,214,980 2% $ $ 5,608,499 2% 5,383,068 2% May 2020 Budget Submittal $ 56,819,154 $ 65,938,521 2020-21 Total Combined Revenue Total Combined Reduction Total Combined Revenue w/Reduction 139,606,689 8,917,732 130,688,957 $ $ (rounded $3.6M) May 2020 Budget Submittal Total Updated Combined Revenue w/Reduction and May 2020 Budget $ 144,979,127 $ (14,290,170) 7