Item 7_Fund Summary — original pdf

Backup

TOTAL AVAILABLE FUNDS 1,416,019,237 1,416,019,237 146,181,753 1,288,070,726 1,288,070,726 -127,948,511 (9.0%) AUSTIN ENERGY FUND For the Fiscal Year Through September 30, 2021 BEGINNING BALANCE REVENUE Base Revenue Power Supply Revenue Community Benefit Revenue Regulatory Revenue Transmission Revenue Other Revenue Interest Income TOTAL REVENUE OPERATING REQUIREMENTS Power Supply Recoverable Expenses Non-Fuel Operations & Maintenance Conservation Conservation Rebates Other Operating Expenses TOTAL OPERATING REQUIREMENTS OTHER REQUIREMENTS Accrued Payroll TOTAL OTHER REQUIREMENTS DEBT SERVICE General Obligation Debt Service Current Year Capital Lease Debt Service (Principal and Interest) TOTAL DEBT SERVICE TRANSFERS OUT Electric Capital Improvement Program General Fund Contingency Reserve Voluntary Utility Assistance Fund Trunked Radio Workers' Compensation Other City Transfers Administrative Support Communication and Technology Management Fund Economic Development Fund Power Supply Stabilization Reserve Fund AE Capital Reserve Fund TOTAL TRANSFERS OUT EXCESS (DEFICIENCY) OF TOTAL AVAILABLE FUNDS OVER TOTAL REQUIREMENTS Adjustment to GAAP ENDING BALANCE Item 7 (3.7%) (22.4%) (10.7%) 17.0% (2.6%) (27.1%) (73.6%) (9.0%) 24.1% 3.1% (10.7%) 21.6% 15.6% 70.7% 8.9% 0.0% 0 8.9% 8.9% Approved Budget Amended Budget September w/Encumb Year to Date w/Encumb Year-End Estimate Variance Fav (Unfav) % Variance Fav (Unfav) 394,198,543 394,198,543 387,799,387 387,799,387 (6,399,156) (1.6%) 630,532,538 419,011,440 56,477,345 140,841,730 86,229,397 73,720,823 9,205,964 1,416,019,237 630,532,538 419,011,440 56,477,345 140,841,730 86,229,397 73,720,823 9,205,964 1,416,019,237 68,605,296 46,051,116 5,970,654 14,278,189 7,018,047 4,110,679 147,771 146,181,753 607,315,909 325,224,839 50,461,746 164,849,014 84,029,342 53,763,463 2,426,413 1,288,070,726 607,315,909 325,224,839 50,461,746 164,849,014 84,029,342 53,763,463 2,426,413 1,288,070,726 (23,216,629) (93,786,601) (6,015,599) 24,007,284 (2,200,055) (19,957,360) (6,779,551) (127,948,511) 359,440,629 161,340,559 428,634,606 15,583,565 22,426,910 56,591,854 1,044,018,123 359,440,629 161,340,559 428,634,606 15,587,615 23,588,747 56,591,854 1,045,184,010 38,786,837 13,350,239 45,842,927 1,204,397 3,479,211 10,110,439 112,774,050 272,844,778 156,396,604 474,652,469 12,224,311 19,898,382 16,571,266 952,587,809 272,844,778 156,396,604 474,652,469 12,224,311 19,898,382 16,571,266 952,587,809 86,595,851 4,943,955 (46,017,863) 3,363,304 3,690,365 40,020,589 92,596,201 642,116 642,116 642,116 642,116 642,116 642,116 642,116 642,116 642,116 642,116 0 0 3,990 125,209 157,967,358 158,096,557 3,990 125,209 157,967,358 158,096,557 39,902,889 114,000,000 0 600,000 954,138 1,415,955 3,589,487 31,303,352 13,185,223 8,367,233 0 5,000,000 218,318,277 39,902,889 114,000,000 0 5,600,000 712,490 1,415,955 3,831,135 31,303,352 13,185,223 8,367,233 0 5,000,000 223,318,277 0 138,066 16,916,440 17,054,506 21,511,872 9,500,000 0 0 59,376 117,996 752,200 2,608,609 1,098,764 697,274 0 0 36,346,091 3,988 138,645 157,529,201 157,671,834 3,988 138,645 157,529,201 157,671,834 2 (13,436) 438,157 424,723 0.1% (10.7%) 0.3% 0.3% 143,082,965 114,000,000 0 5,600,000 712,490 1,415,955 3,334,267 31,303,352 13,185,223 8,367,233 0 0 321,001,485 143,082,965 114,000,000 0 5,600,000 712,490 1,415,955 3,334,267 31,303,352 13,185,223 8,367,233 0 0 321,001,485 (103,180,076) 0 0 0 0 0 496,868 0 0 0 0 5,000,000 (97,683,208) (258.6%) 0.0% 0.0% 0.0% 0.0% 0.0% 13.0% 0.0% 0.0% 0.0% 0.0% 100.0% (43.7%) (5,055,836) (11,221,723) (20,635,010) (143,832,518) (143,832,518) (132,610,795) 1181.7% (9,661,789) 389,142,707 382,976,820 234,305,080 243,966,869 (139,009,951) (36.3%) SUBTOTAL BEFORE TRANSFERS 1,044,660,239 1,045,826,126 113,416,166 953,229,925 953,229,925 92,596,201 SUBTOTAL BEFORE TRANSFERS OUT 1,044,660,239 1,045,826,126 113,416,166 953,229,925 953,229,925 92,596,201 TOTAL REQUIREMENTS 1,421,075,073 1,427,240,960 166,816,763 1,431,903,244 1,431,903,244 (4,662,284) (0.3%)