City of Phoenix, Arizona Monthly Financial Report June 2012 Monthly Financial Report – June 2012 Executive Summary Budget • The budget amounts in this report represent the official adopted budget, as approved by the City Council, for fiscal year 2011-12. Revenues • Citywide revenues were $3.0 billion for fiscal year 2011-12 which is a 0.8% decrease from the prior fiscal year and were 0.7% below the estimated budget. • Fiscal year ended 2011-12 General Fund revenues were $948.4 million and were within 0.5% of the budget estimate. However, fiscal year 2011-12 revenues decreased $14.4 million as compared to fiscal year 2010-11. The decrease is due to lower state shared Income Tax revenues of $21.6 million. There were also decreases in Primary Property Tax for $2.9 million, Vehicle License Tax for $1.9 million and Other Fees and Charges for $2.4 million. These decreases were offset by an increase in Local Sales Tax Collections for $14.4 million indicating a slight increase in the economy. (see pages 12-13) Expenditures • Citywide operating expenditures for the fiscal year 2011-12 were 14.1% below the budget estimate and $40.6 million less than fiscal year 2010-11. The decrease is mostly due to decreases in Water, Wastewater and operating funded capital projects. (see pages 20-25) • General Fund expenditures for fiscal year 2011-12 were 7.1% below the budgeted expenditures. This is primarily due to less expenditures in General Government, Public Safety, and Community Enrichment. (see page 3) • However, fiscal year 2011-12 General Fund expenditures were $41 million more than fiscal year 2010-11 expenditures primarily due to a change in the accounting for the Information Technology Services (ITS) Department’s costs (see page 3). There were also increases in Public Safety for $7.1 million and in Community Enrichment for $2.2 million. • Capital expenditures for fiscal year 2011-12 decreased $115.7 million to $745.3 million from $861.0 million. Significant decreases in capital expenditures as compared to last fiscal year include $150.3 million in Water, $34.4 million in Parks and Preserves, $68.2 million in Streets and Transportation, and $23.4 million in Public Transit projects. Decreases in Capital expenditures are partially offset by increases at the Aviation Department (including PHX Sky-Train) of $175.0 million. (see pages 26-27) -1- General Funds Summary Summary General Funds As of June 30 (dollars in thousands) Actual Year-to-Date 2011-12 2010-11 Budget Estimate 2011-12 % of Year-to-Date Estimate Actual 2011-12 2010-11 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 $ $ 417,006 2,465 406,888 $ 2,335 392,380 2,442 110,696 122,065 48,045 126,763 3,270 9,567 114,017 122,012 46,400 128,054 2,946 9,381 111,787 143,647 48,299 130,913 3,092 9,584 103.0 100.0 96.6 101.0 90.1 98.1 100.0 100.0 100.0 100.0 100.0 100.0 20,759 1,100 12,598 1,256 7,103 993 5,124 21,375 1,217 15,614 1,372 6,684 1,057 5,261 21,322 1,160 16,125 1,243 7,496 1,124 5,253 103.0 110.6 123.9 109.2 94.1 106.4 102.7 100.0 100.0 100.0 100.0 100.0 100.0 100.0 36,750 12,462 300 14,890 35,851 12,077 802 15,041 36,837 12,244 334 17,407 97.6 96.9 267.3 101.0 100.0 100.0 100.0 100.0 953,212 $ $ 948,384 $ -2- 962,689 97.6 % 94.7 99.5 % 100.0 % 100.0 100.0 % Summary General Funds As of June 30 (dollars in thousands) Budget Estimate 2011-12 Actual Year-to-Date 2011-12 2010-11 % of Year-to-Date Estimate Actual 2011-12 2010-11 Expenditures and Encumbrances General Government Mayor City Council City Manager Information Technology Services (1) Public Information Equal Opportunity Law City Auditor City Clerk Human Resources Budget and Research Finance Others Total General Government $ 1,443 $ 3,157 1,830 29,728 2,325 2,166 18,288 1,992 4,564 10,192 2,888 16,631 3,373 98,577 1,338 3,217 1,661 2,805 2,285 2,336 18,029 2,655 3,620 9,240 3,169 18,401 1,894 70,650 101.1 % 95.0 92.8 90.4 100.3 94.7 100.3 77.4 91.8 92.6 90.5 96.9 121.2 94.7 100.0 % 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 30,954 4,708 35,662 28,786 4,756 33,542 28,667 4,657 33,324 93.0 101.0 94.1 100.0 100.0 100.0 437,955 226,892 30 664,877 424,996 222,052 1 647,049 419,577 220,071 43 639,691 97.0 97.9 3.3 97.3 100.0 100.0 100.0 100.0 Transportation Street Transportation Public Transit Total Transportation 22,527 19,231 41,758 20,457 18,704 39,161 19,663 19,048 38,711 90.8 97.3 93.8 100.0 100.0 100.0 Community Development Economic Development Neighborhood Services Department Planning and Development Others Total Community Development 4,886 11,532 4,995 57 21,470 4,305 10,695 4,345 48 19,393 4,309 10,304 4,743 102 19,458 88.1 92.7 87.0 84.2 90.3 100.0 100.0 100.0 100.0 100.0 Community Enrichment Parks and Recreation Library Human Services Others Total Community Enrichment 89,567 35,277 18,493 2,121 145,458 89,564 32,578 16,141 1,743 140,026 86,181 32,306 17,044 2,262 137,793 100.0 92.3 87.3 82.2 96.3 100.0 100.0 100.0 100.0 100.0 Environmental Services Public Works Environmental Programs Total Environmental Services 16,400 978 17,378 14,968 755 15,723 13,135 911 14,046 91.3 77.2 90.5 100.0 100.0 100.0 3,833 2,300 1,122 60.0 100.0 37,890 - - Criminal Justice Municipal Court Public Defender Total Criminal Justice Public Safety Police Fire Others Total Public Safety Capital Improvement Contingencies Total Expenditures and Encumbrances $ 1,428 3,323 1,973 32,873 2,319 2,287 18,234 2,575 4,969 11,008 3,191 17,160 2,782 104,122 1,072,448 $ $ 995,771 $ 954,795 (1) In prior years, Information Technology Services' charges were allocated to user departments. In fiscal year 2012, Information Technology Services' charges are budgeted for within the Information Technology Services Department. -3- 92.9 % 100.0 % Citywide Summary Comparison to Prior Year Revenues YEAR-TO-DATE REVENUES As of June 30, 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 June 30 decreased by $24,975,402 to $2,989,333,883 from the $3,014,309,285 collected during the same period last year, a decrease of 0.8%. For the current year, 99.3% of the total estimated revenue has been collected. Of the total revenues received last year, 100.0% had been collected as of June 30. -4- Comparison to Prior Year Operating Expenditures YEAR-TO-DATE OPERATING EXPENDITURES (millions of dollars) As of June 30, 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 June 30 decreased $40,595,250 to $2,985,409,998 from the $3,026,005,248 spent during the same period last year, a decrease of 1.3%. For the current year, 85.9% of the total appropriations has been spent. Of the total actual expenditures for last year, 100.0% had been spent as of June 30. -5- Comparison to Prior Year Capital Expenditures YEAR-TO-DATE CAPITAL EXPENDITURES As of June 30, 2012 950 900 850 800 750 700 (millions of dollars) 650 600 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 June 30 decreased $115,708,501 to $745,255,616 from the $860,964,117 spent during the same period last year, a decrease of 13.4%. For the current year, 56.5% of the total appropriations has been spent. Of the total actual expenditures for last year, 100.0% had been spent as of June 30. -6- Summary Operating Revenues 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 2011-12 $ Total General Funds 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 Total Operating Revenues $ 417,006 2,465 Actual Year-to-Date 2011-12 2010-11 406,888 $ 2,335 392,380 2,442 110,696 122,065 48,045 126,763 3,270 9,567 21,859 12,598 1,256 7,103 993 5,124 49,212 300 14,890 114,017 122,012 46,400 128,054 2,946 9,381 22,592 15,614 1,372 6,684 1,057 5,261 47,928 802 15,041 111,787 143,647 48,299 130,913 3,092 9,584 22,482 16,125 1,243 7,496 1,124 5,253 49,081 334 17,407 103.0 100.0 96.6 101.0 90.1 98.1 103.4 123.9 109.2 94.1 106.4 102.7 97.4 267.3 101.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 953,212 948,384 962,689 99.5 100.0 26,956 78,517 27,510 159,966 11,425 33,100 17,502 14,781 91,126 28,863 3,854 25,634 306,082 99,757 26,560 76,698 26,928 158,080 9,250 32,695 16,694 15,220 90,838 25,186 3,209 33,954 258,213 99,638 25,345 74,510 25,961 153,198 2,947 31,798 15,638 14,680 105,588 42,174 8,881 24,392 246,910 154,339 98.5 97.7 97.9 98.8 81.0 98.8 95.4 103.0 99.7 87.3 83.3 132.5 84.4 99.9 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 100.0 925,073 873,163 926,361 94.4 100.0 329,036 57,391 366,646 230,882 142,567 6,130 339,281 56,342 388,816 232,845 144,441 6,062 332,636 61,495 354,644 227,641 143,134 5,709 103.1 98.2 106.0 100.9 101.3 98.9 100.0 100.0 100.0 100.0 100.0 100.0 1,132,652 1,167,787 1,125,259 103.1 100.0 2,989,334 $ 3,014,309 3,010,937 -7- $ % of Year-to-Date Estimate Actual 2011-12 2010-11 $ 97.6 % 94.7 99.3 % 100.0 % 100.0 100.0 % Summary Operating Revenues As of June 30, 2012 General Funds Local Taxes General Funds State Shared Taxes 450 350 400 300 350 (millions of dollars) (millions of dollars) 250 300 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 Nov Dec Current YTD Revenues Total General Funds Revenues Jan Feb Mar April May June Prior YTD Revenues Highway User Revenues 1,200 120 110 100 1,000 800 (millions of dollars) (millions of dollars) 90 600 400 80 70 60 50 40 30 20 200 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 June 30 (dollars in thousands) Source General Government General Funds Other Funds Total General Government Actual Year-to-Date 2011-12 2010-11 Budget 2011-12 $ Criminal Justice General Funds Other Funds Total Criminal Justice 104,122 15,886 120,008 $ 98,577 $ 11,081 109,658 % of Year-to-Date Estimate Actual 2011-12 2010-11 70,650 7,397 78,047 94.7 % 69.8 91.4 100.0 % 100.0 100.0 35,662 9,893 45,555 33,542 2,763 36,305 33,324 3,634 36,958 94.1 27.9 79.7 100.0 100.0 100.0 Public Safety General Funds Other Funds Total Public Safety 664,877 164,311 829,188 647,049 156,318 803,367 639,691 152,311 792,002 97.3 95.1 96.9 100.0 100.0 100.0 Transportation General Funds Other Funds Total Transportation 41,758 571,577 613,335 39,161 545,268 584,429 38,711 529,119 567,830 93.8 95.4 95.3 100.0 100.0 100.0 Community Development General Funds Other Funds Total Community Development 21,470 231,374 252,844 19,393 172,740 192,133 19,458 156,656 176,114 90.3 74.7 76.0 100.0 100.0 100.0 Community Enrichment General Funds Other Funds Total Community Enrichment 145,458 142,867 288,325 140,026 132,327 272,353 137,793 137,031 274,824 96.3 92.6 94.5 100.0 100.0 100.0 Environmental Services General Funds Other Funds Total Environmental Services 17,378 617,100 634,478 15,723 533,905 549,628 14,046 558,647 572,693 90.5 86.5 86.6 100.0 100.0 100.0 Debt Service General Funds Other Funds Total Debt Service 139,719 139,719 157,298 157,298 196,779 196,779 112.6 112.6 100.0 100.0 Capital Improvement General Funds Other Funds Total Capital Improvement 3,833 462,688 466,521 2,300 277,939 280,239 1,122 329,637 330,759 60.0 60.1 60.1 100.0 100.0 100.0 Contingencies General Funds Other Funds Total Contingencies Total Operating General Funds Other Funds Total Operating Budget 37,890 46,550 84,440 $ 1,072,448 2,401,965 3,474,413 - $ 995,771 1,989,639 2,985,410 $ -9- 954,795 2,071,211 3,026,006 92.9 82.8 85.9 % 100.0 100.0 100.0 % Summary Operating Expenditures and Encumbrances As of June 30, 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 July Aug Sept Oct Nov Dec Jan Feb Mar April May June Current YTD Expenditures Aug Sept Oct 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. Total Transportation 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 (millions of dollars) (millions of dollars) Total Public Safety July Aug Sept Oct Nov Dec Jan Current YTD Expenditures Feb 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 July Mar April May June Aug Sept Oct Nov Dec Jan Current YTD Expenditures Prior YTD Expenditures - 10 - Feb Mar April May June Prior YTD Expenditures Summary Operating Expenditures and Encumbrances As of June 30, 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 620 600 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 210 200 190 180 170 160 150 (millions of dollars) (millions of dollars) Total Environmental Services Nov Dec 140 130 120 110 100 90 80 70 60 50 40 30 20 10 0 July Aug Sept Oct Nov Dec Current YTD Expenditures Jan July Aug Sept Oct Feb Mar April May June Nov Dec Jan Current YTD Expenditures Prior YTD Expenditures - 11 - Feb Mar April May June Prior YTD Expenditures Citywide Detail Revenues Revenues For the Month Ended June 30 2012 2011 Budget Estimate 2011-12 Source Percent of Year-to-Date Estimate Actual 2011-12 2010-11 Actual Year-to-Date 2011-12 2010-11 General Funds $ 39,114,973 63,146 $ 32,462,369 64,643 Local Taxes: Sales Taxes Privilege License Fees $ 417,006,000 2,464,500 $ 406,887,551 2,335,160 $ 392,379,942 2,442,281 97.6 % 94.8 100.0 % 100.0 39,178,119 32,527,012 Total Local Taxes 419,470,500 409,222,711 394,822,223 97.6 100.0 11,272,110 10,168,121 4,435,402 9,150,236 11,970,582 3,851,230 State Shared Taxes: State Sales Tax State Income Tax Vehicle License Tax 110,696,000 122,065,000 48,045,000 114,017,120 122,012,407 46,400,088 111,787,366 143,647,008 48,298,761 103.0 100.0 96.6 100.0 100.0 100.0 25,875,633 24,972,048 280,806,000 282,429,615 303,733,135 100.6 100.0 25,176,589 15,992,652 Primary Property Tax 126,763,000 128,053,815 130,913,419 101.0 100.0 277,472 225,192 Licenses and Permits 3,270,000 2,946,284 3,091,909 90.1 100.0 2,260,490 2,392,357 Cable Communications 9,567,056 9,381,300 9,584,069 98.1 100.0 1,709,185 97,421 1,766,662 81,194 Municipal Court: Fines and Forfeitures Court Default Fee 20,759,025 1,100,000 21,374,953 1,216,672 21,322,177 1,160,310 103.0 110.6 100.0 100.0 1,806,606 1,847,856 21,859,025 22,591,625 22,482,487 103.4 100.0 1,003,932 1,050,707 12,597,587 15,614,435 16,124,788 123.9 100.0 Total State Shared Taxes Total Municipal Court Police 150,905 110,367 Library Fees 1,256,140 1,371,525 1,243,120 109.2 100.0 1,126,325 844,647 Parks and Recreation 7,102,531 6,683,902 7,495,570 94.1 100.0 - 100.0 - (27) Engineering & Architectural Services 88,526 81,883 Planning and Development 294,789 89,668 Street Transportation 3,240,242 413,999 731,910 3,381,517 185,637 939,007 4,386,151 4,506,161 127,532 52,775 2,223,373 2,044,206 103,976,442 86,737,504 - Fire: Emergency Transportation Service Hazardous Materials Inspection Fee Other Total Fire Interest Other Fees and Service Charges Total General Funds - 12 - - (27) 993,300 1,057,304 1,123,637 106.4 100.0 5,124,098 5,261,218 5,253,203 102.7 100.0 36,750,000 1,300,000 11,161,613 35,850,702 1,334,889 10,742,069 36,836,527 1,290,737 10,952,769 97.6 102.7 96.2 100.0 100.0 100.0 49,211,613 47,927,660 49,080,033 97.4 100.0 301,380 801,578 334,170 266.0 100.0 14,889,664 15,041,372 17,407,241 101.0 100.0 953,211,894 948,384,344 962,688,977 99.5 100.0 Revenues Revenues For the Month Ended June 30 2012 2011 Budget Estimate 2011-12 Source Actual Year-to-Date 2011-12 2010-11 Percent of Year-to-Date Estimate Actual 2011-12 2010-11 Special Revenue Funds and Debt Service $ Neighborhood Protection: Police Neighborhood Protection Police Blockwatch Fire Neighborhood Protection Interest/Other 1,688,738 $ 113,552 566,764 (3,516) 1,597,067 121,290 606,452 (8,517) 2,365,538 2,316,292 4,977,245 1,649,687 (5,791) 4,751,495 1,571,947 (853) 6,621,141 6,322,589 2,433,236 2,332,048 Parks and Preserves 9,647,224 3,927,561 9,130,234 5,355,037 Transit 2000: Sales Taxes Interest/Other 13,574,785 14,485,271 1,835,870 255,166 $ Total Neighborhood Protection 18,837,000 1,345,000 6,726,000 48,000 $ 18,582,821 1,320,273 6,600,365 57,011 $ 17,740,555 1,274,397 6,371,984 (42,186) 98.7 % 98.2 98.1 118.8 100.0 % 100.0 100.0 100.0 26,956,000 26,560,470 25,344,750 98.5 100.0 58,269,000 20,108,000 140,000 57,142,410 19,611,580 (56,084) 55,288,854 19,173,148 47,880 98.1 97.5 (40.1) 100.0 100.0 100.0 78,517,000 76,697,906 74,509,882 97.7 100.0 27,510,000 26,927,589 25,960,955 97.9 100.0 107,640,000 52,325,926 106,184,838 51,894,976 101,378,740 51,819,571 98.6 99.2 100.0 100.0 159,965,926 158,079,814 153,198,311 98.8 100.0 Court Awards 11,425,309 9,249,546 2,946,939 81.0 100.0 Planning and Development 33,100,000 32,695,158 31,798,164 98.8 100.0 Capital Construction 17,502,000 16,693,968 15,638,203 95.4 100.0 Sports Facilities: Sales Taxes Interest/Other 14,386,000 395,000 14,669,881 549,667 14,076,178 603,882 102.0 139.2 100.0 100.0 Public Safety Enhancement & Expansion: Police Fire Interest/Other Total Public Safety Enhancement & Expansion Total Transit 2000 1,614,778 3,355,034 1,419,624 75,816 1,299,665 72,940 1,251,513 37,886 1,372,605 1,289,399 Total Sports Facilities 14,781,000 15,219,548 14,680,060 103.0 100.0 7,737,081 14,438 (872) 9,325,382 49,181 300 Highway User Revenue: Highway User Revenue Interest Other 90,226,000 600,000 300,000 90,367,525 289,110 181,751 104,908,162 543,246 136,094 100.2 48.2 60.6 100.0 100.0 100.0 7,750,647 9,374,863 91,126,000 90,838,386 105,587,502 99.7 100.0 1,930,819 19,832,870 28,863,623 25,186,095 42,175,256 87.3 100.0 Total Highway User Revenue Regional Transit Revenues 297,479 1,578,129 Community Reinvestment 2,638,036 4,475,205 Other Restricted Fees - 13 - 3,853,899 3,208,993 8,880,633 83.3 100.0 25,633,671 33,953,872 24,391,842 132.5 100.0 Revenues Revenues For the Month Ended June 30 2012 2011 Budget Estimate 2011-12 Source Actual Year-to-Date 2011-12 2010-11 Percent of Year-to-Date Estimate Actual 2011-12 2010-11 Special Revenue Funds and Debt Service (Cont'd) $ 451,515 7,536,050 2,972,259 $ 613,659 15,551,727 5,872,383 10,959,824 22,037,769 9,277,935 7,075,262 (607,262) 18,989,542 8,800,440 13,903,652 737,525 27,512,787 34,735,477 50,954,404 45,695,301 72,992,173 18,350,851 2,546,300 17,536,407 61,145 20,897,151 17,597,552 110,447,010 156,282,407 Grants: Public Housing: Rentals Grants Other $ Total Public Housing 9,270,065 77,005,775 2,431,392 $ 6,861,682 71,196,055 4,655,698 $ 6,621,112 71,820,792 10,388,678 74.0 % 92.5 191.5 100.0 % 100.0 100.0 88,707,232 82,713,435 88,830,582 93.2 100.0 42,765,750 9,983,354 34,665,229 129,960,524 47,872,743 22,917,080 17,470,088 87,239,747 45,109,154 18,850,309 17,589,802 76,530,274 111.9 229.6 50.4 67.1 100.0 100.0 100.0 100.0 Total Other 217,374,857 175,499,658 158,079,539 80.7 100.0 Total Grants 306,082,089 258,213,093 246,910,121 84.4 100.0 94,529,000 5,228,000 94,435,864 5,202,121 149,018,526 5,320,237 99.9 99.5 100.0 100.0 Other: Human Resources Federal Transit Administration Community Development Other G.O. Bond Debt Service Secondary Property Tax Interest Total G.O. Bond Debt Service Total Special Revenue and Debt Service 99,757,000 99,637,985 154,338,763 99.9 100.0 925,073,517 873,162,423 926,361,381 94.4 100.0 108,000,000 173,799,000 1,620,000 3,286,000 1,724,000 3,606,500 37,000,000 91,129,057 194,074,228 832,515 7,382,329 1,674,139 2,962,728 41,225,342 83,066,217 196,647,521 1,355,324 7,327,025 1,632,068 3,228,681 39,377,770 84.4 111.7 51.4 224.7 97.1 82.1 111.4 100.0 100.0 100.0 100.0 100.0 100.0 100.0 329,035,500 339,280,338 332,634,606 103.1 100.0 39,685,000 17,106,160 600,000 40,029,700 15,939,510 372,955 37,834,704 23,035,562 625,089 100.9 93.2 62.2 100.0 100.0 100.0 57,391,160 56,342,165 61,495,355 98.2 100.0 Enterprise Funds AVIATION: 8,004,590 13,158,535 (470,191) 4,392,310 140,345 331,828 4,517,266 7,018,344 16,241,102 183,531 3,634,666 133,189 307,754 4,577,070 30,074,683 32,095,656 Sky Harbor: Airlines Concessions Interest Other Phoenix-Goodyear Phoenix-Deer Valley Phoenix-Customer Facility Charge Total Aviation CONVENTION CENTER: 3,724,992 1,620,634 21,771 3,381,064 1,113,893 51,276 5,367,397 4,546,233 Excise Taxes Operating Revenue Interest Total Convention Center - 14 - Revenues Revenues For the Month Ended June 30 2012 2011 Budget Estimate 2011-12 Source Actual Year-to-Date 2011-12 2010-11 Percent of Year-to-Date Estimate Actual 2011-12 2010-11 Enterprise Funds (Cont'd) WATER SYSTEM: $ 43,008,430 $ 515,530 (352,707) (899,478) 115,200 216,609 (225,700) 37,680,595 522,270 (36,184) 1,038,811 151,080 296,034 (1,241,547) 42,377,884 38,411,059 16,096,270 (2,323,856) 107,040 183,474 (3,346,310) 16,860,225 1,510,059 133,200 374,895 (15,089,019) 10,716,618 3,789,360 10,479,729 731,950 33,859 67,259 10,316,796 900,350 52,220 (235,081) 11,312,797 11,034,285 Water Sales Water Service Fees Distribution Intergovernmental Development Fees Interest Other $ 343,293,000 6,000,000 3,180,000 9,395,000 1,500,000 1,298,000 1,980,000 Total Water System $ 366,917,051 5,685,568 3,001,027 6,365,378 1,820,280 1,918,502 3,108,222 $ 331,730,015 6,011,686 2,700,880 7,850,359 1,217,640 3,465,636 1,668,015 106.9 % 94.8 94.4 67.8 121.4 147.8 157.0 100.0 % 100.0 100.0 100.0 100.0 100.0 100.0 366,646,000 388,816,028 354,644,231 106.0 100.0 196,104,000 14,486,000 1,400,000 1,962,000 16,930,000 194,388,181 15,746,953 1,670,220 2,211,662 18,828,236 197,660,319 19,044,986 1,059,239 3,084,972 6,791,627 99.1 108.7 119.3 112.7 111.2 100.0 100.0 100.0 100.0 100.0 230,882,000 232,845,252 227,641,143 100.9 100.0 123,625,000 7,440,000 750,000 10,752,500 124,377,559 6,873,823 501,105 12,688,789 123,477,977 8,399,679 689,985 10,566,553 100.6 92.4 66.8 118.0 100.0 100.0 100.0 100.0 142,567,500 144,441,276 143,134,194 101.3 100.0 WASTEWATER: Sewer Service Charges Multi-City Development Fees Interest Other Total Wastewater SOLID WASTE: Collection Fees Landfill Fees Interest Other Total Solid Waste GOLF COURSES: $ 177,862 4,243 128,670 (7,356) (1,705) 155,129 12,194 117,337 (12,484) (10,124) 301,714 262,052 100,151,093 90,138,645 314,574,545 $ 333,158,556 Fees Coffee Shops Concessions Interest Other 4,100,500 78,400 2,008,000 (185,282) 128,000 3,966,553 77,755 2,035,954 (114,095) 95,890 3,755,168 73,428 1,851,490 (142,771) 172,083 96.7 99.2 101.4 61.6 74.9 100.0 100.0 100.0 100.0 100.0 6,129,618 6,062,057 5,709,398 98.9 100.0 1,132,651,778 1,167,787,116 1,125,258,927 103.1 100.0 Total Golf Courses Total Enterprise Funds Total Operating Revenues $ 3,010,937,189 - 15 - $ 2,989,333,883 $ 3,014,309,285 99.3 % 100.0 % Operating Expenditures and Encumbrances For the Month Ended June 30 2012 2011 Budget Estimate 2011-12 Program Actual Year-to-Date 2011-12 2010-11 2011-12 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt General Government $ 163,629 $ 368,993 435,565 4,330,303 98,827 277,494 294,430 2,558,212 299,450 381,414 34,351 1,279,273 (56,150) 11,697 363,683 2,298,103 451,554 13,590,828 98,223 269,171 252,585 2,027,839 89,984 151,800 254,562 1,454,461 235,239 224,293 197,059 46,941 (123,876) 7,531 (49,906) 1,477,720 956,305 7,569,931 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,438,508 3,323,173 2,289,692 33,838,035 1,321,292 2,624,699 2,691,191 20,041,149 2,574,942 4,993,080 1,298,797 11,729,936 162,059 3,191,087 24,160,975 4,329,630 $ 1,442,741 3,156,995 1,972,121 30,304,251 1,512,294 2,630,376 2,578,167 20,118,428 1,992,482 4,579,514 1,937,633 10,623,798 26,802 94,755 2,887,797 19,470,397 4,329,629 $ 1,353,623 3,217,095 1,954,091 3,482,689 1,241,735 2,596,363 2,719,727 19,695,153 2,655,260 3,633,875 564,451 9,691,845 118,384 3,168,939 20,997,551 956,305 $ 1,442,741 3,156,995 1,972,121 30,113,910 1,512,294 2,630,376 2,578,167 20,118,428 1,992,482 4,564,195 1,937,633 10,538,499 26,802 94,755 2,887,797 19,335,158 4,329,629 $ 190,341 15,319 85,299 135,239 - 120,008,245 109,658,180 78,047,086 109,231,982 426,198 40,846,452 4,708,450 31,549,036 4,756,029 32,300,536 4,657,320 31,088,257 4,756,029 460,779 - 45,554,902 36,305,065 36,957,856 35,844,286 460,779 560,090,725 268,616,005 480,992 541,076,021 261,867,164 424,275 534,049,237 257,456,943 495,945 538,418,361 260,879,096 424,275 2,657,660 988,068 - 829,187,722 803,367,460 792,002,125 799,721,732 3,645,728 Criminal Justice 3,510,413 508,530 (604,652) 502,829 4,018,943 (101,823) Municipal Court Public Defender Total Criminal Justice Public Safety 56,687,687 26,644,326 48,116 39,545,396 20,762,011 (93,268) 83,380,129 60,214,139 Police Fire Other Total Public Safety - 16 - Operating Expenditures and Encumbrances For the Month Ended June 30 2012 2011 Budget Estimate 2011-12 Program Actual Year-to-Date 2011-12 2010-11 2011-12 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Transportation $ 6,877,932 $ 1,012,932 41,514,797 (2,043,495) 4,081,274 920,714 38,275,807 906,177 47,362,166 44,183,972 Street Transportation Street Lighting Aviation Public Transit Total Transportation $ 58,632,945 11,685,358 290,441,289 252,575,530 $ 57,469,178 10,583,687 282,876,705 233,499,188 $ 53,787,348 11,137,165 272,584,623 230,320,549 $ 57,355,714 10,583,687 202,166,748 185,104,803 $ 113,464 80,709,957 48,394,385 613,335,122 584,428,758 567,829,685 455,210,952 129,217,806 Community Development 3,393,711 6,485,754 4,027,582 7,002,342 2,500,992 7,067,891 1,536,778 4,110,376 Planning and Development Housing Economic Development Neighborhood Services Department 33,601,910 75,437,220 37,875,681 105,929,214 31,468,020 77,245,247 25,761,255 57,658,052 31,538,145 76,835,540 25,021,787 42,718,651 31,468,020 77,172,775 22,006,139 57,658,052 72,472 3,755,116 - 20,909,389 15,216,037 Total Community Development 252,844,025 192,132,574 176,114,123 188,304,986 3,827,588 96,385,575 36,069,133 8,541,758 62,545,832 10,968,395 68,839,505 4,133,240 841,581 95,569,009 33,488,228 8,261,247 57,836,346 7,883,584 65,299,085 3,376,317 639,007 92,204,141 33,227,359 7,857,363 60,621,920 10,712,452 65,357,181 3,862,399 980,802 95,399,320 33,488,228 8,260,497 38,476,688 65,242,625 3,376,317 639,007 169,689 750 19,359,658 7,883,584 56,460 - 288,325,019 272,352,823 274,823,617 244,882,682 27,470,141 Community Enrichment 12,462,603 4,092,267 914,252 5,571,056 651,070 8,242,586 453,703 21,372 32,408,909 7,564,987 3,485,177 672,902 4,261,864 (490,506) 5,808,183 808,343 (39,347) 22,071,603 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 June 30 2012 2011 Budget Estimate 2011-12 Program 2011-12 Year-to-Date Operating Expenditures & Encumbrances Capital Operations and Debt Actual Year-to-Date 2011-12 2010-11 Environmental Services $ 28,296,927 14,204,433 14,314,593 2,786,894 193,409 59,796,256 $ 24,537,018 14,416,404 9,683,386 (1,098,184) 197,005 47,735,629 Water System Wastewater Solid Waste Management Public Works Environmental Programs $ Total Environmental Services 390,781,777 84,743,876 124,238,686 33,305,241 1,407,983 $ 273,029,218 137,079,930 121,978,326 16,277,125 1,263,074 $ 282,095,151 154,917,554 118,911,314 15,363,077 1,405,866 $ 175,045,074 72,622,085 109,101,036 15,467,906 1,263,074 $ 373,499,175 97,984,144 64,457,845 12,877,290 809,219 - 634,477,563 549,627,673 572,692,962 176,128,498 1,315,055 13,124,099 19,974,955 211,365 4,727,555 671,765 4,165,274 677,444 9,357,132 7,370,435 929,524 26,140,222 50,200 8,957,446 2,022,132 6,361,800 (36,180,505) 1,846,375 31,958,772 28,293,672 306,413 7,437,854 1,314,930 12,203,413 19,167,584 210,364 3,748,045 665,965 3,635,836 662,694 8,357,587 6,962,608 902,767 24,556,510 50,200 7,768,537 1,431,300 6,256,689 3,834 1,752,387 22,516,618 27,520,859 306,412 7,303,162 1,314,055 9,541,576 20,090,817 5,453,293 264,725 4,855,535 667,165 4,863,781 842,526 7,286,395 5,597,277 919,522 18,741,085 50,200 11,764,722 2,555,020 2,346,787 35,241,380 519 25,472,463 36,664,230 166,813 2,079,051 - 1,314,930 12,203,413 19,167,584 210,364 3,748,045 665,965 3,635,836 662,694 8,357,587 6,962,608 902,767 24,556,510 50,200 7,768,537 1,431,300 6,256,689 3,834 1,752,387 22,516,618 27,520,859 306,412 7,303,162 General Obligation Debt Service 109,463 948,739 1,070,582 16,613 (14,675) 50,180 (140,331) 41,703 (142,477) 468,378 50,705 1,548,127 4,183 404,301 1,730 1,290,506 60,272 (6,486,189) 2,032,860 25,534 838,189 109,505 795,131 1,674,235 5,453,293 22,061 404,628 55,597 405,315 70,210 607,200 466,440 76,626 1,561,487 4,183 980,393 212,918 (5,787,402) 14,892,130 (3,143,081) 2,122,705 3,055,355 13,902 (3,798,241) 2,178,393 20,254,590 Total Debt Service 139,718,984 157,298,301 196,778,937 - 157,298,301 54,630,735 100,823,346 Capital Improvement 466,521,254 280,239,164 330,758,857 - 280,239,164 $ 318,275,748 $ 317,967,424 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 84,440,000 $ 3,474,412,836 - 18 - $ 2,985,409,998 $ 3,026,005,248 $ 2,206,695,795 $ 778,714,203 Capital Expenditures and Encumbrances For the Month Ended June 30 2012 2011 $ (4,701,910) $ 22,760,879 342,229 1,393,828 808,738 194,822 262,017 6,903,919 $ Capital Expenditures and Encumbrances 2010-11 Actual Yearto-Date 2011-12 Actual YearBudget to-Date Program (3,689,365) 22,778,520 4,159,182 1,359,667 2,105,497 Arts and Cultural Facilities Aviation Economic Development Energy Conservation Facilities Management $ 14,804,107 $ 430,912,669 10,543,514 17,716,981 19,197,800 15,956,831 $ 332,919,825 5,273,101 10,920,117 8,862,529 (7,394,734) 691,604 10,618,324 Fire Protection Freeway Mitigation Historic Preservation Housing 21,140,399 2,759,359 67,304,234 13,561,626 810,971 39,939,990 2,157,262 14,253,403 7,697,854 12,085,676 6,432,134 157,883,858 18,529,456 6,997,468 15,007,836 2011-12 Year-to-Date Capital Amounts From Operating Funds From Capital Funds Budget Actual Budget Actual $ 1,195,000 $ 53,590,375 6,944,985 17,716,981 1,752,000 4,622,559 39,392,716 4,037,965 10,920,117 594,444 5,077,215 2,040,547 52,513,484 86,883 48,768,331 645,851 7,842,740 3,037,181 3,083,886 8,273,520 7,982,018 5,614,560 3,356,180 $ Unencumbered Budget 13,609,107 $ 377,322,294 3,598,529 17,445,800 11,334,272 293,527,109 1,235,136 8,268,085 $ (1,152,724) 97,992,844 5,270,413 6,796,864 10,335,271 26,478,064 21,140,399 2,672,476 18,535,903 13,561,626 810,971 13,461,926 7,578,773 1,948,388 27,364,244 10,256,533 1,454,500 3,966,861 4,394,530 1,344,701 790,663 2,157,262 3,996,870 6,243,354 8,118,815 645,851 3,448,210 1,692,480 2,293,223 1,511,411 6,410,663 4,660,673 9,001,790 17,429 53,270 6,783 128,942 3,608,722 975,082 407,732 402,402 Human Services Information Technology Libraries Neighborhood Services 1,090,010 671,366 1,650,606 1,220,787 5,777,682 509,772 300,536 4,003,914 Parks and Mountain Preserves Phoenix Convention Center Police Protection Public Transit 100,088,025 2,412,303 25,509,600 77,991,552 38,343,729 1,643,819 4,018,166 9,896,209 72,654,199 4,493,423 11,834,042 33,260,738 47,150,118 2,312,303 26,179,381 25,614,725 1,584,649 4,009,162 52,937,907 100,000 25,509,600 51,812,171 12,729,004 59,170 4,018,166 5,887,047 61,744,296 768,484 21,491,434 68,095,343 76,538 14,042,777 10,494,960 10,442,786 98,535 16,194,171 8,057,216 36,391,415 Solid Waste Disposal Street Transportation & Drainage Wastewater Water System 31,444,218 155,714,473 95,462,416 184,100,987 15,511,602 70,654,655 66,342,470 95,990,318 22,640,438 138,848,567 41,347,015 246,177,419 16,565,000 70,784,504 58,777,540 99,019,959 11,327,712 47,477,684 32,555,529 65,093,944 14,879,218 84,929,969 36,684,876 85,081,028 4,183,890 23,176,971 33,786,941 30,896,374 15,932,616 85,059,818 29,119,946 88,110,669 67,860,776 $ 107,355,874 Total Capital Improvement Program $ 1,293,296,832 $ 745,255,616 $ - 19 - 860,964,117 $ 466,521,254 $ 280,239,164 $ 826,775,578 $ 465,016,452 $ 548,041,216 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 $ - 20 - 2,689,750 $ 2,537,395 $ 152,355