November 2021 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division November 30, 2021 To the Mayor and City Council: This is the City's Financial Report for November, the fifth 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, Kathleen Gitkin Chief Financial Officer John Gamble Deputy Finance Director December 27, 2021 CITY AUDITOR REPORT To the Chief Financial Officer, We have assessed the Finance Department’s (Finance) November 2021 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 September 27, 2021. The agreed-upon procedures include the following: • Verification of mathematical calculations presented within the MFR, and • Reconciliation of stated financial data presented within the MFR to historical data supplied by Finance. This engagement was conducted in accordance with the attestation standards established by Generally Accepted Government Auditing Standards (GAGAS). 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, For Ross Tate Deputy City Auditor City of Phoenix Monthly Financial Report November 2021 Table of Contents Expenditures by Programs Page Performance Status General Fund Expenditures General Fund Total Expenditures 1 Expected General Government 1 Monitor and Consider Taking Action Criminal Justice 2 Better than Expected Public Safety 2 Better than Expected Transportation 3 Monitor and Consider Taking Action Community Development 3 Better than Expected Community Enrichment 4 Better than Expected Environmental Services 4 Monitor and Consider Taking Action Citywide Total Operating Expenditures 5 Better than Expected General Government 5 Better than Expected Criminal Justice 6 Better than Expected Citywide Expenditures Public Safety 6 Better than Expected Transportation 7 Monitor and Consider Taking Action Community Development 7 Better than Expected Community Enrichment 8 Monitor and Consider Taking Action Environmental Services 8 Monitor and Consider Taking Action 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 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 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. November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 512,361 1,177,280 43.5% 525,696 1,214,362 43.3% 577,295 1,282,831 45.0% 570,279 1,371,152 41.6% 617,214 1,494,453 41.3% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustment for contingencies. Expected Total General Fund General Government $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 November November YTD Expenditures YTD Expenditures $600,000 $600,000 Annual Annual Expenditures Expenditures * * $400,000 $400,000 $200,000 $200,000 $0 $0 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 9.0% higher than the fiscal year 2020-21 actuals. Fiscal year 2021-22 actual general fund expenditures through November are 8.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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 53,558 110,408 48.5% 55,587 114,393 48.6% 65,262 123,100 53.0% 63,801 154,211 41.4% 74,961 169,980 44.1% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action Criminal GeneralJustice Government $140,000 $180,000 $120,000 $160,000 $100,000 $140,000 $120,000 $80,000 $100,000 $60,000 $80,000 $60,000 $40,000 $40,000 $20,000 $20,000 $0 November YTD Expenditures November 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 10.2% increase over fiscal year 2020-21 actuals. General fund general government expenditures through November are 17.5% 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 November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 13,726 32,232 42.6% 14,449 33,387 43.3% 14,948 35,033 42.7% 15,095 36,162 41.7% 16,259 39,858 40.8% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice $45,000 $40,000 $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $5,000 $0 November 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 10.2% increase over fiscal year 2020-21 actuals. General fund criminal justice expenditures through November are 7.7% 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 Public Safety November YTD Annual % of Annual Expenditures Expenditures * Expenditures 346,615 817,960 42.4% 354,763 841,467 42.2% 384,248 893,403 43.0% 390,569 925,920 42.2% 409,014 999,730 40.9% $1,200,000 * - For prior years-total actual expenditures, for current year-total approved budget $0 17-18 18-19 19-20 20-21 21-22 $1,000,000 November YTD Expenditures $800,000 $600,000 $400,000 Annual Expenditures * $200,000 17-18 18-19 19-20 20-21 21-22 Better than Expected Public safety expenditures include costs for police and fire services. The general fund public safety fiscal year 2021-22 budget includes a 8.0% increase over fiscal year 2020-21 actuals. Through November, general fund public safety expenditures are 4.7% 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 November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 9,603 16,366 58.7% 10,009 18,337 54.6% 9,729 19,748 49.3% 8,640 22,144 39.0% 10,097 23,476 43.0% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action CommunityTransportation Development $1 $30,000 $1 Series1 November YTD Expenditures $1 $20,000 $1 $0 $10,000 Series2Annual Expenditures * $0 $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 6.0% 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 November, General fund transportation expenditures are 16.9% higher than the same period in the prior fiscal year. Community Development Community Development November YTD Annual % of Annual Expenditures Expenditures * Expenditures 9,135 20,243 45.1% 9,024 21,238 42.5% 10,087 22,542 44.7% 9,956 24,114 41.3% 11,138 30,755 36.2% $35,000 * - For prior years-total actual expenditures, for current year-total approved budget $5,000 17-18 18-19 19-20 20-21 21-22 Better than Expected $30,000 November YTD Expenditures $25,000 $20,000 $15,000 $10,000 Annual Expenditures * $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 27.5% increase over fiscal year 2020-21 actuals. General fund community development expenditures through November are 11.9% 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 November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 68,040 156,325 43.5% 70,699 156,552 45.2% 78,392 155,417 50.4% 70,922 158,589 44.7% 78,290 181,164 43.2% * - For prior years-total actual expenditures, for current year-total approved budget Community Enrichment $200,000 November 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 14.2% increase over fiscal year 2020-21 actuals. Through November, general fund community enrichment expenditures are 10.4% 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 6,167 12,624 48.9% 7,929 16,886 47.0% 11,511 19,180 60.0% 8,162 20,905 39.0% 13,416 24,482 54.8% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services $28,000 $24,000 $20,000 $16,000 $12,000 $8,000 $4,000 $0 November YTD Expenditures Annual Expenditures * 17-18 Monitor and Consider Taking Action 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 17.1% increase from fiscal year 2020-21 actuals. Because environmental service expenditures are highly dependent on interdepartmental charges, they tend to be very volatile. Through November, general fund environmental services expenditures are 64.4% 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. November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 1,561,646 3,547,078 44.0% 1,712,961 3,775,464 45.4% 1,713,887 3,814,963 44.9% 1,693,614 4,163,122 40.7% 2,030,164 5,431,857 37.4% * - 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 November 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 November are 19.9% 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 61,861 134,117 46.1% 58,050 138,349 42.0% 72,526 157,200 46.1% 95,595 207,451 46.1% 80,041 205,869 38.9% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected General Government $250,000 November 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 November are 16.3% lower than the same period in the prior fiscal year. The budget anticipates an decrease of 0.8% for fiscal year 2021-22 over fiscal year 202021 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 November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 16,344 38,411 42.6% 15,345 42,530 36.1% 18,917 44,425 42.6% 18,631 44,147 42.2% 19,170 48,200 39.8% * - For prior years-total actual expenditures, for current year-total approved budget Criminal Justice $60,000 November 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 2.9% higher through November than the same period in the prior fiscal year. The budgeted increase for fiscal year 2021-22 over fiscal year 2020-21 actuals is 9.2%. 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 408,807 970,771 42.1% 424,761 1,025,513 41.4% 468,014 1,110,457 42.1% 476,226 1,122,901 42.4% 511,477 1,250,252 40.9% * - 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 November 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 November are 7.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.3%. 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 November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 405,867 709,977 57.2% 371,528 722,667 51.4% 472,103 774,492 61.0% 394,525 786,597 50.2% 499,601 852,157 58.6% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action Transportation $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $0 November 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 26.6% higher through November than the same period in the prior fiscal year. The budget anticipates an increase of 8.3% 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 84,836 203,096 41.8% 81,107 195,716 41.4% 86,634 229,793 37.7% 102,567 245,310 41.8% 92,181 295,437 31.2% * - 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 November 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 November are 10.1% lower than the same period in the prior fiscal year. The fiscal year 2021-22 budget includes an increase of 20.4% 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 November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 133,615 306,763 43.6% 130,783 317,465 41.2% 155,703 316,680 49.2% 170,427 390,805 43.6% 183,585 403,432 45.5% * - For prior years-total actual expenditures, for current year-total approved budget Community Enrichment $450,000 $400,000 $350,000 $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 $0 November YTD Expenditures Annual Expenditures * 17-18 18-19 19-20 20-21 21-22 Monitor and Consider Taking Action Community Enrichment expenditures include costs for Parks, Libraries, the Convention Center, Senior Centers and Community Centers. Citywide community enrichment expenditures through November are 7.7% higher than the same period in the prior fiscal year. The fiscal year 2021-22 budget anticipates an increase of 3.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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 263,420 696,244 37.8% 212,378 670,219 31.7% 299,773 692,524 43.3% 308,609 734,733 42.0% 344,196 805,889 42.7% * - 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 November YTD Expenditures Annual Expenditures * 17-18 18-19 19-20 20-21 21-22 Monitor and Consider Taking Action Environmental Services expenditures include costs for Water, Wastewater and Solid Waste services as well as the care and maintenance of City facilities. Citywide environmental services expenditures are 11.5% higher through November than the same period in the prior fiscal year. The fiscal year 2021-22 budget anticipates an increase of 9.7% 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 November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 44,563 106,315 41.9% 222,263 116,634 190.6% 54,429 130,839 41.6% 55,179 131,938 41.8% 54,758 132,070 41.5% * - For prior years-total actual expenditures, for current year-total approved budget net of credit for early redemption fund resources $240,000 November YTD Expenditures $180,000 $120,000 Annual Expenditures * $60,000 $0 17-18 18-19 19-20 20-21 21-22 Expected General obligation debt service expenditures through November are 0.8% 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 $ 684,798 Discussion: 21-22 (Budget) 21-22 (YTD) $ $ 275,985 1,037,492 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 telphone stystem network replacement ($10.4 million) . 18-19 17-18 $0 $500,000 $1,000,000 21-22 (Budget) 21-22 (YTD) $ $ $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 Lightrial ($70M), South Central land acquisition ($45M), North Black Canyon area roadway and drainage infratructure ($39M). Aviation 17-18 18-19 $ 582,921 $ 552,972 19-20 $ 254,523 20-21 $ 172,418 430,169 34,148 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 concorse 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 $ 21-22 (Budget) 20-21 52,148 $ 31,640 Discussion: $ 40,137 21-22 (YTD) $ 64,471 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 exceeds budget due to 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 $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 21-22 (Budget) 20-21 $ 8,796 $ 41,069 21-22 (YTD) $ 1,741 Discussion: Solid Waste In fiscal year 2016-17, Solid Waste spent $3.7 million on the 27th Avenue Composting Facility and $2.2 million on the 27th Avenue Resource Innovation Campus. 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) 21-22 (Budget) 20-21 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. 19-20 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. 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,482 $116,943 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 $ 405,371 $ 84,616 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 November 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 November YTD Revenues 470,755 480,878 521,391 635,240 612,425 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 40.5% 39.4% 39.9% 42.6% 45.2% * - 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 November are 3.6% lower 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 210,000 95,435 101,652 107,555 119,289 115,069 180,000 Secondary 150,000 120,000 90,000 154,560 60,000 162,129 170,209 50,612 182,043 191,294 Primary 77,175 30,000 17-18 FY 17-18 18-19 19-20 20-21 21-22 YTD 21-22 Budget Total 249,995 263,781 277,764 297,112 127,787 310,582 July (1,054) (1,049) (1,141) (1,619) (1,490) (1,411) 18-19 Aug (395) 688 1,081 1,541 1,141 1,226 Sept 891 980 647 1,288 1,040 1,080 19-20 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 20-21 Dec 25,018 30,444 23,612 38,512 34,281 21-22 YTD Jan 10,162 13,302 14,875 15,608 16,215 Feb 7,020 5,422 7,447 6,612 7,214 21-22 Budget Mar 8,086 8,130 8,185 9,456 9,544 Apr 11,994 12,026 12,116 15,171 14,559 May 52,962 68,870 66,043 76,862 78,427 June 31,400 21,036 26,862 22,611 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 77,175 50,612 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 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 local sales tax revenues through November are 11.1% higher than the same period in the prior year. Actual local sales tax revenues through November are 20.3% 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 2020-21 local sales tax revenues were 12.2% higher than the prior year. This follows increases of 2.5% and 10.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 The fiscal year 2021-22 budget includes an decrease of 1.7% in state shared sales tax over fiscal year 2020-21 actuals. Through November state shared sales tax revenues are 11.4% above 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 2020-21 state sales tax revenues were 17.1% higher than the prior year. This follows increases of 4.2% and 5.8% 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 Monitor and Consider Taking Action State shared vehicle license tax revenues through November 2021 are 5.5% lower than budget expectations for the period. Vehicle License Tax 3 Year Trend 12,000 10,000 19-20 Actuals 8,000 20-21 Actuals 6,000 21-22 Actuals 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2020-21 state shared vehicle license tax revenues were 13.2% higher than the prior year. This follows increases of 0.4% and 5.1% 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 500,000.00 450,000.00 400,000.00 21-22 Budget 350,000.00 300,000.00 250,000.00 2021-22 Actuals 200,000.00 150,000.00 100,000.00 50,000.00 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 November 2021 are 10.2% lower than budget expectations for the period. Governmental Funds Revenues 3 Year Trend 400,000.00 350,000.00 300,000.00 2019-20 Actuals 250,000.00 200,000.00 2020-21 Actuals 150,000.00 2021-22 Actuals 100,000.00 50,000.00 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2020-21 governmental fund revenues were 14.4% higher than the prior year. This follows increases of 7.0% and 4.1% 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 70,000 60,000 50,000 21-22 Actuals 40,000 21-22 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 Aviation operating revenues through November 2021 are 10.2% higher than budget expectations for the period. Aviation Operating Revenues 3 Year Trend 100,000 80,000 60,000 19-20 Actuals 40,000 20-21 Actuals 21-22 Actuals 20,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May Fiscal year 2020-21 aviation revenues were 8.0% higher than the prior year. This follows a decrease of 8.3% and increase of 2.5% in the two previous years. Click Here for Additional Information - 19 - June 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 Monitor and Consider Taking Action Water system revenues through November 2021 are 8.4% lower 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 June Fiscal year 2020-21 water system revenues were 8.4% higher than the prior year. This follows increase of 12.7% and decrease of 7.3% in the two previous years. Click Here for Additional Information - 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 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 November 2021 are 3.3% 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 2020-21 wastewater revenues were 0.8% higher than the prior year. This follows increase of 4.0% and 1.6% 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 NOVEMBER 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 $ 259,074 $ 1,006 233,110 651 197,945 219,316 79,100 191,294 2,771 9,600 94,304 89,577 33,976 77,175 1,191 2,150 81,650 100,099 35,933 68,510 1,032 2,096 8,956 1,451 13,108 483 4,093 1,497 6,463 3,388 355 5,842 327 2,195 790 4,965 3,455 444 50,349 58 1,555 567 2,226 33,500 1,500 16,599 5,550 12,355 19,220 349 7,885 1,207 7,450 11,731 347 33,134 2,319 5,974 1,355,778 - 22 - $ 612,426 $ 635,240 General Fund Expenditures As of NOVEMBER 30 (dollars in thousands) Actual Year-to-Date 2021-2022 2020-2021 Budget Estimate 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,323 5,577 8,111 58,739 3,159 2,875 23,864 3,174 7,475 19,275 4,311 29,715 1,384 169,980 $ 1,020 $ 1,876 3,294 27,718 1,393 1,309 10,889 1,234 2,446 10,362 2,067 9,743 1,610 74,961 765 1,598 1,814 22,658 1,143 935 10,162 1,059 2,111 5,333 1,893 12,514 1,817 63,801 Criminal Justice Municipal Court Public Defender Total Criminal Justice 34,224 5,634 39,858 14,051 2,208 16,259 13,140 1,955 15,095 Public Safety Police Fire Others Total Public Safety 611,239 388,358 133 999,730 248,691 160,117 206 409,014 248,532 141,819 218 390,569 Transportation Street Transportation Public Transit Total Transportation 21,638 1,838 23,476 8,455 1,642 10,097 7,551 1,089 8,640 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 8,295 15,515 5,173 1,772 30,755 2,842 6,386 1,793 117 11,138 2,282 5,804 1,786 85 9,956 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 108,229 43,865 22,051 7,019 181,164 45,639 20,581 7,745 4,326 78,291 40,857 19,354 7,549 3,162 70,922 Environmental Services Public Works Environmental Programs Others Total Environmental Services 22,728 1,280 474 24,482 12,711 382 324 13,417 7,523 335 304 8,162 Capital Improvement 25,007 4,039 3,134 Vacancy Savings (11,000) - - Contingencies 124,164 - - 617,214 $ 570,279 Total Expenditures and Encumbrances $ 1,607,616 - 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 NOVEMBER 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 259,074 $ 1,006 233,110 651 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 94,304 89,577 33,976 77,175 1,191 2,150 3,743 5,842 327 2,195 790 4,965 27,454 1,207 7,450 81,650 100,099 35,933 68,510 1,032 2,096 3,899 50,349 58 1,555 567 2,226 45,212 2,319 5,974 1,355,776 612,425 635,241 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 18,122 46,666 18,432 2,996 130,158 2,398 44,936 2,636 8,814 63,048 1,651 1,460 2,663 84,140 50,612 18,630 51,398 16,006 2,720 109,054 18 35,842 2,958 4,661 59,624 4,781 2,274 2,800 70,392 43,778 1,993,617 478,732 424,937 412,546 75,996 487,697 254,696 189,870 166,917 30,932 228,857 110,961 81,592 100,171 20,302 253,397 106,651 70,660 1,420,805 619,259 551,181 4,770,198 - 24 - $ $ 1,710,416 $ 1,611,359 Citywide Operating Expenditures As of NOVEMBER 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 74,961 $ 5,080 80,041 63,801 31,794 95,595 39,858 8,342 48,200 16,259 2,911 19,170 15,095 3,536 18,631 Public Safety General Funds Other Funds Total Public Safety 999,730 250,522 1,250,252 409,014 102,463 511,477 390,569 85,657 476,226 Transportation General Funds Other Funds Total Transportation 23,476 828,681 852,157 10,097 489,504 499,601 8,640 385,885 394,525 Community Development General Funds Other Funds Total Community Development 30,755 264,682 295,437 11,138 81,043 92,181 9,956 92,611 102,567 Community Enrichment General Funds Other Funds Total Community Enrichment 181,164 222,268 403,432 78,290 105,295 183,585 70,922 99,505 170,427 Environmental Services General Funds Other Funds Total Environmental Services 24,482 781,407 805,889 13,416 330,780 344,196 8,162 300,447 308,609 Debt Service General Funds Other Funds Total Debt Service 132,070 132,070 54,758 54,758 55,179 55,179 25,007 1,020,145 1,045,152 4,039 230,121 234,160 3,134 68,721 71,855 American Rescue Plan Act General Funds Other Funds Total American Rescue Plan Act 393,400 393,400 10,996 10,996 - 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,607,616 3,623,506 5,624,522 617,214 1,401,955 2,030,165 $ $ 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 $ 169,980 35,889 205,869 $ $ - 25 - 570,279 1,123,335 1,693,614 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 NOVEMBER 30 2021 2020 Budget Estimate 2021-2022 Source Actual Year-to-Date 2021-2022 2020-2021 General Funds $ 60,970,878 367,272 61,338,150 15,096,750 17,673,908 4,861,184 $ 52,187,758 109,085 Local Taxes: Sales Taxes Privilege License Fees $ 547,396,684 2,800,000 $ 259,074,118 1,005,521 $ 233,109,949 650,543 52,296,843 Total Local Taxes 550,196,684 260,079,639 233,760,492 13,095,373 20,019,769 4,608,198 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 197,945,000 219,316,000 79,100,000 94,304,082 89,576,582 33,975,553 81,649,983 100,098,849 35,933,330 37,631,842 37,723,340 496,361,000 217,856,217 217,682,162 62,035,233 54,640,534 Primary Property Tax 191,294,000 77,175,428 68,510,280 332,984 247,798 Licenses and Permits 2,771,000 1,191,298 1,032,175 2,149,139 2,157,274 Cable Communications 9,600,000 2,149,885 2,096,380 632,539 66,339 Municipal Court: Fines and Forfeitures Court Default Fee 8,956,050 1,451,000 3,387,930 354,751 3,455,107 443,927 617,252 49,087 666,339 698,878 2,233,221 1,489,286 Total State Shared Taxes Total Municipal Court Police 3,742,681 3,899,034 13,107,604 5,841,850 50,349,262 14,644 (3,776) 482,634 326,621 58,133 399,265 511,975 Parks and Recreation 4,092,621 2,195,466 1,555,219 141,149 122,709 Planning and Development 1,496,700 789,773 566,802 618,634 409,746 Street Transportation 6,462,738 4,965,002 2,226,262 4,407,605 79,475 1,156,600 2,081,638 78,825 1,023,118 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other 33,500,000 1,500,000 16,598,713 19,220,141 349,000 7,884,538 11,730,697 346,850 33,134,404 5,643,680 3,183,581 51,598,713 27,453,679 45,211,951 233,619 410,617 5,550,000 1,207,119 2,319,228 2,422,806 2,588,683 175,860,705 156,477,488 Library Fees 10,407,050 Total Fire Interest Other Fees and Service Charges Total General Funds 26 12,354,781 7,450,042 5,973,638 1,355,775,525 612,424,700 635,241,018 Citywide Operating Revenue by Source (continued) For the Month Ended NOVEMBER 30 2021 2020 Budget Estimate 2021-2022 Source Actual Year-to-Date 2021-2022 2020-2021 Special Revenue and Debt Service Funds $ 3,102,436 221,602 1,108,012 27,868 $ 4,459,918 8,749,046 2,788,870 9,712 $ $ $ 11,547,628 2,484,754 177,482 887,413 35,299 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 3,584,948 Total Neighborhood Protection 8,685,035 3,262,000 17,301 11,964,336 4,472,714 $ 3,684,300 616,440 0 273,610 1,004 44,304 $ $ $ $ $ 470,141 0 263,465 953 46,985 935,358 30,267,567 2,880,059 $ $ 33,147,626 $ Public Safety Enhancement & Expansion Police Fire Interest/Other Total Public Safety Enhancement & Expansion 28,150,485 2,010,822 10,053,100 405,446 $ 12,522,793 894,485 4,472,426 232,678 $ 10,720,518 765,751 3,828,757 3,315,376 40,619,853 18,122,382 18,630,402 79,660,712 25,473,909 320,352 35,334,345 11,268,964 62,328 30,951,355 10,077,590 10,368,937 105,454,973 46,665,637 51,397,882 Parks and Preserves 42,099,308 18,432,225 16,006,370 Golf Courses: Fees Coffee Shops Concessions Interest Other 4,296,600 0 2,180,725 10,000 306,300 1,776,231 0 1,025,284 5,462 189,392 1,556,870 0 967,454 6,629 188,980 781,544 Total Golf Courses 6,793,625 2,996,369 2,719,933 24,078,289 798,872 Transit 2000 & 2050: Sales Taxes Interest/Other 274,395,647 27,973,297 122,083,546 8,074,162 104,471,766 4,582,293 302,368,944 130,157,708 109,054,059 24,877,161 Total Transit 2000 & 2050 128,394 $ (164,671) Court Awards 5,295,826 2,398,456 17,948 7,483,050 $ 5,231,212 Planning and Development 71,428,000 44,935,626 35,841,777 548,432 $ 438,962 Capital Construction 7,591,654 2,635,636 2,957,794 946,046 84,346 Sports Facilities: Sales Taxes Interest/Other 15,577,677 4,239,952 7,930,859 882,845 3,590,560 1,070,691 19,817,629 8,813,704 4,661,251 2,207,855 796,587 3,004,442 $ $ 1,030,392 Total Sports Facilities 27 Citywide Operating Revenue by Source (continued) For the Month Ended NOVEMBER 30 2021 2020 Source Budget Estimate 2021-2022 Actual Year-to-Date 2021-2022 2020-2021 148,960,000 750,000 5,000 62,629,315 191,959 226,300 59,276,120 342,513 5,285 149,715,000 63,047,574 59,623,918 Special Revenue and Debt Service Funds (Cont'd) $ 12,063,828 39,071 0 11,905,530 60,104 0 12,102,899 11,965,634 - $ - Highway User Revenue: Highway User Revenue Interest Other Total Highway User Revenue Local Transportation Assistance 0 0 0 531,343 5,232,221 Regional Transit Revenues 38,945,335 1,650,845 4,781,182 289,951 15,594 Community Reinvestment 5,862,535 1,459,674 2,273,520 (897,306) 98,532 Other Restricted Fees 36,384,438 2,663,453 2,800,195 7,677,450 96,223,329 25,464,757 2,429,867 42,882,342 6,612,852 2,804,033 43,251,422 3,298,785 129,365,536 51,925,061 49,354,240 86,581,471 240,755,810 70,581,150 510,270,201 8,021,806 8,587,406 (1,046,149) 16,652,084 18,253,547 2,298,561 (659,958) 1,145,970 493,908 7,872,604 502,745 609,368 8,334,428 635,566 8,869,257 9,579,362 2,040,774 12,863,007 3,398,979 3,074,254 4,712,018 19,632,127 733,587 3,606,966 Grants: Public Housing: Rentals Grants Other $ Total Public Housing Other: Human Resources Federal Transit Administration Community Development Other 21,377,014 28,684,698 Total Other 908,188,632 32,215,147 21,038,120 30,246,271 38,264,060 Total Grants 1,037,554,168 84,140,208 70,392,360 39,250,530 1,762,730 34,880,985 3 119,288,943 4,396,670 48,849,601 1,762,731 43,770,489 7,787 41,013,260 34,880,988 123,685,613 50,612,332 43,778,276 149,013,980 141,885,213 1,993,616,901 478,731,829 424,936,867 119,690,864 271,910,885 5,711,000 8,827,798 2,883,830 3,521,570 0 39,629,637 122,190,608 360,627 1,741,726 1,226,392 1,474,182 293,474 32,786,290 61,641,649 1,234,391 1,438,083 1,275,525 1,184,170 610,640 412,545,947 166,916,646 100,170,748 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: 7,987,835 27,352,371 75,824 19,322 258,499 281,714 55,579 7,003,673 15,782,592 199,310 370,851 281,818 137,442 103,565 36,031,144 23,879,251 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 NOVEMBER 30 2021 2020 Budget Estimate 2021-2022 Source Actual Year-to-Date 2021-2022 2020-2021 Enterprise Funds (Cont'd) CONVENTION CENTER: $ 7,123,334 1,507,347 18,823 5,393,464 368,471 39,671 8,649,504 5,801,606 38,392,842 256,311 564,603 439,142 312,120 102,597 1,715,669 40,989,478 185,067 480,095 (19,708) 348,780 193,257 102,860 41,783,284 42,279,829 Excise Taxes Operating Revenue Interest Total Convention Center 57,195,956 18,000,000 800,000 25,479,696 5,362,077 90,600 18,844,344 1,230,263 227,070 75,995,956 30,932,373 20,301,677 457,546,975 5,000,000 5,610,000 8,792,000 4,900,000 8,317,000 (2,469,270) 218,632,643 1,131,624 8,187,671 3,620,580 2,437,521 544,902 (5,698,244) 244,439,831 1,077,804 3,690,624 3,712,985 2,213,819 1,018,448 (2,756,216) 487,696,705 228,856,697 253,397,295 WATER SYSTEM: $ Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System WASTEWATER: 17,432,845 1,665,417 279,480 134,581 2,208,230 17,272,742 (101,659) 327,300 243,764 835,220 Sewer Service Charges Multi-City Development Fees Interest Other 210,134,198 15,721,355 4,700,000 3,611,000 20,529,855 88,163,322 9,012,561 2,350,393 738,394 10,696,621 87,034,162 7,433,196 2,061,870 1,303,911 8,817,991 21,720,553 18,577,367 Total Wastewater 254,696,408 110,961,291 106,651,130 171,158,281 12,496,485 500,800 5,714,310 71,283,785 5,805,088 86,530 4,416,982 63,873,005 4,867,486 142,235 1,777,406 189,869,876 81,592,385 70,660,132 1,420,804,892 619,259,392 551,180,982 $ 4,770,197,318 $ 1,710,415,921 SOLID WASTE: $ 14,273,305 1,284,205 17,362 48,762 12,783,825 903,209 24,552 169,566 15,623,634 13,881,152 123,808,119 104,419,205 448,682,804 $ 402,781,906 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues 29 $ 1,611,358,867 Citywide Operating Expenditures by Program For the Month Ended NOVEMBER 30 2021 2020 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 $ 184,470 $ 360,925 708,771 4,586,723 69,532 207,993 281,331 2,580,751 269,094 409,809 1,374,918 229,572 9,969 421,820 2,557,056 (431,030) 163,169 358,248 922,102 7,717,664 132,338 234,939 244,967 2,012,834 310,779 376,196 1,727,873 218,123 9,885 443,884 6,557,751 550,393 13,821,705 21,981,146 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 61,402,376 1,259,397 3,159,291 3,453,183 25,947,034 3,174,007 7,475,019 20,125,252 124,177 4,310,873 53,227,261 5,484,955 $ 1,020,007 1,876,439 3,407,162 28,831,024 495,070 1,398,925 1,445,212 11,678,739 1,234,074 2,445,833 10,770,684 1,052,837 61,879 2,066,543 12,252,426 4,269 $ 779,481 1,597,503 3,299,710 39,891,731 838,234 1,156,839 1,122,743 10,974,439 1,059,222 2,110,919 6,703,687 1,069,948 51,844 1,892,763 23,418,285 (372,054) $ 1,020,007 1,876,439 3,407,162 28,062,719 495,070 1,398,925 1,445,212 11,678,739 1,234,074 2,445,833 10,619,510 1,052,837 61,879 2,066,543 10,617,143 4,269 768,305 151,174 1,635,284 - 205,868,751 80,041,122 95,595,294 77,486,360 2,554,762 42,565,455 5,634,405 16,961,701 2,208,212 16,675,285 1,955,483 14,846,549 2,208,212 2,115,152 - 48,199,860 19,169,913 18,630,768 17,054,761 2,115,152 787,047,218 462,514,635 689,995 312,075,112 198,937,012 464,579 305,889,994 169,812,356 524,105 311,933,750 198,831,134 464,579 141,363 105,877 - 1,250,251,848 511,476,703 476,226,455 511,229,463 247,240 Criminal Justice 3,270,367 435,978 3,298,641 393,672 3,706,346 3,692,313 Municipal Court Public Defender Total Criminal Justice Public Safety 63,418,133 36,488,987 105,677 57,749,475 33,713,291 92,090 100,012,797 91,554,856 Police Fire Other Total Public Safety -30- Citywide Operating Expenditures by Program (continued) For the Month Ended NOVEMBER 30 2021 2020 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 $ 7,332,088 582,584 27,441,448 3,514,046 38,870,166 $ 7,041,721 270,395 21,873,629 6,134,200 Street Transportation Street Lighting Aviation Public Transit 35,319,945 Total Transportation $ 109,015,415 8,608,167 439,526,868 295,006,507 $ 49,356,094 4,689,602 217,384,870 228,169,972 $ 49,383,590 3,940,597 133,080,732 208,120,451 $ 48,643,185 4,689,602 181,011,653 228,169,972 712,909 36,373,217 - 852,156,957 499,600,539 394,525,371 462,514,413 37,086,126 Community Development 6,328,905 8,115,457 1,126,773 2,568,171 5,163,036 8,437,970 1,209,744 2,563,658 Planning and Development Housing Economic Development Neighborhood Services Department 81,254,299 113,580,586 19,204,299 81,397,917 31,450,798 42,910,301 5,477,287 12,342,728 26,746,968 42,530,036 14,711,995 18,578,105 31,450,798 42,879,432 3,847,216 12,342,728 30,869 1,630,071 - 18,139,307 17,374,408 Total Community Development 295,437,101 92,181,114 102,567,103 90,520,174 1,660,940 124,466,232 44,860,208 64,404,482 12,708,486 147,637,246 4,582,155 4,772,747 52,508,189 20,867,423 34,588,117 5,295,172 64,114,157 3,933,660 2,277,857 49,389,026 20,240,697 36,731,967 4,590,295 51,933,869 3,544,931 3,996,012 52,498,397 20,867,423 25,937,213 64,112,361 3,933,660 2,277,857 9,792 8,650,905 5,295,172 1,796 - 403,431,556 183,584,576 170,426,796 169,626,911 13,957,665 Community Enrichment 8,688,266 2,824,631 3,892,295 1,058,890 13,631,007 455,943 259,234 8,580,613 2,610,473 3,849,053 1,138,672 9,724,051 109,834 615,362 30,810,267 26,628,059 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 NOVEMBER 30 2021 2020 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 $ 25,896,930 14,245,812 12,777,411 2,972,731 168,761 78,230 56,139,876 $ 23,719,746 14,122,685 11,393,128 3,544,365 818,882 67,375 53,666,182 Water System Wastewater Solid Waste Management Public Works Environmental Programs Manager's Office of Sustainability Total Environmental Services $ 403,108,191 185,472,296 184,719,208 29,682,596 1,996,649 910,264 $ 165,757,548 79,149,594 82,599,641 15,379,670 870,575 439,092 $ 150,683,602 76,247,435 64,388,149 14,105,465 2,814,928 369,598 $ 110,825,865 49,860,541 76,649,025 12,720,055 870,575 439,092 54,931,683 29,289,053 5,950,616 2,659,615 92,830,967 805,889,204 344,196,121 308,609,176 251,365,154 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 8,441,465 1,431,771 303,240 3,349,512 225,219 1,181,513 926,876 6,302,201 3,002,655 272,698 8,387,850 4,448,340 1,811,504 453,097 14 394,375 8,664,965 5,016,330 10,646 133,929 7,051,890 1,763,244 334,172 3,260,221 224,573 2,763,148 1,029,892 6,468,718 2,937,822 317,237 8,301,108 4,014,127 2,137,945 615,596 13 392,500 8,507,236 4,565,666 8,813 133,929 8,441,465 1,431,771 303,240 3,349,512 225,219 1,181,513 926,876 6,302,201 3,002,655 272,698 8,387,850 4,448,340 1,811,504 453,097 14 394,375 8,664,965 5,016,330 10,646 133,929 - General Obligation Debt Service 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 1,410,378 352,649 66,834 652,044 44,915 552,630 205,978 1,293,744 587,564 63,447 1,660,222 802,825 427,589 123,119 78,500 1,701,447 913,133 1,763 26,786 10,951,637 10,965,567 Total Debt Service 132,069,680 54,758,197 55,178,622 54,758,197 - (29,868,767) 13,932,808 Capital Improvement 71,854,579 234,159,968 - 10,995,503 - 1,817,386 $ 242,583,332 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,045,152,010 234,159,968 - American Rescue Plan Act 393,400,000 10,995,503 - Vacancy Savings (11,000,000) - Contingencies 275,115,284 - 203,664,420 - 5,624,521,387 2,030,163,754 -32- 1,693,614,165 1,879,710,903 150,452,851 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 $ 9,449,804 25,757,081 8,000,000 37,132,633 55,512,971 600,000 19,331,192 5,621,283 13,906,226 84,033,892 3,648,000 24,412,000 409,110,166 6,001,000 334,072,971 $ (9,710,143) 2,531,557 3,733,727 1,761,742 3,287,793 3,110,536 26,082 316,266 4,700,945 175,142 11,314,206 173,974,125 378,356 80,384,800 $ 85,824,393 2,852,585 3,391,862 2,387,212 846,331 24,365 577,481 5,625,272 171,743 176,287,108 962,674 57,693,070 1,037,491,703 $ 275,985,136 $ 336,644,095 $ $ 430,168,664 40,136,585 41,068,570 248,481,560 405,370,933 1,165,226,312 $ $ 34,148,438 64,470,848 1,740,583 116,942,730 84,615,579 301,918,179 $ 2,202,718,015 $ 577,903,314 - $ 9,449,804 16,559,658 11,262,645 43,563,845 9,680,493 955,000 13,906,226 68,307,798 3,648,000 $ 337,696,715 169,955,683 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 $ (10,000,000) 1,396,840 3,726,786 1,287,895 651,784 397,826 36,657 11,314,206 67,930,148 378,356 48,316,649 902,484 19,159,947 23,225,524 4,266,273 35,370,891 52,225,178 600,000 16,220,656 5,595,201 13,589,960 79,332,947 3,472,858 13,097,794 235,136,041 5,622,644 253,688,171 684,985,867 $ 150,547,988 352,505,836 $ 125,437,147 761,506,567 $ $ $ 504,095,373 $ 1,045,152,010 - 33 - Unencumbered Budget $ 289,857 1,134,716 6,941 473,848 2,636,010 2,712,710 26,082 316,266 4,664,288 175,142 106,043,977 32,068,151 90,783,060 14,197,869 1,183,697 25,013,062 36,273,588 167,451,278 $ 2021-2022 Year-to-Date Capital Amounts From Capital Funds Budget Actual 127,554,037 15,638,135 19,343,623 69,285,302 128,345,046 360,166,143 $ $ 3,212,396 7,628,678 1,430,453 32,464,745 38,875,707 83,611,979 $ $ 234,159,968 $ $ $ 302,614,627 24,498,450 21,724,947 179,196,258 277,025,887 805,060,169 $ 1,157,566,005 $ $ $ 30,936,042 56,842,170 310,130 84,477,985 45,739,872 218,306,200 $ 396,020,226 (24,334,263) 39,327,987 131,538,830 320,755,354 863,308,133 $ 343,743,347 $ 1,624,814,701 Bonds Authorized and Sold As of NOVEMBER 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 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 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 Jan YTD thru Nov November 31,868 169,147 33,971 181,277 40,325 197,602 52,188 233,110 60,971 259,074 43,668 215,413 Feb Dec 33,857 53,513 51,643 39,837 49,321 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 - Jan 41,041 35,343 39,512 42,051 43,557 Mar Feb 36,368 38,579 33,570 32,672 38,935 Apr May June Mar 32,970 39,641 61,093 63,749 54,451 Apr 48,534 46,770 29,662 40,758 45,701 May 33,061 27,146 35,239 40,197 37,406 June 45,459 64,281 50,222 67,088 62,613 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 YTD thru Nov November 13,678 66,235 15,747 71,730 16,443 77,208 13,095 81,650 15,097 94,304 16,811 84,626 Dec 13,707 14,902 12,120 19,640 17,212 Jan 13,334 12,154 17,440 19,033 17,666 Feb 13,322 15,369 17,707 10,831 16,316 Mar 13,651 13,689 12,285 15,878 15,824 Apr 12,631 14,284 18,557 23,414 19,640 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 - May 13,603 14,640 11,288 17,998 16,402 June 9,515 8,298 5,321 12,848 10,259 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 Sept Oct July 9,008 9,422 10,791 10,098 10,453 10,827 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 Oct 5,670 6,492 6,146 7,328 6,970 7,059 Dec Jan YTD thru Nov November 4,904 29,564 4,886 31,931 5,408 33,171 4,608 35,933 4,862 33,976 5,454 35,963 Feb Dec 5,741 5,800 5,891 6,529 6,598 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 Jan 5,470 6,143 6,514 7,328 7,010 Apr Feb 5,714 5,490 6,528 5,568 6,416 May Mar 5,493 5,943 5,960 6,411 6,556 June Apr 5,593 5,668 5,110 7,162 6,480 May 5,602 5,959 4,699 6,472 6,260 June 3,607 3,276 2,611 4,365 3,816 Governmental Funds Revenue (Dollars in Thousands) Governmental Funds Revenue 500,000.00 2017-18 Actuals 450,000.00 2018-19 Actuals 400,000.00 2019-20 Actuals 350,000.00 2020-21 Actuals 300,000.00 2021-22 Actuals 250,000.00 21-22 Budget 200,000.00 150,000.00 100,000.00 50,000.00 - FY 17-18 18-19 19-20 20-21 21-22 21-22 Budget July Aug 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 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 YTD thru November 876,652 897,854 927,390 1,060,177 1,091,157 1,214,466 Jan Feb Dec 192,262 221,971 226,582 236,818 288,968 Jan 187,522 170,844 209,806 216,626 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 - Mar Apr Feb 176,559 173,462 187,061 178,738 237,296 May Mar 167,449 187,169 217,521 272,444 276,766 June Apr 217,138 210,659 180,484 316,241 313,183 May 223,002 245,256 226,625 277,929 321,346 June 252,080 280,540 378,887 362,173 439,548 Aviation Revenues (Dollars in Thousands) Aviation Operating Revenues 100,000 17-18 Actuals 90,000 18-19 Actuals 80,000 19-20 Actuals 70,000 20-21 Actuals 60,000 21-22 Actuals 50,000 21-22 Budget 40,000 30,000 20,000 10,000 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 Oct 29,291 31,719 32,056 21,045 31,904 30,679 YTD thru Nov November 21,702 142,509 32,312 159,332 33,532 161,337 23,880 100,171 36,031 166,917 29,957 151,457 Feb Mar Apr Dec 38,212 30,496 36,787 31,636 36,868 Jan 32,543 31,205 34,297 18,059 31,215 Feb 30,671 32,944 34,215 61,877 42,937 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 Mar 33,070 33,075 34,228 25,487 33,838 June Apr 37,265 37,847 27,255 31,454 35,978 May 32,447 34,396 23,524 30,668 32,540 June 38,986 35,938 10,702 91,844 47,713 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 YTD thru November 222,357 207,962 230,214 253,397 228,857 249,914 Dec 27,184 25,048 26,405 33,139 30,565 Jan 25,186 22,565 25,330 28,579 27,799 Feb 22,704 21,558 25,643 25,188 26,003 Mar 23,806 20,138 24,861 28,415 26,585 Apr 31,392 31,150 29,080 37,714 35,367 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 - May 38,031 36,293 40,442 42,556 43,020 June 43,736 38,106 52,141 43,174 48,444 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 Oct 20,195 23,028 20,975 22,234 18,312 22,243 Dec Jan YTD thru Nov November 20,386 101,964 19,734 102,273 21,142 106,457 18,577 106,651 21,720 110,961 20,547 107,405 Feb Mar Apr May June Dec 20,097 20,469 20,888 24,461 22,110 Jan 20,584 22,113 22,063 18,430 21,409 Feb 19,499 19,436 20,973 24,355 21,685 Mar 20,517 19,960 21,613 21,754 21,577 Apr 18,079 21,256 18,428 21,584 20,420 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 - May 20,160 20,980 23,948 20,085 21,919 June 18,345 16,544 18,289 17,424 18,170