Loading...
HomeMy WebLinkAboutFY 1991-1992 -- Comprehensive Annual Financial ReportI 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-F1SCALYeAR-cNDED SEPT-EMBEff 30, 1992 PREPARED BY THE CITY OF COLLEGE STATION FINANCE DEPARTMENT GLENN SCHROEDER, EXECUTIVE DIRECTOR FOR FISCAL AND HUMAN RESOURCES KATHLEEN HUBBARD, ACCOUNTING MANAGER CITY OF COLLEGE STATION. TEXAS COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 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 General Purpose Financial Statements for the Fiscal Year Ended September 30, 1992: Combine d Balance 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, 1992: 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 (Continued) . I • 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, 1992 TABLE OF CONTENTS (Continued) Community Development Fund Schedule of Revenues, Expenditures and Changes in Fund Balance -Budget and Actual (Budgetary Basis) Hotel/Motel 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 B asis) 1982 Se ries 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, Ex penses and C hanges in Retained Earnings Combining Statement of Cash Flows (Continued) • II • 80 81 82 84 86 88 89 90 91 92 94 98 100 Total Bank Deposits Construction Permits Principal Taxpayers CITY OF COLLEGE STATION. TEXAS COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 TABLE OF CONTENTS (Continued) Principal Utility Customers Miscellaneous Statistical and Demographic Data -v - 153 154 155 156 157 INTRODUCTORY SECTION - 1 - . 2. CITY OF COL.I EGE STATION February 22, 1993 Honorable Mayor Members of the City Council City of College Station , Texas The Comprehensive Annual Financial Report of the City of College Station, Texas ("City"), for the fiscal year ended September 30, 1992, is submitted herewith. This report was prepared by the City's Finance Department. Respo nsi bility for both the accuracy of the presented data and the completeness and f airness of the presentation, includin g all disclosures, rests with the City. We believe the data, as presented, is acc urate 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 affai rs have been included. The Comprehensive Annual Financial Report is presented in three major section s : 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 individual fund and account group financial statements and schedules, as well as the auditors' report on the financi al statements and schedules. The statistical section includes selected financial and demographic information, generally presented on a multiyear basis to allow for trend analys is of the finances of the City. The City is required to undergo an annual single audit in conformity with the provisions of the Singl e 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 financial 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 D istrict is ad mi nistered by a separate, elected board and operates with its own funding sources; therefore, it has not been included in this report. -3. THE CllY OF COLLEGE STA TlON 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 100 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 $530 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, 1992. The University employs approximately 19,000 permanent and part-time individuals 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 rese arc h 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. Retail activity 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, Beail's, and J.C. Penney. Major additions to the retail sector include the Sam's Wholesale Club opening in March, 1992, and Target in the fall of 1992. Three major grocery stores opened their doors in 1991. The City of College Station area has become the major medical center for the Brazos Valley area. Scott and White opened their first medical clinic in College Station in 1986 and in 1993 will increase the size of that clinic by some 50,000 squa re feet to 125,000 s qua re feet. In 1987, Humana Hospital opened a 100 bed fu!! service hospital and since the n two multi-story professional buildings have been added to the medical complex. Two. psychiatric hospitals serving the Brazos Valley, HCA­ Greenleaf and Desert Hills, are located in College Station. 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 mid-1980's, has been insulated by the dominant effect of Texas A&M University on the l ocal economy. Real estate property valuations had been essentially flat during the late 1980's but as detailed in the statistical section of this report, total valuations in 1992 increased more than $25 million. Improvements in the local economy have been balanced with residential and commercial development, with significant increases in sales tax revenues to the municipality in recent years. Oil and gas activity has returned to the College Station area with the city having permitted nineteen well sites within the last eighteen months. 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 four years. MAJOR INITIATIVES The City continues to devote significant attention to the infrastructure in College Station. General obligation bonds in the amount of $3,500,000 were issued in 1991 for major street and parks 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. Construction is underway for the Southwest Parkway interchange and the extension of FM 2818 was opened in June, 1992. Construction is underway for the widening and upgrading of Krenek Tap Road with a similar project for Sebesta Road to follow. Utility relocation for these projects is the responsibility of the City and has been completed. The City has an ongoing program to reconstruct certain residential . 4. and minor collector streets. A priority listing of streets for reconstruction was developed with the funding coming from an annual appropriation of approximatel y $400,000 from sales tax revenue. 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 co ntract 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 pr oj ects 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. The second series of revenue bonds is anticipated for the summer of 1993 and will be for the continued upgrading of the Carter Creek plant to meet future needs. Long Term. During fiscal 1990, the City entered into a contract with the Texas Municipal Power Agency (TMPA) cities. The City began receiving power under this contract on December 30, 1991 . Under the t erm s of the contract, the City will be a total r eq u irements customer and w ill have the opportunity to become a full partner in the TMPA when TMPA needs to expand its power generating facilities.· The City of College Station and the TMPA cities have recently submitted a proposal to meet the future power needs of Tex as A&M University. The proposal is anticipated to create a significant savings in power cost for all of the entities involved. Final decisions are expected to come from TexasA&M in May. TMPA was created in July, 1975, by concurrent ordinances of the Texas Cities of Bryan, Denton, Garland, and Greenville 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 (93-95) capital construction program for the electric, water, and sewer utilities. Total investment in the utility system over this period of time will be approximately $24.0 million, financed with the use of available funds on hand and the issuance of $12.5 million in utility revenue bonds. A three-year capital improvements budget was approved by the City Council as part of their d eli berati on on the fiscal 1992-93 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 st reet and parks projects that were targeted for construction in 1992 and 1993. The remaining $1 ,000,000 of authorized bonds will be iss u ed in fiscal year 93-94. The process has begun to identify the future capital needs in the areas of streets, facilities, and parks. Future bond authorization elections are anticipated to fund those projects. I n May of 1992 it was announced that the George Bush Presidential Library would be located in College Station on the Texas A&M campus. When completed in 1996, it is anticipated that more than 400,000 people per year will visit the library. College Station has begun preparation for this by placing additional emphasis in areas that will increase the appeal to visitors. Code enforcement and . 5. work in blighted areas has become a priority. The City has adopted a comprehensive streetscape plan to enhance the visual appeal of the community. Review of the City's comprehensive plan is called for to address the changing needs. While tourism is expected to play an important role in College Station's economy in the future, other forms of economic development are also being pursued. The master plan for the Pebble Creek Business Park will be completed by the summer of 1993. The 200 acre city-owned business park will attract high-tech, clean types of industry with two prospects waiting for the completion of Phase I. The City began 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. The amphitheater, walkways, and park areas included in phase one w ill be opened in April, 1993. 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 benefits 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 reglllations related to those programs. This internal control structure is subject to periodic evaluation by ma'1agement. Tests are made to determine the adequacy of the internal control structure, 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 fiscal year ended September 30, 1992, provided no significant violations ot 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 Councii. 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 any 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 p resents a summary of General Fund and Debt Service Fund revenues and other various financing sources for the fiscal year ended September 30, 1992. Comparisons to the previous fiscal year have been included. Fiscal Year Percent of Fiscal Year Increase Revenue Source Ended 9l30l92 Total Ended 9l30l91 (Decrease} General Fund Property Tax $1,376,970 7.10% $ 1,482,577 $ (105,607) Sales and Mixed Drink Tax 7,209,497 37.16 6,523,709 685,788 Franchise Tax 358,949 1.85 328,524 30,425 Licenses and Permits 216,886 1.12 116,574 100,312 Fines and Penalties 684,098 3.53 518,357 165,741 Charges for Services 720,068 3.71 540,096 179,972 Transfer from Enterprise Funds in Lieu of Taxes 3,889,872 20.05 3,772,060 117,812 Miscellaneous Revenues 577,129 2.97 553,079 24,050 Other Financing Resources 1,241,463 6.40 121,895 1,119,568 Debt Service Property Tax 3, 125,805 16.11 3,037,368 88,437 Total Revenues and Other Financing Sources $ 19,400,737 100.00% $ 16,994,239 $2,406,498 The most significant increase in actual revenue sources during 1992 was the increase in sales tax. Revenue was up in fiscal 1992 by 10.5% over 1991 with the opening of several new retail establishments during the year. These numbers reflect the continued strength in the commercial sector of the local economy. Fees relating to building and development activity were up $78,940 or 76.6%. Fines were also up $165,741 or 31.go/O over the previous year due to significant increased efforts in collection. Increased activity in parks programs and fee increases in ambulance services caused those revenues to increase by $179,972. Refunding of short term debt caused the fluctuation in the other financing resources category. REVENUES BY SOURCE GENERAL AND DEBT SERVICE FUNDS FISCAL YEAR 1992 $19,400,737 Other 19.58% Transfer in-lieu­ of taxes 20.05% - 7 - Property Tax 23.21% Sales Tax & Mixed Drink Tax 37.16% The following schedule presents a summary of General Fund and Debt Service Fund expenditures for the fiscal year ended September 30, 1992. As with t he revenue su mmary, comparisons to the previous fiscal year have been included. Fiscal Year Percent of Function Ended 9/30/92 Total Cur rent: General Government $ 5,507,360 28.00% Police 3,862,849 19.64 F ire 3,034,046 15.42 Public Services 2,108,406 10.72 Parks and Recreation 2,576,106 13.10 Less: Reimbursed Administrative Costs (2,591,911) (13.1 8) Debt Service: Principal 3,332,876 16.94 Interest and Fiscal Charges 1,510,729 7.68 Capital Outlay Other F inancing Uses Total Expenditures 329,269 1.68 0 0.00 $19,669,730 100.00% EXPENDITURES BY FUNCTION GENERAL AND DEBT SERVICE FUNDS FISCAL YEAR 1992 $19,669,730 Fiscal Year Ended 9/30/91 $ 4,723,549 3,491,656 2,833,455 1,940,697 2,269,977 (2,415,356) 2,206,493 1,464,946 602,976 720,546 $17,838,939 Capital Outlay General Government 1.673 (Net of Reimbursement) Debt Service 24.62% Parks and Recreation 13.10% Public Service 10.72% . 8. 14.82% Public Safety 35.06% I nc rease (Decrease) $ 783,811 371, 193 200,591 167,709 306,129 (176,555) 1,126,383 45,783 (273,707) (720,546) $1,830,791 General Fund Balance. The unrestricted fund balance of the General Fund increased by $80, 172 in 1992. This 3.3% 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 fiscal year 1992 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, 126,612,003 represents a 2.3% increase from fiscal year 1991. The increase was caused by the completion of three major grocery outlets and two major retail stores along with strong building activity in the single family residential sector. Distribution of property tax rates for the last five years is as follows: Purpose General Fund Debt Service Fund 1992 $.1225 .2775 1991 $.1325 .2675 1990 $.1 600 .2400 1989 $.1400 .2400 1988 $.0900 .2900 Utilitv Funds. The City of College Station operates electric, water, sewer, and solid waste services for the benefit of the citizens. On December 30, 1991 , the electric utility began purchasing 100% of its electric power from the Texas Municipal Power Agency ("TMPA") cities. Under the terms of the contract with TMPA, the City will be considered for participation as an equal member in future generation projects built by TMPA. The City is served through three 138 t<NA transmission lines tied to a ring bus at the City switching station, two substations , and 205 miles of distribution lines. Since 1981, t he City has had the capability to produce and deliver 100% of its water needs through development of its own water well and aqueduct 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 Lick 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, 1992, with comparison to the previous fiscal year, is as follows: Fiscal Year Fiscal Year Operating Revenues: Ended 9l30l92 Ended 9L30l91 Electric $27,320,323 $26,554,630 Water 5,190,561 4,702,612 Sewer 4,251,124 3,785,002 Solid Waste Collection 1,907,028 1,795,247 Other 794,321 538,396 Operating Expenses: Wholesale Purchased Power 18,637,583 19,072,974 Salaries and Benefits 4,057,429 3,807,573 Supplies, Maintenance and Services 3,759,369 4,120,041 Reimbursed Administrative 2,795,476 1,593,365 Depreciation 2,246,591 2,126,498 Other 181,519 234,586 Nonoperating Revenues (Expenses): Interest Earnings 1,336,480 1,748,132 Interest Expense (2,310,279) (2,445,468) Other, Net (307,751) 543,495 Transfer to General Fund In Lieu of Taxes (3,889,872) (3,821,539) Net Income $2,6 13,968 $2,445,470 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 res ponsible for meter reading, billing, and collections for more than 20,000 electric, water, sewer and solid waste collection accounts. During fiscal 1992, this fund recorded net income of $46,926, an in crease of $86,286 over the $39,360 net loss in fiscal year 1991. 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 em ployees electing dependent coverage. During fiscal 1992, the plan had a net income of $42,279, as compared to a net loss of $45,334 in fiscal 1991. Cost containment measures continue to be implemented. • 10. Debt Administration. As of September 30, 1992, the City had a total of $21,126,204 in General Obligation Bonds and Certificates of Obligation relating to Governmental Fund types. That debt, equal to $394 per capita , is serviced by revenues from the local property tax. U nder current state statutes, th e 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 $24,059,81 O 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 obligati ons of the City, and provides for the investment of funds in interest-bearing securities. Safety of the principal invested is always the primary concern. In 1988, the City began separating investment activities from the traditional banking services. Regular banking services are handled under a three-year depository agreement effective October 1 , 1991 with First American Bank. The City currently invests funds in the full range of investments allowable under state law. Accounts have been establis hed with major brokerages tor 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, 1992, the City's investment portfolio consisted of the following: Bank Demand Accounts State Investme nt Pool Insured Certificates of Deposit U.S. Government Obligations Government Agency Notes TOTAL $ 447,636 1,943,530 50,000 17,690,888 8,026,953 $28, 1 59,007 The City earned $2,377,852 on an average investment balance of approximately $30.5 million, a rate of return of 7. 79%, for the year ended September 30, 1992. Compared to prior years' earnings and a market benchmark, the City's investment yield was: 9.00% 8.54% 8.00% 7.00% 6.00% 5.00% 4.00% 3.00% 2.00% 1.00% 0.00% 1990 Actual I RATES OF RETURN I 8.50% 8.34% 1990 10-Bill Index 1991 Actual • 11 • 1991 10-Bill Index 1992 Actual 1992 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 t hree month and six month T­ Bills. This rolling index provides a benchmark for evaluating risk-free cash management portfolios with 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 ,990,605 were added to investment income, fiscal 1992 rate of return was approximately 14.32%. Risk Management. The City's insurance programs are administered by the Risk Management area of the Finance Department. The City's workers' compensation claims are handled by Old Republic Insurance Company. 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 ndependent Audit. State statutes require an annual audit by independent certified public accountants. The accounting firm of Ingram, Wallis & Company, P. C. 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-1 28. 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 Annual Financial Report for the fiscal year ended September 30, 1991 . 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 ten of the last eleven years. We believe our current report continues to conform to the Certificate of Achievement program requirements, and we are submitting it to GFOA. • 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, Ingram, Wallis & Company, P. C., 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 - �� ... Glenn Sc�r ------- 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, 1991 A Certificate of Achievement for Excellence in Financial Reporting is presented by the Government Finance Officers Association of the United States and Canada to government units and public employee retirement systems whose comprehensive annual financial reports (CAFRs) achieve the highest standards in government accounting and financial reporting . . • 14. APPOINTED BOARDS EXECUTIVE DIRECTOR FISCAL/HUMAN RESOURCES FINANCE BUDGET & EVALUATION ACCOUNTING/PAYROLL PURCHASING HUMAN RESOURCES RISK MAN AG�ME NT MUNICIPAL COURT CITIZENS OF COLLEGE STATION MAYOR AND CITY COUNCIL MUNICIPAL JUDGE CITY ATTORNEY CITY MANAGER ASSISTANT CITY MANAGER ASSISTANT CITY MANAGER CCJl4UNITY SERVICES GROUP OPERATIONS GROUP POLICE PUBLIC UTILITIES FIRE TECHNICAL SERVICES DEVELOPMENT SERVICES ELECTRIC SERVICES PUBLIC SERVICES WATER UTILITIES FLEET SERVICES WASTEWATER UTILITIES SOLID WASTE COLLE CT I ON PARKS & RECREATION LANDFILL OPERATION - 15 - CITY SECRETARY EXECUTIVE DIRECT MANAGEMENT SERVICES GROUP PUBLIC RELATIONS/ MARKETING MANAGMENT IN F OR MAT ION UTILITY BILLING SERVI CES FACILITIES MAINTENANCE ENERGY MANAGEMENT LIBRARY Elected Officials: C!JY OF COLLEGE STATION. TEXAS PRINCIPAL CITY OFFICIALS SEPTEMBER 30, 1992 Mayor ...................................................................................................... Larry J. Ringer Council Members .................................................................................... Fred H. Brown ....................................................................................................... Vernon E.Schneider ........................................................................................................... James R. Gardner ................................................................................................................. Nancy Crouch .......................................................................................................... Hubbard Kennady ....................................................................................................... � .. Lynn R. Mcllhaney City Administration: City Manager ............................................................................................. Ron Ragland Assistant City Manager for Community Services Group .......................................................... Thomas E. Brymer Assistant City Manager for Operati o ns Group .................................... John C. Woody Executive Director for Management Services Group ....................... Linda S. Piwonka Executive Director for Fiscal and Human Resources Group ........................................................... Glenn Schroeder Director of Development Services ............................................................ Elrey B. Ash Fire Chief ........................................................................................ William L. Ken nedy Director of Parks and Recreation ................................................... St ephen C. Beachy Personnel· Director ........................................................................... Karen N. Pavlinski Police Chief ....................................................................................... Edgar R. Feldman Director of Public Services .............................................................. Joseph D. LaBeau City Attorney ....................................................................................... Catherine Locke City Secretary ...................................................................................... Connie L. Hooks • 16. FINANCIAL SECTION • 17. • 18. James D. Ingram, III Thomas A. Wallis Agnes L. Bennett Judith W. Childs James 0. Ingram, IV Richard L. Webb Melanie M. Holshouser Sharon L. Pechal Wendi M. Stratta Pu-Yu (Peggy) Wang Joan M. Voneiff INGRAM, WALLIS & COMPANY A PROFESSIONAL CORPORATION Certified Public Accountants 2100 Villa Maria, Suite 100 BRYAN, TEXAS 77802 INDEPENDENT AUDITORS' REPORT Mayor Larry Ringer, Members of City Council and City Manager of the City of College Station, Texas TELEPHONE (409) 776-2600 TELECOPIER (409) 774-7759 We have audited the accompanying general purpose financial statements of the City of College Station, Texas ("City"), as of September 30, 1992, and for the year then ended, as 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. The financial statements of the City as of September 30, 1991 were audited by other auditors whose report dated December 23, 1991 expressed an unqualified opinion on those statements. 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 general purpose financial statement presentation. We believe that our audit provides a reasonable basis for our opinion. In our opinion, the general purpose financial statements referred to above present fairly, in all material respects, the financial position of the City of College Station, Texas, as of September 30, 1992, and the results of its operations and the cash flows of its proprietary and similar trust fund types for the year then ended in conformity with generally accepted accounting principles . • 19. our audit was made for the purpose of forming an opinion on the general purpose financial statements taken as a whole. The supplemental financial information listed in the foregoing table of contents is presented for purposes of additional analysis and is not a required part of the general purpose financial statements of the City of College Station, Texas. Supplemental financial information is also the responsibility of the City's management. Such supplemental financial information has been subjected to the auditing procedures applied in the audit of the general purpose financial statements and, in our opinion, is fairly presented in all material respects 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. Bryan, Texas January 22, 1993 • 20. CITY OF COLLEGE STATION. TEXAS COMBINED BALANCE SHEET--ALL FUND TYPES AND ACCOUNT GROUPS SEPTEMBER 30, 1992 (With comparative totals for the fiscal year ended September 30, 1991) Assets and Other Debits Assets: Equity in cash and Cash Equivalents (Note 2) Equity in I n ves t •en t s (Note 2) Receivables: Accrued Interest Grants Letter of Credit Accounts spec ia l As s ess•en t s Delinquent Property Taxes (Note 3) State Sales Tax (Note 1) Notes and Loans (No t e 4) Other Less Allowance for Unco l lec t1 ble Acc ounts Interfund Receivable Inventories Prepaid Cos t s Restricted Assets : Equity in cash and Cash Equivalents (Note 2) Equity in Invest•ents (Note 2) Receivables: Accrued Inte rest Accounts Notes and Loans (Note 13) Equity in Joint Venture (Note 1 3) Advance to Other Funds Deferred Charges, Net Property and Equip•ent, Ne t (Not e 5) Other Debits: A•ount Available for Retire•ent of Bonded Indebtedness A1ount to be Provided for: Accrued Vacation Leave Retire1ent of Bonded Indebtedness Total Assets General $ 196, 189 2,173,249 57,763 26, 113 25,000 1 69 ,25 6 201,609 92,775 571,689 63,781 133,637 (226, 164) 0 149,887 6,966 2, 119 73,4'79 2, 152 1 ,359 0 0 0 0 0 0 0 0 $3,720,859 • 22. Govern•ental Fund Types $ Specia l Re venue 137,988 834,074 23,202 61,518 25,4 25 7,298 0 0 0 204,439 0 (672) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $1 ,293,272 $ Debt Service 74,005 782,146 22,406 0 0 0 0 271, 158 0 562,056 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $1 I 711, 771 $ capital Projects 500,082 5,539,582 151 ,463 440,212 0 0 0 0 0 0 0 0 0 0 10,006 0 0 0 0 0 0 0 0 0 0 0 0 $6,64i ,345 Proprietary Fund Types Account Groups Totals !Me•orandu• Only! Internal General General Long. Enterprise Service Fixed Assets Ter• Debt 1992 1991 $ 606,098 $ 142,568 $ 0 $ 0 $ 1,656,930 $ 2,595,885 6,751,575 1,579,291 0 0 17 ,659,917 12,948,344 270,245 39,587 0 0 564,666 356,340 0 0 0 0 527,843 213,005 0 0 0 0 50,425 50,425 4,911,037 22,802 0 0 5,110,393 4,520,703 4,794 0 0 0 206,403 213,065 0 0 0 0 363,933 327,854 0 0 0 0 571,689 570,160 0 0 0 0 830,276 3,878,642 654 '578 0 0 0 788,215 645,689 (737,322) (175) 0 0 (964,333) (742,666) 153 ,393 0 0 0 153,393 0 1,218,513 532 0 0 1 ,368,932 1'349' 003 600 3,800 0 0 21 ,372 17,512 445,842 0 0 0 447 ,961 2,079,909 9,477 ,268 0 .o 0 9,550,747 10,424,640 189' 193 0 0 0 191,345 198,628 51,567 0 0 0 52,926 293 836,819 0 0 0 836,819 909' 137 350,038 0 0 0 350,038 631,260 1,168,279 0 0 0 1'168' 279 0 262,530 0 0 0 262,530 314,666 59,479,490 876,907 52,532, 161 0 112,888,558 106, 108,379 0 0 0 830,953 830,953 1,150,418 0 0 0 566 482 568,482 538,917 0 0 0 20,295,251 20,295,251 18,683,662 $86,094,537 $2,665,312 $52 I 532 I 161 $21 ,694,686 $176,353,943 $167,983,870 (Continued) • 23. CITY OF COLLEGE STATION, TEXAS COMBINED BALANCE SHEET--ALL FUND TYPES AND ACCOUNT GROUPS SEPTEMBER 30, 1992 (With comparative totals for the fiscal year ended September 30, 1991) (Continued) Govern11ental Fund T:z'.[!es Special Debt General Revenue Service Liabilities, Equity and Other Credits Liabilities: Accounts Payable $ 233,074 $ 46,963 $ 0 Retainage Payable 8, 109 15,344 0 Interfund Payable 0 0 0 Refundable Deposits 1,360 12,313 0 Claims Payable 0 0 0 Obligation Unde r Capital Lease--Current (Note 12) 0 0 0 Accrued Liabilities 274 ,241 5,507 47,604 Deferred Revenues--Foundation (Note 4) 0 0 0 Una•ortized Discount (Note 4) 0 0 0 Other Deferred Revenues 443,379 204,439 833,214 Liabilities Payable fro• Restricted Assets: Accounts Payable 0 0 D Accrued Interest Payable 0 0 0 Retainage Payable 0 0 0 Refundable Deposits 0 0 0 Revenue Bonds (Note 6) 0 0 0 General Obligation Bonds (Note 6) 0 0 0 certificates of Obligation (Note 6) 0 0 0 Long-Ter• 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 Advances fro• Other Funds 0 0 0 Accrued Vacation 0 0 0 Total Liabilities 960, 163 284,566 880,818 Equity and Other Credits: contributed Capital 0 0 0 Invest•ent in General Fixed Assets () 0 0 Retained Earnings (Deficit): Reserved 0 0 0 Unreserved 0 0 0 Fund Balances: Reserved (Note 15) 207,085 72,710 830,953 Unreserved: Designated for subsequent Years Expenditures 58' 152 297,796 0 Undesignated 2,495,459 638,200 0 Total Equity and Other Credits 2,760,696 110001706 830,953 Total Liabilities, Equity and Other Credits $3,720,859 $1,293,272 $1 I 7111 771 • 24. Capital Projects $ 437,752 74,042 0 0 0 0 373 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 512 167 0 0 0 0 846 ' 040 4,831,462 451 676 6, 129, 178 $6,641 ,345 Proerietar;i: Fund T;i:ee s Internal Entererise Service $ 4, 146,177 $125,249 0 0 153,393 0 0 0 0 478,098 451,982 0 269,441 16,967 0 0 0 0 26,730 0 282,524 0 331,986 0 1 2 8,3 27 0 1,898,082 0 2,375,000 0 370,795 0 26,200 0 19,355,000 0 1,775,615 0 157,200 0 1,826,479 0 0 0 1'168' 279 0 154,292 45 607 34,89 7,5 02 66 5 ,921 10,293,534 381,137 0 0 15' 180' 091 0 25,723,410 1,618,254 0 0 0 0 0 0 51, 197,035 1,999,391 $86,094,537 $2,665,312 Account General Fixed Assets $ 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 52,532, 161 0 0 0 0 0 52, 532, 161 $52 , 532, 161 Groues General Long- Ter• Debt $ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21'103 '590 22,61 4 0 0 0 568,482 21 ,694 ,686 0 0 0 0 0 0 0 0 $21,694,686 The notes to the financial state•ents are an integral part of this state•ent . . 25. Totals (Me•orandu• Onl:t:l 1992 1991 $ 4,989,215 $ 3,330,981 97,495 60,252 153 ,393 0 13,673 14,094 478,098 339,837 451 ,982 413,651 614,133 513,411 0 2' 105,566 0 89 4 ,434 1,507,762 1 ,5 18,4 19 282 ,524.· 282,531 331 ,986 369,541 128,327 107,634 1,898,082 1,919,104 2,375,000 2,475,000 370,795 376,235 26,2 00 26' 201 19,355,000 21'730,000 22,879,205 20,723,765 179,814 315, 126 1,826,479 2,278,462 0 1,125,000 1,168,279 0 768 381 719 161 59,895,823 61 ,63 8 ,405 1 0,674 ,671 10,674,672 52,532, 161 48,682,594 15, 180,091 15,303,69 7 27,341,664 2 2,894 ,9 09 1,956,788 1,544 ,4 36 5,187,410 3,352,706 3,585,335 3, 892, 451 116,458,120 106,345,465 $176,353,943 $1 67,983 ,87 0 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, 1992 (With comparative totals for the fiscal year ended September 30, 1991) 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 Reimbursed Expenses Other Total Revenues Ex pen di tu res: Current: General Government Fiscal and Human Resources Community Services: Administration Police Fire Development Services Parks Public Services Management Services Housing Rehabilitation Reimbursed Administrative Special Programs and Projects Public Agency Funding Economic Development Interi.11 Assistance Subrecipient Projects Clearance Other Capital Outlay Debt Service: Principal Retirement Interest Payments Fiscal Charges Bond Issuance Costa Total Expenditures General $ 8,952,041 216,886 32,000 720,068 684,098 4,682 199, 172 46,893 0 153 879 4,035 68,300 10,929,207 668,230 1,435,226 130,863 3,862,849 3,034,046 1 ,265,213 2,576, 106 2, 108,406 1,435,250 0 (2,591,911) 99,323 102,288 0 0 0 0 370,967 329,269 0 0 0 0 14,826, 125 Special Revenue $1, 123,931 0 714, 147 0 1535 0 70,356 72,948 8,580 8, 755 1, 175 0 4 014 2,004,541 0 0 0 0 0 0 0 0 0 368,596 428, 171 134,80C5 583,562 0 3, 155 5,056 14,954 5,412 59,616 0 0 0 0 1,603,328 Debt Service $3, 125,805 0 0 0 0 0 151,446 0 62,944 0 0 0 0 3,340, 195 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3,332,876 1,501,601 9,127 0 {Continued) • 26. $ Capital Projects 0 0 521,450 0 0 0 512,360 0 0 0 100,113 0 128 1!134,051 0 0 0 0 0 0 0 0 0 0 188,852 0 0 0 0 0 0 4,647 2,511,769 0 0 0 62,395 2, 767 ,663 1992 $13,201,777 216,886 1,267,597 720,068 684, 733 4,682 933,334 119,841 71,524 8,908 102, 167 4,035 72,442 17,407 ,994 668,230 1,435,226 130, 863 3,862,849 3,034,046 1,265,213 2,576, 106 2, 108,406 1,435,250 368,596 (1,974,888) 234, 129 685,850 0 3, 155 5,056 14,954 381,026 2,900,654 3,332,876 1,501,601 9, 127 62,395 24 ,040, 720 1991 $12,377,483 116,574 783,519 540,096 518,570 31,016 833,858 98, 739 8,581 10,548 51,422 712 67,343 15,438,461 627,086 1,404, 127 108, 160 3,491,656 2,833,455 1,149,666 2,269,977 1,940,697 1,258,472 256,997 {1,907,606) 183,390 668, 704 4, 146 2,119 0 42,240 72,973 2,969,219 2,206,493 1,454,260 10,686 30,562 21, 077, 479 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, 1992 (With comparative totals for the fiscal year ended September 30, 1991) (Continued) Totals Special Debt General Revenue Service Excess (Deficiency) of Revenues Over (Under) Expenditures $(3,896,918) $ 401 ,213 $(1 ,503,409) Other Financing Sources (Uses): Proceeds frOll Long-Term Debt 0 0 1,125,000 Sale of General Fixed Assets 57,519 0 0 Operating Transfers In (Note 11) 3,889,872 0 58,944 Operating Transfers Out (Note 11) 0 (3291897) 0 Total Other Financing Sources (Uses) 319471391 (3291897) 111831944 Excess (Deficiency) of Revenues and Other Financing Sources (Uses) Over (Under) Expenditures and Other Uses 50,473 71,3H5 (319,465) Fund Balances, October 1 217101223 9371390 111501418 Fund Balances, September 30 $217601696 s110081706 $ 8301953 The notes to the financial statements are an integral part of this statement . . 27. Capital Projects $(1 ,633,612) 3,500,275 0 270,953 0 317711228 2,137,616 319911562 $ 611291178 (Memorandum Onl�l 1992 $(6,632, 726) 4, 625, 275 57,519 4,219,769 (3291897) 815721666 1,939,940 817891593 $1017291533 $ 1991 $(5,639,018) 500,000 23,527 4, 164,428 (3421889) 413451066 (1,293,952) 1010831545 817891593 Revenues: Taxes licenses and Perm its Grants Charges for Services Fines, Forfeits, and Penalties Special Assessments I nterest on Investments Rents and Royalties Loan Proceeds Interest on Loans Contributions Other T ctal Revenues Expenditures: Current: General Ga-iernment Fiscal and Human Resources Community Services: Administration Police Fire Parks Development Services Public Services Management Services Nondepartmental: Interest Housing Rehabilrtation Reimbursed Administrative Special ProgramS/Projects Public� Funding Interim Assistance Clearance Code Enforcement Subredpient Projects Fleet Start-Up Costs Other Caprtal Outlay Expected Expenditure Savings Contingenc,y De� Service: Principal Interest and Fiscal Charges Bond Issuance C0615 T eial Expendttures Excess (Deficiency) a Revenues Over (Under) Expenditures Other Financing Sources (Usesj: Proceeds from Long Term Debt ISBUance Premium on Bonds Sold Operating Transfers In Operating Transfers Out Other T eial Other Financing Sources (Uses) Excess (Deficiency) a Revenues Over (Under) Expenditures and Other Financing Sources (Usesj Fund Balances, October 1 Fund Balances, Sef;tember 30 CITY OF COLLEGE STATION. IEXAS 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, 1992 General Fund Special ReYenue Funds Variance Favorable � � (Unfayorab!e) � � $8,884,221 $8,945,416 $ 61,195 $927,000 $1,123,931 107,090 216 ,886 109,796 0 0 28,220 32,000 3,780 1,390,358 714,147 736,080 720,067 (16,01 3) 0 0 536,000 684,098 148,098 0 635 20,000 4,682 (15,318) 0 0 303,800 192,907 (1 10,893) 26,800 70,356 48,200 46,893 (1,307) 50,500 72,948 0 0 0 0 8,580 0 0 0 0 8,755 2,000 910 (1,090) 0 1,175 41,200 64,951 23,751 35,000 4,014 10,706,811 10,908,810 201,999 2,429,658 2,004,541 679,532 668,229 11,303 0 0 1,509,878 1,435,227 74,651 0 0 131,096 130,864 232 0 0 4,097,956 3,863,752 234,204 0 0 3,093,769 3,034,048 59,721 0 0 2,614,628 2,576,725 37,903 0 0 1,341,524 1,319,098 22,426 0 0 2,378,968 2,108,405 270,563 0 0 1,469,307 1,437,119 32,188 0 0 0 0 0 0 0 0 0 0 411,111 368,596 (2,696, 166) (2,647,663) (48,503) 483,948 428,171 112,462 99,323 13,139 152,078 134,806 102,288 102,288 0 611,899 583,562 0 0 0 1,234 3,155 0 0 0 31,000 14,954 0 0 0 15,238 0 0 0 0 25,000 5,056 225,000 225,000 0 0 0 0 530 (530) 1,742 5,412 356.194 328,649 27,545 587,669 59,616 (790,340) 0 (790,340) 0 0 13,312 5,058 8,254 16,058 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 14,639,408 14,686,652 (47,244) 2,336,977 1,603,328 (3,932,597) (3,m,842) 154,755 92,681 401,213 0 0 0 0 0 0 0 0 0 0 3,889,900 3,889,872 (28) 0 0 0 0 0 (285,477) (329,897) 20,000 57,519 37,519 0 0 3,909 ,900 3,947,391 37 ,491 (285,477) (329,897) (22,697) 169,549 192,246 (192,796) 71,316 3, 132,458 2,797,540 (334,918) 894,249 937,390 $3,109,761 $2,967,089 $ (142,672) $701,453 $1,008,706 • 28. Variance Favorable !!.infii!YQ!i!�I $196,931 0 (676,211) 0 635 0 43,556 22,448 8,580 8,755 1,175 (30,986) (425, 117) 0 0 0 0 0 0 42,515 55,777 17,272 28,337 (1 ,921) 16,046 15,238 19,944 0 (3,670) 528,053 0 16,058 0 0 733,649 308,532 0 0 (44,420) 0 (44,420) 264,1 12 43,141 $ 307,253 Debi Se1vioe Fund Capital Projects Funds Variance Variance Favorable Favorable l1imi &na fUnlayqab!el l1imi &na l!.!afavorablel $3,129,550 $3,125,805 $(3 ,7 45) $ 0 $ 0 $ 0 0 0 0 0 0 0 0 0 0 500,000 521,450 21,450 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 135,000 114,876 (20,124) 136,200 512,360 376,160 0 0 0 0 0 0 0 62,945 62,945 0 0 0 0 36,570 36,570 0 0 0 0 0 0 100,0000 100,113 113 0 0 0 0 128 128 3,264,550 3,340,196 75,646 736,200 1,134,051 397,851 0 . 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o. 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 4,647 (4,647) 0 0 0 0 0 0 0 0 0 221,090 188,852 32,238 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 7,021,784 2,511,769 4,510,015 0 0 0 0 0 0 0 0 0 0 0 0 2,304,601 3,335,694 (1,031,093) 0 0 0 1,570,182 1,511,311 58,871 0 0 0 0 0 0 0 62,395 (62,395) 3,874,783 4,847,005 (97z,222) 7,242,874 2,767,663 4,475,211 (610,233) (1,506,809) (896,576) (6,506,674) (1,633,612) 4,873,062 0 1,125,000 1,125,000 3,788,202 3,500,000 (288,202) 0 0 0 0 275 275 58,946 58,944 (2) 226,500 270,953 44,453 0 0 0 0 0 0 0 0 0 0 0 0 58,946 1,183,944 1,124,998 4,014,702 3,771,228 (243,474) (551,287) (322,865) 228.� (2,491 ,97 2) 2,137,616 4,629,588 1,142,876 1,150,418 7,542 3,892,237 3,991,562 99,325 s 591,589 $ 827,553 $235,964 $1,400,265 $6,129,178 $4,728,913 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, 1992 (With comparative totals for the fiscal year ended September 30, 1991) Totals (Me•orandu• Only! Operating Revenues: Charges for Services Premiu•s Other Total Operating Revenues operating Expenses: Purchased Power (Note 8) Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Ad•inistration Fees C laia s Pre•iUH Rei1bursed Ad•inistrative Depreciation and A•ortization Other Total Operating Expenses Operating Inco•e (Loss) Nonopersting Revenues (Expenses): Interest Earnings Other Interest Earnings Rei•bursed Expenses Contributions Earnings in Joint Venture (Note 13) Interest Expense Other, Net Total Nonoperating Revenues (Expenses) Inco•e (Loss) Bef ore Operating Transfers Ent erpri s e $ 38,669,036 0 794 321 18, 637' 583 4,057,429 338,787 606' 162 459,974 1,626,676 727' 770 0 0 0 2,795,476 2,246,591 181 519 31 ,677,967 7,785,390 1,336,480 0 86,561 1, 530 19,807 (2,310,279) (415,649) (1 ,281 ,550) 6,503,840 (Continued) • 30. Internal Serv i c e $ 3,311,465 2,368,844 0 5,680,309 0 1,138,452 107,826 82, 251 12,858 33,938 104' 105 118, 723 1,307,812 587,880 401,088 167,844 475 4,063,252 1,617,057 108,038 0 5,635 0 0 (7,608) (13,942) 92 J 123 1J709J180 1992 $ 41,980,501 2,368,844 794 321 45, 143,666 18,637,583 5,195,881 446,613 688,413 472,832 1 ,660,614 831,875 118' 723 1,307,812 587 ,880 3, 196,564 2,414,435 181 994 35,741,219 9,402,447 1,444,518 0 92, 196 1 ,530 19,807 (2,317,887) (429,591) (1J189,427) 8 ,213 ,020 1991 $ 38,482,066 2,041 ,02 9 551 219 41 074 314 19,072,974 4,831 ,096 397,755 633,757 1,326,203 1,553,889 492,007 103,048 1,327,319 662,591 1,907,606 2,218,270 238 311 34,764,82 6 6,309,488 1, 716,243 76,817 82,640 7,832 409,543 (2,445,468) 38 249 (114 I 144) 6 195 344 CITY OF COLLEGE STATION, TEXAS COMBI NED STATEMENT OF REVENUES, EXPEN SES AND CHANGES IN RETAINED EARNINGS (DEFICIT) ALL PROPRIETARY FUND TYPES For the Fiscal Year Ended September 30, 1992 (With comparative totals for the fiscal year ended September 30, 1991) (Continued) Totals (Me1orandu1 Onl�l Internal Enterprise service 1992 1991 Operating Transfers Out $ (3,889,872) $ 0 $ (3,889,872) $ (3,821,539) Total Operating Transfers out (3,889,872) 0 (3,889,872) (3,821 ,539) Net Inco1e 2,613,968 1. 709. 180 4 ,323,1 4 8 2 ,373 ,805 Retained Earnings, October 1 38 ,289 ,533 (90,926) 38,198,607 35,824,801 Retained Earnings, September 30 $ 4019031501 $ 1,618,254 $ 42,521,755 $ 38, 198 , 606 The notes to the financial state1ents are an integral part of this state1ent . • 31 • CITY OF COLLEGE STATION. TEXAS COMBINED STATEMENT OF CASH FLOWS ALL PROPRIETARY FUND TYPES FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 (With Co m parat ive Totals for the Fiscal Year Ended September 30, 1991) Totals (Memorandum Only) E nterprise Internal Service Funds Funds 1992 1991 Cash Flows from Operating Activities: Cash Received from Customers $39,006,323 $5,657,916 $44,664,239 $41,661,692 Cash Payments to Suppliers for Goods and Services (23,809, 773) (2, 693, 7 47) (26,503,520) (26,686,840) Cash Payments to Employees for Services (4,019,579) (1,132,538) (5, 152, 117) (4, 798, 115) Other (513) (180) (693) 10,157 Net Cash Provided by Operating Activities 11, 1 76,458 1,831,451 13,007,909 10,186,894 Cash Flows from Noncapital Financing Activities: Operating Transfers Out to Other Funds (3,889,872) 0 (3,889,872) (3,821,539) Contribution to Fleet Replacement Fund (321,630) 0 (321,630) 0 Cash Received from Customer Prepayments 733 0 733 0 Cash Provided (Used) by Other Noncapital Financing Activities (30,100) (15,9 1 6) (46,016) 216,206 Net Cash Used by Noncapltal Financing Activities (4,240,869) (15,916) (4,256, 785) (3,605,333) Cash Flows from Capital and Related Financing Activities: Acquisition and Construction of Capital Assets (4,800,477) (749,946) (5,550,423) (5,684,095) Proceeds -Sale of Capital Assets 57,735 0 57,735 15,000 Principal Paid on Revenue Bonds (2,475,000) 0 (2,475,000) (2,415,000) Principal Paid on General Obligation Bonds (376,235) 0 (376,2 35) (377,765) Principal Paid on Certificates of Obligation (26,200) 0 (26,200) (26,200) Principal Paid on Obligation Under Capital Lease (413,652) 0 (413,652) f378,849) Interest Paid on Revenue Bonds (1,972,978) 0 (1,972,978) (2,086,420) Interest Paid on General Obligation Bonds (118,973) 0 (118,973) (138,618) Interest Paid on Certificates of Obligation (25,1 52) 0 (25,152) (28,296) Interest Paid on Obligation Under Capital Lease (179,347) 0 (179,347) (214, 151) Proceeds from Revenue Bonds 0 0 0 4,800,000 Proceeds from Advance from Other Funds 1,321,672 0 1,321,672 0 Cash Received from Capital Grants 0 0 0 3,999 Cash Received from Special Assessments 2,092 0 2,092 0 Net Cash Used for Capital and Related Financing Activities (9,006,515) (749,946) (9,756,461) (6,530,395) Cash Flows from Investing Activities: Advance to Other Funds (1,321,672) 0 (1,321,672) 0 Cash Distribution from Joint Venture 301,029 0 301,029 0 Purchase of Investments (13,272,008) (2, 751,628) (16,023,636) (16,316,593) Proceeds from Sale and Maturities of Investments 12,879,609 1,652,787 14,532,396 16, 143,681 Interest on Investments 1,361,076 79,498 1,440,574 1,717,948 Net Cash Provided By (Used for) Investing Activities (51,966) (1,019,343) (1,071,309) 1,545,036 (Continued) • 32. CITY OF COLLEGE STATION. TEXAS COMBINED STATEMENT OF CASH FLOWS ALL PROPRIETARY FUND TYPES FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 (With Comparative Totals for the Fiscal Year Ended September 30, 1991) (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 Activities: 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 Other Receivables Change in Inventory Change in Prepaid Costs Change in Accounts Payable Change in Accrued Liabilities Change in Due to J oin t Venture Change in Accrued Vacation Total Adjustments Net Cash Provided by Operating Activitie s Enterprise Funds $(2, 122,892) 3, 174,832 $1,051,940 $ 7,785,390 2,250,769 95,658 (457,034) 0 7,605 0 1,449,894 29,427 0 14,749 3,391,068 $11,176,458 The notes to the financial statements are an integral part of this statement. • 33. Internal Service Funds $ 46,246 96,322 $1 42,568 $1,617,057 167,844 175 (22,573) 0 (532) 20 (74,624) 139,177 0 4,907 214,394 $1,831,451 Totals (Memorandum Only) 1992 $(2,076,646) 3,271,154 $1,194,508 $9,402,447 2,418,613 95,833 (479,607) 0 7,073 20 1,375,270 168,604 0 19,656 3,605,462 $13,007,909 1991 $1,596,202 1,674,952 3,271, 154 $6,309,488 2,222,099 258,658 1,153,703 (566,032) 125, 128 221,455 780,793 (189,772) (135,772) 7,146 3,877,406 $10,186,894 CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES The financial statements of the City of College Station, Texas ("City"), have been prepared in conformity with generally accepted accounting principles (GAAP) as applied to government units. The Governmental Accounting Standards Board (GASS) is the accepted standard-setting body for establishing governmental accounting and financial reporting principles. The more significant of the City's accounting policies are described below. A. REPORTING ENTITY 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 the 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 is then submitted for approval by both cities as a part of their regular budget process. -35 - CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(Continued) 8. FUND ACCOUNTING The City uses funds and account groups to report on its financial position and results of operations. Fund accounting is designed to demonstrate legal compliance and to aid financial management by segregating transaction s 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 contro ll ed . An account group, on the other hand, i s 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 pay m ent 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 ma nner 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, 1992 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(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 account 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 account 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 obligation and accrued vacation leave. C. BASIS OF ACCOUNTING The accounting and financial reporting treatment applied to a fund is determined by its measurement focus. All governmental funds are accounted for using a current financial resources measurement 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 p ropriet ary 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 i nc reases 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 reven ues 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 lia bi lity 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 F I NANCI AL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 1. SUMMARY OF SIGNIFICANT ACCOUNTI NG POLICIES-(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 r evenues are accrued. D. POWER COST RECOVERY The City is allowed to recover purchased power costs as power cost adjustments. This power cost recovery allow s for the pass-through of power costs to the customers and has no impact on net income. The amount of any under 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 finan cing 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 fu nd 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 C ity 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 - CITY OF COLLEGE STATION, TEXAS NOTES TO G ENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(Continued) The General Fund budget is adopted on a basis that differs from GAAP, as follows: (a) The City does not include in General Fund budgetary amounts revenue or expenditure activity for the Fireman's Relief Fund or the Cemetery Perpetual Care Fund which are combined with the General Fund for reporting purposes. (b) General Fund bu dgetary amounts do not include provisions for adjustments in inventory , the allowance for uncollectible accounts receivable, or the capitalization of salaries for capital improvements projects. Adjustments necessary to convert the General Fund revenues at September 30, 1992, on the GAAP basis to the bu dg etary basis are as follows: Revenues and Other Financing Sourc es -GAAP basis R econcili n g Items: Cemetery Perpetual Care Fund Revenues Fireman's Relief Fund Revenues Other Total Reconciling Items Total R evenu es and Other Financing Sources -Budget (Non-GAAP Basis) $14,876,598 (19,015) (3,804) 2.422 (20.397) $14,856,201 Adjustments necessary to convert the General Fund expenditures at S eptember 30, 1992, on the GAAP basis to the budgetary basis are as follows: Expen ditures and Other Financing Uses-GAAP Basis R ec onc iling Items: Fireman's Relief Fund Expenditures Inventory Adjustment Allowance for Uncollectible Accounts Capitalized Salaries Other Total Reconciling Items Total Expenditures and Other Financing Uses -Bu dget (Non -GAAP B as is) -39 - $14,826, 125 (3,273) (11,669) (125,437) 899 7 (139,473) $14,686.652 CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(Continued) B ud gets for the Special Revenue Funds, Debt Service F u nd, and Capital P rojects Funds ar e ad opted on a basis consiste nt 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 E l ectric , Water and Sewer Funds, are treated as expenses for budgetary purposes. (c) The budget considers princi pal 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 depreciation on E nterpris e Fund property and equipment. (f) Budgeted revenue amounts do not include a provision for revenue accruals. The budget for the I nternal Service Funds are adopted on a basis consistent with. GAAP, except for the following sig nifi cant items: (a) Capital outlay is included in the budget as an expense item. (b} The City does not budget for depreci ati on on Internal Service Funds fixed assets. B ud getary com parisons presented in the report are on the aforementioned budgetary basis. Budgetary amounts are as originally adopted, or as amended by the City Council. I ndividual amendments were not material in relation to the original appropriations which were amended. -40 - CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(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 in significant 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. Treasu ry and Agency securities, bank certificates of deposit, and investments in public funds investments pools (TexPool). 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 C ity 's name in a safekeeping account at First City N ational 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. Thi s 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, 1992 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 inventori es are recorded 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, 1992, 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 bal ance 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 comp r ised of Municipal Court cash bonds, cemetery perpetual care funds and fireman's relief funds, all of whi ch 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 purc h ases 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 thei r estimated fair market value. Public dom ai n 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 COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 1. SUMMARY OF SIGNIFICANT ACCOUNTI NG POLICIES-(Continued) 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 over the following estimated service lives: Utility Systems Buildings and Improvements Equipment M. COMPENSATED ABSENCES 25- 40 years 5 -50 years 3 -10 years Employees are credited with vacation at. rates of· 1 O to 15 days per year, depending upon length of service. Carryover 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 financial 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 financial resources are reported in the General Long-Term Debt Account Group. Employees are credited with sick leave at the rate of one day per month and are allowed to accumulate up to 120 days. Payment for unused accumulated Sick leave is not made to employees by the City and, accordingly, no liability has·been recorded in the financial statements. N. LONG-TERM OBLIGATIONS Long-term debt is recognized as a liability 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 such obligations are reported in the General Long-Term Debt Account Group. Long,term liabilities directly related to andfinancedJrom 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. ENCUMBRANCES 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 ty j:>es. Encumbrances outstanding at year end are reported as reservations of fund balances since 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, 1992 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(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 expenditu re 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 expenditures 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. I nterfund 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. I nterfund eliminations have not been made in the aggregation of this data. U. COMPARATIVE DATA 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. -44 - CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 2. DEPOSITS AND INVESTMENTS At year-end, the carrying amount of the City's cash and time deposits was $2, 104,891, and the bank balance was $2,666,0n. The City also had investments in the state investment pool amounting to $1,943,530, 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, 1992, are as follows: Unrestricted cash and cash equivalents Restricted cash and cash equivalents $ 1,656,930 447,961 $ 2,104,891 The bank balance and certificate of deposit were entirely 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, 1992, 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 $ 18,718,216 $ 19,188,513 Government Agency Notes 8,492,448 8,379,408 Total Investments $ 21.210.664 $ 27.567.921 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, 1992, was $.40 per $100 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 STATI ON, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 3. PROPERTY TAXES-(Continuecl) 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 for bonds and other contractual obligations adjusted for new improvements, exceeds the rate for the previous year 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 RECE IVABLE General Fund: During 1986, the City sold land valued at $943,894 to the CSEDF (see Note 1). In exchange for this land, 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 was 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 $204,439 balance in the Special Revenue Funds represents the outstanding principal for these loans at September 30, 1992. Debt Service Fund: During 1991, the City 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, 1992 A summary of changes in general fixed assets for the year ended September 30, 1992, is as follows: Beginning Balance Land $ 5,089,038 Buildings and Building Improvements 13,031,574 Improvements 14,103,419 Machinery, Tools and Equipment 10,000,811 Parks System 5,826,944 Construction in Progress 630,808 Total $48,682,594 Additions and Transfers In $1,810,330 0 167,339 680,464 448,717 2,579,014 $5,685,864 Retirements and Transfers Out $ 0 0 0 487,514 0 1,348,783 $1,836,297 Ending Balance $ 6,899,368 13,031,574 14,270,758 10, 193,761 6,275,661 1,861,039 $52,532, 161 A summary of proprietary fund type property and equipment at September 30, 1992, is as follows: Combined Solid Waste Utility Collection Fund Fund Electric System $21,396,666 $ 0 Water System 27,812,282 0 Sewer System 19,920,864 0 Machinery & Equipment 1,620,588 2,345,657 Buildings & Improvements 1,623,308 0 Land 944,250 0 Construction in Progress 4,450,705 0 Total 77,768,663 2,345,657 Less Accumulated Depreciation (19,702,238) (932,592) Net $58,066,425 $1,413,065 Fleet Replacement Fund $ 0 0 0 715,994 0 0 0 715,994 (57,589) $658,405 • 47. Utility Billing $ Fund 0 0 0 541, 161 0 0 0 541,161 (350,038) $191, 123 Landfill Fund $ 0 0 0 34,378 0 0 0 34,378 (6,999) $27,379 Total $21,396,666 27,812,282 19,920,864 5,257,778 1,623,308 944,250 4,450,705 81,405,853 (21,049,456) $60,356,397 CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 6. LONG-TERM DEBT The following is a summary of long-term debt transactions for the year ended September 30, 1992: Beginning Incurred/ Matured/ Balance Issued Retired Governmental Fund T��s General Obligation Bonds $18,5n,355 $4,625,000 $2,098,765 Certificates of Obligation 131,725 0 109, 111 Contractual Obligations 1,125,000 0 1,125,000 Accrued Vacation Leave 538,917 493,874 464,309 Subtotal 20,372,997 5,118,874 3,797,185 Progrieta!Y Fund T�R§§ Utility Revenue Bonds 24,205,000 0 2,475,000 General Obligation Bonds Serviced by Utility Revenues 2,522,645 0 376,235 Certificates of Obligation Serviced by Utility Revenues 209,602 0 26,202 Accrued Vacation Leave: Electric Fund 66,568 65,739 60,948 Water Fund 24,010 31,856 26,975 Sewer Fund 30,686 33,741 30,112 Solid Waste Fund 18,279 20,324 18,876 Landfill Fund 9,520 6,223 5,926 Utility Billing Collection Fund 31, 181 34,343 29,734 Obligations Under Capital Lease-(Note 12) 2,692,113 0 413,652 Subtotal 29,809,604 192,226 3,463,660 Total Long-Term Debt $50, 182,601 $5,311, 100 $7,260,845 - 48 - Ending Balance $21, 103,590 22,614 0 568,482 21,694,686 21,730,000 2, 146,410 183,400 71,359 28,891 34,315 19,727 9,817 35,790 2,278,461 26,538,170 $48,232,856 CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 6. LONG-TERM DEBT-(Continued) Long-term debt at September 30, 1992, consisted primarily of bonds maturing serially and is summarized as follows: Interest Series Principal Rates(%) Matures Balance General Obligation Bonds: 1968 Issue 4.40 -6.00 1995 $ 100,000 1976 Issue 4.00 -6.00 1997 375,000 19781 Issue 4.70 -6.00 1998 193,500 197811 Issue 5.15 -5.80 1999 1,070,000 1982 Series II Issue 9.00 -11.00 1993 475,000 1984 Issue 9.50 -11.00 1995 1,350,000 1987 Refunding Issue 4.50 -7.70 2004 8,090,090 1988 Refunding Issue 6.15 -8.15 1996 2,000,000 1989 Issue 6.50 -8.50 2005 2,825,000 1991 Issue 5.50 -7.50 2012 4,625,000 Subtotal 21,103.590 Certificates of Obligation: Ladder Truck 60% of Prime 1993 22,614 Utility Revenue Bonds: 1985 Refunding Issue 6.00-9.50 2001 17,030,000 1990 Issue 6.50-8.50 2006 4,700,000 Subtotal 21,730,000 General Ob ligation Bonds Serviced by Utility Revenues: 1976 Issue 4.00-6.00 1997 1,125,000 19781 Issue 4.70 -6.00 1998 881,500 1987 Refunding Issue 4.50 -7.70 2004 139,910 Subtotal 2,146,410 Certificates of Obligation Serviced by Utility Revenues: Utility Service Center 12.00 1999 183,400 Total $45,186.014 - 49 - CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 6. LONG-TERM DEBT-(Continued) Debt service requirements to maturity for all long term debt is summarized as follows: Year 1993 1994 1995 1996 1997 1998-2002 2003-2007 2008-2012 Total Year 1993 1994 1995 1996 1997 1998-2002 2003-2006 Total Year 1993 1994 1995 1996 1997 1998-2002 2003-2006 Total General Obligation Bonds Principal $2,089,205 1,986,045 1,856,130 3,058,735 1,714,075 6,424,955 2,724,445 1.250,000 $ 21!103,590 . Interest $ 1,387,112 1,231,347 1,088,804 917,863 758,759 2,249,463 690,356 179.063 $ 8.502.767 Certificates of Obligation Serviced by Utility Revenues Principal Interest $ 26,200 $ 22,008 26,200 18,864 26,200 15, 720 26,200 12,576 26,200 9,432 52,400 9,432 ���-:.0 0 $ 183,400 $ 88,032 General Obligation , Bonds Services by Utility Revenues Principal Interest $ 370, 795 $ 99,263 378,955 79,305 378,870 59,076 386,265 40,271 385, 925 22,882 230,045 20, 179 15,555 1!192 $ 2. 146,410 $ 322. 168 • 50. Certificates of Obligation Principal Interest $ 22,614 $ 1,601 0 0 0 b 0 0 0 0 0 0 0 0 ���-:.0 0 $ 22.614 $ 1 .601 Utility Revenue Bonds Principal $ 2,375,000 2,325,000 2,405,000 2,505,000 2,475,000 7,845,000 1.800,000 $21 ,730,000 Interest $ 1,769,820 1,567,845 1,360,185 1,141,588 917,900 1,875,469 247,000 $ 8,879,807 CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 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 interest income and expense, �nd 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 bonds and other indebtedness payable from those revenues and 1.25 times the maximum annual debt service on all revenue bonds and other indebtedness payable from those revenues. The maximum annual debt service is defined as the maximum principal and interest 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 interest 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 refunding 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, 1992, the outstanding principal balance of these defeased revenue refunding bonds was $20, 175,000. At September 30, 1992, the outstanding principal balance of the defeased general obligation bonds and certificates of obligation was $7,375,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, 1992 8. CONTRACTS WITH GULF STATES UTILITIES AND THE TEXAS MUNICIPAL POWER AGENCY The City negotiated a new contract and began purchasing 100% of its electrical power requirements from the Texas Municipal Power Agency ("TMPA") on December 30, 1991. Under this contract, TMPA shall initially provide the City with 11 O MW of electrical power at the following rates: Demand Charge Energy Charge $11.78 per KW $ 2.00 per MWH The contract also includes a provision for consideration of the City as an equal member in the future generation projects built by TMPA. Prior to December 30, the City purchased substantially all its electrical power requirements from Gulf States Utilities. The City's monthly electrical bill averaged $1,553, 132 during the year. 9. RETIREMENT PLAN Plan Description The City provides pension benefits for all of its full-time employees through a nontraditional, joint contributory, defined contribution plan in the state-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 better 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 establishment 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. The plan provisions are adopted by the City Council within the options available in the state statutes governing TMRS and within the actuarial constraints also in the statutes. • 52 • . CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 9. RETIREMENT PLAN-(Continued) Contribution Requirements The contribution rate for the employees is 5% of covered payroll, and the City's matching percent is currently 200% (calendar year 1992), both as adopted by the City Council. 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, 1992. The : :nit 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, 1992, was $14,370,094, and the City's contributions were based on a payroll of $13,792,527. Both the City and the covered employees made the required contributions, amounting to $878,349 (6.44% of covered payroll for the months in calendar year 1991, 5.22% normal cost plus 1.22% to amortize the unfunded actuarial liability, and 6.35% for the months in calendar year 1992, 5.21% normal cost plus 1.14% to amortize the unfunded actuarial liability) for the City and $689,686 (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 1992 by 0.09% 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 (GASS 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 payable 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 COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 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 service to date are not dependent upon future salaries. The calculations were made as part of the annual actuarial valuation as of December 31, 1991. 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 114.1 % of book value as of December 31 , 1991 . The total unfunded pension benefit obligation at December 31, 1991, 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 1991 $ 1,415,819 1,257,092 5,412,440 5,639,407 2.097,876 15,822,634 13.710,302 $2.112.332 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 $211,988 . • 54. CITY OF COLL EGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 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 information concerning this plan is presented below. Complete trend information prior to 1987 is unavailable. Additional historical trend information will be presented as it becomes available. Year Ended December 30 1987 1988 1989 1990 1991 Year Ended December 30 1987 1988 1989 1990 1991 Year Ended December 30 1987 1988 1989 1990 1991 Net Assets Available for Benefits $ 7,299,624 8,806,929 10, 123,841 11,509,969 13,710,302 Unfunded Pension Benefit Obligation $ 2,553,147 2,242,546 2,347,262 2,390,149 2,112,332 Employer Contributions $ 680,759 652,444 730,712 822,349 878,349 . 55. Pension Benefit Obligation $ 9,852,771 11,049,475 12,471,103 13,900,118 15,822,634 Annual Covered Payroll $12,861,559 11,028,053 11,949,309 12,971,271 13,792,527 Employee Contributions $ 643,995 551,417 597,473 648,573 689,686 Net Assets Available as a Percent of Pension Benefit . Obligation 74% 80% 81% 83% 87% Unfunded Pension Benefit Obligation as a Percentage of Annual Covered Payroll 20% 20% 20% 18% 15% Employer Contributions as a Percentage of Annual Covered Payroll 5.3% 5.9% 6.1% 6.3% 6.4% CITY OF COLL EGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 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 for such benefits if they reach normal retirement age while working for the City. The health care benefits are provided through a self-insurance plan administered by Donovan Benefi t Systems (see Note 14). During fiscal year 1992, 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, 1992, is as follows (amounts in thousands): Solid Waste Electric Water Sewer Collection Fund Fund Fund Fund Total Operating Revenues: $27,860 $5,319 $4,345 $1,939 $39,463 Operating Expenses (Excluding Depreciation and Amortization) 22,368 2,650 2,445 1,968 29,431 Depreciation and Amortization 726 750 526 245 2,247 Net Operating Income (Loss) 4,766 1,919 1,374 (274) 7,785 Operating Transfers, Net (2,670) (617) (454) (149) (3,890) Net Income (Loss) 2,387 312 400 (485) 2,614 Property and Equipment Additions 1,593 328 1,564 1,326 4,811 Net Working Capital 9,584 (1,641) 777 66 8,786 Total Assets 33,850 27,658 21,729 2,858 86,095 Bonds and Other Long-Term Liabilities - Excluding Current Portion 5,380 10,445 7,424 1,188 24,437 Total Equity $23,378 $13,416 $12,925 $1,478 $51,197 . 56. CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 11. OPERATING TRANSFERS Individual fund operating and other transfers out and corresponding operating transfers in for fiscal 1992 were as follows: Operating Transfers Out Operating Transfers In Hotel Motel Hotel Motel Solid Waste Collection Electric Wat.er Sewer 12. COMMITMENTS AND CONTINGENCIES Debt Service GOB 1982 Series II General General General General Amount $ 58,944 270,953 149,100 2,670,192 616,980 453,600 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. 1993 1994 1995 1996 1997 1998-2001 Total minimum lease payments Less imputed interest Present value of net minimum lease payments Total $ 592,999 592,999 293,586 250,813 250,813 762.192 2,743,402 (464,941) $ 2,278,461 The City is contingently liable for lawsuits and other claims in the ordinary course of its operat.ions. 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, 1992. 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, 1992 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 1992 was $19,807. 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 $765,525 in 1992. The following is a summary of information from the audited financial statements of BVSWMA as of September 30, 1992, and 1991 . Assets Current Assets Property, Plant and Equipment (Net of $439,954 Accumulated Depreciation at 1992 and $214,495 at 1991) Other Assets Total Assets Liabilities Current Liabilities Notes Payable -Noncurrent Accrued Post Closure Maintenance Costs 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 1992 $1,163,119 2,456,823 175,834 $3,795,n6 $ 460,282 2,084,664 1,076,270 3,621,216 170,200 4,360 174,560 $3,795,n6 $2,090,251 1,993,006 97,245 (58,430) $ 38,815 • 58. 1991 $1,944,896 1,941,910 185,834 $4,072,640 $ 401,806 2,333,031 600,000 3,334,837 170,200 567,603 737,803 $4,072,640 $1,929,757 1,579,416 350,341 (56,172) $ 294,169 CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 13. JOINT VENTURE (Continued) Debt: Current Long Term Total 14. RISK MANAGEMENT $ 248,367 2,084,664 $2,333,031 $ 230,834 2,333,031 $2,563,865 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 Old Rep ublic Insurance Company. The City has a stop-loss insurance policy that limits its liability per employee to $500,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, 1992, 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 Funds: Reserved for Encumbrances Reserved for Prepaids Total Special Revenue Funds Reserved Debt Service Fund -Reserved for Debt Service Capital Projects Funds: Reserved for Encumbrances Reserved for Prepaid Costs Total Capital Projects Fund Reserved Total - 59 - $ 122,885 73,764 6,966 3.470 207,085 62,710 10,000 72.710 830,953 836,034 10.006 846,040 $1 ,956,788 CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 16. DEFICIT RETAINED EARNINGS/FUND BALANCES At September 30, 1992, the Employee Benefits, Property and Casualty, and Utility Billing Funds had deficit unreserved retained earnings. In addition, the Capital Equipment Fund had a deficit unreserved fund balance of $22,810. The $88,439 deficit in the Employee Benefits Fund resulted from higher than expected claims. In fiscal 1994 the City plans to increase 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 $69,936 deficit in the Property and Casualty Fund can be attributed to higher than expected claims expense. The City has reevaluated the amounts charged each fund for property and casualty insurance in an effort to eliminate this deficit. The $85,934 deficit in the Utility Billing Fund can be traced to 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 allowed for partial recovery of these prior year expenses so that the deficit can be eliminated. Future budgets will allow for complete elimination of this deficit. The $22,81 O deficit in the Capital Equipment Fund was a result of expenditures for capital projects made prior to the issuance of debt to finance capital projects. 17. INTERFUND ASSETS/LIABILITIES On September 30, 1992, the Electric Fund loaned $1,321,672 to the Solid Waste Fund for. the purchase of automated garbage trucks and containers. The loan is payable in semi-annual installments beginning March 30, 1993, and ending September 30, 1999, and accrues interest at a rate of 6.75%. The current portion of the loan is recorded as an interfund receivable and payable in the Electric Fund and Solid Waste Fund, respectively. The noncurrent portion is recorded as an Advance to and Advance from in the Electric Fund and Solid Waste Fund, respectively. 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 Parks Escrow Community Development Capital Equipment GOB 1991 Electric Water Sewer Employee Benefits Landfill Property and Casualty Workers' Compensation • 60. Amount $ 530 483 34,906 5,108 4,647 62,395 2,503 126,459 10,066 23,584 10,030 74,843 4,732 CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 18. EXPENDITURES/EXPENSES IN EXCESS OF APPROPRIATIONS (Continued) The $530 excess in the General Fund was a result of recording an inventory adjustment which was not included in the budgetary amounts. The $483 excess in the Hotel/Motel Fund was a result of unbudgeted miscellaneous expenditures, and the majority of the $34,906 excess in the Parks Escrow Fund resulted from unbudgeted capital outlay expenditures. The $15, 108 excess in the Community Development Fund occurred as a result of higher than expected interim assistance and miscellaneous costs. Unbudgeted bond issuance costs were responsible for $62,395 excess in the GOB 1991 Bond Fund. Higher than expected purchased professional services and unbudgeted fiscal agent's fees were responsible for the $2,503 excess in the Electric Fund. Unbudgeted interest expense, special programs and projects costs, and fiscal agent's fees resulted in the $126,459 excess in the Water Fund. The $10,066 excess in the Sewer Fund resulted from unbudgeted special programs and projects costs and fiscal agent's fees and a higher than expected principal payment. Excess expenses were largely responsible for the $23,584 excess in the Employee Benefits Fund, while the $101,030 excess in the Landfill Fund was largely due to excess expenses for salaries and benefits and unbudgeted interest expense. The Property and Casualty Fund recorded a $19,367 excess in budgeted claims expense and a $55,476 excess due to unbudgeted reimbursed administrative costs. Higher than expected administration fees resulted in the $4, 732 excess in the Workers' Compensation 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 ano ther 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, 1992 Taxes: Current Property Delinquent Property Tax Penalty and Interest General Sales Mixed Drinks Franchise Total Taxes Licenses and Per•its: Mixed Drinks Game Machines Professional/Occupational Oil and Gas Builders Per•its Electrical Per•its Plu•bing Per•its Other Total Licenses and Per•its Grants Charges for Services: Parks Concessions Pool Admissions Sports Instruction Sports Programs Special Events Teen center Other Parks Fingerprinting Police Reports and Records Checks Arrest Fees Warrant Service Fees Police Escort Services False Alar•s EMS Transport Hazardous Materials Response Fire Inspections Other Fire Street sweeps and Repairs Budget $ 1,338,711 39,010 17,000 7,060,000 72,000 357,500 8,884,221 10,000 2,400 2,550 0 56,000 9,300 26,800 40 107,090 28,220 80' 100 69,900 68, 100 127,150 i7,500 900 16,200 5,000 20,000 47,500 16,200 8,000 16,500 163,300 5,000 3,000 0 27,000 Actual $ 1 ,337,501 24,413 15,056 7' 128,294 81,203 358 J 949 8,945,416 11,343 1 ,393 22' 101 2,436 123,231 19,645 35,230 1 507 216,886 32,000 72,308 91 ,406 64,850 144,392 14,040 2,329 2,248 957 6,992 2,470 643 2,125 13,050 248,490 820 1 ,944 8 3,900 (Continued) • 64. Variance Favorable (Unfavorable) $ (1,210) (14,597) ( 1'944) 68,294 9,203 1 449 61 I 195 1 ,343 (1,007) 19,551 2,436 67,231 10,345 8,430 1 467 109 796 3 780 (7,792) 21,506 (3,250) 17 ,242 (3,460) 1 ,429 ( 13 '952) (4,043) ( 13 '008) (45,030) (15,557) (5,875) (3 ,450) 85' 190 (4' 180) (1 ,056) 8 (23' 100) 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, 1992 (Continued) Variance Favorable Budget Actual (Unfavorable) Municipal Court $ 25,000 $ 25,689 $ 689 General Govern•ent 17' 130 18,892 1 '762 Other 2,600 2 514 (86) Total Charges for Services 736,080 720,067 ( 16 I 013) Fines, Forfeits and Penalties: Municipal Court Fines 535,000 683,078 148,078 Other Fines and Penalties 1 000 1 020 20 Total Fines, Forfeits and Penalties: 536,000 684,098 148,098 Special Assess•ents 20,000 4 682 (15,318) Use of Money and Property: Interest 303,800 192,907 (110,893) Rents and Royalties 48,200 46,893 (1,307) Interest on Loans 4 700 153 (4,547) Total Use of Money and Property 356,700 239,953 (116,747) Miscellaneous: Contributions 2,000 910 ( 1'090) Rei•bursed Expenditures 0 4,035 4,035 Other 36,500 60 763 24,263 Total Miscellaneous 38,500 65,708 27,208 Total Revenues 10,706,811 10,908,810 201 ,999 Other Financing Sources: Pay•ents in Lieu of Taxes 3,889,900 3,889,872 (28) Sale of General Fixed Assets 20,000 57 519 37 519 Total Other Financing sources 3,909,900 3,947,391 37 491 Total General Fund Revenues $14,616,711 $14 ,856,201 $ 239,490 • 65. CITY OF COLLEGE STATION. TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1992 Budget Actual General Govern•ent: Mayor and Council: Supplies $ 6,365 $ 6,361 Maintenance 40 36 Other Purchased services 140 130 Capital Outlay 30,512 30 474 Total Mayor and Council 37,057 37,001 City Secretary: Salaries and Benefits 86,361 86,347 Supplies 3,459 3,213 Maintenance 1 ,291 1 ,284 Purchased Property Services 1,376 1,155 Other Purchased services 27,730 26,205 Capital Outlay 7 770 7 764 Total City Secretary 127,987 125 ! 968 City Manager: Salaries and Benefits 154,769 154,756 Supplies 6,210 6, 187 Maintenance 160 133 Purchased Professional Services 4,800 500 Purchased Property Services 1 ,450 650 Other Purchased Services 28,904 25,636 Capital Outlay 1 ,558 0 Total City Manager 197,851 187,862 Legal: Salaries and Benefits 276,895 276,794 Supplies 16' 181 16, 173 Maintenance 630 527 Purchased Professional Services 6,497 6,303 Purchased Property Services 2,530 2,400 Other Purchased services 23,232 22,965 Capital Outlay 603 603 Total Legal 326,568 325,765 Total General Govern•ent 689,463 676,596 (Continued) . 66. Variance Favorable (Unfavorable) $ 4 4 10 38 56 14 246 7 221 1 ,525 6 2 019 13 23 27 4,300 800 3,268 1 558 9 989 101 8 103 194 130 267 0 803 12 867 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL(BUDGETARY BASIS) For the Fiscal Year En d ed September 30, 1992 (Continued) Budget Actual Fiscal and Hu•an Resources: Finance Ad•inistration: Salaries and Benefits $ 177,812 $ 177,080 supplies 4,580 4,249 Maintenance 320 203 Purchased Professional Services 1 ,400 1 ,350 Purchased Property Services 1 ,280 783 Other Purchased Services 16,997 16,918 capital Outlay 3 100 3 094 Total Finance Ad•inistration 205,489 203,677 Hu•an Resources: Salaries and Benefits 170,006 169,988 Supplies 12,810 12,791 Maintenance 300 262 Purchased Professional Services 5,800 5,764 Purchased Property Services 1,920 1 ,525 Other Purchased Services 35,674 28,615 Capital Outlay 9 343 7 862 Total Hu•an Resources 235,853 226,807 Accounting: Salaries lU'ld Benefits 287,953 284,222 Supplies 11,415 11 '401 Maintenance 1'610 1 ,200 Purchased Professional Services 118,545 110' 032 Purchased Property Services 3' 125 2,734 Other Purchased Services 67 ,849 55,373 Capital Outlay 2 875 2,872 Total Accounting 493,372 467,834 Purchasing and Stores: Salaries and Benefits 145,985 143,596 Supplies 5,702 4,236 Maintenance 2,380 1 ,254 Purchased Professional Services 8,200 7,220 Purchased Property Services 3,430 2,944 Other Purchased Services 21'157 20,333 Capital Outlay 2,622 2 618 Total Purchasing and Stores 189,476 182,201 (Continued) • 67. Variance Favorable (Unfavorable) $ 732 331 117 50 497 79 6 1 812 18 19 38 36 395 7,059 1 481 9 046 3,731 14 410 8,513 391 12,476 3 25,538 2,389 1,466 1'126 980 486 824 4 7 275 CITY OF COLLEGE STATION. TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGET ARY BASIS) For the Fiscal Year Ended September 30, 1992 (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 Capital Outlay Total Municipal Court Total Fiscal and Hu•an Resources Budget $ 132,241 1'850 770 500 830 10,730 2 736 149,657 165' 574 6,220 1 ,695 39,335 16,200 27,683 65, 125 321,832 1,595,679 (Continued) • 68. Actual $ 113,844 1,828 758 4 788 10,721 2 736 130,679 165,564 5,090 992 39,331 14' 187 18 '047 64,887 308,098 1,519,296 Variance Favorable (Unfavorable) $ 18,397 22 12 496 42 9 0 18 978 10 1'130 703 4 2,013 9,636 238 13 734 76 383 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1992 (Continued) Co11unity Services Ad 1inistration: Salaries and Benefits Supplies Maintenance Purchased Property Services Other Purchased services Capital Outlay Total Co11unity Services Ad1inistration Police: Police Ad1in1strat1on: Salaries and Benefits Supplies Maintenance Purchased Professional services Purchased Property Services Other Purchased Services Capital Outlay Total Police Ad1inistration Unifor1 Patrol: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capit al Outlay Total Unifor1 Patrol Cri1inal Investigation: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Total Cri1inal Investigation Budget $ 112,546 1 ,640 90 480 16,340 110 131,206 347,234 8,600 1,300 7,296 120 30,619 824 395,993 1 '773 ,989 70,017 36,840 20,568 1,330 154,444 36 241 2,093,429 434,220 12,960 1o,120 16,730 3,760 30,230 508,020 (Continued ) • 69. Actual $ 112,540 1 ,627 36 416 16,245 0 130,864 347,174 5,704 1,168 6,370 115 27,229 824 388,584 1, 755,077 61,376 33,889 19,644 454 150,795 30,596 2,051 ,831 369,340 10,807 8,565 16,702 1,700 28,626 435,740 variance Favorable (Unfavorable) $ 6 13 54 64 95 110 342 60 2,896 132 926 5 3,390 0 7 409 18,912 8,641 2 ,951 924 876 3,649 5 645 41 598 64,880 2, 153 1, 555 28 2,060 1 604 72 280 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1992 (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 Total Technical Services Communications/Jail: Salaries and Benefits Supplies Maintenance Purchased Professional Services Other Purchased Services Capital Outlay Total Communications/Jail Total Police Budget $ 229,232 22,410 3,310 45, 135 370 31,293 11 z 554 343,304 227,075 15,530 42,916 72,250 33 I 127 390,898 369,965 13,950 9, 776 3,700 17' 540 1 ,300 416,231 �.147,875 (Continued) . 70. Actual $ 222,053 16,725 2, 183 45,126 145 29,492 10,633 326,357 212,458 11,849 31,375 55,270 27,915 338,867 329,238 10,224 7,283 1,269 16,412 988 365,414 3,906,793 Variance Favorable (Unfavorable} $ 7' 179 5,685 1, 127 9 225 1, 801 921 16 947 14, 617 3 ,681 11 l 541 16,980 5 212 52 031 40,727 3,726 2,493 2,431 1'128 312 50 817 241 ,082 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGET ARY BASIS) For the Fiscal Year Ended September 30, 1992 (Continued) Fire: Fire Administration: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay 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 services Purchased Property Services Other Purchased Services Total Emergency Medical Services Total Fire Budget $ 334,750 4, 118 2,340 355 8,360 22,635 3,883 376,441 2,449,184 45,985 43,418 5,775 29,085 34,754 46,369 2,654,570 0 12,750 3,350 200 16,317 32,617 0 17,320 7' 100 6,000 400 49,573 80,393 3 ! 144 t 021 (Continued) • 71 • Actual $ 334,653 3,712 2,285 186 6, 153 22,591 3,863 373,443 2,415,933 42,624 40,844 5,633 26,757 31,619 45,568 2,608,978 (638) 12,054 2,320 185 15,885 29,806 ( 1I571) 16, 174 6,309 6,000 391 43,949 71 ,252 3,083,479 Variance Favorable (Unfavorable) $ 97 406 55 169 2,207 44 20 2,998 33,251 3 ,361 2,574 142 2,328 3' 135 801 45,592 638 696 1, 030 15 432 2 811 1, 571 1, 146 791 0 9 5 624 9 141 60 542 CITY OF COLLEGE STATION. TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1992 (Continued) Development Services: Development 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 Professional services Purchased Property 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 175,093 5,366 3,679 3,050 14,579 8,942 210,709 261,722 6,445 2,095 14,900 1 ,620 30 ,391 3,554 3201727 703,606 23,030 8,735 10,730 9,920 66,563 20,377 8421961 1,3741397 (Continued) -72- Actual $ 173,238 4,899 2,787 2,366 13,847 81757 2051894 261,709 6,076 2,083 14,885 1, 612 30,367 3,554 320,286 700,211 20,042 5,749 5,423 9,477 64,327 101898 8161127 113421307 Variance Favorable (Unfavorable) $ 1, 855 467 892 684 732 185 4 815 13 369 12 15 8 24 0 441 3,395 2,988 2,986 5,307 443 2,236 9 479 26,834 321090 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1992 (Continued) Public Services: Public Services Administration: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Capital Outlay Total Public Services Administration 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 Property Services Other Purchased Services Total Drainage Maintenance Fleet Services: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property 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 $ 183' 134 $ 183,099 4,300 4,294 1, 860 1 ,407 16,490 16,477 12,486 12,115 980 936 219,250 218,328 494,260 492,340 29,550 29,502 680,690 450,203 19' 750 6,535 21,280 21,273 143,618 139,587 51150 51138 113941298 1,144,578 109,563 109,552 3,219 3,213 12' 100 12,079 4,080 4 ,074 301201 291893 1591163 158,811 385,780 384,656 35, 947 35,382 8,870 8,841 175 175 13,385 12,456 23,732 22,641 81270 71809 4761159 4711960 99,385 94,088 3' 180 2,382 31'123 21,995 7,210 7,200 790 541 21810 21405 1441498 128.611 2,393,368 2 .122. 288 (Continued) . 73. Variance Favorable (Unfavorable) $ 35 6 453 13 371 44 922 1,920 48 230,487 13,215 7 4 ,031 12 2491720 11 6 21 6 308 352 1 '124 565 29 0 929 1'091 461 4 199 5,297 798 9, 128 10 249 405 15.887 2711000 CITY OF COLLEGE STATION. TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1992 (Continued) Parks: Parks Ad•inistration: Salaries and Benefits Supplies Maintenance Purchased Property services Other Purchased Services Total Parks Ad•inistration Recreation: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services 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 $ 243,529 6,660 2,260 2,030 28,088 282,567 335,482 65, 150 4,620 84,110 92,120 43,582 625,064 408,572 52,371 53,545 8,570 114, 735 39,084 8 704 685,581 532,414 34,050 68,970 3,330 86,260 37,932 14,300 777,256 210,278 8, 198 18,449 400 13, 133 16,706 15 160 282,324 2,652,792 (Continued) • 74. $ Actual 243 ,5.26 6,48.4 1 ,826 1,531 26,94 6 280,313 335,296 63,867 2,976 82,974 91,897 43,496 620,506 406,260 50,749 52,772 8,230 114,346 37,588 7 854 677,799 525,760 33,292 66,487 2,994 84, 772 37,903 14 296 765,504 209,389 6,563 15,680 0 7,788 15,333 12,216 266,969 2,611 ,091 Variance Favorable (Unfavorable! $ 3 176 434 499 1 142 2 254 186 1,283 1 ,644 1'136 223 86 4 558 2,312 1,622 773 340 389 1,496 850 7 782 6,654 758 2,483 336 1 ,488 29 4 11 752 889 1 ,635 2,769 400 5,345 1 ,373 2 944 15 355 41 701 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1992 (Continued) Bud get Actual Manaoe•ent Services: Manage•ent services Ad•inistration: Salaries and Benefits $ 100,358 $ 100,334 Supplies 1,220 1,203 Maintenance 90 73 Purchased Property Services 380 375 Other Purchased Services 9,950 9,930 Capital Outlay 220 217 Total Management Services Administration 112,218 112,132 Public Relations: Salaries and Benefits 152' 174 152, 100 Supplies 4,765 4,613 Maintenance 7,223 6,995 Purchased Property Services 1'130 91 4 Other Purchased Services 22,178 21 ,024 Capital Outlay 1 061 1 061 Total Public Relations 188,531 186,707 Energy Manage•ent Services: Salaries and Benefits 191,257 189,9 1 1 Supplies 19, 732 19,247 Maintenance 86,885 86, 185 Purchased Professional Services 319,974 315,617 Purchased Property Services 121, 190 1 09,824 Other Purchased Services 24,981 20,7 69 Capital Outlay 62,050 59,878 Total Energy Manage•ent Services 826,069 801 ,431 Manage•ent Infor•ation Services: Salaries and Benefits 260,180 252,552 Supplies 3,750 3,672 Maintenance 116,005 115,966 Purchased Property Services 5,456 5,417 Other Purchased Services 20,429 20,398 Capital Outlay 11 413 11 127 Total Manage•ent Infor•ation Services 417,233 409, 132 Total Manage•ent Services 1,544,051 1,509,402 Nondepart•ental: Special Progra•s and Projects 112 ,462 99,323 Public Agency Funding 102,288 102,288 Fleet Start-Up Costs 225,000 225,000 Inventory Loss 0 530 Contingency 13,312 5,058 Expected Expenditure Savings (790,340) 0 Total Nondepart•ental (337,278) 432, 199 Subtotal 17,335,574 17,334,315 Less Rei•bursed Ad•inistrative (2, 696, 166) (2,647,663) Total General Fund Expenditures $14,639,408 $14,686,652 • 75. Variance Favorable (Unfavorable) $ 24 17 17 5 20 3 86 74 152 228 216 1'154 0 1 824 1 ,346 485 700 4,357 11,366 4,212 2 172 24,638 7,628 78 39 39 31 286 8 101 34 649 13' 139 0 0 (530) 8,254 (790,340) (769,477) 1 259 (48,503} $ (471244) • 76. SPECIAL REVENUE FUNDS Special revenue funds are used to account for specific revenues that are legally restricted to expenditures 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 Se�tember 30, 1992 (With comparative totals for he fiscal year ended September 30, 1991) Totals Community Hotel/Motel Parka Development Tax Escrow 1992 1991 Assets Equity in Cash and Cash Equivalents $ 62,6Sl3 $ 53,086 $ 22,20SI $ 137,988 $ 148,314 Equity in Investments 0 588,052 246,022 834,074 739, 796 Receivables: Accrued Interest 0 16,317 6,885 23,202 9,602 Grants 61,518 0 0 61,518 83,553 Letter of Credit 0 0 25,425 25,425 25,425 Accounts 602 6,696 0 7,298 1,507 Loans 204,43SI 0 0 204,439 17Sl,842 Less Allowance for Uncollectible Accounts 0 (672) 0 (672) (188) Total Assets $ 329,252 $ 663,479 $ 300,541 $ 1 ,293,272 $ 1t187,851 Liabilities and Fund Balances Liabilities: Accounts Payable $ 35,921 s 11,042 $ 0 $ 46,963 $ 39, 105 Retainage Payable 13,971 0 1,373 15,344 16,627 Refundable Oeposits 0 12,313 0 12,313 11,305 Accrued Liabilities 5, 107 400 0 5,507 3,582 Deferred Revenues 204,439 0 0 204 ,439 179,842 Total Liabilities 259,438 23, 755 1 373 284,566 250,461 Fund Balances: Reserved for Encumbrances 61,389 1,321 0 62,710 1,450 Reserved for Prepaids 0 0 10,000 10,000 0 Unreserved: Designated for Subsequent Years• Expenditures 8,425 203 289, 168 297, 796 341,686 Undesignated 0 638,200 0 638,200 594,254 Total Fund Balances 69,814 639, 724 29SI, 168 1,008,706 937,390 Total Liabilities and Fund Balances $ 329,252 $ 663,479 $ 300,541 $ 1,293,272 $ 1, 1871851 . 78. CITY OF COLLEGE STATION1 TEXAS SPECIAL REVENUE FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES (With For the Fiscal Year Ended September 30, 1992 comparative totals for the fiscal year ended September 30, 1991) Community Development Revenues: Taxes $ 0 Grants 714, 147 Fines, Forfeit• and Penalties 12 Interest on Investments 1 ,241 Rents and Royalties 0 Loan Proceeds 8,580 Interest on Loans 8, 755 Contributions 0 Other 2 424 Total Revenues 735, 159 Expenditures: Current: Housing Rehabilitation 368,596 Reimbursed Adlninistrative 212,884 Special Programs and Projects 0 Public Agency Funding 101 ,562 Economic Development 0 Interim Assistance 3, 155 Planning 5,056 Clearance 14,954 Other 3, 187 Capital Outlay 24 710 Total Expenditures 734, 104 Excess of Revenues Over Expenditures 1 ,055 Other Financing Sources (Uses): Operating Tranef ere Out 0 Other Transfer• 0 Total Other Financing Sources (Uses) 0 Excess (Oeficiency) of Revenues Over Expenditures and Other Financing Sources(Usas) 1,055 Fund 8alances, October 1 68,759 Fund Balances, September 30 $ 69,814 Hotel/Motel Parke Tax Escrow $ 1, 123,931 $ 0 0 0 623 0 47,019 22,096 72,948 0 0 0 0 0 1, 175 0 1 590 0 1,247,286 22,096 0 0 215,287 0 134,80!5 0 482,000 0 0 0 0 0 0 0 0 0 2,225 0 0 34 ,90!5 834,318 34,90!5 412,968 (12,810) (329,897) 0 0 0 (329,897) 0 83,071 (12,810) 556,653 311 ,978 $ 6391724 $ 29911158 • 79. $ $ Totals 1992 1, 123,931 714, 147 635 70,356 72,948 8,580 8,755 1'175 4 014 2,004,541 368,596 428, 171 134' 80!5 583,562 0 3, 155 5,056 14,954 5,412 59,616 1,603,328 401,213 (329,897) 0 (329, 897 ) 71,316 937,390 110081700 1991 $ 1,005,305 607,270 213 71,877 53,1586 8,581 7,656 0 11 472 1, 766,0!50 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) 299, 164 129,275 492,753 444 637 $ 9371390 CITY OF COLLEGE STATION. TEXAS COMMUNITY DEVELOPMENT FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET ANO ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 Revenues: Grants Fines, Forfeits, and Penalties Interest Earnings Loan Proceeds Interest on Loans Other Total Revenues Expenditures: Current: Housi ng Rehabilitation Reimbursed Administrative Public Agency Funding Interim Assistance Clearance Code Enforcement Subrecipient Projects Other Capital Outlay Total Expenditures Excess of Revenues Over Expenditures Fund Balance, October 1 Fund Balance, September 30 Budget Actual $1,390,358 $714, 147 0 12 0 1,241 0 8,580 0 8,755 35,000 2,424 1,425,358 735, 159 411,111 368,596 224,200 212,884 129,899 101,562 1,234 3,155 31,000 14,954 15,238 0 25,000 5,056 0 3,187 587,669 24,710 1,425 ,351 734, 104 7 1,055 0 68,759 $ 7 $ 69,814 • 80. Variance Favorable (Unfavorable) $(676,211) 12 1,241 8,580 8,755 (32,576) (690, 199) 42,515 11,316 28,337 (1,921) 16,046 15,238 19,944 (3, 187) 562,959 691,247 1,048 68,759 $ 69,807 CITY OF COLLEGE STATION. TEXAS HOTEL/MOTELTAXFUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 Revenues: Taxes Fines, Forfeits, and Penalties Interest Earnings Rents and Royalties Contributions Other Total Revenues Expenditures: Current: Reimbursed Administrative Special Programs and Projects Public Agency Funding Other Contingency 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 Fund Balance, September 30 • 81 • Budget Actual $ 927,000 $1, 123,931 0 623 26,800 47,019 50,500 72,948 0 1, 175 0 1,590 1,004,300 1,247,286 259,748 215,287 152,078 134,806 482,000 482,000 1,742 2,225 16,058 0 911,626 834,318 92,674 412,968 285,447 329,897 (192,773) 83,071 446,430 556,653 $ 253,657 $ 639,724 Variance Favorable (Unfavorable) $ 196,931 623 20,219 22,448 1, 175 1,590 242,986 44,461 17,272 0 (483) 16,058 77,308 320,294 (44,450) 275,844 110,223 $ 386,067 CITY OF 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, 1992 Variance Favorable Budget Actual (Unfavorable) Revenues: Interest Earnings $ 0 $ 22,096 $ 22,096 Total Revenues 0 22,096 22,096 Expenditures: Capital Outlay 0 34,906 (34,906) Total Expenditures 0 34,906 (34,906) Excess (Deficiency) of Revenues Over/(Under) Expenditures 0 (12,810) (12,810) Fund Balance, October 1 311,978 311,978 0 Fund Balance, September 30 $311,978 $299, 168 $(12,810) • 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 II 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 11 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 Se rie s 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, 1992 (With comparative totals for the fiscal year ended September 30, 1991) Assets Equity in Cash and cash Equivalents Equity in Invest•ents Receivables: Accrued Interest Grants Prepaid Costs Total Assets Liabilities and Fund Balances Liabilities: Accounts Payable Retainage Payable Miscellaneous Accrued Liabilities Total Liabilities Fund Balances: Reserved: Reserved for Encu•brances Reserved for Prepaids unreserved Designated for: Drainage Projects General Govern•ent Projects Parks Projects Streets Projects Traffic Signalization Projects Unreserved Undesignated Total Fund Balances Total Liabilities and Fund Balances • 84. Capital Equip•ent $ 0 0 0 157,302 0 $ 157,302 $ 178,923 0 0 178,923 1'188 0 0 0 0 0 0 (22,809) (21 ,621) $ 157 ,302 1982 Series II Bond $ 124 '675 1,381,067 40,413 274,247 10,006 $ 1,830,408 $ 239,309 65,233 373 304,915 532,498 10,006 0 380,002 134,820 61,812 70,986 335,369 1,525,493 $ 1 ,830,408 1984 8ond $ 21,525 238,448 4,957 0 0 $ 264,930 $ 6,402 7,736 0 14 138 139,883 0 110,909 0 0 0 0 0 250,792 $ 264,930 1989 Bond 1991 Bond $ 121 ,086 $ 232,796 1 ,341 ,312 2,578,755 36 ,351 69,742 0 8,663 0 0 $ 1,4981749 $ 2,8891956 $ 3,880 $ 9,238 0 1,073 0 0 3,880 10 311 56,032 106,433 0 0 0 0 24,862 0 99,315 410,352 1,175,544 2,362,860 0 0 139,116 0 1,494,869 2,879,645 s 114981749 $ 218891956 s s $ $ 1992 500,082 5,539,582 151,463 440,212 10 006 616411345 437,752 74,042 373 512, 167 836,034 10,006 110,909 404,864 644,487 3,600,216 70,986 451 ,676 6, 129, 178 616411345 . 85. Totals 1991 $ 670,738 3,345,665 76,771 119,515 0 $ 412121689 $ 185,611 35,516 0 221,127 155,784 0 271,667 418,113 957,698 1,305,390 0 882,910 3,991,562 $ 412121689 CITY OF COLLEGE STATION, TEXAS CAPITAL PROJECTS FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES For the Fiscal Year Ended September 30, 1992 (With comparative totals for the fiscal year ended September 30, 1991) Revenues: Grants Interest on Investments contributions Other Total Revenues Expenditures: current: Reimbursed Administrative Public Agency Funding Other Capital Outlay Debt Service: Bond Issuance Costs Total Expenditures Excess (Deficiency) of Revenues over (Under) Expenditures Other Financing Sources (Uses): Proceeds from Long Term Debt Issuance Sale of Long Term Debt 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 Equipment $ 157,302 0 0 0 157,302 0 0 4,647 361, 167 0 365,814 (208,512) 0 0 0 0 0 0 (208,512) 186 891 $ (21 I 621 ) 1982 Series II Bond $ 355,485 142, 189 100,113 0 597 787 57,957 0 0 1,369,607 0 1 ,427,564 (829,777) 0 0 270,9 53 0 0 270,953 (558,824) 2 ,084 ,317 $ 1 ,525,493 $ 1984 Bond 0 1 6,6 18 0 128 16 746 33,601 0 0 4,020 0 37 621 (20,875) 0 0 0 0 0 0 (20,875) 271 667 $ 250,792 Totals 1989 Bond 1991 Bond 1992 1991 $ 0 $ 8,663 $ 521 ,450 $ 158,334 115,532 238,021 512,360 362,081 0 0 100' 113 50,000 0 0 128 990 115,532 246,684 1, 134,051 571 405 18,171 79, 123 188,852 149,519 0 0 0 0 0 0 4,647 32,575 167,200 609,775 2,511, 769 2,343' 136 0 62,395 62,395 30,562 185,371 751,293 2,767,663 2,555,792 (69,839) (504,609) ( 1 I 633 I 61 2 ) (1,984,387) 0 3,500,000 3,500,000 500,000 0 275 275 0 0 0 270,953 294 ,ooo 0 0 0 (173,000) 0 0 0 421 ,382 0 3,500,275 3,771,228 1,042,382 (69,839) 2,995,666 2,137,616 (942,005) 1 ,564,708 ( 116,021) 3,991,562 4,933,567 $ 1 ,494,869 $ 2,879,645 $ 6, 129, 178 $ 3,991 ,562 • 87. CITY OF COLLEGE STATI ON , 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, 1992 Variance Favorable Budget Actual (Unfavorable} Revenues: Grants $ 0 $157,302 $157,302 Interest 0 0 0 Total Revenues 0 157,302 157,302 Expenditures: Interest 0 4,647 (4,647) Capital Outlay 675, 184 361,167 314,017 Total Expenditures 675, 184 365,814 309,370 Excess (Deficiency) of Revenues Over/(Under) Expenditures (675, 184) (208,512) 466,672 Other Financing Sources: Proceeds From Long Term Debt Issuance 288,202 0 (288,202) Total Other Financing Sources 288,202 0 (288,202) Excess of Revenues Over Expenditures and Other Financing Sources (386,982) (208,512) 178,470 Fund Balance, October 1 192,237 186,891 (5,346) Fund Balance, September 30 $ (194,745) $ (21,621) $173,124 • 88. CITY OF COLLEGE STATION. TEXAS 1982 SERIES II BOND FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 Revenues: Grants Interest Contributions Total Revenues Expenditures: Current: Reimbursed Administrative Capital Outlay Total Expenditures Excess (Deficiency) of Revenues 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 Fund Balance, September 30 • 89. Budget Actual $ 500,000 $ 355,485 0 142, 189 100,000 100, 113 600,000 597,787 70,540 57,957 1,479,000 1,369,607 1,549,540 1,427,564 (949,540) (829,777) 226,500 270,953 226,500 270,953 (723,040) (558,824) 1,250,000 2,084,317 $ 526,960 $1,525,493 Variance Favorable (Unfavorable) $ (144,515) 142, 189 113 (2,213) 12,583 109,393 121,976 119,763 44,453 44,453 164,216 834,317 $ 998,533 CITY OF COLLEGE STATION. TEXAS 1984 BOND FUND SCHEDULE OF REVENU ES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 Revenues: Interest Other Total Revenues Expenditures: Current: Reimbursed Administrative Capital Outlay Total Expenditures Excess (Deficiency) of Revenues Over/(Under) Expenditures Fund Balance, October 1 Fund Balance, September 30 • 90. Budget Actual $ 0 $ 16,618 0 128 0 16,746 35,000 33,601 400,000 4,020 (435,000) 37,621 435,000 (20,875) 450,000 271,667 $ 15,000 $ 250,792 Variance Favorable (Unfavorable) $ 16,618 128 16,746 1,.399 395,980 397,379 414, 125 (178,333) $ 235,792 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, 1992 Revenues: Interest Total Revenues Expenditures: Current: Reimbursed Administrative Capital Outlay Total Expenditures Excess (Deficiency) of Revenues Over/(Under) Expenditures Fund Balance, October 1 Fund Balance, September 30 Budget Actual $ 0 $ 115,532 0 115,532 21,582 18, 171 1,936,600 167,200 1,958, 182 185,371 (1, 958, 182) (69,839) 2,000,000 1,564,708 $ 41,818 $1,494,869 • 91 • Variance Favorable (Unfavorable) $ 115,532 115,532 3,411 1,769,400 1,772,811 1,888,343 (435,292) $1,453,051 CITY OF COLLEGE STATION. TEXAS 1991 BOND FUND SCHEDULE OF REVENUES, EXPENDITURES ANO CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 Revenues: Grants Interest Total Revenues Expenditures: Current: Reimbursed Administrative 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 Fund Balance, September 30 • 92. Budget Actual $ 0 $ 8,663 136,200 238,021 136,200 246,684 93,968 79,123 2,531,000 609,775 0 62,395 2,624,968 751,293 (2,488, 768) (504,609) 3,500,000 3,500,275 3,500,000 3,500,275 1,011,232 2,995,666 0 (116,021) $1,011,232 $2,879,645 Variance Favorable (Unfavorable) $ 8,663 101,821 110,484 14,845 1,921,225 (62,395) 1,873,675 1,984, 159 275 275 1,984,434 (116,021) $1,868,413 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, 1992 (With comparative totals for the fiscal year ended September 30, 1991) Electric Assets current Assets: Equity in Cash and Cash Equivalents $ 551,464 Equity in Invest•ents 6,108,735 Receivables: Accrued Interest 228,023 Accounts 4,026,507 Special Assess•ents 0 Other 654,578 Less Allowance for Uncollectible Accounts (711,206) Interfund Receivables 153,393 Inventories 927 ,677 Prepaid Costs 0 Total Current Assets 11,939,171 Restricted Assets: Equity in Cash and Cash Equivalents 10 J 133 Equity in Invest•ents 4,650,774 Receivables: Accrued Interest Receivable 68,321 Accounts 51 ,567 Total Restricted Assets 4,780,795 Note Receivable fro• Joint Venture 0 Equity in Joint Venture 0 Advance to Other Funds 1, 168, 279 Deferred Charges: Water Well 0 Bond Issuance Costs 20,224 Accu•ulated A•ortization (2 ,501 ! Total Deferred Charges 17 723 Property and Equip•ent: Utility Plant 21,396,666 Buildings 0 Machinery and Equip•ent 49,769 Accu•ulated Depreciation (7,401,146) Construction in Progress 1'898 J 516 Land 0 Total Property and Equip•ent, Net 15,943,805 Total Assets $331849,773 • 94. Water $ 0 0 0 486,989 0 0 (6,368) 0 277 ,266 0 757,887 314,727 3,486,333 81 '731 0 3,882,791 0 0 0 1,167,075 13,499 (962,963) 217 611 27,812,282 811,654 572,032 (7,365,430) 439,395 529,609 22,799,542 $271657,831 $ Sewer 47,475 563,530 14,389 238,915 4,794 0 (5,309) 0 13,570 600 877,964 120,982 1,340,161 39 J 141 0 1 ,500,284 0 0 0 0 31'034 {3, 838) 27 196 19,920,864 811,654 998,787 (4,935,662) 2' 112' 794 414 641 19,323,078 $211728,522 Solid Totals Waste Collection 1992 1991 $ 7' 159 $ 606,098 $ 1'108' 708 79,310 6,751,575 5,530,264 2 7 ,833 270,245 196,544 158,626 4,911,037 4,454,003 0 4,794 6, 77.5 0 654,578 566,032 (14,439) (737,322) (641,151) 0 153,393 0 0 1,218,513 1'226, 118 0 600 600 2 58,4 89 13,833,511 12,447,893 0 445,84 2 2' 066' 124 0 9,477,268 10,305,879 0 189, 193 1 96,994 0 51 567 293 0 10, 163, 870 12,569,290 836,819 836,819 909 137 350,038 3 50,038 631 , 2 60 0 1 ,168,279 0 0 1,167,075 1 ,16 7,075 0 64,757 64,757 0 {969,302) (917,166) 0 262,530 314 666 0 69,129,812 63,985,53 8 0 1,623,308 1,623,308 2,345,657 3,966,245 2,832,438 (932,592) (20,634,830) ( 18' 866, 595) 0 4,450,705 6,616,315 0 944, 250 940,200 1,413,065 59,479,490 57,131,204 $ 2,858,411 $ 86,094,537 $ 84,003,450 (Continued) • 95. CITY OF COLLEGE STATION, TEXAS ENTERPRISE FUNDS COMBINING BALANCE SHEET Se ptem ber 30, 1992 (With comparative totals for the fiscal year ended September 30, 1991) (Continued) Liabilities and Fund Equity Current Liabilities: Accounts Payable Retainage Payable Refundable Deposits Obligation Under Capital Lease Ace rued Liabili tie.s Deferred Revenues Total Current Liabilities Current Liabilities Payable fro• Restricted Assets: Accounts Payable Accrued Interest Payable Retainage Payable Refundable Deposits Revenue Bonds General Obligation Bonds Certificates of Obligation Total Current Liabilities Payable fro• Restricted Assets Noncurrent Liabilities: Revenue Bonds General Obligation Bonds certificates of Obligation Obligation Under Capital Lease Advances fro• Other Funds 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 • 96. Electric $ 2' 124 '782 0 0 0 204,662 25,997 2,355,441 38, 811 80,727 62,626 1,898,082 508,750 134,750 13 100 2,736,846 4,536,550 693,000 78,600 0 0 71 359 5,379,509 10,471,796 3' 105,236 662,593 5,461,879 14, 148,269 23,377,977 $33,849,773 Water $ 1,921,712 0 0 451,982 24,731 733 2,399,158 9,079 139,502 3,089 0 1,113,000 126,500 6,550 1,397,720 8,040,400 510,000 39,300 1,826,479 0 28,891 10,445,070 14,241,948 3,091,793 1,643,330 3,486,554 5, 194,206 13,415,883 $27,657,831 $ Sewer 75,654 0 0 0 24,904 0 100,558 234,634 111,757 62,612 0 753,250 109,545 6,550 1,278,348 6,778,050 572,615 39,300 0 0 34,315 7,424,280 8,803,186 4 ,041 ,604 1,080,577 2' 845' 158 4,957,997 12,925,336 $21,728,522 Solid Totals waste Collection 1992 1991 $ 24,029 $ 4' 146' 177 $ 2,696,284 153,393 153 ,393 0 0 0 975 0 451,982 4 1 3,651 15' 144 269,441 240,008 0 26,730 35,402 192,566 5,047,723 3,386,320 0 282,524 2 82,53 1 0 331,986 369,541 0 128,327 107,634 0 1,898,082 1,919,104 0 2,375,000 2,475,000 0 370,795 376,235 0 26,200 26,201 0 5,412,914 5,556,246 0 19,355,000 21,730,000 0 1,775,615 2, 146,410 0 157,200 183 ,401 0 1,826,479 2,278,462 1,168,279 1,168,279 0 19 727 154 ,292 139,543 111881006 24,436,865 26,477,816 1,380,572 34,897,502 35,420,382 54,901 10,293,534 10,293,535 0 3,386,500 3,829,607 0 11 ,793,591 11,474,090 1,422,938 25,723,410 22,985,836 1,477,839 51, 197 ,035 48,583,068 $ 2,8581411 $ 8610941537 $ 8410031450 • 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, 1992 (With comparative totals for the fiscal year ended September 30, 1991) Electric Water Operating Revenues: Electric Sales $ 27,320,323 $ 0 Water Sales 0 5, 190, 561 sewer Service 0 0 Garbage �ollection Fees 0 0 Other 5391660 1281591 Total Operating Revenues 2718591983 513191152 Operating Expenses: Purchased Power 18,637,583 0 Salaries and Benefits 1I501I016 871,502 Supplies 76I180 94,391 Maintenance 237,691 120,666 Purchased Professional Services 355,740 8,094 Purchased Property Services 96,928 615' 134 Other Purchased Services 331, 180 123,330 Rei1bursed Ad1inistrative 1,002,156 784,866 Depreciation and A1ortization 725,945 749,954 Other 1291614 321031 Total Operating Expenses 2310941033 313991968 Operating Inco1e (Loss) 417651950 119191184 Nonoperating Revenues (Expenses): Interest Earnings 895, 188 115,396 Rei1bursed Expenses 82,383 4' 178 Contributions 0 1,530 Earnings in Joint Venture 0 0 Interest Expense (484,631) (1,070,022) Other, Net £2021115) (411304) Total Nonoperating Revenues (Expenses) 2901825 £9901222) Inco1e (loss) Before Operating Transfers 510561775 9281962 Operating Transfers out £216701192) £6161980) Total Operating Transfers Out ( 2 I 670 I 192) £6161980) Net Inco1e 2,386,583 311,982 Retained Earnings, October 1 .1718861158 1010121108 Retained Earnings, Septe1ber 30 $ 2012721741 $1013241090 • 98. Sewer $ 0 0 4I251I124 0 94.227 4.3451351 0 943,987 106,048 177,306 42,437 398,076 112,243 661,078 526,130 31724 219711029 113741322 257,238 0 0 0 (704,237) (731274) £5201273) 8541049 £4531600) £4531600) 400,449 814831283 $ 818831732 Solid Totals Waste Collection 1992 1991 $ 0 $ 27,320,323 $ 26,554,630 0 5' 190' 561 4,702,612 0 4,251'124 3,785,002 1,907,028 1,907,028 1,795,247 311843 7941321 5381396 119381871 3914631357 371375,887 0 18,637,583 19,072,974 740,924 4,057,429 3,807,573 62, 168 338,787 310,667 70,499 606, 162 570,717 53,703 459,974 1,319,535 516,538 1,626,676 1,521,543 161,017 727,770 397,579 347,376 2,795,476 1,593,365 244,562 2,246,591 2,126,498 161150 1811519 2341586 212121937 311677,967 3019551037 (2741066) 7,785,390 614201850 68,658 1,336,480 1, 748, 132 0 86,561 82,640 0 1,530 7,832 19,807 19,807 409,543 (51,389) (2,310,279) (2,445,468) {981956) {4151649) 431480 {611880) p 12811550) (1531841) {335,946) 615031840 61267,009 {1491100) {3,8891872) {318211539) {1491100) {318891872) {3,8211539) (485,046) 2,613,968 2,445,470 119071984 3812891533 35,8441063 $ 114221938 $ 4019031501 $ 3812891533 • 99. CITY OF COLLEGE STATION, TEXAS ENTERPRISE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 (With comparative totals for the fiscal year ended September 30, 1991) Electric Wat.Sf Cash Flows from Operating Activities: Cash Received from Customers $27,899,568 $5,005,378 Cash Payments to Suppliers for Goods and Services (20,484,429) (642,267) Cash Payments to Employees for Services (1,484,953) (862,175) 01her (513) 0 Net Cash (Used) Provided by OPefating Activities 5,929,673 3,500,936 Cash Flows from Noncapital Financing Activities: Operating Transfera Out to Other Funds (2,670, 192) (616,980) Contribution to Fleet Replacement Fund (102,984) (42,563) Cash Received from Customer Prespayments 0 733 Cash Provided (Used) by Other Noncapital Financing Activities (1ao,28n 29,498 Net Cash Used by Noncapital Financing Activities (2,953,463) (629,312) Cash Flows from Capital and Related Financing Actiwies: Acquisition and Consruction cl Capital Assets (1,583,011) (327,501) Proceeds from Sale cl Assets 11,382 18,525 Principal Paid on Revenue Bonds (529,750) (1,161,000) Principal Paid on General Obligation Bonds (134,750) (126,500) Principal Paid on Ceftificates cl Obligation (13,100) (6,550) Principal Paid on Obligation Under Capital Lease 0 (413,652) Interest Paid on Rewnue Bonds (448,051) (855,972) Interest Paid on General Obligation Bonds (44,622) (34,677) Interest Paid on Ceftificates cl Obligation (12,576) (6,288) Interest Paid on Obligation Under Capiital Lease 0 (179,34 7) Prcx::eeds from Rewnue Bonds 0 0 Proceeds from Advance from Other Funds 0 0 Cash Received from Capital Grants 0 0 Cash Received from Special Assessments 0 0 Net Cash Used by Capital and Relat.ed Financing Activities (2,754,478) (3,092,962) Cash Flows from Investing Activities: Advance to 01her Fund (1,321,672) 0 Cash Distribution from Joint Venture 0 0 Purchase cl Investments (8,799,048) (2,850,678) Proceeds from Sale and Maturities cl Investments 7,708,048 2,618,928 Interest on Investments 814,192 115,396 Net Cash Provided (Used) by Investing Activities (1,598,480) (116,354) Net lnaease (Decrease) in Cash (1,376,748) (337,692) Cash and Cash Equivalents, October 1 1,938,345 652,419 Cash and Cash Equivalents, $efXember 30 $ 561,597 $ 314,727 Reconciliation cl OPefating Income to Net Cash Provided (Used) by OPefating Activities: OPefming Income (Loss) $4,765,950 $1,9i9,184 Adjustment to Reconcile OPefating Income to Net Cash Provided (Used) by OPefaling Activities: Depreciation 725,945 749,954 Amortization 1,305 871 Provision for Uncollectible Accoonts 89,670 (1,023) Change in Assets and Liabilities: Change in Accounts Receivable 39,585 (313,774) Other Receivables 0 0 Change in lnventOIY (16,470) 15,469 Change in Acx::oonts Payable 301,158 1,120,941 Change in Accrued Liabilities 17,739 4,433 Change In Due to Joint Venture 0 0 Change in Accrued Vacation 4,791 4,881 Taal Adjustments 1,163,723 1,581,752 Net Cash Provided (Used) by Operating Activities $5,929,673 $3,500,936 • 100 - Sewer $4,249,759 (1, 478, 782) (935,685) 0 1,835,292 (453,600) (65,793) 0 180,501 (338,892) (1,564,090) 3,743 (784,250) (114,985) (6,550) 0 (668,955) (39,674) (6,288) 0 0 0 0 2,092 (3,178,95n 0 0 (1,557,747) 2,543,848 285,568 1,271,669 (410,888) 579,345 $ 168,457 $1,374,322 526,130 2,002 (695) (95,592) 0 162 20,682 4,652 0 3,629 460,970 $1,835,292 T�als SolidWast.e Colledion 1992 1991 $1,851,618 $39,006,323 $37 ,958,884 (1,204,295) (23,809, 773) (24, 182,869) (736,766) (4,019,579) (3,779,432) 0 (513) 10,157 (89,443) 11,176,458 10,006,740 (149,100) (3,889,872) (3,821,539) (110,290) (321,630) 0 0 733 0 (59,812) (30,100) 219,613 (319,202) (4,240,869) (3,601,926) (1,325,875) (4,800,477) (5,577,868) 24,085 57,735 15,000 0 (2,475,000) (2,415,000) 0 (376,235) (377,765) 0 (26,200) (26,200) 0 (413,652) (378,849) 0 (1,972,978) (2, 086, 420) 0 (118,973) (138,618) 0 (25, 152) (28,296) 0 (179,347) (214,151) 0 0 4,800,000 1,321,672 1,321,672 0 0 0 3,999 0 2,092 0 19,882 (9,006,515) (6,424, 168) 0 (1,321,672) 0 301,029 301,029 0 (64,535) (13,272,008) (15,836,144) 8,785 12,879,609 15,723,188 145,920 1,361,076 1,675,818 391,199 (51,966) 1,562,862 2,436 (2, 122,892) 1,543,508 4,723 3,174,832 1,631,324 $7,159 $1,051,940 $ 3,174,832 $(274,066) $7,785,390 6,420,850 244,562 2,246,591 2,126,498 0 4,178 3,829 7,7()8 95,658 258,658 (87,253) (457,034) 1,149,322 0 0 (566,032) 8,444 7,605 125,128 7,113 1,449,894 666,047 2,603 29,427 (44,435) 0 0 (135,772) 1,448 14,749 2,647 184,623 3,391,068 3,585,890 $(89,443) $11,176,458 $10,006,740 • 101 • 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, 1992 Budget Actual $30,022,000 $27 ,268, 119 305,000 298,328 18,700 0 55,000 241,332 30,400,700 27,807,779 610,000 684,763 50,000 82,383 Miscellaneous Nonoperating Revenue 0 26,337 Total Nonoperating Revenues Operating Transfers In Energy Project Fund: Interest Earnings Revenue Bond I & S Fund: Interest Earnings Operating Transfers In Total Revenue I & S Fund Electric Revenue Bond Funds: Interest Earnings Total Electric Fund Revenues See reconciliation to GAAP basis on page 11 0. 660,000 793,483 344,424 344,424 15,000 31,554 0 44,622 1,026,220 1,026,216 1,026,220 1,070,838 0 134,251 $32,446,344 $30, 182,329 • 102. Variance Favorable (Unfavorable) $(2, 753,881) (6,672) (18,700) 186,332 (2, 592, 921) 74,763 32,383 26,337 133,483 0 16,554 44,622 (4) 44,618 134,251 $(2,264,015) Administration: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Administration Technical Services: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Technical Services Electric Transmission/Distribution: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Electrical Transmission/Distribution Nondepartmental: Depreciation Principal Payments Interest Expense Payment in Lieu of Taxes Special Programs/Projects Public Agency Funding Reimbursed Administrative Public Agency Funding Contribution to Fleet Replacement Fund Contingency Total Nondepartmental Revenue Bond I & S Fund: Principal Payments Interest Expense Fiscal Agent's Fees Total Revenue Bond I & S Fund Electric Revenue Bond Fund: Reimbursed Administrative Capital Outlay Contingency Total Electric Revenue Bond Fund Total Electric Fund Expenses CITY OF COLLEGE STATION. TEXAS ELECTRIC FUND SCHEDULE OF EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 Budget Actual $ 153,155 $ 153,143 12,925 12,860 26,811 26,785 89,000 90,636 1,720 1,713 28,926 28,914 13,700 13,671 326,237 327,722 754,902 754,655 73,060 71,408 49,010 46, 196 26,110 25,616 19,848,353 18,713,016 140,846 134,347 58,912 47,719 20,951,193 19,792,957 857,666 857,287 40,390 39,467 166,100 164,711 244,230 243,477 20,460 19,782 168,733 167,919 53,185 51,097 1,550,764 1,543,740 785,400 0 147,850 147,850 57, 198 57, 198 2,670,200 2,670,192 108,000 15,023 1,026,220 1,026,216 1,275,350 1,275,336 110,000 110,000 102,984 102,984 109,789 317 6,392,991 5,405,116 529,750 529,750 448,051 448,051 0 867 977,801 978,668 73, 113 73,113 2,350.000 1,054,984 70,000 0 2,493, 113 1, 128,097 $32, 692, 099 $29, 176,300 See reconciliation to GA.AP basis on page 110. • 103. Variance Favorable (Unfavorable) $ 12 65 26 (1,636) 7 12 29 (1,485) 247 1.652 2,814 494 1,135,337 6,499 11,193 1, 158,236 379 923 1;389 753 678 814 2,088 7,024 785,400 0 0 8 92,977 4 14 0 0 109,472 987,875 0 0 (867) (867) 0 1,295,016 70,000 1,365,016 $3,515,799 CITY OF COLLEGE STATION. TEXAS WATER FUND SCHEDULE OF REVENUES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 Budget Actual Operating Revenues: Water Sales $5,249,200 $5, 139,730 Forfeits, Discounts, Penalties 37,000 51, 103 Water Taps 48,000 77,488 Total Operating Revenues 5,334,200 5,268,321 Nonoperating Revenues: Reimbursed Expenses 3,300 4,178 Miscellaneous Nonoperating Revenue 0 12,239 Total Nonoperating Revenues 3,300 16,417 Revenue Bond I & S Fund: Interest Earnings 0 96,064 Operating Transfers In 1,907, 136 1,907, 136 Total Revenue Bond I & S Fund 1,907, 136 2,003,200 Water Revenue Bond Fund: Interest on Investments 0 135,294 Contributions 0 1,530 Total Water Revenue Bond Fund 0 136,824 Total Water Fund Revenues $7,244,636 $7,424,762 See reconciliation to GAAP basis on page 11 0. • 104. Variance Favorable (Unfavorable) $(109,470) 14, 103 29,488 (65,879) 878 12,239 13, 117 96,064 0 96,064 135,294 1,530 136,824 $180, 126 Water Production: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Water Production Water Distribution: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Water Distribution Nondepartmental: Depreciation Principal Payments Interest Expense Payment in Lieu of Taxes Special Programs/Projects Reimbursed Debt Service Reimbursed Administrative CITY OF COLLEGE STATION. TEXAS WATER FUND SCHEDULE OF EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 Budget Actual $391,809 $372,648 52,030 34, 187 84, 130 32,986 1,400 953 953,850 939,497 36, 116 33,948 16,655 16,627 1,535,990 1,430,846 513,582 498,854 75,720 75,656 109,520 87,680 9,550 7, 141 271,300 268,636 89,427 89,382 28,495 28,433 1,097,594 1,055,782 785,000 0 133,050 133,050 40,965 156,927 616,990 616,980 0 8,630 1,907, 136 1,907, 136 692,836 692,820 Contribution to Fleet Replacement Fund 42,563 42,563 Contingency 57,312 0 Total Nondepartmental 4,275,852 3,558, 106 Revenue Bond I & S Fund: Principal Payments 1,161,000 1,161,000 Interest Expenses 855,971 855,971 Fiscal Agent's Fees 0 1,867 Total Revenue Bond I & S Fund 2,016,971 2,018,838 Water Revenue Bond Fund: Reimbursed Administrative 100, 110 100, 110 Capital Outlay 2,804,000 256,841 Contingency 80,000 0 Total Water Revenue Bond Fund 2,984, 110 356,951 Total Water Fund Expenses $11,910,517 $8,420,523 See reconciliation to GAAP basis on page 11 0. • 105. Variance Favorable (Unfavorable) $19,161 17,843 51,144 447 14,353 2,168 28 105, 144 14,728 64 21,840 2,409 2,664 45 62 41,812 785,000 0 (115,962) 10 (8,630) 0 16 0 57,312 717,746 0 0 (1,867) (1,867) 0 2,547, 159 80,000 2,627, 159 $3,489,994 CITY OF COLLEGE STATION. TEXAS WATER FUND SCHEDULE OF REVENUES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 Budget Actual Operating Revenues: Water Sales $5,249,200 $5,139,730 Forfeits, Discounts, Penalties 37,000 51, 103 Water Taps 48,000 77,488 Total Operating Revenues 5,334,200 5,268,321 Nonoperating Revenues: Reimbursed Expenses 3,300 4,178 Miscellaneous Nonoperating Revenue 0 12,239 Total Nonoperating Revenues 3,300 16,417 Revenue Bond I & S Fund: Interest Earnings 0 96,064 Operating Transfers In 1,907, 136 1,907, 136 Total Revenue Bond I & S Fund 1,907, 136 2,003,200. Water Revenue Bond Fund: Interest on Investments 0 135,294 Contributions 0 1,530 Total Water Revenue Bond Fund 0 136,824 Total Water Fund Revenues $7,244,636 $7,424,762 See reconciliation to GAAP basis on page 11 0. - 106 - Variance Favorable (Unfavorable) $(109,470) 14, 103 29,488 (65,879) 878 12,239 13, 117 96,064 0 96,064 135,294 1,530 136,824 $180, 126 Sewer Treatment: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Sewer Treatment Sewer Collection: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Sewer Collection Nondepartmental: Depreciation Expense Principal Payments Interest Expense CITY OF COLLEGE STATION. TEXAS SEWER FUND SCHEDULE OF EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 Budget Actual $ 549,855 $ 548,872 84,300 77,446 114,260 114,003 53,028 42,262 422,740 373,205 68,487 64,357 23,500 18,027 1,316, 170 1,238, 172 443,623 395, 168 29,060 28,602 67,260 63,303 5,350 176 25,030 24,871 52,092 47,885 57,309 57,241 679,724 617,246 590,000 0 118,717 118,757 45,383 45,382 Contribution to Fleet Replacement Fund 65,793 65,793 Payment in Lieu of Taxes 453,610 453,600 Special Prorams/Projects 0 8,630 Reimbursed Debt Service 1,514,620 1,514,616 Reimbursed Administrative 476,416 476,412 Contingency 44,412 0 Total Nondepartmental 3,308,951 2,683,190 Revenue Bond I & S Fund: Principal Payments 784,250 784,250 Interest Expense 668,955 668,955 Fiscal Agent's Fees 0 1,396 Total Revenue Bond I & S Fund 1,453,205 1,454,601 Sewer Revenue Bond Fund: Reimbursed Administrative 198,248 198,248 Capital Outlay 5,835,000 1,477, 191 Contingency 50,000 0 Total Sewer Revenue Bond Fund 6,083,248 1,675,439 Total Sewer Fund Expenses $12,841,298 $7,668,648 See reconciliation to GAAP basis on page 110. • 107. Variance Favorable (Unfavorable) $ 983 6,854 257 10,766 49,535 4,130 5,473 77,998 48,455 458 3,957 5,174 159 4,207 68 62,478 590,000 (40) 1 0 10 (8,630) 4 4 44,412 625,761 0 0 (1,396) (1,396) 0 4,357,809 50,000 4,407,809 $5, 172,650 Operating Revenues: Residential Collection Commercial Collection Other Charges for Services Dumpster Sales Forfeits, Discounts, and Penalties Recycling Other Total Operating Revenues Nonoperating Revenues: Interest Earnings Earnings in Joint Venture Miscellaneous Total Nonoperating Revenues Operating Transfers In Total Solid Waste Collection Fund Revenues CITY OF COLLEGE STATION. TEXAS SOLID WASTE COLLECTION FUND SCHEDULE OF REVENUES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 Budget Actual $1, 191,717 $1,177,995 663,820 709,545 0 540 10,000 1,645 20,000 19,251 4,000 10,407 10,556 0 1,900,093 1,919,383 38,000 17,269 160,870 0 0 24,860 198,870 42,129 49,444 49.440 $2, 148,407 $2,010,952 See reconciliation to GAAP basis on page 110. • 108. Variance Favorable (Unfavorable) $(13,722) 45,725 540 (8,355) (749) 6,407 (10,556) 19,290 (20, 731) (160,870) 24,860 (156,741) (4) $(137,455) Commercial Collection: Salaries and Benefits Supplies Maintenance Purchased Property Services Other Purchased Services Capital Outlay Total Commercial Collection Residential Collection: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Residential Collection Nondepartmental: Depreciation Expense Principal Payments Interest Expense Reimbursed Administrative Public Agency Funding Payment in Lieu of Taxes CITY OF COLLEGE STATION. TEXAS SOLID WASTE COLLECTION FUND SCHEDULE OF EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 Budget Actual $ 278, 196 $ 270,888 29,040 21,570 41,350 35,815 311,040 311,007 63,719 57,783 1, 187 1, 187 724,532 698,250 487,887 469,204 45,994 40,599 61,680 34,683 63,900 53,703 205,540 205,532 111,491 103,234 3,104 3,016 979,596 909,971 191,700 0 22,324 0 59, 193 0 396,832 396,816 10,000 10,000 156,270 149, 100 Contribution to Fleet Replacement Fund 110,290 110,290 Capital Outlay 1,415,395 1,321,672 Contingency 23,043 0 Expected Expense Savings (69,500) 0 Total Nondepartmental 2,315,547 1,987,878 Total Solid Waste Collection Fund Expenses $4,019,675 $3,596,099 See reconciliation to GAAP basis on page 110. • 109. Variance Favorable (Unfavorable) $ 7,308 7,470 5,535 33 5,936 0 26,282 18,683 5,395 26,997 10, 197 8 8,257 88 69,625 191,700 22,324 59,193 16 0 7, 170 0 93,723 23,043 (69,500) 327,669 $423,576 CITY OF COLLEGE STATION. TEXAS ELECTRIC, WATER, SEWER AND SOLID WASTE COLLECTION FUNDS SCHEDULE FOR RECONCILIATION OFREVENUES AND EXPENSES (BUDGETARY BASIS) TO GAAP BASIS STATEMENT OF INCOME FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 Total Revenues Per Budget - Actual Less total Expenses Per Budget -Actual Net Gain (Loss), Bu dgetary Basis Add (S ubtract) -Expenses (Revenues) Related to Balance Sheet: Prior Year I nterest Accrual Debt Service Principal Payment Capital Outlay Capital Lease Principal Paym e nt s Reclass Salaries and Benefits to Construction in Progress Add (Subtract) - Unbudgeted Revenue/(Expense) Adjustments: Current Year Revenue Accrual Investment in J oint Venture Other Depreciation Amortization Prior Year R evenue Accrual Current Year Interest Expense Accrual Bad Debt Expense Inventory Adjustment Loss on Sale of Equi pment Interest Expense Correction Net Income (Loss). GAAP Basis Electric $30, 182,329 29, 176,300 1,006,029 89,517 677,600 1,215,026 0 269,847 970,128 0 4,074 (725,945) (1,305) (917,924) (80,727) (89,670) (39,628) (2,267) 11,828 $2,386,583 • 110. Water $7,424,762 8,420,523 (995,761) 156,491 1,294,050 317,353 413,652 8, 198 213,869 0 (384) (749,954) (871) (163,038) (139,502) 1,023 (32,031) (384) (10, 729) $311,982 Sewer $6, 112, 714 7,668,648 (1,555,934) 123,533 902,967 1,552,459 0 13,634 171,980. 0 (579) (526, 130) (2,002) (163,320) (111, 757) 695 (3,724) (277) (1,096) $400,449 Solid Waste $2,010,952 3,596,099 (1,585,147) 0 0 1,325,875 0 0 82,544 19,807 79 (244,562) -0 (63,055) 0 (7,706) (8,444) (4,437) 0 $(485,046) 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 City1s health benefits plan. Fleet Replacement - to account for the purchase of City vehiciles not budgeted in other funds. 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 City1s electric, water, and sewer utilities and residential and commercial garbage collection. Workers1 C ompensation -to account for self-insurance activity relating to administration of the City1s workers1 compensation plan . • 111 • CITY OF COLLEGE STATION. TEXAS INTERNAL SERVICE FUNDS COMBINING BALANCE SHEET September 30, 1992 (With comparative totals for the fiscal year ended September 30, 1991) Assets current Assets: Equity in Cash and Cash Equivalents Equity in Invest•ents Receivables: Accrued Interest Accounts Less Allowance for Uncollectable Accounts Inventories Prepaid Costs Total Current Assets Property and Equip•ent: Machinery and Equip•ent General Electric Plant Less Accu•ulated Depreciation Total Property and Equip•ent, Net Total Assets Liabilities and Fund Equity Current Liabilities: Accounts Payable ClailS Payable Accrued Liabilities Total Current Liabilities Noncurrent Liabilities: Accrued vacation Total Noncurrent Liabilities Total Liabilities Fund Equity: Contributed capital Unreserved Retained Earnings (Oef icit) Total Fund Equity Total Liabilities and Fund Equity • 112. E•ployee Benefits $ 15,24 5 168,876 5,232 22,627 0 0 3,800 215,780 0 0 0 0 $ 215,780 $ 1 ,570 298 ,821 3,828 304,219 0 0 3 04,219 0 (88,439) (88 ,439) $ 215,780 Fleet Replacement $ 50,839 563,163 13,563 0 0 0 0 627,565 715,994 0 (57,589) 658,405 $1 ,285,970 $ 225 0 0 225 0 0 225 0 1,285,745 1,285,745 $1,285,970 Landfill $ 2,812 31, 155 0 0 0 532 0 34,499 34 ,378 0 (6,999) 2 7,379 $ 61,878 $ 6,466 0 8, 161 14,627 9 ,817 9 817 24,444 0 37,434 37,434 $ 61,878 Property and Casualty $ 0 0 0 175 (175) 0 0 0 0 0 0 0 $ 0 $ 46,836 23' 100 0 69,936 0 0 69,936 0 !69,936) (69,936) $ 0 $ $ $ $ Une•ploy•ent 9,376 103,865 2,685 0 0 0 0 115 926 0 0 0 0 1 15, 926 0 0 0 0 0 0 0 0 115,926 115,926 115, 926 Utility $ $ $ $ Billing 12' 139 134,474 3 ,511 0 0 0 0 150, 124 0 541, 161 (350,038) 191,123 341,247 5,276 0 4 978 10,254 35, 790 35,790 46,044 381,137 (85,934) 295,203 341,247 $ $ $ $ . 113. Workers' Co•pensation 52' 157 577,758 14,596 0 0 0 0 644 511 0 0 0 0 644,511 64,876 156' 177 0 221 ,053 0 0 221, 053 0 423,458 423,458 644,511 Totals 1992 $ 142,568 $ 1 ,579,291 39,587 22,802 (175) 532 3,800 1,788,405 750,372 541,161 !414,626) 876,907 $2,665,312 $ $ 125,249 $ 478,098 16 967 620,314 45 607 45 607 665,921 381,137 1,618,254 1,999,391 $2,665,312 $ 1991 96,322 480,450 11, 046 229 0 0 3,820 591 ,867 . 18' 765 522,598 (246,782) 294,581 886,448 199' 648 339,837 16, 051 555,536 40,701 40,701 596,237 381'137 (90,926) 290,211 886,448 CITY OF COLLEGE STATION. TEXAS INTERNAL SERVICE FUNDS COMBINING STATEMENT OF REVENUES.i. EXPENSES AND CHANGES IN RETAINED EARNING\:) (DEFICIT) For the Fiscal Year Ended September 30, 1992 (With com parat ive totals for the fiscal year ended September 30, 1991) E•ployee Fleet Benefits Ree1ace111ent Operating Revenues: Charges for services $ 0 $1,304,792 Premiums 1,485,601 0 Other 0 0 Total Operating Revenues 1 J 485 J 601 1,304,792 Operating Expenses: Salaries and Benefits 0 0 Supplies 0 0 Maintenance 0 0 Purchased Professional Services 0 0 Purchased Property Services 0 0 Other Pu rchased Services 0 0 ClaiH 1,062,206 0 Ad•inistration Fees 92,923 0 P re•1 UH 302,084 0 Rei•bursed Ad•inistrative 0 0 Depreciation 0 57,589 Other 300 0 Total Ope rat ing Expenses 1,457,513 57,589 Operating Inco•e (Loss) 28,088 1,247,203 Nonoperating Revenues (Expenses): Intere st Earnings 14,174 38,542 Rei•bursed Expenses 0 0 Interest Expense 0 0 Other, Net 17 0 Total Nonoperating Revenues (E x penses) 14 191 38,542 Net Inco•e (Loss) 42,279 1,285,745 Retained Earnings (Deficit), October 1 (130, 718} 0 Retained Earnings (Deficit), September 30 $ (881439) $11285,745 . 114. Landfill $ 765,525 0 0 765,525 363,585 79 ,871 69,282 12,858 12,045 11 '384 0 0 0 185,364 5,288 0 739 6 77 2 5 ,84 8 0 0 ( 1 '116) 0 ( 1 t 116) 24 ' 732 12 702 $ 37,434 Property Totals and Utility Workers' Casualty Unemployment Billing Co•pensation 19 92 1991 $ 0 $ 0 $ 1 '241 '148 $ 0 $ 3,311,465 $ 1,644,575 372,387 71,675 0 439, 181 2,368,844 2,041 ,029 0 0 0 0 0 12 82 3 3 72,387 71 675 1,241,148 439 181 5,680,309 3,698,427 0 0 774,867 0 1,138,452 1 ,023,523 0 0 27,955 0 107,826 8 7,088 0 0 12,969 0 82,251 63 ,04 0 0 0 0 0 12,858 6 ,668 0 0 21,893 0 33,938 32,346 0 0 92,721 0 104, 105 94,428 78,291 15, 929 0 151,386 1,307,812 1,327,31 9 0 0 0 25,800 118, 7.23 103,048 257,335 0 0 28, 461 587,880 662 ,5 91 55,476 0 160,248 0 401,088 314,241 0 0 104,967 0 167,844 91. 772 175 0 0 0 475 3 725 391 277 15,929 1 ,195,620 205,647 4,063,252 3,809,789 (18 ,890) 55 746 45,528 233,534 1,617,057 ( 111 '362) 0 7' 123 8,65 7 39, 542 108,038 44,92 8 5,635 0 0 0 5,635 0 (6,492) 0 0 0 (7,608 ) 0 (6,700) 0 (7,259) 0 (13,942) (5,23 0 ) (7,557) 7 123 398 39 542 92. 123 39 698 (26,447) 62 ,869 46,926 273,076 1'709,180 (71. 664) (43,489) 53 ,0 57 ( 132. 860) 150,382 (90,926) ( 19' 262) $ {691936) $ 1151926 $ (85,934) $ 423,458 $ 1 ,618,254 $ (90,926) . 115. CITY OF COLLEGE STATION. TEXAS INTERNAL SERVICE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 (WITH COMPARATIVE TOTALS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1991) Employee Fleet Benefits Replacement Landfill Cash Flows from Operating Activities: Cash Received from Customers $1,463,208 $1,304,792 $765,525 Cash Payments to Suppliers for Goods and Services (1,304, 764) 0 (376,449) Cash Payments to Employees for Services 0 0 (363,234) Other (180) 0 0 Net Cash Provided (Used) by Operating Activities 158,264 1,304,792 25,842 Cash Flows from Noncapital Financing Activities: Other 16 0 (1,118) Net Cash Provided (Used) by Noncapital Financing Activities 16 0 (1,118) Cash Flows from Capital and Related Financing Activities: Acquisition of Capital Assets 0 (715,769) (15,613) Net Cash Used by Capital and Related Financing Activities 0 (715,769) (15,613) Cash Flows from Investing Activities: Purchase of Investments (154,799) (1,892,934) (24,479) Proceeds from Sale and Maturities of Investment Securities 0 1,329,771 • 14,029 Interest on Investments 8,942 24,979 0 Net Cash Provided (Used) by Investing Activities (145,857) (538, 184) (10,450) Net Increase (Decrease) in Cash and Cash Equivalents 12,423 50,839 (1,339) Cash and Cash Equivalents, October 1 2,822 0 4, 151 Cash and Cash Equivalents, September 30 $ 15,245 $ 50,839 $ 2,812 Reconciliation of Operating Income (Loss) to Net Cash Provided (Used) by Operating Activities: Operating Income (Loss) $ 28,088 $1,247,203 $ 25,8 48 Adjustments to Reconcile Operating Income (Loss) to Net Cash Provided (Used) by Operating Activities Depreciation 0 57,589 5,288 Provision for Uncollectable Accounts 0 0 0 Change in Assets and Liabilities: Change in Accounts Receivable (22,573) 0 0 Change in Inventory 0 0 (532) Change in Prepaid Costs 0 0 0 Change in Accounts Payable 998 0 (5, 113) Change in Accrued Liabilities 151,751 0 54 Change in Accrued Vacation 0 0 297 Total Adjustments 130, 176 57,589 (6) Net Cash Provided (Used) by Operating Activities $158,264 $1,304,792 $25 ,842 • 116. Property and Utility Workers' Totals Casualtv Unemployment Billing Compensation 1992 1991 $372,387 $71,675 $1,241,148 $439, 181 $5,657,916 $3,702,808 (436,801) (15,929) (319,259) (240,545) (2,693, 747) (2,503,971) 0 0 (769,304) 0 (1, 132,538) (1,018,683) 0 0 0 0 (180) 0 (64,414) 55,746 152,585 198,636 1,831,451 180, 154 (7,556) 0 (7,258) 0 (15,916) (3,407) (7,556) 0 (7,258) 0 (15,916) (3,407) 0 0 (18,564) 0 (749,946) (106,227) 0 0 (18,564) 0 (749,946) 106,227) 0 (84,563) (123,079) (471,774) (2, 751,628) (480,449) 58,777 24, 121 0 226,089 1,652,787 420,493 1,409 5,366 6,170 32,632 79,498 42,130 60,186 (55,076) (116,909) (213,053) (1,019,343) (17,826) (11,784) 670 9,854 (14,417) 46,246 52,694 11,784 8,706 2,285 66,574 96,322 43,628 $ 0 $ 9,376 $ 12, 139 $52,157 $142,568 $96,322 $ (18,890) $ 55,746 $ 45,528 $ 233,534 $1,617,057 $(111,362) 0 0 104,967 0 167,844 175 0 0 0 175 91,772 0 0 0 0 (22,573) 4,381 0 0 0 0 (532) 0 0 0 0 20 20 221,455 (68,799) 0 (3,453) 1,743 (74,624) 114,746 23,100 0 933 (36,661) 139, 177 (145,337) 0 0 4,610 0 4,907 4,499 (45,524) 0 107,057 (34,898) 214,394 291,516 $ (64,414) $ 55,746 $ 152,585 $ 198,636 $1,831,451 $180,154 . 117. Operating Revenues: Premiums Total operating revenues Operating Expenses: Claims Administration Fees Premiums Other Total Operating Expenses Net Operating Income Nonoperating Revenues: Interest Earnings Other, Net Total Nonoperating Revenues Net Income 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, 1992 Budget Actual $1,478,345 $1,485,601 1,478,345 1,485,601 1,065,200 923,144 134,000 90,724 278,800 302,084 0 300 1,478,000 1,316,252 345 169,349 0 14, 174 1,500 17 1,500 14, 191 $ 1,845 $183,540 See reconciliation to GAAP basis on page 126. • 118. Variance Favorable (Unfavorable) $ 7,256 7,256 142,056 43,276 (23,284) (300) 161, 748 169,004 14, 174 (1,483) 12,691 $181,695 Operating Revenues: Charges for Goods and Services Total Operating Revenues Operating Expenses: Capital Outlay Total Operating Expenses Net Operating Income Nonoperating Revenues: Interest Earnings Total Nonoperating Revenues Net Income CITY OF COLLEGE STATION. TEXAS FLEET REPLACEMENT FUND SCHEDULE OF REVENUES AND EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 Budget Actual $1,312,610 $1,304,792 1,312,610 1,304,792 885,040 715,994 885,040 715,994 427,570 588,798 31,609 38,542 31,609 38,542 $ 459, 179 $ 627,340 See reconciliation to GAAP basis on page 126. • 119. Variance Favorable (Unfavorable) $ (7,818) (7,818) 169,046 169,046 161,228 6,933 6,933 $168,161 Operating Revenues: Charges for Services Total Operating Revenues Operating Expenses: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Reimbursed Adminstrative Capital Outlay Total Operating Expenses Net Operating Income Nonoperating Expenses: Interest Expense Total Nonoperating Expenses Net Income CITY OF COLLEGE STATION. TEXAS LANDFILL F UND SCHEDULE OF REVENUES AND EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 Budget Actual $760,237 $765,525 760,237 765,525 367,542 377,497 81,905 79,871 69,844 69,282 12,783 12,858 14,590 12,045 12,558 11,384 185,378 185,364 15,637 15,613 760,237 763,914 0 1,611 0 1, 116 0 1, 116 $ 0 $ 495 See reconciliation to GAAP basis on page 126. • 120. Variance Favorable (Unfavorable) $5,288 5,288 (9,955) 2,034 562 (75) 2,545 1, 174 14 24 (3,677) 1,611 (1,116) (1,116) $ 495 Operating Revenues: Premiums Reimbursements Total Operating Revenues Operating Expenses: Claims Premiums Reimbursed Administrative Total Operating Expenses Net Operating Income (Loss) Nonoperating Expenses: Interest Earnings CITY OF COLLEGE STATION, TEXAS PROPERTY ANO CASUAL TY FUND SCHEDULE OF REVENUES ANO EXPENSES BUDGET ANO ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 Budget Actual $371,980 $372,387 0 5,635 371,980 378,022 35,824 55, 191 362,400 257,335 0 55,476 398,224 368,002 (26,244) 10,020 3,000 0 Contribution to Fleet Replacement Fund 0 (6,700) Interest Expense 0 (6,492) Total Nonoperating Revenues (Expenses) 3,000 (13,192) Net Income (Loss) $(23,244) $(3, 172) See reconciliation to GAAP basis on page 126. • 121 • Variance Favorable (Unfavorable) $407 5,635 6,042 (19,367) 105,065 (55,476) 30,222 36,264 (3,000) (6,700) (6,492) (16,192) $20,072 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 UNEMPLOYM ENT FUND SCHEDULE OF REVENUES AND EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1992 Budget Actual $71, 150 $71,675 71, 150 71,675 35,000 15,929 35,000 15,929 36,150 55,746 0 7,123 0 7, 123 $36, 150 $62,869 See reconciliation to GAAP basis on page 126. • 122. Variance Favorable (Unfavorable) $ 525 525 19,071 19,071 19,596 7,123 7,123 $26,719 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, 1992 Budget Actual Operating Revenues: Charges for Services $1,241,171 $1,241,148 Total Operating Revenues 1,241,171 1,241,148 Operating Expen ses : Salaries and Benefits 776,530 774,867 Supplies 30,175 27,955 M aintenance 13,000 12,969 Purchased Professional Services 13,500 0 Purchased Property Services 22,640 21,893 Other Services 92,015 85,462 Reimbursed Administrative 160,252 160,248 Capital Outlay 32,643 18,564 Depreciation 97,000 0 Expected Expenditure Savings (40,245) 0 Contingency 9,246 0 Total Operating Expenses 1,206,756 1, 101,958 Net Operating (Loss) 34,415 139, 190 Nonoperating Revenues (Expenses): Contribution to Fleet Replacement Fund. (14,518) (14,518) Interest Earnings 0 8,657 Other 1,500 0 To tal Nonoperating Revenues (Expenses) (13,018) (5,861) Net Income $ 21,397 $ 133,329 See reconciliation to GAAP basi s on page 126. • 123. Variance Favorable (Unfavorable) $ (23) (23) 1,663 2,220 31 13,500 747 6,553 4 14,079 97,000 (40,245) 9,246 104,798 104,775 0 8,657 (1,500) 7,157 $ 111,932 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, 1992 Budget Actual $468,510 $439, 181 468,510 439, 181 21,068 25,800 297,635 190,609 39,048 28,461 55,480 0 413,231 244,870 55,279 194,311 . 25,000 39,542 25,000 39,542 $ 80,279 $ 233,853 See reconciliation to GAAP basis on page 126. . 124. Variance Favorable (Unfavorable) $ (29,329) (29,329) (4,732) 107,026 10,587 55,480 168,361 139,032 14;542 14,542 $153,574 . 125. 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, 1992 Total Revenues per Budget-Actual Less Total Expenses per Budget-Actual Net Income (Loss) , Budgetary Basis Add-Expenses Related to Balance Sheet: Capltal Outlay Add (Deduct) • Unbudgeted Revenue/Expense Adjustments: Prior Year Claims Expense Accrual Reclass Salaries and Benefits to Construction in Progress Claims Expense/Payable Adjustment Prepaid Insurance Correction Bad Debt Expense Claims Incurred but not Paid Depreciation Void Check Correction Loss on Sale of Equipment Net Income (Loss), GMP Basis Empl oyee Benefits $1,499,792 1,316,252 183,540 0 0 0 (139,062) 0 0 0 0 (2, 199) 0 $42,279 • 126. Fleet Replacement Landfill $1,343,334 $765,525 715,994 765,030 627,340 495 715,994 15,613 0 0 0 13,912 0 0 0 0 0 0 0 0 (57,589) (5,288) 0 0 0 0 $1,285,745 $24,732 Property and Workers' Casualty Unemployment Utility Billing Compensation $378,022 78,798 $1,249,805 $478,723 381,194 15,929 1,116,476 244,870 (3, 172) 62,869 133,329 233,853 0 0 18,564 0 0 0 0 0 0 0 0 0 (23, 100) 0 0 39,223 0 0 0 0 (175) 0 0 0 0 0 0 0 0 0 (104,967) 0 0 0 0 0 0 0 0 0 $(26,447) $62,869 $ 46,926 $273,076 . 127. • 128. GENERAL FIXED ASSETS ACCOUNT GROUP To account for fixed assets not used in proprietary fund operations . . 129. . 130. CITY OF COLLEGE STATION. TEXAS GENERAL FIXED ASSETS ACCOUNT GROUP SCHEDULE OF GENERAL FIXED ASSETS BY SOURCE September 30, 1992 General Fixed Assets: Buildings Improvements Machinery and Equipment Parks System Construction in Progress Land Total General Fixed Assets Investment in General Fixed Assets From: Capital Pro j ects Funds: General Obligation Bonds Certificates .of Obligation Capital Equipment General Fund Revenues Special Revenue Funds: Parks Escrow Federal Grants Other Contributions/Donations Acquisitions Prior to July 1, 1979-­ Source Undetermined Total Investment in General Fixed Assets • 131 • 1992 $ 13,031,574 14,270,758 10,193,761 6,275,661 1I861I039 6,899,368 $ 5215321161 $ 31,316,660 1, 732,352 2,591,246 6,609,919 175,556 2,023,722 1,066,821 36,650 61979,235 $ 52 I 5321 161 1991 $ 13,031,574 14, 103, 419 10,000,811 5,826,944 630,808 5,089,038 § 4816821594 $ 32,153,718 1, 732,352 0 4,703,639 23, 107 2,023,722 1,066,821 0 6,9791235 $ 4816821594 CITY OF COLLEGE STATION. TEXAS GENERAL FIXED ASSETS ACCOUNT GROUP SCHEDULE OF GENERAL FIXED ASSETS BY SOURCE -BY FUNCTION AND ACTIVITY SEPTEMBER 30, 1992 Building and Building Total Land Improvements General Fund: General Government $ 497,918 $ 0 $ 59,444 Fiscal and Human Resources 374,574 0 10,654 Police 550,509 0 1,972 Fire 1,035,037 0 3,869 Development Services 305,459 0 9,374 Public Services 1,364, 161 1500 28,168 Parks 1,023,605 0 203,749 Management Services 29,035 0 0 Other 1,429,621 1,429,621 0 Total General Fund 6,609,920 1,431,121 317,230 Special Revenue Funds: Federal Grants 2,023,722 13,082 221,859 Parks Escrow 175,556 34,906 0 Other 1,066,821 150,009 894,294 Total Special Revenue Funds 3,266,099 197,997 1, 116, 153 Capital Projects Funds: Certificates of Obligation Funds 1,732,352 637,168 400,000 Capital Equipment 2,591,246 0 0 Southwest Parkway 642,231 0 0 1971 Bond Funds 172,838 0 0 1976 Bond Funds 126,377 0 1,495 1978 Bond Funds 533,706 0 25, 141 197811 Bond Funds 2,803,997 485,325 579,005 1981 Bond Funds 1,904,043 224,979 1, 114, 176 1982 Bond Funds 3,902,862 376,857 1,237,290 1982 II Bond Funds 7,224,694 1,201,088 901,923 1984 Bond Funds 9,869,706 799, 116 4,509,689 1989 Bond Funds 2,000,714 89, 112 877,615 1991 Bond Funds 274,453 0 0 Total Capital Projects Funds 33,779,219 3,813,645 9,646,334 Contributions/Donations 36,650 0 0 Acquisitions Prior to July 1, 1979 -Source Undetermined 6,979,235 1,456,605 1,951,857 Total General Fixed Assets Allocated to Functions 50,671,122 6,899,368 13,031,574 Construction in Progress 1,861,039 0 85,976 Total General Fixed Assets $52,532, 161 $6,899,368 $13,117,550 - 132. Machinery, Tools and Equipment Parks System Improvements $ 438,474 $ 0 $ 0 3 63,920 0 0 548,537 0 0 1,031,168 0 0 295,72 1 0 364 1,334,493 0 0 543,208 276,648 0 29,035 0 0 0 0 0 4,5 84,5 56 276,648 364 11,039 1 54,930 1,622,812 1,300 139,350 0 3,248 0 19,270 15,587 294,280 1,642,082 695, 184 0 0 2,591,246 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,52 0,242 1,907,062 703,751 412,606 3,444,544 14,561 0 1,019,426 0 267,727 6,726 4,998,461 4,892,525 10,428,254 0 0 36,650 595, 156 812,209 2, 163,408 10, 193,760 6,275,662 14,270,758 51 1,325,595 449,417 $10, 193,811 $7,601,257 $14,720, 175 - 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, 1992 General Fixed General Fixed Assets Assets 9/3 0/91 Additions Retirements Transfers 9/30/92 Function and Activity General Fund: General Government $ 5 01 ,361 $ 8,367 $ 11,810 $ 0 $ 497,918 Fiscal and Human Resources 292,654 84,070 2,150 0 374,574 Police 737,968 43,041 230,500 0 550,509 Fire 1,011,176 49,431 25,570 0 1,035,037 Development Services 312,686 23,208 30,435 0 305,459 Public Services 1,379,468 13,883 29,190 0 1,364,161 Parks 1,044,277 62,441 83, 113 0 1,023,605 Management Services 31,497 72,284 74,746 0 29,035 Other 0 1,429,621 0 0 1,429,621 Total General Fund 5,311,087 1,786,346 487,514 0 6,609,919 Special Revenue Funds: Parks Escrow 140,650 34,906 0 0 175,556 Federal Grants 2,023,722 0 0 0 2,023,722 Other 1,066,821 0 0 0 1,066,821 Total Special Revenue Funds 3,231,193 34,906 0 0 3,266,099 Capital Projects Funds: Certificates of Obligation 1,732,352 0 0 0 1,732,352 Capital Equipment 2,230,079 361, 167 0 0 2,591,246 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,734,898 489,796 0 0 7,224,694 1984 Bond Funds 9,779,925 89,781 0 0 9,869,706 1989 BondFunds 1,942,791 57,923 0 0 2,000,714 · 1991 Bond Funds 24,172 250,281 0 0 274,453 Total Capital Projects Funds 32,530,271 1,248,948 0 0 33,779,219 Contributions/Donations 0 36,650 0 0 36,650 Acquisitions Prior to July 1, 1979 -Source Undetermined 6,979,235 0 0 0 6,979,235 Construction in Progress 630,808 2,579,014 1,348,783 0 1,861,039 Total General Fixed Assets $48,682,594 $5,685,864 $(1,836,297) $ 0 $52,532, 161 - 134. STATISTICAL SECTION . 135. 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 Penalties 1983 $589,814 $228,951 $2,654,600 $226,466 $492,985 1984 25,696 299,269 2,743,848 193,065 350,244 1985 8,408 267,991 3,104,118 220,378 442,921 1986 208,481 31 5,272 3,066,168 114,971 459 ,872 1987 222,826 299,973 3,016,640 102,739 442,408 1988 (2) 967,253 340,310 4,257,621 139,412 478,114 1989 1,566,885 345,416 3,825,314 97,449 490,184 1990 1,774,601 335,94 0 4,097,742 94,691 536,155 1991 1,482,577 328,524 6,523,709 116,574 518,357 1992 1,376,970 358,949 7,209,497 216,886 684,098 (1) Revenue sharing transfers made fiscal 1980 through fiscal 1987. (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. Source: City of College Station - 136 - Charges Transfer Other Debt Service For From Enterprise Financing Property Services Funds (2) All Other Sources Tax Total $227,962 $2,097,225 $564,636 $517,768 (1) $1,724,363 $9,324,770 269,094 2,774,940 354,924 337,370 (1) 2,678,842 10,027,292 286,010 3,272,759 453,871 62 5,8 25 (1) 3,514,761 12,197,042 335,371 4,066,951 407,287 706,772 (1) 3,826,083 13,507,228 298,463 4,302,654 414,908 657,086 (1) 3,992,810 1 3,750,507 487,541 5,570,140 577,819 61,439 3,411,171 16,290,820 500,710 4,501,169 593,764 23,520 2,845,775 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 720,068 3,889,872 577,129 1,241,463 3,125,805 19,400,737 - 137 - STATISTIC AL SECTI ON CITY OF COLLEGE STATION, TEXAS GEN ERAL GOVERN MENTAL EXPEN DITURES AN D OTHER USES BY FUNCTION (1) LAST TEN FISCAL YEARS Fiscal General Year Government P olice F ire 1983 $3,592,6n $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 1992 5,507,360 3,862,849 3,034,046 (1) Expend i tures 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, re ducin g reimbursed administrative expenditures in General Fund. Source: City of College Station • 138. Public S ervices $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 2,108,406 Other Parks & Capital Reimbursed Debt Financing Recreation Outlay Administrative Service Uses Total $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 2,576,106 329,269 (2,591,911) (3) 48,483,605 0 19,669,730 • 139. Source: Current Fiscal Year 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 STATISTI CAL SECTIO N CITY OF COL LEGE STATION, TEXAS PROPERTY TAX LEVIES AND COLLEC TI ONS LAST TEN FISCAL YEARS Percent Total Tax Of Levy Tax Levy Collections Collected $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 4,506,448 4,373,907 97.06 C ity of College Station • 140. Delinquent Tax Collections $42,389 76,450 79,880 105,878 192,003 315,203 202,588 98,787 136,233 77,22.0 Total Collections Outstanding Delinquent Total As Percent Of Outstanding Taxes As A Percent Tax Collections Current Levy Delinquent Taxes Of Current Levy $2,221,231 97.16 % $135,609 5.93 % 2,573,594 98.64 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 $82,614 13.67 4,260,511 101.89 489,709 11.71 4,324,823 101.47 420,113 9.86 4,475,223 1 00.05 394,727 8.82 4,444,923 100.36 327,854 7.40 4,451,127 98.77 363,933 8.08 • 141 • -142 - Fiscal Year 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 Source: CITY OF COLLEGE STATION, TEXAS ASSESSED VALUE OF TAXABLE PROPERTIES LAST TEN FISCAL YEARS Exemptions Real Property Personal Property Real Property $695,479,501 $74,976,425 $31,709,751 775,606, 760 95,188,096 29,592,994 879,001,892 116,065,055 35,420,320 993,907,903 144,581,203 36,875,269 1,014,067,239 143,572,456 36,629,372 993,765,995 145,214,623 38,631,099 1,002,938,332 15'1,209,511 38,535,922 995,686,332 161,343, 707 38,794,667 983,973,909 156,164,603 38,658,990 1,013,892,433 150,886,397 38,166,827 Brazos County Appraisal District State Property Tax Board Report of Property Value • 143. Total $738,746,175 841,201,862 959,646,627 1, 101,613,837 1, 121,010,323 1, 100,349,519 1, 121,611,921 1, 118,235,372 1, 101,479,522 1, 126,612,003 Fiscal Year(1) 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 CITY OF COLLEGE STATION, TEXAS PROPERTY TAX RATES, RATIOS AND LEVIES ALL OVERLAPPING GOVERNMENTS LAST TEN FISCAL YEARS Tax Rates (Per $100 of Assessed Value) City School County $ .31 $.9000 $.2700 .31 .9700 .3100 .36 .9500 .3296 .38 .9780 .3253 .38 1.0790 .4170 .38 1.0790 .4170 .38 1.2100 .3427 .40 1.3000 .3689 .40 1.4400 .4105 .40 1.6800 .4399 Total(3) $1.4800 1.5900 1.6396 1.6833 1.8760 1.8760 1.9327 2.0689 2.2505 2.5199 (1) Tax rates are established by each taxing jurisdiction on an annual basis for revenues to be collected in the following fiscal year. (2) The date 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 6% 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. Source: Brazos County Appraisal District • 144 - Tax Ratios Original Tax Levies City School County City School County 100°"' 100°k 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,999,328 17,388,938 11,438,852 100 100 100 5,130,768 18,612,589 12,184,729 . 145. CITY OF COLLEGE S TATION , TEXAS PAVING ASSESSMENT COLLECTIONS LAST TEN FISCAL YEARS Percentage of Total Fiscal Current Assessments Assessments Outstanding Year Assessment Collected Collected Assessments 1983 $40,116 $32,454 25.95 % $92,591 1984 49,373 65 5.00 141,899 1985 0 45,746 32.24 96,153 1986 0 16,019 16.66 80,134 1987 0 13,433 16.76 66,701 1 988 202,546 36,913 13.71 232,334 1989 0 21,703 93.40 210,631 1990 40,926 14,251 5.67 237,306 1991 0 31,016 13.07 206,290 1992 0 4,682 2.27 201,608 Source: City of College Station Finance Department • 146. CITY OF COLLEGE STAT ION, TEXAS COMPUTATION OF LEGAL DEBT MARGIN SEPTEMBER 30, 1992 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 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 (1) (2) Source: CITY OF COLLEGE STATION, TEXAS RATIO OF NET GENERAL BONDED DEBT TO ASSESSED VALUE AND NET BONDED DEBT PER CAPITA Estimated Population 47,578 (1) 49,022 (1) 50,853 (1) 50,991 (1) 51,222 (1) 51,463 (1) 51,707 (1) 51,977 (1) 52,456 (2) 53,686 (1) LAST TEN FISCAL YEARS Assessed Value $738, 746, 175 841,201,862 959,646,627 1, 101,613,837 1, 121,010,323 1, 100,349,519 1, 121,611,921 1, 118,235,372 1, 101,479,522 1,126,612,003 Gross Bonded Debt $20,240,000 27,480,000 21,354,000 19,907,500 18,411,000 20,993,888 19,242,957 20,664,590 18,577,355 21,103,590 Metropolitan Planning Organization & City of College Station Planning Department Source: U.S. Government Preliminary Census (3) Includes general obligation debt that is serviced by the Enterprise Funds. In fiscal 1985, such debt was reflected as indebtedness of the Utility Fund. - 148 - (3) (3) Less Debt Service Cash Funds $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 856,151 Net Bonded Debt $19,284,055 26,001,360 19,603,014 17,878,655 15,850,344 19,102,916 17,362,540 19,136,087 17,430,852 20,247,439 Ratio of Net Bonded Debt To Assessed Valuation 2.61 3.09 2.04 1.62 1.41 1.74 1.55 1.71 1.58 1.80 . 149. Net Bonded Debt Per Capita $405 530 385 351 309 371 336 368 332 377 CITY OF COLLEGE STATION, TEXAS SCHEDULE OF DIRECT AND ESTIMATED OVERLAPPING DEBT SEPTEMBER 30, 1992 Taxing Body ESTIMATED OVER­ LAPPING DEBT College Station l.S.D. Brazos County Bryan 1.$.D. NET DIRECT DEBT City of College Station (2) (3) (4) NET DIRECT AND ESTIMATED OVERLAPPING DEBT *Population Net Debt Amount As Of $36,324,902 8/31/92 9,215,000 8/31/92 28,225,000 8/31/92 20,247,439 9/30/92 53,686 (1) Source: City of Co!!ege Station Finance Department (2) Source: College Station Independent School District (3) Source: Brazos County (4) Source: Bryan Independent School District . 150. Percent 82.28 % 35.77 3.54 100.00 City's Share Amount $29,888,129 999,165 Per* Capita $557 61 19 34, 183,499 637 20,247,439 377 $54,430,938 $1,014 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, Governmental Fiscal Fiscal and T otal Expenditures Year Principal Other Charg es Debt Service and Other Uses Ratio 1983 $1,195 ,929 $1,221,313 $2,417,242 (1) $10,438,959 23.16 % 1984 1,547,007 1,944,710 3,491,717 (1) 11,122,965 31.39 1985 1,361,800 2,137,815 3,499,615 11,933,349 29.33 1986 1,630,982 2,176,601 3,807,583 13,279,662 28.67 1987 1,685,439 2,020,363 3,705,802 13,089,325 28.31 1988 1,795,053 2,108,331 3,903,384 16,822,396 (2) 23.20 (2) 1989 1,852,938 1,546,888 3,399,826 15,237,461 22.31 1990 1,913,720 1,508,983 3,422,703 16,384,008 20.89 1991 2,206,493 1,464,946 3,671,439 17,838,939 20.58 1992 ·3,332,876 1,510,729 4,843,605 19,669,730 24.62 (1) 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. (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. S o u rce : City of College Station -151 - Fiscal Year 1983 1984 1985 1986 1987 1988 (1) 1989 1990 1991 1992 (1) Source: Operating Revenues $23,611,548 26,277,830 31,8f!!i7 ,897 32,480,725 32,760,614 48,138,363 37,584,613 37,108,418 35,558,916 37,524,486 CITY OF COLLEGE STATION, TEXAS UTILITY FUND SCHEDULE OF REVENUE BOND COVERAGE LAST TEN FISCAL YEARS Operating Expenses (Excluding Depreciation) $15,505,972 16,265,010 21,673,543 23,958,157 22,777,769 33,676,511 26,878,049 26,478,070 27,042,224 27,463,001 Net Revenues $8,105,576 10,012,820 10,194,354 8,522,568 9,982,845 14,461,852 10,706,564 10,630,348 8,516,692 10,061,485 Average Annual Maximum Annual Total Coverage Tot al Coverage $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,119 2.97 5,096,158 1.96 3,134,547 4.61 4,758,370 3.04 2,999;229 3.57 4,487,414 2.39 2,863,939 3.71 4,245,295 2.50 2,337,186 3.64 4,447,976 1.91 2,186,415 4.60 4,144,820 2.43 Fiscal year 1988 represents the tra ns ition from a June 30 y ear-en d to September 30. F iscal year 1 988 shows the 15 months 7/1/87 -9/30/88. City of College Station • 152. Fiscal Year 1983 1984 1985 1986 1987 1 988 1989 1990 1991 1992 (1) CITY OF COLLEGE STATION, TEXAS TOTAL BANK DEPOSITS LAST TEN FISCAL YEARS Amount $175,848,000 190,147,000 200,588,000 199, 102,000 214,443,000 135,469,000 806,100,000 703,600,000 787,700,000 769,400,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. (2) (3) (3) (3) (3) (3) Due to continued consolidation in the banking industry, total includes Bryan -College Station area banks. Source: Call reports for all Bryan/College Station area banks . • 153. James D. Ingram, III Thomas A. Wallis Agnes L. Bennett Judith W. Childs James D. Ingram, IV Richard L. Webb Melanie M. Holshouser Sharon L. Pechal Wendi M. Stratta Pu-Yu (Peggy) Wang Joan M. Voneiff INGRAM, WALLIS & COMPANY A PROFESSIONAL CORPORATION Certified Public Accountants 2100 Villa Maria, Suite 100 BRYAN, TEXAS 77802 January 22, 1993 Mayor Larry Ringer and Members of City Council of the City of College Station, Texas TELEPHONE (409) 776-2600 TELECOPIER (409) 774-7759 We have audited the general purpose financial statements of the City of College Station, Texas ("City") for the year ended September 30, 1992 and have issued our report thereon dated January 22, 1993. In connection therewith, we submit comments and recommendations concerning certain internal control, administrative and operating matters. In planning and performing our audit of the general purpose financial statements of the City for the year ended September 30, 1992, we considered its internal control structure in order to determine our auditing procedures for the purpose of expressing our 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 reportable conditions 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 organization's ability to record, process, summarize and report financial data consistent with the assertions of management in the general purpose financial statements. A material weakness is a reportable condition in which the design or operation of one or more of the internal control structure elements does not reduce to a relatively low level the risk that errors or irregularities in amounts that would be material in relation to the financial sttements being audited may occur and not be detected within a timely period by employees in the normal course of performing their assigned functions. None of the reportable conditions described in this letter is believed to be a material weakness. Page 2 January 22, 1993 our consideration of the internal control structure would not necessarily disclose all matters in the internal control structure that might be reportable conditions and, accordingly, would not necessarily disclose all reportable conditions that are considered to be material weaknesses as defined above. Cash and Investments During our review of investments, we noted that safekeeping procedures in place allow only one person to authorize the release of investments from safekeeping. As an additional measure of security, the city should consider a policy requiring two signatures authorizing the release of investments from safekeeping. Accounts Receivable In performing our accounts receivable work, we were unable to obtain a detail accounts receivable report as of year-end. The accounts receivable detail is limited as to period, meaning the report can be run as of the current date only. The City should contact their software technical support representatives to consider making the software "period sensitive" so that details can be produced for a prior period. In reviewing utility accounts receivable, it was noted that the receivable balance per utility billing did not agree with the receivable balance in accounting. Utility billing uses a separate computer system from that used by accounting. The utility billing department is unable to reconcile between the system generated accounts receivable balance and what they believe to be t�e correct balance. The accounting department receives information from utility billing regarding billings, daily deposits and adjustments. When posted by the accounting department, a different accounts receivable balance is generated which is not reconciled to that in the utility billing department. Accounting receives a summary of daily deposits and posts the total to the electric fund. An adjustment is made at month end to distribute the receipts to the other funds. We recommend that the accounting department obtain a detail of deposits from the utility billing system to aid in posting receipts and in reconciling balances. The utility billing system should be reviewed as to why the accounts receivable balance does not roll forward from month to month. Integration of the systems should be considered as part of an overall plan to eliminate the duplication of effort and to provide for ease of monthly reconciliations. Page 3 January 22, 1993 Fixed Assets The City maintains detail property records for the Utility and Sanitation Funds but not for the General Fixed Asset Group of Accounts. Additions and retirements are recorded in the detail records on an annual basis only. The City should plan and work toward performing a complete physical inventory of fixed assets and should hire or train a fixed asset accountant whose duties would include updating the detail records for property additions, obtaining information from auctions for retirements and reconciling the detail with the accounting records on a regular basis. Insurance The Risk Manager is currently able to approve payments to claimants for amounts up to $9, 999 without additional review. A policy requiring approval by someone independent of the settlement negotiation should be considered to provide additional control over these expenditures. Single Audit While reviewing expenditures, we noted that two nonqualifying expenditures were incorrectly recorded and included in the request for funds from the Department of Housing and Urban Development (HUD). One of the expenditures was subsequently corrected. We recommend that procedures be implemented to ensure a monthly review of expenditures to ensure that only qualifying expenditures are submitted to HUD. While reviewing prior year findings, we noted that no plan of corrective action had been filed as required under HUD guidelines. We recommend that all reports be reviewed and appropriate responses filed as needed. This report in intended solely for the information and use of the management and others within the organization and should not be used for any other purpose. We would like to express our appreciation to you and your staff for the cooperation extended to us during our audit. We shall be pleased to discuss the matters contained in this letter at your convenience. dr?q/l..t7Vn?/ a,kJl/;,.i/CP??�� Bryan, Texas fJ (/ January 22, 1993 James D. Ingram, III Thomas A. Wallis Agnes L. Bennett Judith W. Childs James D. Ingram, IV Richard L. Webb Melanie M. Holshouser Sharon L. Pechal Wendi M. Stratta Pu-Yu (Peggy) Wang Joan M. Voneiff Mayor Larry Ringer INGRAM, WALLIS & COMPANY A PROFESSIONAL CORPORATION Certified Public Accountants 2100 Villa Maria, Suite 100 BRYAN, TEXAS 77802 January 22, 1993 and Members of City Council of the City of College station, Texas TELEPHONE (409) 776-2600 TELECOPIER (409) 774-7759 We have audited the general purpose financial statements of the City of College Station, Texas ("City"), for the year ended September 30, 1992 and have issued our report thereon dated January 22, 1993. our professional standards require that we communicate with you concerning certain matters that may be of interest to you in fulfilling your obligation to oversee the financial reporting responsibility. We have prepared the following comments to assist you in fulfilling that obligation. OUR RESPONSIBILITY UNDER GENERALLY ACCEPTED AUDITING STANDARDS We conducted our audit of the 1992 financial statements of the City in accordance with generally accepted auditing standards. Those standards require that we plan and perform the audit to obtain reasonable, rather than absolute, assurance about whether the financial statements are free of material misstatement. When performing an audit in accordance with those standards, we are only required to obtain an understanding of the City's internal control structure sufficient to enable us to properly plan our audit. Therefore, we cannot provide any assurances about the design or operation of the internal control structures. Based, in part, on our understanding of the control environment, we designed our audit to provide reasonable assurance of detecting errors and irregularities. However, because of the characteristics of irregularities, particularly those involving forgery and collusion, a properly designed and executed· audit may not detect such items. January 22, 1993 Page 2 SIGNIFICANT ACCOUNTING POLICIES The City's significant accounting policies are disclosed in the notes to the general purpose financial statements. During the year ended September 30, 1992, there were no significant changes in previously adopted accounting policies or their application. MANAGEMENT JUDGMENTS AND ACCOUNTING ESTIMATES Accounting estimates are an integral part of the financial statements prepared by management and are based upon management's current judgments. Those judgments are normally based on knowledge and experience about past and current events and assumptions about future events. Significant accounting estimates reflected in the City's 1992 general purpose financial statements are normal and were determined on a basis consistent with that used in the prior year. SIGNIFICANT AUDIT ADJUSTMENTS We proposed no audit adj ustment that, either individually or in the aggregate, would have a significant effect on the City's financial reporting process, in our j udgment. All proposed audit adjustments, whether recorded in the accounting records or not, were reviewed with management. DISAGREEMENTS WITH MANAGEMENT We had no disagreements with management regarding the application of accounting principles, the basis for management's j udgments about accounting estimates, the scope of our audit, disclosures to be included in the financial statements or the wording of our report on the 1992 general purpose financial statements. CONSULTATION WITH MANAGEMENT Management informed us that there were no consultations with other independent public accountants reg arding accounting or auditing matters during 1992. January 22, 1993 P age 3 MAJOR ISSUES DISCUSSED WITH MANAGEMENT PRIOR TO RETENTION We discussed no ma j or accounting or auditing issues with management in connection with our retention as the City's auditors in 1992. DIFFICULTIES ENCOUNTERED IN PERFORMING THE AUDIT We experienced no difficulties in dealing with management relating to the performance of our audit. We received the full cooperation of management and staff. We believe that we have direct and unrestricted access to the city's management. This report is intended solely for the information of the Mayor and Members of the City Council and should not be used for any other purpose. We will be pleased to discuss this report with you further at your convenience.