Loading...
HomeMy WebLinkAboutFY 1974 Financial Statements and Supplementary Information - AuditCITY OF EULESS, TEXAS FINANCIAL STATEMENTS AND SUPPLEMENTARY INFORMATION YEAR ENDED SEPTEMBER 30 , 1974 with REPORT OF CERTIFIED PUBLIC ACCOUNTANTS • ARTHUR YOUNG & COMPANY • Exhibit A Exhibit A-1 Exhibit A-2 Exhibit A-3 Exhibit A-4 Exhibit A-5 CONTENTS The Municipal Finance Officers Association Certificates of Conformance Letter of transmittal Report of certified public accountants Financial statements Combined balance sheet - all funds Combined statement of cash receipts and expenditures - all funds Combined schedule of changes in taxes receivable Combined schedule of taxes receivable by funds Combined schedule of bonds payable Combined schedule of cash and investments General Fund Page 1 2- 3 4 5 5 6 7 Exhibit B Balance sheet 8 Exhibit B-1 Analysis of changes in fund balance 9 Exhibit B-2 Statement of revenues - estimated and actual 10-11 Exhibit B-3 Statement of expenditures compared with authorizations 12-23 Exhibit C Exhibit C-1 Exhibit C-2 Exhibit D Exhibit D-1 Exhibit D-2 Debt Service Fund Balance sheet 24 Analysis of changes in reserve for retirement of general long-term debt 24 Statement of revenues and expenditures 25 Capital Projects Funds Balance sheet 26 Statement of cash receipts and disbursements 27 Statement of expenditures compared with appropriations 28 Exhibit E Exhibit E-1 Exhibit E-2 Exhibit E-3 Exhibit F Exhibit F-1 Exhibit G Exhibit G-1 Exhibit G-2 Exhibit H Table I Table II Table III Table IV Table V Table VI Table VII Table VIII Table IX CONTENTS Financial statements (continued) Water and Sewer Enterprise Fund Balance sheet Analysis of changes in retained earnings Statement of revenues and expenses - actual and budgeted Notes to Water and Sewer Enterprise Fund financial statements Schedule of operating expenses budgeted and actual Trust and Agency Funds Balance sheet Statement of cash receipts and disbursements General Fixed Assets Statement of general fixed assets Statement of changes in general fixed assets by source Schedule of general fixed assets classified by departments General long-term debt Statement of general long-term debt Supplementary information - statistical data Tax levies and tax collections Tax rates and tax levies Revenues - other than property taxes Expenditures for selected functions General obligation bonds other than water and sewer revenue debt service charges Revenue water and sewer bonds debt service charges Trinity River Authority - 1969-C Series contract debt service charges Insurance in force Miscellaneous statistical facts Page 29 30 31 32 33-35 36 37 38 39 40 41 42 43 44 45 46 47 48 49-50 51 REPORT THE MUNICIPAL FINANCE OFFICERS ASSOCIATION OF THE UNITED STATES AND CANADA (tertifiees tfjat TIIE ANNUAL FINANCIAL REPORT OF _ The City of Cu less, Texas }or the Fiscal year Endcd. Septem.ber30,1964 CONFORMS TO THE PRINCIPLES AND STANDARDS OF PUBLIC FINANCIAL REPORTING AS PROMULGATED BY THE �lunici at jfinance ®fficeres Ztesgociation AND THE ,. ationat Committee on cibobernmentat Ztccounting Presented janua],ry 13, 1965. c�J Chairman, Committee on Accounting Executive Director A Certificate of Conformance is awarded by the Municipal Finance Officers Association of the United States and Canada only to the governmental unit whose financial report is judged to substantially conform to the high standards of financial reporting established by the Association. These standards are contained in publications of the National Com- mittee on Governmental Accounting. THE MUNICIPAL FINANCE OFFICERS ASSOCIATION OF THE UNITED STATES AND CANADA mm=mm THE ANNUAL FINANCIAL REPORT OF 'The city of Euless, ` ixas 1-or the Fiscal Year Elided September 30,1971 SUBSTANTIALLY CONFORMS TO THE PRINCIPLES AND STANDARDS OF PUBLIC FINANCIAL REPORTING AS PROMULGATED BY THE Municipal finance ti: fficerz asssociation AND THE Rational (Committee on eobernmental Zccounting THIS SUPPLEMENTS A CERTIFICATE OF CONFORMANCE PRESENTED TO TH,E ABOVE NAMED GOVERNMENTAL UNIT Ontlikaty 13, 1,65 Presented ACtv01 31,1,72. Irnnan, Corhmitiee on A� nr g �a-Ar i Execusive wreck,/ A Certificate of Conformance is awarded by the Municipal Finance Officers Association of the United States and Canada only to the governmental unit whose financial report is judged to conform substantially to the high standards for financial reporting established by the Association. A Certificate of Conformance was first awarded to this governmental unit for its annual financial report for the fiscal year ended September 30, 1964, for meeting stan- dards of financial reporting which were then applicable; a Supplemental Certificate has been awarded for substan- tially meeting later and revised standards. These stand- ards are contained in publications of the National Com- mittee on Governmental Accounting which are reviewed and revised by the Committee from time to time. ?Th' Ltltl�i}1tt� { Ittilltrr Qffi1tr0 ,A uri ttiIin of thr thtitrb .ttttro nub (Tanttdtt PRESENTS THIS AWARD OF ACCOUNTING ACHIEVEMENT TO C. 3. Griggs WHOSE EFFORTS HAVE LED TO THE City of Cul¢ss, Texas RECEIVING THE MUNICIPAL FINANCE OFFICERS ASSOCIATION AND THE NATIONAL COMMITTEE ON GOVERNMENTAL ACCOUNTING CERTIFICATE OF CONFORMANCE FOR PUBLIC FINANCIAL REPORTING a President Executive Director This Award of Accounting Achievement was presented to the City Manager in 1973 by the Municipal Finance Officers Association in personal recognition of his part in the high standard of public financial reporting followed by the City of Euless. City o f uteOo EULESS, TEXAS BUTLER 3.5381 201 ECTOR DRIVE 76039 Honorable A. C. Krause, Mayor and City Council City of Euless Euless, Texas Gentlemen: October 25, 1974 The annual financial report of the City of Euless, Texas, for the fiscal year ended September 30, 1974, is submitted herewith. Accounting System and Reports The City's accounting records for general governmental operations are maintained on a modified cash basis, wherein revenues are reported primarily when collected and expenditures when incurred. Accounting records for the City's utility are maintained on a full accrual basis. In accordance with prescribed standards, deprecia- tion of general fixed assets is not recognized in the City's account- ing system; however, depreciation on the depreciable property of the utility is recognized in the accounts and is computed on the expected useful life of the assets. All operating funds of the City function under an annual budget which shows estimated revenues and authorized expenditures by funds. On March 31, 1972, the Municipal Finance Officers Association and the National Committee on Governmental Accounting awarded its Supplemental Certificate of Conformance for financial reporting for the annual financial report of the City of Euless for the year ended September 30, 1971. The latter report was judged to continue to conform substantially to the high standards for finan- cial reporting promulgated by that Association and the National Committee on Governmental Accounting for which the City had earlier received a Certificate of Conformance for conforming to the then existing standards. We believe our present annual report for the year ended September 30, 1974, continues to conform substantially to such standards for which a Supplemental Certificate was granted. In 1974, Mr. C. J. Griggs received the Award of Accounting Achievement from the Municipal Finance Officers Association for his efforts in the City's obtaining the Certificate of Conformance mentioned above. General Comments Information as to the City's tax assessments and collections, bonded indebtedness, insurance in force, water and sewer revenue bond coverage and other miscellaneous data is contained in tables under "Statistical Data" in the annual financial report. The significant net changes during the year in the balances of the principal operating funds of the City may be summarized as follows: General Fund: Cash and investments Total revenues Total expenditures Water and Sewer Enterprise Fund: Cash and investments Retained earnings, reserves and contributions Increase 1974 1973 (decrease) $ 343,214 $ 332,141 $ 11,073 $1,489,357 $1,195,452 $ 293,905 $1,525,887 $1,084,957 $ 440,930 $ 706,640 $ 907,382 $(200,742) $2,713,083 $2,204,109 $ 508,974 U. S. Government securities have been pledged by depository banks sufficient to secure the City's funds on deposit with such banks. Ordinances authorizing the issuance of the City's water and sewer revenue bonds have been read and in accordance with the require- ments of such ordinances, a total of $100,000 has been restricted for emergencies. The City has retired a total of $1,650,000 of revenue bonds with proceeds from the sale of water and sewer facilities to the City of Bedford, and $423,288 of principal proceeds remains on deposit with the City's paying agent in New York City. Independent Audit The books of account, financial records and transactions of all administrative departments of the City are subject to audit annually by certified public accountants selected by the City Council. The report of Arthur Young & Company, Certified Public Accountants, is included with this report. Respectfully submitted, Mrs. Vada Ferris City Secretary ARTHUR YOUNG & COMPANY 2200 FORT WORTH NATIONAL BANK BUILDING FORT WO RTH, T EXA S Honorable A. C. Krause, Mayor and City Council City of Euless Euless, Texas We have examined the accompanying balance sheets of the various funds and balanced account groups of the City of Euless, Texas, at September 30, 1974 and the related statements of revenue, expenditures and changes in fund balances and re- tained earnings for the fiscal year then ended, listed in the accompanying index. Our examination was made in accordance with generally accepted auditing standards, and accordingly in- cluded such tests of the accounting records and such other auditing procedures as we considered necessary in the circum- stances. In our opinion, the statements mentioned above present fairly the financial position of the various funds and balanced account groups of the City of Euless, Texas, at September 30, 1974 and the results of operations for the fiscal year then ended, in conformity with generally accepted accounting prin- ciples applied on a basis consistent with that of the preceding year. It is our further opinion that the accounting require- ments of the bond ordinances under which the City's general obligation and water and sewer revenue bonds were issued have been met. Our examination has been made primarily for the purpose of expressing an opinion on the financial statements, taken as a whole. The accompanying supplementary information is presented for analysis purposes and is not necessary for a fair presenta- tion of the financial information referred to in the preceding paragraph. It has been subjected to the tests and other auditing procedures applied in the examination of the financial statements mentioned above and, in our opinion, is fairly stated in all respects material in relation to the financial statements taken as a whole. cf-,-AA-A.,,4,--.7 4-C9.--17'"-.07 October 25, 1974 2 CITY OF EULESS, TEXAS COMBINED BALANCE SHEET - ALL FUNDS September 30, 1974 ASSETS AND OTHER DEBITS Cash and short-term investments (Exhibit A-5) Taxes receivable (Exhibit A-2) Assessments receivable Accounts receivable (net) Due from other funds Restricted assets: Cash and short-term investments (Exhibit A-5) Cash and investments with paying agent Interest receivable on investments Land Buildings Improvements other than buildings Equipment Due from other funds Amount available for retirement of general long-term debt Amount to be provided for retirement of general long-term debt General Fund $343,214 103,350 937 58,731 Debt Service Fund $285,211 38,342 Capital Projects Funds Water and Sewer Enterprise Fund Trust and Agency Funds $1,017,100 $ 706,640 $101,705 18,587 132,835 113,786 625,871 736,217 5,282 32,970 5,884,833 151,229 General Fixed Assets 1,137,295 2,920,411 560,091 General Long-term Debt 152,376 3,472,624 Total assets and other debits $506,232 $323,553 $1,168,522 $8,256,828 $101,705 $4,617,797 $3,625,000 EXHIBIT A 3 CITY OF EULESS, TEXAS COMBINED BALANCE SHEET -. ALL FUNDS September 30, 1974 (Continued) LIABILITIES Payroll taxes and other payables Customer and developers' deposits Accrued revenue bond interest payable General long-term debt payable Due to other funds Total liabilities Deferred revenues RESERVES AND FUND BALANCES/RETAINED EARNINGS Reserve for uncollected taxes and assessments Reserve for revenue and general bond debt service Reserve for revenue bond retirement Reserve for revenue bond contingency Contributions from subdividers and others Investment in general fixed assets Fund balances Retained earnings Total liabilities, reserves and fund balances/retained earnings EXHIBIT A General Fund $ 26,437 723 27,160 103,350 375,722 Debt Service Fund Capital Projects Funds $ - $ 220 14,879 132,835 132,835 38,342 152,376 58,731 73,830 18,587 1,076,105 Water and Sewer Enterprise Fund $ 75,593 95,874 45,205 5,075,000 5,291,672 252,073 50,985 261,944 100,000 1,257,517 1,042,637 Trust and Agency Funds $ 37,756 $ 51,050 88,806 12,899 General Fixed Assets 4,617,797 General Long-term Debt 3,625,000 3,625,000 $506,232 $323,553 $1,168,522 $8,256,828 $101,705 $4,617,797 $3,625,000 4 CITY OF EULESS, TEXAS COMBINED STATEMENT OF CASH RECEIPTS AND EXPENDITURES - ALL FUNDS Year ended September 30, 1974 Balance Balance 10-1-73 Receipts Expenditures 9-30-74 General Fund $ 178,151 $2,463,021 $2,449,211 $ 191,961 Debt Service Fund 170,540 425,228 310,557 285,211 Capital Projects Funds 249,388 1,503,003 735,291 1,017,100 Water and Sewer Enterprise Fund 1,152,490 2,242,354 2,099,182 1,295,662 Trust and Agency Funds 62,238 675,547 636,080 101,705 Total - all funds $1,812,807 $7,309,153 $6,230,321 $2,891,639 EXHIBIT A-1 5 CITY OF EULESS, TEXAS COMBINED SCHEDULE OF CHANGES IN TAXES RECEIVABLE Year ended September 30, 1974 Balance at beginning of year Add: Taxes levied Transfers from current taxes Deduct: Collections Transfers to delinquent taxes Adjustments Balance at end of year Total $ 58,161 $ 1,173,599 101,893 1,333,653 1,080,949 101,893 9,119 1,191,961 $ 141,692 EXHIBIT A-2 Current taxes 1,173,599 1,173,599 1,070,877 101,893 829 1,173,599 COMBINED SCHEDULE OF TAXES RECEIVABLE BY FUNDS September 30, 1974 Delinquent taxes receivable: General Fund Debt Service Fund EXHIBIT A-3 Delinquent taxes $ 58,161 101,893 160,054 10,072 8,290 18,362 $141,692 $103,350 38,342 $141,692 CITY OF EULESS, TEXAS COMBINED SCHEDULE OF BONDS PAYABLE September 30, 1974 Description Bonds authorized Bonds issued: General Obligation Bonds: Series 1964 Series 1965 Series 1966 Series 1968 Series 1971 Series 1973 Water and Sewer Revenue Bonds: (Note) Series 1965 Series 1967 Series 1971 Total issued and outstanding Balance authorized - unissued Rates of interest 3.6% to 3.875% 3.85% to 5% 4.65% 4.5% to 5% 4% to 5.4% 5% to 6 . 5% 4.5% to 5.5% 4.5% 4.75% to 6% Dates 9-28-64 7- 1-65 7- 1-66 7- 1-68 5-28-71 12- 1-73 7-15-65 1-15-67 5-28-71 Street and drainage $4,395,000 430,000 295,000 205,000 200,000 350,000 1,000,000 2,480,000 2,480,000 $1,915,000 Note: In addition to the above Water and Sewer Revenue Bonds, the City of Euless has contracted with Trinity River Authority to fund certain bonded indebtedness of that organization from water and sewer revenues. The City is obligated to make monthly payments sufficient to pay maturing principal and interest on bonds issued in the original amount of $390,000. Annual debt service payments average approximately $32,000 over 28 years. The City has revised other contracts previously in effect with TRA for water supply and sewage treatment services beginning in 1974. Under the new contract, annual charges by TRA for water and sewer services will aggregate approximately $570,000. Such charges paid by the City in the year ended September 30, 1974 totaled approximately $382,000. Of these amounts, $216,000 in future years and $144,000 in 1974 are earmarked as applicable to City pledged debt service of TRA. EXHIBIT A-4 Public buildings Bonds Parks $1,490,000 $3,490,000 470,000 160,000 120,000 40,000 790,000 790,000 100,000 75,000 75,000 100,000 110,000 300,000 760,000 Water and sewer Total $10,800,000 $20,175,000 - 1,000,000 530,000 400,000 300,000 500,000 1,300,000 - 4,030,000 - 3,600,000 2,200,000 800,000 760,000 $ 700,000 $2,730000 6,600,000 6,600,000 $ 4,200,000 3,600,000 2,200,000 800,000 6,600,000 10,630,000 $ 9,545,000 Balance outstanding 9-30-74 $ 785,000 530,000 400,000 285,000 425,000 1,200,000 3,625,000 2,660,000 1,335,000 700,000 4,695,000 $8,320,000 CITY OF EULESS, TEXAS COMBINED SCHEDULE OF CASH AND INVESTMENTS September 30, 1974 Combined bank balances and investments: Bank accounts: First National Bank of Euless: Consolidated account Trust and Agency account Certificates of deposit Payroll Banker's Trust Company, New York Water and Sewer Revenue bond reserve account Water and Sewer Revenue bond sinking fund account Total on deposit with banks Petty cash funds Total cash Investments in U. S. Government securities: (Held by Bankers Trust Company, New York) Water and Sewer Revenue bond reserve - 6-3/8% U. S. Treasury Notes Water and Sewer Fund - property sales proceeds account - U. S. Treasury Notes Investments in U. S. Government securities: (Held in safe- keeping by National Bank of Commerce, Dallas, Texas) U. S. Treasury Bills - $100,000 par maturing February 2, 1975 General Fund - U. S. Treasury Bills - $160,000 par maturing December 26, 1974 Amount $ 187,080 50,655 2,594,321 300 2,832,356 8,033 50,985 59,018 2,891,374 265 2,891,639 253,912 423,288 95,866 151,253 $3,815,958 Securities guaranty Deposit insurance guaranty - $20,000 20,000 20,000 300 2,815,000 60,300 8,033 20,000 28,033 $2,815,000 $88,333 Cash and investments by fund: Funds: General Fund: Operations Payroll General Debt Service Fund Water and Sewer Enterprise Fund: Operating Restricted: Revenue bond debt service Revenue bond reserve Revenue bond contingency Property sale proceeds account Capital projects account Customer deposits Trust and Agency Funds: Escrow Social security Capital Projects Funds: Park and recreation Street and drainage Service center Revenue sharing Total all funds Demand accounts Time deposits Petty cash funds Securities guaranty is composed of general obligations of various local state and national governmental bodies which have been placed with a third party by the depository bank as security for deposits of the City of Euless. EXHIBIT A-5 Cash and Treasury Certificates Bills of Deposit $151,253 $ 191,661 300 151,253 191,961 285,211 95,866 610,774 50,985 253,912 8,032 100,000 423,288 429,997 95,874 773,066 1,295,662 $924,319 51,050 50,655 101,705 45,710 738,020 40,000 193,370 1,017,100 $2,891,639 $ 297,053 2,594,321 265 $2,891,639 Total $ 342,914 300 343,214 285,211 706,640 50,985 261,944 100,000 423,288 429,997 95,874 2,068,728 51,050 50,655 101,705 45,710 738,020 40,000 193,370 1,017,100 $3815,958 $ 297,053 2,594,321 8 CITY OF EULESS, TEXAS GENERAL FUND BALANCE SHEET September 30, 1974 ASSETS Cash and short-term investments (Exhibit A-5) $343,214 Taxes receivable 103,350 Due from Park and Recreation Department 58,731 Miscellaneous 937 RESERVES AND FUND BALANCE Escrow deposits Accounts payable Reserve for uncollected taxes Court costs collected for State of Texas Fund balance (Exhibit B-1) $506,232 $ 723 23,339 103,350 3,098 375,722 $506,232 EXHIBIT B 9 CITY OF EULESS, TEXAS GENERAL FUND ANALYSIS OF CHANGES IN FUND BALANCE Year ended September 30, 1974 Fund balance, October 1, 1973 $412,252 Add: Excess of revenues over expenditures: Revenues (Exhibit B-2) Expenditures (Exhibit B-3) $1,489,357 1,525,887 (36,530) Fund balance, September 30, 1974 $375,722 EXHIBIT B-1 10 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF REVENUES - ESTIMATED AND ACTUAL Year ended September 30, 1974 General property taxes collected: Current taxes Delinquent taxes Penalty and interest Gross receipts taxes: Southwestern Bell Telephone Company Texas Power and Light Company Lone Star Gas Company Tarrant County Trash Disposal Mixed beverage General sales tax Licenses and permits: Building permits Plumbing permits Electric permits Heating and air conditioning permits Street inspections Miscellaneous permits Electric license exams Estimated Actual revenues revenues Actual over (under) estimated $ 812,807 $ 768,681 $(44,126) 16,000 10,072 (5,928) 1,600 5,886 4,286 830,407 784,639 (45,768) 21,000 56,000 21,000 5,000 4,000 107,000 150,000 18,000 3,500 4,500 1,000 500 1,150 2,500 31,150 23,741 90,373 22,785 5,985 6,947 149,831 227,570 9,007 2,569 5,362 2,413 2,799 1,552 3,333 27,035 2,741 34,373 1,785 985 2,947 42,831 77,570 (8,993) (931) 862 1,413 2,299 402 833 (4,115) EXHIBIT B-2 11 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF REVENUES - ESTIMATED AND ACTUAL Year ended September 30, 1974 (Continued) Fines and fees: Corporation court fines Dog pound fees Other revenues: Library receipts Tarrant County Library contributions Tarrant County fire assistance Interest income Rental income Miscellaneous income Reimbursements from water system funds - assessment in lieu of taxes Emergency Employment Grant State Library Grant Traffic Safety Administration Swimming pools GENERAL FUND REVENUES Estimated revenues Actual revenues Actual over (under) estimated $ 95,000 $ 122,806 $ 27,806 400 1,041 641 95,400 1,600 2,000 2,800 25,000 2,340 10,400 18,528 5,000 23,865 22,000 113,533 $1,327,490 123,847 1,873 5,207 3,000 74,605 1,460 14,591 18,528 6,542 2,460 27,237 20,932 176,435 $1,489,357 28,447 273 3,207 200 49,605 (880) 4,191 6,542 (2,540) 3,372 (1,068) 62,902 $161,867 EXHIBIT B-2 12 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH AUTHORIZATIONS Year ended September 30, 1974 Actual (over) Appropriations Expenditures under General Government: Supervision $ 21,500 $ 22,208 $ (708) Clerical 10,764 9,609 1,155 Labor operations 5,500 4,631 869 Extra help 2,400 2,241 159 Longevity 500 571 (71) Employee benefits 7,700 6,762 938 Office supplies 2,600 2,883 (283) Motor fuel 300 210 90 Maintenance - equipment 1,200 858 342 Communications 1,850 2,233 (383) Hire of equipment 4,000 3,130 870 Insurance 900 624 276 Special services 2,600 3,842 (1,242) Engineer fees 10,000 7,713 2,287 Audit fees 1,225 1,475 (250) Tax office fees 18,080 15,672 2,408 Advertising 500 157 343 Travel expense and meetings 9,500 10,735 (1,235) Dues and subscriptions 2,800 3,426 (626) Elections expense 600 820 (220) Signal systems 50 50 Capital expenditures: Furniture 300 414 (114) Machinery 600 1,207 (607) 105,469 101,421 4,048 Less departmental allocations: Law Enforcement 5,360 5,360 - Library 10,104 10,104 15,464 15,464 - 90,005 85,957 4,048 EXHIBIT B-3 13 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH AUTHORIZATIONS Year ended September 30, 1974 (Continued) Law Enforcement: Police Department: Supervision Clerical Labor operations Employee benefits Longevity Overtime Office supplies Wearing apparel Motor fuel supplies Education supplies Maintenance - furniture and fixtures Maintenance - traffic signals Maintenance - motor vehicles Maintenance - signal system Communications Special services Travel expense and meetings Electricity Association dues and subscriptions Support of persons Insurance - vehicles Advertising Minor apparatus Awards Hire of equipment Capital expenditures: Motor vehicles Furniture and fixtures Signal systems and other Appropriations $ 14,520 34,604 243,273 37,574 3,187 4,500 2,000 5,200 4,800 150 75 7,000 9,650 900 4,000 1,700 3,000 1,200 800 3,500 150 2,500 150 1,000 25,500 600 6,450 417,983 Actual (over) Expenditures under $ 15,710 36,647 291,573 44,020 4,051 21,645 2,517 7,727 8,700 7,090 79 8,175 13,476 2,193 2,849 2,605 2,882 2,446 1,606 1,936 3,843 32 5,543 150 3,078 27,036 439 7,306 525,354 $ (1,190) (2,043) (48,300) (6,446) (864) (17,145) (517) (2,527) (3,900) (6,940) (4) (1,175) (3,826) (1,293) 1,151 (905) 118 (2,446) (406) (1,136) (343) 118 (3,043) (2,078) (1,536) 161 (856) (107,371) EXHIBIT B-3 14 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH AUTHORIZATIONS Year ended September 30, 1974 (Continued) Law Enforcement: (continued) Legal and Corporation Court: Judge's salary Clerical Office supplies City attorney's fees Other Salary -related expenses Capital expenditures: Machinery Furniture and fixtures Administrative expense allocation Total Law Enforcement Fire Department: Labor operations Employee benefits Longevity Office supplies Wearing apparel Motor fuel supplies Minor apparatus Janitorial supplies Chemicals Maintenance - building Maintenance - heating and cooling systems Maintenance - instruments and apparatus Maintenance - motor vehicles Maintenance - signal system Actual (over) Appropriations Expenditures under $ 3,500 5,496 1,000 14,000 580 1,129 25,705 5,360 449,048 206,660 27,457 1,596 300 2,200 2,300 5,000 2,200 50 600 800 150 15,500 650 $ 6,556 11,607 2,569 24,889 1,004 3,660 737 200 ' 51,222 5,360 581,936 229,519 26,451 1,308 298 2,507 6,941 5,314 3,806 13 1,125 281 187 12,996 818 $ (3,056) (6,111) (1,569) (10,889) (424) (2,531) (737) (200) (25,517) (132,888) (22,859) 1,006 288 2 (307) (4,641) (314) (1,606) 37 (525) 519 (37) 2,504 (168) EXHIBIT B-3 15 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH AUTHORIZATIONS Year ended September 30, 1974 (Continued) Actual (over) Appropriations Expenditures under Fire Department: (continued) Insurance $ 1,800 $ 2,039 $ (239) Communications 1,500 1,374 126 Travel expense and meetings 400 583 (183) Rents 300 275 25 Hire of equipment 100 143 (43) Awards 74 (74) Association dues and subscriptions 300 204 96 Electric 1,300 1,444 (144) Water 400 377 23 Gas 1,100 655 445 Advertising 24 (24) Special services and other 2,120 176 1,944 Capital expenditures: Furniture and fixtures 50 769 (719) Instruments and apparatus 1,000 978 22 Signal systems 2,000 2,000 Books 148 (148) 277,833 300,827 (22,994) Street Department: Supervision 11,490 11,521 (31) Labor operations 41,628 28,194 13,434 Clerical 4,800 1,498 3,302 Extra help, overtime and longevity 5,312 2,482 2,830 Employee benefits 8,503 7,699 804 Wearing apparel 1,400 1,232 168 Motor fuel supplies 2,540 2,520 20 Office supplies 300 449 (149) Chemical supplies 400 1,350 (950) Mechanical, janitorial and laundry supplies 50 46 4 Street lights - electricity and repairs 7,378 7,785 (407) EXHIBIT B-3 16 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH AUTHORIZATIONS Year ended September 30, 1974 (Continued) Actual (over) Appropriations Expenditures under Street Department: (continued) Maintenance - streets $ 40,500 $ 34,873 $ 5,627 Maintenance - machinery and other 1,620 2,342 (722) Maintenance - motor vehicles 1,200 1,729 (529) Insurance - motor vehicles 1,100 1,593 (493) Communications 330 330 Hire of equipment 6,000 10,571 (4,571) Minor apparatus 1,600 1,791 (191) Travel expense 300 70 230 Capital expenditures: Motor vehicles and machinery 10,700 28,807 (18,107) 147,151 146,882 269 Traffic Safety Administration: Supervision 13,398 14,808 (1,410) Clerical 5,886 6,804 (918) Longevity 108 132 (24) Benefits 1,707 1,890 (183) Office supplies 1,220 1,903 (683) Communication 134 97 37 Hire of equipment 120 120 Travel 1,292 672 620 Miscellaneous 73 (73) 23,865 26,499 (2,634) Animal Control: Labor operations 14,652 13,252 1,400 Longevity 192 119 73 Overtime 500 773 (273) Employee benefits 1,823 1,794 29 Office supplies 150 150 Motor fuel supplies 350 350 Maintenance - motor vehicles 600 203 397 Maintenance - signal systems 300 144 156 EXHIBIT B-3 17 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH AUTHORIZATIONS Year ended September 30, 1974 (Continued) Actual (over) Appropriations Expenditures under Animal Control: (continued) Wearing apparel $ 600 $ 247 $ 353 Insurance 300 451 (151) Animal care 400 680 (280) Other 675 575 100 Capital expenditures: Motor vehicles 3,600 2,293 1,307 24,142 21,031 3,111 Building and Zoning Department: Supervision 10,572 11,526 (954) Clerical 5,562 6,513 (951) Labor operations 7,212 7,860 (648) Extra help 600 600 Longevity 656 781 (125) Employee benefits 2,500 2,810 (310) Office supplies 600 712 (112) Motor fuel supplies 600 615 (15) Insurance 200 395 (195) Maintenance - motor vehicles 375 285 90 Maintenance - signal systems 100 144 (44) Communications 350 350 Advertising 150 181 (31) Hire of equipment 300 450 (150) Travel expense and meetings 500 889 (389) Wearing apparel 175 200 (25) Association dues and subscriptions 50 12 38 Capital expenditures - fixtures 200 578 (378) 30,702 34,301 (3,599) EXHIBIT B-3 18 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH AUTHORIZATIONS Year ended September 30, 1974 (Continued) Actual (over) Appropriations Expenditures under School Crossing Guard: Labor $ 6,000 $ 5,857 $ 143 Benefits 300 865 (565) 6,300 6,722 (422) Library: Supervision 5,550 6,442 (892) Clerical 12,432 14,790 (2,358) Extra help 5,216 6,706 (1,490) Longevity 816 916 (100) Benefits 2,800 2,984 (184) Office supplies 1,500 2,303 (803) Insurance 300 745 (445) Maintenance 90 166 (76) Rebinding books 2,500 1,354 1,146 Communications 402 367 35 Travel expense and meetings 350 370 (20) Association dues and subscriptions 110 107 3 Other 2,690 922 1,768 Capital expenditures - books 10,000 10,148 (148) Furniture and fixtures 2,205 227 1,978 46,961 48,547 (1,586) Administrative expense allocation 10,104 10,104 - 57,065 58,651 (1,586) Recreation Department: Supervision 3,570 3,570 - Clerical 1,342 1,238 104 Labor operations 12,689 14,949 (2,260) Longevity 33 32 1 Employee benefits 1,280 1,452 (172) EXHIBIT B-3 19 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH AUTHORIZATIONS Year ended September 30, 1974 (Continued) Actual (over) Appropriations Expenditures under Recreation Department: (continued) Office supplies $ 400 $ 1,246 $ (846) Motor fuel 200 200 Insurance 161 221 (60) Minor apparatus 25 71 (46) Maintenance - machinery and implements 300 159 141 Communications 150 200 (50) Educational and recreational 850 1,172 (322) Travel 500 320 180 Association dues and subscriptions 25 24 1 Electric 1,300 1,628 (328) Hire of equipment 260 325 (65) Contributions and awards 500 552 (52) Special services 1,450 983 467 Furniture and fixtures 256 (256) Machinery 497 (497) 25,035 29,095 (4,060) Park Department: Supervision 3,570 3,570 - Clerical 1,342 1,238 104 Labor operations 37,460 43,438 (5,978) Longevity 420 231 189 Employee benefits 3,300 4,557 (1,257) Office supplies 175 197 (22) Wearing apparel 700 780 (80) Motor fuel supplies 1,400 1,815 (415) Minor apparatus 650 1,573 (923) Botanical supplies 3,000 2,997 3 Building maintenance 500 715 (215) Maintenance - motor vehicles 300 1,236 (936) Betterments 2,800 4,393 (1,593) EXHIBIT B-3 20 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH AUTHORIZATIONS Year ended September 30, 1974 (Continued) Actual (over) Appropriations Expenditures under Park Department: (continued) Maintenance - other vehicles $ 300 $ 995 $ (695) Maintenance - fixtures and other 2,800 7,551 (4,751) Communications 170 220 (50) Hire of equipment 180 480 (300) Advertising 20 73 (53) Water 2,300 3,711 (1,411) Insurance 1,200 1,055 145 Sanitation service 500 1,486 (986) Travel expense 500 465 35 Dues and subscriptions 50 33 17 Capital expenditures - machinery 7,600 15,571 (7,971) 71,237 98,380 (27,143) Midway Swimming pool: Supervision 1,190 1,404 (214) Labor operations 11,419 10,030 1,389 Longevity 36 32 4 Employee benefits 855 859 (4) Office supplies 120 141 (21) Awards 125 125 Janitorial supplies 50 28 22 Chemicals 900 976 (76) Equipment rental 180 180 Building maintenance 550 88 462 Equipment maintenance 480 185 295 Communications 150 150 Minor apparatus 40 146 (106) Electric 200 190 10 Water 130 130 Insurance 350 350 Capital expenditures - fixtures 1,103 374 729 17,878 14,913 2,965 EXHIBIT B-3 21 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH AUTHORIZATIONS Year ended September 30, 1974 (Continued) Actual (over) Appropriations Expenditures under Wilshire Swimming Pool: Supervision $ 1,190 $ 1,404 $ (214) Labor operations 11,419 10,902 517 Benefits 878 871 7 Office supplies 100 100 Chemicals 900 875 25 Minor apparatus 40 121 (81) Janitorial 50 41 9 Communications 150 150 Hire of equipment 180 223 (43) Insurance 350 350 Electricity 200 126 74 Water 130 130 Awards 125 125 Maintenance - buildings 300 381 (81) 16,012 15,324 688 South Euless Swimming Pool: Supervision 1,190 1,404 (214) Clerical 1,342 988 354 Labor operations 10,077 8,801 1,276 Longevity 33 32 1 Benefits 845 846 (1) Office supplies 100 107 (7) Minor apparatus 40 96 (56) Janitorial 50 14 36 Chemicals 900 916 (16) Maintenance - buildings 300 49 251 Communications 150 150 Hire of equipment 180 223 (43) Insurance 350 350 Electricity 200 139 61 Water 130 130 Awards 125 73 52 16,012 13,968 2,044 EXHIBIT B-3 22 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH AUTHORIZATIONS Year ended September 30, 1974 (Continued) Civic Center: Supervision, labor and extra help Employee benefits Minor apparatus Janitorial and mechanical Wearing apparel Building maintenance Houses - Sheppard Drive Heating and cooling systems Insurance Electric Water Gas Waste disposal Engineer Capital expenditures: Payment on houses Fixtures Less department allocations - Community Building Community Building: Supervision Clerical Labor operations Employee benefits Office supplies Insurance Educational and recreational Actual (over) Appropriations Expenditures under $ 15,585 1,870 800 1,500 560 3,500 700 800 100 12,500 1,200 2,000 250 1,504 1,000 43,869 15,464 28,405 3,570 1,342 18,507 2,190 250 625 800 EXHIBIT B-3 $ 16,615 1,848 755 1,945 574 14,648 392 47 634 13,191 1,061 1,995 660 996 1,562 112 57,035 15,464 41,571 4,212 1,265 19,443 2,089 268 2,105 1,081 $ (1,030) 22 45 (445) (14) (11,148) 308 753 (534) (691) 139 5 (410) (996) (58) 888 (13,166) (13,166) (642) 77 (936) 101 (18) (1,480) (281) 23 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH AUTHORIZATIONS Year ended September 30, 1974 (Continued) Actual (over) Appropriations Expenditures under Community Building: (continued) Travel expense $ 300 $ 26 Equipment rental 180 330 Communications 275 304 Dues and subscriptions 20 50 Civic Center expense allocation 15,464 15,464 Capital expenditures - furniture and fixtures 2,500 2,247 46,023 48,884 $ 274 (150) (29) (30) 253 (2,861) Simmons Drive Community Center: Office supplies - 108 (108) Minor apparatus 78 (78) Gas 7 (7) Communications 39 (39) Capital outlays: Furniture and fixtures 714 (714) - 946 (946) Total all departments $1,326,713 $1,525,887 $(199,174) EXHIBIT B-3 24 CITY OF EULESS, TEXAS DEBT SERVICE FUND BALANCE SHEET September 30, 1974 ASSETS Cash and short-term investments (Exhibit A-5) Taxes receivable LIABILITIES AND RESERVES Due to other funds Reserve for uncollected taxes Reserve for retirement of general long-term debt (Exhibit C-1) EXHIBIT C ANALYSIS OF CHANGES IN RESERVE FOR RETIREMENT OF GENERAL LONG-TERM DEBT Year ended September 30, 1974 $ 285,211 38,342 $ 323,553 $ 132,835 38,342 152,376 $ 323,553 Balance at beginning of year $ 170,540 Add excess of revenues over expenditures (Exhibit C-2) Less advances from other funds Balance at end of year EXHIBIT C-1 114,671 (132,835) $ 152,376 25 CITY OF EULESS, TEXAS DEBT SERVICE FUND STATEMENT OF REVENUES AND EXPENDITURES Year ended September 30, 1974 Revenues: General property taxes and penalty and interest collected Advances from other funds $292,393 132,835 $425,228 Expenditures: Interest on bonds $140,214 Matured bonds 155,000 Service charges 222 Issuance fees 15,121 310,557 Excess of revenues over expenditures $114,671 EXHIBIT C-2 26 CITY OF EULESS, TEXAS CAPITAL PROJECTS FUNDS BALANCE, SHEET September 30, 1974 ASSETS Cash and short-term investments (Exhibit A-5) Due from Debt Service Fund Assessments receivable RESERVES AND APPROPRIATIONS Due to General Fund Accounts payable Reserve for uncollected assessments Reserve for street and drainage escrow deposits Appropriations - Unencumbered Fund balance Total $1,017,100 132,835 18,587 $1,168,522 $ 58,731 220 18,587 14,879 1,076,105 Street Improvement and Drainage Fund Park and Recreation Fund Service Revenue Center Sharing Fund Fund $738,020 $45,710 $40,000 $193,370 102,283 30,552 18,587 $858,890 $76,262 $40,000 $193,370 $ - $58,731 18,587 14,879 825,424 220 17,311 40,000 193,370 $1,168,522 $858,890 $76,262 $40,000 $193,370 EXHIBIT D 27 CITY OF EULESS, TEXAS CAPITAL PROJECTS FUNDS STATEMENT OF CASH RECEIPTS AND DISBURSEMENTS Year ended September 30, 1974 Total Street Improvement Park and Service Revenue and Drainage Recreation Center Sharing Fund Fund Fund Fund Cash balance at beginning of year $ 249,388 $ 52,556 $ 10,370 $40,000 $146,462 Receipts: Interest income 6,915 m - e 6,915 Matching grants-in-aid 28,360 28,360 Paving assessments 36,526 36,526 Revenue sharing grant 131,202 131,202 Bonds proceeds 1,300,000 1,000,000 300,000 1,503,003 1,036,526 328,360 e 138,117 Disbursements: Capital outlay 578,846 248,779 238,858 - 91,209 Decrease in payable to General Fund 23,610 23,610 Advances to Debt Service Fund 132,835 102,283 30,552 735,291 351,062 293,020 e 91,209 Cash balance at end of year $1,017,100 $ 738,020 $ 45,710 $40,000 $193,370 EXHIBIT D-1 28 CITY OF EULESS, TEXAS CAPITAL PROJECTS FUNDS STATEMENT OF EXPENDITURES COMPARED WITH AUTHORIZATIONS September 30, 1974 Amount appropriated: From: Bonds sold Paving assessments Other participation Matching grants-in-aid Advances from other funds Revenue sharing grants Interest income Less expenditures: Of prior fiscal periods Of this period Unexpended balance Total $3,280,000 299,990 129,818 80,000 82,341 277,664 6,915 4,156,728 2,404,337 735,291 3,139,628 $1,017,100 Street Improvement and Drainage Fund Park and Service Revenue Recreation Center Sharing Fund Fund Fund $2,480,000 $760,000 $40,000 $ 299,990 129,748 70 80,000 82,341 277,664 6,915 2,909,738 922,411 40,000 284,579 1,820,656 351,062 2,171,718 $ 738,020 583,681 293,020 876,701 $ 45,710 91,209 91,209 $40,000 $193,370 EXHIBIT D-2 29 CITY OF EULESS, TEXAS WATER AND SEWER ENTERPRISE FUND BALANCE SHEET September 30, 1974 ASSETS Current assets: Cash and short-term investments (Exhibit A-5) Accounts receivable Less estimated uncollectible accounts Total current assets Restricted assets: Revenue bond debt service: Cash with paying agent Revenue bond reserve: Cash with paying agent Investments with paying agent, at cost Revenue bond contingency: Cash and short-term investments (Exhibit A-5) Property sale proceeds accounts: (Note 1) Principal investments with paying agent, at cost Capital projects account: Cash and short-term investments (Exhibit A-5) Customer deposits: Short-term investments (Exhibit A-5) Interest receivable on investments Total restricted assets Utility plant in service: (Note 1) Land Equipment Water and sewer system Less allowance for depreciation Total utility plant in service $ 114,157 371 8,032 253,912 32,970 216,061 7,085,698 7,334,729 1,265,697 $ 706,640 113,786 820,426 50,985 261,944 100,000 423,288 429,997 95,874 5,282 1,367,370 6,069,032. $8,256,828 LIABILITIES, RESERVES, CONTRIBUTIONS AND RETAINED EARNINGS Current liabilities: Payable from current assets: Revenue bonds payable within one year (Exhibit A-4 and Table VI) Contractual obligation due within one year (Note 2) (Table VII) Accounts payable Payable from restricted assets: Customer deposits Accrued revenue bond interest payable Total current liabilities $ 95,874 45,205 $ 110,000 5,000 75,593 141,079 331,672 Other liabilities payable after one year: Revenue bonds (Note.1) (Exhibit A-4 and Table VI) 4,585,000 Contractual obligations payable to Trinity River Authority (Note 2)(Table VII) 375,000 4,960,000 Total liabilities 5,291,672 Deferred revenues 252,073 Reserves: Reserve for revenue bond debt service, next maturing Reserve for revenue bond retirement Reserve for contingency Total reserves Contributions: From subdividers From Environmental Protection Agency From Trinity River Authority Total contributions Retained earnings (Exhibit E-1) See accompanying notes. EXHIBIT E 50,985 261,944 100,000 1,067,217 175,300 15,000 412,929 1,257,517 1,042,637 $8,256,828 30 CITY OF EULESS, TEXAS WATER AND SEWER ENTERPRISE FUND ANALYSIS OF CHANGES IN RETAINED EARNINGS Year ended September 30, 1974 Retained earnings at beginning of year $ 853,453 Add: Net income (Exhibit E-2) Decrease in reserve for revenue bond debt service - next maturing Retained earnings at end of year See accompanying notes. EXHIBIT E-1 181,333 7,851 $1,042,637 31 CITY OF EULESS, TEXAS WATER AND SEWER ENTERPRISE FUND STATEMENT OF REVENUES AND EXPENSES - ACTUAL AND BUDGETED Year ended September 30, 1974 Operating revenues: Water sales Sewer services Water and sewer tap fees Service fees and miscellaneous Operating expenses excluding depreciation (Exhibit E-3) Net operating revenues excluding depreciation Non -operating revenues: Investment income Income available for debt service Depreciation (straight-line basis, 15 years for equipment and 33 years for the system) Non -operating expenses: Interest on revenue bonds Interest on Trinity River Authority Agreements (Note 2) Assessments by General Fund Net income (loss) Budget $ 720,000 260,000 12,000 17,812 1,009,812 684,107 325,705 25,000 350,705 200,000 150,705 Actual $ 810,974 334,470 6,390 41,441 1,193,275 658,633 534,642 112,466 647,108 201,145 445,963 222,250 221,152 24,950 24,950 18,528 18,528 265,728 264,630 $ (115,023) $ 181,333 See accompanying notes. Actual (over) under $ (90,974) (74,470) 5,610 (23,629) (183,463) 25,474 (208,937) (87,466) (296,403) (1,145) (295,258) 1,098 1,098 $(296,356) EXHIBIT E-2 32 CITY OF EULESS, TEXAS NOTES TO WATER AND SEWER ENTERPRISE FUND FINANCIAL STATEMENTS September 30, 1974 1. Property sale proceeds accounts The City of Euless sold certain of the waterworks and sewer system properties situated within the City of Bedford to that city on December 16, 1968. The customer connections sold produced approximately 30% of the gross water and sewer billings of the system. The proceeds were equal to 32.33% of the $5,800,000 of revenue bonds issued by Euless for the original purchase of the combined system. The Property Sale Proceeds funds may be applied solely to the prepayment or prior redemption of the revenue bonds and investment income of the funds may be applied to current revenue bond interest in an amount not exceeding 32.33% of the require- ment on the amount of bonds then outstanding. As of September 30, 1974, $1,650,000 (28.45%) of the revenue bonds have been retired with proceeds from the above noted sale. 2 Contractual obligations The City is obligated to fund from its water and sewer revenues specific bonded indebtedness issued by the Trinity River Authority of Texas. Although the bonds are not a bonded debt liability of the City, the contract liability of $380,000 at September 30, 1974 does relate to specific TRA bonds and is re- flected in the accompanying balance sheet. The related debt service charges are reflected as nonoperating expenses. In addition, the City has entered into a new long-term contract with the Trinity River Authority of Texas for sewer treatment services and water supply. Under this contract, the City is obligated for the next 49 years to share in the costs of operations, maintenance and debt service of the Authority. Annual charges to the City by TRA in 1975 will approximate $570,000 of which $216,000 is earmarked for debt service. Such charges paid by the City totaled approximately $382,000 in 1974 of which $144,000 was earmarked for debt service. Under the contract all charges by TRA are deemed to be for services which constitute reasonable and necessary "operating expenses" of the City°s water and sewer system, therefore, no part of such charges are included in the accompanying balance sheet as a liability equivalent to bonded in- debtedness requiring debt service accounting treatment. 33 CITY OF EULESS, TEXAS WATER AND SEWER ENTERPRISE FUND SCHEDULE OF OPERATING EXPENSES - BUDGETED AND ACTUAL Year ended September 30, 1974 Actual (over) Budget Actual under General and administrative: Supervision $ 14,500 Clerical 20,472 Employee benefits 6,000 Longevity 558 Property and liability insurance 6,500 Office supplies 2,000 Postage 3,800 Legal fees 600 Audit fees 1,225 Engineering fees 600 Maintenance - machinery and tools 400 Communications 2,600 Advertising 50 Travel and miscellaneous 2,550 Bad debts 61,855 Water production: Supervision 7,890 Labor operations 14,617 Employee benefits 3,025 Overtime 1,200 Wearing apparel 530 Motor fuel 1,300 Minor apparatus 200 Maintenance: Machinery and tools 200 Motor vehicles 420 Signal system 450 Water - TRA 96,050 Electricity 55,000 Bank charges 100 Contingencies and other 34,000 EXHIBIT E-3 10,000 $ 4,500 20,677 (205) 5,969 31 287 271 2,437 4,063 2,132 (132) 5,000 (1,200) 600 1,475 (250) 5,533 (4,933) 366 34 2,913 (313) 4 46 22 2,528 6,087 (6,087) 62,902 (1,047) 3,750 4,140 17,262 (2,645) 2,532 493 482 718 481 49 1,656 (356) 300 (100) 250 (50) 479 (59) 493 (43) 228,103 (132,053) 61,590 (6,590) 14 86 237 33,763 214,982 317,629 (102,647) 34 SCHEDULE CITY OF EULESS, TEXAS WATER AND SEWER ENTERPRISE FUND OF OPERATING EXPENSES - BUDGETED AND ACTUAL Year ended September 30, 1974 (Continued) Water distribution: Supervision Labor operations Employee benefits Overtime Wearing apparel Motor fuel Minor apparatus Chemicals Maintenance: Instruments and apparatus Machinery Motor vehicles Water mains Water meters Signal system and other Fire hydrants Hire of equipment Janitorial supplies Travel and subscriptions Bank charges Buildings Contingencies and other Trinity River Authority Sewer collection and treatment: Supervision Labor operations Overtime Employee benefits Wearing apparel Motor fuel Minor apparatus Chemicals Actual (over) Budget Actual under $ 7,890 41,147 6,642 3,000 1,300 2,500 1,250 50 700 1,500 2,500 5,000 5,000 600 850 500 50 590 150 50 31,000 33,000 $ 4,425 43,126 5,572 5,212 1,350 2,500 1,411 47 341 547 1,998 6,745 5,551 545 1,114 279 12 447 655 32,477 145,269 114,354 11,130 20,170 2,000 4,275 820 1,500 500 100 4,425 29,021 2,273 3,769 955 1,657 893 961 $ 3,465 (1,979) 1,070 (2,212) (50) (161) 3 359 953 502 (1,745) (551) 55 (264) 500 50 311 138 (397) 30,345 523 30,915 6,705 (8,851) (273) 506 (135) (157) (393) (861) EXHIBIT E-3 35 CITY OF EULESS, TEXAS WATER AND SEWER ENTERPRISE FUND SCHEDULE OF OPERATING EXPENSES - BUDGETED AND ACTUAL Year ended September 30, 1974 (Continued) Sewer collection and treatment: (continued) Maintenance: Sanitary sewers Machinery Motor vehicles Signal systems Hire of equipment Treatment fees - TRA Electric Bank charges Travel Contingencies and other Total operating expenses EXHIBIT E-3 Budget $ 1,500 500 550 200 500 185,316 2,000 100 100 30,740 262,001 $684,107 Actual (over) Actual under $ 1,303 1,436 1,263 331 885 113,589 871 8 48 60 $ 197 (936) (713) (131) (385) 71,727 1,129 92 52 30,680 163,748 98,253 $658,633 $ 25,474 36 ASSETS CITY OF EULESS, TEXAS TRUST AND AGENCY FUNDS BALANCE SHEET September 30, 1974 Social Security Escrow Total Fund Fund Cash in bank (Exhibit A-5) $101,705 $50,655 $51,050 LIABILITIES, RESERVES AND FUND BALANCE Payroll taxes payable Reserve for general escrow deposits Fund balance $ 37,756 $37,756 $ 51,050 51,050 12,899 12,899 $101,705 $50,655 $51,050 EXHIBIT F 37 CITY OF EULESS, TEXAS TRUST AND AGENCY FUNDS STATEMENT OF CASH RECEIPTS AND DISBURSEMENTS Year ended September 30, 1974 Balance at beginning of year Receipts: For social security, federal income taxes withheld, employees insurance premiums and employee United Fund deductions Escrow deposits Disbursements: Payments for social security, federal income taxes withheld, insurance premiums and United Fund Escrow payments for street and drainage construction Balance at end of year Social Security Total Fund $ 62,238 $ 28,477 397,400 397,400 278,147 737,785 425,877 375,222 375,222 260,858 636,080 375,222 $1012705 $ 502655 Escrow Fund $ 33,761 278,147 311,908 260,858 260,858 $ 51,050 EXHIBIT F-1 38 CITY OF EULESS, TEXAS STATEMENT OF GENERAL FIXED ASSETS September 30, 1974 General fixed assets: Buildings Improvements other than buildings Machinery and equipment Investment in general fixed assets: From general bonds From current revenues and assessments EXHIBIT G $1,137,295 2,920,411 560,091 $4,617,797 $2,884,185 1,733,612 $4,617,797 39 CITY OF EULESS, TEXAS STATEMENT OF CHANGES IN GENERAL FIXED ASSETS BY SOURCE Year ended September 30, 1974 Balance at beginning of year. Add: Expenditures from bond proceeds Expenditures from assessments and other special funds Expenditures from current revenues Balance at end of year Total $3,934,675 422,972 156,094 104,056 Buildings $ 985,317 150,416 1,562 Improvements other than buildings $2,579,081 238,813 100,877 Machinery and equipment $ 370,277 33,743 55,217 1,640 100,854 $4,617,797 $1,137,295 $2,920,411 $ 560,091 EXHIBIT G-1 40 General Government Street Department Police Department Fire Department Park and Recreation Departments Library CITY OF EULESS, TEXAS SCHEDULE OF GENERAL FIXED ASSETS CLASSIFIED BY DEPARTMENTS Year ended September 30, 1974 Total $ 394,004 2,322,351 267,797 212,215 1,089,032 332,398 $41617,797 Buildings $ 253,346 154,525 92,241 387,339 249,844 $1,137,295 EXHIBIT G-2 Improvements other than buildings $ 2,259,239 630,148 31,024 $2,920,411 Machinery and equipment $ 140,658 63,112 113,272 119,974 71,545 51,530 $ 560,091 41 CITY OF EULESS, TEXAS STATEMENT OF GENERAL LONG-TERM DEBT September 30, 1974 Amount available and to be provided for the payment of general long-term debt: Serial bond principal: Amount available in Debt Service Fund (Exhibit C) To be provided in future years Total available and to be provided GENERAL LONG-TERM DEBT PAYABLE Serial bonds payable in future years (Table V) $3,625,000 EXHIBIT H $ 152,376 3,472,624 $3,625,000 SUPPLEMENTARY INFORMATION - STATISTICAL DATA 42 Tax roll dates 10- 1-64 10- 1-65 10- 1-66 10- 1-67 10- 1-68 10- 1-69 10- 1-70 10-- 1-71 10- 1-72 10- 1-73 Fiscal period ending 9-30-65 9-30-66 9-30-67 9-30-68 9-30-69 9-30-70 9-30-71 9-30-72 9-30-73 9-30-74 CITY OF EULESS, TEXAS TAX LEVIES AND TAX COLLECTIONS Last ten fiscal years Assessed value $ 25,693,730 30,285,610 41,603,636 45,009,290 48,914,070 67,556,170 77,420,170 86,000,000 93,312,960 142,833,960 Collections current years Total taxes during tax levy fiscal period $ 256,937 302,856 320,348 382,592 415,770 574,240 658,071 695,199 793,175 1,173,599 TABLE I $ 241,197 300,609 304,185 369,344 402,888 543,005 621,586 676,102 769,851 1,070,877 Percent of collection of current levy 93.87 99.25 94.95 96.53 96.90 94.56 94.45 97.25 97.06 91.25 Collection on delinquent rolls fiscal period $ 2,503 1,410 5,767 14,398 7,432 8,637 21,049 20,658 17,146 10,072 Total collections during fiscal period $ 243,700 302,019 309,952 383,742 410,320 551,642 642,635 696,760 786,997 1,080,949 Percent of total collection to tax levy 94.85 99.72 96.71 100.30 98.69 96.06 97.65 100.22 99.22 92.11 43 Tax roll dates City 10- 1-65 $1.00 10- 1-66 .77 10- 1-67 .85 10- 1-68 .85 10- 1-69 .85 10- 1-70 .85 10- 1-71 .85 10- 1-72 .85 10- 1-73 .85 10- 1-74 .85 Tax roll Fiscal dates period 10- 1-64 9-30-65 10- 1-65 9-30-66 10- 1-66 9-30-67 10- 1-67 9-30-68 10- 1-68 9-30-69 10- 1-69 9-30-70 10- 1-70 9-30-71 10- 1-71 9-30-72 10- 1-72 9-30-73 10- 1-73 9- 30- 74 CITY OF EULESS, TEXAS TAX RATES AND TAX LEVIES Prior fiscal years School $1.36 1.45 1.45 1.45 1 .69 1.69 1.69 1.69 1.69 1.69 City TAX RATES County $ .82 .82 .82 .82 .82 .88 .88 .88 .86 .86 TAX LEVIES (Estimated) $ 256,937 302,856 320,348 382,592 415,784 574,240 658,071 695,199 793,175 1,173,599 School $ 349,434 411,884 603,248 652,625 775,056 1,000,000 1,100,000 1,200,000 1,600,000 2,400,000 TABLE II State $ .42 .42 .42 .42 .42 .42 .37 .32 .22 .22 County and state $318,601 375,541 515,881 558,125 615,426 668,500 714,000 725,000 750,000 800,000 Total $3.60 3.46 3.54 3.54 3.78 3.84 3.79 3.74 3.62 3.62 Total $ 924,972 1,090,281 1,439,477 1,593,342 1,806,266 2,242,740 2,472,071 2,620,199 3,143,175 4,373,599 44 Fiscal period 9-30-65 9-30-66 9-30-67 9- 30- 68 9-30-69 9-30-70 9- 30- 71 9-30-72 9-30-73 9-30-74 Taxes (other than property taxes) $ 33,207 36,045 34,349 44,502 53,317 117,162 199,807 222,960 293,011 377,401 CITY OF EULESS, TEXAS REVENUES - OTHER THAN PROPERTY TAXES Last ten fiscal years Licenses and permits County fire Fines program Library $14,589 $ 21,208 9,448 23,344 13,170 27,833 30,642 20,187 40,464 31,966 35,984 27,035 42,069 50,343 46,025 58,027 57,002 76,101 109,720 123,847 $1,500 1,500 1,600 1,600 2,000 2,200 2,400 2,600 2,800 3,000 $2,555 2,518 6,805 5,206 7,915 7,444 6,607 8,915 3,943 7,080 Revenue sharing 146,462 131,202 Other $ 31,209 19,002 26,045 43,409 55,920 58,360 58,355 106,935 144,657 166,355 TABLE 11I 45 CITY OF EULESS, TEXAS EXPENDITURES FOR SELECTED FUNCTIONS Last ten fiscal years Fiscal period General ended government 9-30-65 9-30-66 9-30-67 9-30-68 9-30-69 9-30-70 9-30-71 9-30-72 9-30-73 9-30-74 $81,923 73,664 87,735 40,699* 29,826 53,849 60,934 59,678 70,870 85,957 Law enforcement $ 97,958 105,859 129,954 155,890 189,578 240,017 296,293 341,727 388,473 581,936 Fire Public department works $ 23,218 30,337 29,850 33,878 43,450 58,651 105,713 131,732 153,044 300,827 $ 42,659 67,436 54,691 83,077 89,367 99,427 107,488 119,785 173,717 235,435 Parks and recreation Library * Beginning in 1968 certain expenditures classified as nondepartmental and previously reported under "general government" have been allocated or charged directly to the several functions listed above. TABLE IV $ 19,610 44,378 61,081 79,141 113,482 119,906 135,421 138,783 253,117 263,081 $14,092 18,808 21,382 33,285 35,032 40,504 42,435 48,605 45,736 58,651 46 Fiscal CITY OF EULESS, TEXAS GENERAL OBLIGATION BONDS OTHER THAN WATER AND SEWER REVENUE DEBT SERVICE CHARGES Bonds Requirements outstanding Principal Interest Total 1975 $3,625,000 $ 70,000 $ 166,310 $ 236,310 1976 3,555,000 70,000 163,223 233,223 1977 3,485,000 75,000 160,135 235,135 1978 3,410,000 80,000 156,735 236,735 1979 3,330,000 80,000 153,229 233,229 1980 3,250,000 85,000 149,592 234,592 1981 3,165,000 90,000 145,763 235,763 1982 3,075,000 90,000 141,753 231,753 1983 2,985,000 100,000 137,402 237,402 1984 2,885,000 105,000 132,643 237,643 1985 2,780,000 115,000 127,645 242,645 1986 2,665,000 115,000 122,335 237,335 1987 2,550,000 125,000 116,718 241,718 1988 2,425,000 130,000 110,807 240,807 1989 2,295,000 120,000 105,038 225,038 1990 2,175,000 125,000 99,597 224,597 1991 2,050,000 135,000 93,681 228,681 1992 1,915,000 135,000 87,512 222,512 1993 1,780,000 140,000 81,336 221,336 1994 1,640,000 160,000 74,329 234,329 1995 1,480,000 160,000 66,698 226,698 1996 1,320,000 165,000 59,112 224,112 1997 1,155,000 170,000 51,285 221,285 1998 985,000 170,000 43,215 213,215 1999 815,000 170,000 35,085 205,085 2000 645,000 170,000 26,955 196,955 2001 475,000 75,000 21,525 96,525 2002 400,000 75,000 18,600 93,600 2003 325,000 80,000 15,113 95,113 2004 245,000 80,000 11,392 91,392 2005 165,000 80,000 7,672 87,672 2006 85,000 85,000 3,952 88,952 $3,6257000 TABLE V $2,886,387 $6,511,387 47 Fiscal CITY OF EULESS, TEXAS REVENUE WATER AND SEWER BONDS DEBT SERVICE CHARGES Bonds Requirements outstanding Principal Interest Total 1975 $4,695,000 $ 110,000 $ 217,475 $ 327,475 1976 4,585,000 115,000 212,475 327,475 1977 4,470,000 120,000 207,237 327,237 1978 4,350,000 125,000 201,775 326,775 1979 4,225,000 130,000 196,088 326,088 1980 4,095,000 140,000 190,175 330,175 1981 3,955,000 145,000 183,800 328,800 1982 3,810,000 155,000 177,138 332,138 1983 3,655,000 160,000 170,075 330,075 1984 3,495,000 165,000 162,700 327,700 1985 3,330,000 175,000 154,960 329,960 1986 3,155,000 180,000 146,725 326,725 1987 2,975,000 200,000 138,175 338,175 1988 2,775,000 205,000 128,525 333,525 1989 2,570,000 210,000 118,650 328,650 1990 2,360,000 220,000 108,450 328,450 1991 2,140,000 165,000 97,800 262,800 1992 1,975,000 135,000 88,875 223,875 1993 1,840,000 120,000 82,800 202,800 1994 1,720,000 35,000 77,400 112,400 1995 1,685,000 130,000 75,825 205,825 1996 1,555,000 135,000 69,975 204,975 1997 1,420,000 145,000 63,900 208,900 1998 1,275,000 150,000 57,375 207,375 1999 1,125,000 120,000 50,625 170,625 2000 1,005,000 160,000 45,225 205,225 2001 845,000 170,000 38,025 208,025 2002 675,000 240,000 30,375 270,375 2003 435,000 190,000 19,575 209,575 2004 245,000 120,000 11,025 131,025 2005 125,000 125,000 5,625 130,625 $4,695,000 $3,528,848 $8,223,848 TABLE VI 48 Fiscal CITY OF EULESS, TEXAS TRINITY RIVER AUTHORITY - 1969-C SERIES CONTRACT DEBT SERVICE CHARGES Bonds Requirements outstanding Principal Interest Total 1975 $380,000 $ 5,000 $ 24,638 $ 29,638 1976 375,000 5,000 24,325 29,325 1977 370,000 5,000 24,013 29,013 1978 365,000 5,000 23,700 28,700 1979 360,000 5,000 23,387 28,387 1980 355,000 10,000 23,075 33,075 1981 345,000 10,000 22,425 32,425 1982 335,000 10,000 21,775 31,775 1983 325,000 10,000 21,125 31,125 1984 315,000 10,000 20,475 30,475 1985 305,000 10,000 19,825 29,825 1986 295,000 10,000 19,175 29,175 1987 285,000 10,000 18,525 28,525 1988 275,000 15,000 17,875 32,875 1989 260,000 15,000 16,900 31,900 1990 245,000 15,000 15,925 30,925 1991 230,000 15,000 14,950 29,950 1992 215,000 20,000 13,975 33,975 1993 195,000 20,000 12,675 32,675 1994 175,000 20,000 11,375 31,375 1995 155,000 20,000 10,075 30,075 1996 135,000 25,000 8,775 33,775 1997 110,000 25,000 7,150 32,150 1998 85,000 25,000 5,525 30,525 1999 60,000 60,000 3,900 63,900 $380,000 $425,563 $805,563 TABLE VII 49 CITY OF EULESS, TEXAS INSURANCE IN FORCE September 30, 1974 Fire and extended coverage, 80% coinsurance: On contents of city offices, jail, and community center City offices, jail, and community center Library building Library books and furnishings Scheduled water and sewer property Fire station #1 Fire station #2, building and contents Vandalism and malicious mischief: Scheduled water and sewer property City offices, jail and community center Contents City offices, jail, and community center Comprehensive glass breakage: City offices, jail, library, and community center Vehicle liability - all vehicles: Bodily injury Amusement liability Vehicle - fire and theft, extended coverage and $100 deductible collision Public employees blanket bond: Specific employees All other employees Fire and extended coverage for houses on Sheppard Drive: House on 110 N. Sheppard Drive House on 114 N. Sheppard Drive House on 134 N. Sheppard Drive Expires Insurers Amount of insurance 12- 1-76 3 $ 40,000 12- 1-76 3 429,170 12- 1-76 3 180,000 12- 1-76 3 30,000 9- 3-76 3 466,400 12- 1-76 3 30,000 9- 3-76 3 72,000 9- 3-76 12- 1-76 12- 1-76 3 3 3 9-28-75 2 9-14-75 2 9- 3-75 2 9-14-75 2 2- 7-75 1 11-25-75 4-10-77 4-20-75 TABLE VIII 1 4 1 466,400 429,170 40,000 Scheduled 100/300,000 300,000 ACV 7,500 2,500 10,000 10,000 10,000 50 CITY OF EULESS, TEXAS INSURANCE IN FORCE September 30, 1974 (Continued) Insurers: 1. Trinity Universal Insurance Co. 2. United States Fire Insurance Co. 3. North River Insurance Co. 4. Security National Insurance Co. This statement is intended only as a descriptive summary; no expression of opinion as to the adequacy of the coverage is intended. TABLE VIII 51 CITY OF EULESS, TEXAS MISCELLANEOUS STATISTICAL FACTS Calculation of debt service coverage for Water and Sewer Revenue Bonds for contractual agreements with Trinity River Authority payable from water and sewer revenues: Water and Sewer Revenue Fund income available for debt service (Exhibit E-2) Average annual requirements: Water and Sewer Revenue Bonds Specific Trinity.River Authority Bonds Coverage See Exhibits E for Water and Sewer Enterprise Fund financial statements and notes. TABLE IX $ 647,108 $ 265,285 32,223 $ 297,508 2.18 times t _y~r44 -jam► ..t.L I�r i-' ,. i "'� i ► 1 1.,_) in . � ; "' • i I - �4 ,,� •�. (tom4wIr �i � �. •'►'1'.,-41 - :• •i' �?' 4. Ldrh 0 r � ' T», `.; Si . '.Ji',It ».' 11 T'i ray �'t i.i 11` . �._-, 11:_ Si -,.,_ . '1_77—..—.1 -7.—.1.1k. r, i.—.1—.1.„ irk, ,r,-1.76, r. t t 1 11 � . J i,I -N.' '• —111 . 7t G1 , ii ,■ R_ • 211 i� �ir.,! i •Imo 1.n I . � ,* i—rt I rb1 . ti -. J ibith.,....0, , I,- •-• le 1 r 4 ■'p. 1^_r f 4. t . 4`- ty ' 40S:•a♦�+ J—jt ! r� i » i ,1V t . 1 " til.fe: 4 tlll*1i r t•�/ 4. " n i • 1 17 I. ' 1 etrog - ��''■ 'a��' �i}"f• tr ate.` 17 ••If•1•,.; -» ■ 1 ‘, 1 .<. ...► ti_rr _ .t p` »,r: r, - as . • ••• , _• -S., - ` 'r fib : no lk- . r �e � ' "" ` = � �`' r. � i . n_fi .�'^ w...�r 1�' 1, » • " - . I • -^ •• R -Y . ...14, } '• .._ 1 ' , 4, • y f.4 _. _ - .E. t ± rTe r ^ . r r . r M a� C 7,F l Y �- ._ "4_ 1,,,— / ", (. r.'' . .. '.• t % • L ..•JI lib 411,1+ff _' t� r '% y■�-.""a VP 411° ". �, ► „%'f ,'f _-- 1 .,; >, rr * , r r �► f 1 , / , tit i Lr''k ••' % 1f �' I .1 1 ■lf a' (•a, f 1' 4 t- r a ; 1ft_ oat r., ,, . v 1' _ �' 4. • _ i grt i., it L. n ., II 'i.1 f »};'. / • " -i • `•r .r -1 �� -i- ■1 �'j,r� f 1`I r` ., i % _ , �•' �..= 4_ MI 4: • ►. `,41.: E,-.. l . 5 t :'t, • ' Y ^� `�' V• I 1. 1 $ Via. '' • "- -/ • .,- ; . r f .t,•• 4 ��►. ! • 1 2 it, „ rjj ',„• rf . i . .Y i 4II 6 '� - 40. aaa"' 1 j.. 4j 4 t ` ,.,,• t � r a f . l 1 4 /yam �, ... ' Z �T ��■El ` ll ter Y ,� i r1 � •` ti lf. it `.. Li -. . -• Al'u V• ki 1�• Y ,' � 1►a� Z iris ,t', 1r_+, 1 T S' • . K . r. ' 1 • - • ■ ■ 1 y Y `.• T aI. . rim �r f W1 t 1.11r Y•.y 14 1„i I -. • •„ '_I�1..•_moril'� li • f