Loading...
HomeMy WebLinkAboutComprehensive Annual Financial Report (CAFR)-Audit Records-9/30/2012CITY OF COLLEYVILLE, TEXAS COMPREHENSIVE ANNUAL FINANCIAL REPORT YEAR ENDED SEPTEMBER 30, 2012 Prepared by Finance Department Terry Leake Assistant City Manager/Chief Financial Officer Karen Hines Finance Manager CITY OF COLLEYVILLE, TEXAS TABLE OF CONTENTS YEAR ENDED SEPTEMBER 30, 2012 INTRODUCTORY SECTION Letterof Transmittal ......................................................................................................... OrganizationalChart ......................................................................................................... Certiiicateof Achievement ............................................................................................... PrincipalOfficials ............................................................................................................. FINANCIAL SECTION Independent Auditors' Report ........................................................................................... Management's Discussion and Analysis .......................................................................... Basic Financial Statements Statement of Net Assets ................................................................................................. Statementof Activities ................................................................................................... Balance Sheet — Governmental Funds ........................................................................... Statement of Revenues, Expenditures and Changes in Fund Balances — Governmental Funds ....................................................................... Reconciliation of the Statement of Revenues, Expenditures and Changes in Fund Balance of Governmental Funds to the Statementof Activities ................................................................................................ Statement of Revenues, Expenditures and Changes in Fund Balances — Budget and Actual — General Fund ................................................. (continued) Page Number 3-6 . � 13 — 14 17-24 26 — 27 28 — 29 30-31 32-33 34 35 CITY OF COLLEYVILLE, TEXAS TABLE OF CONTENTS (Continued) YEAR ENDED SEPTEMBER 30, 2012 Page Number FINANCIAL SECTION (Continued) Basic Financial Statements (Continued) Statement of Net Assets — Proprietary Funds .................................................................. 36 Statement of Revenues, Expenses and Changes in Fund Net Assets — Proprietary Funds ........................................................................... 37 Statement of Cash Flows — Proprietary Funds ................................................................. 38 — 39 Statement of Fiduciary Net Assets — Fiduciary Funds ..................................................... 40 Notes to the Financial Statements .................................................................................... 41 — 68 Required Supplementary Information Schedule of Funding Progress for the Retirement Plan ................................................... 70 Nonmajor Governmental Funds CombiningBalance Sheet ................................................................................................ 74 — 79 Combining Statement of Revenues, Expenditures and Changes in Fund Balances ............................................................................................ 80 — 85 Schedule of Revenues, Expenditures and Changes in Fund Balance — Budget and Actual — Debt Service Fund ............................................ 86 Agency Funds Combining Statement of Fiduciary Net Assets ................................................................ 88 Combining Statement of Changes in Assets and Liabilities ............................................ 89 (continued) CITY OF COLLEYVILLE, TEXAS TABLE OF CONTENTS (Continued) YEAR ENDED SEPTEMBER 30, 2012 STATISTICAL SECTION (Unaudited) Net Assets by Component ....................................................................... Changes in Net Assets ............................................................................ Fund Balances — Governmental Funds ................................................... Changes in Fund Balances — Governmental Funds ................................ Assessed Value and Estimated Actual Value ofTaxable Property .............................................................................. Direct and Overlapping Property Tax Rates ........................................... Principal Property Taxpayers .................................................................. Property Tax Levies and Collections ...................................................... Principal Water Customers ..................................................................... Ratios of Outstanding Debt by Type ...................................................... Ratios of General Bonded Debt Outstanding .......................................... Direct and Overlapping Governmental Activities Debt .......................... Legal Debt Margin Information .............................................................. Pledged Revenue Coverage .................................................................... Demographic and Economic Statistics ................................................... PrincipalEmployers ................................................................................ Fulltime Equivalent City Government Employees by Function/Program ................................................................................ Operating Indicators by Function/Program ............................................ Capital Asset Statistics by Function/Program ......................................... (continued) Exhibit/Table 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Page Number 92 — 93 94-97 99 100 — 101 102 103 104 105 106 107 108 109 111 112 — 113 114 115 116 117 118 CITY OF COLLEYVILLE, TEXAS TABLE OF CONTENTS (Continued) YEAR ENDED SEPTEMBER 30, 2012 COMPLIANCE Page Number Report on Internal Control Over Financial Reporting and on Compliance and Other Matters Based on an Audit of Financial Statements Performed in Accordance With ..................................................... 121— 122 INTRODUCTORY SECTION THIS PAGE INTENTIONALLY LEFT BLANK Integrity * Service * Innovation February 5, 2013 To the Citizens of the City of Colleyville: The Comprehensive Annual Financial Report of the City of Colleyville (the "City") for the fiscal year ended September 30, 2012, 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 of internal accounting controls. These controls are designed to provide reasonable, but not absolute, assurance regarding the safeguarding of assets against loss from unauthorized use or disposition, and the reliability of financial records for preparing financial statements and maintaining accountability for assets. The concept of reasonable assurance recognizes that the cost of a control should not exceed the beneiits 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 iinancial 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 ftnancial statements of the City of Colleyvi]]e for the fiscal year ended September 30, 2012, 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 Colleyville's financial statements for fiscal year ended September 30, 2012, are presented in conformity with generally accepted accounting principles (GAAP). As required by GAAP, management provides a narrative introduction, overview and analysis to accompany the basic financial statements in the form of Management's Discussion and Analysis (MD&A). This letter of transmittal is designed to complement the MD&A and should be read in conjunction with it. The City's MD&A can be found immediately following the independent auditors report. 3 100 Main Street �r Colleyville, Texas 76034 -�r 817.503.1000 �t Calleyville.carn PROFILE OF THE GOVERNMENT On January 10, 1956, the City of Colleyville was incorporated and adopted a home-rule charter on January I5, 1977. It has a council-manager form of government with policy making and legislative authority vested in a governing body consisting of a mayor and six council members. The mayor and council are responsible for passing ordinances, adopting the budget, appointing board and committee members, and hiring the City Manager. The City Manager is responsible for carrying out the policies and ardinances of the mayor and council, overseeing the day-to-day operations of the City, and appointing department heads. The mayor and six council members are elected on an at large, non- partisan basis for three year terms. The three year terms are staggered so that the Mayor and City council persons from Place 1 and 2 are elected in year one, City Council persons from Places 3 and 4 are elected in year two, and City Council persons from Places 5 and 6 are elected in year three. The City provides a full range of municipal services. These services include police and fire protection, municipal court, streets, drainage utility, leisure services (parks and recreation, Colleyville Center and library), water and sewer, engineering /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: Entity Method of Inclusion Colleyville Economic Development Corporation (CEDC) Blended Colleyville Crime Control and Prevention District Blended Co]]eyville TaX Investment Financing Reinvestment Zone Zone Number One (TIF) Discretely Presented 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 and the proposed budget is presented to the City Council at a budget work session. After public hearings at two consecutive regular City Council meetings, the Council may adopt the proposed budge�, with or without amendment. The budget ordinance is to be adopted no later than the 30th day of September and requires an affirmative vote of a majority of the CounciL The City maintains budgetary control by adopting an annual operating budget for the General Fund, Debt Service Fund, Drainage Utility Fund, and Water and Sewer Enterprise Fund. Detail control is maintained at the line item level by encumbering available funds at the time a purchase order is written. Encumbrances lapse at fiscal year end, but can be re-appropriated through a budget amendment during the following fiscal year. The City Manager is authorized to transfer budgeted amounts between departments within any fund. However, any revisions that alter the total expenditures of any fund must be approved by the City Council. LOCAL ECONOMY The City of Colleyville is a residential-oriented 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 2012, as did commercial development. During the fiscal year, the City issued 155 residential building permits and the average square footage of a residence was almost five thousand square feet. Also, there was the redevelopment of existing commercial properties and two corporate relocations during the fisca] year. 4 The Parks and Recreation Master Plan, which was adopted in November 2011, provides for the construction of inter-connected trail segments throughout the City, with a major segment of the Cotton Belt Trail which opened in April 2012 and provided connectivity to the western portion of the trail which runs through the Cities of Hurst and North Richland Hills. Major transportation projects were the initial phases of construction of Phase I of State Highway 26 / Colleyville Boulevard and the roundabout at the Pleasant Run and John McCain Road intersection. For the Future. In October 2012, the Colleyville joined with the bordering City of Keller to form the first joint Municipal Court in the State of Texas under recently enacted legislation, which brings financial savings to both cities. Major transportation projects will be the completion of Phase I of State Highway 26 / Colleyville Boulevard and the roundabout at the Jackson Road and Cheek Sparger Road intersection. LONG-TERM FINANCIAL PLANNING In Fiscal Year 2005, the City Council adopted a Fund Balance Policy requiring a ninety day reserve for fund balance in both the General Fund and the Utility Fund. In Fiscal Year 2011, the policy was updated to reflect the designations of non-spendable, restricted, committed, assigned and unassigned as reguired by GASB 54. At the end of Fiscal Year 2012, both the General Fund and the Utility Fund have a fund balance in excess of the required ninety day reserve. Amount in excess of the reserve may be used to fund one-time capital expenditures. As a part of the Fiscal Year 2008 budget process, the Mayor and Council and City Staff embarked upon developing a multi-year streets capital improvements program. Additionally, the Council appointed a citizen committee that reviewed street infrastructure needs and financing opportunities. Their recommendations were incorporated into an infrastructure program that was approved by Council in Fiscal Year 2008. Improvements included in the plan, which were completed during Fiscal Year 2012, were the reconstruction of streets in the Shadowwood and Woodland Hills neighborhoods. In Fiscal Year 2010, the City Council adopted a strategic plan, which incorporated strategic points to achieve the City's vision. In August 2012, Council affirmed and slightly modified the strategic points to the following: • Make a long-term commitment to economic development and promote a more diversified tax base • Fostering excellence in core service delivery • Protect and preserve Colleyville's neighborhoods • Deliver sustainable government • Brand Colleyville with a unique identity In the area of sustainable government, a long-term Information Systems Management Strategic Plan was adopted as was the Parks and Recreation Master Plan. There two plans identify annual improvements over the next five years and accompanied by funding sources. In the Fiscal Year 2011 budget, a transition was made to performance based budgeting, with links to specific performance indicators to measure the efficiency and effectiveness of service delivery. 5 AWARDS AND ACKNOWLEDGEMENTS Awards. The Government Finance Officers Association of the United States and Canada (GFOA) awarded a Certificate of Achievement far Excellence in Financia] Reporting to the City of Colleyville for its comprehensive annual financial report for the fiscal year ended September 30, 2011. This was the twenty-second consecutive year the City has received this prestigious award. In order to be awarded a Certificate of Achievement, a government must publish an easily readable and efficiently organized comprehensive annual financial report. This report must satisfy both generally accepted accounting principles and applicable legal requirements. A Certificate of Achievement is valid for a period of one year only. We believe that our current comprehensive annual financial report continues to meet the Certificate of Achievement Program's requirements and we are submitting it to GFOA to determine its eligibility for another certificate. In addition, the City also received the GFOA's Distinguished Budget Presentation award for its annual budget dated October 1, 2011. In order to qualify for this award, the City's budget document was judged to be proficient in several categories, including as a policy document, a financial plan, an operations guide, and a communications device. Acknowledgements. The preparation of this report could not be accomplished on a timely basis without the dedicated endeavors of the entire staff of the Finance Department. We would like to express our sincere appreciation to all employees who contributed to the preparation. Additionally, we would also like to thank the Mayor, City Council, and City Manager for their support in planning and conducting the financial operations of the City in a responsible and progressive manner. Respectfully submitted, Terry Leake Assistant City Manager / Chief Financial Officer Karen Hines Finance Manager 6 CITY OF COLLEYVILLE ORGANIZATIONAL CHART PLANNING AND LIBRARY ZONING BOARD COMMISSION PARKS AND SIGN BOARD RECREATION OFAPPEALS BOARD CITY SECRETARY COMMUNICATIONS DIRECTOR CITIZENS OF COLLEYVILLE ZONING BOARD OF ADJUSTMENT I AD HOC COMMITTEES COMMUNITY DEVELOPMENT gUILDING INSPECTION DIRECTOR PLANNING ECONOMIC DEVELOPMENT MARKETING DIRECTOR FIRE CHIEF POLICE CHIEF OPERATIONS INSPECTIONS INVESTIGATIONS EMERGENCY MANAGEMENT PATROL INVESTIGATIONS ANIMAL CONTROL CODE ENFORCEMENT CITY COUNCIL CITY MANAGER ASSISTANT CITY MANAGER/ CHIEF FINANCIAL OFFICER CRIME CONTROLAND PREVENTION DISTRICT CITY ATTORNEY COLLEYVILLE ECONOMIC DEVELOPMENT CORPORATION � TAX INCREMENT FINANCING DISTRICT MUNICIPAL JUDGE ------------------------ STRATEGIC SERVICES MANAGER HUMAN RESOURCES MANAGER PUBLIC WORKS UTILITY STREETS DIRECTOR ADMINISTRATION DRAINAGE ENGINEERING AND OPERATION FLEET MAINTENANCE % COLLEYVILLE CENTER MANAGER LIBRARY DIRECTOR PARKS AND RECREATION DIRECTOR INFORMATION SERVICES MANAGER � GIS FINANCE MANAGER UTILITY BILLING MUNICIPAL COURT Certificate of Achievement for Excellence in Financial Reporting Presented to City of Colleyville Texas For its Comprehensive Annual Financial Report for the Fiscal Year Ended September 30, 2011 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 iinancial reporting. ���E i?��r�� r � �C�� flF T#�� �,�, +`� �lTfOSTA�S �� � �a �� � % C�'03kl1Tiflk ,� . `��, �� �,.'� �,��, c��c�e�� �`� � � � r f . b .� �r . � �/ , � "� .� � ,� � Executive Director 8 CITY OF COLLEYVILLE, TEXAS HOME RULE, COUNCIL - MANAGER FORM OF GOVERNMENT CITY OFFICIALS YEAR ENDED SEPTEMBER 30, 2012 David Kelly Mayor Carol Wollin Councilmember, Place 1 Michael Muhm Councilmember, Place 2 Stan Hall Councilmember, Place 3 Jody Short Councilmember, Place 4 Tom Hart Mayor Pro Tem and Councilmember, Place 5 Mike Taylor Councilmember, Place 6 Jennifer Fadden City Manager Terry Leake Assistant City Manager/Chief Financial Officer Karen Hines Finance Manager 9 THIS PAGE INTENTIONALLY LEFT BLANK 10 FINANCIAL SECTION �� THIS PAGE INTENTIONALLY LEFT BLANK 12 �,=ll PATTILLO, BROWN 8r HILL,r._L.��. CERTIFIED PUBLIC ACCOUNTANTS ■ BUSINESS CONSULTANTS INDEPENDENT AUDITORS' REPORT To the Honarable 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, 2012, which collectively comprise the City's basic financial statements as listed in the table of contents. These financial statements are the responsibility of the City's management. Our responsibility is to express opinions on these financial statements based on our audit. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. 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 materia] respects, the respective 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, as of September 30, 2012, and the respective changes in financial position, and, where applicable, cash flows thereof and the respective budgetary comparison for the General Fund far the year then ended in conformity with accounting principles generally accepted in the United States of America. In accordance with Government Auditing Standa�ds, we have also issued our report dated January 25, 2013, on our consideration of the City's internal control over financial reporting and on our tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements and other matters. The purpose of that report is to describe the scope of our testing of internal control over financial reporting and compliance and the results of that testing, and not to provide an opinion on internal control over financial reporting or on compliance. That report is an integral part of an audit performed in accordance with Government Auditing Standards and should be considered in assessing the results of our audit. 13 40 L WEST HIGHWAY 6� P. O. BOX 20725 � WACO, TX 76702-0725 �(254) 772-4901 ■ FAX: (254) 772-4920 � www.pbhcpa.com AFFILIATE OFFICES: BROWNSVILLF, TX (956) 544-7778 � HILLSBORO, TX (254) 582-2583 TEMPLE, TX (254) 791-3460 � ALBUQUERQUE, NM (505) 266-5904 Accounting principles generally accepted in the United States of America require that the management's discussion and analysis on pages 17 through 24 and the Schedule of Funding Progress for the Texas Municipal Retirement on page 70 be presented to supplement the basic financial statements. Such information, although not a part of the basic financial statements, is required by the Governmental Accounting Standards Board, who considers it to be an essential part of financial reporting for placing the basic financial statements in an appropriate operational, economic, or historical context. We have applied certain limited procedures to the required supplementary information in accordance with auditing standards generally accepted in the United States of America, which consisted of inquiries of management about the methods of preparing the information and comparing the information for consistency with management's responses to our inquiries, the basic financial statements, and other knowledge we obtained during our audit of the basic financial statements. We do not express an opinion or provide any assurance on the information because the limited procedures do not provide us with sufficient evidence to express an opinion or provide any assurance. Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise the City's financial statements as a whole. The introductory section, combining and individual nonmajar fund financial statements and schedules, and statistical section are presented for purposes of additional analysis and are not a required part of the financial statements. The combining and individual nonmajor fund financial statements and schedules are the responsibility of management and were derived from and relate directly to the underlying accounting and other records used to prepare the financial statements. The information has been subjected to the auditing procedures applied in the audit of the financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the financial statements or to the financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America. In our opinion, the information is fairly stated in all material respects in relation to the financial statements as a whole. The introductory and statistical sections have not been subjected to the auditing procedures applied in the audit of the basic financial statements and, accordingly, we do not express an opinion or provide any assurance on them. ` L. L.� �a��,�o, ��� � �'� ) January 25, 2013 14 MANAGEMENT' S DISCUSSION AND ANALYSIS is 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, 2012. We encourage readers to consider the information presented here in conjunction with additional information that we have furnished in our letter of transmittal, which can be found on pages 3 — 6 of this report. FINANCIAL HIGHLIGATS • The assets of the City of Colleyville exceeded its ]iabilities as of September 30, 2012, by $166,314,101 (net assets). Of this amount, $31,891,957 (unrestricted net assets) may be used to meet the City's ongoing obligations to citizens and creditars in accordance with the City's fund designation and fiscal policies. • The City's total net assets increased by $4,872,818. • As of the close of the current fiscal year, the City of Colleyville's governmental funds reported combined ending fund balances of $32,751,471. Of this amount, $11,762,625 is unassigned fund balance available for use within the City's fund designation and fiscal policies. • As of September 30, 2012, unreserved, unassigned fund balance for the General Fund was $11,762,625 or 60.2% 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 26 of this report, are designed to provide readers with a broad overview of the City's finances, in a manner similar to a private-sector business. The Statement of Net Assets presents information on all of the City's assets and liabilities, with the difference between the two reported as net assets. Over time, increases or decreases in net assets may serve as a useful indicator of whether the iinancial position of the City is improving or deteriorating. The Statement of Activities presents information showing how the City's net assets changed during the fiscal year. All changes in net assets are reported when the underlying event giving rise to the change occurs, regardless of the timing of related cash flows. Thus, revenues and expenses are reported in this statement for some items that will only result in cash flows in the future fiscal periods (e.g., uncollected taxes and earned but unused compensated absences). 17 Both of the government-wide financial statements distinguish functions of the City that are principally supported by taxes and intergovernmental revenues (governmental activities) from functions that are intended to recover all or a significant portion of their costs through user fees and charges (business-type activities). The governmental activities of the City include General Government, Community Development and Engineering, Fire and Rescue, Leisure Services, Maintenance, Municipal Court, Police, and Streets and Drainage. The business-type activities of the City include Water and Wastewater, and Drainage Utility. Fund financial statements — A fund is a grouping of related accounts that is used to maintain control over resources that have been segregated for specific activities ar 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 stateinents. 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 30 of this report, information is presented separately in the Governmen�al 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 fonn of combining statements elsewhere in this report. Proprietary Funds — The City maintains one type of proprietary fund. Enterprise Funds are used to report the same functions presented as business-type activities in the government-wide financial statements. The City uses Enterprise Funds to account for the Water and Wastewater and Drainage Utility Funds. Proprietary funds provide the same type of information as the government-wide financial statements, only in more detail. The basic proprietary fund financial statements which begin on page 36 of this report provide separate information for the Water and Wastewater and Drainage Utility Enterprise Funds since these are considered to be major funds of the City. Notes to the Financial Statements — The notes provide additional information that is essential to a full understanding of the data provided in the government-wide and fund financial statements. The notes to the financial statements can be found on pages 41 — 68 of this report. 18 Other Information — In addition to the basic financial statements and accompanying notes, this report also presents combining fund statements and schedules that further support the information in the financial statements. The combining fund statements and schedules for nonmajor funds are presented immediately following the notes to the financial statements beginning on page 74 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 $166,314,101 as of September 30, 2012. The largest portion of the City's net assets ($121,607,696) 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. CITY OF COLLEYVILLE'S NET ASSETS Governmenta] Activities 2012 201] Business-type Activities 2012 2011 Current and other assets $ ] 90,574 $ 30,839,307 $ - Capital assets 102,809,761 ] 03,873,376 - Total assets 103,000,335 134,712,683 - Other liabilities 2,189,136 3,667,849 993,194 Long-term liabiliti�s 17,976,515 19,269,475 ( 993,194) Totalliabilities 20,165,651 Net assets: Invested in capital assets, net ofrelateddebt 83,211,988 Restrieted 10,773,3 ] 5 Unrestricted 17,751,508 22,937,324 $ 12,450,135 43,974,948 56,425,083 2,561,102 4,198,057 6.759.159 83,166,142 - 38,892,098 10,771,624 - 662,050 17,837,593 49,665,925 10,111,776 Totals 2012 201] $ 190,574 $ 43,289,442 102,809,761 147,848,324 103,000,335 191,137,766 3,182,330 6,228,951 16,983,321 23,467,532 20,165,651 29,696,483 83,211,988 122,058,240 10,773,315 11,433,674 67,417,433 27,949,369 Totalnetassets $ 111,736,811 $ 111,775,359 $ 49,665,925 $ 49,665,924 $ 161,402,736 $ 161,441,283 A portion of the City's net assets ($12,814,448) represents resources that are subject to external restriction on how they may be used. The remaining balance ($31,891,957) 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, 2012, the City has positive balances in all three categories of net assets, both for the City as a whole, as well as for its governmental and business-type activities separately. The increase of $3,810,796 in net assets relating to governmental activities is primarily due to an increase in sales tax, an increase in building permit revenues as well as reductions in General Fund expenditures. The increase in net assets of business type activities is related to water sales occurring during the end of an almost two year period of extreme drought conditions, which began at the start of the prior fiscal year. 19 Analysis of the City's Operations - The following table provides a summary of the City's operations for the year ended September 30, 2012. Governmental activities increased the City of Colleyville's net assets by $3,810,795, accounting far all of the total growth in net assets. Business-type activities contributed an increase to the City's net assets of $1,062,022. CITY OF COLLEYVILLE'S CHANGES IN NET ASSETS Crovernmental Activities 2012 2011 Revenues: Program revenues: Charges for services $ 2,187,152 $ 3,821,848 $ Operating �-ants andcontributions 397,243 822,056 Capital grants and contributions 912,172 405,347 General revenues: Advalorem taxes 32,095,381 12,414,948 Sales taxes 46,932,217 5,056,597 Franchisetaxes 6,355,695 2,031,268 Other taxes - 80,731 Investment earnings 286,293 95,822 Miscellaneous 170,318 55,454 Gain on sale of capital assets - - Total revenues 89,336,471 24,784,071 Expenses: Gencralgovernment 368,641 2,715,]54 Cmnmunity development andengineering - 1,402,669 Fire and rescue 449,102 4,421,496 Leisure services 1,091,058 4,191,960 Maintenance 5,029 412,512 Municipal court - 303,839 Police 250,191 4,878,055 Streetsanddrainage 1,682,988 3,657,591 Water andwastewater - - Drainage - - Interest on ]ong-term debt 22,435 849,390 Total expenses 3,869,444 22,832,666 Increasesin net assets Business-type Activities 2012 2011 1 1 Totals 2012 2011 $ 15,258,507 $ 2,187,152 $ 19,080,355 - 397,243 822,056 168,365 912,172 573,712 - 32,095,381 12,414,948 - 46,932,217 5,056,597 - 6,355,695 2,031,268 - - 80,731 38,674 286,294 134,496 - 170,318 55,454 15,465,546 89,336,472 l 2,009,187 742, I 60 12,751,347 368,641 449,102 ],091,058 5,029 250,191 1,682,988 22,435 3,869,444 40,249,617 2,715,154 1,402,669 4,421,496 4,191,960 412,512 303,839 4,878,055 3,657,591 12,009,187 742,160 849,390 35,584,013 before transfers 85,467,027 1,951,405 1 2,714,199 85,467,028 4,665,604 Transfers ( 2,811,716) 858,879 - ( 858,879) ( 2,8ll,716) - Change in net assets 82,655,311 2,810,284 1 1,855,320 82,655,312 4,665,604 Net assets, beginning 111,775,359 108,965,075 49,665,924 47,810,604 161,441,283 156,775,679 Net assets, ending $ 194,430,670 $] 11,775,359 $ 49,665,925 $ 49,665,924 $ 244,096,595 $ 161,441,283 2� 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 iiscal year, the City of Colleyville's governmental funds reported combined ending fund balances of $32,751,471. Approximately 36% of this total amount ($11,762,625) constitutes unassigned fund balance. The remainder of the fund balance ($20,988,846) is reserved to indicate that is not available for new spending because it has already been committed to pay for encumbrances or debt service or to provide for other items. Refer to page 30 of this report for a more detailed presentation of governmental fund balances. In the General Fund, the City's original budgeted revenues exceeded expenditures by $15,573. While there was a budget adjustment in Fiscal Year 2012, the expense was offset by additional revenues; the final budgeted decrease in fund balance was $984,427. The actual increase to fund balance for the General Fund was $1,776,504 for fiscal year 2012, primarily due to greater than anticipated revenues from sales taxes, franchise taxes, building permits and reductions to overall departmental expenditures. Proprietary funds — The City's proprietary fund statements beginning on page 36 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 ($11,042,613), and Drainage Utility ($1,289,625). The Water and Wastewater fund experienced an increase in total net assets of $865,334 during Fiscal Year 2012 due to increased water sales caused by the extreme drought and summer weather conditions. The Drainage Utility fund's net assets increased by $196,688, due to increased service charge revenue and reductions to expenditures. Governmental Activities — There was a slight decrease in revenues comes from the Charges for Services category, primarily due to the City receiving a one-time signing bonus of over $.7 million for a gas lease on City-owned property in FY 2011 which did not recur in FY 2012. Revenue increases came primarily from an increase in both license and permit revenues due to an increase in the issuance of residential building permits and an increase in sales tax collections due to improving economic conditions. The property tax base decreased approximately $2.5 million, due to the revaluation of property, however the current year tax collection rate was over 99.37% of the levy. There was a two percent one-time lump sum salary payment to employees included in the Fiscal Year 2012 budget, funded primarily from the cost decrease in health insurance premiums. Additionally, there was the addition of one police officer and two firefighters and the elimination of a building clerk position. The City's computer and communications infrastructure were upgraded by the city-wide replacement of the phone system and the centralized virtual environment in a computer data center. The General Fund continued funding in the amount of $1 million in the Street department for the street overlay budget, which will overlay approximately five miles of city streets. Business-type Activities — The City has two enterprise operations, the Water and Wastewater Fund and the Drainage Utility Fund. Total operating revenues of the Water and Sewer fund were $14,034,600 for the fiscal year. Water sales decreased due to the extreme drought and record setting days in excess of 100 degrees in the summer of 2011, which occurred in FY 2011. A slight offset to the decrease in 21 revenue due to lower usage is from a rate increase in December 2011, which passed through a rate increase from the Trinity River Authority, the City's provider of treated water. Wastewater sales increased primarily due to higher residential usage during the winter usage period, which sets residential wastewater charges due to the frequency of irrigation that occurs during the summer months and the pass through of the rate increase from Trinity River Authority, who also treats the City's was�ewater. The coverage ratio for debt for this fund was 3.40 for the iiscal year, exclusive of transfers. The slight increase in the Drainage Utility Fund's revenues was due to new residential and commercial construction. Increases in the Water and Wastewater Fund expenses relate to the increase in cost of purchased water and treatment of wastewater from Trinity River Authority. The Authority's rate increase relates to higher cost for electricity, debt issuance for plant expansion and rehabilitation of aging infrastructure, replacement of system-wide aging infrastructure and compliance with federal water and wastewater mandates. General Fund Budgetary Highlights — The City made revisions to the original appropriations approved by the Ciry Council. Overall, these changes resulted in an increase from the original budget of $1,100,000. The budget amendment was for the funding in the amount of $200,000 for an update to the Master Plan, $300,000 to fund City facility maintenance and repairs, and $600,000 for a transfer to capital projects for the funding of future street rehabilitation projects. Also, included in the budget amendment was the transfer of unspent street resurfacing appropriations to the Capital Projects fund for future street projects. The increases to the original budget were offset by the receipt of higher than anticipated sales tax and permit revenues. The General Fund's overall budgeted revenue increased by $582,492. Major increases were in property taxes due to the declining allocation of the rate to repayment of debt and an increase in sales tax revenue due to improving economic conditions. Also, revenue increases were derived from the increase in the transfer from the Utility Fund for the administrative and franchise that is based upon prior year's operating revenues due to the extreme drought condition in Fiscal Year 2011. Refer to the General Fund Statement of Revenue, Expenditures and Changes in Fund Balances — Budget and Actual on page 35 of this report for a detailed presentation of the actual General Fund operations compared to both the original and final budget for fiscal year 2011. CAPITAL ASSETS The City of Colleyville's investment in capital assets for its governmental and business-type activities as of September 30, 2012, amounts to $145,340,034 (net of accumulated depreciation). This investment in capital assets includes ]and, 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 $.7 million in park improvements with the completion of the Phase II of the Cotton Belt Trail; • Capitalized approximately $.25 million in street improvements and contributions; and Capitalized approximately $.6 million in water and wastewater system projects and contributions including the new water lines on State Highway 26 and the renewal of waterlines in the Shadowwood and Woodland Hills neighborhood. 22 CITY OF COLLEYVILLE'S CAPITAL ASSETS AT YEAR-END Land Buildings and improvements Equipment In Yrastructure/water distribution sewer collection Construction in progress I,ess: accumulated depreciafion Total capital assets Governmental Activities Business-type Activities 2012 2011 2012 2011 $ 9,293,654 � 9,293,654 $ 313,057 $ 373,057 $ 45,603,909 44,880,314 53,922 53,922 10,225,015 9,390,361 1,509,282 1,595,39a 77,797,69a 76,959,884 69,054,295 68,a57,511 1,741,624 1,178,455 512,948 718,330 Totals 2012 2011 9,606,71 ] $ 9,606,7] 1 45,657,831 44,934,236 11,734,297 10,985,755 7 46,251,989 145,a17,395 2,254,572 1,896,785 ( 41,252,135) ( 37,829,292) ( 28,913,231) ( 27,163,266) ( 70,165,366) ( 64,992,558) $ 102,809,761 � 103,873,376 $ 42,530,273 $ 43,974,948 $ 145,340,034 $ 147,848,324 Additional information on the City's capital assets can be found in Note 4, pages 55 — 57 of this report. DEBT ADMINISTRATION At the end of the current fiscal year, the City of Colleyville had total bonded debt, notes payable and capital lease obligations of $23,833,852. Of this amount, $9,975,000 represents bonded debt backed by the full faith and credit of the government, $7,954,732 represents bonds secured by sales tax revenues, $2,850,000 represents bonds secured solely by water and sewer revenues, and $1,345,000 represents bonds secured solely by drainage utility system revenues. The City's capitalized lease obligations of $1,709,120 pertain to the prior year lease purchase of a fire pumper truck and mid-mount aerial platform iire apparatus. In FY 2012, there was an additional lease purchase, in the amount of $894,53�, entered into for the upgrade of the City's trunked radio system tower and equipment to the federally mandated digital public safety communications system standard. OUTSTANDING DEBT AT YEAR-END BONDS, NOTES AND CAPITALIZED LEASE OBLIGATIONS PAYABLE Govemmental Activities Business-type Activities Totals 2012 2011 2012 2011 2012 2011 General obligation bonds and certificates of obligation Sales tax revenue bonds Revenue bonds payable Capitalized lease obligations $ 9,975,000 $ ll,510,000 7,954,732 8,271,278 1,709,120 972,170 $ - $ - 4,195,000 5,150,000 $ 9,975,000 $ 11,510,000 7,954,732 8,271,278 4,195,000 5,150,000 L,709,120 972,170 $ 19,638,852 $ 20,753,448 $ 4,195,000 $ 5,150,000 $ 23,833,852 $ 25,903,448 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. 23 Standard Fitch ICBA & Poor's General Obligation Bonds AAA AAA Water Revenue Bonds AAA AA+ During Fiscal Year 2012, the City retained its existing bond ratings during the biannual ratings surveillance process conducted by the rating agencies. Most of the City's Bonds are insured, thus holding a AAA credit rating from both Fitch Ratings and Standard & Poor's. Additional infonnation on the City of Colleyville's long term-debt can be found in footnote 4 on pages 58 — 63 of this report. ECONOMIC FACTORS AND NEXT YEAR'S BUDGETS AND RATES The General Fund budget including transfers in for Fiscal Year 2013 is based on a projected revenue increase of 10.7% as compared to the Fiscal Year 2012 budget. There is a 3.6% increase projected in General Fund property tax revenue, due to a declining portion of the tax rate committed to debt service repayment increasing the amount allocated to the General Fund. This is the largest revenue source and comprises 57% of General Fund revenues. The total tax rate for Fiscal Year 2013 is $.3559, which is unchanged since Fiscal Year 2008. Approximately 14% of General Fund revenues are sales taxes, budgeted at a 3.8% increase over the Fiscal Year 2012 budget, due to improving economic conditions. Another revenue increase ($130,391) is in the area of licenses and permits due to the increase in residential building permit issuance. There is a utilization of $1,000,000 surplus fund balance in the adopted Fiscal Year 2013 General Fund budget for the over $1.4 million increase in the street rehabilitation budget. Additionally, there is a utilization of $450,000 of fund balance in the adopted Fiscal Year 2013 Debt Service budget for the first year lease payment on the radio tower and equipment due to the current level of existing fund balance. There is a$1,280 one-time lump sum salary payment to employees included in the Fiscal Year 2013 budget, funded in part from the cost decrease in health insurance premiums. Additionally, there was the addition of one police officer, two positions in the Municipal Court due to the regionalization of Municipal Court with the bordering City of Keller, addition of a Systems Administrator in the Information Systems Management Department. The level of funding for street maintenance and rehabilitation was increased from $1 million to over $2.4 million to address needs on the City's streets. Slight revenue growth in the Water and Wastewater Fund will come from additional residential and commercial customers. There was an in-house water and wastewater rate study update completed in Fiscal Year 2012 that reviewed tiered rate options for increasing cost for increased usage by tier and incorporated passing through projected Trinity River Authority (TRA) rate increases to maintain the financial stability of the Water and Wastewater Fund in future years. In September 2012, City Council adopted the tiered water rates to encourage conservation, and those rates became effective December 1, 2012. REQUEST FOR INFORMATION The financial report is designed to provide our citizens, customers, investors and creditors with a general overview of the City's finances. If you have questions about this report or need any additional information, contact Terry Leake, Assistant City Manager / Chief Financial Officer, at 100 Main Street, Colleyville, Texas 76034, or call (817) 503-1115. 24 BASIC FINANCIAL STATEMENTS Zs CITY OF COLLEYVILLE, TEXAS STATEMENT OF NET ASSETS SEPTEMBER 30, 2012 ASSETS Cash and equivalents Investments Receivables (net of allowances for uncollectibles of $341,247) Accounts Property taxes Due from other governments Prepaid expenses Other assets Inventories Deferred charges Accrued interest Capital assets: Land Buildings and improvements Equipment Infrastructure/water distribution/sewer collection Construction in progress Less: accumulated depreciation Total capital assets Total assets LIABILITIES Accounts payable Accrued liabi]ities Unearned revenues Accrued interest payable Advances from developers Escrow funds Customer deposits Noncurrent liabilities: Due within one year Due in more than one year Total liabilities NET ASSETS Invested in capital assets, net of related debt Restricted: Debt service Court security and technology Grant programs Leisure services Econoinic development Streets and drainage Police Unrestricted Governmental Activities $ 17,759,089 14,961,647 64,481 228,806 1,012,815 131,043 1,621 190,574 19,517 9,293,654 45,603,909 ] 0,225,015 77,197,694 ],741,624 ( 47,252,135� 102,809,761 ] 37,179,354 531,405 350,656 976 119,060 193,105 68,147 2,353,335 17,976,515 21,593,199 83,211,988 1,159,092 91,637 21,116 207,736 1,998,845 8,192,568 1,143,454 19,559,719 Business-type Activities $ 7,531,008 3,879,079 2,397,933 108,778 137,618 4,594 313,057 53,922 1,509,282 69,054,295 512,948 ( 28,913,231) 42,530,273 56,589,283 1,021,891 53,531 25,798 73,396 26,613 434,574 993,194 3,232,340 5,861,337 38,395,708 12,332,238 Total net assets $ 115,586,155 $ 50,727,946 The accompanying notes are an integral part of these financial statements. 26 $ Total 25,290,097 18,840,726 2,462,414 228,806 1,012,815 131,043 108,778 139,239 190,574 24,111 9,606,711 45,657,831 11,734,297 146,251,989 2,254,572 ( 70,165,366) 145,340,034 193,768,637 1,553,296 404,187 976 144,858 266,501 26,613 502,721 3,346,529 21,208,855 27,454,536 121,607,696 1,159,092 91,637 21,116 207,736 1,998,845 8,192,568 1,143,454 31.891.957 $ 166,314,101 Component Units $ 14,289,331 888,750 83,767 1,137 1,800,940 4,551,672 � ]44,075) 6,208,537 21,471,522 112,940 18,131 540,000 4,335,260 5,006,331 1,333,277 15,131,914 $ 16,465,19 ] 2% CITY OF COLLEYVILLE, TEXAS STATEMENT OF ACTIVITIES FOR THE YEAR ENDED SEPTEMBER 30, 2012 Program Revenue Operating Grants Capita] Grants and Functions/Programs Expenses Cl�arges for Services and Contributions Contributions Primary government Governmental activities: General government $ 3,125,214 $ 28,408 Community development 1,397,839 1,146,518 Fire and rescue 4,321,929 335,307 Leisure services 4,124,619 520,433 Maintenance 400,306 - Municipal court 319,445 1,015,804 Police 4,579,570 81,056 Streets and drainage 3,073,530 338,845 Interest on long-term debt 780,029 - Total governmental activities 22,122,480 3,466,371 Business-type activities: Water and wastewater 12,258,587 14,034,600 Drainage 723,994 9] 8,323 Total business-type activities 12,982,581 14,952,923 Total primary government Component unit Tax increment financing Total component unit $ 35,105,061 $ 18,419,294 $ 236,992 $ - $ 236,992 $ - General revenues: Taxes: Property taxes, levied far general purposes Property taxes, levied for debt service TIF taxes Sales taxes Franchisetaxes Other taxes Investment earnings Miscellaneous Gain on sale of capital assets Transfers Total general revenues and transfers Change in net assets Net assets - beginning Net assets - ending $ 2,263 10,562 375,402 98,642 3,200 490,069 $ 490,069 $ - $ - The accompanying notes are an integral part of these financial statements. 28 $ - 16,668 364,640 381,308 169,464 169,464 $ 550,772 $ - $ - Net (Expense) Revenue and Changes in Net Assets Primary Government Governmental Business-type Activities Activities Total Component Units $( 3,094,543) $ ( 251,321� ( 3,976,060) ( 3,212,] 16� ( 400,306) 696,359 ( 4,399,872) ( 2,366,845) ( 780,029) � 17,784,73� ( 17,784,732) 10,766,534 ],647,923 5,495,730 2,207,463 65,808 108,192 74,041 147,969 1,081,868 21,595,528 3,8] 0,796 111,775,359 $ 115,586,155 1,945,477 ] 94,329 2,139,806 2,139,806 4,084 ( 1,081,868) ( 1,077,784) 1,062,022 49,665,924 $ 50,727,946 $( 3,094,543) ( 251,321) ( 3,976,060) ( 3,212,L1� ( 400,306) 696,359 ( 4,399,872) � 2,366,845) ( 980,029) ( 17,78�732) 1,945,477 194,329 2, I 39,806 ( 15,644,926) 10,766,534 1,647,923 5,495,730 2,207,463 65,808 112,276 74,041 147,969 20,517,744 4,872,8] 8 161,441,283 $ 166,314,101 29 $ - ( 236,992) ( 236,992) 4,310,889 27,837 4,338,726 4, l 01,734 12,363,457 $ 16,465,191 CITY OF COLLEYVILLE, TEXAS BALANCESHEET GOVERNMENTAL FUNDS SEPTEMBER 30, 2012 General Capital Projects ASSETS Cash and cash equivalents $ 4,534,467 $ 5,764,203 $ ]nvestments 8,420,044 2,578,466 Receivables (net of allowances for uncollectibles) Accounts 64,481 - Taxes 190,066 - Due from other governments 520,63A 10,791 Inventories ],621 - Accrued interest 9,509 4,406 Prepaid items 13],043 - _ Debt Service 1,238,856 38,740 556 Total assets $ 13,871,A69 $ 8,357,866 $ 1,278,152 LIABILITIES AND FUND BALANCES Liabilities: Accountspayable $ 460,896 $ 33,128 $ - Accrued liabilities 341,295 - - Deferred revenue 245,495 - 38,740 Advances from developers 47,2] 1 132,170 - Customer deposits 68,147 - - Total liabilities l,] 63,044 l 65,298 38,740 Fund balances: Non-spendable: lnventories 1,621 - Prepaid items 131,043 - Resh-icted: Streets and drainage - 8,192,568 Debt service - - Court security and technology - - Grant programs - - Leisure services - - Economic development - - Police - - Committed: Strategic incentives 295,198 - Sales ta�c incentives 518,338 - Leisure services - - Capital projects - - Assigned: 1,239,412 Cap�tal pro�ects - - - Recycling - - - Leisure services - - - Unassigned 11,762,625 - - Total fund balances 12,708,825 8, L92,568 1,239,412 Total liabilities and fund balances $ 13,871,869 $ 8,357,866 $ 1,278,152 Amounts reported for governmental activities in the statement of net assets are different because: Capital assets used in governmental activities are not financia] 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 re�orted in the funds. Net assets of governmental activities The accompanying notes are an integral part of these financial statements. 30 Other Govemmental $ 6,221,563 3,963,137 480,830 5,602 $ 10,671,132 $ 37,381 9,361 13,724 60,466 91,637 21,116 207,736 1,998,845 1,143,454 845,670 5,347,390 944,957 1,730 8,131 10,610,666 $ 10,671,132 Tota] Governmental Funds $ 17,759,089 ] 4,961,647 64,481 228,806 1,012,815 1,621 19,517 131,043 $ 34,179,019 $ 531,405 350,656 284,235 193,] OS 68,147 1,427,548 1,62] 131,043 8,192,568 1,239,412 91,637 21,ll6 207,736 1,998,845 ] ,143,454 295,198 518,338 845,670 5,347,390 944,957 1,730 8,131 ] 1,762,625 32,751,471 102,809,761 473,833 ( 20,448,910) $ 115,SA6,155 31 CITY OF COLLEYVILLE, TEXAS STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES GOVERNMENTAL FUNDS FOR THE YEAR ENDED SEPTEMBER 30, 2012 REVENUES Taxes Fees and fines Licenses and permits Intergovernmental Charges for services Capital improvement fees Donations Investment earnings Miscellaneous Total revenues EXPENDITURES Current General government Community development and engineering Fire and rescue Leisure services Maintenance Municipal cowt Police Streets and drainage Debt service: Principal Interest and other charges Capitat outlay Total expenditures EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Capital lease Sale of capital assets Transfers in Transfers out Total other financing sources and uses NET CHANGE IN FUND BALANCES FUND BALANCES, BEGINNING FUND BALANCES, ENDING General $ 15,942,603 990,507 1,113,123 1,030,439 61,626 67,703 19,206,001 2,460,764 1,253,068 3,873,140 2,640,392 394,830 249,787 3,839,766 1,150,488 1,567,281 17,429,516 1,776,485 894,534 147,969 1,081,868 ( 2,124,352) 19 1,776,504 10,932,321 $ 12,708,825 Capital Projects $ - 116,159 322,498 13,956 452,613 6,847 238,482 286,174 531,503 � �8,890) 1,843,352 1,843,352 1,764,462 6,428,106 $ 8,192,568 The accompanying notes are an integral part of these financial statements. 32 Debt Service $ 1,654,744 2,803 6,338 1,663,885 1,692,585 426,006 2,118,591 ( 454,706) 505,2ll 505,217 50,505 1,188,907 $ 1,239,412 Other Governmental $ 2,637,665 61,392 17,303 7, 897 406,789 32,165 15,000 3,178,21 1 292,693 143,191 15,085 409,516 69,297 458,097 315,000 331,588 661,660 2,696,127 482,084 463,153 ( 687,364) ( 224,211) 257,873 10,352,793 Total Governmental Funds $ 20,235,012 1,051,899 1,130,426 124,056 1,030,439 322,498 406,789 110,550 89,041 24,500,710 2,753,457 1,396,259 3,888,225 3,049,908 394,830 319,084 4,304,710 1,388,970 2,007,585 757,594 2,S15,ll5 22,775,737 1,724,973 894,534 147,969 3,893,584 ( 2,811,716) 2,124,371 3,849,344 28,902,127 $ 10,610,666 $ 32,751,471 33 CITY OF COLLEYVILLE, TEXAS RECONCILIATION OF THE STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES OF GOVERNMENTAL FUNDS TO THE STATEMENT OF ACTNITIES FOR THE YEAR ENDED SEPTEMBER 30, 2012 Amounts reported for governmental activities in the StatemenY of Activities (pages 28 - 29) are different because: Net change in fund balances - total governmental funds: Governmental funds report capital outlays as expenditures. However, in the statement of activities, the cost of those assets is allocated over their estimated useful lives and reported as depreciation expense. The net effect of transactions involving capital assets is to increase net assets. Revenues, in the statement of activities, that do not provide current financial resources, are not reported as revenues in the funds. The issuance of long-term debt (e.g., bonds, leases) provides current financial resources to governmental funds, while the repayment of the principal of long- term debt consumes the current financial resources of governmental funds. Some expenses reported in the statement of activities do not require the use of current financial resources and therefore are not reported as expenditures in governmental funds. Change in net assets of governmental activities The accompanying notes are an integral part of these financial statements. 34 $ 3,849,344 ( 1,323,570) 259,955 ( 45,752) 1,109,461 ( 38,642) $ 3,810,796 CITY OF COLLEYVILLE, TEXAS GENERAL FUND STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED SEPTEMBER 30, 2012 REVENUES Taxes License and permits Fines and forfeitures Charges for services Investment earnings Other Total revenues EXPENDITURES Current: General government Community development and engineering Fire and rescue Leisure services Maintenance Municipal court Police Streets and drainage Capital outlay Total expenditures EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Transfers in Transfers out Sale of capital assets Capital lease Total other financing sources and uses NET CHANGE IN FUND BALANCE FUND BALANCE, BEGINNING Budgeted Amounts Original Final $ 15,132,335 595,567 890,124 871,413 35,001 45,300 17,569,740 2,621,780 1,284,190 3,894,755 2,808,744 432,361 252,014 4,199,748 2,113,942 422,962 18,030,496 $ 15,132,335 595,567 890,124 871,413 35,001 45,300 17,569,740 2,621,780 1,284,190 3,894,755 2,808,744 432,361 252,014 4,199,748 2,113,942 422,962 18,030,496 Actual Amounts $ 15,942,603 1,113,123 990,507 1,030,439 61,626 67,703 19,206,001 2,460,764 1,253,068 3,873,140 2,640,392 394,830 249,787 3,839,766 1,150,488 1,567,281 17,429,516 Variance with Final Budget - Positive (Negativc) $ 810,268 517,556 100,3 83 159,026 26,625 22,403 1,636,261 161,016 31,122 21,615 168,352 37,531 2,227 359,982 963,454 ( 1,144,319) 600,980 ( 460,756) ( 460,756) 1,776,485 2,237,241 901,829 901,829 1,081,868 180,039 ( 541,000) ( 1,541,000) ( 2,124,352) ( 583,352) 3,000 3,000 147,969 144,969 - - 894,534 894,534 363,829 ( 636,171) 19 636,190 � 96,92�� � 1,o96,9z�� 1,��6,so4 10,932,321 10,932,321 10,932,321 2,873,431 FUND BALANCE, ENDING $ 10,835,394 $ 9,835,394 $ 12,708,825 $ 2,873,431 The notes to the financial statements are an integral part of this statement. 35 ASSETS Current assets: Cash and cash equivalents Investments Accounts receivable, net of allowances Other assets Inventories Total current assets Non-current assets: Accrued interest receivable Capital assets: Land and improvements Buildings Utility system Equipment and furniture Construction in progress Less accumulated depreciation Total non-current assets To�� assets LIABILITIES Current liabilities: Accounts payable Accrued liabilities Accrued interest payable Advances from developers Gscrow funds Customer deposits Compensated absences Revenue bonds payable Total cu�rent liabilities Non-current liabilities: Compensated absences Revenue bonds payable Total non-current liabilities Total liabilities NET ASSETS Invested in capital assets, net of related debt Restricted for debt service Unrestricted Total net assets CITY OF COLLEYVILLE, TEXAS STATEMENT OF NET ASSETS PROPRIETARY FUNDS SEPTEMBER 30, 2012 Enterprise Funds Water and Wastewater Drainage Utility Total $ 6,453,846 3,759,265 2,289,496 84,327 137,618 12,724,552 4,495 313,057 53,922 64,925,931 1,043,707 471,456 ( 29,�81,140) 39,031,428 si,�ss,9xo 1,015,816 44,637 18,019 73,396 26,6 ] 3 434,574 14,676 765,000 2,392,731 58,703 2,031,O12 2,089,715 4,482,446 36,230,92 ] 11,042,613 $ 47,273,534 $ ],077,162 119,814 108,437 24,451 1,329,864 99 4,128,364 465,575 41,492 ( 1,132,091) 3,503,439 4,833,303 6,075 8,894 7,779 3,S l8 2 ] 0,000 236,266 14,072 1,128,553 1,142,625 ],378,891 2,164,787 1,289,625 $ 3,454,412 The accompanying notes are an integral part of these financial statements. 36 $ 7,531,008 3,879,079 2,397,933 108,778 137,618 14,054,416 4,594 313,057 53,922 69,054,295 1,509,282 512,948 ( 28,913,231) 42,534,867 56,589,283 1,021,891 53,531 25,798 73,396 26,613 434,574 18,194 975,000 2,628,997 72,775 3,159,565 3,232,340 5,861,337 38,395,708 12,332,238 $ 50,727,946 CITY OF COLLEYVILLE, TEXAS STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND NET ASSETS PROPRIETARY FUNDS FOR THE YEAR ENDED SEPTEMBER 30, 2012 OPERATING REVENUES Metered watier salEs Wastewater service charges Drainagc service charges Other charges and services Miscellaneous Total operating revenues OPERATING EXPENSES Personnel serviccs Maintenance and contractual services Materials and supplies Depreciation and amortization Total operating expenses OPERATING INCOME NON-OPERATING REVENUES (EXPENSES) Interest and investment revenues Interest expense and fiscal charges Loss on disposal of property Total non-operating revenues (expenses) INCOME BEFORE CONTRIBUTIONS AND TRANSFERS Capital contributions Transfers out CHANGE IN NET ASSETS TOTAL NET ASSETS, BEGINNING TOTAL NET ASSETS, ENDING Enterpnse Funds Water and Wastewater Drainage Utility Total $ 10,150,129 2,965,143 865,763 53,565 14,034,600 1,577,921 8,625,914 19l ,682 1,734,865 12,130,382 1,904,218 1,725 ( 77,947) � 50,258� ( 126,480) 1,777,738 169,464 ( 1,081,868) 865,334 46,408,200 $ 47,273,534 $ - 904,574 13,749 918,323 386,186 112,162 33,357 128,750 660,455 257,868 2,359 � 51,244) � 12,295) ( 61,180) 196,688 196,688 3,257,724 $ 3,454,412 The accompanying notes are an integral part of these financial statements. 37 $ 10,150,129 2,965,143 904,574 879,512 53,565 14,952,923 1,964,107 8,738,076 225,039 1,863,615 12,790,837 2,162,086 4,084 ( 129,19 L) ( 62,553) ( 187,660) 1,974,426 169,464 ( 1,081,868) 1,062,022 49,665,924 $ 50,727,946 CITY OF COLLEYVILLE, TEXAS STATEMENT OF CASH FLOWS PROPRiETARY FUNDS FOR THE YEAR ENDED SEPTEMBER 30, 2012 CASH FLOWS FROM OPERATING ACTIVITIES Cash received from customers Cash paid to suppliers far goods and services Cash paid to employees for services Net cash provided by operating activities CASH FLOWS FROM NONCAPITAL FINANCiNG ACTIVITiES Transfers out Net cash used for noncapital financing activities CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES Acquisition of capital assets Principal paid on debt Interest paid on debt Net cash used for capital and related financing activities CASH FLOWS FROM INVESTING ACTIVITIES (Purchase) sale of investments Earnings on investments Net cash provided (used) by investing activities NET INCREASE IN CASH AND CASH EQUIVALENTS CASH AND CASH EQUIVALENTS, BEGINNING CASH AND CASH EQUIVALENTS, ENDING Enterprise Funds Water and Drainage Wastewater Utility Totals $ 14,241,059 $ 917,635 $ 15,158,694 � s,sao,idl� � i4o,316� � s,96o,4��> ( 1,570,936) ( 386,148) ( 1,957,084) 3,849,962 391,171 4,241,133 ( 1,081,868) ( 1,081,868) ( 2�0,752� ( 750,000) ( 77,947) ( 1,098,699) ( ]01,485) 1,725 ( 99,760� 1,569,635 4,884,211 $ 6,453,846 (continued) 38 ( 205,000) ( S1,244) ( 256,244) ( 256) 2,359 2,103 137,030 940, l 32 $ 1,077,162 ( 1,08],868) ( 1,081,868) ( 270,752) ( 955,000) ( 129,19] ) ( 1,354,943) ( 101,741) 4,084 ( 97,657) 1,706,665 5,824,343 $ 7,531,008 CITY OF COLLEYVILLE, TEXAS STATEMENT OF CASH FLOWS PROPRIETARY FUNDS (Continued) FOR THE YEAR ENDED SEPTEMBER 30, 2012 Reconciliation of operaring income (loss) to net cash provided (used) by operating activities: Operating income Adjustments to reconcile operating income (loss) to net cash provided by (used for) operating activities: Depreciation and amortization expense Changes in assets and liabilities: Decrease (increase) in assets: Accounts receivable Inventory Accrued interest receivable Other assets Inarease (decrease) in liabilities: Accounts payable Accrued liabilities Compensated absences payable Customer deposits Accrued interest payable Net cash provided by operations Noncash investing, capital, and financing activities: Contributions of capita] assets Enterprise Funds Water and Drainage Wastewater Utility Totals $ 1,904,218 $ 257,868 $ 2,162,086 1,734,865 199,659 � 10,053) � 2,760) ( 21,1�2� 36,888 5,556 1,429 6,800 ( 5,468) $ 3,849,962 128,750 ( 688) ( 16) 4,164 ( 1,743) 1,781 1,055 $ 391,171 $ 169,464 $ - The notes to the financial statements are an integral part of this statement. 39 1,863,615 198,971 ( 10,053) ( 2,776) ( 27,1�2) 41,052 3,813 3,210 6,800 ( 4,413) $ 4,241,133 $ 169,464 CITY OF COLLEYVILLE, TEXAS STATEMENT OF FIDUCIARY NET ASSETS FIDUCIARY FUNDS SEPTEMBER 30, 2012 ASSETS Cash and investments Total assets LIABILITIES Due to other agencies and individuals Total liabilities Agency Fund $ 23,904 $ 23,904 $ 23,904 $ 23,904 The accompanying notes are an integral part of these financial statements. 40 CITY OF COLLEYVILLE, TEXAS NOTES TO THE FINANCIAL STATEMENTS SEPTEMBER 30, 2012 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. Reportin� Entitv As required by generally accepted accounting principles, these financial statements present the government and its component units, entities for which the government is considered to be financially accountable. Blended component units, although legally separate entities are, in substance, part of the government's operations and so data from these units are combined with data of the primary government. Each directly presented component unit, on the other hand, is reported in a separate column in the combined financial statements to emphasize it is legally separate from the government. Each blended component unit has a September 30 year-end. Blended Component Unit — The Colleyville Economic Development Corporation (CEDC) was incorporated on September 3, 1996, as a nonproiit 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 Corpara�ion is organized. This includes municipa] park improvements, the purchase of land and improvements for additional neighborhood parks, the construction of a community center and library. Although it is legally separate from the City, the CEDC is reported as if it were part of the primary government, because CEDC is financing public improvements and the City is the primary beneficiary of the services provided. (continued) 41 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) A. Reporting 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 seven- member board consisting of all members of the City Council. The District is reported as a part of the primary government because it provides services entirely for the City. Discretely Presented Component Unit — Colleyville Tax Increment Financing Reinvestment Zone Number One (the TIF) was formed to make public improvements, under the authority of the Tax Increment Financing Act. The TIF is governed by a 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. Complete financial statements for the TIF inay be obtained from the City of Colleyville Finance Department, 100 Main Street, Colleyville, Texas 76034. 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-type activities, which rely to a significant extent on fees and charges for support. Likewise, the primary government is reported separately from certain legally separate component units for which the primary government is financially accountable. The statement of activities demonstrates the degree to which the direct expenses of a given function or segment are offset by program revenue. Direct expenses are those that are clearly identifiable with a specific function or seginent. Program revenue includes 1) charges to customers or applicants who purchase, use, or directly benefit from goods, services, or privileges provided by a given function or segment, and 2) grants and contributions that are restricted to meeting the operational or capital requirements of a particular function or segment. Taxes and other items not properly included among program revenue are reported instead as general revenue. Separate financial statements are provided for governmental funds, proprietary funds, and fiduciary funds, even though the latter are excluded from the government-wide financial statements. Major individual governmental funds and major individual Enterprise Funds are reported as separate columns in the fund financial statements. (continued) 42 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) C. Measurement Focus, Basis of Accounting and Financial Statement Presentation The government-wide financial statements are reported using the economic resources measurement focus and the accrual basis of accounting, as are the proprietary fund and fiduciary fund financial statements, except for Agency Funds, which have no measurement focus. Revenues are recorded when earned and expenses are recorded when a liability is incurred, regardless of the timing of related cash flows. Property taxes are recognized as revenue in the year for which they are levied. Grants and similar items are recognized as revenue as soon as all eligibility requirements imposed by the provider have been met. Governmental fund financia] 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 recarded 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 �und type) are accounted for through governmental funds. The measurement focus is upon determination of changes in financial position, rather than upon net income determination. The following are the City's governmental fund types: The City reports the following major governmental funds: The General Fund — is the general operating fund of the City. It is used to account for all financial resources except those required to be accounted for in another fund. The Debt Service Fund — is used to account for the acquisition of resources for, and the payment of, general long-term debt principal and interest, and related costs. (continued) 43 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) C. Measurement Focus, Basis of Accountin� and Financial Statement Presentation (Continued) GOVERNMENTAL FUNDS (Continued) The Capital 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. Additionally, the City also reports the following fund type: The Special Revenue Fund — accounts for the revenues and expenditures associated with a special project or purpose. PROPRIETARY FUNDS Proprietary Funds are used to account for activities that are similar to those often found in the private sector. The measurement focus is upon determination of net income and capital maintenance. The City reports the following major proprietary funds: The Water and Wastewater Fund — is used to account for operations (a) that are financed and operated in a manner similar to private business enterprises — where the intent of the governing body is that the costs (expenses, including depreciation) of providing goods or services to the general public on a continuing basis be financed or recovered primarily through user charges; or (b) where the governing body has decided that periodic determination of revenue earned, expenses incurred, and/or net income is appropriate for capital maintenance, public policy, management control, accountability, or other purposes. This fund is used to account for water and wastewater operations. The Draina�e Utilitv Fund — is used to account for the establishment and maintenance of drainage facilities within the municipal boundaries of the City. All activities necessary to provide such facilities are accounted for in this fund, included but not limited to, administration, operations, maintenance, billing and collections. (continued) 44 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) C. Measurement Focus, Basis of Accounting and Financial Statement Presentation (Continued) FID UCIAR Y F UNDS A�encv 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. These funds are held for the benefit of City employees and to benefit the City's historical purposes. Private-sector standards of accounting and financial reporting issued prior to December 1, 1989, generally are followed in both the government-wide and proprietary fund financial statements to the eXtent that those standards do not conflict with or contradict guidance of the Governmental Accounting Standards Board. Governments also have the option of following subsequent private-sector guidance for their business-type activities and Enterprise Funds, subject to this same limitation. The City has elected not to follow subsequent private-sector guidance. As a general rule, the effect of interfund activity has been eliminated from the 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 Equivalents For purposes of the statement of cash flows, the Enterprise Fund considers all highly liquid investments (investments with original maturities less than 90 days, including restricted assets) to be cash equivalents. (continued) 45 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) E. Investments In accordance with GASB Statement No. 31, the City's general policy is to report money market investments and short-term participating interest-earning investment contracts at amortized cost and to report nonparticipating interest-earning investment contracts using a cost-based measure. However, if the fair value of an investment is significantly affected by the impairment of the credit standing of the issuer or by other factors, it is reported at fair value. All other investments are reported at fair value unless a legal contract exists which guarantees a higher value. The term "short-term" refers to investments, which have a remaining term of one year or less at time of purchase. The term "nonparticipating" means that the investrnent'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) ar"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 �nancial 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, 2012. 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, ar 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). 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 ar estimated historical cost if purchased or constructed. Donated capital assets are recarded at estimated fair market value at the date of donation. (continued) 46 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) H. Capital Assets (Continued) 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 15 - 50 Improvements 20 - 50 Equipment 5 - 10 Infrastructure (streets and drainage) 50 Water distribution/sewer collection 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 ihe City, except far retirement, and such amounts are not considered material. All vacation pay is accrued when incurred in the government-wide and proprietary fund financial statements. K. Long-term Obli�ations In the government-wide financial statements and proprietary fund types in the fund financial statements, long-term debt and other long-term obligations are reported as liabilities in the applicable governmental activities, business-type activities, or proprietary fund type statement of net assets. In the fund financial statements, the face amount of debt issued is reported as other financing sources for the governmental fund types. 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 tbe 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. (continued) 47 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) L. Fund Balance Classification The governmental fund financial statements present fund balances based on classifications that comprise a hierarchy that is based primarily on the extent to which the City is bound to honor constraints on the specific purposes for which amounts in the respective governmental funds can be spent. The classifications used in the governmental fund financial statements are as follows: • Nonspendable: This classification includes amounts that cannot be spent because they are either (a) not in spendable form or (b) are legally or contractually required to be maintained intact. Nonspendable items are not expected to be converted to cash or are not expected to be converted to cash within the next year. • Restricted: This classification includes amounts for which constraints have been placed on the use of the resources either (a) externally imposed by creditors, grantors, contributors, or laws or regulations of other govermnents, or (b) imposed by law through constitutional provisions or enabling legislation. • Committed: This classification includes amounts that can be used only for specific purposes pursuant to constraints imposed by board resolution of the City Council, the City's highest level of decision making authority. These amounts cannot be used for any other purpose unless the Council removes or changes the speci�ed use by taking the same type of action that was employed when the funds were initially committed. This classification also includes contractual obligations to the extent that eXisting resources have been specifically coinmitted for use in satisfying those contractual requirements. • Assigned: This classification includes amounts that are constrained by the City's intent to be used for a specific purpose but are neither restricted nor committed. This intent can be expressed by the City's Assistant City Manager/Chief Financial Officer. • Unassigned: This classification includes the residual fund balance for the General Fund. The unassigned classification also includes negative residual fund balance of any other governmental fund that cannot be eliminated by offsetting of assigned fund balance amounts. When an expenditure is incurred for purposes for which both restricted and unrestricted fund balance is available, the City considers restricted funds to have been spent first. When an expenditure is incurred for which committed, assigned, or unassigned fund balances are available, the City considers amounts to have been spent first out of committed funds, then assigned funds, and finally unassigned funds. M. Minimum Unassigned Fund Balance It is the goal of the City to achieve and maintain an unassigned fund balance in the General Fund equal to three months of that year's budgeted expenditures for both the General and Utility Funds. The City Council may declare a fiscal emergency and withdraw any amount of the unassigned General and Utility Funds' balances for purposes of addressing the fiscal emergency. Any such action must also provide for necessary appropriations to restore the designated fund balance to the balance within a three-year period. (continued) 48 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) N. Net Assets Net assets represent the difference between assets and liabilities. Net assets invested in capital assets, net of related debt, consist of capital assets, net of accumulated depreciation, reduced by the outstanding balances of any borrowing used for the acquisition, construction or improvements of those assets, and adding back unspent proceeds. Net assets are reported as restricted when there are limitations imposed on their use either through the enabling legislations adopted by the City or through external restrictions imposed by creditors, grantors or laws or regulations of other governments. O. Estimates The preparation of financial statements, in conformity with generally accepted accounting principles, requires management to make estimates and assumptions that affect the reported amounts of assets and liabilities and disclosures of contingent liabilities at the date of the financial statements and the reported amounts of revenue and expenses during the reporting period. Actual amounts could differ from those estimates. P. 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' 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. 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 $(20,448,910) difference are as follows: Bonds payable Capital leases payable Accrued interest payable Compensated absences Net adjustment to reduce fund balance - total governmental funds to arrive at net assets - governmental activities (continued) 49 $( 1�,sss,653) ( 1,709,]20) ( 119,060) ( 732,077) $( 20,448,910) 2. RECONCILIATION OF GOVERNMENT-WIDE AND FUND FINANCIAL STATEMENTS (Continued) Explanation of Certain Differences Between the Governmental Fund Statement of Revenue, Expenditures and Changes 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 $(1,323,570) difference are as follows: Capital outlay Depreciation expense Net adjustment to increase net changes in fund balances - total governmental funds to arrive at changes in net assets of �governmental activities $ 2,515,115 ( 3,838,685) $( 1,323,570) 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 $(45,752) difference are as follows: Property taxes Ambulance revenue Adjudicated fines Net adjustment to increase net changes in fund balances - total govern�nental funds to arrive at changes in net assets ofgovernmental activities $( 51,554) 6,536 ( 734) $( 45,752) 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,109,461 difference are as follows: Principal payments and refundings Issuance of debt Net adjustment to reduce fund balance -total governmental funds to arrive at net assets - governmental activities $ 2,003,995 ( 894,534) $ 1,109,461 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 $(38,642) difference are as follows: Compensated absences Accrued interest Deferred charges Net adjustment to decrease net changes in fund balances - total governmental funds to arrive at changes in net assets ofgovernmental activities 50 $( I9,�9�) 12,916 ( 31,761) $( 38,642) 3. STEWARDSHIP, COMPLIANCE AND ACCOUNTABILITY A. Budgetarv 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, 2012. (6) Budgets for the General and the Debt Service Funds are adopted on a basis consistent with generally accepted accounting principles (GAAP). Formal budgeted amounts are as amended by the City Council for the General, Debt Service and Enterprise Funds. (7) Budgetary data for the Capital Projects Fund has not been presented in the accompanying basic financial statements, as such funds are budgeted over the life of the respective project and not on an annual basis. Accordingly, formal budgetary integration of the Capital Projects Fund is not employed and comparison of actual results of operations to budgetary data for such fund is not presented. (8) Budgetary data for the Enterprise and Drainage Utility Funds has not been presented since the reporting on such budgets is not legally required. Expenditures Over Appropriations General Fund expenditures in the capital outlay function exceeded appropriations by $1,144,319. This overage was funded by under spending in other functions. 51 4. DETAILED NOTES ON ALL FUNDS Deposits and Investments As of September 30, 2012, the City had the following investments: Investment Type LOGIC U. S. Treasuries and Agencies Total fair value Fair Value $ 23,768,758 19,718,651 $ 43,487,409 Weighted Average Maturity (Days) 48 368 The Public Funds Investment Act (Government Code Chapter 2256) contains specific provisions in the areas of investment practices, management reports and establishment of appropriate policies. Among other things, it requires the City to adopt, implement, and publicize an investment policy. That policy must address the following areas: (1) safety of principal and liquidity, (2) portfolio diversification, (3) allowable investments, (4) acceptable risk levels, (5) eXpected rates of return, (6) maximum allowable stated maturity of portfolio investments, (7) maximum average dollar-weighted maturity allowed based on the stated maturity date for the portfolio, (8) investment staff quality and capabilities, and (9) bid solicitation preferences for certificates of deposit. Statutes authorize the City to invest in (1) obligations of the U. S. Treasury, certain U. S. agencies, and the State of Texas; (2) certificates of deposit, (3) certain municipal securities, (4) money market savings accounts, (5) repurchase agreements, (6) bankers acceptances, (7) Mutual Funds, (8) investment pools, (9) guaranteed investment contracts, and (10) common trust funds. The Act also requires the City to have independent auditors perform test procedures related to investment practices as provided by the Act. The City is in substantial compliance with the requirements of the Act and with local policies. The City's investment pools are 2a7-like pools. A 2a7-lilce pool is one which is not registered with the Securities and Exchange Commission ("SEC") as an investment company, but nevertheless has a policy that it will, and does, operate in a manner consistent with the SEC's Rule 2a7 of the Investment Company Act of 1940. Interest Rate Risk. In accordance with its investment policy, the government manages its exposure to declines in fair market values by limiting the average dollar weighted maturity of its investment portfolios to a maximum of 540 days. (continued) 52 4. DETAILED NOTES ON ALL FUNDS (Continued) Deposits and Investments (Continued) Custodial C�edit Risk. In the case of deposits, this is the risk that in the event of a bank failure, the City's deposits may not be returned to it. As of September 30, 2012, the City's entire $12,395,786 deposit balance was covered by FDIC insurance. Credit Risk. It is the City's policy to limit its investments to investment types with an investment quality rating not less than A or its equivalent by a nationally recognized statistical rating organization. The City's investment pools are rated as follows by Standard & Poor's Investors Service. LOGIC U. S. Treasuries and Agencies Receivables AAAm AA+ 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 Capital Debt Nonmajor Water and Drainage General Projects Service Funds Wastewater Utility ToYal Receivables: Accounts $ 416,005 $ - $ - $ - $ 2,324,124 $ 108,437 $ 2,848,566 Taxes 190,066 - 38,740 - - - 228,806 Due from other govcrnments 520,638 10,791 556 480,830 - - 1,012,815 Accrued interest 9,509 4,406 - 5,602 4,495 99 24,111 Grossreceivables 1,136,218 15,197 39,296 486,432 2,328,619 IOA,536 4,114,298 Less: allowance for uncollecribles ( 351,524) - - - ( 34,628) - ( 386,152) Net total receivables $ 784,694 $ 15,197 $ 39,296 $ 486,432 $ 2,293,991 $ 108,536 $ 3,728,146 (continued) 53 4. DETAILED NOTES ON ALL FUNDS (Continued) Receivables (Continued) Governmental funds report deferred revenue in connection with receivables for revenue that is not considered to be available to liquidate liabilities of the current period. Governmental funds also defer revenue recognition in connection with resources that have been received, but not yet earned. At the end of the current fiscal year, the various components of deferred revenue and unearned revenue reported in the governmental funds were as follows: General fund Delinquent property taxes receivable Ambulance charges for services Municipal court fines Other Total general fund Debt service fund Delinquent property taxes receivable Tota] debt service fund Total governmental funds Unavailable $ 190,066 40,104 14,349 244,519 38,740 38,740 Unearned $ - 976 976 $ 283,259 $ 976 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 2012 levy was based, was $3,730,446,941. 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, 2012, was $.3559 per $100 of assessed valuation. Taxes are due by January 31 �ollowing the levy date. Tax collections, including related penalties and interest, was $12,466,011 for the year ended September 30, 2012. Property taxes receivable at September 30, 2012, were $228,806. 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, if necessary, legal action. (continued) 54 4. DETAILED NOTES ON ALL FUNDS (Continued) Capital Assets Capital asset activity for the year ended September 30, 2012, was as follows: Primary Government Beginning Cnding Balance Increases Decreases Balance Governmental activities: Capital assets, not being depreciated: Land $ 9,293,654 $ - $ - $ 9,293,654 Construction in progress 1,178,455 1,275,384 ( 7] 2,215) 1,741,624 Total assets not being depreciated 10,472,109 1,275,384 ( 712,215) 11,035,278 Capital assets, being depreciated: Buildings and improvements 44,880,314 723,595 - 45,603,909 Machinery and equipment 9,390,361 1,250,496 ( 415,842) 10,225,015 Infrastructure 76,959,884 237,810 - 77,197,694 Total capital assets being depreciated 131,230,559 2,211,901 ( 415,842) 133,026,618 L,ess accumulated depreciation: Buildings and improvements ( 11,571,600) ( 1,448,200) - ( 13,019,800) Machinery and equipment ( 6,630,979) ( 845,931) 415,842 ( 7,061,068) Improvements otherthan buildings ( 19,626,713) ( 1,544,554) - ( 21,171,267) Total accumulated depreciation ( 37,829,292) ( 3,838,685) 415,842 ( 41,252,135) Total capita] assets being depreciated, net 93,401,267 ( 1,626,784) - 91,774,483 Governmental activities capital assets, net $ 103,873,376 $( 351,400) $( 712,215) $ 102,809,761 (continued) 55 4. DETAILED NOTES ON ALL FUNDS (Continued) Capital Assets (Continued) Business-type acYivities: Capital asseCs, not being depreciated: Land Construction in progress Total assets not being depreciaYed CapiYal assets, being depreciaYed: Buildings and improvements Machinery and equipment Improvements other than buildings Total capital assets being depreciated Less accumulated depreciation: Buildings and i�nprovements Machinery and equipmenC improvements other than buildings Total accumulated depreciation Total capital assets being depreciated, net Business-type activities capital assets, net Component unit: Capital assets, not being depreciated: Infrastructurc Total assets not being depreciated Capita] asscts, being depreciated: Improvements other than buildings Total capital assets being depreciated Less accumulated depreciation: Improvements other than buildings ToYal accumulated depreciation Total capital assets being depreciated, net Component unit capital assets, net Beginning Balance lncreases $ 313,057 $ - 718,330 62,017 ],031,387 62,017 53,922 1,595,394 68,457,511 70, I 06,827 48,812 596,784 645,596 Decreases $ - ( 267,399) ( 267,399) ( 134,924) ( 134,924) Ending Balance $ 313,057 512,948 826,005 53,922 1,509,282 69,054,295 70,617,499 ( 47,706) ( 622) - ( 48,328) ( 2,415,862) ( 97,613) 72,37] ( 2,441,104) ( 24,699,698) ( 1,724,101) - ( 26,423,799) ( 27,163,266) ( 1,822,336) 72,371 ( 28,913,231) 42,943,56] ( 1,176,740) ( 62,553) 41,704,268 $ 43,974,94A $( 1,114,723) $( 329,952) $ 42,530,273 $ 4,453,810 $ 97,862 $ 4,453,810 97,862 $ 1,800,940 $ - $ ],800,940 - $( 108,05� �( 36,018) $ � ]08,059) � 36,018) 1,692,883 ( 36,018) $ 6,146,693 $ 61,844 $ (continued) 56 - $ 4,551,672 - 4,SS1,672 - $ 1,800,940 - 1,800,940 $( 144,07� � 144,075) 1,656,865 $ 6,208,537 4. DETAILED NOTES ON ALL FUNDS (Continued) Capital Assets (Continued) Depreciation expense was charged to functions/programs of the primary government as follows: Governmental activities: General government $ 380,115 Fire and rescue 429,304 Leisure scrvices 1,071,260 Maintenance 5,029 Police 269,989 Streets and drainage 1,682,988 Total depreciation expense - governmental activities $ 3,838,685 Business-type activities: Water and wasYewater $ 1,697,816 Drainage utility 124,520 Total depreciation expense - business-type activiries $ 7,822>336 Construction Commitments The government has active construction projects as of September 30, 2012. The major projects are listed as follows: Proj ect John MeCain/Pleasant Run intersection improvements Total Remaining Spent-to-date Commitment $ 232,127 $ 741,590 $ 232,127 $ 741,590 Interfund Transfers The composition of interfund balances as of September 30, 2012, is as follows: Interfund Transfers Transfer In Capital Debt General Projects Service Nonmajor Government Funds Total Transfer Out: General $ - $ 1,843,352 $ - $ 281,000 $ 2,124,352 Nonmajar governmental - - 505,211 182,153 687,364 Waterandwastewater 1,081,868 - - - 1,081,868 Total Transfers Out $ 1,081,868 $ 1,843,352 $ 505,211 $ 463,153 $ 3,893,584 (continued) 57 4. DETAILED NOTES ON ALL FUNDS (Continued) Interfund Transfers (Continued) The transfer of $1,081,868 from the Utility Fund to the General Fund represents the 2012 Administrative transfer and the franchise fee based on gross water and wastewater revenue of the prior year's audited financial statements. The transfer of $2,124,352 from the General Fund to the Capital Projects and nonmajor governmental funds represents transfers for capital replacement. The transfer of $505,211 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. Long-term Liabilities General Obligation Bonds The government issue construction of major governmental activities was $34,030,000. general obligation bonds to provide funds for the acquisition and capital facilities. General obligation bonds have been issued for The original amount of general obligation bonds issued in prior years 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: Pumose Governmental activities Interest Rates 3.64°/a - 4.2% (continued) 58 Ainount $ 17,905,000 $ 17,905,000 4. DETAILED NOTES ON ALL FUNDS (Continued) Lon�-term Liabilities (Continued) General Obligation Bonds (Continued) Long-term liability activity for the year ended September 30, 2012, was a follows: Balance Balance September 30, September 30, 2011 Additions Retirements 2012 Governmental activities General obligation bonds and certificates of obligation Premium on bonds Deferred loss on refunding Sales tax revenue bonds Capital lease obligations Compensated absences Total governmental activities Business-tvpe activities Revenue bonds and certificates of obligation Premium on bonds Loss on refunding Compensated absences Total business-type activities Amounts Due Within One Year $ ll,510,000 $ - $ 1,535,000 $ 9,975,000 $ 1,300,000 5,905 - 656 5,249 - ( 52,119) - ( 5,791) ( 46,328) - 8,271,278 - 316,546 7,954,732 330,000 972,170 894,534 ]57,584 1,709,120 576,920 712,280 440,201 420,404 732,077 146,415 21,419,514 1,334,735 2,424,399 20,329,850 2,353,335 5,150,000 - 955,000 4,195,000 975,000 99,756 - 9,976 89,780 - ( 166,906) - ( 16,691) ( 150,215) - 87,759 51,887 48,677 90,969 18,194 5,170,609 51,887 996,962 4,225,534 993,194 Total primary government $ 26,590,123 $ 1,386,622 $ 3,421,361 $ 24,555,384 $ 3,346,529 Component unit Tax increment financing fund revenue bonds $ 5,295,000 $ - $ 530,000 $ 4,765,000 $ 540,000 Bond premium 167,804 - 20,976 146,828 - Loss on refunding ( 41,792) - ( 5,224) ( 36,568) - Tofal component unit $ 5,421,012 $ - $ 545,752 $ 4,875,260 $ 540,000 For the governmental activities, compensated absences are generally liquidated by the General Fund. (continued) 59 4. DETAILED NOTES ON ALL FUNDS (Continued) Lon�-term Liabilities (Continued) Governmental activities long-term liabilities at September 30, 2012, consisted of the following: General obligation bonds and certificates of obligation serviced by property tax revenue: $4,895,000 Series 2006 General Obligarion Refunding bonds due in annual installments of $25,000 to $540,000 through February 15, 2019; interest at 3.64%. $4,575,000 Series 2007 General Obligation Bonds due in annual installments of $50,000 to $555,000 through February 15, 2027; interest at 4.00% to 5.00%. $2,945,000 Series 2011 General Obligation Refunding Bonds due in annual installments of $135,000 to $800,000 through February 15, 2020; interest at 2.00% to 4.00%. $ 3,455,000 4,375,000 2,145,000 Total General Obligation Bonds and Certificates of Obligation $ 9,975,000 $9,570,000 Series 2005 Colleyville Economic Development Corporation Refunding and Improvement Sales Tax Revenue Bonds due in annual installments of $20,000 to $635,000 through February 15, 2029; interest at 4.10% Unamortized gain on refunding Total Revenue Bonds $ 7,930,000 24,732 $ 7,954,732 The funds utilized for the repayment of long-term liabilities for governmental activities are the Debt Service Fund, the Crime District Fund and the Colleyville Economic Development Corporation. (continued) 60 4. DETAILED NOTES ON ALL FUNDS (Continued) Lon�-term Liabilities (Continued) The City's defeased debt as of September 30, 2012, was $12,419,035. Business-type activities long-term liabilities at September 30, 2012, consisted of the following: Water and Wastewater Fund: $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%. $3,120,000 Series 2010 Waterworks and Wastewater System Refunding Bonds due in annual installments of $155,000 to $580,000 through January 1, 2018; interest at 2.00% - 3.00%. Total Water and Wastewater Fund Drainage Utility Fund: $1,550,000 Series 2011 Waterworks and Wastewater System Refunding Bonds due in annual installments of $105,000 to $225,000 through February 15, 2021; interest at 3.47%. Total Drainage Utility Fund Total Business-type activities $ 380,000 2,470,000 $ 2,850,000 $ 1,345,000 $ 1,345,000 $ 4,195,000 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, 2012, the City was in compliance with these requirements. (continued) 61 4. DETAILED NOTES ON ALL FUNDS (Continued) Lon�-term Liabilities (Continued) The City's component unit, the TaX Increment Financing District, ]ong-term liabilities at September 30, 2012, consisted of the following: Tax Increment Financing District $5,255,000 Series 2011 Refunding Bonds due in installments of $490,000 to $665,000 beginning in 2012 through February 15, 2020; interest at 2.0% to 4.0%. $ 4,765,000 Total Tax Increment Financing District September 30, 2013 2014 2015 2016 2017 2018-2022 2023-2027 2028-2030 September 30, 2013 2014 2015 2016 2017 2018-2022 Governmental Activities General Obligation Bonds and Certificates of Obligation Principal Interest $ 1,300,000 $ 338,134 1,015,000 305,948 740,000 278,384 770,000 251,258 795,000 223,179 2,830,000 736,016 2,525,000 262,500 $ 9,975,000 $ 2,395,419 Business-type Activities (continued) 62 $ 4,765,000 Revenue Bonds Principal Interest $ 330,000 $ 318,365 340,000 304,630 355,000 290,383 375,000 275,418 390,000 259,735 2,195,000 1,041,708 2,700,000 541,610 1,245,000 51,558 $ 7,930,000 $ 3,083,407 Revenue Bonds Principal Interest $ 975,000 $ 105,852 995,000 79,704 685,000 57,947 450,000 42,446 460,000 28,291 630,000 36,244 $ 4,195,000 $ 350,484 4. DETAILED NOTES ON ALL FUNDS (Continued) Lon�-term Liabilities (Continued) September 30, 2013 2014 2015 2016 2017 2018-2020 Capital Leases Discretely Presented Component Unit - Tax Increment Financing Fund Revenue Bonds Principal Interest $ 540,000 $ 224,980 555,000 200,942 565,000 175,256 585,000 97,425 600,000 79,650 1,920,000 114,125 $ 4,765,000 $ 892,378 The City has entered into lease agreements as lessee for financing and acquisition of equipment for the Fire Department. These lease agreements qualify as capital leases for accounting purposes and, therefore, has been recorded at the present value of its future minimum lease payments as of the inception date. The assets acquired through capital leases are as follows: Asset: Machinery and equipment Less: accumulated depreciation Total Governmental Activities $ 2,539,938 ( 692,338) $ 1,847,600 Business-type Activities $ 25,500 ( 21,950) $ 3,550 The future minimum lease obligations and the net present value of these minimum lease payments as of September 30, 2012, were as follows: 2013 2014 2015 2016 2017 2018-2022 Total minimum lease payments Less: amount representing interest Present value of minimum lease payments Governmental Activities $ 616,562 319,228 319,228 269,505 116,839 233,678 1,875,040 ( 165,920) $ 1,709,120 (continued) 63 4. DETAILED NOTES ON ALL FUNDS (Continued) Employees' Retirement System Plan Description The City provides pension benefits for all of its eligible employees through a non-traditional, joint contributory, hybrid defined benefit plan in the statewide Texas Municipal Retirement System (TMRS), an agent multiple-employer public employee retirement system. The plan provisions that have been adopted by the City are within the options available in the governing state statutes of TMRS. TMRS issues a publicly available comprehensive annual financial report that includes financial statements and required supplementary information (RSI) for TMRS; the report also provides detailed explanations of the contributions, benefits and actuarial methods and assumptions used by the System. This report may be obtained by writing to TMRS, P. O. Box 149153, Austin, Texas 78714-9153 or by calling 800-924-8677; in addition, the report is available on TMRS' website at www.TMRS.com. The plan provisions are adopted by the governing body of the City, within the options available in the state statutes governing TMRS. Plan provisions for the City were as follows: Employee deposit rate Matching ratio (oity to employee) Years required for vesting Service retirement eligibility (expressed as age/years of service) Updated service credit Annnity inoreaae (to retixeas) Contributions Plan Year 2010 7.0% 2 to I 60/5, 0/20 100% repeating transfers 70% of CPI repeating Plan Year 2011 7.0% 2to1 5 60/5, 0/20 100% repeating, transfers 70% of CPI Plan Year 2012 7.0% 2 to 1 60/5, 0/20 100% repeating, transfers 0% of CPI Under the state law governing TMRS, the contribution rate for each City is determined annually by the actuary, using the Projected Unit Credit actuarial cost method. This rate consists of the normal cost contribution rate and the prior service cost contribution rate, which is calculated to be a level percent of payroll from year to year. The normal cost contribution rate finances the portion of an active member's projected benefit allocated annually; the prior service contribution rate amortizes the unfunded (overfunded) actuarial liability (asset) over the applicable period for that city. Both the normal cost and prior service contribution rates include recognition of the projected impact of annually repeating benefits, such as Updated Service Credits and Annuity Increases. (continued) 64 4. DETAILED NOTES ON ALL FUNDS (Continued) Employees' Retirement System (Continued) Contributions (Continued) The City contributes to the TMRS Plan at an actuarially determined rate. Both the employees and the City malce contributions monthly. Since the City needs to know its contribution rate in advance for budgetary purposes, there is a one-year delay between the actuarial valuation that serves as the basis for the rate and the calendar year when the rate goes into effect. The annual pension cost and net pension obligation/(asset) are as follows: Accounting Annual Percentage Net Year Pension of APC Pension Ending Cost (APC) Contributed Obligation 09/30/10 $ 1,558,614 100% - 09/30/11 1,220,839 100% - 09/30/12 817,843 100% - The required contribution rates for fiscal year 2012 were determined as part of the December 31, 2009 and 2010 actuarial valuations. Additional information as of the latest actuarial valuation, December 31, 2011, also follows: Actuarial Valuation Date Actuarial cosf inethod Amortization method Asset valuation method Actuarial Assumptions: Investment rate of return Projected salary increases Inflation Cost-of-living adjustments GASB 25 Equivalent Single amortization period Amortization period for new gains/losses 12/31/09 ProjecYed Unit Credit Levelpercent of payroll ] 0-year smoothed market 7.5% varies by age and service 3.0% 2.1% 28.0 years; closed period 30 years (continued) 65 12/31/10 Projected Unit Credit Levelpercent of payroll 10-year smoothed market 7.0% varies by age and service 3.0% 2.1% 38.3 years; closed period 25 years 12/31/ll Projected Unit Credit� Level percent of payroll 10-year smoothed market 7.0% varies by age and service 3.0% 0% 273 years; closed period 25 years 4. DETAILED NOTES ON ALL FUNDS (Continued) Employees' Retirement System (Continued) Funded Status and Fund Progress The funded status as of December 31, 201 l, the most recent actuarial valuation date, is presented as follows: Actuarial accrued liability (AAL) Actuarial value of plan assets Unfunded (overfunded) actuarial accrued liability (UAAL) Fundedratio (actuarial value ofplan assets/ALL) Covered payroll (annual payroll of active employees covered by the plan) UAAL as a percentage of covered payroll $ 36,643,865 38,477,205 $( 1,833,340) 105.00% 9,661,349 ( 19.00%) Actuarial valuations involve estimates of the value of reported amounts and assumptions about the probability of events far into the future. Actuarially determined amounts are subject to continual revision as actual results are compared to past expectations and new estimates are made about the future. Actuarial calculations are based on the benefits provided under the terms of the substantive plan in effect at the time of each valuation, and reflect a long-term perspective. Consistent with that perspective, actuarial methods and assumptions used include techniques that are designed to reduce short-term volatility in actuarial accrued liabilities and the actuarial value of assets. Water and Wastewater Contracts The City has two contracts with the Trinity River Autharity of Texas (TRA) for the purchase of treated water and for the transportation, treatment and disposal of sanitary sewage and other waste. The initial terms of the contracts are 35 and 50 years, and they expire in 2014 and 2023. While the provisions of each of the contracts vary, each contract basically requires the City to pay varying amounts based on the costs associated with water purchased and sewage transported and/or treated and disposed. The cost includes the City's proportionate share of TRA's operating and maintenance expenses, related debt service costs, and certain other miscellaneous charges. Purchases of treated water and charges for the transportation, treatment and disposal of sewage and other wastes during fiscal year 2012 amounted to approximately $6,636,694 and $1,512,145, respectively. (continued) 66 4. DETAILED NOTES ON ALL FUNDS (Continued) Advances from Developers Developers are required by ordinance to construct perimeter streets and related storm drainage facilities. The developer may request a waiver from the Council for the construction requirements and instead deposit escrow funds with the City equal to one-half of the estimated cost of construction, which are utilized by the City to complete the project at some later date. At September 30, 2012, developers had escrowed $3,001,904 with the City in connection with developer agreements. Contingent 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. Risk Financin� and Insurance The City is exposed to various risks of loss related to torts, theft of, damage to, and destruction of assets; errars and omissions; injuries to employees; and natural disasters. During the fiscal year 1974, the City joined the Texas Municipal League Workers Compensation Joint Insurance Fund for risks related to employees. During the fiscal year 1992, the City joined the Texas Municipal League Joint Insurance Fund for risks related to general liability, property and errors and omissions. Premiums are paid to the Pool, which retains a limit of loss. Reinsurance companies insure the risks beyond those limits. The City retains, as a risk, only the deductible amount of each policy. There have been no significant reductions in insurance coverage and no settlements exceeded insurance coverage in the past three fiscal years. Other Postemployment Benefits Supplemental Death Benefits Fund The City also participates in the cost sharing multiple-employer defined benefit group term life insurance plan operated by the Texas Municipal Retirement System (TMRS) lcnown as the Supplemental Death Benefits Fund (SDBF). The City elected, by ordinance to provide group term life insurance coverage to both current and retired employees. The City may terminate coverage under and discontinue participation in the SDBF by adopting an ordinance before November 1 of any year to be effective the following January 1. The death benefit for active employees provides a lump sum payment approximately equal to the employee's annual salary (calculated based on the employee's actual earnings, for the 12-month period preceding the month of death); retired employees are insured for $7,500; this coverage is an "other postemployment benefit," or OPEB. (continued) 67 4. DETAILED NOTES ON ALL FUNDS (Continued) Other Postemployment Benefits (Continued) Supplemental Death Benefits Fund (Continued) The City's contributions to the TMRS 508F for the years ended 2012, 2011, and 2010 were $14,480, $9,752, and $10,162, respectively, which equaled the required contributions each year. Accounting Year Ending 09/30/ 10 09/30/11 09/30/12 Schedule of Contribution Rates Annual Required Contriburion (Bate) .O1% .02% .013% 68 Actual Contribution Made (Bate) .O1 % .02% .013% Percentage of ARC Contributed 100% 100% 100% REQUIRED SUPPLEMENTARY INFORMATION 69 Actuarial Valuation Date 12/3 U2009 12/31/2010 12/31 /201 l Actuarial Value of Assets $ 24,573,182 35,451,160 38,477,205 CITY OF COLLEYVILLE, TEXAS REQUIRED SUPPLEMENTARY INFORMATION TEXAS MUNICIPAL RETIREMENT SYSTEM SCHEDULE OF FUNDING PROGRESS Actuarial Accrued Liability $ 32,867,149 34,974,234 36,643,865 Funded Ratio 74.8% 101.4% 105.0% Unfunded (Overfunded) Unfunded Actuarial Actuarial Annual Accrued Liability Accrued Covered as a Percentage Liability Payroll of Covered Payroll $ 8,293,967 $ 10,436,294 115.0% ( 476,926) 10,125,274 86.9% ( 1,833,340) 9,661,349 82.6% Note: Fiscal years 2010 and 2011 include the impact of Senate Bill 350 enacted by the Texas Legislature in June of 2011. This legislation provided a restructuring of the Texas Municipal Retirement System funds effective December 31, 2010. 70 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 library building for the City. Recreational Event — This fund is used to account for activities related to athletic events for the City. Colleyville Center Development — This fund is used to account for contributions received to construct a community center. Recycling — This fund is used to account for the promotion of recycling activities in the City of Colleyville. Contributions are received from the holder of the City's recycling franchise. LEOSE (Law Enforcement Office� 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 Dist�ict — 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. 71 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 �re and rescue. Public Art — This fund is used to account for the acquisition of art to be placed in City owned facilities with high public visibility. CAPITAL PROJECTS FUNDS Capital Projects Funds are used to account for the acquisition and construction of major capital facilities other than those financed by proprietary funds and trust funds. Colleyville TomoYrow Fund — is used to account far proceeds received on gas leases on City- owned property to be used for capital purchases. Parks Tomorrow Fund — This fund is used to account for proceeds received on gas leases on City-owned parks property for parks capital projects. Parkland Dedication Fund — This fund is used to account for the acquisition of land for new park sites and to make improvements to or expand existing parks to better serve new development. Fees collected fram 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. Capital and Cable Equipment Replacement — This fund is used to account for the replacement of cable equipment and other capital equipment. 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. 72 THIS PAGE INTENTIONALLY LEFT BLANK 73 CITY OF COLLEYVILLE, TEXAS COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS SEPTEMBER 30, 2012 ASSETS Cash and cash equivalents Investments Due from other governments Accrued interest Total assets LIABILITiES AND FUND BALANCES Liabilities: Accounts payable Accrued liabilities Advances from developers Total liabilities Fund balances: Restricted Committed Assigned Total fund balances Total liabilities and fund balances Special Revenue Funds V oluntary Voluntary Park Library $ 72,073 399,184 127 $ 471,384 $ - 471,3 84 471,3 84 $ 471,384 74 $ 9,865 359,043 175 $ 369,083 $ - 369,083 369,083 $ 369,083 Police Asset Forfeiture $ 7,173 $ 7,173 $ 7,173 7,173 $ 7,173 Special Revenue Funds Colleyville Tree Library Recreational Center Preservation Donation Event Development Recycling LEOSE $ 18,927 $ 140,831 $ 227 $ 6,449 $ 1,730 $ 8,956 $ 18,927 $ 140,831 $ 227 $ 6,449 $ 1,730 $ 8,956 $ - 13,724 13,724 $ $ $ $ $ - 140,831 - 6,449 - 8,956 5,203 - - - - - - - 227 - 1,730 - 5,203 140,831 227 6,449 1,730 8,956 $ 18,927 $ 140,831 $ 227 $ 6,449 $ 1,730 $ 8,956 (continued) 75 CITY OF COLLEYVILLE, TEXAS COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS (Continued) SEPTEMBER 30, 2012 ASSETS Cash and cash equivalents Investments Due from other governments Accrued interest Total assets LIABILITiES AND FUND BALANCES Liabilities: Accounts payable Accrued liabilities Advances from developers Total liabilities Fund balances: Restricted Committed Assigned Total fund balances Total liabilities and fund balances Special Revenue Funds Colleyville Economic Kidsville Development Crim� District Maintenance $ 1,174,650 564,373 264,665 727 $ 2,004,415 $ 5,570 5,570 1,998,845 1,998,845 $ 2,004,415 76 $ 929,479 216,165 $ 20,426 $ 1,145,644 $ 20,426 $ 2 9,361 9,363 1,136,281 1,136,281 $ 1,145,644 $ 20,426 20,426 $ 20,426 Special Revenue Funds Special Court Donations Technology Court Security TDPA Grant Public Art $ 40,030 $ 52,349 $ 50,521 $ 12,160 $ 7,904 $ 40,030 $ 52,349 $ 50,521 $ 12,160 $ 7,904 $ 40,030 40,030 $ 40,030 $ 11,233 11,233 41,116 41,1 l6 $ 52,349 $ 50,521 50,521 $ 50,521 (continued) 77 $ 12,160 ] 2,160 $ 12,160 $ 7,904 7,904 $ 7,904 CITY OF COLLEYVILLE, TEXAS COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS (Continued) SEPTEMBER 30, 2012 ASSETS Cash and cash equivalents Investments Due from other governments Accrued interest Total assets LIABILITiES AND FUND BALANCES Liabilities: Accounts payable Accrued liabilities Advances from developers Total liabilities Fund balances: Restricted Committed Assigned Total fund balances Total liabilities and fund balances 78 Capital Project Funds Colleyville Tomorrow $ 1,632,773 $ 691,628 3,431 $ 2,327,832 $ 2,327,832 2,327,832 Parlcs Tomorrow 1,211,052 $ 1,211,052 $ 10,800 10,800 1,200,252 1,200,252 $ 2,327,832 $ 1,211,052 Capital Project Funds Capital and Cable Total Parkland CEDC Capital Equipment Governmental Dedication Project Replacem�nt Kimzey Park Funds $ 729 1,499,066 1,097 $ 1,500,892 $ - 1,500,892 1,500,892 $ 1,500,892 $ 314,838 $ 314,838 $ - 314,838 314,838 $ 314,838 $ 504,845 449,843 45 $ 954,733 $ 9,776 9,776 944,957 944,957 $ 954,733 79 $ 3,576 $ 3,576 $ - 3,576 3,576 $ 3,576 $ 6,221,563 3,963,137 480,830 5,602 $ 10,671,132 $ 37,381 9,361 13,724 60,466 3,462,788 6,193,060 954,818 10,610,666 $ 10,671,132 CITY OF COLLEYVILLE, TEXAS COMBINiNG STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES NONMAJOR GOVERNMENTAL FUNDS FOR THE YEAR ENDED SEPTEMBER 30, 2012 REVENUES Taxes Fees and fines Licenses and permits Intergovernmcntal Donations Investment earnings Miscellaneous Total revenues EXPENDiTURES Current: Gcneral government Cominunity development and engineering Fire and rescue Leisure services Municipal court Police Debt service: Principal Interest and other charges Capital outlay Total expenditures EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Transfers in Transfers out Total other financing sourcES and uses NET CHANGE IN FUND BALANCES FUND BALANCES, BEGINNING FUND BALANCES, ENDING Voluntary Park $ - 149,130 149,130 2,350 2,350 146,780 146,780 324,604 $ 471,384 80 Special Revenue Funds Voluntary Library $ - 151,488 2,398 153,886 135,139 135,139 18,747 18,747 350,336 $ 369,083 Police Asset Forfeiture $ - 9,019 9,019 2,668 2,668 6,35] 822 822 7,173 $ 7,173 Special Revenue Funds Colleyville Tree Library Recrearional Centcr Preservation Donation EvEnt Development Recycling LEOSE $ - $ - $ - $ - $ - $ - - 3,000 - 898 - - - 22,944 9,763 - - - - - - - 15,000 - - 25,944 9,763 898 15,000 - 37,346 - 3,679 - 4l ,025 - ( 15,081� 9,536 9,536 227 898 898 17,311 17,311 814 1,278 2,092 ( 2,311) ( 2,092� - � �s,osi� za� - ( a,3i1� � z,o9z� 5,203 155,912 - 6,449 4,04 ] 11,048 $ 5,203 $ 140,831 $ 227 $ 6,449 $ 1,730 $ 8,956 (continued) 81 CITY OF COLLEYVILLE, TEXAS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES NONMAJOR GOVERNMENTAL FUNDS (Continued) FOR THE YEAR ENDED SEPTEMBER 30, 2012 REVENUES Taxes Fees and fincs Licenses and permits Intergovernmcntal Donations InvesYment earnings Miscellaneous Total revenues EXPENDiTURES Current: General government Community development and engineering Firc and rescue Leisure services Municipal court Police Dcbt service: Principal Interest and other charges Capital outlay Total expenditures EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Transfers in Transfers out Total other financing sources and uses NET CHANGE IN FUND BALANCES FUND BALANCES, BEGINNING FUND BALANCES, ENDING Special Revenue Funds Colleyville Economic Kidsville Development Crime District MainYenance $ 1,426,909 $ 1,210,756 $ - 4,422 1,899 - 1,431,331 1,212,655 - 143,191 - - 190,812 - - - 449,881 - 315,000 - - 331,588 - - 150,464 100,195 - l,l 31,055 550,076 - 300,276 662,579 - � �6s,33i� � szi,zii� - � i6s,331� � s21,2i1� - 134,945 141,368 - 1,863,900 994,913 20,426 $ 1,998,845 $ 1,136,281 $ 20,426 82 Special Revenue Funds Capital and Cable Special Court Equipment Donations Technology Court Security TDPA Grant Replacement Public Art $ - $ - $ - $ - $ - $ - - 29,929 22,444 - - - 3,999 - - - - - 44,046 - - - - - - 214 - - - - 48,045 30,143 22,444 - - - 14,271 7,049 4,270 25,590 22,455 ( 822) ( 822) 21,633 18,397 $ 40,030 46,412 46,412 � ] 6,269) ( 16,269) 57,385 $ 41,116 22,885 45,073 67,958 ( 45,S14) ( 45,514) 96,035 $ 50,521 12,160 $ 12,160 (continued) 83 $ - 7,904 $ 7,904 CITY OF COLLEYVILLE, TEXAS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES NONMAJOR GOVERNMENTAL FUNDS (Continued) FOR THE YEAR ENDED SEPTEMBER 30, 2012 REVENUES Taxes Fees and fines Licenses and permits Intergovcrnmcntal Donations Investment earnings Miscellaneous Total revenues EXPENDiTURES Current: Gcneral government Cominunity development and engineering Fire and rescue Leisure services Municipal court Police Debt service: Principal Interest and other charges Capital outlay Total expenditures EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Transfers in Transfers out Total other financing sourcES and uses NET CHANGE IN FUND BALANCES FUND BALANCES, BEGINNING FUND BALANCES, ENDING 84 Capital Project Funds Colleyville Tomorrow $ - 12,387 10,169 22,556 ll4,898 114,898 ( 92,342) 165,331 165,331 72,989 2,254,843 $ 2,327,832 Parks Tomorrow $ - 4,916 2,927 7,843 7,843 7,843 1,192,409 $ 1,200,252 Capital Project Funds Capital and Cable Parkland CEDC Capital Equipment Dedication Projcct Rcplacemcnt Kimzey Park $ - $ - $ - $ - 16,668 12,750 - - 188 - 9,948 - 16,856 12,750 9,948 - 16,856 16,856 1,484,036 $ 1,500,892 26,386 24,139 50,525 ( 37,775) ( 37,775) 352,613 $ 314,838 275,382 223,212 498,594 � 488,64� 297,000 297,000 ( 191,64� 1,136,603 $ 944,957 85 Total Governmental Funds $ 2,637,665 61,392 17,303 7,897 406,789 32,165 15,000 3,178,211 292,693 143,191 15,085 409,516 69,297 458,097 315,000 331,588 661,660 2,696,127 - 482,084 3,576 $ 3,576 463, l 53 ( 687,364) ( 224,211) 257,873 10,352,793 $ 10,610,666 CITY OF COLLEYVILLE, TEXAS DEBT SERVICE FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED SEPTEMBER 30, 2012 REVENUES Taxes Investment earnings Miscellaneous Total revenues EXPENDITURES Debt service: Principal retirement Interest and fiscal charges Total expenditures EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES Transfers in Total other financing sources NET CHANGE IN FUND BALANCE FUND BALANCE, BEGINNING FUND BALANCE, ENDING Budget $ 1,495,165 2,375 1,497,540 1,692,585 427,006 2,119,591 ( 622,051) 505,211 505,211 ( 116,840) 1,188,907 $ 1,072,067 86 Actual $ 1,654,744 2,803 6,338 1,663,885 1,692,585 426,006 2,118,591 ( 454,706) 505,211 505,211 50,505 1,188,907 $ 1,239,412 Variance with Budget - Positive (Negative) $ 159,579 428 6,338 166,345 1,000 1,000 167,345 167,345 $ 167,345 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. 87 CITY OF COLLEYVILLE, TEXAS COMBINING STATEMENT OF FIDUCIARY NET ASSETS AGENCY FUNDS SEPTEMBER 30, 2012 ASSETS Cash and cash equivalents Total assets LIABILITIES Due to other agencies and individuals Total liabilities Employee Activity Fund $ 6,366 $ 6,366 $ 6,366 $ 6,366 88 Sesquicentennial Fund $ 17,538 $ 17,538 $ 17,538 $ 17,538 Total $ 23,904 $ 23,904 $ 23,904 $ 23,904 Cash and cash equivalents Total assets CITY OF COLLEYVILLE, TEXAS COMBINING STATEMENT OF CHANGES IN ASSETS AND LiABILITIES AGENCYFUNDS FOR THE YEAR ENDED SEPTEMBER 30, 2012 Employee Activity Fund Balance Balance 10/O1/11 Additions Deletions 09/30/12 $ 6,495 $ 2,936 $ 3,065 $ 6,366 $ 6,495 $ 2,936 $ 3,065 $ 6,366 Due to other agencies and individuals $ 6,495 $ 2,936 $ 3,065 $ 6,366 Totalliabilities $ 6,495 $ 2,936 $ 3,065 $ 6,366 Cash and cash equivalents Total assets Due to other agencies and individuals Total liabilities Cash and cash equivalents Total assets Sesquicentennial Fund Balance Balance l0/O1/11 Additions Deletions 09/30/12 $ 17,374 $ $ 17,374 $ $ 17,374 $ $ 17,374 $ Balance 10/O1/11 250 $ 86 $ 17,538 250 $ 86 $ 17,538 250 $ 250 $ Total Agency Funds 86 $ 17,538 86 $ 17,538 Balance Additions Deletions 09/30/12 $ 23,869 $ 3,] 86 $ 3,151 $ 23,904 $ 23,869 $ 3,186 $ 3,151 $ 23,904 Due to other agencies and individuals $ 23,869 $ 3,186 $ 3,151 $ 23,904 Totalliabilities $ 23,869 $ 3,186 $ 3,151 $ 23,904 89 THIS PAGE INTENTIONALLY LEFT BLANK 90 STATISTICAL SECTION This part of the City of Colleyville, Texas' comprehensive annual financial report presents detailed information as a context for understanding what the information in the financial statements, note disclosures, and required supplementary information says about the government's overall financial health. Contents Page Financial Trends 92 These schedules contain trend information to help the reader understand how the government's financial performance and well- being have changed over time. Revenue Capacity 102 These schedules contain information to help the reader assess the government's most significant local revenue source, the property tax. Debt Capacity 107 These schedules present information to help the reader assess the affordability of the government's current levels of outstanding debt and the government's ability to issue additional debt in the future. Demographic and Economic Information 114 These schedules offer demographic and economic indicators to help the reader understand the environment within which the government's financial activities take place. Operating Information 116 These schedules contain service and infrastructure data to help the reader understand how the information in the government's financial report relates to the services the government provides and the activities it performs. Sources: Unless otherwise noted, the information in these schedules is derived from the comprehensive annual financial reports for the relevant year. 91 CITY OF COLLEYVILLE, TEXAS NET ASSETS BY COMPONENT (Accrual Basis of Accounting) Fiscal Year 2003 2004 2005 2006 Governmental activities: Invested in capital assets, net of related debt $ 55,965,990 $ 60,055,616 $ 60,884,756 $ 66,991,146 Restricted for: Debt service 1,040,403 756,516 896,130 937,578 Court securiry and technology - - - - Grant programs - - - - Leisure services - - - - Economic development - - - - Streets and drainage - - - - Police - - - - Unrestricted 15,646,259 15,948,497 19,132,376 19,002, 816 Total governmental activities net assets $ 72,652,652 $ 76,760,629 $ 80,913,262 $ 86,931,540 Business-rype activities: Invested in capital assets, net of related debt $ 22,588,864 $ 23,957,432 $ 24,827,365 $ 25,919,619 Restricted for: Debt service 668,120 668,239 670,571 882,821 Unrestricted 14,502,121 15,470,275 16,374,236 19,253,772 Total business-type activities net assets $ 37,759,105 $ 40,095,946 $ 41,872,172 $ 46,056,212 Primary government: Invested in capital assets, net of related debt $ 78,554,854 $ 84,013,048 $ 85,7] 2,121 $ 92,910,765 Restricted for: Debt service 1,708,523 1,424,755 1,566,701 1,820,399 Court securiry and technology - - - - Grant programs - - - - Leisure services - - - - Economic development - - - - Streets and drainage - - - - Police - - - - Unrestricted 30,148,380 31,418,772 35,506,612 38,256,588 Total primary government net assets $ ll 0,411,757 $ ll 6,856,575 $ 122,785,434 $ 132,987,752 Note: The City implemented GASB 54 in fiscal year 201 1 to provide clearer fund balance classifications. Prior years were not restated. 92 2007 $ 71,824,719 1,032,586 21,987,778 $ 94,845,083 $ 32,804,703 1,080,751 13,626,274 $ 47,511,728 $ 104,629,422 2,l 13,337 35,614,052 $ 142,356,811 2008 $ 77,484,725 889,689 21,862,136 $ 100,236,550 $ 39,442,148 1,024,349 7,837,790 $ 48,304,287 $ 116,926,873 1,914,038 29,699,926 $ 148,540,837 Fisca] Year 2009 2010 $ 79,243,497 1,040,896 27,498,864 $ 107,783,257 $ 39,174,562 987,181 8,127,736 $ 48,289,479 $ 118,418,059 2,028,077 35,626,600 $ 156,072,736 93 $ 81,970,674 1,057,699 25,936,703 $ 108,965,076 $ 39,080,043 983,225 7,747,336 $ 47,810,604 $ 121,050,717 2,040,924 33,684,039 $ 156,775,680 2011 $ 83,166,142 1,106,893 153,420 23,208 201,184 1,863,900 6,428,106 994,913 17,837,593 $ ll1,775,359 $ 38,892,098 662,050 10,111,776 $ 49,665,924 $ 122,058,240 1,768,943 153,420 23,208 201,184 l ,863,900 6,428, l 06 994,913 27,949,369 $ 161,441,283 TABLE l 2012 $ 83,211,988 1,159,092 91,637 21,1 16 207,736 1,998,845 8,192,568 1,143,454 19,559,719 $ 115,586,155 $ 38,395,708 12,332,238 $ 50,727,946 $ 121,607,696 1,159,092 91,637 21,116 207,736 1,998,845 8,192,568 1,143,454 31,891,957 $ 166,314,101 CITY OF COLLEYVILLE, TEXAS EXPENSES Governmental activities: General government Community Development and Engineering Fire and rescue Leisure services Maintenance Municipal court Police Streets and drainage Interest on long-term debt Total governmental activities expenses Business-type activities: Water and wastewater Drainage Interest on long-term debt Total business-type activities expenses CHANGES IN NET ASSETS (Accrual Basis of Accounting) 2003 $ 1,551,989 ] ,280,410 3,010,260 2,728,287 193,865 235,053 3,498,419 2,195,256 ] ,491,649 16,185,] 88 7,704,603 354,960 60l ,560 8,661, ] 23 Fiscal Year 2004 2005 $ 2,542,016 1,281,429 3,144,814 2,953,528 364,256 250,551 3,295,263 2,562,499 1,290,825 17,685,181 7,850,570 5 ] 7,713 8,368,283 Total primary government program expenses $ 24,846,3ll $ 26,053,464 PROGRAM REVENUES Governmental activities: Charges for services: General government Community Development and Engineering Fire and rescue Leisure services Municipal court Police Streets and drainage Operating grants and contributions Capital grants and contributions Total �overnmental activities program revenues $ 18,000 ],242,838 l 04,990 394,098 510,544 45,626 240,309 328,324 8,014,501 10,899,230 94 $ 16,000 1,687,921 125,081 399,319 508,572 66,135 S12,171 619,459 3,857,202 7,791,860 $ 2,245,964 1,164,345 3,325, ] 03 2,923,958 364,434 238,874 3,533,083 2,970,475 1,190,857 ] 7,957,093 8,962,630 550,005 9,512,635 $ 27,469,728 $ 6,000 1,515,052 l 36,498 386,658 492,805 95,234 336,111 523,704 3,283,774 6,775,836 2006 $ 2,729,064 l ,267, l 36 3,814,585 3,513,992 383,504 270,345 3,801,644 2,932,465 1,142,043 ] 9,854,778 9,428,373 548,963 440,703 10,418,039 $ 30,272,817 $ 6,000 2,163,596 239,386 448,606 813,781 70,899 472,860 399,819 4,355,357 8,970,304 2007 $ 2,438,05] ] ,523,768 3,790,831 3,525,094 434,984 262,198 4,232,185 2,890,995 1,032,374 20,130,480 9,337,282 671,773 400,752 10,409,807 $ 30,540,287 $ 6,000 1,454,744 303,868 424,024 932,452 81,054 355,157 431,683 5,372,281 9,361,263 11: $ 2,814,874 1,481,124 3,958,11 l 4,033,105 417,265 324,020 4,657,438 3,129,730 ],l 07 ,714 21,917,381 11,179,548 593,600 362,642 12,135,790 $ 34,053,17] $ 16,000 1,332,453 250,814 563,738 1,171,919 79,699 358,688 1,856,567 3,973,954 9,603,832 Fiscal Year 2009 2010 $ 2,945,481 1,530,90] 4,113,793 3,941,259 455,752 29l ,724 4,841,217 3,503,519 1,051,180 22,674,826 10,612,372 658,O16 331,361 l 1,601,749 $ 34,276,575 $ 15,000 666,914 271,216 6,595,487 1,002,008 51,631 215,619 713,189 360,023 9,891,087 $ 2,691,905 1,645,221 4,419,945 4,118,769 423,783 302,756 4,836,274 3,885,182 1,000,061 23,323,896 11,242,553 572,234 296,288 12,1 l 1,075 $ 35,434,971 $ 15,000 647,298 235,225 468,426 1,213,178 94,059 345,780 543,516 423,873 3,986,355 (continued) 95 2011 $ 2,715,154 l ,402,669 4,421,496 4,191,960 4]2,S13 303,839 4,878,055 3,657,591 849,390 22,832,667 12,009,187 742,160 12,751,347 $ 35,584,014 $ 97,234 868,363 305,882 1,213,167 970,143 70,709 296,350 822,056 405,347 5,049,251 TABLE 2 2012 $ 3,125,214 1,397,839 4,321,929 4,124,619 400,306 3 l 9,445 4,579,570 3,073,530 780,029 22,122,481 12,258,587 723,994 12,982,581 $ 35,105,062 $ 28,408 1,146,518 335,308 520,433 1,015,804 81,056 338,845 490,069 381,308 4,337,749 CITY OF COLLEYVILLE, TEXAS CHANGES IN NET ASSETS (Continued) (Accrual Basis of Accounting) 2003 PROGRAM REVENUES (Continued) Business-type activities: Charges for services: Water and wastewater $ 8,595,871 Drainage 666,399 Capital grants and contributions 1,443,502 Total business-type activities program revenues 10,705,772 Fiscal Year 2004 2005 2006 $ 8,924,942 $ 9,856,889 $ ]3,187,868 677,913 675,045 1,412,990 844,256 1,100,354 11,07 5,845 11,376,190 14,288,222 Total primary government program revenues $ 21,605,002 $ 18,807,705 $ 18,152,026 $ 23,258,526 NET (EXPENSE) REVENUES Governmental activities $( 5,285,958) $( 9,893,321) $(11,181,257) $(10,884,474) Business-type activities 2,044,649 2,647,562 1,863,555 3,870,183 Total primary government net expense ( 3,241,309) ( 7,245,759) ( 9,317,702) ( 7,014,291) GENERAL REVENUES AND OTHER CHANGES IN NET ASSETS Governmental activities: Taxes Property 8,183, 790 Franchise ] ,395,569 Sales 2,964,331 Other 32,123 Investment earnings 468,656 Miscellaneous 63,052 Gain on sale of capital assets - Transfers 1,OS 8,060 Total governmental activities 14,165,581 8,534,388 1,458,079 3,381,634 37,296 2l 7,316 53,538 473,366 ]4,155,617 8,938,888 1,477, 749 3,801,369 53,974 443,570 153,947 464,393 15,333,890 9,483,546 1,790,543 4,355,627 76,005 904,361 65,313 532,357 17,207,752 Business-type activities: Investment earnings 282,661 162,645 377,064 846,214 Gain on sale of capital assets - - - - Transfers ( 1,058,060) ( 473,366) ( 464,393) ( 532,357) Total business-type activities ( 775,399) ( 310,721) ( 87,329) 313,857 Total primary government CHANGE IN NET ASSETS Governmental activities Business-type activities Total primary government 13,390,182 13,844,896 15,246,561 8,879,623 4,262,296 4,152,633 1,269,250 2,336,841 1,776,226 $ 10,148,873 $ 6,599,137 $ 5,928,859 Note: See Table 9 for information about Water and Wastewater Charges for services 96 17,521,609 6,323,278 4,184,040 $ ] 0,507,318 2007 $ 9,127,470 841,972 1,561,255 11,530,697 $ 20,891,960 $( 10,769,217) ] ,120,890 ( 9,648,32�) 10,153,775 1,779,376 4,674,068 89,132 l ,224,361 97,963 664,085 18,682,760 998,710 � 664,085) 334,625 19,017,385 7,913,543 1,455,515 $ 9,369,058 2008 $ 11,114,892 859,013 l ,415,785 13,389,690 $ 22,993,522 $( 12,313,549) l ,253,900 ( 11,059,649) 1 l ,367,967 1,818,060 4,740,964 82,532 804,864 96,348 116,112 841,936 l 9,868,783 380,595 ( 84�,936) ( 46�,341) 19,407,442 7,555,234 792,559 $ 8,347,793 Fiscal Year 2009 2010 $ ] 1,303,868 $ 11,414,425 874,637 897,361 63,293 147,014 12,241,798 12,458,800 $ 22,132,885 $ 16,445,155 $( 12,783,739) 640,049 ( 12,143,690) l 2,121,420 2,017,440 4,718,976 74,] 98 471,524 77,854 25,237 823,797 20,330,446 168,940 ( 823,797) ( 654,857) 19,675,589 7,546,707 ( �4,808) $ 7,531,899 97 $( ] 9,337,541) 347,725 ( 18,989,816) 12,557,716 1,867,065 4,936,484 75,365 76,968 82,833 65,306 857,622 20,519,359 15,158 ] 5,864 ( 857,622) ( 826,600) 19,692,759 1,181,818 ( 478,875) $ 702,943 20l] $ 14,355,418 903,089 168,365 15,426,872 $ 20,476,123 $( 17,783,4] � 2,675,525 ( 15,107,891) 12,414,948 2,031,268 5,056,597 80,731 95,822 55,454 858,879 20,593,699 38,674 ( 858,879) ( 820,205) 19,773,494 2,810,283 1,855,320 $ 4,665,603 TABLE 2 2012 $ 14,034,600 9] 8,323 169,464 15,122,387 $ 19,460,136 $( 17,784,732) 2,139,806 ( 15,644,926) 12,414,457 2,207,463 5,495,730 65,808 ] 08,192 74,041 147,969 1,081,868 2l ,595,528 4,084 ( 1,081,868) ( 1,077,784) 20,517,744 3,810,796 1,062,022 $ 4,872,818 THIS PAGE INTENTIONALLY LEFT BLANK 98 TABLE 3 CITY OF COLLEYVILLE, TEXAS FUND BALANCES GOVERNMENTAL FUNDS LAST TEN FISCAL YEARS (Modified Accr�ual Basis of Accounting) Fiscal Ycar 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 General fund Non-spendable $ - $ - $ - $ - $ - $ - $ - $ - $ 2,147 $ 132,664 Restricted - - - - - - - - - - Committed - - - - - - - - 706,942 813,536 Assigned - - - - - - - - - - Unassigned 6,440,152 6,767,592 6,850,731 7,575,662 8,495,329 8,717,398 8,207,420 8,813,597 10,223,232 11,762,625 Total general fund $ 6,440,152 $ 6,767,592 $ 6,850,731 $ 7,575,662 $ 8,495,329 $ 8,717,398 $ 8,207,420 $ 8,813,597 $ 10,932,321 $ 12,708,825 All other governmental funds Non-spendable $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Restricted 2,674,486 3,056,810 2,959,583 1,082,681 1,254,686 987,681 1,121,567 1,154,570 10,853,638 ]2,894,768 Committed - - - - - - - - 5,967,620 6,193,060 Assigned - - - - - - - - 1,148,548 954,818 Unassigned, reported in: Special revenue funds 2,068,938 2,459,810 3,251,861 4,760,679 4,814,412 5,696,905 7,267,350 5,664,493 - - Capital projects funds 6,012,845 4,967,859 7,438,437 7,012,225 9,055,431 7,811,492 12,369,631 11,524,206 - - Total all other governmentalfunds $ ]0,756,269 $ 10,484,479 $ 13,649,881 $ 12,855,585 $ 15,124,529 $ ]4,496,078 $ 20,758,548 $ 18,343,269 $ ]7,969,806 $ 20,042,646 Note: This schedule does not restate prior years for Special Revenue and Capital Projects Funds. The City implemented GASB 54 in fiscal year 2011 to provide clearer fund balance classifications. Prior years were not restated. 99 REVENUES Taxes Developer contributions Licenses, fees and permits Capital improvement fees Drainage fees Fines and penalties Charges for services Interest Intergovernmenta] Donations Misccllaneous Total revenues EXPENDITURES General government Comm Development/Eng Fire Police Leisure services Streets and drainage Municipal court Maintenance Capital outlay Debt service: Interest Principal Total expenditures CITY OF COLLEYVILLE, TEXAS CHANGES IN FUND BALANCES GOVERNMENTAL FUNDS LAST TEN FISCAL YEARS (Modif'ied Accr�ual Basis of'Accounting) Fiscal Year 2003 2004 2005 2006 2007 2008 2009 2010 2011 TABLE 4 2012 $ 12,596,779 $ 13,438,345 $ 14,277,010 $ 15,708,945 $ 16,701,290 $ 17,975,445 $ 18,889,480 $ 19,353,358 $ 19,627,734 $ 20,235,012 277,084 416,319 274,996 549,911 683,425 226,488 - - - - 926083 1,505,512 1,359,329 1,931,265 1,244,218 1,113,595 646,302 607,132 923,590 1,130,426 300,252 577,171 366,111 482,860 389,657 358,688 208,622 334,075 281,260 322,498 509,395 520,926 513,129 841,595 965,416 1,203,260 1,028,425 1,244,146 998,221 1,051,899 915,695 952,452 940,212 1,173,394 1,190,327 1,322,732 7,129,322 917,884 1,694,993 1,030,439 468,656 217,316 443,570 904,361 1,224,361 804,864 471,524 76,968 95,823 110,550 504,778 328,040 167,293 5,409 4,361 1,437,935 350,468 ]00,807 541,709 124,056 707,829 797,042 502,789 396,627 735,756 548,093 401,432 379,853 602,401 406,789 96,857 92,198 183,902 83,730 107,700 116,280 155,100 97,833 70,453 89,041 ]7,303,348 ]8,845,321 19,028,34] 22,078,097 23,246,511 25,107,380 29,280,675 23,I12,056 24,836,184 24,500,710 1,469,725 1,274,096 2,826,218 3,331,861 2,262,478 1,092,703 234,180 162,865 7,430,703 2,445,219 1,281,745 3,057,879 3,126,469 2,489,222 1,420,620 250,597 356,819 1,939,241 1,873,091 1,160,232 3,166,840 3,293,320 2,388,761 1,656,187 238,245 357,983 1,459,940 2,107,398 1,265,251 3,657,554 3,558,154 2,838,637 1,604,425 270,037 377,144 4,491,341 2,247,359 1,467,216 3,517,817 3,961,975 2,913,798 1,485,756 252,961 415,708 6,337,656 2,537,699 1,462,566 3,755,575 4,395,056 3,171,514 1,649,037 323,059 410,636 5,750,286 2,639,218 1,531,785 3,840,118 4,588,576 3,058,332 1,9I7,536 291,893 449,806 2,759,774 2,423,869 1,642,047 3,955,407 4,552,947 3,173,352 2,297,719 302,172 4 ] 7,946 4,935,053 2,383,276 1,397,256 3,972,053 4,596,862 3,177,878 2,052,298 302,666 405,911 2,510,027 2,753,457 1,396,259 3,888,225 4,304,710 3,049,908 1,388,970 319,084 394,830 2,515,115 1,664,219 1,277,593 1,289,866 ],141,817 1,094,001 2,584,790 1,033,148 944,751 838,320 757,594 1,438,561 1,617,633 1,573,308 ],929,047 2,005,204 1,189,798 2,275,553 2,180,061 2,259,004 2,007,585 23,187,609 19,263,037 18,457,773 23,240,805 25,699,451 26,630,016 24,385,739 26,825,324 23,895,551 22,775,737 (continued) 100 EXCESS OF REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Bonds issued Refunding bonds Notes payable Capital lease Sale of capital assets Premium on bond issue Payments to escrow Transfers in Transfers out Total other financing sources (uses) NET CHANGE IN FUND BALANCES CITY OF COLLEYVILLE, TEXAS CHANGES IN FUND BALANCES GOVERNMENTAL FUNDS (Continued) LAST TEN FISCAL YEARS (Modif'ied Accrual Basis of'Accounting) Fiscal Year 2003 2004 2005 2006 2007 2008 2009 2010 201] TABLE 4 2012 $( 5,884,261) $( 417,716) $ 570,568 $( 1,162,708) $( 2,452,940) $( 1,522,63� $ 4,894,936 $( 3,713,268) $ 940,633 $ 1,724,973 - - 9,570,000 - 9,890,000 - - - 2,945,000 - - - 94, I 87 - - - - - - - - - - 408,716 - 176,150 - 981,238 - 894,534 - - - 152,270 8,800 98,168 33,759 65,306 7,098 147,969 6,56] - ( 600,000) - ( 7,450,606) - ( 4,921,334) - - - ( 3,012,9]0) - 1,766,111 1,ll5,261 1,675,954 2,203,261 1,637,154 2,082,101 2,338,776 ],884,896 2,458,396 3,893,584 ( 708,OS1) ( 641,895) ( 1,211,561) ( ],670,904) ( 973,069) ( 1,240,165) ( ],514,979) ( ],027,274) ( 1,599,517) ( 2,811,716) 458,060 473,366 2,677,974 ],093,343 5,641,551 1,ll6,254 857,556 ],904,166 804,628 2,124,371 $( 5,426,201) $ 55,650 $ 3,248,542 $( 69,365) $ 3,188,611 $( 406,382) $ 5,752,492 $( ],809,102) $ 1,745,261 $ 3,849,344 DEBT SERVICE AS A PERCENTAGE OF NONCAPITAL IL'XPENDITIIREO ]9.7% 16.7% 16.8% 16.4% 76.0% Note: Capital Outlay does not include contributed capital assets received from developers. 1�1 17.6% 15.3% 14.3% ]4.5% 13.6% Fiscal Year 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 CITY OF COLLEYVILLE, TEXAS ASSESSED VALUE AND ESTiMATED ACTUAL VALUE OF TAXABLE PROPERTY LAST TEN FISCAL YEARS Less: Total Taxable Total Residential Personal Tax-exempt Assessed Direct Property Property Property Value Tax Rate $ 2,480,630,162 2,726,410,622 2,793,606,203 3,O15,929,674 3,229,353,459 3,531,988,996 3,748,968,313 3,907,288,105 3,917,415,346 3,941,020,477 Source: Tarrant Appraisal District $ 82,599,959 73,845,277 78,255,043 79, l 22,702 86,080,918 97,998,283 99,556,111 95,261,420 92,176,541 89,758,416 $ l 96,195,476 2l 9,774,274 2l 9,264,381 22],809,521 228,115,791 228,915,486 230,676,995 237,293,931 253,414,335 277,077,387 $ 2,367,034,645 2,580,48 ] ,625 2,652,596,865 2,873,242,855 3,087,318,586 3,401,071,793 3,617,847,429 3,765,255,594 3,756,177,552 3,753,70],506 $ 0.3474 0.3474 0.3474 0.3474 03474 0.3559 0.3559 0.3559 03559 0.3559 $ TABLE 5 Estimated Actual Taxable Value 2,367,034,645 2,580,481,625 2,652,596,865 2,873,242,855 3,087,318,586 3,401,071,793 3,617,847,429 3,765,255,594 3,756,177,552 3,753,701,506 Note: Property in Tarrant County is reassessed once every two years. The Appraisal District assesses property at 100 percent of actual value for residential and personal. Tax rates are per $100 of assessed value. 102 TABLE 6 CITY OF COLLEYVILLE, TEXAS DIRECT AND OVERLAPPING PROPERTY TAX RATES LAST TEN FISCAL YEARS City Direct Rates Overlapping Rates General Grapevine- Hurst-Euless Operations and Obligation Total Birdville Carroll Colleyville Bedford Keller Tarrant County Tarrant County Fiscal Maintenance Debt Direct Independent Independent Independent Independent Independent Tarrant College Hospital Year Rate Service Rate School District School District School District School District School Distr-ict County District District 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 $ 0.27223 $ 0.075]7 $ 034740 $ 0.28700 0.06040 0.34740 0.29072 0.05668 0.34740 0.27771 0.06969 0.34740 0.27873 0.06867 0.34740 0.28299 0.07291 0.35590 0.28860 0.06731 0.35590 0.29864 0.05726 035590 0.29758 0.05832 035590 03]385 0.04205 0.35590 1.6170 $ 1.6170 1.6170 1.6170 1.5650 1.4050 1.4100 1.4050 1.4250 1.4350 1.9350 $ 1.9025 1.9350 L9350 1.7)50 1.4650 1.4150 1.4150 1.4150 1.4000 1.65979 $ 1.70105 1.70000 1.70000 1.57430 1.29000 1.29000 1.2)000 1.29000 132010 1.7119 $ 1.6616 1.7105 1.7230 1.5976 1.3037 1.2955 1.2955 1.2882 1.4075 1.6519 $ 0.27250 $ 0.139380 $ 0.234000 1.6762 0.27250 0.139380 0.235397 1.6975 0.27250 0.139380 0.235397 1.7158 0.27250 0.139380 0.235397 1.6080 0.27150 0.139380 0.235397 1.3574 0.26650 0.139380 0.230397 1.4169 0.26400 0137960 0.227897 1.4863 0.26400 0.137670 0.227897 1.5306 0.26400 0.137600 0.227900 1.5400 0.26400 0148970 0.227897 Source: Tarrant Appraisal District Notes: Overlapping rates are those of local and county governments that apply to properiy owners within the City of Colleyville, Texas. Not all school district overlapping rates apply to all Colleyville property owners because the City is served by five different independent school districts; far example, although the county property tax rates apply to all City property owners, the Grapevine-Colleyville lndependent School District rates apply only to the approximately two-thirds of City property owners whose property is located within that school district's geographic boundaries. 103 Taxpayer Melvin & Martindale Oncor Electric Delivery Lifetime Fitness Real Estate Toll Dallas TX LLC RCC Village Properties Colleyville Plaza LP Silveroak Land Company LP Leonard Hudson Dreiling Realty LLC Uhlman Colleyville, LLC Albertsons Herman Smith & Ca LTD RH-One LP Paul and Shelia Johnson Goodacre LTD Partnership Southwestern Bell Paul and Rebecca Kramer Village Management, LTD Total Source: Tarrant Appraisal Dish-ict CITY OF COLLEYVILLE, TEXAS PRiNCIPAL PROPERTY TAXPAYERS CURRENT YEAR AND NINE YEARS AGO Taxable Assessed Value $ 22,557,000 15,889,593 l 2,233,988 10,654,992 5,933,440 5,784,000 5,034,510 5,030,700 4,905,260 4,794,553 $ 92,818,036 2012 104 Percentage of Total Ciry Taxable Assessed Value 0.60% 0.42% 0.33% 0.28% 0.16% 0.15% 0.13% 0.13% 0.13% 0.13% - % - % - % - % - % - % - % - % 2.47% Taxable Assessed Value $ - ] 7,636,353 6,700,000 16,6ll,570 9,420,769 5,999,935 4,000,000 3,880,617 3,858,383 3,842,326 3,719,827 $ 75,669,780 2003 TABLE 7 Percentage of Total City Taxable Assessed Value - % 0.75% - % - % - % 0.28% - % - % - % - % 0.70% 0.40% �.2$% 0.17% �.16% 0.16% 0.16% 0.16% 3.19% Fiscal Year Ended 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 CITY OF COLLEYVILLE, TEXAS PROPERTY TAX LEVIES AND COLLECTIONS LAST TEN FISCAL YEARS Collected With the Taxes Levied Fiscal Year of the Levy for the Percentage Fiscal Year Amount of Levy $ 8,233,543 $ 8,151,208 98.8% 8,719,444 8,632,250 99.2% 9,201,770 9,109,752 99.1 % 9,981,646 9,906,769 99.2% 10,725,345 10,592,222 98.8% 12,024,882 11,903,333 99.0% l 2,875,919 12,734,871 98.9% 13,351,922 13,166,5 l 5 98.6% ]3,183,932 ]3,063,575 99.1% 13,163,735 13,082,029 99.4% TABLE 8 Collections Total Collections to Date in Subsequent Percentage Years Amount of Levy $ 79,096 $ 8,230,304 99.96% 84,312 8,716,562 99.97% 87,826 9,197,578 99.95% 70,762 9,977,531 99.96% 125,323 10,717,545 99.93% 105,161 12,008,494 99.86% ] ] 3,226 l 2,848,097 99.78% 83,107 13,249,623 99.23% 83,215 ]3,146,790 99.72% - 13,082,029 99.38% Sources: Tarrant County Appraisal District and City of Colleyville Finance Department. 105 Taxpayer Grapevine-Colleyville ISD Bluebonnet Hills Market Street TOWlI CellteY Lifetime Fitness Pebble Hill Timarron Broughton Maint Assoc W OSiYYIOtIi Shadowood Trail Albertsons (Glade Rd) Highland Meadows HOA La Hacienda Ranch Woodland Hills Good Acres LTD Wash Depot Good Sheperd Catholic Church Barbara Gordon School Total Source: City utility billing records CITY OF COLLEYVILLE, TEXAS PRINCiPAL WATER CUSTOMERS CURRENT YEAR AND NINE YEARS AGO Water Usage 47,359,600 15,770,600 l 3,067,600 � %,%99,g�� � �,666,g�� 9,848,800 9,336, l 00 8,406,800 6,393,700 5,606,600 144,256,400 2012 106 Percentage of Total City Water Usage 1.80% 0.60% 0.50% 0.68% 0.40% 0.37% 0.35% 0.32% 0.24% 0.21 % - % - % - % - % - % - % - % - % 5.48% Water Usage 38,923,500 6,105,300 5,349,300 3,967,500 3,632,500 3,581,000 3,180,900 3,110,500 2,444,500 1,742,900 72,037,900 2003 TABLE 9 Percentage of Tota] City Water Usage 2.00% - % - % - % - % - % - % - % - % 0.31 % 0.28% 0.20% 0.19% 0.] 8% 0.16% 0.] 6% 0.13% �.�9% 3.71 % Governmental Activities General Sales Tax Fiscal Obligation Revenue Year Bonds Bonds 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 $ 13,820,000 12,925,000 11,995,000 10,665,000 l 7,770,000 16,275,000 14,665,000 13,300,000 11,5] 0,000 9,975,000 $ 13,937,722 13,077,722 14,980,000 14,760,000 10,372,462 9,795,916 9,199,370 8,572,824 8,271,278 7,930,000 $ TABLE 10 CITY OF COLLEYVILLE, TEXAS RATiOS OF OUTSTANDING DEBT BY TYPE LAST TEN FISCAL YEARS Business-type Activities Water and Sewer Drainage Total Percentage Capital Revenue Revenue Capital Primary of Personal Per Leases Bonds Bonds Leases Government Income Capita 69, l 87 404,395 349,189 430,549 359,996 ],151,173 972,170 ] ,709, ] 20 $ 9,605,000 8,925,000 8,160,000 7,365,000 6,540,000 5,840,000 5,200,000 4,520,000 3,600,000 2,850,000 $ 2,800,000 2,660,000 2,515,000 2,365,000 2,205,000 2,040,000 l ,870,000 1,695,000 1,550,000 ] ,345,000 $ - 41,077 26,933 13,140 Notes: Details regarding the City's outstanding debt can be found in the notes to the financial statements. See Table 14 for personal income and population data. 107 $ 40,162,722 37,587,722 37,760,264 35,586,328 37,249,791 34,381,465 3l ,294,366 29,238,997 25,903,448 23,809,120 3.81% 3.43% 3.28% 2.98% 2.89% 2.65% 2.52% 2.33% 1.71% 1.57% $ 1,993 1,834 1,798 1,655 1,682 l ,528 1,388 1,291 1,136 1,037 CITY OF COLLEYVILLE, TEXAS RATiOS OF GENERAL BONDED DEBT OUTSTANDING LAST TEN FISCAL YEARS General Bonded Debt Outstanding General Less Amounts Fiscal Obligation Restricted to Year Bonds Repaying Principal Total 2003 $ 13,820,000 $ 1,025,530 $ 12,794,470 2004 12,925,000 995,889 11,929,111 2005 11,955,000 989,618 10,965,382 2006 10,665,000 1,082,681 9,582,319 2007 17,770,000 1,254,686 16,515,314 2008 16,275,000 987,681 15,287,319 2009 14,665,000 1,121,567 13,543,433 2010 13,300,000 1,154,570 12,145,430 2011 11,510,000 1,188,907 10,321,093 2012 9,975,000 1,239,412 8,735,588 TABLE il Percentage of Actual Taxable Value of Per Property Capita 0.54% $ 635 0.46% 582 0.41% 522 0.33% 446 0.53% 746 0.50% 679 0.44% 601 0.39% 536 0.33% 453 0.28% 381 Notes: Details regarding the City's outstanding debt can be found in the notes to the iinancial statements. See Table 5 for property value data. Population data can be found in Table 14. 108 CITY OF COLLEYVILLE, TEXAS DIRECT AND OVERLAPPING GOVERNMENTAL ACTIVITIES DEB'I AS OF SEPTEMBER 30, 2012 Government Unit Debt repaid with properry taxes Birdville Independent School District Carroll Independent School District Grapevine-Colleyville Independent School District Hurst-Euless-Bedford Independent School District Keller Independent School District Tarrant County Tarrant County College Disri-ict Tarrant County Hospital District Subtotal overlapping debt City direct debt Total direct and overlapping debi Debt Outstandin� $ 213,969,754 241,860,039 354,381,492 3 ] 2,938,426 700,087,009 3 l 7,725,000 22,705,000 26,285,000 19,614,120 Estimated Percentage Applicable 0.080% 0.490% 21.650% 1.580% 2.890% 3.070% 3.070% 3.070% TABLE 12 Estimated Share of Direct and Overlapping Debt $ 171,176 ],185,114 76,723,593 4,944,427 20,232,515 9,754,158 697,044 806,950 l 14,514,975 - % 19,614,120 $ 134,129,095 Sources: Assessed value data used to estimate applicable percentages provided by the Tarrant County Appraisal District and debt outstanding data provided by each governmental unit. 109 THIS PAGE INTENTIONALLY LEFT BLANK 110 CITY OF COLLEYVILLE, TEXAS LEGAL DEBT MARGIN INFORMATiON LAST TEN FISCAL YEARS Legal Debt Margin Calculation for Fiscal Year 2012 Assessed value Debt limit (.2.5°/o of assessed value) Debt applicable to limit General obligation bonds Less: Amount set aside for repayment of general obligation debt Total net debt applicable to limit Legal debt margin Fiscal Year 2003 2004 2005 2006 2007 2008 2009 TABLE 13 $ 3,753,701,506 93,842,538 9,975,000 ( 1,239,412) 8,735,588 $ 85,106,950 2010 201] 2012 Debtlimit $ 59,175,866 $ 64,512,041 $ 66,314,922 $ 71,831,071 $ 77,182,965 $ 85,026,795 $ 74,212,544 $ 79,676,820 $ 93,876,249 $ 85,106,950 Totalnetdebtapplicabletolim ]3,820,000 ]2,925,000 11,995,000 9,582,319 15,745,132 ]5,287,139 13,543,433 ]2,145,430 10,321,093 9,975,000 Lega] debt margin $ 45,355,866 $ 51,587,041 $ 54,319,922 $ 62,248,752 $ 61,437,833 $ 69,739,656 $ 60,669,1 ]] $ 67,531,390 $ 83,555,] 56 $ 75,131,950 Total net debt applicable to the limit as a percentage of debt limtt. 23.35% 20.04% 18.09% 13.34% 20.40% 17.98% 18.25% 15.24% 10.99% 11.72% Note: Under state finance ]aw, the City's outstanding general obligarion debt should not exceed 2.50 percent of total assessed property value. 111 Fiscal Year 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 Utility Service Charges $ 8,840,900 8,924,942 10,198,733 13,136,476 10,046,030 11,452,268 11,458,282 11,427,074 14,391,910 14,036,325 CITY OF COLLEYVILLE, TEXAS PLEDGED REVENUE COVERAGE LAST TEN FISCAL YEARS Less: Operating Expenses $ 6,444,484 6, ll 7,278 7,251,998 8,067,565 8,040,621 9,670,881 8,943,803 9,458,355 10,120,678 10,395,517 Water Revenue Bonds Net Available Debt Service Revenue Principal Interest $ 2,396,416 2,807,664 2,946,735 5,068,911 2,005,409 1,781,387 2,514,479 1,968,719 4,271,232 3,640,808 $ 622,000 $ 457,143 680,000 406,306 765,000 361,976 795,000 329,451 825,000 296,546 700,000 265,658 640,000 241,223 680,000 213,358 920,000 57,819 750,000 77,947 Coverage $ 1,317,273 1,721,358 1,819,759 3,944,460 883,863 815,729 1,633,256 1,075,361 3,293,413 2,812,861 Notes: Details regarding the City's outstanding debt can be found in the notes to the financial statements. Operating expenses do not include interest, depreciation, or amortization expenses. 112 Drainage Revenue Bonds Drainage Drainage Net Service Operations Available Debt Service Charges Expenses Revenue Principal Interest Coverage $ 704,031 694,196 7l 0,265 897,606 922,123 902,232 889,163 899,870 905,271 920,682 $ 235,105 312,235 338,310 444,700 462,387 510,259 500,677 484,712 551,049 660,455 $ 468,926 $ 140,000 38l ,961 140,000 371,955 175,000 452,906 150,000 459,736 160,000 391,973 165,000 388,486 170,000 415,158 175,000 354,222 152,163 260,227 205,000 $ 144,417 $ 184,509 122,263 1 l 9,698 ] 16,432 80,523 111,252 191,654 104,206 355,530 96,984 294,989 90,138 298,348 82,930 332,228 58,979 295,243 S l ,244 208,983 113 TABLE 14 Sales Tax Bonds Sales Tax Debt Service Increment Principal Interest Coverage $ 768,846 $ 185,000 873,626 l 95,000 982,844 210,000 1,132,094 240,000 1,208,379 255,000 1,300,260 270,000 1,264,385 275,000 1,317,161 290,000 1,319,517 300,000 1,426,909 315,000 $ 419,1 l4 406,472 387,085 402,929 391,366 380,013 368,195 356,290 344,195 331,588 $ 164,732 272,154 385,759 489,165 562,013 650,247 621,190 670,871 675,322 780,321 Calendar Year 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 CITY OF COLLEYVILLE, TEXAS DEMOGRAPHIC AND ECONOMIC STATTSTICS LAST TEN FISCAL YEARS Population 20,150 20,500 21,000 21,500 22,150 22,500 22,550 22,650 22,807 22,950 Personal Income $ 157,414 161,095 165,008 167,009 175,008 173,853 166,063 166,063 162,744 162,744 Per Capita Personal Income $ 52,297 53,520 54,820 55,485 58,142 57,758 55,170 55,354 66,236 66,236 TABLE 15 Tarrant County Unemployment Rate 6.3 % 5.6% 5.1% 4.5% 4.3 % 5.1% 8.2% 7.9% 8.3% 6.2% Sources: Population - North Central Texas Council of Governments, personal income - City of Colleyville Economic Development Department, Unemployment Rate - Texas Workforce Commission (unemployment rate is not available solely for the City of Colleyville) 114 CITY OF COLLEYVILLE, TEXAS PRINCiPAL EMPLOYERS CURRENT YEAR AND NINE YEARS AGO Employer Grapevine Colleyville ISD Market Street Lifetime Fitness City of Colleyville Kroger Albertsons Covenant Christian Academy LaHacienda Ranch TGW Insurance Sonshine Academy Mac's Steak and Seafood Compass Christian Church Michael's Keys TOYaI Source: City Economic Development Division *This information is unavailable. 2012 Percentage of Total City Employees Employment 1,681 369 230 196 110 1�% 100 95 60 55 50 40 3,093 115 32.6% 7.1% 4.5% 3.8% - % 2.1 % 2.1% 1.9% 1.8% 1.2% 1.1% 1.0% 0.8% 59.9% TABLE 16 2003 Percentage of Total City Employees Employment* 720 162 15� 200 1�� 40 93 ] ,465 - % - % - % - % - % - % - % - % - % - % - % - % - % - % TABLE 17 CITY OF COLLEYVILLE TEXAS FULLTIME EQU�VALENT CITY GOVERNMENT EMPLOYEES BY FUNCTION/PROGRAM LAST TEN FISCAL YEARS Fulltimc Equivalent Employees as of September 30, Function/Program 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 General government Management services 6 6 6 6 5 5 4 4 4 4 Finance/court 7 7 7 7 6 6 6 6 6 6 Planning 5 3 3 3 3 3 3 2 2 2 Building 5 5 5 5 5 6 6 5 4 3 Other 3 4 5 5 6 6.5 7.5 9.5 11 11 Police Officers 30 30 31 32 35 37 38 38 38 39 Civilians 10 10 10 11 13 ]4 l4 13 6 6 Fire Firefighters and officers 30 30 33 33 33 33 33 33 33 35 Civilians 1 ] ] 1 1 l 1 2 l 1 Other public works Engineering 6 5 5 5 5 5 5 4 4.5 3.0 Other 3 3 3 3 3 3 3 3 3 3 Streets 10 ]0 10 10 10 10 ]0 10 10 ]0 Parks and recreation 12.5 12.5 12.5 12.5 13.5 13.5 13.5 l 6.5 ] 6 16 Library 5.5 5.5 5.5 5.5 7.5 8.0 8.0 9.5 9.5 9.5 Colleyville center 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 Water/wastewater 22.5 25.5 25.5 28 29 29 29 28 24 24 Drainage 4 4 6 6 6 6 6 6 6 6 Total 165 A 166.0 ] 73.0 177.5 185.5 190.5 191.5 ] 94.0 182.6 182.6 Source: City Human Resources Office Notes: A fulltime employee is scheduled to work 2080 hours per year (including vacation and sick leave). Fulltime equivalent employment is calculated by dividing total labor hours by 2080. ll6 Function/Program 2003 General government Building perniits issucd 132 Building inspections conducted 5,011 Police Physical anests 643 Calls for service ] 1,407 Traffic violations 7,806 Fire F,mergency responses 629 Ambulance calls 559 Inspcctions 750 Other public wor]<s Street resurfacing (miles) I Parks and recreation Athletic field participants 668 Community center rentals 737 Library Volumes in collection 21,757 Total volumes borrowed ]7,933 Water Customece 7,781 Average daily consumption (thousands of gallons) 5,321 Peak daily consumption (tl�oueands of gallone) 15,123 Wastewater Customers 7,112 Source: Various City departments CITY OF COLLEYVILLE, TEXAS OPERATING iNDiCATORS BY FUNCTION/PROGRAM LAST TEN FISCAL YEARS Fiscal Year 2004 2005 2006 2007 2008 275 245 270 140 131 7,401 8,734 9,599 8,941 8,108 643 404 485 666 514 11,407 10,668 10, 546 17,629 15,292 7,806 7,3] 1 l 1,218 12,438 15,621 629 510 656 715 681 559 609 589 630 667 750 560 312 503 666 2 3 3 4.5 8.5 685 690 602 4,960 5,159 614 580 637 592 627 22,334 34,656 43,378 46,311 50,348 102,]65 139,130 177,087 197,712 211,674 8,067 8,271 8,56] 8,700 8,893 4,964 5,951 8,081 S,123 6,619 13,204 16,126 16, 732 13,068 16,764 7,294 7,563 7,761 7,966 8,138 117 2009 2010 90 5,641 809 23,480 12,550 737 693 796 13.9 4,617 507 54,659 238,459 8,960 6,578 16,674 8,315 77 6,149 764 12,242 13,822 762 751 784 8.0 4,296 373 58,147 244,458 9,014 5,990 l 8,207 8,389 2011 104 6,737 666 27,254 ] 1,354 830 765 397 6.2 4,378 410 62,997 235,238 9,103 7,928 18,935 8,457 TABLE 18 2012 155 8,310 653 48,076 11,980 724 803 342 1.0 3,946 404 65,740 244,6] 3 9,285 7,217 18,707 8,603 TABLE 19 CITY OF COLLEYVILLE, TEXAS CAPITAL ASSET STATISTTCS BY FUNCTTON/PROGRAM LAST TEN FISCAL YEARS Fiscal Year Function/Program 2003 2004 2005 2006 2007 2008 200) 2010 2011 2012 Police Stations 1 1 1 l 1 1 1 l 1 1 Patrol units 6 7 7 7 10 ] 3 13 13 13 ] 2 Fire Stations 2 2 2 2 2 3 3 3 3 3 Public works Streets (miles) 288 295 300 307 31 1 312 312 318 282 282 Streetlights 745 751 860 990 1,0] 1 1,010 1,168 1,188 1,169 1,169 Traffic signals 2 2 2 2 2 2 2 2 2 2 Parks and recreation Acreage 207 207 212 212 224 224 224 224 224 224 Playgrounds 5 5 5 5 6 6 6 6 6 6 Baseball/softball diamonds 9 9 9 9 9 9 9 9 9 9 Soccer fields 14 ] 4 14 14 14 ] 4 14 14 14 14 Community centers l 1 1 1 l 1 1 1 l 1 Water Water mains (miles) ] 52 170 173 ] 75 191 192 199 200 195 20l Fire hydrants 940 1,108 1,149 1,206 ],254 1,271 1,340 1,345 1,362 1,389 Storage capacity 4,900 4,900 4,900 4,900 4,900 4,900 9,900 9,900 9,400 9,400 (thousands of gallons) W astewater Sanitary sewers (miles) 133 147 150 ] 54 ] 63 164 166 ] 70 l62 169 Storm sewers (miles) 55 56 57 58 59 59 63 63 58 64 Source: Various City departments Note: No capital asset indicators are available for the general government or library function. 118 COMPLIANCE 119 THIS PAGE INTENTIONALLY LEFT BLANK 120 �,=ll PATTILLO, BROWN 8r HILL,r._L.��. CERTIFIED PUBLIC ACCOUNTANTS ■ BUSINESS CONSULTANTS REPORT ON INTERNAL CONTROL OVER FINANCIAL REPORTING AND ON COMPLIANCE AND OTHER MATTERS BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT A UDITING STANDARDS To the Honorable Mayor and Members of the City Council City of Colleyville, Texas We have audited the financial statements of the governmental activities, the business-type activities, the aggregate discretely presented component unit, each major fund, and the aggregate reinaining fund information of City of Colleyville, Texas (the "City") as of and for the year ended September 30, 2012, which collectively comprise the City's basic financial statements and have issued our report thereon dated January 25, 2013. We conducted our audit in accordance with auditing standards generally accepted in the United States of America and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Internal Control Over Financial Reporting Management of the City is responsible for the establishing and maintaining effective internal control over financial reporting. In planning and performing our audit, we considered the City's internal control over financial reporting as a basis for designing our auditing procedures for the purpose of expressing our opinions on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of the City's internal control over financial reporting. Accordingly, we do not eXpress an opinion on the effectiveness of the City's internal control over financial reporting. A deficiency in inte�nal control exists when the design or operation of a control does not allow management or employees, in the nortnal course of performing their assigned functions, to prevent, or detect and correct misstatements on a timely basis. A material weakness is a deficiency, or a combination of deficiencies, in internal control such that there is a reasonable possibility that a material misstatement of the entity's financial statements will not be prevented, or detected and corrected on a timely basis. Our consideration of internal control over financial reporting was far the limited purpose described in the first paragraph of this section and was not designed to identify all deficiencies in internal control over financial reporting that might be deficiencies, significant deficiencies, or material weaknesses. We did not identify any deiiciencies in internal control over financial reporting that we consider to be material weaknesses, as defined above. 121 401 WEST HTGHWAY 6� P. O. BOX 20725 � WACO, TX 76702-0725 �(254) 772-4901 � FAX: (254) 772-4920 � www.pbhcpa.com AFFILIATE OFFICES: BROWNSV[LLE, TX (956) 544-7778 � HILLSBORO, TX (254) 582-2583 TEMPLE, TX (254) 79 L-3460 � ALBUQUERQUE, NM (505) 266-5904 Compliance and Other Matters As part of obtaining reasonable assurance about whether the City's financial statements are free of material misstatement, we performed tests of its compliance with certain provisions of laws, regulations, contracts, and grant agreements, noncompliance with which could have a direct and material effect on the determination of iinancial statement amounts. However, providing an opinion on compliance with those provisions was not an objective of our audit, and accordingly, we do not express such an opinion. The results of our tests disclosed no instances of noncompliance or other matters that are required to be reported under Government Auditing Standards. This report is intended solely for the information and use of management, City Council, others within the entity, and federal awarding agencies and pass-through entities and is not intended to be and should not be used by anyone other than these specified parties. �a��o1 ��� January 25, 2013 � �};� , L. �-.-P 122