Loading...
FY 1992-1993 -- Comprehensive Annual Financial Reportci I C I TY 0 F C 0 LL E G E ST AT I 0 N, T EX AS COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 PREPARED BY THE CITY OF COLLEGE STATION FINANCE DEPARTMENT GLENN SCHROEDER, EXECUTIVE DIRECTOR FOR FISCAL ANO HUMAN RESOURCES KATHLEEN HUBBARD, ACCOUNTING MANAGER CITY OF COLLEGE STATION. TEXAS COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 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, 1993 Combined Balance Sheet -All Fund Types and Account Groups Combined Statement of R eve nues, 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 - All Proprietary Fund Types Combined Statement of Cash Flows -All Proprietary Fund Types Notes to General Purpose Financial Statements Supplemental Combining, Comparative, Individual Fund and Account Group Statements and Schedules For The Fiscal Year Ended September 30, 1993: General Fund Comparative Balance Sheets Comparative Statements of Revenues, Expenditures and Changes in Fund Balances Schedule of Revenues and Other Financing Sources -Budget and Actual (Budgetary Basis) · Schedule of Expenditures -Budget and Actual (Budgetary Basis) (Conti n ued) - i - 3 14 15 16 19 22 26 28 30 32 35 65 66 68 70 CITY OF COLLEGE STATION. TEXAS COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 TABLE OF CONTENTS (Continued) Enterprise Funds Combining Balance Sheet Combining Statement of Revenues, Expenses and Changes in Retained Earnings Combining Statement of Cash Flows Electric Fund Comparative Balance Sheets Comparative Statements of Revenues, Expenses and Ch anges in Retained Earnings Schedule of Revenues -Budget and Actual (Budgetary Basis) Schedule of Expenses -Budget and Actual (Budgetary Basis) Water Fund Comparative B alance Sheets Comparative Statements of Revenues, Expenses and Changes in Retained Earnings Schedule of Revenues -Budget and Actual (Budgetary Basis) Schedule of Expenses -Budget and Actual (Budgetary Basis) Sewer Fund Comparative Balance Sheets Comparative Statements of RevenuE!S, Expenses and Changes in Retained Earnings Schedule of Revenues -Budget and Actual (Budgetary Basis) Schedule of Expenses -Budget and Actual (Budgetary Basis) Solid Waste C ollection Fund comparative Balance Sheets Comparative Statements of Revenues, Expenses and Changes in Retained Earnings Schedule of Revenues -Budget and Actual (Budgetary Basis) Schedule of Expenses - Budget and Actual (Budgetary Basis) (Continued) -Iv- 118 122 124 128 130 132 133 134 136 138 139 140 142 144 145 146 147 148 149 CITY OF COLLEGE STATION. TEXAS COMPREHENSIVE ANNUAL FI NANC IAL REPORT FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 TABLE OF CONTENTS (Continued) Enterprise Funds (Continued) Electric, Wat.er, Sewer and Solid Waste Collection Funds Schedule for Reconciliat.ion of Revenues and Expenses (Budgetary Basis) to GAAP Basis Stat.ement of Income Internal Service Funds Combining Balance Sheet Combining Stat.ement of Revenues , Expenses and Changes in Retained Earnings (Deficit) Combining Stat.ement of Cash Flows Employee Benefits Fund Comparat.ive Balance Sheets Comparat.ive Stat.ements of Revenues, Expenses and Changes in Deficits Schedule of Revenues and Expenses -Budget and Actual (Budgetary Basis) Fleet Replacement Fund Comparat.ive Balance Sheets Comparat.ive Stat.ements of Revenues, Expenses and Changes in Retained Earnings Schedule of Revenues and Expenses -Budget and Actual (Budgetary Basis) Landfill Fund Comparat.ive Balance Sheets Comparat.ive Stat.ements of Revenues, Expenses and Changes in Retained Earnings Schedule of Revenues and· Expenses -Budget and Actual (Budgetary Basis) Property and Casualty Fund Comparat.ive Balance Sheets Comparat.ive Stat.ements of Revenues, Expenses and Changes in Retained Earn ings (Deficits) Schedule of Revenues and Expenses -Budget and Actual (Budgetary Basis) (Continued) -v - 150 152 154 156 158 159 160 161 162 163 164 165 166 167 168 169 CITY OF COLLEGE STATION. TEXAS COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 TABLE OF CONTENTS Internal Service Funds (Continued) Unemployment Fund (Continued) Comparative Balance Sheets Comparative Statements of Revenues, Expenses and Changes in Retained Earnings Schedule of Revenues and Expenses -Budget and Actual (Budgetary Basis) Utility Billing Fund Comparative Balance Sheets Comparative Statements of Revenues, Expenses and Changes in Retained Earnings (Deficits) Schedule of Revenues and· Expenses -Budget and Actual (Budgetary Basis) Workers' Compensation Fund Comparative Balance Sheets Comparative Statements of Revenues, Expenses and Changes in Retained Earnings Schedule of Revenues and Expenses· Budget and Actual (Budgetary Basis) Internal Service Funds Schedule for Reconciliation of Revenues and Expenses (Budgetary Basis) to GAAP Basis Statement of Income General Fixed Assets Account Group Comparative Schedules of General Fixed Assets by Source Schedule of General Fixed Assets by Source -by Function and Activity Schedule of Changes in General Fixed Assets by Function and Activity STATISTICAL SECTION: General Governmental Revenues and Other Financing Sources General Governmental Expenditures and Other Uses by Function Property Tax Levies and Collections Assessed Value of Taxable Properties (Continued) ·vi · 170 171 172 173 174 175 176 177 178 180 185 186 188 190 192 194 197 CITY OF COLLEGE STATION, TEXAS COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 TABLE OF CONTENTS (Continued) Property Tax Rates, Ratios and Levies -All Direct and Overlapping Governments 198 Paving Assessment Collections 200 Computation of Legal Debt Margin 201 Ratio of Net General Bonded Debt to Assessed Value and Net Bonded Debt Per Capita 202 Schedule of Direct and Estimated Overlapping Debt 204 Ratio of Annual Debt Service Expenditures for General Obligation Debt to Total General Governmental Expenditures and Other Uses 205 Utility Funds -Schedule of Revenue Bond Coverage 206 Total Bank Deposits 207 Construction Permits 208 Principal Taxpayers 209 Principal Utility Customers 21 o Miscellaneous Statistical and Demographic Data 211 ·vii· ·viii. INTRODUCTORY SECTION -1 - ·2 · CITY OF COLLEGE STATION March 25, 1994 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, 1993, is submitted herewith. This report was prepared by the City's Accounting Divisio n of the Fiscal and Human Resource Department. Responsibility for the accuracy of the presented data and the completeness and fai rness of the presentation, i ncl ud ing all disclosures, rests with the City. We believe the data, as presented, is accurate in all material respects; that it is presented in a manner designed to fairly set forth the financial position of the City's various funds; and that all disclosures necessary to enable the reader to gain the maximum understandi ng of the City's financial affairs are included. The Comprehensive Annual Financial Report is presented in three major sections: introductory, financial, and statistical. The introductory section i ncl u d es this transmittal letter, the City's organizational chart and a list of principal elected and appointed o ffi ci als 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 financial statements and schedules. The statistical section includes selected financial and demographic i nfor mation , generally presented on a multi-yea r basis to allow for trend analysis of the finances of the City. The City is required to undergo an annual single a udit in conformity with the provisi ons of the Sing le Audit Act of 1984 and U.S. Office of Management and Budget C i rcular 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 i nclud e 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 collection and disposal; recreational activities and cultural events. The College Station Independent School District is administered by a separate, elected board and operates with its own funding sources; therefore, it has not been included in this report. -3 - THE CITY OF COLLEGE STATION The City of College Station is in East Central Texas, approximately 140 miles north of the Gulf of Mexico, conveniently located 90 miles north of Houston, 165 miles south of Dallas, and 100 miles east of Austin in Brazos County. 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. Texas A&M University has a significant economic impact on the City, contributing an estimated $562 million annually to the local economy. Texas A&M University ranked in the top ten nationally among public institutions in both enrollment and research grants for the school year beginning in September, 1993. The University has approximately 19, 100 permanent and part-time employees and has a physical plant valued in excess of $1.2 billion. In addition to the University, local 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, c hemicals, dairy products, feeds and fertilizers, modular homes, bronze castings, and geophysical survey sensors. A growing research park is located adjacent to the University. Westinghouse Defense and Electroni c 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 sq uare foot Post Oak Mall opened in 1982. Major tenants of the shopping center are Sears-Roebuck, Dillard's, Foley's, Beall's, and J.C. Penney. Major additions to the retail sector are Toys-R-Us and CineMark Theater, a new sixteen screen theater. Both busi nesses opened late in 1993. Brazos County and the City of College Station have become the major medical center for the Brazos Valley area. Scott and White opened their first medical clinic in College Station in 1986 and began a major expansion in 1993 that will increase the size of that clinic by some 50,000 square feet to 125,000 square feet. In 1987, the Brazos Valley Medical Center opened a 100 bed full service hospital, and since then, two multi-sto ry professional buildings have been added to the medical complex. One psychiatric hospital, Desert Hills, serves the Brazos Valley and is 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 somewhat insulated by the dominant effect of Texas A&M University on the local economy. Ad valorem property valuations were substantially unchanged from 1986 through 1991 with net valuations remaining at approximately $1.1 billion, as is detailed in the statistical section of this report. Total valuations in 1993 increased by approximately $62 million over 1992. Additions to the local economy included 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 fifteen (15) well sites during calendar 1993. The job market in College Station continues to be strong with Brazos County having a net increase of approximately 700 jobs in 1993 over 1992 to approximately 66,300 total jobs. The Bryan-College Station area has led the state and the nation with one of the lowest unemployment levels for the past five years. MAJOR INITIATIVES The City continues to devote significant attention to the municipal infrastructure. General obligation bonds in the amount of $2,000,000 are projected for issuance in 1994 for major street and parks construction projects. Construction is underway for the widening and upgrading of Krenek Tap Road to be completed by early 1994. A similar project is scheduled for Sebesta Road and is scheduled to begin by mid 1994. The State of Texas has begun adding two lanes to Texas Avenue bringing the roadway to a six lane divided thoroughfare. Utility relocation for this project is the responsibility of the City and is currently underway. In addition to the widening project, the City is implementing its • 4. underground conversion for major electric utility facilities. The City also has an ongoing program to reconstruct certain residential and minor collector streets . A priority listing of streets for reconstruction was developed and an annual General Fund appropri ation of approximately $400,000 h as been devoted to the various residential reconstruction projects. In May, 1990, the Cities of C ollege Station and Bryan joi ntly formed the Brazos Valley Solid Waste Management Agency (BVSWMA). BVSWMA was formed in order to achieve economies of scale in the joint operatio n and planning for a regional landfill facility. BVSWMA contracts with the City of College Station to operate the landfill site. The Agency is beginnin g initial studies to locate a new landfill site that is anticipated to have a life of up to 50 years. The agency i ntends to acquire and permit the site prior to using up the available space at its current Rock Prairie Road Landfill site that is anticipated to be full between 1997 and 2000. The City issued $4.7 million in additional utility revenue bonds in May of 1993 to fund $3.7 million in wastewater collection and treatment plant projects, and $1 million in electric distribution projects. Wastewater projects include the upgrading of the City's Carter Creek wastewater treatment plant to comply with new Environmental P rotection Agency and Texas Natural Resource Conservation Commission treatment guidelines. Electric projects include system distribution additions and underground conversion projects related primarily to the Texas Avenue widening project. Electric and wastewater capital improvement projects are anticipated to require additional utility revenue bond sales of up to $8.3 million in 1994. Long Term. During fiscal 1990, the City entered i nto a contract with the Texas M unici pal Power Agency (TMPA) cities. The City began receiving power under this contract on December 30, 1991. Under the ter ms of the contract, the City contracted as a total requirements customer of the TMPA cities. College Station's contract allows the City the opportunity to become a full partner in TMPA when additional power generating facilities are required by the member cities. 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 provision s of the Act, TMPA is a separate municipal corporation. In September, 1976, TMPA entered into identical power s al es contracts with each of the cities for the purpose of obtaining the economic advantages of jointly financing, constructing and operati ng large electric generating units and related facilities to supply the cities' future electric requirements. TMPA operates the Gibbons Creek Steam El ectri c Station , a lignite -fueled ge n erating 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 (FY94-96) capital construction program for the electric, water, and sewer utilities. Total investment in the utility system over the next several years is anticipated to be ap pr oxi m ately $65. 7 million, financed with the use of available funds on hand, revenues and the issuance of $27.9 million in utility revenue bonds. A three-year capital improvements budget was approved by the City Council as part of their deliberation on the fiscal 1993-94 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 streets, traffic signalization and sidewalk construction and $1,000,000 in bonds for park development. In December, 1991, $3,500,000 of these bonds were iss ued for streets and parks projects that were targeted for construction in 1992 and 1993. The remaining $2,000,000 of authorized bonds will be i ssued in fiscal year 1994. The City has developed a process to identify the future capital needs in the areas of streets, drainage, facilities, and parks. Future bond authorization elections w ill be required in order to fund those projects. · In May, 1992, it was announced that the George Bush Presidential Library would be located in College Station on the Texas A&M ca mpus . When completed in 1997, the library is anticipated to attract more than 400,000 visitor s per year. College Station has begun preparation for the Bush . 5. Library by placing additional emphasis in areas that will increase the appeal to visitors. Code enforcement and work in bli ghted areas has become a priority. The City has adopted a comprehensive streetscape plan to enhance the visual appeal of the community. A review of the City's comprehensive plan is included in the FY 94 Budget to address the changi ng needs of the community. Economic development in College Station takes several forms. Tour is m is expected to continue to play an important role in College Station's economy. In addition to continuing support for touris m, the m aster plan for the College Station Business Park has been completed. The plan calls for developing the Park in two phases. D etail plans are being developed for Phase I and construct ion is expected to begin by the s umme r of 1994. The 200 acre city-owned business park will attract high-tech, clean types Of industry . Several prospects are currently waiting for the completion of Phase I. The City completed Phase One of the Wolf Pen Creek Park in 1993 wi th the construction completion and grand opening of the amphitheater, which was held in the spring of 1993. The deve lopment of the master plan for this project began in 1 988 and, in addition to the amphitheater, will ulti mately include lakes, trails, botanical gardens, and various publi c and private ventures in addition to the amphitheater. FINANCIAL INFORMATION The City i s responsible for establishing and maintaining an inter nal control structure desi gned to e nsure that the assets of the City are protected from loss, theft or misuse and to ensure that adequate accounti ng data is c ompi led to allow for the preparation of financial statements in conformity with generally accepted accounting princi ples. 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 esti m ates and judgments by management. Single Audit. The City receives federal financial assistance and is responsible for ensuring that an adequate internal control structure is in place to ensure compliance with applicable laws and regulations related to those programs. This internal control structure is subject to periodic evaluation by management. Tests are made to determine the adequacy of the internal control structure, including that portion r e l ated to federal financial assistance programs, as wel l as to determine that the City has complied with appl ica ble laws and regulations. The results of the City's si ngle audit for the fiscal year ended September 30, 1993, provided no significant violations of a ppl icable laws or regu latio ns rel ati ng to fede ral financial assistance programs Of the City. Budgetary Controls. The City maintains a system of budgetary controls. The objective of these budgetary controls i s to ensu re compliance with legal provisi ons embodied in the annual budget appropriati ons ordinance approved by the City Council. Activities of the General Fund, Debt Service Fund, S pec ial Revenue Funds, Capital Projects Funds, Utility Enterprise Funds, and the Internal Service Funds are included in the budget appropriations ordinance. The level of budgetary c ontrol, that is t he level at which expenditures cannot legally exceed ap propri ations, is established at the activity level by category wi thi n each individual fund. For example, expenditures cannot exceed amounts budgeted for the control areas of personnel services, supplies, services, and capital outlay within an activity level budget of a fund. The C ity 's Budget Office monitors expenditure activity on a monthly basis against budgeted amounts and reports signif i cant variances to the City Manager. The City conti nues to meet its responsibility for sound financial management . . 6. General Fund and Debt Service Fund Revenues. The following schedule presents a summary of General Fund and Debt Service Fund revenues and other various financing sources for the fiscal year ended S eptember 30, 1993. Comparisons to the previous fiscal year have been included. Fiscal Year Percent of Revenue Source Ended 9L30/93 Total General Fund Property Tax $1,627,228 7.84% Sales and Mixed Drink Tax 7,995,877 38.52 Franchise Tax 407,168 1.96 Licenses and Permits 445,585 2.15 Fines and Penalties 893,649 4.30 Charges for Services 904,004 4.35 Transfer from Enterprise Funds for Return on.Investment 4,266,504 20.55 Miscellaneous Revenues 800,690 3.86 Other Financing Resources 68,213 0.33 Debt Service Property Tax 3,351,369 16.14 Total Revenues and Other Financing Sources $20,760,287 100.00°/0 Fiscal Year Ended 9L30L92 $1,376,970 7,209,497 358,949 216,886 684,098 720,068 3,889,872 577,129 1,241,463 3,125,805 $1 9,400, 737 Increase (Decrease) $ 250,258 786,380 48,219 228,699 209,551 183,936 376,632 223,561 (1,173,250) 225,564 $1,359,550 The most significant increase in revenue. sources during 1993 was the increase in sales tax which was up·in fiscal 1993 by 10.9% over.1992. This increase·wasthe result of the opening of several new retail establishments during the fiscal 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 105.4%, due to increased construction activity and significant increases in the fees. Fines were also up $209,551, or 30.6%, over the previous year as a result of increased efforts in collection and increased police enforcement. Parks programs continue to have increased participation, and fee increases for both parks programs and ambulance services caused Charges for Services revenues to increase by $183,936. Refunding of a short term debt instrume.nt in 1992 caused the decrease in 1993 in the Other Financing Resources category. REVENUES BY SOURCE GENERAL ANO DEBT SERVICE FUNDS FISCAL YEAR 1993 Transfer in-lieu-of taxes 20.55% $20, 760,287 ·1· Property Tax 23.98% Sales Tax & Mixed Drink Tax 38.52% Property taxes received during fiscal year 1993 were based on a tax levy of 41 .25 cents per $100 of assessed valuation. Under Texas state statutes, assessed valuation represents 100% of market value. The total assessed valuation of $1 , 188,556,991 represents a 5.5% increase from fiscal year 1992. 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 1993 1992 1991 1990 1989 General Fund $0.1350 $0.1225 $0.1325 $0.1600 $0.1400 Debt Service Fund 0.2775 0.2775 0.2675 0.2400 0.2400 Total Ad Valorem Tax Rate $0.4125 $0.4000 $0.4000 $0.4000 $0.3800 General Fund and Debt Service Fund Expenditures. The following schedule presents a summary of General Fund and Debt Service Fund expenditures for the fiscal year ended September 30, 1993. Comparisons to the previous fiscal year are included. Function Current: General Government Police Fire Public Services Parks and Recreation Library Services Less: Reimbursed Administrative Costs Other Debt Service: Principal Interest and Fiscal Charges Capital Outlay Total Expenditures Fiscal Year Ended 9l30l93 $ 5,289,911 4,054,244 3,331,309 2,266,145 2,838,541 283,478 (2,843,580) 398,100 2, 111,906 1,396,999 412,314 $19,539,367 Percent of Fiscal Year Increase Total Ended 9l30l92 (Decrease) 27.07% $ 4,934,782 $ 355,129 20.75 3,862,849 191,395 17.05 3,034,046 297,263 11.60 2,108,406 157,739 14.53 2,576,106 262,435 1.45 0 283,478 (14.55) (2,591,911) (251,669) 2.04 572,578 (174,478) 10.80 3,332,876 ( 1, 220, 970) 7.15 1,510,729 (113,730) 2.11 329,269 83,045 100.00% $19,669, 730 $ (130,363) Expenditure changes in general government operations tend to result from increases in personnel costs from year to year and from policy changes. None of the increases are due to a general area being over authorized expenditure levels. The vast majority of the $355, 129 increase in General Government activities was due to increased salary and benefit costs. The Police Department's $191,395 increase in 1993 over 1992 is due to increased personnel, supplies and other purchased services. The increase in costs of $297,263 for the Fire Department is due to personnel, supplies and other purchased services. The increase in the Public Services Department expenditures is essentially due to a carryover of a residential street reconstruction project from fiscal 1992. The Parks and Recreation Department's. expenditures increase is primarily due to increased personnel costs and supplies as well as the additional operations of the Wolf Pen Creek Amphitheater completed during 1993. Library Services show up as an additional cost center for 1993 and have been taken out of general government. Reimbursed Administrative Costs are associated with services provided to other funds within the City and the increase is related primarily to General Government activities. The category listed as Other is used to account for non-departmental ·8 · expenditures and the reduction is the result of first year start-up costs for the Fleet Replacement Fund that occurred in fiscal 1992. The $1 ,220 ,970 reduction in debt service principal payments can be attributed to a refunding of a short term debt instrument that occurred in fiscal 1992. The reduction in interest is due to a net reduction in total outstanding debt of the general government. Capital outlay tends to vary annually based on the particular needs within a fiscal year. EXPENDITURES BY FUNCTION GENERAL AND DEBT SERVICE FUNDS FISCAL YEAR 1993 $19,539,367 Debt Service 17.96% Library Services 1.45% Parks and Recreation 14.53% Public Service 11.60% Capital General Government Outlay 2. 11 % (Net of Reimbursement) 12.52% Public Safety 37.80% Other 2% General Fund Balance. The unreserved fund balance of the General Fund increased by $946,574 in 1993. This is a 37.9% increase over fiscal 1992 and provides the City with a total fund balance which is equivalent to approximately 71 days of expenditures. The City Council policy on reserve levels requires that the undesignated fund balance be at least equal to 15% of the next years net budgeted expenditures. The undesignated fund balance of $3,442,033 is approximately 19.5% of fiscal 1994 net budgeted expenditures. Utility Funds. The City of College Station operates electric, water, sewer, and solid waste services for the benefit of the citizens. The City purchases 100% of its electric power requirement 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 when TMPA and its member cities require additional generation facilities. The City is served through three 138 kVA transmission lines tied to a ring bus at the City switching station, two substations, and 21 O miles of distribution lines. Since 1981, the City has had the capability to produce and deliver 100% of its water needs through its own water well and transmission system. The water production and transmission system includes four wells with a combined capacity of 15.6 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 Carter - 9 - Creek Treatment Plant has a rated treatment capacity of 8.9 million gallons per day (mgd). The Lick Creek Treatment Plant, the newer of the two plants which came on-line during 1988, has a 500,000 gallons per day treatment capacity. The two plants have a combined treatment capacity of 9.4 mgd as compared to average current daily demand of 6 mgd. Solid Waste Collection Fund. Solid waste collection services are provided to the citizens through a combination of residential curbside pick-up and commercial container services. The Solid Waste Collection Fund shows an operating loss of $24,234 due to expensing some previously capitalized expenditures in BVSWMA. The fund is still sound with $1 ,398, 704 in net retained earnings and cash and liquid investments of $281 , 154. The fiscal year 1993 loss is an improvement of $460,812 over fiscal year 1992 when the service booked a $485,046 loss. The gain is due to rate adjustments for residential and commercial customers as well as customer growth. Summary financial information of the combined utility enterprise operations for the fiscal year ended September 30, 1993, with comparison to the previous fiscal year, is as follows: Operating Revenues: Electric Water Sewer Solid Waste Collection Other Operating Expenses: Wholesale Purchased Power Salaries and Benefits Supplies, Maintenance and Services Reimbursed Administrative Depreciation Other Nonoperating Revenues (Expenses): Interest Earnings Interest Expense Other, Net Operating Transfers In Transfer to General Fund for Return of Investment Extraordinary Loss on Refunding Net Income Fiscal Year Ended 9L30L93 $28,464,801 5,734,669 4,587,982 2,570,879 897,823 19,334,322 4,279,075 4,380,358 3,038,017 2,491,265 44,291 1,127,629 (2, 118,495) (101,827) 1,950 (4,268,454) (129,938) $ 3,199,691 Fiscal Year Ended 9L30L92 $27,320,323 5,190,561 4,251,124 1,907,028 794,321 18,637,583 4,057,429 3,759,369 2,795,476 2,246,591 181,519 1,336,480 (2,310,279) (307,751) 0 (3,889,872) 0 $ 2,613,968 Utility Billing Fund. The Utility Billing Fund, financed with user charges from the utility operating funds, was authorized in the 1989 budget. Formerly, this activity was accounted for as part of the General Fund. Utility Billing is responsible for meter reading, billing, and collections for more than 20,000.electric, water, sewer and solid waste collection accounts. During fiscal year 1993, this fund recorded net income of $166,030, an increase of $119, 104 over the $46,926 net gain in fiscal year 1992. - 10 - Employee Benefits Fund. The City of College Station has a partially 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 $150 paid by operating departments for each employee and $175 monthly paid by employees electing dependent coverage. During fiscal 1993, the plan had a net income of $31,991, as compared to a net income of $42,279 in fiscal 1992. Cost containment measures continue to be implemented as well as increases in premiums in order to bring the fund into self-sufficiency. Workers' Compensation Fund. The City of College Station has a partially self-insured workers' compensation fund that is used to account for the costs of employee claims for injuries/illnesses resulting at or from the workplace. The revenues of the fund are derived from premium charges to the various departments based on actuarial analysis of risks. The fund had a net increase of $32,747 in retained earnings for 1993 as compared to a net income of $39,542 in 1992. Unemployment Fund. The City's unemployment fund is a fully self insured fund used to account for expenses related to claims from persons who become unemployed. The fund's revenues are derived from premiums based on 0.5% of salaries paid during a fiscal year. Net income for 1993 was $29,299 versus $62,869 in 1992. ' Property and Casualty Fund. The Property and Casualty Fund is funded through property/casualty insurance premiums for a partially self-insured program of the City. Premiums are adjusted annually to meet the expenses of the fund and are based on an actuarial review of the various City departments. Net income for the fund in 1993 was $74,514 and provided retained earnings of $4,578 after a net loss of $26,447 in 1992. Fleet Replacement Fund. The Fleet Replacement Fund was established as of October 1, 1991. The revenues of the fund are derived as rents charged the departments for the various pieces of equipment used. The intent of the fund is to allow the City to maintain a safe and useful fleet of motorized equipment. Net income of the fund was $806,177 for 1993 versus $1,285,745 for 1992. The greater net income in 1992 was due to assignments to create equity for startup of the fund. Landfill Fund. The landfill operations of the City are paid for by contract with the Brazos Valley Solid Waste Management Agency (BVSWMA) as referred to above. The contract calls for the City to recover all costs associated with providing the services offered by the Landfill Operations Division. This activity is not intended to be revenue generating for the City; therefore, the operating margin is monitored in order to attempt to maintain retained earnings at a very low level. Net income for the fiscal year ended September 30, 1993, was $46,500 which increased total retained earnings to $83,934. Debt Administration. As of September 30, 1993, the City had a total of $19,593,716 in General Obligation Bonds, Certificates of Obligation, Contract Obligations and other debt relating to Governmental Fund types. That debt of $359 per capita is serviced by revenues from the local property tax. Under current state statutes, the City's ability to increase the mill levy for property taxation is subject to a maximum cap of $2.50 per $100 valuation. The Utility Funds have an additional $26, 102,815 in total debt serviced through utility charges. Cash Management. All investment activity of the City is handled in accordance with Resolution 4-12- 90-5.5, authorizing and implementing the City of College Station Investment Policy. The Investment Policy, established as required by state law and in conformity with state investment statutes, ensures the safety of all funds entrusted to the City, ensures the availability of those funds for the payment of all necessary obligations of the City, and provides for the investment of funds in interest-bearing securities. Safety of the principal invested is always the primary concern. -11 - In 1 988, 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 established with major brokerages for the purchase and sale of U.S. Government obligations 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, 1993, the City's investment portfolio consisted of the following: Bank Demand Accounts State Investment Pool Insured Certificates of Deposit U.S. Government Obligations Government Agency Notes TOTAL $ 509,700 5,730,11g 50,000 18,150,249 4,991,162 $29,431,290 The City earned $2, 161,900 on an average investment balance of approximately $29.2 million, a rate of return of 7.40%, for the year ended September 30, 1993. Compared to prior years' earnings and a market benchmark, the City's investment yield was: 9.00% 8.34% 8.00% 7.00% 6.00% $.00% 4.00% 3.00% 2.00% 1 .00% 0.00% 1991 1991 Actual 10-Blll Index RATES OF RETURN 1992 1992 Actual 10-Blll Index 1993 1993 Actual lO�Bill Index Investment results on the portfolio are compared to The Public Investor 10 bill index. This hypothetical portfolio consists of ten treasury bills with an average maturity of 80 days. Every Thursday a T-Bill matures and proceeds are reinvested alternately in three month and six month T­ Bills. This rolling index provides a.benchmark for evaluating risk-free cash management portfolios 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 $131,753 were added to investment income, fiscal 1993 rate of return was approximately 7.86%. . 12. Risk Management. The City's insurance programs are administered by the Risk Management Division 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 by the Risk Manager. OTHER INFORMATION I ndeoendent 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-128. The independent auditors' report on the general purpose financial statements and combining, individual fund and account group statements and schedules is included in the financial section of this report. The auditors' reports related specifically to the single audit are issued separately. The Government Finance Officers Association of the United States and Canada (GFOA) awarded a Certificate of Achievement for Excellence in Financial Reporting to the City of College Station for its Comprehensive Annual Financial Report for the fiscal year ended September 30, 1992. 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 eleven of the last twelve years. We believe our current report continues to conform to the Certificate of Achievement program requirements, and we are submitting it to GFOA. Acknowledgments. 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 cond ucting 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. _/d-/�}/ Glenn Schroeder Executive Director Fiscal and Human Resources Certificate of Achievement for Excellence in Financial Reporting Presented to City of College Station, Texas For its Comprehensive Annual Financial Report for the Fiscal Year Ended September 30, 1992 A Certificate of Achievement for Excellence in Rnancial Reporting is presented by the Government Rnance Officers Association of the United States and Canada to government units and public empioyee retirement systems whose comprehensive annual financial reports (CAFRs) achieve the highest standards in government accounting and financial reporting. President Jlfh-ot<�:,� Executive Director -14- APPOINTED BOAROS EXECUTIVE DIRECTOR FISCAL/HUMAN RESOURCES FINANCE BUDGET & EVALUATION ACCOUNTING/PAYROLL PURCHASING HUMAN RESOURCES RISK MANAGEMENT MUNICIPAL COURT CITIZENS OF COLLEGE STATION MAYOR AND CITY COUfllCI L MUNICIPAL JUDGE CITY ATTORNEY CITY MANAGER ASSISTANT CITY MANAGER ASSISTANT CITY MANAGER COMMUlllTY SERVICES GROUP OPERATIONS GRQJP POLICE PUBLIC UTILITIES FIRE TECHNICAL SERVICES DEVELOPMENT SERVICES ELECTRIC SERVICES PUBLIC SElVICES WATER UTILITIES FLEET SERVICES WASTEWATER UTILITIES SOLID WASTE COLLECTION PARKS & RECREATION LAND FILL OPERATION -15 - CITY SECRETARY EXECUTIVE DI MANAGEMENT SERV PUBLIC RE LATIONS/ MARKETING MANAGME NT INFORMATION UTILITY BILLING SERVICES FACILITIES MAINTENANCE ENERGY MANAGEMENT LIBRARY Elected Officials : CITY OF COLLEGE STATION. TEXAS PRINCIPAL CITY OFFICIALS SEPTEMBER 30, 1993 M ayor ............................................................................................... ; ........ Lar ry J. R inger Council Members ....................................................................................... Fred H. Brown ......................................................................................................... Vernon E.Schneider .................................................................................................................. David Hickson ................................................................................................................... Nancy Crouch ............................................................................................................. Hubbard Kennady ............................................................................................................ Lynn R. Mcllhaney City Administration: City Manager ................... ; ........................................................................... Ron Ragland Assistant City Manager for Community Services Group .............................................................. Thomas E. Brymer A$sistant City Manager for Operations Group ........................................... John C. Woody Executive Director for Management Services Group .............................. LindaS. Piwonka Executive Director for Fiscal and Human Resources Group .............................................................. Glenn Schroeder Director of Development Services ................................................................. Elrey B. Ash Fire Chief ............................................................................................ William L. Kennedy Director of P arks and Recreation ............................... , ......................... Stephen C. Beachy Personnel Director ............................................................................... Karen N. Pavlinski Police Chief .......................................................................................... Edgar .R. Feldman Acting Director of Public Services .................................................................... Mark Smith City Attorney ........................................................................................... Catherine Locke City Secretary ......................................................................................... Connie L. Hooks 16. Fl NANClAL.SECTION -17 - - 1 8 - James D. Ingram, III Thomas A. Wallis Agnes L. Bennett Judith W. Childs James D. Ingram, IV Richard L. Webb Sharon L. Pechal Wendi M. Stratta Pu-Yu (Peggy) Wang Joan M. Voneiff Diane E. Kruse INGRAM, WALLIS & COMPANY A PROFESSlONAL CORPORATlON 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 TELECOPlER (409) 774-7759 We have audited the accompanying general purpose financial statements of the City of College Station, Texas ("City"), as of September 30, 1993, 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. 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, 1993, 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 29, 1994 - 20- - 21 - CITY OF COLLEGE STATION, TEXAS COMBINED BALANCE SHEET--ALL FUND TYPES AND ACCOUNT GROUPS SEPTEMBER 30, 1993 (With comparative totals for the fiscal year ended September 30, 1992) Govern•ental Fund T)c'.(!es Special Debt General Revenue Service Assets and Other Debits Assets: Equity in Cash and Cash Equivalents (Note 2) $ 791,275 $ 206,083 $ 191,408 Equity in Invest•ents (Note 2) 2,805,429 760' 701 678,627 Receivables: Accrued Interest 131,815 34,600 30' 105 Grants 36,870 100,281 0 Letter of Credit 25,000 25,425 0 Accounts 220,643 10,469 0 Special Assess•ents 143,250 0 0 Delinquent Property Taxes (Note 3) 86,123 0 238,562 State Sales Tax (Note 1) 644,347 0 0 Notes and Loans (Note 4) 52,943 219,870 495,279 Other 141,971 0 0 Less Allowance for uncollectible Accounts (296,299) (1,377) 0 Interfund Receivable (Note 17) 0 0 0 Inventories 156,405 0 0 Prepaid Costs 13,618 0 0 Restricted Assets: Equity in Cash and Cash Equivalents (Note 2) 7,484 0 0 Equity in Invest•ents (Note 2) 76,532 0 0 Receivables: Accrued Interest 3,900 0 0 Accounts 1. 125 0 0 Special Assess•ents 0 0 0 Note Receivable fro• Joint Venture 0 0 0 Equity in Joint Venture (Note 13) 0 0 0 Advance to Other Funds (Note 17) 0 0 0 Deferred Charges, Net (Note 19) 0 0 0 Property and Equip•ent, Net (Note 5) 0 57,500 0 Other Debits: A•ount Available for Retire•ent of Bonded Indebtedness 0 0 0 A•ount to be Provided for: Accrued vacation Leave 0 0 0 Retirement of Bonded Indebtedness 0 0 0 Total Assets $51042,431 $1,413,552 $1 ,633,981 • 22. Capital Pro j ects $ 856,998 3, 166,465 143,418 28,423 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 D 0 0 0 0 0 $4,195,304 Proprietar� Fund T�pes Account Groups Totals {Me•orandu• Onl:t'.} Internal General General Long- Enterprise Service Fixed Assets Ter• Debt 1993 1992 $ 1,928,078 $ 593' 115 $ 0 $ 0 $ 4,566,957 $ 1,656,930 7,123,929 2, 191,464 0 0 16,726,615 17 ,659,917 436, 187 95,438 0 0 871,563 564,666 0 0 0 0 165,574 527,843 0 0 0 0 50,425 50,425 5,441,623 162,674 0 0 5,835,409 5, 110,393 4,794 0 0 0 148,044 206,403 0 0 0 0 324,685 363,933 0 0 0 0 644,347 571,689 0 0 0 0 768,092 830,276 461 ,451 0 0 0 603,422 788,215 (549,825) (2,425) 0 0 (849,926) (964,333) 163,922 0 0 0 163,922 153 ,393 1,490,215 0 0 0 1 ,646,620 1,368,932 3,210 4, 165 0 0 20,993 21,372 1, 715,438 0 0 0 1,722,922 447,961 6,338,264 0 0 0 6,414,796 9,550,747 189,516 0 0 0 193,416 191,345 51,567 0 0 0 52,692 52,926 1,865 0 0 0 1,865 0 758,599 0 0 0 758,599 836,819 295,597 0 0 0 295,597 350,038 1,004,357 0 0 0 1,004,357 1,168,279 401,530 0 0 0 401,530 262,530 62,619,565 1,264,067 55' 670' 181 0 119,611,313 112,888,558 0 0 0 871,871 871,871 830,953 0 0 0 579,331 579,331 568,482 0 0 0 1811421514 1811421514 2012951251 $89,8791882 $41308,498 $55,6701181 $1915931716 $1811737,545 $17613531943 The notes to the general purpose financial state•ents are an integral part of this state•ent. (Continued) -23- CITY OF COLLEGE STATION. TEXAS COMBINED BALANCE SHEET--ALL FUND TYPES AND ACCOUNT GROUPS SEPTEMBER 30, 1993 (With comparative totals for the fiscal year ended September 30, 1992) (Continued) Govern•ental Fund T:t:2es Special Debt General Revenue Service Liabilities, Equity and Other Credits Liabilities: Accounts Payable $ 293 ,016 $ 17 ,479 $ 4' 134 Retainage Payable 15,836 17,060 0 Interfund Payable (Note 17) 0 0 0 Refundable Deposits 2, 775 13,832 0 Claims Payable 0 0 0 Obligation Under Capital Lease--Current (Note 12) 0 0 0 Accrued Liabilities 315,048 5,456 24' 135 Custo•er Construction Advances 18' 190 0 0 Other Deferred Revenues 456,868 219,990 733,841 Liabilities Payable fro• Restricted Assets: Accounts Payable 0 0 0 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 Miscellaneous Accrued Liabilities 0 0 0 Long-Ter• Debt (Note 6): Revenue Bonds 0 0 0 Una•ortized Pre•iu• on 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 Advances fro• Other Funds (Note 17) 0 0 0 Accrued Vacation 0 0 0 Total Liabilities 11101.733 2731817 7621110 Equity and Other Credits: Contributed Capital 0 0 0 Invest•ent in General Fixed Assets 0 0 0 Retained Earnings (Deficit): Reserved (Note 15) 0 0 0 Unreserved 0 0 0 Fund Balances: Reserved (Note 15) 408,579 375,511 871,871 Unreserved: Designated for Subsequent Years• Expenditures 90,086 360,281 0 Undesignated 31442.033 403.943 0 Total Equity and Other Credits 319401698 111391735 8711871 Total Liabilities, Equity and Other Credits $510421431 $114131552 $116331981 - 24 • Capital Projects $ 674,628 72 '545 0 0 0 0 373 50,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7971546 0 0 0 0 1'162 ,837 1,524 ,593 710.328 313971758 $411951304 Proerietar� Fund T�ees Account Groues Totals {Me•orandu• Onl�} Internal General General Long- Entererise Service Fixed Assets Ter• Debt 1993 1992 $ 3,120,809 $562,386 $ 0 $ 0 $ 4,672,452 $ 4,989,215 4,793 17 ,045 0 0 127,279 97,495 163,922 0 0 0 163,922 153,393 0 0 0 0 16,607 13,673 0 473,910 0 0 473,910 478,098 494,221 0 0 0 494,221 451,982 329,026 20,784 0 0 694,822 614,133 32,407 0 0 0 100,597 24,004 2,626 0 0 0 1,413,325 1,483,758 275,524 0 0 0 275,524 282,524 397,537 0 0 0 397,537 331,986 189,846 0 0 0 189,846 128,327 1,834,449 0 0 0 1,834,449 1,898,082 2,335,000 0 0 0 2,335,000 2,375,000 378,955 0 0 0 378,955 370,795 26,200 0 0 0 26,200 26,200 22 0 0 0 22 0 21,835,000 0 0 0 21,835,000 19,355,000 8, 149 0 0 0 8, 149 0 1,396,660 0 0 19,014,385 20,411,045 22,879,205 131,000 0 0 0 131,000 179,814 1,332,257 0 0 0 1,332,257 1,826,479 1,004,357 0 0 0 1,004,357 1,168,279 1601902 471724 0 5791331 787.957 7681381 351453,662 1,121,849 0 1915931716 59, 1041433 5918951823 10,323,028 381'137 0 0 10, 704' 165 10,674,671 0 0 55,670, 181 0 55,670, 181 52,532, 161 15,135,172 0 0 0 15,135,172 15' 180' 091 28,968,020 2,805,512 0 0 31,773,532 27,341,664 0 0 0 0 2,818,798 1,956,788 0 0 0 0 1,974,960 5,187,410 0 0 0 0 415561304 315851335 5414261220 31186.649 55.6701181 0 122.6331112 116 I 4 58 I 120 $89.8791882 $4,308,498 $55 ! 670 ! 181 $19,593,716 $181,7371545 $176,353,943 The notes to the general purpose financial state•ents are an integral part of this state•ent. -25 - CITY OF COLLEGE STATION, TEXAS COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES ALL GOVERNMENTAL FUND TYPES For the Fiscal Year Ended September 30, 1993 (With comparative totals for the fiscal year ended September 30, 1992) Totals (Me111orandu111 Only) Revenues: Taxes Licenses and Permits Grants Charges for Services Fines, Forfeits, and Penalties Special Aasea .. ents Interest on lnvest111ents Rents and Royalties Loan Repay•ents Interest on Loans Contribution• Re.t.bursed Expenses Other Total Revenues Expenditures: Current: General Govern•ent Fiscal and Hu•an Resources C01111unity Services: AdMiniatration Police Fire OevelopMent Services Parks Public Services ... nag .. ent Services Library Services Housing Rehabilitation Reimbursed AdMinistrative Salaries and Benefits Supplies Purchased Professional Services Purchased Property Services Other Purchased Services Special Progra111s and Projects Public Agency Funding Contributions Inter.t. Assistance Inventory AdjustMent Subrecipient Projects Clearance Other General $10,030,273 445,585 39,720 904,004 893,649 58,358 342,992 50,919 10,837 0 12,225 4,488 82,697 723, 721 1,539,352 143,412 ... �.244 3,331,309 1,476, 181 2,838,541 2,266, 145 1,407,245 283,478 0 (2,843,580) 0 0 0 0 0 46,528 202,289 0 0 11,660 0 0 137,623 Special Revenue $1, 100,815 0 789,692 0 827 0 59, 799 85,352 9,432 9,059 67,300 0 26,668 2, 148,944 0 0 0 0 0 0 0 0 0 0 360,629 448,816 18,884 35,787 47,728 3,876 86,870 0 664,747 25,000 5, 148 0 0 16,249 Debt Service $3,351,369 0 0 0 0 0 131,1574 0 66, 777 0 0 0 3 0 0 1,«9 (Continued) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -26- Capital Projects $ 0 0 90,841 0 0 40,000 268,942 0 0 0 26,991 0 0 0 0 0 0 0 0 0 0 0 0 0 200,506 0 0 0 0 0 0 0 0 0 0 0 0 22,022 1993 $14,482,457 445,585 920,253 904,004 894,476 98,358 803,407 136,271 87,046 9,059 106,516 4,488 109 ,368 19,001,288 723, 721 1,539,352 143,412 4,054,244 3,331,309 1,476, 181 2,838,541 2,266, 145 1,407,245 283,478 360,629 (2, 194,258) 18,884 35,787 47,728 3,876 86,870 46,528 867 ,036 25,000 5, 148 11,660 0 16,249 161,094 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 0 368,596 (1,974,888) 0 0 0 0 0 234, 129 685,850 0 3,155 0 5,056 14,954 381,026 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, 1993 (With comparative totals for the fiscal year ended September 30, 1992) (Continued) Capital Outlay Debt Service: General $ 412,314 Principal Retirement O Interest Payments O Fiscal Charges O Bond Issuance Costs O Total Expenditures 16,030,462 Excess (Deficiency) of Revenues Over (Under) Expenditures (3,154,715) Other Financing Sources (Uses): Proceeds frOll Long-Term Debt (Note 6) 0 Sale of General Fixed Assets 68,213 Operating Transfers In (Note 11) 4,266,504 Operating Transfers Out (Note 11) 0 Total Other Financing Sources (Uses) 4,334,717 Excess (Deficiency) of Revenues and Other Financing Sources (Uses) Over (Under) Expenditures and Other Uses 1,180,002 Fund Balances, October 1 2,760,696 Fund Balances, September 30 $ 3,940,698 Special Revenue $ 64,038 0 0 0 0 1!779,221 369,723 0 0 0 (238,694) (238,694) 131,029 1,008.706 $1!1391 735 $ Debt Service 0 2,111,906 1,390,017 6,982 0 3, 508,905 40,918 0 0 0 0 0 40,918 830,953 $ 871 ,871 Capital Projects $ 3, 174,360 0 0 0 0 3,396,888 (2,970,114) 0 0 425,251 (186,557) 238,694 (2,731,420) 6, 129, 178 $ 3,397,758 The notes to the general purpose financial statements are an integral part of this statement. -27- Totals (Memorandum Only) 1993 $ 3,650,712 2,111,906 1,390,017 6,982 0 24, 715,476 ( 5 J 714 ! 188) 0 68,213 4,691,755 (425,251) 4,334,717 1992 $ 2,900,654 3,332,876 1,501,601 9,127 62,395 24,040, 720 (6 ,632, 726) 4,625,275 57,519 4,219, 769 (329,897) 8,572,666 (1,379,471) 1,939,940 10, 729,533 8, 789,593 $ 9,350,062 $ 10,729,533 Revenues: Taxes Licenses and Permits Grants Charges for Selvices Fines, Forfetts. and Penalties Special Assessments Interest on Investments Rents and Royalties Loan Repayments Interest on Loans Contributions Reimbursed Expenses Other TOO!I Revenues Expendttures: Current: General Government Fiscal and Human Resources Community Services: Administration Police Fire Development Services Parks Public Services Management Services Library Services Nondepartmental: Housing Aehabilttation Reimbursed Administrative Special Programs/Projects Public Agerq Funding Interim Assistance Clearance Code Enforcement Contributions Other Capital Outlay Expected Expendtture Savings Contingency Detx Selvice: Principal Interest and Fiscal Charges Bond Issuance Ccm T ctal Expenditures Excess (Deficiency) d Revenues Over (Under) Expenditures Other Financing Sources (Uses): Proceeds from LongTerm Debt Issuance Premium on Bonds Sold Operating Transfers In Operating Transfers Out Sale d General Fixed Assets Taal Other Financing Sources (Usesj Excess (Deficiency) d Revenues Over (Under) Expenditures and Other Financing Sources (Uses) Fund Balances, October 1 Fund Balances, September 30 CITY OF COLLEGE STATION TEXAS COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL (BUDGETARY BASIS) GENERAL. SPECIAL REVENUE, DEBT SERVICE, AND CAPITAL PROJECTS FUNDS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 General Fund Variance Favorable � � IUnfayorabfel � $9,680,624 $10,030,273 $349,649 $1,060,000 223,000 445,585 222,585 0 38,000 39,720 1,720 1,507,879 735,616 904,004 168,388 0 706,000 893,649 187,649 0 5,000 58,358 53,358 0 236,203 334,206 98,003 25,000 48,550 50,919 2,369 65,100 0 10,837 10,837 0 0 0 0 0 1,219 12,070 10,851 0 0 4,488 4,488 0 40,080 74,143 34,063 21,500 11,714,292 12,858,252 1,143,960 2,679,479 733,071 737,075 (4,004) 0 1,677,606 1,581,534 96,072 0 139,334 143,412 (4,078) 0 4,253,708 4,103,445 150,263 0 3,396,688 3,394,081 2,607 0 1,728,051 1,585,575 142.476 0 3,019,193 2,921,269 97,924 0 2,662,160 2,270,357 391,803 0 1,565,125 1,477,043 88,082 0 325,307 323,478 1,829 0 0 0 0 566,930 (2,944,852) (2,943,450) (1,402) 518,325 59,786 50,336 9,450 214,690 202,300 202,289 11 672,377 0 0 0 30,148 0 0 0 28,148 0 0 0 0 0 0 0 0 0 (138) 138 0 0 0 0 543,079 (685,000) 0 (685,000) 0 310 0 310 1,693 0 0 0 0 0 0 0 0 0 0 0 0 16,132,787 15,8"6,306 286,481 2,575,390 (4.418,495) (2,988,054) 1,430,441 104,089 0 0 0 0 0 0 0 0 4,266,504 4,266,504 0 0 0 0 0 (399,759) 20,000 68,213 48,213 0 4,286,504 4,334,717 48,213 (399,759) (131,991) 1,346,663 1,478,654 (295,670) 3,109,761 2,967,089 (142,672) 701,453 $2,977,770 $4,313,752 $1,335,982 $405,783 .29 .. Special Revenue Funds Variance Favorable Aa (l,!nflfQ:B} $1,100,815 $ 40,815 0 0 789,692 (718, 187) 0 0 827 827 0 0 59,799 34.799 85,352 20,252 9,432 9,432 9,059 9,059 67,300 67,300 0 0 26,668 5,168 2,148,944 (530,535) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 360,629 206,301 448,816 69,509 193,145 21,545 664,747 7,630 5,148 25,000 16,249 11,899 0 0 25,000 (25,000) 1,449 (1,449) 64,038 479,041 0 0 0 1,693 0 0 0 0 0 0 1,779,221 796,169 369,723 265,634 0 0 0 0 0 0 (238,694) 161,065 0 0 (238,694) 161,065 131,029 426,699 1,008,706 307,253 $1,139,735 $ 733,952 Oe!X Service Fund capital Projeds Funds Variance Variance favorable Favorable � � lUnfavorab!el � &1YS!I {Ynfavorable} $3,296,590 $3,351,369 $54,779 $ 0 $ 0 $ 0 0 0 0 0 0 0 0 0 0 269,500 90,841 (178,659) 0 0 0 0 0 0 0 0 0 0 0 <> 0 0 0 0 40,000 40,000 167,737 131,674 (36,063) 248,800 268,942 20,142 0 0 0 0 0 0 oo,m 00,777 0 0 0 0 0 0 0 0 0 0 0 0 0 0 26,991 26,991 0 0 0 0 0 0 0 3 3 0 0 0 3,531,104 3,549,823 18,719 518,300 426,774 (91,526) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 247,198 200,506 <46,692 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 22,022 (22.022) 0 0 0 10,124,700 3,174,360 6,950,340 0 0 0 0 0 0 0 0 0 250,000 0 250,000 2,273,137 2,111,906 161,231 0 0 0 1,620,517 1,390,017 230,500 0 0 0 5,000 6,982 (1,982) 0 0 0 3,898,654 3,508,905 389,749 10,621,898 3,396,888 7,133,484 (367,550) 40,918 408,468 (10, 103,598) (2,970, 114) 7,316,537 0 0 0 4,347,700 0 (4,347,700) 0 0 0 0 0 0 6,637 0 (6,637) 393,122 425,251 32,129 0 0 0 0 (186,557) (186,557) 0 0 0 0 0 0 6,637 0 (6,637) 4,740,822 238,694 (4,502, 128) (360,913) 40,918 401,831 (5,362, 776) (2. 731,420) 2,631,356 591,589 830,953 239,364 5,741,302 ' 6,129,178 387,876 $ 230,676 $ 871,871 $641,195 $ 378,526 $3,397,758 $3,019,232 The notes to the general purpose 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 ALL PROPRIETARY FUND TYPES For the Fiscal Year Ended September 30, 1993 (With comparative totals for the fiscal year ended September 30, 1992) Operating Revenues: Charges for Services Pre•iu•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 Clai1s Administration Fees Pre1iu1s Rei1bursed Ad•inistrative Depreciation and A1ortization Other Total Operating Expenses Operating Inco1e Nonoperating Revenues (Expenses): Interest Earnings Rei1bursed Expenses Contributions Earnings in Joint Venture (Note 13) Interest Expense Other, Net Total Nonoperating Revenues (Expenses) Income Before Operating Transfers $ Enterprise 41,358,331 0 897,823 42,256,154 19,334,322 4,279,075 395,937 881,877 467,297 1,812,600 822,647 0 0 0 3,038,017 2,491,265 44,291 33,567,328 8,688,826 1,127,629 170,771 0 (54,441) (2,118,495) (218,157) (1 ! 092 ! 693 ) 7,596,133 (Continued) - 30- Totals (Memorandu• Internal Service 1993 $ 3, 778, 113 $ 45,136,444 2,483,634 2,483,634 0 897,823 6,261,747 48,517,901 0 19,334,322 1,198,376 5,477 ,451 143 ,317 539,254 147,574 1,029,451 585,300 1,052,597 41,774 1,854,374 109,398 932,045 1,530,319 1,530,319 108,393 108,393 592,949 592,949 549,069 ·3,587,086 273,575 2,764,840 23,849 68, 140 5,303,893 38,871.221 957,854 9,646,680 230,864 1,358,493 0 170,771 0 0 0 (54,441) 0 ( 2' 118' 495) (1,460) (219,617) 229,404 (863,289) 1,187,258 8,783 ,391 Onl�} 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 1,307,812 118, 723 587,880 3, 196,564 2,414,435 181 ,994 35,741,219 9,402,447 1,444,518 92' 196 1,530 19,807 (2,317 ,887) (429,591) (1I189,427) 8,213,020 CITY OF COLLEGE STATION, TEXAS COMBINED STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS ALL PROPRIETARY FUND TYPES For the Fiscal Year Ended September 30, 1993 (With comparative totals for the fiscal year ended September 30, 1992) (Continued) Totals {Me•orandu• Onl�} Internal Enterprise Service 1993 Operating Transfers: Operating Transfers In $ 1,950 $ 55,480 $ 57,430 $ Operating Transfers Out (4,268,454) (55,480) (4,323,934 ) Total Operating Transfers (4,266,504) 0 (4,266,504) Inco•e Before Extraordinary Ite• 3,329,629 1, 187,258 4,516,887 Extraordinary Ite•-Loss on Refunding (Note 6) (129,938) 0 (129,938) Net Inco•e 3, 199,69 1 1,187 ,258 4,386,949 Retained Earnings, October 1 40 ,903,501 1,618,254 42,521.755 Retained Earnings, Septe•ber 30 $ 4 411 031192 $ 218051512 $ 4619081704 $ The notes to the general purpose financial state•ents are an integral part of this state•ent. - 31 - 1992 0 (3,889,872) (3,889,872) 4,323'148 0 4,323'148 38, 198,607 4215211755 CITY OF COLLEGE STATION. TEXAS COMBINED STATEMENT OF CASH FLOWS ALL PROPRIETARY FUND TYPES FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 (With Comparative Totals for the Fiscal Year Ended September 30, 1992) Tcials (Memorandum Only) Enterprise Internal Service Ft.rtds Ft.rtds 1993 Cash Flows from Operating Adivilies: Cash ReoeiYed from Customel's $41,725,568 $6,121,875 $47,847,443' Cash Payments to Suppliers for Goods and Services (28,261,750) (3,379,924) (31,641,674) Cash Paymerts to Employees for Services (4,235,296) (1, 192,049) (5,427,345) Cash OistribWon from Joint Venture 0 0 0 Customer Deposits Received 889,240 0 889,240 Customer Deposits Returned (952.873) 0 (952,873) Cash AeceiYed for Reimbursed Expenses 108,392 0 108,392 Cash Received from Sale d Scrap 18,633 0 18,633 Cash Received from Collection Fees 6,525 0 6,525 Cash Received from Mineral leases 9,515 0 9,515 Cash Received from Miscellaneous Revenues 211,768 0 211.768 Cash Paid for Special Projects (49,418) 0 (49,418) Cash Paid for Misoellaneous Expenses (11,737) 0 (11.737) Net Cash Pr<71ided by Operating Activities 9,458,567 1,549,902 11,098,469 Cash Flows from Noncapital Financing Activities: Principal Received on Nae 78,220 0 78,220 Interest RealiYed on Nae 62,852 0 62,852 Principal Received on� to Other Funds 153,393 0 153,393 Interest Received on AtNart:l:3 to Other Funds 86,635 0 86,635 Operating Transfers In From Other Funds 1,950 55,480 57,430 Operating Transfers Out to Other Funds (4,268,454) (55,480) (4,323,934) Cash Paid to Public Agencies (206,000) 0 (206,000) Advance to Other Funds 0 0 0 Net Cash Used for Noncapital Financing Activities (4,091,404) 0 (4,091,404) Cash Flows from Capital and Related Financing Activities: AcquisitiorVConstruction d Capital AssJs (5,529,261) (662,046) (6, 191,307) Proceeds from Sale of Capital Assets 21,885 127 22,012 Capital Comi>uted by Developers 64,053 0 64,053 Principal Paid on Revenue Bonds (2,375,000) 0 (2,375,000) Principal Paid on General Obligation Bonds (370,795 ) 0 (370,795) Principal Paid on Certificates d Obligation (26,200) 0 (26,200) Principal Paid on Obligation Under Capital Lease (451,983) 0 (451,983) Principal Paid on Advance to Other Funds (153,393) 0 (153,393 ) Interest Paid on Revenue Bonds (1, 720,928) 0 (1,720,928) Interest Paid on General Obligation Bonds (125,450) 0 (125,450 ) Interest Paid on Certificates d Obligation (22,008) 0 (22,008) Interest Paid on Obligation Under Capital Lease (141,016) 0 (141,016) Interest Paid on Advance to Other Funds (86,635) 0 (86,635) Fees Paid to Fiscal Agent (5,477) 0 '(5,477) Proceeds from Revenue Bonds 4,568,094 0 4,568,094 Proceeds from Advance from Other Funds 0 0 0 Cash Received from Special Assessments 0 0 0 Net Cash Used for Capital and Related Financing Activities (6,354, 114) (661,919) (7,016,033) (Continued) -32- 1992 $44,664,239 (26,503,520) (5,152, 117) 301,029 906,028 (927,050) 31,631 6,441 5,285 0 0 (32,283 ) (108,811) 13,190,872 72,318 68,658 0 0 0 (4,211,502) (120,000) (1,321,672) (5,512, 198) (5,550 ,423) 57,735 55,937 (2,475,000) (376,2 35) (26,200) (413,652) 0 (1,972,978) (118,973) (25,152) (179,347) 0 (4,130) 0 1,321,672 2,092 (9,704,654) CITY OF COLLEGE STATION. TEXAS COMBINED STATEMENT OF CASH FLOWS ALL PROPRIETARY FUND TYPES FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 (With Comparative Totals.for the Fiscal Year Ended September 30, 1992) (Continued) Taals (Memorandum Only) Cash Flows from Investing Activities: Purchase a Investments Proceeds from Sale and Maturtties a Investments Interest on Investments Other Net Cash Provided By (Used for) Investing Activtties Net Increase (Decrease) in Cash Cash and Cash Equivalents, October 1 Cash and Cash Equivalents, September 30 Reconciliation a Operating Income to Net Cash Provided by Operating Activities: Operating Income Adjustments to Reconcile Operating Income to Net Cash Provided by Operating Activities: Depreciation Amortization Provision for Uncollectible Accounts Miscellaneous Expenses Miscellaneous Revenues Change in Assets and Uabiltties: Change in Accounts Receivable Change in Other Receivables Change in Inventory Change in Prepaid Costs Change in Equity in Joint Venture Change in Aa::ounts Payable · Change in Accrued Liabilities Change in Retainage Payable Change in Deferred Revenues Change in Refundable Deposits Change in Acx:rued Vacation Taal Adjustments Net Cash Provided by Operating Activities Noncash Financing, Capital and Investing Activities: Enterprise Funds $(6,078,639) 8,845,289 811,877 0 3,578,527 2,591,576 1,051,940 $ 3,643,516 $ 8,688,826 2,491,265 6,695 (187,494) (25,906) 111,860 (530,586) 193,126 (271,702) (2,610) 0 (1,025,372) 59,585 0 7,903 (63,633) 6,610 769,741 $ 9,458,567 Internal Service Funds 1993 $(1,332,56n $(7,411,206) 720,394 9,565,683 175,013 986,890 (276) (276) (437,436) 3,141,091 450,547 3,042,123 142,568 1,194,508 $ 593,115 $ 4,236,631 $ 957,854 $ 9,646,680 273,575 2,764,840 0 6,695 2,250 (185,244) 0 (25,906) 0 111,860 (139,872) (670,458) 0 193,126 532 (271,170) (365) (2,975) 0 0 437,137 (588,235) (371) 59,214 17,045 17,045 0 7,903 0 (63,633) 2,117 8,727 592,048 1,361,789 $1,549,902 $11,008,469 The Electric, Water, and Sewer Funds issued revenue bonds in the amount a $217,250, $496,809, and $320,850, respectively, to refund debt issued in 1985. 1992 $(16,023,636) 14,532,396 1,440,574 0 (50,666) (2,076,646) 3,271,154 $ 1,194,508 $ 9,402,447 2,414,435 4,178 95,833 (15,916) 35,897 (479,son (88,546) 7,073 20 281,222 1,375,270 168,604 0 (8,672) (21,022) 19,656 3,788,425 $ 13, 190,872 Bond Issuance Costs a $42,089, $20,042, and $138,291 in the Electric, Water, and Sewer Funds, respectively, that were deducted from bond proceeds were capitalized and will be amortized over the debt repayment period. The naes to the general purpose financial statements are an integral part of this statement. -33- -34- -34- CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED S EPTEMBER 30, 1993 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES The financial statements of the City of C ollege Station, Texas ("City"), have been prepared in conformity with general ly 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 princi ples . 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 p rimary . 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 r eal or.potential financial benefit or burden for the primary government. Moreover, financial accountability also is deemed to exist even in the absence of sim ple "accountability" (i.e. the appointment of a v oting 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 r.elationship exists if the primary government (a) is entitled to the organization's resources; (b) is legally· obl igated 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 as a joint venture 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 Mayorsof 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, 1993 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(Continued) B. 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 transactions related to certain government functions or activities. A fund is a separate accounting entity with a self-balancing set of accounts. Government resources are allocated to and accounted for in individual funds based upon the purposes for which they are to be spent and the means by which s pendi ng activities are controlled. An account group, on the other hand, is a financial reporting device designed to provide accountability for certain assets and liabilities that are not recorded in the funds because they do not directly affect net expenda ble available financial resources. Funds are class ified 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 G.eneral Fund is the general operating fund of the City and is used to account for all financial resources except those required to be accounted for in another fund. Special Revenue Funds are used to account for the proceeds of specific revenue sources (other than major capital projects). The Debt Service Fund is used to account for the accumulation of resources for, and the payment of, general long­ term debt principal, interest, and related costs. C a pital Projects Funds are used to account for financial resources to be used for the acquisiti on or construction of major capital facilities (other than those financed by proprietary funds). Proprietary Fund Types Enterprise Funds are used to account for operations (a) that are financed and operated in a manner similar to private business enterprises - where the intent of the governing body is that the costs (expenses, including depreciation) of providing goods or services to the general public on a continuing basis are to be financed or recovered primarily through user charges; or (b) where the governing body has decided that periodic determination of revenues earned, expenses incurred, and/or net income is appropriate for capital maintenance, public policy, management control, accountability, or other purposes. Internal Service Funds are used to account for the financing of goods or services provided by one department or agency to other departments or agencies of the City, or to other governments, on a cost-reimbursement basis. -36 - CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 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 propri etary 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 o bligation bonds, certificates of obligation and accrued vacation leave. C. BASIS OF ACCOUNTING The accounti ng and financial reporting treatment applied to a fund is determined by its measurement focus. All governmental funds are accounted for usi ng 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 proprietary funds are accounted for on a flow of economic resources measurement focus. With this measurement focus, all assets and all liabilities associated with the operation of these funds are included on the balance sheet. Fund equity is segregated into contributed capital and retained earni ngs components. Proprietary fund-type operating statements present increases and decreases in. net total assets. The modified accrual basis of accounting is used by all governmental fund types. Under the modified accrual basis of accounting, revenues are recognized when susceptible to accrual (i.e., when they become both measurable and available). "Measurable" means the amount of the transaction can be determined and "available" means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Thoserevenues 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. Fi nes 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 li abil ity is incurred. Exceptions to this general rule are the principal ahd 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 - C ITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(Continued) All proprietary funds are accounted for using the acc rual 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 o:n a cycle-billing. basis with revenues recorded. when customers are billed, except at year-end when unbilled revenues are accrued. D. POWERCOST RECOVERY The City is allowed to recover purchased power costs as power cpst adjustments. This power cost recov�ry allows 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 y ear-end was not material. E. BUDGETS AND BUDGETARY ACCOUNTING The City follows these procedures in establishing the budgetary data refl�ed 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 prPposed expenditures and the means of financing them. 2) All budget requests are compiled by the Finance Department andpresented with comparative and supporting data to the Mayor and City Council for review. 3) Public hearings are properly advertised and conducted at City Hall for taxpayer comments. 4) Prior to September 27, the budget is legally enacted through passage of. an ordinance. 5) The City Council·must approve all transfers·of budgeted amounts between departments within any fund and any revision that alters the total expenditure of any fund. An amount is also budgeted each year for contingencies which may arise. The Council has authorized the City Manager to make budget transfers for contingencies if the amount does not exceed $10,000 .. All other transfers must be approved by City Council. City Council may transfer amounts among individual budget·line items within major expenditure.categories d1.1ring the year,.but.no such tra'lsfer may increase the overall total of the budget. Budgeted amounts as originally adopted were not significantly changed by such transfers during the year. 6) In accordance with the City Charter, the budget may be amended after the following conditions are met: a) The City Manager certifies that there are available revenues in excess of those estimated in the budget. b)The City Council holds a public hearing on the supplemental appropriation. c) The City Council approves the supplemental appropriation. 7) Expenditures in excess of appropriations for each fund are prohibited by the City Charter. Appropriations which have not been expended or lawfully e ncum bered 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, 1993 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, the Cemetery Perpetual Care Fund, or the College Station Business Park Fund which are combined with the General Fund for reporting purposes. (b) General Fund budgetary 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, 1993, on the GAAP basis to the budgetary basis are as follows: Revenues and Other Financing Sources -GAAP basis Reconciling Items: Cemetery Perpetual Care Fund Revenues Fireman's Relief Fund Revenues Other Total Reconciling Items Total Revenues and Other Financing Sources -Budget (Non-GAAP Basis) $17.210.464 (13,345) (4,265) 115 (17,495) $17, 1 92,969 Adjustments necessary to convert the General Fund expenditures at September 30, 1993, on the GAAP basis to the budgetary basis are as follows: Expenditures and Other Financing Uses-GAAP Basis Reconciling Items: Cemetery Perpetual Care Fund Expenditures Fireman's Relief Fund Expenditures Inventory Adjustment Allowance for Uncollectible Accounts Capitalized Salaries Correction of Community Development Reimbursed Administrative Transfer Other Total Reconciling Items Total Expenditures and Other Financing Uses -Budget (Non -GAAP Basis) -39 - $16,030.462 (426) (4, 175) (11,660) (134,712) 3,808 (35,058) (1 ,933) (184.156) $15.846,306 CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(Continued) Budgets for the Special Revenue Funds, Debt Service Fund, and Capital Projects Funds are adopted on a basis consistent with GAAP. Budgets for the Enterprise Funds are adopted on a basis consistent with GAAP, except for the following significant items: (a) Capital outlay is included in the budget as an expense item. (b) The budget treats principal payments for General Obligation Bonds and Certificates of Obligation serviced by the Electric, Wai.er, and Sewer Funds and for Utility Revenue Bonds as an expense item. (c) Enterprise Fund budgetary amounts do not include provisions for adjustments in inventory or the allowance for uncollectible accounts receivable. (d) B udgeted revenue amounts do not include a provision for revenue accruals. The budget for the Internal Service Funds are adopted on a basis consistent with GAAP, except that capital outlay is included in the budget as an expense item. Budgetary comparisons presented in the report are on the aforementioned budgetary basis. Budgetary amounts are as originally adopted, or as amended by t he City Council. Individual amendments were not material in relation to the original appropriai.ions which were amended. -40 - CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(Continued) F. Cash and Cash Equivalents Cash and cash equivalents are short term highly liquid investments t hat are: (a) readily conve rtible to known amou nts of cash; and (b) so near thei r maturity that they present i nsignificant risk of changes in value because of changes in interest rates. Therefore, fo r purposes of the statement of cash flows, cash and cash eq uivalents (including restricted assets) include demand accounts, repurchase agreements, and government secu rities and agency notes with original m at urities of three months or less when purc hased . The City uses a pooling method to account for cash and cash equivalents . Equity in cash and cash equivalents and interest income from t he cash pool is al located to the participating funds on a m onthly basis. The amount of the allocation is determi ned by cal culating a ratio of each fund's equity in th e pool to the total pool. G. INVESTMENTS Investments of all funds consist mainly of U. S. Treasury and Agency securities, bank certificates of deposit, and investments in public funds investment pools (TexPool). I nvestments 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 sec urities of the United States, and fully collateralized repurchase agreem ents . The repurchase ag reements must be purchased pursuant to a master repurchase agreement which speci fies that the t ransaction be held i n a safekeeping account subject to the control and custody of the City. I nvestments 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 reporti ng to the Federal Reserve Ban k of New York ("Primary Dealers"). All securities are pu rchased delivery-vs.-payment and held in the City's name in a safekeeping account at Texas Commerce Bank of Houston. Investments are made in accordance with the City's Investment Policy which was adopted by the City Council on April 12, 1990. This policy is ap plicabl e to all City funds and permits investment in ob ligati ons 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, pu blic 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 al so uses a pooling method to account for i nvestments. 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 i nvestment pool to the total pool. -41 - CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(Continued) H. INVENTORY Inventory is valued at cost, which approximates market, using the first-in, first-out method. The costs of governmental fund type and proprietary fund inventories are 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, 1993, are recorded as prepaid costs. J. RESTRICTED ASSETS In the enterprise funds, proceeds of utility revenue bonds, as well as resources set aside for their repayment, are classified as restricted assets on the balance sheet because their use is limited by applicable bond covenants. In addition, customer utility deposits are classified as restricted assets because the deposit remains the property of the customer and is not available for operations. In the General Fund, restricted assets are comprised of Municipal Court cash bonds, cemetery perpetual care funds and fireman's relief funds, all of which are not available for operations. K. INVESTMENT IN JOINT VENTURE The Proprietary Funds' investment in joint venture is recorded using the equity method of accounting. Required disclosures concerning the joint venture are presented in Note 13. L. FIXED ASSETS General fixed assets have been acquired for general government purposes. Asset purchases are recorded as expenditures in the governmental fund types and capitalized in the General Fixed Assets Account Group at cost where historical records are available and at an estimated historical cost where no historical records exist. Donated fixed assets are valued at their estimated fair market value. Public domain fixed assets consisting of improvements other than buildings are also included in the General Fixed Assets Account Group. No depreciation has been provided on general fixed assets, nor has interest been capitalized. Property and equipment owned by the Enterprise Funds and the Internal Service Funds is stated at the historical cost of acquisition, construction or, with respect to contributions of construction from third parties (principally developers), at fair market value. In accordance with Financial Accounting Standards Board Statement No. 71, interest is not capitalized during construction because interest is recovered currently in the City's established rate. -42 - CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 1. SUMMARY OF SIGNIFICANT ACCOUNTING 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 Sy stems Buildings and Improvements E quipmen t M. COMPENSATED ABSENCES 25-40years 5-50 years 3 -10 years Employees are credited with vacation at rates of 1 o to 15 days per year, depending upon le ngth 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. Em ployees 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 governme ntal 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 financ ed 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 and financed from proprietary fund operations are accounted for in those funds. All other unmatured long-term indebtedness of the City is accounted for in the General Long-Term Debt Account Group. 0. 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 govern me ntal fund types. 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, 1993 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 expenditure or legally segregated for a specific future use. Designated fund balances represent tentative plans for future use of financial resources. Q. BOND DISCOUNTS/ISSUANCE COSTS In governmental fund types, bond discounts and issuance costs are recognized as 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. lnterfund transactions other than quasi-external transactions and reimbursements are reported as operating transfers. S. STATEMENTS OF CASH FLOWS The City has elected to use the direct method in presenting the Statements of Cash Flows for each of the Proprietary and Internal Service Funds. T. MEMORANDUM ONLY -TOTAL COLUMNS Total columns on the General Purpose Financial Statements are captioned "Memorandum Only" to indicate that they are presented only to facilitate financial analysis. Data in these columns does not present fi nanc ial position, results of operations, or cash flows in conformity with generally accepted accounting principles. Neither is such data comparable to a consolidation. lnterfund eliminations have not been made in the aggregation of this data. U. COMPARATIVEDATA 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, 1993 2. DEPOSITS AND INVESTMENTS At y ear-end, the carrying amount of the City's cash and time deposits was $6,289,879, and the bank balance was $1,025,349. The City also had investments in the state investment pool amounting to $5,730, 179, and a $50,000 certific ate of deposit committed for cemetery perpetual care. Balance sheet amounts for unrestricted and restricted cash and cash equivalents at September 30, 1993, are as follows: Unrestricted cash and cash equivalents Restricted cash and cash equivalents $ 4,566,957 1.722.922 .$ 6,289.879 The bank bal ance and ce rtific ate 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, 1993, 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. G overnment Obligations $ 18,150,249 $ 19, 188,513 Government Agency Notes 4,991,162 8,379.408 Total Investments $ 231141,411 $ 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 J anu a ry 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 u p 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, 1993, was $.4125 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 1 00% of its appraised value. Real property must be reappraised at least every four years. The City may, at its own -45 - CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 3. PROPERTY TAXES-(Continued) expense, require annual reviews by the Appraisal District through various appeals and, if necessary, legal action. Under this system if the rate, excluding tax rates 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 RECEIVABLE General Fund: 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 $219,870 balance in the Special Revenue Funds represents the outstanding principal for these loans at September 30, 1993. 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 - .s. FIXED ASSETS CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 A summary of changes in general fixed assets for the year ended September 30, 1993, is as follows: Land Bui ldi ngs and Building Improvements Improvements Machinery, Tools and Equipment Parks System Construction in Progress Total Beginning Balance $ 6,899,368 13,031,574 14,270,758 10, 193,761 6,275,661 1,861,039 $52,532, 161 Additions and Transfers In $ 537,661 129,234 276,453 735,330 2,426,505 3,240,299 $7,345,482 Retirements and Transfers Out $ 0 0 0 570, 193 0 3,694,769 $4,264,962 Other $ 0 57,500 0 0 0 0 $ 57,500 A summary of proprietary fund type property and equipment at September 30, 1993, is as follows: Combined Solid Waste Fleet Utility Collection Replacement Utility Billing Landfill Funds Fund Fund .E!mst Fund Electric System $22,225,595 $ 0 $ 0 $ 0 $ 0 Water System 28,562,568 0 0 0 0 Sewer System 20,603,879 0 0 0 0 Machinery & Equipment 1,929,731 2,373,681 1,340,586 545,266 36,530 Buildings & Improvements 1,710,414 0 0 0 0 Land 955,932 0 0 0 0 Construction in Progress 7,304,501 0 0 25,028 0 Total 83,292,620 2,373,681 1,340,586 570,294 36,530 Less Accumulated Depreciation (21,813,494) (1,233,242) (216,586) (452,868) (13,889) Net $61,479,126 $1,140,439 $1,124,000 $117,426 $22,641 ......,.__,. • 47. Ending Balance $ 7,437,029 13,218,308 14,547,211 10,358,898 8,702,166 1,406,569 $55,670, 181 Total $22,225,595 28,562,568 20,603,879 6,225,794 1,710,414 955,932 7,329,529 87,613,711 (23,730,079) $63,883,632 CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEM EN TS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 6. LONG-TERM DEBT The following is a summary of long-term debt transactions for the year ended September 30, 1993: Beginning I ncurred/ Matured/ Balance Issued Retired Governmental Fund T�oes General Obligation Bonds $21,103,590 $ 0 $2,089,205 Certificates of Obligation 22,614 0 22,614 Accrued Vacation Leave 568,482 498,858 488,009 Subtotal 21 ,694,686 498,858 2,599,828 ProQriet� Fund T�QeS Utility Revenue Bonds 21,730,000 5,850,000 3,410,000 General Obligation Bonds Serviced by Utility Revenues 2,146,410 0 370,795 Certificates of Obligation Serviced by Utility Revenues 183,400 0 26,200 Accrued Vacation Leave: Electric Fund 71,359 72,689 72,307 Water Fund 28,891 34,420 27,784 Sewer Fund 34,315 31,017 35,571 Solid Waste Collection Fund 19,727 23,945 19,799 Landfill Fund 9,817 10,061 7,964 Utility Billing Collection Fund 35,790 35,599 35,579 Obligations Under Capital Lease-(Note 12) 2 ,278,461 0 451 ,983 Subtotal 26,538,170 6,057,731 4,457,982 Total Long-Term Debt $48,232,856 $6,556,589 $7,057,810 - 48 - Ending Balance $19,014,385 0 579,331 19,593,716 24,170,000 1,n5,615 157,200 71,741 35,527 29,761 23,873 11,914 35,810 1,826,478 28,137,919 $47,731,635 CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 6. LONG-TERM DEBT-(Continued) Long-term debt at September 30, 1993, consisted primarily of bonds maturing serially and is summarized as follows: General Obligation Bonds: 1968 Issue 1976 Issue 19781 Issue 1978 II Issue 1984 Issue 1987 Refunding Issue 1988 Refunding Iss ue 1989 Issue 1991 Issue Subtotal Utility Revenue Bonds: 1985 Refunding Issue 1990 Iss ue 19931ssue Subtotal General Obligation Bonds Serviced by Utility Revenues: 19761ssue 19781 Issue 1987Refunding I ssue Subtotal Certificates of Obligation Serviced by Utility Revenues: Utility Servic e Center Total I nt er est Ra tes (%) 4.40 -6.00 4.00 - 6.00 4.70 -6.00 5.15 -5.80 9.50 -11 .00 4.50 -7.70 6.15 -8.15 6.50 -8.50 5.50 -7.50 6.00- 9.50 6.50-8.50 4.05-6.50 4.00-6.00 4.70-6.00 4.50-7.70 12.00 - 49 • Series Matures 1995 1997 1998 1999 1995 2004 1996 2005 2012 2001 2006 2013 1997 1998 2004 1999 Principal Balance $ 50,000 300,000 162,000 920,000 900,000 7,957,385 1,675,000 2,625,000 4.425.000 19,014.385 13,720,000 4,600,000 5.850.000 24.170.000 900,000 738,000 137.615 1.n5,615 157.200 $45,117.200 CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 6. LONG-TERM DEBT-(Continued) Debt service requirements to maturity for all long term debt is summarized as follows: Year 1994 1995 1996 1997 1998 1 999-2003 2004-2008 2009-2012 Total Year 1994 1995 1996 1997 1998 1 999-2003 2004-2008 2�2013 Total General Obligation Bonds Principal $ 1,986,045 1,856,130 3,058,735 1,714,075 1,623,915 5,703,220 2,072,265 1,000,000 $19,014,385 Interest $ 1,231,347 1,088,804 917,863 758,759 645,186 1,831,439 529,447 112.813 $ 7.H5.o58 Certificates of Obligation Serviced by Utility Revenues Principal Interest $ 26,200 $ 18,864 26,200 15, 720 26,200 12,576 26,200 9,432 26,200 6,288 26,200 3, 144 0 0 ���---0 0 $ 157,200 $ 66.024 -50. General Obligation. Bonds Serviced by Utility Revenues Principal Interest $ 378,955 $ 79,305 378,870 59,076 386,265 40,271 385,925 22,882 181,085 9,478 56,780 11,595 7,735 298 ���-=o o $ 1.775,615 $ 222.905 Utility Revenue Bonds P ri ncipal $ 2,335,000 2,625,000 2,780,000 2,745,000 2,595,000 7,190,000 2 ,650,000 1.250.000 $24. 170.000 Interest $ 1,816,147 1,551,525 1,316,840 1,080,413 853,674 2,041,398 659,438 174,500 $ 9,493,935 CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 6. LONG-TERM DEBT-(Continued) All the net revenu es of the Utility F und 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 Util ity Fund other than certain i nterest income and expense, and depreciation and amortization. This bond resolution further requi res that the net revenues, as defined, eq ual 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 June, 1993, the City issued utility system revenue and refunding bonds in the aggregate principal amount of $5,850,000. The proceeds of this bond issue were to be used as follows: $3,700,000 for extending and improving the City's existing sanit ary sewer system; $1 ,000,000 for extending and improving the City's existing electric light and power system; and $1 , 150,000 for providing money for the advance refunding of 1985 Utility System Revenue Refunding Bonds in the amount of $1,035,000. A portion of the bond proceeds was also used for paying the costs of issuance of the bonds. As a part of this refunding transaction, the City recognized a loss of $129,938 which is reported as an extraordinary item in the financial statements of the Electric , Water, and Sewer Funds. The City expects reduced debt service requirements over the life of the refunding bonds to offset this loss. 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 i r revocable 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, 1993, the outstan ding principal balance of these defeased revenue refundin g bonds was $17,675,000. At September 30, 1993, the outstanding principal balance of the defeased general obligati on 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 $1,750,000 250,000 1,230,000 700,000 500,000 500,000 $ 4,930,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, 1993 8. CONTRACT WITH THE TEXAS MUNICIPAL POWER AGENCY The City began purchasing 100% of its electrical power requirements from the Texas Municipal Power Agency (11TMPA11) on December 30, 1991. Under this contract, TMPA shall initially provide the City with 110 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. The City's monthly electrical bill averaged $1,611, 194 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 (fMRS), one of over 613 administered by TMRS, an agent multiple-employer public employee retirement system. 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. Benefits depend upon the sum of the employee's contributions to the plan, with interest, and the City-financeq monetary credits, with interest. At the date the plan began, the City granted monetary credits for service rendered before the plan began of a theoretical amount equal to two times what would have been contributed by the employee, with interest, prior to establishment of the plan. Monetary credits for service since the plan began are 200 percent of the employee's accumulated contributions. In addition, the City can grant as often as annually another type of monetary credit referred to as an updated service credit which is a theoretical amount which, when added to the employee's accumulated contributions and the monetary credits for service since the plan began, would be the total monetary credits and employee contributions accumulated with interest if the current employee contribution rate and City matching percent had always been in existence and if the employee's salary had always been the average of his salary in the last three years that are one year before the effective date. At retirement, the benefit is calculated as if the sum of the employee's accumulated contributions with interest and the employer-financed monetary credits with interest were used to purchase an annuity. Members can retire at ages 60 and above with 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 governing body of the City, 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, 1993 9. RETIREMENT PLAN-(Continued) Contribution Requirements The contribution rate for the employees is 5%, and the City matching percent is currently 200%, both as adopted by the governing body of the City. Under the state law governing TMRS, the City 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 in 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, 1993. The unit credit actuarial cost method is used for determining the C ity 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 in fiscal year 1993 was $15,346,987 and the city's Contributions were based on a payroll of $14,658,546. Both the City and the covered employees made the req ui red contributions, amounting to $883, 753 (6.35% of covered payroll for the months in calendar year 1992, 5.21 % normal cost plus 1.14% to amortize the unfunded actuarial liability, and 5.92% for the months in calendar year 1993, 5.06% normal cost plus 0.86% to amortize the unfunded actuarial liability) for the City and $732,941 (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 1993 by 0.05% of payroll. Funding Status Even though 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 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. The pension benefit obligation shown below is similar in nature to the standardized disclosure measure required by GASB 5 for define d 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, 1992. 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 tor each City's plan, but the market value of assets for TMRS as a whole was 112.3% of book value as of December 31, 1992. - 53 • CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 9. RETIREMENT PLAN-(Continued) The total unfunded pensin benefit at December 31, 1992, the latest available information, was $2,466, 704 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 1992 $ 1,639,931 1,621,523 6.287,812 6,937,981 2.131.417 18,618,664 16,151.960 $ 2.466.704 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 $125,970 . • 54. CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 9. RETIREMENT PLAN-(Continued) Trend Information Trend information gives an i n dication of the progress made in accumulating sufficient ass et s to pay benefits when due. Applicable historical trencfinformation concerning this plan is presented below. Compl ete trend information prior to 1987 is unavail able . Additional historical trend information will be presented as it becomes available. Year Ended December30 1987 1988 1989 1 900 1991 1992 Year Ended December30 1987 1 988 1989 1990 1991 1992 Year Ended Decem ber 30 1987 1 988 1989 1990 1991 1992 Net Assets Available for Benefits $ 7,299,624 8,806,929 10,123,841 11,509,969 13,710,302 16,151,960 Unfunded P ension Benefit Obligation $ 2,553,147 2,242,546 2,347,262 2,390,149 2,112,332 2,466,704 Employer Contributions $ 680,759 652,444 730,712 822,349 878,349 883,753 -55- Pension Benefit Obligation $ 9,852,771 11,049,475 12,471,103 13,900,118 15,822,634 18,618,664 Annual Covered Payroll $12,861,559 11,028,053 11,949,309 12,971,271 13,792,527 14,658,546 Employee Contributions $ 643,995 551,417 597,473 648,573 689,686 732,941 Net Assets Available as a Percent of Pension Benefit Obligation 74% 80% 81% 83% 87% 87% Unfunded Pen sion Benefit Obligation as a Percentage of Annual Covered Payroll 20°/0 200/0 200/0 18% 15% 17% Employer Contributions as a P ercentage of Annual Covered Payr oll 5.3% 5.9% 6.1% 6.3% 6.4% 5.0% CITY OF COLLEGE STATION. TEXAS NOTES TO GENER A L PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 9. RETIREMENT PLAN-(Continued) Post Retirement Benefits In addition to providing pension benefits, the City provides certain health care benefits for retired employees as established by City Resolution No. 9-13-90-5.1 o, which was passed and approved by the City Council on S eptem ber 13, 1990. Substantially all employees may become eligible for suc h 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 Benefit Systems (see Note 14). During fiscal year 1993, 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 annua l 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 there are no additional firefighters who could become eligible for these $25 per month payments in the future. Currently, seven retirees and four widows receive benefits. Total assets of the plan are included in the G eneral Fund as a portion of the restricted cash balance. All qualitative and quantitative disclosures as required by the Governmental Accounting Standa rd s 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 mai ntains four enterprise funds. Segment information fo r the year ended Septem ber 30, 1993, is as follows (amounts in thousands): Solid Waste Electric Water Sewer Collection Fund Fund Fund Fund Total Operating Revenues: $29,048 $5,887 $4,703 $2,618 $42,256 Operating Expenses (Excluding Depreciation and Amortization) (23,463) (2,797) (2,652) (2,163) (31,075) Depreciation and Amortization (863) (n2) (555) (301) (2,491) Operating Income 4,722 2,317 1,495 154 8,688 Operating Transfers, Net (2,872) (693) (564) (138) (4,267) Extraordinary Loss on Refunding (40) (44) (46) 0 (130) Net I ncome (Loss) 2,094 717 413 (24) 3,200 Property and Equipment Additions 4,343 1,628 2,087 28 8,086 Net Working Capital 11,060 (521) 1,530 284 12,353 Total Assets 36,740 25,557 24,900 2,683 89,880 Bonds and Other Long-Term Liabilities - Excluding Current Portion 5,758 8,791 10,292 1,229 26,070 Total Equity $25,472 $14,133 $13,368 $1,454 $54,427 • 56. CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 11. OPERATING TRANSFERS Individual fund operating and other transfers out and corresponding ope.rating transfers in for fiscal 1993 were as follows: Operating Transfers Out Operating Transfers In GOB 1989 Hotel Motel Solid Waste Collection Electric Wat.er Sewer Wat.er Worker's Compensat.ion 12. COMMITMENTS AND CONTINGENCIES GOB 1982 Series II GOB 1982 Series II General General General General Sewer Property and Casualty Amount $ 186,557 238,694 138,000 2,871,704 690,600 566,200 1,950 55,480 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 Seotember 30. 1994 1995 1996 1997 1998 1999-2001 Total minimum lease payments Less imputed interest Present value of net minimum lease payments Total $ 592,999 293,586 250,813 250,813 250,813 511.379 2,150,403 (323.925) $ 1,826.478 At September 30, 1993, the City had oversized participation con struction commitments totaling $616, 151. These construction commitments result from development agreements with subdividers in .which. the City, under. certain conditions, agrees to participat.e in the cost of constructing streets, water distribution lines, sanitary sewer lines, bridges or culverts. 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, 1 993. 13. JOINT VENTURE In May 1990, the City of College Stat.ion 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 operat.ing 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, 1993 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 t he ir appraised values. The note accrues interest at a rate of 8% and is payable in semi-annual installments commenci ng November 1, 1990 and ending May 1, 2000. The City's share of BVSWMA's net loss for fiscal 1993 was $54,441. The City has been contr acted as the operator of the BVSWMA landfill. The City's Landfill Fund accounts for the operator activity, and the City is reimbursed by BVSWMA for all operating expenses of the Landfill Fund, which were $1,458,736 in 1993. The following is a summary of information from the audited financial statements of BVSWMA as of September 30, 1993, and 1992. Assets: Current Assets Property, Plant and Equipment (Net of $687,641 Accumulated Depreciation at 1993 and $439,954 at 1992) Other Assets Total Assets Liabilities : Current Liabilities Notes Payable - N oncurr ent Accrued Post Closure Maintenance Costs Total Liabilities Fund Equity: ContribLited Equity Retained Earnings (Deficit) iotal Fund Equity Total Liabilities and Fund Equity Total Operating Revenues Total Operating Expenses Operating Income (Loss) Net Nonoperating Revenues (Expenses) Net Income (Loss) 1993 $1,307,085 1,889,155 165,834 $3,362,074 $ 372,561 1,817,412 1,106,422 3,296,395 170,200 (104,521) 65,679 $3,362,074 $2,773,863 2,797,840 (23,977) (84,904) $ (108,881) - 58 - 1992 $1,163,119 2,456,823 175,834 $3,795,776 $ 460,282 2,084,664 1,076,270 3,621,216 170,200 4,360 174,560 $3,795,776 $2,090,251 1,993,006 97,245 (58,430) $ 38,815 CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 13. JOINT VENTURE-(Continued) D ebt: C ur rent Long Term Total 14. RISK MANAGEMENT $ 267,252 1,817,412 $2,084,664 $ 248,367 2,084,664 $2,333,031 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 determined based on anticipated claims for the subsequent year. The City has a stop-loss insurance policy that limits its liability to $75,000 per individual per year with an aggregate, a nnual liability of $1,200,000. The liability for outstanding losses includes $173,070 for claims incurred but not reported. The City is also self-insured for workers' compensation benefits, and the plan is administered by Old Republic Insurance Company. The C ity has a stop-loss insurance policy that li mits 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 acti viti es . In addition, interfund premiums are reported as quasi-external transactions. 15. RESERVATIONS OF FUND BALANCES AND RETAINED EARNINGS Fund balances have been reserved at September 30, 1993, 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 Property Held for Resale Total Special Revenue Funds Reserved Debt Service Fund - Reserved for Debt Se rvic e Capital Projects Funds/Reserved for Encumbrances Total Reserved F un d Balances $ 143,628 246,649 13,618 4,684 408,579 318,011 57.500 375.511 871 ,871 1 .162.837 $2,818,798 Reserved retained earnings designations for the Enter prise Funds at September 30, 1993, are as follows: Reserved for Debt Service Reserved for Capital Projects Total Reserved Retained Earnings • 59. $ 3,368,073 1 1.767.099 $15. 135, 172 CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 16. DEFICIT RETAINED EARNINGS/FUND BALANCES The Community Development Fund recorded a $275,330 deficit unreserved fund balance at the end of Fiscal 1993. This deficit can be attributed to a higher than usual amount of purchase orders that were still outstanding at September 30, 1993. Since the City has a policy of requesting grant money after actual expenditures have occurred, the fund balance in this fu nd will always be near zero. Therefore, any encumbrances recorded in the fund at year end will result in a negative unreserved fund balance. At September 30, 1993, the Employee B enefits Fund had a deficit unreserved retained earnings. This $56,448 deficit resulted from higher than expected claims and premiums during the fiscal year. 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 Capital Equipment F und showed a deficit unreserved fund balance of $567,044 at September 30, 1993. This deficit was a result of expenditures for capital projects made prior to the issuance of debt to finance capital projects. A Certificate of Obligation was issued in October, 1993, to help cover this deficit. 17. INTERFUND ASSETS/LIABILITIES On September 30, 1992, the Electric Fund loaned $1,321,672 to the Solid Waste Collection 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 Collection Fund, respectively. 18. EXPENDITURES/EXPENSES IN EXCESS OF APPROPRIATIONS The amounts of any excesses of expenditures/expenses over appropriations during fiscal 1993, and the funds in which they occurred are as follows: General Hotel/Motel Community Development Capital Equipment GOB 198211 E lectric Water Sewer Solid Waste Collection U ne mploy men t Utility Billing Fleet Replacement Landfill Property and Casualty Workers' Compensation • 60. Amount $ 10,456 28,764 39,351 21,051 971 84,630 152,145 53,138 76,418 1,283 7,689 158,997 5,289 48,461 23,349 CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEM ENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 18. EXPENDITURES/EXPENSES I N EXCESS OF APPROPRIATIONS (Continued) The $10,456 excess in the General Fund was a result of overages in the Legal and Community Services Administration Division. The amounts of each of the excesses were as follows: Legal Division: Salaries Supplies Maintenance Purchased Professional Services Other Purchased Services Community Services Administration Division: Sal.arias Purchased Professional Services Purchased Property Services Other Purchased Services $1,080 2,249 297 2,040 631 $3,099 44 363 653 A $27,278 excess in expenditures for capital outlay, a $1,449 excess for miscellaneous expenditures, and a $37 overage for public agency funding were res ponsible for the $28,764 excess in the Hotel/Motel Fund. Public agency funding expenditures exceeded the budget by $20,660 and expenditures for clearance exceeded the budget by $18,691 in the Community Development Fund. Higher than expected interest expenditures were responsible for the $21,051 excess in the Capital Equipment Fund and the $971 excess in the 1982 Series II Bond Fund. In the Electric Fund, .the following amounts made up the $84,630 excess: Depreciation Expense Special Programs/Projects Extraordinary Loss on Revenue Bond Refunding Fiscal Agent's Fees $38,158 2,044 40,287 4,141 In the Water Fund, the $152, 145 excess expenses consisted of the following: Depreciation Expense Principal Payments Interest Expense Extraordinary Loss on Revenue Bond Refunding Fiscal Agent's Fees Other Nonoperating Expenses Operating Transfers Out - 61 - $ 321 62,050 41,807 43,503 648 1,866 1,950 CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 18. EXPENDITURES/EXPENSES IN EXCESS OF APPROPRIATIONS-(Continued) The $53, 138 excess in expenses in the Sewer Fu nd were as follows: P ri ncipal Payments Interest Expense Extraordinary Loss on Revenue Bond Refunding Fiscal Agent's Fees Bond I ss uance Costs $ 2,946 3,226 46,148 688 130 Excesses of $54,100 in depreciation and $22,318 in principal payments made up the $76,418 overage in the Solid Wast e Collection Fund. Higher than expected de pr eciation expense was responsible for the $158,997 overage in the Fleet Repl ace ment Fund, the $5,289 excess in the La ndfill Fund and the $7,689 excess in the Utility Billing Fund. Higher than expected claims resulted in the $48,461 excess in the Property and C asualty Fund and the $1,283 excess in the Unemployment Fund. The $23,349 overage in the Worker's Compensation Fund can be attributed to excesses of $81 O in admini str ation fees, $18,787 in claims, and $3,752 in premiums. 19. DEFERRED CHARGES Deferred charges totaling $401 ,530 at September 30, 1993, consist of the following: Prepaid Water Costs On November 8, 1978, the City entered into an agreement with Texas A&M University whereby the City would construct water system improvements for Texas A&M University. This water system was to provide the City with an additional water source until its own syste m could be constructed beginning in January, 1979. The original agreement was for a period not to exceed fi ve years. However, an addendum to the contract extends the pe r iod indefinitely. The costs of the system are being repaid by Texas A&M University at a rate of $0.20 per 1,000 gallons of City water usage. Termination of the agreements provides for absolute titl e to the system to be conveyed to Texas A&M University by the City. A summary of the unrecovered cost of t he water system at September 30, 1993, is as follows: Total Project Cost $1, 167,075 Less Accumulated Water Usage Credits (1,016,152) Prepaid Water Costs, September 30, 1993 $ 150,923 Bond Issuance Costs A summary of the bond issuance costs along with the accumulated amortization for the Electric, Water, and Sewer Funds as of September 30, 1993, is as follows: Electric Bond Issuance Costs $62,313 Accumulated Amortization (4,344) Bond Issuance Costs, Net $57,969 Water $33,542 (2.791) $30,751 . 62. Sewer $169,455 (7,568) $161 ,887 Total $265,310 (14,703) $250,607 GENERAL FUND The general fund is used to account for resources traditionally associated with government which are not required legally or by sound financial management to be accounted for in another fund. -63- -64- CITY OF COLLEGE STATION, TEXAS GENERAL FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets Equity in Cash and Cash Equivalents Equity in Invest•ents Receivables: Accrued Interest Grants Letter of Credit Accounts Special Assess•ents Delinquent Property Taxes State Sales Tax Notes Other Less Allowance for uncollectible Accounts Inventories Prepaid Costs Restriced Assets: Equity in Cash and Cash Equivalents Equity in Invest•ents Receivables: Accrued Interest Accounts Total Assets Liabilities and Fund Balances Liabilities: Accounts Payable Retainage Payable Refundable Deposits Accrued Liabilities Custo•er Construction Advances Other Deferred Revenues Total Liabilities Fund Balances: Reserved Unreserved: Designated for Subsequent Years Expenditures Undesignated Total Fund Balances Total Liabilities and Fund Balances -65- $ $ $ $ 1993 791,275 2,805,429 131,815 36,870 25,000 220,643 143,250 86' 123 644,347 52,943 141 ,971 (296,299) 156,405 13,618 7 ,484 76,532 3,900 1 125 5,042,431 293,016 15,836 2,775 315,048 18,190 456,868 1, 101, 733 408,579 90,086 3,442,033 3,940,698 5,042,431 1992 $ 196 I 189 2,173,249 57,763 26,113 25,000 169,256 201,609 92,775 571,689 63' 781 133,637 (226, 164) 149,887 6,966 2, 119 73,479 2, 152 1 359 $ 3,720,859 $ $ 233,074 8, 109 1,360 274,241 0 443 379 960, 163 207,085 58' 152 2,495,459 2,760,696 3,720,859 CITY OF COLLEGE STATION, TEXAS GENERAL FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES For the Fiscal Years Ended September 30, 1993 and 1992 Revenues: Taxes: General Property General Sales Mixed Drinks Franchise Licenses and Permits Grants Charges for Services: Parks and Recreation Police Fire Public Services Municipal Court Development Services General Government Miscellaneous Fines, Forfeits and Penalties Special Assessments Use of Money and Property: Interest on Investments Rents and Royalties Loan Repayment Other contributions Reimbursed Expenses Other Total Revenues Expenditures: Current: General Government Fiscal and Human Resources Community Services: Administration Police Fire Development Services Parks $ (Continued) -66- 1993 1992 1,627,228 $ 1,376,971 7,901,994 7,128,294 93,883 81,203 407' 168 365,573 445,585 216,886 39,720 32,000 528,399 391,574 33,032 26,237 247' 940 251'262 5,375 3,900 31,393 25,689 40' 159 0 11,400 18,892 6,306 2,514 893,649 684,098 58,358 4,682 342,992 199, 172 50,919 46,893 10,837 0 0 153 12,225 879 4,488 4,035 82 697 68,300 12,875,747 10,929,207 723,721 668,230 1,539,352 1,435,226 143,412 130,863 4,054,244 3,862,849 3,331,309 3,034,046 1,476,181 1,265,213 2,838,541 2' 576 ,.106 CITY OF COLLEGE STATION, TEXAS GENERAL FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES For the Fiscal Years September 30, 1993 and 1992 (Continued) Public Service Manage•ent Services Library Services Rei•bursed Ad•inistrative Special Progra•s and Projects Public Agency Funding Code Enforce•ent Other Capital Outlay Total Expenditures Deficiency of Revenues Under Expenditures Other Financing Sources: Sale of General Fixed Assets Operating Transfers In Total Other Financing Sources Excess of Revenues and Other Financing sources Over Expenditures Fund Balances, October 1 Fund Balances, Septe•ber 30 -67 - 1993 $ 2,266,145 1,407,245 283,478 (2,843,580) 46,528 202,289 11,660 137,623 412,314 1610301462 ( 3 I 154 I 715) 68,213 412661504 413341717 1,180,002 2,7601696 $ 319401698 1992 $ 2,108,406 1,435,250 0 (2,591,911) 99,323 102,288 0 370,967 3291269 141826,125 (318961918) 57,519 318891872 31947,391 50,473 217101223 $ 217601696 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, 1993 Variance Favorable Budget Actual (Unfavorable) Taxes: Current Property $ 1 ,556,415 $ 1,575,854 $ 19,439 Delinquent Property 42,834 34,246 (8,588) Tax Penalty and Interest 18,000 17' 128 (872) General Sales 7,605,135 7,901,994 296,859 Mixed Drinks 73,800 93,883 20,083 Franchise 384,440 407, 168 22,728 Total Taxes 9,680,624 10,030,273 349,649 Licenses and Per•its: Mixed Drinks 11,500 13' 187 1,687 Game Machines 2,500 1,431 (1,069) Professional/Occupational 18,760 31,633 12,873 Oil and Gas 0 58,893 58,893 Builders Permits 133,000 255,929 122,929 Electrical Per•its 19,950 27,385 7,435 Plu•bing Per•its 37,240 43,994 6,754 Other 50 13!133 13,083 Total Licenses and Per•its 223,000 445,585 222,585 Grants 38,000 39,720 1!720 Charges for Services: Parks Concessions 89,900 115,643 25,743 Pool Admissions 120,000 147,772 27,772 Sports Instruction 56,400 70,645 14,245 Sports Programs 136,800 161,692 24,892 Special Events 21,500 29,277 7,777 Teen Center 600 2,847 2,247 Other Parks 10,700 524 (10, 17 6) Police Hazardous Materials Response 0 527 527 Fingerprinting 1, 100 1,470 370 Police Reports and Records Checks 7,020 6,755 (26�) Arrest Fees 0 4,644 4,644 Warrant Service Fees 421 4,077 3,656 Police Escort Services 1,950 750 (1,200) False Alar•s 10,000 14,450 4,450 Other Police 0 360 360 EMS Transport 223, 195 242,088 18,893 (Continued) -68- 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, 1993 (Continued) Fire Inspections Other Fire Fire Hazardous Material Response Street Sweeps and Repairs Municipal Court Inspection Fees Filing Fees Oil and Gas Pipeline Fees General Government Other Total Charges for Services Fines, Forfeits and Penalties: Municipal Court Fines Other Fines and Penalties Total Fines, Forfeits and Penalties Special Assessments Use of Money and Property: Interest on Investments Rents and Royalties Loan Repayment Total Use of Money and Property Miscellaneous: Contributions Reimbursed Expenditures Other Total Miscellaneous Total Revenues Other Financing Sources: Payments in Lieu of Taxes Sale of General Fixed Assets Total Other Financing Sources Total General Fund Revenues $ Budget 3,430 50 5,000 3,000 24,200 7,350 0 0 11,200 1,800 735,616 706,000 0 706,000 5,000 236,203 48,550 0 284,753 1'219 0 40,080 41,299 11,714,292 4,266,504 20,000 4,286,504 $16,000,796 -69 - $ Actual 2,436 0 3,416 5,375 31,393 7,705 10,692 21,761 11,400 6,305 904,004 888,649 5,000 893,649 58,358 334,206 50,919 10,837 395,962 12,070 4,488 74 143 90,701 12,858,252 4,266,504 68,213 4,334,717 $17 I 192 ! 969 variance Favorable (Unfavorable) $ (994) (50) ( 1'584) 2,375 7' 193 355 10,692 21,761 200. 4,505 168,388 182,649 5,000 187,649 53,358 98,003 2,369 10,837 111 I 209 10' 851 4,488 34,063 49,402 1,143,960 0 48,213 48,213 $ 1 ! 192 ! 173 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1993 Budget Actual -70 - variance Favorable (Unfavorable) CITY OF COLL EGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITUR ES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1993 (Continued) Budget Actual Fiscal and Human Resources: Finance Administration: Salaries and Benefits $ 98,331 $ 97,343 supplies 3,940 3,937 Maintenance 410 339 Purchased Professional Services 15,500 14,875 Purchased Property services 1'160 1,066 Other Purchased Services 101692 101684 Total Finance Administration 1301033 128,244 Hu•an Resources: Salaries and Benefits 182,479 182,472 Supplies 13,895 13' 197 Maintenance 240 235 Purchased Professional Services 3,090 2,535 Purchased Property Services 1,820 1,494 Other Purchased Services 40,338 40,333 capital Outlay 41010 4 001 Total Human Resources 2451872 2441267 Accounting: Salaries and Benefits 329,660 297,865 Supplies 13,460 13,450 Maintenance 2, 174 1,560 Purchased Professional Services 133,436 131,424 Purchased Property Services 2,950 2,585 Other Purchased Services 54,043 47,646 Capital Outlay 101961 51280 Total Accounting 5461684 4991810 Purchasing and Stores: Salaries and Benefits 148,073 146,853 Supplies 4,250 4, 124 Maintenance 1,250 801 Purchased Professional Services 4,960 3,540 Purchased Property services 1,790 1,783 Other Purchased Services 15,696 15,630 Capital Outlay 5,700 51700 Total Purchasing and Stores 1811719 1781431 (Continued) - 71 - Variance Favorable {Unfavorablel $ 988 3 71 625 94 8 789 7 698 5 555 326 5 9 11605 31,795 10 614 2,012 365 6,397 51681 461874 1,220 126 449 1,420 7 66 0 3,288 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1993 (Continued) Budget Actual Budget and Evaluation: Salaries and Benefits $ 130,680 $ 123,494 Supplies 2,050 2,045 Maintenance 410 409 Purchased Professional Services 12,982 12, 109 Purchased Property services 830 779 Other Purchased Services 12,040 12,032 Capital Outlay 51018 41244 Total Budget and Evaluation 1641010 1551112 Municipal Court: Salaries and Benefits 192,832 164,729 Supplies 11,035 11,028 Maintenance 875 682 Purchased Professional Services 37,285 37,271 Purchased Property Services 16,230 12,853 Other Purchased Services 30,452 30,438 Capital Outlay 201695 201692 Total Municipal Court 3091404 2771693 Risk Management: Salaries and Benefits 85,943 85,928 Supplies 2,411 1 ,994 Maintenance 140 140 Purchased Professional Services 830 822 Purchased Property Services 410 307 Other Purchased Services 8, 771 7,407 Capital Outlay 11379 11379 Total Risk Management 991884 97:977 Total Fiscal and Human Resources 116771606 115811534 (Continued) -72 - Variance Favorable {Unfavorable} $ 7' 186 5 873 51 8 774 81898 28, 103 7 193 14 3,377 14 3 31 711 15 417 0 8 103 1,364 0 1 907 961072 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1993 (Continued) Co••unity services Ad•inistration: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Total Co••unity Services Ad•inistration Police: Police Ad•inistration: Salaries and Benefits Supplies Maintenance Purchased Professional Services Other Purchased Services capital Outlay Total Police Administration Unifor• Patrol: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services capital Outlay Total Unifor• Patrol Cri•inal Investigation: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Cri•inal Investigation $ Budget 119,489 1,500 70 0 730 17 ,545 1391334 280,782 8,500 1,300 700 32,505 2,455 326,242 1,889,644 75,230 44,320 21,720 1 ,610 184 ,430 431775 2,260,729 444,226 14,080 9, 160 18,300 2,360 35,010 2,800 525,936 (Continued) -73- Actual $ 122,588 1,436 54 44 1,093 18I197 1431412 280,690 5,316 1,217 0 29,751 21231 319,205 1,882,953 68,003 44 ,317 21, 717 521 180,845 43,772 2,242,128 386,649 12' 100 6, 138 18,293 1,643 30, 108 2,797 4571728 Variance Favorable (Unfavorable) $ (3,099) 64 16 (44) (363) (652) {41078) 92 3, 184 83 700 2,754 224 7 037 6,691 7,227 3 3 1,089 3,585 3 18,601 57,577 1,980 3,022 7 717 4,902 3 681208 Special Services: Salaries and Benefits Supplies Maintenance CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1993 (Continued) Budget Actual $ 224,473 $ 220,130 40,360 36,682 2,476 1'199 Purchased Professional Services 58,730 53,565 Purchased Property Services 1,128 808 Other Purchased Services 30,711 30,696 Capital Outlay 400 400 Total Special Services 358,278 343,480 Technical Services: Salaries and Benefits 217,275 217,268 Supplies 16, 130 12,928 Maintenance 11,130 8, 180 Purchased Property Services 61'510 55,416 Other Purchased Services 31!135 25,896 Total Technical Services 337t180 319,688 Com•unications/Jail: Salaries and Benefits 396,278 386,725 Supplies 13,400 5,015 Maintenance 14,615 12' 190 Purchased Professional Services 2,000 1,453 Other Purchased Services 19,050 15,833 Total Co••unications/Jail 445,343 421.216 Total Police 412531708 411031445 (Continued) -74- variance Favorable (Unfavorable) $ 4,343 3,678 1,277 5, 165 320 15 0 14,798 7 3,202 2,950 6,094 5,239 17 492 9,553 8,385 2,425 547 3 217 24 ! 127 1501263 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1993 (Continued) Budget Actual Fire: Fire Ad•inistration: Salaries and Benefits $ 343, 119 $ 343,105 Supplies 4,899 4,877 Maintenance 1,480 1,451 Purchased Professional services 155 78 Purchased Property services 6,530 6,488 Other Purchased Services 18,078 18,073 Capital Outlay 270 269 Total Fire Administration 374 ,531 374,341 Fire Suppression: Salaries and Benefits 2,608,533 2,608,509 Supplies 64' 195 63,603 Maintenance 38,236 38,206 Purchased Professional Services 14,060 13,953 Purchased Property Services 30,600 30,564 Other Purchased Services 84,089 84,082 Capital Outlay 53,705 53,670 Total Fire Suppression 2,893,418 2,892,587 Fire Prevention: Supplies 12,420 11,803 Maintenance 3,480 3,479 Purchased Professional Services 300 0 Purchased Property Services 0 Other Purchased services 17,215 17J133 Capital·Outlay 10,580 10,570 Total Fire Prevention 43,995 42,986 Emergency Medical services: Supplies 23,620 23,492 Maintenance 6,400 6,054 Purchased Professional Services 6,000 6,000 Purchased Property Serives 250 203 Other Purchased Services 45,974 45,952 Capital Outlay 2,500 2,466 Total Emergency Medical Services 84 744 84I167 Total Fire 3,396,688 3,394,081 (Continued) - 75- Variance Favorable (Unfavorable) $ 14 22 29 77 42 5 190 24 592 30 107 36 7 35 831 617 1 300 ( 1) 82 10 1,009 128 346 0 47 22 34 577 2,607 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPE ND ITURES BUDGET AND ACTUAL (BUDGET ARY BASIS) For the Fiscal Year Ended September 30, 1993 (Continued) Budget Actual Develop•ent Services: Develop•ent Services Administration: Salaries and Benefits $ 147,329 $ 147,322 supplies 4,720 4,696 Maintenance 3,490 3,033 Purchased Professional Services 30 22 Purchased Property Services 1,470 1,454 Other Purchased Services 16,240 16,236 Capital Outlay 251 250 Total Development Services Administration 173,530 173,013 Engineering: Salaries and Benefits 456,063 389,059 Supplies 25, 167 23,267 Maintenance 3,830 3,239 Purchased Professional Services 21,758 11,661 Purchased Property services 5,410 4,434 Other Purchased services 42,521 42,068 Capital Outlay 25,249 17 911 Total Engineering 579,998 491,639 Planning: Salaries and Benefits 767,986 764,637 Supplies 35,364 26,255 Maintenance 9,670 3,666 Purchased Professional Services 21,270 10,493 Purchased Property Services 9,760 9,416 Other Purchased Services 83,221 76,755 Capital Outlay 47,252 29,701 Total Planning 974,523 920,923 Total Development Services 11 7281051 115851575 (Continued) - 76 - Variance Favorable (Unfavorable) $ 7 24 457 8 16 4 517 67,004 1,900 591 10,097 976 453 7,338 88,359 3,349 9, 109 6,004 10, 777 344 6,466 17 ,551 53,600 1421476 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year E n ded September 30, 1993 (Continued) Budget Actual Parks: Parks Ad•inistration: Salaries and Benefits $ 253,520 $ 250,865 supplies 7,960 7,075. Maintenance 2,570 2,001 Purchased Property Services 2,030 1,369 Other Purchased Services 30,370 27,849 capital Outlay 141370 61666 Total Parks Ad1inistration 3101820 2951825 Recreation: Salaries and Benefits 385,985 385,952 Supplies 92,470 91, 170 Maintenance 4,540 3,351 Purchased Professional Services 87,060 85,701 Purchased Property services 77,115 71,834 Other Purchased Service 49, 180 47,271 Capital Outlay 121952 121947 Total Recreation 7091302 6981226 Special Facilities: Salaries and Benefits 466,777 461,820 Supplies 69,730 68,780 Maintenance 39, 747 37,297 Purchased Professional Services 9,810 8,838 Purchased Property Services 111,900 107 ,930 Other Purchased Services 47,290 44,803 Capital Outlay 131780 131700 Total Special Facilities 7591034 743z168 Parks Maintenance: Salaries and Benefits 550,288 544,454 Supplies 37,720 34,042 Maintenance 76,375 74,342 Purchased Professional Services 3,090 2, 135 Purchased Property Services 91,840 91,355 Other Purchased Services 38,430 37,972 capital Outlay 311910 30.765 Total Parks Maintenance 8291653 8151065 Forestry: Salaries and Benefits 265,624 243,475 Supplies 19,920 14,931 Maintenance 39,350 30,833 Purchased Professional services 26,540 23' 125 Purchased Property Services 20,430 20,365 Other Purchased Services 22, 150 20,323 Capital Outlay 161370 151933 Total Forestry 4101384 3681985 Total Parks 310191193 2,9211269 (Continued) - 77- Variance Favorable !Unfavorable} $ 2,655 885 569 661 2,521 7 704 141995 33 1,300 1, 189 1,359 5,281 1,909 5 111076 4,957 950 2,450 972 3,970 2,487 80 151866 5,834 3,678 2,033 955 485 458 145 141588 22' 149 4,989 8,517 3,415 65 1,827 437 41 399 97 924 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1993 (Continued) Budget Actual Public Services: Public Services Ad•inistration: Salaries and Benefits $ 187,639 $ 187,622 supplies 4,000 3,975 Maintenance 1,660 850 Purchased Professional Services 30 22 Purchased Property Services 14,820 14,813 Other Purchased Services 22,120 22' 101 capital Outlay 600 600 Total Public Services Ad•inistration 2301869 2291983 Streets Maintenance: Salaries and Benefits 528,972 500,706 Supplies 25,558 25,558 Maintenance 881, 158 616,162 Purchased Professional Services 60, 125 13' 165 Purchased Property Services 20,690 20,680 Other Purchased services 147,111 141,805 Capital Outlay 31362 31362 Total Streets Maintenance 11666,976 113211438 Drainage Maintenance: Salaries and Benefits 109, 100 108,214 Supplies 2,640 2,620 Maintenance 9,650 8,227 Purchased Property services 4,880 4,872 Other Purchased Services 301350 291980 Total Drainage Maintenance 1561620 1531913 Fleet Services: Salaries and Benefits 392' 126 381,356 Supplies 26,076 22,114 Maintenance 11,650 9,989 Purchased Professional Services 1 ,030 442 Purchased Property Services 15,930 12,609 Other Purchased Services 25,500 22,824 Capital Outlay 260 250 Total Fleet Services 4721572 4491584 Traffic Salaries and Benefits 92,243 89,957 Supplies 3,030 2,218 Maintenance 31,020 19,506 Purchased Professional Services 5,000 22 Purchased Property services 790 700 Other Purchased Services 31040 31036 Total Traffic 1351123 1151439 Total Public Services 21662!160 2,2701357 (Continued) -78 - Variance Favorable (Unfavorable) $ 17 25 810 8 7 19 0 886 28,266 0 264,996 46,960 10 5,306 0 3451538 886 20 1,423 8 370 2 707 10,770 3,962 1'661 588 3,321 2,676 10 221988 2,286 812 11,514 4,978 90 4 19 684 391,803 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES B UDG ET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1993 (Continued) Budget Actual Manage•ent Services: Manage•ent Services Administration: Salaries and Benefits $ 104 ,683 $ 104,667 supplies 2,960 2,576 Maintenance 858 858 Purchased Property Services 380 355 Other Purchased Services 5,037 4,210 capital Outlay 11200 11200 Total Manage•ent Services Administration 1151118 1133866 Public Relations: Salaries and Benefits 163,709 161,811 Supplies 3,935 3,457 Maintenance 7,850 7,370 Purchased Professional Services 70 66 Purchased Property Services. 1,230 1,039 Other Purchased Services 24,425 20,476 Capital Outlay 81700 71557 Total Public Relations 2091919 2011776 Energy Manage•ent Services: Salaries and Benefits 140, 551 140, 131 Supplies 6,680 6,060 Maintenance 1,035 586 Purchased Professional Services 39,010 10,905 Purchased Property Services 1,320 701 Other Purchased Services 14,666 14,530 capital Outlay 131400 131241 Total Energy Manage•ent Services 2161662 1861154 Management Information services: Salaries and Benefits 279,300 272,417 supplies 3,630 3,624 Maintenance 207,249 198,887 Purchased Professional Services 80 69 Purchased Property Services 5,920 5,911 Other Purchased Services 22,725 22,714 Capital Outlay 201901 201892 Total Management Infor1ation Services 5391805 5241514 (Continued) -79 - Variance Favorable (Unfavorable) $ 16 384 0 25 827 0 11252 1,898 478 480 4 191 3,949 1 143 81143 420 620 449 28, 105 619 136 159 301508 6,883 6 8,362 11 9 11 9 151291 CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES BUDGET AND ACTUAL (BUDGETARY BASIS) For the Fiscal Year Ended September 30, 1993 (Continued) Facilities Maintenance: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Facilities Maintenance Total Manage•ent Services Library Services: Library: Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services capital Outlay Total Library Services/Library Nondepart•ental: Rei•bursed Ad•inistrative Special Progra•s and Projects Public Agency Funding Inventory Loss Contingency Expected Expenditure Savings Total Nondepart•ental Subtotal Less Rei•bursed Ad•inistrative Total General Fund Expenditures - 80- Budget $ 153,111 11,750 131,533 100,927 51,680 9,990 241630 4831621 115651125 300 490 221,297 62,460 760 401000 3251307 75,000 59,786 202,300 0 310 {6851000) {3471604) 1911521639 {310191852) $161 132 I 787 Actual $ 148, 156 9,764 111,408 96,342 51,671 8,777 241615 4501733 114771043 0 234 220, 119 62,435 690 401000 3231478 75,000 50,336 202,289 (138) 0 0 3271487 1818641756 !310181450) $1518461306 Variance Favorable (Unfavorable) $ 4,955 1 ,986 20J125 4,585 9 1,213 15 321888 881082 300 256 1,178 25 70 0 829 0 9,450 11 138 310 {6851000) {6751091) 2871883 !11402) $ 2861481 DEBT SERVICE FUND The debt service fund is used to account for the accumulation of resources and payment of general obligation bond principal and interest from governmental resources and special assessment bond principal and interest from special assessment levies when the government is obligated in some manner for the payment. - 81 - CITY OF COLLEGE STATION, TEXAS DEBT SERVICE FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets Equity in Cash and Cash Equivalents Equity in Investments Receivables: Delinquent Taxes Accrued Interest Note Total Assets Liabilities and Fund Balance Liabilities: Accounts Payable Accrued Liabilities Deferred Revenues: Deferred Taxes Note Receivable Total Liabilities Fund Balance: Reserved for Debt Service Total Fund Balance Total Liabilities and Fund Balance -82- 1993 $ 191,408 678,627 238,562 30, 105 495,279 $1,633,981 $ 4, 134 24' 135 238,562 495.279 762, 110 87 1 ,87 1 87 1 ,871 $1,633,981 1992 $ 74,005 782, 146 271, 158 22,406 562,056 i1 ,7 11,771 $ 0 47,604 271, 158 562,056 880,818 830,953 830,953 $1'711'771 CITY OF COLLEGE STATION, TEXAS DEBT SERVICE FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES For the Fiscal Years Ended September 30, 1993 and 1992 Revenues Current Property Taxes Interest on Investments Loan Repayments Other Total Revenues Expenditures: Principal Retirement Interest Payments Fiscal Charges Total Expenditures Excess (Deficiency) of Revenues Over/(Under) Expenditures Other Financing Sources: Operating Transfers In Proceeds from Long Term Debt Issuance Total Other Financing Sources Excess (Deficiency) of Revenues and Other Financing Sources Over/(Under) Expenditures Fund Balance, October 1 Fund Balance, September 30 -83- 1993 $3,351,369 131 ,674 66,777 3 3,549,823 2,111,906 1,390,017 6,982 3,508,905 40,918 0 0 0 40,918 830,953 $ 871,871 1992 $3,125,805 151,446 62,944 0 3,340, 195 3,332,876 1,501,601 9, 127 4,843,604 (1 ,503,409) 58,944 1,125,000 1,183,944 (319,465) 1,150,418 $ 830,953 -84- SPECIAL REVENUE FUNDS Special revenue funds are used to account for specific revenues that are legally restricted to expenditures for p a rtic ular purposes. Community Development -to account for funds granted to the City by the National D e p a rt m en t of Housing and Urban Development for use on various community improvement projects. Hotel/Motel Tax -to account for th e r eceipt and expenditure of funds received by the City from the assessment of hotel and motel occupancy tax. Usage of funds is restricted to the c onstruc tion and m ai n ten ance of convention and civic facilities and to the promotion of tourism and arts wit hin the City. Parks Escrow -to account for the receipt and expenditure of funds received by the City from residential lan d developers. Developers either dedicate land or money in lieu of land for use in the de vel opm ent of neighborhood parks in residential areas. -85- CITY OF COLLEGE STATION, TEXAS SPECIAL REVENUE FUNDS COMBINING BALANCE SHEET (With September 30, 1993 comparative totals for the fiscal year ended Sep temb er 30, 1992) Assets Equity in Caeh and Cash Equivalents Equity in Investments Receivables: Accrued Interest Grants Letter of Credit Account a Loans Less Allowance for Uncollectible Accounts Property .Held for Resale Total Assets Liabilities and Fund Balances Liabilities: Accounts Payable Retainage Payable Refundable Deposits Accrued Liabilities Def erred Revenues Total Liabilities Fund Balances: Reserved: Reserved for Encumbrances Reserved for Property Held for Resale Unreserved: Design�ted for Subsequent Years• Expenditures Un designated Total Fund Balances Total Liabilities and Fund Balances Community Development $ $ $ $ 2,925 10,067 0 100,281 0 1,259 219,870 0 57,500 391,902 6,506 15,687 0 4J600 219, 870 246,663 302, 159 57 ,500 60,910 (275,330) 145,239 391 ,902 -86- Totals Hotel/Motel Parks Tax Escrow 1993 $ 139,830 $ 63,328 $ 206,083 $ 516,649 233,985 760, 701 24,042 10,558 34,600 0 0 100,281 0 25,425 25 ,425 9,210 0 10,469 0 0 219,870 (1,377) 0 (1,377) 0 0 57,500 $ 688,354 $ 333,296 $ 1,413,552 $ $ 10,973 $ 0 $ 17 ,479 $ 0 1,373 17,060 13,832 0 13,832 856 0 5 ,455 120 0 219,990 25 781 1 373 273,817 15,852 0 318,011 0 0 57 ,500 203 299, 168 360,281 646,518 32, 755 403,943 662,573 331,923 1I139,735 $ 688,354 $ 333,296 $ 1,413,552 $ 1992 137,988 834.,074 23,202 61,518 25,425 7 ,298 204,439 (672) 0 1,293,272 46,963 15,344 12,313 s1so1 204 ,439 284 ,566 62 ,7 10 0 297 ,796 648,200 1,008,706 1 ,293,272 CITY OF COLLEGE STATION1 TEXAS SPECIAL REVENUE FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITUBESAND CHANGES IN FUND BALANCES --··------"-�--·-- For the Fiscal Year Ended September 30, 1993 (With comparative totals for the fiscal year ended September 30, 1992) Totals Community Hotel/Motel Parks Development Tax Escrow 1993 1992 Revenues: Taxes $ 0 $ 1,100,815 $ 0 $ 1,100,815 $ 1,123,931 Grants 789,692 0 0 789,692 714, 147 Fines, Forfeits and Penalties 0 827 0 827 635 Interest on Invest•enta 0 40, 789 19,010 59,799 70,356 Rents and Royalties 0 85,352 0 85,352 72,948 Loan Repay•ents 9,432 0 0 9,432 8,580 Interest on Loans 9,059 0 0 g,os9 8,755 Contributions 63,500 3,800 0 67,300 1,175 Other 3,105 9,818 13,745 26,668 4,014 Total Revenues 874,788 1 ,241 ,401 32,755 2,148,944 2,004,541 Expenditures: Current: Housing Rehabilitation 360,629 0 0 360,629 368,596 ReiMbursed Administrative 230,388 218,428 0 448,816 428, 171 Special Prograas and Projects 0 193,145 0 193, 145 134,806 Public Agency Funding 130,310 534,437 0 664,747 583,562 Contributions 25,000 0 0 25,000 0 , InteriM Assistance 5,148 0 0 5,148 3,155 Subrecipient Projects 0 0 0 0 5,056 Clearance 16,249 0 0 16,249 14,g54 Other 0 1,449 0 1,449 5,412 Capital OUtlay 31,639 32,399 0 64,038 59,616 Total Expenditures 799,363 979,858 0 1!779,221 1 ,603,328 Excess of Revenues Over Expenditures 75,425 261 ,543 32,755 369,723 401 ,213 Other Financing Uses: Operating Transfers OUt 0 238,694 0 238,694 329,897 Total Other Financing Uses 0 238,694 0 238,694 329,897 Excess of Revenues Over Expenditures and other Financing Uses 75,425 22,849 32,755 131,029 71,316 Fund Balances, October 1 69,814 639,724 299,168 1,008,706 937,390 Fund Balances, September 30 s 145,239 $ 662,573 $ 331,923 $ 1,139,735 s 1,ooa,106 • 87- CITY OF COLLEGE STATION. TEXAS COMMUNITY DEVELOPMENT FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets Equity in Cash and Cash Equivalents Equity in Investments Receivables: Grants Accounts Loans Property Held for Resale Total Assets Liabilities and Fund Balances Liabilities: Accounts Payable Retainage Payable Accrued Liabilities Deferred Revenue Total Liabilities Fund Balances: Reserved: Reserved for Encumbrances Reserved for Property Held for Resale Unreserved: Designated for Subsequent Years' Expenditures Undesignated Total Fund Balances Total Liabilities and Fund Balances -88 - $ 1993 2,925 10,067 100,281 1,259 219,870 57,500 $ 391,902 $ 6,506 15,687 4,600 219,870 246,663 302, 159 57,500 60,910 (275,330) 145,239 $ 391,902 1992 $ 62,693 0 61,518 602 204,439 0 $ 329,252 $ 35,921 13,971 5, 107 204,439 259,438 61,389 0 8,425 0 69,814 $ 329,252 CITY OF COLLEGE STATION. TEXAS COMMUNITY DEVELOPMENT FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES For the Fiscal Years Ended September 30, 1993 and 1992 Revenues: Grants Fines, Forfeits and Penalties Interest on Investments Loan Repayments Interest on Loans Contributions Other Total Revenues Expenditures: Current: Housing Rehabilitation Reimbursed Administrative Public Agency Funding Contributions Interim Assistance Subrecipient Projects Clearance Other Capital Oulay Total Expenditures Excess of Revenues Over Expenditures Fund Balances, October 1 Fund Balances, September 30 -89- 1993 $ 789,692 0 0 9,432 9,059 63,500 3, 105 874,788 360,629 230,388 130,310 25,000 5, 148 0 16,249 0 31,639 799,363 75,425 69,814 $ 145,239 1992 $ 714,147 $ 12 1 ,241 8,580 8,755 0 2,424 735, 159 368,596 212,884 101,562 0 3, 155 5,056 14,.954 3, 187 24,710 734, 104 1,055 68,759 69,814 CITY OF COLLEGE STATION. TEXAS COMMUNITY DEVELOPMENT FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 Revenues: Grants Loan Repayments Interest on Loans Contributions Other Total Revenues Expenditures: Current: Housing Rehabilitation Reimbursed Administrative Public Agency Funding Interim Assistance Clearance Contributions Capital Outlay Total Expenditures Excess of Revenues Over (Under) Expenditures Fund Balance, October 1 Fund Balance, September 30 Budget $1,507,879 0 0 0 20,000 1,527,879 566,930 251,718 137,977 30,148 28,148 0 537,958 1,552,879 (25,000) 7 $ (24,993) -90- Actual $789,692 9,432 9,059 63,500 3,105 874,788 360,629 230,388 130,310 5,148 16,249 25,000 31,639 799,363 75,425 69,814 $145,239 Variance Favorable (Unfavorable) $(718,187) 9,432 9,059 63,500 (16,895) (653,091) 206,301 21,330 7,667 25,000 11,899 (25,000) 506,319 753,516 100,425 69,807 $170,232 CITY OF COLLEGE STATION, TEXAS HOTEL/MOTEL TAX FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets Equity in Cash and Cash Equivalents Equity in Investments Receivables: Accrued Interest Accounts Allowance for Uncollectible Accounts Total Assets Liabilities and Fund Balances Liabilities: Accounts Payable Refundable Deposits Accrued Liabilities Def erred Revenues Total Liabilities Fund Balances: Reserved: Reserved for Encumbrances Unreserved: Designated for Subsequent Year's Expenditures Undesignated Total Fund Balances Total Liabilities and Fund Balances - 91 - 1993 $ 139,830 516,649 24,042 9,210 (1 ,377) $ 688,354 $ 10,973 13,832 856 120 25,781 15,852 203· 646,518 662,573 $ 688,354 1992 $ 53,086 588,052 16,317 6,696 (672) $ 663,479 $ 11,042 12,313 400 0 23,755 1,321 203 638,200 639,724 $ 663,479 CITY OF COLLEGE STATION. TEXAS HOTEWMOTELTAXFUND COMPARATIVE STATEMENTS OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES For the Fiscal Years Ended September 30, 1993 and 1992 Revenues: Taxes Rents Fines, Forfeits and Penalties Interest on Investments Contributions Other Total Revenues Expenditures: Current: Reimbursed Administrative Salaries and Benefits Supplies Purchased Professional Services Purchased Property Services Other Purchased Services Special Programs and Projects Public Agency Funding Other Capital Outlay Total Expenditures Excess of Revenues Over Expenditures Other Financing Uses: Operating Transfers Out Total Other Financing Uses Excess of Revenues Over Expenditures and Other Financing Uses Fund Balance, October 1 Fund Balance, September 30 -92 - 1993 $ 1,100,815 85,352 827 40,789 3,800 9,818 1, 241, 401 218,428 18,884 35,787 47,728 3,876 86,870 0 534,437 1 ,449 32,399 979,858 261 ,543 238,694 238,694 22,849 639,724 $ 662,573 1992 $ 1'123 ,931 72,948 623 47,019 1,175 1 ,590 1,247,286 215,287 0 0 0 0 0 134,806 482,000 2,225 0 834,318 412,968 329,897 329,897 83,071 556,653 $ 639,724 CITY OF COLLEGE STATION. TEXAS HOTELJMOTELTAXFU ND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 Revenues: Taxes Rents and Royalties Fines, Forfeits, and Penalties Interest on Investments Contributions Other Total Revenues Expenditures: Current: Reimbursed Administrative Special Programs and Projects Public Agency Funding Other Contingency Capital Outlay Total Expenditures Excess of Revenues Over Expenditures Other Financing Uses: Operating Transfers Out Total Other Financing Uses Excess (Deficiency) of Revenues Over/(Under) Expenditures and Other Financing Uses Fund Balance, October 1 Fund Balance. September 30 Budget Actual $1,060,000 $1, 100,815 65,100 85,352 0 827 25,000 40,789 0 3,800 1,500 9,818 1, 151,600 1,241,401 266,607 218,428 214,690 193, 145 534,400 534,437 0 1,449 1,693 0 5, 121 32,399 1,022,511 979,858 129,089 261,543 399,759 238,694 399,759 238,694 (270,670) 22,849 253,657 639,724 $ (17.013) $ 662,573 -93- Variance Favorable (Unfavorable) $ 40,815 20,252 827 15,789 3,800 8,318 89,801 48, 179 21,545 (37) (1,449) 1,693 (27,278) 42,653 132,454 161,065 161,065 293,519 386,067 $ 679.586 CITY OF COLLEGE STATION, TEXAS PARKS ESCROW FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 1993 1992 Assets Equity in Cash and cash Equivalents $ 63,328 $ 22,209 Equity in Investments 233,985 246,022 Receivables: Accrued Interest 10,558 6,885 Letter of Credit 251425 251425 Total Assets $ 333,296 $ 300,541 Liabilities and Fund Balances Liabilities: Retainage Payable $ 11373 $ 11373 Total Liabilities 11373 1 ,373 Fund Balances: Unreserved: Designated for Subsequent Year's Expenditures 299, 168 289, 168 Undesignated 321755 102000 Total Fund Balances 331 ,923 2992168 Total Liabilities and Fund Balances $ 3331296 $ 3002541 - 94- CITY OF COLLEGE STATION, TEXAS PARKS ESCROW FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES For the Fiscal Years Ended September 30, 1993 and 1992 Revenues: Interest On Investments Other Total Revenues Expenditures: Capital Outlay Total Expenditures Excess (Deficiency) of Revenues Over (Under) Expenditures Fund Balances, October 1 Fund Balances, September 30 -95 - $ 1993 19,010 13, 745 32,755 0 0 32,755 299, 168 $ 331,923 $ 1992 22,096 0 22,096 34,906 34,906 (12,810) 311,978 $ 299, 168 CITY OF COLLEGE STATION. TEXAS PARKS ESCROW FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) Revenues: Interest Earnings Other Total Revenues Fund Balance, October 1 Fund Balance, September 30 FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 Budget Actual $ 0 $ 19,010 0 13,745 0 32,755 311,978 299,168 $311,978 $331,923 -96- Variance Favorable (Unfavorable) $ 19,010 13,745 32,755 (12,810) $ 19,945 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 Equipment -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 i m prove ments , city hall and warehouse construction, and a traffic signalization project to be made with funds provided by proceeds of the 1982 Series II issue of general obligation bonds. 1984 Bond -to account for the cost of street imp rovements , building construction, and park improvements to be made with funds provided by proceeds of the 1984 Series of general obligation bonds. 1989 Bond -to account for the cost of street improvements and the renovation of the public services building to be made with funds provided by proceeds of the 1989 Series of general obligation bonds. 1991 Bond -to account for the cost of street improvements and parks improvements made with funds provided by proceeds of the 1991 Series of general obligation bonds. -97 - CITY OF COLLEGE STATION, TEXAS CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET September 30, 1993 (With comparative totals for the fiscal year ended September 30, 1992) 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 Accrued Liabilities Custo•er construction Advances 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 (Deficit) Total Liabilities and Fund Balances -98- $ $ Capital EguipRtent 0 0 0 0 0 0 $ 4 74 ,788 2,324 0 0 $ 477 112 89,932 0 0 0 0 0 0 (567,044) (477,112) 0 1982 Series II Bond $ 217,010 112,515 4,077 25,DOO 0 $ 358,602 $ 286 25,944 373 0 26,603 59,097 0 0 272,902 0 0 0 0 331,999 $ 358,602 1984 Bond $ 29,587 109,318 5,749 0 0 $ 144 ,654 $ 0 7,736 0 0 7 736 251,018 0 0 0 0 0 0 ( 114 t 100) 136,918 $ 144 ,654 Totals 1989 Bond 1991 Bond 1993 1992 $ 131,244 $ 479, 157 $ 856,998 $ 500,082 1,174,222 1, 770,410 3,166,465 5,539,582 53,416 80, 176 143,418 151,463 0 3,423 28,423 440,212 0 0 0 10,006 ! 11358,882 $ 213331166 $ 4, 195,304 $ 6,641,345 $ 45,317 $ 154,237 $ 674,628 $ 437,752 0 36,541 72,545 74,042 0 0 373 373 0 50,000 50,000 0 45,317 240,778 797,546 512,167 20,422 742,368 1,162,837 836,034 0 0 0 10,006 0 0 0 110,909 0 0 272,902 404,864 15,984 0 15,984 644,487 0 1,235,707 1,235,707 3,600,216 0 0 0 70,986 1,277,159 114,313 710,328 451,676 1,313,565 2,092,388 3,397,758 6, 129, 178 ! 11358,882 $ 21333, 166 $ 4, 195,304 $ 6,641,345 -99- 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, 1993 (With comparative totals for the fiscal year ended September 30, 1992) Revenues: Grants Special Assess•ents Interest on Invest•ents Contributions Other Total Revenues Expenditures: Current: Rei•bursed Ad•inistrative Other Capital Outlay Debt Service: Bond Issuance costs Total Expenditures Excess (Deficiency) of Revenues over (Under} Expenditures Other Financing Sources (Uses): Proceeds fro• Long Ter• Debt Issuance Pre•iu•s on Bonds Sold Operating Transfers In Operating Transfers Out Total Other Financing Sources (Uses) Excess (Deficiency) of Revenues and Other Financing sources (Under) Expenditures and Other Financing Sources (Uses) Fund Balances, October 1 Fund Balances, Septe•ber 30 -100 - $ Capital Eguip•ent 0 0 0 0 0 0 0 21'051 434,440 0 455,491 (455,491) 0 0 0 0 0 (455,491) (21,621) $ (477,112) $ 1982 Series II Bond 25,000 0 0 0 0 25,000 52, 199 971 1,590,575 0 1,643,745 (1,618,745) 0 0 425,251 0 425 ,251 (1,193,494) 1,525,493 $ 331,999 $ 1984 Bond 0 0 13,702 22,500 0 36,202 29' 281 0 120,795 0 150,076 (113,874) 0 0 0 0 0 (113,874} 250,792 $ 136,918 $ 1989 Bond 0 40,000 97,792 4,491 0 142,283 51,844 0 85, 186 0 137,030 5 253 0 0 0 ( 186, 557) (186,557) (1 81,304 ) $ 1,313,565 1991 Bond $ 65,841 0 157,448 0 0 223,289 67' 182 0 943,364 0 1,010,546 (787,257) 0 0 0 0 0 (787,257) 2,879,645 $ 2,092,388 Totals $ 1993 90,841 40,000 268,942 26,991 0 426,774 200,506 22,022 3,174,360 0 3,396,B88 (2,970,114) 0 0 425,251 (186, 557) 238,694 (2,731,420) 6,129,178 $ 3 ,397,758 - 101 - 1992 $ 521 ,450 0 512,360 100, 113 128 1,134,051 188,852 4,647 2,511,769 62,395 2 ,767,663 (1,633,612) 3,500,000 275 270,953 0 3,771 ,22B 2, 137 ,616 3,991,562 $ 6,129,178 CITY OF COLLEGE STATION, TEXAS CAPITAL EQUIPMENT FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets Receivables: Grants Total Assets Liabilities and Fund Balances Liabilities: Accounts Payable Retainage Payable Total Liabilities Fund Balances: Reserved for Encumbrances Unreserved Undesignated Total Fund Balances Total Liabilities and Fund Balances -102 - 1993 $ 0 $ 0 $ 474,788 2,324 $ 477,112 89,932 (567,044) (477,112) 0 1992 $ 157,302 $ 157,302 $ 178,923 0 178,923 1,188 (22,809) (21 ,621) $ 157,302 CITY OF COLLEGE STATION, TEXAS CAPITAL EQUIPMENT FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES For the Fiscal Years Ended September 30, 1993 and 1992 Revenues Grants Total Revenues Expenditures: Current: Interest Capital Outlay Total Expenditures Deficiency of Revenues Under Expenditures Fund Balance (Deficit), October 1 Fund Balance (Deficit), September 30 -103 - $ 1993 0 0 21 ,051 434,440 455,491 (455,491) (21,621) $ (477,112) 1992 $ 157,302 157,302 4,647 361I167 365,814 (208,512) 186,891 $ (21 ,621) CITY OF COLLEGE STATION, TEXAS CAPITAL EQUIPMENT FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 Variance Favorable Budget Actual (Unfavorable) Expenditures: Current: Other $ 0 $ 21,051 $ (21,051) Capital Outlay 3,898,200 434,440 3,463,760 Total Expenditures 3,898,200 455,491 3,442,709 Excess (Deficiency) of Revenues Over/(Under) Expenditures (3,898,200) (455,491) 3,442,709 Other Financing Sources: Proceeds From Long Term Debt Issuance 3,898,200 0 (3, 898, 200) Total Other Financing Sources 3,.898,200 0 (3,898,200) Deficiency of Revenues and Other Financing Sources Under Expenditures 0 (455,491) (455,491) Fund Balance, October 1 0 (21,621) (21,621) Fund Balance, September 30 $ n $ (477, 112) $ (477, 112) v -104- CITY OF COLLEGE STATION, TEXAS 1982 SERIES II BOND FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets Equity in Cash and Cash Equivalents Equity in Investments 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 Encumbrances Reserved for Prepaids Unreserved Designated for: Drainage Projects General Government Projects Parks Projects Streets Projects Traffic Signalization Projects Unreserved Undesignated Total Fund Balances Total Liabilities and Fund Balances -105 - $ $ $ $ 1993 217,010 112,515 4,077 25,000 0 358,602 286 25,944 373 26,603 59,09.7 0 0 272,902 0 0 0 0 331,999 358,602 1992 $ 1 24 ,675 1,381,067 40,413 274,247 10,006 $1 ,830,408 $ 239,309 65 ,23 3 373 304,915 532,498 10,006 0 380,002 134,820 .61,812 70,986 335,369 1,525,493 $1,830,408 CITY OF COLLEGE STATION, TEXAS 1982 SERIES II BOND FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES For the Fiscal Years Ended September 30, 1993 and 1992 Revenues Grants Interest on Investments Contributions Total Revenues Expenditures: Current: Reimbursed Administrative Other Capital Outlay Total Expenditures Deficiency of Revenue.s Under Expenditures Other Financing Sources: Operating Transfers In Total Other Financing Sources Deficiency of Revenues and Other Financing Sources Under Expenditures Fund Balance, Octobe.r 1 Fund Balance, September 30 -106 - $ 1993 25,000 0 0 25,000 52, 199 971 1,590,575 1,643!745 (1,618,745) 425,251 425,251 (1,193,494) 1,525,493 $ 331,999 $ 1992 355,485 142' 189 100, 113 597,787 57,957 0 1,369,607 1,427,564 (829,777) 270,953 270,953 (558,824) 2,084,317 $1,525,493 CITY OF COLLEGE STA110N. 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, 1993 Revenues: Grants Interest Total Revenues Expenditures: Current: Reimbursed Administrative Other Contingency 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 and Other Financing Sources Over/(Under) Expenditures Fund Balance, October 1 Fund Balance, September 30 Budget Actual $ 0 $ 25,000 72,152 0 72,152 25,000 72,557 52,199 0 971 85,000 0 2,409,100 1,590,575 2,566,657 1,643,745 (2,494,505) (1,618,745) 393,122 425,251 393,122 425,251 (2, 101,383) (1, 193,494) 1,500,000 1,525,493 $ (601,383) $ 331,999 • 107. Variance Favorable (Unfavorable) $ 25,000 (72, 152) (47, 152) 20,358 (971) 85,000 818,525 922,912 875,760 32,129 32,129 907,889 25,493 $ 933,382 CITY OF COLLEGE STATION. TEXAS 1984 BOND FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets Equity in Cash and Cash Equivalents Equity in Investments Receivables: Accrued Interest Total Assets Liabilities and Fund Balances Liabilities: Accounts Payable Retainage Payable Total Liabilities Fund Balances: Reserved: Reserved for Encumbrances Unreserved Designated for: Drainage Projects Unreserved Undesignated Total Fund Balances Total Liabilities and Fund Balances · 108. 1993 $ 29,587 109,318 5 •. 749 $ 144,654 $ 0 7,736 7,736 251,018 0 (114,100) 136,918 $ 144,654 1992 $ 21,525 238,448 4,957 $ 264,930 $ 6,402 7,736 14, 138 139,.883 156,957 (46,048) 250,792 $ 264,930 CITY OF COLLEGE STATION, TEXAS 1964 BOND FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES For the Fiscal Years Ended September 30, 1993 and 1992 Revenues: Interest on Investments Contributions Other Total Revenues Expenditures: Current: Reimbursed Administrative Capital Outlay Total Expenditures Deficiency of Revenues Under Expenditures Fund Balance, October 1 Fund Balance, September 30 -109- 1993 $ 13, 702 22,500 0 36,202 29,281 120,795 150,076 (113,874) 250,792 $ 136,918 1992 $ 16,618 0 128 16 746 33,601 4,020 37,621 (20,875) 271 ,667 $ 250,792 CITY OF COLLEGE STATION, TEXAS 1984 BOND FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 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 -11 0 - Budget Actual $ 9,952 $ 13,702 0 22,500 9,952 36,202 33,601 29 ,281 550,000 120,795 583,601 150,076 (573,649) (113,874) 250,000 250,792 $ (323,649) $136,918 Variance Favorable (Unfavorable) $ 3,750 22,500 26,250 4,320 429,205· 433,525 459,775 792 $460,567 CITY OF COLLEGE STATION, TEXAS 1989 BOND FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets Equity in Cash and Cash Equivalents Equity in Investments Receivables: Accrued Interest Total Assets Liabilities and Fund Balances Liabilities: Accounts Payable Total Liabilities Fund Balances: Reserved: Reserved for Encumbrances Unreserved Designated for: General Government Projects Parks Projects Streets Projects Unreserved Undesignated Total Fund Balances Total Liabilities and Fund Balances -111 - 1993 $ 131,244 1,174,222 53,416 $1,358,882 $ 45,317 45 317 20,422 0 15,984 0 1,277'159 1 ,313,565 $1,358,882 1992 $ 121 ,086 1 '341'312 36,351 $1,498,749 $ 3,880 3,880 56,032 24,862 99,315 1,175,544 139' 116 1,494,869 $1,498,749 CITY OF COLLEGE STATION. TEXAS 1989 BOND FUND COMPARATIVE STATEMENTS OF REvENUES, EXPENDITURES AND CHANGES IN FUND BALANCES For the Fiscal Years Ended September 30, 1993 and 1992 Revenues: Special Assessments Interest on Investments Contributions Total Revenues Expenditures.: Current: Reimbursed Administrative Capital Outlay Total Expenditures Excess (Deficiency) of Revenues Over (Under) Expenditures Other Financing Uses: Operating Transfers Out Total Other Financing Uses Deficiency of Revenues Under Expenditures and Qther Financing Uses Fund Balance, October 1 Fund Balance, September 30 • 112. 1993 $ 40,000 97,792 4,491 142,283 51,844 85, 186 137,030 5,253 186,557 186,557 (181,304) 1,494,869 $1,313,565 $ 1992 0 115,532 0 115,532 18, 171 167,200 185,371 (69,839) 0 0 (69,839) 1,564,708 $1,494,869 CITY OF COLLEGE STATION, TEXAS 1989 BONO FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 Revenues: Special Assessments Interest on Investments Contributions Total Revenues Expenditures: Current: Reimbursed Administrative Capital Outlay Contingency Total Expenditures Excess (Deficiency) of Revenues Over/(Under) Expenditures Other Financing Uses: Operating Transfers Out Total Other Financing Uses Excess. (Deficiency) of Revenues Over/(Under) Expenditures and Other Financing Uses Fund Balance, October 1 Fund Balance, September 30 - 113 - Budget Actual $ 0 $ 40,000 54,737 97,792 0 4,491 54,737 142,283 51,929 51,844 854,400 8 5,186 61,000 0 967,329 137,030 (912,592) 5,253 0 186,557 0 186,557 (912,592) (181,304) 1,291,302 1,494,869 $ 378,710 $1,313,565 Variance Favorable (Unfavorable) $ 40,000 43,055 4,491 8 7,54 6 85 769,214 61,000 830,299 917,845 (186,557) (186,557) 731,288 203,5 67 $ 934,855 CITY OF COLLEGE STATION. TEXAS 1991 BOND FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets Equity in Cash and Cash Equivalents Equity in Investments Receivables: Accrued Interest Grants Total Assets Liabilities and.Fund Balances Liabilities: Accounts Payable Retainage Payable Customer Construction Advances Total Liabilities Fund Balances: Reserved: Reserved for Encumbrances. Unreserved Designated for: Par.ks Projects Streets Projects Unreserved Undesignated Total Fund Balances Total Liabilities and Fund Balances -114 - 1993 $ 479, 157 1,770,410 so, 176 31423 $213331166 $ 154,237 36,541 501000 240,778 742,368 0 1,235,707 1141313 210921388 $213331166 1992 $ 232,796 2,578,755 69,742 81663 $21 8891956 $ 9,238 1,073 0 10.311. 106,433 410,352 2,396,343 (33,483) 218791645 $218891956 CITY OF COLLEGE STATION, TEXAS 1991 BOND FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES For the Fiscal Years Ended September 30, 1993 and 1992 Revenues: Grants Interest on Investments Total Revenues Expenditures: Current: Reimbursed Administrative Capital Outlay Debt Service: Bond Issuance Costs Total Expenditures Deficiency of Revenues Under Expenditures Other Financing Sources: Proceeds from Long Term Debt Issuance Premiums on Bonds Sold Total Other Financing Sources Excess (Deficiency) of Revenues and Other Financing Sources Over (Under) Expenditures Fund Balance, October 1 Fund Balance, September 30 -1 15 - 1993 $ 65,841 157,448 223,289 67' 182 943,364 0 1 ,010,546 (787,257) 0 0 0 (787,257) 2,879,645 $2,092,388 $ 1992 8,663 238,021 246,684 79, 123 609,775 62,395 751 ,293 (504,609) 3,500,000 275 3,500,275 2,995,666 ( 116 '021 ) $2,879,645 CITY OF COLLEGE STATION, TEXAS 1991 BOND FUND SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 Revenues: Grants Interest on Investments Total Revenues Expenditures: Current: Reimbursed Administrative Capital Outlay Contingency Total Expenditures Excess (Deficiency) of Revenues Over/(Under) Expenditures Fund Balance, October 1 Fund Balance, September 30 -116 - Budget Actual $ 0 $ 65,841 111,960 157,448 111,960 223,289 89, 111 67,182 2,413,000 943,364 104,000 0 2,606, 111 1,010,546 (2,494, 151) (787,257) 2,700,000 2,879,645 $ 205,849 $2,092,388 Variance Favorable (Unfavorable) $ 65,841 45,488 111,329 21,929 1,469,636 104,000 1,595,565 1,706,894 179,645 $1,886,539 ENTERPRISE FUNDS Enterprise funds are used to account for operations that are financed and operate d 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 accou nta b ility purposes. Electric -to account for revenues and expense s r e l ated to the operation and maintenance of the ele ctric systems of the City. All activities necessary to pr ovide such service s are accounted for in this fund, and include, but are not l im ited to administration, operations, maintenance, and financing and related debt service. Water -to account for revenues and expense s re l ated 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 s uch 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. -117 - CITY OF COLLEGE STATION, TEXAS ENTERPRISE FUNDS COMBINING BALANCE SHEET September 30, 1993 (With comparative totals for the fiscal year ended September 30, 1992) Electric Water sewer Assets Current Assets: Equity in Cash and Cash Equivalents $ 1,588,015 $ 0 $ 280, 177 Equity in Invest•ents 5,867,454 0 1 ,035,207 Receivables: Accrued Interest 333,979 0 65,019 Accounts 4,525,622 512,538 234,009 Special Assess•ents 0 0 4,794 Other 461 ,451 0 0 Less Allowance for Uncollectible Accounts (512,654) (23,044) (8,554) Interfund Receivables 163,922 0 0 Inventories 1,225,306 251 ,840 7,228 Prepaid costs 2 610 0 600 Total Current Assets 13,655,705 741,334 1,618,480 Restricted Assets: Equity in Cash and Cash Equivalents 693,940 370,431 651,067 Equity in Invest•ents 2,563,995 1,368,683 2,405,586 Receivables: Accrued Interest Receivable 49,025 41,604 98,887 Accounts 51,567 0 0 Special Assess•ents 0 1 865 0 Total Restricted Assets 3,358,527 1,782,583 3, 155,540 Note Receivable fro• Joint Venture 0 0 0 Equity in Joint Venture 0 0 0 Advance to Other Funds 1,004,357 0 0 Deferred Charges: Water Well 0 1,167,075 0 Bond Issuance Costs 62,313 33,542 169,455 Accu•ulated A•ortization !4 ,344) p ,018,943) !7,568) Total Deferred Charges 57,969 181 674 161,887 Property and Equip•ent: Utility Plant 22,225,595 28,562,568 20,603,879 Buildings 0 898,760 811,654 Machinery and Equip•ent 116,721 573,463 1,239,547 Accu•ulated Depreciation (8,234,263) (8,118,981) (5,460,250) Construction in Progress 4,555,798 405,849 2,342,854 Land 0 529,609 426,323 Total Property and Equip•ent, Net 18,663,851 22,851,268 19,964,007 Total Assets $36,740,409 $25,556,859 $24,899,914 -118 - Solid Totals waste Collection 1993 1992 $ 59,886 $ 1,928,078 $ 606,098 221,268 7' 123 ,929 6,751,575 37' 189 436, 187 270,245 169,454 5,441,623 4,911,037 0 4,794 4,794 0 461. 451 654,578 (5,573) (549,825) (737,322) 0 163,922 153,393 5,841 1,490,215 1,218,513 0 3 210 600 488,065 16,503,584 13 ,833 ,511 0 1'715,438 445,842 0 6,338,264 9,477,268 0 189,516 189, 193 0 51,567 S1,567 0 1 865 0 0 8,296,650 10, 163,870 758,599 758,599 836,819 295,597 295,597 350,038 0 1,004 ,357 1, 168,279 0 1, 167 ,075 1,167,075 0 26S,310 64,757 0 p ,030,855) (969,302) 0 401 ,530 262,530 0 71,392,042 69,129,812 0 1,710,414 1,623,308 2,373,681 4,303,412 3,966,245 (1,233,242) (23,046, 736) (20,634,830) 0 7,304,501 4,450,705 0 955,932 944,250 1,140,439 62,619,565 59,479,490 $ 2,682,700 $ 89,879,882 $ 86,094,537 (Continued) -119 - CITY OF COLLEGE STATION, TEXAS ENTERPRISE FUNDS COMBINING BALANCE SHEET September 30, 1993 (With comparative totals for the fiscal year ended September 30, 1992) (Continued) Liabilities and Fund Equity Current Liabilities: Accounts Payable Retainage Payable Interfund Payable Obligation Under Capital Lease Accrued Liabilities custo•er Construction Advances Other Deferred Revenues Total Current Liabilities current Liabilities Payable fro• Restricted Assets: Accounts Payable Accrued Interest Payable Retainage Payable Refundable Deposits Revenue Bonds General Obligation Bond.s Certificates of Obligation Miscellaneous Accrued Liabilities Total Current Liabilities Payable fro• Restric.ted Assets Noncurrent Liabilities: Revenue Bonds Una•ortized Pre•iu•s General Obligation Bonds Certificates of Obligation Obligation Under Capital Lease Advances fro• Other Funds Accrued Vacation Total Noncurrent Liabilities Total Liabilitie.s Fund Equity: Contributed Capital Retained Earnings: Reserved for Debt Service Reserved for capital Projects Unreserved Total Fund Equity Total Liabilities and Fund Equity -120 - Electric $ 2,309,807 4,793 0 0 248,460 29,857 2,626 2,595,543 236,189 92,744 104,114 1,834,449 500,372 134,750 13' 100 0 2,915,718 5,060,328 1,711 558,250 65,500 0 0 71 741 5,757,530 11,268,791 3' 105 ,236 638,489 5,472,539 16,255,354 25,471,618 $36, 740,409 Water $ 737,059 0 0 494,221 29,175 2' 150 0 1,262,605 1,422 126,410 19,704 0 1,089,944 126,500 6,550 22 1,370,552 7,005,656 815 383,500 32,750 1,332,257 0 35,527 8,790,505 11,423,662 3,091,793 1'531'855 3,495,385 6,014,164 14 J 133 I 197 $25,556,859 $ Sewer 57,515 0 0 0 30,876 400 0 88 791 37,913 178,383 66,028 0 744,684 117' 705 6,550 0 1 ,151 ,263 9,769,016 5,623 454,910 32,750 0 0 29 761 10,292,060 11 ! 532 t 114 4 ,071,098 1'197' 729 2,799,175 5,299,798 13,367,800 $24,899,914 Solid Waste Collection $ 16,428 $ 0 163,922 0 20,515 0 0 200,865 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,004,357 23,873 1,028,230 1,229,095 54,901 0 0 1 ,398, 704 1,453,605 $ 21682,700 $ Totals 1993 3,120,809 4,793 163,922 494,221 329,026 32,407 2,626 4, 147 ,804 275,524 397,537 189,846 1. 834 ,449 2,335,000 378,955 26,200 22 5,437,533 21,835,000 8, 149 1,396,660 131,000 1,332,257 1,004,357 160,902 25,868,325 35,453,662 10,323,028 3,368,073 11,767,099 28,968,020 541426,220 89,8791882 -121 - 1992 $ 4, 146, 177 0 153,393 451,982 269,441 24,004 2,726 5,047,723 282,524 331,986 128,327 1,898,082 2,375,000 370,795 26,200 0 5,412,914 19,355,000 0 1,775,615 157,200 1 ,826,479 1,168,279 154,292 24,436,865 34,897,502 10,293,534 3,386,500 11,793,591 25,723,410 5111971035 $ 86,094,537 CITY OF COLLEGE STATION, TEXAS ENTERPRISE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS For the Fiscal Year Ended September 30, 1993 (With comparative totals for the fiscal year ended September 30, i 992) Operating Revenues: Electric Sales Water Sales Sewer Service Garbage Collection Fees Other Total Operating Revenues Operating Expenses: Purchased Power Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Rei•bursed Ad•inistrative Depreciation and A•ortization Other Total Operating Expenses Operating Inco•e Nonoperating Revenues (Expenses): Interest Earnings Rei•bursed Expenses Contributions Earnings in Joint Venture Interest Expense Other, Net Total Nonoperating Revenues (Expenses) Inco•e Before Operating Transfers Operating Transfers: Operating Transfers In Operating Transfers Out Total Operating Transfers Inco•e (Loss) Before Extraordinary Ite• Extraordinary Ite• Loss on Refunding Net Inco•e (Loss) Retained Earnings, October 1 Retained Earnings, Septe•ber 30 -122 - Electric $ 28,464,801 0 0 0 583,219 29,048,020 19,334,322 1,614,435 1 04 ,003 458,542 3 56,373 130,197 341,490 1,098,562 862,828 25,031 24 ,325,783 4,722,237 781,825 153,683 ·o 0 (450,460) (201,653) 283,395 5,005,632 0 (2,871,704) (2,871,704) 2' 133' 928 (40,287) 2,093,641 20,272,741 $ 22,366,382 Water $ 0 5,734,669 0 0 152,045 5,8 86,7 1 4 0 945,234 83 ,539 194,100 6,219 618,740 121,793 811,155 772,321 16,676 3,569,777 2,316,937 42,312 16,895 0 0 (899,523) (23,255) (863 ,571) 1 ,453,366 0 (692,550) (692,550) 760,816 (43,502) 717 ,314 10,324,090 $11,041,404 Sewer $ 0 0 4,587,982 0 115, 158 4 ,703 I 140 0 990,426 130,887 138, 195 38,329 435,832 166,740 749,429 555,466 2,584 3 ,207 ,888 1 ,495,252 205,965 0 0 0 (681,877) 4 029 (471 ,883) 1,023,369 i ,950 (566,200) (564,250) 459, 119 (46, 149) 412,970 8,883 ,732 $ 9,296,702 Solid Totals waste Collection 1993 1992 $ 0 $ 28,464,801 $ 27,320,323 0 5,734,669 5, 190,561 0 4,587,982 4,251,124 2,570,879 2,570,879 1,907,028 47 401 897,823 794,321 2,618,280 42,256,154 39,463,357 0 19,334,322 18,637,583 728,980 4,279,075 4,057,429 77,508 395,937 338,787 91,040 881,877 606' 162 66,376 467,297 459,974 627,831 1,812,600 1,626,676 192,624 822,647 727,770 378,871 3,038,017 2,795,476 300,650 2,491,265 2,246,591 0 44 291 181 519 2,463,880 33,567,328 31,677,967 154 400 8,688,826 7,785,390 97,527 1,127,629 1,336,480 193 170, 771 86,561 0 0 1,530 (54,441) (54,441) 19,807 (86,635) (2,118,495) (2,310,279) 2 722 (218,157) (415,649) (40,634) p ,092,693) p ,281,550) 113,766 7,596,133 6,503,840 0 1 ,950 0 (138,000) (4,268,454) !3,889,872) (138,000) (4,266,504) !3,889,872) (24,234) 3,329,629 2,613,968 0 (129,938) 0 (24,234) 3' 199' 691 2,613,968 1 ,422,938 40, 903, 501 38,289,533 $ 1,398,704 $ 44, 103, 192 $ 40,903,501 -123 - CITY OF COLLEGE STATION, TEXAS ENTERPRISE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 (With comparative totals for the fiscal year ended September 30, 1992) Cash Flows from Operating Activities: Cash Received from Customers Cash Payments to Suppliers for Goods and Services Cash Payments to Employees for Services Cash Distribution from Joint Venture Customer Deposits ReoeNed Customer Deposits Returned Cash Received for Reimbursed Expenses Cash Received from Sale d Scrap Cash Realived from Collection Fees Cash Received from Mineral Leases Cash Received from Miscellaneous Revenues Cash Paid for Special Projects Cash Paid for Miscellaneous Expenses Net Cash PrOO:ted I)'/ Operating Activities Cash Flows from Noncapital Financing Activities: Principal Received on Note Interest Received on Note Principal Received on Advance to Other Funds Interest Received on Advance to Other Funds Operating Transfers In From Other Funds Operating Transfers Out To Other Funds Cash Subsidies Paid to Public Agencies Advance to Other Funds Net Cash Used I)'/ Noncapifal Financing Activities Cash Flows from Capital and Related Financing Activities: Acquisition and Construction d Capttal AS9ills Proceeds from Sale d Assets Capital Contributed I)'/ DevelopelS Principal Paid on Revenue Bonds Principal Paid on General Obligation Bonds Principal Paid on Certificates d Obligation Principal Paid on Obligation Under Capttal Lease Principal Paid on Advance from Other Funds Interest Paid on Rewnue Bonds Interest Paid on General Obligation Bonds Interest Paid on Certificates d Obligation Interest Paid on Obligation Under Capital Lease Interest Paid on Advance from Other Funds Fees Paid to Fi&:al Agent Proceeds from Revenue Bonds Proceeds from Advance from Other Funds Cash Received from Special Assessments Net Cash Provided (Used) I)'/ Capital and Related Financing Activities Cash Flows from Investing Activities: Purchased Investments Proceeds from Sale and Maturities d Investments Interest on Investments Net Cash Provided (Used) I)'/ Investing Activities Net Increase (Decrease) in Cash Cash and Cash Equivalents, October 1 Cash and Cash Equivalents. September 30 Electric $28,548,905 (22,131,635) (1,600,906) 0 889,240 (952,873) 91,304 7,689 5,692 3,993 165,331 (47,044) 0 4,979,696 0 0 153,393 86,635 0 (2,871,704) (195,000) 0 (2,826,676) (3,294,552) 7,655 62,379 (508,750) (134,750) (13,100) 0 0 (394,270) (38,019) (11,004) 0 0 (4,141) 959,300 0 0 (3,369,252) (3.490,970) 5,819,030 608,530 2,936,590 1,720,358 561,597 $2,281,955 (Continued) -124 - Water $5,861,165 (2,994, 773) (934,154) 0 0 0 1 6,895 2,065 0 0 46,437 0 0 1,997,635 0 0 0 0 0 (692,550) 0 0 (692,550) (816,955) 1,090 0 (1,113,000) (126,500) (6,550) (451,983) 0 (737,283) (51,123) (5,502) (141,016) 0 (648) 0 0 0 (3,449,470) (908,609) 3,026,259 82,439 2,200,089 55,704 314,727 $ 370,431 Sewer $4,708,046 (1,670,545) (989,011) 0 0 0 0 10 0 5,522 0 (2,374) (9,458) 2,042,190 0 0 0 0 1,950 (566,200) 0 0 (564,250) (1,389,730) 6,840 1,674 (753,250) (109,545) (6,550) 0 0 (589,375) (36,308) (5,502) 0 0 (688) 3,608,794 0 0 726,360 (1,537,102) 0 95,589 (1,441,513) 762,787 168,457 $ 931,244 Taals SolidWa&e Collection 1993 1992 $2,607,452 $41,725,568 $39,006,323 (1,464,797) (28,261,750) (23,809,n3) (711,225) (4,235,296) (4,019,579) 0 0 301,029 0 889,240 906,028 0 (952,873) (927,050) 193 108,392 31,631 8,869 18,633 6,441 833 6,525 5,285 0 9,515 0 0 211,768 0 0 (49,418) (32,283) (2,279) (11,737) (92,715) 439,046 9,458,567 11,375,337 78,220 78,220 72,318 62,852 62.852 68,658 0 153,393 0 0 86,635 0 0 1,950 0 (138,000) (4,268,454) (4,211,502) (11,000) (206,000) (120,000) 0 0 (1,321,672) (7,928) (4,091,404) (5,512, 198) (28,024) (5,529,261) (4,800,477) 6,300 21,885 57,735 0 64,053 55,937 0 (2,375,000) (2,475,000) 0 (370,795) (376,235) 0 (26,200) (26,200) 0 (451,983) (413,652) (153,393) (153,393) 0 0 (1,720,928) (1,972,978) 0 (125,450) (118,973) 0 (22,008) (25,152) 0 (141,016) (179,347) (86,635) (86,635) 0 0 (5,477) (4,130) 0 4,568,094 0 0 0 1,321,672 0 0 2,092 (261,752) (6,354, 114) (8,954,708) (141,958) (6,078,639) (13,272,008) 0 8,845,289 12,879,609 25,319 811,877 1,361,076 (116,639) 3,578,527 968,677 52,727 2,591,576 (2, 122,892) 7,159 1,051,940 3,174,832 $ 59,886 $3,643,516 $ 1,051,940 -125 - (CITY OF COLLEGE STATION. TEXAS ENTERPRISE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 (With comparative totals for the fiscal year ended September 30, 1992) (Continued) Electric Wat.er Reconciliation cl Operating lnoome to Net Cash Provided by Operating Activities: Operating Income $4,7'Z2.,237 $2,316,937 Adjustments to Reconcile Operating Income to Net Cash Provided by Operating Activities: i)ep.'eciation 862,828 m,321 Amortization 1,843 1,121 Provision for Uncolfec:tible Accounts (198,553) 16,678 Miscellaneous Expenses (3,834) (4,240) Miscellaneous Revenues 29,344 67,099 Change in� and Liabilities: Change in Accounts Recaivable (499,115) (25,549) Change in Other Recaivables 193,126 0 Change in Inventor/ (297,629) 25,426 Change in Prepaid Costs (2,610) 0 Change in Equity in Joint Venture 0 0 Change in Accounts Payable 185,026 (1,184,655) Change in kcrued Liabilities 43,798 4,444 Change In Deferred Revenues 6,486 1,417 Change in Refundable Deposits (63,633) 0 Change in Aa:rued Vacation 382 6,636 T ctal Adjustments 257,459 (319,302) Net Cash Provided by Operating Activities $4,979,696 $1,997,635 Noncash Financing, Capital and Investing Activities: The Electric, Water and Sewer Funds issued revenue bonds in the amount cl $217,350, $496,809, and $320,850, respectively, to refund debt issued in 1985. Sewer $1,495,252 555,466 3,731 3,247 (15,553) 5,5'Z2. 4,906 0 6,342 0 0 (18,141) 5,972 0 0 (4,554) 546,938 $2,042,190 Bond Issuance Costs cl $42,089, $20,042, and $138,291 in the ElectriC, Water, and Sewer Funds, respectively, that were deducted from bond proceeds were capitalized and will be amortized over the debt repayment period. · -126 - Totals SolidW8S.e Colledion 1993 1992 $154,400 $8,688,826 $7,785,390 300,650 2,491,265 2,246,591 0 6,695 4,178 (8,866) (187,494) 95,658 (2,279) (25,906) 0 9,895 111,860 35,897 (10,828) (530,586) (457,034) 0 193,126 (88,546) (5,841) (271,702) 7,605 0 (2,610) 0 0 0 281,222 (7,602) (1,025,372) 1,449,894 5,371 59,585 29,427 0 7,903 (8,672) 0 (63,633) (21,022) 4,146 6,610 14,749 284,646 769,741 3,589,947 $439,046 $9,458,567 $11,375,337 - 127 - CITY OF COLLEGE STATION, TEXAS ELECTRIC FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets current Assets: Equity in Cash and cash Equivalents Equity in Invest•ents Receivables: Accrued Interest Accounts Other Less Allowance for Uncollectible Accounts Interfund Receivable Inventories Prepaid Costs Total Current Assets Restriced Assets: Equity in cash and cash Equivalents Equity in Invest•ents Receivables: Accrued Interest Receivable Accounts Total Restricted Assets Advance to Other Funds Deferred Charges: Bond Issuance Costs Accu•ulated A•ortization Total Deferred Charges Property and Equip•ent: Utility Plant Machinery and Equip•ent Accu•ulated Depreciation construction in Progress Total Property and Equip•ent Total Assets (Continued) -128 - $ 1993 1,588,015 5,867,454 333,979 4,525,622 461 ,451 (512,654) 163,922 1,225,306 21610 1316551705 693,940 2,563,995 49,025 51,567 313581527 110041357 62,313 (4,344) 571969 22,225,595 116. 721 (8,234,263) 415551798 181663,851 $3617401409 $ 1992 551,464 6, 108, 735 228,023 4,026,507 654,578 (711,206) 153,393 927,677 0 1119391171 10, 133 4,650,774 68,321 511567 417801795 111681279 20,224 (2,501) 111723 21,396,666 49,769 (7,401,146) 118981516 1519431805 $3318491773 CITY OF COLLEGE STATION, TEXAS ELECTRIC FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 (Continued) Liabilities and Fund Equity current Liabilities: Accounts Payable Retainage Payable Accrued Liabilities custo•er construction Advances Other 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 Una•ortized Pre•iu• on Bonds General Obligation Bonds Certificates of Obligation Accrued Vacation Total Noncurrent Liabilities Total Liabilities Fund Equity: Contributed Capital Retained Earnings: Reserved for Debt Service Reserved for Capital Projects Unappropriated Total Fund Equity Total Liabilities and Fund Equity -129 - 1993 $ 2,309,807 4,793 248,460 29,857 2.626 2.595,543 236, 189 92,744 104' 114 1,834,449 500,372 134,750 13,100 2,915,718 5,060,328 1, 711 558,250 65,500 71 741 5,757,530 11,268,791 3, 105,236 638,489 5,472,539 16,255,354 25,471,618 $ 36,740,409 1992 $ 2,124,782 0 204,662 23,272 2,725 2,355,441 38,811 80,727 62,626 1,898,082 508,750 134,750 13t100 2,736,846 4,536,550 0 693,000 78,600 71,359 5,379,509 10,471,796 3' 105,236 662,593 5,461,879 14I148, 269 23,377,977 $ 33,849,773 CITY OF COLLEGE STATION, TEXAS ELECTRIC FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS For the Fiscal Years Ended September 30, 1993 and 1992 Operating Revenues: Charges for Sales and Services: Sales of Electricity Other Total Operating Revenues Operating Expenses: Purchased Power Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Reimbursed Administrative Depreciation and Amortization Other Total Operating Expenses Operating Income Nonoperating Revenues (Expenses): Interest Earnings Reimbursed Expenses Interest Expense Other, Net Total Nonoperating Revenues (Expenses) Income Before Operating Transfers (Continued) -130 - 1993 $28,464,801 583,219 29,048,020 19,334,322 1,614,435 104,003 458,542 356,373 130' 197 341,490 1,098,562 862,828 251031 2413251783 417221237 781,825 153,683 (450,460) (2011653) 2831395 510051632 1992 $27,320,323 539,660 27,859,983 18,637,583 1,501,016 76' 180 237,691 355,740 96,928 331_,180 1,002'156 725,945 1291614 2310941033 417651950 895, 188 82,383 (484,631) { 202 I 115) 2901825 510561775 CITY OF COLLEGE STATION, TEXAS ELECTRIC FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS For the Fiscal Years September 30, 1993 and 1992 (Continued) 1993 Operating Transfers Out $(2,871 ,704) Income Before Extraordinary Item 2, 133 ,928 Extraordinary Item -Loss on Refunding (40,287) Net Income 2,093,641 Retained Earnings, October 1 20,272,741 Retained Earnings, September 30 $2213661382 -131 - 1992 $ (2, 670, 192) 2,386,583 0 2,386,583 17,886,158 $2012721741 CITY OF COLLEGE STATION. TEXAS ELECTRIC FUND SCHEDULE OF REVENUES BUDGET AND ACTUAL(BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 Operating Revenues: Electric Sales Forfeits, Discounts, Penalties Electric Property Rentals Miscellaneous Service Revenue Total Operating Revenues Nonoperating Revenues: Interest Earnings Reimbursed Expenses Miscellaneous Nonoperating Revenue Total Nonoperating Revenues Operating Transfers In Energy Project Fund: Interest Earnings Revenue Bond I & S Fund: Interest Earnings Operating Transfers In Total Revenue Bond I & S Fund Electric Revenue Bond Funds: Interest Earnings Other Proceeds from Long Term Debt Total Electric Revenue Bond Funds Total Electric Fund Revenues See reconciliation to GAAP basis on page 150. -132 - Budget Actual $30,098, 181 $28,392,842 310,000 298,483 20,000 20,229 75,000 264,507 30,503, 181 28,976,061 610,000 676,083 69,000 153,683 5,000 72,009 684,000 901,775 518,271 518,271 15,000 29,646 0 36,269 1, 155,082 338,038 1, 155,082 374,307 313,700 39,825 0 471 0 959,300 313,700 999,596 $33, 189, 234 $31,799,656 Variance Favorable (Unfavorable) $(1, 705,339) (11,517) 229 189,507 (1,527, 120) 66,083 84,683 67,009 217,775 0 14,646 36,269 (817,044) (780,775) (273,875) 471 959,300 685,896 $(1,389,578) CITY OF COLLEGE STATION, TEXAS ELECTRIC FUND SCHEDULE OF EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 Budget Actual Administration: Salaries and Benefits $ 159,378 $ 155,632 Supplies 31,750 29,389 Maintenance 44,450 44,446 Purchased Professional Services 113,482 113,428 Purchased Property Services 51,720 50,205 Other Purchased Services 80,480 44,381 Capital Outlay 50,900 26,910 Total Administration 532,160 464,391 Technical Services: Salaries and Benefits 837,535 833,902 Supplies 86,780 86,680 Maintenance 174,893 171,975 Purchased Professional Services 74,570 33,642 Purchased Property Services 19,821,886 19,400,292 Other Purchased Services 139,009 128,900 Capital Outlay 294,972 259,669 Total Technical Services 21,429,645 20,915,060 Electric Transmission/Distribution: Salaries and Benefits 837,712 834,891 Supplies 47,970 41,885 Maintenance 283,210 282,706 Purchased Professional Services 313,550 277,566 Purchased Property Services 14,050 14,022 Other Purchased Services 168,432 168,213 Capital Outlay 861,477 858,920 Total Electrical Transmission/Distribution 2,526,401 2,478,203 Nondepartmental: Depreciation 824,670 862,828 Principal Payments 147,850 147,850 Interest Expense 49,023 49,023 Payment in lieu of T a><es 2,871,704 2,871,704 Special Programs/Projects 45,000 47,044 Reimbursed Debt Service 958,209 338,038 Reimbursed Administrative 1,557,550 1,557,550 Public Agency Funding 195,000 195,000 Inventory Loss 0 (35,335) Extraordinary Loss on Revenue Bond Refunding 0 40,287 Contingency 128,909 0 Total Nondepartmental 6,777,915 6,073,989 Revenue Bond I & S Fund: Principal Payments 535,845 508,750 Interest Expense 411,521 394,270 Fiscal Agenfs Fees 0 4,141 Total Revenue Bond I & S Fund 947,366 907,161 Electric Revenue Bond Fund: Reimbursed Administrative 59,283 59,283 Capital Outlay 4,591,998 2,056,772 Contingency 100,000 0 Total Electric Revenue Bond Fund 4,751,281 2,116,055 Total Electric Fund Expenses $36,964,768 $32,954;859 See reconciliation to GMP basis on page 150. -133 - Variance Favorable (Unfavorable) $ 3,746 2,361 4 54 1,515 36,099 23,990 67,769 3,633 100 2,918 40,928 421,594 10,109 35,303 514,585 2,821 6,085 504 35,984 28 219 2,557 48,198 (38,158) 0 0 0 (2,044) 620,171 0 0 35,335 (40,287) 128,909 703,926 27,095 17,251 (4, 141) 40,205 0 2,535,226 100,000 2,635,226 $4,009,909 CITY OF COLLEGE STATION, TEXAS WATER FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets Current Assets: Receivables: Accounts Less Allowance for uncollectible Accounts Inventories Total Current Assets Restriced Assets: Equity in Cash and Cash Equivalents Equity in Investaents Receivables: Accrued Interest Receivable Special Assessaents Total Restricted Assets Deferred Charges: Water Well Bond Issuance Costs Accuaulated A•ortization Total Deferred Charges Property and Equipaent: Utility Plant Buildings Machinery and Equipaent Accuaulated Depreciation construction in Progress Land Total Property and Equipaent Total Assets (Continued) -134 - 1993 $ 512,538 (23,044) 251,840 741 ,334 370,431 1,368,683 41 ,604 11865 1,782,583 1,167,075 33,542 (1 j 018 I 943) 1811674 28,562,568 898,760 573,463 (8,118,981) 405,849 5291609 2218511268 $2515561859 1992 $ 486,989 (6,368) 277,266 757,887 314,727 3,486,333 81,731 0 3,8821791 1,167,075 13,499 {9621963) 2171611 27,812,282 811,654 572,032 (7,365,430) 439,395 5291609 221799,542 $2716571831 CITY OF COLLEGE STATION, TEXAS WATER FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 (Continued) Liabilities and Fund Equity Current Liabilities: Accounts Payable Obligations Under Capital Lease Accrued Liabilities Custo•er Construction Advances Total Current Liabilities Current Liabilities Payable fro• Restricted Assets: Accounts Payable Accrued Interest Payable Retainage Payable Revenue Bonds General Obligation Bonds Certificates of Obligation Miscellaneous Accrued Liabilities Total Current Liabilities Payable fro• Restricted Assets Noncurrent Liabilities: Revenue Bonds Una•ortized Pre•iu•s General Obligation Bonds certificates of Obligation Obligation Under Capital Lease Accrued Vacation Total Noncurrent Liabilities Total Liabilities Fund Equity: Contributed Capital Retained Earnings Reserved for Debt Service Reserved for Capital Projects Unappropriated Total Fund Equity Total Liabilities and Fund Equity - 135 - $ 1993 737,059 494,221 29,175 2, 150 1,262,605 1,422 126,410 19,704 1,089,944 126,500 6,550 22 1,370,552 7,005,656 815 383,500 32,750 1,332,257 35,527 8,790,505 11,423,662 3,091,793 1,531,855 3,495,385 6, 014I164 14I133I197 $ 25,556,859 1992 $ 1,921,712 451,982 24,731 733 2,399,158 9,079 139,502 3,089 1,113,000 126,500 6,550 0 1,397,720 8,040,400 0 510,000 39,300 1,826,479 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 CITY OF COLLEGE STATION. TEXAS WATER FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS For the Fiscal Years Ended September 30, 1993 and 1992 Operating Revenues: Charges for Sales and Services: Sales of Water Other Total Operating Revenues Operating Expenses: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Reimbursed Administrative Depreciation and Amortization Other Total Operating Expenses Operating Income Nonoperating Revenues (Expenses): Interest Earnings Reimbursed Expenses Contributions Interest Expense Other, Net Total Nonoperating Revenues (Expenses) Income Before Operating Transfers (Continued) -136 - 1993 $ 5,734,669 152,045 5,886,714 945,234 83,539 194' 100 6,219 618,740 121,793 811,155 772,321 16,676 315691777 213161937 42,312 16,895 0 (899,523) (231255) (863,571) 1,4531366 1992 $ 5' 190 ,561 128,591 5,319,152 871,502 94,391 120,666 8,094 615' 134 123,330 784,866 749,954 321031 313991968 119191184 115,396 4, 178 1,530 (i,070,022) (411304) (9901222) 9281962 CITY OF COLLEGE STATION, TEXAS WATER FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS For the Fiscal Years September 30, 1993 and 1992 (Continued) 1993 Operating Transfers Out $ (692,550) Income Before Extraordinary Item 760,816 Extraordinary Item -Loss on Refunding (43,502) Net Income 717,314 Retained Earnings, October 1 10,324,090 Retained Earnings, September 30 $ 11 I 0411404 -137 - 1992 $ (616,980) 311,982 0 311,982 10,012, 108 $1013241090 Operating Revenues: Water Sales Forfeits, Discounts, Penalties Water Taps Total Operating Revenues Nonoperating Revenues: Interest Reimbursed Expenses CITY OF COLLEGE STATION, TEXAS WATER FUND SCHEDULE OF REVENUES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 Budget Actual $5,566,777 $5,710,580 40,000 55,495 50,000 96,550 5,656,777 5,862,625 0 (42, 183) 1,500 16,895 Miscellaneous Nonoperating Revenue 6,000 3,162 Total Nonoperating Revenues 7,500 (22,126) Operating Transfers In 100,223 100,223 Revenue Bond I & S Fund: Interest Earnings 0 5,559 Operating Transfers In 1,938,238 620,897 Total Revenue Bond I & S Fund 1,938,238 626,456 Water Revenue Bond Fund: Interest on Investments 156,400 78,936 Total Water Revenue Bond Fund 156,400 78,936 Total Water Fund Revenues $7,859,138 $6,646,114 See reconciliation to GAAP basis on page 150. -138 - Variance Favorable (Unfavorable) $ 143,803 15,495 46,550 205,848 (42, 183) 15,395 (2,838) (29,626) 0 5,559 (1,317,341) (1,311, 782) (77,464) (77,464) $(1,213,024) CITY OF COLLEGE STATION. TEXAS WATER FUND SCHEDULE OF EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 Budget Actual Water Production/Distribution/Engineering: Salaries and Benefits $ 983,443 $ 945,248 Supplies 143,745 121,015 Maintenance 243,230 194, 100 Purchased Professional Services 8,440 6,219 Purchased Property Services 1,205,240 1,182,450 Other Purchased Services 138,460 121,793 Capital Outlay 22,265 17,717 Total Water Production/Distribution/Engineering 2,744,823 2,588,542 Nondepartmental: Depreciation 772,000 772,321 Principal Payments 133,050 133,050 Interest Expense 33,243 36,625 Payment in Lieu of Taxes 690,600 690,600 Special Programs/Projects 3,310 2,374 Reimbursed Debt Service 1, 771,945 620,897 Reimbursed Administrative 855,917 855,917 Extraordinary Loss Revenue Bond Refunding 0 43,503 Contingency 59,458 0 Other Non-operating Expenses 0 1,866 Total Nondepartmental 4,319,523 3, 157, 153 Revenue Bond I & S Fund: Principal Payments 1,050,950 1, 113,000 Interest Expenses 698,858 737,283 Fiscal Agent's Fees 0 648 Total Revenue Bond I & S Fund 1,749,808 . 1,850,931 Water Revenue Bond Fund: Reimbursed Administrative 61,808 61,808 Operating Transfers Out 0 1,950 Capital Outlay 2,224,539 764,107 Contingency 80,000 0 Total Water Revenue Bond Fund 2,366,347 827,865 Total Water Fund Expenses $11, 180,501 $8,424,491 See reconciliation to GAAP basis on page 150. -139 - Variance Favorable (Unfavorable) $ 38, 195 22,730 49, 130 2,221 22,790 16,667 4,548 156,281 (321) 0 (3,382) 0 936 1,151,048 0 (43,503) 59,458 (1,866) 1, 162,370 (62,050) (38,425) (648) (101,123) 0 (1,950) 1,460,432 80,000 1,538,482 $2,756,010 CITY OF COLLEGE STATION, TEXAS SEWER FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets Current Assets: Equity in Cash and Cash Equivalents Equity in Invest•ents Receivables: Accrued Interest Accounts Special Assess•ents Less Allowance for Uncollectible Accounts Inventories Prepaid Costs Total Current Assets Restriced Assets: Equity in Cash and Cash Equivalents Equity in Invest•ents Receivables: Accrued Interest Receivable Total Restricted Assets Deferred Charges: Bond Issuance Costs Accu•ulated A•ortization Total Deferred Charges Property and Equip•ent: Utility Plant Buildings Machinery and Equip•ent Accu•ulated Depreciation Construction in Progress Land Total Property and Equip•ent Total Assets (Continued) -140- 1993 $ 280,177 1,035,207 65,019 234,009 4,794 (8,554) 7,228 600 116181480 651,067 2,405,586 98,887 3,155,540 169,455 (7,568) 1611887 20,603,879 811,654 1 ,239,547 (5,460,250) 2,342,854 4261323 19,964,007 $2418991914 1992 $ 47,475 563,530 14,389 238,915 4,794 (5,309) 13,570 600 8771964 120,982 1,340,161 39a141 1,500,284 31 ,034 !31838) 27 1196 19,920,864 811,654 998,787 (4,935,662) 2' 112' 794 4141641 19,323,078 $2117281522 CITY OF COLLEGE STATION, TEXAS SEWER FUND COMPARATIVE BALANCE SH EETS September 30, 1993 and 1992 (Continued) Liabilities and Fund Equity current Liabilities: Accounts Payable Accrued Liabilities Custo1er Construction Advances Total Current Liabilities current Liabilities Payable fro1 Restricted Assets: Accounts Payable Accrued Interest Payable Retainage Payable Revenue Bonds General Obligation Bonds Certificates of Obligation Total Current Liabilities Payable fro• Restricted Assets Noncurrent Liabilities: Revenue Bonds Una1ortized Pre1iu1s General Obligation Bonds Certificates of Obligation Accrued Vacation Total Noncurrent Liabilities Total Liabilities Fund Equity: Contributed Capital Retained Earnings: Reserved for Debt Service Reserved for Capital Projects Unappropriated Total Fund Equity Total Liabilities and Fund Equity -141 - $ 1993 57,515 30,876 400 88,791 37,913 178,383 66,028 744,684 117' 705 6,550 1,151,263 9,769,016 5,623 454,910 32,750 29,761 10,292,060 11 I 532 I 114 4,071,098 1,197,729 2,799,175 5,299,798 13,367,800 $ 24,899,914 $ 1992 75,654 24,904 0 100,558 234,634 111,757 62,612 753,250 109,545 6,550 1,278,348 6,778,050 0 572,615 39,300 34,315 7,424,280 8,803I186 1,080,577 2,845, 158 4,957,997 12,925,336 $ 21,728,522 CITY OF COLLEGE STATION. TEXAS SEWER FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS For the Fiscal Years Ended September 30, 1993 and 1992 Operating Revenues: Charges for Sales and Services: Sewer Fees Other Total Operating Revenues Operating Expenses: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Reimbursed Administrative Depreciation and Amortization Other Total Operating Expenses Operating Income Nonoperating Revenues (Expenses): Interest Earnings Interest Expense Other, Net Total Nonoperating Revenues (Expenses) Income Before Operating Transfers (Continued) -142- 1993 $ 4,587,982 115, 158 4I703!140 990,426 130,887 138' 195 38,329 435,832 166,740 749,429 555,466 2,584 3,2071888 114951252 205,965 (681,877) 41029 {4711883) 110231369 1992 $ 4,251, 124 94,227 4,345,351 943,987 106,048 177 ,306 42,437 398,076 112,243 661,078 526' 130 31724 219711029 113741322 257,238 (704,237) {731274) {5201273) 8541049 CITY OF COLLEGE STATION, TEXAS SEWER FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS For the Fiscal Years September 30, 1993 and 1992 (Continued) Operating Transfers In (Out): Operating Transfer In Operating Transfers Out Total Operating Transfers In (Out) Income Before Extraordinary Item Extraordinary Item -Loss on Refunding Net Income Retained Earnings, October 1 Retained Earnings, September 30 -143. 1993 $ 1,950 (5661200) (564,250) 459,119 ( 461149) 412,970 81883,732 $ 9:2961702 1992 $ 0 (4531600) ( 453-1600) 400,449 0 400,449 8,4831283 $ 8:883:732 CITY OF COLLEGE STATION, TEXAS SEWER FUND SCHEDULE OF REVENUES BUDGET AND ACTUAL (BUDGETARY BASlS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 Budget Actual Operating Revenues: Sewer Service $4,776,579 $4,588,772 Forfeits, Discounts, Penalties 38,000 47,533 Sewer Taps 30,000 67,625 Total Operating Revenues 4,844,579 4,703,930 Nonoperating Revenues: Interest Earnings 60,000 114,221 Miscellaneous Nonoperating Revenue 4,400 12,462 Total Nonoperating Revenues 64,400 126,683 Revenue Bond I & S Fund: Interest Earnings 0 7,649 Operating Transfers In 1,938,238 699,566 Total Revenue Bond I & S Fund 1,938,238 707,215 Sewer Revenue Bond Funds: Interest Earnings 307,800 84,094 Special Assessments 0 1,674 Operating Transfers In 0 1,950 Proceeds from Long Term Debt Issuance 4, 150,000 3,608,794 Total Sewer Revenue Bond Funds 4,457,800 3,696,512 Total Sewer Fund Revenues $11,305,017 $9,234,340 See reconciliation to GAAP basis on page 150. -144- Variance Favorable (Unfavorable) $ {187,807) 9,533 37,625 (140,649) 54,221 8,062 62,283 7,649 (1,238,672) (1,231,023) (223,706) 1,674 1,950 (541,206) (761,288) $(2, 070, 677) Sewer Treatment/Collection: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Capital Outlay Total Sewer Treatment/Collection Nondepartmental: Depreciation Expense Principal Payments Interest Expense Payment in Lieu of Taxes Special Prorams/Projects Reimbursed Debt Service Reimbursed Administrative Contingency Inventory Loss CITY OF COLLEGE STATION. TEXAS SEWER FUND SCHEDULE OF EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 Budget Actual $1,017,187 $1,003,239 134,693 130,967 178,616 139,402 69,880 38,328 435,870 435,832 166,765 166,740 64,193 48,277 2,067,204 1,962,785 619,500 555,466 113, 149 116,095 38,584 41,810 566,200 566,200 3,310 2,374 1,559,916 699,566 640,950 640,949 60,000 0 0 (661) Extraordinary Loss on Revenue Bond Refunding 0 46,148 Total Nondepartmental 3,601,609 2,667,947 Revenue Bond I & S Fund: Principal Payments 788,205 753,250 Interest Expense 610,552 589,375 Fiscal Agent's Fees 0 688 Total Revenue Bond I & S Fund 1,398,757 1,343,313 Sewer Revenue Bond Fund: Reimbursed Administrative 120,253 120,253 Bond Issuance Costs 0 130 Capital Outlay 5,811,413 1,094,440 Contingency 50,000 0 Total Sewer Revenue Bond Fund 5,981,666 1,214,823 Total Sewer Fund Expenses $13,049,236 $7,188,868 See reconciliation to GAAP basis on page 150. -145- Variance Favorable (Unfavorable) $ 13,948 3,726 39,214 31,552 38 25 15,916 104,419 64,034 (2,946) (3,226) 0 936 860,350 1 60,000 661 (46, 148) 933,662 34,955 21, 177 (688) 55,444 0 (130) 4,716,973 50,000 4,766,843 $5,860,368 CITY OF COLLEGE STATION, TEXAS SOLID WASTE COLLECTION FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets current Assets: Equity in cash and cash Equivalents Equity in Invest•ents Receivables: Accrued Interest Accounts Less Allowance for Uncollectible Accounts Inventories Total Current Assets Note Receivable fro• Joint Venture Equity in Joint Venture Property and Equip•ent: Machinery and Equip•ent Accu•ulated Depreciation Total Property and Equip•ent, Net Total Assets Liabilities and Fund Equity current Liabilities: Accounts Payable Interfund Payable Accrued Liabilities Total Current Liabilities Noncurrent Liabilities: Advances fro• Other Funds Accrued Vacation Total Noncurrent Liabilities Total Liabilities Fund Equity: Contributed Capital Retained Earnings: Unappropriated Total Fund Equity Total Liabilities and Fund Equity -146 - $ $ 1993 59,886 221,268 37' 189 169,454 (5,573) 51841 488,065 7581599 2951597 2,373,681 (112331242) 111401439 $ 216821700 16,428 163,922 201515 2001865 1,004,357 231873 1,0281230 1,2291095 54,901 113981704 114531605 $ 21682,700 $ $ 1992 7J159 79,310 27,833 158,626 (14,439) 0 2581489 8361819 3501038 2,345,657 (9321592) 1,4131065 $ 2,858,411 24,029 153,393 15 144 192,566 1,168,279 19 727 1,1881006 113801572 54,901 114221938 114771839. $ 218581411 CITY OF COLLEGE STATION, TEXAS SOLID WASTE COLLECTION FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS For the Fiscal Years Ended September 30, 1993 and 1992 Operating Revenues: Charges for Sales and Services: Garbage Collection Fees Other Total Operating Revenues Operating Expenses: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Reimbursed Administrative Depreciation Other Total Operating Expenses Operating Income Nonoperating Revenues (Expenses): Interest Earnings Reimbursed Expenses Earnings (Loss) in Joint Venture Interest Expense Other, Net Total Nonoperating Revenues (Expenses) Income Before Operating Transfers Operating Transfers Out Net Loss Retained Earnings, October 1 Retained Earnings, September 30 -147- 1993 $ 2,570,879 47,401 2,618,280 728,980 77,508 91,040 66,376 627,831 192,624 378,871 300,650 0 2,463,880 154,400 97,527 193 (54,441) (86,635) 21722 (401634) 1131 766 (138,000) (24,234) 114221938 $ 113981704 1992 $ 1,907,028 31 ,843 1 ,938,871 740,924 62' 168 70,499 53,703 516,538 161,017 347,376 244,562 161150 2,212,937 (2741066) 68,658 0 19,807 (51,389) (981956) (611880) (3351946) ( 1491100) (485,046) 11907 1984 $ 114221938 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 Other Reimbursed Expenses Miscellaneous Total Nonoperating Revenues 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, 1993 Budget Actual $1,687,000 $1,646,728 830,000 920,238 0 112 20,000 0 16,000 27,398 4,600 19,890 4,000 0 2,561,600 2,614,366 39,000 97,526 0 194 0 4,856 39,000 102,576 $2,600,600 $2,716,942 See reconciliation to GAAP basis on page 150. - 148 - Variance Favorable (Unfavorable} $(40,272) 90,238 112 (20,000) 11,398 15,290 (4,000) 52,766 58,526 194 4,856 63,576 $116,342 Commercial Collection: Salaries and Benefits Supplies Maintenance 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 Contingency Total Nondepartmental Total Solid Waste Collection Fund Expenses CITY OF COLLEGE STATION. TEXAS SOLID WASTE COLLECTION FUND SCHEDULE OF EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 Budget Actual $ 242,809 $ 241,272 39,660 23,770 41,500 41,361 396,220 396,137 68,420 60,773 788,609 763,313 493,026 487,707 57,455 53,738 52,495 49,679 66,390 66,376 239,750 231,694 131,870 131,851 28,040 28,024 1,069,026 1,049,069 246,550 300,650 131,075 153,393 102,442 86,635 378,871 378,871 11,000 11,000 138,000 138,000 19,000 0 1,026,938 1,068,549 $ 2,884,573 $ 2,880,931 See reconciliation to GAAP basis on page 150. -149 - Variance Favorable (Unfavorable) $ 1,537 15,890 139 83 7,647 25,296 5,319 3,717 2,816 14 8,056 19 16 19,957 (54, 100) (22,318) 15,807 0 0 0 19,000 (41,611) $ 3,642 CITY OF COLLEGE STATION. TEXAS ELECTRIC, WATER, SEWER AND SOLID WASTE COLLECTION FUNDS SCHEDULE FOR RECONCILIATION OF REVENUES AND EXPENSES (BUDGETARY BASIS) TO GAAP BASIS STATEMENT OF INCOME FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 Total Revenues Per Budget -Actual Less Total Expenses Per Budget -Actual Net Gain (Loss), Budgetary Basis Add (Subtract) -Expenses (Revenues) Related to Balance Sheet: Debt Service Principal Payment Capital Outlay Capital Lease Principal Payments Reclass Salaries and Benefits to Construction in Progress Proceeds from Long Term Debt Issuance Add (Subtract) -Unbudgeted Revenue/(Expense) Adjustments: Current Year Revenue Accrual Prior Year Interest Expense Accrual Investment in Joint Venture Amortization Of Bond Issuance Costs Prior Year Revenue Accrual Current Year Interest Expense Accrual Bad Debt Expense Inventory Adjustment Water Well Expense Accrual Other Net Income (Loss), GAAP Basis Electric $31,799,656 32,954,859 (1, 155,203) 656,600 3,237,082 0 337,982 (959,300) 1,042,087 80,727 0 (1,843) (970, 127) (87,894) (60,367) (26, 125) 0 22 $ 2,093,641 -150 - Water $6,646, 114 8,424,491 (1,778,377) $ 1,246,050 819,301 451,983 6,612 0 237,958 139,502 0 (1, 121) (213,869) (124, 100) (16,676) (20,419) (29,289) (241) 717,314 Sewer $9,234,340 7, 188,868 2,045,472 869,345 1, 142,717 0 25,888 (3,608,794) 171, 190 111,757 0 (3,731) (171,980) (162,448) (3,245) (1,683) 0 (1,518) $ 412,970 Solid Waste $2,716,942 2,880,931 (163,989) 153,393 28,024 0 0 0 86,457 0 (54,441) 0 (82,545) 0 8,867 0 0 0 $ (24,234) INTERNAL SERVICE FUNDS Internal service funds are used to account for the financing of goods or services provided by one department or agency to other departments or agencies of the government and to other government units, on a cost reimbursement basis. Employee Benefits -to account for self-insurance activity relating to administration of the City's health benefits plan. Fleet Replacement -to account for the purchase of City vehicles 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 City 's electric, water, and sewer utilities and residential and commercial garbage collection. Workers' Compensation -to account for self-insurance activity relating to administration of the City 's workers' compensation plan. -151 • CITY OF COLLEGE STATION, TEXAS INTERNAL SERVICE FUNDS COMBINING BALANCE SHEET September 30, 1993 (With comparative totals for the fiscal year ended September 30, 1992) Assets Current Assets: Equity in Cash and Cash Equivalents Equity in Invest•ents Receivables: Accrued Interest Accounts Less Allowance for Uncollectible Accounts Inventories Prepaid Costs Total Current Assets Property and Equip•ent: Machinery and Equip•ent General Electric Plant Less Accu•ulated Depreciation Construction in Progress Total Property and Equip•ent, Net Total Assets Liabilities and Fund Equity current Liabilities: Accounts Payable Retainage Payable Clai•s Payable Accrued Liabilities Total Current Liabilities Noncurrent Liabilities: Accrued Vacation Total Noncurrent Liabilities Total Liabilities Fund Equity: Contributed Capital Unreserved Retained Earnings (Deficit) Total Fund Equity Total Liabilities and Fund Equity -152 - E•ployee Benefits $ 12,962 47,893 3, 136 159,833 0 0 3,800 227,624 0 0 0 0 0 $ 227,624 $ 7 ,327 0 272,981 3 764 284,072 0 0 284 ,072 0 (56,448) (56,448) $ 227,624 Fleet ReplaceR1ent $ 232,449 858,863 39,095 0 0 0 0 1, 130,407 1,340,586 0 (216,586) 0 1,124,000 $2,254,407 $ 162,485 0 0 0 162,485 0 0 162,485 0 2,091,922 2,091,922 $2,254,407 Landfill $ 97,521 360,323 11 , 917 0 0 0 0 469, 761 36,530 0 (13,889) 0 22,641 $ 492,402 $ 368,644 17,045 0 10,865 396,554 11 914 11 914 408,468 0 83,934 83,934 $ 492,402 Property Totals and Utility Workers' Casualty Une•ploy•ent Billing Co•pensation 1993 1992 $ 11,575 $ 29,864 $ 79,984 $ 128,760 $ 593,115 $ 142,568 42,767 110,343 295,530 475,745 2,191,464 1'579' 291 1,463 5,018 13,380 21,429 95,438 39,587 2,841 0 0 0 162,674 22,802 (2,425) 0 0 0 (2,425) (175) 0 0 0 0 0 532 0 0 365 0 41165 31800 56,221 145,225 389,259 625,934 3,044,431 1,788,405 0 0 0 0 1,377,116 750,372 0 0 545,266 0 545,266 541, 161 0 0 (452,868) 0 (683,343) (414,626) 0 0 251028 0 251028 0 0 0 117 1426 0 112641067 8761907 $ 561221 $ 145,225 $ 5061685 $ 6251934 $413081498 $21665,312 $ 4,758 $ 0 $ 3,487 $ 15,685 $ 562,386 $ 125,249 0 0 0 0 17' 045 0 46,885 0 0 154 ,044 473,910 478,098 0 0 61155 0 201784 161967 511643 0 9,642 1691729 110741125 620,314 0 0 351810 0 47.724 451607 0 0 351810 0 471724 451607 51,643 0 451452 169,729 1,121,849 6651921 0 0 381,137 0 381'137 381, 137 41578 1451225 801096 4561205 218051512 116181254 41578 1451225 4611233 4561205 311861649 1 19991391 $ 561221 $ 1451225 $ 5061685 $ 6251934 $413081498 $216651312 . 153. CITY OF COLLEGE STATION, TEXAS INTERNAL SERVICE FUNDS COMBINING STATEMENT OF REVENUESA EXPENSES AND CHANGES IN RETAINED EARNING\:> (DEFICIT) For the Fiscal Year Ended September 30, 1993 (With comparative totals for the fiscal year ended September 30, 1992) Operating Revenues: Charges for Services Pre•iu•s Total Operating Revenues Operating Expenses: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased·Services Claims Ad•inistration Fees Pre•iu•s Rei•bursed Ad•inistrative Depreciation Other Total Operating Expenses Operating Income (Loss) Nonoperating Revenues (Expenses): Interest Earnings Rei•bursed Expenses Interest Expense Other, Net Total Nonoperating Revenues (Expenses) Net Inco•e Before Operating Transfers Operating Transfers In (Out): Operating Transfers In Operating Transfers Out Total Operating Transfers In (Out) Net Income Retained Earnings (Deficit), October 1 Retained Earnings (Deficit), Septe•ber 30 -154 - E•ployee Benefits $ 0 1,594,473 1 ,594 ,473 0 0 0 0 0 0 1,148,010 92,529 304,716 35,639 0 15,412 1,596,306 (1,833) 34' 100 0 0 (276) 33,824 31 I 991 0 0 0 31,991 (88,439) $ (56,448) Fleet Replace•ent $ 877,440 0 877,440 0 0 0 0 0 0 0 0 0 0 158,997 0 158,997 718,443 87,734 0 0 0 87,734 806,177 0 0 0 806, 177 1,285,745 $2,091,922 Landfill $1,476,940 0 1,476,940 382,768 105,658 137,023 585,256 20,075 15,763 0 0 0 204,770 6,889 534 1,458,736 18,204 28,296 0 0 0 28,296 46,500 0 0 0 46,500 37,434 $ 83,934 Property Totals and Utility Workers' Casualty Une•ploy11ent Billing Co•pensation 1993 1992 $ 0 $ 0 $ 1,423,733 $ 0 $ 3,778,113 $ 3,311,465 388,740 52,425 0 447,996 2,483,634 2,368,844 388,740 52,425 1,423,733 447,996 6,261,747 5,680,309 0 0 815,608 0 1,198,376 1, 138,452 0 0 37,659 0 143 ,317 107,826 0 0 10,551 0 147,574 82,251 0 0 44 0 585,300 12,858 0 0 21,699 0 41'774 33,938 0 0 93,635 0 109,398 104' 105 58,744 24,583 0 298,982 1,530,319 1,307,812 0 0 0 15,864 108,393 118,723 257,491 0 0 30,742 592,949 587,880 47,031 7,856 200,721 53,052 549,069 401,088 0 0 107 ,689 0 273,575 167,844 7 903 0 0 0 23,849 475 371I169 32,439 1,287,606 398,640 5,303,893 4,063,252 17 571 19,986 136,127 49,356 957,854 1,617,057 1,463 9,313 31,087 38,871 230,864 108,038 0 0 0 0 0 5,635 0 0 0 0 0 (7,608) 0 0 (1J184) 0 (1,460) (13,942) 463 9,313 29,903 38 I 871 229,404 92J123 19,034 29,299 166,030 88,227 1, 187 J 258 1I709, 180 55,480 0 0 0 55,480 0 0 0 0 (55,480) (55,480) 0 55,480 0 0 (55,480) O· 0 74,514 29,299 166,030 32,747 1,187,258 1, 709, 180 (69,936) 115,926 (85,934) 423,458 1,618,254 (90,926) $ 41578 $ 1451225 $ 801096 $ 4561205 $ 218051512 $ 116181254 -155 - CITY OF COLLEGE STATION. TEXAS INTERNAL SERVICE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 (With Co mparative Totals for the Fiscal Year Ended September 30, 1992) Employee Fleet Benefits Replacement Cash Flows from Operating Activities: Cash Received from Customers $1,457,267 $ 877,440 Cash Provided by (Payments to)Suppliers for Goods and Services (1,616,453) 162,260 Cash Payments to Employees for Services 0 0 Other 0 0 Net Cash Provided (Used) by Operating Activities (159, 186) 1,039,700 Cash Flows from Noncapital Financing Activities: Operating Transfers in From Other Funds 0 0 Operating Transfers Out to Other Funds 0 0 Other 0 0 Net Cash Provided (Used) by Noncapital Financing Activities 0 0 Cash Flows from Capital and Related Financing Activities: Acquisition of Capital Assets 0 (624,592) Proceeds from Sale of Assets 0 0 Net Cash Used by Capital and Related Financing Activities 0 (624,592)' Cash Flows from Investing Activities: Purchase of Investments (200,850) (355,792) Proceeds from Sale anq Maturities of Investment Securities 321,833 60,092 Interest on Investments 36, 196 62,202 Other (276) 0 Net Cash Provided (Used) by Investing Activities 156,903 (233,498) Net Increase (Decrease) in Cash and Cash Equivalents (2,283) 181,610 Cash and Cash Equivalents, October 1 15,245 50,839 Cash and Cash Equivalents, September 30 $ 12,962 $ 232,449 Reconciliation of Operating Income (Loss) to Net Cash Provided (Used) by Operating Activities: Operating Income (Loss) $ (1,833) $ 718,443 Adjustments to Reconcile Operating Income (loss) to Net Cash Provided (Used) by Operating Activities Depreciation 0 158,997 Provision for Uncollectible Accounts 0 0 Change in Assets and Liabilities: Change in Accounts Receivable (137,206) 0 Change in Inventory 0 0 Change in Prepaid Costs 0 O· Change in Accounts Payable 5,757 162,260 Change in Retainage Payable 0 0 Change in Accrued Liabilities (25,904) 0 Change in Accrued Vacation 0 0 Total Adjustments (157,353) 321,257 Net Cash Provided (Used) by Operating Activities $ (159,186) $1,039,700 • 156- Landfill $1,476,940 (689,324) (377,967) 0 409,649 0 0 0 0 (2, 151) 0 (2, 151) (329, 168) 0 16,379 0 (312,789) 94,709 2,812 $ 97,521 $ 18,204 6,889 0 0 532 0 362, 178 17,045 2,704 2,097 391,445 $ 409,649 Property and Utility Workers' Totals Casualty Unemployment Billing Compensation 1993 1992 $ 386,074 $ 52,425 $1,423,733 $ 447,996 $6,121,875 $5,657,916 (387,2 1 2) (32,439) (366,792) (449,964) (3,379,924) (2,693, 747) 0 0 (814,082) 0 (1, 192,049) (1, 132,538) 0 0 0 0 0 (180) (1,138) 19,986 242,85 9 (1,96 8) 1,549,902 1,831,451 55,48 0 0 0 0 55,480 0 0 0 0 (55,480) (5 5,48 0) 0 0 0 0 0 0 (15,916) 55,48 0 0 0 (55,480) 0 (15,916) 0 0 (35,303) 0 (662,046) (749,946) 0 0 127 0 127 0 0 0 (35, 1 76) 0 (661,919) (749,946) (42,767) (45,909) (161,056) (197,025) (1,332,567) (2, 751,628) 0 39,431 0 299,038 720,394 1 ,652,787 0 6,980 21,21 8 32,038 1 75,013 79,498 0 0 0 0 (276) 0 (42,767) 502 (139,838) 134,051 (437,436) (1,019,343) 1 1,575 20,488 67,845 76,603 450,547 46,246 0 9,376 12, 139 52,157 142,568 96,322 $ 11,575 $ 29,864 $ 79,984 $ 128,760 $ 593,115 $ 1 42,568 $ 17,571 $ 1 9,986 $ 136 ,127 $ 49,356 $ 957,854 $1,617,057 0 0 107,689 0 273,575 167,844 2,250 0 0 0 2,250 175 (2,666) 0 0 0 (139,872) (22,573) 0 0 0 0 53 2 (532) 0 0 (365) 0 (365) 20 (42,07 8) 0 (1 ,789) (49,191) 43 7 ,137 (74,624) 0 0 0 0 17,045 139, 177 23,785 0 1,177 (2, 133) (371) 4,907 0 0 20 0 2,117 0 (18,709) 0 106,732 (51,324) 592,048 214,394 $ (1, 138) $ 19,986 $ 242,859 $ (1 ,968 ) $1,549,902 $1,831,451 -157 - CITY OF COLLEGE STATION, TEXAS EMPLOYEE BENEFITS FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets Current Assets: Equity in Cash and Cash Equivalents Equity in Investments Receivables: Accrued Interest Accounts Prepaid Costs Total Current Assets Liabilities and Fund Equity Current Liabilities: Accounts Payable Claims Payable Accrued Liabilities Total Current Liabilities Fund Equity: Deficit Total Liabilities and Fund Equity -158 - 1993 $ 12,962 47,893 3, 136 159,833 3,800 $ 227,624 $ 7,327 272,981 3 764 284,072 (56,448) $ 227,624 1992 $ 15,245 168,876 5,232 2 2,627 3,800 $ 215,780 $ 1,570 298,821 3,828 304,219 (88,439) $ 215,780 CITY OF COLLEGE STATION, TEXAS EMPLOYEE BENEFITS FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN DEFICITS For the Fiscal Years Ended September 30, 1993 and 1992 Operating Revenues: Premiums Total Operating Revenues Operating Expenses: Claims Administration Fees Premiums Reimbursed Administrative Other Total Operating Expenses Operating Income (Loss) Nonoperating Revenues (Expenses): Interest on Investments Other, Net Total Nonoperating Revenues (Expenses) Net Income Deficit, October 1 Deficit, September 30 -159 - 1993 $1,594,473 1 ,594,473 1'148,010 92,529 304,716 35,639 152412 1,5962306 {1 2833) 34,100 {276) 33,824 31,991 (88,439) $ {562448) 1992 $1,485,601 1 ,485,601 1 ,062,206 92,923 302,084 0 300 1 2457 ,513 282088 14, 174 17 14 ! 191 42,279 ( 130 ,718) $ (882439) Operating Revenues: Premiums Total Operating Revenues Operating Expenses: Claims Administration Fees Premiums Reimbursed Administrative Other Total Operating Expenses Net Operating 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, 1993 Budget Actual $1,448,000 . $1,594,473 1,448,000 1,594,473 974,600 1,148,010 105,000 92,529 257,300 304,716 35,639 35,639 5,000 15,412 1,377,539 1,596,306 70,461 (1 ,833) Nonoperating Revenues (Expenses): Bank Charges 0 (1,098) Interest Earnings 900 34,100 Other, Net 0 822 Total Nonoperating Revenues 900 33,824 Net Income $ 71,361 $ 31,991 See reconciliation to GAAP basis on page 180. -160- Variance Favorable (Unfavorable) $146,473 146,473 (173,410) 12,471 (47,416) 0 (10,412) (218,767) (72,294) (1,098) 33,200 822 32,924 $ (39,370) CITY OF COLLEGE STATION, TEXAS FLEET REPLACEMENT FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets Current Assets: Equity in Cash and Cash Equivalents Equity in Investments Receivables: Accrued Interest Total Current Assets Property and Equipment: Machinery and Equipment Less Accumulated Depreciation Total Property and Equipment Total Assets Liabilities and Fund Equity Current Liabilities: Accounts Payable Total Current Liabilities Total Liabilities Fund Equity: Unreserved Retained Earnings Total Fund Equity Total Liabilities and Fund Equity -161 - 1993 $ 232,449 858,863 39,095 1,130,407 1,340,586 (216,586) 1,124,000 $2,254,407 $ 162,485 162,485 162,485 2,091,922 2,091 ,922 $2,254,407 1992 $ 50,839 563, 163 13,563 627,565 715,994 (57,589) 658,405 $1,285,970 $ 225 225 225 1,285,745 1,285,745 $1,285,970 CITY OF COLLEGE STATION, TEXAS FLEET REPLACEMENT FUND COMPARATIVE STATEMENTS OF REVEN UES, EXPENSES AND CHANGES IN RETAINED EARNINGS For the Fiscal Years Ended September 30, 1993 and 1992 1993 1992 Operating Revenues: Charges for Services $ 8772440 $123042792 Total Operating Revenues 8772440 1,3042792 Operating Expenses: Depreciation 1582997 572589 Total Operating Expenses 1582997 57,589 Operating Income 7182443 122472203 Nonoperating Revenues: Interest on Investments 872734 382542 Total Nonoperating Revenues 872734 38,542 Net Income 806, 177 1,285,745 Retained Earnings, October 1 12285,745 0 Retained Earnings, September 30 $220912922 $122851745 -162 - Operating Revenues: Charges for Goods and Services Total Operating Revenues Operating Expenses: Depreciation Expense Capital Outlay Contingency Total Operating Expenses Net Operating Income (Loss) 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, 1993 Budget Actual $ 877,440 $ 877,440 877,440 877,440 0 158,997 899;650 624,592 5,100 0 904,750 783,589 (27,310) 93,851 36,900 87,734 36,900 87,734 $ 9,590 $ 181,585 See reconciliation to GAAP basis on page 180. -163 - Variance Favorable (Unfavorable) $ 0 0 (158,997) 275,058 5,100 121, 161 121, 161 50,834 50,834 $171,995 CITY OF COLLEGE STATION, TEXAS LANDFILL FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets Current Assets: Equity in Cash and Cash Equivalents Equity in Investments Receivables: Accrued Interest Inventories Total Current Assets Property and Eq_uipment: Machinery and Equipment Less Accumulated Depreciation Total Property and Equipment Total Assets Liabilities and Fund Equity Current Liabilities: Accounts Payable Retainage Payable Accrued Liabilities Total Current Liabilities Noncurrent Liabilities: Accrued Vacation Total Noncurrent Liabilities Total Liabilities Fund Equity: Unreserved Retained Earnings Total Fund Equity Total Liabilities and Fund Equity -164- 1993 $ 97,521 360,323 11,917 0 469,761 36,530 (13 ,889) 22,641 $ 492,402 $ 368,644 17,045 10,865 396,554 11 ! 914 11 , 914 408,468 83,934 83,934 $ 492,402 $ 1992 2,812 31'155 0 532 34,499 34,378 (6,999) 27,379 $ 61,878 $ 6,466 0 8, 161 14,627 9,8i7 9,817 24,444 37,434 37,434 $ 61,878 CITY OF COLLEGE STATION, TEXAS LANDFILL FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS For the Fiscal Years Ended September 30, 1993 and 1992 Operating Revenues: Charges for Services Total Operating Revenues Operating Expenses: Salaries Supplies Maintenance Purchased Professional Services Purchased Property Services Other Purchased Services Reimbursed Administrative Depreciation Other Total Operating Expenses Operating Income Nonoperating Revenues (Expenses): Interest on Investments Interest Expense Total Nonoperating Revenues (Expenses) Net Income Retained Earnings, October 1 Retained Earnings, September 30 -165 - 1993 $1,476,940 1 ,476,940 382,768 105,658 137,023 585,256 20,075 15,763 204,770 6,889 534 1,458,736 181204 28,296 0 28,296 46,500 371434 $ 831934 1992 $ 765,525 765,525 363,585 79,871 69,282 12,858 12,045 11,384 185,364 5,288 0 739,677 251848 0 (11116) (11116) 24,732 12,702 $ 371434 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 Depreciation Contingency Total Operating Expenses Net Operating Income Nonoperating Revenues: Interest Earnings Total Nonoperating Revenues Net Income CITY OF COLLEGE STATION. TEXAS LANDFILL FUND SCHEDULE OF REVENUES AND EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 Budget Actual $1,880,468 $1,476,940 1,880,468 1,476,940 382,870 382,768 109,850 105,658 137,050 137,023 972,273 585,256 26,995 20,075 17,890 15,763 204,770 204,770 2,170 2,151 1,600 6,889 25,000 0 1,880,468 1,460,353 0 16,587 0 28,296 0 28,296 $ 0 $ 44,883 See reconciliation to GAAP basis on page 180. -166 - Variance Favorable (Unfavorable) $(403,528) (403,528) 102 4,192 27 387,017 6,920 2,127 0 19 (5,289) 25,000 420,115 16,587 28,296 28,296 $ 44,883 CITY OF COLLEGE STATION. TEXAS PROPERTY AND CASUAL TY FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets Current Assets: Equity in Cash and Cash Equivalents Equity in Investments Receivables: Accrued Interest Accounts Less Allowance for Uncollectible Accounts Total Current Assets Liabilities and Fund Equity Current Liabilities: Accounts Payable Claims Payable Total Current Liabilities Fund Equity: Unreserved Retained Earnings (Deficit) Total Liabilities and Fund Equity -167- 1993 $ 11,575 42,767 1,463 2,841 (2,425) $ 56,221 $ 4,758 46,885 51,643 4,578 $ 56,221 $ $ 1992 0 0 0 175 (175) 0 $ 46,836 $ 23, 100 69,936 (69,936) 0 CITY OF COLLEGE STATION, TEXAS PROPERTY AND CASUALTY FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS (DEFICITS) For the Fiscal Years Ended September 30, 1993 and 1992 1993 Operating Revenues: Premiums $ 3881740 $ Total Operating Revenues 3881740 Operating Expenses: Claims 58,744 Premiums 257,491 Reimbursed Administrative 47,031 Other 71903 Total Operating Expenses 3711169 Operating Income (Loss) 17,571 Nonoperating Revenues (Expenses): Reimbursed Expenses 0 Interest Expense 0 Interest Earnings 1,463 Other, Net 0 Total Nonoperating Revenues (Expenses) 1 ,463 Net Income (Loss) Before Operating Transfers In 19,034 Operating Transfers In 551480 Net Income (Loss) 74,514 Deficit, October 1 (69,936) Retained Earnings (Deficit), September 30 $ 41578 $ -168 - 1992 3721387 3721387 78,291 257,335 55,476 175 3911277 (181890) 5,635 (6,492) 0 (62700) (71557) (26,447) 0 (26,447) (431489) {692936) Operating Revenues: Premiums Total Operating Revenues Operating Expenses: Claims Premiums Reimbursed Administrative Total Operating Expenses Net Operating Income (Loss) CITY OF COLLEGE STATION. TEXAS PROPERTY AND CASUAL TY FUND SCHEDULE OF REVENUES AND EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 Budget Actual $390,600 $388,740 390,600 388,740 27,500 58,744 270,000 257,491 47,031 47,031 344,531 363,266 46,069 25,474 Nonoperating Revenues (Expenses): Interest Earnings 2,600 0 Interest Expense 0 (4, 189) Total NonoperatingRevenues (Expenses) 2,600 (4, 189) Operating Transfers In 0 55,480 Net Income $ 48,669 $ 76,765 See reconciliation to GAAP basis on page 180. -169 - Variance Favorable (Unfavorable) $ (1,860) (1,860) (31,244) 12,509 0 (18,735) (20,595) (2,600) (4, 189) (6,789) 55,480 $28,096 CITY OF COLLEGE STATION , TEXAS UNEMPLOYMENT FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets Current Assets: Equity in Cash and Cash Equivalents Equity in Investments Receivables: Accrued Interest Total Current Assets Liabilities and Fund Equity Fund Equity: Unreserved Retained Earnings Total Liabilities and Fund Equity -170- 1993 $ 29,864 110,343 5,018 $ 145,225 $ 145,225 $ 145,225 $ 1992 9,376 103,865 2,685 . $ 115,926 $ 115,926 $ 115,926 CITY OF COLLEGE STATION, TEXAS UNEMPLOYMENT FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS For the Fiscal Years Ended September 30, 1993 and 1992 1993 Operating Revenues: Premiums $ 52,425 $ Total Operating Revenues 52,425 Operating Expenses: Claims 24,583 Reimbursed Administrative 7,856 Total 'Operating Expenses 32,439 Operating Income 19,986 Nonoperating Revenues: Interest on Investments 9,313 Total Nonoperating Revenues 9,313 Net Income 29,299 Retained Earnings, October 1 115,926 Retained Earnings, September 30 $ 145,225 $ -171 - 1992 71,675 71,675 15,929 0 15,929 55,746 7' 123 7' 123 62,869 53,057 115,926 Operating Revenues: Premiums Total Operating Revenues Operating Expenses: Claims Reimbursed Administrative Total Operating Expenses Net Operating Income Nonoperating Revenues : Interest Earnings Total Nonoperating Revenues Net Income CITY OF COLLEGE STATION, TEXAS U NEMPLOYME NT FUND SCHEDULE OF REVENUES AND EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 Budget Actual $46,200 $52,425 46,200 52,425 23,300 24,583 7,856 7,856 31, 156 32,439 15,044 19,986 6,300 9,313 6,300 9,313 $21,344 $29,299 See reconciliation to GAAP basis on page 180. -172 - Variance Favorable (Unfavorable) $ 6,225 6,225 (1,283) 0 (1,283) 4,942 3,013 3,013 $ 7,955 CITY OF COLLEGE STATION, TEXAS UTILITY BILLING FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets Current Assets: Equity in Cash and Cash Equivalents Equity in Investments Receivables: Accrued Interest Prepaid Costs Total Current Assets Property and Equipment: General Electric Plant Less Accumulated Depreciation Construction in Progress Total Property and Equipment Total Assets Liabilities and Fund Equity Current Liabilities: Accounts Payable Accrued Liabilities Total Current Liabilities Noncurrent Liabilities: Accrued Vacation Total Noncurrent Liabilities Total Liabilities Fund Equity: Contributed Capital Unreserved Retained Earnings (Deficit) Total Fund Equity Total Liabilities and Fund Equity -173 - 1993 $ 79,984 295,530 13,380 365 389,259 545,266 (452,868) 25,028 117,426 $ 506,685 $ 3,487 6, 155 9,642 35,810 35,810 45,452 381, 137 80,096 461,233 $ 506,685 1992 $ 12' 139 134,474 3,511 0 150, 124 541,161 (350,038) 0 191 , 123 $ 341,247 $ 5,276 4,978 10,254 35,790 35,790 46,044 381'137 (85,934) 295,203 $ 341,247 CITY OF COLLEGE STATION, TEXAS UTILITY BILLING FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS (DEFICITS) For the Fiscal Years Ended September 30, 1993 and 1992 Operating Revenues: Charges for Services Total Operating Revenues Operating Expenses: Salaries and Benefits Sup plies Maintenance Purchased P r of ess ional Services Purchased Property Services Other Purchased Services Reimbursed Administrative Depreciation Total Ope.rating Expenses Operating Income Nonoperating Revenues (Expenses): Interest on Investments Other Total Nonoperating Revenues (Expenses) Net Income Deficit, October 1 Retained Earnings (Deficit), September 30 -174. 1993 $1,423,733 1,423,733 815,608 37,659 10,551 44 21,699 93,635 200,721 107,689 1,287,606 136, 127 31,087 {1 i184) 29,903 166,030 (85,934) $ 80,096 1992 $1,241,148 1,241,148 774,867 27,955 12,969 0 21,893 92 ,72 1 160,248 104,967 1,195,620 45,528 8,657 {7,259) 1 398 46,926 {132,860) $ {85,934) Operating Revenues: Charges for Services Total Operating Revenues Operating Expenses: Salaries and Benefits Supplies Maintenance Purchased Professional Services Purchased Property Services Other Services Reimbursed Administrative Capital Outlay Depreciation Expected Expenditure Savings Contingency Total Operating Expenses Net Operating Income CITY OF COLLEGE STATION. TEXAS UTILITY BILLING FUND SCHEDULE OF REVENUES AND EXPENSES BUDGET AND ACTUAL (BUDGETARY BASIS) FOR THE FISCAL YEAR ENDED SEPTEMBER 30, 1993 Budget Actual $1,423,733 $1,423,733 1,423,733 1,423,733 839,744 815,608 37,799 37,659 11, 130 10,551 70 44 22,800 21,699 102,405 93,635 200,721 200,721 80,577 35,303 100,000 107,689 (34,307) 0 14,828 0 1,375,767 1,322,909 47,966 100,824 Nonoperating Revenues (Expenses): Interest Earnings 0 31,087 Other 1,500 31 Total Nonoperating Revenues (Expenses) 1,500 31, 118 Net Income $ 49,466 $ 131,942 See reconciliation to GAAP basis on page 180. -175- Variance Favorable (Unfavorable) $ 0 0 24, 136 140 579 26 1, 101 8,770 0 45,274 (7,689) (34,307) 14,828 52,858 52,858 31,087 (1,469) 29,618 $ 82,476 CITY OF COLLEGE STATION, TEXAS WORKERS' COMPENSATION FUND COMPARATIVE BALANCE SHEETS September 30, 1993 and 1992 Assets Current Assets: Equity in Cash and Cash Equivalents Equity in Investments Receivables: Accrued Interest Total Current Assets Liabilities and Fund Equity Current Liabilities: Accounts Payable Claims Payable Total Current Liabilities Fund Equity: Unreserved Retained Earnings Total Liabilities and Fund Equity -176 - 1993 $ 128,760 475,745 21,429 $ 625,934 $ 15,685 154,044 169,729 456,205 $ 625,934 1992 $ 52, 157 577,758 14,596 $ 644 ,511 $ 64,876 156, 177 221,053 423,458 $ 644,511 CITY OF COLLEGE STATION, TEXAS WORKERS' COMPENSATION FUND COMPARATIVE STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS For the Fiscal Years Ended September 30, 1993 and 1992 1993 Operating Revenues: Premiums $ 4471996 $ Total Operating Revenues 4471996 ·*; Operating Expenses: Administration Fees 15,864 Claims 298,982 Premiums 30,742 Reimbursed Administrative 531052 Total Operating Expenses 3981640 Operating Income 491356 Nonoperating Revenues: Interest on Investments 381871 Total Nonoperating Revenues 38,871 Net Income Before Operating Transfers Out 881227 Operating Transfers Out (55,480) Net Income 32,747 Retained Earnings, October 1 423,458 Retained Earnings, September 30 $ 4561205 $ - 177 - 1992 4391181 4391181 25,800 151,386 28,461 0 205,647 2331534 391542 391542 2731076 0 273,076 1501382 4231458 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 Operating Transfers Out 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, 1993 Budget Actual $ 423,711 $447,996 423,711 447,996 15,054 15,864 280,195 298,982 26,990 30,742 53,052 53,052 375,291 398,640 48,420 49,356 14,300 38,871 14,300 38,871 0 (55,480) $ 62,720 $ 32,747 See reconciliation to GAAP basis on page 180. -178 - Variance Favorable (Unfavorable) $ 24,285 24,285 (810) (18, 787) (3,752) 0 (23,349) 936 24,571 24,571 (55,480) $ (29,973) -179 - 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 SEPTEMB.ER 30, 1993 Total Revenues per Budget-Actual Less Total Expenses per Budget-Actual Net Income (Loss), Budgetary Basis Add-Expenses Related to Balance Sheet: Capital Outlay Add (Deduct) -Unbudgeted Revenue/Expense Adjustments: Bad Debt Expense Inventory Adjustment Loss on Sale of Equipment Net Income (Loss), GAAP Basis Employee Benefits $1,629,395 1,597,404 31,991 0 0 0 0 $ 31,991 -180 - Fleet Replacement $ 965,174 783,589 181,585 624,592 0 0 0 $ 806,177 Landfill $1,505,236 1,460,353 44,883 2,151 0 (534) 0 $ 46,500 Property and Casualty $ 444,220 367,455 76,765 0 (2,251) 0 0 $ 74,514 Unemployment $61,738 32,439 29,299 0 0 0 0 $29,299 Utility Billing $1,454,851 1,322,909 131,942 35,303 0 0 (1,215) $ 166,030 Workers' Compensation $ 486,867 454, 120 32,747 0 0 0 0 $ 32,747 - 181 - -182 - GENERAL FIXED ASSETS ACCOUNT GROUP To account for fixed assets not used in proprietary fund operations. -183 - -184 - CITY OF COLLEGE STATION, TEXAS GENERAL FIXED ASSETS ACCOUNT GROUP COMPARATIVE SCHEDULE OF GENERAL FIXED ASSETS BY SOURCE September 30, 1993 and 1992 1993 1992 General Fixed Assets: Buildings $ 13,218,308 $ 13,031,574 Improvements 14,547,211 14,270,758 Machinery and Equipment 10,358,898 10' 193' 761 Parks System 8,702,166 6,275,661 Construction in Progress 1 ,406,569 1'861 ,039 Land 7,437,029 6 ,899 ,368 Total General Fixed Assets $ 5516701181 $ 5215321161 Investment in General Fixed Assets From: Capital Pro j ects Funds $ 38,789,922 $ 35,640,258 General Fund Revenues 6,465,658 6,609,919 Special Revenue Funds 3,411,716 3,266,099 Contributions/Donations 36,650 36,650 Acquisitions Prior to July 1 ' 1979-- Source Undetermined 619661235 619791235 Total Investment in General Fixed Assets $ 5516701181 $ 5215321 161 -185- CITY OF COLLEGE STATION, TEXAS GENERAL FIXED ASSETS ACCOUNT GROUP SCHEDULE OF GENERAL FIXED ASSETS BY SOURCE -BY FUNCTION AND ACTIVITY SEPTEMBER 30, 1993 Building and Building Total Land Improvements General Fund: General Government $ 507,204 $ 0 $ 59,444 Fiscal and Human Resources 392,922 0 10,654 Police 498,610 0 1,972 Fire 927,498 0 3,868 Development Services 345,911 0 9,374 Public Services 1, 150,292 1500 28,168 Parks 1,095, 193 0 216,749 Management Services 116,506 0 9,223 College Station Business Park 1,900 1,900 0 Other 1,429,621 1,429,621 0 Total General Fund 6,465,657 1,433,021 339,452 Special Revenue Funds: Parks Escrow 175,5 56 34,906 0 Federal Grants 2,081,222 13,082 279,359 Other 1,099,220 150,009 896,029 Total Special Revenue Funds 3,355,998 197,997 1, 175,388 Capital Projects Funds: Certificates of Obligation Funds 1,732,352 637, 168 400,000 Capital Equipment 2,908,726 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 1978 II 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 9,897,571 1,734,849 927,666 1984 Bond Funds 10,042,055 799, 116 4,510,058 1989 Bond Funds 2,178,616 91, 112 956,780 1991 Bond Funds 593,698 0 0 Total Capital Projects Funds 37,439,072 4,349,406 9,751,611 Contributions/Donations 36,650 0 0 Acquisitions Prior to July 1, 1979 -Source Undetermined 6,966,235 1,456,605 1,951,857 Total General Fixed Assets Allocated to Functions 54,263,612 7,437,029 13,218,308 Construction in Progress 1,406,569 0 6,909 Total General Fixed Assets $55,670, 181 $7,437,029 $13,225,217 -186 - Machinery, Tools and Parks Equipment System Improvements $ 447,760 $ 0 $ 0 382,268 0 0 496,638 0 0 923,630 0 0 336,173 0 364 1, 120,624 0 0 601, 177 277,267 0 107,283 0 0 0 0 0 0 0 4,415,553 277,267 364 1,300 139,350 0 11,039 154,930 1,622,812 32,909 0 20,273 45,248 294,280 1,643,085 695,184 0 0 2,908,726 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 4,633,404 1,907,273 703,751 584,586 3,444,544 14,561 5,575 1, 110,588 0 402,895 190,803 5,315,941 7,318,410 10,703,704 0 0 36,650 582,156 812,209 2,163,408 10,358,898 8,702,166 14,547,211 51 183, 199 1,216,410 $10,358, 949 $8,885,365 $15, 763, 621 -187 - 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, 1993 General Fixed General Fixed Assets Assets 9/30/92 Additions Retirements Transfers 9/30/93 Function and Activity General Fund: General Government $ 497,918 $ 13,355 $ (4,069) $ 0 $ 507,204 Fiscal and Human Resources 374,574 41,295 (22,947) 0 392,922 Police 550,509 49,200 (101,099) 0 498,610 Fire 1,035,037 66,974 (174,513) 0 927 ,498 Development Services 305,459 47,863 (7,410) 0 345,912 Public Services 1,364, 161 4,211 (218,080) 0 1,150,292 Parks 1,023,605 80,628 (9,040) 0 1,095, 193 Management Services 29 ,035 107,505 (20,035) 0 116,505 College Station Business Park 0 1,900 0 0 1,900 Other 1,429,621 0 0 0 1,429,621 Total General Fund 6,609,919 412,931 (557, 193) 0 6,465,657 Special Revenue Funds: Parks Escrow 175,556 0 0 0 1 75,556 Federal Grants 2,023,722 0 0 57,500 2,081,222 Other 1,066,821 32,399 0 0 1,099,220 Total Special Revenue Funds 3,266,099 32,399 0 57,500 3,355,998 Capital Projects Funds: Certificates of Obligation 1,732,352 0 0 0 1,732,352 Capital Equipment 2,591,246 317,480 0 0 2,908,726 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,9 04,043 1982 Bond Funds 3,902,862 0 0 0 3,902,862 198211 Bond Funds 7,224,694 2,672,87 8 0 0 9,897,572 1984 Bond Funds 9,869,706 172,349 0 0 10,042,055 1989 BondFunds 2,000,714 177,901 0 0 2, 178,615 1991 Bond Funds 274,453 319,245 0 0 593,698 Total Capital Projects Funds 33,779,219 3,659,853 0 0 37,439,072 Contributions/Donations 36,650 0 0 0 36,650 Acquisitions Prior to July 1, 1979 -Source Undetermined 6,979,235 0 (13,000) 0 6,966,235 Construction in Progress 1,861,039 3,240,299 (3, 694, 769) 0 1,406,569 Total General Fixed Assets $52,532, 161 $7,345,482 $(4,264,962) $ 57,500 $55,6 70, 181 -188 - STATISTICAL SECTION - 189 - 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 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 315,272 3,066,168 114,971 459,872 1987 222,826 299,973 3,016,640 102,739 442,408 1988 (3) 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,940 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 1993 1,627,228 407,168 7,995,877 445,58 5 893,649 (1) Revenues presented include the General and Debt Service Funds. (2) Revenue sharing transfers made fiscal 1980 through fiscal 1987. (3) 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 -190 - Charges Transfer Other Debt Service For From Enterprise Financing Property Services Funds All Other Sources Tax Total $ 269,094 $ 2,774,940 $ 354,924 $ 337,370 (2) $ 2,678,842 $ 10,027,292 286,010 3,272,759 453,871 625,825 (2) 3,514,761 12,197,042 335,371 4,066,951 407,287 706,772 (2) 3,826,083 13,507,228 298,463 4,302,654 414,908 657,086 (2) 3,992,810 13,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 904,004 4,266,5 04 800,690 68,213 3,351,369 20,760,287 -191 - (1) Fiscal Year 1984 1985 1986 1987 1988 (2) 1989 1990 1991 1992 1993 CITY OF COLLEGE STATION, TEXAS GENERAL GOVERNMENTAL EXPENDITURES AND OTHER USES BY FUNCTION (1) LAST TEN FISCAL YEARS General Government Police Fire $ 3,200,862 $ 2,089,176 $ 1,842,618 3,559,610 2,445,386 2,008,648 3,948,780 2,711 ,271 2,224,796 4,214,064 3,024,395 2,324,273 4,968,662 3,883,961 2,943,886 4,335,002 3,188,081 2,588,909 4,617,138 3,363,665 2,780,466 4,723,549 3,491,656 2,833,455 4,934,782 3,862,849 3,034,046 5,289,911 4,054,244 3,331,309 Expenditures presented include the General and Debt Service Funds. Public Services $ 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 2,266,145 (2) Fiscal year 1988 represents the transition from a June 30 year-end to September 30. Fiscal Year 1988 shows the 15 months 7/1/87 - 9/30/88. (3) Utility Billing established as internal service fund in fiscal year 1989, reducing reimbursed administrative expenditures in General Fund. Source: City of College Station -192- Parks & Recreation $ 1,159,758 1,405,236 1,572,606 1,583,837 2,401,189 2,090,649 2,428,196 2,269,977 2,576,106 2,838,541 Other Library Capital Reimbursed All Debt Financing Services Outlay Administrative Other Service Uses Total $ 0 $ 762,368 $ (2,391,871) $ 0 $ 3,493,647 $ 0 $ 11,122,965 0 651,878 (2, 779, 161) 0 3,499,615 0 11,933,349 0 606,156 (2,832, 153) 0 3,807,583 0 13,279,662 0 399,930 (3,353,671) 0 3,705,802 0 13,089,325 0 1,068,070 (3,818,632) 0 3,813,384 0 16,822,396 0 636,539 (2, 393, 775) (3) 0 3,399,826 0 15,237,461 0 345,317 (2,276,465) (3) 0 3,422,703 200,000 16,384,008 0 602,976 (2,415,356) (3) 0 3,671,439 720,546 17,838,939 0 329,269 (2,591,911) (3) 572,578 4,843,605 0 19,669,730 283,478 412,314 (2,843,580) (3) 398,100 3,508,905 0 19,539,367 -193 - Current Fiscal Year 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 CITY OF COLLEGE STATION, TEXAS PROPERTY TAX LEVIES AND COLLECTIONS LAST TEN FISCAL YEARS Percent Total Tax Of Levy Tax Levy Collections Collected $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 4,902,798 4,816,407 98.24 Source: City of College Station - 194- Delinquent Tax Collections $76,450 79,880 105,878 192,003 315,203 202,588 98,787 136,233 77,220 107,407 Total Collections Outstanding Delinquent Total As Percent Of Outstanding Taxe s As A Percent Tax Collections Current Levy Delinquent Taxes Of Current Levy $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 582,614 13.67 4,260,511 101.89 489,709 11.71 4,324,823 101.47 420,113 9.86 4,475,223 100.05 394,727 8.82 4,444,923 100.36 327,854 7.40 4,451,127 98.77 363,933 8.08 4,923,814 100.43 324,685 6.62 -195- - 196 - CITY OF COLLEGE STATION, TEXAS ASSESSED VALUE OF TAXABLE PROPERTIES (1) LAST TEN FISCAL YEARS F iscal Year Real Property Personal Property 1984 $ 775,606, 760 $ 95,188,096 1985 879,001,892 116,065,055 1986 993,907 ,903 144,581,203 1987 1,014,067,239 143,572,456 1988 993,765,995 145,214,623 1989 1,002,938,332 157,209,511 1990 995,686,332 161 ,343, 707 1991 983 ,973,909 156,164,603 1992 1,013,892,433 150,886,397 1993 1, 184, 7 48,445 168,378,927 (1) Assessed Value is 100% of the estimated actual value. Source: Brazos County Appraisal District State Property Tax Board Report of Property Value -1 97 - Exemptions $ 29,592,994 35,420,320 36,875,269 36,629,372 38,631,099 38,535,922 38,794,667 38,658,990 38,166,827 164,570,381 Total $ 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,52 2 1, 126,612,003 1, 188,556,991 Fiscal CITY OF COLLEGE STATION, TEXAS PROPERTY TAX RATES, RATIOS AND LEVIES ALL DIRECT AND OVERLAPPING GOVERNMENTS LAST TEN FISCAL YEARS Tax Rates (Per $100 of Assessed Value) Year(1) City School County Total(3) 1984 $.3100 $.9700 $.3100 1985 .3600 .9500 .3296 1986 .3800 .9780 .3253 1987 .3800 1.0790 .4170 1988 .3800 1.0790 .4170 1989 .3800 1.2100 .3427 1990 .4000 1.3000 .3689 1991 .4000 1.4400 .4105 1992 .4000 1.6800 .4399 1993 .4125 1.6800 .4399 (1) Tax rates are established by each taxing jurisdiction on an annual basis for revenues to be collected in the following fiscal year. $1.5900 1.6396 1.6833 1.8760 1.8760 1.9327 2.0689 2.2505 2.5199 2.5324 (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 -198- Tax Ratios OriginalTax Levies City School County City School County 100 % 100 % 100 % $ 2,609,180 $ 8,706,598 $ 9,086,144 100 100 100 3,446,634 9,676,00 1 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 100 100 100 4,902,806 21,608,259 12,789,846 -199 - F iscal Year 1984 1985 1986 1987 1 988 1989 1990 1991 1992 1993 CITY OF COLLEGE STATION, TEXAS PAVING ASSESSMENT COLLECTIONS LAST TEN FISCAL YEARS Percentage of Current Assessments Assessments Assessment Collected Collected $ 49,373 $ 65 5.00% 0 45,746 32.24 0 16,019 16.66 0 13,433 16.76 202,546 36,913 13.71 0 21,703 93.40 40,926 14,251 5.67 0 31,016 13.07 0 4,682 2.27 0 58,358 28.95 Source: City of College Station Finance Department - 200- Total Outstanding Assessments $141,899 96,153 80,134 66,701 232,334 210,631 237,306 206,290 201,608 143,250 CITY OF COLLEGE STATION, TEXAS COMPUTATION OF LEGAL DEBT MARGIN SEPTEMBER 30, 1993 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. -201 - CITY OF COLLEGE STATION, TEXAS RATIO OF NET GENERAL BONDED DEBT TO ASSESSED VALUE AND NET BONDED DEBT PER CAPITA LAST TEN FISCAL YEARS Fiscal Estimated Assessed Gross Year Population Value Bonded Debt 1984 49,022 (1) $ 841,201,862 1985 50,853 (1) 959,646,627 1986 50,991 (1) 1, 101,613,837 1987 51,222 (1) 1,121,010,323 1988 51,463 (1) 1, 100,349,519 1989 51,707 (1) 1,121,611,921 1990 51,977 (1) 1, 118,235,372 1991 52,456 (2) 1, 101,479,522 1992 53,686 (1) 1, 126,612,003 1993 54,449 (1) 1, 188,556,991 (1) Source: Metropolitan Planning Organization & City of College Station Planning Department (2) Source: U.S. Government Preliminary Census $ 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 19,014,385 (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. -202- (3) Less Ratio of Debt Service Net Net Bonded Debt Net Bonded Cash Funds Bonded Debt To Assessed Valuation Debt Per Capita $ 1,478,640 $ 26,001,360 3.09 $530 1,750,986 19,603,014 2.04 385 2,028,845 17,878,655 1.62 351 2,560,656 15,850,344 1.41 309 1,890,972 19,102,916 1.74 371 1,880,417 17,362,540 1.55 336 1,528,503 19,136,087 1.71 368 1,146,493 17,430,862 1.58 332 856,151 20,247,439 1.80 377 870,035 18,144,350 1.53 333 -203- CITY OF COLLEGE STATION, TEXAS SCHEDULE OF DIRECT AND ESTIMATED OVERLAPPING DEBT (1) SEPTEMBER 30, 1993 Net Debt City's Share Taxing Body Amount As Of Percent Amount ESTIMATED OVER- LAPPING DEBT College Station l.S.D. (2) $33,479,902 8/31/93 83.48 % $27,949,022 Brazos County (3) 8,465,000 8/31/93 39.52 3,345,368 Bryan l.S.D. (4) 27,690,022 8/31/93 5.17 1,431,574 32,725,964 NET DIRECT DEBT City of College Station 18,144,350 9/30/93 100.00 18,144,350 NET DIRECT AND ESTIMATED OVERLAPPING DEBT $50,870,314 *Population 54,449 (1) Source: City of College Station Finance Department (2) Source: College Station Independent School District (3) Source: Brazos County (4) Source: Bryan Independent School District -204- Per* Capita $513 62 26 602 333 $935 Fis cal Year 1 984 1985 1986 1987 1 988 1989 1990 1991 1992 1993 (1) (2) CITY OF COLLEGE STATION, TEXAS RATIO OF ANNUAL DEBT SERVICE EXPENDITURES FOR GENERAL OBLIGATION DEBT TO TOTAL GENERAL GOVERNMENTAL EXPENDITURES ANO OTHER USES LAST TEN FISCAL YEARS Total General Interest, Governmental Fiscal and Total Expenditures Principal Other Charges Debt Service and Other Uses Ratio $ 1,547,007 $ 1,944,710 $ 3,491,717 (1) $ 11,122,965 31.39 % 1,361,800 2,137,815 3,499,615 11,933,349 29.33 1,630,982 2,176,601 3,807,583 13,279,662 28.67 1,685,439 2,020,363 3,705,802 13,089,325 2 8.31 1,795,053 2,108,331 3,903,384 16,822,396 (2) 23.20 (2) 1,852,938 1,546,888 3,399,826 15,237,461 22.31 1,913,720 1,508,983 3,422,703 16,384,008 20.89 2,206,493 1,464,946 3,671,439 17,838,939 20.58 3,332,876 1,510,729 4,843,605 19,669,730 24.62 2,111,906 1,396,999 3,508,905 19,539,367 17.96 Includes general o bligation debt that is serviced by the Enterprise Funds. As of July 1, 1984, such debt was reflected as indebtedness of the Utility Fund. Fiscal year 1988 represents the transition from a June 30 year-end to September 30. Fiscal year 1988 shows the 15 months 7 /1 /87 -9/30/88. Source: City of College Station -205 - Fiscal Year 1984 1985 1986 1987 1988 (1) 1989 1990 1991 1992 1993 (1) Operating Revenues $ 26,2n,830 31,867,897 32,480,725 32,760,614 48,138,363 37,584,6 13 37,108,418 35,558,9 16 37,524,486 39,637,874 CITY OF COLLEGE STATION, TEXAS UTILITY FUNDS SCHEDULE OF REVENUE BOND COVERAGE LAST TEN FISCAL YEARS Operating Expenses (Excludi ng Net Average Annual Depreciation) Revenues Total Coverage $ 16,265,010 $ 10,012,820 $ 4,066,427 2 .46 % 21,673,543 10,194,354 3,582,202 2.85 23,958,157 8,522,568 3,476,179 2.45 22,7n,769 9,982,845 3,357,119 2.97 33,676,51 1 14,461,852 3,134,547 4.61 26,878,049 10,706,564 2,999,229 3.57 26,478,070 10,630,348 2,863,939 3.71 27,042,224 8,516,692 2,337,186 3.64 27,463,001 10,061,485 2,186,415 4.60 28,912,833 10,725,041 2,218,247 4.83 Fiscal year 19 88 represents the transition from a June 30 year-end to September 30. Fiscal year 1 98 8 shows the 15 months 7/1/87 -9/30/88. Source: City of College Station -206- Maximum Annual Total Coverage $ 5,688,176 1.76 % 5,172 ,546 1.97 5,143,007 1.66 5,096,158 1.96 4 ,758,37 0 3.04 4,487,414 2 .39 4,2 45,295 2.50 4,447,976 1.91 4,144,820 2.43 4,936,738 2.17 (1) Fiscal Year 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 (1) (4) CITY OF COLLEGE STATION, TEXAS TOTAL BANK DEPOSITS LAST TEN FISCAL YEARS Amount $ 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 717,485,000 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 (now NationsBanJ<). Call reports are not issued by branch banks. (3) Due to continued consolidation in the banking industry, total includes Bryan -College Station area banks. (4) During 1993, First City, Texas was purchased by Victoria Bank and Trust. Since call reports are not issued by branch banks, the corporate office was contacted and the amount of deposits made into the Bryan branch bank was obtained. Source: Call reports for all Bryan/College Station area banks. -207- (2) (3) (3) (3) (3) (3) Year 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 Source: Residential Construction Number of Permits CITY OF COLLEGE STATION, TEXAS Value CONSTRUCTION PERM ITS LAST TEN CALENDAR YEARS Commercial Construction Number of Permits Value 134 $ 23,500.892 467 $ 45,546,079 194 9,587,839 323 15,779,281 209 8,104,272 134 16,133,255 250 12,655,651 225 15,590,672 243 20,279,472 172 3,468,622 229 15,528,105 203 22,085,987 213 12,539,486 56 3,870,491 370 18,933,748 164 17,319,566 475 31,503,185 153 11,648,580 381 38,141,976 178 27,288,295 City of College Station Building Department -208- Total Number of Permits Value 601 $ 69,046,971 517 25,367,120 343 24,237,527 475 28,246,323 415 23,748,094 432 37,614,092 269 16,409,977 534 36,253,314 628 43,151,765 559 65,430,271 Taxpayer C.B.L. Management General Telephone Galen Hospitals of Texas, Inc. l.D.I. Investments, Inc. Walmart/Sam's Properties Resolution Trust Corporation Lodgec Properties Lane College Station, Ltd. Westinghouse Electric Corp. Allen, Lawrence and Elizabeth Total CITY OF COLLEGE STATION, TEXAS PRINCIPAL TAXPAYERS SEPTEMBER 30, 1993 Type of Business Retail Mall Utility Hospital Apartments Retail Commercial/ Apartments Commercial/ Apartments Hotel Manufactur ing Housing 1993 Assessed Valuation $ 44,356,552 27,663,000 20,584,699 19,774,580 15,547,955 13,583,104 13,288,465 9,656,000 9,162,735 7,449,500 $181,066,590 Source: Brazos County Appraisal District - 209 - Percent of Total Assessed Valuation 3.73% 2.33 1.73 1.66 1.31 1.14 1.12 0.81 0.77 0.63 15.23 % Utility Customer City of College Station Westinghouse Lane C/S Ltd. Partnership Randall's Food Markets CBL & Associates Agency Management Services Walmart Stores, Inc. U.S. Department of Agriculture Brazos Valley Medical Center Albertson's TOTAL CITY OF COLLEGE STATION, TEXAS PRINCIPAL UTILITY CUSTOMERS SEPTEMBER 30, 1993 Type of Business Municipality Manufacturing Hotel Retail Grocery Retail Mall Insurance Service Retail Government Health Care Retail Grocery Total FY 1993 Percent of KW KW Consumption Consumed 8,539,200 1.95% 7,722,000 1.77 5,694,300 1.30 5,264,400 1.20 4,623,600 1.06 4,577,400 1.05 4,133,040 0.95 4,078,000 0.93 4,044,800 0.93 3,479,040 0.80 52,155,780 11.94% Total KW consumption for the period October 1, 1992, to September 30, 1993, was 436,679,604. SOURCE: City of College Station Utility Billing Department -210 - CITY OF COLLEGE STATION, TEXAS MISCELLANEOUS STATISTICAL AND DEMOGRAPHIC DATA SEPTEMBER 30, 1993 Date incorporated Date first charter adopted Date present charter amended Form of government Fire Protection: Area in square miles Year Miles of streets 1938 1948 1958 1968 1978 1982 1986 1988 1992 Miles of sidewalks Miles of sanitary sewer Number of stations Number of full-time employees Police Protection: Number of employees (sworn) Number of employees (civilian) Number of patrol units Paved Unpaved One jail facility with a capacity of 20 Recreation: Number of playgrounds Number of basketball courts Number of swimming pools Number of soccer fields Number of softball/baseball fields Number of tennis courts Number of picnic shelters Number of gyms Number of volleyball courts Number of fitness courts Number of nature trails Number of open play areas Number of picnic pavillions (Continued) -211 - Square Miles 1.5 4.2 7.3 17.3 22.6 23.8 26.7 27.7 28.1 October, 1938 October, 1938 May, 1992 Council-Manager 201.0 Miles 2.5 Miles 30.0 Miles 210.0 Miles 2 76 74 36 15 21 17 3 17 14 12 10 1 5 4 12 23 7 CITY OF COLLEGE STATION, TEXAS MISCELLANEOUS STATISTICAL AND DEMOGRAPHIC DATA SEPTEMBER 30, 1993 (Continued) Parks: Facili!Y Acres Facili!Y Acres Anderson Park 8.9 Longmire Park 4.2 Bee Creek Park 43.5 Merry Oaks 4.6 Brison Park 9.2 Oaks Park 7.5 Brother's Pond 16.1 Parkway 1.9 College Station Raintree 13.0 Central Park 47.2 Richard Carter Park 7.4 Conference Center 7.8 Sandstone 15.0 Cy Miller Park 2.5 Southwood Complex 44.7 Eastgate 1.0 Thomas Park 16.1 Emerald Forest Park 4.5 University Park Site 10.2 Fairview 1.8 Wayne Smith Park 2.0 Gabbard Park 10.7 Westchester 10.0 Georgia K. Fitch 11.3 Windwood 1.0 Hensel Park -TAMU 29.7 Wolfpen Creek Park 19.5 Lemon Tree Park 15.4 Woodcreek Park 6.6 Lick Creek Park 515.5 Woodway Park Site 4.2 Lincoln Center 8.0 Lion's Park 1.5 TOTAL ACREAGE 902.5 Utility Funds: Electric Users (Units Served) Water Users (Units Served) 22,505 16,149 KWH/Mo. Average Electrical Consumption: Average Water Consumption: Number of Employees: Electric Weier Sewer Water Capacity: Number of Wells Combined Capacity of Wells Number of Ground Storage Tanks, 3 Number of Elevated Storage Tanks, 2 Miles of Water Lines Electric Capacity: Maximum Capacity Number of Switching Stations Number of Substations Miles of Distribution Lines (Continued) -212- 36,502,446 191,773 MGW/Mo. 46 32 34 4 15,600,000 GALJday Total capacity 1 o, 000,000 GALS Total capacity 3, 000, 000 GALS 300Miles 170 megawatts 1 3 210 CITY OF COLLEGE STATION, TEXAS MISCELLANEOUS STATISTICAL ANO DEMOGRAPHIC DATA SEPTEMBER 30, 1993 (Continued) Solid Waste Collection Fund: Education: Elections: Population: SOURCE: Number of users (units served) 19,275 Methodology Curbside pickup using automated containers. Attendance centers Number of classrooms Number of teachers Number of students Number of registered voters: Last general election Last municipal election Number of votes cast in: Last general election Last municipal election Percentage of registered voters voting in: Census Count Last general election Last municipal election City of College Station 1990 1980 1970 1960 1950 (Continued) - 213 - 7 350 360 6,140 29,465 30,429 22,982 5,436 78.00% 17.86% 52,456 37,296 17,676 11,396 7,925 CITY OF COLLEGE STATION, TEXAS · MISCELLANEOUS STATISTICAL AND DEMOGRAPHIC DATA SEPTEMBER 30, 1993 (Continued) PROJECTED AND ACTUAL TEXAS A&M UNIVERSITY ENROLLMENT BY FALL SEMESTERS UNIVERSITY YEAR PROJECTIONS 1987 39,079 1988 39,163 1989 40,492 1990 41, 131 1991 40 ,997 1992 41,092 1993 42,524 1994 41,000 Projected 1995 41,000 Projected 2000 41,000 Projected SOURCE: TAMU Planning & Institutional Analysis, October, 1993. PRIMARY LABOR FORCE FOR BRAZOS COUNTY TOTAL YEAR LABOR FORCE PERCENT UNEMPLOYED 1984 57,516 3.7 1985 56,504 4 .8 1986 57,472 6 .4 1987 59,595 6.� 1988 57,637 4.6 1989 61,300 4.4 1990 62,000 3.5 1991 60,988 3.6 1992 65,609 3.6 1993 66,300 3.5 SOURCE: College of Business Administ ration Report on the Economic Assessment and Comparative Advantages of Bryan/College Station, Texas A&M University, 1984 for years 1980 -1984. Texas Employment Commission (Bryan, Texas) for years 1985 -1993. -214- INGRAM, WALLIS & COMPANY A PROFESSIONAL CORPORATION Certified Public Accountants 2100 Villa Maria, Suite 100 BRYAN, TEXAS 77802 TELEPHONE James D. Ingram, III Thomas A. Wallis ( 409) 776-2600 TELECOPIER Agnes L. Bennett Judith W. Childs James D. Ingram, IV Richard L. Webb Sharon L. Pechal Wendi M. Stratta Pu-Yu (Peggy) Wang Joan M. Voneiff Diane E. Kruse (409) 774-7759 Mayor Larry Ringer, Members of City Council and City Manager of the City of College Station, Texas We have audited the general purpose financial statements of the City of College Station, Texas ("City"), for the year ended September 30, 1993 and have issued our report thereon dated January 29, 1994. 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 1993 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. 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, 1993, 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 1993 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 adjustment that, either individually or in the aggregate, would have a significant effect on the City's financial reporting process, in our judgment. 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 judgments about accounting estimates, the scope of our audit, disclosures to be included in the financial statements or the wording of our report on the 1993 general purpose financial statements. CONSULTATION WITH MANAGEMENT Management informed us that there were no consultations with other independent public accountants regarding accounting or auditing matters during 1993. MAJOR ISSUES DISCUSSED WITH MANAGEMENT PRIOR TO RETENTION We discussed no major accounting or auditing issues with management in connection with our retention as the City's auditors in 1993. 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. Bryan, Texas January 29, 1994 INGRAM, WALLIS & COMPANY A PROFESSIONAL CORPORA T!ON Certified Public Accountants 2100 Villa Maria, Suite 100 BRYAN, TEXAS 77802 James D. Ingram, III Thomas A. Wallis TELEPHONE (409) 776-2600 TELECOPIER Agnes L. Bennett Judith W. Childs James D. Ingram, IV Richard L. Webb Sharon L. Pechal Wendi M. Stratta Pu-Yu (Peggy) Wang Joan M. Voneiff Diane E. Kruse (409) 774-7759 Mayor Larry Ringer, Members of City Council and City Manager of the City of College Station, Texas In planning and performing our audit of the general-purpose financial statements of the City of College Station ("City") for the year ended September 30, 1993, we considered its internal control structure in order to determine our auditing procedures for the purpose of expressing our opinion on the 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 City's ability to record, process, summarize and report financial data consistent with the assertions of management in the general-purpose financial statements. In testing cash receipts, we noted that some City departments are holding deposits for more than one day before forwarding them to the accounting department. In some departments, large dollar amounts are being accumulated in facilities which do not provide adequate safeguards over assets. All departments should be made aware of the City's cash receipts policy which requires all receipts to be deposited on a daily basis. In testing cash receipts at municipal court, it was noted that several deposits did not agree to supporting documentation. Computer system problems have resulted in the need for manual adjustments to be made to receipt records. No support is maintained to verify manual adjustments and, in most cases, manual adjustments are not shown on receipt records. We recommend that manual adjustments be adequately documented. During our testing of controls over cash disbursements, we noted that the utility billing department prepares and mails utility deposit refund checks independent of the accounting department. No segregation of duties exist in the utility billing department for handling these checks. To provide for segregation of duties, all checks should be written through the accounting department and subject to the cash disbursements procedures in place. 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 the 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. As noted in the prior year, 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. While reviewing expenditures, we noted that some non-qualifying expenditures were incorrectly recorded and included in the request for funds from the Department of Housing and Urban Development {HUD). We recommend that procedures be implemented to ensure a monthly review of expenditures to ensure that only qualifying expenditures are submitted to HUD. 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 statements being audited may occur and not be detected within a timely period by employees in the normal course of performing their assigned functions. 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 also considered to be material weaknesses as defined above. However, none of the reportable conditions described above is believed to be a material weakness. This report is intended solely for the information and use of the City Council and management 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. Bryan, Texas January 29, 1994