Loading...
HomeMy WebLinkAboutComprehensive Annual Financial Report (CAFR)-Audit Records-9/30/2009 CITY OF COLLEYVILLE, TEXAS COMPREHENSIVE ANNUAL FINANCIAL REPORT YEAR ENDED SEPTEMBER 30, 2009 Prepared by Finance Department Terry Leake Assistant City Manager/Chief Financial Officer THIS PAGE LEFT BLAN.K INTENTIONALLY CITY OF COLLEYVILLE, TEXAS TABLE OF CONTENTS YEAR ENDED SEPTEMBER 30, 2009 Page Number INTRODUCTORY SECTION Letter of Transmittal.. ..... ..... ... ..... ............ ................ ... ......... ...... ........ .... ... ... ..... ..... ... ..... ..... 3 - 6 Organizational Chart............................................................................. ~............................. 7 Certificate of Achievement................................................................................................. 8 Principal Officials............................................................................................................... 9 FINANCIAL SECTION Independent Auditors' Report............................................................................................. 13 - 14 Management's Discussion and Analysis............................................................................ 1 7 - 24 Basic Financial Statements S ta tern en t 0 f Net As sets .... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 - 27 Statement of Activities..................................................................................................... 28 - 29 Balance Sheet - Governmental Funds............................................................................. 30 - 31 Statement of Revenues, Expenditures and Changes in Fund Balances - Governmental Funds......................................................................... 32 - 33 Reconciliation of the Statement of Revenues, Expenditures and Changes in Fund Balance of Governmental Funds to the S ta tern en t 0 fActi viti es . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual- General Fund ................................................... 35 ( continued) CITY OF COLLEYVILLE, TEXAS TABLE OF CONTENTS (Continued) YEAR ENDED SEPTEMBER 30, 2009 FINANCIAL SECTION (Continued) Basic Financial Statements (Continued) Statement of Net Assets - Proprietary Funds.................................................................. Statement of Revenues, Expenses and Changes in Fund Net Assets - Proprietary Funds........................................................................... Statement of Cash Plows - Proprietary Funds................................................................. Statement of Fiduciary Net Assets - Fiduciary Funds.. ..... ................... ................. .......... Notes to Basic Financial Statements................................................................................ Nonmajor Governmental Funds Combining Balance Sheet........... ..................................................................................... Combining Statement of Revenues, Expenditures and Changes in Fund Balances............................................................................................ Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual- Debt Service Fund........................................... Agency Funds Page Number 36 37 38 - 39 40 41 - 66 70 - 74 76 - 80 81 Combining Statement of Fiduciary Net Assets......... ....... .......... ....... ..... ..... ......... ... ......... 83 Combining Statement of Changes in Assets and Liabilities............................................ 84 ( continued) CITY OF COLLEYVILLE, TEXAS TABLE OF CONTENTS (Continued) YEAR ENDED SEPTEMBER 30, 2009 Changes in Net Assets ............................................................................ Page Exhibit/Table Number 1 87 2 88 - 89 3 91 4 92 - 93 STATISTICAL SECTION (Unaudited) Net Assets by Government ..................................................................... Fund Balances - Governmental Funds ..... ... ....... ....... .................. ..... ...... Changes in Fund Balances - Governmental Funds ................................ Assessed Value and Estimated Actual Value ofT axab 1 e Property.............................................................................. 5 94 6 95 7 96 8 97 9 98 10 99 11 100 12 101 13 102 14 104 - 105 15 106 16 107 Direct and Overlapping Property Tax Rates........................................... Princ i pal Property T axpa yers . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Property Tax Levies and Collections...................................................... Principal Water Customers..................................................................... Ratios of Outstanding Debt by Type...................................................... Ratios of General Bonded Debt Outstanding.... ....... ... ........... ..... ............ Direct and Overlapping Governmental Activities Debt.......................... Legal Debt Margin Information.............................................................. Pledged Revenue Coverage.................................................................... Demographic and Economic Statistics................................................... Prin c i pal Tax payers ................................................................................ Fulltime Equivalent City Government Employees by Functi on/Pro gram ................................................................................ 17 108 Operating Indicators by Function/Program ... ..... ..... ..... ......... ... ..... ... ...... 18 109 Capital Asset Statistics by Function/Program.... ........ .................... ......... 19 110 THIS PAGE LEFT BLANK .INTENTIONALLY INTRODUCTORY SECTION 1 THIS PAGE INTENTIONALLY LEFT BLANK 2 C:itjl (){ .T(~xa5 February 2, 2010 To the Citizens of the City ofColleyville: The Comprehensive Annual Financial Report of the City ofColleyville (the "City") for the fiscal year ended September 30,2009, is hereby submitted. Responsibility for both the accuracy of the data, and completeness and fairness of the presentation, including all disclosures, rests with the City. To the best of our knowledge and belief, the enclosed data are accurate in all material respects and are reported in a manner designed to present fairly the financial position, results of operations and cash flows of the various funds of the City. All disclosures necessary to enable the reader to gain an understanding of the City's fmancial activities have been included. In developing and evaluating the City's accounting system, consideration is given to the adequacy of internal accounting controls. These controls are designed to provide reasonable, but not absolute, assurance regarding the safeguarding of assets against loss from unauthorized use or disposition, and the reliability of financial records for preparing financial statements and maintaining accountability for assets. The concept of reasonable assurance recognizes that the cost of a control should not exceed the benefits likely to be derived, and the evaluation of costs and benefits requires estimates and judgments by management. We believe that the City's current system of internal controls adequately safeguards assets and provides reasonable assurance of proper recording of financial transactions. As required by the City's charter, the financial statements have been audited by Pattillo, Brown & Hill, L.L.P., a firm of certified public accountants. The goal of the independent audit was to provide reasonable assurances that the financial statements of the City of Colleyville for the fiscal year ended September 30, 2009, are free of material misstatement. The independent audit involved examining on a test basis, evidence supporting the amounts and disclosures in the financial statements; assessing the accounting principles used and significant estimates made by management; and evaluating the overall financial statement presentation. The independent auditor concluded based upon the audit that there was a reasonable basis for rendering an unqualified opinion that the City ofColleyville's financial statements for fiscal year ended September 30, 2009, are presented in conformity with generally accepted accounting principles (GAAP). As required by GAAP, management provides a narrative introduction, overview and analysis to accompany the basic fmancial statements in the form of Management's Discussion and Analysis (MD&A). This letter of transmittal is designed to complement the MD&A and should be read in conjunction with it. The City's MD&A can be found inunediately following the independent auditors report. 3 100 MAIN STREET COLLEYVILLE) TEXAS 76034 (817) 503..1000 PROFILE OF THE GOVERNMENT On January 10, 1956, the City of Colleyville was incorporated and adopted a home-rule charter on January 15, 1977 . It has a Council-Manager form of government with policy making and legislative authority vested in a governing body consisting of a Mayor and six Council members. The Mayor and Council are responsible for passing ordinances, adopting the budget, appointing board and conunittee members, and hiring the City Manager. The City Manager is responsible for carrying out the policies and ordinances of the Mayor and Council, overseeing the day-to-day operations of the City, and appointing department heads. The Mayor and six Council members are elected on an at-large, non-partisan basis for three-year terms. The three-year terms are staggered so that the Mayor and City Council persons from Place 1 and 2 are elected in year one, City Council persons from Places 3 and 4 are elected in year two, and City Council persons from Places 5 and 6 are elected in year three. The City provides a full range of municipal services. These services include police and fire protection, municipal court, streets, drainage utility, leisure services (parks and recreation, Colleyville Center and library), water and sewer, engineering/conununity development, and general administrative services. Based upon the criterion set forth in generally accepted accounting principles, the following organizations are includable within the City's reporting entity: Entity Method of Inclusion Colleyville Economic Development Corporation (CEDC) Colleyville Crime Control and Prevention District Colleyville Tax Investment Financing Reinvestment Zone Zone Number One (TIF) Blended Blended Discretely Presented The City Charter of the City ofColleyville establishes the fiscal year as October 1 through September 30. The Charter requires the City Manager to submit a proposed budget and accompanying budget message to the City Council each year and the proposed budget is presented to the City Council at a budget work session. After public hearings at two consecutive regular City Council meetings, the Council may adopt the proposed budget, with or without amendment. The budget ordinance is to be adopted no later than the 30th day of September and requires an affirmative vote of a majority of the Council. The City maintains budgetary control by adopting an annual operating budget for the General Fund, Debt Service Fund, Drainage Utility Fund, and Water and Sewer Enterprise Fund. Detail control is maintained at the line item level by encumbering available funds at the time a purchase order is written. Encumbrances lapse at fiscal year-end, but can be re-appropriated through a budget amendment during the following fiscal year. The City Manager is authorized to transfer budgeted amounts between departments within any fund. However, any revisions that alter the total expenditures of any fund must be approved by the City Council. LOCAL ECONOMY The City of Colleyville is a residential-oriented conununity located 11 miles northeast of the City of Fort Worth, 22 miles northwest of Dallas and 5 miles west of Dallas/Fort Worth International Airport in Northeast Tarrant County. Relocations of residents to the City continued in fiscal year 2009, as did commercial development. During the fiscal year, the City issued 90 residential building permits and the average square footage of a residence was almost 5,000 square feet. 4 In the winter of2009, construction was completed on the $5 million ground storage tank in the western area of the City. Construction was also completed on Church Street and Bogart Drive located in the middle of Colleyville, providing easy access to the central commercial corridor ofColleyville. Additionally, in spring 2009 construction began on Phase II of McPherson Park, which will include water conservation areas, garden demonstration areas, spray park and renovations to the existing Rock House as a learning center. For the Future. In spring 2010, construction will begin on the renovation of the Colleyville Center, which opened in 1998. Improvements include updated fInishes, updated audio-visual equipment, and improved acoustics. The Library will expand to the second floor of the building with construction beginning in summer 2010. It is proposed to move the existing children's area upstairs and provide programming/meeting rooms on the second floor. The first floor of the Library will be primarily for adults and computer areas. In an effort to enhance and strategically focus the City's economic development efforts, a comprehensive marketing plan will be completed in Fiscal Year 2010. The plan will define target retail tenants for the City's primary business corridors and identify prospective retail operators for Colleyville. LONG- TERM FINANCIAL PLANNING In Fiscal Year 2005, the City Council adopted a Fund Balance Policy requiring a 90-day reserve for fund balance in both the General Fund and the Utility Fund. At the end of Fiscal Year 2009, both the General Fund and the Utility Fund have a fund balance in excess of the required 90-day reserve. The amount in excess of the reserve may be used to fund one-time capital expenditures. As a part of the Fiscal Year 2009 budget process, the Mayor and Council and City Staff embarked upon developing a multi-year capital improvements program. Long-term water storage and delivery needs in the western area of Colleyville are being addressed with the construction of a ground storage tank and the completion of transmission lines. Additionally, the Council appointed a citizen committee that reviewed street infrastructure needs and financing opportunities. Their recommendations were incorporated into an infrastructure program approved by Council in Fiscal Year 2008. AWARDS AND ACKNOWLEDGEMENTS Awards. The Government Finance Officers Association of the United States and Canada (GFOA) awarded a Certificate of Achievement for Excellence in Financial Reporting to the City of Colleyville for its comprehensive annual financial report for the fiscal year ended September 30, 2008. This was the 19th consecutive year the City has received this prestigious award. In order to be awarded a Certificate of Achievement, a government must publish an easily readable and efficiently organized comprehensive annual financial report. This report must satisfy both generally accepted accounting principles and applicable legal requirements. A Certificate of Achievement is valid for a period of one year only. We believe that our current comprehensive annual financial report continues to meet the Certificate of Achievement Program's requirements and we are submitting it to GFOA to determine its eligibility for another certificate. 5 In addition, the City also received the GFOA's Distinguished Budget Presentation award for its annual budget dated October 1, 2008. In order to qualify for this award, the City's budget document was judged to be proficient in several categories, including as a policy document, a financial plan, an operations guide, and a communications device. Acknowledgements,: The preparation of this report could not be accomplished on a timely basis without the dedicated endeavors of the entire staff of the Finance Department. I would like to express my sincere appreciation to all employees who contributed to the preparation. Additionally, I would also like to thank the Mayor, City Council, and City Manager for their support in planning and conducting the financial operations of the City in a responsible and progressive manner. Respectfully submitted, Terry Leake Finance Director 6 CITY OF COLLEYVILLE ORGANIZATIONAL CHART CITIZENS OF FISCAL YEAR 2009 COLLEYVILLE CRIME LIBRARY PLANNING ZONING CONTROL BOARD AND ZONING BOARD OF AND COMMISSION ADJUSTMENT PREVENTION DISTRICT CITY COLLEYVILLE COUNCIL ECONOMIC DEVELOPMENT CORPORATION SIGN PARKS AND AD HOC TAX BOARD OF RECREATION COMMITTEES INCREMENT APPEALS BOARD FINANCING DISTRICT I 1 CITY CITY MUNICIPAL MANAGER ATTORNEY JUDGE PATROL POLICE CHIEF ASSISTANT INVESTIGATIONS ~ :........- . . CITY ANIMAL CONTROL MANAGER ~. ECONOMIC DEVELOPMENT ;....-.. BUILDING DIRECTOR LIBRARY SERVICES & DIRECTOR COMMUNITY CENTER MANAGER STREETS & DRAINAGE PUBLIC WORKS PUBLIC FLEET MAINTENANCE OPERATIONS WORKS - UTILITY ADMIN. & MANAGER DIRECTOR nPFRATlnN PARKS AND HUMAN RECREATION RESOURCES DIRECTOR RESPONSE FIRE CHIEF I NSPECTIONSI - - INVESTIGATIONS BUDGET & ADMINISTRATIVE COMMUNICATIONS SERVICES MANAGER MANAGER UTILITY BILLING FINANCE MUNICIPAL COURT ~ DIRECTOR - I ~HAB INFORMATION COMMUNITY SERVICES - DEVELOPMENT DIRECTOR CITY ,iM ~ SECRETARY - BUILDING INSPECTION CODE ENFORCEMENT 7 ~ .~ Certificate of Achievement for Excellence in Financial Reporting Presented to City of Colleyville Texas For its Comprehensive Annual Financial Report for the Fiscal Year Ended September 30, 2008 A Certificate of Achievement for Excellence in Financial Reporting is presented by the Government Finance Officers Association of the United States and Canada to government units and public employee retirement systems whose comprehensive annual financial reports (CAFRs) achieve the highest standards in government accounting and financial reporting. President ~/~ E-xecutive Director 8 CITY OF cOLLEYVILLE, TEXAS HOME RULE, COUNCIL - MANAGER FORM OF GOVERNMENT CITY OFFICIALS YEAR ENDED SEPTEMBER 30, 2009 David Kelly Mayor Carol Wollin Councilmember, Place 1 Michael Muhrn Councilrnember, Place 2 Stan Hall Councilrnernber, Place 3 Jon Ayers Mayor Pro Tern and Councilmember, Place 4 Tom Hart Councilmember, Place 5 Mike Taylor Councilmember, Place 6 Jennifer Fadden City Manager Terry Leake Assistant City Manager/Chief Financial Officer 9 THIS PAGE INTENTIONALLY LEFT BLANK 10 FINANCIAL SECTION 11 THIS PAGE INTENTIONALLY LEFT BLANK 12 81~ PATTILLO, BROWN & HILL,L.L.p. CERTIFIED PUBLIC ACCOUNTANTS. BUSINESS CONSULTANTS INDEPENDENT AUDITORS' REPORT To the Honorable Mayor and Members of the City Council City of Colleyville, Texas We have audited the accompanying financial statements of the governmental activities, the business-type activities, the aggregate discretely presented component unit, each major fund, and the aggregate remaining fund information of City of Colleyville, Texas, as of and for the year ended September 30, 2009, which collectively comprise the City's basic financial statements as listed in the table of contents. These financial statements are the responsibility of the City's management. Our responsibility is to express opinions on these basic financial statements based on our audit. We conducted our audit in accordance with auditing standards generally accepted in the United States of America Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free of material misstatement. An audit includes examining, ona test basis, evidence supporting the amounts and disclosures in the financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall financial statement presentation. We believe that our audit provides a reasonable basis for our opinions. In our opinion, the financial statements referred to above present fairly, in all material respects, the financial position of the governmental activities, the business-type activities, the aggregate discretely presented component unit, each major fund, and the aggregate remaining fund information of the City of Colleyville, Texas, as of September 30, 2009, and the respective changes in financial position and, where applicable, cash flows and the respective budgetary comparison for the General Fund, thereof for the year then ended in conformity with accounting principles generally accepted in the United States of America. 13 401 WEST IDGHWAY 6. P. o. BOX 20725 . WACO, TX 76702-0725. (254) 772-4901 . FAX: (254) 772-4920. www.pbhcpa.com AFFll..IATE OFFICES: BROWNSVILLE, TX (956) 544-7778 . HILLSBORO, TX (254) 582-2583 TEMPLE, TX (254) 791-3460 . WIll1NEY, TX (254) 694-4600 . ALBUQUERQUE, NM (505) 266..5904 The management's discussion and analysis on pages 17 through 24 is not a required part of the basic financial statements but is supplementary information required by accounting principles generally accepted in the United States of America. We have applied certain limited procedures, which consisted principally of inquiries of management regarding the methods of measurement and presentation of the required supplementary information. However, we did not audit the information and express no opinion on it. Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the City of Colleyville, Texas' basic financial statements. The introductory section, combining and individual fund financial statements and schedules, and statistical tables are presented for purposes of additional analysis and are not a. required part of the basic financial statements. The combining and individual nonmajor fund financial statements and schedules have been subjected to the auditing procedures applied in the audit of the basic financial statements and, in our opinion, are fairly stated in all material respects in relation to the basic financial statements taken as a whole. The introductory section and statistical section have not been subjected to the auditing procedures applied in the audit of the basic financial statements and, accordingly, we express no opinio~ on them. M B~ f 7-!il1 L.L.f , I January 19, 2010 14 MANAGEMENT'S DISCUSSION AND ANALYSIS 15 THIS PAGE INTENTIONALLY LEFT BLANK 16 . Management's Discussion and Analysis As management of the City of Colleyville, we offer readers of the City's financial statement this narrative overview and analysis of the financial activities of the City for the fiscal year ended September 30, 2009. We encourage readers to consider the information presented here in conjunction with additional information that we have furnished in our letter of transmittal, which can be found on pages 3 - 6 of this report. FINANCIAL HIGHLIGHTS . The assets of the City of Colleyville exceeded its liabilities as of September 30, 2009, by $156,072,736 (net assets). Of this amount, $35,626,600 (unrestricted net assets) may be used to meet the City's ongoing obligations to citizens and creditors in accordance with the City's fund designation and fiscal policies. . The City's total net assets increased by $7,531,899. . As of the close of the current fiscal year, the City ofColleyville's governmental funds reported combined ending fund balances of $28,965,968. Of this amount, $21,862,136 is unreserved fund balance available for use within the City's fund designation and fiscal policies. . As of September 30, 2009, unreserved, undesignated fund balance for the General Fund was $8,207,420 or 44% of the total General Fund budgeted expenditures and other financing uses. OVERVIEW OF THE FINANCIAL STATEMENTS This discussion and analysis is intended to serve as an introduction to the City's basic financial statements. The City's basic financial statements are comprised of three components: (1) govemment- wide financial statements, (2) fund financial statements and (3) notes to the financial statements. This report also contains other supplementary information in addition to the basic financial statements themselves. Government-wide financial statements - The government-wide financial statements, which begin on page 26 of this report, are designed to provide readers with a broad overview of the City's finances, in a manner similar to a private-sector business. The Statement of Net Assets presents information on all of the City's assets and liabilities, with the difference between the two reported as net assets. Over time, increases or decreases in net assets may serve as a useful indicator of whether the financial position of the City is improving or deteriorating. The Statement of Activities presents information showing how the City's net assets changed during the fiscal year. All changes in net assets are reported when the underlying event giving rise to the change occurs, regardless of the timing of related cash flows. Thus, revenues and expenses are reported in this statement for some items that will only result in cash flows in the future fiscal periods (e.g., uncollected taxes and earned but unused compensated absences). 17 Both of the government-wide financial statements distinguish functions of the City that are principally supported by taxes and intergovernmental revenues (governmental activities) from functions that are intended to recover all or a significant portion of their costs through user fees and charges (business-type activities). The governmental activities of the City include General Government, Community Development and Engineering, Fire and Rescue, Leisure Services, Maintenance, Municipal Court, Police, and Streets and Drainage. The business-type activities of the City include Water and Wastewater, and Drainage Utility. Fund financial statements - A fund is a grouping of related accounts that is used to maintain control over resources that have been segregated for specific activities or objectives. The City, like other state and local governments, uses fund accounting to ensure and demonstrate compliance with finance-related legal requirements. All funds of the City can be divided into two categories - governmental funds and proprietary funds. Governmental Funds - Governmental funds are used to account for essentially the same functions reported as governmental activities in the government-wide financial statements. However, unlike the government-wide financial statements, governmental fund financial statements focus on current sources and useS of'spendable resources, as well as on balances of spendable resources available at the end of the fiscal year. Such information may be useful in evaluating a government's near-term financing requirements. Because the focus of governmental funds is narrower than that of the government-wide financial statements, it is useful to compare the information presented for governmental funds with similar information presented for governmental activities in the government-wide financial statements. By doing so, readers may better understand the long-term impact of the government's near-term financing decisions. Both the governmental funds balance sheet and the governmental fund statements of revenues, expenditures, and changes in fund balances provide a reconciliation to facilitate this comparison between governmental funds and governmental activities. Beginning on page 32 of this report, information is presented separately in the Governmental Fund Balance Sheet and in the Governmental Fund Statement of Revenues, Expenditures, and Changes in Fund Balances for the General Fund, which is considered to be a major fund. Data from the other governmental funds are combined into a single, aggregated presentation. Individual fund data for each of these non-major governmental funds is provided in the form of combining statements elsewhere in this report. Proprietary Funds - The City maintains one type of proprietary funds. Enterprise Funds are used to report the same functions presented as business-type activities in the government-wide financial statements. The City uses Enterprise Funds to account for the Water and Wastewater and Drainage Utility Funds. Proprietary funds provide the same type of information as the government-wide financial statements, only in more detail. The basic proprietary fund financial statements which begin on page 36 of this report provide separate information for the Water and Wastewater and Drainage Utility Enterprise Funds since these are considered to be major funds of the City. Notes to the Financial Statements - The notes provide additional information that is essential to a full understanding of the data provided in the government-wide and fund financial statements. The notes to the financial statements can be found on pages 41 - 66 of this report. 18 Other Information - In addition to the basic financial statements and accompanying notes, this report also presents combining fund statements and schedules that further support the information in the financial statements. The combining fund statements and schedules for nonmajor funds are presented immediately following the notes to the financial statements beginning on page 70 of this report. GOVERNMENTAL-WIDE FINANCIAL ANALYSIS As noted earlier, net assets may serve over time as a useful indicator of government's financial position. In the case of the City of Colleyville, assets exceeded liabilities by $156,072,736 as of September 30, 2009. The largest portion of the City's net assets ($118,418,059) reflects its investments in capital assets (e.g., land, building, equipment, improvements, construction in progress and infrastructure), less any outstanding debt used to acquire those assets. The City uses these capital assets to provide service to citizens; consequently, these assets are not available for future spending. Although the City's investment in its capital assets is reported net of related debt, it should be noted that the resources needed to repay this debt must be provided from. other sources, since the capital assets themselves cannot be used to liquidate these liabilities. Current and other assets $ Capital assets Total assets CITY OF COLLEYVILLE'S NET ASSETS Governmental Activities Business~type Activities Totals 2009 2008 2009 2008 2009 2008 30,969,411 $ 24,989,626 $ 10,419,510 $ 10,834,957 $ 41,388,921 $ 35,824,583 103,184,780 103,727,039 46,244,562 47,322,148 149,429,342 151,049,187 134,154,191 128,716,665 56,664,072 58,157,105 190,818,263 186,873,770 3,725,217 3,763,168 2,089,467 2,714,360 5,814,684 6,4 77,528 22,645,717 24,716,947 6,285,126 7,138,458 28,930,843 31,855,405 26,370,934 28,480,1 15 8,374,593 9,852,818 34,745,527 38,332,933 Other liabilities Long-term liabilities Total liabilities Net assets: Invested in capital assets, net of related debt Restricted Unrestricted 79,243,497 1,040,896 27,498,864 77,484,725 889,689 21,862,136 39,174,562 987,181 8,127,736 39,442,148 1,024,349 7,837,790 118,418,059 2,028,077 35,626,600 1 16,926,873 1,914,038 29,699,926 Total net assets $ 107,783,257 $ 100,236,550 $ 48,289,479 $ 48,304,287 $ 156,072,736 $ 148,540,837 A portion of the City's net assets ($2,028,077) represents resources that are subject to external restriction on how they may be used. The remaining balance ($35,626,600) of unrestricted net assets may be used to meet the City's ongoing obligation to citizens and creditors in accordance with the City's fund designation and fiscal policies. As of September 30, 2009, the City has positive balances in all three categories of net assets, both for the City as a whole, as well as for its governmental and business-type activities separately. The increase in net assets relating to governmental activities is due to an increase in ad valorem tax collections due to a 6% increase in assessed valuation. During the fiscal year, the City received an over $6.2 million signing bonus for a gas lease on City-owned property. The decrease in net assets of business type activities related to sharply lower investment revenue and capital contributions. 19 Analysis of the City's Operations - The following table provides a summary of the City's operations for the year ended September 30, 2009. Governmental activities increased the City of Colleyville's net assets by $7,546,707, accounting for all of the total growth in net assets. Business-type activities contributed a decrease to the City's net assets of$14,808. CITY OF COLLEYVILLE'S CHANGES IN NET ASSETS Governmental Activities Business-type Activities Totals 2009 2008 2009 2008 2009 2008 Revenues: Program revenues: Charges for services $ 8,817,875 $ 3,773,311 $ 12,178,505 $ 11,973,905 $ 20,996,380 $ 15,747,216 Operating grants and contributions 713,189 1,856,567 713,189 1,856,567 Capital grants and contributions 360,023 3,973,954 63,293 1,415,785 423,316 5,389,739 General revenues: Ad valorem taxes 12,121,420 11,367,967 12,121,420 11,367,967 Sales taxes 4,718,976 4,740,964 4,718,976 4,740,964 Franchise taxes 2,017,440 1,818,060 2,017,440 1,818,060 Other taxes 74, I 98 82,532 74,198 82,532 Investment earnings 471,524 804,864 168,940 380,595 640,464 1,185,459 Miscellaneous 77,854 96,348 77,854 96,348 Gain on sale of capital assets 25,237 116, 112 25,237 116,112 Total revenues 29,397,736 28,630,679 12,410,738 13,770,285 41,808,474 42,400,964 Expenses: General government 2,945,481 2,8 14,874 2,945,481 2,814,874 Community development and engineering 1,530,90 I 1,481,124 1,530,901 1,481, 124 Fire and rescue 4,113,793 3,958,111 4,113,793 3,958, III Leisure services 3,941,259 4,033,105 3,941,259 4,033,105 Maintenance 455,752 417,265 455,752 417,265 Municipal court 291,724 324,020 291,724 324,020 Police 4,841,217 4,657,438 4,841,217 4,657,438 Streets and drainage 3,503,519 3,129,730 3,503,519 3,129,730 Water and wastewater 10,612,372 11,179,548 10,612,372 11,179,548 Drainage 658,016 593,600 658,016 593,600 Interest on long-term debt 1,051,180 1,101,714 331,361 362,642 1,382,541 1,464,356 Total expenses 22,674,826 21,917,381 11,601,749 12,135,790 34,276,575 34,053,171 Increases in net assets before transfers 6,722,910 6,713,298 808,989 I ,634,495 7,531,899 8,347,793 Transfers 823,797 841,936 823,797) 841,936) Change in net assets 7,546,707 7,555,234 14,808) 792,559 7,531,899 8,347,793 Net assets, beginning 100,236,550 94,845,083 48,304,287 47,511,728 148,540,837 142,356,811 Prior period adjustments 2,163,767) 2,163,767) Net assets, ending $ 107,783,257 $ 100,236,550 $ 48,289,479 $ 48,304,287 $ 156,072,736 $ 148,540,837 20 FINANCIAL ANALYSIS OF THE GOVERNMENT'S FUNDS Governmental funds - The focus of the City of Colleyville's governmental funds is to provide information on near-term inflows, outflows, and balances of spendable resources. Such information is useful in assessing the City's financing requirements. In particular, unreserved fund balance may serve as a useful measure ofa government's net resources available for spending at the end of the fiscal year. At the end of the current fiscal year, the City of Colleyville's governmental funds reported combined ending fund balances of $28,965,968. Approximately 96% of this total amount ($27,844,401) constitutes unreserved fund balance. The remainder of the fund balance ($1,121,567) is reserved to indicate that is not available for new spending because it has already been committed to pay for encumbrances or debt service or to provide for other items. Refer to page 30 of this report for a more detailed presentation of governmental fund balances. In the General Fund, the City originally budgeted for a decrease in the fund balance of $833,523 as a planned reduction of excess fund balance to fund "pay-as-you-go" capital expenditures and Tara subdivision street improvements. While there was a budget adjustment in Fiscal Year 2009 the expense was offset by additional revenues, the final budgeted decrease in fund balance was $833,523. The actual decrease to fund balance for the General Fund was $509,978 for fiscal year 2009, due to greater than anticipated revenues from property taxes and utility franchise taxes. Proprietary funds - The City's proprietary fund statements beginning on page 36 of this report provide the same type o.f information found in the government-wide financial statements, but in more detail. Unrestricted net assets of the respective major proprietary funds are Water and Wastewater ($7,216,817), and Drainage Utility ($910,919). The Water and Wastewater Fund experienced a decrease in total net assets of $148,317 during Fiscal Year 2009 due to lower investment income and contributed capital. The Drainage Utility Fund's net assets increased by $133,509, due to increased service charge revenue. Governmental Activities - The major increase in revenues comes from the tax category. The property tax base increased over $216 million, due to construction of new residences and businesses in 2008, and revaluation of property. The current year tax collection rate was almost 99% of the levy. There ~as a sharp decrease in both license and permit revenues due to a decrease in residential building permits. Fines and forfeitures were up due to an increase in citations issued and enhanced warrant collections. Investment income is down due to lower interest rates from the Federal Reserve lowering rates due to the current recession. New in Fiscal Year 2009 is the Colleyville Tomorrow Fund which is funded from proceeds the City received from gas leases on City-owned properties. Enhancements to the Fiscal Year 2009 budget continue the renewed focus on street maintenance with a budget of $1,680,000 of which $680,000 was to be used for street improvements and re-construction in the Tara subdivision. The increase in the general government relates to the acquisition of blades and a san server. Leisure services increases are related to various contractual services of McPherson Park, a 22-acre park in the northwest area of the City that opened in winter 2009. The Debt Service Fund's expenditures decreased due a decrease in the 2002 Certificates of Obligation payments for the portion of the debt for the City Hall and Library used furnishings and equipment. Also, the Fiscal Year 2008 repayment of the $420,000 bank line of credit used to furnish the fire stations did not reoccur in Fiscal Year 2009. 21 Business-type Activities - The City has two enterprise operations, the Water and Wastewater Fund and the Drainage Utility Fund. Total operating revenues of the Water and Sewer fund were $11,303,868 for the fiscal year. Water sales increased due to a rate increase in December 2008 which passed through a rate increase from the Trinity River Authority, the City's provider of treated waste. Also, wastewater sales increased primarily due to the pass-through rate increase to offset the rate increase from Trinity River Authority, who also provides wastewater treatment to the City. The coverage ratio for debt for this fund was 1.9 for the fiscal year. The slight increase in the Drainage Utility Fund's revenues was due to new residential and commercial construction. Increases in the Water and Wastewater Fund expenses relate to the increase in cost of purchased water and treatment of wastewater from Trinity River Authority. The Authority's increase relates to higher cost for electricity, debt issuance for plant expansion, replacement of system-wide aging infrastructure and compliance with federal water and wastewater mandates. General Fund Budgetary Highlights - The City made reVISIons to the original appropriations approved by the City Council. Overall, these changes resulted in an increase from the original budget of $19,391,408. The increase was for the funding of payments to recreational instructors due to greater than anticipated recreation program participation that was offset by revenues. Also, included in the budget amendment was the transfer of unsent street resurfacing appropriations to the Capital Projects Fund for future street projects. The General Fund's overall budgeted revenue decreased by $1,517,280. The major decrease was in the licenses and permits category was due to an unanticipated drop construction activity which occurred shortly after the fiscal year began. Also, included in the budgeted revenues was the drawdown of fund balance in the amount of $833,523 that is not reflected in the actual revenue amounts. However, there was an increase in revenue from greater citation issuance and enhanced warrant collections and the aforementioned recreation program revenue. Refer to the General Fund Statement of Revenue, Expenditures and Changes in Fund Balances - Budget and Actual on page 35 of this report for a detailed presentation of the actual General Fund operations compared to both the original and final budget for fiscal year 2009. CAPITAL ASSETS The City ofColleyville's investment in capital assets for its governmental and business-type activities as of September 30, 2009, amounts to $149,429,342 (net of accumulated depreciation). This investment in capital assets includes land, building, equipment, improvements other than buildings, infrastructure and construction work in progress. Major capital asset events occurring during the current fiscal year included the following: . Capitalized approximately $4.7 million in street improvements and contributions; · Capitalized approximately $8.0 million on various water and wastewater system projects and contributions including the L.D. Lockett $5 million ground storage tank; and . Capitalized $.33 million in drainage improvements. 22 CITY OF COLLEYVILLE'S CAPITAL ASSETS AT YEAR-END Governmental Activities Business-type Activities Totals 2009 2008 2009 2008 2009 2008 Land $ 9,293,654 $ 9,293,654 $ 313,057 $ 313,057 $ 9,606,711 $ 9,606,711 Buildings and improvements 40,536,708 40,433,039 53,922 53,922 40,590,630 40,486,961 Equipment 7,364,496 7,028,032 1,740,485 1,778,060 9,104,981 8,806,092 Infrastructure/water distribution sewer collection 75,202,099 70,656,502 67,391,621 59,062,048 142,593,720 129,718,550 Construction in progress 2,140,424 4,645,335 361,742 7,967,420 2,502,166 12,612,755 Less: accumulated depreciation 31,352,60 l) 28,329,523) 23,616,265 ) 21,852,359) 54,968,866) 50,181,882) Total capital assets $ 103,184,780 $ 103,727,039 $ 46,244,562 $ 47,322,148 $ 149,429,342 $ 151,049,187 Additional information on the City's capital assets 'Can be found in Note 4, pages 55 - 57 of this report. DEBT ADMINISTRATION At the end of the current fiscal year, the City of Colleyville had total bonded debt, notes payable and capital lease obligations of$31,294,366. Of this amount, $14,665,000 represents bonded debt backed by the full faith and credit of the government, $9,199,370 represents bonds secured by sales tax revenues, $5,200,000 represents bonds secured solely by water and sewer revenues, and $1,870,000 represents bonds secured solely by drainage utility system revenues. The City's capitalized lease obligations of $359,996 pertain to the purchase of a fire pumper truck and ambulance. OUTSTANDING DEBT AT YEAR-END BONDS, NOTES AND CAPITALIZED LEASE OBLIGATIONS PAYABLE Governmental Activities Business-type Activities Totals 2009 2008 2009 2008 2009 2008 General obligation bonds and certificates of obligation $ 14,665,000 $ 16,275,000 $ $ $ 14,665,000 $ 16,275,000 Sales tax revenue bonds 9,199,370 9,795,916 9,199,370 9,795,916 Revenue bonds payable 7,070,000 7,880,000 7,070,000 7,880,000 Capitalized lease obligations 359,996 430,549 359,996 430,549 $ 24,224,366 $ 26,501,465 $ 7,070,000 $ 7,880,000 $ 31,294,366 $ 34,381,465 The City's General Obligation, Tax and Water Works and Sewer System Certificates of Obligation, and Water Works and Sewer System Revenue Bond ratings are listed below. Fitch leBA Standard and Poor's General Obligation Bonds Water Revenue Bonds AA+ AA+ MA MA 23 During Fiscal Year 2009, the City received an upgrade to AAA from Standard & Poor's on both its General Obligation Bonds and Water Revenue Bonds. Most of the City's bonds are insured, thus holding an AAA credit rating from both Fitch ICBA and Standard & Poor's. Additional information on the City ofColleyville's long term-debt can be found in footnote 4 on pages 59 - 63 of this report. ECONOMIC FACTORS AND NEXT YEAR'S BUDGETS AND RATES The General Fund budget (including transfers in and planned utilization of surplus) for fiscal year 2010 is based on a projected revenue loss of 2.1 % as compared to the fiscal year 2009 budget. There is an increase projected in property tax revenue, which comprises 54% of General Fund revenues. The 2.9% increase as compared to the 2009 budget is primarily derived from new construction. The total tax rate for fiscal year 2010 is $.3559, which is unchanged since fiscal year 2008. Approximately 14% of General Fund revenues are sales taxes, and sales taxes are budgeted with no increase over the fiscal year 2009 budget. The major revenue decrease ($640,367) is in the area of licenses and permits, anticipating 73 housing starts as compared to 145 budgeted in Fiscal Year 2010. The 2010 budget includes a planned $702,000 utilization of surplus fund balance to fund one-time capital expenditures for street improvements in the Saddlebrook subdivision. There is no pay increase included in the 2010 budget for the General Fund or other funds, due to current economic conditions. The General Fund has continued to budget $1,000,000 in the Street Department budget for the street overlay budget that will overlay approximately five miles of City streets exclusive of the aforementioned Saddlebrook subdivision project. Slight revenue growth in the Water and Wastewater Fund will come from additional residential and commercial customers. There is an in-house water and wastewater rate study to be completed by summer 2010. The study will review tiered rate options and minimum bill options and projected Trinity River Authority rate increases to maintain the financial stability of the Water and Wastewater Fund in future years. REQUEST FOR INFORMATION The financial report is designed to provide our citizens, customers, investors and creditors with a general overview of the City's finances. If you have questions about this report or need any additional information, contact Terry Leake, Assistant City Manager / Chief Financial Officer, at 100 Main Street, Colleyville, Texas 76034, or call (817) 503-1115. 24 BASIC FINANCIAL STATEMENTS 25 CITY OF COLLEYVILLE, TEXAS STATEMENT OF NET ASSETS SEPTEMBER 30, 2009 ASSETS Cash and equivalents Investments Receivables (net of allowances for uncollectibles of$376,197) Accounts Property taxes Due from other governments Prepaid expenses Other assets Inventories Deferred charges Accrued interest Capital assets: Land Buildings and improvements Equipment Infrastructure/water distribution/sewer collection Construction in progress Less: accumulated depreciation Total capital assets Total assets Governmental Activities $ 20,481,779 8,777,006 75,725 241,278 842,872 172,293 283,083 95,375 9,293,654 40,536,708 7,364,496 75,202,099 2,140,424 ( 31,352,601) 103,184,780 134,154,191 804,724 334,350 128,388 211,597 62,359 2,183,799 22,645,717 26,370,934 79,243,497 1,040,896 27,498,864 $ 107,783,257 LIABILITIES Accounts payable Accrued liabilities Accrued interest payable Advances from developers Customer deposits Noncurrent liabilities: Due within one year Due in more than one year T ota1liabilities NET ASSETS Invested in capital assets, net of related debt Restricted for: Debt service Unrestricted Total net assets The accompanying notes are an integral part of these rmancial statements. 26 Business-type Activities $ 6,713,326 1,627,134 1,749,113 139,317 182,433 8,187 313,057 53,922 1,740,485 67,391,621 361,742 ( 23,616,265) 46,244,562 56,664,072 615,169 51,502 69,064 73,396 407,804 872,532 6,285,126 8,374,593 39,174,562 987,181 8,127,736 $ 48,289,479 Component Total Units $ 27,195,105 $ 7,674,188 10,404,140 373,253 1,824,838 241,278 842,872 172,293 139,317 182,433 283,083 103,562 5,807 9,606,711 1,800,940 40,590,630 9,104,981 142,593,720 2,502,166 3,366,559 ( 54,968,866) ( 36,019) 149,429,342 5,131,480 190,818,263 13,184,728 1,419,893 385,852 197,452 37,362 284,993 470,163 3,056,331 450,000 28,930,843 5,850,000 34,745,527 6,337,362 118,418,059 2,028,077 35,626,600 6,847,366 $ 156,072,736 $ 6,847,366 27 FunctionslPrograrns CITY OF COLLEYVILLE, TEXAS STATEMENT OF ACTIVITIES FOR THE YEAR ENDED SEPTEMBER 30, 2009 Program Revenue Expenses Charges for Services Primary government Governmental activities: General government Community development Fire and rescue Leisure services Maintenance Municipal court Police Streets and drainage Interest on long-term debt Total governmental activities Business- type activities: Water and wastewater - Drainage Total business-type activities Total primary government Component unit T ax increment financing Total component unit $ 2,945,481 $ 15,000 $ 1,530,901 666,914 4,113,793 271,216 3,941,259 6,595,487 455,752 291,724 1,002,008 4,841,217 51,631 3,503,519 215,619 1,051,180 22,674,826 8,817,875 10,853,595 11,303,868 748,154 874,637 11,601,749 12,178,505 $ 34,276,575 $ 20,996,380 $ $ 343,419 $ $ $ 343,419 $ $ General revenues: Taxes: Property taxes, levied for general pUlposes Property taxes, levied for debt service TIF taxes Sales taxes Franchise taxes Other taxes Investment earnings Miscellaneous Gain on sale of capital assets Transfers Total general revenues and transfers Change in net assets Net assets - beginning Net assets - ending Operating Grants and Contributions 1,710 $ 8,847 542,714 97,671 62,247 713,189 713,189 The accompanying notes are an integral part of these rmancial statements. 28 Capital Grants and Contributions 3,604 356,419 360,023 63,293 63,293 $ 423,316 $ $ Net (Expense) Revenue and Changes in Net Assets Primary Government Governmental Activities Business--type Activities Total 29 Component Units CITY OF COLLEYVILLE, TEXAS BALANCE SHEET GOVERNMENTAL FUNDS SEPTEMBER 30, 2009 General Debt Service Capital Projects ASSETS Cash and cash equivalents $ 3,892,541 $ 1,113,869 $ 4,707,680 Investments 4,450,670 2,206,116 Receivables (net of allowances for uncollectibles) Accounts 75,725 Taxes 193,561 47,717 Due from other governments 454,860 7,698 Accrued interest 59,667 17,158 Prepaid expenses 172,293 Total assets $ 9,299,317 $ 1,169,284 $ 6,930,954 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable 442,330 50,709 Accrued liabilities 327,595 Deferred. revenue 259,613 47,717 Advances from developers 154,874 Customer deposits 62,359 T otalliabilities 1,091,897 47,717 205,583 Fund balances: Reserved for: Debt service 1,121,567 Unreserved 8,207,420 Unreserved, reported in: Special revenue funds Capital projects funds 6,725,371 Total fund balances 8,207,420 1,121,567 6,725,371 Total liabilities and fund balances $ 9,299,317 $ 1,169,284 $ 6,930,954 Amounts reported. for governmental activities in the statement of net assets are different because: Capital assets used in governmental activities are not financial resources and, therefore, are not reported in the funds. Other long-term assets are not available to pay for current-period expenditures and, therefore are deferred in the funds. Long-term liabilities are not due and payable in the current period and, therefore, are not reported in the funds. Net assets of governmental activities The accompanying notes are an integral part of these fmancial statements. 30 Total Coli eyvill e Other Governmental Tomorrow Fund Governmental Funds $ 3,464,670 $ 7,303,019 $ 20,481,779 2,120,220 8,777,006 75,725 241,278 380,314 842,872 18,550 95,375 172,293 $ 3,464,670 $ 9,822,103 $ 30,686,328 311,685 804,724 6,755 334,350 307,330 56,723 211,597 62,359 375,163 1,720,360 1,121,567 8,207,420 3,464,670 3,464,670 5,519,058 3,927,882 9,446,940 5,519,058 14,117,923 28,965,968 $ 3,464,670 $ 9,822,103 103,184,780 307,330 24,674,821) $ 107,783,257 31 CITY OF COLLEYVILLE, TEXAS STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES GOVERNMENTAL FUNDS FOR THE YEAR ENDED SEPTEMBER 30, 2009 General Debt Service Capital Proj ects REVENUES Taxes $ 14,366,995 $ 2,286,104 $ Fees and fines 972,860 Licenses and pennits 646,302 Intergovernmental 332,972 Charges for services 773,566 Capital improvement fees 208,622 Donations Investment earnings 266,691 10,567 44,396 Miscellaneous 74,100 62,247 Total revenues 17,100,514 2,296,671 648,237 EXPENDITURES Current: General government 2,603,616 16,248 Cormnunity development and engineering 1,227,491 Fire and rescue 3,826,415 Leisure services 2,772,652 Maintenance 449,806 Municipal court 261,678 Police 4,159,649 Streets and drainage 1,907,972 9,564 Debt service: Principal 2,000,553 Interest and other charges 664,953 Capital outlay 258,391 451,786 Total expenditures 17,467,670 2,665,506 477,598 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 367,156) 368,835) 170,639 OTHER FINANCING SOURCES (USES) Sale of capital assets 30,639 Transfers in 816,297 502,721 963,346 Transfers out 989,758) Total other financing sources and uses 142,822) 502,721 963,346 NET CHANGE IN FUND BALANCES 509,978) 133,886 1,133,985 FUND BALANCES, BEGINNING 8,717,398 987,681 5,591,386 FUND BALANCES, ENDING $ 8,207,420 $ 1,121,567 $ 6,725,371 The accompanying notes are an integral part of these imancial statements. 32 Total Colleyville Other Governmental Tomorrow Fund Governmental Funds $ $ 2,236,381 $ 18,889,480 55,565 1,028,425 646,302 17,496 350,468 3,451,479 2,904,277 7,129,322 208,622 401,432 401,432 13,191 136,679 471,524 18,753 155,100 3,464,670 5,770,583 29,280,675 19,354 2,639,218 304,294 1,531,785 13,703 3,840,118 285,680 3,058,332 449,806 30,215 291,893 428,927 4,588,576 1,917,536 275,000 2,275,553 368,195 1,033,148 2,049,597 2,759,774 3,774,965 24,385,739 3,464,670 1,995,618 4,894,936 3,120 33,759 56,412 2,338,776 525,221) ( 1,514,979) 465,689) 857,556 3,464,670 1,529,929 5,752,492 7,917,011 23,213,476 $ 3,464,670 $ 9,446,940 $ 28,965,968 33 CITY OF COLLEYVILLE, TEXAS RECONCILIATION OF THE STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES OF GOVERNMENTAL FUNDS TO THE STATEMENT OF ACTIVITIES FOR THE YEAR ENDED SEPTEMBER 30, 2009 Amounts reported for governmental activities in the Statement of Activities (pages 30 - 31) are different because: Net change in fund balances - total governmental funds: Governmental funds report capital outlays as expenditures. However, in the statement of activities, the cost of those assets is allocated over their estimated useful lives and reported as depreciation expense. The net effect of transactions involving capital assets is to increase net assets. Revenues, in the statement of activities, that do not provide current financial resources, are not reported as revenues in the funds. The issuance of long-term debt (e.g., bonds, leases) provides current financial resources to governmental funds, while the repayment of the principal of long- term debt consumes the current financial resources of governmental funds. Some expenses reported in the statement of activities do not require the use of current financial resources and therefore are not reported as expenditures in governmental funds. Change in net assets of governmental activities The accompanying notes are an integral part of these rmancial statements. 34 $ 5,752,492 ( 557,184) 23,447 68,377 2,246,725 12,850 $ 7,546,707 CITY OF COLLEYVILLE, TEXAS GENERAL FUND STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED SEPTEMBER 30, 2009 Variance with Final Budget - Budgeted Amounts Actual Positive Original Final Amounts (Negative ) REVENUES Taxes $ 14,226,796 $ 14,226, 796 $ 14,366,995 $ 140,199 License and permits 1,369,654 1,369,654 646,302 ( 723,352) Fines and forfeitures 861,850 861,850 972,860 111,010 Charges for services 1,846,474 1,846,474 773,566 ( 1,072,908) Investment earnings 255,000 255,000 266,691 11,691 Other 58,020 58,020 74,100 16,080 Total revenues 18,617,794 18,617,794 17,100,514 ( 1,517,280) EXPENDITURES Current: General government 3,065,959 3,065,959 2,603,616 462,343 Community development and engineering 1,556,527 1,556,527 1,227,491 329,036 Fire and rescue 3,817,173 3,817,173 3,826,415 ( 9,242) Leisure services 2,991,209 3,051,304 2,772,652 278,652 Maintenance 458,654 458,654 449,806 8,848 Municipal court 263,370 263,370 261,678 1,692 Police 4,285,946 4,285,946 4,159,649 126,297 Streets and drainage 2,703,322 2,703,322 1,907,972 795,350 Capital outlay 50,000 50,000 258,391 ( 208,391) Total expenditures 19,192,160 19,252,255 17,467,670 1,784,585 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES ( 574,366) ( 634,461) ( 367,156) 267,305 OTHER FINANCING SOURCES (USES) Transfers in 756,787 756,787 816,297 59,510 Transfers out ( 162,500) ( 162,500) 989,758) 827,258) Sale of capital assets 17,000 17,000 30,639 13,639 Total other financing sources and uses 611,287 611,287 ( 142,822) ( 754,109) NET CHANGE IN FUND BALANCE 36,921 ( 23,174) ( 509,978) ( 486,804) FUND BALANCE, BEGINNING 8,717,398 8,717,398 8,717,398 FUND BALANCE, ENDING $ 8,754,319 $ 8,694,224 $ 8,207,420 $( 486,804) The notes to the fmancial statements are an integral part of this statement. 35 CITY OF COLLEYVILLE, TEXAS STATEMENT OF NET ASSETS PROPRIETARY FUNDS SEPTEMBER 30, 2009 Entetprise Funds Water and Wastewater Drainage Utility Total ASSETS Current assets: Cash and cash equivalents $ 6,024,956 $ 688,370 $ 6,713,326 Investments 1,477,053 150,081 1,627,134 Accounts receivable, net of allowances 1,647,314 101,799 1,749,113 Other assets 139,317 139,317 Inventories 182,433 182,433 Total current assets 9,471,073 940,250 10,411,323 Non-current assets: Accrued interest receivable 7,003 1,184 8,187 Capital assets: Land and improvements 313,057 313,057 Buildings 53,922 53,922 Utility system 63,309,190 4,082,431 67,391,621 Equipment and furniture 1,096,361 644,124 1,740,485 Construction in progress 337,490 24,252 361,742 Less accumulated depreciation 22,658,582) 957,683) 23,616,265) Total non-current assets 42,458,441 3,794,308 46,252,749 Total assets 51,929,514 4,734,558 56,664,072 LIABILITIES Current liabilities: Accounts payable 610,661 4,508 615,169 Accrued liabilities 43,884 7,618 51,502 Accrued interest payable 58,197 10,867 69,064 Advances from developers 73,396 73,396 Customer deposits 407,804 407,804 Compensated absences 16,027 1,504 17,532 Revenue bonds payable 680,000 175,000 855,000 Total current liabilities 1,889,969 199,497 2,089,467 Non-current liabilities: Compensated absences 64,109 6,018 70,126 Revenue bonds payable 4,520,000 1,695,000 6,215,000 Total non-current liabilities 4,584,109 1,701,018 6,285,126 Total liabilities 6,474,078 1,900,515 8,374,593 NET ASSETS Invested in capital assets, net of related debt 37,251,438 1,923,124 39,174,562 Restricted for debt service 987,181 987,181 Unrestricted 7,216,817 910,919 8,127,736 Total net assets $ 45,455,436 $ 2,834,043 $ 48,289,479 The accompanying notes are an integral part of these fmancial statements. 36 CITY OF COLLEYVILLE, TEXAS STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND NET ASSETS PROPRIETARY FUNDS 'FOR THE YEAR ENDED SEPTEMBER 30, 2009 Enterprise Funds Water and Drainage Wastewater Utility Total OPERATING REVENUES Metered water sales $ 7,949,903 $ $ 7,949,903 Wastewater service charges 2,770,366 2,770,366 Drainage service charges 861,671 861,671 Other charges and services 550,895 12,966 563,861 Miscellaneous 32,704 32,704 Total operating revenues 11,303,868 874,637 12,178,505 OPERATING EXPENSES Personnel services 2,113,507 356,659 2,470,166 Maintenance and contractual services 6,697,536 101,116 6,798,652 Materials and supplies 132,760 42,902 175,662 Depreciation and amortization 1,668,569 157,339 1,825,908 Total operating expenses 10,612,372 658,016 11,270,388 OPERATING INCOME (LOSS) 691,496 216,621 908,117 NON-OPERATING REVENUES (EXPENSES) Interest and investment revenues 154,414 14,526 168,940 Interest expense and fiscal charges ( 241,223) ( 90,138) ( 331,361) Total non-operating revenues (expenses) ( 86,809) ( 75,612) ( 162,421) INCOME BEFORE CONTRIBUTIONS AND TRANSFERS 604,687 141,009 745,696 Capital contributions 63,293 63,293 Transfers out ( 816,297) ( 7,500) ( 823,797) CHANGE IN NET ASSETS ( 148,317) 133,509 ( 14,808) TOTAL NET ASSETS, BEGINNING 45,603,753 2,700,534 48,304,287 TOTAL NET ASSETS, ENDING $ 45,455,436 $ 2,834,043 $ 48,289,479 The accompanying notes are an integral part of these fmancial statements. 37 CITY OF COLLEYVILLE, TEXAS STATEMENT OF CASH FLOWS PROPRIETARY FUNDS FOR THE YEAR ENDED SEPTEMBER 30, 2009 Enterprise Funds Water and Drainage Wastewater Utility Totals CASH FLOWS FROM OPERATING ACTIVITIES Cash received from customers $ 11,338,231 $ 872,442 $ 12,210,673 Cash paid to suppliers for goods and services ( 2,104,782) ( 355,678) ( 2,460,460) Cash paid to employees for services ( 7,481,237) ( 140,324) ( 7,621,561) Net cash provided by operating activities 1,752,212 376,440 2,128,652 CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES Transfers out 816,297) 7,500) 823,797) Net cash used for noncapital financing activities 816,297) 7,500) 823,797) CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES Acquisition of capital assets 622,556) 62,473) 685,029) Principal paid on debt 640,000) 170,000) 810,000) Interest paid on debt 241,223) 90,138) 331,361) Net cash used for capital and related financing activities 1,503,779) 322,611) 1,826,390) CASH FLOWS FROM INVESTING ACTIVITIES Purchase (sale) of investments 2,716,980 75,479 2,792,459 Earnings on investments 154,414 14,526 168,940 Net cash provided by investing activities 2,871,394 90,005 2,961,399 NET INCREASE IN CASH AND CASH EQUIVALENTS 2,303,530 136,334 2,439,864 CASH AND CASH EQUIVALENTS, BEGINNING 3,721,426 552,036 4,273,462 CASH AND CASH EQUIVALENTS, ENDING $ 6,024,956 $ 688,370 $ 6,713,326 ( continued) 38 CITY OF COLLEYVaLE, TEXAS STATEMENT OF CASH FLOWS PROPRIETARY FUNDS (Continued) YEAR ENDED SEPTEMBER 30, 2009 Enterprise Funds Water and Drainage Wastewater Utility Totals Reconciliation of operating income (loss) to net cash provided (used) by operating activities: Operating income $ 691,496 $ 216,621 $ 908,117 Adjustments to reconcile operating income (loss) to net cash provided by (used for) operating activities: Depreciation and amortization expense 1,689,395 157,339 1,846,734 Changes in assets and liabilities: Decrease (increase) in assets: Accounts receivable 39,731 2,195) 37,536 Inventory 12,645) 12,645) Accrued interest receivable 16,772 363 17,135 Increase (decrease) in liabilities: Accounts payable 669,547) 4,202 665,345) Accrued liabilities 6,409 1,211 7,620 Compensated absences payable 2,316 ( 230) 2,086 Customer deposits 1,700) 1,700) Advances from developers 2,500 ) 2,500) Escow funds 1,168) 1,168) Accrued interest payable 6,347) 871) 7,218) Net cash provided by operations $ 1,752,212 $ 376,440 $ 2,128,652 Noncash investing, capital, and financing activities: Contributions of capital assets $ 63,293 $ $ 63,293 The notes to the fmancial statements are an integral part of this statement. 39 CITY OF COLLEYVILLE, TEXAS STATEMENT OF FIDUCIARY NET ASSETS FIDUCIARY FUNDS SEPTEMBER 30, 2009 Agency Food ASSETS Cash and investments $ 24,185 Total assets $ 24, 185 LIABILITIES Due to other agencies and individuals $ 24,185 T otalliabilities $ 24,185 The accompanying notes are an integral part of these fmancial statements. 40 CITY OF COLLEYVILLE, TEXAS NOTES TO FINANCIAL STATEMENTS SEPTEMBER 30, 2009 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES The City of Colleyville Home Rule Charter was adopted by the voters at an election held on January 15, 1977. The City operates under a Council-Manager form of government. The accounting policies of the City of Colleyville, Texas (the "City") conform to generally accepted accounting principles as applicable to governmental units. The following is a summary of the more significant of such policies: A. ReDortin!! Entitv As required by generally accepted accounting principles, these financial statements present the government and its component units, entities for which the government is considered to be financially accountable. Blended component units, although legally separate entities are, in substance, part of the government's operations and so data from these units are combined with data of the primary government. Each directly presented component unit, on the other hand, is reported in a separate column in the combined financial statements to emphasize it is legally separate from the government. Each blended component unit has a September 30 year-end. Blended Component Unit - The Colleyville Economic Development Corporation (CEDC) was incorporated on September 3, 1996, as a nonprofit industrial development corporation under the Development Corporation Act of 1979 ("Act"). The CEDe operates under a seven (7) member Board of Directors appointed by the City Council. Each of the directors shall be a resident of the City. The Corporation is organized exclusively for the purposes of benefiting and accomplishing public purposes of and to act on behalf of, the City, and the specific purposes for which the Corporation is organized. This includes municipal park improvements, the purchase of land and improvements for additional neighborhood parks, the construction of a community center and library. Although it is legally separate from the City, the CEDC is reported as if it were part of the primary government, because CEDC is financing public improvements and the City is the primary beneficiary of the services provided. ( continued) 41 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) A. ReDortinf! Entitv (Continued) Blended Component Unit - Colleyville Crime Control and Prevention District (the District) was formed under Chapter 363 of the Texas Local Government Code, the Crime Control and Prevention District Act. The District is organized to act on behalf of the City for financing, development of crime control throughout the City. The District is governed by a seven- member board consisting of all members of the City Council. The District is reported as a part of the primary government because it provides services entirely for the City. Discretely Presented Component Unit - Colleyville Tax Increment Financing Reinvestment Zone Number One (the TIF) was formed to make public improvements, under the authority of the Tax Increment Financing Act. The TIF is governed by a 9-member board consisting of five members appointed by the City Council and one member each appointed by the four other participating taxing entities. The primary government appoints a voting majority of the unit's governing body and the City has a potential economic benefit from this unit. Therefore, the TIF is presented in the accompanying financial statements as a discretely presented component unit. Separate financial statements of the individual component units are not available. B. Government-wide Fund Financial Statements The gove~ent-wide financial statements (i.e., the statement of net assets and the statement of activities) report information on all of the nonfiduciary activities of the primary government and its component units. For the most part, the effect of interfund activity has been removed from these statements. Governmental activities, which normally are supported by taxes and intergovernmental revenue, are reported separately from business-type activities, which rely to a significant extent on fees and charges for support. Likewise, the primary government is reported separately from certain legally separate component units for which the primary government is financially accountable. The statement of activities demonstrates the degree to which the direct expenses of a given function or segment are offset by program revenue. Direct expenses are those that are clearly identifiable with a specific function or segment. Program revenue includes 1) charges to customers or applicants who purchase, use, or directly benefit from goods, services, or privileges provided by a given function or segment, and 2) grants and contributions that are restricted to meeting the operational or capital requirements of a particular function or segment. Taxes and other items not properly included among program revenue are reported instead as general revenue. Separate financial statements are provided for governmental funds, proprietary funds, and fiduciary funds, even though the latter are excluded from the government-wide financial statements. Major individual governmental funds and major individual Enterprise Funds are reported as separate columns in the fund financial statements. ( continued) 42 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) C. Measurement Focus" Basis of Accountine: and Financial Statement Presentation The government-wide financial statements are reported using the economic resources measurement focus and the accrual basis of accounting, as are the proprietary fund and fiduciary fund financial statements, except for Agency Funds, which have no measurement focus. Revenues are recorded when earned and expenses are recorded when a liability is incurred, regardless of the timing of related cash flows. Property taxes are recognized as revenue in the year for which they are levied. Grants and similar items are recognized as revenue as soon as all eligibility requirements imposed by the provider have been met. Governmental fund financial statements are reported using the current financial resources measurement focus and the modified accrual basis of accounting. Revenues are recognized as soon as they are both measurable and available. Revenues are considered to be available when they are collectible within the current period or soon enough thereafter to pay liabilities of the current period. For this purpose, the government considers revenue to be available if collected within 60 days of the end of the current fiscal period. Expenditures generally are recorded when a liability is incurred, as under accrual accounting. However, debt service expenditures, as well as expenditures related to compensated absences and claims and judgments, are recorded only when payment is due. Property taxes, franchise taxes, sales taxes, and interest associated with the current fiscal period are all considered to be susceptible to accrual and so have been recognized as revenue of the current fiscal period. All other revenue items are considered to be measurable and available only when cash is received by the City. GOVERNMENTAL FUNDS Governmental Funds are those through which most governmental functions of the City are financed. The acquisition, use, and balances of the City's expendable financial resources and the related liabilities (except those accounted for in the proprietary fund type) are accounted for through governmental funds. The measurement focus is upon determination of changes in financial position, rather than upon net income determination. The following are the City's governmental fund types: The City reports the following major governmental funds: The General Fund - is the general operating fund of the City. It is used to account for all financial resources except those required to be accounted for in another fund. The Debt Service Fund - is used to account for the acquisition of resources for, and the payment of, general long-term debt principal and interest, and related costs. ( continued) 43 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) c. Measurement Focus.. Basis of Accountinf! and Financial Statement Presentation (Continued) GOVERNMENTAL FUNDS (Continued) The CaDital Proiects Fund - is used to account for financial resources to be used for the acquisition or construction of general major capital facilities. Financing is provided primarily by the sale of general obligation bonds and developer contributions. The Caoital Proiects Fund - Collevville Tomorrow Fund - is used to account for proceeds received on gas leases on City-owned property to be used for capital purchases. Additionally, the City also reports the following fund type: The Soecial Revenue Fund - accounts for the revenues and expenditures associated with a special project or purpose. PROPRIETARY FUNDS Proprietary Funds are used to account for activities that are similar to those often found in the private sector. The measurement focus is upon determination of net income and capital maintenance. The City reports the following major proprietary funds: The Water and Wastewater Fund - is used to account for operations (a) that are financed and operated in a manner similar to private business enterprises - where the intent of the governing body is that the costs (expenses, including depreciation) of providing goods or services to the general public on a continuing basis be financed or recovered primarily through user charges; or (b) where the governing body has decided that periodic determination of revenue earned, expenses incurred, and/or net income is appropriate for capital maintenance, public policy, management control, accountability, or other purposes. This fund is used to account for water and wastewater operations. The Drainaee Utilitv Fund - is used to account for the establishment and maintenance of drainage facilities within the municipal boundaries of the City. All activities necessary to provide such facilities are accounted for in this fund, included but not limited to, administration, operations, maintenance, billing and collections. ( continued) 44 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES. (Continued) c. Measurement Focus.. Basis of Accountin!!: and Financial Statement Presentation (Continued) FIDUCIARY FUNDS Aeencv Fund - Fiduciary Funds are used to account for assets held by the City in a trustee capacity or as an agent on behalf of others. Agency funds are custodial in nature and do not present results of operations or have a measurement focus. The City has two agency funds: Employee Activity and the Sesquicentennial Fund. Private-sector standards of accounting and financial reporting issued prior to December 1, 1989, generally are followed in both the government-wide and proprietary fund financial statements to the extent that those standards do not conflict with or contradict guidance of the Governmental Accounting Standards Board. Governments also have the option of following subsequent private-sector guidance for their business-type activities and Enterprise Funds, subject to this same limitation. The City has elected not to follow subsequent private-sector guidance. As a general rule, the effect of interfund activity has been eliminated from the govemment- wide financial statements. Exceptions to this general rule are charges between the City's water and wastewater function and various other functions of the government. Elimination of these charges would distort the direct costs and program revenue reported for the various functions concerned. Amounts reported as program revenues include: 1) charges to customers or applicants for goods, services, or privileges provided, 2) operating grants and contributions, and 3) capital grants and contributions, including special assessments. Internally dedicated resources are reported as general revenues rather than as program revenue. Likewise, general revenue includes all taxes. Proprietary funds distinguish operating revenues and expenses from nonoperating items. Operating revenues and expenses generally result from providing services and producing and delivering goods in connection with a proprietary fund's principal ongoing operations. The principal operating revenues of the City's Enterprise Funds are charges to customers for sales and services. Operating expenses for Enterprise Funds include the cost of sales and services, administrative expenses, and depreciation on capital assets. All revenue and expenses not meeting this definition are reported as nonoperating revenue and expenses. D. Cash and Cash EQuivalents For purposes of the statement of cash flows, the Enterprise Fund considers all highly liquid investments (investments with original maturities less than 90 days, including restricted assets) to be cash equivalents. ( continued) 45 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) E. Investments In accordance with GASB Statement No. 31, the City's general policy is to report money market investments and short-term participating interest-earning investment contracts at amortized cost and to report nonparticipating interest-earning investment contracts using a cost-based measure. However, if the fair value of an investment is significantly affected by the impairment of the credit standing of the issuer or by other factors, it is reported at fair value. All other investments are reported at fair value unless a legal contract exists which guarantees a higher value. The term "short-term" refers to investments, which have a remaining term of one year or less at time of purchase. The term "nonparticipating" means that the investment's value does not vary with market interest rate changes. F. Receivables and Pavables Activity between funds that are representative of lending/borrowing arrangements outstanding at the end of the fiscal year are referred to as either "due to/from other funds" (i.e., the current portion of interfund loans) or "advances to/from other funds" (i.e., the noncurrent portion of interfund loans). All other outstanding balances between funds are reported as "due to/from other funds." Any residual balances outstanding between the governmental activities and business-type activities are reported in the government-wide financial statements as "internal balances." Advances between funds, as reported in the fund financial statements, are offset by a fund balance reserve account in applicable governmental funds to indicate that they are not available for appropriation and are not expendable available financial resources. All trade and property tax receivables are shown net of an allowance for uncollectibles. Trade accounts receivable in excess of 30 days comprise the trade accounts receivable allowance for uncollectibles. The property tax receivable allowance is equal to one percent of outstanding property taxes at September 30, 2009. Property taxes are levied on October 1 and attach as an enforceable lien on property as of January 1. Statements are mailed on October 1, or as soon thereafter as possible, and are due upon receipt. All unpaid taxes become delinquent if not paid before February 1 of the following year. G. Inventories Inventories in the Enterprise Fund are valued at cost (first-in, first-out method). ( continued) 46 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) H. Caoital Assets Capital assets, which include property, plant, equipment and infrastructure assets (e.g. roads, bridges, sidewalks and similar items) are reported in the applicable governmental or business-type activities columns in the government-wide financial statements. The City defines capital assets as assets with an initial, individual cost of more than $5,000 (amount not rounded) and an estimated useful life in excess of one year. Such assets are recorded at historical cost or estimated historical cost if purchased or constructed. Donated capital assets are recorded at estimated fair market value at the date of donation. The costs of normal maintenance and repairs that do not add to the value of the asset or materially extend assets' lives are not capitalized. Major outlays for capital assets and improvements are capitalized as projects are constructed. Property, plant and equipment is depreciated using the straight-line method over the following estimated useful lives: Assets Years Buildings Improvements Equipment Infrastructure (streets and drainage) Water distribution/sewer collection 15 - 50 20 - 50 5 - 10 50 5 -40 I. Other Assets - Enterprise Fund Other assets consist of expenses incurred in connection with the issuance of certain outstanding revenue bonds. Such charges are amortized on a straight-line basis over the lives of the bonds. J. Comoensated Absences City employees are granted vacation and sick pay in varying amounts. In the event of termination, an employee is paid for all accumulated, unused vacation. Vacation pay is accrued as it vests to the employee. Sick pay is recorded when paid or upon retirement when a maximum of 90 days is paid. The accrued sick pay is not recorded, as the City's policy is not to compensate employees upon separation of services with the City, except for retirement, and such amounts are not considered material. All vacation pay is accrued when incurred in the government-wide and proprietary fund financial statements. ( continued) 47 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) K. LODt!-term Oblie:ations In the government-wide financial statements and proprietary fund types in the fund financial statements, long-term debt and other long-term obligations are reported as liabilities in the applicable governmental activities, business-type activities, or proprietary fund type statement of net assets. In the fund financial statements, the face amount of debt issued is reported as other financing sources for the governmental fund types. F or governmental fund types, bond premiums and discounts, as well as issuance costs, are recognized during the current period. Bond proceeds are reported as an other financing source. Issuance costs, even if withheld from the actual net proceeds received, are reported as expenditures. For proprietary fund types, bond premiums and discounts, as well as issuance costs, are charged to current operations rather than being deferred and amortized due to the relatively immaterial effect on the basic financial statements taken as a whole. L. Fund EQuitv Restrictions of fund balance represent amounts that are not available for appropriation or are legally segregated for specific purposes. Restrictions of net assets are limited to outside third party restrictions. Designations of fund balance represent tentative management plans that are subject to change. In the Special Revenue Funds, fund balances reserved for other represent amounts which are restricted for expenditure in accordance with the purposes for which the fund was established, such as park and library improvements, tree preservation, hosting recreational events and tournaments, and increasing recycling efforts within the City. Amounts under these reservations are listed on the accompanying basic financial statements as reserved for other. M. Risk Manae:ement Insurance coverage for property, liability and workers' compensation is provided by the Texas Municipal League Intergovernmental Risk Pool, a state insurance pool. Contributions to the Risk Pool for workers' compensation are based on the City's past claims history. The Risk Pool is self-sustaining through members' contributions and maintains insurance to limit risk of loss with an external insurance company. Settlement claims have not exceeded aggregate limits in the past three fiscal years. 48 2. RECONCILIATION OF GOVERNMENT-WIDE AND FUND FINANCIAL STATElVIENTS Explanation of Certain Differences Between the Governmental Fund Balance Sheet and the Government-wide Statement of Net Assets The governmental fund balance sheet includes a reconciliation between fund balance - total governmental funds and net assets - governmental activities as reported in the government-wide statement of net assets. One element of that reconciliation explains, "Long-term liabilities are not due and payable in the current period and therefore are not reported in the funds." The details of this $(24,674,821) difference are as follows: Serial Bonds and Certificates of Obligation Accrued interest payable Compensated absences Principal retirement $( 26,803,734) ( 128,388) 10,576 2,246,725 Net adjustment to reduce fund balance - total governmental funds to arrive at net assets - governmental activities $( 24,674,821) Explanation of Certain Differences Between the Governmental Fund Statement of Revenue" Expenditures and Chanf!es in Fund Balances and the Government-wide Statement of Activities The governmental fund statement of revenue, expenditures and changes in fund balances includes a reconciliation between net changes in fund balances - total governmental fund and changes in net assets of governmental activities as reported in the government-wide statement of activities. One element of that reconciliation explains, "Governmental funds report capital outlays as expenditures. However, in the statement of activities the cost of those assets is allocated over their estimated useful lives and reported as depreciation expense." The details of this $(557,184) difference are as follows: Capital outlay Depreciation expense $ ( 2,759,774 3,316,958) Net adjustment to increase net changes in fund balances - total governmental funds to arrive at changes in net assets of governmental activities $( 557,184) ( continued) 49 2. RECONCILIATION OF GOVERNMENT-WIDE AND FUND FINANCIAL STATEMENTS (Continued) Exolanation of Certain Differences Between the Governmental Fund Statement of Revenue.. Expenditures and Chanees in Fund Balances and the Government-wide Statement of Activities (Continued) Another element of that reconciliation states, "Revenues in the statement of activities that do not provide current financial resources are not reported as revenues in the funds." The details of this $68,377 difference are as follows: Property taxes Ambulance revenue Adjudicated fines $ 42,554 23,864 1,959 Net adjustment to increase net changes in fund balances - total governmental funds to arrive at changes in net assets of governmental activities $ 68,377 Another element of that reconciliation states, "The issuance of long-term debt (e.g., bonds, leases) provides current financial resources to governmental funds, while the repayment of the principal of long-term debt consumes the current financial resources of governmental funds." Neither transaction, however, has any effect on net assets. The details of this $2,246,725 difference are as follows: Principal payments and refundings $ 2,246,725 Net adjustment to reduce fund balance -total governmental funds to arrive at net assets - governmental activities $ 2,246,725 Another element of that reconciliation states, "Some expenses reported in the statement of activities do not require the use of current financial resources, and therefore are not reported as expenditures in governmental funds." The details of this $12,850 difference are as follows: Compensated absences Accrued interest Loss on sale of assets $ 10,576 10,796 8,522) ( Net adjustment to decrease net changes infund balances- total governmental funds to arrive at changes in net assets of governmental activities $ 12,850 50 3. STEWARDSHIP, COMPLIANCE AND ACCOUNTABILITY A. Bude:etarv Information The City Council follows these procedures in establishing budgetary data reflected in the basic financial statements: (1) Prior to September 1, the City Manager submits to the City Council a proposed operating budget for the fiscal year commencing the following October 1. The operating budget includes proposed expenditures and the means of financing them. (2) Public hearings are conducted to obtain taxpayer comments. (3) Prior to September 30, the budget is legally enacted through passage of an ordinance. ( 4) The City Manager is authorized to transfer budgeted amounts between departments within any fund; however, any revisions that alter the total expenditures of any fund must be approved by the City Council. (5) Formal budgetary integration is employed as a management control device during the year for the General, Debt Service, and Enterprise Funds. Budgetary control is maintained at the fund level. Internal budgets are prepared and reviewed by the City Council for expenditures of Special Revenue Funds. These budgeted expenditures are not formally adopted by the City Council. No budgets were prepared for revenue of these funds for the year ended September 30, 2009. (6) Budgets for the General and the Debt Service Funds are adopted on a basis consistent with generally accepted accounting principles (GAAP). Formal budgeted amounts are as amended by the City Council for the General, Debt Service and Enterprise Funds. (7) Budgetary data for the Capital Projects Fund has not been presented in the accompanying basic financial statements, as such funds are budgeted over the life of the respective project and not on an annual basis. Accordingly, formal budgetary integration of the Capital Projects Fund is not employed and comparison of actual results of operations to budgetary data for such fund is not presented. (8) Budgetary data for the Enterprise and Drainage Utility Funds has not been presented since the reporting on such budgets is not legally required. Expenditures Over Appropriations General Fund expenditures in the Fire and Rescue function and capital outlay exceeded appropriations by $9,242 and $208,391, respectively. These overages were funded by under spending in other functions. ( continued) 51 3. STEWARDSHIP, COMPLIANCE AND ACCOUNTABILITY (Continued) A. Bud!!:etarv Data (Continued) Encumbrances Encumbrance accounting, under which purchase orders, contracts, and other commitments for the expenditure of funds are recorded in order to reserve that portion of the applicable fund balance, is employed in the governmental funds. Encumbrances are reported as reservations of fund balances because they do not constitute expenditures or liabilities. 4. DETAILED NOTES ON ALL FUNDS DeDosits and Investments As of September 30, 2009, the City had the following investments: Investment Type Fair Value Weighted Average Maturity (Days) LOGIC U. S. Treasuries and Agencies $ 27,716,227 10,766,564 56 432 Total fair value $ 38,482,791 Portfolio weighted average maturity (days) The Public Funds Investment Act (Government Code Chapter 2256) contains specific provisions in the areas of investment practices, management reports and establishment of appropriate policies. Among other things, it requires the City to adopt, implement, and publicize an investment policy. That policy must address the following areas: (1) safety of principal and liquidity, (2) portfolio diversification, (3) allowable investments, (4) acceptable risk levels, (5) expected rates of return, (6) maximum allowable stated maturity of portfolio investments, (7) maximum average dollar-weighted maturity allowed based on the stated maturity date for the portfolio, (8) investment staff quality and capabilities, and (9) bid solicitation preferences for certificates of deposit. Statutes authorize the City to invest in (1) obligations of the U. S. Treasury, certain U. S. agencies, and the State of Texas; (2) certificates of deposit, (3) certain municipal securities, (4) money market savings accounts, (5) repurchase agreements, (6) bankers acceptances, (7) Mutual Funds, (8) investment pools, (9) guaranteed investment contracts, and (10) common trust funds. The Act also requires the City to have independent auditors perform test procedures related to investment practices as provided by the Act. The City is in substantial compliance with the requirements of the Act and with local policies. ( continued) 52 4. DETAILED NOTES ON ALL FUNDS (Continued) DeDosits and Investments (Continued) The City's investment pools are 2a7-like pools. A 2a7-like pool is one which is not registered with the Securities and Exchange Commission ("SEC") as an investment company, but nevertheless has a policy that it will, and does, operate in a manner consistent with the SEC's Rule 2a7 of the Investment Company Act of 1940. Interest Rate Risk. In accordance with its investment policy, the government manages its exposure to declines in fair market values by limiting the average dollar weighted maturity of its investment portfolios to a maximum of 180 days. Custodial Credit Risk. In the case of deposits, this is the risk that in the event of a bank failure, the City's deposits may not be returned to it. As of September 30, 2009, $538,345 of the City's $788,345 deposit balance was collateralized with securities held by the pledging financial institution. The remaining balance, $250,000, was covered by FDIC insurance. Credit Risk. It is the City's policy to limit its investments to investment types with an investment quality rating not less than A or its equivalent by a nationally recognized statistical rating organization. The City's investment pools are rated as follows by Standard & Poor's Investors Service. LOGIC U. S. Treasuries AAAm AAA Receivables Receivables as of year-end for the government's individual major funds, nonmajor funds and enterprise funds in the aggregate, including the applicable allowances for uncollectible accounts, are as follows: Governmental Funds Enterprise Funds Debt Capital Nonmajor Water and Drainage General Service Projects Funds Wastewater Utility Total Receivables: Accounts $ 423,856 $ $ $ $ 1,675,380 $ 101,799 $ 2,201,035 Taxes 193,561 47,717 241,278 Due from other governments 454,860 7,698 380,314 842,872 Accrued interest 59,677 17,158 18,850 95,685 Gross receivables 1,131,954 55,415 17,158 399,164 1,675,380 101,799 3,380,870 Less: allowance for unco llectibles 348,131) 28,066) 376,197) Net total receivables $ 783,823 $ 55,415 $ 17,158 $ 399,164 $ 1,647,314 $ 101,799 $ 3,004,673 ( continued) 53 4. DETAILED NOTES ON ALL FUNDS (Continued) Receivables (Continued) Governmental funds report deferred revenue in connection with receivables for revenue that is not considered to be available to liquidate liabilities of the current period. Governmental funds also defer revenue recognition in connection with resources that have been received, but not yet earned. At the end of the current fiscal year, the various components of deferred revenue and unearned revenue reported in the governmental funds were as follows: Unavailable Unearned General Fund Delinquent property taxes receivable Other Total General Fund $ 193,561 66,052 259,613 $ Debt Service Fund Delinquent property taxes receivable Total Debt Service Fund 47,717 47,717 Total Governmental Funds $ 307,330 $ The City's property tax is levied each October 1 on the assessed value listed as of the prior January 1 for all real property and certain personal property located in the City. Tax liens attach as of January 1. The assessed value, net of exemptions, upon which the fiscal 2009 levy was based, was $3,510,239,091. Property taxes are limited by the Texas constitution to $2.50 per $100 of assessed valuation and by City Charter to $1.50 per $100 valuation. Also, the tax rate set per budget year shall not result in property tax revenue increase greater than seven percent of the total property tax revenue collected in the preceding budget year, adjusted for new construction, unless authorized by the voters of the City at a special election. The combined tax rate to finance general governmental service and debt service for the year ended September 30, 2009, was $.3559 per $100 of assessed valuation. Taxes are due by January 31 following the levy date. Tax collections, including related penalties and interest, was $12,078,866 for the year ended September 30, 2009. Property taxes receivable at September 30, 2009, were $241,278. The appraisal of property within the City is the responsibility of a countywide appraisal district as required by legislation passed by the Texas Legislature. The appraisal district is required under such legislation to assess all property within the appraisal district on the basis of 100% of its appraised value and is prohibited from applying any assessment ratios. The value of property within the appraisal district must be reviewed every three years; however, the City may, at its own expense, require annual reviews of appraised values. The City may challenge appraised values established by the appraisal district through various appeals and, ifnecessary, legal action. ( continued) 54 4. DETAILED NOTES ON ALL FUNDS (Continued) CaDital Assets Capital asset activity for the year ended September 30, 2009, was as follows: Primary Government Beginning Ending Balance Increases Decreases Balance Governmental activities: Capital assets, not being depreciated: Land $ 9,293,654 $ $ $ 9,293,654 Construction in progress 4,645,335 1,703,955 ( 4,208,866) 2,140,424 Total assets not being depreciated 13,938,989 1,703,955 ( 4,208,866) 11,434,078 Capital assets, being depreciated: Buildings and improvements 40,433,039 103,669 40,536,708 Machinery and equipment 7,028,032 638,866 302,402) 7,364,496 Infrastructure 70,656,502 4,545,597 75,202,099 Total capital assets being depreciated 118,117,573 5,288,132 302,402) 123,103,303 . Less accumulated depreciation: Buildings and improvements 7,649,524) 1,245,698) 8,895,222) Machinery and equipment 5,619,431) 566,143) 293,880 5,89] ,694) Improvements other than buildings 15,060,568) 1,505,117) 16,565,685) Total accumulated depreciation 28,329,523) 3,316,958) 293,880 3 ] ,352,60 1 ) Total capital assets being depreciated, net 89,788,050 1,971,174 8,522) 91,750,702 Governmental activities capital assets, net $ 103,727,039 $ 3,675,129 $( 4,217,388) $ 103,184,780 ( continued) 55 4. DETAILED NOTES ON ALL FUNDS (Continued) Capital Assets (Continued) Beginning Ending Balance Increases Decreases Balance Business...type activities: Capital assets, not being depreciated: Land $ 313,057 $ $ $ 313,057 Construction in progress 7,967,420 528,483 ( 8,134,161) 361,742 Total assets not being depreciated 8,280,477 528,483 ( 8,134,161) 674,799 Capital assets, being depreciated: Buildings and improvements 53,922 53,922 Machinery and equipment 1,778,060 37,575) 1,740,485 Improvements other than buildings 59,062,048 8,333,176 3,603) 67,391,621 Total capital assets being depreciated 60,894,030 8,333,176 41 ,178) 69,186,028 Less accumulated depreciation: Buildings and improvements 45,547) 818) 46,365) Machinery and equipment 2,225,222) 170,569) 37,575 2,358,216) Improvements other than buildings 19,581,590) 1,633,697) 3,603 21,211,684) Total accumulated depreciation 21,852,359) 1,805,084) 41,178 23,616,265) Total capital assets being depreciated, net 39,041,671 6,528,092 45,569,763 Business-type activities capital assets, net $ 47,322,148 $ 7,056,575 $( 8,134,161) $ 46,244,562 Component unit: Capital assets, not being depreciated: Construction in progress $ 4,622,766 $ 544,733 $( 1,800,940) $ 3,366,559 Total assets not being depreciated 4,622,766 544,733 ( 1,800,940) 3,366,559 Capital assets, being depreciated: Improvements other than buildings $ $ 1,800,940 $ $ ] ,800,940 Total capital assets being depreciated 1,800,940 1,800,940 Less accumulated depreciation: Improvements other than buildings $ $( 36,019) $ $( 36,019) Total accumulated depreciation ( 36,019) ( 36,019) Total capital assets being depreciated, net 1,764,921 1,764,921 Component unit capital assets, net $ 4,622,766 $ 2,309,654 $( 1,800,940) $ 5,131,480 ( continued) 56 4. DETAILED NOTES ON ALL FUNDS (Continued) Capital Assets (Continued) Depreciation expense was charged to functions/programs of the primary government as follows: Governmental activities: General government Fire and rescue Leisure services Maintenance Police Streets and drainage Total depreciation expense - governmental activities Business-type activities: Water and wastewater Drainage utility Total depreciation expense - business-type activities Construction Commitments $ 307,787 275,892 884,693 6,206 255,290 1,587,090 3,316,958 $ $ 1,649,539 155,545 1,805,084 $ The government has active construction projects as of September 30, 2009. The major projects are listed as follows: Interfund Transfers Transfer In Nonmajor Debt Capital Government General Service Proj ects Funds Total Transfer Out: General $ $ $ 963,346 $ 26,412 $ 989,758 Nonmajor governmental 502,721 22,500 525,221 Water and wastewater 816,297 816,297 Drainage utility 7,500 7,500 Total Transfers Out $ 816,297 $ 502,721 $ 963,346 $ 56,412 $ 2,338,776 Project Spent-to-date McPherson Park II $ $ 1,325,961 1,325,961 Total Interfund Receivables.. Pavables and Transfers The composition of inter fund balances as of September 30,2009, is as follows: ( continued) 57 Remaining Commitment $ $ 133,498 133,498 4. DETAILED NOTES ON ALL FUNDS (Continued) Interfund Receivables.. Payables and Transfers (Continued) Interfund Transfers (Continued) The transfer of $816,297 from the Utility Fund to the General Fund represents the 2009 Administrative transfer and the franchise fee based on gross water and wastewater revenue of the prior year's audited financial statements. The transfer of $989,758 from the General Fund to the Capital Projects and nonmajor governmental funds represents transfers for capital replacement. The transfer of $502,721 from the Crime District to the Debt Service Fund is for the repayment of debt. All principal and interest is paid from the Debt Service Fund's bank account. Cauital Leases The City has entered into a lease agreement as lessee for financing and acquisition of equipment for the Fire Department. This lease agreement qualifies as a capital lease for accounting purposes and, therefore, has been recorded at the present value of its future minimum lease payments as of the inception date. The assets acquired through capital leases are as follows: Governmental Activities Asset: Machinery and equipment Less: accumulated depreciation $ ( 584,866 198,716) Total $ 386,150 Business-type Activities $ ( 71,077 41,711) $ 29,366 The future minimum lease obligations and the net present value of these minimum lease payments as of September 30,2009, were as follows: Governmental Activities 2010 2011 2012 2013 2014 2015 Total minimum lease payments $ 87,900 87,900 87,900 49,723 49,723 49,723 412,869 Less: amount representing interest ( 52,873 ) Present value of minimum lease payments $ 359,996 ( continued) 58 Business-type Activities $ $ 4. DETAILED NOTES ON ALL FUNDS (Continued) Lon!;!-term Liabilities General Obligation Bonds The government issues general obligation bonds to provide funds for the acquisition and construction of major capital facilities. General obligation bonds have been issued for governmental activities. The original amount of general obligation bonds issued in prior years was $22,015,000. General obligation bonds are direct obligations and pledge the full faith and credit of the government. These bonds generally are issued as 20-year serial bonds with equal amounts of principal maturing each year. General obligation bonds currently outstanding are as follows: Purpose Interest Rates Amount Governmental activities 3.64% - 6.00% $ 23,864,370 $ 23,864,370 Long-term liability activity for the year ended September 30, 2009, was a follows: Balance Balance Amounts October 1, September 30, Due Within 2008 Additions Retirements 2009 One Year Governmental activities General obligation bonds and certificates of obligation $ 16,275,000 $ $ 1,610,000 $ 14,665,000 $ 1,365,000 Sales tax revenue bonds 9,795,916 596,546 9,199,370 626,546 Capital lease obligations 430,549 70,553 359,996 71,223 Compensated absences 615,726 10,576 605,150 121,030 Total governmental activities 27,117,191 2,287,675 24,829,516 2,183,799 B usiness-tvDe activities Revenue bonds and certificates of obligation 7,880,000 810,000 7,070,000 855,000 Compensated absences 85,572 2,086 87,658 17,532 Total business-type activities 7,965,572 2,086 810,000 7,157,658 872,532 Total primary government $ 35,082,763 $ 2,086 $ 3,097,675 $ 31,987,174 $ 3,056,331 ComDonent unit Tax Increment Financing Fund Revenue Bonds $ 6,730,000 $ $ 430,000 $ 6,300,000 $ 450,000 Total component unit $ 6,730,000 $ $ 430,000 $ 6,300,000 $ 450,000 For the governmental activities, compensated absences are generally liquidated by the General Fund. ( continued) 59 4. DETAILED NOTES ON ALL FUNDS (Continued) Lone-term Liabilities (Continued) Governmental activities long-term liabilities at September 30, 2009, consisted of the following: General obligation bonds and certificates of obligation serviced by property tax revenue: $500,000 Series 1999 General Obligation Bonds due in annual installments of $5,000 to $40,000 through February 15, 2019; interest at 4.00% to 6.00%. $ 25,000 $9,045,000 Series 2001 General Obligation Bonds due in annual installments of $55,000 to $1,030,000 through February 15, 2014; interest at 4.00% to 4.60%. 3,925,000 $3,000,000 Series 2002 Tax and Waterworks and Sewer System Surplus Revenue Certificates of Obligation Bonds due in annual installments of $110,000 to $170,000 through February 15, 2020; interest at 4.20% to 4.70%. 1,470,000 $4,895,000 Series 2006 General Obligation Refunding bonds due in annual installments of $25,000 to $540,000 through February 15, 2019; interest at 3.64%. 4,720,000 $4,575,000 Series 2007 General Obligation Bonds due in annual installments of $50,000 to $555,000 through February 15, 2027; interest at 4.00% to 5.00%. 4,525,000 Total General Obligation Bonds and Certificates of Obligation $ 14,665,000 $7,170,000 Series 1999 Texas Tax and Waterworks and Sewer System Certificates of Obligation due in annual installments of $5,000 to $565,000 through February 15, 2019; interest at 3.60% to 5.60%. $9,570,000 Series 2005 Colleyville Economic Development Corporation Refunding and Improvement Sales Tax Revenue Bonds due in annual installments of $20,000 to $635,000 through February 15, 2029; interest at 4.10% $ 335,000 Unamortized gain on refunding 8,835,000 29,370 Total Revenue Bonds $ 9,199,370 The funds utilized for the repayment of long-term liabilities for governmental activities are the Debt Service Fund, the Crime District Fund and the Colleyville Economic Development Corporation. ( continued) 60 4. DETAILED NOTES ON ALL FUNDS (Continued) Lon!!-term Liabilities (Continued) The City's defeased debt as of September 30,2009, was $2,188,006. Business-type activities long-term liabilities at September 30, 2009, consisted of the following: Water and Wastewater Fund: $4,220,000 Series 1996 Waterworks and Wastewater System Revenue and Refunding Bonds due in annual installments of $100,000 to $335,000 through January 1, 2017; interest at 3.75% to 5.60%. $ 1,325,000 $2,825,000 Series 1998 Waterworks and Wastewater System Revenue Bonds due in annaul installments of $85,000 to $220,000 through January 1, 2018; interest at 4.25% to 6.75%. 1,615,000 $2,580,000 Series 2002 WatelWorks and Wastewater System Revenue Bonds due in annual installments of $130,000 to $255,000 through January 1, 2015; interest at 2.00% - 4.00%. 1,345,000 $1,710,000 Series 2004 Waterworks and Wastewater System Refunding Bonds due in annual installments of $150,000 to $195,000 through January 1, 2014; interest at 3.73%. 915,000 Total Water and Wastewater Fund $ 5,200,000 Drainage Utility Fund: $3,025,000 Series 2001 Municipal Drainage Utility System Revenue Bonds due in annual installments of $85,000 to $220,000 through February 15,2021; interest at 4.00% to 5.00%. $ 1,870,000 Total Drainage Utility Fund $ 1,870,000 Total Business-type activities $ 7,070,000 The ordinances authorizing the issuance of WatelWorks and Wastewater System Revenue Bonds created the Interest and Sinking Fund and Reserve Fund. The gross revenue of the waterworks and wastewater system, after deduction of reasonable expenses of operations and maintenance, are pledged to such funds in amounts equal to the total annual principal and interest requirements of the bonds and amounts required to maintain the Reserve Fund. At September 30, 2009, the City was in compliance with these requirements. ( continued) 61 4. DETAILED NOTES ON ALL FUNDS (Continued) Lon!!-term Liabilities (Continued) The City's component unit, the Tax Increment Financing District, long-term liabilities at September 30, 2009, consisted of the following: Governmental Activities General Obligation Bonds and Certificates of Obligation Revenue Bonds September 30, Principal Interest Principal Interest 2010 $ 1,365,000 $ 562,454 $ 625,000 $ 363,493 2011 1,780,000 497,873 300,000 344,195 2012 1,605,000 428,856 315,000 331,587 2013 1,270,000 369,889 330,000 318,365 2014 1,000,000 323,207 340,000 304,630 2015-2019 3,950,000 1,140,052 1,940,000 1,295,805 2020-2024 2,105,000 543,495 2,385,000 853,928 2025-2029 1,590,000 97,400 2,935,000 310,678 $ 14,665,000 $ 3,963,226 $ 9,170,000 $ 4,122,681 Tax Increment Financing District $680,000 Series 2002 Tax and Tax Increment Revenue Certificates of Obligation due in installments of $25,000 to $40,000 beginning in 2004 through February 2012; interest at 4.00% to 5.00%. $7,285,000 Series 2001 Tax Notes due in installments of $350,000 to $660,000 beginning in 2006 through February 15, 2020; interest at 4.30% to 5.00%. Total Tax Increment Financing District Business-type Activities $ 505,000 5,795,000 $ 6,300,000 September 30, Revenue Bonds Principal Interest 2010 2011 2012 2013 2014 2015-2019 2020-2021 $ 855,000 885,000 935,000 970,000 1,005,000 2,165,000 255,000 $ 7,070,000 ( continued) 62 $ 302,202 266,101 227,618 186,686 143,189 267,001 12,875 $ 1,405,672 4. DETAILED NOTES ON ALL FUNDS (Continued) LODe-term Liabilities (Continued) Discretely Presented Component Unit- Tax Increment Financing Fund September 30, Revenue Bonds Principal Interest 2010 2011 2012 2013 2014 2015-2019 2020 $ 450,000 470,000 490,000 515,000 540,000 3,115,000 720,000 $ 289,209 269,179 247,718 224,980 200,942 580,403 17,970 $ 6,300,000 $ 1,830,401 Emnloyees' Retirement System Plan Description The City provides pension benefits for all of its eligible employees through a non-traditional, joint contributory, hybrid defined benefit plan in the statewide Texas Municipal Retirement System (TMRS), an -agent multiple-employer public employee retirement system. The plan provisions that have been adopted by the City are within the options available in the governing state statutes of TMRS. TMRS issues a publicly available comprehensive annual financial report that includes financial statements and required supplementary information (RSI) for TMRS; the report also provides detailed explanations of the contributions, benefits and actuarial methods and assumptions used by the System. This report may be obtained by writing to TMRS, P. O. Box 149153, Austin, Texas 78714-9153 or by calling 800-924-8677; in addition, the report is available on TMRS' web site at www.TMRS.com. The plan provisions are adopted by the governing body of the City, within the options available in the state statutes governing TMRS. Plan provisions for the City were as follows: Plan Year 2008 Plan Year 2009 Employee deposit rate Matching ratio (city to employee) Years required for vesting Service retirement eligibility (expressed as age/years of service) Updated service credit 7.0% 2 to 1 5 7.0% 2 to 1 5 Annuity increase (to retirees) 60/5, 0/20 100% repeating, transfers 70% of CPI repeating 60/5, 0/20 100% repeating, transfers 70% of CPI repeating ( continued) 63 4. DETAILED NOTES ON ALL FUNDS (Continued) Emplovees' Retirement System (Continued) Contributions Under the state law governing TMRS, the contribution rate for each City is determined annually by the actuary, using the Projected Unit Credit actuarial cost method. This rate consists of the normal cost contribution rate and the prior service cost contribution rate, which is calculated to be a level percent of payroll from year to year. The normal cost contribution rate finances the portion of an active member's projected benefit allocated annually; the prior service contribution rate amortizes the unfunded (overfunded) actuarial liability (asset) over the applicable period for that city. Both the normal cost and prior service contribution rates include recognition of the projected impact of annually repeating benefits, such as Updated Service Credits and Annuity Increases. The City contributes to the TMRS Plan at an actuarially determined rate. Both the employees and the City make contributions monthly. Since the City needs to know its contribution rate in advance for budgetary purposes, there is a one-year delay between the actuarial valuation that serves as the basis for the rate and the calendar year when the rate goes into effect. The annual pension cost and net pension obligation/(asset) are as follows: Accounting Annual Percentage Net Year Pension of APC Pension Ending Cost (APC) Contributed Obligation 09/30/07 $ 1,053,134 100% 09/30/08 1,156,845 100% 09/30/09 1,360,993 100% The required contribution rates for fiscal year 2009 were determined as part of the December 31, 2006 and 2007 actuarial valuations. Additional information as of the latest actuarial valuation, December 31, 2008, also follows: Actuarial Valuation Date 12/31/06 12/31/07 12/31/08 Unit Credit Projected Unit Credit Projected Unit Credit Level percent Level percent Level percent of payroll of payroll of payroll 25 years - open 30 years - closed 29 years - closed Amortized cost Amortized cost Amortized cost Actuarial cost method Amortization method Remaining amortization period Asset valuation method Actuarial Assumptions: Investment rate of return Projected salary increases Inflation Cost-of-living adjustments 70/0 varies by age and service 3.0% N/A 7% varies by age and service 3.0% 2.1% 7.5% varies by age and service 3.0% 2.1% ( continued) 64 4. DETAILED NOTES ON ALL FUNDS (Continued) Emplovees' Retirement System (Continued) Schedule of Funding Information The funded status as of December 31, 2008, the most recent actuarial valuation date, IS as follows: Actual Valuation Date Actuarial value of assets Actuarial accrued liability Percent funded Unfunded (overfunded) actuarial accrued liability (VAAL) Annual covered payroll UAAL as a percentage of covered payroll 12/31/08 12/31/07 12/3 1/06 $ 23,644,963 $ 21,257,894 $ 20,045,209 31,826,557 28,297,826 22,297,535 74.3% 75.1 % 89.90/0 8,181,594 7,039,932 2,252,326 10,348,960 9,383,755 8,175,810 79.1 % 75.00/0 27.50/0 Water and Wastewater Contracts The City has two contracts with the Trinity River Authority of Texas (TRA) for the purchase of treated water and for the transportation, treatment and disposal of sanitary sewage and other waste. The initial terms of the contracts are 35 and 50 years, and they expire in 2014 and 2023. While the provisions of each of the contracts vary, each contract basically requires the City to pay varying amounts based on the costs associated with water purchased and sewage transported and/or treated and disposed. The cost includes the City's proportionate share of TRA ' s operating and maintenance expenses, related debt service costs, and certain other miscellaneous charges. Purchases of treated water and charges for the transportation, treatment and disposal of sewage and other wastes during 2009 amounted to approximately $4,573,688 and $1,660,246, respectively. Advances from Developers Developers are required by ordinance to construct perimeter streets and related storm drainage facilities. The developer may request a waiver from the Council for the construction requirements and instead deposit escrow funds with the City equal to one-half of the estimated cost of construction, which are utilized by the City to complete the project at some later date. At September 30, 2009, developers had escrowed $284,993 with the City in connection with developer agreements. Contin2ent Liabilities The City has been named as a defendant or co-defendant in a number of legal actions. While the outcome of these cases is not known at this time, City management believes that any awards to insured parties which must be paid in excess of amounts covered by insurance will not be material to the financial position of the City. ( continued) 65 4. DETAILED NOTES ON ALL FUNDS (Continued) Risk Financinf! and Insurance The City is exposed to various risks of loss related to torts, theft of, damage to, and destruction of assets; errors and omissions; injuries to employees; and natural disasters. During the fiscal year 1974, the City joined the Texas Municipal League Workers Compensation Joint Insurance Fund for risks related to employees. During the fiscal year 1992, the City joined the Texas Municipal League Joint Insurance Fund for risks related to general liability, property and errors and omissions. Premiums are paid to the Pool, which retains a limit of loss. Reinsurance companies insure the risks beyond those limits. The City retains, as a risk, only the deductible amount of each policy. There have been no significant reductions in insurance coverage and no settlements exceeded insurance coverage in the past three fiscal years. Other PostemDlovment Benefits Supplemental Death Benefits Fund The City also participates in the cost sharing multiple-employer defined benefit group term life insurance plan operated by the Texas Municipal Retirement System (TMRS) known as the Supplemental Death Benefits Fund (SDBF). The City elected, by ordinance to provide group term life insurance coverage to both current and retired employees. The City may terminate coverage under and discontinue participation in the SDBF by adopting an ordinance before November 1 of any year to be effective the Iollowing January 1. The death benefit for active employees provides a lump sum payment approximately equal to the employee's annual salary (calculated based on the employee's actual earnings, for the 12-month period preceding the month of death); retired employees are insured for $7,500; this coverage is an "other postemployment benefit," or OPEB. Schedule of Contribution Rates Accounting Year Ending Annual Required Contribution (Rate) Actual Contribution Made (Rate) Percentage of ARC Contributed 09/30/07 09/30/08 09/30/09 .01% .01% .02% .01% .01% .02% 100% 100% 100% 66 NONMAJOR GOVERNMENTAL FUNDS SPECIAL REVENUE FUNDS Special Revenue Funds are used to account for specific revenues that are legally restricted to expenditure for particular purposes. Voluntary Park - This fund is used to account for the operations for which voluntary contributions by citizens are used. Contributions are used primarily to support park activities. Voluntary Library - This fund is used to account for the operations for which voluntary contributions by citizens are used. Contributions are used primarily to support library activities. Police Asset Forfeiture -This fund is used to account for activity related to seizure of assets in criminal-related activities. Tree Preservation - This fund is used to account for operations related to replacement of trees, which are eliminated due to commercial development. Contributions are received from entities that are developing the property. Library Donation - This fund is used to account for private and corporate donations for capital purchases related to the new library building for the City. Recreational Event - This fund is used to account for activities related to athletic events for the City. Community Development Center - This fund is used to account for contributions received to construct a community center. Recycling - This fund is used to account for the promotion of recycling activities in the City of Colley viI Ie. Contributions are received from the holder of the City's recycling franchise. LEOSE (Law Enforcement Officer Standards and Education) - This fund is used to account for activities related to the continuing education of qualified law enforcement officers as funded by the State of Texas LEOSE Account. 67 Colleyville Economic Development - This fund is used to account for the use of bond proceeds and sales tax revenues for municipal park improvements, the purchase of land and equipment for additional neighborhood parks and for the construction of a community center and library. Crime District - This fund is used to account for the Colleyville Crime Control and Prevention District formed to act on behalf of the City for financing the development of crime control throughout the City. Kidsville Maintenance - This fund is used to account for contributions received for the maintenance of Kids vii Ie Playground. Special Donations - This fund is used to account for various donations made to the City for specific projects. Court Technology - This fund is used to account for the collection and use of fines collected to be specifically used on technology for the court. Court Security - This fund is used to account for the collection and use of fines collected to be specifically used for security purposes. Capital and Cable Equipment Replacement - This fund is used to account for the replacement of cable equipment and other capital equipment. Sales Tax Incentive Agreement - This fund is used to account for the repayment of sales tax incentive agreements. Public Art - This fund is used to account for the acquisition of art to be placed in City owned facilities with high public visibility. CAPITAL PROJECTS FUNDS Capital Projects Funds are used to account for the acquisition and construction of major capital facilities other than those financed by proprietary funds and trust funds. Parks Tomorrow Fund - This fund is used to account for proceeds received on gas leases on City-owned parks property for parks capital projects. Parkland Dedication Fund - This fund is used to account for the acquisition of land for new park sites and to make improvements to or expand existing parks to better serve new development. Fees collected from the developers of residential and commercial development finance the improvements. Colleyville Economic Development Corporation (CEDC) - This fund is used to account for financial resources to be used for the acquisition of construction of CEDC capital facilities. Financing is provided primarily by the revenue from certificate of obligation bonds. Kimzey Park - This fund is used to account for the construction of Kimzey Park. The source of funding was a Texas Parks and Wildlife state grant. 68 THIS PAGE INTENTIONALLY LEFT BLANK 69 CITY OF COLLEYVILLE, TEXAS. COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS SEPTEMBER 30, 2009 Special Revenue Funds Voluntary Police Asset Voluntary Park Library Forfeiture ASSETS Cash and cash equivalents $ 24,731 $ 180,499 $ 1,747 Investments 196,431 208,159 Due from other governments Accrued interest 1,448 1,011 Total assets $ 222,610 $ 389,669 $ 1,747 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable $ $ 5,250 $ Accrued liabilities Advances from developers Total liabilities 5,250 Fund balances: Special revenue funds 222,610 384,419 1,747 Capital projects Total fund balances 222,610 384,419 1,747 Total liabilities and fund balances $ 222,610 $ 389,669 $ 1,747 70 Special Revenue Funds Community Tree Library Recreational Development Preservation Donation Event Center Recycling LEOSE $ 61,927 $ 104,469 $ 10,647 $ 22,770 $ 1,484 $ 20,237 $ 61,927 $ 104,469 $ 10,647 $ 22,770 $ 1,484 $ 20,237 $ $ $ $ $ 1,400 $ 56,723 56,723 1,400 5,204 104,469 10,647 22,770 84 20,237 5,204 104,469 10,647 22,770 84 20,237 $ 61,927 $ 104,469 $ 10,647 $ 22,770 $ 1,484 $ 20,237 ( continued) 71 CITY OF COLLEYVILLE, TEXAS COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS (Continued) SEPTEMBER 30, 2009 Special Revenue Funds ColI eyvill e Economic Kid sville Development Crime District Maintenance ASSETS Cash and cash equivalents $ 1,438,336 $ 735,916 $ 20,426 Investments 561,736 Due from other governments 218,632 161,682 Accrued interest 9,917 Total assets $ 2,228,621 $ 897,598 $ 20,426 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable $ $ $ Accrued liabilities 6,755 Advances from developers T otalliabilities 6,755 Fund balances: Special revenue funds 2,228,621 890,843 20,426 Capital projects Total fund balances 2,228,621 890,843 20,426 Total liabilities and fund balances $ 2,228,621 $ 897,598 $ 20,426 72 Special Donations $ 10,868 $ 10,868 $ 10,868 10,868 $ 10,868 Court Technology $ 44,002 $ 44,002 $ 44,002 44,002 $ 44,002 Special Revenue Funds Capital and Cable Equipment Replacement Court Security $ 85,160 $ 85,160 $ 85, 160 85, 160 $ 85,160 $ 549,616 $ 549,616 $ 549,616 549,616 $ 549,616 ( continued) 73 Sales Tax Incentive Agreement $ 903,431 $ 903,431 $ 903,431 903,431 $ 903,431 Public Art Fund $ 13,904 $ 13,904 $ 13,904 13,904 $ 13,904 Capital Proj ects Parks Tomorrow Fund $ 2,053,327 $ 2,053,327 $ 305,035 305,035 1,748,292 1,748,292 $ 2,053,327 CITY OF COLLEYVILLE, TEXAS COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS (Continued) SEPTEMBER 30, 2009 Capital Project Funds Total Parkland CEDC Capital Kimzey Governmental Dedication Project Park Funds ASSETS Cash and cash equivalents $ 420,315 $ 595,631 $ 3,576 $ 7,303,019 Investments 1,153,894 2,120,220 Due from other governments 380,314 Accrued interest 6, 174 18,550 Total assets $ 1,580,383 $ 595,631 $ 3,576 $ 9,822,103 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable $ $ $ $ 311,685 Accrued liabilities 6,755 Advances from developers 56,723 , Total liabilities 375,163 Fund balances: Special revenue funds 5,519,058 Capital projects 1,580,383 595,631 3,576 3,927,882 Total fund balances 1,580,383 595,631 3,576 9,446,940 Total liabilities and fund balances $ 1,580,383 $ 595,631 $ 3,576 $ 9,822,103 74 THIS PAGE INTENTIONALLY LEFT BLANK 75 CITY OF COLLEYVILLE, TEXAS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES NONMAJOR GOVERNMENTAL FUNDS FOR THE YEAR ENDED SEPTEMBER 30, 2009 Special Revenue Funds Voluntary Voluntary Police Asset Park Library Forfeiture REVENUES Taxes $ $ $ Fees and fines 172 Intergovernmental Charges for services 145,826 Donations 145,826 Investment earnings 12,238 11,034 , Miscellaneous 3,753 Total revenues 161,817 156,860 172 EXPENDITURES Current: General government Community development and engineering Fire and rescue Leisure services 167,580 Municipal court Police Principal Interest and other charges Capital outlay 337,887 Total expenditures 337,887 167,580 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES ( 176,070) ( 10,720) 172 OTHER FINANCING SOURCES (USES) Sale of capital assets Transfers in Transfers out Total other financing sources and uses NET CHANGE IN FUND BALANCES ( 176,070) ( 10,720) 172 FUND BALANCES, BEGINNING 398,680 395,139 1,575 FUND BALANCES, ENDING $ 222,610 $ 384,419 $ 1,747 76 Special Revenue Funds Community Tree Library Recreational Development Preservation Donation Event Center Recycling LEOSE $ $ $ $ $ $ 12,518 3,978 33,949 1,080 15,000 46,467 1,080 15,000 3,978 19,354 38,560 6,975 30,143 68,703 19,354 6,975 ( 22,236) 1,080 ( 4,354) ( 2,997) ( 22,236) 126,705 1,080 9,567 ( 4,354) 4,438 ( 2,997) 23,234 5,204 22,770 $ 5,204 $ 104,469 $ 10,647 $ 22,770 $ 84 $ 20,237 ( continued) 77 CITY OF COLLEYVILLE, TEXAS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES NONMAJOR GOVERNMENTAL FUNDS (Continued) FOR THE YEAR ENDED SEPTEMBER 30, 2009 Special Revenue Funds Coli eyvill e Economic Kidsville Development Crime District Maintenance REVENUES Taxes $ 1,239,437 $ 996,944 $ Fees and fines Intergovernmental Charges for services Donations Investment earnings 24,948 8,479 Miscellaneous Total revenues 1,264,385 1,005,423 EXPENDITURES Current: General government Community development and engineering 61,640 Fire and rescue Leisure services 62,958 917 Municipal court Police 418,437 Principal 275,000 Interest and other charges 368,195 Capital outlay 145,847 164,571 Total expenditures 913,640 583,008 917 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 350,745 422,415 ( 917) OTHER FINANCING SOURCES (USES) Sale of capital assets 3,120 Transfers in Transfers out ( 7,500) ( 517,721 ) Total other financing sources and uses ( 7,500) ( 514,601) NET CHANGE IN FUND BALANCES 343,245 ( 92,186) ( 917) FUND BALANCES, BEGINNING 1,885,376 983,029 21,343 FUND BALANCES, ENDING $ 2,228,621 $ 890,843 $ 20,426 78 41,412 15,000 41,412 15,000 ( 3,398) 7,387 7, 791 7,537 ( 230,185) ( 1,996) 1,748,292 14,266 36,615 77,369 542,079 1,133,616 15,900 $ 10,868 $ 44,002 $ 85,160 $ 549,616 $ 903,431 $ 13,904 $ 1,748,292 ( continued) 79 CITY OF COLLEYVILLE, TEXAS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES NONMAJOR GOVERNMENTAL FUNDS (Continued) FOR THE YEAR ENDED SEPTEMBER 30, 2009 Capital Project Funds CEDC Total Parkland Capital Kimzey Governmental Dedication Project Park Funds REVENUES Taxes $ $ $ $ 2,236,381 Fees and fines 55,565 Intergovernmental 17,496 Charges for services 2,904,277 Donations 3,604 401,432 Investment earnings 52,173 136,679 Miscellaneous 18,753 Total revenues 55,777 5,770,583 EXPENDITURES Current: General government 19,354 Community development and engineering 304,294 Fire and rescue 13,703 Leisure services 8,979 2,533 285,680 Municipal court 30,215 Police 428,927 Principal 275,000 Interest and other charges 368,195 Capital outlay 84,781 2,049,597 Total expenditures 84,781 8,979 2,533 3,774,965 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES ( 29,004) 8,979) ( 2,533) 1,995,618 OTHER FINANCING SOURCES (USES) Sale of capital assets 3,120 Transfers in 56,412 Transfers out ( 525,221) Total other financing sources and uses ( 465,689) NET CHANGE IN FUND BALANCES ( 29,004) ( 8,979) ( 2,533) 1,529,929 FUND BALANCES, BEGINNING 1,609,387 604,610 6, 109 7,917,011 FUND BALANCES, ENDING $ 1,580,383 $ 595,631 $ 3,576 $ 9,446,940 80 CITY OF COLLEYVILLE, TEXAS DEBT SERVICE FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED SEPTEMBER 30, 2009 81 AGENCY FUNDS Employee Activity Fund - This fund is used to account for funds held by the City for the benefit of employees of the City. Sesquicentennial Fund - This fund is used to account for funds held by the city for the benefit of the City of Colleyville' s historical purposes. 82 CITY OF COLLEYVILLE, TEXAS COMBINING STATEMENT OF FIDUCIARY NET ASSETS AGENCY FUNDS SEPTEMBER 30, 2009 Employee Activity Sesquicentennial FlUld Fwd Total ASSETS Cash and cash equivalents $ 5,385 $ 18,800 $ 24,185 Total assets $ 5,385 $ 18,800 $ 24,185 LIABILITIES Total liabilities $ $ 5,385 $ 18,800 $ $ Due to other agencies and individuals 24,185 5,385 $ 18,800 24,185 83 CITY OF COLLEYVILLE, TEXAS COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES AGENCY FUNDS FOR THE YEAR ENDED SEPTEMBER 30, 2009 Employee Activity Fnnd Balance Balance 1 % 1/08 Additions Deletions 09/30/09 Cash and cash equivalents $ 3,427 $ 3,174 $ 1,216 $ 5,385 Total assets $ 3,427 $ 3,174 $ 1,216 $ 5,385 Due to other agencies and individuals $ 3,427 $ 3,174 $ 1,216 $ 5,385 T otalliabilities $ 3,427 $ 3,174 $ 1,216 $ 5,385 Sesquicentemrial Fnnd Balance Balance 10/01/08 Additions Deletions 09/30/09 Cash and cash equivalents $ 18,530 $ 270 $ $ 18,800 Total assets $ 18,530 $ 270 $ $ 18,800 Due to other agencies and individuals $ 18,530 $ 270 $ $ 18,800 T otalliabilities $ 18,530 $ 270 $ $ 18,800 Total Agency Funds Balance Balance 10/01/08 Additions Deletions 09/30/09 Cash and cash equivalents $ 21,957 $ 3,444 $ 1,216 $ 24,185 Total assets $ 21,957 $ 3,444 $ 1,216 $ 24,185 Due to other agencies and individuals $ 21,957 $ 3,444 $ 1,216 $ 24,185 T otalliabilities $ 21,957 $ 3,444 $ 1,216 $ 24,185 84 STATISTICAL SECTION This part of the City of Colleyville, Texas' comprehensive annual financial report presents detailed information as a context for understanding what the information in the financial statements, note disclosures, and required supplementary information says about the government's overall financial health. Contents Page Financial Trends 87 These schedules contain trend information to help the reader understand how the government's financial performance and well- being have changed over time. Revenue Capacity . 94 These schedules contain information to help the reader assess the government's most significant local revenue source, the property tax. Debt Capacity 99 These schedules present information to help the reader assess the affordability of the government's current levels of outstanding debt and the government's ability to issue additional debt in the future. Demographic and Economic Information 105 These schedules offer demographic and economic indicators to help the reader understand the environment within which the government's financial activities take place. Operating Information 107 These schedules contain service and infrastructure data to help the reader understand how the information in the government's financial report relates to the services the government provides and the activities it performs. Sources: Unless otherwise noted, the information in these schedules is derived from the comprehensive annual financial reports for the relevant year. 85 THIS PAGE INTENTIONALLY LEFT BLANK 86 ...... ~ ~ 00 ~ ~ ~ ~ ~ ~ ~ o u ~ o ~ ~ u ~ z ~ o ~ ~ o u ~ = rI1 ~ ~ 7JJ 7JJ -< ~ ~ ~ .s =: == ~ c..- c..- ~ ~ .~ ~ ~ ....... ~ e ~ ~ ~ 0\ o ~ 00 o ~ t- O ~ \0 o o N l.() o ~ """ o o N M o ~ t-\Ov 0\ 0\ \0 ~oooo M" 0" 00" ~~O\ ("'.lov 0\" ,.....r" t"'"--" t- C"l EI7 VJ 0\ \0 NOO('t') t-\O,.....r """" 0\" C"l" 0000\0 ;:" 00 :" t- ("'\I EI7 0'\ \0 00 ,.....rOOt"'"-- t-l.()t"'"-- V" C"f t"'"--" NMoo 00" 0" 0\" ,.....r ,.....r 1""""1 t- C"l EI7 \000\0 ~t-1""""I ,.....r l.() 00 .....-I" t-" C"l" O\MO 0\0'\0 \0" 0\" \0 ,.....r EI7 \00\0 V)('I')t"'"-- t-.....-I('t') """" \0" C"l" 000\('t') 00 00 1""""1 0" 0\" \0 1""""1 EI7 \O\Ot"'"-- .....-1.....-10\ \Ol.()<o:::t' V)" \0" 00" V)V)<o:::t' Ot-O\ 0" v)" \0 1""""1 EI7 OMO\ 0\0 V) 0\~C"l v)" 0" \0" \O~<o:::t' 0\0\0 v)" .....-I" If')'' V) 1""""1 EI7 1) Q) ~ "'d Q) !S ~ 4-t o ~ C1.1" ~ rn ~ .2 ~ ] o d d -= ~ ~ 8 d ~ .~ .S ~ Q) 1ij ~ ~ "'0 ~ ~ ~ .t:: . t:: t;; tn Q) ~~ t- V) N ('1')" 00 t- t-" o .....-I N1""""I\O \OooM V) 1""""1 t- """" t"'"--" t-" t-OON .....-I 0\ ,.....r 0\ 00" ('I') EI7 EI7 o l.() l.() \0" M N 0" o ,.....r 00 0\ 0 ...q~0\ .....-IMt- N" ~" t-" ...q("4('1') ...q 0 00 0\" .....-I" t-" ('I') f;I7 f;I7 M 00 o l.()" ...q 00 ...q" 0\ M.....-I""" g~N ~" 0" \0" OooN 000\0 (",-1" 1""""1" ('1')" ('f') .....-I f;I7 V7 o "'f' "'1 .....-I ('I') 0\ ...0 00 0\1""""IN .....-IC"lt- \Ooot- 0\" ("'\I" ('f')" .....-I 00 l,f) O\ooN l,f)" 0\ N ,.....r &7 V7 N \0 N M" ,......( 0\ 0" 00 l,f)1""""I\O \Ot-M ('f')V)N t-" 0" v" Nt-t- 00 \0 ('f') ~" ~" frJ V7 0\ ("\I \0 0" \0 t- \0" . t- NO\V) ~~N t-" 00" 0" V)\Ot- 0\\0 v M" l,f)" N .....-I V7 V7 N l,f) \0 ("\I" l.() \0 ("\I" t- v 0.....-1 \OC"lN 00 ,.....r .....-I 00" 00" N" 00\00 V) \0 l,f) C"l" ..q-" ("\I ,......( f;I7 f;I7 C1.1 ~ Q) rn C1.1 d +ol' Q) d C1.1 .2 .~ ~ d -= ~ ~ 61 d ~ .:0 ~ ~ Q) ] ~ 4-t o ~ C1.1" -+-I Q) 00 ~ .2 d :~ 3 ~ .~ Q) ~ .S "7'~ C1.1 Q) [i t;; .S ~ ~ ~ ~ ~ "'0 ~ Q) . t:: '0 -+-I ] [i ~ ~ 0\ t- V 0\" 00 N 00" ~ 0\ t- 0 l.()!:"O 00\0 00" 00" \0" ,......(NN vO\O 00" ('1" v)" 'I""""l M 'I""""l V7 V7 t- oo N v" o ('f') 00" v MOO \0 t-("f)N 0000\ \C)" ..q-" 0\ N,.....rO\ 0\ 0\ \0 \0" "0\" 'I""""l C"l ,.....r V7 V7 00 N t-" 'I""""l 'I""""l V) t-" V ("\It-N N('f)l.() ~ ('f) 0 0'\" ('f)" v" N,.....r'l""""l \0 ,.....r \0 ..q-" N" l,f)" o ('f) ,.....r V7 &7 N ,.....r N \0" l.() o \0" ~ 1.(')0'\00 \0 0\ 00 t- M l,f) 0" 0" \0" ,......(Nl,f) ~" 00" ~ 0\ ('f') V7 f;I7 N t- .....-I ("\1" t- oo" .....-I V """'('I""""lN NO.....-l ,......(t-\O ("\I" \0" \0" ,......(\00 t- l.() an l,f)" .....-I" l,f)" 00 ('f) V7 f;I7 \0 v 0\ an" 0\ o 0" v OOl,f)N Vl.()t- Ot-t- M" v" 00" ,......(N'I""""l ~" :::" :::" 00 ('f') V7 V7 I.(') o 'I""""l 0\" l.() t- t-" ("f) v M 0 l.()('.l00 00 l.() ('f') v" 00" 00 V) 0 v l,f) t-" 'I""""l 00" .....-I 0" t- ('f) V7 V7 C1.1 l) C1.1 C1.1 d ~ Q) d C1.1 .2 ~ ~ Q) ~ "7' C1.1 C1.1 Q) .S C1.1 .5 d "0 f-4 .:0 Q) "'d ~ Q) ~ ] ~ o +ol' Q) d C1.1 " ~ Q) rn rn d ti] ~.~ -tj ~ .S "'d "* o ~ .s .t:: jb.O .s . g 1ii rn ~ Q) ~ g'S ~ . ~ ~ ::::> \0 ('f') t- N" t- o \0" V) 'I""""l V7 t- ('f) 00 0" v l,f) 00" V 'I""""l V7 'I""""l 'I""""l 00 \0" V) ('f) N" v 'I""""l V7 N l,f) t- t-" 00 0\ N" ('f) 'I""""l V7 v ('f) ~ l.(')" 00 t- N" N 'I""""l V7 I.(') t- I.(') \0" l,f) 00 \0" 1""""1 1""""1 V7 t- V) t'-" 'I""""l 'I""""l ..q- 0" 'I""""l 'I""""l V7 rJJ ~ Q) rn ~ ~ = ~ ~ 61 l o.c d "0 f-4 ("f') o o C'l ~ o )>.. Cd u U'l tp .S ~ ("f') t:Q r.Il c3 "0 o ~ E i I:" QO .~ e ~ 6 '.,p ~ ~ .S Cd b u cd ~ fr ..... o ~ a ~ ,.c P 'l""'I U ~ ~ o ~ o Z N ~ ~ rLJ. ~ ~ ~ ~ ~ ~ ~ o u ~ o ~ ~ U rJ:J. ~ r-r-1 rJ:J. rJ:J. -< ~ ~ ~ rJ:J. fj ~ U ~ .5 ...... == :::t ~ ~ rw ~ ~ .l'.I ; ~ ~ ~ rw rw ~ 0'\ o o C"l """(....-.I("t1O'\C"l"'d"t---O\O\O ooOO\V\V\C"l.,.....-4....-.1oo('l ~"' 6 ~"' ~"' ~"' ~ ~"' ~ :- :~ "'d" ("t1 .....t "'d" V\ 0\ ~ 0 V\ t' O'\V\.,.....-4O'\"'d"('lOOV\O\O ("'4"' .,.....-4"' ~"' ('fl"' ~"' ("t1"' ~ ('l"' M GI9 00 o o C"l -.::t -.::t .,.....-4 V\ V\ 0 00 0 oo:t .,.....-4 t'N.,.....-40\oC"l('fl("l').,.....-4oo :"' ~ ;.- ~ ~"' ~"' ~ ~"'::"' ~"' ....-.Ioo\f')('fl.,.....-4C"lV\C"lO.,.....-4 00 oo:t"' 0\ 0 oo:t ('f) \C .,.....-4 .,.....-4 0\ M .,.....-4 ("t)"' oo:t "' ~~ ("1')"' .,.....-4"' .,.....-4"' C"l V7 t""'- o o C"l .....too.,.....-4~~OOV\l()~ 0 l()\OMO\ooO\ooO'lt'OO ot---ooOO'l~.....tO\M~ 00"' M"' 0"' l()"' oo:t"' C"f C"f 0"' ('l"' 0"' ("I')("'4O\C"lM\oMo\M('fl ~"' ~ ~"' ~ oo:t N ~"' ~"' ~"' 2 M GI9 \0 o o C"l ~\O\f')Noo:tt()~l()MOO \O("t100C7\O"'d"~\Ooo:tt--- o .....t l() 0\ l() ('f) \0 oo:t 0 t--- 0\"' t""'-"' ~ ("t1"' ("t1"' 0"' ...; ('l"' ('l"' oo:t"' ('l \0 .....t .,.....-4 00 t' 0 C'f) oo:t t() t'("'4ooV\C'f)NooO\.....too ('l"' .....t"' C'f)"' C'f)"' C'f)"' C"f ~"' 0\"' .,.....-4 Ef3- l() o o ("'4 oo::t l() ("I') 00 -.:t ..... ("t1 l() t' ("f) \C~Ol()("f)t'oot""'-l()O\ O'IM.....tO'l-.:tOOO~ooo \f')"' ~"' l()"' M"' oo:t"' 00"' M"' 0"' 0"' t---"' ~\CNC"l\O('f)Mt'O'Il() ~"' :"' ~"' ~"' ('f) C"l ~ ~"' :"' ~ .,.....-4 GI9 ~ o o ('l \OC7\-.:too\C~MO\V\~ .....t('l.,.....-4('ll()t()\CO\C"loo O"'l:tOOl()Nt()('l""l:t"OO~ ("'4"' .,.....-4"' ""l:t""' ("t1"' "'d""' 0"' \f')"' ("'4"' 0"' lfi"' -q-oo-q-l()\c t() 0\"0 0'1 00 l()('l.....tO\MC"l("'4l()N\O ('l"' .,.....-4"' ("t)"' ('l"' ("t)"' C'..f ....; t'"' .,.....-4 GI9 M o o N 0\0 ot""'-l() ('f)O\\O 0\ 00 oo.,.....-4\Ooo\Ct()....-.Il()"","00 o\"'~("'4NooO~N\O .,.....-4 ....-.I 0"' 0"' 00 M"' If')"' 00"' l()"' ...; lfi"' l() oo.....t NO\('f) 0\0\ 0\ 00 l() N 0 t---"'.....t N ~ ~ -q- .,.....-4 .,.....-4"' .....t"' ("t)"' N ("1")"' N"' ~ \C~ .,.....-4 Ef3- bl) ;:::: . t:: Q) ~ '6h ~ ] ~ en e .~ ~ ~ .~ Q) ~ ~~~88 '3 ~ 0 ~ 'E 00 = ~'a e $ ~~111~ ~~~8~3 ~t) ~ a 8 8 ~ ~ j ,~ = 'a 8 'C; :3 ;.::::l ~~~ ~ = 0,) ~ 0,) 00 0,) '+3 .~ '.&1 ~ ~ pO ~ ~ j S .; r!n e .a ] ~ "'d = 5h ~ ~ '3 i e ~ -l:i ~ 00 ..-...c N "0 .,.....-4 0\ t' .,.....-4 "0 -q- M 0 ('f'I t' ('.f 00"'.,.....-4"' ...; .,.....-4 l() M 0 "0 "0 M "0", 0"' .,.....-4 .,.....-4 .,.....-4 ooOM 0 ~o~ 0\ l() \0 \0 t' 0'1"' M"' ('l"' l()"' ~ ~ ~ ~ .,.....-4"' ('l"' .,.....-4 .,.....-4 C"l M C"l t--- 00 t--- lI') 0 N t--- t--- 00 ~.,.....-4"'o~ Mt'O 0 M \0 ~ ..... 0\"' 0"' .....t MMM 0\ r--. \COM C'f) 0\ r--. 0 00"' 00"' 0"' 00"' N oo:t ..... ...-4 ""'" lI') oo:t ~ 0\"' 0- .....t o lI') C'f) 0 \0 0 C"l"' 0"' \0 \f') 0\ l() 00"' o C'f) r:-- .,.....-4 6~"' I l() .....t 00 l() ~ MOO C'f) o \0 \0 ("'4 \CO\tn .....t ~"' -q-"'.,.....-4"' ....; o tn 0 "0 t' C'f) "0 "0 t'"' 00"' 00 ~ \I) .s :~ ~ '+3 .s ~ ~ \I) ~ ~1 o ~ 8 .!! .~ ~ ~ ~ E ] ~ ~ cd ~ '~ ! A ~ lI') C'f) \0 N"' .....t l() a\ C'f) 00 N 00"' \0 M 00 ~ ~ ~ \I) cn 0,) -..::3 '~ '..z;:3 g 0,) ~ J, fI) ~ '~ = ..c '3 o H l() t' lI') \0"' t' ('l ~"' M o -q- \0 r:-- 00 .....t 0'1 0\ M r:-- O.....t.,.....-4000M.....tOON 00 ~"' ~"' ~"' ~"' ~"' ~"' ~"' ~ ~ ~"' ..........\Ot'o\Ol().,.....-4.,.....-4\O 0\ \OMtnO Mt'M 00 \li .,.....-4"' 0\"' GI9 GI9 .,.....-4 t' .....t C'f') "' \f') o ~"' M o C'f) "'l:t 00 0\ 0\ 00 t--- "'l:t ('l Otn.,.....-4M.,.....-4O\oo\Cl() C'f) ~"' ~"' ~"' ~"' ~~ ~"' ~"' ~"' ~"' ~"' .,.....-4 C'f') V') \0 t' t" l() \f') t'--- 0 ('fl", N \f') ""'i C'f) 00 0\ \0 .....t .,.....-4 ...; ~ 0\"' EA EA r:-- 00 M 0"' -q- l() 0"' M O~OO~N""'"r:--M.,.....-4 M O~\OMV')tnl()oooo \0 ot"OOO"'=tO.,.....-4\OMM "0"' -q-"' M"' ....."' ("I"' .....t"' \f')"' .,.....-4"' C"l"' .....t"' l() 0 M M 00 l() C'f) t'--- \0 "'l:t M -q- 0\ M"'" M M ~"' l()"' a\ f8 w t"-- .,.....-4 00 N t' (".t: 0- M O\O\O\O.....tO\oO'\t- "'l:t oO\oooOOO\\O~V') 0 o lI"'l C'f) \0 t'-- 00 00 00 ("t1 M \0"' M"' 0\"' 00"' ('tr 0"' C"f 0'\"' lfi"' 0"' \0 M -.::t .,.....-4 t'-- t"-- 0'\ l() t' .....t C"l -.::I' 00 -q- C'f) M 0\ (".t:"' -.::1'"' 00"' EA EA 00 N t--. 0\"' \C ~ t"~ M O('lOOOOl()-.::I'.....too:t~ "0 o l() 0\ l() 0 M .....t 0 t--- C'f') ~"' ~ ~"' ~"' ~"' ~"' ~ ~"'~"' ~"' .....t M 00 0\ 0\ ("t1 MOOt' V"l .,.....-4 C'f') ~ M V"l M t"-- .....t"' ("t1 .. \li f8 V7 'l::I" \C "I:t"' M l() o \O~ M 0.,.....-4.,.....-40\ (".t:l().....tO\N 0 o ('l 00 .,.....-4 r:-- C'f) t'--- lI"l 0 \0 o 0\ 0 ("t1 l() 'f'""i .....-4 -.::t""' N 00", \0"' r---"' lI')"' a\ 00'" \0'" ("of 0\ ~ .,.....-4 .,.....-4ooNO\O\O..-I.....tl() 0\ \0 .,.....-4 C'f') V') l() \C 00 t' ...-4... M t"--"' EA EA 'I"""l ~ M \0'" "'d" 00 oo:t"' ('l OOOOoo"","\OO\"","'I"""lO OMO\O\-q.('lO('lO M o 00 0\ 0 l() \0 C'f) ("I') l() ('l 00"' C"'l"' 'l::I""' -.::1'"' 0'" V)"' 0"' 00"' -.;:t'" 0'1"' .....t -q- 0 0'1 .....t ""'" -.::I' C"l .....t 0\ ("'4.....tMtn ('lMO 00 .....t... 00'" 0'" .....t EA EA fI) ~ fi ~ Go) ~ ~ 1 po ~ i , t:: ~ '3 o H cn Q) a ~ e ~ e CI.I Po4 ~ cn ~ '+3 ~ '..z;:3 .5 "+3 '~ '.8 = '..z;:3 = ~ g ~ ~ 8 ~ .~ fa 1 ~ .a 1.5 ~ 1 OJ) ~ ~ ~..Ei '$ '3 ~ e '" ~ CI)~~ ~ . t:: 0,) ~ '6h ~ ] 1:i 00 e ~oo -=j ~:~~8~ ~ '.g 'E ~ Q ~i~~,~ ~=~~s ;j~ 2?~ ~ 0~~O() ~8() ~ CL) 8 ~ ~ 'E 8 .;~1 !:1 ~ '0 cd :3 '8 8 e fI) :3 ..... ~:s~~ ~ ~ = .$ ..... = o CJ "-'" QO QO M ~ ~ VJ ~ ~ ~ ~ ~ ~ ~ o u ~ o ~ J--( U ~ ~ ~ -a r/.) = r/.) = <~S E-I ~ crw ~~~ ~a~ 7: .- ~ -=.~ r/.) = ~ ~~~ ~ ~ ~ S u ~ 0\ o o M 00 r.---. M 00 \OM 0\ 0\ ~"~,,~,, ~ o t--. \0 ~ M 00 M ~" M" ~ ~ GI9 00 o o M MM tr'i 0 0\....-1000\ 00 0 r.---. \0 ~" 0\" tt)" 0\" ....-I tr'i....-l 00 ....-I 00 ~ M ....; ....; M" ~ ~ GI9 r.---. o o M o N l.I) r--- r.---. r.---. l.I) 0\ ~"~,, ~ :g"' N ~ \0 ('f) ~ 00 lI), lI), 0\"' ~....-I ....-I GI9 \0 o o M 00 ~ ("4 \0 tr'i N 00 C"l N t--."' 0 00" 00 0 00 ....-I ~ N M ....;~"' ~ ~ GI9 \f') o o N 0\ tr'i \0 0 00 ~ tt) 0\ 00 0 N ~ \0" tt)"'~"' \0"' tr'i t--. ~ r.---. 00\0 00 M 0\"' ~"' ~ GI9 ~ o o ("4 NM 0 l.I) ~....-I 0\ ~ 0\ 0\ 0\ 00 ~"' f:" ~ ~"' 0\ \0 ~"' 0", 00" ~....-I ....-I GI9 M o o N ....-I 0\ N N t--. 0\ 0 t' 00", M" lI), t---" li1 \0 M l.I) 0\ \0 ~ 0 l.I) \0 ~ r.---. 00"' ....; 0"' ~ Eo'9 C/J Q.) S ~ e ! G g Q.) Pot S C/J ~ '.0 = '.D ~ ..g . ~ ~ M ~'g ~&1oo~ 8 ~ z ~ .~ i .., ~ ~12~ ;.~ ~a> M"O d:::l ~~~~~~3 ~ ~~~'3 0 Q.) a ~'" , 1"'1 E-t 0.~ ~ ~ ~ o=u U ~t:Q ~ l.I) 00 00 N"' M ....-I N N ..-... 0\ 0\ 0 ('Ij ~ 0\ ~"d- ~"' 00 ~ ~ r.---. \0 ~ r--f N"' ~ ~ Eo'9 '-" EA ("4 N l.I) M" 0\ 0\ N"' N ..-... 0\ 0 0\ ~ 0 ~ \f') 0\ \0 ('f)" M"' 0\"' ......c l.I) l.I) M N 0 C..,f....; ~"' ~ ~ GI9 '-" EA o \0 0\ ~ 0\ 00 0"' N ..-... r.---.o r.---. ~ 0\ M M 00 M 0\"' 0"' 00"' \0 N "'d" I:""- ~ \0 o"~"' 0\"' ~ GI9 '-" EA \0 N l.I) 00"' VI N M"' N ....-... "'d" M ~ t--- 00 0\ "'d" ~ M "'d"" 0 ~"' 00 t"-- ....-I 00 00 0 0"' M t"--"' ~ w '-" EA \0 N o N l.I) ....-I 00"' ~ ....-... t'-- tr'i N l.() l.() 0 M l.() t"-- ~"' M"' r.---."' 00 \0 ~ ~ 00 C'f')", ~"'....-I"' 0\ ....-I GI9 '-" GI9 l.() o r--- t"--"' o 00 00"' ~ ....-... ~ N 0\ M \0 l.() M l.I) r--- M"' t---"' lfl"' 0\ ~ "'d" 00 \0 M 0\"' N"' t"--"' EA '-" EA M o o \f')"' o \0 ......."' M ....-... 00 0\ 0\ l.I) ~ 0 0\ \0 M II)"'~"' ~"' 00 ~ "'d" MOM l.()"' N"' M"' w '-" EA 00 ~ ~ 00 ~ ~ f;I;l z Z 1-1 00 t5 2 ~ ~ u ~ ~ ~ == ~ ~ ~ 0 il ~ 00 I ~ ~ ,.8 6h P -.8 '~ Z'~ 'g i ~'g Q.) 'I: ~ '3 ~ Pot ~ = f] ~a> ~ ~ ~~~ '~ ~ ~~ ~ ~ t) lZl Q.) a ~ e ! g P-t 1 ~ 6h i 'I: Pot :3 o E-t 00 f:3 z ~ ~ ~'.D '~ '.l:i ~g ~1 ~ IS ~ e '-~ ~ 0 ~o z o 0 \0 00 ~ "'d" r.---. t--- \0 N ~ r--- 0\ N I./') M 0\ ~ ~"'d"O\....-Il.()ooN t' ~ ....-I"' t'"' oo"~"' ~" r.---." 1./')"' ('f)" 0" N....-I~t't'r.---.NN M ~"' ~" ~,,~ oo~" ....-I N r--- 0 .q- N -.::t 00 N \0 M \0 \0 \0 M \0 "'d" ~ M 00 ~"' ;;"' ~"' ~ :"' ~"' ~ ~" ~"' \0 ~ .q- 00 0 0\ ~ -.::t \0 MOOr.---. 00 ~ 00 00 =" ~"' -.::t"' ~" tr'i\OooN~M t"--t'--\OM\O\O t"--MO~MO\ C'f"}"' 0\"' "'d""' 0\" ~... ~ I tr) r--- r--- 00 N 0\ ~r:-\O N 0"' ~"' "'d""' ~" ....-I \0 M t"-- tr) ....-I M 'o:::I""'::t"NO\o...... lOlrl\OOMM ("t)"' 0"' tr)"' \0"' .q-" \()" I 00 0\ tr) t' 0 \0 'o:::I"t---M 0\ 0\"' ....; .q-"' OOO\O\~OI:""- M 0 00 "'d" \0 t--- r.---. "'d" 0\ 0\ :" ~" ~~"' ~~"' I ~"' ~"' M t"-- 0 iii "'d" l.() \0 M 0\"'d"00 .q-....... ~ M 00" ~"' M" tr)"' ....-I ooO\.q-\O\OOO oot"--MO\~M M" 0" \0" N", trl... "1.. I "'d"OO~t"--t---M ('f) l.I) 00 M ....-I l.() l.I)"'::t"M N 00"' ~"' M"' OO\....-IM\OC""t O\\OMC"ll.()l() I:"--l()M~\OO C'f"}" 1./')"' "'d""' C'.,f 00"' M I ooO\\OM\O\O .......C'f')0\ ~ 00"' ~"' N"' t'~ Q) ~ M P-4 = lZl Q.) e fS~.;i P:;~ooO en ~ .~ 00 Q.) 6 = Q.) ~~ ~ ~ ]~ tr) 0 00 \0 o t--- ..q."' N"' \0 00 \0 \0 00"' ~ t"-- N tr'i tr'i M t"-- ("4"' r.---."' M 0 l.I) N 1:"--"' ~ \0 r.---. \0 ~ M \0 C'f')"' v)' t"-- tr'i -q- ~ "'::t""' ~ o ~ \0 00 o l.I) 00"' v)' If) \0 0" ~ ~ "'d""' ......c .f!l ~ cd '3 '~ r...,. o Q.) ~ d o d '~ t) 00 Q.) '.z:j , f;: '.D Q cd ~ i 6h ~ '3 ~ 0 l ~ 00 ..8 00 ] .r g cd Q) Q.) ~ i ~ ~ ~ ~ ~ !1) Ei .~ ~ ~ ~ o r.---. r.---. ..q. 0\ iii 0\ 1:'" 00 00" ('f) ..q.'" \0 N to ~ 00 \0 \() \0 ....... 0\ C'f') "'::t" If) 0\", M", 0"' ~ ......c 00 "'d" \0 M 00 ..q. o If) l.t"l ~ 00 N r.---." 0 \0 00 .0:; "'d""' 0\ \0 M 0\ \0 M 'oo:::t I:' t"-- ~ l.t"l \() M C'f"} 00 \0"' N"' M"' 'oo:::t M ~ 00 \f) M ..q. M 0\ \0 0\ M o M C'f') t"--"'.q-"' 1:'"' t"-- \0 00 M 'oo:::t \f) \0 ~ ..q. \0 M \0" M t'o N C'f')"' 0"' \0 t'o ~ .....c "'::t" M ~ 0 0\ \0 \0 0\ \0 0 M... c-f 00"' l.I) 00 \f) I:' M 0", r.---. ....-( 00 4.) .~ .~ '-l:i g ~ ch 00 ~ '~ :::I ..c :3 o E-t 0\ 00 l.I) tr)"' t"-- \0 0\"' ....-I N "'d" -q- r---"' o ~ 0\ ....-I If) 00 M t"--"' ~ o 0\"' ....-( 0\ o \0", ....-( N l.I) t'"' ....-( .....-I \0 l.I) \0"' "'::t" M If)"' ~ \0 0\ 00 -q-'" -q- 00 C'f') " ....-I \0 ...... 0\ -.::t MOO N"' \0'" \OM NM .q-"' N"' M 00 ...-l 0'" 0\ C'f"l C'f') "' ...-l MO N If) \0 N 0\0\ t' \0 OON 00"' ~"' = ~ ~ ~ i .~ Pot ~ o ~ 00 ~ ~ ~ rn ~ '.D ,~ ~'~ '~ ~ '.D '~ ~ g ~ Z'3 C) ~~~ tS ~ ~ ~ ~ '1;; = c3 ~ u r.---. 00 o 0 r--- 00 \0"' '<I:f'"' "'=t ~ lr'l t'"' "'=t 0\ C'f"l If') NlI"l v)'c-f \f) 0\ \f)t"-- r-.."' M l.I) -q-........ l.I) l.I) ('f)"' v) ~ lI"l 0\ oo::t", t'"' ...-l 00 0 r--- .q- N 0 M"' ~ Noo M ....-( \0'" ..q." C'f"l \0 C'f')N \ON N"' \0"' l.I)l:' ....-I F:'-- -.::t" ...-l"' 0\ 0\ 00 ~"' M If') t'"' v;) C'f"l 0\ t"-- r-.."' "'d" C'f"l 00"' GI9 00 tr) o 0\"' \0 ('f) 0\"' v;) 00 ...-l C'f"l r.---."' o \(') o .-( w 0\ \(') 00 00"' ("4 0\ \()"' ('f) o ~ 8 ~ ] CIJ P.;:l ,s "'" ('() ~ B 00 ~ 8 ....... 'E r/J (1) P4 : $ c.ev 00'1j ~~ ] a o (1) ~ - l .~ (1) .~ t) ~ ~~ '1j = t:a ,S t ~ d 8 ~cS !S .s ~1 li cS e .s -8 cB i 0\ Q) Q) .0 ~ ,-2 ~() ~~ 0; ~ 0\ QO EA I:"-- M .....c 0\'" 0\ \f) \0"' EA M r.---. 00 00 'oo:::t .....c 0"' .....c EA = ~ ~ ~ i '~ Pot ~ o E-t THIS PAGE INTENTIONALLY LEFT BLANK 90 ~ es ~ Vl ~ ~ ~ ~ ~ ~ ~ o u ~ o ~ JI-l U rJJ. ~ ~S u ~~ ~Z =r-l ~~ S~ o ~ ~ .5 ~I r-1 ~ ;>c~ ~~ U ~ rJJ.~ S__ Z ~ r-1 ,;10.. ~ ~ ~~ tIJ~ -< ~ ~S ~ ~ ~ td ~ ] ~ 0\ o o N GI9 00 o o N GI9 t"-- o o N GI9 \0 o o N GI9 tr'l o o N GI9 "I:t o o N w C1') o o N w M o o M GI9 '1"""'1 o o N tr'l (:"-... ~"' :! '1"""'1 C'f "I:t "I:t l.()"' w o o o N tr'l (:"-... \0 00 '1"""'1 M '1"""'1"' -.:f '1"""'1 0\ 1I1"' w ] ~ ~ ce e M l!~ o o N "I:t t"--"' o N 00"' 00 0\ C1')", t"-- '1"""'1 t"-- 00"' 0'\ M C1')", V) 0\ "I:t 00"' M \0 \0 l./j"' (:"-... V) r:-: '1"""'1 C1') (:"-... 0"' l() 00 ~ M 0\ l() (:"-..."' \0 (:"-... \0"' N l() '1"""'1 0"' "I:t .q- \0"' (:"-... "I:t \0 .n '1"""'1 o \0"' o C"l "'=t (:"-..."' o C"l 00"' V7 00 0\ M (:"-... "' '1"""'1 (:"-... 00"' e,c} 0'\ N M", It') 0\ "'=t 00"' e,c} C"l \0 \0 .n (:"-... It') (:"-..."' EiiI'9- '1"""'1 C1') (:"-... 0"' It') 00 \0"' Gft M 0\ It') (:"-..."' \0 (:"-... \0"' Gft M l.() '1"""'1 0"' "I:t "I:t \0"' Gft (:"-... "'=t \0 .n '1"""'1 o \0"' Gft C"l '1"""'1 M", M "'=t "'=t l.()"' e,c} N It') It') .n '1"""'1 0\", It') Gft ] 1 s o ~ ] ~ ~ ~ 6bPd ~ ~ d M o 0 -~ ~ (:"-... \0 It') '1"""'1"' M '1"""'1 '1"""'1"' o '1"""'1 l.() (f) (f) \0 t"--"' 0\"' \0 \0 M(f) t"--"' M '1"""'1 fI7 '1"""'1 00 \0 (:"-..."' 00 0\ l.() M o 0\ 0\ .q- \0"' '1"""'1"' 0\ '1"""'1 \0 00 V)"' (:"-..."' f.ot'7 \0 00 \0 "I:t"' It') c't '1"""'1 C"l '1"""'1 '1"""'1 C1') "I:t"' "I:t"' "I:t It') '1"""'1 It') 00 0 ~"' 0\"' Gft '1"""'1 00 \0", M 00 o '1"""'1"' 0'\ It') (:"-... N \0 M 0"' N"' \0 '1"""'1 (:"-... 0 "I:t"' (:"-..."' Gft M 00 It') 0\"' It') 0\ C"l"' '1"""'1 (:"-... \0 (f) 00 ~ '1"""'1"' 00"' It') (f) M ~ C1')"' (:"-..."' e,c} o '1"""'1 00 \0"' l.() o err o 0\ '1"""'1 l.() 00 00 0\ 1:'-"' V) \0 ~ 0\ M"' ~"' e,c} \0 00 "II:t "'=t"' (:"-... \0 M"' 00 tr'l (f) ~ 0\ 00 00"' M \0 '1"""'1 o 0 N"' \0"' EiiI'9- (:"-... (:"-... \0 \0"' 0\ '1"""'1 (:"-..."' '1"""'1 EiiI'9- ~ erl '1"""'1 ~ 00"' '1"""'1 Gft '1"""'1 N \I') 0\"' o \0 \0"' '1"""'1 e,c} oS ] ] "t:StSc.S ~ 0 ~ ~ s g ~ ~ 00' ~ e ~ ~ ~ '3 ~ 0 0.-4 ~ Q) ~ ;:i~CJ ~ 00 ~ It') 00"' It") t"-- 0"' M GI9 00 t"-- o \0"' 0\ ~ ~"' '1"""'1 fI7 0\ N tr'l -.::r"' M '1"""'1 \f") "' '1"""'1 Ef7 It') 00 l,f) l,f)"' l,f) 00 N"' '1"""'1 EA '1"""'1 00 00 0\"' ~ \0 ('1')"' '1"""'1 fI7 0\ t"-- ~ -.::r"' 00 ~ 0"' '1"""'1 ui "0 ~ &: [/) Y "(y ~ ~ .~ ~ U "0 ~ Q;) s Q;)i ~ ~ ~ 'g 004 CI.) ~ cS tf.) ~ ~ ~ .~ 0) 1d ~ 0) ~ 8 tf.) Cl) .g 0) i ~ en tf.) ~ 'f"""'I 0\ fI7 0\ \0 N \0"' It") r--. 0"' '1"""'1 fI7 (:"-... t"-- \0 \0"' 0\ '1"""'1 r--."' '1"""'1 GI9 ~ ('1')", '1"""'1 ~ 00"' '1"""'1 fI7 '1"""'1 N It') 0\ o \0 \0"' '1"""'1 GI9 ] '3 ~ ~ ~ 8 S ~ o 6b ~ Q.) '0 Z ~ ~ ~ VJ ~ ~ ~ ~~ ~ ~ ~ o u ~ o ~ ~ u ~ ~ .5 ~~ ~) ~S >:~ =~ ~~ ~~ ~.~ QZ TJj~ ~~ S~ ~~ z ~ rJ1~ ~~ ~ ~ ~ ~ t..?.,. ~ ~ ~O ~~ =(J ~~ u ~ ~ 0'\ o o N o 00 -.:t 0\'" I 00 00 00'" ~ NM o M C"f) \0 \0'" 00'" I -.::t 0 \0 C'l I./') N oq- 00 MOl./') N N N \0 C"f) 0 t'-- -.:t... C"f)... I./') """ """... ~ \0 00 0'\ ....; 0'" ......t 1./')'" 0'" N N t'-- I./') 0 I./') 00 0... ......t oq- C"f) -.:t -.-( M ......t t'-- ... 0'\'" M E;;9 00 o o N 1./')001./')00 """000'\00 :;:... ~... ~~... I I:"'--N......cl./') O\No;.M t'-- ... .....c ~ OM""" I./') C'f') 0 0 \0 C'f') \0 C'f') 0\ 00 00 ~... ~... :... ~... ~...~... ~... o M 0 C"f) oq- ......t 0 M C'f') 00 """ I./') ......t ......t ~... -.-(.........t... 1./')'" N E;;9 I:"'-- o o N o 1./')00 t"-- 0\ M......c I./') M"""N\O -.-(... C"I1'" -.::i' 0\'" I o 00 .q- 00 t'-- \0 M ('f) \0'" -.-(... -.-( \0 t"-- ......t -.-( \0 0 -.-( ~ N \0 \0 I./') 0 -.-( """ C'f')... C'f')... ('f)... t'--... t"-- I./') 1./')'" 0 """ oq- 1.11 r-: \0'" \0 0\ N C'f') 0 """ 0'\ ""'i M" t"--......t M ......t ......t C"f)'" N E;;9 \0 o o N 1.11 ......t 1.11 0 """ -.-( \0 \0 ~...~...~...~... I o """C"f) 00 t"--V10'\""" ~... ....; I./') oq- -.-( 0\ [--. 0 [--. 0\ 0\ \0 0 M C'f') 0'\ '0 C"f) C'f') """ \0 [--. 0 -.-(... ('f)'" -.:t'" '0'" \0'" C'f')'" 00'" """ [--. 0 0\ 00 [--. 00 -.-( 0\ C'f') 0 -.-(... M'" M ~ 1.11 o o M O\OO'\~ -.-( 0'\ M ~ ~... ~...~... ~ I [--.t"--I./')\O M C'l C"f)... C'f') oq-'" .....c -.-( 0'\ M 0 C'f') '" N ......c M......t[--.O\ooO """ ~~,,~~...~...~ ~J -.-( -.:t """ \0 0 00 M 1.11 0\ """ -.-( 1.11 -.-( 0 0'\'" .....c ~ ~ 11 (I) l:I:: f;I:) lr)O\M~ """~-.-([--. ('f) C'f') 1.11 ~ 00'" \0'" 1.11'" t'--... I M'I""'"lOt"-- """""""l\l') M'" -.-( -.-( \OM\OONoo -.-( N 1.11 -.-( "=t oq- 0\ M 0\ -.:t MOO -.-( C'f') 0'" M'" [--.... 00'" [--.... M'" 1.11'" MV1-.-(NO\O\ """ I./') 0\ M M [--. 00 00'" -.-( """ o o M e;o; C"f) o o N 0\ """ ('f') N 1.11 \I') \0 00 0\ t'-- 00 f::~gg~ ~$~~~cid~ \0'" t---'" ~ 0'" · 0\'" '0'" 00'" "",,'" [--.... \0'" C'f')'" O\t---O\O O~\OOOO\ 0 lrl M M lrl 0\ """ lrl [--. C"f)... N'" t--- ~ -.-( EA- N o o M ooM\ONO\Olr)-.-(Moo"""t'-- -.-(OM[--.O\O\~"""\OV1\O """ -.:t... lrl -.:t 00 0 lrl I./') 0 0\ C'f')... lrl C'f')... \0 "",,'" C'f')'" 0'" 1.11'" "",,'" "",,'" \0'" t---'" \0 "",,'" oq- 0\ C'f') -.-( [--. -.-( C'f') \0 """ 0 0 l.() oq- MC'f')O\M\Olrl"""t----.-(Nl.()0 M ~ ~ -.-( GI'7 -.-( o o N lrl [--. t.r) lrl 0 0\ ~ M [--. [--. 00 t'- -.-( C'f') l.() l.() M M 0\ 1.11 C'f') 0 [--. 0\ O\\ON~oo"""O\MO\OooO 0'" \0'" 1./')'" N'" ~ t'-- ... .....c... 0\'" [--.... "",,'" lr)'" \1')'" t"--NI./')C'f')O\I./')-.-(\O......cOOt'--O\ ~C'f')ooNl/')I/')M"""M......cMM -.-( ~ ~ -.-( -.-( e;o; o o o N t---MC'f')-.-(I./')O\l./')o\t'--""" 00 0 M"""\Ot'--oq-\O\Ooooo('f)\O\O ~... ~... ~ 6;;'" ~... ~... ~... ~... ~... ~... ~... :-- -.-(\O\OMo\[--.M-.-(\Ot'-\OO\ \0 lrl ......t M M I/') \I') .q- -.-( -.-( l.() M... O.....c... -.-(... \0 .....c .....c GI'7 ~ Gf.I ~ "s J! o~~~ Gf.IB ~ ~ 1 ~ ~"E ~ ~ ~~e~5~ e ~ e 00 ~r.e BccE ~s e ~ "'::J ~ 4) (I)..."!:! Q) "d tj:j ~ ~ ~ ~ Z Gf.I ~~] ~~ ~~ Sh".8= ~ ~ ~ i 8 oa o~ 8 ~ ~ !i ~ "~ ~~~~C5Q~O~~Q::E 00'0 00 \0 N\OC'f')\O""" .....coo-.-([--.MMo\Ot--- N [--. -.-( l./') M '0 00 00 t--- 0\ ......( 0'" 00'" 00'" [--.... -.-(... 0\'" 0\'" MM"""ool./')-.-(O\"""1./') \OI./')OOl./')O"'N"""t'-- N'" ..; C"f)'" "",,'" ('f)'" -.-(... N'" 0\\01./') \0 """t'--O\\O \0 "'\0 t'--l./')-.-(MI./') M00 \0 I./') I./') 0 I./') 0 0 \0 M ~"'~"'~"'~"'~~"'~r~"'~'" to """ [--. C"f) -.-( \0... M """ .....c "r -.-(... ('f)'" "",,'" ('f)'" .....c '0'" ~~~~~~~~~ ~...~...~~...~...~~...~~... "",,\O-.-(\O.....cool./')-.-(C"f) N """...l./') 0\ 0\ """...N """ M M'" .....c M'" M'" M'" -.-( \0'" oo.....c""""""[--.'Ot'--oq--.-( 0\ lrl I./') lI') M N M """ "=t ~...~...~:...~...:...~...~:... o \0 l/') l/') M 0 [--. [--. 0\ .....cN\Ol./')oo\ONM'oo::t N'" .-c'" M'" ('f)'" M'" -.-(... "",,'" -.-( MOO .....c t--- I./') ('f') 0 g~~~~...~~~~ M'" 0'" \0" M 00 \0" 00'" [--.... 0\ t'--\O\OO\ool/')('f')l./')1./') 00 .-c -.-( N ('f) \0... N C'f') """ ....; .....j ('f)'" C'f')'" N'" -.-( -.-('" O\I./')O\O\MOt'--O'\.....c -.-(oq-t'--\OMMO\.....c""" ~"'~~"'~"'~"'~"'d-~"'~'" """ 00 I./') N 00 M l/') lI') ('f) """ N 0 .....c oq- """ M ("f) 0\ N'" ..-4'" M'" M'" N'" ....;' -.-(... l./') \0 00 ....... 00 M 0 '0 M ~...g M...~ ~...g...~ ~ g 0\ "",,'" \0 -.-( ... N N -.::i' "r 0'" \0 [--. N ('f) \0 0\ C'f') \0 M """ M 00 ('f) NON -.-( """ -.-(... -.-(... ('l'" ('f)'" ('l'" -.-('" [--.... """t'--ooOooO\O'oo::tM t'-- t'-- \0 t'-- 0\ 0\ 1.11 .....c 0\ \0 00 0\ 00 I./') 0 0 00 00 tr)'" \0'" M'" -.-(... lr)'" ",'" 0'" ('l'" \0'" ('l M 00 -.-( \0 ('f) I./') 00 """ 0\ M [--. [--. \0 M -.-( -.-( \0... -.-(... -.-(... M \0'" .......'" -.-('" .....c MooMNOMO\O\N t'-- I./') N .....c I./') 0\ .....c """ [--. M... t'-- N \0 00 0 MOM \0 1./')'" N'" r--f 1./')'" 00'" 00 v) M'" M M l./') N ('l 0 ..-4 M I./') 0\ M 00 ..-4 \0 """ .....c -.-( 0 ....-I... ..-4'" N'" "",,'" -.-('" -.-('" -.-(... -.-( 1.11 \0 1.11 """ -.-( 1.11 0 N .....c 0 \0 .....c N 1.11 t'-- N -.-( o """ 0\ 0\ \0 \I') M \I') M N'" 0\ [--.... 1:"'--'" lr)'" 00'" 1.11'" N'" "",,'" ('f') N 0 0\ """ -.-( 0 ('f') \0 o N... ('f')", \I') 0 \0... .....c -.-( 0\ M ..-4 N N'" .....j -.-( M'" ~ ~~ 00 fi 8 ~I~ E-I 0 p. S~~ ~ ~ ~ ~ Q) 0 ~C)u ~ 00 M 0\ """ \I') M -.-( I./') t'--... M'" \1')'" l./') M t'-- 00 o N ("f) -.-(... M "",,'" M o 00 \0 0\ 0\ .....c t--- t--- 0 "",,'" 0\'" 0'" 00 00 ('f) lI') -i \0 M........c \0'" M ....... .q- -.-( o 0 I./') o N -.:t "",,'" lr)'" ",'" '" 0 '" 0... 0 \0 -.-( N'" \1')'" M [--. t'-- l./') -.-( """ 0 00 0 00 -.-(... 0\'" 0'" """ ('l """ -.-( 0\ M -.-(... -.-(... ~r \0 00 M \0 0 [--. 00 M t'-- ",'" M'" t'--'" 00 [--. l() M I./') oq- -.-('" -.-(... 00'" .....c M ('f') t'-- 0\ M M \I') \0 0 t'-- '" [--.... M t'-- -.-( \0 N \0 M -.-('" -.-(... ~... -.-( 0\ -.-( 0\ -.-( \0 0 M I./') \0 ~... 010'" t'--'" \0 ("I') 00 \0 """ -.-( -.-('" -.-(... M'" N 010 0\ [--. [--. \0 00 [--. \0 ~ t'-... "",,'" l()'" o 0 """ ~'" :2 ~'" N 0\ ...-.( [--. o '0 0 \0 -.-( M M'" M'" M'" """ I./') t'-- 010 """ 00 -.-('" -.-(... [--.... -.-( l./') 0 'll::t 010 0 \0 [--. 00 M M'" "",,'" C"'&'" \0 0 0 0\ 00 00 -.-(... \0'" -.-( 8 ~~ t 8 "~ ~ "E .a 8 8 ~ ~ ~ ~ e ~ "~j ::s ~ "S = 3~~~ ~ >-a ~ ~ ~ ~ 8 4,) 5 "~ ~ ~ '3 '3 ~ e "~ ~ "~~ ~ ~ u ~ ~ ~ = .$ ...... = = CJ "-'" N ~ ~ ~ ~ 00 ~ ~ ~ ~ ~ ~ ~ o u ~ o ~ ~ u ~ ~ ~ ~~ ~~ ~s ~~ =~~~~ = -< Q,) -< .~ z~=u~ QZ~~~ ~r-l=~--.. 7:~QZ~ ~ ~r-l ~ ~~ ~~ t..?;>- E-l~ ~o rJ'1~ =~ j~ u ~ ~ ;; ~ ] ii: 0\ o o C'I 00 o o N t'""- O o C'I \0 o o C'I tn o o M 'O::f' o o N ('f') o o C'I N o o N ~ o o M o o o C'I CI) ~ ~~~ ~~S ~~t= O'-'~ ~ ~ ~ ~ 0 ~ ~ \0 M 0\ "<:t'~ 0\ 00 "<:t'~ EA \0 M \0 N~ N 1II 1"""'l~ EA o .q- 0\ N~ 1II "<:t' N~ EA 00 o t'""- N~ \0 1"""'l ....; EA 00 \0 1II O~ t'""- 1II EA \0 1"""'l t'""- ~ 1"""'l .q- EA 1"""'l \0 C"l "<:t'~ 00 00 1II~ EA o "<:t' 0\ O~ o 00 M~ EA o 1"""'l N t'""-~ t'""- "l 1"""'l EA "<:t' e 1"""'l~ 1"""'l "<:t' EA 0\ lIi t'""-~ I ('t1 M \0 0\ t' t' t'- 0\ oo~ 'O::f'~ ('I") 1"""'1 ('t1 1II N~ 1"""'l~ o 00 lIi \0 -t -t \O~ oo~ I t' 0\ 1"""'1 ~ lIj o \0 -t -t C'I~ O~ 00 -.:t' o C'I N~ -t~ o o o O~ 0\ 00 O\~ ..-.. o ~ "l::t 0\ OMlIj \0 00 M -t 0 OO~ -t~ t'""-~ M~ C'lMt'""- 0\ \0 0\ -.:t'~ -t~ \0 0 1"""'1 ~ -t t'""- \0 0 ~~~ll ~~ ~~ o lIj 0 t'""- "l::t-t N \O~ N~ ~ o t'""- O 00 ~~ I ;- I t'""- 0\ 1II O\~ ..-.. \0 q- -t o tr) \0 ~~~~~ lIit'--t "l::t \0 N ('-..~ ...: .....: -t lIj \0 0\ C'I OO~ tr)~ -t -t "'d- 1"""'1 \0 -t~ ...-.. o ...... 1"""'1 o ~ lIi o -t 0 O~ \O~ oo~ o \0 0 \0 ('-..~ ('-.. ~ o o ~~ I o o M~ 00 ('I") \0 M 0\ M~ N~ "l::t 0\ "l::t O~ \0 ...... 000 o 0 tn ~~~~:~ I o ('-.. N \O~ "l::t ........ 1"""'l O~ ........ ...-.. o l/') 0\ \0 ('f') lIi M 0\ \O~ -t~ OO~ tr) 0\ 1"""'1 0 o -t~ \0 O~ ........ ......c N N ('-.. 1II~ I 00 "<:t' N~ 0\ ('f') \0 \0 ('-.. ('-.. \O~ ~ t'-- N 00 "'d- c.tl $ ~~.g ~I ~ ~ ~ ~ ~ ~ ~ E .S Zoo~~~J~$rn ~ f;lol .~ :..!::I ~'V C) i:l ~ ~ U --0 ~ "::1 C+-lo i1) c.g ~~]~~'aQ)~~ =O~~ZU~~~ E-coo o ~ '6 J1 lU .e, ~o do Q) ~ ~ ~ ~ a ~ H \0 l() l() t'--~ 1II 00 "l::t lIj N \O~ 1"""'1 .,...( ~ -t tn l.() -t~ q- \0 l()~ M "l::t M~ M 0\ O~ ~ "l::t t' 0\ t---~ t--- \0 N~ \0 \0 M ~ ('-.. "l::t o \0 o oo~ tn "l::t l() ('I") \0 oo~ -.:t' -.:t' ('f')~ \0 \0 t'--"' \0 -t \0 C'I~ 00 C'I t' C'I~ ('f') O\~ N 00 z ~ ~ u ~ ~ ~ ~ u ~ ~ ~ z C'I 0\ q- N~ l() t' l()~ ~ N 00 M \O~ o q- Vi ........ ....... \0 oo~ 00 -t ('f')~ Vi tn \0 ('f') O\~ \0 EI7 C'I 'O::f' l() oo~ "l::t N ('f') "' vt o lIj \0 lIj~ lIj vt -t o C'I~ \0 C'I 'O::f' tn~ Vi l() o ('t1 M~ l() ('f') vt \0 lIj lIj O\~ M o -t~ vt 'II:t C'I \O~ -t N lIj N~ vt ~~~~ ~~~~ ~~~Q ~~oz E-c~zt: ~~~~ ~<O~ A #. ('f') vi .,...( '$. \0 ~ -t #. o \Q -t "$. -.:t' \0 .,...( "$. 00 \Q -t #. t--- \0 ,....( M 0\ '$. ('-.. 0\ ........ 00 I-l Q) P-4 o i ~ J '"d ~ '8 Q) 1-1 00 ~ Q) Cf.l 00 cj ta ~ .~ '"d ~ .,D .~ = 8 ~ ::s "0 .S '0 $:l 00 Q) .g 3 "S o t; ~ .~ u Q) ~ o Z "$. M ~ -t '$. \0 0\ ~ #. o o N l() ~ ~ VJ. ~ ~ ~ ~ ~ ~ ~ o u ~ o ~ I--l U ~ ~ ~ ~ ~ r-l ~ ~ o ~ ~ ~ ~ ~ ~ u S -< Z = r-l r-l ~ ~ ~ E-4 ~ tfJ r-l ~ r-l ~ ~ = r-l tIj tIj r-l rI:J Vl -< ~~~Q.) ~S~= .~~ ~~ ~ Eo-<< Q.) 3~~ 0":= >< Eo-<<Oe':S Eo-<< Q.) ......-l ~~ ~ tI) Q.) 10'1 00 ~ Eo-<< Q.) e'tS 00> ~< Eo-<< ....- ~ U:i (1.) a3 ~ 0 ~~~ Eo-<< ~ 8 b ~ 0 ~~ ~ ".Jj 5 Cl) "0 0 ~lt ~ ~ ~~ ~ 0\ -.::t.... .......t 00 \0 0\.... N t"'.... .......t t"' ~ \0 \Or. 00 00 1""""1 1""-4 0\ ~r. l.(") l.(") .q- C'f 0\ r--... Mr. C"} ,.....( C'r l.(") ~ \0 -.::tr. M o r--...r. \0 M C"}.... Gq ~ ..q- -.::t -.::t ~ r--... r--.. r--.. r--.. (""--. ~ ..q- ..q- ~ ..q- ('f") ('f') M ('f") M 00000 Gq ~ t"' l.() l.(") l.(") 0\ ~ l.(") -.::t N -.:::t.... \0 -.:::t \0 \0.... 1""""1 \Or. C"}r. ~r. ~ 00 00 0\ ('f") 00 \0 00 t"- 0 ~ O\r. ~ ('f")r. t"-.... 0.... N ~ N \0 00 I:'-r. O\r. ,.....( M l.(") ~ ~ C'f C'f C'f Gq 00 00 0\ \0 ""'" l(') N \0 r--.. r--.. ~ ~ l.(") ..q- N N.... N r. "'f::tr. l.()r. "'f::tr. M 00 0 0\ r--.. \0 M M ,.....( r--.. O\r. \Or. c,f \0.... 0\.... ""d- ~ 0\ 0\ ,.....( I""""'l ~ ,.....( ,.....( N Gq N l.(") r--... 0\ (""--. MOM l.(") t"- -.:::t t"- l.(") 0\ N Nr. ('f')r. t"- r. 0\ l(')r. o \0 "'=t' 0\ "'=t' 00 \0 ""'" l() 00 ~r. 00 r. or. Nr. ('f")r. I:'- I:'- 00 00 ["'--. Gq o 0 t"- N N N r--.. 00 \0 N C'i 0 ~ """'" \0 ,.....( l.(").... O\r. 0.... 0 .......r 0 ~ M .......r l() \0 \0 \0 .q- "'=t'r. O\r. l.(")r. 0.... \0.... o ["'--. MOON 00 O\r. N .q- r--.. .......r 1""""1 N.... Nr. Nr. ~ o ,.....( N ('f") ""'" 000 a a 000 a a N N N N N l(') N \Or. 1""-4 00 ~ or. 00 l.(") C'f l.(") \0 00 \Or. 0\ l.(") N.... l() \0 c,r -q- r--.. -q- M o l.(") \0 00 \0.... 0\ l() C'f l.(") \0 C'f .......r 00 M ~.... \0 N 0\.... 1""-4 N ('f") ~ o l().... l(') N oor. ["'--. M o N \Or. a \0 Mr. 0\ r--.. C"-f l.(") l.(") 00 Nr. ~ N ('f") r. r--.. 00 Nr. ~ r--.. ""'" ('f") o l.(") l.(") 00 ~r. N M.... ["'--. 00 N.... .......r N l(') O\r. o 00 .......r N N N o r--.. C'f N .......r O\r. t"' ~ r--.. \0 0\.... N 0\ l.(")r. .......r o ('f")r. \0 00 l.(") oor. .......r ('f") r--..r. 00 o ('f")r. ~ ["'--. ~ M o \0 00 l.(") oor. .......r M r--..r. 00 o ("fir. .......r 0\ ["'--. l.(")r. I""""'l .......r 00.... N N 00 .......r 0\ or. 00 o \0.... 00 0\ l.(") ~ Mr. l() ("fi O\r. N N ("fir. ('f') 0\ r--.. .......r t"- o.... .......r o ~ ('f').... 0\ N ~ r--...... -q- 00 r--... r. .......r \0 Mr. 0\ l.() l.(") M o 0\ l() l.(") ("fi o M 0\ t"-r. .......r t'- Or. .......r o ~ ('f") .... 0\ N ~ r--...... ~ 00 r--...... .......r \0 ('f')r. \0 00 ~ l().... .......r 0\ ot:r N N l.(") 0\ 0\ \Or. t'- \0 or. M N M 00 N 00.... 0\ 0\ r--...r. 0\ ,.....( .......r .......r \Or. l.() l.(") O\r. 0\ \0 0\ 0\ oor. 00 0\.... ,.....( M l.(") ('f')r. M .......r ('f') 00.... \0 0\ oor. ~ ["'--. ('f')r. l.(") o o N \0 t"- 00 0\ o 0 0 0 o 0 0 0 N N N N "0 ~ ~ ".Jj 5 "0 "~ ijj """ """ c.S Q.) ~ ~ ~ t C'\S ~ o "S (1.) (.) b ~ o o .......r ~ o b ~ ~ CI:l Q.) CI:l Ul Q.) CI:l CI:l c'd: "0 .~ Q ~ Ul "Cd ~ ~ (j) ~ Eo-<< ~ C\ "0 "~ J:t CI:l Q ~ U') "Cd ~ ~ i ~ Eo-<< Q.) (,.) ~ tIJ u:i ~ ~ ~ Sa) ~~ Q.) > g~ o [/) ~ ~ ~ ~ ~~ CI:l 0 e':So ~o "~ ~ Cb ~ ~ 8 ~ d ~ Cd ~ ~ ~ " S Eo-<< ~cJ "5 ~ ~~ 8 b ~ ~ Qj "0 Z \C ~ ~ VJ ~ ~ ~ ~ ~ ~ ~ ~ o u ~ o ~ I--l U Vl ~ E ~ r-l =-c ~ ~ tJ ~ ~ ~ ~ ~ ~ u ~ = ~ > ~ tfJ S Z r-l ~ E-i tfJ -< ~ f o S t) u ....c '.a ..... 6r rn ~ ~ Q ro E-c j 001) U ~.E i8lS ro E-c l ! ro 0 E-cU ! ~ .~ ~ ~ o 1) = .S ~1~ ~ ~g ~..g 00 CI.l 1) ~ ~.S ]"S~~ ~ ~ ~ ~ ~ ~ ~g ~ ~~ t) <b ..2 ~ ..a s:l- Q) CI.l .f.~] Q ~~ fg o u s:l ~ ~oo t) .....:a ]~lS ro ~ '0 u ..0 0 ~~ 1) o ~ ..a ~1~ ! !] ~ Q 00 '3 t) .B ~8~ rn .B ~ ~ e ..z:f ;-I 8 ;-I 0 ~t\ ~ .~ Q 1=1 """'I ..... eo...... Q QO~ CfJ p U ~ 8 : ;i .~ ~ ~ ~ .- t~ ] ~I ii:r 000 t"-- t"-- t"-- o 0 0 oo::t oo::t oo::t C'f') C'f') C'f') M N M 000 w o 0 0 .....t .....t .....t oo::t oo::t oo::t \0 \0 \0 o 0 0 .....t .....t .....t o 0 d w oo::t 0'\ 0'\ 00 t"-- t"-- oo::t oo::t oo::t \0 t"-- t"-- N N N d 0 d V7 o t"-- 0'\ V"l M 00 t--. M N oo::t \I') V"l ~ ~ ~ EI7 00 \I') 0 .....t t"-- ("l') ("l') t"-- V"l \0 \0 \0 ,...; .....4 ,...; EA o 0 0'\ ("l') ('t) t"-- N N \0 V"l 00 .....t V"l V"l \0 .....; ,...; .....; EA o 0 0 o V"l 0 0'\ 00 V"l t; 00 0'\ .....t ,...; .....; EA V"l 00 00 M 0'\ 0'\ C'f') \0 \0 lf1 V"l V"l .....t ,...; .....; EA o 0 0 oo::t oo::t oo::t t"-- t"-- t' oo::t oo::t ~ C'f') C'f') C'f') 000 Gi'9 001.0 .....t oo::t 00 o oo::t t' 0'\ 00 t' 000 odd w o 0 oo::t ('t) 0 V"l t' C'f') 0'\ V"l \0 \0 N M N o d 0 V7 o o o N .....t o o M o t"-- o 0'\ o ("l') oo::t V"l ("l') ("l') N N d d o 0 00 00 C'f') ('t) 0'\ 0'\ ('f) ('t) .....t .....t d 0 o 0 tI1 V"l N N t'-- t"-- N M d d 0'\ N .....t \0 V"l t"-- 1.0 \0 .....; .....; 0'\ \0 .....t .....t .....t \0 t"-- ~ .....; .....t 0'\ V"l t"-- 0 0\ .....t V"l 0 ~ t; .....t .....t o V"l tI1 N C'f') 0 0'\ 0'\ .....; .....; o 0 t"-- t"-- .....t .....t \0 \0 ,...; ,...; o 0 "I:t oo::t t' t'-- oo::t oo::t C'f') ("l') o d t'-- 0 .....t oo::t V"l 0 t"-- \0 o 0 d 0 C'f') 0 M 0 M t"-- t'-- 00 M N d d N o o N ("l') o o N oo::t o o M t' 0'\ ("l') V"l ("l') N d o 00 ("l') 0'\ ('f) .....t d o V"l N t'-- N d V"l t"-- 0'\ \0 ,...; V"l ;:: t"-- .....; o o o o t; .....t o tI1 C'f') 0'\ .....; o t' .....t \0 ,...; o oo::t t"-- oo::t C'f') o 00 \0 \0 V"l o d N t' o 0'\ N o l() o o N t"-- 0\ C'f') V"l C'f') M o o 00 C'f') 0'\ ("l') .....t d o V"l M t' N d 00 V"l .....t t' .....; o C'f') N t; .....t o o o o t'-- ....; o l() ("f) 0'\ .....; o t"-- .....t \0 .....; o ~ t'-- oo::t ("l') d 0'\ \0 0\ \0 o d .....t t"-- t"-- t"-- N d \0 o o M t' 0'\ C'f') l() C'f') N d o 00 ("l') 0'\ ('f) .....t d o V"l .....t t"-- N d o 00 o 1.0 .....; \0 t"-- 0\ lf1 .....t o C'f') oo::t t"-- lf1 .....t o l() 0\ t"-- .....; o V"l \0 V"l .....; o oo::t t"-- oo::t ("l') o t' \0 00 \0 o o C'f') t"-- 00 t"-- N d t"-- o o M t' 0'\ ('f) o ("l') M o t"-- 0'\ 00 t'-- N M d o 00 C'f') 0'\ ("f) .....t o o \0 0'\ t"-- ("f) .....t d o V"l 1.0 \0 N o o o o oo::t \0 M oo::t t' V"l C'f') ,...; 0'\ \0 ~ ~ .....t t' C'f') o C'f1 .....t tI1 l() 0'\ N .....( o o o 0'\ C'I .....( o o o 0'\ N ....; o l() \0 oo::t .....4 o t.r) .....t ~ .....t o V"l o ~ .....t o o .....t oo::t ,...; o 0'\ V"l V"l C'f') o o 0'\ V"l V"l C'f') o .....c 0'\ N t'-- o d .....t C'f') t"-- \0 o d 0'\ 0'\ N 00 N o o \0 00 00 M d 00 o o N 0'\ o o N "0 .B 00 Q ca 00 .~ ~ ~ ~ ~ - ~- ca t 0 o <l) ..8 ~ 0... 0 ~ 8 00 ~ ~~ ~~.;3 ~U] S ~ .~ e.o 0 ~ ,S ~ ~ 0.. _ ~ ~0..C,) ~ ~.Q ~ ~ .~ o d ~ "0 ~ t .;::: ~ <l) 1;j ~ ~ ;at'a o <l) <l) o ~ ~ ] ~~ ~ ~ 00 ~ 11 rJ ~ t' ~~~ ~ ~ 8 r. 0 0.. ~ ~ ~ ~ ~ "~ :>- r. U <l) <l) 4-. - - 0 o ~ Cf.l U ; ""d 4-. X . !:l o Q) -:S ~ ~ 6 u~~ ] ~^ .Q jii.~ ~ :.a 5 .~ 0 ~ ~ ..8 0.. Q) 0 ~ ~i~ o <l) -.- t'~E <l) <l) ~ 0.. 0... ~ o <l) 0 ~"'O o .S .Q ~ -= 0... ..Qe~ ~~ ~ tIj ".-4 d d "'0 ~ o:S ~ :0 00 ~ ;::: t= >.~ 8~O e ~ g ~ ~ ~ ~~rn ~.~ d ~ E~ 8 U ~ ]~~ (lj <l) ~ 'd ~ Q .-! ~ o ~.~ . C <l) ~ ~ o .,J:J <l) " S ~ ~ :::l 4j ~~C;~ <l) 0 ~ ] ~ ~"~ Q 00 t <l) :E <l) ~ ~ ~ e8-~~ e.o 0.. U 0 .S ~ ] ~ 0.. - ~ ~"~ ~r. ~ ]~ <l).B o 8 ~ ~ l() C\ ~ rn 00 <l) ~ TABLE 7 CITY OF COLLEYVILLE, TEXAS PRINCIPAL PROPERTY TAXPAYERS CURRENT YEAR AND NINE YEARS AGO 2009 2000 Percentage Percentage of Total City of Total City Taxable Taxable Taxable Taxable Assessed Assessed Assessed Assessed Taxpayer Value Value Value Value Melvin & Matrindale $ 25,806,252 0.71% $ - % TXU Electric Delivery 17,858,176 0.49% 13,513,653 0.79% Lifetime Fitness Real Estate 12,275,000 0.34% - % Colleyville Plaza 6,508,174 0.18% - % Keith & Missy Hutton 6,283,500 0.17% G Points SC Ltd. 6,042,358 0.17% - % American National Bank of Texas 5,880,738 0.16% RP25 Development LP 5,801,685 0.16% - % Uhlman Colleyville, LLC 5,558,425 0.15% - % Village Management 5,198,100 0.14% - % Albertsons - % 11,670,707 0.68% Colleyville Glade Corporation - % 6,715,225 0.39% Patsy Smith - % 4,473,545 0.26% Colleyville Development Corporation - % 4,348,454 0.25% ASG Colleyville Park, Ltd. - % 3,705,591 0.22% Payless Cashways - % 3,653,709 0.21% K-Mart Corp - % 3,315,073 0.19% Greenway Glade Partners LP - % 3,214,487 0.19% Southwestern Bell - % 3,191,560 0.19% Total $ 97,212,408 2.67% $ 57,802,004 3.37% Source: Tarrant Appraisal District 96 TABLE 8 CITY OF COLLEYVILLE, TEXAS PROPERTY TAX LEVIES AND COLLECTIONS LAST TEN FISCAL YEARS Collected With the Taxes Levied Fiscal Year of the Levy Collections Total Collections to Date Fiscal for the Percentage in Subsequent Percentage Year Ended Fiscal Year Amount of Levy Years Amount of Levy 2000 $ 6,008,914 $ 5,948,825 98.9% $ 56,443 $ 6,005,268 99.94% 2001 6,664,042 6,597,402 98.8% 63,112 6,660,514 99.95% 2002 7,399,976 7,325,976 98.3% 66,174 7,392,150 99.89% 2003 8,233,543 8,151,208 98.8% 78,652 8,229,860 99.96% 2004 8,719,444 8,632,250 99.2% 83,647 8,715,897 99.96% 2005 9,201,770 9,109,752 99.1 % 86,710 9,196,462 99.94% 2006 9,981,646 9,906,769 99.2% 68,583 9,975,352 99.94% 2007 10,725,345 10,592,222 98.8% 123,055 10,715,277 99.91% 2008 12,024,882 11,903,333 99.0% 91,070 11,994,403 99.75% 2009 12,875,919 12,734,871 98.9% 12,734,871 98.90% Sources: Tarrant Cowty Appraisal District and City of Colleyville Finance Department. 97 TABLE 9 CITY OF COLLEYVILLE, TEXAS PRINCIPAL WATER CUSTOMERS CURRENT YEAR AND NINE YEARS AGO 2009 2000 Percentage Percentage of Total City of Total City Water Water Water Water Usage Usage Usage Usage Taxpayer Grapevine-Colleyville ISD 38,616,200 1.61 % 43,259,600 2.06% Town Center 12,114,500 0.50% - % Lifetime Fitness 10,932,900 0.46% - % Market Street 8,393,800 0.35% - % Bluebonnet Hills 5,935,000 0.25% - % Burk Collins - % 4,797,300 0.23% Shadowood Trail 4,671,900 0.19% 5,807,100 0.28% Remington Park - % 4,500,300 0.21% Walgreens - % 3,948,100 0.19% Woodland Hills 3,886,400 0.16% 5,454,100 0.26% La Hacienda Ranch 3,883,800 0.16% 3,925,900 0.19% Rio Mambo 3,526,200 0.15% - % Albertsons 3,244,400 0.14% 4,821,.500 0.23% Highland Meadows HOA 3,055,400 0.13% - % Colleyville Glade 2,922,000 0.12% - % Timarron 2,821,800 0.12% - % Wash Depot 2,815,800 0.12% 4,285,400 0.20% Covenant Christian Academy 2,534,600 0.11 % 5,482,100 0.26% Colonial Bank 2,486,100 0.10% - % Total 111,840,800 4.66% 86,281,400 4.11% Source: City utility billing records 98 o ....-I ~ ~ V1 ~ ~ ~ ~ ~ ~ o u ~ o ~ I--l U r-l ~ ~ ;; E-l = r-l = ~ ~ rIJ E-4 ~ o ~ o rIJ o 1-1I[ ~ ~ ~ ~ ~ r.n S Z ~ ~ CI'J j C'l3 b :~ ~ ~ U Q)';! ~ = Q.) "S ~ ~ (j) b (,.) (.) ~ d b ~ ~r.s ~ ';j~5 'O.~ ~ Eo-<< '-I >- ~ 0 o ~ ~ "~ CI:l ~~ u~ ~ ".0 : e (j) Q.) ~ ~ 8 ~ (j) "~ ~ E3 $o~~ I CI:l CI:l CD "S CI:l ~ b ~ r.f) Q.) "O8~ ~ ~ 8 b~~ ~ ~ "; ~ "~ tI) ~~ u~ CI:l Q.) ".Jj "~ ".0 ~ Q,) ~Eo-<<8~ ';! ~ CD ~ ~~6)~ Cl)(/)~ ~ ~ o 8 ~"~ CI:l ~~"O Cl) bJ) = 5"~ 0 o:OCQ o ~ ~ ~ Q) i:E:> 'I""""I(""--.r--..('f')~OOONOOOO ('i')0C"\t0\('f')0\~00~00 '1""""1 '1""""1 .......r 0\.... 00.... r--...r. \Or. \0.... 1Il Mr. ("f Nr. C"\tr. .......r .......r .......r .....-I 1""""4 .......r .......r (I} ~'$.'$.'$.'(f:.'(f:.'(f:.';f..'$.'$. O\.......rN1""-4('f') 00\Cl O\l()('.\ "l:tMNOO~NO\OO\Ol(') ~-.e:t~('f')('f')('f')NNNN ~NC"\tNN~OO.....-ll.(")\O ~NNC"\tN\ONO\\Cl\O l' (""--. r--.. t"- r--... N ('f') t'- ~r. ('f') ('f)r. Nr. or. N.... t'- r. 0.... \0.... 0\ r. 1""""4 ~r. C"l OOM\O 00 \000"","00 0\ O\r. Or. N 1""""1 l.(") t'- l() N M C'i o 1""""4 N.... 0.... t'- r. t'-r. ltjr. r--..r. "'=t'r. .......r "l:t~..q--q-M('f')M('f')('f')('f') (I} r--..MO r--..('f')~ o 0\ ,....,( 1""-4 \Or. ('f').... I "t::tN.......r Gt} 0000000000 0000000000 0000000000 or. l.(")r. 0.... 0.... 0.... l()r. l()r. l().... or. or. o N..q-O \0.....-1\0 0 "'=t'["'--. C'flOO\OO\Ol.(")('f')NOOO .,....( ('f')r. Nr. N.... N.... ~.... ~r. N.... Nr. .......rr. (I} 0000000000 0000000000 0000000000 \Or. or. ('f')r. l().... l()r. or. l.()r. 0.... 0.... 0.... \OOOON\O\Cl~~O \O.....-Itr)\OO\I""""4('f')l(')OON or. or. 0\ 0\.... O(f 00.... ["'--..... \Or. l()r. l(').... .,....( 1""-4 G<q t"-l.() 0\ 0"\\0 ooO\oo"t::to\ 1""""4 ('f').....-Il(')O\ 0\.... .q-.... O\r. or. O\r. \OO~Ml(') ~M~('f') G<q C"lNNNNOON\OO C"lNNNNOO\o,....,(t"- l'I:'--I:'--I:'--I:'--OO~C\('tj l'r. Nr. N.... r--...... ["'--.r. 0.... or. Nr. l.()r. 0\ \Ooot'-("I')t"'OO\OI:'--O\O\ ~O\~O\OO\["'--.Mt'-,.....( ltjr. ~r. ~.... ('f').... ('f')r. ~r. ~.... or. 0\ r. 0\.... 'I""""I.......r1""""l1""""4.......r.......r.....-l1""""4 G<q 0000000000 0000000000 0000000000 or. l.(")r. tr).... 0.... l.()r. l.(") r. l()r. 0.... ltjr. l.(")r. O\t'-.......rNNO\\Or--..r--..\O "l:t 0\ ("f") 00 0\ 0\ \0 r--...... N \0 ('f)r. C"'f l.(").... ("1').... Nr. 1""""4r. or. r--.. \Or. "f!!:t'r. 'I""""I.......r'l""""l.......r.......r.......r.......rI""""4I""""4.......r G<q O.......r('.lM'Vl.(")\Ot'-OOo\ 0000000000 0000000000 C"lNNNNNNNNN r.ri 1$ 8 lU td ~ r.n ~ " T'""l ~ ~ ~ ~ o ~ r.n o 8 ~ ~ .S "'0 ~ ~ lU ,.c ~ u ........ ~ "'0 I ~ ........ ~ r.n b "1'""4 U o ~ I td ~ t-I rJ) .,......c " 1'""4 cd ....... lU o C\ C\ ~ ~ 6 ".Jj cd '"S ~ ~ "'0 ~ S o u "$ Cd 6 r.n &j ~ ~ ~ ~ ~ o .......-I ~ E-c lU lU tI) CI) o o z TABLE 11 CITY OF COLLEYVILLE, TEXAS RATIOS OF NET GENERAL BONDED DEBT OUTSTANDING LAST TEN FISCAL YEARS General Bonded Debt Outstanding Percentage of General Less Amounts Actual Taxable Fiscal Obligation Restricted to Value of Per Year Bonds Repaying Principal Total Property Capita 2000 $ 13,490,000 $ 756,106 $ 12,733,894 0.74% $ 663 2001 12,975,000 863,320 12,111,680 0.63% 621 2002 15,315,000 962,363 14,352,637 0.68% 723 2003 13,820,000 1,025,530 12,794,470 0.54% 635 2004 12,925,000 995,889 11,929,111 0.46% 582 2005 11,955,000 989,618 10,965,382 0.41 % 522 2006 10,665,000 1,082,681 9,582,319 0.33% 442 2007 17,770,000 1,254,686 16,515,314 0.53% 746 2008 16,275,000 987,681 15,287,319 0.50% 679 2009 14,665,000 1,121,567 13,543,433 0.44% 601 Notes: Details regarding the City's outstanding debt can be fOlUld in the notes to the financial statements. See Table 5 for property value data. Population data can be fOlUld in Table 14. 100 TABLE 12 CITY OF COLLEYVILLE, TEXAS DIRECT AND OVERLAPPING GOVERNMENTAL ACTIVITIES DEBT AS OF SEPTEMBER 30, 2009 Estimated Share of Estimated Direct and Debt Percentage Overlapping Government Unit Outstandin~ Applicable Debt Debt repaid with property taxes Birdville Independent School District $ 255,639,101 0.080% $ 204,511 Carroll Independent School District 194,305,512 0.450% 874,375 Grapevine-Colleyville Independent School District 279,155,892 20.790% 58,036,510 Hurst-Euless-Bedford Independent School District 212,152,032 1.560% 3,309,572 Keller Independent School District 735,369,466 2.810% 20,663,882 Tarrant County 322,210,000 2.970% 9,569,637 Tarrant County College District 28,810,000 2.970% 855,657 Tarrant County Hospital District 42,785,000 2.970% 1,270,715 Subtotal overlapping debt 94,784,858 City direct debt 14,665,000 100.000% 14,665,000 Total direct and overlapping debt $ 109,449,858 SOlU'ces: Assessed value data used to estimate applicable percentages provided by the Tarrant County Appraisal District and debt outstanding data provided by each governmental unit. 101 (f; ..... ~ ~ VJ ~ ~ ~ ~ ~ ~ o u ~ o ~ l--( u z o I--l E-I ~ ~ o r-l ~ ~ ~ ~ ~ tfJ ~ i E-I ~ tfJ :S ~ == ~ ~ ~ r-1 ~ .....t t"-- 0\ t"-- o 0'\ 0\ V"l.... C'f') V"l N ['.. ~.... ~.... V"l C"f).... o o o V"l.... \0 \0 oo::t.... .....t EA 0'\ o o N ~ o ~ ] ii: 5-c <S d o ..z:f ~ 5 td U ~ .~ ~ ~ ~ Q i ~ ...-... ~ i 5-c "'C CI) <S ~ ] ~ e ~ 0 .~ ~ ~.._~-~~~ ~ ..g~~ "$,3 ~~d V"l 0 ;.:: 6 ~ ~j,~.ge~ ~.~~]~~ ]~~~~~ ~;-I;-IO~ ~ ~ ~ ~QQ r:--- C'f') \0 ('t) Ii). oo::t ....-( M N oo::t ....-( V"l .....t"' ~"' j 3 o ~ i Cd ~ ~ ~ ~ S ..r;j ~ .~ =8 oo::t "'=t V"l M"' .....t M oo::t "' t"-- V7 d .5b ~ ~ ~ ~ V"l o o ~ N ~ ] rn p:: 0'\ o o N 00 o o N ['.. o o N \0 o o M oo::t o o N C"f) o o M M o o N .....t o o M o o o M oo:t oo::t 1I1 N.... .....t N ~ r:--- &9 V"l 0\ ['.. \0"' N o 1I1"' 00 V7 V"l \C 0'\ N.... 00 .....t ['.."' t'-- &9 .....t t"-- 0", .....t C'f') 00 .....i t"-- EF.t N N 0\ oo::t"' .....t C'f')", \0 \0 EA .....t oo::t o ~r V"l oo::t .... \0 EA \C \0 00 V"l.... t"-- .....t 0'\"' V"l &9 \0 00 00 oo::t"' 0'\ o C'f') "' tt') EA \0 \0 .....t t"-- "' 0'\ t"-- t'"' oo::t EA t"-- ("I') o N.... oo::t C'l C'f') "' oo::t EF.t j ;-I ~ Q C'f') C"f) oo::t C'f') "' oo::t V"l ("1')"' .....t 0'\ ("I') .....t r---"' 00 M V"l"' .....t N ("I') .....t V"l"' oo::t t' v1' .....t 0'\ .....t ("1')", N 00 V"l 0\ o o o V"l"' 0'\ 0'\ ~ .....t o o o V"l"' C'l 0'\ N"' .....t o o o 0"' N 00 ("1')"' ...... o o o V"l"' .....t C'f') V"l"' .....t o o o V"l'" r--- 0'\ N"' .....t o o o 0'" 0'\ oo::t ("1')"' .....t j 3 o ~ ~ ~ ~ ;-I ~ s o E-c .....t .....t .....t 0\"' \0 \0 0'" \C EA \C V"l \C 0'\'" C'f') t' 0\"' \0 &9 C'f') C'f') 00 r---"' ("I') oo::t .....t"' \0 &9 N V"l ['.. 00"' "'=t C'l N'" \C EA N N 0\ 0\ .....t C'f') ..q: V"l Ef7 .....t oo::t o r:--- '" 00 1I1 .....t"' V"l Ef7 \C \C 00 V"l"' V"l C'f')", V"l oo::t EA \0 00 00 0'\"' t"-- t"--"' r--- C"f) &9 \0 \0 .....t N"' N 00 oo::t"' C'f') Ef7 t' C'f') o N"' V"l t"-- 0'\"' M EA ~ .5b ~ ~ ~ j ~] o ;-I ~~ ...... ~ - 0 ~ ~ ..... ..s ~ I i ~ ~ : o ~ E-c '$. V"l N 00 .....t "$, 00 0'\ ~ '$. o oo::t d C'l '$. oo::t ("I') M .....t '$. 0'\ o 00 .....t '$. "'=t o d M '$. V"l ('f) ~ N '$. ~ 00 00 N '$. '-n .....t r....: N '$. o M ~ C'f') as '0 Z a) i € ~ a ~ [/) CI:l Q.) CI:l CI:l e':S ~ "0 ....- ~ o d ~ (.) ~ ~ o l() ~ ~ Q.) (.) ~ ~ "0 g ~ ....- is "0 8 ..g bl) · 1"""1 :g ~ b S bl) bl) ~ ~ ....- en g en ~ CJ Q.) 'fi ~ f"'""'4 Q.) (.) ~ ~ Q.) ~ ;-\ tf.) ~ "0 ~ N = ~ THIS PAGE INTENTIONALLY LEFT BLANK 103 CITY OF COLLEYVILLE, TEXAS PLEDGED REVENUE COVERAGE LAST TEN FISCAL YEARS Water Revenue Bonds Utility Less: Net Fiscal Service Operating Available Debt Service Year Charges Expenses Revenue Principal Interest Coverage 2000 $ 9,540,064 $ 5,698,694 $ 3,841,370 $ 541,000 $ 556,761 $ 2,743,609 2001 8,477,716 5,793,366 2,684,350 566,000 515,003 1,603,347 2002 8,407,033 5,909,848 2,497,185 597,000 485,984 1,414,201 2003 8,840,900 6,444,484 2,396,416 622,000 457,143 1,317,273 2004 8,924,942 6,117,278 2,807,664 680,000 406,306 1,721,358 2005 10,198,733 7,251,998 2,946,735 765,000 361,976 1,819,759 2006 13,136,476 8,067,565 5,068,911 795,000 329,451 3,944,460 2007 10,046,030 8,040,621 2,005,409 825,000 296,546 883,863 2008 11,452,268 9,670,881 1,781,387 700,000 265,658 815,729 2009 11,458,282 8,943,803 2,514,479 640,000 241,223 1,633,256 Notes: Details regarding the City's outstanding debt can be found in the notes to the financial statements. Operating expenses do not include interest, depreciation, or amortization expenses. Sales tax increment bonds are backed by the sales tax revenue produced by the sales tax rate in effect when the bonds were issued (1/2 percent) applied to the increase in retail sales in the Commons shopping area since that time. 104 TABLE 14 Drainage Revenue Bonds Sales Tax Bonds Drainage Drainage Net Service Operations Available Debt Service Sales Tax Debt Service Charges Expenses Revenue Principal Interest Coverage Increment Principal Interest Coverage $ 448,990 $ 193,979 $ 255,011 $ 55,000 $ 79,581 $ 120,430 $ 849,426 $ 145,000 $ 344,759 $ 359,667 692,628 230,578 462,050 55,000 142,772 264,270 823,946 160,000 443,401 220,545 615,099 256,866 358,233 205,115 85,550 67,568 881,921 170,000 533,066 178,855 704,031 235,105 468,926 140,000 144,417 184,509 768,846 185,000 419,114 164,732 694,196 312,235 381,961 140,000 122,263 119,698 873,626 195,000 406,472 272,154 710,265 338,310 371,955 175,000 116,432 80,523 982,844 210,000 387,085 385,759 897,606 444,700 452,906 150,000 111,252 191,654 1,132,094 240,000 402,929 489,165 922,123 462,387 459,736 160,000 104,206 355,530 1,208,379 255,000 391,366 562,013 902,232 510,259 391,973 165,000 96,984 294,989 1,300,260 270,000 380,013 650,247 889,163 500,677 388,486 170,000 90,138 298,348 1,264,385 275,000 368,195 621,190 105 TABLE 15 CITY OF COLLEYVILLE, TEXAS DEMOGRAPHIC AND ECONOMIC STATISTICS LAST TEN FISCAL YEARS Tarrant Per Capita County Calendar Personal Personal Unemployment Year Population Income Income Rate 2000 19,200 $ 142,877 $ 47,467 3.6% 2001 19,500 147,258 48,923 4.5% 2002 19,850 151,638 50,378 6.1% 2003 20,150 157,414 52,297 6.3% 2004 20,500 161,095 53,520 5.6% 2005 21,000 165,008 54,820 5.1% 2006 21,700 167,009 55,485 4.5% 2007 22, 150 175,008 58,142 4.3% 2008 22,500 173,853 57,758 5.1% 2009 22,550 166,063 55,170 8.2% Sources: Population - North Central Texas Council of Governments, personal income - City of Colleyvil1e Economic Development Department, Unemployment Rate - Texas Workforce Commission (unemployment rate is not available solely for the City of Coli eyvill e) 106 TABLE 16 CITY OF COLLEYVILLE, TEXAS PRINCIPAL EMPLOYERS CURRENT YEAR AND NINE YEARS AGO 2009 2000 Percentage Percentage of Tot a! City of Total City Employer Employees Employment Employees Employment* Lifetime Fitness 230 4.5% - % Market Street 200 3.9% - % City of Colleyville 199 3.9% 157 - % Grapevine Colleyville ISD 150 2.9% 145 - % Kroger - % 150 - % Morgan Stanley 122 2.4% - % Albertsons 110 2.1% 200 - % LaHacienda Ranch 100 1.9% 100 - % K -Mart - % 100 - % DigiMedical Solutions 90 1.7% - % Mac's Steak and Seafood 80 1.5% - % TGW Insurance 75 1.5% - % NEO Industries 60 1.2% - % Payless Cashways - % 60 - % Creme de la Creme 60 1.2% - % Sonshine Academy 60 1.2% - % RWA, Inc. 50 1.0% - % Crown of Life Lutheran Church 50 1.0% - % Rio Mambo 50 1.0% - % Michael's Keys 50 1.0% - % T ota! 1,736 33.6% 912 - % Source: City Economic Development Division *This information is unavailable. 107 r-... ""'" ~ ~ rLJ. ~ ~ ~ ~ ~ ~ ~ o u ~ o ~ ~ u VJ. r-l r-l S ~ ~ ~ r-l E-l Z ~~ ~ ~~ ~ ~o > o~ ~ ~~ u ~o S u E: z ~u r-l ZZ ~ r-lS ~ ~~ -< ~= ~ ~ OJ r-l r-l ~ E-i ~ ~ 0'\ o o N 00 o o N I:"'-- o o M \0 o o N o~ ("I') .... ~ .B ~ rI.) V"l tt-c 0 o 0 rn N cd CI.l o ~ ..2 ! ;-I ~ oo::t i g 'S N $ 8 .~ ;; ~ ("I') o o N N o o N .....t o o M o o o N s 8 ~ ~.E ~o ~ia ..z:f ~ ~ 8 Q ~ ~ '8 ~ ~ ~ ~ ~::E~ " oo::t\OC"")\O~ V"l\oC'f')\00 V"l\OC'f')lf)\O \0 t"-- ("t) If) \I') \OI:"'--Mlf)\I') \Ot"--C'f')lf)oo::t \Ot"--l()1.()("f) \O\Ol()lf)oo::t 1:"'--\0 l(j If)oo::t t"--\OV"llf)N ~ ~ .~ :.a .... _ 0 ~ .5 o:S p::~o CI.l ~ .~ 8 ~ ~ .- 0 .u..... '0 ~ 00 oo::t C'f') .....t ~~ V"l C'f') ("I') .....t M .....t C'f') .....t .....t 0 ("I') .....t C> 0 ("I') .....t o 0 ("I') ..-4 o 0 C'f') .....t o 0 ("I') .....t o 0 ("t) .....t ~ ~ o 1 ~ .B CI.l ..cj ~ ~~ e .r; e~u ~ C'f') ("t) V"l C'f') 0 .....t ("I') C'f') V"l C'f') 0 .....t ('t) C'f') V"l ("t) 0 .....t V"l C'fi .....t o 00 V"l ~ 0'\ \0 N V"l 0 ;ti 00 V"l ~ 0'\ \0 N V"l V"l M ~ .....t 0'\ \0 N lr) ~ ("I') ("I') V"l C'f') 0 V"l \f') V"l 00 \0 .....t N vi ~ N .....t C'f') C'f') V"l C'f') 0 V"l V"l \f') V"l \0 .....t N vi ~ vi .....t N o ("I') V"l C'f') 0 V"l V"l V"l V"l oo::t .....t N vi ~ vi .....t N o ('f) \0 C'f') 0 V"l V"l \f') V"l oo::t ..-4 N vi ~ C"4 .....t N o C'f') \0 C'f') V"l V"l V"l V"l V"l d N ~,...; M .....t .....t N o ....... C'f') t"-- M V"l M V"l lf1 V"l .....4.....t ~.....t C'f'l .....t N o C'f') t--. N V"l N V"l V"l tr'l .....4.....t ~,...; M .....t N CI.l ~ ~ ~ .g .~ :a ~ ~ .Et ~ ~ OJJ-:S -:S ~ 0 o ~ o ~ rI.) d o '.z:f ro ~ e 1 ~ P-4 ~ ~ 8 ~ Q) ~ ~ ~ { ~ ~ ~ ~ u ~ Q) ~ ~ V"l .....; 0'\ .....t V"l d 0'\ .....t V"l vi 00 .....t V"l ~ t' .....t o C'fi t"-- .....t o \Q \0 .....t o vi \0 .....t V"l 00 V"l .....t ~ .....t \0 .....t o ~ V"l .....t s o E-c E ~ ~ B ~ (,.) Ul . ...... "S (j) ~ ]- (j) "S Q) ~ .e ~ Q.) .~ ~ ~ ~ ~ (j) ...... ~ (,.) .~ CI:l ] 8 .~ ~ 00 .S "C ~ (,.) .s """-" ~ ~ ~ ~ CIJ j o 00 o N ~ o ....- QO o -,...I Q) ~ o CI:l (j) (,.) ~ CI:l ~ ~ s ~ .~ u ~o ~~ ~E CI:l CI:l .~ ~ Q)~ ~~ o 0 a~ ~~ ....- (j) 0 ~i c.S .~ <;.0 Q.) (,.) ~ r/) (,j Q.) ~ 00 l'""'I ~ ~ ~ tJ Vl ~ ~ ~ ~ 0 ~ ~ ~ E-l ~ ~ ~ ~ ~ ~ ~ ~ S ~ 0 Z o E-f r-l U -< ~ U E-l ~ ~ Vl o ~ j ~ ~ U ~ ~ r-1 ~ o 0'\ o o N o .....t O'\-.::t \0 v)"' 00 o o N .....t 00 C'f') 0 .....t .....t 00"' t' o o M o ....... -.::t oo::t .....t 0'\ 00"' \0 o o N o 0'\ t"-- 0'\ NV"l 0'\"' V"l o o M V"l oo::t -.::t C'f') NI:"'-- 00"' ~ ~ ] ii: V"l .....t .......0 M oo::t t"--"' -.:t o o M ("I') o o N M.....t C"f') .....t .....t 0 V"l"' N o o N V"l \0 ("I') ("I') .....t V"l oo::t "' .....t o o M \0 0'\ oo::t 00 M ("I') t"-- "' o o o N C'f') N 00 00 .....to'\ V"l"' 1 ~ o ~ Q ~ ~ "d ~ .a ~ ~ ~ CI.l .~ = 1 ~ ..8 is .~ i ~ P-4.~ ~ gp gp ~:9:9 ~ .s 's .s o~~~ 0'\ 0 0 o 00 V"l 00 -.:t V"l ('t)"' C"t"' M .....t oo::tM.....t .....to'\M V"l ("4 \0 vi tt)"' .....t .....t \0 0'\ 00 \ONC'f') \0 \0 oo::t t---"' N .....t .....t V"l \0 00 00 oo::t .....t oo::t V"l N 0"' .....t"' .....t .....t oo::t 00 .....t o \0 .....t oo::t \0 C'f') 0"' t'"' .....t C'f') t"-- \0 oo::t 0 0 \0 oo::t 00 .....t"' ~ .....t C"f') t--- \0 oo::t 0 0 \0 oo::t 00 .....t"' t'"' .....t o oo::t \0 o 00 C'f') t' t"--.... \0 .....t 00"' .....t .....t C'f') N 0'\ 0 lI) I:"'-- 0'\ .....t vi 00"' 0'\ 0\ N oo::t 00 -.::t M \0 lI) C'f')"' 0\"' ~ 8 CI.l .E ~ M BtS . fi1 CI.l >.;; a::u t"-- C'f') \0 C'f') 0'\ 0'\ t"-- \0 t"-- 0'\ C""i .....t t' I:"'-- .....t 0 \0 V"l oo::t"' .....t t' \0 00 \0 \0 \0 \0 \0 t.r'l 00 0'\ t--- V"l N .....t \0 V"l "' VI 0 C'f') .....tC'f')O I:"'-- \0 lI) ON \0 0'\ 0'\ V"l .; V"l ~ \OO'\M VI 00 .....t \0 V"l C'f') ("I') N I:"'-- o C'f') \0 \0 00'\0 .....t 0 \0 V"l \0 V"l C'f') o 0 0'\ 00 \0 V"l 0'\ 0\ 0 N t() V"l \0 lI) t"-- M V"l -.:t 00 .....t \0 \0 0\ 0'\ 0 N V"l V"l \0 lI) t--- 00 t--- \0 C'f') \0 I:"'-- NV"lO N-.:tV"l \0 V"l M .....t V"l 0'\ t' \0 \0 \0 ....... C'f') .....t 0'\ V"l V"l VI V"l M V"l 0 \0 M \0 \0 \0 V"l 0 aNO \0 V"l M o \0 oo::t 00 \0 \0 0'\ 0\ V"l V"l \0 -.:t"' ';00 \I') ('t) M 00 -.:t oo::tl:"'-- ('t) \0", 0'" .....t V"l .....t M .....t M .....t .....t M t' \0"' t'"' oo::t 0'\ .....t 00 t' t"-- 00 C'f')... 0 ("I') t'"' oo::t t' .....t \0 0 V"l C'f') \0 .....t oo::t"' 0'\"' C'f') C'f') .....t oo::t V"l C'f') \0 C'f')", .....t N M"' N 0 .....t t"-- ("I') V"l C'f') ......."' 0'\ .....t t--.... N.....t o \0 0'\ 00'" C'f') 0'\ 00 00"' o o t"--", 00 .....t \0 V"l 00"' .....t t' ("4 00"' t' \0 o 00"' .....t 00 t' 1:"'--"' C'f') oo::t \0 t---"' o 0'\ oo::t ~ M 00 M t"--"' 00 t"-- V"l \0"' 0'\ .....t \0 \0"' ("I') N ....... V"l"' .....t 00 o 00'" .....t V"l 0'\ V"l'" oo::t \0 0\ oo::t"' .....t N ("I') V"l'" o oo::t ("I') oo::t"' C'f') ~ lI)'" \0 V"l I:"'-- V"l.... ~ CI.l ~ CI.l .~ ~~ ~ ~ 8 .~ ;::l ~ o ~'"3 ~ e ~ ~ ii: ~ ~~ "d ..2 CI -e 0 .s .~ e .~ ~ CI.l ';; ~ .~.B ~_g l5 ~ .~ ~ P-4 ;3 ~ ~tf! ~"d Co> 8 0 CI.l M BQ1p CI E! ~ Q ~ e ~.s .;.e .g1~1.~e'hs~ ~~~rna~e~~ ~0;f3(/)~<Ur9;>E-c o ~ ~ ~ "..:::Jr-....;::lr-.... ~ ~ ..8 ~ ~ ;; ~;; 8~~~ ~~~~ ~ ~ ~ ~ ~ M CJ) ~ '"0 ::s ~~~~~~ ~8<'-"~'-' ~ oo::t t' \0 \0"' .....t V"l .....t C'f') 00"' oo::t \0 I:"'-- \0"' .....t 00 M .....t 00'" 00 \0 o C'f') "' .....t \0 \0 0'\", t--- M C'f') t' \0"' .....t .....t \0 t"-- t---"' \0 M .....t \0"' .....t C'f') \0 V"l 1:"'--"' oo::t o M C'f')"' .....t oo::t 0'\ N 1:"'--"' C'f') M .....t V"l'" .....t M .....t .....t r-:- -.::t 00 .....t ("4'" .....t M t' 0'\ \0'" ("I') V"l I:"'-- oo::t"' .....t .....t I:"'-- oo::t ~ o 00 V"l V"l'" .....t M 0'\ -.:t \0"' I J rn = ~u 0'\ = ,...( CI:l == j fir "0 S ('f') o o N .S i S ~ ~ ~ :9 i-l (j) ~ * rn 6 ~ Q.) (,.) ~ CIJ: e\ ....-I ~ ~ rJ:J. ~ ~ ~ ~ ~ ~ ~ o u ~ o ~ I--l U ~ o ~ ~ o jIIIIII( ~ u z ~ > == Vl U jIIIIII( ~ rIJ ~ E Vl ~ ~ TJ:l tfJ -< ~ jIIIIII( ~ ~ r-l ~ ~ U Vl S z ~ ~ ~ TJ:l ~ ~ o ~ ] ii: ("I') .....t 0'\ o o N C'f') .....t 00 o o N o .....t I:"'-- o o N .....t I:"'-- \0 o o N .....tl:"'-- N V"l o o N .....t I:"'-- N 00::1' o o N .....t\O N C'f') o o N .....t \0 N N o o N .....t \0 M .....t o o N .....t\O N o o o N ~ ~ o '.z:f ~ $l 00 en.~ CI.l ~ ~ p ~ ~ .~ .~.t1 .~.~ Roo~eoo~ ~ ii: ~ ("I') N 00 M .....t \0 C'f') .....t .....t"' ("I') NON .....t .....t ("I') 0 .....t"' N .....t .....t N .....t .....t C'f') 0.... .....t N t"--OM o 0'\ ('t) 0'\ o 0 M o \0 C'f') 00 V"l .....t N 0'\ V"l NI:"'-- 00 V"l N 00 "l:f' N I:"'-- 00::1' 0 \0 00::1' MI:"'-- N t"-- 00::1' N Nt"-- NO N N NI:"'-- s:l o '.z:f "00' CI.l ro ..2 7d ~ 's ~ .~ e 'i'~Q] o Q) 1E d ~.g~~ 00 00 E-c ~ P-c N\O 0'\ 00::1' o ~ N N \0 0'\ 00::1' o .....t N g\OO'\:!; N o V"l 0'\ "l:f' 0'\ .....t .....t o V"l 0'\ 00::1' 0'\ .....t .....t V"l V"l 0'\ 00::1' .....t 00 .....t .....t V"l V"l 0'\ 00::1' 00 .....t .....t V"l V"l 0'\ <o::t 00 .....t .....t V"l V"l 0'\ 00::1' 00 .....t .....t V"l V"l 0'\ 00::1' ~ 00 .....t .....t ] ~ ;.a ~ ~ ~ ~a~~ ~ ~ 03 .S Wf~~i~ j _ ro 0 0 ~~p::jooU 0'\ 0 0 0'\ 00::1' 0 .....t ('t'l 0'\ ~ 0'\"' N.....t 0 0'\ t"-- 0 .....t M 0'\ .....t"' 00::1'"' .....t 00::1' 0 0'\ V"l 0 .....t N 0'\ .....t"' 00::1'"' \() \0 0 ~ ~ ~ .....t"' 00::1'"' ('t'l 0'\ 0 t"-- 00::1' 0 .....t .....t 0'\ .....t"' 00::1'"' o 00 0 ~~~ .....t"' ~ N 0 0 V"l 00::1' 0 .....t 0'\ 0'\ 00::1'"' 000 ~ ~ ~ 00::1'"' 000 \() 00 0 .....t 00 0'\ 00::1'"' t"--NO 00::1' t"-- 0 .....t 00 0'\ 00::1'"' '00' '00' ~ ..2 C';:l .s ~ ~ '-' .0 0 a ~ ~ ~ .~ .a ~ ; ~ '-t.E'~~ ~ ~ ~ .~ ~ ~ ~ ~p~oo ~ \0 ('t) \0 \0 .....t 00::1' 0'\ \0 lI) .....t ("I') 0'\ \0 V"l .....t 00::1' 00 V"l V"l .....t o t"-- V"l V"l .....t t"-- \0 00::1' V"l .....t C'f') V"l C'f') V"l .....t o 00::1' C'f) V"l .....t OM C'f') V"l .....t o .....t ('t'l \() .....t '00' ~~ 5] ~'-' o ~ ~ ~ B ~ .S e Cd ..s 0000 CI:l ~ ~ ~ "0 .~ U CI:l g ~ g .:g ~ ~ 1-1 :9 '1""""'1 ~ d I ~ ~ b 5 bJJ Q.) .s ~ Q;) ~ ~ ~ (j) ~ <= ....-l ~ CI:l ~ ~ (.) ~ .s l) CI:l CI:l C'\S ~ .~ ~ (,,) o Z Cl) (,.) ~ CZl Q.) o z