Loading...
HomeMy WebLinkAboutFY 1979-1980 -- Annual Financial ReportPLEASE FIETURN.TO B SECRETARY OF ege " City of College t . tion, 'Pexas FINANCE DEPARTMENT Annual Financial Report 19791980 CITY OF COLLEGE STATION, TEXAS FINANCIAL STATEMENTS AND SUPPLEMENTAL SCHEDULES FOR THE YEAR ENDED DUNE 30, 1980 AND REPORT OF HEREFORD, LYNCH & CO., P.C. CERTIFIED PUBLIC ACCOUNTANTS 1 i Organization Chart CITY or COLLEGE STATION TABLE OF CONTENTS JUNE 30, 1980 INTRODUCTORY SECTION Principal City Officials City Manager's Letter of Transmittal Finance Director's Letter of Transmittal FINANCIAL SECTION Page 1 2 3 - 4 5 - 9 Exhibit Auditor's Opinion 10 - 11 GENERAL PURPOSE FINANCIAL STATEMENTS - OVERVIEW: Combined Balance Sheet - All Fund Types and Account Groups 1 12 - 15 Combined Statement of Revenues, Expenditures, and Changes in Fund Balances - All Governmental Fund Types and Expendable Trust Funds 2 16 - 17 Combined Statement of Revenues, Expenditures, and Changes in Fund Balances - Budget and Actual - General and Special Revenue Fund Types 3 18 - 19 Combined Statement of Revenues, Expenses, and Changes in Fund Equity - Proprietary Fund Type . . . . . . . . . • . . 4 20 Combined Statement of Changes in Financial Position Proprietary Fund Type ........... . . • . . . • • • 5 21 Notes to the Financial Statements ...... . . 6 22 - 30 COMBINING STATEMENT BY FUND TYPE: Special Revenue Funds: Combining Balance Sheet 7 31 Combining Statement of Revenues, Expenditures, and Changes in Fund Balances . • •0 a 0•0 Oa 0 • . a • 8 32 Capital Projects Funds: Combining Balance Sheet 9 33 - 34 Combining Statement of Revenues, Expenditures, and Changes in Fund Balances . . . V 0 ..... a a 00 0 10 35 - 36 Enterprise Funds: Combining Balance Sheet 11 37 - 38 Combining Statement of Revenues, Expenses, and Changes in Fund Equity . . . . . .......... . 39 . . 12 Exhibit Page Trust and Agency Funds: Combining Balance Sheet 13 40 Combining Statement of Revenues, Expenditures and Changes in Fund Balance 14 41 INDIVIDUAL FUND AND ACCOUNT GROUP STATEMENTS: Governmental Fund Types: General Fund - Balance Sheet 15 42 Statement of Changes in Fund Balance 16 43 Statement of Revenues and Transfers - Estimated & Realized 17 44 - 45 Statement of Expenditures Compared With Appropriations 18 46 - 53 Debt Service Fund - Balance Sheet 19 54 Statement of Revenues, Expenditures & Fund Balance 20 55 Proprietary Fund Types: Utility Fund - Balance Sheet 21 56 - 57 Statement of Changes in Contributions and Retained Earnings 22 58 Statement of Revenue and Expense 23 59 Statement of Revenues - Estimated & Realized 24 60 Schedule of Budgeted and Actual Expenses 25 61 - 63 Schedule of Fixed Assets & Depreciation . . . . . . . . . . 26 64 - 65 Schedule of Revenue Bond Debt 27 66 - 67 Sanitation Fund - j 28 68 Balance Sheet Statement of Changes in Contributions and Retained Earnings . 29 69 Statement of Revenue & Expense . . . . . . . . . . . . . . 30 70 Schedule of Budgeted and Actual Expenses 31 71 Account Groups: General Fixed Assets - I 32 72 Statement of General Fixed Assets Schedule of Changes in General Fixed Assets . . . . . . 33 73 - 74 General Long -Term Debt - Statement of General Long -Term Debt 34 75 Schedule of Tax Obligation Bond Debt 35 76 - 77 Schedule of Other Tax Obligation Debt 36 78 - 79 Exhibit Page Supplemental Schedules: Statement of Cash Receipts and Disbursements - All Funds • . 37 80 - 81 Combined Schedule of Delinquent Taxes Receivable 38 82 Summary of Taxes Receivable 39 83 Combined Statement of Bonds Payable - Utility and General Long -Term Debt 40 84 - 85 STATISTICAL SECTION Table General Governmental Expenditures by Function • • I 86 General Revenue by Source II 87 - 88 Property Tax Levies and Collections III 89 - 90 Assessed and Estimated Actual Value of Taxable Property • • IV 91 - 92 Property Tax Rates, Ratios, and Levies - All Overlapping Governments V 93 - 94 Ratio of Net General Bonded Debt to Assessed Value and Net Bonded Debt Per Capita VI 95 - 96 Computation of Legal Debt Margin VII 97 Statement of Direct and Estimated Overlapping Debt VIII 98 Ratio of Annual Debt Service Expenditures for General Obligation Debt to Total General Fund Expenditures IX 99 Schedule of Revenue Bond Coverage X 100 Debt Service Requirements to Maturity - General Obligation Bonds XIA 101 Debt Service Requirements to Maturity - Revenue Bonds XIB 102 Debt Service Requirements to Maturity - Notes XIC 103 Summary of Debt Service Requirements to Maturity XID 104 Schedule of Insurance Coverage XII 105 - 106 Bank Deposits XIII 107 Principal Taxpayers XIV 108 Miscellaneous Statistical Data XV 109 - 112 (r) (L) N 4-) • (-) >") a) LiJ - Cr) a) __J MS CL U) = • r- -I-) o s) = or- or• r- CU CT) .1--) CT) (I ft C = -i--, (I) .1- S- .1-- • r- >1 4-) S- -----. 0) o01 (1) (/) Q) U C CO S- al .r." CD •," • r- 4- = E•r- •i- •r- 4- = Cr) E Cp (Et (d = 7:3 c S.- i_u < W F- 0-- ro (.) • r- r-- (1) 0 .1-- E Tr) 4-3 ro s- s- or- V) LJ•r- E -0 c7. 0 V> (a -Se $.- S- ccS vrt E or- -0 0 • r- r-• CC/ (-) (/) (/) LL- • r-- EH U CU •r- r •r- -- -CI > 23 S-- CI_ CD 4:1) E 0 z3 4- (13 C a) • r- S- C - Investigations 23 ro a) s- r- (CS .--- a) fa. rt3 U • r- • r- or- U U > •I- S- C) S23 - 0- CU 230 V) V) (i) 0 0 or- ° r• 4-) (1) S- 43) > .-a) S- • r1 r- C) CI - - Ambulance - Recreation a) tit •r- a) -I-4 vt 413 23 O (‚3�i < CU S- 0 LL - Accounting - Utilities - Purchasing - Warehouse - Streets Cn rt3 • S- - Cemeter - Electric Transmission - Electric Distribution Water Production Water Distribution - Sewer Treatment Sewer Collection 0 • r• 0 • r- C) 4-4 ' • (1) r- r- 0 r- 0 r-- • r- ro 4-) cu s- 73 cp • r- 0 - Landfill Mayor CITY OF COLLEGE STATION PRINCIPAL CITY OFFICIALS JUNE 30, 1980 Councilman Councilman Councilman Councilman Councilman Councilman Place 1 Place 2 - Place 3 - Place 4 Place 5 - Place 6 City Manager Assistant City Manager/Director Of Finance Tax Assessor-Collector/City Secretary Municipal Court Judge City Attorney City Health Officer Gary M. Halter Roy W. Kelly Robert C. Runnels Larry J. Ringer Patricia B. Boughton Tony Jones James H. Dozier North Bardell A.E. VanDever, Jr. Glenn Schroeder Kenneth M. Robinson Neeley C. Lewis Dr. T.O. Walton, Jr. - 2 of lie tit POST OFFICE BOX 996() 1 101 TEXAS AVENUE COPI ,F,GF STATION, TEXAS 77840 December 31, 1980 Honorable Mayor and Members of the City Council City of College Station Dear Council: In accordance with the statutes of the State of Texas and local charter provisions, I hereby transmit the annual financial report of the City of College Station as of June 30, 1980,and for the fiscal year then ended. Responsibility for both the accuracy of the data presented and the completeness and fairness of the presentation, including all disclosures, rests with the City. Management believes that 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 and results of operations of the City as measured by the financial activity 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. In developing and evaluating the City's accounting system, consider- ation is given to the adequacy of internal accounting controls. Internal accounting controls are discussed by the finance director in his accom- panying letter of transmittal, and within that framework, I believe that the City's internal accounting controls adequately safeguard assets and provide reasonable assurance of proper recording of financial transactions. This report has been prepared following the guidelines recommended by the Municipal Finance Officers Association of the United States and Canada. The Municipal Finance Officers Association awards Certificates of Confor- mance to those governments whose annual financial reports are judged to conform substantially with high standards of public financial reporting including generally accepted accounting principles promulgated by the National Council on Governmental Accounting. It is my belief that the accompanying fiscal year 1980 financial report will meet program standards and it will be submitted to the Municipal Finance Officers Association for review. In accordance with the above -mentioned guidelines the accompanying report consists of three parts: 1) Introductory section, including the finance director's letter of transmittal. 2 2)'Financial section, including the financial statements and supplemental data of the government accompanied by our inde- pendent auditor's opinion. 3) Statistical section, including a number of tables of unaudited data depicting the financial history of the government for the past ten years, information on overlapping governments, and demographic and other miscellaneous information. The City Charter requires that the financial statements of the City of College Station be audited by an independent Certified Public Accountant selected by the City Council. This requirement has been complied with and our auditor's opinion is included in the financial section of this report. The Capital Improvements Program will be completed and ready to present to the voters in early 1981. Should the proposed capital improvements be approved, the timeliness of this report will enable us to approach the bond market at a time when indicators point toward lower interest rates. I am sure you are aware that due to the extremely dynamic nature of the money market today there are no guarantees, only speculations. The preparation of this annual report could not have been accomplished without the dedicated effort of the Director of Finance and his entire staff. Their efforts over the past two years toward upgrading the accounting and financial reporting systems of the City of College Station have lead sub- stantially to the improved quality of information being reported to the City Council, myself, bond rating companies, state agencies and the citizens of College Station. Respectfully Submitted, North Bardell City Manager NB/jg -4 Cityof College Station POST OFFICE; BOX 9960 1 101 TEXAS AVENUE COLLEGE STATION, TEXAS 77840 December 31, 1980 Honorable Mayor, Members of the City Council, and City Manager City of College Station The Comprehensive Annual Financial Report of the City of College Station, for the fiscal year ended June 30, 1980, 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 fair- ness 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 and results of operations of the City as measured by the financial activity 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. Accounting System and Budgetary Control In developing and evaluating the City's accounting system, consideration is given to the adequacy of internal accounting controls. Internal account- ing controls are designed to provide reasonable, but not absolute, assurance regarding: (1) the safeguarding of assets 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 framework. We believe that the City's internal accounting controls adequately safeguard assets and provide reasonable assurance of proper recording of financial transactions. Budgetary control is maintained at the subfunction level by the encum- brance 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, 1980. The Reporting Entity and Its Services This report includes all of the funds and account groups of the City. It includes all activities considered by the U.S. Bureau of Census to be part of (controlled by or dependent on) the City. 5 The City provides a full range of municipal services and products. These include police and fire protection, streets, sanitation, health, art -cultural, parks, public improvements, planning and zoning, general administrative services, electrical, water and sewer systems. General Governmental Functions Revenues for general governmental functions totaled $4,234,108 in 1980, an increase of 22 percent over 1979. General property taxes produced 10.5 percent of general revenue as compared to 13.1 percent last year. The amount of revenues from various sources and the change from the prior year are shown in the following tabulation: Increase Percent (Decrease) Revenue Source Amount Of Total From 1979 Property Taxes & Penalties $ 444,342 10.50% $ 6,074 Charges for Services 103,883 2.45 (242,100) Fines & Forfeitures 315,514 7.45 27,208 City Sales Tax 1,065,314 25.16 145,822 Contribution From Enterprise Fund 1,634,366 38.60 659,100 Franchise Receipts 115,810 2.74 12,058 Other Revenues 554,879 13.10 316,491 Total $4,234,108 100.00% $924,653 The large decrease in Charges for Services is due to sanitation charges being included in this category in 1979 and, as you know, reported in a separate enterprise fund in 1980. Assessed valuations of 293.9 million represented an increase of 56.6 million over 1979. The major portion of this increase was due to city-wide revaluation in 1980. Current tax collections were 95.03 percent of the tax levy, down 2.14 percent from last year. This is the fourth consecutive year in which current property tax collections have exceeded 95 percent and is the eighth time in ten years collections have exceeded this mark. Delinquent tax collections were double the amount collected in 1979. The ratio of total collections (current and delinquent) to the current tax levy was 97.97 percent, a decrease of .9 percent when compared to last year. Allocation of the property tax levy by purpose for 1980 and the preceeding two fiscal years are as follows (amounts per $100 assessed value): Purpose 1980 1979 1978 General Fund $.1553 $.2770 $.3300 General Obligation Debt .2347 .2830 .1900 Total Tax Rate $.3900 $.5600 $.5200 - 6 3 Expenditures for general governmental purposes (General Fund and Debt Service) totaled $5,300,268, an increase of 36 percent over 1979. Increases in levels of expenditures for major functions of the City over the preceding year are shown in the following tabulation: Increase Percent (Decrease) Function Amount 0f Total From 1979 General Government $1,442,672 27.22% $ 545,402 Police 920,773 17.37 347,935 Fire 687,264 12.97 230,665 Streets 205,684 3.88 (103,461) Parks 476,706 8.99 110,046 Debt Service 1,567,169 29.57 1,027,986 Sanitation - (242,707) Total $5,300,268 100.00% $1,915,866 Expenditures in the street department decreased 43 percent when compared to 1979. This was due to less equipment maintenance costs in 1980 and a shift in personnel for accounting purposes. As previously mentioned, the decrease in the sanitation category was due to the establishment of a separate fund in the current year. Unreserved fund balances and retained earnings in the major operating funds were maintained at adequate levels. The General Fund balance of $1,471,112 was up $532,609 from 1979; the Debt Service Fund balance of $722,498 was up $276,274 from the prior year; and the $438,546 balance in the Special Revenue Funds was down $98,973. 0f the $368,882 balance in retained earnings of the Sanitation Fund, $127,645 represents net assets transferred to establish the fund July 1, 1979. The actual increase within the current fiscal year was therefore $241,237. The Utility Fund retained earnings increased $1,501,756. Debt Administration The ratio of net bonded debt to assessed valuation and the amount of bonded debt per capita are useful indicators of the City's debt position to municipal management, citizens and investors. These data for the City at the end of the 1980 fiscal year were as follows: Ratio of Net Bonded Ratio of Debt Debt Debt to Assessed Value to Present Per Amount (80% of Present Market) Market Value Capita Net Direct Bonded Debt $11,222,502 3.82% 3.05% $300.90 Outstanding general obligation bonds at June 30, 1980, totaled $11,945,000. In addition, $74,507 of long term notes are outstanding For more detailed information about the debt position of the City, please refer to the statistical tables in the final section of this report. - 7 4 The City's bonds continue to carry the same ratings which they have had for the past few years. These ratings are as follows: Moody's Investors Service Standard & Poor's General Obligation Bonds A-1 A 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. The average yield on maturing investments during the year was 10.12 percent, and the amount of interest earned was $1,251,109. Capital Project Funds Proceeds of general obligation bond issues are accounted for in Capital Projects Funds until the projects are completed. These projects and con- struction in progress at year end are capitalized in the General Fixed Assets group of accounts. During 1980, projects costing $868,017 were completed. Authorized but unissued bonds at June 30, 1980, totaled $500,000. No bonds have been issued since that time. The Capital Project Fund balances on hand at June 30, 1980, totaled $3,962,160. General Fixed Assets The general fixed assets of the City are those fixed assets used in the performance of general governmental functions and exclude the fixed assets of Enterprise Funds. As of June 30, 1980, the general fixed assets of the City amounted to $9,952,777. 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 account- ing system. Sanitation Fund As was mentioned earlier, the Sanitation Fund was established and its operations segregated this year from the General Fund. Net income for 1980, totaled $241,237 increasing retained earnings to $368,882. This was a good year for the Sanitation Fund which will aid in the purchases of capital items in future years. Utility Fund The City's utility operation continued to show moderate gains in operating revenues and numbers of customers while net income and debt service coverage showed declines. Comparative data for the past two fiscal years are presented in the following tabulation: Operating Revenues Operating Income Income Available for Debt Service Annual Debt Service Coverage (income available for debt service divided by average annual debt) 1980 1979 $10,324,011 $-2,022,022 $ 2,464,411 839,861 2.93 $8,862,537 S2,143,733 $2,652,331 846,675 3.13 8 5 During the year, $262,000 of regularly maturing revenue bonds were retired in the Utility Fund. In addition, $349,750 of general obligation bonds, serviced with earnings of the Utility activities, were retired. Independent Audit The City Charter requires an annual audit of the books of account, financial records, and transactions of all administrative departments of the City by independent certified public accountants selected by the City Council. This requirement has been complied with and the auditor's opinio has been included in this report. Certificate of Conformance The Municipal Finance Officers Association of the United States and Canada (MFOA) awards a Certificate of Conformance in Financial Reporting to entities who produce a comprehensive annual financial report. In order to be awarded a Certificate of Conformance, a governmental unit must publish an easily readable and efficiently organized comprehensive annual financial report, whose contents conform to program standards. Such reports must satisfy both generally accepted accounting principles and applicable legal requirements. A Certificate of Conformance is valid for a period of one year only. We believe our current report will conform to Certificate of Conformance Program requirements, and we are submitting it to MFOA to determine its eligibility for a certificate. Acknowledgements The preparation of this report on a timely basis could not have been accomplished without the efficient and dedicated services of the entire staff of the Finance Department. I would like to express my appreciation to all members of the Department who assisted and contributed to its pre- paration. I should also like to thank the Mayor, City Council and City Manager for their interest and support in planning and conducting the financial operations of the City in a responsible and progressive manner. Respectfully Submitte A.E. V n Dev r, Assista ty Man&er Director of Finance AEV:jg - 9 Gerald L. Simpson, C.P.A. Candyce F. Dixon, C.P.A. Richard S. Ohendalski, C.P.A. ereford, ynch & Co. Certified Public Accountants off{ �w`essiona(eoz(aozafton 1300 llth STREET, FNB BOX 8001 FIRST NATIONAL BANK BUILDING, SUITE 500 HUNTSVILLE, TEXAS 77340 Huntsville: 713/295-5796 Conroe: 713/756-1095 December 31 , 1980 Other locations: Conroe, Texas Cleveland, Texas Houston, Texas Honorable Mayor, Members of the City Council, and City Manager City of College Station We have examined the combined financial statements of the City of College Station and its combining and individual fund financial statements as of and for the year ended June 30, 1980, as listed in the 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 cir- cumstances. Appropriate adjustments have been made to the fund balance and retained earnings of the Debt Service Fund and Utility Fund, respectively as of the beginning of the year for changes necessary to adopt generally accepted accounting principles as more fully explained in Note 8 to the financial 'statements. It was not practicable to determine what adjustments would be necessary in the financial statements of the preceding year to restate results of operations and changes in financial position in conformity with the accounting principles used in the current year. In our opinion, the combined financial statements referred to above pre- sent fairly the financial position of the City of College Station at June 30, 1980, and the results of its operations and the changes in financial position of its proprietary fund types and similar trust funds for the year then ended, in conformity with generally accepted accounting principles. Also, in our opinion, the combining and individual fund finan- cial statements referred to above present fairly the financial position of the individual funds of the City of College Station at June 30, 1980, their results of operations, and the changes in financial position of individual proprietary funds for the year then ended, in conformity with generally accepted accounting principles. MEMBERS OF THE TEXAS SOCIETY OF CERTIFIED PUBLIC ACCOUNTANTS 2 Our examination was made for the purpose of forming an opinion on the com- bined financial statements taken as a whole and on the combining and indi- vidual fund financial statements. The accompanying financial information listed as supplemental schedules in the table of contents is presented for purposes of additional analysis and is not a required part of the combined financial statements of the City of College Station. The information has been subjected to the auditing procedures applied in the examination of the combined, combining, and individual fund financial statements and, in our opinion, is fairly stated in all material respects in relation to the combined financial statements taken as a whole. Information contained in the statistical tables as listed in the table of contents has not been subjected to the auditing procedures applied in the examination of the combined, combining, and individual fund financial state- ments and therefore, we do not express any opinion concerning them. Respectfully Submitted, HEREFORD, LYNCH & CO., P.C. GERALD L. SIMPSON (� Certified Public Accountant GLS:ld GENERAL PURPOSE FINANCIAL STATEMENTS ^.. ` �^ ". ^"�`�°^ "/ ` ' � COMBINED, BALANCE c� - ALL FUND T 'ND ACCOUNT GROUPS ' 'i ~/.�, ''�� » / JUNE 30, 1980/ � . '. ' CITY OF COLLEGE N ASSETS AND OTHER DEBITS: Cash On Hand and in Bank Certificates of Deposit Accrued Interest Receivable ACCOUnt5 Receivable (Net of Unc011ect.\ Delinquent TdX8S Receivable ' Paving Assessments Receivable Due From Federal & State Agencies Due From Other Funds (Note q\ Inventories Restricted Assets - Utility Fund Cash Certificates of Deposit Accrued Interest Receivable Due From Other Funds (Note 9\ Escrowed Construction Funds Land Utility Systems Buildings & Equipment Buildings & Improvements Machinery, Tools, & Equipment Motor Vehicles Parks & Recreation Equipment Paving Sidewalks & 8Lreets [UD5trUCti0O Work iD Progress Prepaid Water Costs Bond IS5UaDC8 Costs Amount Available for Retirement of Long -Term Debt Amount to be Provided for Retirement of Long -Term Debt TOTAL ASSETS AND OTHER DEBITS: General 38,448 760,000 24,015 20,918 33,413 4,388 17,882 724,808 39,428 GOVERNMENTAL Soeridl ReY�DVg _ __ $125,943 $ 597,000 1,025 76 62,690 Exhibit l Page l of 2 FUND TYPES Debt 5erYi.c. e 17,354 142,000 38"47l Capital $ 459,335 2,763,000 28,839 _ 19,771 1,103,709 2,923,528 _ The accompanying notes are an integral part Of this financial statement. - 12 - PROPRIETARY FIDUCIARY FUND TYPE FUND TYPE Enterprise Trust & Agency � 1,060,639 $ 8,041 350,000 15,900 430 1,126,252 5ql,36l 430,345 273,912 l129,657 39,087 917,313 G,l6l°788 304,594 7,340,538 4,747,654 33,682 129,864 3,204,900 880,887 80,404 $28,811J877 2,527 ACCOUNT GROUPS M80OrDDdU0 General General Totals Fixed Assets Long -Term Debt June 30, 1480 � ~ l,8O0,7l8 2]8l,739 958,361 269,703 947,777 2,418,885 1,295,594 � ~ 722,448 11,2q7,OU9 $26,898 $9,952,777 $12,019,507 $ 1,709,760 4,627,900 54,309 1,l47,246 7l,884 4,388 100,343 5,345,933 469,773 273,912 l,l29,557 39,087 917,313 G,l5l,7O8 2,185,312 7,34.9,538 4,747,654 2,181,739 992,043 399,567 947,777 2,418,885 4,500,494 880,887 80,404 722,498 ll,297,UOA $60 757 lOU - 13 - CITY OF COLLEGE STATION COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS JUNE 30, 1980 LIABILITIES: Accounts Payable Sales Tax Payable Due to Escrowed Construction Funds Due to Southgate Village for Paving Assessments Due to Other Funds (Note 9) Matured Interest Coupons Payable Accrued Interest Payable Refundable Deposits Municipal Court Fees Payable Construction Contracts Retainage Payable Bonds Payable Notes Payable Total Liabilities FUND BALANCES/EQUITY AND OTHER CREDITS: Reserved for Encumbrances Reserved for Purchase of Parks Reserved for Uncollected Taxes Reserved for Uncollected Ambulance Accounts Receivable Reserved for Uncollected Cemetery Accounts Receivable Contributions Investment in General Fixed Assets Fund Balance Retained Earnings Total Fund Balances/Equity/Credits TOTAL LIABILITIES AND FUND BALANCES/EQUITY AND OTHER CREDITS: Exhibit 1 Page 2 of 2 GOVERNMENTAL FUND TYPES Special Debt General Revenue Service $ 81,607 $ 1,765 $ 5,142 97,553 346,423 538,712 1,853 6 ,236 1,650 $-- 192,188 $348,188 $ 540,565 $ 88,551 $ - $ 63,354 33,413 - 38,471 11,423 2,648 1,271,723 438,546 722,498 Capital Projects $ 201,315 1,947,542 83,456 $2,232,313 3,962,160 $1,471,112 $438,546 $ 760,969 $3,962,160 $1,663,300 $786,734 $1,301,534 $6,194,473 The accompanying notes are an integral part of this financial statement. - 14 - PROPRTE::TARY FUND TYPE EnteY pr Ise $ 1,506,478 13,920 4/,417 3,333,016 230,626 534 ,089 235,680 9,824,258 484 7,230,684 $28,811 , FIDUCIARY FUND TYPE Trust & Agency 26,898 526,898 $26,898 ACCOUNT GROUPS Memorandum General General Total s Fixed Assets Lora:Term Debt dune ...30, 1980 $ 11,945,000 74,507 12,019,507 9,952,777 9,952,777 ,$ r $9,952,777_ 512,019,507 S 1 ,791 ,165 13,920 47,417 5 , 142 6,263,246 1 ,853 23(),62.6 540,325 1 ,650 319,136 21,769,258 74,507 058,245 88,551 63,354 71 ,884 11,423 2 ,648 7,230,684 9,952,777 6,421 ,825 5,855,709 '29,698,855 $60,757,100 CITY OF COLLEGE STATION COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES - ALL GOVERNMENTAL FUND TYPES AND EXPENDABLE TRUST FUNDS FOR THE YEAR ENDED JUN[ 30, l980 Exhibit Z REVENUES: Taxes Licenses o8nmitS Service Fees Fines Certificates Fees for City Services Provided Earnings on IDV8St08ntS Shared Revenues - Federal Sources State Grants Miscellaneous Revenue Total K2VeDueS EXPENDITURES: Current: Administration Planning Finance Public Service Police Fire [DgiUcc, rfrig Parks Fe'derdl Housing Rehabilitation Miscellaneous Capital Outlay Capital Outlay Contributed to Utility Fund Debt Service - Principal Retirement Debt Service - Interest & Fiscal Charges Total Expenditures REVENUES OVER (UNDER) EXPENDITURES: OTHER FINANCING 5OURCESS\: [ODtribUti0DS F h8.--- Funds (Contributions to Other FUnJS\ (Contributions to Community OpgDOiZDti0nS\ Total Other FindnCiDg S0UrCe3 /USe3\ � REVENUES AND OTHER SOURCES OVER (UNDER) EXPENDITURES AND OTHER USE-: ADJUSTED FUND BALANCES - JU-Y l, 1979: Add: Increase in K838rVes FUND BALANCE - JUNE 30, 1980: The accompanying notes are an integral part Of thiI - 16 - financial General _ $l,664,2q3 3,262 75,661 5,367 315,5]4 ],076 103,883 35,333 107,063 GOVERNMENTAL 5peCi al Revenue $189,023 _ 49,469 244,935 22l,650 66,884 534,072 474,553 859,629 O6l,7O7 206,812 426,377 lO,l42 202,203 - - 2,956 150,009 $`3-724,099 (31,412,047) S330,462 $l,922,056 /9,O00\ %l, H3,O5b $ 5Ol,UO9 938,503 3l,6O0 $l,47l,ll2 statement. (342,591) (86,844) /'�429,435\ $/98,973\ 537,519 438,546 FUND TYPE Service PrO]2Cts _ � 658,212 $ ---- 7,258 7,406 � ~ 672,876 884,036 6R3 lJ3 \l,5h7,\h9 425,535 4.25,264 l34,ql8 8,532 � � 994,349 FIDUCIARY FUND TYPE Trust & MelnVrdndUm Ag8D[,X Totals $ $2,511,528 _- 3,262 - - 75,661 5,367 3l5,5l4 l,676 103,883 2,310 520,005 670,199 1,500 136,418 41,162 164,163 � 43,386 ~ 150,186 l,525,997 913,351 ?J633,9KZU (894,293) /$1^639,571\ \ 276,274 446,224 / ` (484,059) ;2,105,630\ 6,065,790 4,100 7,398 S ll/498 3 33,474 2,600 2,600 $ 36,074 /9,]7O\ $ 265,046 56,884 534,072 474,653 859,629 665,867 206,812 426,377 150,186 20,496 l,938,2O9 913,351 884,036 683,133 ��-089,h5l / ` 53,O95,223 /Ol5,G50 86,R44) T-2�l92,729 '1,389,246\ 7,978,860 70,071 _ 6-659,585 ' CITY OF COLLEGE STATION COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL GENERAL AND SPECIAL REVENUE FUND TYPES FOR THE YEAR ENDED JUNE 30, 1980 REVENUES: LfCeD3e5 Permits Service Fees Fines Certificates City 38rYiCCS Provided Shared Revenues - Federal Sources Earnings On investments Miscellaneous Total Revenues EXPENDITURES: Administration quDning 7iOunCe lUblir Service l0lice :ire ingin8ering l8rk5 Miscellaneous Expenditures Capital Outlay: Total Expenditures REVENUES ' ` OTHER FINANCING ' . (Contributions To Other Funds) \Cun:r/ou3lUns To Community Organizations) Total Other Financing 30Urc2C /UsBS\ REVENUES AND OTHER SOURCES OVER/ \ ADJUSTED FUND BALANCES - JULY l 1979: Add: Increase in Reserves FUND BALANCE - JUNE 30, 1980: $l,7SA,26O 3,475 49,700 5,200 288,000 2,500 107,000 |O"OOO 121 l06 705 S 225,338 99,621 573,203 679,243 918,363 739,081 210,658 495,6/8 56,552 304,685 / \ $l,922,OS6 /9,OOO\ l,gl3,056 Exhibit 3 @ENER8[ FUND Favorable /UnfaYOrdbl8\ ������' (93,9G7 /2l3\ 25,961 167 27,5]4 /824 /3,]]7\ Actual Sl,664,293 3°262 75,661 5,387 315,514 1,O76 ]U3,883 56,33] lO7 1 O6T 5 22l,660 66,884 534,072 474,553 859,629 6Dl°767 206,812 426,377 10,142 262,203 / \ $l,922,O56 (D,OOO) l,9l3,D56 " 1,534 ~ � 5010O9 938,603 31,600 The accompanying notes are an integral part of this financial statement. 25,333 $ 3,678 32,737 39,131 204,690 58,734 77,314 3,846 69,241 46"4lO 42,482 3499,475 S499 SPECIAL Budget 249,288 $249,288 11,000 $ 11,000 $238,288 (342,591) (86,300) ($428,891) ($190,603) REVENUE FUND Variance Favorable Actual (Unfavorable) $189,023 $189,023 244,935 (4,353) 49,469 49,469 $483,427 $234,139 2,956 150,009 152,965 $330,462 (342,591) (86,844) ($429,435) $(98,973) 537,519 $438,546 $ 8,044 (150,009) ($141,965) $ 92,174 (544) $ (544) $ 91,630 MEMORANDUM Budget $1,758,260 3,475 49,700 5,200 288,000 2,500 107,000 249,288 10,000 166,705 $2,640,128 225,338 99,621 573,203 679,243 918,363 739,081 210,658 495,618 67,552 304,685 413,362 ($1,673,234) $1 ,922 ,056 (351,591) (86,300) $1,484,165 $ (189,069) Actual $1,853,316 3,262 75,661 5,367 315,514 1 ,676 103,883 244 ,935 84,802 107,063 $2,795,479 221 ,660 66,884 534,072 474,553 859,629 661,767 206,812 426,377 13,098 412,212 $3,877,064 ($1 ,081 ,585) TOTALS Variance Favorable (Unfavorable) $ 95,056 (213) 25,961 167 27,514 (824) (3,117) (4,353) 74,802 (59,642) $155,351 $ 3,678 32,737 39,131 204,690 58,734 77,314 3,846 69,241 54,454 (107,527) $436,298 $591 ,649 $1,922,056 $ (351,591) - (86,844) (544) $1,483,621 --(544) $ 402,036 1,476,022 31 ,600 $1,909,658 $591,105 CITY OF COLLEGE STATION COMBINED STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN FUND EQUITY - PROPRIETARY FUND TYPE FOR THE YEAR ENDED JUNE 30, 1980 OPERATING REVENUES: Electric Sales and Fees Water Sales and Fees Sewer Sales and Fees Sanitation Sales and Fees Dumpster Sales Miscellaneous Income Total Operating Revenue OPERATING EXPENSES: Electric and Water Productions and Distribution Sewer and Sanitation Collection and Disposal Non -Departmental Operating Expense Depreciation Total Operating Expenses OPERATING INCOME: NON -OPERATING REVENUES (EXPENSES): Interest Earnings - Time Deposits 115,192 Interest Earnings - Escrowed Construction Funds 615,912 Amortization of Bond Premium 282 Revenue Bond Interest Expense (540,740) Amortization of Revenue Bond Issuance Costs (4,404) Transfer to Debt Service (706,508) EXCESS OF REVENUE OVER EXPENSES: $ 1,742,993 ADJUSTED RETAINED EARNINGS - JULY 1, 1979: 4,112,716 RETAINED EARNINGS - JUNE 30, 1980: $ 5,855,709 Exhibit 4 ADJUSTED CONTRIBUTED CAPITAL - JULY 1, 1979: Add: Contributions 1979-80 FUND EQUITY - JUNE 30, 1980: Proprietary Fund Type Enterprise $ 8,336,194 1,326,433 572 ,778 602,511 16,337 88,618 $10,942,871 $ 5,816,885 690,089 1,684,982 487,656 $ 8,679,612 $ 2,263,259 4,048,188 3,182,496 $13,086,393 The accompanying notes are an integral part of this financial statement. -20- CITY OF COLLEGE STATION COMBINED STATEMENT OF CHANGES IN FINANCIAL POSITION - PROPRIETARY FUND TYPE FOR THE YEAR ENDED JUNE 30, 1980 SOURCES OF WORKING CAPITAL: Operations: Net Income Items Not Requiring Working Capital Depreciation Working Capital From Operations Contributions From Federal & Local Governments Issuance of Long Term Debt Interest Earnings on Time Deposits Transfer of Sanitation Fund Capital Previously Classified in General Fund Increase in Customers' Meter Deposits Amortization of Prepaid Water Costs Total Sources of Working Capital APPLICATIONS OF WORKING CAPITAL: Acquisition of Property, Plant, & Equipment Transfer of Sanitation Fund Property, Plant, & Equipment Previously Classified in General Fixed Asset Group of Accounts (Net of Depreciation) 123,626 Prepayment of Water Costs 201,639 Reclassification of General Obligation Bonded Indebtedness Proceeds to Appropriate Capital Projects Funds 3,472,677 Contribution of Capital to Debt Service Fund 706,508 Net Decrease in Reserve Accounts 187,828 Payment of Issuance Costs of Long -Term Debt 47,219 Correct Accrual of Prior Year's Accounts Payable 3,629 Total Applications of Working Capital 9,015,667 NET INCREASE IN WORKING CAPITAL: $ 1,071,155 ELEMENTS OF NET INCREASE (DECREASE) IN WORKING CAPITAL: Cash $ 540,839 Accounts Receivable 333,720 Inventories 118,597 Due From Other Funds (350,882) Assets Restricted for Payment of Liabilities 2,002,211 Accounts Payable (113,941) Due From Other Funds (157,944) Liabilities Payable From Restricted Assets (1,301,445) NET INCREASE IN WORKING CAPITAL: $ 1,071,155 The accompanying notes are an integral part of this financial statement. - 21 - Exhibit 5 PROPRIETARY FUND TYPE Enterprise $ 2,263,259 487,656 $ 2,750,915 977,250 5,825,000 115,192 119,145 96,875 202,445 $10,086,822 $ 4,272,541 CITY OF COLLEGE STATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 1980 Exhibit 6 Page 1 of 9 Note 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES: The City of College Station was incorporated in October, 1938. The City operates under a Council -Manager form of government and provides the following services as authorized by its charter: public safety (police and fire), highways and streets, sanitation, utilities, health and social ser- vices, culture -recreation, public improvement, planning and zoning, and general administrative services. The accounting policies of the City of College Station conform to generally accepted accounting principles as applicable to governments. The following is a summary of the more significant policies: A. 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 operations 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 activities are controlled. The various funds are grouped, in the financial statements in this report, into six generic fund types and three broad fund categories as follows: Governmental Funds General Fund - 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. Special Revenue Funds - Special Revenue Funds are used to account for the proceeds of specific revenue sources (other than special assessments, expendable trusts, or major capital project). Debt Service Funds - Debt Service Funds are used to account for the accu- mulation of resources for, and the payment of, general long-term debt principal, interest, and related costs. Capital Projects Funds - Capital Projects Funds are used to account for financial resources to be used for the acquisition or construction of major capital facilities (other than those financed by proprietary funds). Proprietary Funds Enterprise Funds - Enterprise Funds are used to account for operations that are financed and operated in a manner similar to private business enterprises - where the intent of the governing body is that the costs (expenses, including depreciation) of providing goods or services to the general public on a continuing basis be financed or recovered pri- marily through user charges. - 2 2 -- CITY OF COLLEGE STATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 1980 Exhibit 6 Page 2 of 9 Fiduciary Funds Trust and Agency Funds - Trust and Agency Funds are used to account for assets held by the City in a trustee capacity or as an agent for private organizations and for other governments. These include Expendable Trust, Nonexpendable Trust, Pension Trust, and Agency Funds. Nonexpendable Trust and Pension Trust Funds are accounted for in essentially the same manner as proprietary funds since capital maintenance is critical. Ex- pendable Trust Funds are accounted for in essentially the same manner as governmental funds. Agency Funds are custodial in nature (assets equal liabilities) and do not involve measurement of results of operations. B. FIXED ASSETS AND LONG-TERM LIABILITIES The accounting and reporting treatment applied to the fixed assets and long-term liabilities associated with a fund are determined by its measurement focus. All governmental funds and expendable trust funds are accounted for on a spending or "financial flow" measurement focus. This means that only current assets and current liabilities are gen- erally included on their balance sheets. Their reported fund balance (net current assets) is considered a measure of "available spendable resources." Governmental fund operating statements present increases (revenues and other financing sources) and decreases (expenditures and other financing uses) in net current assets. Accordingly, they are said to present a summary of sources and uses of "available spendable resources" during a period. Fixed assets used in governmental fund type operations (general fixed assets) are accounted for in the General Fixed Assets Account Group, rather than in governmental funds. Public domain ("infrastructure") general fixed assets consisting of certain improvements other than buildings, including roads, bridges, curbs and gutters, streets and sidewalks, drainage systems, and lighting systems, are capitalized along with other general fixed assets. No depreciation has been pro- vided on general fixed assets. All fixed assets are valued at historical cost or estimated historical cost if actual historical cost is not available. Donated fixed assets are valued at their estimated fair value on the date donated. Long-term liabilities expected to be financed from governmental funds are accounted for in the General Long -Term Debt Account Group, not in the governmental funds. The two account groups are not "funds." They are concerned only with the measurement of financial position. They are not involved with measurement. of results of operations. -23- 1 CITY OF COLLEGE STATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 1980 Exhibit 6 Page 3 of 9 Because of their spending measurement focus, expenditure recognition for governmental fund types is limited to exclude amounts represented by noncurrent liabilities. Since they do not affect net current assets, such long-term amounts are not recognized as governmental fund type expenditures or fund liabilities. They are instead reported as liabili- ties in the General Long -Term Debt Account Group. All proprietary funds and nonexpendable trust and pension trust funds are accounted for on a cost of services or "capital maintenance" mea- surement focus. This means that all assets and all liabilities (whether current or noncurrent) associated with their activity are included on their balance sheets. Their reported fund equity (net total assets) is segregated into contributed capital and retained earnings components. Proprietary fund type operating statements present increases (revenues) and decreases (expenses) in net total assets. Depreciation of all exhaustible fixed assets used by proprietary funds is charged as an expense against their operations. Accumulated depre- ciation is reported on proprietary fund balance sheets. Depreciation has been provided over the estimated useful lives using the straight line method. The estimated useful lives are as follows: Utility Systems Buildings & Improvements Equipment 25-40 years 5-50 years 4-10 years C. BASIS OF ACCOUNTING Basis of accounting refers to when revenues and expenditures or expenses are recognized in the accounts and reported in the financial statements. Basis of accounting relates to the timing of the measurements made, re- gardless of the measurement focus applied. All governmental funds and expendable trust funds are accounted for using the modified accrual basis of accounting. Their revenues are re- cognized when they become measurable and available as net current assets. Taxpayer -assessed income, gross receipts, and sales taxes are considered "measurable" when in the hands of intermediary collecting governments and are recognized as revenue at that time. Anticipated refunds of such taxes are recorded as liabilities and reductions of revenue when they are measurable and their validity seems certain. Expenditures are generally recognized under the modified accrual basis of accounting when the related fund liability is incurred. Exceptions to this general rule include: (1) accumulated unpaid vacation, sick pay, and other employee amounts which are not accrued; and (2) prin- cipal and interest on general long-term debt which is recognized when due All proprietary funds and nonexpendable trust and pension trust funds 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. Unbil1ed Utility Fund utility service receiva- bles are recorded at year end. 24 -- CITY OF COLLEGE STATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 1980 Exhibit 6 Page 4 of 9 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 follow- ing July 1. The operating budget includes proposed expenditures and the means of financing them. 2) A public hearing is conducted to obtain taxpayer comments. 3) Prior to July 1, the budget is legally enacted through passage of an ordinance. 4) The City Manager is authorized to transfer budgeted amounts between departments within any fund; however, any revisions that alter the total expenditures of any fund must be approved by the City Council. 5) Formal budgetary integration is employed as a management control device during the year for the General Fund, Special Revenue Funds, Debt Service Funds, and Enterprise Funds. 6) Budgets for the General, Special Revenue, Debt Service Funds, and Enterprise Funds are adopted on a basis consistent with generally accepted accounting principles (GAAP). Budgeted amounts are as originally adopted, or as amended by the City Council prior to June 27, 1980. Individual amendments were not material in relation to the original appropriations which were amended. E. ENCUMBRANCES Encumbrance accounting, under which purchase orders, contracts, and other commitments for the expenditure of monies are recorded in order to re- serve that portion of the applicable appropriation, is employed as an extension of formal budgetary integration in the General Fund and Special Revenue Funds. Encumbrances outstanding at year end are re- ported as reservations of fund balances since they do not constitute expenditures or liabilities. F. INVESTMENTS Investments in time -deposit certificates are stated at cost. Amounts of cash held in passbook savings accounts at year end are included as part of the cash balances on the financial statements. G. INVENTORY Inventory is valued at cost (first -in, first -out). Inventory in the General, Special Revenue and Enterprise Funds consists of expendable supplies held for consumption. The cost is recorded as an expenditure at the time individual inventory items are consumed. H. ADVANCE TO OTHER FUNDS Current portions of long-term interfund loans receivable (reported in "Due from" asset accounts) are considered "available spendable resources." -- 2 5 - 1 CITY OF COLLEGE STATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 1980 Exhibit 6 Page 5 of 9 I. EMPLOYEES' RETIREMENT PLAN All city employees under age 55 who have at least ninety days of service as a permanent, full-time city employee, are eligible for coverage under the Texas Municipal Retirement System. An amount equal to five percent of the employee's base salary is contri- buted to the plan by the participant, and the City contributes an amount equal to ten percent of the employee's base salary. Covered employees do not become vested in program benefits until completing ten years of service. J. OTHER EMPLOYEE BENEFITS Employees are credited with vacation at rates from ten to fifteen days per year, depending upon length of service. Carryover of unused vaca- tion time from one year to the next is allowed for a maximum of two years. If an employee terminates, he is compensated 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 accu- mulated sick leave is not made to employees by the City. The City of College Station offers, as an additional benefit to employees, a major medical and term life insurance plan. The premium of full time employees with at least ninety days of service is paid in full by the City. Employees may add any number of dependents at their own cost. K. TOTAL COLUMNS ON COMBINED STATEMENTS - OVERVIEW Total columns on the Combined Statements - Overview are captioned Memorandum Only to indicate that they are presented only to facilitate financial analysis. Data in these columns do 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. Note 2 - PROPERTY TAX Property taxes attach as an enforceable lien on property as of January 1. Taxes are levied on and payable July 1. The City bills and collects its own property taxes. City property tax revenues are recognized when levied to the extent that they result in current receivables. 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 long-term debt. The combined current tax rate to finance general governmental services and payment of princi- pal and interest on long-term debt for the year ended June 30, 1980 was $ .39 per $100, which means that the City has a tax margin of $2.11 per $100 and could raise up to $63,171,394 additional a year from the present assessed valuation of 5293,904,940 before the limit is reached. - 2 6 - CITY OF COLLEGE STATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 1980 Exhibit 6 Page 6 of 9 Note 3 - CHANGES IN LONG-TERM DEBT The following is a summary of bond transactions for the City of College Station for the year ended June 30, 1980: Bonds Payable at July 1, 1979 New Bonds Issued: 1979 Utility System Revenue Bonds Bonds Retired Bonds Payable at June 30, 1980 General Obligation Revenue Total $12,600,000 $4,079,000 $16,679,000 6,145,000 6,145,000 (655,000) (402,000) (1,057,000) $11,945,000 $9,822,000 $21,767,000 $722,498 is available in the Debt Service Funds to service the General Obli- gation bonds. Note 4 - BOND DEBT SERVICE REQUIREMENTS General obligation bond ordinances require that during the period in which the bonds are outstanding, the City must create and maintain interest and sinking funds to be used for servicing their retirement. Further require- ments call for a continuing direct ad valorem tax upon all taxable property, to be levied and collected, sufficient to pay current interest and to create a sinking fund of not less than two per cent (2%) of the principal amount of outstanding bonds, or of not less than the amount required to pay the principal payable out of said tax whichever is greater. City Ordinance No. 1026 adopted June 26, 1976 further requires that the City Council consider applying net revenues from the Utility Fund to the retirement of that portion of General Obligation Bonded Indebtedness used to finance Utility System Construction before levying a tax for that pur- pose. During the past fiscal year, Council chose to effectively appro- priate earnings for that purpose by adopting a budget for the Utility Fund that included a transfer to the debt service for retirement of General Obligation Bonded Indebtedness. Revenue bond ordinances require creation of Bond Funds (interest and sinking funds) into which the Utility Fund deposits 100 per cent of the amount required to meet the interest and principal payments falling due on or before the next maturity date of the bonds. In addition, the Utility Fund is required to pay into the Bond Funds twenty per cent (20%) of the above required amount annually until such time as there is in the Bond Funds an amount sufficient to meet the interest and principal payments falling due on or before the next maturity date of the bonds plus the interest and principal payments on the bonds for one year thereafter. - 2 7 - CITY OF COLLEGE STATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 1980 Exhibit 6 Page 7 of 9 Note 5 CAPITAL IMPROVEMENTS PROGRAM Construction of numerous capital improvements by the City during the year ended June 30, 1980, was financed primarily by general obligation and revenue bonds. Capital improvements accounted for in the City's Capital Project Funds include both general fixed assets and utility fixed assets financed primarily by general obligation bonds. Capital improvements financed by revenue bonds are accounted for in the City's Utility Fund. Appropriated fund balances within the Capital Project Funds represent the unexpended original authorization (or expenditures over the original au- thorization) for each project financed by the respective bond funds. The contract balances in excess of amounts paid or accrued are not encumbered in the Capital Project Funds. A summary of beginning capital improvement authorizations (by financial source) for improvements under construction is as follows: Capital Improvement Streets Parks Police Station, Fire Station, City Hall, & Warehouse Water System Sewer System Electrical System Totals General Utility Obligation Revenue Bonds Bonds $ 1,400,000 $ 2 ,235 ,000 2,010,000 2,475,000 2,040,000 2,725,000 $12,885,000 5,300,000 845,000 3,000,000 $9,145,000 A summary of construction -in -progress on capital improvements at June 30, 1980, is as follows: Capital Improvement Water System Electrical System Streets Parks Miscellaneous Totals General Fixed Assets 652 ,287 637,733 5,574 Utility Fixed Assets $ 2,363,003 841,897 $1,295,594 $3,204,900 Note 6 PREPAID WATER COSTS On November 8, 1978, the City entered into an agreement with Texas A & M University (TAMU), whereby the City would construct water system improve- ments for TAMU. This water system provides the City with an additional water source until its own system can be constructed, beginning January 25, 1979, not to exceed a period of five (5) years. The costs of the system are being repaid by TAMU at a rate of $0.20 (twenty cents) per 1,000 gallons of City water usage. Termination of the agreement provides for absolute title to the system to be conveyed to TAMU by the City. A summary of the unrecovered cost of the water system at June 30, 1980 is as follows: -28- CITY OF COLLEGE STATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 1980 Total Project Costs Less Accumulated Water Usage Credits Prepaid Water Costs June 30, 1980 $1,167,076 (286,189) $ 880,887 Exhibit 6 Page 8 of 9 Note 7 - LITIGATION The City is contingently liable in respect of law suits and other claims in the ordinary course of its operations. The settlement of such contingencies under the budgetary process would require appropriation of revenues for liabilities yet to be realized and would not materially affect the financial position of the City at June 30, 1980. Note 8 - CHANGES ADOPTING GENERALLY ACCEPTED ACCOUNTING PRINCIPLES At June 30, 1979, the City had accrued and recorded in the Debt Service Fund a liability for interest expense on General Long -Term Debt. Generally accepted accounting principles do not permit accrual of interest between maturity dates on general obligation debt. The net adjustment to fund balance of the Debt Service Fund amounted to $114,021. Revenue bonds payable within the Utility Fund at June 30, 1979, reflected the balance due on general obligation bonds issued for utility improvements. Repayment of this portion of general obligation bonds is pledged per the bond indentures by ad valorem tax revenues of the City. Accordingly, this debt has been reclassified to the general long-term debt group of accounts for the year ended June 30, 1980. Adjustments to retained earnings of the Utility Fund are as follows: Balances of general obligation bonds payable in the Utility Fund $6,687,463 Less: Bond Proceeds recorded as contra account (3,472,675) Net Increase in Retained Earnings $3,214,788 Note 9 - OTHER REQUIRED INDIVIDUAL FUND DISCLOSURES Generally accepted accounting principles require disclosure, as part of the Combined Statements - Overview, of certain information concerning individual funds including: A. Segment information for certain individual Enterprise Funds. This re- quirement is effectively met in this report by Exhibits 21-31. B. Summary disclosures of debt service requirements to maturity for all types of outstanding debt. This requirement is met by Table XI. C. Summary disclosures of changes in general fixed assets by major asset class. This requirement is met by Exhibit 33. D. Summary disclosures of changes in general long-term debt. This require- ment is met by Note 3. --29- i CITY OF COLLEGE STATION NOTES TO FINANCIAL STATEMENTS JUNE 30, 1980 Exhibit 6 Page 9 of 9 E. Excesses of expenditures over appropriations in individual funds. Hotel/ Motel Tax Fund expenditures of $213,850 exceeded appropriations of $61,800. Debt Service Fund expenditures of $1,567,169 exceeded appro- priations of $1,386,249. F. Deficit fund balances or retained earnings balances of individual funds. No funds reflected such balances at June 30, 1980. G. Individual fund interfund receivable and payable balances. Such balances at June 30, 1980 were: Fund General Fund Special Revenue: Revenue Sharing Fund Hotel/Motel Tax Fund Debt Service Fund Capital Projects: Community Development 1971 Bond Funds 1976 Bond Funds 1978 Bond Funds 1978 II Bond Funds Enterprise Fund: Utility Fund - Operating Utility Fund - Restricted Sanitation Fund Trust & Agency: Cemetery - Perpetual Care Interfund Interfund Receivables Payables $ 724,808 $ 97,553 1,103,709 5,137 1 ,211 ,537 859,034 847,820 495,894 964,730 95,467 2,527 244,848 101,575 538,712 9,750 1 ,142,561 88,241 706,990 1,246,915 2,133,518 $6,310,663 $6,310,663 -30- COMBINING STATEMENTS BY FUND TYPE CITY OF COLLEGE STATION COMBINING BALANCE SHEET - ALL SPECIAL REVENUE FUNDS JUNE 30, 1980 Exhibit 7 Hotel/ Totals Revenue Motel June 30, Sharing Tax 1980 ASSETS Cash $ 98,371 $ 27,572 $125,943 Certificates of Deposit 298,000 299,000 597,000 Accrued Interest Receivable 1,025 1,025 Accounts Receivable - Miscellaneous 76 76 Due From Federal Government 62,690 62,690 TOTAL ASSETS: $459,137 $327,597 $786,734 LIABILITIES AND FUND BALANCE LIABILITIES: Due to General Fund $ 8,512 $ 153 $ 8,665 Due to Utility Fund 36,336 101,422 137,758 Due to 1976 Bond Funds 200,000 200,000 Accounts Payable 1,459 306 1,765 Total Liabilities $246,307 $101,881 $348,188 FUND BALANCE: Fund Balance - June 30, 1980 212,830 225,716 438,546 TOTAL LIABILITIES AND FUND BALANCE: $459,137 $327,597 $786,734 The accompanying notes are an integral part of this financial statement. - 31 - CITY OF'COLLEGE STATION COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE ALL SPECIAL REVENUE FUNDS FOR THE YEAR ENDED JUNE 30, 1980 REVENUES AND CONTRIBUTIONS: Contributions - Federal R9V8DU8 Sharing ReV0DU8s - Hotel/Motel Occupancy Tax Interest Earnings OD Investments Total R8YeDUeS and Contributions Exhibit 8 Hotel/ Totals Revenue Motel June 30, 5h Tax l980 $244,935 $ ---- $244,935 ---- 189,023 189,023 30,246 19,223 49,469 -- JT_ 08�.4-6 983,A25' EXPENDITURES: C0v-uibUti0ntV Mental Health and Retardation $ 9,500 $ $ 9,500 Contribution t0 Bryan pUb]iC Library 15,000 15,000 Contribution 'to Chamber Of Commerce --]7,500 17,500 Contribution to DraZO5 COVDtY Arts Council 20,500 20,500 ~ Contribution to Hospitality In -formation 22000Or0�tiOD Center , , Contribution to Parks and Recreation l,45q 885 2,344 '` ---' 59� 34Z,5ql Contribution to Other Funds 342,591 52rViCe3 2,917 2,917 Miscellaneous Expenditures 39 39 Capital Outlay - l�O00q 150009 LdD� Acquisition --- , _ 7�}i�� 85U ffU Total Expenditures T3_6_ 5�� z-` __- ������ EXCESS OF EXPENDITURES OVER REVENUES: � Fund Balance - July ], 1979 Adjustment for ACC0UDtS Payable Not Accrued in Prior Year Adjusted Fund Balance - July l, 1079 (Q $(5,6O4) 336,274 $231,320 $567,594 FUND BALANCE - JUNE 301980 S212J830 $225,716 � The accompanying notes are an 'integral part of thiS finaUCial statement. -32- CITY Or COLLEGE STATION COMBINING BALANCE SHEET - ALL CAPITAL PROJECT FUNDS jUNE 30, 1980 1971 Community Bond Development Funds ASSETS Cash in Bank $ 5,001 S 1,738 Certificates Of Deposit 200,000 Accrued Interest UD Certificates of Deposit 8,246 Due From Federal Government 19"771 Due From Fr00 Other Funds 5,137 LIABILITIES AND FUND BALANCES LIABILITIES: Contracts and Accounts Payable RetdiDag8 Payable - Contractors Due To Other Funds TOTAL LIABILITIES FUND BALANCES (DEFICITS): Appropriated For Genera-1 FiX9d Assets Street Improvements Park Improvements Police Station, Fire Station & WDrCh0U52 City Hall Expansion Appropriated for Utility Fixed Assets Water System Improvements Sewer Sys -Lem Improvements Electrical System Improvements Unappropriated TOTAL FUND BALANCES TOTAL LIABILITIES AND FUND BALANCES: 12,125 2,897 9,750 24,772 � ~ Exhibit 9 1976 Bond FVnds 86 l30,OOO $215,l21 $ 183,222 15.12 The accompanying notes are an integral part of this financial statement. /28,455\ 841 ,O9l /797,396\ Sl 34l 623 - 33 - 1978 1978 Series II 80Dd Bond Funds Funds $ 303,839 $ 148,671 1,630,000 803,000 12,341 8,252 859,034 847,820 $2,805,214 $1,807,743 $ 76,893 45,517 88,241 $ 210,651 $ 34,396 42,445 747 Gl,724 2,455,251 $2,594,563 S2,805,2l4 $ 112,297 35,042 706,990 $ 854,329 $ ]94,973 687,365 70,553 523 953,414 $l807,743 Totals June 30, 1980 � 459,335 2,76],OOO 28,839 19,771 2,923,528 $6,194,473 $ 201 ,315 83,456 1,947,542 $2,232,313 $ 627,712 729,810 70,553 /28,455\ 842,438 /735,672l 2,455,251 523 $3,962,160 $6,194,473 - 34 - CITY OF COLLEGE STATION COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES - ALL CAPITAL PROJECT FUNDS FOR THE YEAR ENDED JUNE 30, 1980 Exhibit 10 1971 Community Bond Development Funds REVENUES: Earnings on Investments $ $ 20,417 Federal Grants 425,264 State Grants Contribution From B.V.D.C. Lincoln Center Total Revenues $425,264 $ 20,417 EXPENDITURES: General Fixed Assets Land $ 5,052 $ Street Improvements 222,484 Park Improvements Police Station, Fire Station, & Warehouse City Hall Expansion Office Equipment 1,466 Utility Fixed Assets Water System Improvements 2,690 Sewer System Improvements Electrical System Improvements Federal Housing Rehabilitation 150,186 Administrative & Other Costs 43,386 Total Expenditures $425,264 $ EXCESS OF REVENUES OVER (UNDER) EXPENDITURES: $ $ 20,417 TRANSFERS: To Debt Service Fund $ $ 17,363 EXCESS OF REVENUES OVER (UNDER) EXPENDITURES & TRANSFERS: $ $ 3,054 Fund Balances - July 1, 1979 212,067 FUND BALANCES - JUNE 30, 1980: $ $215,121 The accompanying notes are an integral part of this financial statement. - 3 5 - 1978 1976 1978 Series II Bond Bond Bond Funds Funds Funds $ 27,639 $ 225,079 $ 152,500 116,322 18,596 8,532 $152,493 $ 243,675 $ 152,500 37,601 179,608 843 443,034 (12,862) $648,224 ($495,731) $ 27,639 ($523,370) 722,432 $199,062 33,478 23,313 2 ,072 7,021 473,468 $ 539,352 $ (295,677) $ 225,079 $ (520,756) 3,115,319 $2,594,563 $ 269,052 272,443 276 ,593 202 ,992 $1,021,080 $ (868,580) $ 193,978 ($1,062,558) 2,015,972 $ 953,414 Totals June 30, 1980 $ 425,635 425 ,264 134,918 8,532. $ 994,349 $ 274,104 566 ,006 479,514 205,064 843 1,466 445,724 (5,841) 473,468 150,186 43,386 $2,633,920 ($1,639,571) $ 464,059 ($2,103,630) 6 ,065 ,790 $3,962,160 CITY OF COLLEGE STATION COMBINING BALANCE SHEET ALL ENTERPRISE FUNDS JUNE 30, 1980 ASSETS CURRENT ASSETS: Cash on Hand and in Bank Certificate of Deposit Accounts Receivable - Utility Billings (Net of $338,570 Allowance for Doubtful Accounts) Accounts Receivable - Other Inventories Due From Other Funds Total Current Assets RESTRICTED ASSETS: Cash - Customers' Meter Deposits Cash - Revenue Bond Interest & Sinking Certificates of Deposit - Revenue Bond I & S Accrued Interest Receivable on C.D. Cash, Receivables & Inventories - Utility Projects Total Restricted Assets FIXED ASSETS: (Net of Accumulated Depreciation) DEFERRED CHARGES: Prepaid Water Costs Bond Issuance Costs Total Deferred Charges TOTAL ASSETS: Exhibit 11 Utility Sanitation Totals Fund Fund June 30, 1980 $ 895,898 350,000 1,085,433 40,481 426 ,821 495,894 $ 3,294,527 $164,741 338 3,524 95,467 $264,070 $ 90,956 $ 182,956 1,129,657 39,087 7,079,101 $ 8,521 ,757 -` $15,606,686 $ 880,887 80,404 $ 961,291 $ 1,060,639 350,000 1,085,433 40,819 430,345 591,361 $ 3,558,597 $ 90,956 182,956 1,129,657 39,087 7,079,101 $--87521 ,757 $163,546 $15,770,232 $ $ 880,887 80,404 $ - $ 961,291 $28,384,261 $427,616 $28,811,877 The accompanying notes are an integral part of this financial statement. -37- LIABILITIES CURRENT LIABILITIES: Payable From Current Assets: Accounts Payable Sales Tax Payable Due to Other Funds Due to Escrowed Construction Funds Payable From Restricted Assets: Accounts Payable Construction Contracts Retainage Payable Accrued Interest Payable Revenue Bonds Payable (Current Portion) Due to Other Funds Total Current Liabilities OTHER LIABILITIES: Customers' Meter Deposits Revenue Bonds Payable (Long Term Portion) Total Other Liabilities TOTAL LIABILITIES: FUND EQUITY CONTRIBUTIONS: (Exhibit 12) RETAINED EARNINGS - JUNE 30, 1980: TOTAL FUND EQUITY: TOTAL LIABILITIES AND FUND EQUITY: Utility Sanitation Totals Fund Fund June 30, 1980 $ 578,227 13,920 1 ,199,498 47,417 924,418 235,680 230 ,626 443,000 2,133,518 $ 5,806,304 $ 534,089 9,381,258 $ 9,915,347 $15,721,651 $ 7,175,783 $ 5,486,827 $12,662,610 $28,384,261 $ 3,833 $ 582,060 13,920 1,199,498 47,417 924,418 235,680 230,626 443,000 2,133,518 $ 3,833 $ 5,810,137 $ $ 534,089 9,381 ,258 $ $ 9,915,347 $ 3,833 $15,725,484 $ 54,901 $368,882 $423,783 $427,616 $ 7,230,684 $ 5,855,709 $13,086,393 $28,811,877 - 3 8 - CITY OF COLLEGE STATION COMBINING STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN FUND EQUITY ALL ENTERPRISE FUNDS FOR THE YEAR ENDED JUNE 30, 1980 Exhibit 12 OPERATING REVENUES: Electric Sales and Fees Water Sales and Fees Sewer Sales and Fees Sanitation Sales and Fees Dumpster Sales Miscellaneous Income Total Operating Revenue OPERATING EXPENSES: Electric & Water Production & Distribution Sewer & Sanitation Collection & Disposal Non -Departmental Operating Expense Depreciation Total Operating Expenses OPERATING INCOME: NON -OPERATING REVENUES (EXPENSES): Interest Earnings - Time Deposits Interest Earnings - Escrowed Construction Funds Amortization of Bond Premium Revenue Bond Interest Expense Amortization of Revenue Bond Issuance Costs Transfer to Debt Service EXCESS OF REVENUE OVER EXPENSES: ADJUSTED RETAINED EARNINGS - JULY 1, 1979: RETAINED EARNINGS - JUNE 30, 1980: ADJUSTED CONTRIBUTED CAPITAL - JULY 1, 1979: Add: Contributions 1979-80 FUND EQUITY - JUNE 30, 1980: Utility Fund $ 8,336,194 $ 1 ,326,433 572,778 88,606 $10,324,011 $ 5 ,816 ,885 376,777 1 ,665,938 442,389 $ 8,301 ,989 $ 2,022,022 Sanitation Totals Fund June 30, 1980 $ 8,336,194 1,326,433 572,778 602,511 602,511 16,337 16,337 12 88,618 $618,860 $10,942,871 $ $ 5,816,885 313,312 690,089 19,044 1,684,982 45,267 487,656 $377,623 $ 8,679,612 $241,237 $ 2,263,259 115,192 615,912 282 (540,740) (4,404) (706,508) $ 1 ,501 ,756 $241 ,237 3,985,071 127,645 $ 5,486,827 $368,882 4,048,188 3,127,595 54,901 $12,662,610 $423,783 The accompanying notes are an integral part of this financial statement. 115,192 615,912 282 (540,740) (4,404) (706,508) $ 1,742,993 4,112,716 $ 5,855,709 4,048,188 3,182,496 $13,086,393 - 3 9 - CITY OF COLLEGE STATION COMBINING BALANCE SHEET - ALL TRUST AND AGENCY FUNDS JUNE 30, 1980 ASSETS Cash Certificate of Deposit Accrued Interest Receivable Due From General Fund TOTAL ASSETS: FUND BALANCE TOTAL FUND BALANCE - JUNE 30, 1980 Firemen's Relief & Retirement $ 15 TPAA Utility Lobby $ $ 15 $ $ 15 $ Exhibit 13 Cemetery - Perpetual Care $ 8,026 15,900 430 2,527 Totals - June 30, 1980 $ 8,041 15,900 430 2,527 $26,883 $26,898 $26,883 $26,898 The accompanying notes are an integral part of this financial statement. -40- 1 CITY OF COLLEGE STATION COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE ALL TRUST AND AGENCY FUNDS FOR THE YEAR ENDED JUNE 30, 1980 REVENUES AND CONTRIBUTIONS: Contributions - State Contributions - Participants Contributions - General Fund Interest Earnings Fees From Plot Sale Proceeds Total Revenues and Contributions Firemen's TPAA Relief & Utility Retirement Lobby $ 1,500 $ 40 40,044 2,600 238 $ 4,140 $40,282 Exhibit 14 Cemetery - Perpetual Care 2,072 1,078 $ 3,150 Totals - June 30, 1980 $ 1,500 40,084 2,600 2,310 1 ,078 $47,572 EXPENDITURES: Pension Payments $ 4,100 $ $ $ 4,100 Legal Expenses 7,136 7,136 Miscellaneous Expense 262 262 Total Expenditures 7,398 $11,498 REVENUES OVER EXPENDITURES $32,884 $36,074 Fund Balance - July 1, 1979 $ (25) $ $ (25) Adjustment for Prior Year Accounts (32,884) Payable Previously Unrecorded (32,884) Adjustment for Transfer of Reserve for Perpetual Care Fund From Former Cemetery Fund (Operating & Perpetual 23,692 23,692 Care Combined) Adjustment for Error in Recording 41 41 Prior Year Revenue Adjusted Fund Balance July 1, 1979 $ (25) ($32,884) $23,733 $(9,176) FUND BALANCES - JUNE 30, 1980: $ 4,100 $ 40 $ 15 $ $26,883 $26,898 The accompanying notes are an integral part of this financial statement. - 41 - INDIVIDUAL FUND AND ACCOUNT GROUP STATEMENTS CITY OF COLLEGE STATION GENERAL FUND BALANCE SHEET JUNE 30, 1980 ASSETS Cash on Hand and in Bank Certificates of Deposit Accrued Interest Receivable Delinquent Taxes Receivable Paving Assessments Receivable Accounts Receivable - Grants Accounts Receivable - Ambulance Services Accounts Receivable - Cemetery Plot Sales Accounts Receivable - Other Due From Other Funds Inventories Exhibit 15 $ 38,448 760,000 24,015 33,413 4,388 17,882 16,434 2,708 1 ,776 724,808 39,428 TOTAL ASSETS: $1,663,300 LIABILITIES AND FUND BALANCE LIABILITIES: Accounts Payable Due to Other Funds Due to Southgate Village for Paving Assessments Refundable Deposits Municipal Court Fees Payable Total Liabilities FUND BALANCE: Reserved for Encumbrances Reserved for Purchase of Parks Reserved for Uncollected Taxes Reserved for Uncollected Ambulance Accounts Receivable Reserved for Uncollected Cemetery Accounts Receivable Total Reserved Fund Balance Unreserved Fund Balance - June 30, 1980 $ 88,551 63,354 33,413 11,423 2,648 $ 199,389 1,271,723 $ 81 ,607 97,553 5,142 6,236 1 ,650 $ 192,188 1,471,112 TOTAL LIABILITIES AND FUND BALANCE: $1,663,300 The accompanying notes are an integral part of this financial statement. -42- CITY or COLLEGE STATION GENERAL FUND STATEMENT OF CHANGES IN FUND BALANCE FOR THE YEAR ENDED JUNE 30, 1980 FUND BALANCE - JULY 1, 1979: Adjustment for Transfer of Accounts Receivable to Utility Fund (Net of Reserve for Uncollectibles) Adjustment to Correctly Accrue Prior Year Accounts Payable Adjustment to Fully Reserve and Reclassify Prior Year Delinquent Taxes Receivable Adjustment to Reclassify Prior Year Reserves for Uncollectible Accounts Receivable and Monies Held for Purchase of Parks Previously Shown as a Contra Asset and Liability, Respectively Adjustment to Transfer Assets and Liabilities (Net) From Former Cemetery Fund to General Fund Adjustment to Transfer Long Term Liability to General Long Term Debt Group of Accounts Adjustment to Transfer Assets and Liabilities (Net) to Sanitation Fund $ 829,703 (24,005) (46,184) 1 ,467 77,538 69,252 24,731 6,001 Exhibit 16 ADJUSTED FUND BALANCE - JULY 1, 1979: $ 938,503 Add: Excess of Revenues Over Expenditures Revenues and Transfers (Exhibit 17) Expenditures (Exhibit 18) Add: (Deduct): Increase in Reserve for Purchase of Parks Increase in Reserve for Uncollected Taxes Increase in Reserve for Cemetery Accounts Receivable (Decrease in Reserve for Ambulance Accounts Receivable) $4,234,108 3,733,099 $ 5,516 31,713 2,648 (8,277) 501 ,009 31 ,600 TOTAL FUND BALANCE - JUNE 30, 1980: $1,471,112 The accompanying notes are an integral part of this financial statement. - 43 - CITY OFCOLLEGE STATION GENERAL FUND STATEMENT OF REVENUES AND TRANSFERS - ESTIMATED AND REALIZED FOR THE YEAR ENDED JUNE 30, 1980 TAXES: Current Ad Valorem Delinquent Ad Valorem Tax Penalty and Interest Franchise Taxes Mixed Drinks Tax Sales Tax Total Taxes LICENSES: Electricians Animal Taxi Game Machine Total Licenses PERMITS: Builder Electrical Plumbing Air Conditioning Mixed Drink Health Total Permits SERVICE FEES: Court Cost Pound Miscellaneous Total Service Fees FINES: Municipal Court Total Fines CERTIFICATES: Birth & Death Tax Total Certificates Estimated $ 441 ,253 18,000 4,500 122,000 32,000 1,140,507 $1,758,260 Realized $ 420,789 19,262 4,291 115,810 38,827 1,065,314 $1,664,293 1,200 $ 1,150 275 289 1,000 30 1,000 1,793 3,475 $ 3,262 $ 38,000 2,550 2,550 5,100 1 ,000 500 $ 49,700 $ 3,000 2,200 $ 5,200 $ 44,698 10,436 17,894 2,283 350 $ 75,661 $ 3,310 2,038 19 $ 5,367 Exhibit 17 Page 1 of 2 Variance Favorable (Unfavorable) $(20,464) 1 ,262 (209) (6,190) 6,827 (75,193) $(93,967) $ (50) 14 (970) 793 $ (213) $ 6,698 7,886 15,344 (5,100) 1 ,283 (150) $ 25,961 $ 310 (162) 19 $ 167 $ 288,000 $ 315,514 $ 27,514 288,000 $ 315,514 $ 27,514 $ 500 $ 193 $ (307) 2,000 1,483 (517) $ 2,500 $ 1,676 $ (824) -44- CITY OF COLLEGE STATION GENERAL FUND STATEMENT OF REVENUES AND TRANSFERS - ESTIMATED AND REALIZED FOR THE YEAR ENDED JUNE 30, 1980 CITY SERVICES PROVIDED: Contributions from County for Fire Ambulance Service Accident Coding Sale of Ordinances Art and Cultural Program Swimming Pool Admission Swimming Pool Concessions Swimming Pool Instruction Thomas Pool Admission Thomas Pool Concessions Adult Sports Program Youth Sports Program Opening Graves Sale of Cemetery Plots Total City Services Provided MISCELLANEOUS: Grant Reimbursements Paving Assessments Earnings on Investments Use of City Equipment, Materials & Labor Park Fees Other Revenues Total Miscellaneous TOTAL REVENUES: TRANSFERS: From Utility Fund From Revenue Sharing Fund Total Transfers TOTAL GENERAL FUND REVENUES AND TRANSFERS: Estimated Realized $ 10,000 18,000 500 500 1,000 28,500 2,200 25,600 9,400 3,800 1,500 6,000 9,269 107,000 $ 103,883 $ 11,978 13,461 154 6 611 28,078 430 19,875 1 ,269 251 13,455 5,046 $ 113,405 $ 87,430 15,000 10,000 35,333 30,000 530 5,000 2,169 3,300 16,934 $ 176,705 $ 142,396 $2,390,840 $2,312,052 $1 ,634,366 $1 ,634,366 287,690 287,690 $1,922,056 $1,922,056 $4,312,896 $4,234,108 The accompanying notes are an integral part of this financial statement. Exhibit 17 Page 2 of 2 Variance Favorable (Unfavorable) $ 1,978 (4,539) (346) (494) (389) (422) (1,770) (5,725) 1 ,269 251 4,055 1 ,246 (1,500) 3,269 $ (3,117) $(25,975) (15,000) 25,333 (29,470) (2,831) 13,634 $(34,309) $(78,788) $ $(78,788) - 4 5 - CITY OF COLLEGE STATION GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH APPROPRIATIONS FOR THE YEAR ENDED JUNE 30, 1980 ADMINISTRATION: Administration / City Manager: Salaries & Benefits Supplies Building Maintenance Equipment Maintenance Services Sundry Capital Outlay - Equipment Capital Outlay - Motor Vehicles Total Administration / City Manager Personnel: Salaries & Benefits Supplies Equipment Maintenance Services Sundry Capital Outlay - Equipment Total Personnel TOTAL ADMINISTRATION: PLANNING: Salaries & Benefits Supplies Equipment Maintenance Services Sundry Capital Outlay - Equipment Capital Outlay - Motor Vehicles TOTAL PLANNING: FINANCE: Fiscal Administration: Salaries & Benefits Supplies Equipment Maintenance Services Sundry Total Fiscal Administration 234,039 80,183 7,400 1,900 8,428 1,710 4,293 5,500 Budget $ 89,263 4,171 1,640 104,218 3,497 1 ,862 6,029 $ 210,680 Exhibit 18 Page 1 of 8 Variance Favorable Actual (Unfavorable) $ 88,883 5,526 7 482 101 ,900 2,390 1,762 6,289 207,239 19,105 $ 19,317 810 494 75 36 919 927 1,640 1,698 810 810 23,359 $ 23,282 $ 230,521 $ 54,786 4,456 377 5,347 1 ,918 4,587 4,680 109,414 $ 76,151 $ 380 (1 ,355) (7) 1 ,158 2,318 1,107 100 $ 260) 3,441 $ (212) 316 39 (8) (58) $ 77 $ 3,518 $ 25,397 2,944 1,523 3,081 (208) (294) 820 $ 33,263 43,614 $ 42,902 $ 712 3,430 3,706 (276) 600 153 447 10,306 10,302 4 880 867 1 58,830 57,930 $ 900 -46- CITY OF COLLEGE STATION GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH APPROPRIATIONS FOR THE YEAR ENDED JUNE 30, 1980 Budget Actual Accounting: Salaries & Benefits $ 59,423 $ 54,634 Supplies 5,190 4,507 Equipment Maintenance 150 118 Services 26,860 10,639 Sundry 60 54 Capital Outlay - Equipment 4,506 3,753 Total Accounting $ 96,189 $ 73,705 Tax & City Secretary: Salaries & Benefits Supplies Equipment Maintenance Services Sundry Capital Outlay - Equipment Total Tax & City Secretary Utilities: Salaries & Benefits Supplies Equipment Maintenance Services Sundry Capital Outlay - Equipment Capital Outlay - Motor Vehicles Total Utilities Purchasing: Salaries & Benefits Supplies Equipment Maintenance Services Sundry Capital Outlay - Equipment Capital Outlay - Motor Vehicles Total Purchasing Warehouse: Salaries & Benefits Supplies Building Maintenance Equipment Maintenance Services Sundry Capital Outlay - Equipment Total Warehouse $ 48,586 $ 45,536 4,765 3,291 272 24 9,939 7,202 5,500 3,401 340 330 69,402 $' 59,784 Exhibit 18 Page 2 of 8 $ 239,447 $ 232,343 22,660 26,985 1,846 1,544 8,320 9,020 1,200 1,156 1,676 1,537 4,844 4,749 $ 279,993 $ 277,334 $ 18,802 $ 17,755 2,900 1,251 500 615 710 670 500 442 1,000 880 6,005 5,999 $ 30,417 $ 27,612 $ 11,010 $ 10,996 360 215 250 85 120 73 612 641 15 12 633 633 $ 13,000 12,655 $ 345 Variance Favorable (Unfavorable) $ 4,789 683 32 16,221 6 753 $ 22,484 $ 3,050 1,474 248 2,737 2,099 10 9,618 $ 7,104 (4,325) 302 (700) 44 139 95 $ 2,659 $ 1,047 1 ,649 (115) 40 58 120 6 2,805 14 145 165 47 (29) 3 -47- CITY OF COLLEGE STATION GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH APPROPRIATIONS FOR THE YEAR ENDED JUNE 30, 1980 Data Processing: Salaries & Benefits Supplies Equipment Maintenance Services Sundry Capital Outlay - Equipment Total Data Processing TOTAL FINANCE: PUBLIC SERVICE: Administration: Salaries & Benefits Supplies Equipment Maintenance Services Sundry Capital Outlay - Equipment Total Administration Streets: Salaries & Benefits Supplies Building Maintenance Equipment Maintenance Services Sundry Capital Outlay - Equipment Capital Outlay - Motor Vehicles Total Streets Building inspection: Salaries & Benefits Supplies Building Maintenance Equipment Maintenance Services Sundry Capital Outlay - Equipment Capital Outlay - Motor Vehicles Total Building Inspection Exhibit 18 Page 3 of 8 Budget Actual $ 20,598 $ 18,199 9,603 10,834 11,500 11,042 2,655 2,846 20 12 100 $-44,376 43,033 $ 592,207 $ 552,053 Variance Favorable (Unfavorable) $ 2,399 (1,231) 458 (191) 8 $1,343 $ 40,154 52,244 $ 52,127 $ 117 2,298 2,187 111 350 100 250 5,328 4,979 349 350 294 56 434 433 1 $ 61,004 60,120 $ 884 168,039 56,275 34,400 46,800 7,050 10,425 400 26,000 349,389 116,849 14,185 5,318 8,702 4,447 621 920 20,904 171,946 98,118 29,005 15,618 17,755 4,265 3,492 37,431 20-5767g $ 69,921 27,270 18,782 29,045 2,785 6,933 400 (11,431) $143,705 $ 111,895 $ 4,954 8,338 5,847 6,169 (851) 6,500 2,202 2,080 2,367 607 , 14 810 110 15,433 . ,471 $ 151,832 $ 20,114 - 48 - CITY OF COLLEGE STATION GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH APPROPRIATIONS FOR THE YEAR ENDED JUNE 30, 1980 Garage: Salaries & Benefits Supplies Building Maintenance Equipment Maintenance Services Sundry Capital Outlay - Equipment Capital Outlay - Motor Vehicles Total Garage Cemetery / Ground Maintenance: Salaries & Benefits Supplies Building Maintenance Equipment Maintenance Services Sundry Capital Outlay - Equipment Capital Outlay - Motor Vehicles Total Cemetery / Ground Maintenance TOTAL PUBLIC SERVICE: POLICE: Police Administration: Salaries & Benefits Supplies Equipment Maintenance Services Sundry Capital Outlay - Equipment Capital Outlay - Motor Vehicles Total Police Administration Uniformed Bureau: Salaries & Benefits Supplies Equipment Maintenance Services Sundry Capital Outlay - Equipment Capital Outlay - Motor Vehicles Total Uniformed Bureau Budget Actual Exhibit 18 Page 4 of 8 91,055 $ 67,448 13,300 11,454 1,300 444 1,766 1,190 3,450 2,891 725 710 5,239 5,028 8,000 6,750 124,835 $ 95,915 23,366 $ 19,087 4,150 6,250 2,200 1,760 1,408 2,380 36 110 106 1 ,300 585 6,000 5,577 41,266 $ 33,049 748,440 $ 546,600 $ 99,975 5,455 2,275 3,227 2,000 1,745 6,550 $ 121,227 $ 374,968 52,231 16,580 1,700 11,380 5,225 41 ,500 $ 503,584 93,125 3,316 1,232 4,149 2,017 6,352 110,191 366,800 50,720 12,410 1 ,694 3,321 2,186 39,969 477,100 Variance Favorable (Unfavorable) $ 23,607 1 ,846 856 576 559 15 211 1,250 $ 28,920 $ 4,279 (2,100) 2,200 352 2,344 4 715 423 $ 8,217 $201 840 $ 6,850 2,139 1 ,043 (922) (17) 1,745 198 $ 11,036 $ 8,168 1,511 4,170 6 8,059 3,039 1 ,531 26,484 -49- CITY OF COLLEGE STATION GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH APPROPRIATIONS FOR THE YEAR ENDED JUNE 30, 1980 Investigation: Salaries & Benefits Supplies Equipment Maintenance Services Sundry Capital Outlay - Equipment Capital Outlay - Motor Vehicles Total Investigation Special Services Bureau: Salaries & Benefits Supplies Building Maintenance Equipment Maintenance Services Sundry Capital Outlay -- Equipment Total Special Services Bureau Municipal Court: Salaries & Benefits Supplies Services Sundry Capital Outlay - Equipment Total Municipal Court TOTAL POLICE: FIRE: Fire Administration: Salaries & Benefits Supplies Equipment Maintenance Services Sundry Capital Outlay - Equipment Total Fire Administration Exhibit 18 Page 5 of 8 Budget Actual $ 76,702 $ 75,816 8,021 5,720 2,840 2,174 2,185 1,965 1 ,975 647 3,625 2,249 6,352 6,352 $ 101,700 $ 94,923 $ 137,574 $ 126,610 15,610 12,426 2,200 2,307 4,900 1,425 33,596 34,701 1 ,600 578 5,148 3,802 I-200,628 181,849 $ 47,600 $ 44,016 6,068 4,833 7,551 7,523 150 104 161 234 $ 61,530 _56,710 988,669 $ 920,773 $ 51 ,859 3,866 1,100 7,810 940 3,115 68,690 Variance Favorable (Unfavorable) $ 886 2,301 666 220 1 ,328 1,376 $ 6,777 $ 10,964 3,184 (107) 3,475 (1,105) 1,022 1,346 18,779 $ 3,584 1 ,235 28 46 73) 4,820 $ 67,896 $ 51,793 $ 66 1,821 2,045 458 642 6,898 912 940 792 2,323 61,762 $ 6,928 -m50- CITY OF COLLEGE STATION GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH APPROPRIATIONS FOR THE YEAR ENDED JUNE 30, 1980 Fire Operations: Salaries & Benefits Supplies Building Maintenance Equipment Maintenance Services Sundry Capital Outlay - Equipment Total Fire Operations Fire Prevention: Salaries & Benefits Supplies Equipment Maintenance Services Sundry Capital Outlay - Equipment Total Fire Prevention Ambulance: Salaries & Benefits Supplies Equipment Maintenance Services Sundry Capital Outlay - Equipment Total Ambulance TOTAL FIRE: ENGINEERING: Engineering Administration: Salaries & Benefits Supplies Equipment Maintenance Services Sundry Capital Outlay - Equipment Total Engineering Administration Budget Actual Exhibit 18 Page 6 of 8 $ 526,713 $ 475,519 29,388 24,224 3,810 4,163 13,850 10,734 16,600 10,957 6,940 6,931 43,535 20,442 $ 640,836 $ 552,970 $ 33,842 $ 33,597 4,369 2,874 2,440 1,368 1,515 1,429 2,923 341 1,502 586 46,591 $ 40,195 $ 17,582 4,427 4,855 834 3,418 3,676 $ 34,792 $ 790,909 $ 17,195 4,780 3,522 344 2,819 3,677 32,337 687,264 34,512 $ 4,200 400 5,472 1 ,650 750 $ 46,984 $ 34,872 4,390 401 4,941 2,217 99 46,920 Variance Favorable (Unfavorable) $ 51,194 5,164 (353) 3,116 5,643 9 23,093 $ 87,866 $ 245 1,495 1,072 86 2,582 916 $ 6,396 $ 387 (353) 1 ,333 490 599 2,455 $103,645 $ (360) (190) (1) 531 (567) 651 $ 64 - 51 - CITY OF COLLEGE STATION GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH APPROPRIATIONS FOR THE YEAR ENDED JUNE 30, 1980 Engineering: Salaries & Benefits Supplies Equipment Maintenance Services Sundry Capital Outlay - Streets Capital Outlay - Equipment Capital Outlay - Motor Vehicles Total Engineering TOTAL ENGINEERING: PARKS: Parks Administration: Salaries & Benefits Supplies Building Maintenance Equipment Maintenance Services Sundry Capital Outlay - Equipment Capital Outlay - Motor Vehicles Capital Outlay - Buildings Total Parks Administration Recreation: Salaries & Benefits Supplies Building Maintenance Equipment Maintenance Services Sundry Capital Outlay - Recreation Equipment Total Recreation Aquatics: Salaries & Benefits Supplies Building Maintenance Equipment Maintenance Services Sundry Capital Outlay - Equipment Capital Outlay - Recreation Equipment Total Aquatics Budget Actual $ 68,790 $ 68,848 30,950 30,823 942 597 63,202 58,904 540 819 364 364 6,240 4,765 12,036 11,849 183,064 $ 176,969 $ 230,048 $ 223,889 $ 43,582 $ 3,630 200 400 8,710 640 1,850 6,500 $ 65,512 $ 32,943 13,489 700 100 16,467 110 858 64,667 $ 112,097 12,345 3,000 5,600 30,750 550 10,880 135 $ 175,357 Exhibit 18 Page 7 of 8 43,784 3,578 57 52 7,264 368 2,470 5,779 1,209 64,561 $ 32,022 10,828 364 44 22,290 408 781 66,737 83,828 12,753 2,782 5,638 22,987 558 8,727 255 $ 137,528 Variance Favorable (Unfavorable) $ (58) 127 345 4,298 (279) 1 ,475 187 $ 6,095 $ 6,159 $ (202) 52 143 348 1 ,446 272 (620) 721 (1,209) $ 951 $ 921 2,661 336 56 (5,823) (298) 77 J2 ,070) $ 28,269 (408) 218 (38) 7,763 (8) 2,153 (120) T-37 ,829 -52 - CITY OF COLLEGE STATION GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH APPROPRIATIONS FOR THE YEAR ENDED JUNE 30, 1980 Parks Maintenance: Salaries & Benefits Suppl ies Building Maintenance Equipment Maintenance Services Sundry Capital Outlay - Equipment Capital Outlay - Motor Vehicles Capital Outlay - Buildings Capital Outlay - Recreation Equipment Total Parks Maintenance Forestry: Salaries & Benefits Supplies Building Maintenance Equipment Maintenance Services Sundry Capital Outlay - Equipment Capital Outlay - Recreation Facilities Total Forestry TOTAL PARKS: Budget Actual $ 121,090 $ 23,220 11,600 9,815 6,880 440 14,287 7,575 4,160 $ 199,067 Exhibit 18 Page 8 of 8 104,439 11,006 11,858 8,543 7,685 421 15,404 7,341 2,966 75 169,738 $ 28,915 $ 5 ,585 20 1 ,500 1,090 150 2,221 8,000 47,481 $ 552,084 NON -DEPARTMENTAL: $ Opening Graves Contribution to Utility Fund 9,000 Contingencies 56,552 Miscellaneous TOTAL NON -DEPARTMENTAL: $ 65,552 TOTAL GENERAL FUND EXPENDITURES: 28,760 2,227 16 827 857 133 1 ,449 3,873 $ 38,142 $ 476,706 $ 100 9,000 3,878 6,164 $ 19,142 Variance Favorable (Unfavorable) $ 16,651 12,214 (258) 1,272 (805) 19 (1,117) 234 1 ,194 75) $ 155 3,358 4 673 233 17 772 4,127 $ 9,339 $ 75,378 $ (100) 52,674 (6,164) $ 46,410 $4,311,362 $3,733,099 $578,263 The accompanying notes are an integral part of this financial statement. - 5 3 - Cash on Hand and in Bank Certificate of Deposit Delinquent Taxes Receivable Due From Utility Fund TOTAL ASSETS: CITY OF'COLLEGE STATION DEBT SERVICE FUND BALANCE SHEET JUNE 30, 1980 ASSETS LIABILITIES, RESERVES, AND FUND BALANCE LIABILITIES: Due to General Fund Matured Interest Coupons Payable Total Liabilities RESERVES: Reserve for Uncollectible Taxes $38,471 Total Reserves FUND BALANCE: Fund Balance - June 30, 1980 TOTAL LIABILITIES, RESERVES, AND FUND BALANCE: The accompanying notes are an integral part of this financial statement. Exhibit 19 $ 17,354 142,000 38,471 1,103,709 $1 ,301 ,534 $ 538,712 1 ,853 540,565 38,471 722 ,498 $1,301,534 - 54 CITY OF COLLEGE STATION DEBT SERVICE FUND STATEMENT OF REVENUES, EXPENDITURES, AND FUND BALANCE FOR THE YEAR ENDED JUNE 30, 1980 REVENUES COLLECTED: - ---' tUrr�D3 |aXe5 Delinquent Taxes Penalty and Interest on Delinquent Taxes Contribution from Utility Fund Contribution from 1971 Bond Funds Contribution fr00 1976 Bond Funds Contribution from 1978 Bond Funds Contribution from 1978 Series II Bond Funds Interest Earned OD Investments DiSC0UDt for Early Retirement of Notes Payable Total ReYeDV83 Exhibit 20 644,558 13,654. 3,622 706,508 17,363 27,639 225,079 193,978 7,258 3,784 EXPENDITURES: Redem--0n of Tax Obligation Bonds $655,000 ' Interest 56q74� �]324743 OO Tax Obligation 8On�S , _ , , Retirement of Notes Payable $229,035 Interest on Notes Payable 13,128 242,164 Paying Agents Fees 262 Total Expenditures EXCESS OF REVENUES OVER EXPENDITURES: IDCr2a58 in Fund Balance Fund Ud]aDC9 - July l, 1979 $ 332,203 l Ad'USt02nt for Interest Improperly Accrued ` ll� A2l in Prior Year ___������� Adjusted Fund Balance - July l, 1979 FUND BALANCE - JUNE 30, l980: The accompanying notes are an integral part Of this financial statement. $l,843,443 l,567,l09 � 275,274 44G2_2>4 -55- � CITY OF COLLEGE STATION UTILITY FUND BALANCE SHEET JUNE 30, 1980 ASSETS CURR[NT ASSETS. �---d in Bank Certificate of Deposit ACCVUOt3 Receivable - Utility Billings Less: Allowance for Doubtful AoCOUDtS ACCOUntS Receivable - Other Due From Other Funds Inventories Total Current Assets RESTRICTED ASSETS: JDk 3tO0erS/ Meter Deposits Cash in Bank - ReV2DU8 Bond Interest & Sinking Certificates of Deposit - Revenue Bond Interest & Sinking Due From Utility Operating - Revenue Bond Interest & Sinking Accrued Interest Receivable on Certificates of Deposit 1978 Bond Fund: Cash in Bank Due From Other Funds Inventories ]979 Bond Fund: Cash in Bank Certificates Of Deposit Accrued Interest Receivable OU Certificates of Deposit Due From Other Funds Total Restricted Assets FIXED ASSETS: Land Electric System Water Sv5tg0 Sewer System Buildings & Equipment CUDStrUCtiVD Work in Progress Total Fixed ASS8tS DEFERRED CHARGES: Prepaid Water --Costs Bond ISSuaDC9 Costs Total Deferred Charges TATAL ASSETS: - Cost $ 3O4,594 3,293,871 3,400,104 2,5]7,020 5,436,105 3,204,900 $ 114,195 917,029 ll,3U3 $],277,36O 4,626,000 85,513 284 Depreciation 782,947 709,090 369,420 688,451 $l,4y4,O03 /33q,570\ $ 90,956 ]8Y,95O l,129,657 47,417 39,087 l,O42,527 5,989,157 Net $ 3---94. 2,510,924 2,59l,Ol4 2,]47,6OO 4"747,b54 3,204,900 $ 880,887 80,404. The accompanying notes are an integral part of this financial statement. Exhibit21 $ 895,898 350,000 l,085,433 40,48] 495,894 426,821 3,294,527 8,52l,757 15,606,686 - 56 -- LIABILITIES CURRENT LIABILITIES: Payable From Current Assets: Accounts Payable Sales Tax Payable Due to Other Funds Due to Utility Revenue Bond Interest & Sinking Payable From Restricted Assets: Accounts Payable Construction Contracts Retainage Payable Accrued Revenue Bond Interest Payable Matured Revenue Bond Interest Payable Revenue Bonds Payable - Due Within One Year Due to Other Funds Total Current Liabilities OTHER LIABILITIES: Customers' Meter Deposits Revenue Bond Payable - Net of Current Portion Due Within One Year Total Other Liabilities $ 578,227 13,920 1,199,498 47,417 $ 924,418 235,680 229,281 1,345 443,000 2,133,518 $ 534,089 9,381,258 $ 1 ,839 ,062 3,967,242 $ 5,806,304 9,915,347 TOTAL LIABILITIES: $15,721,651 FUND EQUITY CONTRIBUTIONS: RETAINED EARNINGS - JUNE 30, 1980: TOTAL FUND EQUITY: $ 7,175,783 5,486,827 $12,662,610 TOTAL LIABILITIES AND FUND EQUITY: $28,384,261 -57- CITY OF COLLEGE STATION UTILITY FUND STATEMENT OF CHANGES IN CONTRIBUTIONS AND RETAINED EARNINGS FOR THE YEAR ENDED JUNE 30, 1980 Exhibit 22 CONTRIBUTIONS: Adjusted Balances Balance 1979/80 Balances Source 6/30/79 *Adjustments 6/30/79 Contributions 6/30/80 Local Government $ 447,564 $4,808,933 $5,256,497 $ 922,349 $6,178,846 Customers 176,590 --- 176,590 176,590 Federal Government 820,347 -- 820,347 820,347 TOTAL CONTRIBUTIONS: $1,444,501 $4,808,933 $6,253,434 $ 922,349 $7,175,783 *See Adjustment to Retained Earnings Below RETAINED EARNINGS: Balance - July 1, 1979 *Adjustment to Reclassify Prior Years' Contributions From Local Government Adjustment to Reclassify General Obligation Bond Proceeds to the Appropriate Capital Projects Funds Adjustment to Remove Issuance Expenses of General Obligation Bonded Indebtedness Adjustment to Reclassify Allowance for Doubtful Accounts Attributable to Utility Billings and Previously Reflected in General Fund Adjustment to Reclassify General Obligation Bonded Indebtedness and Long Term Debt to the General Long Term Debt Group of Accounts Adjustment for Interest on General Obligation Bonded Indebtedness Improperly Accrued in Utility Fund Adjustment to Correct Prior Year Accrual of Accounts P,yable Adjusted Balance - July 1, 1979 $5,503,846 (4,808,933) (3,472,675) (53,150) (8,500) 6,687,463 140,652 (3,632) $3,985,071 Add: Net Income for the Year 1,501,756 RETAINED EARNINGS - JUNE 30, 1980: $5,486,827 The accompanying notes are an integral part of this financial statement. -58- CITY OF COLLEGE STATION UTILITY FUND STATEMENT OF REVENUE AND EXPENSE FOR THE YEAR ENDED JUNE 30, 1980 OPERATING REVENUE: Electric Division Sales and Fees Water Division Sales and Fees Sewer Division Sales and Fees Miscellaneous Total Operating Revenues Less: Operating Expenses NET OPERATING INCOME BEFORE DEPRECIATION: Less: Depreciation NET OPERATING INCOME: $8,336,194 1,326,433 572,778 88,606 NON -OPERATING INCOME: Interest Earnings - Time Deposits,' $ 115,192 Interest Earnings - Escrowed Construction Funds 615,912 Amortization of Bond Premium ) 282 Total Non -Operating Income NET INCOME BEFORE NON -OPERATING EXPENSES: NON -OPERATING EXPENSES: Revenue Bond Interest Amortization of Revenue Bond Issuance Costs Transfer to Debt Service Fund Total Non -Operating Expenses $ 540,740 4,404 706,508 Exhibit 23 $10,324,011 (7,859,600) $ 2,464,411 (442,389) L$ 2,022,022 731,386 $ 2,753,408 (1,251,652) NET INCOME: $ 1,501,756 The accompanying notes are an integral part of this financial statement. -59- CITY OF COLLEGE STATION UTILITY FUND STATEMENT OF REVENUES - ESTIMATED AND REALIZED FOR THE YEAR ENDED JUNE 30, 1980 ELECTRIC: Electric Revenue Penalty on Billings Pole Rental Temporary Service Fee For Sales Tax Collection Total Electric WATER: Water Revenue Penalty on Billings Water Taps Total Water SEWER: Sewer Revenue Penalty on Billings Sewer Taps Total Sewer MISCELLANEOUS: Reconnect Fees Service Fees Use of City Forces Sale of Scrap Other Revenues Total Miscellaneous TOTAL OPERATING ESTIMATED & REALIZED: NON -OPERATING REVENUE: Interest Earnings Total Non -Operating Revenue TOTAL BUDGETED ESTIMATED & REALIZED: NON -BUDGETED: Amortization of Bond Premium Interest Earnings on Escrowed Construction Funds TOTAL BUDGETED AND NON -BUDGETED: Exhibit 24 Estimated Realized $ 8,454,875 $ 8,126,941 20,000 191,559 8,000 10,944 2,000 5,125 1 ,625 $ 8,484,875 $ 8,336,194 $ 1 ,430,000 $ 1,275,908 10,000 42,000 50,525 $ 1 ,482 ,000 $ 1 ,326 ,433 $ 493,000 $ 554,463 5,000 14,600 18,315 $ 512,600 $ 572,778 $ 3,000 $ 5,951 3,000 1,250 5,000 64,607 5,796 11,002 11,000 $ 88,606 $10,490,475 $10,324,011 $ 100,000 $ 115,192 $ 100,000 $ 115,192 $10,590,475 $10,439,203 282 615,912 $11,055,397 The accompanying notes are an integral part of this financial statement. Variance Favorable (Unfavorable) ($327,934) 171 ,559 2,944 3,125 1 ,625 ($148,681) ($154,092) (10,000) 8,525 ($155,567) $ 61 ,463 (5,000) 3,715 60,178 $ 2,951 (1,750) 59,607 5,796 11,002 $ 77,606 ($166,464) $ 15,192 15,192 ,($151 ,272)\ - 60 - CITY OF COLLEGE STATION UTILITY FUND SCHEDULE OF BUDGETED AND ACTUAL EXPENSES FOR THE YEAR ENDED JUNE 30, 1980 ELECTRICAL TRANSMISSION: Building Maintenance Services Total Operating - Electrical Transmission Capital Outlay - Machinery Total Electrical Transmission ELECTRICAL DISTRIBUTION: Salaries and Benefits Supplies Building Maintenance Equipment Maintenance Services Sundry Total Operating -- Electrical Distribution Capital Outlay - Distribution Lines Capital Outlay - Office Equipment Capital Outlay - Machinery Capital Outlay - Automotive Equipment Total Electrical Distribution WATER PRODUCTION: Salaries and Benefits Supplies Building Maintenance Equipment Maintenance Services Sundry Total Operating - Water Production Capital Outlay - Office Equipment Capital Outlay - Machinery Total Water Production WATER DISTRIBUTION: Salaries and Benefits Supplies Building Maintenance Equipment Maintenance Services Sundry Total Operating - Water Distribution Capital Outlay - Facilities Capital Outlay - Distribution Lines Capital Outlay - Office Equipment Capital Outlay - Machinery Capital Outlay - Automotive Equipment Total Water Distribution Budget $ 14,570 4,410,800 $4,425,370 5,430 $4,430,800 187,287 106,676 60,000 16,600 116,582 5,760 Exhibit 25 Page 1 of 3 Actual $ 993 4,612,242 $4,613,235 5,429 $4,618,664 $ 174,776 104,204 49,569 13,367 45,794 5,755 $ 492,905 $ 393,465 250,000 179,530 2,190 2,185 2,373 5,784 39,000 35,514 $ 786,468 $ 616,478 92,045 $ 66,997 11,950 10,035 1,500 286 2,150 1,116 601 ,494 518,985 3,000 2,182 $ 712,139 599,601 2,350 2,299 4,250 693 $ 718,739 $ 602,593 $ 132,397 $ 66,266 98,850 21 ,600 39,190 3,500 361 ,803 $ 2,000 3,837 1 ,071 27,500 396,211 $ 87,748 48,406 30,726 11,034 30,003 2,667 210,584 1,726 1 ,059 2,385 21 ,664 237,418 Variance Favorable (Unfavorable) $ 13,577 (201,442) ($187,865) 1 ($187,864) $ 12,511 2,472 10,431 3,233 70,788 5 $ 99,440 70,470 5 (3,411) 3,486 $169,990 $ 25,048 1,915 1,214 1 ,034 82 ,509 818 $112,538 51 3,557 116,146 $ 44,649 17,860 68,124 10,566 9,187 833 151 ,219 274 3,837 12 25,115 (21 ,664) $158,793 - 61 - CITY OF COLLEGE STATION UTILITY FUND SCHEDULE OF BUDGETED AND ACTUAL EXPENSES FOR THE YEAR ENDED JUNE 30, 1980 SEWER TREATMENT: Salaries and Benefits Supplies Building Maintenance Equipment Maintenance Services Sundry Total Operating - Sewer Treatment Capital Outlay - Facilities Capital Outlay - Machinery Capital Outlay - Automotive Equipment Total Sewer Treatment SEWER COLLECTION: Salaries and Benefits Supplies Building Maintenance Equipment Maintenance Services Sundry Total Operating - Sewer Collection Capital Outlay - Machinery Total Sewer Collection NON -DEPARTMENTAL: Administrative Transfers to General Fund Transfers to General Fund in Lieu of Taxes Transfer to Debt Service Fund Contingency Revenue Bond Principal and Reserve Revenue Bond Interest Capital Outlay - Computer Project Total Non -Departmental TOTAL UTILITY BUDGETED & ACTUAL EXPENSES: NON -BUDGETED: Bad Debt Expense Amortization of Bond Issuance Costs Miscellaneous TOTAL BUDGETED AND NON -BUDGETED EXPENSES: Exhibit 25 Page 2 of 3 Budget Actual $ 110,870 $ 99,142 17,975 15,669 26,200 15,204 3,300 2,882 141,050 122,709 7,500 6,865 $ 306,895 $ 262,471 21 ,680 4,922 4,070 2,149 16,162 16,012 348,807 $ 285,554 105,725 33,935 26,800 10,250 15,219 1 ,400 $ 193,329 6,000 $ 199,329 $ 629,533 1,004,833 706 ,508 19,289 262,000 221,433 9,000 2,852,596 $9,732,950 65,690 24,293 11,967 4,891 6,477 988 114,306 4,260 $ 118,566 $ 629,533 1,004,833 706,508 13,894 402,000 540,740 148,419 S3,445,927 $9,925,200 14,570 4,404 3,108 $9,947,282 Variance Favorable (Unfavorable) $ 11,728 2,306 10,996 418 18,341 635 $ 44,424 16,758 1,921 150 $ 63,253 $ 40,035 9,642 14,833 5,359 8,742 412 79,023 1,740 $ 80,763 $ 5,395 (140,000) (319,307) (139,419) ($593,331) ($192,250) -- 6 2 - CITY OF COLLEGE STATION UTILITY FUND SCHEDULE OF BUDGETED AND ACTUAL EXPENSES FOR THE YEAR ENDED JUNE 30, 1980 Budget DEDUCT NON -OPERATING EXPENSES: Capital Outlay Transfer to Debt Service Revenue Bond Principal Revenue Bond Interest Amortization of Bond Issuance Costs Exhibit 25 Page 3 of 3 Variance Favorable Actual (Unfavorable) (434,030)e (706,508) (402,000) (540,740) (4,404) TOTAL OPERATING EXPENSES FOR THE YEAR $7,859,600 ENDED JUNE 30, 1980: The accompanying notes are an integral part of this financial statement. -63- CITY OF COLLEGE STATION UTILITY FUND SCHEDULE OF FIXED ASSETS AND DEPRECIATION JUNE 30, 1980 LAND: ELECTRIC SYSTEM: Transmission & Distribution Lines Electric Services Equipment Meters Transformers Total Electric System WATER SYSTEM: Transmission & Distribution Lines Water Services Equipment Meters Storage Tanks Water Well Drilling Costs Total Water System SEWER SYSTEM: Transmission & Distribution Lines Outfall Lines & Lift Station Total Sewer System BUILDINGS & EQUIPMENT: Buildings & Improvements General & Office Equipment Automotive Equipment Computer Project Total Buildings & Equipment CONSTRUCTION WORK IN PROGRESS: TOTAL FIXED ASSETS: ASSETS Exhibit 26 Balances Balances 7/1/79 Additions Deductions 6/30/80 $ 158,787 $ 145,807 $ $ 304,594 $ 1,694,699 4,406 532,456 882,781 $ 3,114,342 $ 1,698,424 74 427,605 492,555 28,390 S 2,647,048 $ 179,529 $ 179,529 753,056 $ 753,056 $ $ 634,978 $ 819,229 1,062,813 $ 1,454,207 $1,062,813 $ 4,688,080 259,843 227,746 4,463 5,180,132 $ 1,414,725 $13,969,241 $ 6,397 $ 27,546 73,611 148,419 $ 255,973 $ $1 ,790,175 $4,187,353 $ 1,874,228 4,406 532,456 882,781 $ 3,293,871 $ 2,451 ,480 74 427,605 492 ,555 28,390 $ 3,400,104 $ 634,978 1,882,042 $ 2,517,020 $ 4,694,477 287,389 301 ,357 152,882 $ 5,436,105 $ 3,204,900 $18,156,594 - 64 - DEPRECIATI0N Balances Depreciation BdlaDC93 7/1/79 Taken 6/30/80 - $ 326,118 2,898 125,609 216 472 670,897 $ 354,446 74 143,306 129,296 $ O27,T22 $ 62,466 61 18,636 3O,8g7 S..^,... $ 388,574 2,759 144,245 247,309 $ 782,947 3 51,874 $ 406,320 74 17,070 160,376 12,314 141,610 710 710 $ 81, --�---709,090 $ 228,729 $ 14,762 92,163 33,766 t 256,457 l39,0l4 92,537 � ~ $2,107,519 t 243,49] 125,929 136,277 $ 392,734. 22,689 162,303 33,010 125,547 7,867 7,867 ~ - �4�2,389$2,549,908 Net Asset Value $ 304»5q4 $ 1,485,654 l,647 388,211 635,412 $ 2,510,924 $ 2,045,160 267,229 350,945 27,680 -- 2,591,014 $ 391,487 l,75S,ll3 S 2,147,600 $ 4,301,743 125,086 l75,8]8 145,015 $ 4,747,554 $ 3,204,900 $15,606,886 -h5- CITY OF COLLEGE STATION UTILITY FUND SCHEDULE OF REVENUE BOND DEBT JUNE 30, 1980 Exhibit 27 Original Balance Date Issue Retired 6/30/80 Water and Sewer System and 2/01/67 $ 333,000 $ 251,000 $ 82,000 Electric Light and Power System Revenue Refunding Bonds - Series 1967 Water and Sewer System and 2/01/67 600,000 325,000 275,000 Electric Light and Power System Revenue Bonds - Series 1967 Utility System Revenue Bonds 8/01/71 800,000 360,000 440,000 Series 1971 Utility System Revenue Bonds _ 8/01/73 500,000 175,000 325,000 Series 1973 Utility System Revenue Bonds - 8/01/76 3,000,000 300,000 2,700,000 Series 1976 Utility System Revenue Bonds 5/01/79 6,145,000 145,000 6,000,000 Series 1979 $11,378,000 $1,556,000 $9,822,000 -66 MATURITIES REQUIREMENTS Fiscal Year 1980-81 Fiscal Year 1981-82 From To Annually Principal Interest Principal Interest 2/01/81 2/01/82 $ 18,000 $ 18,000 $ 2,735 $ 18,000 $ 2,138 2/01/83 2/01/84 23,000 Matured 5,000 30,000 9,765 30,000 8,685 2/01/81 2/01/89 30,000 2/01/81 2/01/91 40,000 40,000 23,680 40,000 21,560 2/01/81 2/01/93 25,000 25,000 16,538 25,000 15,163 2/01/81 2/01/93 150,000 150,000 154,575 150,000 145,575 2/01/94 2/01/95 175,000 2/01/96 2/01/97 200,000 2/01/81 175,000 2/01/82 200,000 2/01/83 2/01/84 225,000 2/01/85 275,000 2/01/86 300,000 2/01/87 325,000 2/01/88 2/01/91 350,000 2/01/92 2/01/97 400,000 2/01/98 475,000 175,000 345,413 200,000 332,725 $438,000 $552,706 $463,000 $525,846 - 67 - CITY OF COLLEGE STATION SANITATION FUND BALANCE SHEET JUNE 30, 1980 CURRENT ASSETS: Cash on Hand and in Bank Accounts Receivable - Other Inventories Due From General & Utility Funds Total Current Assets FIXED ASSETS: Automotive Equipment Machinery, Tools & Equipment Total Fixed Assets TOTAL ASSETS: CURRENT LIABILITIES: Accounts Payable TOTAL LIABILITIES: ASSETS Cost Depreciation Net $174,090 $ 44,226 $129,864 121,120 87,438 33,682 $295,210 $131 ,664 LIABILITIES CONTRIBUTIONS AND RETAINED EARNINGS CONTRIBUTIONS: RETAINED EARNINGS - JUNE 30, 1980: TOTAL LIABILITIES, CONTRIBUTIONS, AND RETAINED EARNINGS: The accompanying notes are an integral part of this financial statement. Exhibit 28 $164,741 338 3,524 95,467 $264,070 163,546 $427,616 $ 3,833 $ 3,833 54,901 368,882 $427,616 - 68 - CITY OF COLLEGE STATION SANITATION FUND STATEMENT OF CHANGES IN CONTRIBUTIONS AND RETAINED EARNINGS FOR THE YEAR ENDED JUNE 30, 1980 CONTRIBUTIONS: Federal Government TOTAL CONTRIBUTIONS: Exhibit 29 Balances 1979-80 Balances 7/1/79 Contributions 6/30/80 $ $ 54,901 $ 54,901 $ $ 54,901 $ 54,901 RETAINED EARNINGS: Balance - July 1, 1979 Adjustment for Addition of Fixed Assets from General Fixed Asset Group of Accounts 210,022 Adjustment for Accumulated Depreciation on Transferred Assets (86,396) Adjustment for Transfer of Receivables Previously Carried in Utility Fund 32,505 Adjustment for Transfer of Payables Previously Carried in General Fund (29,397) Adjustment for Transfer of Inventory 911 Previously Carried in General Fund Adjusted Balance - July 1, 1979 $127,645 Add: Net Income for the Year 241,237 RETAINED EARNINGS - JUNE 30, 1980: $368,882 The accompanying notes are an integral part of this financial statement. -69- CITY OF COLLEGE STATION SANITATION FUND STATEMENT OF REVENUE AND EXPENSE FOR THE YEAR ENDED JUNE 30, 1980 OPERATING REVENUE: Sanitation Fees - Residential $429,637 Sanitation Fees - Commercial 169,053 Sanitation Fees - Landfill 3,253 Penalties on Billings 568 Dumpster Sales 16,337 Miscellaneous Income 12 Total Operating Revenues Less: Operating Expenses NET OPERATING INCOME BEFORE DEPRECIATION: Less: Depreciation NET INCOME: Exhibit 30 $618,860 (332,356) $286,504 (45,267) $241 ,237 The accompanying notes are an integral part of this financial statement. -70- CITY OF COLLEGE STATION SANITATION FUND SCHEDULE OF BUDGETED AND ACTUAL EXPENSES FOR THE YEAR ENDED JUNE 30, 1980 SANITATION COLLECTION (RESIDENTIAL): Salaries and Benefits Supplies Equipment Maintenance Services Sundry Total Operating - Sanitation Collection (Residential) Capital Outlay - Automotive Equipment Total Sanitation Collection (Residential) SANITATION COLLECTION (COMMERCIAL): Salaries and Benefits Supplies Equipment Maintenance Services Sundry Total Sanitation Collection (Commercial) SANITATION DISPOSAL: Salaries and Benefits Supplies Building Maintenance Equipment Maintenance Services Sundry Total Operating - Sanitation Disposal Capital Outlay - Machinery, Tools, Equipment Total Sanitation Disposal TOTAL SANITATION BUDGETED AND ACTUAL EXPENSES: NON -BUDGETED: Dumpster Purchases TOTAL BUDGETED AND NON -BUDGETED EXPENSES: DEDUCT NON -OPERATING EXPENSES: Capital Outlay TOTAL OPERATING EXPENSES FOR THE YEAR ENDED JUNE 30, 1980: Budget $248,641 39,050 33,300 2,000 2,200 $325,191 78,901 $404,092 $ 30,698. 11,732 10,000 1 ,000 53,430 $ 38,080 19,100 2,800 35,000 9,920 104 , 900 6,700 111 ,600 $569,122 Exhibit 31 Actual $191 ,491 10,745 13,720 737 1,936 $218,629 78,568 $297,197 $ 25,494 1 ,648 1,306 423 $ 28,871 $ 35,019 3,050 9 21,349 6,197 188 $ 65,812 6,620 $ 72,432 $398,500 $ 19,044 $417,544 Variance Favorable Unfavorable) $ 57,150 28,305 19,580 1 ,263 264 $106,562 333 $106,895 (85,188) $332,356 The accompanying notes are an integral part of this financial statement. $ 5,204 10,084 8,694 1 ,000 423) 4,559 $ 3,061 16,050 2,791 13,651 3,723 (188) $ 39 , 088 80 $ 39,168 $170,622 - 71 - CITY OF COLLEGE STATION GENERAL FIXED ASSETS GROUP OF ACCOUNTS STATEMENT OF GENERAL FIXED ASSETS JUNE 30, 1980 Exhibit 32 GENERAL FIXED ASSETS: $1,880,718 Land 2,181 ,739 Buildings and Improvements 181,739 Machinery, Tools, and Equipment 9958,361 Motor Vehicles 947,7776 03 Parks and Recreation Equipment 2,418,885 Paving Sidewalks and Streets ,8,88 Construction in Progress TOTAL GENERAL FIXED ASSETS: $9,952,777 CITY OF COLLEGE STATION GENERAL FIXED ASSETS GROUP OF ACCOUNTS SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS FOR THE YEAR ENDED JUNE 30, 1980 ADJUSTED BALANCES - 6/30/79 NET ADDITIONS BY FUNDS: General Fund: Exhibit 33 Buildings And Total Land Improvements $8,223,590 $1,456,605 $1,954,162 Administration $ 8,861 $ $ Planning 9,267 Finance 17,981 Public Service 72,047 Police 61,144 Fire 25,497 Engineering 17,077 Parks 50,329 4,175 Total General Fund $ 262,203 $ $ 4,175 Special Revenue Funds $ 150,009 $ 150,009 $ Capital Projects Funds: Community Development $ 229,002 $ 5,052 $ 1976 Bond Funds 218,052 1978 Bond Funds 58,863 25,141 1978 Series II Bond Funds 1,021,080 269,052 198,261 Total Capital Projects $1,526,997 $ 274,104 $ 223,402 (DEDUCTIONS) FROM GENERAL FUND: Removal of Assets Transferred to Newly Established Sanitation Fund $ (210,022) $ $ BALANCES - JUNE 30, 1980: $9,952,777 $1,880,718 $2,181,739 --73- Machinery, Parks & Paving Construction Tools, Motor Recreation Sidewalks In Equipment Vehicles Equipment & Streets Progress $983,265 $200,675 $827,396 $2,163,408 $ 638,079 $ 2,572 $ 6,289 $ $ $ 4,587 4,680 7,233 10,748 6,856 65,191 8,471 52,673 - 25,497 4,864 11,849 - 364 28,050 13,120 4,984 $ 88,130 $164,550 $ 4,984 $ 364 $ $ $ $ $ 19,270 $ (19,270) $ 1,466 $ $ $ 235,843 $ (13,359) 218,052 111,727 (78,005) 3,670 550,097 $ 1,466 $ 5115,397 $ 235,843 $ 676,785 ($114,500) $(95,522) $ $ $ $958,361 $269,703 $947,777 $2,418,885 $1,295,594 CITY OF COLLEGE STATION GENERAL LONG TERM DEBT STATEMENT OF GENERAL LONG TERM DEBT JUNE 30, 1980 AMOUNT AVAILABLE AND TO BE PROVIDED FOR THE PAYMENT OF GENERAL LONG-TERM DEBT Amount Available in Debt Service Fund Amount to be Provided for Debt Service $ 722,498 11,297,009 TOTAL AVAILABLE AND TO BE PROVIDED: $12,019,507 Tax Obligation Bonds Notes Payable GENERAL LONG-TERM DEBT PAYABLE $11,945,000 74,507 TOTAL GENERAL OBLIGATION LONG-TERM DEBT: $12,019,507 Exhibit 34 - 7 5 - CITY OF COLLEGE STATION GENERAL LONG-TERM DEBT SCHEDULE OF TAX OBLIGATION BOND DEBT JUNE 30, 1980 DEBT Exhibit 35 Purpose And Date Of Issue Date Authorized IS3U2d Re -tired 0Ut5tandinq _ 1968 City Hall, Fire/Police 8/01/68 $ 840,000 $ 840,000 $ 230,000 $ 610,000 Headquarters, Street Improvements l971 Street Improvements 8/01/71 500,000 500,000 225,000 275,000 1976 Street Improvements; 8/15/76 9,865,000 5,840,000 825,000 5,015,000 Electric, Water Works, & Sewer Systems' Improve- ments; Police, Fire, & Warehouse Buildings; City Hall Expansion; Park Improvements; Civic Center 1078 Series I - Issue 2/01/78 Balance of 1976 Autho- rization (See Above) 1978 38ri83 II - Street 5/15/78 3,020,000 3,020,000 150,000 2,870,000 Improvements; Police, Fire, Warehouse Buildings; Park I0pr0V808Dt3 TOTAL TAX OBLIGATION BONDS: _ BONDS AUTHORIZED AND UNISSUED: 1970 Series - Civic Center 500,000 TOTAL: $500,000 3,525,000 350,000 3,175,000 -7h- 8/01/80 8/01/81 3 30,000 8/01/82 8/01/84 35,000 8/01/85 8/01/87 40,000 8/81/88 8/01/92 45,000 8/0l/80 8/0l/90 25,000 8/15/80 8/15/82 275,000 8/15/83 290,000 8/15/84 8/15/96 300,000 2/01/81 2/0l/97 175,000 2/01/98 200,000 5/15/81 5/15/98 150,000 MATURITIES xE REMENT5 -- - F1SCDl Year. l98U-8\ Fiscal Yea 1981-02 $ 30,000 3 27,225 $ 30,000 $ 25,905 25,000 14,250 25,000 13,075 275,000 277,350 275,000 260,850 175,000 l69,275 175,000 148,775 150,000 153,710 .150,000 145,273 - S655,0X00 $631,810 $655,000 S593J7Y8 ^ CITY OF COLLEGE STATION GENERAL LONG-TERM DEBT SCHEDULE OF OTHER TAX OBLIGATION DEBT JUNE 30, 1980 Exhibit 30 DE8T Creditor and Purpose Original Balance Of Debt Rate 0lt8 A0UUDt Retirements 6/30/80 -- - ____--- NOTES PAYABLE/ Wanda Smith Hobson - Police & NdrehVUS2 Property 7,5% 5/16/74 $ 86,000 S65,308 S19,692 Xerox - Copy Machine 5% 3/28/78 5,413 2,970 3,443 [iddie B. Arnold - Park Land TOTAL NOTES PAYABL.E: 7% 4/17/78 68,498 17,126 5l,372 _ $160,911 $86,404 S74,507 MATURITIES REQUIREMENTS Fiscal Year 1980-81 Fiscal Year 1981-82 From To Annually Principle Interest Principle Interest 5/15/81 $19,692 $19,692 $1,477 $ $ 7/01/80 7/01/81 1 ,181 1 ,181 325 1 ,181 325 7/01/82 1,081 4/17/81 4/17/86 8,562 8,562 3,596 8,562 2,997 $29,435 $5,398 $9,743 $3,322 -79- CITY OF COLLEGE STATION ALL FUNDS STATEMENT OF CASH RECEIPTS AND DISBURSEMENTS FOR THE YEAR ENDED JUNE 30, 1980 GENERAL FUND: SPECIAL REVENUE FUND: Revenue Sharing Hotel/Motel Tax Total Special Revenue Fund DEBT SERVICE FUND: CAPITAL PROJECTS FUND: Community Development $ 3,756 $ 417,963 1971 Bond Funds 738 1976 Bond Funds 3,324 44,728 1978 Bond Funds (519) 114,957 1978 Series II Bond Funds 68,265 53,536 Total Capital Projects Fund $ 75,564 $ 631,184 ENTERPRISE FUND: Utility Fund Operating $ 408,548 $11,003,862 Sanitation Fund Operating 699,617 Revenue Bond Interest & Sinking 206,290 408,948 Customers' Meter Deposits 10,393 381,687 1976 Bond Funds 3,108 34,236 1979 Bond Funds 6,641,163 Total Enterprise Fund 628,339 $19,169,513 TRUST AND AGENCY FUND: Firemen's Relief and Retirement $ $ 4,115 TPAA Utility Lobby 7,750 51,093 Cemetery _ Perpetual Care 7,984 1,642 Total Trust and Agency Fund $ 15,734 $ 56,850 MEMORANDUM TOTALS: $1,220,611 $24,502,611 Exhibit 37 Cash Balances 6/30/79 Receipts $ 407,410 $ 2,323,608 $ 18,667 $ 272,752 49,620 217,148 $ 68,287 $ 489,900 $ 25,277 $ 1 ,831 ,556 -80- Interfund Transfers In Out $2,349,664 $ 375,833 $ 309,444 93,500 $ 402,944 $ 47,563 $ 49,456 462 ,300 1,013,353 192,747 ,717,856 $ 617,944 65,511 1,384,072 369,620 1 ,300,926 $3,738,073 5,000 $ 5,000 $8,261 ,100 $ 452,035 92,325 $ 544,360 $ 177,825 $ 43,544 854,467 1,818,772 829,065 $3,545,848 $3,165,020 124,096 803,210 285 ,062 54,377,388 $ 45,635 $ 45,635 $9,066,889 Investments Balances Sold Purchased Disbursements 6/30/80 $ 487,565 $ 1,206,000 $ 3,947,966 $ 38,448 $ 1,306,257 367,133 $ 1,673,390 $ 290,000 201,000 450,000 7,660,000 3,825,000 $12,136,000 $ 1,192,859 1,220,000 1,120,000 6,171 ,000 $ 9,703,859 43,300 -$ 43,300 $24,334,114 $ 1,266,000 348 ,000 $ 1,614,000 $ 432,000 $ 200,000 6,160,000 2,623,000 8,983,000 $ 1,092,000 2,125,657 85,000 440,000 10,797,000 $14,539,657 10,000 44,900 $ 54,900 $26,829,557 $ 90,714 259,504 $ 350,218 $ 1,567,217 $ 422,630 105,799 505,180 538,812 $ 1,572,421 $ 8,070,295 476,291 910,697 216,124 169,559 1,753,667 $11 ,596,633 $ 98,371 27,572 �125,943 $ 17,354 $ 5,001 1 ,738 86 303,839 148,671 $ 459,335 $ 895,898 164,741 182,956 90,956 114,195 1 ,277,360 $2,726,106 $ 4,100 $ 15 8,026 $ 12,308 $ 8,041 $19,046,763 $3,375,227 8,208 - 81 CITY OF COLLEGE STATION COMBINED SCHEDULE OF DELINQUENT TAXES RECEIVABLE BY FUNDS JUNE 30, 1980 Exhibit 38 Debt General Service Tax Year Fund Fund Total 1969 & Prior $ 1,556 $ 274 $ 1,830 1970 194 91 285 1971 184 309 493 1972 326 373 699 1973 289 411 700 1974 675 318 993 1975 1,069 173 1,242 1976 2,249 554 2,803 1977 2,765 1,592 4,357 1978 4,202 4,294 8,496 1979 19,904 30,082 49,986 TOTAL DELINQUENT TAXES RECEIVABLE: $33,413 $38,471 $71,884 - 82 - CITY OF COLLEGE STATION SUMMARY OF TAXES RECEIVABLE FOR THE YEAR ENDED JUNE 30, 1980 Exhibit 39 Additions Or (Cancellations) Collections Balance Current Current Balance Tax Year 6/30/79 Fiscal Year Fiscal Year 6/30/80 1969 & Prior $ 2,281 $ $ 451 $ 1,830 1970 379 94 285 1971 717 (119) 105 493 1972 972 (126) 147 699 1973 993 (165) 128 700 1974 1,341 (250) 98 993 1975 1,786 (160) 384 1,242 1976 5,957 (123) 3,031 2,803 1977 12,835 8,478 4,357 1978 25,227 16,731 8,496 1979 1 ,121 ,037 1 ,071 ,051 49,986 TOTALS: $52,488 $1,120,094 $1,100,698 $71 ,884 DISTRIBUTION OF TAX COLLECTIONS FISCAL YEAR 1979-80 General Fund Debt Service Fund Current Delinquent Total $ 421 ,759 $19,262 $ 441 ,021 646,023 13,654 659,677 TOTALS: $1,067,782 $32,916 $1,100,698 -83- CITY OF COLLEGE STATION UTILITY AND GENERAL LONG-TERM DEBT COMBINED STATEMENT OF BONDS PAYABLE JUNE 30, 1980 REVENUE BONDS: Water and Sewer System and Electric Light and Power System Revenue Refunding Bonds - Series 1967 Exhibit 40 Interest Final Payment Issue Maturity Dates Date Date 2-01; 8-01 2-01-67 2-01-84 Water and Sewer System and Electric Light and 2-01; 8-01 Power System Revenue Bonds - Series 1967 Utility System Revenue Bonds - Series 1971 2-01; 8-01 Utility System Revenue Bonds - Series 1973 2-01; 8-01 Utility System Revenue Bonds - Series 1976 2-01; 8-01 Utility System Revenue Bonds - Series 1979 TOTAL REVENUE BONDS: TAX OBLIGATION BONDS: 1968 City Hall, Fire/Police Headquarters, Street Improvements 2-01-67 8-01-71 8-01-73 8-01-76 2-01-89 8-01-91 2-01-93 2-01-97 2-01; 8-01 5-01-79 2-01-98 2-01; 8-01 1971 Street Improvements 2-01; 8-01 1976 Street Improvements; Electric, Water Works, 2-15; 8-15 & Sewer Systems' Improvements; Police, Fire, & Waterhouse Buildings; City Hall Expansion; Park Improvements; Civic Center 1978 Series I - Issue Balance of 1976 2-01; 8-01 Authorization (See Above) 1978 Series II - Street Improvements, Police, 2-15; 8-15 Fire, Waterhouse Buildings; Park Improvements TOTAL TAX OBLIGATION BONDS: TOTAL BONDS PAYABLE: 8-01-68 8-01-94 8-01-71 2-01-91 8-15-76 2-15-97 2-01-78 2-01-98 5-15-78 2-15-99 -84- Future Annual Serial Payments $ 18,000 23,000 (81-82) (83-84) $ 30,000 (81-89) $ 40,000 (81-91) $ 25,000 (81-93) $150,000 (81-93) 175,000 (94-95) 200,000 (96-97) $175,000 (81) Various (82-98) $ 30,000 (81) Various (82-94) $ 25,000 (80-90) $275,000 (80-82) 290,000 (83) 300,000 (84-96) $175,000 (81-97) 200,000 (98) $150,000 (81-98) B0NDS Authorized Issued Retired Outstanding $ 333,000 $ 333,000 600,000 600,000 800,000 500,000 3,000,000 800,000 500,000 3,000,000 6,145,000 6,145,000 $11,378,000 $11,378,000 $ 840,000 $ 840,000 500,000 500,000 9,865,000 5,840,000 3,525,000 3,020,000 3,020,000 $14,225,000 $25,603,000 $13,725,000 $25,103,000 $ 251,000 $ 82,000 325,000 275,000 360,000 175,000 300,000 440,000 325 ,000 2,700,000 145,000 6,000,000 $1,556,000 $9,822,000 $ 230,000 $ 610,000 225,000 275,000 825,000 5,015,000 350,000 3,175,000 150,000 2,870,000 $1,780,000 $11,945,000 $3,336,000 $21,767,000 -85- Fiscal Year l97O-7l lq7]-72 l972-73 l973-74 ]974-75 l975-76 lQ76-77 l977-78 1978-79 l979-8O CITY OF COLLEGE STATION GENERAL GOVERNMENTAL EXPENDITURES BY FUNCTION LAST TEN FISCAL YEARS --UNAUDITED-- General Government. Police Fire Sanitation $ 159,448 124,866 $ 46,80S 83,418 _--`_---- l66,6O9 146,093 52,947 86,293 l72,918 155,265 59,581 81,611 239,880 215,001 97,252 79,275 264,948 262,306 l38,450 135,480 330,999 186,212 127,874 425,957 330,805 251,852 576,522 479,468 242,976 847,270 456,599 242,707 1,442,672 11 11 i587,264 l/ - l/ TD fi3Cd] year 79-80, the Sanitation Fund was set no longer supported by the General Fund. Up � Streets 178,095 115,464 7l4,243 ]85,OD2 176,488 166,781 296,716 219,884 309,145 205,684 Table I Parks & Recreation 3 l7.976\- 19,737 21,864 49,695 113,272 ) ./ 143,597«/- 238,714 3A6,5Ol 366,660 475,706 _ as an Enterprise � � Debt Service 53,150 106,692 106,835 1O3~9O8 106,255 102,717 340,531 308,265 539,183 . 1,567,169 Fund and is \ - 86 - ., Fiscal Property Year Tax 1970-71 S110,202 1971-72 67,938 1972-73 100,69l 1973-74 l05,294 lQ74-75 209,704 l975-76 409,904 1976-77 424,222 1977-78 34.2,457 1978-79 438,258 1979-80 444,342 CITY OF COLLEGE STATION GENERAL REVENUE BY SOURCE LAST TEN FISCAL YEARS -UNAUDITED- 1% City Sales Tax 128,680 159,031 ]9O,23O 246,759 396,784 482,952 58],70O 784,930 9]9,492 l,065°3l4 Mixed Drink Fax l,0l2 3,000 6,750 10,305 ]3,20Q 22,272 26,323 32,234 38,827 Franchise & G-ross Receipts, $ 30,790 32,23l 35,339 40,876 51,083 63,839 79,858 93,582 103,752 ll5,8l0 Fines & Forfeitures $ 20,698 25,668 22,008 46,152 74,471 94,476 113,675 184,053 288,306 315,514 l/ ID fiscal year 79-80, the Sanitation Fund was set Up as an Enterprise Fund and is DO longer supported by the General Fund. Fiscal Year 1970-71 1971-72 1972-73 1973-74 1974-75 1975-76 1976-77 1977-78 1978-79 1979-80 Assessed Value $ 19,877,630 43,210,952 50,875,868 60,294,657 76,248,230 92,839,625 104,966,638 120,853,467 140,112,861 266,536,120 ti CITY OF COLLEGE STATION ASSESSED AND ESTIMATED ACTUAL VALUE OF TAXABLE PROPERTY LAST TEN FISCAL YEARS -UNAUDITED - Real Property Estimated Actual Value $ 49,694,075 Table IV Personal Property Estimated Assessed Actual Value Value $ 3,165,162 $ 7,912,905 54,013,690 6,737,200 8,421,500 63,594,835 6,936,284 8,670,355 75,368,321 8,877,850 11,097,312 95,310,287 11,153,376 13,941,720 116,049,531 17,899,207 22,3.74,009 131,208,297 25,299,855 31,624,818 151,066,834 25,023,668 31,279,585 1 75,141 ,076 26,258,105 32,822,631 333,170,150 27,368,820 34,211,02.5 -91 -• Total Tax Collections � l7l,874 184,603 216,859 255,556 310,258 47l,565 559,252 747,868 882,318 l"098,263 Total Collections As Percent Of Current L2VY 99,35% 98.66 98.30 98.50 94,73 99,83 l0l'05 99.71 98.87 97.97 Outstanding Delinquent Taxes $17,962 20,565 24,534 31,130 48,867 49,807 40,508 42,601 52,502 71,884 Outstanding Delinquent Taxes As A Percent Of Current L8vY lO'38% 11.04 11.12 ]2.00 14.92 10.54 7'32 5,68 5.88 6.41 -9O- CITY F COLLEGE STATION PROPERTY TAX LEVIES AND COLLECTIONS LAST TEN FISCAL. YEARS -UNAUDITED- Table III Total Current Percent Delinquent Fiscal Tax Tax Of Levy Tax Year Levy Collections Collected Collections ----' 9O8 3 � 1970-71 $ 173,002 $ 167,886 97,04% ~ , 1971-72 187,111 177,803 95,02 6,800 1972-73 220,600 212,029 96.11 4,830 1973-74 239,439 251,514 96.45 4,042 1974-75 327,535 299,839 91.54 '10,419 1976-76 472,346 445,472 94,35 26,093 l2852lq7�-77 553,453 53O,73� 95,84 , 1977-78 750"027 728"672 97,15 19,196 1978-79 892,365 867,137 97.17 l�,101 1979-80 1"121,035 l,055,347 95,03 32,916 ... 89- Int9rg0V/tl. ReV8Due .. _-__---_� 2,997 13,603 22,251 55,394 87,430 Contribution Targes For From Enterprise Services Funds � ~ 85,816 ]21,l67 140,189 160,563 207,764 237,488 208,474 Jl2,7]9 345,983 l/ 103,883 58,000 lgl,000 59],lO8 975,260 l,534,366 Interest Earned l,588 8,946 8,606 10,407 16,347 12,080 7,042 35,333 Licenses & Permits \l7,953 20,799 Jl,37U 33,926 20,114 5l,42g 74,4]5 h7,51l 59,022 75,661 ^ Total Estimated Ratio of Total Assessed Assessed Actual TO Total Estimated/ Value Value Actual Value $ 23,04.2,792 $ 57,006,980 40% 49,788,464 52,235,580 80 57,812,152 72,285,190 80 09,172,507 86,465,633 80 87,401,606 109,252,007 80 110,738,832 138,423,540 80 130,266,493 162,833,116 80 145,877,135 l82,346,418 80 166,370,986 207,963,707 80 293,904,940 367,381,175 80 Fiscal Year Citv 1970-71 $ '75 1971-72 ,375 1972-73 .375 1973-74 .375 1974-75 ,375 1975-76 .43 1976-77 ,43 1977-78 ,52 1978-79 .55 1979-80 .39 CITY OF COLLEGE STATION PROPERTY TAX RATES, RATIOS AND LEVIES ALL OVERLAPPING GOVERNMENTS LAST TEN FISCAL YEARS -UNAUDITED- TA X R8TE3 P2r-3100 Of A5S8S3ed Va1�-cTT- School Cou,nty 3tdt�__ TOtal _ $1.61 $1,30 $ ,37 $4,03 1.61 1,30 .32 6,98 1,61 1.25 ,27 6.88 1.67 1,20 .22 6.84 1.75 1,15 .17 6.82 1.77 1.10 .12 3.42 1,81 ,47 '12 3.33 1'40 1.00 ,10 3,02 1,27 ,99 ,10 2.92 1,29 1.15 .10 2.95 ` l\ The upper limit Of the tax rate is set at S2,50/$100 of d5S8538d value for all jurisdictions by State Statute. This limit is f0r both operation and for debt service combined. ` 2\ The`dDte that taxes are due for th2 City is the bSginOfDq of th9 fiscal year, ` currently July ]. For Other ~Uri1diciioos the ddte iS October I, Taxes for all jurisdictions become delinquent on February 1. � ^ 3\ The penalties for all jurisdictions are Set by state law at l% per month for February thrU July and interest accrued at 1/2% per month. There are no diSCOUDt3 allowed. TAX RATIOS TAX LEVIES City School County State City 40% 80% 20% 20% $ 173,002 80 80 20 20 187,111 80 80 20 20 220,600 80 80 20 20 259,439 80 80 20 20 327,535 80 80 20 20 472,346 80 80 20 20 553,453 80 80 20 20 750,027 80 80 20 20 892,365 80 80 20 20 1,121,035 County/ School State $ 945,617 $ 993,016 998,633 1,002,569 1,129,836 1,018,746 1,395,207 1,014,679 1,786,604 1,041,703 2,192,776 1,130,711 3,041,909 1,280,512 3,714,929 1,410,978 3,665,701 1,592,086 3,631 ,840 2,183,122 - 94 - CITY OF COLLEGE STATION RATIO OF NET GENERAL 8ONOE13 DEBT TO ASSESSED VALUE AND NET BONDED DEBT PER CAPITA LAST TEN FISCAL YEARS -UNAUDITED-, Table VI Gross Less Fiscal Estimated A5Se35Pd 80Dd2d Debt Service Year Population Value Debt Cash Funds 1970-71 17,698 $ 23,042,792 $ 825,000 $ 23,107 1971-72 19,289 49,788,464 1,280,000 31,140 1972-73 21,896 57,812,152 1,235,000 37,546 1973-74 23,654 69,172,507 1,190,000 81,831 19/4-/5 25,201 87,401,606 1,140,000 73,249 1975-70 27,227 110,738,832 1,090,000 36,224 1975-77 29,667 ]30,265,493 2"530,000 45,340 l977-78 32,348 145,877,135 3,040,250 365,282 1978-79 35,260 166,370,966 5,916,000 332,203 l/ In fiscal year 1979-80, all General Obligation Bonded Indebtedness was consolidated in the General Long Term Debt Group of ACC0UDtS, All retirement Of that debt was also made from the Debt Service Fund. In all prior years, a portion of the debt was incorrectly reflected as indebtedness of the Utility Fund. - 95 - Net Ratio 0f Net Bonded Net Bonded Debt Bonded Debt Debt To Assessed Value Per Capita $ 801,893 .0348 $ 45.31 1,248,860 .0251 64.79 1,197,454 .0207 54.69 1,108,169 .0160 46.85 1,066,751 .0122 42.33 1,053,776 .0095 38.70 2,434,660 .0187 82.07 2,680,968 .0184 82.88 5,583,797 .0336 158.36 11,222,502 .0382 300.90 - 96 - CITY OF COLLEGE STATION COMPUTATION OF LEGAL DEBT MARGIN JUNE 30, 1980 -UNAUDITED- Table VII The City Of College Station has DO general obligation legal debt limit other than a ceiling VD the tax rate as specified by the State of Texas. The pre- scribed 0aXi0WD is $2,50 per $100 at 100% valuation. - 97 - CITY Or COLLEGE STATION STATEMENT OF DIRECT AND ESTIMATED OVERLAPPING DEBT JUN[ 30, 1980 -UNAUDITED- ESTIMATED TAXING BODY: College Station I.S.D. 8raZO3 County BrdZV3 County Road & Bridge Bryan I.S.D. NET DIRECT DEBT: City of College Station NET DIRECT AND ESTIMATED OVERLAPPING DEBT: Net Debt A0UUDt As Of % $ 7,897,000 8/31/80 72,96 12/31/80 32.48 595,000 12/31/80 32,48 12,522,000 8/31/80 2,05 ll,q45,000 Table VIII Citv/s Share Amount *Per Capita $ 5,751,651 $154.44 193,256 5.18 256,701 6,88 6/30/80 100,00 11,945,000 320,19 $18,155,608 $486.69 *Population 37,306 based On preliminary 1980 census. - 98 - CITY OF COLLEGE STATION RATIO OF ANNUAL DEBT SERVICE EXPENDITURES FOR GENERAL OBLIGATION DEBT TO TOTAL GENERAL FUND EXPENDITURES LAST TEN FISCAL YEARS -UNAUDITED- Table IX Total Total Fiscal Debt General Fund Year Principal Interest Service Expenditures Ratio 1970-71 $ 15,000 $ 38,130 $ 53,130 $ 613,685 8.66% 1971-72 45,000 61,661 106,661 589,623 18.09 1972-73 45,000 61,801 106,801 740,845 14.42 1973-74 45,000 58,872 103,872 901,771 11.52 1974-75 50,000 56,222 106,222 1,115,793 9.52 1975-76 50,000 52,684 102,684 1,294,910 7.93 1976-77 50,000 290,441 340,441 1,964,868 17.33 1977-78 118,750 189,442 308,192 2,353,609 13.09 1978-79 150,250 298,569 448,819 2,845,220 15.77 1979-80 884,036 683,133 1/ 1,567,169 2/ 3,733,099 41.98 1/ In fiscal year 79-80, all General Obligation Bonded Indebtedness was consolidated in the General Long Term Debt Group of Accounts. All retirement of that debt was also made from the Debt Service Fund. In all prior years, a portion of the debt was incorrectly reflected as indebtedness of the Utility Fund. 2/ In fiscal year 79-80, the Sanitation Fund was set up as an Enterprise Fund and is no longer supported by the General Fund. - 99 Fiscal Year 1970-71 1971-72 1972-73 1973-74 1974-75 1975-76 1976-77 1977-78 1978-79 1979-80 Gross Revenues $ 1,423,272 1,743,016 2,089,404 2,566,360 3,457,424 4,882,274 6,544,345 8,057,633 8,862,537 10,324,011 CITY OF COLLEGE STATION SCHEDULE OF REVENUE BOND COVERAGE LAST TEN FISCAL YEARS -UNAUDITED- Operating Expenses $ 921,741 1,050,064 1,313,504 1,740,976 2,704,674 4,001,477 5,507,207 6,532,582 6,210,206 7 ,859 ,600 ,4F-Gpl Net Available For Debt Service $ 501,531 $ 42,167 692,952 77,632 775,900 77,278 825,384 93,789 752,750 92,888 880,797 91,882 1,037,138 440,100 1,525,051 568,738 2,652,331 566,474 2,464,411 545,389 ���9z4.4• Table X AVERAGE ANNUAL DEBT SERVICE REQUIREMENTS Principal Interest Total Coverage $ 13,334 33,211 31,218 39,001 36,432 33,897 245,603 296,920 280,201 294,472 $ 55,501 110,843 108,496 132,790 129,320 125,779 685,703 865,658 846,675 839,861 9.04 6.25 7.15 6.22 5.82 7.00 1 .51 1.76 3.13 2.93 d.. t 1) City Ordinance No. 1026, as discussed in Note 4 to the financial statements, possibly restricts the use of Utility Fund net revenues for the retirement of General Obligation Bonded Indebtedness. No General Obligation Bonded Indebtedness is included in the average annual debt service requirements. -100- Fiscal Year _ l980-8l lq8l-82 l982-83 l983-O4 l984-85 1985-AG ]985-87 l987-88 1988-89 lq89-90 ]990-9] l991-92 l9q2-93 lg93-94 l994-95 lQ95-96 ]g96-97 l997-98 l9q8-9Q TOTAL: CITY OF COLLEGE STATION DEBT SERVICE REQUIREMENT'S TO MATURITY - GENERAL OBLIGATION BONDS -UNAUDITED- Table XIA Total PriDCjnal Interest Requirements $ 655,000 S 631,810 $ 1,286,810 655,000 593,878 1,248,878 660,000 555,760 1,216,700 675,000 518,595 1,193,595 685,000 482,455 1,157,455 690,000 445,585 1,135,585 690,000 408,473 1,098,473 690,000 371,340 1,051,340 695,000 334,010 1,029,010 695,000 298,065 993,065 695,000 263,023 958,023 670,000 227,333 897,333 070,000 192,368 862,368 675,000 166,935 831,935 675°000 121,385 796,385 625"000 86,710 711,710 625,000 57,710 682,710 350,000 28,410 378,410 170,000 9,860 179,850 $17,728,705 CITY OF COLLEGE STATION DEBT SERVICE REQUIREMENTS TO MATURITY - REVENUE BONDS -UNAUDITED - Table XIB Fiscal Total Year Principal Interest Requirements 1980-81 $ 438,000 $ 552,705 $ 990,705 1981-82 463,000 525,845 988,845 1982-83 493,000 497,298 990,298 1983-84 493,000 466,765 959,765 1984-85 520,000 436,233 956,233 1985-86 545,000 402,725 947,725 1986-87 570,000 373,405 943,405 1987-88 595,000 342,638 937,638 1988-89 595,000 310,558 905,558 1989-90 565,000 279,588 844,588 1990-91 565,000 249,513 814,513 1991-92 575,000 219,425 794,425 1992-93 575,000 188,050 763,050 1993-94 575,000 156,450 731,450 1994-95 575,000 124,300 699,300 1995-96 600,000 91,400 691,400 1996-97 600,000 57,000 657,000 1997-98 475,000 26,600 501,600 TOTAL: $9,817,000 $5,300,498 $15,117,498 - 102 - CITY OF COLLEGE STATION DEBT SERVICE REQUIREMENTS TO MATURITY - NOTES -UNAUDITED- Table XIC Fiscal Total Year Principal Interest Requirements 1980-81 $29,435 $ 5,398 $34,833 1981-82 9,743 3,322 13,065 1982-83 9,643 2,694 12,337 1983-84 8,562 1,798 10,360 1984-85 8,562 1,199 9,761 1985-86 8,562 599 9,161 TOTAL: $74,507 $15,010 $89,517 - 103 - Fiscal Year l98O-8l l98l-82 lD82-83 l983-8/1 l984-85 l985-8O l985-87 \987-A8 l988-AQ l98q-9O l990-9l l991-92 l992-93 l993-94 l9B4-95 l995-46 l996-97 l997-98 l998-39 CITY OF COLLEGE STATION SUMMARY OF DEBT SERVICE REQUIREMENTS TO MATURITY JUNE 30, 1980 -UNAUDITED- Table XID Revenue General Bonds jbliqation Notes Total 990,705 S 1,286,810 $34,833 2,312,348 988,845 1,748,878 13°065 2,250,788 990°298 1,215,760 12,337 2,218,395 959,765 1,193,595 10,360 2,163,720 956,233 1,167,455 9,761 2,133,449 947,725 1'135,585 9,16l 2,092,471 943,405 1,098,473 2,041,878 937,038 1,061,340 1,998,978 905,558 1,029,010 1°934,568 844,588 893,005 1,837,653 814,513 958,023 1,772,336 794,425 897,333 1,691,758 763,050 862,368 1,625,418 731,450 831,935 1,563,385 699,300 796,385 1,495,685 691,400 711,710 1,403,110 657,000 882,710 1"339,710 501,600 378,410 880,010 17286D __". -1--|0109u - 104 -- CITY OF COLLEGE STATION SCHEDULE OF INSURANCE COVERAGE JUNE :30, 1980 -UNAUDITED- Insurance Compprly Royal -Globe, American and Foreign Insurance Cornpany Royal -Globe Insurance Fidelity and Deposit Company of Maryland Fidelity and Deposit Company of Maryland International Surplus Lines Insurance Company Royal -Globe Insurance Royal -Globe Insurance Royal indemnity Cornpany Table XII Type of CoveraRe Workmen's Compensation and Employer's Liability Coverage Police and Emergency Liability: Bodily Injury Property Damage Comprehensive General Liability: Bodily Injury Property Damage Automobile: Bodily Injury Property Damage Comprehensive Disappearance and Destruction: Loss Inside the Premises - Money, Securities, Property Checks Other Than Payroll Loss Outside the Premises - Money, Securities, Property Checks Other Than Payroll Official Bond for Glenn Schroeder Tax Assessor -Collector Public Officials and Employees Liability as Blanket Fire Coverage on Listed Buildings and their Contents Fire Insurance on HTS Building (Bath House) Fire Insurance on House Contents Fire Insurance on Swimming Pool Boiler and Machinery Policy - Broad Accident Coverage - 105 Amount of Coverage $ 100,000 300,000 25,000 Each Person Each Occurrence Each Occurrence $ 300,000 Each Occurrence 300,000 Aggregate 25,000 Each Occurrence 50,000 Aggregate $ 100,000 Each Person 300,000 Each Occurrence 25,000 Each Occurrence $ 20,000 80,000 20,000 80,000 $ 50,000 $ 1,000,000 1,000,000 $11,000,000 Each Loss Aggregate Per Policy Year Policy Period From To 1/01/80 1/01/81 1/01/80 1/01/81 1/31/80 1/31/83 1/31/80 1/31/83 2/15/80 2/15/83 8/20/79 8/20/82 $ 90,000 5,000 250,000 $ 100,000 Per Accident 1/28/79 1/28/82 CITY OF COLLEGE STATION BANK DEPOSITS LAST TEN FISCAL YEARS -UNAUDITED- Fiscal Bank Year Deposits 1970-71 $ 1,894,491 1971-72 2,831 ,713 1972-73 3,030,807 1973-74 3,709,349 1974-75 4,812,414 1975-76 6,695,186 1976-77 10,553,941 1977-78 12,284,766 1978-79 16,675,307 1979-80 24,502,611 Table XIII 107 - Name General Telephone Co. Continental Real Estate MUnZ8l Properties Martell Interests M.A.S.H. #1 Anderson Ridge Assoc. Southwood Volley, Inc. Agency Records, Inc. Southgate Village Courtyard Associates CITY OF COLLEGE STATION PRINCIPAL TAXPAYERS JUNE 30, l980 -UNAUDITED- Type of Property Telephone Utility Apartments Apartments Apartments Apartments Apartments Developers Accounting @ Manufacturing Apartments Apartments Table XIV 1979 ASSHSSed Value $8,005,220 4,890,500 4,639,400 4,536,500 3,882,800 3,758,500 2,960,800 2,684,300 2,507,700 2,495,300 - 108 -- ^ r CITY OF COLLEGE STATION MISCELLANEOUS STATISTICAL DATA JUNE 30, 1980 -UNAUDITED-- I Table XV Page l of 4 Date Incorporated . , , . , . ^ ^ . . . , October, 1938 Date First Charter Adopted . , . . . . . October. 1938 Date Present Charter Adopted . . . ^ . . ^ ^ ' , June, 1980 FOMn of GOV8rD0eUt . , . . . ^ . ~ - - , Council -Manager Area in Square Miles . , Miles of Streets . . . . . , Year 1938 ]'5 1948 4,2 1958 7.3 1968 17.3 1978 22.6 lgRO 23.8 , Paved 116.2 Miles Unpaved 2,5 Miles Miles of Sidewalks . ' - . . . , , 19.7 Miles Miles of Sanitary Sewer . . . ^ . . . 96.1 Miles Buildinq Permits Number Year Of Permits 1971 242 \972 265 1973 277 1974 272 1975 461 1976 650 1977 646 1978 527 1979 519 1980 597 Valu2 _ 8,356,39l 12,507,781 19,234,595 8,097,048 ll,366,4O8 23,614,206 3O,27l,592 22,019,948 20,353,988 35,405,495 - 109 - Fire Protection: Number Of Stations . CITY OF COLLEGE STATION MISCELLANEOUS STATISTICAL. DATA JUNE 30, 1980 -UNAUDITED- ^ ^ '^ Police Protection: Number of Employees (Uniformed) . Number of Employees (Plain Clothes, Clerical) Number of Patrol Units , . . . . . . . , . ^ One Jail Facility With a Capacity of 20 Recreation: Number Of Playgrounds Number of Swimming Pools Numb8r, of Soccer Fields , . .. 2 . , 62 ... ............ ^ ' - '^` ~````-^ .. .. Number Of Softball/Baseball Fields Number of Picnic Shelters . ' NU0h8r Of Gyms Facili ty Anderson Park 88e Creek Park Brentwood Park RrisOD Park Brother's Pond College Station Central Ea5tgate Fairview GUhbdrd Park Georgia K. Fitch Lemon Tree Park Park ... . . ^ 0 2 12 ]4 3 l ACreS Facil1 ty 8.94 Lincoln Center 43,50 LiOD/D Park 7.69 L0Dg0ire Park 9.20 Merry Oaks 16.12 Oaks Park 47,22 Parkway 1,00 KaiDtre8 1.80 Southwest Park 10,67 Southwood Complex l0.30 Thomas Park 15,43 Wayne Smith Park TOTAL ACREAGE Table XV Page 2 of 4 Acres 8.00 l,5O 4.16 4,60 7'50 1.00 2.28 ],4O 44.65 l6.l0 4.07 2G7-l3 ==== CITY OF COLLEGE STATION MISCELLANEOUS STATISTICAL DATA JUNE 30, 1980 -UNAUDITED-,- Total Number of Users . . . . 10,719 �YV Electric Users ` ' ^ ` ~ ` ' 9,120 5l7 Water Users . , ^ ' , . ~ . , ^ . . . ~ ~ , ' 5,517 Average Electrical Consumption: 15,667,574 KNH/Mo' During 1979-80 Average Water C0DSU0pti0D: 108,602,000 Gals./MO' During 1979-80 Number of Employees TDtxl Electric 10 l 20 Water 40 2 61 Table XV Page 3 of 4 � Water C� i ; ��� � Number of Wells ' , , , . . . 3 � Combined Capacity of Wells . . . . 8,850,000 MGD � Number Of Ground Storage Tanks . . 2; Total Capacity 6,000"000 Gals. � Number of Elevated Storage Tanks . l; Total Capacity 1,000,000 Gals. | Miles of Water Lines , , 101.2 EleCtri Maximum Capacity . 120 Megawatts � Number of Switching Stations 2 Number Of Substations ' . ' . I Miles of Distribution Lines ' . 98.3 Sanitati n Fund: 7O7 Number of Users . , 6,787 Landfill Size . ^ . 45 Acres Methodology , . . . Curbside Pickup Using Plastic Bags CITY OF COLLEGE STATION MISCELLANEOUS STATISTICAL DATA JUNE 30, 1980 --UNAUDITED- Elections: Number Of Registered Voters: Last General El8Ct10D . , , . 14,744 Last Municipal Election . . . . , . . 6,763 Number Of Votes Cast In: Last General Election . . , , . . . . ' 10,668 Last Municipal Election 1,237 Percentage of Registered UOt8r3 Voting In: Last General Election 72% Last Municipal Election ..`.... 18% Population: Year Number C8D3U3 Count . . , . . 1880 37,306 1970 17,676 1960 11,396 1950 7,925 Table XV Page 4 Of 4