April 2017 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division City of Phoenix Monthly Financial Report April 2017 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 Expected 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 be taken directly to that page of the report. 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 Better than Expected positive or negative. Environmental Services 8 Better than Expected Monitor and Consider Taking Action - Negative General Obligation Debt Service 9 Expected variance greater than 1% actual vs budget. Capital Expenditures CIP-General Government 10 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 Corrective Action Taken - Negative variance Performance Status Monitor and Consider Taking Action Property Tax 14 Better than Expected Local Sales Tax 15 Monitor and Consider Taking Action State Sales Tax 16 Expected Vehicle License Tax 17 Better than Expected Governmental Funds 18 Monitor and Consider Taking Action Aviation 19 Better than Expected Water System 20 Monitor and Consider Taking Action 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. April 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 861,949 1,038,092 83.0% 864,555 1,042,102 83.0% 869,945 1,051,395 82.7% 885,014 1,066,521 83.0% 919,246 1,139,061 80.7% * - 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 April YTD April 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 April 2017, actual general fund expenditures are 3.9% 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 83,915 102,211 82.1% 83,849 100,400 83.5% 82,940 96,385 86.1% 88,632 105,240 84.2% 90,835 114,998 79.0% * - 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 April YTD Expenditures April 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 April 2017 are 2.5% higher than the same period in the prior year. Although personal services costs have increased 8.2% ($6.7 million) over the same period in fiscal year 2015-16, the budgeted increase over prior year actuals was 13.2%. Additionally, expenditures charged to other departments, which are budgeted to increase 5.9% over prior year actuals, have increased 16.4% ($3.2 million) which partially offsets the personal services increases. 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- April General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Criminal Justice April YTD Annual % of Annual Expenditures Expenditures * Expenditures 27,903 33,453 83.4% 27,135 32,659 83.1% 25,886 31,018 83.5% 26,075 30,698 84.9% 25,549 33,206 76.9% 12-13 13-14 14-15 15-16 16-17 * - 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 April YTD Expenditures April 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. The fiscal year 2016-17 budget includes an 8.2% increase over fiscal year 201516 actuals. General fund criminal justice expenditures through April 2017 are 2.0% 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 in fiscal year 2016-17 and are instead only showing as expenditures when utilized. Personal services expenditures were budgeted to increase 10.4% over prior year actuals, however, through April the increase has only been 1.5% over the same period in the prior year. 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 570,270 684,609 83.3% 582,201 699,796 83.2% 591,045 716,304 82.5% 615,892 737,129 83.6% 642,504 772,160 83.2% * - For prior years-total actual expenditures, for current year-total approved budget 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 April YTD Expenditures April 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. The general fund public safety fiscal year 2016-17 budget includes a 4.8% increase over fiscal year 2015-16 actuals. Expenditures through April 2017 are 4.3% higher than the same period in the prior year. General fund public safety expenditures have been steadily increasing at 2-3% per year since fiscal year 2012-13. - 2- April 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 31,750 38,161 83.2% 25,199 29,713 84.8% 29,509 34,187 86.3% 13,569 17,473 77.7% 15,045 21,924 68.6% * - 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 April YTD Expenditures April 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 are reduced by transfers to Arizona Highway User Revenue (AHUR) Funds, however, these transfers are based on AHUR revenues, not on expenditure levels. For fiscal year 2016-17, the available AHUR funds increased by 3.1% over the prior year. At the same time, general fund transportation personal services costs were expected to increase 13.0%. Since the majority of the increase remains in the general fund, the result is a 25.5% increase in budgeted expenditures over prior year actuals. Since actual personal services costs through April 2017 are only 8.0% higher than prior year actuals and the AHUR transfers are 3.1% higher than the prior year, the resulting increase in general fund transportation expenditures through April 2017 is 10.9%. 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 16,485 19,927 82.7% 17,068 20,210 84.5% 15,784 18,986 83.1% 15,429 18,571 83.1% 16,101 21,554 74.7% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $25,000 $25,000 April AprilYTD 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 April 2017 are 4.4% higher than the same period in the prior year with a 7.2% 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- April General Fund 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 115,394 141,209 81.7% 117,201 143,665 81.6% 111,917 138,024 81.1% 113,284 141,483 80.1% 118,015 151,008 78.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected 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 AprilYTD YTD April 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 April 2017 are 4.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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 13,684 15,353 89.1% 10,726 13,748 78.0% 11,779 15,082 78.1% 10,107 12,143 83.2% 8,866 14,285 62.1% * - 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 April 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 April 2017 are 12.3% lower 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. April 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 2,568,567 3,123,865 82.2% 2,491,992 3,054,098 81.6% 2,529,328 3,051,875 82.9% 2,560,817 3,156,441 81.1% 2,774,181 3,822,337 72.6% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustments for contingencies and use of the early redemption fund. Better than Expected 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 April YTD April 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 April 2017 are better than expected with an increase of 8.3% from the same period in the prior year. General Government 12-13 13-14 14-15 15-16 16-17 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 93,799 114,015 82.3% 95,557 114,235 83.6% 92,813 108,690 85.4% 100,354 118,505 84.7% 102,182 139,120 73.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 April YTD Expenditures April 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 1.8% through April 2017 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- April 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 34,464 41,290 83.5% 33,870 40,697 83.2% 32,765 39,265 83.4% 33,076 39,463 83.8% 33,956 48,118 70.6% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Public Safety Criminal Justice $60,000 $200,000 April YTD Expenditures April 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 2.7% higher through April 2017 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 in fiscal year 2016-17 and are instead only showing as expenditures when utilized. 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 700,285 842,387 83.1% 701,221 842,270 83.3% 699,108 841,817 83.0% 729,201 874,558 83.4% 757,202 934,174 81.1% * - 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 April YTD Expenditures April 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 April 2017 are 3.8% 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- April 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 507,425 582,381 87.1% 500,558 573,025 87.4% 510,089 582,486 87.6% 517,654 609,990 84.9% 545,544 671,988 81.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Transportation Community Development $600,000 $800,000 $580,000 $700,000 $560,000 $600,000 $540,000 $500,000 $520,000 $400,000 $500,000 $300,000 $480,000 $200,000 $460,000 $100,000 $440,000 $0 April YTD Expenditures April 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 5.4% higher through April 2017 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 176,493 209,403 84.3% 164,104 194,542 84.4% 158,408 188,670 84.0% 145,697 174,956 83.3% 152,678 224,802 67.9% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected CommunityDevelopment Enrichment Community $250,000 $250,000 AprilYTD YTD April 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 April 2017 of 4.8% over the same period in the prior year. The 2016-17 budget includes an increase of 28.5% over 2015-16 actuals. -7- April 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 220,932 273,110 80.9% 226,042 272,326 83.0% 216,166 259,944 83.2% 223,403 273,179 81.8% 234,786 298,691 78.6% * - 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 Better than Expected AprilYTD YTD April 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 April 2017 of 5.1% over the same period in the prior year. The budgeted increase for fiscal year 2016-17 over prior year actuals is 9.3%. Environmental Services 12-13 13-14 14-15 15-16 16-17 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 471,225 564,051 83.5% 479,011 577,118 83.0% 453,194 545,198 83.1% 457,301 555,711 82.3% 491,466 626,701 78.4% * - 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 AprilYTD YTD April 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 7.5% higher through April 2017 than the same period in the prior year. The budgeted increase for fiscal year 2016-17 over prior year actuals is 12.8%. -8- April 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 April YTD Annual % of Annual Expenditures Expenditures * Expenditures 114,438 137,208 83.4% 83,985 100,524 83.5% 112,351 134,594 83.5% 127,238 154,710 82.2% 114,405 137,966 82.9% * - For prior years-total actual expenditures, for current year-total approved budget net of credit for early redemption fund resources Expected 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 AprilYTD YTD April 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 April 2017 are 10.1% 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) 16-17 (YTD) $ 238,739 $ 615,494 $ 164,079 14-15 $ 244,107 Discussion: General Gov't Major Projects in fiscal year 2013-14 include technology acquisitions for E-Procurement and Regional Wireless Communications ($21 million), street projects ($67 million), and Police PACE Upgrade/Replacement ($12 million). 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 April 2017, the City has committed or spent $20 million for the 48th St and Washington Light Rail Station, $25 million for wireless communication in the regional bus system, $45 million for street construction, repair and maintenance, $25 million for sidewalks, traffic signals, bridges, bike lanes and street lighting improvements and maintenance and $21 million for parks, preserves and recreation facility improvements. Aviation 12-13 13-14 $ 168,639 $ 180,571 14-15 $ 259,616 15-16 16-17 (Budget) 16-17 (YTD) $ 522,633 $ 223,029 $ 117,661 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 April 2017, Aviation has spent or committed $18.2 million for runway, apron and taxiway projects, $14.1 million for Communications Center/EOC Design and Construction, $10.0 million for PHX Sky Train phase 2 and $8.3 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) $ 17,549 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,233 $20,000 $30,000 16-17 (YTD) $ 6,651 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 April 2017, Solid Waste has spent or committed $3.1 million on the 27th Avenue Composting Facility and $2.1 million on 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,619 16-17 (YTD) $ 66,313 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 April 2017, Wastewater has spent or committed $17.5 million to construct, replace or rehabilitate pipelines, $6.7 million for improvements at the 23rd Avenue wastewater treatment plant and $9.0 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) 16-17 (YTD) $ 226,863 $ 145,120 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 April 2017, Water has spent or committed $46.2 million to construct, replace or rehabilitate pipelines and valves, $18.5 million for rehabilitation at the Deer Valley water treatment plant, $13.3 million for reservoir rehabilitation and $8.2 million for water resiliency. - 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 Apr 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 Apr YTD Actuals 782,590 825,557 844,209 852,464 859,770 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 79.8% 80.5% 80.6% 80.2% 78.8% * - For prior years - total actual revenues, for current year - total approved budget Monitor and Consider Taking Action Fiscal year 2016-17 general fund operating revenues are budgeted to increase 2.6% over prior year actuals. Actual revenues through April 2017 are 0.9% 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 49,567 35,204 Secondary 50,484 59,229 100,000 50,000 132,101 143,931 12-13 13-14 145,141 141,310 138,243 Primary 95,371 - FY 12-13 13-14 14-15 15-16 16-17 YTD 16-17 budget Total 194,112 179,136 187,811 191,793 154,601 235,763 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,013 10,261 Feb 4,743 3,818 2,958 3,815 4,033 4,469 16-17 budget Mar 6,670 5,668 5,135 5,779 6,593 6,997 Apr 8,323 7,300 9,411 9,409 12,231 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 April 2017, property tax revenues are 23.5% 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 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 revenues through April 2017 are 6.6% below budget. The lower revenues are in part related to timing differences and reporting issues related to the requirement that all sales taxes be reported to the Department of Revenue and then disbursed to the cities. Due to variability in the State’s closing process, we will likely see more variability in monthly revenues, however, annual revenues will be accounted for through accrual entries that will be reported on the June 2017 report. Monthly revenue figures for August 2016 through November 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 April 2017 local sales tax revenues are 3.2% lower 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 November 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 Expected State shared sales tax revenues through April 2017 are 1.0% 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 April 2017 state shared sales tax revenues are 3.6% 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 Better than Expected State shared vehicle license tax revenues through April 2017 are 1.8% 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 April 2017 state shared vehicle license tax revenues are 3.9% 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 April 2017 are 2.0% 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 April 2017, governmental funds revenues are 8.2% 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 April 2017 are 2.8% 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 April 2017, aviation operating revenues are 1.6% 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 Monitor and Consider Taking Action Water system revenues through April 2017 are 2.5% 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 April 2017 revenues are 4.1% 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 April 2017 are 2.4% 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 APRIL 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 $ 336,416 1,302 $ 347,432 2,340 141,696 187,210 61,042 145,141 2,786 10,090 118,349 159,354 50,782 95,371 2,273 5,213 114,189 145,195 48,874 92,305 2,277 7,378 14,327 915 13,803 672 7,818 1,680 3,472 9,945 932 11,541 585 5,776 1,384 5,063 11,704 848 10,257 523 5,841 1,336 3,594 34,700 12,299 3,500 14,737 27,917 11,509 3,225 12,833 30,485 11,448 2,816 13,622 1,091,343 - 22 - $ 859,770 $ 852,464 General Fund Expenditures As of APRIL 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 1,299 $ 2,781 2,852 27,461 1,555 1,718 15,470 2,047 3,293 8,614 2,977 18,733 2,035 90,835 1,194 2,603 2,675 28,772 1,410 1,816 15,259 1,685 3,150 7,410 2,454 17,862 2,342 88,632 28,112 5,094 33,206 21,774 3,775 25,549 21,260 4,815 26,075 498,786 273,282 92 772,160 422,304 220,189 11 642,504 404,742 210,685 465 615,892 Transportation Street Transportation Public Transit Total Transportation 20,272 1,652 21,924 13,393 1,652 15,045 11,900 1,669 13,569 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 5,064 12,115 4,321 54 21,554 3,788 9,013 3,259 41 16,101 3,562 8,497 3,329 41 15,429 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 91,391 35,282 18,511 5,824 151,008 71,576 27,486 14,006 4,947 118,015 68,690 27,592 13,053 3,949 113,284 Environmental Services Public Works Environmental Programs Total Environmental Services 13,616 669 14,285 8,491 375 8,866 9,770 337 10,107 9,926 2,331 2,026 83,146 - - Criminal Justice Municipal Court Public Defender Total Criminal Justice Public Safety Police Fire Others Total Public Safety Capital Improvement Contingencies Total Expenditures and Encumbrances $ 1,222,207 - 23 - $ $ 919,246 $ 885,014 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 APRIL 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 $ $ 336,416 1,302 $ $ 347,432 2,340 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 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 118,349 159,354 50,782 95,371 2,273 5,213 10,877 11,541 585 5,776 1,384 5,063 39,426 3,225 12,833 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 114,189 145,195 48,874 92,305 2,277 7,378 12,551 10,257 523 5,841 1,336 3,594 41,934 2,816 13,622 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 $ 859,770 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 23,429 65,594 23,949 4,923 197,504 4,287 50,331 8,762 18,255 104,198 32,441 6,016 44,081 203,450 61,598 1,113,621 848,818 341,495 64,247 420,996 223,816 147,789 291,007 52,766 333,167 191,082 125,755 1,198,343 993,777 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 - $ 852,464 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 23,966 69,185 23,977 5,153 159,538 3,174 47,496 10,993 18,112 95,909 31,100 4,049 36,477 161,965 35,286 726,380 $ $ $ $ $ 2,702,365 $ 286,405 56,140 320,008 187,881 123,082 973,516 2,552,360 Citywide Operating Expenditures As of APRIL 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 $ Criminal Justice General Funds Other Funds Total Criminal Justice 114,998 24,122 139,120 $ 90,835 $ 11,347 102,182 88,632 11,722 100,354 33,206 14,912 48,118 25,549 8,407 33,956 26,075 7,001 33,076 Public Safety General Funds Other Funds Total Public Safety 772,160 162,014 934,174 642,504 114,698 757,202 615,892 113,309 729,201 Transportation General Funds Other Funds Total Transportation 21,924 650,064 671,988 15,045 530,499 545,544 13,569 504,085 517,654 Community Development General Funds Other Funds Total Community Development 21,554 203,248 224,802 16,101 136,577 152,678 15,429 130,268 145,697 Community Enrichment General Funds Other Funds Total Community Enrichment 151,008 147,683 298,691 118,015 116,771 234,786 113,284 110,119 223,403 Environmental Services General Funds Other Funds Total Environmental Services 14,285 612,416 626,701 8,866 482,600 491,466 10,107 447,194 457,301 Debt Service General Funds Other Funds Total Debt Service 137,966 137,966 114,405 114,405 127,238 127,238 Capital Improvement General Funds Other Funds Total Capital Improvement 9,926 730,851 740,777 2,331 339,631 341,962 2,026 224,867 226,893 Contingencies General Funds Other Funds Total Contingencies 83,146 51,500 134,646 Total Operating General Funds Other Funds Total Operating Budget $ 1,222,207 2,734,776 3,956,983 - $ - 25 - 919,246 1,854,935 2,774,181 $ 885,014 1,675,803 2,560,817 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 APRIL 30 2017 2016 Budget Estimate 2016-2017 Source Actual Year-to-Date 2016-2017 2015-2016 General Funds $ 36,306,961 91,248 Local Taxes: Sales Taxes Privilege License Fees 29,003,312 36,398,209 Total Local Taxes 435,455,000 337,717,482 349,772,057 12,900,062 15,935,404 5,469,945 12,975,132 14,519,502 5,512,071 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 141,696,000 187,210,000 61,042,000 118,348,756 159,354,036 50,782,057 114,188,856 145,195,017 48,874,461 34,305,411 33,006,705 389,948,000 328,484,849 308,258,334 7,577,772 6,956,770 Primary Property Tax 145,141,000 95,370,910 92,305,173 116,316 186,681 Licenses and Permits 2,786,000 2,272,634 2,276,642 0 2,436,874 Cable Communications 10,090,000 5,213,123 7,377,612 1,082,634 119,834 1,264,557 125,570 Municipal Court: Fines and Forfeitures Court Default Fee 14,326,586 915,000 9,944,792 932,449 11,703,561 847,865 1,202,468 1,390,127 15,241,586 10,877,241 12,551,426 1,270,405 594,543 13,803,108 11,540,772 10,256,762 58,028 59,141 672,215 585,410 522,980 538,379 941,062 Parks and Recreation 7,817,520 5,776,132 5,841,076 137,132 145,282 Planning and Development 1,679,900 1,384,019 1,336,147 667,066 355,322 Street Transportation 3,472,000 5,063,156 3,594,168 2,713,996 149,300 2,365,599 3,472,475 234,433 1,789,297 34,700,000 1,550,000 10,749,485 27,916,888 1,004,246 10,504,896 30,485,040 977,736 10,470,756 5,228,895 5,496,205 46,999,485 39,426,030 41,933,532 367,939 323,915 3,500,000 3,224,897 2,816,136 1,302,649 1,472,874 14,737,022 12,833,812 13,621,594 81,775,772 89,763,710 1,091,342,836 859,770,467 852,463,639 28,920,630 82,682 $ $ 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 $ 336,415,746 1,301,736 $ 347,431,970 2,340,087 Citywide Operating Revenue by Source (continued) For the Month Ended APRIL 30 2017 2016 Budget Estimate 2016-2017 Source Actual Year-to-Date 2016-2017 2015-2016 Special Revenue and Debt Service Funds $ 1,484,753 106,054 530,268 31,937 $ 1,836,876 131,206 656,027 16,732 2,153,012 2,640,841 4,197,433 1,341,029 130 5,195,939 1,660,932 31,317 5,538,592 6,888,188 2,176,785 2,663,153 349,099 3,829 203,323 436 12,687 370,490 0 236,195 195 18,762 569,374 625,642 14,505,341 4,320,745 17,613,941 4,106,619 18,826,086 21,720,560 0 0 4,358,076 4,686,005 660,131 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 $ 16,113,435 1,150,959 5,754,798 409,743 $ 16,551,008 1,182,215 5,911,074 321,864 29,933,376 23,428,935 23,966,161 64,007,000 22,023,000 45,000 48,683,844 16,472,503 437,188 51,412,381 17,781,871 (9,264) 86,075,000 65,593,535 69,184,988 29,991,315 23,949,222 23,976,938 3,710,739 0 2,225,017 (10,000) 94,257 2,927,410 3,829 1,788,703 (374) 203,473 3,094,090 82 1,869,672 (1,652) 190,784 6,020,013 4,923,041 5,152,976 206,782,000 56,438,091 155,492,480 42,011,980 113,893,654 45,644,546 263,220,091 197,504,460 159,538,200 4,088,873 4,287,460 3,173,994 Planning and Development 47,058,000 50,331,241 47,496,067 1,086,149 Capital Construction 12,051,000 8,762,208 10,992,712 1,628,303 28,616 2,695,677 15,703 Sports Facilities: Sales Taxes Interest/Other 18,702,000 8,815,726 13,612,663 4,641,947 14,504,865 3,606,896 1,656,919 2,711,380 27,517,726 18,254,610 18,111,761 Total Golf Courses Transit 2000 & 2050: Sales Taxes Interest/Other Total Transit 2000 & 2050 Court Awards Total Sports Facilities - 27 - Citywide Operating Revenue by Source (continued) For the Month Ended APRIL 30 2017 2016 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 11,513,849 80,024 3,600 12,019,588 57,110 11,143 11,597,473 12,087,841 6,908,773 1,987,616 2,088,235 6,915 5,236,682 6,108,445 Other Restricted Fees 600,634 5,446,889 1,017,213 Grants: Public Housing: Rentals Grants Other 408,477 6,663,326 1,345,075 $ 8,416,878 7,064,736 3,443,126 16,702,474 5,132,663 3,623,142 3,169,259 1,647,234 4,077,533 2,364,783 28,901,405 11,258,809 37,318,283 18,323,545 4,653,602 0 2,451,766 0 4,653,602 2,451,766 103,742,023 83,988,046 Total Highway User Revenue Regional Transit Revenues Community Reinvestment $ Total Public Housing 115,992,000 400,000 150,000 103,300,605 591,349 306,037 95,119,672 502,950 286,123 116,542,000 104,197,991 95,908,745 48,139,440 32,440,435 31,099,865 5,413,996 6,015,506 4,049,156 47,391,330 44,080,977 36,477,576 6,457,040 79,392,390 6,174,228 $ 6,368,015 61,169,556 11,782,209 $ 6,043,513 57,071,280 4,534,144 92,023,658 79,319,780 67,648,937 43,099,854 82,258,927 39,982,633 37,451,348 32,542,363 44,680,975 16,559,265 30,347,519 32,432,635 15,189,458 16,222,217 30,472,187 Total Other 202,792,762 124,130,122 94,316,497 Total Grants 294,816,420 203,449,902 161,965,434 90,622,120 4,741,740 59,229,427 2,368,483 32,914,469 2,371,129 95,363,860 61,597,910 35,285,598 1,113,622,440 848,817,433 726,380,171 137,300,000 194,137,000 1,500,000 3,339,000 2,193,000 3,025,500 - 83,623,121 200,404,324 1,768,964 197,958 1,975,378 2,484,316 553,147 82,998,934 195,742,826 1,414,290 1,592,812 1,910,873 2,402,148 343,234 341,494,500 291,007,208 286,405,117 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: 8,942,831 23,926,595 202,351 (412,153) 232,073 215,605 54,280 8,826,676 20,969,038 165,074 351,165 193,946 242,473 10,858 33,161,582 30,759,230 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 APRIL 30 2017 2016 Budget Estimate 2016-2017 Source Actual Year-to-Date 2016-2017 2015-2016 Enterprise Funds (Cont'd) CONVENTION CENTER: $ 4,107,396 2,592,758 48,312 5,427,749 2,517,691 39,221 6,748,466 7,984,661 Excise Taxes Operating Revenue Interest Total Convention Center 46,726,000 17,303,084 218,012 36,685,898 15,698,024 382,017 38,149,632 17,673,927 316,210 64,247,096 52,765,939 56,139,769 WATER SYSTEM: $ 30,941,500 328,067 452,786 232,302 377,670 315,435 309,754 $ 32,957,514 29,862,995 403,712 471,955 524,264 265,800 268,419 299,709 32,096,854 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 $ 310,736,495 3,977,579 4,855,261 4,943,880 3,091,860 2,235,428 3,326,528 $ 298,305,484 4,427,506 5,089,058 4,800,395 2,831,820 2,035,999 2,517,894 420,996,000 333,167,031 320,008,156 192,431,000 15,822,000 3,100,000 1,435,000 11,028,000 159,648,243 16,086,352 2,940,810 1,731,856 10,675,105 155,702,514 16,554,510 2,698,170 1,448,231 11,477,726 223,816,000 191,082,366 187,881,151 129,906,427 8,647,399 305,000 8,929,739 107,773,631 6,981,050 590,783 10,409,121 107,164,149 6,652,239 551,453 8,714,655 147,788,565 125,754,585 123,082,496 1,198,342,161 993,777,129 973,516,689 WASTEWATER: 16,712,391 1,510,979 369,750 258,962 878,858 15,888,637 1,730,372 263,400 215,298 3,265,423 19,730,940 21,363,130 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: $ 10,799,628 550,382 59,579 1,081,712 10,762,219 797,208 61,791 1,550,597 12,491,301 13,171,815 105,089,803 105,375,690 290,607,598 $ 279,127,446 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ - 29 - 3,403,307,437 $ 2,702,365,029 $ 2,552,360,499 Citywide Operating Expenditures by Program For the Month Ended APRIL 30 2017 2016 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 $ 113,670 262,983 282,337 2,237,394 87,860 376,026 191,073 1,406,920 192,783 137,564 54,120 1,102,475 45,752 35,436 145,865 7,329 293,198 (553,286) (415,722) $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 6,003,777 105,722 250,680 265,306 3,774,917 87,285 165,526 210,042 1,568,783 (78,710) 261,289 232 841,613 48,616 37,283 (324,376) (61,508) 161,017 630,970 (960,906) 6,983,781 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 1,299,168 2,781,169 3,152,211 29,604,819 905,103 1,867,618 2,038,877 16,543,427 2,046,825 3,292,962 312,378 9,837,726 583,032 517,049 149,170 89,032 2,977,077 21,875,845 2,308,238 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 102,181,726 1,194,138 2,602,914 2,883,183 30,681,845 802,163 1,681,295 2,218,555 15,926,135 1,684,844 3,150,097 869,042 9,939,830 512,637 481,183 154,555 13,464 2,453,977 20,099,173 3,004,638 $ 1,299,168 2,781,169 3,152,211 28,094,409 905,103 1,867,618 2,038,877 16,543,427 2,046,825 3,292,962 312,378 9,125,218 583,032 517,049 149,170 89,032 2,977,077 20,550,852 2,308,238 1,510,410 712,508 1,324,993 - 100,353,668 98,633,815 3,547,911 28,260,939 4,815,241 - 24,025,300 3,775,505 - 6,155,043 - 33,076,180 27,800,805 6,155,043 478,133,456 250,120,611 946,891 496,752,322 253,513,450 668,301 4,349,605 1,918,850 - 729,200,958 750,934,073 6,268,455 Criminal Justice 2,801,488 369,108 - $ $ $ 3,170,596 2,697,598 84,302 2,781,900 Municipal Court Public Defender Other Total Criminal Justice 43,023,685 5,093,954 - $ $ $ 48,117,639 30,180,343 3,775,505 - $ $ $ 33,955,848 Public Safety 45,589,278 24,071,808 67,943 69,729,029 $ $ $ 46,003,002 25,356,072 60,490 71,419,564 Police Fire Other Total Public Safety 613,942,012 319,414,035 817,576 $ $ $ 934,173,623 501,101,927 255,432,300 668,301 757,202,528 - 30 - $ $ $ Citywide Operating Expenditures by Program (continued) For the Month Ended APRIL 30 2017 2016 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,174,327 435,304 24,561,733 10,725,183 $ $ $ $ 40,896,547 4,716,242 1,258,223 20,845,363 9,312,185 36,132,013 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 63,631,138 11,223,396 300,867,783 296,265,820 $ $ $ $ 671,988,137 49,809,894 9,451,474 242,065,132 244,217,380 $ $ $ $ 545,543,880 45,193,694 9,383,652 230,348,185 232,728,032 $ $ $ $ 517,653,563 49,470,973 9,451,474 194,889,485 189,315,129 $ $ $ $ 443,127,061 338,921 47,175,647 54,902,251 102,416,819 Community Development 3,822,387 2,279,171 2,154,287 2,661,227 $ $ $ $ 10,917,072 3,159,465 7,039,799 1,817,812 3,331,925 Planning and Development Housing Economic Development Neighborhood Services Department 52,457,820 91,468,988 27,958,662 52,917,436 15,349,001 Total Community Development 224,802,906 $ $ $ $ 38,314,582 69,240,755 21,118,406 24,004,694 $ $ $ $ 152,678,437 32,442,141 69,190,707 20,756,946 23,306,972 $ $ $ $ 145,696,766 38,314,582 69,179,632 18,177,892 24,004,694 $ $ $ $ 149,676,800 61,123 2,940,514 3,001,637 Community Enrichment 7,222,315 2,287,297 422,469 3,665,499 980,382 4,578,949 561,182 226,985 19,945,078 $ $ $ $ $ $ $ $ 6,592,539 2,788,027 479,145 4,147,114 913,269 5,078,047 236,669 317,228 20,552,038 Parks and Recreation Library Golf Convention Center Sports and Cultural Facilities Human Services Public Parking Facilities Other Total Community Enrichment 100,794,979 35,786,355 5,683,994 62,561,583 21,323,644 63,044,520 5,369,072 4,126,369 $ $ $ $ $ $ $ $ 298,690,516 77,523,013 27,827,902 4,816,838 51,622,845 14,164,691 51,053,407 4,316,342 3,460,868 234,785,906 - 31 - $ $ $ $ $ $ $ $ 74,772,940 28,066,707 5,203,403 49,626,907 9,348,108 50,310,093 3,164,023 2,911,120 223,403,301 $ $ $ $ $ $ $ $ 77,181,074 27,827,902 4,816,838 35,152,994 50,809,956 4,316,342 3,460,868 203,565,974 $ $ $ $ $ $ $ $ 341,939 16,469,851 14,164,691 243,451 31,219,932 Citywide Operating Expenditures by Program (continued) For the Month Ended APRIL 30 2017 2016 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 $ 25,115,420 11,545,469 11,783,954 542,084 254,112 $ $ $ $ $ 49,241,039 22,385,715 10,726,844 10,187,543 1,811,355 91,912 45,203,369 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 244,604,333 120,389,179 110,636,826 15,144,931 691,412 $ $ $ $ $ 491,466,681 228,801,345 115,434,466 97,241,931 15,207,062 616,735 $ $ $ $ $ 457,301,539 156,335,777 64,124,200 100,887,502 8,991,532 691,412 88,268,556 56,264,979 9,749,324 6,153,399 - 331,030,423 160,436,258 General Obligation Debt Service 16,421 1,291,210 2,287,131 68,916 375,397 27,915 1,108,955 171,216 586,534 535,036 105,397 1,138,765 32,525 569,639 443,901 180,849 6 115,327 1,317,551 421,862 513 552,719 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 11,347,785 68,019,809 $ 279,270,732 $ $ 16,421 1,214,797 2,366,799 69,430 404,942 33,320 1,134,548 173,495 451,048 628,009 117,322 1,045,464 74,592 582,627 521,114 657,380 (0) 115,073 1,258,618 425,245 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 25,635,912 Capital Improvement 740,777,428 $ Contingencies 134,646,000 $ 236,781,364 Total Operating Budget 164,208 12,915,456 23,051,131 689,996 3,758,751 280,571 11,099,655 1,716,667 5,867,264 5,353,445 1,056,816 11,395,398 325,250 5,707,212 4,439,019 1,808,485 659,420 1,153,271 13,206,948 4,223,238 5,125 5,527,181 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 114,404,507 3,956,982,515 341,961,916 2,774,181,429 - 32 - 164,208 12,147,968 23,667,988 694,293 4,049,424 333,208 11,345,485 1,734,955 4,510,487 6,280,089 1,173,226 10,454,637 745,917 5,826,274 5,211,134 6,573,803 20 1,150,729 12,586,180 4,252,444 5,125 14,330,285 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 127,237,879 $ $ 226,892,966 2,560,816,820 164,208 12,915,456 23,051,131 689,996 3,758,751 280,571 11,099,655 1,716,667 5,867,264 5,353,445 1,056,816 11,395,398 325,250 5,707,212 4,439,019 1,808,485 659,420 1,153,271 13,206,948 4,223,238 5,125 5,527,181 - 114,404,507 - $ - $ 2,119,173,458 341,961,916 655,007,971 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 12,014,707 669,511 14,203,412 1,178,482 22,284,888 600,000 64,248,599 629,126 5,116,031 82,175,710 965,000 156,367,083 8,561,919 232,830,500 54,573 $ 6,544,275 871,208 903,104 677,064 239,772 5,975,496 19,414,098 157,059 628,675 20,534,490 324,966 32,694,044 1,213,338 73,846,518 6,284,753 1,206,446 451,241 301,344 2,381,814 310,084 16,453,192 15,731,415 45,321 378,617 15,318,379 3,219,199 14,758,857 7,916,771 60,891,240 $ 615,493,546 $ 164,078,680 $ 145,648,673 $ $ 223,028,686 23,212,500 30,233,007 150,618,833 226,862,611 653,955,637 $ $ $ 1,269,449,183 $ 117,660,810 17,549,496 6,650,527 66,313,279 145,120,111 353,294,223 517,372,903 $ $ 499,110,700 18,633,364 4,293,401 27,625,533 75,424,385 625,087,383 $ 770,736,056 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,779,707 368,231 13,736,250 13,978,065 15,564,593 200,000 2,843,653 62,121,051 900,000 136,524,247 138,024,217 6,544,275 871,208 903,104 489,778 3,090,291 5,043,306 602,755 20,291,462 324,966 32,505,738 61,149,527 405,614,592 $ 131,816,410 $ 67,466,730 2,763,500 29,031,910 66,815,450 169,085,246 335,162,836 $ 740,777,428 - 33 - $ $ 33,738,777 508,663 5,743,176 58,687,043 111,467,847 210,145,506 $ 341,961,916 $ $ $ 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,573 187,286 239,772 2,885,205 14,370,792 157,059 25,920 243,028 188,306 1,213,338 12,696,991 209,878,954 $ 32,262,270 $ 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,326 4,786,404 328,792 11,111,603 669,511 13,526,348 938,710 16,309,392 600,000 44,834,501 472,067 4,487,356 61,641,220 640,034 123,673,039 7,348,581 158,983,982 $ 451,414,866 $ 83,922,033 17,040,833 907,351 7,626,236 33,652,264 143,148,717 $ $ 105,367,876 5,663,004 23,582,480 84,305,554 81,742,500 300,661,414 $ 175,410,987 $ 752,076,280 Bonds Authorized and Sold As of APRIL 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 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 Feb Jan 36,527 40,116 37,227 37,567 38,595 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 - Mar Feb 32,542 32,084 34,432 32,793 22,766 34,211 Apr Mar 32,047 32,147 34,938 33,135 33,502 34,319 May Apr 34,911 35,988 37,203 36,307 28,921 37,469 YTD thru April 337,834 350,063 353,584 347,432 336,416 360,375 June 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 Jan 11,986 12,744 13,173 13,760 14,184 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 - Mar Feb 9,270 10,430 10,244 10,375 10,974 11,082 Apr Mar 9,887 10,506 10,861 11,139 11,785 11,653 May Apr 11,037 11,285 12,265 12,975 12,900 13,074 June YTD thru April 98,229 104,792 109,208 114,189 118,349 117,212 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 Jan 3,572 3,936 4,661 5,195 5,607 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 - Mar Feb 4,141 4,799 4,920 5,024 5,049 5,358 Apr Mar 4,623 4,559 4,984 5,065 5,457 5,456 May Apr 3,676 3,826 4,408 5,512 5,470 4,942 June YTD thru April 39,448 42,268 45,158 48,874 50,782 49,864 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 Jan 160,895 153,911 151,099 160,567 173,436 178,935 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 - Feb Mar Feb 134,498 132,551 144,296 141,861 145,268 158,278 Mar 142,641 144,892 150,768 160,707 159,366 172,229 Apr Apr 160,782 162,046 169,860 173,752 185,518 191,738 May YTD thru April 1,472,558 1,516,406 1,527,231 1,578,844 1,708,588 1,743,575 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 Jan 27,054 26,659 27,917 28,789 28,532 27,669 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 - Mar Apr Feb 27,884 26,561 26,683 27,161 28,901 27,136 Mar 31,100 28,352 30,414 31,530 29,273 30,420 May Apr 34,980 31,467 32,304 30,759 33,162 32,453 June YTD thru April 288,215 273,411 281,265 286,405 291,007 282,983 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 Jan 21,738 22,872 21,031 22,460 21,608 23,934 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 - Mar Apr Feb 18,711 21,185 19,044 19,179 19,223 21,425 Mar 21,386 21,993 20,725 24,487 20,925 24,238 May Apr 30,809 29,578 31,472 32,097 32,958 33,594 June YTD thru April 352,983 319,944 307,137 320,008 333,167 341,569 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 Jan 25,337 17,618 18,183 19,384 19,155 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 - Mar Feb 17,663 18,058 17,960 18,385 18,594 18,543 Apr Mar 14,263 14,986 17,538 18,659 19,618 17,445 May Apr 17,865 18,386 18,112 21,363 19,731 19,722 June YTD thru April 185,049 179,172 180,532 187,881 191,082 186,641 May 17,982 18,299 17,762 18,555 18,616 June 14,638 16,909 18,253 19,289 18,559