February 2018 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division City of Phoenix Monthly Financial Report February 2018 Table of Contents Expenditures by Programs Page Performance Status General Fund Expenditures Report Navigation General Fund Total Expenditures 1 Better than Expected General Government 1 Better than Expected Click on either the schedule name or the Criminal Justice 2 Better than Expected performance status in the table of contents to Public Safety 2 Better than Expected be taken directly to that page of the report. Transportation 3 Monitor and Consider Taking Action Community Development 3 Better than Expected Community Enrichment 4 Monitor and Consider Taking Action Environmental Services 4 Better than Expected Citywide Total Operating Expenditures 5 Better than Expected General Government Criminal Justice 5 6 Better than Expected Better than Expected Performance Status Public Safety 6 Better than Expected Better than Expected - Positive variance of Transportation 7 Monitor and Consider Taking Action Community Development 7 Better than Expected Community Enrichment 8 Monitor and Consider Taking Action Environmental Services 8 Expected Monitor and Consider Taking Action - Negative General Obligation Debt Service 9 Expected variance greater than 1% actual vs budget. From any page of the report, click on the City of Phoenix Bird Emblem to return to the Table of Contents Citywide Expenditures greater than 1% actual vs budget. Expected - Actual vs budget variance within 1% positive or negative. 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 Better than Expected 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 Better than Expected 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 Better than Expected General Fund Expenditures Expenditures from the City's General Fund for core functions such as Police, Fire, Parks, Streets and Social Services as well as administrative functions such as Mayor and Council, City Manager, Finance, and Human Resources. This does not include any expenditures from dedicated revenue streams such as grants, bonds, specifically dedicated taxes, and enterprise revenues. February General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Total General Fund Expenditures 13-14 14-15 15-16 16-17 17-18 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 698,732 1,042,102 67.1% 704,778 1,051,395 67.0% 707,066 1,066,521 66.3% 745,561 1,105,361 67.4% 791,531 1,221,839 64.8% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustment for contingencies. Better than Expected Total General Fund General Government $1,400,000 $1,200,000 $1,200,000 $1,000,000 $1,000,000 $800,000 $800,000 $600,000 $600,000 February YTD Expenditures February 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 February are 6.2% 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 67,617 100,400 67.3% 69,384 96,385 72.0% 71,538 105,240 68.0% 72,595 106,754 68.0% 79,151 118,398 66.9% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice General Government $120,000 $140,000 $100,000 $120,000 $80,000 $100,000 February YTD Expenditures February YTD Expenditures $80,000 $60,000 Annual Expenditures * Annual Expenditures * $60,000 $40,000 $40,000 $20,000 $20,000 $0 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 February are 9.0% higher than the same period in the prior fiscal year. General fund general government expenditures increased 6.3% over the three 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 February 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 22,091 32,659 67.6% 21,009 31,018 67.7% 21,719 30,698 70.8% 20,675 31,595 65.4% 21,636 34,322 63.0% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice $40,000 February YTD Expenditures $35,000 $30,000 $25,000 Annual Expenditures * $20,000 $15,000 $10,000 $5,000 $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 February are 4.6% 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 469,702 699,796 67.1% 474,792 716,304 66.3% 489,816 737,129 66.4% 516,987 764,482 67.6% 544,938 847,357 64.3% * - For prior years-total actual expenditures, for current year-total approved budget Public Safety $1,000,000 $800,000 February 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 2016-17 actuals. Through February, general fund public safety expenditures are 5.4% 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 February 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 20,828 29,713 70.1% 23,851 34,187 69.8% 10,436 17,473 59.7% 11,098 17,878 62.1% 13,150 20,548 64.0% * - 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 February 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 February general fund transportation expenditures are 18.5% higher than the same period in the prior fiscal year. General fund transportation expenditures decreased significantly in fiscal year 2015-16 from prior years due to the passage of proposition 104 which eliminated the need for approximately $16 million in support for the transit fund from the general fund. Community Development 13-14 14-15 15-16 16-17 17-18 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 13,684 20,210 67.7% 12,892 18,986 67.9% 12,692 18,571 68.3% 12,784 19,709 64.9% 14,095 22,583 62.4% * - For prior years-total actual expenditures, for current year-total approved budget Community Development $25,000 February YTD Expenditures $20,000 $15,000 $10,000 Annual Expenditures * $5,000 $0 13-14 Better than Expected 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 February are 10.3% 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 February 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 94,806 143,665 66.0% 90,592 138,024 65.6% 91,777 141,483 64.9% 95,572 146,749 65.1% 102,793 155,228 66.2% * - For prior years-total actual expenditures, for current year-total approved budget Community Enrichment $200,000 February YTD Expenditures $160,000 $120,000 $80,000 Annual Expenditures * $40,000 $0 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 February, general fund community enrichment expenditures are 7.6% higher than the same period in the prior fiscal year. The increased spending over budget expectations is primarily due to the costs associated with the damage to the Burton Barr Central Library. 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 2013-14. Environmental Services 13-14 14-15 15-16 16-17 17-18 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 9,274 13,748 67.5% 11,583 15,082 76.8% 7,585 12,143 62.5% 13,748 12,775 107.6% 9,234 13,731 67.2% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services $16,000 February YTD Expenditures $12,000 $8,000 Annual Expenditures * $4,000 $0 13-14 Better than Expected 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 February, general fund environmental services expenditures are 32.8% lower 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. February 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 2,035,798 3,054,098 66.7% 2,022,852 3,051,875 66.3% 2,073,930 3,156,441 65.7% 2,195,311 3,468,589 63.3% 2,350,069 3,959,913 59.3% * - 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 February 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 February are 7.0% higher than the same period in the prior fiscal year. General Government 13-14 14-15 15-16 16-17 17-18 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 77,942 114,235 68.2% 77,269 108,690 71.1% 80,324 118,505 67.8% 83,827 121,863 68.8% 92,407 147,657 62.6% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected General Government $160,000 $140,000 $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $0 February 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 February are 10.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 February 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 % of Annual February YTD Annual Expenditures Expenditures * Expenditures 27,521 40,697 67.6% 26,542 39,265 67.6% 27,337 39,463 69.3% 27,251 41,117 66.3% 25,645 46,594 55.0% * - For prior years-total actual expenditures, for current year-total approved budget Criminal Justice $50,000 February 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 5.9% lower through February than the same period in the prior fiscal year. The decrease is primarily due to lower debt service requirements resulting from the 2017 excise tax refunding bonds. 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 565,460 842,270 67.1% 561,069 841,817 66.6% 579,550 874,558 66.3% 607,741 908,553 66.9% 646,129 1,032,610 62.6% * - For prior years-total actual expenditures, for current year-total approved budget Public Safety $1,200,000 $1,000,000 February YTD Expenditures $800,000 $600,000 $400,000 Annual Expenditures * $200,000 $0 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 February are 6.3% 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 February 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 435,821 573,025 76.1% 436,530 582,486 74.9% 444,364 609,990 72.8% 463,838 642,850 72.2% 522,075 705,273 74.0% * - 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 February YTD Expenditure s Annual Expenditure s* 13-14 14-15 15-16 Monitor and Consider Taking Action 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 February than the same period in the prior fiscal year, primarily due to increased contractual transportation for Public Transit. 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 136,062 194,542 69.9% 130,273 188,670 69.0% 115,620 174,956 66.1% 121,705 188,365 64.6% 135,253 235,949 57.3% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Community Development $250,000 February 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 February of 11.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 February 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 % of Annual February YTD Annual Expenditures Expenditures * Expenditures 180,457 272,326 66.3% 174,211 259,944 67.0% 178,359 273,179 65.3% 192,684 292,983 65.8% 205,936 308,685 66.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 February 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 February are 6.9% higher than the same period in the prior fiscal year. The increase is primarily due to encumbering the annual contract amount for services from the Greater Phoenix Convention and Visitors Bureau. In past years, this amount was recorded on a monthly basis and not encumbered for the whole 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 February YTD Annual % of Annual Expenditures Expenditures * Expenditures 383,537 577,118 66.5% 361,325 545,198 66.3% 363,671 555,711 65.4% 391,423 599,837 65.3% 420,578 642,924 65.4% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services $700,000 February 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 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 7.4% higher through February than the same period in the prior fiscal year. The budgeted increase for fiscal year 2017-18 over fiscal year 2016-17 actuals is 7.2%. 8 February 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 February Annual YTD Expenditures % of Annual Expenditures * Expenditures 67,188 100,524 66.8% 89,798 134,594 66.7% 101,790 154,710 65.8% 91,709 137,205 66.8% 71,062 106,552 66.7% * - 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 February 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 February are 22.5% 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) 17-18 (YTD) $ 315,502 $ 586,634 $ 172,105 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 $ 547,090 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. The Aviation department has spent or encumbered $430 million on the PHX Sky Train extension, $25 million on Apron and Taxiway improvements, and $13 million on the terminal 4 south 1 concourse through February 2018. - 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 15-16 $ 17-18 (Budget) 16-17 24,554 Discussion: $ 21,885 $ 29,116 17-18 (YTD) $ 15,878 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 $10,000 17-18 (Budget) 16-17 $ 7,460 $ 29,555 $20,000 $30,000 $40,000 17-18 (YTD) $ 8,399 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 $ 188,138 $ 25,819 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 $ 296,159 $ 90,056 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 February 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 February YTD Revenues 666,704 677,195 685,349 698,348 754,524 14-15 Annual Revenues* 1,026,167 1,048,053 1,063,211 1,094,933 1,129,621 15-16 16-17 17-18 % of Annual Revenues 65.0% 64.6% 64.5% 63.8% 66.8% * - For prior years - total actual revenues, for current year - total approved budget Better than Expected Fiscal year 2017-18 general fund operating revenues are budgeted to increase 3.2% over prior year actuals. Actual revenues through February are 8.0% higher 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 270,000 240,000 210,000 94,664 91,021 180,000 35,205 150,000 Secondary 50,483 49,568 120,000 55,582 90,000 60,000 143,931 138,243 141,310 153,454 146,121 Primary 89,970 30,000 13-14 FY 13-14 14-15 15-16 16-17 17-18 YTD 17-18 budget Total 179,136 187,811 191,793 237,142 145,552 248,118 July (1,260) (1,107) (981) (1,004) (1,055) (1,244) 14-15 Aug Sept 971 867 760 816 641 857 454 773 (395) 891 746 984 15-16 Oct 11,107 12,338 15,224 12,067 16,220 15,943 Nov 46,645 63,660 60,232 57,953 87,691 73,157 16-17 Dec 32,028 18,028 21,975 51,488 25,018 36,807 17-18 YTD Jan 7,180 8,869 8,268 10,013 10,162 10,922 Feb 3,818 2,958 3,815 4,033 7,020 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 Better than Expected Because property taxes are primarily collected in October through December and 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. Through February, property tax collections are 2.7% above budget expectations. 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,205 138,243 49,568 141,310 50,483 146,121 91,021 89,970 55,582 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 February, local sales tax revenues are 2.3% above prior year actuals. 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 20,000 18,000 16,000 14,000 17-18 Actuals 12,000 10,000 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 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 February, state shared sales tax revenues are 9.7% above budget expectations. State Sales Tax 3 Year Trend 20,000 18,000 16,000 14,000 12,000 15-16 Actuals 10,000 16-17 Actuals 8,000 17-18 Actuals 6,000 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. Through February 2018 state shared sales tax revenues were 13.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 February 2018 are 14.6% 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 Better than Expected Governmental funds are those funds supported primarily through taxes, bonds and grants and include the general fund as well as funds with dedicated tax revenue streams. They do not include the enterprise funds. Governmental fund revenues through February 2018 are 1.6% higher than budget expectations. 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 (40,000.00) July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June 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. Through February 2018, governmental funds revenues are 5.1% higher than the same period in 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 45,000 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 February 2018 are 9.6% higher than budget expectations for the period. Aviation Operating Revenues 3 Year Trend 50,000 40,000 30,000 15-16 Actuals 20,000 16-17 Actuals 17-18 Actuals 10,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 February 2018, aviation operating revenues are 6.7% 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 February 2018 are 5.2% higher than budget expectations for the period. The higher revenues are primarily due to increased water consumption resulting from the exceptionally warm and dry weather the valley has been experiencing. Water System Operating Revenues 3 Year Trend 60,000 50,000 40,000 15-16 Actuals 30,000 16-17 Actuals 20,000 17-18 Actuals 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 February 2018, water system revenues are 6.5% 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 February 2018 are 6.1% 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 FEBRUARY 28 (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 280,413 $ 2,135 273,993 1,107 148,964 196,303 62,706 153,454 2,896 10,090 106,598 133,357 46,489 89,970 1,916 5,514 93,664 127,565 39,856 83,623 1,801 5,213 10,365 1,164 13,644 740 7,658 2,106 4,339 8,545 725 9,362 8,407 4,877 1,209 4,549 7,479 636 8,965 468 4,645 1,131 4,298 35,000 1,400 11,613 3,908 15,469 23,876 620 8,799 4,206 12,958 22,421 8,392 2,488 10,604 1,129,621 - 22 - $ $ 754,524 $ 698,348 General Fund Expenditures As of FEBRUARY 28 (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,044 $ 2,260 2,244 23,547 1,392 1,508 13,576 2,013 3,017 7,118 2,388 16,326 2,718 79,151 1,048 2,219 2,300 20,806 1,256 1,370 12,540 1,555 2,711 6,707 2,384 15,753 1,946 72,595 29,241 5,081 34,322 18,455 3,181 21,636 17,644 3,031 20,675 548,803 298,471 83 847,357 355,632 189,077 229 544,938 341,592 175,409 (14) 516,987 Transportation Street Transportation Public Transit Total Transportation 18,836 1,712 20,548 11,527 1,623 13,150 9,446 1,652 11,098 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 5,091 13,281 4,157 54 22,583 3,350 8,264 2,449 32 14,095 3,004 7,146 2,601 33 12,784 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 90,983 38,766 19,141 6,338 155,228 60,672 26,087 11,122 4,912 102,793 58,286 22,253 11,146 3,887 95,572 Environmental Services Public Works Environmental Programs Total Environmental Services 13,113 618 13,731 8,808 426 9,234 13,490 258 13,748 9,672 6,534 2,102 55,900 - - Criminal Justice Municipal Court Public Defender Total Criminal Justice Public Safety Police Fire Others Total Public Safety Capital Improvement Contingencies Total Expenditures and Encumbrances 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 $ 1,277,739 - 23 - $ $ 791,531 $ 745,561 Citywide Summary Presents the City's summarized comparisons of the year-to-date balances to the fiscal year budget and to the actual results for the prior year. Citywide Operating Revenue As of FEBRUARY 28 (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 $ $ 280,413 $ 2,135 $ 273,993 1,107 148,964 196,303 62,706 153,454 2,896 10,090 11,529 13,644 740 7,658 2,106 4,339 48,013 3,908 15,469 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 106,598 133,357 46,489 89,970 1,916 5,514 9,271 9,362 8,407 4,877 1,209 4,549 33,296 4,206 12,958 93,664 127,565 39,856 83,623 1,801 5,213 8,115 8,965 468 4,645 1,131 4,298 30,813 2,488 10,604 1,129,621 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,174 277,541 99,401 754,524 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,115,124 344,541 73,179 420,570 229,962 148,669 1,216,922 $ 3,461,667 - 24 - $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 19,812 55,531 20,200 3,057 164,678 3,094 45,547 6,538 14,954 85,942 21,910 3,958 31,649 143,594 58,005 698,348 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 678,471 $ $ $ $ $ 243,935 43,091 297,431 162,144 100,580 847,182 18,853 53,841 19,259 3,443 159,351 4,287 41,164 7,251 14,426 81,724 22,950 3,856 35,847 144,582 54,521 665,356 $ $ $ $ $ 228,573 39,369 279,284 151,733 100,313 799,273 $ 2,280,177 $ 2,162,977 Citywide Operating Expenditures As of FEBRUARY 28 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2017-2018 2016-2017 Budget 2017-2018 79,151 $ 13,256 92,407 72,595 11,232 83,827 34,322 12,272 46,594 21,636 4,009 25,645 20,675 6,576 27,251 847,357 185,253 1,032,610 544,938 101,191 646,129 516,987 90,754 607,741 Transportation General Funds Other Funds Total Transportation 20,548 684,725 705,273 13,150 508,925 522,075 11,098 452,740 463,838 Community Development General Funds Other Funds Total Community Development 22,583 213,366 235,949 14,095 121,158 135,253 12,784 108,921 121,705 Community Enrichment General Funds Other Funds Total Community Enrichment 155,228 153,457 308,685 102,793 103,143 205,936 95,572 97,112 192,684 Environmental Services General Funds Other Funds Total Environmental Services 13,731 629,193 642,924 9,234 411,344 420,578 13,748 377,675 391,423 Debt Service General Funds Other Funds Total Debt Service 106,552 106,552 71,062 71,062 91,709 91,709 Capital Improvement General Funds Other Funds Total Capital Improvement 9,672 723,997 733,669 6,534 224,450 230,984 2,102 213,031 215,133 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 $ 791,531 1,558,538 $ 2,350,069 $ - 25 - 745,561 1,449,750 2,195,311 Citywide Detail Presents, in detail, the results of the City's operations for the current month and for the fiscal year-to-date. Included are breakdowns of the City's revenues, operating budget expenditures, capital budget expenditures and bonds authorized and sold. Citywide Operating Revenue by Source For the Month Ended FEBRUARY 28 2018 2017 Budget Estimate 2017-2018 Source Actual Year-to-Date 2017-2018 2016-2017 General Funds $ 36,367,876 179,127 36,547,003 $ 22,765,720 126,359 Local Taxes: Sales Taxes Privilege License Fees $ 445,511,000 2,290,000 $ 280,412,556 2,134,858 $ 273,993,171 1,106,772 22,892,079 Total Local Taxes 447,801,000 282,547,414 275,099,943 13,321,652 16,669,602 5,713,689 10,973,870 15,945,590 5,048,652 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 148,964,000 196,303,000 62,706,000 106,597,653 133,356,814 46,489,095 93,663,849 127,564,721 39,855,551 35,704,943 31,968,112 407,973,000 286,443,562 261,084,121 4,361,125 2,506,666 Primary Property Tax 153,454,000 89,969,587 83,623,182 228,189 176,270 Licenses and Permits 2,896,000 1,915,972 1,801,028 84,349 2,605,399 Cable Communications 10,090,000 5,513,568 5,213,093 1,174,226 131,894 1,034,161 118,401 Municipal Court: Fines and Forfeitures Court Default Fee 10,364,925 1,164,000 8,545,213 725,363 7,478,900 635,630 1,306,120 1,152,562 11,528,925 9,270,576 8,114,530 2,440,774 1,172,948 13,644,495 9,361,696 8,965,042 51,013 49,583 740,110 8,407,187 467,738 554,201 406,660 Parks and Recreation 7,658,381 4,877,243 4,645,470 Total State Shared Taxes Total Municipal Court Police Library Fees 178,306 148,482 Planning and Development 2,106,481 1,209,066 1,131,319 1,351,981 911,679 Street Transportation 4,339,350 4,548,570 4,297,716 3,617,371 128,800 765,739 2,938,920 45,200 769,003 35,000,000 1,400,000 11,612,884 23,876,431 620,250 8,799,290 22,420,913 527,871 7,864,131 4,511,910 3,753,123 48,012,884 33,295,971 30,812,915 553,744 347,286 1,309,330 1,206,851 89,182,988 69,297,700 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire Interest Other Fees and Service Charges Total General Funds 26 3,908,000 4,205,586 2,487,726 15,468,866 12,958,093 10,603,726 1,129,621,492 754,524,091 698,347,549 Citywide Operating Revenue by Source (continued) For the Month Ended FEBRUARY 28 2018 2017 Budget Estimate 2017-2018 Source Actual Year-to-Date 2017-2018 2016-2017 Special Revenue and Debt Service Funds $ 1,800,472 128,605 643,026 23,714 $ 2,595,817 5,319,739 1,767,006 144,336 $ $ $ 7,231,081 2,755,954 424,334 0 194,610 (724) 24,515 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 1,524,077 Total Neighborhood Protection 3,292,730 1,145,381 1,541 4,439,652 $ $ $ $ $ $ 642,735 17,540,102 3,286,568 1,052,141 75,154 375,764 21,018 1,553,000 475,945 0 230,316 (116) 80,481 786,626 $ $ 20,826,670 10,182,892 4,858,104 15,040,996 0 $ 0 5,633,031 $ 3,788,051 920,351 $ 284,484 1,212,816 42,529 1,255,345 $ $ 1,202,233 23,939 1,226,172 $ Public Safety Enhancement & Expansion: Police Fire Interest/Other Total Public Safety Enhancement & Expansion Parks and Preserves Golf Courses: Fees Coffee Shops Concessions Interest Other 21,930,000 1,567,000 7,832,000 365,000 $ 13,505,443 964,674 4,823,373 518,356 $ 12,948,550 924,897 4,624,482 355,431 31,694,000 19,811,846 18,853,360 66,423,000 22,518,000 54,000 41,222,757 14,062,889 245,706 39,770,186 13,634,542 436,603 88,995,000 55,531,352 53,841,331 31,853,000 20,199,840 19,258,532 3,552,200 0 2,172,725 (2,000) 219,275 1,861,398 0 969,158 (4,549) 231,309 1,979,917 0 1,311,908 (959) 151,987 5,942,200 3,057,316 3,442,853 210,700,000 51,376,890 131,563,246 33,115,041 124,597,972 34,753,505 262,076,890 164,678,287 159,351,477 4,847,340 3,094,324 4,287,460 Planning and Development 53,948,800 45,547,353 41,163,789 Capital Construction 11,076,000 6,537,529 7,250,884 Sports Facilities: Sales Taxes Interest/Other 19,235,000 8,852,016 10,304,558 4,649,882 9,839,957 4,585,630 28,087,016 14,954,440 14,425,587 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 FEBRUARY 28 2018 2017 Budget Estimate 2017-2018 Source Actual Year-to-Date 2017-2018 2016-2017 Special Revenue and Debt Service Funds (Cont'd) $ 9,965,637 104,593 0 14,636,671 64,785 1,200 10,070,230 14,702,656 - $ - Highway User Revenue: Highway User Revenue Interest Other Total Highway User Revenue Local Transportation Assistance 127,531,000 500,000 150,000 85,114,765 816,057 11,400 80,998,649 434,829 290,793 128,181,000 85,942,222 81,724,271 0 0 0 2,713,782 2,573,809 Regional Transit Revenues 38,214,960 21,909,631 22,949,903 323,915 1,208,926 Community Reinvestment 5,091,810 3,958,111 3,855,933 2,159,580 6,376,130 Other Restricted Fees 48,173,904 31,649,278 35,847,380 929,536 5,750,866 405,448 422,948 5,648,344 784,819 Grants: Public Housing: Rentals Grants Other 7,274,000 81,683,028 8,694,844 5,189,097 48,422,774 5,752,296 4,995,722 47,091,159 9,754,152 7,085,850 6,856,111 97,651,872 59,364,167 61,841,033 3,582,919 10,118,316 4,057,353 2,744,573 3,724,347 4,752,131 2,872,326 2,735,108 46,031,773 53,696,411 30,138,429 50,022,756 25,881,782 24,899,846 4,550,452 28,898,205 23,921,621 23,508,824 10,219,423 25,091,336 20,503,161 14,083,912 Total Other 179,889,369 84,230,285 82,741,204 27,589,011 20,940,023 Total Grants 277,541,241 143,594,452 144,582,237 94,663,937 4,736,652 55,582,978 2,421,650 52,152,979 2,368,483 2,658,120 0 1,526,132 0 2,658,120 1,526,132 87,375,622 75,970,734 $ Total Public Housing Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond/Secondary Property Tax Secondary Property Tax Interest 99,400,589 58,004,628 54,521,462 Total Special Revenue and Debt Service Funds 1,115,123,750 678,470,609 665,356,459 137,700,000 195,960,000 1,500,000 4,262,700 2,142,000 2,976,500 0 69,955,637 163,193,306 2,792,803 3,566,571 1,732,115 1,956,388 738,474 66,617,523 155,862,498 1,367,229 722,905 1,561,580 1,979,541 461,423 344,541,200 243,935,294 228,572,699 Total G.O. Bond/Secondary Property Tax Enterprise Funds AVIATION: 8,955,132 20,446,743 372,597 361,150 207,360 256,499 71,604 8,446,400 19,577,145 173,425 249,740 176,473 233,114 44,562 30,671,085 28,900,859 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge Total Aviation 28 Citywide Operating Revenue by Source (continued) For the Month Ended FEBRUARY 28 2018 2017 Budget Estimate 2017-2018 Source Actual Year-to-Date 2017-2018 2016-2017 Enterprise Funds (Cont'd) CONVENTION CENTER: $ 3,831,209 1,828,735 52,071 2,794,058 2,246,061 36,801 5,712,015 5,076,920 20,385,305 460,509 383,068 624,265 158,640 271,778 420,325 17,370,461 423,799 406,530 265,169 178,680 213,539 364,596 22,703,890 19,222,774 Excise Taxes Operating Revenue Interest Total Convention Center 51,897,000 20,958,163 323,835 29,830,521 12,845,892 414,297 28,024,876 11,054,779 289,721 73,178,998 43,090,710 39,369,376 396,920,000 5,800,000 4,270,000 6,168,000 3,600,000 2,279,000 1,533,000 275,996,564 3,983,650 3,567,019 4,087,804 2,442,004 2,052,163 5,302,141 260,897,066 3,219,934 3,946,303 4,133,362 2,315,430 1,690,108 3,082,183 420,570,000 297,431,345 279,284,386 195,418,000 17,259,000 3,600,000 1,664,000 12,021,000 133,588,933 12,564,129 2,379,420 2,018,816 11,593,195 126,365,615 13,020,492 2,168,940 1,311,700 8,866,593 229,962,000 162,144,493 151,733,340 130,245,000 8,300,000 625,000 9,499,411 87,161,337 4,667,975 482,229 8,268,578 86,222,263 5,564,745 467,119 8,059,132 148,669,411 100,580,119 100,313,259 1,216,921,609 847,181,961 799,273,060 WATER SYSTEM: $ Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System WASTEWATER: 16,574,398 1,539,786 135,840 208,525 1,040,484 15,783,293 1,420,016 138,780 172,746 1,079,203 19,499,033 18,594,038 10,932,835 301,518 62,958 499,875 10,792,145 578,477 61,281 1,161,650 11,797,186 12,593,553 90,383,209 84,388,144 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: $ 266,941,819 $ 229,656,578 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds $ Total Operating Revenues 29 3,461,666,851 $ 2,280,176,661 $ 2,162,977,068 Citywide Operating Expenditures by Program For the Month Ended FEBRUARY 28 2018 2017 Program Budget Estimate 2017-2018 2017-2018 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2017-2018 2016-2017 General Government $ 120,300 264,412 283,748 6,850,799 53,715 197,303 199,304 1,463,997 215,867 356,357 2,071 458,497 51,787 29,404 152,448 6,843 261,608 968,920 197,499 12,134,879 $ 113,274 250,110 286,861 3,489,662 223,877 (21,017) 176,697 1,307,559 200,787 198,721 13,841 963,904 53,174 47,725 161,146 6,809 258,435 2,943,632 2,803,426 13,478,623 Mayor $ City Council City Manager Information Technology Services Government Relations Public Information Equal Opportunity Law City Auditor City Clerk Elections Human Resources Manager's Office of Sustainability Phx Community Development Invst Corp Retirement Systems Phoenix Employment Relations Board Budget and Research Finance Regional Wireless Cooperative Total General Government 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 $ 1,043,680 2,259,693 2,447,786 31,658,710 666,864 1,665,349 1,840,238 14,536,854 2,013,462 3,016,586 489,223 7,784,630 474,313 246,359 1,017,573 69,670 2,387,709 18,880,565 (92,222) $ 1,048,007 2,219,257 2,545,690 22,743,289 758,028 1,316,140 1,614,087 13,426,642 1,555,361 2,710,948 171,722 7,751,110 477,012 408,590 469,900 73,862 2,383,594 20,260,187 1,893,830 $ 1,043,680 2,259,693 2,447,786 23,948,796 666,864 1,665,349 1,840,238 14,536,854 2,013,462 3,016,586 489,223 7,317,604 474,313 246,359 1,017,573 69,670 2,387,709 17,744,145 (92,222) 7,709,914 467,026 1,136,420 - 147,657,166 92,407,042 83,827,256 83,093,682 9,313,360 41,513,195 5,080,998 - 22,464,044 3,181,230 - 24,220,105 3,030,707 - 19,741,310 3,181,230 - 2,722,734 - 46,594,193 25,645,274 27,250,812 22,922,540 2,722,734 677,593,110 353,985,691 1,031,393 422,250,479 223,204,619 674,282 404,037,097 203,165,804 537,773 420,530,773 220,351,318 674,282 1,719,706 2,853,301 - 1,032,610,194 646,129,380 607,740,674 641,556,373 4,573,007 Criminal Justice 2,647,550 385,324 - 3,071,598 374,375 - 3,032,874 3,445,973 Municipal Court Public Defender Other Total Criminal Justice Public Safety 51,564,038 24,428,602 69,754 45,299,648 23,596,322 83,272 76,062,394 68,979,242 Police Fire Other Total Public Safety -30- Citywide Operating Expenditures by Program (continued) For the Month Ended FEBRUARY 28 2018 2017 Budget Estimate 2017-2018 Program 2017-2018 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2017-2018 2016-2017 Transportation $ 5,238,913 1,679,167 22,738,575 10,390,838 40,047,493 $ 3,190,008 918,756 23,452,858 8,840,751 Street Transportation Street Lighting Aviation Public Transit 36,402,373 Total Transportation $ 71,996,080 11,770,967 310,554,884 310,950,911 $ 47,866,412 8,284,699 195,434,788 270,489,491 $ 38,757,739 7,466,277 192,819,360 224,794,717 $ 46,655,244 8,284,699 154,874,139 225,693,491 1,211,168 40,560,649 44,796,000 705,272,842 522,075,390 463,838,093 435,507,573 86,567,817 60,933,593 95,454,581 29,490,369 50,070,115 34,940,146 58,171,040 17,168,406 24,972,915 30,597,044 56,013,645 16,659,834 18,434,566 34,940,146 58,122,466 14,795,351 24,972,915 48,574 2,373,055 - 235,948,658 135,252,507 121,705,089 132,830,878 2,421,629 101,201,405 39,661,235 5,842,725 65,115,039 20,325,455 67,056,229 5,055,056 4,427,907 66,535,900 26,480,282 4,379,490 47,249,056 12,126,836 42,345,520 3,845,348 2,973,878 62,981,772 22,524,229 3,942,292 43,360,253 12,196,953 41,583,461 3,318,526 2,776,606 66,274,502 26,480,282 4,379,490 33,956,801 41,927,665 3,845,348 2,973,878 261,398 13,292,255 12,126,836 417,855 - 308,685,051 205,936,310 192,684,092 179,837,966 26,098,344 Community Development 4,535,919 7,020,554 1,967,098 2,146,424 3,516,198 6,504,952 2,390,453 2,396,141 15,669,995 14,807,744 Planning and Development Housing Economic Development Neighborhood Services Department Total Community Development Community Enrichment 7,501,262 2,465,774 548,443 4,499,952 984,273 4,968,245 292,392 412,607 5,965,001 2,653,956 460,131 4,420,133 980,382 5,544,764 401,256 111,562 21,672,948 20,537,185 Parks and Recreation Library Golf Convention Center Sports and Cultural Facilities Human Services Public Parking Facilities Other Total Community Enrichment -31- Citywide Operating Expenditures by Program (continued) For the Month Ended FEBRUARY 28 2018 2017 Budget Estimate 2017-2018 Program 2017-2018 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2017-2018 2016-2017 Environmental Services $ 23,092,687 11,863,244 9,176,361 347,024 24,281 44,503,597 $ 18,541,781 11,343,388 7,079,046 6,402,877 96,910 43,464,002 Water System Wastewater Solid Waste Management Public Works Environmental Programs Total Environmental Services $ 327,420,239 150,448,181 142,138,658 21,558,832 1,357,601 $ 218,977,979 99,654,201 88,550,763 12,254,932 1,140,264 $ 191,245,095 94,935,321 86,335,962 18,607,644 299,358 $ 145,957,989 54,244,154 83,571,130 8,829,345 1,140,264 73,019,990 45,410,047 4,979,633 3,425,587 126,835,257 642,923,511 420,578,139 391,423,380 293,742,882 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 131,367 7,593,511 10,221,957 514,780 2,946,506 223,317 8,196,088 1,169,101 6,101,921 3,212,875 410,514 8,999,239 200 3,957,686 2,722,989 1,210,816 358,396 1,388,947 8,001,762 3,350,397 4,100 345,286 131,367 10,333,036 18,476,869 552,163 3,007,958 224,742 8,881,746 1,374,235 4,694,196 4,283,373 846,021 9,117,868 260,200 4,567,934 3,551,215 1,446,788 659,413 922,617 10,571,845 3,379,514 4,100 4,421,744 131,367 7,593,511 10,221,957 514,780 2,946,506 223,317 8,196,088 1,169,101 6,101,921 3,212,875 410,514 8,999,239 200 3,957,686 2,722,989 1,210,816 358,396 1,388,947 8,001,762 3,350,397 4,100 345,286 - 71,061,755 - General Obligation Debt Service 16,421 947,611 1,277,744 64,347 368,313 27,915 1,024,511 146,137 747,390 400,804 51,314 1,122,011 25 494,711 340,374 151,099 172,929 997,685 418,800 512 43,161 16,421 1,291,209 2,287,131 68,917 375,397 27,915 1,108,955 171,215 586,534 535,036 105,398 1,138,765 32,525 569,639 443,901 180,849 165,000 115,327 1,317,551 421,862 513 552,718 8,813,814 11,512,778 Total Debt Service 106,552,239 71,061,755 91,708,944 36,766,509 17,918,914 Capital Improvement 733,669,374 230,983,703 215,133,388 Contingencies 103,400,000 $ 258,704,503 230,546,834 Aviation Civic Plaza Cultural Facilities Downtown Development Early Redemption Economic Development Fire Protection Freeway Mitigation Historic/Neighborhood Preservation Human Services Information Systems Libraries Maintenance Service Centers Mountain Preserves/Parks MEGA Real Estate Municipal Administration Buildings Police Protection Public Housing Renovation Public Housing Sanitary Sewers Secondary Property Tax Solid Waste Enterprise Bonds Storm Sewer Improvements Street Improvements Street Light Refinancing Public Transit Water System - 4,063,313,228 2,350,069,500 -32- 2,195,311,728 - - - - 1,860,553,649 258,532,148 Capital Expenditures and Encumbrances 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 Budget $ 1,057,899 $ 9,652,500 1,200,000 21,318,325 1,647,511 17,361,537 924,988 23,626,766 600,000 57,679,245 1,808,939 4,409,052 76,133,228 91,975,498 7,607,558 269,631,234 16,098 $ 4,380,023 705,743 7,408,973 1,093,024 85,895 7,837,260 35,816,569 5,520,637 174,266 13,417,538 22,221,464 128,160 73,299,184 General Government Subtotal$ 586,634,280 $ 172,104,835 $ Enterprise Aviation Phoenix Convention Center Solid Waste Disposal Wastewater Water System Enterprise Subtotal Total Capital Budget Program $ $ 681,775,068 29,116,250 29,555,081 188,138,112 296,158,586 1,224,743,097 $ 1,811,377,377 2016-2017 Actual Yearto-Date Actual Yearto-Date $ $ 547,090,265 15,877,876 8,398,798 25,818,663 90,055,676 687,241,278 $ 859,346,112 From Operating Funds Budget Actual 54,000 $ 6,406,759 698,825 850,616 571,678 239,121 4,186,216 15,682,969 128,453 547,327 16,855,100 324,966 28,557,325 1,208,262 46,283,958 122,595,575 $ $ 102,833,366 13,942,510 5,760,982 30,305,107 78,533,318 231,375,283 $ 353,970,858 $ $ 2017-2018 Year-to-Date Capital Amounts From Capital Funds Budget Actual Unencumbered Budget 43,899 $ 9,652,500 1,200,000 9,528,325 1,126,181 6,100,000 13,639,174 12,590,579 730,000 2,175,240 55,193,888 84,699,646 168,788,112 $ 4,380,023 705,743 992,129 3,296,012 5,362,634 5,306,318 76,696 11,802,042 22,217,223 42,918,921 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 $ 6,416,844 1,093,024 85,895 4,541,248 30,453,935 214,319 97,570 1,615,496 4,241 128,160 30,380,263 1,041,801 5,272,477 494,257 13,909,352 1,647,511 16,268,513 839,093 15,789,506 600,000 21,862,676 (3,711,698) 4,234,786 62,715,690 69,754,034 7,479,398 196,332,050 365,467,544 $ 97,057,741 221,166,736 $ 75,047,094 414,529,445 $ 108,133,092 6,617,250 22,094,151 73,279,918 158,077,419 368,201,830 47,770,768 864,855 4,250,719 20,104,328 60,935,292 $ 133,925,962 $ 733,669,374 $ 230,983,703 - 33 - $ $ $ $ 573,641,976 22,499,000 7,460,930 114,858,194 138,081,167 856,541,267 $ 1,077,708,003 $ $ $ 499,319,497 15,013,021 4,148,079 5,714,335 29,120,384 553,315,316 $ $ 134,684,803 13,238,374 21,156,283 162,319,449 206,102,910 537,501,819 $ 628,362,410 $ 952,031,265 Bonds Authorized and Sold As of FEBRUARY 28 (dollars in thousands) Authorized Sold Available 1988 Authorizations General Obligation Bonds Freeway Mitigation, Neighborhood Stabilization, and Slum and Blight Elimination $ Bonds Fully Issued 29,285 884,175 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 Total General Obligation Bonds Revenue Bonds Bonds Fully Issued Total 1988 Authorizations $ 2001 Authorization General Obligation Bonds Education, Youth and Family Cultural Facilities Computer Technology Environmental Cleanup Fire Protection Historic Preservation Library Facilities Street Improvements Neighborhood Protection and Senior Centers Parks, Open Space, and Recreational Facilities Police Protection Storm Sewer and Flood Protection Bonds Fully Issued Total 2001 Authorizations 2006 Authorization General Obligation Bonds Affordable Housing and Neighborhood Revitalization Computer Technology Education and Health Science Facilities Environmental Cleanup Family, Senior, and Youth Cultural Facilities Fire Protection Library Facilities and Improvements Parks, Open Space, and Recreational Facilities Police Protection Street Improvements Storm Sewer and Flood Protection Total 2006 Authorizations Total Bond Program - 34 - $ 152,355 Appendix A Additional historic and trend information for various revenue streams. Local Sales Tax (Dollars in Thousands) Local Sales Tax 50,000 13-14 Actuals 14-15 Actuals 40,000 15-16 Actuals 16-17 Actuals 30,000 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 July 36,360 35,365 34,740 35,857 17,068 37,597 Aug Sept Oct Aug 35,589 36,414 35,137 36,805 43,895 38,025 Sept 35,873 35,290 35,079 34,012 33,757 37,050 Oct 35,068 34,621 35,459 38,800 42,559 38,026 Nov Nov 34,363 33,033 34,433 32,023 31,868 35,359 Dec Dec 32,474 35,062 32,783 35,135 33,857 35,783 Jan Jan 40,116 37,227 37,567 38,595 41,041 40,551 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 2016-17 actual expenditures. Return to Summary Page - A1 - Feb Feb 32,084 34,432 32,793 22,766 36,368 32,248 Mar YTD thru February 281,928 281,442 277,990 273,993 280,413 294,639 Apr Mar 32,147 34,938 33,135 33,502 35,325 May 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 20,000 13-14 Actuals 14-15 Actuals 15,000 15-16 Actuals 16-17 Actuals 10,000 17-18 Actuals 17-18 budget 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 Sept 10,012 10,552 11,237 11,658 17,561 11,972 Nov Oct 9,923 10,307 10,688 11,195 10,963 11,601 Dec Nov 9,673 10,295 11,100 11,443 13,678 11,711 Jan Dec 10,296 10,695 11,623 11,913 13,707 12,266 Feb Jan 12,744 13,173 13,760 14,184 13,334 14,838 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 2016-17 actual expenditures. Return to Summary Page - A2 - Mar Feb 10,430 10,244 10,375 10,974 13,322 11,576 Apr YTD thru February 83,001 86,082 90,075 93,664 106,598 97,195 May 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 17-18 budget Aug July 4,752 4,963 5,095 5,712 9,008 5,635 Sept Aug 4,663 5,004 5,133 4,393 4,830 5,270 Oct Sept 3,992 3,749 4,087 4,846 5,152 4,578 Nov Dec Jan Feb Oct 3,912 4,415 4,922 5,181 5,670 5,060 Nov 3,958 4,198 4,291 4,242 4,904 4,582 Dec 3,872 3,857 4,550 4,826 5,741 4,697 Jan 3,936 4,661 5,195 5,607 5,470 5,326 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 2016-17 actual expenditures. Return to Summary Page - A3 - Mar Feb 4,799 4,920 5,024 5,049 5,714 5,435 Apr YTD thru February 33,883 35,767 38,298 39,856 46,489 40,583 May 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 300,100.00 2013-14 Actuals 2014-15 Actuals 250,100.00 2015-16 Actuals 200,100.00 2016-17 Actuals 2017-18 Actuals 150,100.00 17-18 budget 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 Aug 137,320 138,394 155,197 165,819 185,527 167,452 Sept Sept 157,974 133,016 129,829 157,173 176,701 162,857 Oct Nov Dec Oct 143,773 155,801 160,655 165,460 189,075 175,318 Nov 188,461 193,744 195,040 212,320 226,848 220,751 Dec 169,767 162,290 172,648 218,635 192,262 203,156 Jan Jan 153,911 151,099 160,567 173,436 187,522 179,104 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 2016-17 actual expenditures. Return to Summary Page - A4 - Feb Feb 132,551 144,296 141,861 145,268 176,559 158,535 Mar Apr May YTD thru February 1,209,468 1,206,602 1,244,386 1,363,704 1,432,995 1,409,782 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,373 June 177,153 167,673 244,902 225,798 230,221 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 Sept Oct July 31,036 27,544 28,758 28,314 26,403 29,090 Aug 22,760 26,594 27,373 29,777 34,965 26,789 Sept 26,677 27,855 28,151 29,279 30,148 28,162 Nov Oct 26,505 26,489 29,050 28,339 29,291 27,765 Dec Nov 26,222 27,610 29,039 30,504 21,702 28,517 Jan Dec 27,171 27,853 25,795 24,926 38,212 26,598 Feb Jan 26,659 27,917 28,789 28,532 32,543 28,145 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 2016-17 actual expenditures. Return to Summary Page - A5 - Mar Feb 26,561 26,683 27,161 28,901 30,671 27,494 Apr YTD thru February 213,592 218,547 224,116 228,573 243,935 222,560 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 60,000 13-14 Actuals 14-15 Actuals 50,000 15-16 Actuals 40,000 16-17 Actuals 17-18 Actuals 30,000 17-18 budget 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 Sept 41,144 36,711 42,235 43,613 44,819 43,437 Nov Oct 34,917 30,601 34,778 37,360 39,391 36,526 Dec Nov 34,774 32,130 30,252 34,083 38,890 34,823 Jan Dec 22,327 24,573 24,406 26,073 27,184 25,839 Feb Mar Apr May Jan 22,872 21,031 22,460 21,608 25,186 23,342 Feb 21,185 19,044 19,179 19,223 22,704 20,864 YTD thru February 268,373 254,939 263,424 279,284 297,431 282,859 Mar 21,993 20,725 24,487 20,925 23,385 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 2016-17 actual expenditures. Return to Summary Page - A6 - 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 Sept 18,224 18,337 21,171 19,337 19,811 19,945 Nov Oct 17,798 17,754 18,058 18,611 20,195 18,690 Dec Nov 20,452 17,529 17,530 18,347 20,386 19,114 Jan Dec 17,763 18,276 18,697 19,493 20,097 19,210 Feb Jan 17,618 18,183 19,384 19,155 20,584 19,239 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 2016-17 actual expenditures. Return to Summary Page - A7 - Mar Feb 18,058 17,960 18,385 18,594 19,499 18,891 Apr YTD thru February 145,800 144,883 147,859 151,733 162,144 152,758 May Mar 14,986 17,538 18,659 19,618 18,323 June 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