August 2017 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division City of Phoenix Monthly Financial Report August 2017 Table of Contents Expenditures by Programs Page Performance Status General Fund Expenditures Report Navigation General Fund Total Expenditures 1 Expected General Government 1 Monitor and Consider Taking Action Criminal Justice 2 Better than Expected performance status in the table of contents to Public Safety 2 Better than Expected be taken directly to that page of the report. Transportation 3 Monitor and Consider Taking Action Community Development 3 Better than Expected Community Enrichment 4 Monitor and Consider Taking Action City of Phoenix Bird Emblem to return to the Environmental Services 4 Monitor and Consider Taking Action Table of Contents Click on either the schedule name or the From any page of the report, click on the Citywide Expenditures Citywide Total Operating Expenditures 5 Better than Expected General Government Criminal Justice 5 6 Monitor and Consider Taking Action Better than Expected Performance Status Public Safety 6 Better than Expected Better than Expected - Positive variance of 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 Expected 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 Page Performance Status General Fund Total Operating Revenue 13 Property Tax 14 Local Sales Tax 15 Monitor and Consider Taking Action State Sales Tax 16 Better than Expected Vehicle License Tax 17 Better than Expected Governmental Funds 18 Monitor and Consider Taking Action Monitor and Consider Taking Action Aviation 19 Better than Expected 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. August General Fund YTD Expenditures (Dollars in Thousands) Total General Fund Expenditures 13-14 14-15 15-16 16-17 17-18 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 197,973 1,042,102 19.0% 191,888 1,051,395 18.3% 203,366 1,066,521 19.1% 193,512 1,105,361 17.5% 214,974 1,221,840 17.6% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustment for contingencies. Expected Refer to detailed financial schedules pages 22 thru 34 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 August YTD Expenditures August YTD Expenditures Annual Annual Expenditures *Expenditures * $400,000 $400,000 $200,000 $200,000 $0 $0 13-14 14-15 13-14 15-16 16-17 17-18 14-15 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 August are 11.1% 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 fund expenditures have been nearly flat over the past 3 years with FY2014-15 only showing a 1.3% increase over FY2012-13. Year to date expenditures through May have increased 1.9% since FY2012-13. General Government 13-14 14-15 15-16 16-17 17-18 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 21,014 100,400 20.9% 12,838 96,385 13.3% 20,897 105,240 19.9% 16,482 106,754 15.4% 20,003 118,398 16.9% * - 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 August YTD Expenditures August YTD Expenditures $80,000 $60,000 $60,000 $40,000 $40,000 $20,000 $20,000 $0 Annual Expenditures * Annual Expenditures * 13-1414-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. The fiscal year 2017-18 budget includes a 10.9% increase over fiscal year 2016-17 actuals. General fund general government expenditures through August are 21.4% higher than the same period in the prior fiscal year. The majority of the year over year variance is due to an overcharge of purchasing expenditures to the enterprise funds in July and August of FY2016-17. The overcharge was corrected in September 2016, which should result in a year over year difference more in line with the budget expectations in the September monthly report. 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 August General Fund 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 6,243 32,659 19.1% 6,019 31,018 19.4% 7,998 30,698 26.1% 5,301 31,595 16.8% 5,668 34,322 16.5% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice $40,000 $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $5,000 $0 August YTD Expenditures Annual Expenditures * 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 August are 6.9% 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 126,065 699,796 18.0% 130,177 716,304 18.2% 129,416 737,129 17.6% 133,920 764,482 17.5% 146,896 847,357 17.3% * - For prior years-total actual expenditures, for current year-total approved budget Public Safety $1,000,000 $800,000 August 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 August, general fund public safety expenditures are 9.7% 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 August 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 8,926 29,713 30.0% 9,232 34,187 27.0% 14,625 17,473 83.7% 4,424 17,878 24.7% 5,586 20,548 27.2% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action Community Development Transportation $1 $40,000 $1 $30,000 $1 Series1 August YTD Expenditures $1 $20,000 $0 $10,000 $0 Annual Series2 Expenditures * $0 $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. Through August general fund transportation expenditures are 26.3% higher than the same period in the prior fiscal year. Personal services are budgeted to increase 8.4% over fiscal year 2016-17 actuals, however, through August personal services are 19.6% 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 13-14 14-15 15-16 16-17 17-18 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 4,074 20,210 20.2% 3,828 18,986 20.2% 3,406 18,571 18.3% 3,125 19,709 15.9% 3,516 22,583 15.6% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Community Development $25,000 August YTD Expenditures $20,000 $15,000 $10,000 Annual Expenditures * $5,000 $0 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 August are 12.5% 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 201516 and 2014-15 leaving fiscal year 2016-17 expenditures 2.5% lower than fiscal year 2013-14. 3 August General Fund 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 29,044 143,665 20.2% 25,858 138,024 18.7% 25,475 141,483 18.0% 27,208 146,749 18.5% 29,852 155,228 19.2% * - For prior years-total actual expenditures, for current year-total approved budget Community Enrichment $200,000 August YTD Expenditures $160,000 $120,000 Annual Expenditures * $80,000 $40,000 $0 13-14 14-15 15-16 16-17 17-18 Monitor and Consider Taking Action Community enrichment expenditures include costs for parks, recreational activities, senior centers and community centers. The fiscal year 2017-18 budget includes a 5.8% increase over fiscal year 2016-17 actuals. Through August, general fund community enrichment expenditures are 9.7% higher than the same period in the prior fiscal year. Over the past four years, general fund community enrichment expenditures have remained relatively flat, with fiscal year 2016-17 expenditures 2.1% higher than fiscal year 201314. Environmental Services 13-14 14-15 15-16 16-17 17-18 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 2,475 13,748 18.0% 3,598 15,082 23.9% 1,479 12,143 12.2% 2,242 12,775 17.5% 2,704 13,731 19.7% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action Environmental Services $16,000 August YTD Expenditures $12,000 $8,000 Annual Expenditures * $4,000 $0 13-14 14-15 15-16 16-17 17-18 Environmental service expenditures include costs for maintaining and operating city facilities. The fiscal year 2017-18 budget includes a 7.5% increase from fiscal year 2016-17 actuals. Through August, general fund environmental services expenditures are 20.6% higher than the same period in the prior fiscal year. Due to the work order system used to allocate public works facility maintenance costs, environmental services expenditures are highly volatile from month to month. 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. August 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 647,141 3,054,098 21.2% 643,842 3,051,875 21.1% 622,576 3,156,441 19.7% 679,730 3,468,591 19.6% 731,246 3,959,913 18.5% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustments for contingencies and use of the early redemption fund. Total Citywide $4,500,000 $4,000,000 $3,500,000 $3,000,000 $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $0 August YTD Expenditures Annual Expenditures * 13-14 14-15 15-16 16-17 17-18 Better than Expected 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 August are 7.6% higher than the same period in the prior fiscal year. General Government 13-14 14-15 15-16 16-17 17-18 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 22,488 114,235 19.7% 18,244 108,690 16.8% 21,788 118,505 18.4% 18,232 121,863 15.0% 22,833 147,657 15.5% * - For prior years-total actual expenditures, for current year-total approved budget Monitor and Consider Taking Action General Government $160,000 $140,000 $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $0 August YTD Expenditure s Annual Expenditure s* 13-14 14-15 15-16 16-17 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 August are 25.2% 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 August 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 7,796 40,697 19.2% 7,458 39,265 19.0% 9,376 39,463 23.8% 6,886 41,117 16.7% 6,689 46,594 14.4% * - For prior years-total actual expenditures, for current year-total approved budget Criminal Justice $50,000 August YTD Expenditures $40,000 $30,000 Annual Expenditures * $20,000 $10,000 $0 13-14 Better than Expected 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 2.9% lower through August 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 151,300 842,270 18.0% 152,115 841,817 18.1% 149,140 874,558 17.1% 156,251 908,553 17.2% 168,172 1,032,610 16.3% * - For prior years-total actual expenditures, for current year-total approved budget Public Safety $1,200,000 $1,000,000 August YTD Expenditures $800,000 $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 of Police, Fire and Emergency Management. Citywide public safety expenditures through August 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 August 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 229,099 573,025 40.0% 227,928 582,486 39.1% 187,587 609,990 30.8% 237,140 642,850 36.9% 267,099 705,273 37.9% * - For prior years-total actual expenditures, for current year-total approved budget Transportation $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $0 August YTD Expenditure s Annual Expenditure s* 13-14 14-15 Monitor and Consider Taking Action 15-16 16-17 17-18 Transportation expenditures include costs for Street lighting, maintenance and repair; Aviation and Public Transit. Citywide transportation expenditures are 12.6% higher through August 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 37,275 194,542 19.2% 37,422 188,670 19.8% 30,946 174,956 17.7% 31,094 188,365 16.5% 32,539 235,949 13.8% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Community Development $250,000 August YTD Expenditures $200,000 $150,000 $100,000 Annual Expenditures * $50,000 $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 August of 4.6% 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 August 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 55,212 272,326 20.3% 44,490 259,944 17.1% 47,326 273,179 17.3% 49,835 292,983 17.0% 54,502 308,665 17.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 August 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 August are 9.4% 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 August YTD Annual % of Annual Expenditures Expenditures * Expenditures 96,911 577,118 16.8% 94,101 545,198 17.3% 88,633 555,711 15.9% 109,066 599,837 18.2% 110,971 640,366 17.3% * - For prior years-total actual expenditures, for current year-total approved budget Community Enrichment $700,000 August YTD Expenditures $600,000 $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 August 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 August 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 August YTD Expenditures 16,797 22,462 25,448 23,024 17,935 Annual Expenditures % of Annual * Expenditures 100,524 16.7% 134,594 16.7% 154,710 16.4% 137,205 16.8% 106,552 16.8% * - For prior years-total actual expenditures, for current year-total approved budget net of credit for early redemption fund resources General Obligation Debt Service $180,000 August YTD Expenditures $150,000 $120,000 $90,000 Annual Expenditures * $60,000 $30,000 $0 13-14 14-15 15-16 16-17 17-18 Expected General obligation debt service expenditures through August are 22.1% lower than the same period in the prior fiscal year. Budgeted expenditures for fiscal year 2017-18 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) General Gov't 13-14 14-15 $ 263,112 $ 244,107 Refer to detailed financial schedules pages 22 - 34 15-16 $ 238,739 16-17 17-18 (Budget) $ 315,502 $ 586,357 17-18 (YTD) $ 29,724 Discussion: 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). Aviation 13-14 14-15 $ 180,571 $ 259,616 15-16 $ 522,633 16-17 17-18 (Budget) 17-18 (YTD) $ 151,957 $ 681,775 $ 143,549 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) 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). 16-17 15-16 14-15 13-14 $0 $200,000 $400,000 $600,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) Phx Convention Ctr 13-14 14-15 $ 23,189 $ 24,633 Refer to detailed financial schedules pages 22 - 34 16-17 17-18 (Budget) $ 21,885 $ 29,416 15-16 $ 24,554 Discussion: 17-18 (YTD) $ 3,840 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 $ 8,781 17-18 (Budget) 16-17 $ 7,460 $10,000 $ 29,960 $20,000 $30,000 $40,000 17-18 (YTD) $ 85 Discussion: Solid Waste Fiscal years 2010-11, 2011-12 and 2012-13 included about $5-$6 million per year in spending on the SR85 landfill. Additionally, in fiscal years 2009-10, 2010-11 and 2011-12 renovation of the 27th Ave Transfer Station accounted for a total of $24 million in spending. 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 In fiscal year 2015-16, Solid Waste spent $2.5 million on the 27th Ave Resource Innovation Campus. 13-14 $0 $10,000 $20,000 $30,000 $40,000 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 $ 42,084 16-17 17-18 (Budget) 17-18 (YTD) $ 106,776 $ 189,382 $ 2,481 Discussion: Capital funds were used to pay $25 million, $50 million and $25 million of commercial paper in fiscal years 201112, 2012-13 and 2013-14 respectively. In fiscal year 1213 the department spent $21 million on the Broadway Road Parallel Sewer. Wastewater 17-18 (YTD) 17-18 (Budget) 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. 16-17 15-16 14-15 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. 13-14 $0 $50,000 $100,000 $150,000 $200,000 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. 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). 13-14 Water System $ 129,080 14-15 $ 117,196 15-16 $ 99,091 16-17 17-18 (Budget) 17-18 (YTD) $ 189,809 $ 297,065 $ 25,823 Discussion: Major projects in fiscal year 2013-14 include construction of a new 20 million gallon concrete reservoir at Deer Valley WTP ($16 million). Water System 17-18 (YTD) 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. 17-18 (Budget) 16-17 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. 15-16 14-15 13-14 $0 $100,000 $200,000 $300,000 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 August 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 14-15 15-16 16-17 17-18 August YTD Annual % of Annual Revenues Revenues* Revenues 145,337 1,026,167 14.2% 147,664 1,048,053 14.1% 148,446 1,063,211 14.0% 154,383 1,094,933 14.1% 156,371 1,129,627 13.8% * - 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 August are 1.3% higher than the same period in the prior fiscal year. Actual revenues include $6 million from insurance proceeds related to Burton Barr Library. Without those proceeds actual revenues through August would be 2.6% lower than the same period in the prior year, primarily due to the timing difference in local sales tax revenues. 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 91,021 94,664 141,310 146,121 153,454 15-16 16-17 200,000 150,000 35,204 49,567 50,484 143,931 138,243 13-14 14-15 100,000 50,000 Secondary Primary (50,000) FY 13-14 14-15 15-16 16-17 17-18 YTD 17-18 budge Total 179,136 187,811 191,793 237,142 (1,450) 248,118 July (1,260) (1,107) (981) (1,004) (1,055) (1,244) Aug 971 760 641 454 (395) 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 YTD 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 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. There is no performance measure at this time; property tax has not yet been collected for fiscal year 17-18. 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 (943) (506) 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 50,000 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. Through August, local sales tax revenues are 19.4% below budget expectations. 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 2014-15 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 8,000 17-18 budget 6,000 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Better than Expected The fiscal year 2017-18 budget includes an increase of 3.5% in state shared sales tax over fiscal year 2016-17 actuals. Through August, state shared sales tax revenues are 3.5% above 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 201617 state shared sales tax revenues were 4.7% higher than fiscal year 2015-16. Through August 2017 state shared sales tax revenues were 7.8% higher than the same period in the prior fiscal year. 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 17-18 Actuals 6,000 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 The fiscal year 2017-18 budget includes an increase of 1.8% in state shared vehicle license tax revenues over fiscal year 2016-17 actuals. State shared vehicle license tax revenues through August 2017 are 26.9% higher than budget expectations for the period. Vehicle License Tax 3 Year Trend 10,000 8,000 15-16 Actuals 16-17 Actuals 17-18 Actuals 6,000 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 through August 2017 are 8.4% lower than budget expectations in large part due to the timing difference for local sales tax revenues. Governmental Funds Revenues 3 Year Trend 260,000.00 210,000.00 160,000.00 2015-16 Actuals 110,000.00 2016-17 Actuals 60,000.00 2017-18 Actuals 10,000.00 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June (40,000.00) 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 40,000 35,000 30,000 17-18 Actuals 25,000 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 Better than Expected Aviation operating revenues through August 2017 are 9.8% higher than budget expectations for the period. Aviation Operating Revenues 3 Year Trend 40,000 35,000 30,000 25,000 15-16 Actuals 16-17 Actuals 17-18 Actuals 20,000 15,000 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. Through August 2017, aviation operating revenues are 5.6% higher than the same period in the prior fiscal 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 30,000 17-18 budget 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Better than Expected Water system revenues through August 2017 are 1.3% higher than budget expectations for the period. Water System Operating Revenues 60,000 3 Year Trend 50,000 40,000 15-16 Actuals 16-17 Actuals 17-18 Actuals 30,000 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. Through August 2017, water system revenues are 2.0% higher than the same period in the prior fiscal 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 25,000 20,000 15,000 17-18 budget 10,000 17-18 Actuals 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 August 2017 are 10.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 10,000 17-18 Actuals 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May Click Here for Additional Information - 21 - 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 AUGUST 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 $ 60,963 $ 107 72,662 111 148,964 196,303 62,706 153,454 2,896 10,090 24,033 33,339 13,838 (943) 585 (86) 22,296 31,891 10,105 (413) 478 171 10,365 1,164 13,644 740 7,664 2,106 4,339 2,046 173 1,446 6,105 1,502 287 777 1,946 154 1,178 83 1,296 325 921 35,000 1,400 11,613 3,908 15,469 5,807 119 2,464 1,049 2,762 7,109 1,728 591 1,752 445,511 2,290 1,129,626 - 22 - $ $ 156,373 $ 154,384 General Fund Expenditures As of AUGUST 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 $ 228 $ 582 672 6,639 330 373 3,336 424 838 1,657 592 3,380 952 20,003 209 538 609 6,718 319 336 3,084 382 495 1,655 594 977 566 16,482 29,241 5,081 34,322 4,917 751 5,668 4,591 710 5,301 548,803 298,471 83 847,357 99,609 47,239 48 146,896 91,961 41,945 14 133,920 Transportation Street Transportation Street Lighting Public Transit Total Transportation 18,836 1,712 20,548 5,586 5,586 2,761 1,663 4,424 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 5,091 13,281 4,157 54 22,583 791 2,025 692 8 3,516 883 1,649 585 8 3,125 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 90,983 38,766 19,141 6,338 155,228 18,365 6,544 2,250 2,693 29,852 17,589 5,499 2,279 1,841 27,208 Environmental Services Public Works Environmental Programs Total Environmental Services 13,113 618 13,731 2,613 91 2,704 2,147 95 2,242 9,672 749 810 - - Criminal Justice Municipal Court Public Defender Total Criminal Justice Public Safety Police Fire Others Total Public Safety Capital Improvement Contingencies Total Expenditures and Encumbrance$ 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 $ 55,900 1,277,739 - 23 - $ 214,974 $ 193,512 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 AUGUST 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 Enterprise Funds Aviation Convention Center Water System Wastewater Solid Waste Total Enterprise Funds Total Operating Revenues 445,511 2,290 $ $ 60,963 $ 107 $ 72,662 111 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 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 24,033 33,339 13,838 (943) 585 (86) 2,219 1,446 6,105 1,502 287 777 8,390 1,049 2,762 22,296 31,891 10,105 (413) 478 171 2,100 1,178 83 1,296 325 921 8,837 591 1,752 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 Total Special Revenue and Debt Service Funds Actual Year-to-Date 2017-2018 2016-2017 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 156,372 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,115,118 344,541 73,179 420,570 229,962 148,669 - 24 - 4,195 10,066 4,281 325 36,429 708 15,720 1,277 2,088 19,749 5,239 1,677 7,756 18,611 (464) 154,383 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 127,657 $ $ $ $ $ 1,216,922 $ 3,461,667 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 61,368 8,694 99,257 41,572 26,548 4,825 14,874 4,838 433 34,033 940 14,852 1,981 2,255 18,735 7,734 1,712 6,028 23,926 (138) 137,028 $ $ $ $ $ 58,091 8,707 97,324 38,196 24,785 237,440 227,103 521,468 $ 518,514 Citywide Operating Expenditures As of AUGUST 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 20,003 $ 2,830 22,833 16,482 1,750 18,232 34,322 12,272 46,594 5,668 1,021 6,689 5,301 1,585 6,886 847,357 185,253 1,032,610 146,896 21,276 168,172 133,920 22,331 156,251 Transportation General Funds Other Funds Total Transportation 20,548 684,725 705,273 5,586 261,513 267,099 4,424 232,716 237,140 Community Development General Funds Other Funds Total Community Development 22,583 213,366 235,949 3,516 29,023 32,539 3,126 27,967 31,093 Community Enrichment General Funds Other Funds Total Community Enrichment 155,228 153,437 308,665 29,852 24,650 54,502 27,208 22,627 49,835 Environmental Services General Funds Other Funds Total Environmental Services 13,731 626,635 640,366 2,704 108,267 110,971 2,241 106,825 109,066 Debt Service General Funds Other Funds Total Debt Service 106,552 106,552 17,935 17,935 23,024 23,024 Capital Improvement General Funds Other Funds Total Capital Improvement 9,672 726,575 736,247 749 49,758 50,507 810 47,391 48,201 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 $ $ 214,974 516,273 731,247 $ - 25 - 193,512 486,216 679,728 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 AUGUST 31 2017 2016 Budget Estimate 2017-2018 Source Actual Year-to-Date 2017-2018 2016-2017 General Funds $ 43,894,730 76,867 43,971,597 $ 36,805,097 73,852 36,878,949 12,260,079 16,669,601 4,829,997 11,027,339 15,945,590 4,393,227 33,759,677 31,366,156 Local Taxes: Sales Taxes Privilege License Fees $ Total Local Taxes State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax Total State Shared Taxes 445,511,000 2,290,000 148,964,000 196,303,000 62,706,000 24,033,079 33,339,203 13,837,716 22,296,339 31,891,180 10,104,899 407,973,000 71,209,998 64,292,418 153,454,000 314,059 302,360 Licenses and Permits 2,501,111 2,607,549 1,061,225 88,295 875,324 79,652 954,976 72,662,058 110,660 72,772,718 Primary Property Tax 573,933 $ 61,069,936 331,621 805,624 60,962,932 107,004 447,801,000 (213,694) 1,149,520 $ (943,160) (412,999) 2,896,000 585,421 478,254 Cable Communications 10,090,000 (85,764) 170,705 Municipal Court: Fines and Forfeitures Court Default Fee 10,364,925 1,164,000 Total Municipal Court Police Library Fees 2,045,625 172,963 1,945,813 154,351 11,528,925 2,218,588 2,100,164 13,644,495 1,445,762 1,177,737 5,055,940 51,609 740,110 6,104,818 83,183 919,184 361,061 Parks and Recreation 7,664,381 1,501,647 1,295,791 152,206 170,225 Planning and Development 2,106,481 286,581 324,766 541,681 519,594 Street Transportation 4,339,350 776,783 920,544 14,647,192 65,650 2,443,865 18,521,980 72,571 169,103 35,000,000 1,400,000 11,612,884 5,806,631 118,500 2,464,444 7,109,111 122,971 1,605,082 17,156,707 18,763,654 48,012,884 8,389,575 8,837,164 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire 493,979 294,202 Interest 1,428,666 941,619 Other Fees and Service Charges 108,036,257 94,117,508 Total General Funds 26 3,908,000 1,049,454 591,352 15,468,866 2,761,948 1,751,517 1,129,627,492 156,371,587 154,383,314 Citywide Operating Revenue by Source (continued) For the Month Ended AUGUST 31 2016 2017 Budget Estimate 2017-2018 Source Actual Year-to-Date 2017-2018 2016-2017 Special Revenue and Debt Service Funds $ 2,001,633 142,973 714,869 152,550 $ 3,012,025 5,437,807 1,672,509 14,859 $ $ $ 7,125,175 3,057,604 87,613 0 70,046 71 18,075 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 2,410,397 Total Neighborhood Protection 5,563,085 2,041,412 83,567 7,688,064 $ $ $ $ $ $ 175,805 19,413,227 5,350,848 1,649,465 117,820 589,095 54,017 2,397,073 88,594 0 101,848 54 (5,818) 184,678 $ $ 24,764,075 15,711,525 (58,891) 15,652,634 0 $ 940,000 5,573,063 $ 4,722,950 1,137,491 $ 984,002 1,250,376 39,205 1,289,581 $ $ 1,051,042 19,570 1,070,612 $ 21,930,000 1,567,000 7,832,000 365,000 $ 2,813,331 200,952 1,004,761 176,391 $ 3,330,045 237,861 1,189,302 67,824 31,694,000 4,195,435 4,825,032 66,423,000 22,518,000 54,000 7,669,618 2,367,095 29,003 10,880,954 3,906,722 86,077 88,995,000 10,065,716 14,873,753 31,853,000 4,280,716 4,837,746 3,552,200 0 2,172,725 (2,000) 219,275 161,010 0 128,298 224 35,837 191,523 0 216,625 281 24,795 5,942,200 325,369 433,224 210,700,000 51,376,890 27,333,906 9,095,084 31,798,348 2,234,502 262,076,890 36,428,990 34,032,850 4,847,340 708,000 940,000 Planning and Development 53,948,800 15,719,579 14,851,798 Capital Construction 11,076,000 1,277,299 1,981,081 Sports Facilities: Sales Taxes Interest/Other 19,235,000 8,852,016 2,011,204 76,582 2,216,030 38,532 28,087,016 2,087,786 2,254,562 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 Total Sports Facilities 27 Citywide Operating Revenue by Source (continued) For the Month Ended AUGUST 31 2016 2017 Budget Estimate 2017-2018 Source Actual Year-to-Date 2017-2018 2016-2017 Special Revenue and Debt Service Funds (Cont'd) $ 9,304,023 104,227 0 9,422,000 49,651 2,754 9,408,250 9,474,405 - $ - Highway User Revenue: Highway User Revenue Interest Other 127,531,000 500,000 150,000 19,544,023 198,539 6,400 18,636,000 96,444 2,754 Total Highway User Revenue 128,181,000 19,748,962 18,735,198 Local Transportation Assistance 0 0 0 38,214,960 5,238,753 7,734,428 5,091,810 1,677,412 1,712,114 48,167,904 7,756,284 6,027,652 7,274,000 81,683,028 8,694,844 1,017,405 11,815,597 1,979,679 1,471,115 10,820,016 880,779 97,651,872 14,812,681 13,171,910 46,031,773 53,696,411 30,138,429 50,022,756 1,626,560 28,171 (4,875,339) 7,018,814 Total Other 179,889,369 3,798,206 10,753,874 Total Grants 277,541,241 18,610,887 23,925,784 2,608,368 761,303 Regional Transit Revenues 572,194 726,866 Community Reinvestment 4,194,193 3,938,246 Other Restricted Fees 467,570 6,256,944 1,525,622 851,805 5,938,948 775,581 Grants: Public Housing: Rentals Grants Other 8,250,136 7,566,334 3,581,112 28,170 (11,333) 2,905,949 3,490,069 6,358,216 1,289,549 1,923,409 6,503,898 13,061,243 14,754,034 20,627,577 (181,342) 71 (181,271) 77,490,587 122,205 0 122,205 71,701,012 $ Total Public Housing Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond/Secondary Property Tax Secondary Property Tax Interest 94,663,937 4,736,652 Total G.O. Bond/Secondary Property Tax 99,400,589 Total Special Revenue and Debt Service Funds 1,115,117,750 (506,387) 42,117 (464,270) 3,501,214 6,358,216 1,505,755 (611,311) (137,598) 0 (137,598) 127,656,918 137,027,624 137,700,000 195,960,000 1,500,000 4,262,700 2,142,000 2,976,500 0 17,608,531 41,343,324 396,420 880,763 426,953 483,438 228,478 16,939,565 39,011,173 322,257 785,380 382,043 487,215 163,710 344,541,200 61,367,907 58,091,343 Enterprise Funds AVIATION: 8,841,515 24,683,370 206,131 666,308 212,287 229,788 125,377 8,492,880 20,171,531 163,478 443,583 181,909 240,131 83,566 34,964,776 29,777,078 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 AUGUST 31 2016 2017 Budget Estimate 2017-2018 Source Actual Year-to-Date 2017-2018 2016-2017 Enterprise Funds (Cont'd) CONVENTION CENTER: $ 3,918,161 1,314,972 51,146 3,221,204 875,941 34,492 5,284,279 4,131,637 41,893,518 563,033 442,959 1,070,214 436,920 251,753 (24,765) 44,143,769 445,419 483,444 1,397,799 341,280 177,669 114,505 44,633,632 47,103,885 Excise Taxes Operating Revenue Interest Total Convention Center 51,897,000 20,958,163 323,835 5,471,812 3,125,856 96,232 6,717,261 1,922,688 67,486 73,178,998 8,693,900 8,707,435 396,920,000 5,800,000 4,270,000 6,168,000 3,600,000 2,279,000 1,533,000 92,495,744 1,090,789 867,245 1,141,636 661,620 476,799 2,523,410 92,546,424 809,319 1,414,858 1,959,971 474,540 342,966 (223,874) 420,570,000 99,257,243 97,324,204 195,418,000 17,259,000 3,600,000 1,664,000 12,021,000 33,501,739 3,268,844 645,060 486,444 3,670,205 31,646,107 3,524,159 432,840 288,536 2,303,978 229,962,000 41,572,292 38,195,620 130,245,000 8,300,000 625,000 9,499,411 21,724,187 1,577,850 117,839 3,128,338 21,535,165 1,441,114 111,359 1,697,233 WATER SYSTEM: $ Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System WASTEWATER: 16,914,273 3,268,844 435,360 205,594 2,132,912 16,008,861 1,715,159 304,620 145,565 1,185,155 22,956,983 19,359,360 10,875,070 851,475 60,630 1,011,712 10,760,669 762,340 56,439 826,672 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: $ 12,798,887 12,406,120 120,638,557 112,778,080 306,165,401 $ 278,596,600 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ 29 148,669,411 26,548,214 24,784,871 1,216,921,609 237,439,556 227,103,473 3,461,666,851 $ 521,468,061 $ 518,514,411 Citywide Operating Expenditures by Program For the Month Ended AUGUST 31 2017 2016 Program Budget Estimate 2017-2018 Actual Year-to-Date 2017-2018 2016-2017 2017-2018 Year-to-Date perating Expenditures & Encumbranc Capital Operations and Debt General Government $ 122,058 304,448 328,127 4,415,789 46,858 205,577 232,483 1,874,199 181,401 480,696 159,355 861,770 57,264 31,881 172,274 8,591 293,828 1,705,187 137,843 11,619,629 $ 114,539 278,514 308,092 3,287,854 50,597 181,406 195,283 1,825,969 222,864 244,671 7,156 1,107,596 60,042 48,150 171,738 9,926 314,740 702,472 652,771 Mayor $ City Council City Manager Information Technolog Government Relations Public Information Equal Opportunity Law City Auditor City Clerk Elections Human Resources Manager's Office of S Phx Community Deve Retirement Systems Phoenix Employment Budget and Research Finance Regional Wireless Co 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,405,838 40,936,270 4,628,072 $ 228,490 582,075 730,254 8,702,935 98,900 446,304 446,988 3,590,215 423,986 838,118 396,174 1,818,228 119,276 60,489 320,635 17,013 592,267 4,060,952 (640,428) $ 209,063 537,651 657,789 7,156,954 104,079 366,548 395,225 3,291,652 382,187 495,576 7,752 2,032,203 126,266 101,975 310,482 17,481 594,243 1,596,159 (150,898) $ 228,490 582,075 730,254 6,749,490 98,900 446,304 446,988 3,590,215 423,986 838,118 396,174 1,701,310 119,276 60,489 320,635 17,013 592,267 3,773,892 (640,428) 1,953,445 116,918 287,060 - 9,784,380 Total General Gover 147,657,166 22,832,871 18,232,387 20,475,448 2,357,423 41,513,195 5,080,998 - 5,938,036 751,141 - 6,176,118 710,300 - 5,242,393 751,141 - 695,643 - 46,594,193 6,689,177 6,886,418 5,993,534 695,643 677,593,110 353,985,691 1,031,393 113,131,450 54,878,040 162,805 106,476,529 49,566,075 207,923 112,701,118 54,163,499 162,805 430,331 714,540 - 1,032,610,194 168,172,295 156,250,527 167,027,422 1,144,872 Criminal Justice 2,641,447 374,008 - 3,154,796 652,611 - 3,015,455 3,807,407 Municipal Court Public Defender Other Total Criminal Justic Public Safety 54,919,146 26,408,174 86,425 50,873,149 24,613,747 133,632 81,413,745 75,620,528 Police Fire Other Total Public Safety -30- Citywide Operating Expenditures by Program (continued) For the Month Ended AUGUST 31 2017 2016 Program Budget Estimate 2017-2018 Actual Year-to-Date 2017-2018 2016-2017 2017-2018 Year-to-Date perating Expenditures & Encumbranc Capital Operations and Debt Transportation $ 6,356,082 112,735 23,446,167 164,833,497 194,748,481 $ 5,152,565 972,857 25,957,728 166,134,872 Street Transportatio $ Street Lighting Aviation Public Transit 198,218,022 Total Transportation 84,034,896 (267,849) 310,554,884 310,950,911 $ 15,842,273 1,033,616 45,639,830 204,582,827 $ 10,319,904 1,836,919 50,070,129 174,912,945 $ 15,530,741 1,033,616 36,183,020 191,782,635 311,532 9,456,810 12,800,192 705,272,842 267,098,546 237,139,897 244,530,012 22,568,533 Community Development 4,246,602 7,034,154 2,370,904 2,814,751 4,456,965 6,989,024 2,390,394 1,511,088 Planning and Develop Housing Economic Developme Neighborhood Service 60,933,593 95,454,581 29,490,369 50,070,115 8,269,205 15,094,589 4,027,717 5,147,803 7,844,685 15,717,863 4,007,064 3,524,363 8,269,205 15,082,446 3,434,048 5,147,803 12,144 593,669 - 16,466,411 15,347,471 Total Community De 235,948,658 32,539,314 31,093,975 31,933,502 605,812 Community Enrichment 9,024,906 3,037,773 834,071 5,102,837 986,433 5,030,402 174,063 309,133 8,797,346 2,734,374 442,966 5,844,504 988,454 4,692,065 389,797 284,764 Parks and Recreation Library Golf Convention Center Sports and Cultural Fa Human Services Public Parking Facilitie 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 20,104,210 6,638,448 1,134,520 10,695,531 1,970,706 9,588,812 3,108,612 1,261,444 18,896,137 5,564,628 936,188 9,892,824 1,996,881 9,770,265 1,381,002 1,397,417 20,038,860 6,638,448 1,134,520 7,370,457 9,484,348 3,108,612 1,261,444 65,349 3,325,074 1,970,706 104,464 - 24,499,618 24,174,270 Total Community En 308,665,051 54,502,283 49,835,342 49,036,689 5,465,594 -31- Citywide Operating Expenditures by Program (continued) For the Month Ended AUGUST 31 2017 2016 Budget Estimate 2017-2018 Program Actual Year-to-Date 2017-2018 2016-2017 2017-2018 Year-to-Date perating Expenditures & Encumbranc Capital Operations and Debt Environmental Services $ 37,833,645 16,980,265 9,975,345 2,161,434 235,163 67,185,852 $ 28,111,036 10,939,491 10,145,902 1,095,566 133,955 50,425,950 Water System $ Wastewater Solid Waste Managem Public Works Environmental Progra 325,460,179 150,257,662 141,731,658 21,558,832 1,357,601 Total Environmental 640,365,932 $ 59,415,446 27,214,239 20,507,045 3,485,506 348,391 $ 53,329,366 25,539,525 26,572,868 3,389,811 234,347 $ 41,160,636 15,863,347 19,252,276 2,616,932 348,391 18,254,810 11,350,892 1,254,769 868,574 31,729,045 110,970,627 109,065,917 79,241,582 General Obligation Debt Service 16,421 949,715 1,277,744 64,347 368,314 27,914 1,024,511 146,137 773,918 401,877 51,315 1,125,869 25 494,711 340,373 151,437 28,101 173,848 1,001,066 418,799 512 43,161 16,421 1,292,609 2,362,056 69,262 377,391 28,509 1,113,166 173,095 587,335 536,321 106,581 1,141,993 32,525 574,149 443,902 180,848 100,000 115,327 1,330,649 423,786 512 552,718 Aviation Civic Plaza Cultural Facilities Downtown Developme Early Redemption Economic Developme Fire Protection Freeway Mitigation Historic/Neighborhood Human Services Information Systems Libraries Maintenance Service Mountain Preserves/P MEGA Real Estate Municipal Administrati Police Protection Public Housing Renov Public Housing Sanitary Sewers Secondary Property T Solid Waste Enterpris Storm Sewer Improve Street Improvements Street Light Refinancin Public Transit Water System 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 - 32,842 1,899,430 2,555,489 128,695 736,627 55,829 2,049,022 292,275 1,562,311 803,755 102,629 2,251,739 50 989,422 680,747 302,873 216,026 347,696 2,002,131 837,599 1,025 86,322 32,842 2,585,218 4,724,112 138,525 754,781 57,017 2,226,332 346,190 1,174,670 1,072,643 213,162 2,283,986 65,050 1,148,297 887,804 361,697 106,000 230,654 2,661,298 847,572 1,025 1,105,436 32,842 1,899,430 2,555,489 128,695 736,627 55,829 2,049,022 292,275 1,562,311 803,755 102,629 2,251,739 50 989,422 680,747 302,873 216,026 347,696 2,002,131 837,599 1,025 86,322 - 8,880,115 11,559,155 Total Debt Service 106,552,239 17,934,534 23,024,311 17,934,534 - 8,529,606 13,558,507 Capital Improvement 736,246,953 50,506,697 48,201,381 Contingencies 103,400,000 $ 416,358,912 402,495,690 - 4,063,313,228 731,246,344 -32- 679,730,155 - - - - 616,172,723 64,566,922 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 Actual Yearto-Date Budget From Operating Funds Budget Actual $ 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,769,835 16,098 $ 64,923 422,495 181,086 7,435 10,000 1,128,597 13,493,005 39,400 42,649 2,505,191 2,340,126 69,824 9,403,502 $ 16,523 295,899 182,836 204,235 905 2,023,493 2,092,889 3,057 91,081 912,092 208,621 22,231,795 1,311,083 7,479,337 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,926,713 General Government Subtota$ 586,356,681 $ 29,724,331 $ 37,053,846 365,189,945 $ Enterprise Aviation Phoenix Convention Center Solid Waste Disposal Wastewater Water System Enterprise Subtotal Total Capital Budget Program $ $ $ 681,775,068 29,416,250 29,959,680 189,382,112 297,065,165 1,227,598,275 $ $ 143,548,604 3,840,150 84,963 2,480,988 25,823,301 175,778,006 $ 1,813,954,956 $ 205,502,337 $ $ $ 37,405,202 3,462,612 1,978,219 2,533,699 7,493,203 52,872,935 $ 89,926,781 $ 64,923 422,495 170,413 216,706 2,740,289 3,105 40,079 2,436,055 2,340,126 4,468,672 12,902,863 $ $ 108,133,092 6,917,250 22,498,750 74,523,918 158,983,998 371,057,008 $ 736,246,953 - 33 - 2017-2018 Year-to-Date Capital Amounts From Capital Funds Budget Actual $ $ $ 19,986,789 82,271 76,960 2,094,329 15,363,485 37,603,834 $ 50,506,697 Unencumbered Budget 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 16,098 $ 10,673 7,435 10,000 911,891 10,752,716 36,295 2,570 69,136 69,824 4,934,830 1,041,801 9,587,577 777,505 21,001,039 1,647,511 17,354,102 914,988 22,498,169 600,000 44,186,240 1,739,539 4,366,403 73,378,037 84,699,646 4,935,726 7,537,734 260,366,333 221,166,736 $ 16,821,468 556,632,350 $ $ 573,641,976 22,499,000 7,460,930 114,858,194 138,081,167 856,541,267 $ 1,077,708,003 $ $ $ 123,561,815 3,757,879 8,003 386,659 10,459,816 138,174,172 $ 538,226,464 25,576,100 29,874,717 186,901,124 271,241,864 1,051,820,269 $ 154,995,640 $ 1,608,452,619 Bonds Authorized and Sold As of AUGUST 31 (dollars in thousands) Authorized Sold Available 1988 Authorizations General Obligation Bonds Freeway Mitigation, Neighborhood Stabilization, and Slum and Blight Elimination $ Bonds Fully Issued Total General Obligation Bonds 29,285 884,175 $ 28,285 884,175 $ 1,000 - 913,460 912,460 1,000 143,890 143,890 - 1,057,350 1,056,350 1,000 66,300 125,300 24,800 61,500 12,000 33,000 91,500 74,000 77,000 78,800 66,000 43,700 64,600 124,685 24,170 60,700 11,205 32,100 89,275 71,645 72,575 77,685 65,950 43,700 1,700 615 630 800 795 900 2,225 2,355 4,425 1,115 50 - 753,900 738,290 15,610 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 $ 2,689,750 $ 2,537,395 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 Revitalizatio 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 - $ 152,355 Appendix A Additional historic and trend information for various revenue streams. Local Sales Tax (Dollars in Thousands) Local Sales Tax 60,000 13-14 Actuals 14-15 Actuals 15-16 Actuals 16-17 Actuals 17-18 Actuals 50,000 40,000 30,000 20,000 10,000 July FY 13-14 14-15 15-16 16-17 17-18 17-18 budget July 36,360 35,365 34,740 35,857 17,068 37,597 Aug Aug 35,589 36,414 35,137 36,805 43,895 38,025 Sept YTD thru August 71,949 71,779 69,876 72,662 60,963 75,622 Oct Sept 35,873 35,290 35,079 34,012 37,050 Nov Oct 35,068 34,621 35,459 38,800 38,026 Dec Nov 34,363 33,033 34,433 32,023 35,359 Jan Feb Mar Dec 32,474 35,062 32,783 35,135 35,783 Jan 40,116 37,227 37,567 38,595 40,551 Feb 32,084 34,432 32,793 22,766 32,248 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 2013-14 through FY 2017-18 actual expenditures. Return to Summary Page - A1 - Apr Mar 32,147 34,938 33,135 33,502 35,325 May Apr 35,988 37,203 36,307 28,921 36,566 June 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 30,000 13-14 Actuals 14-15 Actuals 15-16 Actuals 16-17 Actuals 17-18 Actuals 17-18 budget 25,000 20,000 15,000 10,000 5,000 July FY 13-14 14-15 15-16 16-17 17-18 17-18 budget Aug July 10,309 11,103 11,070 11,269 11,773 12,053 Sept Aug 9,616 9,712 10,222 11,027 12,260 11,178 Oct YTD thru August 19,925 20,815 21,292 22,296 24,033 23,231 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 2013-14 through FY 2017-18 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 Mar 10,506 10,861 11,139 11,785 12,201 June 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 17-18 budget Aug Sept July 4,752 4,963 5,095 5,712 9,008 5,635 Aug 4,663 5,004 5,133 4,393 4,830 5,270 Oct YTD thru August 9,415 9,967 10,228 10,105 13,838 10,905 Nov Sept 3,992 3,749 4,087 4,846 4,578 Dec Jan Feb Oct 3,912 4,415 4,922 5,181 5,060 Nov 3,958 4,198 4,291 4,242 4,582 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 2013-14 through FY 2017-18 actual expenditures. Return to Summary Page - A3 - Mar Jan 3,936 4,661 5,195 5,607 5,326 Apr May Feb 4,799 4,920 5,024 5,049 5,435 Mar 4,559 4,984 5,065 5,457 5,509 June 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 2013-14 Actuals 2014-15 Actuals 2015-16 Actuals 2016-17 Actuals 2017-18 Actuals 17-18 budget 300,100.00 250,100.00 200,100.00 150,100.00 100,100.00 50,100.00 100.00 July FY 13-14 14-15 15-16 16-17 17-18 17-18 budget July 125,711 127,962 128,588 125,592 98,501 142,610 Aug Sept Aug 137,320 138,394 155,197 165,819 185,527 167,452 YTD thru August 263,031 266,356 283,786 291,411 284,028 310,062 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 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 2013-14 through FY 2017-18 actual expenditures. Return to Summary Page - A4 - Feb Jan 153,911 151,099 160,567 173,436 179,104 Mar Feb 132,551 144,296 141,861 145,268 158,535 Apr Mar 144,892 150,768 160,707 159,366 173,392 May 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 15-16 Actuals 30,000 16-17 Actuals 17-18 Actuals 17-18 budget 20,000 10,000 July FY 13-14 14-15 15-16 16-17 17-18 17-18 budget Aug July 31,036 27,544 28,758 28,314 26,403 29,090 Sept Aug 22,760 26,594 27,373 29,777 34,965 26,789 Oct YTD thru August 53,796 54,138 56,131 58,091 61,368 55,879 Nov Sept 26,677 27,855 28,151 29,279 28,162 Dec Jan Feb Mar Apr Oct 26,505 26,489 29,050 28,339 27,765 Nov 26,222 27,610 29,039 30,504 28,517 Dec 27,171 27,853 25,795 24,926 26,598 Jan 26,659 27,917 28,789 28,532 28,145 Feb 26,561 26,683 27,161 28,901 27,494 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 2013-14 through FY 2017-18 actual expenditures. Return to Summary Page - A5 - May Mar 28,352 30,414 31,530 29,273 30,075 June 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 100,000 13-14 Actuals 90,000 14-15 Actuals 80,000 15-16 Actuals 70,000 16-17 Actuals 60,000 17-18 Actuals 50,000 17-18 budget 40,000 30,000 20,000 10,000 July FY 13-14 14-15 15-16 16-17 17-18 17-18 budget Aug July 49,017 50,166 47,014 50,220 54,624 52,117 Sept Aug 42,137 40,684 43,100 47,104 44,633 45,911 Oct YTD thru August 91,154 90,850 90,115 97,324 99,257 98,028 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 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 2013-14 through FY 2017-18 actual expenditures. Return to Summary Page - A6 - Mar Jan 22,872 21,031 22,460 21,608 23,342 Apr Feb 21,185 19,044 19,179 19,223 20,864 May Mar 21,993 20,725 24,487 20,925 23,385 June 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 27,000 13-14 Actuals 14-15 Actuals 22,000 15-16 Actuals 16-17 Actuals 17,000 17-18 Actuals 17-18 budget 12,000 7,000 2,000 July FY 13-14 14-15 15-16 16-17 17-18 17-18 budget Aug July 17,634 18,325 16,156 18,836 18,615 18,361 Sept Aug 18,252 18,520 18,477 19,359 22,957 19,308 Oct YTD thru August 17,634 36,845 34,634 38,196 41,572 37,669 Nov Sept 18,224 18,337 21,171 19,337 19,945 Dec Oct 17,798 17,754 18,058 18,611 18,690 Jan 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 2013-14 through FY 2017-18 actual expenditures. Return to Summary Page - A7 - Mar Apr May June Jan 17,618 18,183 19,384 19,155 19,239 Feb 18,058 17,960 18,385 18,594 18,891 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