The URL can be used to link to this page

Home My WebLink AboutFY 1986 -1987 -- Comprehensive Annual Financial ReportCity of College Station, Texas FINANCE DEPARTMENT Comprehensive Annual Financial Report For the Fiscal Year Ended June 30, 1987 C I T Y O F C 0 L L E G E S T A T I 0 N, T E X A S COMPREHENSIVE ANNUAL FINANCIAL REPORT YEAR ENDED JUNE 30, 1987 PREPARED BY THE CITY OF COLLEGE STATION FINANCE DEPARTMENT WILLIAM P. HARRISON, DIRECTOR OF FINANCE GLENN SCHROEDER) DEPUTY DIRECTOR OF FINANCE KATHLEEN HUBBARD, ACCOUNTING SUPERVISOR CITY OF COLLEGE STATION, TEXAS COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE YEAR ENDED JUNE 30, 1987 TABLE OF CONTENTS INTRODUCTORY SECTION: PAGE Organizational Chart 2 Principal City Officials 3 Letter of Transmittal 5 GFOA Certificate of Achievement for Excellence in Financial Reporting 15 FINANCIAL SECTION: Auditors' Opinion 19 General Purpose Financial Statements for the Year Ended June 30, 1987: Combined Balance Sheet - All Fund Types and Account Groups 21 Combined Statement of Revenues, Expenditures and Changes in Fund Balances - All Governmental Fund Types and Expendable Trust Funds 25 Combined Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual (Non-GAAP Basis) - General and Certain Special Revenue Funds 27 Combined Statement of Revenues, Expenses and Changes in Fund Equity - All Proprietary Fund Types and Pension Trust Fund 29 Combined Statement of Changes in Financial Position - All Proprietary Fund Types and Pension Trust Fund 31 Notes to General Purpose Financial Statements 34 SUPPLEMENTAL FINANCIAL INFORMATION - INDIVIDUAL AND COMBINING FINANCIAL STATEMENTS OF FUND TYPES AND ACCOUNT GROUPS FOR THE YEAR ENDED JUNE 36, 1987: General Fund Schedule of Revenues and Other Financing Sources - Budget and Actual (Non-GAAP Basis) 57 Schedule of Expenditures Compared with Budget (Non-GAAP Basis) 59 - i - CITY OF COLLEGE STATION, TEXAS COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE YEAR ENDED JUNE 30, 1987 TABLE OF CONTENTS (CONTINUED) PAGE SUPPLEMENTAL FINANCIAL INFORMATION (Continued): Special Revenue Funds Combining Balance Sheet 71 Combining Statement of Revenues, Expenditures and Changes in Fund balances 72 Community Development Fund Statement of Revenues, Expenditures and Changes in Fund Balance - Budget (GAAP Basis) and Actual 73 Revenue Sharing Fund Statement of Revenues, Expenditures and Changes in Fund Balance - Budget (GAAP Basis) and Actual 74 Hotel/Motel Tax Fund Statement of Revenues, Expenditures and Changes in Fund Balance - Budget (GAAP Basis) and Actual 75 Capital Project Funds Combining Balance Sheet 78 Combining Statement of Revenues, Expenditures and Changes in Fund Balances 79 Enterprise Funds Combining Balance Sheet 83 Combining Statement of Revenues, Expenses and Changes in Fund Equity 85 Combining Statement of Changes in Financial Position 86 Utility Fund Schedule of Revenues - Budget and Actual (Non-GAAP Basis) 87 Schedule of Expenses - Budget and Actual (Non-GAAP Basis) 88 CITY OF COLLEGE STATION, TEXAS COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE YEAR ENDED JUNE 30, 1987 TABLE OF CONTENTS (CONTINUED) PAGE SUPPLEMENTAL FINANCIAL INFORMATION (Continued): Sanitation Fund Schedule of Revenues - Budget and Actual (Non-GAAP Basis) 91 Schedule of Expenses - Budget and Actual (Non-GAAP Basis) 92 Utility Fund and Sanitation Fund Schedule for Reconciliation of Revenues and Expenses (Non-GAAP Basis) to GAAP Basis Statement of Income 94 Internal Service Funds Combining Balance Sheet 97 Combining Statement of Revenues, Expenses and Changes in Fund Equity 98 Combining Statement of Changes in Financial Position 99 Fiduciary Funds Combining Balance Sheet 101 General Fixed Assets Account Group Schedule of General Fixed Assets - By Sources 104 Schedule of General Fixed Assets - By Function and Activity 105 Schedule of Changes in General Fixed Assets - By Function and Activity 107 CITY OF COLLEGE STATION, TEXAS COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE YEAR ENDED JUNE 30, 1987 TABLE OF CONTENTS (CONTINUED) STATISTICAL SECTION: PAGE General Governmental Expenditures and Other Uses by Function 111 General Revenues and Other Financing Sources 113 Property Tax Levies and Collections 115 Assessed and Estimated Actual Value of Taxable Properties 117 Property Tax Rates, Ratios and Levies - All Overlapping Governments 119 Paving Assessment Collections 121 Computation of Legal Debt Margin 122 Ratio of Net General Bonded Debt to Assessed Value and Net Bonded Debt Per Capita 123 Schedule of Direct and Estimated Overlapping Debt 125 Ratio of Annual Debt Service Expenditures for General Obligation Debt to Total General Fund Expenditures 126 Schedule of Revenue Bond Coverage - Utility Fund 127 Total Bank Deposits 128 Construction Permits 129 Principal Taxpayers 130 Miscellaneous Statistical Data 131 - iv - (This page intentionally left blank.) - v - stcI1014 I�TR OD�C�ORY u i t CITY OF COLLEGE STATION, TEXAS ORGANIZATIONAL CHART JUNE 30, 1987 CITIZENS OF COLLEGE STATION MAYOR CITY COUNCIL MUNICIPAL CRY ATTORNEY CITY MANAGER MUNICIPALJUDGE CITY SECRETARY COURTCLERK PUBLIC INFORMATION PERSONNEL OFFICER POLICE FIRE ASSISTANT CITY MANAGER MANAGEMENT SERVICES ASSISTANT CITY MANAGER COMMUNITY SERVICES FISCAL BUDGET/ DATA ADMINISTRATION I I RESEARCH ( PROCESSING ELECTRICAL I SEWAGE RECREATION I IMPROVEMENTS SERVICES CITY OF COLLEGE STATION, TEXAS PRINCIPAL CITY OFFICIALS JUNE 30, 1987 Elected Officials: Mayor...........................................................Larry J. Ringer Council Members............................................Patricia B. Boughton Fred H. Brown James R. Gardner Dick B. Haddox Sara Goode Jones Lynn Mcllhaney City Administration: City Manager ....................................................William K. Cole Assistant City Manager for Community Services...........................................James R. Ragland Director of Public Utilities— ...................... o..* ........ oJohn C. Woody Director of Capital Improvements ................ .................. .Elrey B. Ash Director of Finance.........................................William P. Harrison Fire Chief ....................................................Douglas W. Landua Director of Parks— ..... o .......... o ................. o ....... Stephen C. Beachy Personnel Director.............................................Karen N. Dickson Police Chief..................................................Michael L. Strope Director of Public Services....................................Alfred W. Miller City Attorney ...................................................Catherine Locke City Secretary ....................................................Dian B. Jones Municipal Court Judge...........................................Philip C. Banks — 3 — (This page intentionally left blank.) - 4 Honorable Mayor, City Council City of College City of College Station POST OFFICE BOX 9960 1101 TEXAS AVENUE COLLEGE STATION, TEXAS 77840-2499 Members of the Station November 25, 1987 The Comprehensive Annual Financial Report of the City of College Station, Texas ("City") for the fiscal year ended June 30, 1987, is submitted herewith. This report was prepared by the City's Finance Department. Responsibility for both the accuracy of the presented data and the completeness and fairness of the presentation, including all disclosures, rests with the City. We believe the data, as presented, is accurate in all material aspects; that it is presented in a manner designed to fairly set forth the financial position of its various funds; and that all disclosures necessary to enable the reader to gain the maximum understanding of the City's financial affairs have been included. Certificate of Achievement The Government Finance Officers Association of the United States and Canada (G1!OA) awarded a Certificate of Achievement for Excellence in Financial Reporting to the City for its comprehensive annual financial report for the fiscal year ended June 30, 1986. In order to be awarded a Certificate of Achievement, a government must publish an easily readable and efficiently organized comprehensive annual financial report in which its contents conform to program standards. Such reports must satisfy both generally accepted accounting principles and applicable legal requirements. A Certificate of Achievement is valid for a period of une year only. We belA evP our current report continues.to conform to Certificate of Achievement Program requirements, and we are submitting it to GFOA to determine its eligibility for a certificate. Accounting System and Budgetary Control In developing and evaluating the City's accounting system, con- sideration is given to the adequacy of internal accounting controls. Internal accounting controls are designed to provide reasonable, but not absolute, assurance regarding: (1) the safeguarding of assets - 5 - against loss from unauthorized use or disposition; and (2) the reliability of financial records for preparing financial statements and maintaining accountability for assets. 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 evaluation of costs and benefits requires estimates and judgments by management. All internal control evaluations occur within the above frame— work. We believe that the City's internal accounting controls adequately safeguard assets and provide reasonable assurance of proper accounting of financial transactions. Budgetary control is maintained at the subfunction level by the encumbrance of estimated purchase amounts prior to the release of purchase orders to vendors. Purchase orders which result in an overrun of subfunction balances are not released until additional appropriations are made available. Open encumbrances are reported as reservations of fund balance at June 30, 1987. The Reporting Entity and Its Organization The City of College Station is located in East Central Texas in Brazos County approximately 90 miles north of Houston, 165 miles south of Dallas, and 100 miles east of Austin. The City has a population of 52,851 and contains the 5200 acre Texas A&M University campus. The City was incorporated in 1938 and operates under a council—manager form of government. The Mayor and six Council Members are elected from the City at large, with the Mayor and three Council members being elected in each even —numbered year for two—year terms and the other three Council members elected in each odd —numbered year for two—year terms. The City Council appoints several boards and commissions, none of which have operating budgets or financial statements with the exception of the College Station Economic Development Foundation. Because the Foundation is administered by a separate board and is not subject to oversight by the Mayor and City Council, its financial statements are not included within the scope of this report. The City Manager, City Attorney, City Secretary, Municipal Judge, and Municipal Court Clerk are all appointed by the City Council. At present, the City Manager utilizes an Assistant City Manager for Community Services, who is responsible for the parks and recreation, capital improvements, and public services areas; a Director of Public Utilities, who oversees electrical, water, and sewer services; and a Director of Finance, who oversees the areas of accounting, budgeting, data processing, centralized purchasing, and financial administration. — 6 — The City provides a full range of municipal services to its citizens. In the public safety area, the City maintains and operates a Police Department and a Fire Department with emergency medical services and fire prevention services available. In the area of public services, the City of College Station provides street cleaning, repair and maintenance, and construction in addition to minor drainage maintenance. Other public services provided are maintenance and perpetual care for the City's cemetery grounds and rights -of -way, residential and commercial garbage collection, and operation of a landfill site for disposal of non -hazardous solid waste. Included in the City's services is a parks system operated and maintained by the Parks Department which sponsors a variety of organized athletic and aquatic programs as well as many special events throughout the year. The City owns and operates a Community Center along with several other activity centers for youth and adults. The Capital Improvements Department provides engineering, planning, and building inspection services. Included in this area is the Community Development office which supports neighborhood revitalization.ac.tivities through the administration of federal Housing and -Urban Development grants. The City maintains, and:: operates water'; production, .water distribution, and'sewsge colle.c'tionsys.tems. In addi.ti6ri, the City owns and operates wastewater tr.e.atment plant. Althnu'gh the City purchases subsC1f I. alli.i;:power ,requirements from Gulf ::States Utilities, it,does not .pTovide f6r:.:construction and ma:(ntenance of::°ttansmisstO.,h� and 'distribu:ttiorisystems,.: pneral,sta..,f;:;:s:ipport..t::A nc1udes:-a,Pe::r onn0:1 Department, an in-house legal.: staff, a GitiZ0ns' u:ervice.'.Repxeseh ativ.e. a Coun'caL1 Coax:dinator,::a;.::muniei;pa:1..c�iurt staff. and a..Pub. is Information Of f Cep' The City of.Co lege Station operates„its own in-house print -mail service, building :,%a gntenance service, and garage for..: fleet maintenance .In cooperation with the Qity of Bryan, the City operates the College Station Library, a branch of the Bryan Library, and contributes to the funding of a City -County HealthUnit. General Governmental Function Revenues and other financing sources for general governmental functions (General Fund and Debt Service) totaled $13,750,507 in 1987, an increase of 1.8% over 1986. Property taxes amounted to $4,202,807 or 30.57% of all general governmental revenues. City sales and mixed - 7 - drink taxes produced 21.94% of general revenues compared to 22.7% in 1986. The transfer from Enterprise Fund in lieu of taxes increased $235,703 and represented 31.28% of total general governmental revenues as compared to 30.11% in the previous year. Most revenues, with the exception of property taxes and the transfer from the Enterprise Fund in lieu of taxes, were down in FY 1987. These declines are indicators of the continued soft state and local economies. The most significant decreases, however, were in licenses, permits, and certificates; charges for services; and other financing sources. The decrease in licenses, permits, and certificates can primarily be attributed to a 92% drop in revenues from health permits which are now collected and kept by the County. Prior to FY 1987, the City collected and recognized revenue from these health permits. In addition, the total value of construction permits issued declined more than $1.1 million. The decline in revenue from charges for services can be explained by the opening of a new sports complex in nearby Bryan, and the decrease in other financing sources was a result of the decrease in federal Revenue Sharing funds received by the City during FY 1987. The amount of revenues from various sources and the change from the prior year are shown in the following tabulation: Revenue Source General fund property tax $ Delinquent taxes and penalties Franchise taxes City sales & mixed drink tax Licenses, permits & certificates Fines & service fees Charges for services Transfer from Enterprise Fund in lieu of taxes Miscellaneous revenues Other financing sources Debt service property tax Increase Percent (Decrease) Amount of Total From 1986 209,997 1.53% $ 6,399 12,829 .09 7,946 299,973 2.18 (15,299) 3,016,640 21.94 (49,528) 102,739 .75 (12,232) 442,408 3.22 (17,464) 298,463 2.17 (36,908) 4,302,654 31.28 235,703 414,908 3.02 7,621 657,086 4.78 (49,686) 3,992,810 29.04 166,727 Total $13,750,507 100.00% $243,279 Assessed value of $1,121.5 million represented an increase of $25.8 million over 1985-86. Current tax collections were 92.83% of the tax levy. Total collections (current and delinquent) as compared to the current tax levy were 97.34%. For the second year, five percent of current property tax revenue was allocated to the General Fund in order to fund the library facility. Allocation of the property tax levy by purpose for 1987 and the preceding two fiscal years are as follows (amounts per $100 assessed value): Purpose 1987 1986 1985 General Fund $ .0200 $ .0200 $ .0000 General Obligation Debt .3600 .3600 .3600 Total Tax Kate $ .3800 $ .3800 $ .3600 Expenditures and other uses for general governmental purposes (General Fund and Debt Service) totaled $13,089,325, a decrease of 1.43% from 1986. Capital outlay expenditures decreased from 4.56% of total expenditures in 1986 to 3.06% in 1987. Debt service expendi- tures in 1987 accounted for 28.31% of total expenditures as compared to 26.67% last year. Police expenditures increased from 20..42%;;9f total expenditures in 1986 to 23.11% in 1987. General government expenditures .increased $.2.65, 84 and, represented 32.19% of :'total expenditures.: Other ,major. fun,pt,ions of the City which showed increases, over 19136' levels �rexe::: fi re; 'parks and recreation, and transfers for administrative" :costs from the Enterprise .Funds. The.34% reduction fin expenditures.for capital outlay was a direct resul..t of the $5..11,253,:d6crease in: Revenue Sharing funds received by t4,e:,Cf.ty during 1.987. in past years, these .°manes were. used to fund cape:al outlay':.expendi.;tures. The $313;124 ahcrease in ;:police expezdi'tures can be attributed to.. increased :s:al.aries due to position r6c�lAss.ifications and increases iA! other operating costs. The increase in..:general governmental expenditures<itesulted,from the fusidllgg.of the ::college Station Economic Develrpment Foundation and from expenditut.es.;. elating to the first full year :of operations for the College Station Library. Increases (decreases) in levels of expenditures for major functions of the City over the preceding year are shown in the following tabulation: Function General Government Police Fire Public Services Parks & Recreation Debt Service Capital Outlay Reimbursed Administrative Costs Total Increase (Decrease) Amount Percent From 1986 $ 4,214,064 32.19% $ 265,284 3,024,395 23.11 313,124 2,324,273 17.76 99,477 1,190,695 9.10 (49,928) 1,583,837 12.10 11,231 3,705,802 28.31 (101,781) 399,930 3.06 (206,226) (3,353,671) (25.63) (521,518) $13,089,325 100.00% $ (190,337) Fund balances and retained earnings in the major operating funds were maintained at adequate levels. The General Fund balance of $2,086,433 was up $129,371 from 1986, and the $298,958 balance in the Special Revenue Funds was down $517,847. Debt Administration The ratio of net bonded debt to assessed value and the amount of bonded debt per capita are useful indicators of the City's debt position to municipal management, citizens and investors. Such data at the end of the 1987 fiscal year were as follows: Ratio of Ratio of Debt Debt Net Bonded to to Present Per Amount Assessed Value Market Value Capita Net Direct Bonded Debt $15,850,344 1.41% 1.41% $300 Outstanding general obligation bonds at June 30, 1987, totaled $18,411,000. In addition, $1,977,487 of long—term notes and certifi— cates are outstanding. For more detailed information about the debt position of the City, please refer to the notes to the combined financial statements and the statistical sections of this report. The City's general obligation bonds and revenue bonds continue to carry the same ratings. These ratings are as follows: Moody's Standard & Investors Service Poor's General Obligation Bonds A-1 A+ Revenue Bonds (Insured) AAA AAA — 10 — Cash Management Cash temporarily idle during the year was invested in time deposits ranging from 30 to 365 days to maturity. All time deposits were in the form of certificates of deposit or U.S. Treasury Bills. The yields on maturing investments ranged from 4.89% to 7.82% during the year, and the amount of interest earned on these investments totaled $1,828,944. By mutual agreement, the City's depository agreement with University National Bank was terminated in June, 1986. After soliciting and receiving bids for a renewal contract for depository services, the City awarded a two-year contract to First Republicbank A&M. Investment rates achieved are at a rate equal to the daily quoted rates in the Treasury Bill yield column plus 15 basis points. (A basis point is equal to 1/100 of one percent). All demand accounts are earning interest at a rate which is the greater of the prior month's average of weekly average Federal Funds rates minus 100 basis points, as quoted by the Federal Reserve Bank of New York, or the basic NOW account rate offered by the bank to all customers. Demand account interest totaled $260,911 for fiscal year 1987. Capital projects Funds Proceeds of general abligation bond issues are ac6,ounted for in Capital Projects.kund:s until the p:roject.s.are comple:tedo- ese projects and .con str.uction„in progress at .year-end are Capitalized in the General Fixed Asserts.':,group of accounts.: During:::19:87., projects and other :capita l `additions totaled $3;994;417 uthorized.but unissued bonds at dune 30,:11 1 totaled 5 000. Tl e Capital :Project Fund balances ;inn hand at June 30, 19i37; total e.d $(�S,032; and consisted p� maril}� of aasli and investments General Fixed Assets The`g'eneral fixed assets of "thy: City are those.:..f.ixPd assets used in fixed assets of .Enterprise funds. As of JunenGti,ons and exclude the fi the pe.r.f,s�,rmance o general overnmental fD, 187, the general fixed assets of.the City amounted to $38,45010..10. This amount represents the original cost of the assets and is considerably less than their present value. Depreciation of general fixed assets is not recognized in the City's accounting system. Sanitation Fund The Sanitation Fund showed a net loss of $127,445 in 1987 which decreased retained earnings to $1,140,230. This reserve will be used for major capital expenditures in future years. Utility Fund The City's utility operation continued to show gains in operating revenues, number of customers, and net income. The debt service average and maximum coverage ratios both showed increases over the 1986 ratios. (For a further discussion of the average and maximum coverage ratios, please refer to Note 6 of the general purpose financial statements.) Comparative data for the past three fiscal years are presented in the following tabulation: 1987 1986 1985 Operating Revenues $32,760,614 $32,480,725 $31,867,897 Operating Income 8,403,514 7,147,700 8,976,656 Income Available for Debt Service 9,982,845 8,522,568 10,194,354 Average Annual Debt Service 3,357,048 3,476,179 3,582,202 Coverage (income available for debt service divided by average annual debt) 2.97 2.45 2.85 Maximum Annual Debt Service 5,096,158 5,143,007 5,172,546 Coverage (income available for debt service divided by maximum annual debt) 1.96 1.66 1.97 During fiscal 1987, $2,490,000 of the 1985 refunding bond issue were retired. In addition, *368,500 of general obligation bonds and $54,606 of certificates of obligation, serviced with earnings of the Utility activities, were retired. Local Economic Highlights The City of College Station is continuing to experience growth but at a more moderate rate than in the late 1970s and early 1980s. Some of the economic highlights during fiscal year 1987 which are indicators of this continued growth are: 1. The City continues to require capital additions in the utility system, streets, and parks. In addition, during fiscal year 1967, construction was begun on the new Utility Service Center (a 40,764 square foot office and warehouse facility) and on the renovation of a 17,000 square foot addition to the Police Building. These two projects totaled more than $5.7 million. 2. College Station has experienced substantial growth in medical facilities. Last year the new Scott and White Clinic opened, and this year Humana Hospital opened a new 100-bed facility along with a medical office complex. In addition, two new psychiatric hospitals, Sandstone and Greenleaf, are in the early stages of construction. - 12 - 3. The number of utility customers continues to increase. This increase is evidenced by the 18,777 peak count in fiscal year 1987 as compared to the 18,400 and 18,499 peak counts in the 1985 and 1986 fiscal years, respectively. 4. Sales tax revenue declined slightly due to the continued soft state and local economic conditions. However, sales tax receipts for the first five months of fiscal year 1988 are already $169,043 or 14.06% above the receipts for the same period last fiscal year, an indication that the local economy has taken a turn upward. Some of this sales tax growth can be attributed to the 2,531 increase in fall enrollment at Texas A&M University. 5. For seven of the first nine months of calendar year 1987, the College Station area recorded the lowest unemployment statistics in the state of Texas. 6. Expansion of airport facilities has continued with completion of the preliminary design for the new terminal building scheduled for December, 1987. This new terminal facility is expected to -be operational by October, 1989. In addition, construe:tidn has begun on a 33,000 square yard rsmp:,:ddjacent to <<the, proposed.:,new...;tarminal building. Independent.Audit. The City_:Ch>artel� requires an.:.annudl. audit, of the,'.. books of account, financial records, and..t:r;ansactioris.of'all: administrative, epartmen s of tlxe.`.City b ' :inde.penden certifl.ed publ� c ,accountaz�t4:, selected by the City Council This requirement has;been:complied with and the auditors' opinion has beon included, in this„,report. Acknowledgments The preparation of this report on a timely basis could not have been accomplished without the efficient and dedicated services of the entir@"`''bCaff!' of the Filtallce Department. We wou, ,d:. Uke to express our contributed to its preparation. assisted and apgreci.a.xi,.c�.1� to all pme�be;rs of Gh�.. De artment w�l,,,,,, p ° anon. We would.als;o' ike to thank the Mayor and City Council for their interest and support in planning and conducting the financial operations of the City in a responsible and progressive manner. Finally, we would like to thank our auditors, Deloitte Haskins & Sells, whose professional expertise and advice has resulted in continuing improvements in the quality of the City's financial reporting. Respectfully Submitted, William K. Cole William Harrison City Manager Director of Finance - 14 - 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 June 30, 1986 A Certificate of Achievement for Excellence in Financial Reporting is presented by the Government Finance Officers Association of the United States and Canada to governmental units and public employee retirement systems whose comprehensive annual financial reports (CAFR's) are judged to substantially conform to program standards. �UNITEDSTAIES' y V w AND N President E CANAOA o d CORPORATION 'Executive Director — 15 — (This page intentionally left blank.) - 16 - (This page intentionally left blank.) oft Deloitte Haskin"ells 1200 Travis Houston, Texas 77002 (713) 651-1700 Telex 762840 AUDITORS' OPINION Mayor Larry Ringer and Members of City Council of the City of College Station, Texas: We have examined the general purpose financial statements of the City of College Station, Texas ("City") as of June 30, 1987 and for the year then ended, listed in the foregoing table of contents. Our examination was made in accordance with generally accepted auditing standards and, accordingly, included such tests of the accounting records and such other auditing procedures as we considered necessary in the circumstances. In our opinion, the accompanying general purpose financial statements present fairly the financial position of the City at June 30, 1987, and the results of its operations and the changes in financial position of its proprietary fund types and pension trust fund for the year then ended, in conformity with generally accepted accounting principles applied on a basis consistent with that of the preceding year. Our examination also comprehended the supplemental financial information, listed in the foregoing table of contents as of June 30, 1987 and for the year then ended. In our opinion, such supplemental financial information, when considered in relation to the general purpose financial statements, presents fairly in all material respects the information shown therein. In connection with our examination, nothing came to our attention that caused us to believe that the City was not in compliance with any of the accounting or financial reporting requirements of the various bond reoolutions governing the outstanding bonds of the City. Our examination was not, however, directed primarily toward obtaining knowledge of such noncompliance. The accompanying statistical tables, listed in the foregoing table of contents, were not audited by us and, accordingly, we express no opinion on them. September 18, 1987 — 19 — (This page intentionally left blank.) - 20 - CITY OF COLLEGE STATION, TEXAS COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS JUNE 30, 1987 Governmental Fund Types Special Debt Capital ASSETS General Revenue Service Projects Cash on hand and in bank (Note 2) $ 275,583 $157,065 $ 223,259 $ 937,605 Investments (Note 2) 515,000 75,000 2,160,000 5,200,000 Receivables: Delinquent taxes (Note 3) 33,145 549,469 Accounts 17,200 Less allowance for uncollect- ible accounts (105,606) (12,910) (73,299) Paving assessments 71,743 Accrued interest 5,279 1,365 43,314 85,479 Ambulance services 54,481 Grants 7,525 325,802 Other 115,855 14,164 127,572 159,381 ' Foundation (Note 4) 3,000,000 Due from other funds (Note 11) 1,769,200 230 10,950 4,110 Inventories 90,065 Prepaid costs 124,693 1,253 Restricted assets: Cash in bank (Note 2) Investments (Note 2) Accrued interest receivable Property and equipment (Note 5) Accumulated depreciation Deferred charges Amount available for retirement of bonded indebtedness Amount to be provided for: Retirement of bonded indebtedness Accrued vacation leave TOTAL ASSETS $5,974,163 $561,969 $3,114,564 $6,313,276 See notes to general purpose financial statements. - 21 - Fiduciary Proprietary Fund Types Fund Type Internal Enterprise Service Trust $ 877,791 $ 94,789 $ 4,128 5,396,000 51,000 3,844,683 (345,415) 31,881 77 ,747 344,909 5991073 1,250,060 93,900 13,935 1,753,719 13,975,001 299,605 63,202,371 (11,449,364) 367,535 787 Account Groups General General Total Fixed Long -Term (Memorandum Assets Debt Only) $ 2,570,220 13,397,000 582,614 3,861,883 (537,230) 71,743 168,105 54,481 333,327 494,719 3 ,000 ,000 2,729,282 1,340,125 233,781 1,753,719 13,975,001 299,805 $38 ,450 ,010 101 ,652 ,381 (11,449,364) 367,535 $ 79,720,623 $707,797 $56,725 $38,450,010 $ 2,560,656 2,560,656 17,827 ,831 17 827,831 487,557 487,557 $20,876,044 $155,775,171 (Continued) - 22 - CITY OF COLLEGE STATION, TEXAS COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS (Continued) JUNE 30, 1987 Governmental Fund Types Special Debt Capital LIABILITIES General Revenue Service Projects Accounts payable $ 136,673 $ 17,748 $ 870 $ 30,863 Accrued liabilities 177,822 3,569 Retainage payable 1,372 41,294 121,711 Due to other funds (Note 11) 444,260 198,586 4,670 Obligation under capital lease - current (Note 13) Liabilities payable from restricted assets: Construction contracts and retainages payable Accrued interest payable Revenue bonds - current portion General obligation bonds - current portion Certificates of obligation - current portion Customers' meter deposits Refundable deposits 4,029 5,383 Deferred revenues - other 123,574 549,469 Deferred revenues - Foundation (Note 4) 1,532,377 Unamortized discount -- Foundation ( Note 4 ) 1 ,467 ,623 Long-term debt (Note 6): Revenue bonds General obligation bonds Certificates of obligation Obligation under capital lease ( Note 13 ) Accrued vacation leave Total liabilities 3,887,730 263,011 553,908 157,244 FUND EQUITY Contributed capital Investment in general fixed assets Retained earnings: Reserved for debt service Unreserved Fund balances: Reserved (Note 14) 237,940 2,560,656 190,402 Unreserved: Designated for subsequent years' expenditures 452,176 5,085,768 Undesignated 1,396,317 298,958 879,862 Total fund equity 2,086,433 298,958 2,560,656 6,156,032 COMMITMENTS AND CONTINGENCIES (Note 13) TOTAL LIABILITIES AND FUND EQUITY $5,974,163 $561,969 $3,114,564 $6,313,276 See notes to general purpose financial statements. - 23 - Fiduciary Proprietary Fund Types Fund Type Internal Enterprise Service Trust $ 1,713,683 148,812 $ 50,292 2,080,566 $ 1,200 286,186 454,309 1,031,062 2,605,000 368,500 54,606 1,679,492 84,189 26,830,000 3,480,500 401,826 3,812,120 101,759 45,132,610 10,242,179 50,292 1,200 2,746,188 21,599,646 657,505 55,525 Account Groups General General Fixed Long -Term Assets Debt $38,450,010 34,588,013 657,505 55,525 38,450,010 $18,411,000 1,977,487 487,557 20,876,044 To tal (Memorandum Only) $ 1,899,837 380,495 164,377 2,729,282 286,186 454,309 1,031,062 2 ,605 ,000 368,500 54,606 1,679,492 9,412 757 ,232 1,532,377 1,467,623 26,830,000 21,891,500 2,379,313 3,812,120 589,316 70,922,039 10,242,179 38,450,010 2,746,188 22,257,151 3,044,523 5 ,537 ,944 2,575,137 84,853,132 $79,720,623 *707,797 $56,725 $38,450,010 $20,876,044 $155,775,171 - 24 - CITY OF COLLEGE STATION, TEXAS COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - ALL GOVERNMENTAL FUND TYPES AND EXPENDABLE TRUST FUNDS FOR THE YEAR ENDED JUNE 30, 1987 REVENUES General Taxes $ 3,551,466 Permits 90,445 Fines 442,408 City services provided 298,463 Grants 36,869 Interest 93,962 Other 170,941 Total revenues 4,684,554 EXPENDITURES Current: Administration 1,137,723 Finance 1,525,044 Public service 1,190,695 Police 3 ,024 ,395 Fire 2,324,273 Engineering 1,255,186 Parks 1,583,837 Housing rehabilitation Reimbursed administrative expenditures (3,353,671) Other 296,111 Capital outlay 399,930 Debt service: Principal retirement Interest and fiscal charges Total expenditures 9,383,523 Excess (deficiency) of revenues over expenditures (4,698,969) OTHER FINANCING SOURCES (USES): Operating transfers in (Note 12) 4,828,340 Operating transfers out (Note 12) Total other financing sources (uses) 4,828,340 Excess (deficiency) of revenues and other financing sources over expenditures Governmental Fund Types Special Debt Revenue Service $ 481,252 $3,992,810 1,433,254 30,569 138,991 2 ,084 ,066 740,336 298,211 513,299 392,981 1,944,827 139,239 (657,086) (657,086) and other uses 129,371 (517,847) FUND BALANCES, JULY 1, 1986 1 ,957 ,062 816,805 FUND VALANCES, JUNE 30, 1987 $ 2,086,433 $ 298,958 See notes to general purpose financial statements. Capital Projects 113,403 $ 446,811 59,482 4,106,213 506,293 270 1 ,b85,439 2 ,020 ,093 3,705,802 400,411 131,400 131,400 531,811 2,028,845 $2,560,656 110,100 73,306 3,311,771 3,495,177 (2,988,884) 369,737 (369,737) (2,988,884) 9,144,916 $ 6,156,032 - 25 - Fiduciary Fund Type Total Expendable (Memorandum Trust Only) $ 8,025,528 90,445 442,408 298,463 1,470,123 $ 33,231 687,976 4,711 374,125 7,942 11 ,389 ,068 1,137,723 1,525,044 1,190,695 3,024,395 2,324,273 1,255,186 1,583,837 740,336 (2,945,360) 14,462 897,448 4,104,682 1,685,439 2 ,020 ,093 14,462 18,543,791 (6,520) (7,154,723) 5,329,477 (1,026,823) 4,302,654 (6,520) (2,852,069) 61,168 14,008,796 $54,648 $11,156,727 — 26 — CITY OF COLLEGE STATION, TEXAS COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL (NON-GAAP BASIS) GENERAL AND CERTAIN SPECIAL REVENUE FUNDS FOR THE YEAR ENDED JUNE 30, 1987, REVENUES Taxes Permits Fines City services provided Grants Interest Other Total revenues EXPENDITURES Current: Administration Finance Public service Police Fire Engineering Parks Reimbursed administrative expenditures Other Housing rehabilitation Capital outlay Total expenditures Excess (deficiency) of revenues over expenditures OTHER FINANCING SOURCES (USES) Operating transfers in Operating transfers out Total other financing sources (uses) EXCESS (DEFICIENCY) OF REVENUES AND OTHER SOURCES OVER EXPENDITURES AND OTHER USES Budget $ 3,514,978 95,000 543,000 245,300 20,000 60,000 172,950 4,651 ,228 1,271,629 1,635,505 1,399,263 3,115,935 2,469,030 1,332,281 1,658,976 (3,357,306) 186,804 316,389 16 ,028 ,506 (5,377,278) 4,828,340 4,828,340 General Fund Ac tual $ 3,539,439 90,445 442,408 298,463 36,869 58,323 149,208 4,615,155 1,143,277 1,521,200 1,187,802 3,022,153 2,301,327 1,247,806 1,586,457 (3,353,671) 185,000 288,210 9,129,561 (4,514,406) 4,828,340 4,828,340 Variance Favorable (Unfavorable) $ 24,461 (4,555) (100,592) 53,163 16,869 (1,677) (23,742) (36,073) 128,352 114,305 211,461 93,782 167,703 84,475 72,519 (3,635) 1,804 28,179 898,945 862,872 $ (548,938) $ 313,934 $ 862,872 See notes to general purpose financial statements. - 27 - Certain Special Revenue Funds Variance Favorable Budget Actual (Unfavorable) $ 540,000 $ 481,252 $ (58,748) 952,000 1,433,254 481,254 30,497 30,497 43,500 136,729 93,229 1,535,500 2,081,732 546,232 160,000 298,211 (138,211) 1,048,373 511,362 537,011 697,001 740,336 (43,335) 469,128 390,331 78,797 2,374,502 1,940,240 434,262 (839,002) 141,492 980,494 (657 ,086) (657,086) (657,086) (657,086) $1,496,088 $ (515,594) $ 980,494 CITY OF COLLEGE STATION, TEXAS COMBINED STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND EQUITY - ALL PROPRIETARY FUND TYPES AND PENSION TRUST FUND FOR THE YEAR ENDED JUNE 30, 1987 Proprietary Fund Types Internal Enterprise Service OPERATING REVENUES: Electric $26,903,239 Water 3,114,269 Sewer 2,326,181 Sanitation 1,453,392 Premiums Other 416,925 Total operating revenues 34,214,006 OPERATING EXPENSES: Purchased power (Note 8) 15,291,836 Salaries and benefits 3,025,595 Supplies 265,699 Building maintenance 354,548 Equipment maintenance 153,270 Services 1,891,645 Claims Administration fee Premiums Other 353,251 Administrative expenses from general fund 2,945,360 Depreciation: Electrical system 522,331 Water system 631,579 Sewer system 416,848 Sanitation system 103,038 Other 8,573 Total operating expenses 25,963,573 OPERATING INCOME 8,250,433 NONOPERATING REVENUES (EXPENSES): Interest earnings 1,378,470 Interest expense (3,185,429) Other, net 12,144 Total nonoperating revenues (expenses) (1,794,815) $766,170 766,170 573,030 44,963 55,040 3,764 676,797 89,373 1,684 1,684 Fiduciary Fund Type Pension Trust $4 ,500 4,500 4,266 4,266 234 201 201 Total (Memorandum Only) $26,903,239 3,114,269 2,326,181 1,453,392 766,170 421,425 34,984,676 15,291,836 3,025,595 265,699 354,548 153,270 1,891,645 573,030 44,963 55,040 361,281 2,945,360 522,331 631,579 416,848 103,038 8,573 26 ,644 ,636 8,340,040 1,380,355 (3,185,429) 12,144 (1,792,930) (Continued) - 29 - CITY OF COLLEGE STATION, TEXAS COMBINED STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND EQUITY - ALL PROPRIETARY FUND TYPES AND PENSION TRUST FUND (Continued) FOR THE YEAR ENDED JUNE 30, 1987 Proprietary Fund Types Internal Enterprise Service Fiduciary Fund Type Total Pension (Memorandum Trust Only) Income before operating transfers $ 6,455,618 $ 91,057 $ 435 $ 6,547,110 Operating transfers to general fund (Note 12) (4,302,654) (4,302,654) Net income 2,152,964 91,057 435 2,244,456 FUND EQUITY, JULY 1, 1986 32,435,049 566,448 442 33,001,939 FUND EQUITY, JUNE 30, 1987 $34,588,013 $657,505 $ 877 $35,246,395 See notes to general purpose financial statements. - 30 - CITY OF COLLEGE STATION, TEXAS COMBINED STATEMENT OF CHANGES IN FINANCIAL POSITION ALL PROPRIETARY FUND TYPES AND PENSION TRUST FUND FOR THE YEAR ENDED JUNE 30, 1987 Fiduciary Proprietary Fund Types Fund Type Total Internal Pension (Memorandum Enterprise Service Trust Only) SOURCES OF WORKING CAPITAL: Operations: Net income $2,152,964 $ 91,057 $ 435 $2,244,456 Items not requiring working capital: Depreciation 1,682,369 1,682,369 Amortization of deferred charges 32,411 32,411 Working capital provided by operations 3,867,744 91,057 435 3,959,236 Decrease in restricted assets 3,614,485 3,614,485 Increase in payables from restricted assets 45,041 45,041 Increase in accrued vacation leave 12,363 12,363 Increase in deferred revenues 62,932 62,932 . Total sources of working capital 7,602,565 91,057 435 7,694,057 USES OF WORKING CAPITAL: Additions of property and equipment 5,306,402 5,306,402 Principal payments: Revenue bonds 2,490,000 2,490,000 General obligation bonds 368,500 368,500 Certificates of obligation 54,606 54,606 Capital lease 262,247 262,247 Other, net 32,834 32,834 Total uses of working capital 8,514,589 8,514,589 INCREASE; (DECREASE) IN WORKING CAPITAL $ (912,024) $ 91,057 $ 435 $ (820,532) (Continued) - 31 - CITY OF COLLEGE STATION, TEXAS COMBINED STATEMENT OF CHANGES IN FINANCIAL POSITION - ALL PROPRIETARY FUND TYPES AND PENSION TRUST FUND (Continued) FOR THE YEAR ENDED JUNE 30, 1987 Fiduciary Proprietary Fund TyL Fund Type Total Internal Pension (Memorandum Enterprise Service Trust Only) ELEMENTS OF NET INCREASE (DECREASE) IN WORKING CAPITAL: Cash on hand and in bank $ (112,061) $ 84,390 $ 620 $ (27,051) Investments (622,000) 1,000 (621,000) Receivables (75,798) 15 (75,783) Due from other funds 99,435 25,445 124,880 Inventories 256,699 256,699 Prepaid costs 62,071 10,435 72,506 Accounts payable 223,720 223,720 Accrued liabilities 110,762 (29,213) (1,200) 80,349 Due to other funds (831,450) (831,450) Obligation under capital lease - current (23,402) (23,402) INCREASE (DECREASE) IN WORKING CAPITAL $ (912,024) $ 91,057 $ 435 $ (820,532) See notes to general purpose financial statements. - 32 - (This page intentionally left blank.) - 33 - CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES REPORTING ENTITY The City of College Station ("City") has included in the general purpose financial statements the accounts of all city operations for which the Mayor and City Council have oversight responsibility. Such oversight responsibility includes designation of management, selection of governing authority, the ability to significantly influence operations, the scope of public service, and the accountability for fiscal matters. The City's major operations which are covered by this oversight responsibility include police and fire protection, streets, sanitation, health, art -cultural, parks, public improvements, planning and zoning, general administrative services, electrical, and water and sewer systems. The College Station Industrial development Foundation was created in 1981 to encourage development of an industrial park through the issuance of tax-exempt financing. In fiscal 1986, the College Station Industrial Development Foundation was restructured as the College Station Economic Development Foundation ("Foundation") with the purpose of accumulating funds for the improvement of commercial or industrial property in the City, and buying and selling real property in College Station to promote the public interest. The Foundation is administered by a separate board and is not subject to oversight by the Mayor and City Council. Consequently, financial information for the Foundation is not included within the scope of these financial statements. FUND ACCOUNTING The accounts of the City are organized on the basis of funds and account groups, each of which is considered a separate accounting entity. The opera- tions of each fund are accounted for with a separate set of self -balancing accounts that comprise its assets, liabilities, fund equity, revenues, and expenditures or expenses, as appropriate. Government resources are allocated to and accounted for in individual funds based upon the purposes for which they are to be spent and the means by which spending activiLles are controll.pad. The various funds are grouped, in the accompanying financial statements, into seven generic fund types and three broad fund categories as follows: Governmental Fund Tvpes The General Fund is the general operating fund of the City. It is used to account for all financial resources except those required to be accounted for in another fund. - 34 - CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 I. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(Cont'd) FUND ACCOUNTING-(Cont'd) Special Revenue Funds are used to account for the proceeds of specific revenue sources (other than special assessments, expendable trusts, and major capital projects). The Debt Service Fund is used .to account for the accumulation of resources for, and the payment of, general long-term debt principal, interest, and related costs. Capital Project Funds are used to account for financial resources to be used for the acquisition or construction of major capital facilities (other than those financed by proprietary funds). Proprietary Fund Types Enterprise Funds are used to account for operations (a) that are financed and operated in a manner similar to private business enterprises - where the intent of the governing body is that the costs (expenses, including depreciation) of providing goods or services to the general public on a continuing basis are to be financed or recovered primarily through user charges; or (b) where the governing body has decided that periodic deter- mination 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. Fiduciary Fund Type Trust Funds are used to account for assets held by the City in a trustee capacity for private organizations and individuals. These include Expendable Trusts and a Pension Trust. The Pension Trust Fund is accounted for in essentially the same manner as proprietary funds since capital maintenance is critical. Expendable Trust Funds are accounted for in essentially the same manner as governmental funds. - 35 - CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(Cont'd) ACCOUNT GROUPS Account groups are used to establish accounting control and accountability for the City's general fixed assets and general long-term debt. The following are the City's account groups: General Fixed Assets Account Group - This group of accounts is established to account for all fixed assets of the City, other than those accounted for in the proprietary funds. General Long-term Debt Account Group - This group of accounts is established to account for all long-term debt of the City except that accounted for in the proprietary funds. General long-term debt of the City includes general obligation bonds, certificates of obligations and accrued vacation leave. BASIS OF ACCOUNTING All governmental funds and expendable trust funds are accounted for using the modified accrual basis of accounting. Under this basis, revenues are recognized when they become measurable and available as net current assets. Available means collected within the current year or soon enough thereafter to be used to pay liabilities of the current year. Substantially all revenues are considered to be susceptible to accrual. Expenditures are generally recognized under the modified accrual basis of accounting when the related fund liability is incurred. Exceptions to this general rule are the principal and interest on general long-term debt which are recognized when due, and accrued vacation leave which is recognized when expected to be liquidated with expendable available financial resources. All proprietary funds and the pension trust fund are accounted for using the accrual basis of accounting. Their revenues are recognized when they are earned, and their expenses are recognized when they are incurred. Utility customers are billed monthly on a cycle -billing basis with revenues recorded when customers are billed, except at year-end when unbilled revenues are accrued. POWER COST RECOVERY The City is allowed to recover purchased power costs as power cost adjust- ments. This power -cost recovery allows for the pass -through of power costs to the customers and has no impact on net income. The amount of any under or over recovered purchased power costs at year-end was not material. - 36 - CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 I. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(Cont`d) BUDGETS AND BUDGETARY ACCOUNTING The City follows these procedures in establishing the budgetary data reflected in the financial statements: 1) Prior to June 1, the City Manager submits to the City Council a proposed operating budget for the fiscal year commencing the following July 1. The operating budget includes proposed expenditures and the means of financing them. 2) All budget requests are compiled by the Finance Department and presented with comparative and supporting data to the Mayor and City Council for review. 3) Public hearings are properly advertised and conducted at City Hall for taxpayer comments. 4) Prior to June 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 expendi- ture 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. 6) Expenditures in excess of appropriations for each fund are prohibited by the City Charter. Appropriations which have not been expended or lawfully encumbered lapse at the end of the budget year. 7) Formal budgetary integration is legally enacted and employed as a management control device during the year for the General Fund, Special Revenue Funds (with one exception), and the Enterprise Funds. A special revenue fund (Crime Prevention), created solely to account for citizen contributions used for juvenile education programs, is not budgeted. The contributions are not significant in amount and their use is administered by the police department. Formal budgetary integration is not employed for the Debt Service Fund and Capital Project Funds because effective budgetary control is alternatively achieved through general obligation bond indenture provisions. - 37 - CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(Cont'd) BUDGETS AND BUDGETARY ACCOUNTING-(Cont'd) 8) The General Fund budget is adopted on a basis consistent with generally accepted accounting principles ("GAAP"), except for the following significant items: (a) The City does not include revenue or expenditure activity for the Parks Escrow Fund or Computer Project Fund, which are combined with the General Fund for reporting purposes, in General Fund budgetary amounts. (b) Budgeted revenue amounts do not include a provision for property tax receipt accruals. (c) Encumbrances for capital items which do not lapse at year-end are treated as budgeted expenditures in the year the commitment to purchase is made. (d) General Fund budgetary amounts do not include provisions for adjustments in accrued vacation leave or the allowance for uncollectible accounts receivable. Adjustments necessary to convert the General Fund revenues at June 30, 1987, on the GAAP basis to the budgetary basis are as follows: Revenues - GAAP basis Reconciling items: Parks Escrow Fund revenues Tax receipt accrual Other Total reconciling items Total revenues - Budget (Non-GAAP basis) $4 ,684 ,554 (71,112) (16,156) 17,869 (69,399) $4,615,155 CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(Cont'd) BUDGETS AND BUDGETARY ACCOUNTING-(Cont'd) Adjustments necessary to convert the General Fund expenditures at June 30, 1987, on the GAAP basis to the budgetary basis are as follows: Expenditures - GAAP basis $9,383,523 Reconciling items: Parks Escrow Fund expenditures (84,375) Current year encumbrances 20,747 Prior year encumbrances (113,124) Adjustment to vacation accrual (3,782) Adjustment to allowance for uncollectible accounts (65,417) Other (8,011) Total reconciling items (253,962) Total expenditures - Budget (Non-GAAP basis) $9,129,561 Budgets for the Enterprise Funds are adopted on a basis consistent with GAAP, except for the following significant items: (a) Capital outlay is included in the budget as an expense item. (b) Transfers to the Debt Service Fund for debt principal payments, relating to General Obligation Bonds and Certificates of Obligation which are serviced by the Utility Fund, are treated as expenses for budgetary purposes. (c) The budget considers principal payments for Utility Revenue Bonds as an expense item. (d) Enterprise Fund budgetary amounts do not include provisions for adjustments in accrued vacation leave or the allowance for uncollectible accounts receivable. (e) The City does not budget for depreciation on Enterprise Fund property and equipment. (f) Budgeted revenue amounts do not include a provision for revenue accruals. - 39 - CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 I. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(Cont'd) BUDGETS AND BUDGETARY ACCOUNTING,-(Cont'd) See the schedule at page 94 for a reconciliation of revenues and expenses (non-GAAP basis) to the GAAP basis statement of income for the Utility Fund and the Sanitation Fund. Budgets for the Special Revenue Funds are adopted on a basis consistent with GAAP. Budgetary comparisons presented in the report are on the aforementioned budgetary basis. Budgetary amounts are as originally adopted, or as amended by the City Council. Individual amendments were not material in relation to the original appropriations which were amended. 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 General Fund, Special Revenue Funds and Capital Project Funds. Encumbrances outstanding at year-end are reported as reservations of fund balances since they do not constitute expenditures or liabilities in the GAAP basis general purpose financial statements. INVESTMENTS Investments in time -deposit certificates are stated at cost which approximates market value. INVENTORY Inventory is valued at the lower of average cost or market value. The City records inventory as an asset in the General Fund with a corresponding reserve of fund balance. Inventory is recorded in Proprietary Funds as an asset with no corresponding reserve in fund balance. Other funds have no significant inventories. GENERAL 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 at cost in the General Fixed Assets Account Group. Public domain fixed assets consisting of improvements other than buildings are also included in General Fixed Assets. - 40 - CITY OF COLLEGE STATION. TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 I. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(Cont'd) GENERAL FIXED ASSETS-(Cont'd) No depreciation has been provided on general fixed assets, nor has interest been capitalized. PROPERTY AND EQUIPMENT Property and equipment owned by the enterprise funds is stated at the histori- cal cost of construction, or with respect to contributions in aid of construction from third parties (principally developers) at an estimated value which approximates cost of construction. Also, to the extent the construction is performed by the City, the cost includes payroll and related costs and certain general and administrative expenses. Interest is not capitalized in these accounts because interest is recovered currently in the City's rate calculation. Maintenance, repairs and minor renewals are charged to operating expense; major property replacements are capitalized. Depreciation is recorded in the enterprise funds on a straight-line basis over the following estimated service lives: Utility Systems 25 - 40 years Buildings and Improvements 5 - 50 years Equipment 3 - 10 years ACCRUED VACATION AND SICK LEAVE Employees are credited with vacation at rates of 10 to 15 days per year, depending upon length of service. Carryover of unused vacation time from one year to the next is allowed for a maximum of two years. Upon termination, the respective employees are paid for any accrued vacation not taken (up to the two-year maximum). Employees are credited with sick leave at the rate of one day per month and are allowed to accumulate up to 120 days. Payment for unused accumulated sick leave is not made to employees by the City. - 41 - CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES-(Cont'd) SELF-INSURANCE The City is self -insured for health benefits, and the plan is administered by Employee Benefit Management, Inc. The Employee Benefits Fund is funded monthly by contributions from employees and from the operating funds of the City. These contributions are actuarially determined. The City has a stop -loss insurance policy that limits its liability per employee to $50,000 per incident with an aggregate, annual liability of $250,000. For the first three months of fiscal 1987, the City was fully -insured for workers' compensation. Subsequent to that time, however, the City's workers' compensation plan, which is administered by Texas Political Subdivisions, became self -insured. The Workers' Compensation Fund is funded by actuarially determined contributions from the operating funds of the City. The City has a stop -loss insurance policy that limits its liability per employee to $200,000 per incident. TOTAL COLUMNS ON COMBINED STATEMENT - OVERVIEW Total columns on the General Purpose Financial Statements are captioned "Memorandum Only" to indicate that they are presented only to facilitate financial analysis. Data in these columns does not present financial position, results of operations, or changes in financial position in conformity with generally accepted accounting principles. Neither is such data comparable to a consolidation. Interfund eliminations have not been made in the aggregation of this data. 2. CASH AND INVESTMENTS The City's demand deposits at June 30, 1987, were entirely covered by federal depository insurance or by pledged collateral held by the pledging financial institution's agent In the City'c name. Such total collateralization and insurancecoverage is required by state of Texas statutes. State statutes authorize the City to invest in fully -collateralized or fully -insured time deposits, direct debt securities of the United States, and fully collateralized repurchase agreements. The repurchase agreements must be purchased pursuant to a master repurchase agreement which specifies the rights and obligations of both parties and which requires that the securities - 42 - CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 2. CASH AND INVESTMENTS-(Cont'd) involved in the transaction be held in a safekeeping account subject to the control and custody of the City. Investments in security repurchase agreements may be made only with the City's depository bank or with state or national banks domiciled in the state of Texas. The City did not invest in any repurchase agreements during the year ended June 30, 1987. The City's investments at June 30, 1987, are shown below. All of the City's time deposits were entirely covered by federal depository insurance or collateralized by securities held by the pledging institution's agent in the City's name with the exception of investments totaling $23,000 which were neither insured or collateralized. Carrying Market Amount Value Included in Current Assets: Time Deposits $13,397,000 $13,397,000 Included in Restricted Assets: Time Deposits 13,975,001 13,975,001 Total $27,372,001 $27,372,001 3. PROPERTY TAXES Property is appraised and a lien on such property becomes enforceable as of January 1. Taxes are levied on and payable October 1. The Brazos County Tax Office bills and collects property taxes for the City. City property tax revenues are recognized when levied to the extent that they are collected in the current year. The balance is reported as deferred revenues. Taxes become delinquent February 1 of the following year and are subject to interest and penalty charges. The City is permitted by the state of Texas to levy taxes up to $2.50 per $100 of assessed valuation for general governmental services and for the payment of principal and interest on general long-term debt. The combined current tax rate to finance general government services including debt service for the year ended June 30, 1987, was $.38 per $100 of assessed valuation. - 43 - CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 3. PROPERTY TAXES-(Cont`d) The Brazos County Appraisal District ("Appraisal District") is responsible for the recording and appraisal of property for all taxing units in the County. The Appraisal District is required to assess property at 100% of its appraised value. Real property must be reappraised at least every four years. The City may, at its own 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 deter- mine whether to limit the tax rate to no more than 8% above the tax rate of the previous year. 4. NOTE RECEIVABLE During 1986, the City sold land valued at $943,894 to the Foundation (see Note 1). In exchange for this land, the City received a $3,000,000 noninterest-bearing promissory note to be repaid at face value in ten years or whenever the Foundation sells the land, whichever comes first. In addition, the Foundation has agreed to share profits with the City related to the eventual sale of the land by the Foundation and to comply with certain financial covenants and legal restrictions. 5. FIXED ASSETS A summary of changes in general fixed assets for the year ended June 30, 1987, are as follows: Land Buildings and Improvements Pavings, Sidewalks and Streets Machinery, Tools and Equipment Motor Vehicles Parks and Recreation Equipment Construction in Progress Total Additions Beginning and Balance Transfers In $ 4,343,128 $ 27,095 Retirements and Ending Tranfers Out Balance $ 4,370,223 7,419,429 1,033,039 8,452,468 6,743,375 4,431,207 11,174,582 5,114,481 472,396 $ (47,325) 5,539,552 1,524,692 103,009 (95,000) 1,532,701 3,806,024 1,449,150 (8,400) 5,246,774 5,504,464 3,703,834 (7,074,588) 2,133,710 $34,455,593 $11,219,730 $(7,225,313) $38,450,010 - 44 - CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 5. FIXED ASSETS-(Cont'd) A summary of proprietary fund type property and equipment of the enterprise funds at June 30, 1987, are as follows: Utility Sanitation Fund Fund Total Electric System $14,484,331 $14,484,331 Water System 25,831,465 25,831,465 Sewer System 16,406,088 16,406,088 Sanitation System Other Land Construction in Progress Total Less Accumulated Depreciation Net $1,642,292 1,642,292 45,935 45,935 1,542,601 55,190 1,597,791 3,194,469 3,194,469 61,504,889 1,697,482 63,202,371 10 ,245 ,268 1 ,204 ,096 11,449 ,364 $51,259,621 $ 493,386 $51,753,007 6. LONG-TERM DEBT The following is a summary of long-term debt transactions for the year ended June 30, 1987: Beginning Incurred/ Ending Balance Issued Matured Balance Governmental Fund Types General Obligation Bonds $19,907,500 $1,496,500 $18,411,000 Certificates of Obligation 2,166,426 188,939 1,977,487 Accrued Vacation Leave 342,333 $496,115 350,891 487,557 Subtotal 22,416,259 496,115 2 ,036 ,330 20 , 876 ,044 Proprietary Fund Tye Utility Revenue Bonds 31,925,000 2,490,000 29,435,000 General Obligation Bonds Serviced by Utility Revenues 4,217,500 368,500 3,849,000 Certificates of Obligation Serviced by Utility Revenues 511,038 54,606 456,432 Accrued Vacation Leave: Utility Fund 71,110 90,989 79,105 82,994 Sanitation Fund 18,286 27,747 27,268 18,765 Obligations under Capital Lease -(note 13) 4,360,553 262,247 4,098,306 Subtotal 41,103,487 118,736 3,281,726 37,940,497 Total Long -Term Debt $63,519,746 $614,851 $5,318,056 $58,816,541 - 45 - CITY OF COLLEGE STATION, TEXAS NOTES TO GENEkAL PURPOSE FINANCIAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 6. LONG-TERM DEBT-(Cont'd) Long-term debt at June 30, 1987, consisted primarily of bonds maturing serially and is summarized as follows: General Obligation Bonds: 1968 Issue 1971 Issue 1976 Issue 1978 I Issue 1978 II Issue 1981 Issue 1982 I Issue 1982 II Issue 1984 Issue Subtotal Certificates of Obligation: High -Tech Park Community Center Ladder Truck C of C Building Subtotal Utility Revenue Bonds - 1985 Refunding Issue General Obligation Bonds Serviced by Utility Revenues: 1976 Issue 19781 Issue Subtotal Certificates of Obligation Serviced by Utility Revenues: Sewage Treatment Plant Utility Service Center Subtotal Total Interest Series Principal Rates M Matures Balance 4.40- 6.00 1995 $ 365,000 4.70- 7.00 1991 100,000 4.00- 6.00 1997 750,000 4.70- 6.00 1998 351,000 5.15- 5.80 1999 1,820,000 8.7 5 -10.7 5 1991 600,000 9.75-11.75 1992 1,375,000 9 .00-11 .00 2000 5 ,400 ,000 9.00-11.00 2004 7,650,000 18 ,411 ,000 12.00 1989 1,182,634 11.00 1992 200,000 60% of Prime 1994 317,638 57.5% of Prime 1993 277,215 1,977,487 6.00- 9.50 2001 29 ,435 ,000 4.00- 6.00 1997 2,250,000 4.70- 6.00 1998 1 ,599 ,000 3,849,000 - 46 - 9.25 12.00 1992 1999 142,032 314,400 456,432 $54,128,919 CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCTAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 6. LONG-TERM[ DEBT-(Cont'd) Debt service requirements to maturity for all bonds are summarized as follows: General Certificates Obligation Bonds of Obligation Year Principal Interest Principal Interest 1988 $ 1,496,500 $ 1,670,306 $ 159,215 $209,428 1989 1,501,500 1,529,944 1,285,078 194,538 1990 1,501,500 1,388,657 141,364 44,836 1991 1,501,500 1,252,452 149,107 32,693 1992 1,426,500 1,115,545 157,441 19,959 1993-1997 6,052,500 3,883,332 85,282 6,754 1998-2002 4,031,000 1,369,695 2003-2004 900,000 121,500 Total $18,411,000 $12,331,431 $1,977,487 $508,208 General Obligation Utility Bonds Serviced by Revenue Bonds Utility Revenues Year Principal Interest Principal Interest 1988 $ 2,605,000 $ 2,491,158 $ 368,500 $ 195,422 1989 2,545,000 2,308,808 368,500 175,177 1990 2,465,000 2,117,932 368,500 156,058 1991 2,415,000 1,926,895 368,500 137,501 1992 2,375,000 1,733,695 368,500 118,463 1993-1997 11,085,000 5,743,622 1,842,500 303,875 1998-2001 5,945,000 1,242,563 164,000 8,200 Total $29,435,000 $17,564,673 $3,849,000 $1,094,696 Certificates of Obligation Serviced by Utility Revenues Year Principal Interest 1988 $ 54,606 $ 50,866 1989 54,606 45,094 1990 54,606 39,323 1991 54 ,606 33,551 1992 54,608 27,780 1993-1997 131,000 78,600 1998-1999 52,400 9,432 Total $456 ,432 $284 ,646 - 47 - 6. CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 LONG-TERM DEBT-(Cont'd) All the net revenues of the Utility Fund are pledged for the payment of debt service of the revenue bonds and other indebtedness payable from those revenues. Net revenues, as defined by the revenue bond resolution, include substantially all of the revenues and expenses of the Utility Fund other than certain interest income and expense and depreciation and amortization. This bond resolution further requires that the net revenues, as defined, equal at least 1.40 times the average annual debt service on all revenue 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. During fiscal 1985, the City refinanced its revenue refunding bonds totaling $39,610,000 with a $34,185,000 refunding bond issue. The proceeds of the refunding bond issue were used to acquire government securities to be placed in an escrow account held by a trustee. The securities and related investment earnings will provide sufficient funds to meet all debt service requirements of the refunded debt of which $32,965,000 was outstanding at June 30, 1987. These assets are administered by the trustees and are restricted for the retirement of the refunded debt. Accordingly, neither the assets held by the trustee nor the liability for the refunded bonds are reflected in the City's financial statements. All Utility Revenue Bonds were refunded and are payable from escrow accounts. In July, 1987, City Council approved a measure to refund the callable maturities of certain series of General Obligation Bonds and Certificates of Obligation. Details of the debt refunding are as follows: Debt Series General Obligation Bonds: 1981 Issue 1982 I Issue 1982 II Issue 1984 Issue Subtotal - 48 - Maturities Principal Refunded Refunded 1989-1991 $ 450,000 1989-1992 1,100,000 1994-2000 3,325,000 1996-2004 4 ,050 ,000 8,925,000 CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FTNANCIAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 6. LONG-TERM DEBT-(Cont'd) Maturities Principal Debt Series Refunded Refunded Certificates of Obligation: Sewage Treatment Plant 1989-1991 85,219 Community Center 1988-1991 160,000 Subtotal 245,219 Total Refunded $9,170,219 The City has issued $10,445,000 of General Obligation bonds to effect the transaction. The proceeds of the refunding bond issue were used to acquire government securities to be placed in an escrow account held by a trustee. The securities and related investment earnings will provide sufficient funds to meet all debt service requirements and the call provisions of the refunded debt. The City estimates that savings of approximately $400,000 will be realized over the life of the refunding issue. 7. BONDS AVAILABLE FOR SALE Authorized general obligation bonds available for future issue are as follows: Street improvements Maintenance and storage buildings Drainage improvements Civic center Total Year Authorized 1984 1984 1984 1976 Unissued Amount $2,800,000 9 25 ,000 1,230,000 500,000 *5,455,000 Revenue bonds, authorized in fiscal year 1984, remain unissued in the amount of $5,000,000 and are available for future use. 8. CONTRACT WITH GULF STATES UTILITIES The City purchases substantially all of its electrical power requirements from Gulf States Utilities ("Gulf States"). This contract requires the City's monthly minimum load to be not less than 15 kilowatts nor less than 60% of the City's greatest maximum load (experienced during the previous 12 months) adjusted for Gulf States power factor. The City's monthly Gulf States bill averages $1,274,000. - 49 - CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 9. RETIRE? ' PLAN The City provides pension benefits for all of its full-time employees through a joint contributory, defined contribution plan in the state-wide Texas Municipal Retirement System ("TMRS"), an agent multiple -employer public employee retirement system. Plan members can retire at ages 60 and above with 10 or more years of service or at ages 50-59 with 25 or more years of service or with 28 years of service regardless of age. A member is vested after 10 years, but he must leave his accumulated contributions in the plan. The contribution rate for the employees is 5%, and the City's matching percent is currently 200%, both as adopted by the governing body of the City. Under the state law governing TMRS, the City's contribution rate is annually determined by the actuary. Currently, the unfunded actuarial liability is being amortized over a 25-year period. The City's total payroll in fiscal year 1987 was $10,609,514, and the City's contributions were based on a payroll of $10,048,119. Both the City and the covered employees made the required contributions, amounting to $506,472 (4.95% of covered payroll for the months in calendar year 1986 and 5.08% for the months in calendar year 1987) for the City and $502,406 (5%) for the employees. Also, the City contributed .03% and .02% of the earnings of eligible employees during calendar years 1986 and 1987, respectively, to provide supplemental disability benefits. The City adopted changes in the plan since the previous actuarial valuation, which had the effect of increasing the City's contribution rate for 1987 by .01% of payroll. There were no related party transactions, and the City has no further liability to employees or TMRS under the plan. In addition to providing pension benefits, the City provides certain health care benefits for retired employees. Substantially all employees may become eligible for such benefits if they reach normal retirement age while working for the City. The health care benefits are provided through a self-insurance plan administered by Employee Benefit Management, Inc. (see note 1). During fiscal 1987, four retirees were eligible under this plan; however, claims filed by these retirees were not material. - 50 - CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL, PURPOSE FINANCTAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 10. SEGMENT INFORMATION OF ENTERPRISE FUNDS The City maintains two enterprise funds. Segment information for the year ended June 30, 1987, is as follows (amounts in thousands): Utility Sanitation Fund Fund Total Operating revenues: Electrical system $26,903 $26,903 Water system 3,114 3,114 Sewer system 2,326 2,326 Sanitation system $1,453 1,453 Other 417 417 Depreciation 1,579 103 1,682 Operating income (loss) before operating transfers 6,583 (127) 6,456 Operating transfers, net (4,303) (4,303) Net income 2,280 (127) 2,153 Property and equipment: Additions $ 5,127 $ 179 $ 5,306 Retirements 149 30 179 Net working capital 6,676 666 7,342 Total assets 78,482 1,239 79,721 Bonds and other long-term liabilities e excluding current portion 34,607 19 34,626 Total equity 33,448 1,140 34,588 — 51 — CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 11. INTERFUND BALANCES Individual fund interfund receivable and payable balances at June 30, 1987, were: Interfund Interfund Receivables Payables General Fund $1,769,200 $ 444,260 Special Revenue Fund: Revenue Sharing 27,735 Hotel/Motel Tax 220 37,381 Community Development 10 133,470 Debt Service Fund 10,950 Capital Projects Fund: 1982 II Bond 4,110 1984 Bond 4,110 560 Enterprise Fund: Utility 120,372 2,017,752 Sanitation 224,537 62,814 Internal Service Fund: Employee Benefits 5573,403 Workers' Compensation 41,670 Fiduciary Fund: Cemetery - Perpetual Care 810 Firemen's Relief and Retirement 1,200 Total $2,729,282 $2,729,282 12. OPERATING TRANSFERS Individual fund operating transfers in and operating transfers out for fiscal 1987 were as follows: Operating Operating Transfers In Transfers Out General Fund $4,828,340 Special Revenue Fund: Revenue Sharing Hotel/Motel Tax Debt Service Fund Capital Projects Fund: 1978 Bond 1978 II Bond 1981 Bond 1982 Bond 1982 11 Bond 1984 Bond Utility Fund Total 131,400 193,564 176,173 $5,329,477 $ 525,686 131,400 6,533 13 176,173 187,018 4,302,654 $5 ,329 ,477 - 52 - CITY OF COLLEGE STATION, TEXAS NOTES TO GENERAL PURPOSE FINANCIAL. STATEMENTS FOR THE YEAR ENDED JUNE 30, 1987 13. COMMITMENTS AND CONTINGENCIES As of June 30, 1987, the City had contractual commitments of approximately $2,208,809 for construction of various utility fund projects. Funding of these future expenditures is expected to be received from utility revenue bond proceeds. In fiscal 1984, the City advanced $552,807 to the Trinity River Authority ("TRA") for a feasibility study on a hydroelectric project. Repayment of this amount is contingent on TRA's building the hydroelectric plant. If, at a future date, TRA completes the project, the City will recognize revenues for the amount of all sums advanced since these payments are currently accounted for as expenses. Minimum future lease payments and present value of the net minimum lease payments for capital leases for waterwell facilities are as follows: Year Ending June 30, Total 1988 $ 592,999 1989 592,999 1990 592,999 1991 592,999 1992 592,999 1993-1997 2,066,757 1998-2001 824,896 Total minimum lease payments 5,856,648 Less imputed interest 1 ,758 ,342 Present value of net minimum lease payments $4,098,306 14. RESERVATIONS OF FUND BALANCES Fund balances have been reserved at June 30, 1987, as follows: General Fund: Reserved for encumbrances $ 23,182 Reserved for prepaid costs 124,693 Reserved for inventories 90,065 237,940 Debt Service — reserved for debt service 2,560,656 Capital Projects — reserved for encumbrances 190,402 Trust Funds: Reserved for fireman's relief and retirement 877 Reserved for cemetery perpetual care 54,648 55,525 Total $3 ,044 ,523 — 53 — S U P P L E M E N T A L F I N A N C I A L I N F O R M A T I O N - 54 - (This page intentionally left blank.) - 55 - GENERAL FUND To account for all financial resources traditionally associated with government which are not required to be accounted for in another fund. - 56 - CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF REVENUES AND OTHER FINANCING SOURCES - BUDGET AND ACTUAL (NON-GAAP BASIS) FOR THE YEAR ENDED JUNE 30, 1987 Variance Favorable Budget Actual (Unfavorable) TAXES: Current tax revenues $ 205,551 $ 209,997 $ 4,446 Delinquent ad valorem 3,000 8,303 5,303 Tax penalty and interest 1,000 4,526 3,526 Franchise 291,000 299,973 8,973 Mixed drinks 88,000 60,405 (27,595) Sales 2,926,427 2,956,235 29,808 Total taxes 3,514,978 3,539,439 24,461 PERMITS: Builder 55,000 47,983 (7,017) Electrical 10,000 8,802 (1,198) Plumbing 10,000 19,614 9,614 Mixed drink 9,000 12,998 3,998 Health 11,000 928 (10,072) Other 120 120 Total permits 95,000 90,445 (4,555) FINES: Municipal court 500,000 397,930 (102,070) Accident coding 338 338 Warrant services fees 33,000 20,939 (12,061) Other 10,000 23,201 13,201 Total fines 543,000 442.408 (100,592) CITY SERVICES PROVIDED: Ambulance service 70,000 64,820 (5,180) Adamson Pool 48,500 52,329 3,829 Thomas Pool 37,000 32,288 (4,712) Sports program 68,300 75,803 7,503 Other recreational 21,500 73,223 51,723 Total city services provided 245,300 298.463 53,163 GRANTS 20,000 36,869 16,869 INTEREST INCOME 60,000 58,323 (1,677) (Continued) - 57 - CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF REVENUES AND OTHER FINANCING SOURCES - BUDGET AND ACTUAL (NON-GAAP BASIS) (Continued) FOR THE YEAR ENDED JUNE 30, 1987 OTHER: Licenses Fees and certificates Paving assessments Sale of cemetery plots and other property Rentals Contributions Other revenues Total other TOTAL REVENUES OTHER FINANCING SOURCES: From utility fund From revenue sharing fund Total other financing sources TOTAL GENERAL FUND REVENUES AND OTHER FINANCING SOURCES - 58 - i i Variance Favorable Budget Actual (Unfavorable) $ 4,750 $ 4,143 $ (607) 10,500 8,151 (2,349) 20,000 8,495 (11,505) 20,000 30,925 10,925 16,000 16,483 483 101,700 81,011 (20,689) 172,950 149,208 (23,742) 4,651,228 4,615,155 (36,073) 4,302,654 4,302,654 525,686 525,686 4,828,340 4,828,340 $9,479,568 $9,443,495 $ (36,073) CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES COMPARED WITH BUDGET (NON-GAAP BASIS) FOR THE YEAR ENDED JUNE 30, 1987 ADMINISTRATION: Administration and City Manager: Salaries and benefits Supplies Equipment maintenance Services Sundry Capital outlay - equipment Capital outlay - motor vehicles Total administration and city manager Personnel: Salaries and benefits Supplies Equipment maintenance Services Sundry Capital outlay - equipment Total personnel Legal: Salaries and benefits Supplies Equipment maintenance Services Sundry Capital outlay - equipment Total legal Energy: Salaries and benefits Supplies Equipment maintenance Services Sundry Capital outlay - equipment Total energy - 59 - Variance Favorable Budget Actual (Unfavorable) $ 263,626 $ 255,295 $ 8,331 11,479 11,408 71 2,126 1,423 703 146,494 141,652 4,842 33,418 21,638 11,780 5,970 5,322 648 8,500 8,500 471,613 445,238 26,375 110,839 104,711 6,128 3,351 2,161 1,190 651 650 1 17,505 15,430 2,075 2,989 627 2,362 3,840 3,836 4 139,175 127,415 11,760 155,373 149,815 5,558 7,890 6,639 1,251 1,700 1,291 409 76,608 25,482 51,126 5,010 1,257 3,753 325 325 246,906 184,809 62,097 45,200 43,206 1,994 7,966 4,572 3,394 709 262 447 9,085 7,129 1,956 1,980 1,248 732 1,252 1,144 108 66,192 57,561 8,631 (Continued) CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES COMPARED WITH BUDGET (NON-GAAP BASIS) (Continued) FOR THE YEAR ENDED JUNE 30, 1987 Community Center: Salaries and benefits Supplies Building maintenance Equipment maintenance Services Sundry Capital outlay - equipment Total community center Printing/Mail: Salaries and benefits Supplies Equipment maintenance Services Sundry Capital outlay - equipment Total printing/mail Library: Salaries and benefits Supplies Building maintenance Services Sundry Capital outlay - equipment Total library TOTAL ADMINISTRATION FINANCE: : Fiscal Administration: Salaries and benefits Supplies Equipment maintenance Services Sundry Capital outlay - equipment Total fiscal administration Variance Favorable Budget Actual (Unfavorable) $ 84,496 $ 80,821 $ 3,675 8,490 6,550 1,940 3,975 3,623 352 2,321 2,278 43 46,508 41,038 5,470 2,870 2,415 455 1,267 1,267 149,927 137,992 11,935 66,139 64,056 2,083 2,205 10619 586 3,634 2,858 776 8,077 7,091 986 997 695 302 800 564 236 81,852 76,883 4,969 867 862 5 180 180 135,759 132,919 2,840 1,112 376 736 39,507 39,504 3 177,425 173,841 3,584 1,333,090 1,203,739 129,351 93,547 91,141 2,406 1,525 960 565 358 181 177 23,046 15,809 7,237 2,974 1,126 1,848 1,627 1,627 123,077 110,844 12,233 (Continued) CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES COMPARED WITH BUDGET (NON-GAAP BASIS) (Continued) FOR THE YEAR ENDED JUNE 30, 1987 Variance Favorable Budget Actual (Unfavorable) Accounting: • Salaries and benefits $ 162,407 $ 159,741 $ 2,666 Supplies 6,200 4,944 1,256 Building maintenance 63 63 Equipment maintenance 764 595 169 Services 89,989 84,408 5,581 Sundry 1,232 604 628 Capital outlay - equipment 748 748 Total accounting 261,403 251,103 10,300 Tax: Salaries and benefits 102,762 98,666 4,096 Supplies 3,750 2,600 1,150 Equipment maintenance 1,032 1,022 10 Services 96,438 85,554 10,884 Sundry 2,293 1,595 698 Total tax 206,275 189,437 16,838 Utilities: Salaries and benefits 474,444 450,245 24,199 Supplies 50,639 46,087 4,552 Equipment maintenance 9,189 8,502 687 Services 39,191 36,761 2,430 Sundry 4,133 2,333 1,800 Capital outlay - equipment 7,156 6,029 1,127 Total utilities 584,752 549,957 34,795 Purchasing: Salaries and benefits 88,385 86,471 1,914 Supplies 2,576 1,769 807 Equipment maintenance 1,049 855 194 Services 13,538 11,755 1,783 Sundry 3,214 2,115 1,099 Total purchasing 108,762 102,965 5,797 (Continued) - 61 - CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES COMPARED WITH BUDGET (NON-GAAP BASIS) (Continued) FOR THE YEAR ENDED JUNE 30, 1987 Warehouse: Salaries and benefits Supplies Building maintenance Equipment maintenance Services Sundry Total warehouse Data Processing: Salaries and benefits Supplies Equipment maintenance Services Sundry Capital outlay - equipment Total data processing Meter Services: Salaries and benefits Supplies Equipment maintenance Services Sundry Capital outlay - equipment Total meter services TOTAL FINANCE PUBLIC SERVICE: Administration: Salaries and benefits Supplies Equipment maintenance Services Sundry Capital outlay - equipment Total administration Budget Actual $ 24,821 $ 22,798 845 621 263 262 426 178 5,300 3,389 135 54 31,790 27,302 - 62 - 97,155 11,165 38,150 8,730 927 233 156,360 151,633 10,431 3,869 3,111 3,806 169 173,019 1 ,645 ,438 133,057 3,285 2,145 10,785 3,210 799 153,281 92,173 6,706 33,957 7,070 344 233 140,483 144,396 5,545 2,413 2,891 2,501 169 157,915 1 ,530 ,006 132,518 2,052 1,360 9,635 1,261 574 147,400 Variance Favorable (Unfavorable) $ 2,023 224 1 248 1,911 81 4,488 4,982 4,459 4,193 1,660 583 15,877 7,237 4 ,886 1,456 220 1,305 15,104 115,432 539 1,233 785 1,150 1,949 225 5,881 (Continued) CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES COMPARED WITH BUDGET (NON-GAAP BASIS) (Continued) FOR THE YEAR ENDED JUNE 30, 1987 Variance Favorable Budget Actual (Unfavorable) Streets: Salaries and benefits $ 488,139 $ 428,613 $ 59,526 Supplies 45,010 26,029 18,981 Building maintenance 247,008 160,034 86,974 Equipment maintenance 49,634 44,898 4,736 Services 5,118 395 4,723 Sundry 19,736 15,490 4,246 Capital outlay - equipment 6,450 3,366 3,084 Capital outlay - motor vehicles 11,992 11,992 Total streets 873,087 690,817 182,270 Garage: Salaries and benefits 238,974 224,813 14,161 Supplies 35,656 34,633 1,023 Building maintenance 2,000 875 1,125 Equipment maintenance 4,189 2,769 1,420 Services 6,520 2,631 3,889 Sundry 3,402 2,242 1,160 Capital outlay - equipment 1,406 1,401 5 Total garage 292,147 269,364 22,783 Cemetery and Ground Maintenance: Salaries and benefits 93,345 92,605 740 Supplies 4,509 2,638 1,871 Equipment maintenance 2,000 1,240 760 Sundry 1,541 1,071 470 Capital outlay - equipment 4,250 3,976 274 Total cemetery and ground maintenance 105,645 101,530 4,115 TOTAL PUBLIC SERVICE 1,424,160 1,209,111 215,049 (Continued) - 63 - CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES COMPARED WITH BUDGET (NON-GAAP BASIS) (Continued) FOR THE YEAR ENDED JUNE 30, 1987 Variance Favorable Budget Actual (Unfavorable) POLICE: Police Administration: Salaries and benefits $ 292,896 $ 291,620 $ 1,276 Supplies 12,182 11,233 949 Equipment maintenance 2,596 1,504 1,092 Services 36,109 35,759 350 Sundry 4,861 4,794 67 Capital outlay - equipment 1,055 1,000 55 Total police administration 349,699 345,910 3,789 Uniformed Bureau: Salaries and benefits 1,192,025 1,190,055 1,970 Supplies 75,237 74,122 1,115 Equipment maintenance 26,860 25,141 1,719 Services 14,677 13,167 1,510 Sundry 32,044 24,480 7,564 Capital outlay - buildings 124 123 1 Capital outlay - equipment 6,925 6,211 714 Capital outlay - motor vehicles 13,282 13,282 Total uniformed bureau 1,361,174 1,346,581 14,593 Investigation: Salaries and benefits 293,037 291,928 1,109 Supplies 15,965 12,721 3,244 Equipment maintenance 7,440 3,076 4,364 Services 12,043 5,969 6,074 Sundry 11,837 7 ,409 4,428 Capital outlay - equipment 6,057 4,834 1,223 Capital outlay - motor vehicles 55,140 54,200 940 Total investigation 401,519 380,137 21,382 Special Services Bureau: Salaries and benefits 189,052 185,481 3,571 Supplies 15,016 9,404 5,612 Equipment maintenance 4,010 2,715 1,295 Services 52,928 46,641 6,287 Sundry 7,274 6,544 730 Capital outlay - equipment 1,070 819 251 Total special services bureau 269,350 251,604 17,746 (Continued) - 64 - � I CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES COMPARED WITH BUDGET (NON-GAAP BASIS) (Continued) FOR THE YEAR ENDED JUNE 30, 1987 Variance Favorable Budget Actual (Unfavorable) Municipal Court: Salaries and benefits $ 103,177 $ 101,392 $ 1,785 Supplies 8,005 6,331 1,674 Building maintenance 566 536 30 Equipment maintenance 4,543 4,543 Services 63,112 56,173 6,939 Sundry 1,944 715 1,229 Capital outlay - equipment 9,629 4,237 5,392 Total municipal court 190,976 173,927 17,049 Records: Salaries and benefits 131,470 128,054 3,416 Supplies 12,945 7,254 5,691 Equipment maintenance 30,817 24,680 6,137 Services 18,432 17,498 934 Sundry 3,567 2,567 1,000 Capital outlay - equipment 28,616 26,253 2,363 Total records 225,847 206,306 19,541 Communications and Jails: Salaries and benefits 351,349 346,481 4,868 Supplies 9,300 6,972 2,328 Building maintenance 1,800 1,665 135 Equipment maintenance 8,082 6,508 1,574 Services 61,421 61,241 180 Sundry 7,316 5,780 1,536 Capital outlay - equipment 650 125 525 Total communications and jails 439,918 428,772 11,146 TOTAL POLICE 3,238,483 3,133,237 105,246 FIRE: Fire Administration: Salaries and benefits 146,782 143,554 3,228 Supplies 3,003 1,700 1,303 Equipment maintenance 5,271 4,433 838 Services 22,514 18,230 4,284 Sundry 2,884 1,238 1,646 Capital outlay - equipment 4,723 3,801 922 Total fire administration 185,177 172,956 12,221 (Continued) - 65 - CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES COMPARED WITH BUDGET (NON-GAAP BASIS) (Continued) FOR THE YEAR ENDED JUNE 30, 1987 Variance Favorable Budget Actual (Unfavorable) Fire Operations: Salaries and benefits l,b03,186 $ 1,564,131 $ 39,055 Supplies 34,566 25,095 9,471 Building maintenance 5,200 3,436 1,764 Equipment maintenance 32,628 29,129 3,499 Services 56,593 48,910 7,683 Sundry 12,457 9,372 3,085 Capital outlay - buildings 1,140 1,130 10 Capital outlay - equipment 7,618 7,522 96 Total fire operations 1,753,388 1,688,725 64,663 Fire Prevention: Salaries and benefits 142,429 126,528 15,901 Supplies 11,374 10,228 1,146 Equipment maintenance 2,500 2,469 31 Services 4,888 4,713 175 Sundry 2,930 2,196 734 Capital outlay - equipment 1,000 990 10 Total fire prevention 165,121 147,124 17,997 Ambulance: Salaries and benefits 323,499 261,884 61,615 Supplies 19,636 14,053 5,583 Equipment maintenance 10,060 81455 1,605 Services 14,823 9,773 5,050 Sundry 11,807 11,800 7 Capital outlay - equipment 31,499 27,594 3,905 Total ambulance 411,324 333,559 77,765 TOTAL FIRE 2,515,010 2,342,.364 172,646 ENGINEERING: Engineering Administration: Salaries and benefits 117,109 114,104 3,005 Supplies 7,298 2,875 4,423 Equipment maintenance 1,542 1,257 285 Services 10,657 8,516 2,141 Sundry 2,568 772 1,796 Capital outlay - equipment 12,800 10,313 2,487 Total engineering administration 151,974 137,837 14,137 (Continued) 66 - CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES COMPARED WITH BUDGET (NON-GAAP BASIS) (Continued) FOR THE YEAR ENDED JUNE 30, 1987 Engineering: Salaries and benefits Supplies Building maintenance Equipment maintenance Services Sundry Capital outlay - equipment Total engineering Planning: Salaries and benefits Supplies Equipment maintenance Services Sundry Total planning Building Inspection: Salaries and benefits Supplies Building maintenance Equipment maintenance Services Sundry Capital outlay - equipment Total building inspection Community Development: Salaries and benefits Supplies Building maintenance Equipment maintenance Services Sundry Capital outlay - equipment Total community development TOTAL ENGINEERING Budget Actual Variance Favorable (Unfavorable) $ 360,821 $ 360,776 $ 45 10,916 9,376 1,540 28,869 28,868 1 8,280 8,161 119 34,246 20,150 14,096 6,792 4,838 1,954 4,201 1,764 2,437 454,125 433,933 20,192 204,633 194,960 9,673 5,687 4,548 1,139 1,666 856 810 19,224 13,313 5,911 12,444 3,340 9,104 243.654 217,017 26,637 301,426 289,055 12,371 11,146 7,393 3,753 6,840 6,839 1 8,970 7,146 1,824 20,851 14,976 5,875 6,853 5,284 1,569 1,323 1,317 6 357,409 332,010 25,399 114,110 113,112 998 3,741 2,784 957 500 322 178 841 477 364 21,310 20,825 485 2,941 2,883 58 685 575 110 144,128 140,978 3,150 1,351,290 1,261,775 89,515 - 67 - (Continued) CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES COMPARED WITH BUDGET (NON-GAAP BASIS) (Continued) FOR THE YEAR ENDED JUNE 30, 1987 Variance Favorable Budget Actual (Unfavorable) PARKS: Parks Administration: $ 17, $ 171,0 $ 7 049 Salaries and benefits 5 ,79798 5,689 109 Supplies 740 730 10 Building maintenance 2,125 834 1,900 439 Equipment maintenance 33,25 32,00 225 Services 1,992 1,623 369 Sundry Capital outlay - buildings ,3 224,389 2,347 216,185 3 8,204 Total parks administration Recreation: 206,978 191,209 15,769 Salaries and benefits S 28,654 27,440 1,214 Supplies 1,700 1,079 621 Building maintenance 3,285 2,699 586 Equipment maintenance 99,203 95,062 4,141 Services 16,549 15,830 719 Sundry Capital outlay - buildings 5,535 5�535 Capital outlay - equipment 32,300 31,660 640 Concession operations 394,450 370,760 23,690 Total recreation Aquatics 223,010 211,935 11,075 Salaries and benefits S 29,770 29,766 4 Supplies 1, 1,,341 1 Building maintenance 5 41 4,95757 384 Equipment maintenance 69,010 68,992 18 Services 5,277 2,20Fi 3,071 Sundry 734 Capital outlay - equipment 343,252 328,699 99 14,553 Total aquatics Parks Maintenance: 408,595 403,946 4,649 Salaries and benefits 29,986 29,795 191 Supplies 29, 29, 3 Building maintenance 22,616 9 22,219 397 Equipment maintenance 53,532 46,046 7,486 Services 8,995 6,908 2,087 Sundry Capital outlay - equipment 5,911 559,592 5,909 544,777 2 14,815 Total parks maintenance (Continued) .: CITY OF COLLEGE STATION, TEXAS GENERAL FUND SCHEDULE OF EXPENDITURES COMPARED WITH BUDGET (NON-GAAP BASIS) (Continued) FOR THE YEAR ENDED JUNE 30, 1987 Variance Favorable Budget Actual (Unfavorable) Forestry: Salaries and benefits $ 101,288 $ 99,497 $ 1,791 Supplies 16,416 10,620 5,796 Building maintenance 1,000 706 294 Equipment maintenance 3,360 2,762 598 Services 2,601 2,502 99 Sundry 3,629 2,964 665 Capital outlay - equipment 1,955 1,737 218 Capital outlay - motor vehicles 15,830 15,035 795 Total forestry 146,079 135,823 10,256 Teen Center: Supplies 1,520 740 780 Building maintenance 600 598 2 Equipment maintenance 450 166 284 Services 21,038 201110 928 Sundry 167 142 25 Total teen center 23,775 21,756 2,019 TOTAL PARKS 1,691,537 1,618,000 73,537 NONDEPARTMENTAL: Contribution to community for the disabled Contribution to airport Contingency Contribution to Economic Development Foundation TOTAL NONDEPARTMENTAL Subtotal Less reimbursed administrative expenditures TOTAL EXPENDITURES 5,000 5,000 100,000 100,000 1,804 1,804 80,000 80,000 186,804 185,000 1,804 13,385,812 12,483,232 902,580 (3,357,306) (3,353,671) (3,635) $10,028,506 $ 9,129,561 $ 898,945 SPECIAL REVENUE FUNDS Crime Prevention - to account for the receipt and expenditure of funds received by the City from private donations that are designated for programs for juveniles. All activities are designed and implemented by the police department in an effort to deter crime. Community Development - to account for funds granted to the City by the National Department of Housing and Urban Development for use on various community improvement projects. Revenue Sharing - to account for the receipt and expenditure of funds received by the City under the Federal Revenue. Sharing Program. Hotel/Motel Tax - to account for the receipt and expenditure of funds received by the City from the assessment of hotel and motel occupancy tax. Usage of funds is restricted to construction and maintenance of convention and civic facilities, and promotion of tourism and arts within the City. - 70 - CITY OF COLLEGE STATION, TEXAS ALL SPECIAL REVENUE FUNDS COMBINING BALANCE SHEET JUNE 30, 1987 Hotel/ Crime Community Revenue Motel Prevention Development Sharing Tax ASSETS Cash on hand and in bank $1,212 Investments Receivables: Grants Accrued interest Other Less allowance for uncollectible accounts Due from other funds Prepaid costs TOTAL ASSETS $1,212 LIABILITIES AND FUND BALANCES LIABILITIES: Accounts payable Retainage payable Due to other funds Refundable deposits Total liabilities FUND BALANCES: Reserved for encumbrances Unreserved - undesignated $1,212 Total fund balances 1,212 TOTAL LIABILITIES AND FUND BALANCES $1,212 To tal $ 37,373 $ 63,063 $ 55,417 $157,065 25,000 50,000 75,000 325,802 325,802 180 1,185 1,365 14,164 14,164 (12,910) (12,910) 10 220 230 1,228 25 1,253 $365,667 $ 88,243 $106,847 $561,969 $ 5,376 $ 2,098 $ 10,274 $ 17,748 41,294 41,294 133,470 27,735 37,381 198,586 5,383 5,383 180,140 29,833 53,038 263,011 185,527 58,410 53,809 298,958 185,527 58,410 53,809 298,958 $365,667 $ 88,243 $106,847 $561,969 - 71 - CITY OF COLLEGE STATION, TEXAS ALL SPECIAL REVENUE FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES FOR THE YEAR ENDED JUNE 30, 1987 Hotel/ Crime Community Revenue Motel Prevention Development Sharing, Tax Total REVENUES: Taxes $ 481,252 $ 481,252 Grants $1,320,295 $ 112,959 1,433,254 Interest $ 72 5 20,496 9,996 30,569 Other 2,262 96,787 39,942 138,991 Total revenues 2,334 1,417,087 133,455 531,190 2,084,066 EXPENDITURES: Current: Reimbursed administrative expenditures 140,423 157,788 298,211 Housing rehabilitation 740,336 740,336 Other 1,937 62,910 51,147 397,305 513,299 Capital outlay 2,650 390,331 392,981 Total expenditures 4,587 1,334,000 51,147 555,093 1,944,827 Excess (deficiency) of revenues over expenditures (2,253) 83,087 82,308 (23,903) 139,239 OTHER FINANCING USES: Operating transfers out i (525,686) (131,400) (657,086) Excess (deficiency) of revenues over expenditures and other financing ! uses (2,253) 83,087 (443,378) (155,303) (517,847) j FUND BALANCES, ! JULY 1, 1986 I 3,465 102,440 501,788 209,112 816,805 i FUND BALANCES, JUNE 30, 1987 $ 1,212 $ 185,527 $ 58,410 $ 53,809 $ 298,958 - 72 - CITY OF COLLEGE STATION, TEXAS COMMUNITY DEVELOPMENT FUND STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE — BUDGET (GAAP BASIS) AND ACTUAL FOR THE YEAR ENDED JUNE 30, 1987 Variance Favorable Budget Actual (Unfavorable) REVENUES: Grants $ 852,000 $1,320,295 $468,295 Interest 5 5 Other 96,787 96,787 Total revenues 852,000 _ 1 ,417 ,087 565,087 EXPENDITURES: Current: Reimbursed administrative expenditures 160,000 140,423 19,577 Housing rehabilitation 697,001 740,336 (43,335) Other 410,111 62,910 347,201 Capital outlay 469,128 390,331 78,797 Total expenditures 1,736,240 1,334,000 402,240 Excess (deficiency) of revenues over expenditures (884,240) 83,087 967,327 FUND BALANCE, JULY 1, 1986 102,440 102,440 FUND BALANCE, JUNE 30, 1987 $ (781,800) $ 185,527 $967,327 — 73 — CITY OF COLLEGE STATION, TEXAS REVENUE SHARING FUND STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE — BUDGET (GAAP BASIS) AND ACTUAL FOR THE YEAR ENDED JUNE 30, 1987 Budget Actual REVENUES: Grants $ 100,000 $ 112,959 Interest 20,496 Total revenues 100,000 133,455 EXPENDITURES — Current — Other 52,049 51,147 Excess of revenues over expenditures 47,951 82,308 OTHER FINANCING USES — Operating transfers out (525,686) (525,686) Excess (deficiency) of revenues over expenditures and other uses (477,735) (443,378) FUND BALANCE, JULY 1, 1986 501,788 501,788 FUND BALANCE, JUNE 30, 1987 $ 24,053 $ 58,410 — 74 — Variance Favorable (Unfavorable) $ 12,959 20,496 33,455 902 34,357 34,357 $ 34,357 CITY OF COLLEGE STATION, TEXAS HOTEL/MOTEL TAX FUND STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE — BUDGET (GAAP BASIS) AND ACTUAL FOR THE YEAR ENDED JUNE 30, 1987 Variance Favorable Budget Actual (Unfavorable) REVENUES: Taxes Grants $ 540,000 $ 481,252 $ (58,748) Interest Other 9,996 9,996 Total revenues 43,500 39,942 (3,558) 583,500 531,190 (52,310) EXPENDITURES: Current: Reimbursed administrative expenditures 157,788 157,788 Other Total expenditures 428,425 397,305 31,120 586,213 555,093 31,120 Deficiency of revenues over expenditures (2,713) (23,903) (21,190) OTHER FINANCING USES — Operating transfers out (131,400) (131,400) Deficiency of revenues over expenditures and other financing uses (134,113) (155,303) (21,190) FUND BALANCE, JULY 1, 1986 209,112 209,112 FUND BALANCE, JUNE 30, 1987 $ 74,999 $ 53,809 $ (21,190) — 75 — CAPITAL PROJECT FUNDS 1978 Bond Funds - to account for the cost of street and park improvements, and construction of utility fixed assets to be made with proceeds of the 1978 issue. 1978 Series II Bond Funds - to account for the cost of street improvements; park improvements; and construction of police, fire, and warehouse buildings to be made with funds provided by proceeds of the 1978 Series II issue of general obligation bonds. 1981 Bond Funds - to account for the cost of street improvements, building con- struction, park improvements, and acquisition of park land to be made with funds provided by proceeds of the 1981 Series of general obligation bonds. 1982 Bond Funds - to account for the cost of street improvements, building purchase and construction, park improvements, and acquisition of park land to be made with funds provided by proceeds of the 1982 Series of general obligation bonds. 1982 Series II Bond Funds - to account for the cost of parks and street improvements, city hall and warehouse construction, and a traffic signalization project to be made with funds provided by proceeds of the 1982 Series II issue of general obligation bonds. 1984 Bond Funds - to account for the cost of street improvements, building con- struction, and park improvements to be made with funds provided by proceeds of the 1984 Series of general obligation bonds. - 76 - (This page intentionally left blank.) ® 77 -P CITY OF COLLEGE STATION, TEXAS ALL CAPITAL PROJECT FUNDS COMBINING BALANCE SHEET JUNE 30, 1987 ASSETS Cash on hand and in bank Investments Receivables: Accrued interest Other Less allowance for uncollectible accounts Due from other funds TOTAL ASSETS LIABILITIES AND FUND BALANCES LIABILITIES: Accounts payable Retainage payable Due to other funds Total liabilities FUND BALANCES: Reserved for encumbrances Unreserved - designated for: Parks projects Street projects General government Drainage projects Unreserved - undesignated Total fund balances TOTAL LIABILITIES AND FUND BALANCES 1982 1982 II 1984 Bond Bond Bond Total $ 181,238 $ 290,702 $ 465,665 $ 937,605 150,000 2,350,000 2,700,000 5,200,000 1,089 38,112 46,278 85,479 70,871 88,510 159,381 (73,299) (73,299) 4,110 4,110 $ 332,327 $2,749,685 $3,231,264 $ 6,313,276 $ 2,666 $ 1,025 3,691 10,000 238,001 54,483 26,152 328,636 80816 $ 19,381 $ 4,649 116,037 4,110 560 17 ,575 135,978 49,998 793,913 881,792 481,680 524,727 2,732,110 130,404 12,788 1,265,794 504,265 853,052 328,983 3 ,095 ,286 30,863 121,711 4,670 157,244 190,402 806,701 2,385,587 1,040,428 853,052 879,862 6,156,032 $ 332,327 $2,749,685 $3,231,264 $ 6,313,276 - 78 - CITY OF COLLEGE STATION, TEXAS ALL CAPITAL PROJECT FUNDS COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES JUNE 30, 1987 REVENUES: Interest Other Total revenues EXPENDITURES: Current: Reimbursed administrative expenditures Capital outlay Other Total expenditures Excess (deficiency) of revenues over expenditures OTHER FINANCING SOURCES (USES) — Operating transfers in (out) Excess (deficiency) of revenues over expenditures and other financing sources (uses) FUND BALANCES, JULY 1, 1986 FUND BALANCES, JUNE 30, 1987 — 79 — 1978 1978 II 1981 Bond Bond Bond $ 127 $ 13 $ 1,903 127 13 1,903 127 13 1,903 (6,533) (13) (176,173) (6,406) (174,270) 6,406 174,270 1982 1982 11 1984 Bond Bond Bond 33,453 $ 140,936 $ 270,379 59,482 33,453 200,418 270,379 Total $ 446,811 59,482 506,293 16,620 40,470 53,010 110,100 117,743 366,134 2,827,894 3,311,771 73,306 73,306 134,363 406,604 2,954,210 3,495,177 (100,910) (206,186) (2,683,831) (2,988,884) 193,564 (167,018) 176,173 92,654 (393,204) (2,507,658) (2,988,884) 235,982 3,125,314 5,602,944 9,144,916 $ 328,636 $2,732,110 $ 3,095,286 $ 6,156,032 (This page intentionally left blank.) - 81 - ENTERPRISE FUNDS Utility Fund - to account for revenues and expenses related to the operation and maintenance of the water, sewer and electric systems of the City. All activities necessary to provide such services are accounted for in this fund, including, but not limited to, administration, operations, maintenance, financing and related debt service, and billing and collection. Sanitation Fund - to account for all sanitation collection and disposal activities by the City to both residential and commercial residents, including the operation of the City's sanitary landfill. -82- i CITY OF COLLEGE STATION, TEXAS ALL ENTERPRISE FUNDS COMBINING BALANCE SHEET JUNE 30, 1987 ASSETS CURRENT ASSETS: Cash on hand and in bank Investments Receivable: Accounts Less allowance for uncollectible accounts Accrued interest Other Due from other funds Inventories Prepaid costs Total current assets RESTRICTED ASSETS: Cash in banks Investments Accrued interest receivable Total restricted assets PROPERTY AND EQUIPMENT: Less accumulated depreciation Property, net DEFERRED CHARGES TOTAL ASSETS Utility Sanitation Fund Fund Total $ 866,657 $ 11,134 $ 877,791 5,046,000 350,000 5,396,000 3,717,388 127,295 3,844,683 (343,445) (1,970) (345,415) 28,176 3,705 31,881 70,487 7,260 77,747 120,372 224,537 344,909 1,238,239 11,821 1,250,060 82,301 11,599 93,900 10,826,175 745,381 11,571,556 1,753,719 1,753,719 13,975,001 13,975,001 299,805 299,805 16,028,525 16,028,525 61,504,889 1,697,482 63,202,371 (10,245,268) (1,204,096) (11,449,364) 51,259,621 493,386 51,753,007 367,535 367,535 $ 78,481,856 $ 1,238,767 $ 79,720,623 LIABILITIES AND FUND EQUITY CURRENT LIABILITIES: Accounts payable Accrued liabilities Obligation under capital lease - current Due to other funds Total current liabilities PAYABLE FROM RESTRICTED ASSETS: Construction contracts and retainages payable Accrued interest payable Revenue bonds - current General obligation - current Certificates of obligation - current Customers' meter deposits Total liabilities payable from restricted assets LONG-TERM DEBT: Revenue bonds General obligation bonds Certificates of obligation Obligation under capital lease Total long-term debt ACCRUED VACATION LEAVE DEFERRED REVENUES TOTAL LIABILITIES FUND EQUITY: Contributed capital Retained earnings: Reserved for debt service Unreserved TOTAL FUND EQUITY TOTAL LIABILITIES AND FUND EQUITY - 84 - Utility Sanitation Fund Fund Total $ 1,701,867 $ 11,816 $ 1,713,683 143,670 5,142 148,812 286,186 286,186 2,017,752 62,814 2,080,566 4,149,475 79,772 4,229,247 454,309 454,309 1 ,031 ,062 1 ,031 ,062 2,605 ,000 2 ,605 ,000 368,500 368,500 54,606 54,606 1,679,492 1,679,492 6,192,969 6,192,969 26,830,000 26,830,000 3 ,480 ,500 3 ,480 ,500 401,826 401,826 3,812,120 3,812,120 34,524,446 34,524,446 82,994 18,765 101,759 84,189 84,189 45,034,073 98,537 45,132,610 10,187,278 54,901 10,242,179 2,746,188 2,746,188 20 ,514 ,317 1 ,085 ,329 21 ,599 ,646 33,447,783 1,140,230 34,588,013 $78,481,856 $1,238,767 $79,720,623 d CITY. -OF -COLLEGE STATION, TEXAS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND EQUITY s ALL ENTERPRISE FUNDS '. FOR THE YEAR ENDED JUNE 30, 1987 Utility Sanitation Fund Fund Total " OPERATING REVENUES: Electric $26,903,239 $26,903,239 Water 3,114,269 3,114,269 Sewer 2,326,181 2,326,181 Sanitation $1,453,392 1,453,392 Other 416,925 1 416,925 Total operating revenues 32,760 ,614 1 ,453 ,392 34 ,214 ,006 ' OPERATING EXPENSES: Purchased power 15,291,836 15,291,836 Salaries and benefits 2,271,445 754,150 3,025,595 Supplies 209,135 56,564 265,699 Building maintenance 354,467 81 354,548 Equipment maintenance 72,369 80,901 153,270 Services 1,861,892 29,753 1,891,645 Other 332,465 20,786 353,251 Administrative expenses from general fund 2,384,160 561,200 2,945,360 Depreciation: Electrical system 522,331 522,331 Water system 631,579 631,579 Sewer system 416,848 416,848 Sanitation system 103,038 103,038 Other 8,573 8,573 Total operating expenses 24,357,100 1,606,473 25,963,573 ' NET OPERATING INCOME (LOSS) 8,403,514 (153,081) 8,250,433 NONOPERATING REVENUES (EXPENSES) Interest earnings 1,349,992 28,478 1,378,470 Interest expense (3,185,429) (3,185,429) Other, net 14,986 (2,842) 12,144 Total nonoperating revenues (expenses) (1,820,451) 25,636 (1,794,815) Income (loss) before operating transfers 6,583,063 (127,445) 6,455,618 Operating transfer to general fund (4,302,654) (4,302,654) NET INCOME (LOSS) 2,280,409 (127,445) 2,152,964 TOTAL FUND EQUITY, DULY 1, 1986 31,167,374 1,267,675 32,435,049 TOTAL FUND EQUITY, JUNE 30, 1987 $33,447,783 $1,140,230 $34,588,013 85 CITY OF COLLEGE STATION, TEXAS COMBINING STATEMENT OF CHANGES IN FINANCIAL POSITION - ALL ENTERPRISE FUNDS FOR THE YEAR ENDED JUNE 30, 1987 SOURCES OF WORKING CAPITAL: Operations: Net income (loss) Items not requiring working capital: Depreciation Amortization of deferred charges Working capital provided by operations Decrease in restricted assets Increase in payables from restricted assets Increase in accrued vacation leave Increase in deferred revenues Total sources of working capital USES OF WORKING CAPITAL: Additions of property and equipment Principal payments: Revenue bonds General obligation bonds Certificates of obligation Capital lease Other, net Total uses of working capital DECREASE IN WORKING CAPITAL INCREASE (DECREASE) IN WORKING CAPITAL: Cash on hand and in bank Investments Receivables Due from other funds Inventories Prepaid costs Accounts payable Accrued liabilities Due to other funds Obligations under capital lease - current DECREASE IN WORKING CAPITAL Utility Sanitation Fund Fund Total $ 2,280,409 $(127,445) $ 2,152,964 1,579,331 103,038 1,682,369 32,411 32,411 3,892,151 (243,407) 3,867,744 3 ,614 ,485 3 ,614 ,485 45,041 45,041 11,884 479 12,363 62,932 62,932 7 ,626 ,493 (23,928) 7 ,602 ,565 5,126,938 179,464 5,306,402 2,490,000 2,490,000 368,500 368,500 54,606 54,606 262,247 262,247 32,834 32,834 8,335,125 179,464 8,514,589 $ (708,632) $(203,392) $ (912,024) $ (55,698) $ (56,363) $ (112,061) (447,000) (175,000) (622,000) (76,074) 276 (75,798) 50,599 48,836 99,435 260,949 (4,250) 256,699 55,994 6,077 62,071 225,470 (1,750) 223,720 106,704 4,058 110,762 (806,174) (25,276) (831,450) (23,402) (23,402) $ (708,632) $(203,392) $ (912,024) CITY OF COLLEGE STATION, TEXAS i1TTT.TTY FUND SCHEDULE OF REVENUES a BUDGET AND ACTUAL (NON-GAAP BASIS) FOR THE YEAR ENDED JUNE 30, 1987 Variance Favorable Budget Actual (Unfavorable) OPERATING REVENUES: Electric: Electric services $34,420,000 $26,922,043 $(7,497,957) Underground construction 50,000 27,656 (22,344) Pole rental 23,000 18,306 (4,694) Temporary service 10,000 5,425 (4,575) Sales tax collection fees 5,000 6,093 1,093 Security lights 1,950 1,950 Total electric 34,508,000 26,981,473 (7,526,527) Water: Water services 3,465,000 3,115,332 (349,668) Water taps 25,000 36,300 11,300 Total water 3,490,000 3,151,632 (338,368) Sewer: Sewer services 2,113,000 2,290,118 177,118 Sewer taps 25,000 20,363 (4,637) Total sewer 2,138,000 2,310,481 172,481 Nondepartmental: Penalties 320,000 332,193 12,193 Reconnect fees 22,000 19,250 (2,750) Service fees 60,000 68,404 8,404 Total nondepartmental 402,000 419,847 17,847 Total operating revenues 40,538,000 32,863,433 (7,674.567) NONOPERATING REVENUES: Other 43,000 89,447 46,447 Interest earnings 350,000 1 ,349 ,993 999,993 Total nonoperating revenues 393,000 1,439,440 1,046.440 TOTAL kEVENUES *40,931,000 $34,302,873 $(6,628,127) See reconciliation to GAAP basis on page 94. CITY OF COLLEGE STATION, TEXAS UTILITY FUND SCHEDULE OF EXPENSES - BUDGET AND ACTUAL (NON-GAAP BASIS) FOR THE YEAR ENDED JUNE 30, 1987 Variance Favorable Budget Actual (Unfavorable) ELECTRICAL TRANSMISSION: Supplies $ 900 $ 572 $ 328 Building maintenance 15,885 9,915 5,970 Equipment maintenance 1,008 267 741 Services 22,697,738 15,345,559 7,352,193 Sundry 79,219 35,239 43,980 Total operating - electrical transmission 22,794,750 15,391,552 7,403,198 Total electrical transmission 22,794,750 15,391,552 7,403,198 ELECTRICAL DISTRIBUTION: Salaries and benefits 936,344 834,192 102,152 Supplies 95,952 80,908 15,044 Building maintenance 128,743 110,169 18,574 Equipment maintenance 32,100 27,270 4,830 Services 361,613 329,115 32,498 Sundry 28,478 19,694 8,784 Total operating - electrical distribution 1,583,230 1,401,348 181,882 Capital outlay 281,512 232,708 48,804 Total electrical distribution 1,864,742 1,634,056 230,686 WATER PRODUCTION: Salaries and benefits 245,804 229,036 16,768 Supplies 36,040 26,248 9,792 Building maintenance 15,975 9,994 5,981 Equipment maintenance 30,616 14,654 15,962 Services 949,641 857,728 91,913 Sundry 11,883 6,820 5,063 Total operating - water production 1,289,959 1,144,480 145,479 Capital outlay 12,900 9,025 3,875 Total water production 1,302,859 1,153,505 149,354 WATER DISTRIBUTION: Salaries and benefits 332,086 278,327 53,759 Supplies 43,818 37,967 5,851 Building maintenance 95,710 92,470 3,240 Equipment maintenance 24,917 14,238 10,679 Services 306,002 304,769 1,233 Sundry 9,813 6,370 3,443 Total operating - water distribution 812,346 734,141 78,205 Capital outlay 18,362 15,876 2,486 Total water distribution 830,708 750,017 80,691 (Continued) - 88 - CITY OF COLLEGE -- ----- - STATION, TEXAS UTILITY FUND SCHEDULE OF EXPENSES - BUDGET AND ACTUAL (NON-GAAP BASIS) (Continued) FOR THE YEAR ENDED JUNE 30, 1987 Variance Favorable Budget Actual (Unfavorable) SEWER TREATMENT: . - Salaries and benefits $ 385,250 $ 364,424 $ 20,826 Supplies 50,259 48,525 1,734 Building maintenance 65,253 64,837 416 Equipment maintenance 8,047 5,823 2,224 Services 492,193 489,755 23,438 Sundry 7,508 4,678 2,830 Total operating - sewer treatment 1,008,510 978,042 30,468 Capital outlay 18,672 14,066 4,606 . Total sewer treatment 1,027,182 992,108 35,074 SEWER COLLECTION: Salaries and benefits 289,511 286,509 3,002 Supplies ` 21,725 10,781 10,944 Building maintenance 54,500 41,624 12,876 Equipment maintenance 13,330 7,408 5,922 Services 33,643 20,419 13,224 Sundry 9,768 7,516 2,252 Total operating - sewer collection 422,477 374,257 48,220 Capital outlay 36,000 30,046 5,954 Total sewer collection 458,477 404,303 54,174 WATER AND SEWER ADMINISTRATION: Salaries and benefits 180,805 180,039 766 Supplies 3,590 3,198 392 Equipment maintenance 1,671 650 1,021 Services 5,272 2,998 2,274 Sundry 859 531 328 Capital Outlay 475 456 19 Total water and sewer administration 192,672 187,872 4,800 UTILITIES ADMINISTRATION: Salaries and benefits 87,034 87,033 1 Supplies 1,700 1,333 367 Equipment maintenance 1,759 782 977 Services 36,468 33,994 2,474 Sundry 2,633 650 1,983 Total operating - utilities administration 129,594 123,792 5,802 Capital outlay 3,500 3,453 47 Total utilities administration 133,094 127,245 5,849 (Continued) CITY OF COLLEGE STATION, TEXAS UTILITY FUND SCHEDULE OF EXPENSES — BUDGET AND ACTUAL (NON—GAAP BASIS) (Continued) FOR THE YEAR ENDED JUNE 30, 1987 NONDEPARTMENTAL: Administration transfers to general fund Energy projects Contribution: superconductor Sundry Total operating — nondepartmental Transfer to debt service fund Revenue bond principal Revenue bond interest Transfer to general fund in lieu of taxes Contingency Total nondepartmental TOTAL EXPENSES See reconciliation to GAAP basis on page 94. Budget Actual $ 2,194,610 $ 2,194,260 261,760 229,004 20,000 20,000 7,079 7,078 2,483,449 2,450,342 695,410 695,410 2,490,000 2,490,000 2,653,010 2,653,008 4,302,654 4,302,654 251,757 12,876,280 12,591,414 $41 ,480 ,764 $33 ,232 ,072 Variance Favorable (Unfavorable) $ 350 32,756 1 33,107 2 251,757 284,866 $8 , 248 ,692 i CITY OF COLLEGE STATION, TEXAS SANITATION FUND SCHEDULE OF REVENUES — BUDGET AND ACTUAL (NON—GAAP BASIS) FOR THE YEAR ENDED JUNE 30, 1987 Variance Favorable Budget Actual (Unfavorable) OPERATING REVENUES: Commercial collection $ 370,000 $ 375,794 $ 5,794 Resiclential collection 860,000 870,625 10,625 Drainage 100,000 105,330 5,330 Landfill 85,000 99,067 14,067 Dumpster sales 267 267 Total operating revenues 1,415,000 1,451,083 36,083 NONOPERATING REVENUES: Interest earnings 28,478 28,478 Miscellaneous 5,158 5,158 Total nonoperating revenues 33,636 33,636 TOTAL REVENUES $1,415,000 $1,484,719 $ 69,719 See reconciliation to GAAP basis on page 94. — 91 — CITY OF COLLEGE STATION, TEXAS SANITATION FUND SCHEDULE OF EXPENSES - BUDGET AND ACTUAL (NON-GAAP BASIS) FOR THE YEAR ENDED JUNE 30, 1987 SANITATION COLLECTION (RESIDENTIAL): Salaries and benefits Supplies Equipment maintenance Services Sundry Total operating - sanitation collection (residential) Capital outlay Total sanitation collection (residential) SANITATION COLLECTION (COMMERCIAL): Salaries and benefits Supplies Equipment maintenance Services Sundry Total operating - sanitation collection (commercial) Total sanitation collection (commercial) SANITATION DISPOSAL: Salaries and benefits Supplies Building and grounds maintenance Equipment maintenance Services Sundry Total operating - sanitation disposal Capital outlay Total sanitation disposal DRAINAGE DEPARTMENT: Salaries and benefits Supplies Equipment maintenance Sundry Total operating - drainage department Total drainage department - 92 - Budget $ 518,511 38,726 50,004 3,104 9,482 619,827 183,990 803,817 136,507 14,628 15,168 318 2,899 169,520 169,520 108,357 18,013 6,500 28,435 26,922 4,012 192,239 190 192,429 72,655 17,000 7,000 2,939 99,594 99,594 Ac tual $ 453,589 21,683 44,193 3,067 7,659 530,191 179,297 709,488 136,424 9,220 8,072 257 2,613 156,586 156,586 106,087 17,976 81 26,576 26,430 3,866 181,016 167 181,183 57 ,571 7,685 2,059 1,797 69,112 69,112 Variance Favorable (Unfavorable) $ 64,922 17,043 5,811 37 1,823 89,636 4,693 94,329 83 5,408 7,096 61 286 12,934 12,934 2,270 37 6,419 1 ,859 492 146 11,223 23 11,246 15,084 9,315 4,941 1,142 30,482 30,482 (Continued) CITY OF COLLEGE STATION, TEXAS SANITATION FUND SCHEDULE OF EXPENSES - BUDGET AND ACTUAL (NON-GAAP BASIS) (Continued) FOR THE YEAR ENDED JUNE 30, 1987 NONDEPARTMENTAL: Contingency Transfer to general fund Contribution to Brazos Beautiful Total nondepartmental TOTAL See reconciliation to GAAP basis on page 94. Variance Favorable Budget Actual (Unfavorable) $ 23,439 $ 23,439 561,200 $ 561,200 8,000 8,000 592,639 569,200 23,439 $1,857,999 $1,685,569 $172,430 - 93 - CITY OF COLLEGE STATION, TEXAS UTILITY FUND AND SANITATION FUND SCHEDULE FOR RECONCILIATION OF REVENUES AND EXPENSES (NON-GAAP BASIS) TO GAAP BASIS STATEMENT OF INCOME FOR THE YEAR ENDED JUNE 30, 1987 Total revenues per budget - Actual Less total expenses per budget - Actual NET GAIN (LOSS), BUDGET BASIS ADD - Expenditures related to balance sheet: Capital outlay Transfer to debt service Bond principal payment ADD - Unbudgeted revenue adjustments: Current year revenue accrual DEDUCT - Unbudgeted expenses/revenue adjustments: Accrued vacation leave Depreciation Prior year revenue accrual Allowance for uncollectible accounts Other NET INCOME (LOSS), GAAP BASIS - 94 - Utility Fund $ 34,302,873 (33,232,072) 1,070,801 305,175 755,988 2 ,490 ,000 1,960,305 (11,884) (1,602,699) (2,029,133) (215,991) (389,707) $ 2 ,280 ,409 Sanitation Fund $ 1,484,719 0 685,569) 200 ,850 ) 179,464 (479) (103,038) (66,780) (4,851) $ (127,445) (This page intentionally left blank.) - 95 - INTERNAL SERVICE FUNDS Employee Benefits — to account for self—insurance activity relating to administration of the City's health benefits plan. Workers' Compensation — to account for self—insurance activity relating to administration of the City's workers' compensation plan. CITY OF COLLEGE STATION, TEXAS ALL INTERNAL SERVICE FUNDS COMBINING BALANCE SHEET JUNE 30, 1987 ASSETS Cash on hand and in bank Due from other funds Prepaid costs TOTAL ASSETS LIABILITIES AND FUND EQUITY LIABILITIES: Accrued liabilities Total liabilities FUND EQUITY — Unreserved retained earnings TOTAL LIABILITIES AND FUND EQUITY — 97 Employee Workers' Benefits Compensation Total $ 17,235 $ 77,554 $ 94,789 557,403 41,670 599,073 3,500 10,435 13,935 $578,138 $129,659 $707,797 $ 38,451 $ 11,841 $ 50,292 38,451 11,841 50,292 539,687 117,818 657,505 $578,138 $129,659 $707,797 CITY OF COLLEGE STATION, TEXAS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND EQUITY - ALL INTERNAL SERVICE FUNDS FOR THE YEAR ENDED JUNE 30, 1987 OPERATING REVENUES OPERATING EXPENSES: Claims Administration fee Premiums Other Total operating expenses NET OPERATING INCOME (LOSS) NONOPERATING REVENUES - Interest earnings NET INCOME (LOSS) TOTAL FUND EQUITY, JULY 1, 1986 TOTAL FUND EQUITY, JUNE 30, 1987 Employee Workers' Benefits Compensation $600,789 $165,381 546,822 39,949 41,741 628,512 (27,723) 962 (26,761) 566,448 $539,687 26,208 5,014 13,299 3,764 48,285 117,096 722 117,818 $117 ,818 Total $766,170 573,030 44,963 55,040 3,764 676,797 89,373 1,684 91,057 566,448 $657 ,505 CITY OF COLLEGE STATION, TEXAS COMBINING STATEMENT OF CHANGES TN FINANCIAL POSITION — ALL INTERNAL SERVICE FUNDS FOR THE YEAR ENDED JUNE 30, 1987 INCREASE (DECREASE) IN WORKING CAPITAL — Net income (loss) INCREASE (DECREASE) IN WORKING CAPITAL: Cash on hand and in bank Due from other funds Prepaid costs Accrued liabilities INCREASE (DECREASE) IN WORKING CAPITAL Employee Workers' Benefits Compensation $(26,761) 6,836 (16,225) (17 ,372 ) $(26,761) $117 ,818 77,554 41,670 10,435 (11,841) $117 ,818 Total $ 91,057 84,390 25,445 10,435 (29,213) $ 91,057 FIDUCIARY FUNDS Pension Trust Fund Fireman's Relief and Retirement - to account for the accumulation of resources to be used for retirement annuity payments at appropriate amounts and time. The fund does not account for the administrative costs of the System, which are borne by the general fund. Resources are contributed by employees at an annual fixed rate. The City has voluntarily contributed amounts as needed to maintain the solvency of the fund. The potential future liabilities related to these payments appear to be minimal due to the fact that it is estimated by the City that there are approximately 5 or less past employees who could become eligible for these $25 per month payments in the future. Expendable Trust Fund Cemetery Perpetual Care - to account for a portion of cemetery plot sales proceeds that are designated as a contribution to the perpetual care fund. Funds are to be expended for maintenance and care of the City's cemetery. - 100 - CITY OF COLLEGE STATION, TEXAS ALL FIDUCIARY FUNDS COMBINING BALANCE SHEET JUNE 30, 1987 Pension Trust Expendable Fund Trust Fund Firemen's Relief Cemetery and Perpetual ASSETS Retirement Care Total Cash on hand and in bank $1,061 $ 3,067 $ 4,128 Investments 1,000 50,000 51,000 Accrued interest receivable 16 771 787 Due from other funds 810 810 TOTAL ASSETS $2 ,077 $54,648 $56 ,725 LIABILITIES AND FUND BALANCES LIABILITIES - Due to other funds $1,200 $ 1,200 FUND BALANCES: Reserved for Firemen's Relief and Retirement 877 877 Reserved for cemetery perpetual care $54,648 54,648 Total fund balances 877 54,648 55,525 TOTAL LIABILITIES AND FUND BALANCES $2,077 $54,648 $56,725 - 101 - GENERAL FIXED ASSETS ACCOUNT GROUP To account for fixed assets not used in proprietary fund operations or accounted for in trust funds. - 102 - (This page intentionally left blank.) - 103 - CITY OF COLLEGE STATION, TEXAS GENERAL FIXED ASSETS ACCOUNT GROUP SCHEDULE OF GENERAL FIXED ASSETS - BY SOURCES JUNE 30, 1987 GENERAL FIXED ASSETS: Land Buildings and improvements Machinery, tools and equipment Motor vehicles Parks and recreation equipment Paving sidewalks and streets Construction in progress TOTAL GENERAL FIXED ASSETS INVESTMENT IN GENERAL FIXED ASSETS FROM: Capital projects funds: General obligation bonds Certificates of obligation General fund revenues Expendable trust fund revenues Special revenue fund revenues: Federal grants Other Acquisitions prior to July 1, 1979 - Source undetermined TOTAL INVESTMENT IN GENERAL FIXED ASSETS - 104 - $ 4,370,223 8,452,468 5,539,552 1,532,701 5,246,774 11,174,582 2,133,710 $38 ,450 ,010 $22 ,481,437 1,732,352 4,626,429 14,364 1,523,373 1 ,066 ,821 7,005,234 $38,450,010 CITY OF COLLEGE STATION, TEXAS GENERAL FIXED ASSET ACCOUNT GROUP ' SCHEDULE OF GENERAL FIXED ASSETS BY FUNCTION AND ACTIVITY JUNE 30, 1987 Building and Total Land Improvements GENERAL FUND: Administration $ 387,610 $ 17,239 Finance 319,802 10,654 Public service 1,209,399 28,168 Police 639,756 1,972 Fire 670,362 1,649 Engineering 313,342 9,036 Parks 526,407 104,270 Computer project 559,751 ` Total general fund 4,626,429 172,988 .. EXPENDABLE TRUST FUND - Cemetery perpetual care 14,364 14,364 SPECIAL REVENUE FUNDS: Federal grants 1,523,373 $ 13,082 182,497 Others 1 ,066 ,821 150,009 894,294 Total special revenue fund 2,590,194 163,091 1,076,791 CAPITAL PROJECTS FUNDS: Certificate of obligation funds 1,732,352 637,168 400,000 Southwest Parkway 642,231 1971 bond funds 172,838 1976 bond funds 126,377 1,495 1978 bond funds 533,706 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,682,481 376,607 1,233,304 1982 II bond funds 5,333,767 516,408 337,531 1984 bond funds 5,148,287 510,040 1,543,511 Total capital project funds 22,080,079 2,750,527 5,234,163 Acquisitions prior to July 1, 1979 - Source undetermined 7,005,234 1,456,605 1,954,162 Total general fixed assets allocated to functions 36,316,300 $4,370,223 $8,452,468 Construction in progress 2,133,710 TOTAL GENERAL FIXED ASSETS $38,450,010 - 105 - Machinery, Parks and Paving Tools and Motor Recreation Sidewalks ° Equipment Vehicles Equipment and Streets $ 274,799 $ 95,572 230,232 78,916 715,711 465,520 330,330 307,454 418,198 250,515 142,793 161,149 $ 364 237,681 164,580 $ 19,876 559,751 2 ,909 ,495 1 ,523 ,706 19,876 364 2,044 8,995 67,220 1,249,535 3,248 19,270 5,292 8,995 67,220 1,268,805 695,184 642,231 172,838 13,249 111,633 162,399 346,166 13,967 1,070,353 655,347 930 22,568 541,390 223,018 415,910 1,433,642 561,643 2,428,444 1,489,741 511,173 234,546 2,349,017 2,005,915 4,347,469 7,742,005 618,850 812,209 2,163,408 $5,539,552 $1,532,701 $5,246,774 $11,174,582 106 d CITY OF COLLEGE STATION, GENERAL FUND FIXED ASSET GROUP SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS •- BY FUNCTION AND ACTIVITY FOR THE YEAR ENDED JUNE 30, 1987 General General Fixed Fixed Function and Assets Assets Activity 7/1/86 Additions Retirements Transfers 6/30/87 GENERAL FUND: Administration $ 328,315 $ 59,295 $ 387,610 Finance 311,073 8,729 319,802 Public service 1,198,090 21,534 $ (10,225) 1,209,399 Police 570,048 157,319 (79,494) $ (8,117) 639,756 Fire 634,473 41,059 (5,170) 670,362 Engineering 300,738 22,304 (9,700) 313,342 Parks 450,557 113,869 (46,136) 8,117 526,407 Computer project 551,823 7,928 559,751 Total general fund 4,345,117 424,109 (150,725) 7,928 4,626,429 EXPENDABLE TRUST FUND - Cemetery perpetual care 14,364 14,364 SPECIAL REVENUE FUNDS: Federal grants 1,212,228 311,145 1,523,373 Other 1 ,063 ,986 2,835 1 ,066 ,821 Total special revenue funds 2,276,214 2,835 311,145 2,590,194 CAPITAL PROJECT FUNDS: Certificate of obligation funds 1,732,352 1,732,352 Southwest Parkway 642,231 642,231 1971 bond funds 172,838 172,838 1976 bond funds 126,377 126,377 1978 bond funds 533,706 533,706 1978 II bond funds 2,803,997 2,803,997 1981 bond funds 1,630,944 273,099 1,904,043 1982 bond funds 1,968,299 1,714,182 3,682,481 1982 II bond funds 2,914,194 2,419,573 5,333,767 1964 bond funds 2,799,626 2,348,661 5,148,287 Total capital project funds 15,324,564 6,755,515 22,080,079 (Continued) 107 - CITY OF COLLEGE STATION, TEXAS GENERAL FUND FIXED ASSET GROUP SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS — BY FUNCTION AND ACTIVITY (Continued) FOR THE YEAR ENDED JUNE 30, 1987 General General Fixed Fixed Function and Assets Assets Activity, 7/1/86 Additions Retirements Transfers 6/30 /87 Acquisitions prior to July 1, 1979 — Source undetermined $ 7,005,234 Construction in progress 5,504,464 $3,703,834 TOTAL GENERAL FIXED ASSETS $34,455,593 $4,145,142 $050,725) $ 7,005,234 $(7,074,588) 2,133,710 $38,450,010 (This page intentionally left blank.) - 109 - S T A T I S T I C A L S E C T I O N - 110 - CITY OF COLLEGE STATION, TEXAS GENERAL GOVERNMENTAL EXPENDITURES AND OTHER USES BY FUNCTION (6) LAST TEN FISCAL YEARS Fiscal General Year Government (2) Police (3) Fire (4) Sanitation (1) 1978 $ 568,390 $ 410,462 $ 371,046 $182,019 1979 883,323 524,288 425,628 200,488 1980 1,039,570 859,629 661,767 1981 1,319,826 1,090,295 967,410 .. 1982 2 ,132 ,476 1 ,491 ,374 1 ,350 ,053 1983 3,592,677 1,922,117 1,691,084 1984 3,200,862 2,089,176 1,842,618 1985 3,559,610 2,445,386 2,008,648 1986 3,948,780 2,711,271 2,224,796 1987 4,214,064 3,024,395 2,324,273 (1) In fiscal 1980, the Sanitation Fund was set up as an Enterprise Fund and is no longer supported by the General Fund. (2) The General Government column includes administration, finance, engineering, and nondepartmental categories. (3) The Police column includes municipal court. (4) The Fire column includes ambulance services. (5) The Public Service column includes streets, garage, cemetery, and ground maintenance. (6) Expenditures presented include the General and Debt Service Funds. 111 Public Reimbursed Capital Service Parks & Debt Administrative Outlay (5) Recreation Service Expenditures Total $220,575 $ 214,892 $ 386,226 $ 308,265 $ (591,108) $ 2,070,767 228,328 252,736 330,429 539,183 (975,266) 2,409,137 262,203 474,553 426,377 1,567,169 (628,795) 4,662,473 466,892 509,671 591,194 1,322,307 (849,678) 5,417,917 498,411 714,819 733,073 1,571,830 (1,277,255) 7,214,781 549,230 819,417 979,019 2,417,748 (1,532,333) 10,438,959 762,368 966,407 1,159,758 3,493,647 (2,391,871) 11,122,965 651,878 1,142,137 1,405,236 3,499,615 (2,779,161) 11,933,349 606,156 1,240,623 1,572,606 3,807,583 (2,832,153) 13,279,662 399,930 1,190,695 1,583,837 3,705,802 (3,353,671) 13,089,325 — 112 — CITY OF COLLEGE STATION, TEXAS GENERAL REVENUES AND OTHER FINANCING SOURCES (4) LAST TEN FISCAL YEARS Certificates, Fiscal Property Franchise & Sales & Mixed Licenses & Fines & : Year Tax Franchise Tax Drink Tax Permits Service Fees 1978 $342,457 $ 93,682 $ 810,253 $ 67,511 $184,053 1979 438,268 103,752 951,726 59,022 288,306 1980 444,342 115,810 1,104,141 80,599 320,881 1981 513,114 135,823 1,596,132 219,785 406,636 1982 606,989 177,753 1,874,722 299,577 418,371 1983 589,814 228,951 2,654,600 226,466 492,985 1984 25,696 299,269 2,743,848 193,065 350,244 1985 8,408 267,991 3,104,118 220,378 442,921 1986 208,481 315,272 3,066,168 114,971 459,872 1987 222,826 299,973 3,016,640 102,739 442,408 (1) In fiscal 1980, the Sanitation Fund was set up as an Enterprise Fund, and is no longer supported by the General Fund. (2) Revenue sharing transfers not made until fiscal 1980. (3) Contribution from Enterprise Funds includes operating transfers. (4) Revenue presented includes the General Fund and Debt Service Funds. 113 Other Debt Service Services From Enterprise Financing Property Provided Funds (3) Miscellaneous Sources Tax Total $312,719 $125,565 $ 22,251 $ 578,207 $ 2,536,698 345,983 91,738 55,394 506,103 2,840,292 103,883 (1) $1,005,571 142,396 287,690 (2) 1,843,443 5,448,756 136,719 1,328,425 203,804 360,089 1,369,367 6,269,894 177,930 1,647,247 431,233 313,893 1,614,989 7,562,704 227,962 2,097,225 564,636 517,768 1,724,363 .9,324,770 269,094 2,774,940 354,924 337,370 2,678,842 10,027,292 286,010 3,272,759 453,871 625,825 3,514,761 12,197,042 335,371 4 ,066 ,951 407,287 706,772 3 ,826 ,083 13 ,507 ,228 298,463 4,302,654 414,908 657,086 3,992,810 13,750,507 j - 114 - I i CITY OF COLLEGE STATION, TEXAS PROPERTY TAX LEVIES AND COLLECTIONS LAST TEN FISCAL YEARS Current Percent Delinquent Fiscal Total Tax Of Levy Tax Year Tax Levy Collections Collected Collections 1978 $ 750,008 $ 728,672 97.16% $ 19,196 1979 892,181 867,137 97.19 15,181 1980 1,120,957 1,065,347 95.04 32,916 1981 1,178,078 1,127,500 95.71 44,166 1982 1,281,534 1,236,615 96.50 50,820 1983 2,286,192 2,178,842 95.30 42,389 1984 2,609,180 2,497,144 95.71 76,450 1985 3,446,634 3,243,918 94.12 79,880 1986 4,163,870 3,870,682 92.96 105,878 1987 4,261,855 3,956,428 92.83 192,003 — 115 Total Collections Outstanding Delinquent Total As Percent Of Outstanding Taxes As A Percent Tax Collections Current Levy Delinquent Taxes Of Current Levy 747,868 99.71% $ 42,601 5.68% 882,318 98.89 52,502 5.88 1,098,263 97.98 71,884 6.41 1,171,666 99.46 76,509 6.49 1,287,435 100.46 70,839 5.53 2,221,231 97.16 135,609 5.93 2 ,573 ,594 99.40 168,495 6.46 3,323,798 96.44 286,133 8.30 3,976,560 95.50 470,034 11.29 4,148,431 97.34 582,614 13.67 — 116 — CITY OF COLLEGE STATION, TEXAS ASSESSED AND ESTIMATED ACTUAL VALUE OF TAXABLE PROPERTIES LAST TEN FISCAL YEARS Real Property Personal Property Fiscal Assessed Assessed Estimated Year Value Actual Value Value Actual Value 1978 $120,853,467 $151,066,834 $ 25,023,668 $ 31,279,686 1979 140,112,861 175,141,076 26,258,105 32,822,631 1980 266,536,-120 333,170,150 27,368,820 34,211,025 1981 288,809,588 361,011,985 28,255,830 35,319,787 1982 388,608,966 388,608,966 44,444,725 44,444,725 1983 701,275,219 701,275,219 67,852,521 67,852,521 1984 751,247,026 751,247,026 90,423,941 90,423,941 1985 837,335,042 837,335,042 120,063,291 120,063,291 1986 947,844,276 947,844,276 147,911,179 147,911,179 1987 973,309,236 973,309,236 148,231,526 148,231,526 — 117 — Assessed Value Estimated Actual Value 145,877,135 $ 182,346,520 166 ,370 ,966 207 ,963 ,707 293,904,940 367,381,175 317 ,065,418 396,331 ,772 433,053,691 433,053,691 769,127,740 769,127,740 841,670,967 841,670,967 957,398,333 957,398,333 1 ,095 ,755 ,455 1 ,095,755 ,455 1,121,540,789 1,121,540,879 — 118 — Ratio of Total Assessed To Total Estimated Actual Value 80% 80 80 80 100 100 100 100 100 100 CITY OF COLLEGE STATION TEXAS PROPERTY TAX RATES, RATIOS AND LEVIES - ALL OVERLAPPING GOVERNMENTS LAST TEN FISCAL YEARS Tax Rates Fiscal (Per $100 of Assessed Value) Year City School County State Total 1978 $.52 $1.40 $1.00 $.10 $3.02 1979 .56 1.27 .99 .10 2.92 1980 .39 1.29 1.15 .10 2.93 1981 .39 1.40 .38 .10 2.27 1982 .31 1.18 .40 .10 1.99 1983 .31 .90 .27 .00 1.48 1984 .31 .97 .31 .00 1.59 1985 .36 .95 .3296 .00 1.6396 ' 1986 .38 .9780 .3253 .00 1.6833 1987 .38 1.079 .4170 .00 1.8760 (1) 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. (2) The date that taxes are due for all jurisdictions is October 1. Taxes for all jurisdictions become delinquent on February 1. (3) 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. (4) The state legislature effectively eliminated state property taxes by reducing the ratio to .0001% in fiscal 1981. - 119 - Tax Ratios City School County State 80% 80% 20% 20% 80 80 20 20 80 80 20 20 80 80 100 0 (4) 100 100 100 0 100 100 100 0 100 100 100 0 100 100 100 0 100 100 100 0 100 100 100 0 Tax Levies County/ City School State $ 750,027 $3,714,929 $1,410,978 892,365 3,665,701 1,592,086 1,121,035 3,631,840 2,183,122 1,176,291 4,173,218 3,653,898 1,281,560 4,707,725 4,140,834 2,286,192 7,105,257 5,879,701 2,609,180 8,706,598 9,086,144 3,446,634 9,676,001 9,206,410 4,163,870 11,757,247 9,997,174 4,261,855 12,797,106 11,515,156 - 120 - CITY OF COLLEGE STATION, TEXAS PAVING ASSESSMENT COLLECTIONS LAST TEN FISCAL YEARS Percentage of Current Current Total Fiscal Current Assessment Assessment Outstanding Year Assessment Collected Collected Assessments 1978 $ 18,671 $ 18,671 100.00 $ 24,299 1979 -- -- -- 7,612 1980 -- -- -- 4,388 1981 79,847 44,740 56.03 57,922 1982 394,287 348,235 88.32 385,484 1983 40,116 32,454 80.90 161,606 1984 49,373 65 .13 141,899 1985 -- -- -- 96,153 1986 -- -- -- 80,134 1987 -- -- -- 71,743 SOURCE: City of College Station Finance Office — 121 — CITY OF COLLEGE STATION, TEXAS COMPUTATION OF LEGAL DEBT MARGIN JUNE 30, 1987 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. - 122 - Fiscal Year 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 CITY OF COLLEGE STATION, TEXAS RATIO OF NET GENERAL BONDED DEBT TO ASSESSED VALUE AND NET BONDED DEBT PER CAPITA LAST TEN FISCAL YEARS Estimated Population* 32,348 35,260 37,296 42,320 45,623 46,857 52,784 52,521 52,581 52,851 Assessed Value $ 145,877,135 166,370,966 293,904,940 317,065,418 433 ,053 ,691 769,127,740 841,670,967 957,398,333 1 ,095 ,755 ,455 1,121,540,789 Gross Bonded Debt $ 3,046,250 5,916,000 11,995,000 (1) 11,290,000 (1) 14,690,000 (1) 20,240,000 (1) 27 ,480 ,000 (1) 21,354,000 19,907,500 18 ,411 ,000 Less Debt Service Cash Funds $ 365,282 332,203 772,498 769,558 812,717 955,945 1,478,640 1,750,986 2,028,845 2,560,656 * Source: Metropolitan Planning Organization & City of College Station Planning Department (1) Includes general obligation debt that is serviced by the enterprise funds. In fiscal 1985, such debt was reflected as indebtedness of the Utility Fund. -- 123 Ratio Of Net Bonded Net Bonded Net Bonded Debt Debt To Assessed Value Debt Per Capita $ 2,680,968 1.84% $ 83 5 ,583 ,797 3.36 158 11,222,502 3.82 301 10,520,442 3.32 249 13,877,283 3.20 304 19 ,284 ,055 2.51 412 26,001,360 3.09 493 19,603,014 2.05 373 17,878,655 1.63 340 15,850,344 1.41 300 — 124 — CITY OF COLLEGE STATION, TEXAS SCHEDULE OF DIRECT AND ESTIMATED OVERLAPPING DEBT JUNE 30, 1987 Taxing Body ESTIMATED OVERLAPPING DEBT College Station I.S.D. Brazos County Brazos County Road & Bridge Bryan I.S.D. NET DIRECT DEBT City of College Station NET DIRECT AND ESTIMATED OVERLAPPING DEBT *Population - 52,851 Net Debt City's Share Per* Amount As Of Percent Amount Capita $19,205,000 8/31/87 90.98% $17,472,709 $331 9,544,199 12/31/86 35.67 3,404,416 64 265,000 12/31/86 34.68 91,902 2 7,650,000 8/31/87 1.15 87,975 2 21,056,501 399 15,850,344 6/30/87 100.00 15,850,344 300 $36,906,845 $699 - 125 - Fiscal Year 1978 1979 1980 1981 1982 1983 1984 1965 1986 1987 Principal $ 118,750 150,250 884,036 684,435 856,343 1,195,929 1,547,007 1,361,800 1,630,982 1,685,439 CITY OF COLLEGE STATION, TEXAS RATIO OF ANNUAL DEBT SERVICE EXPENDITURES FOR GENERAL OBLIGATION DEBT TO TOTAL GENERAL FUND EXPENDITURES LAST TEN FISCAL YEARS Interest, Fiscal and Other Charges $ 189,442 298,569 683,133 637,503 715,120 1 ,221 $13 1 ,944 ,710 2,137,815 2,176,601 2,020,363 Total Debt Service $ 308,192 448,819 1,567,169 (1) 1,321,938 (1) 1,571,463 (1) 2,417,242 (1) 3,491,717 (1) 3,499,615 3,807,583 3,705,802 To tal General Fund Expenditures $1,762,502 1,869,954 3,095,304 (2) 4,095,610 5,642,951 8,021 ,211 7,629,318 8,433,734 9,472,079 9,383,523 Ratio 17 .49% 24.00 50.63 32.28 27.85 30.14 45.77 41.50 40.20 39.49 (1) Includes general obligation debt that is serviced by the Enterprise Funds. As of July 1, 1984, such debt was reflected as indebtedness of the Utility Fund. (2) In fiscal 1980, the Sanitation Fund was set up as an Enterprise Fund and is no longer supported by the General Fund. - 126 - CITY OF COLLEGE STATION, SCHEDULE OF REVENUE BOND COVERAGE — UTILITY FUND LAST TEN FISCAL YEARS Operating Expenses Debt Service Requirements Fiscal Operating (excluding Net Average Annual Maximum Annual Year Revenues Depreciation) Revenues Total Coverage Total Coverage ' 1978 $ 8,057,633 $ 6,532,582 $ 1,525,051 $ 362,505 4.21 $ 501,248 3.04 1979 8,862,537 6,210,206 2,652,331 354,559 7.48 487,673 5.44 1980 10,324,011 6,854,767 3,469,244 933,090 3.72 990,705 3.50 1981 11,917,202 7,974,852 3,942,350 812,578 4.85 990,298 3.98 1982 16,549,721 9,456,675 7,093,046 1,492,660 4.75 2,410,048 2.94 1983 23,611,548 15,505,972 8,105,576 2,288,214 3.54 3,787,641 2.14 1984 26,277,830 16,265,010 10,012,820 4,066,427 2.46 5,688,176 1.76 1985 31,867,897 21,673,543 10,194,354 (1) 3,582,202 2.85 5,172,546 1.97 1986 32,480,725 23,958,157 8,522,568 (1) 3,476,179 2.45 5,143,007 1.66 1987 32,760,614 22,777,769 9,982,845 (1) 3,357,048 2.97 5,096,158 1.96 (1) This amount includes an estimate of unbilled revenue for utility service. Prior years' amounts were not restated since the change in policy did not result in a material change. — 127 — CITY OF COLLEGE STATION, TEXAS TOTAL BANK DEPOSITS LAST TEN FISCAL YEARS Fiscal Year Amount 1978 $ 81,777,000 1979 88,045 ,000 1980 131,596,000 1981 143,578,000 1982 174 ,990 ,000 1983 175,848,000 1984 190 ,147 ,000 1985 200,588,000 1986 199,102,000 1987 214,443,000 SOURCE: Call Reports June 30 for all College Station Banks , - 128 - Year 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 CITY OF COLLEGE STATION, TEXAS CONSTRUCTION PERMITS LAST TEN YEARS Residential Construction Number of Permits Value 223 $22,527,190 287 8,899,612 267 11,606,261 359 25,707,945 603 50,667,095 663 64,567,551 424 27,272,747 134 23,500,892 194 9,587,839 209 8,104,272 Commercial Construction Number of Permits Value 223 $ 5,237,202 240 10,250,643 252 6,212,298 238 9,697,550 417 3,114,838 398 40,177,931 314 32,116,284 467 45$46,079 323 15,779,281 134 16,133,255 SOURCE: City of College Station Building Department Total Number of Permits Value 646 $ 27,764,392 527 19,150,225 519 17,818,559 597 35,405,495 1,020 80,781,933 1,061 104,745,482 738 59,389,031 601 69,046,971 517 25,367,120 343 24,237,527 — 129 — CITY OF COLLEGE STATION, TEXAS PRINCIPAL TAXPAYERS JUNE 30, 1987 Taxpayer Type of Business General Telephone Company Utility CBL Associates, Inc. Retail Mall Westinghouse Electric Corp. Manufacturing College Station Hotel Partners Hotel Texas Instruments, Inc. Manufacturing Foley's Federated Department Store Retail Ramada Inn Hotel Western Gulf Savings & Loan Retail Center Continental Real Estate Partners Apartments Sears Roebuck and Co. Retail SOURCE: Brazos County Appraisal District - 130 - 1986 Assessed Valuation $ 28,472,563 20 ,397 ,910 18,598,890 13,192,062 11,308,220 11,257,210 9,410,010 8,396,070 8,113,060 8 ,083 ,450 $137,229,445 Percent of Total Assessed Valuation 2.54% 1.82 1.66 1.18 1.01 1.00 .84 .75 .72 .72 12.24% CITY OF COLLEGE STATION. TEXAS MISCELLANEOUS STATISTICAL DATA JUNE 30, 1987 Date incorporated October 1938 Date first charter adopted October 1938 Date present charter adopted August 1983 Form of government Council —Manager Area in square miles Year Sq . Mi . 1938 1.5 1948 4.2 1958 7.3 1968 17.3 1978 22.6 1982 23.8 1986 26.7 Miles of sLreeLs Paved 157.0 Miles Unpaved 2.5 miles Miles of sidewalks 28.8 Miles Miles of sanitary sewer 192.0 Miles Fire Protection: Number of stations 2 Number of full—time employees 75 Police Protection: Number of employees (uniformed) 62 Number of employees (plain clothes, clerical) 25 Number of patrol units 15 One jail facility with a capacity of 20 Recreation: Number of playgrounds 17 Number of basketball courts 14 Number of swimming pools 3 Number of soccer fields 17 Number of softball/baseball fields 13 Number of tennis courts 13 Number of picnic shelters 11 Number of gyms 1 (Continued) — 131 — Parks : Facility CITY OF COLLEGE STATION, TEXAS MISCELLANEOUS STATISTICAL DATA (Continued) JUNE 30, 1987 Anderson Park Bee Creek Park Brentwood Park Brison Park Brother's Pond College Station Central Park Eastgate Fairview Gabbard Park Georgia K. Fitch Lemon Tree Park Lick Creek Park Lincoln Center Lion's Park Utility Fund: Electric users Water users Average electrical consumption: Average water consumption: Electric Water Sewer Water Capacity: Number of wells Combined capacity of wells Number of ground storage tanks Number of elevated storage tanks Miles of water lines Electric Capacity: Maximum capacity Number of switching stations Number of substations Miles of distribution lines Acres 8.94 43.50 7.69 9.20 16.12 47.22 1.00 1.80 10.67 11.30 15.50 515.00 8.00 1.50 Facility Longmire Park Merry Oaks Oaks Park Parkway Raintree Richard Carter Park Sandstone Southwood Complex Thomas Park University Park Site Wayne Smith Park Woodcreek Park Site Woodway Park Site TOTAL ACREAGE 27,037,596 KWH/Mo. during 1986-87 140,942 MGW/Mo. during 1986-87 Number of Employees 39 28 32 — 132 — Acres 4.16 4.60 7.50 1.90 13.00 7.40 13.21 44.65 16.10 10.02 2.00 6.65 2.00 830.63 16,765 15,221 4 12,000,000 GAL/day 3, Total capacity 10,000,000 GALS 2, Total capacity 3,000,000 GALS 180.0 miles 120 megawatts 1 2 180 (Continued) CITY OF COLLEGE STATION, TEXAS MISCELLANEOUS STATISTICAL DATA (Continued) JUNE 30, 1987 Sanitation Fund: Number of users Landfill size Methodology Education: Attendance centers Number of classrooms Number of teachers Number of students Elections: 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: Last general election Last municipal election Population: Census count 18,129 118 acres Curbside pickup using plastic bags 7 309 293 5,185 21,563 21,357 9,464 2,015 44% 9% 1987 52,851* 1980 37,296 1970 17,676 1960 11,396 1950 7,925 * 1987 Estimate per Metropolitan Planning Organization and City of College Station Planning Department. — 133 —