March 2020 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division March 31, 2020 To the Mayor and City Council: This is the City's Financial Report for March, the nineth 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 8, 2020 CITY AUDITOR REPORT To the Chief Financial Officer, We have assessed the Finance Department’s (Finance) March 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 March 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 Monitor and Consider Taking Action 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 Better than Expected Property Tax 14 Better than Expected Local Sales Tax 15 Better than Expected State Sales Tax 16 Better than Expected Vehicle License Tax 17 Better than Expected Governmental Funds 18 Expected Aviation 19 Better than Expected Water System 20 Expected Wastewater 21 Better than Expected Financial Schedules Page General Fund Revenue 22 General Fund Expenditures 23 Citywide Operating Revenue 24 Citywide Operating Expenditures 25 Citywide Operating Revenue by Source 26 Citywide Operating Expenditures by Program 30 Capital Expenditures and Encumbrances 33 Bonds Authorized and Sold 34 Appendix A - Additional Detail for Revenues General Fund Expenditures Expenditures from the City's General Fund for core functions such as Police, Fire, Parks, Streets and Social Services as well as administrative functions such as Mayor and Council, City Manager, Finance, and Human Resources. This does not include any expenditures from dedicated revenue streams such as grants, bonds, specifically dedicated taxes, and enterprise revenues. March 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 March YTD Annual % of Annual Expenditures Expenditures * Expenditures 801,377 1,066,521 75.1% 838,278 1,105,361 75.8% 887,604 1,177,280 75.4% 912,741 1,214,362 75.2% 975,398 1,341,013 72.7% * - 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 March YTD Expenditures March 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 March are 6.9% 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 March YTD Annual % of Annual Expenditures Expenditures * Expenditures 81,469 105,240 77.4% 83,217 106,754 78.0% 87,347 110,408 79.1% 91,276 114,393 79.8% 103,440 139,831 74.0% * - 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 March YTD Expenditures March 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 March are 13.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 March 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 March YTD Annual % of Annual Expenditures Expenditures * Expenditures 23,988 30,698 78.1% 23,140 31,595 73.2% 24,186 32,232 75.0% 25,192 33,387 75.5% 26,103 36,665 71.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice $40,000 March 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 March are 3.6% 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 March YTD Annual % of Annual Expenditures Expenditures * Expenditures 556,973 737,129 75.6% 584,418 764,482 76.4% 616,287 817,960 75.3% 631,910 841,467 75.1% 667,265 911,944 73.2% * - For prior years-total actual expenditures, for current year-total approved budget Public Safety $1,000,000 $800,000 March 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 March, general fund public safety expenditures are 5.6% 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 March 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 March YTD Annual % of Annual Expenditures Expenditures * Expenditures 11,871 17,473 67.9% 13,948 17,878 78.0% 13,797 16,366 84.3% 14,240 18,337 77.7% 16,198 20,587 78.7% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action Community Development Transportation $1 $30,000 $1 Series1 March 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 March, General fund transportation expenditures are 13.8% 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 March YTD Annual % of Annual Expenditures Expenditures * Expenditures 14,187 18,571 76.4% 14,626 19,709 74.2% 15,629 20,243 77.2% 16,072 21,238 75.7% 17,479 24,639 70.9% * - For prior years-total actual expenditures, for current year-total approved budget Community Development $30,000 March 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 March are 8.8% 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 March 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 March YTD Annual % of Annual Expenditures Expenditures * Expenditures 102,536 141,483 72.5% 107,675 146,749 73.4% 113,812 156,325 72.8% 116,186 156,552 74.2% 120,436 168,104 71.6% * - For prior years-total actual expenditures, for current year-total approved budget Community Enrichment $200,000 March 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 March, general fund community enrichment expenditures are 3.7% 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 March YTD Annual % of Annual Expenditures Expenditures * Expenditures 8,796 12,143 72.4% 9,109 12,775 71.3% 9,908 12,624 78.5% 12,949 16,886 76.7% 16,185 19,792 81.8% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services $24,000 March 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 March, general fund environmental services expenditures are 25.0% 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. March 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 March YTD Annual % of Annual Expenditures Expenditures * Expenditures 2,324,035 3,156,441 73.6% 2,494,911 3,468,589 71.9% 2,613,760 3,547,078 73.7% 2,927,854 3,775,464 77.5% 3,089,642 4,444,572 69.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 March 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 March are 5.5% higher than the same period in the prior fiscal year. General Government 15-16 16-17 17-18 18-19 19-20 March YTD Annual % of Annual Expenditures Expenditures * Expenditures 93,370 118,505 78.8% 96,178 121,863 78.9% 102,997 134,117 76.8% 108,659 138,349 78.5% 120,362 167,560 71.8% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected General Government $200,000 March 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 March are 10.8% 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 March 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 March YTD Annual % of Annual Expenditures Expenditures * Expenditures 30,294 39,463 76.8% 30,785 41,117 74.9% 28,679 38,411 74.7% 32,029 42,530 75.3% 33,075 48,764 67.8% * - For prior years-total actual expenditures, for current year-total approved budget Criminal Justice $60,000 March 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.3% higher through March 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 March YTD Annual % of Annual Expenditures Expenditures * Expenditures 657,781 874,558 75.2% 687,473 908,553 75.7% 731,851 970,771 75.4% 774,868 1,025,513 75.6% 829,834 1,124,185 73.8% * - For prior years-total actual expenditures, for current year-total approved budget Public Safety $1,200,000 $1,000,000 March 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 March are 7.1% 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 March 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 March YTD Annual % of Annual Expenditures Expenditures * Expenditures 481,522 609,990 78.9% 504,647 642,850 78.5% 567,900 709,977 80.0% 594,710 722,667 82.3% 669,884 821,667 81.5% * - 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 March 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 12.6% higher through March 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 March YTD Annual % of Annual Expenditures Expenditures * Expenditures 130,348 174,956 74.5% 141,761 188,365 75.3% 152,002 203,096 74.8% 144,458 195,716 73.8% 155,857 239,073 65.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Community Development $300,000 March 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 March 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 March 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 March YTD Annual % of Annual Expenditures Expenditures * Expenditures 202,851 273,179 74.3% 214,841 292,983 73.3% 227,122 306,763 74.0% 238,049 317,465 75.0% 245,580 361,344 68.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 March 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 March are 3.2% higher than the same period in the prior fiscal year. The fiscal year 2019-20 budget anticipates an increase of 13.8% 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 March YTD Annual % of Annual Expenditures Expenditures * Expenditures 412,098 555,711 74.2% 442,226 599,837 73.7% 467,769 696,244 67.2% 533,678 670,219 79.6% 522,465 724,310 72.1% * - 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 March 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.1% lower through March 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 March 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 March YTD Annual % of Annual Expenditures Expenditures * Expenditures 114,514 154,710 74.0% 103,057 137,205 75.1% 79,875 106,315 75.1% 87,475 116,634 75.0% 98,091 131,082 74.8% * - For prior years-total actual expenditures, for current year-total approved budget net of credit for early redemption fund resources $180,000 March 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 March are 12.1% 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,975 $ 426,681 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 $ 220,775 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) $ 43,580 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) $ 3,703 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,958 $ 82,416 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,117 $140,769 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 March 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 March YTD Revenues 762,700 777,995 838,230 878,185 945,213 16-17 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 71.7% 71.1% 72.1% 71.9% 74.3% * - For prior years - total actual revenues, for current year - total approved budget Better than Expected Fiscal year 2019-20 general fund operating revenues are budgeted to increase 4.3% over prior year actuals. Actual revenues through March are 7.6% 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 66,817 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 105,926 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 172,743 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 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 Better than Expected Because property taxes are primarily collected in November, December, May and June, a monthly breakdown of the revenues is not particularly useful, therefore the chart for property tax revenues is presented with an annual perspective. Total property tax revenues are budgeted to increase 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 105,926 66,817 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 March are 10.1% higher than the same period in the prior year. Actual local sales tax revenues through March are 5.8% 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 March state shared sales tax revenues are 5.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 Better than Expected State shared vehicle license tax revenues through March 2020 are 1.3% higher than budget expectations for the period. Vehicle License Tax 3 Year Trend 12,000 10,000 17-18 Actuals 18-19 Actuals 19-20 Actuals 8,000 6,000 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 Expected 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 March 2020 are 0.5% 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 March 2020 are 4.7% 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 Expected Water system revenues through March 2020 are 0.3% 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 March 2020 are 5.4% 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 MARCH 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 $ 383,420 $ 2,244 348,353 2,246 172,557 215,228 75,597 170,899 2,998 11,152 136,760 161,023 58,064 105,926 2,205 5,110 127,844 147,688 55,307 99,527 2,205 5,594 12,663 1,409 14,231 570 7,163 1,755 4,806 8,208 893 10,965 329 4,775 1,272 4,329 9,395 955 11,103 476 5,153 1,239 4,330 36,964 1,400 12,642 9,407 15,962 30,051 892 9,325 7,947 11,477 27,728 868 8,992 7,085 12,095 1,272,831 - 22 - $ 945,215 $ 878,183 General Fund Expenditures As of MARCH 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,200 $ 2,883 2,798 35,357 1,788 1,635 17,133 2,184 3,698 8,926 2,999 20,440 2,399 103,440 1,164 2,547 2,735 27,497 1,524 1,608 15,988 2,330 2,721 8,081 2,712 17,035 5,334 91,276 Criminal Justice Municipal Court Public Defender Total Criminal Justice 31,376 5,289 36,665 22,295 3,808 26,103 21,488 3,704 25,192 Public Safety Police Fire Others Total Public Safety 566,452 345,429 63 911,944 416,037 251,211 17 667,265 405,876 226,159 (125) 631,910 Transportation Street Transportation Public Transit Total Transportation 18,947 1,640 20,587 14,558 1,640 16,198 12,449 1,791 14,240 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 6,054 14,073 4,334 179 24,639 4,090 10,535 2,745 109 17,479 3,853 9,650 2,533 36 16,072 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 101,458 39,710 20,157 6,779 168,104 71,133 30,177 13,874 5,252 120,436 67,632 27,713 13,655 7,186 116,186 Environmental Services Public Works Environmental Programs Others Total Environmental Services 18,475 800 517 19,792 15,297 388 500 16,185 12,503 446 12,949 Capital Improvement 19,452 8,292 4,916 Vacancy Savings (5,000) - - Contingencies 57,912 - - 975,398 $ 912,741 Total Expenditures and Encumbrances $ 1,393,926 - 23 - $ Citywide Summary Presents the City's summarized comparisons of the year-to-date balances to the fiscal year budget and to the actual results for the prior year. Citywide Operating Revenue As of MARCH 31 (dollars in thousands) Source General Funds Local Taxes: Sales Taxes Privilege License Fees State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax Primary Property Tax Licenses and Permits Cable Communications Municipal Court Police Library Fees Parks and Recreation Planning & Development Street Transportation Fire Interest Other Fees and Service Charges Budget Estimate 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 383,420 $ 2,244 348,353 2,246 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 136,760 161,023 58,064 105,926 2,205 5,110 9,101 10,965 329 4,775 1,272 4,329 40,268 7,947 11,477 127,844 147,688 55,307 99,527 2,205 5,594 10,351 11,103 476 5,153 1,239 4,330 37,588 7,085 12,095 1,272,831 945,215 878,183 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 27,753 72,148 29,394 4,940 222,008 3,094 63,303 6,791 17,038 107,901 31,247 8,282 11,147 149,563 68,539 24,766 58,784 25,805 4,314 205,287 3,463 57,450 6,433 13,936 104,529 24,656 2,592 33,301 143,078 64,720 1,283,288 823,147 773,115 394,789 91,048 456,571 242,954 150,958 300,864 63,270 332,453 191,994 110,347 287,052 58,360 297,271 184,251 112,791 1,336,320 998,927 939,725 $ 3,892,439 - 24 - $ $ 2,767,289 $ 2,591,023 Citywide Operating Expenditures As of MARCH 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 103,440 $ 16,922 120,362 91,276 17,383 108,659 36,665 12,099 48,764 26,103 6,972 33,075 25,192 6,837 32,029 Public Safety General Funds Other Funds Total Public Safety 911,944 212,241 1,124,185 667,265 162,569 829,834 631,910 142,958 774,868 Transportation General Funds Other Funds Total Transportation 20,587 801,080 821,667 16,198 653,686 669,884 14,240 580,470 594,710 Community Development General Funds Other Funds Total Community Development 24,639 214,434 239,073 17,479 138,378 155,857 16,072 128,386 144,458 Community Enrichment General Funds Other Funds Total Community Enrichment 168,104 193,240 361,344 120,436 125,144 245,580 116,186 121,863 238,049 Environmental Services General Funds Other Funds Total Environmental Services 19,792 704,518 724,310 16,185 506,280 522,465 12,949 520,729 533,678 Debt Service General Funds Other Funds Total Debt Service 131,082 131,082 98,091 98,091 87,475 87,475 Capital Improvement General Funds Other Funds Total Capital Improvement 19,452 807,135 826,587 8,292 406,202 414,494 4,916 409,012 413,928 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 975,398 2,114,244 3,089,642 $ $ 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 - 912,741 2,015,113 2,927,854 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 MARCH 31 2020 2019 Budget Estimate 2019-2020 Source Actual Year-to-Date 2019-2020 2018-2019 General Funds $ 39,640,468 133,516 Local Taxes: Sales Taxes Privilege License Fees 61,255,146 39,773,984 Total Local Taxes 505,428,500 385,663,736 350,598,287 12,284,545 17,891,435 5,959,494 13,689,424 16,409,929 5,943,001 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 172,557,000 215,228,000 75,597,000 136,759,877 161,022,910 58,063,935 127,844,091 147,688,051 55,307,482 36,135,474 36,042,354 463,382,000 355,846,722 330,839,624 5,026,596 5,020,677 Primary Property Tax 170,899,000 105,925,693 99,527,234 283,060 329,960 Licenses and Permits 2,998,000 2,204,931 2,205,064 0 0 Cable Communications 11,152,000 5,109,853 5,593,515 764,351 126,171 1,293,619 171,802 Municipal Court: Fines and Forfeitures Court Default Fee 12,662,750 1,409,000 8,208,107 893,042 9,395,436 955,234 14,071,750 9,101,149 10,350,670 14,230,592 10,965,008 11,102,938 569,801 329,148 476,161 61,092,363 162,783 $ $ Total State Shared Taxes Total Municipal Court 502,650,000 2,778,500 $ 383,419,611 2,244,125 $ 348,352,582 2,245,705 890,522 1,465,421 1,510,090 1,981,930 31,878 47,520 Library Fees 321,939 771,399 Parks and Recreation 7,163,316 4,774,563 5,153,315 133,626 154,522 Planning and Development 1,755,490 1,272,451 1,238,580 481,941 419,112 Street Transportation 4,805,543 4,328,536 4,330,083 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other 36,964,000 1,400,000 12,641,599 30,050,953 891,625 9,325,253 27,727,926 868,450 8,992,360 37,588,736 Police 4,281,849 324,800 342,010 3,494,336 318,800 154,752 4,948,659 3,967,888 51,005,599 40,267,831 799,929 884,192 Interest 9,407,000 7,946,528 7,085,291 1,223,506 995,922 Other Fees and Service Charges 15,961,784 11,477,492 12,095,138 113,042,366 91,854,881 1,272,830,375 945,213,641 878,184,636 Total Fire Total General Funds 26 Citywide Operating Revenue by Source (continued) For the Month Ended MARCH 31 2020 2019 Budget Estimate 2019-2020 Source Actual Year-to-Date 2019-2020 2018-2019 Special Revenue and Debt Service Funds $ 2,919,941 208,568 1,042,835 29,584 $ 4,200,928 7,879,221 2,407,128 18,161 $ $ $ 10,304,510 1,986,334 141,881 709,405 35,454 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 2,873,074 Total Neighborhood Protection 4,540,217 1,135,064 332,415 6,007,696 4,365,418 $ 3,549,564 571,167 0 241,358 641 38,191 $ $ $ $ $ 625,372 0 274,311 (1,142) 22,990 851,357 28,556,423 3,644,228 $ $ 32,200,651 $ 25,633,000 1,831,000 9,155,000 639,000 $ 19,060,001 1,361,429 6,807,143 524,559 $ 16,989,396 1,213,528 6,067,641 495,752 37,258,000 27,753,132 24,766,317 75,998,000 25,316,000 444,000 54,299,914 17,470,453 377,571 44,770,966 13,347,683 665,547 101,758,000 72,147,938 58,784,196 Parks and Preserves 37,513,347 29,394,172 25,804,720 Golf Courses: Fees Coffee Shops Concessions Interest Other 3,372,500 0 1,883,000 0 258,285 3,100,001 0 1,575,608 2,010 262,611 2,679,884 0 1,486,682 (10,406) 158,139 Public Safety Enhancement & Expansion: Police Fire Interest/Other Total Public Safety Enhancement & Expansion 921,531 Total Golf Courses 5,513,785 4,940,230 4,314,299 19,402,868 4,380,795 Transit 2000 & 2050: Sales Taxes Interest/Other 249,936,000 47,738,578 185,968,072 36,039,780 165,850,293 39,436,944 297,674,578 222,007,852 205,287,237 23,783,663 Total Transit 2000 & 2050 60,546 $ 1,776,749 Court Awards 4,913,184 3,093,716 3,462,751 5,581,980 $ 5,153,658 Planning and Development 66,542,000 63,303,225 57,449,784 1,356,782 $ 742,427 Capital Construction 8,837,000 6,790,950 6,432,561 3,076,081 87,461 $ $ 2,333,129 81,789 Sports Facilities: Sales Taxes Interest/Other 23,063,000 4,508,180 14,918,222 2,119,808 13,215,670 720,317 27,571,180 17,038,030 13,935,987 3,163,542 2,414,918 Total Sports Facilities 27 Citywide Operating Revenue by Source (continued) For the Month Ended MARCH 31 2020 2019 Budget Estimate 2019-2020 Actual Year-to-Date 2019-2020 2018-2019 145,617,000 152,000 150,000 105,566,917 1,473,853 860,105 103,166,852 1,408,479 (46,335) Total Highway User Revenue 145,919,000 107,900,875 104,528,996 Local Transportation Assistance 0 0 0 40,580,254 31,246,883 24,656,212 Source Special Revenue and Debt Service Funds (Cont'd) $ 11,726,525 151,723 9,100 12,265,589 183,633 (974,883) 11,887,348 11,474,339 1,587,116 $ - Highway User Revenue: Highway User Revenue Interest Other 2,619,006 Regional Transit Revenues 57,643 495,766 Community Reinvestment 6,250,792 8,281,543 2,592,255 (4,376,583) 3,508,497 Other Restricted Fees 37,599,774 11,146,698 33,301,433 785,702 6,402,793 7,219,623 474,696 6,497,859 646,824 Grants: Public Housing: Rentals Grants Other 7,990,700 81,312,772 25,830,102 6,273,240 62,847,372 14,642,665 5,954,910 59,443,261 4,414,680 14,408,118 7,619,379 115,133,574 83,763,277 69,812,851 3,777,338 5,246,010 3,741,516 2,907,206 3,992,739 5,034,989 5,731,446 4,504,385 56,270,174 111,361,958 30,988,877 38,949,477 36,277,202 5,114,512 6,650,437 17,757,507 31,081,742 10,681,041 4,141,365 27,361,075 15,672,070 19,263,559 Total Other 237,570,486 65,799,658 73,265,223 30,080,188 26,882,938 Total Grants 352,704,060 149,562,935 143,078,074 3,157,869 0 3,110,258 0 107,881,000 4,772,266 66,816,762 1,722,121 62,322,381 2,397,975 3,157,869 3,110,258 Total G.O. Bond/Secondary Property Tax 112,653,266 68,538,883 64,720,356 104,479,295 95,314,084 Total Special Revenue and Debt Service Funds 1,283,288,220 823,147,062 773,115,178 160,590,000 218,625,000 5,500,000 4,403,200 2,589,500 3,081,500 0 85,352,061 202,721,945 4,877,156 672,417 2,221,716 2,601,770 2,416,894 81,987,595 195,530,233 3,938,548 159,983 1,997,117 2,343,265 1,095,244 394,789,200 300,863,959 287,051,985 $ Total Public Housing Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond/Secondary Property Tax Secondary Property Tax Interest Enterprise Funds AVIATION: 9,607,925 23,101,166 537,698 190,470 225,533 325,920 239,651 8,920,618 22,644,662 473,749 442,123 224,155 255,612 114,547 34,228,363 33,075,466 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 MARCH 31 2020 2019 Budget Estimate 2019-2020 Source Actual Year-to-Date 2019-2020 2018-2019 Enterprise Funds (Cont'd) CONVENTION CENTER: $ 7,422,033 2,586,288 107,377 6,248,684 2,516,577 104,666 10,115,698 8,869,927 21,769,342 346,616 602,497 665,480 468,600 455,480 553,027 18,993,585 384,459 561,473 444,952 396,240 (935,615) 293,091 24,861,042 20,138,185 Excise Taxes Operating Revenue Interest Total Convention Center 66,626,000 23,421,704 1,000,000 44,000,000 18,242,974 1,026,640 40,429,578 17,174,250 756,287 91,047,704 63,269,614 58,360,115 431,411,000 5,500,000 5,210,000 6,499,000 3,800,000 2,734,000 1,417,000 306,323,589 3,605,215 4,744,033 5,199,848 4,437,702 5,120,641 3,021,675 275,708,891 4,105,412 4,037,449 4,790,035 2,885,295 3,140,432 2,603,671 456,571,000 332,452,703 297,271,185 WATER SYSTEM: $ Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System WASTEWATER: 17,108,283 1,704,764 449,100 313,044 2,037,431 16,839,850 1,436,392 390,240 45,698 1,247,890 Sewer Service Charges Multi-City Development Fees Interest Other 205,243,000 18,052,000 3,700,000 1,994,000 13,965,000 154,223,655 15,225,489 4,120,140 3,470,222 14,954,450 152,134,077 15,150,946 2,769,480 2,770,146 11,426,160 21,612,622 19,960,070 Total Wastewater 242,954,000 191,993,956 184,250,809 131,647,000 7,811,400 400,000 11,099,474 100,162,245 6,264,686 607,260 3,312,924 99,079,322 6,133,825 730,913 6,846,752 150,957,874 110,347,115 112,790,812 1,336,319,778 998,927,347 939,724,906 SOLID WASTE: $ 11,179,962 596,669 50,235 280,896 11,054,496 762,231 88,501 877,466 12,107,762 12,782,694 102,925,487 94,826,342 320,447,148 $ 281,995,307 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ 29 3,892,438,373 $ 2,767,288,050 $ 2,591,024,720 Citywide Operating Expenditures by Program For the Month Ended MARCH 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 $ 121,369 $ 309,888 284,631 7,079,488 231,213 194,975 246,791 1,873,912 203,970 446,877 1,148,579 185,457 (24,506) 220,080 4,519,107 955,116 121,537 305,095 307,546 4,173,590 78,695 170,676 192,057 2,024,136 144,243 2,169,475 277,450 58,889 173,892 11,703 293,967 1,203,517 1,267,653 17,996,945 11,346,225 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,200,289 2,882,770 2,866,660 44,821,660 1,968,522 1,837,804 1,910,460 18,223,297 2,183,627 3,698,155 9,883,141 735,841 67,795 2,998,693 22,678,734 2,404,784 $ 1,164,478 2,547,372 2,870,567 37,059,409 939,473 1,813,838 1,876,870 17,096,608 2,330,274 4,734,387 9,030,481 534,198 121,453 1,790,412 56,349 2,712,185 19,125,798 2,854,717 $ 1,200,289 2,882,770 2,866,660 35,708,937 1,968,522 1,837,804 1,910,460 18,223,297 2,183,627 3,698,155 9,270,838 735,841 67,795 2,998,693 21,995,033 2,404,784 9,112,723 612,304 683,702 - 167,560,469 120,362,230 108,658,869 109,953,502 10,408,728 43,474,862 5,289,134 29,266,948 3,808,371 28,324,170 3,704,414 24,225,368 3,808,371 5,041,580 - 48,763,996 33,075,319 32,028,584 28,033,739 5,041,580 721,210,722 401,998,584 975,928 533,204,506 295,956,843 672,373 502,578,536 271,763,694 525,688 531,253,453 292,783,479 672,373 1,951,053 3,173,364 - 1,124,185,234 829,833,722 774,867,918 824,709,305 5,124,417 Criminal Justice 3,010,732 423,216 2,974,866 394,063 3,433,948 3,368,929 Municipal Court Public Defender Total Criminal Justice Public Safety 55,426,014 27,614,904 129,075 59,403,980 27,736,579 68,636 83,169,993 87,209,195 Police Fire Other Total Public Safety -30- Citywide Operating Expenditures by Program (continued) For the Month Ended MARCH 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,459,525 574,359 29,379,638 23,825,227 60,238,749 $ 5,304,671 780,150 26,466,565 10,800,038 Street Transportation Street Lighting Aviation Public Transit 43,351,424 Total Transportation $ 98,411,850 11,415,352 371,376,781 340,462,560 $ 75,317,084 7,139,624 264,435,844 322,991,299 $ 55,512,744 8,316,787 235,683,372 295,197,361 $ 72,090,677 7,139,624 201,474,803 252,392,452 3,226,407 62,961,041 70,598,847 821,666,543 669,883,851 594,710,264 533,097,556 136,786,296 Community Development 4,579,638 7,587,030 1,455,438 2,290,928 4,264,038 6,873,678 1,030,103 3,472,603 Planning and Development Housing Economic Development Neighborhood Services Department 71,928,530 100,338,355 19,590,335 47,215,711 47,030,057 69,596,632 12,339,187 26,891,025 40,640,416 66,645,469 10,021,736 27,150,539 47,030,057 69,543,181 7,411,829 26,891,025 53,451 4,927,357 - 15,913,034 15,640,422 Total Community Development 239,072,931 155,856,899 144,458,160 150,876,092 4,980,808 116,740,992 40,933,224 76,695,514 23,221,844 94,267,469 5,218,616 4,266,751 83,206,419 30,663,537 55,457,855 5,148,247 63,573,485 4,334,260 3,196,098 79,342,039 28,321,525 52,283,140 9,553,390 59,162,201 4,080,340 5,306,574 82,914,116 30,663,537 40,493,894 63,514,680 4,334,260 3,196,098 292,303 14,963,961 5,148,247 58,805 - 361,344,410 245,579,900 238,049,209 225,116,584 20,463,316 Community Enrichment 7,583,440 2,402,204 4,545,081 508,218 5,856,273 180,377 261,773 12,233,334 2,952,045 5,101,582 1,002,355 6,779,612 282,790 1,037,286 21,337,366 24,883,744 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 MARCH 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 $ 26,759,155 13,192,418 11,085,733 371,290 132,400 69,800 51,610,796 $ 48,454,121 18,707,058 13,000,758 1,469,157 135,950 81,767,044 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 $ 258,038,366 131,305,333 111,072,484 20,772,203 776,799 500,103 $ 202,742,226 198,619,601 118,891,494 12,659,196 765,093 - $ 169,934,415 78,580,681 101,627,577 15,386,854 776,799 500,103 88,103,951 52,724,652 9,444,908 5,385,348 155,658,860 724,310,227 522,465,288 533,677,610 366,806,428 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,570,775 8,552,719 4,570,639 517,388 5,314,499 457,481 7,793,908 1,631,762 10,190,634 5,421,553 2,630,547 13,627,098 7,725 5,087,928 3,714,193 1,874,686 12 1,048,500 12,033,199 5,601,844 4,613 5,439,697 3,537,788 9,127,767 14,967,260 190,103 8,024,819 251,231 4,548,988 618,538 7,300,367 6,174,118 501,147 9,382,533 225 4,576,485 1,391,638 1,765,636 12 1,304,550 9,623,599 3,795,446 4,613 388,447 2,570,775 8,552,719 4,570,639 517,388 5,314,499 457,481 7,793,908 1,631,762 10,190,634 5,421,553 2,630,547 13,627,098 7,725 5,087,928 3,714,193 1,874,686 12 1,048,500 12,033,199 5,601,844 4,613 5,439,697 - 98,091,401 - 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 393,088 1,014,197 1,663,029 21,123 891,646 27,914 505,443 68,727 811,152 686,013 55,683 1,042,504 25 508,499 154,626 196,182 144,950 1,069,289 421,716 513 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,710 9,719,480 Total Debt Service 131,082,016 98,091,401 87,475,310 36,029,410 41,965,426 Capital Improvement 826,586,943 414,494,479 413,928,394 - - - - Vacancy Savings (5,000,000) - - - - - - Contingencies 115,412,000 - - - - 300,645,952 319,251,889 4,554,984,769 3,089,643,090 -32- 2,927,854,318 2,336,684,607 338,464,004 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,749,964 19,772,000 321,805,336 9,203,942 241,948,272 95,418 $ 7,949,267 9,490,797 0 356,279 5,678,800 2,584,795 331,602 2,151,499 21,507,303 17,300,362 225,491,785 3,202,350 130,540,877 $ 2,305,842 379,650 5,036,248 237,510 5,450,303 4,242,972 13,776,569 409,218 174,265 11,972,320 406,193 69,139,995 3,908,075 114,043,441 986,974,762 $ 426,681,134 $ 231,482,601 $ $ 380,845,409 64,074,585 19,247,748 205,957,867 374,116,552 1,044,242,161 $ $ 220,774,700 43,580,122 3,703,003 82,415,531 140,768,606 491,241,962 $ 2,031,216,923 $ 917,923,095 - $ 14,546,377 16,778,542 6,100,000 29,948,367 13,535,050 925,000 4,085,000 77,904,067 19,772,000 $ $ $ 509,772,301 24,711,666 3,113,355 48,666,779 180,085,103 766,349,205 $ 997,831,806 2019-2020 Year-to-Date Capital Amounts From Capital Funds Budget Actual 204,701,310 134,421,065 $ 7,949,267 8,308,232 0 3,959,781 590,058 331,602 1,335,646 17,447,154 17,300,362 210,282,181 59,560,845 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,418 $ 1,182,565 356,279 1,719,019 1,994,738 815,852 4,060,148 15,209,604 3,202,350 70,980,032 902,484 156,774,437 34,296,245 (0) 15,996,841 35,796,977 600,000 21,064,148 593,398 2,832,261 75,242,661 2,471,638 96,313,551 6,001,592 111,407,395 522,716,778 $ 327,065,128 464,257,984 $ 99,616,005 560,293,628 $ $ 19,022,271 3,734,771 3,275,448 20,446,767 40,950,094 87,429,351 $ $ 93,232,622 14,393,555 9,034,831 49,690,460 137,518,697 303,870,165 $ 826,586,943 $ 414,494,479 - 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 $ $ $ 201,752,429 39,845,351 427,555 61,968,764 99,818,512 403,812,611 $ 160,070,709 20,494,463 15,544,745 123,542,336 233,347,946 553,000,199 $ 503,428,616 $ 1,113,293,828 Bonds Authorized and Sold As of MARCH 31 (dollars in thousands) Authorized Sold Available 1988 Authorizations General Obligation Bonds Freeway Mitigation, Neighborhood Stabilization, and Slum and Blight Elimination $ Bonds Fully Issued 29,285 884,175 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 May June YTD thru March 311,125 307,495 313,383 348,353 383,420 362,435 Apr 36,307 28,921 48,534 46,770 45,442 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 YTD thru March 101,214 105,449 120,249 127,844 136,760 130,225 Apr 12,975 12,900 12,631 14,284 15,117 (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 YTD thru March 43,362 45,312 51,982 55,307 58,064 57,334 June Apr 5,512 5,470 5,593 5,668 6,508 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 YTD thru March 1,405,092 1,523,070 1,600,444 1,651,300 1,768,360 1,776,788 June Apr 173,752 185,518 217,138 210,659 226,813 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 May 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 YTD thru March 255,646 257,846 277,005 287,052 300,864 287,247 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 - June Apr 30,759 33,162 37,265 37,847 37,063 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 YTD thru March 287,911 300,210 321,237 297,271 332,453 333,537 Apr 32,097 32,958 31,392 31,150 35,270 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 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 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 June YTD thru March 166,518 171,351 182,661 184,251 191,994 182,170 Apr 21,363 19,731 18,079 21,256 20,789 May 18,555 20,233 20,160 20,980 20,659 June 19,289 20,633 18,345 16,544 19,337