January 2023 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division January 31, 2023 To the Mayor and City Council: This is the City's Financial Report for January, the seventh 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 April 5, 2024 INDEPENDENT AUDITOR REPORT To the Chief Financial Officer, We have assessed the Finance Department’s (Finance) January 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, Aaron Cook City Auditor City of Phoenix Monthly Financial Report January 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 2 Expected Public Safety 2 Expected Transportation 3 Monitor and Consider Taking Action Community Development 3 Better than Expected Community Enrichment 4 Better than Expected Environmental Services 4 Better than Expected Citywide Expenditures Citywide Total Operating Expenditures 5 Better than Expected General Government 5 Monitor and Consider Taking Action Criminal Justice 6 Better than Expected Public Safety 6 Monitor and Consider Taking Action Transportation 7 Better than Expected Community Development 7 Better than Expected Community Enrichment 8 Better than Expected Environmental Services 8 Better than Expected General Obligation Debt Service 9 Monitor and Consider Taking Action Capital Expenditures CIP-General Government 10 CIP-Aviation 10 CIP-Phoenix Convention Center 11 CIP-Solid Waste Disposal 11 CIP-Wastewater 12 CIP-Water System 12 Page Performance Status General Fund Total Operating Revenue 13 Better than Expected Property Tax 14 Better than Expected Local Sales Tax 15 Better than Expected Revenues by Source State Sales Tax 16 Better than Expected Vehicle License Tax 17 Monitor and Consider Taking Action Governmental Funds 18 Monitor and Consider Taking Action Aviation 19 Better than Expected Water System 20 Monitor and Consider Taking Action Wastewater 21 Monitor and Consider Taking Action Financial Schedules Page General Fund Revenue 22 General Fund Expenditures 23 Citywide Operating Revenue 24 Citywide Operating Expenditures 25 Citywide Operating Revenue by Source 26 Citywide Operating Expenditures by Program 30 Capital Expenditures and Encumbrances 33 Bonds Authorized and Sold 34 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. January General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Total General Fund Expenditures 18-19 19-20 20-21 21-22 22-23 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 723,600 1,214,362 59.6% 803,429 1,282,831 62.6% 807,024 1,371,152 58.9% 845,001 1,470,251 57.5% 942,130 1,678,993 56.1% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustment for contingencies. Better than Expected Total General Fund General Government $1,800,000 $1,600,000 $1,600,000 $1,400,000 $1,400,000 $1,200,000 $1,200,000 $1,000,000 $1,000,000 $800,000 $800,000 $600,000 $600,000 $400,000 $400,000 $200,000 $200,000 $0 $0 January YTD January YTD Expenditures Expenditures Annual Annual Expenditures * Expenditures * 18-19 18-19 19-20 20-21 19-20 21-22 20-21 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 January are 11.5% 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 18-19 19-20 20-21 21-22 22-23 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 71,351 114,393 62.4% 82,137 123,100 66.7% 88,113 154,211 57.1% 94,798 161,907 58.6% 109,713 208,388 52.6% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal GeneralJustice Government $180,000 $250,000 $160,000 $140,000 $200,000 $120,000 $100,000 $150,000 $80,000 $100,000 $60,000 $40,000 $50,000 $20,000 $0 January YTD Expenditures January YTD Expenditures Annual Expenditures * Annual Expenditures * 18-19 19-20 19-20 18-19 20-21 20-21 22-23 21-22 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 January are 15.7% 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. 1 January General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Criminal Justice 18-19 19-20 20-21 21-22 22-23 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 19,966 33,387 59.8% 20,914 35,033 59.7% 20,819 36,162 57.6% 21,919 40,008 54.8% 23,693 43,390 54.6% * - For prior years-total actual expenditures, for current year-total approved budget Expected Criminal Justice $50,000 January YTD Expenditures $40,000 $30,000 Annual Expenditures * $20,000 $10,000 $0 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 202122 actuals. Fiscal year 2022-23 actual general fund expenditures through January are 8.1% 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. Public Safety Public Safety January YTD Annual % of Annual Expenditures Expenditures * Expenditures 497,136 841,467 59.1% 540,890 893,403 60.5% 548,165 925,920 59.2% 574,249 992,648 57.9% 634,818 1,088,575 58.3% $1,200,000 * - For prior years-total actual expenditures, for current year-total approved budget $0 18-19 19-20 20-21 21-22 22-23 $1,000,000 January YTD Expenditures $800,000 $600,000 $400,000 Annual Expenditures * $200,000 18-19 19-20 20-21 21-22 22-23 Expected 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 2021-22 actuals. Fiscal year 2022-23 actual general fund public safety expenditures through January are 10.5% 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. 2 January General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Transportation 18-19 19-20 20-21 21-22 22-23 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 12,296 18,337 67.1% 13,050 19,748 66.1% 14,984 22,144 67.7% 11,692 23,166 50.5% 15,988 26,085 61.3% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action CommunityTransportation Development $1 $30,000 $1 Series1 $1 $20,000 January YTD Expenditures $1 $0 $10,000 $0 Series2 Annual Expenditures * $0 $0 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 202122 actuals. Fiscal year 2022-23 actual general fund transportation expenditures through January are 36.7% 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 18-19 19-20 20-21 21-22 22-23 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 12,563 21,238 59.2% 13,989 22,542 62.1% 24,441 24,114 101.4% 15,237 28,225 54.0% 17,627 36,748 48.0% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Community Development $40,000 $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $5,000 $0 January YTD Expenditures Annual Expenditures * 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 January are 15.7% 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. 3 January General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Community Enrichment 18-19 19-20 20-21 21-22 22-23 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 94,512 156,552 60.4% 109,833 155,417 70.7% 91,616 158,589 57.8% 103,499 173,631 59.6% 113,839 197,458 57.7% * - For prior years-total actual expenditures, for current year-total approved budget Community Enrichment $240,000 January YTD Expenditures $200,000 $160,000 $120,000 Annual Expenditures * $80,000 $40,000 $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 January are 10.0% 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 18-19 19-20 20-21 21-22 22-23 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 11,409 16,886 67.6% 15,469 19,180 80.7% 14,724 20,905 70.4% 18,122 26,508 68.4% 15,770 29,534 53.4% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Environmental Services $32,000 $28,000 $24,000 $20,000 $16,000 $12,000 $8,000 $4,000 $0 January YTD Expenditures Annual Expenditures * 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 2021-22 actuals. Fiscal year 2022-23 actual general fund environmental service expenditures through January are 13.0% 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. 4 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. January Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Total Citywide Operating 18-19 19-20 20-21 21-22 22-23 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 2,368,890 3,775,464 62.7% 2,374,095 3,814,963 62.2% 2,368,844 4,163,122 56.9% 2,657,700 4,488,949 59.2% 2,846,351 5,811,553 49.0% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustments for contingencies and use of the early redemption fund. Total Citywide $7,000,000 $6,000,000 January YTD Expenditures $5,000,000 $4,000,000 $3,000,000 $2,000,000 Annual Expenditures * $1,000,000 $0 18-19 Better than Expected 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 January are 7.1% higher than the same period in the prior fiscal year. General Government 18-19 19-20 20-21 21-22 22-23 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 83,797 138,349 60.6% 94,503 157,200 60.1% 124,691 207,451 60.1% 103,630 238,925 43.4% 146,735 245,463 59.8% * - For prior years-total actual expenditures, for current year-total approved budget General Government $300,000 $250,000 January YTD Expenditures $200,000 $150,000 $100,000 Annual Expenditures * $50,000 $0 18-19 Monitor and Consider Taking Action 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 January are 41.6% 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 January Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Criminal Justice January YTD Annual % of Annual Expenditures Expenditures * Expenditures 25,368 42,530 59.6% 26,282 44,425 59.2% 25,607 44,147 58.0% 26,025 47,054 55.3% 27,589 51,449 53.6% 18-19 19-20 20-21 21-22 22-23 * - For prior years-total actual expenditures, for current year-total approved budget Criminal Justice $60,000 January YTD Expenditures $50,000 $40,000 $30,000 Annual Expenditures * $20,000 $10,000 $0 18-19 Better than Expected 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 January are 6.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. Public Safety 18-19 19-20 20-21 21-22 22-23 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 609,051 1,025,513 59.4% 666,703 1,110,457 60.0% 667,778 1,122,901 59.5% 715,062 1,228,901 58.2% 802,352 1,348,529 59.5% * - For prior years-total actual expenditures, for current year-total approved budget Public Safety $1,600,000 $1,400,000 $1,200,000 $1,000,000 $800,000 $600,000 $400,000 $200,000 $0 January YTD Expenditures Annual Expenditures * 18-19 19-20 20-21 21-22 22-23 Monitor and Consider Taking Action 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 January are 12.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. 6 January Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Transportation 18-19 19-20 20-21 21-22 22-23 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 509,830 722,667 70.5% 561,011 774,492 72.4% 477,057 786,597 60.6% 586,820 797,084 73.6% 568,575 831,587 68.4% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Transportation $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $0 January YTD Expenditures Annual Expenditures * 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 January are 3.1% 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 18-19 19-20 20-21 21-22 22-23 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 114,290 195,716 58.4% 124,284 229,793 54.1% 160,361 245,310 65.4% 127,962 227,960 56.1% 151,624 306,574 49.5% * - For prior years-total actual expenditures, for current year-total approved budget Community Development $350,000 $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 $0 January YTD Expenditures Annual Expenditures * 18-19 Better than Expected 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 January are 18.5% 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. 7 January Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Community Enrichment 18-19 19-20 20-21 21-22 22-23 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 191,638 317,465 60.4% 213,865 316,680 67.5% 221,173 390,805 56.6% 262,109 420,501 62.3% 294,307 479,012 61.4% * - For prior years-total actual expenditures, for current year-total approved budget Community Enrichment $600,000 January YTD Expenditures $500,000 $400,000 $300,000 Annual Expenditures * $200,000 $100,000 $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 13.9% over fiscal year 2021-22 actuals in total operating expenditures. Actual expenditures through January are 12.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. Environmental Services 18-19 19-20 20-21 21-22 22-23 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 408,296 670,219 60.9% 407,400 692,524 58.8% 433,301 734,733 59.0% 464,074 752,386 61.7% 491,252 853,197 57.6% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $0 January YTD Expenditures Annual Expenditures * 18-19 19-20 20-21 21-22 22-23 Better than Expected 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 January are 5.9% 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. 8 January Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 General Obligation Debt Service Citywide Debt Service Expenditures 18-19 19-20 20-21 21-22 22-23 January YTD Annual % of Annual Expenditures Expenditures * Expenditures 68,036 116,634 58.3% 76,260 130,839 58.3% 77,110 131,938 58.4% 76,661 131,081 58.5% 153,335 198,070 77.4% * - For prior years-total actual expenditures, for current year-total approved budget net of credit for early redemption fund resources $240,000 January YTD Expenditures $180,000 $120,000 Annual Expenditures * $60,000 $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 January 2023 are 100.0% 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-toyear comparison from December 2018 forward, all debt service budgeted and actual expenditures are reported by functional areas. -9- 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 (Dollars in Thousands) 19-20 18-19 General Gov't $ Refer to detailed financial schedules pages 22 - 34 384,131 $ 500,745 20-21 $ 21-22 684,798 $ 525,852 Discussion: 22-23 (Budget) 22-23 (YTD) $ $ 197,227 1,547,308 General Gov't 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. 22-23 (YTD) 22-23 (Budget) 21-22 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. 20-21 19-20 18-19 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. $0 $500,000 $1,000,000 22-23 (Budget) 22-23 (YTD) $ $ $1,500,000 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. 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 18-19 Aviation $ 552,972 $ 254,523 20-21 $ 172,418 21-22 $ 115,395 567,088 25,387 Discussion: Aviation 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. 22-23 (YTD) 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 (Budget) 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. 21-22 20-21 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. 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. - 10 - Capital Expenditures (Dollars in Thousands) Phx Convention Ctr 18-19 19-20 $ 36,542 $ 52,148 Refer to detailed financial schedules pages 22 - 34 20-21 $ 31,640 21-22 22-23 (Budget) 22-23 (YTD) $ 84,751 $ 169,543 $138,965 Discussion: Phx Convention Ctr 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. 22-23 (YTD) 22-23 (Budget) 21-22 20-21 19-20 18-19 $0 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. 18-19 Solid Waste $ 7,857 19-20 $ 5,490 20-21 $ 8,796 $40,000 22-23 (Budget) 21-22 $ 28,986 $ 28,947 $80,000 $120,000 $160,000 22-23 (YTD) $ 15,100 Discussion: Solid Waste 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. 22-23 (YTD) 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 (Budget) 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. 21-22 20-21 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. 19-20 18-19 $0 $15,000 $30,000 $45,000 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. - 11 - Capital Expenditures (Dollars in Thousands) 18-19 Wastewater $ 97,890 Refer to detailed financial schedules pages 22 - 34 19-20 $ 123,141 20-21 $ 77,339 21-22 22-23 (Budget) 22-23 (YTD) $ 182,710 $ 507,203 $ 56,005 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. 22-23 (Budget) 21-22 20-21 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. 19-20 18-19 $0 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. $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 $ 252,146 20-21 $ 434,000 21-22 22-23 (Budget) 22-23 (YTD) $ 205,485 $ 389,929 $ 49,207 Discussion: Water System 22-23 (YTD) 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. 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) 21-22 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. 20-21 19-20 18-19 $0 $100,000 $200,000 $300,000 $400,000 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. 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. - 12 - 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 (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 General Fund Revenues $1,800,000 $1,600,000 $1,400,000 $1,200,000 $1,000,000 $800,000 $600,000 $400,000 $200,000 $0 January YTD Revenues Annual Revenues* 18-19 18-19 19-20 20-21 21-22 22-23 January YTD Revenues 696,529 741,812 863,490 885,713 983,281 19-20 Annual Revenues* 1,220,768 1,307,357 1,491,537 1,508,526 1,589,483 20-21 21-22 22-23 % of Annual Revenues 57.1% 56.7% 57.9% 58.7% 61.9% * - For prior years - total actual revenues, for current year - total approved budget Better than Expected Fiscal year 2022-23 general fund operating revenues are budgeted to increase 5.4% over prior year actuals. Actual revenues through January are 11.0% higher than the same period in the prior fiscal year. Specific revenue sources are discussed on the following pages. - 13 - Property Tax Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Property Taxes Primary & Secondary 270,000 240,000 101,652 210,000 107,555 115,069 124,847 119,973 180,000 Secondary 71,345 150,000 120,000 90,000 162,129 170,209 182,043 199,194 192,215 60,000 Primary 113,839 30,000 18-19 FY 18-19 19-20 20-21 21-22 22-23 YTD 22-23 Budget Total 263,781 277,764 297,112 312,188 185,184 324,043 July (1,049) (1,141) (1,619) (1,490) (1,541) (1,553) 19-20 Aug 688 1,081 1,541 1,141 1,275 1,375 Sept 980 647 1,288 1,040 1,357 1,087 20-21 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 21-22 Dec 30,444 23,612 38,512 33,534 39,943 34,943 22-23 YTD Jan 13,302 14,875 15,608 18,086 16,279 17,742 Feb 5,422 7,447 6,612 6,889 7,652 22-23 Budget Mar 8,130 8,185 9,456 8,972 9,722 Apr 12,026 12,116 15,171 15,063 15,470 May 68,870 66,043 76,862 71,096 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 Better than 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. - 14 - Primary Secondary 162,129 101,652 170,209 107,555 182,043 115,069 192,215 119,973 113,839 71,345 199,194 124,847 Local Sales Tax Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Local Sales Tax Budget vs Actual 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 January are 12.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 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 January 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. - 15 - State Sales Tax Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 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 January are 5.6% 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 January fiscal year 2022-23 State Sales Tax revenues are higher 3.7% 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. - 16 - Vehicle License Tax Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 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 January are 7.7% 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 January fiscal year 2022-23 Vehicle License Tax revenues increased 0.3% 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. - 17 - Governmental Funds Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 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 January are 5.9% 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 January fiscal year 2022-23 Governmental Funds revenues increased 5.0% 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. - 18 - Aviation Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Aviation Operating Revenues Budget vs Actual 100,000 90,000 80,000 70,000 22-23 Actuals 60,000 50,000 22-23 Budget 40,000 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 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 January are 3.1% 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 200,000 150,000 20-21 Actuals 100,000 21-22 Actuals 22-23 Actuals 50,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Through January fiscal year 2022-23 Aviation revenues increased 1.2% 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. - 19 - Water System Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 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 January are 5.2% 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 January fiscal year 2022-23 Water System Operating revenues increased 5.2% 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. - 20 - Wastewater Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 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 January are 3.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 January fiscal year 2022-23 Wastewater Operating revenues decreased 2.7% 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. - 21 - 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 JANUARY 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 $ 404,639 $ 2,325 382,904 2,498 227,155 310,387 83,100 199,194 2,872 9,000 145,668 179,774 47,937 113,839 1,685 1,917 140,528 124,924 47,798 109,423 1,596 2,150 8,184 920 14,154 399 5,722 1,828 6,818 4,435 417 6,775 296 3,767 1,036 6,625 4,573 454 8,386 337 2,933 1,067 5,743 44,313 1,500 17,518 5,550 16,432 27,936 658 10,170 8,488 14,894 26,353 512 12,049 1,756 9,727 1,589,483 - 22 - $ 983,281 $ 885,711 General Fund Expenditures As of JANUARY 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,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,340 $ 2,728 4,877 40,766 2,074 1,411 16,055 2,040 3,498 15,408 3,148 13,857 2,511 109,713 1,314 2,588 4,105 32,899 1,847 1,664 14,632 1,883 3,034 12,949 2,728 12,700 2,455 94,798 Criminal Justice Municipal Court Public Defender Total Criminal Justice 37,568 5,822 43,390 20,839 2,855 23,693 18,842 3,077 21,919 Public Safety Police Fire Others Total Public Safety 659,530 429,045 1,088,575 389,649 245,169 634,818 351,661 222,783 (194) 574,249 Transportation Street Transportation Public Transit Total Transportation 24,194 1,891 26,085 14,098 1,890 15,988 10,050 1,642 11,692 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 9,599 18,478 6,608 2,063 36,748 4,420 9,688 2,198 1,322 17,627 4,006 8,599 2,471 161 15,237 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 116,611 45,841 26,042 8,964 197,458 64,279 28,178 14,903 6,479 113,839 59,268 26,306 13,029 4,896 103,499 Environmental Services Public Works Environmental Programs Others Total Environmental Services 27,275 1,561 698 29,534 14,563 677 530 15,770 17,147 526 449 18,122 Capital Improvement 48,815 10,682 5,486 Vacancy Savings (20,000) - - Contingencies 120,788 - - 942,130 $ 845,001 Total Expenditures and Encumbrances $ 1,779,782 - 23 - $ 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 JANUARY 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 $ Total General Funds 631,431 3,006 404,639 $ 2,325 382,904 2,498 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 145,668 179,774 47,937 113,839 1,685 1,917 4,852 6,775 296 3,767 1,036 6,625 38,764 8,488 14,894 140,528 124,924 47,798 109,423 1,596 2,150 5,027 8,386 337 2,933 1,067 5,743 38,914 1,756 9,727 1,589,484 983,281 885,712 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 29,539 75,020 32,167 5,378 220,619 (500) 65,132 3,826 15,606 88,306 22,200 3,083 14,702 63,284 71,528 27,170 70,119 27,552 4,920 197,145 2,398 57,479 3,850 13,242 89,574 2,736 2,989 5,718 151,953 69,984 1,869,135 709,889 726,829 508,516 91,686 525,269 268,890 196,668 262,543 61,821 310,506 153,337 118,329 259,333 49,285 295,282 157,559 116,253 1,591,028 906,535 877,711 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 $ Actual Year-to-Date 2022-2023 2021-2022 5,049,647 - 24 - $ $ 2,599,705 $ 2,490,253 Citywide Operating Expenditures As of JANUARY 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 109,713 $ 37,022 146,735 94,798 8,832 103,630 43,390 8,059 51,449 23,693 3,896 27,589 21,919 4,106 26,025 Public Safety General Funds Other Funds Total Public Safety 1,088,575 259,954 1,348,529 634,818 167,534 802,352 574,249 140,813 715,062 Transportation General Funds Other Funds Total Transportation 26,085 805,502 831,587 15,988 552,587 568,575 11,692 575,128 586,820 Community Development General Funds Other Funds Total Community Development 36,748 269,826 306,574 17,627 133,997 151,624 15,237 112,725 127,962 Community Enrichment General Funds Other Funds Total Community Enrichment 197,458 281,554 479,012 113,839 180,468 294,307 103,499 158,610 262,109 Environmental Services General Funds Other Funds Total Environmental Services 29,534 823,663 853,197 15,770 475,482 491,252 18,122 445,952 464,074 Debt Service General Funds Other Funds Total Debt Service 198,070 198,070 153,335 153,335 76,661 76,661 48,815 1,340,409 1,389,224 10,682 199,900 210,582 5,486 264,299 269,785 American Rescue Plan Act General Funds Other Funds Total American Rescue Plan Act 108,448 108,448 - 25,570 25,570 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 942,130 1,904,221 2,846,351 $ $ 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,075 245,463 $ $ - 25 - 845,002 1,812,696 2,657,698 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 JANUARY 31 2023 2022 Budget Estimate 2022-2023 Source Actual Year-to-Date 2022-2023 2021-2022 General Funds $ 70,666,688 780,458 71,447,146 $ 70,196,712 581,579 Local Taxes: Sales Taxes Privilege License Fees $ 631,430,699 3,006,300 $ 404,638,620 2,324,969 $ 382,903,963 2,498,389 70,778,291 Total Local Taxes 634,436,999 406,963,589 385,402,352 20,469,634 25,681,939 6,683,450 22,363,978 17,673,908 7,284,564 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 227,155,000 310,387,000 83,100,000 145,668,372 179,773,575 47,936,583 140,527,664 124,924,397 47,797,731 52,835,023 47,322,450 620,642,000 373,378,530 313,249,792 10,118,714 11,270,280 Primary Property Tax 199,194,000 113,838,578 109,423,391 168,604 121,036 Licenses and Permits 2,872,000 1,685,167 1,595,969 0 0 Cable Communications 9,000,000 1,916,887 2,149,885 585,809 48,987 Municipal Court: Fines and Forfeitures Court Default Fee 8,184,192 920,000 4,434,507 417,337 4,572,771 454,148 662,578 57,512 720,090 634,796 659,973 1,296,133 101,986 6,168 486,932 380,415 176,519 238,738 Total State Shared Taxes Total Municipal Court 9,104,192 4,851,844 5,026,919 14,154,183 6,775,272 8,385,745 399,106 296,244 337,080 Parks and Recreation 5,722,212 3,766,857 2,933,277 145,135 Planning and Development 1,828,100 1,035,798 1,066,838 450,743 Street Transportation 6,818,100 6,625,173 5,743,321 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other 44,313,000 1,500,000 17,517,798 27,936,036 658,025 10,170,310 26,352,935 512,150 12,049,282 63,330,798 38,764,371 38,914,367 1,756,298 Police Library Fees 2,698,471 93,875 1,419,087 3,324,064 100,375 3,869,899 4,211,433 7,294,338 1,814,014 282,305 Interest 5,550,000 8,488,368 1,243,380 571,491 Other Fees and Service Charges 16,431,605 14,893,985 9,727,204 144,222,552 140,553,581 1,589,483,295 983,280,663 885,712,438 Total Fire Total General Funds 26 Citywide Operating Revenue by Source (continued) For the Month Ended JANUARY 31 2023 2022 Budget Estimate 2022-2023 Source Actual Year-to-Date 2022-2023 2021-2022 Special Revenue and Debt Service Funds $ 3,713,591 265,257 1,326,283 51,464 $ 5,356,595 9,704,789 2,867,697 46,193 $ $ $ 12,618,679 5,599,296 716,028 0 294,297 9,809 47,248 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 5,326,610 Total Neighborhood Protection 10,458,173 3,321,993 9,883 13,790,049 $ $ $ $ $ $ 1,067,382 36,113,802 3,380,997 3,722,581 265,899 1,329,494 8,636 $ $ 39,494,799 5,363,144 696,532 0 304,541 1,265 44,563 33,490,615 2,391,688 11,960,435 292,000 $ 20,432,283 1,459,449 7,297,244 350,354 $ 18,844,259 1,346,019 6,730,093 249,498 48,134,738 29,539,330 27,169,869 92,559,251 28,948,147 119,000 56,844,679 17,891,849 283,902 53,114,318 16,922,754 81,880 121,626,398 75,020,430 70,118,952 Parks and Preserves 48,789,684 32,166,946 27,551,822 Golf Courses: Fees Coffee Shops Concessions Interest Other 6,142,000 0 2,907,000 7,000 505,976 3,297,627 0 1,739,242 49,887 290,998 3,044,079 0 1,583,521 7,926 284,531 Public Safety Enhancement & Expansion: Police Fire Interest/Other Total Public Safety Enhancement & Expansion 1,046,901 Total Golf Courses 9,561,976 5,377,754 4,920,057 36,198,956 2,795,687 Transit 2000 & 2050: Sales Taxes Interest/Other 326,454,730 38,156,549 198,930,943 21,687,947 183,705,433 13,439,863 38,994,643 159,850 $ 0 6,452,742 $ 6,133,292 651,008 $ 679,073 2,613,045 155,886 $ $ 2,172,543 21,171 2,768,931 $ 2,193,714 364,611,279 220,618,890 197,145,296 Court Awards Total Transit 2000 & 2050 4,532,715 (500,273) 2,398,456 Planning and Development 81,725,100 65,131,896 57,478,730 Capital Construction 6,299,234 3,825,659 3,849,788 Sports Facilities: Sales Taxes Interest/Other 24,576,788 3,877,936 14,136,324 1,469,984 12,318,016 924,229 28,454,724 15,606,308 13,242,245 Total Sports Facilities 27 Citywide Operating Revenue by Source (continued) For the Month Ended JANUARY 31 2023 2022 Budget Estimate 2022-2023 Actual Year-to-Date 2022-2023 2021-2022 154,499,000 500,000 0 86,762,103 1,492,719 50,960 89,018,942 278,514 276,300 Total Highway User Revenue 154,999,000 88,305,782 89,573,756 Local Transportation Assistance 0 0 0 Source Special Revenue and Debt Service Funds (Cont'd) $ 13,121,269 311,224 11,194 14,094,440 44,797 50,000 13,443,687 14,189,237 - $ - Highway User Revenue: Highway User Revenue Interest Other 3,262,225 553,916 Regional Transit Revenues 45,671,569 22,199,646 2,735,958 1,518,958 1,384,604 Community Reinvestment 6,045,200 3,083,128 2,989,216 1,741,292 (2,874) Other Restricted Fees 48,378,624 14,701,563 5,718,103 5,540,493 124,466,359 27,004,331 2,579,740 62,042,131 6,012,495 3,185,523 58,588,048 10,361,933 157,011,183 70,634,366 72,135,504 76,011,213 96,561,074 54,728,038 387,015,508 20,457,246 (30,360,299) (5,942,962) 8,495,308 23,790,382 32,848,202 (938,652) 24,117,810 Total Other 614,315,833 (7,350,707) 79,817,742 Total Grants 771,327,016 63,283,659 151,953,246 124,847,420 4,130,117 71,344,854 183,494 68,220,873 1,762,744 128,977,537 71,528,348 69,983,617 1,869,134,794 709,889,066 726,829,111 98,741,306 304,230,075 2,390,000 94,827,511 3,082,175 3,914,572 1,330,000 62,835,919 207,828,848 4,735,921 (18,773,577) 2,018,780 2,062,947 1,833,975 57,591,057 170,509,347 833,573 26,205,658 1,736,263 2,045,091 412,040 508,515,639 262,542,813 259,333,029 472,011 8,295,861 472,746 395,863 7,632,812 853,913 9,240,618 8,882,588 5,080,561 132,282 13,598 4,174,700 4,543,899 11,972,175 22,144 4,963,616 9,401,141 21,501,834 18,641,759 30,384,422 6,160,244 0 6,815,654 0 6,160,244 6,815,654 118,937,447 126,852,385 Grants: Public Housing: Rentals Grants Other $ Total Public Housing Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond/Secondary Property Tax Secondary Property Tax Interest Total G.O. Bond/Secondary Property Tax Total Special Revenue and Debt Service Funds Enterprise Funds AVIATION: 9,143,165 34,779,136 946,583 392,355 276,955 312,113 377,489 8,673,896 22,484,194 84,460 25,561,139 244,345 282,686 59,912 46,227,796 57,390,632 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge Total Aviation 28 Citywide Operating Revenue by Source (continued) For the Month Ended JANUARY 31 2023 2022 Budget Estimate 2022-2023 Source Actual Year-to-Date 2022-2023 2021-2022 Enterprise Funds (Cont'd) CONVENTION CENTER: $ 8,528,958 1,855,584 210,397 8,049,458 2,298,805 19,289 10,594,939 10,367,552 24,246,192 232,589 427,752 1,119,558 991,500 755,670 642,832 26,169,750 240,624 497,669 463,865 553,599 112,846 863,632 28,416,093 28,901,985 Excise Taxes Operating Revenue Interest Total Convention Center 73,883,063 17,349,462 453,000 46,328,232 14,539,428 952,979 39,883,812 9,271,731 128,992 91,685,525 61,820,639 49,284,535 495,373,898 3,000,000 5,461,000 9,119,120 6,200,000 6,953,000 (838,421) 283,879,609 1,626,923 5,062,197 5,589,468 4,491,900 3,764,726 6,090,894 277,673,402 1,615,928 9,121,496 4,536,310 3,751,560 768,932 (2,185,396) 525,268,597 310,505,717 295,282,232 WATER SYSTEM: $ Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System WASTEWATER: 17,347,503 1,698,573 948,360 706,313 5,426,823 17,422,547 2,019,711 520,350 138,839 2,115,916 Sewer Service Charges Multi-City Development Fees Interest Other 216,761,657 17,370,062 7,000,000 3,953,000 23,805,606 118,451,708 10,838,215 4,252,980 3,535,178 16,258,850 123,024,796 12,983,300 3,597,510 1,017,377 16,935,673 26,127,572 22,217,363 Total Wastewater 268,890,325 153,336,931 157,558,656 15,090,918 896,922 124,101 935,782 14,613,871 789,946 19,912 1,954,318 174,865,017 13,285,000 170,000 8,348,370 103,368,603 7,869,693 619,126 6,471,414 100,194,715 7,882,763 125,158 8,050,355 196,668,387 118,328,836 116,252,991 1,591,028,473 906,534,936 877,711,443 SOLID WASTE: $ 17,047,723 17,378,047 128,414,123 136,255,579 391,574,122 $ 403,661,545 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ 29 5,049,646,562 $ 2,599,704,665 $ 2,490,252,992 Citywide Operating Expenditures by Program For the Month Ended JANUARY 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 $ 177,707 $ 365,048 762,798 4,709,364 79,834 263,226 217,426 1,913,665 214,927 545,879 1,379,825 224,369 (33,882) 348,099 2,615,570 (1,333,442) 155,301 321,122 417,857 1,976,565 67,256 212,323 223,764 1,977,597 295,579 278,201 1,311,138 273,184 11,305 305,507 1,807,961 198,256 12,450,413 9,832,916 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 $ 1,339,511 2,728,060 5,272,859 47,661,467 851,427 2,192,298 1,708,178 17,090,256 2,039,779 3,497,667 34,173,154 1,840,334 37,992 3,147,627 20,932,319 2,222,066 $ 1,314,340 2,588,424 4,275,392 34,436,468 853,261 1,853,000 1,919,322 15,635,721 1,883,409 3,033,630 13,420,207 1,559,271 84,718 2,728,450 16,305,067 1,739,547 $ 1,339,511 2,728,060 5,272,859 41,264,811 851,427 2,192,298 1,708,178 17,090,256 2,039,779 3,497,667 33,834,053 1,840,334 37,992 3,147,627 14,711,867 2,222,066 6,396,656 339,101 6,220,452 - 245,462,707 146,734,994 103,630,226 133,778,784 12,956,209 45,627,473 5,821,708 24,734,478 2,854,614 22,947,870 3,077,318 21,776,182 2,854,614 2,958,296 - 51,449,181 27,589,093 26,025,188 24,630,797 2,958,296 851,356,532 497,172,879 - 511,640,850 290,710,778 - 443,177,513 271,805,055 79,759 510,727,803 289,960,724 - 913,047 750,054 - 1,348,529,411 802,351,627 715,062,326 800,688,527 1,663,101 Criminal Justice 3,236,080 473,084 2,848,067 428,426 3,709,165 3,276,493 Municipal Court Public Defender Total Criminal Justice Public Safety 68,667,849 37,138,187 (289) 54,652,467 34,835,083 (403,453) 105,805,747 89,084,097 Police Fire Other Total Public Safety -30- Citywide Operating Expenditures by Program (continued) For the Month Ended JANUARY 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 Transportation $ 8,828,635 785,627 33,175,759 4,494,925 47,284,946 $ 6,476,410 599,745 32,840,979 5,007,104 Street Transportation Street Lighting Aviation Public Transit 44,924,239 Total Transportation $ 122,011,150 9,224,160 407,090,969 293,260,282 $ 70,154,276 6,238,418 228,457,369 263,724,492 $ 63,309,248 5,904,746 281,196,130 236,410,320 $ 65,198,829 6,238,418 170,346,321 263,724,492 4,955,447 58,111,048 - 831,586,561 568,574,555 586,820,444 505,508,060 63,066,495 Community Development 6,376,705 11,377,038 1,062,762 2,160,492 5,500,616 8,978,610 812,006 2,594,800 Planning and Development Housing Economic Development Neighborhood Services Department 90,299,394 123,746,419 24,460,571 68,067,495 47,183,544 69,005,900 13,902,104 21,532,690 42,706,336 59,689,045 8,210,544 17,355,909 47,183,544 68,963,522 10,677,039 21,532,690 42,378 3,225,065 - 20,976,997 17,886,032 Total Community Development 306,573,879 151,624,238 127,961,834 148,356,796 3,267,442 137,396,866 49,254,411 69,897,540 13,127,552 195,722,335 6,521,208 7,091,626 74,994,961 29,139,569 46,649,472 7,657,408 126,455,757 5,464,428 3,945,686 68,438,965 26,706,083 43,513,739 7,412,953 109,121,593 4,191,106 2,724,613 74,730,418 29,139,569 36,461,130 126,400,743 5,464,428 3,945,686 264,543 10,188,343 7,657,408 55,014 - 479,011,538 294,307,281 262,109,053 276,141,973 18,165,307 Community Enrichment 9,363,418 2,725,885 5,495,290 1,093,813 12,593,332 81,588 402,684 8,270,686 2,478,164 4,309,742 1,058,890 12,553,048 107,349 271,349 31,756,010 29,049,230 Parks and Recreation Library Convention Center Sports and Cultural Facilities Human Services Public Parking Facilities Other Total Community Enrichment -31- Citywide Operating Expenditures by Program (continued) For the Month Ended JANUARY 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 $ 33,722,538 17,743,636 14,202,459 3,204,830 330,845 89,199 $ 22,973,348 15,605,198 14,858,829 2,125,969 132,864 70,844 Water System Wastewater Solid Waste Management Public Works Environmental Programs Manager's Office of Sustainability 69,293,506 55,767,054 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 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 78,875 1,732,993 1,003,266 2,129 26,786 10,903,701 10,951,637 27,609,981 25,988,676 7,268,304 $ 415,010,163 201,009,119 179,991,778 51,923,026 4,226,968 1,036,338 $ 247,411,217 116,986,185 100,514,732 22,928,631 2,846,219 564,996 $ 221,535,606 109,749,836 110,159,609 20,881,063 1,155,734 592,584 $ 162,921,727 74,437,026 92,012,590 15,846,609 2,846,219 564,996 84,489,490 42,549,159 8,502,142 7,082,022 - 853,197,392 491,251,980 464,074,432 348,629,166 142,622,813 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 42,539,364 9,957,982 1,243,987 5,545,165 559,073 1,978,241 193,521 7,569,136 7,524,093 143,019 21,230,713 11,305,287 634,335 1,772,427 350,000 29,937,768 10,626,805 36,917 187,500 11,818,052 2,004,479 424,535 4,689,317 315,306 1,654,118 1,297,626 8,823,081 4,203,717 381,777 11,742,990 6,227,676 2,536,106 634,335 14 552,125 12,130,951 7,022,861 14,904 187,500 42,539,364 9,957,982 1,243,987 5,545,165 559,073 1,978,241 193,521 7,569,136 7,524,093 143,019 21,230,713 11,305,287 634,335 1,368,385 350,000 29,937,768 10,626,805 36,917 187,500 404,042 - Total Debt Service 198,070,331 153,335,332 76,661,470 152,931,290 404,042 Capital Improvement 1,389,224,070 210,582,421 269,785,086 210,582,421 - General Obligation Debt Service $ 329,790,465 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 American Rescue Plan Act 108,447,955 - - Vacancy Savings (20,000,000) - - Contingencies 294,028,676 186,288,000 - 5,977,841,025 2,846,351,520 -32- 25,569,699 2,657,699,759 - - - - 2,601,247,815 245,103,705 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 $ 11,670,942 10,668,234 1,289,818 6,480,517 2,832,787 2,345,014 284,209 382,525 48,210,215 19,282,324 1,789,861 12,453,597 1,007,211 25,334,174 53,195,943 $ 320,744 6,901,549 3,726,786 2,244,635 4,313,675 4,326,949 33,859 813,062 6,639,560 176,461 11,314,206 177,937,388 378,445 84,609,384 - $ 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 $ 11,670,942 8,926,984 505,131 4,842,026 2,832,787 2,345,014 284,209 382,525 19,142,958 1,789,861 304,113 25,334,174 51,416,528 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 $ 1,741,250 784,687 1,638,491 48,210,215 139,366 12,453,597 703,098 1,779,415 $ 1,547,308,145 $ 197,227,373 $ 303,736,705 927,905,167 $ 129,777,253 619,402,978 $ 67,450,121 $ $ $ 567,087,818 169,543,000 28,946,616 507,203,480 389,928,515 1,662,709,429 $ $ 25,387,164 138,964,936 15,099,561 56,005,105 49,207,009 284,663,775 $ 3,210,017,574 $ 481,891,148 $ $ $ 59,834,767 70,032,376 2,701,748 127,158,256 95,489,185 355,216,332 $ 658,953,037 $ 1,389,224,070 - 33 - $ 188,456,320 10,943,000 18,447,037 86,081,878 157,390,668 461,318,903 $ $ 15,967,777 1,467,186 7,983,888 20,308,253 35,078,066 80,805,169 $ $ 210,582,421 $ $ $ 378,631,498 158,600,000 10,499,579 421,121,602 232,537,847 1,201,390,526 $ 1,820,793,504 902,484 40,849,934 28,783,108 4,700,000 32,715,100 105,151,681 16,930,185 25,086,812 8,993,571 6,861,295 155,012,386 91,267,064 13,748,139 8,528,049 6,778,992 490,644,428 6,001,000 307,126,546 $ 1,350,080,772 $ $ 9,419,387 137,497,750 7,115,673 35,696,852 14,128,943 203,858,606 $ 541,700,654 30,578,064 13,847,055 451,198,375 340,721,506 1,378,045,654 $ 271,308,726 $ 2,728,126,426 Bonds Authorized and Sold As of JANUARY 31 (dollars in thousands) Authorized Sold Available 1988 Authorizations General Obligation Bonds Freeway Mitigation, Neighborhood Stabilization, and Slum and Blight Elimination Bonds Fully Issued $ 29,285 884,175 Total General Obligation Bonds 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 Revenue Bonds Bonds Fully Issued Total 1988 Authorizations $ 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 $ 2,689,750 - 34 - $ 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 FY 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 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 - Feb YTD thru January 270,133 288,757 314,998 382,904 404,639 360,109 Mar Feb 38,579 33,570 32,672 42,535 42,222 Apr May June Mar 39,641 61,093 63,749 44,740 59,949 Apr 46,770 29,662 40,758 54,758 49,268 May 27,146 35,239 40,197 72,938 50,292 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 FY 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 Dec Jan Feb Mar Oct 10,922 14,226 18,038 18,259 18,918 18,170 Nov 15,747 16,443 13,095 15,097 17,357 17,855 Dec 14,902 12,120 19,640 23,860 22,501 20,854 Jan 12,154 17,440 19,033 22,364 20,469 20,992 YTD thru January 98,786 106,768 120,323 140,528 145,668 137,918 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 - Apr May June Feb 15,369 17,707 10,831 12,163 16,580 Mar 13,689 12,285 15,878 18,738 17,917 Apr 14,284 18,557 23,414 25,105 24,058 May 14,640 11,288 17,998 15,952 17,706 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 FY 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 9,422 10,791 10,098 10,453 10,826 11,323 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 YTD thru January 43,874 45,576 49,790 47,798 47,937 51,955 Feb 5,490 6,528 5,568 5,828 6,504 Mar 5,943 5,960 6,411 6,418 6,870 Apr 5,668 5,110 7,162 8,075 7,226 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 - May 5,959 4,699 6,472 6,061 6,442 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 550,000 500,000 2019-20 Actuals 450,000 2020-21 Actuals 400,000 2021-22 Actuals 350,000 2022-23 Actuals 300,000 22-23 Budget 250,000 200,000 150,000 100,000 50,000 - FY 18-19 19-20 20-21 21-22 22-23 22-23 Budget July Aug July 131,124 100,481 68,761 123,174 79,979 127,517 Aug 168,019 187,393 217,048 225,569 274,628 247,347 Sept Sept 152,605 194,506 260,275 185,901 211,185 247,626 Oct Oct 198,474 175,883 215,731 231,638 288,507 257,060 Nov Nov 247,632 269,127 298,362 324,875 300,162 354,869 Dec Dec 221,971 226,582 236,818 253,979 275,549 293,929 Jan Jan 170,844 209,806 216,626 267,406 263,160 270,465 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 - Feb Mar YTD thru January 1,290,669 1,363,778 1,513,621 1,612,542 1,693,170 1,798,813 Apr May June Feb 173,462 187,061 178,738 199,258 232,309 Mar 187,169 217,521 272,444 230,537 284,334 Apr 210,659 180,484 316,241 255,574 304,518 May 245,256 226,625 277,929 320,064 335,291 June 280,540 378,887 362,173 540,197 503,355 Aviation Revenues (Dollars in Thousands) Aviation Operating Revenues 170,000 160,000 150,000 140,000 130,000 120,000 110,000 100,000 90,000 80,000 70,000 60,000 50,000 40,000 30,000 20,000 10,000 - 18-19 Actuals 19-20 Actuals 20-21 Actuals 21-22 Actuals 22-23 Actuals 22-23 Budget July FY 18-19 19-20 20-21 21-22 22-23 22-23 Budget Aug Sept Oct Nov Dec Jan Feb July 31,468 30,489 25,387 36,735 12,023 36,632 Aug 32,105 32,307 2,666 33,945 37,402 29,825 Sept 31,728 32,953 27,193 28,302 34,042 35,480 Oct 31,719 32,056 21,045 31,904 41,419 34,461 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 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 - Mar YTD thru January 221,033 232,421 149,866 259,333 262,543 254,684 Apr Feb 32,944 34,215 61,877 33,583 48,011 May Mar 33,075 34,228 25,487 38,417 38,737 June Apr 37,847 27,255 31,454 40,080 40,340 May 34,396 23,524 30,668 46,367 39,843 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 FY 18-19 19-20 20-21 21-22 22-23 22-23 Budget Aug Sept Oct Nov Dec Jan Feb Mar 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 YTD thru January 255,575 281,949 315,115 295,282 310,506 327,454 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 - Apr May June Feb 21,558 25,643 25,188 28,035 28,647 Mar 20,138 24,861 28,415 31,242 29,854 Apr 31,150 29,080 37,714 40,702 39,550 May 36,293 40,442 42,556 45,193 46,921 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 FY 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 Jan Feb Mar Apr May June Nov 19,734 21,142 18,577 21,720 25,044 21,456 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 YTD thru January 144,855 149,408 149,542 157,559 153,337 158,953 Feb 19,436 20,973 24,355 21,916 22,911 Mar 19,960 21,613 21,754 23,023 22,824 Apr 21,256 18,428 21,584 24,091 22,562 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 - May 20,980 23,948 20,085 22,296 23,077 June 16,544 18,289 17,424 17,973 18,563