June 2014 Monthly Financial Report PREPARED BY Financial Accounting & Reporting Division City of Phoenix Monthly Financial Report June 2014 Table of Contents Expenditures by Programs Page Performance Status General Fund Expenditures General Fund Total Expenditures 1 Better than Expected Report Navigation General Government 1 Better than Expected Click on either the schedule name or the Criminal Justice 2 Better than Expected performance status in the table of contents to Public Safety 2 Better than Expected be taken directly to that page of the report. Transportation 3 Better than Expected Community Development 3 Better than Expected From any page of the report, click on the Community Enrichment 4 Better than Expected City of Phoenix Bird Emblem to return to the Environmental Services 4 Better than Expected Table of Contents Citywide Total Operating Expenditures 5 Better than Expected General Government 5 Better than Expected Criminal Justice 6 Better than Expected Citywide Expenditures 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 Corrective Action Taken - Negative variance CIP-Aviation 10 greater than 1% actual vs budget, however the CIP-Phoenix Convention Center 11 City has taken action to address the negative CIP-Solid Waste Disposal 11 variance. CIP-Wastewater 12 CIP-Water System 12 Revenues by Source General Fund Total Operating Revenue Page 13 Performance Status Corrective Action Taken Property Tax 14 Expected Local Sales Tax 15 Corrective Action Taken State Sales Tax 16 Expected Vehicle License Tax 17 Better than Expected Regional Transit Revenues 18 Monitor & Consider Corrective Action Aviation 19 Better than Expected Water System 20 Monitor & Consider Corrective 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. June General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Total General Fund Expenditures 09-10 10-11 11-12 12-13 13-14 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 994,322 994,322 100.0% 954,795 954,795 100.0% 995,771 995,771 100.0% 1,038,092 1,038,092 100.0% 1,042,102 1,089,602 95.6% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustment for contingencies. Better than Expected TotalGovernment General Fund General $1,100,000 $1,100,000 June YTD June YTD Expenditures Expenditures $1,050,000 $1,050,000 $1,000,000 $1,000,000 $950,000 $950,000 Annual Annual Expenditures * Expenditures * $900,000 $900,000 $850,000 $850,000 09-10 09-10 10-11 10-11 11-12 11-12 12-13 12-13 13-14 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. For fiscal year 2013-14, general fund expenditures were budgeted to increase 5.0% over fiscal year 2012-13 actuals. Through June 2014, general fund expenditures are performing better than expected as year to date expenditures are 0.4% higher than through June 2013. The lower than expected expenditures are the result of the City's efforts to reduce costs due to the lower than expected general fund revenues. General Government 09-10 10-11 11-12 12-13 13-14 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 77,130 77,130 100.0% 70,650 70,650 100.0% 98,577 98,577 100.0% 102,211 102,211 100.0% 100,400 106,532 94.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice General Government $120,000 $120,000 $100,000 $100,000 $80,000 $80,000 $60,000 $60,000 $40,000 $40,000 June YTD Expenditures June YTD Expenditures Annual Expenditures * Annual Expenditures * $20,000 $20,000 $0$0 09-10 09-10 10-11 10-11 11-12 12-13 12-13 13-14 13-14 11-12 General government expenditures include costs for administrative and internal service functions such as the Mayor and City Council, City Manager's Office, City Auditor, Finance, Budget and Research, and Human Resources. General fund general government expenditures are better than expected through June 2014 with a 1.8% decrease from the same period in the prior year. The fiscal year 2013-14 budget includes a 4.2% increase over fiscal year 2012-13 actuals. The better than expected performance reflects actions taken by departments to reduce costs due to the lower than expected general fund revenues. -1- June General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Criminal Justice 09-10 10-11 11-12 12-13 13-14 Criminal Justice Public Safety June YTD Annual % of Annual Expenditures Expenditures * Expenditures 35,028 35,028 100.0% 33,324 33,324 100.0% 33,542 33,542 100.0% 33,453 33,453 100.0% 32,659 34,298 95.2% * - For prior years-total actual expenditures, for current year-total approved budget $40,000 $35,500 $35,000 $35,000 $34,500 $30,000 $34,000 $25,000 $33,500 $33,000 $20,000 $32,500 $15,000 $32,000 $31,500 $10,000 $31,000 $5,000 June YTD Expenditures June YTD Expenditures Annual Expenditures * Annual Expenditures * 09-10 10-11 11-12 12-13 13-14 $0 Better than Expected 09-10 10-11 11-12 12-13 13-14 Criminal justice expenditures include costs for municipal courts and public defenders. General fund criminal justice expenditures are better than expected through June 2014 with a 2.4% decrease from the same period in the prior year. The fiscal year 2013-14 budget includes a 2.5% increase over fiscal year 2012-13 actuals. The better than expected performance reflects actions taken by departments to reduce costs due to the lower than expected general fund revenues. Public Safety June YTD % of Annual Annual Expenditures Expenditures * Expenditures 09-10 10-11 11-12 12-13 13-14 658,886 639,691 647,049 684,609 699,796 658,886 639,691 647,049 684,609 713,122 100.0% 100.0% 100.0% 100.0% 98.1% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Transportation Public Safety $720,000 $720,000 $700,000 $700,000 $680,000 $680,000 $660,000 June YTD Expenditures June YTD Expenditures $660,000 $640,000 $620,000 $640,000 $600,000 $620,000 09-10 10-11 11-12 12-13 13-14 Annual Expenditures * Annual Expenditures * $600,000 09-10 10-11 11-12 12-13 13-14 Public safety expenditures include costs for police and fire services. General fund public safety expenditures are better than expected through June 2014 with a 2.2% increase over the same period in the prior year. The fiscal year 2013-14 budget includes a 4.2% increase over fiscal year 2012-13 actuals. The better than expected performance reflects actions taken by departments to reduce costs due to the lower than expected general fund revenues. - 2- June General Fund YTD Expenditures (Dollars in Thousands) Transportation June YTD % of Annual Annual Expenditures Expenditures * Expenditures 09-10 10-11 11-12 12-13 13-14 39,570 38,711 39,161 38,161 29,713 39,570 38,711 39,161 38,161 41,617 100.0% 100.0% 100.0% 100.0% 71.4% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Refer to detailed financial schedules pages 22 thru 34 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 June YTD Expenditures June YTD Expenditures Annual Annual Expenditures * Expenditures * 09-10 09-10 10-11 10-11 11-12 11-12 12-13 12-13 13-14 13-14 Transportation expenditures include costs for public transit and street maintenance and repair. General fund transportation expenditures are better than expected through June 2014 with a 22.1% decrease over the same period in the prior year. The fiscal year 2013-14 budget includes a 9.1% increase over fiscal year 201213 actuals. As part of the plan to reduce the food tax in January 2014, Public Transit used savings achieved by refunding transit bonds to reduce the amount of support needed from the General Fund resulting in the significant decrease in transportation expenses from fiscal year 2012-13 to fiscal year 2013-14. Community Development Community Development 09-10 10-11 11-12 12-13 13-14 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 21,352 21,352 100.0% 19,458 19,458 100.0% 19,393 19,393 100.0% 19,927 19,927 100.0% 20,210 22,551 89.6% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $23,000 $22,500 $25,000 $22,000 $21,500 $20,000 $21,000 $15,000 $20,500 $20,000 $10,000 $19,500 $19,000 $5,000 $18,500 $18,000 $0 $17,500 Community Enrichment June YTD June YTD Expenditures Expenditures Annual Annual Expenditures * Expenditures * 09-10 10-11 09-10 10-11 11-12 11-12 12-13 12-13 13-14 13-14 Community development expenditures include costs for economic development and neighborhood services. General fund community development expenditures are better than expected through June 2014 with a 1.4% increase over the same period in the prior year. The fiscal year 2013-14 budget includes a 13.2% increase over fiscal year 2012-13 actuals. The better than expected performance reflects actions taken by departments to reduce costs due to the lower than expected general fund revenues. -3- June General Fund YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Community Enrichment 09-10 10-11 11-12 12-13 13-14 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 145,893 145,893 100.0% 137,793 137,793 100.0% 140,026 140,026 100.0% 141,209 141,209 100.0% 143,665 151,502 94.8% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Environmental Services Community Enrichment $160,000 $155,000 $140,000 $150,000 $120,000 $100,000 $145,000 $80,000 $60,000 $140,000 $40,000 $135,000 $20,000 $0 $130,000 09-10 10-11 09-10 10-11 JuneYTD YTD June Expenditures Expenditures Annual Expenditures * Annual Expenditures * 11-12 11-12 12-13 12-13 13-14 13-14 Community enrichment expenditures include costs for parks, recreational activities, senior centers and community centers. General fund community enrichment expenditures are better than expected through June 2014 with a 1.7% increase over the same period in the prior year. The fiscal year 2013-14 budget includes a 7.3% increase over fiscal year 2012-13 actuals. The better than expected performance reflects actions taken by departments to reduce costs due to the lower than expected general fund revenues. Environmental Services 09-10 10-11 11-12 12-13 13-14 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 15,767 15,767 100.0% 14,046 14,046 100.0% 15,723 15,723 100.0% 15,353 15,353 100.0% 13,748 17,538 78.4% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Total GeneralServices Fund $20,000 $18,000 $16,000 $14,000 $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 $0 Better than Expected June YTD Expenditures Annual Expenditures * 09-10 10-11 11-12 12-13 13-14 Environmental service expenditures include costs for maintaining and operating city facilities. General Fund environmental services expenditures are better than expected through June 2014 with a 10.5% decrease over the same period in the prior year. The fiscal year 2013-14 budget includes a 14.2% increase over fiscal year 2012-13 actuals. Lower fuel costs account for the majority of the decrease from the prior year. The better than expected performance also reflects actions taken by departments to reduce costs due to the lower than expected general fund revenues. -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. June Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Total Citywide Operating 09-10 10-11 11-12 12-13 13-14 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 2,923,454 2,923,454 100.0% 3,026,005 3,026,005 100.0% 2,985,410 2,985,410 100.0% 3,123,865 3,123,865 100.0% 3,054,098 3,462,278 88.2% * - For prior years-total actual expenditures, for current year-total approved budget net of adjustments for contingencies and use of the early redemption fund. Total Citywide General Government $3,600,000 $3,600,000 $3,500,000 $3,500,000 $3,400,000 $3,400,000 $3,300,000 $3,300,000 $3,200,000 $3,200,000 $3,100,000 $3,100,000 $3,000,000 $3,000,000 $2,900,000 $2,900,000 $2,800,000 $2,800,000 $2,700,000 $2,700,000 $2,600,000 $2,600,000 Better than Expected June YTD June YTD Expenditures Expenditures Annual Annual Expenditures * Expenditures * 09-10 09-10 10-11 10-11 11-12 11-12 12-13 12-13 13-14 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. Additionally, per the note on General Obligation Debt Service Expenditures (Page 9), the credit for the use of the early redemption fund will not be included in the budgetary total. After these adjustments, the budget for fiscal year 2013-14 anticipated an increase 10.8% in total operating expenditures. Actual expenditures are better than expected with a year to date decrease of 2.2% from the prior year through June 2014. General Government 09-10 10-11 11-12 12-13 13-14 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 84,752 84,752 100.0% 78,047 78,047 100.0% 109,658 109,658 100.0% 114,015 114,015 100.0% 114,235 121,981 93.6% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Criminal Justice General Government $140,000 $140,000 $120,000 $120,000 $100,000 $100,000 $80,000 $80,000 $60,000 $60,000 $40,000 $40,000 June YTD Expenditures June YTD Expenditures Annual Expenditures * Annual Expenditures * $20,000 $20,000 $0 09-10 10-11 11-12 11-12 12-13 12-13 13-14 13-14 General government expenditures include costs for administrative and internal service functions such as the Mayor and City Council, City Manager's Office, City Auditor, Finance, Budget and Research, and Human Resources. Citywide general government expenditures are better than expected with a year-to-date increase of 0.2% through June 2014 over the prior June. This is lower than the budgeted increase of 7.0% for fiscal year 2013-14 over prior year actuals. -5- June Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Criminal Justice 09-10 10-11 11-12 12-13 13-14 Public Safety Criminal Justice June YTD Annual % of Annual Expenditures Expenditures * Expenditures 42,633 42,633 100.0% 36,958 36,958 100.0% 36,305 36,305 100.0% 41,290 41,290 100.0% 40,697 46,871 86.8% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $50,000 $200,000 $45,000 $40,000 $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $0 $5,000 09-10 10-11 11-12 12-13 13-14 $0 09-10 10-11 11-12 12-13 13-14 June YTD Expenditures June YTD Expenditures Annual Annual Expenditures * Expenditures * Criminal Justice expenditures include costs of the Municipal Court and the Public Defender’s office. Citywide criminal justice expenditures are better than expected with a year to date decrease at June 2014 of 1.4% from the prior June. The budgeted increase for fiscal year 2013-14 over prior year actuals is 13.5%. Public Safety Transportation Public Safety June YTD % of Annual Annual Expenditures Expenditures * Expenditures 09-10 10-11 11-12 12-13 13-14 817,192 792,002 803,367 842,387 842,270 817,192 792,002 803,367 842,387 875,841 100.0% 100.0% 100.0% 100.0% 96.2% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected $1,000,000 $900,000 $880,000 $860,000 $800,000 $840,000 $820,000 $800,000 $780,000 $600,000 $760,000 09-10 10-11 11-12 12-13 13-14 $740,000 09-10 10-11 11-12 12-13 13-14 June YTD Expenditures June YTD Expenditures Annual Expenditures * Annual Expenditures * Public Safety expenditures include costs of Police, Fire and Emergency Management. Citywide public safety expenditures are better than expected with June 2014 expenditures about equal to June 2013 amounts. The budgeted increase for fiscal year 2013-14 over prior year actuals is 4.0%. -6- June Citywide YTD Expenditures (Dollars in Thousands) Transportation % of Annual June YTD Annual Expenditures Expenditures * Expenditures 09-10 10-11 11-12 12-13 13-14 577,083 567,830 584,429 582,381 573,025 577,083 567,830 584,429 582,381 639,414 100.0% 100.0% 100.0% 100.0% 89.6% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected Refer to detailed financial schedules pages 22 thru 34 Transportation Community Development $660,000 $640,000 $620,000 June YTD Expenditures June YTD Expenditures $600,000 $600,000 $580,000 $580,000 $560,000 $560,000 $540,000 $540,000 $520,000 $520,000 Annual Annual Expenditures * Expenditures * 09-10 09-10 10-11 10-11 11-12 11-12 12-13 12-13 13-14 13-14 Transportation expenditures include costs for Street lighting, maintenance and repair; Aviation and Public Transit. Citywide transportation expenditures are better than expected with a year to date decrease at June 2014 of 1.6% from the prior June. The budgeted increase for fiscal year 2013-14 over prior year actuals is 9.8%. Community Development 09-10 10-11 11-12 12-13 13-14 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 170,213 170,213 100.0% 176,114 176,114 100.0% 192,133 192,133 100.0% 209,403 209,403 100.0% 194,542 234,163 83.1% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected CommunityDevelopment Enrichment Community $250,000 $250,000 JuneYTD YTD June Expenditures Expenditures $200,000 $200,000 $150,000 $150,000 $100,000 $100,000 $50,000 $50,000 $0 $0 09-10 09-10 Annual Expenditures * Annual Expenditures * 10-11 10-11 11-12 11-12 12-13 12-13 13-14 13-14 Community Development expenditures include costs for Neighborhood Services, Housing, Planning and Economic Development. Citywide community development expenditures are better than expected with a year to date decrease at June 2014 of 7.1% from the prior June. These expenditures were budgeted to increase 11.8% for fiscal year 2013-14 over prior year actuals. The decrease is primarily due to the culmination of the ARRA grants leading to lower spending levels in Neighborhood Services. -7- June Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Community Enrichment 09-10 10-11 11-12 12-13 13-14 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 283,569 283,569 100.0% 274,824 274,824 100.0% 272,353 272,353 100.0% 273,110 273,110 100.0% 272,326 289,946 93.9% * - For prior years-total actual expenditures, for current year-total approved budget Environmental Services Community Enrichment $350,000 $295,000 $300,000 $290,000 $250,000 $285,000 $200,000 $280,000 $150,000 $275,000 $100,000 $270,000 $50,000 $265,000 $0 $260,000 Better than Expected JuneYTD YTD June Expenditures Expenditures Annual Expenditures * Annual Expenditures * 09-10 09-10 10-11 10-11 11-12 11-12 12-13 12-13 13-14 13-14 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 a year to date decrease at June 2014 of 0.3% from the prior June. The budgeted increase for fiscal year 2013-14 over prior year actuals is 6.2%. Environmental Services 09-10 10-11 11-12 12-13 13-14 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 579,689 579,689 100.0% 572,693 572,693 100.0% 549,628 549,628 100.0% 564,051 564,051 100.0% 577,118 627,459 92.0% * - For prior years-total actual expenditures, for current year-total approved budget Better than Expected General Obligation Services Debt Service Environmental $700,000 $640,000 $600,000 $620,000 JuneYTD YTD June Expenditures Expenditures $500,000 $600,000 $400,000 $580,000 $300,000 $560,000 $200,000 $540,000 $100,000 $520,000 $0 $500,00009-10 10-11 11-12 12-13 09-10 10-11 11-12 12-13 Annual Expenditures * Annual Expenditures * 13-14 13-14 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 better than expected with a year to date increase at June 2014 of 2.3% over the prior June. The budgeted increase for fiscal year 2013-14 over prior year actuals is 11.2%. -8- June Citywide YTD Expenditures (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 General Obligation Debt Service 09-10 10-11 11-12 12-13 13-14 June YTD Annual % of Annual Expenditures Expenditures * Expenditures 168,779 168,779 100.0% 196,779 196,779 100.0% 157,298 157,298 100.0% 137,208 137,208 100.0% 100,524 100,790 99.7% * - 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 $250,000 $250,000 JuneYTD YTD June Expenditures Expenditures $200,000 $200,000 $150,000 $150,000 $100,000 $100,000 Annual Expenditures * Annual Expenditures * $50,000 $50,000 $0 $009-10 10-11 11-12 12-13 09-10 10-11 11-12 12-13 13-14 13-14 In order to better compare the current year budget to prior year actuals, the budget for General Obligation Debt Service expenditures has been increased by $45.6 million over the amount recorded on the accompanying statements. The approved budget includes a credit for $45.6 million to be taken from the early redemption fund which is not included in available resources for budget purposes. However, the expenditures are measured at full value for the actuals. Using the adjusted budget figure, general obligation debt service expenditures are performing as expected. Budgeted expenditures for fiscal year 2013-14 are 26.5% lower than actual expenditures for the prior fiscal year. Through June 2014, year to date expenditures are 26.7% lower than the prior June. -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 Refer to detailed financial schedules pages 22 - 34 09-10 10-11 11-12 12-13 13-14 (Budget) 13-14 (YTD) $ 371,045 $ 388,422 $ 232,848 $ 320,599 $ 531,186 $ 263,112 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 (Avenida Rio Salado-$27 million, Sonoran Desert Drive-$14 million, Black Mountain Blvd ramps to SR51-$9 million, Pinnacle Peak Rd-$10 million, and Greenway Rd/Cave Creek Wash Bridge-$7 million), and Police PACE Upgrade/Replacement ($12 million). 13-14 (YTD) 13-14 (Budget) 12-13 11-12 Major Projects in fiscal year 2012-13 included Bus Acquisitions ($60 million), Sonoran Preserve Land Acquisitions ($25 million), Ballet Arizona and Arizona Opera facilities ($8 million), and the purchase of fire safety apparatus ($6 million). 10-11 09-10 $0 Aviation $200,000 $400,000 09-10 10-11 11-12 12-13 13-14 (Budget) 13-14 (YTD) $ 566,779 $ 157,884 $ 332,920 $ 168,639 $ 315,148 $ 180,571 $600,000 Discussion: Aviation In addition to the ongoing capital costs needed to maintain the property and infrastructure of the Aviation Department, in fiscal year 2009-10 the department spent $440 million on stage 1 of the PHX Sky Train and in fiscal year 2011-12 the department spent $190 million on stage 1a of the PHX Sky Train. In fiscal year 2013-14 the department has spent $19 million on Terminal Development Concept Design. 13-14 (YTD) 13-14 (Budget) 12-13 11-12 10-11 09-10 $0 $200,000 $400,000 $600,000 - 10 - Capital Expenditures (Dollars in Thousands) 09-10 Phx Convention Ctr 10-11 12,109 4,493 Refer to detailed financial schedules pages 22 - 34 11-12 12-13 1,644 Discussion: 21,830 13-14 (Budget) 26,370 13-14 (YTD) 23,189 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. For fiscal year 2012-13 and fiscal year 2013-14 that payment was $20 million. 13-14 (YTD) 13-14 (Budget) 12-13 11-12 10-11 09-10 $0 09-10 Solid Waste 10-11 13,326 22,640 11-12 $10,000 12-13 15,512 8,605 13-14 (Budget) 23,656 $20,000 $30,000 13-14 (YTD) 8,063 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. 13-14 (YTD) 13-14 (Budget) 12-13 11-12 10-11 09-10 $0 $10,000 $20,000 $30,000 - 11 - Capital Expenditures (Dollars in Thousands) 09-10 Wastewater $ 43,016 Refer to detailed financial schedules pages 22 - 34 10-11 $ 41,347 11-12 $ 66,342 12-13 13-14 (Budget) $ 109,914 $ 121,032 Discussion: 13-14 (YTD) $ 58,012 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. 13-14 (YTD) 13-14 (Budget) 12-13 11-12 10-11 09-10 $0 Water System 09-10 10-11 $ 138,146 $ 246,177 11-12 $ 95,990 $50,000 $100,000 12-13 13-14 (Budget) 13-14 (YTD) $ 110,333 $ 182,968 $ 129,080 $150,000 Discussion: Water System Major Projects in fiscal year 2009-10 included Val Vista GAC Contactors ($25 million) and Automatic Meter Reading System ($7 million). 13-14 (YTD) 13-14 (Budget) Major Projects in fiscal year 2010-11 included Val Vista GAC Contactors ($51 million), Rehabilitation of the 42nd St/Baseline Reservoir ($19 million), DBP mitigation at various water treatment plants ($27 million), and Residential Pressure Improvements ($41 million). 12-13 11-12 10-11 09-10 $0 $100,000 $200,000 $300,000 Major projects in fiscal year 2013-14 include construction of a new 20 million gallon concrete reservoir at Deer Valley WTP ($16 million). Additionally, the Water department has spent about $100 million per year to maintain the infrastructure for the water system. - 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,060,000 $1,040,000 $1,020,000 $1,000,000 $980,000 $960,000 $940,000 $920,000 $900,000 $880,000 June YTD Actuals Annual Revenues* 09-10 09-10 10-11 11-12 12-13 13-14 June YTD Actuals 944,096 962,689 948,384 980,945 1,026,167 Annual Revenues* 944,096 962,689 948,384 980,945 1,051,789 10-11 11-12 12-13 13-14 % of Annual Revenues 100.0% 100.0% 100.0% 100.0% 97.6% * - For prior years - total actual revenues, for current year - total approved budget Corrective Action Taken Fiscal Year 2013-14 general fund operating revenues were budgeted to increase 7.2% over prior year actuals. Actual year over year revenue growth through June 2014 is 4.6%. The Budget and Research Department is monitoring the shortfall in revenues and has worked with departments to reduce expenditures so that expenditures will not exceed available resources. 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 350,000 300,000 Secondary 250,000 196,673 200,000 149,019 94,436 62,012 35,204 35,443 121,366 130,913 128,054 132,101 143,931 142,849 09-10 10-11 11-12 12-13 13-14 YTD 13-14 budget 150,000 Primary 100,000 50,000 - FY 09-10 10-11 11-12 12-13 13-14 YTD 13-14 budget Total 318,039 279,932 222,488 194,112 179,136 178,292 July (2,743) (3,017) (2,553) (1,733) (1,260) (1,869) Aug 1,842 1,118 1,059 1,349 971 903 Sept 908 1,279 1,189 904 867 863 Oct 12,540 18,792 13,656 11,888 11,107 11,349 Nov 92,245 85,251 55,555 54,091 46,645 49,888 Dec 52,851 34,444 40,845 31,075 32,028 27,226 Jan 9,954 9,642 7,689 7,015 7,180 6,232 Feb 6,193 5,599 5,685 4,743 3,818 4,102 Mar 11,325 10,676 8,871 6,670 5,668 6,711 Apr 14,830 14,532 11,013 8,323 7,300 8,669 May 85,484 68,087 35,952 44,111 44,562 37,922 June 32,610 33,529 43,527 25,676 20,250 26,296 Note: Monthly budget amount for 13-14 is the average % of last 3 years of the total budget amount 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. Property tax revenues for fiscal year 2013-14 are performing as expected showing a 7.7% decline from prior year actuals as opposed to the 8.1% decline anticipated in the budget. Total property tax revenues have been decreasing each year since fiscal year 2009-10 and since the assessments for property taxes lag market changes by about two years, the revenues have not yet benefitted from the market recovery. - 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 13-14 Actuals 20,000 13-14 budget 15,000 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Corrective Action Taken Local sales tax revenues through June 2014 are 5.5% below budget for that period. The Budget and Research Department has adjusted their revenue estimates to account for the budget shortfall. The new revenue estimates are being used by departments as they adjust expenditure levels so that expenditures do not exceed available resources. Local Sales Tax 3 Year Trend 45,000 40,000 35,000 30,000 25,000 11-12 Actuals 20,000 12-13 Actuals 15,000 13-14 Actuals 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June As you can see from the chart above, local sales tax revenues have been increasing over the last three years. Revenues for fiscal year 2013-14 are 1.8% higher than fiscal year 2012-13 which was 1.0% higher than fiscal year 2011-12. The current year was bolstered by a strong holiday season reflected in a 9.8% increase over the prior year for the month of January. In the five months (February through June) reflecting the reduction of the food tax from 2% to 1%, the City has experienced a 2.4% year over year reduction in local sales tax revenues. 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 14,000 12,000 10,000 13-14 Actuals 8,000 13-14 budget 6,000 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Expected State shared sales tax revenues are performing as expected through June 2014 at 0.3% below the budget estimates for the same period. State Sales Tax 3 Year Trend 14,000 12,000 10,000 8,000 11-12 Actuals 12-13 Actuals 6,000 13-14 Actuals 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Fiscal year 2013-14 state shared sales tax revenues were 7.0% higher than fiscal year 2012-13. This growth rate is nearly 75% greater than the 4.1% growth rate from fiscal year 2011-12 to fiscal year 2012-13 reflecting continued economic recovery. 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 6,000 5,000 4,000 13-14 Actuals 3,000 Budget 13-14 2,000 1,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Better than Expected State shared vehicle license tax revenues are better than expected at 1.1% higher than budgeted through June 2014. Vehicle License Tax 3 Year Trend 6,000 5,000 4,000 11-12 Actuals 3,000 12-13 Actuals 2,000 13-14 Actuals 1,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June State shared vehicle license tax revenues for fiscal year 2013-14 increased 6.9% over fiscal year 2012-13. This follows a 4.2% increase for fiscal year 2012-13 over fiscal year 2011-12 which reversed a trend of declining revenues from fiscal year 2009-10 through fiscal year 2011-12. Click Here for Additional Information - 17 - Regional Transit Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Regional Transit Revenues Budget vs Actual 12,000 10,000 13-14 Actuals 8,000 Budget 13-14 6,000 4,000 2,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Monitor & Consider Corrective Action Regional transit revenues are generated through agreements with other communities for transit services. Through June 2014, actuals were 2.2% lower than budget expectations for the fiscal year. The variance is primarily driven by lower than expected bus acquisition costs related to other communities resulting in lower revenues. Since both costs and revenues are lower, no corrective action is needed. Regional Transit Revenues 3 Year Trend 12,000 10,000 8,000 11-12 Actuals 6,000 4,000 12-13 Actuals 2,000 13-14 Actuals July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June (2,000) The City is reimbursed for bus route operations which tend to be stable from year to year. The City is also reimbursed for bus acquisitions which can result in large year over year variances. The city recorded revenues related to bus acquisitions of $5.5 million in February and $5.8 million in May. Additionally, the City received payments from Valley Metro Rail of $3.3 million related to the Northwest Extension funding agreement. These revenues account for the majority of the 72.2% increase in regional transit revenues for fiscal year 2013-14 as compared to fiscal year 2012-13. 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 13-14 Actuals 20,000 Budget 13-14 15,000 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Better than Expected Aviation revenues through June 2014 were better than expected at 6.7% higher than budget expectations for the same period. Concession revenues related to commercial tenants in the terminals and airline joint use spaces are well ahead of budget projections through June. Aviation Operating Revenues 3 Year Trend 40,000 35,000 30,000 25,000 11-12 Actuals 20,000 12-13 Actuals 15,000 10,000 13-14 Actuals 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June In the above chart, fiscal years 2011-12 and 2012-13 include Customer Facility Charge revenues. In fiscal year 2013-14, Customer Facility Charge revenues were moved from operating to non-operating to better reflect their required use for capital projects and debt service. In fiscal year 2012-13, those revenues amounted to $41.4 million. Not counting the Customer Facility Charge, Aviation revenues for fiscal year 2013-14 increased $23.7 million (7.7%) over the prior year. This growth rate in revenues more than triples the 2.5% growth rate for fiscal year 201213 over fiscal year 2011-12. 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 13-14 Actuals Budget 13-14 30,000 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Monitor & Consider Corrective Action Water revenues are 2.2% below budget projections through June 2014. These revenues are being monitored. However, at this time, no specific actions are being taken as Water’s available resources are enough to meet expenditure requirements. Water System Operating Revenues 3 Year Trend 90,000 80,000 70,000 60,000 11-12 Actuals 50,000 40,000 12-13 Actuals 30,000 13-14 Actuals 20,000 10,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June In July 2012 Water sold land in McMullen Valley for $29.7 million. Not including those revenues in fiscal year 2012-13, water revenues in fiscal year 2013-14 are 0.8% higher than the prior year. This follows four years of revenue growth. Click Here for Additional Information - 20 - Wastewater Revenues (Dollars in Thousands) Refer to detailed financial schedules pages 22 thru 34 Wastewater Operating Revenues Budget vs Actual 25,000 20,000 15,000 13-14 Actuals Budget 13-14 10,000 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Better than Expected Wastewater revenues through June 2014 are better than expected at 1.5% higher than budget expectations for the same time frame. Wastewater Operating Revenues 3 Year Trend 30,000 25,000 20,000 11-12 Actuals 15,000 12-13 Actuals 10,000 13-14 Actuals 5,000 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June Wastewater revenues are $3.3 million (1.5%) less in fiscal year 2013-14 than in the prior year. Wastewater rates decreased effective July 1, 2012 leading to a decrease in revenues for fiscal year 2012-13 from fiscal year 2011-12. Click Here for Additional Information - 21 - 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 June 30 (dollars in thousands) Actual Year-to-Date 2013-14 2012-13 Budget Estimate 2013-14 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 Planning & Development Street Transportation Fire Emergency Transportation Service Other Interest Other Fees and Service Charges Total Revenues $ $ 442,309 2,363 418,126 $ 2,483 410,777 2,352 127,448 160,852 51,150 142,849 2,830 9,525 127,005 161,580 51,689 143,931 2,774 9,720 118,730 147,668 48,369 132,101 2,703 9,505 19,312 1,210 13,266 1,362 7,912 1,058 3,975 17,540 1,013 14,703 1,080 8,127 1,251 4,437 18,927 1,086 12,682 1,006 8,238 1,250 4,194 37,900 12,451 2,200 11,817 30,788 12,884 1,987 15,049 33,719 12,369 1,439 13,831 1,026,167 $ 980,946 1,051,789 - 22 - $ $ General Fund Expenditures As of June 30 (dollars in thousands) Actual Year-to-Date 2013-14 2012-13 Budget Estimate 2013-14 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,755 3,590 2,442 32,781 2,419 2,367 19,542 2,389 5,694 10,225 3,054 18,061 2,213 106,532 Criminal Justice Municipal Court Public Defender Total Criminal Justice $ 1,628 $ 3,345 2,170 31,725 2,185 2,197 18,745 2,294 4,338 9,188 2,996 17,712 1,877 100,400 1,669 3,227 1,924 32,774 2,441 2,262 19,770 1,950 4,699 9,732 2,920 16,363 2,480 102,211 29,395 4,903 34,298 27,871 4,788 32,659 28,687 4,766 33,453 Public Safety Police Fire Others Total Public Safety 462,407 250,693 22 713,122 454,377 245,405 14 699,796 444,822 239,771 16 684,609 Transportation Street Transportation Public Transit Total Transportation 22,097 19,520 41,617 18,033 11,680 29,713 18,747 19,414 38,161 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 5,134 12,337 5,026 54 22,551 4,478 11,499 4,185 48 20,210 4,195 11,374 4,309 49 19,927 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 94,371 35,478 18,711 2,942 151,502 90,607 33,326 17,195 2,537 143,665 87,540 33,564 17,809 2,296 141,209 Environmental Services Public Works Environmental Programs Total Environmental Services 16,554 984 17,538 13,042 706 13,748 14,557 796 15,353 2,442 1,911 3,169 38,313 - - Capital Improvement Contingencies Total Expenditures and Encumbrances $ 1,127,915 - 23 - $ 1,042,102 $ 1,038,092 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 June 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 Budget Estimate 2013-14 $ Total General Funds 442,309 2,363 418,126 $ 2,483 410,777 2,352 127,448 160,852 51,150 142,849 2,830 9,525 20,522 13,266 1,362 7,912 1,058 3,975 50,351 2,200 11,817 127,005 161,580 51,689 143,931 2,774 9,720 18,553 14,703 1,080 8,127 1,251 4,437 43,672 1,987 15,049 118,730 147,668 48,369 132,101 2,703 9,505 20,013 12,682 1,006 8,238 1,250 4,194 46,088 1,439 13,831 1,051,789 1,026,167 980,946 30,240 85,231 30,399 8,056 171,171 15,377 36,720 17,226 15,829 100,600 41,867 4,862 31,368 288,554 40,581 29,340 83,042 29,393 8,927 179,686 12,849 40,550 15,159 16,269 102,463 40,931 5,219 32,163 236,421 39,887 27,668 79,599 27,727 8,338 163,200 9,827 40,433 16,452 15,264 99,032 23,767 4,844 37,267 294,545 66,857 918,081 872,299 914,820 309,343 60,544 407,753 211,312 145,756 329,961 61,029 398,799 214,380 146,448 347,698 59,621 425,325 217,669 143,341 1,134,708 1,150,617 1,193,654 3,049,083 $ 3,089,420 Special Revenue and Debt Service Funds Neighborhood Protection Public Safety Enhancement & Expansion Parks and Preserves Golf Courses Transit 2000 Court Awards Planning and Development Capital Construction Sports Facilities Highway User Revenue Regional Transit Revenues Community Reinvestment Other Restricted Fees Grants G.O. Bond/Secondary Property Tax Total Special Revenue and Debt Service Funds Enterprise Funds Aviation Convention Center Water System Wastewater Solid Waste Total Enterprise Funds Total Operating Revenues $ Actual Year-to-Date 2013-14 2012-13 3,104,578 - 24 - $ $ Citywide Operating Expenditures As of June 30 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2013-14 2012-13 Budget 2013-14 $ Criminal Justice General Funds Other Funds Total Criminal Justice 106,532 15,449 121,981 $ 100,400 $ 13,835 114,235 102,211 11,804 114,015 34,298 12,573 46,871 32,659 8,038 40,697 33,453 7,837 41,290 Public Safety General Funds Other Funds Total Public Safety 713,122 162,719 875,841 699,796 142,474 842,270 684,609 157,779 842,388 Transportation General Funds Other Funds Total Transportation 41,617 597,797 639,414 29,713 543,312 573,025 38,161 544,220 582,381 Community Development General Funds Other Funds Total Community Development 22,551 211,612 234,163 20,210 174,332 194,542 19,927 189,476 209,403 Community Enrichment General Funds Other Funds Total Community Enrichment 151,502 138,444 289,946 143,665 128,661 272,326 141,209 131,901 273,110 Environmental Services General Funds Other Funds Total Environmental Services 17,538 609,921 627,459 13,748 563,370 577,118 15,353 548,698 564,051 55,155 55,155 100,524 100,524 137,208 137,208 2,442 523,371 525,813 1,911 337,450 339,361 3,169 356,850 360,019 Debt Service General Funds Other Funds Total Debt Service Capital Improvement General Funds Other Funds Total Capital Improvement Contingencies General Funds Other Funds Total Contingencies Total Operating General Funds Other Funds Total Operating Budget 38,313 47,550 85,863 $ 1,127,915 2,374,591 3,502,506 - 25 - - $ 1,042,102 2,011,996 3,054,098 $ 1,038,092 2,085,773 3,123,865 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 June 30 2014 2013 Budget Estimate 2013-14 Source Actual Year-to-Date 2013-14 2012-13 General Funds $ 34,897,740 83,478 $ 38,243,290 66,033 Local Taxes: Sales Taxes Privilege License Fees $ 442,309,000 2,363,000 $ 418,126,185 2,483,184 $ 410,776,744 2,352,358 34,981,218 38,309,323 Total Local Taxes 444,672,000 420,609,369 413,129,102 11,349,914 13,449,465 4,777,914 10,598,787 12,305,684 4,834,359 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 127,448,000 160,852,000 51,150,000 127,005,277 161,579,859 51,689,052 118,729,642 147,668,202 48,369,596 29,577,293 27,738,830 339,450,000 340,274,188 314,767,440 16,302,502 17,508,676 142,849,000 143,930,555 132,100,924 Total State Shared Taxes Primary Property Tax 286,638 256,342 Licenses and Permits 2,830,000 2,774,513 2,703,119 2,430,411 2,265,203 Cable Communications 9,525,232 9,719,744 9,504,804 1,322,516 74,385 1,426,135 81,532 Municipal Court: Fines and Forfeitures Court Default Fee 19,312,290 1,210,000 17,540,364 1,012,526 18,926,604 1,086,436 1,396,901 1,507,667 20,522,290 18,552,890 20,013,040 2,726,541 1,413,910 13,266,040 14,703,265 12,681,707 115,749 95,090 1,586,654 1,558,614 132,704 76,403 561,708 4,418 2,157,180 138,475 646,112 2,839,207 166,443 656,039 2,941,767 3,661,689 221,987 106,162 2,266,160 1,031,000 95,528,233 95,533,327 Total Municipal Court Police Library Fees 1,362,000 1,079,884 1,006,068 Parks and Recreation 7,911,605 8,127,233 8,237,965 Planning and Development 1,058,400 1,250,742 1,249,890 Street Transportation 3,975,000 4,436,711 4,193,511 37,900,000 1,150,000 11,300,885 30,787,469 1,239,497 11,644,722 33,718,579 1,233,417 11,136,011 50,350,885 43,671,688 46,088,007 2,200,000 1,986,746 1,438,981 Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire Interest Other Fees and Service Charges Total General Funds - 26 - 11,816,950 15,049,179 13,830,816 1,051,789,402 1,026,166,707 980,945,374 Citywide Operating Revenue by Source (continued) For the Month Ended June 30 2014 2013 Budget Estimate 2013-14 Source Actual Year-to-Date 2012-13 2013-14 Special Revenue and Debt Service Funds $ 1,741,135 124,082 621,405 4,113 $ 1,734,141 123,938 619,693 (560) Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 2,490,735 2,477,212 5,263,189 1,781,625 (10,064) 5,387,317 1,863,004 (6,891) 7,034,750 7,243,430 2,504,691 2,489,530 Parks and Preserves 390,212 38,568 161,979 (2,784) 12,735 1,832,400 232,817 379,873 (4,066) (153,219) Golf Courses: Fees Coffee Shops Concessions Interest Other 600,710 2,287,805 8,270,052 3,014,300 9,910,090 3,036,704 11,284,352 12,946,794 681,596 1,311,979 (649,800) $ Total Neighborhood Protection Public Safety Enhancement & Expansion: Police Fire Interest/Other Total Public Safety Enhancement & Expansion 21,066,000 1,505,000 7,523,000 145,500 $ 20,407,668 1,457,405 7,288,024 186,458 $ 19,260,245 1,375,803 6,879,016 152,717 30,239,500 29,339,555 27,667,781 63,718,000 21,578,000 (65,000) 62,052,819 21,104,413 (115,515) 59,305,020 20,371,913 (77,737) 85,231,000 83,041,717 79,599,196 30,399,000 29,393,320 27,727,018 5,427,300 271,360 2,331,200 (81,040) 107,431 5,831,227 296,166 2,334,247 (57,186) 522,795 5,663,057 298,958 2,331,402 (71,564) 115,685 8,056,251 8,927,249 8,337,538 120,380,000 50,791,438 111,067,552 68,618,363 110,059,257 53,141,173 171,171,438 179,685,915 163,200,430 Court Awards 15,376,764 12,849,175 9,827,198 3,980,085 Planning and Development 36,720,200 40,550,427 40,432,574 1,112,899 1,327,609 Capital Construction 17,226,000 15,159,012 16,452,222 1,326,199 24,078 1,197,421 54,079 Sports Facilities: Sales Taxes Interest/Other 15,564,000 265,000 15,987,560 281,415 14,893,104 370,542 1,350,277 1,251,500 15,829,000 16,268,975 15,263,646 Total Golf Courses Transit 2000: Sales Taxes Interest/Other Total Transit 2000 Total Sports Facilities - 27 - Citywide Operating Revenue by Source (continued) For the Month Ended June 30 2014 2013 Budget Estimate 2013-14 Source Actual Year-to-Date 2012-13 2013-14 Special Revenue and Debt Service Funds (Cont'd) $ Highway User Revenue: Highway User Revenue Interest Other 9,778,053 26,328 11,068 9,680,081 15,815 12,167 9,815,449 9,708,063 1,906,854 1,869,193 519,319 36,272 2,680,358 2,483,715 Other Restricted Fees 535,771 9,289,164 46,435 Grants: Public Housing: Rentals Grants Other 641,354 5,368,322 828,814 $ 6,838,490 9,871,370 8,658,722 9,909,462 (993,992) 9,585,437 11,161,612 49,761,574 (1,699,844) 16,085,197 100,150,000 250,000 200,000 102,008,948 245,366 208,321 98,804,322 177,086 50,822 100,600,000 102,462,635 99,032,230 Regional Transit Revenues 41,867,049 40,930,689 23,766,976 Community Reinvestment 4,861,901 5,219,133 4,844,568 31,368,544 32,163,173 37,266,837 Total Highway User Revenue $ Total Public Housing Other: Human Resources Federal Transit Administration Community Development Other 6,952,965 73,208,080 5,269,398 $ 6,681,599 69,990,033 4,309,750 $ 6,951,034 69,619,374 2,411,375 85,430,443 80,981,382 78,981,783 42,441,013 59,918,966 33,269,864 67,493,613 38,884,092 39,393,155 16,905,390 60,257,120 42,337,211 60,070,266 15,407,267 97,748,222 27,159,629 75,308,539 Total Other 203,123,456 155,439,757 215,562,966 33,998,119 85,179,909 Total Grants 288,553,899 236,421,139 294,544,749 3,947,544 2,347,321 8,167,726 2,913,108 35,442,800 5,138,000 35,204,116 4,683,373 62,012,119 4,844,549 6,294,865 11,080,834 81,625,174 145,673,930 G.O. Bond/Secondary Property Tax Secondary Property Tax Interest Total G.O. Bond/Secondary Property Tax Total Special Revenue and Debt Service Funds 40,580,800 39,887,489 66,856,668 918,081,346 872,299,603 914,819,631 123,050,000 177,863,000 450,000 3,341,000 1,679,200 2,960,000 - 103,149,009 215,320,239 902,751 4,514,768 2,116,377 3,017,030 940,508 98,954,384 199,996,225 467,320 1,930,845 1,850,248 3,065,097 41,434,147 309,343,200 329,960,682 347,698,266 Enterprise Funds AVIATION: 8,292,765 16,757,374 50,966 576,050 178,390 308,058 1,036,243 8,476,150 14,111,376 11,833 347,876 211,526 366,578 4,937,723 27,199,846 28,463,062 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 June 30 2014 2013 Budget Estimate 2013-14 Source Actual Year-to-Date 2013-14 2012-13 Enterprise Funds (Cont'd) CONVENTION CENTER: 4,174,905 2,073,557 22,120 3,626,765 2,001,308 19,549 6,270,582 5,647,622 Excise Taxes Operating Revenue Interest Total Convention Center 43,924,000 16,280,625 338,980 44,311,409 16,485,988 232,072 40,828,004 18,543,596 250,622 60,543,605 61,029,469 59,622,222 WATER SYSTEM: $ 42,443,362 $ 463,176 (346,777) 705,335 262,170 264,905 (1,229,397) 40,243,700 538,439 (219,047) (938,492) 96,960 173,753 (2,215,196) 42,562,774 37,680,117 15,318,593 1,609,558 261,060 158,389 (438,401) 15,473,892 1,516,425 98,760 125,552 (2,576,736) 16,909,199 14,637,893 Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System 385,949,000 6,000,000 3,500,000 6,666,000 2,600,000 2,925,000 113,000 $ 376,304,565 5,725,818 3,399,779 5,999,176 2,478,090 2,289,025 2,602,365 $ 373,353,881 5,965,823 3,564,617 6,610,261 2,333,400 1,867,926 31,629,873 407,753,000 398,798,818 425,325,781 179,686,000 16,004,000 2,500,000 1,370,000 11,752,000 181,147,765 18,779,557 2,370,780 1,354,852 10,727,137 180,358,181 18,340,320 2,281,560 1,331,678 15,356,798 211,312,000 214,380,091 217,668,537 125,935,000 6,932,000 310,000 12,578,700 127,089,235 7,705,427 392,624 11,260,798 125,660,240 7,314,554 340,203 10,025,587 145,755,700 146,448,084 143,340,584 1,134,707,505 1,150,617,144 1,193,655,390 WASTEWATER: Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: $ 10,673,441 1,257,758 38,916 (344,054) 10,559,480 1,137,443 25,108 (356,029) 11,626,061 11,366,002 104,568,462 97,794,696 281,721,869 $ 339,001,953 Collection Fees Landfill Fees Interest Other Total Solid Waste Total Enterprise Funds Total Operating Revenues $ - 29 - 3,104,578,253 $ 3,049,083,454 $ 3,089,420,395 Citywide Operating Expenditures by Program For the Month Ended June 30 2014 2013 Budget Estimate 2013-14 Program Actual Year-to-Date 2013-14 2012-13 2013-14 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt General Government $ 109,669 $ 299,206 270,015 3,840,751 48,124 172,601 206,639 1,324,925 118,321 525,641 917 580,047 11,605 (18,805) (7,884) 1,567,938 (113,294) 122,284 274,806 255,486 3,681,862 75,074 149,394 220,802 1,547,991 21,712 340,949 35,944 902,271 (39,502) 12,535 (39,946) 1,761,611 (54,710) 8,936,416 9,268,563 Mayor City Council City Manager Information Technology Services Government Relations Public Information Equal Opportunity Law City Auditor City Clerk Elections Human Resources Retirement Systems Phoenix Employment Relations Board Budget and Research Finance Regional Wireless Cooperative Total General Government $ 1,755,285 3,589,459 2,766,001 35,059,291 1,304,646 2,760,360 2,796,854 20,550,337 2,389,388 5,694,435 809,263 11,510,338 99,285 3,053,828 21,961,636 5,880,637 $ 1,627,593 3,344,608 2,481,499 34,037,130 1,094,076 2,525,443 2,586,007 19,831,701 2,293,787 4,337,881 735,005 10,405,764 58,497 2,995,749 21,452,657 4,428,090 $ 1,668,993 3,226,854 2,160,575 34,437,825 1,303,924 2,760,436 2,640,813 21,006,995 1,949,755 4,699,090 1,174,853 11,121,069 66,456 2,919,891 19,312,418 3,565,014 $ 1,627,593 3,344,608 2,481,499 32,353,153 1,094,076 2,525,443 2,586,007 19,831,701 2,293,787 4,337,881 735,005 9,622,343 58,497 2,995,749 20,357,594 4,428,090 $ 1,683,977 783,421 1,095,063 - 121,981,043 114,235,487 114,014,961 110,673,026 3,562,461 41,968,415 4,902,494 35,909,063 4,787,627 36,524,925 4,765,378 29,677,251 4,787,627 6,231,812 - 46,870,909 40,696,690 41,290,303 34,464,878 6,231,812 577,412,700 297,951,260 476,598 555,423,376 286,383,000 463,285 559,767,460 282,082,260 537,672 550,558,224 283,027,282 463,285 4,865,152 3,355,718 - 875,840,558 842,269,661 842,387,392 834,048,791 8,220,870 Criminal Justice 2,849,581 615,307 2,873,589 502,729 3,464,888 3,376,318 Municipal Court Public Defender Total Criminal Justice Public Safety 49,474,177 24,373,123 28,579 48,010,274 23,866,411 34,960 73,875,879 71,911,645 Police Fire Other Total Public Safety - 30 - Citywide Operating Expenditures by Program (continued) For the Month Ended June 30 2014 2013 Budget Estimate 2013-14 Program Actual Year-to-Date 2013-14 2012-13 2013-14 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Transportation $ 4,838,758 1,008,222 27,465,965 1,638,792 34,951,737 $ 4,468,829 1,216,176 26,300,827 4,730,259 36,716,091 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 62,190,604 11,172,894 305,626,250 260,424,196 $ 56,903,753 11,344,325 275,589,135 229,187,473 $ 55,078,293 11,310,051 273,872,403 242,120,393 $ 56,006,085 11,344,325 223,939,732 188,228,746 $ 897,668 51,649,403 40,958,727 639,413,944 573,024,686 582,381,140 479,518,888 93,505,798 Community Development 2,979,624 6,270,544 4,264,207 2,679,836 2,966,366 5,614,394 4,402,527 3,125,950 Planning and Development Housing Economic Development Neighborhood Services Department 42,236,572 87,145,323 33,963,216 70,818,138 37,948,828 75,912,439 36,165,212 44,515,892 35,912,792 74,729,205 33,385,520 65,375,192 37,948,828 75,842,054 20,693,456 44,515,892 70,385 15,471,756 - 16,194,211 16,109,237 Total Community Development 234,163,249 194,542,371 209,402,709 179,000,230 15,542,141 103,886,009 36,116,557 8,885,423 61,858,418 10,927,120 62,723,393 3,919,060 1,630,435 98,071,110 34,080,198 8,702,720 58,116,229 10,925,727 57,386,563 3,646,468 1,396,773 94,512,562 34,265,844 8,648,634 57,508,587 11,849,480 61,719,039 3,485,436 1,120,428 96,170,980 34,080,198 8,702,720 39,531,505 57,088,434 3,646,468 1,396,773 1,900,130 18,584,724 10,925,727 298,129 - 289,946,415 272,325,788 273,110,010 240,617,078 31,708,710 Community Enrichment 11,190,201 2,896,172 70,831 4,197,738 910,103 3,930,360 592,229 143,171 9,031,149 2,564,849 1,801,224 4,764,015 984,149 3,666,084 513,624 54,018 23,930,805 23,379,112 Parks and Recreation Library Golf Convention Center Sports and Cultural Facilities Human Services Public Parking Facilities Other Total Community Enrichment - 31 - Citywide Operating Expenditures by Program For the Month Ended June 30 2014 2013 Budget Estimate 2013-14 Program 2013-14 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2013-14 2012-13 Environmental Services $ 26,480,752 12,100,633 11,152,505 2,038,926 172,676 $ 51,945,492 24,419,887 12,515,625 9,676,459 1,452,408 137,078 48,201,457 Water System Wastewater Solid Waste Management Public Works Environmental Programs $ Total Environmental Services 385,100,042 76,206,190 141,801,767 22,863,808 1,486,777 $ 293,430,640 139,951,286 124,013,175 18,677,703 1,045,054 $ 286,353,301 134,056,461 121,706,878 20,722,647 1,211,868 $ 179,271,037 72,149,149 111,039,168 13,515,606 1,045,054 $ 377,020,014 114,159,603 67,802,137 12,974,007 5,162,097 - 627,458,584 577,117,858 564,051,155 200,097,844 866,210 9,110,990 8,426,500 337,530 4,614,170 690,670 4,883,650 628,460 7,202,830 7,785,230 1,173,410 14,496,710 50,200 7,264,190 1,279,120 2,866,431 (45,635,390) 938,600 15,486,000 5,480,820 6,810 7,201,708 859,462 9,057,901 8,426,496 337,534 4,605,380 688,937 4,871,739 628,464 7,185,748 7,769,451 1,170,898 14,439,809 50,192 7,246,418 1,278,930 2,864,969 2,247 937,629 15,441,729 5,460,546 6,680 7,192,663 1,104,616 11,637,099 13,336,743 271,437 4,678,693 386,246 3,157,166 629,657 4,555,461 6,790,858 505,701 14,718,823 50,200 6,193,165 1,290,891 6,063,656 2,957 465,638 26,397,274 27,408,005 225,212 7,338,326 - 859,462 9,057,901 8,426,496 46,116,673 337,534 4,605,380 688,937 4,871,739 628,464 7,185,748 7,769,451 1,170,898 14,439,809 50,192 7,246,418 1,278,930 2,864,969 (46,114,426) 937,629 15,441,729 5,460,546 6,680 7,192,663 General Obligation Debt Service 65,441 706,174 702,208 28,128 375,739 55,827 395,071 52,372 583,176 633,011 95,272 1,155,210 4,175 587,589 106,414 238,523 77,727 1,246,671 437,307 435 594,394 92,051 965,221 1,106,905 22,294 384,513 32,139 259,470 52,372 373,150 565,379 41,951 1,217,886 4,183 510,765 106,592 505,279 750 38,173 2,194,173 2,281,658 18,767 611,452 8,140,864 11,385,123 Total Debt Service 55,154,849 100,523,822 137,207,824 - 100,523,822 87,772,548 69,560,577 Capital Improvement 525,813,358 339,361,257 360,019,181 - 339,361,257 $ 309,212,840 $ 289,908,123 Aviation 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 Contingencies Total Operating Budget 85,863,000 $ - 3,502,505,909 $ - 32 - 3,054,097,620 $ 3,123,864,675 $ 2,255,342,905 $ 798,754,715 Capital Expenditures and Encumbrances 2013-14 Program Budget 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 2012-13 Actual Yearto-Date Actual Yearto-Date $ 953,939 $ 10,687,984 4,674,297 12,715,087 4,963,402 7,548,022 1,618,109 47,238,059 2,471,825 11,675,314 2,034,035 7,713,141 58,973,395 18,666,428 107,343,452 11,146,109 220,763,460 790,302 $ 3,406,052 4,758,859 5,385,536 7,352,376 4,499,720 188,725 17,897,890 2,102,914 10,789,790 660,604 1,465,534 19,372,438 14,394,899 22,411,008 5,330,471 142,305,365 8,939,610 2,954,120 7,236,663 20,826,325 11,387,086 1,375,844 30,470,178 1,910,474 780,308 328,408 3,256,590 47,351,100 11,901,555 90,689,651 81,190,600 Total Capital Improvement Program $ 531,186,058 $ 263,112,483 $ 320,598,512 Enterprise Aviation Phoenix Convention Center Solid Waste Disposal Wastewater Water System Enterprise Subtotal Total Capital Budget Program $ $ 315,148,316 26,370,374 23,655,539 121,032,175 182,968,247 669,174,651 $ 1,200,360,709 $ $ 180,570,621 23,189,168 8,063,281 58,012,444 129,080,488 398,916,002 $ 662,028,485 $ $ 168,639,365 21,829,982 8,604,773 109,914,315 110,332,519 419,320,954 $ 739,919,466 2013-14 Year-to-Date Capital Amounts From Operating Funds From Capital Funds Budget Actual Budget $ $ $ 134,803 $ 10,425,140 4,674,297 4,915,687 1,606,370 87,000 4,759 24,852,045 919,925 200,000 3,836,994 33,873,798 8,500,000 79,481,910 82,078,014 207,595 3,221,988 4,758,859 4,250,319 4,072,628 223 11,401,597 82,000 764,106 114,078 983,197 15,229,842 6,330,160 18,236,571 72,898,309 255,590,742 $ 142,551,472 $ 34,834,765 5,921,374 15,992,172 58,073,538 155,400,767 270,222,616 $ 525,813,358 - 33 - $ $ 21,577,511 2,740,168 2,989,737 31,951,227 137,551,142 196,809,785 $ 339,361,257 $ $ $ 819,136 $ 262,844 7,799,400 3,357,032 7,461,022 1,613,350 22,386,014 2,471,825 10,755,389 1,834,035 3,876,147 25,099,597 10,166,428 27,861,542 11,146,109 138,685,446 582,707 184,064 1,135,217 3,279,748 4,499,497 188,725 6,496,293 2,020,914 10,025,684 546,526 482,337 4,142,596 8,064,739 4,174,437 5,330,471 69,407,056 275,595,316 $ 120,561,011 $ 280,313,551 20,449,000 7,663,367 62,958,637 27,567,480 398,952,035 $ 674,547,351 Unencumbered Budget Actual $ $ 163,637 7,281,932 (84,562) 7,329,551 (2,388,974) 3,048,302 1,429,384 29,340,169 368,911 885,524 1,373,431 6,247,607 39,600,957 4,271,529 84,932,444 5,815,638 78,458,095 $ 268,073,575 $ 158,993,110 20,449,000 5,073,544 26,061,217 (8,470,654) 202,106,217 $ $ 134,577,695 3,181,206 15,592,258 63,019,731 53,887,759 270,258,649 $ 322,667,228 $ 538,332,224 Bonds Authorized and Sold As of June 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 $ - 34 - 2,689,750 $ 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 09-10 Actuals 40,000 10-11 Actuals 35,000 11-12 Actuals 30,000 12-13 Actuals 25,000 13-14 Actuals 20,000 13-14 budget 15,000 July FY 09-10 10-11 11-12 12-13 13-14 13-14 budget July 17,876 32,543 33,875 34,005 36,360 36,708 Aug Aug 32,064 32,288 34,239 34,276 35,589 36,847 Sept Sept 30,205 33,087 33,371 34,254 35,873 36,813 Oct Nov Oct 26,205 32,143 34,746 33,337 35,068 36,636 Dec Nov 30,500 32,952 31,854 33,430 34,363 35,908 Jan Dec 32,382 31,456 31,745 32,504 32,474 34,984 Jan 29,948 36,278 36,385 36,527 40,116 39,913 Feb Feb 27,160 30,658 31,532 32,542 32,084 34,628 Note: City of Phoenix revenue is budgeted on an annual basis. 2013-14 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2010-11 through 2012-13 actual expenditures. FY 2009-10 expenditures were excluded from the calculation due to a significant outlier in July 2009. Return to Summary Page - A1 - Mar Mar 26,456 31,302 32,549 32,047 32,147 35,054 Apr Apr 34,963 34,169 34,955 34,911 35,988 38,028 May May 26,601 33,040 32,521 34,699 33,165 36,648 June June 36,787 32,462 39,115 38,243 34,898 40,143 YTD thru June 351,146 392,380 406,888 410,777 418,126 442,310 State Sales Tax (Dollars in Thousands) State Sales Tax 13,000 12,000 09-10 Actuals 11,000 10-11 Actuals 10,000 11-12 Actuals 9,000 8,000 12-13 Actuals 7,000 13-14 Actuals 6,000 13-14 budget 5,000 July FY 09-10 10-11 11-12 12-13 13-14 YTD 13-14 budget Aug July 11,157 9,769 8,852 9,907 10,309 10,553 Sept Aug 8,370 8,262 8,683 8,755 9,616 9,507 Sept 8,954 8,684 8,993 9,240 10,012 9,957 Oct Oct 8,785 8,642 9,177 9,229 9,923 10,006 Nov Nov 8,530 8,687 9,083 9,456 9,673 10,071 Dec Jan Dec 8,883 8,947 9,055 9,462 10,296 10,160 Feb Jan 11,040 10,757 11,290 11,986 12,744 12,589 Mar Feb 8,164 9,258 8,572 9,270 10,430 10,025 Note: City of Phoenix revenue is budgeted on an annual basis. 2013-14 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2010-11 through 2012-13 actual expenditures. FY 2009-10 expenditures were excluded from the calculation due to a significant outlier in June 2010. Return to Summary Page - A2 - Apr Mar 8,625 9,134 9,554 9,887 10,506 10,570 May Apr 10,070 10,448 9,744 11,037 11,285 11,552 June May 8,718 10,048 9,743 9,902 10,863 10,984 June 5,623 9,150 11,272 10,599 11,350 11,475 YTD thru June 106,917 111,787 114,017 118,730 127,005 127,449 Vehicle License Tax (Dollars in Thousands) Vehicle License Tax 5,500 09-10 Actuals 5,000 4,500 10-11 Actuals 4,000 11-12 Actuals 3,500 12-13 Actuals 3,000 13-14 Actuals 2,500 Budget 13-14 2,000 July FY 09-10 10-11 11-12 12-13 13-14 Budget 13-14 Aug July 4,920 5,217 4,482 4,493 4,752 5,077 Sept Aug 5,344 4,141 3,698 3,982 4,663 4,559 Oct Sept 3,336 3,722 3,842 3,852 3,992 3,918 Nov Oct 4,425 4,018 3,669 3,535 3,912 4,156 Dec Nov 3,702 3,224 3,089 3,582 3,958 3,612 Jan Feb Dec 3,649 4,095 3,781 3,993 3,872 4,122 Jan 4,145 3,894 3,645 3,572 3,936 4,052 Mar Feb 3,437 3,372 3,620 4,141 4,799 3,870 Note: City of Phoenix revenue is budgeted on an annual basis. 2013-14 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2009-10 through 2012-13 actual expenditures. Return to Summary Page - A3 - Apr Mar 4,742 4,820 4,860 4,623 4,559 5,059 May Apr 3,912 3,854 3,482 3,676 3,826 3,964 June May 4,295 4,091 3,796 4,088 4,643 4,321 June 3,594 3,851 4,435 4,834 4,778 4,440 YTD thru June 49,500 48,299 46,400 48,370 51,689 51,150 Regional Transit Revenues (Dollars in Thousands) Regional Transit Revenues 20,000 09-10 Actuals 15,000 10-11 Actuals 11-12 Actuals 10,000 12-13 Actuals 5,000 13-14 Actuals Budget 13-14 July FY 09-10 10-11 11-12 12-13 13-14 Budget 13-14 Aug July 15,852 1,256 (7) 2,410 2,097 1,681 Sept Aug (36) 2,067 1,931 2,077 2,106 2,791 Oct Sept 13 1,140 1,936 2,077 2,097 2,367 Nov Oct 2,564 1,936 2,953 2,077 1,460 3,201 Dec Nov 7 2,661 1,043 2,077 2,600 2,656 Jan Dec 14,098 11,011 1,931 1,197 2,096 6,496 Feb Jan 7,255 2,196 1,931 2,113 2,575 2,867 Mar Feb (325) 12 1,931 2,076 9,865 1,847 Note: City of Phoenix revenue is budgeted on an annual basis. 2013-14 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2010-11 through 2012-13 actual expenditures. FY 2009-10 expenditures were excluded from the calculation due to multiple months with significant outliers. Return to Summary Page - A4 - Apr Mar 56 12 1,931 2,075 1,396 1,846 May Apr 2,208 39 2,208 1,859 3,576 1,886 June May 74 12 5,466 1,859 9,156 3,371 June 16,328 19,833 1,931 1,869 1,907 10,858 YTD Thru June 58,096 42,175 25,186 23,767 40,931 41,867 Aviation Revenues (Dollars in Thousands) Aviation Operating Revenues 40,000 09-10 Actuals 35,000 10-11 Actuals 30,000 11-12 Actuals 25,000 12-13 Actuals 20,000 13-14 Actuals 15,000 Budget 13-14 10,000 July FY 09-10 10-11 11-12 12-13 13-14 Budget 13-14 Aug July 24,629 26,581 27,628 28,080 31,036 24,975 Sept Aug 22,881 26,388 24,404 26,231 22,760 22,855 Oct Sept 24,894 26,824 27,570 28,144 26,677 25,060 Nov Oct 24,298 38,540 26,280 30,124 26,505 25,089 Dec Nov 24,558 13,697 27,849 26,471 26,222 24,522 Jan Dec 27,072 27,977 29,526 28,146 27,171 26,345 Feb Jan 23,587 25,681 27,146 27,054 26,659 24,183 Mar Feb 24,594 28,359 27,028 27,884 26,561 24,717 Note: City of Phoenix revenue is budgeted on an annual basis. 2013-14 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2009-10, 2011-12, and 2012-13 actual expenditures. FY 2010-11 expenditures were excluded from the calculation due to significant outliers in October and November 2010. Return to Summary Page - A5 - Apr Mar 27,973 28,876 28,470 31,100 28,352 27,215 May Apr 29,635 30,528 33,111 34,980 31,467 30,381 June May 26,896 27,087 30,194 31,020 29,350 27,392 June 27,054 32,096 30,075 28,463 27,200 26,609 YTD thru June 308,072 332,635 339,280 347,698 329,961 309,343 Water System Revenues (Dollars in Thousands) Water System Operating Revenues 80,000 75,000 09-10 Actuals 70,000 65,000 60,000 55,000 10-11 Actuals 50,000 11-12 Actuals 45,000 40,000 35,000 12-13 Actuals 30,000 13-14 Actuals 25,000 20,000 15,000 10,000 Budget 13-14 July FY 09-10 10-11 11-12 12-13 13-14 Budget 13-14 Aug July 42,332 47,691 48,584 79,417 49,017 51,867 Sept Aug 41,933 40,774 44,616 42,419 42,137 47,644 Oct Sept 40,206 39,640 47,230 42,446 41,144 47,552 Nov Oct 35,368 30,588 35,860 34,197 34,917 38,100 Dec Nov 21,267 26,585 30,215 36,338 34,774 29,213 Jan Dec 24,487 21,157 20,946 25,523 22,327 24,918 Feb Jan 16,423 17,482 19,694 21,738 22,872 20,057 Mar Feb 15,317 16,371 18,282 18,711 21,185 18,699 Note: City of Phoenix revenue is budgeted on an annual basis. 2013-14 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2009-10 through FY 2011-12 actual expenditures. FY 2012-13 expenditures were excluded from the calculation due to a significant outlier in July 2012. Return to Summary Page - A6 - Apr Mar 15,957 17,629 20,726 21,386 21,993 20,324 May Apr 24,693 28,414 27,648 30,809 29,578 30,219 June May 27,969 29,903 32,635 34,663 36,292 33,868 June 40,252 38,411 42,378 37,680 42,563 45,294 YTD thru June 346,204 354,644 388,816 425,326 398,799 407,755 Wastewater Revenues (Dollars in Thousands) Wastewater Operating Revenues 27,000 09-10 Actuals 22,000 10-11 Actuals 17,000 11-12 Actuals 12,000 12-13 Actuals 13-14 Actuals 7,000 Budget 13-14 2,000 July FY 09-10 10-11 11-12 12-13 13-14 Budget 13-14 Aug July 18,122 18,867 18,754 17,547 17,634 16,893 Sept Aug 19,401 19,831 19,339 18,057 18,252 17,630 Oct Sept 18,594 20,379 19,500 17,930 18,224 17,390 Nov Oct 21,058 18,860 19,161 17,684 17,798 17,973 Dec Nov 16,469 18,540 26,283 20,958 20,452 19,776 Jan Feb Dec 17,830 27,453 18,864 17,744 17,763 16,898 Jan 18,340 19,363 26,967 25,337 17,618 21,928 Mar Feb 18,338 23,589 16,038 17,663 18,058 16,153 Note: City of Phoenix revenue is budgeted on an annual basis. 2013-14 monthly budget amounts are based on an allocation of the annual budget. Monthly budget amounts are calculated based on an allocation of FY 2009-10, 2011-12, and 2012-13 actual expenditures. FY 2010-11 expenditures were excluded from the calculation due to a significant outlier in June 2011. Return to Summary Page - A7 - Apr Mar 18,038 18,759 18,552 14,263 14,986 15,785 May Apr 19,619 19,435 18,938 17,865 18,386 17,514 June May 26,066 18,776 19,734 17,982 18,299 19,798 June 18,374 3,789 10,717 14,638 16,909 13,574 YTD thru June 230,249 227,641 232,845 217,669 214,380 211,312