City of Phoenix, Arizona Monthly Financial Report July 2012 Monthly Financial Report – July 2012 Executive Summary Budget • The budget amounts in this report represent the official adopted budget, as approved by the City Council, for fiscal year 2012-13. Revenues • Local Taxes and the City’s portion of State Shared Taxes comprise the major portion, approximately 74 percent, of estimated General Fund revenues. At the end of July 2012, local sales revenues were comparable to the prior July and State Shared Taxes were $3.2 million higher compared to the prior July. (see pages 2-3). Expenditures • General Fund Expenditures overall for the month of July 2012 are $4.8 million more than they were during July of the prior fiscal year. (see pages 3-4) Individual specific trends are difficult to determine at this time as it is still early in the fiscal year. -1- General Funds Summary Summary General Funds As of July 31 (dollars in thousands) Budget Estimate 2012-13 Actual Year-to-Date 2012-13 2011-12 % of Year-to-Date Estimate Actual 2012-13 2011-12 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 $ $ 432,690 2,680 34,005 $ 48 33,875 44 119,646 147,655 47,000 131,921 2,897 9,386 9,907 12,306 4,493 (936) 132 - 8,852 10,168 4,482 (1,145) 152 (140) 8.3 8.3 9.6 (0.7) 4.6 - 7.8 8.3 9.7 (0.9) 5.2 (1.5) 22,009 1,150 12,317 1,313 7,889 894 3,960 1,724 73 628 93 420 87 343 1,813 69 695 100 351 52 593 7.8 6.3 5.1 7.1 5.3 9.7 8.7 8.5 5.7 4.5 7.3 5.2 4.9 11.3 41,100 12,878 870 12,752 3,262 184 135 1,088 3,022 1,438 82 844 7.9 1.4 15.5 8.5 8.4 11.9 10.2 5.6 1,011,007 $ $ 67,992 $ -2- 65,347 7.9 % 1.8 6.7 % 8.3 % 1.9 6.9 % Summary General Funds As of July 31 (dollars in thousands) Budget Estimate 2012-13 Actual Year-to-Date 2012-13 2011-12 % of Year-to-Date Estimate Actual 2012-13 2011-12 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 $ 131 $ 257 233 2,564 200 189 1,848 464 239 821 360 1,441 439 9,186 92 276 218 1,733 216 179 1,568 595 288 749 340 1,353 626 8,233 7.7 % 7.0 10.1 7.3 8.2 7.7 9.6 19.6 4.6 7.8 12.0 8.2 20.0 8.5 6.4 % 8.7 11.9 5.8 9.3 8.3 8.6 29.8 6.3 7.4 11.8 8.1 18.5 8.4 30,422 4,780 35,202 3,093 410 3,503 3,043 364 3,407 10.2 8.6 10.0 10.6 7.7 10.2 450,336 244,149 16 694,501 39,854 22,245 62,099 40,612 19,455 60,067 8.8 9.1 8.9 9.6 8.8 27.8 9.3 Transportation Street Transportation Public Transit Total Transportation 23,904 19,559 43,463 5,611 1,685 7,296 5,095 1,540 6,635 23.5 8.6 16.8 24.9 8.2 16.9 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 4,799 11,819 4,987 54 21,659 353 903 441 4 1,701 376 846 385 4 1,611 7.4 7.6 8.8 7.4 7.9 8.7 7.9 8.9 8.3 8.3 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 89,909 36,051 18,260 2,485 146,705 9,389 2,298 2,380 405 14,472 8,560 2,102 2,464 148 13,274 10.4 6.4 13.0 16.3 9.9 9.6 6.5 15.3 8.5 9.5 Environmental Services Public Works Environmental Programs Total Environmental Services 16,136 987 17,123 1,190 160 1,350 1,350 89 1,439 7.4 16.2 7.9 9.0 11.8 9.2 38 175 0.7 7.6 - - - 8.9 % 9.5 % Criminal Justice Municipal Court Public Defender Total Criminal Justice Public Safety Police Fire Others Total Public Safety Capital Improvement $ 5,698 Contingencies Total Expenditures and Encumbrances 1,692 3,646 2,306 35,299 2,438 2,446 19,348 2,367 5,156 10,511 3,007 17,603 2,192 108,011 42,658 $ 1,115,020 $ -3- 99,645 $ 94,841 Citywide Summary Comparison to Prior Year Revenues YEAR-TO-DATE REVENUES As of July 31, 2012 3,500 3,000 (millions of dollars) 2,500 2,000 1,500 1,000 500 0 July Aug Sept Oct Nov Dec Current YTD Revenues Jan Feb Mar April May June Prior YTD Revenues Revenues Year-to-date revenues as of July 31 increased by $59,780,253 to $257,447,822 from the $197,667,569 collected during the same period last year, an increase of 30.2%. For the current year, 8.4% of the total estimated revenue has been collected. Of the total revenues received last year, 6.6% had been collected as of July 31. -4- Comparison to Prior Year Operating Expenditures YEAR-TO-DATE OPERATING EXPENDITURES (millions of dollars) As of July 31, 2012 3,200 3,100 3,000 2,900 2,800 2,700 2,600 2,500 2,400 2,300 2,200 2,100 2,000 1,900 1,800 1,700 1,600 1,500 1,400 1,300 1,200 1,100 1,000 900 800 700 600 500 400 300 200 100 0 July Aug Sept Oct Nov Dec Current YTD Expenditures Jan Feb Mar April May June Prior YTD Expenditures Operating Expenditures For the entire City, including enterprise funds such as Water Services and Aviation, year-to-date operating expenditures as of July 31 decreased $47,538,571 to $329,022,564 from the $376,561,135 spent during the same period last year, a decrease of 12.6%. For the current year, 9.2% of the total appropriations has been spent. Of the total actual expenditures for last year, 12.6% had been spent as of July 31. -5- Comparison to Prior Year Capital Expenditures YEAR-TO-DATE CAPITAL EXPENDITURES As of July 31, 2012 800 750 700 650 600 (millions of dollars) 550 500 450 400 350 300 250 200 150 100 50 0 July Aug Sept Oct Nov Dec Current YTD Expenditures Jan Feb Mar April May June Prior YTD Expenditures Capital Expenditures Year-to-date capital expenditures as of July 31 decreased $36,089,107 to $32,679,387 from the $68,768,494 spent during the same period last year, a decrease of 52.5%. For the current year, 2.8% of the total appropriations has been spent. Of the total actual expenditures for last year, 9.2% had been spent as of July 31. -6- Summary Operating Revenues As of July 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 $ 432,690 2,680 $ 33,875 44 9,907 12,306 4,493 (936) 132 1,797 628 93 420 87 343 3,446 135 1,088 8,852 10,168 4,482 (1,145) 152 (140) 1,882 695 100 351 52 593 4,460 82 844 8.3 8.3 9.6 (0.7) 4.6 7.8 5.1 7.1 5.3 9.7 8.7 6.4 15.5 8.5 7.8 8.3 9.7 (0.9) 5.2 (1.5) 8.3 4.5 7.3 5.2 4.9 11.3 9.3 10.2 5.6 67,992 65,347 6.7 6.9 29,009 82,103 29,472 169,411 11,327 33,990 17,405 16,092 102,211 34,489 3,564 26,785 274,742 68,149 2,240 6,702 2,224 13,401 3,374 1,410 1,001 7,978 2,410 1,294 1,628 5,940 (845) 2,162 6,365 2,209 11,718 2,967 1,450 1,017 6,702 (7) 33 2,967 (14,978) (1,449) 7.7 8.2 7.5 7.9 9.9 8.1 6.2 7.8 7.0 36.3 6.1 2.2 (1.2) 8.1 8.3 8.2 7.4 9.1 8.7 6.7 7.4 1.0 8.7 (5.8) (1.5) 898,749 48,757 21,156 5.4 2.4 350,068 60,697 379,108 231,107 144,972 6,205 28,081 4,235 79,417 17,547 11,099 320 27,628 3,870 48,584 18,754 12,014 315 8.0 7.0 20.9 7.6 7.7 5.2 8.1 6.9 12.5 8.1 8.3 5.2 1,172,157 140,699 111,165 12.0 9.5 257,448 $ 197,668 1,011,007 Special Revenue Funds and Debt Service Neighborhood Protection Public Safety Enhancement & Expansion Parks and Preserves 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 Debt Service Total Special Revenue Funds and Debt Service Enterprise Funds Aviation Convention Center Water System Wastewater Solid Waste Golf Courses Total Enterprise Funds $ % of Year-to-Date Estimate Actual 2012-13 2011-12 34,005 $ 48 119,646 147,655 47,000 131,921 2,897 9,386 23,159 12,317 1,313 7,889 894 3,960 53,978 870 12,752 Total General Funds Total Operating Revenues Actual Year-to-Date 2012-13 2011-12 Budget Estimate 2012-13 3,081,913 -7- $ 7.9 % 1.8 8.4 % 8.3 % 1.9 6.6 % Summary Operating Revenues As of July 31, 2012 General Funds Local Taxes General Funds State Shared Taxes 450 300 400 250 300 (millions of dollars) (millions of dollars) 350 250 200 150 200 150 100 100 50 50 0 0 July Aug Sept Oct Nov Dec Jan Feb Mar April May June Current YTD Revenues July Aug Sept Oct Prior YTD Revenues Jan Current YTD Revenues Total General Funds Revenues Feb Mar April May June Prior YTD Revenues Highway User Revenues 1,000 100 900 90 800 80 700 70 (millions of dollars) (millions of dollars) Nov Dec 600 500 400 60 50 40 300 30 200 20 100 10 0 0 July Aug Sept Oct Nov Dec Jan Feb Mar April May June July Aug Sept Oct Nov Dec Jan Feb Mar April May June Current YTD Revenues Current YTD Revenues Prior YTD Revenues -8- Prior YTD Revenues Summary Operating Expenditures and Encumbrances As of July 31 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2012-13 2011-12 Budget 2012-13 $ 9,186 $ (550) 8,636 8,233 (448) 7,785 8.5 % (4.1) 7.1 35,202 13,015 48,217 3,503 744 4,247 3,407 411 3,818 10.0 5.7 8.8 10.2 14.9 10.5 Public Safety General Funds Other Funds Total Public Safety 694,501 175,223 869,724 62,099 13,806 75,905 60,067 12,558 72,625 8.9 7.9 8.7 9.3 8.0 9.0 Transportation General Funds Other Funds Total Transportation 43,463 582,736 626,199 7,296 94,130 101,426 6,635 165,878 172,513 16.8 16.2 16.2 16.9 30.4 29.5 Community Development General Funds Other Funds Total Community Development 21,659 224,492 246,151 1,701 18,020 19,721 1,611 12,685 14,296 7.9 8.0 8.0 8.3 7.3 7.4 Community Enrichment General Funds Other Funds Total Community Enrichment 146,705 157,019 303,724 14,472 17,338 31,810 13,274 15,816 29,090 9.9 11.0 10.5 9.5 12.0 10.7 Environmental Services General Funds Other Funds Total Environmental Services 17,123 616,891 634,014 1,350 65,087 66,437 1,439 42,791 44,230 7.9 10.6 10.5 9.2 8.0 8.0 Debt Service General Funds Other Funds Total Debt Service 106,762 106,762 11,366 11,366 14,076 14,076 10.6 10.6 8.9 8.9 Capital Improvement General Funds Other Funds Total Capital Improvement 5,698 520,573 526,271 38 9,437 9,475 175 17,953 18,128 0.7 1.8 1.8 7.6 6.5 6.5 42,658 47,550 90,208 - - - - Criminal Justice General Funds Other Funds Total Criminal Justice Contingencies General Funds Other Funds Total Contingencies Total Operating General Funds Other Funds Total Operating Budget $ 108,011 13,360 121,371 1,115,020 2,457,621 3,572,641 $ % of Year-to-Date Estimate Actual 2012-13 2011-12 $ 99,645 229,378 329,023 $ -9- 94,841 281,720 376,561 8.9 9.3 9.2 % 8.4 % 7.1 9.5 14.2 12.6 % Summary Operating Expenditures and Encumbrances As of July 31, 2012 Total General Government Total Criminal Justice 120 40 100 80 (millions of dollars) (millions of dollars) 30 60 40 20 10 20 0 0 July Aug Sept Oct July Aug Sept Oct Nov Dec Jan Feb Mar April May June Current YTD Expenditures Nov Dec Jan Current YTD Expenditures Prior YTD Expenditures Feb Mar April May June Prior YTD Expenditures see Note 1 on page 3 for General Government explanation. 850 825 800 775 750 725 700 675 650 625 600 575 550 525 500 475 450 425 400 375 350 325 300 275 250 225 200 175 150 125 100 75 50 25 0 Total Transportation (millions of dollars) (millions of dollars) Total Public Safety July Aug Sept Oct July Aug Sept Oct Nov Dec Jan Feb Mar April May June Current YTD Expenditures 625 600 575 550 525 500 475 450 425 400 375 350 325 300 275 250 225 200 175 150 125 100 75 50 25 0 Nov Dec Jan Feb Mar April May June Current YTD Expenditures Prior YTD Expenditures - 10 - Prior YTD Expenditures Summary Operating Expenditures and Encumbrances As of July 31, 2012 Total Community Development Total Community Enrichment 210 300 200 280 190 180 260 170 240 160 220 140 (millions of dollars) (millions of dollars) 150 130 120 110 100 90 80 70 60 200 180 160 140 120 100 80 50 40 60 30 40 20 20 10 0 0 July Aug Sept Oct Nov Dec Jan Feb Mar April May June July Aug Sept Oct Current YTD Expenditures Current YTD Expenditures Prior YTD Expenditures 580 560 540 520 500 480 460 440 420 400 380 360 340 320 300 280 260 240 220 200 180 160 140 120 100 80 60 40 20 0 Jan Feb Mar April May June Prior YTD Expenditures Total Debt Service 170 160 150 140 130 120 (millions of dollars) (millions of dollars) Total Environmental Services Nov Dec 110 100 90 80 70 60 50 40 30 20 10 0 July Aug Sept Oct Nov Dec Jan Feb Mar April May June July Aug Sept Oct Nov Dec Jan Feb Mar April May June Current YTD Expenditures Current YTD Expenditures Prior YTD Expenditures - 11 - Prior YTD Expenditures Citywide Detail Revenues Revenues For the Month Ended July 31 2012 2011 Budget Estimate 2012-13 Source Actual Year-to-Date 2012-13 2011-12 Percent of Year-to-Date Estimate Actual 2012-13 2011-12 General Funds $ 34,005,443 47,919 $ 33,875,116 44,224 Local Taxes: Sales Taxes Privilege License Fees $ 432,689,754 2,680,000 $ 34,005,443 47,919 $ 33,875,116 44,224 7.9 % 1.8 8.3 % 1.9 34,053,362 33,919,340 Total Local Taxes 435,369,754 34,053,362 33,919,340 7.8 8.3 9,907,000 12,305,684 4,493,000 8,852,000 10,168,121 4,482,000 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 119,646,000 147,655,000 47,000,000 9,907,000 12,305,684 4,493,000 8,852,000 10,168,121 4,482,000 8.3 8.3 9.6 7.8 8.3 9.7 26,705,684 23,502,121 314,301,000 26,705,684 23,502,121 8.5 8.3 (1,145,277) (0.7) (0.9) 4.5 5.2 (936,092) 131,753 (239) (1,145,277) 152,050 (139,522) 1,723,946 73,473 1,812,899 68,743 1,797,419 1,881,642 627,967 694,971 93,549 99,835 419,838 350,579 87,511 51,909 342,953 593,142 3,262,152 40,171 143,974 3,022,579 51,536 1,385,987 3,446,297 4,460,102 134,573 81,733 1,087,700 844,360 67,992,275 65,346,985 Total State Shared Taxes Primary Property Tax 131,921,000 Licenses and Permits 2,897,000 Cable Communications 9,385,916 Municipal Court: Fines and Forfeitures Court Default Fee 22,008,875 1,150,000 1,723,946 73,473 1,812,899 68,743 7.8 6.4 8.5 5.7 23,158,875 1,797,419 1,881,642 7.8 8.3 Total Municipal Court Police (936,092) 131,753 (239) 152,050 (139,522) - (1.5) 12,316,712 627,967 694,971 5.1 4.5 Library Fees 1,313,000 93,549 99,835 7.1 7.3 Parks and Recreation 7,888,825 419,838 350,579 5.3 5.2 Planning and Development Street Transportation Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire Interest Other Fees and Service Charges Total General Funds - 12 - 894,000 87,511 51,909 9.8 4.9 3,959,982 342,953 593,142 8.7 11.3 41,100,000 1,300,000 11,578,248 3,262,152 40,171 143,974 3,022,579 51,536 1,385,987 7.9 3.1 1.2 8.4 3.9 12.9 53,978,248 3,446,297 4,460,102 6.4 9.3 870,000 134,573 81,733 15.5 10.2 12,752,227 1,087,700 844,360 8.5 5.6 1,011,006,539 67,992,275 65,346,985 6.7 6.9 Revenues Revenues For the Month Ended July 31 2011 2012 Budget Estimate 2012-13 Source Percent of Year-to-Date Estimate Actual 2012-13 2011-12 Actual Year-to-Date 2012-13 2011-12 Special Revenue Funds and Debt Service $ 1,542,491 110,178 550,890 36,833 $ 1,513,111 108,080 540,397 399 Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 2,240,392 2,161,987 4,951,038 1,755,273 (4,822) 4,725,358 1,641,322 (1,662) 6,701,489 6,365,018 2,224,011 2,209,130 Parks and Preserves 8,814,236 4,586,781 8,646,348 3,071,976 Transit 2000: Sales Taxes Interest/Other 13,401,017 11,718,324 $ Total Neighborhood Protection Public Safety Enhancement & Expansion: Police Fire Interest/Other Total Public Safety Enhancement & Expansion Total Transit 2000 20,280,000 1,449,000 7,243,000 37,000 $ 1,542,491 110,178 550,890 36,833 $ 1,513,111 108,080 540,397 399 7.6 % 7.6 7.6 99.5 8.1 % 8.2 8.2 0.7 29,009,000 2,240,392 2,161,987 7.7 8.1 61,354,000 20,784,000 (35,000) 4,951,038 1,755,273 (4,822) 4,725,358 1,641,322 (1,662) 8.1 8.4 13.8 8.3 8.4 3.0 82,103,000 6,701,489 6,365,018 8.2 8.3 29,472,000 2,224,011 2,209,130 7.5 8.2 115,886,000 53,524,611 8,814,236 4,586,781 8,646,348 3,071,976 7.6 8.6 8.1 5.9 169,410,611 13,401,017 11,718,324 7.9 7.4 Court Awards 11,326,546 - - 3,374,020 2,967,116 Planning and Development 33,990,000 3,374,020 2,967,116 9.9 9.1 1,410,406 1,450,135 Capital Construction 17,405,000 1,410,406 1,450,135 8.1 8.7 981,759 19,064 962,287 54,703 Sports Facilities: Sales Taxes Interest/Other 15,672,000 420,000 981,759 19,064 962,287 54,703 6.3 4.5 6.6 10.0 1,000,823 1,016,990 Total Sports Facilities 16,092,000 1,000,823 1,016,990 6.2 6.7 7,967,000 10,430 - 6,664,000 34,187 3,729 Highway User Revenue: Highway User Revenue Interest Other 101,561,000 350,000 300,000 7,967,000 10,430 - 6,664,000 34,187 3,729 7.8 3.0 - 7.4 11.8 2.1 7,977,430 6,701,916 102,211,000 7,977,430 6,701,916 7.8 7.4 34,489,645 2,410,345 (7,174) 7.0 - 3,564,321 1,294,302 32,614 36.3 1.0 26,785,065 1,628,330 2,967,513 6.1 8.7 - - Total Highway User Revenue 2,410,345 (7,174) Regional Transit Revenues 1,294,302 32,614 Community Reinvestment 1,628,330 2,967,513 Other Restricted Fees - 13 - - - Revenues Revenues For the Month Ended July 31 2011 2012 Budget Estimate 2012-13 Source Actual Year-to-Date 2012-13 2011-12 Percent of Year-to-Date Estimate Actual 2012-13 2011-12 Special Revenue Funds and Debt Service (Cont'd) $ 493,033 $ 4,269,976 (1,971,900) 2,791,109 445,946 (671,740) (5,128,557) (5,354,351) Grants: Public Housing: Rentals Grants Other $ Total Public Housing Other: Human Resources Federal Transit Administration Community Development Other 6,417,750 74,227,147 4,045,150 $ 493,033 4,269,976 (1,971,900) $ 445,946 (671,740) (5,128,557) 7.7 % 5.8 (48.7) 6.5 % (0.9) (110.2) 84,690,047 2,791,109 (5,354,351) 3.3 (6.5) 42,898,440 19,321,262 34,362,991 93,468,913 (2,056,391) 259 3,994,036 1,210,538 (218,984) 1,847,697 (11,252,746) (4.8) 11.6 1.3 (0.5) 10.6 (12.9) (2,056,391) 259 3,994,036 1,210,538 (218,984) 1,847,697 (11,252,746) 3,148,442 (9,624,033) Total Other 190,051,606 3,148,442 (9,624,033) 1.7 (5.5) 5,939,551 (14,978,384) Total Grants 274,741,653 5,939,551 (14,978,384) 2.2 (5.8) G.O. Bond Debt Service Secondary Property Tax Interest (796,835) (48,540) (1,408,133) (40,766) (845,375) (1,448,899) Total G.O. Bond Debt Service 21,156,286 Total Special Revenue and Debt Service 48,756,741 62,961,000 5,188,000 (796,835) (48,540) (1,408,133) (40,766) (1.3) (0.9) (1.5) (0.8) 68,149,000 (845,375) (1,448,899) (1.2) (1.5) 898,748,841 48,756,741 21,156,286 5.4 2.4 117,260,000 179,146,000 1,620,000 6,110,500 1,623,000 3,109,000 41,200,000 7,876,345 16,775,590 14,603 169,798 138,780 237,387 2,867,863 7,295,432 16,975,303 122,722 180,295 138,523 252,062 2,663,191 6.7 9.4 0.9 2.8 8.6 7.6 7.0 8.0 8.7 14.7 2.4 8.3 8.5 6.5 350,068,500 28,080,366 27,627,528 8.0 8.1 42,987,000 17,356,485 353,222 3,036,150 1,180,693 18,194 2,960,423 865,267 44,487 7.1 6.8 5.2 7.4 5.4 11.9 60,696,707 4,235,037 3,870,177 7.0 6.9 Enterprise Funds AVIATION: 7,876,345 16,775,590 14,603 169,798 138,780 237,387 2,867,863 7,295,432 16,975,303 122,722 180,295 138,523 252,062 2,663,191 28,080,366 27,627,528 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge Total Aviation CONVENTION CENTER: 3,036,150 1,180,693 18,194 2,960,423 865,267 44,487 4,235,037 3,870,177 Excise Taxes Operating Revenue Interest Total Convention Center - 14 - Revenues Revenues For the Month Ended July 31 2011 2012 Budget Estimate 2012-13 Source Actual Year-to-Date 2012-13 2011-12 Percent of Year-to-Date Estimate Actual 2012-13 2011-12 Enterprise Funds (Cont'd) WATER SYSTEM: $ 47,088,334 427,619 959,220 1,437,356 203,280 133,348 29,168,165 $ 46,711,791 444,045 581,405 1,568,690 210,960 213,243 (1,145,970) 79,417,322 48,584,164 14,836,150 1,587,000 212,372 110,073 801,278 16,057,597 1,561,000 206,400 226,504 702,373 17,546,873 18,753,874 Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ Total Water System 356,625,000 6,010,000 3,190,000 7,651,000 2,000,000 2,707,000 925,000 $ 47,088,334 427,619 959,220 1,437,356 203,280 133,348 29,168,165 $ 46,711,791 444,045 581,405 1,568,690 210,960 213,243 (1,145,970) 13.2 % 7.1 30.1 18.8 10.2 4.9 3,153.3 12.7 % 7.8 19.4 24.6 11.6 11.1 (36.9) 379,108,000 79,417,322 48,584,164 20.9 12.5 192,582,000 19,206,000 1,800,000 2,001,000 15,518,000 14,836,150 1,587,000 212,372 110,073 801,278 16,057,597 1,561,000 206,400 226,504 702,373 7.7 8.3 11.8 5.5 5.2 8.3 9.9 12.4 10.2 3.7 231,107,000 17,546,873 18,753,874 7.6 8.1 124,225,000 8,100,000 365,000 12,282,000 10,440,462 568,130 29,403 61,067 10,326,794 650,371 49,020 987,398 8.4 7.0 8.1 0.5 8.3 9.5 9.8 7.8 144,972,000 11,099,062 12,013,583 7.7 8.3 WASTEWATER: Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: 10,440,462 568,130 29,403 61,067 10,326,794 650,371 49,020 987,398 11,099,062 12,013,583 Collection Fees Landfill Fees Interest Other Total Solid Waste GOLF COURSES: $ 181,337 4,365 130,611 (6,775) 10,608 180,924 9,293 125,351 (11,801) 11,205 320,146 314,972 140,698,806 111,164,298 257,447,822 $ 197,667,569 Fees Coffee Shops Concessions Interest Other Total Golf Courses Total Enterprise Funds Total Operating Revenues $ - 15 - 4,118,580 85,060 1,958,500 (126,084) 169,500 181,337 4,365 130,611 (6,775) 10,608 180,924 9,293 125,351 (11,801) 11,205 4.4 5.1 6.7 5.4 6.3 4.6 12.0 6.2 10.3 11.7 6,205,556 320,146 314,972 5.2 5.2 1,172,157,763 140,698,806 111,164,298 12.0 9.5 3,081,913,143 $ 257,447,822 $ 197,667,569 8.4 % 6.6 % Operating Expenditures and Encumbrances For the Month Ended July 31 2012 2011 Budget Estimate 2012-13 Program Actual Year-to-Date 2012-13 2011-12 2012-13 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt General Government $ 130,808 $ 257,303 257,430 2,698,455 76,631 223,640 225,153 1,967,314 463,648 253,546 186,680 925,836 169,872 6,389 359,894 1,674,832 (1,241,847) 8,635,584 92,149 275,889 286,994 1,779,837 285,278 235,424 215,497 1,674,743 594,502 288,962 366,170 801,309 (36,279) 11,118 340,039 1,615,540 (1,041,752) 7,785,420 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,692,427 3,645,603 2,586,241 37,158,029 1,265,498 2,749,291 2,868,513 20,780,565 2,367,167 5,334,050 812,985 11,970,394 113,144 3,006,705 20,557,525 4,462,701 $ 130,808 257,303 257,430 2,698,455 76,631 223,640 225,153 1,967,314 463,648 253,546 186,680 925,836 169,872 6,389 359,894 1,674,832 (1,241,847) $ 92,149 275,889 286,994 1,779,837 285,278 235,424 215,497 1,674,743 594,502 288,962 366,170 801,309 (36,279) 11,118 340,039 1,615,540 (1,041,752) $ 130,808 257,303 257,430 2,593,836 76,631 223,640 225,153 1,967,314 463,648 238,844 186,680 837,344 169,872 6,389 359,894 1,659,452 (1,241,847) $ 104,619 14,702 88,492 15,380 - 121,370,838 8,635,584 7,785,420 8,412,391 223,193 43,437,077 4,780,377 3,836,906 409,648 3,453,676 364,063 3,318,214 409,648 518,692 - 48,217,454 4,246,554 3,817,739 3,727,862 518,692 576,653,193 291,668,478 1,402,594 50,155,679 25,634,831 114,550 49,958,561 22,620,097 46,284 49,693,273 25,430,813 114,550 462,406 204,018 - 869,724,265 75,905,060 72,624,942 75,238,636 666,424 Criminal Justice 3,836,906 409,648 3,453,676 364,063 4,246,554 3,817,739 Municipal Court Public Defender Total Criminal Justice Public Safety 50,155,679 25,634,831 114,550 49,958,561 22,620,097 46,284 75,905,060 72,624,942 Police Fire Other Total Public Safety - 16 - Operating Expenditures and Encumbrances For the Month Ended July 31 2012 2011 Budget Estimate 2012-13 Program Actual Year-to-Date 2012-13 2011-12 2012-13 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Transportation $ 5,449,398 787,441 20,598,028 74,591,369 101,426,236 $ 4,647,191 898,926 17,505,302 149,462,059 172,513,478 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 61,570,685 11,014,510 296,142,386 257,470,874 $ 5,449,398 787,441 20,598,028 74,591,369 $ 4,647,191 898,926 17,505,302 149,462,059 $ 5,407,654 787,441 16,060,355 69,523,549 $ 41,744 4,537,673 5,067,820 626,198,455 101,426,236 172,513,478 91,778,999 9,647,237 Community Development 2,805,272 6,864,174 4,012,813 6,038,459 2,713,984 6,065,289 2,285,795 3,230,592 Planning and Development Housing Economic Development Neighborhood Services Department 39,700,228 82,942,907 43,484,725 80,022,667 2,805,272 6,864,174 4,012,813 6,038,459 2,713,984 6,065,289 2,285,795 3,230,592 2,805,272 6,858,269 2,188,053 6,038,459 5,905 1,824,760 - 19,720,718 14,295,660 Total Community Development 246,150,527 19,720,718 14,295,660 17,890,053 1,830,665 98,145,384 36,552,016 8,181,541 80,892,732 12,330,577 62,617,917 3,775,655 1,227,764 10,146,233 2,353,727 588,401 12,693,069 991,178 4,516,503 156,230 365,116 9,016,000 2,132,609 617,798 10,630,435 663,633 5,721,182 235,177 72,667 9,991,205 2,353,727 588,401 9,477,644 4,493,238 156,230 365,116 155,028 3,215,425 991,178 23,265 - 303,723,586 31,810,457 29,089,501 27,425,561 4,384,896 Community Enrichment 10,146,233 2,353,727 588,401 12,693,069 991,178 4,516,503 156,230 365,116 9,016,000 2,132,609 617,798 10,630,435 663,633 5,721,182 235,177 72,667 31,810,457 29,089,501 Parks and Recreation Library Golf Convention Center Sports and Cultural Facilities Human Services Public Parking Facilities Other Total Community Enrichment - 17 - Operating Expenditures and Encumbrances For the Month Ended July 31 2012 2011 Budget Estimate 2012-13 Program 2012-13 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2012-13 2011-12 Environmental Services $ 38,063,132 10,819,245 15,642,245 1,702,194 210,126 66,436,942 $ 23,460,775 11,589,400 7,571,654 1,458,466 149,352 44,229,647 Water System Wastewater Solid Waste Management Public Works Environmental Programs $ Total Environmental Services 305,978,438 164,779,934 139,297,120 22,491,280 1,467,646 $ 38,063,132 10,819,245 15,642,245 1,702,194 210,126 $ 23,460,775 11,589,400 7,571,654 1,458,466 149,352 $ 14,732,434 5,654,201 14,564,819 1,230,835 210,126 $ 36,392,415 23,330,698 5,165,044 1,077,426 471,359 - 634,014,418 66,436,942 44,229,647 30,044,527 1,104,655 12,586,976 22,011,525 235,585 4,834,585 676,265 4,672,507 845,364 7,485,581 7,623,820 1,058,524 21,334,286 50,200 8,322,272 1,849,762 6,317,402 (59,195,407) 1,847,394 27,545,652 27,987,298 225,213 7,342,210 92,052 974,295 1,115,886 22,945 395,269 32,236 266,725 52,571 386,093 566,430 42,333 1,235,251 4,183 521,429 108,556 414,712 39,433 2,205,373 2,286,509 18,768 585,350 109,588 1,023,152 1,645,182 17,614 342,065 55,980 343,288 56,454 772,733 590,385 77,460 2,091,377 4,183 669,476 129,961 431,277 153,823 2,636,619 2,317,091 25,534 583,198 - 92,052 974,295 1,115,886 22,945 395,269 32,236 266,725 52,571 386,093 566,430 42,333 1,235,251 4,183 521,429 108,556 414,712 39,433 2,205,373 2,286,509 18,768 585,350 General Obligation Debt Service 92,052 974,295 1,115,886 22,945 395,269 32,236 266,725 52,571 386,093 566,430 42,333 1,235,251 4,183 521,429 108,556 414,712 39,433 2,205,373 2,286,509 18,768 585,350 109,588 1,023,152 1,645,182 17,614 342,065 55,980 343,288 56,454 772,733 590,385 77,460 2,091,377 4,183 669,476 129,961 431,277 153,823 2,636,619 2,317,091 25,534 583,198 11,366,399 14,076,440 Total Debt Service 106,761,669 11,366,399 14,076,440 - 11,366,399 9,474,614 18,128,308 Capital Improvement 526,271,454 9,474,614 18,128,308 - 9,474,614 $ 329,022,564 $ 376,561,135 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 90,208,390 Contingencies Total Operating Budget $ 3,572,641,056 - 18 - $ 329,022,564 $ 376,561,135 $ 260,865,917 $ 68,156,647 Capital Expenditures and Encumbrances For the Month Ended July 31 2012 2011 $ $ 7,077,517 $ 12,646,707 282,234 496,497 51,656 6,101,545 32,498,005 535,332 653,136 501,715 126,469 884,177 2,368,035 7,533,986 144,270 3,473,270 49,326 276,699 66,520 54,632 9,380 612,114 316,548 98,416 151,223 61,058 28,719 589,815 1,190,075 2,323 293,152 973,325 6,189 3,624,768 572,436 3,264,710 18,689 8,506,490 925,677 4,381,046 32,679,387 $ 68,768,494 Capital Expenditures and Encumbrances 2012-13 Program Arts and Cultural Facilities Aviation Economic Development Energy Conservation Facilities Management Budget $ Fire Protection Historic Preservation Housing 8,738,512 $ 256,370,044 6,332,221 6,118,898 11,753,000 2011-12 Actual Yearto-Date Actual Yearto-Date 7,077,517 $ 12,646,707 282,234 496,497 51,656 6,101,545 32,498,005 535,332 653,136 501,715 2012-13 Year-to-Date Capital Amounts From Operating Funds From Capital Funds Budget Actual Budget Actual $ 5,963,000 $ 73,637,378 6,309,421 6,118,898 3,335,000 695,143 282,234 496,497 25,581 $ 2,775,512 $ 182,732,666 22,800 8,418,000 7,077,517 11,951,564 26,075 Unencumbered Budget $ 1,660,995 243,723,337 6,049,987 5,622,401 11,701,344 8,030,100 2,797,161 58,996,658 126,469 884,177 2,368,035 7,533,986 144,270 3,473,270 4,759 31,833,284 1,276,855 8,030,100 2,792,402 27,163,374 126,469 884,177 1,091,180 7,903,631 1,912,984 56,628,623 1,928,486 8,542,195 2,344,400 7,218,347 49,326 276,699 66,520 54,632 9,380 612,114 316,548 98,416 7,700,041 281,000 2,695,000 124 1,974 7,785 1,928,486 842,154 2,063,400 4,523,347 49,326 276,575 64,546 46,847 1,879,160 8,265,496 2,277,880 7,163,715 Parks and Mountain Preserves Phoenix Convention Center Police Protection Public Transit 85,424,176 3,119,967 16,729,321 122,393,928 151,223 61,058 28,719 589,815 1,190,075 2,323 293,152 973,325 53,350,342 3,003,572 50,008,360 148,184 3,064 303,783 32,073,834 116,395 16,729,321 72,385,568 3,039 57,994 28,719 286,032 85,272,953 3,058,909 16,700,602 121,804,113 Solid Waste Disposal Street Transportation & Drainage Wastewater Water System 18,906,108 197,733,383 180,110,892 171,152,743 6,189 3,624,768 572,436 3,264,710 18,689 8,506,490 925,677 4,381,046 11,711,000 73,581,360 74,706,298 122,032,741 5,130 2,930,750 460,492 2,837,018 7,195,108 124,152,023 105,404,594 49,120,002 1,059 694,018 111,944 427,692 18,899,919 194,108,615 179,538,456 167,888,033 526,271,454 $ 9,474,614 Human Services Information Technology Libraries Neighborhood Services Total Capital Improvement Program $ 1,174,740,540 $ 32,679,387 $ - 19 - 68,768,494 $ $ 648,469,086 $ 23,204,773 $ 1,142,061,153 Bonds Authorized and Sold As of July 31 (dollars in thousands) Authorized Sold Available 1988 Authorizations General Obligation Bonds Freeway Mitigation, Neighborhood Stabilization, and Slum and Blight Elimination Bonds Fully Issued $ 29,285 884,175 Total General Obligation Bonds 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 Revenue Bonds Bonds Fully Issued Total 1988 Authorizations $ 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 - 20 - $ 2,537,395 $ 152,355