May 2017 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division City of Phoenix Monthly Financial Report May 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 Page Corrective Action Taken - Negative variance Performance Status General Fund Total Operating Revenue 13 Expected Property Tax 14 Better than Expected Local Sales Tax 15 Monitor and Consider Taking Action State Sales Tax 16 Expected Vehicle License Tax 17 Expected Governmental Funds 18 Expected 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. May 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 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 951,725 1,038,092 91.7% 950,798 1,042,102 91.2% 949,947 1,051,395 90.4% 970,059 1,066,521 91.0% 1,012,772 1,139,061 88.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,060,000 $1,150,000 $1,040,000 May YTD May YTD Expenditures Expenditures $1,100,000 $1,020,000 $1,000,000 $1,050,000 $980,000 $1,000,000 $960,000 $950,000 $940,000 $900,000 $920,000 $850,000 $900,000 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 May 2017, actual general fund expenditures are 4.4% 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 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 93,493 102,211 91.5% 94,146 100,400 93.8% 89,840 96,385 93.2% 97,617 105,240 92.8% 98,481 114,998 85.6% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice General Government $104,000 $102,000 $140,000 $100,000 $120,000 $98,000 $100,000 $96,000 $94,000 $80,000 $92,000 $60,000 $90,000 $88,000 $40,000 $86,000 $20,000 $84,000 $82,000 $0 May YTD Expenditures May YTD Expenditures Annual Expenditures * Annual Expenditures * 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 May 2017 are 0.9% higher than the same period in the prior year. Although personal services costs have increased 8.7% ($7.8 million) over the same period in fiscal year 2015-16, the budgeted increase over prior year actuals was 13.2% ($12.9 million). Additionally, expenditures charged to other departments, which are budgeted to increase 5.9% ($1.5 million) over prior year actuals, have increased 22.7% ($4.8 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- May General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Criminal Justice May YTD Annual % of Annual Expenditures Expenditures * Expenditures 30,711 33,453 91.8% 29,846 32,659 91.4% 28,244 31,018 91.1% 28,285 30,698 92.1% 29,305 33,206 88.3% 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 $34,000 $33,000 $35,000 $32,000 $30,000 $31,000 $25,000 $30,000 $29,000 $20,000 $28,000 $15,000 $27,000 $26,000 $10,000 $25,000 $5,000 May YTD Expenditures May 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 May 2017 are 3.6% higher than the same period in the prior year. Personal services expenditures were budgeted to increase 10.4% over prior year actuals, however, through May the increase has only been 5.0% 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 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 628,313 684,609 91.8% 638,481 699,796 91.2% 645,047 716,304 90.1% 672,768 737,129 91.3% 704,011 772,160 91.2% * - For prior years-total actual expenditures, for current year-total approved budget Expected $900,000 $740,000 $800,000 $720,000 $700,000 $600,000 $700,000 $500,000 $680,000 $400,000 $660,000 $300,000 $200,000 $640,000 $100,000 $620,000 $0 $600,000 12-13 13-14 $580,000 12-13 May YTD Expenditures May 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 May 2017 are 4.6% 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- May 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 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 34,946 38,161 91.6% 27,648 29,713 93.1% 31,565 34,187 92.3% 15,614 17,473 89.4% 16,757 21,924 76.4% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Community Development Transportation $45,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 May YTD Expenditures May 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 personal services increase remains in the general fund, the result is a 25.5% increase in budgeted expenditures over prior year actuals. Actual personal services costs through May 2017 are only 8.9% higher than prior year actuals and the AHUR transfers are 3.1% higher than the prior year. Additionally, streets department direct charges to other funds has increased 46.6% through May 2017 over the prior year. These changes result in an increase in general fund transportation expenditures through May 2017 of 7.3% over the prior year. General fund transportation expenditures decreased significantly in fiscal year 2015-16 from prior years due to the passage of proposition 104 which eliminated the need for approximately $16 million in support for the transit fund from the general fund. Community Development Community Enrichment Community Development 12-13 13-14 14-15 15-16 16-17 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 18,229 19,927 91.5% 18,522 20,210 91.6% 17,280 18,986 91.0% 16,888 18,571 90.9% 17,870 21,554 82.9% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $25,000 $25,000 May MayYTD 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 May 2017 are 5.8% higher than the same period in the prior year with an 8.5% 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- May 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 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 128,996 141,209 91.4% 129,122 143,665 89.9% 122,495 138,024 88.7% 125,741 141,483 88.9% 131,187 151,008 86.9% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Environmental Services Community Enrichment $160,000 $150,000 $140,000 $145,000 $120,000 $140,000 $100,000 $135,000 $80,000 $130,000 $60,000 $125,000 $40,000 $120,000 $20,000 $115,000 $0 $110,000 12-13 13-14 12-13 MayYTD YTD May 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 May 2017 are 4.3% 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 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 14,390 15,353 93.7% 11,726 13,748 85.3% 14,379 15,082 95.3% 10,454 12,143 86.1% 11,914 14,285 83.4% * - 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 May 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 May 2017 are 14.0% 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. May 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 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 2,833,957 3,123,865 90.7% 2,744,885 3,054,098 89.9% 2,755,618 3,051,875 90.3% 2,807,928 3,156,441 89.0% 3,155,863 3,822,337 82.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,200,000 $4,000,000 $3,100,000 $3,500,000 $3,000,000 $3,000,000 $2,500,000 $2,900,000 $2,000,000 $2,800,000 $1,500,000 $2,700,000 $1,000,000 $500,000 $2,600,000 $0 $2,500,000 May YTD May 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 May 2017 are better than expected with an increase of 12.4% from the same period in the prior year. General Government 12-13 13-14 14-15 15-16 16-17 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 104,746 114,015 91.9% 105,299 114,235 92.2% 100,374 108,690 92.3% 110,577 118,505 93.3% 110,991 139,120 79.8% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice General Government $116,000 $160,000 $114,000 May YTD Expenditures May YTD Expenditures $140,000 $112,000 $120,000 $110,000 $100,000 $108,000 $80,000 $106,000 $60,000 $104,000 $40,000 Annual Expenditures * Annual Expenditures * $102,000 $20,000 $100,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 0.4% through May 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- May 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 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 37,914 41,290 91.8% 37,232 40,697 91.5% 35,797 39,265 91.2% 36,367 39,463 92.2% 38,000 48,118 79.0% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Public Safety Criminal Justice $60,000 $200,000 May YTD Expenditures May 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 4.5% higher through May 2017 than the same period in the prior year. 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 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 770,476 842,387 91.5% 768,394 842,270 91.2% 762,709 841,817 90.6% 798,948 874,558 91.4% 831,179 934,174 89.0% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $1,000,000 $860,000 $800,000 $840,000 May YTD Expenditures May YTD Expenditures $820,000 $600,000 $800,000 $400,000 $780,000 $200,000 $760,000 $0 $740,000 12-13 13-14 14-15 15-16 16-17 Annual Expenditures * Annual Expenditures * $720,000 12-13 13-14 Public Safety expenditures include costs of Police, Fire and Emergency Management. Citywide public safety expenditures through May 2017 are 4.0% 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- May 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 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 545,665 582,381 93.7% 538,073 573,025 93.9% 542,672 582,486 93.2% 556,996 609,990 91.3% 602,168 671,988 89.6% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Transportation Community Development $590,000 $800,000 $580,000 $700,000 $570,000 $600,000 $560,000 $500,000 $550,000 $400,000 $540,000 $300,000 $530,000 $200,000 $520,000 $100,000 $510,000 $0 May YTD Expenditures May 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 8.1% higher through May 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 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 193,293 209,403 92.3% 178,348 194,542 91.7% 171,235 188,670 90.8% 160,487 174,956 91.7% 169,516 224,802 75.4% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected CommunityDevelopment Enrichment Community $250,000 $250,000 MayYTD YTD May 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 May 2017 of 5.6% over the same period in the prior year. The 2016-17 budget includes an increase of 28.5% over 2015-16 actuals. -7- May 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 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 249,731 273,110 91.4% 248,395 272,326 91.2% 233,877 259,944 90.0% 246,711 273,179 90.3% 259,713 299,091 86.8% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services Community Enrichment $350,000 $280,000 $300,000 $270,000 $250,000 $260,000 $200,000 $250,000 $150,000 $240,000 $100,000 $230,000 $50,000 $220,000 $0 $210,000 Better than Expected MayYTD YTD May 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 May 2017 of 5.3% over the same period in the prior year. The budgeted increase for fiscal year 2016-17 over prior year actuals is 9.5%. Environmental Services 12-13 13-14 14-15 15-16 16-17 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 515,850 564,051 91.5% 525,172 577,118 91.0% 495,881 545,198 91.0% 502,949 555,711 90.5% 549,694 626,701 87.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 MayYTD YTD May 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 9.3% higher through May 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- May 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 May YTD Annual % of Annual Expenditures Expenditures * Expenditures 125,823 137,208 91.7% 92,383 100,524 91.9% 123,891 134,594 92.0% 139,962 154,710 90.5% 125,799 137,966 91.2% * - 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 MayYTD YTD May 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 May 2017 are 10.1% lower than the same period in the prior year. Budgeted expenditures for fiscal year 201617 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 $ 614,932 $ 269,015 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 May 2017, the City has committed or spent $45 million for bus replacement, $20 million for the 48th St and Washington Light Rail Station, $25 million for wireless communication in the regional bus system, $67 million for street construction, repair and maintenance, $24 million for sidewalks, traffic signals, bridges, bike lanes and street lighting improvements and maintenance and $22 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 $ 126,003 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 May 2017, Aviation has spent or committed $18.9 million for runway, apron and taxiway projects, $14.3 million for Communications Center/EOC Design and Construction, $10.0 million for PHX Sky Train phase 2 and $10.0 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) $ 19,381 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,241 $20,000 $30,000 16-17 (YTD) $ 7,173 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 May 2017, Solid Waste has spent or committed $3.6 million on the 27th Avenue Composting Facility and $2.2 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) $ 89,303 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 May 2017, Wastewater has spent or committed $29.9 million to construct, replace or rehabilitate pipelines, $24.8 million for the construction of the biogas project at the 91st Avenue Wastewater Treatment Plant, $9.6 million for improvements at the 23rd Avenue wastewater treatment plant and $14.2 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) $ 227,017 $ 170,390 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 May 2017, Water has spent or committed $56.3 million to construct, replace or rehabilitate pipelines and valves, $18.5 million for rehabilitation at the Deer Valley water treatment plant, $15.0 million for reservoir rehabilitation and $9.4 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 May 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 May YTD Actuals 885,412 930,638 955,325 959,745 990,073 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 90.3% 90.7% 91.2% 90.3% 90.7% * - 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 May 2017 are 3.2% 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 82,981 90,622 62,012 35,204 49,567 50,484 132,101 143,931 138,243 141,310 132,563 145,141 12-13 13-14 14-15 15-16 16-17 YTD 16-17 budget 100,000 50,000 Secondary Primary - FY 12-13 13-14 14-15 15-16 16-17 YTD 16-17 budget Total 194,112 179,136 187,811 191,793 215,544 235,763 July (1,733) (1,260) (1,107) (981) (1,004) (1,413) Aug 1,349 971 760 641 454 1,001 Sept 904 867 816 857 773 1,072 Oct 11,888 11,107 12,338 15,224 12,067 16,317 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 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 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 60,943 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 May 2017, property tax revenues are 28.8% 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 60,000 50,000 40,000 30,000 16-17 Actuals 16-17 budget 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 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 May 2017 are 2.9% 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 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 Through May 2017 local sales tax revenues are 0.6% higher than the same period in the prior year. Fiscal year 2015-16 local sales tax revenues exceeded fiscal year 2014-15 revenues by 0.1%. Fiscal year 2014-15 local sales tax revenues exceeded fiscal year 2013-14 revenues by 0.4%. Monthly revenue figures for August 2016 through 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 May 2017 are 0.8% 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 May 2017 state shared sales tax revenues are 3.7% 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 May 2017 are 1.0% 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 May 2017 state shared vehicle license tax revenues are 3.5% higher than the same period in the prior year. Click Here for Additional Information - 17 - Governmental Funds Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Governmental Funds Revenues Budget vs Actual 300,000 250,000 200,000 16-17 Actuals 16-17 budget 150,000 100,000 50,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Year to Date Performance Status Expected Governmental funds are those funds supported primarily through taxes, bonds and grants and include the general fund as well as funds with dedicated tax revenue streams. They do not include the enterprise funds. Governmental fund revenues through May 2017 are 0.2% 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 May 2017, governmental funds revenues are 10.6% 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 May 2017 are 3.3% 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 May 2017, aviation operating revenues are 2.3% 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 May 2017 are 2.0% 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 May 2017 revenues are 4.8% 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,500 20,000 19,500 19,000 16-17 Actuals 18,500 16-17 budget 18,000 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 May 2017 are 3.0% 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 MAY 31 (dollars in thousands) Budget Estimate 2016-2017 Actual Year-to-Date 2016-2017 2015-2016 Revenues Local Taxes Sales Taxes Privilege License Fees State Shared Taxes State Sales Tax State Income Tax Vehicle License Tax Primary Property Tax Licenses and Permits Cable Communications Municipal Court Fines and Forfeitures Court Default Fee Police Library Parks and Recreation Engineering & Architectural Services Planning & Development Street Transportation Fire Emergency Transportation Service Hazardous Materials Inspection Fee Other Interest Other Fees and Service Charges Total Revenues $ $ 433,000 2,455 $ 384,063 1,380 $ 381,668 2,413 141,696 187,210 61,042 145,141 2,786 10,090 130,353 175,289 55,720 132,563 2,605 7,805 125,659 159,715 53,818 123,326 2,511 7,591 14,327 915 13,803 672 7,818 1,680 3,472 11,106 1,063 12,851 641 6,333 1,574 5,266 12,686 952 12,761 598 6,341 1,484 4,126 34,700 12,299 3,500 14,737 32,008 11,913 3,603 13,937 34,227 12,225 3,168 14,476 1,091,343 - 22 - $ 990,073 $ 959,745 General Fund Expenditures As of MAY 31 (dollars in thousands) Actual Year-to-Date 2016-2017 2015-2016 Budget Estimate 2016-2017 Expenditures and Encumbrances General Government Mayor City Council City Manager Information Technology Services Public Information Equal Opportunity Law City Auditor City Clerk Human Resources Budget and Research Finance Others Total General Government $ 1,831 3,537 2,361 36,081 1,959 2,552 20,266 2,777 4,230 10,745 3,281 23,274 2,104 114,998 1,434 $ 3,082 1,757 30,910 1,739 1,899 16,938 2,281 3,641 9,694 3,193 19,891 2,022 98,481 1,306 2,871 2,949 32,620 1,549 2,014 16,508 1,856 3,339 8,133 2,732 19,312 2,428 97,617 28,112 5,094 33,206 25,134 4,171 29,305 23,375 4,909 28,285 498,786 273,282 92 772,160 462,861 241,115 35 704,011 442,411 229,848 509 672,768 Transportation Street Transportation Public Transit Total Transportation 20,272 1,652 21,924 15,105 1,652 16,757 13,944 1,669 15,614 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 5,064 12,115 4,321 54 21,554 4,167 10,068 3,590 45 17,870 3,919 9,359 3,565 45 16,888 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 91,391 35,282 18,511 5,824 151,008 79,505 30,904 15,346 5,432 131,187 76,192 30,719 14,466 4,364 125,741 Environmental Services Public Works Environmental Programs Total Environmental Services 13,616 669 14,285 11,478 436 11,914 10,074 380 10,454 9,926 3,247 2,692 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 - $ $ 1,012,772 $ 970,059 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 MAY 31 (dollars in thousands) Source General Funds Local Taxes: Sales Taxes Privilege License Fees State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax Primary Property Tax Licenses and Permits Cable Communications Municipal Court Police Library Fees Parks and Recreation Planning & Development Street Transportation Fire Interest Other Fees and Service Charges $ Total General Funds 433,000 2,455 $ $ 384,063 1,380 $ $ 381,668 2,413 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 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 130,353 175,289 55,720 132,563 2,605 7,805 12,169 12,851 641 6,333 1,574 5,266 43,921 3,603 13,937 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 125,659 159,715 53,818 123,326 2,511 7,591 13,638 12,761 598 6,341 1,484 4,126 46,452 3,168 14,476 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 $ 990,073 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 26,956 73,918 27,504 5,525 225,502 4,288 54,687 9,909 21,454 115,149 35,004 6,242 50,225 227,894 85,350 959,745 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 26,439 75,701 26,472 5,595 180,841 3,174 52,977 12,065 19,956 106,170 34,602 4,063 36,413 181,591 46,442 1,113,621 969,607 341,495 64,247 420,996 223,816 147,789 323,153 61,690 371,176 211,315 138,905 1,198,343 1,106,239 1,075,168 3,065,919 $ 2,847,414 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 - $ 812,501 $ $ $ $ $ 315,844 62,999 354,130 206,436 135,759 Citywide Operating Expenditures As of MAY 31 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2016-2017 2015-2016 Budget 2016-2017 $ Criminal Justice General Funds Other Funds Total Criminal Justice 114,998 24,122 139,120 $ 98,481 $ 12,510 110,991 97,617 12,960 110,577 33,206 14,912 48,118 29,305 8,695 38,000 28,285 8,082 36,367 Public Safety General Funds Other Funds Total Public Safety 772,160 162,014 934,174 704,011 127,168 831,179 672,768 126,180 798,948 Transportation General Funds Other Funds Total Transportation 21,924 650,064 671,988 16,757 585,411 602,168 15,614 541,382 556,996 Community Development General Funds Other Funds Total Community Development 21,554 203,248 224,802 17,870 151,646 169,516 16,888 143,599 160,487 Community Enrichment General Funds Other Funds Total Community Enrichment 151,008 148,083 299,091 131,187 128,526 259,713 125,741 120,970 246,711 Environmental Services General Funds Other Funds Total Environmental Services 14,285 612,416 626,701 11,914 537,780 549,694 10,454 492,495 502,949 Debt Service General Funds Other Funds Total Debt Service 137,966 137,966 125,799 125,799 139,962 139,962 Capital Improvement General Funds Other Funds Total Capital Improvement 9,926 730,451 740,377 3,247 465,556 468,803 2,692 252,239 254,931 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 - 1,012,772 2,143,091 3,155,863 $ 970,059 1,837,869 2,807,928 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 MAY 31 2017 2016 Budget Estimate 2016-2017 Source Actual Year-to-Date 2016-2017 2015-2016 General Funds $ 34,236,365 72,976 Local Taxes: Sales Taxes Privilege License Fees 47,726,153 34,309,341 Total Local Taxes 435,455,000 385,443,635 384,081,398 12,004,176 15,935,403 4,937,857 11,469,803 14,519,501 4,943,252 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 141,696,000 187,210,000 61,042,000 130,352,932 175,289,439 55,719,914 125,658,659 159,714,518 53,817,713 32,877,436 30,932,556 389,948,000 361,362,285 339,190,890 37,191,693 31,020,844 Primary Property Tax 145,141,000 132,562,603 123,326,017 332,275 234,803 Licenses and Permits 2,786,000 2,604,909 2,511,445 2,591,516 213,840 Cable Communications 10,090,000 7,804,639 7,591,452 1,161,314 130,292 982,221 104,249 Municipal Court: Fines and Forfeitures Court Default Fee 14,326,586 915,000 11,106,106 1,062,741 12,685,782 952,114 1,291,606 1,086,470 15,241,586 12,168,847 13,637,896 1,310,581 2,504,489 13,803,108 12,851,353 12,761,251 55,818 75,382 672,215 641,228 598,362 556,430 499,740 Parks and Recreation 7,817,520 6,332,562 6,340,816 190,030 148,329 Planning and Development 1,679,900 1,574,049 1,484,476 202,510 531,352 Street Transportation 3,472,000 5,265,666 4,125,520 4,091,530 194,375 208,729 3,742,032 196,575 579,566 34,700,000 1,550,000 10,749,485 32,008,418 1,198,621 10,713,625 34,227,072 1,174,311 11,050,322 4,494,634 4,518,173 46,999,485 43,920,664 46,451,705 378,517 351,548 Interest 3,500,000 3,603,414 3,167,684 1,103,551 854,802 Other Fees and Service Charges 14,737,022 13,937,363 14,476,396 130,302,750 107,281,669 1,091,342,836 990,073,217 959,745,308 47,647,419 78,734 $ $ Total State Shared Taxes Total Municipal Court Police Library Fees Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire Total General Funds - 26 - 433,000,000 2,455,000 $ 384,063,165 1,380,470 $ 381,668,335 2,413,063 Citywide Operating Revenue by Source (continued) For the Month Ended MAY 31 2017 2016 Budget Estimate 2016-2017 Source Actual Year-to-Date 2016-2017 2015-2016 Special Revenue and Debt Service Funds $ 2,448,161 174,869 874,344 30,039 $ 1,719,937 122,853 614,263 15,517 3,527,413 2,472,570 6,420,784 1,904,586 (666) 4,927,107 1,593,169 (4,003) 8,324,704 6,516,273 3,554,205 2,494,621 426,767 (3,829) 148,555 463 29,662 238,214 0 177,608 119 25,751 601,618 441,692 23,694,114 4,303,791 16,461,073 4,841,740 27,997,905 21,302,813 0 0 4,355,966 5,480,554 1,146,535 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 $ 18,561,596 1,325,828 6,629,142 439,782 $ 18,270,945 1,305,068 6,525,337 337,381 29,933,376 26,956,348 26,438,731 64,007,000 22,023,000 45,000 55,104,628 18,377,089 436,522 56,339,488 19,375,040 (13,267) 86,075,000 73,918,239 75,701,261 29,991,315 27,503,427 26,471,559 3,710,739 0 2,225,017 (10,000) 94,257 3,354,177 0 1,937,258 89 233,135 3,332,304 82 2,047,280 (1,533) 216,535 6,020,013 5,524,659 5,594,668 206,782,000 56,438,091 179,186,594 46,315,771 130,354,727 50,486,286 263,220,091 225,502,365 180,841,013 4,088,873 4,287,460 3,173,994 Planning and Development 47,058,000 54,687,207 52,976,621 1,072,707 Capital Construction 12,051,000 9,908,743 12,065,419 3,170,126 29,707 1,827,917 16,730 Sports Facilities: Sales Taxes Interest/Other 18,702,000 8,815,726 16,782,789 4,671,654 16,332,782 3,623,626 3,199,833 1,844,647 27,517,726 21,454,443 19,956,408 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 MAY 31 2017 2016 Budget Estimate 2016-2017 Source Actual Year-to-Date 2016-2017 2015-2016 Special Revenue and Debt Service Funds (Cont'd) $ 10,867,271 83,592 0 10,198,565 55,862 6,526 10,950,863 10,260,953 2,563,445 3,502,277 226,261 13,777 6,144,215 $ 776,809 7,396,937 1,361,745 (64,053) $ 442,050 6,857,781 (195,176) 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 $ 9,535,491 7,104,655 Total Public Housing 2,888,204 8,496,826 422,490 3,101,579 3,924,293 4,811,754 930,142 2,854,455 14,909,099 12,520,644 24,444,590 19,625,299 23,751,766 0 11,156,339 0 23,751,766 11,156,339 Total G.O. Bond/Secondary Property Tax 120,789,319 86,120,469 Total Special Revenue and Debt Service Funds 115,992,000 400,000 150,000 114,167,876 674,941 306,037 105,318,237 558,812 292,649 116,542,000 115,148,854 106,169,698 48,139,440 35,003,880 34,602,142 5,413,996 6,241,767 4,062,933 47,391,330 50,225,192 36,413,523 6,457,040 79,392,390 6,174,228 $ 7,144,824 68,566,493 13,143,954 $ 6,485,563 63,929,061 4,338,968 92,023,658 88,855,271 74,753,592 43,099,854 82,258,927 39,982,633 37,451,348 35,430,567 53,177,801 16,981,755 33,449,098 36,356,928 20,001,212 17,152,359 33,326,642 Total Other 202,792,762 139,039,221 106,837,141 Total Grants 294,816,420 227,894,492 181,590,733 90,622,120 4,741,740 82,981,193 2,368,483 44,070,808 2,371,129 95,363,860 85,349,676 46,441,937 1,113,622,440 969,606,752 812,500,640 137,300,000 194,137,000 1,500,000 3,339,000 2,193,000 3,025,500 - 92,115,403 223,648,051 1,975,933 (117,364) 2,159,478 2,726,056 645,419 91,396,946 215,707,633 1,573,211 1,983,483 2,104,379 2,689,117 388,867 341,494,500 323,152,976 315,843,636 Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond/Secondary Property Tax Secondary Property Tax Interest Enterprise Funds AVIATION: 8,492,282 23,243,727 206,969 (315,322) 184,100 241,740 92,272 8,398,012 19,964,807 158,921 390,671 193,506 286,969 45,633 32,145,768 29,438,519 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 MAY 31 2017 2016 Budget Estimate 2016-2017 Source Actual Year-to-Date 2016-2017 2015-2016 Enterprise Funds (Cont'd) CONVENTION CENTER: $ 6,605,619 2,265,119 53,466 4,415,826 2,402,838 40,562 8,924,204 6,859,226 Excise Taxes Operating Revenue Interest Total Convention Center 46,726,000 17,303,084 218,012 43,291,517 17,963,143 435,483 42,565,458 20,076,765 356,772 64,247,096 61,690,143 62,998,995 WATER SYSTEM: $ 34,637,049 560,933 492,386 599,865 334,560 214,242 1,169,571 $ 38,008,606 32,034,166 416,663 370,445 549,835 260,580 161,229 328,660 34,121,578 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 $ 345,373,544 4,538,512 5,347,647 5,543,745 3,426,420 2,449,670 4,496,099 $ 330,339,650 4,844,169 5,459,503 5,350,230 3,092,400 2,197,228 2,846,554 420,996,000 371,175,637 354,129,734 192,431,000 15,822,000 3,100,000 1,435,000 11,028,000 176,507,190 17,710,134 3,277,710 1,915,135 11,904,781 171,588,373 18,056,033 2,946,570 1,588,128 12,257,244 223,816,000 211,314,950 206,436,348 129,906,427 8,647,399 305,000 8,929,739 118,621,829 7,979,665 647,594 11,656,213 117,926,773 7,682,067 608,879 9,540,982 147,788,565 138,905,301 135,758,701 1,198,342,161 1,106,239,007 1,075,167,414 WASTEWATER: 16,858,947 1,623,782 336,900 183,279 1,229,676 15,885,859 1,501,523 248,400 139,897 779,518 20,232,584 18,555,197 Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: $ 10,848,198 998,615 56,811 1,247,092 10,762,624 1,029,828 57,426 826,327 13,150,716 12,676,205 112,461,878 101,650,725 363,553,947 $ 295,052,863 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ - 29 - 3,403,307,437 $ 3,065,918,976 $ 2,847,413,362 Citywide Operating Expenditures by Program For the Month Ended MAY 31 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 $ 134,412 300,615 (1,029,912) 3,653,973 26,027 209,948 212,899 1,553,383 234,614 347,723 13,442 1,197,518 (211,578) 41,136 177,972 (18,418) 215,942 1,480,728 269,262 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 8,809,686 111,734 268,545 284,812 4,040,923 52,785 165,970 227,267 1,304,791 171,539 188,465 (200,756) 921,803 58,239 39,597 167,387 7,962 277,535 1,615,370 518,995 10,222,963 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,433,580 3,081,784 2,122,299 33,258,792 931,130 2,077,566 2,251,776 18,096,810 2,281,439 3,640,685 325,820 11,035,244 371,454 558,185 327,142 70,614 3,193,019 23,356,573 2,577,500 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 110,991,412 1,305,872 2,871,459 3,167,995 34,722,768 854,948 1,847,265 2,445,822 17,230,926 1,856,383 3,338,562 668,286 10,861,633 570,876 520,780 321,942 21,426 2,731,512 21,714,543 3,523,633 $ 1,433,580 3,081,784 2,122,299 31,597,341 931,130 2,077,566 2,251,776 18,096,810 2,281,439 3,640,685 325,820 10,251,485 371,454 558,185 327,142 70,614 3,193,019 21,899,081 2,577,500 1,661,451 783,759 1,457,492 - 110,576,631 107,088,710 3,902,702 31,458,097 4,909,316 - 27,059,004 4,170,873 - 6,770,421 - 36,367,413 31,229,877 6,770,421 524,284,352 273,619,143 1,044,531 545,921,443 277,619,359 743,397 4,784,439 2,110,573 - 798,948,026 824,284,199 6,895,012 Criminal Justice 3,649,082 395,368 - $ $ $ 4,044,450 3,197,158 94,075 3,291,233 Municipal Court Public Defender Other Total Criminal Justice 43,023,685 5,093,954 - $ $ $ 48,117,639 33,829,425 4,170,873 - $ $ $ 38,000,298 Public Safety 49,603,955 24,297,632 75,096 73,976,683 $ $ $ 46,150,896 23,498,532 97,640 69,747,068 Police Fire Other Total Public Safety 613,942,012 319,414,035 817,576 $ $ $ 934,173,623 550,705,882 279,729,932 743,397 831,179,211 - 30 - $ $ $ Citywide Operating Expenditures by Program (continued) For the Month Ended MAY 31 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,457,255 945,954 28,659,259 21,561,145 $ $ $ $ 56,623,613 5,247,416 984,684 24,561,462 8,548,536 39,342,098 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 63,631,138 11,223,396 300,867,783 296,265,820 $ $ $ $ 671,988,137 55,267,149 10,397,428 270,724,391 265,778,525 $ $ $ $ 602,167,493 50,441,110 10,368,336 254,909,647 241,276,568 $ $ $ $ 556,995,661 54,894,336 10,397,428 218,833,389 204,776,906 $ $ $ $ 488,902,059 372,813 51,891,002 61,001,619 113,265,434 Community Development 4,047,779 7,201,317 2,303,430 3,284,602 $ $ $ $ 16,837,128 3,519,761 6,410,169 2,135,110 2,725,597 Planning and Development Housing Economic Development Neighborhood Services Department 52,457,820 91,468,988 27,958,662 52,917,436 14,790,637 Total Community Development 224,802,906 $ $ $ $ 42,362,361 76,442,072 23,421,836 27,289,296 $ $ $ $ 169,515,565 35,961,902 75,600,876 22,892,056 26,032,569 $ $ $ $ 160,487,403 42,362,361 76,374,836 20,187,325 27,289,296 $ $ $ $ 166,213,818 67,236 3,234,511 3,301,747 Community Enrichment 8,630,731 3,495,989 546,927 4,654,320 980,381 5,841,245 403,349 373,961 24,926,903 $ $ $ $ $ $ $ $ 8,214,499 3,157,908 478,005 4,011,097 930,494 5,786,126 437,361 291,721 23,307,211 Parks and Recreation Library Golf Convention Center Sports and Cultural Facilities Human Services Public Parking Facilities Other Total Community Enrichment 101,194,979 35,786,355 5,683,994 62,561,583 21,323,644 63,044,520 5,369,072 4,126,369 $ $ $ $ $ $ $ $ 299,090,516 86,153,744 31,323,891 5,363,765 56,277,165 15,145,072 56,894,652 4,719,691 3,834,829 259,712,809 - 31 - $ $ $ $ $ $ $ $ 82,987,439 31,224,615 5,681,408 53,638,004 10,278,602 56,096,219 3,601,384 3,202,841 246,710,512 $ $ $ $ $ $ $ $ 85,777,611 31,323,891 5,363,765 38,160,743 56,626,856 4,719,691 3,834,829 225,807,386 $ $ $ $ $ $ $ $ 376,133 18,116,422 15,145,072 267,796 33,905,423 Citywide Operating Expenditures by Program (continued) For the Month Ended MAY 31 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 $ 27,049,412 11,147,817 16,174,132 3,660,532 194,912 $ $ $ $ $ 58,226,805 23,236,522 11,668,639 9,794,709 846,147 101,924 45,647,941 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 271,653,745 131,536,996 126,810,958 18,805,463 886,324 $ $ $ $ $ 549,693,486 252,037,867 127,103,105 107,036,640 16,053,209 718,659 $ $ $ $ $ 502,949,480 174,162,535 69,351,535 116,086,773 12,037,192 886,324 97,491,210 62,185,461 10,724,185 6,768,271 - 372,524,359 177,169,127 General Obligation Debt Service 16,421 1,291,209 2,287,131 68,917 375,397 27,914 1,108,955 171,215 633,344 535,036 105,398 1,138,765 32,525 569,639 443,902 180,848 1 115,327 1,317,551 421,862 513 552,718 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 11,394,588 126,841,283 $ 381,681,139 $ $ 16,421 1,214,797 2,366,799 69,429 404,943 33,321 1,134,548 173,496 451,049 628,009 117,323 1,045,463 74,591 582,628 521,113 657,381 16 115,073 1,258,618 425,244 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,802 Total Debt Service 137,965,967 28,037,762 Capital Improvement 740,377,428 $ Contingencies 134,646,000 $ 247,110,715 Total Operating Budget 180,629 14,206,665 25,338,262 758,913 4,134,148 308,485 12,208,610 1,887,882 6,500,608 5,888,481 1,162,214 12,534,163 357,775 6,276,851 4,882,921 1,989,333 659,421 1,268,598 14,524,499 4,645,100 5,638 6,079,899 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 125,799,095 3,956,982,515 468,803,199 3,155,862,568 - 32 - 180,629 13,362,765 26,034,787 763,722 4,454,367 366,529 12,480,033 1,908,451 4,961,536 6,908,098 1,290,549 11,500,100 820,508 6,408,902 5,732,247 7,231,184 36 1,265,802 13,844,798 4,677,688 5,637 15,763,313 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 139,961,681 $ $ 254,930,728 2,807,927,535 180,629 14,206,665 25,338,262 758,913 4,134,148 308,485 12,208,610 1,887,882 6,500,608 5,888,481 1,162,214 12,534,163 357,775 6,276,851 4,882,921 1,989,333 659,421 1,268,598 14,524,499 4,645,100 5,638 6,079,899 - 125,799,095 - $ - $ 2,341,849,503 468,803,199 814,013,065 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 515,523 14,203,412 1,178,482 22,284,888 600,000 64,248,599 629,126 5,116,031 81,775,710 965,000 156,367,083 8,561,919 232,822,910 54,573 $ 6,662,665 1,164,988 1,753,034 907,681 181,834 7,560,357 20,198,563 266,715 637,456 22,456,419 324,966 106,975,675 1,266,476 98,603,689 6,838,161 1,405,961 983,179 326,814 2,447,536 325,513 17,742,669 15,935,082 28,539 411,034 16,025,493 3,223,552 15,440,097 8,057,475 67,994,139 $ 614,931,968 $ 269,015,091 $ 157,185,244 $ $ 223,028,686 23,212,500 30,240,597 150,618,833 227,016,599 654,117,215 $ $ $ 1,269,049,183 $ 126,002,830 19,381,420 7,172,758 89,303,350 170,389,581 412,249,939 681,265,030 $ $ 505,191,980 21,379,866 4,474,090 35,069,207 83,677,628 649,792,771 $ 806,978,015 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 214,243 13,736,250 13,978,065 15,564,593 200,000 2,843,653 61,721,051 900,000 136,524,247 138,016,627 6,662,665 1,164,988 1,753,034 489,778 3,606,227 5,710,620 77,113 605,396 22,149,336 324,966 90,851,282 84,960,501 405,053,014 $ 218,355,906 $ 67,466,730 2,763,500 29,039,500 66,815,450 169,239,234 335,324,414 $ 740,377,428 - 33 - $ $ 37,891,544 636,503 6,259,278 70,470,426 135,189,542 250,447,293 $ 468,803,199 $ $ $ 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 417,903 181,834 3,954,130 14,487,943 189,602 32,060 307,083 16,124,393 1,266,476 13,643,188 209,878,954 $ 50,659,185 $ 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,668,014 35,012 10,261,673 515,523 13,295,731 996,648 14,724,531 600,000 44,050,036 362,411 4,478,575 59,319,291 640,034 49,391,408 7,295,443 134,219,221 $ 345,916,877 $ 88,111,286 18,744,917 913,480 18,832,924 35,200,039 161,802,646 $ $ 97,025,856 3,831,080 23,067,839 61,315,483 56,627,018 241,867,276 $ 212,461,831 $ 587,784,153 Bonds Authorized and Sold As of MAY 31 (dollars in thousands) Authorized Sold Available 1988 Authorizations General Obligation Bonds Freeway Mitigation, Neighborhood Stabilization, and Slum and Blight Elimination Bonds Fully Issued $ Total General Obligation Bonds Revenue Bonds Bonds Fully Issued Total 1988 Authorizations 29,285 884,175 $ 28,285 884,175 $ 1,000 - 913,460 912,460 1,000 143,890 143,890 - 1,057,350 1,056,350 1,000 66,300 125,300 24,800 61,500 12,000 33,000 91,500 74,000 77,000 78,800 66,000 43,700 64,600 124,685 24,170 60,700 11,205 32,100 89,275 71,645 72,575 77,685 65,950 43,700 1,700 615 630 800 795 900 2,225 2,355 4,425 1,115 50 - 753,900 738,290 15,610 81,000 11,100 198,700 12,800 104,622 74,705 29,178 115,500 107,295 78,200 65,400 63,385 8,510 190,610 8,345 85,510 61,200 21,100 102,290 81,900 58,135 61,770 17,615 2,590 8,090 4,455 19,112 13,505 8,078 13,210 25,395 20,065 3,630 878,500 742,755 135,745 2001 Authorization General Obligation Bonds Education, Youth and Family Cultural Facilities Computer Technology Environmental Cleanup Fire Protection Historic Preservation Library Facilities Street Improvements Neighborhood Protection and Senior Centers Parks, Open Space, and Recreational Facilities Police Protection Storm Sewer and Flood Protection Bonds Fully Issued Total 2001 Authorizations 2006 Authorization General Obligation Bonds Affordable Housing and Neighborhood Revitalization Computer Technology Education and Health Science Facilities Environmental Cleanup Family, Senior, and Youth Cultural Facilities Fire Protection Library Facilities and Improvements Parks, Open Space, and Recreational Facilities Police Protection Street Improvements Storm Sewer and Flood Protection Total 2006 Authorizations Total Bond Program $ 2,689,750 - 34 - $ 2,537,395 $ 152,355 Appendix A Additional historic and trend information for various revenue streams. Local Sales Tax (Dollars in Thousands) Local Sales Tax 50,000 12-13 Actuals 45,000 13-14 Actuals 40,000 14-15 Actuals 35,000 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 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 - Feb Feb 32,542 32,084 34,432 32,793 22,766 34,211 Mar Mar 32,047 32,147 34,938 33,135 33,502 34,319 Apr May Apr 34,911 35,988 37,203 36,307 28,921 37,469 June May 34,699 33,165 33,049 34,236 47,647 35,067 YTD thru May 372,533 383,228 386,633 381,668 384,063 395,442 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 May 9,902 10,863 11,697 11,470 12,004 12,075 YTD thru May 108,131 115,655 120,905 125,659 130,353 129,287 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 May 4,088 4,643 5,108 4,943 4,938 5,328 YTD thru May 43,535 46,911 50,266 53,818 55,720 55,192 June 4,834 4,778 5,027 5,983 5,850 Governmental Funds Revenue (Dollars in Thousands) Governmental Funds Revenue 260,000 2012-13 Actuals 240,000 2013-14 Actuals 220,000 2014-15 Actuals 200,000 2015-16 Actuals 180,000 2016-17 Actuals 160,000 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 May 182,000 204,907 192,623 193,402 251,092 220,777 June YTD thru May 1,654,558 1,721,313 1,719,854 1,772,246 1,959,680 1,964,352 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 May 31,020 29,350 29,251 29,439 32,146 29,834 YTD thru May 319,235 302,761 310,516 315,844 323,153 312,817 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 May 34,663 36,292 32,249 34,122 38,009 37,025 YTD thru May 387,646 356,236 339,386 354,130 371,176 378,594 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 May 17,982 18,299 17,762 18,555 20,233 18,616 YTD thru May 203,031 197,471 198,295 206,436 211,315 205,257 June 14,638 16,909 18,253 19,289 18,559