July 2017 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division City of Phoenix Monthly Financial Report July 2017 Table of Contents Expenditures by Programs Page Performance Status General Fund Expenditures Report Navigation General Fund Total Expenditures 1 Monitor and Consider Taking Action General Government 1 Monitor and Consider Taking Action Click on either the schedule name or the Criminal Justice 2 Monitor and Consider Taking Action performance status in the table of contents to Public Safety 2 Better than Expected Transportation 3 Monitor and Consider Taking Action Community Development 3 Monitor and Consider Taking Action From any page of the report, click on the Community Enrichment 4 Monitor and Consider Taking Action City of Phoenix Bird Emblem to return to the Environmental Services 4 Better than Expected be taken directly to that page of the report. Table of Contents Citywide Expenditures Citywide Total Operating Expenditures 5 Monitor and Consider Taking Action General Government 5 Monitor and Consider Taking Action Criminal Justice 6 Monitor and Consider Taking Action Public Safety 6 Better than Expected Transportation 7 Monitor and Consider Taking Action Community Development 7 Better than Expected Community Enrichment 8 Monitor and Consider Taking Action Environmental Services 8 Better than Expected General Obligation Debt Service 9 Monitor and Consider Taking Action Performance Status Better than Expected - Positive variance of greater than 1% actual vs budget. Expected - Actual vs budget variance within 1% positive or negative. Monitor and Consider Taking Action - Negative 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 General Fund Total Operating Revenue Page 13 Performance Status Monitor and Consider Taking Action Property Tax 14 Expected Local Sales Tax 15 Monitor and Consider Taking Action State Sales Tax 16 Monitor and Consider Taking Action Vehicle License Tax 17 Better than Expected Governmental Funds 18 Monitor and Consider Taking Action Aviation 19 Monitor and Consider Taking Action Water System 20 Better than Expected Wastewater 21 Better than Expected Financial Schedules Page General Fund Revenue 22 General Fund Expenditures 23 Citywide Operating Revenue 24 Citywide Operating Expenditures 25 Citywide Operating Revenue by Source 26 Citywide Operating Expenditures by Program 30 Capital Expenditures and Encumbrances 33 Bonds Authorized and Sold 34 Appendix A - Additional Detail for Revenues General Fund Expenditures Expenditures from the City's General Fund for core functions such as Police, Fire, Parks, Streets and Social Services as well as administrative functions such as Mayor and Council, City Manager, Finance, and Human Resources. This does not include any expenditures from dedicated revenue streams such as grants, bonds, specifically dedicated taxes, and enterprise revenues. July General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Total General Fund Expenditures 13-14 14-15 15-16 16-17 17-18 Annual % of Annual July YTD Expenditures Expenditures * Expenditures 109,999 1,042,102 10.6% 111,441 1,051,395 10.6% 111,233 1,066,521 10.4% 99,620 1,105,361 9.0% 118,244 1,221,840 9.7% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustment for contingencies. Monitor and Consider Taking Action Total General Fund General Government $1,400,000 $1,200,000 $1,200,000 $1,000,000 $1,000,000 $800,000 $800,000 $600,000 $600,000 July YTD July YTD Expenditures Expenditures $400,000 $400,000 $200,000 $200,000 $0 $0 Annual Annual Expenditures * Expenditures * 13-14 13-14 14-15 15-16 14-15 16-17 17-18 15-16 In order to have a better comparison to prior year actuals, contingencies 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 2017-18 budgeted general fund expenditures are 10.5% higher than the fiscal year 2016-17 actuals. Fiscal year 2017-18 actual general fund expenditures through July are 18.7% higher than the same period in fiscal year 2016-17. General fund expenditures increased 3.6% in fiscal year 2016-17 over fiscal year 2015-16. This followed increases of 1.4% and 0.9% in the two prior years. General Government 13-14 14-15 15-16 16-17 17-18 Annual % of Annual July YTD Expenditures Expenditures * Expenditures 11,829 100,400 11.8% 10,205 96,385 10.6% 8,890 105,240 8.4% 8,400 106,754 7.9% 10,188 118,398 8.6% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action Criminal Justice General Government $120,000 $140,000 $100,000 $120,000 $80,000 $100,000 July YTD Expenditures July YTD Expenditures $80,000 $60,000 Annual Expenditures * $60,000 $40,000 $40,000 $20,000 $20,000 Annual Expenditures * $0$0 13-1413-1414-15 14-15 16-17 15-16 15-16 17-18 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 2017-18 budget includes a 10.9% increase over fiscal year 2016-17 actuals. General fund general government expenditures through July are 21.3% higher than the same period in the prior fiscal year. General fund general government expenditures increased 6.3% over the four years from fiscal year 2013-14 to fiscal year 2016-17. The increase from fiscal year 2015-16 to fiscal year 2016-17 was 1.4%. 1 July General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Criminal Justice Annual % of Annual July YTD Expenditures Expenditures * Expenditures 3,653 32,659 11.2% 3,535 31,018 11.4% 5,948 30,698 19.4% 2,235 31,595 7.1% 3,036 34,322 8.8% 13-14 14-15 15-16 16-17 17-18 * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action Criminal Justice Public Safety $40,000 $1 $35,000 $1 July YTD Expenditures Series1 $30,000 $1 $25,000 $1 $20,000 $0 $15,000 $0 $10,000 $0 $5,000 Annual Expenditures * Series2 $0 13-14 14-15 15-16 16-17 17-18 Criminal justice expenditures include costs for municipal courts and public defenders. The fiscal year 2017-18 budget includes an 8.6% increase over fiscal year 2016-17 actuals. General fund criminal justice expenditures through July are 35.8% higher than the same period in the prior fiscal year. General fund criminal justice expenditures were 2.9% higher in fiscal year 2016-17 over fiscal year 2015-16. Even with that increase, fiscal year 2016-17 expenditures were 3.2% lower than fiscal year 2013-14 levels. Public Safety 13-14 14-15 15-16 16-17 17-18 Public Safety Annual % of Annual July YTD Expenditures Expenditures * Expenditures 67,778 699,796 9.7% 72,457 716,304 10.1% 71,611 737,129 9.7% 69,516 764,482 9.1% 75,495 847,357 8.9% * - For prior years-total actual expenditures, for current year-total approved budget $1,000,000 $800,000 July YTD Expenditures $600,000 $400,000 Annual Expenditures * $200,000 $0 13-14 14-15 15-16 16-17 17-18 Better than Expected Public safety expenditures include costs for police and fire services. The general fund public safety fiscal year 2017-18 budget includes a 10.8% increase over fiscal year 201617 actuals. Through July, general fund public safety expenditures are 8.6% higher than the prior fiscal year. General fund public safety expenditures increased 2.4% from fiscal year 2013-14 to fiscal year 2014-15, 2.9% from fiscal year 2014-15 to fiscal year 2015-16, and 3.7% from fiscal year 2015-16 to fiscal year 2016-17. 2 July General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Transportation 13-14 14-15 15-16 16-17 17-18 Annual % of Annual July YTD Expenditures Expenditures * Expenditures 5,782 29,713 19.5% 6,517 34,187 19.1% 6,675 17,473 38.2% 1,571 17,878 8.8% 8,686 20,548 42.3% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action Transportation $40,000 $30,000 July YTD Expenditures $20,000 $10,000 Annual Expenditures * $0 13-14 14-15 15-16 16-17 17-18 Transportation expenditures include costs for public transit and street maintenance and repair. General Fund transportation expenditures for fiscal year 2017-18 are budgeted to increase 14.9% over fiscal year 2016-17 actuals. Reimbursements for AHUR eligible expenditures were not recorded in July 2017. Since the reimbursement for July 2016 was recorded in July, a year over year comparison is not useful. 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 13-14 14-15 15-16 16-17 17-18 Annual % of Annual July YTD Expenditures Expenditures * Expenditures 2,293 20,210 11.3% 2,126 18,986 11.2% 1,906 18,571 10.3% 1,347 19,709 6.8% 1,763 22,583 7.8% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action Community Development Enrichment Community $1 $25,000 $1 $20,000 $1 $1 $15,000 $1 $10,000 $1 $1 $5,000 $0 $0 July Series1 YTD Expenditures Series2 Annual Expenditures * 13-14 14-15 15-16 16-17 17-18 Community development expenditures include costs for economic development and neighborhood services. The fiscal year 2017-18 budget includes a 14.6% increase over fiscal year 2016-17 actuals. General fund community development expenditures through July are 30.9% higher than the same period in the prior fiscal year. General fund community development expenditures increased in fiscal year 2016-17 over fiscal year 2015-16 by 6.1%. This follows year over year decreases in fiscal years 2015-16 and 2014-15 leaving fiscal year 2016-17 expenditures 2.5% lower than fiscal year 2013-14. 3 July General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Transportation 13-14 14-15 15-16 16-17 17-18 Annual % of Annual July YTD Expenditures Expenditures * Expenditures 5,782 29,713 19.5% 6,517 34,187 19.1% 6,675 17,473 38.2% 1,571 17,878 8.8% 8,686 20,548 42.3% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action Transportation $40,000 $30,000 July YTD Expenditures $20,000 $10,000 Annual Expenditures * $0 13-14 14-15 15-16 16-17 17-18 Transportation expenditures include costs for public transit and street maintenance and repair. General Fund transportation expenditures for fiscal year 2017-18 are budgeted to increase 14.9% over fiscal year 2016-17 actuals. Reimbursements for AHUR eligible expenditures were not recorded in July 2017. Since the reimbursement for July 2016 was recorded in July, a year over year comparison is not useful. 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 13-14 14-15 15-16 16-17 17-18 Annual % of Annual July YTD Expenditures Expenditures * Expenditures 2,293 20,210 11.3% 2,126 18,986 11.2% 1,906 18,571 10.3% 1,347 19,709 6.8% 1,763 22,583 7.8% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action Community Development Enrichment Community $1 $25,000 $1 $20,000 $1 $1 $15,000 $1 $10,000 $1 $1 $5,000 $0 $0 July Series1 YTD Expenditures Series2 Annual Expenditures * 13-14 14-15 15-16 16-17 17-18 Community development expenditures include costs for economic development and neighborhood services. The fiscal year 2017-18 budget includes a 14.6% increase over fiscal year 2016-17 actuals. General fund community development expenditures through July are 30.9% higher than the same period in the prior fiscal year. General fund community development expenditures increased in fiscal year 2016-17 over fiscal year 2015-16 by 6.1%. This follows year over year decreases in fiscal years 2015-16 and 2014-15 leaving fiscal year 2016-17 expenditures 2.5% lower than fiscal year 2013-14. 3 Citywide Expenditures All expenditures of the City including those for enterprise functions and those related to dedicated revenue streams. Expenditures are reported in total and by program. July Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Total Citywide Operating 13-14 14-15 15-16 16-17 17-18 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 396,320 3,054,098 13.0% 413,245 3,051,875 13.5% 281,867 3,156,441 8.9% 277,234 3,468,591 8.0% 330,745 3,959,913 8.4% * - 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 General Government $4,500,000 $3,500,000 $4,000,000 $3,000,000 $3,500,000 $2,500,000 $3,000,000 $2,500,000 $2,000,000 $2,000,000 $1,500,000 $1,500,000 $1,000,000 $1,000,000 $500,000 $500,000 $0 $0 Monitor and Consider Taking Action July YTD July YTD Expenditures Expenditures Annual Annual Expenditures * * Expenditures 13-14 14-15 13-14 15-16 14-15 16-17 17-18 15-16 In order to have a better comparison to prior year actuals, contingencies will only be included in the annual budget to the extent that they have been spent. Without contingencies, the budget for fiscal year 2017-18 anticipates an increase of 14.2% over fiscal year 2016-17 actuals in total operating expenditures. Actual expenditures through July are 19.3% higher than the same period in the prior fiscal year. General Government 13-14 14-15 15-16 16-17 17-18 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 11,957 114,235 10.5% 10,471 108,690 9.6% 8,707 118,505 7.3% 8,448 121,863 6.9% 11,213 147,657 7.6% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action Criminal Justice General Government $140,000 $160,000 $120,000 $140,000 $100,000 $120,000 $80,000 $100,000 July YTD Expenditures July YTD Expenditures Annual Expenditures * $80,000 $60,000 $60,000 $40,000 $40,000 $20,000 $20,000 $0 Annual Expenditures * 13-14 14-15 13-14 14-15 15-16 16-17 15-16 17-18 General government expenditures include costs for administrative and internal service functions such as the Mayor and City Council, City Manager's Office, City Auditor, Finance, Budget and Research, and Human Resources. Citywide general government expenditures through July are 32.7% higher than the same period in the prior fiscal year. The budget anticipates an increase of 21.2% for fiscal year 2017-18 over fiscal year 2016-17 actuals. 5 July Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Criminal Justice 13-14 14-15 15-16 16-17 17-18 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 4,554 40,697 11.2% 4,310 39,265 11.0% 6,650 39,463 16.9% 3,079 41,117 7.5% 3,674 46,594 7.9% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action Public Safety Criminal Justice $50,000 $200,000 July YTD Expenditures Series1 $40,000 $30,000 Annual Expenditures * Series2 $20,000 $10,000 $0 $0 13-14 14-15 15-16 16-17 17-18 Criminal Justice expenditures include costs of the Municipal Court and the Public Defender’s office. Citywide criminal justice expenditures are 19.3% higher through July than the same period in the prior fiscal year. The budgeted increase for fiscal year 2017-18 over fiscal year 2016-17 actuals is 13.3%. Public Safety 13-14 14-15 15-16 16-17 17-18 Transportation Public Safety July YTD Annual % of Annual Expenditures Expenditures * Expenditures 81,520 842,270 9.7% 84,376 841,817 10.0% 82,409 874,558 9.4% 80,630 908,553 8.9% 86,759 1,032,610 8.4% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $1,200,000 $1 $1,000,000 $1 $800,000 $600,000$1 July YTD Expenditures Series1 $400,000$1 Annual Expenditures * Series2 $200,000$0 $0$0 $0 13-14 14-15 15-16 16-17 17-18 Public Safety expenditures include costs of Police, Fire and Emergency Management. Citywide public safety expenditures through July are 7.6% higher than the same period in the prior fiscal year. The budgeted increase for fiscal year 2017-18 over fiscal year 2016-17 actuals is 13.7%. 6 July Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Transportation 13-14 14-15 15-16 16-17 17-18 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 181,383 573,025 31.7% 191,924 582,486 32.9% 38,152 609,990 6.3% 38,922 642,850 6.1% 72,350 705,273 10.3% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action Transportation Community Development $1 $800,000 $700,000 $1 $600,000 $1 $500,000 $1 $400,000 Series1 July YTD Expenditures $300,000 $0 $200,000 $0 $100,000 $0 $0 Annual Series2 Expenditures * 13-14 14-15 15-16 16-17 17-18 Transportation expenditures include costs for Street lighting, maintenance and repair; Aviation and Public Transit. Citywide transportation expenditures are 85.9% higher through July than the same period in the prior fiscal year. The budgeted increase for fiscal year 2017-18 over fiscal year 2016-17 actuals is 9.7%. Community Development 13-14 14-15 15-16 16-17 17-18 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 19,937 194,542 10.2% 19,277 188,670 10.2% 17,152 174,956 9.8% 15,747 188,365 8.4% 16,073 235,949 6.8% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected CommunityDevelopment Enrichment Community $1 $250,000 $1 $200,000 $1 $150,000 $1 July YTD Series1 Expenditures $100,000 $0 Series2 Annual Expenditures * $0 $50,000 $0 $0 13-14 14-15 15-16 16-17 17-18 Community Development expenditures include costs for Neighborhood Services, Housing, Planning and Economic Development. Citywide community development expenditures are better than expected with an increase through July of 2.1% over the same period in the prior fiscal year. The fiscal year 2017-18 budget includes an increase of 25.3% over fiscal year 2016-17 actuals. 7 July Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Community Enrichment 13-14 14-15 15-16 16-17 17-18 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 25,840 272,326 9.5% 24,216 259,944 9.3% 26,092 273,179 9.6% 25,661 292,983 8.8% 29,998 308,665 9.7% * - For prior years-total actual expenditures, for current year-total approved budget Community Enrichment $350,000 $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 $0 July YTD Expenditures Annual Expenditures * 13-14 14-15 15-16 16-17 17-18 Monitor and Consider Taking Action Community Enrichment expenditures include costs for Parks, Libraries, the Convention Center, Senior Centers and Community Centers. Citywide community enrichment expenditures through July are 16.9% higher than the same period in the prior fiscal year. The budgeted increase for fiscal year 2017-18 over fiscal year 2016-17 actuals is 5.4%. Environmental Services 13-14 14-15 15-16 16-17 17-18 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 47,970 577,118 8.3% 50,125 545,198 9.2% 45,832 555,711 8.2% 58,640 599,837 9.8% 59,647 640,366 9.3% * - For prior years-total actual expenditures, for current year-total approved budget Community Enrichment $700,000 $600,000 July YTD Expenditures $500,000 $400,000 $300,000 Annual Expenditures * $200,000 $100,000 $0 13-14 14-15 15-16 16-17 17-18 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 1.7% higher through July than the same period in the prior fiscal year. The budgeted increase for fiscal year 2017-18 over fiscal year 2016-17 actuals is 6.8%. 8 July Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 General Obligation Debt Service 13-14 14-15 15-16 16-17 17-18 July YTD Annual % of Annual Expenditures Expenditures * Expenditures 8,399 100,524 8.4% 11,166 134,594 8.3% 12,724 154,710 8.2% 11,465 137,205 8.4% 9,054 106,552 8.5% * - For prior years-total actual expenditures, for current year-total approved budget net of credit for early redemption fund resources Monitor and Consider Taking Action General Obligation Debt Service Total Citywide $180,000 $180,000 $160,000 $160,000 $140,000 $140,000 $120,000 $120,000 $100,000 $100,000 $80,000 $80,000 $60,000 $60,000 $40,000 $40,000 $20,000 $20,000 $0 $013-14 JulyYTD YTD July Expenditures Expenditures Annual Expenditures * Annual Expenditures * 14-15 13-14 15-16 16-17 17-18 14-15 15-16 General obligation debt service expenditures through July are 21.0% lower than the same period in the prior fiscal year. Budgeted expenditures for fiscal year 201718 are 22.3% lower than fiscal year 2016-17 actual expenditures for the prior fiscal year. -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) 14-15 13-14 General Gov't $ 263,112 $ 244,107 Refer to detailed financial schedules pages 22 - 34 15-16 16-17 17-18 (Budget) $ 238,739 $ 315,502 $ 586,364 Discussion: 17-18 (YTD) $ 22,918 General Gov't Major projects in fiscal year 2013-14 include technology acquisitions for E-Procurement and Regional Wireless Communications ($21 million), street projects ($67 million), and Police PACE Upgrade/Replacement ($12 million). 17-18 (YTD) 17-18 (Budget) 16-17 Major projects in fiscal year 2014-15 include bus purchases ($43 million), major street projects ($40 million including Avenida Rio Salado - $15 million and Broadway Rd Corridor - $10 million), local and collector street improvements ($37 million), transit south facility upgrades ($21 million), parks and recreation facility improvements ($18 million), and regional wireless cooperative ($18 million). 15-16 14-15 13-14 $0 $200,000 $400,000 $600,000 $800,000 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). 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). Major projects budgeted for fiscal year 2017-18 include street construction ($80 million), parks and recreation facility improvements ($76 million), street and sidewalk maintenance and repair ($48 million), purchase of transit buses ($34 million) and replacement of the City telephone system ($33 million). 14-15 13-14 Aviation $ 180,571 $ 259,616 15-16 16-17 17-18 (Budget) 17-18 (YTD) $ 522,633 $ 151,957 $ 681,775 $ 122,604 Discussion: Aviation In fiscal year 2014-15 major projects included $122 million for Terminal Development Concept Design and Construction, $14 million for terminal four improvements, and $13 million for airfield reconstruction and rehabilitation. Aviation capital expenditures also include $87 million in debt service. 17-18 (YTD) 17-18 (Budget) 16-17 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). 15-16 14-15 13-14 $0 $200,000 $400,000 $600,000 $800,000 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 budgeted in fiscal year 2017-18 include PHX Sky Train phase 2 ($445 million), terminal 4 south 1 concourse ($33 million), and runway, taxiway and apron reconstruction ($32 million). - 10 - Capital Expenditures (Dollars in Thousands) 14-15 13-14 Phx Convention Ctr $ 23,189 Refer to detailed financial schedules pages 22 - 34 $ 24,633 15-16 $ 17-18 (Budget) 16-17 24,554 Discussion: $ 21,885 $ 29,416 17-18 (YTD) $ 1,894 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 $22.5 million for fiscal year 2017-18. 17-18 (YTD) 17-18 (Budget) 16-17 15-16 14-15 13-14 $0 13-14 $ Solid Waste 8,063 14-15 $ 22,832 15-16 $ $10,000 17-18 (Budget) 16-17 8,781 $ 7,460 $20,000 $ 29,952 $30,000 $40,000 17-18 (YTD) $ 19 Discussion: Solid Waste In fiscal year 2013-14, projects included $3.5 million for methane gas systems at closed landfills and $3 million for a park in Buckeye as part of the intergovernmental agreement for the Buckeye landfill. 17-18 (YTD) 17-18 (Budget) 16-17 In fiscal year 2014-15 Solid Waste spent $16 million for the 27th avenue composting facility and $6 million for the SR85 landfill. 15-16 14-15 13-14 $0 $10,000 $20,000 $30,000 $40,000 In fiscal year 2015-16, Solid Waste spent $2.5 million on the 27th Ave Resource Innovation Campus. 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. Major projects budgeted for fiscal year 2017-18 include 27th Avenue facilities ($12 million), and SR85 Landfill requirements ($11 million). - 11 - Capital Expenditures (Dollars in Thousands) 13-14 Wastewater $ 58,012 Refer to detailed financial schedules pages 22 - 34 14-15 $ 39,880 15-16 $ 16-17 42,084 $ Discussion: 106,776 17-18 (Budget) $ 189,382 17-18 (YTD) $ 1,791 Wastewater In fiscal year 2014-15 Wastewater spent $19 million on mains and lines, most of which is for rehabilitation or replacement. Wastewater also spent $9 million for projects related to the 91st Avenue Wastewater Treatment Plant and SROG. 17-18 (YTD) 17-18 (Budget) 16-17 In fiscal year 2015-16 Wastewater spent $18 million on rehabilitation and replacement of sewer mains and lines and an additional $16 million on capital improvements at the wastewater treatment facilities. 15-16 14-15 In fiscal year 2016-17, Wastewater spent $30 million to construct, replace or rehabilitate pipelines, $25 million for the construction of the biogas project at the 91st Avenue Wastewater Treatment Plant, $16 million for improvements at the 91st Avenue wastewater treatment plant, and $10 million for improvements at the 23rd Avenue wastewater treatment plant. 13-14 $0 $50,000 $100,000 $150,000 $200,000 Major projects budgeted for fiscal year 2017-18 include sewer mains and lines ($113 million), improvements at the 91st Ave WWTP ($26 million), and improvements at the 23rd Ave WWTP ($12 million). Water System 13-14 14-15 $ 129,080 $ 117,196 15-16 $ 99,091 16-17 $ 189,809 17-18 (Budget) $ 297,065 17-18 (YTD) $ 31,834 Discussion: Water System Major projects in fiscal year 2013-14 include construction of a new 20 million gallon concrete reservoir at Deer Valley WTP ($16 million). 17-18 (YTD) 17-18 (Budget) Major projects in fiscal year 2014-15 include $9 million for rehabilitation at the 24th Street water treatment plant and $24 million for improvements to the solids handling facility at the Union Hills water treatment plant. The water system also spent nearly $34 million on mains and lines, most of which is for rehabilitation or replacement. 16-17 15-16 14-15 13-14 $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. Major projects budgeted for fiscal year 2017-18 include water mains and lines ($123 million), water resiliency and storage ($37 million), and groundwater well projects ($25 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,200,000 $1,000,000 July YTD Revenues $800,000 $600,000 $400,000 Annual Revenues* $200,000 $0 13-14 13-14 14-15 15-16 16-17 17-18 July YTD Revenues 72,193 73,562 66,172 60,266 48,335 Annual Revenues* 1,026,167 1,048,053 1,063,211 1,094,933 1,129,627 14-15 15-16 16-17 17-18 % of Annual Revenues 7.0% 7.0% 6.2% 5.5% 4.3% * - For prior years - total actual revenues, for current year - total approved budget Monitor and Consider Taking Action Fiscal year 2017-18 general fund operating revenues are budgeted to increase 3.2% over prior year actuals. Actual revenues through July are 19.8% lower than the same period in the prior fiscal year. Specific revenue sources are discussed on the following pages. - 13 - Property Taxes (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Property Taxes Primary & Secondary 300,000 250,000 Secondary 200,000 150,000 91,021 35,204 49,567 50,484 143,931 138,243 141,310 146,121 13-14 14-15 15-16 16-17 100,000 50,000 Primary (50,000) FY 13-14 14-15 15-16 16-17 17-18 17-18 budget Total 179,136 187,811 191,793 237,142 (1,055) 248,118 July (1,260) (1,107) (981) (1,004) (1,055) (1,244) Aug 971 760 641 454 746 Sept 867 816 857 773 984 Oct 11,107 12,338 15,224 12,067 15,943 Nov 46,645 63,660 60,232 57,953 73,157 Dec 32,028 18,028 21,975 51,488 36,807 17-18 Jan 7,180 8,869 8,268 10,013 10,922 Feb 3,818 2,958 3,815 4,033 4,347 17-18 budget Mar 5,668 5,135 5,779 6,593 7,043 Apr 7,300 9,411 9,409 12,231 12,492 May 44,562 45,939 42,177 60,943 59,967 June 20,250 21,004 24,397 21,598 26,954 Note: Monthly budget amount for 17-18 is the average % of last 3 years of the total budget amount Expected Because property taxes are primarily collected in November, December, May and June, a monthly breakdown of the revenues is not particularly useful, therefore the chart for property tax revenues is presented with an annual perspective. Total property tax revenues are budgeted to increase 4.6% in fiscal year 2017-18 over fiscal year 2016-17 actuals. - 14 - Primary Secondary 143,931 35,204 138,243 49,567 141,310 50,484 146,121 91,021 (729) (325) 153,454 94,664 Local Sales Tax (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Local Sales Tax Budget vs Actual 45,000 40,000 35,000 30,000 25,000 17-18 Actuals 20,000 17-18 budget 15,000 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Monitor and Consider Taking Action The fiscal year 2017-18 budget includes an increase of 4.0% in local sales tax revenues over fiscal year 2016-17 actuals. Beginning in January 2017, local sales tax returns and payments were no longer sent to the City, but were instead collected and processed by the State. This created a delay in the posting of sales taxes to the City. The delay is evident in the lower sales tax revenues for July 2017 as compared to July 2016. This is a timing difference and will be accounted for at fiscal year-end so that the total revenues for the fiscal year will reflect actual sales activity for the year, however, the delay in posting revenues will be evident in the year over year comparisons for this report until we have a complete year of collections by the State. Local Sales Tax 3 Year Trend 60,000 50,000 40,000 15-16 Actuals 16-17 Actuals 30,000 17-18 Actuals 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2016-17 local sales tax revenues are 1.9% higher than the prior year. Fiscal year 2015-16 local sales tax revenues exceeded fiscal year 2014-15 revenues by 0.1%. Fiscal year 201415 local sales tax revenues exceeded fiscal year 2013-14 revenues by 0.4%. Click Here for Additional Information - 15 - State Sales Tax (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 State Sales Tax Budget vs Actual 16,000 14,000 12,000 10,000 17-18 Actuals 17-18 budget 8,000 6,000 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Monitor and Consider Taking Action The fiscal year 2017-18 budget includes an increase of 3.5% in state shared sales tax over fiscal year 2016-17 actuals. Through July, state shared sales tax revenues are 2.3% below budget expectations. State Sales Tax 3 Year Trend 16,000 14,000 12,000 10,000 15-16 Actuals 8,000 16-17 Actuals 6,000 17-18 Actuals 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2015-16 state shared sales tax revenues were 4.0% higher than fiscal year 2014-15 which were 4.1% higher than fiscal year 2013-14. Fiscal year 2016-17 state shared sales tax revenues were 4.7% higher than fiscal year 2015-16. July 2017 state shared sales tax revenues were 4.4% higher than July 2016. Click Here for Additional Information - 16 - Vehicle License Tax (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Vehicle License Tax Budget vs Actual 10,000 9,000 8,000 7,000 6,000 17-18 Actuals 5,000 17-18 budget 4,000 3,000 2,000 1,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 for July 2017 are 59.9% higher than budget expectations for the period. Vehicle License Tax 3 Year Trend 10,000 8,000 15-16 Actuals 16-17 Actuals 6,000 17-18 Actuals 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June State shared vehicle license tax revenues for fiscal year 2015-16 were 8.2% higher than fiscal year 2014-15 which were 7.0% over fiscal year 2013-14. Fiscal year 2016-17 state shared vehicle license tax revenues were 3.0% higher than fiscal year 2015-16. 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 250,000.00 200,000.00 17-18 budget 150,000.00 2017-18 Actuals 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 for July 2017 are 30.9% lower than budget expectations in large part due to the timing difference for local sales tax revenues. Governmental Funds Revenues 3 Year Trend 300,000.00 250,000.00 2015-16 Actuals 200,000.00 2016-17 Actuals 150,000.00 2017-18 Actuals 100,000.00 50,000.00 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2013-14 governmental funds revenues increased by 0.1% over fiscal year 2012-13 and fiscal year 2014-15 governmental revenues decreased 0.6% from the prior year. Fiscal year 2015-16 governmental funds revenues increased 6.9% over fiscal year 2014-15. Fiscal year 2016-17 governmental funds revenues were 8.3% higher than the prior fiscal year. 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 35,000 30,000 25,000 17-18 Actuals 20,000 17-18 budget 15,000 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Monitor and Consider Taking Action Aviation operating revenues for July 2017 are 9.2% lower than budget expectations for the period. Aviation Operating Revenues 3 Year Trend 35,000 30,000 25,000 15-16 Actuals 20,000 16-17 Actuals 15,000 17-18 Actuals 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2014-15 aviation operating revenues were 3.0% higher than fiscal year 2013-14. Fiscal year 2015-16 aviation operating revenues were 1.6% higher than fiscal year 2014-15. Fiscal year 2016-17 aviation operating revenues were 2.7% higher than the prior year. Click Here for Additional Information - 19 - 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 17-18 Actuals 17-18 budget 30,000 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Better than Expected Water system revenues for July 2017 are 4.8% higher than budget expectations for the period. Water System Operating Revenues 3 Year Trend 60,000 50,000 40,000 15-16 Actuals 16-17 Actuals 30,000 17-18 Actuals 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Primarily due to the record setting rainfall received in August and September 2014 and above average rainfall in December and January, fiscal year 2014-15 revenues were 6.8% below revenues for fiscal year 2013-14. Revenues for fiscal year 2015-16 were 6.8% higher than the prior fiscal year. Fiscal year 2016-17 revenues were 5.3% higher than the prior year. Click Here for Additional Information - 20 - Wastewater Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Wastewater Operating Revenues Budget vs Actual 20,500 20,000 19,500 19,000 17-18 budget 17-18 Actuals 18,500 18,000 17,500 17,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Better than Expected Wastewater revenues for July 2017 are 1.4% above budget expectations for the period. Wastewater Operating Revenues 3 Year Trend 25,000 20,000 15-16 Actuals 15,000 16-17 Actuals 17-18 Actuals 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr Click Here for Additional Information - 21 - May June General Funds Summary Presents comparisons of year-to-date balances to the fiscal year budget and to the actual results for the prior year for the general fund. General Fund Revenue As of JULY 31 (dollars in thousands) Budget Estimate 2017-2018 Actual Year-to-Date 2017-2018 2016-2017 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 $ $ 445,511 2,290 17,068 $ 30 35,857 37 148,964 196,303 62,706 153,454 2,896 10,090 11,773 16,670 9,008 (729) 271 (2,587) 11,269 15,946 5,712 (745) 176 (2,437) 10,365 1,164 13,644 740 7,664 2,106 4,339 984 85 640 1,049 582 134 235 1,070 75 604 32 935 155 401 35,000 1,400 11,613 3,908 15,469 (8,841) 53 21 555 1,333 (11,413) 1,486 297 810 1,129,626 - 22 - $ $ 48,334 $ 60,267 General Fund Expenditures As of JULY 31 (dollars in thousands) Budget Estimate 2017-2018 Actual Year-to-Date 2017-2018 2016-2017 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 $ 1,962 4,207 2,403 38,007 2,131 2,461 20,354 2,853 4,052 10,345 3,406 23,724 2,493 118,398 Criminal Justice Municipal Court Public Defender Total Criminal Justice $ 106 $ 278 374 3,260 161 173 1,560 243 357 881 298 1,989 508 10,188 95 259 327 3,649 163 171 1,382 159 251 812 280 585 267 8,400 29,241 5,081 34,322 2,658 377 3,036 2,177 58 2,235 548,803 298,471 83 847,357 50,970 24,502 23 75,495 48,293 21,215 8 69,516 Transportation Street Transportation Public Transit Total Transportation 18,836 1,713 20,549 8,686 8,686 1,571 1,571 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 5,091 13,281 4,157 54 22,583 339 1,064 356 4 1,763 307 769 267 4 1,347 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 90,983 38,796 19,141 6,338 155,258 10,216 3,554 1,065 2,348 17,183 9,513 2,796 857 1,440 14,606 Environmental Services Public Works Environmental Programs Total Environmental Services 13,112 619 13,731 1,322 40 1,362 1,621 50 1,671 9,642 531 274 - - 118,244 $ 99,620 Public Safety Police Fire Others Total Public Safety Capital Improvement Contingencies Total Expenditures and Encumbrances 55,900 $ 1,277,740 - 23 - $ Citywide Summary Presents the City's summarized comparisons of the year-to-date balances to the fiscal year budget and to the actual results for the prior year. Citywide Operating Revenue As of JULY 31 (dollars in thousands) Source General Funds Local Taxes: Sales Taxes Privilege License Fees State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax Primary Property Tax Licenses and Permits Cable Communications Municipal Court Police Library Fees Parks and Recreation Planning & Development Street Transportation Fire Interest Other Fees and Service Charges Budget Estimate 2017-2018 $ Total General Funds 445,511 2,290 $ $ 17,068 $ 30 $ 35,857 37 148,964 196,303 62,706 153,454 2,896 10,090 11,529 13,644 740 7,664 2,106 4,339 48,013 3,908 15,469 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 11,773 16,670 9,008 (729) 271 (2,587) 1,069 640 1,049 582 134 235 (8,767) 555 1,333 11,269 15,946 5,712 (745) 176 (2,437) 1,145 604 32 935 155 401 (9,926) 297 810 1,129,627 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 31,694 88,995 31,853 5,942 262,077 4,847 53,949 11,076 28,087 128,181 38,215 5,092 48,168 277,541 99,401 Total Special Revenue and Debt Service Funds 344,541 73,179 420,570 229,962 148,669 Total Enterprise Funds $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 3,461,667 - 24 - 1,183 2,941 1,223 150 11,665 708 10,147 140 798 10,341 2,630 1,105 3,562 3,857 (283) 60,266 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 50,166 $ $ $ $ $ 1,216,922 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 48,335 1,115,118 Enterprise Funds Aviation Convention Center Water System Wastewater Solid Waste Total Operating Revenues Actual Year-to-Date 2017-2018 2016-2017 $ 26,403 3,410 54,624 18,615 13,749 2,415 7,186 2,441 249 18,380 10,129 997 1,184 9,261 6,973 985 2,089 3,298 (260) 65,327 $ $ $ $ $ 28,314 4,576 50,220 18,836 12,379 116,801 114,325 215,303 $ 239,918 Citywide Operating Expenditures As of JULY 31 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2017-2018 2016-2017 Budget 2017-2018 10,188 $ 1,025 11,213 8,400 48 8,448 34,322 12,272 46,594 3,035 639 3,674 2,235 844 3,079 847,357 185,253 1,032,610 75,495 11,264 86,759 69,516 11,114 80,630 Transportation General Funds Other Funds Total Transportation 20,548 684,725 705,273 8,686 63,664 72,350 1,571 37,351 38,922 Community Development General Funds Other Funds Total Community Development 22,583 213,366 235,949 1,763 14,310 16,073 1,347 14,399 15,746 Community Enrichment General Funds Other Funds Total Community Enrichment 155,258 153,407 308,665 17,183 12,815 29,998 14,606 11,055 25,661 Environmental Services General Funds Other Funds Total Environmental Services 13,731 626,635 640,366 1,362 58,285 59,647 1,671 56,969 58,640 Debt Service General Funds Other Funds Total Debt Service 106,552 106,552 9,054 9,054 11,465 11,465 Capital Improvement General Funds Other Funds Total Capital Improvement 9,642 726,605 736,247 531 41,446 41,977 274 34,369 34,643 Contingencies General Funds Other Funds Total Contingencies 55,900 47,500 103,400 - - $ Criminal Justice General Funds Other Funds Total Criminal Justice Public Safety General Funds Other Funds Total Public Safety Total Operating General Funds Other Funds Total Operating Budget $ 118,398 29,259 147,657 1,277,739 2,785,574 4,063,313 - 25 - $ $ 118,243 212,502 330,745 $ 99,620 177,614 277,234 Citywide Detail Presents, in detail, the results of the City's operations for the current month and for the fiscal year-to-date. Included are breakdowns of the City's revenues, operating budget expenditures, capital budget expenditures and bonds authorized and sold. Citywide Operating Revenue by Source For the Month Ended JULY 31 2017 2016 Budget Estimate 2017-2018 Source Actual Year-to-Date 2017-2018 2016-2017 General Funds $ 17,068,202 30,137 $ 35,856,961 36,808 Local Taxes: Sales Taxes Privilege License Fees $ 445,511,000 2,290,000 $ 17,068,202 30,137 $ 35,856,961 36,808 35,893,769 Total Local Taxes 447,801,000 17,098,339 35,893,769 11,773,000 16,669,602 9,007,719 11,269,000 15,945,590 5,711,672 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 148,964,000 196,303,000 62,706,000 11,773,000 16,669,602 9,007,719 11,269,000 15,945,590 5,711,672 37,450,321 32,926,262 407,973,000 37,450,321 32,926,262 17,098,339 Total State Shared Taxes (729,466) (744,620) Primary Property Tax 153,454,000 271,362 175,894 Licenses and Permits 2,896,000 (2,586,875) (729,466) 271,362 175,894 (2,436,844) Cable Communications 10,090,000 984,400 84,668 1,070,489 74,699 Municipal Court: Fines and Forfeitures Court Default Fee 10,364,925 1,164,000 984,400 84,668 1,070,489 74,699 1,069,068 1,145,188 11,528,925 1,069,068 1,145,188 640,138 603,804 13,644,495 640,138 603,804 Total Municipal Court Police (2,436,844) 1,048,878 31,574 740,110 1,048,878 31,574 582,463 934,730 Parks and Recreation 7,664,381 582,463 934,730 134,375 154,541 Planning and Development 2,106,481 134,375 154,541 235,102 400,950 Street Transportation 4,339,350 235,102 400,950 (8,840,561) 52,850 20,579 (11,412,869) 50,400 1,435,979 (8,767,132) (9,926,490) Library Fees (2,586,875) (744,620) Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire 555,475 297,150 Interest 1,333,282 809,898 Other Fees and Service Charges 48,335,330 60,265,806 Total General Funds 26 35,000,000 1,400,000 11,612,884 (8,840,561) 52,850 20,579 (11,412,869) 50,400 1,435,979 48,012,884 (8,767,132) (9,926,490) 3,908,000 555,475 297,150 15,468,866 1,333,282 809,898 1,129,627,492 48,335,330 60,265,806 Citywide Operating Revenue by Source (continued) For the Month Ended JULY 31 2017 2016 Budget Estimate 2017-2018 Source Actual Year-to-Date 2017-2018 2016-2017 Special Revenue and Debt Service Funds $ 811,698 57,979 289,892 23,841 $ 2,414,635 1,183,410 2,231,811 694,586 14,144 1,680,580 120,041 600,207 13,807 $ $ $ 5,317,869 1,865,310 2,510 1,223,112 $ 2,440,673 73,397 0 58,252 153 17,762 $ $ $ $ $ 102,929 0 114,777 227 30,613 2,940,541 7,185,689 248,546 149,564 7,920,679 3,744,236 $ $ 11,664,915 16,086,823 2,293,393 18,380,216 708,000 $ 0 10,146,516 $ 10,128,848 139,808 $ 997,079 760,828 37,377 $ $ 1,164,988 18,962 798,205 1,183,950 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other $ Total Neighborhood Protection Public Safety Enhancement & Expansion Police Fire Interest/Other Total Public Safety Enhancement & Expansion Parks and Preserves Golf Courses: Fees Coffee Shops Concessions Interest Other Total Golf Courses Transit 2000 & 2050: Sales Taxes Interest/Other Total Transit 2000 & 2050 Court Awards 21,930,000 1,567,000 7,832,000 365,000 $ 811,698 57,979 289,892 23,841 $ 1,680,580 120,041 600,207 13,807 31,694,000 1,183,410 2,414,635 66,423,000 22,518,000 54,000 2,231,811 694,586 14,144 5,317,869 1,865,310 2,510 88,995,000 2,940,541 7,185,689 31,853,000 1,223,112 2,440,673 3,552,200 0 2,172,725 (2,000) 219,275 73,397 0 58,252 153 17,762 102,929 0 114,777 227 30,613 5,942,200 149,564 248,546 210,700,000 51,376,890 7,920,679 3,744,236 16,086,823 2,293,393 262,076,890 11,664,915 18,380,216 4,847,340 708,000 0 Planning and Development 53,948,800 10,146,516 10,128,848 Capital Construction 11,076,000 139,808 997,079 Sports Facilities: Sales Taxes Interest/Other 19,235,000 8,852,016 760,828 37,377 1,164,988 18,962 28,087,016 798,205 1,183,950 Total Sports Facilities 27 Citywide Operating Revenue by Source (continued) For the Month Ended JULY 31 2017 2016 Budget Estimate 2017-2018 Source Actual Year-to-Date 2017-2018 2016-2017 Special Revenue and Debt Service Funds (Cont'd) $ 10,240,000 94,312 6,400 9,214,000 46,793 0 10,340,712 9,260,793 - $ - Highway User Revenue: Highway User Revenue Interest Other Total Highway User Revenue Local Transportation Assistance 10,240,000 94,312 6,400 9,214,000 46,793 0 128,181,000 10,340,712 9,260,793 0 0 0 38,214,960 2,630,385 6,973,125 5,091,810 1,105,218 985,248 48,167,904 3,562,091 2,089,406 7,274,000 81,683,028 8,694,844 549,835 5,558,653 454,057 619,310 4,881,068 105,198 97,651,872 6,562,545 5,605,576 46,031,773 53,696,411 30,138,429 50,022,756 (1,954,552) 1 (4,864,006) 4,112,865 11,145 0 216,206 (2,534,720) 2,630,385 6,973,125 1,105,218 985,248 3,562,091 2,089,406 Other Restricted Fees 549,835 5,558,653 454,057 619,310 4,881,068 105,198 Grants: Public Housing: Rentals Grants Other 6,562,545 5,605,576 (1,954,552) 1 (4,864,006) 4,112,865 11,145 0 216,206 (2,534,720) (2,705,692) (2,307,369) Total Other 179,889,369 (2,705,692) (2,307,369) 3,856,853 3,298,207 Total Grants 277,541,241 3,856,853 3,298,207 (325,045) 42,046 (259,803) 0 (282,999) (259,803) 50,166,331 65,326,612 Regional Transit Revenues 127,531,000 500,000 150,000 Community Reinvestment $ 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 94,663,937 4,736,652 (325,045) 42,046 (259,803) 0 99,400,589 (282,999) (259,803) 1,115,117,750 50,166,331 65,326,612 137,700,000 195,960,000 1,500,000 4,262,700 2,142,000 2,976,500 0 8,767,016 16,659,954 190,289 214,455 214,666 253,650 103,101 8,446,685 18,839,642 158,779 341,797 200,134 247,084 80,144 344,541,200 26,403,131 28,314,265 Enterprise Funds AVIATION: 8,767,016 16,659,954 190,289 214,455 214,666 253,650 103,101 8,446,685 18,839,642 158,779 341,797 200,134 247,084 80,144 26,403,131 28,314,265 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge Total Aviation 28 Citywide Operating Revenue by Source (continued) For the Month Ended JULY 31 2017 2016 Budget Estimate 2017-2018 Source Actual Year-to-Date 2017-2018 2016-2017 Enterprise Funds (Cont'd) CONVENTION CENTER: $ 1,553,651 1,810,884 45,086 3,496,057 1,046,747 32,994 3,409,621 4,575,798 Excise Taxes Operating Revenue Interest Total Convention Center 51,897,000 20,958,163 323,835 1,553,651 1,810,884 45,086 3,496,057 1,046,747 32,994 73,178,998 3,409,621 4,575,798 396,920,000 5,800,000 4,270,000 6,168,000 3,600,000 2,279,000 1,533,000 50,602,226 527,756 424,286 71,422 224,700 225,046 2,548,175 48,402,655 363,900 931,414 562,172 133,260 165,297 (338,379) 420,570,000 54,623,611 50,220,319 195,418,000 17,259,000 3,600,000 1,664,000 12,021,000 16,587,466 209,700 280,850 1,537,293 15,637,246 1,809,000 128,220 142,971 1,118,823 229,962,000 18,615,309 18,836,260 130,245,000 8,300,000 625,000 9,499,411 10,849,117 726,375 57,209 2,116,626 10,774,496 678,774 54,920 870,561 148,669,411 13,749,327 12,378,751 1,216,921,609 116,800,999 114,325,393 WATER SYSTEM: $ 50,602,226 527,756 424,286 71,422 224,700 225,046 2,548,175 48,402,655 363,900 931,414 562,172 133,260 165,297 (338,379) 54,623,611 50,220,319 Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System WASTEWATER: 16,587,466 0 209,700 280,850 1,537,293 15,637,246 1,809,000 128,220 142,971 1,118,823 18,615,309 18,836,260 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: $ 10,849,117 726,375 57,209 2,116,626 10,774,496 678,774 54,920 870,561 13,749,327 12,378,751 116,800,999 114,325,393 215,302,660 $ 239,917,811 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ 29 3,461,666,851 $ 215,302,660 $ 239,917,811 Citywide Operating Expenditures by Program For the Month Ended JULY 31 2017 2016 Program Budget Estimate 2017-2018 Actual Year-to-Date 2017-2018 2016-2017 2017-2018 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt General Government $ 106,432 $ 277,627 402,127 4,287,146 52,042 240,727 214,505 1,716,016 242,585 357,422 236,819 956,458 62,012 28,608 148,361 8,422 298,439 2,355,765 (778,271) 11,213,242 94,524 259,137 349,697 3,869,100 53,482 185,142 199,942 1,465,683 159,323 250,905 596 924,607 66,224 53,825 138,744 7,555 279,503 893,687 (803,669) 8,448,007 Mayor $ City Council City Manager Information Technology Se Government Relations Public Information Equal Opportunity Law City Auditor City Clerk Elections Human Resources Manager's Office of Susta Phx Community Developm Retirement Systems Phoenix Employment Rela Budget and Research Finance Regional Wireless Cooper 1,962,000 4,206,557 2,649,769 40,659,681 1,091,364 2,489,595 2,970,071 21,746,360 2,853,214 4,052,636 874,421 11,692,734 431,816 910,943 95,825 3,501,309 40,840,799 4,628,072 $ 106,432 277,627 402,127 4,287,146 52,042 240,727 214,505 1,716,016 242,585 357,422 236,819 956,458 62,012 28,608 148,361 8,422 298,439 2,355,765 (778,271) $ 94,524 259,137 349,697 3,869,100 53,482 185,142 199,942 1,465,683 159,323 250,905 596 924,607 66,224 53,825 138,744 7,555 279,503 893,687 (803,669) $ 106,432 277,627 402,127 3,310,423 52,042 240,727 214,505 1,716,016 242,585 357,422 236,819 897,999 62,012 28,608 148,361 8,422 298,439 2,212,235 (778,271) 976,722 58,459 143,530 - Total General Governme 147,657,166 11,213,242 8,448,007 10,034,529 1,178,711 41,513,195 5,080,998 - 3,296,589 377,133 - 3,021,322 57,689 - 2,949,037 377,133 - 347,552 - 46,594,193 3,673,722 3,079,011 3,326,170 347,552 677,593,110 353,985,691 1,031,393 58,212,304 28,469,866 76,380 55,603,380 24,952,328 74,291 57,997,408 28,113,406 76,380 214,896 356,460 - 1,032,610,194 86,758,550 80,629,999 86,187,194 571,356 Criminal Justice 3,296,589 377,133 - 3,021,322 57,689 - 3,673,722 3,079,011 Municipal Court Public Defender Other Total Criminal Justice Public Safety 58,212,304 28,469,866 76,380 55,603,380 24,952,328 74,291 86,758,550 80,629,999 Police Fire Other Total Public Safety -30 - Citywide Operating Expenditures by Program (continued) For the Month Ended JULY 31 2017 2016 Budget Estimate 2017-2018 Program Actual Year-to-Date 2017-2018 2016-2017 2017-2018 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Transportation $ 9,486,191 920,881 22,193,663 39,749,330 72,350,065 $ 5,167,339 864,062 24,112,401 8,778,073 38,921,875 Street Transportation Street Lighting Aviation Public Transit $ Total Transportation 84,034,896 (267,849) 310,554,884 310,950,911 $ 9,486,191 920,881 22,193,663 39,749,330 $ 5,167,339 864,062 24,112,401 8,778,073 $ 9,330,425 920,881 17,459,563 33,350,315 155,766 4,734,100 6,399,016 705,272,842 72,350,065 38,921,875 61,061,184 11,288,882 Community Development 4,022,603 8,060,435 1,656,813 2,333,052 3,387,720 8,728,839 1,616,670 2,013,275 Planning and Developmen Housing Economic Development Neighborhood Services De 60,933,593 95,454,581 29,490,369 50,070,115 4,022,603 8,060,435 1,656,813 2,333,052 3,387,720 8,728,839 1,616,670 2,013,275 4,022,603 8,054,363 1,360,248 2,333,052 6,072 296,564 - 16,072,903 15,746,504 Total Community Develo 235,948,658 16,072,903 15,746,504 15,770,267 302,636 Community Enrichment 11,079,304 3,600,675 300,449 5,587,709 984,273 4,558,410 2,934,549 952,311 10,098,791 2,830,254 493,222 4,048,320 1,008,427 5,078,200 991,205 1,112,653 Parks and Recreation Library Golf Convention Center Sports and Cultural Faciliti Human Services Public Parking Facilities Other 101,451,405 39,691,235 5,842,725 64,815,039 20,325,455 67,056,229 5,055,056 4,427,907 11,079,304 3,600,675 300,449 5,587,709 984,273 4,558,410 2,934,549 952,311 10,098,791 2,830,254 493,222 4,048,320 1,008,427 5,078,200 991,205 1,112,653 11,046,630 3,600,675 300,449 3,925,672 4,506,178 2,934,549 952,311 32,675 1,662,037 984,273 52,232 - 29,997,680 25,661,072 Total Community Enrich 308,665,051 29,997,680 25,661,072 27,266,464 2,731,217 -31 - Citywide Operating Expenditures by Program (continued) For the Month Ended JULY 31 2017 2016 Program Budget Estimate 2017-2018 Actual Year-to-Date 2017-2018 2016-2017 2017-2018 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Environmental Services $ 30,708,126 15,909,420 11,159,084 1,756,738 113,228 59,646,596 $ 25,218,330 14,600,034 16,426,966 2,294,245 100,392 58,639,967 Water System $ Wastewater Solid Waste Management Public Works Environmental Programs 325,460,179 150,257,662 141,731,658 21,558,832 1,357,601 Total Environmental Ser 640,365,932 $ 30,708,126 15,909,420 11,159,084 1,756,738 113,228 $ 25,218,330 14,600,034 16,426,966 2,294,245 100,392 $ 21,581,801 10,233,974 10,531,700 1,324,072 113,228 9,126,325 5,675,446 627,385 432,667 15,861,822 59,646,596 58,639,967 43,784,775 197,050 11,189,557 15,332,937 772,171 4,419,759 334,975 12,294,133 1,753,652 6,521,098 6,360,557 615,772 14,208,780 300 5,936,530 4,084,483 2,175,932 651,286 1,394,725 12,758,866 5,025,597 6,150 517,929 - 16,421 949,715 1,277,745 64,348 368,313 27,915 1,024,511 146,138 788,393 401,878 51,314 1,125,870 25 494,711 340,374 151,436 187,925 173,848 1,001,065 418,800 513 43,161 16,421 1,292,609 2,362,056 69,263 377,390 28,508 1,113,166 173,095 587,335 536,322 106,581 1,141,993 32,525 574,148 443,902 180,849 6,000 115,327 1,330,649 423,786 513 552,718 16,421 949,715 1,277,745 64,348 368,313 27,915 1,024,511 146,138 788,393 401,878 51,314 1,125,870 25 494,711 340,374 151,436 187,925 173,848 1,001,065 418,800 513 43,161 - 9,054,416 - General Obligation Debt Service 16,421 949,715 1,277,745 64,348 368,313 27,915 1,024,511 146,138 788,393 401,878 51,314 1,125,870 25 494,711 340,374 151,436 187,925 173,848 1,001,065 418,800 513 43,161 16,421 1,292,609 2,362,056 69,263 377,390 28,508 1,113,166 173,095 587,335 536,322 106,581 1,141,993 32,525 574,148 443,902 180,849 6,000 115,327 1,330,649 423,786 513 552,718 9,054,419 11,465,156 Total Debt Service 106,552,239 9,054,419 11,465,156 41,977,091 34,642,874 Capital Improvement 736,246,953 41,977,091 34,642,874 $ 330,744,268 277,234,465 Aviation Civic Plaza Cultural Facilities Downtown Development Early Redemption Economic Development Fire Protection Freeway Mitigation Historic/Neighborhood Pre Human Services Information Systems Libraries Maintenance Service Cent Mountain Preserves/Parks MEGA Real Estate Municipal Administration B Police Protection Public Housing Renovation Public Housing Sanitary Sewers Secondary Property Tax Solid Waste Enterprise Bo Storm Sewer Improvemen Street Improvements Street Light Refinancing Public Transit Water System Contingencies 103,400,000 - 4,063,313,228 330,744,268 -32 - 277,234,465 256,484,998 32,282,176 Capital Expenditures and Encumbrances 2016-2017 Actual Yearto-Date 2017-2018 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 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 Actual Yearto-Date Budget $ 1,057,899 $ 9,652,500 1,200,000 21,182,125 1,647,511 17,361,537 924,988 23,626,766 600,000 57,679,245 1,778,939 4,409,052 75,883,228 84,699,646 7,275,852 7,607,558 269,777,585 98 $ 7,312 203,195 20,489 10,000 165,596 10,771,733 15,451 20,832 5,424,798 227,008 101,199 5,950,301 13,846 129,054 14,759 59,267 109 678,291 783,772 1,489 45,264 466,405 27,599 23,124,036 1,310,757 2,045,646 $ 586,364,431 $ 22,918,012 $ 28,700,294 $ $ $ 681,775,068 29,416,250 29,951,930 189,382,112 297,065,165 1,227,590,525 $ $ 122,604,344 1,893,817 18,790 1,790,583 31,834,239 158,141,773 $ 1,813,954,956 $ 181,059,785 2017-2018 Year-to-Date Capital Amounts From Capital Funds From Operating Funds Budget Actual Budget Actual $ $ $ $ 697,503 1,729,973 82,875 746,786 2,895,690 6,152,827 $ 34,853,121 43,899 $ 9,652,500 1,200,000 9,392,125 1,126,181 6,100,000 13,639,174 12,590,579 700,000 2,175,240 54,943,888 84,699,646 168,934,463 7,312 203,195 16,025 38,448 2,225,974 1,002 18,262 5,419,351 227,008 1,261,648 365,197,695 $ 9,418,225 $ $ 108,133,092 6,917,250 22,491,000 74,523,918 158,983,998 371,049,258 $ 736,246,953 - 33 - $ $ $ $ 18,663,000 18,901 16,359 1,528,930 12,331,676 32,558,866 $ 41,977,091 1,014,000 $ 11,790,000 521,330 11,261,537 924,988 9,987,592 600,000 45,088,666 1,078,939 2,233,812 20,939,340 7,275,852 7,607,558 100,843,122 98 4,464 10,000 127,148 8,545,759 14,449 2,570 5,447 101,199 4,688,653 221,166,736 $ 13,499,787 $ $ 573,641,976 22,499,000 7,460,930 114,858,194 138,081,167 856,541,267 $ 1,077,708,003 Unencumbered Budget $ 1,057,801 9,645,188 996,805 21,161,636 1,647,511 17,361,537 914,988 23,461,170 600,000 46,907,512 1,763,488 4,388,220 70,458,430 84,699,646 7,048,844 7,506,359 263,827,284 $ 563,446,419 $ $ 103,941,344 1,874,916 2,431 261,653 19,502,563 125,582,907 $ 559,170,724 27,522,433 29,933,140 187,591,529 265,230,926 1,069,448,752 $ 139,082,694 $ 1,632,895,171 Bonds Authorized and Sold As of JULY 31 (dollars in thousands) Authorized Sold Available 1988 Authorizations General Obligation Bonds Freeway Mitigation, Neighborhood Stabilization, and Slum and Blight Elimination Bonds Fully Issued $ Total General Obligation Bonds Revenue Bonds Bonds Fully Issued Total 1988 Authorizations 29,285 884,175 $ 28,285 884,175 $ 1,000 - 913,460 912,460 1,000 143,890 143,890 - 1,057,350 1,056,350 1,000 66,300 125,300 24,800 61,500 12,000 33,000 91,500 74,000 77,000 78,800 66,000 43,700 64,600 124,685 24,170 60,700 11,205 32,100 89,275 71,645 72,575 77,685 65,950 43,700 1,700 615 630 800 795 900 2,225 2,355 4,425 1,115 50 - 753,900 738,290 15,610 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 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 $ - 34 - 2,689,750 $ 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 45,000 13-14 Actuals 14-15 Actuals 15-16 Actuals 16-17 Actuals 17-18 Actuals 40,000 35,000 30,000 25,000 20,000 15,000 July FY 13-14 14-15 15-16 16-17 17-18 Budget 17-18 Aug July 36,360 35,365 34,740 35,857 17,068 37,597 YTD thru July 36,360 35,365 34,740 35,857 17,068 37,597 Sept Oct Aug 35,589 36,414 35,137 36,805 38,025 Nov Dec Sept 35,873 35,290 35,079 34,012 37,050 Oct 35,068 34,621 35,459 38,800 38,026 Jan Nov 34,363 33,033 34,433 32,023 35,359 Feb Dec 32,474 35,062 32,783 35,135 35,783 Note: City of Phoenix revenue is budgeted on an annual basis. 2017-18 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2014-15 through FY 2016-17 actual expenditures. Return to Summary Page - A1 - Mar Jan 40,116 37,227 37,567 38,595 40,551 Apr Feb 32,084 34,432 32,793 22,766 32,248 May Mar 32,147 34,938 33,135 33,502 35,325 June Apr 35,988 37,203 36,307 28,921 36,566 May 33,165 33,049 34,236 47,647 39,123 June 34,898 33,017 38,598 44,372 39,859 State Sales Tax (Dollars in Thousands) State Sales Tax 16,000 15,000 13-14 Actuals 14-15 Actuals 15-16 Actuals 16-17 Actuals 17-18 Actuals 17-18 budget 14,000 13,000 12,000 11,000 10,000 9,000 8,000 7,000 6,000 5,000 July FY 13-14 14-15 15-16 16-17 17-18 Budget 17-18 Aug July 10,309 11,103 11,070 11,269 11,773 12,053 Sept YTD thru July 10,309 11,103 11,070 11,269 11,773 12,053 Oct Aug 9,616 9,712 10,222 11,027 11,178 Nov Sept 10,012 10,552 11,237 11,658 11,972 Dec Oct 9,923 10,307 10,688 11,195 11,601 Jan Nov 9,673 10,295 11,100 11,443 11,711 Feb Dec 10,296 10,695 11,623 11,913 12,266 Note: City of Phoenix revenue is budgeted on an annual basis. 2017-18 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2014-15 through FY 2016-17 actual expenditures. Return to Summary Page - A2 - Mar Jan 12,744 13,173 13,760 14,184 14,838 Apr May Feb 10,430 10,244 10,375 10,974 11,576 June Mar 10,506 10,861 11,139 11,785 12,201 Apr 11,285 12,265 12,975 12,900 13,616 May 10,863 11,697 11,470 12,004 12,681 June 11,350 11,314 11,886 13,622 13,270 Vehicle License Tax (Dollars in Thousands) Vehicle License Tax 10,000 13-14 Actuals 9,000 14-15 Actuals 8,000 15-16 Actuals 7,000 16-17 Actuals 6,000 17-18 Actuals 5,000 17-18 budget 4,000 3,000 2,000 July FY 13-14 14-15 15-16 16-17 17-18 Budget 17-18 Aug July 4,752 4,963 5,095 5,712 9,008 5,635 Sept YTD thru July 4,752 4,963 5,095 5,712 9,008 5,635 Oct Aug 4,663 5,004 5,133 4,393 5,270 Nov Sept 3,992 3,749 4,087 4,846 4,578 Dec Oct 3,912 4,415 4,922 5,181 5,060 Jan Nov 3,958 4,198 4,291 4,242 4,582 Feb Mar Dec 3,872 3,857 4,550 4,826 4,697 Note: City of Phoenix revenue is budgeted on an annual basis. 2017-18 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2014-15 through FY 2016-17 actual expenditures. Return to Summary Page - A3 - Apr Jan 3,936 4,661 5,195 5,607 5,326 May Feb 4,799 4,920 5,024 5,049 5,435 June Mar 4,559 4,984 5,065 5,457 5,509 Apr 3,826 4,408 5,512 5,470 5,276 May 4,643 5,108 4,943 4,938 5,391 June 4,778 5,027 5,983 5,866 5,946 Governmental Funds Revenue (Dollars in Thousands) Governmental Funds Revenue 240,100.00 2013-14 Actuals 220,100.00 2014-15 Actuals 200,100.00 2015-16 Actuals 2016-17 Actuals 180,100.00 2017-18 Actuals 160,100.00 17-18 budget 140,100.00 120,100.00 100,100.00 80,100.00 60,100.00 40,100.00 20,100.00 100.00 July FY 13-14 14-15 15-16 16-17 17-18 Budget 17-18 July 125,711 127,962 128,588 125,592 98,501 142,610 Aug YTD thru July 125,711 127,962 128,588 125,592 98,501 142,610 Sept Aug 137,320 138,394 155,197 165,819 167,452 Oct Sept 157,974 133,016 129,829 157,173 162,856 Nov Oct 143,773 155,801 160,655 165,460 175,318 Dec Nov 188,461 193,744 195,040 212,320 220,751 Jan Feb Dec 169,767 162,290 172,648 218,635 203,155 Note: City of Phoenix revenue is budgeted on an annual basis. 2017-18 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2014-15 through FY 2016-17 actual expenditures. Return to Summary Page - A4 - Mar Jan 153,911 151,099 160,567 173,436 179,104 Apr Feb 132,551 144,296 141,861 145,268 158,535 May Mar 144,892 150,768 160,707 159,366 173,392 June Apr 162,046 169,860 173,752 185,518 194,979 May 204,907 192,623 193,402 251,092 236,372 June 177,153 167,673 244,902 225,798 230,220 Aviation Revenues (Dollars in Thousands) Aviation Operating Revenues 40,000 13-14 Actuals 14-15 Actuals 35,000 15-16 Actuals 16-17 Actuals 30,000 17-18 Actuals 17-18 budget 25,000 20,000 15,000 10,000 July FY 13-14 14-15 15-16 16-17 17-18 Budget 17-18 Aug July 31,036 27,544 28,758 28,314 26,403 29,090 Sept YTD thru July 31,036 27,544 28,758 28,314 26,403 29,090 Oct Aug 22,760 26,594 27,373 29,777 26,789 Nov Sept 26,677 27,855 28,151 29,279 28,162 Dec Oct 26,505 26,489 29,050 28,339 27,765 Jan Nov 26,222 27,610 29,039 30,504 28,517 Feb Mar Dec 27,171 27,853 25,795 24,926 26,598 Note: City of Phoenix revenue is budgeted on an annual basis. 2017-18 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2014-15 through FY 2016-17 actual expenditures. Return to Summary Page - A5 - Apr Jan 26,659 27,917 28,789 28,532 28,145 May Feb 26,561 26,683 27,161 28,901 27,494 June Mar 28,352 30,414 31,530 29,273 30,075 Apr 31,467 32,304 30,759 33,162 32,118 May 29,350 29,251 29,439 32,146 30,230 June 27,200 29,272 29,507 31,531 29,557 Water System Revenues (Dollars in Thousands) Water System Operating Revenues 60,000 13-14 Actuals 14-15 Actuals 50,000 15-16 Actuals 16-17 Actuals 40,000 17-18 Actuals 17-18 budget 30,000 20,000 10,000 July FY 13-14 14-15 15-16 16-17 17-18 Budget 17-18 Aug July 49,017 50,166 47,014 50,220 54,624 52,117 Sept YTD thru July 49,017 50,166 47,014 50,220 54,624 52,117 Oct Aug 42,137 40,684 43,100 47,104 45,911 Nov Sept 41,144 36,711 42,235 43,613 43,437 Dec Oct 34,917 30,601 34,778 37,360 36,526 Jan Nov 34,774 32,130 30,252 34,083 34,823 Feb Mar Dec 22,327 24,573 24,406 26,073 25,839 Note: City of Phoenix revenue is budgeted on an annual basis. 2017-18 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2014-15 through FY 2016-17 actual expenditures. Return to Summary Page - A6 - Apr Jan 22,872 21,031 22,460 21,608 23,342 May Feb 21,185 19,044 19,179 19,223 20,864 June Mar 21,993 20,725 24,487 20,925 23,385 Apr 29,578 31,472 32,097 32,958 33,461 May 36,292 32,249 34,122 38,009 37,326 June 42,563 32,329 42,680 46,526 43,542 Wastewater Revenues (Dollars in Thousands) Wastewater Operating Revenues 22,000 13-14 Actuals 14-15 Actuals 15-16 Actuals 17,000 16-17 Actuals 17-18 Actuals 17-18 budget 12,000 7,000 2,000 July FY 13-14 14-15 15-16 16-17 17-18 Budget 17-18 Aug July 17,634 18,325 16,156 18,836 18,615 18,361 Sept YTD thru July 17,634 18,325 16,156 18,836 18,615 18,361 Oct Aug 18,252 18,520 18,477 19,359 19,308 Nov Sept 18,224 18,337 21,171 19,337 19,945 Dec Jan Oct 17,798 17,754 18,058 18,611 18,690 Nov 20,452 17,529 17,530 18,347 19,114 Feb Dec 17,763 18,276 18,697 19,493 19,210 Note: City of Phoenix revenue is budgeted on an annual basis. 2017-18 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2014-15 through FY 2016-17 actual expenditures. Return to Summary Page - A7 - Mar Apr Jan 17,618 18,183 19,384 19,155 19,239 May Feb 18,058 17,960 18,385 18,594 18,891 June Mar 14,986 17,538 18,659 19,618 18,323 Apr 18,386 18,112 21,363 19,731 20,080 May 18,299 17,762 18,555 20,233 19,370 June 16,909 18,253 19,289 20,633 19,431