June 2023 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division June 30, 2023 To the Mayor and City Council: This is the City's Financial Report for June, the twelfth 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 24, 2023 INDEPENDENT AUDITOR REPORT To the Chief Financial Officer, We have assessed the Finance Department’s (Finance) June 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 June 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 Expected Transportation 2 Better than Expected Community Development 2 Better than Expected Community Enrichment 3 Better than Expected Environmental Services 3 Better than Expected Citywide Total Operating Expenditures 4 Better than Expected General Government 4 Expected Criminal Justice 4 Better than Expected Public Safety 5 Better than Expected Transportation 5 Better than Expected Community Development 5 Better than Expected Community Enrichment 6 Better than Expected Environmental Services 6 Better than Expected General Obligation Debt Service 6 Better than Expected Citywide Expenditures 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 Better than Expected 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 June YTD Expenditures 1,214,362 1,282,831 1,371,152 1,470,251 1,623,808 Annual Expenditures * 1,214,362 1,282,831 1,371,152 1,470,251 1,678,993 Total General Fund % of Annual Expenditures 100.0% 100.0% 100.0% 100.0% 96.7% * For prior years-total actual expenditures, for current year-total approved budget net of adjustment for contingencies. $2,000,000 June 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 June are 10.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 June YTD Expenditures 114,393 123,100 154,211 161,907 190,945 General Government Annual % of Annual Expenditures * Expenditures 100.0% 114,393 100.0% 123,100 100.0% 154,211 100.0% 161,907 91.6% 208,388 * For prior years-total actual expenditures, for current year-total approved budget $250,000 June 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.7% higher than the fiscal year 2021-22 actuals. Fiscal year 2022-23 actual general fund expenditures through June are 17.9% 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 June YTD Expenditures 33,387 35,033 36,162 40,008 42,361 Annual Expenditures * 33,387 35,033 36,162 40,008 43,390 % of Annual Expenditures 100.0% 100.0% 100.0% 100.0% 97.6% * For prior years-total actual expenditures, for current year-total approved budget $50,000 June 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 June are 5.9% 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 June YTD Expenditures 841,467 893,403 925,920 992,648 1,082,562 Annual Expenditures * 841,467 893,403 925,920 992,648 1,088,575 % of Annual Expenditures 100.0% 100.0% 100.0% 100.0% 99.4% * For prior years-total actual expenditures, for current year-total approved budget $1,200,000 June YTD Expenditures $900,000 $600,000 Annual Expenditures * $300,000 $0 18-19 Expected 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 June are 9.1% 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 June YTD Expenditures 18,337 19,748 22,144 23,166 24,827 Annual Expenditures * 18,337 19,748 22,144 23,166 26,085 % of Annual Expenditures 100.0% 100.0% 100.0% 100.0% 95.2% * For prior years-total actual expenditures, for current year-total approved budget $30,000 $25,000 June 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 June are 7.2% 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 June YTD Expenditures 21,238 22,542 24,114 28,225 32,420 Community Development Annual Expenditures * 21,238 22,542 24,114 28,225 36,748 % of Annual Expenditures 100.0% 100.0% 100.0% 100.0% 88.2% * For prior years-total actual expenditures, for current year-total approved budget $40,000 June 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 June are 14.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 June YTD Expenditures 156,552 155,417 158,589 173,631 190,780 Community Enrichment Annual Expenditures * 156,552 155,417 158,589 173,631 197,458 % of Annual Expenditures 100.0% 100.0% 100.0% 100.0% 96.6% $250,000 June 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 June are 9.9% 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 June YTD Expenditures 16,886 19,180 20,905 26,508 28,329 Environmental Services Annual Expenditures * 16,886 19,180 20,905 26,508 29,534 % of Annual Expenditures 100.0% 100.0% 100.0% 100.0% 95.9% * For prior years-total actual expenditures, for current year-total approved budget $30,000 June 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 June are 6.9% higher 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 June YTD Expenditures 3,775,464 3,814,963 4,163,122 4,488,949 4,737,609 Total Citywide Annual Expenditures * 3,775,464 3,814,963 4,163,122 4,488,949 5,811,553 % of Annual Expenditures 100.0% 100.0% 100.0% 100.0% 81.5% * 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 June 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 June are 5.5% higher than the same period in the prior fiscal year. General Government Fiscal Year 18-19 19-20 20-21 21-22 22-23 General Government June YTD Expenditures 138,349 157,200 207,451 238,925 246,244 Annual Expenditures * 138,349 157,200 207,451 238,925 246,373 % of Annual Expenditures 100.0% 100.0% 100.0% 100.0% 99.9% * For prior years-total actual expenditures, for current year-total approved budget $300,000 $250,000 June YTD Expenditures $200,000 $150,000 $100,000 Annual Expenditures * $50,000 $0 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. Budget for fiscal year 2022-23 anticipates an increase of 3.1% over fiscal year 2021-22 actuals in total operating expenditures. Actual expenditures through June are 3.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. Criminal Justice Fiscal Year 18-19 19-20 20-21 21-22 22-23 Criminal Justice June YTD Expenditures 42,530 44,425 44,147 47,054 49,422 Annual Expenditures * 42,530 44,425 44,147 47,054 51,449 % of Annual Expenditures 100.0% 100.0% 100.0% 100.0% 96.1% * For prior years-total actual expenditures, for current year-total approved budget $60,000 June 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 June are 5.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. 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 June YTD Expenditures 1,025,513 1,110,457 1,122,901 1,228,901 1,354,421 Annual Expenditures * 1,025,513 1,110,457 1,122,901 1,228,901 1,382,649 % of Annual Expenditures 100.0% 100.0% 100.0% 100.0% 98.0% $1,600,000 June 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 Better than Expected 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 12.5% over fiscal year 2021-22 actuals in total operating expenditures. Actual expenditures through June are 10.2% 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 June YTD Expenditures 722,667 774,492 786,597 797,084 792,941 Annual Expenditures * 722,667 774,492 786,597 797,084 835,037 % of Annual Expenditures 100.0% 100.0% 100.0% 100.0% 95.0% $1,000,000 June 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.8% over fiscal year 2021-22 actuals in total operating expenditures. Actual expenditures through June are 0.5% lower 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 June YTD Expenditures 195,716 229,793 245,310 227,960 270,479 Community Development Annual Expenditures * 195,716 229,793 245,310 227,960 306,614 % of Annual Expenditures 100.0% 100.0% 100.0% 100.0% 88.2% $400,000 June 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 June are 18.7% 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 June YTD Expenditures 317,465 316,680 390,805 420,501 450,218 Community Enrichment Annual Expenditures * 317,465 316,680 390,805 420,501 502,642 % of Annual Expenditures 100.0% 100.0% 100.0% 100.0% 89.6% $600,000 June 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 Better than 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 19.5% over fiscal year 2021-22 actuals in total operating expenditures. Actual expenditures through June are 7.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 June YTD Expenditures 670,219 692,524 734,733 752,386 830,101 Environmental Services Annual Expenditures * 670,219 692,524 734,733 752,386 873,197 % of Annual Expenditures 100.0% 100.0% 100.0% 100.0% 95.1% $1,000,000 June 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 16.1% over fiscal year 2021-22 actuals in total operating expenditures. Actual expenditures through June are 10.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. Citywide Debt Service Expenditures Fiscal Year 18-19 19-20 20-21 21-22 22-23 June YTD Expenditures 116,634 130,839 131,938 131,081 207,854 Annual Expenditures * 116,634 130,839 131,938 131,081 210,920 General Obligation Debt Service % of Annual Expenditures 100.0% 100.0% 100.0% 100.0% 98.5% $240,000 June 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 Better than Expected General obligation debt service expenditures budget for fiscal year 2022-23 has an increase of 60.9% over fiscal year 2021-22 actuals in total operating expenditures. Actual debt service expenditures through June 2023 are 58.6% 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 494,744 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 134,479 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 112,717 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,723 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 147,620 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 152,431 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 June 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 June YTD Revenues 1,220,768 1,307,357 1,491,537 1,508,526 1,695,886 19-20 20-21 21-22 22-23 Annual % of Annual Revenues* Revenues 1,220,768 100.0% 1,307,357 100.0% 1,491,537 100.0% 1,508,526 100.0% 1,589,483 106.7% * 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 June are 12.4% 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 330,000 300,000 126,148 270,000 240,000 210,000 124,847 119,973 115,069 107,555 101,652 180,000 Secondary 150,000 Primary 120,000 90,000 170,209 182,043 192,215 201,050 199,194 162,129 18-19 19-20 20-21 21-22 22-23 YTD 22-23 Budget 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 327,198 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 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 May 68,870 66,043 76,862 71,096 77,294 78,174 June 21,036 26,862 22,611 32,524 31,045 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 201,050 126,148 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 June are 10.4% 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 June fiscal year 2022-23 Local Sales Tax revenues increased 5.7% 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 June are 6.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. 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 June fiscal year 2022-23 State Sales Tax revenues are higher 5.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 June are 3.0% 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 June fiscal year 2022-23 Vehicle License Tax revenues increased 2.4% 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 June are 3.0% 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 June fiscal year 2022-23 Governmental Funds revenues increased 6.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 120,000 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 June are 12.8% 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 June fiscal year 2022-23 Aviation revenues increased 0.0% 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 June are 5.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. 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 June 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 35,000 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 Better than Expected 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 June are 2.3% 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. Wastewater Operating Revenues 3 Year Trend 35,000 30,000 25,000 20-21 Actuals 20,000 21-22 Actuals 15,000 22-23 Actuals 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Through June fiscal year 2022-23 Wastewater Operating revenues increased 3.1% 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 JUNE 30 (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 696,962 $ 3,385 659,161 3,467 227,155 310,387 83,100 199,194 2,872 9,000 241,813 308,183 80,593 201,050 3,018 7,979 229,901 213,294 78,695 192,215 3,022 8,982 8,184 920 14,154 399 5,722 1,828 6,818 7,954 885 13,844 448 6,246 1,690 5,358 8,109 880 13,842 434 5,141 1,904 4,510 44,313 1,500 17,518 5,550 16,432 54,830 1,586 18,442 19,526 22,093 46,487 1,297 17,769 3,902 15,514 1,589,483 19 $ $ 1,695,886 $ 1,508,526 General Fund Expenditures As of JUNE 30 (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,425 $ 5,589 7,363 76,515 3,565 2,544 28,812 3,358 5,616 26,466 4,287 22,877 1,529 190,945 2,200 4,782 6,143 63,048 3,360 2,789 24,642 2,743 4,331 20,630 4,008 21,798 1,431 161,907 37,568 5,822 43,390 36,776 5,585 42,361 32,433 7,575 40,008 Public Safety Police Fire Others Total Public Safety 659,530 429,045 1,088,575 665,384 417,178 1,082,562 610,288 382,352 8 992,648 Transportation Street Transportation Public Transit Total Transportation 24,194 1,891 26,085 23,699 1,128 24,827 22,399 767 23,166 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 9,599 18,478 6,608 2,063 36,748 7,372 18,353 4,631 2,065 32,420 7,680 14,554 4,414 1,578 28,225 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 116,611 45,841 26,042 8,964 197,458 111,733 45,957 24,776 8,314 190,780 103,306 41,683 21,708 6,934 173,631 Environmental Services Public Works Environmental Programs Others Total Environmental Services 27,275 1,561 698 29,534 26,244 1,450 635 28,329 24,930 1,112 465 26,508 Capital Improvement 48,815 31,584 24,158 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,759 3,011 29,766 3,323 8,630 29,253 4,806 25,546 1,446 208,388 1,779,782 $ $ 1,623,808 $ 1,470,251 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 JUNE 30 (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 $ 696,962 $ 3,385 659,161 3,467 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 241,813 308,183 80,593 201,050 3,018 7,979 8,839 13,844 448 6,246 1,690 5,358 74,858 19,526 22,093 229,901 213,294 78,695 192,215 3,022 8,982 8,989 13,842 434 5,141 1,904 4,510 65,553 3,902 15,514 1,589,483 1,695,886 1,508,526 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 54,118 136,887 57,792 11,211 404,665 4,655 90,781 6,935 37,267 156,042 41,169 9,669 51,543 464,765 131,266 49,951 125,018 50,264 10,309 362,607 6,051 87,581 6,351 30,963 156,459 7,058 6,950 31,673 594,474 123,936 1,869,135 1,658,765 1,649,646 508,516 91,686 525,269 268,890 196,668 573,801 123,312 497,414 275,038 203,589 573,640 99,147 492,275 266,858 199,650 1,591,028 1,673,155 1,631,571 5,049,646 21 Actual Year-to-Date 2022-2023 2021-2022 $ $ 5,027,805 $ 4,789,743 Citywide Operating Expenditures As of JUNE 30 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2022-2023 2021-2022 Budget 2022-2023 190,945 $ 55,299 246,244 161,907 77,018 238,925 43,390 8,059 51,449 42,361 7,061 49,422 40,008 7,046 47,054 Public Safety General Funds Other Funds Total Public Safety 1,088,575 294,074 1,382,649 1,082,562 271,859 1,354,421 992,648 236,253 1,228,901 Transportation General Funds Other Funds Total Transportation 26,085 808,952 835,037 24,827 768,114 792,941 23,166 773,918 797,084 Community Development General Funds Other Funds Total Community Development 36,748 269,866 306,614 32,420 238,059 270,479 28,225 199,735 227,960 Community Enrichment General Funds Other Funds Total Community Enrichment 197,458 305,184 502,642 190,780 259,438 450,218 173,631 246,870 420,501 Environmental Services General Funds Other Funds Total Environmental Services 29,534 843,663 873,197 28,329 801,772 830,101 26,508 725,878 752,386 Debt Service General Funds Other Funds Total Debt Service 210,920 210,920 207,854 207,854 131,081 131,081 48,815 1,340,409 1,389,224 31,584 504,347 535,931 24,158 539,477 563,635 American Rescue Plan Act General Funds Other Funds Total American Rescue Plan Act 13,448 13,448 - 81,422 81,422 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,781 4,198,060 5,977,841 1,623,808 3,113,803 4,737,609 $ $ 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,388 37,985 246,373 22 $ $ 1,470,251 3,018,698 4,488,949 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 JUNE 30 2023 2022 Budget Estimate 2022-2023 Source Actual Year-to-Date 2022-2023 2021-2022 General Funds $ 61,285,519 400,104 Local Taxes: Sales Taxes Privilege License Fees 56,780,031 61,685,623 Total Local Taxes 634,436,999 700,346,956 662,627,813 16,104,980 25,681,939 4,590,035 17,414,703 17,673,908 4,514,890 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 227,155,000 310,387,000 83,100,000 241,813,283 308,183,271 80,593,187 229,900,524 213,293,936 78,694,876 46,376,954 39,603,501 620,642,000 630,589,741 521,889,336 19,320,996 20,263,491 Primary Property Tax 199,194,000 201,049,553 192,214,899 572,412 289,480 Licenses and Permits 2,872,000 3,018,219 3,021,912 2,060,000 2,300,000 Cable Communications 9,000,000 7,979,285 8,982,382 600,460 87,515 659,424 63,510 Municipal Court: Fines and Forfeitures Court Default Fee 8,184,192 920,000 7,953,542 885,205 8,108,822 879,810 687,975 722,934 9,104,192 8,838,747 8,988,632 163,862 213,915 Police 14,154,183 13,843,910 13,841,516 67,531 45,500 Library Fees 399,106 447,863 433,745 448,778 340,303 Parks and Recreation 5,722,212 6,245,570 5,141,281 150,405 119,318 Planning and Development 1,828,100 1,690,009 1,904,040 (3,270,593) (2,783,041) Street Transportation 6,818,100 5,358,098 4,509,864 11,590,675 308,275 1,270,723 3,017,243 147,533 883,057 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other 44,313,000 1,500,000 17,517,798 54,830,163 1,585,700 18,442,419 46,487,195 1,296,733 17,768,721 13,169,673 4,047,833 65,552,649 2,484,672 651,262 1,959,313 1,361,718 140,972,009 128,861,837 56,271,654 508,377 $ $ Total State Shared Taxes Total Municipal Court Total Fire 631,430,699 3,006,300 $ 696,961,946 3,385,010 $ 659,160,549 3,467,264 63,330,798 74,858,282 Interest 5,550,000 19,526,180 3,902,034 Other Fees and Service Charges 16,431,605 22,092,885 15,514,385 1,589,483,295 1,695,885,298 1,508,524,488 Total General Funds Special Revenue and Debt Service Funds 4,002,916 285,923 1,428,613 373,421 3,820,766 272,697 1,364,488 18,174 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 33,490,615 2,391,688 11,960,435 292,000 37,203,278 2,657,377 13,285,885 971,488 34,421,678 2,458,477 12,293,385 777,791 6,090,873 5,476,125 Total Neighborhood Protection 48,134,738 54,118,028 49,951,331 12,160,491 4,131,457 37,686 10,297,992 3,143,540 13,371 92,559,251 28,948,147 119,000 103,696,261 32,694,556 496,107 95,129,762 29,753,960 134,304 16,329,634 13,454,903 121,626,398 136,886,924 125,018,026 6,085,364 5,679,146 48,789,684 57,791,761 50,263,649 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 JUNE 30 2023 2022 $ 387,184 297,156 14,392 38,160 $ Budget Estimate 2022-2023 Source 505,419 212,804 3,974 55,063 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 $ 7,088,653 3,502,924 110,952 508,685 $ 6,571,680 3,179,501 20,907 537,229 736,892 777,260 Total Golf Courses 9,561,976 11,211,214 10,309,317 40,048,398 2,683,991 37,242,079 2,241,925 Transit 2000 & 2050: Sales Taxes Interest/Other 326,454,730 38,156,549 362,473,105 42,192,169 335,608,608 26,998,864 42,732,389 39,484,004 364,611,279 404,665,274 362,607,472 3,841,309 2,327,176 Court Awards 4,532,715 4,655,362 6,050,965 (3,763,968) (4,096,449) Planning and Development 81,725,100 90,780,750 87,581,081 879,817 338,801 Capital Construction 6,299,234 6,935,047 6,350,678 5,363,120 212,970 3,459,333 47,204 Sports Facilities: Sales Taxes Interest/Other 24,576,788 3,877,936 31,999,731 5,266,858 27,040,132 3,922,630 5,576,090 3,506,537 Total Sports Facilities 28,454,724 37,266,589 30,962,762 15,846,904 374,022 (15,138) 14,546,305 102,562 26,307 Highway User Revenue: Highway User Revenue Interest Other 154,499,000 500,000 - 152,748,386 3,241,369 51,956 155,465,241 630,024 364,038 16,205,788 14,675,174 154,999,000 156,041,711 156,459,303 - - Total Transit 2000 & 2050 Total Highway User Revenue Local Transportation Assistance - - - 3,271,394 1,306,441 Regional Transit Revenues 45,671,569 41,168,970 7,058,415 4,663,423 1,948,363 Community Reinvestment 6,045,200 9,668,701 6,949,583 24,989,649 16,617,775 Other Restricted Fees 48,378,624 51,543,405 31,672,953 850,774 3,603,711 851,981 381,348 2,939,503 6,000,530 Grants: Public Housing: Rentals Grants Other 5,540,493 124,466,359 27,004,331 4,913,164 110,509,168 18,305,417 5,292,053 94,754,765 20,923,236 5,306,466 9,321,381 157,011,183 133,727,749 120,970,054 28,551,235 52,674,296 8,125,048 121,554,512 72,598,319 94,869,017 7,147,559 111,443,663 76,011,213 96,561,074 54,728,038 387,015,508 104,723,579 41,937,252 32,580,903 151,795,433 134,441,220 172,716,681 17,446,156 148,900,216 210,905,091 286,058,558 Total Other 614,315,833 331,037,167 473,504,273 216,211,557 295,379,939 Total Grants 771,327,016 464,764,916 594,474,327 11,724,234 453,614 12,260,176 2,200,045 124,847,420 4,130,117 126,148,163 5,117,713 119,973,319 3,962,894 12,177,848 14,460,221 Total G.O. Bond/Secondary Property Tax 128,977,537 131,265,876 123,936,213 356,028,059 411,335,416 Total Special Revenue and Debt Service Funds 1,869,134,794 1,658,764,528 1,649,646,075 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 JUNE 30 2023 2022 Budget Estimate 2022-2023 Source Actual Year-to-Date 2022-2023 2021-2022 Enterprise Funds AVIATION: $ 10,986,094 $ 33,819,290 1,186,096 65,188,595 274,838 323,359 467,048 9,202,210 28,432,608 109,441 117,440,218 264,026 286,370 125,043 112,245,320 155,859,916 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 $ 111,351,657 376,413,685 10,442,491 64,234,438 3,465,911 3,946,192 3,947,047 $ 99,932,418 313,626,959 1,460,615 151,223,426 3,053,232 3,491,322 851,717 508,515,639 573,801,421 573,639,689 73,883,063 17,349,462 453,000 92,515,977 28,380,991 2,415,124 77,786,044 21,045,586 315,500 91,685,525 123,312,092 99,147,130 495,373,898 3,000,000 5,461,000 9,119,120 6,200,000 6,953,000 (838,421) 447,850,757 2,854,683 5,067,286 9,802,735 6,910,320 13,496,749 11,431,430 460,337,051 2,972,008 9,503,834 8,411,320 6,364,860 2,245,606 2,440,608 525,268,597 497,413,960 492,275,287 CONVENTION CENTER: 14,166,742 2,247,582 341,162 8,685,057 2,606,715 55,591 16,755,486 11,347,363 Excise Taxes Operating Revenue Interest Total Convention Center WATER SYSTEM: 46,871,052 269,820 (1,813,663) 1,070,807 414,660 6,797,838 (1,167,555) 51,720,293 282,523 (1,671,673) 1,008,306 281,880 898,488 (698,850) 52,442,959 51,820,967 Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other Total Water System WASTEWATER: 18,183,718 1,456,119 397,860 2,981,636 5,571,786 20,694,330 (6,429,432) 254,220 403,177 3,051,432 Sewer Service Charges Multi-City Development Fees Interest Other 216,761,657 17,370,062 7,000,000 3,953,000 23,805,606 206,197,849 21,682,381 6,612,390 9,395,496 31,150,352 213,922,095 13,615,667 6,086,070 2,113,338 31,121,207 28,591,119 17,973,727 Total Wastewater 268,890,325 275,038,468 266,858,377 174,865,017 13,285,000 170,000 8,348,370 179,193,138 14,165,716 1,336,354 8,893,706 173,609,450 13,975,373 287,429 11,778,012 196,668,387 203,588,914 199,650,264 1,591,028,473 1,673,154,855 1,631,570,747 SOLID WASTE: $ 15,366,632 1,780,275 158,608 (224,004) 14,846,330 1,361,826 47,699 (976,567) 17,081,511 15,279,288 227,116,395 252,281,261 724,116,463 $ 792,478,514 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ 25 5,049,646,562 $ 5,027,804,681 $ 4,789,741,310 Citywide Operating Expenditures by Program For the Month Ended JUNE 30 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 $ 327,707 $ 963,008 1,155,883 15,458,037 19,491 269,806 343,877 3,813,486 180,337 139,396 3,864,931 577,512 13,912 491,468 2,798,034 620,375 264,423 828,567 1,045,111 9,111,555 93,516 386,982 310,069 2,617,247 189,868 199,574 2,473,530 (2,218,475) 13,552 482,657 64,229,683 1,060,880 31,037,261 81,088,740 $ 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,985,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 6,350,783 $ 2,424,640 5,589,063 8,275,213 88,279,571 1,341,724 3,843,140 2,989,077 30,550,256 3,357,634 5,615,594 47,772,367 445,964 111,738 4,287,263 35,590,488 5,770,030 $ 2,200,130 4,782,318 6,429,267 65,671,066 1,288,130 3,366,172 3,231,082 26,294,072 2,743,127 4,330,910 21,021,488 429,873 104,004 4,007,629 88,217,273 4,807,998 $ 2,424,640 5,589,063 8,275,213 77,314,648 1,341,724 3,843,140 2,989,077 30,550,256 3,357,634 5,615,594 47,191,050 445,964 111,738 4,287,263 24,508,919 5,770,030 $ 10,964,924 581,317 11,081,569 - 246,372,707 246,243,762 238,924,537 223,615,952 22,627,810 45,627,473 5,821,708 43,837,141 5,584,931 39,478,171 7,575,381 38,765,777 5,584,931 5,071,364 - 51,449,181 49,422,072 47,053,551 44,350,708 5,071,364 877,646,532 505,002,879 - 869,414,657 485,006,794 - 779,052,175 449,574,235 275,086 867,850,977 483,720,987 - 1,563,680 1,285,807 - 1,382,649,411 1,354,421,451 1,228,901,496 1,351,571,964 2,849,487 Criminal Justice 5,180,770 839,799 3,737,926 484,918 6,020,569 4,222,844 Municipal Court Public Defender Total Criminal Justice Public Safety 75,331,292 40,611,302 - 95,894,994 46,219,479 192,514 115,942,594 142,306,987 Police Fire Other Total Public Safety Transportation 8,294,041 1,066,131 41,719,489 (11,512,131) 6,721,019 726,404 51,682,174 (12,655,578) Street Transportation Street Lighting Aviation Public Transit 125,461,150 9,224,160 407,090,969 293,260,282 108,239,676 11,469,544 403,941,252 269,290,210 97,447,458 9,377,633 453,292,136 236,966,900 97,975,427 11,469,544 305,024,677 269,290,210 10,264,249 98,916,575 - 39,567,530 46,474,019 Total Transportation 835,036,561 792,940,681 797,084,128 683,759,856 109,180,824 Community Development 8,081,493 13,652,423 2,508,971 4,543,743 8,396,863 12,781,476 2,547,037 2,530,325 Planning and Development Housing Economic Development Neighborhood Services Department 90,299,394 123,786,419 24,460,571 68,067,495 82,730,457 126,331,818 23,425,142 37,991,223 74,292,826 108,139,131 16,905,954 28,622,196 82,730,457 126,259,170 17,896,974 37,991,223 72,647 5,528,168 - 28,786,630 26,255,701 Total Community Development 306,613,879 270,478,639 227,960,108 264,877,824 5,600,815 139,122,866 49,254,411 69,897,540 13,127,552 217,626,335 6,521,208 7,091,626 129,821,014 47,496,467 68,749,694 13,127,551 179,250,077 5,887,539 5,885,364 118,961,942 42,924,922 62,221,285 12,273,429 174,940,063 4,508,502 4,671,181 129,367,513 47,496,467 51,285,334 179,155,767 5,887,539 5,885,364 453,502 17,464,360 13,127,551 94,310 - 502,641,538 450,217,705 420,501,325 419,077,983 31,139,723 Community Enrichment 16,038,639 5,181,067 4,771,580 1,094,893 (8,138,005) 82,197 520,040 13,846,007 3,591,981 4,699,659 624,913 16,179,326 102,614 535,050 19,550,409 39,579,549 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 JUNE 30 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 $ 26,547,301 $ 16,842,441 18,516,188 7,119,999 759,365 62,606 27,746,591 14,324,419 14,501,099 2,786,547 352,462 81,671 Water System Wastewater Solid Waste Management Public Works Environmental Programs Manager's Office of Sustainability 69,847,900 59,792,789 Total Environmental Services 1,952,924 1,420,565 176,313 638,663 52,010 183,009 27,646 542,998 584,835 20,431 1,502,656 1,053,105 90,619 50,000 1,589,303 989,422 2,417 26,786 1,611,837 276,014 53,413 576,417 45,044 234,518 185,375 1,183,415 591,731 54,540 1,542,082 794,462 362,301 90,619 281,250 78,875 1,644,815 977,422 2,129 26,786 10,903,701 10,613,045 135,600,145 $ 435,010,163 201,009,119 179,991,778 51,923,026 4,226,968 1,036,338 $ 411,493,436 199,503,218 173,758,810 39,720,375 4,893,176 732,384 $ 365,422,108 180,841,627 172,226,796 31,332,890 1,820,383 741,749 $ 263,924,734 123,834,691 159,184,480 27,580,745 4,893,176 732,384 $ 147,568,702 75,668,528 14,574,330 12,139,630 - 873,197,392 830,101,399 752,385,553 580,150,209 249,951,190 34,795,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 52,303,981 17,060,808 2,125,550 8,738,479 819,125 2,893,288 331,750 10,284,127 10,448,266 245,175 28,743,990 16,570,813 1,087,431 1,772,443 600,000 37,884,281 15,573,915 49,000 321,429 20,183,061 3,425,910 720,540 7,945,344 540,525 2,833,846 2,224,501 15,048,257 7,197,572 654,475 19,995,352 10,580,809 4,347,610 1,087,431 281,273 946,500 20,707,738 12,013,347 25,550 321,429 52,303,981 17,060,808 2,125,550 8,738,479 819,125 2,893,288 331,750 10,284,127 10,448,266 245,175 28,743,990 16,570,813 1,087,431 1,368,401 600,000 37,884,281 15,573,915 49,000 321,429 404,042 - Total Debt Service 210,920,331 207,853,852 131,081,070 207,449,810 404,042 89,740,675 Capital Improvement 1,389,224,070 535,930,906 563,635,243 535,930,906 - - 4,676,746 American Rescue Plan Act 13,447,955 - 81,421,501 - - - - Vacancy Savings (20,000,000) - - - - - - Contingencies 186,288,000 - - - - General Obligation Debt Service $ 457,256,739 $ 504,751,095 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,737,610,467 $ 4,488,948,511 $ 4,310,785,212 $ 426,825,255 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 $ 25,095,199 27,306,067 1,501,024 23,490,001 31,202,561 14,653,584 8,752,162 1,521,060 3,612,736 103,425,306 40,996,919 3,200,990 12,654,832 1,702,623 48,743,885 38 146,884,690 2,587,200 14,775,964 5,469,106 5,034,553 6,677,698 16,571,818 1,101,455 4,848,783 40,899,604 553,157 12,345,107 237,152,569 379,490 177,455,711 $ $ 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 25,095,199 21,031,486 1,950,971 19,304,478 14,653,584 8,752,162 1,521,060 3,612,736 36,789,019 3,200,990 517,198 48,161,731 133,991,790 $ 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,274,581 1,501,024 21,539,030 11,898,083 103,425,306 4,207,900 12,654,832 1,185,425 582,154 38 12,892,900 $ 902,484 27,425,677 12,145,275 3,198,976 10,514,917 80,429,637 5,109,388 18,679,664 7,756,720 3,631,084 99,797,295 69,552,469 12,337,010 8,326,814 6,083,580 467,234,717 6,000,962 213,437,799 $ 1,547,308,145 $ 494,743,677 $ 525,852,215 $ 927,905,167 $ 318,582,404 $ 619,402,978 $ 176,161,273 $ 1,052,564,468 $ $ 567,087,818 169,543,000 28,946,616 507,203,480 389,928,515 1,662,709,429 $ 3,210,017,574 $ $ 134,479,069 112,717,475 22,723,008 147,619,728 152,430,940 569,970,221 $ $ 115,394,586 84,750,933 28,986,269 182,709,702 205,485,392 617,326,881 $ 1,064,713,898 $ 1,143,179,096 28 $ 188,456,320 10,943,000 18,447,037 86,081,878 157,390,668 461,318,903 38,825,058 4,126,115 14,257,937 42,251,566 117,887,826 $ 217,348,502 $ 1,389,224,070 $ 535,930,906 $ $ $ $ 378,631,498 158,600,000 10,499,579 421,121,602 232,537,847 1,201,390,526 $ 1,820,793,504 $ $ 95,654,011 108,591,360 8,465,071 105,368,162 34,543,114 352,621,719 $ $ 432,608,749 56,825,525 6,223,608 359,583,752 237,497,575 1,092,739,208 $ 528,782,992 $ 2,145,303,676 Bonds Authorized and Sold As of JUNE 30 (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 June 64,281 50,222 67,088 61,286 56,272 69,592 YTD thru June 486,550 498,543 559,462 659,161 696,962 631,432 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 June 8,298 5,321 12,848 17,415 16,105 12,976 YTD thru June 165,066 171,926 201,292 229,901 241,813 227,155 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 June 3,276 2,611 4,365 4,515 4,590 4,102 YTD thru June 70,210 70,484 79,768 78,695 80,593 83,099 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 June 280,540 378,887 362,173 540,197 497,001 503,355 YTD thru June 2,387,755 2,554,356 2,921,146 3,158,172 3,354,651 3,458,619 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 June 35,938 10,702 91,844 155,860 112,245 86,900 YTD thru June 395,233 362,345 391,196 573,640 573,801 508,515 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 June 38,106 52,141 43,174 51,821 52,443 52,842 YTD thru June 402,820 454,116 492,162 492,275 497,414 525,268 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 June 16,544 18,289 17,424 17,973 28,591 18,563 YTD thru June 243,031 252,659 254,744 266,858 275,038 268,890