Loading...
HomeMy Public PortalAbout1979 Comprehensive Annual Financial Report (8 mos 12/31) TABLE OF CONTENTS PAGE INTRODUCTORY SECTION AUDITORS' REPORT ON THE FINANCIAL STATEMENTS 1 FINANCIAL SECTION COMBINED OVERVIEW FINANCIAL STATEMENTS Combined Balance Sheet - All Fund Types and Account Groups 2 Combined Statement of Revenues, Expenditures and Changes in Fund Balance - Ail Governmental Fund Types 3 Combined Statement of Revenues, Estimated and Actual, Expenditures - Appropriated and Actual, and Changes in Fund Balance - Corporate and Special Revenue Funds 4 Combined Statement of Revenues, Expenses and Changes in Retained Earnings/Fund Balance - All Proprietary and Fiduciary (Nonexpendable and Pension Trust) Fund Types 5 Combined Statement of Changes in Financial Position - Ail Proprietary and Fiduciary (Nonexpendable and Pension Trust) Fund Types 6 Notes to the Financial Statements 7 - 16 GOVERNMENTAL FUND TYPES CORPORATE FUND Financial Statements Balance Sheet 17 Statement of Revenues - Estimated and Actual, Expenditures - Appropriated and Actual and Changes in Fund Balance 18 Supplemental Statements Statement of Expenditures - Appropriated and Actual 19 ! TABLE OF CONTENTS ! PAGE FINANCIAL SECTION (CONT.) GOVERNMENTAL FUND TYPES (CONT.) SPECIAL REVENUE FUNDS Ail Funds I Financial Statements Combined Balance Sheet 20 Combined Statement of Revenues, Expenditures, and Changes in Fund Balance 21 · Library 22 - 23 Federal Revenue Sharing 24 - 25 Illinois Municipal Retirement 26 - 27 · Motor Fuel Tax 28 - 29 DEBT SERVICE FUNDS All Funds Financial Statements Combined Balance Sheet 30 · Combined Statement of Revenues, Expenditures, and Changes in Fund Balance 31 Debt Service 32 - 33 · Public Benefit 34 - 35 CAPITAL PROJECT Ail Funds Financial Statements Combined Balance Sheet 36 Combined Statement of Revenues, Expenditures, and Changes in Fund Balance 37 Waterworks and Sewerage ~cquisition Fund 38 - 39 · Village Hall Construction 40 - 41 Public Works Garage 42 - 43 SPECIAL ASSESSMENT l Ail Funds Financial Statements I Combined Balance Sheet 44 Combined Statement of Revenues, Expenditures, and Changes in Fund Balance 45 ! TABLE OF CONTENTS PAGE FINANCIAL SECTION (CONT.) PROPRIETARY FUND TYPES ENTERPRISE Ail Funds Financial Statements Combined Balance Sheet 46 Combined Statement of Revenues, Expenditures, and in Retained 47 Changes Earnings Waterworks and Sewerage Fund Number One Balance Sheet 48 Analysis of Changes in Contributions and Retained Earnings 49 Statement of Income and Expenses - Budgeted and Actual 50 Statement of Changes in Restricted Accounts 51 Statement of Changes in Financial Position 52 Schedule of Fixed Assets and Depreciation 53 Waterworks and Sewerage Fund Number Two Balance Sheet 54 Statement of Changes in Contributions and Retained Earnings 55 Statement of Income and Expense - Budgeted and Actual 56 Statement of Changes in Financial Position 57 Schedule of Fixed Assets and Depreciation 58 Commuter Parking Lot Balance Sheet 59 Statement of Income and Expense - Budgeted and Actual and Changes in Retained Earnings 60 Statement of Changes in Financial Position 61 ! ! TABLE OF CONTENTS ! PAGE FINANCIAL SECTION (CONT.) FIDUCIARY FUND TYPES TRUST AND AGENCY · Ail Funds I Financial Statements Combined Balance Sheet 62 Combined Statement of Revenues, Expenditures, and Changes in Fund Balance 63 Police Pension 64 - 65 Firemen's Pension 66 - 67 Escrow Deposit 68 - 69 ACCOUNT GROUPS General Fixed Assets Account Group Statement of General Fixed Assets 70 General Long-Term Debt Account Group Statement of General Long-Term Debt 71 STATISTICAL SECTION AUDITORS' REPORT - SUPPLEMENTARY DATA 72 SUPPLEMd~NTARY DATA Schedule of Interfund Accounts 73 - 74 · Property Tax Assessed Valuations, Rates, Extensions and Collections 75 · Statement of Legal Debt Margin 76 Insurance in Force 77 Long-Term Debt Requirements 78 - 84 · Statement of Cash and Investments 85 Statement of Investments 86 - 90 Statement of Revenues - Estimated and Actual - Fund 91 · Corporate Statement of Expenditures and Encumbrances Compared with Appropriations - Corporate Fund 92 - 107 Statement of Expenditures Compared with Budget - Waterworks and Sewerage Fund Number O~e 108 - 110 Statement of Expenditures Compared with Budget - Waterworks and Sewerage Fund Number Two 111 - 112 ! I i I I I i I I I I i I i I I I INTRODUCTORY SECTION I I I I I I i I I I I I I I ! I AUDITORS' REPORT ON THE FINANCIAL STATEMENTS The Honorable Thomas E. Smith, President ~ard of ~ustees Village of Glenview, Illinois We have examined the financial statements of the various funds and account groups of the Village of Glenview, Illinois for the eight months ended December 31, 1979, as listed in the foregoing table of contents. Our examination was made in accordance with generally accepted auditing standards, and accordingly included such tests of the accounting records and such other auditing procedures as we considered necessary in the circumstances. In our opinion, the aforementioned financial statements present fairly the financial position of the various funds and account groups of the Village of Gienview, Illinois at December 31, 1979 and the results of operations of such funds and the changes in financial position of the Enterprise Funds for the eight months then ended (see Note 2), in accepted accounting principles. conformity with generally The accompanying supplemental schedules and related information presented on pages 73 - 112 are not necessary for a fair presentation of the financial statements, but are presented as additional analytical data. his information 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 material respects in relation to the financial statements taken as a whole. Karrfson & Byrne April 25, 1980 Bank of Wheaton Building · 21 I South Wheaton Avenue · Wheaton, Illinois 60187 · (312) 665-4510 Geneva Professional O~ces o 206'~ West State Street- Geneva, Illinois 60134 · (312) 232-94~ I I ! I I I i I I I I I I I I I FINANCIAL SECTION i I I I I I I I I I I I I I I COMBINED OVERVIEW FINANCIAL STATEMENTS VILLAGE OF GLENVlEW~ ILLINOIS ALL PROPRIETARY AND FIDUCIARY (NONEXPENDABLE PENSION TRUST) FUND TYPES I~terest Expense (8,722.50) (8,722.50) ~ 12~092.98 ~ 12~092.98 ~3~844~985.34 ~ 2~624~829.40 ~6t469~814.74 6 VILLAGE OF GLENVIEW~ ILLINOIS ALL PROPRIETARY AND FIDUCIARY (NONEXPENDABLE AND PENSION TRUST) FUND TYPES COMBINED STATEMENT OF CHANGES IN FINANCIAL POSITION FOR TNE EIGHT MONTHS ENDED DECEMBEH 31, 1979 Proprietary Fiduc£arF Fund Types Total Fund Types Nonexpendable Pension (Memorand~ Enterprise Trust Trust Only) Sources of Cash Net Income $ 233,587.17 $ 360,768.40 $ 594,355.57 Nd Non-Cash Items Depreciation 110,277.73 110,277.73 Contributions - Capital Project Fund 5,700,000.00 5,700,000.00 Transfers from Other ~ccounts 28,402.95 28,402.95 Increase in Liabilities 82,326.06 82,326.06 Decrease in Current Assets 206,726.79 $ 53~442.92 260,169.71 $6,361~320.70 $ 53,442.92 $ 360,768.40 $ 6,775,532.02 Uses of Cash Increase in Current Amsets $ 132,247.51 $ 100,938.01 $ 233,185.52 Decrease in Current Liabilities 428,716.68 $ 13,695.20 5,241.22 447,653.10 Transfers to Other A~counts 29,000.00 29,000.00 Purchase Fixed Assets 564,121.28 564,121.28 Decrease in Refundable Deposits 740,174.53 740,174.53 $1~154,085.47 $ 753~869.73 $ 106~179.23 $ 2~014,134.43 Not Increase (Decrease) $5,207,235.23 $ (700,426.81) $ 254,589.17 $ 4,761,397.59 Cash and Investments May 1, 1979 1~559,280.41 2,626~676.70 2,434~741.63 6,620,698.74 December 31, 1979 $6,766,515.64 $1~926~249.89 ~2~689~330.80 $11~382,096.33 lhe accompanying Notes to the Financial Statemeuts are an integral part of ali financial statements. VILLAGE OF GLENVIEW, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 1979 1. S,,mmary of Significant ~counting Policies Financial Statements - The financial statements are presented in accordance with generally accepted accounting principles applicable to state and local governmental units. These basic principles have been promulgated by the National Council on Governmental Accounting, and are detailed in their publications entitled "Governmental Accounting, Auditing and Financial Reporting" and in "Governmental Accounting and Financial Reporting Principles - NCGA Statement 1"; these principles are also embodied in "Audits of State and Local Governmental Units" as published by the American Institute of Certified Public Accountants. Funds - For governmental units the basic accounting and reporting entity is a "fund". A fund is defined as an independent fiscal and accounting entity with a self-balancing set of accounts recording cash and/or other resources together with all related liabilities, obligations, reserves and equities which are segregated for the purpose of carrying on specific activities or attaining certain objectives in accordance with special regulations, restrictions or limitations. Bases of Presentation The following fund types and account groups are used by the Village: GOVERNMENTAL FUND TYPES Fund - The Corporate Fund is the general operating fund of Corporate the Village. Ail general tax revenues and other receipts that are not allocated by law or contractual agreement to another fund are ac- counted for in this fund. From the fund are paid the general opera- ting expenditures, the fixed charges, and the capital improvement costs that are not paid through other funds. Special Revenue Funds - Special Revenue Funds are used to account for the proceeds of specific revenue sources (other than special asses- ments, expendable trust, or major capital projects) requiring separate accounting because of legal or regulatory provision or administrative action. Debt Service Funds - Debt Service Funds are used to account for the annual payment of principal, interest, and expenditures on long-term general obligation debt, other than bonds payable from special assess- ments or from the operations of an enterprise. 8 VILLAGE OF GLENVIEW, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 1979 Summary of Significant A~counting Policies (Cont.) Bases of Presentation (Cont.) GOVERNMENTAL FUND TYPES (CONT.) Capital Project Funds - Capital Project Funds are used to account for financial resources segregated for the acquisition or construc- major capital other than those financed by tion of facilities special assessments or enterprise operations. Special Assessment Funds - Special Assessment Funds are used to account for financial resources obtained and used for the financing and construction of improvements that are to be fully or partially paid for by assessments against benefited properties. PROPRIETARY FUND TYPES Enterprise Funds - Enterprise Funds are used to account for operations that provide a service to citizens financed primarily by a user charge for the provision of that service and activities where the periodic measurement of net income is deemed appropriate for capital maintenance, public policy, management control, accountability, or other purposes. ACCOUNT GROUPS General Fixed Assets Account - This Group account group is established to account for all fixed assets of the Village, other than those accounted for in the Enterprise Funds. General Lon$-Term Debt Account Group - This account group is estab- lished to account for the long-term debt, including capitalized leases, that is backed by the Village's full faith and credit. Bases of Accounting Corporate~ Special Revenue and Debt Service Funds The modified accrual basis of accounting has been utilized. Revenues are recognized when received in cash except for material and/or available revenues which are accrued to properly reflect earnings for the period. Such revenues accrued at the end of the accounting period are those which are both measurable and available; that is, the item is a resource that can be used to finance the governmental operations dur- ing the year. Expenditures are recognized when the fund liability is incurred. VILLAGE OF GLENVIEW, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 1979 1. Sunm~ary of Significant A~counting Policies (Cont.) Bases of Accounting (Cont.) Corporate~ Special Revenue and Debt Service Funds (Cont.) Fixed assets are not capitalized but rather are charged to current expen- ditures. Fixed asset acquisitions are accounted for in the General Fixed Assets Account Group and are valued at historical cost; no depreciation is required to be recorded. The long-term portion of general obligation debt has been reflected in the General Long-Term Debt Account Group. Capital Projects, Enterpris~ Trust and Asency and Special Assessment Funds The accrual basis of accounting has been utilized. Revenues are recognized when earned and expenditures recognized when incurred. En- terprise Funds account for their own fixed assets, which are valued at historical cost, and for current and long-term debt. Depreciation is recorded. carried at cost, which approximates market, Investments All investments are unless otherwise noted. Inventories - All inventories are carried at the lower of cost, on a first- in, first-out basis, or market. Encumbrances - the Village utilizes an encumbrance system; commitments are recorded as expenditures and reported as "Encumbrances Outstanding" on applicable balance sheets. The Village prepares its budget on the same bases of accounting Budgetary Data aa that used for the applicable funds, as stated previously under "Bases of Accounting". For financial reporting purposes, the Village has presented budget com- parisons to actual results in this report. For consistency purposes the Village has elected to use the term "Appropriations" on its financial statements. A statement comparing appropriation ordinance amounts to actual is presented in the supplementary data section. 2. Change in Ascounting Period On July 2, 1979 the Village board passed Ordinance #2239 adopting the "Municipal Budget Office's System of Finance" and changed its fiscal year end from April 30 to December 31. This is to commence January 1, 1980. 10 VILLAGE OF GLENVIEW~ ILLINOIS NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 1979 Property Taxes receivable which are delinquent more than two years have been written off, subsequent collections of such taxes are reflected as "Prior years' taxes" revenue in the period received. The allowance for uncollectible taxes has been stated at 1% of the 1979 tax levy, to reflect actual collection experience. Rmtirement Commitments Illinois Municipal Retirement Fund 1) The Village is a participating member of the Illinois Municipal Retire- ment Fund which covers all of its employees who: a) occupy a job normally requiring 600 hours or more per year; b) are paid on a regular payroll from Village funds; c) were under age sixty when first entering employment; and d) are not covered by another state created retirement system for the same service. 2) The Illinois Municipal Retirement Fund's (Chicago) actuary estimated that as of December 31, 1978, the present value of currently accrued retirement obligations of the Village was $1,687,103.00. The Village had accumulated assets of $484,639.00 on the same date. Therefore, the balance of $1,202,464.00 remains to be financed future contributions by payable by the municipality on behalf of its present employees. The normal cost portion of the Village's contribution rate is expected to provide $312,462.00 of this amount and the prior service portion of the rate is expected to provide $890,002.00. The latter amount is considered to be unfunded at this time; it is sometimes referred to as the "actuarial deficiency." As required by Section 7-172, Chapter 108-1/2, Illinois Revised Statutes 1977, municipality contribution rates are fixed at levels, certified by the Fund actuary, sufficient to meet the entire cost of benefit payments ultimately to be made. VILLAGE OF GLENVIEW, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 1979 4. Retirement Commitments (Cont.) Police Pension Fund 1) Chapter 108-1/2, Sections 3-125 and 127 of the Illinois Revised Statutes, 1977, provides that municipalities shall establish and maintain a reserve fund of not less $10,000.00 for each police- man and each beneficiary; provided that the accumulated reserve shall not exceed the estimated total actuarial requirements of the Fund. In municipalities having less than the actuarial requirements of the Fund, the Board of Trustees of the Fund shall designate the propor- tionate amount needed annually to insure the accumulation of such actuarial reserve over a 40 year period ending in 1999. The total actuarial requirements at April 30, 1978 (the date of the latest computation) amounted to $2,629,018.00, as determined by the Illinois Department of Insurance. Net present assets $1,401,099.00 Unfunded accrued liability 1~227,919.00 $2,629,018.00 2) Tax Levy Requirements Amount necessary to provide the normal cost based on the annual payroll of active of December 31, 1978 $ 101,530.00 participants as Amount necessary to amortize the unfunded accrued liability of $2,629,018.00, as determined by the State of Illinois De- partment of Insurance over the remaining 21.2137 years as contemplated by Section 3-127 of the Illinois Pension Code 203,893.00 Total amount of tax levy necessary to ar- rive at the annual requirements of the Fund as required in Section 3-125 of the Illinois Pension Code $ 305,423.00 12 VILLAGE OF GLENVIEW~ ILLINOIS NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31~ 1979 P~tirement Commitments (Cont.) Firemen's Pension Fund Chapter 108-1/2, Section 4-120 and 127 of the Illinois Revised Statutes, 1977, provides that municipalities shall establish and maintain a reserve fund of not less than $1,000.00 for each 1,000 inhabitants; provided that the accumulated reserve shall not exceed the estimated total actuarial requirements of the Fund. In municipalities having less than the actuarial requirements of the Fund, the Board of Trustees of the Fund shall designate the proportionate amount needed annually to insure the accumulation of such actuarial reserve over a 40 year period ending in 2007. The actuarial requirements at April 30, 1979 (the date of the latest computation) amounted to $2,098,445.00, as determined by the Illinois Department of Insurance. Net present assets $ 990,085.00 Unfunded accrued liability 1,108,360.00 $2,098,445.00 Tax Levy Requirements Minimum amount necessary to provide actuarial reserves for the annuities and benefits to be earned during the year, computed at a rate of not less than 17.5% of the annual payroll of active particpants as of December 31, 1978 $ 178,818.00 Amount to amortize the unfunded necesary accrued liability of $2,098,445.00 as determined by the State of Illinois Department of Insurance over the re- maining 29.0 years as contemplated by by Section 4-118 of the Illinois Pension Code 66,956.00 Total amount of tax levy necessary to arrive at the annual requirements of the Fund as required in Section 4-118 of the Illinois Pension Code .$ 245,774.00 VILLAGE OF GLENVIEW~ ILLINOIS NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 1979 5. Motor Fuel Tax Fund The balance of Unobligated Funds in the Motor Fuel Tax Fund at December 31, 1979 is $883,691.79. Unobligated Funds April 30, 1979 $615,932.29 Allotments 243,384.94 Credits (Unexpended - Approved Projects and Interest Income) 1972 Contract Construction $36,706.46 1972 Engineering 11,081.76 1973 Contract Construction 51.65 1973 Engineering 1,209.26 1974 Contract Construction 50.00 1975 Engineering 2,712.82 1975 Engineering 3,773.41 1975 Contract Construction 10,067.40 1975 Contract Construction 340.55 1976 Contract Construction 1,031.94 1977 Contract Construction 4,369.80 71,395.05 $930,712.28 Less - Authorizations by the Illinois Department of Transportation 1972 Other $ 4,480.00 1974 Contract Construction 26,322.59 1976 Engineering 6,785.83 1976 Contract Construction 4,997.68 1977 Engineering 4,434.39 47,020.49 $883,691.79 14 VILLAGE OF GLENVIEW~ ILLINOIS NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 1979 Commuter Parking Lease Agreements The Village of Glenview is a lessee under two agreements with the Chicago, Milwaukee, St. Paul and Pacific Railroad Company for certain property adjacent to the railroad station located in the Village. The leases provide the terms as shown. Lease A a. Period - May 1, 1966 to April 30, 1986. b. Annual rent - 30% of parking revenues, but not less than $2,400.00. c. Improvements costs - the Village has incurred certain expen- ditures for capital improvements to improve the area sur- rounding the railroad station. Repayment of the expendi- ture is to be derived from net revenue produced from parking meters installed and parking permits sold. Lease B a. October 1, 1972 to September 30, 1982 Period b. Annual rent - $500.00 (subject to renegotiation after September 30, 1977). c. Improvement costs - the Village is to bear all such costs for improvements. d. Termination - either party may terminate the agreement upon 60 days written notice. Leasehold Improvement Improvements Parking Lot Fund Leasehold of the Commuter reflected in the accounts of the Village have been recorded at cost less accumulated amortization to date of $66,538.06 computed on a straight-line method. VILLAGE OF GLENVIEW, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS DECEMBER 31, 1979 7. Capital Projects Funds A. The Village Hall Construction Fund is accounting for the construction of the new village hall scheduled to be completed in the s,~mer of 1980. The contract for the construction of the new village hall is $1,832,964.00. B. The Public Works Garage Fund was created to accumulate funds for the construction of a new garage facility. The land has already been acquired. C. The Waterworks and Sewerage Acquisition Fund On October 18, 1979 the Village authorized the issuance of the $5,700,000.00 Corporate Purpose Bond Series of 1979 to construct the water transmission mains for the Western unincorporated area of the Village. 8. Waterworks and Sewerage Fund Number One Section 9 of the Revenue Bond Ordinance of 1964 created the following accounts: a) Operation and Maintenance Account b) Bond and Interest A~count c) Bond Raserve Account d) Depreciation, Improvement and Extension Account e) Surplus Revenue A~count. Monthly cash transfers are required in the following order: Operation and Maintenance Account - an amount sufficient to pay the reasonable expenses of maintenance and operation of the system for the next succeeding month, including 1/12 of all expenses which are paid on an annual basis. ~and interest account - an amount not less than 1/5 of the interest Bond becoming due on the next succeeding interest date and an amount equal to 1/10 of the principal becoming due on the next succeeding principal maturity date. Bond reserve account - the sum of $625.00 each month until all bonds have been paid or provided for. 16 VILLAGE OF GLENVIEW~ ILLINOIS NOTES TO THE FIN;~NCIAL STATEMENTS DECEMBER 1979 31~ Depreciation, improvement and extension account - the sum of $2,000.00 each month. Surplus revenue account - at the end of each fiscal year all moneys after distribution of the above amounts to their respective accounts. Funds accumulated in the bond reserve account are available for the payment of maturing bond principal or interest whenever funds are not available for that purpose in the bond and interest account. In addition, whenever the balance in this account equals the maximum principal and interest requirements on all outstanding bonds for any future fiscal year, any surplus above such amount may be transferred to the depreciation, improvement and extension account or may be used for calling and redeeming those bonds that are callable prior to maturity, or by purchasing by tender or on the open market, at not more than par and accrued interest, any bonds which are payable from the revenues of the system. Funds accumulated in the depreciation, improvement and extension account are available for the payment of maturing bond principal or interest, whenever sufficient funds are not available. Also, such funds may be used for either extraordinary repairs or replacements, or improvements and extensions of the system. Whenever the account aggregates $250,000.00, any sums in excess thereof may be transferred to the bond reserve account or to the surplus revenue account. a. To make up any deficiencies in any of the other accounts created by the ordinance. b. Thereafter, at the end of each fiscal year any sums re- maining may be transferred to be used for any lawful purpose including general administration of the system; a sum equal to 7-1/2% of the annual gross revenue or percentage as the President and Board of Trustees such may establish. General Fixed Assets Account Group General fixed assets are recorded as expenditures in the Corporate Fund, Special Revenue Funds, and Capital Projects Funds at time of purchase. Such assets are stated at estimated historical cost in the General Fixed Asset Group of Accounts except for certain improvements other than buildings, including streets, bridges, curbs and gutters, sidewalks, and drainage which are not capitalized. No is systems depreciation provided on general fixed assets. I I I ! I i I I I i I I I I I I I I I I I I I I I I I I I I I I I I ! GOVERNMENTAL FUND TYPES i I I I I I I I I I i I I I i ! I i I I I I I ! I I I I i I ! I I i I CORPORATE FUND I ! ! I ! I I I ! I I I I I I I ! I I 17 VILLAGE OF GLENVIEW, ILLINOIS CORPORATE FUND BALANCE SHEET DECEMBER 31, 1979 ASSETS Cash and Investments (Page 85) $ 613,857.07 Property Taxes R~ceivable - 1979 Levy $918,813.00 Allowance for Uncollectible Taxes (9,188.00) 909,625.00 Replacement Taxes Receivable 33,206.00 Accounts Receivable 654,019.36 Due from Other Funds (Page 73) 478,686.76 .~.2,689,394.19 LIABILITIES, ENCUMBRANCES AND FUND BALANCE Liabilities Accounts Payable $ 57,373.17 Due to Other Funds (Page 73) 47,666.76 Refundable Deposits 81,436.66 Total $ 186,476.59 Encumbrances Outstanding 264,193.63 Total Liabilities and Encumbrances $ 450,670.22 Fund Balance (Page 18) 2~238,723.97 $2,689,394.19 The accompanying Notes to the Financial Statements are an integral part of all financial statements. VILLAGE OF GLENVIEW, ILLINOIS CORPORATE FUND STATEMENT OF REVENUES - ESTIMATED A/~D ACTUAL, EXPENDITURES - APPROPRIATED A-ND ACTUAL AND CHANGES IN FUND BALANCE FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Estimated Revenues or Appropriations Actual Revenues Tax Levy - 1979 $1,025,000.00 $ 918,813.00 (9,188.00) Provision for Uncollectible Taxes · $1,025,000.00 $ 909,625.00 - 33,206.00 Replacement Taxes Prior Years' Tax (14,353.03) Municipal Sales Tax 1,028,500.00 1,050,991.60 Utility Tax 975,000.00 679,483.11 Illinois Income Tax 415,000.00 335,329.35 Road and Bridge Tax 53,000.00 27,177.27 Traffic Fines 120,000.00 123,460.50 Interest on Investments 62,000.00 48,476.18 Transfers From Other Funds 317,157.00 284,950.34 Intergovernmental Transfers 216,350.00 89,057.60 12,000.00 5,064.89 Parking Lot 60,000.00 33,733.12 Miscellaneous Licenses (Page 91) 236,250.00 318,125.28 Permits (Page 91) 148,150.00 270,439.35 $4,668,407.00 $4,194,766.56 Expenditures 3,607,500.00 3,585,044.78 Excess of Revenues over Expenditures (Pages 19 and 92-107) $1,060,907.00 $ 609,721.78 Fund Balance May 1, 1979 1,629,002.19 December 31, 1979 (Page 17) $2,238,723.97 19 VILLAGE OF GLENVIEW, ILLINOIS CORPORATE FUND STATEMENT OF EXPENDITURES - APPROPRIATED AND ACTUAL FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Appropriations Actual General Government Trustees $ 3,585.00 $ 2,389.11 Board of Special Board 6,330.00 5,550.48 Village Clerk's Office 5,467.00 4,944.35 Elections (750.00) Legal 37,100.00 35,263.82 Village Manager's Office 92,704.00 88,082.86 Finance Department 178,377.00 175,727.95 Municipal Building and Grounds 25,638.00 24,345.74 Personnel Department 144,570.00 140,953.58 $ 493,771.00 $ 476,507.89 Public Safety Police Department $1,104,506.00 $1,085,017.47 Fire Department 739,272.00 728,364.96 Printing and General Services 9,395.00 9,272.74 $1,853,173.00 $1,822,655.17 Development and Public Services Administration/Development and Public Services $ 54,175.00 $ 52,456.53 Planning and Zoning 25,102.00 22,277.46 Engineering Department 67 625.00 64,652.69 Public Works - General Street Maintenance 235.200.00 295,393.42 Public Works - Special Projects 452 863.00 445,240.08 Public Works - Snow Removal 69 959.00 65,154.43 Public Works - Parkway Maintenance 93 792.00 96,180.87 Public Works - Garage 146 960.00 134,473.59 Building Inspection 84 940.00 81,667.84 General Health 29~940.00 28,384.81 $1,260,556.00 $1,285,881.72 (Page 18) $3,607,500.00 $3,585,044.78 I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I SPECIAL REVENUE FUNDS I I I I i I I I I I I I I I I I I I I 22 VILLAGE OF GLENVIEW, ILLINOIS LIBRARY FUND BALANCE SHEET DECEMBER 31, 1979 ASSETS Cash and Investments (Page 85) $331,225.19 Property Taxes Receivable - 1979 Levy 455,866.00 Allowance for Uncollectible Taxes (4,558.00) Replacement Taxes P~ceivable 16,347.00 $798,880.19 LIABILITIES AND FUND BALANCE Due to Other Funds (Page 73) $101,563.00 Fund Balance (Page 23) 697,317.19 $798,880.19 The accompanying Notes to the Financial Statements are an integral part of all financial statements. VILLAGE OF GLENVIEW, ILLINOIS LIBRARY FUND STATEMENT OF REVENUES - ESTIMATED AND ACTUAL, EXPENDITURES - APPROPRIATED AND ACTUAL AND CHANGES IN FUND BALANCE FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Estimated Revenues or Appropriations Actual P~venues 1979 Tax Levy $405,000.00 $455,866.00 Provision for Uncollectible Taxes - (4,558.00) $405,000.00 $451,308.00 Replacement Taxes 16,347.00 Prior Years' Taxes (6,117.67) Interest Earned 9,400.00 10,046.44 Miscellaneous Receipts/Grants-in-Aid 8,825.23 Fines and Fees 10,000.00 23,356.26 Other Current Charges 51,190.00 8,638.73 Donations 3,291.00 $475,590.00 $515,694.99 Expenditures Personnel Services $200,000.00 $198,607.99 Operations and Contractual Services 42,220.00 41,957.50 Materials and Supplies 58,950.00 65,457.17 Other Charges 200.00 247.76 Contingencies 1,000.00 331.90 Capital 0~tlay 27,700.00 34,292.32 $330,070.00 $340,894.64 Excess of Revenues over Expenditures $145~520.00 $174,800.35 Fund Balance May 1, 1979 522,516.84 December 31, 1979 (Page 22) $697,317.19 24 VILLAGE OF GLENVIEW, ILLINOIS FEDERAL REVENUE SHARING FUND BALANCE SHEET DECEMBER 31, 1979 ASSETS Cash and Investments (Page 85) $(68,695.15) Distributions Receivable 40,821.00 $(27,874.15) FUND BALANCE Fund Balance (Page 25) $(27,874.15) The accompanying Notes to the Financial Statements are an integral part of all financial statements. 26 VILLAGE OF GLENVIEW, ILLINOIS ILLINOIS MUNICIPAL RETIREMENT FUND BALBR~CE SHEET DECEMBER 31, 1979 ASSETS Cash and Investments (Page 85) $131,994.05 Property ~axes Receivable - 1979 Levy $288,509.00 Allowance for Uncollectible Taxes 2,885.00 285,624.00 Replacement Taxes Receivable 10,339.00 $427,957.05 FUND BAL~uNCE Fund Balance (Page 27) $427,957.05 The accompanying Notes to the Financial Statements are an integral part of all financial statements. VILLAGE OF GLENVIEW~ ILLINOIS ILLINOIS MUNICIPAL RETIREMENT FUND STATEMENT OF REVENUES - ESTIMATED AND ACTUAL, EXPENDITURES - APPROPRIATED AND ACTUAL AND CHANGES IN FUND BALANCE FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Estimated Revenues or Appropriations Actual Revenues 1979 Tax Levy $185,893.00 $ 288,509.00 Provision for Uncollectible Taxes (2,885.00) $185,893.00 $ 285,624.00 Replacement Taxes 10,339.00 Prior Year Taxes (3,498.48) Transfer From Other Funds 37,600.00 24,816.00 Employee Deductions 6,000.00 118,391.61 $229,493.00 $ 435,672.13 Expenditures Participating $143,000.00 $ 257,238.59 Non-Participating - 18,518.29 $143,000.00 $ 275,756.88 Excess of Revenues over Expenditures $ 86,493.00 $ 159~915.25 Fund Balance May 1, 1979 $(621,960.20) Prior Year Adjustment Decrease Actuarial Deficiency 890,002.00 $ 268,041.80 December 31, 1979 (Page 26) $ 427,957.05 28 VILLAGE OF GLENVIEW~ ILLINOIS MOTOR FUEL TAX FUND BALANCE SHEET DECEMBER 31, 1979 ASSETS Cash and Investments (Page 85) $1,053,178.31 Allotments Raceivable 25,619.32 Due From Other Funds (Page 73) 29,618.20 $1,108,415.83 FUND BALANCE Fund Balance (Page 29) .~1,108,415.83 Ihe accompanying Notes to the Financial Statements are an integral part of all financial statements. VILLAGE OF GLENVIEW, ILLINOIS MOTOR FUEL TAX FUND STATEMENT OF REVENUES - ESTIMATED AND ACTUAL, EXPENDITURES - APPROPRIATED AND ACTUAL AND CHANGES IN FUND BALANCE FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Estimated Revenues or Appropriations Actual Ravenues Allotments Earned $ 366,000.00 $ 243,384.94 Interest Earned 21,000.00 36,882.76 Reimbursements from State of Illinois/ Engineering - 68,018.16 P~imbursement for Outside Costs - 11,590.10 $ 387,000.00 $ 359~875.96 Expenditures Maintenance $ 82,000.00 $ 63,285.07 Mass Transit 4,480.00 4,480.00 Fau/Earlem Central 305,360.00 6,148.82 Glenview/Harlem Signals 1,000.00 - Fontana/Lindle S/S 12,000.00 5,000.00 Grove Street Bridge 138,000.00 - Linneman Street/Washington Street 138,160.00 1,564.40 Club Circle 255,000.00 1 2,085.52 Washington Street Widening 38~000.00 - $ 974,000.00 $ 92~563.81 Excess (Deficiency) of Revenues over Expenditures $(587,000.00) $ 267,312.15 Fund Balance May 1, 1979 841,103.68 December 31, 1979 (Page 28) $1~108,415.83 I I I i I I I I I I I I I I I I I I I 3O VILLAGE OF GLENVIEW~ ILLINOIS DEBT SERVICE FUND COMBINED BALANCE SHEET DECEMBER 31, 1979 Total Debt Public (Memorandum Service Benefit Only) ASSETS Cash and Investments $539,077.89 $539,077.89 Property Taxes Receivable - 1979 Levy 267,319.00 267,319.00 Allowance for Uncollectible Taxes (2,67 3.00) (2,673.00) Replacement Taxes 23,737.00 23,737.00 Due From Other Funds $18,048.56 18,048.56 $827,460.89 $18,048.56 $845,509.45 LIABILITIES AND FUND BALANCE Liabilities Bonds Payable $135,000.00 $135,000.00 Due to Other Funds 38,348.75 $ 9,046.05 47,394.80 Interest Payable 174,660.00 174,660.00 Total $348,008.75 $ 9,046.05 $357,054.80 Fund Balance $479,452.14 $ 9~002.51 $488,454.65 $827,460.89 $18,048.56 $845,509.45 The accompanying Notes to the Financial Statements are an integral part of all financial statements. VILLAGE OF GLENVIEW, ILLINOIS DEBT SERVICE FUND COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE FOR THE EIGHT MONTHS ENDED DECEMBER 31~ 1979 Debt P~blic Service Benefit Total Revenues 1979 Tax Levy $267,319.00 $267,319.00 Provision for Uncollectible Taxes (2,673.00) (2,673.00) Replacement Taxes 23,737.00 23,737.00 Prior Years Taxes 1,536.58 1,536.58 Transfers from Other Funds 255,837.50 255,837.50 $545,757.08 - $545,757.08 Expenditures Principal and Interest $307,610.00 $307,610.00 Bank Charges 487.16 487.16 $308,097.16 - $308,097.16 Excess of Revenues over Expendi- tures $237,659.92 $ - $237,659.92 Fund Balance May 1, 1979 241,792.22 9,002.51 250,794.73 December 31, 1979 $479,452.14 $9,002.51 $488,454.65 34 VILLAGE OF GLENVIEW, ILLINOIS PUBLIC BENEFIT FUND BALANCE SHEET DECEMBER 31, 1979 ASSETS Due from Other Funds (Page 73) $18,048.56 LIABILITIES AHqD FUND BALANCE Due to Other Funds (Page 73) $ 9,046.05 Fund Balance (Page 35) 9,002.51 $18,048.56 The accompanying Notes to the Financial Statements are an integral part of all financial statements. VILLAGE OF GLENVIEW, ILLINOIS I PUBLIC BENEFIT FUND STATEMENT OF REVENUES, EXPENDITURES m AND CHANGES IN FUND BALANCE FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Revenues m Expenditures I Excess of Revenues over Expenditures $ - Fund Balance I May 1, 1979 9,002.51 December 31, 1979 (Page 34) $9,002.51 W I I I I i I I I I I I I I I I I CAPITAL PROJECT I I I I I I I I I I I I I I I I I I I 36 VILLAGE OF GLENVIEW, ILLINOIS CAPITAL PROJECTS FUNDS COMBINED BALANCE SHEET DECEMBER 31, 1979 Waterworks and Sewerage Village Hall Public Works Acquisition Construction Garage Fund Fund Fund Total ASSETS Cash and Investments - $857,022.15 $386,234.04 $1,243,256.19 Interest Receivable - 1,431.54 - 1,431.54 Due From Other Funds 138,348.75 - 138,348.75 - $996,802.44 $386,234.04 $1,383,036.48 LIABILITIES AND FUND BALANCE Due To Other Funds $ - $ 98,907.42 $ 98,907.42 Fund Balance - 996,802.44 287,326.62 1,284,129.06 - $996,802.44 $386,234.04 $1,383,036.48 The accompanying Notes to the Financial Statements are an integral part of all financial statements. VILLAGE OF GLENVIEW, ILLINOIS CAPITAL PROJECTS FUNDS COMBINED STATEMENT OF REVENUES~ EXPENDITURES AND CHANGES IN FUND BALANCE FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Waterworks and Sewerage Village Hall Public Works Acquisition Construction Garage Fund Fund Fund Total Rmvenues Interest Income $ 73,571.73 $ 3,519.20 $ 77,090.93 Transfer from Other Funds 90,000.00 100,000.00 190,000.00 Proceeds from Bond Issue $5,700,000.00 5,700,000.00 $5,700,000.00 $ 163,571.73 .$103,519.20 $5,967~090.93 Expenditures Contractual Services $ 865,329.69 - $ 865,329.69 Other Costs 3,477.00 - 3,477.00 Transfer to Waterworks and Sewerage Fund Number Two $5,700,000.00 - - 5,700,000.00 $5,700~000.00 $ 868,806.69 $6,568,806.69 Excess (Deficiency) of Revenues over Expenditures - $ (705,234.96) $103,519.20 $ (601,715.76) Fund Balance May 1, 1979 - 1~702,037.40 183,807.42 1,885,844.82 December 31, 1979 $ 996,802.44 $287,326.62 $1,284~129.06 38 VILLAGE OF GLENVIEW~ ILLINOIS WATERWORKS AND SEWERAGE ACQUISITION FUND BALANCE SHEET DECEMBER 31, 1979 ASSETS NONE FUND BALANCE NONE The accompanying Notes to the Financial Statements are an integral part of all financial statements. VILLAGE OF GLENVIEW~ ILLINOIS WATERWORKS AND SEWERAGE ACQUISITION FUND STATEMENT OF REVENUES - ESTIMATED AND ACTUAL, EXPENDITURES - APPROPRIATED AND ACTUAL AND CHANGES IN FUND BALANCE FOR THE EIGHTS MONTHS ENDED DECEMBER 31, 1979 Estimated Revenues or Appropriations Actual P~venues Proceeds of Bond Issue - $5,700,000.00 Expenditures Transfer to Waterworks and Sewerage Fund Number Two - 5,700,000.00 Excess (Deficiency) of Revenues over Expenditures - Fund Balance May 1, 1979 December 31, 1979 - 4O VILLAGE OF GLENVIEW, ILLINOIS VILLAGE HALL CONSTRUCTION FUND BALANCE SHEET DECEMBER 31, 1979 ASSETS Cash and Investments (Page 85) $857,022.15 Interest P~ceivable 1,431.54 Due From Other Funds (Page 73) 138,348.75 $996,802.44 FUND BALANCE Fund Balance (Page 41) $996,802.44 The accompanying Notes to the Financial Statements are an integral part of all financial statements. VILLAGE OF GLENVIEW~ ILLINOIS VILLAGE HALL CONSTRUCTION FUND STATEMENT OF REVENUES - ESTIMATED AND ACTUAL, EXPENDITURES AND CHANGES IN FUND BALANCE FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Estimated Revenues Actual Revenue s Transfer from Corporate Fund $ 250,000.00 $ 90,000.00 Interest Earned - 73,571.73 $ 250,000.00 $ 163,571.73 Rxpenditures Contractual Services $ 1,941,090.00 $ 865,329.69 Other Costs 3,477.00 $ 1,941,090.00 $ 868,806.69 Excess of Revenues over Expenditures $(1~691,090.00) $ (705,234.96) Fund Balance May 1, 1979 1,702,037.40 December 31, 1979 (Page 40) $ 996,802.44 42 VILLAGE OF GLENVIEW, ILLINOIS PUBLIC WORKS GARAGE FUND BALANCE SHEET DECEMBER 31, 1979 ASSETS Cash and Investments (Page 85) $386,234.04~ LIABILITIES AND FUND BALANCE Due to Other Funds (Page 73) $ 98,907.42 Fund Balance (Page 43) 287,326.62 $386,234.04 The accompanying Notes to the Financial Statements are an integral part of all financial statements. VILLAGE OF GLENVIEW, ILLINOIS PUBLIC WORKS GARAGE FUND STATEMENT OF REVENUES - ESTIMATED AND ACTUAL, EXPENDITURES - APPROPRIATED AND ACTUAL AND CHANGES IN FUND BALANCE FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Estimated Revenues or Appropriations Actual Ravenues Transfer from Corporate Fund $ 170,000.00 $100,000.00 Interest Income 3,519.20 $ 170,000.00 $103,519.20 Expenditures Contractual Services 303,340.00 - Excess of Revenues over Expenditures $(133,340.00) $103,519.20 Fund Balance May 1, 1979 183,807.42 December 31, 1979 (Page 42) $287,326.62 I I I I I I I I I I I I I I I I SPECIAL ASSESSMENT I I I I I I I I I I I I I I I I ! i I ! ! I I ! I I ! ! ! I i I ! I I PROPRIETARY FUND TYPES ! I I I I I I I I ! I I i I I ! I ! i I I I I I I I ! I I I I I ! I I I I I VILLAGE OF GLENVIEW, ILLINOIS WATERWORKS AND SEWERAGE FUND NUMBER ONE OPERATIONS AND MAINTENANCE ACCOUNT ANALYSIS OF CHANGES IN CONTRIBUTIONS AND RETAINED EARNINGS FOR THE EIGHT MONTHS ENDED DECEMBER 31~ 1979 Municipal Retained Contributions Earninss Increases Transfers from Restricted Accounts - $ 28,402.95 Decreases Net Loss (Page 50) $ 82,604.41 Transfers to Restricted Accounts 29~000.00 - $ 111~604.41 Net Increase (Decrease) $ - $ (83,201.46) Account Balance May 1, 1979 285~000.00 3,790,546.59 December 31, 1979 (Page 48) $285,000.00 $3,707,345.13 5O VILLAGE OF GLENVIEW, ILLINOIS WATERWORKS AiND SEWERAGE FUND NUMBER ONE OPERATIONS =D NTEN=CE ACC0UNT STATEMENT OF INCOME AND EXPENSE - BUDGETED AND ACTUAL FOR THE EIGHT MONTHS ENDED DECEMBER 31~ 1979 Budget Actual Operating Income Water and Sewer Charges $1,150,000.00 $ 675,194.38 Water Meter Repair Charges 100.00 507.00 Water Connection Charges 35,000.00 47,776.00 Water Meters and Remote Readers 14,000.00 4,958.00 Brass Fittings 3,000.00 3,252.00 Water for Construction 1,500.00 2,050.00 Turn on Charges 2,500.00 1,350.00 $1,206~100.00 $ 735,087.38 Operating Expenses (Pages 108-110) Water Administration $ 230,280.00 $ 67,193.69 Water Operations and Maintenance 550,916.00 508,669.13 Pumping Station 71,920.00 94,471.63 Distribution System 94,740.00 76,148.79 Sewer Operations and Maintenance 53,442.00 51,370.63 Lift Station 275.00 595.98 Special Projects 48,000.00 $1,049,573.00 $ 798,449.85 Net Operating Income (Loss) before Depreciation $ 156,527.00 $ (63,362.47) Depreciation 44,526.33 Net Operating Income (Loss) $ 156~527.00 $(107,888.80) Add Non-Operating Income Interest Earned $ 16,000.00 $ 38,982.59 Miscellaneous 7,400.00 2,674.30 Transfers from Other Funds 255,000.00 $ 278,400.00 $ 41~656.89 Less Non-Operating Expenses Interest on Revenue Bonds $ 17,445.00 $ 8,722.50 Transfer to Debt Service Fund - Interest - 7,650.00 $ 17,445.00 $ 16,372.50 Net Income (Less) (Pages 49 and 52) $ 417,482.00 $ (82,604.41) VILLAGE OF GLENVIEW, ILLINOIS WATERWORKS AND SEWERAGE FUND NUMBER ONE STATEMENT OF CHANGES IN RESTRICTED ACCOUNTS FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Depreciation, Bond Extension Principal and Bond and Interest Improvement Reserve Increases Interest Earned $ 12,261.52 $ 2,674.90 Transfers from Operations and Maintenance - Bond Requirements $ 8,722.50 24,000.00 5,000.00 - Other 4,950.00 Transfers From Waterworks and Sewerage Fund Number Two 75,000.00 4,950.00 Watermain Agreement 21,356.77 $ 8,722.50 $111,261.52 ~ 38,931.67 Decreases Transfers to Operations and Maintenance $ 8,722.50 Capital Outlay $ 28,402.95 Extraordinary Repairs and Replacements 8~436.20 $ 8,722.50 $ 36,839.15 - Net Increase - $ 74,422.37 $ 38,931.67 Account Balance May 1, 1979 - 30,424.08 232,742.02 December 31, 1979 (Page 48) - $104,846.45 $271,673.69 52 VILLAGE OF GLENVIEW, ILLINOIS WATERWORKS AND SEWERAGE FUND NUMBER ONE OPERATIONS AND MAINTENANCE ACCOUNT STATEMENT OF CHANGES IN FINANCIAL POSITION FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Cash Was Provided By Operations Net Loss (Page 50) $(82,604.41) Add Back Depreciation 44,526.33 $(38,078.08) Decrease in Accounts Receivable 61,706.24 Transfer Fixed Assets from Restricted Accounts 28,402.95 Decrease In Due From Other Funds 8,507.50 Increase In Accounts Payable 13,560.26 $ 74,098.87 Cash Was Used To Transfer To Restricted Accounts $ 29,000.00 Purchase Fixed Assets 42,888.95 Decrease in Due to Other Funds 151,596.15 Increase Interest Receivable 724.05 224,209.15 Net Increase (Decrease) $(150,110.28) Cash and Investments May 1, 1979 819,912.78 December 31, 1979 (Page 48) $ 669,802.50 54 VILLAGE OF GLENVIEW, ILLINOIS WATERWORKS AND SEWERAGE FUND NUMBER TWO BALANCE SHEET DECEMBER 31, 1979 ASSETS Current Assets Cash and Investments (Page 85) $ 6,054,535.46 Accounts Rsceivable - Billed and Unbilled 131,750.97 Interest Receivable 160,306.00 Fixed Assets (Page 58) Cost $4,428,088.83 Accumulated Depreciation 216,517.00 4,211,571.83 Construction in Progress 24,078.54 $10,582~242.80 LIABILITIES AND FUND EQUITY Liabilities Accounts Payable $ 35,713.34 Interest Payable 33,052.46 Due to Other Funds (Page 74) 150,000.00 $ 218,765.80 Fund Equity Contributions (Page 55) 10,075,000.00 Rstained Earnings (Page 55) 288,477.00 $10,582,242.80 The accompanying Notes to the Financial Statements are an integral part of all financial statements. VILLAGE OF GLENVIEW, ILLINOIS WATERWORKS AND SEWERAGE FUND NUMBER TWO STATEMENT OF CHANGES IN CONTRIBUTIONS AND RETAINED EARNINGS FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Retained Contributions Earnings Increases Net Income (Page 56) $302,880.80 Transfer from Waterworks and Sewerage Acquisition Fund $ 5,700,000.00 Decreases - Net Increase $ 5,700,000.00 $302,880.80 Account Balance May 1, 1979 4,375,000.00 (14,403.80) December 31, 1979 (Page 54) $10,075,000.00 $288,477.00 56 VILLAGE OF GLENVIEW~ ILLINOIS WATERWORKS AND SEWERAGE FUND NUMBER TWO STATEMENT OF INCOME AND EXPENSES - BUDGETED AND ACTUAL FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Budget Actual Operating Income Water and Sewer Charges $1,080,000.00 $598,861.86 Water Connection Charges 200,850.00 142,300.00 Water Meters and Remote Readers 61,311.00 22,015.00 Brass Fittings 3,000.00 1,143.00 Water for Construction 5,000.00 6,688.85 Turn on Charges 3,500.00 1,320.00 $1,353,661.00 $772,328.71 Operating Expenses Excluding Depreciation (Pages 111-112) Water Administration $ 366,667.00 $ 79,008.28 Waterworks Operations and Maintenance 49,546.00 76,317.75 Pumping Station 184,472.00 179,806.41 Distribution 50,496.00 61,046.87 Capital Outlay - 590.60 Special Projects - 3,215.18 $ 651,181.00 $399,985.09 Depreciation $ 702,480.00 $372,343.62 Net Operating Income before Depreciation - 61,738.00 Net Operating Income $ 702,480.00 $310,605.62 Add Non-Operating Income $ 41,500.00 $ 3,563.48 Miscellaneous Interest Earned 42,000.00 186,099.20 $ 83,500.00 $189,662.68 Less Non-Operating Expense Transfer to Debt Service Fund - Interest $ 117,438.00 $117,437.50 Fund Number One - Depreciation, Extension, and Improvements Account 75,000.00 75,000.00 - Bond and Interest Account 4~950.00 4,950.00 $ 197,388.00 $197,387.50 Net Income (Pages 55 and 57) $ 588,592.00 $302,880.80 VILLAGE OF GLENVIEW~ ILLINOIS WATERWORKS AND SEWERAGE FUND NUMBER TWO STATEMENT OF CHANGES IN FINANCIAL POSITION FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Cash Was Provided By Operations Net Income (Page 56) $302,880.80 Add Back Depreciation 61~738.00 $ 364,618.80 Decrease Due from Other Funds 117,437.50 Decrease in Accounts Rmceivable 19,075.55 Increase in Interest Payable 33,052.46 Increase in Contributions - Waterworks and Sewerage Acquisition Fund 5,700,000.00 Increase in Accounts Payable 35,713.34 $6,269,897.65 Cash Was Used To Purchase Fixed Assets $ 521,232.33 Decrease Due to Other Funds 270,292.90 Increase Interest Receivable 131,523.46 923,048.69 Net Increase (Decrease) $5,346,848.96 Cash and Investments May 1, 1979 707,686.50 December 31, 1979 (Page 54) $6,054,535.46 i I I ~ 0 ~ ~ ~ 0 VILLAGE OF GLENVIEW, ILLINOIS COMMUTER PARKING LOT FUND BALANCE SHEET DECEMBER 31, 1979 ASSETS Cash and Investments (Page 85) $42,177.68 Leasehold Improvements $106,513.71 Accumulated Amortization (66,538.06) 39,975.65 $82,153.33 RETAINED EARNINGS Retained Earnings (Page 60) $82,153.33 The accompanying Notes to the Financial Statements are an integral part of all financial statements. 6O VILLAGE OF GLENVIEW, ILLINOIS COMMUTER PARKING LOT FUND STATEMENT OF INCOME AND EXPENSE - BUDGETED AND ACTUAL AND CHANGES IN RETAINED EARNINGS FOR THE EIGHT MONTH ENDED DECEMBER 31, 1979 Budget Actual Ravenues Meter Fees - $35,132.75 Interest Earned - 1,368.24 $36,500.99 Expenditures Contractual and Professional Services - $ 7,773.66 Maintenance Materials 5,454.89 Rentals - 5,698.26 Improvements Other Than Buildings - 250.00 $19,176.81 Net Operating Income before Amortization $17,324.18 Provision for Amortization 4,013.40 Net Income (Page 61) $13,310.78 Retained Earnings May 1, 1979 68,842.55 December 31, 1979 (Page 59) $82,153.33 VILLAGE OF GLENVIEW~ ILLINOIS COM~fUTER PARKING LOT FUND STATEMENT OF CH~GES IN FINANCIAL POSITION FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Cash Was Provided By Operations Net Income (Page 60) $13,310.78 Add Back Depreciation 4,013.40 $17,324.18 Cash Was Used To Repay Advance from Corporate Fund 6,827.63 Net Increase in Cash and Investments $10,496.55 Cash and Investments May 1, 1979 31,681.13 December 31, 1979 (Page 59) $42,177.68 I I I I I I I I I I I I ! I I I I I I i I I I I I I I I I I I ! I I I I I I m o o ~'~, o', ~ ~ -.,-;-.~ '""-- "'"' ! ~ m oooo~o~ o ~ q~ I 64 VILLAGE OF GLENVIEW~ ILLINOIS POLICE PENSION FUND BALANCE SHEET DECEMBER 31, 1979 ASSETS Cash and Investments (Page 85) $1,641,322.28 Property Taxes Receivable - 1979 Levy $169,511.00 Allowance for Uncollectible Taxes 1,695.00 167,816.00 Replacement Taxes Receivable 6,080.00 $1,815,218.28 FUND BALANCE Fund Balance (Page 65) $1,815,218.28 The accompanying Notes to the Financial Statements are an integral part of all financial statements. VILLAGE OF GLENVIEW, ILLINOIS POLICE PENSION FUND STATEMENT OF REVENUES - ESTIMATED AND ACTUAL, EXPENDITURES - APPROPRIATED AND ACTUAL A~qD CHANGES IN FUND BALANCE FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Estimated Revenues or Appropriations Actual Rmvenues 1979 Tax Levy $ 95,998.00 $ 169,511.00 Provision for Uncollectible Taxes (1,695.00) $ 95,998.00 $ 167,816.00 Prior Year's Taxes (1,757.07) Replacement Taxes 6,080.00 Employees~ Contributions 5 1,543.48 Interest Income 81,500.00 47,539.09 Donations - Police Pension 75,000.00 100.00 Other - Budget Transfer 9,200.00 6,427.00 $261,698.00 $ 277,748.50 Expenditures Separation Refunds $ 35,250.00 $ 10,366.42 Pensions Paid 124,696.00 80,869.08 $159,946.00 $ 91,235.50 Excess of Revenues over Expenditures $101,752.00 $ 186,513.00 Fund Balance May 1, 1979 $(1,917,837.72) Prior Period A~justment Elimination of Unfunded Actuarial Deficiency 3,546,543.00 $ 1,628,705.28 December 31, 1979 (Page 64) $ 1,815,218.28 66 VILLAGE OF GLENVIEW, ILLINOIS FIREMEN'S PENSION FUN~ BALANCE SHEET DECEMBER 31, 1979 ASSETS Cash and Investments (Page 85) $1,048,008.52 Property Taxes Receivable - 1979 Levy $119,290.00 Allowance for Uncollectible Taxes 1,193.00 118,097.00 R~placement Taxes Receivable 4,274.00 $1,170,379.52 FUND BALANCE Fund Balance (Page 67) $1,170,379.52 The accompanying Notes to the Financial Statements are an integral part of all financial statements. VILLAGE OF GLENVIEW, ILLINOIS FIREMEN'S PENSION FUND STATEMENT OF REVEN-OES - ESTIMATED AND ACTUAL, EXPENDITURES - APPROPRIATED AND ACTUAL AND CHANGES IN FUND BALANCE FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Estimated Revenues or Appropriations Actual Rmvenues 1979 Tax Levy $ 67,554.00 $ 119,290.00 Provision for Uncollectible Taxes (1~193.00) $ 67,554.00 $ 118,097.00 Prior Year's Taxes (1,230.81) Replacement Taxes 4,274.00 Employees' Contributions 58,800.00 36,541.71 Interest Income 44,500.00 29,727.36 Foreign Fire Insurance Tax 12,000.00 18,283.32 Transfer From Corporate Fund 7,000.00 5,005.00 $189,854.00 $ 210,697.58 Expenditures Separation Refunds $ 13,000.00 $ 13,285.38 Pensions Paid 33,287.00 22,190.64 Miscellaneous 966.16 $ 46,287.00 $ 36,442.18 Excess of Revenues over Expenditures $143~567.00 $ 174,255.40 Fund Balance May 1, 1979 $ 132,952.12 Prior Year 3~ijustment Elimination of Unfunded Actuarial Deficiency 863,172.00 $ 996,124.12 December 31, 1979 (Page 66) $1,170,379.52 68 VILLAGE OF GLENVIEW, ILLINOIS ESCROW DEPOSIT FUND BALANCE SHEET DECEMBER 31, 1979 ASSETS Cash and Investments (Page 85) $1,926,249.89 LIABILITIES Refundable Deposits $1,798,033.55 Due to Other Funds (Page 74) 128,216.34 $1,926,249.89 The accompanying Notes to the Financial Statements are an integral part of all financial statements. VILLAGE OF GLENVIEW~ ILLINOIS ESCROW DEPOSIT FUND STATEMENT OF REVENUES AND EXPENDITURES FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Actual Interest Earned $128,216.34 Expenditures Transfer to Corporate Fund 128,216.34 Excess of Rmvenues over Expenditures ! I I I I I I I i I I I I I I I ACCOUNT GROUPS ! I ! I I I ! I i I I I I I ! I ! I I 7O VILLAGE OF GLENVIEW, ILLINOIS GENERAL FIXED ASSETS ACCOUNT GROUP DECEMBER 31, 1979 May 31, December 31, 1979 Additions Deletions 1979 GENERAL FIXED ASSETS Village Hall $ 384,740.41 $ 384,740.41 Parking Lot 202,943.59 $ 2,492.20 205,435.79 Library 1,410,097.47 34,292.32 1,444,389.79 Police and Fire Department 3,546,841.68 54,049.59 $3,554.00 3,597,337.27 Public Works Department 736,649.31 317,701.54 1,054,350.85 Transmitter Station 5,004.50 5,004.50 Sidewalks 96,433.92 96,433.92 Depot Street Land 110,000.00 110,000.00 Harmony Lane Land 4,676.00 4,676.00 Rmcycling Center 5,340.40 5,340.40 Butler Imnd 90,000.00 90,000.00 Rustive Manor Land 118,839.00 118,839.00 Techny Retention Basin 232,500.00 232,500.00 Public Works Garage 147,623.07 147,623.07 General Government Departments 10,293.38 4,995.90 1,315.00 13,974.28 Construction in Progress New Village Hall 102,756.96 868,806.69 971,563.65 New Public Works Garage 212,485.48 212,485.48 $7,417,225.17 $1,282,338.24 $4,869.00 $8,694,694.41 I I STATISTICAL SECTION I I 1 I I i i I I I I I I I i I i I I AUDITORS' REPORT- SUPPLEMENTARY DATA I I I ,! I ! ! ! I ! I I ! I I ! I 72 he Honorable ~omas E. Smith, President Members of the ~ard of ~ustees Village of Glenview, Illinois The accompanying financial information is presented for supplementary analysis purposes and is not considered necessary for a fair presen- tation of the basic financial statements. Our examination of the basic financial statements for the eight months ended ~cember 31, 1979, which are presented in the first section of this report, was made for the primary purpose of formulating an opinion on those statements. ~rrison & Byrne April 25, 1980 Bank of Wheaton Building · Z ] I South Wheaton Avenue · Wheaton, Illinois 60187 · (312) 665-4510 Geneva Professional O~ces · 206'~ West S~te Street · Geneva, Illinois 60134 · (31Z} 23Z-9404 I i ! I i ! I I i ! ! I ! I I I SUPPLEMENTARY DATA I I I 1 1 i ! I t '1 I I I I I i I I 73 VILLAGE OF GLENVIEW~ ILLINOIS SCHEDULE OF INTERFUND ACCOUNTS DECEMBER 31~ 1979 Due From Due To Corporate Waterworks and Sewerage Number Two $150,000.00 Library 101,563.00 Escrow Deposit 128,216.34 Public Works - Construction 98,907.42 Public Benefit $ 18,048.56 Motor Fuel Tax 29,618.20 $478,686.76 $ 47,666.76 Special Revenue Motor Fuel Tax Corporate $ 29,618.20 Library Corporate $101,563.00 Debt Service Village Hall Construction $ 38,348.75 Public Benefit Corporate $ 18,048.56 Special Assessment $ 9,046.05 $ 18,048.56 $ 9,046.05 Capital Projects Village Hall Construction Debt Service $ 38,348.75 Waterworks and Sewerage Fund Number One 100,000.00 $138,348.75 Public Works - Construction Corporate $ 98,907.42 Special Assessment Public Benefit $ 9,046.05 VILLAGE OF GLENVIEW, ILLINOIS SCHEDULE OF INTERFUND ACCOUNTS DECEMBER 31, 1979 Due From Due To Proprietary Fund Types - Enterprise Waterworks and Sewerage Number One Village Hall Construction $100,000.00 Waterworks and Sewerage Number Two Corporate $150,000.00 Escrow Deposit Corporate $128,216.34 $673,748.32 .$673,748.32 VILLAGE OF GLENVIEW, ILLINOIS STATEMENT OF LEGAL DEBT MARGIN DECEMBER 31, 1979 There is no legal debt limit for home rule municipalities in Illinois. Articletion of theVII' LegalSecti°nDebt6(k)Margin.°f the 1970 Illinois Constitution governs computa- "The General Assembly may limit by law the amount and require referendum approval of debt to be incurred by home rule municipalities, payable from ad valorem property tax receipts, only in excess of the following pircentages of the assessed value of its taxable property...(2) if its population is more than 25,000 and less than 500,000, an aggregate of one percent;... indebtedness which is outstanding on the effective date (July 1, 1971) of this constitution or which is thereafter approved by referendum...shall not be included in the foregoing percentage amounts." To date the General Assembly has set no limits for home rule municipalities. VILLAGE OF GLENVIEW, ILLINOIS LONG-TERM DEBT REQUIREMENTS POLICE ADMINSITRATION BUILDING BONDS OF 1972 DECEMBER 31, 1979 Date of Issue December 1, 1972 Date of Maturity January 1, 1990 Authorized Issue $1,400,000.00 Actual Issue $1,400,000.00 Denomination of ~onds $5,000.00 Interest Rate Bonds 1-280 - 7% Interest Dates July 1 and January 1 Principal Maturity Date January 1 Payable at Northern Trust CURRENT AND FUTURE BOND AND INTEREST REQUIREMENTS Tax Levy Tax Levy Coupons Due on Year Prinicpal Interest Total July 1 Amount Jan. 1 Amount $ 27,395.00 $ 27,395.00 1980 $27,395.00 1979 $ 95 000.00 50,740.00 145,740.00 1980 $25,370.00 1981 25,370.00 1980 100 000.00 46,465.00 146,465.00 1981 23,232.50 1982 23,232.50 1981 100 000.00 41,965.00 141,965.00 1982 20,982.50 1983 20,982.50 1982 110 000.00 37,465.00 147,465.00 1983 18,732.50 1984 18,732.50 1983 115 000.00 32,515.00 147,515.00 1984 16,257.50 1985 16,257.50 1984 120 000.00 27,225.00 147,225.00 1985 13,612.50 1986 13,612.50 1985 125 000.00 21,525.00 146,525.00 1986 10,762.50 1987 10,762.50 1986 125 000.00 15,587.00 140,587.00 1987 7,793.50 1988 7,793.50 1987 100 000.00 9,650.00 109,650.00 1988 4,825.00 1989 4,825.00 1988 100 000.00 4,900.00 104,900.00 1989 2,450.00 1990 2,450.00 $1~090,000.00 $315~432.00 $1,405,432.00 $ 95,000.00 $ 78,135.00 $ 173,135.00 - Current Portion - Debt Service Fund 995,000.00 237,297.00 1,232,297.00 - Long-Term Portion - General Long- Term Debt A~count Group $1,090,000.00 $315,432.00 $1,405,432.00 79 VILLAGE OF GLENVIEW, ILLINOIS LONG-TERM DEBT REQUIREMENTS PUBLIC LIBRARY PARKING LOT BONDS OF 1976 DECEMBER 31, 1979 Date of Issue July 1, 1976 Date of Maturity October 1, 1981 Authorized Issue $200,000.00 Denomination of Bonds 1 to 5 - $40,000.00 Interest Rate 5-1/8% Interest Dates October 1 and April 1 Principal Maturity Dates October 1 Payable at Northern Trust CURRENT AND FUTURE BOND ~LND INTEREST LEVY REQUIREMENTS Levy Tax Levy Coupons Due on Year Principal Interest Total Oct 1 Amount April 1 Amount 1978 $2,050.00 $ 2,050.00 1980 $2,050.00 1979 $ 40,000.00 3,075.00 43,075.00 1980 $2,050.00 1981 1,025.00 1980 40,000.00 1,025.00 41,025.00 1981 1,025.00 $ 80,000.00 $6,150.00 $ 86,150.00 $ 40,000.00 $5,125.00 $ 45,125.00 - Current Portion - Debt Service Funds 40,000.00 1,025.00 41,025.00 - Long-Term Portion - General Long- Term Debt Agcount Group $ 80,000.00 $6,150.00 $ 86,150.00 VILLAGE OF GLENVIEW, ILLINOIS LONG-TERM DEBT REQUIREMENTS CORPORATE PURPOSE BOND SERIES OF 1976 DECEMBER 31, 1979 l~.te of Issue September 1, 1976 Date of Maturity January 1, 1986 Authorized Issue $385,000.00 Actual Issue $385,000.00 Denomination of Bonds 1 to 77 - $5,000.00 Interest Rate Bonds 1 to 12 - 4.90% Bonds 13 to 47 - 4.60% Bonds 48 to 67 - 4.80% Bonds 68 to 77 - 4.90% Interest Dates January 1 and July 1 Principal Maturity Date January 1 Payable at The Northern Trust Company, Chicago, Illinois Bond Redeemable Annually on Numbers January 1 Amount 29-37 1982 45,000.00 $ 45,000.00 38-77 1983-86 50,000.00 200,000.00 $245,000.00 FUTURE BOND AND INTEREST REQUIREMENTS Levy Tax Levy Coupons Due on Year Principal Interest Total July i Amount Jan. 1 Amount 1980 $ 45,000.00 $11,620.00 $ 56,620.00 1981 $5,810.00 1982 $5,810.00 1981 50,000.00 9,550.00 59,550.00 1982 4,775.00 1983 4,775.00 1982 50,000.00 7,250.00 57,250.00 1983 3,625.00 1984 3,625.00 1983 50,000.00 4,850.00 54,850.00 1984 2,425.00 1985 2,425.00 1984 50,000.00 2,450.00 52,450.00 1985 1,225.00 1986 1,225.00 $245,000.00 $35,720.00 $280,720.00 - Long-Term Portion - General Long- Term Debt Account Group Note: 1979 Tax Levy was abated by ord±nanee #2289° The principal and interest will be paid by Waterworks and Sewerage Fund I. 83 VILLAGE OF GLENVIEW, ILLINOIS LONG-TERM DEBT REQUIREMENTS MUNICIPAL BUILDING BONDS, SERIES 1979 DECEMBER 31, 1979 Date of Issue April 1, 1979 Date of Maturity January 1, 1991 Authorized Issue $950,000.00 Actual Issue $950,000.00 Denomination of Bonds 1 - 190 - $5,000.00 Interest Rates Bonds 1 - 70 - 5.30% Bonds 71 - 160 - 5.40% Bonds 161 - 190 - 5.50% Interest Dates July 1 and January 1 Principal Maturity Date January 1 Payable at Amalgamated Trust and Savings Bank Chicago, Illinois Bond Redeemable Annually on Numbers January 1 Amount 1-30 1982-84 $ 50,000.00 $150,000.00 31-130 1985-89 100,000.00 500,000.00 131-190 1990-91 150,000.00 300,000.00 $950,000.00 CURRENT AND FUTURE BOND AND INTEREST REQUIREMENTS Levy Tax Levy Coupons Due on Year Prinicpal Interest Total July 1 Amount Jan. 1 Amount $ 38,250.00 *$ 38,250.00 1980 $38,250.00 1979 51,100.00 * 51,100.00 1980 $25,550.00 1981 25,550.00 1980 $ 50,000.00 51,100.00 101,100.00 1981 25,550.00 1982 25,550.00 1981 50,000.00 48,450.00 98,450.00 1982 24,225.00 1983 24,225.00 1982 50,000.00 45,800.00 95,800.00 1983 22,900.00 1984 22,900.00 1983 100,000.00 43,150.00 143,150.00 1984 21,575.00 1985 21,575.00 1984 100,000.00 37,850.00 137,850.00 1985 18,925.00 1986 18,925.00 1985 100,000.00 32,550.00 132,550.00 1986 16,275.00 1987 16,275.00 1986 100,000.00 27,150.00 127,150.00 1987 13,575.00 1988 13,575.00 1987 100,000.00 21,750.00 121,750.00 1988 10,875.00 1989 10,875.00 1988 150,000.00 16,350.00 166,350.00 1989 8,175.00 1990 8,175.00 1989 150~000.00 8,250.00 158,250.00 1990 4,125.00 1991 4,125.00 $ 950,000.00 $421,750.00 $1,371,750.00 $ - $ 89,350.00 $ 89,350.00 - Current Portion - Debt Service Fund 950,000.00 332,400.00 1,282~400.00 - Long-Term Portion - General Long-Term Debt Account Group $ 950,000.00 $421,750.00 $1~371,750.00 * Three interest payments 1979 levy year only. VILLAGE OF GLENVIEW~ ILLINOIS SCHEDULE OF INVESTMENTS AND SAVINGS DECEMBER 31~ 1979 Maturity Rate Due Date Amount Corporate Fund Passbook - Glenview State Bank - Commingled Account 5.250 $ (518,270.32) Certificates of Deposit Gienview State Bank 13.600 6/29/80 100,000.00 Glenview State Bank 10.125 1/07/80 100,000.00 Glenview Guaranty Savings and Loan 14.000 6/05/80 250,000.00 Glenview Guaranty Savings and Loan 13.500 12/13/79 150,000.00 Glenview Guaranty Savings and Loan 12. 750 3/20/80 119,677.39 Glenview Guaranty Savings and Loan 12. 250 3/25/80 100,000.00 Cragin Federal 1 1.000 1/28/80 100,000.00 Cragin Federal 10.050 1/03/80 100,000.00 Cragin Federal 14.500 5/02/80 100,000.00 $ 601,407.07 Special Revenue Funds Library Fund Passbook - Glenview State Bank 5.250 - $ 190,925.19 Certificate of Deposit Glenview State Bank 14.575 1/30/80 140,000.00 $ 330,925.19 Federal Revenue Sharing Fund Passbook - Glenview State Bank - Commingled Account 5.250 - $ (68,695.15) Illinois Municipal Rmtirement Fund Passbook - Glenview State Bank - 5.250 - $ 131,994.05 Commingled Account Motor Fuel Tax Fund Passbook - Glenview State Bank 5.250 - $ 153,078.31 Certificates of Deposit Glenview State Bank 10.000 1/07/80 100,000.00 Glenview State Bank 10.000 1/07/80 100,000.00 Glenview State Bank 10.000 1/07/80 100,000.00 Glenview State Bank 1 1.200 2/28/80 100,000.00 Glenview State Bank 14.500 4/30/80 100,000.00 Glenview State Bank 13.125 6/17/80 100,000.00 87 VILLAGE OF GLENVIEW, ILLINOIS SCHEDULE OF INVESTMENTS AND SAVINGS DECEMBER 31, 1979 Maturity Rate Due Date Amount Special Revenue Funds (Cont.) Motor Fuel Tax Fund (Cont.) Certificates of Deposit (Cont.) Glenview Guaranty Savings and Loan 14.750 5/05/80 $ 100,000.00 Glenview Guaranty Savings and Loan 14.000 5/30/80 100,000.00 Glenview Guaranty Savings and Loan 14.000 6/04/80 100,000.00 $ 1,053,078.31 Debt Service Fund Passbook - Glenview State Bank - Commingled Account 5.250 $ 500,752.89 Capital Projects Fund Village Hall Construction Fund Passbook - Glenview State Bank 5.250 $ 157,022.15 Certificates of Deposit Glenview State Bank 13.000 6/03/80 100,000.00 Glenview State Bank 11.200 2/28/80 100,000.00 Glenview State Bank 13.375 3/17/80 200,000.00 Glenview State Bank 13.375 4/17/80 200,000.00 Glenview Guaranty Savings and Loan 12.500 1/02/80 100,000.00 $ 857,022.15 Public Works Garage Fund Passbook~- Glenview State Bank 5.250 $ 16,234.04 Certificates of Deposit Glenview Guaranty Savings and Loan 10.375 4/22/80 100,000.00 Cragin Federal 8.750 7/17/80 170,000.00 Cragin Federal 11.450 2/29/80 100,000.00 $ 386,234.04 VILLAGE OF GLENVIEW~ ILLINOIS SCHEDULE OF INVESTMENTS AND SAVINGS DECEMBER 31, 1979 Maturity Rate Due Date Amount Special Assessment Fund Passbook - 1st Trust and Savings Bank of Glenview 5.250 - $ 97,890.75 Certificate of Deposit Cragin Federal 10.375 3/14/80 225,000.00 $ 322,890.75 Enterprise Funds Water and Sewer Operating Fund I Passbook - Glenview State Bank - Commingled Account 5.250 $ 119,702.50 Certificates of Deposit Glenview State Bank 11.200 2/28/80 250,000.00 Glenview State Bank 14.500 4/30/80 200,000.00 Glenview Guaranty Savings and Loan 14.000 5/26/80 100,000.00 $ 669,702.50 Water and Sewer Depreciation Passbook - Glenview State Bank - Commingled Account 5.250 - $ (4,938.16) Water and Sewer - Principal, Interest and Reserve Passbook - Glenview State Bank 5.250 $ 381,358.30 Water and Sewer Operating Fund II Passbook - Glenview State Bank 5.250 $ (74,258.98) Certificates of Deposit Glenview State Bank 14.375 1/02/80 200,000.00 Glenview State Bank 14.575 2/01/80 175,000.00 Glenview State Bank 14.375 3/01/80 1,000,000.00 Glenview State Bank 14.375 4/01/80 1,000,000.00 Glenview State Bank 14.500 5/01/80 1,200,000.00 Glenview State Bank 14.375 6/02/80 2,000,000.00 Glenview State Bank 12.875 7/01/80 150,000.00 Glenview Guaranty Savings and Loan 12.250 3/25/80 100,000.00 Cragin Federal 13.750 5/30/80 200,000.00 Cragin Federal 11.450 2/29/80 103,694.44 $ 6,054,435.46 Commuter Parking Lot Fund Passbook - Glenview State Bank 5.250 - $ 42,077.68 89 VILLAGE OF GLENVIEW, ILLINOIS SCHEDULE OF INVESTMENTS AND SAVINGS DECEMBER 31, 1979 M~turity Rate Due Date Amount Trust and Agency Funds Police Pension Fund - Glenview State Bank 5.250 - 59,502.62 Passbook $ Certificates of Deposit Glenview Guaranty Savings and Loan 13.250 125,000.00 Glenview Guaranty Savings and Loan 14.000 7/21/80 100,000.00 Cragin Federal 10.375 7/17/80 100,000.00 U.S. Treasury Bonds - Harris Trust 6.375 8/15/84 40,687.50 U.S. Treasury Bonds - Harris Trust 6.375 8/15/84 29,100.00 U.S. Treasury Bonds - Harris Trust 8.500 5/15/99 53,464.50 U.S. Treasury Bonds - Harris Trust 6.125 11/15/86 92,265.00 U.S. Treasury Bonds - Harris Trust 6.750 2/15/93 90,515.00 U.S. Treasury Bonds - Harris Trust 8.250 5/15/90 136,175.55 U.S. Treasury Bonds - Harris Trust 8.375 8/15/99 243,242.19 U.S. Treasury Notes - Harris Trust 7.625 2/15/81 97,187.50 U.S. Treasury Notes - Harris Trust 8.000 5/15/82 90,040.00 U.S. Treasury Notes - Harris Trust 7.375 8/15/81 99,951.00 U.S. Treasury Notes - Harris Trust 7.875 5/15/86 284,109.38 $ 1,641~240.24 Fire Pension Fund Passbook - Glenview State Bank 5.250 - $ 93,160.40 Passbook - Glenview Guaranty Savings and Loan 5.500 - 1,478.73 Certificates of Deposit Glenview State Bank 13.125 6/11/80 100,000.00 Cragin Federal 10.200 5/18/80 100,000.00 Cragin Federal 10.675 3/07/80 100,000.00 U.S. Treasury Bonds - Harris Trust 7.000 8/15/81 36,192.81 U.S. Treasury Bonds - Harris Trust 6.375 8/15/84 24,529.45 U.S. Treasury Bonds - Harris Trust 6.375 8/15/84 10,000.00 U.S. Treasury Bonds - Harris Trust 8.500 5/19/99 134,392.70 U.S. Treasury Bonds - Harris Trust 8.375 8/15/99 145,945.31 U.S. Treasury Notes - Harris Trust 7.625 8/15/81 97,593.31 U.S. Treasury Notes - Harris Trust 7.875 5/15/86 154,715.81 U.S. Treasury Notes - Harris Trust 7.250 2/15/84 50,000.00 $ 1,048,008.52 VILLAGE OF GLENVIEW~ ILLINOIS SCHEDULEDECEMBER OF INVESTMENTS 31, 1979 AND SAVINGS Maturity Rate Due Date A~ount Trust and Agency Funds (Cont.) Escrow Deposit Fund Passbook - Harris Bank and Trust 5.250 - $ 376,249.89 Certificates of Deposit Glenview State Bank 10.000 1/07/80 200,000.00 Glenview State Bank 10.125 1/30/80 300,000.00 Glenview State Bank 10.125 1/30/80 300,000.00 Glenview State Bank 13.250 6/13/80 500,000.00 Glenview Guaranty Savings and Loan 10.500 2/04/80 250,000.00 $ 1,926,249.89 $15,873,743.73 (Pgae 85) 91 VILLAGE OF GLENVIEW, ILLINOIS CORPORATE FUND STATEMENT OF P, EVENUES - ESTIMATED AND ACTUAL FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Estimated Actual Licenses Motor Vehicle $143,000.00 $262,387.75 Bicycle 150.00 50.00 Business 38,500.00 19,741.88 Liquor 43,000.00 34,229.15 Dog 10,500.00 1,469.50 Cat 1,100.00 247.00 $236,250.00 $318,125.28 Permits HVAC $ 1,000.00 $ 735.00 Buildings 50,000.00 118,452.81 Electrical Inspection 18,000.00 44,202.55 Plumbing and Sewer 13,800.00 29,380.00 Driveway 350.00 762.00 Engineering 40,000.00 52,494.83 Unclassified Public Works Service 5,000.00 8,173.17 Other Current Service Charges 20,000.00 16,238.99 Special Assessment - Corporate Only - $148,150.00 $270,439.35 I 102 I I 103 ! i ~ oooooooo I 104 I I 105 VILLAGE OF GLENVIEW, ILLINOIS WATERWORKS AND SEWERAGE FUND NUF~ER ONE OPERATIONS AND MAINTENANCE STATEMENT OF EXPENDITURES - BUDGETED AND ACTUAL FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Budget Actual Water Administration Postage $ 1,800.00 $ 1,834.92 Dues and Subscriptions 100.00 100.00 Maintenance of Equipment 10.00 Travel 20.00 3.90 Training 250.00 175.16 Office Supplies 250.00 500.69 Illinois Municipal Retirement Fund Payments 13,000.00 12,408.00 Transfer to Corporate for Administrative Services 75,000.00 46,716.00 Other Operating Expenses 86,800.00 15.30 Books and Pamphlets 50.00 Computer Supplies 3,000.00 489.72 Payment on Bonds 50,000.00 Transfer to Bond Reserve Account - 4,950.00 $247,725.00 $ 67,193.69 Waterworks Operations and Maintenance Regular Salaries $ 40,456.00 $ 40,494.01 Overtime Salaries 440.00 38.52 Contractual Professional Services 5,000.00 - Water 500,000.00 462,206.32 Uniforms 920.00 2,444.12 Gasoline 3,900.00 3,290.20 Motor Vehicle Supplies 200.00 195.96 $550,916.00 $508,669.13 109 VILLAGE OF GLENVIEW~ ILLINOIS WATERWORKS AND SEWERAGE FUND NUMBER ONE OPERATIONS AND MAINTENANCE STATEMENT OF EXPENDITURES - BUDGETED AND ACTUAL FOR THE EIGHT MONTHS ENDED DECEMBER 31~ 1979 Budget Actual Pumping Station Regular Salaries $ 14,744.00 $ 13,744.00 2,500.00 2,688.95 Overtime Salaries Contractual Professional Services 1,200.00 1,892.50 Power and Light 20,000.00 19,915.39 Heating 600.00 1,144.29 Telephone 700.00 801.05 Maintenance of Building and Improvements 800.00 51,212.49 Rmntal 96.00 32.64 Cleaning and Household Supplies 32.00 44.88 Maintenance Materials - Equipment 2,600.00 358.80 Maintenance Materials - Building and Improvements 300.00 57.21 Operating Materials and Supplies 920.00 1,09 1.22 Building and Improvements - 1,488.21 Machinery and Equipment 27~428.00 5~566.00 $ 71,920.00 $100,037.63 Less Capital Outlay Expenses Capitalized 5,566.00 $ 71,920.00 $ 94,471.63 Distribution System Regular Salaries $ 30,450.00 $ 30,230.71 Overtime Salaries 7,000.00 3,127.33 Temporary Salaries 5,000.00 4,416.75 Maintenance of Equipment - Services 500.00 810.85 Maintenance of Buildings and Improvements - Services 2,000.00 5,003.60 Rental - 132.00 Maintenance Materials - Equipment 1,000.00 4,550.05 Maintenance Materials - Building and Improvements 9,000.00 10,095.97 Small Tools and Equipment 720.00 1,075.30 Operating Materials and Supplies 10,000.00 8,825.96 Machinery and Equipment 9,570.00 1,237.56 Hydrant Locations Signs 2,500.00 2,742.71 Automotive Equipment 17~000.00 11,800.00 $ 94,740.00 $ 84,048.79 Less Capital Outlay Expenses Capitalized 7,900.00 $ 94,740.00 $ 76,148.79 110 VILLAGE OF GLENVIEW, ILLINOIS WATERWORKS AND SE~fERAGE FUND NUMBER ONE OPERATIONS AND MAINTENANCE STATEMENTS OF EXPENDITURES - BUDGETED AND ACTUAL FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Budget Acutal Sewer Operations and Maintenance Regular Salaries $36,272.00 $36,272.00 Overtime Salaries 700.00 254.01 Contractual Professional Services 5,425.00 10,825.17 Rental 50.00 50.00 Fuel 750.00 550.00 Training 100.00 Motor Vehicles Supplies 150.00 Maintenance Materials - Equipment and Auto Repair 3,000.00 2,362.72 Operating Materials and Supplies 3,000.00 826.43 Machinery and Equipment 3,995.00 1,250.30 $53,442.00 $52,390.63 Less Capital Outlay Expenses Capitalized 1,020.00 $53,442.00 $51,370.63 Lift Station Maintenance and Improvements $ 75.00 $ 378.16 Maintenance Materials - Repair Parts 200.00 217.82 $ 275.00 $ 595.98 Special Projects Water/SPL Project - Club Circle $42,000.00 - Water/SPL Project - Ltnneman Water Main 6,000.00 - $48,000.00 - 111 VILLAGE OF GLENVIEW~ ILLINOIS WATERWORKS AND SEWERAGE FUND NUMBER TWO STATEMENT OF EXPENDITURES BUDGETED AND ACTUAL FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Budget Actual Water Administration Postage $ 1,600.00 $ 2,159.30 Dues and Subscriptions 100.00 100.00 Maintenances of Equipment 10.00 Travel 20.00 20.02 Training 250.00 175.16 Office Supplies 250.00 500.70 Social Security Illinois Municipal Retirement Fund 13,000.00 12,408.00 Transfer to Corporate Fund 62,500.00 40,601.00 Other Operating Expenses 483,300.00 22,778.10 Books/Pamphlets 25.00 6.93 Computer Supplies 3,000.00 259.07 $564~055.00 $ 79,008.28 Waterworks Operations and Maintenance Regular Salaries $ 20,536.00 $ 18,193.28 Overtime Salaries 400.00 117.36 Contractual Professional Services 15,000.00 21,397.76 Water 10,000.00 32,966.46 Uniforms 660.00 816.78 Gasoline 2,750.00 2,676.11 Motor Vehicle Supplies 200.00 150.00 $ 49~546.00 $ 76,317.75 VILLAGE OF GLENVIEW~ ILLINOIS I WATERWORKS AND SEWERAGE FUND NUMBER TWO STATEMENT OF EXPENDITURES BUDGETED AND ACTUAL I FOR THE EIGHT MONTHS ENDED DECEMBER 31, 1979 Budget Actual I Pumping Station Regular Salaries $ 14,432.00 $ 14,441.69 Overtime Salaries 10,000.00 9,200.51 · Contractual Professional Services 980.00 968.34 Power and Light 75,000.00 87,426.14 Heating 300.00 1,208.25 · Telephone 600.00 682.21 Maintenance of Building and Improvements 78,000.00 63,947.02 Rmntal 90.00 and Household Supplies 30.00 72.11 · Cleaning Maintenance Materials - Equipment 1,750.00 386.39 Maintenance Materials - Buildings and Improvements 990.00 334.58 · Operating Materials and Supplies 2,300.00 1,139.17 Machinery and Equipment 2,400.00 1,499.00 $186,872.00 $181,305.41 I Less Capital O~tlay Expenses Capitalized 2,400.00 1~499.00 $184,472.00 $179,806.41 Distribution System Regular Salaries $ 20,072.00 $ 19,199.18 I Overtime Salaries 7,610.00 8,901.42 I Temporary Salaries 9,214.00 8,825.43 Maintenance of Equipment - Services 340.00 431.49 · Maintenance of Buildings and Improvements 1,000.00 195.00 Maintenance Materials - Equipment 2,000.00 2,973.02 Maintenance Materials - Building and II Improvements 9,500.00 14,111.07 Small Tools and Equipment 760.00 1,268.23 Operating Materials and Supplies 7,000.00 19,680.77 Hydrant Location - Signs 2,726.16 I $ 57,496.00 $ 78,311.77 Less Capital Outlay Expenses Capitalized 7,000.00 17,264.90 ~ 50,496.00 $ 61~046.87 · Capital Outlay Machinery and Equipment $ 9,641.60 Automotive Equipment 371.00 $ 10,012.60 I Less Capital Outlay Expenses Capitalized - 9~422.00 $ 590.60 Special Projects i Three Interconnnections $ 15,500.00 $ 11,088.72 Countryside Watermain 100,000.00 164,380.27 Zenith Watermain 110,000.00 115,953.76 · Valve Replacement 6,697.35 I Watermain T~anamission - 222~220.05 $225,500.00 $520,340.15 I Less Capital Outlay Expenses Capitalized 225,500.00 517,124.97 · - $ 3,215.18