July 2023 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division July 31, 2023 To the Mayor and City Council: This is the City's Financial Report for July, the first month of fiscal year 2023-24. This financial report summarizes revenues and expenditures by major categories. The report consists of three sections: Expenditures by Program General Fund Presents a five-year history, including current year budget and actual, and variance and trend analysis for general fund expenditures. Citywide Presents a five-year history, including current year budget and actual, and variance and trend analysis for citywide expenditures. Revenues by Source Presents a current year budget-to-actual analysis as well as a three-year variance and trend analysis for various revenue sources. Financial Schedules General Fund Summary Presents comparisons of year-to-date balances to the fiscal year budget and to the actual results for the prior year for the general fund. Citywide Summary Presents the City's summarized comparisons of the year-to-date balances to the fiscal year budget and to the actual results for the prior year. Citywide Detail Presents, in detail, the results of the City's operations for the current month and for the fiscal year-to-date. Included are breakdowns of the City's revenues, operating budget expenditures, capital budget expenditures and bonds authorized and sold. Respectfully submitted, Kathleen Gitkin Chief Financial Officer John Gamble Deputy Finance Director December 7, 2023 INDEPENDENT AUDITOR REPORT To the Chief Financial Officer, We have assessed the Finance Department’s (Finance) July 2023 Monthly Financial Report (MFR) in accordance with the agreed-upon procedures engagement between Finance and the City Auditor Department (Audit). Finance prepares a monthly, written report to the City Council detailing expenditures, revenues, and the City’s financial condition. Finance is responsible for compiling an accurate and complete MFR. Finance and Audit entered into an agreed-upon procedures engagement for the assessment of the MFR on September 7, 2023. The agreed-upon procedures include the following:  Mathematically check calculations presented within the MFR.  Confirm stated financial data presented within the MFR to historical data supplied by Finance. This agreed-upon procedures engagement was conducted in accordance with the attestation standards established by the American Institute of Certified Public Accountants (AICPA). Because the agreed-upon procedures listed above do not constitute an examination or a review, we will not express an opinion on the MFR as a whole. Had we performed additional procedures; other matters may have come to our attention which would have been reported. The sufficiency of the procedures is solely the responsibility of parties specified in the agreed-upon procedures engagement agreement. Based on the agreed-upon procedures, we verified that the presented financial data was mathematically accurate and tied to historical data presented in the MFR. Sincerely, Ross Tate City Auditor City of Phoenix Monthly Financial Report July 2023 Table of Contents Expenditures by Programs Page Performance Status General Fund Expenditures General Fund Total Expenditures 1 Monitor and Consider Taking Action General Government 1 Monitor and Consider Taking Action Criminal Justice 1 Better than Expected Public Safety 2 Monitor and Consider Taking Action Transportation 2 Better than Expected Community Development 2 Better than Expected Community Enrichment 3 Better than Expected Environmental Services 3 Better than Expected Citywide Expenditures Citywide Total Operating Expenditures 4 Better than Expected General Government 4 Monitor and Consider Taking Action Criminal Justice 4 Better than Expected Public Safety 5 Monitor and Consider Taking Action Transportation 5 Better than Expected Community Development 5 Better than Expected Community Enrichment 6 Monitor and Consider Taking Action Environmental Services 6 Monitor and Consider Taking Action General Obligation Debt Service 6 Better than Expected Capital Expenditures CIP-General Government 7 CIP-Aviation 7 CIP-Phoenix Convention Center 8 CIP-Solid Waste Disposal 8 CIP-Wastewater 9 CIP-Water System 9 Page Performance Status General Fund Total Operating Revenue 10 Better than Expected Property Tax 11 Expected Local Sales Tax 12 Better than Expected Revenues by Source State Sales Tax 13 Better than Expected Vehicle License Tax 14 Monitor and Consider Taking Action Governmental Funds 15 Better than Expected Aviation 16 Better than Expected Water System 17 Better than Expected Wastewater 18 Monitor and Consider Taking Action Financial Schedules Page General Fund Revenue 19 General Fund Expenditures 20 Citywide Operating Revenue 21 Citywide Operating Expenditures 22 Citywide Operating Revenue by Source 23 Citywide Operating Expenditures by Program 26 Capital Expenditures and Encumbrances 28 Bonds Authorized and Sold 29 Notes: Performance Status Better than Expected - Positive variance of greater than 1% actual vs budget. Expected - Actual vs budget variance within 1% positive or negative. Monitor and Consider Taking Action - Negative variance greater than 1% actual vs budget. Corrective Action Taken - Negative variance greater than 1% actual vs budget, however the City has taken action to address the negative variance. General Fund Expenditures Expenditures from the City's General Fund for core functions such as Police, Fire, Parks, Streets and Social Services as well as administrative functions such as Mayor and Council, City Manager, Finance, and Human Resources. This does not include any expenditures from dedicated revenue streams such as grants, bonds, specifically dedicated taxes, and enterprise revenues. General Fund Year-To-Date Expenditures (In Thousands of Dollars) Refer to detailed financial schedules pages 19 thru 29 Total General Fund Expenditures Fiscal Year 19-20 20-21 21-22 22-23 23-24 July YTD Expenditures 133,757 133,971 128,314 141,261 183,988 Total General Fund Annual Expenditures * 1,282,831 1,371,152 1,470,251 1,623,808 1,955,421 % of Annual Expenditures 10.4% 9.8% 8.7% 8.7% 9.4% * For prior years -- total actual expenditures; for current year -- total approved budget net of adjustment for contingencies. $2,500,000 July YTD Expenditures $2,000,000 $1,500,000 $1,000,000 Annual Expenditures * $500,000 $0 19-20 Monitor and Consider Taking Action 20-21 21-22 22-23 23-24 In order to have a better comparison to prior year actuals, contingencies and vacancy savings will only be included in the annual budget to the extent that they have been spent. The general fund provides for core City functions that are not provided by dedicated revenue streams. It does not include services provided by dedicated taxes, grants, bond proceeds or enterprise fund revenues. Fiscal year 2023-24 budgeted general fund expenditures are 20.4% higher than the fiscal year 2022-23 actuals. Fiscal year 2023-24 actual general fund expenditures through July are 30.2% higher than the same period in fiscal year 2022-23. The increase is due to higher personal services (i.e., salaries, benefits, etc.), vehicle purchases, and insurance premiums in fiscal year 2023-24. General fund expenditures increased 10.4% in fiscal year 2022-23 over fiscal year 2021-22. This followed an increase of 7.2% from 2021-22 over 2020-21 and an increase of 6.9% from 2020-21 over 2019-20 fiscal results. General Government Fiscal Year 19-20 20-21 21-22 22-23 23-24 July YTD Expenditures 12,740 16,077 14,191 15,844 24,128 General Government Annual % of Annual Expenditures * Expenditures 10.3% 123,100 10.4% 154,211 8.8% 161,907 8.3% 190,945 10.3% 234,477 * For prior years -- total actual expenditures; for current year -- total approved budget net of adjustment for contingencies. $250,000 July YTD Expenditures $200,000 $150,000 $100,000 Annual Expenditures * $50,000 $0 19-20 Monitor and Consider Taking Action 20-21 21-22 22-23 23-24 General government expenditures include costs for administrative and internal service functions such as the Mayor and City Council, City Manager’s Office, City Auditor, Finance, Budget and Research, and Human Resources. Fiscal year 2023-24 budgeted general fund expenditures are 22.8% higher than the fiscal year 2022-23 actuals. Fiscal year 2023-24 actual general fund expenditures through July are 52.3% higher than the same period in fiscal year 2022-23. The largest driver accounting for increase year-over-year is Human Resource's $4.2 million charge for the Firefighters Cancer Reimbursement Fund Assessment. The largest driver accounting for the year-over-year increase in budget is $10 million in Information Technology. General fund expenditures increased 17.9% in fiscal year 2022-23 over fiscal year 2021-22. This followed an increase of 5.0% from 2021-22 over 2020-21 and an increase of 25.3% from 2020-21 over 2019-20 fiscal results. Criminal Justice Fiscal Year 19-20 20-21 21-22 22-23 23-24 Criminal Justice July YTD Expenditures Annual Expenditures * 3,113 3,307 2,946 3,145 2,993 35,033 36,162 40,008 42,361 45,265 % of Annual Expenditures 8.9% 9.1% 7.4% 7.4% 6.6% * For prior years -- total actual expenditures; for current year -- total approved budget net of adjustment for contingencies. $50,000 July YTD Expenditures $40,000 $30,000 Annual Expenditures * $20,000 $10,000 $0 19-20 Better than Expected 20-21 21-22 22-23 23-24 Criminal Justice expenditures include costs for Municipal Courts and Public Defenders. Fiscal year 2023-24 budgeted general fund expenditures are 6.9% higher than the fiscal year 2022-23 actuals. Fiscal year 2023-24 actual general fund expenditures through July are 4.8% lower than the same period in fiscal year 2022-23. General fund criminal justice expenditures increased 5.9% in fiscal year 2022-23 over fiscal year 2021-22. This followed an increase of 10.6% from 2021-22 over 2020-21 and an increase of 3.2% from 2020-21 over 2019-20 fiscal results. 1 General Fund Year-To-Date Expenditures (In Thousands of Dollars) Refer to detailed financial schedules pages 19 thru 29 Public Safety Fiscal Year 19-20 20-21 21-22 22-23 23-24 Public Safety July YTD Expenditures Annual Expenditures * 87,214 87,252 82,127 90,080 121,977 893,403 925,920 992,648 1,082,562 1,222,556 % of Annual Expenditures 9.8% 9.4% 8.3% 8.3% 10.0% $1,500,000 July YTD Expenditures $1,200,000 $900,000 $600,000 Annual Expenditures * $300,000 * For prior years -- total actual expenditures; for current year -- total approved budget net of adjustment for contingencies. $0 19-20 Monitor and Consider Taking Action 20-21 21-22 22-23 23-24 Public Safety expenditures include costs for police and fire services. The anticipated increases are due to vehicle purchases and higher personal service expenditures for public safety employees in both the Police and Fire Departments, which includes City pension contributions. Fiscal year 2023-24 budgeted general fund public safety expenditures are 12.9% higher than the fiscal year 2022-23 actuals. Fiscal year 2023-24 actual general fund public safety expenditures through July are 35.4% higher than the same period in fiscal year 2022-23. General fund public safety expenditures increased 9.1% in fiscal year 2022-23 over fiscal year 2021-22. This followed an increase of 7.2% from 2021-22 over 2020-21 and an increase of 3.6% from 2020-21 over 2019-20 fiscal results. Transportation Fiscal Year 19-20 20-21 21-22 22-23 23-24 Transportation July YTD Expenditures Annual Expenditures * 355 338 2,059 2,502 615 19,748 22,144 23,166 24,827 25,473 % of Annual Expenditures 1.8% 1.5% 8.9% 10.1% 2.4% * For prior years -- total actual expenditures; for current year -- total approved budget net of adjustment for contingencies. $30,000 $25,000 July YTD Expenditures $20,000 $15,000 $10,000 Annual Expenditures * $5,000 $0 19-20 Better than Expected 20-21 21-22 22-23 23-24 Transportation expenditures include costs for public transit and street maintenance and repair. Prior to fiscal year 2018-19 Street Transportation Department charged expenses to the general fund and subsequently transferred some of those expenses to the Arizona Highway User Revenue fund (AHUR). Beginning in fiscal year 2018-19 Street Transportation is charging most expenses to AHUR while transferring a portion of those to the general fund. Fiscal year 2023-24 budgeted general fund transportation expenditures are 2.6% higher than the fiscal year 2022-23 actuals. Fiscal year 2023-24 actual general fund transportation expenditures through July are 75.4% lower than the same period in fiscal year 2022-23 due to the senior services shuttle program being discontinued. General fund transportation expenditures increased 7.2% in fiscal year 2022-23 over fiscal year 2021-22. This followed an increase of 4.6% from 2021-22 over 2020-21 and an increase of 12.1% from 2020-21 over 2019-20 fiscal results. Community Development Fiscal Year 19-20 20-21 21-22 22-23 23-24 July YTD Expenditures 2,028 2,115 1,840 2,323 2,389 Community Development Annual Expenditures * 22,542 24,114 28,225 32,420 39,424 % of Annual Expenditures 9.0% 8.8% 6.5% 7.2% 6.1% $50,000 July YTD Expenditures $40,000 $30,000 $20,000 Annual Expenditures * $10,000 * For prior years -- total actual expenditures; for current year -- total approved budget net of adjustment for contingencies. $0 19-20 Better than Expected 20-21 21-22 22-23 23-24 Community Development expenditures include costs for economic development and neighborhood services. The fiscal year 2023-24 budgeted general fund community development expenditures are 21.6% higher than the fiscal year 2022-23 actuals. Fiscal year 2023-24 actual general fund community development expenditures through July are 2.8% higher than the same period in fiscal year 2022-23. General fund community development expenditures increased 14.9% in fiscal year 2022-23 over fiscal year 2021-22. This followed an increase of 17.0% from 2021-22 over 2020-21 and an increase of 7.0% from 2020-21 over 2019-20 fiscal results. 2 General Fund Year-To-Date Expenditures (In Thousands of Dollars) Refer to detailed financial schedules pages 19 thru 29 Community Enrichment Community Enrichment % of Annual Expenditures 15.5% 13.1% 9.3% 11.0% 10.6% $250,000 * For prior years -- total actual expenditures; for current year -- total approved budget net of adjustment for contingencies. $0 Fiscal Year 19-20 20-21 21-22 22-23 23-24 July YTD Expenditures 24,080 20,833 16,178 20,970 24,078 Annual Expenditures * 155,417 158,589 173,631 190,780 227,767 July YTD Expenditures $200,000 $150,000 $100,000 Annual Expenditures * $50,000 19-20 20-21 21-22 22-23 23-24 Better than Expected Community enrichment expenditures include costs for parks, recreational activities, senior centers and community centers. Fiscal year 2023-24 budgeted general fund community enrichment expenditures are 19.4% higher than the fiscal year 2022-23 actuals. Fiscal year 2023-24 actual general fund community enrichment expenditures through July are 14.8% higher than the same period in fiscal year 2022-23. The anticipated increase is due to higher contractual services related to parking management services and staffing fiscal year 202324. General fund community enrichment expenditures increased 9.9% in fiscal year 2022-23 over fiscal year 2021-22. This followed an increase of 9.5% from 2021-22 over 2020-21 and an increase of 2.0% from 2020-21 over 2019-20 fiscal results. Environmental Services Fiscal Year 19-20 20-21 21-22 22-23 23-24 July YTD Expenditures 3,663 3,514 10,745 7,232 4,440 Environmental Services Annual Expenditures * 19,180 20,905 26,508 28,329 38,527 % of Annual Expenditures 19.1% 16.8% 40.5% 25.5% 11.5% $40,000 July YTD Expenditures $30,000 $20,000 Annual Expenditures * $10,000 * For prior years -- total actual expenditures; for current year -- total approved budget net of adjustment for contingencies. $0 19-20 Better than Expected 20-21 21-22 22-23 23-24 Environmental service expenditures include costs for maintaining and operating City facilities. Because environmental service expenditures are highly dependent on interdepartmental charges, they tend to be very volatile. Fiscal year 2023-24 budgeted general fund environmental services expenditures are 36.0% higher than the fiscal year 2022-23 actuals. Fiscal year 2023-24 actual general fund environmental service expenditures through July are 38.6% lower than the same period in fiscal year 2022-23. The largest factors increasing annual budget is additional personal services and commodities. General fund environmental expenditures increased 6.9% in fiscal year 2022-23 over fiscal year 2021-22. This followed an increase of 26.8% from 2021-22 over 2020-21 and an increase of 9.0% from 2020-21 over 2019-20 fiscal results. 1 Citywide Expenditures All expenditures of the City including those for enterprise functions and those related to dedicated revenue streams. Expenditures are reported in total and by program. Citywide Year-To-Date Expenditures (In Thousands of Dollars) Refer to detailed financial schedules pages 19 thru 29 Total Citywide Operating Fiscal Year 19-20 20-21 21-22 22-23 23-24 July YTD Expenditures 375,727 433,140 586,932 668,583 438,684 Total Citywide Annual Expenditures * 3,814,963 4,163,122 4,488,949 4,737,610 6,601,290 % of Annual Expenditures 9.8% 10.4% 13.1% 14.1% 6.6% * For prior years -- total actual expenditures; for current year -- total approved budget net of adjustments for contingencies and use of the early redemption fund. $8,000,000 July YTD Expenditures $6,000,000 $4,000,000 Annual Expenditures * $2,000,000 $0 19-20 Better than Expected 20-21 21-22 22-23 23-24 In order to have a better comparison to prior year actuals, contingencies and vacancy savings will only be included in the annual budget to the extent that they have been spent. Fiscal year 2023-24 budget includes program budgeted ARPA amounts. Without contingencies and vacancy savings, and including programs budgeted for ARPA the budget for fiscal year 2023-24 anticipates an increase of 39.3% over fiscal year 2022-23 actuals in total operating expenditures. Actual expenditures through July are 34.4% lower than the same period in the prior fiscal year. General Government Fiscal Year 19-20 20-21 21-22 22-23 23-24 July YTD Expenditures 12,379 20,472 15,432 16,850 24,336 General Government Annual Expenditures * 157,200 207,451 238,925 246,244 287,719 % of Annual Expenditures 7.9% 9.9% 6.5% 6.8% 8.5% $400,000 July YTD Expenditures $300,000 $200,000 Annual Expenditures * $100,000 * For prior years -- total actual expenditures; for current year -- total approved budget. $0 19-20 Monitor and Consider Taking Action 20-21 21-22 22-23 23-24 General government expenditures include costs for administrative and internal service functions such as the Mayor and City Council, City Manager's Office, City Auditor, Finance, Budget and Research, and Human Resources. Budget for fiscal year 2023-24 anticipates an increase of 16.8% over fiscal year 2022-23 actuals in total operating expenditures. Actual expenditures through July are 44.4% higher than the same period in the prior fiscal year. Criminal Justice Fiscal Year 19-20 20-21 21-22 22-23 23-24 Criminal Justice July YTD Expenditures 4,160 4,090 3,501 3,700 3,655 Annual Expenditures * 44,425 44,147 47,054 49,422 54,280 % of Annual Expenditures 9.4% 9.3% 7.4% 7.5% 6.7% $80,000 July YTD Expenditures $60,000 $40,000 Annual Expenditures * $20,000 * For prior years -- total actual expenditures; for current year -- total approved budget. $0 19-20 Better than Expected 20-21 21-22 22-23 23-24 Criminal Justice expenditures include costs of the Municipal Court and the Public Defender’s Office. Citywide criminal justice budget for fiscal year 2023-24 anticipates an increase of 9.8% over fiscal year 2022-23 actuals in total operating expenditures. Actual expenditures through July are 1.2% lower than the same period in the prior fiscal year. 4 Citywide Year-To-Date Expenditures (In Thousands of Dollars) Refer to detailed financial schedules pages 19 thru 29 Public Safety Public Safety % of Annual Expenditures 9.4% 9.4% 8.0% 8.1% 9.3% $2,000,000 * For prior years -- total actual expenditures; for current year -- total approved budget. $0 Fiscal Year 19-20 20-21 21-22 22-23 23-24 July YTD Expenditures 104,833 105,446 98,750 109,549 144,580 Annual Expenditures * 1,110,457 1,122,901 1,228,901 1,354,421 1,547,732 July YTD Expenditures $1,600,000 $1,200,000 $800,000 Annual Expenditures * $400,000 19-20 20-21 21-22 22-23 23-24 Monitor and Consider Taking Action Public Safety expenditures include costs of Police, Fire and Emergency Management. Citywide public safety budget for fiscal year 2023-24 anticipates an increase of 14.3% over fiscal year 2022-23 actuals in total operating expenditures. Actual expenditures through July are 32.0% higher than the same period in the prior fiscal year. Transportation Fiscal Year 19-20 20-21 21-22 22-23 23-24 Transportation July YTD Expenditures 70,139 122,743 300,960 231,350 53,430 Annual Expenditures * 774,492 786,597 797,084 792,941 914,442 % of Annual Expenditures 9.1% 15.6% 37.8% 29.2% 5.8% $1,000,000 July YTD Expenditures $800,000 $600,000 $400,000 Annual Expenditures * $200,000 * For prior years -- total actual expenditures; for current year -- total approved budget. $0 19-20 Better than Expected 20-21 21-22 22-23 23-24 Transportation expenditures include costs for street lighting, maintenance and repair, Aviation and Public Transit. Citywide transportation budget for fiscal year 2023-24 anticipates an increase of 15.3% over fiscal year 2022-23 actuals in total operating expenditures. Actual expenditures through July are 76.9% lower than the same period in the prior fiscal year. Fiscal year 2021-22 financial results included a $70 million pension paydown. Community Development Fiscal Year 19-20 20-21 21-22 22-23 23-24 July YTD Expenditures 18,444 21,129 19,809 18,894 21,457 Community Development Annual Expenditures * 229,793 245,310 227,960 270,479 415,139 % of Annual Expenditures 8.0% 8.6% 8.7% 7.0% 5.2% $500,000 July YTD Expenditures $400,000 $300,000 $200,000 Annual Expenditures * $100,000 * For prior years -- total actual expenditures; for current year -- total approved budget. $0 19-20 Better than Expected 20-21 21-22 22-23 23-24 Community Development expenditures include costs for Neighborhood Services, Housing, Planning and Economic Development. Citywide community development budget for fiscal year 2023-24 anticipates an increase of 53.5% over fiscal year 2022-23 actuals in total operating expenditures. Actual expenditures through July are 13.6% higher than the same period in the prior fiscal year. 5 Citywide Year-To-Date Expenditures (In Thousands of Dollars) Refer to detailed financial schedules pages 19 thru 29 Community Enrichment % of Annual Expenditures 16.8% 14.6% 11.5% 9.6% 12.3% $600,000 * For prior years -- total actual expenditures; for current year -- total approved budget. $0 Fiscal Year 19-20 20-21 21-22 22-23 23-24 July YTD Expenditures 53,178 57,093 48,233 43,376 59,043 Community Enrichment Annual Expenditures * 316,680 390,805 420,501 450,218 478,454 July YTD Expenditures $450,000 $300,000 Annual Expenditures * $150,000 19-20 20-21 21-22 22-23 23-24 Monitor and Consider Taking Action Community Enrichment expenditures include costs for Parks, Libraries, the Convention Center, Senior Centers and Community Centers. Citywide community enrichment budget for fiscal year 2023-24 anticipates an increase of 6.3% over fiscal year 2022-23 actuals in total operating expenditures. Actual expenditures through July are 36.1% higher than the same period in the prior fiscal year. Environmental Services Environmental Services % of Annual Expenditures 10.4% 10.8% 11.4% 9.9% 10.4% $1,000,000 * For prior years -- total actual expenditures; for current year -- total approved budget. $0 Fiscal Year 19-20 20-21 21-22 22-23 23-24 July YTD Expenditures 72,182 79,526 85,499 81,927 95,731 Annual Expenditures * 692,524 734,733 752,386 830,101 918,863 July YTD Expenditures $750,000 $500,000 Annual Expenditures * $250,000 19-20 20-21 21-22 22-23 23-24 Monitor and Consider Taking Action Environmental Services expenditures include costs for Water, Wastewater and Solid Waste services as well as the care and maintenance of City facilities. Citywide environmental services budget for fiscal year 2023-24 anticipates an increase of 10.7% over fiscal year 2022-23 actuals in total operating expenditures. Actual expenditures through July are 16.8% higher than the same period in the prior fiscal year. Citywide Debt Service Expenditures Fiscal Year 19-20 20-21 21-22 22-23 23-24 July YTD Expenditures 10,866 10,966 10,952 87,270 11,333 Annual Expenditures * 130,839 131,938 131,081 207,854 136,900 General Obligation Debt Service % of Annual Expenditures 8.3% 8.3% 8.4% 42.0% 8.3% $240,000 July YTD Expenditures $180,000 $120,000 Annual Expenditures * $60,000 * For prior years -- total actual expenditures; for current year -- total approved budget net of credit for early redemption fund resources $0 19-20 20-21 21-22 22-23 23-24 Better than Expected General obligation debt service expenditures budget for fiscal year 2023-24 has a decrease of 34.1% over fiscal year 2022-23 actuals in total operating expenditures. Actual debt service expenditures through July 2023 are 87.0% lower than the same period in the prior fiscal year. Increases in fiscal year 2022-23 include a $75 million partial defeasance of General Obligation Refunding Bonds, Series 2014, and a $60 million pay-off of the Excise Tax Revenue Obligations Loan that was used to purchase the 100 W. Washington Street Building. 6 Capital Expenditures Expenditures for capital projects. These expenditures may come from designated capital funds such as bond proceeds or grants, or they may come from operating funds and be reported in both the operating and capital sections. Because of the long-term view used in capital budgeting and the volatility of capital spending, no performance status is provided unless capital spending exceeds the capital budget. Capital Expenditures (In Thousands of Dollars) Refer to detailed financial schedules pages 19 thru 29 20-21 21-22 22-23 23-24 (Budget) 23-24 (YTD) $ 684,798 $ 525,852 $ 494,744 $ 2,119,807 $ 19-20 General Government $ 500,745 Discussion: 25,558 General Government Major projects budgeted for in fiscal year 2019-20 included $131 million for pavement maintenance, $100 million on Light Rail, $57 million for Talking Stick Arena Renovations, $47 million on parks preserve development, community centers, and development, $45 million bus and vehicle purchases, and $18 million for major streets. 23-24 (YTD) 23-24 (Budget) 22-23 Major projects budgeted for in fiscal year 2020-21 included $115 million on the South Central Light Rail, $96 million for Talking Stick Arena renovations, $69 million on Northwest Light Rail extension, and $32 million to replace fare collection system. 21-22 20-21 Major projects budgeted for in fiscal year 2021-22 included $117 million on South Central Light Rail extension, $70 million on Northwest Light Rail extension, $29 million to design and constructing roadway and drainage near the 303 and Carefree Highway, $11 million replacement of Police Air Fleet, and $10 million street improvement near Pinnacle Peak and 35th to 45th Ave. 19-20 $0 $500 $1,000 $1,500 $2,000 $2,500 Major projects budgeted for in fiscal year 2022-23 included $248 million for Light Rail extension, construction, right-of-way and acquisition of property, $63 million for debt service/principal and interest for Aviation and Convention Center, $60 million to construct and complete major street projects, $53 million to purchase standard buses, design first corridor Bus Rapid Transit, and add an operational garage, $22 million on funds for construction cost of affordable housing, $21 million to improve three Pedestrian Hybrid Beacons, $18 million to procure and implement a Time and Labor System, and $2 million to acquire parcels along the Capitol and I-10 corridor. Additionally, there is $100 million in contingency budget for undetermined capital expenditures. Major projects budgeted for in fiscal year 2023-24 include $264 million for Light Rail extension, construction, right-of-way and acquisition of property, $116 million to purchase standard buses, design first and second corridors Bus Rapid Transit, $75 million to acquire parcels along the Capitol and I-10 corridor, $65 million for new parks construction, $101 million for major streets and bridges projects, $41 million on funds for construction cost of affordable housing, and $20 million to procure and implement a Time and Labor System. Additionally, there is $100 million in contingency budget for undetermined capital expenditures. 20-21 21-22 22-23 23-24 (Budget) 23-24 (YTD) $ 172,418 $ 115,395 $ 134,479 $ 1,192,245 $ 19-20 Aviation $ 254,523 26,846 Discussion: Aviation Major projects budgeted for in fiscal year 2019-20 included $90 million for PHX Terminal 4 South concourse and gates, $47 million for Runway, Apron and Taxiway Improvements, and $10 million for PHX Sky Train. 23-24 (YTD) 23-24 (Budget) 22-23 Major projects budgeted for in fiscal year 2020-21 included $51 million on Terminal 4 concourse, $24 million Terminal 4 Apron Concrete construction, $19 million garage demolition, and $13 million on the 24th St parking lot. 21-22 20-21 19-20 $0 $500 $1,000 $1,500 Major events budgeted for in fiscal year 2021-22 included $58 million in Aviation Bonds, $13 million in New Crossfield Taxiway, $6 million on Terminal 4 South 1 Concourse, and $5 million on Phoenix Sky Train. Major projects budgeted for in fiscal year 2022-23 included $11 million for a New Crossfield Taxiway, $34 million to modernize vertical and horizontal transportation equipment at Sky Harbor, $24 million to reconstruct the West Air Cargo Apron, $21 million to replace and relocate the police hangar at Phoenix Deer Valley Airport, $13 million to relocate Taxiway at Phoenix Deer Valley Airports, $12 million to replace Terminal 4 fire alarm/voice evacuation system, and $11 million to facilitate the acquisition of land on the North side of Phoenix Sky Harbor Airport. Additionally, the City budgets $176 million in contingencies for the Airport Development Plan. Major projects budgeted for in fiscal year 2023-24 include $315 million for Concourse Construction at Phoenix Sky Harbor Airport, $185 million for the new Crossfield Taxiway, $43 million to relocate the American Airlines baggage sorting facility, $41 million to modify West Air Cargo Building in support of new Crossfield Taxiway, and $23 million to reconstruct the West Air Cargo Apron. Additionally, the City budgets $377 million in contingencies for the Airport Development Plan. 7 Capital Expenditures (In Thousands of Dollars) Refer to detailed financial schedules pages 19 thru 29 20-21 21-22 22-23 $ 31,640 $ 84,751 $ 112,717 19-20 Phoenix Convention Center $ 52,148 23-24 (Budget) 23-24 (YTD) $ $ Discussion: 45,697 186 Phoenix Convention Center Beginning in fiscal year 2012-13, Phoenix Convention Center began making debt service payments on the State funded portion of the 2005 Convention Center bonds. The payments from the State are accumulated in a capital fund and the subsequent debt service payments are then made from the capital fund within the capital budget. The debt service payments totaled $24 million for fiscal year 202021. Major projects budgeted for in fiscal year 2021-22 included $47 million for the purchase of 100 West Washington Street. 23-24 (YTD) 23-24 (Budget) 22-23 21-22 Major projects budgeted for in fiscal year 2022-23 included $150 million to design and construct the second phase of building and garage renovations at 100 West Washington Street. 20-21 19-20 Major projects budgeted for in fiscal year 2023-24 include $34 million to design and construct the second phase of building and garage renovations at 100 West Washington Street. 19-20 Solid Waste $ 20-21 5,490 $ 8,796 $0 21-22 22-23 $ 28,986 $ 22,723 $50 $100 23-24 (Budget) 23-24 (YTD) $ $ 38,135 $150 575 Discussion: Solid Waste Major projects budgeted for in fiscal year 2019-20 Solid Waste included $3 million for transfer stations, $1 million at State Route 85, and $1 million for Skunk Creek as monitoring and maintenance. 23-24 (YTD) 23-24 (Budget) Major projects budgeted for in fiscal year 2020-21 Solid Waste included $4.5 million on Excavate and line Cell 2 at the State Route 85 Landfill, $1.2 million Dixileta payment replacement at self-haul area, and $1.1 million at the 27th Ave trommel machine. 22-23 21-22 Major projects budgeted for in fiscal year 2021-22 Solid Waste included $24 million on replacing and upgrading aging equipment at 27th Ave and North Gateway Transfer Stations Material Recovery Facilities. 20-21 19-20 $0 $15 $30 Major projects budgeted for in fiscal year 2022-23 included $10 million at transfer stations, $8.5 million at State Route 85 for excavating and lining along with methane gas extraction systems, and $3 million to purchase replacement vehicles. Additionally, the City budgeted $2.5 million in contingency funding for unexpected expenditures. $45 Major projects budgeted for in fiscal year 2023-24 include $9 million to excavate and line Cell 2 at the State Route 85 Landfill, $7 million to replace or upgrade aging equipment at the 27th Ave Material Recovery Facilities, and $3 million to purchase and install upgraded recycling equipment at the North Gateway Material Recovery Facility. Additionally, the City budgets $10 million for unexpected expenditures. 8 Capital Expenditures (In Thousands of Dollars) Refer to detailed financial schedules pages 19 thru 29 19-20 Wastewater $123,141 20-21 21-22 22-23 $ 77,339 $ 182,710 $147,620 23-24 (Budget) 23-24 (YTD) $ $ 381,836 Discussion: 360 Wastewater Major projects budgeted for in fiscal year 2019-20 included $42.0 million on sewer replacement and construction, $27.7 million on 91st Ave Waste Water Treatment Plant, $14.4 million at 23rd Ave, $13.1 million at Cave Creek, and $13.1 million on lift stations. 23-24 (YTD) 23-24 (Budget) Major projects budgeted for in fiscal year 2020-21 included $12.4 million on 91st Ave plant equipment, $10.1 million for 23rd Ave Grit Basin Replacement, $6.9 million Citywide to rehabilitate small diameter sewers, and $4.7 million for 23rd Ave equipment replacement. 22-23 21-22 Major projects budgeted for in fiscal year 2021-22 included $49.8 million on Lift Stations, $33.2 million on Dixileta Dobbins North Gravity Sewer, $22.7 million primarily rehabbing at 91st Ave, $16.3 million at 23rd Ave including designing and constructing a new grit basin, $6.6 million rehabbing small diameter sewers Citywide, $5.9 million rehabbing Cave Creek Reclamation Plant, $3 million 32nd Street sanity sewer between Cortez Street and Cactus Road, and $3.0 million for Sewer Relocation due to Light Rail. 20-21 19-20 $0 $100 $200 $300 $400 $500 Thousands Major projects budgeted for in fiscal year 2022-23 included $20 million on growth-related wastewater infrastructure in Desert View area, $17 million to replace and rehabilitate equipment used in solids thickening, $17 million to rehabilitate Plant 2 equipment at 91st Ave, $12 million to rehabilitate or replace large diameter sewers, $11 million 23rd Ave Grit Basin Replacement, $9 million to rehabilitate small sewers citywide, $5 million for rehabilitate or replacing PVC-lined concrete sanitary interceptors, and $4 million for Dixileta Dobbins North Gravity Sewer. In addition, the City has budgeted $165 million for contingencies. Major projects budgeted for in fiscal year 2023-24 include $50 million to rehabilitate equipment at Cave Creek, $29 million to replace and rehabilitate Plant 2 equipment at 91st Ave, $23 million to rehabilitate or replace PVC-lined concrete sanitary interceptors, $19 million to replace and rehabilitate equipment used in solids thickening, $16 million to rehabilitate small diameter sewers Citywide, $15 million to construct a new force main, $12 million for large growth-related infrastructure in the Desert View Impact fee area, and $11 million for the Northwest Wastewater Gravity Sewer. Additionally, the City has budgeted $66 million for contingencies. 19-20 Water System $ 252,146 20-21 21-22 22-23 $ 434,000 $ 205,485 $152,431 23-24 (Budget) 23-24 (YTD) $ $ 630,118 2,528 Discussion: Water System Major projects budgeted for in fiscal year 2019-20 included $84.3 million on water main replacement and construction, $55.9 million on Water Treatment Plants, and $38.9 million on wells. 23-24 (YTD) 23-24 (Budget) Major projects budgeted for in fiscal year 2020-21 included $153 million on water main from 24th Street treatment plant to 32nd St and Bell Road, $110 million on water boosters, and $20 million on transmission main rehabilitation. 22-23 21-22 20-21 19-20 $0 $200 $400 $600 $800 Major projects budgeted for in fiscal year 2021-22 included $47 million on Dixileta Dobbins to install water infrastructure, $21 million on relocating waterlines along the Light Rail, $15 million to provide power redundancy at 24th Street Water Treatment Plant, $12 million to repair and replace leaking water services from main to meter, and $9 million in underground aquifer water storage. Major projects budgeted for in fiscal year 2022-23 included $104 million for water engineering and construction labor, $51 million for the Southern/Northern Water Growth Projects for growth-related water infrastructure, $22 million at DVWTP to relocate existing chemical storage and related chemical feed pumping systems to upgrade and replace aging facilities, $17 million on underground Aquifer Water Storage, $12 million on Booster Pump Stations, $12 million Remote Facilities Rehab and Replacement, $11 million for 24th Street WTP rehabilitation, and $9 million to Acquire Additional Water Resources. Additionally, the City budgeted $105 million for Water contingencies. Major projects budgeted for in fiscal year 2023-24 include $85 million on booster pump stations, $25 million to install and upgrade water mains, $42 million for Deer Valley plant rehabilitation, $32 million for 24th Street treatment plant rehabilitation, $30 million for infrastructure construction in the Southern development impact fee area, $17 million for groundwater wells construction, $17 million on plant power redundancy at 24 th Street, $15 million for concrete reservoir rehabilitation, $15 million for construction improvements, and $12 million for aquifer storage recovery wells. Additionally, the City budgets $105 million for Water contingencies. 9 Revenues Sources of funds for the operations of the City including local taxes, state shared taxes, user fees and charges, and grants. General Fund Total Operating Revenue (In Thousands of Dollars) Refer to detailed financial schedules on pages 19 thru 29 General Fund Revenues $2,000,000 $1,600,000 July YTD Revenues $1,200,000 $800,000 Annual Revenues* $400,000 $0 19-20 Fiscal Year 19-20 20-21 21-22 22-23 23-24 July YTD Revenues 73,830 78,594 94,725 96,914 124,772 20-21 21-22 22-23 23-24 Annual % of Annual Revenues* Revenues 1,307,357 5.6% 1,491,537 5.3% 1,508,526 6.3% 1,695,886 5.7% 1,833,837 6.8% * For prior years - total actual revenues, for current year - total approved budget Year to Date Performance Status Better than Expected Fiscal year 2023-24 general fund operating revenues are budgeted to increase 8.1% over prior year actuals. Actual revenues through July are 28.7% higher than the same period in the prior fiscal year. Specific revenue sources are discussed on the following pages. 10 Property Tax Revenue (In Thousands of Dollars) Refer to detailed financial schedules on pages 19 thru 29 Property Taxes Primary & Secondary 360,000 320,000 280,000 131,092 126,148 240,000 119,973 115,069 107,555 Secondary 200,000 Primary 160,000 120,000 80,000 182,043 192,215 201,050 170,209 19-20 20-21 21-22 22-23 206,935 40,000 - Fiscal Year 19-20 20-21 21-22 22-23 23-24 YTD 23-24 Budget Total 277,764 297,112 312,188 327,198 (1,819) 338,027 July (1,141) (1,619) (1,490) (1,541) (1,819) (1,678) Aug 1,081 1,541 1,141 1,275 1,428 Sept 647 1,288 1,040 1,357 1,330 Oct 11,579 21,550 24,048 29,752 27,197 Nov 106,458 89,520 101,285 98,119 104,287 Dec 23,612 38,512 33,534 39,943 40,422 Jan 14,875 15,608 18,086 16,279 18,038 23-24 YTD Feb 7,447 6,612 6,889 7,687 7,648 Mar 8,185 9,456 8,972 10,370 10,395 Apr 12,116 15,171 15,063 15,618 16,550 23-24 Budget May 66,043 76,862 71,096 77,294 81,304 June 26,862 22,611 32,524 31,045 31,106 Primary Secondary 170,209 107,555 182,043 115,069 192,215 119,973 201,050 126,148 (1,124) (695) 206,935 131,092 Note: Monthly budget amount for 23-24 is the average % of last 3 fiscal years of the total actual amount. Year to Date Performance Status Expected Because property taxes are primarily collected in November, December, May and June, a monthly breakdown of the revenues is not particularly useful, therefore the chart for property tax revenues is presented with an annual perspective. Total property tax revenues are budgeted to increase 3.3% in fiscal year 2023-24 over fiscal year 2022-23 actuals. 11 Local Sales Tax Revenue (In Thousands of Dollars) Refer to detailed financial schedules on pages 19 thru 29 Local Sales Tax Budget vs Actual 90,000 80,000 70,000 60,000 19-20 Actuals 20-21 Actuals 50,000 21-22 Actuals 40,000 22-23 Actuals 23-24 Actuals 30,000 23-24 Budget 20,000 10,000 July Fiscal Year 19-20 20-21 21-22 22-23 23-24 23-24 Budget Aug July 33,070 41,583 44,048 43,479 65,562 46,969 Sept YTD thru July 33,070 41,583 44,048 43,479 65,562 46,969 Oct Aug 36,653 59,937 61,805 67,368 65,383 Nov Dec Jan Feb Mar Apr May June Sept 56,465 33,935 41,516 46,739 51,740 Oct 31,089 45,467 50,734 81,273 60,402 Nov 40,325 52,188 60,971 35,837 54,829 Dec 51,643 39,837 53,633 59,276 59,193 Jan 39,512 42,051 70,197 70,667 64,417 Feb 33,570 32,672 42,535 54,420 47,264 Mar 61,093 63,749 44,740 52,376 64,281 Apr 29,662 40,758 54,758 43,371 48,814 May 35,239 40,197 72,938 85,884 67,844 June 50,222 67,088 61,286 56,272 68,020 Year to Date Performance Status Better than Expected Local Sales Tax for fiscal year 2023-24 are budgeted to increase 0.3% over fiscal year 2022-23 actual results. Year-to-date Local Sales Tax through July are 39.6% higher than budget expectations. City of Phoenix revenue is budgeted on an annual basis. Fiscal year 2023-24 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2019-20 through fiscal year 2022-23 actual revenue. Through July fiscal year 2023-24 Local Sales Tax revenues increased 50.8% compared to the same period in prior year. For the fiscal year 2022-23 Local Sales Tax for the full year increased 5.7% over fiscal year 2021-22. Fiscal year 2021-22 increased 17.8% over 2020-21 full year results. 12 State Sales Tax Revenue (In Thousands of Dollars) Refer to detailed financial schedules on pages 19 thru 29 State Sales Tax Budget vs Actual 35,000 30,000 25,000 19-20 Actuals 20-21 Actuals 20,000 21-22 Actuals 22-23 Actuals 15,000 23-24 Actuals 23-24 Budget 10,000 5,000 July Fiscal Year 19-20 20-21 21-22 22-23 23-24 23-24 Budget Aug July 20,116 22,912 26,539 28,422 31,080 28,837 Sept YTD thru July 20,116 22,912 26,539 28,422 31,080 28,837 Oct Aug 14,944 14,482 18,124 15,064 18,427 Nov Sept 11,479 13,123 16,285 22,937 18,783 Dec Jan Feb Mar Apr May June Oct 14,226 18,038 18,259 18,918 20,436 Nov 16,443 13,095 15,097 17,357 18,244 Dec 12,120 19,640 23,860 22,501 22,990 Jan 17,440 19,033 22,364 20,469 23,339 Feb 17,707 10,831 12,163 19,205 17,630 Mar 12,285 15,878 18,738 22,501 20,424 Apr 18,557 23,414 25,105 23,090 26,535 May 11,288 17,998 15,952 15,244 17,799 June 5,321 12,848 17,415 16,105 15,212 Year to Date Performance Status Better than Expected State Sales Tax for fiscal year 2023-24 are budgeted to increase 2.8% over fiscal year 2022-23 actual results. Year-to-date State Sales Tax through July are 7.8% higher than budget expectations. City of Phoenix revenue is budgeted on an annual basis. Fiscal year 2023-24 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2019-20 through fiscal year 2022-23 actual revenue. Through July fiscal year 2023-24 State Sales Tax revenues increased 9.4% compared to the same period in prior year. For the fiscal year 2022-23 State Sales Tax for the full year increased 5.2% over fiscal year 2021-22. Fiscal year 2021-22 increased 14.2% over 2020-21 full year results. 13 Vehicle License Tax Revenue (In Thousands of Dollars) Refer to detailed financial schedules on pages 19 thru 29 Vehicle License Tax Budget vs Actual 14,000 12,000 19-20 Actuals 10,000 20-21 Actuals 21-22 Actuals 8,000 22-23 Actuals 6,000 23-24 Actuals 23-24 Budget 4,000 2,000 July Fiscal Year 19-20 20-21 21-22 22-23 23-24 23-24 Budget Aug July 10,791 10,098 10,453 10,826 10,796 11,665 Sept Oct Nov Dec Jan Feb Mar Apr May YTD thru July 10,791 10,098 10,453 10,826 10,796 11,665 Aug 5,619 7,692 5,328 5,739 6,744 Sept 5,207 6,207 6,363 6,274 6,653 Oct 6,146 7,328 6,970 6,676 7,502 Nov 5,408 4,608 4,862 5,183 5,549 Dec 5,891 6,529 6,537 6,555 7,057 Jan 6,514 7,328 7,285 6,684 7,693 Feb 6,528 5,568 5,828 6,276 6,694 Mar 5,960 6,411 6,418 7,297 7,216 June Apr 5,110 7,162 8,075 7,252 7,635 May 4,699 6,472 6,061 7,241 6,770 June 2,611 4,365 4,515 4,590 4,448 Year to Date Performance Status Monitor and Consider Taking Action Vehicle License Tax for fiscal year 2023-24 are budgeted to increase 6.2% over fiscal year 2022-23 actual results. Year-to-date Vehicle License Tax through July are 7.4% lower than budget expectations. City of Phoenix revenue is budgeted on an annual basis. Fiscal year 2023-24 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2019-20 through fiscal year 2022-23 actual revenue. Through July fiscal year 2023-24 Vehicle License Tax revenues decreased 0.3% compared to the same period in prior year. For the fiscal year 2022-23 Vehicle License Tax for the full year increased 2.4% over fiscal year 2021-22. Fiscal year 2021-22 decreased 1.3% over 2020-21 full year results. 14 Governmental Funds Revenue (In Thousands of Dollars) Refer to detailed financial schedules on pages 19 thru 29 Governmental Funds Revenues Budget vs Actual 600,000 500,000 19-20 Actuals 20-21 Actuals 21-22 Actuals 400,000 22-23 Actuals 23-24 Actuals 300,000 23-24 Budget 200,000 100,000 - Fiscal Year 19-20 20-21 21-22 22-23 23-24 23-24 Budget July Aug Sept Oct July 100,481 68,761 123,174 79,979 154,502 114,645 YTD thru July 100,481 68,761 123,174 79,979 154,502 114,645 Aug 187,393 217,048 225,569 274,628 288,476 Sept 194,506 260,275 185,901 211,185 272,566 Nov Oct 175,883 215,731 231,638 288,507 291,960 Dec Jan Nov 269,127 298,362 324,875 300,162 381,199 Feb Dec 226,582 236,818 253,979 275,549 318,233 Mar Jan 209,806 216,626 267,406 263,160 306,678 Apr May June Feb 187,061 178,738 199,258 246,172 260,842 Mar 217,521 272,444 230,537 255,008 312,903 Apr 180,484 316,241 255,574 243,521 321,256 May 226,625 277,929 320,064 419,779 399,467 June 378,887 362,173 540,197 497,001 581,656 Year to Date Performance Status Better than Expected Governmental Funds are those funds supported primarily through taxes, bonds and grants and include the general fund as well as funds with dedicated tax revenue streams. They do not include the enterprise funds. Governmental Funds for fiscal year 2023-24 are budgeted to increase 14.8% over fiscal year 2022-23 actual results. Year-to-date Governmental Funds revenues through July are 34.8% higher than budget expectations. City of Phoenix revenue is budgeted on an annual basis. Fiscal year 2023-24 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2019-20 through fiscal year 2022-23 actual revenue. Through July fiscal year 2023-24 Governmental Funds revenues increased 93.2% compared to the same period in prior year. For the fiscal year 2022-23 Governmental Funds for the full year increased 6.2% over fiscal year 2021-22. Fiscal year 2021-22 increased 8.1% over 2020-21 full year results. 15 Aviation Revenue (In Thousands of Dollars) Refer to detailed financial schedules on pages 19 thru 29 Aviation Operating Revenues Budget vs Actual 160,000 120,000 19-20 Actuals 20-21 Actuals 21-22 Actuals 80,000 22-23 Actuals 23-24 Actuals 23-24 Budget 40,000 July Fiscal Year 19-20 20-21 21-22 22-23 23-24 23-24 Budget Aug July 30,489 25,387 36,735 12,023 43,541 29,090 Sept YTD thru July 30,489 25,387 36,735 12,023 43,541 29,090 Oct Nov Dec Jan Feb Mar Apr May June Aug 32,307 2,666 33,945 37,402 29,559 Sept 32,953 27,193 28,302 34,042 34,054 Oct 32,056 21,045 31,904 41,419 35,148 Nov 33,532 23,880 36,031 66,192 44,381 Dec 36,787 31,636 35,025 25,237 35,777 Jan 34,297 18,059 57,391 46,228 43,364 Feb 34,215 61,877 33,583 57,291 51,980 Mar 34,228 25,487 38,417 45,866 40,034 Apr 27,255 31,454 40,080 48,930 41,069 May 23,524 30,668 46,367 46,926 41,004 June 10,702 91,844 155,860 112,245 103,048 Year to Date Performance Status Better than Expected Aviation Operating revenue for fiscal year 2023-24 are budgeted to decrease 7.9% over fiscal year 2022-23 actual results. Year-to-date Aviation Operating revenues through July are 49.7% higher than budget expectations. City of Phoenix revenue is budgeted on an annual basis. Fiscal year 2023-24 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2019-20 through fiscal year 2022-23 actual revenue. Through July fiscal year 2023-24 Aviation Operating revenues increased 262.1% compared to the same period in prior year. For the fiscal year 2022-23 Aviation Operating revenues for the full year increased 0.0% over fiscal year 2021-22. Fiscal year 2021-22 increased 46.6% over 2020-21 full year results. 16 Water System Revenue (In Thousands of Dollars) Refer to detailed financial schedules on pages 19 thru 29 Water System Operating Revenues Budget vs Actual 90,000 80,000 70,000 60,000 19-20 Actuals 50,000 20-21 Actuals 21-22 Actuals 40,000 22-23 Actuals 30,000 23-24 Actuals 20,000 23-24 Budget 10,000 July Fiscal Year 19-20 20-21 21-22 22-23 23-24 23-24 Budget Aug July 52,660 57,819 58,256 60,867 79,474 74,381 Sept Oct Nov Dec Jan Feb Mar Apr May June YTD thru July 52,660 57,819 58,256 60,867 79,474 74,381 Aug 51,596 53,509 42,379 49,237 63,729 Sept 47,319 52,454 47,181 53,259 64,861 Oct 40,300 47,335 39,257 44,825 55,629 Nov 38,339 42,280 41,784 40,352 52,726 Dec 26,405 33,139 37,523 33,550 42,314 Jan 25,330 28,579 28,902 28,416 36,033 Feb 25,643 25,188 28,035 26,868 34,253 Mar 24,861 28,415 31,242 30,349 37,212 Apr 29,080 37,714 40,702 35,722 46,397 May 40,442 42,556 45,193 41,526 54,981 June 52,141 43,174 51,821 52,443 64,655 Year to Date Performance Status Better than Expected Water System Operating revenues for fiscal year 2023-24 are budgeted to increase 26.1% over fiscal year 2022-23 actual results. Year-to-date Water System Operating revenues through July are 6.8% higher than budget expectations. City of Phoenix revenue is budgeted on an annual basis. Fiscal year 2023-24 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2019-20 through fiscal year 2022-23 actual revenue. Through July fiscal year 2023-24 Water System Operating revenues increased 30.6% compared to the same period in prior year. For the fiscal year 2022-23 Water System Operating revenues for the full year increased 1.0% over fiscal year 2021-22. Fiscal year 2021-22 increased 0.0% over 2020-21 full year results. 17 Wastewater Revenue (In Thousands of Dollars) Refer to detailed financial schedules on pages 19 thru 29 Wastewater Operating Revenues Budget vs Actual 35,000 30,000 25,000 19-20 Actuals 20,000 20-21 Actuals 15,000 21-22 Actuals 22-23 Actuals 10,000 23-24 Actuals 23-24 Budget 5,000 July Fiscal Year 19-20 20-21 21-22 22-23 23-24 23-24 Budget Aug July 18,374 21,205 22,011 18,108 18,448 21,965 Sept YTD thru July 18,374 21,205 22,011 18,108 18,448 21,965 Oct Nov Dec Jan Feb Mar Apr May June Aug 24,593 22,791 21,971 22,936 25,436 Sept 21,373 21,844 26,947 19,029 24,582 Oct 20,975 22,234 18,312 22,401 23,129 Nov 21,142 18,577 21,720 25,044 23,835 Dec 20,888 24,461 24,380 19,691 24,644 Jan 22,063 18,430 22,218 26,128 24,484 Feb 20,973 24,355 21,916 25,503 25,561 Mar 21,613 21,754 23,023 22,405 24,472 Apr 18,428 21,584 24,091 21,595 23,618 May 23,948 20,085 22,296 23,607 24,786 June 18,289 17,424 17,973 28,591 22,676 Year to Date Performance Status Monitor and Consider Taking Action Wastewater Operating revenues for fiscal year 2023-24 are budgeted to increase 5.1% over fiscal year 2022-23 actual results. Year-to-date Wastewater Operating revenues through July are 16.0% lower than budget expectations. City of Phoenix revenue is budgeted on an annual basis. Fiscal year 2023-24 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2019-20 through fiscal year 2022-23 actual revenue. Through July fiscal year 2023-24 Wastewater Operating revenues increased 1.9% compared to the same period in prior year. For the fiscal year 2022-23 Wastewater Operating revenues for the full year increased 3.1% over fiscal year 2021-22. Fiscal year 2021-22 increased 4.8% over 2020-21 full year results. 18 General Funds Summary Presents comparisons of year-to-date balances to the fiscal year budget and to the actual results for the prior year for the general fund. General Fund Revenue As of JULY 31 (dollars in thousands) Budget Estimate 2023-2024 Actual Year-to-Date 2023-2024 2022-2023 Revenues Local Taxes Sales Taxes Privilege License Fees State Shared Taxes State Sales Tax State Income Tax Vehicle License Tax Primary Property Tax Licenses and Permits Cable Communications Municipal Court Fines and Forfeitures Court Default Fee Police Library Parks and Recreation Engineering & Architectural Services Planning & Development Street Transportation Fire Emergency Transportation Service Hazardous Materials Inspection Fee Other Interest Other Fees and Service Charges Total Revenues $ $ 699,157 3,005 65,562 $ 220 43,479 135 248,655 435,656 85,627 206,935 3,070 8,000 31,080 36,313 10,796 (1,124) 152 (2,060) 28,422 25,682 10,826 (952) 147 (2,300) 7,987 778 14,511 438 6,372 1,811 6,946 689 70 1,625 53 887 137 4,555 639 59 1,211 21 896 156 3,915 51,332 1,700 18,066 14,540 19,250 (29,268) 51 527 2,492 2,016 (20,333) 80 2,612 717 1,503 1,833,837 19 $ $ 124,772 $ 96,914 General Fund Expenditures As of JULY 31 (dollars in thousands) Budget Estimate 2023-2024 Actual Year-to-Date 2023-2024 2022-2023 Expenditures and Encumbrances General Government Mayor City Council City Manager Information Technology Services Public Information Equal Opportunity Law City Auditor City Clerk Human Resources Budget and Research Finance Others Total General Government $ 2,700 6,854 11,109 92,038 4,778 3,486 34,148 3,682 9,744 30,340 4,563 29,093 1,944 234,477 $ 193 $ 429 967 13,463 270 284 2,141 362 1,005 1,916 329 2,429 340 24,128 152 331 606 3,992 219 223 1,731 207 270 5,398 452 1,934 331 15,844 Criminal Justice Municipal Court Public Defender Total Criminal Justice 38,970 6,295 45,265 2,820 173 2,993 3,022 123 3,145 Public Safety Police Fire Others Total Public Safety 741,278 481,278 1,222,556 65,674 56,303 121,977 58,673 31,407 90,080 Transportation Street Transportation Public Transit Total Transportation 25,473 25,473 616 615 612 1,891 2,502 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 9,771 20,578 7,072 2,003 39,424 605 1,364 378 42 2,389 462 1,519 254 88 2,323 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 128,060 49,528 40,944 9,235 227,767 12,300 6,494 2,529 2,755 24,078 9,839 7,029 2,304 1,798 20,970 Environmental Services Public Works Environmental Programs Others Total Environmental Services 36,023 1,789 715 38,527 4,213 142 85 4,440 7,105 81 47 7,232 Capital Improvement 121,932 3,368 (835) Vacancy Savings (28,000) - - Contingencies Total Expenditures and Encumbrances 101,247 $ 20 2,028,668 $ - - 183,988 $ 141,261 Citywide Summary Presents the City's summarized comparisons of the year-to-date balances to the fiscal year budget and to the actual results for the prior year. Citywide Operating Revenue As of JULY 31 (dollars in thousands) Source General Funds Local Taxes: Sales Taxes Privilege License Fees State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax Primary Property Tax Licenses and Permits Cable Communications Municipal Court Police Library Fees Parks and Recreation Planning & Development Street Transportation Fire Interest Other Fees and Service Charges Budget Estimate 2023-2024 $ 699,157 3,005 Total General Funds Special Revenue and Debt Service Funds Neighborhood Protection Public Safety Enhancement & Expansion Parks and Preserves Golf Courses Transit 2000 & 2050 Court Awards Planning and Development Capital Construction Sports Facilities Highway User Revenue Regional Transit Revenues Community Reinvestment Other Restricted Fees Grants G.O. Bond/Secondary Property Tax Total Special Revenue and Debt Service Funds Enterprise Funds Aviation Convention Center Water System Wastewater Solid Waste Total Enterprise Funds Total Operating Revenues $ 65,562 $ 220 43,479 135 248,655 435,656 85,627 206,935 3,070 8,000 8,764 14,511 438 6,372 1,811 6,946 71,098 14,540 19,250 31,080 36,313 10,796 (1,124) 152 (2,060) 759 1,625 53 887 137 4,555 (28,690) 2,492 2,016 28,422 25,682 10,826 (952) 147 (2,300) 698 1,211 21 896 156 3,915 (17,641) 717 1,503 1,833,837 124,772 96,914 53,788 136,966 56,273 10,130 402,264 4,673 84,311 6,157 32,452 158,475 82,429 11,905 51,070 790,214 134,938 3,866 10,303 4,215 504 30,457 (3,717) 15,770 594 1,935 13,089 7,327 166 (9,854) (44,230) (695) 2,527 5,941 2,623 567 20,605 (1,954) 17,506 413 1,726 12,691 3,268 329 (6,005) (76,584) (588) 2,016,044 29,730 (16,935) 528,508 112,998 627,172 289,188 197,194 43,541 8,139 79,474 18,448 17,276 12,023 5,826 60,867 18,108 17,243 1,755,060 166,877 114,068 321,380 $ 194,047 5,604,941 21 Actual Year-to-Date 2023-2024 2022-2023 $ $ Citywide Operating Expenditures As of JULY 31 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2023-2024 2022-2023 Budget 2023-2024 24,128 $ 208 24,336 15,844 1,006 16,850 45,265 9,015 54,280 2,993 662 3,655 3,145 555 3,700 Public Safety General Funds Other Funds Total Public Safety 1,222,556 325,176 1,547,732 121,977 22,603 144,580 90,080 19,469 109,549 Transportation General Funds Other Funds Total Transportation 25,473 888,969 914,442 615 52,815 53,430 2,502 228,848 231,350 Community Development General Funds Other Funds Total Community Development 39,424 375,715 415,139 2,389 19,068 21,457 2,323 16,571 18,894 Community Enrichment General Funds Other Funds Total Community Enrichment 227,767 250,687 478,454 24,078 34,965 59,043 20,970 22,406 43,376 Environmental Services General Funds Other Funds Total Environmental Services 38,527 880,336 918,863 4,440 91,291 95,731 7,232 74,695 81,927 Debt Service General Funds Other Funds Total Debt Service 136,900 136,900 11,333 11,333 87,270 87,270 121,932 1,649,990 1,771,922 3,368 21,751 25,119 (835) 76,504 75,669 Non-Departmental Grants General Funds Other Funds Total Non-Departmental Grants 75,839 75,839 - - Vacancy Savings General Funds Other Funds Total Vacancy Savings (28,000) (28,000) - - Contingencies General Funds Other Funds Total Contingencies 101,247 75,500 176,747 - - 2,028,668 4,721,369 6,750,037 183,988 254,696 438,684 $ 141,261 527,324 668,583 $ Criminal Justice General Funds Other Funds Total Criminal Justice Capital Improvement General Funds Other Funds Total Capital Improvement Total Operating General Funds Other Funds Total Operating Budget $ 234,477 53,242 287,719 22 $ $ Citywide Detail Presents, in detail, the results of the City's operations for the current month and for the fiscal year-to-date. Included are breakdowns of the City's revenues, operating budget expenditures, capital budget expenditures and bonds authorized and sold. Citywide Operating Revenue by Source For the Month Ended JULY 31 2023 2022 Budget Estimate 2023-2024 Source Actual Year-to-Date 2023-2024 2022-2023 General Funds $ 43,478,711 134,823 Local Taxes: Sales Taxes Privilege License Fees 65,782,381 43,613,534 Total Local Taxes 702,162,501 65,782,381 43,613,534 31,079,661 36,312,872 10,795,675 28,421,549 25,681,939 10,826,392 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 248,655,000 435,656,000 85,627,000 31,079,661 36,312,872 10,795,675 28,421,549 25,681,939 10,826,392 78,188,208 64,929,880 769,938,000 78,188,208 64,929,880 (1,124,344) (952,019) Primary Property Tax 206,935,000 (1,124,344) (952,019) 65,562,469 219,912 $ $ Total State Shared Taxes 699,157,051 3,005,450 $ 65,562,469 219,912 $ 43,478,711 134,823 151,530 147,004 Licenses and Permits 3,070,000 151,530 147,004 (2,060,000) (2,300,000) Cable Communications 8,000,000 (2,060,000) (2,300,000) 689,449 69,933 638,662 59,223 Municipal Court: Fines and Forfeitures Court Default Fee 7,986,764 777,600 689,449 69,933 638,662 59,223 759,382 697,885 8,764,364 759,382 697,885 1,624,831 1,211,473 14,511,088 1,624,831 1,211,473 53,049 21,432 Library Fees 438,376 53,049 21,432 887,088 896,216 Parks and Recreation 6,371,912 887,088 896,216 136,573 155,959 Planning and Development 1,810,900 136,573 155,959 4,555,094 3,914,621 Street Transportation 6,946,062 4,555,094 3,914,621 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other 51,332,000 1,700,000 18,066,317 (29,268,163) 51,300 526,937 (20,332,922) 80,150 2,611,834 71,098,317 (28,689,926) (17,640,938) Interest 14,539,712 2,491,983 716,611 Other Fees and Service Charges 19,250,440 2,016,490 1,502,706 1,833,836,672 124,772,339 96,914,364 (29,268,163) 51,300 526,937 (20,332,922) 80,150 2,611,834 (28,689,926) (17,640,938) 2,491,983 716,611 2,016,490 1,502,706 124,772,339 96,914,364 Total Municipal Court Police Total Fire Total General Funds Special Revenue and Debt Service Funds 2,654,281 189,592 947,957 74,605 1,749,785 124,985 624,923 27,166 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 37,394,341 2,671,453 13,356,262 365,618 2,654,281 189,592 947,957 74,605 1,749,785 124,985 624,923 27,166 3,866,435 2,526,859 Total Neighborhood Protection 53,787,674 3,866,435 2,526,859 7,671,005 2,499,876 131,877 4,558,712 1,342,615 39,268 103,978,215 32,710,001 278,000 7,671,005 2,499,876 131,877 4,558,712 1,342,615 39,268 10,302,758 5,940,595 136,966,216 10,302,758 5,940,595 4,215,382 2,622,786 56,272,960 4,215,382 2,622,786 Public Safety Enhancement & Expansion: Police Fire Interest/Other Total Public Safety Enhancement & Expansion Parks and Preserves 23 Citywide Operating Revenue by Source For the Month Ended JULY 31 2023 2022 $ 253,420 195,385 16,432 38,783 $ Budget Estimate 2023-2024 Source 289,344 230,341 4,822 42,829 Golf Courses: Fees Coffee Shops Concessions Interest Other $ 6,566,050 3,022,550 45,000 496,615 Actual Year-to-Date 2023-2024 2022-2023 $ 253,420 195,385 16,432 38,783 $ 289,344 230,341 4,822 42,829 504,020 567,336 Total Golf Courses 10,130,215 504,020 567,336 25,937,996 4,518,843 17,054,983 3,549,952 Transit 2000 & 2050: Sales Taxes Interest/Other 364,772,821 37,490,765 25,937,996 4,518,843 17,054,983 3,549,952 30,456,839 20,604,935 402,263,586 30,456,839 20,604,935 (3,716,515) (1,954,199) Court Awards 4,672,692 (3,716,515) (1,954,199) 15,769,697 17,505,861 Planning and Development 84,311,300 15,769,697 17,505,861 594,112 413,064 Capital Construction 6,157,424 594,112 413,064 1,681,699 252,877 1,661,936 63,781 Sports Facilities: Sales Taxes Interest/Other 28,487,629 3,964,315 1,681,699 252,877 1,661,936 63,781 1,934,576 1,725,717 Total Sports Facilities 32,451,944 1,934,576 1,725,717 12,620,059 445,346 22,876 12,551,000 126,937 13,481 Highway User Revenue: Highway User Revenue Interest Other 157,955,000 500,000 20,000 12,620,059 445,346 22,876 12,551,000 126,937 13,481 13,088,281 12,691,418 158,475,000 13,088,281 12,691,418 - - Total Transit 2000 & 2050 Total Highway User Revenue Local Transportation Assistance - - - 7,326,919 3,268,202 Regional Transit Revenues 82,428,550 7,326,919 3,268,202 166,435 329,316 Community Reinvestment 11,905,291 166,435 329,316 (9,854,249) (6,004,932) Other Restricted Fees 51,069,507 (9,854,249) (6,004,932) 351,707 15,442,648 5,171,980 222,879 13,493,442 (2,573,952) Grants: Public Housing: Rentals Grants Other 5,139,519 180,635,763 60,510,644 351,707 15,442,648 5,171,980 222,879 13,493,442 (2,573,952) 20,966,335 11,142,369 246,285,926 20,966,335 11,142,369 (5,819,268) (44,782,088) (5,950,568) (8,644,726) (9,853,847) (58,198,347) (6,957,953) (12,716,107) 69,661,897 136,907,541 58,578,515 278,779,742 (5,819,268) (44,782,088) (5,950,568) (8,644,726) (9,853,847) (58,198,347) (6,957,953) (12,716,107) (65,196,650) (87,726,254) Total Other 543,927,695 (65,196,650) (87,726,254) (44,230,315) (76,583,885) Total Grants 790,213,621 (44,230,315) (76,583,885) (694,642) - (589,192) 981 131,092,075 3,846,046 (694,642) - (589,192) 981 (694,642) (588,211) 134,938,121 (694,642) (588,211) 29,729,733 (16,935,138) 2,016,044,101 29,729,733 (16,935,138) Total Public Housing Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond/Secondary Property Tax Secondary Property Tax Interest Total G.O. Bond/Secondary Property Tax Total Special Revenue and Debt Service Funds 24 Citywide Operating Revenue by Source For the Month Ended JULY 31 2023 2022 Budget Estimate 2023-2024 Source Actual Year-to-Date 2023-2024 2022-2023 Enterprise Funds AVIATION: $ 10,774,579 $ 29,941,972 1,518,164 256,932 241,924 281,827 525,172 8,904,700 25,759,849 310,072 (23,646,023) 257,009 281,925 155,830 43,540,570 12,023,362 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge $ Total Aviation 132,626,916 374,531,216 8,130,000 3,270,252 2,984,888 3,584,906 3,380,000 $ 10,774,579 29,941,972 1,518,164 256,932 241,924 281,827 525,172 $ 8,904,700 25,759,849 310,072 (23,646,023) 257,009 281,925 155,830 528,508,178 43,540,570 12,023,362 86,163,389 25,634,387 1,200,000 5,834,213 1,921,176 383,969 3,999,704 1,755,099 70,778 112,997,776 8,139,358 5,825,581 567,565,219 5,000,000 9,382,054 10,703,646 6,200,000 7,213,000 21,108,100 55,377,838 202,126 2,691,186 131,253 413,700 946,802 19,710,901 56,550,339 246,608 2,610,377 817,844 715,320 311,581 (384,783) 627,172,019 79,473,806 60,867,286 CONVENTION CENTER: 5,834,213 1,921,176 383,969 3,999,704 1,755,099 70,778 8,139,358 5,825,581 Excise Taxes Operating Revenue Interest Total Convention Center WATER SYSTEM: 55,377,838 202,126 2,691,186 131,253 413,700 946,802 19,710,901 56,550,339 246,608 2,610,377 817,844 715,320 311,581 (384,783) 79,473,806 60,867,286 Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other Total Water System WASTEWATER: 17,304,974 382,860 996,735 (236,925) 14,012,906 1,895,000 649,920 321,549 1,228,777 Sewer Service Charges Multi-City Development Fees Interest Other 232,083,321 16,357,249 6,200,000 9,367,000 25,180,224 17,304,974 382,860 996,735 (236,925) 14,012,906 1,895,000 649,920 321,549 1,228,777 18,447,644 18,108,152 Total Wastewater 289,187,794 18,447,644 18,108,152 178,603,138 13,906,117 450,000 4,235,040 15,165,119 979,201 163,182 968,388 14,653,831 1,224,819 53,240 1,311,483 197,194,295 17,275,890 17,243,373 1,755,060,062 166,877,268 114,067,754 SOLID WASTE: $ 15,165,119 979,201 163,182 968,388 14,653,831 1,224,819 53,240 1,311,483 17,275,890 17,243,373 166,877,268 114,067,754 321,379,340 $ 194,046,980 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ 25 5,604,940,835 $ 321,379,340 $ 194,046,980 Citywide Operating Expenditures by Program For the Month Ended JULY 31 2023 2022 Program Budget Estimate 2023-2024 2023-2024 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2023-2024 2022-2023 General Government $ 192,825 $ 428,740 987,233 14,573,996 158,200 271,556 313,961 2,246,929 361,756 1,004,971 1,969,245 193,199 11,467 329,279 3,566,488 (2,274,125) 151,646 331,247 628,659 4,969,234 160,133 268,045 256,007 1,818,293 206,757 269,538 5,445,951 172,397 10,207 451,753 2,638,876 (928,941) 24,335,721 16,849,802 Mayor $ City Council City Manager Information Technology Services Government Relations Public Information Equal Opportunity Law City Auditor City Clerk Human Resources Retirement Systems Phoenix Employment Relations Board Budget and Research Finance Regional Wireless Cooperative Total General Government 2,700,000 6,854,261 17,288,658 105,471,392 1,580,787 4,803,103 4,066,660 35,832,717 3,682,271 9,744,371 38,268,397 852,015 129,248 4,562,718 45,001,681 6,881,164 $ 192,825 428,740 987,233 14,573,996 158,200 271,556 313,961 2,246,929 361,756 1,004,971 1,969,245 193,199 11,467 329,279 3,566,488 (2,274,125) $ 151,646 331,247 628,659 4,969,234 160,133 268,045 256,007 1,818,293 206,757 269,538 5,445,951 172,397 10,207 451,753 2,638,876 (928,941) $ 192,825 428,740 987,233 13,526,271 158,200 271,556 313,961 2,246,929 361,756 1,004,971 1,915,705 193,199 11,467 329,279 2,583,367 (2,274,125) $ 1,047,726 53,540 983,122 - 287,719,443 24,335,721 16,849,802 22,251,333 2,084,388 47,984,830 6,295,331 3,482,733 172,733 3,577,137 122,583 2,956,709 172,733 526,023 - 54,280,161 3,655,466 3,699,720 3,129,442 526,023 980,679,674 567,051,944 - 83,425,690 61,154,192 - 73,464,221 36,084,122 289 83,256,425 60,984,796 - 169,266 169,397 - 1,547,731,618 144,579,883 109,548,631 144,241,220 338,662 Criminal Justice 3,482,733 172,733 3,577,137 122,583 3,655,466 3,699,720 Municipal Court Public Defender Total Criminal Justice Public Safety 83,425,690 61,154,192 - 73,464,221 36,084,122 289 144,579,883 109,548,631 Police Fire Other Total Public Safety Transportation 13,157,727 1,737,099 30,939,467 7,595,476 14,104,197 2,323,612 34,760,942 180,160,755 Street Transportation Street Lighting Aviation Public Transit 126,809,355 10,266,365 442,525,728 334,840,200 13,157,727 1,737,099 30,939,467 7,595,476 14,104,197 2,323,612 34,760,942 180,160,755 12,762,025 1,737,099 22,699,627 7,595,476 395,702 8,239,841 - 53,429,769 231,349,506 Total Transportation 914,441,648 53,429,769 231,349,506 44,794,226 8,635,543 Community Development 6,550,068 10,826,764 1,598,443 2,481,682 5,833,039 9,333,073 1,318,435 2,409,052 Planning and Development Housing Economic Development Neighborhood Services Department 96,602,351 199,791,557 27,666,019 91,078,576 6,550,068 10,826,764 1,598,443 2,481,682 5,833,039 9,333,073 1,318,435 2,409,052 6,550,068 10,779,171 1,110,923 2,481,682 47,592 487,520 - 21,456,957 18,893,599 Total Community Development 415,138,503 21,456,957 18,893,599 20,921,845 535,112 150,922,077 52,313,101 76,642,732 12,759,875 172,977,937 6,219,799 6,618,485 13,924,245 6,546,645 21,841,552 1,063,173 11,112,855 4,116,430 438,090 11,886,138 7,177,059 7,209,679 1,093,813 12,249,992 3,408,635 350,373 13,871,280 6,546,645 20,384,252 11,102,547 4,116,430 438,090 52,965 1,457,300 1,063,173 10,308 - 478,454,006 59,042,989 43,375,689 56,459,243 2,583,746 Community Enrichment 13,924,245 6,546,645 21,841,552 1,063,173 11,112,855 4,116,430 438,090 11,886,138 7,177,059 7,209,679 1,093,813 12,249,992 3,408,635 350,373 59,042,989 43,375,689 Parks and Recreation Library Convention Center Sports and Cultural Facilities Human Services Public Parking Facilities Other Total Community Enrichment 26 Citywide Operating Expenditures by Program For the Month Ended JULY 31 2023 2022 Budget Estimate 2023-2024 Program 2023-2024 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2023-2024 2022-2023 Environmental Services $ 50,985,574 $ 24,723,468 14,399,945 5,124,423 395,016 102,912 38,609,550 22,570,121 11,916,384 8,409,906 360,894 59,872 Water System Wastewater Solid Waste Management Public Works Environmental Programs Manager's Office of Sustainability 95,731,338 81,926,725 Total Environmental Services $ 457,619,596 224,901,618 182,579,989 47,591,219 5,070,133 1,100,374 $ 50,985,574 24,723,468 14,399,945 5,124,423 395,016 102,912 $ 38,609,550 22,570,121 11,916,384 8,409,906 360,894 59,872 $ 36,959,208 16,691,650 13,651,612 4,214,447 395,016 102,912 $ 14,026,366 8,031,818 748,333 909,976 - 918,862,929 95,731,338 81,926,725 72,014,845 23,716,493 12,670,339 23,155,869 100,500 14,829,694 626,325 3,029,663 558,750 12,892,226 6,768,002 377,425 17,184,992 12,573,822 1,087,431 900,036 600,000 17,778,600 11,412,282 33,000 321,419 1,055,862 1,929,656 8,375 1,235,808 52,194 252,472 46,563 1,074,352 564,000 31,452 1,432,083 1,047,818 90,619 50,000 1,481,550 951,024 2,750 26,786 30,743,573 1,422,903 177,946 1,621,917 247,010 878,372 27,646 4,233,523 4,006,543 20,431 12,083,843 4,896,197 90,619 1,739,413 50,000 20,316,411 4,664,564 22,417 26,786 1,055,862 1,929,656 8,375 1,235,808 52,194 252,472 46,563 1,074,352 564,000 31,452 1,432,083 1,047,818 90,619 50,000 1,481,550 951,024 2,750 26,786 - General Obligation Debt Service $ 1,055,862 1,929,656 8,375 1,235,808 52,194 252,472 46,563 1,074,352 564,000 31,452 1,432,083 1,047,818 90,619 50,000 1,481,550 951,024 2,750 26,786 30,743,573 1,422,903 177,946 1,621,917 247,010 878,372 27,646 4,233,523 4,006,543 20,431 12,083,843 4,896,197 90,619 1,739,413 50,000 20,316,411 4,664,564 22,417 26,786 11,333,362 87,270,113 Total Debt Service 136,900,375 11,333,362 87,270,113 11,333,362 - 25,118,742 75,668,798 Capital Improvement 1,771,921,923 25,118,742 75,668,798 25,118,742 - - - Non-Departmental Grants 75,839,421 - - - - - - Vacancy Savings (28,000,000) - - - - - - Contingencies 176,747,000 - - - - 438,684,226 $ 668,582,583 Cultural Facilities Downtown Development Economic Development Environmental Services Fire Protection Freeway Mitigation Historic/Neighborhood Preservation Human Services Information Systems Libraries Maintenance Service Centers Mountain Preserves/Parks Municipal Administration Buildings Police Protection Public Housing Renovation Sanitary Sewers Secondary Property Tax Solid Waste Enterprise Bonds Storm Sewer Improvements Street Improvements Street Light Refinancing Water System $ 6,750,037,027 $ 27 438,684,226 $ 668,582,583 $ 400,264,258 $ 38,419,968 Capital Expenditures and Encumbrances 2023-2024 Program General Government Arts and Cultural Facilities Economic Development Facilities Management Finance Fire Protection Housing Human Services Information Technology Libraries Neighborhood Services Non-Departmental Capital Parks and Mountain Preserves Planning & Historic Preservation Police Protection Public Art Program Public Transit Regional Wireless Cooperative Street Transportation & Drainage General Government Subtotal Enterprise Aviation Phoenix Convention Center Solid Waste Disposal Wastewater Water System Enterprise Subtotal Total Capital Budget Program 2022-2023 Actual Yearto-Date Actual Yearto-Date Budget From Operating Funds Budget Actual 2023-2024 Year-to-Date Capital Amounts From Capital Funds Budget Actual Unencumbered Budget $ 2,797,246 $ 18,088,263 53,901,968 1,030,894 52,713,739 122,276,471 7,762,972 52,359,900 9,228,892 10,588,009 668,406,841 156,600,628 26,563,000 17,759,000 7,634,150 516,206,676 6,001,000 389,887,281 5,989 $ 217,045 641,056 1,636,383 4,015,699 15,019 1,293,563 62,679 18,194 (7,370,431) 3,093,283 6,557,398 398,565 7,474,824 7,498,425 10,201,637 (875,562) 84,541 1,119,431 25,600 (8,276) 28,217 (7,439,399) 243,731 95,858 6,606,776 4,930,443 $ 1,696,965 $ 18,088,263 32,875,714 20,044,385 109,111,590 7,162,972 44,222,725 3,933,792 10,588,009 37,000,000 129,877,565 26,563,000 2,588,233 515,949,670 226,228,532 5,763 217,045 513,610 1,512,518 3,770,378 15,019 1,293,563 62,679 18,194 3,078,593 33,391 7,474,824 3,520,614 $ 1,100,281 $ 21,026,254 1,030,894 32,669,354 13,164,881 600,000 8,137,175 5,295,100 631,406,841 26,723,063 17,759,000 5,045,917 257,006 6,001,000 163,658,749 226 127,446 123,865 245,321 (7,370,431) 14,690 6,557,398 365,174 3,977,811 $ 2,791,257 17,871,218 53,260,912 1,030,894 51,077,356 118,260,772 7,747,953 51,066,337 9,166,213 10,569,815 675,777,272 153,507,345 26,563,000 11,201,602 7,235,585 508,731,852 6,001,000 382,388,856 $ 2,119,806,930 $ 25,557,690 $ 15,012,997 $ 1,185,931,415 $ 21,516,191 $ 933,875,515 $ 4,041,499 $ 2,094,249,240 $ $ 1,192,244,623 45,697,400 38,134,630 381,835,887 630,118,072 2,288,030,612 $ 4,407,837,542 $ $ 26,845,666 185,819 574,708 360,399 2,528,344 30,494,935 $ 56,052,625 $ $ 2,408,191 51,522 7,195,149 9,377,849 37,953,913 56,986,624 $ 232,286,116 8,927,400 14,373,212 134,949,019 195,454,761 585,990,508 $ 71,999,621 $ 1,771,921,923 28 $ $ $ 1,855,733 15,772 402,042 113,600 1,215,405 3,602,551 $ 25,118,742 $ $ 959,958,507 36,770,000 23,761,418 246,886,868 434,663,311 1,702,040,104 $ 2,635,915,619 $ $ 24,989,933 170,047 172,666 246,799 1,312,939 26,892,384 $ $ 1,165,398,957 45,511,581 37,559,922 381,475,488 627,589,728 2,257,535,677 $ 30,933,883 $ 4,351,784,917 Bonds Authorized and Sold As of JULY 31 (dollars in thousands) Authorized Sold Available 1988 Authorizations General Obligation Bonds Freeway Mitigation, Neighborhood Stabilization, and Slum and Blight Elimination Bonds Fully Issued $ Total General Obligation Bonds Revenue Bonds Bonds Fully Issued Total 1988 Authorizations 29,285 884,175 $ 28,285 884,175 $ 1,000 - 913,460 912,460 1,000 143,890 143,890 - 1,057,350 1,056,350 1,000 66,300 125,300 24,800 61,500 12,000 33,000 91,500 74,000 77,000 78,800 66,000 43,700 64,600 124,685 24,170 60,700 11,205 32,100 89,275 71,645 72,575 77,685 65,950 43,700 1,700 615 630 800 795 900 2,225 2,355 4,425 1,115 50 - 753,900 738,290 15,610 81,000 11,100 198,700 12,800 104,622 74,705 29,178 115,500 107,295 78,200 65,400 63,385 8,510 190,610 8,345 85,510 61,200 21,100 102,290 81,900 58,135 61,770 17,615 2,590 8,090 4,455 19,112 13,505 8,078 13,210 25,395 20,065 3,630 878,500 742,755 135,745 2001 Authorization General Obligation Bonds Education, Youth and Family Cultural Facilities Computer Technology Environmental Cleanup Fire Protection Historic Preservation Library Facilities Street Improvements Neighborhood Protection and Senior Centers Parks, Open Space, and Recreational Facilities Police Protection Storm Sewer and Flood Protection Bonds Fully Issued Total 2001 Authorizations 2006 Authorization General Obligation Bonds Affordable Housing and Neighborhood Revitalization Computer Technology Education and Health Science Facilities Environmental Cleanup Family, Senior, and Youth Cultural Facilities Fire Protection Library Facilities and Improvements Parks, Open Space, and Recreational Facilities Police Protection Street Improvements Storm Sewer and Flood Protection Total 2006 Authorizations Total Bond Program $ 29 2,689,750 $ 2,537,395 $ 152,355