November 2016 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division City of Phoenix Monthly Financial Report November 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 Expected 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 Click on either the schedule name or the 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 Page Performance Status General Fund Total Operating Revenue 13 Expected Property Tax 14 Monitor and Consider Taking Action Local Sales Tax 15 Better than Expected State Sales Tax 16 Better than Expected Vehicle License Tax 17 Expected Governmental Funds 18 Monitor and Consider Taking Action Aviation 19 Better than Expected Water System 20 Expected Wastewater 21 Better than Expected Financial Schedules 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. November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 450,253 1,038,092 43.4% 450,295 1,042,102 43.2% 452,319 1,051,395 43.0% 463,607 1,066,521 43.5% 476,731 1,139,061 41.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 November YTD November 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 November 2016, actual general fund expenditures are 2.8% 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 44,878 102,211 43.9% 48,471 100,400 48.3% 43,081 96,385 44.7% 46,465 105,240 44.2% 50,519 114,998 43.9% * - For prior years-total actual expenditures, for current year-total approved budget Expected Criminal Justice General Government $120,000 $140,000 $100,000 $120,000 $80,000 $100,000 November YTD Expenditures November 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. General fund general government expenditures through November 2016 are 8.7% higher than the same period in the prior year. The fiscal year 2016-17 budget includes a 9.3% increase over fiscal year 2015-16 actuals. 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- November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 14,468 33,453 43.2% 14,120 32,659 43.2% 13,609 31,018 43.9% 15,138 30,698 49.3% 12,885 33,206 38.8% * - 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 November YTD Expenditures November 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 November 2016 are 14.9% 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 290,290 684,609 42.4% 294,031 699,796 42.0% 302,503 716,304 42.2% 318,254 737,129 43.2% 328,745 772,160 42.6% * - 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 November YTD Expenditures November 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 November 2016 are 3.3% 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- November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 17,773 38,161 46.6% 15,026 29,713 50.6% 16,331 34,187 47.8% 10,541 17,473 60.3% 6,979 21,924 31.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 November YTD Expenditures November 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 November 2016 are 33.8% lower than the same period in the prior year. The variance is resulting from a timing difference on expenditures charged to the AHUR funds and will resolve itself in December. 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 8,798 19,927 44.2% 9,255 20,210 45.8% 8,559 18,986 45.1% 8,531 18,571 45.9% 8,274 21,554 38.4% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $25,000 $25,000 November NovemberYTD 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. General fund community development expenditures through November 2016 are 3.0% lower than the same period in the prior year. The fiscal year 2016-17 budget includes a 16.1% increase over fiscal year 2015-16 actuals. 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- November General Fund YTD Expenditures (Dollars in Thousands) Community Enrichment 12-13 13-14 14-15 15-16 16-17 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 64,528 141,209 45.7% 63,311 143,665 44.1% 59,080 138,024 42.8% 60,184 141,483 42.5% 63,283 151,008 41.9% * - 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 NovemberYTD YTD November 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 November 2016 are 5.1% 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 8,662 15,353 56.4% 5,712 13,748 41.5% 7,823 15,082 51.9% 4,045 12,143 33.3% 4,669 14,285 32.7% * - 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 November 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 November 2016 are 15.4% 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. November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 1,358,940 3,123,865 43.5% 1,360,917 3,054,098 44.6% 1,373,955 3,051,875 45.0% 1,396,121 3,156,441 44.2% 1,440,496 3,822,337 37.7% * - 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 November YTD November 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 November 2016 are better than expected with an increase of 3.2% from the same period in the prior year. General Government 12-13 13-14 14-15 15-16 16-17 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 46,796 114,015 41.0% 50,558 114,235 44.3% 46,872 108,690 43.1% 50,280 118,505 42.4% 54,419 139,120 39.1% * - 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 November YTD Expenditures November 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 an increase of 8.2% through November 2016 over 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- November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 17,822 41,290 43.2% 17,614 40,697 43.3% 17,126 39,265 43.6% 18,656 39,463 47.3% 16,779 48,118 34.9% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Public Safety Criminal Justice $60,000 $200,000 November YTD Expenditures November 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 10.1% lower through November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 357,015 842,387 42.4% 354,032 842,270 42.0% 353,738 841,817 42.0% 368,569 874,558 42.1% 385,595 934,174 41.3% * - 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 November YTD Expenditures November 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 November 2016 are 4.6% 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- November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 333,829 582,381 57.3% 333,855 573,025 58.3% 336,901 582,486 57.8% 338,257 609,990 55.5% 351,910 671,988 52.4% * - 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 November YTD Expenditures November 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.0% higher through November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 96,187 209,403 45.9% 91,309 194,542 46.9% 85,506 188,670 45.3% 74,151 174,956 42.4% 76,224 226,028 33.7% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected CommunityDevelopment Enrichment Community $250,000 $250,000 NovemberYTD YTD November 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 an increase through November 2016 of 2.8% over the same period in the prior year. The 2016-17 budget includes an increase of 29.2% over 2015-16 actuals. -7- November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 118,475 273,110 43.4% 117,958 272,326 43.3% 115,275 259,944 44.3% 115,029 273,179 42.1% 125,030 298,792 41.8% * - 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 NovemberYTD YTD November 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 better than expected with an increase through November 2016 of 8.7% 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 249,213 564,051 44.2% 241,024 577,118 41.8% 233,725 545,198 42.9% 231,296 555,711 41.6% 254,857 626,701 40.7% * - 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 NovemberYTD YTD November 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 10.2% higher through November 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- November 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 November YTD Annual % of Annual Expenditures Expenditures * Expenditures 56,948 137,208 41.5% 41,994 100,524 41.8% 55,960 134,594 41.6% 63,619 154,710 41.1% 58,713 137,966 42.6% * - 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 NovemberYTD YTD November 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 November 2016 are 7.7% 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) $ 79,221 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). The fiscal year 2016-17 capital budget includes $156.4 million for transit related projects, $121.5 million for street construction, repair and maintenance, $95.1 million for sidewalks, traffic signals, bridges, bike lanes and street lighting improvements and maintenance, and $82.0 million for parks and recreation related projects. 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) $ 51,075 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 The fiscal year 2016-17 capital budget includes $17.0 million for Communications Center/EOC Design and Construction, $16.1 million for Terminal 4 North Apron Reconstruction, $15.0 million for RCC Building Improvements and $14.8 million for Terminal 3 Development. - 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) $ 8,706 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,419 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. The fiscal year 2016-17 capital budget includes $10.4 million for work at the SR85 landfill and $8.6 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) $ 10,458 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 The fiscal year 2016-17 capital budget includes $92.5 million for pipeline construction, rehabilitation and replacement, $29.0 million for treatment plant improvements, and $21.7 million for lift station improvements and replacements. 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) $ 31,474 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. The fiscal year 2016-17 capital budget includes $97.4 million for pipeline and water services construction, rehabilitation and replacement, $20.9 million for the demolition and restoration of the Verde WTP, and $12.6 million for rehabilitation at the Deer Valley WTP. - 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 Nov 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 Nov YTD Actuals 387,451 408,585 423,814 429,525 439,553 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 39.5% 39.8% 40.4% 40.4% 40.3% * - For prior years - total actual revenues, for current year - total approved budget Expected Fiscal year 2016-17 general fund operating revenues are budgeted to increase 2.6% over prior year actuals. Actual revenues through November 2016 are 2.3% 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 100,000 50,000 145,141 26,904 Secondary Primary 43,339 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 70,243 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 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 Monitor and Consider Taking Action 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. - 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 Better than Expected Local sales tax revenues through November 2016 are 4.3% above budget. The fiscal year 2016-17 budget includes an increase of 3.0% in local sales tax revenues over fiscal year 2015-16 actuals. 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 November 2016 local sales tax revenues are 7.7% 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%. 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 November 2016 are 1.7% 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 November 2016 state shared sales tax revenues are 4.2% 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 November 2016 are 0.8% lower 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 November 2016 state shared vehicle license tax revenues are 3.6% 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 Monitor and Consider Taking Action Governmental funds are those funds supported primarily through taxes, bonds and grants and include the general fund as well as funds with dedicated tax revenue streams. They do not include the enterprise funds. Governmental fund revenues through November 2016 are 2.8% lower 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 November 2016, governmental funds revenues are 7.4% 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 November 2016 are 6.0% 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 November 2016, aviation operating revenues are 2.7% 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 November 2016 are 0.1% lower 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 November 2016 revenues are 7.6% 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 November 2016 are 1.1% 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 NOVEMBER 30 (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 $ 188,325 251 $ 174,848 666 141,696 187,210 61,042 145,141 2,786 10,090 56,593 79,728 24,374 43,339 1,091 2,608 54,317 72,597 23,529 55,753 980 2,447 14,327 915 13,803 672 7,818 1,680 3,472 4,484 368 4,963 307 3,933 782 1,640 5,937 271 5,354 253 2,866 692 1,417 34,700 12,299 3,500 14,737 14,081 5,179 1,440 6,067 14,347 5,306 1,319 6,626 1,091,343 - 22 - $ 439,553 $ 429,525 General Fund Expenditures As of NOVEMBER 30 (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 632 $ 1,409 1,510 16,132 780 901 7,914 931 1,835 4,085 1,539 11,548 1,303 50,519 631 1,321 1,389 13,644 639 887 7,394 923 1,538 3,376 1,257 11,202 2,264 46,465 28,112 5,094 33,206 11,004 1,881 12,885 10,922 4,216 15,138 498,786 273,282 92 772,160 219,267 109,515 (37) 328,745 212,546 105,404 304 318,254 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 5,327 1,652 6,979 8,872 1,669 10,541 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 5,064 12,115 4,321 54 21,554 1,964 4,580 1,710 20 8,274 2,011 4,833 1,667 20 8,531 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 91,391 35,282 18,511 5,824 151,008 39,555 14,130 6,666 2,932 63,283 38,061 13,281 6,370 2,472 60,184 Environmental Services Public Works Environmental Programs Total Environmental Services 13,616 669 14,285 4,546 123 4,669 3,932 113 4,045 9,926 1,377 449 83,146 - Capital Improvement Contingencies Total Expenditures and Encumbrances $ 1,222,207 - 23 - $ 476,731 $ 463,607 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 NOVEMBER 30 (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 $ $ 188,325 251 $ $ 174,848 666 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 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 56,593 79,728 24,374 43,339 1,091 2,608 4,852 4,963 307 3,933 782 1,640 19,260 1,440 6,067 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 54,317 72,597 23,529 55,753 980 2,447 6,208 5,354 253 2,866 692 1,417 19,653 1,319 6,626 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 $ 439,553 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 12,101 24,160 12,460 1,617 100,530 940 28,160 4,971 6,206 47,505 16,835 2,061 17,782 84,580 26,904 1,113,621 386,812 341,495 64,247 420,996 223,816 147,789 146,213 24,206 212,380 94,491 62,569 1,198,343 539,859 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 - $ 429,525 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 11,498 35,802 11,498 1,763 68,783 980 25,268 5,512 5,828 44,759 16,967 2,456 15,042 73,407 20,222 339,785 $ $ $ $ $ 1,366,224 $ 142,371 23,201 197,379 91,393 61,608 515,952 1,285,262 Citywide Operating Expenditures As of NOVEMBER 30 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2016-2017 2015-2016 Budget 2016-2017 50,519 $ 3,900 54,419 46,465 3,815 50,280 33,206 14,912 48,118 12,885 3,894 16,779 15,138 3,518 18,656 Public Safety General Funds Other Funds Total Public Safety 772,160 162,014 934,174 328,745 56,850 385,595 318,254 50,315 368,569 Transportation General Funds Other Funds Total Transportation 21,924 650,064 671,988 6,979 344,931 351,910 10,541 327,716 338,257 Community Development General Funds Other Funds Total Community Development 21,554 204,474 226,028 8,274 67,950 76,224 8,531 65,620 74,151 Community Enrichment General Funds Other Funds Total Community Enrichment 151,008 147,784 298,792 63,283 61,747 125,030 60,184 54,845 115,029 Environmental Services General Funds Other Funds Total Environmental Services 14,285 612,416 626,701 4,669 250,188 254,857 4,045 227,251 231,296 Debt Service General Funds Other Funds Total Debt Service 137,966 137,966 58,713 58,713 63,619 63,619 Capital Improvement General Funds Other Funds Total Capital Improvement 9,926 729,524 739,450 1,377 115,592 116,969 449 135,815 136,264 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 - 476,731 963,765 1,440,496 $ 463,607 932,514 1,396,121 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 NOVEMBER 30 2016 2015 Budget Estimate 2016-2017 Source Actual Year-to-Date 2016-2017 2015-2016 General Funds $ 34,433,208 277,232 Local Taxes: Sales Taxes Privilege License Fees 34,740,662 34,710,440 Total Local Taxes 435,455,000 188,576,537 175,513,502 11,443,130 15,945,590 4,241,749 11,100,186 14,519,501 4,291,458 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 141,696,000 187,210,000 61,042,000 56,592,579 79,727,951 24,373,599 54,316,654 72,597,508 23,528,665 31,630,469 29,911,145 389,948,000 160,694,129 150,442,827 35,853,017 44,151,599 Primary Property Tax 145,141,000 43,338,997 55,753,092 206,377 152,154 Licenses and Permits 2,786,000 1,091,206 979,940 2,436,904 2,437,271 Cable Communications 10,090,000 2,607,664 2,447,321 817,165 66,979 1,089,798 42,638 Municipal Court: Fines and Forfeitures Court Default Fee 14,326,586 915,000 4,484,079 367,994 5,936,983 271,162 884,144 1,132,436 15,241,586 4,852,073 6,208,145 1,206,065 1,915,706 13,803,108 4,962,780 5,353,777 67,746 44,225 672,215 307,061 252,755 Parks and Recreation 7,817,520 3,933,077 2,866,086 34,692,434 48,228 1,342,416 $ (246,146) $ Total State Shared Taxes Total Municipal Court Police Library Fees 433,000,000 2,455,000 $ 188,325,134 251,403 $ 174,847,845 665,657 148,580 136,516 Planning and Development 1,679,900 781,841 692,246 353,297 349,769 Street Transportation 3,472,000 1,639,982 1,417,033 2,623,723 72,129 1,299,219 1,957,199 69,825 123,322 34,700,000 1,550,000 10,749,485 14,081,171 327,325 4,851,577 14,346,472 326,865 4,979,291 3,995,071 2,150,346 46,999,485 19,260,073 19,652,628 279,143 274,741 3,500,000 1,440,266 1,319,242 2,325,362 1,859,810 14,737,022 6,066,838 6,626,179 115,469,253 118,980,012 1,091,342,836 439,552,524 429,524,773 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire Interest Other Fees and Service Charges Total General Funds - 26 - Citywide Operating Revenue by Source (continued) For the Month Ended NOVEMBER 30 2016 2015 Budget Estimate 2016-2017 Source Actual Year-to-Date 2016-2017 2015-2016 Special Revenue and Debt Service Funds $ 1,658,120 118,437 592,186 66,177 $ 1,619,769 115,697 578,490 26,166 2,434,920 2,340,122 2,237,837 (3,821) 91,706 5,143,919 1,809,137 (5,234) 2,325,722 6,947,822 2,409,465 2,353,133 300,313 0 178,823 (240) 2,434 337,235 0 199,931 (1,015) (3,592) 481,330 532,559 15,960,055 3,901,198 9,250,099 3,582,557 19,861,253 12,832,656 0 0 4,411,319 3,795,294 991,066 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 $ 20,744,000 1,481,000 7,413,000 295,376 8,290,678 592,191 2,960,956 257,498 $ 7,945,586 567,541 2,837,710 147,109 29,933,376 12,101,323 11,497,946 64,007,000 22,023,000 45,000 19,053,250 4,800,738 306,385 26,297,075 9,526,757 (21,982) 86,075,000 24,160,373 35,801,850 29,991,315 12,459,746 11,497,936 3,710,739 0 2,225,017 (10,000) 94,257 Total Golf Courses $ 844,928 0 724,477 (295) 47,754 1,010,983 82 716,165 (763) 36,487 6,020,013 1,616,864 1,762,954 206,782,000 56,438,091 79,473,995 21,055,790 45,261,615 23,521,390 263,220,091 100,529,785 68,783,005 4,088,873 940,000 980,000 Planning and Development 47,058,000 28,159,873 25,268,062 1,096,613 Capital Construction 12,051,000 4,970,953 5,512,455 1,559,414 119,393 1,520,681 15,379 Sports Facilities: Sales Taxes Interest/Other 18,702,000 8,815,726 6,006,575 199,696 5,658,953 168,597 1,678,807 1,536,060 27,517,726 6,206,271 5,827,550 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 NOVEMBER 30 2016 2015 Budget Estimate 2016-2017 Source Actual Year-to-Date 2016-2017 2015-2016 Special Revenue and Debt Service Funds (Cont'd) $ 9,557,586 51,830 8,393 9,077,429 61,655 0 9,617,809 9,139,084 4,675,691 3,819,855 202,879 377,083 8,076,725 $ 847,328 5,307,335 621,935 (469,577) $ 427,721 5,489,820 142,025 Highway User Revenue: Highway User Revenue Interest Other Total Highway User Revenue Regional Transit Revenues Community Reinvestment Other Restricted Fees Grants: Public Housing: Rentals Grants Other $ 6,776,598 6,059,566 Total Public Housing 3,877,805 0 4,101,166 2,828,021 4,761,758 925,240 2,706,390 1,225,728 10,806,992 9,619,116 17,583,590 15,678,682 22,100,466 9 16,080,557 0 22,100,475 16,080,557 Total G.O. Bond/Secondary Property Tax 96,851,051 76,059,943 Total Special Revenue and Debt Service Funds 115,992,000 400,000 150,000 46,966,381 254,021 285,047 44,420,025 243,446 95,914 116,542,000 47,505,449 44,759,385 48,139,440 16,834,541 16,966,596 5,413,996 2,060,679 2,456,165 47,391,330 17,781,684 15,042,287 6,457,040 79,392,390 6,174,228 $ 3,321,243 27,240,413 7,306,005 $ 2,726,108 27,526,419 2,072,097 92,023,658 37,867,661 32,324,624 43,099,854 82,258,927 39,982,633 37,451,348 15,075,392 9,860,304 5,658,182 16,118,290 15,102,062 4,512,583 7,179,674 14,288,326 Total Other 202,792,762 46,712,168 41,082,645 Total Grants 294,816,420 84,579,829 73,407,269 90,622,120 4,741,740 26,903,941 148 20,221,734 256 95,363,860 26,904,089 20,221,990 1,113,622,440 386,811,459 339,785,450 137,300,000 194,137,000 1,500,000 3,339,000 2,193,000 3,025,500 - 41,447,622 99,540,155 846,752 1,765,434 1,009,670 1,286,463 317,400 40,799,476 96,957,545 650,390 1,594,600 937,625 1,217,741 213,519 341,494,500 146,213,496 142,370,896 Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond/Secondary Property Tax Secondary Property Tax Interest Enterprise Funds AVIATION: 8,252,785 21,281,853 170,018 197,981 257,094 320,324 23,773 8,213,980 20,123,981 28,424 198,352 182,611 235,797 55,464 30,503,828 29,038,609 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 NOVEMBER 30 2016 2015 Budget Estimate 2016-2017 Source Actual Year-to-Date 2016-2017 2015-2016 Enterprise Funds (Cont'd) CONVENTION CENTER: $ 4,050,066 1,861,910 38,541 3,842,584 1,775,099 37,652 5,950,517 5,655,335 Excise Taxes Operating Revenue Interest Total Convention Center 46,726,000 17,303,084 218,012 17,680,925 6,345,174 180,106 16,744,174 6,309,332 147,216 64,247,096 24,206,205 23,200,722 WATER SYSTEM: $ 32,460,316 $ 376,306 378,915 (127,052) 360,300 192,073 441,857 28,774,793 354,396 166,483 516,178 144,180 205,667 90,095 34,082,715 30,251,792 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 $ 201,241,598 1,988,506 2,652,080 2,971,198 1,421,850 952,364 1,152,485 $ 186,574,298 2,303,106 2,911,591 2,703,656 1,150,080 908,388 828,159 420,996,000 212,380,081 197,379,278 192,431,000 15,822,000 3,100,000 1,435,000 11,028,000 79,068,388 8,263,889 1,341,480 752,747 5,064,307 77,275,357 8,286,923 1,090,110 650,972 4,089,795 223,816,000 94,490,811 91,393,157 129,906,427 8,647,399 305,000 8,929,739 53,852,990 3,612,841 280,337 4,822,846 53,535,901 3,600,510 259,226 4,212,280 147,788,565 62,569,014 61,607,917 1,198,342,161 539,859,607 515,951,970 WASTEWATER: 15,594,819 1,517,034 340,080 144,719 750,258 15,192,021 1,607,738 138,540 135,678 456,026 18,346,910 17,530,003 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: $ 10,774,374 588,045 55,468 1,110,843 10,675,376 758,766 66,099 801,117 12,528,730 12,301,358 101,412,700 94,777,097 313,733,004 $ 289,817,052 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ - 29 - 3,403,307,437 $ 1,366,223,590 $ 1,285,262,193 Citywide Operating Expenditures by Program For the Month Ended NOVEMBER 30 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 $ 135,652 276,575 387,079 3,372,792 289,531 204,334 249,982 1,720,063 219,475 379,065 12,077 875,248 57,485 49,556 169,378 9,098 354,297 2,563,887 238,189 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 11,563,763 123,726 261,474 368,530 3,216,108 62,391 178,112 201,067 1,592,893 207,840 284,800 95,503 684,492 56,582 (16,260) 183,840 7,289 258,044 1,653,450 717,666 10,137,547 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 631,796 1,408,574 1,641,152 17,236,095 536,644 947,499 1,049,283 8,407,787 931,174 1,834,653 25,753 4,827,694 296,845 256,024 397,258 50,046 1,538,488 13,121,059 (718,954) $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 54,418,870 631,166 1,321,028 1,367,003 14,557,310 364,841 803,875 1,108,986 7,708,065 923,181 1,538,275 884,600 3,850,349 260,099 195,027 711,937 42,787 1,257,190 12,295,692 458,314 $ 631,796 1,408,574 1,641,152 16,480,890 536,644 947,499 1,049,283 8,407,787 931,174 1,834,653 25,753 4,471,440 296,845 256,024 397,258 50,046 1,538,488 12,458,562 (718,954) 755,205 356,254 662,497 - 50,279,725 52,644,914 1,773,956 14,440,458 4,215,797 - 11,819,804 1,881,114 - 3,078,151 - 18,656,255 13,700,918 3,078,151 244,241,604 123,815,465 512,209 254,912,393 127,213,218 333,151 2,175,432 960,235 - 368,569,278 382,458,762 3,135,667 Criminal Justice 2,997,473 404,218 - $ $ $ 3,401,691 2,816,219 157,725 2,973,944 Municipal Court Public Defender Other Total Criminal Justice 43,023,685 5,093,954 - $ $ $ 48,117,639 14,897,955 1,881,114 - $ $ $ 16,779,069 Public Safety 48,955,601 26,468,254 66,435 75,490,290 $ $ $ 44,128,026 23,067,363 100,973 67,296,362 Police Fire Other Total Public Safety 613,942,012 319,414,035 817,576 $ $ $ 934,173,623 257,087,825 128,173,453 333,151 385,594,429 - 30 - $ $ $ Citywide Operating Expenditures by Program (continued) For the Month Ended NOVEMBER 30 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 $ 4,847,959 1,287,665 22,795,459 9,299,570 $ $ $ $ 38,230,653 4,321,270 557,858 19,823,824 14,428,005 39,130,957 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 63,631,138 11,223,396 300,867,783 296,265,820 $ $ $ $ 671,988,137 23,710,189 4,601,080 122,073,231 201,525,311 $ $ $ $ 351,909,811 22,027,573 4,428,631 109,655,421 202,145,349 $ $ $ $ 338,256,974 23,540,729 4,601,080 98,477,600 171,026,310 $ $ $ $ 297,645,719 169,460 23,595,631 30,499,001 54,264,092 Community Development 3,919,383 6,746,326 1,983,610 2,118,193 $ $ $ $ 14,767,512 3,636,397 6,273,970 1,867,634 2,227,641 Planning and Development Housing Economic Development Neighborhood Services Department 53,383,420 91,468,988 27,958,662 53,217,436 14,005,642 Total Community Development 226,028,506 $ $ $ $ 19,236,121 36,219,787 9,890,386 10,877,751 $ $ $ $ 76,224,045 16,548,177 35,064,671 11,486,575 11,051,114 $ $ $ $ 74,150,537 19,236,121 36,189,225 8,419,859 10,877,751 $ $ $ $ 74,722,956 30,562 1,470,527 1,501,089 Community Enrichment 7,413,912 2,789,511 670,916 11,031,076 980,382 4,712,541 359,241 238,721 28,196,300 $ $ $ $ $ $ $ $ 7,058,740 2,841,585 488,569 4,994,524 943,014 4,618,652 382,493 241,503 21,569,080 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 42,396,402 14,311,043 2,567,424 30,624,247 4,938,025 25,626,153 2,396,980 2,169,906 125,030,180 - 31 - $ $ $ $ $ $ $ $ 41,303,451 13,490,803 2,453,505 24,164,954 4,718,367 25,210,155 1,852,151 1,836,126 115,029,512 $ $ $ $ $ $ $ $ 42,225,433 14,311,043 2,567,424 22,389,676 25,504,427 2,396,980 2,169,906 111,564,889 $ $ $ $ $ $ $ $ 170,969 8,234,571 4,938,025 121,726 13,465,291 Citywide Operating Expenditures by Program (continued) For the Month Ended NOVEMBER 30 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 $ 27,316,990 12,092,427 10,027,839 1,645,114 149,172 $ $ $ $ $ 51,231,542 24,498,266 11,072,769 9,259,539 (178,108) 114,259 44,766,725 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 128,265,313 61,159,273 57,839,795 7,644,601 (51,993) $ $ $ $ $ 254,856,989 117,773,589 57,203,913 49,645,331 6,663,904 9,230 $ $ $ $ $ 231,295,967 83,801,053 32,782,341 52,964,773 4,565,562 (51,993) 174,061,736 44,464,260 28,376,932 4,875,022 3,079,039 80,795,253 General Obligation Debt Service 16,421 1,314,301 2,505,573 69,857 418,458 40,709 1,122,186 176,454 596,422 563,534 110,909 1,196,673 32,525 618,312 443,902 180,848 13 115,327 1,401,853 463,092 512 552,718 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 11,940,599 15,503,481 $ 250,325,831 $ $ 16,421 1,214,797 2,366,799 69,429 404,942 33,321 1,134,549 173,496 451,049 628,009 117,322 1,045,463 74,591 582,627 521,114 657,381 115,073 1,258,618 425,245 512 1,433,028 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,765,428 Capital Improvement 739,449,828 $ Contingencies 134,646,000 $ 229,369,471 Total Operating Budget 82,104 6,506,429 12,097,315 347,502 1,969,087 166,942 5,583,871 872,194 2,954,849 2,736,032 541,560 5,819,326 162,625 2,959,069 2,219,510 904,242 454,073 576,635 6,795,654 2,197,543 2,562 2,763,590 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 58,712,714 3,956,982,515 116,969,449 1,440,495,556 - 32 - 82,104 6,073,984 11,833,994 347,146 2,024,712 166,604 5,672,743 867,478 2,255,244 3,140,045 586,613 5,227,318 372,958 2,913,137 2,605,567 3,286,902 575,365 6,293,090 2,126,222 2,562 7,165,142 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 63,618,930 $ $ 136,263,529 1,396,120,707 82,104 6,506,429 12,097,315 347,502 1,969,087 166,942 5,583,871 872,194 2,954,849 2,736,032 541,560 5,819,326 162,625 2,959,069 2,219,510 904,242 454,073 576,635 6,795,654 2,197,543 2,562 2,763,590 - 58,712,714 - $ - $ 1,165,512,608 116,969,449 274,982,948 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 $ 108,679 436,416 494,581 331,710 71,416 2,617,374 10,384,011 6,962 348,919 6,422,187 312,478 23,417,036 1,207,773 33,061,483 3,189,498 861,179 210,942 124,696 424,065 45,195 7,385,123 9,549,686 14,823 90,964 5,803,738 1,824,855 10,995,568 1,659,228 34,958,963 $ 608,878,256 $ 79,221,025 $ 77,138,523 $ $ 223,028,686 23,212,500 30,145,097 150,665,033 232,192,011 659,243,327 $ 1,268,121,583 $ $ 51,074,980 8,706,173 4,419,302 10,457,743 31,474,377 106,132,575 $ 185,353,600 $ $ 424,752,230 8,925,728 564,178 8,121,747 57,507,480 499,871,363 $ 577,009,886 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 108,679 436,416 494,581 148,007 1,137,733 2,684,369 3,397 336,013 6,409,303 298,651 23,224,059 29,057,859 398,999,302 $ 64,339,067 $ 67,466,730 2,763,500 28,944,000 66,861,650 174,414,646 340,450,526 $ 739,449,828 - 33 - $ $ 10,479,118 185,756 4,344,979 8,453,263 29,167,266 52,630,382 $ 116,969,449 $ $ $ 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 183,703 71,416 1,479,641 7,699,642 3,565 12,906 12,884 13,827 192,977 1,207,773 4,003,624 209,878,954 $ 14,881,958 $ 155,561,956 20,449,000 1,201,097 83,803,383 57,777,365 318,792,801 $ 528,671,755 $ Unencumbered Budget $ 1,117,899 11,222,000 763,584 10,919,126 669,511 14,472,702 1,107,066 19,667,514 600,000 47,563,388 622,164 4,467,112 75,651,523 652,522 132,950,047 7,354,146 199,856,927 $ 529,657,231 $ 40,595,862 8,520,417 74,323 2,004,480 2,307,111 53,502,193 $ $ 171,953,706 14,506,327 25,725,795 140,207,290 200,717,634 553,110,752 $ 68,384,151 $ 1,082,767,983 Bonds Authorized and Sold As of NOVEMBER 30 (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 39,187 36,692 Sept Sept 34,254 35,873 35,290 35,079 36,904 36,454 Oct Nov Oct 33,337 35,068 34,621 35,459 41,685 35,932 Dec Nov 33,430 34,363 33,033 34,433 34,692 35,095 Jan YTD thru November 169,302 177,253 174,722 174,848 188,325 180,620 Feb Dec 32,504 32,474 35,062 32,783 34,463 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. 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 YTD thru November 46,587 49,531 51,969 54,317 56,593 55,636 Jan Feb Dec 9,462 10,296 10,695 11,623 11,566 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 YTD thru November 19,444 21,276 22,329 23,529 24,374 24,565 Feb Dec 3,993 3,872 3,857 4,550 4,617 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 Dec 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 YTD thru November 705,947 753,238 748,917 769,310 826,364 850,123 Jan Dec 167,796 169,767 162,290 172,648 192,272 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 YTD thru November 139,051 133,200 136,093 142,371 146,213 138,000 Feb Dec 28,146 27,171 27,853 25,795 27,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 YTD thru November 234,817 201,989 190,292 197,379 212,380 212,661 Feb Dec 25,523 22,327 24,573 24,406 25,717 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 YTD thru November 92,177 92,360 90,464 91,393 94,491 93,466 Feb Dec 17,744 17,763 18,276 18,697 18,656 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