June 2022 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division June 30, 2022 To the Mayor and City Council: This is the City's Financial Report for June, the 12th month of fiscal year 2021-22. 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, September 23, 2022 INDEPENDENT AUDITOR REPORT To the Chief Financial Officer, We have assessed the Finance Department’s (Finance) June 2022 Monthly Financial Report (MFR) in accordance with the agreed-upon procedures engagement between Finance and the City Auditor Department (Audit). The City Charter requires Finance to prepare 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 March 18, 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 2022 Table of Contents Expenditures by Programs Page Performance Status General Fund Total Expenditures 1 Better than Expected General Government 1 Better than Expected Criminal Justice 2 Better than Expected General Fund Expenditures Public Safety 2 Expected Transportation 3 Better than Expected Community Development 3 Better than Expected Community Enrichment 4 Better than Expected Environmental Services 4 Better than Expected Citywide Total Operating Expenditures 5 Better than Expected General Government 5 Expected Criminal Justice 6 Better than Expected Citywide Expenditures Public Safety 6 Better than Expected 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 Expected 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 Revenues by Source 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 State Sales Tax 16 Better than Expected Vehicle License Tax 17 Expected Governmental Funds 18 Monitor and Consider Taking Action Aviation 19 Better than Expected Water System 20 Expected Wastewater 21 Better than Expected Financial Schedules General Fund Revenue Page 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. Report Navigation Click on the performance status next to a report to be taken directly to that page. From any page of the report, click on the City of Phoenix Bird Emblem to return to the Table of Contents. 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. June General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Total General Fund Expenditures 17-18 18-19 19-20 20-21 21-22 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 1,177,278 1,177,280 100.0% 1,214,362 1,214,362 100.0% 1,282,831 1,282,831 100.0% 1,371,151 1,371,151 100.0% 1,470,251 1,508,504 97.5% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustment for contingencies. Better than Expected General Fund GeneralTotal Government $1,600,000 $1,300,000 $1,400,000 $1,280,000 $1,200,000 $1,260,000 $1,240,000 $1,000,000 $1,220,000 $800,000 $1,200,000 $600,000 $1,180,000 $400,000 $1,160,000 $200,000 $1,140,000 $0 $1,120,000 June YTD June YTD Expenditures Expenditures Annual Annual Expenditures * Expenditures * 17-18 17-18 18-19 19-20 18-19 20-21 19-20 21-22 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. The fiscal year 2021-22 budgeted general fund expenditures are 10.0% higher than the fiscal year 2020-21 actuals. Fiscal year 2021-22 actual general fund expenditures through June are 7.2% higher than the same period in fiscal year 2020-21. General fund expenditures increased 6.9% in fiscal year 2020-21 over fiscal year 2019-20. This followed increases of 5.6% and 3.1% in the two prior years. General Government 17-18 18-19 19-20 20-21 21-22 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 110,408 110,408 100.0% 114,393 114,393 100.0% 123,100 123,100 100.0% 154,211 154,211 100.0% 161,907 172,790 93.7% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal GeneralJustice Government $126,000 $124,000 $200,000 $122,000 $180,000 $120,000 $160,000 $118,000 $140,000 $116,000 $120,000 $114,000 $100,000 $112,000 $80,000 $110,000 $60,000 $108,000 $40,000 $106,000 $20,000 $104,000 $0 June YTD Expenditures June YTD Expenditures Annual Expenditures * Annual Expenditures * 17-18 18-19 18-19 17-18 19-20 19-20 20-21 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. The fiscal year 2021-22 budget includes a 12.0% increase over fiscal year 2020-21 actuals. General fund general government expenditures through June are 5.0% higher than the same period in the prior fiscal year. General fund general government expenditures increased 25.3% in fiscal year 2020-21 over fiscal year 2019-20. This followed increases of 7.6% and 3.6% in the prior two years. 1 June General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Criminal Justice 17-18 18-19 19-20 20-21 21-22 Criminal Justice June YTD Annual % of Annual Expenditures Expenditures * Expenditures 32,232 32,232 100.0% 33,387 33,387 100.0% 35,033 35,033 100.0% 36,162 36,162 100.0% 40,008 41,438 96.5% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $45,000 $40,000 $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $5,000 $0 June YTD Expenditures Annual Expenditures * 17-18 18-19 19-20 20-21 21-22 Criminal justice expenditures include costs for municipal courts and public defenders. The fiscal year 2021-22 budget includes a 14.6% increase over fiscal year 2020-21 actuals. General fund criminal justice expenditures through June are 10.6% higher than the same period in the prior fiscal year. General fund criminal justice expenditures increased 3.2% in the fiscal year 2020-21 over fiscal year 2019-20. This followed increases of 4.9% and 3.6% in the prior two years. Public Safety 17-18 18-19 19-20 20-21 21-22 Public Safety June YTD Annual % of Annual Expenditures Expenditures * Expenditures 817,960 817,960 100.0% 841,467 841,467 100.0% 893,403 893,403 100.0% 925,920 925,920 100.0% 992,648 999,730 99.3% * - For prior years-total actual expenditures, for current year-total approved budget $1,200,000 $1,000,000 June YTD Expenditures $800,000 $600,000 $400,000 Annual Expenditures * $200,000 $0 17-18 18-19 19-20 20-21 21-22 Expected Public safety expenditures include costs for police and fire services. The general fund public safety fiscal year 2021-22 budget includes an 8.0% increase over fiscal year 2020-21 actuals. Through June, general fund public safety expenditures are 7.2% higher than the prior fiscal year. General fund public safety expenditures increased 3.6% over fiscal year 2020-21 over the fiscal year 2019-20. This followed increases of 6.2% and 2.9% in the prior two years. 2 June General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Transportation 17-18 18-19 19-20 20-21 21-22 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 16,366 16,366 100.0% 18,337 18,337 100.0% 19,748 19,748 100.0% 22,144 22,144 100.0% 23,166 25,006 92.6% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected CommunityTransportation Development $1 $30,000 $1 Series1 $1 $20,000 June YTD Expenditures $1 $0 $10,000 $0 Series2 Annual Expenditures * $0 $0 17-18 18-19 19-20 20-21 21-22 Transportation expenditures include costs for public transit and street maintenance and repair. General Fund transportation expenditures for fiscal year 2021-22 are budgeted to increase 12.9% over fiscal year 2020-21 actuals. 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. Through June, General fund transportation expenditures are 4.6% higher than the same period in the prior fiscal year. Community Development 17-18 18-19 19-20 20-21 21-22 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 20,243 20,243 100.0% 21,238 21,238 100.0% 22,542 22,542 100.0% 24,114 24,114 100.0% 28,225 32,015 88.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Community Development $35,000 $30,000 June YTD Expenditures $25,000 $20,000 $15,000 $10,000 Annual Expenditures * $5,000 $0 17-18 18-19 19-20 20-21 21-22 Community development expenditures include costs for economic development and neighborhood services. The fiscal year 2021-22 budget includes a 32.8% increase over fiscal year 2020-21 actuals. General fund community development expenditures through June are 17.0% higher than the same period in the prior fiscal year. General fund community development expenditures increased in fiscal year 2020-21 over fiscal year 2019-20 by 7.0%. This follows a year over year increase of 6.1% in fiscal year 2019-20 and 4.9% increase in the 2018-19 fiscal year. 3 June General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Community Enrichment 17-18 18-19 19-20 20-21 21-22 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 156,325 156,325 100.0% 156,552 156,552 100.0% 155,417 155,417 100.0% 158,589 158,589 100.0% 173,631 182,964 94.9% * - For prior years-total actual expenditures, for current year-total approved budget Community Enrichment $200,000 June YTD Expenditures $160,000 $120,000 $80,000 Annual Expenditures * $40,000 $0 17-18 Better than Expected 18-19 19-20 20-21 21-22 Community enrichment expenditures include costs for parks, recreational activities, senior centers and community centers. The fiscal year 2021-22 budget includes a 15.4% increase over fiscal year 2020-21 actuals. Through June, general fund community enrichment expenditures are 9.5% higher than the same period in the prior fiscal year. General fund community enrichment expenditures increased 2.0% in fiscal year 2020-21 over fiscal year 2019-20. This followed a decrease of 0.7% and an increase of 0.1% in the prior two years. Environmental Services 17-18 18-19 19-20 20-21 21-22 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 12,624 12,624 100.0% 16,886 16,886 100.0% 19,180 19,180 100.0% 20,905 20,905 100.0% 26,508 27,932 94.9% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services $32,000 $28,000 $24,000 $20,000 $16,000 $12,000 $8,000 $4,000 $0 June YTD Expenditures Annual Expenditures * 17-18 Better than Expected 18-19 19-20 20-21 21-22 Environmental service expenditures include costs for maintaining and operating city facilities. The fiscal year 2021-22 budget includes a 33.6% increase from fiscal year 2020-21 actuals. Because environmental service expenditures are highly dependent on interdepartmental charges, they tend to be very volatile. Through June, general fund environmental services expenditures are 26.8% higher than the prior fiscal year. 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. June Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Total Citywide Operating 17-18 18-19 19-20 20-21 21-22 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 3,547,077 3,547,078 100.0% 3,775,464 3,775,464 100.0% 3,814,963 3,814,963 100.0% 4,163,122 4,163,122 100.0% 4,488,949 5,433,859 82.6% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustments for contingencies and use of the early redemption fund. Total Citywide $6,000,000 June YTD Expenditures $5,000,000 $4,000,000 $3,000,000 $2,000,000 Annual Expenditures * $1,000,000 $0 17-18 Better than Expected 18-19 19-20 20-21 21-22 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. Without contingencies and vacancy savings, the budget for fiscal year 2021-22 anticipates an increase of 30.5% over fiscal year 2020-21 actuals in total operating expenditures. Actual expenditures through June are 7.8% higher than the same period in the prior fiscal year stemming from an additional $304M in light rail extension and $70M in Aviation. General Government 17-18 18-19 19-20 20-21 21-22 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 134,117 134,117 100.0% 138,349 138,349 100.0% 157,200 157,200 100.0% 207,451 207,451 100.0% 238,925 238,879 100.0% * - For prior years-total actual expenditures, for current year-total approved budget Expected General Government $300,000 $250,000 June YTD Expenditures $200,000 $150,000 $100,000 Annual Expenditures * $50,000 $0 17-18 18-19 19-20 20-21 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. Citywide general government expenditures through June are 15.2% higher than the same period in the prior fiscal year. The budget anticipates an increase of 15.1% for fiscal year 2021-22 over fiscal year 2020-21 actuals. 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. Fiscal year 2020-21 expenditures can be higher due to receiving additional revenue through the Coronavirus relief funds. 5 June Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Criminal Justice 17-18 18-19 19-20 20-21 21-22 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 38,411 38,411 100.0% 42,530 42,530 100.0% 44,425 44,425 100.0% 44,147 44,147 100.0% 47,054 49,780 94.5% * - For prior years-total actual expenditures, for current year-total approved budget Criminal Justice $60,000 June YTD Expenditures $50,000 $40,000 $30,000 Annual Expenditures * $20,000 $10,000 $0 17-18 Better than Expected 18-19 19-20 20-21 21-22 Criminal Justice expenditures include costs of the Municipal Court and the Public Defender’s office. Citywide criminal justice expenditures are 6.6% higher through June than the same period in the prior fiscal year. The budgeted increase for fiscal year 2021-22 over fiscal year 2020-21 actuals is 12.8%. 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 17-18 18-19 19-20 20-21 21-22 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 970,771 970,771 100.0% 1,025,513 1,025,513 100.0% 1,110,457 1,110,457 100.0% 1,122,901 1,122,901 100.0% 1,228,901 1,252,522 98.1% * - For prior years-total actual expenditures, for current year-total approved budget Public Safety $1,400,000 $1,200,000 $1,000,000 $800,000 $600,000 $400,000 $200,000 $0 June YTD Expenditures Annual Expenditures * 17-18 18-19 19-20 20-21 21-22 Better than Expected Public Safety expenditures include costs of Police, Fire and Emergency Management. Citywide public safety expenditures through June are 9.4% higher than the same period in the prior fiscal year. The budgeted increase for fiscal year 2021-22 over fiscal year 2020-21 actuals is 11.5%. 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 June Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Transportation 17-18 18-19 19-20 20-21 21-22 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 709,977 709,977 100.0% 722,667 722,667 100.0% 774,492 774,492 100.0% 786,597 786,597 100.0% 797,084 853,687 93.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 June YTD Expenditures Annual Expenditures * 17-18 18-19 19-20 20-21 21-22 Transportation expenditures include costs for Street lighting, maintenance and repair, Aviation and Public Transit. Citywide transportation expenditures are 1.3% higher through June than the same period in the prior fiscal year. The budget anticipates an increase of 8.5% for fiscal year 2021-22 from fiscal year 2020-21 actuals. 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. Year to date includes a $70M Aviation liability paydown. Community Development 17-18 18-19 19-20 20-21 21-22 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 203,096 203,096 100.0% 195,716 195,716 100.0% 229,793 229,793 100.0% 245,310 245,310 100.0% 227,960 296,697 76.8% * - 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 June YTD Expenditures Annual Expenditures * 17-18 Better than Expected 18-19 19-20 20-21 21-22 Community Development expenditures include costs for Neighborhood Services, Housing, Planning and Economic Development. Citywide community development expenditures through June are 7.1% lower than the same period in the prior fiscal year. The fiscal year 2021-22 budget includes an increase of 20.9% over fiscal year 2020-21 actuals. 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. Fiscal year 2020-21 expenditures can be higher due to receiving additional revenue through the Coronavirus relief funds. 7 June Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Community Enrichment 17-18 18-19 19-20 20-21 21-22 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 306,763 306,763 100.0% 317,465 317,465 100.0% 316,680 316,680 100.0% 390,805 390,805 100.0% 420,501 477,382 88.1% * - For prior years-total actual expenditures, for current year-total approved budget Community Enrichment $600,000 June YTD Expenditures $500,000 $400,000 $300,000 Annual Expenditures * $200,000 $100,000 $0 17-18 18-19 19-20 20-21 21-22 Better than Expected Community Enrichment expenditures include costs for Parks, Libraries, the Convention Center, Senior Centers and Community Centers. Citywide community enrichment expenditures through June are 7.6% higher than the same period in the prior fiscal year. The fiscal year 2021-22 budget anticipates an increase of 22.2% from fiscal year 2020-21 actuals. 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. Fiscal year 2020-21 expenditures can be higher due to receiving additional revenue through the Coronavirus relief funds. Environmental Services 17-18 18-19 19-20 20-21 21-22 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 696,244 696,244 100.0% 670,219 670,219 100.0% 692,524 692,524 100.0% 734,733 734,733 100.0% 752,386 812,782 92.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 June YTD Expenditures Annual Expenditures * 17-18 18-19 19-20 20-21 21-22 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 expenditures are 2.4% higher through June than the same period in the prior fiscal year. The fiscal year 2021-22 budget anticipates an increase of 10.6% from fiscal year 2020-21 actuals. 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 June Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 General Obligation Debt Service Citywide Debt Service Expenditures 17-18 18-19 19-20 20-21 21-22 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 106,315 106,315 100.0% 116,634 116,634 100.0% 130,839 130,839 100.0% 131,938 131,938 100.0% 131,081 132,070 99.3% * - For prior years-total actual expenditures, for current year-total approved budget net of credit for early redemption fund resources $180,000 June YTD Expenditures $120,000 Annual Expenditures * $60,000 $0 17-18 18-19 19-20 20-21 21-22 Expected General obligation debt service expenditures through June are 0.6% lower than the same period in the prior fiscal year. Budgeted expenditures for fiscal year 2021-22 are 0.1% higher than fiscal year 2020-21 actual expenditures for 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. -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) General Gov't 17-18 18-19 $ 290,772 $ 384,131 Refer to detailed financial schedules pages 22 - 34 19-20 $ 20-21 500,745 21-22 (Budget) 21-22 (YTD) $ $ 525,852 $ 684,798 Discussion: 1,082,356 General Gov't Major projects in fiscal year 2017-18 include street construction and maintenance ($66 million), parks and recreation facility improvements ($25 million), conversion of streetlights to LED ($28 million) and replacement of the City telephone system ($22 million). 21-22 (YTD) 21-22 (Budget) 20-21 19-20 Major projects in fiscal year 2018-19 include street and sidewalk maintenance ($134.8 million), light rail ($47.9 million), transit bus and vehicle purchases ($43.1 million), major streets ($33.2 million), parks and preserves improvements ($20.8 million), and telephone system network replacement ($10.4 million) . 18-19 17-18 $0 $500,000 $1,000,000 21-22 (Budget) 21-22 (YTD) $ $ 115,395 $1,500,000 Major projects in fiscal year 2019-20 include pavement maintenance ($131 million), Light Rail ($100 million), Talking Stick Arena Renovations ($57 million), parks preserve development, community centers, and development ($47 million), bus and vehicle purchases ($45 million), and major streets ($18 million). Major projects in fiscal year 2020-21 include ($115M) South Central Light Rail, ($96M) Talking Stick Arena renovations, ($69M) Northwest Light Rail extension, and ($32M) replace fare collection system. Major projects budgeted for fiscal year 2021-22 include South Central Light Rail ($90M), North West Light Rail ($70M), South Central land acquisition ($45M), North Black Canyon area roadway and drainage infrastructure ($39M). Aviation 17-18 18-19 $ 582,921 $ 552,972 19-20 $ 254,523 20-21 $ 172,418 430,069 Discussion: Aviation Major projects in fiscal year 2017-18 include the PHX Sky Train extension ($423 million), Apron and Taxiway improvements ($26 million), and Terminal 4 improvements including the South 1 concourse ($20 million). 21-22 (YTD) 21-22 (Budget) Major projects in fiscal year 2018-19 include PHX Sky Train stage 2 ($267.8 million) and Terminal 4 South 1 concourse ($127.8 million). 20-21 Major projects in fiscal year 2019-20 include PHX Terminal 4 South concourse and gates ($90M), Runway, Apron and Taxiway Improvements ($47M), and PHX Sky Train ($10M). Major projects in fiscal year 2020-21 include ($51M) Terminal 4 concourse, ($24M) Terminal 4 Apron Concrete construction, ($19M) garage demolition, and ($13M) 24th St parking lot 19-20 18-19 17-18 $0 $200,000 $400,000 $600,000 Major projects budgeted for fiscal year 2021-22 include Union Pacific Railroad grade (trench) separation project ($64.5M), Airport Development Plant Contingency ($60.9M), New Crossfield Taxi ($34.0M), Terminal 4 South Concourse ($22.2M). - 10 - Capital Expenditures (Dollars in Thousands) Phx Convention Ctr 17-18 18-19 $ 28,898 $ 36,542 Refer to detailed financial schedules pages 22 - 34 19-20 $ 52,148 20-21 21-22 (Budget) 21-22 (YTD) $ 31,640 $ 109,475 $ 84,751 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. FY2021-22 includes the $47M purchase of 100 W. Washington Street. 21-22 (YTD) 21-22 (Budget) 20-21 19-20 18-19 17-18 $0 Solid Waste 17-18 18-19 $ 10,355 $ 7,857 19-20 $ 5,490 $20,000 21-22 (Budget) 20-21 $ 8,796 $ 41,067 $40,000 $60,000 $80,000 $100,000 $120,000 21-22 (YTD) $ 28,986 Discussion: Solid Waste In fiscal year 2017-18 Solid Waste spent $10.3 million on SR85 Landfill requirements. In fiscal year 2018-19 Solid Waste spent $4.5 million on North Gateway material recovery facility upgrade and $1.5 million on SR 85 Landfill. 21-22 (YTD) In fiscal year 2019-20 Solid Waste spent $3 million in transfer stations and $1 million at SR-85 and $1 million for Skunk Creek as monitoring and maintenance. In fiscal year 2020-21 Solid Waste spent $4.5M on Excavate and line Cell 2 at the State Route 85 Landfill, $1.2M Dixaleta payment replacement at self-haul area, and $1.1M at the 27th Ave trommel machine. Major projects budgeted for fiscal year 2021-22 include $17M Material Recovery Facility retrofit, $2.5M general capital improvement and $2.0M capital improvement in the transfer station. 21-22 (Budget) 20-21 19-20 18-19 17-18 $0 $15,000 $30,000 $45,000 - 11 - Capital Expenditures (Dollars in Thousands) 17-18 Wastewater $ 105,912 Refer to detailed financial schedules pages 22 - 34 18-19 $ 97,890 19-20 $ 123,141 20-21 $ 77,339 21-22 (Budget) 21-22 (YTD) $ 248,807 $182,710 Discussion: In fiscal year 2017-18, Wastewater spent $54 million on pipeline assessment, repair, replacement and construction and $23 million on improvements at the 91st Avenue Wastewater Treatment Plant. Wastewater 21-22 (YTD) 21-22 (Budget) 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. 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 23rd Ave, $13.1 million Cave Creek, and $13.1 million In fiscal year 2020-21 Wastewater spent $12.4M 91st Ave plant equipment, $10.1M 23rd Ave Grit Basin Replacement, $6.9M citywide rehabilitate small diameter sewers, and $4.7M 23rd Ave equipment replacement. 20-21 19-20 18-19 17-18 $0 $100,000 $200,000 $300,000 Major projects budgeted in fiscal year 2021-22 include $38M Lift Station 77 mains, $21M Dixaleta Dobbins gravity sewer and $19M 91st Ave WWTP Solids Rehab. 17-18 Water System $ 229,256 18-19 $ 289,858 19-20 $ 252,146 20-21 21-22 (Budget) 21-22 (YTD) $ 434,000 $ 350,046 $205,485 Discussion: Water System 21-22 (YTD) In fiscal year 2017-18, Water spent $82 million to construct, replace or rehabilitate pipelines and valves, $36 million on groundwater well projects, $21 million on the Union Hills Water Treatment Plant rehabilitation and $17 million on water resiliency and storage. 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. 21-22 (Budget) 20-21 19-20 18-19 In fiscal year 2020-21 water spent $153M on water main from 24th Street treatment plant to 32nd St and Bell Road, $110.0M on water boosters, and $19.9M on transmission main rehabilitation. 17-18 $0 $100,000 $200,000 $300,000 $400,000 Major projects budgeted in fiscal year 2021-22 include $50M Dixaleta infrastructure, $36.8M Deer Valley WTP Rehabilitation, $21.5M Light Rail Water Relocation and $18.1M Southern Water Growth Projects. - 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,600,000 $1,400,000 June YTD Revenues $1,200,000 $1,000,000 $800,000 $600,000 $400,000 Annual Revenues* $200,000 $0 17-18 17-18 18-19 19-20 20-21 21-22 June YTD Revenues 1,162,635 1,220,768 1,307,357 1,491,537 1,508,526 18-19 Annual Revenues* 1,162,635 1,220,768 1,307,357 1,491,537 1,355,776 19-20 20-21 21-22 % of Annual Revenues 100.0% 100.0% 100.0% 100.0% 111.3% * - For prior years - total actual revenues, for current year - total approved budget Better than Expected Fiscal year 2021-22 general fund operating revenues are budgeted to decrease 9.1% over prior year actuals. Fiscal year 2020-21 includes $73M Coronavirus relief fund allocated to offset General Fund Public Safety costs. Actual revenues through June are 1.1% 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 123,936 240,000 210,000 95,435 101,652 107,555 115,069 119,289 180,000 Secondary 150,000 120,000 90,000 60,000 162,129 170,209 182,043 192,215 191,294 154,560 17-18 18-19 19-20 20-21 21-22 YTD 21-22 Budget Primary 30,000 - FY 17-18 18-19 19-20 20-21 21-22 YTD 21-22 Budget Total 249,995 263,781 277,764 297,112 316,151 310,583 July (1,054) (1,049) (1,141) (1,619) (1,490) (1,411) Aug (395) 688 1,081 1,541 1,141 1,226 Sept 891 980 647 1,288 1,040 1,080 Oct 16,220 12,601 11,579 21,550 24,048 16,935 Nov 87,691 91,331 106,458 89,520 103,048 106,400 Dec 25,018 30,444 23,612 38,512 33,534 34,281 Jan 10,162 13,302 14,875 15,608 18,086 16,215 Feb 7,020 5,422 7,447 6,612 6,889 7,214 Mar 8,086 8,130 8,185 9,456 8,972 9,544 Apr 11,994 12,026 12,116 15,171 15,063 14,559 May 52,962 68,870 66,043 76,862 71,096 78,427 June 31,400 21,036 26,862 22,611 34,724 26,112 Note: Monthly budget amount for 21-22 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 4.5% in fiscal year 2021-22 over fiscal year 2020-21 actuals. - 14 - Primary Secondary 154,560 95,435 162,129 101,652 170,209 107,555 182,043 115,069 192,215 123,936 191,294 119,289 Local Sales Tax Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Local Sales Tax Budget vs Actual 80,000 70,000 60,000 50,000 40,000 21-22 Actuals 30,000 21-22 Budget 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Better than Expected Fiscal year 2021-22 actual local sales tax revenues through June are 20.4% higher than budget expectations. Local Sales Tax 3 Year Trend 80,000 70,000 60,000 50,000 19-20 Actuals 40,000 20-21 Actuals 21-22 Actuals 30,000 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2021-22 local sales tax revenues were 17.8% higher than the prior year. This follows increases of 12.2% and 2.5% in the two previous years. Click Here for Additional Information - 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 21-22 Actuals 15,000 21-22 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 Fiscal year 2021-22 state sales tax revenues through June are 16.1% higher than budget expectations. State Sales Tax 3 Year Trend 30,000 25,000 20,000 19-20 Actuals 15,000 20-21 Actuals 21-22 Actuals 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2021-22 state sales tax revenues were 14.2% higher than the prior year. This follows increases of 17.1% and 4.2% in the two previous years. Click Here for Additional Information - 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 21-22 Actuals 6,000 21-22 Budget 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Expected Vehicle license tax revenues through June 2022 are 0.5% lower than budget expectations for the period. Vehicle License Tax 3 Year Trend 12,000 10,000 8,000 19-20 Actuals 6,000 20-21 Actuals 21-22 Actuals 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2021-22 vehicle license tax revenues were 1.3% lower than the prior year. This follows increases of 13.2% and 0.4% in the two previous years. Click Here for Additional Information - 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 21-22 Budget 400,000 300,000 2021-22 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 fund revenues through June 2022 are 5.7% lower than budget expectations for the period. Governmental Funds Revenues 3 Year Trend 600,000 500,000 400,000 2019-20 Actuals 300,000 2020-21 Actuals 200,000 2021-22 Actuals 100,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2021-22 governmental fund revenues were 8.1% higher than the prior year. This follows increases of 14.4% and 7.0% in the two previous years. Click Here for Additional Information - 18 - Aviation Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Aviation Operating Revenues Budget vs Actual 180,000 160,000 140,000 120,000 21-22 Actuals 100,000 80,000 21-22 Budget 60,000 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 through June 2022 are 39.0% higher than budget expectations for the period. Aviation Operating Revenues 3 Year Trend 200,000 150,000 19-20 Actuals 100,000 20-21 Actuals 21-22 Actuals 50,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2021-22 aviation revenues were 46.6% higher than the prior year. This follows an increase of 8.0% and decrease of 8.3% in the two previous years. Click Here for Additional Information - 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 21-22 Actuals 30,000 21-22 Budget 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Expected Water system revenues through June 2022 are 0.9% higher than budget expectations for the period. Water System Operating Revenues 3 Year Trend 70,000 60,000 50,000 40,000 19-20 Actuals 30,000 20-21 Actuals 20,000 21-22 Actuals 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May Fiscal year 2021-22 water system revenues were 0.0% higher than the prior year. This follows increases of 8.4% and 12.7% in the two previous years. Click Here for Additional Information - 20 - June 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 21-22 Budget 15,000 21-22 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 revenues through June 2022 are 4.8% higher than budget expectations for the period. Wastewater Operating Revenues 3 Year Trend 30,000 25,000 20,000 19-20 Actuals 15,000 20-21 Actuals 10,000 21-22 Actuals 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May Fiscal year 2021-22 wastewater revenues were 4.8% higher than the prior year. This follows increases of 0.8% and 4.0% in the two previous years. Click Here for Additional Information - 21 - June 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) Actual Year-to-Date 2021-2022 2020-2021 Budget Estimate 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 $ 547,397 2,800 $ 659,161 $ 3,467 559,462 2,915 197,945 219,316 79,100 191,294 2,771 9,600 229,901 213,294 78,695 192,215 3,022 8,982 201,292 240,237 79,768 182,043 2,694 9,424 8,956 1,451 13,108 483 4,093 1,497 6,463 8,109 880 13,842 434 5,141 1,904 4,510 9,171 1,288 82,734 118 3,670 1,725 5,867 33,500 1,500 16,599 5,550 12,355 46,487 1,297 17,769 3,902 15,514 34,101 1,465 55,042 5,012 13,507 1,355,776 - 22 - $ 1,508,524 $ 1,491,536 General Fund Expenditures As of JUNE 30 (dollars in thousands) Budget Estimate 2021-2022 Actual Year-to-Date 2021-2022 2020-2021 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,323 5,577 8,111 61,279 3,429 2,875 23,864 3,174 7,475 19,275 4,311 29,715 1,384 172,790 $ 2,200 $ 4,782 6,143 63,049 3,360 2,789 24,643 2,743 4,331 20,630 4,008 21,798 1,431 161,907 2,006 4,162 7,940 55,785 2,713 2,345 23,940 2,655 5,519 15,194 3,597 26,976 1,379 154,211 Criminal Justice Municipal Court Public Defender Total Criminal Justice 34,224 7,214 41,438 32,433 7,575 40,008 31,102 5,060 36,162 Public Safety Police Fire Others Total Public Safety 611,239 388,358 133 999,730 610,288 382,352 8 992,648 574,044 351,833 43 925,920 Transportation Street Transportation Public Transit Total Transportation 23,169 1,838 25,007 22,399 767 23,166 18,596 3,548 22,144 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 9,555 15,515 5,173 1,772 32,015 7,680 14,553 4,414 1,578 28,225 5,820 13,478 4,238 578 24,114 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 108,229 43,865 22,051 8,819 182,964 103,306 41,683 21,708 6,934 173,631 93,833 38,838 20,030 5,888 158,589 Environmental Services Public Works Environmental Programs Others Total Environmental Services 26,178 1,280 474 27,932 24,931 1,112 465 26,508 19,739 726 440 20,905 Capital Improvement 26,627 24,158 29,106 Vacancy Savings (11,000) - - Contingencies 124,164 - - Total Expenditures and Encumbrances $ 1,621,668 - 23 - $ 1,470,251 $ 1,371,151 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 $ 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 Actual Year-to-Date 2021-2022 2020-2021 Budget Estimate 2021-2022 $ 547,397 2,800 659,161 $ 3,467 559,462 2,915 197,945 219,316 79,100 191,294 2,771 9,600 10,407 13,108 483 4,093 1,497 6,463 51,599 5,550 12,355 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 201,292 240,237 79,768 182,043 2,694 9,424 10,459 82,734 118 3,670 1,725 5,867 90,608 5,012 13,507 1,355,776 1,508,524 1,491,536 40,620 105,455 42,099 6,794 302,369 5,296 71,428 7,592 19,818 149,715 38,945 5,863 36,384 1,037,554 123,686 49,951 125,018 50,264 10,309 362,607 6,051 87,581 6,351 30,963 156,460 7,058 6,950 31,673 594,474 123,936 44,354 116,815 43,030 9,192 293,468 1,982 70,968 7,060 18,164 147,054 20,685 7,011 39,912 490,215 119,698 1,993,617 1,649,646 1,429,609 412,546 75,996 487,697 254,696 189,870 573,640 99,147 492,275 266,858 199,650 391,196 57,922 492,162 254,744 186,310 1,420,805 1,631,571 1,382,334 4,770,198 - 24 - $ $ 4,789,742 $ 4,303,480 Citywide Operating Expenditures As of JUNE 30 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2021-2022 2020-2021 Budget 2021-2022 161,907 $ 77,018 238,925 154,211 53,240 207,451 41,438 8,342 49,780 40,008 7,046 47,054 36,162 7,985 44,147 Public Safety General Funds Other Funds Total Public Safety 999,730 252,792 1,252,522 992,648 236,253 1,228,901 925,920 196,981 1,122,901 Transportation General Funds Other Funds Total Transportation 25,006 828,681 853,687 23,166 773,918 797,084 22,144 764,453 786,597 Community Development General Funds Other Funds Total Community Development 32,015 264,682 296,697 28,225 199,735 227,960 24,114 221,196 245,310 Community Enrichment General Funds Other Funds Total Community Enrichment 182,964 294,418 477,382 173,631 246,870 420,501 158,589 232,216 390,805 Environmental Services General Funds Other Funds Total Environmental Services 27,932 784,850 812,782 26,508 725,878 752,386 20,905 713,828 734,733 Debt Service General Funds Other Funds Total Debt Service 132,070 132,070 131,081 131,081 131,938 131,938 26,627 1,077,626 1,104,253 24,158 539,477 563,635 29,106 470,134 499,240 American Rescue Plan Act General Funds Other Funds Total American Rescue Plan Act 215,807 215,807 81,422 81,422 - Vacancy Savings General Funds Other Funds Total Vacancy Savings (11,000) (11,000) - - Contingencies General Funds Other Funds Total Contingencies 124,164 79,500 203,664 - - 1,621,668 4,004,857 5,626,523 1,470,251 3,018,698 4,488,949 $ $ 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 $ 172,790 66,089 238,879 $ $ - 25 - 1,371,151 2,791,971 4,163,122 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 2022 2021 Budget Estimate 2021-2022 Source Actual Year-to-Date 2021-2022 2020-2021 General Funds $ 61,285,519 400,104 61,685,623 17,414,703 17,673,908 4,514,890 $ 67,088,210 146,376 Local Taxes: Sales Taxes Privilege License Fees $ 547,396,684 2,800,000 $ 659,160,549 3,467,264 $ 559,461,871 2,915,221 67,234,586 Total Local Taxes 550,196,684 662,627,813 562,377,092 12,848,111 20,019,770 4,365,732 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 197,945,000 219,316,000 79,100,000 229,900,524 213,293,936 78,694,876 201,292,317 240,237,239 79,768,303 39,603,501 37,233,613 496,361,000 521,889,336 521,297,859 20,263,491 14,052,721 Primary Property Tax Total State Shared Taxes 191,294,000 192,214,899 182,043,050 289,480 256,332 Licenses and Permits 2,771,000 3,021,912 2,693,955 2,300,000 2,400,000 Cable Communications 9,600,000 8,982,382 9,423,540 659,424 63,510 771,992 116,713 Municipal Court: Fines and Forfeitures Court Default Fee 8,956,050 1,451,000 8,108,822 879,810 9,171,082 1,288,398 722,934 888,705 213,915 566,769 Police Total Municipal Court 10,407,050 8,988,632 10,459,480 13,107,604 13,841,516 82,733,549 45,500 (80,394) Library Fees 482,634 433,745 118,467 340,303 393,682 Parks and Recreation 4,092,621 5,141,281 3,669,919 119,318 211,783 Planning and Development 1,496,700 1,904,040 1,725,236 (2,783,041) (1,144,637) Street Transportation 6,462,738 4,509,864 5,867,262 3,017,243 147,533 883,057 5,471,660 182,275 829,888 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other 33,500,000 1,500,000 16,598,713 46,487,195 1,296,733 17,768,721 34,101,092 1,465,150 55,041,533 4,047,833 6,483,823 51,598,713 65,552,649 90,607,775 Total Fire 651,262 385,575 Interest 5,550,000 3,902,034 5,011,968 1,361,718 826,000 Other Fees and Service Charges 12,354,781 15,514,385 13,506,973 128,861,837 129,708,558 1,355,775,525 1,508,524,488 1,491,536,125 Total General Funds 26 Citywide Operating Revenue by Source (continued) For the Month Ended JUNE 30 2021 2022 Budget Estimate 2021-2022 Source Actual Year-to-Date 2021-2022 2020-2021 Special Revenue and Debt Service Funds $ 3,820,766 272,697 1,364,488 18,174 $ 5,476,125 10,297,992 3,143,540 13,371 $ $ $ 13,454,903 5,679,146 505,419 0 212,804 3,974 55,063 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 6,003,037 Total Neighborhood Protection 13,077,114 4,537,572 9,902 17,624,588 $ $ $ $ $ $ 777,260 37,242,079 2,241,925 4,192,707 299,479 1,498,395 12,456 $ $ 39,484,004 6,538,515 247,604 0 176,450 2,087 62,063 $ 28,150,485 2,010,822 10,053,100 405,446 $ 34,421,678 2,458,477 12,293,385 777,791 $ 28,657,367 2,046,955 10,235,774 3,414,300 40,619,853 49,951,331 44,354,396 79,660,712 25,473,909 320,352 95,129,762 29,753,960 134,304 80,677,989 25,677,100 10,460,019 105,454,973 125,018,026 116,815,108 Parks and Preserves 42,099,308 50,263,649 43,030,405 Golf Courses: Fees Coffee Shops Concessions Interest Other 4,296,600 0 2,180,725 10,000 306,300 6,571,680 0 3,179,501 20,907 537,229 5,763,989 0 2,904,051 16,845 506,701 Public Safety Enhancement & Expansion Police Fire Interest/Other Total Public Safety Enhancement & Expansion 488,204 Total Golf Courses 6,793,625 10,309,317 9,191,586 40,806,811 1,013,394 Transit 2000 & 2050: Sales Taxes Interest/Other 274,395,647 27,973,297 335,608,608 26,998,864 279,348,428 14,119,120 302,368,944 362,607,472 293,467,548 $ 1,835,922 Court Awards 5,295,826 6,050,965 1,982,173 (4,096,449) $ (4,140,699) Planning and Development 71,428,000 87,581,081 70,967,855 338,801 883,304 Capital Construction 7,591,654 6,350,678 7,060,113 Sports Facilities: Sales Taxes Interest/Other 15,577,677 4,239,952 27,040,132 3,922,630 13,990,449 4,173,607 19,817,629 30,962,762 18,164,056 2,327,176 3,459,333 47,204 3,506,537 41,820,205 $ $ $ 2,627,936 29,634 2,657,570 Total Transit 2000 & 2050 Total Sports Facilities 27 Citywide Operating Revenue by Source (continued) For the Month Ended JUNE 30 2021 Budget Estimate 2021-2022 Actual Year-to-Date 2021-2022 2020-2021 148,960,000 750,000 5,000 155,465,241 630,024 364,038 146,188,071 727,153 138,959 Total Highway User Revenue 149,715,000 156,459,303 147,054,183 Local Transportation Assistance 0 0 0 2022 Source Special Revenue and Debt Service Funds (Cont'd) $ 14,546,305 102,562 26,307 11,816,237 52,056 40,083 14,675,174 11,908,376 - $ - Highway User Revenue: Highway User Revenue Interest Other 1,306,441 3,315,602 Regional Transit Revenues 38,945,335 7,058,415 20,685,042 1,948,363 1,311,908 Community Reinvestment 5,862,535 6,949,583 7,011,405 16,617,775 10,529,519 Other Restricted Fees 36,384,438 31,672,953 39,912,099 381,348 2,939,503 6,000,530 648,274 6,167,583 3,720,209 Grants: Public Housing: Rentals Grants Other 7,677,450 95,987,976 25,700,110 5,292,053 94,754,765 20,923,236 7,009,343 95,898,426 15,633,246 9,321,381 10,536,066 129,365,536 120,970,054 118,541,015 72,598,319 94,869,017 7,147,559 111,443,663 20,318,689 42,217,547 9,879,209 37,868,508 86,581,471 240,755,810 70,581,150 510,270,201 134,441,220 172,716,681 17,446,156 148,900,216 72,107,524 141,731,759 17,302,564 140,532,628 286,058,558 110,283,953 Total Other 908,188,632 473,504,273 371,674,475 295,379,939 120,820,019 Total Grants 1,037,554,168 594,474,327 490,215,490 119,288,943 4,396,670 119,973,319 3,962,894 115,068,645 4,629,221 12,260,176 2,200,045 8,557,157 2,310,705 $ Total Public Housing Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond/Secondary Property Tax Secondary Property Tax Interest 14,460,221 10,867,862 Total G.O. Bond/Secondary Property Tax 411,335,416 232,463,932 Total Special Revenue and Debt Service Funds 123,685,613 123,936,213 119,697,866 1,993,616,901 1,649,646,075 1,429,609,325 119,690,864 271,910,885 5,711,000 8,827,798 2,883,830 3,521,570 0 99,932,418 313,626,959 1,460,615 151,223,426 3,053,232 3,491,322 851,717 85,390,772 189,073,026 2,157,255 106,990,417 3,045,238 3,290,022 1,249,336 412,545,947 573,639,689 391,196,066 Enterprise Funds AVIATION: 9,202,210 28,432,608 109,441 117,440,218 264,026 286,370 125,043 6,913,882 27,013,902 (2,551) 57,288,108 255,005 293,488 82,352 155,859,916 91,844,186 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 JUNE 30 2021 2022 Budget Estimate 2021-2022 Source Actual Year-to-Date 2021-2022 2020-2021 Enterprise Funds (Cont'd) CONVENTION CENTER: $ 8,685,057 2,606,715 55,591 8,322,929 391,745 26,882 11,347,363 8,741,556 51,720,293 282,523 (1,671,673) 1,008,306 281,880 898,488 (698,850) 46,082,550 252,553 (4,950,394) 1,314,405 870,505 (454,985) 59,161 51,820,967 43,173,795 Excise Taxes Operating Revenue Interest Total Convention Center 57,195,956 18,000,000 800,000 77,786,044 21,045,586 315,500 54,330,674 3,138,878 452,711 75,995,956 99,147,130 57,922,263 457,546,975 5,000,000 5,610,000 8,792,000 4,900,000 8,317,000 (2,469,270) 460,337,051 2,972,008 9,503,834 8,411,320 6,364,860 2,245,606 2,440,608 472,189,766 2,539,132 2,278,279 9,364,381 6,171,264 1,564,945 (1,946,080) 487,696,705 492,275,287 492,161,687 WATER SYSTEM: $ Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System WASTEWATER: 20,694,330 (6,429,432) 254,220 403,177 3,051,432 17,913,308 (4,158,221) 630,930 151,695 2,885,985 Sewer Service Charges Multi-City Development Fees Interest Other 210,134,198 15,721,355 4,700,000 3,611,000 20,529,855 213,922,095 13,615,667 6,086,070 2,113,338 31,121,207 208,504,527 14,007,353 5,722,710 2,742,839 23,766,208 17,973,727 17,423,697 Total Wastewater 254,696,408 266,858,377 254,743,637 14,846,330 1,361,826 47,699 (976,567) 14,897,602 1,209,505 21,867 1,271,268 171,158,281 12,496,485 500,800 5,714,310 173,609,450 13,975,373 287,429 11,778,012 162,591,883 12,177,274 297,736 11,243,583 SOLID WASTE: $ 15,279,288 17,400,242 252,281,261 178,583,476 792,478,514 $ 540,755,966 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ 29 189,869,876 199,650,264 186,310,476 1,420,804,892 1,631,570,747 1,382,334,129 4,770,197,318 $ 4,789,741,310 $ 4,303,479,579 Citywide Operating Expenditures by Program For the Month Ended JUNE 30 2022 2021 Program Budget Estimate 2021-2022 2021-2022 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2021-2022 2020-2021 General Government $ 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 344,343 555,269 1,154,000 8,307,894 92,281 277,127 304,429 2,409,683 250,397 340,791 2,976,948 (329,012) (23,213) 388,620 2,169,254 2,251,054 81,088,740 21,469,865 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,322,528 5,577,004 8,826,394 63,942,376 1,259,397 3,429,291 3,453,183 25,947,034 3,174,007 7,475,019 20,125,252 124,177 4,310,873 83,017,261 5,894,955 $ 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,020,408 4,161,885 10,300,245 78,632,559 1,479,025 2,762,377 2,702,596 25,438,267 2,654,785 5,518,693 22,087,790 47,648 95,913 3,596,533 40,819,226 5,133,535 $ 2,200,130 4,782,318 6,429,267 63,830,102 1,288,130 3,366,172 3,231,082 26,294,072 2,743,127 4,330,910 20,630,071 429,873 104,004 4,007,629 23,529,438 4,807,998 1,840,964 391,417 64,687,834 - 238,878,751 238,924,537 207,451,484 172,004,322 66,920,215 42,565,455 7,214,405 39,478,171 7,575,381 39,086,809 5,059,995 34,401,806 7,575,381 5,076,364 - 49,779,860 47,053,551 44,146,803 41,977,187 5,076,364 789,317,218 462,514,635 689,995 779,052,175 449,574,235 275,086 711,125,836 411,201,338 573,691 778,712,905 449,321,642 275,086 339,270 252,593 - 1,252,521,848 1,228,901,496 1,122,900,866 1,228,309,633 591,863 Criminal Justice 3,737,926 484,918 4,104,166 686,479 4,222,844 4,790,645 Municipal Court Public Defender Total Criminal Justice Public Safety 95,894,994 46,219,479 192,514 73,565,813 40,193,371 71,704 142,306,987 113,830,889 Police Fire Other Total Public Safety -30- Citywide Operating Expenditures by Program (continued) For the Month Ended JUNE 30 2022 2021 Budget Estimate 2021-2022 Program 2021-2022 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2021-2022 2020-2021 Transportation $ 6,721,019 $ 726,404 51,682,174 (12,655,578) 5,740,907 878,613 46,845,910 (13,414,507) Street Transportation Street Lighting Aviation Public Transit 46,474,019 40,050,923 Total Transportation $ 110,545,415 8,608,167 439,526,868 295,006,507 $ 97,447,458 9,377,633 453,292,136 236,966,900 $ 92,715,385 8,589,176 467,020,841 218,271,975 $ 94,940,892 9,377,633 348,414,395 236,966,900 2,506,566 104,877,742 - 853,686,957 797,084,128 786,597,377 689,699,820 107,384,308 Community Development 8,396,863 12,781,476 2,547,037 2,530,325 6,442,247 15,981,775 2,094,725 2,982,856 Planning and Development Housing Economic Development Neighborhood Services Department 81,254,299 113,580,586 20,464,299 81,397,917 74,292,826 108,139,131 16,905,954 28,622,196 66,451,484 105,656,989 24,821,602 48,380,255 74,292,826 108,081,127 12,750,960 28,622,196 58,004 4,154,995 - 26,255,701 27,501,603 Total Community Development 296,697,101 227,960,108 245,310,330 223,747,108 4,212,999 126,466,232 44,860,208 64,654,482 12,708,486 217,537,246 6,382,155 4,772,747 118,961,942 42,924,922 62,221,285 12,273,429 174,940,063 4,508,502 4,671,181 110,331,317 40,193,754 63,592,405 12,168,663 153,965,629 3,827,647 6,725,391 118,938,440 42,924,922 41,458,012 174,935,754 4,508,502 4,671,181 23,502 20,763,273 12,273,429 4,310 - 477,381,556 420,501,325 390,804,807 387,436,812 33,064,513 Community Enrichment 13,846,007 3,591,981 4,699,659 624,913 16,179,326 102,614 535,050 15,567,543 4,378,898 4,077,216 1,101,975 16,499,515 (163,087) 358,572 39,579,549 41,820,633 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 JUNE 30 2022 2021 Budget Estimate 2021-2022 Program 2021-2022 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2021-2022 2020-2021 Environmental Services $ 27,746,591 14,324,419 14,501,099 2,786,547 352,462 81,671 $ 27,596,518 13,760,447 17,308,280 2,437,799 173,990 99,316 Water System Wastewater Solid Waste Management Public Works Environmental Programs Manager's Office of Sustainability 59,792,789 61,376,351 Total Environmental Services 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 1,410,378 352,649 66,834 652,044 44,915 552,630 205,978 1,293,743 587,564 63,447 1,660,221 802,825 427,589 123,119 78,500 1,701,447 913,133 1,763 26,786 10,613,045 10,965,566 89,740,675 79,746,333 $ 404,608,191 187,472,296 184,719,208 33,074,896 1,996,649 910,264 $ 365,422,108 180,841,627 172,226,796 31,332,890 1,820,383 741,749 $ 357,456,370 177,445,363 165,856,548 29,344,864 3,649,335 980,483 $ 233,680,460 110,548,377 157,946,326 24,953,090 1,820,383 741,749 131,741,648 70,293,250 14,280,470 6,379,800 - 812,781,504 752,385,553 734,732,961 529,690,385 222,695,168 20,259,518 3,436,251 727,775 8,038,829 540,525 2,835,631 2,224,501 15,125,282 7,206,372 654,475 20,130,840 10,676,016 4,347,610 1,087,432 650,036 946,500 20,795,916 12,039,192 25,550 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 16,924,536 4,231,786 802,013 7,824,529 538,975 6,631,555 2,471,740 15,524,922 7,050,772 761,369 19,922,659 9,633,904 5,131,068 1,477,431 27 942,000 20,417,366 10,957,597 21,150 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 23 946,500 20,707,738 12,013,347 25,550 321,429 281,250 - Total Debt Service 132,069,680 131,081,070 131,937,602 130,799,820 281,250 Capital Improvement 499,239,839 563,635,243 - 81,421,501 - General Obligation Debt Service 4,676,746 $ 500,074,348 Cultural Facilities Downtown Development Economic Development Fire Protection Freeway Mitigation Historic/Neighborhood Preservation Human Services Information Systems Libraries Maintenance Service Centers Mountain Preserves/Parks Police Protection Public Housing Renovation Sanitary Sewers Secondary Property Tax Solid Waste Enterprise Bonds Storm Sewer Improvements Street Improvements Street Light Refinancing Water System 1,104,252,998 563,635,243 - American Rescue Plan Act 215,806,712 81,421,501 - Vacancy Savings (11,000,000) - Contingencies 401,552,809 - 203,664,420 - 5,626,521,387 4,488,948,511 -32- 4,163,122,069 4,048,721,831 440,226,679 Capital Expenditures and Encumbrances 2021-2022 Program General Government Arts and Cultural Facilities Economic Development Facilities Management Finance Fire Protection Housing Human Services Information Technology Libraries Neighborhood Services Parks and Mountain Preserves Planning & Historic Preservation Police Protection 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 Budget $ $ $ 2020-2021 Actual Yearto-Date Actual Yearto-Date From Operating Funds Budget Actual 902,484 $ 34,449,804 25,868,734 8,000,000 37,132,633 57,512,971 600,000 20,951,192 7,706,283 13,906,226 85,207,418 3,648,000 24,412,000 409,110,166 6,001,000 346,946,855 $ 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 $ 98,178,957 15,857,171 (0) 9,134,629 14,678,279 11,724,536 271,507 1,175,108 31,963,886 11,053,443 272,511,918 963,741 217,284,834 1,082,355,766 $ 525,852,215 $ 684,798,008 $ 430,068,664 109,474,873 41,067,207 248,806,560 350,045,933 1,179,463,237 $ 2,261,819,003 $ $ 115,394,586 84,750,933 28,986,269 182,709,702 205,485,392 617,326,881 $ $ 172,418,239 31,640,338 8,795,570 77,339,283 433,999,712 724,193,142 $ 1,143,179,096 $ 1,408,991,150 - 33 - - $ 34,449,804 16,671,311 11,262,645 45,563,845 11,300,493 3,040,000 13,906,226 69,481,324 3,648,000 $ $ 2021-2022 Year-to-Date Capital Amounts From Capital Funds Budget Actual 337,696,715 182,829,567 $ 2,587,200 11,898,790 1,949,858 5,392,236 14,436,338 1,101,455 4,848,783 39,562,049 553,157 169,225,012 108,052,508 902,484 $ 9,197,423 8,000,000 25,869,988 11,949,126 600,000 9,650,699 4,666,283 15,726,094 24,412,000 71,413,451 6,001,000 164,117,288 $ 2,877,174 5,469,106 3,084,695 1,285,462 2,135,480 1,337,554 12,345,107 67,927,557 379,490 69,403,204 902,484 31,862,604 11,092,770 2,530,894 32,098,080 50,835,273 600,000 4,379,374 6,604,828 9,057,443 44,307,814 3,094,843 12,066,893 171,957,597 5,621,510 169,491,144 729,849,930 $ 359,607,386 352,505,836 $ 166,244,829 556,503,551 127,454,037 29,976,423 19,342,260 69,595,302 128,035,046 374,403,068 18,397,950 9,280,841 13,877,125 66,083,712 96,388,229 $ 204,027,857 $ 1,104,252,998 $ 563,635,243 $ Unencumbered Budget $ $ $ $ 302,614,627 79,498,450 21,724,947 179,211,258 222,010,887 805,060,169 $ 1,157,566,005 $ $ $ 96,996,635 75,470,092 15,109,144 116,625,990 109,097,163 413,299,025 $ $ 314,674,078 24,723,940 12,080,938 66,096,858 144,560,541 562,136,356 $ 579,543,853 $ 1,118,639,907 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 Revitalizatio 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 80,000 17-18 Actuals 70,000 18-19 Actuals 60,000 19-20 Actuals 50,000 20-21 Actuals 21-22 Actuals 40,000 21-22 Budget 30,000 20,000 10,000 July FY 17-18 18-19 19-20 20-21 21-22 21-22 Budget Aug July 17,068 29,246 33,070 41,583 44,048 33,359 Sept Aug 43,895 32,982 36,653 59,937 61,805 47,837 Oct Sept 33,757 32,919 56,465 33,935 41,516 43,317 Nov Oct 42,559 52,159 31,089 45,467 50,734 47,232 Dec Nov 31,868 33,971 40,325 52,188 60,971 43,668 Jan Dec 33,857 53,513 51,643 39,837 53,633 49,321 Feb Jan 41,041 35,343 39,512 42,051 70,197 43,557 Note: City of Phoenix revenue is budgeted on an annual basis. 2021-22 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2017-18 through FY 2020-21 actual expenditures. Return to Summary Page - A1 - Feb 36,368 38,579 33,570 32,672 42,535 38,935 Mar Mar 32,970 39,641 61,093 63,749 44,740 54,451 Apr May June Apr 48,534 46,770 29,662 40,758 54,758 45,701 May 33,061 27,146 35,239 40,197 72,938 37,406 June 45,459 64,281 50,222 67,088 61,286 62,613 YTD thru June 440,437 486,550 498,543 559,462 659,161 547,397 State Sales Tax (Dollars in Thousands) State Sales Tax 30,000 17-18 Actuals 25,000 18-19 Actuals 19-20 Actuals 20,000 20-21 Actuals 15,000 21-22 Actuals 21-22 Budget 10,000 5,000 July FY 17-18 18-19 19-20 20-21 21-22 21-22 Budget Aug July 11,773 18,836 20,116 22,912 26,539 20,994 Aug 12,260 13,749 14,944 14,482 18,124 15,805 Sept Oct Sept 17,561 12,476 11,479 13,123 16,285 15,578 Nov Oct 10,963 10,922 14,226 18,038 18,259 15,438 Dec Jan Feb Mar Apr May June Nov 13,678 15,747 16,443 13,095 15,097 16,811 Dec 13,707 14,902 12,120 19,640 23,860 17,212 Jan 13,334 12,154 17,440 19,033 22,364 17,666 Feb 13,322 15,369 17,707 10,831 12,163 16,316 Mar 13,651 13,689 12,285 15,878 18,738 15,824 Apr 12,631 14,284 18,557 23,414 25,105 19,640 May 13,603 14,640 11,288 17,998 15,952 16,402 Note: City of Phoenix revenue is budgeted on an annual basis. 2021-22 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2017-18 through FY 2020-21 actual expenditures. Return to Summary Page - A2 - June YTD thru June 9,515 155,998 8,298 165,066 5,321 171,926 12,848 201,292 17,415 229,901 10,259 197,945 Vehicle License Tax (Dollars in Thousands) Vehicle License Tax 12,000 17-18 Actuals 11,000 18-19 Actuals 10,000 9,000 19-20 Actuals 8,000 20-21 Actuals 7,000 21-22 Actuals 6,000 21-22 Budget 5,000 4,000 3,000 2,000 July FY 17-18 18-19 19-20 20-21 21-22 21-22 Budget Aug July 9,008 9,422 10,791 10,098 10,453 10,827 Sept Oct Aug 4,830 5,782 5,619 7,692 5,328 6,588 Sept 5,152 5,349 5,207 6,207 6,363 6,035 Nov Dec Jan Feb Oct 5,670 6,492 6,146 7,328 6,970 7,059 Nov 4,904 4,886 5,408 4,608 4,862 5,454 Dec 5,741 5,800 5,891 6,529 6,537 6,598 Jan 5,470 6,143 6,514 7,328 7,285 7,010 Note: City of Phoenix revenue is budgeted on an annual basis. 2021-22 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2017-18 through FY 2020-21 actual expenditures. Return to Summary Page - A3 - Mar Feb 5,714 5,490 6,528 5,568 5,828 6,416 Apr Mar 5,493 5,943 5,960 6,411 6,418 6,556 May Apr 5,593 5,668 5,110 7,162 8,075 6,480 June May 5,602 5,959 4,699 6,472 6,061 6,260 June YTD thru June 3,607 66,784 3,276 70,210 2,611 70,484 4,365 79,768 4,515 78,695 3,816 79,099 Governmental Funds Revenue (Dollars in Thousands) Governmental Funds Revenue 600,000 2017-18 Actuals 550,000 500,000 2018-19 Actuals 450,000 2019-20 Actuals 400,000 2020-21 Actuals 350,000 2021-22 Actuals 300,000 21-22 Budget 250,000 200,000 150,000 100,000 50,000 - FY 17-18 18-19 19-20 20-21 21-22 21-22 Budget July Aug Sept July 98,501 131,124 100,481 68,761 123,174 122,524 Aug 185,527 168,019 187,393 217,048 225,569 243,150 Sept 176,701 152,605 194,506 260,275 185,901 255,683 Oct Nov Dec Oct 189,075 198,474 175,883 215,731 231,638 255,315 Nov 226,848 247,632 269,127 298,362 324,875 337,794 Dec 192,262 221,971 226,582 236,818 253,979 288,968 Jan Jan 187,522 170,844 209,806 216,626 267,406 257,819 Note: City of Phoenix revenue is budgeted on an annual basis. 2021-22 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2017-18 through FY 2020-21 actual expenditures. Return to Summary Page - A4 - Feb Feb 176,559 173,462 187,061 178,738 199,258 237,296 Mar Apr Mar 167,449 187,169 217,521 272,444 230,537 276,766 May June Apr 217,138 210,659 180,484 316,241 255,574 313,183 May 223,002 245,256 226,625 277,929 320,064 321,346 June YTD thru June 252,080 2,292,664 280,540 2,387,755 378,887 2,554,356 362,173 2,921,146 540,197 3,158,172 439,548 3,349,392 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 - 17-18 Actuals 18-19 Actuals 19-20 Actuals 20-21 Actuals 21-22 Actuals 21-22 Budget July FY 17-18 18-19 19-20 20-21 21-22 21-22 Budget Aug Sept Oct July 26,403 31,468 30,489 25,387 36,735 30,581 Aug 34,965 32,105 32,307 2,666 33,945 27,434 Sept 30,148 31,728 32,953 27,193 28,302 32,806 Nov Dec Jan Feb Mar Apr Oct 29,291 31,719 32,056 21,045 31,904 30,679 Nov 21,702 32,312 33,532 23,880 36,031 29,957 Dec 38,212 30,496 36,787 31,636 35,025 36,868 Jan 32,543 31,205 34,297 18,059 57,391 31,215 Feb 30,671 32,944 34,215 61,877 33,583 42,937 Mar 33,070 33,075 34,228 25,487 38,417 33,838 Note: City of Phoenix revenue is budgeted on an annual basis. 2021-22 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2017-18 through FY 2020-21 actual expenditures. Return to Summary Page - A5 - May Apr 37,265 37,847 27,255 31,454 40,080 35,978 June May 32,447 34,396 23,524 30,668 46,367 32,540 June 38,986 35,938 10,702 91,844 155,860 47,713 YTD thru June 385,703 395,233 362,345 391,196 573,640 412,546 Water System Revenues (Dollars in Thousands) Water System Operating Revenues 70,000 17-18 Actuals 60,000 18-19 Actuals 19-20 Actuals 50,000 20-21 Actuals 40,000 21-22 Actuals 21-22 Budget 30,000 20,000 10,000 July FY 17-18 18-19 19-20 20-21 21-22 21-22 Budget Aug July 54,624 49,797 52,660 57,819 58,256 58,764 Sept Aug 44,633 46,762 51,596 53,509 42,379 53,733 Oct Sept 44,819 44,112 47,319 52,454 47,181 51,601 Nov Dec Jan Feb Mar Apr May June Oct 39,391 35,672 40,300 47,335 39,257 44,490 Nov 38,890 31,619 38,339 42,280 41,784 41,326 Dec 27,184 25,048 26,405 33,139 37,523 30,565 Jan 25,186 22,565 25,330 28,579 28,902 27,799 Feb 22,704 21,558 25,643 25,188 28,035 26,003 Mar 23,806 20,138 24,861 28,415 31,242 26,585 Apr 31,392 31,150 29,080 37,714 40,702 35,367 May 38,031 36,293 40,442 42,556 45,193 43,020 Note: City of Phoenix revenue is budgeted on an annual basis. 2021-22 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2017-18 through FY 2020-21 actual expenditures. Return to Summary Page - A6 - June 43,736 38,106 52,141 43,174 51,821 48,444 YTD thru June 434,396 402,820 454,116 492,162 492,275 487,697 Wastewater Revenues (Dollars in Thousands) Wastewater Operating Revenues 32,000 17-18 Actuals 18-19 Actuals 27,000 19-20 Actuals 22,000 20-21 Actuals 21-22 Actuals 17,000 21-22 Budget 12,000 7,000 2,000 July FY 17-18 18-19 19-20 20-21 21-22 21-22 Budget Aug July 18,615 17,949 18,374 21,205 22,011 19,596 Sept Aug 22,957 20,417 24,593 22,791 21,971 23,357 Oct Sept 19,811 21,145 21,373 21,844 26,947 21,662 Nov Dec Jan Feb Mar Apr May June Oct 20,195 23,028 20,975 22,234 18,312 22,243 Nov 20,386 19,734 21,142 18,577 21,720 20,547 Dec 20,097 20,469 20,888 24,461 24,380 22,110 Jan 20,584 22,113 22,063 18,430 22,218 21,409 Feb 19,499 19,436 20,973 24,355 21,916 21,685 Mar 20,517 19,960 21,613 21,754 23,023 21,577 Apr 18,079 21,256 18,428 21,584 24,091 20,420 May 20,160 20,980 23,948 20,085 22,296 21,919 Note: City of Phoenix revenue is budgeted on an annual basis. 2021-22 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2017-18 through FY 2020-21 actual expenditures. Return to Summary Page - A7 - June 18,345 16,544 18,289 17,424 17,973 18,170 YTD thru June 239,245 243,031 252,659 254,744 266,858 254,695