2006-07 Annual Report Receipts & Expenditures Arizona Department of Transportation Transportation Services Group 206 South Seventeenth Avenue Janet Napolitano Governor Phoenix, Arizona 85007-3213 John A. Bogert Chief of Staff Victor M. Mendez Director January 30, 2008 Ms. Jan Brewer Secretary of State 1700 W. Washington Street, 7th Floor Phoenix, Arizona 85007 Dear Ms. Brewer: In compliance with Section 35-103 of the Arizona Revised Statutes, I respectfully submit the Receipts & Expenditures Annual Report of the Arizona Department of Transportation for the fiscal year ended June 30, 2007. This report presents the financial position of the Department on a cash basis as of June 30, 2007. This report includes all funds used to record the financial activity of the Department. Responsibility for both the accuracy of the data and the completeness and fairness of the presentation rests with the Department. Sincerely, John E. McGee Chief Financial Officer 206 S. 17th Avenue, MD200B Phoenix, AZ 85007-3213 602-712-7441 c: GladysAnn Wells, Director of Arizona State Library, Archives and Public Records Arizona Department of Transportation Receipts & Expenditures – Annual Report For the fiscal year ended June 30, 2007 (With comparative totals for the fiscal year ended June 30, 2006) Table of Contents Statements: 1 2 3 4 5 Page State Highway Fund .........................................................................................................................1 Aviation Fund...................................................................................................................................2 Maricopa County Regional Area Road Fund (RARF) .....................................................................3 Highway User Revenue Fund (HURF) ............................................................................................4 Other Funds: Highway Revenue Bond Fund ...................................................................................................5 Grant Anticipation Notes Bond Fund ........................................................................................5 Highway Revenue Bond Proceeds Fund....................................................................................5 Grant Anticipation Notes Bond Proceeds Fund .........................................................................5 Cash Deposit Fund.....................................................................................................................5 Driving Under the Influence Abatement Fund ..........................................................................5 Employee Awards and Recognition Fund .................................................................................6 Equipment Fund.........................................................................................................................6 General Fund..............................................................................................................................6 Highway Expansion and Extension Loan Program Fund ..........................................................6 Federal Program Fund................................................................................................................6 Motor Vehicle Division Clearing Fund .....................................................................................6 Highway Properties Fund ..........................................................................................................6 Arizona Highways Magazine Fund ...........................................................................................6 Local Agency Deposits Fund………………………………………………………………….6 Statewide Transportation Acceleration Needs………………………………………………...7 Other Arizona Department of Transportation Funds .................................................................7 Schedules: 1 2 3 4 5 Summary of Transfers - State Highway Fund ..................................................................................8 Breakdown of Motor Vehicle Fees and State Highway Fund Miscellaneous Receipts ..................9 Construction Expenditures .............................................................................................................10 Federal Grants and Other Federal Reimbursements.......................................................................11 Breakdown of Receipts/Expenditures by County - Local Agency Deposits Fund.........................12 Statement 1 Arizona Department of Transportation Comparative Statement of Receipts, Expenditures, Transfers and Cash Position State Highway Fund For the fiscal year ended June 30, 2007 (With comparative totals for the fiscal year ended June 30, 2006) 2007 Receipts: Federal grants and reimbursements (see Schedule 4) Motor vehicle fees (see Schedule 2) Motor vehicle fuel taxes Motor vehicle license taxes Motor carrier taxes Investment interest Interest on loans Local grants and reimbursements Rental income Sale of capital assets Advance deposits Miscellaneous (see Schedule 2) Total receipts $ Expenditures: Highway construction (see Schedule 3) Highway maintenance Motor vehicle division Highway administration Transportation planning division Transportation service group Land, buildings and improvements Highway non-capital Administrative adjustments and refunds Total expenditures Excess of receipts over expenditures Transfers in : Operating transfers in (see Schedule 1) Operating transfers out (see Schedule 1) Total transfers in Excess of receipts and transfers in over expenditures and transfers out Beginning balance, July 1 Ending balance, June 30 $ 1 2006 129,773,430 8,202,749 137,976,179 $ 261,175,118 129,773,430 356,544,741 186,592,748 11,275,325 24,872,196 486,134 13,935,554 1,127,621 461,348 8,202,749 994,446,963 - 396,113,080 120,755,493 100,042,015 130,086,632 3,227,478 44,226,200 8,776,327 1,328,653 304,795 804,860,673 137,976,179 189,586,290 342,248,889 <238,418,702> 103,830,187 342,248,889 <238,418,702> 103,830,187 241,806,366 293,416,477 574,148,480 815,954,846 $ 280,732,003 574,148,480 Statement 2 Arizona Department of Transportation Comparative Statement of Receipts, Expenditures, Transfers and Cash Position Aviation Fund For the fiscal year ended June 30, 2007 (With comparative totals for the fiscal year ended June 30, 2006) 2007 Receipts: Flight property taxes Aircraft lieu taxes Grand Canyon National Park Airport Investment interest Interest on loans Aviation fuel taxes Loan principal payments Registration fees and penalties Stored aircraft license taxes Private donations Federal grants and reimbursements (see Schedule 4) Miscellaneous receipts Total receipts $ Expenditures: Airport construction grants (see Schedule 3) Administration Grand Canyon National Park Airport administration 15,300,127 7,748,524 1,133,347 1,302,805 297,388 460,470 1,417,091 124,075 3,770 11,245 1,967,841 1,724 29,768,407 2006 $ 16,808,328 2,419,989 93,021 13,685,936 5,980,022 1,213,726 774,605 144,143 462,598 645,866 78,437 13,692 10,839 5,133,165 2,516 28,145,545 Total expenditures 19,321,338 21,867,832 2,056,235 99,562 24,023,629 Excess of receipts over expenditures 10,447,069 4,121,916 Beginning balance, July 1 Ending balance, June 30 $ 2 24,031,432 34,478,501 $ 19,909,516 24,031,432 Statement 3 Arizona Department of Transportation Comparative Statement of Receipts, Expenditures, Transfers and Cash Position Maricopa County Regional Area Road Fund (RARF) For the fiscal year ended June 30, 2007 (With comparative totals for the fiscal year ended June 30, 2006) 2007 Receipts: Transportation excise taxes Investment interest Interest on loans Rental income Sale of capital assets Loan principal payments Local reimbursements Federal grants and reimbursements (see Schedule 4) Prior year reimbursement Miscellaneous Total receipts $ Expenditures: Highway construction (see Schedule 3) Other aid to counties HELP loan repayment Administrative expenditure Miscellaneous 2006 262,263,939 11,806,780 144,452 291,499 836,690 747,901 7,096,156 28,657,476 99,504 311,944,397 $ 220,230,263 22,303,272 34,788,929 1,434,504 2,500 Total expenditures Excess of receipts over expenditures Transfers in : Operating transfers in Operating transfers out Total transfers in Excess of receipts and transfers in over expenditures and transfers out Beginning balance, July 1 Ending balance, June 30 $ 3 316,491,260 7,385,519 102,242 250,305 9,323,072 310,779 14,124,837 24,782,529 2,176,954 1,779 374,949,276 278,759,468 186,352,228 7,877,139 6,407,337 16,720 200,653,424 33,184,929 174,295,852 - 179,363 <81,449,977> - <81,270,614> 33,184,929 93,025,238 246,209,575 153,184,337 246,209,575 279,394,504 $ Statement 4 Arizona Department of Transportation Comparative Statement of Receipts, Expenditures, Transfers and Cash Position Highway User Revenue Fund (HURF) For the fiscal year ended June 30, 2007 (With comparative totals for the fiscal year ended June 30, 2006) 2007 Receipts: Motor vehicle fuel taxes Vehicle registration, title, license and related fees Motor carrier taxes Investment interest Overweight fines Reversion from prior year Total receipts $ Expenditures: Distributions to State Highway Fund Distributions to Cities and Towns Distributions to Counties Distributions to Department of Public Safety Distributions to Arizona State Parks Distributions to Economic Strength Project Fund Distributions to Vehicle Registration Enforcement Total expenditures 728,112,531 637,091,410 22,473,394 2,399,231 2,045,200 292,337 1,392,414,103 2006 $ 1,338,039,666 686,403,286 416,304,320 259,337,117 10,000,000 11,450,479 1,000,000 607,300 1,385,102,502 Excess of receipts over expenditures Beginning balance, July 1 Ending balance, June 30 4 638,073,485 386,786,376 240,948,890 63,999,300 9,915,932 1,000,000 637,742 1,341,361,725 7,311,601 $ 117,631,998 124,943,599 709,009,555 604,656,530 20,823,961 2,000,654 1,316,810 232,156 <3,322,059> $ 120,954,057 117,631,998 Statement 5 Arizona Department of Transportation Statement of Receipts, Expenditures, Transfers and Cash Position Funds other than State Highway, Aviation, RARF and HURF For the fiscal year ended June 30, 2007 Beginning Balance Highway Revenue Bond Fund: Debt Service - Series 2006 $ 47,246 124,304 119,236 448,085 86,465 441,966 223,243 68,891 48,065 45,269 145,121 71,973 28,157 1,898,021 $ 92,021 6,645 110 98,776 $ $ $ 1,359 20,361,417 20,362,776 $ $ Debt Service - Series 2005B Debt Service - Series 2005A Debt Service - Series 2004B Debt Service - Series 2004A Debt Service - Series 2003A Debt Service - Series 2003 Debt Service - Series 2002 Debt Service - Series 2002B Debt Service - Series 2002A Debt Service - Series 2001 Debt Service - Series 1999A Debt Service - Series 1993A Debt Service - Series 1992B Total Highway Revenue Bond Fund Cumulative Receipts $ $ Cumulative Expenditures 11,750,481 5,963,636 7,383,482 9,427,405 32,274,866 7,120,556 21,931,480 1,822,267 7,275,358 3,831,479 10,268,458 6,820,385 6,196,419 15,604 132,081,876 $ $ Ending Balance 11,587,516 5,922,550 7,388,087 9,413,000 32,231,250 7,106,335 21,858,337 1,968,805 7,227,137 3,820,937 10,112,147 6,793,475 6,180,600 43,761 131,653,937 $ 5,126,250 7,729,719 5,984,750 38,307,500 57,148,219 $ $ $ 207,177,481 207,177,481 $ 162,965 88,332 119,699 133,641 491,701 100,686 515,109 76,705 117,112 58,607 201,580 172,031 87,792 2,325,960 Grant Anticipation Notes Bond Fund: Debt Service - Series 2004B $ 5,130,645 7,730,037 5,984,753 38,307,500 57,152,935 $ $ $ 309,461,122 50,798,320 127,960 360,387,402 $ 102,283,641 50,798,320 1,359 20,489,377 173,572,697 20 20 $ $ - $ $ 17 17 $ $ 3 3 $ 300,000 9,174 95,401 22,872 $ 18,480 2,735 12,884 $ 160,000 18,485 31,142 $ 140,000 9,169 98,136 4,614 $ 427,447 $ 34,099 $ 209,627 $ 251,919 $ 132,575 - $ 136,800 $ 111,774 $ 132,575 25,026 $ 132,575 $ 136,800 $ 111,774 $ 157,601 $ $ $ 22,474 24,560 13,522 60,556 $ $ 5,212 28,004 19,007 52,223 $ $ 25,067 2,750 27,817 $ 7,805 6,194 5,485 19,484 $ $ 5,156,555 5,156,555 $ $ 41,963,436 41,963,436 $ $ 38,783,981 38,783,981 $ $ 8,336,010 8,336,010 Debt Service - Series 2004A Debt Service - Series 2003A Debt Service - Series 2001A Total Grant Anticipation Notes Bond Fund $ $ $ $ 96,416 6,963 113 103,492 Highway Revenue Bond Proceeds Fund: Bond Proceeds - Series 2006 $ Bond Proceeds - MAG Series 2006 Bond Proceeds - Series 2005B Bond Proceeds - Series 2005A Total Highway Revenue Bond Proceeds Fund Grant Anticipation Notes Bond Proceeds Fund: Bond Proceeds - Series 2004B Total Grant Anticipation Notes Bond Proceeds Fund Cash Deposit Fund: Cash Site Clearance Deposits Human Resource Development Rental Security Deposit Deposit for Revenue Audit Travel Total Cash Deposit Fund Driving Under the Influence Abatement Fund: Driving Under the Influence Abatement Drivingr Under the Influence Abatement 2007 Total Driving Under the Influence Abatement Fund Employee Awards and Recognition Fund: Employee Awards and Recognition MVD Employee Awards and Recognition TSG Employee Awards and Recognition Total Employee Awards and Recognition Fund Equipment Fund: Equipment Services Total Equipment Fund (continued) 5 Statement 5 Arizona Department of Transportation Statement of Receipts, Expenditures, Transfers and Cash Position Funds other than State Highway, Aviation, RARF and HURF For the fiscal year ended June 30, 2007 Beginning Balance Cumulative Receipts Cumulative Expenditures Ending Balance General Fund: Other: Intersection improvement; fire $ - $ $ 1,375,723 87,400,168 $ $ Public Transit Division Operating Total General Fund $ 1,105,000 82,896 1,187,896 $ $ 67,940 47,815,445 88,775,891 $ 38,754 440,581 482,370 28,570 31,682 68,363 1,090,320 $ 10,885,622 559,896 37,353,568 48,799,086 $ $ 1,105,000 82,896 1,187,896 $ $ 6,027,666 $ 1,443,663 129,187,947 47,883,385 $ 6,027,666 $ 130,631,610 100,463 2,910,098 5,456,816 1,526,965 170,000 10,164,342 $ 35,102 66,619 2,374,094 5,425,017 1,522,673 163,031 9,586,536 $ 3,652 474,425 1,018,374 60,369 35,974 75,332 1,668,126 46,007,935 6,835,939 1,382,887,583 1,435,731,457 $ 41,345,912 6,535,063 1,384,950,509 1,432,831,484 $ $ $ 21,500 172,526 194,026 $ $ - Highway Expansion and Extension Loan Program Fund: HELP - Restricted HELP - Unrestricted Total Highway Expansion and Extension Loan Program Fund Federal Program Fund: Federal Hazardous Material Program Highway Fatality File Handicapped Federal Transit Administration - Arizona Federal Transit Administration - Planning Assistance Valley Metro Rail Total Federal Program Fund $ $ $ $ Motor Vehicle Division Clearing Fund: International Registraion Program $ International Fuel Tax Agreement MVD - Revenue Clearing Total Motor Vehicle Division Clearing Fund $ $ $ $ 15,547,645 860,772 35,290,642 51,699,059 Highway Properties Fund: $ $ 21,500 3,002 192,496 148 217,146 $ $ Local Agency Deposits (see Schedule 5) Total Local Agency Deposits Fund Bond Deposits $ $ $ 175,657 211 175,868 $ 3,002 195,627 359 198,988 2,163,050 2,163,050 $ $ 7,587,272 7,587,272 $ $ 7,718,677 7,718,677 $ $ 2,031,645 2,031,645 $ 10,176,890 $ 37,068,680 $ 34,004,061 $ 13,241,509 $ 10,176,890 $ 37,068,680 $ 34,004,061 $ 13,241,509 $ 4,171,221 87 10,226,462 26,792 688,493 75,112 257,160 3,117,779 650,000 19,213,106 $ 68,600 1,221,086 26,051 57,148,222 3,033,484 4,050 3,409,295 22,500 37,026,957 1,808,860 103,769,105 $ 59,292 456,995 57,148,219 4,686,423 758,699 265 34,034,022 1,408,084 98,551,999 $ 9,308 4,935,312 26,051 90 8,573,523 30,842 3,339,089 97,347 3,250,095 3,518,555 650,000 24,430,212 Financial Responsibility Highway Property Fund Right-of-Way Privilege Tax Total Highway Properties Fund Arizona Highways Magazine Fund: Arizona Highways Magazine Total Arizona Highways Magazine Fund Local Agency Deposits Fund: Other Arizona Department of Transportation Funds: Air Quality Economic Strength Project AZ Professional Baseball Special Plate Grant Anticipation Notes Motor Vehicle Liability Insurance Enforcement Motor Carrier Safety Revolving Safety Enforcement and Transportation Infrastructure The Shared Location and Advertising Agreements Expense Fund Underground Storage Tank Tax Clearing Vehicle Inspection and Title Enforcement Appropriation Year 2000 Railroad Corridor Acquisition Total Other Arizona Department of Transportation Funds $ $ 6 $ $ Schedule 1 Arizona Department of Transportation Summary of Transfers State Highway Fund For the fiscal year ended June 30, 2007 (With comparative totals for the fiscal year ended June 30, 2006) 2007 Operating transfers in: Governor's Office of Highway Safety Military Affair Arizona Department of Public Safety Juvenile Court Emergency Management State General Fund to Statewide Transportation Acceleration Needs Fund Statewide Transportation Acceleration Need Highway Expansion and Extension Loan Program Total operating transfers in Operating transfers out: Bond Debt Service - Series 2006 Bond Debt Service - Series 2005B Bond Debt Service - Series 2005A Bond Debt Service - Series 2004B Bond Debt Service - Series 2004A Bond Debt Service - Series 2003A Bond Debt Service - Series 2003 Bond Debt Service - Series 2002B Bond Debt Service - Series 2002A Bond Debt Service - Series 2002 Bond Debt Service - Series 2001 Bond Debt Service - Series 1999 Bond Debt Service - Series 1993A Bond Debt Service - Series 1992B Statewide Transportation Acceleration Need Governor's Office of Highway Safety Arizona Department of Public Safety Office of the Governor Highway Expansion and Extension Loan Program Total operating transfers out $ $ $ $ 7 2006 18,872 384,336 43,761 3,000 245,000,000 62,000,000 34,798,920 342,248,889 $ 36,032 49,978 822,654 36,907,337 $ 37,816,001 11,587,517 5,887,945 7,276,489 9,308,692 31,558,830 7,031,065 21,474,334 7,167,349 3,779,777 1,776,543 10,072,144 6,668,243 6,118,667 62,000,000 1,020,174 10,826,000 66,013 34,798,920 238,418,702 $ 3,373,366 7,018,683 8,782,487 22,953,981 7,050,991 21,572,213 5,422,755 3,795,827 10,640,464 2,956,726 6,654,929 6,116,454 8,901,904 2,118,114 42,552,114 30,750 13,507,330 173,449,088 $ Schedule 2 Arizona Department of Transportation Breakdown of Motor Vehicle Fees and State Highway Fund Miscellaneous Receipts For the fiscal year ended June 30, 2007 (With comparative totals for the fiscal year ended June 30, 2006) 2006 2007 Motor vehicle fees: Registration Other fees & charges for services Motor vehicle driver's licenses Motor vehicle permits Titles Other licenses and permits Total motor vehicle fees $ $ Miscellaneous receipts: Underground storage tank Court assessments Surplus property sales Postage fund Insurance recovery Private company donations Occupational & professional licenses Prior year reimbursements (refunds) Reversion from prior year Other fines & forfeitures, penalties Reproduction Education Miscellaneous Total miscellaneous receipts $ $ 8 95,194,473 6,058,064 9,639,893 4,684,128 7,147,602 7,049,270 129,773,430 $ 233,946 966,769 126,304 1,489,474 2,543,933 2,163,880 42,860 243,582 195,099 122,840 54,707 19,355 8,202,749 $ $ $ 84,985,322 5,644,911 8,848,947 4,499,884 6,608,532 6,407,580 116,995,176 174,716 655,350 155,275 1,378,538 1,268,714 149,796 41,585 67,687 165,911 146,878 31,322 69,270 68,698 4,373,740 Schedule 3 Arizona Department of Transportation Construction Expenditures For the fiscal year ended June 30, 2007 (With comparative totals for the fiscal year ended June 30, 2006) 2007 State Highway Fund: District construction: District E - Phoenix District F - Flagstaff District G - Globe District H - Holbrook District K - Kingman District P - Prescott District S - Safford District T - Tucson District Y - Yuma $ Total District construction 2006 75,142,018 42,205,241 15,343,948 35,242,839 31,452,788 8,423,149 22,477,070 74,787,479 22,661,411 $ 58,238,469 41,073,848 36,492,216 54,631,820 58,293,980 43,814,337 33,591,591 25,517,766 32,859,395 327,735,943 384,513,422 6,321,863 59,190,983 2,139,762 65,533 24,807 634,189 - 50,071,898 49,347,487 1,430,046 247,477 584,402 7,788 2,546 396,113,080 486,205,066 Highway Revenue Bond Proceeds: Highway Revenue Bond Proceeds MAG 2006 Highway Revenue Bond Proceeds 2006 Highway Revenue Bond Proceeds 2005B Highway Revenue Bond Proceeds 2005A Highway Revenue Bond Proceeds 2004B 50,571,439 100,921,297 20,463,223 - 107,235,023 343,411 87,573,285 Total Highway Revenue Bond Proceeds 171,955,959 195,151,719 220,230,263 186,352,228 Grant Anticipation Notes Bond Proceeds: Grant Anticipation Notes Bond Proceeds 2004B - 45,815,714 Total GANS Revenue Bond Proceeds - 45,815,714 Local Agency Deposits Fund 34,004,061 40,769,195 Aviation Fund 16,808,328 21,867,832 Statewide construction Controlled access highways Statewide planning and research NICET/Technical training Minority business education training Partnering Declared emergency maintenance Total State Highway Fund construction expenditures Maricopa County Regional Area Road Fund Total Construction Expenditures $ 9 839,111,691 $ 976,161,754 Schedule 4 Arizona Department of Transportation Federal Grants and Other Federal Reimbursements For the fiscal year ended June 30, 2007 (With comparative totals for the fiscal year ended June 30, 2006) State Highway Fund: Federal Highway Administration reimbursements: Construction Design/preliminary engineering Location Highway planning and research Right-of-Way Utility relocation Total Federal Highway Administration reimbursements Other Federal grants and reimbursements Total State Highway Fund (see Statement 1) 2007 2006 $ 227,999,457 2,406,817 <27,973> 15,625,818 1,250,419 247,254,538 13,920,580 261,175,118 $ 287,332,776 3,489,252 129,471 12,710,431 497,281 824 304,160,035 19,541,755 323,701,790 Local Agency Deposits Fund: Federal Highway Administration reimbursements: Construction Design/preliminary engineering Right-of-Way Total Federal Highway Administration reimbursements Other Federal grants and reimbursements Total Local Agency Deposits Fund (see Schedule 5) 21,894,805 4,215,249 1,399 26,111,453 152,310 26,263,763 34,764,565 2,656,909 305,218 37,726,692 86,555 37,813,247 Maricopa County Regional Area Road Fund: Federal Highway Administration reimbursements: Construction Total Federal Highway Administration reimbursements Total Maricopa Regional Area Road Fund (see Statement 3) 28,657,476 28,657,476 28,657,476 24,782,529 24,782,529 24,782,529 Other funds: Highway Fatality File Transportation Assistance to Elderly/Disabled Federal Transit Administration - Arizona Federal Transit Administration - Planning Assistance Grant Anticipation Notes Aviation Total Other funds 96,481 1,968,891 5,456,816 1,403,367 57,148,219 1,967,841 68,041,615 60,519 2,093,869 3,809,782 898,128 55,019,894 5,133,165 67,015,357 $ 384,137,972 $ 453,312,923 Total Federal Grants and Other Federal Reimbursements 10 Schedule 5 Arizona Department of Transportation Breakdown of Receipts/Expenditures by County Local Agency Deposits Fund For the fiscal year ended June 30, 2007 (With comparative totals for the fiscal year ended June 30, 2006) 2007 Receipts: Federal grants (see Schedule 4) Urban aid County aid Miscellaneous Total receipts $ $ Expenditures by County: Apache Cochise Coconino Gila Graham Greenlee La Paz Maricopa Mohave Navajo Pima Pinal Santa Cruz Yavapai Yuma Statewide Total Expenditures by County $ $ 11 26,263,763 10,622,549 182,368 37,068,680 19,587 <10,878> 298,647 241,514 220,321 18,561 1,064 19,427,475 208,586 1,091,480 10,296,734 115,756 285,107 419,671 1,272,835 97,600 34,004,061 2006 $ $ $ $ 37,813,247 3,262,735 49,437 3,013 41,128,432 925,963 227,236 39,937 145,878 1,962,211 249,134 143,921 17,582,074 63,569 152,233 16,798,395 311,534 138,692 150,926 1,803,203 74,289 40,769,195