The URL can be used to link to this page

Home My WebLink AboutFY 1975 Financial Statements and Supplementary Information - AuditCITY OF EULESS, TEXAS FINANCIAL STATEMENTS AND SUPPLEMENTARY INFORMATION YEAR ENDED SEPTEMBER 30, 1975 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 Exhibit B Exhibit B-1 Exhibit B-2 Exhibit B-3 Exhibit C Exhibit C-1 Exhibit C-2 Exhibit D Exhibit D-1 Exhibit D-2 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 Balance sheet Analysis of changes in fund balance Statement of revenues - estimated and actual Statement of expenditures compared with budget Debt Service Fund Balance sheet Analysis of changes in reserve for retirement of general long-term debt Statement of revenues and expenditures Capital Projects Funds Balance sheet Statement of cash receipts and disbursements Statement of expenditures compared with appropriations Page 1 2- 3 4 5 5 6 7 8 9 10-11 12-24 25 25 26 27 28 29 Exhibit E Exhibit E-1 Exhibit E-2 Exhibit E-3 Exhibit E-4 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 CONTENTS Financial statements (continued) Page Water and Sewer Enterprise Fund Balance sheet Analysis of changes in retained earnings Statement of revenues and expenses - actual and budgeted Statement of changes in financial position 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 Insurance in force Miscellaneous statistical facts 30 31 32 33 34-35 36-38 39 40 41 42 43 44 45 46 47 48 49 50 51-52 53 REPORT THE MUNICIPAL FINANCE OFFICERS ASSOCIATION OF THE UNITED STATES AND CANADA Qtertifiettjat THE ANNUAL FINANCIAL REPORT OF The City of Ca less, Te x cis Mr tau fiscal year Cnda Scptember30,1964 CONFORMS TO THE PRINCIPLES AND STANDARDS OF PUBLIC FINANCIAL REPORTING AS PROMULGATED BY THE fillunicipal ,finance 'w:ffice as azoociation AND THE Pational Committee on iliobernmental accounting Presented January 13, 1965. //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 THE ANNUAL FINANCIAL REPORT OF The City of Eul¢ss, Tsxas For the Fiscal Year Eroded September 30,1971 SUBSTANTIALLY CONFORMS TO THE PRINCIPLES AND STANDARDS OF PUBLIC FINANCIAL REPORTING AS PROMULGATED BY THE jiunicipat ,finance Q tticerci aO0ociation AND THE Aationai Committee on obernmentat accounting THIS SUPPLEMENTS A CERTIFICATE OF CONFORMANCE PRESENTED TO THE ABOVE NAMED GOVERNMENTAL UNIT Octmary 13,1,6g Presented ,A\Arc11 31, 1`j72. 4-41 Ereaulux Dt# 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. PHONE 283-5381 • 201 ECTOR DRIVE • EULESS, TEXAS 76039 ‘== nnAA VJ � r October 31, 1975 Honorable Harold Samuels, Mayor and City Council City of Euless Euless, Texas Gentlemen: The annual financial report of the City of Euless, Texas, for the fiscal year ended September 30, 1975, 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, depreciation of general fixed assets is not recognized in the City's accounting 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 financial 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, 1975, continues to conform substantially to such standards. ); EULESS MY CHOICE, .YOUR. OPPORTUNITY General Comments Information as to the City's tax assessments and collec- tions, 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 operating Retained earnings, reserves and contributions 1975 1974 $ 407,863 $1,779,390 $1,695,283 $ 343,214 $1,489,357 $1,525,887 Increase (decrease) $ 64,649 $290,033 $169,396 895,140 $ 706,640 $188,500 $2,908,929 $2,713,083 $195,846 Securities have been pledged by depository banks suffi- cient 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 requirements of such ordinances, a total of $100,000 has been restricted for emergencies. Other reserve and accounting require- ments of the ordinances have been met. 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, James R. Hickerson Finance Director ARTHUR YOUNG & COMPANY 2200 FORT WORTH NATL.BANK BLDG. FORT WORTH, TEXAS 76102 Honorable Harold Samuels, Mayor and City Council City of Euless Euless, Texas We have examined the accompanying financial statements of the various funds and account groups of the City of Euless, Texas, for the year ended September 30, 1975, listed in the foregoing table of contents. Our examination was made in accord- ance 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 circum- stances. In our opinion, the statements mentioned above present fairly the financial position of the various funds and account groups of the City of Euless, Texas, at September 30, 1975 and the results of operations of such funds and the changes in finan- cial position of the Water and Sewer Enterprise Fund for the year then ended, in conformity with generally accepted accounting principles applied on a basis consistent with that of the preceding year. It is our further opinion that the accounting requirements 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 presentation of the financial information referred to in the preceding para- graph. 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. October 31, 1975 2 CITY OF EULESS, TEXAS COMBINED BALANCE SHEET - ALL FUNDS September 30, 1975 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 (Exhibit A-5) Interest receivable on investments Land Buildings Improvements other than buildings Equipment Amount available for retirement of general long-term debt Amount to be provided for retirement of general long-term debt General Fund $407,863 138,957 13,273 58,731 Debt Service Fund $237,135 51,552 Capital Projects Funds $806,832 13,683 Water and Sewer Enterprise Fund $ 895,140 104,530 311,623 734,464 5,384 32,970 5,654,229 153,444 Trust and Agency Funds $76,266 1,509 General Fixed Assets 1,141,322 3,474,723 678,188 General Long-term Debt 237,135 3,317,865 Total assets and other debits $618,824 $2882687 $820,515 $7,891,784 $772775 $52294,233 $3,555,000 EXHIBIT A 3 CITY OF EULESS, TEXAS COMBINED BALANCE SHEET - ALL FUNDS September 30, 1975 (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 Reserve for unexpended grants Contributions from subdividers and others Investment in general fixed assets Fund balances Retained earnings Total liabilities, reserves and fund balances/ retained earnings EXHIBIT A Debt General Service Fund Fund $ 10,924 788 11,712 138,957 8,326 Capital Projects Funds $110,342 14,879 58,731 183,952 51,552 13,683 237,135 Water and Sewer Enterprise Fund $ 8,644 100,671 44,267 4,585,000 4,738,582 244,273 36,516 274,660 100,000 Trust and Agency Funds $40,291 28,881 69,172 1,356,398 1,141,355 $618,824 $288,687 $820,515 $7,891,784 $77,7 622,880 8,603 $ General Fixed Assets 5,294,233 General Long-term Debt 3,555,000 3,555,000 5, $5,294,233, $3,555,000 459,829 4 CITY OF EULESS, TEXAS COMBINED STATEMENT OF CASH RECEIPTS AND EXPENDITURES - ALL FUNDS Year ended September 30, 1975 General Fund Debt Service Fund Capital Projects Funds Water and Sewer Enterprise Fund Trust and Agency Funds Total - all funds Cash Cash balances balances 10-1-74 Receipts Expenditures 9-30-75 $ 191,961 $2,988,822 $2,921,930 $ 258,853 285,211 321,317 369,393 237,135 1,017,100 270,345 480,613 806,832 1,295,662 2,980,396 3,119,749 1,156,309 101,705 561,528 586,967 76,266 $2,891,639 $7,122408 $7,478,652 $2,535,395 EXHIBIT A-1 5 CITY OF EULESS, TEXAS COMBINED SCHEDULE OF CHANGES IN TAXES RECEIVABLE Year ended September 30, 1975 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 $ 141,692 $ 1,237,576 100,807 Current taxes Delinquent taxes - $141,692 1,237,576 1,480,075 1,237,576 1,187,910 100,807 849 1,136,105 100,807 664 1,289,566 1,237,576 $ 190,509 $ EXHIBIT A-2 100,807 242,499 51,805 185 51,990 - $190,509 COMBINED SCHEDULE OF TAXES RECEIVABLE BY FUNDS September 30, 1975 Delinquent taxes receivable: General Fund Debt Service Fund $138,957 51,552 $190,509 EXHIBIT A-3 6 CITY OF EULESS, TEXAS COMBINED SCHEDULE OF BONDS PAYABLE September 30, 1975 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 Public buildings Bonds Parks Water and sewer $1,490,000 $3,490,000 $10,800,000 470,000 160,000 120,000 40,000 790,000 100,000 75,000 75,000 100,000 110,000 300,000 760,000 Total $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 - 6,600,000 2,480,000 790,000 760,000 6,600,000 $1,915,000 $ 700,000 $2,730,000 $ 4,200,000 Issued subsequent to September 30, 1975: General Obligation Bonds - Series 1975 (matures serially 1976-1999) (soldl0-21-75) 6.3461% 11- 1-75 $ 400,000 $ 700,000 $ 300,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. Under the contract, annual charges by TRA for water and sewer services will aggregate approximately $525,000. Such charges paid by the City in the year ended September 30, 1975 totaled approximately $477,000. Of these amounts, $275,000 in future years and $233,000 in 1975 are earmarked as applicable to City pledged debt service of TRA. EXHIBIT A-4 3,600,000 2,200,000 800,000 Balance outstanding 9-30-75 $ 760,000 530,000 400,000 275,000 400,000 1,190,000 3,555,000 2,605,000 1,300,000 680,000 6,600,000 4,585,000 10,630,000 $8,140,000 $ 9,545,000 $ 1,400,000 CITY OF EULESS, TEXAS COMBINED SCHEDULE OF CASH AND INVESTMENTS September 30, 1975 Combined bank balances and investments: Securities Amount guaranty Bank accounts: First National Bank of Euless: Consolidated account $ 342,457 $ Trust and Agency account 47,385 Certificates of deposit 2,100, 000 Payroll 300 2,490,142 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 Water and Sewer Fund - property sales proceeds account Investments in U. S. Government securities (held in safekeeping by National Bank of Commerce, Dallas, Texas): Water and Sewer Fund - operating account 95,417 General Fund 149,010 $3,469,323 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. 8,447 36,516 44,963 2,535,105 290 2,535,395 Deposit insurance guaranty $ 40,000 40,000 40,000 300 3,275,000 120,300 $3,275,000 8,447 36,516 44,963 $165,263 266,213 423,288 EXHIBIT A-5 Cash and investments by fund: Funds: General Fund: Operations Payroll General Debt Service Fund U. S. Treasury obligations $149,010 149,010 Water and Sewer Enterprise Fund: Operating 95,417 Restricted: Revenue bond debt service Revenue bond reserve 266,213 Revenue bond contingency Property sale proceeds account 423,288 Capital projects account Customer deposits 784,918 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 $933,928 Cash and certificates of deposit $ 258,553 300 258,853 237,135 799,723 36,516 8,447 100,000 110,952 100,671 1,156,309 28,881 47,385 76,266 9,405 453,321 40,000 304,106 806,832 $2,535,395 $ 435,105 2,100,000 290 $2,535,395 Total $ 407,563 300 407,863 237,135 895,140 36,516 274,660 100,000 423,288 110,952 100,671 1,941,227 28,881 47,385 76,266 9,405 453,321 40,000 304,106 806,832 $3,469,323 8 CITY OF EULESS, TEXAS GENERAL FUND BALANCE SHEET September 30, 1975 ASSETS Cash and short-term investments (Exhibit A-5) Taxes receivable (Exhibit A-3) Accounts receivable, State of Texas Due from Park and Recreation Department Miscellaneous receivables RESERVES AND FUND BALANCE Escrow deposits Accounts payable Reserve for uncollected taxes Court costs collected for State of Texas Reserve for unexpended grants Fund balance (Exhibit B-1) $407,863 138,957 6,946 58,731 6,327 $618,824 $ 788 7,932 138,957 2,992 8,326 459,829 $618,824 EXHIBIT B 9 CITY OF EULESS, TEXAS GENERAL FUND ANALYSIS OF CHANGES IN FUND BALANCE Year ended September 30, 1975 Fund balance, October 1, 1974 $375,722 Add: Excess of revenues over expenditures: Revenues (Exhibit B-2) Expenditures (Exhibit B-3) $1,779,390 1,695,283 84,107 Fund balance, September 30, 1975 $459,829 EXHIBIT B-1 10 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF REVENUES - ESTIMATED AND ACTUAL Year ended September 30, 1975 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 $ 821,494 $ 10,000 3,000 Actual over (under) estimated 814,789 $ (6,705) 51,317 41,317 15,656 12,656 834,494 881,762 47,268 24,000 94,000 23,000 6,200 6,500 153,700 218,000 10,000 1,600 2,000 1,000 1,400 1,065 2,000 19,065 25,393 115,346 25,238 6,366 10,944 183,287 266,098 5,173 980 859 195 424 1,212 3,725 12,568 1,393 21,346 2,238 166 4,444 29,587 48,098 (4,827) (620) (1,141) (805) (976) 147 1,725 (6,497) EXHIBIT B-2 11 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF REVENUES v ESTIMATED AND ACTUAL Year ended September 30, 1975 (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 Appropriations from water system funds State Library Grant Traffic Safety Administration Texas Court cost service fee Swimming pools General Fund revenues Estimated Actual revenues revenues Actual over (under) estimated $ 121,000 $ 177,159 $ 56,159 900 759 (141) 121,900 1,600 5,207 3,000 40,000 1,320 11,900 18,528 2,460 18,600 375 22,000 124,990 $1,472,149 177,918 2,013 5,467 3,000 90,672 480 12,148 106,217 16,952 607 20,201 257,757 $1,779,390 56,018 413 260 50,672 (840) 248 87,689 (2,460) (1,648) 232 (1,799) 132,767 $307,241 EXHIBIT B-2 12 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH BUDGET Year ended September 30, 1975 General Government: Supervision Clerical Labor operations Extra help Longevity Employee benefits Office supplies Motor fuel Maintenance - equipment Communications Hire of equipment Insurance Special services Engineer fees Audit fees Tax office fees Advertising Travel expense and meetings Dues and subscriptions Elections expense Signal systems Bicentennial Committee Capital expenditures: Furniture Machinery Less departmental allocations: Law Enforcement Library Budget Expenditures $ 24,716 18,632 5,400 2,160 950 9,135 2,800 300 1,500 3,100 4,000 900 3,500 10,000 1,475 18,000 500 10,000 3,100 600 50 325 1,100 122,243 5,360 10,104 15,464 106,779 $ 34,741 13,094 6,605 2,207 243 8, 563 4,737 634 1,626 5,753 6,454 608 5,359 5,168 3,575 20,749 273 10,865 3,604 1,406 40 1,000 515 985 138,804 5,360 10,104 15,464 123,340 Actual (over) under $(10,025) 5,538 (1,205) (47) 707 572 (1,937) (334) (126) (2,653) (2,454) 292 (1,859) 4,832 (2,100) (2,749) 227 (865) (504) (806) 10 (1,000) (190) 115 (16, 561) EXHIBIT B-3 13 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH BUDGET Year ended September 30, 1975 (Continued) Civil Service: Clerical Office supplies Minor apparatus Maintenance - building Communications Hire of equipment Capital expenditures: Buildings Furniture and fixtures Machinery Sunshine House: Labor operations Employee benefits Office supplies Food supplies Minor apparatus Maintenance - building Communications Hire of equipment Travel expense Electric, water, and gas Capital expenditures: Furniture and fixtures Actual (over) Budget Expenditures under $ - $ 400 $ (400) 60 (60) 34 (34) 238 (238) 112 (112) 715 (715) 698 (698) 641 (641) 200 (200) - 3,098 (3,098) 8,100 7,748 352 466 303 163 178 (178) 142 (142) 86 (86) 380 (380) 359 (359) 161 (161) 657 (657) 104 (104) 1,216 (1,216) 8,566 11,334 (2,768) EXHIBIT B-3 14 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH BUDGET Year ended September 30, 1975 (Continued) Actual (over) Budget Expenditures under Law Enforcement: Police Department: Supervision $ 17,138 Clerical 46,050 Labor operations 303,924 Employee benefits 54,702 Longevity 6,656 Overtime 9,500 Office supplies 3,000 Wearing apparel 5,800 Motor fuel supplies 6,800 Education supplies 300 Maintenance - furniture and fixtures 125 Maintenance - traffic signals 7,000 Maintenance - motor vehicles 9,725 Maintenance - signal system 1,500 Communications 4,000 Special services 1,700 Travel expense and meetings 3,000 Electricity 2,700 Association dues and subscriptions 1,200 Support of persons 1,600 Insurance - vehicles 3,500 Advertising 150 Minor apparatus 5,000 Awards 200 Hire of equipment 3,000 Drug Abuse Education Program Capital expenditures: Motor vehicles 17,000 Furniture and fixtures 600 Signal systems and other 13,450 529,320 $ 12,435 47,829 299,124 51,752 1,529 22,026 3,353 7,598 10,863 361 211 10,423 11,625 2,146 6,649 1,398 2,880 3,744 1,298 2,605 3,813 61 5,748 139 3,750 3,346 17,212 521 12,074 546,513 $ 4,703 (1,779) 4,800 2,950 5,127 (12,526) (353) (1,798) (4,063) (61) (86) (3,423) (1,900) (646) (2,649) 302 120 (1,044) (98) (1,005) (313) 89 (748) 61 (750) (3,346) (212) 79 1,376 (17,193) EXHIBIT B-3 15 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH BUDGET Year ended September 30, 1975 (Continued) Law Enforcement: (continued) Legal and Corporation Court: Judge's salary Clerical Office supplies City attorney's fees Other Salary -related expenses Capital expenditures: Furniture and fixtures Administrative expense allocation Total Law Enforcement Fire Department: Supervision 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 Insurance Budget Expenditures $ 7,000 15,256 2,000 18,000 1,335 3,341 100 47,032 $ 16,184 13,041 1,651 15,037 1,212 1,985 Actual (over) under $ (9,184) 2,215 349 2,963 123 1,356 100 49,110 (2,078) 5,360 5,360 581,712 600,983 (19,271) 17,134 15,301 1,833 239,745 240,358 (613) 35,199 34,839 360 2,604 527 2,077 600 760 (160) 3,000 3,593 (593) 4,500 4,777 (277) 7,500 6,643 857 4,400 5,717 (1,317) 500 436 64 5,000 4,455 545 800 222 578 300 662 (362) 3,000 1,558 1,442 2,200 1,231 969 1,800 2,049 (249) EXHIBIT B-3 16 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH BUDGET Year ended September 30, 1975 (Continued) Actual (over) Budget Expenditures under Fire Department: (continued) Communications $ 1,500 $ 1,903 $ (403) Travel expense and meetings 2,400 489 1,911 Rents 300 300 Hire of equipment 200 505 (305) Awards 200 196 4 Association dues and subscriptions 600 196 404 Electric 1,300 2,450 (1,150) Water 400 477 (77) Gas 1,100 1,050 50 Advertising 260 (260) Special services and other 3,120 1,038 2,082 Capital expenditures: Furniture and fixtures 1,000 1,301 (301) Instruments and apparatus 1,000 884 116 Signal systems 2,000 2,000 Motor vehicles 6,800 8,737 (1,937) 350,202 342,914 7,288 Street Department: Supervision 4,425 3,933 492 Labor operations 51,216 53,280 (2,064) Clerical 5,124 5,251 (127) Extra help, overtime and longevity 16,973 1,137 15,836 Employee benefits 14,932 12,643 2,289 Wearing apparel 2,000 1,632 368 Motor fuel supplies 3,600 4,186 (586) Office supplies 500 563 (63) Chemical supplies 3,000 3,331 (331) Mechanical, janitorial and laundry supplies 175 8 167 Street lights - electricity and repairs 7,378 11,402 (4,024) Maintenance - streets 61,500 48,337 13,163 EXHIBIT B-3 17 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH BUDGET Year ended September 30, 1975 (Continued) Actual (over) Budget Expenditures under Street Department: (continued) Maintenance - machinery and other $ 3,916 $ 2,960 $ 956 Maintenance - motor vehicles 2,500 1,078 1,422 Insurance - motor vehicles 1,500 2,658 (1,158) Communications 500 530 (30) Hire of equipment 8,750 834 7,916 Minor apparatus 2,000 2,218 (218) Travel expense 575 5 570 Capital expenditures: Motor vehicles and machinery 9,130 3,460 5,670 199,694 159,446 40,248 Traffic Safety Administration: Supervision 16,032 14,623 1,409 Clerical 7,115 6,141 974 Longevity 224 39 185 Benefits 2,316 2,283 33 Office supplies 1,940 940 1,000 Communication 134 198 (64) Hire of equipment 120 182 (62) Travel 976 656 320 Miscellaneous 55 (55) 28,857 25,117 3,740 Animal Control: Labor operations 16,104 9,719 6,385 Longevity 198 120 78 Overtime 500 1,925 (1,425) Employee benefits 2,491 1,898 593 Office supplies 150 95 55 Motor fuel supplies 350 465 (115) Maintenance - motor vehicles 600 684 (84) Maintenance - signal systems 200 144 56 EXHIBIT B-3 18 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH BUDGET Year ended September 30, 1975 (Continued) Actual (over) Budget Expenditures under Animal Control: (continued) Wearing apparel $ 600 $ 159 $ 441 Insurance 300 27 273 Animal care 400 175 225 Other 775 853 (78) 22,668 16,264 6,404 Building and Zoning Department: Supervision 12,480 3,973 8,507 Clerical 7,212 3,742 3,470 Labor operations 8,508 8,482 26 Extra help 800 800 Longevity 822 208 614 Employee benefits 3,970 2,348 1,622 Office supplies 600 968 (368) Motor fuel supplies 600 856 (256) Insurance 200 396 (196) Maintenance - motor vehicles 375 970 (595) Maintenance - signal systems 100 218 (118) Communications 350 440 (90) Advertising 150 152 (2) Hire of equipment 300 300 Travel expense and meetings 700 658 42 Wearing apparel 200 117 83 Association dues and subscriptions 60 75 (15) Capital expenditures: Motor vehicles 3,400 3,596 (196) 40,827 27,499 13,328 School Crossing Guard: Labor 6,000 6,151 (151) Benefits 1,583 1,308 275 7,583 7,459 124 EXHIBIT B-3 19 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH BUDGET Year ended September 30, 1975 (Continued) Library: Supervision Clerical Extra help Longevity Benefits Office supplies Insurance Maintenance Rebinding books Communications Travel expense and meetings Association dues and subscriptions Other Capital expenditures: Books Furniture and fixtures Administrative expense allocation Recreation Department: Supervision Clerical Labor operations Longevity Employee benefits Office supplies Motor fuel Insurance Minor apparatus Maintenance - machinery and implements Actual (over) Budget Expenditures under $ 7,128 20,280 7,968 1,113 4,700 3,000 450 170 3,500 402 710 $ 8,322 20,813 7,887 250 4,530 3,725 357 224 1,380 402 179 110 173 2,690 1,979 12,500 16,074 5,609 607 70,330 66,902 10,104 10,104 80,434 77,006 4,212 4,212 854 854 21,312 17,806 88 61 3,356 3,261 450 1,523 400 500 200 308 50 105 500 701 $ (1,194) (533) 81 863 170 (725) 93 (54) 2,120 531 (63) 711 (3,574) 5,002 3,428 3,428 3,506 27 95 (1,073) (100) (108) (55) (201) EXHIBIT B-3 20 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH BUDGET Year ended September 30, 1975 (Continued) Actual (over) Budget Expenditures under Recreation Department: (continued) Communications $ 175 $ 524 $ (349) Educational and recreational 1,000 1,674 (674) Travel 600 650 (50) Association dues and subscriptions 50 49 1 Electric 2,400 4,325 (1,925) Hire of equipment 260 447 (187) Contributions and awards 550 382 168 Special services 1,450 587 863 37,907 37,969 (62) Park Department: Supervision 4,212 4,212 - Clerical 854 934 (80) Labor operations 44,388 49,024 (4,636) Longevity 450 60 390 Employee benefits 7,025 7,022 3 Office supplies 200 206 (6) Wearing apparel 900 1,115 (215) Motor fuel supplies 2,000 2,790 (790) Minor apparatus 700 1,223 (523) Botanical supplies 4,600 3,923 677 Building maintenance 500 973 (473) Maintenance - motor vehicles 800 1,065 (265) Betterments 900 1,647 (747) Maintenance - other vehicles 800 736 64 Maintenance - fixtures and other 4,700 7,310 (2,610) Communications 200 499 (299) Hire of equipment 200 549 (349) Gas 152 (152) Water 2,300 6,367 (4,067) Insurance 1,500 2,070 (570) Sanitation service 500 1,345 (845) Travel expense 600 139 461 EXHIBIT B-3 21 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH BUDGET Year ended September 30, 1975 (Continued) Park Department: (continued) Dues and subscriptions Capital expenditures: Furniture and fixtures Machinery and other vehicles Betterments Midway Swimming Pool: Supervision Labor operations Longevity Employee benefits Office supplies Awards Janitorial supplies Chemicals Equipment rental Building maintenance Equipment maintenance Communications Minor apparatus Electric Water Insurance Capital expenditures: Fixtures Actual (over) Budget Expenditures under $ 75 $ 3,000 4,200 85,604 1,404 12,665 40 1,237 250 150 75 1,100 200 550 800 150 100 250 130 400 5,000 24,501 93 $ (18) 561 (561) 7,761 (4,761) 1,511 2,689 103,287 (17,683) 2,953 (1,549) 10,069 2,596 40 1,114 123 252 (2) 107 43 103 (28) 1,429 (329) 350 (150) 796 (246) 290 510 268 (118) 168 (68) 375 (125) 130 634 (234) 3,950 1,050 22,988 1,513 EXHIBIT B-3 22 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH BUDGET Year ended September 30, 1975 (Continued) Actual (over) Budget Expenditures under Wilshire Swimming Pool: Supervision $ 1,404 $ 2,052 $ (648) Labor operations 12,705 10,234 2,471 Benefits 1,237 1,006 231 Office supplies 150 170 (20) Chemicals 1,100 1,050 50 Minor apparatus 100 161 (61) Janitorial 75 64 11 Communications 150 267 (117) Hire of equipment 200 200 Insurance 400 633 (233) Electricity 250 375 (125) Water 130 130 Awards 150 107 43 18,051 16,449 1,602 South Euless Swimming Pool: Supervision 1,404 - 1,404 Clerical 854 513 341 Labor operations 11,927 8,884 3,043 Longevity 40 40 Benefits 1,291 995 296 Office supplies 150 150 Minor apparatus 100 149 (49) Janitorial 75 50 25 Chemicals 1,100 1,288 (188) Communications 175 192 (17) Hire of equipment 200 118 82 Insurance 400 633 (233) Electricity 250 375 (125) Water 130 130 Awards 150 123 27 18,246 13,600 4,646 EXHIBIT B-3 23 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH BUDGET Year ended September 30, 1975 (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 Equipment maintenance Travel expense Actual (over) Budget Expenditures under $ 18,562 2,836 900 1,400 560 4,000 340 1,400 611 13,010 968 3,378 800 934 1,504 800 52,003 15,464 36,539 4,212 854 22,009 2,541 300 700 1,100 500 400 $ 20,450 2,819 1,276 2,778 485 5,777 1,762 1,474 282 20,362 998 3,014 594 341 1,327 127 63,866 15,464 48,402 2,735 513 20,173 2,460 307 738 1,029 981 396 $ (1,888) 17 (376) (1,378) 75 (1,777) (1,422) (74) 329 (7,352) (30) 364 206 593 177 673 1,477 341 1,836 81 (7) (38) 71 (481) 4 EXHIBIT B-3 24 CITY OF EULESS, TEXAS GENERAL FUND STATEMENT OF EXPENDITURES COMPARED WITH BUDGET Year ended September 30, 1975 (Continued) Community Building: (continued) Equipment rental Communications Dues and subscriptions Civic Center expense allocation Capital expenditures: Furniture and fixtures Simmons Drive Community Center: Labor operations Benefits Office supplies Educational and recreational Communications Building maintenance and other Insurance Electric, water and gas Dues and subscriptions Capital expenditures: Furniture and fixtures Total all departments Actual (over) Budget Expenditures under $ 200 300 50 15,464 48,630 4,836 290 200 400 600 $ 168 315 50 15,464 304 45,633 5,442 200 211 772 666 865 1,541 1,307 50 32 (15) (304) 2,997 (606) 90 (11) (372) (66) (865) (1,541) (1,307) 1,441 359 12,495 (4,319) $1,704,976 $1,695,283 $ 9,693 50 1,800 8,176 EXHIBIT B-3 25 CITY OF EULESS, TEXAS DEBT SERVICE FUND BALANCE SHEET September 30, 1975 ASSETS Cash and short-term investments (Exhibit A-5) Taxes receivable (Exhibit A-3) $237,135 51, 552 $288,687 LIABILITIES AND RESERVES Reserve for uncollected taxes $ 51,552 Reserve for retirement of general long-term debt (Exhibit C-1) 237,135 $288,687 EXHIBIT C ANALYSIS OF CHANGES IN RESERVE FOR RETIREMENT OF GENERAL LONG-TERM DEBT Year ended September 30, 1975 Balance at beginning of year $152,376 Add excess of revenues over expenditures (Exhibit C-2) 84,759 Balance at end of year $237,135 EXHIBIT C-1 26 CITY OF EULESS, TEXAS DEBT SERVICE FUND STATEMENT OF REVENUES AND EXPENDITURES Year ended September 30, 1975 Revenues: General property taxes and penalty and interest collected Expenditures: Interest on bonds Matured bonds Service charges $321,317 $166,310 70,000 248 236,558 Excess of revenues over expenditures $ 84,759 EXHIBIT C-2 27 CITY OF EULESS, TEXAS CAPITAL PROJECTS FUNDS BALANCE SHEET September 30, 1975 ASSETS Cash and short-term investments (Exhibit A-5) (Exhibit D-1) 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 $806,832 13,683 $820, 515 $ 58,731 110,342 13,683 14,879 622,880 Street Improvement and Drainage Fund $453,321 13,683 $467,004 Park and Recreation Fund Service Revenue Center Sharing Fund Fund $ 9,405 $40,000 $304,106 $ 9,405 $40,000 $304,106 $ V $ 58,731 $ 110,342 13,683 14,879 328,100 $820,515 $467,004 NOTE: Regulations require that funds received under the Revenue Sharing Program must be used, obligated or appropriated within 24 months of the closing date of the entitlement period. EXHIBIT D (49,326) 40,000 304,106 $ 9,405 $40,000 $304,106 28 CITY OF EULESS, TEXAS CAPITAL PROJECTS FUNDS STATEMENT OF CASH RECEIPTS AND DISBURSEMENTS Year ended September 30, 1975 Cash balance at beginning of year Receipts: Interest income Paving assessments Revenue sharing grant Repayment of advance from Debt Service Fund Disbursements: Capital outlay Cash balance at end of year EXHIBIT D-1 Total Street Improvement and Drainage Fund Park and Recreation Fund Service Revenue Center Sharing Fund Fund $1,017,100 $738,020 $ 45,710 $40,000 $193,370 3,600 3,070 130,840 132,835 1,287,445 3,070 3,600 130,840 102,283 30,552 843,373 76,262 40,000 327,810 480,613 390,052 66,857 - 23,704 $ 806,832 $453,321 $ 9,405 $40,000 $304x106 29 CITY OF EULESS, TEXAS CAPITAL PROJECTS FUNDS STATEMENT OF EXPENDITURES COMPARED WITH APPROPRIATIONS September 30, 1975 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 EXHIBIT D-2 Total $3,280,000 303,060 129,818 80,000 82,341 408,504 10,515 4,294,238 3,006,793 480,613 3,487,406 $ 806,832 Street Improvement and Drainage Fund Park and Recreation Fund Service Revenue Center Sharing Fund Fund $2,480,000 $760,000 $40,000 $ 303,060 129,748 70 80,000 82,341 408,504 10,515 2,912,808 922,411 40,000 419,019 2,069,435 390,052 846,149 66,857 91,209 23,704 2,459,487 913,006 - 114,913 $ 453,321 $ 9,405 $40,000 $304,106 30 CITY OF EULESS, TEXAS WATER AND SEWER ENTERPRISE FUND BALANCE SHEET September 30, 1975 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: (Note 3) Cash with paying agent (Exhibit A-5) Revenue bond reserve: (Note 3) (Exhibit A-5) Cash with paying agent Investments with paying agent, at cost Revenue bond contingency: (Note 3) Cash and short-term investments (Exhibit A-5) Property sale proceeds accounts: (Note 1) Principal investments with paying agent, at cost (Exhibit A-5) 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 $ 104,901 371 8,447 266,213 32,970 232,685 7,068,861 7,334,516 1,493,873 $ 895,140 104,530 999,670 36, 516 274,660 100,000 423,288 110,952 100,671 5,384 1,051,471 5,840,643 $7,891,784. LIABILITIES, RESERVES, CONTRIBUTIONS AND RETAINED EARNINGS Current liabilities: Payable from current assets: Revenue bonds payable within one year (Exhibit A-4 and Table VI) Accounts payable Payable from restricted assets: Customer deposits Accrued revenue bond interest payable Total current liabilities $ 100,671 44,267 Other liabilities payable after one year: (Note 3) Revenue bonds (Note 1) (Exhibit A-4 and Table VI) Total liabilities Deferred revenues Commitments: (Note 2) Reserves: (Note 3) 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 36,516 274,660 100,000 1,131,473 209,925 15,000 $ 115,000 8,644 144,938 268,582 4,470,000 4,738,582 244,273 411,176 1,356,398 1,141,355 $7,891,784 31 CITY OF EULESS, TEXAS WATER AND SEWER ENTERPRISE FUND ANALYSIS OF CHANGES IN RETAINED EARNINGS Year ended September 30, 1975 Retained earnings at beginning of year Add: Net income (Exhibit E-2) Decrease in reserves for revenue bond debt service Retained earnings at end of year See accompanying notes. $1,042,637 96,965 1,753 $1,141,355 EXHIBIT E-1 32 CITY OF EULESS, TEXAS WATER AND SEWER ENTERPRISE FUND STATEMENT OF REVENUES AND EXPENSES - ACTUAL AND BUDGETED Year ended September 30, 1975 Operating revenues: Water sales Sewer services Water and sewer tap fees Service fees and miscellaneous Operating expenses excluding depreciation (Exhibit E-4) 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 Appropriations to General Fund Net income (loss) Budget $ 900,000 400,000 5,800 25,100 1,330,900 944,165 386,735 20,000 406,735 273,825 132,910 Actual $ 866,061 466,323 4,705 39,561 1,376,650 217,475 18, 528 236,003 $ (103,093) $ See accompanying notes. 833,507 543,143 104,772 647,915 228,176 419,739 216, 557 106,217 322,774 96,965 Actual (over) under $ 33,939 (66,323) 1,095 (14,461) (45, 750) 110,658 (156,408) (84,772) (241,180) 45,649 (286,829) 918 (87,689) (86,771) $(200,058) EXHIBIT E-2 CITY OF EULESS, TEXAS WATER AND SEWER ENTERPRISE FUND STATEMENT OF CHANGES IN FINANCIAL POSITION Year ended September 30, 1975 Funds provided: Operations: Net income for the year Expenses not requiring outlay of funds: Depreciation Total funds provided from operations Contributions in aid to construction Decrease in restricted funds Total funds provided Funds used: Additions to utility plant in service Payment of long-term debt Decrease in deferred revenue Total funds used Increase in working capital Changes in components of working capital: Increase (decrease) in current assets: Cash and short-term investments Accounts receivable Increase (decrease) in current liabilities: Revenue bonds payable within one year Accounts payable Customer deposits Accrued revenue bond interest payable Increase in working capital See accompanying notes. 33 $ 96,965 228,176 325,141 98,881 315,899 739,921 379,787 115, 000 7,800 502,587 $237,334 $188,500 (9,256) 179,244 5,000 (66,949) 4,797 (938) (58,090) $237,334 EXHIBIT E-3 34 CITY OF EULESS, TEXAS NOTES TO WATER AND SEWER ENTERPRISE FUND FINANCIAL STATEMENTS September 30, 1975 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 in 1968. 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 redemp- tion 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 requirement on the amount of bonds then outstanding. As of September 30, 1975, $1,650,000 (28,45%) of the revenue bonds have been retired with proceeds from the sale noted above, 2. Contractual obligations Under the City's long-term contract with the Trinity River Authority of Texas for sewer treatment services and water supply, the City is obligated for the next 48 years to share in the costs of operations, maintenance and debt service of the Authority. Annual charges to the City by TRA in 1976 will approximate $525,000 of which $275,000 is earmarked for debt services Such charges paid by the City totaled approxi- mately $477,000 in 1975 of which $333,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 indebtedness requiring debt service accounting treatment. Certain of the TRA bonds were reflected in the balance sheet in 1974; however, since charges by TRA covering debt service for such bonds constitute "operating expenses", they have been excluded from the accompanying balance sheet and are included in the information above, 35 CITY OF EULESS, TEXAS NOTES TO WATER AND SEWER ENTERPRISE FUND FINANCIAL STATEMENTS September 30, 1975 3. Revenue Bond Ordinances The Series 1965, 1967 and 1971 Water and Sewer Revenue Bonds are payable solely from and equally secured by a first lien on and pledge of the net revenues of the City's combined Waterworks and Sanitary Sewer System. In accordance with the bond ordinances, the following special funds were established: Reserve for revenue bond debt service - to be used for retirement of the current portion of principal and interest payments due. Reserve for revenue bond retirement - to be used for payment of principal and interest on bonds at any time where there is not sufficient money available in the revenue bond debt service fund. No payments are required into this fund after accumulating therein an amount equal to the average annual principal and interest requirements of the bonds outstanding. Reserve for contingency - to be used for payment of extraordinary repairs or replacements to the system necessitated by an emergency for which no other funds are available. Should the reserve for bond debt service and/or reserve for bond retirement prove deficient, the reserve for contingency shall be used for the purpose of meeting principal and/or interest requirements of the bonds. All requirements for funding of the above reserves were met at September 30, 1975. Investments of funds included in the bond reserve and contingency accounts are restricted to direct obligations of or obligations unconditionally guaranteed by the United States of America having maturities not in excess of ten and five years respectively. 36 CITY OF EULESS, TEXAS WATER AND SEWER ENTERPRISE FUND SCHEDULE OF OPERATING EXPENSES - BUDGETED AND ACTUAL Year ended September 30, 1975 General and administrative: Supervision Clerical Employee benefits Longevity Property and liability insurance Office supplies Postage Legal fees Audit fees Engineering fees Maintenance - machinery and tools Communications Advertising Travel and miscellaneous Bad debts Water production: Supervision Labor operations Employee benefits Overtime Office supplies Wearing apparel Motor fuel Minor apparatus Maintenance: Machinery and tools Motor vehicles Signal system Water - TRA Electricity Bank charges Contingencies and other Budget Actual (over) Actual under $ 16,000 $ 20,499 25,602 24,022 7,000 5,891 500 193 7,000 6,524 2,200 4,002 5,500 5,000 600 8,650 1,475 2,980 5,000 1,747 500 1,138 2,700 3,652 50 38 500 241 5,316 74,627 89,893 4,425 5,826 22,775 19,804 5,038 3,602 500 473 100 85 650 532 2,000 2,232 250 366 400 1,125 500 401 500 192 419,232 412,955 25,000 61,737 100 61 42,400 4,272 523,870 513,663 $ (4,499) 1,580 1,109 307 476 (1,802) 500 (8,050) (1,505) 3,253 (638) (952) 12 259 (5,316) (15, 266) (1,401) 2,971 1,436 27 15 118 (232) (116) (725) 99 308 6,277 (36,737) 39 38,128 10,207 EXHIBIT E-4 CITY OF EULESS, TEXAS WATER AND SEWER ENTERPRISE FUND SCHEDULE OF OPERATING EXPENSES - BUDGETED AND ACTUAL Year ended September 30, 1975 (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 37 Actual (over) Budget Actual under $ 4,425 56,538 10,000 5,500 1,500 3,300 1,500 300 700 1,500 4,966 7,000 8,000 650 850 500 50 625 150 3,500 31, 000 29,637 172,191 4,425 36,620 2,500 6,219 1,000 2,300 1,200 2,000 $ 6,000 59,830 9,102 6,323 1,589 3,669 1,158 333 111 2,555 1,773 6,998 6,658 317 364 75 450 106 1,217 29,583 138,211 4,833 27,408 1,930 5,055 779 2,666 744 526 $ (1,575) (3,292) 898 (823) (89) (369) 342 (33) 589 (1,055) 3,193 2 1,342 333 486 425 50 175 44 2, 283 31, 000 54 33,980 (408) 9,212 570 1,164 221 (366) 456 1,474 EXHIBIT E-4 38 CITY OF EULESS, TEXAS WATER AND SEWER ENTERPRISE FUND SCHEDULE OF OPERATING EXPENSES - BUDGETED AND ACTUAL Year ended September 30, 1975 (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 Actual (over) Budget Actual under $ 2,500 1,800 3,766 350 1,200 74, 557 2,000 100 200 30,740 $ 1,566 854 1,275 240 4,725 34,771 2,952 103 110 1,203 $ 934 946 2,491 110 (3,525) 39,786 (952) (3) 90 29,537 173,477 91,740 81,737 $944,165 $833,507 $110,658 EXHIBIT E-4 39 CITY OF EULESS, TEXAS TRUST AND AGENCY FUNDS BALANCE SHEET September 30, 1975 Social Security Escrow ASSETS Total Fund Fund Cash in bank (Exhibit A-5) $76,266 $47,385 $28,881 Employee account receivable 1,509 1,509 $77_1775 $48,894 $28,881 LIABILITIES, RESERVES AND FUND BALANCE Payroll taxes payable Reserve for general escrow deposits Fund balance $40,291 $40,291 $ 28,881 28,881 8,603 8,603 $77,775 $48,894 $28,881 EXHIBIT F 40 CITY OF EULESS, TEXAS TRUST AND AGENCY FUNDS STATEMENT OF CASH RECEIPTS AND DISBURSEMENTS Year ended September 30, 1975 Social Security Escrow Total Fund Fund Balance at beginning of year $101,705 $ 50,655 $ 51,050 Receipts: For social security, federal income taxes withheld, employees insurance premiums and employee United Fund deductions Escrow deposits 476,907 476,907 84,621 84,621 561,528 476,907 84,621 Disbursements: Payments for social security, federal income taxes withheld, insurance premiums and U1iited Fund 480,177 480,177 Escrow payments for street and drainage construction 106,790 - 106,790 586,967 480,177 106,790 Balance at end of year $ 761266 $ 47/385 $ 28,881 EXHIBIT F-1 41 CITY OF EULESS, TEXAS STATEMENT OF GENERAL FIXED ASSETS September 30, 1975 General fixed assets: Buildings Improvements other than buildings Machinery and equipment Investment in general fixed assets: From general bonds From current revenues and assessments $1,141,322 3,474,723 678,188 $5,294,233 $3,448,146 1,846,087 $5,294,233 EXHIBIT G 42 CITY OF EULESS, TEXAS STATEMENT OF CHANGES IN GENERAL FIXED ASSETS BY SOURCE Year ended September 30, 1975 Improvements Machinery other than and Total Buildings buildings equipment Balance at beginning of year $4,617,797 $1,137,295 $2,920,411 $560,091 Add: Expenditures from bond proceeds 563,961 2,700 525,329 35,932 Expenditures from assessments and other special funds 26,775 26,775 Expenditures from current revenues 85,700 1,327 2,208 82,165 Balance at end of year $5,294,233 $1,141,322 $3,474,723 $678,188 EXHIBIT G-1 43 CITY OF EULESS, TEXAS SCHEDULE OF GENERAL FIXED ASSETS CLASSIFIED BY DEPARTMENTS Year ended September 30, 1975 Improvements Machinery other than and Total Buildings buildings equipment General Government $ 405,052 $ 254,673 $ 698 $149,681 Street Department 2,826,205 2,759,633 66,572 Police Department 321,308 154,525 23,704 143,079 Fire Department 223,138' 92,241 130,897 Park and Recreation Departments 1,169,452 390,039 659,664 119,749 Library 349,078 249,844 31,024 68,210 $5,294,233 $1,141,322 $3,474,723 $678,188 EXHIBIT G-2 44 CITY OF EULESS, TEXAS STATEMENT OF GENERAL LONG-TERM DEBT September 30, 1975 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 $ 237,135 3,317,865 $3,555,000 Serial bonds payable in future years (Table V) $3,555,000 EXHIBIT H SUPPLEMENTARY INFORMATION - STATISTICAL DATA 45 Tax roll dates 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 10-1-74 Fiscal period ending 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 9-30-75 CITY OF EULESS, TEXAS TAX LEVIES AND TAX COLLECTIONS Last ten fiscal years Assessed value $ 30,285,610 41,603,636 45,009,290 48,914,070 67,556,170 77,420,170 86,000,000 93,312,960 138,068,760 145,595,360 Total tax levy $ 302,856 320,348 382,592 415,770 574,240 658,071 695,199 793,175 1,173,599 1,236,912 TABLE I Collections current years taxes during fiscal period $ 300,609 304,185 369,344 402,888 543,005 621,586 676,102 769,851 1,070,877 1,136,105 Percent of collection of current levy 99.25 94.95 96.53 96 .90 94.56 94.45 97.25 97.06 91.25 91.85 Collection on delinquent rolls fiscal period $ 1,410 5,767 14,398 7,432 8,637 21,049 20,658 17,146 10,072 51,805 Total collections during fiscal period $ 302,019 309,952 383,742 410,320 551,642 642,635 696,760 786,997 1,080,949 1,187,910 Percent of total collection to tax levy 99.72 96.71 100.30 98.69 96.06 97.65 100.22 99.22 92.11 96.04 46 Tax roll dates City 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 10-1-75 .85 Tax roll Fiscal dates period 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 10-1-74 9-30-75 CITY OF EULESS, TEXAS TAX RATES AND TAX LEVIES Prior fiscal years School $1.45 1.45 1.45 1.69 1.69 1.69 1.69 1.69 1.76 1.76 City TAX RATES County $ .82 .82 .82 .82 .88 .88 .86 .86 .86 .86 TAX LEVIES (Estimated) $ 302,856 320,348 382,592 415,784 574,240 658,071 695,199 793,175 1,173,599 1,236,912 School $ 411,884 603,248 652,625 775,056 1,000,000 1,100,000 1,200,000 1,600,000 2,400,000 2,700,000 State $ .47 .47 .47 .42 .37 .32 .27 .22 .17 .12 County and state $375,541 515,881 558,125 615,426 668,500 714,000 725,000 750,000 800,000 825,000 Total $3.51 3.59 3.59 3.78 3.79 3.74 3.67 3.62 3.64 3.59 Total $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 4,761,912 TABLE II 47 CITY OF EULESS, TEXAS REVENUES - OTHER THAN PROPERTY TAXES Last ten fiscal years Taxes (other than Fiscal property period taxes) 9-30-66 $ 36,045 9-30-67 34,349 9-30-68 44,502 9-30-69 53,317 9-30-70 117,162 9-30-71 199,807 9-30-72 222,960 9-30-73 293,011 9-30-74 377,401 9-30-75 449,385 Licenses and permits $ 9,448 13,170 27,833 30,642 20,187 40,464 31,966 35,984 27,035 12,568 County f ire Fines program Library $ 23,344 42,069 50,343 46,025 58,027 57,002 76,101 109,720 123,847 177,918 $1,500 1,600 1,600 2,000 2,200 2,400 2,600 2,800 3,000 3,000 $2,518 6,805 5,206 7,915 7,444 6,607 8,915 3,943 7,080 7,480 Revenue sharing Other 146,462 131,202 130,840 $ 19,002 26,045 43,409 55,920 58,360 58,355 106,935 144,657 166,355 247,677 TABLE III 48 CITY OF EULESS, TEXAS EXPENDITURES FOR SELECTED FUNCTIONS Last ten fiscal years Fiscal period General Law ended government enforcement 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 9-30-75 $ 73,664 87,735 40,699* 29,826 53,849 60,934 59,678 70,870 85,957 123,340 $105,859 129,954 155,890 189,578 240,017 296,293 341,727 388,473 581,936 600,983 Fire department $ 30,337 29,850 33,878 43,450 58,651 105,713 131,732 153,044 300,827 342,914 Public Parks and works recreation Library $ 67,436 54,691 83,077 89,367 99,427 107,488 119,785 173,717 235,435 235,785 * 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. $ 44,378 61,081 79,141 113,482 119,906 135,421 138,783 253,117 263,081 300,823 $18,808 21,382 33,285 35,032 40,504 42,435 48,605 45,736 58,651 77,006 TABLE IV 49 CITY OF EULESS, TEXAS GENERAL OBLIGATION BONDS OTHER THAN WATER AND SEWER REVENUE DEBT SERVICE CHARGES Bonds Requirements Fiscal outstanding Principal Interest Total 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,555,000 $2,720,077 $6,275,077 Note: See Exhibit A-4 for information on bonds issued subsequent to September 30, 1975. TABLE V 50 CITY OF EULESS, TEXAS REVENUE WATER AND SEWER BONDS DEBT SERVICE CHARGES Bonds Requirements Fiscal outstanding Principal Interest Total 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,585,000 $3,311,373 $7,896,373 TABLE VI 51 CITY OF EULESS, TEXAS INSURANCE IN FORCE September 30, 1975 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 Fire and extended coverage for Simmons Recreation Center Expires Insurers 12- 1-76 12- 12- 12- 1-76 1-76 1-76 9- 3-76 12- 1-76 9- 3-76 9- 3-76 12- 1-76 12- 1-76 9-28-76 9-14-76 9- 3-76 9-14-76 2- 7-76 11-25-75 4-10-77 4-20-76 9-12-77 Amount of insurance 3 $ 40,000 3 429,170 3 180,000 3 30,000 3 466,400 3 30,000 3 72,000 3 466,400 3 429,170 3 40,000 2 Scheduled 2 100/300,000 2 300,000 2 1 1 4 4 3 ACV 7,500 2,500 10,000 109000 10,000 75,000 TABLE VII 52 CITY OF EULESS, TEXAS INSURANCE IN FORCE September 30, 1975 (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 VII 53 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 Coverage See Exhibits E for Water and Sewer Enterprise Fund financial statements and notes. $647,915 $263,212 2e46 times TABLE VIII