Loading...
HomeMy WebLinkAboutFY 1990-1991 -- Comprehensive Annual Financial Report' i I C I TY 0 F C 0 LL E G E ST AT I 0 N, T EX AS COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 PREPARED BYTHE CITY OF COLLEGE STATION FINANCE DEPARTMENT GLENN SCHROEDER, EXECUTIVE DIRECTOR FOR FISCAL ANO HUMAN RESOURCES KATHLEEN HUBBARD, CHIEF ACCOUNTANT CITY OF COLLEGE STATION. TEXAS COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 TABLE OF CONTENTS INTRODUCTORY SECTION: Letter of Transmittal GFOA Certificate of Achievement for Excellence in Financial Reporting Organizational Chart Principal City Officials FINANCIAL SECTION: Independent Auditors' Report �eneral Purpose Financial Statements for the Fiscal Year Ended September 30, 1991 : Combined Balanc e Sheet -All Fund Types and Account Groups Combined Statement of Revenues, Expenditures and Changes in Fund Balances -All Governmental Fund Types Combined Statement of Revenues, Expenditures and Changes in Fund Balances -Budget and Actual (Budgetary Basis) -General , Special Revenue, Debt Service and Capital Projects Funds Combined Statement of Revenues, Expenses and Changes in Retained Earnings (Deficit) -All Proprietary Fund Types Combined Statement of Cash Flows -All Proprietary Fund Types Notes to General Purpose Financial Statements Supplemental Combining, Individual Fund and Account Group Statements and Schedules For The Fiscal Year Ended September 30, 1991: General Fund Schedule of Revenues and Other Financing Sources -Budget and Actual (Budgetary Basis) Schedule of Expenditures -Budget and Actual (Budgetary Basis) Special Revenue Funds Combining Balance Sheet Combining Statement of Revenues, Expenditures and Changes in Fund Balances • I • (Continued) 3 14 15 16 19 22 26 28 30 32 35 64 66 78 79 CITY OF COLLEGE STATION. TEXAS COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 TABLE OF CONTENTS (Continued) Commun ity Development Fund Schedule of Revenues, Expenditures and Changes in Fund Balance -Budget and Actual (Budgetary Basis) HoteVMote l Tax Fund Schedule of Revenues, Expenditures and Changes in Fund Balance -Budget and Actual (Budgetary Basis) Parks Escrow Fund Schedule of Revenues, Expenditures and Changes in Fund Balance -Budget and Actual (Budgetary Basis) Capital Projects Funds Combining Balance Sheet Combining Statement of Revenues, Expenditures and Changes in Fund Balances Capital Equipment Fund Schedule of Revenues, Expenditures and Changes in Fund Balance -Budget and Actual (Budgetary Basis) 1982 Series II Bond Fund Schedule of Revenues, Expenditures and Changes in Fund Balance-Budget and Actual (Budgetary Basis) 1984 Bond Fund Schedule of Revenues, Expenditures and Changes in Fund Balance -Budget and Actual (Budgetary Basis) 1989 Bond Fund Schedule of Revenues, Expenditures and Changes in Fund Balance -Budget and Actual (Budgetary Basis) 1991 Bond Fund Schedule of Revenues, Expenditures and Changes in Fund Balance -Budget and Actual (Budgetary Basis) Enterprise Funds Combining Balance Sheet Combining Statement of Revenues, ExpeQSes and Changes in Retained Earnings Combining Statement of Cash Flows • II • 80 81 82 84 86 88 89 90 91 92 94 98 102 (Continued) CITY OF COLLEGE STATION. TEXAS COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 TABLE OF CONTENTS (Continued) Electric Fund Schedule of Revenues -Budget and Actual (Budgetary Basis) Schedule of Expenses -Budget and Actual (Budgetary Basis) Wat.er Fund Schedule of Revenues -Budget and Actual (Budgetary Basis) Schedule of Expenses -Budget and Actual (Budgetary Basis) Sewer Fund Schedule of Revenues -Budget and Actual (Budgetary Basis) Schedule of Expenses -Budget and Actual (Budgetary Basis) Solid Waste Collection Fund Schedule of Revenues -Budget and Actual (Budgetary Basis) Schedule of Expenses -Budget and Actual (Budgetary Basis) Electric, Wat.er, Sewer and Solid Waste Collection Funds Schedule for Reconcilimion of Revenues and Expenses (Budgetary Basis) to GAAP Basis Stmement of Income Internal Service Funds Combining Balance Sheet Combining Stmement of Revenues, Expenses and Changes in · Retained Earnings (Deficit) Combining Stmement of Cash Flows Employee Benefits Fund Schedule of Revenues and Expenses -Budget and Actual (Budgetary Basis) · Landfill Fund Schedule of R_evenues and Expenses -Budget and Actual (Budgetary Basis) Property and Casualty Fund . Schedule of Revenues and Expenses - Budget and Actual (Budgetary Basis) · Unemployment Fund Schedule of Revenues and Expenses -Budget and Actual (Budgetary Basis) • Ill • 104 105 106 107 108 109 110 111 112 114 116 118 120 121 122 123 (Continued) CITY OF COLLEGE STATI ON. TEXAS COMP REHENSIVE ANNUAL FINANCIAL REPORT FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 TABLE OF CONTENTS (Continued) Utility Billing Fund Schedule of Revenues and Expenses -Budget and Actual (Budgetary Basis) Workers' Compensation Fund Schedule of Revenues and Expenses Budget and Actual (Budgetary Basis) Internal Service Funds Schedule for Reconciliation of Revenues and Expenses (Budgetary Basis) to GAAP Basis Statement of Income General Fixed Assets Account Group Schedule of General Fixed Assets by Source Schedule of General Fixed Assets by Source -by Function and Activity Schedule of Changes in General Fixed Assets by Function and Activity STATISTICAL SECTION: General Governmental Revenues and Other Financing Sources General Governmental Expenditures and Other Uses by Function Property Tax Levies and Collections Assessed and Estimated Actual Value of Taxable Properties Property Tax Rates, Ratios and Levies -Direct and Overlapping Paving Assessment Collections Computation of Legal Debt Margin Ratio of Net General Bonded Debt to Assessed Value and Net Bonded Debt Per Capita Schedule of Direct and Estimated Ovf!Wlapping Debt Ratio of Annual Debt Service Expenditures for General Obligation Debt to Total General Governmental Expenditures and Other Uses Utility Fund -Schedule of Revenue Bond Coverage ·IV · 124 125 126 131 132 134 136 138 140 142 144 146 147 148 150 151 152 (Continued) Total Bank Deposits Construction Permits Principal Taxpayers CITY OF COLLEGE STATION, TEXAS COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1990 TABLE OF CONTENTS (Continued) Principal Utility Customers Miscellaneous Statistical and Demographic Data -v- 153 154 155 156 157 -vi- INTRODUCTORY SECTION - 1 - -2- CITY OF COLLEGE STATION March 17, 1992 Honorable Mayor Members of the City Council City of College Station, Texas P.O. BOX 9960 1101 TEXAS AVENUE COLLEGE STATION, TEXAS 77842-0690 \409) 764-3500 The Comprehensive Amual Financial Report of ttie City of College Station, Texas (•City•), for the fiscal year ended September 30, 1991, is submitted herewith. This report was prepared by the City's Finance Department. Responsibility for both the accuracy of the presented data and the completeness and fairnes$ of the presentation, including all disclosures, rests with the City. We believe the data, as presented, is accurate in all material aspects; that it is presented in a manner designed to fairly set forth the financial position of its various funds; and that all disclosures necessary to enable the reader to gain the maximum understanding of the City's financial affairs have been included. The Comprehensive Annual Financial Report is presented in three major sections: introductory, financial, and statistical. The introductory section includes this transmittal letter, the City's organizational chart and a list of principal elected and appointed officials of the City. The financial section includes the general purpose financial statements and the combining and indMdual fund and account group financial statements and schedules, as well as the auditors' report on the financial statements and schedules. The statistical section includes selected financial and demographic information, generally presented on a multiyear basis to allow for trend analysis of the finances of the City. The City is required to undergo an annual single audit in conformity with the provisions of the Single Audit Act of 1984 and U.S. Office of Management and Budget Circular A-128, Audits of State and Local Governments. Information related to this single audit, including the schedule of federal fi nancial assistance, findings and recommendations, and auditors' reports on the internal control structure and compliance with applicable laws and regulations, are reported separately. This report includes all funds and account groups of the City. The City provides a full range of municipal services. These services include police and fire protection; the construction and maintenance of streets and infrastructure; municipal utilities in the areas of electric, water, sewer, storm drainage, and solid waste; recreational activities and cultural events. The College Station Independent School District is administered by a separate, elected board and operates with its own funding sources; therefore, it has not been included in this report. Horne of Texas A & 1v1 University THE CITY OF COLLEGE STATION The City of College Station is in East Central Texas, approximately 140 miles north of the Gulf of Mexico, conveniently located 90 miles north of Houston, 165 miles south of Dallas, and 1 oo miles east of Austin. Of major importance to the City of College Station is Texas A&M University, located on a 5,200 acre campus within the corporate limits of the City. The economic impact on the City by the University continues to be substantial, contributing an estimated $500 million annually to the local . economy. In the categories of enrollment and research grants, Texas A&M University ranked in the top ten nationally among public institutions for the school year beginning in September, 1991. The University employs in excess of 18,000 people and has a physical plant valued in excess of $1.2 billion. In addition to the University, employment is provided by more than 75 manufacturing industries, located in or adjacent to the City, which provide such products as aluminum windows, business forms, furniture, chemicals, dairy products, feeds and fertilizers, modular homes, bronze castings, and geophysical survey sensors. A growing research park is located adjacent to the University. Westinghouse Defense and Electronic Systems Center produces defense radar-related equipment. Automated Management Systems provides a major automated accounting service for independent property and casualty insurance agents. Commercial development in the City is anchored by the 1,000,000 square foot Post Oak Mall opened in 1982. Major tenants of the shopping center are Sears-Roebuck, Dillard's, Foley's, Beall's, and J.C. Penney's. Wal-Mart opened a major retail facility in the community in 1989 and K-Mart underwent a major expansion of their retail operations. Three major grocery stores opened their doors in 1991. Over the past five years, the City of College Station has become the major medical center for the Brazos Valley area. In 1986, Scott & White opened a large medical clinic; in 1987, Humana Hospital opened a 100-bed full service hospital with an adjacent medical office complex. In 1988, HCA­ Greenleaf Hospital opened a psychiatric hospital in College Station, and the Sandstone Psychiatric Hospital opened in 1989. Scott & White is scheduled to begin additional construction in 1992 increasing their clinic some 50,000 square feet to 125,000 square feet. The City, although not immune to the effects of the collapse of the oil and real estate markets in the State of Texas in the early and mid-1980's, has been insulated by the dominant effect of Texas A&M University on the local economy. Real estate property valuations had been essentially flat during the late 1980's but as detailed in the statistical section at the rear of this report, total valuatioils ·in 1'991 increased more than $25 million. Improvements in the local economy have been in the area of commercial d0Velopment, with significant increases in sales tax revenues to the municipality in recent years. The job market in College Station continues to be strong. The Bryan-College Station area has led the State with the lowest unemployment level for the past thirty five months. MAJOR INITIATIVES During this fiscal year, the City devoted significant attention to the infrastructure of the City. General obligation bonds in the amount of $3,225,000 were issued in 1989 for several major street construction projects. The City was awarded a grant totaling approximately $238,000 for intersection signalization improvements. The City is also cooperating with the Texas State Department of Highways in the construction of major traffic links crossing the Texas 6 By-Pass. The City has purchased the required right-of-way for the planned overpass at Southwest Parkw ay, and the extension of FM 2818 is currently being constructed. Utility relocation for these projects is the responsibility of the City and has been completed. The City has also completed the construction of the realignment of Emerald Parkway. At the public election held in May, 1990, the electorate approved a one-half of one percent (1/2%) - 4 - increase in the local sales tax rate. That rate increase provides the City with approximately $2,000,000 on an annualized basis. As part of the City's fiscal 1991 budget, the City Council approved the use of the majority of those funds for the reduction of utility rates charged to customers. The second major category of use of funds was to finance an ongoing program for residential street reconstruction. A priority listing of residential street renovation projects was developed to begin this program, and the first three were completed in 1991 . In May, 1990, the Cities of College Station and Bryan jointly formed the Brazos Valley Solid Waste Management Agency (BVSWMA). That agency was formed to provide efficiencies of scale in the joint operation of a single landfill. The City of College Station has been retained by BVSWMA to operate the landfill on a contract basis. Equity in BVSWMA and a separate Landfill Fund have been included in the City's financial statements with more complete-disclosure in the Notes to the Financial Statements. The first series of bonds used to finance the utility system projects was issued in December, 1990, in the amount of $4,800,000, providing funding for engineering and the first phases of construction expense. Electric projects included new transmission, substation, and distribution facilities. Sewer projects started include upgrading the City's Carter Creek wastewater treatment plant to comply with new EPA and Texas Water Commission treatment guidelines and several sewer line upgrading projects. Long Term. During fiscal 1990, the City entered into a contract with the Texas Municipal Power Agency (TMPA) cities. The City will begin receiving power under this contract on December 30, 1991. Under the terms of the contract, the City will be a total requirements customer and will have the opportunity to become a full partner in the TMPA when TMPA needs to expand its power generating facilities. TMPA was created in July, 1975, by concurrent ordinances of the Texas Cities of Bryan, Denton, Garland, and Gr eenville pursuant to the Acts of the 63rd and 64th Legislature of Texas. Under provisions of the Act, TMPA is a separate municipal corporation. In September, 1976, TMPA entered into identical power sales contracts with each of the cities for the purpose of obtaining the economic advantages of jointly financing, constructing and operating large electric generating units and related facilities to supply the cities' future electric needs. TMPA operates the Gibbons Creek Steam Electric Station, a lignite-fueled generating plant located in Grimes County, Texas, with a net generating capacity of 405 MW. The plant began commercial operation October 1, 1983. The City has developed a three-year capital construction program for the electric, water, and sewer utilities. Total investment in the utility system over this period of time will be approximately $23.8 million, financed with the use of available funds on hand and the issuance of $15.3 million in utility revenue bonds. A three-year capital improvements budget was approved by the City Council as part of their deliberation on the fiscal 1991 budget. A special election was held in December, 1990 for approval of General Obligation Bonds. The electorate authorized the issuance of $4,500,000 in bonds for street and sidewalk construction and $1,000,000 in bonds for park development. In December, 1991, $3,500,000 of these bonds were issued for street and parks projects that were targeted for construction in 1992 and 1993. Other projects are expected to be constructed in subsequent years. The City will begin construction of the first phase of the Wolfpen Creek Corridor project in 1992. The development of the masterplan for. this project began in 1988 and will include lakes, trails, an amphitheater, botanical gardens, and various public-private ventures . • 5. FINANCIAL INFORMATION The City is responsible for establishing and maintaining an internal control structure designed to ensure that the assets of the City are protected from loss, theft or misuse and to ensure that adequate accounting data is compiled to allow for the preparation of financial statements in conformity with generally accepted accounting principles. The internal control structure is designed to provide reasonable, but not absolute, assurance that these objectives are met. The concept of reasonable assurance recognizes that: (1 )' the cost of a control should not exceed the benefits likely to be derived; and (2) the valuation of costs and benefats requires estimates and judgments by management. Single Audit. The City receives federal financial assistance and is responsible for ensuring that an adequate internal control structure is in place to ensure compliance with applicable laws and regulations related to those programs. This internal control structure is subject to periodic evaluation by m�gement. Tests are made to determine the adequacy of the internal control structur e, including that portion related to federal financial assistance programs, as well as to determine that the City has complied with applicable laws and regulations. The results of the City's single audit for the fascal year ended September 30, 1991 • provided no significant violations of applicable laws or regulations relating to federal financial assistance programs of the City. Budgetary Controls. The City maintains a system of budgetary controls. The objective of these budgetary controls is to ensure compliance with legal provisions embodied in the annual budget appropriations ordinance approved by the City Council. Activities of the General Fund, Debt Service Fund, Special Revenue Funds, Capital Projects Funds, Utility Enterprise Funds, and the Internal Service Funds are included in the budget appropriations ordinance. The level of budgetary control, that is the level at which expenditures cannot legally exceed appropriations, is established by division and major activity level within an individual fund. For example, expenditures cannot exceed amounts budgeted for the control areas of personnel services supplies, services, and capital outlay within 8Irf division budget of the General Fund. The City's Budget Office monitors expenditure activity on a monthly basis against budgeted amounts and reports significant variances to the City Manager. The City continues to meet its responsibility for sound financial management. ·6· General Government Functions. The following schedule presents a summary of General Fund and Debt Service Fund revenues and other various financing sources for the fiscal year ended September 30, 1991. Comparisons to the previous fascal year have been included. Fiscal Year Percent of Fiscal Year I ncrease Revenue Source Ended �30£91 Total Ended 9l30l90 (Decrease) General Fu nd Property Tax $1,482,577 8.72°A> $ 1,774,601 $ (292,024) Sales and Mixed Drink Tax 6,523,709 38.39 4,097,742 2,425,967 Franchise Tax 328,524 1.93 335,940 (7,416) Licenses and Permits 116,574 .69 94,691 21,883 Fines and Penalties 518,357 3.05 -536,155 (17,798) Charges for Services 540,096 3.18 573,748 {33,652) Transfer from Enterprise Funds in Lieu of Taxes 3,772,060 22.20 4,701,449 (929,389) Miscellaneous Revenues 553,079 3.25 693,154 {140,075) Other Financing Resources 121 ,895 .72 227,930 (1 06,035) Debt Service Property Tax 3,037,368 17.87 2,716,367 321,001 Total Revenues and Other Financing Sources $ 16,994,239 100.00% $15,751,777 $1,242,462 The most significant increase in actual revenue sources during 1991 was the increase in sales tax due to the increase in the tax rate. After a 7.12% increase in fiscal 1990 over fiscal 1989, revenue was up in fiscal 1991 by 60.4% over 1990. Most of that increase was due to the change in the tax rate, but sales growth was approximately 8.5%. These numbers reflect the continued strength in the commercial sector of the local economy. The decrease in the transfer in lieu of taxes from the enterprise funds was a planned use of a portion of the additional sales tax. Also during 1991, the City changed the method of recording sales tax from the cash basis to ac cruing for sales tax remitted by the state to the City in October. The accounting change resulted in an accrual of sales tax revenues of $570, 160. On a continuing basis, property tax collections were up slightly in fiscal 1991 when looking at the combined general fund and debt service fund. The small increase was the result of additional efforts relating to the collection of delinquent taxes. REVENUES BY SOURCE GENERAL AND DEBT SERVICE FUNDS FISCAL YEAR 1991 $16,994,236 22.20°k Transfer in-lieu-of taxes Other -7 - 26.59% Property Tax The following schedule presents a summary of General Fund and Debt Service Fund expenditures for the fiscal year ended September 30, 1991. As with the revenue summary, comparisons to the previous fiscal year have been included. Fiscal Year Percent of Fiscal Year Increase Function Ended 9l30l91 Total Ended 9l30l90 (Decrease) Current: General Government $ 4,723,549 26.48% $ 4,617,138 $ 106,411 Police 3,491,656 19.57 3,363,665 127,991 Fire 2,833,455 15.88 2,780,466 52,989 Public Services 1,940,697 10.88 1,502,988 437,709 Parks and Recreation 2,269,977 12 . .72 2,428,196 (158,219) Less: Reimbursed Administrative Costs (2,415,356) (13.54) (2,276,465) (138,891) Debt Service: Principal 2,206,493 12.37 1,917,289 289,204 · Interest and Fiscal Charges 1,464,946 8.22 1,505,414 (40,468) Capital Outlay 602,976 3.38 345,317 257,659 Other Financing Uses 720,546 4.04 200,000 520,546 Total Expenditures $17,838,939 100. 00°.k $16,384,008 $1,454,931 The largest percentage increase in operating expenditures was in Public Services, caused by the significant emphasis on reconstruction of a number of residential streets. Increases in capital outlay expenditures reflect heavy expenditures in the replacement of fire and ambulance vehicles. EXPENDITURES BY FUNCTION GENERAL AND DEBT SERVICE FUNDS FISCAL YEAR 1991 $17,838,939 Other Financing Capital OUtlay 4.04% 12.94% General Government (Net of Reimbursement) 20.58% Debt Service Parks and Recreation 12.72% 3.38% 1 0.88% Public Service -8- 35.46% Public Safety General Fund Balance. The unrestricted fund balance of the General Fund increase d by $207,936 in 1991. This 9.4% increase provides the City with a total fund balance which is equivalent to 65 working days of expenditures. That fund balance is viewed as a reasonable and prudent reserve under the City Council policy on reserve levels. Property taxes received during flSCal year 1991 were based on a tax levy of 40 cents per $100 of assessed valuation. Under Texas state statues, assessed valuation represents 100% of market value. The total assessed valuation of $1,101,479,522 represents a 1.5% decrease from fiscal year 1990. The decline was caused by valuation price downs on commercial property exceeding value of new residential construction and properties purchased by Texas A & M University and removed from taxable status. Distribution of property tax rates tor the last five years is as follows: puroose General Fund Debt Service Fund � $.1325 .267 5 1990 $.1600 .2400 1989 $.1400 .2400 1988 $.0900 .2900 1987 $.0200 .3600 Utility Funds. The City of College Station operates electric, water, sewer, and solid waste services for the benefit of the citizens. The electric utility presently purchases 100% of its electric power from Gulf States Utility under a contract valid through 1991. The City is served through three 138 t<:V A transmission lines tied to a ring bus at the City switching station. The City will begin purchasing power from the Texas Municipal Power Agency cities on December 30, 1991. Since 1981, the City has had the capability to produce and deliver 100% of its water needs through development of its own water well and aquaduct system. This system includes four wells with a combined capacity of 17 million gallons per day, and a delivery system of 14 miles of 30-inch diameter pipeline with two pumping stations. Sewer treatment is provided to the community through two wastewater treatment plants. The Uck Creek plant was completed and came on-line during 1988. The two plants have a combined treatment capacity of 9.4 million gallons per day as compared to average current daily demand of 6 million gallons per day. Solid waste collection services are provided to the citizens through a combination of residential curbside pick-up and commercial dumpster services . • 9. Summary financial information of the combined utility enterprise operations for the fiscal year ended September 30, 1991, with comparison to the previous fiscal year, is as follows: Fiscal Year Fiscal Year Operating Revenues: l;nded aL30£91 Eade� a£30!90 Electric $26,554,630 $28,599,828 Water 4,702,612 4,679,593 Sewer 3,785,002 3,718,541 Solid Waste Collection 1,795,247 1,854,505 Other 538,396 110,456 Operating Expenses: Wholesale Purchased Power 19,072,974 18,715,821 Salaries and Benefits 3,807,573 3,527,525 Supplies, Maintenance and Services 4,120,041 3,919,110 Reimbursed Administrative 1,593,365 1,713,818 Depreciation 2,126,498 2,129,475 Other 234,586 115,394 Nonoperating Revenues (Expenses): Interest Earnings 1,748,132 1,559,763 Interest Expense (2,445,468) (2,488,517) Other, Net 581,037 746,877 Transfer to General Fund In Lieu of Taxes (3,821,539) (4,701,449) Net Income $2,483,012 $3,958,454 Utility Billing Fund. The Utility Billing Fund, financed with user charges from the utility operating funds, was authorized in the 1989 budget. Formerly, this activity was accounted for as part of the General Fund. Utility billing is responsible for meter reading, billing, and collections for approximately 19,000 electric, water, sewer and solid waste collection accounts. The net loss of $39,360 recorded for the fiscal year ended September 30, 1991, can be attributed to $90, 179 in depreciation expense recorded during the year. Employee Benefits Fund. The City of College Station has a self-insured employee benefits plan providing medical and dental insurance to employees and their families. The City annually purchases both specific and aggregate stop�loss insurance to protect the financial integrity of the plan. The plan is funded through monthly premiums of $11 o paid by operating departments for each employee and $150 monthly paid by employees electing dependent coverage. During fiscal 1991, the plan had a net loss of $45,334, caused by escalating medical costs. Cost containment measures continue to be implemented as well as increase� in the monthly premiums that went into effect in October, 1991. -10 - Debt Administration. As of September 30, 1991, the City had a total of $19,834,080 In General Obligation Bonds and Certificates of Obligation relating to Governmental Fund types. That debt, equal to $378 per capita, is serviced by revenues from the local property tax. Under current state statutes, the City's ability to increase the mill levy for property taxation is subject to a maximum cap of $2.50 per $100 valuation. The Utility Fund has an additional $26,937,247 in total debt serviced through utility charges. · Cash Management. All investment activity of the City is handled in accordance with Resolution 4-12- 90-5.5, authorizing and implementing the City of College Station Investment Policy. The Investment Policy, established as required by state law and in conformity with state investment statutes, ensures the safety of all funds entrusted to the City, ensures the availability of those funds for the payment of all necessary obligations of the City, and provides for the investment of funds in interest-bearing securities. Safety of the principal invested is always the primary concern. Effective October 1, 1988, the City entered into a three year agreement with NCNB -Texas National Bank, A&M Branch, separating investments from traditional banking services. The City currently invests tunds in the full range of investments allowable under state law. Accounts have been established with major brokerages for the purchase and sale of U.S. Government obligations and Master Repurchase Agreements have been entered into by the City. All purchases and sales of securities are delivery-versus-payment through a safekeeping account at the City's third-party bank. As of September 30, 1991, the City's investment portfolio consisted of the following: Bank Demand Accounts State Investment Pool Insured Certificates of Deposit U.S. Government Obligations Government Agency Notes TOTAL $ (56,018) 4,681,812 50,000 13,760,321 9,612,663 $28,048, 778 The City earned $2,550, 100 on an average investment balance of approximately $30.6 million, a rate of return of 8.34%, for the year ended September 30, 1991. Compared to prior years' earnings and a market benchmark, the City's investment yield was: 9.00% 8.50% 8.00% 7.50% 7.00% 6.50% 6.00% 5.50% 5.00% 8.77% 1989 Acutal 1989 10-Bill Index jRATES OF RETURN I 1990 Actual -11 - 1990 10-Bill Index 1991 Actual 1991 10-Bill Index Investment results on the portfolio are compared to The Public Investor 10 bill index. This hypothetical portfolio consists of ten treasury bills with an average maturity of 80 days. Every Thursday a T-Bill matures and proceeds are reinvested alternately in three month and six month T­ Bills. This rolling index provides a benchmark for evaluating risk-free cash management portfolios w�th short-term liquidity needs for payroll and accounts payable. In accordance with normal investment reporting, rates of return do not include unrealized capital gains, that is, year-end market values higher than the original cost of a security held at the end of a fiscal year. If these unrealized capital gains of $1, 106,355 were added to investment income, fiscal 1991 rate of return was approximately 11.95%. Risk Management. The City's insurance programs are administered by the Risk Management area of the Finance Department. The City participates in the Texas Political Subdivision pool for workers' compensation claims. Property and liability claims are paid from a self-insurance reserve fund carried to provide for claims of $25,000 or less with third party carriers providing for claims in excess of that amount. Safety programs are coordinated on an ongoing basis from that office. OTHER INFORMATION I ndeoendent Audit. State statutes require an annual audit by independent certified public accountants. The accounting firm of Deloitte & Touche has been retained by the City Council for this function. In addition to meeting the requirements set forth in state statutes, the audit also was designed to meet the requirements of the federal Single Audit Act of 1984 and related OMB Circular A-128. The independent auditors' report on the general purpose financial statements and combining, individual fund and account group statements and schedules is included in the financial section of this report. The auditors' reports related specifically to the single audit are issued separately. 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 College Station for its Comprehensive Amual Financial Report for the fiscal year ended September 30, 1990. The Certificate of Achievement is a prestigious national award recognizing conformance with the highest standards for preparation of state and local government financial reports. In order to be awarded a Certificate of Achievement, a government unit must publish an easily readable and efficiently organized comprehensive annual financial report, whose contents conform to program standards. Such CAFR must satisfy both generally accepted accounting principles and applicable legal requirements. A Certificate of Achievement is valid for a period of one year only. The City of College Station has received a Certificate of Achievement nine of the last ten years. We believe our current report continues to conform to the Certificate of Achievement program requirements, and we are submitting it toGFOA. - 12. Acknowledgements. The preparation of this report on a timely basis could not have been accomplished 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 its preparation. We would also like to thank the Mayor and City Council for their interest and support in planning and conducting the financial operations of the City in a responsible and progressive manner. Finally, we would like to thank our auditors, Deloitte & Touche, whose professional expertise and advice have resulted in continuing improvements in the quality of the City's financial reporting. Respectfully submitted, Ron Ragland City Manager • 13. Glem Schroeder Executive Director Fiscal and Human Resources Certificate of Achievement for Excellence in Financial Reporting Presented to City of College Station, Texas For its Comprehensive Annual Financial Report for the Fiscal Year Ended September 30, 1990 A Certificate of Achievement for Excellence in Financial Reporting is Presented by the Government Financial Officers Association of the United States and Canada to government units and public employee retirement systems whose comprehensive annual financial reports (CAFR's) achieve the highest standards in government accounting and financial reporting. President !��� ·14· I APPOINTED BOARDS I I I EXECUTIVE DIRECTOR II FISCAL/HUMAN RESOURCES I FINANCE BUOGET & EVALUATION ACCOUNTING/PAYROLL PURCHASING HUMAN RESOURCES RISK MANAGEMENT MUNICIPAL COURT CITIZENS OF COLLEGE STATION - I MAYOR AND CITY COUNCIL I I MUNICIPAL JUDGE I CITY ATTORNEY C !TY MANAGER I I I ASSISTANT CITY MANAGER II ASSISTANT CITY MANAGER II COfil4UNITY SERVICES GROUP OPERATIONS GRClJP I I POLICE PUBLIC UTILITIES FIRE TECHNICAL SERVICES DEVELOPMENT SERVICES ELECTRIC SERVICES PUBLIC SERVICES WATER UTILITIES FLEET SERVICES WASTEWATER UTILITIES SOLID WASTE COLLECTION PARKS & RECREATION LANDFILL OPERATION - 15 - I CITY SECRETARY I EXECUTIVE DIRECTOR II MANAGEMENT SERVICES GROUP I PUBLIC RELATIONS/ MARKETING MANAGMENT INFORMATION UTILITY BILLING SERVICES FACILITIES MAINTENANCE ENERGY MANAGEMENT LIBRARY I crry OF COLLEGE STATION. TEXAS Elected Officials: PRINCIPAL crrv OFFICIALS SEPTEMBER 30, 1991 Mayor ••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••• Larry J. Ringer Council Membera •••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••• Fred H. Brown •••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••• Ver non E.Schnelder .•.......•••••..••.........•••.••••.....••....••••••••••.••••.••••••••••••••••••••••••••••••••••••••••••• James R. Gardner ••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••• Nancy Crouch ••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••• Dick Birdwell •••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••• Lynn R. Mcllhaney City Administration: City" Manager •••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••• Ron Ragland Assistant City Manager for Community Services Group,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Thomas E. Brymer Assistant City Manager for Operations Group,,,,,,,,,,,,,,,,,,,,� •••• ,,,, •••• John C. Woody Executive Director for Management Services Group,,,, •• ,,,, •• ,,.,,.Unda S. Piwonka Executive Director for Fiscal and Human Resources Group ........................................................ Glenn Schroeder Director of Development Servlces,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Elrey B. Ash Fire Chief ••••••••••••••••••••••••.••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••• Richard S. Orange Director of Parks and Recreation,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Stephen C. Beachy Personnel Director ........................................................................ Karen N. Pavllnskl Police Chlef.,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,.,,,, ••••••••••• ,, •• ,,,,,,,, •• ,, •••••• ,,,,Mlchael L Strope Director of Public Servlc_es,,,,,,,,,,,.,,,,,,,,,,.,,,,,,,,,,,,,,,,,,,,,,,,.,,,,,,,,,,,Joseph D. LaBeau C ity Attorney ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, •• ,, •• ,,,,,,,,,,,,,,,,,,,,.,,,,,,,,,,,,,,,,,,,,,,,,Catherine Locke City Secretary ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,.,,,,,,,,,,,,, •• ,,,,,,,,,,,,,,.,,,,.,,,.,,,.,,,Connie L Hooks ·16 · FINANCIAL SECTION -17- -18- Deloitte& Touche INDEPENDENT AUDITORS' REPORT Mayor Larry Ringer and Members of the City Council of the City of College Station, Texas: Suite 2300 Telephone: (713) 756-2000 333 Clay Street Facsimile: (713) 756-2001 Houston, Texas 77002-4196 We have audited the accompanying general purpose financial statements of the City of College Station, Texas ("City") as of September 30, 1991 and for the year then ended, listed in the foregoing table of contents. These general purpose financial statements are the responsibility of the City's management. Our responsibility is to express an opinion on these general purpose financial statements based on our audit. We conducted our audit in accordance with generally accepted auditing standards. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the general purpose financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall financial statement presentation. We believe that our audit provides a reasonable basis for our opinion. In our opinion, such general purpose financial statements present fairly, in all material respects, the financial position of the City at September 30, 1991, and the results of its operations and the cash flows of its proprietary fund types for the year then ended in conformity with generally accepted accounting principles. Our audit was conducted for the purpose of forming an opinion on the general purpose financial statements taken as a whole. The combining and individual fund and account group financial statements and schedules listed in the foregoing table of contents, which are also the responsibility of the City, are presented for the purposes of additional analysis and are not a required part of the general purpose financial statements of the City. Such supplemental information has been subjected to the auditing procedures applied in our audit of the general purpose financial statements and, in our opinion, is fairly stated in all material respects when considered in relation to the general purpose financial statements taken as a whole. The accompanying statistical tables, listed in the foregoing table of contents, were not audited by us and, accordingly, we express no opinion on them. As discussed in Note 1 to the general purpose financial statements, the City changed its method of accounting for sales tax revenue in 1991. �Q_TIJ-U� December 23, 1991 Member DRilnternational -19- -20- - 21 - CITY OF COLLEGE STATION, TEXAS COMBINED BALANCE SHEET--ALL FUND TYPES AND ACCOUNT GROUPS SEPTEMBER 30, 1991 (With comparative totals for the fiscal year ended September 30, 1990) Assets and Other Debits Assets: Equity in Cash and Cash Equivalents (Note 2) Equity in Investments (Note 2) Receivables: Accrued Interest Grants Letter of Credit Accounts Special Assessments Delinquent Property Taxes (Note 3) State Sales Tax (Note 1) Notes and Loans (Note 4) Other Less Allowance for Uncollectible Accounts Inventories Prepaid Costs Restricted Assets: Equity in Cash and Cash Equivalents (Note 2) Equity in Investments (Note 2) Accrued Interest Accounts Note Receivable from Joint Venture (Note 13) Equity in Joint venture (Note 13) Deferred Charges, Net Property and Equipment, Net (Note 5) Other Debits: Amount Available for Retirement of Bonded Indebtedness Amount to be Provided for: Accrued Vacation Leave Retirement of Bonded Indebtedness Total Assets General $ 380,337 1'897' 132 40' 116 9,937 25,000 64,964 206,290 83,580 570, 160 3,073,800 79,657 (101,327) 122,885 13,092 13,785 118, 761 1,634 0 0 0 0 0 0 0 0 $6,599,803 -22 - Governmental Fund Ty12es Special Debt Revenue Service $ 148,314 $ 191,466 739,796 955,037 9,602 22 '261 83,553 0 25,425 0 1 ,507 0 0 0 0 244,274 0 0 179,842 625,000 0 0 (188) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $1, 187,851 $2,038,038 Capital Projects $ 670,738 3,345,665 76' 771 119,515 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $4,212,689 Proprietary Fund Types Enterprise $ 1,108,708 5,530,264 196,544 0 0 4,454,003 6,775 0 0 0 566,032 (641,151) 1,226,118 600 2,066,124 10,305,879 196' 994 293 909,137 631,260 314,666 57' 131'204 0 0 0 $84,003,450 Internal Service $ 96,322 480,450 11 '046 0 0 229 0 0 0 0 0 0 0 3,820 0 0 0 0 0 0 0 294 '581 0 0 0 $886,448 Account Groups General Fixed Assets $ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 48,682,594 0 0 0 $48,682,594 General Long­ Term Debt $ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,150,418 538,917 18,683,662 $20,372,997 (Continued) -23- Totals (Memorandum Only) 1991 1990 $ 2,595,885 $ 1,596,520 12,948,344 15,387' 721_ 356,340 314' 061 213,005 107,406 50,425 25,000 4,520,703 5,755,428 213,065 237,306 327,854 394,728 570, 160 0 3,878,642 3,187,887 645,689 138,750 (742,666) (464,451) 1'349' 003 1,456,470 17,512 109 ,056 2,079,909 1'046, 457 10,424,640 10,086,068 198,628 206,090 293 25,425 909, 137 976,000 631 ,260 221,717 314,666 257' 140 106,108,379 99,931,994 1,150,418 1,540,743 538,917 460,190 18,683,662 19,374,830 $167,983,870 $162,372,536 CITY OF COLLEGE STATION. TEXAS COMBINED BALANCE SHEET--ALL FUND TYPES AND ACCOUNT GROUPS SEPTEMBER 30, 1991 (With comparative totals for the fiscal year ended September 30, 1990) (Continued) . Governaental Fund T�[!es Special Debt General Revenue Service Liabilities, Equity and Ofher Credits Liabilities: Accounts Payable $ 210,332 $ 39, 105 $ 0 Retainage Payable 8, 109 16' 627 0 Refundable Deposits 1,814 11,305 0 Claias Payable 0 0 0 Obligation Under Capital Lease--Current (Note 12) 0 0 0 Accrued Liabilities 235,424 3,582 18,346 Deferred Revenues--Foundation (Note 4) 2' 105,566 0 0 Unaaortized Discount (Note 4) 894,434 0 0 Other Deferred Revenues 433,901 179' 842 869,274 Liabilities Payable from Restricted Assets: Accounts Payable 0 0 0 Accrued Interest Payable 0 0 0 Retainage Payable 0 0 0 Re·fundable Deposits 0 0 0 Revenue Bonds (Note 6) .o 0 0 General Obligation Bonds (Note 6) 0 0 0 Certificates of Obligation (Note 6) 0 0 0 Long-Term Debt (Note 6): Revenue Bonds 0 0 0 General Obligation Bonds 0 0 0 Certificates of Obligation 0 0 0 Obligation Under Capital Lease (Note 12) 0 0 0 Contractual Obligations 0 0 0 Accrued Vacation 0 0 0 Total Liabilities 3,889,580 250 I 461 887,620 Equity and Other credits: Contrfbuted Capital 0 0 0 Investment in General Fixed Assets 0 0 0 Retained Earnings (Deficit): Reserved 0 0 0 Unreserved 0 0 0 Fund Balances: Reserved (Note 15) 236,784 1,450 1'150 ,418 Unreserved: Designated for Subsequent Years Expenditures 58' 152 341 ,686 0 Undesignated 2,415,287 594 254 0 Total Equity and Other Credits 2,710,223 937,390 1, 150 ,418 Total Liabilities, Equity and Other Credits $6,599,803 $1I1871851 $2,038,038 • 24. Capital Projects $ 185' 611 35,516 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 221,127 0 0 0 0 155,784 2,952,868 882,910 3,991 ,562 $4,212,689 Proerietar:i Fund T:i(!es Account GrOU(!S Totals (Memorandu111 Onl:il Internal General General Long- Entererise service Fixed Assets Ter111 Debt 1991 1990 $ 2,696,284 $199,649 $ 0 $ 0 $ 3,330,981 $ 2,721,904 0 0 0 0 60,252 121,314 975 0 0 0 14,094 11,929 0 339,837 0 0 339,837 501,226 413,651 0 0 0 413,651 378,848 240,008 16' 051 0 0 513,411 547' 145 0 0 0 0 2' 105' 566 1'954' 121 0 0 0 0 894,434 1'045' 879 35,402 0 0 0 1,518,419 922,229 282,531 0 0 0 282,531 0 369,541 0 0 0 369,541 369, 117 107,634 0 0 0 107,634 86,676 1,919, 104 0 0 0 1,919,104 1'923 '971 2,475,000 0 0 0 2,475,000 2,415,000 376,235 0 0 0 376,235 377,765 26,201 0 0 0 26' 201 26,200 21,730,000 0 0 0 21,730,000 19,405,000 2, 146,410 0 0 18,577,355 20,723,765 23' 187 ,235 183,401 0 0 131,725 315, 126 460,583 2,278,462 0 0 0 2,278,462 2,692,113 0 0 0 1,125,000 1,125,000 0 139 543 40 701 0 538,917 719 161 633,287 35,420,382 596,238 0 20,372,997 61 ,638,405 59,781 ,542 10,293,535 381,137 0 0 10,674,672 10,674,672 0 0 48,682,594 0 48,682,594 4,6' 007' 976 15,303,697 -0 0 0 15,303,697 8,910,098 22,985,836 (90,927) 0 0 22,894,909 26,914,703 0 0 0 0 1,544,436 1, 751,943 0 0 0 0 3,352,706 5,035,340 0 0 0 0 3,892,451 3,296,262 48,583,068 290,210 48,682,594 0 106,345,465 102,590,994 $84,003,450 $886,448 $48,682,594 $20,372,997 $167,983,870 $162,372,536 The notes to the financial statements are an integral part of this statement. -25- CITY OF COLLEGE STATION. TEXAS COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES ALL GOVERNMENTAL FUND TYPES For the Fiscal Year Ended September 30, 1991 (With comparative totals for the fiscal year ended September 30, 1990) Totals (Memorandum Only) Revenues: Taxes Licenses and Permits Grants Charges for Services Fines, Forfeits, and Penalties Special Assessments Interest on Investments Rents and Royalties Loan Proceeds Interest on Loans Contributions Other Total Revenues Expenditures: Current: General Government Fiscal and Human Resources Community Services: Administration Police Fire Parks Development Services Public Services Management Services Housing Rehabilitation Reimbursed Administrative Special Programs and Projects Public Agency Funding Economic Development Interim Assistance Planning Clearance Other Capital Outlay Debt Service: Principal Retirement Interest Payments Fiscal Charges Bond Issuance Costs Total Expenditures General $ 8,334,810 116,574 17,915 540, 096 518,357 31,016 254,522 45,053 0 2,892 1,422 54 881 9,917,538 627,086 1,404, 127 108, 160 3,491,656 2,833,455 2, 269 '977 1, 149,666 1,940,697 1 ,258,472 0 (2,415,356) 13,461 123,083 0 0 0 0 39,494 602,976 0 0 0 0 13,446,954 S• ,005,305 0 607,270 0 213 0 71'877 53 ,686 8,581 7,656 0 11 472 1 ,766,060 0 0 0 0 0 0 0 0 0 256,997 358,231 169,929 545,621 4, 146 2, 119 0 42,240 192 23, 107 0 0 0 0 1,402,582 Debt Service $3, 037 ,368 0 0 0 0 0 145,378 0 0 0 0 0 3 > 182 I 746 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2,206,493 1,454 ;260 10,686 0 3,671,439 (Continued) -26 - $ Capital Projects 0 0 158,334 0 0 0 362, 081 0 0 0 50,000 990 571 ,405 0 0 0 0 0 0 0 0 0 0 149,519 0 0 0 0 0 0 32,575 2,343, 136 0 0 0 30,562 2,555,792 1991 $12,377,483 116,574 783,519 540,096 518,570 31,016 833,858 98,739 8,581 10,548 51,422 67,343 15,437,749 627 ,086 1,404,127 108, 160 3,491,656 2,833,455 2,269,977 1,149,666 1,940,697 1,258,472 256,997 (1,907,606) 183,390 668, 704 4, 146 2, 119 0 42,240 72,261 2,969,219 2,206,493 1,454,260 10,686 30,562 21,076,767 1990 $ 9,895,875 94,691 775,877 573, 748 536, 155 14,250 1,090,964 102,023 8,438 0 0 88 445 13, 180,466 627,522 1,274, 100 82, 746 3,363,665 2, 780,466 2,428, 196 1, 181,381 1,502,988 1,163,000 206,691 (1,827,860) 107,432 774,958 2,337 2,756 12,000 0 102,442 3,697,715 1,913,720 1,508,983 0 41 001 20 ,946' 239 CITY OF COLLEGE STATION, TEXAS COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES ALL GOVERNMENTAL FUND TYPES For the Fiscal Year Ended September 30, 1991 (With comparative totals for the fiscal year ended September 30, 1990) (Continued) Totals (Memorandum Onl�l Special Debt Capital General Revenue Service Projects 1991 1990 Excess (Deficiency) of Revenues Over (Under) Expenditures $(3,529,416) $ 363,478 $ (488,693) $(1,984,387) $(51639 I 018) $(7 I 765 I 773) Other Financing Sources (Uses): Proceeds from Long·Term Debt 0 0 0 500,000 500,000 3,242,428 Sale of General Fixed Assets 23,527 0 0 0 23,527 31,565 Operating Transfers In (Note 11) 3,772,060 0 98,368 294 ,000 4' 164 ,428 5,097,689 Operating Transfers Out (Note 11) 0 (169,889) 0 ( 173' 000) (342,889) (596' 240) Other .Transfers (Note 11) (720,546) 299 164 0 421 ,382 0 0 Total Other Financing Sources (Uses) 3,075,041 129,275 98,368 1,042,382 4,345,066 7 I 7751442 Excess (Deficiency) of Revenues and Other Financing Sources (Uses) Over (Under) Expenditures and Other Uses (454,375) 492,753 (390,325) (942, 005) (1,293,952) 9,669 Fund Balances, October 1 3, 164,598 444 637 1 ,540, 743 4,933,567 10,083,545 10,073,876 Fund Balances, September 30 $2,710,223 $ 937,390 $1, 150,418 $ 3,991,562 $ 8,789,593 $ 10,083,545 The notes to the financial statements are an integral part of this statement. -27- Revenues: Taxes Licenses and Permils Grants Charges for Services Fines, FO!feils, and P9nalties Special Assessnents Interest on l11'19Stmenls Rentals loan Proceeds Interest on loans Contributions Other Total revenues Expenditures: Current: General government Fiscal and Human Resources Community Services: Administration Police Fire Parks Development Serviees Public Services Management Services Nondepartmental: Housing Rehabililalion Reimbursed Administrative Special ProgramS/Projects Public A1Jeooi Funding Econmic Development Interim Assistance Clearanal Subrecipient Projects Other Capital Outlay Expected Expendtture Savings Contingency Debt Selvice: Principal Interest and Fiscal Charges Bond Issuance Cosls Total Expenditures Excess (Deficienc.y) rJ Revenues � (Under) Expenditures Other Financing Sources (Uses): Proceeds from longTerm Debt Issuance Operating Transfers In Operating Transfers Out Other T ranslers Other Total Other Financing Sources (Uses) Excess (Deficienc.y) rJ Revenues � (Under) Expenditures and Other Financing Sources (Uses) Fund Balances, October 1 Fund Balances, September 30 CITY OF COL.LEGE STATION. TEXAS COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL (BUDGETARY BASIS) GENERAL, SPECIAL REVENUE, DEBT SERVICE, AND CAPITAL PROJECTS FUNDS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 General Fund Special Ae\ISnue Funds Variance FBYCnlble 8llllllll 6'IYd l\Jnfayorab!el 8llllllll � $7,691,700 $8,334,810 $643,110 $780,000 $1,005,305 98,500 116,574 18,074 0 0 3.210 17,915 14,705 1,250,250 Sl7,'ll0 494,390 540,096 45,708 0 0 587,000 518,357 (68,643) 0 213 40,000 31,016 (8,984) 0 0 213,500 254,375 40,875 37,000 71,877 46,460 45,053 (1,407) 47,000 53,686 0 0 0 0 8,581 0 2,892 2,892 0 7,656 0 1,-422 1,-422 0 0 50,600 69,283 18,683 25,000 11,472 9,225,3Sl 9,931,793 706,433 2,139,250 1,766,060 642,512 627,200 15,312 0 0 1,429,952 1,404,m 25,825 0 0 112,296 108,160 4,136 0 0 3,702,078 3,491,656 210,-422 0 0 2,903,445 2,827,635 75,810 0 0 2,333,869 2,267,853 66,016 0 0 1,199,169 1,210,441 (11,272) 0 0 1,981,664 1,940,697 40,967 0 0 1,339,292 1,258,978 80,314 0 0 0 0 0 418,624 256,997 (2,490,791) (2,465,577) (25,214) 363,423 358,231 0 13,461 (13,461) 169,200 169,929 223,083 123,083 100,000 580,475 545,621 0 0 0 4,000 4,146 0 0 0 6,250 2,119 0 0 0 38,338 42,240 0 0 0 25,000 0 0 0 0 0 192 586,740 566,178 20,562 486,000 23,107 (728,840) 0 (728,840) 0 0 22,303 0 22,303 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 13,256,772 13,373,892 (117,120) 2,091,310 1,402,582 (4,031,412) (3,442,099) 589,313 47,940 363,478 0 0 0 0 0 3,772,060 3,772,060 0 0 0 0 0 0 (169,889) (169,889) (629,446) (720,546) (91,100) 284,446 299,164 100,000 23,527 (76,473) 0 0 3,242,614 3,075,041 (167,573) 114,557 129,275 (788,798) (367,058) 421,740 162,497 492,753 2,093,506 3,164,598 1,071,092 298,763 444,637 $1,304,708 $2,797,540 $1,492,832 $461,260 $ 937,390 -28- Variance FBYCnlble (l,!nlalioreblel $225,305 0 (642.980) 0 213 0 34,877 6,686 8,581 7,656 0 (13,528) (373,190) 0 0 0 0 0 0 0 0 0 161,627 I 5,192 (729) 34,854 (146) 4,131 (3,902) 25,000 (192) 462,893 0 0 0 0 0 688,728 315,538 0 0 0 14,718 0 14,718 330,256 145,874 $476,130 Deli SeMce Finl Capi1a1 P10jec1a Flnlls Vlrillnce Vlrillnce FIYORlille F-..cnble limll � BJrtayqa!MI Bllilll � IUr4yprablol $2.954,300 $3.037,388 $83,068 $ 0 $ 0 $ 0 0 0 0 0 0 0 0 0 0 500,000 -158,334 1341,868) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 145,000 145,378 (822) 300,000 3112,081 82,081 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100,000 50,000 (50,000) 0 0 0 0 990 990 3,100,300 3,182,746 82,446 800,000 571,405 (328,595) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 150,340 1411,519 821 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30,593 (30,593) 0 0 0 8,492,332 2,343,136 6,1411,196 0 0 0 0 0 0 0 0 0 259,068 1,982 257,086 2,607,920 2,610,458 (2 ,538) 0 0 0 1,841,221 1,609,418 231,803 0 0 0 0 0 0 0 30,562 (30,562) 4,+19,141 4,219,876 229,265 8,901,740 2,555,792 6,345,948 (1,348,841) (1,037,130) 311,711 (8,001, 7 40) (1,984,387) 6,017,353 0 5,475,000 500,000 (4,975,000) 646,770 646,805 35 127,000 294,000 167,000 0 0 0 (173,000) (173,000) 0 0 0 0 345,000 421,382 76,382 0 0 0 0 0 0 646,770 646,805 35 5,m,ooo 1,042,382 (4,731,618) (702,071) (390,325) 311,746 (2,227,740) (942,005) 1,285,735 1,500,116 1,540,743 40,627 4,500,000 4,933,567 433,567 $ 798,045 $1,150,418 $352,373 $2,272,260 $3,991,562 $1,719,302 The notes to the financial statements are an integral part of this statement. -29 - CITY OF COLLEGE STATION, TEXAS COMBINED STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS (DEFICIT) ALL PROPRIETARY FUND TYPES For the Fiscal Year Ended September 30, 1991 (With comparative totals for the fiscal year ended September 30, 1990) Totals (Me1orandum Only) Enterprise Operating Revenues: Charges for Services $ 36,837 ,491 Premiums 0 Other 538,396 Total Operating Revenues 37,375,887 Operating Expenses: Purchased Power (Note 8) 19,072,974 Salaries and Benefits 3,807,573 Supplies 310,667 Maintenance 570 I 717 Purchased Professional Services 1,319,535 Purchased Property Services 1t521I543 Other Purchased Services 397,579 Administration Fees 0 Claims 0 Premiums 0 Reimbursed Administrative 1I593 ,365 Depreciation and Amortization 2, 126,498 Other 234,586 Total Operating Expenses 30,955,037 Operating Income (Loss) 6,420,850 Nonoperating Revenues (Expenses): Interest on Investments 1,671,315 Other Interest Earnings 76,817 Reimbursed Expenses 82,640 contributions 7,832 Gain on Asset Retirement 0 Earnings in Joint Venture (Note 13) 409,543 Interest Expense (2,445,468) Other, Net 43 480 Total Nonoperating Revenues (Expenses) ( 153 I 841) Income (Loss) Before Operating Transfers 6,267,009 (Continued) -30- $ Internal Service 1,644,575 2,041,029 12,823 3,698,427 0 1,023,523 87,088 63,040 6,668 32,346 94,428 103,048 1,327,319 662 '591 314,241 91,772 3 725 3,809,789 ( 111 I 362) 44,928 0 0 0 0 0 0 (5,231) 39 697 (71 ,665) $ 1991 1990 38,482,066 $ 40,036,697 2' 041'029 1,537 ,083 551 ,219 178,886 41,074,314 41,752,666 19,072,974 18,715,821 4,831,096 4,341,995 397,755 363,397 633,757 719,900 1,326,203 1,232,744 1 ,553 ,889 1,380,579 492,007 457,846 103,048 96,976 1,327,319 1,006,080 662,591 574,089 1,907,606 1,827,860 2,218,270 2,214,360 238,311 201 ,387 34,764,826 33 I 133 ,034 6,309,488 8,619,632 1, 716,243 1,592,215 76.,817 0 82,640 0 7,832 0 0 626,795 409 ,543 136,717 (2,445,468) (2,501,666) 38 249 (17 ,587) (114I144) (163,526) 6 I 195,344 8,456, 106 CITY OF COLLEGE STATION, TEXAS COMBINED STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS (DEFICIT) ALL PROPRIETARY FUND TYPES For the Fiscal Year Ended September 30, 1991 (With comparative totals for the fiscal year ended September 30, 1990) (Continued) Totals (Me•orandum Onl�l Operating Transfers In $ Operating Transfers Out Total Operating Transfers In (Out) Net Income (Loss) Retained Earnings, October 1 Retained Earnings, September 30 $ Enterprise 0 (3,821 ,539) (3,821,539) 2 ,445,470 35,844,063 38,289,533 $ $ Internal Service 0 0 0 (71 ,665) (19 I 262) (90,927) The notes to the financial statements are an integral part of this statement • 31. 1991 1990 $ 0 $ 200,000 (3,821,539) (4,701 ,449) (3,821,539) (4,501 ,449) 2,373,805 3,954,657 35,824,801 31,870,144 $ 38, 198, 606 $ 35,824,801 CITY OF COLLEGE STATION. TEXAS COMBINED STATEMENT OF CASH FLOWS ALL PROPRIETARY FUND TYPES FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 (With Comparative Totals for the Fiscal Year Ended September 30, 1990) Totals (Memorandum Only) Enterprise Internal Service Funds Funds 1991 1990 Cash Flows from Operating Activities: Cash Received from Customers $37 ,958,884 $3,702,808 $41,661,692 $41,048,922 Cash Payments to Suppliers for Goods and Services (24, 182,869) (2,503,971) (26 ,686,840) (26,398,619) Cash Payments to Employees for Services (3,779,432) (1,018,683) (4,798, 115) (4,303,372) Other 10, 157 0 10, 157 263,852 Net Cash Provided (Used) by Operating Activities 10,006,740 180,154 10,186,894 10,610,783 Cash Flows from Noncapltal Financing Activities: Operating Transfers In from (Out to) Other Funds (3,821,539) 0 (3,821,539) (4,501,449) Cash Received from Customer Prepayments 0 0 0 27,703 Cash Provided (Used) by Other Noncapital Financing Activities 219,613 (3,407) 216,206 58,485 Net Cash Provided (Used) by Noncapital Financing Activities (3,601,926) (3,407) (3,605,333) (4,415,261) Cash Flows from Capital and Related Financing Activities: Acquisition and Construction of Capital Assets (5,577,868) (106,227) (5,684,095) (2,072,572) Proceeds • Sale of Capital Assets 15,000 0 15,000 Principal Paid on Revenue Bonds (2,415,000) 0 (2,415,000) (2,465,000) Principal Paid on General Obfigation Bonds (377,765) 0 (377,765) (382,023) Principal Paid on Certificates of Obligation (26,200) 0 (26,200) (26,200) Principal Paid on Obligation Under Capital Lease (378,849) 0 (378,849) (347,231) Interest Paid on Revenue Bonds (2,086,420) 0 (2,086,420) (2,022,414) Interest Paid on General Obligation Bonds (138,618) 0 (138,618) (157,917) Interest Paid on Certificates of Obligation (28,296) 0 (28,296) (31,440) Interest Paid on Obligation Under Capital Lease (214, 151) 0 (214, 151) (245,769) Proceeds from Revenue Bonds 4,800,000 0 4,800,000 0 Cash Received from Capital Grants 3,999 0 3,999 28,073 Cash Received from Special Assessments 0 0 0 719 Net Cash Used for Capital and Related Financing Activities (6,424, 168) (106,227) (6,530,395) (7,721,774) Cash Flows from Investing Activities: Purchase of Investments (15,836, 144) (480,449) (16,316,593) (24,073,359) Proceeds from Sale and Maturities of Investments 15,723, 188 420,493 16, 143,681 21,937,791 Interest on Investments 1,675,818 42,130 1,717,948 1,545,503 Net Cash Used for Investing Activities 1,562,862 (17,826) 1,545,036 (590,065) (Continued) -32- CITY OF COLLEGE STATION. TEXAS COMBINED STATEMENT OF CASH FLOWS ALL PROPRIETARY FUND TYPES FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 (With Comparative Totals for the Fiscal Year Ended September 30, 1990) (Continued) Net Increase (Decrease) in Cash Cash and Cash Equivalents, October 1 Cash and Cash Equivalents, September 30 Reconciliation of Operating Income (Loss) to Net Cash Provided (Used) by Operating ActMtles: Operating Income (Loss) Adjustments to Reconcile Operating Income to Net Cash Provided (Used) by Operating Activities: Depreciation • Amortization Provision for Uncollectible Accounts Change In Assets and Liabilities: Change in Accounts Receivable Change in Joint Venture Receivable Change in Other Receivables Change in Inventory Change in Prepaid Costs Change in Accounts Payable Change in Accrued Liabilities Change in Due to Joint Venture Change in Accrued Vacation Total Adjustments Net Cash Provided (Used) by Operating Activities Enterprise Funds $1,543,508 1,631,324 3,174,832 $6,420,850 2, 130,327 258,658 1,149,322 0 (566,032) 125,128 0 666,047 (44,435) (135,772) 2,647 3,585,890 $10,006,740 The notes to the financial statements are an integral part of this statement. -33- Internal Service Funds $ 52,694 43,628 $ 96 ,322 $(111,362) 91 ,772 0 4,381 0 0 0 221,455 114,746 (145,337) 0 4,499 291,516 $180,154 Totals (Memorandum Only) 1991 $1,596,202 1,674,952 3,271,154 $6,309,488 2,222,099 258,658 1,153,703 0 (566,032) 125,128 221,455 780,793 (189,772) (135,772) 7,146 3,877,406 $10, 186,894 1990 $(2, 116,317) 3,791,269 $1,674,952 $8,619,632 2,214,360 58,504 (463,102) (130,186) 0 (49,816) 32,098 (80,628) 233,550 135,772 40,599 1,991,151 $10,610,783 -34 - CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES The financial statements of the City of College Ststk>n, Texas (•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 stindard-setting body for establishing governmental accounting and financial reporting principles. The more significart "the City's accOUl)tlng policies are described below. A. REPORTING ENTITY The financial reporting entity is defined as (1) the primary government and (2) those component units for which the primary government is financially accountable. A primary government is financially accountable for the organizations that make up its legal entity. It is also financially accountable for the legally separate organizations if its officials appoint a voting majority of an organization's governing body and one or both of the following conditions are met: (a) the primary government is able to impose its will on the component unit or (b) the primary government's relationship with the component unit poses a real or potential financial benefit or burden for the primary government. Moreover, financial accountability also is deemed to exist even in the absence Of simple •accountability• (i.e. the appointment of a voting majority Of the organization's governing body) if the component unit is financially dependent upon the primary government. A primary government has the ability to impose its will on an organization if it can significantly influence the programs, projects, or activities of, or level of services performed or provided by, the organization. A financial benefit or burden relationship exists if the primary government (a) is entitled to the organization's resources; (b) is legally obligated or has otherwise assumed the obligation to finance the deficits of, or provide financial support to, the organization; or (c) is obligated in some manner for t� debt of the organization. If an organization is unable to adopt its budget, levy taxes, or set rates or charges, or issue bonded debt without approval by the primary government, then it is deemed to be fiscally dependent on the primary government and is included as a component unit. Included within the reporting entity for the City is the Brazos Valley Solid Waste Management Agency. The Brazos Valley Solid Waste Management Agency ("BVSWMA") was created May 8, 1990, by the Cities of Bryan and College Station, Texas, to achieve economy of scale savings for the participants through joint ownership and use of regional waste management facilities. BVSWMA is governed by an Administrative Board of Trustees ("Board") comprised of the City Manager and a staff person from each city. In addition, the Mayors of each city serve alternating two-year terms on the Board, which has complete responsibility for the daily operating activities of BVSWMA. The BVSWMA annual budget is first approved by the BVSWMA Board and then submitted for approval by both cities as a part of their regular budget process. Excluded from the reporting entity of the City is the College Station Economic Development Foundation. In 1981 the College Station Industrial Development Foundation ("CSIDF") was created to encourage development of an industrial park through the issuance of tax-exempt financing. In fiscal year 1986, the CSIDF was restructured as the College Station Economic Development Foundation ("CSEDF") with the purpose of accumulating funds for the improvement of commercial or industrial property in the City and buying and selling real property in College Station to promote the public interest of the City. The CS EDF is administered by a separate board and is not subject to oversight by the Mayor and City Council. -35 - CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 1. SUMMARY OF SIGNIFICANT ACCOUNTING POUCIES-(Continued) B. FUND ACCOUNTING The City uses funds and account groups to report on its financial position and the results of operations. Fund accounting is designed to demonstrate legal compliance and to aid fi�ial management by segregating transactions related to certain government functions or activities. A fund is a separate accounting entity with a self-balancing set of accounts. Government resources are allocated to and accounted for in individual funds based upon the purposes for which they are to be spent and the means by which spending activities are controlled. An account group, on the other hand, is a financial reporting device designed to provide accountability for certain assets and liabilities that are not recorded in the funds because they do not directly affect net expendable available financial resources. Funds are classified into three categories: governmental, proprietary, and fiduciary. Each category is divided into separate "fund types". The two broad fund categories used by the City in the accompanying financial statements are governmental and proprietary. The separate fund types are as follows: Governmental Fund Types The General Fund is the general operating fund of the City and is used to account for all financial resources except those required to be accounted for in another fund. Special Revenue Funds are used. to account for the proceeds of specific revenue sources (other than major capital projects). The Debt Service Fund is used to account for the accumulation of resources for, and the payment of, general long­ term debt principal, intereSt, and related costs. Capital Projects Funds are used to account for financial resources to be used for the acquisition or construction of major capital facilities (other than those financed by proprietary funds). Proprietary Fund Types Enterprise Funds are used to account for operations (a) that are financed and operated in a manner similar to private business enterprises -where the intent of the governing body is that the costs (expenses, including depreciation) of providing goods or services to the general public on a continuing basis are to be financed or recovered primarily through user charges; or (b) where the governing body has decided that periodic determination of revenues earned, expenses incurred, and/or net income is appropriate for capital maintenance, public policy, management control, accountability, or other purposes. Internal Service Funds are used to account for the financing of goods or services provided by one department or agency to other departments or agencies of the City, or to other governments, on a cost-reimbursement basis. -36- CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 1. SUMMARY OF SIGNIFICANT ACCOUNTING POUCIES-(Continued) The account groups used by the City in the accompanying financial statements are as follows: General Fixed Assets Account Group -This account group is established to 8CCOlrt for all fixed assets of the City, other than those accounted for in the proprietary funds. General Long-Term Debt Account Group-This account group is established to 8CCOlrt for all long-term debt of the City except that accounted for in the proprietary funds. General long-term debt of the City includes general obligation bonds, certificates of obligations and accrued vacation leave. C. BASIS OF ACCOUNTING The accounting and financial reporting treatment applied to a fund is determined by its measurernert focus. All governmental funds are accounted for using a current financial resources measurernert focus. With this measurement focus, only current assets and current liabilities generally are included on the balance sheet. Operating statements of these funds present increases and decreases in net current assets. All proprietary funds are accounted for on a flow of economic resources measurement focus. With this measurement focus, all assets and all liabilities associated with the operation of these funds are included on the balance sheet. Fund equity is segregated into contributed capital and retained earnings components. Proprietary fund-type operating statements present increases and decreases in net total assets. The modified accrual basis of accounting is used by all governmental fund types. Under the modified accrual basis of accounting, revenues are recognized when susceptible to accrual (i.e., when they become both measurable and available). •Measurable• means the amount of the transaction can be determined and •available• means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Those revenues susceptible to accrual are property taxes, franchise taxes, interest revenue and charges for services. Sales taxes collected and held by the State at year-end on behalf of the City are also recognized as revenue. Fines and permits are not susceptible to accrual because generally they are not measurable until received in cash. Expenditures are generally recognized under the modified accrual basis of accounting when the related fund liability is incurred. Exceptions to this general rule are the principal and interest on general long-term debt which are recognized when due, and accrued vacation leave which is recognized when expected to be liquidated with expendable available financial resources. -37- CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 1. SUMMARY OF SIGNIFICANT ACCOUNTING POUCIES-(Continued) All proprietary funds are accounted for using the accrual basis of accounting. Revenues in these funds are recognized when they are earned, and expenses are recognized when they are incurred. Utility customers are billed monthly on a cycle-billing basis with revenues recorded when customers are billed, except at year-end when unbilled revenues are accrued. D. POWE R COST RECOVERY The City is allowed to recover purchased power costs as power cost act;ustments. This power cost recovery allows for the pass-through of power costs to the customers and has no impact on net income. The amount of any ooder or over recovered purchased power costs at year-end was not material. E. BUDGETS AND BUDGETARY ACCOUNTING The City follows these procedures in establishing the budgetary data reflected in the financial statements: 1) Prior to September 1, the City Manager submits to the City Council a proposed operating budget for the fiscal year commencing the following October 1. The operating budget includes proposed expenditures and the means of financing them. 2) All budget requests are compiled by the Finance Department and presented with comparative and supporting data to the Mayor and City Council for review. 3) Public hearings are properly advertised and conducted at City Hall for taxpayer comments. 4) Prior to September 27, the budget is legally enacted through passage of an ordinance. 5) The City Council must approve all transfers of budgeted amounts between departments within any fund and any revision that alters the total expenditure of any fund. An amount is also budgeted each year for contingencies which may arise. The Council has authorized the City Manager to make budget transfers for contingencies if the amount does not exceed $10,000. All other transfers must be approved by City Council. City Council may transfer amounts among individual budget line items within major expenditure categories during the year, but no such transfer may increase the overall total of the budget. Budgeted amounts as originally adopted were not significantly changed by such transfers during the year. 6) The City Charter requires that a petition be signed by 100 registered voters of the City prior to City Council's consideration of an ordinance amending upward the total of any fund of the city. 7) Expenditures in excess of appropriations for each fund are prohibited by the City Charter. Appropriations which have not been expended or lawfully encumbered lapse at the end of the budget year. 8) Formal budgetary integration is legally enacted and employed as a management control device during the year for all funds. -38 - Cl!Y OE COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 1. SUMMARY OE SIGNIFICANT ACCOUNTING POUCIES-(Continued) The General Fund budget is adopted on a basis that differs from GAAP, as foll01Ns: (a) The City does not include in General Fund budgetary amounts revenue or expenditure activity for the Fireman's Relief Fund which is combined with the General Fund for reporting purposes. (b) General Fund budgetary amounts do not include provisions for adjustments in inventory, the all01Nance for uncollectible accounts receivable, or the capitalization of salaries for capital improvements projects. Adjustments necessary to convert the General Fund revenues at September 30, 1991, on the. GAAP basis to the budgetary basis are as foll01Ns: Revenues and Other Financing Sources - GAAP basis Reconciling Items: Fireman's Relief Fund -Revenues Other Total Reconciling Items Total Revenues and Other Financing Sources -Budget (Non-GAAP Basis) $13.713.125 (4,347) 18.602 14.255 $13.727.380 Adjustments necessary to convert the General Fund expenditures at September 30, 1991, on the GAAP basis to the budgetary basis are as foll01Ns: Expenditures and Other Financing Uses-GAAP Basis Reconciling Items: Prior Year Encumbrances Fireman's Relief Fund Expenditures Inventory Adjustment Allowance for Uncollectible Accounts (Adjustment) Capitalized Salaries Other Total Reconciling Items Total Expenditures and Other Financing Uses -Budget (Non-GAAP Basis) -39 - $14.167.500 (75,271) (3,039) (14,768) (18,604) 46,413 (7.793) (73.062) $14.094,438 CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 1. SUMMARY OF SIGNIFICANT ACCOUNTING POUCIES-(Continued) Budgets for the Special Revenue Funds, Debt Service Fund, and Capital Projects Funds are adopted on a basis consistent with GAAP. Budgets for the Enterprise Funds are adopted on a basis consistent-with GAAP, except for the following significant items: (a) Capital outlay is included in the budget as an expense item. (b) Transfers to the Debt Service Fund for debt principal payments, relating to General Obligation Bonds and Certificates of Obligation which are serviced by the Electric, Wat.er and Sewer Funds, are treated as expenses for budgetary purposes. · (c) The budget considers principal payments for Utility Revenue Bonds as an expense item. (d) Enterprise Fund budgetary amounts do not include provisions for adjustments in inventory or the allowance for uncollectible accounts receivable. (e) The City does not budget for depreciat.ion on Enterprise Fund property and equipment. (f) Budgeted revenue amounts do not include a provision for revenue accruals. The budget for the Internal Service Funds are adopted on a basis consistent with GAAP, except for the following significant items: (a) Capital outlay is included in the budget as an expense item. (b) The City does not budget for depreciat.ion on Internal Service Funds fixed assets. Budgetary comparisons presented in the report are on the aforementioned budgetary basis. Budgetary amounts are as originally adopted, or as amended by the City Council. Individual amendments were not mat.erial in relation to the original appropriat.ions which were amended. -40 - CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 1. SUMMARY OF SIGNIFICANT ACCOUNTING POUCIES-(Continued) F. Cash and Cash Equivalents Cash and cash equivalents are short term highly liquid investments that are: (a) readily convertible to known amounts of cash; and (b) so near their maturity that they present insignificant risk of changes in value because of changes in interest rates. Therefore, for purposes of the statement of cash flows, cash and cash equivalents (including restricted assets) include demand accounts, repurchase agreements, and government securities and agency notes with original maturities of three months or less when purchased. The City uses a pooling method to account for cash and cash equivalents. Equity in cash and cash equivalents and interest income from the cash pool is allocated to the participating funds on a monthly basis. The amount of the allocation is determined by calculating a ratio of each fund's equity in the pool to the total pool. G. INVESTMENTS Investments of all funds consist mainly of U. S. Treasury and Agency securities, bank certificates of deposit and investments in public funds investments pools (TexPooQ. Investments are stated at cost or amortized cost which approximates market value. State statutes authorize the City to invest in fully-insured time deposits, direct debt securities of the United States, and fully collateralized repurchase agreements. The repurchase agreements must be purchased pursuant to a master repurchase agreement which specifies that the transaction be held in a safekeeping account subject to the control and custody of the City. Investments in security repurchase agreements may be made only with the City's depository bank, with state or national banks domiciled in the state of Texas, or with securities dealers reporting to the Federal Reserve Bank of New York (•Primary Dealers•). All securities are purchased delivery-vs.-payment and held in the City's name in a safekeeping account at First City National Bank of Houston. Investments are made in accordance with the City's Investment Policy which was adopted by the City Council on April 12, 1990. This policy is applicable to all City funds and permits investment in obligations of the U.S. Government or its agencies, repurchase agreements made in compliance with State of Texas Statutes, time certificates of deposit or savings accounts in state or national banks located within the State of Texas, public funds investment pools, and money market mutual funds. This policy designates the Director of Finance as the City's Investment Officer with whom responsibility and authority for investment transactions reside. The City also uses a pooling method to account for investments. Equity in investments and interest income from the investment pool is allocated to the participating funds on a monthly basis and is determined by calculating a ratio of each fund's equity in the investment pool to the total pool. -41 - CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(Continued) H. INVENTORY Inventory is valued at cost, which approximates market, using the first-in, first-out method. The costs of governmental fund type and proprietary fund inventories are record�d as expenditures/expenses when consumed rather than when purchased. I. PREPAID COSTS Payments made to vendors for services that will benefit periods beyond September 30, 1991, are recorded as prepaid costs. J. RESTRICTED ASSETS In the enterprise funds, proceeds of utility revenue bonds, as well as resources set aside for their repayment, are classified as restricted assets on the balance sheet because their use is limited by applicable bond covenants. In addition, customer utility deposits are classified as restricted assets because the deposit remains the property of the customer and is not available for operations. In the General Fund, restricted assets are comprised of Municipal Court cash bonds, cemetery perpetual care funds and fireman's relief funds, all of which are not available for operations. K. INVESTMENT IN JOINT VENTURE The Proprietary Fund's investment in joint venture is recorded using the equity method of accounting. Required disclosures concerning the joint venture are presented in Note 13. L. FIXED ASSETS General fixed assets have been acquired for general government purposes. Asset purchases are recorded as expenditures in the governmental fund types and capitalized in the General Fixed Assets Account Group at cost where historical records are available and at an estimated historical cost where no historical records exist. Donated fixed assets are valued at their estimated fair market value. Public domain fixed assets consisting of improvements other than buildings are also included in the General Fixed Assets Account Group. No depreciation has been provided on general fixed assets, nor has interest been capitalized. Property and equipment owned by the Enterprise Funds and the Internal Service Funds is stated at the historical cost of acquisition, construction or, with respect to contributions of construction from third parties (principally developers), at fair market value. In accordance with Financial Accounting Standards Board Statement No. 71, interest is not capitalized during construction because interest is recovered currently in the City's established rate. -42- CITY OF COLL EGE STATION. TEXAS NOT ES TO GENERAL PURPO SE FINANCI AL STAT EMENTS FOR THE FI SCAL YEAR EN DED SEPTE MBER 30, 1991 1. SU MMARY OF SIGNIFICANT ACCOUNTING POUCI E S-(Continuecl) Maintenance, repairs and minor renewals are charged to operating expense; major property replacements are capitalized. Depreciation is recorded in the above funds on a straight-line basis ""�the following estimated se rvice lives: Utility Systems Buildings and lmpr01ements Equipment M. CO MPENSAT ED ABSENCES 25-40years 5-SO years 3-10years Employees are credited with vacation at rates of 1 o to 15 clays per year, depending upon length of serv ice. CarryO/er of unused vacation time from one year to the next is allowed for a maximum of two years. Upon termination, the respective employees are paid for any accrued vacation not taken (up to the two-year maximum). Accumulated vacation leave that is expected to be liquidated with expendable available fi nancial resources is reported as an expenditure and a liability of the General Fund. Amounts of accumulated vacation leave that are not expected to be liquidated with expendable available fi nancial resources are reported in the General Long-Term Debt Account Group. Employees are credited with si ck leave at the rate of one day per month and are allowed to accumulate up to 120 days. Payment for unused accumulated si ck leave is not made to employees by the City and, accordingly, no liability has been recorded in the financial st atements. N. LON G-TER M OB LIGATIONS Long-term debt is recognized as a liabllity of a governmental fund when due or when resources have been accumulated in the Debt Service Fund for payment early in the following year. For other long-term obligations, only that portion expected to be financed from expendable available financial resources is reported as a fund liability of a governmental fund. The remaining portions of su ch obligations are reported in the General Long-Term Debt Account Group. Long-term liabilities directly related to and financed from proprietary fund operations are accounted for in those funds. All other unmatured long-term indebtedness of the City is accounted for in the General Long-Term Debt Account Group. 0.ENCUMBRANC ES Encumbrance accounting, under which purchase orders, contracts and other commitments for the expenditure of monies are recorded in order to reserve that portion of the applicable appropriation, is employed as an extension of formal budgetary integration in the governmental fund types. Encumbrances outstanding at year end are reported as reservations of fund balances si nce they do not constitute expenditures or liabilities in the general purpose financial statements. -43- CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 1. SUMMARY OF SIGNIFICANT ACCOUNTING POUCIES-(Continued) P. FUND EQUITY Contributed capital is recorded in proprietary funds that have received_ capital grants or contributions from developers, customers or other funds. Reserved balances represent those portions of fund equity not appropriable for expenditure or legally segregated for a specific future use. Designated fund balances represent tentative plans for future use of financial resources. Q. BOND DISCOUNTS/ISSUANCE COSTS In governmental fund types, bond discounts and issuance costs are recognized as an expenditure in the current period. Bond discounts and issuance costs for proprietary fund types are deferred and amortized over the term of the bonds using the straight-line method. Bond discounts are presented as a reduction of the face amount of bonds payable, and issuance costs are recorded as deferred charges. R. INTERFUND TRANSACTIONS Quasi-external transactions are accounted for as revenues, expenditures or expenses. Transactions that constitute reimbursements to a fund for expenditures/expenses initially made from that fund which are properly applicable to another fund are recorded as expenditures/expenses in the reimbursing fund and as reductions of expenditures/expenses in the fund that is reimbursed. lnterfund transactions other than quasi-external transactions and reimbursements are reported as operating transfers. · S. STATEMENTS OF CASH FLOWS The City has elected to use the direct method in presenting the Statements of Cash Flows for each of the Proprietary and Internal Service Funds. T. MEMORANDUM ONLY -TOTAL COLUMNS Total columns on the. General Purpose Financial Statements are captioned "Memorandum Only" to indicate that they are presented only to facilitate financial analysis. Data in these columns does not present financial position, results of operations, or cash flows in conformity with generally accepted accounting principles. Neither is such data comparable to a consolidation. lnterfund eliminations have not been made in the aggregation of this data. U. COMPARATIVE PATA Comparative total data for the prior year have been presented in the accompanying financial statements in order to provide an understanding of changes in the City's financial position and operations. However, comparative data have not been presented in all statements because their inclusion would make certain statements unduly complex and difficult to understand. V. ACCOUNTING CHANGE During 1991, the City changed the method of recording sales taxes from the cash basis to accruing for sales tax remitted by the state to the City in October. As these amounts are available to pay liabilities of the current period, the change is appropriate under the modified accrual basis of accounting. The accounting change resulted in an accrual of sales tax revenues in the amount of $570, 160. -44 - CITY OF COLLEGE STATION. TE)(AS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 2. DEPOSITS AND INVESTMENTS At year-end, the carrying amount of the City's cash and time deposits was ($56,018), and the bank balance was $465,334. The City also had investments in the state investment pool amounting to $4,681,812, and a $50,000 certificate of deposit committed for cemetery perpetual care. Balance sheet amounts for unrestricted and restricted cash and cash equivalents at September 30, 1991, are as follows: Unrestricted cash and cash equivalents Restricted cash and cash equivalents $ 2,595,885 2.079.909 $ 4.§75.794 The bank balance and certificate of deposit were entirety covered by federal depository insurance or by pledged collateral held by the City's third-party custodian in the City's name. The state investment pool represents short term investments in a pool managed by another government for which risk categorization is not appropriate because the City's investment is not evidenced by securities that exist in physical or book entry form. The City's investments at September 30, 1991, are shown below. The carrying amount is the cost at date of purchase and approximates market value, except for U.S. Government Obligations, and Government Agency Notes, where market values may be independently obtained: Carrying Market Amount Value U.S. Government Obligations $ 13,760,321 $ 14,869,858 Government Agency Notes 9,612,663 9,835,125 Total Investments $ 2313721984 $ 24.7041983 All of the City's investments consist of U.S. Government Securities and repurchase agreements of U.S. Government Securities and are held by its agent in the City's name (Category One credit risk). 3. PROPERTY TAXES Property is appraised and a lien on such property becomes enforceable as of January 1. Taxes are levied and payable on October 1. The Brazos County Tax Office bills and collects property taxes for the City. City property tax revenues are recognized when levied to the extent that they are collected in the current year. The balance is reported as deferred revenues. Taxes become delinquent February 1 of the following year and are subject to interest and penalty charges. The City is permitted by the State of Texas to levy taxes up to $2.50 per $100 of assessed valuation for general governmental services and for the payment of principal and interest on general long-term debt. The combined current tax rate to finance general government services including debt service for the year ended September 30, 1991, was $.40 per $1 oo of assessed valuation. The Brazos County Appraisal District ("Appraisal District") is responsible for the recording and appraisal of property for all taxing units in Brazos County. The Appraisal District is required to assess property at 100% of its appraised value. Real property must be reappraised at least every four years. The City may, at its own -45 - CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 3. PROPERTY TAXES-(Continued) expense, require annual reviews by the Appraisal District through various appeals and, if necessary, legal action. Under this system if the rate, excluding tax rates fOf bonds and other contractual obligations adjusted fOf new improvements, exceeds the rate for the previous ye&1 by more than 8%, qualified voters of the City may petition for an election to determine whether to limit the tax rate to no more than 8% above the tax rate of the previous year. 4. NOTES RECEIVABLE General Fund: During 1986, the City sold land valued at $943,894 to the CSEDF (see Note 1). In exchange for this rand, the City received a $3,000,000 noninterest-bearing promissory note to be repaid at face value in ten years or when the CSEDF sells the land, whichever comes first. In addition, the CSEDF has agreed to share profits with the City related to the eventual sale of the land by the CSEDF and to comply with certain financial covenants and legal restrictions. On October 1 , 1991, the Bryan-College Station Economic Development Corporation was formed to promote economic development within the two cities. As a result, on October 15, 1991, the CSEDF approved a resolution dissolving the CSEDF. During fiscal year 1992, ownership of the land will be transferred to the City. During 1991, the City sold a roller valued at $73,800 to the Brazos Valley Solid Waste Management Agency ("BVSWMA ") in exchange for a promissory note to be repaid in semi-annual installments over a period of six years at 8% (see Note 13). Special Revenue Funds: In 1988, the City initiated a Community Development Loan Program which provides loans to eligible applicants from Community Development Block Grant funds. The $179,842 balance in the Special Revenue Funds represents the outstanding principal for these loans at September 30, 1991. Debt Service Fund: During 1991, the City also loaned BVSWMA $625,000 for the purchase of equipment in exchange for an eight year 6% note to be repaid in semi-annual installments (see note 13) . • 46. 5. FIXED ASSETS CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 A summary of changes in general fixed assets for the year ended September 30, 1991, is as follows: Additions Beginning and Balance Transfers In Land $ 4,999,926 $ 89,112 Buildings and Building Improvements 11,448,305 1,583,269 Improvements 12,390,473 1,712,946 Machinery, Tools and Equipment 8,981,715 1,346,210 Parks System 5,761,583 65,361 Construction in Progress 2.425.974 2.204.117 Total $ 46.007.976 $ 7.001.015 Retirements and Transfers Out $ 0 0 0 327,114 0 3.999.283 $ 4.326.397 E ndi ng Balance $ 5,089,038 13,031,574. 14,103,419 10,000,811 5,826,944 630.808 $ 48.682.594 A summary of proprietary fund type property and equipment at September 30, 1991, is as follows: Combined Utility Solid Waste Utility Billing Landfill Fund Fund Fund Fund Total Electric System $10,452,451 $ 0 $ 0 $ 0 $ 10,452,451 Weier System 26,849,614 0 0 0 26,849,614 Sewer System 18,774,351 0 0 0 18,774,351 Machinery & Equipment 3,363,935 1,294,376 522,598 18,765 5,199,674 Buildings and Improvements 6,999,939 0 0 0 6,999,939 Land 1,648,197 0 0 0 1,648,197 Construction in Progress 6,614,936 0 0 0 6,614,936 Total 74,703,423 1,294,376 522,598 18,765 76,539,162 Less Accumulmed Depreciation (17,908,408) (958,187) (245,071) (1,711) (19, 113,377) Net $ 56,795,015 $336,189 $ 277,527 $17,054 $ 57,425,785 • 47. 6. CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 LONG-TERM DEBT The following is a summary of long-term debt transactions for the year ended September 30, 1991 : Beginning Incurred/-Ending Balance Issued Matured Balance Governmental Fund T�oes General Obligation Bonds $ 20,664,590 $ 0 $ 2,087,235 $ 18,577,355 Certificates of Obligation 250,983 119,258 131,725 Contractual Obligations 0 1,125,000 1,125,000 Accrued Vacation Leave 460,190 532,455 453,728 538,917 Subtotal 21.375,763 1,657,455 2,660,221 20.372,997 Progrietaiy Fund T�()eS Utility Revenue Bonds 21,820,000 4,800,000 2,415,000 24,205,000 General Obligation Bonds Serviced by Utility Revenues 2,900,410 0 377,765 2,522,645 Certificates of Obligation Serviced by Utility Revenues 235,800 0 26,198 209,602 Accrued Vacation Leave: Electric Fund 61,241 63,778 58,451 66,568 Water Fund 25,557 39,162 40,709 24,010 Sewer Fund 29,048 35,484 33,846 30,686 Solid Waste Fund 21,050 27,447 30,218 18,279 Landfill Fund 6,950 10,294 7,724 9,520 Utility Billing Collection Fund 29,251 34,471 32,541 31,181 Obligations Under Capital Lease-(Note 12) 3,070,961 378,848 2,692,113 Subtotal 28.200,268 5,010,636 3.401,300 29.809,604 Total Long-Term Debt $ 4915761031 m 616681091 m 610611521 m 5011821601 - 48 - CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 6. LONG-TERM DEBT-(Continued) Long-term debt at September 30, 1991, consisted primarily of bonds maturing serially and is summarized as follows: General Obligation Bonds: 19681ssue 19761ssue 19781 Issue 1978 II Issue 1982 Series II Issue 1984 Issue 1987 Refunding Issue 1988 Refunding Issue 1989 Issue Subtotal Certificates of Obligation: Ladder Truck C of C Building Subtotal Contractual Obligation, Series 1991 Utility Revenue Bonds: 1985 Refunding Issue 1990 Issue Subtotal General Obligation Bonds Serviced by Utility Revenues: 1976 Issue 19781 Issue 1987 Refunding Issue Subtotal Certificates of Obligation Serviced by Utility Revenues: Utility Service Center Total Interest Rates(%) 4.40 -6.00 4.00 -6.00 4.70 -6.00 5.15 -5.80 9.00 -11.00 9.50 -11.00 4.50 -7.70 6.15 -8.15 6.50 -8.50 SOo....b of Prime 57.5% of Prime 6.00% 6.00-9.50 6.50-8.50 4.00-6.00 4.70-6.00 4.50-7.70 12.00 -49- Series Matures 1995 1997 1998 1999 1 993 1995 2004 1996 2005 1993 1992 1 992 2001 2006 1997 1998 2004 1999 Principal Balance $ 145,000 450,000 225,000 1,220,000 875,000 1,800,000 8,537,355 2,300,000 3.025.000 18.577.355 86,539 45.186 131.725 1.125.000 1�,405,000 4.800.000 24.205.000 1,350,000 1,025,000 147.645 2.522.645 209.602 $46, 771,327 CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 6. LONG-TERM DEBT-(Continued) Debt service requirements to maturity for all bonds are summarized as fella.vs: Year 1992 1993 1994 1995 1996 1997-2001 2002-2006 Total Year 1992 1993 1994 1995 1996 1997-2001 2002-2006 Total Year 1992 1993 1994 1995 1996 1997-2001 2002-2006 Total General Obligation Bonds Principal $2,098,765 1,889,205 1,761,045 1,631,130 2,833,735 6,106,935 2.256.540 $ 18.577.355 Interest 1,253,370 1,094,160 954,335 828,667 674,599 1,747,209 271.788 $ 6.824.128 Contractual Obligation Principal Interest $ 1,125,000 $ 33,750 $ 1.125.000 $ 33.750 General Obligation Bonds Services by Utility Revenues Principal Interest $ 376,235 $ 118,972 370, 795 99,263 378,955 79,305 378,870 59,076 386,265 40,271 608,065 41,576 23.460 2.677 $ 2.522.645 $ 441.140 • 50. Certifacates of Obligation Principal I at er est $ 107,474 $ 8,570 24,251 1,601 $ 131.725 $ 10.171 Utility Revenue Bonds Principal $ 2,475,000 2,375,000 2,325,000 2,405,000 2,505,000 9,920,000 2.200.000 $24.205.000 Interest $ 1,972,976 1,769,820 1,567,845 1,360,185 1,141,588 2,663,369 377.000 $10.852.783 Certificat es of Obligation Services by Utility Revenues Principal . Interest $ 26,201 $ 25, 152 26,200 22,008 26,200 18,864 26,200 15, 720 26,200 12,576 78,601 18,864 $ 209.602 $ 113.184 CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 6. LONG-TERM DEBT-(Continued) All the net revenues of the Utility Fund are pledged for the payment of debt service of the revenue bonds and other indebtedness payable from those revenues. Net revenues, as defined by the revenue · bond resolution, include substantially all of the revenues and expenses of the Utility Fund other than certain i nterest income and expense, and depreciation and amortization. This bond resolution further requires that the net revenues, as defined, equal at least 1 .40 times the average annual debt service on all revenue bond$ and other indebtedness payable from those revenues and 1.25 times the maximum annual debt service on al l revenue bonds and other indebtedness payable from those revenues. The maximum annual debt service is defined as the maximum principal and inte rest payments to be paid in any one year remaining in the life of the bonds, and the average annual debt service is defined as the sum of all principal and i nterest payments due over the remaining life of the bonds divided by the remaining life of the bonds. The City is in compliance with these requirements. In prior years the City defeased certain revenue refunding bonds totaling $39,610,000 and certain general obligation bonds and certificates of obligation totaling $11,821, 126 by placing the proceeds of the r efunding bonds in an irrevocable trust to provide for all future debt service on the refunded bonds. Accordingly, the trust account assets and the liability for the defeased bonds are not included in the City's general purpose financial statements. At September 30, 1991, the outstanding principal balance of these defeased revenue refunding bonds was $22,725,000. At September 30, 1991, the outstanding principal balance of the defeased general obligation bonds and certificates of obligation was $7 ,650,000. 7. BONDS AVAILABLE FOR SALE Authorized general obligation bonds available for future issue are as follows: Street Improvements Parks Improvements Drainage Improvements Public Buildings (Fire Station #4) Oversize Participation -Bridges Civic Center Total Year Authorized 1990 1990 1984 1984 1984 1976 Unissued Amount $4,500,000 1,000,000 1,230,000 . 700,000 500,000 500,000 $8,430,000 Revenue bonds, authorized in fiscal 1984, remain unissued in the amount of $2,615,000 and are available for future use. • 51 • CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 8. CONTRACT WITH GULF STATES UTILITIES The City purchases substantially all of its electrical power requirements from Gulf St ates Ut ilities (•Gulf St ates•). This contract requires the City's monthly minimum load to be not less than 15 kilowatts nor less than 60% of the City's great est maximum load (experienced during the previous 12 months) adjusted for Gulf States' power factor. The City's monthly Gulf States bill averages approximately $1 1589,4 15. The City has negotiated a new contract and will begin purchasing 100% of its power from the Texas Municipal Power Agency on December 30, 1991 . 9. RETIREMENT PLAN Plan Descriotion The City provides pension benefits for all of its full-time employees through a nontraditional, joint contributory, defined contribution plan in the st ate-wide Texas Municipal Retirement System (•TMRS•), an agent multiple-employer public employee retirement system with over 570 plans currently in operation. It is the opinion of the TMRS management that the plans in TMRS are substantially defined contribution plans, but they have elected to provide additional voluntary disclosure to help foster a bet ter understanding of some of the nontraditional characteristics of the plan. Benefit amounts are determined by the sum of the employee's contribution to the plan, with interest, and the City­ financed monetary credits, with interest. At the date the plan began, the City granted monetary credits for service rendered before the plan began of a theoretical amount equal to two times what would have been contributed by the employee, with interest, prior to est ablishment of the plan. The City currently provides monetary credits for service since the plan began of 200% of the employee's accumulated contributions, less amounts available from forfeitures. In addition, the City can grant as often as annually another type of monetary credit referred to as an updated service credit which is a theoretical amount which, when added to the employee's accumulated contributions and the monetary credits for service since the plan began, would be the total monetary credits and employee contributions accumulated with interest if the current employee contribution rate and City matching percent had always been in existence and if the employee's salary had always been the average of his salary in the last three years that are one year before the effective date. At retirement, the benefit is calculated as if the sum of the employee's accumulated contributions with interest and the employer-financed monetary credits with interest were used to purchase an annuity. Plan members can retire at ages 60 and above with 1 o or more years of service or with 25 years of service regardless of age. The plan also provides death and disability benefits. A member is vested after 1 O years, but he must leave his accumulated contributions in the plan. If a member withdraws his own money, he is not entitled to the employer-financed monetary credits, even if he was vested. These benefit provisions are adopted by the City Council with in the options available in the st ate statutes governing TMRS and within the actuarial constra ints also in the st atues. - 52 - CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 9. RETIREMENT PLAN-(Continued) Contribution Requirements The contribution rate for the empoyees is 5% of covered payroll, and the City's matching percent is currently 200% (calendar year 1992), both as adopted by the governing body of the City. Under the state law governing TMRS, the City's contribution rate is annually determined by the actuary. This rate consists of the normal cost contribution rate and the prior service contribution rate, both of which are calculated to be a level percent of payroll from year to year. The normal cost contribution rate finances the currently accruing monetary credits due to City matching percent, which are the obligation of the City as of an employee's retirement date, not at the time the employee's contributions are made. The normal cost contribution rate is the actuarially determined percent of payroll necessary to satisfy the obligation of the City to each employee at the time his retirement becomes effective. The prior service contribution rate amortizes the unfunded actuarial liability over the remainder of the plan's 25-year amortization period. When the City periodically adopts updated service credits and increases annuities in. effect, the increased unfunded actuarial liability is to be amortized over a new 25 year period. Currently, the unfunded actuarial liability is being amortized · over the 25-year period which began January, 1991. The unit credit actuarial cost method is used for determining the City contribution rate. Contributions are made monthly by both the employees and the City. Since the City needs to -know its contribution rate in advance to budget for it, there is a one-year lag between the actuarial valuation that is the basis for the rate and the calendar year when the rate goes into effect. ·The City's total payroll for the year ended September 30, 1991, was $13,493,490, and the City's contributions were based on a payroll of $12,971,271. Both the City and the covered employees made the required contributions, · amou nting to $822,349 (6.14% of covered payroll for the months in calendar year 1990 , 5.00% normal cost plus 1.14% to amortize the unfunded actuarial liability ,and 6.400A> for the months in calendar year 1991, 5.19% normal cost plus 1.21% to amortize the unfunded actuarial liability) for the City and $648,573 (5%) for the employees. The City adopted changes in the plan since the previous actuarial valuation which had the effect of increasing the City's contribution rate for 1991 by 0.03% of payroll. Funding Status· Although the substance of the City's plan is not to provide a defined benefit, in some form, some additional voluntary disclosure is appropriate due to the nontraditional nature of the defined contribution plan which had an initial unfunded pension benefit obligation due to the monetary credits granted by the City for services rendered before the plan began and which can have additions to the unfunded pension benefit obligation through the periodic adoption of increases in benefit credits and benefits. Statement No. 5 of the Governmental Accounting Standards Board (GASB 5) defines pension benefit obligation as a standardized disclosure measure of the actuarial present value of pension benefits, adjusted for the effects of projected salary increases, estimated to be payab le in the future as a result of employee service to date. The measure is intended to help users assess, on a going-concern basis, the funding status of public employee pension plans, assess progress made in accumulating sufficient assets to pay benefits when due, and make comparisons among public employee pension plans . • 53. CITY OF CO LLEGE STATION. TE)(AS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR 11-tE FISCAL YEAR ENDED SEPTEMBER 30, 1991 9. RETIREMENT PLAN-(Continued) The pension benefit obligation shown below Is similar in nature to the standardized disclosure measure required by the GASB Statement 5 for defined benefit plans except that there Is no need to project salary increases since the benefit credits earned for serviat to date are not dependent upon Mure salaries. The calculations were made as part of the annual actuarial valuation as of December 31, 1990. Because of the money-purchase nature of the plan, the interest rate assumption, currently 8.5% per year, does not have as much impact on the results as it does for a defined benefit plan. Market value of assets is not determined for each city's plan, but the market value of assets for TMRS as a whole was 106.2% of book value as of December 31, 1990. The total unfunded pension benefit obligation at December 31, 1990, the latest available information, is as follows: Pension Benefit Obligation: Annuitants Currently Receiving Benefits Terminated Employees Current Employees Accumulated Employee Contributions Including Allocated Invested Earnings Employer-Financed Vested Employer-Financed Nonvested Total Net Assets Available for Benefits, at Book Value Unfunded Pension Benefit Obligation 1990 $ 1,309,182 1,192,888 4,572,172 4,627,489 2,198.387 13,900,118 11.509,969 $ 2.390.149 The book value of assets is amortized cost for bonds and original cost for short-term securities and stocks. The actuarial assumptions used to compute the actuarially determined City contribution rate are the same as those used to compute the. pension benefit obligation. The amounts above reflect the adoption of changes in the plan since the previous actuarial valuation, which had the effect of increasing the pension benefit obligation by $100,608 . • 54. CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOS E FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 9. RETIREMENT PLAN-(Continued) Trend Information Trend information gives an indication of the progress made in accumulating sufficient assets to pay benefits when due. Applicable historical trend inf ormati on concerning this plan is pr�ented below. Complete trend information prior to 1987 is unavailable. Additional historical trend information will be presented as it becomes available. Year Ended September 30 1987 1988 1989 1990 Year Ended September 30 1987 1988 1989 1990 Year Ended September 30 1987 1988 1989 1990 Net Assets Available for Benefits $ 7,299,624 8,806,929 10,123,841 11,509,969 Unfunded Pension Benefit Obligation $ 2,553,147 2,242,546 2,347,262 2,390,149 Employer Contributions $ 680,759 652,444 730,712 822,349 -55 - Pension Benefit Obligation $ 9,852,771 11,049,475 12,471,103 13,900,118 Annual Covered Payroll $12,861,559 11,028,053 11,949,309 12,971,271 Employee Contr ib utio n s $ 643,995 551,417 597,473 648,573 Net Assets Available as a Percent of Pension Benefit Obligation 74% SO°A, 81% 83% Unfunded Pension Benefit Obligation as a Percentage of Covered Payroll 20% 20% 20% 18% Employer Contributions as a Percentage of Annual Covered Payr oll 5.3% 5.9% 6.1% 6.3% CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 9. RETIREMENT PLAN-(Continued) Post Retirement Benefits In addition to providing pension benefits, the City provides certain health care benefits for retired employees. Substantially all employees may become eligible fa such benefits if they reach normal retirement age while working for the City. The health care benefits are provided ttvough a self-insurance plan administered by Donovan Benefit Systems (see Note 14). During fiscal year 1991, five retirees were eligible under this plan; however, claims filed by these retirees were not material. Fireman's Relief and Retirement Fund The City's General Fund is used to account for the accumulation of resources and the payment of annuities and related administrative costs of the Fireman's Relief and Retirement Fund, a closed, single-employer, defined contribution plan. Resources are contributed by the City at an annual fixed rate. The City has voluntarily contributed amounts as needed to maintain the solvency of the fund. The potential future liabilities related to these payments appear to be minimal due to the fact that it is estimated by the City that there are approximately 5 or less former employees who could become eligible for these $25 per month payments in the future. Total assets of the plan are included in the General Fund as a portion of the restricted cash balance. All qualitative and quantitative disclosures as required by the Governmental Accounting Standards Board are not made for the Fireman's Relief and Retirement Fund because such plan is not considered to be material. 10. SEGMENT INFORMATION OF ENTERPRISE FUNDS The City maintains four enterprise funds. Segment information for the year ended September 30, 1991, is as follows (amounts in thousands): Solid Waste Electric Wat.er Sewer Collection Fund Fund Fund Fund Total Operating Revenues: $26,896 $4,806 $3,857 $1,817 $37,376 Operating Expenses 22,994 2,212 1,836 1,786 28,828 (Excluding Depreciation) Depreciat.ion 748 727 512 140 2,127 Net Operating Income (Loss) 3,154 1,867 1,509 (109) 6,421 Operating Transfers, Net (2,632) (605) (443) (142) (3,822) Net Income (Loss) 1,060 403 709 311 2,483 Property and Equipment Additions 2,816 1,102 1,500 160 5,578 Net Working Capital 8,822 (7T/) 912 105 9,062 Total Assets 32,051 27,918 22,024 2,048 84,041 Bonds and Other Long-Term Liabilities -6,032 12,138 8,290 18 26,478 Excluding Current Portion Total Equity 20,991 13,105 12,525 2,000 48,621 • 56. CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 11. OPERATING AND OTHER TRANSFERS Individual fund operating and other transfers out and corresponding operating transfers in for fiscal 1991 were as follows: Operating and Other Transfers Out Operating and Other Transfers In Hotel Motel Hotel Motel GOB 1984 Electric Water Sewer Solid Waste Collection Electric Water Sewer Sewer General General 12. COMMITMENTS AND CONTINGENCIES Debt Service _ GOB 1982 Series 11 GOB1982 Series 11 Debt Service Debt Service Debt Service General General General General GOB 1982 Series II Parks Escrow Capital Equipment Amount $ 75,889 94,0CX> 173,0CX> 8,400 10,237 3,842 142,060 2,623,500 594,750 411,750 27,0CX> 299,164 421,382 Minimum future lease payments and present value of the net minimum lease payments for capital leases for waterwell and water storage facilities are as follows: Year Ending September 30. 1992 1993 1994 1995 1996 1997-2001 Total minimum lease payments Less imputed interest Present value of net minimum lease payments Total $ 592,999 592,999 592,999 293,586 250,813 1.013.006 3,336,402 (644.289) $ 2.692.113 The City is contingently liable for lawsuits and other claims in the ordinary course of its operations. The settlement of such contingencies under the budgetary process would require appropriation of revenues yet to be realized and would not materially affect the financial position· of the City at September 30, 1991 . 13. JOINT VENTURE In May 1990, the City of College Station joined the City of Bryan in creating BVSWMA. The primary purpose of BVSWMA is to achieve economy of scale savings for the participants through joint ownership and use of regional waste management facilities. Each city holds a 50% interest and ownership in BVSWMA. BVSWMA is governed by an Administrative Board of Trustees ("Board") comprised of the city manager and a staff person from each city; in addition, the mayors of each city serve alternating two-year terms on the Board. The Board has complete responsibility for the daily operating activities of BVSWMA. After Board approval, the BVSWMA annual budget is presented for approval by both cities as a part of their regular budget. "57 - CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 13. JOINT VENTURE (Continued) On May 8, 1990, the City transferred assets in the form of property permitted for landfill use and landfill equipment to BVSWMA in exchange for a note payable of $976,000, with the remaining consideration representing contributed capital of $85,100. The City's Solid Waste Collection Fund realized a gain of $626,795 on the transaction. BVSWMA recorded the transferred assets at their appraised values. The note accrues interest at a rate of 8% and is payable in semi-annual installments commencing November 1, 1990 and ending May 1 , 2000. The City's share of BVSWMA's net income for fiscal 1991 was $409,543 (unaudited). The City has been contracted as the operator of the landfill for BVSWMA. The City's Landfill Fund accounts for such activity, and the City is reimbursed by BVSWMA for all operating expenses of the Landfill Fund, which were $599,866 in 1991. The following is a summary of information from the audited financial statements of BVSWMA as of September 30, 1991 (unaudited), and 1990. Assets Current Assets Property, Plant and Equipment (Net of $214,495 Accumulated Depreciation at 1991 and $66, 151 at 1990) Other Assets Total Assets Liabilities Current Liabilities Notes Payable -Noncurrent Other Liabilities Total Liabilities Fund Equity: Contributed Equity Retained Earnings Total Fund Equity Total Liabilities and Fund Equity Total Operating Revenues Total Operating Expenses Operating Income Net Nonoperating Revenues (Expenses) Net Income 1fil!Q $1,944,896 $ 517,943 1,941,910 1,228,462 746,751 195,834 $4,633,557 $1,942,239 $ 401,806 $ 316,540 2,333,031 1,182,065 636,000 0 3,370,837 $1,498,605 170,200 170,200 1,092,520 273,434 1,262,720 443,634 $4,633,557 $1,942,239 $1,929,757 $ 724,828 1,054,499 416,078 875,258 308,750 (56, 172) (35,316) $ 819,086 $ 273,434 • 58. CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 13. JOINT VENTURE (Continued) Debt: Current Long Term Total 14. RISK MANAGEMENT $ 230,834 2,333,031 $2,563,865 $ 86,935 1,182,065 $1,269,000 The City is self-insured for health benefits, and the plan is administered by Donovan Benefit Systems. The Employee Benefits Fund is funded monthly by contributions from employees and from the operating funds of the City. These contributions are actuarially determined. The City has a stop-loss insurance policy that limits its liability per employee to $50,000 per incident with an aggregate, annual liability of $250,000. The liability for outstanding losses includes $53,572 for claims incurred but not reported. The City is also self-insured for workers' compensation benefits, and the plan is administered by Texas Political Subdivisions. The Workers' Compensation Fund is funded by actuarially determined contributions from the operating funds of the City. The City has a stop-loss insurance policy that limits its liability per employee to $200,000 per incident. The amount for estimated outstanding losses for claims incurred but not reported is not material. The City uses internal service funds to account for its risk-management activities. In addition, interfund premiums are reported as quasi-external transactions. 15. RESERVATIONS OF FUND BALANCES Fund balances have been reserved at September 30, 1991, as follows: General Fund: Reserved for Inventory Reserved for Encumbrances Reserved for Prepaid Costs Reserved for Fireman's Relief and Retirement Fund Total General Fund Reserved Special Revenue Fund -Reserved for Encumbrances Debt Service Fund -Reserved for Debt Service Capital Projects Fund -Reserved for Encumbrances Total 16. DEFICIT RETAINED EARNINGS $ 122,885 97,867 13,092 2.940 236,784 1,450 1,150,418 155.784 $1.544,436 At September 30, 1991, the Employee Benefits, Property and Casualty, and Utility Billing Funds had deficit unreserved retained earnings. In addition, the 1991 General Obligation Bond Fund had a deficit fund balance of $116,022. • 59. CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 16. DEFICIT RETAINED EARNINGS/FUND BALANCE (Continued) The $130,719 deficit in the Employee Benefits Fund resulted from administration fees and premiums in excess of the amounts budgeted. In fiscal 1991 the City increased the amount of premiums charged for both employee and dependent insurance coverage. In addition, cost containment measures continue to be implemented in order to eliminate this deficit. - The $43,489 deficit in the Property and Casualty Fund can be attributed to continued higher than expected insurance premium costs. The City has reevaluated the amounts charged each fund for property and casualty insurance in an effort to eliminate this deficit. The $132,861 deficit in the Utility Billing Fund can be traced to $249,669 of depreciation expense in the current and prior fiscal years which was not recovered in the charges for services received from other funds. The fiscal year 1992 budget allows for recovery of these prior year expenses so that the deficit can be eliminated. The $116,022 deficit in the 1991 Bond Fund was a result of expenditures for capital projects made prior to the issuance and sale of the bonds. In December, 1991, bonds were sold, and the proceeds were recorded in the 1991 Bond Fund. (See Note 17.) 17. SUBSEQUENT EVENT During December, 1991, the City issued $4,625,000 in General Obligation and Refunding Bonds. These bonds included $2,750,000 for street construction and improvements, $750,000 for parks construction and improvements and $1, 125,000 to refund the City's outstanding Public Property Finance Contractual Obligations, Series 1991. The bonds mature serially from February, 1993, to February, 2012, and carry an average coupon rate of 6.19%. The bonds have been rated A-1 and A+, respectively, by Moody's and Standard & Poors. 18. EXPENDITURES/EXPENSES IN EXCESS OF APPROPRIATIONS The amounts of any excesses of expenditures/expenses over appropriations and the funds in which they occurred are as follows: General Hotel/Motel Community Development Capital Equipment GOB 1984 GOB 1991 Electric Water Sewer Solid Waste Collection Employee Benefits Utility Billing Workers' Compensation Amount $ 40,634 918 2,389 2,905 27,419 30,831 63,285 26,792 100,078 100,979 85,330 1,673 91,521 The major portion of the excess in the General Fund occurred in salaries and benefits and was a result of recording accrued vacation which was not included in the budgetary amounts. - 60. CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 18. EXPENDITURES/EXPENSES IN EXCESS OF APPROPRIATIONS (Continued) The $918 excess in the HoteVMotel Fund was a result of unbudgeted special programs and projects expenditures, and the majority of the $2,389 excess in the Community Development Fund resulted from excess expenditures related to demolition costs associated with the community appearance program. Unbudgeted bond issuance costs were responsible for the majority of the $30,831 excess in the GOB 1991 Bond Fund while miscellaneous interest charges accounted for the $27,419 excess in the GOB 1984 Bond Fund. Unbudgeted fiscal agent's fees and interest expense for the 1991 revenu e bond issue were largely responsible for excesses of $63,285, $26,792, and $100,078 in the Electric, Water, and Sewer Funds, respectively. The $100,979 excess in the Solid Waste Collection Fund resulted from excess expenditures for disposal fees. Excess expenditures for administration fees and premiums were largely responsible for the $85,330 excess in the Employee Benefits Fund and the $91,521 excess in the Workers' Compensation Fund, while the recording of accrued vacation accounted for the $1,673 excess in the Utility Billing Fund • 61 • -62- GENERAL FUND The general fund is used to account for resources traditionally associated with government which are not required legally or by sound financial management to be accounted for in another fund. -63- CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF REVENUES AND OTHER FINANCING SOURCES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1991 Taxes: Current Property Delinquent Property Tax Penalty and Interest General Sales Mixed Drinks Franchise Total Taxes Licenses and Per11its: Mixed Drinks Ga11e Machines Builders Per11its Electrical Per11its Plumbing PerRlits Other Total Licenses and Permits Grants Charges for Services: Parks Concessions Pool Ad11iss,ions Sports Instruction Sports Programs Special Events Teen Center Other Parks Housing of Prisoners Arrest Fees Warrant Service Fees EMS Transport Municipal Court General Government Other Total Charges for Services Fines, Forfeits and Penalties: Municipal Court Fines Other Fines and Penalties Total Fines, Forfeits and Penalties: $ Budget 1,415,300 $ 36,000 14,500 5,800,000 77,000 348,900 7,691,700 12,000 2,000 51,000 6,000 25,000 2 500 98 500 3 210 72,500 67,000 69,640 121,350 14,500 2,700 3,600 5,000 35' 000 12,800 64,000 0 17,000 9 300 494 390 575,000 12 000 587 000 (Continued) • 64· Actual 1,427,769 35,623 19, 185 6,450,608 73' 101 328,524 8,334,810 11 '100 2,365 63,668 10,251 26,505 2 685 116 574 17 915. 70,994 73,941 55,537 123,048 9' 190 1 ,051 1,511 33,270 47' 139 10,348 87,466 480 16,857 9 264 540 096 483, 169 35 188 518 357 Variance Favorable (Unfavorable) $ 12,469 (377) 4,685 650,608 (3,899) (20,376) 643 110 (900) 365 12,668 4,251 1'505 185 18 074 14 705 (1'506) 6,941 (14 '103) 1,698 (5,310) ( 1 ,649) (2,089) 28,270 12' 139 (2,452) 23 ,466 480 (143) (36) 45 706 (91 ,831) 23 188 (68,643) CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF REVENUES AND OTHER FINANCING SOURCES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1991 (Continued) Budget Special Assess•ents $ 40,000 Use of Money and Property: Interest 213,500 Rents and Royalties 46,460 Interest on Loans 0 Total use of Money and Property 259,960 Miscellaneous: Contributions 0 Other 50,600 Total Miscellaneous 50,600 Total Revenues 9,225,360 Other Financing Sources: Payments in Lieu of Taxes 3,772,060 Sale of General Fixed Assets 100 000 Total Other Financing Sources 3,872,060 Total $13,097,420 . 65· $ Actual 31,016 254,375 45,053 2,892 302,320 1,422 69,283 70 705 9' 931 '793 3 '772 ,060 23,527 3,795,587 $13,727,380 Variance Favorable (Unfavorable) $ (8,984) 40,875 (1 ,407) 2 892 42,360 1 ,422 18 683 20, 105 706,433 0 (76,473) (76,473) $ 629,960 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1991 Budget Actual General Govern•ent: Mayor and council: Supplies $ 6, 110 $ 5,6B7 Maintenance 1,021 832 Other Purchased Services 22,389 14,926 Capital Outlay 783 783 Total Mayor and Council 30,303 22,228 City Secretary: Salaries and Benefits 79,323 79,266 Supplies 2,645 2,263 Maintenance 680 676 Purchased Property Services 1 ,361 1,355 Other Purchased Services 34,006 31,940 Capital Outlay 460 449 Total City secretary 118 475 115 949 City Manager: Salaries and Benefits 146,274 146,245 Supplies 7' 158 6,998 Maintenance 485 481 Purchased Professional Services 2,432 2,432 Purchased Property Services 1 '730 979 Other Purchased Services 29,433 27,771 Capital Outlay 4 574 2 603 Total City Manager 192 086 187 509 Legal: Salaries and Benefits 259,373 259,462 Supplies 16,449 16,448 Maintenance 870 867 Purchased Professional Services 10,039 10,034 Purchased Property Services 2,290 2,076 Other Purchased Services 18,444 16,462 Capital Outlay '4 085 4 085 Total Legal 311 550 309 434 Total General Government 652 414 635 120 (Continued) - 66- Variance Favorable (Unfavorable) $ 423 189 7 ,463 0 8 075 57 382 4 6 2,066 11 2 526 29 160 4 0 751 1'662 1 971 4 577 (89) 3 5 214 1 ,982 0 2 116 17 294 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1991 (Continued) Fiscal and Human Resources: Finance Administration: Salaries and Benefits Supplies Maintenance Purchased Professional services Purchased Property services Other Purchased Services Capital Outlay Total Finance Administration Human Resources: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Human Resources Accounting: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Accounting Purchasing and Stores: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Purchasing and Stores Budget $ (Continued) -67 - 169,674 5, 198 714 1,000 1 ,245 16,279 5,550 199,660 136,635 11 '154 250 1 ,042 1 ,600 36,347 3,206 190 234 269,790 10,375 1,320 125,523 2,890 63,893 2 204 475,995 146,306 5, 102 2,419 2,670 3,981 13,359 3 200 177 037 $ Actual 169,692 5,200 704 1,000 1,218 15,952 5,088 198,854 136,628 10,921 200 921 1 ,491 36,336 3 205 189,702 269,908 10' 303 967 125,706 2,818 63,723 2 205 475 630 145,526 4,340 1 ,444 2,671 3,582 11 ,403 1 981 170 947 Variance Favorable (Unfavorable) $ (18) (2) 10 0 27 327 462 806 7 233 50 121 109 11 532 (118) 72 353 (183) 72 170 1) 365 780 762 975 (1) 399 1 ,956 1 219 6 090 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1991 (Continued) Budget and Evaluation: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Budget and Evaluation Municipal Court: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Total Municipal Court Total Fiscal and Human Resources Budget $ 140,-568 2,519 350 1. 733 1,140 11 ,947 3 531 161,7B8 157,291 7,304 7,215 42,739 16,515 11 865 242,929 1 447 643 (Continued) -68- Actual $ 123,606 2,519 205 475 1,123 10,86B 3,533 142,329 157,371 7,302 7,212 42,740 16,384 11 668 242,677 1,420,139 Variance Favorable (Unfavorable) $ 16,962 0 145 1,258 17 1,079 (2) 19 459 (80) 2 3 ( 1 ) 131 197 252 27 504 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASI S) For the Fiscal Year Ended September 30, 1991 (Continued) Community Services Administration: Salaries and Benefits Supplies Maintenance Purchased Property Services Other Purchased Services Capital Outlay Total Community Services Administration Police: Police Administration: Salaries and Benefits Supplies Maintenance Purchased Professional Services Other Purchased Services Total Police Administration Uniform Patrol Division: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Uniform Patrol Criminal Investigation: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Criminal Investigation Budget $ 98,�19 621 111 330 12,515 330 112,626 308,608 6,000 1 ,300 1,021 28,531 345,460 1,669,016 67,380 28,235 19,455 150 53,478 90,473 1,928,187 432,299 13,735 10' 120 18,350 2,400 17' 049 11 710 505 ,6.63 (Continued) - 69- Actual $ 94,604 622 111 309 12,514 331 108,491 308,062 4 ,552 523 856 23,951 337 944 1,607,658 61'471 27,928 19' 455 60 48,272 86 742 1 ,851,586 378, 167 12,944 7,599 17 ,211 2,330 15,811 11 621 445 683 Variance Favorable (Unfavorable) $ 4' 115 ( 1 ) 0 ;11 1 1) 4 135 546 1 ,448 777 165 4 580 7 516 61 ,358 5,909 307 0 90 5,206 3 731 76 601 54' 132 791 2,521 1'139 70 1 ,238 89 59 980 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1991 (Continued) Special Services: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Special Services Technical Services: Salaries and Benefits Supplies Maintenance Purchased Property Services Other Purchased Services Capital Outlay Total Technical Services Com•unications/Jail: Salaries and Benefits Supplies Maintenance Purchased Professional Services Other Purchased Services Total Communications/Jail Total Police Budget $ 223,241 17 ,430 3,906 38,970 370 21,502 2,305 307,724 168,413 12' 120 38,289 75,112 28,822 875 323,631 354, 729 11,850 8,955 3,700 17 542 396 I 776 3,807,441 (Continued) -70 - Actual $ 222,999 15j227 3,901 37,714 95 20,295 0 300,231 166,911 9,589 34,735 61,634 23,865 875 297,609 328,562 6, 183 4,724 2,906 15 466 357,841 3,590,894 Variance Favorable (Unfavorable) $ 242 2,203 5 1 ,256 275 1,207 2,305 7 493 1 ,502 2,531 3,554 13,478 4,957 0 26 ,022 26,167 5,667 4,231 794 2 076 38 935 216 547 CITY OF COLLEGE STATION. TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1991 (Continued) Fire: Fire Ad•inistration: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Total Fire Administration Fire Suppression: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Fire Suppression Fire Prevention: Salaries and Benefits Supplies Maintenance Purchased Professional Services Other Purchased Services Total Fire Prevention Emergency Medical Services: Salaries and Benefits Supplies Maintenance Purchased Professional Service? Purchased Property Services Other Purchased Services Capital Outlay Total Emergency Medical Services Total Fire Budget $ 228,381 3,515 2,865 20 9, 170 11,027 254,978 1,854,766 45, 175 54,047 916 30,705 34' 184 34 704 2,054,497 164,836 8,427 3,550 200 6 964 183,977 396,044 17,870 9,560 6,040 300 14,883 50,000 494 697 2 l 988, 149 (Continued) -71 - Actual $ 228,728 2,570 1,879 16 7,008 10 ! 712 250,913 1,846,538 45, 176 54 ,047 916 28,057 29,613 34,690 2,039,037 147,120 8,285 2,377 161 6.221 164 164 367,604 15,428 6,515 6,034 140 12,490 49 909 458 1 2 0 2,91 2,234 Variance Favorable (Unfavorable) $ (347) 945 986 4 2, 162 315 4 065 8,228 ( 1 ) 0 0 2,648 4,571 14 15 460 17' 716 142 1, 173 39 743 19 813 28,440 2,442 3,045 6 160 2,393 91 36 577 75 915 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended Septem be r 30, 1991 (Continued) Develop•ent Services: Oevelop•ent Services Administration: Salaries and Benefits supplies Maintenance Purchased Property Services Other Purchased Services Capital Outlay Total Development Services Administration Engineering: Salaries and Benefits Supplies Maintenance Purchased Prof essional Services Purchased Prope rty Services Other Purchased Services Capital Outlay Total Engineering Planning: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Planning Total Development Services Budget Actual $ 168,538 $ 162,874 6,326 4,691 4,809 1,977 2' 110 1,981 8,871 7 ,091 4,623 4,622 195,277 183,236 240,181 246, 164 6,975 6,757 2' 161 2, 157 5,220 4,507 1 ,680 1 ,575 20,917 20,909 13,300 13,270 290,434 295,339 641,213 657,204 16,965 18,458 5,280 5,054 8,340 10,567 8,440 8,614 51'143 49,861 19,200 16,924 750,581 766,682 1,236,292 1,245,257 (Continued) • 72· Variance Favorable (Unfavorable) $ 5,664 1,635 2,832 129 1, 780 1 12 041 (5,983) 218 4 713 105 8 30 (4,905) (15,991) ( 1 ,493) 226 (2,227) ( 174) 1 ,282 2 276 (16,101) (8,965) CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1991 (Continued) Public Services: Public Services Ad•inistration: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Total Public Services Ad•inistration Streets Maintenance: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Streets Maintenance Drainage Maintenance: Salaries and Benefits Supplies Maintenance Purchased Proper t y Services Other Purchased Services Capital Outlay Total Drainage Maintenance Fleet Services: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Propert y Services Other Purchased Services Capital Outlay Total Fleet Services Traffic Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Total Traffic Total Public Services Budget Actual $ 169,�28 $ 169,897 3,975 3,972 2,377 1,270 120 120 11,060 11,057 1.41926 141924 202,386 201,240 492,322 488,325 43,338 43,334 503,707 480,037 38,720 38,240 19,049 19,044 29,374 27,379 1651350 1611546 1.291,860 1.257,905 91,346 90' 198 4,585 4 ,578 19,113 19. 104 3,863 3,856 3,390 2,977 7 510 7 508 129,807 1281221 334' 141 333' 153 31, 982 31,650 5,581 4,893 800 800 11,902 11,233 11,365 10,908 829 826 396.600 393,463 96,465 96,858 3, 180 2,873 25,881 24' 133 5,000 2,029 786 764 31388 3 091 134 700 129 748 2 '155 ,353 2,110,577 (Continued) -73- Variance Favorable (Unfavorable) $ 31 3 1, 107 0 3 2 146 3,997 4 23,670 480 5 1,995 31804 331955 1'148 7 9 7 413 2 586 988 332 688 0 669 457 3 3 137 (393) 307 1, 748 2,971 22 297 4 952 44 776 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1991 (Continued) Parks Ad•inistration: Salaries and Benefits supplies Maintenance Purchased Property Services Other Purchased Services Capital Outlay Total Parks Ad•inistration Recreation: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Recreation Special Facilities: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total.special Facilities Parks Maintenance: Salaries and Benefits supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Parks Maintenance Forestry: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Forestry Total Parks Budget Actual $ 230,952 $ 230,955 5,782 5,415 3,500 2,848 2,286 1,533 20,491 20,350 17 750 17 728 280,761 278,829 298,932 298,928 67, 158 64,974 4' 136 3, 149 74,029 70,866 68,003 67,997 33, 188 30,925 4 450 3 941 549,896 540,780 387,631 384,385 46,286 43,422 36,609 35,357 12,425 11,418 110, 167 107,953 34, 120 30,485 31,689 31 516 658,927 644 ,536 498,328 477 ,025 35' 158 31 ,594 50' 130 49,319 3,980 3,734 56,334 54,472 11,292 11,279 63,860 61 884 719 082 689,307 205,509 195,525 7 ,483 6,775 15,439 14' 157 3,500 3,500 6,060 4,983 4 ,961 4,530 6 822 6 816 249 774 236,286 2,458,440 2,389,738 (Continued) -74 - Variance Favorable (Unfavorable) $ (3 ) 367 652 753 141 22 932 4 2, 184 987 3' 163 6 2,263 509 9 116 3,246 2,864 1 ,252 1 ,007 2,214 3,635 173 14 391 21,303 3,564 811 246 1 ,862 13 976 29 775 9,984 708 1 ,282 0 1,077 431 6 13 488 68 702 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1991 (Continued) Management Services: Management Services Administration: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Management services Administration Public Relations: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Public Relations Energy Management Services: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Energy Management Services Management Information Services: Salaries and Benefits Supplies Maintenance Purchased Property Services Other Purchased Services Capital Outlay Total Management Information Services Total Management Services Nondepartmental: Special Programs and Projects Public Agency Funding Contingency Expected Expenditure Savings Total Nondepartmental Subtotal Less Reimbursed Administrative Total General Fund Expenditures -75 - $ Budget 96,383 1 ,030 155 4,535 380 5,599 1 000 109,082 138,935 3,413 7,245 2,000 1,010 17,823 5 631 176 057 177' 109 15,259 69,889 274,047 134,223 16,282 738 687 547 274,695 2,606 73,500 2,055 21'119 25,998 399,973 1,372,659 0 223,083 22,303 (728,840) (483,454) 0 (2,490,791) $13,256,772 $ Actual 96,445 957 151 2,568 364 5,601 782 106,868 138,732 3,057 6,970 1'850 813 17' 104 5 622 174 148 168,688 14,401 65,089 259,772 110' 624 13,337 737 632,648 257,762 2,604 72,940 2,042 17' 107 24 356 376 811 1 ,290,475 13 ,461 123,083 0 0 136 544 0 (2,465,577) $13,373,892 Variance Favorable (Unfavorable) $ $ (62) 73 4 1,967 16 (2) 218 2 214 203 356 275 150 197 719 9 909 8,421 858 4,800 14,275 23,599 2,945 1 54 899 16,933 2 560 13 4,012 1 642 23 162 82 184 (13,461) 100,000 22,303 (728,840) (619,998) 0 (25,214) (117 I 120) -76- SPECIAL REVENUE FUNDS Special revenue funds are used to account for specific revenues that are legally restricted to expendi tures for particular purposes. Community Development -to account for funds granted to the City by the National Department of Housing and Urban Development for use on various community improvement projects. Hotel/Motel Tax -to account for the receipt and expenditure of funds received by the City from the assessment of hotel and motel occupancy tax. Usage of funds is restricted to the construction and maintenance of convention and civic facilities and to the promotion of tourism and arts within the City. Parks Escrow -to account for the receipt and expenditure of funds received by the City from residential land developers. Developers either dedicate land or money in lieu of land for use in the development of neighborhood parks in residential areas. -n- CITY OF COLLEGE STATION, TEXAS SPECIAL REVENUE FUNDS COMBINING BALANCE SHEET (With September 30, 1991 comparative totals for the fiscal year ended September 30, 1990) Totals Community Hotel/Motel Parks Development Tax Escrow 1991 1990 Assets Equity in Cash and Cash Equivalents $ 3, 774 $ 96,457 $ 48,083 $ 148,314 $ 39,957 Equity in Investments 18,824 481, 130 239,842 739,796 385, 121 Receivables: Accrued Interest 0 9,602 0 9,602 7,424 Grants 83,553 0 0 83,553 101,823 Letter of Credit 0 0 25,425 25' 425 0 Accounts 600 907 0 1,507 1,686 Loans 179' 842 0 0 179,842 187,887 Less Allowance for Uncollectible Ac�ounts 0 (188) 0 (188) 0 Total Assets $ 286,593 $ 587 ,908 $ 313,350 $ 1, 187 ,851 $ 723 ,898 Liabilities and Fund Balances Liabilities: Accounts Payable 19,319 19, 786 0 39, 105 16,789 Retainage Payable 15,255 0 1,372 16,627 12,852 Refundable Deposits 0 11,305 0 11,305 9,010 Accrued Liabilities 3,418 164 0 3,582 52,723 Deferred Revenues 179' 842 0 0 179,842 187,887 Total Liabilities 217 I 834 31 ,255 1 372 250,461 279,261 Fund Balances: Reserved for Encumbrances 0 1,450 0 1,450 2,626 Unreserved: Designated for Subsequent Years' Expenditures 42,319 204 299, 163 341,686 203 Undesignated 26 440 554,999 12 815 594' 254 441,808 Total Fund Balances 68 759 556,653 311 978 937,390 444 637 Total Liabilities and Fund Balances $ 286,593 $ 587,908 $ 313,350 $ 111871851 $ 723,898 . 78. CITY OF COLLEGE STATION, TEXAS SPECIAL REVENUE FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES For the Fiscal Year Ended September 30, 1991 (With comparative totals for the fiscal year ended September 30, 1990) Revenues: Taxes Grants Fines, Forfeits and Penalties Interest on Investments Rents and Royalties Loan Proceeds Interest on Loans Contributions Other Total Revenues Expenditures: Current: Housing Rehabilitation Reimbursed Administrative Special Programs and Projects Public Agency Funding Economic Development Interim Assistance Planning Clearance Other Capital Outlay Total Expenditures Excess of Revenues Over Expenditures Other Financing Sources (Uses): Operating Transfers Out Other Transfers Total Other Financing Sources (Uses) Excess of Revenues Over Expenditures and Other Financing Sources(Uses) Fund Balances, October 1 Fund Balances, September 30 Community Development $ $ 0 607,270 213 7, 124 0 8,581 7,656 0 51 630,895 256,997 179,596 0 99,396 4, 146 2, 119 0 42,240 3 2 997 587 494 43 401 0 0 0 43,401 25 358 68,759 Hotel/Motel Tax $ 1,005,305 0 0 41 ,829 53,686 0 0 0 1 421 1!102,241 0 178,635 169,929 446,225 0 0 0 0 189 0 794,978 307,263 (169,889) 0 (169,889) 137,374 419 279 $ 556,653 "79 " $ Parks Escrow 0 0 0 22,924 0 0 0 0 10 000 0 0 0 0 0 0 0 0 0 20 110 20 110 12 814 0 299, 164 299 I 164 311 ,978 0 $ 311,978 1991 $ 1,005,305 607,270 213 71 ,877 53,686 8,581 7,656 0 11 472 Totals 1,766,060 256,997 358,231 169,929 545,621 4, 146 2, 119 0 42,240 192 23 107 1 ,402,582 363,478 (169,889) 299I164 129, 275 492,753 444,637 $ 937,390 1990 $ 971 ,225 773,025 89 30,888 53, 154 8,438 8,680 1 ,647 988 1 ,848,134 206,691 309,650 58,520 508, 136 2,337 2,756 12,000 0 6 314 ,423 1,414,519 433,615 ( 176 ,365) 0 ( 176 ,365) 257 I 250 187 387 $ 444,637 CITY OF COLLEGE STATI ON. TEXAS COMMUNITY DEVELOPMENT FUND SCHEDULE OE REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Revenues: Grants Fines, Forfeits and Penalties Interest on Investments Loan Proceeds Interest on Loans Other Total Revenues Expenditures: Current: Housing Rehabilitation Reimbursed Administrative Public Agency Funding Economic Development Interim Assistance Clearance Subrecipient Projects Other Capital Outlay Total Expenditures Excess of Revenues Over Expenditures Fund Balance, October 1, 1990 Fund Balance, September 30, 1991 -80 - Budget Actual $1,250,250 $607,270 0 213 0 7,124 Q 8,581 0 7,656 25,000 51 1,275,250 630,895 420,962 ' 256,997 179,788 179,596 134,250 99,396 4,000 4,146 7,250 2,119 40,000 42,240 25,000 0 0 3 464,000 2,997 1,275,250 587,494 0 43,401 23,763 25,358 $ 23,763 $ 68,759 Variance Favorable (Unfavorable) $(642,980) 213 7,124 8,581 7,656 (24,949) (644,355) 163,965 192 34,854 (146) 5,131 (2,240) 25,000 (3) 461,003 687,756 43,401 1,595 $ 44,996 CITY OF COLLEGE STATION. TEXAS HOTEL.JMOTELTAXFUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Revenues: Taxes Interest on Investments Rents and Royalties Other Total Revenues Expenditures: Current: Reimbursed Administrative Special Programs and Projects Public Agency Funding Other Total Expenditures Excess of Revenues Over Expenditures Other Financing Uses: Operating Transfers Out Excess (Deficiency) of Revenues over/(under) expenditures and other financing uses Fund Balance, October 1, 1990 Fund Balance, September 30, 1991 -81 - Budget Actual $ 780,000 $1,005,305 17,000 41,829 47,000 53,686 0 1,421 844,000 1, 102,241 178,635 178,635 169,200 169,929 446,225 446,225 0 189 794,060 794,978 49,940 307,263 169,889 169,889 (119,949) 137,374 275,000 419,279 $ 155,051 $ 556,653 Variance Favorable (Unfavorable) $225,305 24,829 6,686 1,421 258,241 0 (729) 0 (189) (918) 257,323 0 257,323 144,279 $401,602 CITY OE COLLEGE STATION. TEXAS PARKS ESCROW FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Variance Favorable Budget ·Actual (Un favorable) Revenues: Interest on Investments $ 20,000 $ 22,924 $ 2,924 Other 0 10,000 10,000 Total Revenues 20,000 32,924 12,924 Expenditures: Capital Outlay 22,000 20,110 1,890 Total Expenditures 22,000 20, 110 1,890 Excess (Deficiency) of Revenues Over/(Under) Expenditures (2,000) 12,814 14,814 Other Financing Sources: Other Transfers. 284,446 299,164 14,718 Excess of Revenues and Other Financing Sources Over Expenditures 282,446 311,978 29,532 Fund Balance, October 1, 1990 0 0 0 Fund Balance, September 30, 1991 $282,446 $311,978 $29,532 -82- CAPITAL PROJECTS FUNDS Capital projects funds are used to account for the acquisition and construction of major capital facilities other than those financed by proprietary funds and trust funds. Capital Eguipment -to account for the cost of acquisition and replacement of vehicles and equipment to be made with funds provided by operating funds. 1982 Series 11 Bond -to account for the cost of parks and street improvements, city hall and warehouse construction, and a traffic signalization project to be made with funds provided by proceeds of the 1982 Series II issue of general obligation bonds. 1984 Bond -to account for the cost of street improvements, building construction, and park improvements to be made with funds provided by proceeds of the 1984 Series of general obligation bonds. 1989 Bond -to account for the cost of street improvements and the renovation of the public services building to be made with funds provided by proceeds of the 1989 Series of general obligation bonds. 1991 Bond -to account for the cost of street improvements and parks improvements made with funds provided by proceeds of the 1991 Series of general obligation bonds. -83- CITY OF COLLEGE STATION, TEXAS CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET September 30, 1991 (With comparative totals for the fiscal year ended September 30, 1990) Assets Equity in Cash and Cash Equivalents Equity in Investments Receivables: Accrued Interest Grants Total Assets Liabilities and Fund Balances Liabilities: Accounts Payable Retainage Payable Total Liabilities Fund Balances: Reserved: Reserved for Encumbrances unreserved Designated for: Drainage Projects General Government Projects Parks Projects Streets Projects Unreserved Undesignated Total Fund Balances Total Liabilities and Fund Balances -84 - capital Eguip11ent $ 35,061 174,888 0 0 $ 209,949 $ 23,058 0 23,058 155,784 0 0 0 0 31 107 186 891 $ 209,949 1982 Series II Bond $ 327,194 1,632,054 35,888 119,515 $ 2,114,651 $ 9,828 20,505 30,333 0 0 386,554 1,012,525 145,464 539,775 2,084,318 $ 2,114,651 1984 Bond $ 53,994 269,326 0 0 $ 323,320 $ 39,216 12 437 51 653 0 271,667 0 0 0 0 271 ,667 $ 323,320 Totals 1989 Bond 1991 Bond 1991 1990 $ 254,489 $ 0 $ 670,738 $ 469,017 1,269,397 0 3,345,665 4,520,518 40,883 0 76,771 92,388 0 0 119 515 0 $ 1,564'769 $ 0 $ 4,212,689 $ 5,081 ,923 $ 61 $ 113,448 $ 185,611 $ 39,894 0 2 574 35 516 108,462 61 116,022 221, 127 148,356 0 0 155,784 0 0 0 271 ,667 526,942 31,559 0 418,113 532 '261 0 (54,827) 957,698 789,812 1, 190,291 (30,365) 1,305,390 2,437,449 342,858 (30,830) 882,910 647 103 1,564,708 (116 '022 l 3,991 ,562 4,933,567 $ 1,564'769 $ 0 $ 4,212,689 $ 5,081 ,923 -85- CITY OF COLLEGE STATION, TEXAS CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES For the Fiscal Yea r Ended September 30, 1991 (With comparative totals for the fiscal year ended September 30, 1990) Revenues: Grants Interest on Invest11ents Contributions Other Total Revenues Expenditures: Current: Rei•bursed Administrative Public Agency Funding Other Capital Outlay Debt Service: Bond Issuance Costs Total Expenditures Excess (Deficiency) of Revenues Over (Under) Expenditure� Other Financing Sources (Uses): Proceeds fro• Long Ter11 Debt Issuance Sale of General Fixed Assets Operating Transfers In Operating Transfers Out Other Transfers Total Other Financing Sources (Uses) Excess (Deficiency) of Revenues Over (Under) Expenditures and Other Financing Sources (Uses) Fund Balances, October 1 Fund Balances, September 30 - 86- $ Capital Eguip11ent 38,819 0 0 0 38,819 0 0 1 ,982 768,423 2 905 773 310 (734,491) 500,000 0 0 0 421 382 921 ,382 186,891 0 $ 186,891 1982 Series II Bond $ 119,515 150,785 50,000 0 320,300 59,179 0 0 225,670 0 284,849 35 451 0 0 294,000 0 0 294 000 329 ,451 754 867 $ 2,084,318 $ 1984 Bond 0 0 0 990 990 0 0 27,419 55,846 0 83,265 (82,275) 0 0 0 ( 173 '000) 0 (173,000) (255,275) 526 942 $ 271 ,667 $ 1989 Bond 0 211,296 0 0 211,296 90,340 0 0 1,208,006 0 1,298,346 ( 1 I 087 I 050) 0 0 0 0 0 0 (1,087,050) 2, 651 ,758 $ 1 I 564 ,708 $ 1991 Bond 0 0 0 0 0 0 0 3, 174 85' 191 27 657 116,022 (116,022) 0 0 0 0 0 0 (116,022) 0 $ (116,022) $ Totals 1991 158,334 362,081 50,000 990 571 405 149,519 0 32,575 2 '343' 136 30 562 2,555,792 (1 ,984 ,387) 500,000 0 294,000 ( 173 ,000) 421 382 1 ,042,382 (942,005) 4,933,567 $ 3,991 ,562 -87- $ 1990 0 509,932 0 2 509,934 138,955 50,000 79,781 3,037,975 41 001 3,347,712 (2 ,837,778) 3,242,428 0 199,875 (219,875) 0 3,222,428 384,650 4,548,917 $ 4,933,567 CITY OF COLLEGE STATION. TEXAS CAPITAL EQUIPMENT FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Variance Favorable Budget Actual (Unfavorable) Revenues: Grants $ 0 $38,819 $(38,819) Interest 25,000 0 (25,000) Total Revenues 25,000 38,819 13,819 Expenditures: Capital Outlay 835,932 768,423 67,509 Debt Service: Debt Issuance Costs 0 2,905 (2,905) Contingency 9,068 1,982 7,086 Total Expenditures 845,000 773,310 71,690 Excess (Deficiency) of Revenues Over/(Under) Expenditures (820,000) (734,491) 85,509 Other Financing Sources: Proceeds From Long Term Debt Issuance 475,000 500,000 25,000 Other Transfers In 345,000 421,382 76,382 Total Other Financing Sources 820,000 921,382 101,382 Excess of Revenues Over Expenditures and Other Financing Sources 0 186,891 186,891 Fund Balance, October 1, 1990 0 0 0 Fund Balance, September 30, 1991 $ 0 $186,891 $186,891 -88- CITY OF COLLEGE STATION. TE)(AS 1982 SERIES 11 BOND FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Revenues: Grants Interest Contributions Total Revenues Expenditures: Current: Reimbursed Administrative Capital Outlay General Contingency Total Expenditures Excess (Deficiency) of A.avenues Over/(Under) Expenditures Other Financing Sources: Operating Transfers In Total Other Financing Sources Excess (Deficiency) of Revenues Over/(Under) Expenditures and Other Financing Sources Fund Balance, October 1, 1990 Fund Balance, September 30, 1991 • 89· Budget Actual $500,000 $119,515 75,000 150,785 100,000 50,000 675,000 320,300 60,000 59,179 1,680,000 225,670 187,500 0 1,927,500 284,849 (1,252,500) 35,451 127,000 294,000 127,000 294,000 (1,125,500) 329,451 1,300,000 1,754,867 $ 174,500 $2,084,318 Variance Favorable (Unfavorable) $(380,485) 75,785 (50,000) (354,700) 821 1,454,330 187,500 1,642,651 1,287,951 167,000 167,000 1,454,951 454,867 $1,909,818 CITY OE COLLEGE STATION. TEXAS 1984 BOND FUND SCHEDULE OE REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Revenues: Interest Other Total Revenues Expenditures: Current: Other Capital Outlay Total Expenditures Excess (Deficiency) of Revenues Over/(Under) Expenditures Other Financing Uses: Operating Transfers Out Total Other Financing Uses Excess (Deficiency) of Revenues Over/(Under) Expenditures and Other Financing Uses Fund Balance, October 1, 1990 Fund Balance, September 30, 1991 -90 - Budget Actual $25,000 0 0 990 25,000 990 0 27,419 500,000 55,846 500,000 83,265 (475,000) (82,275) (173,000) (173,000) (173,000) (173,000) (648,000) (255,275) 700,000 526,942 $ 52,000 $ 271,667 Variance Favorable (Unfavorable) $(25,000) 990 (24,010) (27,419) 444,154 416,735 392,725 0 0 392,725 (173,058) $219,667 CITY OF COLLEGE STATION. TEXAS 1989 BOND FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Revenues: Interest Total Revenues Expenditures: Current: Reimbursed Administrative Capital Outlay General Contingency Total Expenditures Excess (Deficiency) of Revenues Over/(Under) Expenditures Fund Balance, October 1, 1990 Fund Balance, September 30, 1991 - 91 - Budget Actual $75,000 $211,296 75,000 211,296 90,340 90,340 1,976,400 1,208,006 62,500 0 2,129,240 1,298,346 (2,054,240) (1,087,050) 2,500,000 2,651,758 $ 445,760 $1,564,708 Variance Favorable (Unfavorable) $136,296 136,296 0 768,394 62,500 830,894 967,190 151,758 $1, 118,948 CITY OF COLLEGE STATION. TEXAS 1991 BOND FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Revenues: Interest Total Revenues Expenditures: Current: Other Capital Outlay Debt Service: Bond Issuance Costs Total Expenditures Excess (Deficiency) of Revenues Over/(Under) Expenditures Other Financing Sources: Proceeds From Long Term Debt Issuance Total Other Financing Sources Excess (Deficiency) of Revenues Over/(Under) Expenditures and Other Financing Sources Fund Balance, October 1, 1990 Fund Balance, September 30, 1991 -92- Budget Actual $100,000 $ 0 100,000 0 0 3,174 3,500,000 85, 191 0 27,657 3,500,000 116,022 (3,400,000) (116,022) 5,000,000 0 5,000,000 0 1,600,000 (116,022) 0 0 $1,600,000 $ (116,022) Variance Favorable (Unfavorable) $(100,000) (100,000) (3, 174) 3,414,809 (27,657) 3,383,978 3,283,978 (5,000,000) (5,000,000) (1, 716,022) 0 $(1 ;716,022) ENTERPRISE FUNDS Enterprise funds are used to account for operations that are financed and operated in a manner similar to private business enterprises -where the intent of the government's council is that the costs of providing goods or services to the general public on a continuing basis be financed or recovered primarily through user charges, or where the government's council has decided that periodic determination of net income is appropriate for accountability purposes. Electric -to account for revenues and expenses _related to the operation and maintenance of the electric systems of the City. All activities necessary to provide such services are accounted for in this fund, and include, but are not limited to administration, operations, maintenance, and financing and related debt service. Water -to account for revenues and expenses related to the operation and maintenance of the water systems of the City. All activities necessary to provide such services are accounted for in this fund, and include, but are not limited to administration, operations, maintenance, and financing and related debt service. Sewer -to account for revenues and expenses related to the operation and maintenance of the sewer systems of the City. All activities necessary to provide such services are accounted for in this fund, and include, but are not limited to administration, operations, maintenance, and financing and related debt service. Solid Waste Collection -to account for all sanitation collection and disposal activities by the City for both residential and commercial residents. - 93- CITY OF COLLEGE STATION, TEXAS ENTERPRISE FUNDS COMBINING BALANCE SHEET September 30, 1991 (With comparative totals for the fiscal year ended September 30, 1990) Electric Water Sewer Assets Current Assets: Equity in Cash and Cash Equivalents $ 968,057 $ 0 $ 135,928 Equity in Investments 4,828,691 0 678,014 Receivables: Accrued Interest 148,71-2 0 15' 055 Accounts 4,066,092 173,215 143,323 Special Assessments 0 0 6,886 Other 566,032 0 0 Less Allowance for Uncollectible Accounts (621,023) (7 ,391) (6,004) Inventories 911,207 292,735 13,732 Prepaid Costs 0 0 600 Total Current Assets 10,867,768 458,559 987,534 Restricted Assets: Equity in Cash and Cash Equivalents 970,288 652,419 443,417 Equity in Investments 4,839,818 3,254,283 2,211, 778 Receivables: Accrued Interest Receivable 66,635 63,553 66,806 Accounts 293 0 0 Total Restricted Assets 5,877,034 3,970,255 2,122,001 Note Receivable from Joint Venture 0 0 0 Equity in Joint Venture 0 0 0 Deferred Charges: Water Well 0 1'167' 075 0 Bond Issuance Costs 20,224 13,499 31,034 Accumulated Amortization (1, 196) (914,135) (1 ,835) Total Deferred Charges 19 028 266,439 29 199 Property and Equipment: Utility Plant 18,388,372 26,822,815 18,774,351 Buildings 0 811,654 811 ,654 Machinery and Equipment 27,937 570,621 939' 504 Accumulated Depreciation (6,824,427) (6,658, 741) (4,425,240) Construction in Progress 3,695,361 1,150,471 1,770,483 Land 0 525,559 414 641 Total Property and Equipment, Net 15,287,243 23,222,379 18,285,393 Total Assets $32,051 ,073 $27,917,632 $22,024,127 -94. Solid Totals Waste Collection 1991 1990 $ •4,723 $ 1, 108, 708 $ 651,118 23,559 5,530,264 6,275,666 32,777 196,544 127,863 71,373 4,454,003 4,847,474 ( 111 ) 6, 775 7,638 0 566,032 755,907 (6,733) (641'151) (382,493) 8,444 1,226,118 1,351,246 0 600 600 134,032 12,447,893 13,635,019 0 2,066,124 980,206 0 10,305,879 9,447,522 0 196,994 193,409 0 293 3 999 0 12,569,290 10 '625' 136 909 137 909 137 976 000 631 ,260 631 260 221 717 0 1,167,075 1,167,075 0 64,757 0 0 (917' 166) (909,935) 0 314 666 257 140 0 63,985,538 55,119,465 o· 1,623,308 6' 980' 164 1,294,376 2,832,438 4,265,712 (958, 187) (18,866,595) (16,952, 716) 0 6,616,315 2,646,698 0 940 200 1,581,931 336 189 57' 131 ,204 53,641,254 $ 2,010,618 $ 84,003,450 $ 79,356,266 (Continued) -95- CITY OF COLLEGE STATION, TEXAS ENTERPRISE FUNDS COMBINING BALANCE SHEET September 30, 1991 (With comparative totals for the fiscal year ended September 30, 1990) (Continued) Liabilities and Fund Equity Current Liabilities: Accounts Payable Due to Joint Venture Retainage Payable Refundable Deposits Obligation Under Lease Accrued Liabilities Deferred Revenues Total current Liabilities Current Liabilities Payable from Restricted Assets: Accounts Payable Accrued Interest Payable Retainage Payable Refundable Deposits Revenue Bonds General Obligation Bonds certificates of Obligation Total current Liabilities Payable from Restricted Assets Noncurrent Liabilities: Revenue Bonds General Obligation Bonds Certificates of Capital Obligation Obligation Under Capital Lease Accrued Vacation Total Noncurrent Liabilities Total Liabilities Fund Equity: Contributed Capital Retained Earnings: Reserved for Debt Service Reserved for Capital Projects Unreserved Total Fund Equity Total Liabilities and Fund Equity Electric $ 1 ,823,624 0 (). 0 0 186,923 35 402 2,045,949 182 J 021 101,343 102,344 1,919,104 529,750 134,750 13 100 2,982,412 5,045,300 827,750 91,700 0 66,568 6,031 ,318 11 ,059,679 3 J 105 J 236 804,218 5,324,471 11 ,757,469 . 20,991 ,394 $32,051 ,073 . 96- Water $ 800,771 0 0 975 413,651 20,299 0 1,235,696 0 145,762 0 0 1J161 ,ooo 126,500 6 550 1,439,812 9,153,400 636,500 45,850 2,278,462 24 010 12,138,222 14,813,730 3,091,794 1 ,838,211 3,320,925 4,852,972 13 J 103 J 902 $27,917,632 $ Sewer 54,972 0 0 0 0 20,249 0 75,221 100,510 122,436 5,290 0 784,250 114,985 6 551 1 ,134,022 7,531,300 682 J 160 45 J 851 0 30,686 8,289,997 9,499,240 4 ,041 ,604 1J187J178 2,828,694 .4 467 411 12,524,887 $22,024,127 Solid 1 ot a Is Waste Collection 1991 1990 $ 16,917 $ 2. 6\lt> 184 s 2,030,241 0 0 135, 772 0 (I _o 0 4/:,1 0 0 4, '.I 6�1 378,848 12,537 ?40, 008 294,317 0 3� 40;:> 34 985 29 454 3 386 320 2,874'163 0 282,531 180,894 0 369,541 369' 117 0 107,634 85' 304 0 1'919' 104 1,923,971 0 2,475,000 2,415,000 0 376,235 377,765 0 26 201 26,200 0 5 556 246 5,378,251 0 21 ,730,000 19,405,000 0 2,146,410 2,522,645 0 183 '401 209,600 0 2,278,462 2,692,113 18 279 139 543 136 896 18 279 26 477 816 24,966,254 47 733 35,420,382 33,218,668 54,901 10,293,535 10,293,535 0 3,829,607 4,510,290 0 11'4 74' 090 4,399,808 1 ,907,984 22,985,836 26,933,965 1 ,962,885 48,583,068 46,137,598 $ 2,010,618 $ 84,003,450 $ 79,356,266 • 97 • CITY OF COLLEGE STATION, TEXAS ENTERPRISE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS For the Fiscal Year Ended September 30, 1991 (With comparative totals for the fiscal year ended September 30, 1990) Operating Revenues: Electric Sales Water Sales Sewer Service Garbage Collection Fees Landfill Charges Other Total Operating Revenues Operating Expenses: Purchased Power Salaries and Benefits Supplies Maintenance Purchased Professional services Purchased Property Services Other Purchased Services Reimbursed Administrative Depreciation Other Total Operating Expenses Operating Income (Loss) Nonoperating Revenues (Expenses): Interest on Investments Other Interest Earnings Reimbursed Expenses Grants Contributions Gain on Asset Retirement Earnings in Joint Venture Interest Expense Other, Net Total Nonoperating Revenues (Expenses) Income Before Operating Transfers -98 - Electric $ 26,554,630 0 0 0 0 341 332 26,895,962 19,072,974 1,397,307 65,921 250,416 807,424 95,714 234,675 878,245 747 ,541 191 222 23,741,439 3 I 154 I 523 990,801 0 80,950 0 0 0 0 (533,022) (1 ,643) 537 086 3,691 ,609 Water $ 0 4,702,612 0 0 0 103, 148 4 I 805 ,760 0 816,064 80,091 106, 903 350,542 483,292 72,552 267,604 726,884 35,352 2,939,284 1,866,476 270,857 0 1,690 0 7,832 0 0 ( 1 J 1 66' 902 ) 28 577 (857,946) 1!008 I 530 Sewer $ 0 0 3,785,002 0 0 72 192 3I857I194 0 882,331 99,870 106, 188 81 J 951 364,405 44,896 254,127 512,249 2 158 2,348,175 1,509,019 366,578 48 0 0 0 0 0 (745,544) 21 544 (357,374) 1,151,645 Solid Totals Waste Collection 1991 1990 $ 0 $ 26,554,630 $ 28,599,828 0 4,702,612 4,679,593 0 3,785,002 3,7f8,541 1'795'247 1'795'247 1 '772 ,339 0 0 82' 166 21 724 538,396 110 456 1 ,816,971 37,375,887 38,962,923 0 19,072,974 18,715,821 711 ,871 3,807,573 3,527,525 64,785 310,667 315,746 107,210 570,717 670,302 79,618 1,319,535 1,214,433 578' 132 1'521'543 1,357,280 45,456 397,579 361 ,349 193,389 1,593,365 1'713 ,818 139,824 2, 126,498 2,129,475 5 854 234 586 115 394 1,926,139 30,955,037 30, 121 , 143 ( 109 I 168) 6,420,850 81841 ,780 43,079 1 ,671 ,315 1,559,706 76,769 76,817 57 0 82 '640 40,277 0 0 26,347 0 7,832 0 0 0 626,795 409,543 409,543 136,717 0 (2,445,468) (2,488,517) !4 ,998) 43 480 (83,259) 524,393 (153, 841) (181 ,877) 415 225 6,267,009 8,659,903 (Continued) • 99. CITY OF COLLEGE STATION, TEXAS ENTERPRISE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS For the Fiscal Year Ended September 30, 1991 (With comparative totals for the fiscal year ended September 30, 1990) . (Continued) Electric Water Operating Transfers Out $ (2,631 ,900) $ {604,987) Total Operating Transfers In (Out) (2,631 ,900) (604,987) Net Income 1,059, 709 403,543 Retained Earnings, October 1 16,826,449 9,608,565 Retained Earnings, September 30 $ 17, 886, 158 $10,012,108 • 100. Sewer $ (442,592) (442,592) 709,053 7,774,230 $ 8,483,283 Solid Totals Waste Collection 1991 1990 $ (142 I 060) $ (3,821,539) $ (4,701,449) (142,060) (3,821,539) (4,701,449) 273' 165 2,445,470 3,958,454 1 ,634 ,819 35,844,063 31 ,885,609 $ 1, 907 ,984 $ 38,289,533 $ 35,844 ,063 -101. CITY OF COLLEGE STATION. TEXAS ENTERPRISE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 (With comparative totals for the f1SCal year ended September 30, 1990) Cash Flows from Operating Adlviies: Cash Received from Cu8lclners Cash Paymenl& to Suppliers for Goods and Services Cash Payrnera to E� for Services Otta Net Cash P«Mded 11" Operating AdivUll Cash Flows from Nonc:apilal Finllncing AdiYities: Operating Transf8lll Oti to Other Fundll Cash Received from Cuslomer Pl86fl8Ylll8l1I Cash PllMded IJt' Other Nonc:apilal Financing Activties Net Cash (Used) IJt' Nonc:apilal Financing Activties Cash Flows flOm Capilal and Reeled Financing Activities: Acqui&&n and Conaruclion cl Capital AISie Proceeds fromk Sale cl Aseels Principal Paid on ReYer1ue Bonds Principal Paid on General Obligation Bonds Principal Paid on Certiicales cl Obligation Principal Paid on Obligmion Under Capital Lease hi81&1 Paid on ReYenue Bonds lliersl Paid on General Obligation Bonds lntereet Paid on Certlicales cl Obligation lntere&t Paid on Obligliion Under Capiial Lease Proceeds from Re\tenue Bonds Cash Received from Capital Grants Cash Received from Special AseessnerCI Net Cash Uaed IJt' Capital and Relliec:I Financing Adivtie& Cash Flows flOm lrMlllling Adlviies: f'lwcha9e cl ll'Ml6tmerlls Proceeds from Sale and Maltriies cl llMl8lmen1S Interest on lrMllllments Net Cash PrcMded (Used) 11" lrMlllling Activties Net lnaease (Decrease) in Cash Cash and Cash EqlMlents. October 1 Cash and Cash Equivalents, September 30 Rea>nciliation cl Operating Income to Net Cash l'ro'lided (Used) by Operating Activties: Operating lnoome (l..OE6) Adjustment to ReoonCile Operating Income to Net Cash ProWled (Used) by Operating Activities: Deprecialion Amortiz.alion PrcMsion for Uncolleclible Accounts Change in Asse1s and Liabilities: Change in kc:ounl& Rea!ivable Change in lll\!8riory Change in Prepaid Coe1s Change in Aa:ounts Payable Change in Accrued Liabilities Change In Due to Joint Venture Change in Accrued Vacation Other Receivables Net Cash P«Mded 11t' Operating Adivties Eledric S27 ,066,835 (20,854, 159) (1 ,377,766) 293 4,835,203 (2,631,900) 0 190,341 (2, 441,559) (2.815,491) 3,800 (507,150) (134,750) (13,tOO) 0 (463,761) (51,090) (14,146) 0 1,500,000 0 0 (2,495,690) (9,668,509) 9,803,441 956,382 1,091,314 989,268 949,077 s 1,938,345 $3,154,523 747,541 1,196 264,912 737,198 102,878 0 442,254 (54,594) 0 5,327 (566,032) $4,835,203 -102 - Wli« s- $5,048,208 $3,974,089 (1, 163,555) (941,671) (813,725) (875,911) 9,874 (6) 3,080,802 2,156,501 (604,987) (442,582) 0 0 (43,421) 14,316 (648,408) (428,276) (1, 102, 119) (1,500,389) 4,150 3,450 (1,159,200) (748,650) (126,500) (116,515) (6.550) (6.550) (378,849) 0 (932,328) (690,331) (41,546) (45,982) (7,074) (7,074) (214,151) 0 1.000.000 2,300,000 3,999 0 0 0 (2,960, 166) (812,041) (3,254,283) (2.889, 792) 3,800,999 1,898,311 281,099 347,644 827,815 . (843,837) 300,041 272,347 352,378 306,998 $ 652,419 $ 579,345 $1,866,476 $1,509,019 726,884 512,249 798 1,835 (3,900) (2,931) 242,448 116,895 19,337 (964) 0 0 225,369 13,978 4,937 4,782 0 0 (1,547) 1,638 0 0 $3,080,802 $2,156,501 T<Xals SolidWl!llle 1991 1990 $1,869,752 $37,958,884 $38,393,656 (1,223,484) (24, 182,869) (24,236,016) (712,030) (3,779,432) (3,502, 187) (4) 10,157 110,454 (65,766) 10,006,740 10,765,907 (142,060) (3.821,539) (4,701,449) 0 0 27,703 58,377 219,613 73,744 (83,683) (3,601,926) (4,600,002) (159,869) (5,577,868) (2,019,795) 3,600 15,000 0 0 (2,415,000) (2,465,000) 0 (377,765) (382,023) 0 ('le,200) ('le,200) 0 (378,849) (347,231) 0 (2,086,420) (2,022,414) 0 (138,618) (157,917) 0 (28,296) (31,440) 0 (214,151) (245,769) 0 4,800,000 0 0 3,999 28,073 0 0 719 (156,269) (6,424, 166) (7,668,997) (23,560) (15,836,144) (23,421,364) 220,437 15,723,188 21,349,554 90,693 1,675,818 1,511,507 287,570 1,562,862 (560,303) (18,148) 1,543,508 (2,063,395) 22,871 1,631,324 3,694,719 4,723 $ 3,174,832 $ 1,631,324 $(109,168) $6,420,650 $8,841,780 139,824 2,126,498 2,129,475 0 3,829 0 577 258,658 58,504 52,781 1,149,322 (458,811) 3,877 125,128 (49,816) 0 0 82,737 (15,554) 666,047 (61,123) 440 (44,435) 60,488 (135,772) (135,772) 135.m (2,771) 2,647 26,901 0 (566,032) 0 $(65,766) $10,006,740 $10,765,907 -103 - Operating Revenues: Electric Sales Forfeits, Discounts, Penalties Electric Property Rentals Miscellaneous Service Revenue Total Operating Revenues Nonoperating Revenues: Interest Reimbursed Expenses CITY OF COLLEGE STATION. TEXAS ELECTRIC FUND SCHEDULE OF REVENUES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Budget Actual $28,344,000 $27,517,585 275,000 281,380 18,700 19,152 57,000 40,800 28,694,700 27,858,917 430,000 651,215 54,500 80,950 Miscellaneous Nonoperating Revenue 11,500 40,990 Total Nonoperating Revenues 496,000 n3,155 Energy Project Fund: Interest on Investments 18,000 23,610 Revenue Bond I & S Fund: Interest on Investments 0 64,480 Operating Transfers In 738,298 776,038 Total Revenue I & S Fund 738,298 840,518 URB 1982 II Bond Fund: Interest on Investments 0 18,919 URB 1984 Bond Fund: Interest on Investments 0 116,916 URB 1990 Bond Fund: Interest on Investments 0 115,660 Proceeds From Long Term Debt Issuance 0 1,493,203 Total URB 1990 Bond Fund 0 1,608,863 Total Electric Fund Revenues $29,946,998 $31,240,898 See reconciliation to GAAP basis on page 112. -104 - Variance Favorable (Unfavorable) $(826,415) 6,380 452 (16,200) (835,783) 221,215 26,450 29,490 277,155 5,610 64,480 37,740 102,220 18,919 116,916 115,660 1,493,203 1,608,863 $1,293,900 Administration: Salaries and Benefits Supplies Maintenance Purchased Professional Servicea Purchased Property Services Other Purchased Services Capital Outlay Total .Administration Technical Services:. Salaries and Benefits Supplies Maintenance Purchased Professional Sarvices Purchased Property Servicea Other Purchased Services Capital Outlay Total Technical SelVices Electric Transmission/Distribution: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Electrical Transmission/Di&lribution Nondepartmental: Payment In Lieu of Taxes Special Programs/Projects Public Agency Fundir\g Reimbursed Debt Service Reimbursed Administrative Other Contingency Total Nondepartmental Revenue Bond I & S Fund: Principal Payments Interest Expense Fiscal Agenrs Fees Total Revenue Bond I & S Fund URB 1984 Bond fund: Reimbursed Administrative Capital Outlay Total URB 1984 Bond Fund URB 1990 Bond Fund: Capital Outlay Total Electrical Expenses CITY OF COLLEGE STATION. TEXAS ELECTRIC FUND SCHEDULE OF EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Budget Adual $139,931 $135,572 7,393 7,394 9,040 9,037 59,300 17,316 1,210 1,032 45,545 28,250 1,675 1,360 264,094 199,961 671,809 672,816 64,185 60,601 118,873 114,833 30,450 25,230 19,812,575 19,150,669 112,900 111,846 129,894 126,070 20,940,686 20,262.065 804,883 694,816 51,300 40,570 128,815 117,747 211,431 125,673 25,220 16,988 104,654 94,578 113,074 100,549 1,439,3n 1,190,921 2,623,500 2,623,500 11,500 2,247 50,000 50,000 951,607 989,547 1,358,574 1,358,574 0 230 45,296 0 5,04o,6n 5,024,098 507,150 507,150 440,012 463,761 0 558 947,162 971,469 157,450 157,447 2,041,000 2,428,566 2,198,450 2,586,013 1,500,000 3,993 $32,330,446 $30,238,520 See reconciliation to GAAP basis on page 112. -105 - v.aioe Favorable (U� $4,359 (1) 3 41,984 178 17,295 315 64,133 (1,007) 3,584 4,040 5,220 661,906 1,054 3,824 678,621 110,076 10,730 11,068 85,758 8,232 10,076 12,525 248,456 0 9,253 0. (37,740) 0 (230) 45,296 16,579 0 (23,749) (558) (24,307) 3 (387,566) (387,563) 1,496,007 $2,091,926 CITY OF COLLEGE STATION. TEXAS WATER FUND SCHEDULE OE REVENUES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Budget Actual Water Operating Revenues: Water Sales $4,995,000 $4,866,570 Forfeits, discounts, penalties 42,800 46,148 Water Taps 48,000 53,100 Miscellaneous Operating Revenues 5,000 0 Total Operating Revenues 5,090,800 4,965,818 Water Nonoperating Revenues: Interest on Investments 17,000 (57,594) Reimbursed expenses 2,500 1,690 Miscellaneous Nonoperating Revenue 5,000 5,607 Total Nonoperating Revenues 24,500 (50,297) Revenue Bond I & S Fund: Interest on Investments 24,000 141,241 Operating Transfers In 1,595,599 1,621,171 Total Revenue I & S Fund 1,619,599 1,762,412 URB 198211 Bond Fund: Interest on Investments 0 41, 171 URB 1984 Bond Fund: Interest on Investments 0 67,688 Contributions 0 7,832 Total URB 1984 Bond Fund 0 75,520 URB 1990 Bond Fund: Interest on Investments 0 78,351 Proceeds From Long Term Debt Issuance 0 995,467 Total URB 1990 Bond Fund 0 1,073,818 Total Water Fund Revenues $6,734,899 $7,868,442 See reconciliation to GAAP basis on page 112. -106. Variance Favorable (Unfavorable) $(128,430) 3,348 5,100 (5,000) (124,982) (74,594) (810) 607 (74,797) 117,241 25,572 142,813 41, 171 67,688 7,832 75,520 78,351 995,467 1,073,818 $1, 133,543 CITY OF COLLEGE STATION. TEXAS WATER FUND SCHEDULE OE EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Budget Actual Water Production: Salaries and Benefits $389,288 $357,747 Supplies 50,519 40,818 Maintenance 76,825 46,258 Purchased Professional Services 1,400 547 Purchased Property Services 911,481 811, 128 Other Purchased Services 27,648 24,855 Capital Outlay 17,610 15,246 Total Water Production 1,474,771 1,296,599 Water Distribution: Salaries and Benefits 476,297 458,778 Supplies 49,455 49,508 Maintenance 102, 170 59,395 Purchased Professional Services 9,345 4,552 Purchased Property Services 271,491 265,163 Other Purchased Services 50,661 47,697 Capital Outlay 85,425 71,406 Total Water Distribution 1,044,844 956,499 Nondepartmental: Payment in Lieu of Taxes 594,750 594,750 Reimbursed Debt Service 1,779,994 1,805,566 Reimbursed Administrative 527,608 527,608 C ontingency 59,825 0 Total Nondepartmental 2,962,177 2,927,924 Revenue Bond I & S Fund: Principal Payments 1,159,200 1,159,200 Interest Expenses 1,005,742 932,328 Fiscal Agent's Fees 0 1,167 Total Reve nue Bond I & S Fund 2,164,942 2,092,695 , URB 1982 Bond Fund: Capital Outlay 190,000 1,865 URB 1984 Bond Fund: Reimbursed Admi nistrative 66, 129 66,128 Capital Outlay 2,283,000 985,984 Total URB 1984 Bond Fund 2,349,129 1,052, 112 URB 1990 Bond Fund: Capital Outlay 1,025,000 0 Total Water Fund Expenses $11,210,863 $8,327,694 See re conciliation to GAAP basis on page 112. -1 07 - Variance Favorable (Unfavorable) $31,541 9,701 30,567 853 100,353 2,793 2,364 178,172 17,51 9 (53) 42,775 4,793 6,328 2,964 14,019 88,345 0 (25,572) 0 59,825 34,253 0 73.414 (1,167) 72,247 188, 135 1 1,297,016 1,297,017 1,025,000 $2,883,169 CITY OF COi i EGE STATION. TEXAS SEWER FUND · SCHEDULE OF REVENUES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30j 1991 Budget Actual Operating Revenues: Sewer Service $3,793,300 $3,863,403 Forfeits, Discounts, Penalties 45,300 38,806 Sewer Taps 28,000 30,455 Miscellaneous Operating Revenue 5,000 0 Total Operating Revenues 3,871,600 3,932,664 Nonoperating Revenues: Interest on Investments 36,000 66,654 Miscellaneous Nonoperating Revenue 5,500 4,386 Total Nonoperating Revenues 41,500 70,040 Revenue Bond I & S Fund: Interest on Investments 24,000 101,325 Operating Transfers In 1, 176,398 1,234,838 Total Revenue Bond I & S Fund 1,200,398 1,336,163 URB 1984 Bond Fund: Interest on Investments 0 20,512 URB 1990 Bond Fund: Interest on Investments 0 179,087 Proceeds From Long Term Debt Issuance 0 2,289,580 Total URB 1990 Bond Fund 0 2,468,667 Total Sewer Fund Revenues $5, 113,498 7,828,046 See reconciliation to GAAP basis on page 112. • 108. Variance Favorable (Unfavorable) $70,103 (6,494) 2,455 (5,000) 61,064 29,654 (1, 114) 28,540 n,325 58,440 135,765 20,512 179,087 2,468,667 2,468,667 $2,714,548 CITY OF COLLEGE STATION, TEXAS SEWER FUND SCHEDULE OF EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Budget Actual Sewer Treatment: Salaries and Benefits $582,766 $489,990 Supplies 101,514 74,780 Maintenance 64,935 62,737 Purchased Professional Services 58,235 28,276 Purchased Property Services 379,019 318,604 Other Purchased Services 32,867 30,855 Capital Outlay 29,100 26,271 Total Sewer Treatment 1,248,436 1,031,513 Sewer Collection: Salaries and Benefits 513,691 393,420 Supplies 29,324 25,090 Maintenance 51,775 43,451 Purchased Professional Services 7,845 130 Purchased Property Services 45,932 45,801 Other Purchased Services 17,927 14,041 Capital Outlay 54,020 51, 126 Total Sewer Collection 720,514 573,059 Nondepartmental: Payment in Lieu of Taxes 411,750 411,750 Reimbursed Debt Service 1,349,375 1,407,851 Reimbursed Administrative 237,848 237,848 Contingency 38,393 0 Total Nondepartmental 2,037,366 2,057,449 Revenue Bond I & S Fund: Principal Payments 748,650 748,650 Interest Expenses 649,541 690,331 Fiscal Agent•s Fees 0 812 Total Revenue Bond I & S Fund 1,398, 191 1,439,793 URB 1984 Bond Fund: Reimbursed Administrative 91,321 91,319 Operating Transfers Out 27,000 27,000 Capital Outlay 4,150,000 1,388,396 Total URB 1984 Bond Fund 4,268,321 1,506,715 URB 1990 Bond Fund: Capital Outlay 2,400,000 0 Total Sewer Fund Expenses $12,072,828 $6,608,529 See reconciliation to GAAP basis on page 112. -109- Variance Favorable (Unfavorable) $92,776 26,734 2,198 29,959 60,41 5 2,012 2,829 216,923 120,271 4,234 8,324 7715 131 3,886 2,894 147,455 0 (58,476) 0 38,393 (20,083) 0 (40,790) (812) (41,602) 2 0 .2,761,604 2,761,606 2,400,000 $5,464,299 Operating Revenues: Residential Collection Commercial Collection Dumpster Sales Forfeits, Discounts, Penalties Other Total Operating Revenues Non-Operating Revenues: Interest Earnings Earnings in Joint Venture Miscellaneous Total Nonoperatlng Revenues CITY OE COLLEGE STATION. TEXAS SOLID WASTE COLLECTION FUND SCHEDULE OE REVENUES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Budget Actual $ 880,000 $1, 176, 125 1,005,000 664,948 10,000 16,679 20,900 17,439 12,000 4,284 1,927,900 1,879,475 7,000 119,848 90,000 0 3,000 4,004 100,000 123,852 Total Solid Waste Collection Fund Revenues $2,027,900 $2,003,327 See reconciliation to GAAP basis on page 112. • 110- Variance Favorable (Unfavorable) $296,125 (340,052) 6,679 (3,461) (7,716) (48,425) 112,848 (90,000) 1,004 23,852 $(24,573) CITY OF COLLEGE STATION. TEXAS SOLID WASTE COLLECTION FUND SCHEDULE OF EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Budget Actual Commercial Collection: Salaries and Benefits $ 289,841 $ 281,943 Supplies 27,649 16,547 Maintenance 42,500 41,429 Purchased Property Services 363,409 316,642 Other Purchased Services 12,030 9,397 Capital Outlay 66,272 63,672 Total Commercial Collection 801,701 729,630 Residential Collection: Salaries and Benefits 490,634 429,928 Supplies 51,125 48,239 Maintenance 66,183 61,553 Purchased Professional Services 72,100 47,492 Purchased Property Services 160,511 261,490 Other Purchased Services 40,458 36,060 Capital Outlay 33,913 30,614 Total Residential Collection 914,924 915;376 Nondepartmental: Reimbursed Administrative 225,515 225,515 Public Agency Funding 9,000 9,000 Payment in Lieu of Taxes 142,060 142,060 Contingency 15,000 0 Expected Expense Savings (68,772) 0 Total Nondepartmental 322,803 376,575 Total Solid Waste Collection Fund Expenses $2,039,428 $2,021,581 See reconciliation to GAAP basis on page 112. -111 - Variance Favorable (Unfavorable) $ 7,898 11,102 1,071 46,767 2,633 2,600 72,071 60,706 2,886 4,630 24,608 (100,979) 4,398 3,299 (452) 0 0 0 15,000 (68,772) (53,772) $17,847 CITY OF COLLEGE STATION. TEXAS ELECTRIC, WATER, SEWER AND SOLID WASTE COLLECTION FUNDS SCHEDULE FOR RECONCILIATION OF REVENUES AND EXPENSES (BUDGETARY BASIS) TO GAAP BASIS STATEMENT OF INCOME FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Total Revenues Per Budget -Actual Less total Expenses Per Budget -Actual Net Gain (Loss), Budgetary Basis Add (Subtract) -Expenses (Revenues) Related to Balance Sheet: Prior Year Interest Expense Accrual Debt Service Principal Payment Capital Outlay Capita! Lease Payments Proceeds From Long Term Debt Issuance Add (Subtract) -Unbudgeted Revenue/(Expense) Adjustments: Current Year Revenue Accrual Investment in Joint Venture Reclass Salaries and Benefits to Construction In Progress Interest Income Other Depreciation Amortization Prior Year Revenue Accrual Current Year Interest Expense Accrual Allowance for Uncollectible Accounts Inventory Adjustment Prior Year Encumbrances Net Income (Loss), GAAP Basis Electric $31,240,898 30,238,520 , ,002,378 77,514 655,000 2,652,545 0 (1,493,203) 917,925 0 105,889 13,532 62,908 (747,541) (1,196) (1,880,880) (101,343) (82,704) (108,278) (16,837) $1,059,709 -112 - Water $7,868,442 8,327,694 (459,252) 177,176 1,292,250 1,072,636 378,848 (995,467) 163,038 0 5,030 27,626 1,670 (726,884) (798) (326,996) (145,762) 3,900 (35,322) (28, 150) $403,5 43 Sewer $7,828,046 6,608,529 1,219,517 114,426 871,715 1,465,793 0 (2,289,580) 163,320 0 22,574 19,853 (1,097) (512,249) (1,835) (241,721) (122,436) 2,931 (2, 158) 0 $709,053 Solid Waste Collection $2,003,327 (2,021,581) (18,254) 0 0 94,286 0 0 63,055 409,543 0 0 8 (139,824) 0 (108,882) 0 (577) (21,960) (4,230) $273,165 INTERNAL SERVICE FUNDS Internal service funds are used to account for the financing of goods or services provided by one department or agency to other departments or agencies of the government and to other government units, on a cost reimbursement basis. Employee Benefits -to account for self-insurance activity relating to administration of the-City's health benefits plan. Landfill -to account for activities related to operating the landfill owned by the Brazos Valley Solid Waste Management Agency. Property and Casualty -to account for insurance activity relating to all claims filed for liability cases (both injury and property) and property losses incurred for City property. Unemployment -to account for self-insurance activity on claims filed under unemployment compensation laws. Utility Billing -to account for the billing and collection activities relating to the City's electric, water, and sewer utilities and residential and commercial garbage collection. Worker's Compensation -to account for self-insurance activity relating to administration of the City's workers' compensation plan .. -113 - CITY OF COLLEGE STATION, TEXAS INTERNAL SERVICE FUNDS COMBINING BALANCE SHEET September 30, 1991 (With comparative totals for the fiscal year ended September 30, 1990) Assets Current Assets: Equity in Cash and Cash Equivalent• Equity in Investments Receivables: Accrued Interest Accounts Joint Venture Prepaid Costs Total Current Assets Property and Equipment: Furniture and Fixtures Machinery and Equipment General Electric Plant Less Accumulated Depreciation Total Property and Equipment, Net Total Assets Liabilities and Fund Equity Current Liabilities: Accounts Payable Claims Payable Accrued Liabilities Total Current Liabilities Noncurrent Liabilities: Accrued Vacation Total Noncurrent Liabilities Total Liabilities Fund Equity: Contributed Capital Unreserved Retained Earnings (Deficit) Total Fund Equity Total Liabilities and Fund Equity • 114- E111ployee Benefits $ 2,822 14,077 0 54 0 3,800 20,753 0 0 0 0 0 $ 20, 753 $ 574 146,999 3,899 151 472 0 0 151 4 72 0 (130, 719) (130, 719) $ 20,753 Landfill $ 4' 151 20,705 0 0 0 0 24,856 1 ,470 17 ,295 0 ( 1 ,711) 17 054 $ 41,910 $ 11,580 0 8 107 19 687 9,520 9,520 29 207 0 12 703 12,703 $ 41 ,910 Property and Casualty $ 11 '784 58, 778 1 ,409 175 0 0 72 I 146 0 0 0 0 0 $ 72,146 $ 115,635 0 0 115,635 0 0 115 I 635 0 (43,489) (43,489) $ 72,146 Ut i l 1 t • Une11ployment B1ll1nu $ 8,706 s 2 '?8'> 43,423 11'39;, 928 1 ,073 0 () 0 () 0 0 53 057 14 703 0 0 0 0 0 522,598 0 (245,071) 0 277 527 $ 53 057 s 292,230 $ 0 $ 8, 728 0 0 0 4 045 0 12 773 0 31 181 0 31 1 81 0 43 954 0 381, 137 53 057 (132,861) 53 057 248 276 $ 53 057 $ 292,230 v.orkers' Co•pensation $ 66 ,574 $ 332,072 7,686 0 0 20 406 352 0 0 0 0 0 s 406,352 $ $ 63, 132 $ 192 '838 0 255 970 0 0 255 970 0 150 382 150 382 $ 406 352 $ • 115 • Totals 1991 96,322 $ 480,450 11 ,046 229 0 3,820 591,867 1 ,470 17 ,295 522,598 (246,782) 294, 581 886,448 $ 199,649 339,837 16 051 555,537 40 701 40 701 596,238 381'137 (90,927) 290,210 886,448 $ 1990 43,628 420,493 7,435 4,610 130, 186 95,089 701 441 1 ,470 2' 162 438, 193 (159, 061) 282,764 984,205 84,903 333,036 168, 190 586, 129 36, 201 36 201 622,330 381'137 (19,262) 361,875 984,205 CITY OF COLLEGE STATION, TEXAS INTERNAL SERVICE FUNDS COMBINING STATEMENT OF REVENUES.i.. EXPENSES AND CHANGES IN RETAINED EARNING \::i (DEFICIT) For the Fiscal Year Ended September 30, 1991 (With comparative totals for the fiscal year ended September 30, 1990) Operating Revenues: Charges for Services Premiums Other Total Operating Revenues Operating Expenses: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Claims Administration Fees Premiums Reimbursed Administrative Depreciation Other Total Operating Expenses Operating Income (Loss) Nonoperating Revenues (Expenses): Interest Earnings Interest Expense Other, Net Total Nonoperating Revenues (Expenses) Income (Loss) Before Operating Transfers Operating Transfers In Total Operating Transfers In Net Income (Loss) Retained Earnings (Deficit), October 1 Retained Earnings (Deficit), September 30 • 116. E111ployee Benefits $ 0 1,178,899 12,823 1,191,722 0 0 0 0 0 0 915,249 83,605 242,000 0 0 3 725 1,244,579 (52,857) 6,204 0 319 7 523 (45,334) 0 0 (45,334) (85,385) $ (130, 719) Landfill $ 573,699 0 0 573,699 284,740 59,829 52 '081 6,668 12,222 10,676 0 0 0 123,403 1 ,593 0 551 ,212 22,487 0 0 (3,239) (3,239) 19,248 0 0 19,248 (6,545) $ 12,703 Property and Casualty $ 0 371 ,935 0 371,935 0 0 0 0 0 0 21 '138 0 353,613 24,894 0 0 399,645 (27,710) 0 0 (671) (671) (28,381) 0 0 (28,381) ( 15, 108) $ (43,489) Totals Utility Workers' Unemployment Billing Compensation 1991 1990 $ 0 $ 1,070,876 $ 0 $ 1,644,575 $ 1,184,230 71 '157 0 419,038 2,041,029 1,537,083 0 0 0 12,823 68,430 71 157 1,070,876 419 038 3,698,427 2,789,743 0 738,783 0 1,023,523 814,470 0 27,259 0 87,088 47,651 0 10,959 0 63,040 49,598 0 0 0 6,668 18,311 0 20' 124 0 32,346 23,299 0 83,752 0 94,428 96,497 19,789 0 371,143 1,327,319 1,006,080 0 0 19,443 103,048 96,976 0 0 66,978 662' 591 574,089 0 141,050 24' 894 314,241 114,042 0 90, 179 0 91,772 84,885 0 0 0 3 725 85,993 19 789 1I112 ! 106 482,458 3,809,789 3 '011 '891 51 368 (41 ,230) (63,420) ( 111 ,362) (222,148) 1 ,689 4,510 32,525 44,928 32,452 0 0 0 0 ( 13' 149) 0 (2,640) 0 (5,231) (952) 689 1 870 32 525 39 697 18 351 53 057 (39,360) (30,895) (71 ,665) (203,797) 0 0 0 0 200,000 0 0 0 0 200,000 53,057 (39,360) (30,895) (71 ,665) (3,797) 0 (93 ,501) 181 277 ( 19 I 262) (15,465) $ 53 057 $ ( 132 '861) $ 150,382 $ (90,927) $ (19,262) -117 - CITY OF COLLEGE STATION. TEXAS INTERNAL SERVICE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 (WITH COMPARATIVE TOTALS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1990) Cash Flows from Operating Activities: Cash Received from Customers Cash Payments to Suppliers for Goods and Services Cash Payments to Employees for Services Other Net Cash Provided (Used) by Operating Activities Cash Flows from Noncapitai Financing Activities: Operating Transfers in from Other Funds Other Net Cash Provided (Used) by Noncapltal Financing Activities Cash Flows from Capital and Related Financing Activities: Acquisition of Capital Assets Net Cash (Used) by Capital and Related Financing activities Cash Flows from Investing Activities: Purchase of Investments Proceeds from Sale and Maturities of Investment Securities Interest on Investments Net Cash Provided (Used) by Investing Activities Net Increase (Decrease) in Cash and Cash Equivalents Cash and Cash Equivalents, October 1 Cash and Cash Equivalents, September 30 Reconciliation of Operating Income (Loss) to Net Cash Provided (Used) by Operating Activities: Operating Income (Loss) Adjustments to Reconcile Operating Income (Loss) to Net Cash Provided (Used) by Operating Activities Depreciation Change in Assets and Liabilities: Change in Accounts Receivable Change in Joint Venture Receivable Change in Prepaid Costs Change in Accounts Payable Change in Accrued Liabilities Change in Accrued Vacation Total Adjustments Net Cash Provided (Used) by Operating Activities -118- Employee Benefits $1,195,488 (1,271, 757) 0 0 -(76,269� 1,319 1,319 0 0 (14,077) 77,594 6,204 69,721 (5,229) 8,051 $ 2,822 $ (52,857) 0 3,766 0 (3,800) (15,524) (7,854) 0 (23,412) $(76,269) Property and Landfill Casualty $573,699 $372,550 (250,525) (300,502) (279,946) 0 0 0 43,228 72,048 (3,239) (1,487) (3,239) (1,487) (15,133) 0 (15,133) 0 (20,705) (58,777) 0 0 0 0 (20,705) (58,777) 4,151 11,784 0 0 $ 4,151 11,784 $ 22,487 $(27,710) 1,593 0 0 615 0 0 130,186 51,089 (20,507) 108,371 (93, 101) (60,317) 2,570 0 20,741 99,758 $43,228 $72,048 Utility Workers' Totals Unemployment Billing Comoensat!on liil liiQ $71, 157 $1,070,876 $419,038 $3,702,808 $2,655,266 (19,789) (280,523) (380,875) (2,503,971) (2, 162,603) 0 (738,737) 0 (1,018,683) (801,185) 0 0 0 0 153,398 51,368 51,616 38,163 180, 154 (155,124) 0 0 0 0 200,000 0 0 0 (3,407) (15,259) 0 0 0 (3,407) 184,741 0 (91,094) 0 (106,227) (52,777) 0 (91,094) 0 (106,227) (52,777) (43,423) (11,395) (332,072) (480,449) (651,995) 0 44,259 298,640 420,493 588,237 761 4,307 30,858 42,130 33,996 (42,662) 37, 171 (2,574) (17,826) (29,762) 8,706 (2,307) 35,589 52,694 (52,922) 0 4,592 30,985 43,628 96,550 $8,706 $ 2,285 $66,574 $96,322 $43,628 $51,368 $(41,230) $(63,420) $(111,362) $(222,148) 0 90, 179 91,772 84,885 0 0 0 4,381 (4,291) 0 0 0 0 (130, 186) 0 0 43,980 221,455 (50,639) 0 2,621 39,785 114,746 (19,505) 0 (1,883) 17,818 (145,337) 173,062 0 1,929 0 4,499 13,698 0 92,846 101,583 291,516 67,024 $51,368 $51,616 $38,163 $180,154 $(155,124) -119. Operating Revenues: Premiums Flex Benefits Withheld Total operating revenues Operating Expenses: Claims Administration Fees Premiums Other Total Operating Expenses Net Operating Loss Nonoperating Revenues: Interest Earnings Other Total Nonoperating Expenses Net Loss CITY OF COLLEGE STATION. TEXAS EMPLOYEE BENEFITS FUND SCHEDULE OF REVENUES AND EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Budget Actual $1,197,000 $1,178,899 0 12,823 1,197,000 1, 191,722 975,000 896,436 54,000 83,605 190,000 242,000 0 3,725 1,219,000 1,225,766 (22,000) (34,044) 0 6,204 0 1,319 0 7,523 $(22,000) $(26,521) See reconciliation to GAAP basis on page 126. -120- Variance Favorable (Unfavorable) $(18, 101) 12,823 (5,278) 78,564 (29,605) (52,000) (3,725) (6,766) (12,044) 6,204 1,319 7,523 $(4,521) Operating Revenues: Charges for Services Total Operating Revenues Operating Expenses: Salaries and Benefits Supplies Maintenance CITY OF COLLEGE STATION. TEXAS LANDFILL FUND · SCHEDULE OF REVENUES AND EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Budget Actual $580,285 $573,699 580,285 573,699 - 294,986 291,960 60,146 59,829 52,119 52,081 Purchased Professional Services 7,650 6,668 Purchased Property Services 12,312 12,222 Other Purchased Services 20,215 10,676 Reimbursed Adminstrative 123,403 123,403 Capital Outlay 15,200 15, 134 Contingency 15,000 0 Expected Expenditure Savings (20,746) 0 Total Operating Expenses 580,285 571,973 Net Operating Income 0 1,726 Nonoperating Expenses: Interest Expense 0 3,239 Total Nonoperatlng Expenses 0 3,239 Net Loss $ 0 $(1,513) See reconciliation to GAAP basis on page 126. • 121. Variance Favorable (Unfavorable) $(6,586) (6,586) 3,026 317 38 982 90 9,539 0 66 15,000 (20,746) 8,312 1,726 (3,239) (3,239) $(1,513) Operating Revenues: Premiums Reimbursements Total Operating Revenues Operating Expenses:. Claims Premiums Reimbursed Administrative Total Operating Expenses Net Operating Income (Loss) Nonoperating Expenses: Interest Expense · Total Nonoperating Expenses Net Income (Loss) CITY OF COLLEGE STATION. TEXAS PROPERTY AND CASUAL TY FUND SCHEDULE OF REVENUES AND EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Budget Actual $371,300 $371,935 0 7,843 371,300 379,778 40,000 28,981 340,000 281,345 24,894 24,894 404,894 335,220 (33,594) 44,558 0 671 0 671 $(33,594) $43,887 See reconciliation to GAAP basis on page 126. • 122. Variance Favorable (Unfavorable) $635 7,843 8,478 11,019 58,655 0 69,674 78,152 . 671 671 $77,481 Operating Revenues: Premiums Total Operating Revenues Operating Expenses: Claims Total Operating Expenses Net Operating Income Nonoperating Revenues: Interest Earnings Total Nonoperating Revenues Net Income CITY OF COLLEGE STATION. TEXAS UNEMPLOYMENT FUND SCHEDULE OF REVENUES AND EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Budget Actual $67,900 $71, 157 67,900 71, 157 48,000 19,789 48,000 19,789 19,900 51,363 0 1,689 0 1,689 $19,900 $53,057 See reconciliation to GAAP basis on page 126. • 123. Variance Favorable (Unfavorable) $3,257 3,257 28,211 28,211 31,468 1,689. 1,689 $33,157 Operating Revenues: Charges for Services Total Operating Revenues Operating Expenses: Salaries and Benefits Supplies Maintenance Purchased Property Services Other Services Reimbursed Administrative Capital Outlay Expected Expenditure Savings Contingency Total Operating Expenses Net Operating (Loss) Nonoperating Revenues: Interest Earnings Other Total Nonoperating Revenues Net Income CITY OF COLLEGE STATION. TEXAS UTILITY BILLING FUND SCHEDULE OF REVENUES AND EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Budget Actual $1,070,876 $1,070,876 1,070,876 1,070,876 - 737,110 738,783 28,629 26,025 11,110 10,959 20,718 20,124 85,842 83,752 141,050 141,050 65,785 51,319 (39,969) 0 13,215 0 1,063,490 1,072,012 7,386 (1, 136) 0 4,509 0 745 0 5,254 $ 7,386 $ 4,118 See reconciliation to GAAP basis on page 126. -124 - Variance Favorable (Unfavorable) $ 0 0 (1,673) 2,604 151 594 2,090 0 14,466 (39,969) 13,215 (8,522) (8,522) 4,509 745 5,254 $ (3,268) Operating Revenues: Premiums Total Operating Revenues Operating Expenses: Administration Fees Claims Premiums Reimbursed Administrative Total Operating Expenses Net Operating Income Nonoperating Revenues: Interest Earnings Total Nonoperating Revenues Net Income CITY OF COLLEGE STATION. TEXAS WORKERS' COMPENSATION FUND SCHEDULE OF REVENUES AND EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Budget Actual $399,800 $419,038 399,800 419,038 - 20,000 19,443 280,000 371, 143 22,600 22,978 24,894 24,894 347,494 438,458 52,306 (19,420) 0 32,525 0 32,525 $ 52,306 $ 13,105 See reconciliation to GAAP basis on page 126. -125- Variance Favorable (Unfavorable) $ 19,238 19,238 557 (91t143) (378) 0 (90,964) (71,726) 32,525 32,525 $(39,201) CITY OF COLLEGE STATION. TEXAS INTERNAL SERVICE FUNDS SCHEDULE FOR RECONCILIATION OF REVENUES AND EXPENSES (BUDGETARY BASIS) TO GAAP BASIS STATEMENT OF INCOME FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 Total Revenues per Budget-Actual Less Total Expenses per Budget-Actual Net Income (Loss) , Budgetary Basis Add-Expenses Related to Balance Sheet: Capital Outlay Add(Deducij • Unbudgeted Revenue/Expense Adjustments: Prior Year Claims Expense Accrual Reclass Salaries and Benefits to Construction In Progress Claims Expense Correction Prepaid Insurance Correction Claims Incurred but not Paid Depreciation Prior Year Encumbrances Loss on Sale of Equipment Net Income (Loss), GAAP Basis Employee Benefits Landfll $1,199,245 $573,699 (1,225 ,766) (575,212) (26,521) (1,513) 0 15,134 0 0 0 7,220 18,813 0 0 0 0 0 0 (1,593) 0 0 0 0 $(45,334) $19,248 -126- Property and Casualty $379,n8 (335,891) 43,887 0 0 0 0 (72.268) 0 0 0 0 $(28,381) Workers' Unemployment Utility Billing Compensation 72,846 $1,076,130 $451,563 (19,789) (1,072,012) (438,458) 53,057 4,118 13, 105 0 51,319 0 0 0 0 0 0 0 0 0 0 0 0 (44,000) 0 0 0 0 (90,179) 0 0 (1,919) 0 0 (2,700) 0 $53,057 $(39,360) $(30,895) -127- -128- GENERAL FIXED ASSETS ACCOUNT GROUP To account for fixed assets not used in proprietary fund oper ations. -129- -130- CITY OF COLLEGE STATION, TEXAS GENERAL FIXED ASSETS ACCOUNT GROUP SCHEDULE OF GENERAL FIXED ASSETS BY SOURCE September 30, 1991 1991 General Fixed Assets: Buildings $ 13,031,574 Improvements 14, 103,419 Machinery and Equipment 10,000,811 Parks System 5,826,944 Construction in Progress 630,808 Land 5,089,038 Total General Fixed Assets $ 48,682,594 Investment in General Fixed Assets From: Capital Projects Funds: General Obligation Bonds 29, 168,875 Certificates of Obligation 1, 732, 352 Contractual Obligations 2,984,843 General Fund Revenues 4,703,639 Special Revenue Funds: Federal Grants 2,026,719 Other 1'086, 931 Acquisitions Prior to July 1 ' 1979-- Source Undetermined 6,979,235 Total Investment in General Fixed Assets $ 48,682,594 -131 - 1990 $ 11,448,305 12,390,473 8,981,715 5,761,583 2,425,974 4,999,926 $ 46,007,976 27,561,019 1,732,352 0 6,623,927 2,023,722 1,066,821 7 ,000, 135 $ 46,007,976 cny OF COLLEGE STATION. TEXAS GENERAL FIXED ASSETS ACCOUNT GROUP SCHEDULE OF GENERAL FIXED ASSETS BY SOURCE -BY FUNCTION AND ACTIVITY SEPTEMBER 30, 1991 General Fund: General Government Fiscal and Human Resources Police Fire Development Services Public Services Parks Management Services Total General Fund Special Revenue Funds: Parks Escrow Federal Grants Other Total Special Revenue Funds Capital Projects Funds: Certificates of Obligation Funds Capital Equipment Southwest Parkway 1971 Bond Funds 1976 Bond Funds 1978 Bond Funds 1978 II Bond Funds 1981 Bond Funds 1982 Bond Funds 198211 Bond Funds 1984 Bond Funds 1989 Bond Funds 1991 Bond Funds Total Capital Projects Funds Acquisitions Prior to July 1, 1979 -Source Undetermined Total General Fixed Assets Allocated to Functions Construction in Progress Total General Fixed Assets Total $ 501,361 292,654 737,968 1,011,177 312,68«> 1,379,467 1,044,277 31,497 5,311,087 140,650 2,023,722 1,066,821 3,231,193 1,732,352 2,230,079 642,231 172,838 126,377 533,706 2,803,997 1,904,043 3,902,862 6,734,898 9,779,925 1,942,791 24,172 32,530,271 6,979,235 48,051,786 630,808 $48,682,594 -132- $ Building and Bullding Land Improvements 0 0 0 0 0 0 0 0 0 0 13,082 150,009 163,091 637,168 0 0 0 0 0 485,325 224,979 376,857 856,785 799,116 89,112 0 3,469,342 1,456,605 5,089,038 $5,089,038 $ 59,444 10,654 1,972 3,869 9,374 28,168 203,749 0 317,230 0 221,859 894,294 1,116, 153 400,000 0 0 0 1,495 25,141 579,005 1, 114, 176 1,237,290 901,923 4,509,689 877,615 0 9,646,334 1,951,857 13,031,574 2,727 $13,034,301 Machinery, Tools and Equipment Parks System Improvements $ 441,917 $ 0 $ 0 282,000 0 0 735,996 0 0 1,007,308 0 0 302,948 0 364 1,351,299 0 0 - 599,809 240,719 0 31,497 0 0 4,752,774 240,719 364 1,300 139,350 0 11,039 154,930 1,622,812 3,248 0 19,270 15,587 294,280 1,642,082 695,184 0 0 2,230,079 0 0 0 0 642,231 0 0 172,838 0 13,249 111,633 0 162,399 346,166 13,967 1,070,353 655,347 930 22,568 541,390 284,443 423,381 1,580,891 694,379 2,433,490 1,848,321 703,751 336,850 3,430,519 14,561 0 961,503 0 17,446 6,726 4,637,294 4,479,736 10,297,565 595,156 812,209 2,163,408 10,000,811 5,826,944 14,103,419 50 473,172 154,859 $10,000,861 $6,300,116 $14,258,278 -133 • CITY OF COLLEGE STATION, TEXAS GENERAL FIXED ASSETS ACCOUNT GROUP SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS BY FUNCTION AND ACTIVITY FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991 General Fixed General Fixed Assets Assets 9/30/90 Additions Retirements Transfers 9/30/91 Function and Activity General Fund: General Government $ 518,971 $ 24,428 $ 42,038 $ 0 $ 501,361 Fiscal and Human Resources 272,406 20,248 0 0 292,654 Police 725,725 101,241 88,998 0 737,968 Fire 924,278 86,898 0 0 1,011, 176 Development Services 282,983 35,713 6,010 0 312,686 Public Services 1,357,195 172,230 149,957 0 1,379,468 Parks 947,814 115,674 19,211 0 1,044,277 Management Services 0 31,497 0 0 31,497 Computer Project I 458,321 0 0 (458,321) 0 Computer Project II 1,016,994 532,298 (1,549,292) 0 Parks Escrow 119,240 0 0 (119,240) 0 Total General Fund 6,623,927 1,120,227 306,214 (2, 1 26,853) 5,311,087 Special Revenue Funds: Federal Grants 2,023,722 0 0 0 2,023,722 Parks Escrow 0 21,410 0 119,240 140,650 Other 1,066,821 0 0 0 1,066,821 Total Special Revenue Funds 3,090,543 21,410 0 119,240 3,231,193 Capital Projects Funds: Certificates of Obligation 1,732,352 0 0 0 1,732,352 Southwest Parkway 642,231 0 0 0 642,231 1971 Bond Funds 172,838 0 0 0 172,838 1976 Bond Funds 126,377 0 0 0 126,377 1978 BondFunds 533,706 0 0 0 533,706 1978 II Bond Funds 2,803,997 0 0 0 2,803,997 1981 Bond Funds 1,904,043 0 0 0 1,904,043 1982 Bond Funds 3,902,862 0 0 0 3,902,862 1982 II Bond Funds 6,407,855 327,043 0 0 6,734,898 1984 Bond Funds 8,641,136 1,138,789 0 0 9,779,925 1989 BondFunds 0 1,942,791 0 0 1,942,791 1991 Bond Funds 0 24,172 0 0 24,172 Capital Equipment 0 222,466 0 2,007,613 2,230,079 Total Capital Projects Funds 26,867,397 3,655,261 0 2,007,613 32,530,271 Acquisitions Prior to July 1, 1979 • Source Undetermined 7,000,135 0 20,900 0 6,979,235 Construction in Progress 2,425,974 2,204,117 0 $(3,999,283) 630,808 Total General Fixed Assets $46,007,976 $7,001,015 $327, 114 $(3,999,283) $48,682,594 -134. STATISTICAL SECTION -1 35 - CITY OF COLLEGE STATION, TEXAS GENERAL GOVERNMENTAL REVENUES AND OTHER FINANCING SOURCES' (1) LAST TEN FISCAL YEARS General Fiscal Property Franchise & Sales & Mixed Licenses & Fines & Year Tax Franchise Tax Drink Tax Permits 1982 $606,989 s1n,1sa $1,874,722 $299,5n 1983 589,814 228,951 2,654,600 226,466 1984 25,696 299,269 2,743,848 193,065 1985 8,408 267,991 3, 104,118 220,378 1986 208,481 315,272 3,066,168 114,971 1987 222,826 299,973 3,016,640 102,739 1988 (4) 967,253 (5) 340,310 4,257,621 139,412 1989 1,566,885 (6) 345,416 3,825,314 97,449 1990 1,n4,601 (7) 335,940 4,097,742 94,691 1991 1,482,5n (8) 328,524 6,523,709 116,574 (1) Revenue presented includes the General Fund and Debt Service Funds. (2) Contribution from Enterprise Funds represents transfers in lieu of taxes. (3) Revenue sharing transfers made fiscal 1980 through fiscal 1987. (4) Fiscal Year 1988 represents the transition from a June 30 year-end to September 30. Fiscal Year 1988 shows the 15 months 7/1/87 - 9/30/88. (5) Property tax allocated to the General Fund increased from two cents per $100 valuation in 1987 to nine cents in 1988, with a corresponding decrease in debt service from thirty-six to twenty-nine cents. Penalties $418,371 492,985 350,244 442,921 459,872 442,408 478,114 490,184 536,155 518,357 (6) Property tax allocated to the General Fund increased from nine cents per $100 valuation in 1988 to fourteen cents in 1989, with a corresponding decrease in debt service from twenty-nine to twenty-four cents. (7) General Fund property tax increased from fourteen cents per $100 valuation in 1989 to sixteen cents in 1990. (8) General Fund property tax decreased from sixteen cents per $100 valuation in 1990 to thirteen and one quarter cents per $100 valuation in 1991 . Source: City of College Station -136. Charges Transfer Other Debt Service For From Enterprise Financing Property Services Funds (2) All Other Sources Tax Total $177,930 $1,647,247 $431,233 $313,89 3 (3) $1,614,989 $7,562,704 227,962 2,097,225 564,636 517,768 (3) 1,724,363 9,324,770 269,094 2,774,940 354,924 337,370 (3) 2,678,842 10,027,292 286,010 3,272,759 453,871 625,82 5 (3) 3,514,761 12,197,042 335,371 4,066,951 407,287 706,772 (3) 3,826,083 13,507,228 298,463 4,302,654 414,908 657,086 (3) 3,992,810 13,750,507 487,541 5,570,140 577,819 61,439 3,411,171 (5) 16;290,820 500,710 4,501,169 593 ,764 23,520 2,845, 775 (6) 14,790,186 573,748 4,701,449 693,154 31,565 2,716,367 15,555,412 540,096 3,772,060 553,079 121,895 3,037,368 16,994,239 -137 - ST A TISTICAL SE CTIO N CITY OF COLL EGE ST ATION, TEXA S GENERAL GOVERNMEN TAL EXPENDIT UR ES AND OTHER USES BY FUNCTION (1) LAS T TEN FISCAL YEARS Fiscal General Year Government Police Fire 1982 $2,132,476 $1,491,374 $1,350,053 1983 3,592,677 1,922,117 1,691,084 1984 3,200,862 2,089,176 1,842,618 1985 3,559,610 2,445,386 2,008,648 1986 3,948,780 2,711,271 2,224,796 1987 4,214,064 3,024,395 2,324,273 1988 (2) 4,968,662 3,883,961 2,943,886 1989 4,335,002 3,188,081 2,588,909 1990 4,617,138 3,363,665 2,780,466 1991 4,723,549 3,491,656 2,833,455 (1) Expenditures presented include the General and Debt Service Funds. (2) Fiscal year 1988 represents the transition from a June 30 year-end to September 30. Fiscal Year 1988 shows the 15 months 7/1/87 -9/30/88. (3) Utility Billing established as internal service fund in fiscal year 1989, reducing reimbursed administrative expenditures in General Fund. Source: City of College Station • 138. Public Services $714,819 819,417 966,407 1,142,137 1,240,623 1,190,695 1,561,876 1,392,230 1,502,988 1,940,697 Other Parks & Capital Reimbursed Debt Financing Recreation Outlay Administrative Service Uses Total $733,073 $498,411 ($1,277,255) $1,571,830 $ 0 $7,214,781 979,019 549,230 (1,532,333) 2,417,748 0 10,438,959 1,159,758 762,368 (2,391,871) 3,493,647 0 11,122,965 1,405,236 651,878 (2, 779, 161) 3,499,615 0 11,933,349 1,572,606 606,156 (2,832, 153) 3,807,583 0 13,279,662 1,583,837 399,930 (3,353,671} 3,705,802 0 13,089,325 2,401,189 1,068,070 (3,818,632) 3,813,384 0 16,822,396 2,090,649 636,539 (2,393, 775} (3) 3,399,826 0 15,237,461 (3) 2,428,196 345,317 (2,276,465) (3) 3,422,703 200,000 16,384,008 (3) 2,269,977 602,976 (2,415,356) (3) 3,671,439 720,546 17,838,939 -139. Current Fiscal Year 1982 1983 1984 1985 1986 1987 1988 1989 · 1990 1991 STATI STICAL SECTION CITY OF COLLEGE STATION, TEXAS PROPE RTY TAX LEVIE S AND COLLECTIONS LAST TEN FISC AL YEARS Percent Total Tax Of LS\ly Tax Levy Collections Collected $1,281,534 $1,236,615 96.50 2,286,192 2,178,842 95.30 2,609,180 2,497,144 95.71 3,446,634 3,243,918 94.12 4,163,870 3,870,682 92.96 4,261,855 3,956,428 92.83 4,181,328 3,945 ,308 94.36 4,262,125 4,122,235 96.72 4,472,941 4,376,436 97.84 4,429,176 4,308,690 97.28 Source: City of College Station -140. Delinquent Tax Collections $50,820 42,389 76,450 79,880 105,878 192,003 315,203 202,588 98,787 136,233 Total Collections · ·outstanding Delinquent Total As Percent Of Outstanding Taxes As A Percent Tax Collections Current Levy Delinquent Taxes Of Current Levy $1,287,435 100.46 $70,839 5.53 2,221,231 97.16 135,609 5.93 2,573,594 99.40 168,495 6.46 3,323,798 96.44 286,133 8.30 3,976,560 95.50 470,034 11.29 4,148,431 97.34 582,614 13.67 4,260,511 101.89 489,709 11.71 4,324,823 101.47 420,113 9.86 4,475,223 100.05 394,727 8.82 4,444,923 100.36 327,854 7.40 -141 - Fiscal Year 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 Source: (1) CITY OF COLLEGE STATION, TEXAS ASSESSED AND ESTIMATED ACTUAL VALUE OF TAXABLE PROPERTIES LAST TEN FISCAL YEARS Real Property Assessed Estimated Value Actual Value $391,198,889 $391, 198,889 695,479,501 695,479,501 n5,606,760 n5,606,760 879,001,892 879,001,892 993,907,903 993,907,903 1,014,067,239 1,014,067,239 993, 765,995 993, 765,995 1,002,938,332 1,002,938,332 995,686,332 995,686,332 983,973,909 983,973,909 1,013,892,433 1,013,892,433 Brazos County Appraisal District Personal Property Assessed Estimated Value Actual Value $44,786,518 $44,786,518 74,976,425 74,976,425 95,188,096 95,188,096 116,065,055 116,065,055 144,581,203 · 144,581,203 143,572,456 143,572,623 145,214, 623 145,214, 623 157,209,511 157,209,511 161 ,343, 707 161,343,707 156, 164,603 156, 164,603 150,886,397 150,886,397 State Property Tax Board Report of Property Value Does not include totally exemjX property -142- Exemptions Real Property (1) $19,582,260 31,709,751 29,592,994 35,420,320 36,875,269 36,629,372 38,631,099 38,535,92 2 38,794,667 38,658,990 38,166,827 Total Ratio of Total Assessed Assessed Estimated To Total Estimated Value Actual Value Actual Value $416,403, 147 $41 6,403, 147 100 738,746,175 738,746, 175 100 841 ,201 ,862 841,201,862 100 959,646,627 959,646,627 100 1, 101,613,837 1, 101,613,837 100 1, 121,010,323 1, 121,010,323 100 1, 100,349,519 1,100,349,519 100 1, 121,611,921 1, 121,611,921 100 1, 118,235,372 1, 118,235,372 100 1, 101 ,479,522 1, 101,479,522 100 1,126,612,003 1,126,612,003 100 • 143. (1) (2) Fiscal Year(1) City 1982 $.31 1983 .31 1984 .31 1985 .36 1986 .38 1987 .38 1988 .38 1989 .38 1990 .40 1991 .40 CITY OF COLLEGE STATION, TEXAS PROPERTY TAX RATES, RATIOS AND LEVIES DIRECT AND OVERLAPPING LAST TEN FISCAL YEARS Tax Rates (Per $100 of Assessed Value) School County State $1.1800 $0.4000 $.10 (4) 0.9000 0.2700 .00 0.9700 0.3100 .00 0.9500 0.3296 .00 0.9780 0.3253 .00 1.0790 0.4170 .00 1.0790 0.4170 .00 1.2100 0.3427 .00 1.3000 0.3689 .00 1.4400 0.4105 .00 Total(3) $1.9900 1.4800 1.5900 1.6396 1.6833 1.8760 1.8760 1.9327 2.0689 2.2500 Tax rates are established by each taxing jurisdiction on an annual basis for revenues to be collected in the following fiscal year. The elate that taxes are due for all jurisdictions is October 1. Taxes for all jurisdictions become delinquent on February 1. The penalty is set by state law at S°.ib in February, and an additional 1 % per month up to 12%. The interest is accrued at 1 % per month. (3) The upper limit of the tax rate is set at $2.50/$100 of assessed value for each jurisdiction by State Statute. This limit is for both operations and debt service combined. (4) The state legislature effectively eliminated state property taxes by reducing the ratio to .0001% infiscal 1981. Source: Brazos County Appraisal District -144- Tax Ratios Original Tax Levies City School County City School County 100 100 100 $1,281,560 $4,707,725 $4,140,834 100 100 100 2,286,192 7,105,257 5,879,701 100 100 100 2,609,180 8,706,598 9,086,144 100 100 100 3,446,634 9,676,001 9,206,410 100 100 100 4,163,870 11,757,247 9,997,174 100 100 100 4,261,855 12,797,106 11,515,156 100 100 100 4,181,328 12,959,657 12,297,807 100 100 100 4,262,125 14,868,835 10,138,888 100 100 100 4,472,941 15,814,785 10,476,587 100 100 100 4,429,176 17,388,938 11,438,852 -145 - CITY OF COLLEGE STATION, TEXAS PAVING ASSESSMENT COLLECTIONS LAST TEN FISCAL YEARS Percentage of Total Fiscal Current Assessments Assessments Outstanding Year Assessment Collected Collected Assessments 1982 $394,287 $348,235 80.39% $84,929 1983 40,116 32,454 25.95% 92,591 1984 49,373 65 5.00% 141,899 1985 45,746 32.24% 96,153 1986 16,019 16.66% 80,134 1987 13,433 16.76% 66,701 1988 202,546 36,913 13.71% 232,334 1989 21,703 93.4()0-' 210,631 1990 40,926 14,251 5.67% 237,306 1991 31,016 13.07% 206,290 Source: City of College Station Finance Department • 146. CITY OF COLLEGE STATION, TEXAS COMPUTATION OF LEGAL DEBT MARGIN SEPTEMBER 30, 1991 The City has no general obligation legal debt limit other than a ceiling on the tax rate as specified by the State of Texas. The prescribed maximum is $2.50 per $100 at 100% valuation. • 147. Fiscal Year 1982 1983 1984 1 985 1986 1 987 1988 1989 1990 1991 CITY OF COLLEGE STATION, TEXAS RATIO OF NET GENERAL BONDED DEBT TO ASSESSED VALUE AND NET BONDED DEBT PER CAPITA Estimated Population (1) 43,121 47,578 49,022 50,853 50,991 51,222 51,463 51,707 51,977 52,456 (2) LAST TEN FISCAL YEARS Assessed Value $433,053,691 769,127,740 841,670,967 957,398,333 1,095, 755,455 1, 121,540, 789 1, 100,349,519 1, 121,611 ,921 1, 118,235,372 1, 126,612,003 Gross Bonded Debt $14,690,000 (3) 20,240,000 (3) 27,480,000 (3) 21,354,00Q 19,907,500 18,411,000 20,993,888 19,242,957 20,664,590 18,577,355 (1) Source: Metropolitan Planning Organization & City of College Station Planning Department (2) Source: U.S. Goverrment Census (3) Includes general obligation debt that is sef'Viced by the Enterprise Funds. In fiscal 1985, such debt was reflected as indebtedness of the Utility Fund. -148. Less Debt Service Cash Funds $812,717 955,945 1,478,640 1,750,986 2,028,845 2,560,656 1,890,972 1,880,417 1,528,503 1,146,503 Net Bonded Debt $13,877 ,283 19,284,055 26,001,360 19,603,014 17,878,655 15,850,344 19,102,916 17,362,550 19,136,087 17,430,852 Ratio of Net Bonded Debt To Assessed Valuation 3.20 2.51 3.09 2.05 1.63 1.41 1.74 1.55 1.71 1.55 • 149. Net Bonded Debt Per Capita $322 405 530 385 351 309 371 336 368 332 Taxing Body ESTIMATED OVER- LAPPING DEBT College Station l.S.D. Brazos County Bryan l.S.D. NET DIRECT DEBT City of College Station CITY OF COLLEGE STATION, TEXAS SCHEDULE OF DIRECT AND ESTIMATED OVERLAPPING DEBT (1) SEPTEMBER 30, 1991 Net Bonded Debt City's Share Amount As Of Percent Amount (2) $35, 170,000 &'31/91 82.28 % $28,937,876 (3) 8,825,953 &'31/91 35.n 3,157,043 (4) 29,810,000 &'31/91 3.54 1,055,274 $33, 150, 193 17,430,852 9/3Q'91 100.00 17,430,852 NET DIRECT AND ESTIMATED OVERLAPPING DEBT $50,581,045 *Population 52,456 (1) Source: City of College Station Finance Department (2) Source: College Station Independent School District (3) Source: Brazos County (4) Source: Bryan Independent School District -150- Per* Capita $552 60 20 632 332 $964 Fiscal Year 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 (1) (2) Source: CITY OF COLLEGE STATION, TEXAS RATIO OF ANNUAL DEBT SERVICE EXPENDITURES FOR GENERAL OBLIGATION DEBT TO TOTAL GENERAL GOVERNMENTAL EXPENDITURES AND OTHER USES LAST TEN FISCAL YEARS Total General Interest, Gover nmental Fiscal and Total Expenditures Principal Other Charges Debt Service and Other Uses $ 856,343 $ 715,120 $ 1,571,463 (1) $ 7,214,781 1,195,929 1,221,313 2,417,242 (1) 10,438,959 1,547,007 1,944,710 3,491,717 (1) 11,122,965 1,361,800 2,137,815 3,499,615 11,933,349 1,630,982 2,176,601 3,807,583 13,279,662 1,685,439 2,020,363 3,705,802 13,089,325 1,795,053 2,108,331 3,813,384 16,822,396 (2) 1,852,938 1,546,888 3,399,826 15,237,461 1,913,720 1 ,508,983 3,422,703 1 6,384,008 2,206,493 1,464,946 3,671,439 17,838,939 Includes general obligation debt that is serviced by the Enterprise Funds. As of July 1, 1984, such debt was reflected as indebtedness of the Utility Fund. Fiscal year 1988 represents the transition from a June 30 year-end to September 30. Fiscal year 1988 shows the 1 s months 7 /1 /87 -9130/88. City of College Station -151 • Ratio 21.78 % 23.16 31.39 29.33 28.67 28.31 22.67 (2) 22.31 20.89 20.58 Fiscal Year 1982 1983 1984 1985 1986 1987 1988 (1) 1989 1990 1991 (1) Source: Operating Revenues $16,549,721 23,611,548 26,277,830 31,867,897 32,480,725 32,760,614 48,138,363 37,584,613 37,108,418 35,558,916 CITY OF COLLEGE STATION, TEXAS UTILITY FUND SCHEDULE OF REVENUE BOND COVERAGE LAST TEN FISCAL YEARS Operating Expenses (Excluding Net Depreciation) Revenues $9,456,675 $7,093,046 15,505,972 8,105,576 16,265,010 10,012,820 21,673,543 10,194,354 23,958,157 8,522,568 22,777,769 9,982,845 33,676,511 14,461,852 26,878,049 10,706,564 26,478,070 10,630,348 27,042,224 8,516,692 Debt Service Requirements Average ··Annual Maximum AnnuaJ Total Coverage Total Coverage $1,492,660 4.75 % $2,410,048 2.94% 2,288,214 3.54 3,787,641 2.14 4,066,427 2.46 5,688,176 1.76 3,582,202 2.85 5,172,546 1.97 3,476,179 2.45 5,143,007 1.66 3,357,048 2.97 5,096,158 1.96 3,532,240 4.09 5,384,967 2.69 3,377,186 3.17 5,090,875 2.10 2,952,927 3.60 4,826,164 2.20 2,738,882 3.10 4,994,535 1.70 Fiscal year 1988 represents the transition from a June 30 year-end to September 30. Fiscal year 1988 shows the 15 months 7/1 /87 -9/'J0/88. City of College Station • 152. Fiscal Year 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 (1) CITY OF COLLEGE STATION, TEXAS TOTAL BANK DEPOSITS LAST TEN FISCAL YEARS Amount $17 4,990,000 175,848,000 190, 147 ,000 200,588,000 199, 102,000 214,443,000 135,469,000 (2) 806, 1 00,000 (3) 703,600,000 (3) 787,700,000 (1) Effective in fiscal year 1988, data from September 30. Prior years are June 30 reports. (2) During fiscal year 1988, First Republic Bank A&M was purchased by North Carolina National Bank and operated. as a branch of N.C.N.B.­ Texas National Bank. Call reports are not issued by branch banks. (3) Due to continued consofidation in the banking industry, total includes Bryan - College Station area banks. SOURCE: Call reports for all College Station area banks • 153. Year 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 SOURCE: Cl1Y OF COLLEGE STATION, TEXAS CONSTRUCTION PERMITS LAST TEN CALENDAR YEARS Residential Construction Number of Permits Value 663 $64,567,551 424 27,272,747 134 23,500,892 194 9,587,839 209 8,104,272 250 12,655,651 243 20,279,472 229 15,528,105 213 12,539,486 370 18,933,748 Commercial Construction Number of Permits Value . 543 $40,1n,931 500 32,116,284 467 45,546,079 323 15,n9,281 134 16,133,255 225 15,590,672. 172 3,468,622 203 22,085,987 56 3,870,491 164 17,319,566 City of College Station Building Department • 154. Total Number of Permits 1,206 924 601 517 343 475 415 432 269 534 Value $104,745,482 59,389,031 69,046,971 25,367,120 24,237,527 28,246,323 23,748,094 37,614,092 16,409,9n 36,253,314 CITY OF COLLEGE STATION, TEXAS Taxpayer C.B.L. Management General Telephone Humana of Texas, Inc. Southwest Savings Association Resolution Trust Corp. Westinghouse Electric Corp. NCNB Texas Nati onal Bank Lodgec Properties/Rossco Holdings College Station Hotel Partners San Antonio Savings Primary Properti es -Foleys Jerry J. Moore Briarwood Trust Sears Roebuck, Co. Dillards Department Stores Plantation Oaks Association Cain, D.R. Scott & White Hospital First American Bank Texas Psychiatric Company Total PRINCIPAL TAXPAYERS SEPTEMBER 30, 1991 Type of Business Retail Mall Utility Hospital Hotel CommerciaV Apartments Manufacturing Bank RetaiVHotel Hotel Apartments Retail Shopping Centers Apartments Retail Retail Apartments Rental Properties Hospital Bank Hospital SOURCE: Brazos County Appraisal District -155 - 1990 Assessed Valuation $40,584,540 26,547,330 21,722,409 20,050,645 18,100,180 17,553,600 15,640,226 13,755,580 10,498,940 8,178,290 7,430,702 6,829,500 6,567,540 6,447,470 6,388,599 6,341,970 6,317,590 5,895,231 5,862,770 51806,250 $256,519,362 Percent of Total Assessed Valuation 3.60% 2.36 1.93 1.78 1.61 1.56 1.39 1.22 0.93 0.73 0.66 0.61 0.58 0.57 0.57 0.56 0.56 0.52 0.52 0.52 22.7So.4 Utility Customer Westinghouse City of College Station College Station Hotel Partners CSL & Associates U:S. Department of Agriculture Humana Hospital Skaggs Alpha Beta Kroger Company CSL & Associates Consolidated High School TOTAL CITY OF COLLEGE STATION, TEXAS PRINCIPAL UTILITY CUSTOMERS SEPTEMBER 30, 1991 Type of Business Manufacturing Municipality Hotel Retail Government Service Retail Grocery Retail Grocery Retail School District FY 1991 � Consumption 9,682 7.496 5,450 5,139 4,087 4,023 3,991 3,561 3,313 3,136 49,878 Total � consumption for the period October 1, 1990, to September 30, 1991, was 401, 1 �. SOURCE: City of College Station Utility Billing Department • 156· Total Percent of� Consumed 2.41% 1.86% 1.35% 1.28% 1.01% 1.00% 0.99% 0.88% 0.82% 0.78% 12.38% CITY OF COLLEGE STATION, TEXAS MISCELLANEOUS STATISTICAL AND DEMOGRAPHIC DATA SEPTEMBER 30, 1991 Date incorporated Date first charter adopted Date present charter adopted Form of government Fire Protection: Area in square miles Year Miles of streets 1938 1948 1958 1968 1978 1982 1986 1 988 1989 1990 1991 Miles of sidewalks Miles of sanitary sewer Number of stations Number of full-time employees Paved Unpaved Police Protection: Recreation: Number of employees (uniformed) Number of employees (plain clothes, clerical) Number of patrol units One jail facility with a capacity of 20 Number of playgrounds Number of basketball courts Number of swimming pools Number of soccer fields Number of softball/baSeball fields Num ber of tennis courts Number of picnic shelters Number of gyms Number of volleyball courts (Continued) • 157 • Square Miles 1.50 4.20 7.30 17.3 22.6 23.8 26.7 27.7 27.7 27.7 27.7 October, 1938 October, 1938 August, 1983 Council-Manager 157.0 Miles 2.5 Miles 30.0 Miles 210.0 Miles 2 68 69 29 15 21 17 3 17 14 12 10 1 4 CITY OF COLLEGE STATION, TEXAS MISCELLANEOUS STATISTICAL AND DEMOGRAPHIC DATA SEPTEMBER 30, 1991 (Continued) Sanitation Fund: Education: Elections: Population: SOURCE: Number of users (units served) Landfill size Methodology Attendance centers Number of classrooms Number of teachers Number of students Number of registered voters: Last general election Last municipal election Number of votes cast in: Last general election 18,750 119.53 acres Curbside pickup using plastic bags 7 350 375 5,400 26,652 32,787 Last municipal election Percentage of registered voters voting in: 1,800 2,280 Census Count Last general election Last municipal etection City of College Station 1990 1980 1970 1960 1950 • 160. 4.9% 7.0% 52,456 37,296 17,676 11,396 7,925 Deloitte & Touche December 23, 1991 Mayor Larry Ringer and Members of City Council City of College Station, Texas Suite 2300 Telephone: (713) 756-2000 333 Clay Street Facsimile: (713) 756-2001 Houston, Texas 77002-4196 Dear Honorable Mayor and Council Members: In planning and performing our audit of the general purpose financial statements of the City of College Station, Texas ("City") for the year ended September 30, 1991 (on which we have issued our report dated December 23, 1991), we considered its internal control structure in order to determine our auditing procedures for the purpose of expressing an opinion on the general purpose financial statements and not to provide assurance on the internal control structure. However, we noted certain matters involving the internal control structure and its operation that we consider to be a reportable condition under standards established by the American Institute of Certified Public Accountants. Reportable conditions involve matters coming to our attention relating to significant deficiencies in the design or operation of the internal control structure that, in our judgment, could adversely affect the City's ability to record, process, summarize and report financial data consistent with the assertions of management in the financial statements. The reportable condition that we noted is described below. FIXED ASSET DETAIL RECORDS Observation: The City maintains detail property records for the Utility and Sanitation Funds but not for the General Fixed Asset Group of Accounts. Recommendation: The City has prepared a draft of a fixed asset manual which outlines specific policies and procedures for conducting fixed asset inventories. The City should continue this process to ensure that a complete physical inventory of fixed assets is taken and to hire or train a fixed asset accountant whose duties would include maintaining accurate detail property records. We also submit our comments concerning certain observations and recommendations relating to other accounting matters. The recommendations resulted from our observations made in connection with our audit of the City's general purpose financial statements for the year ended September 30, 1991, and are described beginning on the following page. Member RR¥ ij� i International CONSTRUCTION IN PROGRESS Observation: Numerous year-end adjustments are required to properly state the property accounts. Back round: During the course of our audit, we noted that the Construction-in- rogress account is not analyzed on a timely basis to determine projects that are complete. Recommendation: Establish a review process to ensure that projects are transferred to fixed assets when complete and depreciation (if applicable) begins upon completion of the project. PAYROLL CHECK DISTRIBUTION Observation: Certain control procedures are not consistently adhered to relating to the distribution of employee payroll checks. Background: While observing the regular distribution of the employee payroll checks, we noted that payroll checks are not consistently compared to the payroll registers to verify that employees are being paid at the proper rates and that appropriate deductions are being withheld. In addition, unclaimed payroll checks are not always returned to the Payroll Department as required by the City of College Station Policy and Procedures Manual. Recommendation: Require that all employees consistently adhere to prescribed payroll procedures as documented in the City of College Station Policy and Procedures Manual. CAPITALIZATION POLICIES Observation: The current capitalization limits ($500 or 2 year useful life) allow for the capitalization of non-major and short-lived assets, which results in cumbersome record keeping tasks. Recommendation: Consider increasing the criteria for asset capitalization so that assets capitalized are significant and of a long-term nature. This report is intended solely for the information and use of the Mayor and City Council members, management, and others within the City, and officials of applicable federal and state agencies. This restriction is not intended to limit the distribution of this report, which is a matter of public record. We will be pleased to discuss these comments with you and, if desired, to assist you in implementing our suggestions. Yours truly, ��TtJuW- CITY OF COi J EGE S MEMORANDUM TO: Ron Ragland, City Manager FROM: Glenn Schroeder, Executive Director . --:� of Fiscal and Huma�eso� DATE: April 3, 1992 SUBJECT: Staff Response to Audit Manag emen t Letter The audit for the fiscal year ended Septe m ber 30, 1991 was completed by D el oitte & Touche/lngram, Wallis & Co., Inc. This was the second year of a three year j oint engagement that the City Council agreed to in 1990. As part of their annual audit process, the auditors conduct a review of the operations of the Finance Department. The result of that review is their "Report to Management" in whi ch they report on issues they consider to be wea knesses in the operation of th e department. Their report is divi ded into two areas: 1) reportable conditions, and 2) other matters. Reportable conditions involve areas in which serio us deficiencies exist which could significantly affect the reliability of the financial records of the City or the safeguard of the assets of the City. There is currently only one reportable condition noted in the auditors' report. It is in the process of being addressed. Other matters are issues that are of a minor nature and have been iden tifie d as areas where improvements would be b eneficial to the d e p a rt men t . The following response has been .structured to address the issues raised by the auditors. FIXED ASSET DETAIL RECORDS Lack of the detailed fixed asset re cords has been noted as a reportable condition for several years. Property records are available for the utility and sanitation funds in order to record depreciation. We have, likewise, drafted policies and p rocedures that would entail a complete fixed asset inventory. We have used these procedures to list property of individual divisions, such as utility billing and community development, but with existing resources and the complexity of a full inventory of the City, it will take several years to complete this process. OTHER MA TIERS Construction in Process Changes in the ca pital projects accountin g procedures have been drafted. Steps include not only coordination at the beginning of the project, but also steps at the co m pletio n of the project to ensure that t h e project is properly closed and transferred to fixed assets. Payroll Check Distribution Procedures have been p rescri bed as it relates to the distribution of payroll checks. The Fi nance Department personnel are currently planning assistance visits to the operating departments to review procedures and answer q uesti ons . Payroll distribution procedures will be reviewe d at this ti m e . Capitalization Policies Changes have been made to the cri te ria for asset capitalization. The new criteria will be i m plemented as part of the budget process for fiscal year 1992-93. cc: Mayor and City Council Executive Staff