May 2023 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division May 31, 2023 To the Mayor and City Council: This is the City's Financial Report for May, the eleventh month of fiscal year 2022-23. 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 August 22, 2023 INDEPENDENT AUDITOR REPORT To the Chief Financial Officer, We have assessed the Finance Department’s (Finance) May 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 27, 2022. 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 May 2023 Table of Contents Expenditures by Programs Page Performance Status General Fund Expenditures General Fund Total Expenditures 1 Better than Expected General Government 1 Better than Expected 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 Expected Environmental Services 6 Better than Expected General Obligation Debt Service 6 Monitor and Consider Taking Action 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 Monitor and Consider Taking Action Aviation 16 Better than Expected Water System 17 Monitor and Consider Taking Action 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 Appendix A - Additional Detail for Revenues 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 18-19 19-20 20-21 21-22 22-23 May YTD Expenditures 1,114,329 1,158,429 1,214,849 1,293,588 1,454,532 Annual Expenditures * 1,214,362 1,282,831 1,371,152 1,470,251 1,678,643 Total General Fund % of Annual Expenditures 91.8% 90.3% 88.6% 88.0% 86.6% * For prior years-total actual expenditures, for current year-total approved budget net of adjustment for contingencies. $2,000,000 May YTD Expenditures $1,500,000 $1,000,000 Annual Expenditures * $500,000 $0 Better than Expected 18-19 19-20 20-21 21-22 22-23 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 2022-23 budgeted general fund expenditures are 14.2% higher than the fiscal year 2021-22 actuals. Fiscal year 2022-23 actual general fund expenditures through May are 12.4% higher than the same period in fiscal year 2021-22. General fund expenditures increased 7.2% in fiscal year 2021-22 over fiscal year 2020-21. This followed an increase of 6.9% from 2020-21 over 2019-20 and an increase of 5.6% from 2019-20 over 2018-19 fiscal results. General Government Fiscal Year 18-19 19-20 20-21 21-22 22-23 May YTD Expenditures 108,017 116,998 136,410 143,335 163,710 General Government Annual % of Annual Expenditures * Expenditures 94.4% 114,393 95.0% 123,100 88.5% 154,211 88.5% 161,907 78.7% 208,038 * For prior years-total actual expenditures, for current year-total approved budget $250,000 May YTD Expenditures $200,000 $150,000 $100,000 Annual Expenditures * $50,000 $0 Better than Expected 18-19 19-20 20-21 21-22 22-23 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 2022-23 budgeted general fund expenditures are 28.5% higher than the fiscal year 2021-22 actuals. Fiscal year 2022-23 actual general fund expenditures through May are 14.2% higher than the same period in fiscal year 2021-22. Largest driver accounting for increase year over year is Human Resource's $4.2 million charge for the Firefighters Cancer Reimbursement Fund Assessment. Largest drivers accounting for the year on year increase in budget include $20 million in Information Technology, additional $10 million in Human Resources of which $7 million is for additional Safety and Workers’ Compensation, $6 million in law, and $1.2 million in City Clerk. General fund expenditures increased 5.0% in fiscal year 2021-22 over fiscal year 2020-21. This followed an increase of 25.3% from 2020-21 over 2019-20 and an increase of 7.6% from 2019-20 over 2018-19 fiscal results. Criminal Justice Fiscal Year 18-19 19-20 20-21 21-22 22-23 Criminal Justice May YTD Expenditures 30,603 32,026 32,005 36,397 37,065 Annual Expenditures * 33,387 35,033 36,162 40,008 43,390 % of Annual Expenditures 91.7% 91.4% 88.5% 91.0% 85.4% * For prior years-total actual expenditures, for current year-total approved budget $50,000 May YTD Expenditures $40,000 $30,000 Annual Expenditures * $20,000 $10,000 $0 Better than Expected 18-19 19-20 20-21 21-22 22-23 Criminal justice expenditures include costs for municipal courts and public defenders. Fiscal year 2022-23 budgeted general fund expenditures are 8.5% higher than the fiscal year 2021-22 actuals. Fiscal year 2022-23 actual general fund expenditures through May are 1.8% higher than the same period in fiscal year 2021-22. General fund criminal justice expenditures increased 10.6% in fiscal year 2021-22 over fiscal year 2020-21. This followed an increase of 3.2% from 2020-21 over 2019-20 and an increase of 4.9% from 2019-20 over 2018-19 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 18-19 19-20 20-21 21-22 22-23 Public Safety May YTD Expenditures 771,806 801,172 826,661 870,725 989,981 Annual Expenditures * 841,467 893,403 925,920 992,648 1,088,575 % of Annual Expenditures 91.7% 89.7% 89.3% 87.7% 90.9% * For prior years-total actual expenditures, for current year-total approved budget $1,200,000 May YTD Expenditures $900,000 $600,000 Annual Expenditures * $300,000 $0 18-19 Monitor and Consider Taking Action 19-20 20-21 21-22 22-23 Public safety expenditures include costs for police and fire services. Fiscal year 2022-23 budgeted general fund public safety expenditures are 9.7% higher than the fiscal year 202122 actuals. Fiscal year 2022-23 actual general fund public safety expenditures through May are 13.7% higher than the same period in fiscal year 2021-22. General fund public safety expenditures increased 7.2% in fiscal year 2021-22 over fiscal year 2020-21. This followed an increase of 3.6% from 2020-21 over 2019-20 and an increase of 6.2% from 2019-20 over 2018-19 fiscal results. Transportation Fiscal Year 18-19 19-20 20-21 21-22 22-23 Transportation May YTD Expenditures 16,465 18,399 21,169 21,788 23,396 Annual Expenditures * 18,337 19,748 22,144 23,166 26,085 % of Annual Expenditures 89.8% 93.2% 95.6% 94.1% 89.7% * For prior years-total actual expenditures, for current year-total approved budget $30,000 $25,000 May YTD Expenditures $20,000 $15,000 $10,000 Annual Expenditures * $5,000 $0 Better than Expected 18-19 19-20 20-21 21-22 22-23 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 AHUR fund. Beginning in fiscal year 2018-19 street transportation is charging the majority of expenses to AHUR and will be transferring a portion of those to the General Fund. Fiscal year 2022-23 budgeted general fund transportation expenditures are 12.6% higher than the fiscal year 2021-22 actuals. Fiscal year 2022-23 actual general fund transportation expenditures through May are 7.4% higher than the same period in fiscal year 2021-22 due to the timing of AHUR charges. General fund transportation expenditures increased 4.6% in fiscal year 2021-22 over fiscal year 2020-21. This followed an increase of 12.1% from 2020-21 over 2019-20 and an increase of 7.7% from 2019-20 over 2018-19 fiscal results. Community Development Fiscal Year 18-19 19-20 20-21 21-22 22-23 May YTD Expenditures 19,653 20,842 21,877 25,711 27,753 Community Development Annual Expenditures * 21,238 22,542 24,114 28,225 36,748 % of Annual Expenditures 92.5% 92.5% 90.7% 91.1% 75.5% * For prior years-total actual expenditures, for current year-total approved budget $40,000 May YTD Expenditures $30,000 $20,000 Annual Expenditures * $10,000 $0 Better than Expected 18-19 19-20 20-21 21-22 22-23 Community development expenditures include costs for economic development and neighborhood services. The fiscal year 2022-23 budgeted general fund community development expenditures are 30.2% higher than the fiscal year 2021-22 actuals. Fiscal year 2022-23 actual general fund community development expenditures through May are 7.9% higher than the same period in fiscal year 2021-22. General fund community development expenditures increased 17.0% in fiscal year 2021-22 over fiscal year 2020-21. This followed an increase of 7.0% from 2020-21 over 2019-20 and an increase of 6.1% from 2019-20 over 2018-19 fiscal results. 2 General Fund Year-To-Date Expenditures (In Thousands of Dollars) Refer to detailed financial schedules pages 19 thru 29 Community Enrichment Fiscal Year 18-19 19-20 20-21 21-22 22-23 May YTD Expenditures 142,009 142,111 136,733 154,270 167,175 Community Enrichment Annual Expenditures * 156,552 155,417 158,589 173,631 197,458 % of Annual Expenditures 90.7% 91.4% 86.2% 88.8% 84.7% $250,000 May YTD Expenditures $200,000 $150,000 $100,000 Annual Expenditures * $50,000 * For prior years-total actual expenditures, for current year-total approved budget $0 18-19 Better than Expected 19-20 20-21 21-22 22-23 Community enrichment expenditures include costs for parks, recreational activities, senior centers and community centers. Fiscal year 2022-23 budgeted general fund community enrichment expenditures are 13.7% higher than the fiscal year 2021-22 actuals. Fiscal year 2022-23 actual general fund community enrichment expenditures through May are 8.4% higher than the same period in fiscal year 2021-22. General fund community enrichment expenditures increased 9.5% in fiscal year 2021-22 over fiscal year 2020-21. This followed an increase of 2.0% from 2020-21 over 2019-20 and a decrease of 0.7% from 2019-20 over 2018-19 fiscal results. Environmental Services Fiscal Year 18-19 19-20 20-21 21-22 22-23 May YTD Expenditures 15,925 16,936 18,892 23,936 21,810 Environmental Services Annual Expenditures * 16,886 19,180 20,905 26,508 29,534 % of Annual Expenditures 94.3% 88.3% 90.4% 90.3% 73.8% * For prior years-total actual expenditures, for current year-total approved budget $30,000 May YTD Expenditures $25,000 $20,000 $15,000 $10,000 Annual Expenditures * $5,000 $0 Better than Expected 18-19 19-20 20-21 21-22 22-23 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 2022-23 budgeted general fund environmental services expenditures are 11.4% higher than the fiscal year 202122 actuals. Fiscal year 2022-23 actual general fund environmental service expenditures through May are 8.9% lower than the same period in fiscal year 2021-22. The largest factor increasing annual budget is additional personal services. General fund environmental expenditures increased 26.8% in fiscal year 2021-22 over fiscal year 2020-21. This followed an increase of 9.0% from 2020-21 over 2019-20 and an increase of 13.6% from 2019-20 over 2018-19 fiscal results. 3 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 18-19 19-20 20-21 21-22 22-23 May YTD Expenditures 3,536,287 3,477,611 3,761,569 3,984,197 4,280,353 Total Citywide Annual Expenditures * 3,775,464 3,814,963 4,163,122 4,488,949 5,811,553 % of Annual Expenditures 93.7% 91.2% 90.4% 88.8% 73.7% * For prior years-total actual expenditures, for current year-total approved budget net of adjustments for contingencies and use of the early redemption fund. $7,000,000 $6,000,000 May YTD Expenditures $5,000,000 $4,000,000 $3,000,000 $2,000,000 Annual Expenditures * $1,000,000 $0 Better than Expected 18-19 19-20 20-21 21-22 22-23 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 2022-23 budget includes program budgeted ARPA amounts. Without contingencies and vacancy savings, and including programs budgeted for ARPA the budget for fiscal year 2022-23 anticipates an increase of 29.5% over fiscal year 2021-22 actuals in total operating expenditures. Actual expenditures through May are 7.4% higher than the same period in the prior fiscal year. General Government Fiscal Year 18-19 19-20 20-21 21-22 22-23 May YTD Expenditures 128,085 144,723 185,982 157,836 215,207 General Government Annual Expenditures * 138,349 157,200 207,451 238,925 245,463 % of Annual Expenditures 92.6% 92.1% 89.7% 66.1% 87.7% * For prior years-total actual expenditures, for current year-total approved budget $300,000 $250,000 May YTD Expenditures $200,000 $150,000 $100,000 Annual Expenditures * $50,000 $0 Monitor and Consider Taking Action 18-19 19-20 20-21 21-22 22-23 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 2022-23 anticipates an increase of 2.7% over fiscal year 2021-22 actuals in total operating expenditures. Actual expenditures through May are 36.3% higher than the same period in the prior fiscal year. Debt service budget and expenditures for the first five months ending November 2018 were moved out of functional areas and separately reported. In order to provide a more accurate year over year comparison, as of December 2018 all debt service budget and expenditures will be reported by functional areas. Criminal Justice Fiscal Year 18-19 19-20 20-21 21-22 22-23 Criminal Justice May YTD Expenditures 39,002 40,681 39,356 42,831 43,402 Annual Expenditures * 42,530 44,425 44,147 47,054 51,449 % of Annual Expenditures 91.7% 91.6% 89.1% 91.0% 84.4% * For prior years-total actual expenditures, for current year-total approved budget $60,000 May YTD Expenditures $50,000 $40,000 $30,000 Annual Expenditures * $20,000 $10,000 $0 Better than Expected 18-19 19-20 20-21 21-22 22-23 Criminal Justice expenditures include costs of the Municipal Court and the Public Defender’s office. Citywide criminal justice budget for fiscal year 2022-23 anticipates an increase of 9.3% over fiscal year 2021-22 actuals in total operating expenditures. Actual expenditures through May are 1.3% higher than the same period in the prior fiscal year. Debt service budget and expenditures for the first five months ending November 2018 were moved out of functional areas and separately reported. In order to provide a more accurate year over year comparison, as of December 2018 all debt service budget and expenditures will be reported by functional areas. 4 Citywide Year-To-Date Expenditures (In Thousands of Dollars) Refer to detailed financial schedules pages 19 thru 29 Public Safety Fiscal Year 18-19 19-20 20-21 21-22 22-23 Public Safety May YTD Expenditures 946,279 1,000,535 1,009,070 1,086,595 1,238,479 Annual Expenditures * 1,025,513 1,110,457 1,122,901 1,228,901 1,348,529 % of Annual Expenditures 92.3% 90.1% 89.9% 88.4% 91.8% $1,600,000 May YTD Expenditures $1,200,000 $800,000 Annual Expenditures * $400,000 * For prior years-total actual expenditures, for current year-total approved budget $0 18-19 Monitor and Consider Taking Action 19-20 20-21 21-22 22-23 Public Safety expenditures include costs of Police, Fire and Emergency Management. Citywide public safety budget for fiscal year 2022-23 anticipates an increase of 9.7% over fiscal year 2021-22 actuals in total operating expenditures. Actual expenditures through May are 14.0% higher than the same period in the prior fiscal year. Debt service budget and expenditures for the first five months ending November 2018 were moved out of functional areas and separately reported. In order to provide a more accurate year over year comparison, as of December 2018 all debt service budget and expenditures will be reported by functional areas. Transportation Fiscal Year 18-19 19-20 20-21 21-22 22-23 Transportation May YTD Expenditures 686,382 742,448 746,546 750,610 753,373 Annual Expenditures * 722,667 774,492 786,597 797,084 831,587 % of Annual Expenditures 95.0% 95.9% 94.9% 94.2% 90.6% $1,000,000 May YTD Expenditures $800,000 $600,000 $400,000 * For prior years-total actual expenditures, for current year-total approved budget Annual Expenditures * $200,000 $0 Better than Expected 18-19 19-20 20-21 21-22 22-23 Transportation expenditures include costs for Street lighting, maintenance and repair, Aviation and Public Transit. Citywide transportation budget for fiscal year 2022-23 anticipates an increase of 4.3% over fiscal year 2021-22 actuals in total operating expenditures. Actual expenditures through May are 0.4% higher than the same period in the prior fiscal year. Fiscal year 2021-22 financial results included a $70 million pension paydown. Debt service budget and expenditures for the first five months ending November 2018 were moved out of functional areas and separately reported. In order to provide a more accurate year over year comparison, as of December 2018 all debt service budget and expenditures will be reported by functional areas. Community Development Fiscal Year 18-19 19-20 20-21 21-22 22-23 May YTD Expenditures 176,922 190,633 217,809 201,704 241,692 Community Development Annual Expenditures * 195,716 229,793 245,310 227,960 306,574 % of Annual Expenditures 90.4% 83.0% 88.8% 88.5% 78.8% $400,000 May YTD Expenditures $300,000 $200,000 Annual Expenditures * $100,000 * For prior years-total actual expenditures, for current year-total approved budget $0 Better than Expected 18-19 19-20 20-21 21-22 22-23 Community Development expenditures include costs for Neighborhood Services, Housing, Planning and Economic Development. Citywide community development budget for fiscal year 2022-23 anticipates an increase of 34.5% over fiscal year 2021-22 actuals in total operating expenditures. Actual expenditures through May are 19.8% higher than the same period in the prior fiscal year. Debt service budget and expenditures for the first five months ending November 2018 were moved out of functional areas and separately reported. In order to provide a more accurate year over year comparison, as of December 2018 all debt service budget and expenditures will be reported by functional areas. 5 Citywide Year-To-Date Expenditures (In Thousands of Dollars) Refer to detailed financial schedules pages 19 thru 29 Community Enrichment Fiscal Year 18-19 19-20 20-21 21-22 22-23 May YTD Expenditures 288,290 289,202 348,984 380,922 430,667 Community Enrichment Annual Expenditures * 317,465 316,680 390,805 420,501 479,012 % of Annual Expenditures 90.8% 91.3% 89.3% 90.6% 89.9% $600,000 May YTD Expenditures $450,000 $300,000 Annual Expenditures * $150,000 * For prior years-total actual expenditures, for current year-total approved budget $0 18-19 19-20 20-21 21-22 22-23 Expected Community Enrichment expenditures include costs for Parks, Libraries, the Convention Center, Senior Centers and Community Centers. Citywide community enrichment budget for fiscal year 2022-23 anticipates an increase of 13.9% over fiscal year 2021-22 actuals in total operating expenditures. Actual expenditures through May are 13.1% higher than the same period in the prior fiscal year. Debt service budget and expenditures for the first five months ending November 2018 were moved out of functional areas and separately reported. In order to provide a more accurate year over year comparison, as of December 2018 all debt service budget and expenditures will be reported by functional areas. Environmental Services Fiscal Year 18-19 19-20 20-21 21-22 22-23 May YTD Expenditures 624,084 636,305 673,357 692,593 760,253 Environmental Services Annual Expenditures * 670,219 692,524 734,733 752,386 853,197 % of Annual Expenditures 93.1% 91.9% 91.6% 92.1% 89.1% $1,000,000 May YTD Expenditures $750,000 $500,000 Annual Expenditures * $250,000 * For prior years-total actual expenditures, for current year-total approved budget $0 18-19 Better than Expected 19-20 20-21 21-22 22-23 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 2022-23 anticipates an increase of 13.4% over fiscal year 2021-22 actuals in total operating expenditures. Actual expenditures through May are 9.8% higher than the same period in the prior fiscal year. Debt service budget and expenditures for the first five months ending November 2018 were moved out of functional areas and separately reported. In order to provide a more accurate year over year comparison, as of December 2018 all debt service budget and expenditures will be reported by functional areas. Citywide Debt Service Expenditures Fiscal Year 18-19 19-20 20-21 21-22 22-23 May YTD Expenditures 106,916 119,923 120,972 120,468 196,950 Annual Expenditures * 116,634 130,839 131,938 131,081 198,070 General Obligation Debt Service % of Annual Expenditures 91.7% 91.7% 91.7% 91.9% 99.4% $240,000 May 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 18-19 19-20 20-21 21-22 22-23 Monitor and Consider Taking Action General obligation debt service expenditures budget for fiscal year 2022-23 has an increase of 51.1% over fiscal year 2021-22 actuals in total operating expenditures. Actual debt service expenditures through May 2023 are 63.5% higher 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. Note - Debt service budgeted and actual expenditures for the first five months of fiscal year 2018-19 were moved out of functional areas and separately reported. To provide a more accurate year-to-year comparison from December 2018 forward, all debt service budgeted and actual expenditures are reported by functional areas. 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 19-20 20-21 21-22 22-23 (Budget) 22-23 (YTD) $ 500,745 $ 684,798 $ 525,852 $ 1,547,308 $ 18-19 General Government $ 384,131 408,628 Discussion: Major projects in fiscal year 2018-19 include $135 million for street and sidewalk maintenance, $48 million on Light Rail, $43 million transit bus and vehicle purchases, $33 million major streets, $21 million parks and preserves improvements, and $10 million for telephone system network replacement. General Government 22-23 (YTD) Major projects in fiscal year 2019-20 include $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. 22-23 (Budget) 21-22 Major projects in fiscal year 2020-21 include $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. 20-21 Major projects in fiscal year 2021-22 include $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 18-19 Major projects budgeted for fiscal year 2022-23 include $195 million for Light Rail extension, construction, right-of-way and acquisition of property, $76 million to purchase standard buses, design first corridor Bus Rapid Transit, and add an operational garage, $76 million to acquire parcels along the Capitol and I-10 corridor, $70 million to construct and complete major street projects, $63 million for debt service/principal and interest for Aviation and Convention Center, $25 million on funds for construction cost of affordable housing, $21 million to improve three Pedestrian Hybrid Beacons, and $20 million to procure and implement a Time and Labor System. Additionally, there is $100 million in contingency budget for undetermined capital expenditures. 19-20 20-21 21-22 $ 254,523 $ 172,418 $ 115,395 18-19 Aviation $ 552,972 $0 $500,000 22-23 (Budget) 22-23 (YTD) $ $ 567,088 $1,000,000 $1,500,000 38,807 Discussion: Major projects in fiscal year 2018-19 include $268 million for PHX Sky Train stage 2 and $128 million for Terminal 4 South 1 concourse. Aviation Major projects in fiscal year 2019-20 include $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. 22-23 (YTD) Major projects in fiscal year 2020-21 include $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. 22-23 (Budget) 21-22 Major events in fiscal year 2021-22 include $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. 20-21 19-20 18-19 $0 $200,000 $400,000 $600,000 Major projects budgeted for fiscal year 2022-23 include $69 million for Concourse Construction, $56 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, $17 million to relocate American Airlines Cargo Transfer Area, $17 million Paging System Upgrade, $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 $189 million in contingencies for the Airport Development Plan. 7 Capital Expenditures (In Thousands of Dollars) Refer to detailed financial schedules pages 19 thru 29 19-20 20-21 21-22 $ 52,148 $ 31,640 $ 84,751 18-19 Phoenix Convention Center $ 36,542 22-23 (Budget) 22-23 (YTD) $ $ 169,543 111,540 Discussion: 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 total $24 million for fiscal year 2020-21. Fiscal year 2021-22 includes the $47 million purchase of 100 West Washington Street. Phoenix Convention Center 22-23 (YTD) 22-23 (Budget) 21-22 Fiscal year 2022-23 budget includes $150 million to design and construct the second phase of building and garage renovations at 100 West Washington Street. 20-21 19-20 18-19 $0 18-19 Solid Waste $ 7,857 19-20 20-21 21-22 $ 5,490 $ 8,796 $ 28,986 $50,000 22-23 (Budget) 22-23 (YTD) $ $ 28,947 $100,000 $150,000 $200,000 22,126 Discussion: In fiscal year 2018-19 Solid Waste spent $4.5 million on North Gateway material recovery facility upgrade and $1.5 million on State Route 85 Landfill. Solid Waste In fiscal year 2019-20 Solid Waste spent $3 million in transfer stations, $1 million at State Route 85, and $1 million for Skunk Creek as monitoring and maintenance. 22-23 (YTD) In fiscal year 2020-21 Solid Waste spent $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 (Budget) 21-22 In fiscal year 2021-22 Solid Waste spent $24 million on replacing and upgrading aging equipment at 27th Ave and North Gateway Transfer Stations Material Recovery Facilities. 20-21 Major projects budgeted for fiscal year 2022-23 include $8.4 million at State Route 85 for excavating and lining along with methane gas extraction systems, $4.6 million at transfer stations, and $3.9 million to purchase replacement vehicles. Additionally, the City budgets $2.5 million in contingency funding for unexpected expenditures. 19-20 18-19 $0 $15,000 $30,000 $45,000 8 Capital Expenditures (In Thousands of Dollars) Refer to detailed financial schedules pages 19 thru 29 18-19 Wastewater $ 97,890 19-20 20-21 21-22 $ 123,141 $ 77,339 $182,710 22-23 (Budget) 22-23 (YTD) $ $ 507,203 104,880 Discussion: In fiscal year 2018-19, Wastewater spent $45.2 million in sewer main replacement and construction and $32.5 million on improvements and maintenance at the wastewater treatment plants. Wastewater 22-23 (YTD) In fiscal year 2019-20 Wastewater spent $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. In fiscal year 2020-21 Wastewater spent $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 (Budget) 21-22 20-21 In fiscal year 2021-22 Wastewater spent $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. 19-20 18-19 $0 $200,000 $400,000 $600,000 Major projects budgeted in fiscal year 2022-23 include $26 million for Dixileta Dobbins North Gravity Sewer, $20 million on growth-related wastewater infrastructure in Desert View area, $18 million to replace and rehabilitate equipment used in solids thickening, $18 million to rehabilitate Plant 2 equipment at 91st Ave, $14 million to rehabilitate small sewers citywide, $13 million for rehabilitate or replacing PVC-lined concrete sanitary interceptors, $11 million 23rd Ave Grit Basin Replacement, and $10 million to rehabilitate or replace large diameter sewers. In addition, budget has $165 million for contingencies and $186 million in wastewater projects under $10 million. 18-19 Water System $ 289,858 19-20 20-21 21-22 $ 252,146 $ 434,000 $205,485 22-23 (Budget) 22-23 (YTD) $ $ 389,929 98,727 Discussion: In fiscal year 2018-19 water spent $111.1 million on main replacement and construction, $49.9 million on boosters, $35.2 million on groundwater well program, $24.4 million on production, and $23.6 million on 24th Street water treatment plant rehabilitation. Water System 22-23 (YTD) In fiscal year 2019-20 water spent $84.3 million on water main replacement and construction, $55.9 million on Water Treatment Plants, and $38.9 million on wells. 22-23 (Budget) In fiscal year 2020-21 water spent $153 million on water main from 24th Street treatment plant to 32nd St and Bell Road, $110.0 million on water boosters, and $19.9 million on transmission main rehabilitation. 21-22 20-21 In fiscal year 2021-22 largest water projects include $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. 19-20 18-19 $0 $200,000 $400,000 $600,000 Major projects budgeted in fiscal year 2022-23 include $51 million for the Southern/Northern Water Growth Projects for growth-related water infrastructure, $26 million for water engineering and construction labor, $25 million on Booster Pump Stations, $22 million at DVWTP to relocate existing chemical storage and related chemical feed pumping systems to upgrade and replace aging facilities, $22 million on underground Aquifer Water Storage, $11 million for 24th Street WTP rehabilitation, $11 million Remote Facilities Rehab and Replacement, and $10 million to Acquire Additional Water Resources. 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 May YTD Revenues $1,200,000 $800,000 Annual Revenues* $400,000 $0 18-19 Fiscal Year 18-19 19-20 20-21 21-22 22-23 May YTD Revenues 1,100,526 1,154,049 1,361,828 1,379,664 1,554,914 19-20 20-21 21-22 22-23 Annual % of Annual Revenues* Revenues 1,220,768 90.2% 1,307,357 88.3% 1,491,537 91.3% 1,508,526 91.5% 1,589,483 97.8% * For prior years - total actual revenues, for current year - total approved budget Year to Date Performance Status Better than Expected Fiscal year 2022-23 general fund operating revenues are budgeted to increase 5.4% over prior year actuals. Actual revenues through May are 12.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 270,000 240,000 119,973 115,069 124,847 107,555 101,652 210,000 114,424 180,000 150,000 Secondary 120,000 90,000 162,129 170,209 18-19 19-20 182,043 192,215 20-21 21-22 181,729 Primary 199,194 60,000 30,000 - Fiscal Year 18-19 19-20 20-21 21-22 22-23 YTD 22-23 Budget Total 263,781 277,764 297,112 312,188 296,153 324,043 July (1,049) (1,141) (1,619) (1,490) (1,541) (1,553) Aug 688 1,081 1,541 1,141 1,275 1,375 Sept 980 647 1,288 1,040 1,357 1,087 Oct 12,601 11,579 21,550 24,048 29,752 20,887 Nov 91,331 106,458 89,520 101,285 98,119 108,589 Dec 30,444 23,612 38,512 33,534 39,943 34,943 Jan 13,302 14,875 15,608 18,086 16,279 17,742 22-23 YTD Feb 5,422 7,447 6,612 6,889 7,687 7,652 Mar 8,130 8,185 9,456 8,972 10,370 9,722 Apr 12,026 12,116 15,171 15,063 15,618 15,470 22-23 Budget May 68,870 66,043 76,862 71,096 77,294 78,174 June 21,036 26,862 22,611 32,524 29,953 Note: Monthly budget amount for 22-23 is the average % of last 3 years of the total budget 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.8% in fiscal year 2022-23 over fiscal year 2021-22 actuals. 11 Primary Secondary 162,129 101,652 170,209 107,555 182,043 115,069 192,215 119,973 181,729 114,424 199,194 124,847 Local Sales Tax Revenue (In Thousands of Dollars) Refer to detailed financial schedules on pages 19 thru 29 Local Sales Tax Budget vs Actual 100,000 90,000 80,000 70,000 60,000 50,000 22-23 Actuals 40,000 22-23 Budget 30,000 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Better than Expected Local Sales Tax for fiscal year 2022-23 are budgeted to decrease 4.2% over fiscal year 2021-22 actual results. Year-to-date through May are 14.0% higher than budget expectations. City of Phoenix revenue is budgeted on an annual basis. Fiscal year 2022-23 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2018-19 through fiscal year 2021-22 actual expenditures. Local Sales Tax 3 Year Trend 100,000 90,000 80,000 70,000 60,000 20-21 Actuals 50,000 21-22 Actuals 40,000 22-23 Actuals 30,000 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Through May fiscal year 2022-23 Local Sales Tax revenues increased 7.2% than the same period in prior year. For the entire fiscal year 2021-22 Local Sales Tax for the full year increased 17.8% over fiscal year 2020-21. Fiscal year 2020-21 increased 12.2% over 2019-20 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 30,000 25,000 20,000 22-23 Actuals 15,000 22-23 Budget 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Better than Expected State Sales Tax for fiscal year 2022-23 are budgeted to decrease 1.2% over fiscal year 2021-22 actual results. Year-to-date through May are 5.4% higher than budget expectations. Fiscal year 2022-23 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2018-19 through fiscal year 2021-22 actual expenditures. State Sales Tax 3 Year Trend 30,000 25,000 20,000 20-21 Actuals 15,000 21-22 Actuals 22-23 Actuals 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Through May fiscal year 2022-23 State Sales Tax revenues are higher 6.2% than the same period in prior year. For the entire fiscal year 2021-22 State Sales Tax for the full year increased 14.2% over fiscal year 2020-21. Fiscal year 2020-21 increased 17.1% over 2019-20 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 12,000 10,000 8,000 22-23 Actuals 6,000 22-23 Budget 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Monitor and Consider Taking Action Vehicle License Tax for fiscal year 2022-23 are budgeted to increase 5.6% over fiscal year 2021-22 actual results. Year-to-date through May are 3.8% lower than budget expectations. Fiscal year 2022-23 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2018-19 through fiscal year 2021-22 actual expenditures. Vehicle License Tax 3 Year Trend 12,000 10,000 20-21 Actuals 8,000 21-22 Actuals 6,000 22-23 Actuals 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Through May fiscal year 2022-23 Vehicle License Tax revenues increased 2.5% than the same period in prior year. For the entire fiscal year 2021-22 Vehicle License Tax for the full year decreased 1.3% over fiscal year 2020-21. Fiscal year 2020-21 increased 13.2% over 2019-20 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 22-23 Budget 400,000 300,000 2022-23 Actuals 200,000 100,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Monitor and Consider Taking Action 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 2022-23 are budgeted to increase 9.5% over fiscal year 2021-22 actual results. Year-to-date through May are 3.3% lower than budget expectations. Fiscal year 2022-23 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2018-19 through fiscal year 2021-22 actual expenditures. Governmental Funds Revenues 3 Year Trend 600,000 500,000 400,000 2020-21 Actuals 300,000 2021-22 Actuals 200,000 2022-23 Actuals 100,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Through May fiscal year 2022-23 Governmental Funds revenues increased 9.2% than the same period in prior year. For the entire fiscal year 2021-22 Governmental Funds for the full year increased 8.1% over fiscal year 2020-21. Fiscal year 2020-21 increased 14.4% over 2019-20 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 100,000 80,000 22-23 Actuals 60,000 22-23 Budget 40,000 20,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Better than Expected Aviation operating revenues for fiscal year 2022-23 are budgeted to decrease 11.4% over fiscal year 2021-22 actual results. Year-to-date through May are 9.5% higher than budget expectations. Fiscal year 2022-23 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2018-19 through fiscal year 2021-22 actual expenditures. Aviation Operating Revenues 3 Year Trend 180,000 150,000 120,000 20-21 Actuals 90,000 21-22 Actuals 22-23 Actuals 60,000 30,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Through May fiscal year 2022-23 Aviation revenues increased 10.5% than the same period in prior year. For the entire fiscal year 2021-22 Aviation revenue for the full year increased 46.6% over fiscal year 2020-21. Fiscal year 2020-21 increased 8.0% over 2019-20 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 70,000 60,000 50,000 40,000 22-23 Actuals 30,000 22-23 Budget 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Monitor and Consider Taking Action Water System Operating revenues for fiscal year 2022-23 are budgeted to increase 6.7% over fiscal year 2021-22 actual results. Year-to-date through May are 5.8% lower than budget expectations. Fiscal year 2022-23 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2018-19 through fiscal year 2021-22 actual expenditures. Water System Operating Revenues 3 Year Trend 70,000 60,000 50,000 40,000 20-21 Actuals 30,000 21-22 Actuals 20,000 22-23 Actuals 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Through May fiscal year 2022-23 Water System Operating revenues increased 1.0% than the same period in prior year. For the entire fiscal year 2021-22 Water System Operating revenue for the full year increased 0.0% over fiscal year 2020-21. Fiscal year 2020-21 increased 8.4% over 2019-20 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 30,000 25,000 20,000 22-23 Budget 15,000 22-23 Actuals 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Monitor and Consider Taking Action Wastewater Operating revenues for fiscal year 2022-23 are budgeted to increase 0.8% over fiscal year 2021-22 actual results. Year-to-date through May are 1.5% lower than budget expectations. Fiscal year 2022-23 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2018-19 through fiscal year 2021-22 actual expenditures. Wastewater Operating Revenues 3 Year Trend 30,000 25,000 20,000 20-21 Actuals 15,000 21-22 Actuals 10,000 22-23 Actuals 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Through May fiscal year 2022-23 Wastewater Operating revenues decreased 1.0% than the same period in prior year. For the entire fiscal year 2021-22 Wastewater revenue for the full year increased 4.8% over fiscal year 2020-21. Fiscal year 2020-21 increased 0.8% over 2019-20 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 MAY 31 (dollars in thousands) Budget Estimate 2022-2023 Actual Year-to-Date 2022-2023 2021-2022 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 $ $ 631,431 3,006 640,690 $ 2,877 597,875 3,067 227,155 310,387 83,100 199,194 2,872 9,000 225,708 282,501 76,003 181,729 2,446 5,919 212,486 195,620 74,180 171,951 2,732 6,682 8,184 920 14,154 399 5,722 1,828 6,818 7,353 798 13,680 380 5,797 1,540 8,629 7,449 816 13,628 388 4,801 1,785 7,293 44,313 1,500 17,518 5,550 16,432 43,239 1,277 17,172 17,042 20,134 43,470 1,149 16,886 3,251 14,153 1,589,483 19 $ $ 1,554,914 $ 1,379,662 General Fund Expenditures As of MAY 31 (dollars in thousands) Budget Estimate 2022-2023 Actual Year-to-Date 2022-2023 2021-2022 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,097 $ 4,626 6,288 62,034 3,396 2,227 25,169 3,177 5,476 23,187 3,796 21,294 943 163,710 1,936 3,954 5,118 54,155 2,973 2,514 22,088 2,553 4,131 18,215 3,525 18,617 3,555 143,335 37,568 5,822 43,390 32,320 4,745 37,065 29,307 7,090 36,397 Public Safety Police Fire Others Total Public Safety 659,530 429,045 1,088,575 612,827 377,154 989,981 533,606 337,313 (193) 870,725 Transportation Street Transportation Public Transit Total Transportation 24,194 1,891 26,085 21,506 1,890 23,396 20,146 1,642 21,788 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 9,599 18,478 6,608 2,063 36,748 6,637 15,216 3,913 1,987 27,753 7,075 13,106 4,004 1,527 25,711 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 116,611 45,841 26,042 8,964 197,458 97,520 40,846 21,002 7,807 167,175 90,872 38,153 18,812 6,433 154,270 Environmental Services Public Works Environmental Programs Others Total Environmental Services 27,275 1,561 698 29,534 20,136 1,069 605 21,810 22,681 854 401 23,936 Capital Improvement 48,815 23,642 17,426 Vacancy Savings (20,000) - - Contingencies 120,788 - - Criminal Justice Municipal Court Public Defender Total Criminal Justice Total Expenditures and Encumbrances $ 20 2,507 6,384 8,758 81,198 3,409 3,011 29,766 3,323 8,630 29,253 4,806 25,546 1,446 208,038 1,779,432 $ $ 1,454,532 $ 1,293,588 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 MAY 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 2022-2023 $ 631,431 3,006 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 $ 640,690 $ 2,877 597,875 3,067 227,155 310,387 83,100 199,194 2,872 9,000 9,104 14,154 399 5,722 1,828 6,818 63,331 5,550 16,432 225,708 282,501 76,003 181,729 2,446 5,919 8,151 13,680 380 5,797 1,540 8,629 61,689 17,042 20,134 212,486 195,620 74,180 171,951 2,732 6,682 8,266 13,628 388 4,801 1,785 7,293 61,505 3,251 14,153 1,589,484 1,554,914 1,379,663 48,135 121,626 48,790 9,562 364,611 4,533 81,725 6,299 28,455 154,999 45,672 6,045 48,379 771,327 128,978 48,027 120,557 51,706 10,474 361,933 814 94,545 6,055 31,690 139,836 37,898 5,005 26,554 248,553 119,088 44,475 111,563 44,585 9,532 323,123 3,724 91,678 6,012 27,456 141,784 5,752 5,001 15,055 299,094 109,476 1,869,135 1,302,736 1,238,311 508,516 91,686 525,269 268,890 196,668 461,556 106,557 444,971 246,447 186,507 417,780 87,800 440,454 248,885 184,371 1,591,028 1,446,038 1,379,289 5,049,647 21 Actual Year-to-Date 2022-2023 2021-2022 $ $ 4,303,688 $ 3,997,263 Citywide Operating Expenditures As of MAY 31 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2022-2023 2021-2022 Budget 2022-2023 163,710 $ 51,497 215,207 143,335 14,501 157,836 43,390 8,059 51,449 37,065 6,337 43,402 36,397 6,434 42,831 Public Safety General Funds Other Funds Total Public Safety 1,088,575 259,954 1,348,529 989,981 248,498 1,238,479 870,725 215,870 1,086,595 Transportation General Funds Other Funds Total Transportation 26,085 805,502 831,587 23,396 729,977 753,373 21,788 728,822 750,610 Community Development General Funds Other Funds Total Community Development 36,748 269,826 306,574 27,753 213,939 241,692 25,711 175,993 201,704 Community Enrichment General Funds Other Funds Total Community Enrichment 197,458 281,554 479,012 167,175 263,492 430,667 154,270 226,652 380,922 Environmental Services General Funds Other Funds Total Environmental Services 29,534 823,663 853,197 21,810 738,443 760,253 23,936 668,657 692,593 Debt Service General Funds Other Funds Total Debt Service 198,070 198,070 196,950 196,950 120,468 120,468 48,815 1,340,409 1,389,224 23,642 376,689 400,331 17,426 456,469 473,895 American Rescue Plan Act General Funds Other Funds Total American Rescue Plan Act 108,448 108,448 - 76,745 76,745 Vacancy Savings General Funds Other Funds Total Vacancy Savings (20,000) (20,000) - - Contingencies General Funds Other Funds Total Contingencies 120,788 65,500 186,288 - - 1,779,431 4,198,410 5,977,841 1,454,532 2,825,822 4,280,353 $ $ 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 $ 208,038 37,425 245,463 22 $ $ 1,293,588 2,690,611 3,984,199 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 MAY 31 2023 2022 Budget Estimate 2022-2023 Source Actual Year-to-Date 2022-2023 2021-2022 General Funds $ 72,938,179 126,450 Local Taxes: Sales Taxes Privilege License Fees 85,884,993 73,064,629 Total Local Taxes 634,436,999 643,566,925 600,942,190 15,244,490 25,681,939 7,240,886 15,951,809 17,673,907 6,061,478 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 227,155,000 310,387,000 83,100,000 225,708,303 282,501,332 76,003,152 212,485,821 195,620,028 74,179,986 48,167,315 39,687,194 620,642,000 584,212,787 482,285,835 47,040,666 43,398,768 Primary Property Tax 199,194,000 181,728,557 171,951,408 (1) (190,903) Licenses and Permits 2,872,000 2,445,807 2,732,432 2,005,753 2,271,049 Cable Communications 9,000,000 5,919,285 6,682,382 697,163 82,073 757,182 80,261 Municipal Court: Fines and Forfeitures Court Default Fee 8,184,192 920,000 7,353,082 797,690 7,449,398 816,300 779,236 837,443 9,104,192 8,150,772 8,265,698 2,179,453 1,347,111 14,154,183 13,680,048 13,627,601 20,655 26,199 Library Fees 399,106 380,332 388,245 614,044 462,472 Parks and Recreation 5,722,212 5,796,792 4,800,978 176,309 135,194 Planning and Development 1,828,100 1,539,604 1,784,722 410,613 506,927 Street Transportation 6,818,100 8,628,691 7,292,905 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other 44,313,000 1,500,000 17,517,798 43,239,488 1,277,425 17,171,696 43,469,952 1,149,200 16,885,664 61,504,816 85,884,624 369 $ $ Total State Shared Taxes Total Municipal Court Police 631,430,699 3,006,300 $ 640,690,292 2,876,633 $ 597,875,030 3,067,160 4,760,611 175,800 2,562,928 4,468,854 96,175 400,896 7,499,339 4,965,925 63,330,798 61,688,609 2,322,828 510,735 Interest 5,550,000 17,041,508 3,250,772 1,262,955 863,266 Other Fees and Service Charges 16,431,605 20,133,572 14,152,667 198,364,158 167,886,009 1,589,483,295 1,554,913,289 1,379,662,651 Total Fire Total General Funds Special Revenue and Debt Service Funds 4,344,569 310,326 1,551,631 60,822 3,780,517 270,037 1,350,185 14,372 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 33,490,615 2,391,688 11,960,435 292,000 33,200,362 2,371,454 11,857,272 598,067 30,600,912 2,185,780 10,928,897 759,617 6,267,348 5,415,111 Total Neighborhood Protection 48,134,738 48,027,155 44,475,206 11,307,429 3,326,571 34,773 12,464,120 4,503,386 11,277 92,559,251 28,948,147 119,000 91,535,770 28,563,099 458,421 84,831,770 26,610,420 120,933 14,668,773 16,978,783 121,626,398 120,557,290 111,563,123 6,560,869 5,476,446 48,789,684 51,706,397 44,584,503 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 MAY 31 2023 2022 $ 842,386 388,397 13,494 48,565 $ Budget Estimate 2022-2023 Source 631,732 299,957 3,310 50,451 Golf Courses: Fees Coffee Shops Concessions Interest Other $ 6,142,000 2,907,000 7,000 505,976 Actual Year-to-Date 2022-2023 2021-2022 $ 6,701,469 3,205,768 96,560 470,525 $ 6,066,261 2,966,697 16,933 482,166 1,292,842 985,450 Total Golf Courses 9,561,976 10,474,322 9,532,057 41,366,605 5,610,333 36,718,270 3,455,228 Transit 2000 & 2050: Sales Taxes Interest/Other 326,454,730 38,156,549 322,424,707 39,508,178 298,366,529 24,756,939 46,976,938 40,173,498 364,611,279 361,932,885 323,123,468 461,207 332,259 Court Awards 4,532,715 814,053 3,723,789 7,461,841 8,881,762 Planning and Development 81,725,100 94,544,718 91,677,530 854,981 538,122 Capital Construction 6,299,234 6,055,230 6,011,877 4,474,612 3,077,082 3,818,734 37,191 Sports Facilities: Sales Taxes Interest/Other 24,576,788 3,877,936 26,636,611 5,053,888 23,580,799 3,875,426 7,551,694 3,855,925 Total Sports Facilities 28,454,724 31,690,499 27,456,225 12,332,390 375,882 6,218 12,782,691 83,135 2,397 Highway User Revenue: Highway User Revenue Interest Other 154,499,000 500,000 - 136,901,482 2,867,347 67,094 140,918,936 527,462 337,731 12,714,490 12,868,223 154,999,000 139,835,923 141,784,129 - - Total Transit 2000 & 2050 Total Highway User Revenue Local Transportation Assistance - - - 3,270,448 381,813 Regional Transit Revenues 45,671,569 37,897,576 5,751,974 1,337,589 1,366,466 Community Reinvestment 6,045,200 5,005,278 5,001,220 (1,322,454) (2,987,141) Other Restricted Fees 48,378,624 26,553,756 15,055,178 183,947 13,455,856 6,582,409 287,928 10,636,265 1,359,787 Grants: Public Housing: Rentals Grants Other 5,540,493 124,466,359 27,004,331 4,062,390 106,905,457 17,453,436 4,910,705 91,815,262 14,922,706 20,222,212 12,283,980 157,011,183 128,421,283 111,648,673 39,485,846 4,258,486 14,777,205 4,627,034 5,530,974 6,047,943 4,609,499 1,741,449 76,011,213 96,561,074 54,728,038 387,015,508 76,172,344 (10,737,044) 24,455,855 30,240,921 61,842,901 77,847,664 10,298,597 37,456,553 63,148,571 17,929,865 Total Other 614,315,833 120,132,076 187,445,715 83,370,783 30,213,845 Total Grants 771,327,016 248,553,359 299,094,388 30,252,988 (304,374) 27,697,453 105 124,847,420 4,130,117 114,423,929 4,664,099 107,713,143 1,762,849 29,948,614 27,697,558 Total G.O. Bond/Secondary Property Tax 128,977,537 119,088,028 109,475,992 221,415,963 152,178,120 Total Special Revenue and Debt Service Funds 1,869,134,794 1,302,736,469 1,238,310,659 Total Public Housing Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond/Secondary Property Tax Secondary Property Tax Interest 24 Citywide Operating Revenue by Source For the Month Ended MAY 31 2023 2022 Budget Estimate 2022-2023 Source Actual Year-to-Date 2022-2023 2021-2022 Enterprise Funds AVIATION: $ 9,356,041 $ 34,761,848 1,318,512 362,925 319,384 354,733 452,819 8,587,772 30,672,251 183,780 6,274,460 260,141 286,764 101,980 46,926,262 46,367,148 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge $ Total Aviation 98,741,306 304,230,075 2,390,000 94,827,511 3,082,175 3,914,572 1,330,000 $ 100,365,563 342,594,395 9,256,395 (954,157) 3,191,073 3,622,833 3,479,999 $ 90,730,208 285,194,351 1,351,174 33,783,208 2,789,206 3,204,952 726,674 508,515,639 461,556,101 417,779,773 73,883,063 17,349,462 453,000 78,349,235 26,133,409 2,073,962 69,100,987 18,438,871 259,909 91,685,525 106,556,606 87,799,767 495,373,898 3,000,000 5,461,000 9,119,120 6,200,000 6,953,000 (838,421) 400,979,705 2,584,863 6,880,949 8,731,928 6,495,660 6,698,911 12,598,985 408,616,758 2,689,485 11,175,507 7,403,014 6,082,980 1,347,118 3,139,458 525,268,597 444,971,001 440,454,320 CONVENTION CENTER: 10,568,489 2,976,510 334,037 10,795,931 2,618,263 47,701 13,879,036 13,461,895 Excise Taxes Operating Revenue Interest Total Convention Center WATER SYSTEM: 37,684,765 261,728 456,236 762,543 426,780 735,290 1,198,738 42,100,344 270,732 420,426 820,498 458,820 185,022 937,606 41,526,080 45,193,448 Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other Total Water System WASTEWATER: 17,304,040 1,855,400 455,010 802,066 3,191,183 17,626,383 1,695,608 427,080 218,136 2,328,227 Sewer Service Charges Multi-City Development Fees Interest Other 216,761,657 17,370,062 7,000,000 3,953,000 23,805,606 188,014,131 20,226,262 6,214,530 6,413,860 25,578,566 193,227,765 20,045,099 5,831,850 1,710,161 28,069,775 23,607,699 22,295,434 Total Wastewater 268,890,325 246,447,349 248,884,650 174,865,017 13,285,000 170,000 8,348,370 163,826,506 12,385,441 1,177,746 9,117,710 158,763,120 12,613,547 239,730 12,754,579 196,668,387 186,507,403 184,370,976 1,591,028,473 1,446,038,460 1,379,289,486 SOLID WASTE: $ 15,136,046 1,313,917 154,174 408,237 14,668,524 1,486,593 38,949 1,459,974 17,012,374 17,654,040 142,951,451 144,971,965 562,731,572 $ 465,036,094 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ 25 5,049,646,562 $ 4,303,688,218 $ 3,997,262,796 Citywide Operating Expenditures by Program For the Month Ended MAY 31 2023 2022 Program Budget Estimate 2022-2023 2022-2023 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2022-2023 2021-2022 General Government $ 202,824 $ 543,416 1,000,920 5,821,893 150,112 572,245 292,155 2,514,763 289,743 217,514 2,199,742 (2,677,185) 16,201 (295,066) 5,564,729 312,525 152,279 379,818 1,355,474 6,720,470 73,330 244,101 270,039 2,479,642 212,533 110,999 1,446,962 234,558 10,669 (214,113) 1,931,914 515,685 16,726,531 15,924,360 $ 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,507,342 6,384,019 9,383,176 93,020,341 1,312,698 3,635,481 3,499,236 31,853,781 3,323,074 8,630,568 29,834,654 641,300 117,915 4,806,301 40,722,038 5,790,783 $ 2,096,933 4,626,055 7,119,330 72,821,534 1,322,233 3,573,334 2,645,199 26,736,770 3,177,297 5,476,199 43,907,435 (131,549) 97,825 3,795,795 32,792,454 5,149,655 $ 1,935,707 3,953,752 5,384,156 56,559,511 1,194,614 2,979,189 2,921,013 23,676,825 2,553,259 4,131,337 18,547,958 2,648,347 90,451 3,524,972 23,987,589 3,747,118 $ 2,096,933 4,626,055 7,119,330 62,770,264 1,322,233 3,573,334 2,645,199 26,736,770 3,177,297 5,476,199 43,374,562 (131,549) 97,825 3,795,795 22,683,108 5,149,655 $ 10,051,270 532,874 10,109,346 - 245,462,707 215,206,501 157,835,797 194,513,011 20,693,490 45,627,473 5,821,708 38,656,371 4,745,132 35,740,245 7,090,462 34,007,621 4,745,132 4,648,751 - 51,449,181 43,401,503 42,830,707 38,752,753 4,648,751 851,356,532 497,172,879 - 794,083,365 444,395,492 - 683,157,181 403,354,756 82,572 792,649,811 443,216,836 - 1,433,553 1,178,656 - 1,348,529,411 1,238,478,857 1,086,594,509 1,235,866,647 2,612,210 Criminal Justice 3,622,089 493,542 3,205,116 441,127 4,115,631 3,646,243 Municipal Court Public Defender Total Criminal Justice Public Safety 69,192,861 37,055,148 - 61,046,267 34,579,192 - 106,248,010 95,625,458 Police Fire Other Total Public Safety Transportation 8,106,377 755,143 35,209,807 4,041,407 6,834,244 687,753 29,524,926 3,600,879 Street Transportation Street Lighting Aviation Public Transit 122,011,150 9,224,160 407,090,969 293,260,282 99,945,634 10,403,412 362,221,763 280,802,341 90,726,439 8,651,229 401,609,962 249,622,479 92,021,294 10,403,412 270,389,357 280,802,341 7,924,341 91,832,406 - 48,112,734 40,647,802 Total Transportation 831,586,561 753,373,151 750,610,109 653,616,403 99,756,747 Community Development 6,861,699 12,088,858 2,649,944 3,036,699 5,973,719 10,031,708 1,540,768 2,345,557 Planning and Development Housing Economic Development Neighborhood Services Department 90,299,394 123,746,419 24,460,571 68,067,495 74,648,964 112,679,394 20,916,171 33,447,480 65,895,963 95,357,655 14,358,917 26,091,871 74,648,964 112,612,801 15,848,623 33,447,480 66,593 5,067,547 - 24,637,201 19,891,752 Total Community Development 306,573,879 241,692,009 201,704,406 236,557,868 5,134,140 137,396,866 49,254,411 69,897,540 13,127,552 195,722,335 6,521,208 7,091,626 113,782,375 42,315,400 63,978,114 12,032,658 187,388,082 5,805,342 5,365,324 105,115,935 39,332,942 57,521,626 11,648,515 158,760,738 4,405,888 4,136,132 113,366,665 42,315,400 47,969,821 187,301,631 5,805,342 5,365,324 415,710 16,008,293 12,032,658 86,451 - 479,011,538 430,667,296 380,921,776 402,124,184 28,543,112 Community Enrichment 10,687,707 3,418,814 3,884,232 1,093,813 18,822,230 250,373 385,776 11,466,617 4,079,770 1,984,285 1,058,890 13,184,561 176,255 417,147 38,542,946 32,367,524 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 MAY 31 2023 2022 Budget Estimate 2022-2023 Program 2022-2023 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2022-2023 2021-2022 Environmental Services $ 30,320,137 $ 14,431,847 15,188,390 2,414,834 446,212 156,956 28,752,216 15,215,780 11,822,588 1,343,028 209,618 99,472 Water System Wastewater Solid Waste Management Public Works Environmental Programs Manager's Office of Sustainability 62,958,376 57,442,701 Total Environmental Services 1,952,923 1,420,565 176,313 638,663 52,010 183,009 27,646 542,998 584,835 20,431 1,502,655 1,053,105 90,619 16 50,000 1,589,303 989,422 2,417 26,786 1,688,293 286,354 60,648 669,902 45,044 236,303 185,375 1,260,440 600,531 54,540 1,677,570 889,668 362,301 90,619 9 78,875 1,732,993 1,003,266 2,129 26,786 10,903,716 10,951,645 70,914,386 $ 415,010,163 201,009,119 179,991,778 51,923,026 4,226,968 1,036,338 $ 384,946,135 182,660,777 155,242,622 32,600,375 4,133,811 669,778 $ 337,675,517 166,517,208 157,725,698 28,546,342 1,467,921 660,079 $ 249,226,089 112,851,697 141,882,730 21,472,267 4,133,811 669,778 $ 135,720,046 69,809,080 13,359,892 11,128,108 - 853,197,392 760,253,499 692,592,764 530,236,372 230,017,127 21,945,294 15,304,933 895,100 8,925,254 631,525 2,283,657 331,750 9,678,083 7,289,216 245,175 19,712,161 59,500,000 13,598,027 1,087,431 1,065,036 600,000 21,545,806 13,080,704 29,750 321,429 50,351,057 15,640,243 1,949,237 8,099,817 767,115 2,710,278 304,104 9,741,129 9,863,432 224,744 27,241,335 15,517,708 996,812 1,772,443 550,000 36,294,979 14,584,493 46,583 294,643 18,571,224 3,149,896 667,127 7,368,927 495,481 2,599,328 2,039,126 13,864,842 6,605,841 599,935 18,453,269 9,786,348 3,985,309 996,812 23 867,625 19,062,923 11,035,925 23,421 294,643 50,351,057 15,640,243 1,949,237 8,099,817 767,115 2,710,278 304,104 9,741,129 9,863,432 224,744 27,241,335 15,517,708 996,812 1,368,401 550,000 36,294,979 14,584,493 46,583 294,643 404,042 - Total Debt Service 198,070,331 196,950,151 120,468,025 196,546,109 404,042 56,964,597 Capital Improvement 1,389,224,070 400,330,761 473,894,568 400,330,761 - - 4,024,271 American Rescue Plan Act 108,447,955 - 76,744,755 - - - - Vacancy Savings (20,000,000) - - - - - - Contingencies 186,288,000 - - - - General Obligation Debt Service $ 383,159,531 $ 337,486,355 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 $ 5,977,841,025 $ 27 4,280,353,728 $ 3,984,197,416 $ 3,888,544,109 $ 391,809,618 Capital Expenditures and Encumbrances 2022-2023 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 2021-2022 Actual Yearto-Date Actual Yearto-Date Budget From Operating Funds Budget Actual 2022-2023 Year-to-Date Capital Amounts From Capital Funds Budget Actual Unencumbered Budget $ 902,484 $ 52,520,876 39,451,342 4,700,000 34,004,918 111,632,198 19,762,972 27,431,826 9,277,780 7,243,820 203,222,601 110,549,388 15,538,000 20,981,646 7,786,203 515,978,602 6,001,000 360,322,489 $ 26,083,194 23,474,537 1,501,024 20,348,081 27,607,362 12,143,313 5,672,648 948,743 1,162,815 81,369,687 33,132,887 2,584,878 12,453,597 1,661,286 45,322,100 113,161,814 1,977,105 11,751,036 7,107,497 4,896,940 8,895,237 12,487,433 995,786 4,787,383 25,756,513 578,235 12,345,107 234,912,201 379,490 130,518,197 $ $ 52,520,876 22,753,919 11,060,496 98,498,679 19,162,972 19,294,651 4,438,780 7,243,820 85,516,464 15,538,000 2,041,204 371,668,102 218,167,204 26,083,194 17,335,235 412,809 16,011,524 12,143,313 5,672,648 948,743 1,162,815 28,940,651 2,584,878 506,551 44,739,946 101,579,472 $ 902,484 $ 16,697,423 4,700,000 22,944,422 13,133,519 600,000 8,137,175 4,839,000 203,222,601 25,032,924 20,981,646 5,744,999 144,310,500 6,001,000 142,155,285 6,139,302 1,501,024 19,935,272 11,595,838 81,369,687 4,192,236 12,453,597 1,154,735 582,154 11,582,342 $ 902,484 26,437,682 15,976,805 3,198,976 13,656,837 84,024,836 7,619,659 21,759,178 8,329,037 6,081,005 121,852,914 77,416,501 12,953,122 8,528,049 6,124,917 470,656,502 6,001,000 247,160,675 $ 1,547,308,145 $ 408,627,964 $ 457,388,159 $ 927,905,167 $ 258,121,779 $ 619,402,978 $ 150,506,186 $ 1,138,680,181 $ $ 567,087,818 169,543,000 28,946,616 507,203,480 389,928,515 1,662,709,429 $ 3,210,017,574 $ $ 38,807,126 111,539,945 22,126,452 104,879,519 98,727,375 376,080,417 $ $ 107,769,940 79,832,235 28,811,768 162,593,843 173,393,634 552,401,421 $ 784,708,381 $ 1,009,789,580 28 $ 188,456,320 10,943,000 18,447,037 86,081,878 157,390,668 461,318,903 22,433,435 3,243,686 13,481,149 30,999,377 72,051,336 $ 142,208,983 $ 1,389,224,070 $ 400,330,761 $ $ $ $ 378,631,498 158,600,000 10,499,579 421,121,602 232,537,847 1,201,390,526 $ 1,820,793,504 $ $ 16,373,691 108,296,259 8,645,303 73,880,142 26,676,039 233,871,434 $ $ 528,280,692 58,003,055 6,820,164 402,323,961 291,201,140 1,286,629,012 $ 384,377,620 $ 2,425,309,193 Bonds Authorized and Sold As of MAY 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 Appendix A Additional historic and trend information for various revenue streams. Local Sales Tax (Dollars in Thousands) Local Sales Tax 90,000 18-19 Actuals 80,000 19-20 Actuals 70,000 20-21 Actuals 60,000 21-22 Actuals 50,000 22-23 Actuals 40,000 22-23 Budget 30,000 20,000 10,000 July Fiscal Year 18-19 19-20 20-21 21-22 22-23 22-23 Budget Aug July 29,246 33,070 41,583 44,048 43,479 42,391 Sept Aug 32,982 36,653 59,937 61,805 67,368 54,835 Oct Sept 32,919 56,465 33,935 41,516 46,739 47,230 Nov Oct 52,159 31,089 45,467 50,734 81,273 51,418 Dec Nov 33,971 40,325 52,188 60,971 35,837 53,712 Jan Dec 53,513 51,643 39,837 53,633 59,276 56,912 Feb Jan 35,343 39,512 42,051 70,197 70,667 53,611 Note: City of Phoenix revenue is budgeted on an annual basis. Fiscal year 2022-23 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2018-19 through fiscal year 2021-22 actual expenditures. A1 Mar Feb 38,579 33,570 32,672 42,535 54,420 42,222 Apr Mar 39,641 61,093 63,749 44,740 52,376 59,949 May Apr 46,770 29,662 40,758 54,758 43,371 49,268 June May 27,146 35,239 40,197 72,938 85,884 50,292 YTD thru May 422,269 448,321 492,374 597,875 640,690 561,840 June 64,281 50,222 67,088 61,286 69,592 State Sales Tax (Dollars in Thousands) State Sales Tax 30,000 18-19 Actuals 25,000 19-20 Actuals 20-21 Actuals 20,000 21-22 Actuals 15,000 22-23 Actuals 22-23 Budget 10,000 5,000 July Fiscal Year 18-19 19-20 20-21 21-22 22-23 22-23 Budget Aug July 18,836 20,116 22,912 26,539 28,422 26,141 Sept Aug 13,749 14,944 14,482 18,124 15,064 18,126 Oct Sept 12,476 11,479 13,123 16,285 22,937 15,780 Nov Oct 10,922 14,226 18,038 18,259 18,918 18,170 Dec Nov 15,747 16,443 13,095 15,097 17,357 17,855 Jan Dec 14,902 12,120 19,640 23,860 22,501 20,854 Feb Jan 12,154 17,440 19,033 22,364 20,469 20,992 Note: City of Phoenix revenue is budgeted on an annual basis. Fiscal year 2022-23 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2018-19 through fiscal year 2021-22 actual expenditures. A2 Mar Apr May June Feb 15,369 17,707 10,831 12,163 19,205 16,580 Mar 13,689 12,285 15,878 18,738 22,501 17,917 Apr 14,284 18,557 23,414 25,105 23,090 24,058 May 14,640 11,288 17,998 15,952 15,244 17,706 YTD thru May 156,768 166,605 188,444 212,486 225,708 214,179 June 8,298 5,321 12,848 17,415 12,976 Vehicle License Tax (Dollars in Thousands) Vehicle License Tax 12,000 18-19 Actuals 11,000 19-20 Actuals 10,000 9,000 20-21 Actuals 8,000 21-22 Actuals 7,000 22-23 Actuals 6,000 22-23 Budget 5,000 4,000 3,000 2,000 July Fiscal Year 18-19 19-20 20-21 21-22 22-23 22-23 Budget Aug July 9,422 10,791 10,098 10,453 10,826 11,323 Sept Oct Nov Dec Jan Feb Mar Apr May June Aug 5,782 5,619 7,692 5,328 5,739 6,784 Sept 5,349 5,207 6,207 6,363 6,274 6,424 Oct 6,492 6,146 7,328 6,970 6,676 7,482 Nov 4,886 5,408 4,608 4,862 5,183 5,490 Dec 5,800 5,891 6,529 6,537 6,555 6,877 Jan 6,143 6,514 7,328 7,285 6,684 7,575 Feb 5,490 6,528 5,568 5,828 6,276 6,504 Mar 5,943 5,960 6,411 6,418 7,297 6,870 Apr 5,668 5,110 7,162 8,075 7,252 7,226 May 5,959 4,699 6,472 6,061 7,241 6,442 Note: City of Phoenix revenue is budgeted on an annual basis. Fiscal year 2022-23 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2018-19 through fiscal year 2021-22 actual expenditures. A3 YTD thru May 66,934 67,873 75,403 74,180 76,003 78,997 June 3,276 2,611 4,365 4,515 4,102 Governmental Funds Revenue (Dollars in Thousands) Governmental Funds Revenue 600,000 2018-19 Actuals 2019-20 Actuals 500,000 2020-21 Actuals 400,000 2021-22 Actuals 2022-23 Actuals 300,000 22-23 Budget 200,000 100,000 July Fiscal Year 18-19 19-20 20-21 21-22 22-23 22-23 Budget Aug July 131,124 100,481 68,761 123,174 79,979 127,517 Sept Aug 168,019 187,393 217,048 225,569 274,628 247,347 Oct Nov Dec Jan Feb Mar Apr May June Sept 152,605 194,506 260,275 185,901 211,185 247,626 Oct 198,474 175,883 215,731 231,638 288,507 257,060 Nov 247,632 269,127 298,362 324,875 300,162 354,869 Dec 221,971 226,582 236,818 253,979 275,549 293,929 Jan 170,844 209,806 216,626 267,406 263,160 270,465 Feb 173,462 187,061 178,738 199,258 246,172 232,309 Mar 187,169 217,521 272,444 230,537 255,008 284,334 Apr 210,659 180,484 316,241 255,574 243,521 304,518 May 245,256 226,625 277,929 320,064 419,779 335,291 Note: City of Phoenix revenue is budgeted on an annual basis. Fiscal year 2022-23 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2018-19 through fiscal year 2021-22 actual expenditures. A4 YTD thru May 2,107,215 2,175,469 2,558,973 2,617,975 2,857,650 2,955,264 June 280,540 378,887 362,173 540,197 503,355 Aviation Revenues (Dollars in Thousands) Aviation Operating Revenues 160,000 18-19 Actuals 19-20 Actuals 20-21 Actuals 120,000 21-22 Actuals 22-23 Actuals 80,000 22-23 Budget 40,000 July Fiscal Year 18-19 19-20 20-21 21-22 22-23 22-23 Budget Aug July 31,468 30,489 25,387 36,735 12,023 36,632 Sept Aug 32,105 32,307 2,666 33,945 37,402 29,825 Oct Sept 31,728 32,953 27,193 28,302 34,042 35,480 Nov Oct 31,719 32,056 21,045 31,904 41,419 34,461 Dec Jan Feb Mar Apr May June Nov 32,312 33,532 23,880 36,031 66,192 37,127 Dec 30,496 36,787 31,636 35,025 25,237 39,545 Jan 31,205 34,297 18,059 57,391 46,228 41,614 Feb 32,944 34,215 61,877 33,583 57,291 48,011 Mar 33,075 34,228 25,487 38,417 45,866 38,737 Apr 37,847 27,255 31,454 40,080 48,930 40,340 May 34,396 23,524 30,668 46,367 46,926 39,843 Note: City of Phoenix revenue is budgeted on an annual basis. Fiscal year 2022-23 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2018-19 through fiscal year 2021-22 actual expenditures. A5 YTD thru May 359,295 351,643 299,352 417,780 461,556 421,615 June 35,938 10,702 91,844 155,860 86,900 Water System Revenues (Dollars in Thousands) Water System Operating Revenues 70,000 18-19 Actuals 60,000 19-20 Actuals 20-21 Actuals 50,000 21-22 Actuals 40,000 22-23 Actuals 22-23 Budget 30,000 20,000 10,000 July Fiscal Year 18-19 19-20 20-21 21-22 22-23 22-23 Budget Aug Sept Oct Nov Dec Jan Feb Mar Apr May June July 49,797 52,660 57,819 58,256 60,867 62,338 Aug 46,762 51,596 53,509 42,379 49,237 55,411 Sept 44,112 47,319 52,454 47,181 53,259 54,503 Oct 35,672 40,300 47,335 39,257 44,825 46,373 Nov 31,619 38,339 42,280 41,784 40,352 43,936 Dec 25,048 26,405 33,139 37,523 33,550 34,834 Jan 22,565 25,330 28,579 28,902 28,416 30,059 Feb 21,558 25,643 25,188 28,035 26,868 28,647 Mar 20,138 24,861 28,415 31,242 30,349 29,854 Apr 31,150 29,080 37,714 40,702 35,722 39,550 May 36,293 40,442 42,556 45,193 41,526 46,921 Note: City of Phoenix revenue is budgeted on an annual basis. Fiscal year 2022-23 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2018-19 through fiscal year 2021-22 actual expenditures. A6 YTD thru May 364,714 401,975 448,988 440,454 444,971 472,426 June 38,106 52,141 43,174 51,821 52,842 Wastewater Revenues (Dollars in Thousands) Wastewater Operating Revenues 32,000 18-19 Actuals 19-20 Actuals 27,000 20-21 Actuals 22,000 21-22 Actuals 22-23 Actuals 17,000 22-23 Budget 12,000 7,000 2,000 July Fiscal Year 18-19 19-20 20-21 21-22 22-23 22-23 Budget Aug July 17,949 18,374 21,205 22,011 18,108 21,024 Sept Aug 20,417 24,593 22,791 21,971 22,936 23,728 Oct Sept 21,145 21,373 21,844 26,947 19,029 24,135 Nov Oct 23,028 20,975 22,234 18,312 22,401 22,348 Dec Nov 19,734 21,142 18,577 21,720 25,044 21,456 Jan Feb Mar Apr May June Dec 20,469 20,888 24,461 24,380 19,691 23,841 Jan 22,113 22,063 18,430 22,218 26,128 22,421 Feb 19,436 20,973 24,355 21,916 25,503 22,911 Mar 19,960 21,613 21,754 23,023 22,405 22,824 Apr 21,256 18,428 21,584 24,091 21,595 22,562 May 20,980 23,948 20,085 22,296 23,607 23,077 Note: City of Phoenix revenue is budgeted on an annual basis. Fiscal year 2022-23 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of fiscal year 2018-19 through fiscal year 2021-22 actual expenditures. A7 YTD thru May 226,487 234,370 237,320 248,885 246,447 250,327 June 16,544 18,289 17,424 17,973 18,563