May 2020 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division May 31, 2020 To the Mayor and City Council: This is the City's Financial Report for May, the eleventh month of fiscal year 2019-20. 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 June 22, 2020 CITY AUDITOR REPORT To the Chief Financial Officer, We have assessed the Finance Department’s (Finance) May 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 16, 2019. 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, Ross Tate City Auditor City of Phoenix Monthly Financial Report May 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 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 Total Operating Expenditures 5 Better than Expected General Government 5 Better than Expected Criminal Justice 6 Better than Expected Performance Status Public Safety 6 Better than Expected Better than Expected - Positive variance of Citywide Expenditures Transportation 7 Better than Expected greater than 1% actual vs budget. 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 Better than Expected Monitor and Consider Taking Action - Negative General Obligation Debt Service 9 Expected 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 Page Performance Status General Fund Total Operating Revenue 13 Expected Property Tax 14 Expected Local Sales Tax 15 Expected State Sales Tax 16 Better than Expected Vehicle License Tax 17 Monitor and Consider Taking Action Governmental Funds 18 Monitor and Consider Taking Action Aviation 19 Monitor and Consider Taking Action Water System 20 Monitor and Consider Taking Action 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. May General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Total General Fund Expenditures 15-16 16-17 17-18 18-19 19-20 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 970,059 1,066,521 91.0% 1,012,772 1,105,361 91.6% 1,073,953 1,177,280 91.2% 1,114,329 1,214,362 91.8% 1,158,430 1,341,015 86.4% * - 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 May YTD Expenditures May YTD Expenditures $600,000 $600,000 Annual Annual Expenditures *Expenditures * $400,000 $400,000 $200,000 $200,000 $0 $0 15-16 16-17 15-16 17-18 18-19 19-20 16-17 17-18 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 2019-20 budgeted general fund expenditures are 10.4% higher than the fiscal year 2018-19 actuals. Fiscal year 2019-20 actual general fund expenditures through May are 4.0% higher than the same period in fiscal year 2018-19. General fund expenditures increased 3.1% in fiscal year 2018-19 over fiscal year 2017-18. This followed increases of 6.5% and 3.6% in the two prior years. General Government 15-16 16-17 17-18 18-19 19-20 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 97,617 105,240 92.8% 98,481 106,754 92.3% 105,100 110,408 95.2% 108,017 114,393 94.4% 116,997 139,831 83.7% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice General Government $115,000 $160,000 $110,000 $140,000 May YTD Expenditures May YTD Expenditures $120,000 $105,000 $100,000 Annual Expenditures * Annual Expenditures * $80,000 $100,000 $60,000 $40,000 $95,000 $20,000 $90,000 $0 15-1616-17 15-16 16-17 17-18 18-19 17-18 19-20 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 2019-20 budget includes a 22.2% increase over fiscal year 2018-19 actuals. General fund general government expenditures through May are 8.3% higher than the same period in the prior fiscal year. General fund general government expenditures increased 3.6% in fiscal year 2018-19 over fiscal year 2017-18. This followed increases of 3.4% and 1.4% in the prior two years. 1 May General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Criminal Justice Criminal Justice May YTD Annual % of Annual Expenditures Expenditures * Expenditures 28,285 30,698 92.1% 29,305 31,595 92.8% 29,520 32,232 91.6% 30,603 33,387 91.7% 32,027 36,665 87.4% $40,000 * - For prior years-total actual expenditures, for current year-total approved budget $5,000 15-16 16-17 17-18 18-19 19-20 Better than Expected May YTD Expenditures $35,000 $30,000 $25,000 Annual Expenditures * $20,000 $15,000 $10,000 $0 15-16 16-17 17-18 18-19 19-20 Criminal justice expenditures include costs for municipal courts and public defenders. The fiscal year 2019-20 budget includes a 9.8% increase over fiscal year 2018-19 actuals. General fund criminal justice expenditures through May are 4.7% higher than the same period in the prior fiscal year. General fund criminal justice expenditures increased 3.6% in the fiscal year 2018-19 over fiscal year 2017-18. This followed increases of 2.0% and 2.9% in the prior two years. Public Safety Public Safety May YTD Annual % of Annual Expenditures Expenditures * Expenditures 672,768 737,129 91.3% 704,011 764,482 92.1% 743,824 817,960 90.9% 771,806 841,467 91.7% 801,173 911,944 87.9% $1,000,000 * - For prior years-total actual expenditures, for current year-total approved budget $0 15-16 16-17 17-18 18-19 19-20 $800,000 May YTD Expenditures $600,000 $400,000 Annual Expenditures * $200,000 15-16 16-17 17-18 18-19 19-20 Better than Expected Public safety expenditures include costs for police and fire services. The general fund public safety fiscal year 2019-20 budget includes a 8.4% increase over fiscal year 2018-19 actuals. Through May, general fund public safety expenditures are 3.8% higher than the prior fiscal year. General fund public safety expenditures increased 2.9% over fiscal year 2018-19 over the fiscal year 2017-18. This followed increases of 7.0% and 3.7% in the prior two years. 2 May General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Transportation Community Development Transportation May YTD Annual % of Annual Expenditures Expenditures * Expenditures 15,614 17,473 89.4% 16,757 17,878 93.7% 15,897 16,366 97.1% 16,465 18,337 89.8% 18,398 20,587 89.4% $1 $30,000 * - For prior years-total actual expenditures, for current year-total approved budget $0 15-16 16-17 17-18 18-19 19-20 Expected $1 MaySeries1 YTD Expenditures $1 $20,000 $1 $0 $10,000 Annual Series2 Expenditures * $0 $0 15-16 16-17 17-18 18-19 19-20 Transportation expenditures include costs for public transit and street maintenance and repair. General Fund transportation expenditures for fiscal year 2019-20 are budgeted to increase 12.3% over fiscal year 2018-19 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 May, General fund transportation expenditures are 11.7% higher than the same period in the prior fiscal year. General fund transportation expenditures decreased significantly in fiscal year 2015-16 from prior years due to the passage of proposition 104 which eliminated the need for approximately $16 million in support for the transit fund from the general fund. Community Development 15-16 16-17 17-18 18-19 19-20 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 16,888 18,571 90.9% 17,870 19,709 90.7% 18,736 20,243 92.6% 19,653 21,238 92.5% 20,843 24,640 84.6% * - For prior years-total actual expenditures, for current year-total approved budget Community Development $30,000 May YTD Expenditures $25,000 $20,000 $15,000 $10,000 Annual Expenditures * $5,000 $0 15-16 Better than Expected 16-17 17-18 18-19 19-20 Community development expenditures include costs for economic development and neighborhood services. The fiscal year 2019-20 budget includes a 16.0% increase over fiscal year 2018-19 actuals. General fund community development expenditures through May are 6.1% higher than the same period in the prior fiscal year. General fund community development expenditures increased in fiscal year 2018-19 over fiscal year 2017-18 by 4.9%. This follows a year over year increase of 2.7% in fiscal year 2017-18 and 6.1% increase in the 2016-17 fiscal year. 3 May General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Community Enrichment Community Enrichment May YTD Annual % of Annual Expenditures Expenditures * Expenditures 125,741 141,483 88.9% 131,187 146,749 89.4% 139,267 156,325 89.1% 142,009 156,552 90.7% 142,110 168,104 84.5% $200,000 * - For prior years-total actual expenditures, for current year-total approved budget $0 15-16 16-17 17-18 18-19 19-20 May YTD Expenditures $160,000 $120,000 Annual Expenditures * $80,000 $40,000 15-16 16-17 17-18 18-19 19-20 Better than Expected Community enrichment expenditures include costs for parks, recreational activities, senior centers and community centers. The fiscal year 2019-20 budget includes a 7.4% increase over fiscal year 2018-19 actuals. Through May, general fund community enrichment expenditures are 0.1% higher than the same period in the prior fiscal year. General fund community enrichment expenditures increased 0.1% in fiscal year 2018-19 over fiscal year 2017-18. This followed increases of 6.5% and 3.7% in the prior two years. Environmental Services 15-16 16-17 17-18 18-19 19-20 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 10,454 12,143 86.1% 11,914 12,775 93.3% 12,692 12,624 100.5% 15,925 16,886 94.3% 16,937 19,792 85.6% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services $24,000 May YTD Expenditures $20,000 $16,000 $12,000 $8,000 Annual Expenditures * $4,000 $0 15-16 Better than Expected 16-17 17-18 18-19 19-20 Environmental service expenditures include costs for maintaining and operating city facilities. The fiscal year 2019-20 budget includes a 17.2 % increase from fiscal year 2018-19 actuals. Because environmental service expenditures are highly dependent on interdepartmental charges, they tend to be very volatile. Through May, general fund environmental services expenditures are 6.4% higher than the prior fiscal year. 4 Citywide Expenditures All expenditures of the City including those for enterprise functions and those related to dedicated revenue streams. Expenditures are reported in total and by program. May Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Total Citywide Operating 15-16 16-17 17-18 18-19 19-20 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 2,807,928 3,156,441 89.0% 3,155,863 3,468,589 91.0% 3,157,804 3,547,078 89.0% 3,536,287 3,775,464 93.7% 3,477,612 4,444,572 78.2% * - 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 $4,500,000 $4,000,000 $3,500,000 $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $0 May YTD Expenditures Annual Expenditures * 15-16 16-17 17-18 18-19 19-20 Better than Expected In order to have a better comparison to prior year actuals, contingencies and vacancy savings will only be included in the annual budget to the extent that they have been spent. Without contingencies and vacancy savings, the budget for fiscal year 2019-20 anticipates an increase of 17.7% over fiscal year 2018-19 actuals in total operating expenditures. Actual expenditures through May are 1.7% lower than the same period in the prior fiscal year. General Government 15-16 16-17 17-18 18-19 19-20 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 110,577 118,505 93.3% 110,991 121,863 91.1% 125,914 134,117 93.9% 128,085 138,349 92.6% 144,723 167,560 86.4% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected General Government $200,000 May YTD Expenditures $150,000 $100,000 Annual Expenditures * $50,000 $0 15-16 16-17 17-18 18-19 19-20 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 May are 13.0% higher than the same period in the prior fiscal year. The budget anticipates an increase of 21.1% for fiscal year 2019-20 over fiscal year 2018-19 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 May Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Criminal Justice 15-16 16-17 17-18 18-19 19-20 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 36,367 39,463 92.2% 38,000 41,117 92.4% 35,151 38,411 91.5% 39,002 42,530 91.7% 40,681 48,764 83.4% * - For prior years-total actual expenditures, for current year-total approved budget Criminal Justice $60,000 May YTD Expenditures $50,000 $40,000 Annual Expenditures * $30,000 $20,000 $10,000 $0 15-16 Better than Expected 16-17 17-18 18-19 19-20 Criminal Justice expenditures include costs of the Municipal Court and the Public Defender’s office. Citywide criminal justice expenditures are 4.3% higher through May than the same period in the prior fiscal year. The budgeted increase for fiscal year 2019-20 over fiscal year 2018-19 actuals is 14.7%. 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 15-16 16-17 17-18 18-19 19-20 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 798,948 874,558 91.4% 831,179 908,553 91.5% 884,684 970,771 91.1% 946,279 1,025,513 92.3% 1,000,535 1,124,185 89.0% * - For prior years-total actual expenditures, for current year-total approved budget Public Safety $1,200,000 $1,000,000 May YTD Expenditures $800,000 $600,000 $400,000 Annual Expenditures * $200,000 $0 15-16 16-17 17-18 18-19 19-20 Better than Expected Public Safety expenditures include costs of Police, Fire and Emergency Management. Citywide public safety expenditures through May are 5.7% higher than the same period in the prior fiscal year. The budgeted increase for fiscal year 2019-20 over fiscal year 2018-19 actuals is 9.6%. 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 May Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Transportation 15-16 16-17 17-18 18-19 19-20 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 556,996 609,990 91.3% 602,167 642,850 93.7% 655,099 709,977 92.3% 686,382 722,667 95.0% 742,448 821,667 90.4% * - For prior years-total actual expenditures, for current year-total approved budget Transportation $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $0 May YTD Expenditure s Annual Expenditure s* 15-16 Better than Expected 16-17 17-18 18-19 19-20 Transportation expenditures include costs for Street lighting, maintenance and repair; Aviation and Public Transit. Citywide transportation expenditures are 8.2% higher through May than the same period in the prior fiscal year. The budget anticipates an increase of 13.7% for fiscal year 2019-20 from fiscal year 2018-19 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 15-16 16-17 17-18 18-19 19-20 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 160,487 174,956 91.7% 169,516 188,365 90.0% 184,160 203,096 90.7% 176,922 195,716 90.4% 190,633 239,073 79.7% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Community Development $300,000 May YTD Expenditures $250,000 $200,000 $150,000 Annual Expenditures * $100,000 $50,000 $0 15-16 16-17 17-18 18-19 19-20 Community Development expenditures include costs for Neighborhood Services, Housing, Planning and Economic Development. Citywide community development expenditures through May are 7.7% higher than the same period in the prior fiscal year. The fiscal year 2019-20 budget includes an increase of 22.2% over fiscal year 2018-19 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 May Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Community Enrichment 15-16 16-17 17-18 18-19 19-20 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 246,711 273,179 90.3% 259,713 292,983 88.6% 273,104 306,763 89.0% 288,290 317,465 90.8% 289,202 361,444 80.0% * - 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 May YTD Expenditures Annual Expenditures * 15-16 16-17 17-18 18-19 19-20 Better than Expected Community Enrichment expenditures include costs for Parks, Libraries, the Convention Center, Senior Centers and Community Centers. Citywide community enrichment expenditures through May are 0.3% higher than the same period in the prior fiscal year. The fiscal year 2019-20 budget anticipates an increase of 13.9% from fiscal year 2018-19 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 15-16 16-17 17-18 18-19 19-20 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 502,949 555,711 90.5% 549,693 599,837 91.6% 574,166 696,244 82.5% 624,084 670,219 93.1% 636,305 724,310 87.8% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $0 May YTD Expenditures Annual Expenditures * 15-16 16-17 17-18 18-19 19-20 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.0% higher through May than the same period in the prior fiscal year. The fiscal year 2019-20 budget anticipates an increase of 8.1% from fiscal year 2018-19 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 May Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 General Obligation Debt Service Citywide Debt Service Expenditures 15-16 16-17 17-18 18-19 19-20 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 139,962 154,710 90.5% 125,799 137,205 91.7% 97,502 106,315 91.7% 106,916 116,634 91.7% 119,923 131,082 91.5% * - For prior years-total actual expenditures, for current year-total approved budget net of credit for early redemption fund resources $180,000 May YTD Expenditures $120,000 $60,000 Annual Expenditures * $0 15-16 16-17 17-18 18-19 19-20 Expected General obligation debt service expenditures through May are 12.2% higher than the same period in the prior fiscal year. Budgeted expenditures for fiscal year 2019-20 are 12.4% higher than fiscal year 2018-19 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 15-16 16-17 $ 238,739 $ 315,502 Refer to detailed financial schedules pages 22 - 34 17-18 $ 290,772 18-19 19-20 (Budget) 19-20 (YTD) $ 384,131 $ 986,875 $ 421,725 Discussion: General Gov't Major projects in fiscal year 2015-16 include street construction, improvement and repair ($67 million), affordable and low income housing related projects ($19 million), parks and recreation projects ($22 million), and transit related projects ($62 million). 19-20 (YTD) 19-20 (Budget) 18-19 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). 17-18 16-17 15-16 $0 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). $500,000 $1,000,000 $1,500,000 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 budgeted for fiscal year 2019-20 include Light Rail ($170.5 million), Talking Stick Arena Renovations ($150.0 million), pavement maintenance ($112.2 million), major streets ($70.3 million), parks preserve development, acquisition, and development ($67.7 million), transit fare collection system replacement ($57.9 million), bus purchases ($40.6 million), replacing the city's badging and access control system ($24.0 million), KIVA replacement ($19.8 million), and Data Center Modernization ($16.8M). Aviation 15-16 16-17 $ 522,633 $ 151,957 17-18 $ 582,921 18-19 19-20 (Budget) 19-20 (YTD) $ 552,972 $ 380,845 $ 237,663 Discussion: Aviation Major projects in fiscal year 2015-16 include Terminal 3 Development ($373 million), Terminal 4 improvements and refurbishments ($28 million), Terminal 4 North Apron Reconstruction ($24 million) and improvements at the satellite airports ($17 million). 19-20 (YTD) 19-20 (Budget) 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). 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). 18-19 17-18 16-17 15-16 $0 $200,000 $400,000 $600,000 Major projects budgeted for fiscal year 2019-20 include PHX Terminal 4 south concorse and gates ($110M), Runway, Apron and Taxiway Improvements ($70M), and PHX Sky Train ($35M). - 10 - Capital Expenditures (Dollars in Thousands) Phx Convention Ctr 15-16 16-17 $ 24,554 $ 21,885 Refer to detailed financial schedules pages 22 - 34 17-18 $ 19-20 (Budget) 18-19 28,898 $ 36,542 Discussion: $ 64,075 19-20 (YTD) $ 48,652 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 2019-20. Other major projects budgeted for fiscal year 201920 include shoring wall ($31.2 million) and exhibit hall lighting ($2.6 million). 15-16 $ Solid Waste 8,781 19-20 (YTD) 19-20 (Budget) 18-19 17-18 16-17 15-16 $0 16-17 $ 7,460 17-18 $ 10,355 $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 19-20 (Budget) 18-19 $ 7,857 $ 19,248 19-20 (YTD) $ 5,192 Discussion: Solid Waste In fiscal year 2014-15 Solid Waste spent $16 million for the 27th avenue composting facility and $6 million for the SR85 landfill. 19-20 (YTD) In fiscal year 2015-16, Solid Waste spent $2.5 million on the 27th Ave Resource Innovation Campus. 19-20 (Budget) In fiscal year 2016-17, Solid Waste spent $3.7 million on the 27th Avenue Composting Facility and $2.2 million on the 27th Avenue Resource Innovation Campus. In fiscal year 2017-18 Solid Waste spent $10.3 million on SR85 Landfill requirements. In fiscal year 2018-19 Solid Waste spent $4.5 million on North Gateway material recovery facility upgrade and $1.5 million on SR 85 Landfill. Major projects budgeted for fiscal year 2019-20 include $12 million in transfer stations and $2.5 million for solid waste projects and unexpected expenditures. 18-19 17-18 16-17 15-16 $0 $10,000 $20,000 $30,000 - 11 - Capital Expenditures (Dollars in Thousands) 15-16 Wastewater $ 42,084 Refer to detailed financial schedules pages 22 - 34 16-17 $ 106,776 17-18 $ 105,912 19-20 (Budget) 18-19 $ 97,890 $ 202,899 19-20 (YTD) $120,507 Discussion: In fiscal year 2015-16 Wastewater spent $18 million on rehabilitation and replacement of sewer mains and lines and an additional $16 million on capital improvements at the wastewater treatment facilities. 19-20 (YTD) In fiscal year 2016-17, Wastewater spent $30 million to construct, replace or rehabilitate pipelines, $25 million for 19-20 (Budget) the construction of the biogas project at the 91st Avenue Wastewater Treatment Plant, $16 million for 18-19 improvements at the 91st Avenue wastewater treatment plant, and $10 million for improvements at the 23rd 17-18 Avenue wastewater treatment plant. In fiscal year 2017-18, Wastewater spent $54 million on 16-17 pipeline assessment, repair, replacement and construction and $23 million on improvements at the 91st 15-16 Avenue Wastewater Treatment Plant. In fiscal year 2018-19 , Wastewater spent $45.2 million in $0 $50,000 $100,000 $150,000 $200,000 $250,000 sewer main replacement and construction and $32.5 million on improvements and maintenance at the wastewater treatment plants. Major projects budgeted in fiscal year 2019-20 include sewer replacement and construction ($126.3 million), 91st Ave Waste Water Tretment Plant ($28.6 million), and lift stations ($20.4 million). Wastewater 15-16 Water System $ 99,091 16-17 $ 189,809 17-18 $ 229,256 19-20 (Budget) 18-19 $ 289,858 $ 377,175 19-20 (YTD) $200,903 Discussion: Water System 19-20 (YTD) 19-20 (Budget) 18-19 17-18 16-17 15-16 $0 $100,000 $200,000 $300,000 In fiscal year 2015-16 the water system spent over $16 million for rehabilitation at the Val Vista water treatment plant. Additionally, over $41 million has been spent for assessment, rehabilitation and replacement of hydrants, valves, mains and lines. 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. Major projects budgeted in fiscal year 2019-20 incldue water main replacement and construction ($150.2 million), field site consolidation ($36.0 million), Val Vista design and rehabilitation construction ($33.8 million), and designing and constructing new water supply wells ($25.6 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 May YTD Revenues $1,000,000 $800,000 $600,000 $400,000 Annual Revenues* $200,000 $0 15-16 15-16 16-17 17-18 18-19 19-20 16-17 May YTD Revenues 959,745 990,073 1,055,977 1,100,525 1,153,470 Annual Revenues* 1,063,211 1,094,933 1,162,635 1,220,768 1,272,831 17-18 18-19 19-20 % of Annual Revenues 90.3% 90.4% 90.8% 90.2% 90.6% * - For prior years - total actual revenues, for current year - total approved budget Expected Fiscal year 2019-20 general fund operating revenues are budgeted to increase 4.3% over prior year actuals. Actual revenues through May are 4.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 91,021 180,000 95,435 107,881 101,652 97,403 Secondary 50,484 150,000 120,000 90,000 60,000 141,309 146,121 154,560 162,129 153,499 170,899 15-16 16-17 17-18 18-19 19-20 YTD 19-20 Budget Primary 30,000 - FY 15-16 16-17 17-18 18-19 19-20 YTD 19-20 Budget Total 191,793 237,142 249,995 263,781 250,902 278,780 July (981) (1,004) (1,054) (1,049) (1,141) (1,153) Aug 641 454 (395) 688 1,081 277 Sept 857 773 891 980 647 982 Oct 15,224 12,067 16,220 12,601 11,579 15,180 Nov 60,232 57,953 87,691 91,331 106,458 87,978 Dec 21,975 51,488 25,018 30,444 23,612 39,705 Jan 8,268 10,013 10,162 13,302 14,875 12,428 Feb 3,815 4,033 7,020 5,422 7,447 6,116 Mar 5,779 6,593 8,086 8,130 8,185 8,468 Apr 9,409 12,231 11,994 12,026 12,116 13,458 May 42,177 60,943 52,962 68,870 66,043 67,856 June 24,397 21,598 31,400 21,036 27,485 Note: Monthly budget amount for 19-20 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 2019-20 over fiscal year 2018-19 actuals. - 14 - Primary Secondary 141,309 50,484 146,121 91,021 154,560 95,435 162,129 101,652 153,499 97,403 170,899 107,881 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 19-20 Actuals 30,000 19-20 Budget 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Expected Fiscal year 2019-20 local sales tax revenues through May are 6.0% higher than the same period in the prior year. Actual local sales tax revenues through May are 0.1% lower than budget expectations. Local Sales Tax 3 Year Trend 70,000 60,000 50,000 17-18 Actuals 40,000 18-19 Actuals 30,000 19-20 Actuals 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2018-19 local sales tax revenues were 10.5% higher than the prior year. This follows increases of 2.8% and 1.9% 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 19-20 Actuals 15,000 19-20 Budget 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Better than Expected The fiscal year 2019-20 budget includes an increase of 4.5% in state shared sales tax over fiscal year 2018-19 actuals. Through May state shared sales tax revenues are 4.0% above budget expectations. State Sales Tax 3 Year Trend 25,000 20,000 15,000 17-18 Actuals 18-19 Actuals 10,000 19-20 Actuals 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2018-19 state sales tax revenues were 5.8% higher than the prior year. This follows increases of 8.4% and 4.7% 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 19-20 Actuals 6,000 19-20 Budget 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Monitor and Consider Taking Action State shared vehicle license tax revenues through May 2020 are 3.2% lower than budget expectations for the period. Vehicle License Tax 3 Year Trend 12,000 10,000 17-18 Actuals 8,000 18-19 Actuals 6,000 19-20 Actuals 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2018-19 state shared vehicle license tax revenues were 5.1% higher than the prior year. This follows increases of 8.4% and 3.0% 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 350,000.00 300,000.00 250,000.00 19-20 Budget 200,000.00 2019-20 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 May 2020 are 4.0% lower than budget expectations for the period. Governmental Funds Revenues 3 Year Trend 260,000.00 210,000.00 160,000.00 2017-18 Actuals 110,000.00 2018-19 Actuals 60,000.00 2019-20 Actuals 10,000.00 (40,000.00) July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2018-19 governmental fund revenues were 4.1% higher than the prior year. This follows increases of 4.9% and 8.3% 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 40,000 35,000 30,000 25,000 19-20 Actuals 20,000 19-20 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 May 2020 are 1.9% lower than budget expectations for the period. Aviation Operating Revenues 3 Year Trend 45,000 40,000 35,000 30,000 25,000 17-18 Actuals 20,000 18-19 Actuals 15,000 19-20 Actuals 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr Fiscal year 2018-19 aviation revenues were 2.5% higher than the prior year. This follows increases of 8.7% and 2.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 60,000 50,000 40,000 19-20 Actuals 30,000 19-20 Budget 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Monitor and Consider Taking Action Water system revenues through May 2020 are 1.8% lower than budget expectations for the period. Water System Operating Revenues 3 Year Trend 60,000 50,000 40,000 17-18 Actuals 30,000 18-19 Actuals 20,000 19-20 Actuals 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May Fiscal year 2018-19 water system revenues were 7.3% lower than the prior year. This follows increases of 4.0% and 5.3% in the two previous years. Click Here for Additional Information - 20 - June Wastewater Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Wastewater Operating Revenues Budget vs Actual 30,000 25,000 20,000 19-20 Budget 15,000 19-20 Actuals 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Better than Expected Wastewater revenues through May 2020 are 4.8% higher than budget expectations for the period. Wastewater Operating Revenues 3 Year Trend 30,000 25,000 20,000 17-18 Actuals 15,000 18-19 Actuals 10,000 19-20 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 MAY 31 (dollars in thousands) Budget Estimate 2019-2020 Actual Year-to-Date 2019-2020 2018-2019 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 $ $ 502,650 2,779 $ 447,494 $ 2,363 422,269 2,757 172,557 215,228 75,597 170,899 2,998 11,152 166,605 196,806 67,873 153,499 2,560 7,769 156,768 180,508 66,934 148,950 2,718 8,276 12,663 1,409 14,231 570 7,163 1,755 4,806 9,775 1,153 14,093 341 5,243 1,468 6,056 11,566 1,218 14,148 848 6,328 1,616 6,365 36,964 1,400 12,642 9,407 15,962 34,467 1,302 12,464 9,222 12,917 33,548 1,212 11,571 8,916 14,009 1,272,831 - 22 - $ 1,153,470 $ 1,100,525 General Fund Expenditures As of MAY 31 (dollars in thousands) Budget Estimate 2019-2020 Actual Year-to-Date 2019-2020 2018-2019 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,094 4,751 2,873 45,528 2,357 2,702 25,841 3,345 7,258 11,530 3,659 24,975 2,918 139,831 $ 1,411 $ 3,641 3,405 41,091 2,197 1,937 19,939 2,350 4,278 10,848 3,022 20,474 2,404 116,997 1,368 3,196 1,881 34,225 1,888 1,972 18,770 2,650 5,843 9,784 2,777 19,930 3,733 108,017 Criminal Justice Municipal Court Public Defender Total Criminal Justice 31,376 5,289 36,665 27,097 4,930 32,027 26,073 4,530 30,603 Public Safety Police Fire Others Total Public Safety 566,452 345,429 63 911,944 503,882 297,176 115 801,173 497,675 274,225 (94) 771,806 Transportation Street Transportation Public Transit Total Transportation 18,947 1,640 20,587 16,758 1,640 18,398 14,674 1,791 16,465 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 6,054 14,073 4,334 179 24,640 5,087 12,293 3,325 138 20,843 4,750 11,751 3,107 45 19,653 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 101,458 39,710 20,157 6,779 168,104 83,850 35,047 17,551 5,662 142,110 81,544 34,372 16,887 9,206 142,009 Environmental Services Public Works Environmental Programs Others Total Environmental Services 18,475 800 517 19,792 15,740 560 637 16,937 15,358 567 15,925 Capital Improvement 19,452 9,945 9,851 Vacancy Savings (5,000) - - Contingencies 57,912 - - Total Expenditures and Encumbrances $ 1,393,927 - 23 - $ 1,158,430 $ 1,114,329 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 MAY 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 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 Budget Estimate 2019-2020 $ 502,650 2,779 Actual Year-to-Date 2019-2020 2018-2019 447,494 $ 2,363 422,269 2,757 172,557 215,228 75,597 170,899 2,998 11,152 14,072 14,231 570 7,163 1,755 4,806 51,006 9,407 15,962 166,605 196,806 67,873 153,499 2,560 7,769 10,928 14,093 341 5,243 1,468 6,056 48,232 9,222 12,917 156,768 180,508 66,934 148,950 2,718 8,276 12,784 14,148 848 6,328 1,616 6,365 46,331 8,916 14,009 1,272,831 1,153,470 1,100,525 37,258 101,758 37,513 5,514 297,675 4,913 66,542 8,837 27,571 145,919 40,580 6,251 37,600 352,704 112,653 32,978 86,503 34,828 6,465 265,062 3,787 72,474 8,174 19,456 131,031 38,283 8,453 21,525 192,884 99,125 31,226 83,977 32,509 5,981 257,938 3,787 69,200 8,375 23,116 128,887 34,421 3,052 43,459 184,568 96,193 1,283,288 1,021,028 1,006,689 394,789 91,048 456,571 242,954 150,958 351,643 71,913 401,975 234,370 138,714 359,295 76,180 364,714 226,487 141,192 1,336,320 1,198,614 1,167,868 $ 3,892,439 - 24 - $ $ 3,373,112 $ 3,275,083 Citywide Operating Expenditures As of MAY 31 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2019-2020 2018-2019 Budget 2019-2020 116,997 $ 27,726 144,723 108,017 20,068 128,085 36,665 12,099 48,764 32,027 8,654 40,681 30,603 8,399 39,002 Public Safety General Funds Other Funds Total Public Safety 911,944 212,241 1,124,185 801,173 199,362 1,000,535 771,806 174,473 946,279 Transportation General Funds Other Funds Total Transportation 20,587 801,080 821,667 18,398 724,050 742,448 16,465 669,917 686,382 Community Development General Funds Other Funds Total Community Development 24,640 214,433 239,073 20,843 169,790 190,633 19,653 157,269 176,922 Community Enrichment General Funds Other Funds Total Community Enrichment 168,104 193,340 361,444 142,110 147,092 289,202 142,009 146,281 288,290 Environmental Services General Funds Other Funds Total Environmental Services 19,792 704,518 724,310 16,937 619,368 636,305 15,925 608,159 624,084 Debt Service General Funds Other Funds Total Debt Service 131,082 131,082 119,923 119,923 106,916 106,916 Capital Improvement General Funds Other Funds Total Capital Improvement 19,452 807,035 826,487 9,945 303,217 313,162 9,851 530,476 540,327 Vacancy Savings General Funds Other Funds Total Vacancy Savings (5,000) (5,000) - - Contingencies General Funds Other Funds Total Contingencies 57,912 57,500 115,412 - - 1,393,927 3,161,057 4,554,984 1,158,430 2,319,182 3,477,612 $ $ Criminal Justice General Funds Other Funds Total Criminal Justice Total Operating General Funds Other Funds Total Operating Budget $ 139,831 27,729 167,560 $ $ - 25 - 1,114,329 2,421,958 3,536,287 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 MAY 31 2020 2019 Budget Estimate 2019-2020 Source Actual Year-to-Date 2019-2020 2018-2019 General Funds $ 34,411,944 56,900 34,468,844 $ 27,145,826 296,567 Local Taxes: Sales Taxes Privilege License Fees $ 502,650,000 2,778,500 $ 447,494,392 2,363,226 $ 422,268,705 2,757,025 27,442,393 Total Local Taxes 505,428,500 449,857,618 425,025,730 11,287,542 17,891,435 4,699,035 14,640,544 16,409,929 5,958,787 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 172,557,000 215,228,000 75,597,000 166,604,644 196,805,779 67,872,823 156,768,070 180,507,909 66,933,844 33,878,012 37,009,260 463,382,000 431,283,246 404,209,823 40,112,848 41,974,189 Primary Property Tax 170,899,000 153,499,418 148,950,223 252,603 343,419 Licenses and Permits 2,998,000 2,560,040 2,717,958 2,659,558 0 Cable Communications 11,152,000 7,769,411 8,275,625 682,583 114,445 899,788 113,385 Municipal Court: Fines and Forfeitures Court Default Fee 12,662,750 1,409,000 9,774,980 1,153,466 11,566,066 1,218,365 797,028 1,013,173 14,071,750 10,928,446 12,784,431 996,030 1,374,353 14,230,592 14,093,021 14,147,652 8,217 304,494 Library Fees 569,801 341,289 847,976 208,405 602,405 Parks and Recreation 7,163,316 5,243,105 6,328,399 88,435 172,845 Planning and Development 1,755,490 1,467,848 1,616,281 1,306,146 1,411,174 Street Transportation 4,805,543 6,056,062 6,364,734 2,592,114 248,725 966,894 1,087,071 194,875 712,864 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other 36,964,000 1,400,000 12,641,599 34,466,524 1,301,525 12,464,185 33,547,780 1,211,725 11,571,476 3,807,733 1,994,810 51,005,599 48,232,234 46,330,981 615,276 957,369 Interest 9,407,000 9,221,876 8,916,295 318,120 775,204 Other Fees and Service Charges 15,961,784 12,916,899 14,009,253 119,517,255 115,375,088 1,272,830,375 1,153,470,513 1,100,525,361 Total State Shared Taxes Total Municipal Court Police Total Fire Total General Funds 26 Citywide Operating Revenue by Source (continued) For the Month Ended MAY 31 2020 2019 Budget Estimate 2019-2020 Source Actual Year-to-Date 2019-2020 2018-2019 Special Revenue and Debt Service Funds $ 1,806,606 129,043 645,217 23,173 $ 2,604,039 5,542,351 1,898,357 10,885 2,029,302 144,950 724,751 34,678 2,933,681 $ $ $ 7,451,593 12,369,155 5,897,802 32,026 18,298,983 2,782,046 $ 3,046,651 526,348 0 244,791 987 14,226 $ $ $ $ $ 396,697 0 181,564 (271) 293,099 786,352 17,698,364 6,162,094 $ $ 23,860,458 Total Public Safety Enhancement & Expansion $ 22,683,262 1,620,233 8,101,165 573,661 $ 21,463,364 1,533,097 7,665,487 564,000 37,258,000 32,978,321 31,225,948 75,998,000 25,316,000 444,000 65,047,374 21,052,137 403,007 62,853,366 20,717,377 406,088 101,758,000 86,502,518 83,976,831 Parks and Preserves 37,513,347 34,828,440 32,508,820 Golf Courses: Fees Coffee Shops Concessions Interest Other 3,372,500 0 1,883,000 0 258,285 4,118,915 0 2,046,146 3,881 296,290 3,496,207 0 2,024,014 (11,328) 472,451 5,513,785 6,465,232 5,981,344 19,775,444 4,468,846 Transit 2000 & 2050: Sales Taxes Interest/Other 249,936,000 47,738,578 221,509,327 43,552,546 209,490,973 48,446,545 297,674,578 265,061,873 257,937,518 Court Awards 4,913,184 3,786,517 3,786,768 Planning and Development 66,542,000 72,474,065 69,200,067 Capital Construction 8,837,000 8,173,890 8,375,477 Sports Facilities: Sales Taxes Interest/Other 23,063,000 4,508,180 17,059,268 2,396,515 18,606,081 4,509,711 27,571,180 19,455,783 23,115,792 $ 0 4,634,309 $ 6,024,598 783,468 $ 795,180 749,327 Total Neighborhood Protection Public Safety Enhancement & Expansion: Police Fire Interest/Other 25,633,000 1,831,000 9,155,000 639,000 Total Golf Courses 24,244,290 $ $ $ 871,089 0 676,994 72,333 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 1,925,113 89,780 2,014,893 Total Transit 2000 & 2050 Total Sports Facilities 27 Citywide Operating Revenue by Source (continued) For the Month Ended MAY 31 2020 2019 Source Budget Estimate 2019-2020 Actual Year-to-Date 2019-2020 2018-2019 145,617,000 152,000 150,000 128,414,714 1,729,670 886,560 127,131,192 1,774,771 (18,730) 145,919,000 131,030,944 128,887,233 Special Revenue and Debt Service Funds (Cont'd) $ 9,560,680 121,200 26,455 11,386,756 179,244 6,108 9,708,335 11,572,108 - $ Total Highway User Revenue 0 0 0 4,165,724 7,149,100 Regional Transit Revenues 40,580,254 38,283,272 34,421,249 115,478 1,105,537 Community Reinvestment 6,250,792 8,453,260 3,052,062 604,719 5,903,471 Other Restricted Fees 37,599,774 21,525,145 43,459,382 507,061 7,497,628 4,570,823 633,478 8,672,839 515,757 Grants: Public Housing: Rentals Grants Other 7,990,700 81,312,772 25,830,102 7,455,301 79,147,561 20,194,209 8,035,389 74,352,645 5,571,755 12,575,512 9,822,074 115,133,574 106,797,071 87,959,789 56,270,174 111,361,958 30,988,877 38,949,477 45,514,928 6,329,471 10,665,786 23,576,399 39,762,072 17,125,700 7,041,684 32,678,889 4,190,042 188,989 2,426,032 2,579,542 - Highway User Revenue: Highway User Revenue Interest Other 4,056,234 1,088,623 96,810 3,962,268 Local Transportation Assistance $ Total Public Housing Other: Human Resources Federal Transit Administration Community Development Other 9,384,605 9,203,935 Total Other 237,570,486 86,086,584 96,608,345 21,960,117 19,026,009 Total Grants 352,704,060 192,883,655 184,568,134 25,930,579 (214) 26,895,672 0 107,881,000 4,772,266 97,402,511 1,722,021 93,794,898 2,397,975 25,930,365 26,895,672 112,653,266 99,124,532 96,192,873 106,136,330 129,881,262 1,283,288,220 1,021,027,447 1,006,689,498 160,590,000 218,625,000 5,500,000 4,403,200 2,589,500 3,081,500 0 101,651,740 233,782,788 5,754,138 1,905,514 2,627,029 3,104,709 2,816,841 100,956,824 245,656,797 4,911,482 1,079,785 2,436,680 2,881,794 1,371,292 394,789,200 351,642,759 359,294,654 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,014,446 14,522,389 416,447 958,761 179,107 240,750 192,174 9,329,211 23,487,162 491,124 456,605 201,024 264,744 165,820 23,524,074 34,395,690 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 MAY 31 2020 2019 Budget Estimate 2019-2020 Source Actual Year-to-Date 2019-2020 2018-2019 Enterprise Funds (Cont'd) CONVENTION CENTER: $ 3,580,175 57,620 93,888 5,188,268 1,970,850 123,910 3,731,683 7,283,028 38,256,379 180,392 448,512 1,198,364 354,360 298,957 (294,595) 34,069,583 458,933 334,572 508,686 315,210 281,279 324,514 40,442,369 36,292,777 Excise Taxes Operating Revenue Interest Total Convention Center 66,626,000 23,421,704 1,000,000 51,170,019 19,522,041 1,220,580 53,343,158 21,849,067 988,095 91,047,704 71,912,640 76,180,320 431,411,000 5,500,000 5,210,000 6,499,000 3,800,000 2,734,000 1,417,000 371,840,678 3,988,247 5,593,438 6,575,258 5,100,042 5,771,822 3,105,702 338,488,991 5,027,216 4,921,011 5,857,352 3,796,665 3,631,292 2,991,190 456,571,000 401,975,187 364,713,717 WATER SYSTEM: $ Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System WASTEWATER: 17,093,470 3,338,760 338,700 327,081 2,849,567 17,112,090 1,603,203 295,140 367,832 1,601,192 Sewer Service Charges Multi-City Development Fees Interest Other 205,243,000 18,052,000 3,700,000 1,994,000 13,965,000 188,644,619 18,482,268 4,749,180 4,136,031 18,357,571 186,255,257 18,556,522 3,649,680 3,597,405 14,428,078 23,947,578 20,979,457 Total Wastewater 242,954,000 234,369,669 226,486,942 131,647,000 7,811,400 400,000 11,099,474 125,599,255 8,060,983 687,192 4,366,716 121,238,369 7,773,851 915,863 11,264,101 150,957,874 138,714,146 141,192,184 1,336,319,778 1,198,614,401 1,167,867,817 SOLID WASTE: $ 12,718,711 826,560 38,416 358,347 11,079,052 867,441 93,964 751,103 13,942,034 12,791,560 105,587,738 111,742,512 331,241,323 $ 356,998,862 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ 29 3,892,438,373 $ 3,373,112,361 $ 3,275,082,676 For the Month Ended MAY 31 2020 2019 Program Budget Estimate 2019-2020 2019-2020 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2019-2020 2018-2019 General Government $ 108,905 $ 411,254 294,021 3,978,991 328,875 199,825 293,186 1,519,382 39,741 281,397 1,004,911 197,098 7,900 (265,113) 4,153,491 109,806 140,073 314,675 (1,144,473) 4,522,133 155,010 202,993 225,234 1,381,852 127,136 469,670 1,168,416 (258,497) 196,868 9,919 (239,051) 1,369,910 475,848 12,663,670 9,117,716 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,093,626 4,750,584 3,191,391 58,548,946 5,167,856 2,735,515 3,230,617 27,692,854 3,344,780 7,257,781 12,898,318 105,048 3,659,188 28,101,022 4,782,943 $ 1,410,980 3,641,177 3,491,722 53,368,765 2,773,698 2,255,746 2,295,348 21,351,223 2,349,825 4,278,277 12,001,159 341,688 90,072 3,025,488 29,173,161 2,874,857 $ 1,368,699 3,195,621 2,026,530 45,926,387 1,177,317 2,232,185 2,274,875 20,008,835 2,649,531 5,843,171 10,920,865 330,147 121,453 2,148,698 77,174 2,776,968 22,460,406 2,546,361 $ 1,410,980 3,641,177 3,491,722 42,231,297 2,773,698 2,255,746 2,295,348 21,351,223 2,349,825 4,278,277 11,252,788 341,688 90,072 3,025,488 28,337,526 2,874,857 11,137,468 748,371 835,635 - 167,560,469 144,723,188 128,085,223 132,001,714 12,721,474 43,474,862 5,289,134 35,751,226 4,929,633 34,472,228 4,529,747 29,589,415 4,929,633 6,161,811 - 48,763,996 40,680,859 39,001,975 34,519,048 6,161,811 721,210,722 401,998,584 975,928 642,614,569 357,045,649 874,307 616,767,376 328,714,232 797,189 640,230,069 353,167,453 874,307 2,384,500 3,878,196 - 1,124,185,234 1,000,534,525 946,278,797 994,271,828 6,262,696 Criminal Justice 3,406,692 439,069 3,120,105 430,672 3,845,760 3,550,777 Municipal Court Public Defender Total Criminal Justice Public Safety 52,224,573 23,531,441 101,242 59,474,290 29,132,876 101,972 75,857,256 88,709,138 Police Fire Other Total Public Safety -30- Citywide Operating Expenditures by Program (continued) For the Month Ended MAY 31 2020 2019 Budget Estimate 2019-2020 Program 2019-2020 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2019-2020 2018-2019 Transportation $ 6,251,168 682,465 26,571,946 3,034,118 36,539,698 $ 6,020,650 700,660 30,011,626 10,252,935 Street Transportation Street Lighting Aviation Public Transit 46,985,871 Total Transportation $ 98,411,850 11,415,352 371,376,781 340,462,560 $ 88,582,866 8,422,342 316,532,464 328,910,629 $ 67,986,834 9,720,633 294,424,086 314,250,933 $ 84,639,480 8,422,342 236,790,189 258,298,907 3,943,386 79,742,275 70,611,722 821,666,543 742,448,302 686,382,486 588,150,919 154,297,384 Community Development 4,821,551 9,197,671 1,591,362 2,260,528 5,130,476 7,359,389 1,156,359 3,202,746 Planning and Development Housing Economic Development Neighborhood Services Department 71,928,530 100,338,355 19,590,335 47,215,711 56,751,160 86,759,688 15,646,231 31,475,950 50,370,310 81,352,584 12,289,891 32,908,999 56,751,160 86,694,360 9,624,026 31,475,950 65,328 6,022,205 - 17,871,111 16,848,970 Total Community Development 239,072,931 190,633,029 176,921,784 184,545,495 6,087,534 116,840,992 40,933,224 76,695,514 23,221,844 94,267,469 5,218,616 4,266,751 98,344,060 35,694,590 64,331,644 6,164,683 76,451,029 4,647,551 3,568,019 96,054,275 35,098,951 60,538,268 11,558,099 73,461,791 4,357,365 7,221,552 97,986,801 35,694,590 46,043,281 76,379,156 4,647,551 3,568,019 357,259 18,288,363 6,164,683 71,872 - 361,444,410 289,201,576 288,290,301 264,319,398 24,882,178 Community Enrichment 7,547,720 2,592,989 4,383,470 508,218 6,265,061 78,796 178,717 8,849,454 4,111,322 3,945,835 1,002,354 7,685,495 150,393 621,353 21,554,972 26,366,206 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 MAY 31 2020 2019 Budget Estimate 2019-2020 Program 2019-2020 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2019-2020 2018-2019 Environmental Services $ 24,728,958 $ 12,991,839 9,935,632 (284,778) 244,159 64,096 16,650,834 30,210,210 11,941,122 1,838,581 394,793 - 47,679,905 61,035,540 Water System Wastewater Solid Waste Management Public Works Environmental Programs Manager's Office of Sustainability Total Environmental Services $ 352,029,642 180,174,026 161,607,654 28,316,137 1,615,942 566,826 $ 313,929,907 156,623,393 141,072,810 22,875,129 1,167,519 636,618 $ 303,617,446 160,633,055 142,927,891 15,599,466 1,305,782 - $ 204,646,260 92,184,215 129,529,194 16,293,757 1,167,519 636,618 109,283,647 64,439,177 11,543,616 6,581,372 191,847,813 724,310,227 636,305,375 624,083,640 444,457,563 3,427,700 11,403,627 6,094,187 689,851 7,085,999 609,975 10,391,879 2,175,683 13,587,513 7,228,737 3,507,397 18,169,466 10,300 42,192 6,783,905 4,952,259 2,499,585 651,286 998,000 16,044,266 7,469,127 6,150 7,252,932 3,142,058 10,453,323 5,586,337 632,363 6,495,499 559,144 9,525,888 1,994,375 12,455,220 6,626,342 3,215,114 16,655,342 9,442 6,218,579 4,539,570 2,291,283 25 1,314,833 14,707,243 6,846,698 5,638 6,648,518 4,323,963 11,156,159 18,293,317 232,348 9,808,113 307,060 5,559,874 755,991 8,922,671 7,546,144 612,513 11,467,540 275 5,593,481 1,700,891 2,158,000 24 1,594,450 1,545 11,762,177 4,638,879 5,638 474,768 3,142,058 10,453,323 5,586,337 632,363 6,495,499 559,144 9,525,888 1,994,375 12,455,220 6,626,342 3,215,114 16,655,342 9,442 6,218,579 4,539,570 2,291,283 25 1,314,833 14,707,243 6,846,698 5,638 6,648,518 - 119,922,834 - General Obligation Debt Service 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 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,915,710 9,721,023 Total Debt Service 131,082,016 119,922,834 106,915,821 26,341,690 63,900,869 Capital Improvement 826,486,943 313,161,555 540,327,379 $ 393,088 1,014,196 1,663,029 21,122 891,647 27,914 505,443 68,727 811,152 686,013 55,683 1,042,504 25 508,498 154,626 196,182 144,950 1,545 1,069,289 421,717 513 43,160 253,269,771 - Vacancy Savings - Contingencies 326,236,110 (5,000,000) - 115,412,000 - 4,554,984,769 3,477,611,242 -32- 3,536,287,406 - - - - 2,762,188,798 402,260,890 Capital Expenditures and Encumbrances 2019-2020 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 $ $ $ 2018-2019 Actual Yearto-Date Actual Yearto-Date From Operating Funds Budget Actual 997,902 $ 164,723,704 43,787,042 16,353,120 41,475,777 600,000 23,648,943 925,000 4,983,760 96,649,964 19,772,000 321,805,336 9,203,942 241,948,272 96,364 $ 32,040,855 11,391,393 0 625,311 5,975,062 2,763,554 362,852 2,344,198 50,480,191 17,302,482 144,411,047 3,204,333 150,727,713 $ 2,429,640 572,774 8,378,684 2,243,522 5,841,352 5,134,915 15,476,590 661,454 345,357 20,922,802 768,711 97,438,604 3,908,997 154,033,415 986,874,762 $ 421,725,355 $ 318,156,816 $ $ 380,845,409 64,074,585 19,247,748 202,899,377 377,175,042 1,044,242,161 $ $ 237,663,286 48,652,041 5,192,442 120,507,307 200,902,871 612,917,946 $ 2,031,116,923 $ 1,034,643,301 - $ 14,546,377 16,778,542 6,100,000 29,948,367 13,535,050 925,000 4,085,000 77,804,067 19,772,000 $ $ $ 528,779,533 32,737,906 7,803,425 75,415,257 269,036,448 913,772,569 $ 1,231,929,385 2019-2020 Year-to-Date Capital Amounts From Capital Funds Budget Actual 204,701,310 134,421,065 $ 8,156,907 10,212,799 0 4,145,781 634,815 362,852 1,527,331 33,764,322 17,301,422 54,202,715 77,856,560 997,902 $ 150,177,327 27,008,500 10,253,120 11,527,410 600,000 10,113,893 898,760 18,845,897 117,104,026 9,203,942 107,527,207 96,364 $ 23,883,948 1,178,594 625,311 1,829,281 2,128,740 816,867 16,715,869 1,060 90,208,332 3,204,333 72,871,152 901,538 132,682,849 32,395,649 (0) 15,727,809 35,500,715 600,000 20,885,389 562,148 2,639,562 46,169,773 2,469,518 177,394,289 5,999,609 91,220,559 522,616,778 $ 208,165,504 464,257,984 $ 213,559,851 565,149,407 $ $ 21,269,155 4,890,031 3,948,231 25,464,328 49,424,306 $ 104,996,051 $ $ 93,232,622 14,393,555 9,034,831 48,146,970 139,062,187 303,870,165 $ 826,486,943 $ 313,161,555 - 33 - Unencumbered Budget $ $ 287,612,787 49,681,030 10,212,917 154,752,407 238,112,855 740,371,996 $ 1,204,629,980 $ $ $ 216,394,131 43,762,009 1,244,211 95,042,979 151,478,565 507,921,895 $ 143,182,123 15,422,544 14,055,306 82,392,070 176,272,171 431,324,215 $ 721,481,746 $ 996,473,622 Bonds Authorized and Sold As of MAY 31 (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 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 742,755 135,745 Revenue Bonds Bonds Fully Issued Total 1988 Authorizations 2001 Authorization General Obligation Bonds Education, Youth and Family Cultural Facilities Computer Technology Environmental Cleanup Fire Protection Historic Preservation Library Facilities Street Improvements Neighborhood Protection and Senior Centers Parks, Open Space, and Recreational Facilities Police Protection Storm Sewer and Flood Protection Bonds Fully Issued Total 2001 Authorizations Total 2006 Authorizations Total Bond Program 878,500 $ 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 15-16 Actuals 60,000 16-17 Actuals 17-18 Actuals 50,000 18-19 Actuals 40,000 19-20 Actuals 19-20 Budget 30,000 20,000 10,000 July FY 15-16 16-17 17-18 18-19 19-20 19-20 Budget Aug July 34,740 35,857 17,068 29,246 33,070 33,094 Sept Aug 35,137 36,805 43,895 32,982 36,653 42,127 Oct Sept 35,079 34,012 33,757 32,919 56,465 38,432 Nov Oct 35,459 38,800 42,559 52,159 31,089 47,833 Dec Nov 34,433 32,023 31,868 33,971 40,325 37,449 Jan Dec 32,783 35,135 33,857 53,513 51,643 43,958 Feb Jan 37,567 38,595 41,041 35,343 39,512 43,182 Note: City of Phoenix revenue is budgeted on an annual basis. 2019-20 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2015-16 through FY 2018-19 actual expenditures. Return to Summary Page - A1 - Feb 32,793 22,766 36,368 38,579 33,570 36,943 Mar Mar 33,135 33,502 32,970 39,641 61,093 39,417 Apr May June Apr 36,307 28,921 48,534 46,770 29,662 45,442 May 34,236 47,647 33,061 27,146 34,412 40,222 YTD thru May 381,668 384,063 394,978 422,269 447,494 448,099 June 38,598 44,372 45,459 64,281 54,551 State Sales Tax (Dollars in Thousands) State Sales Tax 21,000 15-16 Actuals 16,000 16-17 Actuals 17-18 Actuals 11,000 18-19 Actuals 19-20 Actuals 19-20 Budget 6,000 1,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Nov 11,100 11,443 13,678 15,747 16,443 14,882 Dec 11,623 11,913 13,707 14,902 12,120 14,932 Jan 13,760 14,184 13,334 12,154 17,440 15,301 Feb 10,375 10,974 13,322 15,369 17,707 14,330 Mar 11,139 11,785 13,651 13,689 12,285 14,394 Apr 12,975 12,900 12,631 14,284 18,557 15,117 May 11,470 12,004 13,603 14,640 11,288 14,810 (4,000) FY 15-16 16-17 17-18 18-19 19-20 19-20 Budget July 11,070 11,269 11,773 18,836 20,116 15,162 Aug 10,222 11,027 12,260 13,749 14,944 13,533 Sept 11,237 11,658 17,561 12,476 11,479 15,158 Oct 10,688 11,195 10,963 10,922 14,226 12,533 Note: City of Phoenix revenue is budgeted on an annual basis. 2019-20 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2015-16 through FY 2018-19 actual expenditures. Return to Summary Page - A2 - YTD thru May 125,659 130,353 146,483 156,768 166,605 160,152 June 11,886 13,622 9,515 8,298 12,406 Vehicle License Tax (Dollars in Thousands) Vehicle License Tax 12,000 15-16 Actuals 11,000 16-17 Actuals 10,000 9,000 17-18 Actuals 8,000 18-19 Actuals 7,000 19-20 Actuals 6,000 19-20 Budget 5,000 4,000 3,000 2,000 July FY 15-16 16-17 17-18 18-19 19-20 19-20 Budget Aug Sept Oct July 5,095 5,712 9,008 9,422 10,791 8,554 Aug 5,133 4,393 4,830 5,782 5,619 5,892 Sept 4,087 4,846 5,152 5,349 5,207 5,686 Nov Dec Jan Feb Oct 4,922 5,181 5,670 6,492 6,146 6,514 Nov 4,291 4,242 4,904 4,886 5,408 5,361 Dec 4,550 4,826 5,741 5,800 5,891 6,120 Jan 5,195 5,607 5,470 6,143 6,514 6,558 Note: City of Phoenix revenue is budgeted on an annual basis. 2019-20 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2015-16 through FY 2018-19 actual expenditures. Return to Summary Page - A3 - Mar Feb 5,024 5,049 5,714 5,490 6,528 6,225 Apr Mar 5,065 5,457 5,493 5,943 5,960 6,424 May Apr 5,512 5,470 5,593 5,668 5,110 6,508 June May 4,943 4,938 5,602 5,959 4,699 6,274 YTD thru May 53,818 55,720 63,177 66,934 67,873 70,116 June 5,983 5,866 3,607 3,276 5,481 Governmental Funds Revenue (Dollars in Thousands) Governmental Funds Revenue 300,100.00 2015-16 Actuals 2016-17 Actuals 250,100.00 2017-18 Actuals 200,100.00 2018-19 Actuals 2019-20 Actuals 150,100.00 19-20 Budget 100,100.00 50,100.00 100.00 FY 15-16 16-17 17-18 18-19 19-20 19-20 Budget July Aug Sept July 128,588 125,592 98,501 131,124 100,481 139,293 Aug 155,197 165,819 185,527 168,019 187,393 193,590 Sept 129,829 157,173 176,701 152,605 194,506 177,405 Oct Nov Dec Oct 160,655 165,460 189,075 198,474 175,883 205,052 Nov 195,040 212,320 226,848 247,632 269,127 253,106 Dec 172,648 218,635 192,262 221,971 226,582 231,700 Jan Feb Jan 160,567 173,436 187,522 170,844 209,806 198,919 Feb 141,861 145,268 176,559 173,462 187,061 183,390 Note: City of Phoenix revenue is budgeted on an annual basis. 2019-20 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2015-16 through FY 2018-19 actual expenditures. Return to Summary Page - A4 - Mar Apr Mar 160,707 159,366 167,449 187,169 217,521 194,333 May Apr 173,752 185,518 217,138 210,659 180,484 226,813 June May 193,402 251,092 223,002 245,256 225,653 262,619 YTD thru May 1,772,246 1,959,680 2,040,584 2,107,215 2,174,497 2,266,220 June 244,902 225,798 252,080 280,540 289,899 Aviation Revenues (Dollars in Thousands) Aviation Operating Revenues 50,000 15-16 Actuals 16-17 Actuals 17-18 Actuals 40,000 18-19 Actuals 19-20 Actuals 30,000 19-20 Budget 20,000 10,000 July FY 15-16 16-17 17-18 18-19 19-20 19-20 Budget Aug Sept Oct July 28,758 28,314 26,403 31,468 30,489 30,641 Aug 27,373 29,777 34,965 32,105 32,307 33,114 Sept 28,151 29,279 30,148 31,728 32,953 31,804 Nov Dec Jan Feb Mar Apr Oct 29,050 28,339 29,291 31,719 32,056 31,562 Nov 29,039 30,504 21,702 32,312 33,532 30,271 Dec 25,795 24,926 38,212 30,496 36,787 31,837 Jan 28,789 28,532 32,543 31,205 34,297 32,274 Feb 27,161 28,901 30,671 32,944 34,215 31,903 Mar 31,530 29,273 33,070 33,075 34,228 33,841 Note: City of Phoenix revenue is budgeted on an annual basis. 2019-20 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2015-16 through FY 2018-19 actual expenditures. Return to Summary Page - A5 - May Apr 30,759 33,162 37,265 37,847 27,255 37,063 June May 29,439 32,146 32,447 34,396 23,524 34,235 YTD thru May 315,844 323,153 346,717 359,295 351,643 358,545 June 29,507 31,531 38,986 35,938 36,244 Water System Revenues (Dollars in Thousands) Water System Operating Revenues 60,000 15-16 Actuals 16-17 Actuals 50,000 17-18 Actuals 40,000 18-19 Actuals 19-20 Actuals 30,000 19-20 Budget 20,000 10,000 July FY 15-16 16-17 17-18 18-19 19-20 19-20 Budget Aug July 47,014 50,220 54,624 49,797 52,660 55,742 Sept Aug 43,100 47,104 44,633 46,762 51,596 50,198 Oct Sept 42,235 43,613 44,819 44,112 47,319 48,312 Nov Dec Jan Feb Mar Apr May June Oct 34,778 37,360 39,391 35,672 40,300 40,689 Nov 30,252 34,083 38,890 31,619 38,339 37,273 Dec 24,406 26,073 27,184 25,048 26,405 28,392 Jan 22,460 21,608 25,186 22,565 25,330 25,381 Feb 19,179 19,223 22,704 21,558 25,643 22,850 Mar 24,487 20,925 23,806 20,138 24,861 24,700 Apr 32,097 32,958 31,392 31,150 29,080 35,270 May 34,122 38,009 38,031 36,293 40,442 40,483 Note: City of Phoenix revenue is budgeted on an annual basis. 2019-20 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2015-16 through FY 2018-19 actual expenditures. Return to Summary Page - A6 - YTD thru May 354,130 371,176 390,660 364,714 401,975 409,290 June 42,680 46,526 43,736 38,106 47,281 Wastewater Revenues (Dollars in Thousands) Wastewater Operating Revenues 27,000 15-16 Actuals 16-17 Actuals 22,000 17-18 Actuals 18-19 Actuals 17,000 19-20 Actuals 19-20 Budget 12,000 7,000 2,000 July FY 15-16 16-17 17-18 18-19 19-20 19-20 Budget Aug July 16,156 18,836 18,615 17,949 18,374 18,496 Sept Aug 18,477 19,359 22,957 20,417 24,593 20,991 Oct Sept 21,171 19,337 19,811 21,145 21,373 21,057 Nov Dec Jan Feb Mar Apr May June Oct 18,058 18,611 20,195 23,028 20,975 20,650 Nov 17,530 18,347 20,386 19,734 21,142 19,643 Dec 18,697 19,493 20,097 20,469 20,888 20,357 Jan 19,384 19,155 20,584 22,113 22,063 20,998 Feb 18,385 18,594 19,499 19,436 20,973 19,622 Mar 18,659 19,618 20,517 19,960 21,613 20,356 Apr 21,363 19,731 18,079 21,256 18,428 20,789 May 18,555 20,233 20,160 20,980 23,948 20,659 Note: City of Phoenix revenue is budgeted on an annual basis. 2019-20 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2015-16 through FY 2018-19 actual expenditures. Return to Summary Page - A7 - YTD thru May 206,436 211,315 220,900 226,487 234,370 223,618 June 19,289 20,633 18,345 16,544 19,337