The URL can be used to link to this page

CAFR FY 2013-2014CITY OF SCHERTZ, TEXAS COMPREHENSIVE ANNUAL FINANCIAL REPORT FISCAL YEAR ENDED SEPTEMBER 30, 20]4 OFFICIALS ISSUING REPORT John C. Kessel City Manager Juan F. Santoya, Jr. Director of Finance rr CITY OF SC0FD{TZ,TEXA8 TABLE 0PCONTENTS SEPTEMBER 3O,2014 INTRODUCTORY SECTION ......................................................................................................... iii LETTER [)F TRANSMITTAL ----------------------------------------iv CITYOFFICIALS ............................................................................................................................................ ir ORGANIZATIONAL CruAu/ ----------------------------------------.x CERTIFICATE OF ACHIEVEMENT ------------------------------------.xi FINANCIAL SECTION B/\8[C FINANCIAL STATEMENTS ------------------------------------|4 STATl�D�By�T(}FyJET9()SlTl(}�� .]5 STATEMENT ()F ACTIVITIES ................................................................................................................. 17 BALANCE SHEET - GOVERNMENTAL FDN[)S---------------------------' 19 RECONCILIATION OF BALANCE SHEET ............................................................................................. 2] STATEMENT {)FREVENUES, EXPENDITURES, /\ND CHANGES IN FUND BALANCES - 9LNlJS.................................................................................................................... 22 RECONCILIATION OF THE STATEMENT OF REVENUES, GOVERNMENTAL FUNDS TO THE STATEMENT (}9 ACTIVITIES ...................................................................................................... 24 STATEMENT [)F NET POSITION - PROPRIETARY FUNDS ................................................................ 25 STATEMENT (}F REVENUES, EXPENSES, AND CHANGES IN FUND NET POSITION - PROPRIETARY FUNDS .......................................................................................................................... 27 NOTES TO BASIC FINANCIAL STATEMENTS ........................................................................................ 30 SCl{E[DJLB OF QB\/ENLUBB` EXPENDITURES, AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL - GENERAL FUND ...................................................................................... 57 SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL - ECONOMIC DEVELOPMENT CORPORATION '''''''''''----'56 NOTES TO SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES BN FUND BALANCE - BUDGET AND ACTUAL .'''''''''''''''''''''''''''''''''''''''------0O TEXAS MUNICIPAL RETIREMENT SYSTEM - ANALYSIS OF FUNDING PROGRESS ..................6| RETIREE HEALTH INSURANCE PLAN - ANALYSIS OF FUNDING PROGRESS 62 SUPPLEMENTARY INFORMATION -----------------------------------.63 COMPARATIVE BALANCE SHEETS - GENERAL FUND .................................................................... 64 COMPARATIVE STATEMENTS ()pREVENUES, EXPENDITURES AND CHANGES IN FLDNTJ BALANCE-(]ENEB'ALF\TNI) ............................................................................................................... 65 COMPARATIVE BALANCE SHEETS - ECONOMIC DEVELOPMENT CORPORATION .................. 62 COMPARATIVE STATEMENTS (]F REVENUES, EXPENDITURES AND CHANGES DqFUND i CITY OF SCHERTZ, TEXAS TABLE OF CONTENTS (CONTINUED) SEPTEMBER 30, 2014 FINANCIAL SECTION (Continued) PAGE COMPARATIVE BALANCE SHEETS - DEBT SERVICE FUND ........................................................... 68 SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - FUND BALANCES - GOVERNMENTAL FUNDS .............................................................................................. BUDGET TO ACTUAL - DEBT SERVICE FUND ................................................................................... 69 COMPARATIVE BALANCE SHEETS - CAPITAL PROJECTS FUND .................................................. 66 COMPARATIVE STATEMENTS OF REVENUES, EXPENDITURES AND CHANGES IN FUND TOTAL WATER AND SEWER CONSUMPTION AND RATES .......................................................... BALANCE - CAPITAL PROJECTS FUND ............................................................................................ 67 COMBINING BALANCE SHEET - NONMAJOR GOVERNMENTAL FUNDS .................................... 72 COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND 98 BALANCES — NONMAJOR GOVERNMENTAL FUNDS .................................................................... 74 SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - 100 BUDGET TO ACTUAL - HOTEL OCCUPANCY FUND ...................................................................... 76 SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - 102 BUDGET TO ACTUAL - PARK FUND .................................................................................................. 77 SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET TO ACTUAL - TREE MITIGATION FUND .......................................................................... 78 SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - 107 BUDGET TO ACTUAL - POLICE FORFEITURES FUND ................................................................... 79 SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - 109 BUDGET TO ACTUAL - LIBRARY ADVISORY BOARD .................................................................. 80 SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET TO ACTUAL - HISTORICAL COMMITTEE FUND ............................................................ 81 SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET TO ACTUAL - PARKS AND RECREATION FOUNDATION ............................................ 78 STATISTICAL SECTION NET POSITION, BY COMPONENT ............................................................................................................ 84 CHANGEIN NET POSITION ....................................................................................................................... 86 FUND BALANCES - GOVERNMENTAL FUNDS .............................................................................................. 90 CHANGES IN FUND BALANCES, GOVERNMENTAL FUNDS .............................................................. 92 TAX REVENUE BY SOURCE — GOVERNMENTAL FUNDS ................................................................... 94 TOTAL WATER AND SEWER CONSUMPTION AND RATES .......................................................... 95 PRINCIPAL WATER AND SEWER CONSUMERS - ASSESSED VALUE AND ESTIMATED ACTUAL VALUE OF TAXABLE PROPERTY ........................................................................................ 97 DIRECT AND OVERLAPPING PROPERTY TAX RATES ....................................................................... 98 PRINCIPAL PROPERTY TAX PAYERS ...................................................................................................... 99 PROPERTY TAX LEVIES AND COLLECTIONS ..................................................................................... 100 TAXABLE ASSESSED VALUE .................................................................................................................. 101 RATIOS OF OUTSTANDING DEBT BY TYPE ........................................................................................ 102 RATIOS OF GENERAL BONDED DEBT OUTSTANDING ............................................................... 104 DIRECT AND OVERLAPPING GOVERNMENTAL ACTIVITIES DEBT - DEBT MARGIN INFORMATION........................................................................................................................................ 106 PLEDGED REVENUE COVERAGE ........................................................................................................... 107 DEMOGRAPHIC AND ECONOMIC STATISTICS ................................................................................... 108 TOP TEN PRINCIPAL EMPLOYERS ......................................................................................................... 109 FULL-TIME EQUIVALENT CITY GOVERNMENTAL EMPLOYEES BY FUNCTION ....................... 110 ii CITY OF SCHERTZ, TEXAS TABLE OF CONTENTS (CONTINUED) SEPTEMBER 30, 2014 STATISTICAL SECTION (Continued) PAGE OPERATING INDICATORS BY FUNCTION /PROGRAM ........................................ ............................... 111 CAPITAL ASSET STATISTICS BY FUNCTION/ PROGRAM ................................... ............................... 113 COMPLIANCE SECTION 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 AUDITING STANDARDS ................... ............................... 116 iii INTRODUCTORY SECTION IV March 03, 2015 To the Honorable Mayor, City Council, and the Citizens of City of Schertz: State law requires that local governments publish a complete set of financial statements presented in conformity with generally accepted accounting principles in the United States of America (U.S. GAAP) and audited in accordance with generally accepted auditing standards in the United States of America by a firm of licensed certified public accountants. Pursuant to that requirement, we hereby issue the comprehensive annual financial report of the City of Schertz for the fiscal year ended September 30, 2014. This report consists of management's representations concerning the finances of the City of Schertz. Consequently, management assumes full responsibility for the completeness and reliability of all the information presented in this report. To provide a reasonable basis for making these representations, management of the City of Schertz has established a comprehensive internal control framework that is designed both to protect the government's assets from loss, theft, or misuse and to compile sufficient reliable information for the preparation of the City of Schertz's financial statements in conformity with U.S. GAAP. Because the cost of internal controls should not outweigh their benefits, the City of Schertz comprehensive framework of internal controls has been designed to provide reasonable rather than absolute assurance that the financial statements will be free from material misstatement. As management, we assert that, to the best of our knowledge and belief, this financial report is complete and reliable in all material respects. The City of Schertz's financial statements have been audited by Armstrong, Vaughan & Associates P.C. a firm of licensed certified public accountants. The goal of the independent audit was to provide reasonable assurance that the financial statements of the City of Schertz for the fiscal year ended September 30, 2014, 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 Schertz's financial statements for the fiscal year ended September 30, 2014, are fairly presented in conformity with U.S. GAAP. The independent auditor's report is presented as the first component of the financial section of this report. GAAP requires that management provide 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 MD &A and should be read in conjunction with it. The City of Schertz's MD &A can be found immediately following the report of the independent auditors. 1400 Schertz Parkway Schertz, Texas 78154 ° 210.619.1000 schermcom u Profile of the Government The City of Schertz, incorporated in 1958, is located in the central part of Texas, which is considered to be a top growth area in the state, and one of the top growth areas in the country. The City of Schertz currently occupies a land area of 32.21 square miles with a population of 36,477 in 2014. The City of Schertz is empowered to levy a property tax on both real and personal properties located within its boundaries. It also is empowered by state statue to extend its corporate limits by annexation, which occurs periodically when deemed appropriate by the governing body. The City of Schertz has operated under the council- manager form of government since 30 November 1972. Policymaking and legislative authority are vested in a City Council consisting of the mayor and 5 other members. The City Council is responsible for establishing public policy on City matters by the passage of appropriate ordinances and resolutions. The City Manager is responsible for overseeing the day -to -day operations of the government, implementing policy established by City Council, and for appointing the heads of the various departments. The council is elected on a non - partisan basis. Council members serve two -year staggered terms, with two council members elected every two years. The mayor is elected to serve a two -year term. The mayor and all five council members are elected at large. The City of Schertz provides a full range of services, including police and fire protection, EMS services, the construction and maintenance of streets, recreational facilities, cultural events, water and sewer services. The annual budget and five -year forecast serve as the foundation for the City of Schertz's financial planning and control. All city departments are required to submit requests for appropriation to the City Manager by June of each year. The City Manager uses these requests as the starting point for developing a proposed budget. The City Manager then presents the proposed budget to the council . for review before August 1st. The council then holds public hearings and community meetings on the proposed budget and to adopt a final budget by September 30th. The fiscal year for Schertz is from October 1 through September 30. The appropriated budget is prepared by each department (e.g. police). Department heads may make transfers of appropriations within a department. The City Manager may make transfers between departments and funds with City Council approval. Budget to actual comparisons are provided in this report for each individual governmental fund for which an appropriated annual budget has been adopted. For the general fund, this comparison is presented on pages 57 -58 as part of the required supplementary information. Factors Affecting Financial Condition. The information presented in the financial statements is perhaps best understood when it is considered from the broader perspective of the specific environment within which the City of Schertz operates. vi Local economy. The City of Schertz enjoys a favorable economic environment and leading indicators point to continued growth. In December 2014, the unemployment rate was 3.1 %. Within a 15 mile radius, the labor market includes a workforce of approximately 331,000 well trained workers and this number is expected to increase in the next several years as the region continues to experience population and business growth. Local indicators point to a strong and growing housing market. The City planned well and has an abundant water supply for meeting its future growth. In the last few years, four Fortune 1.00 companies have made major investments in Schertz. These four companies include General Electric, Caterpillar, Amazon.com and SYSCO. General Electric purchased Salof Companies which designs and manufactures small scale liquefied natural gas technologies and occupies a 390,935 square foot facility in Schertz. The purchase of Salof will allow General. Electric to expand their worldwide capabilities in the liquefied natural gas industry. Amazon.com completed construction of their $166 million fulfillment center on 96 acres in Schertz in time for the 2013 holiday season. The fulfillment center has 1.26 million square feet and is the largest facility in Schertz and in Guadalupe County. The new fulfillment center has 674 new full - time jobs with an annual payroll of $1.1 million. SYSCO completed their 630,000 square foot distribution facility in January 2012 and employs 810 full -time staff. This is a regional distribution center for SYSCO. In addition, Baptist Emerus Emergency Hospital completed construction on its new $11 million facility in April 2013. Businesses with headquarters or divisions located within the city or in close proximity include Vision Works, Brandt Engineering, Cal -Tex Protective Coatings, Inc., CST Distribution which was formerly Valero, FedEx Freight, Marshall Shredding Company, Kraft Nabisco, Republic National Distributing Company, Caterpillar, Wal -Mart, and H.E.B. Long -term financial planning. The community approved bond propositions in November 2010 for quality of life projects which included a swimming pool, improvements to the baseball fields and soccer fields, building a new animal adoption facility, and improvements to Main Street. The animal adoption facility was completed and operational in March 2014. The baseball field improvements were also completed in spring 2014. . Completion of the soccer fields is scheduled for the mid -year 2015. Design work was completed for the aquatic facility and selection of a Construction Manager at Risk was made in early 2015. Main Street improvements continue to be developed. Financial Information: Internal Control. Management is responsible for establishing and maintaining internal controls designed to ensure that assets of the City are protected from loss, theft or misuse and to provide adequate accounting information compiled to allow for the preparation of financial statements in conformity with generally accepted accounting principles for local governments as prescribed by the Governmental Accounting Standards Board (GASB), the Financial Accounting Standards Board (FASB) and the American Institute of Certified Public Accountants (AICPA). The internal control system is designed to provide reasonable, but not absolute assurance that these objectives are met. The concept of reasonable assurance recognizes that the cost of an internal control should not exceed the benefits derived from the internal control. The City utilizes financial accounting software which is designed with a system of internal controls. These controls are continually being reevaluated to provide reasonable, but not absolute, assurances. vli Budget Controls. The City also utilizes budgetary controls. Legally expenditures cannot exceed the appropriated amount. The objective of these budgetary controls is to ensure compliance with the adopted budget approved by the City Council as mandated by the city charter and state law. The levels of budgetary control are established at the line -item basis and at the fund level. Cash management policies and practices. During the year, temporarily idle cash was invested through State local investment pools. Cash available for longer term investments was invested in agency bonds and certificates of deposit. Cash in the State local investment pools are essentially liquid. Longer term investments had an average maturity of 1.25 years. The average yield on the investment portfolio was .25 percent. Active involvement in investment instruments was limited due to the continuation of extremely low interest rates and market uncertainty. The rate of return was simply not sufficient to justify the management expense. Risk Management. During 2014, . the City continued a risk management program for worker's compensation. Various control techniques, including employee accident prevention training, have been implemented during the year to minimize accident - related losses. Third -party coverage is currently maintained for individual worker's compensation claims and all other potential losses. Additional information on the City of Schertz's risk management activity can be found in the notes to the financial statements. Pension benefits. The City of Schertz is a member city of the Texas Municipal Retirement System, referred to as TMRS. TMRS is one of the leading public pension funds in the nation. Each year, an independent actuary engaged by the pension plan calculates the amount of the annual contribution the City of Schertz must make to the pension plan to ensure the plan will be able to fully meet its obligations to retired employees on a timely basis. As a matter of policy, the City of Schertz fully funds each year's annual required contribution to the pension plan as determined by the actuary. The remaining unfunded amount is being systematically funded as part of the annual required contribution calculated by the actuary. Other Financial Information: Independent Audit. An independent audit is performed every year of the general ledger, accounts, financial records, and transactions of all city departments. The audit is completed by an independent certified public accounting firm selected by the City Council. The City is in compliance with this requirement and the independent auditor's report by Armstrong, Vaughan, P.C. Certified Public Accountants, has been included in this report. Awards and Acknowledgements The Government Finance Officers Association of the United States and Canada (GFOA) awarded a Certificate of Achievement for Excellence in Financial Reporting to the City of Schertz for its comprehensive annual financial report for the fiscal year ended September 30, 2013. . This was the 29th consecutive year that the City has received this prestigious award. In order to be awarded a Certificate of Achievement, the City 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. viii A Certificate of Achievement is valid for a period of one year only. We believe our current comprehensive annual financial report continues to meet the Certificate of Achievement Program's requirements and we are submitting it to the GFOA to determine its eligibility for another certificate. The preparation of this report would not have been possible without the efficient and dedicated services of the entire staff of the finance department. We would like to express our appreciation to all members of the department who assisted and contributed to the preparation of this report. In addition, without the assistance of each and every department head on staff, we would have none of the successes we've enjoyed. Credit also must be given to the Mayor and the City Council for their unfailing support for the City Manager and staff. Respectfully submitted, 00�voor John C. Kessel City Manager ix CITY OF SCHERTZ, TEXAS CITY OFFICIALS MAYOR MICHAEL CARPENTER. MAYOR PRO -TEM DARYL JOHN CITY COUNCIL DAVID SCAGLIOLA CEDRIC EDWARDS, SR. 1► krd Ism I WiA11 JIM FOWLER CITY MANAGER JOHN C. KESSEL DIRECTOR OF FINANCE JUAN F. SANTOYA, JR. CITY ATTORNEY CHARLES ZECH, DENTON, NAVARRO, ROCHA, BERNAL, HYDE & ZECH, P.C. .2111 %t41D1TO _?4TI`yYZM[f %rilil'. /_ \`►�F:?./_F.Y.Y�7 /_Ill f.` � x • *Appointed by City Council xi Govern, mere. Finance Officers Association Presented'to Financial Wport f6r tk Fiwal Ydw E�ded Executivc DirwtorICEO xii FINANCIAL SECTION StrARE tOLDERS Nancy 1.. Vaughan, CPA Deborah E Fraser, CPA Phil S. Vaughan, CPA To the Honorable Mayor and Members of the City Council City of Schertz, Texas e z� z t 1 �,. Vaughan& Associates, IBC: Report on the Financial Statements Certified Public Accountants We have audited the accompanying financial statements of the governmental activities, the business -type activities, each major fund, and the aggregate remaining fund information of City of Schertz, as of and for the year ended September 30, 2014, and the related notes to the financial statements, which collectively comprise City of Schertz's basic financial statements as listed in the table of contents. Management's Responsibility for the Financial Statements City of Schertz's management is responsible for the preparation and fair presentation of these financial statements in accordance with accounting principles generally accepted in the United States of America; this includes the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Auditor's Responsibility 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 from material misstatement. An audit involves performing procedures to obtain audit evidence about the amounts and disclosures in the financial statements. The procedures selected depend on the auditor's judgment, including the assessment of the risks of material misstatement of the financial statements, whether due to fraud or error. In making those risk assessments, the auditor considers internal control relevant to the entity's preparation and fair presentation of the financial statements in order to design audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of the entity's internal control. Accordingly, we express no such opinion. An audit also includes evaluating the appropriateness of accounting policies used and the reasonableness of significant accounting estimates made by management, as well as evaluating the overall presentation of the financial statements. We believe that the audit evidence we have obtained is sufficient and appropriate to provide a basis for our audit opinions. 941 West Byrd Blvd., Smite 101, . Universal City, Texas 78148 Phone: 210 - 658 -6229 . Fax: 210 - 639 -7 11 - email: vaughan @avac a,com # wwwavacpa:xor 2 Opinions In our opinion, the financial statements referred to above present fairly, in all material respects, the respective financial position of the governmental activities, the business -type activities, each major fund, and the aggregate remaining fund information of City of Schertz, as of September 30, 2014, and the respective changes in financial position and, where applicable, cash flows thereof for the year then ended in accordance with accounting principles generally accepted in the United States of America. Other Matters Required Supplementary Information Accounting principles generally accepted in the United States of America require that management's discussion and analysis, budgetary comparison information, and schedule of funding progress, as listed in the table of contents, 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. The budgetary comparison information is the responsibility of management and was derived from and relate directly to the underlying accounting and other records used to prepare the basic financial statements. Such information has been subjected to the auditing procedures applied in the audit of the basic financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the basic financial statements or to the basic financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America. In our opinion, the budgetary comparison information is fairly stated, in all material respects, in relation to the basic financial statements as a whole. We have applied certain limited procedures to the management's discussion and analysis and schedule of funding progress 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 management's discussion and analysis and schedule of funding progress because the limited procedures do not provide us with sufficient evidence to express an opinion or provide any assurance. Other Information Our audit was conducted for the purpose of forming opinions on the financial statements that collectively comprise City of Schertz's basic financial statements. The combining and individual nonmajor fund financial statements, introductory section, and statistical section are presented for purposes of additional analysis and are not a required part of the basic financial statements. The combining and individual nonmajor fund financial statements are the responsibility of management and were derived from and relate directly to the underlying accounting and other records used to prepare the basic financial statements. Such information has been subjected to the auditing procedures applied in the audit of the basic financial statements and certain additional procedures, including comparing and reconciling such information directly to the underlying accounting and other records used to prepare the basic financial statements or to the basic financial statements themselves, and other additional procedures in accordance with auditing standards generally accepted in the United States of America. In our opinion, the combining and individual nonmajor fund financial statements are fairly stated, in all material respects, in relation to the basic 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 it. Other Reporting Required by Government Auditing Standards In accordance with Government Auditing Standards, we have also issued our report dated March 03, 2015 on our consideration of City of Schertz'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 in considering City of Schertz's internal control over financial reporting and compliance. Armstrong, Vaughan & Associates, P.C. March 03, 2015 29 MANAGEMENTS DISCUSSION AND ANALYSIS As management of the City of Schertz, we offer readers of the City's financial statements this narrative overview and analysis of the financial activities of the City of Schertz for the fiscal year ended September 30, 2014. 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 in the introductory section of this report. Financial Highlights The assets of the City of Schertz exceeded its liabilities at the close of the most recent fiscal year by $151.9 million (net position). Of this amount, $25.1 million (unrestricted net position) may be used to meet the City's ongoing obligations to citizens and creditors. The City's total net position increased by $15.0 million. A significant portion of this increase, 57 %, is attributable to capital contributions from developers. As of the close of the current fiscal year, the City's governmental funds reported combined ending fund balances of $27.4 million, a decrease of $3.0 million in comparison with the prior year. At the end of the fiscal year, the combined total of the General Fund assigned and unassigned fund balances was $6.3 million which is 32% of the general fund expenditures not including capital outlay. The fund balance policy is to have a 25% balance. During the fiscal year, the City issued $10.6 million in general obligation refunding bonds and $5.0 million in certificates of obligation for water and sewer improvements. 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 comprise 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 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 position presents information on all of the City's assets and liabilities, with the difference between the two reported as net position. Over time, increases or decreases in net position may serve as a useful indicator of whether the financial position of the City of Schertz is improving or deteriorating. The statement of activities presents information showing how the City's net position changed during the most recent fiscal year. All changes in net position are reported as soon as the underlying event giving 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 future fiscal periods (e.g. uncollected taxes and earned but unused vacation leave). Both of the government -wide financial statements distinguish functions of the City of Schertz that are principally supported by taxes and intergovernmental revenues (governmental activities) from other 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 of Schertz include general government, public safety, streets and parks, health, and culture and recreation. The business -type activities of the City of Schertz include a water and sewer department and an emergency medical services department. Fund financial statements. A fund is a grouping of related accounts that is used to maintain control over resources that have been segregated for specific activities or objectives. The City of Schertz, like other state and local governments, uses fund accounting to ensure and demonstrate compliance with finance- related legal requirements. The funds of the City of Schertz can be divided into two categories: governmental and proprietary. Governmental funds. Governmental funds are used to account for essentially the same functions reported as governmental activities in the government -wide financial statements. However, unlike the government - wide financial statements, governmental fund financial statements focus on near term inflows and outflows of spendable resources, as well as on balances of spendable resources available at the end of the fiscal year. Such information is 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 fiends 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 fund balance sheet and the governmental fund statement of revenues, expenditures, and changes in fund balances provide a reconciliation to facilitate this comparison between governmental funds and governmental activities. The City of Schertz maintains eleven individual governmental funds. Information is presented separately in the governmental fiend balance sheet and in the governmental fund statement of revenues, expenditures, and changes in fund balances for the general fund, the debt service fund, the economic development corporation and the capital projects fund, all of which are considered to be major funds. Data from the other seven governmental funds are combined into a single, aggregated presentation. Individual fiend data for each of these non -major governmental funds is provided in the form of combining statements elsewhere in this report. Proprietary funds. The City of Schertz 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 of Schertz uses enterprise fiends to account for its water and sewer department and for its emergency medical services department. Proprietary funds provide the same type of information as the government -wide financial statements, only in more detail. The proprietary fund financial statements provide separate information for the water and sewer department and for the emergency medical services department, both of which are considered to be major funds of the City of Schertz. 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. 0 Other information. In addition to the basic financial statements and accompanying notes, this report also presents certain required supplementary information concerning the City's general fund budgetary schedule. The City of Schertz adopts an annual appropriated budget for its general fund. A budgetary comparison schedule has been provided for the general fund to demonstrate compliance with this budget. The economic development corporation also adopts an annual budget, and a comparison schedule for it also is provided in the required supplementary information. The combining statements referred to earlier in connection with non -major governmental funds are presented immediately following the required supplementary information. Government -wide Financial Analysis As noted earlier, net position may serve over time as a useful indicator of a government's financial position. In the case of the City of Schertz, assets exceeded liabilities by $151.9 million at the close of the most recent fiscal year. The largest portion of the City's total net position (77 %) reflects its net investment in capital assets (e.g., land, buildings, machinery, and equipment) less any related debt used to acquire those assets that is still outstanding, plus bond proceeds that have not yet been signed. The City of Schertz uses these capital assets to provide services to citizens; consequently, these assets are not available for operational type of 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. An additional portion of the City's total net position (7 %) represents resources that are subject to external restrictions on how they may be used. The remaining balance of unrestricted net position, $25.1 million, may be used to meet the government's ongoing obligations to citizens and creditors. At the end of the current fiscal year, the City of Schertz is able to report positive balances in all three categories of net position, both for the government as a whole, as well as for its separate governmental and business -type activities. The same situation held true for the prior fiscal year. TABLE A -1. NET POSITION 0 Governmental Activities Business -Type Activities Total 2014 2013 2014 2013 2014 2013 Current and Other Assets $ 32,058,111 $ 34,732,826 $ 22,393,677 $ 15,115,524 $ 54,451,788 $ 49,848,350 Capital Assets 111,550,067 102,042,076 64,553,475 61,785,399 176,103,542 163,827,475 Total Assets 143,608,178 136,774,902 86,947,152 76,900,923 230,555,330 213,675,825 Deferred Outflows 969,012 423,735 146,807 112,125 1,115,819 535,860 Current Liabilities 7,021,924 6,585,918 4,011,930 3,195,714 11,033,854 9,781,632 Long -Term Liabilities 55,747,628 58,635,329 12,956,604 8,843,216 68,704,232 67,478,545 Total Liabilities 62,769,552 65,221,247 16,968,534 12,038,930 79,738,086 77,260,177 Net Investment in Capital Assets 62,792,671 57,543,618 53,674,437 53,071,836 116,467,108 110,615,454 Restricted 10,401,728 7,788,354 - - 10,401,728 7,788,354 Unrestricted 8,613,239 6,645,418 16,450,988 11,902,282 25,064,227 18,547,700 Total Net Position $ 81,807,638 $ 71,977,390 $ 70,125,425 $ 64,974,118 $ 151,933,063 $ 136,951,508 0 The government's net position increased by $15.0 million during the current fiscal year. Fifty -seven percent of this increase represents capital contributions from developers. The following table indicates changes in net position for governmental and business -type activities followed by graphs displaying total revenues and expenses by type: TABLE A -2 CHANGES IN NET POSITION FOR GOVERNMENTAL AND BUSINESS -TYPE ACTIVITIES $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 TOTAL REVENUES- GOVERNMENT -WIDE Charges for Operating Capital Grants Property Taxes Other Taxes Unrestricted Miscellaneous Services Grants and and Investment Contributions Contributions Earnings ®iota ®ZOf Governmental Activities Business -Type Activities Total Revenues: 2014 2013 2014 2013 2014 2013 Program Revenues: Charges for Services $ 5,771,078 $ 5,812,650 $ 23,681,625 $ 22,401,117 $ 29,452,703 $ 28,213,767 Operating Contributions 220,264 234,084 - - 220,264 234,084 Capital Contributions 5,756,456 1,531,740 2,809,110 1,301,235 8,565,566 2,832,975 General Revenues - Property Taxes 12,794,172 12,359,146 - - 12,794,172 12,359,146 Other Taxes 13,219,031 11,851,864 - - 13,219,031 11,851,864 Investment Earnings 43,279 54,270 31,810 53,088 75,089 107,358 Miscellaneous 180,316 505,268 609,003 419,331 789,319 924,599 Total Revenues 37,984,596 32,349,022 27,131,548 24,174,771 65,116,144 56,523,793 Expenses: General Government 6,958,530 6,913,524 - - 6,958,530 6,913,524 Public Safety 10,025,703 9,567,595 - - 10,025,703 9,567,595 Public Environment 3,740,538 3,622,834 - - 3,740,538 3,622,834 Parks and Recreation 1,807,136 1,807,559 - - 1,807,136 1,807,559 Cultural 870,159 907,676 - - 870,159 907,676 Health 407,114 344,647 - - 407,114 344,647 Administration 1,942,312 1,333,219 - - 1,942,312 1,333,219 Interest and Other Fees 2,352,856 3,340,951 - - 2,352,856 3,340,951 Water and Sewer - - 17,762,116 16,954,870 17,762,116 16,954,870 EMS - - 4,268,125 3,959,445 4,268,125 3,959,445 Total Expenses 28,104,348 27,838,005 22,030,241 20,914,315 50,134,589 48,752,320 INCREASE IN NET POSITION BEFORE TRANSFERS 9,880,248 4,511,017 5,101,307 3,260,456 14,981,555 7,771,473 Transfers (50,000) 25,140 50,000 (25,140) - - CHANGE IN NET POSITION $ 9,830248 $_4,536 157 $ 5,151,307 $ 3,235,316 $ 14,981,555 $ 7,771,473 $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 TOTAL REVENUES- GOVERNMENT -WIDE Charges for Operating Capital Grants Property Taxes Other Taxes Unrestricted Miscellaneous Services Grants and and Investment Contributions Contributions Earnings ®iota ®ZOf 12,000,000 10,000,000 8,000,000 6,000,000 4,000,000 2,000,000 TOTAL EXPENSES - GOVERNMENT -WIDE General Public Safety Public Parks and Cultural Health Interest and Government Environment Recreation Administration Other Fees Revenues- Governmental Activities (Continued) General Revenue by Source -Governmental Activities Misc< Occupancy Tay Franchise Tay M, 3% lnvestr� ^aj Earnin 0 Tay, 59% Business -Type Activities Business -Type activities accounted for 34% of the growth in the net position of the City of Schertz. Of this increase, 19% is the result of capital contributions from developers. For the most part, increases in expenses closely paralleled inflation and the change in revenues was primarily related to fluctuations in capital contributions from developers. 30,000,000 25,000,000 20,000,000 15,000,000 10,000,000 5,000,000 $20,000,000 $18,000,000 $16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 $(2,000,000) 2014 2013 Water and Sewer Utilities EMS 10 Financial Analysis of the Government's Funds As noted earlier, the City of Schertz uses fund accounting to ensure and demonstrate compliance with finance- related legal requirements. Governmental funds. The focus of the City'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, unassigned fund balance may serve as a useful measure of a government's net resources available for spending at the end of the fiscal year. As of the end of the current fiscal year, the City's governmental funds reported combined ending fund balances of $27.4 million. Of this total amount, $5.6 million constitutes unassigned fund balance, which is available for spending at the government's discretion. The remainder of fund balance is non - spendable, restricted, or assigned to indicate that it is not available for new spending because it has already been committed to pay debt service, for capital improvement projects, and other assigned purposes. The general fund is the chief operating fund of the City of Schertz. At the end of the current fiscal year, unassigned fund balance of the general fund was $5.6 million, while total fund balance was $7.7 million, an increase of $1.7 million from the prior year. As a measure of the general fund's liquidity, it may be useful to compare both unassigned fund balance and total fiend balance to total fund expenditures. Unassigned fund balance represents 28% of total general fund expenditures, not including capital. The debt service fund has a total fund balance of $0.6 million all of which is restricted for the payment of debt service. The net increase in fund balance during the current year in the debt service fund was $0.1 million. The capital projects fund has a total fund balance of $9.6 million, a decrease of $6.8 million. No new governmental bonds were issued this year, so the activity in the capital projects fund is primarily the expenditures of prior bond issuances. Proprietary funds. The City's proprietary funds provide the same type of information found in the government -wide financial statements, but in more detail. Unrestricted net position of the water and sewer fund at the end of the year amounted to $15.3 million and those for the Schertz EMS fund amounted to $1.1 million. General Fund Budgetary Highlights The General Fund expenditures were $1.4 million less than the $21.3 million budget. This was the result of cost savings across most of the General Fund. Revenues were higher by $0.6 million than budgeted. Overall, the fund balance increased by $1.7 million higher than budgeted. The original budget was amended during the year to increase total expenditures by less than 2 %. 11 CAPITAL ASSET AND DEBT ADMINISTRATION Capital assets. The City's investment in capital assets for its governmental and business -type activities as of September 30, 2014, amounts to $176 million (net of accumulated depreciation). Developers contributed $8.6 million in infrastructure during the year. The City also has several projects in progress from voter approved bonds. Additional information on the City's capital assets can be found in the note 6 to the basic financial statements. TABLE A -3 CAPITAL ASSETS (Net of Depreciation) Governmental Activities Business -Type Activities Total Long -Term Debt. At the end of the current fiscal year, the City of Schertz had total bonded debt outstanding of $70.9 million. During the fiscal year, the City issued $10.0 million in refunding bonds and $5.0 million certificates for water and sewer improvements. The related principal and interest payment for the bonds are backed by an annual ad valorem tax levied against all taxable property within the City. The City of Schertz maintains a "AA" rating from Standard and Poors. Additional information on the City's long -term debt can be found in note 9 to the basic financial statements. TABLE A -4 2014 2013 2014 2013 2014 2013 Land $ 7,445,117 $ 7,445,117 $ 1,267,852 $ 1,254,524 $ 8,712,969 $ 8,699,641 Water Rights - - 70,245 70,245 70,245 70,245 Buildings and Improvements 39,116,202 35,471,337 4,660,001 4,660,001 43,776,203 40,131,338 Machinery, Equipment, - 2,215,000 - 2,215,000 Tax Notes and Leases 1,585,000 2,155,000 and Vehicles 8,162,722 6,354,680 3,640,274 3,051,206 11,802,996 9,405,886 Infrastructure 87,983,067 81,758,702 77,985,687 75,176,577 165,968,754 156,935,279 Construction in Progress 4,995,655 3,161,422 1,651,694 365,904 6,647,349 3,527,326 Accumulated Depreciation (36,152,696) (32,149,182) (24,722,278) (22,793,058) (60,874,974) (54,942,240) TOTALS $ 111,550,067 $102,042,076 $ 64,553,475 $ 61,785,399 $176,103,542 $ 163,827,475 Long -Term Debt. At the end of the current fiscal year, the City of Schertz had total bonded debt outstanding of $70.9 million. During the fiscal year, the City issued $10.0 million in refunding bonds and $5.0 million certificates for water and sewer improvements. The related principal and interest payment for the bonds are backed by an annual ad valorem tax levied against all taxable property within the City. The City of Schertz maintains a "AA" rating from Standard and Poors. Additional information on the City's long -term debt can be found in note 9 to the basic financial statements. TABLE A -4 12 Governmental Business -Type Activities Activities Total 2014 2013 2014 2013 2014 2013 General Obligation Bonds $55,300,000 $58,060,000 $ 3,960,000 $ 2,120,000 $59,260,000 $60,180,000 Certificates of Obligation 543,934 801,767 9,436,066 5,048,234 9,980,000 5,850,001 Revenue Bonds - - - 2,215,000 - 2,215,000 Tax Notes and Leases 1,585,000 2,155,000 65,000 130,000 1,650,000 2,285,000 TOTALS $57,428,934 $61,016,767 $13,461,066 $ 9,513,234 $70,890,000 $70,530,001 12 Economic Factors and Next Year's Budgets and Rates At the end of the last fiscal year, the assigned and unassigned fund balance in the general fund increased to $6.3 million. The City of Schertz has not appropriated any portion of this amount for spending in the 2015 fiscal year budget. The intention is to build up the assigned and unassigned fund balance to 3 to 6 months of operating expenses. Each year the City updates its five -year budgeting forecast and has implemented a long term debt model to assist management in making informed financial decisions that will impact the community now and in the future. Requests for Information This financial report is designed to provide a general overview of the City's finances for all those with an interest in the government's finances. Questions concerning any of the information provided in this report or requests for additional financial information should be addressed to the Office of the Finance Director, City of Schertz, 1400 Schertz Parkway, Schertz, Texas 78154. 13 rr BASIC FINANCIAL STATEMENTS 14 CITY OF SCHERTZ, TEXAS STATEMENT OF NET POSITION SEPTEMBER 30, 2014 ASSETS Current Assets: Cash and Cash Equivalents Investments Receivables (net of allowances) Taxes Accounts and Other Accrued Interest Income Prepaid Expenses Inventories Internal Balances Total Current Assets Noncurrent Assets: Restricted Assets: Cash and Cash Equivalents Investments Capital Assets: Land Water Rights Buildings and Improvements Equipment and Vehicles Infrastructure Construction in Progress Accumulated Depreciation Total Noncurrent Assets TOTAL ASSETS DEFERRED OUTFLOWS OF RESOURCES Deferred Loss on Debt Refundings TOTAL DEFERRED OUTFLOWS OF RESOURCES Primary Government Governmental Business -Type Activities Activities Total $ 2,992,700 25,054,620 2,399,734 1,987,983 1,888 21,735 88,518 (91 4,931) 31,632,247 425,864 7,445,117 39,1.1.6,202 8,1.62,722 87,983,067 4,995,655 (36,152,696) 111,975,931 143,608,178 $ 1,987,332 2,742,995 4,486,025 3,1.1.4 1,950 124,1.83 91.4,931 10,260,530 2,065,094 10,068,053 1,267,852 70,245 4,660,001 3,640,274 77,985,687 1,651,694 (24,722,278) 76,686,622 86,947,152 $ 4,980,032 27,797,615 2,399,734 6,474,008 5,002 23,685 212,701 41,892,777 2,490,958 1.0,068,053 8,712,969 70,245 43,776,203 1.1,802,996 165,968,754 6,647,349 (60,874,974) 188,662,553 230,555,330 969,012 146,807 1,115,819 $ 969,012 See Accompanying notes to basic financial statements. 15 $ 146,807 $ 1,115,819 CITY OF SCHERTZ, TEXAS STATEMENT OF NET POSITION (CONTINUED) SEPTEMBER 30, 2014 Noncurrent Liabilities: Compensated Absences 693,439 Primary Government 886,783 Net Other Post - Employment Benefit Payable Governmental Business -Type 364,906 Long -Term Debt Activities Activities Total LIABILITIES 55,747,628 1.2,956,604 68,704,232 Current Liabilities: TOTAL LIABILITIES 62,769,552 Accounts Payable $ 1,753,083 $ 1,729,321 $ 3,482,404 Accrued Liabilities 476,859 157,840 634,699 Due to Other Governments 205,303 - 205,303 Unearned Revenue 28,284 305,651 333,935 Accrued Interest Payable 377,209 68,004 445,213 Compensated Absences 173,360 48,336 221,696 Customer Deposits 42,513 486,814 529,327 Current Portion of Long -Term Debt 3,965,313 1,215,964 5,181,277 Total Current Liabilities 7,021,924 4,011,930 11,033,854 Noncurrent Liabilities: Compensated Absences 693,439 193,344 886,783 Net Other Post - Employment Benefit Payable 279,765 85,141 364,906 Long -Term Debt 54,774,424 1.2,678,119 67,452,543 Total Noncurrent Liabilities 55,747,628 1.2,956,604 68,704,232 TOTAL LIABILITIES 62,769,552 16,968,534 79,738,086 NET POSITION Net Investment In Capital Assets 62,792,671 53,674,437 116,467,108 Restricted For: Police and Municipal Court 1,157,723 - 1,157,723 PEG Capital Fees 489,509 - 489,509 Tourism Development 501,996 - 501,996 Economic Development 7,193,388 - 7,193,388 Parks and Tree Mitigation 663,860 - 663,860 Debt Service 317,1.54 - 317,1.54 Other Purposes 78,098 - 78,098 Unrestricted 8,613,239 16,450,988 25,064,227 TOTAL NET POSITION $ 81,807,638 $ 70,125,425 $ 1.51,933,063 See Accompanying notes to basic financial statements. 16 CITY OF SCHERTZ, TEXAS STATEMENT OF ACTIVITIES FOR THE YEAR ENDED SEPTEMBER 30, 2014 Functions and Programs Expenses Primary Government: Governmental Activities: General Government Public Safety Public Environment Parks and Recreation Cultural Health Administration Interest Total Governmental Activities Business -Type Activities Water and Sewer EMS Total Business -Type Activities Total Primary Government General Revenues: Taxes: Ad Valorem Sales Franchise Fees Hotel /Motel Mixed Drink Investment Earnings Miscellaneous Total General Revenues Transfers Change in Net Position Net Position at Beginning of Year Net Position at End of Year Program Revenues Operating Capital Charges for Grants and Grants and Services Contributions Contributions $ 6,958,530 $ 1,974,637 $ 6,725 $ 5,749,198 10,025,703 2,536,476 28,705 4,863 3,740,538 - - - 1,807,136 917,639 163,799 - 870,159 309,897 7,467 - 407,1.14 32,429 13,568 2,395 1,942,312 - - - 2,352,856 - - - 28,104,348 5,771,078 220,264 5,756,456 17,762,116 19,147,872 - 2,809,110 4,268,125 4,533,753 - - 22,030,241 23,681,625 - 2,809,110 $ 50,134,589 $ 29,452,703 $ 220,264 $ 8,565,566 See Accompanying notes to basic financial statements. 17 Net (Expense) Revenue and Changes in Net Position Primary Government Governmental Business -Type Activities Activities Total $ 772,030 (7,455,659) (3,740,538) (725,698) (552,795) (358,722) (1,942,312) (2,352,856) (16,356,550) $ 4,194,866 265,628 4,460,494 $ 772,030 (7,455,659) (3,740,538) (725,698) (552,795) (358,722) (1,942,312) (2,352,856) (16,356,550) 4,194,866 265,628 4,460,494 (16,356,550) 4,460,494 (11,896,056) 12,794,172 - 12,794,172 10,553,382 - 10,553,382 2,073,162 - 2,073,162 552,570 - 552,570 39,917 - 39,917 43,279 31,810 75,089 180,316 609,003 789,319 26,236,798 640,813 26,877,611 (50,000) 50,000 - 9,830,248 5,1.51,307 14,981,555 71,977,390 64,974,118 136,951,508 $ 81,807,638 $ 70,125,425 $ 151,933,063 18 CITY OF SCHERTZ, TEXAS BALANCE SHEET — GOVERNMENTAL FUNDS SEPTEMBER 30, 2014 Assigned for: Property Replacement 694,916 - Special Events 31,177 - Unassigned 5,587,262 - - Total Fund Balances 7,722,034 9,631,746 625,435 TOTAL LIABILITIES, DEFERRED INFLOWS OF RESOURCES AND FUND BALANCES $ 11,865,702 $ 10,877,234 $ 728,105 See Accompanying notes to basic financial statements. 19 General Capital Debt Fund Projects Service ASSETS Cash and Cash Equivalents $ 734,684 $ 1,084,721 $ 34,988 Investments 6,895,148 9,792,513 624,189 Receivables (net of allowances) Taxes 1,725,512 - 68,928 Accounts and Other 1,987,843 - Inventory 88,518 - Prepaid Items 8,133 - Restricted Assets: Cash and Cash Equivalents 425,864 - - TOTAL ASSETS $ 11,865,702 $ 10,877,234 $ 728,105 LIABILITIES, DEFERRED INFLOWS OF RESOURCES AND FUND BALANCES Liabilities: Accounts Payable $ 1,241,009 $ 469,483 $ - Accrued Salaries and Benefits 456,962 - - Accrued Interest - 33,742 Customer Deposits 42,513 - Due to Other Governments 205,303 - - Due to Other Funds 138,926 776,005 - Unearned Revenues 28,285 - - Total Liabilities 2,112,998 1,245,488 33,742 Deferred Inflows of Resources: Unavailable Revenues 2,030,670 - 68,928 Fund Balances: Nonspendable: Inventory 88,518 - Prepaid Items 8,133 - Restricted for: Police and Public Safety 139,884 - Municipal Court 628,459 - PEG Capital Fees 489,509 - Capital Improvement - 9,600,028 - Debt Service - 625,435 Tourism Development - Parks and Tree Mitigation - Historical Committee and Library - Economic Development - - Scholarships 54,176 - - Committed for Capital Improvements - 31,718 - Assigned for: Property Replacement 694,916 - Special Events 31,177 - Unassigned 5,587,262 - - Total Fund Balances 7,722,034 9,631,746 625,435 TOTAL LIABILITIES, DEFERRED INFLOWS OF RESOURCES AND FUND BALANCES $ 11,865,702 $ 10,877,234 $ 728,105 See Accompanying notes to basic financial statements. 19 Economic Nonmajor Total Development Governmental Governmental Corporation Funds Funds $ 293,205 $ 845,103 $ 2,992,701 6,961,045 781,725 25,054,620 567,202 38,093 2,399,735 1,888 140 1,989,871 - - 88,518 - 13,602 21,735 - - 425,864 $ 7,823,340 $ 1,678,663 $ 32,973,044 $ 9,658 $ 31,727 $ 1,751,877 21,104 - 478,066 - 33,742 - 42,513 205,303 914,931 - - 28,285 30,762 31,727 3,454,717 2,099,598 88,518 13,602 21,735 - 389,380 529,264 - - 628,459 - 489,509 - 9,600,028 - - 625,435 - 501,996 501,996 - 663,860 663,860 - 78,098 78,098 7,792,578 - 7,792,578 - 54,176 - 31,718 - 694,916 - 31,177 - - 5,587,262 7,792,578 1,646,936 27,418,729 $ 7,823,340 $ 1,678,663 $ 32,973,044 20 rr CITY OF SCHERTZ, TEXAS RECONCILIATION OF BALANCE SHEET SEPTEMBER 30, 2014 TOTAL FUND BALANCE - TOTAL GOVERNMENTAL FUNDS Amounts reported for governmental activities in the Statement of Net Position are different because: Capital Assets used in governmental activities are not financial resources and, therefore, are not reported in the funds. Other long -term assets are not available to pay for current - period expenditures and, therefore, are not recognized as revenue in the funds. The governmental funds report other post- employement benefit contributions as expenditures when they become due and payable. However, in the statement of activities differences between other post - employment benefit contributions and actuarially determined costs are reported as an obligation. Long -term liabilities, including bonds payable and capital leases, are not due and payable in the current period and therefore, not reported in the funds: Bonds Payable Unamortized Premiums, Discounts, Losses on Refundings Capital Lease Payable Accrued Interest Payable Compensated Absences TOTAL NET POSITION - GOVERNMENTAL ACTIVITIES See accompanying notes to basic financial statements. 21 $ 27,418,729 111,550,067 2,099,598 (279,765) (57,428,934) (218,421) (123,370) (343,467) (866,799) (58,980,991) $ 81,807,638 CITY OF SCHERTZ, TEXAS STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES — GOVERNMENTAL FUNDS FOR THE YEAR ENDED SEPTEMBER 30, 2014 EXPENDITURES Current: General Government 5,232,687 46,542 Debt Public Safety General Capital Service Public Environment Fund Projects Fund REVENUES 1,100,971 - - Taxes $ 16,652,245 $ - $ 5,295,577 Permits and Fees 1,365,624 - - Service Fees 1,592,851 - - Fines and Fees 1 ,712,562 - - Intergovernmental 218,081 3,688 - Investment Earnings 13,657 17,429 1,477 Miscellaneous 547,515 - - TOTAL REVENUES 22,102,535 21,117 5,297,054 EXPENDITURES Current: General Government 5,232,687 46,542 - Public Safety 9,398,845 - - Public Environment 1,012,607 - - Parks and Recreation 1,100,971 - - Cultural 794,434 - - Health 394,918 - - Administration 1,604,825 - - Capital Outlay 383,264 7,530,597 - Debt Service: Net Change in Fund Balance 1,704,828 Principal 32,764 - 3,262,833 Interest and Fiscal Charges 579 - 2,080,360 Bond Issue Costs - - 165,650 TOTAL EXPENDITURES 1.9,955,894 7,577,139 5,508,843 Excess (Deficiency) of Revenues Over (Under) Expenditures 2,146,641 (7,556,022) (211,789) OTHER FINANCING SOURCES (USES) Proceeds from Issuance of Debt - - 8,450,000 Premiums from Issuance of Debt - - 686,137 Proceeds from Capital Lease 133,715 - - Payments to Refunding Escrow Agent - - (9,182,250) Transfers In 89,416 762,358 366,138 Transfers Out (664,944) - - TOTAL OTHER FINANCING SOURCES (USES) (441,81.3) 762,358 320,025 Net Change in Fund Balance 1,704,828 (6,793,664) 108,236 Fund Balances at Beginning of Year 6,017,206 16,425,410 517,199 Fund Balances at End of Year $ 7,722,034 $ 9,631,746 $ 625,435 See accompanying notes to basic financial statements. 22 Economic Development Corporation Other Nonmaj or Governmental Funds Total Governmental Funds $ 3,521,338 $ 552,570 $ 26,021,730 - 439,423 1,805,047 - 171,113 1,763,964 - 37,749 1,750,311. - - 221,769 9,599 853 43,015 - 81,201 628,716 3,530,937 1,282,909 32,234,552 565,322 136,888 5,981,439 - 11,049 9,409,894 - - 1,012,607 - 237,261 1,338,232 - 21,257 815,691 - - 394,918 519,831 145,385 2,270,041 - 86,606 8,000,467 400,000 - 3,695,597 27,671 - 2,108,610 - - 165,650 1,512,824 638,446 35,193,146 2,018,113 644,463 (2,958,594) - - 8,450,000 - - 686,137 - - 133,715 - - (9,182,250) - 25,921 1,243,833 (367,743) (261,145) (1,293,832) (367,743) (235,224) 37,603 1,650,370 409,239 (2,920,991) 6,142,208 1,237,697 30,339,720 $ 7,792,578 $ 1,646,936 $ 27,418,729 23 rr CITY OF SCHERTZ, TEXAS RECONCILIATION OF THE STATEMENT OF REVENUES, GOVERNMENTAL FUNDS TO THE STATEMENT OF ACTIVITIES FOR THE YEAR ENDED SEPTEMBER 30, 2014 NET CHANGE IN FUND BALANCES - GOVERNMENTAL FUNDS Amounts reported for governmental activities in the Statement of Activities are different because: 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. In addition, capital assets contributed to governmental activities are not recorded on the fund statements. Capital Outlay 7,968,458 Capital Contributions 5,749,198 Depreciation Expense (4,209,665) 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, which the repayment of the principal of long -term debt consumes the current financial reourees of governmental funds. Neither transaction, however, has any affect on net position. This amount is the net effect of these differences in the treatment of long -term debt and related items. Proceeds from the Issuance of Debt (8,450,000) Premiums Received from the Issuance of Debt (686,137) Proceeds from Capital Leases (133,715) Payment to Refunding Escrow Agent 9,182,250 Principal Repayments 3,695,597 Amortization of Premiums, Discounts, Losses (81406) 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: Compensated Absences Net Other Postemployment Benefits Accrued Interest CHANGE IN NET POSITION - GOVERNMENTAL ACTIVITIES See accompanying notes to basic financial statements. 24 (7,231) (279,765) (70,193) $ (2,920,991) 9,507,991 848 3,599,589 (357,189) $ 9,830,248 CITY OF SCHERTZ, TEXAS STATEMENT OF NET POSITION - PROPRIETARY FUNDS SEPTEMBER 30, 2014 ASSETS Current Assets: Cash and Cash Equivalents Investments Accounts Receivable, Net of Allowance: Customer Accounts Due from Other Funds Accrued Interest Prepaid Expenses Inventory Total Current Assets Noncurrent Assets: Restricted Assets: Cash and Cash Equivalents Investments Capital Assets: Land Water Rights Buildings and Improvements Machinery, Equipment, and Vehicles Infrastructure Construction in Progress Less: Accumulated Depreciation Total Noncurrent Assets TOTAL ASSETS Business -Type Activities - Enterprise Funds Water and Sewer Schertz System EMS Total $ 1,693,211 $ 294,121 $ 1,987,332 2,742,995 - 2,742,995 3,101,633 1,384,392 4,486,025 933,250 - 933,250 3,114 - 3,114 - 1,950 1,950 40,890 83,293 124,183 8,515,093 1,763,756 10,278, 849 2,065,094 - 2,065,094 10,068,053 - 10,068,053 1,267,852 - 1,267,852 70,245 - 70,245 4,653,501 6,500 4,660,001 1,917,786 1,722,488 3,640,274 77,985,687 - 77,985,687 1,651,694 - 1,651,694 (23,576,447) (1,145,831) (24,722,278) 76,103,465 583,157 76,686,622 84,618,558 2,346,913 86,965,471 Governmental Activities Internal Service Fund DEFERRED OUTFLOWS OF RESOURCES Deferred Loss on Refunding 146,807 - 146,807 - TOTAL DEFERRED OUTFLOWS $ 146,807 $ - $ 146,807 $ - See accompanying notes to basic financial statements. 25 CITY OF SCHERTZ, TEXAS STATEMENT OF NET POSITION - PROPRIETARY FUNDS (CONTINUED) SEPTEMBER 30, 2014 LIABILITIES Current Liabilities: Accounts Payable Accrued Liabilities Customer Deposits Accrued Interest Payable Due to Other Funds Unearned Revenue Current Portion of Compensated Absences Current Portion of Long -Term Debt Total Current Liabilities Noncurrent Liabilities: Compensated Absences Net Other Post- Employment Benefit Payable Long -Term Debt (Net of Current Portion) Total Noncurrent Liabilities TOTAL LIABILITIES NET POSITION Net Investment in Capital Assets Unrestricted TOTAL NET POSITION Business -Type Activities - Enterprise Funds Water and Sewer Schertz System EMS Total Governmental A,.,.,. mtemat Service Fund $ 1,427,474 $ 301,847 $ 1,729,321 $ - 55,203 102,637 157,840 - 486,814 - 486,814 - 67,282 722 68,004 - - 18,31.9 1.8,319 - 305,651 - 305,651 - 18,198 30,1.38 48,336 - 1,049,756 166,208 1,215,964 - 3,410,378 619,871 4,030,249 - 72,791 120,553 193,344 - 34,800 50,341 85,141 - 12,411,316 266,803 12,678,119 - 1.2,518,907 437,697 12,956,604 - 15,929,285 1,057,568 16,986,853 - 53,524,290 150,1.47 53,674,437 - 1.5,311,790 1,139,198 16,450,988 - $ 68,836,080 $ 1,289,345 $ 70,125,425 $ - See accompanying notes to basic financial statements. 26 CITY OF SCHERTZ, TEXAS STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN FUND NET POSITION PROPRIETARY FUNDS FOR THE YEAR ENDED SEPTEMBER 30, 2014 OPERATING REVENUES Fees Charged to Users Charges for Premiums Other Charges TOTAL OPERATING REVENUES OPERATING EXPENSES Personnel Services Contribution to Joint Ventures Water Purchase Garbage Contractor Sewage Treatment General and Administrative Contractual Services Supplies and Maintenance Depreciation TOTAL OPERATING EXPENSES OPERATING INCOME (LOSS) NONOPERATING REVENUES (EXPENSES) Investment Earnings Lease Income Miscellaneous Interest Expense Amortization and Bond Issue Costs TOTAL NONOPERATING REVENUES (EXPENSES) INCOME BEFORE CONTRIBUTIONS AND TRANSFERS Transfers In (Out) Capital Contributions Governmental Business -Type Activities - Enterprise Funds Activities Water Internal and Sewer Schertz Service System EMS Total Fund $ 19,110,332 $ 4,533,753 $ 23,644,085 $ - - - - 1,993,559 37,540 - 37,540 - 19,147,872 4,533,753 23,681,625 1,993,559 1,996,505 3,055,528 5,052,033 1,993,559 1,572,074 - 1,572,074 - 2,890,719 - 2,890,719 - 3,736,380 - 3,736,380 - 2,621,480 - 2,621,480 - 2,040,834 432,283 2,473,117 - 125,663 125,877 251,540 - 262,998 443,306 706,304 - 1,939,379 204,325 2,143,704 - 17,186,032 4,261,319 21,447,351 1,993,559 1,961,840 272,434 2,234,274 - 31,735 75 31,810 - 202,984 - 202,984 - 297,722 108,297 406,019 - (427,018) (6,806) (433,824) - (149,066) - (149,066) - (43,643) 101,566 57,923 - 1,918,197 374,000 2,292,197 - 50,000 - 50,000 - 2,809,110 - 2,809,110 - CHANGE IN NET POSITION 4,777,307 374,000 5,151,307 - NET POSITION AT BEGINNING OF YEAR 64,058,773 915,345 64,974,118 - NET POSITION AT END OF YEAR $ 68,836,080 $ 1,289,345 $ 70,125,425 $ - See accompanying notes to basic financial statements. 27 CITY OF SCHERTZ, TEXAS STATEMENT OF CASH FLOWS - PROPRIETARY FUNDS FOR THE YEAR ENDED SEPTEMBER 30, 2014 Cash Flows From Operating Activities: Cash Received From Customers and Users Cash Received from Interfund Services Cash Paid to Employees for Services Cash Paid to Supplier for Goods & Services Net Cash Provided (Used) by Operating Activities Cash Flows From Noncapital Financing Activities: Cash Advances From /(To) Other Funds Net Cash Provided (Used) by Noncapital Financing Activities Cash Flows From Capital and Related Financing Activities: Acquisition and Construction of Capital Assets Interest Paid on Long -Term Debt Transfers from Other Funds for Projects Proceeds from Bonds Issued Premiums from Bonds Issued Bond Issuance Costs Paid Payment to Refunding Escrow Agent Principal Paid on Long -Term Debt Net Cash Provided (Used) by Capital and Related Financing Activities Cash Flows From Investing Activities: Purchase of Investments Payments from Leases Interest and Investment Earnings Net Cash Provided (Used) by Investing Activities Net Increase (Decrease) in Cash and Cash Equivalents Cash and Cash Equivalents at Beginning of Year: Cash and Cash Equivalents Restricted Cash and Cash Equivalents Cash and Cash Equivalents at End of Year: Cash and Cash Equivalents Restricted Cash and Cash Equivalents See accompanying notes to basic financial statements. Business -Type Activities - Enterprise Funds Water and Sewer Schertz System EMS Total Governmental 111 LG1 nai Service Fund $ 18,413,100 $ 4,648,155 $ 23,061,255 $ - - - - 1,993,559 (1,937,683) (2,959,582) (4,897,265) (1,993,559) (12,981,530) (1,045,269) (14,026,799) - 3,493,887 643,304 4,137,191 (227,564) (198,970) (426,534) (227,564) (198,970) (426,534) (1,734,647) - (1,734,647) (412,213) (7,259) (419,472) 50,000 - 50,000 7,125,000 - 7,125,000 131,725 - 131,725 (157,037) - (157,037) (2,113,216) - (2,113,216) (1,010,500) (143,029) (1,153,529) 1,879,112 (150,288) 1,728,824 (3,560,139) - (3,560,139) 202,984 - 202,984 31,723 75 31,798 (3,325,432) 75 (3,325,357) 1,820,003 294,121 2,114,124 1,152,953 - 1,152,953 785,349 - 785,349 1,938,302 - 1,938,302 1,693,211 294,121 1,987,332 - 2,065,094 - 2,065,094 - $ 3,758,305 $ 294,121 $ 4,052,426 $ - 28 CITY OF SCHERTZ, TEXAS STATEMENT OF CASH FLOWS - PROPRIETARY FUNDS (CONTINUED) FOR THE YEAR ENDED SEPTEMBER 30, 2014 Reconciliation of Operating Income to Net Cash Provided (Used) by Operating Activities: Operating Income Revenues from Other Sources Adjustments to Reconcile Operating Income (Loss) to Net Cash Provided (Used) by Operating Activities: Depreciation Decrease (Increase) in Assets: Accounts Receivable (net) Prepaid Expenses Inventory Increase (Decrease) in Liabilities: Accounts Payable Accrued Liabilities Customer Deposits Unearned Revenue Compensated Absences Net Other Post- employment Benefit Payable Net Cash Provided (Used) by Operating Activities Noneash Capital and Related Financing Transactions: Developer Contributions of Capital Assets Contribution of Capital Asset from General Fund Assets Purchased through Capital Lease See accompanying notes to basic financial statements. Governmental Business -Type Activities - Enterprise Funds Water and Sewer Schertz System EMS Total $ 1,961,840 $ 272,434 $ 2,234,274 $ 297,722 108,297 406,019 ui M 1 uai Service Fund 29 1,939,379 204,325 2,143,704 - (1,187,651) 6,105 (1,181,546) - 36,005 (31,803) 4,202 - 232,613 (12,000) 220,613 - 19,735 34,482 54,217 - (13,674) - (13,674) - 168,831 - 168,831 - 4,287 11,123 15,410 - 34,800 50,341 85,141 - $ 3,493,887 $ 643,304 $ 4,137,191 $ - $ 2,809,110 $ - $ - $ - $ 20,319 $ - $ - $ - $ - $ 347,705 $ - $ - 29 NOTES TO BASIC FINANCIAL STATEMENTS 30 CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS SEPTEMBER 30, 2014 NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES The City of Schertz is a municipal corporation governed by an elected mayor and five- member council. The financial statements of the City have been prepared in conformity with generally accepted accounting principles (GAAP) as applied to government units. The Governmental Accounting Standards Board (GASB) is the accepted standard setting body for establishing governmental accounting and financial reporting principles. The more significant of the City's accounting policies are described below: A. Reporting Entity Component Units - 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; thus, data from these units are be combined with data of the primary government. Discretely presented component units, on the other hand, are reported in a separate column in the government -wide financial statements to emphasize it is legally separate from the government. The City reports the following blended component units: Schertz Economic Development Corporation - The Corporation was organized for the purpose of promoting economic development in order to eliminate unemployment and underemployment and to promote and encourage employment and public welfare of, for, and on behalf of the City. The board of directors consists of seven (7) members appointed by the city council. The City is financially accountable for the Corporation because the city council approves the Corporation's budget. Complete financial statements for the Schertz Economic Development Corporation may be obtained from City Hall. 2. Parks and Recreation Foundation — The Corporation was organized to improve and expand the community parks, trails, venues, and recreational programs providing fun leisure and healthy activities. The Foundation's governing board is comprised of Schertz residents and employees of the City, the accounting records are maintained by the finance department, cash is held by the City, and the City provides financing for the Foundation. In addition, the City includes the Foundation as part of the City budget process. The City and its citizens are the sole beneficiaries of the Foundation. Separate financials are not issued for the Parks and Recreation Foundation. Joint Ventures - A joint venture is a legally separate entity that results from a contractual arrangement and that is owned, operated, or governed by two or more participating governments. The following entities meet the criteria as joint ventures. Separate financial statements for these entities may be obtained at City Hall. Schertz /Seguin. Local Government Corporation - is a public, nonprofit corporation organized to aid, assist, and act on behalf of the cities of Schertz and Seguin in acquiring, constructing, maintaining, and operating a water utility system. The participating governments have an ongoing financial responsibility to fund the operation of the corporation through either purchase of services or by subsidizing the operations. 2. Cibolo Valley Local Government Corporation — is a public, nonprofit corporation organized July 28, 2011 to aid, assist, and act on behalf of the cities of Cibolo, Converse and Schertz in acquiring, constructing, maintaining, and operating a water utility system. The participating governments have an ongoing financial responsibility to fund the operation of the corporation through either purchase of services or by subsidizing the operations. 31 CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) Cibolo Creek Municipal Authority ( CCMA) — was created in 1971 and provides regional wastewater services to the area northeast of San Antonio. The City and CCMC entered into a joint project to develop a new treatment facility that will currently only serve the City. The project will have excess capacity to serve other users in the future. The City is solely responsible for funding the project until other users need capacity. B. Government -Wide and Fund Financial Statements The government -wide financial statements (i.e., the statement of net position and the statement of activities) report information on all of the 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 revenues, are reported separately from business -type activities, which rely to a significant extent on fees and charges for support. The statement of activities demonstrates the degree to which the direct expenses of a given function or segment is offset by program revenues. Direct expenses are those that are clearly identifiable with a specific function or segment. Program revenues include 1) charges of 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 revenues are reported instead as general revenues. Separate financial statements are provided for governmental funds and proprietary funds. Major individual governmental fiends and major individual enterprise funds are reported as separate columns in the fund financial statements. 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 fiend financial statements. Revenues are recorded when earned and expenses are recorded when a liability is incurred, regardless of the timing of related cash flows. Property taxes are recognized as revenues in the year for which they are levied. Grants and similar items are recognized as revenue as soon as all eligibility requirements imposed by the provider have been met. Governmental fund financial statements are reported using the current financial resources measurement focus and the modified accrual basis of accounting. Revenues are recognized as soon as they are both measurable and available. Revenues are considered to be available when they are collectible within the current period or soon thereafter to pay liabilities of the current period. For this purpose, the City considers revenues to be available if they are collected within 60 days of the end of the current fiscal period. Nonexchange revenues that are measurable but not available are recorded as unavailable revenue (a deferred inflow of resources). These revenues are generally property taxes and warrants outstanding. Expenditures generally are recorded when a liability is incurred, as under accrual accounting. However, debt service expenditures, as well as expenditures related to compensated absences and claims and judgments, are recorded only when payment is due. Exchange revenues (payments for services) received in advance of the service being provided are recorded as unearned revenue. 32 CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) C. Measurement Focus, Basis of Accounting, and Financial Statement Presentation (Continued) The City reports the following major governmental funds: The General Fund is the City's primary operating fund which accounts for all financial resources of the general government, except those required to be accounted for in another fund. The Debt Service Fund accounts for the resources accumulated and payments made for principal and interest on long -term general obligation debt of governmental funds. The Capital Proiects Fund accounts for financial resources to be used for the acquisition and construction of major capital facilities and is principally financed by the sale of bonds or certificates of obligation and grants. Economic Development Corporation collects sales taxes to support business development and expansion within the City. The government reports the following major proprietary funds: The Water and Sewer System Fund accounts for the water and sewer services provided to the citizens through user charges. The EMS Fund accounts for the emergency medical services provided to the citizens of the City and other participating governments through user charges. Internal Service Fund accounts for the City's group medical insurance program. As a general rule the effect of interfund activity has been eliminated from the government -wide financial statements. Exceptions to this are charges between the City's general government function and various other functions of the City. Eliminations of these charges would distort the direct costs and program revenues reported for the various functions concerned. Amounts reported as program revenues include 1) charges to customers or applications for goods, services, or privileges provided, 2) operating grants and contributions, and 3) capital grants and contributions. General revenues include all taxes and investment earnings. 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 water and sewer enterprise fund and the EMS enterprise fund 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 revenues and expenses not meeting this definition are reported as nonoperating revenues and expenses. 33 CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) C. Measurement Focus. Basis of Accounting. and Financial Statement Presentation (Continued When both restricted and unrestricted resources are available for use, it is the City's policy to use restricted resources first, then unrestricted resources as they are needed. D. Cash and Cash Eauivalents The City's cash and cash equivalents are considered to be cash on hand and demand deposits. Cash is reported as restricted when it has restrictions on its use narrower than the purpose of the fund in which it is reported. This can result in differences in presentation between fund statements and government -wide statements. E. Investments The City is authorized to invest in (1) obligations of the United States or its agencies and instrumentalities; (2) direct obligations of the State of Texas or its agencies; (3) other obligations, the principal of and interest on which are unconditionally guaranteed or insured by the State of Texas of the United States; (4) obligations of states, agencies, counties, cities, and other political subdivisions of any state having been rated of not less than "AA" or its equivalent; (5) certificates of deposit issued by state and national banks domiciled in Texas that are guaranteed or insured by the Federal Deposit Insurance Corporation (FDIC) or its successor, or secured by obligations mentioned above; and (6) fully collateralized direct repurchase agreements having a defined termination date. In addition, the City is authorized to invest in local government investment pools. The investment pools operate in accordance with appropriate state laws and regulations and have regulatory oversight from the Texas Public Funds Investment Act Sec. 2256.0016. The fair value of the City's position in each pool is the same as the fair value of the pool shares. F. Receivables and Payables Activities between the funds that are representative of interfund loans outstanding at the end of the fiscal year are referred to 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 ". Accounts receivable are reported net of allowances for uncollectible accounts. The allowance account represents management's estimate of uncollectible accounts based upon experience and historical trends. Property taxes for the City are levied each October 1 on the taxable value as of the preceding January 1, the date a lien attaches, for all taxable real and personal property located in the City. Taxes are due by January 31 following the October 1 assessment date and become delinquent on February 1, at which time they begin accruing penalty and interest. The enforceable legal claim date for property taxes is the assessment date; therefore, the City did not record a receivable for accrual of future taxes at year end. Accordingly, no current taxes receivable are reported. Delinquent taxes have been reported in the financial statements net of the allowance for uncollectible taxes. Tax revenues are recognized as they become available. Accordingly, an amount equal to taxes not yet available has been reported as unavailable revenue (a deferred inflow of resources) at the government fund level. 34 CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) G. Inventories All inventories are valued at cost using the first -in /first -out (FIFO) method. Inventories of governmental funds are recorded as expenditures when consumed rather than when purchased. H. Restricted Assets Certain proceeds from bonds, resources set aside for their repayment, and other restrictive agreements are classified as restricted assets on the balance sheet because they are maintained in separate bank accounts and their use is limited by applicable bond covenants and/or contractual arrangements. I. Capital Assets Capital assets, which include land, buildings and improvements, machinery, equipment, vehicles, and infrastructure assets (i.e., roads, bridges, sidewalks, and similar items), are reported in the applicable governmental or business -type activities columns in the government -wide financial statements. Capital assets are defined by the City as assets with an initial, individual cost of more than $5,000 and an estimated useful life in excess of one year. When capital assets are purchased, they are capitalized and depreciated in the government -wide financial statements and the proprietary fund statements. Capital assets are recorded as expenditures of the current period in the governmental fund financial statements. Capital assets are valued at cost where historical records are available and at an estimated cost where no records exist. Donated capital assets are valued at their estimated fair market value at the date of donation. The costs of normal maintenance and repairs that do not add to the value of the asset or materially extend asset lives are not capitalized. Improvements to capital assets that materially extend the life of the asset or add to the value are capitalized. Major outlays for capital assets and improvements are capitalized as projects are constructed. Interest incurred during construction will not be capitalized in the governmental activities on the government -wide financial statements; however capitalization of interest is required for business -type activities. There was no capitalized interest during the current fiscal year. Capital assets are depreciated over their useful lives on a straight -line basis as follows: Useful Lives Assets (Years) Buildings and Improvements 10-50 Machinery, Equipment, and Vehicles 2-20 Infrastructure 15-30 J. Deferred Inflows /Outflows of Resources A deferred outflow of resources is a consumption of net position by the government that is applicable to a future reporting period while a deferred inflow of resources is an acquisition of net position. These items are presented in separate sections following assets (deferred outflows) or liabilities (deferred inflows) on the statement of net position. 35 CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) K. Compensated Absences It is the City's policy to permit employees to accumulate earned but unused vacation and compensatory time benefits. There is no liability for unpaid accumulated sick leave since the City does not have a policy to pay any amounts when employees separate from service with the City. All vacation and compensatory time pay is accrued when incurred in the government -wide and proprietary fund financial statements. A liability for these amounts is reported in governmental fiends only if they have matured, for example, as a result of employee resignations and retirements. L. Long -Term Obligations 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 position. Bond premiums, discounts, and losses on defeasance are amortized over the life of the bonds using the effective interest method. Bonds payable are reported net of the applicable bond premium or discount. Losses on defeasance are reported as deferred outflows of resources. Bond issuance costs are expensed as incurred. In the fund financial statements, governmental fund types recognize bond premiums and discounts, as well as bond issuance costs, during the current period. The face amount of debt issued is reported as other financing sources. Premiums received on debt issuances are reported as other financing sources while discounts on debt issuances are reported as other financing uses. Issuance costs, whether or not withheld from the actual debt proceeds received, are reported as debt service expenditures. M. Fund Equity Fund balances in governmental funds are classified as follows: Nonspendable — Represents amounts that cannot be spent because they are either not in spendable form (such as inventory or prepaid items) or legally required to remain intact. Restricted — Represents amounts that are constrained by external parties, constitutional provisions or enabling legislation. Committed — Represents amounts that can only be used for a specific purpose because of a formal action by the government's highest level of decision making authority: an ordinance adopted by City Council prior to the end of the fiscal year. Once adopted, the limitation imposed by the ordinance remains in place until a similar action is taken (the adoption of another ordinance) to remove or revise the limitation. Assigned — Represents amounts which the City intends to use for a specific purpose but do not meet the criteria of restricted or committed. The City Council may make assignments through formal documentation in the minutes. The City Council authorized (by way of policy) the City Manager to also make assignments. The City Manager's assignments do not require formal action; however, the City Manager has not assigned any funds at this time. Unassigned — Represents the residual balance that may be spent on any other purpose of the City. 36 CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) M. Fund Eauitv (Cont.) When an expenditure is incurred for a purpose in which multiple classifications are available, the City considers restricted balances spent first, committed second, and assigned third. N. Net Position Net position represents the difference between assets plus deferred outflows of resources less liabilities and deferred inflows of resources. Net investment in capital assets consists 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 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. Budizetary Information Annual budgets are adopted on a basis consistent with generally accepted accounting principles for all governmental funds except the library grant special revenue fund, police department forfeiture special revenue fund and the capital projects fund, which adopts project - length budgets. Q. Reclassifications Certain reclassifications have been made in the presentation of the September 30, 2014 . financial statements. All comparative information for prior periods has been reclassified to match the new presentation. The changes in presentation had no impact on the changes in net position or fund balance. 37 CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 2 - CASH, CASH EQUIVALENTS AND INVESTMENTS The City's operating deposits are held at one institution. The institution provides a combination of pledged collateral and FDIC insurance to completely collateralize the City's deposits. As of September 30, 2014, the City had the following pooled investment funds: Investment Type LOGIC Lone Star Investment Pool Texas CLASS Schertz Bank & Trust - Certificate of Deposit Capital One - U.S. Agency Securities Total Book Fair Value Value $ 6,562,212 $ 6,562,212 17,974,689 17,974,689 8,147,947 8,147,947 Weighted Average Maturity in Days 57 107 60 2,108,558 2,108,558 85 3,072,262 3,072,262 528 $ 37,865,668 $ 37,865,668 121 Interest Rate Risk. As a means of limiting its exposure to fair value losses arising from rising interest rates, the City's investment policy limits the City's investment portfolio to highly liquid investments to meet unanticipated cash requirements, and /or to redeploy cash into other investments expected to outperform current holdings. Credit Risk. State law limits investments in certificates of deposit to guaranteed or insured by the Federal Deposit Insurance Corporation, or its successor or the National Credit Union Share Insurance Fund, or its successor and investment pools continuously rated no lower than AAA or an equivalent rating by at least one nationally recognized rating service. The City's investment policy does not further limit its investment choices. As of September 30, 2014, the City's investments in the pooled investment funds were rated AAAm by Standard & Poor's. The City has also invested in debt securities provided by the Federal Home Loan Bank, Federal National Mortgage Association, Federal Home Loan Mortgage Corporation, Federal Farm Credit Banks, and U.S Treasury Notes. Custodial Credit Risk - Deposits. In the case of deposits, this is the risk that in the event of a bank failure, the government's deposits may not be returned. As of September 30, 2014, the City's cash and cash equivalents (including certificates of deposit, and component unit holdings) were fully collateralized by the City's depository by a combination of pledged collateral and FDIC insurance. All collateral is held in the City's name. Custodial Credit Risk - Investments. For an investment, this is the risk that, in the event of the failure of the counterparty, the government will not be able to recover the value of its investment or collateral securities that are in the possession of an outside party. All of the government securities owned by the City are held by its agent in the City's name. 38 CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 3 - PROPERTY TAX Taxes are levied on and payable as of October 1. The City has contracted with the Guadalupe County Tax Assessor - Collector to collect taxes on its behalf. Current taxes become delinquent February 1. Current year delinquent taxes not paid by July 1 are turned over to attorneys for collection action. The total taxable value as of October 1, 2013, upon which the fiscal 2014 levy was based, was $2,752,562,574 (i.e., market value less exemptions). The estimated market value was $3,093,310,224, making the taxable value 89% of the estimated market value. The City is permitted by the Constitution of the State of Texas to levy taxes up to $2.50 per $100 of taxable assessed valuation for all governmental purposes. Pursuant to a decision of the Attorney General of the State of Texas, up to $1.50 per $100 of assessed valuation may be used for the payment of long -term debt. The combined tax rate to finance general governmental services, including the payment of principal and interest on long -term debt for the year ended September 30, 2014, was $0.4974 per $100 of assessed value, which means that the City has a tax margin of $2.0026 for each $100 value and could increase its annual tax levy by approximately $55,122,81.8 based upon the present assessed valuation before the limit is reached. However, the City may not adopt a tax rate that exceeds the tax rate calculated in accordance with the Texas Property Tax Code without holding a public hearing. The Property Tax Code subjects an increase in the effective tax rate to a referendum election, if petitioned by registered voters, when the effective tax rate increase is more than eight percent (8 %) of the previous year's effective tax rate. Property taxes are recorded as receivables and unearned revenues at the time the taxes are assessed. In governmental funds, revenues are recognized as the related ad valorem taxes are collected. Additional amounts estimated to be collectible in the time to be a resource for payment of obligations incurred during the fiscal year and therefore susceptible to accrual in accordance with generally accepted accounting principles have been recognized as revenue. In the government -wide financial statements, the entire levy is recognized as revenue, net of estimated uncollectible amounts (if any), at the levy date. NOTE 4 - RECEIVABLES Receivables as September 30, 2014 for the government's individual major fiends and nonmajor funds in the aggregate, including the applicable allowances for uncollectible accounts, are as follows: Receivables: Property Taxes Sales Taxes Occupancy Taxes Franchise Taxes Customers Court Fines Grants Other Gross Receivables Less: Allowance for Uncollectibles Net Total Receivables 39 Governmental Funds Proprietary Funds Capital Economic Debt Nonmajor Water and Schertz General Projects Development Service Funds Sewer Fund EMS $ 125,772 $ - $ - $ 73,328 1,134,403 - 567,202 - - - - - - 38,093 472,883 - - - - - 50,398 - - - - 3,171,852 15,248,204 4,698,881 - - - - - - 25,000 46,542 1,888 - 140 - 5,301 6,507,337 46,542 569,090 73,328 38,233 3,171,852 15,253,505 2,793,982 46,542 - 4,400 - 70,219 13,869,113 —Lill $ _J_169 090 _J__68 ,928 38,233 3,101,633 $ 1,384,392 39 CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 4 — RECEIVABLES (Continued) Governmental funds report unavailable 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 unearned/ unavailable revenue and unavailable revenue reported in the governmental funds were as follows: Unavailable General Fund Delinquent Property Taxes Receivable $ 118,225 Court Fines 1,912,445 Total General Fund 2,030,670 Debt Service Fund Delinquent Property Taxes Receivable 68,928 Total Debt Service Fund 68,928 Total Governmental Funds $ 2,099,598 NOTE 5 - INTERFUND BALANCES AND TRANSFERS The composition of interfund balances as of September 30, 2014 is as follows: Due From Due To EMS Water & Sewer Capital Projects Water & Sewer General Fund Water & Sewer Amount Purpose $ 18,319 Structured loan between funds 776,005 Portion of bond proceeds for water projects 138,926 Property tax collections for TIRZ The following schedule briefly summarizes the City's transfer activity for the year ending September 30, 2014: Transfer From Transfer To Amount Purpose Nonmajor Governmental General $ 89,416 Hotel tax support of special events General Nonmajor Governmental 2,421 Supplement historical committee Nonmajor Governmental Nonmajor Governmental 23,500 Hotel tax support of parks and recreation Economic Development Debt Service 366,138 Pledge in support of debt service General Capital Projects 612,523 Supplement capital projects funding Nonmajor Governmental Capital Projects 148,229 Supplement capital projects funding General Water & Sewer 50,000 Supplement capital projects funding Economic Development Capital Projects 1,605 Supplement capital projects funding .m CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 6 - CAPITAL ASSETS Capital asset activity for the year ended September 30, 2014 was as follows: Accumulated Depreciation Buildings and Improvements Beginning (975,237) 63,182 97,571 Ending Machinery, Equipment, and Vehicles Balance Increases Deletions Transfers Balance Governmental Activities: (20,320,934) (2,708,664) - (97,571) (23,127,169) Capital Assets, Not Being Depreciated: (32,149,182) (4,209,665) 185,832 20,319 (36,152,696) Land $ 7,445,117 $ $ $ $ 7,445,117 Construction in Progress 3,161,422 6,835,613 $ (5,001,380) 4,995,655 Total Capital Assets Not Being Depreciated 10,606,539 6,835,613 (5,001,380) 12,440,772 Capital Assets, Being Depreciated: Balance Increases Deletions Transfers Balance Buildings and Improvements 35,471,337 - (63,182) 3,708,047 39,116,202 Machinery, Equipment, and Vehicles 6,354,680 1,132,844 (122,650) 797,848 8,162,722 Streets and Infrastructure 81,758,702 5,749,199 $ - 475,166 87,983,067 Total Capital Assets Being Depreciated 123,584,719 6,882,043 (185,832) 4,981,061 135,261,991 Accumulated Depreciation Buildings and Improvements (7,706,131) (975,237) 63,182 97,571 (8,520,615) Machinery, Equipment, and Vehicles (4,122,117) (525,764) 122,650 20,319 (4,504,912) Streets and Infrastructure (20,320,934) (2,708,664) - (97,571) (23,127,169) Total Accumulated Depreciation (32,149,182) (4,209,665) 185,832 20,319 (36,152,696) Total Capital Assets Being Depreciated, Net 91,435,537 2,672,378 - 5,001,380 99,109,295 Governmental Activities Capital Assets, Net $ 102,042,076 $ 9,507,991 $ $ - $ 111,550,067 Beginning Ending Balance Increases Deletions Transfers Balance Business -Type Activities: Capital Assets, Not Being Depreciated. Land $ 1,254,524 $ 13,328 $ - $ $ 1,267,852 Water Rights 70,245 - - 70,245 Construction in Progress 365,904 1,285,790 - 1,651,694 Total Assets Not Being Depreciated 1,690,673 1,299,118 - 2,989,791 Capital Assets, Being Depreciated: Buildings and Improvements 79,836,578 2,809,110 - (77,985,687) 4,660,001 Machinery, Equipment, and Vehicles 3,051,206 803,552 (234,803) 20,319 3,640,274 Infrastructure - - - 77,985,687 77,985,687 Total Capital Assets Being Depreciated 82,887,784 3,612,662 (234,803) 20,319 86,285,962 Accumulated Depreciation: Buildings and Improvements (20,604,422) (263,759) - - (20,868,181) Machinery, Equipment, and Vehicles (2,188,636) (334,358) 234,803 (20,319) (2,308,510) Infrastructure - (1,545,587) - (1,545,587) Total Accumulated Depreciation (22,793,058) (2,143,704) 234,803 (20,319) (24,722,278) Total Capital Assets Being Depreciated, Net 60,094,726 1,468,958 - 61,563,684 Business -Type Activities Capital Assets, Net $ 61,785,399 $ 2,768,076 $ - $ $ 64,553,475 41 CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 6 - CAPITAL ASSETS (Continued) Depreciation expense was charged to functions /programs of the primary government as follows: Governmental Activities: General Government $ 666,390 Public Safety 425,911 Public Environment 2,713,900 Parks and Recreation 318,140 Cultural 61,623 Health 5,953 Administration 17,748 Total Depreciation Expense - Governmental Activities $ 4,209,665 Business -Type Activities: Water and Sewer System $ 1,939,379 EMS 204,325 Total Depreciation Expense - Business Type Activities $ 2,143,704 NOTE 7 - OPERATING LEASE The City has agreements with several telecommunication companies to place cellular towers on City water towers. The following schedule represents the future minimum lease payments. Fiscal Year Ending September 30, Total 2015 $ 211,812 2016 220,285 2017 229,096 2018 238,260 2019 250,173 $ 1,149,626 NOTE 8 - CAPITAL LEASE In 2014, the City entered into two lease agreements qualifying as capital leases for accounting purposes based on a bargain purchase option. Therefore, capital assets and a related capital lease obligation has been recorded at the present value of the future minimum lease payments at the inception date. The assets acquired through capital lease are reported in capital assets with the following accumulated depreciation at September 30, 2014: Assets: Equipment Less Accumulated Depreciation Total 42 Governmental Business -type Activities Activities $ 133,715 $ 133,715 $ 347,705 (46,361) $ 301,344 CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 8 - CAPITAL LEASE (Continued) Future minimum lease payments are as follows: Year Ending September 30, 2015 2016 2017 2018 2019 Total Payments Less: Amount Representing Interest Present Value of Minimum Lease Payments Governmental Business -type Activities Activities $ 36,230 $ 69,541 36,230 69,541 36,230 69,541 24,153 69,541 - 23,180 132,843 301,344 (9,473) - $ 1.23,370 $ 301,344 The City issues a variety of long -term debt instruments in order to acquire and/or construct major capital facilities and equipment for governmental activities. These instruments include general obligation bonds, certificates of obligation, and capital leases. These debt obligations are secured by primarily future property tax revenues. In some cases, these bonds are also secured by a pledge of net revenues from the utility system, emergency medical services and economic development sales taxes. However, the amount of the formal pledge is generally limited to $1,000. In October 2013, the City issued $4,965,000 in Combination Tax and Limited Pledge Revenue Certificates of Obligation Series 2013 for utility system improvements and a new public works building. The certificates are secured by a pledge of utility system revenues, which will be used to pay the entire debt service. In October 2013, the City also issued $2,160,000 in General Obligation Refunding Bonds Series 2013 to advance refund a portion of the Combination Tax and Subordinate Lien Revenue Certificates of Obligation Series 2005. The bonds were called on February 1, 2014. The refunding saved the City $155,573 in future debt service with a present value of $1.33,020. Utility system revenues will be used to service the debt on these refunding obligations. In. June 2014, the City issued $8,450,000 in General Obligation Refunding Bonds Series 2014 to advance refund a portion of General Obligation Bonds Series 2006. Proceeds from the bonds were placed with an escrow agent solely to repay the debt service related to the refunded obligations of $8,375,000 until the call date of February 1, 2016. The refunded obligations are considered defeased and are not shown as outstanding on these financial statements. The refunding resulted in gross debt service savings of $1,406,689 with a present value of $1,093,616. Future interest and sinking taxes will be used to service this debt. 43 CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 9 - LONG -TERM DEBT (Continued) A summary of the terms of general obligation bonds and combination of tax and revenue certificates of obligation outstanding at September 30, 2014, follows: .. Issue Amount Maturity Rate Balance Primary Government General Obligation Bonds 2006 Series $ 15,000,000 2031 4.0%-5.25% $ 4,880,000 2007 Series 6,000,000 2027 4.07% 4,295,000 2008 Series 9,900,000 2028 4.13% 7,830,000 2009 Series 9,500,000 2033 2.0%-5.50% 7,090,000 2010 Series, Refunding 2,865,000 2021 2.0%-4.0% 2,040,000 2011 Series 8,250,000 2036 3.0%-6.0% 7,750,000 2011A Series, Refunding 6,745,000 2024 2.33% 5,920,000 2012 . Series 7,625,000 2032 2.00% 7,045,000 2014 Series, Refunding 8,450,000 2030 2.0 % -4.0% 8,450,000 Tax Notes 2010 . Notes 1,270,000 2015 1.2%-2.55% 265,000 2013 Notes 835,000 2018 0.7%-1.7% 675,000 2013A Notes 800,000 2018 1.30% 645,000 Certificates of Obligation 2007 Series CIB 2 438,900 2016 4.01% 105,600 2007 Series CIB 4 569,500 2016 4.01% 133,334 2007 Series CIB 5 1,300,000 2016 4.01% 305,000 Total Governmental Long -Term Obligations $ 57,428,934 General Obligation Bonds 2011 Series, Refunding $ 2,675,000 2021 2.0%-3.0% $ 1,830,000 2013 Series, Refunding 2,130,000 2025 2.58% 2,130,000 Certificates of Obligation 2007 Series CIB 1 6,600,000 2026 4.01% 4,580,000 2007 Series CIB 2 226,100 2016 4.01% 54,400 2007 Series CIB 4 280,500 2016 4.01% 66,666 2013 Series 4,965,000 2033 2.0 % -4.0% 4,735,000 Tax Notes 2010 . Notes 31.0,000 2015 1.20% - 2.55% 65,000 Total Business -Type Long -Term Obligations $ 13,461,066 .. CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 9 - LONG -TERM DEBT (Continued) Changes in long -term debt for the year ending September 30, 2014 are as follows: Governmental Activities: General Obligation Bonds Unamortized Premium General Obligation Refunding Bonds Unamortized Premium Certificates of Obligation Tax Notes Capital Lease Compensated Absences Total Governmental Activities Business -Type Activities: Revenue Bonds Unamortized Discount General Obligation Refunding Bonds Unamortized Premium Certificates of Obligation Unamortized Premium Tax Notes Capital Lease Compensated Absences Payable Total Business -Type Activities Balance $ - $ (2,215,000) Balance Due Within 9/30/2013 Additions Reductions 9130/2014 One Year $ 49,225,000 $ - $ (10,335,000) $ 38,890,000 $ 2,075,000 542,651 - (79,381) 463,270 24,232 8,835,000 8,450,000 (875,000) 16,410,000 925,000 91,099 686,137 (53,073) 724,163 53,073 801,767 - (257,833) 543,934 266,133 2,155,000 - (570,000) 1,585,000 590,000 22,398 133,715 (32,743) 123,370 31,875 859,568 179,145 (171,914) 866,799 173,360 $ 62,532,483 $ 9,448,997 $ (12,374,944) $ 59,606,536 $ 4,138,673 $ 2,215,000 $ - $ (2,215,000) $ - $ - (11,369) - 11,369 - - 2,120,000 2,160,000 (320,000) 3,960,000 475,000 7,502 - (969) 6,533 969 5,048,234 4,965,000 (577,168) 9,436,066 598,867 - 131,725 (6,585) 125,140 6,587 130,000 - (65,000) 65,000 65,000 - 347,705 (46,361) 301,344 69,541 226,270 60,664 (45,254) 241,680 48,336 $ 9,735,637 $ 7,665,094 $ (3,264,968) $ 14,135,763 $ 1,264,300 Annual debt service requirements of bonded debt as of September 30, 2014, are as follows: Governmental Activities September 30, Principal Interest Total 2015 $ 3,856,133 $ 2,148,255 $ 6,004,388 2016 3,767,801 1,953,204 5,721,005 2017 3,605,000 1,830,686 5,435,686 2018 3,720,000 1,712,133 5,432,133 2019 3,145,000 1,597,258 4,742,258 2020 -2024 16,335,000 6,243,415 22,578,415 2025 -2029 13,930,000 3,443,810 17,373,810 2030 -2034 7,990,000 970,501 8,960,501 2034 -2036 1,080,000 54,750 1,134,750 Total $ 57,428,934 $ 19,954,012 $ 77,382,946 '. CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 9 - LONG -TERM DEBT (Continued) 10 0111a[11MHINIIRWTA111,1118aMWI A. Plan Description The City provides pension benefits for its eligible employees through a nontraditional, joint contributory, hybrid defined benefit plan in the state -wide 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 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 contribution, benefits and actuarial methods and assumptions used by the System. This report may be obtained from 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 (City to employee) Years required for vesting Service retirement eligibility (expressed as age /years of service) Updated Service Credit Plan Year 2013 7.0% 2 to 1. 5 60/5,0/20 100% Repeating, Transfers Plan Year 2014 7.0% 2 to 1. 5 60/5,0/20 1.00% Repeating, Transfers Annuity Increase (to retirees) 70% of CPI Repeating 70% of CPI Repeating .m Business -Type Activities September 30, Principal Interest Total 2015 $ 1,138,867 $ 423,799 $ 1,562,666 2016 1,092,199 393,127 1,485,326 2017 1,190,000 361,236 1,551,236 2018 1,135,000 329,659 1,464,659 2019 1,170,000 297,846 1,467,846 2020 -2024 4,800,000 977,892 5,777,892 2025 -2029 2,060,000 326,976 2,386,976 2030 -2033 875,000 71,700 946,700 Total $ 13,461,066 $ 3,182,235 $ 16,643,301 10 0111a[11MHINIIRWTA111,1118aMWI A. Plan Description The City provides pension benefits for its eligible employees through a nontraditional, joint contributory, hybrid defined benefit plan in the state -wide 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 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 contribution, benefits and actuarial methods and assumptions used by the System. This report may be obtained from 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 (City to employee) Years required for vesting Service retirement eligibility (expressed as age /years of service) Updated Service Credit Plan Year 2013 7.0% 2 to 1. 5 60/5,0/20 100% Repeating, Transfers Plan Year 2014 7.0% 2 to 1. 5 60/5,0/20 1.00% Repeating, Transfers Annuity Increase (to retirees) 70% of CPI Repeating 70% of CPI Repeating .m CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 10 - RETIREMENT PLAN (Continued) B. Contributions Under the state law governing TMRS, the contribution rate for each city is determined annually by the actuary, using the Entry Age Nonnal (EAN) cost method (EAN was first used in the December 31, 2013 valuation; previously, the Projected Unit Credit actuarial cost method had been used). 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 for an employee is the contribution rate which, if applied to a member's compensation throughout their period of anticipated covered service with the municipality, would be sufficient to meet all benefits payable on their behalf. The salary- weighted average of the individual rates is the total normal cost rate. The prior service contribution rate amortizes the unfunded (overfunded) actuarial liability (asset) over the applicable period for that city. Both the normal cost and prior service contribution rates include recognition of the projected impact of annually repeating benefits, such as Updated Service Credits and Annuity Increases. The City contributes to the TMRS Plan at an actuarially determined rate. Both the employees and the City make contributions monthly. Since the City needs to know its contribution rate in advance for budgetary purposes, there is a one -year delay between the actuarial valuation that is 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: Fiscal Year Annual Actual Percentage of Net Pension Pension Cost Contribution Made APC Contributed Obligation 2014 $ 2,277,278 $ 2,277,278 100% 2013 2,190,352 2,190,352 100% 2012 2,120,746 2,120,746 100% The required contribution rates for fiscal year 2014 . were determined as part of the December 31, 2011 . and 2012 actuarial valuations. Additional information as of the latest actuarial valuation, December 31, 2013, also follows: Actuarial Valuation Date Actuarial Cost Method Amortization Method Remaining Amortization Period Amortization of New Gains /Losses Asset Valuation Method Investment Rate of Return Projected Salary Increases Inflation Rate Cost -of- Living Adjustments December 31, 2011 Projected Unit Credit Level Percent of Payroll 26.1 years - Closed Period 30 years December 31, 2012 Projected Unit Credit Level Percent of Payroll 25.1 years - Closed Period 30 years December 31, 2013 Entry Age Normal Level Percent of Payroll 30.0 years - Closed Period 30 years 10 -year Smoothed Market 10 -year Smoothed Market 10 -year Smoothed Market 7.0% 7.0% 7.0% Varies by age and service Varies by age and service Varies by age and service 3.0% 2.1% IN 3.0% 2.1% 3.0% 2.1% CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 10 - RETIREMENT PLAN (Continued) C. Funded Status and Funding Progress In October 2013, the TMRS Board approved actuarial changes in (a) the funding method from Projected Unit Credit to Entry Age Normal, (b) the post - retirement mortality assumptions used in calculating liabilities and contribution rates and in the development of the Annuity Purchase Rate factors, and (c) the amortization policy. These actuarial changes were effective with the December 31, 2013 . actuarial valuation. For a complete description of the new actuarial cost method and assumptions, please see the December 31, 2013 TMRS Comprehensive Annual Financial Report (CAFR). The funded status as of December 31, 2013, the most recent actuarial valuation date, is as follows: Actuarial Actuarial Value Valuation Date of Assets 12/31/2013 $ 30,541,625 Actuarial UAAL as a Accrued Unfunded Percentage of Liability (AAL) Funded Ratio AAL (UAAL) Covered Payroll Covered Payroll $ 45,615,815 67.0% $ 15,074,190 $ 14,356,845 105.0% 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 revisions 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 to include techniques that are designed to reduce short -term volatility in actuarial accrued liabilities and the actuarial value of assets. The schedule of finding progress, presented as Required Supplementary Information following the notes to the financial statements, presents multi -year information about whether the actuarial value of plan assets is increasing or decreasing over time relative to the actuarial accrued liability of benefits. C. Other Post - Employment Benefits The City also participates in the cost sharing multiple- employer defined benefit group -term life insurance plan operated by TMRS known as 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. The City contributes to the SDBF at a contractually required rate as determined by an annual actuarial valuation. The rate is equal to the cost of providing one -year term life insurance. The funding policy for the SDBF program is to assure that adequate resources are available to meet all death benefit payments for the upcoming year; the intent is not to pre -fund retiree life insurance during the employees' entire careers. The City's contributions to the TMRS SDBF for the years ended 2014, 2013, and 2012 were $20,815, $21,251, and $22,274, respectively, which equaled the required contributions each year. CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 11— RETIREE HEALTH INSURANCE PLAN A. Plan Description The City provides an other post - employment benefit to eligible retirees of the City whereby they can stay on the City's health insurance plan by paying the full premium. B. Contributions The City's annual other post - employment benefits (OPEB) cost is calculated based on the annual required contribution (ARC) of the employer, an amount actuarially determined in accordance with the parameters of GASB Statement No. 45. The ARC represents a level of accrual that, if paid on an ongoing basis, is projected to cover the normal cost each year and to amortize any unfunded actuarial liabilities (or funding excesses) over a period not to exceed thirty years. The City's annual OPEB cost for the fiscal year ending September 30, 2014 is as follows: Annual Required Contribution Interest on OPEB obligation Adjustment to ARC Annual OPEB cost Contributions Increase in net OPEB obligation Beginning Net OPEB Obligation Ending Net OPEB Obligation $ 78,523 1.3,457 (12,467) 79,513 (13,645) 65,868 299,038 $ 364,906 The City's annual OPEB cost, the amount contributed by the employer, the percentage of annual OPEB cost contributed to the plan, and the net OPEB obligation for fiscal year ending September 30, 2014 and the preceding two fiscal years were as follows: Fiscal Year Ending September 30, 2014 2013 2012 Annual OPEB Percent Cost Contributions Contributed $ 79,512 $ 13,645 17% 77,014 1 3,248 17% 74,590 1 2,862 17% Net OPEB Obligation $ 364,905 299,038 235,272 The Projected Unit Credit Cost Method is used to calculate the actuarial required contribution (ARC) for the City's retiree health care plan. Using the plan benefits, the present health premiums and a set of actuarial assumptions, the anticipated future payments are projected. The actuarial cost method then provides for a systematic funding for these anticipated payments. The yearly ARC is computed to cover the cost of benefits being earned by covered members as well as to amortize a portion of the unfunded accrued liability. .• CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 11— RETIREE HEALTH INSURANCE PLAN (Continued) B. Contributions (Continued) Projections of health benefits are based on the plan as understood by the City and include the types of benefits in force at the valuation date and the pattern of sharing benefit costs between the City and the City's employees to that point. Actuarial calculations reflect a long -term perspective and employ methods and assumptions that are designed to reduce short-term volatility in actuarial accrued liabilities and the actuarial value of assets. Significant methods and assumptions were as follows: Inflation Rate 3.0% Investment Rate of Return 4.5 %, net of expenses Actuarial Cost Method Projected Unit of Credit Amortization Method Level as a percent of payroll Amortization Period 30 -year open period Payroll Growth 3.0% Medical Trend Initial rate of 7.25 %, declining to an ultimate rate of 4.5% after 11 years Actuarial valuations involve estimates of the value of reported amounts and assumptions about the probability of events in the future. Amounts determined regarding the funded status and the annual required contributions of the City's retiree health care plan are subject to continual revision as actual results are compared to past expectations and new estimates are made about the future. The required schedule of funding progress presented as required supplementary information provides multiyear trend information that shows whether the actuarial value of plan assets is increasing or decreasing over time relative to the actuarial . accrued liability for benefits. The funded status as of December 31, 2013, the most recent actuarial valuation date, is as follows: Actuarial UAAL as a Actuarial Actuarial Value Accrued Unfunded Percentage of Valuation Date of Assets Liability (AAL) Funded Ratio AAL (UAAL) Covered Payroll Covered Payroll 12/31/2013 $ - $ 493,114 0.0% $ 493,114 $ 14,356,845 3.4% 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 revisions 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 to include techniques that are designed to reduce short-term volatility in actuarial accrued liabilities and the actuarial value of assets. The schedule of funding progress, presented as Required Supplementary Information following the notes to the financial statements, presents multi -year information about whether the actuarial value of plan assets is increasing or decreasing over time relative to the actuarial accrued liability of benefits. W CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 12 - JOINT VENTURES Schertz /Seguin Local Government Corporation The Schertz /Seguin Local Government Corporation is a public, nonprofit corporation organized to aid, assist, and act on behalf of the cities of Schertz and Seguin in acquiring, constructing, maintaining, and operating a water utility system. The participating governments have an ongoing financial responsibility to fund the operation of the corporation through either purchase of services or by subsidizing the operations. Contributions to the corporation are reflected as "operating expenses" in the water and sewer fiend and totaled $1,432,074 for the year ended September 30, 2014. Separate financial statements for the Schertz /Seguin Local Government Corporation may be obtained from the City of Seguin, 210 East Gonzales Street, Seguin, Texas 781.56. The City of Schertz is jointly liable, together with the City of Seguin, for operating deficits and long -term debt of the Schertz /Seguin Local Government Corporation. Following is a summary of financial data as reported in the Corporation's audited financial statements dated September 30, 2013: ASSETS: Current Assets $ 6,426,218 Restricted Cash and Cash Equivalents 23,684,301 Property, Plant & Equipment (net) 78,465,951 Other Assets 2,300,213 TOTAL ASSETS 110,876,683 LIABILITIES: Current Liabilities 9,463,232 Revenue Bonds (Less Current Maturities) 99,486,517 TOTAL LIABILITIES 108,949,749 NET POSITION: Net Investment in Capital Assets (4,723,901) Restricted 4,568,930 Unrestricted 2,081,905 TOTAL NET POSITION $ 1,926,934 The Corporation had revenue bonds outstanding in the amount of $101,176,000 (as of September 30, 2013) to provide funds to build, improve, extend, enlarge and repair the Corporation's utility system, fund a reserve, and pay the costs of bond issuance. The bond resolution pledges intergovernmental contract revenues from the cities of Schertz and Seguin (the participating governments) to bond holders. Under the intergovernmental water supply contract, the participating governments are unconditionally obligated to pay their respective shares of annual contract revenue bond debt service from the operation of their respective utility systems. 51 CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 12 - JOINT VENTURES (Continued) Cibolo Valley Local Government Corporation The Cibolo Valley Local Government Corporation (CVLGC) is a public nonprofit corporation incorporated in March 2012 to assist and act on behalf of the cities of Schertz, Converse and Cibolo to obtain additional water sources. The participating governments have an ongoing financial responsibility to fund the operation of the corporation through either purchase of services or by subsidizing the operations. Contributions to the corporation are reflected as "operating expenses" in the water and sewer fund. Separate financial statements for the CVLGC may be obtained from the City of Seguin, 210 East Gonzales Street, Seguin, Texas 78156. The City of Schertz is jointly liable, together with the City of Seguin, City of Converse, and City of Cibolo, for operating deficits and long -term debt of CVLGC. Following is a summary of financial data as reported in the Corporation's audited financial statements dated September 30, 2013: ASSETS: Current Assets $ 563,1.85 TOTAL ASSETS 563,185 LIABILITIES: Current Liabilities 26,401 TOTAL LIABILITIES 26,401 NET POSITION: Unrestricted 536,784 TOTAL NET POSITION $ 536,784 Cibolo Creek Municipal Authority Cibolo Creek Municipal Authority (COMA) provides sewage treatment for the area in and around the City. CCMA has agreed to construct a sewage treatment facility in the southern portion of the City to primarily serve citizens of the City but also neighboring Cities and future development. Because the City would be the primary customer at this time, the City agreed to enter into a regional wastewater treatment contract in September 2014. CCMA will issue bonds to finance the project and the City has agreed to make payments to CCMA to cover operation expenses, maintenance expenses, and debt service. The City is the sole member at this time, so it is responsible for 100% of the project costs. Should other members join, the City's share of the costs would be reduced. 52 CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 12 - JOINT VENTURES (Continued) Ciholo Creek Municipal Authority (Continued) In September 2014, CCMA issued bonds for the project in the amount of $6,950,000 with debt service requirements as follows: Fiscal Year Ending September 30, Principal 2015 $ 75,000 2016 . 1.45,000 2017 150,000 2018 1.50,000 2019 155,000 2020 -2024 830,000 2025 -2029 970,000 2030 -2034 1,180,000 2035 -2039 1,465,000 2040 -2044 1,830,000 $ 6,950,000 NOTE 13 - COMMITMENTS AND CONTINGENCIES Tax Increment Financing (the "Zone') Interest Total $ 267,650 266,1.50 263,250 260,250 257,250 1,233,350 1,087,650 877,450 592,500 225,200 $ 5,330,700 $ 342,650 411,1.50 413,250 410,250 412,250 2,063,350 2,057,650 2,057,450 2,057,500 2,055,200 $12,280,700 The City is a principal in the City of Schertz Tax Increment Reinvestment Zone #2, pursuant to Chapter 311 of the Texas Tax Code. Under the terms of the Zone agreement, the City of Schertz, Bexar County, and San. Antonio River Authority are funding infrastructure improvements through tax increment financing to the Sedona Development Project. At the time the Zone was created, the property tax base was "frozen" and increment taxes resulting from the increases to property tax base are being used to finance Zone improvements. The total projected cost is a combined figure of $45,000,000. Project costs of the developer will be funded up to 100% of the tax increment generated by the City of Schertz, Bexar County, and San Antonio River Authority (SARA). The City of Schertz (combined with SARA) have committed up to $32,877,000 of the total $45,000,000. The Zone has a statutory termination date of December 31, 2027. The TIRZ has collected $368,610 from taxing entities (net of administrative reimbursements) and remitted $50,376 to the developer as of September 30, 2014. 380 Agreements To encourage economic growth, the City has entered into various 380 agreements with businesses in the City. These agreements involve rebates of future ad valorem taxes and or sales taxes. These agreements are rebates of future taxes, and should not have a significant impact on current tax base in future years. Once the terms of the 380 agreements expire, the tax base of the City will be increased to include these new businesses. 53 CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 13 - COMMITMENTS AND CONTINGENCIES (Continued) Construction Commitments The City of Schertz has entered into commitments for various projects as follows: Primary Government: Governmental Activities: Ware Seguin Road Improvements Lower Seguin Road Improvements Lazy Oak Drive Laura Heights Projects Natatorium Project Soccer Fields Improvements Schertz Animal Adoption Center FM 78 and Main Street Woodland Oaks Detention Total Governmental Commitments Business -Type Activities: S. W.W. Treatment Plant Town Creek Sewer Project - Phase III East Live Oak Water Plan Upgrades SE Quad Elevated Tank Aviation Heights Waterline Replacement Northcliffe Waterline Upgrades Waterline at Maske Rd- FM1518 Commercial Place Project Total Business -Type Activities Total Estimated Future Commitments Estimated Project Cost to City $ 487,499 541,841 172,420 80,394 6,160,500 4,051,000 2,415,100 1,000,000 32,000 1.4,940,754 3,985,000 695,807 245,000 200,552 400,000 730,064 367,735 2,135,723 8,759,881. $ 23,700,635 El Expended to Date $ 472,516 134,215 103,610 40,043 320,152 3,652,109 2,383,806 20,430 5,830 7,132,711 223,811 76,414 22,847 14,346 32,481 700,634 337,295 1,783,485 3,191,313 $ 10,324,024 Estimated Future Commitment $ 14,983 407,626 68,810 40,351 5,840,348 398,891 31,294 979,570 26,170 7,808,043 3,761,189 619,393 222,153 186,206 367,519 29,430 30,440 352,238 5,568,568 $ 13,376,611 CITY OF SCHERTZ, TEXAS NOTES TO BASIC FINANCIAL STATEMENTS (CONTINUED) SEPTEMBER 30, 2014 NOTE 13 - COMMITMENTS AND CONTINGENCIES (Continued) Litigation The City is the subject of various claims and litigation that have arisen in the course of its operations. Management is of the opinion that the City's liability in these cases, if decided adversely to the City, will not have a material effect on the City's financial position. Risk Management The City is exposed to various risks of loss related to torts; theft of, damage to, and destruction of assets; errors and omissions; and natural disasters. The City contracts with the Texas Municipal League Intergovernmental Risk Pool, a public entity risk pool currently operating as a common risk management and insurance program providing insurance coverage in the following areas: general liability, automobile liability and physical damage, law enforcement liability, worker's compensation, real and personal property, mobile equipment, and errors and omissions liability. TML is a multi - employer group that provides for a combination of risk sharing among pool participants and stop loss coverage. Contributions are set annually by the provider. Liability by the City is generally limited to the contributed amounts. Annual contributions for the year ended September 30, 2014 were $379,140 for property and casualty and workers compensation coverage. There were no significant increases or decreases in coverage from fiscal year 2013. NOTE 14 - SUBSEQUENT EVENTS In January 2015, the City issued Tax Notes, Series 2015 for a principal amount of $2,125,000. The notes mature serially through 2021 and bear interest at 1.75 %. The notes were issued to purchase various vehicles and equipment. The debt service will be paid by the activities receiving the equipment. hC��IL�if�i�L� � ► � Y.Y�1�litZ.TKK� J1� ►MM1►[- • ._ ��[�1�1�[� � ►i ' ► y In June 2012, the GASB issued Statement 68, Accounting and Financial Reporting for Pensions — an Amendment of GASB Statement 27. The statement improves information provided by governments for defined benefit retirement plans. The Statement is effective for fiscal years beginning after June 15, 2014. Management is currently evaluating the impact of the adoption of this statement on the City's financial statements and it may be significant. W REQUIRED SUPPLEMENTARY INFORMATION m CITY OF SCHERTZ, TEXAS REQUIRED SUPPLEMENTARY INFORMATION GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL YEAR ENDED SEPTEMBER 30, 2014 Public Safety. Police Department 5,456,518 5,468,000 5,432,623 Variance With Fire Department 3,022,948 3,052,134 2014 Final Budget - Inspection Budgeted Amounts Actual Positive 41,466 Original Final Amounts (Negative) REVENUES Total Public Safety 9,602,221 9,672,931 9,568,062 Taxes $ 15,595,829 $ 16,120,391 $ 16,652,245 $ 531,854 Permits and Fees 1,077,162 1,275,162 1,365,624 90,462 Service Fees 1,338,588 1,491,998 1,592,851 1.00,853 Fines and Fees 2,188,680 1,871,680 1,712,562 (1.59,118) Intergovernmental 229,000 229,000 218,081 (10,919) Investment Earnings 19,575 19,575 13,657 (5,918) Miscellaneous 502,100 512,325 547,515 35,190 TOTAL REVENUES 20,950,934 21,520,131 22,102,535 582,404 EXPENDITURES General Government: Council 83,075 88,375 81,048 7,327 City Manager 984,533 950,368 939,236 1.1,132 Municipal Court 400,621 400,621 361,365 39,256 31.1 Customer Relations 1 12,272 1 12,790 112,771 19 Planning & Zoning 1 55,482 1 55,482 140,107 1.5,375 Legal 450,000 450,000 305,524 144,476 General Services 1,012,532 1,012,532 922,1.56 90,376 City Secretary 189,876 189,876 179,657 10,219 Nondepartmental 1,480,041 1,454,395 1,002,71.4 451,681 Community & Media Relations 343,115 269,690 220,717 48,973 Records Management 69,037 69,037 57,365 11,672 Schertz Magazine 406,684 406,684 363,659 43,025 Engineering 259,672 295,026 175,445 119,581 Geographic Information Systems 142,703 1.42,703 137,752 4,951 Citizens Assistance 74,000 74,000 87,648 (1.3,648) Special Events 1.41,950 1.94,807 155,676 39,131 Total General Government 6,305,593 6,266,386 5,242,840 1,023,546 Public Safety. Police Department 5,456,518 5,468,000 5,432,623 35,377 Fire Department 3,022,948 3,052,134 3,036,331 15,803 Inspection 471,768 501,810 460,344 41,466 Marshal Service 650,987 650,987 638,764 12,223 Total Public Safety 9,602,221 9,672,931 9,568,062 1.04,869 Public Environment: Streets 1,072,407 1,1.05,905 1,076,136 29,769 Total Public Environment $ 1,072,407 $ 1,105,905 $ 1,076,136 $ 29,769 IN CITY OF SCHERTZ, TEXAS REQUIRED SUPPLEMENTARY INFORMATION GENERAL FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL (CONTINUED) YEAR ENDED SEPTEMBER 30, 2014 Administration. Information Technology 1,261,414 1,452,402 1,490,941 Variance With Human Resources 414,508 414,508 2014 Final Budget - Finance Budgeted Amounts Actual Positive 7,163 Original Final Amounts (Negative) EXPENDITURES (Continued) Building Maintenance 298,529 338,529 224,414 Parks and Recreation: Fleet Service 490,646 490,646 531,903 Parks $ 834,854 $ 837,944 $ 873,978 $ (36,034) Pools 254,503 254,503 21.6,967 37,536 Community /Civic Center 142,522 142,522 126,693 15,829 Senior Center - 53,615 50,391 3,224 Total Parks and Recreation 1,231,879 11288,584 11268,029 20,555 Cultural: Library 874,697 836,476 794,434 42,042 Total Cultural 874,697 836,476 794,434 42,042 Health: Animal Control 454,136 454,136 394,918 59,218 Total Health 454,136 454,136 394,918 59,218 Administration. Information Technology 1,261,414 1,452,402 1,490,941 (38,539) Human Resources 414,508 414,508 400,035 14,473 Finance 470,977 473,301 466,1.38 7,163 Purchasing & Asset Management 267,159 267,1.59 249,651 1.7,508 Building Maintenance 298,529 338,529 224,414 114,115 Fleet Service 490,646 490,646 531,903 (41,257) Interfund Charges (1,753,162) (1,753,162) (1,751,607) (1,555) Total Administration 1,450,071 1,683,383 1,611,475 71,908 TOTAL EXPENDITURES 20,991,004 21,307,801 19,955,894 1,351,907 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (40,070) 212,330 2,1.46,641 1,934,311 OTHER FINANCING SOURCES (USES) Lease Proceeds - - 1.33,715 133,715 Transfers In 257,150 294,578 89,416 (205,162) Transfers Out (5,150) (483,400) (664,944) (181,544) TOTAL OTHER FINANCING SOURCES (USES) 252,000 (188,822) (441,813) (252,991) NET CHANGE IN FUND BALANCE 211,930 23,508 1,704,828 1,681,320 FUND BALANCE - BEGINNING 6,017,206 6,017,206 6,017,206 - FUND BALANCE - ENDING $ 6,229,136 $ 6,040,714 $ 7,722,034 $ 1,681,320 w CITY OF SCHERTZ, TEXAS REQUIRED SUPPLEMENTARY INFORMATION ECONOMIC DEVELOPMENT CORPORATION SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES — BUDGET AND ACTUAL YEAR ENDED SEPTEMBER 30, 2014 EXPENDITURES Current: Variance With General Government 2014 Final Budget - 565,322 Budgeted Amounts Actual Positive 1,063,544 Original Final Amounts (Negative) REVENUES Taxes $ 3,095,036 $ 3,440,944 $ 3,521,338 $ 80,394 Investment Earnings 10,175 10,175 9,599 (576) TOTAL REVENUES 3,105,211 3,451,119 3,530,937 79,818 EXPENDITURES Current: General Government 1,217,200 1,217,200 565,322 651,878 Administration 1,063,544 1,063,544 519,831 543,713 Debt Service: Principal 400,000 400,000 400,000 - Interest 27,672 27,672 27,671 1 TOTAL EXPENDITURES 2,708,416 2,708,416 1,512,824 1,195,592 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 396,795 742,703 2,018,113 1,275,410 OTHER FINANCING SOURCES (USES) Transfers Out (366,138) (366,138) (367,743) (1,605) TOTAL OTHER FINANCING SOURCES (USES) NET CHANGE IN FUND BALANCE FUND BALANCE - BEGINNING FUND BALANCE - ENDING (366,138) (366,138) (367,743) (1,605) 30,657 376,565 1,650,370 1,273,805 6,142,208 6,142,208 6,142,208 $ 6,1.72,865 $ 6,518,773 $ 7,792,578 $ 1,273,805 ®' CITY OF SCHERTZ, TEXAS NOTES TO SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE — BUDGET AND ACTUAL SEPTEMBER 30, 2014 Budgetary Information — The budget is prepared in accordance with accounting principles generally accepted in the United States of America. The City maintains strict budgetary controls. The objective of these controls is to ensure compliance with legal provision embodied in the annual appropriated budget approved by the City Council and as such is a good management control device. Annual budgets are adopted for the general fund; debt service fund; hotel motel tax, park fund, tree mitigation; police forfeiture fund, library advisory board fund, and the historical committee fund. Project - length financial plans are adopted for capital projects funds. Of these budgets, only the General Fund, Debt Service and Economic Development Corporation are legally adopted. Budgetary preparation and control is exercised at the department level. Actual expenditures may not legally exceed appropriations at the fund level. The City did not exceed the budgeted expenditures in any funds with legally adopted budgets during 2014. The City does not use encumbrances. •1 CITY OF SCHERTZ, TEXAS REQUIRED SUPPLEMENTARY INFORMATION TEXAS MUNICIPAL RETIREMENT SYSTEM ANALYSIS OF FUNDING PROGRESS LAST TEN CALENDAR YEARS * As of December 31 of the preceding year, the date of the actuarial valuation. * * Assets are stated cost as of December 31 of the preceding year. 61 UNFUNDED ACTUARIAL ACCRUED LIABILITY UNFUNDED AS ACTUARIAL ACTUARIAL ACTUARIAL FUNDING ACTUARIAL ANNUAL PERCENTAGE VALUATION VALUE OF ACCRUED RATIO ACCRUED COVERED OF COVERED DATE ASSETS" LIABILITY* (1)/(2) LIABILITY PAYROLL PAYROLL 2013 $ 30,541,625 $ 45,615,815 67.0% $1.5,074,190 $ 1.4,356,845 105.0% 2012 26,273,784 38,771,665 67.8% 12,497,881 13,853,458 90.2% 2011 22,377,323 35,296,880 63.4% 12,919,557 13,125,349 98.4% 2010 18,696,437 31,792,634 58.8% 13,096,197 12,612,346 103.8% 2009 13,946,029 25,584,067 54.5% 11,638,038 12,321,349 94.5% 2008 11,216,663 22,068,312 50.8% 10,851,649 11,626,232 93.3% 2007 8,811,205 19,057,935 46.2% 10,246,730 10,047,726 102.0% 2006 7,290,175 11,798,002 61.8% 4,507,827 8,478,634 53.2% 2005 6,042,437 9,003,970 67.1% 2,961,533 7,662,928 38.6% 2004 5,122,816 7,950,619 64.4% 2,827,803 6,144,053 46.0% * As of December 31 of the preceding year, the date of the actuarial valuation. * * Assets are stated cost as of December 31 of the preceding year. 61 ACTUARIAL VALUATION r)ATF 12/31/2013 CITY OF SCHERTZ, TEXAS REQUIRED SUPPLEMENTARY INFORMATION RETIREE HEALTH INSURANCE PLAN ANALYSIS OF FUNDING PROGRESS LAST CALENDAR YEAR UNFUNDED ACTUARIAL ACCRUED LIABILITY AS A PERCENTAGE OF COVERED PAYROLL (b -a) /d 0.0% $ 14,356,845 3.4% The actuarial valuation conducted as of December 31, 2013 . was the first for the plan. 62 ANNUAL UNFUNDED ACTUARIAL ACTUARIAL ACTUARIAL VALUE OF ACCRUED ACCRUED ASSETS LIABILITY* LIABILITY (a) (b) (b -a) $ - $ 493,114 $ 493,114 UNFUNDED ACTUARIAL ACCRUED LIABILITY AS A PERCENTAGE OF COVERED PAYROLL (b -a) /d 0.0% $ 14,356,845 3.4% The actuarial valuation conducted as of December 31, 2013 . was the first for the plan. 62 ANNUAL FUNDING COVERED RATIO PAYROLL (a/b) (d) UNFUNDED ACTUARIAL ACCRUED LIABILITY AS A PERCENTAGE OF COVERED PAYROLL (b -a) /d 0.0% $ 14,356,845 3.4% The actuarial valuation conducted as of December 31, 2013 . was the first for the plan. 62 rr SUPPLEMENTARY INFORMATION • Comparative Statements • General Fund • Economic Development Corporation • Debt Service Fund • Capital Projects Fund Combining and Comparative Individual Fund Statements - Nonmajor Governmental Funds • Hotel Occupancy - will account for proceeds of hotel occupancy taxes to be used strictly for those kinds of programs that promote the tourism industry. • Tree Mitigation Fund - will account for revenues from permits, grants and donations to preserve and replace trees in the City. • Park Fund - will account for revenues from developers' fees (in lieu of park land dedication), grants, and donations and is designed to monitor and manage improvement of park system. • Police Forfeitures Fund - will account for revenue received from drug related cases in conjunction with other law enforcement agencies. • Library Advisory Board — to account for certain fees generated at the library to be used by the Board for general improvements to the Library. • Historical Committee Fund - will account for funds received for the preservation of the history of the city. • Parks and Recreation Foundation — to account for revenues from events, fundraisers and donations to improve and maintain City parks. 63 CITY OF SCHERTZ, TEXAS COMPARATIVE BALANCE SHEETS GENERAL FUND SEPTEMBER 30, 2014 AND 2013 a 2014 2013 ASSETS Cash and Cash Equivalents $ 734,684 $ 169,823 Investments 6,895,148 4,884,186 Receivables (net of allowances): Taxes 1,725,512 1,640,179 Accounts and Other 1,987,843 1,986,715 Due from Other Funds - 467,407 Inventory 88,518 50,768 Prepaid Items 8,133 - Restricted Cash 425,864 443,360 TOTAL ASSETS $ 11,865,702 $ 9,642,438 LIABILITIES, DEFERRED INFLOWS OF RESOURCES AND FUND BALANCES Liabilities: Accounts Payable $ 1,241,009 $ 931,146 Accrued Salaries and Benefits 456,962 353,809 Customer Deposits 42,513 33,916 Due to Other Governments 205,303 231,399 Due to Other Funds 138,926 - Unearned Revenue 28,285 47,386 Total Liabilities 2,112,998 1,597,656 Deferred Inflows of Resources: Unavailable Revenue 2,030,670 2,027,576 Fund Balance: Nonspendable: Inventory 88,518 50,768 Prepaid Items 8,133 - Restricted for: Police and Public Safety 139,884 101,303 Municipal Court 628,459 646,422 PEG Capital Fees 489,509 456,175 Scholarships 54,176 - Assigned for: Property Replacement 694,916 456,034 Special Events 31,177 99,770 Unassigned 5,587,262 4,206,734 Total Fund Balance 7,722,034 6,017,206 TOTAL LIABILITIES, DEFERRED INFLOWS OF RESOURCES AND FUND BALANCE $ 11,865,702 $ 9,642,438 a CITY OF SCHERTZ, TEXAS COMPARATIVE STATEMENTS OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE GENERAL FUND FOR THE YEARS ENDED SEPTEMBER 30, 2014 AND 2013 REVENUES Taxes Permits and Fees Service Fees Fines and Fees Intergovernmental Investment Earnings Miscellaneous TOTAL REVENUES EXPENDITURES Current: General Government Public Safety Public Environment Parks and Recreation Cultural Health Administration Capital Outlay Debt Service: Principal Interest and Fiscal Charges TOTAL EXPENDITURES Excess (Deficiency) of Revenues Over (Under) Expenditures OTHER FINANCING SOURCES (USES) Lease Proceeds Transfers In Transfers Out TOTAL OTHER FINANCING SOURCES (USES) Net Change in Fund Balance Fund Balance at Beginning of Year Fund Balance at End of Year m 2014 2013 $ 16,652,245 1,365,624 1,592,851 1,712,562 218,081 13,657 547,515 22,102,535 5,232,687 9,398,845 1,012,607 1,100,971 794,434 394,918 1,604,825 383,264 32,764 579 19,955,894 S 15,411,501 1,398,781 1,541,839 1,870,825 464,979 10,247 584,214 21,282,386 5,552,150 9,113,840 951,528 1,120,724 830,149 341,961 933,705 221,562 37,792 913 19,104,324 2,146,641 2,178,062 133,715 89,416 (664,944) (441,813) 1,704,828 61,226 (198,899) (137,673) 2,040,389 6,017,206 3,976,817 $ 7,722,034 $ 6,017,206 CITY OF SCHERTZ, TEXAS COMPARATIVE BALANCE SHEETS ECONOMIC DEVELOPMENT CORPORATION SEPTEMBER 30, 2014 AND 2013 ASSETS Cash and Cash Equivalents Investments Receivables (net of allowances): Taxes Accounts and Other Note Receivable TOTAL ASSETS LIABILITIES AND FUND BALANCE Liabilities: Accounts Payable Accrued Salaries and Benefits Total Liabilities Fund Balance: Nonspendable: Note Receivable Restricted for: Economic Development Total Fund Balance TOTAL LIABILITIES AND FUND BALANCE 2014 2013 $ 293,205 $ 318,397 6,961,045 5,152,452 567,202 569,259 1,888 1,197 - 120,080 $ 7,823,340 $ 6,161,385 $ 9,658 $ 11,034 21,104 8,143 30,762 19,177 120,080 7,792,578 6,022,128 7,792,578 6,142,208 $ 7,823,340 $ 6,161,385 CITY OF SCHERTZ, TEXAS COMPARATIVE STATEMENTS OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE ECONOMIC DEVELOPMENT CORPORATION FOR THE YEARS ENDED SEPTEMBER 30, 2014 AND 2013 REVENUES Taxes Investment Earnings TOTAL REVENUES EXPENDITURES Current: General Government Administration Debt Service: Principal Interest and Fiscal Charges TOTAL EXPENDITURES Excess (Deficiency) of Revenues Over (Under) Expenditures OTHER FINANCING SOURCES (USES) Transfers Out TOTAL OTHER FINANCING SOURCES (USES) Net Change in Fund Balance Fund Balance at Beginning of Year Fund Balance at End of Year M 2014 2013 . $ 3,521,338 $ 3,215,620 9,599 8,821 3,530,937 3,224,441 565,322 572,880 519,831 197,859 400,000 390,000 27,671 38,504 1,512,824 1,199,243 2,018,1.1.3 2,025,198 (367,743) (369,075) (367,743) (369,075) 1,650,370 1,656,123 6,142,208 4,486,085 $ 7,7927578 $ 6,142,208 CITY OF SCHERTZ, TEXAS COMPARATIVE BALANCE SHEETS DEBT SERVICE FUND SEPTEMBER 30, 2014 AND 2013 ASSETS Cash and Cash Equivalents Investments Receivables (net of allowances): Taxes TOTAL ASSETS LIABILITIES, DEFERRED INFLOWS OF RESOURCES AND FUND BALANCE Liabilities: Accounts Payable Accrued Interest Payable Total Liabilities Deferred Inflows of Resources: Unavailable Revenue Fund Balance: Restricted for: Debt Service Total Fund Balance TOTAL LIABILITIES, DEFERRED INFLOWS OF RESOURCES AND FUND BALANCE • 2014 2013 . $ 34,988 $ 118,850 624,189 398,749 68,928 71,174 $ 728,105 $ 588,773 $ - $ 400 33,742 - 33,742 400 68,928 71,174 625,435 517,199 625,435 517,199 $ 728,1.05 $ 588,773 CITY OF SCHERTZ, TEXAS SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET TO ACTUAL DEBT SERVICE FUND FOR THE YEAR ENDED SEPTEMBER 30, 2014 (WITH COMPARATIVE ACTUAL TOTALS FOR 2013) •• Variance with 2014 Final Budget- 2013 Budgeted Amounts Actual Positive Actual Original Final Amounts (Negative) Amounts REVENUES Property Taxes $ 5,204,493 $ 5,204,493 $ 5,295,577 $ 91,084 $ 5,051,475 Investment Earnings 25,075 25,075 1,477 (23,598) 2,012 TOTAL REVENUES 5,229,568 5,229,568 5,297,054 67,486 5,053,487 EXPENDITURES Debt Service: Principal 3,262,834 3,262,834 3,262,833 1 2,789,533 Interest and Fiscal Charges 2,291,591 2,291,591 2,080,360 211,231 2,341,754 Bond Issue Costs 42,350 42,350 165,650 (123,300) 1,750 TOTAL EXPENDITURES 5,596,775 5,596,775 5,508,843 87,932 5,133,037 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES (367,207) (367,207) (211,789) 155,418 (79,550) OTHER FINANCING SOURCES Transfers In 367,207 367,207 366,138 (1,069) 369,075 Proceeds from Refunding Bonds - - 8,450,000 8,450,000 - Premiums from Refunding Bonds - - 686,137 686,137 - Payments to Refunding Escrow Agent - - (9,182,250) (9,182,250) - TOTAL OTHER FINANCING SOURCES 367,207 367,207 320,025 (47,182) 369,075 Net Change in Fund Balance - - 108,236 108,236 289,525 FUND BALANCE, BEGINNING 517,199 517,199 517,199 - 227,674 FUND BALANCE, ENDING $ 517,199 $ 517,199 $ 625,435 $ 108,236 $ 517,199 •• CITY OF SCHERTZ, TEXAS COMPARATIVE BALANCE SHEETS CAPITAL PROJECTS FUND SEPTEMBER 30, 2014 AND 2013 ASSETS Cash and Cash Equivalents Investments Receivables (net of allowances): Accounts and Other Prepaid Items TOTAL ASSETS LIABILITIES AND FUND BALANCE Liabilities: Accounts Payable Due to Other Funds Total Liabilities Fund Balance: Nonspendable Prepaid Items Restricted for Capital Improvement Committed for Capital Improvement Assigned for Capital Improvement Total Fund Balance TOTAL LIABILITIES AND FUND BALANCE HE 2014 2013 . $ 1,084,721 $ 259,881 9,792,513 16,797,740 - 73,895 - 754,443 $ 10,877,234 $ 1.7,885,959 $ 469,483 $ 664,745 776,005 795,804 1,245,488 1,460,549 - 754,443 9,600,028 15,360,800 31,718 165,000 - 145,167 9,631,746 1.6,425,41.0 $ 10,877,234 $ 17,885,959 CITY OF SCHERTZ, TEXAS COMPARATIVE STATEMENTS OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE CAPITAL PROJECTS FUND FOR THE YEARS ENDED SEPTEMBER 30, 2014 AND 2013 REVENUES Intergovernmental Investment Earnings Miscellaneous TOTAL REVENUES EXPENDITURES Current: General Government Capital Outlay Debt Service: Bond Issue Costs TOTAL EXPENDITURES Excess (Deficiency) of Revenues Over (Under) Expenditures OTHER FINANCING SOURCES (USES) Proceeds from Issuances of Debt Transfers In TOTAL OTHER FINANCING SOURCES (USES) Net Change in Fund Balance Fund Balance at Beginning of Year Fund Balance at End of Year 71 2014 $ 3,688 $ 27,353 17,429 31,572 - 7,500 21,117 66,425 46,542 - 7,530,597 2,931,207 - 30,000 7,577,139 2,961,207 (7,556,022) (2,894,782) - 1,635,000 762,358 337,051 762,358 1,972,051. (6,793,664) (922,731) 16,425,41.0 17,348,141 $ 9,631.1746 $ 16,425,410 CITY OF SCHERTZ, TEXAS COMBINING BALANCE SHEET NONMAJOR GOVERNMENTAL FUNDS SEPTEMBER 30, 2014 . ASSETS Cash and Cash Equivalents Investments Accounts Receivable, Net of Allowance Taxes Other Prepaid Items TOTAL ASSETS LIABILITIES AND FUND BALANCE Liabilities Accounts Payable Total Liabilities Fund Balance Nonspendable Prcpaids Restricted for: Tourism Development Tree Mitigation Parks Police Forfeiture Library Historical Committee Total Fund Balances TOTAL LIABILITIES AND FUND BALANCE Special Revenue Funds Hotel Occupancy Park Tree Fund Fund Mitigation $ 165,308 $ 203,633 $ 261,866 299,187 1,355 97,339 38,093 - - 13,602 - - 516,190 $ 204,988 $ 359,205 $ 592 $ 1.2,840 $ - 592 12,840 - 13,602 - - 501,996 - - - - 359,205 192,148 - 515,598 1.92,1.48 359,205 $ 516,190 $ 204,988 $ 359,205 72 Special Revenue Funds Police Library Parks & Historical Forfeitures Advisory Recreation Committee Fund Board Foundation Fund Totals $ 53,737 $ 29,623 $ 121,369 $ 9,567 $ 845,103 338,989 44,855 - - 781,725 - - - - 38,093 140 - 140 - - - - 13,602 $ 392,726 $ 74,478 $ 121,509 $ 9,567 $ 1,678,663 $ 3,346 $ 5,947 $ 9,002 $ - $ 31,727 3,346 5,947 9,002 - 31,727 - - 13,602 - - 501,996 - - 359,205 - - 112,507 - 304,655 389,380 - - - 389,380 - 68,531 - - 68,531 - - - 9,567 9,567 389,380 68,531 112,507 9,567 1,646,936 $ 392,726 $ 74,478 $ 121,509 $ 9,567 $ 1,678,663 73 CITY OF SCHERTZ, TEXAS COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES — NONMAJOR GOVERNMENTAL FUNDS FOR THE YEAR ENDED SEPTEMBER 30, 2014 REVENUES Occupancy Tax Permits and Fees Service Fees Fines and Fees Investment Earnings Miscellaneous TOTAL REVENUES EXPENDITURES Current: General Government Public Safety Parks and Recreation Cultural Administration Capital Outlay TOTAL EXPENDITURES Excess (Deficiency) of Revenues Over (Under) Expenditures OTHER FINANCING SOURCES (USES) Transfers In Transfers Out TOTAL OTHER FINANCING SOURCES (USES) Net Change in Fund Balance Fund Balances, Beginning Special Revenue Funds Hotel Occupancy Park Tree Fund Fund Mitigation $ 552,570 $ - $ - - 198,150 241,273 390 34 - 2,781 229 552,960 200,965 241,502 134,311 - - 12,840 39,956 145,385 - - 279,696 12,840 39,956 273,264 188,125 201,546 (227,916) - - (227,916) - - 45,348 188,125 201,546 470,250 4,023 1.57,659 Fund Balances, Ending $ 515,598 $ 192,148 $ 359,205 m Special Revenue Funds Police Library Parks & Historical Forfeitures Advisory Recreation Committee Fund Board Foundation Fund Totals - $ - $ - $ - $ 552,570 - 439,423 21,686 149,427 - 171,113 37,749 - - - 37,749 322 59 48 - 853 - 51 77,979 161 81,201 38,071 21,796 227,454 161 1,282,909 - - - 2,577 136,888 11,049 - - - 11,049 - - 184,465 - 237,261 21,257 - - 21,257 - - - 145,385 - - 86,606 - 86,606 11,049 21,257 271,071 2,577 638,446 27,022 539 (43,617) (2,416) 644,463 23,500 2,421 25,921 (33,229) - - - (261,145) (33,229) - 23,500 2,421 (235,224) (6,207) 539 (20,1.1.7) 5 409,239 395,587 67,992 132,624 9,562 1,237,697 $ 389,380 $ 68,531 $ 112,507 $ 9,567 $ 1,646,936 Is CITY OF SCHERTZ, TEXAS SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET TO ACTUAL HOTEL OCCUPANCY FUND FOR THE YEAR ENDED SEPTEMBER 30, 2014 (WITH COMPARATIVE ACTUAL TOTALS FOR 2013) . Excess (Deficiency) of Revenues Over (Under) Expenses 115,912 115,912 273,264 157,352 160,915 OTHER FINANCING SOURCES (USES) Transfers Out (138,650) (289,722) (227,916) 61,806 (81,226) TOTAL OTHER FINANCING SOURCES (USES) (138,650) (289,722) (227,916) 61,806 (81,226) Net Change in Fund Balance (22,738) (173,810) 45,348 219,158 79,689 FUND BALANCE, BEGINNING 470,250 470,250 470,250 - 390,561 FUND BALANCE, ENDING $ 447,512 $ 296,440 $ 515,598 $ 219,158 $ 470,250 m Variance with 2014 Final Budget- 2013 Budgeted Amounts Actual Positive Actual Original Final Amounts (Negative) Amounts REVENUES Occupancy Tax $ 485,000 $ 485,000 $ 552,570 $ 67,570 $ 503,267 Investment Earnings 550 550 390 (160) 512 TOTAL REVENUES 485,550 485,550 552,960 67,410 503,779 EXPENDITURES Current: General Government 204,253 204,253 134,311 69,942 185,347 Administration 145,385 145,385 145,385 - 157,517 Capital Outlay 20,000 20,000 - 20,000 - TOTAL EXPENDITURES 369,638 369,638 279,696 89,942 342,864 Excess (Deficiency) of Revenues Over (Under) Expenses 115,912 115,912 273,264 157,352 160,915 OTHER FINANCING SOURCES (USES) Transfers Out (138,650) (289,722) (227,916) 61,806 (81,226) TOTAL OTHER FINANCING SOURCES (USES) (138,650) (289,722) (227,916) 61,806 (81,226) Net Change in Fund Balance (22,738) (173,810) 45,348 219,158 79,689 FUND BALANCE, BEGINNING 470,250 470,250 470,250 - 390,561 FUND BALANCE, ENDING $ 447,512 $ 296,440 $ 515,598 $ 219,158 $ 470,250 m CITY OF SCHERTZ, TEXAS SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET TO ACTUAL PARK FUND FOR THE YEAR ENDED SEPTEMBER 30, 2014 (WITH COMPARATIVE ACTUAL TOTALS FOR 2013) Excess (Deficiency) of Revenues Over (Under) Expenditures 110,300 110,300 188,125 Variance with OTHER FINANCING USES 2014 Final Budget- 2013 - Budgeted Amounts Actual Positive Actual - Original Final Amounts (Negative) Amounts REVENUES FUND BALANCE, BEGINNING 4,023 4,023 4,023 - (38,724) Licenses and Permits $ 150,000 $ 150,000 $ 198,150 $ 48,150 $ 192,000 Investment Earnings 300 300 34 (266) 225 Miscellaneous - - 2,781 2,781 - TOTAL REVENUES 150,300 150,300 200,965 50,665 192,225 EXPENDITURES Current: Parks and Recreation - 12,840 12,840 (12,840) 10,594 Capital Outlay 40,000 27,160 - 40,000 - TOTAL EXPENDITURES 40,000 40,000 12,840 27,160 10,594 Excess (Deficiency) of Revenues Over (Under) Expenditures 110,300 110,300 188,125 77,825 181,631 OTHER FINANCING USES Transfers Out - - - - (138,884) TOTAL OTHER FINANCING - - - - (138,884) Net Change in Fund Balance 110,300 110,300 188,125 77,825 42,747 FUND BALANCE, BEGINNING 4,023 4,023 4,023 - (38,724) FUND BALANCE, ENDING $ 114,323 $ 114,323 $ 192,148 $ 77,825 $ 4,023 M CITY OF SCHERTZ, TEXAS SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET TO ACTUAL TREE MITIGATION FUND FOR THE YEAR ENDED SEPTEMBER 30, 2014 (WITH COMPARATIVE ACTUAL TOTALS FOR 2013) IN Variance with 2014 Final Budget- 2013 Budgeted Amounts Actual Positive Actual Original Final Amounts (Negative) Amounts REVENUES Licenses and Permits $ 35,000 $ 35,000 $ 241,273 $ 206,273 $ 19,173 Miscellaneous 200 200 229 29 1,842 TOTAL REVENUES 35,200 35,200 241,502 206,302 21,015 EXPENDITURES Current: Parks and Recreation 139,525 139,525 39,956 99,569 57,730 Capital Outlay - - - - 23,226 TOTAL EXPENDITURES 139,525 139,525 39,956 99,569 80,956 Net Change in Fund Balance (104,325) (104,325) 201,546 305,871 (59,941) FUND BALANCE, BEGINNING 157,659 157,659 157,659 - 217,600 FUND BALANCE, ENDING $ 53,334 $ 53,334 $ 359,205 $ 305,871 $ 157,659 IN CITY OF SCHERTZ, TEXAS SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET TO ACTUAL POLICE FORFEITURES FUND FOR THE YEAR ENDED SEPTEMBER 30, 2014 (WITH COMPARATIVE ACTUAL TOTALS FOR 2013) . REVENUES Fines and Fees Investment Earnings TOTAL REVENUES EXPENDITURES Current: Public Safety Capital Outlay TOTAL EXPENDITURES Excess (Deficiency) of Revenues Over (Under) Expenditures OTHER SOURCES (USES) Transfers Out TOTAL OTHER SOURCES Net Change in Fund Balance FUND BALANCE, BEGINNING FUND BALANCE, ENDING Variance with 2014 Final Budget- 2013 Budgeted Amounts Actual Positive Actual Original Final Amounts (Negative) Amounts $ 52,800 $ 52,800 $ 37,749 $ (15,051) $ 56,919 600 600 322 (278) 550 53,400 53,400 38,071 (15,329) 57,469 - - 11,049 (11,049) - 50,000 50,000 - 50,000 - 50,000 50,000 11,049 38,951 - 3,400 3,400 1 27,022 23,622 57,469 - 33,229 (33,229) (66,458) - - 33,229 (33,229) (66,458) - 3,400 36,629 (6,207) (42,836) 57,469 395,587 1 395,587 395,587 - 338,118 $ 398,987 $ 432,21.6 $ 389,380 $ (42,836) $ 395,587 m' CITY OF SCHERTZ, TEXAS SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET TO ACTUAL LIBRARY ADVISORY BOARD FOR THE YEAR ENDED SEPTEMBER 30, 2014 (WITH COMPARATIVE ACTUAL TOTALS FOR 2013) EXPENDITURES Current: Cultural 34,500 34,500 21,257 1.3,243 1.0,446 TOTAL EXPENDITURES 34.500 34.500 21,257 1.3,243 10.446 Net Change in Fund Balance (9,240) (9,240) 539 Variance with FUND BALANCE, BEGINNING 67,992 67,992 67,992 2014 Final Budget- 2013 $ 58,752 Budgeted Amounts Actual Positive Actual Original Final Amounts (Negative) Amounts REVENUES Service Fees $ 21,200 $ 21,200 $ 21,686 $ 486 $ 20,772 Investment Earnings 60 60 59 (1) 61 Miscellaneous 4,000 4,000 51 (3,949) 1,764 TOTAL REVENUES 25,260 25,260 21,796 (3,464) 22,597 EXPENDITURES Current: Cultural 34,500 34,500 21,257 1.3,243 1.0,446 TOTAL EXPENDITURES 34.500 34.500 21,257 1.3,243 10.446 Net Change in Fund Balance (9,240) (9,240) 539 9,779 12,151 FUND BALANCE, BEGINNING 67,992 67,992 67,992 - 55,841 FUND BALANCE, ENDING $ 58,752 $ 58,752 $ 68,531 $ 9,779 $ 67,992 .E CITY OF SCHERTZ, TEXAS SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET TO ACTUAL HISTORICAL COMMITTEE FUND FOR THE YEAR ENDED SEPTEMBER 30, 2014 (WITH COMPARATIVE ACTUAL TOTALS FOR 2013) REVENUES Sale of Merchandise TOTAL REVENUES EXPENDITURES Current General Government TOTAL EXPENDITURES Excess (Deficiency) of Revenues Over (Under) Expenditures Budgeted Amounts Original Final $ 500 $ 500 $ 5,650 5,650 2,577 3,073 5,650 5,650 2,577 3,073 2013 Actual 162 (5,150) (5,1.50) (2,416) 2,734 (737) OTHER FINANCING SOURCES (USES) Transfers In 5, 150 5,150 2,421 (2,729) 732 TOTAL OTHER FINANCING SOURCES (USES) 5,150 5,150 2,421 (2,729) 732 Net Change in Fund Balance - - 5 5 (5) FUND BALANCE, BEGINNING Variance with 2014 Final Budget - Actual Positive Amounts (Negative) $ 9,562 $ 9,562 $ 161 $ (339) $ 161 (339) _ 5,650 5,650 2,577 3,073 5,650 5,650 2,577 3,073 2013 Actual 162 (5,150) (5,1.50) (2,416) 2,734 (737) OTHER FINANCING SOURCES (USES) Transfers In 5, 150 5,150 2,421 (2,729) 732 TOTAL OTHER FINANCING SOURCES (USES) 5,150 5,150 2,421 (2,729) 732 Net Change in Fund Balance - - 5 5 (5) FUND BALANCE, BEGINNING 9,562 9,562 9,562 - 9,567 FUND BALANCE, ENDING $ 9,562 $ 9,562 $ 9,567 $ 5 $ 9,562 81 CITY OF SCHERTZ, TEXAS SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET TO ACTUAL PARKS AND RECREATION FOUNDATION FOR THE YEAR ENDED SEPTEMBER 30, 2014 (WITH COMPARATIVE ACTUAL TOTALS FOR 2013) REVENUES Charges and Fees at Events Investment Earnings Miscellaneous Income and Donations TOTAL REVENUES EXPENDITURES Current Parks and Recreation Capital Outlay TOTAL EXPENDITURES Excess (Deficiency) of Revenues Over (Under) Expenditures OTHER FINANCING SOURCES (USES) Transfers In TOTAL OTHER FINANCING SOURCES (USES) Net Change in Fund Balance FUND BALANCE, BEGINNING FUND BALANCE, ENDING Budgeted Amounts Original Final 2014 Actual Amounts Variance with Final Budget- 2013 Positive Actual (Negative) Amounts $ 238,000 $ 238,000 $ 149,427 $ (88,573) $ 176,776 50 50 48 (2) 117 32,300 32,300 77,979 45,679 117,515 270,350 270,350 227,454 (42,896) 294,408 275,250 275,250 184,465 90,785 223,281 - - 86,606 (86,606) 101,402 275,250 275,250 271,071 4,179 324,683 (4,900) (4,900) (43,617) (38,717) (30,275) 23,500 23,500 23,500 - 20,000 23,500 23,500 23,500 - 20,000 18,600 18,600 (20,117) (38,717) (10,275) 132,624 132,624 132,624 - 142,899 $ 151,224 $ 151,224 $ 112,507 $ (38,717) $ 132,624 MN STATISTICAL SECTION This part of the City of Schertz's 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 City's overall financial health. Financial Trends (Tables I through 4) Net Position by Component Change in Net Position Fund Balances, Governmental Funds Changes in Fund Balances, Governmental Funds These schedules contain trend information to help reader understand how the City's financial performance and well -being have changed over time. Revenue Capacity (Tables S through 12) Tax Revenues by Source, Governmental Funds Total Water and Sewer Consumption and Rates Principal Water and Sewer Consumers Assessed Value and Estimated Actual Value of Taxable Property Direct and Overlapping Property Tax Rates Principal Property Taxpayers Property Tax Levies and Collections Taxable Assessed Value These schedules contain information to help readers assess the factors affecting the City's ability to generate its property and sales tax. Debt Capacity (Tables 13 through 17) Ratios of Outstanding Debt by Type Ratios of General Bonded Debt Outstanding Direct and Overlapping Governmental Activities Debt Debt Margin Information Pledged Revenue Coverage These schedules present information to help the reader assess the affordability of the City's current levels of outstanding debt and the City's ability to issue additional debt in the, future. Demographic and Economic Information (Tables 18 through 19) Demographic and Economic Statistics Principal Employers These schedules offer demographic and economic indicators to help the reader understand how the City's financial activities take place and to help make comparisons over time and with other governments. Operating Information (Tables 20 through 22) Full -time Equivalent City Government Employees by Function Operating Indicators by Function/Program Capital Asset Statistics by Function/Program These schedules contain information about the City's operations and resources to help the reader understand how the City's financial information relates to the services the City provides and the activities it performs. CITY OF SCHERTZ, TEXAS NET POSITION, BY COMPONENT LAST TEN FISCAL YEARS Business -Type Activities Net Investment in Capital Assets $ Fiscal Year $ 24,783,839 2004 2005 2006 2008 Governmental Activities 428,712 1,253,711 Net Investment in Capital Assets $ 1.7,699,797 $ 13,257,031 $ 32,932,355 $ 47,327,175 Restricted 4,813,496 15,888,549 663,973 1,058,514 Unrestricted 8,014,574 1.0,373,267 13,763,070 11,029,326 Total Governmental Activities Net Position $ 30,527,867 $ 39,518,847 $ 47,359,398 $ 59,415,015 Business -Type Activities Net Investment in Capital Assets $ 24,970,976 $ 24,783,839 $ 18,788,933 $ 41,350,184 Restricted 428,712 1,253,711 1,995,213 - Unrestricted 5,377,968 9,879,126 23,658,181 10,286,447 Total Business -Type Activities Net Position $ 30,777,656 $ 35,916,676 $ 44,442,327 $ 51,636,631 Primary Government Net Investment in Capital Assets $ 42,670,773 $ 38,040,870 $ 51,721,288 $ 88,677,359 Restricted 5,242,208 17,142,260 2,659,186 1,058,514 Unrestricted 1.3,392,542 20,252,393 37,421,251 21,31.5,773 Total Primary Government Net Position $ 61,305,523 $ 75,435,523 $ 91,801,725 $ 111,051,646 ., TABLE 1 Fiscal Year 2009 2010 2011 2012 2013 2014 $ 57,324,482 $ 54,010,139 $ 55,415,699 $ 56,616,809 $ 57,543,618 $ 62,792,671 1,170,786 897,324 2,089,971 1,917,098 7,788,354 10,401,728 3,650,287 7,548,859 7,370,101 8,907,326 6,645,418 8,613,239 $ 62,145,555 $ 62,456,322 $ 64,875,771 $ 67,441,233 $ 71,977,390 $ 81,807,638 $ 50,047,301 $ 50,778,490 $ 51,838,589 $ 50,161,157 $ 53,071,836 $ 53,674,437 3,633,244 4,217,098 7,441,722 11,577,645 11,902,282 16,450,988 $ 53,680,545 $ 54,995,588 $ 59,280,311 $ 61,738,802 $ 64,974,118 $ 70,1.25,425 $ 107,371,783 $ 104,788,629 $ 107,254,288 $ 106,777,966 $ 110,615,454 $ 116,467,108 1,170,786 897,324 2,089,971 1,917,098 7,788,354 10,401,728 7,283,531 11,765,957 14,81.1,823 20,484,971 18,547,700 25,064,227 $ 115,826,100 $ 117,451,910 $ 124,156,082 $ 129,180,035 $ 136,951,508 $ 151,933,063 CITY OF SCHERTZ, TEXAS CHANGE IN NET POSITION LAST TEN FISCAL YEARS Business -Type Activities Fiscal Year 11. $ 3,982,768 6,403,122 856,260 384,696 400,630 231,149 547,206 823,818 13,629,649 2007 $ 5,808,552 5,920,046 1,864,450 944,529 454,662 272,730 897,628 1,420,086 17,582,683 11: $ 7,093,762 7,227,406 2,300,425 1,184, 866 492,991 330,736 1,364,194 1,984,151 21,978,531 Water and Sewer 2005 Expenses 9,502,039 Governmental Activities EMS General Government $ 3,707,036 Public Safety 5,558,596 Public Environment 782,654 Parks and Recreation 351,627 Cultural 341,957 Health 221,950 Administration 505,757 Interest and Other Fees 862,744 Total Governmental Activities Expenses 1.2,332,321 Business -Type Activities Fiscal Year 11. $ 3,982,768 6,403,122 856,260 384,696 400,630 231,149 547,206 823,818 13,629,649 2007 $ 5,808,552 5,920,046 1,864,450 944,529 454,662 272,730 897,628 1,420,086 17,582,683 11: $ 7,093,762 7,227,406 2,300,425 1,184, 866 492,991 330,736 1,364,194 1,984,151 21,978,531 Water and Sewer 8,937,553 9,821,823 9,502,039 12,379,584 EMS 3,789,791 3,474,249 5,114,911 2,976,112 Total Business -Type Activities 12,727,344 13,296,072 14,616,950 15,355,696 Total Primary Government Expenses $ 25,059,665 $ 26,925,721 $ 32,199,633 $ 37,334,227 Program Revenues Governmental Activities Charges for Service: General Government Public Safety Parks and Recreation Cultural Health Operating Grants and Contributions Capital Grants and Contributions Total Governmental Aactivities Program Revenues Business -Type Activities Charges for Service: Water and Sewer EMS Capital Grants and Contributions Total Business -Type Activities Program Revenues Total Primary Government Program Revenues $ 1,125,236 1,475,618- 141,523 148,1.90 44,611 1,794,486 3,808,133 $ 810,142 1,684,786 143,254 151,028 44,178 1,573,944 5,382,779 $ 1,448,032 1,307,295 196,436 210,417 33,148 497,219 5,789,432 $ 1,497,472 1,643,635 155,168 219,749 41,390 595,401 12,595,635 8,537,797 9,790,111 9,481,979 16,748,450 9,308,362 11,223,658 13,007,618 13,620,440 3,443,429 3,904,818 5,017,343 3,1 50,428 2,055,366 3,148,100 2,755,376 5,190,039 14,807,1 57 $ 23,344,954 :• 1.8,276,576 $ 28,066,687 20,780,337 $ 30,262,316 21,960,907 $ 38,709,357 Fiscal Year 2009 2010 2011 2012 2013 . 2014 . $ 7,987,977 $ 7,892,516 $ 8,112,954 $ 7,802,092 $ 7,066,087 $ 6,958,530 7,755,056 7,897,298 8,390,740 9,103,676 9,567,595 10,025,703 2,740,755 2,966,642 3,152,119 3,586,087 3,622,834 3,740,538 1,193,525 1,593,075 1,673,098 1,584,605 1,807,559 1,807,136 769,928 809,323 876,339 916,967 907,676 870,159 377,125 345,455 374,516 357,658 344,647 407,114 734,584 1,084,430 1,321,055 1,117,044 1,180,656 1,942,312 1,818,984 2,230,452 2,251,472 2,302,912 3,340,951 2,352,856 23,377,934 24,819,191 26,152,293 26,771,041 27,838,005 28,104,348 1.3,568,065 1.4,434,709 15,280, 871 16,349,967 1.6,954,871 17,762,116 3,365,544 3,690,007 3,659,031 3,758,425 3,959,445 4,268,125 16,933,609 18,124,716 18,939,902 20,108,392 20,914,316 22,030,241 $ 40,311,543 $ 42,943,907 $ 45,092,195 $ 46,879,433 $ 48,752,321 $ 50,134,589 $ 1,720,279 $ 1,905,600 $ 1,495,563 $ 2,286,488 $ 2,230,800 $ 1,974,637 1,481,004 1,986,536 2,81.5,029 2,216,385 2,516,547 2,536,476 273,917 536,609 524,443 541,512 721,222 917,639 219,029 265,714 228,242 279,267 305,932 309,897 33,930 36,728 39,743 36,746 38,1.49 32,429 1,044,884 587,643 717,105 764,997 234,084 220,264 3,023,377 1,276,465 2,998,115 1,178,573 1,531,740 5,756,456 7,796,420 6,595,295 8,818,240 7,303,968 7,578,474 11,747,798 14,668,137 15,147,332 17,073,075 17,411,568 17,696,327 19,147,872 2,889,518 3,061,414 3,564,852 3,561,114 4,459,600 4,533,753 2,241,726 973,437 2,175,889 828,853 1,301,235 2,809,1.10 1.9,799,381 1.9,182,183 22,81.3,816 21,801,535 23,457,1.62 26,490,735 $ 27,595,801 $ 25,777,478 $ 31,632,056 $ 29,105,503 $ 31,035,636 $ 38,238,533 CITY OF SCHERTZ, TEXAS CHANGE IN NET POSITION (CONTINUED) LAST TEN FISCAL YEARS Fiscal Year 2005 2006 2007 2008 Net (Expenses) Revenue Governmental Activities $ (3,794,524) $ (3,839,538) $ (8,100,704) $ (5,230,081) Business -Type Activities 2,079,813 4,980,504 6,163,387 6,605,211 Total Primary Government Net Expenses $ (1,714,711) $ 1,140,966 $ (1,937,317) $ 1,375,130 Governmental Revenues and Other Changes in Net Position Governmental Activities Taxes: Ad Valorem Sales Franchise Fees Hotel /Motel Mixed Drink Bingo Unrestricted Investment Earnings Miscellaneous Transfers Total Governmental Activities Business -Type Activities Interest and Investment Earnings Miscellaneous Transfers Total Business -Type Activities Total Primary Government Changes In Net Position Government Activities Business -Type Activities Total Primary Government $ 4,908,108 $ 5,705,805 $ 7,309,127 $ 7,841,928 3,340,475 4,704,960 6,026,675 6,1 75,759 786,298 961,462 1,004,116 1,240,642 42,982 202,108 259,176 273,558 6,437 20,068 29,451 32,364 4,946 5,124 6,781 4,751 377,790 608,587 1,606,976 1,310,310 83,337 112,306 923,574 293,763 199,123 510,098 (1,224,621) - 9,749,496 12,830,518 15,941,255 17,173,075 170,610 473,205 976,595 522,595 177,554 195,409 161,048 1.79,121 (199,123) (510,098) 1,224,621 - 149,041 158,51.6 2,362,264 701,716 $ 9,898,537 $ 12,989,034 $ 18,303,519 $ 17,874,791 $ 5,954,972 $ 8,990,980 $ 7,840,551 $ 11,942,994 2,228,854 5,139,020 8,525,651 7,306,927 $ 8,183,826 $ 14,130,000 $ 16,366,202 $ 19,249,921 TABLE 2 (Continued) Fiscal Year 2009 2010 2011 2012 2013 . 2014 . $ (15,581,514) $ (18,223,896) $ (17,334,053) $ (19,467,073) $ (20,259,531) $ (16,356,550) 2,865,772 1,057,467 3,873,914 1,693,143 2,542,846 4,460,494 $ (12,715,742) $ (17,166,429) $ (13,460,139) $ (17,773,930) $ (17,716,685) $ (11,896,056) $ 8,980,102 $ 9,715,645 $ 10,280,768 $ 11,298,204 $ 12,359,146 $ 12,794,172 6,017,782 6,240,749 7,054,394 7,968,212 9,637,097 10,553,382 1,462,1.99 1,448,620 1,542,046 1,647,712 1,681,079 2,073,1.62 305,073 348,147 391,181 470,290 503,267 552,570 31,790 32,144 33,630 28,586 30,421 39,917 5,105 4,651 2,173 - - - 364,648 117,776 48,235 60,265 54,270 43,279 84,748 611,510 316,840 621,560 505,268 180,316 1,060 607 15,421 84,235 (62,294) 25,140 (50,000) 18,312,054 18,534,663 19,753,502 22,032,535 24,795,688 26,186,798 128,233 36,824 37,950 36,409 53,089 31,810 110,516 236,173 457,094 666,645 664,521 609,003 (1,060,607) (1.5,421) (84,235) 62,294 (25,140) 50,000 (821,858) 257,576 410,809 765,348 692,470 690,81.3 $ 17,490,196 $ 18,792,239 $ 20,164,311 $ 22,797,883 $ 25,488,158 $ 26,877,611 $ 2,730,540 $ 310,767 $ 2,419,449 $ 2,565,462 $ 4,536,157 $ 9,830,248 2,043,914 1,315,043 4,284,723 2,458,491 3,235,316 5,151,307 $ 4,774,454 $ 1,625,810 $ 6,704,172 $ 5,023,953 $ 7,771,473 $ 14,981,555 .. CITY OF SCHERTZ, TEXAS FUND BALANCES - GOVERNMENTAL FUNDS LAST TEN FISCAL YEARS Nonspendable Fund Balance: Inventory Prepaid Items Note Receivable Total Nonspendable Fund Balance Restricted Fund Balance: Police and Public Safety Municipal Court PEG Capital Fees Capital Improvement Debt Service Tourism Development Tree Mitigation Parks Historical Committee & Library Economic Development Corporation Scholarships Total Restricted Fund Balance Committed Fund Balance: Capital Improvement Total Assigned Fund Balance Assigned Fund Balance: Property Replacement Special Events Capital Improvement Recycling Historical Committee Youth Activities Total Assigned Fund Balance Unassigned Fund Balance Total Governmental Funds •E Fiscal Year 2005 2006 2007 2008 $ 10,571 $ 16,706 $ 67,333 $ 46,014 10,571 16,706 67,333 46,014 327,21.2 304,378 352,791 394,122 - 205,344 191,663 269,961 5,135,834 15,134, 814 17,612,092 16,416,440 263,740 347,739 556,884 429,289 187,953 378,823 470,743 502,883 326,267 343,091 271,071 271,071 236,400 286,072 180,223 169,529 25,317 36,261 46,784 68,207 930,697 1,450,801 2,014,135 2,331,951 7,433,420 18,487,323 21,696,386 20,853,453 - - 579,708 400,247 - - 127,500 88,778 10,009 12,733 6,780 1.4,748 10,009 12,733 713,988 503,773 4,864,647 7,202,709 8,876,682 5,269,890 $ 12,318,647 $ 25,719,471 $ 31,354,389 $ 26,673,130 •E TABLE 3 Fiscal Year 1/1/1(1 1/11 /1 1/11 i 1m 1 1m '1m A $ 44,217 $ 46,473 $ 43,504 $ 63,556 $ 50,768 $ 88,518 - - - 2,367 754,443 21,735 - 150,000 120,080 120,080 120,080 - 44,217 1.96,473 1.63,584 186,003 925,291 110,253 355,451 421,265 403,799 338,11.8 496,890 529,264 332,117 402,744 459,244 527,513 646,422 628,459 - - 317,453 409,870 456,175 489,509 14,342,553 3,914,323 10,219,300 17,104,595 15,360,800 9,600,028 444,369 286,215 117,250 227,674 517,199 625,435 180,710 250,379 301,517 390,561 470,250 501,996 191,834 164,424 173,999 217,600 157,659 359,205 120,501 79,317 84,329 90,718 136,647 304,655 163,661 200,359 231,686 65,409 77,554 78,098 2,543,010 3,548,067 3,394,850 4,366,005 6,022,128 7,792,578 - - - - - 54,1.76 18,674,206 9,267,093 15,703,427 23,738,063 24,341,724 20,963,403 - - - - 165,000 31,718 - - - - 165,000 31,718 201,850 202,341 202,723 322,656 456,034 694,916 62,263 142,465 93,447 92,555 99,770 31,177 - - 162,113 243,546 145,167 - 10,149 9,940 9,940 - - - - - - 11,090 - - 274,262 354,746 468,223 669,847 700,971 726,093 1,209,451 1,372,779 1,899,105 2,560,667 4,206,734 5,587,262 $ 20,202,136 $ 11,191,091 $ 18,234,339 $ 27,154,580 $ 30,339,720 $ 27,418,729 91 CITY OF SCHERTZ, TEXAS CHANGES IN FUND BALANCES, GOVERNMENTAL FUNDS LAST TEN FISCAL YEARS REVENUES Taxes Permits and Fees Service Fees Fines and Fees Intergovernmental Other Revenue TOTAL REVENUES EXPENDITURES Current: General Government Public Safety Public Environment Parks and Recreation Cultural Health Administration Capital Outlay Debt Service: Principal Interest and Fiscal Charges Bond Issue Costs TOTAL EXPENDITURES Excess (Deficiency) of Revenues Over (Under) Expenditures OTHER FINANCING SOURCES (USES) Proceeds from Bonds & Debt Issuances Premium (Discount) on Bond Issue Payment to Refund Agent Transfers In Transfers (Out) TOTAL OTHER FINANCING SOURCES (USES) NET CHANGE IN FUND BALANCE Debt Service as a percentage of Noncapital Expenditures Fiscal Year 2005 2006 2007 2008 $ 9,682,628 $ 1.2,122,079 $ 15,093,799 $ 15,583,058 1,421,575 1,475,61.9 1,062,054 992,953 424,047 1,322,743 1,230,634 1,018,197 915,704 1,157,480 1,397,101 1,387,677 961,514 26,058 267,420 4,376,072 681,140 767,075 2,510,021 1,864,877 14,086,608 16,871,054 21,561,029 25,222,834 2,758,576 2,934,800 4,994,598 6,184,705 4,542,384 5,020,684 5,665,671 6,638,352 500,880 558,020 655,930 745,307 542,621 604,521 843,870 800,079 328,331 388,679 443,455 667,995 208,499 216,655 263,918 295,156 760,905 903,154 1,115,737 1,517,785 4,360,483 6,127,735 5,504,679 19,189,505 1,236,000 885,838 16,124,517 1,499,270 1,586,092 2,025,043 799,738 1,3 80,444 1,617, 876 165,125 63,969 1.22,290 19,218,381 22,518,363 39,804,093 (2,037,909) (2,347,327) (957,334) (14,581,259) 1.5,319,996 8,306,805 9,900,000 123,057 - - 583,1.26 529,598 354,150 593,294 (934,986) (224,500) (2,068,703) (593,294) (351,860) 15,748,151 6,592,252 9,900,000 $ (2,389,769} $ 13,400,824 $ 5,634,918 $ (4,681,259) 18.0% 92 17.6% 16.1% 14.6% l Fiscal Year 2009 2010 2011 2012 2013 2014 $ 16,786,590 $ 17,811,547 $ 19,309,675 $ 21,401,991 $ 24,181,863 $ 26,021,730 822,105 1,160,197 1, 776, 292 1,363,461 1,609,954 1,805,047 973,781 1,492,130 1,645, 489 1,547,007 1,739,387 1,763,964 1,51.7,821 1,655,183 1,452,610 2,027,613 1,927,744 1,750,311 1,444,966 570,386 1,21.6,211 1,000,413 492,332 221,769 1,066,097 1,161,182 603,498 969,921 767,11.0 671,731 22,611,360 23,850,625 26,003,775 28,310,406 30,718,390 32,234,552 6,765,315 6,989,561 7,164,667 7,094,834 6,311,276 5,981,439 7,235,501 7,409,720 7,885,119 8,690,849 9,113,840 9,409,894 884,158 816,939 846,150 976,327 951,528 1,012,607 869,166 1,1 78,455 1,195,171 1,398,692 1,412,329 1,338,232 821,048 872,668 937,611 845,124 840,595 815,691 348,448 331,860 360,746 346,318 341,961 394,918 941,675 1,251,368 1,506,831 1,249,557 1,289,078 2,270,041 14,963,950 11,347,876 2,956,511 1,299,843 3,277,397 8,000,467 4,816,928 1,893,086 2,371,070 2,704,898 3,217,325 3,695,597 1,987,384 2,183,852 2,066,221 2,313,510 2,381,171 2,108,610 191,066 20,000 244,237 254,971 31,750 165,650 39,824,639 34,295,385 27,534,334 27,174,923 29,168,250 35,193,146 (17,213,279) (10,444,760) (1,530,559) 1,135,483 1,550,140 (2,958,594) 9,681,678 1,418,294 8,206,572 1.4,370,000 1,635,000 8,583,71.5 - - 283,000 175,473 - 686,137 - - - (6,698,421) - (9,182,250) 2,778,593 242,539 348,846 139,635 788,084 1,243,833 (1,71.7,986) (227,118) (264,611) (201,929) (788,084) (1,293,832) 10,742,285 1,433,715 8,573,807 7,784,758 1,635,000 37,603 $ (6,470,994) $ (9,011,045) $ 7,043,248 $ 8,920,241 $ 3,185,140 $ (2,920,991) 26.1% 17.7% 17.4% 19.5% 21.6% 21.3% 93 CITY OF SCHERTZ, TEXAS TAX REVENUE BY SOURCE — GOVERNMENTAL FUNDS LAST TEN FISCAL YEARS Fiscal Year Property Sales & Use Franchise 2014 $ 12,802,668 $ 10,553,382 $ 2,073,162 2013 12,329,999 9,637,097 1,681,079 2012 11,287,191 7,968,212 1,647,712 2011 10,286,251 7,054,394 1,542,046 2010 9,737,236 6,240,749 1,448,620 2009 8,964,642 6,017,781 1,462,199 2008 7,855,984 6,175,759 1,240,642 2007 7,767,600 6,026,675 1,004,116 2006 6,261,532 4,671,785 961,462 2005 5,501,490 3,340,475 786,298 •, Mixed Hotel Total Beverage Bingo Occupancy Revenue $ 39,917 $ 31 $ 552,570 $ 26,021,730 30,421 - 503,267 24,181,863 28,586 - 470,290 21,401,991 33,630 2,173 391,181 19,309,675 32,144 4,651 348,147 17,811,547 31,790 5,105 305,073 16,786,590 32,364 4,751 273,558 15,583,058 29,451 6,781 259,176 15,093,799 20,068 5,124 202,108 12,122,079 6,437 4,946 42,982 9,682,628 CITY OF SCHERTZ, TEXAS TOTAL WATER AND SEWER CONSUMPTION AND RATES LAST TEN FISCAL YEARS Fiscal Year Ended September 30, 2014 2013 . 2012 2011 2010 2009 2008 2007 2006 2005 Total Water & Sewer Consumption (In Gallons) 1,549,888,700 1,550,039,700 1,604,952,300 1,676,323,900 1,231,376,600 1,511,567,900 855,779,200 614,508,100 714,230,400 528,766,500 a Water & Sewer Base Rate 19.32 18.94 18.94 18.94 18.94 18.94 15.94 15.94 15.94 15.94 Water & Sewer Initial Rate Per 1,000 Gallons $ 2.39 2.34 2.34 2.34 2.25 2.16 1.92 1.72 1.69 1.52 CITY OF SCHERTZ, TEXAS PRINCIPAL WATER AND SEWER CONSUMERS CURRENT YEAR AND NINE YEARS AGO w 2014 2005 Total Percentage of Total Percentage of Water Total City Water Total City Consumption Water Consumption Water Consumers (in Gallons) Rank Consumption (in Gallons) Rank Consumption SYSCO 23,384,500 1 1.51% Caterpillar Inc. 20,741,100 2 1.34% Sycamore Creek Apartments 10,869,700 3 0.70% Waterford Ridge Apartments 9,537,700 4 0.61% Beck Readymix 9,366,900 5 0.60% 4,930,800 1 0.88% Ray D. Corbett Jr High School 8,695,600 6 0.56% Big Time Management Properties 8,200,700 7 0.53% Pecan Grove TX LLC 7,725,100 8 0.50% 2,176,000 3 0.39% Val Verde 6,301,600 9 0.41% 1,787,900 6 0.32% YMCA /Splash Pad 5,281,200 10 0.34% Wal -mart Supercenter 3,052,600 2 0.54% Sprint PCS 2,073,200 4 0.37% Manco Structures LTD 1,812,600 5 0.32% H2 Auto Inc. 1,623,700 7 0.29% Diamond Shamrock 1,542,400 8 0.27% The Oak at Green Valley 1,365,300 9 0.24% Republic Beverage Company 1,340,800 10 0.24% TOTAL 110,104,100 7.09% 21,705,300 3.85% Total City Water Consumption 1,552,387,300 563,511,000 w CITY OF SCHERTZ, TEXAS ASSESSED VALUE AND ESTIMATED ACTUAL VALUE OF TAXABLE PROPERTY LAST TEN FISCAL YEARS Fiscal Year Ended September 30, 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 Total Taxable Assessed Value Total Direct Tax Rate 2,752,562,574 0.4974 2,600,365,551 0.4999 2,41 1,270,623 0.4843 2,363,893,708 0.4493 2,342,355,490 0.4342 2,230,825,045 0.4090 2,221,073,744 0.4090 1,893,240,916 0.4317 1,621,059,759 0.3977 1,444,991,860 0.3760 Source: Bexar, Comal and Guadalupe County Appraisal Districts NOTES: Property in the City of Schertz is reassessed every year at estimated actual value. For this reason, assessed value is equal to estimated actual value. Tax rates are per $100 of assessed value. Total taxable assessed value is before any applicable fi°eeze adjustments. .m Source NOTE: CITY OF SCHERTZ, TEXAS DIRECT AND OVERLAPPING PROPERTY TAX RATES LAST TEN FISCAL YEARS (UNAUDITED) Overlapping Counties Bexar Comal Guadalupe Fiscal Hospital River Year County District Authority Community College District County County 2013 . City Direct Rates 0.2762 Overlapping School Districts 0.3504 0.3999 2013 0.3269 Schertz - 0.01.74 0.1.492 0.3504 0.4036 2012 Cibolo- 0.2762 Fiscal Basic Debt 0.4036 Universal Coma] Year Rate Service Total City ISD ISD 0.3269 2014 0.3010 0.1964 0.4974 1.4900 1.4300 2013 0.2993 0.2006 0.4999 1.4600 1.4300 2012 0.2993 0.1850 0.4843 1.4350 1.4300 2011 0.2993 0.1.500 0.4493 1.4350 1.3700 2010 . 0.2842 0.1500 0.4342 1.4200 1.31.00 2009 0.2590 0.1.500 0.4090 1.3850 1.3100 2008 0.2590 0.1500 0.4090 1.31.50 1.31.00 2007 0.2805 0.1.512 0.4317 1.6100 1.6400 2006 0.3005 0.0972 0.3977 1.7200 1.8000 2005 0.2888 0.0872 0.3760 1.7400 1.8200 Overlapping Counties Bexar Comal Guadalupe Fiscal Hospital River Year County District Authority Community College District County County 2013 . 0.3269 0.2762 0.01.78 0.1492 0.3504 0.3999 2013 0.3269 0.2762 0.01.74 0.1.492 0.3504 0.4036 2012 0.3269 0.2762 0.01.74 0.1416 0.3504 0.4036 2011 0.3269 0.2762 0.0167 0.1416 0.3340 0.3999 2010 0.3269 0.2662 0.0160 0.1359 0.3130 0.3895 2009 0.3269 0.2610 0.0160 0.1359 0.3080 0.3895 2008 0.3269 0.2374 0.0160 0.1346 0.3180 0.3895 2007 0.3269 0.2439 0.0160 0.1371 0.3152 0.4031 2006 0.3312 0.2439 0.0164 0.1.071 0.3537 0.4031. 2005 0.3312 0.2439 0.0164 0.1071 0.3337 0.4031 Bexar, Comal and Guadalupe County Tax Offices Overlapping rates are those of local and county governments that apply within the City of Schertz. Not all overlapping rates apply to all City of Schertz property owners. •• CITY OF SCHERTZ, TEXAS PRINCIPAL PROPERTY TAX PAYERS CURRENT YEAR AND NINE YEARS AGO Source: Bexar, Comal and Guadalupe County Appraisal Districts •• 2014 2005 Percentage Percentage of of Total City Total City Taxable Taxable Taxable Taxable Assessed Assessed Assessed Assessed Taxpayer Value Rank Value Value Rank Value Caterpillar Inc. $ 105,162,397 1 3.82% SYSCO San Antonio, Inc. 95,931,063 2 3.49% Republic Beverage Co. Distribution 46,370,700 3 1.68% Capital Group Companies, Inc 37,581,105 4 1.37% San Antonio MTA LP 22,907,035 5 0.83% $ 28,007,240 1 1.94% SC Schertz LLC 16,240,300 6 0.59% GE Oil & Gas Inc. 16,011,420 7 0.58% Wal -Mart Real Estate Business Trust 13,239,871 8 0.48% H.E.Butt Grocery Co. 11,650,124 9 0.42% 9,793,856 6 0.68% EM Limited Partnership 9,922,009 10 0.36% Block Distributing, Inc. 19,686,530 2 1.36% Sprint Spectrum, LP 13,846,660 3 0.96% Verde Tri County, LTD 12,570,214 4 0.87% Eye Care Centers of America, Inc. 11,081,946 5 0.77% Prologis North American Properties 8,157,730 7 0.56% Atlantic Financial Group LTD 8,072,983 8 0.56% Wal -Mart Real Estate Business Trust 7,897,206 9 0.55% Legacy Oaks Apartments, Ltd. 7,693,601 10 0.53% TOTALS $ 375,016,024 13.62% $ 126,807,966 8.78% TOTAL TAXABLE ASSESSED VALUE $ 2,752,562,574 $ 1,444,991,860 Source: Bexar, Comal and Guadalupe County Appraisal Districts •• CITY OF SCHERTZ, TEXAS PROPERTY TAX LEVIES AND COLLECTIONS LAST TEN FISCAL YEARS (UNAUDITED) Source: Guadalupe County Tax Office 100 Total Collections Collected Within Fiscal Year Taxes Levied Fiscal Year of Levy Ended for the Levy % of September 30, Fiscal Year Amount Levy 99.35% 2014 $ 13,383,759 $ 13,297,258 99.35% 2013 12,536,540 12,455,336 99.35% 2012 11,239,572 11,159,974 99.29% 2011 9,978,430 9,895,240 99.17% 2010 9,639,945 9,559,899 99.17% 2009 8,800,927 8,703,978 98.90% 2008 7,793,405 7,711 ,714 98.95% 2007 7,048,818 6,957,827 98.71% 2006 5,645,611 5,576,559 98.78% 2005 4,858,508 4,796,062 98.71% Source: Guadalupe County Tax Office 100 Total Collections Collections In To Date Subsequent % of Years Amount Levy $ - $ 13,297,258 99.35% 19,539 12,455,336 99.35% 67,632 11,159,974 99.29% 70,941 9,895,240 99.17% 68,763 9,628,662 99.88% 85,940 8,789,918 99.87% 74,257 7,785,971 99.90% 80,601 7,038,428 99.85% 63,505 5,640,064 99.90% 58,564 4,854,626 99.92% CITY OF SCHERTZ, TEXAS TAXABLE ASSESSED VALUE LAST TEN FISCAL YEARS (UNAUDITED) Fiscal Year Taxable Total Taxable Total Ended Value Residential Commercial Tax - Exempt Other Assessed Direct September 30, January 1, Property Property Property Property Value* Tax Rate 2014 2013 $ 1,445,731,509 $ 1,540,565,195 $ (340,747,650) $ 107,013,520 $ 2,752,562,574 0.4974 2013 2012 1,383,423,359 1,396,349,905 (285,245,142) 105,837,429 2,600,365,551 0.4999 2012 2011 1,337,223,390 1,233,687,039 (262,591,896) 102,952,090 2,411,270,623 0.4843 2011 2010 1,272,970,256 1,253,600,729 (280,015,063) 117,337,786 2,363,893,708 0.4493 2010 2009 1,234,950,439 1,237,284,878 (251,217,268) 121,337,441 2,342,355,490 0.4342 2009 2008 1,169,845,869 1,191,387,341 (248,544,582) 118,136,417 2,230,825,045 0.4090 2008 2007 1,096,587,777 1,276,925,393 (345,068,394) 192,628,968 2,221,073,744 0.4090 2007 2006 990,263,111 1,033,634,277 (271,404,640) 140,748,168 1,893,240,916 0.4317 2006 2005 901,544,236 810,987,398 (182,861,671) 91,389,796 1,621,059,759 0.3977 2005 2004 820,916,373 713,003,107 (173,247,011) 84,319,391 1,444,991,860 0.3760 *Taxable Assessed Value is before any applicable freeze adjustments. Source: Bexar, Comal, and Guadalupe County Appraisal Districts. 101 CITY OF SCHERTZ, TEXAS RATIOS OF OUTSTANDING DEBT BY TYPE LAST TEN FISCAL YEARS Governmental Activities NOTES: a Details regarding the City's outstanding debt can be found in the notes to the basic financial statements. b. See Table 18 for personal income and population data for the City. These ratios are calculated using personal income and population for the prior calendar year. 102 General Certificates Fiscal Obligation of Tax Capital Year Bonds Obligation Notes Lease 2014 $ 55,300,000 $ 543,934 $ 1,585,000 $ 123,370 2013 58,060,000 801,767 2,155,000 22,398 2012 60,205,000 1,581,300 190,000 60,190 2011 47,505,000 8,625,800 250,000 97,188 2010 37,530,000 12,415,650 310,000 133,408 2009 38,485,000 13,338,850 - - 2008 32,790,000 14,243,700 - 107,078 2007 23,950,000 15,232,893 - 215,854 2006 18,740,000 13,560,000 - 319,996 2005 4,045,000 14,250,000 160,000 - NOTES: a Details regarding the City's outstanding debt can be found in the notes to the basic financial statements. b. See Table 18 for personal income and population data for the City. These ratios are calculated using personal income and population for the prior calendar year. 102 TABLE 13 103 Business -Type Activities Certificates Public General Total Percent Revenue of Facility Obligation Capital Tax Primary of Gross Bonds Obligation Loan Bonds Lease Notes Government Income $ - $ 9,436,066 $ - $ 3,960,000 $ 347,705 $ 65,000 $ 71,361,075 6.24% 2,215,000 5,048,233 - 2,120,000 - 130,000 70,552,398 6.44% 2,355,000 5,383,700 - 2,405,000 - 190,000 72,370,190 8.08% 2,490,000 5,704,200 - 2,675,000 - 250,000 67,597,188 7.95% 5,460,000 6,149,350 - - - 310,000 62,308,408 7.28% 5,805,000 6,571,150 7,000 - - - 64,207,000 7.03% 6,230,000 6,976,300 14,000 - - - 60,361,078 7.19% 6,645,000 7,237,107 21,000 - - - 53,301,854 6.02% 7,055,000 - 28,000 - - - 39,702,996 4.82% 7,445,000 - 34,000 - - - 25,934,000 3.70% 103 CITY OF SCHERTZ, TEXAS RATIOS OF GENERAL BONDED DEBT OUTSTANDING LAST TEN FISCAL YEARS Percentage of General Bonded Debt Outstanding Value of General Certificates Capita 2.09% Fiscal Obligation of Tax 1,796 Year Bonds Obligation Notes Total 2014 $ 55,300,000 $ 543,934 $1,585,000 $ 57,428,934 2013 58,060,000 801,767 2,155,000 61,016,767 2012 60,205,000 1,581,300 190,000 61,976,300 2011 47,505,000 8,625,800 250,000 56,380,800 2010 37,530,000 12,415,650 310,000 50,255,650 2009 38,485,000 13,338,850 - 51,823,850 2008 32,790,000 14,243,700 - 47,033,700 2007 23,950,000 15,232,893 - 39,182,893 2006 18,740,000 13,560,000 - 32,300,000 2005 4,045,000 14,250,000 160,000 18,455,000 Percentage of Actual Taxable Value of Per Property Capita 2.09% 1,574 2.35% 1,698 2.57% 1,796 2.39% 1,681. 2.1.5% 1,545 2.32% 1,647 2.1.2% 1,467 2.07% 1,233 1.99% 1,027 1.28% 689 NOTE: Details regarding the City's outstanding debt can be found in the notes to the basic financial statements. See Table 8 for the City's property tax value data. City population data can be found in Table 18. 104 CITY OF SCHERTZ, TEXAS DIRECT AND OVERLAPPING GOVERNMENTAL ACTIVITIES DEBT CURRENT YEAR TABLE 15 Estimated Estimated Share of Debt Percentage Overlapping Governmental Unit Outstanding Applicable* Debt Debt repaid with property taxes: Alamo CCD $ 506,301,257 0.15% $ 759,452 Bexar County 1,023,238,620 0.15% 1,534,858 Bexar County Hospital District 721,615,000 0.15% 1,082,423 Comal County 59,095,100 3.23% 1,908,772 ComalISD 492,921,213 2.84% 13,998,962 Guadalupe County 19,181,414 18.63% 3,573,497 San Antonio River Authority 27,630,000 0.14% 38,682 Schertz- Cibolo- Universal ISD 287,979,356 52.85% 152,197,089 Subtotal, Overlapping Debt City Governmental Activities Direct Debt TOTAL NET OVERLAPPING DEBT 175,093,735 57,428,934 $ 232,522,669 NOTES: The overlapping debt was received from the Municipal Advisory Council of Texas. Details regarding the City's outstanding debt can be found in the notes to the basic financial statements. 105 CITY OF SCHERTZ, TEXAS DEBT MARGIN INFORMATION LAST TEN FISCAL YEARS Assessed Value, 2013 Tax Roll Debt Limit - Texas statues do not provide a legal debt limit for cities; however, through accepted practice a practical "economic" debt limit is considered to be 10% of the assessed value. Amount of Applicable Debt: General Bonded Debt Less Debt Service Fund Balance Total Net Debt as a Percentage of Debt Margin $ 2,752,562,574 $ 275,256,257 $ 57,428,934 (625,435) 56,803,499 $ 218,452,758 26.00% 106 Fiscal Year 2011 2012 2013 Assessed Value $ 2,363,893,708 $ 2,411,270,623 $ 2,600,365,551 Debt Limit $ 236,389,371 $ 241,127,062 $ 260,036,555 Total Net Debt Applicable to Limit 55,298,550 60,973,626 60,499,568 Total Debt Margin $ 181,090,821 $ 1.80,153,436 $ 199,536,987 2008 2009 2010 Assessed Value $ 2,221,073,744 $ 2,230,825,045 $ 2,342,355,490 Debt Limit $ 222,107,374 $ 223,082,505 $ 234,235,549 Total Net Debt Applicable to Limit 45,466,903 50,414,481 48,819,435 Total Debt Margin $ 176,640,471 $ 172,668,024 $ 185,416,114 2005 2006 2007 Assessed Value $ 1,444,991,860 $ 1,621,059,759 $ 1,893,240,916 Debt Limit $ 144,499,186 $ 162,105,976 $ 189,324,092 Total Net Debt Applicable to Limit 3,781,530 18,392,261 23,488,500 Total Debt Margin $ 140,717,656 $ 143,713,715 $ 165,835,592 106 CITY OF SCHERTZ, TEXAS PLEDGED REVENUE COVERAGE LAST TEN FISCAL YEARS NOTE: Details regarding the City's outstanding debt can be found in the notes to the basic financial statements. Operating expenses do not include depreciation, interest, amortization or joint venture expenses. 107 Water Revenue Bonds Utility Less: Net Debt Service Fiscal Service Operating Available Year Charges Expenses Revenue Principal Interest Coverage 2014 $ 19,147,872 $ 15,246,653 $ 3,901,219 $ 1,010,500 $ 426,100 2.72 2013 17,696,327 14,553,274 3,143,053 728,800 359,680 2.89 2012 17,411,568 14,185,126 3,226,442 697,100 396,968 2.95 2011 16,843,780 13,229,037 3,614,743 577,824 409,801 3.66 2010 14,993,648 12,399,880 2,593,768 615,400 502,629 3.74 2009 14,533,390 9,973,940 4,559,450 685,400 534,634 3.74 2008 13,620,440 9,040,264 4,580,176 665,400 558,569 4.86 2007 13,476,288 7,896,319 5,579,969 645,800 501,397 5.82 2006 11,289,876 6,955,000 4,334,876 390,000 354,965 5.47 2005 9,381,042 6,136,390 3,244,652 380,000 213,290 3.26 NOTE: Details regarding the City's outstanding debt can be found in the notes to the basic financial statements. Operating expenses do not include depreciation, interest, amortization or joint venture expenses. 107 CITY OF SCHERTZ, TEXAS DEMOGRAPHIC AND ECONOMIC STATISTICS LAST TEN FISCAL YEARS Sources: Population, personal income, median age and education level information provided by City Economic Development Corporation. School enrollment provided by Schertz- Cibolo - Universal City Independent School District. Unemployment data provided by the Texas Workforce Commission. 108 Education Per Capita Level In Personal Personal Median Years of School Unemployment Year Population Income Income Age Schooling Enrollment Rate 2014 36,477 $ 1,144,465,875 $ 31,375 36.9 15.4 14,515 3.2% 2013 35,929 1,095,331,494 30,486 37.1 15.4 1.4,058 5.1% 2012 34,499 895,739,206 25,964 36.8 15.4 1.3,016 5.5% 2011 33,544 850,069,800 25,342 37.8 15.4 12,533 5.6% 2010 32,523 856,236,720 26,327 34.4 15.4 12,330 5.7% 2009 31,465 913,919,790 29,046 36.5 13.9 11,700 5.1% 2008 32,057 839,701,058 26,194 35.1 14.0 10,991 5.0% 2007 31,788 885,836,196 27,867 36.3 14.0 9,470 4.0% 2006 31,452 823,539,168 26,184 36.1 18.0 8,380 4.4% 2005 26,780 701,207,520 26,184 35.1 15.9 7,712 3.6% Sources: Population, personal income, median age and education level information provided by City Economic Development Corporation. School enrollment provided by Schertz- Cibolo - Universal City Independent School District. Unemployment data provided by the Texas Workforce Commission. 108 CITY OF SCHERTZ, TEXAS TOP TEN PRINCIPAL EMPLOYERS CURRENT YEAR AND EIGHT YEARS AGO Employer Employees Schertz /Cibolo/IJC ISD 1,753 Sysco Central Texas 810 Amazon.com 674 Brandt Engineering 450 Vision Works 410 H.E.B. Grocery Co. 350 City of Schertz 345 Wal -Mart Stores 320 CST Distribution 305 Republic Beverage Company 250 Valero Diamond Distribution 5.04% Federal Express Freight Metro Ambulance LP 3 Manco Lowe's 4 5,667 2014 2007 Source: City Economic Development Corporation Note: Principal employer information is not available prior to 2007. 109 Percentage Percentage of Total City of Total City Rank Employment Employees Rank Employment 1 10.92% 1,300 1 9.47% 2 5.04% 3 4.20% 4 2.80% 5 2.55% 6 2.18% 220 4 1.60% 7 2.15% 232 3 1.69% 8 1.99% 420 2 3.06% 9 1.90% 10 1.56% 1.00 9 0.73% 167 5 1.22% 165 6 1.20% 110 7 0.80% 100 8 0.73% 83 10 0.60% 35.29% 2,897 21.11% Source: City Economic Development Corporation Note: Principal employer information is not available prior to 2007. 109 rr CITY OF SCHERTZ, TEXAS FULL -TIME EQUIVALENT CITY GOVERNMENTAL EMPLOYEES BY FUNCTION LAST TEN FISCAL YEARS 110 Full -Time Equivalent Employees as of September 30, Function 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 General Government City Manager 4 3 4 6 7 6 6 7 7 6 Court Support 4 4 4 0 0 0 0 0 0 0 Municipal Court 2 3.5 5 6 4 5 5 5 6 6 Customer Relations 0 0 2 4 4 4 4.5 4.5 4.5 4.5 Planning and Zoning 2 3 4 5 4 4 4 3 3 3 General Services 6 6.5 9 9 9.5 13.5 14.7 1.4.7 1.2.7 1.2.7 City Secretary 2 2 2 2 2 2 2 2 2 2 Public Affairs 1 1 2 3 3 3 3 4 4 4 Records Management 1.5 2 2 3 3 1 1 1 1 1 Schertz Magazine 0 0 0 0 0 0 2 2 2 2 Engineer 0 0 1 3 1 2 2 4 3 3 GIS 0 0 0 0 2 2 2 2 2 2 Information Technology 2 3 3 3 3 3 4 4 6 6 Human Resources 2 2 2 3 3 4 4 4 4 4 Accounting 5 5 5 6 6 6 6 6 6 6 Purchasing 0 0 1 2 2 5 5 5 5 5 Fleet Service 3 3 3 3 3 3 4 4 4 4 Building Maintenance 0 0 0 0 0 0 0 0 2 2 Public Safety Police 50.5 58.7 63.6 68.6 64.6 64.6 64.6 69.7 74.7 74.7 Fire 31 32 32 32 32 32 32 32 32 33 Inspections 6 6 8 8 7 6 7 7 7 8 Marshal Services 0 0 0 0 5 5 8 8 8 8 Health Animal Control 5 5 5 6 6 6 6 6 6 6.5 Parks and Culture Parks 7 7 8 8 8 8 9 9 9 9 Pools 15 12.5 12.5 0 0 0 0 0 0 0 Event Facilities 0 0 1 1 1 1 2 1 1 1 Library 8.5 9.5 9.5 10.5 11 13.5 13.5 14 14 14 Public Environment Streets 13 11 11 13 13 13 14 14 14 14 Public Works Public Works 6 6 6 6 6 5 4 4 6 6 Business Office 9 10 9 10 10 10 10 10 10 10 Water and Sewer 11 12 14 14 16 16 17 17 16 16 Drainage 4 5 5 6 7 7 7 7 8 8 EMS 22 22 23.5 30 34 34 34 35 35 36 Economic Development 2 3 3 3 4 4 3 4 4 4 TOTAL 224.5 237.7 260.1 274.1 281.1 288.6 300.3 309.9 318.9 321.4 Source: City Adopted Budgets Note: Full -time equivalent is based on the schedule hours of positions to a 40 hour work week. 110 CITY OF SCHERTZ, TEXAS OPERATING INDICATORS BY FUNCTIONTROGRAM LAST TEN FISCAL YEARS III Fiscal Year Function 2005 2006 2007 2008 2009 General Government Building Permits Issued 3,434 9,948 5,811 2,869 5,181 Schertz Tales Number of Magazines printed - - 72,000 108,000 120,000 Police CFS 12,770 16,642 25,478 37,829 36,319 Arrests 729 526 608 719 873 Traffic Violations 11,157 10,487 13,461 18,820 20,452 Accidents 1,169 1,192 1,484 1,475 1,491 Fire Number of Rescue /Other Responses 1,131 1,216 1,459 978 1,536 Number of Fire Responses 128 129 103 141 135 Number of Inspections 331 356 302 461 447 Number of Training Classes Conducted 136 136 694 595 264 Number of Pre -Plan Inspections 452 EMS Requests for Transport 4,966 5,171 6,256 6,619 7,061 Actual Transports 2,767 2,937 3,634 4,193 4,341 EMT Students - - 45 73 80 Marshal Service Warrants Issued - - 5,974 Warrants Cleared 3,836 Food Establishment Permits 134 Food Establishment Inspection 209 Foster /Adoption Inspections - - - - 34 Parks Facility Reservations 294 416 516 983 671 Community and Civic Centers Civic Center - - - - 484 Community Center Rentals - North Community Center Rentals - Animal Services Number of Animals Handled 1,804 Number of Adoptions 255 Number of Return to Owners 252 Number of Transfers - - - - 415 Library Annual Circulation 257,765 276,873 292,909 278,826 263,131 Library Visits 175,976 181,603 179,630 175,435 188,118 Library Program Attendance 5,254 5,064 6,680 7,444 10,499 Registered Users 17,101 19,342 19,595 23,327 20,360 Water New Connections 425 532 91 1,474 446 Water Main Breaks 39 46 29 72 72 Total Consumption (thousands of gallons) 11,030,621 13,322,380 11,535,927 14,460,239 15,115,679 Daily Average Consumption (thousands of gallons) 30,639 37,007 31,606 39,617 38,550 Peak Daily Consumption (thousands of gallons) 6,939 10,540 5,379 5,804 7,520 Total Customers 9,673 10,118 10,598 10,900 10,198 Average Use Per Connection 5,957 7,060 1,089 6,378 6,913 Sewer Total Customers 8,664 8,990 9,391 6,378 9,974 Facilities Maintenance Number of Buildings Maintained 9 12 14 16 19 Square Footage 89,452 111,642 127,589 135,091 166,591 Source: Various City Departments. Prior year information for some functions is not available. III 112 Fiscal Year 2010 2011 2012 2013 2014 4,806 4,950 2,643 3,054 2,869 144,000 168,000 168,000 168,000 180,000 37,269 26,205 19,434 19,894 19,067 790 762 666 800 776 19,259 13,231 20,881 19,335 15,077 1,606 1,575 1,665 1,960 1,823 1,671 1,657 1,799 2,046 1,759 76 110 74 108 110 425 616 429 332 252 107 142 168 132 125 642 536 714 729 735 7,281 7,443 7,545 8,391 8,840 4,575 4,801 4,766 5,451 5,713 80 85 79 116 87 5,444 4,141 2,888 3,344 2,354 4,023 3,985 4,118 4,687 3,781 129 118 123 127 82 202 244 180 281 218 27 18 14 24 16 719 237 234 258 301 594 354 325 444 458 635 666 816 735 437 - 241 307 288 244 2,021 1,802 1,463 1,326 1,218 249 257 291 362 309 279 313 149 231 222 451 300 312 301 316 392,528 414,074 410,312 404,691 395,998 257,235 254,934 256,349 254,633 253,237 10,610 13,767 16,035 12,581 15,048 24,628 28,589 30,475 31,658 30,759 509 439 271 168 235 25 76 52 38 45 12,313,766 16,763,239 16,131,415 15,500,413 15,497,071 33,736 45,927 44,196 42,466 42,458 7,040 11,000 9,290 9,483 10,089 10,134 12,234 12,557 12,757 13,324 5,054 5,725 5,517 5,905 5,467 9,499 10,907 10,988 11,456 11,578 19 19 19 19 19 166,591 166,591 166,591 166,591 166,591 112 CITY OF SCHERTZ, TEXAS CAPITAL ASSET STATISTICS BY FUNCTIONTROGRAM LAST TEN FISCAL YEARS 113 Fiscal Year Function 2005 2006 2007 2008 2009 Police Stations 1 1 1 1 1 Patrol Units 27 34 33 33 38 Fire Stations 2 2 2 2 2 Training Facility 1 1 1 1 - Fire Vehicles 11 12 12 14 13 EMS Ambulances 6 6 6 6 6 Marshal Service Vehicles - - - - 5 Streets Streects, paved (miles) 102 102 107 122 124 Streets, unpaved (miles) 9 9 9 7 7 Parks and Recreation Parks - Developed 7 7 7 7 11 Parks - Undeveloped 4 4 4 4 4 Playground 20 20 20 20 20 Swimming Pools 1 1 1 2 2 Baby Pools 1 1 1 2 2 Baseball /Softball Diamonds 12 12 12 12 12 Soccer Fields - - - - 12 Community Centers 1 1 1 2 2 Animal Control Control Vehicle 2 2 3 3 3 Library Facility 1 1 1 1 1 Volumes in Collection 49,289 52,818 56,282 60,650 64,400 Water Number of Reservoirs 1 1 - - - Number of Pump Stations 1 1 2 - 5 Water Mains (Miles) 166 171 177 182 188 Sewer Sanitary Sewers (Miles) 54 54 59 71 78 Storm Sewers (Miles) 4 4 6 8 9 Facilities Maintenance Vehicles 4 4 4 4 5 Generators 3 3 3 3 3 Source: Various City Departments 113 Fiscal Year TABLE 22 2010 2011 2012 2013 2014 1 1 1 1 1 40 42 42 42 42 2 2 2 2 2 13 13 13 13 15 6 6 6 7 7 7 8 8 7 7 125 132 134 137 141 7 5 5 5 5 12 17 17 13 13 4 4 4 8 8 19 15 15 16 16 2 2 2 2 2 2 2 2 2 2 12 9 9 12 12 12 12 12 12 12 4 4 4 4 4 3 3 3 3 3 1 1 1 1 1 71,929 73,904 81,468 86,221 100,478 5 5 5 5 5 190 192 192 197 199 78 84 85 87 90 9 10 10 11 11 5 5 4 5 5 3 3 3 3 3 114 rr COMPLIANCE SECTION 115 SHAREHOLDERS Nancy L Vaughan, CPA Armstrong, ughan Ass,ci to r PC Deborah E Fraser, CPA Certified Public Accountants Phil S. Vaughan, CPA 110111101 W 0191 " 01611 :11111YC�7ii. '� COMPLIANCE AND OTHER MATTERS BASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GO VERNMENT A UDITING STANDARDS To the City Council and management City of Schertz We have audited, 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, the financial statements of the governmental activities, the business -type activities, each major fund, and the aggregate remaining fund infonnation of City of Schertz as of and for the year ended September 30, 2014, and the related notes to the financial statements, which collectively comprise City of Schertz's basic financial statements, and have issued our report thereon dated March 03, 2015. Internal Control over Financial Reporting In planning and performing our audit of the financial statements, we considered City of Schertz's internal control over financial reporting (internal control) to determine the audit procedures that are appropriate in the circumstances for the purpose of expressing our opinions on the financial statements, but not for the purpose of expressing an opinion on the effectiveness of City of Schertz's internal control. Accordingly, we do not express an opinion on the effectiveness of City of Schertz's internal control. A deficiency in internal control exists when the design or operation of a control does not allow management or employees in the normal 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. A significant deficiency is a deficiency, or a combination of deficiencies, in internal control that is less severe than a material weakness, yet important enough to merit attention by those charged with governance. Our consideration of internal control over financial reporting was for 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 material weaknesses or significant deficiencies. Given these limitations, during our audit we did not identify any deficiencies in internal control over financial reporting that we consider to be material weaknesses. However, material weaknesses may exist that have not been identified. 941 West Byrd Blvd., Smite 101, - Universal City, Texas 78148 Phone: 210-658-6229 - Fax: 210 -65 - 611 - email: vaughan @avac a,com # wwwavacpa:xor 116 Compliance and Other Matters As part of obtaining reasonable assurance about whether City of Schertz's financial statements are free from 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 financial 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. We noted certain matters that we have reported to management of City of Schertz in a separate letter dated March 03, 2015. Purpose of this Report The purpose of this report is solely to describe the scope of our testing of internal control and compliance and the results of that testing, and not to provide an opinion on the effectiveness of the entity's internal control or on compliance. This report is an integral part of an audit performed in accordance with Government Auditing Standards in considering the entity's internal control and compliance. Accordingly, this communication is not suitable for any other purpose. Armstrong, Vaughan & Associates, P.C. March 03, 2015 117 rr