November 2020 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division November 30, 2020 To the Mayor and City Council: This is the City's Financial Report for November, the fifth month of fiscal year 2020-21. 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, Denise Olson Chief Financial Officer Joe Jatzkewitz Deputy Finance Director December 21, 2020 CITY AUDITOR REPORT To the Chief Financial Officer, We have assessed the Finance Department’s (Finance) November 2020 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 October 7, 2020. 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, Aaron Cook Deputy City Auditor for Ross Tate City Auditor City of Phoenix Monthly Financial Report November 2020 Table of Contents Expenditures by Programs Page Performance Status General Fund Expenditures Report Navigation General Fund Total Expenditures 1 Better than Expected General Government 1 Better than Expected Click on either the schedule name or the Criminal Justice 2 Better than Expected performance status in the table of contents to Public Safety 2 Better than Expected be taken directly to that page of the report. Transportation 3 Better than Expected Community Development 3 Better than Expected From any page of the report, click on the Community Enrichment 4 Better than Expected City of Phoenix Bird Emblem to return to the Environmental Services 4 Better than Expected Table of Contents Citywide Expenditures Citywide Total Operating Expenditures 5 Better than Expected General Government 5 Monitor and Consider Taking Action Criminal Justice 6 Better than Expected Performance Status Public Safety 6 Better than Expected Better than Expected - Positive variance of Transportation 7 Better than Expected greater than 1% actual vs budget. Community Development 7 Expected Community Enrichment 8 Better than Expected positive or negative. Environmental Services 8 Better than Expected Monitor and Consider Taking Action - Negative General Obligation Debt Service 9 Expected Expected - Actual vs budget variance within 1% variance greater than 1% actual vs budget. Capital Expenditures CIP-General Government 10 Corrective Action Taken - Negative variance CIP-Aviation 10 greater than 1% actual vs budget, however the CIP-Phoenix Convention Center 11 City has taken action to address the negative CIP-Solid Waste Disposal 11 variance. CIP-Wastewater 12 CIP-Water System 12 Revenues by Source General Fund Total Operating Revenue Page Performance Status 13 Better than Expected Property Tax 14 Monitor and Consider Taking Action Local Sales Tax 15 Better than Expected State Sales Tax 16 Better than Expected Vehicle License Tax 17 Better than Expected Governmental Funds 18 Monitor and Consider Taking Action Aviation 19 Monitor and Consider Taking Action Water System 20 Better than 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 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 16-17 17-18 18-19 19-20 20-21 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 476,731 1,105,361 43.1% 512,361 1,177,280 43.5% 525,696 1,214,362 43.3% 577,295 1,282,831 45.0% 570,279 1,388,617 41.1% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustment for contingencies. Better than Expected Total General Fund General Government $1,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 YTD Expenditures Expenditures $600,000 $600,000 Annual Annual Expenditures Expenditures * * $400,000 $400,000 $200,000 $200,000 $0 $0 16-17 17-18 16-17 18-19 19-20 20-21 17-18 18-19 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 2020-21 budgeted general fund expenditures are 8.2% higher than the fiscal year 2019-20 actuals. Fiscal year 2020-21 actual general fund expenditures through November are 1.2% lower than the same period in fiscal year 2018-19. General fund expenditures increased 5.6% in fiscal year 2019-20 over fiscal year 2018-19. This followed increases of 3.1% and 6.5% in the two prior years. General Government 16-17 17-18 18-19 19-20 20-21 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 50,519 106,754 47.3% 53,558 110,408 48.5% 55,587 114,393 48.6% 65,261 123,100 53.0% 63,801 152,890 41.7% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice General 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 November Expenditures YTD Expenditures Annual Expenditures * Annual Expenditures * 16-1717-18 16-17 17-18 18-19 19-20 18-19 20-21 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 2020-21 budget includes a 24.2% increase over fiscal year 2019-20 actuals. General fund general government expenditures through November are 2.2% lower than the same period in the prior fiscal year. General fund general government expenditures increased 7.6% in fiscal year 2019-20 over fiscal year 2018-19. This followed increases of 3.6% and 3.4% 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 Criminal Justice November YTD Annual % of Annual Expenditures Expenditures * Expenditures 12,885 31,595 40.8% 13,726 32,232 42.6% 14,449 33,387 43.3% 14,947 35,033 42.7% 15,095 37,541 40.2% $40,000 * - For prior years-total actual expenditures, for current year-total approved budget $5,000 16-17 17-18 18-19 19-20 20-21 Better than Expected November YTD Expenditures $35,000 $30,000 $25,000 Annual Expenditures * $20,000 $15,000 $10,000 $0 16-17 17-18 18-19 19-20 20-21 Criminal justice expenditures include costs for municipal courts and public defenders. The fiscal year 2020-21 budget includes a 7.2% increase over fiscal year 2019-20 actuals. General fund criminal justice expenditures through November are 1.0% higher than the same period in the prior fiscal year. General fund criminal justice expenditures increased 4.9% in the fiscal year 2019-20 over fiscal year 2018-19. This followed increases of 3.6% and 2.0% in the prior two years. Public Safety Public Safety November YTD Annual % of Annual Expenditures Expenditures * Expenditures 328,745 764,482 43.0% 346,615 817,960 42.4% 354,763 841,467 42.2% 384,248 893,403 43.0% 390,569 944,681 41.3% $1,000,000 * - For prior years-total actual expenditures, for current year-total approved budget $0 16-17 17-18 18-19 19-20 20-21 November YTD Expenditures $800,000 $600,000 $400,000 Annual Expenditures * $200,000 16-17 17-18 18-19 19-20 20-21 Better than Expected Public safety expenditures include costs for police and fire services. The general fund public safety fiscal year 2020-21 budget includes a 5.7% increase over fiscal year 2019-20 actuals. Through November, general fund public safety expenditures are 1.6% higher than the prior fiscal year. General fund public safety expenditures increased 6.2% over fiscal year 2019-20 over the fiscal year 2018-19. This followed increases of 2.9% and 7.0% in the prior two years. 2 November General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Transportation Community Development Transportation November YTD Annual % of Annual Expenditures Expenditures * Expenditures 6,979 17,878 39.0% 9,603 16,366 58.7% 10,009 18,337 54.6% 9,729 19,748 49.3% 8,640 20,762 41.6% $1 $30,000 * - For prior years-total actual expenditures, for current year-total approved budget $0 16-17 17-18 18-19 19-20 20-21 Better than Expected $1 Series1 November YTD Expenditures $1 $20,000 $1 $0 $10,000 Annual Series2 Expenditures * $0 $0 16-17 17-18 18-19 19-20 20-21 Transportation expenditures include costs for public transit and street maintenance and repair. General Fund transportation expenditures for fiscal year 2020-21 are budgeted to increase 5.1% over fiscal year 2019-20 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 11.2% lower than the same period in the prior fiscal year. Community Development 16-17 17-18 18-19 19-20 20-21 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 8,274 19,709 42.0% 9,135 20,243 45.1% 9,024 21,238 42.5% 10,088 22,542 44.8% 9,956 24,761 40.2% * - For prior years-total actual expenditures, for current year-total approved budget Community Development $30,000 November YTD Expenditures $25,000 $20,000 $15,000 $10,000 Annual Expenditures * $5,000 $0 16-17 Better than Expected 17-18 18-19 19-20 20-21 Community development expenditures include costs for economic development and neighborhood services. The fiscal year 2020-21 budget includes a 9.8% increase over fiscal year 2019-20 actuals. General fund community development expenditures through November are 1.3% lower than the same period in the prior fiscal year. General fund community development expenditures increased in fiscal year 2019-20 over fiscal year 2018-19 by 6.1%. This follows a year over year increase of 4.9% in fiscal year 2018-19 and 2.7% increase in the 2017-18 fiscal year. 3 November General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Community Enrichment Community Enrichment November YTD Annual % of Annual Expenditures Expenditures * Expenditures 63,283 146,749 43.1% 68,040 156,325 43.5% 70,699 156,552 45.2% 78,393 155,417 50.4% 70,922 169,541 41.8% $200,000 * - For prior years-total actual expenditures, for current year-total approved budget $0 16-17 17-18 18-19 19-20 20-21 November YTD Expenditures $160,000 $120,000 Annual Expenditures * $80,000 $40,000 16-17 17-18 18-19 19-20 20-21 Better than Expected Community enrichment expenditures include costs for parks, recreational activities, senior centers and community centers. The fiscal year 2020-21 budget includes a 9.1% increase over fiscal year 2019-20 actuals. Through November, general fund community enrichment expenditures are 9.5% lower than the same period in the prior fiscal year. General fund community enrichment expenditures decreased 0.7% in fiscal year 2019-20 over fiscal year 2018-19. This followed increases of 0.1% and 6.5% in the prior two years. Environmental Services 16-17 17-18 18-19 19-20 20-21 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 4,669 12,775 36.5% 6,167 12,624 48.9% 7,929 16,886 47.0% 11,511 19,180 60.0% 8,162 18,799 43.4% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services $24,000 November YTD Expenditures $20,000 $16,000 $12,000 $8,000 Annual Expenditures * $4,000 $0 16-17 Better than Expected 17-18 18-19 19-20 20-21 Environmental service expenditures include costs for maintaining and operating city facilities. The fiscal year 2020-21 budget includes a 2.0% decrease from fiscal year 2019-20 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 29.1% lower 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 16-17 17-18 18-19 19-20 20-21 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 1,440,496 3,468,589 41.5% 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,639,964 36.5% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustments for contingencies and use of the early redemption fund. Total Citywide $5,000,000 November YTD Expenditures $4,000,000 $3,000,000 $2,000,000 Annual Expenditures * $1,000,000 $0 16-17 17-18 18-19 19-20 20-21 Better than Expected In order to have a better comparison to prior year actuals, coronavirus relief fund, contingencies and vacancy savings will only be included in the annual budget to the extent that they have been spent. Without coronavirus relief fund, contingencies and vacancy savings, the budget for fiscal year 2020-21 anticipates an increase of 21.6% over fiscal year 2019-20 actuals in total operating expenditures. Actual expenditures through November are 1.2% lower than the same period in the prior fiscal year. General Government 16-17 17-18 18-19 19-20 20-21 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 54,419 121,863 44.7% 61,861 134,117 46.1% 58,050 138,349 42.0% 72,526 157,200 46.1% 95,595 178,719 53.5% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action General Government $200,000 November YTD Expenditures $150,000 $100,000 Annual Expenditures * $50,000 $0 16-17 17-18 18-19 19-20 20-21 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 31.8% higher than the same period in the prior fiscal year. The budget anticipates an increase of 13.7% for fiscal year 2020-21 over fiscal year 201920 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. 5 November Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Criminal Justice 16-17 17-18 18-19 19-20 20-21 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 16,779 41,117 40.8% 16,344 38,411 42.6% 15,345 42,530 36.1% 18,917 44,425 42.6% 18,631 47,008 39.6% * - For prior years-total actual expenditures, for current year-total approved budget Criminal Justice $50,000 November YTD Expenditures $40,000 $30,000 Annual Expenditures * $20,000 $10,000 $0 16-17 Better than Expected 17-18 18-19 19-20 20-21 Criminal Justice expenditures include costs of the Municipal Court and the Public Defender’s office. Citywide criminal justice expenditures are 1.5% lower through November than the same period in the prior fiscal year. The budgeted increase for fiscal year 2020-21 over fiscal year 2019-20 actuals is 5.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 16-17 17-18 18-19 19-20 20-21 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 385,594 908,553 42.4% 408,807 970,771 42.1% 424,761 1,025,513 41.4% 468,014 1,110,457 42.1% 476,226 1,165,317 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 * 16-17 17-18 18-19 19-20 20-21 Better than Expected Public Safety expenditures include costs of Police, Fire and Emergency Management. Citywide public safety expenditures through November are 1.8% higher than the same period in the prior fiscal year. The budgeted increase for fiscal year 2020-21 over fiscal year 2019-20 actuals is 4.9%. 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 16-17 17-18 18-19 19-20 20-21 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 351,910 642,850 54.7% 405,867 709,977 57.2% 371,528 722,667 51.4% 472,103 774,492 61.0% 394,525 952,224 41.4% * - For prior years-total actual expenditures, for current year-total approved budget Transportation $1,000,000 $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $0 November YTD Expenditure s Annual Expenditure s* 16-17 Better than Expected 17-18 18-19 19-20 20-21 Transportation expenditures include costs for Street lighting, maintenance and repair, Aviation and Public Transit. Citywide transportation expenditures are 16.4% lower through November than the same period in the prior fiscal year. The budget anticipates an increase of 22.9% for fiscal year 2020-21 from fiscal year 2019-20 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. Community Development 16-17 17-18 18-19 19-20 20-21 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 76,224 188,365 40.5% 84,836 203,096 41.8% 81,107 195,716 41.4% 86,634 229,793 37.7% 102,567 273,969 37.4% * - For prior years-total actual expenditures, for current year-total approved budget Expected Community Development $300,000 November YTD Expenditures $250,000 $200,000 $150,000 Annual Expenditures * $100,000 $50,000 $0 16-17 17-18 18-19 19-20 20-21 Community Development expenditures include costs for Neighborhood Services, Housing, Planning and Economic Development. Citywide community development expenditures through November are 18.4% higher than the same period in the prior fiscal year. The fiscal year 2020-21 budget includes an increase of 19.2% over fiscal year 2019-20 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. 7 November Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Community Enrichment 16-17 17-18 18-19 19-20 20-21 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 125,030 292,983 42.7% 133,615 306,763 43.6% 130,783 317,465 41.2% 155,703 316,680 49.2% 170,427 368,384 46.3% * - For prior years-total actual expenditures, for current year-total approved budget Community Enrichment $400,000 $350,000 $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 $0 November YTD Expenditures Annual Expenditures * 16-17 17-18 18-19 19-20 20-21 Better than Expected Community Enrichment expenditures include costs for Parks, Libraries, the Convention Center, Senior Centers and Community Centers. Citywide community enrichment expenditures through November are 9.5% higher than the same period in the prior fiscal year. The fiscal year 2020-21 budget anticipates an increase of 16.3% from fiscal year 2019-20 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. Environmental Services 16-17 17-18 18-19 19-20 20-21 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 254,857 599,837 42.5% 263,420 696,244 37.8% 212,378 670,219 31.7% 299,773 692,524 43.3% 308,609 762,498 40.5% * - 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 * 16-17 17-18 18-19 19-20 20-21 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.9% higher through November than the same period in the prior fiscal year. The fiscal year 2020-21 budget anticipates an increase of 10.1% from fiscal year 2019-20 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 16-17 17-18 18-19 19-20 20-21 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 58,713 137,205 42.8% 44,563 106,315 41.9% 222,263 116,634 190.6% 54,429 130,839 41.6% 55,179 132,332 41.7% * - 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 16-17 17-18 18-19 19-20 20-21 Expected General obligation debt service expenditures through November are 1.4% higher than the same period in the prior fiscal year. Budgeted expenditures for fiscal year 2020-21 are 1.1% higher than fiscal year 2019-20 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 16-17 17-18 $ 315,502 $ 290,772 Refer to detailed financial schedules pages 22 - 34 18-19 $ 19-20 384,131 20-21 (Budget) 20-21 (YTD) $ $ 336,644 $ 500,745 Discussion: 1,848,001 General Gov't Major projects in fiscal year 2016-17 include street construction, repair and maintenance ($75 million), bus replacement ($50 million), sidewalks, traffic signals, bridges, bike lanes and street lighting improvements and maintenance ($38 million), parks, preserves and recreation facility improvements ($37 million), wireless communication in the regional bus system ($25 million), and the 48th St and Washington Light Rail Station ($20 million). 20-21 (YTD) 20-21 (Budget) 19-20 18-19 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). 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) . 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). 17-18 16-17 $0 $500,000 $1,000,000$1,500,000$2,000,000 Major projects budgeted for fiscal year 2020-21 include light rail ($990 million), pavement maintenance ($125 million), major streets ($90 million), Talking Stick renovation ($124.5 million), parks and recreations and preserves ($88.6 million), and replace fare collecton system ($57.3 million). Aviation 16-17 17-18 $ 151,957 $ 582,921 18-19 $ 552,972 19-20 20-21 (Budget) 20-21 (YTD) $ $ $ 254,523 517,947 90,783 Discussion: Aviation 19-20 Major projects in fiscal year 2016-17 include runway, apron and taxiway projects ($21 million), Communications Center/EOC Design and Construction ($14 million), Terminal 3 Development ($12 million), and PHX Sky Train phase 2 ($10 million). Aviation capital expenditures for fiscal year 2016-17 also includes $70 million of debt service. 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). 18-19 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 (YTD) 20-21 (Budget) 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). 17-18 16-17 $0 $200,000 $400,000 $600,000 Major projects budgeted for fiscal year 2020-21 include Union Pacific Railroad grade (trench) separation project ($74M), Runway, Apron and Taxiway Improvements ($73M), PHX Terminal 4 south concorse and gates ($71M), PHX Sky Train ($21M) and rental car center and parking facilities ($20M). - 10 - Capital Expenditures (Dollars in Thousands) Phx Convention Ctr 16-17 17-18 $ 21,885 $ 28,898 Refer to detailed financial schedules pages 22 - 34 18-19 $ 20-21 (Budget) 19-20 36,542 $ 52,148 Discussion: $ 43,609 20-21 (YTD) $ 14,198 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. Other major projects budgeted for fiscal year 2020-21 include shoring wall ($7 million), garage elevator ($3 million), arena plumbing ($3 million) and replacing wood veneer ($1.5 million). 16-17 $ Solid Waste 7,460 20-21 (YTD) 20-21 (Budget) 19-20 18-19 17-18 16-17 $0 17-18 $ 10,355 18-19 $ 7,857 $10,000 20-21 (Budget) 19-20 $ 5,490 $ 31,309 $20,000 $30,000 $40,000 $50,000 $60,000 20-21 (YTD) $ 1,184 Discussion: Solid Waste In fiscal year 2015-16, Solid Waste spent $2.5 million on the 27th Ave Resource Innovation Campus. 20-21 (YTD) 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. 20-21 (Budget) 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 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 18-19 Major projects budgeted for fiscal year 2020-21 include $21.1 million in transfer stations, $4.3 million SR-85, and $2.5 million for solid waste projects and unexpected expenditures. 17-18 16-17 $0 $10,000 $20,000 $30,000 $40,000 - 11 - Capital Expenditures (Dollars in Thousands) 16-17 Wastewater $ 106,776 Refer to detailed financial schedules pages 22 - 34 17-18 $ 105,912 18-19 $ 97,890 19-20 20-21 (Budget) 20-21 (YTD) $ 123,141 $ 312,589 $ 25,013 Discussion: In fiscal year 2016-17, Wastewater spent $30 million to construct, replace or rehabilitate pipelines, $25 million for the construction of the biogas project at the 91st Avenue Wastewater Treatment Plant, $16 million for improvements at the 91st Avenue wastewater treatment plant, and $10 million for improvements at the 23rd Avenue wastewater treatment plant. 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. 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 on lift stations. Wastewater 20-21 (YTD) 20-21 (Budget) 19-20 18-19 17-18 16-17 $0 $100,000 $200,000 $300,000 $400,000 Major projects budgeted in fiscal year 2020-21 include sewer replacement and construction ($151.2 million), buildings ($47.3 million), 23rd Ave ($40.6 million), and 91st Ave ($38.4 million). 16-17 Water System $ 189,809 17-18 $ 229,256 18-19 $ 289,858 19-20 20-21 (Budget) 20-21 (YTD) $ 252,146 $ 605,241 $ 36,274 Discussion: In fiscal year 2016-17, Water spent $65 million to construct, replace or rehabilitate pipelines and valves, $19 million for rehabilitation at the Deer Valley water treatment plant, $15 million for reservoir rehabilitation and $10 million for water resiliency. 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. Water System 20-21 (YTD) 20-21 (Budget) 19-20 18-19 17-18 16-17 $0 $100,000 $200,000 $300,000 Major projects budgeted in fiscal year 2020-21 include water main replacement and construction ($255.0 million), boosters ($179.9 million), Water Treatment Plants ($39.9 million), and pressure reducing valve stations ($29.5 million). - 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,400,000 $1,200,000 November YTD Revenues $1,000,000 $800,000 $600,000 $400,000 Annual Revenues* $200,000 $0 16-17 16-17 17-18 18-19 19-20 20-21 November YTD Revenues 428,724 470,755 480,878 521,391 635,240 17-18 Annual Revenues* 1,094,933 1,162,635 1,220,768 1,307,357 1,309,519 18-19 19-20 20-21 % of Annual Revenues 39.2% 40.5% 39.4% 39.9% 48.5% * - For prior years - total actual revenues, for current year - total approved budget Better than Expected Fiscal year 2020-21 general fund operating revenues are budgeted to increase 0.2% 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 21.8% higher than the same period in the prior fiscal year. Specific revenue sources are discussed on the following pages. - 13 - Property Tax Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Property Taxes Primary & Secondary 270,000 240,000 210,000 95,435 91,021 180,000 101,652 113,594 107,555 Secondary 150,000 120,000 90,000 154,560 146,121 60,000 162,129 43,770 170,209 179,950 Primary 68,510 30,000 16-17 FY 16-17 17-18 18-19 19-20 20-21 YTD 20-21 Budget Total 237,142 249,995 263,781 277,764 112,280 293,545 July (1,004) (1,054) (1,049) (1,141) (1,619) (1,203) 17-18 Aug 454 (395) 688 1,081 1,541 510 Sept 773 891 980 647 1,288 934 18-19 Oct 12,067 16,220 12,601 11,579 21,550 14,982 Nov 57,953 87,691 91,331 106,458 89,520 105,871 19-20 Dec 51,488 25,018 30,444 23,612 29,325 20-21 YTD Jan 10,013 10,162 13,302 14,875 14,218 Feb 4,033 7,020 5,422 7,447 7,376 20-21 Budget Mar 6,593 8,086 8,130 8,185 9,049 Apr 12,231 11,994 12,026 12,116 13,401 May 60,943 52,962 68,870 66,043 69,674 June 21,598 31,400 21,036 26,862 29,408 Note: Monthly budget amount for 20-21 is the average % of last 3 years of the total budget amount Monitor and Consider Taking Action 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 5.7% in fiscal year 2020-21 over fiscal year 2019-20 actuals. - 14 - Primary Secondary 146,121 91,021 154,560 95,435 162,129 101,652 170,209 107,555 68,510 43,770 179,950 113,594 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 20-21 Actuals 30,000 20-21 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 2020-21 local sales tax revenues through November are 18.0% higher than the same period in the prior year. Actual local sales tax revenues through November are 18.3% higher than budget expectations. Local Sales Tax 3 Year Trend 70,000 60,000 50,000 18-19 Actuals 40,000 19-20 Actuals 30,000 20-21 Actuals 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2019-20 local sales tax revenues were 2.5% higher than the prior year. This follows increases of 10.5% and 2.8% 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 25,000 20,000 15,000 20-21 Actuals 10,000 20-21 Budget 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 2020-21 budget includes an increase of 1.2% in state shared sales tax over fiscal year 2019-20 actuals. Through November state shared sales tax revenues are 9.9% above budget expectations. State Sales Tax 3 Year Trend 25,000 20,000 15,000 18-19 Actuals 19-20 Actuals 10,000 20-21 Actuals 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2019-20 state sales tax revenues were 4.2% higher than the prior year. This follows increases of 5.8% and 8.4% 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 20-21 Actuals 6,000 20-21 Budget 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Better than Expected State shared vehicle license tax revenues through November 2020 are 13.2% higher than budget expectations for the period. Vehicle License Tax 3 Year Trend 12,000 10,000 18-19 Actuals 8,000 19-20 Actuals 6,000 20-21 Actuals 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2019-20 state shared vehicle license tax revenues were 0.4% higher than the prior year. This follows increases of 5.1% and 8.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 400,000.00 350,000.00 300,000.00 20-21 Budget 250,000.00 200,000.00 2020-21 Actuals 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 2020 are 4.9% lower than budget expectations for the period. Governmental Funds Revenues 3 Year Trend 260,000.00 210,000.00 160,000.00 2018-19 Actuals 110,000.00 2019-20 Actuals 60,000.00 2020-21 Actuals 10,000.00 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June (40,000.00) Fiscal year 2019-20 governmental fund revenues were 7.0% higher than the prior year. This follows increases of 4.1% and 4.9% 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 45,000 40,000 35,000 30,000 20-21 Actuals 25,000 20,000 20-21 Budget 15,000 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Monitor and Consider Taking Action Aviation operating revenues through November 2020 are 42.2% lower than budget expectations for the period. August 2020 revenue decrease is also attributed to a multi-month COVID concession relief primarily for retail food and beverage and car rental companies. Aviation Operating Revenues 3 Year Trend 40,000 35,000 30,000 25,000 18-19 Actuals 20,000 19-20 Actuals 15,000 20-21 Actuals 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr Fiscal year 2019-20 aviation revenues were 8.3% lower than the prior year. This follows increases of 2.5% and 8.7% in the two previous years. Click Here for Additional Information - 19 - May 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 20-21 Actuals 30,000 20-21 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 Water system revenues through November 2020 are 3.4% higher than budget expectations for the period. Water System Operating Revenues 3 Year Trend 70,000 60,000 50,000 40,000 18-19 Actuals 30,000 19-20 Actuals 20,000 20-21 Actuals 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2019-20 water system revenues were 12.7% higher than the prior year. This follows decrease of 7.3% and increase of 4.0% 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 25,000 20,000 15,000 20-21 Budget 10,000 20-21 Actuals 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 2020 are 1.9% higher than budget expectations for the period. Wastewater Operating Revenues 3 Year Trend 30,000 25,000 20,000 18-19 Actuals 15,000 19-20 Actuals 10,000 20-21 Actuals 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr Click Here for Additional Information - 21 - May 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 2020-2021 2019-2020 Budget Estimate 2020-2021 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 $ 503,367 3,050 $ 233,110 $ 651 197,602 327 174,072 241,167 71,743 179,950 2,960 10,120 81,650 100,099 35,933 68,510 1,032 2,096 77,208 89,457 33,171 72,388 1,094 2,535 11,548 1,296 15,481 768 7,559 1,808 6,663 3,455 444 50,349 58 1,555 567 2,226 4,518 454 3,942 201 2,951 691 3,065 37,875 1,400 13,660 9,420 15,613 11,731 347 33,134 2,319 5,974 15,450 342 5,446 4,362 6,188 1,309,520 - 22 - $ 635,241 $ 521,392 General Fund Expenditures As of NOVEMBER 30 (dollars in thousands) Actual Year-to-Date 2020-2021 2019-2020 Budget Estimate 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,244 5,444 5,971 52,412 2,780 2,761 26,183 3,205 7,285 12,969 3,975 26,013 1,648 152,890 $ 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 689 1,652 1,713 23,885 1,023 935 9,961 1,315 2,871 5,272 1,834 11,962 2,149 65,261 Criminal Justice Municipal Court Public Defender Total Criminal Justice 32,161 5,380 37,541 13,140 1,955 15,095 12,929 2,018 14,947 Public Safety Police Fire Others Total Public Safety 591,932 352,507 242 944,681 248,532 141,819 218 390,569 239,493 144,596 159 384,248 Transportation Street Transportation Public Transit Total Transportation 18,976 1,786 20,762 7,551 1,089 8,640 8,089 1,640 9,729 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 6,251 14,033 4,308 169 24,761 2,282 5,803 1,786 85 9,956 2,483 6,042 1,512 51 10,088 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 101,808 40,896 19,978 6,859 169,541 40,857 19,354 7,549 3,162 70,922 45,516 19,560 9,059 4,258 78,393 Environmental Services Public Works Environmental Programs Others Total Environmental Services 17,643 732 424 18,799 7,523 335 304 8,162 11,332 179 11,511 Capital Improvement 19,643 3,134 3,118 Vacancy Savings (18,600) - - Contingencies 55,596 - - 570,279 $ 577,295 Total Expenditures and Encumbrances $ 1,425,613 - 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 2020-2021 2019-2020 Budget Estimate 2020-2021 $ 503,367 3,050 233,110 $ 651 197,602 327 174,072 241,167 71,743 179,950 2,960 10,120 12,844 15,481 768 7,559 1,808 6,663 52,935 9,420 15,613 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 77,208 89,457 33,171 72,388 1,094 2,535 4,972 3,942 201 2,951 691 3,065 21,238 4,362 6,188 1,309,520 635,241 521,392 37,176 96,479 38,831 6,274 292,698 5,760 72,140 8,539 24,970 146,284 41,124 5,987 47,489 750,940 118,206 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 14,038 38,186 14,483 1,874 113,325 1,228 40,315 3,752 8,136 59,556 11,382 7,317 7,361 38,809 46,236 1,692,894 424,937 405,999 425,915 87,381 479,782 249,814 175,132 100,171 20,302 253,397 106,651 70,660 161,337 29,926 230,214 106,457 61,364 1,418,024 551,181 589,297 4,420,438 - 24 - $ $ 1,611,359 $ 1,516,689 Citywide Operating Expenditures As of NOVEMBER 30 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2020-2021 2019-2020 Budget 2020-2021 63,801 $ 31,794 95,595 65,261 7,265 72,526 37,541 9,467 47,008 15,095 3,536 18,631 14,947 3,970 18,917 Public Safety General Funds Other Funds Total Public Safety 944,681 220,636 1,165,317 390,569 85,657 476,226 384,248 83,766 468,014 Transportation General Funds Other Funds Total Transportation 20,762 931,462 952,224 8,640 385,885 394,525 9,729 462,374 472,103 Community Development General Funds Other Funds Total Community Development 24,761 249,208 273,969 9,956 92,611 102,567 10,088 76,546 86,634 Community Enrichment General Funds Other Funds Total Community Enrichment 169,541 198,843 368,384 70,922 99,505 170,427 78,393 77,310 155,703 Environmental Services General Funds Other Funds Total Environmental Services 18,799 743,699 762,498 8,162 300,447 308,609 11,511 288,262 299,773 Debt Service General Funds Other Funds Total Debt Service 132,332 132,332 55,179 55,179 54,429 54,429 Capital Improvement General Funds Other Funds Total Capital Improvement 19,643 739,871 759,514 3,134 68,721 71,855 3,118 82,670 85,788 Coronavirus Relief Fund General Funds Other Funds Total Coronavirus Relief Fund 275,000 - Vacancy Savings General Funds Other Funds Total Vacancy Savings (18,600) (18,600) - - Contingencies General Funds Other Funds Total Contingencies 55,596 68,500 124,096 - - 1,425,614 3,319,847 5,020,460 570,279 1,123,335 1,693,614 $ $ Criminal Justice General Funds Other Funds Total Criminal Justice Total Operating General Funds Other Funds Total Operating Budget $ 152,890 25,829 178,719 $ $ - 25 - 577,295 1,136,592 1,713,887 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 2020 2019 Budget Estimate 2020-2021 Source Actual Year-to-Date 2020-2021 2019-2020 General Funds $ 52,187,758 109,085 52,296,843 13,095,373 20,019,769 4,608,198 $ 40,325,500 66,088 Local Taxes: Sales Taxes Privilege License Fees $ 503,367,000 3,050,000 $ 233,109,949 650,543 $ 197,602,407 327,001 40,391,588 Total Local Taxes 506,417,000 233,760,492 197,929,408 16,442,455 17,891,434 5,408,064 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 174,072,000 241,167,000 71,743,000 81,649,983 100,098,849 35,933,330 77,207,552 89,457,172 33,171,172 37,723,340 39,741,953 486,982,000 217,682,162 199,835,896 54,640,534 64,972,210 Primary Property Tax 179,950,000 68,510,280 72,388,006 247,798 237,914 Licenses and Permits 2,960,000 1,032,175 1,094,019 2,157,274 0 Cable Communications 10,120,000 2,096,380 2,534,509 851,356 81,651 Municipal Court: Fines and Forfeitures Court Default Fee 11,548,248 1,296,000 3,455,107 443,927 4,517,859 454,474 632,539 66,339 698,878 933,007 1,489,286 1,264,319 Total State Shared Taxes Total Municipal Court Police 12,844,248 3,899,034 4,972,333 15,480,700 50,349,262 3,941,623 (3,776) 35,162 Library Fees 767,713 58,133 201,308 511,975 935,662 Parks and Recreation 7,559,338 1,555,219 2,950,569 122,709 91,580 Planning and Development 1,808,200 566,802 691,372 409,746 705,968 Street Transportation 6,662,600 2,226,262 3,064,573 2,081,638 78,825 1,023,118 3,164,166 77,225 136,942 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other 37,875,000 1,400,000 13,659,600 11,730,697 346,850 33,134,404 15,450,165 341,600 5,445,996 3,183,581 3,378,333 52,934,600 45,211,951 21,237,761 410,617 842,339 9,420,000 2,319,228 4,361,652 2,588,683 2,426,276 156,477,488 155,956,311 Total Fire Interest Other Fees and Service Charges Total General Funds 26 15,612,775 5,973,638 6,188,438 1,309,519,174 635,241,018 521,391,467 Citywide Operating Revenue by Source (continued) For the Month Ended NOVEMBER 30 2020 2019 Budget Estimate 2020-2021 Source Actual Year-to-Date 2020-2021 2019-2020 Special Revenue and Debt Service Funds $ 2,484,754 177,482 887,413 35,299 $ 3,584,948 8,685,035 3,262,000 17,301 2,007,130 143,366 716,832 36,341 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 2,903,669 Total Neighborhood Protection $ $ $ 6,367,144 2,237,542 39,402 3,684,300 $ 3,001,734 470,141 0 263,465 953 46,985 $ $ $ $ $ 369,561 0 188,290 (81) 33,286 11,964,336 8,644,088 781,544 24,078,289 798,872 $ $ 24,877,161 $ 9,578,086 684,149 3,420,745 355,496 37,176,000 18,630,402 14,038,476 72,595,000 23,277,000 606,510 30,951,355 10,077,590 10,368,937 28,447,915 9,490,863 247,365 96,478,510 51,397,882 38,186,143 Parks and Preserves 38,830,728 16,006,370 14,482,725 Golf Courses: Fees Coffee Shops Concessions Interest Other 3,948,300 0 2,054,000 1,540 269,816 1,556,870 0 967,454 6,629 188,980 1,048,274 0 650,549 1,382 173,614 2,719,933 1,873,819 19,631,035 3,514,381 Transit 2000 & 2050: Sales Taxes Interest/Other 249,230,000 43,467,791 104,471,766 4,582,293 93,405,119 19,920,256 292,697,791 109,054,059 113,325,375 Court Awards 5,759,602 17,948 1,228,170 Planning and Development 72,139,500 35,841,777 40,315,255 Capital Construction 8,539,000 2,957,794 3,752,292 Sports Facilities: Sales Taxes Interest/Other 20,558,000 4,411,906 3,590,560 1,070,691 6,819,966 1,315,609 24,969,906 4,661,251 8,135,575 0 5,497,985 438,962 $ 759,363 1,030,392 10,720,518 765,751 3,828,757 3,315,376 6,273,656 $ $ $ Total Public Safety Enhancement & Expansion $ Total Golf Courses 5,231,212 946,046 84,346 Public Safety Enhancement & Expansion Police Fire Interest/Other 25,578,000 1,827,000 9,134,000 637,000 591,056 23,145,416 (164,671) $ $ 1,334,342 148,143 1,482,485 Total Transit 2000 & 2050 Total Sports Facilities 27 Citywide Operating Revenue by Source (continued) For the Month Ended NOVEMBER 30 2020 2019 Source Budget Estimate 2020-2021 Actual Year-to-Date 2020-2021 2019-2020 145,124,000 1,000,000 160,000 59,276,120 342,513 5,285 57,920,790 775,468 859,605 146,284,000 59,623,918 59,555,863 Special Revenue and Debt Service Funds (Cont'd) $ 11,905,530 60,104 0 10,859,831 150,967 267,415 11,965,634 11,278,213 - $ - Highway User Revenue: Highway User Revenue Interest Other Total Highway User Revenue Local Transportation Assistance 0 0 0 5,232,221 2,854,945 Regional Transit Revenues 41,123,538 4,781,182 11,381,733 15,594 35,225 Community Reinvestment 5,987,227 2,273,520 7,317,463 98,532 833,084 Other Restricted Fees 47,489,334 2,800,195 7,360,740 8,287,450 99,730,276 22,242,602 2,804,033 43,251,422 3,298,785 3,334,996 34,833,915 4,787,940 130,260,328 49,354,240 42,956,851 58,963,098 180,910,504 53,374,820 327,430,851 18,253,547 2,298,561 (659,958) 1,145,970 8,622,624 (17,103,002) (805,668) 5,138,431 609,368 8,334,428 635,566 646,049 4,682,003 924,974 9,579,362 6,253,026 4,712,018 19,632,127 733,587 3,606,966 616,984 216,502 28,748 3,542,465 Grants: Public Housing: Rentals Grants Other $ Total Public Housing Other: Human Resources Federal Transit Administration Community Development Other 28,684,698 4,404,699 Total Other 620,679,273 21,038,120 (4,147,615) 38,264,060 10,657,725 Total Grants 750,939,601 70,392,360 38,809,236 34,880,985 3 41,485,901 0 113,594,000 4,611,597 43,770,489 7,787 46,235,642 750 34,880,988 41,485,901 118,205,597 43,778,276 46,236,392 141,885,213 113,170,889 1,692,893,990 424,936,867 405,999,257 116,487,500 295,282,200 2,424,900 5,293,420 2,697,600 3,729,600 0 32,786,290 61,641,649 1,234,391 1,438,083 1,275,525 1,184,170 610,640 46,575,991 107,609,571 1,822,851 1,315,823 1,274,510 1,449,746 1,288,187 425,915,220 100,170,748 161,336,679 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,003,673 15,782,592 199,310 370,851 281,818 137,442 103,565 9,626,129 22,496,928 338,597 153,497 239,266 424,826 252,040 23,879,251 33,531,283 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 2020 2019 Budget Estimate 2020-2021 Source Actual Year-to-Date 2020-2021 2019-2020 Enterprise Funds (Cont'd) CONVENTION CENTER: $ 5,393,464 368,471 39,671 4,492,762 2,054,283 112,919 5,801,606 6,659,964 40,989,478 185,067 480,095 (19,708) 348,780 193,257 102,860 35,388,827 406,869 465,943 525,845 600,000 581,607 370,314 42,279,829 38,339,405 Excise Taxes Operating Revenue Interest Total Convention Center 60,050,000 25,831,300 1,500,000 18,844,344 1,230,263 227,070 21,135,248 8,250,080 540,873 87,381,300 20,301,677 29,926,201 449,675,316 5,500,000 5,310,000 7,878,000 4,100,000 5,690,000 1,628,668 244,439,831 1,077,804 3,690,624 3,712,985 2,213,819 1,018,448 (2,756,216) 216,788,156 1,916,301 2,694,118 2,691,691 2,161,710 2,727,534 1,234,513 479,781,984 253,397,295 230,214,023 WATER SYSTEM: $ Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System WASTEWATER: 17,272,742 (101,659) 327,300 243,764 835,220 17,036,399 1,622,531 583,620 369,236 1,529,877 Sewer Service Charges Multi-City Development Fees Interest Other 207,876,578 17,561,000 4,000,000 5,456,000 14,920,801 87,034,162 7,433,196 2,061,870 1,303,911 8,817,991 85,750,959 8,487,342 2,033,460 1,847,036 8,337,991 18,577,367 21,141,663 Total Wastewater 249,814,379 106,651,130 106,456,788 160,206,000 9,970,500 18,000 4,937,029 63,873,005 4,867,486 142,235 1,777,406 55,497,397 3,480,497 360,821 2,024,965 175,131,529 70,660,132 61,363,680 1,418,024,412 551,180,982 589,297,371 $ 4,420,437,576 $ 1,611,358,867 SOLID WASTE: $ 12,783,825 903,209 24,552 169,566 11,122,122 472,357 57,876 153,643 13,881,152 11,805,998 104,419,205 111,478,313 402,781,906 $ 380,605,513 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues 29 $ 1,516,688,095 Citywide Operating Expenditures by Program For the Month Ended NOVEMBER 30 2020 2019 Program Budget Estimate 2020-2021 2020-2021 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2020-2021 2019-2020 General Government $ 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 21,981,146 $ 100,421 298,357 433,841 5,655,392 77,521 189,775 241,962 2,064,314 364,591 312,673 1,178,865 51,658 268,873 11,858 348,529 1,331,332 68,478 12,998,440 Mayor $ City Council City Manager Information Technology Services Government Relations Public Information Equal Opportunity Law City Auditor City Clerk Human Resources Manager's Office of Sustainability Phx Community Development Invst Co Retirement Systems Phoenix Employment Relations Board Budget and Research Finance Regional Wireless Cooperative Total General Government 2,243,626 5,444,176 6,307,388 64,086,924 1,540,954 2,779,617 3,340,547 27,805,636 3,205,469 7,284,919 14,398,098 107,120 3,974,562 31,082,387 5,117,948 $ 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) $ 688,736 1,652,095 1,712,307 29,150,216 840,752 1,072,486 1,070,032 10,577,624 1,315,399 2,870,960 5,848,564 267,137 1,052,525 61,560 1,834,320 13,188,003 (676,913) $ 779,481 1,597,503 3,299,710 35,433,888 838,234 1,156,839 1,122,743 10,974,439 1,059,222 2,110,919 6,376,122 1,069,948 51,844 1,892,763 22,099,963 (372,054) 4,457,844 327,565 1,318,322 - 178,719,371 95,595,294 72,525,803 89,491,563 6,103,731 41,627,291 5,380,368 16,675,285 1,955,483 16,898,204 2,018,460 14,071,911 1,955,483 2,603,375 - 47,007,659 18,630,768 18,916,664 16,027,394 2,603,375 745,289,020 418,740,427 1,287,140 305,889,994 169,812,356 524,105 297,979,118 169,477,071 557,829 305,445,164 168,912,061 524,105 444,830 900,294 - 1,165,316,587 476,226,455 468,014,018 474,881,331 1,345,124 Criminal Justice 3,298,641 393,672 3,142,008 428,273 3,692,313 3,570,281 Municipal Court Public Defender Total Criminal Justice Public Safety 57,749,475 33,713,291 92,090 55,295,999 38,541,406 104,492 91,554,856 93,941,897 Police Fire Other Total Public Safety -30- Citywide Operating Expenditures by Program (continued) For the Month Ended NOVEMBER 30 2020 2019 Budget Estimate 2020-2021 Program 2020-2021 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2020-2021 2019-2020 Transportation $ 7,041,721 270,395 21,873,629 6,134,200 35,319,945 $ 8,176,913 1,216,271 25,925,899 11,157,789 Street Transportation Street Lighting Aviation Public Transit 46,476,872 Total Transportation $ 99,257,160 9,859,530 556,005,818 287,100,994 $ 49,383,590 3,940,597 133,080,732 208,120,451 $ 48,546,127 5,070,232 148,223,990 270,263,081 $ 47,467,075 3,940,597 96,706,748 207,958,750 1,916,516 36,373,985 161,701 952,223,502 394,525,371 472,103,430 356,073,169 38,452,202 Community Development 5,163,036 8,437,970 1,209,744 2,563,658 5,065,325 7,185,391 1,464,078 2,829,442 Planning and Development Housing Economic Development Neighborhood Services Department 72,793,823 118,008,161 19,610,771 63,555,996 26,746,968 42,530,036 14,711,995 18,578,105 25,809,460 38,642,475 6,642,785 15,539,529 26,746,968 42,500,758 12,384,869 18,578,105 29,278 2,327,125 - 17,374,408 16,544,235 Total Community Development 273,968,751 102,567,103 86,634,249 100,210,700 2,356,403 118,089,734 41,958,307 76,518,471 21,161,884 100,582,945 5,411,601 4,661,018 49,389,026 20,240,697 36,731,967 4,590,295 51,933,869 3,544,931 3,996,012 52,730,488 19,827,571 38,551,222 2,541,090 35,876,925 3,903,207 2,272,669 49,206,587 20,240,697 28,206,110 51,891,879 3,544,931 3,996,012 182,439 8,525,857 4,590,295 41,990 - 368,383,960 170,426,796 155,703,172 157,086,216 13,340,581 Community Enrichment 8,580,613 2,610,473 3,849,053 1,138,672 9,724,051 109,834 615,362 8,665,364 2,820,868 5,344,356 508,218 5,837,824 280,908 169,059 26,628,059 23,626,597 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 2020 2019 Budget Estimate 2020-2021 Program 2020-2021 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2020-2021 2019-2020 Environmental Services $ 23,719,746 14,122,685 11,393,128 3,544,365 818,882 67,375 53,666,182 $ 27,351,965 14,149,834 10,285,571 2,278,752 139,053 54,205,175 Water System Wastewater Solid Waste Management Public Works Environmental Programs Manager's Office of Sustainability Total Environmental Services $ 372,988,397 185,327,134 174,710,966 27,366,209 1,449,105 656,278 $ 150,683,602 76,247,435 64,388,149 14,105,465 2,814,928 369,598 $ 146,979,396 77,672,769 60,503,746 14,402,622 214,804 - $ 95,201,578 46,956,673 58,677,220 10,903,635 2,814,928 369,598 55,482,025 29,290,762 5,710,928 3,201,831 93,685,546 762,498,089 308,609,176 299,773,337 214,923,631 16,924,537 4,231,787 802,013 7,824,529 538,975 6,631,556 2,471,740 15,524,925 7,050,772 761,369 19,922,662 93,780 9,633,906 5,131,069 1,477,433 651,286 942,000 20,417,366 10,957,599 21,150 321,430 7,051,890 1,763,244 334,172 3,260,221 224,573 350,775 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 1,428,208 4,751,511 2,539,244 287,438 2,952,500 254,156 4,329,949 906,534 5,661,464 3,011,974 1,461,415 7,570,610 4,292 2,826,627 2,063,441 1,041,492 12 515,833 6,685,111 3,112,135 2,563 3,022,054 7,051,890 1,763,244 334,172 3,260,221 224,573 350,775 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 - 55,178,622 - General Obligation Debt Service $ 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 285,642 950,302 507,849 57,488 590,500 50,831 865,990 181,307 1,132,293 602,395 292,283 1,514,122 858 565,325 412,688 208,298 12 133,167 1,337,022 622,427 513 604,411 Aviation Civic Plaza Community Development Community Enrichment Criminal Justice Cultural Facilities Downtown Development Early Redemption Economic Development Environmental Services Fire Protection Freeway Mitigation General Government Historic/Neighborhood Preservation Human Services Information Systems Libraries Maintenance Service Centers Mountain Preserves/Parks MEGA Real Estate Municipal Administration Buildings Municipal Courts Police Protection Public Housing Renovation Public Housing Sanitary Sewers Secondary Property Tax Solid Waste Enterprise Bonds Sports Facilities Storm Sewer Improvements Street Improvements Street Light Refinancing Public Transit Water System 10,965,567 10,915,722 Total Debt Service 132,331,884 55,178,622 54,428,562 13,932,808 885,975 Capital Improvement 759,514,438 71,854,579 85,787,592 Coronavirus Relief Fund 275,000,000 - Vacancy Savings (18,600,000) - - - Contingencies 124,096,000 - 263,165,194 - - - - - 275,115,284 - 5,020,460,241 1,693,614,165 -32- 1,713,886,827 1,463,872,624 157,886,961 Capital Expenditures and Encumbrances 2020-2021 Program General Government Arts and Cultural Facilities Economic Development Energy Conservation Facilities Management Finance Fire Protection Historic Preservation 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 $ $ $ 2019-2020 Actual Yearto-Date Actual Yearto-Date From Operating Funds Budget Actual 902,484 $ 132,875,105 42,498,275 30,601,087 37,379,470 600,000 21,160,664 9,485,000 10,643,300 89,546,645 14,498,000 11,016,000 1,142,978,622 7,324,952 296,491,298 $ 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,568 $ 6,141,887 2,909,949 0 141,118 5,151,420 2,219,470 7,858 53,135 5,316,786 1,305,150 19,529,286 3,202,350 65,960,499 166,700,631 152,284,744 $ 1,246,163 2,576,079 1,573,180 1,597,500 720,683 24,365 576,802 5,261,528 171,743 7,708,496 26,568,972 1,848,000,902 $ 336,644,095 $ 111,940,476 485,068,222 $ 48,025,511 $ $ 517,946,938 43,608,529 31,308,636 312,588,597 605,240,884 1,510,693,584 $ $ 90,783,060 14,197,869 1,183,697 25,013,062 36,273,588 167,451,278 $ 3,358,694,486 $ 504,095,373 - $ 10,495,105 15,038,235 10,330,000 25,263,569 6,966,000 955,000 10,590,000 71,946,938 14,498,000 2020-2021 Year-to-Date Capital Amounts From Capital Funds Budget Actual $ $ $ 58,833,645 35,466,926 3,437,958 12,574,408 47,026,574 157,339,511 $ 269,279,987 - 33 - $ $ 125,596,593 17,617,018 9,549,309 32,033,000 89,650,296 274,446,216 $ 759,514,438 902,484 $ 122,380,000 27,460,040 20,271,087 12,115,901 600,000 14,194,664 8,530,000 53,300 17,599,707 11,016,000 976,277,991 7,324,952 144,206,554 $ $ 84,578,230 276,506 1,818,682 789,712 125,647 678 363,743 168,578,612 962,674 31,124,099 1,362,932,680 $ $ $ 2,349,110 2,300,229 1,065,877 3,551,156 14,562,696 23,829,068 $ 71,854,579 Unencumbered Budget 288,618,584 $ $ 392,350,345 25,991,511 21,759,327 280,555,597 515,590,588 1,236,247,368 $ 2,599,180,048 902,484 47,050,712 39,645,690 27,209,225 34,992,258 600,000 20,314,333 9,460,635 10,065,819 83,921,373 14,326,257 11,016,000 966,691,514 6,362,278 238,798,228 $ 1,511,356,807 $ $ 88,433,950 11,897,641 117,821 21,461,906 21,710,892 143,622,210 $ 427,163,878 29,410,660 30,124,939 287,575,535 568,967,296 1,343,242,306 $ 432,240,794 $ 2,854,599,113 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 16-17 Actuals 60,000 17-18 Actuals 18-19 Actuals 50,000 19-20 Actuals 40,000 20-21 Actuals 20-21 Budget 30,000 20,000 10,000 July FY 16-17 17-18 18-19 19-20 20-21 20-21 Budget Aug July 35,857 17,068 29,246 33,070 41,583 31,289 Sept Aug 36,805 43,895 32,982 36,653 59,937 40,817 Oct Sept 34,012 33,757 32,919 56,465 33,935 42,668 Nov Oct 38,800 42,559 52,159 31,089 45,467 44,692 Dec Jan YTD thru Nov November 32,023 177,496 31,868 169,147 33,971 181,277 40,325 197,602 52,188 233,110 37,519 196,985 Feb Dec 35,135 33,857 53,513 51,643 47,283 Note: City of Phoenix revenue is budgeted on an annual basis. 2020-21 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2016-17 through FY 2019-20 actual expenditures. Return to Summary Page - A1 - Jan 38,595 41,041 35,343 39,512 41,946 Mar Feb 22,766 36,368 38,579 33,570 35,644 Apr May June Mar 33,502 32,970 39,641 61,093 45,398 Apr 28,921 48,534 46,770 29,662 41,781 May 47,647 33,061 27,146 35,239 38,851 June 44,372 45,459 64,281 50,222 55,478 State Sales Tax (Dollars in Thousands) State Sales Tax 25,000 16-17 Actuals 20,000 17-18 Actuals 18-19 Actuals 15,000 19-20 Actuals 20-21 Actuals 20-21 Budget 10,000 5,000 July FY 16-17 17-18 18-19 19-20 20-21 20-21 Budget Aug July 11,269 11,773 18,836 20,116 22,912 16,942 Aug 11,027 12,260 13,749 14,944 14,482 14,205 Sept Oct Sept 11,658 17,561 12,476 11,479 13,123 14,532 Nov Oct 11,195 10,963 10,922 14,226 18,038 12,928 Dec Jan Feb Mar Apr May June YTD thru Nov November 11,443 56,593 13,678 66,235 15,747 71,730 16,443 77,208 13,095 81,650 15,662 74,269 Dec 11,913 13,707 14,902 12,120 14,386 Jan 14,184 13,334 12,154 17,440 15,608 Feb 10,974 13,322 15,369 17,707 15,679 Mar 11,785 13,651 13,689 12,285 14,049 Apr 12,900 12,631 14,284 18,557 15,952 Note: City of Phoenix revenue is budgeted on an annual basis. 2020-21 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2016-17 through FY 2019-20 actual expenditures. Return to Summary Page - A2 - May 12,004 13,603 14,640 11,288 14,084 June 13,622 9,515 8,298 5,321 10,045 Vehicle License Tax (Dollars in Thousands) Vehicle License Tax 12,000 16-17 Actuals 11,000 17-18 Actuals 10,000 9,000 18-19 Actuals 8,000 19-20 Actuals 7,000 20-21 Actuals 6,000 20-21 Budget 5,000 4,000 3,000 2,000 July FY 16-17 17-18 18-19 19-20 20-21 20-21 Budget Aug Sept Oct July 5,712 9,008 9,422 10,791 10,098 9,314 Aug 4,393 4,830 5,782 5,619 7,692 5,499 Sept 4,846 5,152 5,349 5,207 6,207 5,480 Nov Oct 5,181 5,670 6,492 6,146 7,328 6,263 Dec Jan YTD thru Nov November 4,242 24,374 4,904 29,564 4,886 31,931 5,408 33,171 4,608 35,933 5,183 31,739 Feb Dec 4,826 5,741 5,800 5,891 5,935 Note: City of Phoenix revenue is budgeted on an annual basis. 2020-21 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2016-17 through FY 2019-20 actual expenditures. Return to Summary Page - A3 - Mar Jan 5,607 5,470 6,143 6,514 6,328 Apr Feb 5,049 5,714 5,490 6,528 6,074 May Mar 5,457 5,493 5,943 5,960 6,093 June Apr 5,470 5,593 5,668 5,110 5,824 May 4,938 5,602 5,959 4,699 5,652 June 5,866 3,607 3,276 2,611 4,096 Governmental Funds Revenue (Dollars in Thousands) Governmental Funds Revenue 2016-17 Actuals 350,100.00 2017-18 Actuals 300,100.00 2018-19 Actuals 250,100.00 2019-20 Actuals 2020-21 Actuals 200,100.00 20-21 Budget 150,100.00 100,100.00 50,100.00 100.00 FY 16-17 17-18 18-19 19-20 20-21 20-21 Budget July Aug Sept Oct Nov Dec July 125,592 98,501 131,124 100,481 68,761 143,545 Aug 165,819 185,527 168,019 187,393 217,048 221,783 Sept 157,173 176,701 152,605 194,506 260,275 217,459 Oct 165,460 189,075 198,474 175,883 215,731 231,112 Nov 212,320 226,848 247,632 269,127 298,362 300,608 YTD thru November 826,364 876,652 897,854 927,390 1,060,177 1,114,506 Jan Feb Dec 218,635 192,262 221,971 226,582 273,368 Jan 173,436 187,522 170,844 209,806 235,306 Note: City of Phoenix revenue is budgeted on an annual basis. 2020-21 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2016-17 through FY 2019-20 actual expenditures. Return to Summary Page - A4 - Mar Apr Feb 145,268 176,559 173,462 187,061 218,212 May Mar 159,366 167,449 187,169 217,521 233,453 June Apr 185,518 217,138 210,659 180,484 255,157 May 251,092 223,002 245,256 226,625 301,435 June 225,798 252,080 280,540 378,887 370,977 Aviation Revenues (Dollars in Thousands) Aviation Operating Revenues 50,000 16-17 Actuals 17-18 Actuals 40,000 18-19 Actuals 19-20 Actuals 30,000 20-21 Actuals 20-21 Budget 20,000 10,000 July FY 16-17 17-18 18-19 19-20 20-21 20-21 Budget Aug Sept Oct July 28,314 26,403 31,468 30,489 25,387 33,174 Aug 29,777 34,965 32,105 32,307 2,666 36,722 Sept 29,279 30,148 31,728 32,953 27,193 35,288 Nov Dec Jan Oct 28,339 29,291 31,719 32,056 21,045 34,519 YTD thru Nov November 30,504 146,213 21,702 142,509 32,312 159,332 33,532 161,337 23,880 100,171 33,565 173,268 Feb Mar Apr Dec 24,926 38,212 30,496 36,787 37,082 Jan 28,532 32,543 31,205 34,297 35,990 Feb 28,901 30,671 32,944 34,215 36,033 Note: City of Phoenix revenue is budgeted on an annual basis. 2020-21 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2016-17 through FY 2019-20 actual expenditures. Return to Summary Page - A5 - May Mar 29,273 33,070 33,075 34,228 36,862 June Apr 33,162 37,265 37,847 27,255 38,535 May 32,146 32,447 34,396 23,524 34,834 June 31,531 38,986 35,938 10,702 33,311 Water System Revenues (Dollars in Thousands) Water System Operating Revenues 70,000 16-17 Actuals 60,000 17-18 Actuals 18-19 Actuals 50,000 19-20 Actuals 40,000 20-21 Actuals 20-21 Budget 30,000 20,000 10,000 July FY 16-17 17-18 18-19 19-20 20-21 20-21 Budget Aug July 50,220 54,624 49,797 52,660 57,819 58,196 Sept Aug 47,104 44,633 46,762 51,596 53,509 53,366 Oct Sept 43,613 44,819 44,112 47,319 52,454 50,494 Nov Dec Jan Feb Mar Apr May June Oct 37,360 39,391 35,672 40,300 47,335 42,874 Nov 34,083 38,890 31,619 38,339 42,280 40,125 YTD thru November 212,380 222,357 207,962 230,214 253,397 245,055 Dec 26,073 27,184 25,048 26,405 29,396 Jan 21,608 25,186 22,565 25,330 26,582 Feb 19,223 22,704 21,558 25,643 25,021 Mar 20,925 23,806 20,138 24,861 25,190 Apr 32,958 31,392 31,150 29,080 34,974 Note: City of Phoenix revenue is budgeted on an annual basis. 2020-21 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2016-17 through FY 2019-20 actual expenditures. Return to Summary Page - A6 - May 38,009 38,031 36,293 40,442 42,889 June 46,526 43,736 38,106 52,141 50,675 Wastewater Revenues (Dollars in Thousands) Wastewater Operating Revenues 27,000 16-17 Actuals 17-18 Actuals 22,000 18-19 Actuals 19-20 Actuals 17,000 20-21 Actuals 20-21 Budget 12,000 7,000 2,000 July FY 16-17 17-18 18-19 19-20 20-21 20-21 Budget Aug July 18,836 18,615 17,949 18,374 21,205 19,061 Sept Aug 19,359 22,957 20,417 24,593 22,791 22,563 Oct Sept 19,337 19,811 21,145 21,373 21,844 21,100 Nov Oct 18,611 20,195 23,028 20,975 22,234 21,395 Dec Jan YTD thru Nov November 18,347 94,491 20,386 101,964 19,734 102,273 21,142 106,457 18,577 106,651 20,569 104,688 Feb Mar Apr May June Dec 19,493 20,097 20,469 20,888 20,914 Jan 19,155 20,584 22,113 22,063 21,681 Feb 18,594 19,499 19,436 20,973 20,283 Mar 19,618 20,517 19,960 21,613 21,111 Apr 19,731 18,079 21,256 18,428 20,022 Note: City of Phoenix revenue is budgeted on an annual basis. 2020-21 monthly budget amounts are based on an allocation of the annu budget. Monthly budget amounts are calculated based on an allocation of FY 2016-17 through FY 2019-20 actual expenditures. Return to Summary Page - A7 - May 20,233 20,160 20,980 23,948 22,044 June 20,633 18,345 16,544 18,289 19,071