April 2020 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division April 30, 2020 To the Mayor and City Council: This is the City's Financial Report for April, the tenth 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 May 28, 2020 CITY AUDITOR REPORT To the Chief Financial Officer, We have assessed the Finance Department’s (Finance) April 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 April 2020 Table of Contents Expenditures by Programs Page Performance Status General Fund Expenditures Report Navigation General Fund Total Expenditures 1 Better than Expected General Government 1 Better than Expected Click on either the schedule name or the Criminal Justice 2 Better than Expected performance status in the table of contents to Public Safety 2 Better than Expected be taken directly to that page of the report. Transportation 3 Better than Expected Community Development 3 Better than Expected From any page of the report, click on the Community Enrichment 4 Better than Expected City of Phoenix Bird Emblem to return to the Environmental Services 4 Monitor and Consider Taking Action Table of Contents Citywide Expenditures 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 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 Property Tax 14 Expected Expected Local Sales Tax 15 Better than 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 Better than Expected 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. April 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 885,014 1,066,521 83.0% 919,246 1,105,361 83.2% 977,247 1,177,280 83.0% 1,011,666 1,214,362 83.3% 1,073,685 1,341,014 80.1% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustment for contingencies. Better than Expected Total General Fund General Government $1,600,000 $1,400,000 $1,400,000 $1,200,000 $1,200,000 $1,000,000 $1,000,000 $800,000 $800,000 April YTD Expenditures April YTD Expenditures $600,000 $600,000 $400,000 $400,000 $200,000 $200,000 $0 $0 Annual Annual Expenditures *Expenditures * 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 April are 6.1% 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 88,632 105,240 84.2% 90,835 106,754 85.1% 94,648 110,408 85.7% 100,889 114,393 88.2% 108,964 139,831 77.9% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice General Government $120,000 $160,000 $100,000 $140,000 $120,000 $80,000 $100,000 $60,000 $80,000 $40,000 $60,000 $40,000 $20,000 $20,000 $0 April YTD Expenditures April YTD Expenditures Annual Expenditures * Annual Expenditures * 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 April are 8.0% 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 April General Fund 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 26,075 30,698 84.9% 25,549 31,595 80.9% 26,709 32,232 82.9% 27,791 33,387 83.2% 29,147 36,665 79.5% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice $40,000 April YTD Expenditures $35,000 $30,000 $25,000 Annual Expenditures * $20,000 $15,000 $10,000 $5,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 April are 4.9% 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 15-16 16-17 17-18 18-19 19-20 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 615,892 737,129 83.6% 642,504 764,482 84.0% 680,832 817,960 83.2% 700,536 841,467 83.3% 741,524 911,944 81.3% * - For prior years-total actual expenditures, for current year-total approved budget Public Safety $1,000,000 $800,000 April YTD Expenditures $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 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 April, general fund public safety expenditures are 5.9% 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 April General Fund 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 13,569 17,473 77.7% 15,045 17,878 84.2% 14,922 16,366 91.2% 15,578 18,337 85.0% 17,212 20,587 83.6% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Community Development Transportation $1 $30,000 $1 Series1 April YTD Expenditures $1 $20,000 $1 $0 $10,000 $0 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 April, General fund transportation expenditures are 10.5% 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 15,429 18,571 83.1% 16,101 19,709 81.7% 17,052 20,243 84.2% 17,771 21,238 83.7% 18,901 24,639 76.7% * - For prior years-total actual expenditures, for current year-total approved budget Community Development $30,000 April 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 April are 6.4% 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 April General Fund 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 113,284 141,483 80.1% 118,015 146,749 80.4% 126,029 156,325 80.6% 128,106 156,552 81.8% 131,048 168,104 78.0% * - For prior years-total actual expenditures, for current year-total approved budget Community Enrichment $200,000 April YTD Expenditures $160,000 $120,000 $80,000 Annual Expenditures * $40,000 $0 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 April, general fund community enrichment expenditures are 2.3% 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 10,107 12,143 83.2% 8,866 12,775 69.4% 10,018 12,624 79.4% 14,108 16,886 83.5% 18,050 19,792 91.2% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services $24,000 April YTD Expenditures $20,000 $16,000 $12,000 $8,000 Annual Expenditures * $4,000 $0 15-16 Monitor and Consider Taking Action 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 April, general fund environmental services expenditures are 27.9% 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. April 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 2,560,817 3,156,441 81.1% 2,774,181 3,468,589 80.0% 2,878,196 3,547,078 81.1% 3,210,051 3,775,464 85.0% 3,224,341 4,444,573 72.5% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustments for contingencies and use of the early redemption fund. Total Citywide $5,000,000 April YTD Expenditures $4,000,000 $3,000,000 $2,000,000 Annual Expenditures * $1,000,000 $0 15-16 Better than Expected 16-17 17-18 18-19 19-20 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 April are 0.4% higher than the same period in the prior fiscal year. General Government 15-16 16-17 17-18 18-19 19-20 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 100,354 118,505 84.7% 102,182 121,863 83.8% 112,010 134,117 83.5% 118,968 138,349 86.0% 132,060 167,560 78.8% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected General Government $200,000 April 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 April are 11.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 April 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 33,076 39,463 83.8% 33,956 41,117 82.6% 31,656 38,411 82.4% 35,451 42,530 83.4% 36,835 48,764 75.5% * - For prior years-total actual expenditures, for current year-total approved budget Criminal Justice $60,000 April 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 3.9% higher through April 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 729,201 874,558 83.4% 757,203 908,553 83.3% 808,369 970,771 83.3% 857,570 1,025,513 83.6% 924,677 1,124,185 82.3% * - For prior years-total actual expenditures, for current year-total approved budget Public Safety $1,200,000 $1,000,000 April 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 April are 7.8% 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 April 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 517,654 609,990 84.9% 545,544 642,850 84.9% 609,662 709,977 85.9% 639,397 722,667 88.5% 705,909 821,667 85.9% * - 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 April 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 10.4% higher through April 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 145,697 174,956 83.3% 152,678 188,365 81.1% 166,964 203,096 82.2% 160,073 195,716 81.8% 172,762 239,073 72.3% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Community Development $300,000 April 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 April are 7.9% 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 April 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 223,403 273,179 81.8% 234,786 292,983 80.1% 249,463 306,763 81.3% 261,924 317,465 82.5% 267,647 361,444 74.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 April 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 April are 2.2% 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 457,302 555,711 82.3% 491,467 599,837 81.9% 520,841 696,244 74.8% 563,048 670,219 84.0% 588,625 724,310 81.3% * - 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 April 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 4.5% higher through April 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 April 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 127,238 154,710 82.2% 114,405 137,205 83.4% 88,688 106,315 83.4% 97,195 116,634 83.3% 109,007 131,082 83.2% * - For prior years-total actual expenditures, for current year-total approved budget net of credit for early redemption fund resources $180,000 April 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 April 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 $ 382,103 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 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) . $0 $500,000 $1,000,000 $1,500,000 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 $ 228,621 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) $ 45,697 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) $ 4,738 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. In fiscal year 2015-16, Solid Waste spent $2.5 million on the 27th Ave Resource Innovation Campus. 19-20 (YTD) 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 $ 18-19 19-20 (Budget) 19-20 (YTD) 97,890 $ 205,929 $ 98,942 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 19-20 (YTD) the wastewater treatment facilities. 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 15-16 91st Avenue Wastewater Treatment Plant. In fiscal year 2018-19 , Wastewater spent $45.2 million $0 $50,000 $100,000 $150,000 $200,000 $250,000 in 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 18-19 19-20 (Budget) 19-20 (YTD) $ 289,858 $ 374,145 $174,591 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 April 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 April YTD Revenues 852,464 859,770 940,468 985,151 1,033,953 Annual Revenues* 1,063,211 1,094,933 1,162,635 1,220,768 1,272,830 17-18 18-19 19-20 % of Annual Revenues 80.2% 78.5% 80.9% 80.7% 81.2% * - 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 April are 5.0% 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 Secondary 50,484 150,000 71,472 120,000 90,000 60,000 141,309 146,121 154,560 162,129 15-16 16-17 17-18 18-19 170,899 Primary 113,387 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 184,859 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 19-20 YTD 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 19-20 Budget 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 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 113,387 71,472 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 Better than Expected Fiscal year 2019-20 local sales tax revenues through April are 4.5% higher than the same period in the prior year. Actual local sales tax revenues through April are 1.3% higher 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 15,000 19-20 Actuals 10,000 19-20 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 2019-20 budget includes an increase of 4.5% in state shared sales tax over fiscal year 2018-19 actuals. Through April state shared sales tax revenues are 6.9% 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 April 2020 are 1.0% 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 April 2020 are 2.7% 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 Better than Expected Aviation operating revenues through April 2020 are 1.2% higher than budget expectations for the period. Aviation Operating Revenues 3 Year Trend 50,000 40,000 30,000 17-18 Actuals 20,000 18-19 Actuals 19-20 Actuals 10,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 April 2020 are 2.0% 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 April 2020 are 3.7% 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 APRIL 30 (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 $ 413,082 $ 2,306 395,123 2,460 172,557 215,228 75,597 170,899 2,998 11,152 155,317 178,914 63,174 113,387 2,307 5,110 142,128 164,098 60,975 106,976 2,375 8,276 12,663 1,409 14,231 570 7,163 1,755 4,806 9,092 1,039 13,097 333 5,035 1,379 4,750 10,666 1,105 12,773 543 5,726 1,443 4,954 36,964 1,400 12,642 9,407 15,962 31,875 1,053 11,497 8,607 12,599 32,460 1,017 10,859 7,959 13,234 1,272,831 - 22 - $ 1,033,953 $ 985,150 General Fund Expenditures As of APRIL 30 (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,302 $ 3,230 3,115 38,399 2,006 1,695 18,582 2,310 3,997 9,930 3,288 19,067 2,043 108,964 1,229 2,881 3,033 30,755 1,708 1,764 17,469 2,522 3,034 8,710 3,016 18,799 5,969 100,889 Criminal Justice Municipal Court Public Defender Total Criminal Justice 31,376 5,289 36,665 24,656 4,491 29,147 23,692 4,099 27,791 Public Safety Police Fire Others Total Public Safety 566,452 345,429 63 911,944 462,636 278,817 71 741,524 451,132 249,511 (107) 700,536 Transportation Street Transportation Public Transit Total Transportation 18,947 1,640 20,587 15,572 1,640 17,212 13,787 1,791 15,578 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 6,054 14,072 4,334 179 24,639 4,600 11,168 3,010 123 18,901 4,273 10,657 2,800 41 17,771 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 101,458 39,710 20,157 6,779 168,104 77,574 32,547 15,465 5,462 131,048 74,057 30,326 15,182 8,541 128,106 Environmental Services Public Works Environmental Programs Others Total Environmental Services 18,475 800 517 19,792 17,030 448 573 18,050 13,603 505 14,108 Capital Improvement 19,452 8,839 6,887 Vacancy Savings (5,000) - - Contingencies 57,912 - - Total Expenditures and Encumbrances $ 1,393,926 - 23 - $ 1,073,685 $ 1,011,666 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 APRIL 30 (dollars in thousands) Source General Funds Local Taxes: Sales Taxes Privilege License Fees State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax Primary Property Tax Licenses and Permits Cable Communications Municipal Court Police Library Fees Parks and Recreation Planning & Development Street Transportation Fire Interest Other Fees and Service Charges Budget Estimate 2019-2020 $ 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 502,650 2,779 Actual Year-to-Date 2019-2020 2018-2019 413,082 $ 2,306 395,123 2,460 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 155,317 178,914 63,174 113,387 2,307 5,110 10,131 13,097 333 5,035 1,379 4,750 44,425 8,607 12,599 142,128 164,098 60,975 106,976 2,375 8,276 11,771 12,773 543 5,726 1,443 4,954 44,336 7,959 13,234 1,272,831 1,033,953 985,150 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 30,374 79,051 32,046 5,679 241,201 3,787 67,840 7,390 18,706 121,323 34,118 8,338 20,920 170,924 73,194 28,292 65,678 29,462 5,110 233,693 3,787 63,175 7,580 21,101 117,315 27,272 1,947 37,556 165,542 69,297 1,283,288 914,892 876,808 394,789 91,048 456,571 242,954 150,958 328,119 68,181 361,533 210,422 124,772 324,899 68,897 328,421 205,507 128,401 1,336,320 1,093,027 1,056,125 $ 3,892,439 - 24 - $ $ 3,041,871 $ 2,918,084 Citywide Operating Expenditures As of APRIL 30 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2019-2020 2018-2019 Budget 2019-2020 108,964 $ 23,096 132,060 100,889 18,079 118,968 36,665 12,099 48,764 29,147 7,688 36,835 27,791 7,660 35,451 Public Safety General Funds Other Funds Total Public Safety 911,944 212,241 1,124,185 741,524 183,153 924,677 700,536 157,034 857,570 Transportation General Funds Other Funds Total Transportation 20,587 801,080 821,667 17,212 688,697 705,909 15,578 623,819 639,397 Community Development General Funds Other Funds Total Community Development 24,639 214,434 239,073 18,901 153,861 172,762 17,771 142,302 160,073 Community Enrichment General Funds Other Funds Total Community Enrichment 168,104 193,340 361,444 131,048 136,599 267,647 128,106 133,818 261,924 Environmental Services General Funds Other Funds Total Environmental Services 19,792 704,518 724,310 18,050 570,575 588,625 14,108 548,940 563,048 Debt Service General Funds Other Funds Total Debt Service 131,082 131,082 109,007 109,007 97,195 97,195 Capital Improvement General Funds Other Funds Total Capital Improvement 19,452 807,035 826,487 8,839 277,981 286,820 6,887 469,540 476,427 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,926 3,161,058 4,554,984 1,073,685 2,150,657 3,224,342 $ $ 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,011,666 2,198,387 3,210,053 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 APRIL 30 2020 2019 Budget Estimate 2019-2020 Source Actual Year-to-Date 2019-2020 2018-2019 General Funds $ 46,770,297 214,753 Local Taxes: Sales Taxes Privilege License Fees 29,725,038 46,985,050 Total Local Taxes 505,428,500 415,388,774 397,583,337 18,557,225 17,891,434 5,109,853 14,283,435 16,409,929 5,667,575 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 172,557,000 215,228,000 75,597,000 155,317,102 178,914,344 63,173,788 142,127,526 164,097,980 60,975,057 41,558,512 36,360,939 463,382,000 397,405,234 367,200,563 7,460,877 7,448,800 Primary Property Tax 170,899,000 113,386,570 106,976,034 102,506 169,475 Licenses and Permits 2,998,000 2,307,437 2,374,539 0 2,682,110 Cable Communications 11,152,000 5,109,853 8,275,625 884,290 145,979 1,270,842 149,746 Municipal Court: Fines and Forfeitures Court Default Fee 12,662,750 1,409,000 9,092,397 1,039,021 10,666,278 1,104,980 1,030,269 1,420,588 14,071,750 10,131,418 11,771,258 2,131,983 1,670,361 14,230,592 13,096,991 12,773,299 3,924 67,321 Library Fees 569,801 333,072 543,482 260,137 572,679 Parks and Recreation 7,163,316 5,034,700 5,725,994 106,962 204,856 Planning and Development 1,755,490 1,379,413 1,443,436 421,380 623,477 Street Transportation 4,805,543 4,749,916 4,953,560 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other 36,964,000 1,400,000 12,641,599 31,874,410 1,052,800 11,497,291 32,460,709 1,016,850 10,858,612 44,336,171 29,662,837 62,201 $ 1,823,457 161,175 2,172,038 4,732,783 148,400 1,866,252 4,156,670 6,747,435 660,072 873,635 1,121,287 1,138,911 88,739,617 106,965,637 $ Total State Shared Taxes Total Municipal Court Police Total Fire 502,650,000 2,778,500 $ 413,082,448 2,306,326 $ 395,122,879 2,460,458 51,005,599 44,424,501 Interest 9,407,000 8,606,600 7,958,926 Other Fees and Service Charges 15,961,784 12,598,779 13,234,049 1,272,830,375 1,033,953,258 985,150,273 Total General Funds 26 Citywide Operating Revenue by Source (continued) For the Month Ended APRIL 30 2020 2019 Budget Estimate 2019-2020 Source Actual Year-to-Date 2019-2020 2018-2019 Special Revenue and Debt Service Funds $ 1,816,655 129,761 648,805 25,929 $ 2,621,150 5,205,109 1,683,327 14,551 $ $ $ 6,902,987 2,444,666 174,619 873,095 33,570 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 3,525,950 Total Neighborhood Protection 5,713,245 1,471,892 (291,485) 6,893,652 2,652,222 $ 3,657,449 492,566 0 225,747 884 19,453 $ $ $ $ $ 419,626 0 355,768 (651) 21,213 738,650 17,842,891 1,350,672 $ $ 19,193,563 $ 25,633,000 1,831,000 9,155,000 639,000 $ 20,876,656 1,491,190 7,455,948 550,488 $ 19,434,062 1,388,147 6,940,736 529,322 37,258,000 30,374,282 28,292,267 75,998,000 25,316,000 444,000 59,505,023 19,153,780 392,122 50,484,211 14,819,575 374,062 101,758,000 79,050,925 65,677,848 Parks and Preserves 37,513,347 32,046,394 29,462,169 Golf Courses: Fees Coffee Shops Concessions Interest Other 3,372,500 0 1,883,000 0 258,285 3,592,567 0 1,801,355 2,894 282,064 3,099,510 0 1,842,450 (11,057) 179,352 Public Safety Enhancement & Expansion: Police Fire Interest/Other Total Public Safety Enhancement & Expansion 795,956 Total Golf Courses 5,513,785 5,678,880 5,110,255 23,865,236 4,540,755 Transit 2000 & 2050: Sales Taxes Interest/Other 249,936,000 47,738,578 203,810,963 37,390,452 189,715,529 43,977,699 297,674,578 241,201,415 233,693,228 28,405,991 Total Transit 2000 & 2050 692,801 $ 324,017 Court Awards 4,913,184 3,786,517 3,786,768 4,536,531 $ 5,725,685 Planning and Development 66,542,000 67,839,756 63,175,469 599,472 $ 1,147,736 Capital Construction 8,837,000 7,390,422 7,580,297 1,464,052 204,374 $ $ 3,465,298 3,699,614 Sports Facilities: Sales Taxes Interest/Other 23,063,000 4,508,180 16,382,274 2,324,182 16,680,968 4,419,931 27,571,180 18,706,456 21,100,899 1,668,426 7,164,912 Total Sports Facilities 27 Citywide Operating Revenue by Source (continued) For the Month Ended APRIL 30 2020 2019 Budget Estimate 2019-2020 Actual Year-to-Date 2019-2020 2018-2019 145,617,000 152,000 150,000 118,854,034 1,608,470 860,105 115,744,436 1,595,527 (24,838) Total Highway User Revenue 145,919,000 121,322,609 117,315,125 Local Transportation Assistance 0 0 0 40,580,254 34,117,548 27,272,149 Source Special Revenue and Debt Service Funds (Cont'd) $ 13,287,117 134,617 0 12,577,584 187,048 21,497 13,421,734 12,786,129 2,870,665 $ - Highway User Revenue: Highway User Revenue Interest Other 2,615,937 Regional Transit Revenues 56,239 (645,730) Community Reinvestment 6,250,792 8,337,782 1,946,525 9,773,728 4,254,478 Other Restricted Fees 37,599,774 20,920,426 37,555,911 675,000 8,802,561 980,721 1,447,001 6,236,545 641,318 Grants: Public Housing: Rentals Grants Other 7,990,700 81,312,772 25,830,102 6,948,240 71,649,933 15,623,386 7,401,911 65,679,806 5,055,998 10,458,282 8,324,864 115,133,574 94,221,559 78,137,715 5,047,684 1,025,970 1,589,317 3,239,350 4,624,096 5,356,036 2,803,509 1,355,546 56,270,174 111,361,958 30,988,877 38,949,477 41,324,886 6,140,482 8,239,754 20,996,857 35,705,838 16,037,077 6,944,874 28,716,621 10,902,321 14,139,187 Total Other 237,570,486 76,701,979 87,404,410 21,360,603 22,464,051 Total Grants 352,704,060 170,923,538 165,542,125 4,655,170 114 4,576,845 0 107,881,000 4,772,266 71,471,932 1,722,235 66,899,226 2,397,975 4,655,284 4,576,845 112,653,266 73,194,167 69,297,201 91,744,055 103,693,058 1,283,288,220 914,891,117 876,808,236 160,590,000 218,625,000 5,500,000 4,403,200 2,589,500 3,081,500 0 94,637,294 219,260,399 5,337,691 946,753 2,447,922 2,863,959 2,624,667 91,627,613 222,169,635 4,420,358 623,180 2,235,656 2,617,050 1,205,472 394,789,200 328,118,685 324,898,964 $ Total Public Housing Other: Human Resources Federal Transit Administration Community Development Other 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: 9,285,233 16,538,454 460,535 274,336 226,206 262,189 207,773 9,640,018 26,639,402 481,810 463,197 238,539 273,785 110,228 27,254,726 37,846,979 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 APRIL 30 2020 2019 Budget Estimate 2019-2020 Source Actual Year-to-Date 2019-2020 2018-2019 Enterprise Funds (Cont'd) CONVENTION CENTER: $ 3,589,844 1,221,447 100,052 7,725,312 2,703,967 107,898 4,911,343 10,537,177 27,260,710 202,640 400,893 177,046 307,980 352,224 378,622 28,710,517 462,871 548,990 558,631 596,160 209,581 63,005 29,080,115 31,149,755 Excise Taxes Operating Revenue Interest Total Convention Center 66,626,000 23,421,704 1,000,000 47,589,844 19,464,421 1,126,692 48,154,890 19,878,217 864,185 91,047,704 68,180,957 68,897,292 431,411,000 5,500,000 5,210,000 6,499,000 3,800,000 2,734,000 1,417,000 333,584,299 3,807,855 5,144,926 5,376,894 4,745,682 5,472,865 3,400,297 304,419,408 4,568,283 4,586,439 5,348,666 3,481,455 3,350,013 2,666,676 456,571,000 361,532,818 328,420,940 WATER SYSTEM: $ Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System WASTEWATER: 17,327,494 (81,981) 290,340 338,728 553,554 17,009,090 1,802,373 585,060 459,427 1,400,726 Sewer Service Charges Multi-City Development Fees Interest Other 205,243,000 18,052,000 3,700,000 1,994,000 13,965,000 171,551,149 15,143,508 4,410,480 3,808,950 15,508,004 169,143,167 16,953,319 3,354,540 3,229,573 12,826,886 18,428,135 21,256,676 Total Wastewater 242,954,000 210,422,091 205,507,485 131,647,000 7,811,400 400,000 11,099,474 112,880,544 7,234,423 648,776 4,008,369 110,159,317 6,906,410 821,899 10,512,998 150,957,874 124,772,112 128,400,624 1,336,319,778 1,093,026,663 1,056,125,305 SOLID WASTE: $ 12,718,299 969,737 41,516 695,445 11,079,995 772,585 90,986 3,666,246 14,424,997 15,609,812 94,099,316 116,400,399 274,582,988 $ 327,059,094 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ 29 3,892,438,373 $ 3,041,871,038 $ 2,918,083,814 Citywide Operating Expenditures by Program For the Month Ended APRIL 30 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 $ 101,786 $ 347,153 331,042 4,568,115 476,300 218,118 91,702 1,608,544 126,457 298,725 1,113,106 (591,250) 14,378 291,908 2,340,936 360,268 64,148 333,574 300,436 4,344,845 82,834 215,354 172,771 1,530,375 192,121 639,114 721,968 54,446 161,418 10,906 303,834 1,964,698 (784,204) 11,697,288 10,308,638 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,302,075 3,229,923 3,197,702 49,389,774 2,444,822 2,055,922 2,002,162 19,831,841 2,310,084 3,996,880 10,996,248 144,591 82,172 3,290,601 25,019,670 2,765,051 $ 1,228,626 2,880,946 3,171,003 41,404,254 1,022,307 2,029,192 2,049,641 18,626,983 2,522,395 5,373,501 9,752,449 588,644 121,453 1,951,830 67,255 3,016,019 21,090,496 2,070,513 $ 1,302,075 3,229,923 3,197,702 39,264,679 2,444,822 2,055,922 2,002,162 19,831,841 2,310,084 3,996,880 10,315,910 144,591 82,172 3,290,601 24,260,002 2,765,051 10,125,095 680,337 759,668 - 167,560,469 132,059,518 118,967,507 120,494,417 11,565,101 43,474,862 5,289,134 32,344,534 4,490,564 31,352,123 4,099,075 26,742,839 4,490,564 5,601,695 - 48,763,996 36,835,098 35,451,198 31,233,403 5,601,695 721,210,722 401,998,584 975,928 590,389,996 333,514,208 773,065 557,293,086 299,581,356 695,217 588,222,219 329,988,428 773,065 2,167,777 3,525,780 - 1,124,185,234 924,677,268 857,569,659 918,983,712 5,693,557 Criminal Justice 3,077,587 682,193 3,027,953 394,661 3,759,780 3,422,614 Municipal Court Public Defender Total Criminal Justice Public Safety 57,185,490 37,557,364 100,693 54,714,550 27,817,662 169,529 94,843,547 82,701,741 Police Fire Other Total Public Safety -30- Citywide Operating Expenditures by Program (continued) For the Month Ended APRIL 30 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 $ 7,014,614 600,253 25,524,673 2,885,212 36,024,753 $ 6,453,440 703,186 28,729,088 8,800,637 Street Transportation Street Lighting Aviation Public Transit 44,686,351 Total Transportation $ 98,411,850 11,415,352 371,376,781 340,462,560 $ 82,331,698 7,739,877 289,960,518 325,876,511 $ 61,966,184 9,019,973 264,412,460 303,997,998 $ 78,746,802 7,739,877 218,692,433 255,271,226 3,584,897 71,268,085 70,605,285 821,666,543 705,908,604 639,396,615 560,450,338 145,458,267 Community Development 4,899,553 7,965,385 1,715,683 2,324,397 4,599,418 7,347,726 1,111,796 2,555,714 Planning and Development Housing Economic Development Neighborhood Services Department 71,928,530 100,338,355 19,590,335 47,215,711 51,929,609 77,562,017 14,054,869 29,215,422 45,239,834 73,993,195 11,133,532 29,706,253 51,929,609 77,502,627 8,580,088 29,215,422 59,390 5,474,781 - 16,905,018 15,614,654 Total Community Development 239,072,931 172,761,918 160,072,814 167,227,747 5,534,171 116,840,992 40,933,224 76,695,514 23,221,844 94,267,469 5,218,616 4,266,751 90,796,340 33,101,600 59,948,174 5,656,465 70,185,968 4,568,755 3,389,303 87,204,821 30,987,629 56,592,433 10,555,745 65,776,296 4,206,972 6,600,199 90,471,559 33,101,600 43,322,012 70,120,629 4,568,755 3,389,303 324,781 16,626,162 5,656,465 65,338 - 361,444,410 267,646,605 261,924,095 244,973,858 22,672,747 Community Enrichment 7,589,921 2,438,064 4,490,319 508,218 6,612,483 234,495 193,205 7,862,782 2,666,104 4,309,293 1,002,355 6,614,095 126,632 1,293,625 22,066,704 23,874,886 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 APRIL 30 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 $ 31,162,583 12,326,221 20,064,694 2,387,705 146,561 72,419 66,160,183 $ 84,224,386 (68,196,756) 12,095,275 1,101,689 145,896 29,370,490 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 $ 289,200,949 143,631,554 131,137,179 23,159,907 923,360 572,522 $ 286,966,612 130,422,845 130,986,769 13,760,885 910,989 - $ 191,598,410 85,049,639 120,642,917 17,176,547 923,360 572,522 97,602,539 58,581,915 10,494,262 5,983,360 172,662,076 724,310,227 588,625,471 563,048,100 415,963,394 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 2,856,417 9,503,021 5,078,488 574,875 5,904,999 508,313 8,659,898 1,813,068 11,322,927 6,023,947 2,922,830 15,141,220 8,583 5,653,254 4,126,882 2,082,985 25 1,181,667 13,370,221 6,224,271 5,125 6,044,108 3,930,875 10,141,963 16,630,288 211,226 8,916,466 279,146 5,054,431 687,264 8,111,519 6,860,131 556,830 10,425,036 250 5,084,983 1,546,265 1,961,818 24 1,449,500 10,692,888 4,217,162 5,125 431,608 2,856,417 9,503,021 5,078,488 574,875 5,904,999 508,313 8,659,898 1,813,068 11,322,927 6,023,947 2,922,830 15,141,220 8,583 5,653,254 4,126,882 2,082,985 25 1,181,667 13,370,221 6,224,271 5,125 6,044,108 - 109,007,124 - 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 13 133,167 1,337,022 622,427 513 604,411 393,087 1,014,196 1,663,028 21,123 891,647 27,915 505,443 68,726 811,152 686,013 55,683 1,042,503 25 508,498 154,627 196,182 12 144,950 1,069,289 421,716 512 43,161 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,723 9,719,488 Total Debt Service 131,082,016 109,007,124 97,194,798 (127,674,614) 62,498,117 Capital Improvement 826,486,943 286,819,865 476,426,511 - - - - Vacancy Savings (5,000,000) - - - - - - Contingencies 115,412,000 - - - - 134,698,381 282,196,979 4,554,984,769 3,224,341,471 -32- 3,210,051,297 2,568,333,992 369,187,614 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 95,972 $ 20,810,047 10,239,514 0 618,956 5,732,596 2,710,129 348,397 2,168,285 35,619,056 17,300,362 143,680,794 3,202,350 139,576,467 $ 2,396,211 777,704 5,955,560 2,237,510 5,834,031 4,660,875 15,070,888 650,715 308,519 17,637,381 685,455 95,742,983 3,908,075 133,709,642 986,874,762 $ 382,102,925 $ 289,575,549 $ $ 380,845,409 64,074,585 19,247,748 205,929,377 374,145,042 1,044,242,161 $ $ 228,620,957 45,697,275 4,738,046 98,942,499 174,590,618 552,589,395 $ 2,031,116,923 $ 934,692,320 - $ 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 $ $ $ 519,887,455 26,836,781 7,617,033 61,624,443 186,873,937 802,839,649 $ 1,092,415,198 2019-2020 Year-to-Date Capital Amounts From Capital Funds Budget Actual 204,701,310 134,421,065 $ 8,135,779 9,086,804 0 3,959,781 607,254 348,397 1,352,432 28,354,554 17,300,362 53,473,328 67,486,844 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 95,972 $ 12,674,268 1,152,710 618,956 1,772,815 2,102,875 815,852 7,264,502 90,207,466 3,202,350 72,089,623 901,930 143,913,657 33,547,528 (0) 15,734,164 35,743,181 600,000 20,938,814 576,603 2,815,475 61,030,908 2,471,638 178,124,542 6,001,592 102,371,805 522,616,778 $ 190,105,535 464,257,984 $ 191,997,390 604,771,837 $ $ 20,476,101 3,893,595 3,703,239 22,364,703 46,276,692 96,714,330 $ $ 93,232,622 14,393,555 9,034,831 49,661,970 137,547,187 303,870,165 $ 826,486,943 $ 286,819,865 - 33 - Unencumbered Budget $ $ $ 287,612,787 49,681,030 10,212,917 156,267,407 236,597,855 740,371,996 $ 1,204,629,980 $ $ $ 208,144,856 41,803,680 1,034,807 76,577,795 128,313,927 455,875,065 $ 152,224,452 18,377,310 14,509,702 106,986,878 199,554,424 491,652,766 $ 647,872,454 $ 1,096,424,604 Bonds Authorized and Sold As of APRIL 30 (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 Total General Obligation Bonds 28,285 884,175 $ 1,000 - 913,460 912,460 1,000 143,890 143,890 - 1,057,350 1,056,350 1,000 66,300 125,300 24,800 61,500 12,000 33,000 91,500 74,000 77,000 78,800 66,000 43,700 64,600 124,685 24,170 60,700 11,205 32,100 89,275 71,645 72,575 77,685 65,950 43,700 1,700 615 630 800 795 900 2,225 2,355 4,425 1,115 50 - 753,900 738,290 15,610 81,000 11,100 198,700 12,800 104,622 74,705 29,178 115,500 107,295 78,200 65,400 63,385 8,510 190,610 8,345 85,510 61,200 21,100 102,290 81,900 58,135 61,770 17,615 2,590 8,090 4,455 19,112 13,505 8,078 13,210 25,395 20,065 3,630 878,500 742,755 135,745 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 2006 Authorization General Obligation Bonds Affordable Housing and Neighborhood Revitalization Computer Technology Education and Health Science Facilities Environmental Cleanup Family, Senior, and Youth Cultural Facilities Fire Protection Library Facilities and Improvements Parks, Open Space, and Recreational Facilities Police Protection Street Improvements Storm Sewer and Flood Protection Total 2006 Authorizations Total Bond Program $ 2,689,750 - 34 - $ 2,537,395 $ 152,355 Appendix A Additional historic and trend information for various revenue streams. Local Sales Tax (Dollars in Thousands) Local Sales Tax 70,000 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 Apr 36,307 28,921 48,534 46,770 29,662 45,442 May June YTD thru April 347,432 336,416 361,917 395,123 413,082 407,877 May 34,236 47,647 33,061 27,146 40,222 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 YTD thru April 114,189 118,349 132,880 142,128 155,317 145,342 (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 - May 11,470 12,004 13,603 14,640 14,810 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 July 5,095 5,712 9,008 9,422 10,791 8,554 Sept Oct 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 YTD thru April 48,874 50,782 57,575 60,975 63,174 63,842 May 4,943 4,938 5,602 5,959 6,274 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 YTD thru April 1,578,844 1,708,588 1,817,582 1,861,959 1,948,844 2,003,601 May 193,402 251,092 223,002 245,256 262,619 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 YTD thru April 286,405 291,007 314,270 324,899 328,119 324,310 May 29,439 32,146 32,447 34,396 34,235 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 Oct 34,778 37,360 39,391 35,672 40,300 40,689 Dec Nov 30,252 34,083 38,890 31,619 38,339 37,273 Jan Feb Mar Apr May June 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 YTD thru April 320,008 333,167 352,629 328,421 361,533 368,807 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 - May 34,122 38,009 38,031 36,293 40,483 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 YTD thru April 187,881 191,082 200,740 205,507 210,422 202,959 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 - May 18,555 20,233 20,160 20,980 20,659 June 19,289 20,633 18,345 16,544 19,337