20240110-002 Financial Report — original pdf

Backup

CITY OF AUSTIN AUSTIN-BERGSTROM INTERNATIONAL AIRPORT Airport Operating Fund 5070 Income Statement - For Internal Use Only Fiscal Year to Date for 2 Month(s) ended November 30, 2023 FY 2024 Budget Budget Seasonalized 2 month(s) Year to Date w/ Accruals Variance Fav (Unfav) % Variance Fav (Unfav) Y-T-D to Budget TOTAL OPERATING EXPENSES Debt Service 0 4 REVENUE AIRLINE REVENUE Landing Fees Terminal Rental & Other Fees TOTAL AIRLINE REVENUE NON-AIRLINE REVENUE Parking Ground Transportation for Hire Rental Cars Food & Beverage Retail Advertising Other Concessions, Rentals & Fees TOTAL NON-AIRLINE REVENUE Interest Income TOTAL REVENUE OPERATING REQUIREMENTS Fac Mgmt, Ops and Airport Security Airport Planning and Development Support Services Business Services 2013 Prosperity Bank Loan 2014 Bond Issuance 2017 Bond Issuance 2019 Refunding Bonds 2019 New Money 2022 New Money TOTAL Net Debt Service OTHER REQUIREMENTS Workers' Compensation Citywide Administrative Support Communications & Technology Mgmt Accrued Payroll 27th Payroll Additional Retirement Contribution Operating Reserve CTECC Trunked Radio Allocation Public Works Capital Projects Mgmt Fund Compensation Adjustment TOTAL OTHER REQUIREMENTS EXCESS (DEFICIT) OF TOTAL AVAILABLE FUNDS OVER TOTAL REQUIREMENTS Federal Relief Reimbursement (Parking) Federal Relief Reimbursement (Debt Service) TOTAL FEDERAL RELIEF REIMBURSEMENT 47,227,041 91,892,750 139,119,791 67,567,206 8,940,600 20,911,887 16,357,880 6,920,612 4,906,850 21,992,777 147,597,812 2,491,042 289,208,645 85,176,445 8,161,976 46,218,424 14,238,156 153,795,001 5,414,978 7,077,844 10,034,715 14,366,313 17,724,531 12,016,000 66,634,383 619,900 6,654,530 2,154,703 202,049 0 3,773,716 4,670,043 527,737 457,471 1,268,713 16,359 20,345,221 8,301,701 16,007,640 24,309,341 11,049,981 1,343,654 3,860,798 2,654,819 1,128,880 845,918 3,183,700 24,067,750 415,174 48,792,264 13,051,503 1,177,301 6,393,540 2,193,000 22,815,345 901,603 1,179,641 1,672,453 2,403,010 2,953,490 1,123,178 10,233,374 103,317 1,109,088 359,117 33,675 0 580,572 778,341 87,956 76,245 211,452 0 3,339,763 9,325,457 15,457,060 24,782,517 12,715,733 1,994,093 4,317,909 3,540,673 1,261,108 1,145,612 3,977,287 28,952,414 877,005 54,611,936 14,515,208 1,115,455 5,816,390 2,782,290 24,229,343 901,603 1,179,641 1,672,453 2,403,010 2,953,490 1,123,178 10,233,374 103,317 1,109,088 359,117 33,675 0 580,572 786,527 87,956 76,245 211,452 0 3,347,949 1,023,755 (550,579) 473,176 1,665,752 650,439 457,111 885,853 132,228 299,694 793,587 4,884,664 461,832 5,819,672 (1,463,704) 61,846 577,150 (589,290) (1,413,998) 0 0 0 0 0 0 (8,186) 0 0 0 0 (8,186) 0 0 0 0 0 0 0 0 0 0 12.3% (3.4%) 1.9% 15.1% 48.4% 11.8% 33.4% 11.7% 35.4% 24.9% 20.3% 111.2% 11.9% (11.2%) 5.3% 9.0% (26.9%) (6.2%) 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% N/A 0.0% (1.1%) 0.0% 0.0% 0.0% N/A (0.2%) N/A N/A N/A TOTAL REQUIREMENTS 240,774,605 36,388,482 37,810,666 (1,422,185) (3.9%) 48,434,040 12,403,783 16,801,270 4,397,487 35.5% 0 0 0 0 0 0 0 0 0 EXCESS (DEFICIT) OF TOTAL AFTER FEDERAL RELIEF 48,434,040 12,403,783 16,801,270 4,397,487 35.5% Note: Columns may not add to totals shown because of rounding CITY OF AUSTIN AUSTIN-BERGSTROM INTERNATIONAL AIRPORT INCOME STATEMENT COMPARISON THIS YEAR VS. LAST YEAR This month - This Year vs. Last Year FY24 (Nov 23) vs FY23 (Nov 22) Fiscal YTD - This Year vs. Last Year FY24 (Oct 23 - Nov 23) vs FY23 (Oct 22 - Nov 22) FY24 Nov-23 FY23 Nov-22 Fav (Unfav) $ Variance Fav (Unfav) % Variance FY24 YTD Nov-23 FY23 YTD Nov-22 Fav (Unfav) $ Variance Fav (Unfav) % Variance 4,486,177 7,748,213 12,234,390 3,882,009 6,142,952 10,024,961 5,953,542 950,074 1,952,899 1,692,874 540,320 392,883 1,928,338 13,410,930 5,393,087 832,000 1,952,803 1,470,985 584,564 434,545 1,723,388 12,391,373 387,810 26,033,130 186,858 22,603,193 8,091,913 618,941 3,263,040 1,407,484 13,381,378 450,980 589,820 836,226 1,199,780 1,476,865 561,589 5,115,261 51,658 554,544 179,559 16,837 290,286 393,263 43,978 38,123 105,726 1,673,974 4,783,722 715,147 2,283,896 1,006,167 8,788,932 450,797 589,820 836,226 1,206,361 1,476,323 9,614 4,569,141 38,955 555,489 144,843 15,996 0 379,949 38,755 37,730 131,326 1,343,043 604,168 1,605,260 2,209,428 560,455 118,074 97 221,889 (44,244) (41,662) 204,950 1,019,557 200,952 3,429,937 (3,308,191) 96,206 (979,144) (401,317) (4,592,446) (183) 0 0 6,581 (542) (551,975) (546,119) (12,704) 945 (34,715) (842) (290,286) (13,314) (5,223) (392) 25,600 (330,931) 15.6% 26.1% 22.0% 10.4% 14.2% 0.0% 15.1% (7.6%) (9.6%) 11.9% 8.2% 107.5% 15.2% (69.2%) 13.5% (42.9%) (39.9%) (52.3%) (0.0%) 0.0% 0.0% 0.5% (0.0%) (5741.6%) (12.0%) (32.6%) 0.2% (24.0%) (5.3%) N/A (3.5%) (13.5%) (1.0%) 19.5% (24.6%) 9,325,457 15,457,060 24,782,517 12,715,733 1,994,093 4,317,909 3,540,673 1,261,108 1,145,612 3,977,287 28,952,414 877,005 54,611,936 14,515,208 1,115,455 5,816,390 2,782,290 24,229,343 901,603 1,179,641 1,672,453 2,403,010 2,953,490 1,123,178 10,233,374 103,317 1,109,088 359,117 33,675 580,572 786,527 87,956 76,245 211,452 3,347,949 7,927,483 12,441,065 20,368,548 11,223,219 1,790,117 4,218,272 3,074,200 1,328,508 1,086,012 3,139,713 25,860,042 398,608 46,627,198 9,360,464 1,055,960 4,292,247 1,959,150 16,667,821 901,768 1,179,641 1,672,453 2,415,701 2,952,344 19,146 9,141,052 77,909 1,110,978 289,687 31,991 0 759,898 77,510 75,461 262,653 2,686,086 1,397,974 3,015,995 4,413,969 1,492,514 203,976 99,636 466,473 (67,400) 59,599 837,574 3,092,372 478,397 7,984,738 (5,154,744) (59,495) (1,524,143) (823,140) (7,561,523) 165 0 0 12,690 (1,146) (1,104,031) (1,092,322) (25,407) 1,889 (69,431) (1,684) (580,572) (26,629) (10,446) (784) 51,201 (661,863) 17.6% 24.2% 21.7% 13.3% 11.4% 2.4% 15.2% (5.1%) 5.5% 26.7% 12.0% 120.0% 17.1% (55.1%) (5.6%) (35.5%) (42.0%) (45.4%) 0.0% 0.0% 0.0% 0.5% (0.0%) (5766.3%) (11.9%) (32.6%) 0.2% (24.0%) (5.3%) N/A (3.5%) (13.5%) (1.0%) 19.5% (24.6%) 5,862,517 7,902,076 (2,039,559) (25.8%) 16,801,270 18,132,239 (1,330,969) (7.3%) 0 0 0 (763,237) 0 (763,237) (763,237) 0 (763,237) (100.0%) N/A (100.0%) 0 0 0 (1,486,196) 0 (1,486,196) (1,486,196) 0 (1,486,196) (100.0%) N/A (100.0%) Airline Revenue Landing Fees Terminal Rental & Other Fees Total Airline Revenue Non-Airline Revenue Parking Ground Transportation for Hire Rental Cars Food & Beverage Retail Advertising Other Concessions, Rentals & Fees Total Non-Airline Revenue Interest Income Total Operating Revenue Operating Requirements Fac Mgmt, Ops and Airport Security Airport Planning and Development Support Services Business Services Total Operating Expense Debt Service 2013 Prosperity Bank Loan 2014 Bond Issuance 2017 Bond Issuance 2019 Refunding Bonds 2019 New Money 2022 New Money Total Debt Service Other Requirements Workers' Compensation Citywide Administrative Support Communications & Technology Mgmt Accrued Payroll Additional Retirement Contribution Operating Reserve CTECC Trunked Radio Allocation Public Works Capital Projects Mgmt Fund Total Other Requirements SURPLUS (DEFICIT) OF TOTAL AVAILABLE FUNDS OVER TOTAL REQUIREMENTS Federal Relief Reimbursement (Parking) Federal Relief Reimbursement (Debt Service) Total Federal Relief Total Requirements 20,170,613 14,701,117 (5,469,497) (37.2%) 37,810,666 28,494,959 (9,315,708) (32.7%) TOTAL SURPLUS (DEFICIT) AFTER FEDERAL RELIEF 5,862,517 8,665,313 (2,802,796) (32.3%) $ 16,801,270 $ 19,618,435 $ (2,817,165) (14.4%) Note: Columns may not add to totals shown because of rounding