Debt Management Plan Fiscal Year Ended June 30, 2005 COCONINO MOHAVE APACHE NAVAJO YAVAPAI LA PAZ MARICOPA COUNTY GILA GREENLEE PINAL GRAHAM YUMA PIMA COCHISE SANTA CRUZ Maricopa County, Arizona Debt Management Plan Table of Contents INTRODUCTION TO DEBT ............................................................................................ 1 Current Debt Situation ............................................................................................... 1 Debt Issuance History................................................................................................ 2 Financing Alternatives ............................................................................................... 3 Pay-As-You-Go Financing ......................................................................................... 3 Grants.......................................................................................................................... 4 Short-Term Borrowing (Notes) .................................................................................. 4 General Obligation Bonds (GO) ................................................................................ 4 Revenue Bonds .......................................................................................................... 5 Special Assessment Bonds ...................................................................................... 5 Certificates of Participation (COP)............................................................................ 5 Lease-Purchase .......................................................................................................... 5 Installment Purchase Agreement.............................................................................. 5 Debt Limit .................................................................................................................... 6 Rating Agency Analysis ............................................................................................ 6 History of Debt Rating ............................................................................................... 7 Ratio Analysis ............................................................................................................ 8 General Obligation Bonds ....................................................................................... 10 Lease Revenue Bonds ............................................................................................. 10 Lease Purchase Agreement .................................................................................... 12 Stadium District ........................................................................................................ 13 Stadium District Contractual Commitments .......................................................... 15 Special Assessment Districts ................................................................................. 15 Certificates of Participation ..................................................................................... 16 Capital Leases (Lease-Purchase Obligations) ....................................................... 17 Installment Purchase Contracts Payable ............................................................... 18 DEBT POLICIES ........................................................................................................... 21 Administration of Policy .......................................................................................... 21 i Maricopa County, Arizona Department of Finance Debt Management Division Use of Debt Financing ............................................................................................. 21 Method of Sale .......................................................................................................... 21 Competitive Sale ...................................................................................................... 21 Negotiated Sale ........................................................................................................ 21 Use of Bond Insurance ............................................................................................ 22 Arbitrage Liability Management .............................................................................. 22 Selection of Professional Services ......................................................................... 22 Continuing Disclosure of County Financial Information ...................................... 23 Maturity Structures .................................................................................................. 24 Ratings ...................................................................................................................... 24 Modification to Policies ........................................................................................... 24 INDIVIDUAL DEBT SERVICE SCHEDULES ............................................................... 27 ii Maricopa County, Arizona Department of Finance Debt Management Division INTRODUCTION TO DEBT Debt Management Plan INTRODUCTION TO DEBT A comprehensive debt plan should be developed by all jurisdictions intending to issue debt. The purpose of Maricopa County’s Debt Management Plan is to set forth the parameters for issuing debt, to manage the debt portfolio and provide guidance to decision makers regarding the timing and purposes for which debt may be issued. Provisions of the debt plan must be compatible with the County’s goals pertaining to the capital program and budget, the financial plan, and the operating budget. A debt plan should strike an appropriate balance between establishing limits on the debt program and providing sufficient flexibility to enable the County to respond to unforeseen circumstances and new opportunities that may benefit the County. This document is not intended to review the County’s total financial position. It is a study of the County’s current debt position, as growth in the County could result in an increased need for capital financing. Revenues, as well as needs, should drive the County’s debt issuance program. Decisions regarding the use of debt will be based in part on the long-term needs of the County and the amount of equity (cash) dedicated in a given fiscal year to capital outlay. A disciplined, systematic approach to debt management should allow the County to enhance its credit ratings, while at the same time meeting the growing demands of the County’s capital projects. The information contained herein reflects the current debt status of Maricopa County for the fiscal year ended June 30, 2005. The tables have been compiled by the Department of Finance. Portions of this Debt Management Plan are contained in the Comprehensive Annual Financial Report (CAFR) for the fiscal year ended June 30, 2005. A copy of the CAFR can be viewed at: http://www.maricopa.gov/finance. Current Debt Situation It is recognized that all debt, regardless of the source of revenue pledged for repayment, represents some sort of cost to taxpayers or ratepayers. Therefore, all types of County debt/obligations are considered herein. While lease-secured and certificate of participation obligations may not be debt under strict legal definitions, they still require future appropriations and are a fixed charge. These lease payments and other non-bonded obligations are added by most security analysts when calculating an issuer’s debt ratios. 1 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan Debt Issuance History The County has used debt financing for many years to finance capital projects. The following chart illustrates the amount of debt, as well as, categories of outstanding debt for the fiscal year ended June 30, 2005. LONG-TERM LIABILITIES All Categories of Debt (2) Maricopa County, Arizona As of June 30, 2005 Year Ending June 30 2001 2002 2003 2004 2005 GOVERNMENTAL ACTIVITES: Bonds, loans, and other payables: General obligation bonds $ 39,515,000 $ 20,165,000 $ 104,355,000 104,355,000 91,558,756 93,569,382 101,101,501 0 0 0 0 10,812,000 28,658,512 58,225,000 57,225,000 55,225,000 52,735,000 0 0 7,888,888 6,428,888 4,428,888 Stadium Debt with governmental commitment (1) 27,935,000 0 0 0 0 Special assessment debt with governmental commitment (1) 589,431 458,977 368,573 343,102 235,458 81,862 64,925 50,811 0 0 Housing Department loans (3) 1,861,500 1,754,922 1,641,310 0 0 Certificates of participation (4) 13,575,118 9,804,315 5,808,084 0 5,500,000 Lease revenue bonds (4) Lease purchase agreement Stadium District revenue bonds (1) Stadium District contractual obligations (1) Housing Department bonds (3) Installment purchase agreements (4) Capital leases Total Governmental activities $ 79,595,000 $ 58,370,000 $ 0 0 0 0 0 892,254 14,225,356 19,442,376 19,414,904 10,820,105 13,507,633 270,876,779 $ 252,475,515 $ 223,471,326 $ 186,551,477 $ 189,212,734 BUSINESS-TYPE ACTIVITES: Bonds and other payables: Lease revenue bonds (4) 20,500,000 20,500,000 17,986,244 16,670,618 43,499 Certificates of participation (4) 11,824,853 11,768,519 10,940,368 5,865,000 0 229,159 0 0 0 0 3,023,111 2,607,815 2,350,524 1,252,049 0 Capital leases Installment purchase agreements (4) Total Business-type activities $ 35,577,123 $ 34,876,334 $ 31,277,136 $ 23,787,667 $ 43,499 Notes: (1) Does not represent an obligation of the County. (2) Long-term liabilities excludes claims and judgments payable, reported and incurred but not reported claims, and liabilities for closure and post closure costs. (3) On July 1, 2003, the Housing Authority of Maricopa County became a legally separate entity and will be reported as a discretely presented component unit. During fiscal year 2004, the Authority implemented HUD Flyer No. 4. As a result, long-term debt (bonds and loans) were written off as the debt is ultimately secured by HUD. 2 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan (4) On January 1, 2005, the Maricopa County Medical Center (business-type activity) was transitioned to the Maricopa County Special Health Care District, a separate legal entity. The long-term debt obligations as previously reported in the Medical Center that include the lease revenue bonds, certificates of participation and installment purchase agreements are the responsibility of the County. Therefore, on January 1, 2005, the long-term debt obligations were reclassified from business-type activities to governmental activities. Maricopa County will pay the debt service including principal and interest as it becomes payable and request reimbursement from the Special Health Care District for their applicable debt obligations as provided for in the Intergovernmental Agreement. Financing Alternatives The County should evaluate all potential funding sources before considering which method of financing may be the most appropriate. Sources of funding may include: current revenues and fund balances; intergovernmental grants from federal, state or other sources; state revolving funds or loan pools; private sector contributions through impact fees or public/private partnerships; and leasing. There are many sources of funding, depending on the type of debt to be incurred and the length of time for repayment. Short-term financing is defined as debt maturing not later than one year after the date of its issuance. There are basically three reasons for using short-term debt: • A vehicle to deal with temporary cash flow difficulties. This situation arises when cash receipts do not follow the same pattern as cash outlays. • To handle unexpected costs resulting from natural emergencies or other significant unexpected events. • In anticipation of issuing a long-term bond for capital financing. This form of financing offers an opportunity to borrow for short periods until the true, final costs of a project are known. Pay-As-You-Go Financing This method means that capital projects are paid for from the government’s current revenue base. The County does not issue bonds and does not have to repay the borrowings over time. There are several advantages to this method. For example, pay-as-you-go financing will save the amount of interest which otherwise would be paid on bonds issued to finance the program. The government is not encumbered by as much debt service when economic conditions deteriorate due to normal business cycles. Since the use of current revenues can be adjusted in a given budget year, pay-as-you-go financing can provide greater budgetary flexibility than does a debt issue. The jurisdiction’s long-term debt capacity is preserved for the future. Finally, lower debt ratios may have a positive effect upon the jurisdiction’s credit rating. Relying on current revenues to finance capital improvements also presents several disadvantages. Exclusive reliance upon pay-as-you-go funds for capital improvements means that existing residents are obliged to pay for improvements that will benefit new residents who relocate to the area. If the jurisdiction is forced to finance the improvements within a single budget, the large capital outlay required for some projects may result in an onerous tax burden. The County must be careful to ensure that the use of current revenues for capital projects does not diminish its availability to respond to emergencies and ongoing mandated services. 3 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan Grants Government grants stem from a variety of sources, but the majority of grant revenues for capital projects come from federal and state governments. Grants often require a County matching contribution. Most grants require an application from the County, identifying specific improvements or equipment that will be purchased with the grant money. Short-Term Borrowing (Notes) Tax Anticipation Notes (TANs) are notes issued in anticipation of the collection of taxes, as referenced in the Arizona Revised Statutes (A.R.S.), Title 35, Chapter 3, Article 3.1. They provide operating funds to meet regular payroll and other operating expenses. During the fiscal year when tax payments are received, sufficient sums are used to retire the note. The timing of the note sale, the note’s due date, and repayment of funds are all components of cash flow and cash management analysis. The County last issued a TAN in August 1995 for $40 million, which matured on July 31, 1996. The TAN was retired and the County has not needed to issue additional TANs. Lines and Letters of Credit – Where their use is judged by the Chief Financial Officer to be prudent and advantageous to the County, the County has the power to enter into agreements with commercial banks or other financial entities for purposes of acquiring lines or letters of credit. The Board of Supervisors must approve any agreement with financial institutions for the acquisition of lines or letters of credit. On July 1, 2001, the County entered into a $35,000,000 municipal revolving line of credit with an interest rate of 65% of the bank’s prime rate and a maturity date of June 30, 2005. The municipal revolving line of credit was renewed to July 1, 2006, for $35,000,000. Outstanding principal and interest is due on June 30 of each year. During fiscal year 2005, the County had not borrowed against the line of credit. On July 1, 2004, the County entered into an $8,503,093 irrevocable standby letter of credit issued to the Industrial Commission of Arizona for unfunded workers’ compensation claims. The irrevocable standby letter of credit matured on July 1, 2005. The letter of credit was reserved against the municipal revolving line of credit. During fiscal year 2005, the letter of credit had not been drawn upon. The irrevocable standby letter of credit was renewed to July 1, 2006 for $8,031,435. General Obligation Bonds (GO) Bond security is the taxing power of the state or local government, as referenced in the A.R.S., Title 35, Chapter 3, Article 3, for new GO bonds and Title 35, Chapter 3, Article 4 for refunding bonds. An issuer selling a general obligation bond secured by its full faith and credit attaches to that issue its broadest pledge. This makes the security of these bonds very high. The full faith and credit backing of a GO bond includes the pledge of all general revenues, unless specifically limited, as well as, the legal means to raise tax rates to cover debt service. The public entity is authorized to levy property taxes or to draw from other unrestricted revenue streams such as sales or income taxes to pay the bond’s principal and interest. Interest rates on these bonds are generally the 4 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan lowest of any public securities due to this superior security. Prior to issuance, Arizona GO bonds must have a majority vote approval from the residents of the County. Revenue Bonds Revenue bonds are long-term debt instruments retired by specific dedicated revenues. Often these revenues are generated by the project funded out of debt proceeds. Revenue bonds are designed to be self-supporting through user fees or other special revenues. The general taxing powers of the jurisdiction are not pledged. The debt created through the issuance of revenue bonds is to be repaid by the earnings from the operations of a revenue producing enterprise, from special taxes, or from contract leases or rental agreements. County revenue bonds do not burden the constitutional or statutory debt limitation placed on the County because they are not backed by the full faith and credit of the issuer. The underlying security is the only revenue stream pledged to pay the bond principal and interest. Special Assessment Bonds Special Assessment Bonds are issued to districts that are within a legally designated geographic area located within the County, which through the consent of the affected property owners pay for basic infrastructure and public improvements to the area through a supplemental assessment. This financing approach achieves the objective of tying the repayment of debt to those property owners who most directly benefit from the improvements financed. Certificates of Participation (COP) Certificates of Participation represent proportionate interests in semiannual lease payments. Participation in the lease is sold in the capital markets. The County’s obligation to make lease payments is subject to annual appropriations made by the County for that purpose. Rating agencies typically give Certificate of Participation issues a grade below that of general obligation bonds. A.R.S., Title 11, Chapter 2, Article 4, §11-251, Paragraph 46, provides for a maximum repayment term of twenty five years for the purchase or improvement of real property. Lease-Purchase Lease-Purchase financing provides long-term financing through a lease (with a mandatory purchase provision). This method does not constitute indebtedness under a state or local government’s constitutional debt limit and does not require voter approval. In a lease-purchase transaction, the asset being financed can include new capital asset needs or assets under existing lease agreements. Installment Purchase Agreement Same as a lease purchase agreement with the exception that the County takes title to the property up front. 5 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan Debt Limit The Arizona Constitution, Article 9, Section 8, states that a County indebtedness pertaining to general obligation bonds may not exceed six percent of the value of the County’s taxable property ascertained by the last assessment. All general obligation bonds must be approved by voters regardless of amount issued up to the six percent limit. The County may issue non-general obligation bonds without voter approval up to six percent of the taxable property. However, with voter approval, the County may become indebted for an amount not to exceed fifteen percent of such taxable property. The following table represents the County’s outstanding general obligation indebtedness with respect to its constitutional general obligation debt limitation. 2004-05 Constitutional General Obligation Bonding Capacity Maricopa County, Arizona 2004-05 Secondary Assessed Valuation 15% of Secondary Assessed Valuation Less: GO Bonded Debt Outstanding Plus: GO Debt Service Fund Balance Unused Fifteen Percent Borrowing Capacity $ 30,066,986,673 $ 4,510,048,001 4,510,048,001 Rating Agency Analysis Independent assessments of the relative credit worthiness of municipal securities are provided by rating agencies. They furnish letter grades that convey their assessment of the ability and willingness of a borrower to repay its debt in full and on time. Credit ratings issued by these agencies are a major function in determining the cost of borrowed funds in the municipal bond market. Moody’s Investors Service, Standard and Poor’s Corporation, and Fitch Ratings are the three major rating agencies that rate municipal debt. These rating agencies have provided a rating assessment of credit worthiness for Maricopa County. There are five primary factors that comprise their ratings: • • • • • Economic conditions – stability of trends, Debt-history of County – debt and debt position, Governmental/administration – leadership and organizational structure of the County, Financial performance – current financial status and the history of financial reports, Debt management – debt policies, including long-term planning. Each of the rating agencies has their own method of assigning a rating on the ability and willingness of a borrower to repay in full and on time. Issuers must pay a fee for the opportunity to have one or more rating agencies rate existing and proposed debt issuance. The following chart outlines how the ratings reflect creditworthiness, ranging from very strong securities to speculative and default situations. 6 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan Examples of the rating systems are: RATING AGENCIES BOND RATINGS Explanation of corporate/municipal bond ratings Fitch Moody’s Standard & Poor’s Premium quality High quality Medium quality AAA AA A Aaa Aa A AAA AA A Medium grade, lower quality Predominantly speculative Speculative, low grade BBB BB B Baa Ba B BBB BB B Poor to default Highest speculation Lowest quality, no interest CCC CC C Caa Ca C CCC CC C In default, in arrears Questionable value DDD DD D DDD DD D Fitch and Standard & Poor’s may use “+” or “-” to modify ratings while Moody’s may use numerical modifiers such as 1 (highest), 2, or 3. History of Debt Rating On November 11, 2003, Maricopa County received a bond rating upgrade from AA to AA+ from Fitch Ratings. Fitch Ratings Press Release dated November 11, 2003, states that the bond rating “upgrades are based on the imminent transfer of the county’s health care delivery system to a separate voter-approved special health district with its own property tax levy. The upgrades also reflect continued financial improvement despite slower growth in the county’s predominant revenue source, a record of continued economic growth and diversification, successful fiscal reforms, and the county’s very modest debt profile.” The County’s bond ratings can be viewed on the Department of Finance’s webpage at the following location: http://www.maricopa.gov/Finance 7 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan The following illustrates a history of the County’s various debt ratings. Type of Debt General Obligation Fitch AA+ AA AA Date Date Date Rating Rating Standard & Rating Assigned Moody's Assigned Poor's Assigned 11/11/03 Aa3 12/6/01 A+ 4/11/97 12/4/01 Aa3 5/26/00 A 5/27/94 4/5/00 A-1 11/6/98 AA 6/2/76 A-2 3/17/97 A 6/13/94 Aa 7/26/93 Aa-1 8/21/81 Aa 12/6/72 Stadium District Revenue Bonds Aaa (1) AAA (1) (1) Bonds are insured, no underlying rating. Ratio Analysis Rating analysts compare direct net debt to the population in order to measure the size or magnitude of the County’s debt. This ratio is referred to as the Direct Net Debt Per Capita Ratio. The same ratio is applied to all debt within the County which includes School Districts, Cities and Towns, and Special Districts. This ratio is referred to as the Overall Net Debt Per Capita Ratio. The taxable value of the County is a measure of the County’s wealth. It also reflects the capacity of the County’s ability to service current and future debt. The ratio of Direct Net Debt as a percentage of Full Value (FV) Property is the comparison of direct net debt to the County's taxable value. The same ratio is applied to all debt within the County and is referred to as the Overall Net Debt as a percentage of Full Value Property. The Full Value Property Per Capita ratio represents the per capita value of taxable property in the County. An explanation of how each ratio is calculated is included in the notes adjacent to the following tables. There are an infinite number of ratios, which could be calculated to measure the County’s debt burden. The following analysis focuses on commonly used ratios instead of creating customized ones. The ratios calculated are for governmental activities and do not include business-type activities. The source of repayment is from either the secondary tax levy or by appropriation from the general fund for debt service payments. Debt for which there is a source of repayment; i.e. pledged revenues for car rental service charge, debt service has been excluded. 8 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan DIRECT AND OVERALL NET DEBT MARICOPA COUNTY, ARIZONA Audited 6/30/04 GOVERNMENTAL ACTIVITES Audited 6/30/05 Projected 6/30/06 Projected 6/30/07 General Obligation $ 20,165,000 $ 0 $ 0 $ 0 Lease Revenue Bonds (5) 110,240,000 101,145,000 91,830,000 82,325,000 Lease Purchase Agreement 0 10,812,000 9,451,000 8,031,000 Certificate of Participation (5) 5,865,000 5,500,000 5,115,000 4,715,000 Capital Leases 10,820,105 13,507,633 7,384,236 2,410,253 Installment Purchase Agreement (5) 1,252,049 892,254 546,202 205,765 $ 148,342,154 $ 131,856,887 $ 114,326,438 $ 97,687,018 Direct Net Debt Overlapping Debt (1) 5,343,308,638 5,861,863,210 6,198,920,345 6,555,358,264 $ 5,491,650,792 $ 5,993,720,097 $ 6,313,246,783 $ 6,653,045,282 Overall Net Debt Population Estimate (2) Full Value of Taxable Property (3) $ 3,254,363 226,293,569 $ 3,329,561 253,264,911 $ 3,405,237 276,058,753 $ 3,480,881 300,904,041 Direct Net Debt Per Capita $ 45.58 $ 39.60 $ 33.57 $ 28.06 Overall Net Debt Per Capita $ 1,687.47 $ 1,800.15 $ 1,853.98 $ 1,911.31 Ratios (4) Direct Net Debt As Percentage Of Full Value Property Overall Net Debt As % Of FV Property FV Property Per Capita $ 0.066% 0.052% 0.041% 0.032% 2.43% 2.37% 2.29% 2.21% 69,535.44 $ 76,065.56 $ 81,068.88 $ 86,444.79 Notes: (1) Projected overlapping debt for 2006 and 2007 was based on a three year average of 5.75%. -General Obligation Bonds for: Cities, Towns, School Districts and Special Assessment Districts. Source: www.azdor.gov/ResearchStats/bonding/05-0002i.pdf (2) Source: www.workforce.az.gov, projections for 2005 and 2006 are based on a 2.22% estimated annual growth rate. (3) Secondary Valuation Taxable Property Estimates: 2005 provided by the Assessor’s Office; 2006 and 2007; based on a 9% estimated annual growth; amounts are in billions (000’s omitted). (4) Summary of Debt Ratios: • Direct Net Debt per capita = Direct Net Debt/Population • Overall Net Debt per capita = Overall Net Debt/Population • Direct Net Debt as a percentage of full value property (FV) = Direct Net Debt/FV property • Overall Net Debt a percentage of FV Property = Overall Net Debt/FV property • FV property per capita = FV Property/Population 9 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan (5) Governmental activities direct and overall net debt includes the applicable portion of outstanding debt obligations that were reclassified from the transition of the Maricopa County Medical Center (businesstype activity) to the Maricopa County Special Health Care District, a separate legal entity. The debt obligations are included in the calculation as they are a direct obligation to the County and are not paid from pledged revenues. Maricopa County will be reimbursed by the Maricopa County Special Health Care District for the debt service payments paid on behalf of the County as provided for in the Intergovernmental Agreement. The following section of the Debt Management Plan contains information on the obligations of Maricopa County by debt type. General Obligation Bonds Long-term General Obligation Bonds shall be issued to finance significant capital improvements for purposes set forth by voters in bond elections. Interest rates on these bonds are generally the lowest of any public securities. Prior to issuance, Arizona General Obligation Bonds must have a majority vote approval from the residents of the County. Recently retired General Obligation Bonds were the result of the 1986 general election where the voters authorized the County to issue long-term debt. The resulting proceeds from the sale of the bonds were used for the purpose of making improvements in the County which included Criminal and Civil Courts Facilities, Juvenile Court – Juvenile Treatment and Detention Facilities, Law Enforcement and Public Safety, Regional Park Improvements, Environmental Protection, Sanitary Landfill, Public Health Facilities, Infrastructure, Communication Improvements, etc. Legal Debt Margin – County indebtedness pertaining to general obligation bonds may not exceed six percent of the value of the County’s taxable property ascertained by the last assessment. However, with voter approval, the County may become indebted for an amount not to exceed 15 percent of such taxable property. At June 30, 2005, the County had no outstanding general obligation debt, (0.00% of taxable property), while the 6 percent limit was $1,804,019,200 and the 15 percent limit was $4,510,048,001. Lease Revenue Bonds On June 1, 2001, the Maricopa County Public Finance Corporation issued $124,855,000 of Lease Revenue Bonds to pay for the acquisition, construction and equipment for a planned Public Service Building, Forensic Science Center, Superior Court Customer Service Center, parking garages and related projects. Under the terms of the bond indentures the Corporation received the proceeds to construct and purchase these assets and the County will make lease payments to extinguish the debt. Lease payments will equal the aggregate amount of principal and interest due at that date. Upon the final lease payment, the title to the assets will transfer to the County. The County’s obligation to make lease payments will be subject to and dependent upon annual appropriations made by the County. 10 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan On December 3, 2003, the Maricopa County Public Finance Corporation issued Lease Revenue Refunding Bonds, Series 2003, of $16,880,000 (par value) with an interest rate ranging from 2.5% to 4% and maturing on July 1, 2012. The proceeds were used to advance refund the 2000 certificates of participation principal of $4,103,000, 1996 certificates of participation principal of $1,576,452, 1994 certificates of participation principal of $3,815,000, 1993 certificates of participation principal of $580,000, and several capital leases aggregating $11,104,817. The bonds were issued at a premium of $457,156 and debt service reserve accounts previously established totaling $4,461,354 were used for the current refunding and to pay cost of issuance expense. Under the terms of the bond indentures, the Corporation received the proceeds to current refund County debt obligations and the County will make lease payments to extinguish the debt. The County will be obligated to pay on each lease payment date an amount equal to the lease payments then due. The County’s obligation to pay the lease payments will continue until all lease payments due under the lease have been paid. The County’s obligation to make lease payments will be subject to and dependent upon annual appropriations made by the County. DEBT SERVICE REQUIREMENTS TO MATURITY Lease Revenue Bonds Maricopa County, Arizona As of June 30, 2005 Governmental Activities Year Ending June 30 2006 2007 2008 2009 2010 2011-15 2016 Total Principal $ 9,308,434 9,498,024 8,477,750 8,592,477 8,890,076 46,069,740 10,265,000 $ 101,101,501 Business-Type Activities Interest Principal $ 4,874,068 $ 6,566 $ 4,434,264 6,976 4,044,588 7,250 3,671,791 7,524 3,238,803 4,924 9,076,726 10,259 278,525 $ 29,618,765 $ 43,499 $ Interest 1,291 1,021 791 587 394 319 4,403 On January 1, 2005, the Maricopa County Medical Center (business-type activity) was transitioned to the Maricopa County Special Health Care District, a separate legal entity. The following represents the reimbursement schedule for debt service obligations to Maricopa County from the Maricopa County Special Health Care District as provided for in the Intergovernmental Agreement. 11 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan REIMBURSEMENT REQUIREMENTS TO MATURITY Special Health Care District (Lease Revenue Bonds) Maricopa County, Arizona As of June 30, 2005 Year Ending June 30 2006 2007 2008 2009 2010 2011-15 2016 Total Principal $ 1,458,937 1,530,562 1,606,741 1,478,163 1,526,943 6,270,806 1,335,273 $ 15,207,425 $ $ Interest 694,342 626,269 563,380 503,181 435,430 1,179,934 36,231 4,038,767 Total Debt Service $ 2,153,279 2,156,831 2,170,121 1,981,344 1,962,373 7,450,740 1,371,504 $ 19,246,192 SUMMARY OF LEASE REVENUE BOND AMOUNTS OUTSTANDING BY ISSUE As of June 30, 2005 Bond Issue 2001 Lease Revenue Bonds 2003 Lease Revenue Refunding Bonds Total Amount 87,580,000 13,565,000 $ 101,145,000 $ Lease Purchase Agreement On August 28, 2004, the Maricopa County Public Finance Corporation entered into a Lease Purchase Agreement with a financial institution not to exceed $15,000,000 with a fixed interest rate of 4.165% and maturing on June 1, 2012. The Lease Purchase Agreement will be on a draw down basis and will be re-amortized after each draw down. The purpose of the Lease Purchase Agreement is to provide financing for the construction and capital equipment for the Human Services Project. The County is obligated to make the principal and interest payments on the amounts borrowed under this agreement. As of June 30, 2005, the County had not drawn the remaining $3,000,000 from the lease purchase agreement. 12 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan DEBT SERVICE REQUIREMENTS TO MATURITY Lease Purchase Agreement Maricopa County, Arizona As of June 30, 2005 Year Ending June 30 2006 2007 2008 2009 2010 2011-12 Total Principal $ 1,361,000 1,420,000 1,478,000 1,539,000 1,604,000 3,410,000 $ 10,812,000 $ $ Interest 449,615 393,625 334,483 272,926 208,828 214,492 1,873,969 Total Debt Service $ 1,810,615 1,813,625 1,812,483 1,811,926 1,812,828 3,624,492 $ 12,685,969 SUMMARY OF PRINCIPAL AMOUNT OUTSTANDING BY ISSUE As of June 30, 2005 Lease Purchase Agreement Issue Total Lease Purchase Agreement, Series 2004 Amount $ 10,812,000 Stadium District The Stadium District was formed through action of the Maricopa County Board of Supervisors in September 1991 pursuant to the A.R.S., Title 48, Chapter 26. The Stadium District has two purposes: • To oversee the operation and maintenance of Bank One Ballpark, a major league baseball stadium, and • Enhance and promote major league baseball spring training in the County through the development of new, and the improvement of, existing baseball training facilities. To accomplish this purpose, the Stadium District possesses the statutory authority to issue special obligation bonds to provide financial assistance for the development and improvement of baseball training facilities located within the County. Ten major league baseball teams hold spring training in Arizona as part of the Cactus League: California Angels, Chicago Cubs, Colorado Rockies, Milwaukee Brewers, Oakland Athletics, San Diego Padres, San Francisco Giants, Seattle Mariners, Chicago White Sox and Arizona Diamondbacks. The Stadium District Revenue Bonds are special obligations of the District. The bonds are payable solely from pledged revenues, consisting of car rental surcharges levied and collected by the District pursuant to A.R.S., Title 48, Chapter 26, Article 2, §48-4234. Under the statute, the District may set the surcharge at $2.50 on each lease or rental of a motor vehicle licensed for hire, for less than one year, and designed to carry fewer than 15 passengers, regardless of whether such vehicle is licensed in the State of Arizona. The District Board of Directors initially levied a surcharge at a rate of $1.50 beginning in January 1992. The District Board of Directors increased the surcharge to $2.50, the maximum amount permitted by statute, in January 1993. 13 Maricopa County, Arizona Department of Finance Debt Management Division Debt Managem M ent Plan The bond ds do not constitute a debt d or a plledge of the e faith or cre edit of Mariccopa Countyy, the State of Arizona, or any other political p subd division. Th he payment of the bond ds is enforce eable solely ou ut of the pled dged revenues and no owner o shall have h any rig ght to compe el any exerciise of taxing po ower of the District, D exce ept for surcharges. owing tables s illustrate the t existing debt servicce for the outstanding o Stadium District D The follo Revenue e Bonds. DEBT SERVICE REQ QUIREMENT TS TO MATU URITY Sttadium Disttrict Revenu ue Bonds Maricopa a County, Arrizona As of June J 30, 20 005 Yea ar Ending J June 30 2006 2007 2008 2009 2010 2011 – 15 2016 – 19 Total Principal P $ 2,685,000 2 2 2,820,000 2 2,960,000 3 3,105,000 3 3,260,000 18 8,850,000 19 9,055,000 $ 52 2,735,000 $ $ Interest 2,737,592 2,603,345 2,462,344 2,314,344 2,159,094 8,252,244 2,627,568 23,156,531 Total Deb bt Service 5,422,592 $ 5,423,345 5,422,344 5,419,344 5,419,094 2 27,102,244 2 21,682,568 $ 7 75,891,531 SUMM MARY OF PRINCIPAL P A AMOUNT OUTSTANDIN NG BY ISSU UE As of June 30, 20 005 Bon nd Issue Tota al Stadium District D Reven nue Bonds, Series S 2002 $ Am mount 5 52,735,000 DEBT SERVICE REQUIR D REMENTS S Stadium Disttrict Revenu ue Bonds In nterest $6,000,000 $ $4,000,000 $ $2,000,000 $ $0 14 2018 2016 2014 2012 2010 2008 2006 P Principal Ma aricopa County, Arizona A Department of Finance F Deb bt Management Division D Debt Management Plan Stadium District Contractual Commitments On February 17, 1994, the Stadium District entered into an agreement with the Arizona Diamondbacks (Team) to provide for the financing of a portion of the costs of acquisitions and construction of a new major league baseball stadium. In connection with the agreement, the Stadium District committed to provide up to $253,000,000 for the cost of the new stadium. The $253,000,000 was funded through the use of $238,000,000 of the special sales tax levy imposed on April 1, 1995. Under the Facility Development Agreement for the major league baseball stadium, the Stadium District was obligated to obtain a loan in the amount not to exceed $15 million to pay for part of the Stadium District’s portion of construction costs. The Team agreed to include the Stadium District loan in its financing in order to allow the Stadium District to obtain more favorable financing terms, and the Stadium District agreed to repay the Team for this increase in the Team’s borrowing. At June 30, 2005, the Stadium District had contractual commitments outstanding of $4,428,888 with a fixed interest rate of 7.15%. DEBT SERVICE REQUIREMENTS TO MATURITY Stadium District Contractual Commitments Maricopa County, Arizona As of June 30, 2005 Year Ending June 30 2006 2007 2008 2009 2010 2011 – 15 2016 – 19 Total Principal $ $ Interest 316,841 316,841 316,841 316,841 316,841 1,266,251 314,058 3,164,514 $ 2,222,224 2,206,664 4,428,888 $ $ $ Total Debt Service 316,841 316,841 316,841 316,841 316,841 3,488,475 2,520,722 7,593,402 Special Assessment Districts A Special Assessment District (County Improvement District) process begins with the circulation of a petition. The petition must be signed by either a majority of the persons owning real property or by the owners of fifty-one percent or more of the real property within the limits of the proposed district. With the approval of the petition by the Board of Supervisors, a new improvement district is established. County Improvement Districts are further described in A.R.S., Title 48, Chapter 6, Article 1. With the Board of Supervisors acting as the Board of Directors for each district, approval of an engineer, and the approval of plans, specifications and cost estimates soon follow. Each of these early phases of the improvement district process contain regulations for public notification through posting of the property, publication in the local newspaper, and the set up of a protest period. 15 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan Once the Board of Supervisors approves the awarding of the bid, construction follows. Since the residents pay for these improvements, an assessment is levied against each property owner. Depending on the type of improvement, some assessments are carried on the property tax roll, while others are collected through the County Improvement District Office. If the property owners are unable to prepay the improvement assessment within 30 days after the completion of the work, bonds are sold for the balance of the construction amount. The bonds are collateralized by properties within the District. The receivable is held by the Improvement District, and billed on a semi-annual basis. In cases of a delinquent payment of an assessment, the lien including penalty and interest may be sold at a public auction. If there is no purchaser for the lien, the District (not the County) will assume, as a general obligation, the amount of the assessment and interest accruing thereon. The following table illustrates the outstanding principal amount by issue for the Special Assessment District Bonds. SUMMARY OF PRINCIPAL AMOUNT OUTSTANDING BY ISSUE As of June 30, 2005 Bond Issue Queen Creek Water Fairview Lane East Fairview Lane White Fence Farms 104th Place/University Drive Central Avenue Billings Street Marquerite Drive 7th Street North Total Amount $ 56,252 5,082 7,250 24,195 14,086 46,207 2,280 26,053 54,053 $ 235,458 Certificates of Participation Certificates of Participation represent proportionate interests in semiannual lease payments. The County’s obligation to make lease payments is subject to annual appropriations made by the County for that purpose. On November 1, 2000, Maricopa County Public Finance Corporation issued $6,975,000 of Certificates of Participation to pay for the cost of construction for the Desert Vista Health Center. The following schedule shows all outstanding debt service for the Certificates of Participation as of June 30, 2005. On January 1, 2005, the outstanding debt obligations were reclassified from the transition of the Maricopa County Medical Center (business-type activity) to the Maricopa County Special Health Care District, a separate legal entity. Maricopa County will pay the debt service including principal and interest as they become due and payable and will request reimbursement from the Maricopa County Special Health Care District as provided for in the Intergovernmental Agreement. The following schedule reflects the Maricopa County debt service requirements which will be reimbursed by the Maricopa County Special Health Care District as provided for in the Intergovernmental Agreement. 16 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan DEBT SERVICE REQUIREMENTS TO MATURITY Certificates of Participation Maricopa County, Arizona As of June 30, 2005 Governmental Activities Year Ending June 30 2006 2007 2008 2009 2010 2011 – 15 2016 Total Principal 385,000 400,000 420,000 445,000 465,000 2,740,000 645,000 $ 5,500,000 $ Interest 271,786 253,043 233,258 212,170 189,759 555,147 17,737 $ 1,732,900 $ SUMMARY OF PRINCIPAL AMOUNT OUTSTANDING BY ISSUE As of June 30, 2005 Certificate of Participation Issues Total Certificates of Participation, Series 2000 $ Amount 5,500,000 Capital Leases (Lease-Purchase Obligations) Maricopa County uses lease-purchase financing to expand its borrowing power. This financing technique provides long-term financing through a lease (with a mandatory purchase provision). Lease-purchase agreements use non-appropriation clauses to avoid being classified as long-term debt, which might be subject to State legal restrictions. This clause allows the government to terminate the lease without penalty. However, because it is not likely that the County would be willing to forego the property, lease-purchase agreements are considered long-term obligations for policy planning purposes, regardless of the legal structure. The County maintains many capital leases, with the majority relating to the computer equipment refresh program where most personal computers are replaced every three years. The security for lease-purchase financing is the lease payments made by the County and, where legally permitted, also the asset being financed. The following schedule shows all outstanding capital leases as of June 30, 2005. 17 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan Capital Leases Governmental Activities Maricopa County, Arizona Fiscal Year Ending June 30, 2005 2006 2007 2008 2009 2010 Total minimum lease payments Less: Amount representing interest Present value of net minimum lease payments $ 6,405,779 5,078,806 2,436,634 27,195 18,130 13,966,544 (458,911) $ 13,507,633 Installment Purchase Contracts Payable The County has entered into installment purchase contracts payable for the acquisition of medical equipment used in the Maricopa County Special Health Care District The Maricopa County Special Health Care District is obligated to reimburse the County for the debt service payments as provided for in the Intergovernmental Agreement. The total purchase price of the capital equipment was $2,382,705. The future minimum payments required under the contracts at June 30, 2005, are as follows. Installment Purchase Contracts Payable Governmental Activities Maricopa County, Arizona Fiscal Year Ending June 30, 2005 2006 2007 2008 Total minimum lease payments Less: Amount representing interest Present value of net minimum lease payments 18 $ $ 378,731 358,051 208,863 945,645 (53,391) 892,254 Maricopa County, Arizona Department of Finance Debt Management Division DEBT POLICIES 19 Maricopa County, Arizona Department of Finance Debt Management Division 20 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan DEBT POLICIES Regular, updated debt policies can be an important tool to ensure the use of the County’s resources to meet its financial commitments to provide needed services to the citizens of Maricopa County and to maintain sound financial practices. Administration of Policy The County Manager is the Chief Executive of the County. With the exception of those responsibilities specifically assigned by state statute to the Chief Financial Officer, the County Manager is ultimately responsible for the approval of any form of County borrowing. The Chief Financial Officer coordinates the administration and issuance of debt, as designated by the County Manager. The Chief Financial Officer is also responsible for attestation of disclosure and other bond related documents. References to the “County Manager or his designee” in bond documents are hereinafter assumed to assign the Chief Financial Officer as the “designee” for administration of this policy. Use of Debt Financing Debt financing includes General Obligation Bonds, Revenue Bonds, Certificates of Participation, Lease/Purchase agreements, and other obligations permitted to be issued or incurred under Arizona law. Method of Sale Debt issues of the County may be sold by competitive, negotiated, or private placement sale methods unless otherwise limited by state law. The selected method of sale will be the option which is expected to result in the lowest cost and most favorable terms given the financial structure used, market conditions, and prior experience. Competitive Sale The County will use the competitive sale method unless there are compelling reasons which indicate that a negotiated sale or private placement would have a more favorable result due to prevailing conditions in the market, a financing structure which requires special pre-marketing efforts, or factors are present that are expected to result in an insufficient number or competitive bids. Advantages of using a competitive sale is that the issuer is getting the lowest net interest cost on that day time and all parties are given an equal opportunity, but timing is very inflexible. Negotiated Sale When determined appropriate, the County may elect to sell its debt obligations through a negotiated sale. Such determination may be made on an issue by issue basis, for a series of issues, or for part or all of a specific financing program. Negotiated underwriting may be considered upon recommendation of the Chief Financial Officer. Advantages of a negotiated sale is that timing is extremely flexible, the size of the issue can be easily changed at last minute and the issuer has influence over the underwriter selection and bond distribution. 21 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan Use of Bond Insurance This is an insurance policy purchased by an issuer or an underwriter for either an entire issue or specific maturities. It will guarantee the payment of principal and interest, which in turn provides a higher credit rating and thus a lower borrowing cost for an issuer. The present value of the estimated debt service savings from insurance should be at least equal to or greater than the insurance premium when insurance is purchased directly by the County. The bond insurance company will usually be chosen based on an estimate of the greatest net present value insurance benefit (present value of debt service savings less insurance premium). Arbitrage Liability Management Arbitrage is defined as the practice of simultaneously buying and selling an item in different markets in order to profit from a spread in prices or yields resulting from market conditions. Arbitrage profits are made by selling tax-exempt bonds and investing the proceeds in higheryielding taxable securities, when referencing municipal bonds. Municipal issuers are allowed to make arbitrage profits under certain restricted conditions. The sale of tax-exempt bonds primarily for the purpose for making arbitrage profits is prohibited by Section 103(c) of the Internal Revenue Code. The Debt Management Division of the Department of Finance shall establish a system of record keeping and reporting to meet the arbitrage rebate compliance requirements of the federal tax code. This will include tracking investment earnings on bond proceeds, using outside experts to assist in calculating rebate payments, preparing returns, and making payments in a timely manner in order to preserve the tax exempt status of the County’s outstanding debt issues. Additionally, general financial reporting and certification requirements embodied in bond covenants will be monitored to ensure that all covenants are met. The County will structure its financing in such a way as to reduce or eliminate future Arbitrage Rebate liability, wherever feasible. Selection of Professional Services The Chief Financial Officer shall be responsible for establishing a solicitation and selection process for securing professional services that are required to develop and implement the County’s debt program. Goals of the solicitation and selection process shall include encouraging participation from qualified service providers, both local and national, and securing services at competitive prices. Bond Counsel – To render opinions on the validity, enforceability and tax exempt status of the debt and related legal matters, and to prepare the necessary resolutions, agreements and other documents. 22 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan Financial Advisor – To advise on the structuring of obligations to be issued, inform the County of various options, advise the County as to how choices will impact the marketability of County obligations and provide other services as defined by contract. To ensure independence, the financial advisor will not bid on nor underwrite any County debt issues. Competitive proposals will be taken periodically for services to be provided over a period of one year with annual renewal options. Other professional services will be retained, when required, including managing underwriters, credit agencies, escrow agents, trustees, printers, and others. These services will be procured when in the best interest of the County by a competitive selection process. Continuing Disclosure of County Financial Information Annual financial statements and other pertinent credit information, including the Comprehensive Annual Financial Report (CAFR), will be provided by the County upon request. A copy of the CAFR can be viewed from the Maricopa County home page at: http://www.maricopa.gov/finance/. All material that has a pertinent bearing on County finances will be provided to the agencies that maintain a rating on County securities. The Chief Financial Officer shall be responsible for providing ongoing disclosure information to established national information repositories and for maintaining compliance with disclosure standards dictated by state and national regulatory bodies. Copies of official statements for future issuance’s of its bonds will be available through the following recognized municipal repositories: Bloomberg Municipal Repositories 100 Business Park Drive Skillman, NJ 08558 Phone: (609) 279-3225 Fax: (609) 279-5962 Email: Munis@Bloomberg.com DPC Data Inc. One Executive Drive Fort Lee, NJ 07024 Phone: (201) 346-0701 Fax: (201) 947-0107 Email: nrmsir@dpcdata.com FT Interactive Data Attn: NRMSIR 100 Williams Street, 15th Floor New York, NY 10038 Phone (212) 771-6999; (800) 689-8466 Fax: (212) 771-7390 Email: NRMSIR@Interactivedata.com Standard & Poor’s Security Evaluations, Inc. 55 Water Street – 45th Floor New York, NY 10041 Phone: (212) 438-4595 Fax: (212) 438-3975 Email: nrmsir_repository@sandp.com The Securities and Exchange Commission released final “continuing disclosure” rules (the “Rules”) for municipal bond issues on November 10, 1994, (amended existing Rule 15c2-12). The Rules, which in general were effective on July 3, 1995, impact nearly every issuer of municipal securities. The stated purpose of the Rules is to deter fraud and manipulation in the municipal securities market by prohibiting the underwriting and subsequent recommendation of securities for which adequate information is not available. No underwriter can purchase or sell 23 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan bonds in an offering of more than $1,000,000 after July 3, 1995, unless it has reasonably determined that an issuer has undertaken to provide to the public information repositories on a continuing basis both annual financial information and notices of specified material events affecting the issuer or its securities. This is applicable unless an exemption applies. The County intends to fully comply with the “continuing disclosure” rules. Maturity Structures Principal payment schedules should not extend beyond the economic life of the project or equipment financed. The structure of debt issued by the County should be to provide for either level principal or level debt service. Except in select instances, deferring the repayment of principal should be avoided. Ratings The County’s goal is to maintain or improve its bond ratings. To that end, prudent financial management policies will be adhered to in all areas. The Chief Financial Officer shall be responsible for maintaining relationships with the rating agencies that currently assign ratings to the County’s various debt obligations. The County will maintain a line of communication with the rating agencies informing them of major financial events in the County as they occur. Full disclosure of operations will be made to the bond rating agencies. County staff, with the assistance of the financial advisor and bond counsel, will prepare the necessary materials for presentation to the rating agencies. A personal meeting with representatives of the rating agencies will be scheduled every few years or whenever a major project is initiated. Modification to Policies These policies will be reviewed annually and significant changes may be made with the approval of the County Manager. Significant policy changes will be presented to the Board of Supervisors for approval. 24 Maricopa County, Arizona Department of Finance Debt Management Division INDIVIDUAL DEBT SERVICE SCHEDULES 25 Maricopa County, Arizona Department of Finance Debt Management Division 26 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan INDIVIDUAL DEBT SERVICE SCHEDULES LEASE REVENUE BONDS LEASE PURCHASE AGREEMENT STADIUM DISTRICT SPECIAL ASSESSMENT CERTIFICATES OF PARTICIPATION CAPITAL LEASES INSTALLMENT PURCHASE CONTRACTS PAYABLE 27 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan MARICOPA COUNTY, ARIZONA TOTAL LEASE REVENUE BONDS LEASE REVENUE BONDS REDEMPTION SCHEDULE DATE 7/1/2005 1/1/2006 7/1/2006 1/1/2007 7/1/2007 1/1/2008 7/1/2008 1/1/2009 7/1/2009 1/1/2010 7/1/2010 1/1/2011 7/1/2011 1/1/2012 7/1/2012 1/1/2013 7/1/2013 1/1/2014 7/1/2014 1/1/2015 7/1/2015 1/1/2016 $ $ PRINCIPAL 9,315,000.00 9,505,000.00 8,485,000.00 8,600,000.00 8,895,000.00 9,380,000.00 8,765,000.00 9,030,000.00 9,205,000.00 9,700,000.00 10,265,000.00 101,145,000.00 $ $ INTEREST 2,544,980.00 2,330,380.00 2,330,380.00 2,104,905.00 2,104,905.00 1,940,473.75 1,940,473.75 1,731,905.00 1,731,905.00 1,507,292.50 1,507,292.50 1,269,827.50 1,269,827.50 1,036,900.00 1,036,900.00 796,012.50 796,012.50 542,875.00 542,875.00 278,525.00 278,525.00 29,623,172.50 28 PERIOD TOTAL 11,859,980.00 2,330,380.00 11,835,380.00 2,104,905.00 10,589,905.00 1,940,473.75 10,540,473.75 1,731,905.00 10,626,905.00 1,507,292.50 10,887,292.50 1,269,827.50 10,034,827.50 1,036,900.00 10,066,900.00 796,012.50 10,001,012.50 542,875.00 10,242,875.00 278,525.00 10,543,525.00 $ 130,768,172.50 $ FISCAL TOTAL 14,190,360.00 13,940,285.00 12,530,378.75 12,272,378.75 12,134,197.50 12,157,120.00 11,071,727.50 10,862,912.50 10,543,887.50 10,521,400.00 10,543,525.00 $ 130,768,172.50 $ Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan $124,844,000 MARICOPA COUNTY, ARIZONA LEASE REVENUE BONDS, SERIES 2001 LEASE REVENUE BONDS REDEMPTION SCHEDULE DATE 7/1/2005 1/1/2006 7/1/2006 1/1/2007 7/1/2007 1/1/2008 7/1/2008 1/1/2009 7/1/2009 1/1/2010 7/1/2010 1/1/2011 7/1/2011 1/1/2012 7/1/2012 1/1/2013 7/1/2013 1/1/2014 7/1/2014 1/1/2015 7/1/2015 1/1/2016 $ $ PRINCIPAL 6,065,000.00 6,385,000.00 6,740,000.00 7,020,000.00 7,395,000.00 7,830,000.00 8,265,000.00 8,710,000.00 9,205,000.00 9,700,000.00 10,265,000.00 87,580,000.00 $ $ INTEREST 2,311,230.00 2,161,630.00 2,161,630.00 1,998,555.00 1,998,555.00 1,855,936.25 1,855,936.25 1,671,067.50 1,671,067.50 1,470,830.00 1,470,830.00 1,256,615.00 1,256,615.00 1,031,500.00 1,031,500.00 796,012.50 796,012.50 542,875.00 542,875.00 278,525.00 278,525.00 28,438,322.50 29 PERIOD TOTAL 8,376,230.00 2,161,630.00 8,546,630.00 1,998,555.00 8,738,555.00 1,855,936.25 8,875,936.25 1,671,067.50 9,066,067.50 1,470,830.00 9,300,830.00 1,256,615.00 9,521,615.00 1,031,500.00 9,741,500.00 796,012.50 10,001,012.50 542,875.00 10,242,875.00 278,525.00 10,543,525.00 $ 116,018,322.50 $ FISCAL TOTAL 10,537,860.00 10,545,185.00 10,594,491.25 10,547,003.75 10,536,897.50 10,557,445.00 10,553,115.00 10,537,512.50 10,543,887.50 10,521,400.00 10,543,525.00 $ 116,018,322.50 $ Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan $16,880,000 MARICOPA COUNTY, ARIZONA LEASE REVENUE BONDS, SERIES 2003 LEASE REVENUE BONDS REDEMPTION SCHEDULE DATE 7/1/2005 1/1/2006 7/1/2006 1/1/2007 7/1/2007 1/1/2008 7/1/2008 1/1/2009 7/1/2009 1/1/2010 7/1/2010 1/1/2011 7/1/2011 1/1/2012 7/1/2012 $ $ PRINCIPAL 3,250,000.00 3,120,000.00 1,745,000.00 1,580,000.00 1,500,000.00 1,550,000.00 500,000.00 320,000.00 13,565,000.00 $ $ INTEREST 233,750.00 168,750.00 168,750.00 106,350.00 106,350.00 84,537.50 84,537.50 60,837.50 60,837.50 36,462.50 36,462.50 13,212.50 13,212.50 5,400.00 5,400.00 1,184,850.00 30 PERIOD TOTAL 3,483,750.00 168,750.00 3,288,750.00 106,350.00 1,851,350.00 84,537.50 1,664,537.50 60,837.50 1,560,837.50 36,462.50 1,586,462.50 13,212.50 513,212.50 5,400.00 325,400.00 $ 14,749,850.00 $ FISCAL TOTAL 3,652,500.00 3,395,100.00 1,935,887.50 1,725,375.00 1,597,300.00 1,599,675.00 518,612.50 325,400.00 $ 14,749,850.00 $ Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan $15,000,000 MARICOPA COUNTY, ARIZONA LEASE PURCHASE AGREEMENT, SERIES 2004 LEASE PURCHASE AGREEMENT REDEMPTION SCHEDULE DATE 12/1/2005 6/1/2006 12/1/2006 6/1/2007 12/1/2007 6/1/2008 12/1/2008 6/1/2009 12/1/2009 6/1/2010 12/1/2010 6/1/2011 12/1/2011 6/1/2012 PRINCIPAL $ $ 1,361,000.00 1,420,000.00 1,478,000.00 1,539,000.00 1,604,000.00 1,670,000.00 1,740,000.00 10,812,000.00 $ $ INTEREST 224,460.35 225,154.50 196,812.37 196,812.37 167,241.56 167,241.56 136,462.95 136,462.95 104,414.05 104,414.05 71,011.55 71,011.55 36,234.63 36,234.63 1,873,969.07 PERIOD TOTAL 224,460.35 1,586,154.50 196,812.37 1,616,812.37 167,241.56 1,645,241.56 136,462.95 1,675,462.95 104,414.05 1,708,414.05 71,011.55 1,741,011.55 36,234.63 1,776,234.63 $ 12,685,969.07 $ FISCAL TOTAL 1,810,614.85 1,813,624.74 1,812,483.12 1,811,925.90 1,812,828.10 1,812,023.10 1,812,469.26 $ 12,685,969.07 $ * $3,000,000 had not been drawn upon as of June 30, 2005 31 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan MARICOPA COUNTY, ARIZONA CALCULATED TOTAL OF ALL STADIUM DISTRICT BOND REDEMPTION SCHEDULE DATE 12/1/2005 PRINCIPAL $ 6/1/2006 INTEREST - $ 2,685,000.00 12/1/2006 - 6/1/2007 2,820,000.00 12/1/2007 - 6/1/2008 2,960,000.00 12/1/2008 - 6/1/2009 3,105,000.00 12/1/2009 - 6/1/2010 3,260,000.00 12/1/2010 - 6/1/2011 3,390,000.00 12/1/2011 - 6/1/2012 3,570,000.00 12/1/2012 - 6/1/2013 3,760,000.00 12/1/2013 - 6/1/2014 3,960,000.00 12/1/2014 - 6/1/2015 4,170,000.00 12/1/2015 - 6/1/2016 4,395,000.00 12/1/2016 - 6/1/2017 4,635,000.00 12/1/2017 - 6/1/2018 4,880,000.00 12/1/2018 - 6/1/2019 $ 5,145,000.00 52,735,000.00 $ PERIOD TOTAL 1,368,796.88 $ 1,368,796.88 1,368,796.88 4,053,796.88 1,301,671.88 1,301,671.88 1,301,671.88 4,121,671.88 1,231,171.88 1,231,171.88 1,231,171.88 4,191,171.88 1,157,171.88 1,157,171.88 1,157,171.88 4,262,171.88 1,079,546.88 1,079,546.88 1,079,546.88 4,339,546.88 1,014,346.88 1,014,346.88 1,014,346.88 4,404,346.88 925,359.38 925,359.38 925,359.38 4,495,359.38 831,646.88 831,646.88 831,646.88 4,591,646.88 730,596.88 730,596.88 730,596.88 4,690,596.88 624,171.88 624,171.88 624,171.88 4,794,171.88 512,103.13 512,103.13 512,103.13 4,907,103.13 393,987.51 393,987.51 393,987.51 5,028,987.51 269,421.88 269,421.88 269,421.88 5,149,421.88 138,271.88 138,271.88 138,271.88 23,156,531.40 32 $ 5,283,271.88 75,891,531.40 FISCAL TOTAL $ 5,422,593.76 5,423,343.76 5,422,343.76 5,419,343.76 5,419,093.76 5,418,693.76 5,420,718.76 5,423,293.76 5,421,193.76 5,418,343.76 5,419,206.26 5,422,975.02 5,418,843.76 - $ 5,421,543.76 75,891,531.40 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan MARICOPA COUNTY, ARIZONA CALCULATED TOTAL OF ALL SPECIAL ASSESSMENT BOND REDEMPTION SCHEDULES DATE 7/1/2005 1/1/2006 7/1/2006 1/1/2007 7/1/2007 1/1/2008 7/1/2008 1/1/2009 7/1/2009 1/1/2010 7/1/2010 1/1/2011 7/1/2011 1/1/2012 7/1/2012 1/1/2013 7/1/2013 1/1/2014 7/1/2014 1/1/2015 7/1/2015 1/1/2016 7/1/2016 1/1/2017 7/1/2017 1/1/2018 $ $ PRINCIPAL 5,471.21 43,154.92 6,549.82 41,047.14 5,828.10 14,145.41 8,871.31 24,775.99 10,298.81 6,005.86 10,298.81 6,005.86 10,298.81 6,005.86 5,230.59 6,005.86 3,232.95 6,005.92 4,231.77 4,231.77 3,529.38 4,231.60 235,457.75 $ $ INTEREST 8,671.29 8,272.99 6,361.05 6,147.67 4,330.58 4,245.68 3,737.06 3,443.38 2,358.49 2,273.59 2,180.16 1,822.25 1,582.01 1,224.10 983.86 898.97 658.73 579.93 339.69 254.79 254.79 169.90 169.90 85.00 85.00 61,130.86 33 PERIOD TOTAL 14,142.50 51,427.91 12,910.87 47,194.81 10,158.68 18,391.09 12,608.37 28,219.37 12,657.30 8,279.45 12,478.97 7,828.11 11,880.82 7,229.96 6,214.45 6,904.83 3,891.68 6,585.85 4,571.46 254.79 4,486.56 169.90 3,699.28 85.00 4,316.60 $ 296,588.61 $ FISCAL TOTAL 65,570.41 60,105.68 28,549.77 40,827.74 20,936.75 20,307.08 19,110.78 13,119.28 10,477.53 4,826.26 4,656.46 3,784.27 4,316.60 $ 296,588.61 $ Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan $301,960 MARICOPA COUNTY, ARIZONA Queen Creek Water K-91 BOND REDEMPTION SCHEDULE 4.875% DATE 07/01/05 PRINCIPAL $ 01/01/06 INTEREST 5,471.21 $ - 07/01/06 3,694.74 01/01/07 - 07/01/07 5,471.20 01/01/08 - 07/01/08 4,231.77 01/01/09 - 07/01/09 4,231.77 01/01/10 - 07/01/10 4,231.77 01/01/11 - 07/01/11 4,231.77 01/01/12 - 07/01/12 5,230.59 01/01/13 - 07/01/13 3,232.95 01/01/14 - 07/01/14 4,231.77 01/01/15 - 07/01/15 4,231.77 01/01/16 - 07/01/16 3,529.38 01/01/17 - 07/01/17 4,231.60 01/01/18 1,108.08 56,252.29 $ 1,012.78 1,012.78 4,707.52 927.88 927.88 927.88 6,399.08 842.99 842.99 842.99 5,074.76 758.09 758.09 758.09 4,989.86 673.19 673.19 673.19 4,904.96 588.29 588.29 588.29 4,820.06 503.39 503.39 503.39 5,733.98 418.50 418.50 418.50 3,651.45 339.69 339.69 339.69 4,571.46 254.79 254.79 254.79 4,486.56 169.90 169.90 169.90 3,699.28 85.00 85.00 85.00 4,316.60 $ 6,579.29 1,012.78 $ PERIOD TOTAL 14,257.05 34 FISCAL TOTAL $ 5,635.41 7,242.07 5,832.84 5,663.05 5,493.25 5,323.45 6,152.48 3,991.14 4,826.26 4,656.46 3,784.27 - $ 70,509.34 7,592.07 4,316.60 $ 70,509.34 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan $59,379 MARICOPA COUNTY, ARIZONA Fairview Lane K-92 SPECIAL ASSESSMENT BOND REDEMPTION SCHEDULE 9.00% DATE 07/01/05 01/01/06 PRINCIPAL $ $ 5,082.33 5,082.33 $ $ INTEREST 228.70 228.70 457.41 35 $ $ PERIOD TOTAL 228.70 5,311.03 5,539.74 FISCAL TOTAL $ $ 5,539.74 5,539.74 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan $60,657 MARICOPA COUNTY, ARIZONA East Fairview Lane K-93 SPECIAL ASSESSMENT BOND REDEMPTION SCHEDULE 9.00% DATE 07/01/05 PRINCIPAL $ 01/01/06 INTEREST - $ 3,367.86 07/01/06 3,882.63 $ 7,250.49 PERIOD TOTAL $ 326.27 - 01/01/07 326.27 $ 326.27 3,694.13 174.72 174.72 174.72 4,057.35 1,001.98 36 FISCAL TOTAL $ $ 8,252.47 4,020.40 4,232.07 $ 8,252.47 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan $185,810 MARICOPA COUNTY, ARIZONA White Fence Farms K-94 SPECIAL ASSESSMENT BOND REDEMPTION SCHEDULE 9.00% DATE 07/01/05 PRINCIPAL $ 01/01/06 INTEREST - $ 8,444.77 15,749.64 $ 24,194.41 PERIOD TOTAL $ 1,088.75 - 07/01/06 01/01/07 1,088.75 $ 1,088.75 9,533.52 708.73 708.73 708.73 16,458.37 3,594.96 37 FISCAL TOTAL $ $ 27,789.37 10,622.27 17,167.11 $ 27,789.37 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan $83,236 MARICOPA COUNTY, ARIZONA 104 th Place/University Drive K-95 SPECIAL ASSESSMENT BOND REDEMPTION SCHEDULE 9.00% DATE 07/01/05 01/01/06 07/01/06 01/01/07 PRINCIPAL $ - INTEREST $ 5,762.50 14,086.10 PERIOD TOTAL $ 633.87 8,323.60 $ 633.87 $ 633.87 6,396.37 374.56 374.56 374.56 8,698.16 2,016.87 38 FISCAL TOTAL $ $ 16,102.97 7,030.25 9,072.72 $ 16,102.97 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan $301,905 MARICOPA COUNTY, ARIZONA Central Avenue K-96 SPECIAL ASSESSMENT BOND REDEMPTION SCHEDULE 9.00% DATE 07/01/05 01/01/06 07/01/06 01/01/07 07/01/07 01/01/08 07/01/08 01/01/09 PRINCIPAL INTEREST $ 13,715.19 7,090.87 18,770.13 46,206.76 PERIOD TOTAL $ 1,981.42 6,630.57 $ 1,981.42 $ 1,981.42 15,696.61 1,364.23 1,364.23 1,364.23 7,994.80 1,065.86 1,065.86 1,065.86 8,156.73 844.66 844.66 844.66 19,614.79 10,512.32 39 FISCAL TOTAL $ $ 56,719.08 17,678.02 9,359.03 9,222.58 20,459.44 $ 56,719.08 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan $14,004 MARICOPA COUNTY, ARIZONA Billings Street K-98 SPECIAL ASSESSMENT BOND REDEMPTION SCHEDULE 9.00% DATE 07/01/05 PRINCIPAL $ 01/01/06 INTEREST - $ 776.41 PERIOD TOTAL 102.60 $ 102.60 102.60 FISCAL TOTAL $ - 879.01 981.60 07/01/06 - 67.66 67.66 - 01/01/07 454.84 67.66 522.50 590.16 07/01/07 - 01/01/08 1,048.68 $ 2,279.93 $ 47.19 47.19 47.19 1,095.87 434.89 40 $ 2,714.82 1,143.06 $ 2,714.82 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan $60,670 MARICOPA COUNTY, ARIZONA Marquerite Drive K100 SPECIAL ASSESSMENT BOND REDEMPTION SCHEDULE 9.000% DATE 07/01/05 01/01/06 07/01/06 01/01/07 07/01/07 01/01/08 07/01/08 01/01/09 07/01/09 01/01/10 07/01/10 01/01/11 07/01/11 01/01/12 PRINCIPAL $ INTEREST - $ - $ 1,172.37 2,855.08 1,172.37 1,172.37 4,027.45 1,043.89 1,043.89 356.90 1,043.89 1,400.79 - 1,027.83 1,027.83 1,027.83 5,667.37 819.05 819.05 819.05 6,886.09 546.03 546.03 546.03 6,613.07 273.02 273.02 273.02 6,340.06 6,067.04 6,067.04 6,067.04 26,052.64 $ 10,936.75 41 FISCAL TOTAL $ 1,172.37 - 4,639.54 $ PERIOD TOTAL 1,172.37 5,071.34 2,428.62 6,486.42 7,432.12 6,886.09 - $ 36,989.39 2,344.74 6,340.06 $ 36,989.39 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan $60,059 MARICOPA COUNTY, ARIZONA 7th Street North Improvement K106 BOND REDEMPTION SCHEDULE 9.000% DATE 07/01/05 01/01/06 07/01/06 01/01/07 07/01/07 01/01/08 07/01/08 01/01/09 07/01/09 01/01/10 07/01/10 01/01/11 07/01/11 01/01/12 07/01/12 01/01/13 07/01/13 01/01/14 PRINCIPAL $ INTEREST - $ 6,005.86 6,005.86 6,005.86 6,005.86 6,005.86 6,005.86 6,005.86 6,005.92 54,052.80 PERIOD TOTAL $ 2,162.11 6,005.86 $ 2,162.11 $ 2,162.11 8,167.97 1,921.88 1,921.88 1,921.88 7,927.74 1,681.64 1,681.64 1,681.64 7,687.50 1,441.41 1,441.41 1,441.41 7,447.27 1,201.17 1,201.17 1,201.17 7,207.03 960.94 960.94 960.94 6,966.80 720.71 720.71 720.71 6,726.57 480.47 480.47 480.47 6,486.33 240.24 240.24 240.24 6,246.16 21,621.14 42 FISCAL TOTAL $ $ 75,673.94 10,330.08 9,849.62 9,369.15 8,888.68 8,408.21 7,927.74 7,447.27 6,966.80 6,486.39 $ 75,673.94 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan MARICOPA COUNTY, ARIZONA CALCULATED TOTAL OF ALL CERTIFICATE OF PARTICIPATION REDEMPTION SCHEDULES Date 7/1/2005 1/1/2006 7/1/2006 1/1/2007 7/1/2007 1/1/2008 7/1/2008 1/1/2009 7/1/2009 1/1/2010 7/1/2010 1/1/2011 7/1/2011 1/1/2012 7/1/2012 1/1/2013 7/1/2013 1/1/2014 7/1/2014 1/1/2015 7/1/2015 1/1/2016 $ $ Principal 385,000.00 400,000.00 420,000.00 445,000.00 465,000.00 490,000.00 520,000.00 545,000.00 575,000.00 610,000.00 645,000.00 5,500,000.00 $ $ Interest 140,465.00 131,321.25 131,321.25 121,721.25 121,721.25 111,536.25 111,536.25 100,633.75 100,633.75 89,125.00 89,125.00 76,875.00 76,875.00 63,615.00 63,615.00 49,445.00 49,445.00 34,207.50 34,207.50 17,737.50 17,737.50 1,732,900.00 43 $ $ Period Total 525,465.00 131,321.25 531,321.25 121,721.25 541,721.25 111,536.25 556,536.25 100,633.75 565,633.75 89,125.00 579,125.00 76,875.00 596,875.00 63,615.00 608,615.00 49,445.00 624,445.00 34,207.50 644,207.50 17,737.50 662,737.50 7,232,900.00 Fiscal Total $ 656,786.25 653,042.50 653,257.50 657,170.00 654,758.75 656,000.00 660,490.00 658,060.00 658,652.50 - $ 661,945.00 662,737.50 7,232,900.00 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan MARICOPA COUNTYMARICOPA COUNTY, ARIZONA CALCULATED TOTA CALCULATED TOTAL OF ALL CAPITAL LEASES Principal and Interest GOVERNMENTAL ACTIVIES Department: Purpose: FY 05-06 FY 06-07 FY 07-08 FY 08-09 FY 09-10 Medical Examiner Trial Courts Medical Equipment Security Equipment $ $ 18,674.55 $ 6,225.85 24,900.40 $ Various Dept Total Governmental Computer Equipment Activites 27,195.06 $ 27,195.06 27,195.06 27,195.07 18,130.06 126,910.31 $ 44 6,265,620.33 $ 4,951,096.54 2,346,578.57 13,563,295.44 $ 6,311,489.94 4,984,517.45 2,373,773.63 27,195.07 18,130.06 13,715,106.15 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan MARICOPA COUNTY, ARIZONA CALCULATED TOTAL OF ALL CAPITAL LEASES Principal and Interest INTERNAL SERVICE FUND Department: Purpose: FY 05-06 FY 06-07 FY 07-08 Telecom Equipment $ $ 94,289.27 94,289.27 62,859.37 251,437.91 45 Internal Service Fund Total $ $ 94,289.27 94,289.27 62,859.37 251,437.91 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan County Department: County Agency: Contract Number: Lease Description: Medical Examiner 290 98215-E Medical Equipment LOAN DATA Loan amount: Annual interest rate: Term in years: Payments per year: First payment due: PERIODIC PAYMENT $84,107.12 Calculated payment: $1,556.21 4.1908% 5 12 11/24/2001 AMORTIZATION SCHEDULE Payment No. Date 45 7/24/2005 $ 46 8/24/2005 47 9/24/2005 48 10/24/2005 49 11/24/2005 50 12/24/2005 51 1/24/2006 52 2/24/2006 53 3/24/2006 54 4/24/2006 55 5/24/2006 56 6/24/2006 57 7/24/2006 58 8/24/2006 59 9/24/2006 60 10/24/2006 Outstanding as of June 30, 2005 Principal $ Total Interest Payment $ Total Debt Service Payable $ Beginning Balance 24,175.64 22,703.86 21,226.94 19,744.86 18,257.61 16,765.16 15,267.50 13,764.61 12,256.47 10,743.06 9,224.37 7,700.37 6,171.05 4,636.39 3,096.37 1,550.97 Interest $ 84.43 79.29 74.13 68.96 63.76 58.55 53.32 48.07 42.80 37.52 32.21 26.89 21.55 16.19 10.81 5.49 $ 723.97 $ $ Principal 1,471.78 1,476.92 1,482.08 1,487.25 1,492.45 1,497.66 1,502.89 1,508.14 1,513.41 1,518.69 1,524.00 1,529.32 1,534.66 1,540.02 1,545.40 1,550.92 24,175.59 $ Ending Balance 22,703.86 21,226.94 19,744.86 18,257.61 16,765.16 15,267.50 13,764.61 12,256.47 10,743.06 9,224.37 7,700.37 6,171.05 4,636.39 3,096.37 1,550.97 0.05 Fiscal Year Ended 6/30 Cumulative Interest Principal Interest Total $ 8,626.19 8,705.48 8,779.61 8,848.57 8,912.33 8,970.88 9,024.20 9,072.27 9,115.07 9,152.59 9,184.80 9,211.69 $ 18,004.59 $ 669.93 $ 18,674.52 9,233.24 9,249.43 9,260.24 9,265.73 $ 6,171.00 $ 54.04 $ 6,225.04 24,175.59 723.97 24,899.56 46 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan County Department: County Agency: Contract Number: Lease Description: Various Departments TFP#7 Computer Equipment LOAN DATA Loan amount: Annual interest rate: Term in years: Payments per year: First payment due: PERIODIC PAYMENT Calculated payment: $535,598.63 2.44200% 3 12 12/8/2002 AMORTIZATION SCHEDULE Payment Beginning No. Date Balance 32 7/8/2005 $ 76,753.26 33 8/8/2005 61,464.96 34 9/8/2005 46,145.55 35 10/8/2005 30,794.97 36 11/8/2005 15,413.15 Outstanding as of June 30, 2005 Principal $ Total Interest Payment $ Total Debt Service Payable $ $15,444.49 Fiscal Year Ended 6/30 Interest 156.19 125.08 93.91 62.67 31.37 $ 469.22 $ Principal 15,288.30 15,319.41 15,350.58 15,381.82 15,413.15 $ 76,753.26 $ $ Ending Balance 61,464.96 46,145.55 30,794.97 15,413.15 0.00 Cumulative Interest $ 20,090.03 20,215.11 20,309.02 20,371.69 20,403.06 Principal Interest Total $ 76,753.26 $ 469.22 $ 77,222.48 76,753.26 469.22 77,222.48 47 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan County Department: County Agency: Contract Number: Lease Description: Various Departments TFP#8 Computer Equipment LOAN DATA Loan amount: Annual interest rate: Term in years: Payments per year: First payment due: PERIODIC PAYMENT Calculated payment: $1,368,648.56 2.44000% 3 12 4/6/2003 AMORTIZATION SCHEDULE Payment Beginning No. Date Balance 28 7/6/2005 $ 351,601.34 29 8/6/2005 312,851.19 30 9/6/2005 274,022.25 31 10/6/2005 235,114.36 32 11/6/2005 196,127.36 33 12/6/2005 157,061.08 34 1/6/2006 117,915.37 35 2/6/2006 78,690.06 36 3/6/2006 39,384.99 $39,465.07 Fiscal Year Ended 6/30 Interest 714.92 636.13 557.18 478.07 398.79 319.36 239.76 160.00 80.08 $ 3,584.29 $ Principal 38,750.15 38,828.94 38,907.89 38,987.00 39,066.28 39,145.71 39,225.31 39,305.07 39,384.99 $ 351,601.34 $ $ Ending Balance 312,851.19 274,022.25 235,114.36 196,127.36 157,061.08 117,915.37 78,690.06 39,384.99 - Cumulative Interest $ 49,224.60 49,860.73 50,417.91 50,895.98 51,294.77 51,614.13 51,853.89 52,013.89 52,093.97 Principal Interest Total $ 351,601.34 $ 3,584.29 $ 355,185.63 Outstanding as of June 30, 2005 Principal $ 351,601.34 Total Interest Payment $ 3,584.29 Total Debt Service Payable $ 355,185.63 48 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan County Department: County Agency: Contract Number: Lease Description: Various Departments TFP#9 Computer Equipment PERIODIC PAYMENT Calculated payment: LOAN DATA Loan amount: Annual interest rate: Term in years: Payments per year: First payment due: $2,242,808.79 1.98000% 3 12 7/28/2003 AMORTIZATION SCHEDULE Payment Beginning No. Date Balance 25 7/28/2005 $ 762,441.07 26 8/28/2005 699,478.85 27 9/28/2005 636,412.74 28 10/28/2005 573,242.57 29 11/28/2005 509,968.17 30 12/28/2005 446,589.37 31 1/28/2006 383,106.00 32 2/28/2006 319,517.88 33 3/28/2006 255,824.84 34 4/28/2006 192,026.70 35 5/28/2006 128,123.30 36 6/28/2006 64,114.46 $64,220.25 Fiscal Year Ended 6/30 Interest 1,258.03 1,154.14 1,050.08 945.85 841.45 736.87 632.12 527.20 422.11 316.84 211.40 105.79 $ 8,201.88 $ Principal 62,962.22 63,066.11 63,170.17 63,274.40 63,378.80 63,483.37 63,588.12 63,693.04 63,798.14 63,903.40 64,008.84 64,114.46 $ 762,441.07 $ $ Ending Balance 699,478.85 636,412.74 573,242.57 509,968.17 446,589.37 383,106.00 319,517.88 255,824.84 192,026.70 128,123.30 64,114.46 0.00 Cumulative Interest $ 62,176.24 63,330.38 64,380.46 65,326.31 66,167.76 66,904.63 67,536.75 68,063.95 68,486.06 68,802.90 69,014.30 69,120.09 Principal Interest Total $ 762,441.07 $ 8,201.88 $ 770,642.95 Outstanding as of June 30, 2005 Principal $ 762,441.07 Total Interest Payment $ 8,201.88 Total Debt Service Payable $ 770,642.95 49 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan County Department: County Agency: Contract Number: Lease Description: Various Departments TFP#10 Computer Equipment LOAN DATA Loan amount: Annual interest rate: Term in years: Payments per year: First payment due: PERIODIC PAYMENT Calculated payment: $777,422.38 2.08000% 3 12 2/15/2004 AMORTIZATION SCHEDULE Payment Beginning No. Date Balance 18 7/15/2005 $ 416,342.28 19 8/15/2005 394,769.40 20 9/15/2005 373,159.13 21 10/15/2005 351,511.40 22 11/15/2005 329,826.15 23 12/15/2005 308,103.31 24 1/15/2006 286,342.82 25 2/15/2006 264,544.61 26 3/15/2006 242,708.61 27 4/15/2006 220,834.76 28 5/15/2006 198,923.00 29 6/15/2006 176,973.26 30 7/15/2006 154,985.47 31 8/15/2006 132,959.57 32 9/15/2006 110,895.49 33 10/15/2006 88,793.17 34 11/15/2006 66,652.54 35 12/15/2006 44,473.53 36 1/15/2007 22,256.08 $22,294.54 Fiscal Year Ended 6/30 Interest 721.66 684.27 646.81 609.29 571.70 534.05 496.33 458.54 420.69 382.78 344.80 306.75 268.64 230.46 192.22 153.91 115.53 77.09 38.58 $ 7,254.10 $ Principal 21,572.88 21,610.27 21,647.73 21,685.25 21,722.84 21,760.49 21,798.21 21,836.00 21,873.85 21,911.76 21,949.74 21,987.79 22,025.90 22,064.08 22,102.32 22,140.63 22,179.01 22,217.45 22,255.96 $ 416,342.16 $ $ Ending Balance 394,769.40 373,159.13 351,511.40 329,826.15 308,103.31 286,342.82 264,544.61 242,708.61 220,834.76 198,923.00 176,973.26 154,985.47 132,959.57 110,895.49 88,793.17 66,652.54 44,473.53 22,256.08 0.12 Cumulative Interest $ 18,648.74 19,333.01 19,979.82 20,589.11 21,160.81 21,694.86 22,191.19 22,649.73 23,070.42 23,453.20 23,798.00 24,104.75 24,373.39 24,603.85 24,796.07 24,949.98 25,065.51 25,142.60 25,181.18 Principal Interest Total $ 261,356.81 $ 6,177.67 $ 267,534.48 $ 154,985.35 $ 1,076.43 $ 156,061.78 Outstanding as of June 30, 2004 Principal $ 416,342.16 Total Interest Payment $ 7,254.10 Total Debt Service Payable $ 423,596.26 50 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan County Department: County Agency: Contract Number: Lease Description: Various Departments TFP#11 Computer Equipment PERIODIC PAYMENT Calculated payment: LOAN DATA Loan amount: Annual interest rate: Term in years: Payments per year: First payment due: $5,556,061.81 2.34000% 3 12 7/17/2004 AMORTIZATION SCHEDULE Payment No. Date 13 7/17/2005 $ 14 8/17/2005 15 9/17/2005 16 10/17/2005 17 11/17/2005 18 12/17/2005 19 1/17/2006 20 2/17/2006 21 3/17/2006 22 4/17/2006 23 5/17/2006 24 6/17/2006 25 7/17/2006 26 8/17/2006 27 9/17/2006 28 10/17/2006 29 11/17/2006 30 12/17/2006 31 1/17/2007 32 2/17/2007 33 3/17/2007 34 4/17/2007 35 5/17/2007 36 6/17/2007 $159,974.23 Fiscal Year Ended 6/30 Beginning Balance 3,747,063.28 3,594,395.82 3,441,430.66 3,288,167.22 3,134,604.92 2,980,743.17 2,826,581.39 2,672,118.99 2,517,355.39 2,362,290.00 2,206,922.24 2,051,251.51 1,895,277.22 1,738,998.78 1,582,415.60 1,425,527.08 1,268,332.63 1,110,831.65 953,023.54 794,907.71 636,483.55 477,750.46 318,707.84 159,355.09 Interest 7,306.77 7,009.07 6,710.79 6,411.93 6,112.48 5,812.45 5,511.83 5,210.63 4,908.84 4,606.47 4,303.50 3,999.94 3,695.79 3,391.05 3,085.71 2,779.78 2,473.25 2,166.12 1,858.40 1,550.07 1,241.14 931.61 621.48 310.74 $ 92,009.84 $ Principal $ 152,667.46 152,965.16 153,263.44 153,562.30 153,861.75 154,161.78 154,462.40 154,763.60 155,065.39 155,367.76 155,670.73 155,974.29 156,278.44 156,583.18 156,888.52 157,194.45 157,500.98 157,808.11 158,115.83 158,424.16 158,733.09 159,042.62 159,352.75 159,663.49 $ 3,747,371.68 $ Ending Cumulative Balance Interest 3,594,395.82 $ 117,999.00 3,441,430.66 125,008.07 3,288,167.22 131,718.86 3,134,604.92 138,130.79 2,980,743.17 144,243.27 2,826,581.39 150,055.72 2,672,118.99 155,567.55 2,517,355.39 160,778.18 2,362,290.00 165,687.02 2,206,922.24 170,293.49 2,051,251.51 174,596.99 1,895,277.22 178,596.93 1,738,998.78 182,292.72 1,582,415.60 185,683.77 1,425,527.08 188,769.48 1,268,332.63 191,549.26 1,110,831.65 194,022.51 953,023.54 196,188.63 794,907.71 198,047.03 636,483.55 199,597.10 477,750.46 200,838.24 318,707.84 201,769.85 159,355.09 202,391.33 (308.40) 202,702.07 Principal Interest Total $ 1,851,786.06 $ 67,904.70 $ 1,919,690.76 $ 1,895,585.62 $ 24,105.14 $ 1,919,690.76 Outstanding as of June 30, 2005 Principal $ 3,747,371.68 Total Interest Payment $ 92,009.84 Total Debt Service Payable $ 3,839,381.52 51 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan County Department: County Agency: Contract Number: Lease Description: Various Departments TFP#12 Computer Equipment PERIODIC PAYMENT Calculated payment: LOAN DATA Loan amount: Annual interest rate: Term in years: Payments per year: First payment due: $1,081,954.15 2.48000% 3 12 11/15/2004 AMORTIZATION SCHEDULE Payment Beginning No. Date Balance 9 7/15/2005 $ 848,425.88 10 8/15/2005 818,962.52 11 9/15/2005 789,438.22 12 10/15/2005 759,852.86 13 11/15/2005 730,206.31 14 12/15/2005 700,498.45 15 1/15/2006 670,729.15 16 2/15/2006 640,898.28 17 3/15/2006 611,005.72 18 4/15/2006 581,051.33 19 5/15/2006 551,034.99 20 6/15/2006 520,956.57 21 7/15/2006 490,815.95 22 8/15/2006 460,612.99 23 9/15/2006 430,347.57 24 10/15/2006 400,019.55 25 11/15/2006 369,628.81 26 12/15/2006 339,175.22 27 1/15/2007 308,658.64 28 2/15/2007 278,078.95 29 3/15/2007 247,436.02 30 4/15/2007 216,729.71 31 5/15/2007 185,959.89 32 6/15/2007 155,126.44 33 7/15/2007 124,229.22 34 8/15/2007 93,268.10 35 9/15/2007 62,242.95 36 10/15/2007 31,153.63 $31,218.05 Fiscal Year Ended 6/30 Interest 1,754.69 1,693.75 1,632.69 1,571.50 1,510.19 1,448.75 1,387.18 1,325.48 1,263.66 1,201.71 1,139.63 1,077.43 1,015.09 952.62 890.03 827.31 764.45 701.47 638.36 575.11 511.74 448.23 384.60 320.83 256.93 192.89 128.73 64.43 $ 25,679.48 $ Principal 29,463.36 29,524.30 29,585.36 29,646.55 29,707.86 29,769.30 29,830.87 29,892.56 29,954.39 30,016.34 30,078.42 30,140.62 30,202.96 30,265.42 30,328.02 30,390.74 30,453.59 30,516.58 30,579.69 30,642.93 30,706.31 30,769.82 30,833.45 30,897.22 30,961.12 31,025.15 31,089.32 31,153.62 $ 848,425.87 $ $ Ending Cumulative Balance Interest 818,962.52 $ 17,969.82 789,438.22 19,663.57 759,852.86 21,296.26 730,206.31 22,867.76 700,498.45 24,377.95 670,729.15 25,826.70 640,898.28 27,213.88 611,005.72 28,539.36 581,051.33 29,803.02 551,034.99 31,004.73 520,956.57 32,144.36 490,815.95 33,221.79 460,612.99 34,236.88 430,347.57 35,189.50 400,019.55 36,079.53 369,628.81 36,906.84 339,175.22 37,671.29 308,658.64 38,372.76 278,078.95 39,011.12 247,436.02 39,586.23 216,729.71 40,097.97 185,959.89 40,546.20 155,126.44 40,930.80 124,229.22 41,251.63 93,268.10 41,508.56 62,242.95 41,701.45 31,153.63 41,830.18 (0.00) 41,894.61 Principal Interest Total $ 357,609.93 $ 17,006.66 $ 374,616.59 $ 366,586.73 $ 8,029.84 $ 374,616.57 $ 124,229.21 $ 4,987.77 $ 129,216.98 Outstanding as of June 30, 2005 Principal $ 848,425.87 Total Interest Payment $ 25,679.48 Total Debt Service Payable $ 874,105.35 52 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan County Department: County Agency: Contract Number: Lease Description: Various Departments TFP#13 Computer Equipment PERIODIC PAYMENT Calculated payment: LOAN DATA Loan amount: Annual interest rate: Term in years: Payments per year: First payment due: $1,162,300.76 2.99490% 3 12 3/7/2005 AMORTIZATION SCHEDULE Payment Beginning No. Date Balance 5 7/7/2005 $ 1,038,246.56 6 8/7/2005 1,007,039.26 7 9/7/2005 975,754.08 8 10/7/2005 944,390.82 9 11/7/2005 912,949.28 10 12/7/2005 881,429.27 11 1/7/2006 849,830.60 12 2/7/2006 818,153.06 13 3/7/2006 786,396.47 14 4/7/2006 754,560.62 15 5/7/2006 722,645.31 16 6/7/2006 690,650.35 17 7/7/2006 658,575.54 18 8/7/2006 626,420.68 19 9/7/2006 594,185.57 20 10/7/2006 561,870.01 21 11/7/2006 529,473.80 22 12/7/2006 496,996.73 23 1/7/2007 464,438.61 24 2/7/2007 431,799.23 25 3/7/2007 399,078.39 26 4/7/2007 366,275.89 27 5/7/2007 333,391.52 28 6/7/2007 300,425.08 29 7/7/2007 267,376.37 30 8/7/2007 234,245.17 31 9/7/2007 201,031.29 32 10/7/2007 167,734.51 33 11/7/2007 134,354.63 34 12/7/2007 100,891.45 35 1/7/2008 67,344.75 36 2/7/2008 33,714.33 $33,798.50 Fiscal Year Ended 6/30 Interest 2,591.20 2,513.32 2,435.24 2,356.96 2,278.49 2,199.83 2,120.96 2,041.91 1,962.65 1,883.19 1,803.54 1,723.69 1,643.64 1,563.39 1,482.94 1,402.29 1,321.43 1,240.38 1,159.12 1,077.66 996.00 914.13 832.06 749.79 667.30 584.62 501.72 418.62 335.32 251.80 168.08 84.14 $ 43,305.41 $ Principal 31,207.30 31,285.18 31,363.26 31,441.54 31,520.01 31,598.67 31,677.54 31,756.59 31,835.85 31,915.31 31,994.96 32,074.81 32,154.86 32,235.11 32,315.56 32,396.21 32,477.07 32,558.12 32,639.38 32,720.84 32,802.50 32,884.37 32,966.44 33,048.71 33,131.20 33,213.88 33,296.78 33,379.88 33,463.18 33,546.70 33,630.42 33,714.36 $ 1,038,246.59 $ $ Ending Cumulative Balance Interest 1,007,039.26 $ 13,731.00 975,754.08 16,244.32 944,390.82 18,679.56 912,949.28 21,036.52 881,429.27 23,315.01 849,830.60 25,514.84 818,153.06 27,635.80 786,396.47 29,677.71 754,560.62 31,640.36 722,645.31 33,523.55 690,650.35 35,327.09 658,575.54 37,050.78 626,420.68 38,694.42 594,185.57 40,257.81 561,870.01 41,740.75 529,473.80 43,143.04 496,996.73 44,464.47 464,438.61 45,704.85 431,799.23 46,863.97 399,078.39 47,941.63 366,275.89 48,937.63 333,391.52 49,851.76 300,425.08 50,683.82 267,376.37 51,433.61 234,245.17 52,100.91 201,031.29 52,685.53 167,734.51 53,187.25 134,354.63 53,605.87 100,891.45 53,941.19 67,344.75 54,192.99 54,361.07 33,714.33 (0.00) 54,445.21 Principal Interest Total $ 379,671.02 $ 25,910.98 $ 405,582.00 $ 391,199.17 $ 14,382.83 $ 405,582.00 $ 267,376.40 $ 3,011.60 $ 270,388.00 Outstanding as of June 30, 2005 Principal $ 1,038,246.59 Total Interest Payment $ 43,305.41 Total Debt Service Payable $ 1,081,552.00 53 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan County Department: County Agency: Contract Number: Lease Description: Various Departments TFP#14 Computer Equipment LOAN DATA Loan amount: Annual interest rate: Term in years: Payments per year: First payment due: PERIODIC PAYMENT Calculated payment: $1,246,651.39 2.64400% 3 12 3/17/2005 AMORTIZATION SCHEDULE Payment No. Date 4 6/17/2005 $ 5 7/17/2005 6 8/17/2005 7 9/17/2005 8 10/17/2005 9 11/17/2005 10 12/17/2005 11 1/17/2006 12 2/17/2006 13 3/17/2006 14 4/17/2006 15 5/17/2006 16 6/17/2006 17 7/17/2006 18 8/17/2006 19 9/17/2006 20 10/17/2006 21 11/17/2006 22 12/17/2006 23 1/17/2007 24 2/17/2007 25 3/17/2007 26 4/17/2007 27 5/17/2007 28 6/17/2007 29 7/17/2007 30 8/17/2007 31 9/17/2007 32 10/17/2007 33 11/17/2007 34 12/17/2007 35 1/17/2008 36 2/17/2008 Beginning Balance 1,146,494.79 1,112,962.03 1,079,355.39 1,045,674.70 1,011,919.80 978,090.53 944,186.72 910,208.21 876,154.83 842,026.42 807,822.82 773,543.85 739,189.36 704,759.17 670,253.12 635,671.04 601,012.77 566,278.13 531,466.96 496,579.09 461,614.35 426,572.57 391,453.58 356,257.21 320,983.29 285,631.65 250,202.12 214,694.53 179,108.70 143,444.47 107,701.66 71,880.09 35,979.60 Interest $ 2,526.11 2,452.23 2,378.18 2,303.97 2,229.60 2,155.06 2,080.36 2,005.49 1,930.46 1,855.27 1,779.90 1,704.38 1,628.68 1,552.82 1,476.79 1,400.60 1,324.23 1,247.70 1,171.00 1,094.13 1,017.09 939.88 862.50 784.95 707.23 629.34 551.28 473.04 394.64 316.06 237.30 158.38 79.28 $ 43,447.93 Principal 33,532.76 33,606.64 33,680.69 33,754.90 33,829.27 33,903.81 33,978.51 34,053.38 34,128.41 34,203.60 34,278.97 34,354.49 34,430.19 34,506.05 34,582.08 34,658.27 34,734.64 34,811.17 34,887.87 34,964.74 35,041.78 35,118.99 35,196.37 35,273.92 35,351.64 35,429.53 35,507.59 35,585.83 35,664.23 35,742.81 35,821.57 35,900.49 35,979.60 $1,146,494.79 $ $ $36,058.87 Fiscal Year Ended 6/30 Ending Cumulative Balance Interest Principal Interest Total 1,112,962.03 $ 10,546.12 1,079,355.39 12,998.35 1,045,674.70 15,376.53 1,011,919.80 17,680.50 978,090.53 19,910.10 944,186.72 22,065.16 910,208.21 24,145.52 876,154.83 26,151.01 842,026.42 28,081.47 807,822.82 29,936.74 773,543.85 31,716.64 739,189.36 33,421.02 704,759.17 35,049.70 $ 441,735.62 $ 27,029.69 $ 468,765.31 670,253.12 36,602.52 635,671.04 38,079.31 601,012.77 39,479.91 566,278.13 40,804.14 531,466.96 42,051.84 496,579.09 43,222.84 461,614.35 44,316.97 426,572.57 45,334.06 391,453.58 46,273.94 356,257.21 47,136.44 320,983.29 47,921.39 285,631.65 48,628.62 $ 419,127.52 $ 13,578.92 $ 432,706.44 250,202.12 49,257.96 214,694.53 49,809.24 179,108.70 50,282.28 143,444.47 50,676.92 107,701.66 50,992.98 71,880.09 51,230.28 35,979.60 51,388.66 (0.00) 51,467.94 $ 285,631.65 $ 2,839.32 $ 288,470.97 Outstanding as of June 30, 2005 Principal $ 1,146,494.79 Total Interest Payment $ 43,447.93 Total Debt Service Payable $ 1,189,942.72 54 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan County Department: County Agency: Contract Number: Lease Description: Various Departments TFP#15 Computer Equipment LOAN DATA Loan amount: Annual interest rate: Term in years: Payments per year: First payment due: PERIODIC PAYMENT Calculated payment: $1,223,651.69 3.12000% 3 12 6/30/2005 AMORTIZATION SCHEDULE Payment No. Date 2 7/30/2005 $ 3 8/30/2005 4 9/30/2005 5 10/30/2005 6 11/30/2005 7 12/30/2005 8 1/30/2006 9 2/28/2006 10 3/30/2006 11 4/30/2006 12 5/30/2006 13 6/30/2006 14 7/30/2006 15 8/30/2006 16 9/30/2006 17 10/30/2006 18 11/30/2006 19 12/30/2006 20 1/30/2007 21 2/28/2007 22 3/30/2007 23 4/30/2007 24 5/30/2007 25 6/30/2007 26 7/30/2007 27 8/30/2007 28 9/30/2007 29 10/30/2007 30 11/30/2007 31 12/30/2007 32 1/30/2008 33 2/29/2008 34 3/30/2008 35 4/30/2008 36 5/30/2008 Beginning Balance 1,191,183.16 1,158,630.22 1,125,992.64 1,093,270.20 1,060,462.68 1,027,569.86 994,591.52 961,527.44 928,377.39 895,141.15 861,818.50 828,409.21 794,913.05 761,329.80 727,659.24 693,901.13 660,055.25 626,121.37 592,099.27 557,988.71 523,789.46 489,501.29 455,123.97 420,657.27 386,100.96 351,454.80 316,718.56 281,892.01 246,974.91 211,967.02 176,868.11 141,677.95 106,396.29 71,022.90 35,557.54 Interest $ 3,097.08 3,012.44 2,927.58 2,842.50 2,757.20 2,671.68 2,585.94 2,499.97 2,413.78 2,327.37 2,240.73 2,153.86 2,066.77 1,979.46 1,891.91 1,804.14 1,716.14 1,627.92 1,539.46 1,450.77 1,361.85 1,272.70 1,183.32 1,093.71 1,003.86 913.78 823.47 732.92 642.13 551.11 459.86 368.36 276.63 184.66 92.45 $ 56,567.51 Principal 32,552.94 32,637.58 32,722.44 32,807.52 32,892.82 32,978.34 33,064.08 33,150.05 33,236.24 33,322.65 33,409.29 33,496.16 33,583.25 33,670.56 33,758.11 33,845.88 33,933.88 34,022.10 34,110.56 34,199.25 34,288.17 34,377.32 34,466.70 34,556.31 34,646.16 34,736.24 34,826.55 34,917.10 35,007.89 35,098.91 35,190.16 35,281.66 35,373.39 35,465.36 35,557.54 $1,191,183.16 $ $ Ending Balance 1,158,630.22 1,125,992.64 1,093,270.20 1,060,462.68 1,027,569.86 994,591.52 961,527.44 928,377.39 895,141.15 861,818.50 828,409.21 794,913.05 761,329.80 727,659.24 693,901.13 660,055.25 626,121.37 592,099.27 557,988.71 523,789.46 489,501.29 455,123.97 420,657.27 386,100.96 351,454.80 316,718.56 281,892.01 246,974.91 211,967.02 176,868.11 141,677.95 106,396.29 71,022.90 35,557.54 - $35,650.02 Fiscal Year Ended 6/30 Cumulative Interest Principal Interest Total $ 6,278.57 9,291.01 12,218.59 15,061.09 17,818.29 20,489.97 23,075.91 25,575.88 27,989.66 30,317.03 32,557.76 34,711.62 $ 396,270.11 $ 31,530.13 $ 427,800.24 36,778.39 38,757.85 40,649.76 42,453.90 44,170.04 45,797.96 47,337.42 48,788.19 50,150.04 51,422.74 52,606.06 53,699.77 $ 408,812.09 $ 18,988.15 $ 427,800.24 54,703.63 55,617.41 56,440.88 57,173.80 57,815.93 58,367.04 58,826.90 59,195.26 59,471.89 59,656.55 59,749.00 $ 386,100.96 $ 6,049.23 $ 392,150.19 Outstanding as of June 30, 2005 Principal $ 1,191,183.16 Total Interest Payment $ 56,567.51 Total Debt Service Payable $ 1,247,750.67 55 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan County Department: County Agency: Contract Number: Lease Description: Various Departments TFP#16 Computer Equipment LOAN DATA Loan amount: Annual interest rate: Term in years: Payments per year: First payment due: PERIODIC PAYMENT Calculated payment: $3,546,496.76 2.84002% 3 12 7/6/2005 AMORTIZATION SCHEDULE Payment No. Date 1 7/6/2005 $ 2 8/6/2005 3 9/6/2005 4 10/6/2005 5 11/6/2005 6 12/6/2005 7 1/6/2006 8 2/6/2006 9 3/6/2006 10 4/6/2006 11 5/6/2006 12 6/6/2006 13 7/6/2006 14 8/6/2006 15 9/6/2006 16 10/6/2006 17 11/6/2006 18 12/6/2006 19 1/6/2007 20 2/6/2007 21 3/6/2007 22 4/6/2007 23 5/6/2007 24 6/6/2007 25 7/6/2007 26 8/6/2007 27 9/6/2007 28 10/6/2007 29 11/6/2007 30 12/6/2007 31 1/6/2008 32 2/6/2008 33 3/6/2008 34 4/6/2008 35 5/6/2008 36 6/6/2008 $102,886.56 Fiscal Year Ended 6/30 Beginning Balance 3,546,496.76 3,452,003.63 3,357,286.86 3,262,345.93 3,167,180.30 3,071,789.45 2,976,172.84 2,880,329.93 2,784,260.19 2,687,963.09 2,591,438.08 2,494,684.63 2,397,702.19 2,300,490.23 2,203,048.20 2,105,375.55 2,007,471.74 1,909,336.23 1,810,968.46 1,712,367.89 1,613,533.96 1,514,466.12 1,415,163.82 1,315,626.50 1,215,853.61 1,115,844.59 1,015,598.88 915,115.92 814,395.15 713,436.00 612,237.92 510,800.33 409,122.67 307,204.37 205,044.86 102,643.58 Interest $ 8,393.43 8,169.79 7,945.63 7,720.93 7,495.71 7,269.95 7,043.65 6,816.82 6,589.46 6,361.55 6,133.11 5,904.12 5,674.60 5,444.53 5,213.91 4,982.75 4,751.05 4,518.79 4,285.99 4,052.63 3,818.72 3,584.26 3,349.24 3,113.67 2,877.54 2,640.85 2,403.60 2,165.79 1,927.41 1,688.48 1,448.97 1,208.90 968.26 727.05 485.28 242.92 $ 157,419.34 Principal $ 94,493.13 94,716.77 94,940.93 95,165.63 95,390.85 95,616.61 95,842.91 96,069.74 96,297.10 96,525.01 96,753.45 96,982.44 97,211.96 97,442.03 97,672.65 97,903.81 98,135.51 98,367.77 98,600.57 98,833.93 99,067.84 99,302.30 99,537.32 99,772.89 100,009.02 100,245.71 100,482.96 100,720.77 100,959.15 101,198.08 101,437.59 101,677.66 101,918.30 102,159.51 102,401.28 102,643.64 $ 3,546,496.76 $ Ending Cumulative Balance Interest 3,452,003.63 $ 8,393.43 3,357,286.86 16,563.22 3,262,345.93 24,508.85 3,167,180.30 32,229.78 3,071,789.45 39,725.49 2,976,172.84 46,995.44 2,880,329.93 54,039.09 2,784,260.19 60,855.91 2,687,963.09 67,445.37 2,591,438.08 73,806.92 2,494,684.63 79,940.03 2,397,702.19 85,844.15 2,300,490.23 91,518.75 2,203,048.20 96,963.28 2,105,375.55 102,177.19 2,007,471.74 107,159.94 1,909,336.23 111,910.99 1,810,968.46 116,429.78 1,712,367.89 120,715.77 1,613,533.96 124,768.40 1,514,466.12 128,587.12 1,415,163.82 132,171.38 1,315,626.50 135,520.62 1,215,853.61 138,634.29 1,115,844.59 141,511.83 1,015,598.88 144,152.68 915,115.92 146,556.28 814,395.15 148,722.07 713,436.00 150,649.48 612,237.92 152,337.96 510,800.33 153,786.93 409,122.67 154,995.83 307,204.37 155,964.09 205,044.86 156,691.14 102,643.58 157,176.42 (0.00) 157,419.34 Principal Interest Total $ 1,148,794.57 $ 85,844.15 $ 1,234,638.72 $ 1,181,848.58 $ 52,790.14 $ 1,234,638.72 $ 1,115,844.65 $ 15,907.51 $ 1,131,752.16 Outstanding as of June 30, 2005 Principal $ 3,546,496.76 Total Interest Payment $ 157,419.34 Total Debt Service Payable $ 3,703,916.10 56 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan County Department: County Agency: Contract Number: Lease Description: Various Departments Trial Courts Security Equipment LOAN DATA Loan amount: Annual interest rate: Term in years: Payments per year: First payment due: PERIODIC PAYMENT Calculated payment: $123,600.00 3.82000% 5 12 7/23/2005 AMORTIZATION SCHEDULE Payment Beginning No. Date Balance 5 7/23/2005 $ 116,072.96 6 8/23/2005 114,176.20 7 9/23/2005 112,273.40 8 10/23/2005 110,364.54 9 11/23/2005 108,449.61 10 12/23/2005 106,528.58 11 1/23/2006 104,601.44 12 2/23/2006 102,668.16 13 3/23/2006 100,728.73 14 4/23/2006 98,783.12 15 5/23/2006 96,831.32 16 6/23/2006 94,873.31 17 7/23/2006 92,909.06 18 8/23/2006 90,938.56 19 9/23/2006 88,961.79 20 10/23/2006 86,978.73 21 11/23/2006 84,989.35 22 12/23/2006 82,993.64 23 1/23/2007 80,991.58 24 2/23/2007 78,983.14 25 3/23/2007 76,968.31 26 4/23/2007 74,947.07 27 5/23/2007 72,919.39 28 6/23/2007 70,885.26 29 7/23/2007 68,844.65 30 8/23/2007 66,797.55 31 9/23/2007 64,743.93 32 10/23/2007 62,683.77 33 11/23/2007 60,617.05 34 12/23/2007 58,543.75 35 1/23/2008 56,463.85 36 2/23/2008 54,377.33 37 3/23/2008 52,284.23 38 4/23/2008 50,184.47 39 5/23/2008 48,078.02 40 6/23/2008 45,964.87 41 7/23/2008 43,844.99 42 8/23/2008 41,718.36 43 9/23/2008 39,584.96 44 10/23/2008 37,444.77 45 11/23/2008 35,297.77 46 12/23/2008 33,143.93 47 1/23/2009 30,983.24 48 2/23/2009 28,815.67 49 3/23/2009 26,641.20 50 4/23/2009 24,459.81 51 5/23/2009 22,271.47 52 6/23/2009 20,076.17 53 7/23/2009 17,873.88 54 8/23/2009 15,664.58 55 9/23/2009 13,448.25 56 10/23/2009 11,224.86 57 11/23/2009 8,994.39 58 12/23/2009 6,756.82 59 1/23/2010 4,512.13 60 2/23/2010 2,260.29 $2,266.26 Fiscal Year Ended 6/30 Interest 369.50 363.46 357.40 351.33 345.23 339.12 332.98 326.83 320.65 314.46 308.25 302.01 295.76 289.49 283.20 276.88 270.55 264.20 257.82 251.43 245.02 238.58 232.13 225.65 219.16 212.64 206.10 199.54 192.96 186.36 179.74 173.10 166.44 159.75 153.05 146.32 139.57 132.80 126.01 119.20 112.36 105.51 98.63 91.73 84.81 77.86 70.90 63.91 56.90 49.87 42.81 35.73 28.63 21.51 14.36 7.20 $ 10,837.39 $ Principal 1,896.76 1,902.80 1,908.86 1,914.93 1,921.03 1,927.14 1,933.28 1,939.43 1,945.61 1,951.80 1,958.01 1,964.25 1,970.50 1,976.77 1,983.06 1,989.38 1,995.71 2,002.06 2,008.44 2,014.83 2,021.24 2,027.68 2,034.13 2,040.61 2,047.10 2,053.62 2,060.16 2,066.72 2,073.30 2,079.90 2,086.52 2,093.16 2,099.82 2,106.51 2,113.21 2,119.94 2,126.69 2,133.46 2,140.25 2,147.06 2,153.90 2,160.75 2,167.63 2,174.53 2,181.45 2,188.40 2,195.36 2,202.35 2,209.36 2,216.39 2,223.45 2,230.53 2,237.63 2,244.75 2,251.90 2,259.06 $ 116,073.17 $ Outstanding as of June 30, 2005 Principal $ 116,073.17 Total Interest Payment $ 10,837.39 Total Debt Service Payable $ $ 57 Ending Balance 114,176.20 112,273.40 110,364.54 108,449.61 106,528.58 104,601.44 102,668.16 100,728.73 98,783.12 96,831.32 94,873.31 92,909.06 90,938.56 88,961.79 86,978.73 84,989.35 82,993.64 80,991.58 78,983.14 76,968.31 74,947.07 72,919.39 70,885.26 68,844.65 66,797.55 64,743.93 62,683.77 60,617.05 58,543.75 56,463.85 54,377.33 52,284.23 50,184.47 48,078.02 45,964.87 43,844.99 41,718.36 39,584.96 37,444.77 35,297.77 33,143.93 30,983.24 28,815.67 26,641.20 24,459.81 22,271.47 20,076.17 17,873.88 15,664.58 13,448.25 11,224.86 8,994.39 6,756.82 4,512.13 2,260.29 1.00 Cumulative Interest $ 1,907.50 2,270.96 2,628.36 2,979.69 3,324.92 3,664.04 3,997.02 4,323.85 4,644.50 4,958.96 5,267.21 5,569.22 5,864.98 6,154.47 6,437.67 6,714.55 6,985.10 7,249.30 7,507.12 7,758.55 8,003.57 8,242.15 8,474.28 8,699.93 8,919.09 9,131.73 9,337.83 9,537.37 9,730.33 9,916.69 10,096.43 10,269.53 10,435.97 10,595.72 10,748.77 10,895.09 11,034.66 11,167.46 11,293.47 11,412.67 11,525.03 11,630.54 11,729.17 11,820.90 11,905.71 11,983.57 12,054.47 12,118.38 12,175.28 12,225.15 12,267.96 12,303.69 12,332.32 12,353.83 12,368.19 12,375.39 Principal Interest Total $ 23,163.90 $ 4,031.22 $ 27,195.12 $ 24,064.41 $ 3,130.71 $ 27,195.12 $ 24,999.96 $ 2,195.16 $ 27,195.12 $ 25,971.83 $ 1,223.29 $ 27,195.12 $ 17,873.07 $ $ 18,130.08 257.01 126,910.56 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan County Department: County Agency: Contract Number: Lease Description: Telecom C76030078 Equipment PERIODIC PAYMENT LOAN DATA Loan amount: Annual interest rate: Term in years: Payments per year: First payment due: Calculated payment: $440,000.00 2.7500% 5 12 3/1/2003 AMORTIZATION SCHEDULE Payment Beginning No. Date Balance 29 7/1/2005 $ 242,172.47 30 8/1/2005 234,870.01 31 9/1/2005 227,550.81 32 10/1/2005 220,214.84 33 11/1/2005 212,862.06 34 12/1/2005 205,492.43 35 1/1/2006 198,105.92 36 2/1/2006 190,702.47 37 3/1/2006 183,282.06 38 4/1/2006 175,844.64 39 5/1/2006 168,390.18 40 6/1/2006 160,918.63 41 7/1/2006 153,429.96 42 8/1/2006 145,924.13 43 9/1/2006 138,401.10 44 10/1/2006 130,860.83 45 11/1/2006 123,303.28 46 12/1/2006 115,728.41 47 1/1/2007 108,136.19 48 2/1/2007 100,526.56 49 3/1/2007 92,899.49 50 4/1/2007 85,254.94 51 5/1/2007 77,592.88 52 6/1/2007 69,913.26 53 7/1/2007 62,216.04 54 8/1/2007 54,501.18 55 9/1/2007 46,768.64 56 10/1/2007 39,018.38 57 11/1/2007 31,250.36 58 12/1/2007 23,464.54 59 1/1/2008 15,660.88 60 2/1/2008 7,839.33 Outstanding as of June 30, 2005 Principal $ Total Interest Payment $ Total Debt Service Payable $ $7,857.44 Fiscal Year Ended 6/30 Interest $ 554.98 538.24 521.47 504.66 487.81 470.92 453.99 437.03 420.02 402.98 385.89 368.77 351.61 334.41 317.17 299.89 282.57 265.21 247.81 230.37 212.89 195.38 177.82 160.22 142.58 124.90 107.18 89.42 71.62 53.77 35.89 17.97 $ 9,265.44 $ $ Principal 7,302.46 7,319.20 7,335.97 7,352.78 7,369.63 7,386.51 7,403.45 7,420.41 7,437.42 7,454.46 7,471.55 7,488.67 7,505.83 7,523.03 7,540.27 7,557.55 7,574.87 7,592.22 7,609.63 7,627.07 7,644.55 7,662.06 7,679.62 7,697.22 7,714.86 7,732.54 7,750.26 7,768.02 7,785.82 7,803.66 7,821.55 7,839.33 242,172.47 $ Ending Balance 234,870.01 227,550.81 220,214.84 212,862.06 205,492.43 198,105.92 190,702.47 183,282.06 175,844.64 168,390.18 160,918.63 153,429.96 145,924.13 138,401.10 130,860.83 123,303.28 115,728.41 108,136.19 100,526.56 92,899.49 85,254.94 77,592.88 69,913.26 62,216.04 54,501.18 46,768.64 39,018.38 31,250.36 23,464.54 15,660.88 7,839.33 0.00 Cumulative Interest $ 22,735.76 23,274.00 23,795.47 24,300.13 24,787.94 25,258.86 25,712.85 26,149.88 26,569.90 26,972.88 27,358.77 27,727.54 28,079.15 28,413.56 28,730.73 29,030.62 29,313.19 29,578.40 29,826.21 30,056.58 30,269.47 30,464.85 30,642.67 30,802.89 30,945.47 31,070.37 31,177.55 31,266.97 31,338.59 31,392.36 31,428.25 31,446.22 Principal Interest Total $ 88,742.51 $ 5,546.76 $ 94,289.27 $ 91,213.92 $ 3,075.35 $ 94,289.27 $ 62,216.04 $ $ 62,859.37 643.33 242,172.47 9,265.44 251,437.91 58 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan MARICOPA COUNTY, ARIZONA CALCULATED TOTAL OF INSTALLMENT PURCHASE CONTRACTS PAYABLE Principal and Interest Governmental Activities Department: Purpose: Maricopa Med. Ctr. MRI FY 05-06 FY 06-07 FY 07-08 $ $ 358,051.08 358,051.08 208,863.11 924,965.27 MIHS Medical Equipment $ 20,679.78 20,679.78 $ 59 Total Governmental Activities $ $ 378,730.86 358,051.08 208,863.11 945,645.05 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan County Department: County Agency: Contract Number: Lease Description: Maricopa Medical Center 900 C90000771 MRI LOAN DATA Loan amount: Annual interest rate: Term in years: Payments per year: First payment due: PERIODIC PAYMENT Calculated payment: $2,146,564.00 4.50000% 7 12 2/22/2001 AMORTIZATION SCHEDULE Payment Beginning No. Date Balance 54 7/22/2005 $ 871,685.26 55 8/22/2005 845,116.49 56 9/22/2005 818,448.09 57 10/22/2005 791,679.68 58 11/22/2005 764,810.89 59 12/22/2005 737,841.34 60 1/22/2006 710,770.66 61 2/22/2006 683,598.46 62 3/22/2006 656,324.37 63 4/22/2006 628,948.00 64 5/22/2006 601,468.97 65 6/22/2006 573,886.89 66 7/22/2006 546,201.38 67 8/22/2006 518,412.05 68 9/22/2006 490,518.51 69 10/22/2006 462,520.37 70 11/22/2006 434,417.23 71 12/22/2006 406,208.71 72 1/22/2007 377,894.40 73 2/22/2007 349,473.92 74 3/22/2007 320,946.86 75 4/22/2007 292,312.82 76 5/22/2007 263,571.40 77 6/22/2007 234,722.20 78 7/22/2007 205,764.82 79 8/22/2007 176,698.85 80 9/22/2007 147,523.89 81 10/22/2007 118,239.52 82 11/22/2007 88,845.33 83 12/22/2007 59,340.91 84 1/22/2008 29,725.85 Fiscal Year Ended 6/30 $ $ Outstanding as of June 30, 2005 Principal $ Total Interest Payment $ Total Debt Service Payable $ $29,837.59 Interest 3,268.82 3,169.19 3,069.18 2,968.80 2,868.04 2,766.91 2,665.39 2,563.50 2,461.22 2,358.56 2,255.51 2,152.08 2,048.26 1,944.05 1,839.45 1,734.45 1,629.07 1,523.28 1,417.11 1,310.53 1,203.55 1,096.17 988.39 880.21 771.62 662.62 553.22 443.40 333.17 222.53 111.47 53,279.75 $ $ Principal 26,568.77 26,668.40 26,768.41 26,868.79 26,969.55 27,070.68 27,172.20 27,274.09 27,376.37 27,479.03 27,582.08 27,685.51 27,789.33 27,893.54 27,998.14 28,103.14 28,208.52 28,314.31 28,420.48 28,527.06 28,634.04 28,741.42 28,849.20 28,957.38 29,065.97 29,174.96 29,284.37 29,394.19 29,504.42 29,615.06 29,726.11 871,685.52 $ Ending Cumulative Balance Interest 845,116.49 $ 309,782.35 818,448.09 312,951.54 791,679.68 316,020.72 764,810.89 318,989.52 737,841.34 321,857.56 710,770.66 324,624.47 683,598.46 327,289.86 656,324.37 329,853.36 628,948.00 332,314.58 601,468.97 334,673.14 573,886.89 336,928.65 546,201.38 339,080.73 518,412.05 341,128.99 490,518.51 343,073.04 462,520.37 344,912.49 434,417.23 346,646.94 406,208.71 348,276.01 377,894.40 349,799.29 349,473.92 351,216.40 320,946.86 352,526.93 292,312.82 353,730.48 263,571.40 354,826.65 234,722.20 355,815.04 205,764.82 356,695.25 176,698.85 357,466.87 147,523.89 358,129.49 118,239.52 358,682.71 88,845.33 359,126.11 59,340.91 359,459.28 29,725.85 359,681.81 (0.00) 359,793.28 Principal Interest Total $ 325,483.88 $ 32,567.20 $ 358,051.08 $ 340,436.56 $ 17,614.52 $ 358,051.08 $ 205,765.08 $ 3,098.03 $ 208,863.11 871,685.52 53,279.75 924,965.27 60 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan County Department: County Agency: Contract Number: Lease Description: MIHS 900 Cardiac Monitoring and Telementary Equipment LOAN DATA Loan amount: Annual interest rate: Term in years: Payments per year: First payment due: PERIODIC PAYMENT $236,141.06 3.25000% 3 12 11/10/2002 AMORTIZATION SCHEDULE Payment No. Date 34 7/27/2005 $ 35 8/27/2005 36 9/27/2005 Calculated payment: Fiscal Year Ended 6/30 Beginning Balance 20,568.26 13,730.65 6,874.52 $ $ Outstanding as of June 30, 2005 Principal $ Total Interest Payment $ Total Debt Service Payable $ $6,893.32 Interest 55.71 37.19 18.62 111.52 $ $ Principal 6,837.61 6,856.13 6,874.52 20,568.26 $ Ending Balance 13,730.65 6,874.52 0.00 Cumulative Interest $ 11,962.47 11,999.66 12,018.28 Principal Interest Total $ 20,568.26 $ 111.52 $ 20,679.78 20,568.26 111.52 20,679.78 61 Maricopa County, Arizona Department of Finance Debt Management Division Debt Management Plan 62 Maricopa County, Arizona Department of Finance Debt Management Division