July 2020 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division July 31, 2020 To the Mayor and City Council: This is the City's Financial Report for July, the first 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 October 15, 2020 CITY AUDITOR REPORT To the Chief Financial Officer, We have assessed the Finance Department’s (Finance) July 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, For Ross Tate City Auditor City of Phoenix Monthly Financial Report July 2020 Table of Contents Expenditures by Programs Page Performance Status General Fund Expenditures General Fund Total Expenditures 1 Better than Expected General Government 1 Monitor and Consider Taking Action Report Navigation Click on either the schedule name or the Criminal Justice 2 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 Monitor and Consider Taking Action Community Development 7 Better than Expected Expected - Actual vs budget variance within 1% Community Enrichment 8 Better than Expected positive or negative. Environmental Services 8 Expected Monitor and Consider Taking Action - Negative General Obligation Debt Service 9 Expected variance greater than 1% actual vs budget. 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 Page Performance Status General Fund Total Operating Revenue 13 Better than Expected Property Tax 14 Expected 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 Expected Wastewater 21 Better than Expected Financial Schedules Page General Fund Revenue 22 General Fund Expenditures 23 Citywide Operating Revenue 24 Citywide Operating Expenditures 25 Citywide Operating Revenue by Source 26 Citywide Operating Expenditures by Program 30 Capital Expenditures and Encumbrances 33 Bonds Authorized and Sold 34 Appendix A - Additional Detail for Revenues 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. July 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 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 99,620 1,105,361 9.0% 118,244 1,177,280 10.0% 115,538 1,214,362 9.5% 133,757 1,282,831 10.4% 133,971 1,388,617 9.6% * - 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 July YTD Expenditures July YTD 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 July are 0.2% higher 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 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 8,400 106,754 7.9% 10,188 110,408 9.2% 10,196 114,393 8.9% 12,740 123,100 10.3% 16,077 152,890 10.5% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action 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 July YTD Expenditures July 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 July are 26.2% higher 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 July General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Criminal Justice Criminal Justice July YTD Annual % of Annual Expenditures Expenditures * Expenditures 2,235 31,595 7.1% 3,035 32,232 9.4% 3,201 33,387 9.6% 3,113 35,033 8.9% 3,307 37,541 8.8% $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 Expected July 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 July are 6.2% 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 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 69,516 764,482 9.1% 75,495 817,960 9.2% 77,590 841,467 9.2% 87,214 893,403 9.8% 87,252 944,681 9.2% $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 $800,000 July YTD Expenditures $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 July, general fund public safety expenditures are 0.0% 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 July General Fund 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 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 1,571 17,878 8.8% 8,686 16,366 53.1% 2,192 18,337 12.0% 355 19,748 1.8% 338 20,762 1.6% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Community Development Transportation $1 $30,000 $1 JulySeries1 YTD Expenditures $1 $20,000 $1 $0 $10,000 Annual Series2 Expenditures * $0 $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 July, General fund transportation expenditures are 4.8% lower than the same period in the prior fiscal year. Community Development 16-17 17-18 18-19 19-20 20-21 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 1,347 19,709 6.8% 1,763 20,243 8.7% 1,827 21,238 8.6% 2,028 22,542 9.0% 2,115 24,761 8.5% * - For prior years-total actual expenditures, for current year-total approved budget Community Development $30,000 July 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 July are 4.3% higher 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 July General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Community Enrichment Community Enrichment July YTD Annual % of Annual Expenditures Expenditures * Expenditures 14,606 146,749 10.0% 17,183 156,325 11.0% 17,525 156,552 11.2% 24,080 155,417 15.5% 20,833 169,541 12.3% $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 July 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 July, general fund community enrichment expenditures are 13.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 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 1,671 12,775 13.1% 1,362 12,624 10.8% 2,969 16,886 17.6% 3,663 19,180 19.1% 3,514 18,799 18.7% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services $24,000 July YTD Expenditures $20,000 $16,000 $12,000 Annual Expenditures * $8,000 $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 July, general fund environmental services expenditures are 4.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. July 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 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 277,234 3,468,589 8.0% 314,887 3,547,078 8.9% 432,775 3,775,464 11.5% 375,727 3,814,963 9.8% 433,139 4,639,965 9.3% * - 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 July 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 July are 15.3% higher than the same period in the prior fiscal year. General Government 16-17 17-18 18-19 19-20 20-21 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 8,448 121,863 6.9% 11,213 134,117 8.4% 10,662 138,349 7.7% 12,379 157,200 7.9% 20,472 178,719 11.5% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action General Government $200,000 July 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 July are 65.4% 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 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. 5 July 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 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 3,079 41,117 7.5% 3,674 38,411 9.6% 3,354 42,530 7.9% 4,160 44,425 9.4% 4,090 47,008 8.7% * - For prior years-total actual expenditures, for current year-total approved budget Criminal Justice $50,000 July 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.7% lower through July 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 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 80,630 908,553 8.9% 86,759 970,771 8.9% 91,412 1,025,513 8.9% 104,833 1,110,457 9.4% 105,446 1,165,317 9.0% * - 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 July 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 July are 0.6% 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 July 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 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 38,922 642,850 6.1% 72,350 709,977 10.2% 88,668 722,667 12.3% 70,139 774,492 9.1% 122,743 952,224 12.9% * - 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 July YTD Expenditure s Annual Expenditure s* 16-17 Monitor and Consider Taking Action 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 75.0% higher through July 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 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 15,747 188,365 8.4% 16,073 203,096 7.9% 16,513 195,716 8.4% 18,444 229,793 8.0% 21,129 273,969 7.7% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Community Development $300,000 July 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 July are 14.6% 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 July 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 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 25,661 292,983 8.8% 30,003 306,763 9.8% 40,507 317,465 12.8% 53,178 316,680 16.8% 57,093 368,384 15.5% * - 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 July 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 July are 7.4% 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 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 58,640 599,837 9.8% 43,785 696,244 6.3% 50,138 670,219 7.5% 72,182 692,524 10.4% 79,526 762,498 10.4% * - 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 July YTD Expenditures Annual Expenditures * 16-17 17-18 18-19 19-20 20-21 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 10.2% higher through July 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 July 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 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 11,465 137,205 8.4% 9,054 106,315 8.5% 46,433 116,634 39.8% 10,866 130,839 8.3% 10,966 132,332 8.3% $180,000 July YTD Expenditures $120,000 $60,000 Annual Expenditures * * - For prior years-total actual expenditures, for current year-total approved budget net of credit for early redemption fund resources $0 16-17 17-18 18-19 19-20 20-21 Expected General obligation debt service expenditures through July are 0.9% 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 $ 500,745 Discussion: 20-21 (Budget) 20-21 (YTD) $ $ 1,848,080 89,035 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 $ 254,523 20-21 (Budget) 20-21 (YTD) $ $ 517,947 50,436 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) $ 5,075 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,000 20-21 (Budget) 19-20 $ 5,490 $ 31,309 $30,000 $40,000 $50,000 $60,000 20-21 (YTD) $ 864 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 $ 315,434 $ 417 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 2019-20 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) $ 252,146 $ 602,317 20-21 (YTD) $ 9,705 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 July 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 July YTD Revenues 60,266 48,335 67,569 73,830 78,594 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 5.5% 4.2% 5.5% 5.6% 6.0% * - 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. Actual revenues through July are 6.5% 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 91,021 180,000 95,435 101,652 113,594 107,555 Secondary 150,000 120,000 90,000 60,000 146,121 154,560 162,129 170,209 16-17 17-18 18-19 19-20 179,950 Primary 30,000 - FY 16-17 17-18 18-19 19-20 20-21 YTD 20-21 Budget Total 237,142 249,995 263,781 277,764 (1,619) 293,545 July (1,004) (1,054) (1,049) (1,141) (1,619) (1,203) Aug Sept 454 773 (395) 891 688 980 1,081 647 510 934 Oct 12,067 16,220 12,601 11,579 14,982 Nov 57,953 87,691 91,331 106,458 105,871 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 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 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 (1,029) (590) 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 60,000 50,000 40,000 30,000 20-21 Actuals 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 July are 25.7% higher than the same period in the prior year. Actual local sales tax revenues through July are 32.9% 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 July state shared sales tax revenues are 35.2% 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 July 2020 are 8.4% 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 July 2020 are 52.1% 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 July 2020 are 23.5% lower than budget expectations for the period. 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 Expected Water system revenues through July 2020 are 0.6% lower 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 23,000 22,000 21,000 20-21 Budget 20,000 20-21 Actuals 19,000 18,000 17,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Better than Expected Wastewater revenues through July 2020 are 11.2% 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 JULY 31 (dollars in thousands) Budget Estimate 2020-2021 Actual Year-to-Date 2020-2021 2019-2020 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 $ 41,583 $ 45 33,070 70 174,072 241,167 71,743 179,950 2,960 10,120 22,912 20,020 10,098 (1,029) 108 (2,600) 20,116 17,891 10,791 (737) 136 - 11,548 1,296 15,481 768 7,559 1,808 6,663 736 117 849 (71) 206 122 405 988 98 584 34 570 129 522 37,875 1,400 13,660 9,420 15,613 (16,345) 50 243 568 577 (12,365) 53 241 909 730 1,309,519 - 22 - $ 78,594 $ 73,830 General Fund Expenditures As of JULY 31 (dollars in thousands) Budget Estimate 2020-2021 Actual Year-to-Date 2020-2021 2019-2020 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 $ 137 $ 318 502 4,173 243 219 2,186 222 397 1,039 356 5,983 302 16,077 161 354 292 4,410 201 187 1,821 197 911 1,156 458 2,180 413 12,740 Criminal Justice Municipal Court Public Defender Total Criminal Justice 32,161 5,380 37,541 2,907 399 3,307 2,713 400 3,113 Public Safety Police Fire Others Total Public Safety 591,932 352,507 242 944,681 55,955 31,248 49 87,252 58,218 28,968 28 87,214 Transportation Street Transportation Public Transit Total Transportation 18,976 1,786 20,762 338 338 355 355 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 6,251 14,033 4,308 169 24,761 457 1,241 400 17 2,115 424 1,307 293 4 2,028 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 101,808 40,896 19,978 6,859 169,541 9,107 7,948 1,894 1,884 20,833 11,749 8,142 2,186 2,003 24,080 Environmental Services Public Works Environmental Programs Others Total Environmental Services 17,643 732 424 18,799 3,371 75 68 3,514 3,611 52 3,663 Capital Improvement 19,643 535 564 Vacancy Savings (18,600) - - Contingencies 55,596 - - 133,971 $ 133,757 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 JULY 31 (dollars in thousands) Source General Funds Local Taxes: Sales Taxes Privilege License Fees State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax Primary Property Tax Licenses and Permits Cable Communications Municipal Court Police Library Fees Parks and Recreation Planning & Development Street Transportation Fire Interest Other Fees and Service Charges Budget Estimate 2020-2021 $ 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 503,367 3,050 Actual Year-to-Date 2020-2021 2019-2020 41,583 $ 45 33,070 70 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 22,912 20,020 10,098 (1,029) 108 (2,600) 852 849 (71) 206 122 405 (16,052) 568 577 20,116 17,891 10,791 (737) 136 1,086 584 34 570 129 522 (12,071) 909 730 1,309,519 78,594 73,830 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 2,294 4,459 2,358 449 16,900 14,271 598 581 10,026 1,337 (2) (5,005) (55,666) (2,432) 2,233 5,483 2,337 257 18,925 14,841 601 1,432 11,775 (612) 352 (5,779) (24,789) (404) 1,692,894 (9,832) 26,651 425,915 87,381 479,782 249,814 175,132 25,387 2,574 57,819 21,205 13,734 30,489 5,875 52,660 18,374 12,396 1,418,024 120,719 119,794 189,481 $ 220,276 $ 4,420,437 - 24 - $ $ Citywide Operating Expenditures As of JULY 31 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2020-2021 2019-2020 Budget 2020-2021 16,077 $ 4,395 20,472 12,740 (361) 12,379 37,541 9,467 47,008 3,307 783 4,090 3,113 1,047 4,160 Public Safety General Funds Other Funds Total Public Safety 944,681 220,636 1,165,317 87,252 18,194 105,446 87,214 17,619 104,833 Transportation General Funds Other Funds Total Transportation 20,762 931,462 952,224 338 122,405 122,743 355 69,784 70,139 Community Development General Funds Other Funds Total Community Development 24,761 249,208 273,969 2,115 19,014 21,129 2,028 16,416 18,444 Community Enrichment General Funds Other Funds Total Community Enrichment 169,541 198,843 368,384 20,833 36,260 57,093 24,080 29,098 53,178 Environmental Services General Funds Other Funds Total Environmental Services 18,799 743,699 762,498 3,514 76,012 79,526 3,663 68,519 72,182 Debt Service General Funds Other Funds Total Debt Service 132,332 132,332 10,966 10,966 10,866 10,866 Capital Improvement General Funds Other Funds Total Capital Improvement 19,643 739,871 759,514 535 11,139 11,674 564 28,982 29,546 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 133,971 299,168 433,139 $ 133,757 241,970 375,727 $ 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 - 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 JULY 31 2020 2019 Budget Estimate 2020-2021 Source Actual Year-to-Date 2020-2021 2019-2020 General Funds $ 41,583,043 45,245 41,628,288 $ 33,070,373 69,765 Local Taxes: Sales Taxes Privilege License Fees $ 503,367,000 3,050,000 $ 41,583,043 45,245 $ 33,070,373 69,765 33,140,138 Total Local Taxes 506,417,000 41,628,288 33,140,138 22,911,587 20,019,770 10,098,470 20,116,174 17,891,434 10,791,056 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 174,072,000 241,167,000 71,743,000 22,911,587 20,019,770 10,098,470 20,116,174 17,891,434 10,791,056 53,029,827 48,798,664 486,982,000 53,029,827 48,798,664 (1,029,398) (737,365) Primary Property Tax 179,950,000 (1,029,398) (737,365) 108,458 135,692 Licenses and Permits 2,960,000 108,458 135,692 (2,600,000) 0 Cable Communications 10,120,000 (2,600,000) 0 735,733 116,559 988,220 97,628 Municipal Court: Fines and Forfeitures Court Default Fee 11,548,248 1,296,000 735,733 116,559 988,220 97,628 852,292 1,085,848 12,844,248 852,292 1,085,848 848,972 583,898 Police 15,480,700 848,972 583,898 (70,674) 33,932 Library Fees 767,713 (70,674) 33,932 206,439 570,302 Parks and Recreation 7,559,338 206,439 570,302 122,175 128,836 Planning and Development 1,808,200 122,175 128,836 404,823 521,511 Street Transportation 6,662,600 404,823 521,511 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other 37,875,000 1,400,000 13,659,600 (16,344,713) 49,750 242,650 (12,364,330) 52,500 241,196 52,934,600 (16,052,313) (12,070,634) 9,420,000 568,106 909,388 Total State Shared Taxes Total Municipal Court (16,344,713) 49,750 242,650 (12,364,330) 52,500 241,196 (16,052,313) (12,070,634) 568,106 909,388 Interest 577,499 729,869 Other Fees and Service Charges 78,594,494 73,830,079 Total Fire Total General Funds 26 15,612,775 577,499 729,869 1,309,519,174 78,594,494 73,830,079 Citywide Operating Revenue by Source (continued) For the Month Ended JULY 31 2020 2019 Budget Estimate 2020-2021 Source Actual Year-to-Date 2020-2021 2019-2020 Special Revenue and Debt Service Funds $ 1,589,932 113,567 567,833 22,430 $ 2,293,762 3,561,208 863,838 34,217 $ $ $ 4,459,263 1,536,679 109,763 548,814 38,173 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 2,233,429 Total Neighborhood Protection 4,154,273 1,271,503 57,152 5,482,928 2,357,870 $ 2,337,102 240,327 0 166,823 1,740 40,274 $ $ $ $ $ 132,413 0 100,457 880 22,870 449,164 15,577,040 1,322,718 $ $ 16,899,758 1,589,932 113,567 567,833 22,430 $ 1,536,679 109,763 548,814 38,173 37,176,000 2,293,762 2,233,429 72,595,000 23,277,000 606,510 3,561,208 863,838 34,217 4,154,273 1,271,503 57,152 96,478,510 4,459,263 5,482,928 Parks and Preserves 38,830,728 2,357,870 2,337,102 Golf Courses: Fees Coffee Shops Concessions Interest Other 3,948,300 0 2,054,000 1,540 269,816 240,327 0 166,823 1,740 40,274 132,413 0 100,457 880 22,870 Total Public Safety Enhancement & Expansion 6,273,656 449,164 256,620 14,974,971 3,950,289 Transit 2000 & 2050: Sales Taxes Interest/Other 249,230,000 43,467,791 15,577,040 1,322,718 14,974,971 3,950,289 292,697,791 16,899,758 18,925,260 Court Awards 5,759,602 0 0 Planning and Development 72,139,500 14,270,941 14,841,266 Capital Construction 8,539,000 597,823 601,077 Sports Facilities: Sales Taxes Interest/Other 20,558,000 4,411,906 525,540 55,295 1,342,122 89,734 24,969,906 580,835 1,431,856 $ 0 14,270,941 $ 14,841,266 597,823 $ 601,077 580,835 $ Total Golf Courses 18,925,260 $ $ Public Safety Enhancement & Expansion: Police Fire Interest/Other 25,578,000 1,827,000 9,134,000 637,000 256,620 0 525,540 55,295 $ 1,342,122 89,734 1,431,856 Total Transit 2000 & 2050 Total Sports Facilities 27 Citywide Operating Revenue by Source (continued) For the Month Ended JULY 31 2020 2019 Budget Estimate 2020-2021 Source Actual Year-to-Date 2020-2021 2019-2020 Special Revenue and Debt Service Funds (Cont'd) $ 9,943,000 82,404 0 11,593,000 163,064 18,560 10,025,404 11,774,624 - $ - Highway User Revenue: Highway User Revenue Interest Other Total Highway User Revenue Local Transportation Assistance 145,124,000 1,000,000 160,000 9,943,000 82,404 0 11,593,000 163,064 18,560 146,284,000 10,025,404 11,774,624 0 0 0 1,337,011 (611,951) Regional Transit Revenues 41,123,538 1,337,011 (611,951) (1,524) 351,736 Community Reinvestment 5,987,227 (1,524) 351,736 (5,005,351) (5,779,340) Other Restricted Fees 47,489,334 (5,005,351) (5,779,340) 344,453 10,409,112 636,597 595,462 8,484,037 1,291,661 Grants: Public Housing: Rentals Grants Other 8,287,450 99,730,276 22,242,602 344,453 10,409,112 636,597 595,462 8,484,037 1,291,661 11,390,162 10,371,160 130,260,328 11,390,162 10,371,160 58,963,098 180,910,504 53,374,820 327,430,851 (1,262,975) (45,834,459) (2,072,521) (17,885,788) (4,898,789) (19,836,553) (3,155,235) (7,269,815) $ Total Public Housing Other: Human Resources Federal Transit Administration Community Development Other (1,262,975) (45,834,459) (2,072,521) (17,885,788) (4,898,789) (19,836,553) (3,155,235) (7,269,815) (67,055,743) (35,160,392) Total Other 620,679,273 (67,055,743) (35,160,392) (55,665,581) (24,789,232) Total Grants 750,939,601 (55,665,581) (24,789,232) (590,287) (1,841,900) (404,017) 0 113,594,000 4,611,597 (590,287) (1,841,900) (404,017) 0 (2,432,187) (404,017) 118,205,597 (2,432,187) (404,017) (9,832,812) 26,651,358 1,692,893,990 (9,832,812) 26,651,358 116,487,500 295,282,200 2,424,900 5,293,420 2,697,600 3,729,600 0 6,491,140 26,478,070 259,681 (8,493,804) 244,496 261,217 146,315 9,176,307 19,911,071 386,861 175,046 328,530 254,758 256,057 425,915,220 25,387,115 30,488,630 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: 6,491,140 26,478,070 259,681 (8,493,804) 244,496 261,217 146,315 9,176,307 19,911,071 386,861 175,046 328,530 254,758 256,057 25,387,115 30,488,630 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 JULY 31 2020 2019 Budget Estimate 2020-2021 Source Actual Year-to-Date 2020-2021 2019-2020 Enterprise Funds (Cont'd) CONVENTION CENTER: $ 2,339,529 182,174 52,324 3,345,310 2,430,201 99,649 2,574,027 5,875,160 55,869,560 234,536 1,640,307 653,367 550,140 219,085 (1,347,984) 50,717,762 256,990 680,953 84,377 367,620 475,487 77,220 57,819,011 52,660,409 Excise Taxes Operating Revenue Interest Total Convention Center 60,050,000 25,831,300 1,500,000 2,339,529 182,174 52,324 3,345,310 2,430,201 99,649 87,381,300 2,574,027 5,875,160 449,675,316 5,500,000 5,310,000 7,878,000 4,100,000 5,690,000 1,628,668 55,869,560 234,536 1,640,307 653,367 550,140 219,085 (1,347,984) 50,717,762 256,990 680,953 84,377 367,620 475,487 77,220 479,781,984 57,819,011 52,660,409 WATER SYSTEM: $ Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System WASTEWATER: 17,237,476 1,672,000 500,430 280,563 1,514,475 16,996,460 0 329,880 361,942 686,094 Sewer Service Charges Multi-City Development Fees Interest Other 207,876,578 17,561,000 4,000,000 5,456,000 14,920,801 17,237,476 1,672,000 500,430 280,563 1,514,475 16,996,460 329,880 361,942 686,094 21,204,944 18,374,376 Total Wastewater 249,814,379 21,204,944 18,374,376 160,206,000 9,970,500 18,000 4,937,029 12,757,788 830,484 31,518 113,851 11,098,984 648,927 81,552 566,458 175,131,529 13,733,641 12,395,921 1,418,024,412 120,718,738 119,794,496 SOLID WASTE: $ 12,757,788 830,484 31,518 113,851 11,098,984 648,927 81,552 566,458 13,733,641 12,395,921 120,718,738 119,794,496 189,480,420 $ 220,275,933 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds $ 4,420,437,576 Total Operating Revenues 29 $ 189,480,420 $ 220,275,933 Citywide Operating Expenditures by Program For the Month Ended JULY 31 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 $ 136,850 $ 317,947 629,904 7,510,013 87,558 246,123 258,292 2,323,703 221,781 396,669 1,236,175 204,279 10,643 355,888 8,836,843 (2,300,358) 160,701 354,362 321,724 5,471,173 124,908 237,455 197,953 1,918,520 197,274 910,581 1,303,267 56,895 212,897 18,105 458,349 2,408,291 (1,973,330) 20,472,310 12,379,126 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 Corp 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 $ 136,850 317,947 629,904 7,510,013 87,558 246,123 258,292 2,323,703 221,781 396,669 1,236,175 204,279 10,643 355,888 8,836,843 (2,300,358) $ 160,701 354,362 321,724 5,471,173 124,908 237,455 197,953 1,918,520 197,274 910,581 1,303,267 56,895 212,897 18,105 458,349 2,408,291 (1,973,330) $ 136,850 317,947 629,904 6,600,565 87,558 246,123 258,292 2,323,703 221,781 396,669 1,163,679 204,279 10,643 355,888 8,759,801 (2,300,358) 909,448 72,496 77,042 - 178,719,371 20,472,310 12,379,126 19,413,324 1,058,986 41,627,291 5,380,368 3,691,062 399,334 3,759,995 400,228 3,150,128 399,334 540,935 - 47,007,659 4,090,396 4,160,223 3,549,462 540,935 745,289,020 418,740,427 1,287,140 67,795,323 37,552,857 97,735 71,112,090 33,617,443 103,576 67,670,615 37,277,226 97,735 124,708 275,631 - 1,165,316,587 105,445,916 104,833,110 105,045,577 400,339 Criminal Justice 3,691,062 399,334 3,759,995 400,228 4,090,396 4,160,223 Municipal Court Public Defender Total Criminal Justice Public Safety 67,795,323 37,552,857 97,735 71,112,090 33,617,443 103,576 105,445,916 104,833,110 Police Fire Other Total Public Safety -30- Citywide Operating Expenditures by Program (continued) For the Month Ended JULY 31 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 $ 12,770,371 2,004,927 30,630,496 77,336,917 122,742,712 $ 13,287,593 1,989,684 30,005,127 24,856,151 Street Transportation Street Lighting Aviation Public Transit 70,138,554 Total Transportation $ 99,257,160 9,859,530 556,005,818 287,100,994 $ 12,770,371 2,004,927 30,630,496 77,336,917 $ 13,287,593 1,989,684 30,005,127 24,856,151 $ 12,414,068 2,004,927 23,359,229 77,330,355 356,303 7,271,267 6,563 952,223,502 122,742,712 70,138,554 115,108,579 7,634,133 Community Development 5,925,973 9,192,564 3,368,170 2,642,494 5,509,738 8,376,560 1,222,910 3,334,550 Planning and Development Housing Economic Development Neighborhood Services Department 72,793,823 118,008,161 19,610,771 63,555,996 5,925,973 9,192,564 3,368,170 2,642,494 5,509,738 8,376,560 1,222,910 3,334,550 5,925,973 9,186,708 2,832,608 2,642,494 5,856 535,562 - 21,129,201 18,443,757 Total Community Development 273,968,751 21,129,201 18,443,757 20,587,783 541,418 118,089,734 41,958,307 76,518,471 21,161,884 100,582,945 5,411,601 4,661,018 10,904,138 8,074,050 19,145,012 473,680 13,823,569 3,159,584 1,513,461 13,761,955 8,190,367 20,267,603 508,218 6,666,193 3,135,892 647,397 10,853,490 8,074,050 17,480,465 13,812,254 3,159,584 1,513,461 50,648 1,664,547 473,680 11,316 - 368,383,960 57,093,494 53,177,624 54,893,303 2,200,191 Community Enrichment 10,904,138 8,074,050 19,145,012 473,680 13,823,569 3,159,584 1,513,461 13,761,955 8,190,367 20,267,603 508,218 6,666,193 3,135,892 647,397 57,093,494 53,177,624 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 JULY 31 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 $ 40,732,955 18,718,326 15,334,028 4,338,662 317,203 85,250 79,526,424 $ 36,008,479 19,778,603 11,972,774 4,234,927 187,697 72,182,480 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 $ 40,732,955 18,718,326 15,334,028 4,338,662 317,203 85,250 $ 36,008,479 19,778,603 11,972,774 4,234,927 187,697 - $ 29,652,315 12,856,198 14,270,017 3,737,669 317,203 85,250 11,080,640 5,862,128 1,064,012 600,993 18,607,773 762,498,089 79,526,424 72,182,480 60,918,651 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 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 83,167 1,337,022 622,427 513 604,411 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,965,567 - 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 83,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,865,710 Total Debt Service 132,331,884 10,965,567 10,865,710 11,674,262 29,545,977 Capital Improvement 759,514,438 11,674,262 29,545,977 Coronavirus Relief Fund 275,000,000 - - - Vacancy Savings (18,600,000) - - - Contingencies 124,096,000 - 433,140,282 375,726,560 5,020,460,241 433,140,282 -32- 375,726,560 - - - - 390,482,247 30,983,773 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,570,298 $ 914,504 572,246 175,614 860,516 1,022 7,518 69,144 844,615 72 80,502,837 5,086,927 $ 2,832 2,389 467,461 12,776 637,217 619,853 2,156 35,285 374,780 17,723,959 7,036,269 166,700,631 152,363,744 $ 914,504 540,080 786,000 76 7,518 68,747 829,359 1,502,330 4,140,273 1,848,079,902 $ 89,035,015 $ 26,914,977 485,147,222 $ 8,788,887 $ 517,946,938 43,608,529 31,308,636 315,433,597 602,316,884 1,510,614,584 $ 3,358,694,486 $ $ 50,436,355 5,074,577 863,761 416,514 9,704,962 66,496,168 $ 155,531,184 $ $ (6,561,921) 2,300,933 64,249 2,006,144 3,110,720 920,125 $ 27,835,102 - $ 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 $ - 33 - $ $ 125,596,593 17,617,018 9,549,309 32,033,000 89,571,296 274,367,216 $ 759,514,438 $ $ 235,984 1,295,141 770,289 68,557 515,404 2,885,375 $ 11,674,262 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 $ 1,362,932,680 $ $ $ 392,350,345 25,991,511 21,759,327 283,400,597 512,745,588 1,236,247,368 $ 2,599,180,048 $ Unencumbered Budget $ 32,166 175,614 74,516 946 397 15,256 72 79,000,507 946,655 902,484 131,960,601 41,926,029 30,425,473 36,518,954 600,000 21,159,642 9,477,482 10,574,156 88,702,030 14,497,928 11,016,000 1,062,475,785 7,324,952 291,483,371 80,246,129 1,759,044,887 $ $ 50,200,371 3,779,436 93,472 347,956 9,189,558 63,610,793 $ $ 467,510,583 38,533,952 30,444,875 315,017,083 592,611,922 1,444,118,416 $ 143,856,922 $ 3,203,163,302 Bonds Authorized and Sold As of JULY 31 (dollars in thousands) Authorized Sold Available 1988 Authorizations General Obligation Bonds Freeway Mitigation, Neighborhood Stabilization, and Slum and Blight Elimination $ Bonds Fully Issued 29,285 884,175 $ 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 2006 Authorization General Obligation Bonds Affordable Housing and Neighborhood Revitalization 81,000 Computer Technology 11,100 Education and Health Science Facilities 198,700 Environmental Cleanup 12,800 Family, Senior, and Youth Cultural Facilities 104,622 Fire Protection 74,705 Library Facilities and Improvements 29,178 Parks, Open Space, and Recreational Facilities 115,500 Police Protection 107,295 Street Improvements 78,200 Storm Sewer and Flood Protection 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 Total General Obligation Bonds Revenue Bonds Bonds Fully Issued Total 1988 Authorizations 2001 Authorization General Obligation Bonds Education, Youth and Family Cultural Facilities Computer Technology Environmental Cleanup Fire Protection Historic Preservation Library Facilities Street Improvements Neighborhood Protection and Senior Centers Parks, Open Space, and Recreational Facilities Police Protection Storm Sewer and Flood Protection Bonds Fully Issued Total 2001 Authorizations 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 Sept July YTD thru July 35,857 35,857 17,068 17,068 29,246 29,246 33,070 33,070 41,583 41,583 31,289 31,289 Oct Aug 36,805 43,895 32,982 36,653 40,817 Nov Sept 34,012 33,757 32,919 56,465 42,668 Dec Oct 38,800 42,559 52,159 31,089 44,692 Jan Nov 32,023 31,868 33,971 40,325 37,519 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 YTD thru July 11,269 11,773 18,836 20,116 22,912 16,942 Sept Oct Aug 11,027 12,260 13,749 14,944 14,205 Nov Sept 11,658 17,561 12,476 11,479 14,532 Dec Jan Feb Mar Apr May June Oct 11,195 10,963 10,922 14,226 12,928 Nov 11,443 13,678 15,747 16,443 15,662 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 YTD thru July 5,712 9,008 9,422 10,791 10,098 9,314 Aug 4,393 4,830 5,782 5,619 5,499 Nov Dec Jan Feb Sept 4,846 5,152 5,349 5,207 5,480 Oct 5,181 5,670 6,492 6,146 6,263 Nov 4,242 4,904 4,886 5,408 5,183 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 July 125,592 98,501 131,124 100,481 68,761 143,545 YTD thru July 125,592 98,501 131,124 100,481 68,761 143,545 Aug 165,819 185,527 168,019 187,393 221,783 Sept 157,173 176,701 152,605 194,506 217,459 Oct 165,460 189,075 198,474 175,883 231,112 Dec Jan Feb Nov 212,320 226,848 247,632 269,127 300,608 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 18-19 Actuals 40,000 19-20 Actuals 20-21 Actuals 30,000 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 YTD thru July 28,314 26,403 31,468 30,489 25,387 33,174 Aug 29,777 34,965 32,105 32,307 36,722 Nov Dec Jan Feb Mar Apr Sept 29,279 30,148 31,728 32,953 35,288 Oct 28,339 29,291 31,719 32,056 34,519 Nov 30,504 21,702 32,312 33,532 33,565 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 YTD thru July 50,220 54,624 49,797 52,660 57,819 58,196 Oct Aug 47,104 44,633 46,762 51,596 53,366 Nov Dec Jan Feb Mar Apr May June Sept 43,613 44,819 44,112 47,319 50,494 Oct 37,360 39,391 35,672 40,300 42,874 Nov 34,083 38,890 31,619 38,339 40,125 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 YTD thru July 18,836 18,615 17,949 18,374 21,205 19,061 Oct Aug 19,359 22,957 20,417 24,593 22,563 Nov Dec Jan Feb Mar Apr May June Sept 19,337 19,811 21,145 21,373 21,100 Oct 18,611 20,195 23,028 20,975 21,395 Nov 18,347 20,386 19,734 21,142 20,569 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 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 - A7 - May 20,233 20,160 20,980 23,948 22,044 June 20,633 18,345 16,544 18,289 19,071