December 2016 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division City of Phoenix Monthly Financial Report December 2016 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 Better than Expected Community Development 3 Better than Expected From any page of the report, click on the Community Enrichment 4 Better than Expected City of Phoenix Bird Emblem to return to the Environmental Services 4 Better than Expected Table of Contents Citywide Expenditures Citywide Total Operating Expenditures 5 Better than Expected General Government 5 Better than Expected Criminal Justice 6 Better than Expected Performance Status Public Safety 6 Better than Expected Better than Expected - Positive variance of Transportation 7 Better than Expected greater than 1% actual vs budget. Community Development 7 Better than Expected Expected - Actual vs budget variance within 1% Community Enrichment 8 Expected Environmental Services 8 Better than Expected General Obligation Debt Service 9 Monitor and Consider Taking Action positive or negative. Monitor and Consider Taking Action - Negative variance greater than 1% actual vs budget. Capital Expenditures CIP-General Government 10 Corrective Action Taken - Negative variance CIP-Aviation 10 greater than 1% actual vs budget, however the CIP-Phoenix Convention Center 11 City has taken action to address the negative CIP-Solid Waste Disposal 11 variance. CIP-Wastewater 12 CIP-Water System 12 Revenues by Source General Fund Total Operating Revenue Page 13 Performance Status Better than Expected 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 Expected Governmental Funds 18 Expected Aviation 19 Better than Expected Water System 20 Expected Wastewater 21 Better than Expected Financial Schedules General Fund Revenue Page 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. December General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Total General Fund Expenditures 12-13 13-14 14-15 15-16 16-17 December YTD Annual % of Annual Expenditures Expenditures * Expenditures 534,953 1,038,092 51.5% 537,686 1,042,102 51.6% 540,413 1,051,395 51.4% 550,771 1,066,521 51.6% 567,986 1,139,061 49.9% * - 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,200,000 $1,200,000 $1,000,000 $1,000,000 December YTD December YTD Expenditures Expenditures $800,000 $800,000 $600,000 $600,000 $400,000 $400,000 $200,000 $200,000 $0 $0 Annual Annual Expenditures * Expenditures * 12-13 13-14 12-13 14-15 15-16 16-17 13-14 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 2016-17 budgeted general fund expenditures are 6.8% higher than the fiscal year 2015-16 actuals. Through December 2016, actual general fund expenditures are 3.1% higher than the same period in fiscal year 2015-16. General fund expenditures have gradually increased over the past 4 years with FY2015-16 expenditures 2.7% higher than FY2012-13. General Government 12-13 13-14 14-15 15-16 16-17 December YTD Annual % of Annual Expenditures Expenditures * Expenditures 54,085 102,211 52.9% 56,460 100,400 56.2% 50,643 96,385 52.5% 57,652 105,240 54.8% 57,725 114,998 50.2% * - 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 December YTD Expenditures December YTD Expenditures $80,000 $60,000 Annual Expenditures * $60,000 $40,000 $40,000 $20,000 $20,000 Annual Expenditures * $0$0 12-1312-1313-14 13-14 15-16 14-15 14-15 16-17 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 2016-17 budget includes a 9.3% increase over fiscal year 2015-16 actuals, primarily due to anticipated increases in personal services costs. General fund general government expenditures through December 2016 are 0.1% higher than the same period in the prior year. The increase in personal services costs has been less than anticipated and contractual services costs are much lower than anticipated through December 2016. Fiscal year 2015-16 general fund general government expenditures were 3.0% higher than the fiscal year 2012-13 expenditures following two successive years of decreases in spending. -1- December General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Criminal Justice 12-13 13-14 14-15 15-16 16-17 December YTD Annual % of Annual Expenditures Expenditures * Expenditures 17,366 33,453 51.9% 17,057 32,659 52.2% 16,331 31,018 52.7% 17,589 30,698 57.3% 15,623 33,206 47.0% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice Public Safety $40,000 $40,000 $35,000 $35,000 $30,000 $30,000 $25,000 $25,000 $20,000 $20,000 $15,000 $15,000 $10,000 $5,000 $10,000 $0 $5,000 December YTD Expenditures December YTD Expenditures Annual Expenditures * Annual Expenditures * 12-13 13-14 14-15 $0 12-13 13-14 14-15 15-16 16-17 Criminal justice expenditures include costs for municipal courts and public defenders. General fund criminal justice expenditures through December 2016 are 11.2% lower than the same period in the prior year. In July 2015, the City encumbered the annual contracts for outside legal service, those contracts were not encumbered and are instead only showing as expenditures when utilized in fiscal year 2016-17. The fiscal year 2016-17 budget includes an 8.2% increase over fiscal year 2015-16 actuals. General fund criminal justice expenditures have decreased each year since fiscal year 2012-13 and were 8.2% lower in fiscal year 2015-16 than 2012-13. Public Safety 12-13 13-14 14-15 15-16 16-17 Transportation Public Safety December YTD Annual % of Annual Expenditures Expenditures * Expenditures 345,801 684,609 50.5% 354,239 699,796 50.6% 363,684 716,304 50.8% 379,953 737,129 51.5% 393,507 772,160 51.0% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $900,000 $800,000 $800,000 $700,000 $700,000 $600,000 $600,000 $500,000 $500,000 $400,000 $400,000 $300,000 $200,000 $300,000 $100,000 $200,000 $0 $100,000 12-13 13-14 $0 12-13 December YTD Expenditures December YTD Expenditures 14-15 13-14 15-16 16-17 Annual Expenditures * Annual Expenditures * 14-15 Public safety expenditures include costs for police and fire services. General fund public safety expenditures through December 2016 are 3.6% higher than the same period in the prior year. The fiscal year 2016-17 budget includes a 4.8% increase over fiscal year 2015-16 actuals. General fund public safety expenditures have been steadily increasing at 2-3% per year since fiscal year 2012-13 - 2- December General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Transportation 12-13 13-14 14-15 15-16 16-17 December YTD Annual % of Annual Expenditures Expenditures * Expenditures 20,815 38,161 54.5% 16,898 29,713 56.9% 19,079 34,187 55.8% 8,065 17,473 46.2% 9,165 21,924 41.8% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Community Development Transportation $45,000 $40,000 $40,000 $35,000 $35,000 $30,000 $30,000 $25,000 $25,000 $20,000 $20,000 $15,000 $15,000 $10,000 $10,000 $5,000 $5,000 $0 $0 December YTD Expenditures December YTD Expenditures Annual Annual Expenditures * Expenditures * 12-13 12-13 13-14 13-14 14-15 15-16 14-15 16-17 Transportation expenditures include costs for public transit and street maintenance and repair. General fund transportation expenditures through December 2016 are 13.6% higher than the same period in the prior year. The fiscal year 2016-17 budget includes a 25.5% increase over fiscal year 2015-16 actuals. 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 Community Enrichment Community Development 12-13 13-14 14-15 15-16 16-17 December YTD Annual % of Annual Expenditures Expenditures * Expenditures 10,423 19,927 52.3% 11,060 20,210 54.7% 10,333 18,986 54.4% 10,146 18,571 54.6% 9,960 21,554 46.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $25,000 $25,000 December DecemberYTD YTD Expenditures Expenditures $20,000 $20,000 $15,000 $15,000 $10,000 $10,000 Annual Expenditures * Annual Expenditures * $5,000 $5,000 $0 $0 12-13 12-13 13-14 13-14 14-15 15-16 14-15 16-17 Community development expenditures include costs for economic development and neighborhood services. The fiscal year 2016-17 budget includes a 16.1% increase over fiscal year 2015-16 actuals primarily due to an anticipated increase of 16.5% in personal services costs. General fund community development expenditures through December 2016 are 1.8% lower than the same period in the prior year with a 2.1% increase in personal services costs. General fund community development expenditures showed a year over year decrease for the second straight year in fiscal year 2015-16. The decreases have fiscal year 2015-16 expenditures 8.1% lower than fiscal year 2013-14 and 6.8% lower than fiscal year 2012-13. -3- December General Fund YTD Expenditures (Dollars in Thousands) Community Enrichment 12-13 13-14 14-15 15-16 16-17 December YTD Annual % of Annual Expenditures Expenditures * Expenditures 75,194 141,209 53.3% 75,321 143,665 52.4% 70,388 138,024 51.0% 71,137 141,483 50.3% 74,855 151,008 49.6% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Refer to detailed financial schedules pages 22 thru 34 Environmental Services Community Enrichment $160,000 $160,000 $140,000 $140,000 $120,000 $120,000 $100,000 $100,000 $80,000 $80,000 $60,000 $60,000 $40,000 $40,000 $20,000 $20,000 $0 $0 12-13 13-14 12-13 DecemberYTD YTD December Expenditures Expenditures Annual Expenditures * Annual Expenditures * 14-15 13-14 15-16 16-17 14-15 Community enrichment expenditures include costs for parks, recreational activities, senior centers and community centers. General fund community enrichment expenditures through December 2016 are 5.2% higher than the same period in the prior year. The fiscal year 2016-17 budget includes a 6.7% increase over fiscal year 2015-16 actuals. Over the past four years, general fund community enrichment expenditures have remained relatively flat, with fiscal year 2015-16 expenditures 0.2% higher than fiscal year 2012-13. Environmental Total GeneralServices Fund Environmental Services 12-13 13-14 14-15 15-16 16-17 December YTD Annual % of Annual Expenditures Expenditures * Expenditures 10,375 15,353 67.6% 6,196 13,748 45.1% 9,367 15,082 62.1% 5,420 12,143 44.6% 5,565 14,285 39.0% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $18,000 $16,000 $14,000 $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 $0 December YTD Expenditures Annual Expenditures * 12-13 12-13 13-14 14-15 13-14 15-16 14-15 16-17 Environmental service expenditures include costs for maintaining and operating city facilities. General Fund environmental services expenditures through December 2016 are 2.7% higher than the same period in the prior year. Because of the work order credits related to the Public Works Department, the general fund environmental services expenditures can fluctuate greatly from month to month. The fiscal year 2016-17 budget includes a 17.6% increase from fiscal year 2015-16 actuals. -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. December Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Total Citywide Operating 12-13 13-14 14-15 15-16 16-17 December YTD Annual % of Annual Expenditures Expenditures * Expenditures 1,590,682 3,123,865 50.9% 1,592,454 3,054,098 52.1% 1,604,689 3,051,875 52.6% 1,632,362 3,156,441 51.7% 1,702,284 3,822,337 44.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 General Government $4,500,000 $3,500,000 $4,000,000 $3,000,000 $3,500,000 $2,500,000 $3,000,000 $2,500,000 $2,000,000 $2,000,000 $1,500,000 $1,500,000 $1,000,000 $1,000,000 $500,000 $500,000 $0 $0 Better than Expected December YTD December YTD Expenditures Expenditures Annual Annual Expenditures * Expenditures * 12-13 13-14 12-13 14-15 13-14 15-16 16-17 14-15 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 2016-17 anticipates an increase of 21.1% over prior year actuals in total operating expenditures. Actual expenditures through December 2016 are better than expected with an increase of 4.3% from the same period in the prior year. General Government 12-13 13-14 14-15 15-16 16-17 December YTD Annual % of Annual Expenditures Expenditures * Expenditures 57,297 114,015 50.3% 60,213 114,235 52.7% 56,574 108,690 52.1% 63,559 118,505 53.6% 63,147 139,120 45.4% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice General Government $120,000 $160,000 $100,000 $140,000 $120,000 $80,000 December YTD Expenditures December YTD Expenditures $100,000 $60,000 $80,000 $60,000 $40,000 Annual Expenditures * Annual Expenditures * $40,000 $20,000 $20,000 $0 12-13 12-13 13-14 14-15 13-14 16-17 15-16 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 are better than expected with a decrease of 0.6% through December 2016 from the same period in the prior year. The budget anticipates an increase of 17.4% for fiscal year 2016-17 over prior year actuals. -5- December Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Criminal Justice 12-13 13-14 14-15 15-16 16-17 December YTD Annual % of Annual Expenditures Expenditures * Expenditures 21,376 41,290 51.8% 21,205 40,697 52.1% 20,525 39,265 52.3% 21,832 39,463 55.3% 20,317 48,118 42.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Public Safety Criminal Justice $60,000 $200,000 December YTD Expenditures December YTD Expenditures $50,000 $40,000 $30,000 Annual Expenditures * Annual Expenditures * $20,000 $0 $10,000 12-13 13-14 14-15 $0 12-13 13-14 14-15 15-16 16-17 Criminal Justice expenditures include costs of the Municipal Court and the Public Defender’s office. Citywide criminal justice expenditures are 6.9% lower through December 2016 than the same period in the prior year. In July 2015, the City encumbered the annual contracts for outside legal service, those contracts were not encumbered and are instead only showing as expenditures when utilized in fiscal year 2016-17. The budgeted increase for fiscal year 2016-17 over prior year actuals is 21.9%. Public Safety 12-13 13-14 14-15 15-16 16-17 Transportation Public Safety December YTD Annual % of Annual Expenditures Expenditures * Expenditures 425,940 842,387 50.6% 427,073 842,270 50.7% 427,334 841,817 50.8% 443,269 874,558 50.7% 462,271 934,174 49.5% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $1,000,000 $900,000 $800,000 $800,000 $700,000 $600,000 $600,000 $500,000 $400,000 $400,000 $200,000 $300,000 $200,000 $0 $100,000 12-13 13-14 $0 12-13 December YTD Expenditures December YTD Expenditures 14-15 15-16 16-17 Annual Expenditures * Annual Expenditures * 13-14 Public Safety expenditures include costs of Police, Fire and Emergency Management. Citywide public safety expenditures through December 2016 are 4.3% higher than the same period in the prior year. The budgeted increase for fiscal year 2016-17 over prior year actuals is 6.8%. -6- December Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Transportation 12-13 13-14 14-15 15-16 16-17 December YTD Annual % of Annual Expenditures Expenditures * Expenditures 363,316 582,381 62.4% 367,552 573,025 64.1% 372,555 582,486 64.0% 371,252 609,990 60.9% 387,257 671,988 57.6% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Transportation Community Development $700,000 $800,000 $700,000 $600,000 $600,000 $500,000 $500,000 $400,000 $400,000 $300,000 $300,000 $200,000 $200,000 $100,000 $100,000 $0 $0 December YTD Expenditures December YTD Expenditures Annual Annual Expenditures * Expenditures * 12-13 12-13 13-14 13-14 14-15 15-16 14-15 16-17 Transportation expenditures include costs for Street lighting, maintenance and repair; Aviation and Public Transit. Citywide transportation expenditures are 4.3% higher through December 2016 than the same period in the prior year. The budgeted increase for fiscal year 2016-17 over prior year actuals is 10.2%. Community Development 12-13 13-14 14-15 15-16 16-17 December YTD Annual % of Annual Expenditures Expenditures * Expenditures 114,172 209,403 54.5% 106,934 194,542 55.0% 102,101 188,670 54.1% 88,268 174,956 50.5% 87,917 226,028 38.9% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected CommunityDevelopment Enrichment Community $250,000 $250,000 DecemberYTD YTD December Expenditures Expenditures $200,000 $200,000 $150,000 $150,000 $100,000 $100,000 $50,000 $50,000 $0 $0 Annual Expenditures * Annual Expenditures * 12-13 12-13 13-14 13-14 14-15 15-16 14-15 16-17 Community Development expenditures include costs for Neighborhood Services, Housing, Planning and Economic Development. Citywide community development expenditures are better than expected with a decrease through December 2016 of 0.4% from the same period in the prior year. The 2016-17 budget includes an increase of 29.2% over 2015-16 actuals. -7- December Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Community Enrichment 12-13 13-14 14-15 15-16 16-17 December YTD Annual % of Annual Expenditures Expenditures * Expenditures 140,156 273,110 51.3% 140,929 272,326 51.8% 136,717 259,944 52.6% 137,254 273,179 50.2% 149,636 298,792 50.1% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services Community Enrichment $350,000 $300,000 $300,000 $250,000 $250,000 $200,000 $200,000 $150,000 $150,000 $100,000 $100,000 $50,000 $50,000 $0 $0 Expected DecemberYTD YTD December Expenditures Expenditures Annual Expenditures * Annual Expenditures * 12-13 13-14 12-13 14-15 13-14 15-16 16-17 14-15 Community Enrichment expenditures include costs for Parks, Libraries, the Convention Center, Senior Centers and Community Centers. Citywide community enrichment expenditures are as expected with an increase through December 2016 of 9.0% over the same period in the prior year. The budgeted increase for fiscal year 2016-17 over prior year actuals is 9.4%. Environmental Services 12-13 13-14 14-15 15-16 16-17 December YTD Annual % of Annual Expenditures Expenditures * Expenditures 293,589 564,051 52.1% 290,538 577,118 50.3% 281,419 545,198 51.6% 277,818 555,711 50.0% 301,359 626,701 48.1% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected General Obligation Services Debt Service Environmental $700,000 $700,000 $600,000 $600,000 DecemberYTD YTD December Expenditures Expenditures $500,000 $500,000 $400,000 $400,000 $300,000 $300,000 $200,000 $200,000 $100,000 $100,000 $0 $0 Annual Expenditures * Annual Expenditures * 12-13 12-13 13-14 13-14 14-15 14-15 15-16 16-17 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 8.5% higher through December 2016 than the same period in the prior year. The budgeted increase for fiscal year 2016-17 over prior year actuals is 12.8%. -8- December Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 General Obligation Debt Service 12-13 13-14 14-15 15-16 16-17 December YTD Annual % of Annual Expenditures Expenditures * Expenditures 68,901 137,208 50.2% 50,392 100,524 50.1% 67,358 134,594 50.0% 76,343 154,710 49.3% 68,848 137,966 49.9% * - For prior years-total actual expenditures, for current year-total approved budget net of credit for early redemption fund resources Monitor and Consider Taking Action General Obligation Debt Service Total Citywide $180,000 $160,000 $160,000 $140,000 $140,000 $120,000 $120,000 $100,000 $100,000 $80,000 $80,000 $60,000 $60,000 $40,000 $40,000 $20,000 $20,000 $0 $012-13 DecemberYTD YTD December Expenditures Expenditures Annual Expenditures * Annual Expenditures * 13-14 12-13 14-15 15-16 16-17 13-14 14-15 General obligation debt service expenditures through December 2016 are 9.8% lower than the same period in the prior year. Budgeted expenditures for fiscal year 2016-17 are 10.8% lower than 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 12-13 13-14 $ 320,599 $ 263,112 Refer to detailed financial schedules pages 22 - 34 15-16 16-17 (Budget) $ 238,739 $ 608,878 14-15 $ 244,107 Discussion: 16-17 (YTD) $ 94,561 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). 16-17 (YTD) 16-17 (Budget) 15-16 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). 14-15 13-14 12-13 $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). Through December 2016, the City has committed or spent $20 million for the 48th St and Washington Light Rail Station, $24 million for street construction, repair and maintenance and $12 million for sidewalks, traffic signals, bridges, bike lanes and street lighting improvements and maintenance. Aviation 12-13 13-14 $ 168,639 $ 180,571 14-15 $ 259,616 15-16 16-17 (Budget) $ 522,633 $ 223,029 16-17 (YTD) $ 70,261 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. 16-17 (YTD) 16-17 (Budget) 15-16 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). 14-15 13-14 12-13 $0 $200,000 $400,000 $600,000 Through December 2016, Aviation has spent or committed $16 million for runway, apron and taxiway projects, $13 million for Communications Center/EOC Design and Construction, $5 million for Terminal 3 Development, and $5 million for improvements at Deer Valley and Goodyear airports. - 10 - Capital Expenditures (Dollars in Thousands) 12-13 Phx Convention Ctr $ 21,830 Refer to detailed financial schedules pages 22 - 34 14-15 13-14 $ 23,189 $ 16-17 (Budget) 15-16 24,633 Discussion: $ 24,554 $ 23,213 16-17 (YTD) $ 10,470 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 $20 million per year and continued in fiscal year 2016-17. 16-17 (YTD) 16-17 (Budget) 15-16 14-15 13-14 12-13 $0 13-14 12-13 Solid Waste $ 8,605 $ 8,063 14-15 $ $10,000 16-17 (Budget) 15-16 22,832 $ 8,781 $ 30,145 $20,000 $30,000 16-17 (YTD) $ 4,774 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. 16-17 (YTD) 16-17 (Budget) 15-16 14-15 13-14 In fiscal year 2014-15 Solid Waste spent $16 million for the 27th avenue composting facility and $6 million for the SR85 landfill. 12-13 $0 $10,000 $20,000 $30,000 $40,000 In fiscal year 2015-16, Solid Waste has spent $2.5 million on the 27th Ave Resource Innovation Campus. Through December 2016, Solid Waste has spent or committed $2.6 million at the 27th Avenue Composting Facility and $1.7 million at the 27th Avenue Resource Innovation Campus. - 11 - Capital Expenditures (Dollars in Thousands) 13-14 12-13 Wastewater $ 109,914 Refer to detailed financial schedules pages 22 - 34 $ 58,012 14-15 $ 16-17 (Budget) 15-16 39,880 $ 42,084 Discussion: $ 150,665 16-17 (YTD) $ 18,239 Wastewater 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. 16-17 (YTD) 16-17 (Budget) 15-16 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. In fiscal year 2015-16 Wastewater has 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. 14-15 13-14 12-13 $0 $50,000 $100,000 $150,000 $200,000 Through December 2016, Wastewater has spent or committed $6.4 million to construct, replace or rehabilitate pipelines, $3.9 million for improvements at the 23rd Avenue wastewater treatment plant and $3.8 million for improvements at the 91st Avenue wastewater treatment plant. Water System 12-13 13-14 14-15 $ 110,333 $ 129,080 $ 117,196 15-16 $ 99,091 16-17 (Budget) $ 232,192 16-17 (YTD) $ 42,532 Discussion: Water System Major projects in fiscal year 2013-14 include construction of a new 20 million gallon concrete reservoir at Deer Valley WTP ($16 million). 16-17 (YTD) 16-17 (Budget) Major projects in fiscal year 2014-15 include $9 million for rehabilitation at the 24th Street water treatment plant and $24 million for improvements to the solids handling facility at the Union Hills water treatment plant. The water system also spent nearly $34 million on mains and lines, most of which is for rehabilitation or replacement. 15-16 14-15 13-14 12-13 $0 $100,000 $200,000 $300,000 In fiscal year 2015-16 the water system has spent or committed 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. Through December 2016, Water has spent or committed $16.8 million to construct, replace or rehabilitate pipelines and valves and $4.9 million for reservoir rehabilitation. - 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 Dec YTD Actuals $800,000 $600,000 $400,000 Annual Revenues* $200,000 $0 12-13 12-13 13-14 14-15 15-16 16-17 Dec YTD Actuals 477,901 505,704 513,176 519,553 538,712 Annual Revenues* 980,945 1,026,167 1,048,053 1,063,211 1,091,343 13-14 14-15 15-16 16-17 % of Annual Revenues 48.7% 49.3% 49.0% 48.9% 49.4% * - For prior years - total actual revenues, for current year - total approved budget Better than Expected Fiscal year 2016-17 general fund operating revenues are budgeted to increase 2.6% over prior year actuals. Actual revenues through December 2016 are 3.7% higher than the same period in the prior 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 250,000 200,000 150,000 90,622 62,012 35,204 49,567 50,484 132,101 143,931 138,243 141,310 46,872 100,000 50,000 145,141 Secondary Primary 74,859 12-13 FY 12-13 13-14 14-15 15-16 16-17 YTD 16-17 budget Total 194,112 179,136 187,811 191,793 121,731 235,763 13-14 July (1,733) (1,260) (1,107) (981) (1,004) (1,413) Aug 1,349 971 760 641 454 1,001 14-15 Sept 904 867 816 857 773 1,072 Oct 11,888 11,107 12,338 15,224 12,067 16,317 15-16 Nov 54,091 46,645 63,660 60,232 57,953 71,959 Dec 31,075 32,028 18,028 21,975 51,488 30,394 16-17 YTD Jan 7,015 7,180 8,869 8,268 10,261 Feb 4,743 3,818 2,958 3,815 4,469 16-17 budget Mar 6,670 5,668 5,135 5,779 6,997 Apr 8,323 7,300 9,411 9,409 11,021 May 44,111 44,562 45,939 42,177 55,984 June 25,676 20,250 21,004 24,397 27,701 Note: Monthly budget amount for 13-14 is the average % of last 3 years of the total budget amount Better Than Expected Because property taxes are primarily collected in November, December, May and June, a monthly breakdown of the revenues is not particularly useful, therefore the chart for property tax revenues is presented with an annual perspective. Total property tax revenues are budgeted to increase 22.9% in fiscal year 2016-17 over fiscal year 2015-16 actuals. Through December 2016, property tax revenues are 24.3% higher than the same period in the prior year. - 14 - Local Sales Tax (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Local Sales Tax Budget vs Actual 45,000 40,000 35,000 30,000 25,000 16-17 Actuals 20,000 16-17 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 Local sales tax revenues through December 2016 are 1.1% below budget. The fiscal year 2016-17 budget includes an increase of 3.0% in local sales tax revenues over fiscal year 2015-16 actuals. Monthly revenue figures for August 2016 through December 2016 have been adjusted for a change in accounting for the transfer of Excise Tax Funds to Public Safety Enhancement Funds. Local Sales Tax 3 Year Trend 45,000 40,000 35,000 30,000 14-15 Actuals 25,000 15-16 Actuals 20,000 16-17 Actuals 15,000 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Through December 2016 local sales tax revenues are 2.4% higher than the same period in 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%. Monthly revenue figures for August 2016 through December 2016 have been adjusted for a change in accounting for the transfer of Excise Tax Funds to Public Safety Enhancement Funds. 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 16-17 Actuals 16-17 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 State shared sales tax revenues through December 2016 are 1.9% higher than budget expectations for that period. The fiscal year 2016-17 budget includes an increase of 3.0% in state shared sales tax over fiscal year 2015-16 actuals. State Sales Tax 3 Year Trend 16,000 14,000 12,000 10,000 14-15 Actuals 8,000 15-16 Actuals 6,000 16-17 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. Through December 2016 state shared sales tax revenues are 3.9% higher than the same period in the prior 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 7,000 6,000 5,000 16-17 Actuals 4,000 16-17 budget 3,000 2,000 1,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Expected State shared vehicle license tax revenues through December 2016 are 0.1% higher than budget expectations for the same period. Vehicle License Tax 3 Year Trend 7,000 6,000 14-15 Actuals 5,000 15-16 Actuals 4,000 16-17 Actuals 3,000 2,000 1,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. Through December 2016 state shared vehicle license tax revenues are 4.0% higher than the same period in the prior year. 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 300,000 250,000 200,000 16-17 Actuals 16-17 budget 150,000 100,000 50,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Expected Governmental funds are those funds supported primarily through taxes, bonds and grants and include the general fund as well as funds with dedicated tax revenue streams. They do not include the enterprise funds. Governmental fund revenues through December 2016 are 0.2% higher than budget expectations for the period. Governmental Funds Revenues 3 Year Trend 300,000 250,000 2014-15 Actuals 200,000 2015-16 Actuals 150,000 2016-17 Actuals 100,000 50,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2013-14 governmental funds revenues increased by 0.1% over fiscal year 2012-13 and fiscal year 2014-15 governmental revenues decreased 0.6% from the prior year. Fiscal year 2015-16 governmental funds revenues increased 6.9% over fiscal year 2014-15. Through December 2016, governmental funds revenues are 10.9% 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 35,000 30,000 25,000 16-17 Actuals 20,000 16-17 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 December 2016 are 3.5% higher than budget expectations for the period. Aviation Operating Revenues 3 Year Trend 35,000 30,000 25,000 14-15 Actuals 20,000 15-16 Actuals 15,000 16-17 Actuals 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2014-15 aviation operating revenues were 3.0% higher than fiscal year 2013-14. Fiscal year 2015-16 aviation operating revenues were 1.6% higher than fiscal year 2014-15. Through December 2016, aviation operating revenues are 1.8% higher than the same period in the prior year. Click Here for Additional Information - 19 - Water System Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Water System Operating Revenues Budget vs Actual 60,000 50,000 40,000 16-17 Actuals 16-17 budget 30,000 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Expected Water system revenues through December 2016 are less than 0.1% different than budget expectations for the period. Water System Operating Revenues 3 Year Trend 60,000 50,000 40,000 14-15 Actuals 15-16 Actuals 30,000 16-17 Actuals 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Primarily due to the record setting rainfall received in August and September 2014 and above average rainfall in December and January, fiscal year 2014-15 revenues were 6.8% below revenues for fiscal year 2013-14. Revenues for fiscal year 2015-16 were 6.8% higher than the prior fiscal year. Through December 2016 revenues are 7.5% higher than the same period in the prior year. Click Here for Additional Information - 20 - Wastewater Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Wastewater Operating Revenues Budget vs Actual 20,000 19,500 19,000 18,500 16-17 Actuals 18,000 16-17 budget 17,500 17,000 16,500 16,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Better than Expected Wastewater revenues through December 2016 are 1.7% above budget expectations for the period. Wastewater Operating Revenues 3 Year Trend 25,000 20,000 14-15 Actuals 15,000 15-16 Actuals 16-17 Actuals 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr Click Here for Additional Information - 21 - May June General Funds Summary Presents comparisons of year-to-date balances to the fiscal year budget and to the actual results for the prior year for the general fund. General Fund Revenue As of DECEMBER 31 (dollars in thousands) Budget Estimate 2016-2017 Actual Year-to-Date 2016-2017 2015-2016 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 $ $ 433,000 2,455 $ 212,632 616 $ 207,631 1,746 141,696 187,210 61,042 145,141 2,786 10,090 68,506 95,673 29,200 74,859 1,406 2,608 65,940 87,117 28,079 72,126 1,387 2,447 14,327 915 13,803 672 7,818 1,680 3,472 5,293 439 6,364 345 3,699 878 3,103 6,739 315 6,547 294 3,316 852 1,787 34,700 12,299 3,500 14,737 16,694 6,070 1,769 8,558 17,468 5,456 1,621 8,685 1,091,343 $ 538,712 $ 519,553 - - 22 - General Fund Expenditures As of DECEMBER 31 (dollars in thousands) Actual Year-to-Date 2016-2017 2015-2016 Budget Estimate 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,831 3,537 2,361 36,081 1,959 2,552 20,266 2,777 4,230 10,745 3,281 23,274 2,104 114,998 796 $ 1,700 1,779 19,050 955 1,067 9,419 1,128 2,200 4,719 1,821 12,047 1,044 57,725 750 1,580 1,705 18,158 805 1,094 8,967 1,074 1,933 4,279 1,523 13,597 2,187 57,652 28,112 5,094 33,206 13,346 2,277 15,623 13,202 4,387 17,589 498,786 273,282 92 772,160 261,183 132,355 (31) 393,507 253,231 126,409 313 379,953 Criminal Justice Municipal Court Public Defender Total Criminal Justice Public Safety Police Fire Others Total Public Safety $ Transportation Street Transportation Public Transit Total Transportation 20,272 1,652 21,924 7,513 1,652 9,165 6,396 1,669 8,065 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 5,064 12,115 4,321 54 21,554 2,380 5,552 2,004 24 9,960 2,335 5,789 1,998 24 10,146 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 91,391 35,282 18,511 5,824 151,008 46,238 16,547 8,779 3,291 74,855 44,828 15,847 7,692 2,770 71,137 Environmental Services Public Works Environmental Programs Total Environmental Services 13,616 669 14,285 5,381 184 5,565 5,251 169 5,420 9,926 1,586 809 83,146 - Capital Improvement Contingencies Total Expenditures and Encumbrances $ 1,222,207 - 23 - $ 567,986 $ 550,771 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 DECEMBER 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 $ Total General Funds 433,000 2,455 $ $ 212,632 616 $ $ 207,631 1,746 141,696 187,210 61,042 145,141 2,786 10,090 15,242 13,803 672 7,818 1,680 3,472 46,999 3,500 14,737 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 68,506 95,673 29,200 74,859 1,406 2,608 5,732 6,364 345 3,699 878 3,103 22,764 1,769 8,558 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 65,940 87,117 28,079 72,126 1,387 2,447 7,054 6,547 294 3,316 852 1,787 22,924 1,621 8,685 1,091,343 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 29,933 86,075 29,991 6,020 263,220 4,089 47,058 12,051 27,518 116,542 48,139 5,414 47,391 294,816 95,364 Total Special Revenue and Debt Service Funds Total Enterprise Funds $ 538,712 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 14,440 41,770 14,823 2,090 121,714 940 33,153 5,965 11,943 56,966 19,354 2,531 21,626 109,732 49,240 1,113,621 506,287 341,495 64,247 420,996 223,816 147,789 171,140 29,507 238,453 113,984 75,182 1,198,343 628,266 Enterprise Funds Aviation Convention Center Water System Wastewater Solid Waste Total Operating Revenues Actual Year-to-Date 2016-2017 2015-2016 Budget Estimate 2016-2017 3,403,307 - 24 - $ 519,553 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 13,801 41,992 13,821 2,230 82,982 3,174 29,938 6,656 10,667 54,144 20,015 2,586 21,648 90,557 28,194 422,405 $ $ $ $ $ 1,673,265 $ 168,166 28,706 221,786 110,090 73,991 602,739 1,544,697 Citywide Operating Expenditures As of DECEMBER 31 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2016-2017 2015-2016 Budget 2016-2017 57,725 $ 5,422 63,147 57,652 5,907 63,559 33,206 14,912 48,118 15,623 4,694 20,317 17,589 4,243 21,832 Public Safety General Funds Other Funds Total Public Safety 772,160 162,014 934,174 393,507 68,764 462,271 379,953 63,316 443,269 Transportation General Funds Other Funds Total Transportation 21,924 650,064 671,988 9,165 378,092 387,257 8,065 363,187 371,252 Community Development General Funds Other Funds Total Community Development 21,554 204,474 226,028 9,960 77,957 87,917 10,146 78,122 88,268 Community Enrichment General Funds Other Funds Total Community Enrichment 151,008 147,784 298,792 74,855 74,781 149,636 71,137 66,117 137,254 Environmental Services General Funds Other Funds Total Environmental Services 14,285 612,416 626,701 5,565 295,794 301,359 5,420 272,398 277,818 Debt Service General Funds Other Funds Total Debt Service 137,966 137,966 68,848 68,848 76,343 76,343 Capital Improvement General Funds Other Funds Total Capital Improvement 9,926 729,524 739,450 1,586 159,946 161,532 809 151,958 152,767 Contingencies General Funds Other Funds Total Contingencies 83,146 51,500 134,646 $ Criminal Justice General Funds Other Funds Total Criminal Justice Total Operating General Funds Other Funds Total Operating Budget $ 114,998 24,122 139,120 1,222,207 2,734,776 3,956,983 $ - $ - 25 - 567,986 1,134,298 1,702,284 $ 550,771 1,081,591 1,632,362 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 DECEMBER 31 2016 2015 Budget Estimate 2016-2017 Source Actual Year-to-Date 2016-2017 2015-2016 General Funds $ 32,782,863 1,080,605 Local Taxes: Sales Taxes Privilege License Fees 35,499,954 33,863,468 Total Local Taxes 435,455,000 213,247,851 209,376,970 11,913,059 15,945,590 4,826,340 11,623,114 14,519,502 4,550,003 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 141,696,000 187,210,000 61,042,000 68,505,638 95,673,541 29,199,939 65,939,768 87,117,010 28,078,668 32,684,989 30,692,619 389,948,000 193,379,118 181,135,446 31,519,923 16,372,978 Primary Property Tax 145,141,000 74,858,920 72,126,070 315,166 407,485 Licenses and Permits 2,786,000 1,406,372 1,387,425 30 25 Cable Communications 10,090,000 2,607,694 2,447,346 808,916 70,733 802,446 43,730 Municipal Court: Fines and Forfeitures Court Default Fee 14,326,586 915,000 5,292,995 438,727 6,739,429 314,892 879,649 846,176 15,241,586 5,731,722 7,054,321 1,401,235 1,193,313 13,803,108 6,364,015 6,547,090 37,823 40,975 672,215 344,884 293,730 (234,283) 449,610 Parks and Recreation 7,817,520 3,698,794 3,315,696 96,571 160,301 Planning and Development 1,679,900 878,412 852,547 1,462,913 369,663 Street Transportation 3,472,000 3,102,895 1,786,696 2,612,708 61,746 829,677 3,121,355 51,218 98,424 34,700,000 1,550,000 10,749,485 16,693,879 389,071 5,681,254 17,467,827 378,083 5,077,715 3,504,131 3,270,997 46,999,485 22,764,204 22,923,625 328,455 301,888 3,500,000 1,768,721 1,621,130 2,491,527 2,058,955 14,737,022 8,558,365 8,685,134 109,988,083 90,028,453 1,091,342,836 538,711,967 519,553,226 35,135,496 364,458 $ $ Total State Shared Taxes Total Municipal Court Police Library Fees Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire Interest Other Fees and Service Charges Total General Funds - 26 - 433,000,000 2,455,000 $ 212,631,990 615,861 $ 207,630,708 1,746,262 Citywide Operating Revenue by Source (continued) For the Month Ended DECEMBER 31 2016 2015 Budget Estimate 2016-2017 Source Actual Year-to-Date 2016-2017 2015-2016 Special Revenue and Debt Service Funds $ 1,623,116 115,937 579,685 19,903 $ 1,602,511 114,466 572,325 13,777 2,338,641 2,303,079 5,038,030 1,741,461 1,421 4,664,472 1,529,598 (3,763) 6,780,912 6,190,307 2,363,038 2,322,847 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other Total Neighborhood Protection Public Safety Enhancement & Expansion: Police Fire Interest/Other Total Public Safety Enhancement & Expansion Parks and Preserves Golf Courses: Fees Coffee Shops Concessions Interest Other 284,559 0 180,066 (266) 8,422 274,217 0 178,299 (373) 14,577 472,781 466,720 15,742,642 5,441,327 9,153,394 5,045,279 21,183,969 14,198,673 0 2,193,994 Court Awards 4,993,369 4,669,624 994,368 $ 20,744,000 1,481,000 7,413,000 295,376 $ 9,913,794 708,128 3,540,641 277,401 $ 9,548,097 682,007 3,410,035 160,886 29,933,376 14,439,964 13,801,025 64,007,000 22,023,000 45,000 30,805,037 10,657,082 307,806 30,961,547 11,056,355 (25,745) 86,075,000 41,769,925 41,992,157 29,991,315 14,822,784 13,820,783 3,710,739 0 2,225,017 (10,000) 94,257 1,129,487 0 904,543 (561) 56,176 1,285,200 82 894,464 (1,136) 51,064 6,020,013 2,089,645 2,229,674 206,782,000 56,438,091 95,216,637 26,497,117 54,415,009 28,566,669 263,220,091 121,713,754 82,981,678 4,088,873 940,000 3,173,994 Planning and Development 47,058,000 33,153,242 29,937,686 1,143,169 Capital Construction 12,051,000 5,965,321 6,655,624 1,399,338 4,337,496 1,459,230 3,379,964 Sports Facilities: Sales Taxes Interest/Other 18,702,000 8,815,726 7,405,913 4,537,192 7,118,183 3,548,561 5,736,834 4,839,194 27,517,726 11,943,105 10,666,744 Total Golf Courses Transit 2000 & 2050: Sales Taxes Interest/Other Total Transit 2000 & 2050 Total Sports Facilities - 27 - Citywide Operating Revenue by Source (continued) For the Month Ended DECEMBER 31 2016 2015 Budget Estimate 2016-2017 Source Actual Year-to-Date 2016-2017 2015-2016 Special Revenue and Debt Service Funds (Cont'd) $ $ Highway User Revenue: Highway User Revenue Interest Other 9,405,050 55,544 299 9,336,985 47,430 300 9,460,893 9,384,715 2,519,571 3,048,754 469,790 130,209 3,844,210 6,605,570 Other Restricted Fees 561,288 6,535,467 311,510 Grants: Public Housing: Rentals Grants Other 462,209 10,439,265 1,093,230 $ 11,994,704 7,408,265 3,041,224 6,680,387 1,023,210 2,413,121 3,414,660 1,566,732 1,588,671 3,171,686 13,157,942 9,741,749 25,152,646 17,150,014 19,967,884 2,368,335 5,601,527 2,370,869 22,336,219 7,972,396 108,647,241 82,619,265 Total Highway User Revenue Regional Transit Revenues Community Reinvestment $ Total Public Housing 115,992,000 400,000 150,000 56,371,431 309,565 285,346 53,757,010 290,876 96,214 116,542,000 56,966,342 54,144,100 48,139,440 19,354,112 20,015,350 5,413,996 2,530,469 2,586,374 47,391,330 21,625,894 21,647,857 6,457,040 79,392,390 6,174,228 $ 3,783,452 37,679,678 8,399,235 $ 3,287,396 34,061,886 2,383,607 92,023,658 49,862,365 39,732,889 43,099,854 82,258,927 39,982,633 37,451,348 18,116,616 16,540,691 6,681,392 18,531,411 18,516,722 6,079,315 8,768,345 17,460,012 Total Other 202,792,762 59,870,110 50,824,394 Total Grants 294,816,420 109,732,475 90,557,283 90,622,120 4,741,740 46,871,825 2,368,483 25,823,261 2,371,125 95,363,860 49,240,308 28,194,386 1,113,622,440 506,287,340 422,404,715 137,300,000 194,137,000 1,500,000 3,339,000 2,193,000 3,025,500 - 49,421,390 117,205,300 1,017,722 394,282 1,198,906 1,530,836 371,094 48,994,508 116,009,678 796,849 (465,039) 1,132,223 1,455,873 241,844 341,494,500 171,139,530 168,165,936 Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond/Secondary Property Tax Secondary Property Tax Interest Total G.O. Bond/Secondary Property Tax Total Special Revenue and Debt Service Funds Enterprise Funds AVIATION: 7,973,768 17,665,145 170,970 (1,371,152) 189,236 244,373 53,694 8,195,032 19,052,133 146,459 (2,059,639) 194,598 238,132 28,325 24,926,034 25,795,040 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 DECEMBER 31 2016 2015 Budget Estimate 2016-2017 Source Actual Year-to-Date 2016-2017 2015-2016 Enterprise Funds (Cont'd) CONVENTION CENTER: $ 3,537,923 1,726,117 36,596 3,666,737 1,804,466 34,276 5,300,636 5,505,479 Excise Taxes Operating Revenue Interest Total Convention Center 46,726,000 17,303,084 218,012 21,218,848 8,071,291 216,702 20,410,911 8,113,798 181,492 64,247,096 29,506,841 28,706,201 WATER SYSTEM: $ 23,412,580 392,306 470,161 536,553 482,190 209,522 569,998 $ 26,073,310 21,876,397 402,912 519,336 378,276 334,440 194,000 701,120 24,406,481 Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System 397,081,000 6,000,000 4,070,000 6,317,000 3,100,000 2,897,000 1,531,000 $ 224,654,178 2,380,812 3,122,241 3,507,751 1,904,040 1,161,886 1,722,483 $ 208,450,695 2,706,018 3,430,927 3,081,932 1,484,520 1,102,388 1,529,279 420,996,000 238,453,391 221,785,759 192,431,000 15,822,000 3,100,000 1,435,000 11,028,000 94,804,850 9,895,330 1,821,030 910,933 6,551,771 92,788,407 9,975,130 1,422,450 782,484 5,121,702 223,816,000 113,983,914 110,090,173 129,906,427 8,647,399 305,000 8,929,739 64,635,775 4,390,703 340,462 5,815,116 64,277,599 4,242,816 312,629 5,158,182 147,788,565 75,182,056 73,991,226 1,198,342,161 628,265,732 602,739,295 WASTEWATER: 15,736,462 1,631,441 479,550 158,186 1,487,464 15,513,050 1,688,207 332,340 131,512 1,031,907 19,493,103 18,697,016 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: $ 10,782,785 777,862 60,125 992,270 10,741,698 642,306 53,403 945,902 12,613,042 12,383,309 88,406,125 86,787,325 307,041,449 $ 259,435,043 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ - 29 - 3,403,307,437 $ 1,673,265,039 $ 1,544,697,236 Citywide Operating Expenditures by Program For the Month Ended DECEMBER 31 2016 2015 Budget Estimate 2016-2017 Program Actual Year-to-Date 2016-2017 2015-2016 2016-2017 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt General Government $ 163,829 291,684 306,768 3,148,491 (59,866) 198,203 199,177 1,616,256 196,531 365,667 115,481 639,008 60,249 51,358 (383,307) 9,544 282,708 836,623 689,996 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 8,728,400 118,223 258,971 357,706 4,702,349 144,098 188,627 258,827 1,628,135 150,471 394,613 (18,285) 989,215 53,071 58,855 (261,582) 7,599 265,929 2,625,814 1,356,309 13,278,945 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,831,303 3,536,511 2,434,048 39,031,830 1,106,274 2,312,584 2,993,238 21,174,127 2,776,856 4,230,396 483,110 12,095,007 423,470 965,149 90,813 3,281,194 35,268,429 5,085,426 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 139,119,765 795,625 1,700,258 1,947,920 20,384,586 476,778 1,145,702 1,248,460 10,024,043 1,127,705 2,200,320 141,234 5,466,702 357,094 307,382 13,951 59,590 1,821,196 13,957,682 (28,958) $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 63,147,270 749,389 1,579,999 1,724,709 19,259,659 508,939 992,502 1,367,813 9,336,200 1,073,652 1,932,888 866,315 4,839,564 313,170 253,882 450,355 50,386 1,523,119 14,921,506 1,814,623 $ 795,625 1,700,258 1,947,920 19,478,340 476,778 1,145,702 1,248,460 10,024,043 1,127,705 2,200,320 141,234 5,039,197 357,094 307,382 13,951 59,590 1,821,196 13,162,687 (28,958) 906,246 427,505 794,995 - 63,558,670 61,018,524 2,128,746 17,444,819 4,386,914 - 14,345,839 2,277,144 - 3,693,530 - 21,831,733 16,622,983 3,693,530 294,159,848 148,519,940 589,065 305,183,774 152,927,471 397,356 2,610,267 1,151,958 - 443,268,853 458,508,601 3,762,225 Criminal Justice 3,141,414 396,030 - $ $ $ 3,537,444 3,004,361 171,117 3,175,478 Municipal Court Public Defender Other Total Criminal Justice 43,023,685 5,093,954 - $ $ $ 48,117,639 18,039,369 2,277,144 - $ $ $ 20,316,513 Public Safety 50,706,216 25,905,976 64,205 76,676,397 $ $ $ 49,918,244 24,704,475 76,856 74,699,575 Police Fire Other Total Public Safety 613,942,012 319,414,035 817,576 $ $ $ 934,173,623 307,794,041 154,079,429 397,356 462,270,826 - 30 - $ $ $ Citywide Operating Expenditures by Program (continued) For the Month Ended DECEMBER 31 2016 2015 Budget Estimate 2016-2017 Program Actual Year-to-Date 2016-2017 2015-2016 2016-2017 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Transportation $ 5,997,377 1,018,678 24,937,750 3,393,640 $ $ $ $ 35,347,445 4,966,214 508,094 28,777,341 (1,257,008) 32,994,641 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 63,631,138 11,223,396 300,867,783 296,265,820 $ $ $ $ 671,988,137 29,707,566 5,619,758 147,010,981 204,918,951 $ $ $ $ 387,257,256 26,993,787 4,936,725 138,432,762 200,888,341 $ $ $ $ 371,251,615 29,504,214 5,619,758 118,699,995 174,414,172 $ $ $ $ 328,238,139 203,352 28,310,986 30,504,779 59,019,117 Community Development 4,049,405 259,849 4,678,408 2,705,494 $ $ $ $ 11,693,156 3,402,079 6,587,393 1,691,636 2,436,749 Planning and Development Housing Economic Development Neighborhood Services Department 53,383,420 91,468,988 27,958,662 53,217,436 14,117,857 Total Community Development 226,028,506 $ $ $ $ 23,285,526 36,479,636 14,568,794 13,583,245 $ $ $ $ 87,917,201 19,950,256 41,652,064 13,178,211 13,487,863 $ $ $ $ 88,268,394 23,285,526 36,442,962 12,804,270 13,583,245 $ $ $ $ 86,116,003 36,674 1,764,524 1,801,198 Community Enrichment 7,254,284 2,446,303 458,665 3,870,206 5,298,165 4,763,020 275,039 239,791 24,605,473 $ $ $ $ $ $ $ $ 7,348,213 2,606,328 680,519 4,781,641 943,015 5,418,705 212,983 233,549 22,224,953 Parks and Recreation Library Golf Convention Center Sports and Cultural Facilities Human Services Public Parking Facilities Other Total Community Enrichment 100,896,979 35,786,355 5,683,994 62,561,583 21,323,644 63,044,520 5,369,072 4,126,369 $ $ $ $ $ $ $ $ 298,792,516 49,650,686 16,757,346 3,026,089 34,494,453 10,236,190 30,389,173 2,672,019 2,409,697 149,635,653 - 31 - $ $ $ $ $ $ $ $ 48,651,664 16,097,131 3,134,024 28,946,595 5,661,382 30,628,860 2,065,134 2,069,675 137,254,465 $ $ $ $ $ $ $ $ 49,445,523 16,757,346 3,026,089 24,610,882 30,243,102 2,672,019 2,409,697 129,164,658 $ $ $ $ $ $ $ $ 205,163 9,883,571 10,236,190 146,071 20,470,995 Citywide Operating Expenditures by Program (continued) For the Month Ended DECEMBER 31 2016 2015 Budget Estimate 2016-2017 Program Actual Year-to-Date 2016-2017 2015-2016 2016-2017 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Environmental Services $ 24,849,767 9,794,744 10,117,438 1,607,025 132,390 $ $ $ $ $ 46,501,364 24,210,721 11,132,320 9,180,088 1,858,776 140,846 46,522,751 Water System Wastewater Solid Waste Management Public Works Environmental Programs Total Environmental Services $ 310,106,196 150,254,281 143,052,099 21,871,143 1,416,815 $ $ $ $ $ 626,700,534 153,115,080 70,954,017 67,957,233 9,251,626 80,397 $ $ $ $ $ 301,358,353 141,984,310 68,336,233 58,825,419 8,522,680 150,076 $ $ $ $ $ 277,818,718 99,758,412 38,376,548 62,107,351 5,557,715 80,397 53,356,668 32,577,469 5,849,882 3,693,911 - 205,880,423 95,477,930 General Obligation Debt Service 16,421 1,244,188 1,805,291 66,828 288,077 1,970 1,079,965 159,610 566,278 477,269 93,666 1,021,012 32,525 469,587 443,902 180,849 40,341 115,328 1,141,089 338,247 513 552,718 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 10,135,674 44,562,889 $ 261,788,242 $ $ 16,421 1,214,797 2,366,799 69,430 404,943 33,321 1,134,548 173,495 451,048 628,008 117,323 1,045,464 74,592 582,628 521,113 657,380 115,072 1,258,618 425,244 513 1,433,029 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 Municipal Administration Buildings Police Protection Public Housing Renovation Sanitary Sewers Secondary Property Tax Solid Waste Enterprise Bonds Storm Sewer Improvements Street Improvements Street Light Refinancing Water System 197,050 15,511,312 28,344,673 831,150 4,528,684 342,100 13,357,995 2,077,138 7,048,023 6,435,857 1,278,972 13,703,919 390,300 6,889,780 5,326,824 2,621,013 1,250 1,383,925 15,967,791 5,085,434 6,150 6,636,627 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 12,723,786 Total Debt Service 137,965,967 16,503,142 Capital Improvement 739,449,828 $ Contingencies 134,646,000 $ 236,241,128 Total Operating Budget 98,525 7,750,617 13,902,606 414,330 2,257,164 168,912 6,663,836 1,031,804 3,521,127 3,213,301 635,226 6,840,338 195,150 3,428,656 2,663,412 1,085,091 494,414 691,963 7,936,743 2,535,790 3,075 3,316,308 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 68,848,388 3,956,982,515 161,532,338 1,702,283,798 - 32 - 98,525 7,288,781 14,200,793 416,576 2,429,655 199,925 6,807,291 1,040,973 2,706,292 3,768,053 703,936 6,272,782 447,550 3,495,765 3,126,680 3,944,282 690,437 7,551,708 2,551,466 3,075 8,598,171 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 76,342,716 $ $ 152,766,671 1,632,361,835 98,525 7,750,617 13,902,606 414,330 2,257,164 168,912 6,663,836 1,031,804 3,521,127 3,213,301 635,226 6,840,338 195,150 3,428,656 2,663,412 1,085,091 494,414 691,963 7,936,743 2,535,790 3,075 3,316,308 - 68,848,388 - $ - $ 1,354,397,719 161,532,338 347,886,079 Capital Expenditures and Encumbrances 2015-2016 Actual Yearto-Date 2016-2017 Program General Government Arts and Cultural Facilities Economic Development Energy Conservation Facilities Management Finance Fire Protection Historic Preservation Housing Human Services Information Technology Libraries Neighborhood Services Parks and Mountain Preserves Police Protection Public Transit Regional Wireless Cooperative Street Transportation & Drainage General Government Subtotal Enterprise Aviation Phoenix Convention Center Solid Waste Disposal Wastewater Water System Enterprise Subtotal Total Capital Budget Program Actual Yearto-Date Budget $ 1,117,899 $ 11,330,679 1,200,000 11,413,707 669,511 14,804,412 1,178,482 22,284,888 600,000 57,947,399 629,126 4,816,031 82,073,710 965,000 156,367,083 8,561,919 232,918,410 54,000 $ 1,683,733 455,209 564,696 546,281 103,905 2,861,891 11,262,592 8,370 467,608 8,284,288 300,164 28,005,852 1,207,936 38,754,648 3,475,874 940,828 228,033 177,725 443,012 62,713 9,324,863 10,336,542 17,175 132,914 6,189,856 1,889,320 11,887,388 2,567,444 39,314,628 $ 608,878,256 $ 94,561,173 $ 86,988,315 $ $ 223,028,686 23,212,500 30,145,097 150,665,033 232,192,011 659,243,327 $ $ $ 1,268,121,583 $ 70,260,639 10,470,442 4,774,134 18,239,184 42,532,406 146,276,805 240,837,978 $ $ 442,226,784 10,796,094 1,093,294 15,661,802 61,045,267 530,823,241 $ 617,811,556 2016-2017 Year-to-Date Capital Amounts From Capital Funds From Operating Funds Budget Actual Budget Actual $ $ $ 43,899 $ 11,330,679 1,200,000 8,178,707 368,231 14,337,250 13,978,065 9,263,393 200,000 2,543,653 62,019,051 900,000 136,524,247 138,112,127 1,683,733 455,209 564,696 358,653 1,384,821 3,103,764 4,158 452,301 8,270,687 283,575 27,809,006 32,748,204 398,999,302 $ 77,118,807 $ 67,466,730 2,763,500 28,944,000 66,861,650 174,414,646 340,450,526 $ 739,449,828 - 33 - $ $ 24,902,783 245,942 4,694,557 14,756,283 39,813,966 84,413,531 $ 161,532,338 $ $ $ 1,074,000 $ 3,235,000 301,280 467,162 1,178,482 8,306,823 600,000 48,684,006 429,126 2,272,378 20,054,659 65,000 19,842,836 8,561,919 94,806,283 54,000 187,628 103,905 1,477,070 8,158,828 4,212 15,307 13,601 16,589 196,846 1,207,936 6,006,444 209,878,954 $ 17,442,366 $ 155,561,956 20,449,000 1,201,097 83,803,383 57,777,365 318,792,801 $ 528,671,755 $ Unencumbered Budget $ 1,063,899 9,646,946 744,791 10,849,011 669,511 14,258,131 1,074,577 19,422,997 600,000 46,684,807 620,756 4,348,423 73,789,422 664,836 128,361,231 7,353,983 194,163,762 $ 514,317,083 $ 45,357,856 10,224,500 79,577 3,482,901 2,718,440 61,863,274 $ $ 152,768,047 12,742,058 25,370,963 132,425,849 189,659,605 512,966,522 $ 79,305,640 $ 1,027,283,605 Bonds Authorized and Sold As of DECEMBER 31 (dollars in thousands) Authorized Sold Available 1988 Authorizations General Obligation Bonds Freeway Mitigation, Neighborhood Stabilization, and Slum and Blight Elimination Bonds Fully Issued $ Total General Obligation Bonds Revenue Bonds Bonds Fully Issued Total 1988 Authorizations 29,285 884,175 $ 28,285 884,175 $ 1,000 - 913,460 912,460 1,000 143,890 143,890 - 1,057,350 1,056,350 1,000 66,300 125,300 24,800 61,500 12,000 33,000 91,500 74,000 77,000 78,800 66,000 43,700 64,600 124,685 24,170 60,700 11,205 32,100 89,275 71,645 72,575 77,685 65,950 43,700 1,700 615 630 800 795 900 2,225 2,355 4,425 1,115 50 - 753,900 738,290 15,610 81,000 11,100 198,700 12,800 104,622 74,705 29,178 115,500 107,295 78,200 65,400 63,385 8,510 190,610 8,345 85,510 61,200 21,100 102,290 81,900 58,135 61,770 17,615 2,590 8,090 4,455 19,112 13,505 8,078 13,210 25,395 20,065 3,630 878,500 742,755 135,745 2001 Authorization General Obligation Bonds Education, Youth and Family Cultural Facilities Computer Technology Environmental Cleanup Fire Protection Historic Preservation Library Facilities Street Improvements Neighborhood Protection and Senior Centers Parks, Open Space, and Recreational Facilities Police Protection Storm Sewer and Flood Protection Bonds Fully Issued Total 2001 Authorizations 2006 Authorization General Obligation Bonds Affordable Housing and Neighborhood Revitalization Computer Technology Education and Health Science Facilities Environmental Cleanup Family, Senior, and Youth Cultural Facilities Fire Protection Library Facilities and Improvements Parks, Open Space, and Recreational Facilities Police Protection Street Improvements Storm Sewer and Flood Protection Total 2006 Authorizations Total Bond Program $ 2,689,750 - 34 - $ 2,537,395 $ 152,355 Appendix A Additional historic and trend information for various revenue streams. Local Sales Tax (Dollars in Thousands) Local Sales Tax 45,000 12-13 Actuals 40,000 13-14 Actuals 35,000 14-15 Actuals 15-16 Actuals 30,000 16-17 Actuals 25,000 16-17 budget 20,000 15,000 July FY 12-13 13-14 14-15 15-16 16-17 16-17 budget July 34,005 36,360 35,365 34,740 35,857 36,447 Aug Aug 34,276 35,589 36,414 35,137 36,805 36,692 Sept Sept 34,254 35,873 35,290 35,079 34,012 36,454 Oct Nov Oct 33,337 35,068 34,621 35,459 38,800 35,932 Dec Nov 33,430 34,363 33,033 34,433 32,023 35,095 Jan Dec 32,504 32,474 35,062 32,783 35,135 34,463 YTD thru December 201,806 209,728 209,784 207,631 212,632 215,083 Feb Mar Jan 36,527 40,116 37,227 37,567 39,293 Note: City of Phoenix revenue is budgeted on an annual basis. 2016-17 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2012-13 through 2015-16 actual revenues. Monthly revenue for August 2016 through December 2016 have been adjusted for a change in accounting for the transfer of Excise Tax Funds to Public Safety Enhancement Funds. Return to Summary Page - A1 - Apr Feb 32,542 32,084 34,432 32,793 34,211 May Mar 32,047 32,147 34,938 33,135 34,319 June Apr 34,911 35,988 37,203 36,307 37,469 May 34,699 33,165 33,049 34,236 35,067 June 38,243 34,898 33,017 38,598 37,558 State Sales Tax (Dollars in Thousands) State Sales Tax 15,000 12-13 Actuals 14,000 13-14 Actuals 13,000 14-15 Actuals 12,000 15-16 Actuals 11,000 16-17 Actuals 16-17 budget 10,000 9,000 8,000 7,000 6,000 5,000 July FY 12-13 13-14 14-15 15-16 16-17 16-17 budget Aug July 9,907 10,309 11,103 11,070 11,269 11,652 Sept Aug 8,755 9,616 9,712 10,222 11,027 10,529 Sept 9,240 10,012 10,552 11,237 11,658 11,281 Oct Nov Oct 9,229 9,923 10,307 10,688 11,195 11,035 Dec Nov 9,456 9,673 10,295 11,100 11,443 11,139 Jan Dec 9,462 10,296 10,695 11,623 11,913 11,566 Feb YTD thru December 56,050 59,827 62,664 65,940 68,506 67,202 Mar Jan 11,986 12,744 13,173 13,760 14,201 Note: City of Phoenix revenue is budgeted on an annual basis. 2016-17 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2012-13 through 2015-16 actual revenues. Return to Summary Page - A2 - Apr Feb 9,270 10,430 10,244 10,375 11,082 May Mar 9,887 10,506 10,861 11,139 11,653 June Apr 11,037 11,285 12,265 12,975 13,074 May 9,902 10,863 11,697 11,470 12,075 June 10,599 11,350 11,314 11,886 12,409 Vehicle License Tax (Dollars in Thousands) Vehicle License Tax 6,000 12-13 Actuals 5,500 13-14 Actuals 5,000 14-15 Actuals 4,500 15-16 Actuals 4,000 16-17 Actuals 3,500 16-17 budget 3,000 2,500 2,000 July FY 12-13 13-14 14-15 15-16 16-17 Budget 16-17 Aug July 4,493 4,752 4,963 5,095 5,712 5,477 Sept Aug 3,982 4,663 5,004 5,133 4,393 5,329 Oct Sept 3,852 3,992 3,749 4,087 4,846 4,449 Nov Oct 3,535 3,912 4,415 4,922 5,181 4,762 Dec Nov 3,582 3,958 4,198 4,291 4,242 4,548 Jan Dec 3,993 3,872 3,857 4,550 4,826 4,617 Feb YTD thru December 23,437 25,148 26,185 28,079 29,200 29,182 Mar Jan 3,572 3,936 4,661 5,195 4,926 Note: City of Phoenix revenue is budgeted on an annual basis. 2016-17 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2012-13 through 2015-16 actual revenues. Return to Summary Page - A3 - Apr Feb 4,141 4,799 4,920 5,024 5,358 May Mar 4,623 4,559 4,984 5,065 5,456 June Apr 3,676 3,826 4,408 5,512 4,942 May 4,088 4,643 5,108 4,943 5,328 June 4,834 4,778 5,027 5,983 5,850 Governmental Funds Revenue (Dollars in Thousands) Governmental Funds Revenue 240,000 2012-13 Actuals 220,000 2013-14 Actuals 200,000 2014-15 Actuals 180,000 2015-16 Actuals 160,000 2016-17 Actuals 16-17 budget 140,000 120,000 100,000 80,000 60,000 40,000 20,000 July FY 12-13 13-14 14-15 15-16 16-17 Budget 16-17 July 117,069 125,711 127,962 128,588 125,592 142,419 Aug Aug 123,710 137,320 138,394 155,197 165,819 158,810 Sept Sept 131,313 157,974 133,016 129,829 157,173 158,548 Oct Nov Oct 145,692 143,773 155,801 160,655 165,460 172,842 Nov 188,162 188,461 193,744 195,040 212,320 217,504 Dec Dec 167,796 169,767 162,290 172,648 218,635 192,272 Jan YTD thru December 873,743 923,006 911,207 941,958 1,044,999 1,042,395 Feb Mar Jan 160,895 153,911 151,099 160,567 178,935 Feb 134,498 132,551 144,296 141,861 158,278 Note: City of Phoenix revenue is budgeted on an annual basis. 2016-17 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2012-13 through FY 2015-16 actual revenues. Return to Summary Page - A4 - Apr Mar 142,641 144,892 150,768 160,707 172,229 May Apr 160,782 162,046 169,860 173,752 191,738 June May 182,000 204,907 192,623 193,402 220,777 June 241,207 177,153 167,673 244,902 240,614 Aviation Revenues (Dollars in Thousands) Aviation Operating Revenues 40,000 12-13 Actuals 35,000 13-14 Actuals 14-15 Actuals 30,000 15-16 Actuals 25,000 2016-17 Actuals 16-17 budget 20,000 15,000 10,000 July FY 12-13 13-14 14-15 15-16 16-17 Budget 16-17 Aug July 28,080 31,036 27,544 28,758 28,314 28,922 Sept Aug 26,231 22,760 26,594 27,373 29,777 25,800 Oct Sept 28,144 26,677 27,855 28,151 29,279 27,771 Nov Oct 30,124 26,505 26,489 29,050 28,339 28,108 Dec Jan Nov 26,471 26,222 27,610 29,039 30,504 27,399 Dec 28,146 27,171 27,853 25,795 24,926 27,305 Feb YTD thru December 167,198 160,372 163,946 168,166 171,140 165,305 Mar Apr Jan 27,054 26,659 27,917 28,789 27,669 Feb 27,884 26,561 26,683 27,161 27,136 Note: City of Phoenix revenue is budgeted on an annual basis. 2016-17 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2012-13 through FY 2015-16 actual revenues. Return to Summary Page - A5 - May Mar 31,100 28,352 30,414 31,530 30,420 June Apr 34,980 31,467 32,304 30,759 32,453 May 31,020 29,350 29,251 29,439 29,834 June 28,463 27,200 29,272 29,507 28,677 Water System Revenues (Dollars in Thousands) Water System Operating Revenues 80,000 12-13 Actuals 75,000 70,000 13-14 Actuals 65,000 60,000 14-15 Actuals 55,000 15-16 Actuals 50,000 45,000 16-17 Actuals 40,000 16-17 budget 35,000 30,000 25,000 20,000 15,000 10,000 July FY 12-13 13-14 14-15 15-16 16-17 Budget 16-17 Aug July 79,417 49,017 50,166 47,014 50,220 52,726 Sept Aug 42,419 42,137 40,684 43,100 47,104 45,414 Oct Sept 42,446 41,144 36,711 42,235 43,613 43,310 Nov Oct 34,197 34,917 30,601 34,778 37,360 36,172 Dec Jan Nov 36,338 34,774 32,130 30,252 34,083 35,039 Dec 25,523 22,327 24,573 24,406 26,073 25,717 Feb YTD thru December 260,340 224,316 214,865 221,786 238,453 238,378 Mar Apr Jan 21,738 22,872 21,031 22,460 23,934 Feb 18,711 21,185 19,044 19,179 21,425 Note: City of Phoenix revenue is budgeted on an annual basis. 2016-17 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 2015-16 actual revenues. Return to Summary Page - A6 - May Mar 21,386 21,993 20,725 24,487 24,238 June Apr 30,809 29,578 31,472 32,097 33,594 May 34,663 36,292 32,249 34,122 37,025 June 37,680 42,563 32,329 42,680 42,402 Wastewater Revenues (Dollars in Thousands) Wastewater Operating Revenues 12-13 Actuals 27,000 13-14 Actuals 14-15 Actuals 22,000 15-16 Actuals 16-17 Actuals 16-17 budget 17,000 12,000 7,000 2,000 July FY 12-13 13-14 14-15 15-16 16-17 Budget 16-17 Aug July 17,547 17,634 18,325 16,156 18,836 17,763 Sept Aug 18,057 18,252 18,520 18,477 19,359 18,832 Oct Sept 17,930 18,224 18,337 21,171 19,337 19,677 Nov Oct 17,684 17,798 17,754 18,058 18,611 18,273 Dec Nov 20,958 20,452 17,529 17,530 18,347 18,921 Jan Dec 17,744 17,763 18,276 18,697 19,493 18,656 Feb YTD thru December 109,920 110,123 108,740 110,090 113,984 112,122 Mar Jan 25,337 17,618 18,183 19,384 18,809 Note: City of Phoenix revenue is budgeted on an annual basis. 2016-17 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 2015-16 actual revenues. Return to Summary Page - A7 - Apr Feb 17,663 18,058 17,960 18,385 18,543 May Mar 14,263 14,986 17,538 18,659 17,445 June Apr 17,865 18,386 18,112 21,363 19,722 May 17,982 18,299 17,762 18,555 18,616 June 14,638 16,909 18,253 19,289 18,559