Loading...
HomeMy WebLinkAboutComprehensive Annual Financial Report (CAFR)-Audit Records-9/30/2004 CITY OF COLLEYVILLE, TEXAS COMPREHENSIVE ANNUAL FINANCIAL REPORT YEAR ENDED SEPTEMBER 30, 2004 CITY OF COLLEYVILLE, TEXAS T ABLE OF CONTENTS YEAR ENDED SEPTEMBER 30, 2004 Page Number INTRODUCTORY SECTION Letter 0 f Transmittal ........................................................................................................... 3 - 6 Organizational Chart........................................................................................................... 7 Certificate of Achievement................................................................................................. 8 Prin c i pal 0 ffi c i al s ............................................................................................................... 9 FINANCIAL SECTION Independent Auditors' Report............................................................................................. 13 - 14 Management's Discussion and Analysis............................................................................ 1 7 - 25 Basic Financial Statements Statement of Net Assets................................................................................................... 28 - 29 S ta tement 0 fActi viti e s . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 - 31 Balance Sheet - Governmental Funds............................................................................. 32 - 33 Statement of Revenues, Expenditures and Changes in Fund Balances - Governmental Funds......................................................................... 34 - 35 Reconciliation of the Statement of Revenues, Expenditures and Changes in Fund Balance of Governmental Funds to the S ta tement 0 fActi viti e s . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36 Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual- General Fund ................................................... 37 ( continued) CITY OF COLLEYVILLE, TEXAS T ABLE OF CONTENTS (Continued) YEAR ENDED SEPTEMBER 30, 2004 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 Flows - Proprietary Funds................................................................. Statement of F iduciary Net Assets................................................................................... 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 38 39 40 - 41 42 43 - 68 72 - 75 76 - 79 80 Combining Statement of Fiduciary Net Assets................................................................ 82 Combining Statement of Changes in Assets and Liabilities............................................ 83 ( continued) CITY OF COLLEYVILLE, TEXAS T ABLE OF CONTENTS (Continued) YEAR ENDED SEPTEMBER 30, 2004 STATISTICAL SECTION (Unaudited) General Governmental Expenditures by Function.................................. General Governmental Revenue by Source............................................ Property Tax Levies and Collections ...................................................... Assessed and Estimated Actual Value of Taxable Property................... Property Tax Rates - Direct and Overlapping Governments (Per $100 of Assessed Value) .............................................................. Ratio of Net General Bonded Debt to Assessed Value and Net Bonded Debt Per Capita................................................................ Computation of Legal Debt Margin........................................................ Ratio of Annual Debt Service Expenditures for General Bonded Debt to Total General Governmental Expenditures ............... Computation of Direct and Overlapping Debt........................................ Revenue Bond and Certificates of Obligation Coverage ........................ Demographic Statistics........................................................................... Property Value, Construction.................................................................. Princ i pal T axpay ers ................................................................................ Miscellaneous Statistical Data................................................................ Exhibit/Table 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Page Number 86 - 87 88 - 89 90 - 91 92 94 - 95 96 - 97 98 99 100 102 - 103 104 105 106 107 INTRODUCTORY SECTION 1 THIS PAGE INTENTIONALLY LEFT BLANK 2 February 1,2005 To the Citizens of the City of Colley vii Ie: The Comprehensive Annual Financial Report of the City of Colley vii Ie (the "City") for the fiscal year ended September 30, 2004, 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 financial activities have been included. In developing and evaluating the City's accounting system, consideration is given to the adequacy ofintemal 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, 2004, 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 of Colley vii Ie's financial statements for fiscal year ended September 30, 2004, are presented in conformity with generally accepted accounting principles (GAAP). The Comprehensive Annual Financial Report is presented in three sections: introductory, financial and statistical. The introductory section includes this transmittal letter and the City's organizational chart. The financial section includes auditor's report on the financial statements, a narrative introduction, overview and analysis required by GAAP in the form of the Management's Discussion and Analysis, the basic financial statements, fund financial statements, and combining and individual financial statements. 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 immediately following the report of the independent auditors. The statistical section includes selected unaudited financial and demographic information generally presented on a multi -year basis. 3 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 five council members. The mayor and council are responsible for passing ordinances, adopting the budget, appointing board and committee 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 council are elected on an at large, non-partisan basis. The mayor is elected for a two-year term. The Council's terms are staggered with three Council members elected for a two year term and the two remaining Council members elected for a two year term at the same time as the mayor. 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 community 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: Entitv 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 ECONOMIC CONDITION AND OUTLOOK The City of Colleyville is a residential-oriented community 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 2004, as did commercial development. During the fiscal year, the City issued 275 residential building permits and the average square footage of a residence was over five thousand square feet. Also, approximately 220,000 square feet of new commercial development was completed or in process during FY 2004. Long-term Financial Planning. As a part of the Fiscal Year 2004 budget process the Mayor and Council and City Staff embarked upon developing a multi-year capital improvements program. The process identified projects in the following sub-categories: facilities, parks and recreations, streets, subdivisions, sidewalks, drainage, water and wastewater, and equipment. Additional topics discussed were financing mechanisms and debt capacity. 4 FINANCIAL INFORMATION Budgeting Controls. The City Charter of the City of Colleyville 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. The proposed budget is presented to the City Council at a budget work session. Department directors have an opportunity to make a budget presentation to the City Council and are available for questions. Copies of the proposed budget are made available to the public and the press and the public hearing schedule is confirmed. Before the public hearings are held, notices of the public hearings on the proposed budget are posted and published in the newspaper. 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 Council adopts the tax rate ordinance at the same meeting as the budget. 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. Cash Management. Cash temporarily idle during the year was invested in U. S. Treasury Bills and Notes, Agency Discount Notes and Medium Term Notes and a local government investment pool (LOGIC). The average yield on investments for the year was approximately 1.93%. The primary objectives of the City's investment policy, in priority order, are safety (preservation of capital), liquidity (to provide adequate and timely working funds), and return on investment (obtaining a rate of return commensurate with investment risk constraints and cash flow needs). All deposits were either insured by federal deposit insurance or collateralized and the collateral was held by a trustee bank in the City's name, which is the lowest category of risk as defined by the Governmental Accounting Standards Board. The City currently holds the Certificate of Distinction from the Government Treasurer's Organization of Texas for its investment policy. Risk Management. 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' rates are based on the City's past claims history. The Risk Pool retains a limit of loss and reinsurance companies insure the risks beyond those limits. During the fiscal year, representatives from the Risk Pool physically reviewed City facilities to identify possible risks. City employees also participated in Risk Pool sponsored safety training classes. 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, 2003. This was the fifteenth 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. 5 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. In addition, the City also received the GFOA's Distinguished Budget Presentation award for its annual budget dated October 1, 2003. In order to qualify for this award, the City's budget document was judged to be proficien.t 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, lMutf;If~ Terry Leake Finance Director 6 CITY OF COLLEYVILLE CITIZENS OF ORGANIZA TIONAL CHART COLLEYVILLE FISCAL YEAR 2003-2004 LIBRARY PLANNING ZONING CRIME BOARD AND ZONING BOARD OF CONTROL COMMISSION ADJUSTMENT AND PREVENTION DISTRICT COLLEVYILLE I I I CITY I ECONOMIC I I I COUNCIL I DEVELOPMENT SIGN BOARD PARKS AND AD HOC TAX CORPORATION OF APPEALS RECREATION COMMITTEES INCREMENT BOARD FINANCING DISTRICT I MUNICIPAL JUDGE I CITY ATTORNEY CITY MANAGER LIBRARY COMMUNITY PARKS AND CITY DIRECTOR CENTER RECREATION SECRETARY MANAGER MANAGER DEPUTY I I I CITY MANAGER HUMAN COMMUNICA- RECORDS ADMINISTRA- RESOURCES TIONS MANAGER TIVE MANAGER MANAGER ASSISTANT I FINANCE DIRECTOR OF PUBLIC WORKS FIRE CHIEF POLICE CHIEF DIRECTOR DEVELOPMENT DIRECTOR SERVICES (CITY ENGINEER) I PUBLIC WORKS OPERATIONS MANAGER COMMUNITY & UTILITY ECONOMIC STREETS & RESPONSE PATROL BILLING DEVELOPMENT DRAINAGE FLEET INVESTIGATIONS MUNICIPAL BUILDING INSPECTIONS/ COURT INSPECTION MAINTENANCE INVESTIGATIONS ANIMAL UTILITY ADMIN. CONTROL CITY HALL CODE AND OPERATION RECEPTION 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 Y ear Ended September 30, 2003 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 ~/~ Executive Director 8 CITY OF COLLEYVILLE, TEXAS HOME RULE, COUNCIL - MANAGER FORM OF GOVERNMENT CITY OFFICIALS YEAR ENDED SEPTEMBER 30, 2004 Joe Hocutt Mayor Mark Skinner Councilmember, Place 1 Elaine Dolan Councilmember, Place 2 Rich Hendler Councilmember, Place 3 Jon Ayers Mayor Pro Tem and Councilmember, Place 4 Tom Hart Councilmember, Place 5 William Lindley City Manager Terry Leake Finance Director 9 THIS PAGE INTENTIONALLY LEFT BLANK 10 FINANCIAL SECTION 11 THIS PAGE INTENTIONALLY LEFT BLANK 12 PH~ PAT T ILL 0, B ROW N & H ILL, 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, 2004, 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 an opinion 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, on a 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, 2004, and the respective changes in financial position and the cash flows, where applicable, 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 HIGHWAY 6 . P. o. BOX 20725 . WACO, TX 76702-0725 . (254) 772-4901. FAX: (254) 772-4920 . www.pbhcpa.com AFFILIATE OFFICES: BROWNSVILLE, TX (956) 544-7778 . HILLSBORO, TX (254) 582-2583 TEMPLE, TX (254) 791-3460 . ALBUQUERQUE, NM (505) 266-5904 . RIO RANCHO, NM (505) 898-3516 The management's discussion and analysis on pages 1 7 through 25 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 nonmajor fund financial statements, 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 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 tables have not been subjected to the auditing procedures applied in the audit of the basic financial statements and, accordingly, we express no opinion on them. l) ~ \ll (1(1 ) L.L:f r a...~Jio J ~ ~ 1'1\,V.. November 19,2004 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, 2004. 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. The City implemented Governmental Accounting Standards Board Statement 34 - Basic Financial Statements and Management's Discussion and Analysis for State and Local Governments (GASB 34) for the first time this year. FINANCIAL HIGHLIGHTS . The assets of the City of Colleyville exceeded its liabilities as of September 30,2004, by $116,856,575 (net assets). Of this amount, $31,418,772 (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 $6,444,818. . As of the close of the current fiscal year, the City of Colleyville's governmental funds reported combined ending fund balances of $17,252,071. Of this amount, $14,195,261 is unreserved fund balance available for use within the City's fund designation and fiscal policies. . As of September 30, 2004, unreserved, undesignated fund balance for the General Fund was $6,767,592 or 50% 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) government- 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 28 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. 17 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). 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. 18 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 38 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 43 - 68 of this report. 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 72 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 $116,856,575 as of September 30, 2004. The largest portion of the City's net assets ($84,013,048) 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. With the first year implementation of GASB 34, the City is not presenting comparable columns in the various comparisons and analyses for the prior year. 19 CITY OF COLLEYVILLE'S NET ASSETS Governmental Activities Business-type Activities Totals 2004 2003 2004 2003 2004 2003 Current and other assets $ 18,536,561 $ 18,689,258 $ 17,337,224 $ 16,372,931 $ 35,873,785 $ 35,062,189 Capital assets 86,386,646 83,914,653 35,391,552 34,845,252 121,778,198 118,759,905 Total assets 104,923,207 102,603,911 52,728,776 51,218,183 157,651,983 153,822,094 Other liabilities 2,813,573 3,078,676 1,905,217 1,871,258 4,718,790 4,949,934 Long-term liabilities 25,349,005 26,872,583 10,727,613 11,587,820 36,076,618 38,460,403 Total liabilities 28,162,578 29,951,259 12,632,830 13,459,078 40,795,408 43,410,337 Net assets: Invested in capital assets, net of related debt 60,055,616 55,965,990 23,957,432 22,588,864 84,013,048 78,554,854 Restricted 756,516 1,040,403 668,239 668,120 1,424,755 1,708,523 Unrestricted 15,948,497 15,646,259 15,470,275 14,502,121 31,418,772 30,148,380 Total net assets $ 76,760,629 $ 72,652,652 $ 40,095,946 $ 37,759,105 $ 116,856,575 $ 110,411,757 A portion of the City's net assets ($1,424,755) represents resources that are subject to external restriction on how they may be used. The remaining balance ($31,418,772) 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, 2004, 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. Analysis of the City's Operations - The following table provides a summary of the City's operations for the year ended September 30, 2004 and 2003. Governmental activities increased the City of Colleyville's net assets by $4,107,977 accounting for 64% of the total growth in net assets. Business- type activities increased the City's net assets by $2,336,841, accounting for 36% of the total growth in net assets. 20 CITY OF COLLEYVILLE'S CHANGES IN NET ASSETS Governmental Activities Business-type Activities Totals 2004 2003 2004 2003 2004 2003 Revenues: Program revenues: Charges for services $ 3,315,199 $ 2,556,405 $ 9,602,855 $ 9,262,270 $ 12,918,054 $ 11,818,675 Operating grants and contributions 619,459 328,324 619,459 328,324 Capital grants and contributions 3,857,202 8,014,501 1,412,990 1,443,502 5,270,192 9,458,003 General revenues: Ad valorem taxes 8,534,388 8,183,790 8,534,388 8,183,790 Sales taxes 3,381,634 2,964,331 3,381,634 2,964,331 Franchise taxes 1,458,079 1,395,569 1,458,079 1,395,569 Other taxes 37,296 32,123 37,296 32, 123 Investment earnings 217,316 468,656 162,645 282,661 379,961 751,317 Miscellaneous 53,538 63,052 53,538 63,052 Total revenues 21,474,111 24,006,751 11,178,490 10,988,433 32,652,601 34,995,184 Expenses: General government 2,542,016 1,551,989 2,542,016 1,551,989 Community development and engineering 1,281,429 1,280,410 1,281,429 1,280,410 Fire and rescue 3,144,814 3,010,260 3,144,814 3,010,260 Leisure services 2,953,528 2,728,287 2,953,528 2,728,287 Maintenance 364,256 193,865 364,256 193,865 Municipal court 250,551 235,053 250,551 235,053 Police 3,295,263 3,498,419 3,295,263 3,498,419 Streets and drainage 2,562,499 2,195,256 2,562,499 2,195,256 Water and wastewater 1,491,649 7,444,264 7,704,603 7,444,264 2,093,209 Drainage 395,450 601,560 395,450 7,704,603 Interest on long-term debt 1,290,825 528,569 354,960 1,819,394 354,960 Total expenses 17,685,181 16,185,188 8,368,283 8,661,123 26,053,464 24,846,311 Increases in net assets before transfers 3,788,930 7,821,563 2,810,207 2,327,310 6,599,137 10,148,873 Transfers 473,366 1,058,060 473,366) 1,058,060) Change in net assets 4,262,296 8,879,623 2,336,841 1,269,250 6,599,137 10,148,873 Net assets, beginning 72,652,652 63,773,029 37,759,105 36,489,855 110,411,757 100,262,884 Prior period adjustments 154,319) 154,319) Net assets, ending $ 76,760,629 $ 72,652,652 $ 40,095,946 $ 37,759,105 $ 116,856,575 $ 110,411,757 21 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 of a 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 $17,252,071. Approximately 82% of this total amount ($14,195,261) constitutes unreserved fund balance. The remainder of the fund balance ($3,056,810) 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 32 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 $262,132 as a planned reduction of excess fund balance to fund "pay-as-you-go" capital expenditures. With budget amendments made, the final budgeted decrease in fund balance was $152,047. The actual increase to fund balance for the General Fund was $327,440 for fiscal year 2004. Proprietary funds - The City's proprietary fund statements beginning on page 38 of this report provide the same type of 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 ($14,107,538), and Drainage Utility ($1,362,737). These funds experienced increases in total net assets during 2004 as follows: Water and Wastewater ($2,160,358), and Drainage Utility ($176,483). Governmental Activities - There was an overall decrease in revenues in the governmental funds due to fewer developer contribution and grant revenues in Fiscal Year 2004. A small portion of the decrease is due to lower fine and forfeitures due to a decrease in citations issued and more appeals to Tarrant County. Investment income was down due to continued low interest rates for much of the fiscal year. However, there was an increase in the tax category due to the property tax base increase of over $213 million due to the construction of new residences, businesses, and revaluation of property. Fiscal Year 2004 was a year of preparation for the opening of Colleyville's first library in autumn 2004, as staff was added and supplies purchased. Increases in the Police area relate to the move to the new Justice Center. The increase in the Community Development and Engineering area was due to the update of the City's Master Plan. The Debt Service Fund's expenditures increased due to the first year payment on the 2002 Certificates of Obligations to furnish the City Hall and Library. Business-type Activities - The City has two enterprise operations, the Water and Sewer Fund and the Drainage Utility Fund. Total operating revenues of the Water and Sewer Fund were $8,924,942 for the fiscal year. Total operating revenues of this fund increased due to greater wastewater sales and impact fee revenues from new and commercial construction. There was a decrease in water sales due to record setting rains during the summer months. The coverage ratio for debt for this fund was 2.93 for the fiscal year. The increase in the Drainage Utility Fund's revenues was due to new residential and commercial construction. 22 Decreases in the Water and Sewer Fund expenses relate to the decrease of purchased water and treatment of wastewater from Trinity River Authority. The reduction of purchased water and treatment of wastewater was due to record rainfall during the summer months. The decrease in the Drainage Utility Fund expenses relates to smaller purchases of supplies for small neighborhood drainage projects completed by City crews. 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 $12,903,156. The increase was for street resurfacing, sidewalk improvements and construction of practice fields at Reagan Park. The General Fund's overall budgeted revenue increased by $923,282. The major increase was due to $420,882 in strong delinquent tax collections and sales tax collections, and $651,717 in building permit revenues from the Town Center and the Villages at Colleyville developments and residential permits. This increase was partially offset by a $53,837 reduction due to a lower number of traffic citations and higher number of appeals. Refer to the General Fund Statement of Revenue, Expenditures and Changes in Fund Balances - Budget and Actual on page 37 of this report for a detailed presentation of the actual General Fund operations compared to both the original and final budget for fiscal year 2004. CAPIT AL ASSETS The City of Colleyville's investment in capital assets for its governmental and business-type activities as of September 30,2004, amounts to $121,778,198 (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 million in drainage improvements and contributions; . Capitalized approximately $1 million in street improvements and contributions; and . Capitalized approximately $1.7 million on various water and wastewater system projects and contributions. 23 CITY OF COLLEYVILLE'S CAPITAL ASSETS AT YEAR-END Governmental Activities Business-type Activities Totals 2004 2003 2004 2003 2004 2003 Land $ 6,360,180 $ 6,360,180 $ 313,057 $ 313,057 $ 6,673,237 $ 6,673,237 Buildings and improvements 12,782,014 12,775,932 53,922 53,922 12,835,936 12,829,854 Equipment 4,818,713 4,609,685 969,344 977,481 5,788,057 5,587,166 Infrastructure/water distribution sewer collection 56,674,159 54,402,230 49,305,050 47,324,063 105,979,209 101,726,293 Construction in progress 23,668,324 21,783,326 827,548 934,168 24,495,872 22,717,494 Less: accumulated depreciation 17,916,744) 16,016,700) 16,077,369) 14,757,439) 33,994,113) 30,774,139) Total capital assets $ 86,386,646 $ 83,914,653 $ 35,391,552 $ 34,845,252 $ 121,778,198 $ 118,759,905 Additional information on the City's capital assets can be found in Note 4, pages 57 - 59 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$37,926,030. Of this amount, $12,925,000 represents bonded debt backed by the full faith and credit of the government, $13,377,722 represents bonds secured by sales tax revenues, $8,925,000 represents bonds secured solely by water and sewer revenues, and $2,660,000 represents bonds secured solely by drainage utility system revenues. The notes payable of $28,308 pertains to the purchase of radio tower communications system. OUTSTANDING DEBT AT YEAR-END BONDS, NOTES AND CAPITALIZED LEASE OBLIGATIONS PAYABLE Governmental Activities Business-type Activities Totals 2004 2003 2004 2003 2004 2003 General obligation bonds and certificates of obligation $ 12,925,000 $ 13,820,000 $ $ $ 12,925,000 $ 13,820,000 Sales tax revenue bonds 13,377,722 13,937,722 11,585,000 24,962,722 13,937,722 Revenue bonds payable 12,405,000 12,405,000 Notes payable 28,308 160,047 28,308 160,047 Capitalized lease obligations 30,894 30,894 Accreted interest 108,438 80,424 108,438 80,424 $ 26,439,468 $ 28,029,087 $ 11,585,000 $ 12,405,000 $ 38,024,468 $ 40,434,087 During the fiscal year, the City issued $1,710,000 in Water and Wastewater Revenue Refunding Bonds. The refunding resulted in a net present value savings of $100,715. 24 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+ AA+ AA- Most of the City's Bonds are insured, thus holding a Triple A credit rating from both Fitch ICBA and Standard & Poor's. Additional information on the City of Colleyville's long term-debt can be found in footnote 4 on pages 60 - 64 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 2005 is based on projected revenue growth of 7.8% compared to the fiscal year 2004 budget. Taxes account for the majority of the increase. Property taxes, which are about 54% of General Fund revenues, are budgeted at a 6% increase compared to the 2004 budget. This reflects the net effect of valuation increases and new construction. Approximately 13% of General Fund revenues are sales taxes. Sales taxes have been budgeted to increase 8% as compared to the FY 2004 budget. The 2005 budget includes a planned $344,744 utilization of surplus fund balance to fund one-time capital expenditures. The 2005 budget includes for the General Fund and other funds a 4% salary increase for all classes of employees. The General Fund has budgeted add $136,695 to the Street Department budget for the street overlay budget and purchase of asphalt patch truck and implementation of an equipment replacement fund ($45,740). There is no rate increase in the 2005 budget for either the Water and Wastewater Fund or the Drainage Utility Fund. Included in the Water and Wastewater Fund is $29,000 for the funding of upgrading security of the City's water system. This assessment will aid the City in meeting the requirements of the Bioterrorism Act for community water systems and enhancements are planned to continue through FY 2010. 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, Finance Director, at 100 Main Street, Colleyville, Texas 76034, or call (81 7) 503 -1 015. 25 THIS PAGE INTENTIONALLY LEFT BLANK 26 BASIC FINANCIAL STATEMENTS 27 CITY OF COLLEYVILLE, TEXAS STATEMENT OF NET ASSETS SEPTEMBER 30, 2004 Primary Government Component Unit Tax Increment Governmental Business-type Financing Activities Activities Total District ASSETS Cash and cash equivalents $ 3,285,618 $ 5,215,962 $ 8,501,580 $ 2,354,052 Investments 14,163,032 10,337,846 24,500,878 199,006 Receivables (net of allowances for uncollectibles of $158,696) Accounts 114,665 1,331,604 1,446,269 Property taxes 154,875 154,875 Due from other governments 716,181 5, 1 04 721,285 Other assets 265,468 265,468 Inventories 126,342 126,342 Accrued interest 102,190 54,898 157,088 242 Capital assets: Land 6,360,180 313,057 6,673,237 Buildings and improvements 12,782,014 53,922 12,835,936 Equipment 4,818,713 969,344 5,788,057 Infrastructure/water distribution! sewer collection 56,674,159 49,305,050 105,979,209 Construction in progress 23,668,324 827,548 24,495,872 Less: accumulated depreciation 17,916,744) 16,077,369) ( 33,994,113) Total capital assets 86,386,646 35,391,552 121,778,198 Total assets 104,923,207 52,728,776 157,651,983 2,553,300 ( continued) 28 CITY OF COLLEYVILLE, TEXAS STATEMENT OF NET ASSETS (Continued) SEPTEMBER 30, 2004 Primary Government Component Unit Tax Increment Governmental Business-type Financing Activities Activities Total District LIABILITIES Accounts payable $ 682,797 $ 490,171 $ 1,172,968 $ Accrued liabilities 111,407 17,754 129,161 Accrued interest payable 156,454 112,222 268,676 60,513 Advances from developers 271,835 6,728 278,563 Escrow funds 1,643 1,643 Customer deposits 42,772 366,699 409,471 Noncurrent liabilities: Due within one year 1,639,878 920,520 2,560,398 730,000 Due in more than one year 25,257,435 10,717,093 35,974,528 9,435,000 Total liabilities 28,162,578 12,632,830 40,795,408 10,225,513 NET ASSETS Invested in capital assets, net of related debt 60,055,616 23,957,432 84,013,048 Restricted for: Court security and technology 25,519 25,519 Debt service 730,997 668,239 1,399,236 Unrestricted 15,948,497 15,470,275 31,418,772 7,672,213) Total net assets $ 76,760,629 $ 40,095,946 $ 116,856,575 $( 7,672,213) The notes to the financial statements are an integral part of this statement. 29 CITY OF COLLEYVILLE, TEXAS STATEMENT OF ACTIVITIES FOR THE YEAR ENDED SEPTEMBER 30, 2004 Functions/Pro~rams Primary Government: Governmental activities: General government Community development and engineering F ire 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: Tax increment financing Total component unit Program Revenues Operating Capital Charges for Grants and Grants and Expenses Services Contributions Contributions $ 2,542,016 $ 16,000 $ 8,100 $ 1,281,429 1,687,921 103 3,144,814 125,081 201,123 2,953,528 399,319 336,064 778,918 364,256 250,551 508,572 3,295,263 66,135 74,069 2,562,499 512,171 3,078,284 1,290,825 17,685,181 3,315,199 619,459 3,857,202 7,850,570 8,924,942 1,412,990 517,713 677,913 8,368,283 9,602,855 1,412,990 $ 26,053,464 $ 12,918,054 $ 619,459 $ 5,270,192 894,805 $ $ $ $ 894,805 General revenues: Taxes: Property taxes, levied for general purposes Property taxes, levied for debt service TIF tax Sales taxes Franchise taxes Other taxes Investment earnings Miscellaneous Transfers Total general revenues, special items, and transfers Change in net assets Net assets, beginning Prior period adjustment Net assets, ending The notes to the financial statements are an integral part of this statement. 30 Net (Expense) Revenue and Changes in Net Assets Component Unit Primary Government Governmental B usiness- type Tax Increment Activities Activities Total Financing District $( 2,517,916) $ $( 2,517,916) $ 406,595 406,595 2,818,610) 2,818,610) 1,439,227) 1,439,227) 364,256) 364,256) 258,021 258,021 3,155,059) 3,155,059) 1,027,956 1,027,956 1,290,825) 1,290,825) 9,893,321) 9,893,321) 2,487,362 2,487,362 160,200 160,200 2,647,562 2,647,562 $( 9,893,321) $ 2,647,562 $( 7,245,759) $ 894,805) $ $ $ $( 894,805) 31 CITY OF COLLEYVILLE, TEXAS BALANCE SHEET GOVERNMENTAL FUNDS SEPTEMBER 30, 2004 Major Funds Debt Capital General Service Proj ect ASSETS Cash and cash equivalents $ 242,727 $ 466,877 $ 907,305 Investments 6,446,059 520,527 3,955,090 Receivables (net of allowances for uncollectibles) Accounts 76,239 38,426 Property taxes 123,732 31,143 Due from other governments 378,709 3,543 Accrued interest 58,435 4,942 13,068 Total assets $ 7,325,901 $ 1,027,032 $ 4,913,889 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable 259,594 85,658 Accrued liabilities 111,407 Deferred revenue 144,536 31,143 Advances from developers 241,212 Customer deposits 42,772 Total liabilities 558,309 31,143 326,870 Fund balances: Reserved for: Court security/technology Debt service 995,889 Developer fees 2,035,402 Unreserved, reported in: General fund 6,767,592 Special revenue funds Capital proj ects funds 2,551,617 Total fund balances 6,767,592 995,889 4,587,019 Total liabilities and fund balances $ 7,325,901 $ 1,027,032 $ 4,913,889 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 notes to the financial statements are an integral part of this statement. 32 Other Total Governmental Governmental Funds Funds $ 1,668,709 $ 3,285,618 3,241,356 14,163,032 114,665 154,875 333,929 716,181 25,745 102,190 $ 5,269,739 $ 18,536,561 337,545 682,797 111,407 175,679 30,623 271,835 42,772 368,168 1,284,490 25,519 25,519 995,889 2,035,402 6,767,592 2,459,810 2,459,810 2,416,242 4,967,859 4,901,571 17,252,071 $ 5,269,739 86,386,646 175,679 27,053,767) $ 76,760,629 33 CITY OF COLLEYVILLE, TEXAS STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES GOVERNMENTAL FUNDS FOR THE YEAR ENDED SEPTEMBER 30, 2004 Major Funds Debt Capital General Service Proi ect REVENUES Taxes $ 10,311,887 $ 1,494,699 $ Intergovernmental Licenses and permits 1,505,512 Fines and forfeitures 491,853 Charges for services 826,326 Capital improvement fees 577,171 Donations Investment earnings 107,912 12,592 40,923 Developer contributions 416,319 Other 51,937 20,547 Total revenues 13,295,427 1,527,838 1,034,413 EXPENDITURES Current: General government 1,580,990 848,229 Community development and engineering 1,281,745 F ire and rescue 2,931,073 Leisure services 1,967,513 412,258 Maintenance 356,819 Municipal court 232,170 Police 3,057,283 Streets and drainage 1,420,620 Debt service: Principal retirement 1,331,883 Interest and fiscal charges 867,491 Capital outlay 613,140 617,015 Total expenditures 13,441,353 2,199,374 1,877,502 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 145,926) 671,536) 843,089) OTHER FINANCING SOURCES (USES) Transfers in 473,366 641,895 Transfers out Total other financing sources and uses 473,366 641,895 NET CHANGE IN FUND BALANCES 327,440 29,641) 843,089) FUND BALANCES, BEGINNING 6,440,152 1,025,530 5,430,108 FUND BALANCES, ENDING $ 6,767,592 $ 995,889 $ 4,587,019 The notes to the financial statements are an integral part of this statement. 34 Other Total Governmental Governmental Funds Funds $ 1,631,759 $ 13,438,345 328,040 328,040 1,505,512 29,073 520,926 126,126 952,452 577,171 797,042 797,042 55,889 217,316 416,319 19,714 92,198 2,987,643 18,845,321 16,000 2,445,219 1,281,745 126,806 3,057,879 109,451 2,489,222 356,819 18,427 250,597 69,186 3,126,469 1,420,620 285,750 1,617,633 410,102 1,277,593 709,086 1,939,241 1,744,808 19,263,037 1,242,835 417,716) 1,115,261 641,895) 641,895) 641,895) 473,366 600,940 55,650 4,300,631 17,196,421 $ 4,901,571 $ 17,252,071 35 CITY OF COLLEYVILLE, TEXAS RECONCILIATION OF THE STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE OF GOVERNMENTAL FUNDS TO THE STATEMENT OF ACTIVITIES FOR THE YEAR ENDED SEPTEMBER 30, 2004 Amounts reported for governmental activities in the Statement of Activities (pages 30 - 31) are different because: Net change in fund balances - total governmental funds (page 34 - 35) 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. 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 (pages 30 - 31) The notes to the financial statements are an integral part of this statement. 36 $ 55,650 2,632,136 27,349) 1,617,633 15,774) $ 4,262,296 CITY OF COLLEYVILLE, TEXAS GENERAL FUND STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL FOR THE YEAR ENDED SEPTEMBER 30, 2004 The notes to the financial statements are an integral part of this statement. 37 CITY OF COLLEYVILLE, TEXAS STATEMENT OF NET ASSETS PROPRIETARY FUNDS SEPTEMBER 30, 2004 Enterprise Funds Water and Drainage Wastewater Utility Totals ASSETS Current assets: Cash and cash equivalents $ 4,398,205 $ 817,757 $ 5,215,962 Investments 9,664,951 672,895 10,337,846 Accounts receivable, net of allowances 1,254,665 76,939 1,331,604 Due from other governments 5, 1 04 5, 1 04 Other assets 265,468 265,468 Inventories 126,342 126,342 Total current assets 15,714,735 1,567,591 17,282,326 Noncurrent assets: Accrued interest receivable 49,018 5,880 54,898 Capital assets: Land 313,057 313,057 Buildings 53,922 53,922 Equipment 760,522 208,822 969,344 Water distribution 46,757,799 2,547,251 49,305,050 Construction in progress 169,057 658,491 827,548 Less: accumulated depreciation 15,665,073) 412,296) 16,077,369) Total capital assets 32,389,284 3,002,268 35,391,552 Total noncurrent assets 32,438,302 3,008,148 35,446,450 Total assets 48,153,037 4,575,739 52,728,776 LIABILITIES Current liabilities: Accounts payable 453,638 36,533 490,171 Accrued liabilities 15,342 2,412 17,754 Accrued interest payable 97,292 14,930 112,222 Advances from developers 6,728 6,728 Escrow funds 1,643 1,643 Customer deposits 366,699 366,699 Compensated absenses 9,327 1,193 10,520 Revenue bonds payable 765,000 145,000 910,000 Total current liabilities 1,715,669 200,068 1,915,737 Long-term liabilities: Compensated absences 37,307 4,786 42,093 Revenue bonds payable 8,160,000 2,515,000 10,675,000 Total long-term liabilities 8,197,307 2,519,786 10,717,093 Total liabilities 9,912,976 2,719,854 12,632,830 NET ASSETS Invested in capital assets, net of related debt 23,464,284 493,148 23,957,432 Restricted for debt service 668,239 668,239 Unrestricted 14,107,538 1,362,737 15,470,275 Total net assets $ 38,240,061 $ 1,855,885 $ 40,095,946 The notes to the financial statements are an integral part of this statement. 38 CITY OF CITY OF COLLEYVILLE, TEXAS STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN FUND NET ASSETS PROPRIETARY FUNDS YEAR ENDED SEPTEMBER 30, 2004 Enterprise Funds Water and Drainage Wastewater Utility Totals OPERATING REVENUES Metered water sales $ 5,732,211 $ $ 5,732,211 Wastewater services charges 2,007,678 2,007,678 Drainage service charges 643,986 643,986 Other charges and services 1,185,053 33,927 1,218,980 Total operating revenues 8,924,942 677,913 9,602,855 OPERATING EXPENSES Personnel services 1,472,700 233,092 1,705,792 Maintenance and contractual services 4,496,368 45,306 4,541,674 Materials and supplies 140,078 33,837 173,915 Miscellaneous expenses 8,132 8,132 Depreciation and amortization 1,326,986 83,215 1,410,201 Total operating expenses 7,444,264 395,450 7,839,714 OPERATING INCOME 1,480,678 282,463 1,763,141 NONOPERATING REVENUES (EXPENSES) Investment earnings 146,362 16,283 162,645 Interest expense and fiscal charges 406,306) 122,263) 528,569) Total nonoperating revenues (expenses) 259,944) 105,980) 365,924) INCOME BEFORE CONTRIBUTIONS AND TRANSFERS 1,220,734 176,483 1,397,217 CAPITAL CONTRIBUTIONS 1,412,990 1,412,990 TRANSFERS OUT 473,366) 473,366) CHANGE IN NET ASSETS 2,160,358 176,483 2,336,841 TOTAL NET ASSETS, BEGINNING 36,079,703 1,679,402 37,759,105 TOTAL NET ASSETS, ENDING $ 38,240,061 $ 1,855,885 $ 40,095,946 The notes to the financial statements are an integral part of this statement. 39 CITY OF COLLEYVILLE, TEXAS STATEMENT OF CASH FLOWS PROPRIETARY FUNDS YEAR ENDED SEPTEMBER 30, 2004 Enterprise Funds Water and Drainage Wastewater Utility Totals CASH FLOWS FROM OPERATING ACTIVITIES Cash received from customers $ 8,907,902 $ 678,201 $ 9,586,103 Cash paid to suppliers for goods and services ( 4,664,532) ( 118,762) ( 4,783,294) Cash paid to employees for services ( 1,312,130) ( 233,718) ( 1,545,848) Net cash provided by operating activities 2,931,240 325,721 3,256,961 CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES Transfers out 473,366) 473,366) Payments from other funds Net cash used for noncapital financing activities 473,366) 473,366) CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES Acquisition of capital assets 820,466) 209,795) 1,030,261 ) Capital grants and contributions 1,412,990 1,412,990 Proceeds from debt issues 1,710,000 1,710,000 Principal paid on debt 2,390,000) 140,000) 2,530,000) Interest paid on debt 406,306) 122,263) 528,569) Net cash used for capital and related financing activities 493,782) 472,058) 965,840) CASH FLOWS FROM INVESTING ACTIVITIES Purchase (sale) of investments 535,960) 32,467) 568,427) Earnings on investments 146,362 16,283 162,645 Net cash used for investing activities 389,598) 16,184) 405,782) NET INCREASE (DECREASE) IN CASH AND CASH EQUIV ALENTS 1,574,494 162,521) 1,411,973 CASH AND CASH EQUIV ALENTS, BEGINNING 2,823,711 980,278 3,803,989 CASH AND CASH EQUIV ALENTS, ENDING $ 4,398,205 $ 817,757 $ 5,215,962 ( continued) 40 CITY OF COLLEYVILLE, TEXAS STATEMENT OF CASH FLOWS PROPRIETARY FUNDS (Continued) YEAR ENDED SEPTEMBER 30, 2004 Enterprise Funds Water and Drainage Wastewater Utility Totals Reconciliation of operating income (loss) to net cash provided (used) by operating activities: Operating income $ 1,480,678 $ 282,463 $ 1,763,141 Adjustments to reconcile operating income (loss) to net cash provided by (used for) operating activities: Depreciation and amortization expense 1,326,986 83,215 1,410,201 Changes in assets and liabilities: Decrease (increase) in assets: Accounts receivable 4,864 524 5,388 Due from other funds Due from other governments 5, 1 04) 5, 1 04) Inventory 32,310 32,310 Accrued interest receivable Other assets 46,115 46,115 Increase (decrease) in liabilities: Accounts payable 43,769 35,818) 7,951 Accrued liabilities 23,815) 4,545) 28,360) Compensated absences payable 9,167 626 9,793 Customer deposits 16,270 16,270 Advances from developers Accrued interest payable 744) 744) Escrow funds Net cash provided by operations $ 2,931,240 $ 325,721 $ 3,256,961 Noncash investing, capital, and financing activities: Contributions of capital assets $ 1,412,990 $ $ 1,412,990 The notes to the financial statements are an integral part of this statement. 41 CITY OF COLLEYVILLE, TEXAS STATEMENT OF FIDUCIARY NET ASSETS FIDUCIARY FUNDS SEPTEMBER 30, 2004 Agency Funds ASSETS Cash and investments $ 4,368 Total assets $ 4,368 LIABILITIES Due to other agencies and individuals $ 4,368 T otalliabilities $ 4,368 The notes to the financial statements are an integral part of this statement. 42 CITY OF COLLEYVILLE, TEXAS NOTES TO FINANCIAL STATEMENTS SEPTEMBER 30, 2004 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. ReDortin2 Entity 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 CEDC 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) 43 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) A. ReDortin2 Entity (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 six-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. Directly 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 nine-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 government-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-like 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) 44 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) C. Measurement Focus.. Basis of Accountin2 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. 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 has 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) 45 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) C. Measurement Focus.. Basis of Accountin2 and Financial Statement Presentation (Continued) GOVERNMENTAL FUNDS (Continued) The Caoital 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. 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. 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. ( continued) 46 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) C. Measurement Focus.. Basis Of Accountin2 and Financial Statement Presentation (Continued) 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-like 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 government- 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 Eauivalents 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) 47 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, 2004. 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) 48 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) H. Capital 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. Compensated 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) 49 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) K. Lon2-term Obli2ations 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. For 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 Eauitv Reservations of fund balance represent amounts that are not available for appropriation or are legally segregated for specific purposes. Reservations of retained earnings 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 general purpose financial statements as reserved for other. M. Risk Mana2ement 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. 50 2. RECONCILIATION OF GOVERNMENT -WIDE AND FUND FINANCIAL STATEMENTS 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 $(27,053,767) difference are as follows: Serial Bonds and Certificates of Obligation Accrued interest payable Compensated absences Principal retirement Net adjustment to reduce fund balance - total governmental funds to arrive at net assets - governmental activities $( 28,409,792) ( 264,892) 3,284 1,617,633 $( 27,053,767) Explanation of Certain Differences Between the Governmental Fund Statement of Revenue.. Expenditures and Chan2es 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 $2,632,136 difference are as follows: Capital outlay Depreciation expense Net adjustment to increase net changes infund balances- total governmental funds to arrive at changes in net assets of governmental activities $ 4,601,206 ( 1,969,070) $ 2,632,136 ( continued) 51 2. RECONCILIATION OF GOVERNMENT -WIDE AND FUND FINANCIAL STATEMENTS (Continued) Exolanation of Certain Differences Between the Governmental Fund Statement of Revenue.. Exoenditures and Chan2es 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 $(35,018) difference are as follows: Property taxes Ambulance revenue Adjudicated fines Net adjustment to increase net changes infund balances - total governmental funds to arrive at changes in net assets of governmental activities $( ( 34,617) 905) 504 $( 35,018) 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 $1,617,633 difference are as follows: Principal payments Net adjustment to reduce fund balance -total governmental funds to arrive at net assets - governmental activities $ 1,617,633 $ 1,617,633 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 $(15,774) difference are as follows: Compensated absences Accrued interest Loss on sale of assets Net adjustment to decrease net changes infund balances - total governmental funds to arrive at changes in net assets of governmental activities 52 $ ( ( 3,284 13,232) 5,826) $( 15,774) 3. STEWARDSHIP, COMPLIANCE AND ACCOUNTABILITY A. Bud2etarv 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, 2004. (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 Debt Service Fund expenditures exceeded appropriations by $138,662. The City plans to fund this through available fund balance. ( continued) 53 3. STEWARDSHIP, COMPLIANCE AND ACCOUNTABILITY A. Bud2etarv 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. Deficit Net Assets The City's component unit, the Tax Increment Financing District, has negative net assets of $(7,672,213). This deficit is due to the conversion to the new reporting model GASB No. 34. The component unit has long-term debt with no capital assets. Purchases made by this fund are contributed to the City or other entities that participate in the District. This fund will continue to have a deficit fund balance until the entities' debt has been repaid. 4. DETAILED NOTES ON ALL FUNDS Deoosits and Investments Substantially all cash, cash equivalents and investments are maintained in consolidated cash and investment accounts. Interest income relating to consolidated cash, cash equivalents and investments is allocated to the individual funds monthly based on each fund's prorate share of total consolidated cash, cash equivalents and investments. Legal provisions generally permit the City to invest in certificates of deposit, repurchase agreements, public funds investment pools, direct obligations of the United States of America or its subdivisions and state and local government securities. During the year ended September 30, 2004, the City did not own any types of securities other than those permitted by statute. The City's cash deposits are categorized to give an indication of the level of credit risk assumed by the City at year-end. Category 1 includes cash deposits that are insured or collateralized with securities held by the City or its agent in the City's name. Category 2 includes cash deposits that are collateralized with securities held by the pledging financial institution's trust department or agent in the City's name. Category 3 includes cash deposits that are uncollateralized, including any cash deposit that is collateralized with securities held by the pledging financial institution's trust department or agent, but not in the City's name. At September 30, 2004, the carrying amount of the City's cash deposits (primarily interest bearing deposits) was $486,870 and the bank balance was $1,204,733. The entire bank balance qualified as Category 1. ( continued) 54 4. DETAILED NOTES ON ALL FUNDS (Continued) Deoosits and Investments (Continued) During the year ended September 30, 2004, the City invested in Texas Local Government Investment Cooperative (LOGIC) Liquid Asset Portfolio and United States government agency securities. LOGIC, a public funds investment pool managed by Southwest Securities Group, Inc. Authorized investments of LOGIC include obligations of the United States of America or its agencies and instrumentalities, other obligations unconditionally guaranteed by the U. S. government, and collateralized repurchase agreements. The fair value of the City's position in the investment pool is the same as the value of the pool shares. At September 30, 2004, the City's investments in LOGIC are considered cash equivalents. These investments in LOGIC are not categorized because they are not evidenced by securities that exist in physical or book entry form. The City's investments are categorized to given an indication of the level of credit risk assumed by the City at year-end. Category 1 includes investments that are insured or registered for which the securities are held by the City or its agent in the City's name. Category 2 includes uninsured and unregistered investments for which the securities are held by the counterparty's trust department or agent in the City's name. Category 3 includes uninsured and unregistered investments for which the securities are held by the counterparty, or by its trust department or agent but not in the City's name. All of the City's investments at September 30, 2004, were Category 1 investments. Investments in the United States government agency securities are considered to be short-term and are stated at cost and all such investment activity is conducted through a depository bank. During the fiscal year ended September 30, 2004, the City did not invest through any security brokers or dealers. All investments in United States government agency securities qualified as Category 1. A summary of the City's cash, cash equivalents and investments follows: Cash and cash equivalents, net Carrying Fair Amount Value $ 486,870 $ 486,870 10,373,130 10,373,130 10,860,000 10,860,000 24,699,884 24,699,884 $ 35,559,884 $ 35,559,884 equivalents and investments, respectively, Cash in bank LOGIC Investments - United States government agency security $2,354,052 and $199,006 of total cash and cash represents the City's component units' portion. 55 4. DETAILED NOTES ON ALL FUNDS (Continued) 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 $ 211,771 $ $ 38,426 $ $ 1,277,829 $ 76,939 $ 1,604,965 Taxes 123,732 31,143 154,875 Due from other governments 378,709 3,542 333,929 5, 1 04 721,284 Accrued interest 58,435 4,942 13,068 25,745 49,018 5,880 157,088 Gross receivables 772,647 39,627 51,494 359,674 1,331,951 82,819 2,638,212 Less: allowance for uncollectibles 135,532) 23,164) 158,696) Net Total Receivables $ 637,115 $ 39,627 $ 51,494 $ 359,674 $ 1,308,787 $ 82,819 $ 2,479,516 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 $ 123,732 20,804 144,536 $ Debt Service Fund Delinquent property taxes receivable Total Debt Service Fund Total Governmental Funds 31,143 31,143 175,679 $ $ 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 2004 levy was based, was $8,719,444. 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, 2004, was $.3474 per $100 of assessed valuation. ( continued) 56 4. DETAILED NOTES ON ALL FUNDS (Continued) Receivables (Continued) Taxes are due by January 31 following the levy date. Tax collections, including related penalties and interest, for the year ended September 30, 2004. Property taxes receivable at September 30,2004, were $154,875. 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. Capital Assets Capital asset activity for the year ended September 30, 2004, was as follows: Primary Government Beginning Ending Balance Increases Decreases Adjustment Balance Governmental activities: Capital assets, not being depreciated: Land $ 6,360,180 $ $ $ $ 6,360,180 Construction in progress 21,783,326 2,039,320 ( 154,322) 23,668,324 Total assets not being depreciated 28,143,506 2,039,320 ( 154,322) 30,028,504 Capital assets, being depreciated: Buildings and improvements 12,775,932 6,082 12,782,014 Machinery and equipment 4,609,685 283,874 74,846 4,818,713 Infrastructure 54,402,230 2,271,929 56,674,159 Total capital assets being depreciated 71,787,847 2,561,885 74,846 74,274,886 Less accumulated depreciation: Buildings and improvements 3,237,846 513,499 3,751,345 Machinery and equipment 4,035,878 322,088 69,026 4,288,940 Improements other than buildings 8,742,976 1,133,483 9,876,459 Total accumulated depreciation 16,016,700 1,969,070 69,026 17,916,744 Total capital assets being depreciated, net 55,771,147 592,815 5,820 56,358,142 Governmental activities capital assets, net $ 83,914,653 $ 2,632,135 $ 5,820 $( 154,322) $ 86,386,646 The adjustment column represents the prior period adjustment in the government-wide financial statements governmental activities and was due to an error in prior year construction progress. ( continued) 57 4. DETAILED NOTES ON ALL FUNDS (Continued) Caoital Assets (Continued) Beginning Ending Balance Increases Decreases Balance Business-type activities: Capital assets, not being depreciated: Land $ 313,057 $ $ $ 313,057 Construction in progress 934,168 104,728 211,348 827,548 Total assets not being depreciated 1,247,225 104,728 211,348 1,140,605 Capital assets, being depreciated: Buildings and improvements 53,922 53,922 Machinery and equipment 977,481 18,163 26,300 969,344 Improvements other than buildings 47,324,063 1,980,987 49,305,050 Total capital assets being depreciated 48,355,466 1,999,150 26,300 50,328,316 Less accumulated depreciation: Buildings and improvements 41,461 817 42,278 Machinery and equipment 711,736 80,467 26,300 765,903 Improvements other than buildings 14,004,241 1,264,947 15,269,188 Total accumulated depreciation 14,757,438 1,346,231 26,300 16,077,369 Total capital assets being depreciated, net 33,598,028 652,919 34,250,947 Business-type activities capital assets, net $ 34,845,253 $ 757,647 $ 211,348 $ 35,391,552 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 $ 97,274 88,072 464,644 7,457 1,141,978 169,645 Total depreciation expense - governmental activities $ 1,969,070 Business-type activities: Water and wastewater Drainage utility $ 1,263,016 83,215 Total depreciation expense - business-type activities $ 1,346,231 ( continued) 58 4. DETAILED NOTES ON ALL FUNDS (Continued) Caoital Assets (Continued) Construction Commitments The government has active construction projects as of September 30, 2004. The major projects consist of a building project that will house the new City Hall facilities as well as a new library. At the end, the City's commitments with contractors were as follows: Remaining Project Spent - to-date Commitment City Hall and Library $ 5,947,747 $ 17,448 Sneed 416,422 16,942 Cottonbelt Trail 714,237 33,340 $ 7,078,406 $ 67,730 Interfund Total Transfers The composition of interfund balances as of September 30, 2004, is as follows: Transfer In Debt General Service Total Transfer Out: Nonmajor Governmental Funds $ $ 641,895 $ 641,895 Water and Wastewater Fund 473,366 473,366 Total Transfers Out $ 473,366 $ 641,895 $ 1,115,261 The transfer of $473,366 from the Utility Fund to the General Fund represents the 2004 Administrative transfer and the franchise fee based on gross water and wastewater revenue of the prior year's audited financial statements. The remaining transfer of $641,895 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. ( continued) 59 4. DETAILED NOTES ON ALL FUNDS (Continued) Lon2-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 $18,785,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.6% - 7% $ 23,302,722 $ 23,302,722 Long-term liability activity for the year ended September 30, 2004, was a follows: Balance Balance Amounts October 1, September 30, Due Within 2003 Additions Retirements 2004 One Year Governmental activities General obligation bonds and certificates of obligation $ 13,820,000 $ $ 895,000 $ 12,925,000 $ 930,000 Sales tax revenue bonds 13,937,722 560,000 13,377,722 590,000 Capital lease obligations 30,894 30,894 Note payable 160,047 131,739 28,308 28,308 Compensated absences 461,129 297,570 300,854 457,845 91,570 Accreted interest 80,424 28,014 108,438 Total governmental activities 28,490,216 325,584 1,918,487 26,897,313 1,639,878 Business-tvpe activities Revenue bonds and certificates of obligation 12,405,000 1,710,000 2,530,000 11,585,000 910,000 Compensated absences 42,820 34,199 24,406 52,613 10,520 Total business-type activities 12,447,820 1,744,199 2,554,406 11,637,613 920,520 Total primary government $ 40,938,036 $ 2,069,783 $ 4,472,893 $ 38,534,926 $ 2,560,398 Component unit: Tax Increment Financing Fund Revenue Bonds 10,860,000 695,000 10,165,000 730,000 Total component unit $ 10,860,000 $ $ 695,000 $ 10,165,000 $ 730,000 For the governmental activities, compensated absences are generally liquidated by the General Fund. ( continued) 60 4. DETAILED NOTES ON ALL FUNDS (Continued) Lon2-term Liabilities (Continued) Governmental Activities long-term liabilities at September 30, 2004, consisted of the following: General obligation bonds and certificates of obligation serviced by property tax revenue: $4,515,000 Series 1994 General Obligation Refunding and Improvement Bonds due in annual installments of $115,000 to $405,000 through February 1,2013; interest at 3.60% to 5.60%. $ 1,130,000 $2,205,000 Series 1996 General Obligation Bonds due in annual installments of $75,000 to $170,000 through February 15, 2016; interest at 3.75% to 5.80%. 195,000 $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%. 425,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%. 8,175,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%. 3,000,000 Total General Obligation Bonds and Certificates of Obligation $ 12,925,000 Revenue bonds serviced by sales tax revenue: $6,460,000 Series 1997 Colleyville Economic Development Corporation Sales Tax Revenue Bonds due in annual installments of $150,000 to $480,000 through February 15, 2022; interest at 5.00% to 7.00%. $ 5,525,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%. 5,790,000 $2,122,722 Series 2000 Colleyville Economic Development Corporation Sales Tax Revenue Bonds due in annual installments through February 15, 2027; interest at 5.50% to 6.250%. 2,062,722 Total Revenue Bonds $ 13,377,722 Notes payable: Note payable served by property taxes; $108,144 note payable due in various annual installments plus interest; interest rate at 5.4%. $ 28,308 Total Notes Payable $ 28,308 ( continued) 61 4. DETAILED NOTES ON ALL FUNDS (Continued) Lon2-term Liabilities (Continued) The funds utilized for the repayment of long-term liabilities for governmental activities are the Debt Service Fund and the Crime District Fund. In years past, the City has issued refunding bonds. As a result, the refunded debt is considered to be defeased and the liability has been removed from the books. The City's defeased debt as of September 30, 2004, was $3,320,000. Business-type Activities long-term liabilities at September 30, 2004, 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%. $ 2,590,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%. 2,240,000 $2,580,000 Series 2002 Waterworks 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,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%. 2,385,000 1,710,000 Total Water and Wastewater Fund $ 8,925,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%. Total Drainage Utility Fund $ $ 2,660,000 2,660,000 Total Business-type activities $ 11,585,000 In years past, the City has issued refunding bonds. As a result, the refunded debt is considered to be defeased and the liability has been removed from the books. The City's defeased debt as of September 30,2004, was $1,065,000. In the current fiscal year, the City refunded bonds that were callable. This refunding did not result in an economic gain or loss. ( continued) 62 4. DETAILED NOTES ON ALL FUNDS (Continued) Lon2-term Liabilities (Continued) The ordinances authorizing the issuance of Waterworks 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, 2004, the City was in compliance with these requirements. The City's component unit, the Tax Increment Financing District, long-term liabilities at September 30, 2004, consisted of the following: Tax Increment Financing District $2,895,000 Series 2000 Tax Notes due in installments of $670,000 to $780,000 beginning in 2004 through February 15, 2007; interest at 4.95% to 5.20%. $ 2,225,000 $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%. 655,000 $7,285,000 Series 2001 Tax Notes due in installments of $350,000 to $66,000 beginning in 2006 through February 15,2020; interest at 4.30% to 5.00%. 7,285,000 Total Tax Increment Financing District Governmental Activities General Obligation Bonds and Certificates of Obligation Revenue Bonds September 30, Principal Interest Principal Interest 2005 $ 930,000 $ 543,453 $ 590,000 $ 652,090 2006 1,330,000 495,440 505,000 622,408 2007 1,400,000 437,915 525,000 596,818 2008 1,470,000 377,986 550,000 572,223 2009 1,535,000 314,773 575,000 572,223 2010-2014 5,190,000 745,702 3,355,000 2,277,103 2015-2019 900,000 149,539 4,340,000 1,327,508 2020-2024 170,000 3,995 2,610,000 401,350 2025-2029 327,722 1,487,277 $ 12,925,000 $ 3,068,803 $ 13,377,722 $ 8,509,000 $ 10,165,000 Notes Payable Principal Interest $ 28,308 $ 719 $ 28,308 $ 719 ( continued) 63 Business- Type Activities Revenue Bonds September 30, Principal Interest 2005 $ 910,000 $ 487,187 2006 945,000 446,830 2007 985,000 407,372 2008 865,000 369,465 2009 810,000 335,902 2010-2014 4,650,000 1,125,835 2015-2019 2,165,000 267,001 2020-2024 255,000 12,875 $ 11,585,000 $ 3,452,467 4. DETAILED NOTES ON ALL FUNDS (Continued) Lon2-term Liabilities (Continued) Discretely Presented Component Unit- Tax Increment Financing Fund September 30, Revenue Bonds Principal Interest 2005 2006 2007 2008 2009 2010-2014 2015-2019 2020-2024 $ 730,000 1,120,000 1,175,000 410,000 430,000 2,465,000 3,115,000 720,000 $ 10,165,000 ( continued) 64 $ 466,824 421,435 365,620 327,660 308,665 1,232,027 580,403 17,970 $ 3,720,604 4. DETAILED NOTES ON ALL FUNDS (Continued) Emolovees' Retirement System Plan Description The City provides pension benefits for all of its full time employees through a nontraditional, joint contributory, hybrid defined benefit plan in the statewide Texas Municipal Retirement System (TMRS), one of 794 administered by TMRS, an agent multiple-employer public employee retirement system. Benefits depend upon the sum of the employee's contributions to the plan, with interest, and the City-financed monetary credits, with interest. At the date the plan began, the City granted monetary credits for service rendered before the plan began of a theoretical amount equal to two times what would have been contributed by the employee, with interest, prior to establishment of the plan. Monetary credits for service since the plan began are a percent (100%,150%, or 200%) of the employee's accumulated contributions. In addition, the City can grant, as often as annually, another type of monetary credit referred to as an updated service credit which is a theoretical amount which, when added to the employee's accumulated contributions and the monetary credits for service since the plan began, would be the total monetary credits and employee contributions accumulated with interest if the current employee contribution rate and City matching percent had always been in existence and if the employee's salary had always been the average of his salary in the last three years that are one year before the effective date. At retirement, the benefit is calculated as if the sum of the employee's accumulated contributions with interest and the employer-financed monetary credits with interest were used to purchase an annuity. Members can retire at ages 60 and above with 5 or more years of service or with 20 years of service regardless of age. A member is vested after 5 years. The plan provisions are adopted by the governing body of the City, within the options available in the state statutes governing TMRS and within the actuarial constraints also in the statutes. TMRS issues a publicly available annual financial report that includes financial statements and required supplementary information. The report may be obtained by writing to TMRS, P. O. Box 149153, Austin, Texas 78714-9153. ( continued) 65 4. DETAILED NOTES ON ALL FUNDS (Continued) Contributions The contribution rate for the employees is 7%, and the City matching percent is currently 200%, both as adopted by the governing body of the City. Under the state law governing TMRS, the actuary annually determines the City contribution rate. This rate consists of the normal cost contribution rate and the prior service cost contribution rate, both of which are calculated to be a level percent of payroll from year to year. The normal cost contribution rate finances the currently accruing monetary credits due to the City matching percent, which are the obligation of the City as of an employee's retirement date, not at the time the employee's contributions are made. The normal cost contribution rate is the actuarially determined percent of payroll necessary to satisfy the obligation of the City to each employee at the time his/her retirement becomes effective. The prior service contribution rate amortizes the unfunded (overfunded) actuarial liability (asset) over the remainder of the plan's 25-year amortization period. The unit credit actuarial cost method is used for determining the City contribution rate. Contributions are made monthly by both the employees and the City. 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. Schedule of Actuarial Liabilities and Funding Progress Actual valuation date Actuarial value of assets Actuarial accrued liability Percentage funded Unfunded (over-funded) actuarial accrued liability (UAAL) Annual covered payroll UAAL as a percentage of covered payroll Net pension obligation (NPO) at the beginning of period Annual Pension Cost: Annual required contribution (ARC) Contributions made Increase in NPO NPO at the end of period 12/31/03 12/31/02 12/31/01 $ 15,892,324 $ 13,959,261 $ 12,000,548 19,889,831 17,190,512 13,378,986 79.9% 81.2% 89.7% 3,997,507 3,231,251 1,378,438 7,482,837 7,071,220 7,195,064 53.4% 45.7% 19.2% 973,844 973,844 864,108 864,108 740,452 740,452 ( continued) 66 4. DETAILED NOTES ON ALL FUNDS (Continued) Contributions (Continued) Actuarial Assumotions Actuarial Cost Method Amortization Method Remaining Amortization Period Asset Valuation Method Unit Credit Level percent of Payroll 25 Years - Open Period Amortized Cost (to accurately reflect the requirements of GASB Statement No. 25, paragraphs 36e and 138) Investment Rate of Return Proj ected Salary Increases Includes Inflation At Cost-of-Living Adjustments 7% None None None 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 2015 and 2025. 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 ofTRA'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 2004 amounted to approximately $3,165,222 and $958,005, respectively. Advances from Develooers Developers are required by ordinance to construct perimeter streets and related storm drainage facilities. The developer may request a waver 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, 2004, developers had escrowed $271,835 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) 67 4. DETAILED NOTES ON ALL FUNDS (Continued) Risk Financin2 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. Prior Period Adjustment In the government-wide financial statements, there is a prior period adjustment of $(154,319) in the governmental activities. This was due to capitalizing assets previously recorded as construction in progress. 68 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 Center Development - This fund is used to account for contributions received to construct a community center. 69 Recycling - This fund is used to account for the promotion of recycling activities in the City of Colleyville. 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. 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 Kidsville 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. TDPA Grant - This fund is used to account for grant proceeds received for the acquisition of equipment and expenditures relating to fires and rescue. 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. 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. 70 THIS PAGE INTENTIONALLY LEFT BLANK 71 CITY OF COLLEYVILLE, TEXAS COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS SEPTEMBER 30, 2004 Special Revenue Funds Police Voluntary Voluntary Asset Tree Library Park Library Forfeiture Preservation Donation ASSETS Cash and cash equivalents $ 2,220 $ 4,610 $ 2,984 $ 35,827 $ 75,634 Investments 567,620 307,476 Due from other governments Accrued interest 6,085 1,882 Total assets $ 575,925 $ 313,968 $ 2,984 $ 35,827 $ 75,634 LIABILITIES Accounts payable $ $ $ $ $ Advances from developers 30,623 Total liabilities 30,623 FUND BALANCES Special revenue funds 575,925 313,968 2,984 5,204 75,634 Capital proj ect funds Total fund balances 575,925 313,968 2,984 5,204 75,634 Total liabilities and fund balances $ 575,925 $ 313,968 $ 2,984 $ 35,827 $ 75,634 72 Special Revenue Funds Community Colleyville Recreational Center Economic Crime Kidsville Event Development Recycling LEOSE Development District Maintenance $ 8,138 $ 23,13 1 $ 5,490 $ 18,378 $ 423,934 $ 425,203 $ 24,298 498,196 180,109 148,791 4,288 $ 8,138 $ 23, 13 1 $ 5,490 $ 18,378 $ 1,106,527 $ 573,994 $ 24,298 $ $ $ 3,796 $ $ $ 298,037 $ 3,796 298,037 8,138 23,13 1 1,694 18,378 1,106,527 275,957 24,298 8,138 23, 13 1 1,694 18,378 1,106,527 275,957 24,298 $ 8,138 $ 23, 13 1 $ 5,490 $ 18,378 $ 1,106,527 $ 573,994 $ 24,298 ( continued) 73 CITY OF COLLEYVILLE, TEXAS COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS (Continued) SEPTEMBER 30, 2004 Special Revenue Funds Total Nonmajor Special Court Court TDPA Special Revenue Donations Technology Security Grant Funds ASSETS Cash and cash equivalents $ 27,972 $ 5,113 $ 20,406 $ $ 1,103,338 Investments 1,373,292 Due from other governments 328,900 Accrued interest 12,255 Total assets $ 27,972 $ 5,113 $ 20,406 $ $ 2,817,785 LIABILITIES Accounts payable $ $ $ $ $ 301,833 Advances from developers 30,623 Total liabilities 332,456 FUND BALANCES Special revenue funds 27,972 5,113 20,406 2,485,329 Capital proj ect funds Total fund balances 27,972 5,113 20,406 2,485,329 Total liabilities and fund balances $ 27,972 $ 5,113 $ 20,406 $ $ 2,817,785 74 Capital Proj ect Funds Total CEDC Nonmajor Total Parkland Capital Kimzey Capital Proj ect Nonmajor Dedication Proj ect Park Funds Funds $ 8,863 $ 541,772 $ 14,736 $ 565,371 $ 1,668,709 1,868,064 1,868,064 3,241,356 5,029 5,029 333,929 13,490 13,490 25,745 $ 1,895,446 $ 541,772 $ 14,736 $ 2,451,954 $ 5,269,739 $ 35,712 $ $ $ 35,712 $ 337,545 30,623 35,712 35,712 368,168 2,485,329 1,859,734 541,772 14,736 2,416,242 2,416,242 1,859,734 541,772 14,736 2,416,242 4,901,571 $ 1,895,446 $ 541,772 $ 14,736 $ 2,451,954 $ 5,269,739 75 CITY OF COLLEYVILLE, TEXAS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES NONMAJOR GOVERNMENTAL FUNDS FOR THE YEAR ENDED SEPTEMBER 30, 2004 Special Revenue Funds Police Voluntary Voluntary Asset Tree Library Park Library Forfeiture Preservation Donation REVENUES Taxes $ $ $ $ $ Intergovernmental 2,878 Fines and forfeitures Charges for services 126,126 Donations 103 63,063 136,201 Investment earnings 7,250 4,343 Other Total revenues 133,479 67,406 139,079 EXPENDITURES Current: General government F ire and rescue Leisure services 24,048 19,013 64,249 Municipal court Police Debt service: Principal retirement Interest and fiscal charges Capital outlay 41,236 102,250 Total expenditures 65,284 19,013 166,499 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 68,195 48,393 27,420) OTHER FINANCING SOURCES (USES) Transfers out Total other financing sources and (uses) NET CHANGE IN FUND BALANCES 68,195 48,393 27,420) FUND BALANCES, BEGINNING 507,730 265,575 2,984 5,204 103,054 FUND BALANCES, ENDING $ 575,925 $ 313,968 $ 2,984 $ 5,204 $ 75,634 76 Special Revenue Funds Community Colleyville Recreational Center Economic Crime Kidsville Event Development Recycling LEOSE Development District Maintenance $ $ $ $ $ 873,626 $ 758,133 $ 5,127 2,175 5,824 8,818) 5,127 2,175 16,000 16,000 3,714 3,714 879,450 749,315 ( 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, 2004 Special Revenue Funds Total Nonmajor Special Court Court TDPA Special Revenue Donations Technology Security Grant Funds REVENUES Taxes $ $ $ $ $ 1,631,759 Intergovernmental 200,063 202,941 Fines and forfeitures 14,507 14,566 29,073 Charges for services 126,126 Donations 1,554 208,223 Investment earnings 8,599 Other 19,714 Total revenues 1,554 14,507 14,566 200,063 2,226,435 EXPENDITURES Current: General government 16,000 F ire and rescue 126,806 126,806 Leisure services 341 109,451 Municipal court 11,748 6,679 18,427 Police 69,186 Debt service: Principal retirement 195,000 Interest and fiscal charges 406,472 Capital outlay 73,257 241,680 Total expenditures 341 11,748 6,679 200,063 1,183,022 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 1,213 2,759 7,887 1,043,413 OTHER FINANCING SOURCES (USES) Transfers out 641,895) Total other financing sources and (uses) 641,895) NET CHANGE IN FUND BALANCES 1,213 2,759 7,887 401,518 FUND BALANCES, BEGINNING 26,759 2,354 12,519 2,083,811 FUND BALANCES, ENDING $ 27,972 $ 5,113 $ 20,406 $ $ 2,485,329 78 Capital Proj ect Funds Total CEDC Nonmajor Total Parkland Capital Kimzey Capital Proj ect Nonmajor Dedication Proj ect Park Funds Funds $ $ $ $ $ 1,631,759 125,099 125,099 328,040 29,073 126,126 588,819 588,819 797,042 36,438 10,852 47,290 55,889 19,714 750,356 10,852 761,208 2,987,643 16,000 126,806 109,451 18,427 69,186 90,750 90,750 285,750 3,630 3,630 410,102 114,190 353,216 467,406 709,086 114,190 447,596 561,786 1,744,808 636,166 436,744) 199,422 1,242,835 641,895) 641,895) 636,166 436,744) 199,422 600,940 1,223,568 978,516 14,736 2,216,820 4,300,631 $ 1,859,734 $ 541,772 $ 14,736 $ 2,416,242 $ 4,901,571 79 CITY OF COLLEYVILLE, TEXAS DEBT SERVICE FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL FOR THE YEAR ENDED SEPTEMBER 30, 2004 80 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. 81 CITY OF COLLEYVILLE, TEXAS COMBINING STATEMENT OF FIDUCIARY NET ASSETS AGENCY FUNDS SEPTEMBER 30, 2004 Employee Activity Sesquicentennial Fund Fund Total ASSETS Cash and cash equivalents $ 2,074 $ 2,294 $ 4,368 Total assets $ 2,074 $ 2,294 $ 4,368 LIABILITIES Due to other agencies and individuals $ 2,074 $ 2,294 $ 4,368 T otalliabilities $ 2,074 $ 2,294 $ 4,368 82 CITY OF COLLEYVILLE, TEXAS COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES AGENCY FUNDS YEAR ENDED SEPTEMBER 30, 2004 Employee Activity Fund Balance Balance 1 % 1/03 Additions Deletions 09/30/04 Cash and cash equivalents $ 1,915 $ 3,073 $ 2,914 $ 2,074 Total assets $ 1,915 $ 3,073 $ 2,914 $ 2,074 Due to other agencies and individuals $ 1,915 $ 3,073 $ 2,914 $ 2,074 T otalliabilities $ 1,915 $ 3,073 $ 2,914 $ 2,074 Sesquicentennial Fund Balance Balance 1 % 1/03 Additions Deletions 09/30/04 Cash and cash equivalents $ 2,044 $ 2,294 $ 2,044 $ 2,294 Total assets $ 2,044 $ 2,294 $ 2,044 $ 2,294 Due to other agencies and individuals $ 2,044 $ 2,294 $ 2,044 $ 2,294 T otalliabilities $ 2,044 $ 2,294 $ 2,044 $ 2,294 Total Agency Funds Balance Balance 1 % 1/03 Additions Deletions 09/30/04 Cash and cash equivalents $ 3,959 $ 5,367 $ 4,958 $ 4,368 Total assets $ 3,959 $ 5,367 $ 4,958 $ 4,368 Due to other agencies and individuals $ 3,959 $ 5,367 $ 4,958 $ 4,368 T otalliabilities $ 3,959 $ 5,367 $ 4,958 $ 4,368 83 THIS PAGE INTENTIONALLY LEFT BLANK 84 STATISTICAL SECTION 85 CITY OF COLLEYVILLE, TEXAS GENERAL GOVERNMENTAL EXPENDITURES BY FUNCTION LAST TEN FISCAL YEARS (UNAUDITED) Community Fiscal General Development Fire and Leisure Municipal Year Government and Engineering Rescue Services Maintenance Court 1995 $ 948,638 $ 772,827 $ 939,541 $ 491,266 $ 89,751 $ 63,635 1996 1,354,952 788,195 1,380,287 597,757 91,831 84,018 1997 1,219,562 813,136 1,283,509 585,805 103,521 81,924 1998 1,674,400 928,845 1,446,339 756,356 121,628 90,060 1999 1,687,141 1,071,373 2,153,203 1,002,355 138,697 102,204 2000 2,032,011 1,229,405 2,307,966 1,045,624 132,520 105,375 2001 1,936,372 1,335,758 2,852,223 1,625,850 125,049 118,219 2002 1,925,674 1,226,877 2,783,968 1,665,598 182,814 150,056 2003 1,469,725 1,274,096 2,826,218 1,846,787 162,865 234,180 2004 1,596,990 1,281,745 3,057,879 2,076,964 356,819 250,597 Note: Includes General, Special Revenue and Debt Service Funds. 86 TABLE 1 Streets and Debt Capital Police Drainage Service Outlay Totals $ 1,523,665 $ 988,442 $ 1,085,980 $ 272,618 $ 7,176,363 1,639,642 1,059,242 1,545,305 441 , 121 8,982,350 1,805,924 1,522,489 2,003,854 224,595 9,644,319 1,924,456 1,643,967 2,070,234 539,735 11,196,020 3,438,183 1,383,782 2,269,543 202,154 13,448,635 2,597,915 1,618,551 3,075,557 20,171 14,165,095 4,122,612 1,408,092 3,189,490 208,396 16,922,061 6,711,870 1,239,090 3,210,409 603,955 19,700,311 3,331,861 1,092,703 3,004,769 2,058,650 17,301,854 3,126,469 1,420,620 2,800,846 854,820 16,823,749 87 CITY OF COLLEYVILLE, TEXAS GENERAL GOVERNMENTAL REVENUE BY SOURCE LAST TEN FISCAL YEARS (UNAUDITED) Engineering, Licenses Inspection Donations Fiscal and Fines and and Other and Year Taxes Permits Forfeitures Charges Contributions 1995 $ 6,064,309 $ 401,480 $ 279,321 $ 61,555 $ 212,038 1996 6,880,942 417,941 371,183 89,756 194,554 1997 7,808,425 489,185 341,211 87,338 141,250 1998 8,689,822 596,502 406,292 252,649 360,488 1999 9,363,995 852,489 472,120 307,483 274,928 2000 10,612,927 1,161,363 574,769 533,665 173,934 2001 11,170,915 855,255 557,439 311,991 184,607 2002 12,296,418 913,426 534,590 464,515 206,358 2003 12,596,779 926,083 509,395 915,694 251,754 2004 13,438,345 1,505,512 520,926 952,452 411 , 164 Note: Includes General, Special Revenue and Debt Service Funds. 88 TABLE 2 Investment Developer Earnings Contributions Other Totals $ 281,731 $ 482 $ 201,743 $ 7,502,659 378,426 8,447 212,046 8,553,295 403,773 1,173 285,732 9,558,087 460,713 14,745 257,411 11,038,622 502,075 45,094 304,375 12,122,559 882,718 560,068 14,499,444 900,734 326,637 375,878 14,683,456 436,596 334,502 554,564 15,740,969 243,635 96,857 15,540,197 129,103 92,198 17,049,700 89 CITY OF COLLEYVILLE, TEXAS PROPERTY TAX LEVIES AND COLLECTIONS LAST TEN FISCAL YEARS (UNAUDITED) Current Percent Delinquent Fiscal Total Tax of Levy Tax Total Tax Year Tax Levy Collections (1) Collected Collections ( 1) Collections 1995 $ 3,914,475 $ 3,988,795 101.90% $ 40,856 $ 4,029,651 1996 4,521,281 4,536,704 100.34% 44,926 4,581,630 1997 4,847,786 4,859,910 100.25% 68,438 4,928,348 1998 5,179,670 5,146,115 99.35% 45,216 5,191,331 1999 5,534,817 5,479,798 99.01% 98,586 5,578,384 2000 6,008,914 5,994,435 99.76% 65,745 6,060,180 2001 6,664,042 6,614,200 99.25% 74,961 6,689,161 2002 7,399,976 7,344,042 99.24% 81,733 7,425,775 2003 8,233,543 8,251,059 100.21 % 155,622 8,406,681 2004 8,719,444 8,701,794 99.80% 94,628 8,796,422 (1) Includes related penalties and interest. Source: Tarrant County Appraisal District; Grapevine-Colleyville, Tax Assessor-Collector. 90 TABLE 3 Percent of Percent of Total Tax Outstanding Delinquent Collections Delinquent Taxes to to Tax Levy Taxes Tax Levy 102.94% $ 93,461 2.39% 101.33% 88,996 1.97% 101.66% 100,964 2.08% 100.23% 97,842 1.89% 100.79% 111,044 2.01% 100.85% 127,878 2.13% 100.38% 143,615 2.16% 100.35% 204,837 2.77% 102.10% 183,660 2.23% 100.88% 154,875 1.78% 91 TABLE 4 CITY OF COLLEYVILLE, TEXAS ASSESSED AND ESTIMATED ACTUAL VALUE OF TAXABLE PROPERTY LAST TEN FISCAL YEARS (UNAUDITED) Fiscal Real Property Personal Property Year Assessed Value (1) Assessed Value (1) Assessed Value (1) 1995 $ 1,187,856,360 $ 50,131,950 $ 1,237,988,310 1996 1,283,285,015 56,748,974 1,340,033,989 1997 1,378,523,815 62,251,717 1,440,775,532 1998 1,426,690,278 64,255,538 1,490,945,816 1999 1,516,190,807 65,897,793 1,582,088,600 2000 1,654,879,062 74,802,432 1,729,681,494 2001 1,833,222,942 78,663,705 1,911,886,647 2002 2,043,344,918 80,447,537 2,123,792,455 2003 2,284,434,686 82,599,959 2,367,034,645 2004 2,506,636,348 73,845,277 2,580,481,625 (1) Ratio of total assessed value to total estimated actual value equals 100%. Source: Tarrant County Appraisal District; Grapevine-Colleyville, Tax Assessor-Collector. 92 THIS PAGE INTENTIONALLY LEFT BLANK 93 CITY OF COLLEYVILLE, TEXAS PROPERTY TAX RATES - DIRECT AND OVERLAPPING GOVERNMENTS (PER $100 OF ASSESSED VALUE) LAST TEN FISCAL YEARS (UNAUDITED) Grapevine- B irdville Carroll Colleyville Fiscal City of Independent Independent Independent Year Colleyville School District School District School District 1995 $ 0.3263 $ 1.51150 $ 1.6295 $ 1.4791 1996 0.3474 1.50150 1.6295 1.5350 1997 0.3474 1.50150 1.7400 1.5378 1998 0.3474 1.50050 1.7400 1.5378 1999 0.3474 1.53850 1.7400 1.5378 2000 0.3474 1.53250 1.7900 1.5523 2001 0.3474 1.56980 1.8850 1.5823 2002 0.3474 1.56980 1.9500 1.61679 2003 0.3474 1.61700 1.9350 1.65979 2004 0.3474 1.61700 1.9025 1.70105 Source: Information furnished by various assessors. 94 TABLE 5 Tarrant Hurst Tarrant County Euless- Bedford County Junior Independent Tarrant Hospital College School District County District District $ 1.5350 $ 0.271870 $ 0.244640 $ 0.056510 1.5345 0.266600 0.239800 0.055500 1.6169 0.264836 0.234070 0.057720 1.6063 0.234836 0.234070 0.057690 1.6063 0.234836 0.234070 0.106410 1.6318 0.234836 0.234070 0.106410 1.6775 0.274785 0.234070 0.106410 1.6530 0.274785 0.234070 0.106410 1.7119 0.272500 0.234000 0.139380 1.6616 0.272500 0.235397 0.139380 95 CITY OF COLLEYVILLE, TEXAS RATIO OF NET GENERAL BONDED DEBT TO ASSESSED VALUE AND NET BONDED DEBT PER CAPITA LAST TEN FISCAL YEARS (UNAUDITED) Gross General Fiscal Estimated Obligation Year Population Assessed Value Bonded Debt 1995 16,550 $ 1,199,654,988 $ 13,575,000 1996 16,750 1,301,462,527 15,400,000 1997 17,400 1,395,447,797 14,840,000 1998 18,100 1,490,945,816 14,255,000 1999 18,700 1,582,088,600 14,150,000 2000 19,200 1,729,681,494 13,490,000 2001 19,500 1,911,886,647 12,975,000 2002 19,850 2,123,792,455 15,315,000 2003 20,150 2,367,034,645 13,820,000 2004 20,500 2,580,481,625 12,925,000 Source: Various departments within the City and Grapevine-Colleyville Tax Assessor-Collector and Tarrant County Appraisal District. 96 TABLE 6 Percent of Net Net Less Debt Net Bonded Debt to Bonded Debt Service Funds Bonded Debt Assessed Value Per Capita $ 464,366 $ 13,110,634 1.09% $ 492 548,756 14,851,244 1.14% 887 540,849 14,299,151 1.02% 822 614,437 13,640,563 0.91 % 754 676,097 13,473,903 0.85% 721 756,106 12,733,894 0.74% 663 863,320 12,111,680 0.63% 612 962,636 14,352,364 0.68% 707 1,025,530 12,794,470 0.54% 635 995,889 11,929,111 0.46% 582 97 TABLE 7 CITY OF COLLEYVILLE, TEXAS COMPUTATION OF LEGAL DEBT MARGIN SEPTEMBER 30, 2004 (UNAUDITED) Article XI, Section 5 of the State of Texas Constitution states in part: "... but no tax for any purpose shall ever be lawful for anyone year, which shall exceed two and one-half percent of the taxable property of such city." Article X, Section 3 of the Charter of /Colleyville, Texas states: "The maximum tax rate shall not exceed $1.50 on the one hundred dollars ($100) valuation of taxable property with the City." The tax rate at October 1, 2003, is $.3474 per $100 of assessed valuation at 100% of market value. The City operates under a Home Rule Charter, which adopts the constitutional provision. The tax rate is 23% of the legal limit. 98 TABLE 8 CITY OF COLLEYVILLE, TEXAS RATIO OF ANNUAL DEBT SERVICE EXPENDITURES FOR GENERAL BONDED DEBT TO TOTAL GENERAL GOVERNMENTAL EXPENDITURES LAST TEN FISCAL YEARS (UNAUDITED) Ratio of Total Debt Service Total General to General Fiscal Interest Debt Government Government Year Principal and Fees Service Expenditures (1) Expenditures 1995 $ 245,000 $ 734,770 $ 979,770 $ 7,206,491 $ 13.60 1996 380,000 832,655 1,212,655 8,982,350 13.50 1997 560,000 905,592 1,465,592 9,644,319 15.20 1998 585,000 821,790 1,406,790 11,196,020 12.57 1999 605,000 783,494 1,388,494 13,448,635 10.29 2000 665,000 1,238,770 1,903,770 14,165,095 10.14 2001 1,040,000 818,282 1,858,282 16,922,061 6.96 2002 1,015,000 1,096,464 2,111,464 19,700,311 7.25 2003 1,495,000 721,390 2,216,390 17,301,854 12.80 2004 895,000 583,599 1,478,599 16,823,749 8.79 (1) Includes General, Special Revenue and Debt Service Funds. 99 TABLE 9 CITY OF COLLEYVILLE, TEXAS COMPUTATION OF DIRECT AND OVERLAPPING DEBT SEPTEMBER 30, 2004 (UNAUDITED) Debt Percent Overlapping Jurisdiction Outstanding Overlapping Debt City of Colleyville $ 12,925,000 (1) 100.00% $ 12,925,000 Birdville Independent School District 152,958,037 (1) 0.07% 107,071 Carroll Independent School District 164,487,671 (1) 0.43% 707,297 Grapevine-Colleyville Independent School District 242,715,813 (1) 22.94% 55,679,008 Hurst-Eules-Bedford Independent School District 235,925,613 (1) 1.30% 3,067,033 Keller Independent School District 400,520,930 (1) 0.10% 400,521 Tarrant County 153,200,000 (1) 3.01 % 4,611,320 Tarrant County Hospital District 2,410,000 (1) 3.01 % 72,541 Tarrant County Junior College District 76,790,000 (1) 3.01 % 2,311,379 Total Direct and Overlapping Debt $ 1,441,933,064 $ 79,881,169 Estimated Population as of January 1, 2004 $ 20,500 (2) Per Capita Overlapping General Obligation Tax Debt $ 5,146 (1) Source: Texas Municipal Reports (2) Source: North Central Texas Council of Governments Research and Information Services. 100 THIS PAGE INTENTIONALLY LEFT BLANK 101 CITY OF COLLEYVILLE, TEXAS REVENUE BOND AND CERTIFICATES OF OBLIGATION COVERAGE LAST TEN FISCAL YEARS (UNAUDITED) Net Revenue Fiscal Gross Operating A vailable for Year Revenue (1) Expenses (2) Debt Service 1995 $ 5,369,721 $ 3,827,749 $ 1,541,972 1996 6,754,594 4,628,183 2,126,411 1997 6,759,061 3,757,793 3,001,268 1998 7,775,729 4,366,860 3,408,869 1999 8,321,893 4,196,771 4,125,122 2000 9,540,064 5,698,694 3,841,370 2001 8,477,716 5,793,366 2,684,350 2002 8,407,033 5,909,848 2,497,185 2003 9,544,931 6,723,108 2,821,823 2004 9,765,500 6,429,513 3,335,987 (1) Includes interest income and other income, exclusive of capital contributions. (2) Excludes depreciation and amortization. 102 TABLE 10 Debt Service Requirements Principal Interest Total Coverage $ 309,000 $ 374,789 $ 683,789 2.26 280,000 398,420 678,420 3.13 420,000 471,594 891,594 3.37 410,000 486,163 896,163 3.80 510,000 576,767 1,086,767 3.79 541,000 556,761 1,097,761 3.49 566,000 515,003 1,081,003 2.48 597,000 485,984 1,082,984 2.30 762,000 601,560 1,363,560 2.07 910,000 487,187 1,397,187 2.39 103 TABLE 11 CITY OF COLLEYVILLE, TEXAS DEMOGRAPHIC STATISTICS LAST TEN FISCAL YEARS (UNAUDITED) Fiscal Year Population 1995 16,550 1996 16,750 1997 17,400 1998 18,100 1999 18,700 2000 19,200 2001 19,500 2002 19,850 2003 20,150 2004 20,500 Source: North Central Texas Council of Governments. 104 TABLE 12 CITY OF COLLEYVILLE, TEXAS PROPERTY VALUE, CONSTRUCTION LAST TEN FISCAL YEARS (UNAUDITED) Commercial Residential Fiscal Property Construction (2) Construction (2) Year Value (1) Units Value Units Value 1995 $ 1,237,988,310 11 $ 3,625,000 169 $ 42,250,000 1996 1,340,033,989 17 6,309,200 224 56,000,000 1997 1,440,775,532 17 5,328,000 209 50,337,000 1998 1,490,945,816 46 6,430,727 220 56,650,000 1999 1,582,088,600 20 7,946,222 194 50,806,000 2000 1,729,681,494 11 5,470,600 246 64,791,553 2001 1,911,886,647 6 6,449,762 183 55,086,037 2002 2,123,792,455 14 33,895,087 132 50,173,140 2003 2,367,034,645 18 14,244,049 136 51,989,544 2004 2,506,636,348 16 21,257,852 275 104,205,111 (1) Tarrant County Appraisal District (2) City records 105 TABLE 13 CITY OF COLLEYVILLE, TEXAS PRINCIP AL T AXP AYERS SEPTEMBER 30, 2004 (UNAUDITED) Percentage 2004 of Total Assessed Assessed Valuation Valuation Oncor Electric/TXU Gas $ 15,654,363 0.63% Albertsons, Inc. 9,915,345 0.40% Village Management, L TD 9,419,217 0.38% Herman Smith & Co, L TD. 7,576,374 0.30% Colleyville Plaza 6,500,000 0.26% Industrial Bank Japan Trust Co 5,145,107 0.21 % RH -One LP 4,400,000 0.18% Broughton L TD Partnership 4,267,148 0.17% Church of Jesus Christ LDS 4,090,960 0.16% D.R. Horton Texas LTD 4,050,950 0.16% Total $ 71,019,464 2.85% 106 TABLE 14 CITY OF COLLEYVILLE, TEXAS MISCELLANEOUS STATISTICAL DATA SEPTEMBER 30, 2004 (UNAUDITED) Date of Incorporation January 10, 1956 Date of City Charter Adoption January 15, 1977 Form of Govemment Council - Manager Area - square miles 13 Municipal water system: Number of customers Annual gallons of water pumped in millions Stored capacity in millions 8,067 Miles of streets 158 1,812 4.9 Miles of sanitary sewers 147 Miles of water mains Number of fire hydrants 170 1,108 Building Permits: Permits issued 291 Number of street lights 745 Value in millions $ 125,463 Fire Protection: City Employees: Number of stations 3 Fulltime 162 Number of firefighters 30 Part-time 8 Police Protection: Registered voters 16,641 Number of employees 40 Number of uniformed officers 30 V otes in last Council election 3,030 Recreation: Population (City's estimate) 20,500 Parks - number of acres 185 Number of playgrounds 5 107 THIS PAGE INTENTIONALLY LEFT BLANK 108