February 2020 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division February 29, 2020 To the Mayor and City Council: This is the City's Financial Report for February, the eighth 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 April 6, 2020 CITY AUDITOR REPORT To the Chief Financial Officer, We have assessed the Finance Department’s (Finance) February 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 February 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 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 Criminal Justice 5 6 Better than Expected 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 Expected State Sales Tax 16 Better than Expected Vehicle License Tax 17 Better than Expected Governmental Funds 18 Monitor and Consider Taking Action Aviation 19 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. February 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 707,066 1,066,521 66.3% 745,560 1,105,361 67.4% 791,533 1,177,280 67.2% 813,576 1,214,362 67.0% 880,045 1,341,015 65.6% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustment for contingencies. Better than Expected Total General Fund General Government $1,600,000 $1,400,000 $1,400,000 $1,200,000 $1,200,000 $1,000,000 $1,000,000 $800,000 $800,000 February YTD Expenditures February 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 February are 8.2% 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 71,538 105,240 68.0% 72,595 106,754 68.0% 79,150 110,408 71.7% 82,867 114,393 72.4% 88,050 139,831 63.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 $60,000 $40,000 $40,000 $20,000 $20,000 $0 February YTD Expenditures February 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 February are 6.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 February 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 Criminal Justice February YTD Annual % of Annual Expenditures Expenditures * Expenditures 21,719 30,698 70.8% 20,675 31,595 65.4% 21,636 32,232 67.1% 22,539 33,387 67.5% 23,352 36,665 63.7% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $40,000 February 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 February 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 Public Safety February YTD Annual % of Annual Expenditures Expenditures * Expenditures 489,816 737,129 66.4% 516,987 764,482 67.6% 544,939 817,960 66.6% 560,757 841,467 66.6% 603,669 911,944 66.2% * - For prior years-total actual expenditures, for current year-total approved budget $1,000,000 $800,000 February YTD Expenditures $600,000 $400,000 Annual Expenditures * $200,000 $0 15-16 16-17 17-18 18-19 19-20 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 February, general fund public safety expenditures are 7.7% 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 February 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 10,436 17,473 59.7% 11,098 17,878 62.1% 13,149 16,366 80.3% 12,790 18,337 69.7% 14,596 20,587 70.9% * - 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 February 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 February, General fund transportation expenditures are 14.1% 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 12,692 18,571 68.3% 12,784 19,709 64.9% 14,096 20,243 69.6% 14,108 21,238 66.4% 15,543 24,639 63.1% * - For prior years-total actual expenditures, for current year-total approved budget Community Development $30,000 February 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 February are 10.2% 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 February 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 91,777 141,483 64.9% 95,571 146,749 65.1% 102,794 156,325 65.8% 104,284 156,552 66.6% 109,973 168,104 65.4% * - For prior years-total actual expenditures, for current year-total approved budget Community Enrichment $200,000 February 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 February, general fund community enrichment expenditures are 5.5% 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 7,585 12,143 62.5% 13,748 12,775 107.6% 9,234 12,624 73.1% 11,433 16,886 67.7% 16,282 19,792 82.3% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services $24,000 February 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 February, general fund environmental services expenditures are 42.4% higher than the prior fiscal year. 4 Citywide Expenditures All expenditures of the City including those for enterprise functions and those related to dedicated revenue streams. Expenditures are reported in total and by program. February 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 2,073,930 3,156,441 65.7% 2,195,312 3,468,589 63.3% 2,350,069 3,547,078 66.3% 2,608,604 3,775,464 69.1% 2,788,997 4,444,572 62.8% * - 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 February 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 February are 6.9% higher than the same period in the prior fiscal year. General Government 15-16 16-17 17-18 18-19 19-20 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 80,324 118,505 67.8% 83,827 121,863 68.8% 92,407 134,117 68.9% 97,313 138,349 70.3% 102,365 167,560 61.1% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected General Government $200,000 February 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 February are 5.2% 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 February 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 27,337 39,463 69.3% 27,251 41,117 66.3% 25,645 38,411 66.8% 28,660 42,530 67.4% 29,641 48,764 60.8% * - For prior years-total actual expenditures, for current year-total approved budget Criminal Justice $60,000 February 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.4% higher through February 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 579,550 874,558 66.3% 607,741 908,553 66.9% 646,129 970,771 66.6% 687,659 1,025,513 67.1% 746,664 1,124,185 66.4% * - For prior years-total actual expenditures, for current year-total approved budget Public Safety $1,200,000 $1,000,000 February 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 February are 8.6% 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 February 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 444,364 609,990 72.8% 463,838 642,850 72.2% 522,075 709,977 73.5% 551,359 722,667 76.3% 609,645 821,667 74.2% * - 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 February 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.6% higher through February 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 115,620 174,956 66.1% 121,705 188,365 64.6% 135,253 203,096 66.6% 128,818 195,716 65.8% 139,944 239,073 58.5% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Community Development $300,000 February 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 February are 8.6% 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 February 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 178,360 273,179 65.3% 192,684 292,983 65.8% 205,936 306,763 67.1% 213,165 317,465 67.1% 224,243 361,344 62.1% * - 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 February 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 February are 5.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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 363,671 555,711 65.4% 391,423 599,837 65.3% 420,578 696,244 60.4% 451,911 670,219 67.4% 470,854 724,310 65.0% * - 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 February 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.2% higher through February 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 February 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 101,790 154,710 65.8% 91,709 137,205 66.8% 71,062 106,315 66.8% 77,756 116,634 66.7% 87,176 131,082 66.5% * - For prior years-total actual expenditures, for current year-total approved budget net of credit for early redemption fund resources $180,000 February 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 February 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 $ 387,371 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 $ 214,637 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) $ 41,596 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,579 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 $ 97,890 19-20 (Budget) 19-20 (YTD) $ 205,958 $ 66,516 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 19-20 (Budget) for 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 $129,417 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 February 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 February YTD Revenues 685,349 698,348 754,524 786,330 832,171 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 64.5% 63.8% 64.9% 64.4% 65.4% * - 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 February are 5.8% higher than the same period in the prior fiscal year. Specific revenue sources are discussed on the following pages. - 13 - Property Tax Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Property Taxes Primary & Secondary 270,000 240,000 210,000 91,021 180,000 95,435 107,881 101,652 Secondary 50,484 150,000 63,659 120,000 90,000 60,000 141,309 146,121 154,560 15-16 16-17 17-18 170,899 162,129 Primary 100,899 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 164,558 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 18-19 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,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 100,899 63,659 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 60,000 50,000 40,000 30,000 19-20 Actuals 19-20 Budget 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Expected Fiscal year 2019-20 local sales tax revenues through February are 4.4% higher than the same period in the prior year. Actual local sales tax revenues through February are 0.2% lower than budget expectations. Local Sales Tax 3 Year Trend 70,000 60,000 50,000 17-18 Actuals 40,000 18-19 Actuals 30,000 19-20 Actuals 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2018-19 local sales tax revenues were 10.5% higher than the prior year. This follows increases of 2.8% and 1.9% in the two previous years. Click Here for Additional Information - 15 - State Sales Tax Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 State Sales Tax Budget vs Actual 25,000 20,000 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 February state shared sales tax revenues are 7.5% 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 February 2020 are 2.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 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 February 2020 are 2.0% lower than budget expectations for the period. Governmental Funds Revenues 3 Year Trend 260,000.00 210,000.00 160,000.00 2017-18 Actuals 110,000.00 2018-19 Actuals 60,000.00 2019-20 Actuals 10,000.00 (40,000.00) July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2018-19 governmental fund revenues were 4.1% higher than the prior year. This follows increases of 4.9% and 8.3% in the two previous years. Click Here for Additional Information - 18 - Aviation Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Aviation Operating Revenues Budget vs Actual 40,000 35,000 30,000 25,000 19-20 Actuals 20,000 19-20 Budget 15,000 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Better than Expected Aviation operating revenues through February 2020 are 5.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 Expected Water system revenues through February 2020 are 0.4% 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 February 2020 are 5.3% 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 FEBRUARY 29 (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 $ 322,327 $ 2,081 308,712 2,112 172,557 215,228 75,597 170,899 2,998 11,152 124,475 143,131 52,104 100,899 1,922 5,110 114,155 131,278 49,364 94,507 1,875 5,594 12,663 1,409 14,231 570 7,163 1,755 4,806 7,444 767 9,455 297 4,453 1,139 3,847 8,102 783 9,121 429 4,382 1,084 3,911 36,964 1,400 12,642 9,407 15,962 25,769 567 8,983 7,147 10,254 24,233 550 8,838 6,201 11,099 1,272,831 - 22 - $ 832,171 $ 786,330 General Fund Expenditures As of FEBRUARY 29 (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,079 $ 2,573 2,520 29,329 1,593 1,424 15,424 1,980 3,251 7,863 2,779 16,141 2,094 88,050 1,043 2,242 2,434 24,382 1,375 1,435 14,216 2,186 2,565 7,919 2,418 16,027 4,625 82,867 Criminal Justice Municipal Court Public Defender Total Criminal Justice 31,376 5,289 36,665 19,967 3,385 23,352 19,229 3,310 22,539 Public Safety Police Fire Others Total Public Safety 566,452 345,429 63 911,944 376,838 226,878 (47) 603,669 357,733 203,155 (131) 560,757 Transportation Street Transportation Public Transit Total Transportation 18,947 1,640 20,587 12,955 1,640 14,595 10,999 1,791 12,790 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 6,054 14,073 4,334 179 24,640 3,657 9,390 2,402 94 15,543 3,464 8,317 2,295 32 14,108 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 101,458 39,710 20,157 6,779 168,104 64,705 27,854 12,444 4,970 109,973 61,172 24,870 12,162 6,081 104,285 Environmental Services Public Works Environmental Programs Others Total Environmental Services 18,475 800 517 19,792 15,525 327 430 16,282 11,040 393 11,433 Capital Improvement 19,452 8,581 4,797 Vacancy Savings (5,000) - - Contingencies 57,912 - - 880,045 $ 813,576 Total Expenditures and Encumbrances $ 1,393,927 - 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 FEBRUARY 29 (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 322,327 $ 2,081 308,712 2,112 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 124,475 143,131 52,104 100,899 1,922 5,110 8,211 9,455 297 4,453 1,139 3,847 35,319 7,147 10,254 114,155 131,278 49,364 94,507 1,875 5,594 8,885 9,121 429 4,382 1,084 3,911 33,621 6,201 11,099 1,272,831 832,171 786,330 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 23,552 61,843 25,029 4,089 189,807 3,033 57,721 5,434 13,874 96,014 29,660 8,224 15,523 119,483 65,381 21,893 52,777 22,255 3,393 181,504 1,686 52,296 5,690 11,521 93,055 22,037 2,096 29,793 116,195 61,610 1,283,288 718,668 677,801 394,789 91,048 456,571 242,954 150,958 266,636 53,154 307,592 170,381 98,239 253,977 49,490 277,133 164,291 100,008 1,336,320 896,002 844,899 $ 3,892,439 - 24 - $ $ 2,446,841 $ 2,309,029 Citywide Operating Expenditures As of FEBRUARY 29 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2019-2020 2018-2019 Budget 2019-2020 88,049 $ 14,316 102,365 82,868 14,445 97,313 36,665 12,099 48,764 23,352 6,289 29,641 22,539 6,121 28,660 Public Safety General Funds Other Funds Total Public Safety 911,944 212,241 1,124,185 603,669 142,995 746,664 560,757 126,902 687,659 Transportation General Funds Other Funds Total Transportation 20,587 801,080 821,667 14,596 595,049 609,645 12,791 538,568 551,359 Community Development General Funds Other Funds Total Community Development 24,639 214,434 239,073 15,543 124,401 139,944 14,108 114,710 128,818 Community Enrichment General Funds Other Funds Total Community Enrichment 168,104 193,240 361,344 109,973 114,270 224,243 104,285 108,880 213,165 Environmental Services General Funds Other Funds Total Environmental Services 19,792 704,518 724,310 16,282 454,572 470,854 11,432 440,479 451,911 Debt Service General Funds Other Funds Total Debt Service 131,082 131,082 87,176 87,176 77,756 77,756 Capital Improvement General Funds Other Funds Total Capital Improvement 19,452 807,135 826,587 8,581 369,884 378,465 4,797 367,166 371,963 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 880,045 1,908,952 2,788,997 $ $ 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 - 813,577 1,795,027 2,608,604 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 FEBRUARY 29 2020 2019 Budget Estimate 2019-2020 Source Actual Year-to-Date 2019-2020 2018-2019 General Funds $ 33,570,496 187,504 33,758,000 $ 38,579,102 283,393 Local Taxes: Sales Taxes Privilege License Fees $ 502,650,000 2,778,500 $ 322,327,248 2,081,342 $ 308,712,114 2,112,189 38,862,495 Total Local Taxes 505,428,500 324,408,590 310,824,303 17,707,764 17,891,434 6,528,715 15,368,194 16,409,929 5,490,127 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 172,557,000 215,228,000 75,597,000 124,475,332 143,131,475 52,104,441 114,154,667 131,278,122 49,364,481 42,127,913 37,268,250 463,382,000 319,711,248 294,797,270 4,622,943 3,356,496 Primary Property Tax 170,899,000 100,899,097 94,506,557 282,193 259,740 Licenses and Permits 2,998,000 1,921,871 1,875,104 0 0 Cable Communications 11,152,000 5,109,853 5,593,515 1,017,324 130,858 1,021,853 126,977 Municipal Court: Fines and Forfeitures Court Default Fee 12,662,750 1,409,000 7,443,756 766,871 8,101,817 783,432 1,148,182 1,148,830 14,071,750 8,210,627 8,885,249 2,984,301 749,063 Police 14,230,592 9,454,918 9,121,008 39,157 56,060 Library Fees 569,801 297,270 428,641 513,662 494,282 Parks and Recreation 7,163,316 4,452,624 4,381,916 167,079 148,636 Planning and Development 1,755,490 1,138,825 1,084,058 (307,321) 1,335,851 Street Transportation 4,805,543 3,846,595 3,910,971 3,210,487 59,700 123,398 3,803,415 53,600 207,872 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other 36,964,000 1,400,000 12,641,599 25,769,104 566,825 8,983,243 24,233,590 549,650 8,837,608 3,393,585 4,064,887 51,005,599 35,319,172 33,620,848 794,137 816,189 835,268 1,240,270 90,359,099 89,801,049 Total State Shared Taxes Total Municipal Court Total Fire Interest 9,407,000 7,146,599 6,201,099 Other Fees and Service Charges 15,961,784 10,253,986 11,099,216 1,272,830,375 832,171,275 786,329,755 Total General Funds 26 Citywide Operating Revenue by Source (continued) For the Month Ended FEBRUARY 29 2020 2019 Budget Estimate 2019-2020 Source Actual Year-to-Date 2019-2020 2018-2019 Special Revenue and Debt Service Funds $ 1,870,602 133,614 668,073 31,724 $ 2,704,013 4,851,424 1,421,802 25,611 $ $ $ 6,298,837 2,876,712 596,950 0 263,763 507 21,149 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 2,808,231 Total Neighborhood Protection 4,702,493 1,275,514 32,646 6,010,653 $ $ $ $ $ $ 882,369 18,181,341 4,120,182 1,936,917 138,351 691,756 41,207 $ $ 22,301,523 2,872,868 445,388 0 203,209 (1,125) 21,495 25,633,000 1,831,000 9,155,000 639,000 $ 16,140,060 1,152,861 5,764,308 494,975 $ 15,003,062 1,071,647 5,358,236 460,298 37,258,000 23,552,204 21,893,243 75,998,000 25,316,000 444,000 46,420,693 15,063,325 359,410 40,230,749 12,212,619 333,132 101,758,000 61,843,428 52,776,500 Parks and Preserves 37,513,347 25,028,754 22,255,156 Golf Courses: Fees Coffee Shops Concessions Interest Other 3,372,500 0 1,883,000 0 258,285 2,528,834 0 1,334,250 1,369 224,420 2,054,512 0 1,212,371 (9,264) 135,149 Public Safety Enhancement & Expansion: Police Fire Interest/Other Total Public Safety Enhancement & Expansion 668,967 Total Golf Courses 5,513,785 4,088,873 3,392,768 18,959,792 1,106,421 Transit 2000 & 2050: Sales Taxes Interest/Other 249,936,000 47,738,578 157,411,649 32,395,552 146,447,425 35,056,149 20,066,213 0 $ 0 6,376,891 $ 5,362,662 121,878 $ 583,593 1,426,598 485,283 $ $ 1,264,700 70,004 1,911,881 $ 1,334,704 297,674,578 189,807,201 181,503,574 Court Awards Total Transit 2000 & 2050 4,913,184 3,033,170 1,686,002 Planning and Development 66,542,000 57,721,245 52,296,126 Capital Construction 8,837,000 5,434,168 5,690,134 Sports Facilities: Sales Taxes Interest/Other 23,063,000 4,508,180 11,842,141 2,032,347 10,882,541 638,528 27,571,180 13,874,488 11,521,069 Total Sports Facilities 27 Citywide Operating Revenue by Source (continued) For the Month Ended FEBRUARY 29 2020 2019 Budget Estimate 2019-2020 Actual Year-to-Date 2019-2020 2018-2019 145,617,000 152,000 150,000 93,840,392 1,322,130 851,005 90,901,263 1,224,846 928,548 Total Highway User Revenue 145,919,000 96,013,527 93,054,657 Local Transportation Assistance 0 0 0 Source Special Revenue and Debt Service Funds (Cont'd) $ 12,231,242 153,789 (345) 11,778,347 167,093 17,241 12,384,686 11,962,681 - $ - Highway User Revenue: Highway User Revenue Interest Other 4,146,282 5,371,056 Regional Transit Revenues 40,580,254 29,659,767 22,037,206 131,877 112,472 Community Reinvestment 6,250,792 8,223,900 2,096,489 2,879,102 2,239,466 Other Restricted Fees 37,599,774 15,523,281 29,792,936 720,094 6,224,052 1,382,104 671,822 9,324,043 411,554 Grants: Public Housing: Rentals Grants Other 7,990,700 81,312,772 25,830,102 5,487,538 56,444,579 7,423,042 5,480,214 52,945,402 3,767,856 8,326,250 10,407,419 115,133,574 69,355,159 62,193,472 4,196,045 9,437,377 3,822,503 5,079,447 4,326,270 2,912,316 36,636 4,520,122 56,270,174 111,361,958 30,988,877 38,949,477 32,499,864 (131,498) 2,908,921 14,850,301 27,089,003 5,646,052 (1,590,081) 22,856,690 22,535,372 11,795,344 Total Other 237,570,486 50,127,588 54,001,664 30,861,622 22,202,763 Total Grants 352,704,060 119,482,747 116,195,136 107,881,000 4,772,266 63,658,893 1,722,121 59,212,123 2,397,975 112,653,266 65,381,014 61,610,098 1,283,288,220 718,667,767 677,801,094 160,590,000 218,625,000 5,500,000 4,403,200 2,589,500 3,081,500 0 75,744,136 179,620,779 4,339,458 481,947 1,996,183 2,275,850 2,177,243 73,066,977 172,885,571 3,464,799 (282,140) 1,772,962 2,087,653 980,697 394,789,200 266,635,596 253,976,519 2,823,740 0 2,065,087 0 2,823,740 2,065,087 96,701,413 83,661,416 $ 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,655,590 23,074,850 512,423 233,245 235,430 264,451 238,309 9,343,267 21,895,800 399,917 670,378 220,600 287,952 125,995 34,214,298 32,943,909 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 FEBRUARY 29 2020 2019 Budget Estimate 2019-2020 Source Actual Year-to-Date 2019-2020 2018-2019 Enterprise Funds (Cont'd) CONVENTION CENTER: $ 4,511,382 2,627,507 99,944 4,399,468 2,042,163 82,839 7,238,833 6,524,470 22,490,719 413,960 510,374 504,669 651,720 482,088 589,324 18,978,960 434,300 323,524 622,425 385,695 481,151 332,208 25,642,854 21,558,263 Excise Taxes Operating Revenue Interest Total Convention Center 66,626,000 23,421,704 1,000,000 36,577,967 15,656,686 919,263 34,180,894 14,657,673 651,621 91,047,704 53,153,916 49,490,188 431,411,000 5,500,000 5,210,000 6,499,000 3,800,000 2,734,000 1,417,000 284,554,247 3,258,599 4,141,536 4,534,368 3,969,102 4,665,161 2,468,648 256,715,306 3,720,953 3,475,976 4,345,083 2,489,055 4,076,047 2,310,580 456,571,000 307,591,661 277,133,000 WATER SYSTEM: $ Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System WASTEWATER: 16,844,565 1,725,246 624,180 373,146 1,405,848 16,843,298 789,765 375,720 356,216 1,070,282 Sewer Service Charges Multi-City Development Fees Interest Other 205,243,000 18,052,000 3,700,000 1,994,000 13,965,000 137,115,372 13,520,725 3,671,040 3,157,178 12,917,019 135,294,227 13,714,554 2,379,240 2,724,448 10,178,270 20,972,985 19,435,281 Total Wastewater 242,954,000 170,381,334 164,290,739 11,167,133 637,514 51,268 268,635 11,043,229 572,584 76,288 1,563,157 131,647,000 7,811,400 400,000 11,099,474 88,982,283 5,668,017 557,025 3,032,028 88,024,826 5,371,594 642,412 5,969,286 12,124,550 13,255,258 150,957,874 98,239,353 100,008,118 100,193,520 93,717,181 1,336,319,778 896,001,860 844,898,564 SOLID WASTE: $ 287,254,032 $ 267,179,646 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ 29 3,892,438,373 $ 2,446,840,902 $ 2,309,029,413 Citywide Operating Expenditures by Program For the Month Ended FEBRUARY 29 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 $ 124,217 $ 331,639 315,502 3,660,368 185,209 192,814 120,921 1,615,408 166,330 340,690 554,145 (1,038,087) 10,070 297,440 682,307 302,920 81,751 266,767 287,916 7,204,134 78,514 167,617 192,849 1,627,746 115,465 (1,120,869) 970,293 48,397 (5,164) 178,808 8,030 154,299 1,121,471 509,691 7,861,894 13,515,611 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,078,920 2,572,882 2,582,029 37,742,172 1,737,309 1,642,828 1,663,669 16,349,384 1,979,657 3,251,278 8,734,562 550,384 92,301 2,778,613 18,159,628 1,449,668 $ 1,042,941 2,242,277 2,563,021 32,885,819 860,778 1,643,162 1,684,813 15,072,472 2,186,031 2,564,912 8,753,031 475,309 121,453 1,616,520 44,646 2,418,218 17,922,281 1,587,064 $ 1,078,920 2,572,882 2,582,029 29,641,822 1,737,309 1,642,828 1,663,669 16,349,384 1,979,657 3,251,278 8,190,292 550,384 92,301 2,778,613 17,551,893 1,449,668 8,100,350 544,270 607,735 - 167,560,469 102,365,285 97,312,644 93,112,930 9,252,355 43,474,862 5,289,134 26,256,216 3,385,155 25,349,304 3,310,351 21,774,751 3,385,155 4,481,464 - 48,763,996 29,641,370 28,659,655 25,159,906 4,481,464 721,210,722 401,998,584 975,928 477,778,492 268,341,940 543,297 443,174,556 244,027,115 457,052 476,044,163 265,520,992 543,297 1,734,329 2,820,948 - 1,124,185,234 746,663,729 687,658,723 742,108,451 4,555,277 Criminal Justice 2,964,909 394,667 2,903,404 388,377 3,359,576 3,291,781 Municipal Court Public Defender Total Criminal Justice Public Safety 51,256,881 28,622,256 81,894 50,956,161 27,842,647 (190,955) 79,961,031 78,607,853 Police Fire Other Total Public Safety -30- Citywide Operating Expenditures by Program (continued) For the Month Ended FEBRUARY 29 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 $ 8,515,771 552,392 28,851,316 10,714,728 48,634,206 $ 3,580,549 1,540,977 26,388,057 10,018,858 Street Transportation Street Lighting Aviation Public Transit 41,528,441 Total Transportation $ 98,411,850 11,415,352 371,376,781 340,462,560 $ 68,857,558 6,565,265 235,056,206 299,166,072 $ 50,208,073 7,536,637 209,216,807 284,397,323 $ 65,989,641 6,565,265 180,302,271 249,735,287 2,867,917 54,753,935 49,430,785 821,666,543 609,645,102 551,358,840 502,592,465 107,052,637 Community Development 5,096,267 7,777,627 839,373 1,946,844 4,059,035 7,767,925 940,463 1,759,948 Planning and Development Housing Economic Development Neighborhood Services Department 71,928,530 100,338,355 19,590,335 47,215,711 42,450,419 62,009,601 10,883,749 24,600,097 36,376,378 59,771,791 8,991,633 23,677,936 42,450,419 61,962,090 6,503,815 24,600,097 47,512 4,379,933 - 15,660,111 14,527,371 Total Community Development 239,072,931 139,943,865 128,817,738 135,516,421 4,427,445 116,740,992 40,933,224 76,695,514 23,221,844 94,267,469 5,218,616 4,266,751 75,622,978 28,261,333 50,912,774 4,640,029 57,717,212 4,153,883 2,934,325 67,108,705 25,369,480 47,181,558 8,551,035 52,382,589 3,797,550 4,269,288 75,363,153 28,261,333 37,611,015 57,664,941 4,153,883 2,934,325 259,825 13,301,760 4,640,029 52,271 - 361,344,410 224,242,534 213,165,465 205,988,650 18,253,885 Community Enrichment (2,490,045) 2,602,492 3,032,254 508,218 6,353,499 96,572 274,153 2,528,431 2,949,677 4,093,384 1,002,354 6,124,058 99,001 224,915 10,377,143 21,527,080 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 FEBRUARY 29 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 $ 33,296,752 13,950,157 14,678,312 1,314,230 164,125 50,507 63,454,083 $ 12,620,864 20,544,447 10,780,027 135,439 (465,968) 43,614,809 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 $ 231,279,211 118,112,915 99,986,751 20,400,912 644,399 430,303 $ 154,288,105 179,912,543 105,890,736 11,190,039 629,143 - $ 153,585,760 71,245,525 91,591,198 15,613,576 644,399 430,303 77,693,451 46,867,390 8,395,553 4,787,336 137,743,731 724,310,227 470,854,492 451,910,566 333,110,761 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,285,133 7,602,417 4,062,791 459,900 4,723,999 406,650 6,927,918 1,450,455 9,058,342 4,819,158 2,338,264 12,112,976 6,867 4,522,603 3,301,505 1,666,388 12 915,333 10,696,177 4,979,417 4,100 4,835,286 3,144,700 8,113,570 13,304,231 168,980 7,133,173 223,317 4,043,545 549,811 6,489,215 5,488,105 445,464 8,340,029 200 4,067,986 1,237,012 1,569,454 12 1,159,600 8,554,310 3,373,730 4,100 345,286 2,285,133 7,602,417 4,062,791 459,900 4,723,999 406,650 6,927,918 1,450,455 9,058,342 4,819,158 2,338,264 12,112,976 6,867 4,522,603 3,301,505 1,666,388 12 915,333 10,696,177 4,979,417 4,100 4,835,286 - 87,175,691 - 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,087 1,014,196 1,663,029 21,122 891,647 27,915 505,443 68,726 811,152 686,014 55,683 1,042,504 25 508,498 154,627 196,181 144,950 1,069,288 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,710 9,719,476 Total Debt Service 131,082,016 87,175,691 77,755,830 174,678,108 13,379,708 Capital Improvement 826,586,943 378,465,069 371,962,967 - - - - Vacancy Savings (5,000,000) - - - - - - Contingencies 115,412,000 - - - - 414,901,861 239,712,130 4,554,984,769 2,788,997,138 -32- 2,608,602,428 2,124,765,275 285,766,794 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 94,510 $ 6,233,549 9,563,736 (0) 353,571 5,525,376 2,415,181 325,481 2,144,842 15,853,385 17,299,852 223,894,109 3,202,350 100,464,590 $ 2,239,148 359,412 4,895,200 237,510 5,428,998 3,281,680 13,446,887 406,663 169,671 10,928,022 372,713 67,781,721 3,908,075 73,858,666 986,974,762 $ 387,370,531 $ 187,314,364 $ $ 380,845,409 64,074,585 19,247,748 205,957,867 374,116,552 1,044,242,161 $ $ 214,637,106 41,595,944 3,578,869 66,515,512 129,416,636 455,744,068 $ 2,031,216,923 $ 843,114,599 - $ 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 $ $ $ 503,770,932 22,658,571 3,072,369 38,435,012 155,259,526 723,196,410 $ 910,510,774 2019-2020 Year-to-Date Capital Amounts From Capital Funds Budget Actual 204,701,310 134,421,065 $ 6,233,549 8,592,990 (0) 3,857,976 577,047 325,481 1,329,344 15,753,169 17,299,852 208,685,044 36,143,162 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 94,510 $ 970,746 353,571 1,667,400 1,838,134 815,498 100,216 15,209,065 3,202,350 64,321,428 903,392 158,490,155 34,223,306 0 15,999,549 35,950,401 600,000 21,233,762 599,519 2,838,918 80,896,579 2,472,148 97,911,227 6,001,592 141,483,682 522,716,778 $ 298,797,614 464,257,984 $ 88,572,918 599,604,231 $ $ 18,976,981 3,708,922 3,226,278 16,728,486 37,026,788 79,667,455 $ $ 93,232,622 14,393,555 9,034,831 49,690,460 137,518,697 303,870,165 $ 826,586,943 $ 378,465,069 - 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 $ $ $ 195,660,125 37,887,022 352,591 49,787,026 92,389,848 376,076,612 $ 166,208,303 22,478,641 15,668,879 139,442,355 244,699,916 588,498,093 $ 464,649,530 $ 1,188,102,324 Bonds Authorized and Sold As of FEBRUARY 29 (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 Apr May June YTD thru February 277,990 273,993 280,413 308,712 322,327 323,018 Mar 33,135 33,502 32,970 39,641 39,417 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 YTD thru February 90,075 93,664 106,598 114,155 124,475 115,831 Mar 11,139 11,785 13,651 13,689 14,394 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 YTD thru February 38,298 39,856 46,489 49,364 52,104 50,910 May Mar 5,065 5,457 5,493 5,943 6,424 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 Mar 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 YTD thru February 1,244,386 1,363,704 1,432,995 1,464,131 1,550,839 1,582,455 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 - Apr May Mar 160,707 159,366 167,449 187,169 194,333 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 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 YTD thru February 224,116 228,573 243,935 253,977 266,636 253,406 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 Mar 31,530 29,273 33,070 33,075 33,841 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 YTD thru February 263,424 279,284 297,431 277,133 307,592 308,837 Mar 24,487 20,925 23,806 20,138 24,700 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 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 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 - Apr YTD thru February 147,859 151,733 162,144 164,291 170,381 161,814 May June Mar 18,659 19,618 20,517 19,960 20,356 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