Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Village CAFR For Year Ended April 30, 1988 (2)
jT aor t�k �mf, E a-a0m SM&MCDUL, ME D OMS 1 i COMPREHENSIVE � ANNUAL � FINANCIAL REPORT 11 FOR THE FISCAL YEAR ENDED APRIL 30, 1988 PREPARED BY GEORGE J: VALENTINE FINANCE DIRECTOR VILLAGE OF DEERFIELD, ILLINOIS 1 1 1 I 1 1 VILLAGE OF DEERFIELD, ILLINOIS COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE YEAR ENDED APRIL 30, 1988 1 1 Prepared by Finance Department George Valentine Director of Finance 1� TABLE OF CONTENTS PAGE INTRODUCTORY SECTION Principal Officials i Organizational Chart Certificate of Achievement for Excellence in Financial Reporting iii Letter of Transmittal iv-x FINANCIAL SECTION AUDITOR'S REPORT ON THE FINANCIAL STATEMENTS 1-2 GENERAL PURPOSE FINANCIAL STATEMENTS Combined Balance Sheet - All Fund Types and Account Groups 3 Combined Statement of Revenues, Expenditures, and Changes in Fund Balances - All Governmental and Fiduciary (Expendable Trust) Fund Types 4 Combined Statement of Revenues, Expenditures, and Changes in Fund Balances - Budget and Actual - General, Special Revenue, and Debt Service Fund Types 5 Combined Statement of Revenues, Expenses, and Changes in Retained Earnings/Fund Balances - All Proprietary and Fiduciary (Pension Trust) Fund Types 6 Combined Statement of Changes in Financial Position All Proprietary and Fiduciary (Pension Trust) Fund Types 7 Notes to the Financial Statements 8-52 FINANCIAL STATEMENTS OF INDIVIDUAL FUNDS GOVERNMENTAL FUND TYPES GENERAL FUND General Fund Financial Statements Balance Sheet 53 Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual 54 TABLE OF CONTENTS (CONT.) FINANCIAL SECTION (CONT.) GOVERNMENTAL FUND TYPES (CONT.) GENERAL FUND (CONT.) Supplemental Schedules Schedule of Revenues - Budget .and Actual Schedule of Expenditures - Budget and Actual SPECIAL REVENUE FUNDS All Funds Financial Statements Combining Balance Sheet Combining Statement of Revenues, Expenditures, and Changes in Fund Balances Municipal Audit Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual Emergency Services/Disaster Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual Youth Bound Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual Library Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual Supplemental Schedules Schedule of Expenditures - Budget and Actual PAGE 55 56-5 8 59 60 61 62 63 64 65 1 1 1 1 1 TABLE OF CONTENTS (CONT. FINANCIAL SECTION (CONT. GOVERNMENTAL FUND TYPES (CONT.) SPECIAL REVENUE FUNDS (CONT.) Street and Bridge Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual Supplemental Schedules Schedule of Expenditures - Budget and Actual Illinois Municipal Retirement Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual Public Benefit Fund Financial Statements Statement of Revenues, Expenditures`, and Changes in Fund Balance - Budget and Actual Federal Revenue Sharing Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual Motor Fuel Tax Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual Transportation Fund Financial Statements Statement of Revenues,, Expenditures, and Changes in Fund Balance - Budget and Actual 1 PAGE C'�el 67-71 72 73 W 75 76 TABLE OF CONTENTS (CONT.) FINANCIAL SECTION (CONT.) GOVERNMENTAL FUND TYPES (CONT.) DEBT SERVICE FUND Debt Service . Fund Financial Statements Balance Sheet Statement of Reveues, Expenditures, and Changes in Fund Balance - Budget and Actual Supplemental Schedules Schedule of Expenditures - Budget and Actual. CAPITAL PROJECTS FUNDS All Funds Financial Statements Combining Balance Sheet Combining Statement of Revenues, Expenditures, and Changes in Fund Balances SPECIAL ASSESSMENT FUNDS Special Assessment Funds All Funds . Financial Statements Combining Balance Sheet Combining Statement of Revenues, Expenditures, and Changes in Fund Balances PROPRIETARY FUND TYPES ENTERPRISE FUNDS All Funds Financial Statements Combining Balance Sheet Combining Statement of Changes in Contributed Capital Combining Statement of Revenues, Expenses, and Changes in Retained Earnings - Unreserved Combining Statement of Changes in Financial Position PAGE 77 78 79 0 82 83 84 85 86 87 1 1 f t r TABLE OF CONTENTS (CONT.) PAGE FINANCIAL SECTION (CONT.) PROPRIETARY FUND TYPES (CONT.) ENTERPRISE FUNDS (CONT.) Water Fund Financial Statements Balance Sheet 88 Statement of Changes in Retained Earnings - Reserved - Restricted Accounts 89 Statement of Revenues, Expenses, and Changes in Retained Earnings - Unreserved - Budget and Actual 90 Supplemental Schedules Schedule of Operating Expenses - Budget and Actual 91-93 Schedule of Fixed Assets and Depreciation 94 Sewerage Fund Financial Statements Balance Sheet 95 Statement of Revenues, Expenses, and Changes in Retained Earnings - Unreserved - Budget and Actual 96 Supplemental Schedules Schedule of Operating Expenses - Budget and Actual 98-99 Schedule of Fixed Assets and Depreciation 100 Refuse Fund Financial Statements Balance Sheet 101 Statement of Revenues, Expenses, and Changes in Retained Earnings - Budget and Actual 102 Commuter Parking Lot Fund Financial Statements Balance Sheet 103 Statement of Revenues, Expenses, and Changes in Retained Earnings - Budget and Actual 104 Supplemental Schedules Schedule of Operating Expenses - Budget and Actual 105 Schedule of Fixed Assets and Depreciation 106 TABLE OF CONTENTS (CONT.) PAGE FINANCIAL SECTION (CONT.) PROPRIETARY FUND TYPES (CONT.) INTERNAL SERVICE FUND Garage Fund Financial Statements Balance Sheet 107 Statement of Revenues, Expenses, and Changes in Retained Earnings - Budget and Actual 108 Statement of Changes in Financial Position 109 Supplemental Schedules Schedule of Operating Expenses - Budget and Actual 110 FIDUCIARY FUND TYPES TRUST AND AGENCY FUNDS All Funds Financial Statements Combining Balance Sheet 111 Statement of Revenues, Expenditures and Changes in Fund Balance (Expendable Trust) 112 .Statement of Revenues, Expenses, and Changes in Fund Balance - Budget and Actual (Pension Trust Fund) 113 Statement of Changes in Financial Position (Pension Trust Fund) 114 Combining Statement of Changes in Assets and Liabilities (Agency Funds) 115 ACCOUNT GROUPS GENERAL FIXED ASSETS ACCOUNT GROUP Supplemental Schedules Schedule of General Fixed Assets 116 Schedule of General Fixed Assets - By Function and Activity 117 Schedule of Changes in General Fixed Assets - By Function and Activity 118 1 1 1 t 1 1 1 TABLE OF CONTENTS (CONT.) PAGE FINANCIAL SECTION (CONT.) ACCOUNTS GROUPS (CONT.) GENERAL LONG-TERM DEBT ACCOUNT GROUP Supplemental Schedules Schedule of General Long -Term Debt 119 SUPPLEMENTARY DATA Required Supplementary Information Analysis of Funding Progress - Illinois Municipal Retirement 120 - Police Pension 121 Revenues by Source - Illinois Municipal Retirement 122 Revenues by Source and Expenses by Type - Police Pension 123 Long -Term Debt Requirements Sewerage Improvement Bond Series of 1973 124 Sewerage Treatment Facilities Bond Series of 1973 125 Corporate Purpose Bond Series of 1982 126 Corporate Purpose Bond Series of 1982-A 127 Corporate Purpose Bond Series of 1983 128. Corporate Purpose Bond Series of 1987 129 Corporate Purpose Bond Series of 1986 130 Water Revenue Bond Series of 1960 131 Water Revenue Bond Series of 1959 132 Schedule of Officer's Deposits (Police Pension Fund) 133 Schedule of Insurance in Force 134 STATISTICAL SECTION General Governmental Expenditures by Function - Last Ten Fiscal Years 135 General Governmental Revenues By Source - Last Ten Fiscal Years 136 Property Tax Assessed Valuations, Rates, Extensions and Collections - Last Ten Fiscal Years 137 Assessed and Estimated Actual Values of Taxable Property - Last Ten Fiscal Years 138 TABLE OF CONTENTS (CONT.) PAGE STATISTICAL SECTION (CONT.) Property Tax Rates - All Overlapping Governments Last Ten Fiscal Years 139 Special Assessment Collections - Last Ten Fiscal Years 140 Ratio of Net General Bonded Debt to Assessed Value and Net Bonded Debt Per Capita - Last Ten Fiscal Years 141 Schedule of Legal Debt Margin 142 Schedule of Direct and Overlapping Debt 143 Ratio of Annual Debt Service Expenditures for General Bonded Debt to Total General Governmental Expenditures - Last Ten Fiscal Years 144 Schedule of Revenue Bond Coverage - Water and Sewer Bonds - Last Ten Fiscal Years 145 Demographic Statistics - Last Ten Fiscal Years 146 Property Value, Construction, and Bank Deposits - Last Ten Fiscal Years 147 Principal Taxpayers 148 Miscellaneous Statistics 149 j 1 � Introductory Section. 1 LI I I rl �J 11 1 VILLAGE OF DEERFIELD, ILLINOIS PRINCIPAL OFFICIALS APRIL 30, 1988 LEGISLATIVE VILLAGE BOARD OF TRUSTEES Bernard Forrest, President Harriet E. Rosenthal Edwin B. Seidman James L. Marovitz Vernon E. Swanson Cynthia J. Marty J. Robert York Naomi S. Clampitt, Clerk ADMINISTRATIVE Robert D. Franz, Village Manager FINANCE DEPARTMENT George J. Valentine, Director of Finance/Treasurer i Cl) Z U) 0 } W W Z .. Q � m2 0 J J O >Q U I�Cl) U mH CW'3W m �� m a 0` ;z >� o 2 Y Wcr- W J U �¢ W ~ cn N Q Z N J � ¢ c) 0 Y Z cc .7 (IJ N W ( z =C � z O 3 W CD F- W J¢ f¢ �/ o"" W `z J� LU F- n� N LLJ -. 0 Qp 3 Iz I ~ Q Z W W ~U- Q J ¢ + z O z m O U a Z � W J � z U Z C7 � ►- �w J W J J C7 Z ~ Z m N W ¢� O ¢ O 0 LLJ CC Z F- Qj LL W Qj a N Z O N Z C ►' O Z U ¢ ¢ o g of _ = O Q F- O Z O ¢ O a Q. Ul r = W W LAJ LLI N W C �CD ii 1 I 1 I i1 fJ Certificate of Achievement for Excellence in Financial Reporting Presented to Village of Deerfield, Illinois For its Comprehensive Annual Financial Report for the Fiscal Year Ended April 30, 1987 A Certificate of Achievement for Excellence in Financial Reporting is presented by the Government Finance Officers Association of the United States and Canada to government units and public employee retirement systems whose comprehensive annual financial reports (CAFRs) achieve the highest standards in government accounting and financial reporting. -, = --� (! f , e'-4 � � � iii President e�Z'C: V' Executive Director P-J PJ F� L EERFIELD, 945.5000 ILLINOIS 850 WAUKEGAN ROAD • DEERFIELD, ILLINOIS 60015 November 15, 1988 Mr. Robert Franz, Village Manager Village of Deerfield Deerfield, Illinois 60015 Dear Mr. Franz: The Comprehensive Annual Financial Report of the Village of Deerfield for the fiscal year ending April 30 1988, is submitted herin. This report was prepared by the Village Finance Department. Responsibility for both the accuracy of the presented data and the completeness and fairness of the presentation, including all disclosures, rests with the Village. The organization and content of this report, including the financial statements, exhibits, and statistical tables, follow the standards for financial reporting recommended by the National Council on Governmental Accounting and its successor, the Governmental Accounting Standards Board. I believe that the data, as presented, is accurate in all material aspects, that it is presented in a manner designed to fairly set forth the financial position and results of operations of the Village as measured by the financial activity of its various funds, and that all disclosures necessary to enable the reader to gain the maximum understanding of the Village's financial affairs have been included. Accounting System and Budgetary Control In developing and evaluating the Village's accounting system, consideration is given to the adequacy of internal accounting controls. Internal accounting controls aredesigned to provide reasonable, but not absolute, assurance regarding: (1) the safeguarding of assests against financial loss from unauthorized use or disposition, and (2) the reliability of financial records for preparing financial statements and maintaining accountability for assets. The concept of reasonable assurance recognizes that: (1) the cost of a control should not exceed the benefits likely to be derived from it, and (2) the evaluation of costs and benefits requires estimates and judgements by management. All internal control evaluations occur within the above framework. I believe that the Village's internal accounting controls adequately iv 1 safeguard assets and provide reasonable assurance of proper recording of financial transactions. ' Budgetary control is maintained at the departmental and subdeparmental level through a system of purchase orders and a monthly reporting system which reports actual versus estimated expenditures for the time period. The Reporting Entity and Its Services This report includes all of the funds and account groups of the Village. It also includes all activities considered to be part of (controlled by or dependent on) the Village, as determined by the application of the criteria set forth in "Defining the Governmental Reporting Entity - GASB Codification Section 2100". In accordance with GASB Codification Section 2100, for financial reporting purposes the Village's financial statements include all funds, account groups, departments, agencies, boards, commissions and other organizations over which Village officials exercise oversight responsibility. Oversight responsibility includes such aspects as appointment of governing body members, budget approval, approval of property tax levies, outstanding debt secured by Village full faith and credit or 1 revenues, and responsibility for funding deficits. The Village considered the following entities when implementing GASB Codification Section 2100. Although these entities are similar in nomenclature and scope of public service, the criteria in GASB Codification Section 2100 dis not require the inclusion of these entities in the Village's financial statements as component units principally because the Village does not exercise any of the elements of oversight responsibility over such entities. Listed below are the entities that were considered: West Deerfield Township Highland Park Mosquito Abatement District" Deerfield Park District Deerfield Bannockburn Fire Protection District Municipal Insurance Cooperative Agency (reported as a proprietary joint venture - Note 5) ' High -Level Excess Liability Pool (reported as a proprietary joint venture - Note 5) The Village of Deerfield, Illinois, was incorporated April 14, 1903. The Village operates under a Board/Manager form of government and provides the following services as authorized by its charter: public safety (police), highways and streets, sanitation, health and social services, culture -recreation, public improvements, planning and zoning, and general administrative services. Separate reports and financial statements have been prepared for the Police Pension Board and the Public Library Board. These financial statements and reports are also contained within this report which combines all the funds under the Village's jurisdiction. ' v General Governmental Functions Revenues for the General, Special Revenue, and Debt Service Funds totaled $7,532,218. This is an increase of 0.8% over 1987. Taxes produced 72.9% of general revenues compared to 63.4% last year. Of the amount listed as taxes, $2,761,433 was property tax revenue. The prior property tax extension was $2,784,086 for a decrease of 0.82%. Sales tax is also included in the general category of taxes in the amount of $1,788,844. This is an increase from the prior year (net of a one time adjustment in 1986-87) of 9%. The increase in miscellaneous revenues was primarily due to increased interest earnings. 1988.REVENUES Increase Percent (Decrease) Revenue Source Amount of Total from 1986 Taxes $5,491,917 72.9 $ 118,372 Licenses and Permits 380,651 5.0 (196,089) Intergovernmental 317,734 4.2 (28,686) Charges for Services 207,055 2.7 (21,149) Fines and Forfeits 240,598 3.3 (17,125) Miscellaneous 894,263 11.9 198,309 TOTAL $7,532,218 100.00 $ 53,632 The current year (1986) tax levy collections were approximately 100.5%. Property taxes which are delinquent more than one year are written off; subsequent collections of such taxes are reflected as 'prior year revenues' in the year collected. Allocation of property tax levy by purpose for 1987 and the preceding three years is as follows: 1987 1986 1985 1984 Purpose Tax Rate* Tax Rate* Tax Rate* Tax Rate* General Fund .068 .117 .168 .183 Special Revenue Funds .397 .459 .483 .446 General Obligation Debt .351 .414 .467 .232 Pension Trust Funds .044 .064 .067 .062 Enterprise Funds .149 .156 .156 .151 TOTAL TAX RATE* 1.009 1.210 1.341 1.074 *Rate per $100 of equalized assessed valuation Expenditures for General, Special Revenue, and Debt Service Funds purposes totaled $7,433,332, an increase of 9.2% over the prior year. The increase in Debt Service Expenditures is due primarily to issuance cost of the new bond issue. vi [I 1 1 1 1 i 1 1 1 i 1 1 1 i 1 1 1988 EXPENDITURES Increase Percent (Decrease) Revenue Source Amount of Total from 1987 General Government $1,246,347 16.8 $ 49,703 Public Safety 2,256,808 30.4 116,868 Highways & Streets 936,688 12.6 20,198 Culture and Recreation 891,812 12.0 85,940 Miscellaneous 364,665 4.9 9,932 Debt Service 1,737,012, 23.3 347,457 TOTAL $7,433,332 100.00 $630,098 Debt Administration The ratio of bonded debt to assessed valuation and the amount of bonded debt per capita are useful indicators of the Village's debt position to municipal management, citizens, and investors. The data for the Village at the end of the 1987 fiscal year is as follows: Outstanding General Obligation Bonds By Issue Sewerage Improvement Bonds Series of 1973 $ 325,000 Sewerage Treatment Facility Bonds Series of 1973 675,000 Corporate Purpose Bond Series of 1982-A 300,000 Corporate Purpose Bond Series 1986 10,775,000 Corporate Purpose Bond Series 1987 10,000,000 TOTAL $22,07 5 ,000 Other Debt to be Abated from T.I.F. District #1 Corporate Purpose 1982 Bond Series of 1982 Corporate Purpose 1983 Bond Series of 1983 TOTAL GRAND TOTAL BONDED DEBT Less: DEBT SERVICE FUNDS AND EXPENDABLE TRUST FUNDS NET BONDED DEBT Net Bonded Debt Net Bonded Debt Less Self Funded Ratio of Net Debt to Amount Assessed Value $11,543,846 3.66% 10,993,846 3.49% vii $ 425,000 125,000 $ 550,000 $22,625,000 11,631,154 10,993,846 Net Debt Per Capita $659 $628 Moody's Investor Service upgraded the Village's General Obligation Debt to Aa from A 1 on July 1, 1982. This rating was last confirmed on October 12, 1988. Cash Management Cash temporarily idle during the year was invested in repurchase agreements (Library only), certificates of deposit, treasury bills, bonds and notes. Funds held for the Police Pension Fund are invested in treasury bonds and notes, treasury strip coupons. As of April 30, 1988, the total amount invested by the Village was 100.0% of available funds. The total interest earnings for the year for all funds, including the pension funds, was $1,,720,774. For the prior fiscal year, the total amount earned was $1,790,540. General Fixed Assets The General Fixed Assets of the Village are those fixeds assets used on the performance of general governmental functions, excluding the fixed assets of the Enterprise funds. As of April 30, 1988, the general fixed assets of the Village amounted to $5,295,105. This amount represents the original cost or estimated original cost of the assets and is considerably less than their present value. Depreciation of general fixed assets is not recognized in the Village's accounting system. Enterprise Funds The Village's Water Fund had total operating revenues of $1,984,088 and operating expenses of $1,753,907, or a total operating income before depreciation of $230,181. Revenue bond coverage for the year ending April 30, 1987, was 4.71. The Sewerage Fund has operating revenues of $1,070,821, operating ex- penses of $1,005,577 for an operating income before depreciation of $65,244. The Refuse Fund had operating revenues of $453,555 and operating expenses of $957,265, for an operating loss of $503,710. However, there was a property tax levy for $485,998 for refuse purposes. This revenue source and other revenues cover the operating loss. The Commuter Parking Lots' fund operating revenues were $91,181, with operating expenses of $23,182, for an operating income of $67,999. Prospects for the Future, Significant Activities and Local Economic Events The Village's Tax Incremental Financing District #1 was founded in June, 1982, to facilitate growth and development in the Lake -Cook corridor portion of the Village, primarily the area known as the Brickyards. The district's increased equalized assessed valuation over its frozen cap has been: 1982 - $4,143,104; 1983 - $7,247,225; 1984 - $19,483,923; 1985 - $26,641,540; 1986 0 $31,010,143; 1987 - $40,260,189. This growth has been faster than had been anticipated. viii 1 1 ,n u 1 TIF District #2 was established in December, 1986, for the renovation of the Village Center. The increment district equalized assessed valuation has been: 1986 - $770,480; 1987 - $2,278,213. The Village's commercial community has been rapidly expanding in the last several years shown by the: Calendar Year 1984 1985 1986 1987 1988 (Eight Months Only) Commercial Building Permits $33,836,440 36,217,107 40,460,342 31,990,577 17,368,883 These projects are only now reaching completion and indicate that there will be significant increases in the Village's equalized assessed valuation for some years in the future. The Village has added a hotel tax to its revenue mix. The Village currently has three hotels in operation: Marriott Courtyard, 132 rooms completed in 12/86; The Hyatt Deerfield, 300 rooms completed in 12/87; The Embassy Suites, 237 Rooms completed also in 12/87. In addition, the Village has under construction a 128 room Residence Inn Hotel with an anticipated completion date of December, 1988. There is also a 3,000 square foot hotel proposed; however, construction has not yet begun. The hotel tax is a significant addition and will help diversify the financial revenue mix. The hotel tax is budgeted for $500,000 for the 1988-89 fiscal year and is tentatively budgeted for $700,000 in the 1989-90 fiscal year. These additional businesses and the consumers which they bring into the Village add a vibrance to the existing Village's commercial activities and will have a positive effect on the Village's partial tax revenues. Fund Balance Designations The Village has established designations of General Fund fund balance for capital improvements as follows: Area improvements: Brickyards ($322,000).. This designation is for the improvements to the area described as the Brickyards. Area improvements: Downtown ($1,200,000). These funds will be utilized to enable the Village to encourage development/redevelopment in the central business district. ix 1 Independent Audit I State statutes require an annual audit of the books of account, fiscal ' records and transactions of all administrative departments of the Village by independent certified public accountants selected by the Board of Trustees. This requirement has been complied with, and the ' auditor's opinion has been included in this report. Certificate of Achievement for Excellence in Financial Reporting The Government Finance Officers Association of the United States and Canada (GFOA) awards a Certificate of Achievement for Excellence in Financial Reporting to units of government for the comprehensiveness of ' its financial report. In order to be awarded a Certificate of Achievement for Excellence in ' Financial Reporting, a governmental unit must publish an easily readable and efficiently organized comprehensive annual financial report, whose contents conform to program stadards. Such reports must satisfy both generally accepted accounting principles and applicable legal require- ' ments. The Village was first awarded a Certificate of Achievement for Excellence in Financial Reporting for its April 30, 1984, report, and was also awarded the Certificate for the April 30, 1985, report and its April 30, 1986, report, and the April 30, 1987, report. I believe our current report substantially conforms to Certificate of Conformance ' Program requirements. We are submitting this report to GFOA to deter- mine its continuing eligiblity for a certificate. Acknowledgements i The preparation of this report on a timely basis could not be , accomplished without the efficient and dedicated services of the entire staff of the Finance Department. I would like to express my appreciation to all members of the department who assisted and contributed to its preparation. I would also like to thank the ' president and members of the Board of Trustees for their interest and support in planning and conducting the financial operations of the Village in a responsible and progressive manner. , Res ectfully submitted, 4 George. Valentine Finance Director Village of Deerfield I 1 1 1 it u � Financial Section P-j I 1 1 1 11 11 AUDITOR'S OPINION r- 1 1 I ' Certified Public Accountants I ' The Honorable Bernard Forrest, Mayor Members of the Board of Trustees Village of Deerfield, Deerfield, Illinois We have examined the general purpose financial statements of the Village of Deerfield, Illinois and the combining, individual fund, and account group financial statements of the Village as of and for the ' year ended April 30, 1988 as listed in the table of contents. Our examination was made in accordance with generally accepted auditing standards and, accordingly, included such tests of the accounting records and such other auditing procedures as we considered necessary in the circumstances. In our opinion, the general purpose financial statements referred to ' above, present fairly the financial position of the Village of Deerfield, Illinois at April 30, 1988, and the results of its operations and the changes in financial position of its proprietary fund types and similar trust funds for the year then ended, in ' conformity with generally accepted accounting principles applied on a basis consistent with that of the preceding year. Also, in our opinion, the combining, individual fund, and account group financial ' statements referred to above, present fairly the financial position of the individual funds and account groups of the Village of Deerfield, Illinois at April 30, 1988, and the results of operations of such funds ' and the changes in financial position of individual proprietary funds and similar trust funds for the year then ended, in conformity with generally accepted accounting principles applied on a basis consistent with that of the preceding year. Bank of Wheaton Building • 211 South Wheaton Avenue • Wheaton, Illinois 60187 • (312) 665-4510 2 1 Our examination was made for the purpose of forming an opinion on the ' general purpose financial statements taken as a whole and on the combining, individual fund, and account group financial statements. The accompanying financial information listed as supplemental in the table of ' contents is presented for purposes of additional analysis and is not a required part of the general purpose financial statements of the Village of Deerfield, Illinois. The information has been subjected to the auditing procedures applied in the examination of the combined, combining, individual fund, and account group financial statements and, in our opinion, is fairly stated in all material respects in relation to the general purpose financial statements taken as a whole. The statistical information listed in the Table of Contents was not examined by us and accordingly, we do not express an opinion thereon. 1 1 '<✓ Karrison & Byrne September 8, 1988 11 1 1 I I li i� 1 1 1 GENERAL PURPOSE FINANCIAL STATEMENTS �1 VILLAGE OF DEERFIELD, ILLINOIS ALL FUND TYPES AND ACCOUNT GROUPS COMBINED BALANCE SHEET APRIL 30, 1988 n n ( See Following Page) 11 1 1 1 t 11 1 rt ray 90 Q I ,rye N fY ~p uR fT rym~y (rt� ~ (D o D rt o M j _ w F O� F N In W F N Tj 'co F W V 10 V W O V L� 49 oo W W lNi+ W O, In N N W N N 10 V ON14 W In V r p N L. 00 m _ '17 8 O Oo W W N fD00 prt� Oo In N N V O� F O F n ul 10 Li _ R pp ppV F 00 07 Oho t-nt N OOo F W O� OW lol rt W N rr O V OD M N O D 0 C ID C3, O 00 �Hp \ � 00 N A N W 'D � `G {p iA In In PI mmPD R � W W NN WW � O Oo •V-. N V N N W OD O Oo ti W W D` In F QD v N In � V OVVO V ol F v pW O l0co W F � Fop �-- ip rv'-00 a, � O R a N10 ao A Q ONN> N O� In Oo 00 Off. Ut 00 lJ N O\ lD F N �W-. O 4\ coW `G 1\ o OW co co pV � In O+ pip O O 0 V A N O O W �D Oo N W In w rr �O Q` I 1 1 1 1 i n 1 r t 1 1 L 1 1 L Q) H W uGy tl N N I-1 GL N tta�tr 'oG-' N U W 8� HMO �?CO �8O Epp pp �11N �7 00 ON �? 0p0 1p� pN N �mc7 �p1O1 00 O� rn I W�p7 .D 2 d An SO N ! O cn en I N In cn w N �Op 00 N W m W f'1 N O .'~r vl O O N N O M O Qcl Lc'' d r% cl� cl N n N r'1 M �O O r� .NO Mi O N O� O lO 00 vl D n n lO N co Vl M ICY '� �'1 .--� a, pp N co � pQN pQ C�1 VpQ? Ln V V V I I eq O O O rn I rn N N N M M t? of n S lo N 1o�p O I O spy Epp M r^ N ul O a0 ^'� O 00 la�'01 O O O c0'1 pp N_O op p N oo N � M Ol .r co M m fM"1 nM'1 d v v) vl N n N P. n O c m Go m en ^ cn N v d "I N W N Inf` O--� -� a0 CO �7 d .7 N M y N N O O O Oc I N cn I�co v vl N to O r- N N N N 8n Ln Ln �O M cn 17 n n n r- N to N en (no�r d a, nn- r/1 v1 V1 .fir n 11l lc V^ 00 oc cl: ccc� cn N NN 8 a0 O N pp 8 pp pp pp pp � M N MMp O m O V1 Ln vw pp c'1 c� p g Epp M MNOOON ti M MIn M N .i C cn Jq O 'O W O O O N W a�) 14 8H C�jF' ,fl °tl�F H F F �� �,�a�a�a a12a � �° y4l a �kf 3 1 4 W W a >+ qF z D w O OO J MtnN J JN pN•--�J-� n O n J J N . . >1 O\ Ln 'I N to EO M •-� �D cn M N N v1 cD O n —0 � 7 N u O O O oo cnM�O+nO N DO w �� n O to n n 00 oOO�t`ONt� N M M N N O J 00 N aJ .i ca O L O O O O O O G :5 In to aE X N N W J J N LI G O� Oc .-1 N O Lo M N N N . U to m M M a O O Vf 6 JJrnCO f�N �D OJ,..� -O)J" ^-� n OaD t' 1+ 10 O, 10 Ln .r w OO W m M OW N o0 en Ln O Mn �Dn � .y N N O nW W Ntn� OJ\ Jp oo lo'n ON co cn oo 'D o0 '0 0 O J O oo J J l N .: o0 J tnM �Ic:.; N N.--��D NN O, co MAD Ln 'n J IJ Ln n Q O rn N O O O O v1 -a Q C tb N O, Q O O p f� N O O O O O O O t\ N N M O M J co O r- O t- I .--� J J Ln O cn �D �D 'D O ap N M O OO t` Ot, N vl Mv0 OI I v v J O M M o cn O M O� J O O J11 N -O O �D+ 0010 O cop D a0ti Oa0 N M Im, O a,O+ n N N lD coo0 N O O .+ a,0 0 .r N II I III MI rn M 1`�cn—C"OI to O H N N f� oo to Cn O) N cn O cn n a0 W .r Ln Le) O cn 0 J J n n M O C M ID N M O M J u1 pN oo ooND to U W lD n rn c+c p N M N N M O O n F V G O w D M M N J J CA_ N c7lM N O N 00 o0 O t- O n tT lD lo Ln ctl L .i O O� O O n J to O C O� a� u ,D > G. y H lD O1 N N cn O t\ N M O N co N M O O c O 0 W) F] Q) 6 N ..w ,..� M O V1 O� M n .y J N f� O �O O O� ✓1 to 00 O 00 O M lD N .-c O o N ro ? 'D M cD Ul M J n N J oo cn M W Oc O 1� M O to V1 Ln+-1 C U W/ cl .r O .D o0 Vi M lD W lD m J N C O O O aD .fir N N ol to O) u1 .r 00 M o0 M •--� N W O. W) h w co �c N O M M O) 'D O) �D v Ln '.'� OO J .-� .ti .-i N O� op M ID co W C, N N '4 J N M oo n M n J .r N W J m coD` wJ O O O� cD �D 'I n N J O v1 J Ol O� O� oo G Wl t l to O J • M oD J H M M Ln y G �D J— O co J lD .--� n N 6 d O N OO J J O Ln in In oo N N cD O N O O O u J to cli J N M v M M M N to H W H tH4 w G p V ^ tW C a) y _ w Ea77 � W OHO C C N C lbca c O H v N > W) F01 ;a a CO c L c 6 w .. o a$ > a u cc L y L WJ G� C W) W) O .-1 u u C tq H H v w H H + m to u fA to u U +: U co WJ N C W) y 6 U 1Ui 7 W p O W) PO W � U o) N w> x O O u G G m ..Ui u W) H H W) V7 41 H — O o1 H H H C 3 7 W) O Q ct) co E {.a y L H co > +') N N y M w +4 'O >> W W) y O O W W +-1 to E O z W C H w C yy W) u �C a 7 u G U W) U to tW O) a.) C tW tUo U u G H C u u W) N H m c 0 > y C 'O O t>'y C4 G O O N P� d 7 W to Wu C .pO-I wt oO G G C > U Ero 0UE MUy 0 WH W)O ~G W4) UH w 10 c W oco m -4 co W) -1 >+ W) rt 0> P. tW .4 -H t W C W O C GO "i cuWW tNo > co N O N N 14 H H O UG H -4 H Z) 61 H M 3 7 W) H W) U H )+ to u p .-1 +') C +') M H 4j (, t M C H H 0 o A. U) to OO W) .. co W 0 H M u u G W) H t u U N LO C u F C G ,� ,� W v u 'O .ro 7 M O C OO y C K �+ G •,q W) c p CO .4 cn u +d .0 N W. co W. v b u m 0 FF C Ga. 5 U o. p pH,, H O of P. G H N N C a U)) -0 A. >. V m N co aHa -GEc)w c7i c�in� ww u ccoW c Ww�a C W W ogouw v w 61 W ra r'" o Od W E q In W qdW O L)i z H ON HC iCU .4 In W a OM N ^ pq W VI 1 N �n a tw >L)d w Wdz a N o w w 0w{r.� w 6 F H F > U rA W P4 a z w to oo � qU U Z. W 6 C9 t 1 J p O0 �O O N o0 M C ro Ili lC n p V1 N N M 00 lD coO %O O Ol O M OD N p V1 . O 1� O 7 --� O 1, O J N %D %O %D .--i J V'1 O �-+ M 1b 10 O 00 O Q` L Q\Io .r OJ O,M L1 J V)M Q•'D Np.+M Ol O M ti1� OO` 7 6 J MM NN 00 N NaO M �O�MJ M OO N O O .. ca t? 0 E v M 00 M O O 000 V 1 N J n O O cD J 02 O J O M O O O 1 N M V 1 a, O O N M o 'D O .0 O y N � 1 0 V1 1� O 'I u -+ 10 n O op O N �O W J p J H COI NJ 1: M 110 O O1Z N NO V1 �c J M cl lD n w' a a D N N M O O� M V) C h � O M N N M O O W v n u 7 O PO M M M N N ID N M M O O, M V 1 O %D J M M F Vl r� --� N --� � N `D M O O J Do N M O M O M c> N O N 00 o0 0 1., O 1, H f+N1 O a O O r, J u 1 C O S ro O� D N O 1� O N 1b cc 7 Ol N N :+ N p.- M N M p p U •-� M V1 O� M O O � v W 0) W a.l `D O %D o %O %O c 0 0 ? N o N O N (14 O O O 0) u A v OJ O O O N N J J J to cn en clj 'a 00 N N V.,00 M N N N V) O% J N N N ^ nO, ^'lo M%O J00 M M ON V1 ^ �O O O Oo0 �+ w C OO 'O 'D M �D V\ ID r+ J O M --i N 00 si � �-1 .... C U d J...iM .:N O� M > N N x O p O U++ �O� V) c, �c, n c C rn O O C)0. OOI Ib O 1: O� M 00 V1 w N N C O 'a J V1 ^I M 01 J N N T %O lO v ..-' N N J N M O% 1b n I M 1� J .-� N 1, u'1 OD O m O. O O O, l O %O J 1� N J O V 1 J ro J I� J V1 O J M IT00 ID 00 N J C %c M c o J IO .+ 1, lO N r, J L O N co J J O o V1 u W N N ID O N N ti 1 cc N J � .+ N M w w G � ^ a) 000 1n n O O C9 00o0000 �N 00 ul cu clo coo olol cn Oo b CO O J O J V'1 V1 Vl N �p 'a O� J .r � cq �D N N N O, .r 0p v O N N M l D M M I cN M ti N M cN m w v y Iv y y c u w w C :3 u C O y O O) 1+ a ro > w c G O 6 a) 0) fO v u 'o y M J.1 y /+ PC O O) 7 1$ C O C u L C r-4 y W y y 1,q v O w y y L v CO 0) CO w 44 O) a Q. � O O) C O) y 3 U 7 O'D ... U y y w vu{ U ww Q) y u " w 14 C w ro> .a y U N y w .,.1 W 'a y y T N N 7 d O w W M y u w N N iG.l T K. y L C U l+ U V) y y L w a, c w c v u a G w .a u e 7 w G p G w W O w o W m c O N C 61 w' C ro 0. X O) ,., 7 +-� +1 O a ro oCo ro .-1 W 4 G w wEl C ro w O O) N U ro y Cn y co,.1 ro u M C F, U O N w 'a C w U T y H> 0. y .-1 4+ U OO .D C OO EO O 41 u y > C ro w ro U 1+ ++ N ro 0) 0. C ro C G 0. N O y ro 'y .-1 y w W w .-1 ro 7 L w. 4 3 7 0 y C N U U w t+ u A X v4 U C' A -H H L 9 O1 y C w 00 y y u W w w U O u .4 .0 u to .,q a) C OO .4 w 'u w 7+ C O) N +1 u L D H v W C u u ro W CO CO w a 'o C X U C y E u 7 +1 L C 3.+ U f1. 5 U i pyy F+ C u P. r4 0 y w ro y 6) C w w v 1+ v tU C T v P. LLro > H .] rCi U �s, 6 V U O O U P. LY G] W O W X W ,C u o J O O V1 J V1 lD O V1 M J OO � V1 C O� O t? �O J c. ..4 J J %O V O� C .r O O '+ Vl W M N O lO N O O O Ln Vf C) N O� N N 00 .D 00 000 O� V). � c w 1 VILE OF DEERFMD, ILLINOIS ALL PROPRIETARY AND FIDUCIARY (PENSION TRUST) FUND TYPES OCI MED STA'[g2M OF REVIIVUES, EXPENSES, AND CHANGES IN FEf'ATNF:I) FAR MVS - UNRESERVED/FUND BALANCE FOR THE YEAR E M APRM 30. 1988 Operating Revenues Taxes Charges for Services Contributions Miscellaneous Total Operating Revenues Operating Expenses Administration Operations Depredation Benefits and Refunds Miscellaneous Total Operating Expenses Operating Income (Loss) Nanoperating Revenues (Expenses) Interest Inane Property Taxes Interest Expense Net Income (loss) before Operating Transfers Operating Transfers In Operating Transfers (Out) Net Income (Loss) Other Changes in Retained Earnings - Unreserved/Fund Balance Depredation that Reduces Contributed Capital Nat Increase (Decrease) in Retained Earnings/Fund Balance Retained Earnings - Unreserved/ Rmd Balance May 1 April 30 Proprietary Fiduciary Rud Types Fund Types Totals Internal Pension (Memorardum Only) Enterprise Service Trust 1988 1987 $ 150,024 $ 150,024 $ 180,434 $3,523,025 $151,154 3,674,379 3,498,455 107,902 107,902 99,923 76,620 473,397 550,017 572,001 3,599,645 151,354 731,323 4,482,322 4,350,813 316,636 316,636 312,189 3,423,295 176,351 3,599,646 3,157,864 386,448 386,448 298,505 87,859 87,859 100,935 53 53 99 4,126,379 176,351 87,912 4,390,642 3,869,592 (526,734) (24,997) 643,411 91,680 481,221 135,047 135,047 107,256 485,998 485,998 424,717 (3,825) (3,825) (5,738) 617,220 - - 617,220 526,235 90,486 (24,997) 643,411 (20,000) (20,000) - 70,486 (24,997) 301,500 - 643,411 371,986 (24,997) 643,411 3,655,529 (8,305) 4,411,629 $4,027,515 $(33,302) $5,055,040 708,900 1,007,456 900 (20,000) (20,000) (20,000) (19,100) 688,900 988,356 301,500 212,000 990,400 1,200,356 8,058,853 6,858,497 $9,049,253 $8,058,853 See accompanying Notes to the Financial Statements. 7 rn a z H E-+ A H z (n O O c74 a — Ic H c to U) H H O U z H z a z F-4 c a O �. H H � cn z z H f Aa cn H v C7 f w Cd < f w � x • W H U A D fZ4 f f=+ A O O H f Ls+ H w z Wiz`• a W E a H �>• -ccf >� F fni w ra H W Cd z ca fL H a o U a a N in r- ON ON ID rl 00 o 00 M O O N N O N -+ O O to 00 M In M -It 1.0 1.0 to ON �t O� O% O N M r- 00 M 00 N M 00 Lr Ln �t W 7, m M .--r •--4 .-i M ON ,p N ON to N -It N O N -4 •-+ O N cn cc O L 'O O C [� cc r- 00 to n O r- O%� r- 00 -a )n O -+ 00 N O w O, �t Ln r- 't .--I D\ .--i N M O r- 00 M O 00 M %.D rn m ON CYN O-' -4 -4 O • 4 ON n 0) 00 M %D O Ln •--� 't •--i M N 00 )n 00 %D O, I •--� 00 O N 00 cV cV r- rn N 00 O N .-4 r+ c'1 00 O 00 . r+ Lr 1 ,D y �-+ r•+ n 00 ID � N .-•i M 91 N C ^� --4 Ln ,D O C) %D r� M %+ 0 a. 't %.D O .t %D M CO >,•�4 w • ,-q H rn 7 ri cl in u = .1 -t N M 7 •b U) E-H 00 'v C W 4 It L: I .a N N n M O 00 O rb m 0) cV N O, O, O, ,D O ,D C u O O N N W -4 v i It N r: r. O r: +J w (14 N N �O >, V) C 0) v L 0) 1-4 cn trr rr} ra a N H . rl w •b N %D 00 It 00 r- O` UN •--r M O V1 It •--1 ow C U) 00 It M It It N N N N O n Ln •--� O 7 •4 .t It ON in m 00 00 • r- O ,D Ln ,D w 0. o ,D .o -+ N N ,p )n iri r� 1 L+ r� 00 Ln 00 to M •--i O's •-r v cn O u•1 .--i •-+ en N 00 •-.4 L v Er v ca 1) «1 .4 U C cc to G -+ rz, L y v -4N v CA to .-.4 • ••I .0 C L • rr u L v 0) A y •d f1. (n co aJ (n 1-1 O a) 4-1 w a m (L)) rn A -4'' �. s C rn u rd M (U in +-) u ,..+ O rn 0) ,4 06 rn 4 fn •ter (t U) U C i-� L' •"'1 L Qi u �'+ s+ C z b 1 O 3+ S+ L7 A C C r+ V v a) C 7 C •-+ O C v •b N L+ v b Z u U U tJ H O l+ 0)w Al A u G v m"o 4-)-4 Sj x w Ou) •u p O C b 4J O •14 O O -Ci U ca U LL+ U C U) v 9 C u O t+ EnW ° to Co 04 O C CO W v a) v x v O v 0) v fra ca N O H W 0. m v) Cw -+ a s rn rn rn v M rn L N co rh m co O co m N N w O cti rd LI b A al v 1+ rtl L 0) v W u C -r .-a 3 L W•, C m •4 u v z U u •+ f3 ❑ z u W U L H 71 X 0. v C w r0 C C C v a) C ro a. v) O A H a4 U rn [zr H 0A W u U)Cl d v V 0 z U cn 1. VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30. 1988 Summary of Significant Accounting Policies The accounting policies of the Village of Deerfield, Illinois conform to generally accepted accounting principles as applicable to governments. The following is a summary of the more significant policies. A. Reporting Entity and Its Services This report includes all of the funds and account groups of the Village. It also includes all activities considered to be part of (controlled by or dependent on) the Village, as determined by the application of the criteria set forth in "Defining the Governmental Reporting Entity - GASB Codifica- tion Section 2100". In accordance with GASB Codification Section 2100, for financial reporting purposes the Village's financial statements include all funds, account groups, departments, agencies, boards, commissions and other organizations over which Village officials exercise oversight responsibility. Oversight responsibility includes such aspects as appointment of governing body members, budget approval, approval of property tax levies, outstanding debt secured by Village full faith and credit or revenues, responsibility for funding deficits. The Village considered the following entities when implementing GASB Codification Section 2100: West Deerfield Township Highland Park Mosquito Abatement District Deerfield Park District Deerfield Bannockburn Fire Protection District Although these entities may operate within the Village's boundaries, and are similar in nomenclature and scope of public service, the criteria in GASB Codification Section 2100 did not require inclusion of these entities in the Village's financial statements as component units because they have their own oversight boards, their expenditures are financed from sources other than the Village, and the Village has no obligation for their debts. High -Level Excess Liability Pool (HELP) HELP is a joint venture established to provide excess liability cover- age for its member municipalities. Management consists of a Board of Directors comprised of one representative from each member. The 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 1. Summary of Significant Accounting Policies (Cont.) A. Reporting Entity and Its Services (Cont.), High -Level Excess Liability Pool (HELP) (Cont.) Village does not exercise any control over the activities of the Agency beyond its representation on the Board of Directors. HELP is reported as a joint venture (Note 5). Municipal Insurance Cooperative Agency (MICA) MICA is a proprietary joint venture established to manage and fund first party property losses, third party liability claims, workmen's compensation claims and public officials' liability claims for its members municipalties. Management consists of a Board of Directors comprised of one representative from each member. The Village does not excercise any control over the activities of the agency beyond its representation on the Board of Directors. MICA is reported as a proprietary joint venture (Note 5). The Village of Deerfield, Illinois was incorporated April 14, 1903. The Village operates under a Board/Manager form of government and provides the following services as authorized by its charter: public safety (police), highways and streets, sanitation, health and social services, culture - recreation, public improvements, planning and zoning, and general admini- strative services. B. Basis of Presentation - Fund Accounting, The accounts of the Village are organized on the basis of funds and account groups, each of which is considered a separate accounting entity. The operations of each fund are accounted for with a separate set of self - balancing accounts that comprise its assets, liabilities, fund equity, revenues, resources and expenditures, or expenses, as appropriate. are allocated to and accounted for in individual funds Government based upon the purposes for which they are to be spent and the means by which spending activities are controlled. The various funds are grouped, in the financial ' statements in this report, into generic fund types and broad fund categories as follows: GOVERNMENTAL FUNDS General Fund The General Fund is the general operating fund of the Village. It is used to account for all financial resources except those required to be accounted for in another fund. Special Revenue Funds - Special Revenue Funds are used to account for the proceeds of specific revenue sources (other than special assessments or major capital projects) that are legally restricted to expenditures for specified purposes. VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 Summary of Significant Accounting Policies (Cont.) B. Basis of Presentation - Fund Accounting (Cont.) GOVERNMENTAL FUNDS (CONT.) Debt Service Fund - Debt Service Funds are used to account for the accumulation of resources for, and the payment of, general long-term debt principal, interest, and related costs. The Debt Service Fund has been treated as a single fund and budgeted in a like manner by the Village. Capital Projects Funds - Capital Projects Funds are used to account for financial resources to be used for the acquisition or construction of major capital facilities (other than those financed by Proprietary Funds, Special Assessment Funds, and Trust Funds). Special Assessment Funds - Special Assessment Funds are used to account for the financing of public improvements or services deemed to benefit the properties against which special assessments are levied. PROPRIETARY FUNDS Enterprise Funds - Enterprise Funds are used to account for operations (a) that are financed and operated in a manner similar to private business enterprises - where the intent of the governing body is that the costs (expenses, including depreciation) of providing goods or services to the general public on a continuing basis be financed or recovered primarily through user charges; or (b) where the governing body has decided that periodic determination of revenues earned, expenses incurred, and/or net income is appropriate for capital maintenance, public policy, management control, accountability, or other purposes. Internal Service Funds - Internal Service Funds are used to account for the financing of goods or services provided by one department or agency to other departments or agencies of the Village, or to other governments, on a cost -reimbursement basis. FIDUCIARY FUNDS Trust and Agency Funds - Trust and Agency Funds are used to account for assets held by the Village in a trustee capacity or as an agent for individuals, private organizations, other governments, and/or other funds. These include Pension Trust, and Agency Funds. Pension Trust Funds are accounted for in essentially the same manner as proprietary funds since capital maintenance is critical. Agency Funds are custodial in nature (assets equal liabilities) and do not involve measurement of results of operations. r 1 1 11 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 1. Summary of Significant Accounting Policies (Cont.) B. Basis of Presentation - Fund Accounting (Cont.) ACCOUNT GROUPS General Fixed Assets Account Group - The General Fixed Assets Account Group is used to account for all fixed assets which are not accounted for in Enterprise, Internal Service, or Trust Funds. General Long -Term Debt Account Group - The General Long -Term Debt Account Group is used to account for all long-term debt not accounted for in Special Assessment, Enterprise, Internal Service, or Trust Funds. C. Basis of Accounting Basis of accounting refers to when revenues and expenditures or expenses are recognized in the accounts and reported in the financial statements. Basis of accounting relates to the timing of the measurements made, regardless of the measurement focus applied. All Governmental Funds are accounted for usingthe modified accrual basis s s of accounting. Their -revenues are recognized when they become measurable and available as net current assets. The Village's share of State -assessed income taxes, gross receipts, and sales taxes are 'considered "measurable" when in the hands of intermediary collecting governments and are recognized ' as revenue at that time. Anticipated refunds of such taxes are recorded as liabilities and reductions of revenue when they are measurable and their validity seems certain. Revenues considered to be susceptible to accrual are: Taxes Intergovernmental Revenues Property Motor Fuel Tax Allotments Sales Income Expenditures are generally recognized under the modified accrual basis of accounting when the related fund liability is incurred. rj All Proprietary Funds and Pension Trust Funds accrual basis of accounting. Their revenues are accounted for are recognized when using the they are earned, and their expenses are recognized when they are incurred. Unbilled Waterworks and Sewerage Fund utility service receivables are recorded at . year end. Agency Fund assets and liabilities are accounted for on the modified accrual basis. r 12 1 VILLAGE OF DEERFIELD. ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30. 1988 1. Summary of Significant Accounting Policies (Cont.) D. Budgets and Budgetary Accounting The Village follows these procedures in establishing the budgetary data reflected in the financial statements: 1. The Village Manager submits to the Board of Trustees a proposed operating budget for the fiscal year commencing the following May 1. The operating budget includes proposed expenditures and the means of financing them. 2. Budget hearings are conducted. 3. The budget is legally enacted through passage of an ordinance. 4. The budget may be amended by the Board of Trustees. 5. Budgets are adopted on a basis consistent with generally accepted accounting principles (GAAP). The level of control (level at which expenditures may not exceed budget) is the Fund. Budget lapses at year end. The Village passed a Budget Amendment and the amended budget has been included in the financial statements. Encumbrance accounting, under which purchase orders, contracts, and other commitments for the expenditure of monies are recorded in order to reserve that portion of the applicable appropriation, is employed. Encumbrances outstanding at year end, if any, are reported as reservations of fund balances since they do not constitute expenditures or liabilities. There were no material encumbrances outstanding at April 30. The following funds adopt annual operating budgets: Fund General Special Revenue Municipal Audit Emergency Services/Disaster Youth Bound Library Street and Bridge Illinois Municipal Retirement Public Benefit Federal Revenue Sharing Budgetary Basis of Accounting Modified Accrual Modified Accrual Modified Accrual Modified Accrual Modified Accrual Modified Accrual Modified Accrual Modified Accrual Modified Accrual 1 1 13 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 1. Summary of Significant Accounting Policies (Cont.) D. Budgets and Budgetary Accounting (Cont.) 5. (Cont.) Fund Special Revenue (Cont.) Motor Fuel Tax Transportation Debt Service Debt Service Enterprise Water Sewerage Refuse Commuter Parking Lot Internal Service Garage Trust Police Pension E. Assets, Liabilities, Fund Equity and r„ Investments 1 Budgetary Basis of Accounting Modified Accrual Modified Accrual Modified Accrual Accrual Accrual Accrual Accrual Accrual Accrual Investments are stated at cost or amortized cost, which approximates market, except for the Deferred Compensation Plan Fund investments which are stated at market value. Inventory Inventory is valued at the lower of cost (first -in, first -out) or market. Inventory is recorded on the basis of a physical count. Fixed Assets and Long -Term Liabilities The accounting and reporting treatment applied to the fixed assets and long-term liabilities associated with a fund are determined by its measurement focus. All Governmental Funds are accounted for on a spending or "financial flow" measurement focus. This means that only current assets and current liabilities are generally included on their balance sheets. Their reported fund balance (net current assets) is considered a measure of "available spendable resources." Governmental fund operating statements 14 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 Summary of Significant Accounting Policies (Cont.) E. Assets, Liabilities, and Fund Equity (Cont.) Fixed Assets and Long -Term Liabilities (Cont.) present increases (revenues and other financing sources) and decreases (expenditures and other financing uses) in net current assets. Accordingly, they are said to present a summary of sources and uses of "available spendable resources" during a period. Fixed assets used in governmental fund type operations (general fixed assets) are accounted for in the General Fixed Assets Account Group, rather than in governmental funds. Public domain ("infrastructure") general fixed assets consisting of certain improvements other than buildings, including roads, bridges, curbs and gutters, streets and sidewalks, drainage systems, and lighting systems, are not capitalized along with other general fixed assets. No depreciation has been provided on generalfixed assets. All fixed assets are valued at historical cost or estimated historical cost if actual historical cost is not available. Donated fixed assets are valued at their estimated fair market value on the date donated. Long-term liabilities expected to be financed from governmental funds are accounted for in the General Long -Term Debt Account Group, not in the governmental funds. The single exception to this general rule is for special assessment bonds, which are accounted for in Special Assessment Funds. The two account groups are not "funds." They are concerned only with the measurement of financial position. They are not involved with measurement of results of operations. Because of their spending measurement focus, expenditure recognition for governmental fund types is limited to exclude amounts represented by noncurrent liabilities. Since they do not affect net current assets, such long-term amounts are not recognized as governmental fund type expenditures or fund liabilities. They are instead reported as liabilities in the General Long -Term Debt Account Group. All Proprietary Funds and Pension Trust Funds are accounted for on a cost of services or "capital maintenance" measurement focus. This means that all assets and all liabilities (whether current or noncurrent) associated with their activity are included on their balance sheets. Their reported fund equity (net total assets) is segregated into contributed capital and retained earnings components. Proprietary fund type operating statements present increases (revenues) and decreases (expenses) in net total assets. 1 15 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 r1. Summary of Significant Accounting Policies (Cont.) E. Assets, Liabilities, and Fund Equity (Cont.) Fixed Assets and Long -Term Liabilities (Cont.) Depreciation of all exhaustible fixed assets used by proprietary funds is charged as an expense against their operations. Accumulated depreciation is reported on proprietary fund balance sheets. Depreciation has been provided over the estimated useful lives using the straight line method. The estimated useful lives are as follows: Parking Lot Improvements 20 years Water Systems 40 years Equipment 5-10 years F. Revenues, Expenditures, and Expenses Property Tax Revenue Recognition 1987 property taxes attach as an enforceable lien on January 1, 1987. They are levied in September of the subsequent fiscal year (by passage of a Tax Levy Ordinance). Tax bills are prepared by the County and issued on or about April 30, 1988, and are payable in two installments, on or about April 1, 1988 and on or about September 1, 1988. The County collects such taxes and remits them periodically. Governmental fund property tax revenues are recognized when they become both measurable and available, in accordance with GASB Codification Section P70. The 1987 tax levy has been treated as deferred revenue since it is intended to finance the subsequent year's expenditures. Current year's operating statements recognize current year's expenditures. 1986 tax Fiduciary levy revenues which finance the (Pension Trust) funds recognize 1987 tax levy revenues (accrual basis). Property taxes receivable which are delinquent more than one year have been written off; subsequent collections of such taxes are reflected as "property taxes - prior" revenue in the period received. Accumulated Unpaid Compensated Absences Village employees are granted vacation pay and sick leave in varying amounts. The Village has calculated the following amounts with respect to I I 16 1 1. VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 Summary of Significant Accounting Policies (Cont.) I F. Revenues, Expenditures, and Expenses (Cont.) Accumulated Unpaid Compensated Absences (Cont.) accrued vacation pay and sick leave at April 30: Fund General $259,222 Special Revenue Street and Bridge 7,773 Enterprise Water 5,992 Sewerage 27,030 Internal Service Garage 9,255 Total $309,272 Accumulated unpaid compensated absences are reflected in the financial statements in accordance with GASB Codification Section C60 and SFAS 43 provisions. Such amounts are accrued when incurred in proprietary funds (using the accrual basis of accounting). Such amounts (current portion) are accrued in governmental funds (using the modified accrual basis of accounting). The amounts are all considered current by the Village. G. Financial Reporting Comparative Data Comparative total data for the prior year have been presented in the accompanying financial statements in order to provide an understanding of changes in the Village's financial position and operations. Comparative total data for the prior year have been restated as necessary in order to provide consistency for comparison purposes. However, comparative (i.e., presentation of prior year totals by fund type) data have not been presented in each of the statements since their inclusion would make the statements unduly complex and difficult to read. Total Columns on General Purpose Financial Statements Total columns on the General Purpose Financial Statements are captioned "Memorandum Only" to indicate that they are presented only to facilitate financial analysis._ Data in these columns do not present financial 1 17 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30. 1988 1. Summary of Significant Accounting Policies (Cont.) G. Financial Reporting (Cont.) Total Columns on General Purpose Financial Statements (Cont.) position, results of operations, or changes in financial position in conformity with generally accepted accounting principles. Neither is such data comparable to a consolidation. Interfund eliminations have not been made in the aggregation of this data. Authoritative Sources - Financial Reporting 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 Governmental Accounting Standards Board. The Board has issued "GASB Codification of Governmental Accounting and Financial Reporting Standards" which provides authoritative guidance to state and local governmental entities, and has issued subsequent authoritative pronouncements. 2. Stewardship, Compliance, and Accountability A. Deficit Fund Balances/Retained Earnings of Individual Funds The following funds had a deficit in fund balance/retained earnings at April 30: Deficit Fund Balance Illinois Municipal Retirement $ (14,703) Tax Incremental Finance District 2 (264,188) Special Assessments 3-84 (92,937). Garage (33,302) These deficits will be eliminated with General Fund revenues. B. Excess of Actual Expenditures/Expenses over Budget in Individual Funds �! The following funds had an excess of actual expenditures/expenses (ex- clusive of depreciation and amortization) over budget for the year ended April 30: Fund Excess Debt Service $ 255,786 Water 88,233 Refuse 42,265 Garage 27,361 18 ' VILIAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STAMIENTS APRIL 30, 1988 3. Detail Notes on All Fund and Account Groups A. Assets 1. Cash and Investments The Village maintains a cash and investment pool that is available for use by all funds, except the pension trust fund. Each fund type's portion of this pool is displayed on the combined balance sheet as "cash and investments". In addition, investments are separately held by several of the Village's funds. The deposits and investments of the pension trust fund are held separately from those of other funds. Cash on hand has been excluded from the anounts shown below. Permitted Deposits and Investments - Statutes authorize the Village to make deposits/invest in commercial banks, savings and loan institutions, obligations of the U.S. Treasury and U.S. Agencies, obligations of States and their political subdivisions, credit union shares, repurchase agreements, commercial paper rated within the three highest classifications by at least two standard rating services, and the Illinois Public Treasurer's Investment Pool. Pension funds may also invest in certain norr-U.S. obligations, mortgages, veteran's loans, and life insurance company contracts. Deposits At yearend the carrying anount of the Village's deposits totaled $4,606,587, and the bank balances totaled $5,250,660. Bank Balances Category 1 Deposits covered by federal depository insurance, or by collateral held by the Village, or its agent, in the Village's nane. $ 817,133 Category 2 Deposits covered by collateral held by the pledging financial institution's trust department, or by its agent, in the Village's name. - Category 3 Deposits covered by collateral held by the pledging financial institution, or its trust department, or its agent but not in the Village's nave, and deposits which are uninsured and uncollateralized. 4,433,527 Total Deposits $5,250,660 1 1 For pension trust funds the types of deposits authorized and the mix of credit risk categories do not differ significantly from the other funds of the Village. 11 19 APRIL 30, 1988 3. Detail Notes on All Funds and Account Groups (Cont.) A. Assets (Cont.) 1. Cash and Investments (Cont.) Investments The Village's investments are categorized to give an indication of the Level of risk assumed by the entity at year-end. Category 1 includes investments that are insured or registered or for which the securities are held by the Village or its meant in the Village's name. Category 2 includes uninsured and unregistered investments for which the securities are held by the broker's or dealer's trust department or agent in the Village's name. Category 3 includes uninsured and unregistered investments for which the securities are held by the broker or dealer, or by its trust department or agent but not in the Village's name and uninsured, unregistered and uncollateralized investments. Carrying Amotmt Category Yarket 1 2 3 Totals Value U.S. Government Securities $14,478,922 $14,478,922 $14,852,054 Life Insurance Om parry Contract GNM 976,196 Dade County Florida Aviation Revenue Bonds 10,000,000 Guaranteed Investment Contract $25,455,118 $220,000 220,000 242,686 976,196 976,196 10,000,000 10,438,550 250,000 250,000 250,000 $470,000 25,925,118 26,759,486 Investment in Illinois Public Treasurer's Investnnt Pool 1,120,004 1,120,004 Assets Held by Agents for Deferred Compensation Plan 716,674 716,674 Total Investuents $27,761,7% $28,5%,164 The pension trust fund awns approximately 27 percent of the investments in category 1 and 100 percent of the investments in category 3. ME VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 3. Detail Notes on All Funds and Account Groups (Cont.) A. Assets (Cont.) 2. Fixed Assets a. Changes in General Fixed Assets Balances Balances May 1 Additions Deletions April 30 Land $1,929,477 $402,051 $140,806 $2,190,722 Building and Improvements 1,237,500 77,350 1,314,850 Vehicles 412,994 82,043 5,000 490,037 Equipment 1,113,035 194,616 8,155 1,299,496 $4,693,006 $756,060 $153,961 $5,295,105 b. Summary of Proprietary Fixed Assets at April 30: Enterprise Commuter Water Sewerage Parking Lot Land $ 77,500 Systems $2,808,048 $8,343,360 Equipment and Vehicles 333,881 217,070 Parking Lot _ 613,958 3,141,929 8,560,430 691,458 Less Accumulated Depreciation 755,735 1,655,830 274,100 $2,386,194 $6,904,600 $417,358 1 21 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 3. Detail Notes on All Funds and Account Groups (Cont.) B. Liabilities 1. Retirement Fund Commitments a. Plan Descriptions Illinois -Municipal Retirement The Village contributes to the Illinois Municipal Retirement Fund ("IMRF"), an agent multiple -employer public employee retirement system that acts as a common investment and administrative agent for local governments and school districts in Illinois. The Village's total payroll for the year ended December 31, 1987 was $3,698,215. Of this amount, $2,292,114 in payroll earnings were reported to and covered by the IMRF system. All employees hired in positions that meet or exceed the prescribed annual hourly standard must be enrolled in IMRF as participating members. Pension benefits vest after eight years of service. Participating members who retire at or after age 60 with 8 years of credited service are entitled to an annual retirement benefit, payable monthly for life, in an amount equal to 1 2/3 percent of their final rate (average of the highest 48 consecutive months' 1 earnings during the last 10 years) of earnings, for each year of credited service up to 15 years, and 2 percent for each year thereafter. IMRF also provides death and disability benefits. These benefit provisions and all other requirements are established by Illinois State Statute. Participating members are required to contribute 4.5 percent of their annual salary to IMRF. The Village is required to contribute the remaining amounts necessary to fund the coverage of its own employees in the System, using the actuarial basis specified by state statute (entry age normal); for 1987 the rate was 7.83%. Police Pension Police sworn personnel are covered by the Police Pension Plan which is a defined benefit single -employer pension plan. Although this is a single -employer pension plan, the defined benefits and employee and employer contributions levels are governed by Illinois State Statutes (Chapter 108 1/2 Article 3) and may be amended only by the Illinois legislature. The Village accounts for the plan as a pension trust fund. The Village's payroll for employees covered 3 22 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 Detail Notes on All Funds and Account Groups (Cont.) B. Liabilities (Cont.) 1. Retirement Fund Commitments (Cont.) a. Plan Descriptions (Cont.) Police Pension (Cont.) by the Police Pension Plan for the year ended April 30, 1988 was $1,244,967 out of a total payroll of $3,698,215. At April 30, 1988 the Police Pension Plan membership consisted of: Retirees and Beneficiaries Currently Receiving Benefits and Terminated Employees Entitled to Benefits but not yet Receiving Them 6 Current Employees] Vested 34 Nonvested — Total 40 The following is a summary of the Police Pension Plan as provided for in Illinois State Statutes. The Police Pension Plan provides retirement benefits as well as death and disability benefits. Employees attaining the age of 50 or more with 20 or more years of creditable service are entitled to receive an annual retirement benefit of one-half of the salary attached to the rank held on the last day of service, or for one year prior to the last day, whichever is greater. The pension shall be increased by 2% of such salary for each additional year of service over 20 years up to 30 years, and 1% of such salary for each additional year of service over 30 years, to a maximum of 75% of such salary. Employees with at least 8 years but less than 20 years of credited service may retire at or after age 60 and receive a reduced benefit. The monthly pension of a police officer who retired with 20 or more years of service after January 1, 1977 shall be increased annually, following the first anniversary date of retirement and be paid upon reaching the age of at least 55 years, by 3% of the original pension and 3% simple interest annually thereafter. 1 23 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 i 3. Detail Notes on All Funds and Account Groups (Cont.) B. Liabilities (Cont.) 1. Retirement Fund Commitments (Cont.) a. Plan Descriptions (Cont.) Police Pension (Cont.) Covered employees are required to contribute 9% of their base salary to. the Police Pension Plan. If an employee leaves covered employment with less than 20 years of service, accumulated employee contributions may be refunded without accumulated interest. The Village is required to contribute the remaining amounts necessary 1 to finance the plan as actuarially determined by an enrolled actuary. By the year 2020 the Village's contributions must accumulate to the point where the past service cost for the .Police Pension Plan is fully funded. b. Summary of Significant Accounting Policies and Plan Asset Matters Basis of Accounting The financial statements are prepared using the accrual basis of ' accounting. Employee and employer contributions are recognized as revenues in the period in which employee services are performed. Method Used to Value Investments Fixed -income securities are reported at amortized cost with discounts or premiums amortized using the effective interest rate method, subject to adjustment for market declines judged to be other than temporary (lower of cost or market). Investment income is recognized as earned. Gains and losses on sales and exchanges of fixed -income securities are recognized on the transaction date. Equity securities are reported at cost subject to adjustment for market declines judged to be other than temporary (lower of cost or market). C. Funding Status and Progress The amount shown below as the "pension benefit obligation" is a standardized disclosure measure of the present value of pension benefits, adjusted for the effects of projected salary increases and step -rate benefits, estimated to be payable in the future as a t 24 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 3. Detail Notes on All Funds and Account Groups (Cont.) B. Liabilities (Cont.) 1. Retirement Fund Commitments (Cont.) c. Funding Status and Progress (Cont.) result of employee service to date. The measure is intended to help users assess the funding status of the system on a going - concern basis, assess progress made in accumulating sufficient assets to pay benefits when due, and make comparisons among employers. The measure is the actuarial present value of credited projected benefits and is independent of the funding method used to determine contributions to the System. Illinois Municipal Police Retirement Pension December 31, May 1, Actuarial Valuation Date 1987 1987 Significant Actuarial Assumptions a) Rate of Return on Invest- 7.00% 9.00% ment of Present and compounded compounded Future Assets annually annually b) Projected Salary 3.75% ] .5.50% Increases - Attributable compounded ] compounded to Inflation annually ] annually c) Additional Projected ] ] Salary Increases - ] (Note - separate information Attributable to ] for b) and c) not available) Seniority/Merit 1.00% ] d) Postretirement Benefit Increases 3.00% 3.00% simple interest annually 1 25 1 1 1 1 1 i VILLAGE OF DEERFIELD. ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30. 1988 3. Detail Notes on All Funds and Account Groups (Cont.) B. Liabilities (Cont.) 1. Retirement Fund Commitments (Cont.) c. Funding Status and Progress (Cont.) Pension Benefit Obligation Retirees and Beneficiaries Currently Receiving Benefits and Terminated Employees not yet Receiving Benefits Current Employees Accumulated Employee Contributions Including Allocated Investment Earnings Employer - Financed Vested Employer - Financed Nonvested Total Pension Benefit Obligation Illinois Municipal Police Retirement Pension (Note A) $ 32,140 $ 959,078 ] ] ] 4,291,038 902,400 ] (Note B) 2,032,704 ] ] 262,191 ] Totals $ 991,218 7,488,333 3,229,435 5,250,116 8,479,551 Net Assets Available for Benefits, at Lower of Cost or Market 1,785,417 4,411,629 6,197,046 (Market Values) (IMRF - $1,785,417) (Police - 4,413,035) (Totals $6,198,452) Unfunded (Assets in Excess of) Pension Benefit Obligation $1,444,018 $ 838,487 $2 282 505 (Note A) The pension benefit obligation applicable to retirees and beneficiaries currently receiving benefits is not included in the above schedule due to the fact that this obligation was transferred from the Village to IMRF as a whole when the annuity became payable. (Note B) The concept of vesting is not clearly defined in Illinois State Statutes. Benefit accrual rates are delineated, but they do not assist in defini- tively determining vesting status. As such no detail allocation can be determined. 26 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 , 1 3. Detail Notes on All Funds and Account Groups (Cont.) B. Liabilities (Cont.) 1. Retirement Fund Commitments (Cont.) C. Funding Status and Progress (Cont.) Effects on the Pension Benefit Obligation of Current -Year Changes Illinois Municipal Retirement Current -year changes in the actuarial assumptions, benefit provisions, and methodology are reflected in the December 31, 1987 pension benefit obligation shown above. This amount has been calculated by the IMRF Actuary using the measure described above. The dollar effect of these changes on the pension benefit obligation was not economically determinable on an individual employer basis by IMRF. Since the December 31, 1987 valuation was the first time this measure was used, comparison with a previous year's pension benefit obligation is not available. Police Pension Current -year changes in the actuarial assumptions and benefit provisions resulted in an increase (decrease) in the pension benefit obligation (PBO) of $211,058 as compared to the amount of the PBO calculated irrespective of such changes. 27 IVILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 3. Detail Notes on All Funds and Account Groups (Cunt.) B. Liabilities (Cont.) 1. Retirement Fund Commitments (Cont.) d. Actuarially Determined Contribution Requirements and Contribution Made Illinois Municipal Retirement, Police Pension, and Firemen's Pension The Systems' funding policy provides for actuarially determined periodic contributions at rates that, for individual employees, accumulate assets gradually over time so that sufficient assets will be available to pay benefits when due. The rate for the Village's employee group as a whole has tended to remain level as a percentage of annual covered payroll. The contribution rate for normal cost is determined using the entry age normal actuarial funding method. The IMRF System used the level percentage of payroll method, while the Police Pension and Firemen's Pension Systems used a level dollar amount method to amortize the unfunded liability over a 40 year period. The significant actuarial assumptions used to compute the actuarially determined contribution requirements are the same as those used to compute the pension benefit obligation as described in c . above. 1 1 1 28 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30. 1988 3. Detail Notes on All Funds and Account Groups (Cont.) B. Liabilities (Cont.) 1. Retirement Fund Commitments (Cont.) d. Actuarially Determined Contribution Requirements and Contribution Made (Cont.) Illinois Municipal Police Retirement Pension Totals December 31, May 1, Actuarial Valuation Date 1987 1987 Actuarially Determined Contribution Requirement - Employer As a Dollar Amount Normal Cost $ 59,824 $ 66,239 $126,063 Amortization of Unfunded Actuarial Accrued Liability 101,540 73,512 175,052 Death and Disability Cost 18,107 18,107 $179,471 $139,751 $319,222 As a % of Current Covered Payroll Normal Cost 2.61% 5.30% 3.56% Amortization of Unfunded Actuarial Accrued Liability 4.43 5.90 4.90 Death and Disability Cost .79 .79 7.83% 11.20% 9.25% Contribution Made As a Dollar Amount Employer $179,472 $150,024 $329,496 Employee 103,137 107,902 211,039 $282,609 $257,926 $540,535 As a % of Current Covered Payroll Employer 7.83% 11.20% 9.31% Employee 4.50 8.70 5.96 12.33% 19.90% 15.27% 29 i 1 1 1 1 1 1 1 1 1 i 1 1 1 1 VILLAGE OF DEERFIELD. ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30. 1988 3. Detail Notes on All Funds and Account Groups (Cont.) B. Liabilities (Cont.) 1. Retirement Fund Commitments (Cont.) d. Actuarially Determined Contribution Requirements and Contribution Made (Cont.) Effects on the Contribution Requirements of Current -Year Changes Illinois Municipal Retirement Current -year changes in the actuarial assumptions, benefit provisions, and methodology, explained below, will be incorporated in the 1989 employer contribution rate. These changes are estimated to increase the 1989 rate by approximately 2.03 percent of payroll over the 1988 rate. Separate dollar effects of each change were not economically determinable on an individual employer basis by IMRF. Police Pension Current -year changes in the actuarial assumptions, actuarial fund- ing method, and benefit provisions resulted in an increase (decrease) in the contribution requirement of $(6,300) as compared to the amount of the contribution requirement calculated irrespective of such changes. 30 1 � !! I 1 �I�I• 1�1 1 1 1 1 3. Detail Notes on All Rinds and Account Groups (Osnt.) B. Liabilities (Cont.) 1. Retirement Rind Commitments (Cont.) e. Trend Information Trend information gives an indication of the progress made in accumulating sufficient assets to pay benefits uben due. Tbn year trend information uay be found in the supplemental section of the Village's annual financial report. Illinois Municipal Police Year Retirement Pension Totals Net Assets Available for Benefits As a % of the Pension Benefit Obligation (PBO) Unfunded (Assets in Excess of) PBO As a % of Annual Covered Payroll (Expressing the unfunded pension benefit obligation as a percent- a�p of annual coxered payroll approximately adjusts for the effects of inflation for analysis purposes) Employer Contributions As a % of Annual Covered Payroll Required Made 1988 55.29% 84.03/ 73.08% 1988 63.OUI. 67.35% 64.53/. 1988 8.217. 12.057. 9.56% 1988 $179,472 $139,841 $319,313 1988 $188,188 $150,024 $338,212 (Durirg the implementation transition period all information required is presented for as marry years as is available.) 31 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 3. Detail Notes on All Funds and Account Groups (Cont. ) B. Liabilities (Cont.) 1. Retirement Fund Commitments (Cont.) f. Deferred Compensation Plan Fund The Village offers its employees a deferred compensation plan created in accordance with Internal Revenue Code Section 457. The plan, available to certain Village employees, permits them to defer a portion of their salary until future years. The deferred compensation is not available to employees until termination, retirement, death, or unforeseeable emergency. All amounts of compensation deferred under the plan, all property and rights purchased with those amounts, and all income attribut- able to those amounts, property, or rights are (until paid or made available to the employee or other beneficiary) solely the property and rights of the Village (without being restricted to the provisions of benefits under the plan) , subject only to the claims of the Village's general creditors. Participants' rights under the plan are equal to those of general creditors of the Village in an amount equal to the fair market value of the deferred account for each participant. It is the opinion of the Village's legal counsel that the Village has no liability for losses under the plan but does have the duty of due care that would be required of an ordinary prudent investor. The Village believes that it is unlikely that it will use the assets to satisfy the claims of general creditors in the future. I� 11 32 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 3. Detail Notes on All Funds and Account Groups (Cont.) B. Liabilities (Cont.) 2. Commitments The following major contractual commitments existed at April 30: Expended Required Project Through Future Description Authorization April 30 Committed Financing Sewer Treatment Plant Clarifier $ 129,880 - $129,880 - Public Works Facility 127,300 $ 113,813 13,487 - Sewer Treatment Plant Improvement 428,094 352,416 75,678 - Phase 2A Sanitary Sewer 276,000 200,676 75,324 - Phase 2B Sanitary Sewer 2,276,000 1,875,907 400,093 $12,000 Deerfield Road Pumping Station 1,668,000 1,281,520 386,480 - 1988 Street Rehabilitation 84,700 20,899 63,801 - Wilmot Road Pumping Station 380,000 266,711 113,289 - Bridges 1,392,129 784,605 607,524 - Recreational Site 10,000 4,415 5,585 - Pfingsten/Kates Road Extension 692,069 255,796 436,273 - Brickyard Park Development 28,500 - 28,500 - 33 u [l VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 3. Detail Notes on All Funds and Account Groups (Cont.) B. Liabilities (Cont.) 2. Commitments The Village has committed to purchase excess liability insurance from the High -Level Excess Liability Pool (Agency), a joint venture of Illinois municipalities. The Village expects to pay the following minimum amounts (these amounts represent the Village's share of the principal and interest - "fixed costs" - of the Agency): Year Ended April 30 Amount 1989 $23,492 1990 24,139 1991 24,265 1992 25,209 1993 25,122 1994 24,954 1995 25,600 1996 26,120 1997 25,585 1998 25,880 These amounts have been calculated using the Village's current allocation percentage of 3.59. In future years this allocation percentage will be subject to change, because the Agency Agreement provides that each year Members will be assessed based upon a formula which specifies the following four criteria for allocating premium costs: Miles of Streets Full -Time Equivalent Employees Number of Motor Vehicles Operating Revenues I 34 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEM24M APRIL 30, 1988 3. Detail Notes on All Funds and Account Groups (Cant.) B. Liabilities (Cont.) 3. Lang Term Debt a. Changes in Long -Term Debt Fund Debt Balances Adjustments/ Balances Retired By May 1 Issuances Retirements April 30 General Obligation Bonds Sewerage Improvement Bond Series of 1973 ($1,080,000 dated June 1, 1973; maturing December 1, 1992; payable in annual installments; interest rates from 4.4% to 5.1%) Sewer Treatment Facility Bond Series of 1973 ($2,000,000 dated June 1, 1973; maturing December 1, 1992; payable in annual installments; Debt interest rates from 4.4% to 6.0%) Service Corporate Purpose Bond Series of 1982 ($500,000 dated October 1, 1982; maturing December 1, 1994; payable in annual installments; Debt interest rates from 9.60% to 10.25%) Service Corporate Purpose Bond Series of 1982-A ($500,000 dated December 1, 1982; maturing December 1, 1993; payable in annual installments; Debt interest rates from 7.0% to 8.5%) Service Corporate Purpose Bond Series of 1983 ($500,000 dated December 1, 1983; maturing December 1, 1988; payable in annual installments; Debt interest rates from 8.5%) Service Corporate Purpose Bond Series of 1986 ($11,000,000 dated May 1, 1986; maturing January 1, 2005; payable in annual installments; Debt interest rates from 6.40% to 7.75%) Service Corporate Purpose Bond Series of 1987 ($10,000,000 dated October 8, 1987; maturing October 8, 2002) Debt Service $ 400,000 $ 75,000 $ 325,000 125,000 675,000 25,000 425,000 125,000 125,000 125,000 10,775,000 $10,000,000 10,000,000 $13,150,000 $10,000,000 $525,000 $22,625,000 35 1 1 1 1 1 1 1 1 t 1 1 t i 1 1 1 1 1 VMLAGE OF DMTIaD, IILIWIS NOTES TO TIC FINANCIAL SL4TEHMTS APRIL 30, 1988 3. Detail Notes on All Rmds and Account Groups Wont.) B. Liabilities (font.) 3. IDng-%rm Debt (Cont.) a. Changes in Long-Tenm Debt (font.) Fund Debt Balances Adjustments/ Balances Retired By May 1 Issuances Retirements April 30 Revenue Bonds Water Revenue Bond Series of 1960 ($125,000 dated January 1, 1960; maturing May 1, 1989; payable in annual installments; interest rates from 4.257. to 4.75%) Water $20,000 $10,000 $10,000 Water Revenue Bond Series of 1959 ($545,000 dated April 1, 1959; maturing May 6, 1989; payable in annual installments; interest rates fram 4.25% to 5.00%) Water 70,000 35,000 35,000 $90,000 - $45,000 $45,000 Special Assessment Bonds (callable; interest rates Special from 6.0`/ to 7.0%/) Assessment $64,587 - - $64,587 b. Corporate Purpose Bond Series of 1987 The Village issued $10,000,000 of Corporate Purpose Bonds. (Actual proceeds including premium - $10,738,573). Part of the proceeds of this issue have been deposited with an escrow agent to pay the debt service requirements on the Corporate Purpose Bond Series of 1987. These fiords have been used to purchase Dade County, Florida Aviation Revenue Bonds and recorded in the Corporate Purpose Bond Series of 1987 Redemption Rmd (Expendable Trust). This transaction does not constitute defeasance of debt under CASB Statement No. 7 - Advance Refunding of Debt. 36 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 3. Detail Notes on All Funds and Account Groups (Cont.) B. Liabilities (Cont.) 3. Long -Term Debt (Cont.) c. Debt Service Requirements to Maturity ANNUAL PRINCIPAL AND INTEREST REQUIREMENTS Fiscal Year General Special Ending Obligation Revenue Assessment April 30 Bonds Bonds Bonds* 1989 $ 2,314,123 $46,913 $64,587 1990 2,273,638 1991 2,342,138 1992 2,326,988 1993 2,338,750 1994 2,110,013 1995 2,038,800 1996 1,952,905 1997 1,955,785 1998 1,955,485 1999 1,951,925 2000 1,955,025 2001 1,954,025 2002 8,659,825 2003 4,240,613 2004 1,111,350 2005 1,115,538 $42,5961926 $46,913 $64,587 Totals $ 2,425,623 2,273,638 2,342,138 2,326,988 2,338,750 2,110,013 2,038,800 1,952,905 1,955,785 1,955,485 1,951,925 1,955,025 1,954,025 8,659,825 4,240,613 1,111,350 1,115,538 4IIA9 Ina /19A 1 1 7 A 1 * callable and have been allocated to the most current year. I These bonds are calla e y 37 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS ' APRIL 30, 1988 1 3. Detail Notes on All Funds and Account Groups (Cont.) ' B. Liabilities (Cont.) 3. Long -Term Debt (Cont.) c. Legal Debt Margin The Village is a home rule municipality. Article VII, Section 6(k) of the 1970 Illinois Constitution governs computation of the legal debt margin. "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 percentages 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. d. Revenue Bond Ordinance Disclosures 1) Water Fund a) The ordinance authorizing the issuance of the Water Revenue Bond Series of 1959 and the subsequent Water Revenue Bond Issue of 1960 provided for the creation of separate accounts designated as "Operations and Maintenance ' Account," "Principal and Interest Account," "Depreciation Account," "Bond Reserve Account," "Surplus Account," "Improvement and Extension Account," and "Bond Redemption Account" into which accounts there shall be credited as of the first day of each month except as hereinafter provided for the Improvement and Extension Account and the Bond Redemption Account, all monies of the system in accordance with the following priority. Operation and Maintenance Account - An amount sufficient to cover the estimated operating and maintenance expense of the water system for the current month. 11 38 ' VILLAGE OF DEERFIELD. ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30. 1988 3. Detail Notes on All Funds and Account Groups (Cont.) B. Liabilities (Cont.) 3. Long -Term Debt (Cont.) d. Revenue Bond Ordinance Disclosures (Cont.) 1) Water Fund (Cont.) a) (Cont. ) Bond Principal and Interest Account - an amount at least equal to the sum of one -sixth of the interest becoming due on the next interest payment date, and one -twelfth of the aggregate yearly amount of principal due on the next principal maturity date. Depreciation Account - the sum of $250 each month until such account aggregates the sum of $15,000. Funds accumulated shall be used for replacements or unusual repairs for which funds are not otherwise available. Bond Reserve Account - an amount of $950 each month until such account aggregates the sum of $52,000. Funds accumulated shall be used for the payment of bond principal and interest, should the amount available in the bond principal and interest account be insufficient to meet the payments when due. Surplus Account - any monies remaining each month after providing for the credits to the above listed accounts shall be credited to the surplus account. At the end of each fiscal year, funds in this account shall be used to make up deficiencies in the prior accounts, 50% of the remaining amounts be transferred to an Improvement and Extension Account accumulated up to a maximum of $100,000, and all money then remaining in the surplus account may be used for the following purposes: A. Create a Bond Redemption Account B. Accelerate the accumulation of funds In aforementioned accounts C. Used for any lawful corporate purpose 1 I 1 1 39 1 1 1 1 1 1 1 1 1 i 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 3. Detail Notes on All Funds and Account Groups (Cont.) B. Liabilities (Cont.) 3. Long -Term Debt (Cont.) d. Revenue Bond Ordinance Disclosures (Cont.) 1) Waterworks and Sewerage Fund (Cont.) b) Supplemental information required under bond ordinance provisions, not subject to audit: Metered Customers 5,646 Unmetered Customers - Hydrants 734 Gallons Pumped 977,213,000 Gallons Billed 840,307,523 Connecting Properties 5,687 4. Industrial Revenue Bonds The Village entered into agreements with Chi-Chi's, Inc., Teradyne, Inc., and Industrialplex Limited Partnership in which the Village has authorized the issuance of Industrial Revenue bonds in the following amounts: Chi-Chi's, Inc. $1,615,000 Trustee - The Citizens Fidelity Bank and Trust of Kentucky Teradyne, Inc. $1,000,000 Trustee - State Bank and Trust of Boston Industrialplex Limited Partnership $4,500,000 Trustee - American National Bank and Trust Company of Chicago The Village has no liability under these bond issues. 40 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 3. Detail Notes on All Funds and Account Groups (Cont. C. Interfund Receivables and Payables Due Due From To General General Municipal Audit $ 152 $ 36 Emergency Services/Disaster 194 .17 Street and Bridge 821 Illinois Municipal Retirement 1,059 1,112 Debt Service 419 3,830 Tax Incremental Finance District 2 400,000 Sewerage 1,686 Refuse 1,454 Garage 2,513 Police Pension 599 Deposit 10,707 414,217 10,382 Special Revenue Municipal Audit General 36 152 Illinois Municipal Retirement 57 93 152 Emergency Services/Disaster General 17 194 Illinois Municipal Retirement 14 31 194 Youth Bound Garage 362 Library Illinois Municipal Retirement 10,723 Debt Service 190 10,913 Street and Bridge General 821 Debt Service 310 222 Refuse 2,300 Garage 7,439 Police Pension 669 1,131 10,630 1 1 1 1 i i i 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30. 1988 3. Detail Notes on All Funds and Account Groups (Cont.) C. Interfund Receivables and Payables (Cont.) Due Due From To Special Revenues (Cont.) Illinois Municipal Retirement General $ 1,112 $ 1,059 Municipal Audit 57 Emergency Services/Disaster 14 Library 10,723 Debt Service 572 7,463 1,684 19,316 Total Special Revenues 13,852 30,654 Debt Service Debt Service General 3,830 419 Library 190 Street and Bridge 222 310 Illinois Municipal Retirement 7,463 572 Refuse 419 Police Pension 324 Total Debt Service 11,515 2,234 Capital Projects Tax Incremental Finance District 1 Brickyards Development 170,000 Tax Incremental Finance District 2 General 400,000 Brickyards Development Tax Incremental Finance District 170,000 Total Capital Projects 170,000 570,000 Enterprise Water Garage 446 Sewerage General 1,686 Garage 1,915 3,601 41 42 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 3. Detail Notes on All Funds and Account Groups (Cont.) i C. Interfund Receivables and Payables (Cont.) Due Due From To Enterprise (Cont.) Refuse General $ 1,454 Street and Bridge 2,300 Debt Service 419 4,173 Total Enterprise 4,173 $ 4,047 Internal Service Garage General 2,513 Youth Bound 362 Street and Bridge 7,439 Water 446 Sewerage 1,915 Total Internal Service 12,675 Trust and Agency Police Pension General 599 Street and Bridge 669 Debt Service 324 1,592 Deposit General 10,707 Total Trust and Agency 1,592 10,707 Total All Funds $628,024 $628,024 1 1 1 1 t i i 1 1 1 1 1 1 1 1 1 1 1 1 43 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 3. Detail Notes on All Funds and Account Groups (Cont.) D. Fund Equity 1. Reservation of Retained Earnings Retained Earnings - Reserved - Restricted Accounts represents amounts required to be segregated by bond ordinance provisions. 2. Reservation of Fund Balance Reserves are used to segregate portions of fund balances which are either legally restricted for specific purposes or not "available spendable resources". 3. Designation of Fund Balance Designated Fund Balance is used to segregate portions of fund balance intended by management for future expenditures. The Village has designated $1,522,000 for area improvements in the General Fund. 44 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STAT2=S APRIL 30, 1988 4. Segment Information for Certain Individual Enterprise Funds The Village maintains 4 Enterprise Finds which provide water, sewerage, refuse and paikirg services Segment information for the year ended April 30 is as follows: Operating Revenues Depreciation, Depletion, and Amort izat ion Expense Operating Income or (Lass) Operating Transfers Out Tax Revenues Net Incone (Loss) Contributed Capital Contributions Plant, Property and Equipment Additions Deletions Total Assets Net kbrki.ng Capital Bonds and Other Long -Term Liabilities Payable fran Operating Revenues Total Equity Commuter Thter Seuerage Refuse Parking In. t Fund Fund Fund Fund Totals $1,984,088 $1,070,821 $ 453,555 $ 91,181 $ 3,599,645 106,240 249,510 - 30,698 386,448 123,941 (184,266) (503,710) 37,301 (526,734) - - - (20,000) (20,000) - - 485,998 - 485,998 161,118 (127,985) 20,052 17,301 70,486 2,012,347 2,072,000 - - 4,084,347 2,032,810 2, 0 79, 311 - - 4,112,121 3,811,710 8,168,725 580,525 627,593 13,188,553 1,217,396 1,156,769 501,802 208,851 3,084,818 45,000 - - - 45,000 3,647,298 8,061,369 501,802 626,209 12,836,678 45 ' VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 5. Related Entities ' A. Joint Ventures Municipal Insurance Cooperative Agency (MICA) 1. Description of Joint Venture The Municipal Insurance Cooperative Agency is a proprietary joint venture whose members are Illinois municipalities. MICA manages and funds first party property losses, third party liability claims, and Worker's Compensation claims of its member municipalities. 1 Each member municipality has self-insurance retentions at various amounts. ' Management consists of a Board of Directors comprised of one representative from each member. In addition, there are two officers, a Risk Manager and a Treasurer. The Village does not exercise any control over the activities of the Agency beyond its representation on the Board of Directors. 2. Summary Financial Information of Joint Venture ' There are no available financial statements of the Agency at April 30, 1988. Therefore, MICA has not been reflected in the financial statements at April 30, 1988. ' Initial contributions are determined in advance of each membership year based on the individual member's eligible revenue as defined in the bylaws of MICA and assessment factors based on past member experience ' and the funding needs for the membership year. The Board of Directors may require that supplemental contributions be made by members to ensure adequate funds are available to meet the obligations applicable to the membership year. Members have a contractual obligation to fund any deficit of MICA attributable to a membership year during which they were a member. It is estimated that the equity on the MICA financial statements when issued will be zero and that the Village's net ' investment in MICA will also be equal to zero. �1 46 ' VILLAGE OF DEERFIELD. ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 5. Related Entities (Cont.) A. Joint Ventures (Cont.) High -Level Excess Liability Pool 1. Description of Joint Venture The High -Level Excess Liability Pool (the "Agency") was organized on April 1, 1987. The purpose of the Agency is to act as a joint self- insurance pool for the purpose of seeking the prevention or lessening of liability claims for injuries to persons or property or claims for errors and omissions made against the Members and other parties included within the scope of coverage of the Agency. At April 30, 1988, the following municipalities were members of the Agency: Village of Arlington Heights 11.70% Village of Mount Prospect 7.79% Village of Chicago Ridge 2.24 Village of Oak Lawn 9.27 Village of Deerfield 3.59 City of Park Ridge 5.86 City of Des Plaines 11.43 Village of Skokie 10.55 Village of Elk Grove Village 7.67 Village of Streamwood 4.20 Village of Glenview 6.24 City of Wheaton 7.01 Village of Hoffman Estates 6.62 Village of Winnetka 4.48 Village of Lincolnshire 1.35 100.00%* These percentage shares are subject to change in future years based upon a formula specified in the Agency Agreement. The Agency is governed by a Board of Directors which consists of one representative from each member municipality. Each Director has an equal vote. The officers of the Agency are appointed by the Board of Directors. The Board of Directors determines the general policy of the Agency, makes all appropriations, approves contracts, adopts resolu- tions providing for the issuance of debt by the Agency, adopts by-laws, rules and regulations, and exercises such powers and performs such duties as may be prescribed in the Agency Agreement or the by-laws. The Village does not exercise any control over the activities of the Agency beyond its representation on the Board of Directors. The Village accounts for its share of HELP through its General Fund, using the equity method of accounting as provided for by GASB Codification Section J50. 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STAMENIS APRIL 30, 1988 5. Related Entities (Cont.) A. Joint Ventures (Cont.) High -Level Excess Liability Pool (Cont.) 2. Summary Financial Information of Joint Venture a. Sumary of Financial Position as of April 30, 1988 Assets Liabilities and Fund Equity Current Assets Current Liabilities Cash and Investments Accounts Payable $ 4,352 Unrestricted $ 937,558 Claims Payable 50,000 Escrow Agreement 5,480,740 We to Village of 6,418,298 Elk Grove Village 350,000 Accrued Interest Payable 131,949 Receivables Due to Members 52,197 Accounts 83,554 Deferred Revenues 556,686 Accrued Interest 11,898 1,145,184 95,452 long -Term Liabilities We to Village of Elk Grove Village 4,650,000 Total Liabilities 5,795,184 Fund Equity Retained Earnings 718,566 Total Liabilities Total Assets $6,513,750 and Fund. Equity $6,513,750 47 48 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 5. Related Entities (Cont.) A. Joint Ventures (Cont.) High -Level Excess Liability Pool (Cont.) 2. Summary Financial Information of Joint Venture (Cont.) b. Summary of Revenues, Expenses, and Changes in Retained Earnings for the year ended April 30, 1988. Operating Revenues $ 962,059 Operating Expenses 88,542 Operating Income 873,517 Nonoperating Revenues (Expenses) Interest Income 78,302 Interest Expense (118,754) Bond Issuance Expenses (114,499) 054,951) Net Income 718,566 Retained Earnings May 1 - April 30 $ 718,566 49 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 5. Related Entities (Cont.) A. Joint Ventures (Cont. High -Level Excess Liability Pool (Cont.) 2. Summary Financial Information of Joint Venture (Cont.) C. Village's Share of Assets, Liabilities, Fund Equity and Changes for the year ended April 30, 1988 Balances Increases Balances May 1 (Decreases) April 30 Total Assets - $233,844 $233,844 Total Liabilities $208,047 $208,047 Fund Equity Retained Earnings - 25,797 25,797 Total Liabilities and Fund Equity - $233,844 $233,844 d. Village's Share of: Net Income $ 25,797 e. Joint Venture Debt I. Changes in Long -Term Debt Balances May 1 Due to Village of Elk Grove Village for Retirement of General Obligation Bonds - Balances Issuances Retirements April 30 $5,000,000 - $5,000,000 50 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 5. Related Entities (Cont.) A. Joint Ventures (Cont.) High -Level Excess Liability Pool (Cont.) 2. Summary Financial Information of Joint Venture (Cont.) e. Joint Venture Debt (Cont.) 2. Security for the Debt The Village of Elk Grove Village, Illinois (the initial Host Member) issued $5,000,000 of general obligation bonds in 1987 to provide initial funding for the Agency. The bond proceeds were put into escrow with LaSalle National Bank as escrow agent. An intergovernmental agreement among the Agency, the Village of Elk Grove Village, and the Members provides that the Agency and its Members are obligated to the Village of Elk Grove Village for payment of principal and interest on the bonds until such bonds have been retired. Additionally each Member is liable for its proportionate share of any default by other Members. The obligations of the Agency and its Members are unconditional. 6. Significant Contingencies A. Litigation There are several pending lawsuits in which the Village is involved. The Village Attorney estimated that the potential claims against the Village not not covered by insurance resulting from such litigation would not materially affect the financial statements of the Village. B. Contingent Liabilities 1. The Village participates in a number of federally assisted grant programs, principal of which is the Federal Revenue Sharing Program. These programs are subject to program compliance audits by the grantors or their representatives. The audits of these programs for or including the year ended April 30, 1988 have not yet been conducted. Accordingly, the Village's compliance with applicable grant requirements will be established at some future date. The amount, if any, of expenditures which may be disallowed by the granting agencies cannot be determined at this time although the Village expects such amounts, if any, to be immaterial. 1 1 1 �I' 51 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 6. Significant Contingencies (Cont.) B. Contingent Liabilities (Cont.) 2. The Village's agreement with the High -Level Excess Liability Pool provides that each member is liable for its proportionate share of any costs arising from defaults in payment obligations by other members. 7. Insurance A. The Village participates in the Municipal Insurance Cooperative Agency MICA. MICA is a proprietary joint venture whose members are Illinois municipalities. MICA manages and funds first party property losses, third party liability claims, Workers' Compensation claims, and Public Officials Liability claims of its member muncipalities. Deductibles, self -insured retentions, and excess coverages are as follows: Property General Liability Auto Liability Workers' Compensation Self - Insured Deductibles Retentions $1,000 $ 50,000 1,000 1,000 75,000 50,000 150,000 Excess (Maximum Coverage inclusive of Deductibles and Retentions) (1) $ 50,000 - 500,000 (2) 500,000 - 1,000,000 (3) 1,000,000 - 30,000,000 (1) 75,000 - 250,000 (2) 250,000 - 1,000,000 (1) 50,000 - 500,000 (2) 500,000 - 1,000,000 (1) 150,000 - 250,000 (2) 250,000 - 30,000,000 The Village's payments to MICA are displayed on the financial statements as expenditures/expenses in appropriate funds. 52 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1988 7. Insurance (Cont.) B. The Village has purchased employee benefit insurance from private insurance companies. Premiums have been displayed as expenditures/expenses in appropriate funds. C. The Village participates in the High -Level Excess Liability Pool (HELP). HELP is a joint venture established by certain municipalities in Illinois to provide excess liability coverage ($5,000,000 of coverage after a $1,000,000 self-insurance retention). The Village's payments to HELP are displayed on the financial statements as expenditures/expenses in appropriate funds. 1 w 1 1 A 1 u i P-A J 1 I GOVERNMENTAL FUND TYPES I I I I I I 'I I I I GENERAL FUND I 1 i Fund Description It General Fund General Fund - (also referred to as the Corporate Fund) To account for resources traditionally associated with governmental services not required to be accounted for in another fund. 11 I 1 1 r I I 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND BALANCE SHEET APRIL 30. 1988 1988 1987 ASSETS Cash and Investments $3,174,359 $3,215,044 Receivables Property Taxes 194,667 285,102 Accrued Interest 43,098 67,361 Other 145,113 106,776 Due from Other Governments Sales Tax 128,620 133,307 State Income Tax 54,188 58,812 Court Fines 10,089 14,346 Due from Other Funds 414,217 6,003 Investment in Joint Venture - HELP 16,123 Total Assets $4,180,474 $3,886,751 LIABILITIES AND FUND BALANCE Liabilities Accounts Payable $ 166,582 $ 79,107 Accrued Payroll 53,863 36,271 Contracts Payable 33,037 127,986 Compensated Absences Payable 259,222 246,329 Other Payables 30,803 15,373 Due to Other Funds 10,382 7,294 Deferred Property Taxes 220,000 320,000 Total Liabilities 773,889 832,360 Fund Balance Unreserved Designated - Capital Improvements 1,522,000 1,522,000 Undesignated 1,884,585 1,532,391 Total Fund Balance 3,406,585 3,054,391 Total Liabilities and Fund Balance S4.180.474 93.886.751 See accompanying Notes to the Financial Statements. 53 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30. 1988 Revenues Taxes Licenses and Permits Intergovernmental Charges for Services Fines and Forfeits Miscellaneous Total Revenues Expenditures General Government Public Safety Total Expenditures Excess (Deficiency) of Revenues over Expenditures before Other Financing Sources (Uses) Other Financial Sources (Uses) Operating Transfers In (Out) Youth Bound Fund Street and Bridge Fund Federal Revenue Sharing Fund Transportation Fund Debt Service Fund Tax Incremental Finance District 2 Fund Police Pension Fund Excess (Deficiency) of Revenues and Other Sources over Expenditures and Other Uses Fund Balance May 1 Residual Equity Transfer (Out) Vehicle Replacement Fund April 30 1988 Budget Actual $2,690,000 244,000 10,000 94,000 225,000 365,000 3,628,000 $2,806,194 224,492 1,703 83,409 240,598 648,067 4,004,463 1987. Actual $2,765,809 308,460 6,457 97,954 257,723 466,171 3,902,574 1,325,125 1,246,347 1,196,644 2,392,332 2,251,474 2,136,248 3,717,457 3,497,821 3,332,892 (89,457) 506,642 569,682 (4,000) (4,000) (4,000) (135,000) 2,807 130,000 (2,000) (2,000) (2,000) 4,000 (16,255) (900) (6,000) (154,448) 127,100 $ (95,457) 352,194 696,782 See accompanying Notes to the Financial Statements. 1 1 1 3,054,391 2,957,609 , (600,000) 3,054,391 2,357,609 $3,406 585 $3 054 391 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND SCHEDULE OF REVENUES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1988 Taxes Property Taxes - General Sales Tax Income Tax Hotel Motel Tax Licenses and Permits Beer/Liquor Licenses Food Licenses Other Business Licenses Building Permits Animal Licenses Non -Business Licenses and Permits Vehicle Stickers Intergovernmental State Grants Charges for Services Special Police Services Transfer Charges Engineering Charges Fines and Forfeits Miscellaneous False Alarms Sale of Materials Rentals Interest Miscellaneous Franchise Fees Income from Joint Venture Total Revenues r, Budget Actual $ 320,000 $ 328,281 1,725,000 1,788,844 430,000 476,920 215,000 212,149 2,690,000 2,806,194 45,000 45,313 3,000 4,130 9,000 9,817 140,000 131,300 7,000 4,552 25,000 29,380 15,000 244,000 224,492 10,000 1,703 53,000 44,393 36,000 36,000 5,000 3,016 94,000 83,409 225,000 240,598 30,000 18,860 1.,078 40,000 38,525 175,000 285,241 20,000 150,860 100,000 137,380 16,123 365,000 648,067 $3,628,000 $4,004,463 55 56 , VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1988 Budget Actual General Government Administration Department Salaries $ 651,963 $ 6119940 Overtime 7,500 15,323 Part -Time 72,662 68,396 Employee Benefits 86,600 71,305 Professional Services 185,500 166,646 Travel, Training and Dues 17,500 13,365 Printing and Advertising 11,000 12,034 Communications 21,000 16,489 Insurance 71,300 65,870 Contractual Services 47,000 50,144 Utility Services 2,600 2,064 Motor Vehicle Maintenance 7,000 3,412 Repairs and Maintenance 58,000 27,558 Equipment Rental 500 408 Rental Property Repairs 3,000 1,326 Miscellaneous 29,000 16,764 Supplies 19,000 19,385 Materials 2,000 1,827 Motor Vehicle Supplies 2,000 2,093 Dog Pound 3,054 Housing Assistance 10,000 9,750 Apparel 300 181 Small Tools and Equipment 1,000 140 Equipment 6,000 5,209 Land Acquisition 2,200 2,051 Advisory Boards 16,197 Motor Vehicles 10,500 8,500 1,325,125 1,211,431 Computer Project Contractual Services 33,351 Equipment 1,565 34,916 Total General Government $1,325,125 $1,246,347 11 A 57 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL (CONT.) FOR THE YEAR ENDED APRIL 30, 1988 n Budget Actual Public Safety Police Department Administrative Service Salaries $ 339,000 $343,067 Overtime 5,000 724 Part -Time 14,500 13,580 Employee Benefits 38,952 33,712 Professional Services 5,600 3,429 Travel, Training and Dues 4,800 3,075 Printing and Advertising 6,650 4,801 Communications 27,600 25,193 Insurance 141,300 127,727 Contractual Services 35,830 22,973 Motor Vehicle Maintenance 2,000 1,033 Repairs and Maintenance 7,600 10,484 Supplies 12,200 13,124 Apparel 1,000 354 - Equipment 3,750 2,570 Motor Vehicles 15,400 11,816 Miscellaneous 7,000 4,256 668,182 621,918 Investigations Salaries 114,400 114,850 Overtime 10,200 4,448 Employee Benefits 13,995 13,053 Travel, Training and Dues 1,350 174 Contractual Services 14,000 13,783 Motor Vehicle Maintenance 2,000 3,182 Repairs and Maintenance 1,000 52 Supplies 5,000 1,950 Motor Vehicle Supplies 1,000 584 Apparel 1,200 1,206 Equipment 500 164,645 153,282 Patrol Salaries 1,019,163 993,495 Overtime 48,004 32,935 Part -Time 43,020 30,667 Employee Benefits 108,173 97,968 Travel, Training and Dues 18,250 11,664 Motor Vehicle Maintenance 26,930 25,946 I 58 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL (CONT.) FOR THE YEAR ENDED APRIL 30, 1988 Budget Actual Public Safety (Cont.) Police Department (Cont.) Patrol (Cont.) Repairs and Maintenance $ 2,000 $ 1,056 Supplies 7,000 4,004 Motor Vehicle Supplies 25,000 18,227 Apparel 13,600 14,189 Equipment 2,500 1,738 Motor Vehicles 61,000 78,502 1,374,640 1,310,391 Special Services Salaries 18,496 13,641 Youth Services Salaries 132,000 127,483 Overtime 8,300 3,090 Employee Benefits 15,744 13,028 Travel, Training and Dues 1,600 431 Motor Vehicle Maintenance 2,500 274 Repairs and Maintenance 1,500 1,159 Supplies 925 77 Motor Vehicle Supplies 2,000 1,025 Apparel 800 683 Contractual Services 4,992 Equipment 1,000 166,369 152,242 Total Public Safety 2,392,332 2,251,474 Total Expenditures $3,717,457 $3,497,821 1 i I 1 i 11 r I n SPECIAL REVENUE FUNDS I Fund Descriptions IMunicipal Audit Fund Municipal Audit Fund - An independent, outside audit is conducted by a firm engaged by the Mayor and Board of Trustees on an annual basis as required by State law. These are earmarked funds that can only be expended for audit purposes. 1 Emergency Services/Disaster Fund Emergency Services and Disaster Fund - The Emergency Services and Disaster Agency supersedes the Civil Defense Agency and now basically relates to natural disasters caused by floods and tornadoes. The Agency also prepares a plan of action to be taken if man-made disasters occur. Youth Bound Fund Youth Bound Fund - Accounts for the revenues collected and the expenditures incurred for this unique and very successful youth project of the Deerfield Police Department. a I Library Fund Library Fund - To account for the resources necessary to provide the educational, cultural and recreational activities of the Deerfield Public Library. Street and Bridge Fund Street and Bridge Fund - Accounts for the revenues and resources used in main- taining approximately 70 miles of street and the Railroad Station in the Village of Deerfield. Illinois Municipal Retirement Fund Illinois Municipal Retirement Fund - To account for the revenues and expenditures associated with providing disability and pension benefits for Deerfield employees. The fund also provides the employer with a portion of F.I.C.A. Contributions. Public Benefit Fund Public Benefit Fund - To account for the public benefit portion of local improvements installed under the special assessment procedure of financing is paid from this fund. A Fund Descrivtions Federal Revenue Sharing Fund Federal Revenue Sharing Fund - Provides accountability for Federal Revenue Sharing revenues received under Title I of the State and Local Fiscal Assistance Act of 1972. Motor Fuel Tax Fund Motor. Fuel Tax Fund - To account for the activities involved with street maintenance and construction. Financing is provided by the Village's share of State gasoline taxes. State law required these gasoline taxes to be used for the following purposes: (1) Street construction or reconstruction to improve traffic capacity; (2) Installation of traffic signs, signals, and controls; (3) Sidewalk repair and replacement; and (4) The public benefit share of new street improvements when certain criteria are met in connection with a special assessment project. Transportation Fund Transportation Fund - To account for the Taxi Subsidy Program established for senior citizens and the handicapped. 59 E 1 1 1 1 1 1 1 1 1 1 1 1 1 C, O r'M �OJ n O N oo c 8 ...i M J Op t+l �-Wy N to (A N F+ i 1 tJ+l p W� O n u~'1 00 Vl N �T 'O C�1 'n M O CO I� J t� C 1� On0 O 00 I^+ N N ^+ v .Ny .-.i tM+l 00 O m 00 Lfi O 00 Co W O N 4i O J N v O �M�pp u V1 N �D OOV? W Vj to •D �I I I I I I w � M N M Nen N N A t? I v> lo 51 IJ ij M Go y •rUi 'y7 N M ID ti Z I •�• M aN Cppn C � � � � v .�� .M-i V1 8M � (M'1' n �D n a�D ocp ✓1 M UN 4 M N �MO� pOp NJn ONN OD W N vll NII 0.' a0 00 M c rn co Cli O ao o M O pMp O N O pMp p J �O O 1� 0N0 N O �w�w�w�wjjjj 10� M u'1 In C144V> C, cq C a F+ J U N U V1 n N l'1I J �p O N pp cV pp O I� �p pI pUp 0u0� {+S N O, I � N a 4101 'i cl 8 O M C\ M I V� I I .�i �71 �O M OI.--� N N til �CyyNl�� vrll U �11a 10 4 al� u N a F c7 E O! w H b O F3 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 i mo Ico 00 Eo !OO �2 4- N �© N y IWIW IIOD IFI O A f]9 IOI I� I� � lol ~O IP.7 O 41 W I 01 I OI OD � I`G UPI W O In In In F N O V O V Q� .F-. �F-. kp c P a, ~ ID p y C�• 'I � F OD � W lJ 10 n O N �?[� " ru, III III irt� � a' OND ONO W yN�j y� to In Vt V�i V V � 0 N prt 7 N Oho pW� N 2 r F O1 In o, W a, O, 00 Ro F O� OD pip W 00 tnof 00 �` O Oo In N kC N W O� V 0 IwN � R �G+ N ppN - p W N O N V QpQ� O O W O F v 61 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS MUNICIPAL AUDIT FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1988 Revenues Taxes Property Taxes Miscellaneous Interest Other Total Revenues Expenditures Miscellaneous Contractual Excess (Deficiency) of Revenues over Expenditures Fund Balance May 1 April 30 1988 1987 Budget Actual Actual $10,500 $10,772 $10,492 36 21 13 10,500 10,821 10,513 11,000 10,850 10,140 $ (500) (29) 373 12,252 11,879 $12,223 $12,252 See accompanying Notes to the Financial Statements. 62 VILLAGE OF DEERFIELD, ILLINOIS EMERGENCY SERVICES/DISASTER FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30. 1988 Revenues Taxes Property Taxes Miscellaneous Interest Other Total Revenues Expenditures Public Safety Travel, Training and Dues Communications Insurance Contractual Utility Services Motor Vehicle Maintenance Motor Vehicle Supplies Repairs and Maintenance Supplies Equipment Total Expenditures Excess (Deficiency) of Revenues over Expenditures Fund Balance May 1 April 30 1988 1987 Budget Actual Actual $5,000 $ 5,130 $ 4,996 17 11 6 5,000 5,153 5,007 600 496 499 1,400 1,747 1,514 600 365 409 300 156 169 100 116 100 800 1,488 269 200 37 500 755 500 211 245 500 450 5,500 5,334 3,692 $ (500) (181) 1,315 See accompanying Notes to the Financial Statements. 18,899 17,584 $18,718 $18,899 63 VILLAGE OF DEERFIELD, ILLINOIS YOUTH BOUND FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30. 1988 Revenues Charges for Services Project Income Expenditures Culture and Recreation Travel Advances Travel, Training and Dues Insurance Motor Vehicle Maintenance Motor Vehicle Supplies Repairs and Maintenance Supplies Equipment Communications Contractual Total Expenditures Excess (Deficiency) of Revenues over Expenditures before Other Financing Sources Other Financing Sources Operating Transfers In General Fund Excess (Deficiency) of Revenues and Other Sources over Expenditures Fund Balance May 1 April 30 1988 1987 Budget Actual Actual $14,000 $ 7,210 $10,554 4,085 450 779 348 600 395 442 5,000 5,895 4,382 900 628 676 200 4,800 849 4,735 300 57 1,800 1,582 1,718 2,800 1,544 2,698 16,850 15,757 15,056 (2,850) (8,547) (4,502) 4,000 4,000 4,000 $ 1,150 (4,547) (502) See accompanying Notes to the Financial Statements. 6,996 7,498 $ 2,449 $ 6,996 IM VILLAGE OF DEERFIELD, ILLINOIS LIBRARY FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30. 1988 Revenues Taxes Property Taxes Replacement Taxes Intergovernmental Grants Charges for Services Non -Resident Fees Fees, Fines, Penalties Reciprocal Borrowing Xerox Videos Miscellaneous Interest Gifts Reserve for Repairs and Replacement Other Total Revenues Expenditures Culture and Recreation Excess (Deficiency) of Revenues over Expenditures Fund Balance May 1 April 30 1988 1987 Budget Actual Actual $722,017 $689,406 $676,091 14,000 16,894 17,074 17,430 17,313 17,041 15,000 13,224 15,232 42,000 23,113 23,644 3,000 1,074 3,858 18,000 14,075 18,467 23,483 17,220 20,000 31,500 30,191 500 761 541 124,000 727 975,947 831,570 819,359 975,947 876,055 790,816 - (44,485) 28,543 See accompanying Notes to the Financial Statements. 307,634 279,091 $263,149 $307,634 1 65 ' VILLAGE OF DEERFIELD, ILLINOIS LIBRARY FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1988 1 I- Budget Actual Culture and Recreation ' Salaries - Professional $203,818 $195,849 Salaries - Non -Professional 279,899 274,659 Employee Benefits 25,000 23,849 Professional Services 15,000 14,800 Education, Travel and Dues 6,000 7,358 Communication 7,500 7,475 ' Insurance Contractual Services 13,000 11,000 2,396 8,206 Utilities 600 624 Repairs, Maintenance of Building and ' Equipment Building Supplies 34,000 34,337 Supplies - Library and Office 25,000 23,658 Books 92,000 79,270 Periodicals 22,000 22,731 Audio -Visual 16,000 28,706 Binding 1,000 645 Special Library Programs 3,000 2,920 Data Base 1,500 1,148 New Equipment 30,000 60,662 Printing 3,000 1,877 Computer Service 12,188 Cataloging Service 3,315 Miscellaneous 400 582 Automation Project Improvements - Parking Lot Wall 80,000 27,000 Improvements Other than Building 79,230 68,800 Total Expenditures $975,947 $876,055 11 VILLAGE OF DEERFIELD, ILLINOIS STREET AND BRIDGE FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1988 Revenues Taxes Property Taxes Other Taxes Licenses and Permits Vehicle Licenses Charges for Services State Highway Maintenance 50/50 Sidewalk and Curb 50/50 Tree Train Station Maintenance Miscellaneous Interest Other Total Revenues Expenditures Highways and Streets Administration Cleaning Traffic Marking Pavement Patching Tarring Cracks Drainage Structure Street Lights and Traffic Signals Miscellaneous Maintenance Snow and Ice Control Weed Control Leaf Removal. Tree Removal Tree Planting Railroad Station Maintenance Total Expenditures Excess (Deficiency) of Revenues over Expenditures before Other Financing Sources Other Financing Sources Operating Transfers In General Fund Commuter Parking Lot Fund Excess of Revenues and Other Sources over Expenditures Fund Balance May 1 April 30 See accompanying Notes to the Financial Statements. 1988 Budget Actual $ 250,000 $246,210 180,000 180,000 150,000 156,159 16,000 23,752 25,000 15,055 5,000 1,160 1,500 1,500 15,000 32,691 5,000 8,585 647,500 665,112 132,184 95,371 36,054 30,136 42,154 38,474 82,450 71,723 49,717 37,411 15,604 17,259 118,209 111,819 72,504 71,715 120,548 133,670 17,804 12,317 16,209 24,978 25,704 24,020 13,404 10,195 43,109 28,618 785,654 707,706 (138,154) (42,594) 135,000 135,000 20,000 20,000 155,000 155,000 $ 16,846 112,406 114,450 $226,856 1987 Actual $219,840 170,000 268,280 21,417 17,858 500 1,500 17,179 4,607 721,181 116,262 33,729 44,496 80,875 40,704 12,065 97,933 72,356 72,591 13,968 20,839 19,703 12,362 19,987 657,870 63,311 20,000 20,000 83,311 31,139 $114,450 1 67 1 VILLAGE OF DEERFIELD, ILLINOIS STREET AND BRIDGE FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1988 Budget Actual Highways and Streets Public Works Administration Salaries $ 51,670 $23,436 Overtime 3,700 84 Employee Benefits 3,314 6,331 Professional Services 2,200 625 Travel, Training and Dues 1,000 1,810 Printing and Advertising 4,400 797 Communications 4,600 1,885 Other 48,600 47,488 Motor Vehicle Maintenance 2,000 1,843 Miscellaneous 2,200 3,962 Supplies 3,000 1,769 Motor Vehicle Supplies 1,200 1,399 Apparel 1,600 1,490 Repairs and Maintenance 1,500 610 Contractual 1,200 1,842 132,184 95,371 Cleaning Salaries 14,570 13,107 Overtime 1,100 1,339 Employee Benefits 1,884 1,965 Small Tools and Equipment 500 179 Contractual 3,700 2,225 ' Motor Vehicle Maintenance Repairs and Maintenance 4,000 5,500 1,572 6,232 Equipment Rental 1,500 Motor Vehicle Supplies 1,500 1,835 Supplies 1,800 1,682 36,054 30,136 Traffic Marking Salaries 14,570 16,390 Overtime 300 116 Part -Time 2,600 2,285 ' Employee Benefits 1,884 2,122 Motor Vehicle Maintenance. 1,000 153 Repairs and Maintenance. 800 541 Motor Vehicle Supplies 500 81 68 1 VILLAGE OF DEERFIELD, ILLINOIS , STREET AND BRIDGE FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL (CONT.) FOR THE YEAR ENDED APRIL 30, 1988 Highways and Streets (Cont.) Budget Actual Public Works (Cont. Traffic Marking (Cont.) Materials $ 4,000 $ 1,682 Street Signs 6,500 4,706 Contractual 10,000 10,398 42,154 38,474 Pavement Patching Salaries Overtime 30,379 1,200 30,287 163 Employee Benefits 4,971 3,611 Motor Vehicle Maintenance 5,000 3,799 Repairs and Maintenance 5,500 1,006 Supplies 600 Motor Vehicle Supplies 2,000 1,149 Aggregates 30,800 30,811 Materials 2,000 897 82,450 71,723 Tarring Cracks Salaries 19,130 14,911 Overtime 600 1,223 Part -Time 2,600 2,692 Employee Benefits 3,087 1,272 , Motor Vehicle Maintenance 1,400 1,488 Repairs and Maintenance 1,900 3,008 Motor Vehicle Supplies 3,000 1,155 Aggregates 500 14 Materials 15,000 11,648 Equipment Rental 2,500 49,717 37,411 Drainage Structures Salaries 6,075 8,529 Overtime 900 751 Employee Benefits 1,029 1,094 Motor Vehicle Maintenance 2,000 599 Repairs and Maintenance 2,300 3,569 Motor Vehicle Supplies 300 90 Aggregates 1,000 1,451 Materials 2,000 1,176 , 15,604 17,259 1 69 VILLAGE OF DEERFIELD, ILLINOIS STREET AND BRIDGE FUND ' SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL (CONT.) FOR THE YEAR ENDED APRIL 30. 1988 Budget Actual Highways and Streets (Cont.) Public Works (Cont.) Street Lights and Traffic Signals Salaries $ 6,980 $ 8,638 Overtime 1,100 655 Employee Benefits 1,029 1,101 Contractual 31,000 27,654 Utility Services 63,500 58,505 Motor Vehicle Maintenance 1,500 1,131 ' Repairs and Maintenance Equipment Rental 1,000 1,000 97 335 Motor Vehicle Supplies 800 393 Aggregates 300 451 Materials 10,000 12,859 118,209 111,819 Miscellaneous Maintenance Salaries 6,075 6,610 Overtime 1,100 2,040 Employee Benefits Contractual 1,029 53,700 711 43,391 Motor Vehicle Maintenance 1,000 1,718 Repairs and Maintenance 3,000 3,959 Small Tools and Equipment 300 226 Miscellaneous 500 1,292 Motor Vehicle Supplies 600 1,250 Aggregates 1,000 682 Materials 2,200 9,676 Equipment Rental 2,000 160 72,504 71,715 Snow and Ice Control Salaries 34,780 24,291 Overtime 9,400 24,021 Employee Benefits 3,768 2,753 Communications 800 216 Motor Vehicle Maintenance Repairs and Maintenance 7,000 18,000 10,530 29,707 Equipment Rental 1,000 Supplies 2,500 1,002 Motor Vehicle Supplies 5,300 3,323 Salt 32,000 35,259 70 VILLAGE OF DEERFIELD, ILLINOIS STREET AND BRIDGE FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL (CONT.) FOR THE YEAR ENDED APRIL 30, 1888 Highways and Streets (Cont.) Public Works (Cont.) Snow and Ice Control (Cont.) Aggregates Materials Weed Control Salaries Overtime Part -Time Employee Benefits Motor Vehicle Maintenance Repairs and Maintenance Motor Vehicle Supplies Materials Equipment Leaf Removal Salaries Overtime Employee Benefits Motor Vehicle Maintenance Repairs and Maintenance Motor Vehicle Supplies Supplies Tree Removal Salaries Overtime Part -Time Employee Benefits Contractual Motor Vehicle Maintenance Repairs and Maintenance Motor Vehicle Supplies Materials Equipment Equipment Rental Budget Actual $ 4,000 2,000 $ 2,568 120,548 133,670 6,075 1,608 100 143 2,600 1,913 1,029 458 1,000 205 3,000 4,536 500 281 3,000 3,173 500 17,804 12,317 6,980 8,587 2,200 6,828 1,029 1,124 1,500 739 4,000 6,790 500 775 135 16,209 24,978 6,075 7,518 600 756 4,100 2,892 1,029 913 9,000 9,591 700 617 600 1,334 400 102 2,200 297 500 500 25,704 24,020 71 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS STREET AND BRIDGE FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL (CONT.) FOR THE YEAR ENDED APRIL 30. 1988 Budget Actual Highways and Streets (Cont.) Public Works (Cont.) Tree Planting Salaries $ 6,075 $ 3,939 Overtime 400 94 Employee Benefits 1,029 1,184 Contractual 4,200 4,181 Motor Vehicle Maintenance 500 213 Repairs and Maintenance 300 247 Motor Vehicle Supplies 400 233 Materials 500 104 13,404 10,195 Railroad Station Maintenance Salaries 6,980 8,747 Overtime 900 271 Part -Time 3,600 2,275 Employee Benefits 1,029 830 Contractual Services 15,800 5,864 Utility Services 2,500 Repairs and Maintenance 2,400 1,887 Supplies 1,500 Aggregates 500 379 Materials 7,900 8,365 43,109 28,618 Total Expenditures $785,654 $707,706 72 VILLAGE OF DEERFIELD, ILLINOIS ILLINOIS MUNICIPAL RETIREMENT FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1988 Revenues Taxes Property Taxes Replacement Taxes Miscellaneous Interest Earnings Other Total Revenues Expenditures Miscellaneous Illinois Municipal Retirement Payments - Employer Excess (Deficiency) of Revenues over Expenditures 1988 Budget Actual $360,000 7,000 6,000 373,000 $333,410 6,995 12,795 404 353,604 1987 Actual $299,782 7,069 10,963 2,592 320,406 360,000 348,698 324,957 $ 13,000 4,906 (4,551) Fund Balance May 1 (19,609) (15,058) April 30 $0 4,703) $(19,609) See accompanying Notes to the Financial Statements. 73 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS PUBLIC BENEFIT FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1988 1988 1987 Budget Actual Actual Revenues Miscellaneous Interest $ 3,000 Other $ 2,000 Total Revenues 3,000 - 2,000 Expenditures General Government Contractual 7,000 - - Excess (Deficiency) of Revenues over Expenditures $(4,000) - 2,000 Fund Balance May 1 $63,273 61,273 April 30 $63,273 $63,273 See accompanying Notes to the Financial Statements. VILLAGE OF DEERFIELD, ILLINOIS FEDERAL REVENUE SHARING FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30. 1988 1988 Budget Actual Revenues Intergovernmental Entitlements Miscellaneous Interest Total Revenues Expenditures Miscellaneous Excess of Revenues over Expenditures before Other Financing (Uses) Other Financing (Uses) Operating Transfers (Out) General Fund Excess (Deficiency) of Revenues over Expenditures and Other Uses Fund Balance May 1 April 30 See accompanying Notes to the Financial Statements. 1987 Actual $ 25,434 10,433 35,867 15,000 20,867 $(2,807) (130,000) (2,807) (109,133) 2,807 111,940 $ 2,807 75 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS MOTOR FUEL TAX FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1988 1988 1987 Budget Actual Actual Revenues Intergovernmental Allotments Earned $295,000 $293,696 $294,011 Miscellaneous Interest 20,000 24,063 15,364 Other 5,275 698 Total Revenues 315,000 323,034 310,073 Expenditures Highways and Streets Street Maintenance 180,000 180,000 170,000 Street Resurfacing and Renovation Program 57,000 48,982 88,620 Total Expenditures 237,000 228,982 258,620 Excess of Revenues over Expenditures $ 78,000 94,052 51,453 Fund Balance May 1 307,798 256,345 April 30 $401,850 $307,798 See accompanying Notes to the Financial Statements. VILLAGE OF DEERFIELD, ILLINOIS TRANSPORTATION FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1988 Revenues Intergovernmental Grant Expenditures Miscellaneous Transportation Excess (Deficiency) of Revenues over Expenditures before Other Financing Sources Other Financing Sources Operating Transfers In General Fund Excess of Revenues and Other Sources over Expenditures Fund Balance May 1 April 30 1988 Budget Actual $ 5,000 7,000 (2,000) 2,000 See accompanying Notes to the Financial Statements. $5,022 1987 Actual $ 3,477 5,117 4,636 (95) (1,159) 2,000 2,000 1,905 841 5,095 4,254 $7,000 $ 5,095 1 :J DEBT SERVICE FUND 1 1 1 1 I I 11 [1 L DEBT SERVICE FUND 1 Debt Service Fund Fund Description ' Debt Service Fund - To account for the accumulation of resources for the payment of General Long -Term Debt. 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS DEBT SERVICE FUND BALANCE SHEET APRIL 30. 1988 ASSETS 1988 1987 Cash and Investments $1,762,020 $1,151,764 Receivables Property Taxes 968,191 975,878 Accrued Interest 13,387 35,125 Due from Other Funds 11,515 56,490 Total Assets $2,755,113 $2,219,257 LIABILITIES AND FUND BALANCE Liabilities Interest Payable Due to Other Funds Deferred Property Taxes Total Liabilities Fund Balance Reserved for Debt Service Total Liabilities and Fund Balance See accompanying Notes to the Financial Statements. $ 24,899 2,234 1,096,826 1,123,959 1,631,154 $2,755,113 $ 29,701 10,650 1,097,942 1,138,293 1,080,964 $2,219,257 77 78 ' VILLAGE OF DEERFIELD, ILLINOIS DEBT SERVICE FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1988 Revenues Taxes Property Taxes Replacement Taxes Miscellaneous Interest Other Total Revenues Expenditures .Debt Service Principal Retirement Interest Fiscal Charges Other Total Expenditures Excess (Deficiency) of Revenues over Expenditures before Other Financing Sources (Uses) Other Financing Sources (Uses) Operating Transfers In (Out) General Fund Tax Incremental Finance District 1 Fund Capital Improvements - Series A Fund Capital Improvements - Series B Fund General Obligation Bond Proceeds Payment to Escrow for Bond Redemption Excess (Deficiency) of Revenues and Other Sources over Expenditures and Other Uses Fund Balance May 1 April 30 1988 Budget Actual 1 1 1987 ' Actual $1,114,826 $ 1,148,224 $ 1,153,191 29,000 48,682 49,201 80,000 127,932 135,183 1,391 1,223,826 1,326,229 1,337,575 525,000 11,630,000 900,924 750,006 1,000 835 310,088 8,714 1,481,226 1,737,012 12,389,555 (257,400) (410,783) (11,051,980) (4,000) 222,400 222,400 208,712 (292,444) (202,661) 10,738,573 11,000,000 (10,000,000) 222,400 960,973 10,709,607 $ (35,000) 550,190 (342,373) See accompanying Notes to the Financial Statements. 1,080,964 1,423,337 $ 1,631,154 $ 1,080,964 79 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS DEBT SERVICE FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1988 Debt Service Sewerage Improvement Bond Series of 1973 Principal Interest Sewerage Treatment Facility Bond Series of 1973 Principal Interest Corporate Purpose Bond Series of 1983 Principal Interest Corporate Purpose Bond Series 1982 Principal Interest Corporate Purpose Bond Series 1982-A Principal Interest Corporate Purpose Bond Series of 1986 Principal Interest Fiscal Charges Other - Bond Issue Costs .Total Expenditures Budget $1,481,226 Actual $ 75,000 17,975 125,000 36,625 125,000 17,750 25,000 40,962 50,000 28,750 125,000 758,862 1,000 310,088 $1,737,012 1 I I fl I 1 CAPITAL PROJECT FUNDS I 1 IFund Descriptions Land Acquisition Fund Established in 1974 to acquire land in 'the area now known as The Brickyards. The funds remaining are held against the potential need of reimbursing the Illinois Department of Transportation in the event a retention pond is not constructed. Capital Projects Fund Established in 1983 to provide funds for the study and review of the Village of Deerfield Storm and Sanitary Sewer System. Tax Incremental Finance District 1 Fund Established in 1982 to provide funds for land acquisition and improvements to the Village of Deerfield Tax Increment Financing District. Tax Incremental Finance District 2 Fund Established in 1987 to provide funds for land acquisition and improvements to the Village of Deerfield Tax Increment Financing District. Capital Improvements Series A Fund Established in December, 1984, to provide funds for Storm Sewer Improvements, Sanitary Improvements and a Street Rehabilitation Program. Capital Improvements Series B Fund Established in December, 1985, to provide funds for major renovation to the Storm and Sanitary Sewers and a Street Rehabilitation Program. Brickyards Development Fund Established for the purpose of providing improvements to the area known as The Brickyards property. This includes construction of Culverts, Creek Realignment, and the extension of Pfingsten Road, which includes a bridge at Lake -Cook and an overpass at Kates Road. Vehicle Replacement Fund Established to account for the funds annually set aside for the eventual replacement of certain vehicles. O% (.4 00 r) Q, N C" 8 Np � d 00 J O W 00 1�10 co J CO 11u"1 00 I ^ O� O N L� F pp N c1 N v), Cfco ^ N a0 N LY1 cn 00 O N 'D On ^ N O� N � N n d In O en.-�Niw d 1�Ni N n NCIL 1 Q ID ool Ul a I w� Iq � O N Ow H66 H O� IDI ^ C C � JJ 00 O f�l O 00 X cn a,v, w �I cn OE1 ¢°' or yr a' oo x G CJ U fl 00 0'rn en N V1 1CI Q ry cn N N L W ^ u nl NI 1 I 1 N ^ .fir O � ca I m u 1 pp N ¢ Cg P r E O � � � � nµ� y�.� �yy � _ [❑rye, nY [x�� S+� � G � � " N n� N f�D �' �, fn0 � � 'f (� F'Y• F" 5G �Nrtf ^J �G N f0 rt - � X y M N ry 76 M �"1 1 � N O C SP N M rt r r V+ lNn In I Frt+ yn- v N N U1 I I UI I �.J N V V 2 F' ry rt 41 N N N QQ� �pNp �p Np N pp a, N N pF p (per poi O r ref N y�R V N N 2.0 v OD 00 OD F a {, ppop N N pDp �O In N TJ N n fyD iC OD l�n V�i W O O V Oo W N !- 1�\ 0000 eo00 l� lvt N N ONVO ONO 9 V N N � N �Npp ON+ NT W W W W O� In �Np 1 �Np O+ W W �Mp o 'pq� aJ (0��0 Ipp O N ppi W r+ N y I9 F+ V V O C! 7 N NW N41 N N N 01 w QOp+ pOp� 0�0 yN� N F F V OD O0+ pTp 1O OO OD V A F N 8 O V SOD pVp ��p E� V O H v InC31 a, N W N N IT pp�pp lr In N r800 1 Ir+ V v 10 10 t v v 01 V QO? pOp W p �pNp In � p11 W� N a, 00 00 O �-- yp. W A N r 00 OVG v O N D n F vNwON1p� OOt N(n N W N 100p pVp 0N0 1D NN l� lwn H VWi �O m 'D In OD In W �-' W N 00 D` I co I8 `"°" o1 viw 4- o o 00 W N In -I, O VWi A 1 I 1 1 1 1 1 1 1 1 I I SPECIAL ASSESSMENT FUNDS Fund Descriptions ISpecial Assessment Funds Special Assessments 3-84 Fund - This group of special assessments was issued prior to 1930 for various municipal projects. Special Assessment 111 Fund - This fund set up in 1974 to account for the collec- tion and disbursement of funds for the improvement of portions of Wilmot Road and Berkeley Court by construction of concrete curb and gutter, sidewalks and a bituminous transition pavement and including a storm drainage system where necessary. Special Assessment 112 Fund - This fund set up in 1975 to account for the collec- tion and disbursement of funds for the construction of concrete pavement, curb and gutter, sidewalks and a drainage system where necessary along portions of Gordon Terrace and Kenmore. ' Special Assessment 113 Fund - This fund set up in 1978 to account for the collec- tion and disbursement of funds for the improvement of portions of Waukegan and Northwoods Roads by construction of a Sanitary Sewer. Special Assessment 114 Fund - This fund set up in 1978 to account for the collec- tion and disbursement of funds for the improvement of Kates Road by construction of concrete pavement, curb and gutter, storm sewer and other work necessary and incidental to the improvement. 1 11 82 1 1 1 1 1 1 1 r r rl- UIN ppZA "0 n ON d m 00 �I ON N 0` O VT Vi y EH cn co r �I 8 n u} yr �n un cn ^a O NO u} � M I O 00 i V} Cli V? N � cn cq �- U1 tf1 En V> V? ID r. � � n �t M M OOI a% a% �+1 Vi V} U7 L L 1-Gi VI 6 � co d n ucn�' i F U n 1� � Ln N M "0 Ln a M O M Vi V} v1 0�0 N O 0000 M O N tn� to en M 1.0 1�0 OI NO V> V} 001 00 .-i •--i VT V> lz lz V> V> Q-r V)- 0000 N c O oll ccn O y L.! co 1J L7 co u �p C �� RJ WCf G-4 .n 1� u Qf � 4J Gza Q JJ W � y 4J •� -- •rl 1J •�4 jEn H y 4 • T• H L •� ca •; .--1 u r E2 �' 19 N c� 1 1 f 1 1 1 1 1 1 1 1 i 1 1 1 1 wt (o G n RF'O 3 GGp H fD 'p F H� fD N (D m (D r rt O (D r h r cn w r M r r r CA rr cn R I rr v. (D rrrt O G y V+ m O rr r �U r cn rr w rt N N W W V O� 0\ O 1 N Q v -4v N � r O pp I Ln 00 00o O O O I ID rOND rrW-+ W I W W CDW N N N CN v l0 %.O %o N IWJ� 0000 OD Un ONa Na Ir W 1 PROPRIETARY FUND TYPES 1 Fj, L� i I ENTERPRISE FUNDS 11 Fund Descriptions Water Fund - To account for all activity necessary to provide water to the residents of the Village of Deerfield including administration, operation, maintenance, financing and related Debt Service. Sewerage Fund Sewerage Fund - To account for the provision of sewer service to the residents of the Village of Deerfield. All activity necessary to provide such services is accounted for in this fund including, but not limited to, administration, construction, maintenance, and operations of the Sewerage Treatment Plant. Refuse Fund - To account for all revenues and expenses necessary to provide the residents of the Village of Deerfield with refuse service. Commuter Parking Lot Fund Commuter Parking Lot Fund - To account for all activity necessary to construct, operate, and maintain the commuter parking facilities within the Village. I 84 VILLAGE OF DEERFIELD, ILLINOIS ' ENTERPRISE FUNDS COMBINING BALANCE SHEET APRIL 30, 1988 Commuter Parking Totals Water Sewerage Refuse Lot 1988 1987 ASSETS Current Assets Cash and Investments $ 860,539 $ 991,313 $ 52,578 $210,235 $ 2,114,665 $1,897,511 Receivables Property Taxes 420,303 420,303 378,651 Accrued Interest 4,289 5,221 3,986 13,496 10,581 Accounts 392,437 226,781 95,115 714,333 631,703 Other 43,604 26,797 4,370 74,771 34,340 Due from Other Funds 4,173 4,173 735 Inventories 33,153 7,125 40,278 49,193 1 Investment in Joint Venture - HELP 2,786 6,888 9,674 1,336,808 1,264,125 580,525 210,235 3,391,693 3,002,714 Restricted Assets Cash and Investments 88,708 . 88,708 88,708 Fixed Assets (Net of ' Accumulated Depreciation) 2,386,194 6,904,600 417,358 9,708,152 5,982,479 Total Assets $3,811,710 $8,168,725. $580,525 $627,593 $13,188,553 $9,073,901 LIABILITIES AND FUND EQUITY Current Liabilities Accounts Payable $ 110,107 $ 47,953 $ 78,723 $ 845 $ 237,628 $ 232,007 Accrued Payroll 7,774 7,774 Compensated Absences Payable 5,992 27,030 33,022 49,472 Other Payables 2,867 20,998 539 24,404 13,125 Due to Other Funds 446 3,601 4,047 7,452 119,412 107,356 78,723 1,384 306,875 302,056 Long -Term Liabilities Revenue Bonds Payable 45,000 - - - 45,000 90,000 Total Liabilities 164,412 107,356 78,723 1,384 351,875 392,056 �I Fund Equity Contributed Capital 1,961,847 6,379,368 - 379,240 8,720,455 4,937,608 Retained Earnings 1 Reserved - Restricted Accounts 88,708 88,708 88,708 Unreserved 1,596,743 1,682,001 501,802 246,969 4,027,515 3,655,529 Total Retained Earnings 1,685,451 1,682,001 501,802 246,969 4,116,223 3,744,237 Total Fund Equity 3,647,298 8,061,369 501,802 626,209 12,836,678 8,681,845 Total Liabilities and Fund Equity 13,811,710 $8,168,725 $580,525 $627,593 $13,188,553 $9,073,901 El ISee accompanying Notes to the Financial Statements. 85 VMLAGE OF DEERFIELD, ENERPRISE FUNDS CCHBEMU STAMMOF CHMM iN •mr. m CAPrM Increases Contributions from Other Finds Decreases Depreciation that Reduces Contributed Capital Net Increase (Wcrease) Account Balances lby 1 April 30 Water Sewerage Refuse $2,012,347 $2,072,000 50,500 224,000 1,961,847 1,848,000 4,531,368 $1,961,847 $6,379;368 See acconpanying Notes to the Financial Statements. Commter Paiidr g Lot Totals - $4,084,347 $ 27,000 301,500 - (27,000) 3,782,847 - 406,240 4,937,608 - $379,240 $8,720,455 1 1 1 t 1 1 1 1 1 1 l 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS ENTERPRISE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - UNRESERVED FOR THE YEAR ENDED APRIL 30, 1988 Operating Revenues Charges for Services Water Sales Sewer Charges Refuse Billings Parking Lot Fees Surcharges Miscellaneous Total Operating Revenues Operating Expenses Excluding Depreciation Administration Operations Total Operating Expenses Excluding Depreciation Operating Income (Loss) before Depreciation Depreciation Operating Income (Loss) Nonoperating Revenues (Expenses) Interest Income Property Taxes Interest Expense Net Income (Loss) before Operating Transfers Operating Transfers (Out) Net Income (Loss) Other Changes in Retained Earnings Unreserved Depreciation that Reduces Contributed Capital Net Increase in Retained Earnings - Unreserved Retained Earnings - Unreserved May 1 April 30 86 Commuter Parking Totals Water Sewerage Refuse Lot 1988 1987 $1,942,437 $1,942,437 $1,795,892 $ 934,476 934,476 948,122 $ 453,555 453,555 444,063 $ 91,181 91,181 90,953 101,376 101,376 94,056 41,651 34,969 76,620 113,133 1,984,088 1,070,821 453,555 91,181 3,599,645 3,486,219 121,993 167,030 27,613 316,636 312,189 1,631,914 838,547 929,652 23,182 3,423,295 3,007,529 1,753,907 1,005,577 957,265 23,182 3,739,931 3,319,718 230,181 65,244 (503,710) 67,999 (140,286) 166,501 106,240 249,510 - 30,698 386,448 298,505 123,941 (184,266) (503,710) 37,301 (526,734) (132,004) 41,002 56,281 37,764 135,047 107,256 485,998 485,998 424,717 (3,825) (3,825) (5,738) 37,177 56,281 523,762 - 617,220 526,235 161,118 (127,985) 20,052 37,301 90,486 394,231 - - - (20,000) (20,000) (20,000) 161,118 (127,985) 20,052 17,301 70,486 374,231 50,500 224,000 - 27,000 301,500 212,000 211,618 96,015 20,052 44,301 371,986 586,231 1,385,125 1,585,986 481,750 202,668 3,655,529 3,069,298 $1,596,743 $1,682,001 $ 501,802 $246,969 $4,027,515 $3,655,529 See accompanying Notes to the Financial Statements. 1 1 1 1 1 1 1 i 1 1 1 1 1 1 1 1 1 1 S] W w w n 0 10 w p oq z O rt w rt O rt w w p 0 H• w rt w rt 0 rt T w (D 03 rt m •o w a' m G p �• � � w w n Wi n£ W (D m y O H wIn 0 m a G w e a rt w ro n N n H (D R. (D 0 m n rt rt rt (D v, w H•rm a m 10 w (D fA (D w w rt m m (D w rt N ri) H. rt w w m N N 00 v rn �• � � .� w rn O 00 N f- In N W W N W 4- O W ON tD V N 01,10 O O\ n w w ro � 10 a' H. w n a(D n E rt ri (D t7 a. rt w w H ro (A 'C to H H. (D (D n w p 0 ro H. `� ° Z0 w 8 rt a w z (D H. I,• a (z H- (D v a n O i a r' c rt (Dp w bd H. (A p O rt rt p . � (D r tzj p H. x rt w 10 ri) rD H• p H (D rt r• N N N O N r 00 1— D` O O` W N 1 V 41 r 00 V w 00 O 00 � O tD N ON W V to O V N A N (D r N 00 V rj W A 00 O w V 10 O 4- to to tD pq q V h-' Ot O\ O W N I h 00 (D I to O O In to O to to to W to to N N tO tD to O O O M G to W Oo w O O O V 41 4 V In In In (D 00 r w v to A N N N N r+ 9 r- a% A W O In N N V V O V [ r� N to V N N tO tO a, W O x G rt H• rt W N r 00 00 tD tD tD O to A F--' 00 00 tO to 00 i--• Qq ry I- 00 N W r--• F•-• I- tO I.- W A t-+ V A v V to In O'" N r Ol O\ O V r-• 00 ON rr In V O N N N to I.- A to I O tD I- to 00 4 rn t0 tD O A V N N to In ol 00 r O N t0 t0 O V+ O l� W In 00 1--• In 00 V O 00 w to tO l-- 1- N l� 4__ W A 00 to v 00 P- 00 Orn � tD w V tD v V tO r N 00 4._ O Ol tn0O W O W 00 V O, ON 1 to i.- In III OD V H O rt w 114 O x txl z C7 m C7 roil z H r W O tD 00 00 I E:Z:3 1 11 1 1 I 1 U]" VILLAGE OF DEERFIELD, ILLINOIS WATER FUND . BALANCE SHEET APRIL 30, 1988 ASSETS Current Assets Cash and Investments Receivables Accrued Interest Accounts - Billed - Unbilled Other Inventories Investment in Joint Venture - HELP Restricted Assets Cash and Investments Fixed Assets Cost Accumulated Depreciation Total Assets LIABILITIES AND FUND EQUITY Current Liabilities Accounts Payable Compensated Absences Payable Other Payables Due to Other Funds Long -Term Liabilities Revenue Bonds Payable Total Liabilities Fund Equity Contributed Capital Retained Earnings Reserved - Restricted Accounts Unreserved Total Retained Earnings Total Fund Equity Total Liabilities and Fund Equity See accompanying Notes to the Financial Statements. 1988 $ 860,539 4,289 131,897 260,540 43,604 33,153 2,786 1,336,808 88,708 3,141,929 (755,735) 2,386,194 $3,811,710 $ 110,107 5,992 2,867 446 119,412 45,000 164,412 1,961,847 88,708 1,596,743 1,685,451 3,647,298 C1 Q 1 1 71n 1987 $ 718,217 3,566 85,914 261,596 20,617 40,890 1,130,800 88,708 1,109,119 (649,495) 459,624 (,'1 A70 11') $ 97,020 12,866 3,546 1,867 115,299 90,000 205,299 88,708 1,385,125 1,473,833 1,473,833 (Z1 A 7 Q 14f) 89 VILLAGE OF DEERFIELD, ILLINOIS STATEMENT OF.CHANGES IN RETAINED EARNINGS - RESERVED - RESTRICTED ACCOUNTS FOR THE YEAR ENDED APRIL 30. 1988 Increases Decreases Net Increase (Decrease) Account Balances May 1 April 30 Principal and Bond Interest Depreciation Reserve $21,708 $21,708 $15,000 $15,000 See accompanying Notes to the Financial Statements. $52,000 $52,000 Totals $88,708 $88,708 i90 ' VILLAGE OF DEERFIELD, ILLINOIS WATER FUND STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - UNRESERVED - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1988 1 1988 Budget Actual 1987 Actual Operating Revenues Charges for Services Water Sales $1,750,000 $1,942,437 $1,795,892 Miscellaneous Permits and Fees 20,000 16,169 35,222 Penalties 24,000 22,154 20,880 ' Other 1,000 3,328 876 Total Operating Revenues 1,795,000 1,984,088 1,852,870 Operating Expenses Excluding Depreciation Administration 125,022 121,993 119,044 Operations Distribution 1,315,664 1,419,254 1,249,222 ' Maintenance - Mains and Fire Hydrants 165,642 160,341 112,261 Maintenance - Meters 59,346 52,319 37,136 Total Operating Expenses Excluding Depreciation 1,665,674 1,753,907 1,517,663 Operating Income before Depreciation 129,326 230,181 335,207 Depreciation - 106,240 61,329 ' Operating Income 129,326 123,941 273,878 Nonoperating Revenues (Expenses) Interest Income 40,000 41,002 39,908 Interest Expense Revenue Bonds (4,000) (3,825) (5,738) 36,000 37,177 34,170 Net Income $ 165,326 161,11-8 308,048 Other Changes in Retained Earnings - Unreserved Depreciation that Reduces Contributed Capital 50,500 - Net Increase in Retained Earnings - Unreserved 211,618 308,048 ' Retained Earnings Unreserved May 1 1,385,125 1,077,077 April 30 $1,596,743 $1,385,125 See accompanying Notes to the Financial Statements. 1. 91 VILLAGE OF DEERFIELD, ILLINOIS SCHEDULE OF OPERATING EXPENSES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30. 1988 Administration Salaries Employee Benefits Professional Services Travel, Training and Dues Printing and Advertising Communications Contractual Services Insurance Motor Vehicle Maintenance Miscellaneous Supplies Motor Vehicle Supplies Occupancy Apparel Bond Principal Repairs and Maintenance Total Less Nonoperating Items Bond Principal Total Administration Operations Distribution Salaries Overtime Employee Benefits Professional Services Printing and Advertising Contractual Services Utility Services Motor Vehicle Maintenance Repairs and Maintenance Miscellaneous Purchase of Water Supplies R Budget 51,250 5,372 3,700 300 700 8,500 1,000 36,900 1,200 300 500 700 12,000 1,800 45,000 170,022 Actual 57,398 7,333 300 659 1,167 10,628 306 25,378 1,429 1,733 1,224 586 12,000 1,852 45,000 166,993 45,000 45,000 125,022 121,993 41,290 41,638 5,900 10,277 6,174 4,830 1,500 1,460 1,100 6,000 5,261 74,500 75,062 1,200 1,720 3,000 860 1,300 827 1,170,000 1,274,619 500 75 92 VILLAGE OF DEERFIELD, ILLINOIS SCHEDULE OF OPERATING EXPENSES - BUDGET AND ACTUAL (CONT.) FOR THE YEAR ENDED APRIL 30, 1988 Budget Actual Operations (Cont.) Distribution (Cont.) Motor Vehicle Supplies $ 1,000 $ 471 Chlorine 1,000 Materials 1.200 1,941 Equipment 213 Total Distribution 1,315,664 1,419,254 Maintenance - Main and Fire Hydrants Salaries 50,010 28,106 Overtime 11,500 11,862 Part -Time 18,400 16,453 Employee Benefits 8,232 4,909 Contractual Services 33,900 31,407 Motor Vehicle Maintenance 3,000 4,498 Repairs and Maintenance 10,500 3,364 Equipment Rental 1,000 511 Miscellaneous 400 1,513 Motor Vehicle Supplies 1,900 Small Tools and Equipment 300 299 Aggregates 6,000 10,928 Materials 20,500 46,491 Equipment 590 Improvements - Not Buildings 7,950 Total 165,642 168,881 Less Nonoperating Items Fixed Assets Capitalized - 8,540 Total Maintenance - Main and Fire Hydrants 165,642 160,341 93 VILLAGE OF DEERFIELD, ILLINOIS SCHEDULE OF OPERATING EXPENSES - BUDGET AND ACTUAL (CONT.) FOR THE YEAR ENDED APRIL 30, 1988 Budget Actual Operations (Cont.) Maintenance - Meters Salaries _ $ 36,970 $ 35,442 Overtime 800 670 Part -Time 900 837 Employee Benefits 5,826 4,503 Professional Services 3,000 Travel, Training and Dues 300 Printing and Advertising 1,000 Contractual Services 2,200 675 Motor Vehicle Maintenance 2,000 3,429 Repairs and Maintenance 1,400 244 Miscellaneous 300 96 Supplies 350 Motor Vehicle Supplies 1,000 1,128 Materials 3,000 3,371 Small Tools and Equipment 300 Equipment 16,500 13,847 Total 75,846 64,242 Less Nonoperating Items Fixed Assets Capitalized 16,500 11,923 Total Maintenance - Meters 59,346 52,319 Total Expenses $1,665,674 $1,753,907 94 VILLAGE OF DEERFIELD, ILLINOIS SCHEDULE OF FIXED ASSETS AND DEPRECIATION FOR THE YEAR ENDED APRIL 30, 1988 Assets Balances Balances May 1 Additions Deletions April 30 Water System $ 787,751 $2,020,297 $2,808,048 Equipment and Automotive 321,368 12,513 333,881 $1,109,119 $2,032,810 - 3,141,929 Accumulated Depreciation Balances Balances May 1 Provisions Deletions April 30 Water System $ 484,548 $ 70,201 $ 554,749 Equipment and Automotive 164,947 36,039 200,986 $ 649,495 $ 106,240 - 755,735 Net Asset Value $2.386.194 VILLAGE OF DEERFIELD, ILLINOIS SEWERAGE FUND BALANCE SHEET APRIL 30, 1988 1988 1987 ASSETS Current Assets Cash and Investments $ 991,313 $ 922,429 Receivables Accrued Interest 5,221 5,265 Accounts - Billed 57,908 33,784 - Unbilled 168,873 158,972 Other 26,797 13,723 Inventories 7,125 8,303 Investment in Joint Venture - HELP 6,888 1,264,125 1,142,476 Fixed Assets Cost 8,560,430 6,481,119 Accumulated Depreciation (1,655,830) (1,406,320) 6,904,600 5,074,799 Total Assets $ 8,168,725 $ 6,217,275 LIABILITIES AND FUND EQUITY Current Liabilities Accounts Payable $ 47,953 $ 52,002 Accrued Payroll 7,774 Compensated Absences Payable 27,030 36,606 Other Payables 20,998 9,187 Due to Other Funds 3,601 2,126 Total Liabilities 107,356 99,921 Fund Equity Contributed Capital 6,379,368 4,531,368 Retained Earnings - Unreserved 1,682,001 12585,986 Total Fund Equity 8,061,369 6,117,354 Total Liabilities and Fund Equity $ 8,168,725 $ 6,217,275 See accompanying Notes to the Financial Statements. ' 96 VILLAGE OF DEERFIELD, ILLINOIS SEWERAGE FUND STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - UNRESERVED - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1988 1988 Actual 1987 Actual Budget Operating Revenues Charges for Services Sewer Charges $ 940,000 $ 934,476 $ 948,122 Surcharges - Construction 30,000 45,325 44,262 Surcharges - Sara Lee 56,051 49,794 Miscellaneous ' Permits and Fees 20,000 18,610 41,230 Penalties 12,000 8,932 11,485 Other 2,000 7,427 3,440 Total Operating Revenues 1,004,000 1,070,821 1,098,333 Operating Expenses Excluding Depreciation Administration 171,563 167,030 171,484 Operations Treatment Plant 632,046 613,027 556,766 Cleaning and Maintenance 124,496 84,760 93,028 ' Construction 171,250 140,760 90,773 Total Operating Expenses Excluding Depreciation 1,099,355 1,005,577 912,051 Operating Income (Loss) before Depreciation (95,355) 65,244 186,282 Depreciation 68,500 249,510 206,478 Operating Income (Loss) (163,855) (184,266) (20,196) Nonoperating Revenues Interest Income 50,000 56,281 50,343 (Loss) $ (113,855) (127,985) 30,147 Net Income Other Changes in Retained Earnings - Unreserved ' Depreciation that Reduces Contributed Capital 224,000 185,000 Net Increase in Retained Earnings - Unreserved 96,015 215,147 Retained Earnings Unreserved May 1 1,585,986 1,370,839 April 30 $1,682,001 $1,585,986 See accompanying Notes to the Financial Statements. ' 97 VILLAGE OF DEERFIELD, ILLINOIS ' SEWERAGE FUND SCHEDULE OF OPERATING EXPENSES - BUDGET AND ACTUAL , FOR THE YEAR ENDED APRIL 30, 1988 Budget Actual , Administration Salaries Overtime $ 51,250 500 $ 55,653 ' Employee Benefits 5,213 7,613 Professional Services 2,200 300 Travel, Training and Dues 200 223 Printing and Advertising 100 616 ' Communications 2,900 2,655 Insurance 90,300 82,258 Motor Vehicle Maintenance 900 120 Repairs and Maintenance 1,300 164 Miscellaneous 700 946 Supplies 600 732 ' Motor Vehicle Supplies 700 1,810 Occupancy 12,000 12,000 Apparel 1,500 1,262 Contractual Services 1,200 678 , Total Administration 171,563 167,030 ' Operations Treatment Plant Salaries 246,500 252,520 ' Overtime 7,500 9,142 Part -Time 4,100 4,386 Employee Benefits 33,246 29,563 , Professional Services 5,000 Travel, Training and Dues Printing and Advertising 900 1,000 1,401 153 , Communications 3,400 7,338 Contractual Services 34,500 23,024 Utility Services 205,300 175,533 , Motor Vehicle Maintenance 3,000 1,968 Repairs and Maintenance 53,000 61,914 Equipment Rental 1,000 1,183 Supplies 8,600 9,577 ' Motor Vehicle Supplies 6,000 7,901 Chlorine 7,000 11,553 Aggregates 2,500 3,797 ' Materials 4,000 5,863 Street Signs 300 1 98 t 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS SEWERAGE FUND SCHEDULE OF OPERATING EXPENSES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1988 Budget Actual Operations (Cont.) Treatment Plant (Cont.) Small Tools and Equipment $ 500 $ 456 Apparel 1,700 1,329 Miscellaneous 3,000 3,825 Equipment 19,500 6,959 Total 651,546 619,385 Less Nonoperating Items Fixed Assets Capitalized 19,500 6,358 Total Treatment Plant 632,046 613,027 Cleaning and Maintenance Salaries 56,260 46,177 Overtime 4,400 2,468 Part -Time 2,400 2,289 Employee Benefits 7,536 5,910 Contractual Services 10,000 616 Motor Vehicle Maintenance 4,000 2,561 Repairs and Maintenance 5,000 2,604 Equipment Rental 3,000 240 Miscellaneous 2,000 1,063 Supplies 20,100 15,444 Motor Vehicle Supplies 1,500 579 Aggregates 1,000 1,326 Materials 7,000 3,278 Equipment 3,000 953 Small Tools and Equipment 300 205 Total 127,496 85,713 Less Nonoperating Items Fixed Assets Capitalized 3,000 953 Total Cleaning and Maintenance 124,496 84,760 99 VILLAGE OF DEERFIELD, ILLINOIS SEWERAGE FUND SCHEDULE OF OPERATING EXPENSES - BUDGET AND ACTUAL (CONT.) FOR THE YEAR ENDED APRIL 30. 1988 Operations (Cont.) Construction Salaries Overtime Part -Time Employee Benefits Contractual Services Motor Vehicle Maintenance Repairs and Maintenance Equipment Rental Supplies Motor Vehicle Supplies Aggregates Materials Small Tools and Equipment Total Construction Total Expenses Budget Actual $ 77,750 $ 69,581 2,100 302 1,200 1,017 12,000 8,720 41,000 40,684 5,500 2,967 7,500 3,966 1,000 2,000 372 2,000 2,690 5,000 1,424 14,000 8,989 200 48 171,250 140,760 Al noQ i55 Al nnq S77 1 1 1 1 1 1 1 1 7 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS SEWERAGE FUND SCHEDULE OF FIXED ASSETS AND DEPRECIATION FOR THE YEAR ENDED APRIL 30, 1988 Sewer System and Plant Equipment and Automotive Sewer System and Plant Equipment and Automotive Net Asset Value Assets Balances May 1 Additions Deletions $6,271,360 $2,072,000 209,759 7,311 64 L01 i i n eo n7n III Accumulated Devreciation Balances April 30 $8,343,360 217,070 8,560,430 Balances Balances May 1 Provisions Deletions April 30 $1,276,569 $ 216,330 $1,492,899 129,751 33,180 162,931 $1,406,320 $ 249,510 - 1,655,830 s6_9n& 6nn 100 101 VILLAGE OF DEERFIELD, ILLINOIS BALANCE SHEET APRIL 30. 1988 ASSETS Current Assets Cash and Investments Receivables Property Taxes Accrued Interest Accounts - Billed - Unbilled Other Due from Other Funds Total Assets LIABILITIES AND FUND EQUITY Current Liabilities Account Payable Due to Other Funds Total Liabilities Fund Equity Retained Earnings - Unreserved Total Liabilities and Fund Equity See accompanying Notes to the Financial Statements. 1988 1987 $ 52,578 $ 92,341 420,303 378,651 3,986 1,750 17,855 19,121 77,260 72,316 4,370 4,173 735 $580,525 $564,914 $ 78,723 $ 79,705 3,459 78,723 83,164 501,802 481,750 $580,525 $564,914 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 102 VILLAGE OF DEERFIELD, ILLINOIS STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - UNRESERVED - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30. 1988 Operating Revenues Charges for Services Refuse Billing Operating Expenses Administration Operations Contractual Services Total Operating Expenses Operating Income (Loss) Nonoperating Revenues (Expenses) Interest Income Property Taxes Net Income Retained Earnings - Unreserved May 1 April 30 1988 1987 Budget Actual Actual $ 437,000 $ 453,555 $ 444,063 15,000 27,613 21,661 900,000 929,652 842,129 915,000 957,265 863,790 (478,000) (503,710) (419,727) 10,000 37,764 17,005 475,000 485,998 424,717 485,000 523,762 441,722 $ 7,000 20,052 21,995 See accompanying Notes to the Financial Statements. 481,750 459,755 $ 501,802 $ 481,750 103 VILLAGE OF DEERFIELD, ILLINOIS COMMUTER PARKING LOT FUND BALANCE SHEET APRIL 30, 1988 ASSETS Current Assets Cash and Investments Fixed Assets Cost Accumulated Depreciation Total Assets LIABILITIES AND FUND EQUITY Current Liabilities Accounts Payable Other Payables Total Liabilities Fund Equity Contributed Capital Retained Earnings - Unreserved Total Fund Equity Total Liabilities and Fund Equity See accompanying Notes to the Financial Statements. 1988 1987 $ 210,235 $ 164,524 691,458 691,458 (274,100) (243,402) 417,358 448,056 $ 627,593 $ 612,580 $ 845. $ 3,280 539 392 1,384 3,672 379,240 406,240 246,969 202,668 626,209 608,908 $ 627,593 $ 612,580 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 104 VILLAGE OF DEERFIELD, ILLINOIS COMMUTER PARKING LOT FUND STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - UNRESERVED - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30. 1988 Operating Revenues Parking Lot Fees Operating Expenses Excluding Depreciation Operations Operating Income before Depreciation Depreciation Operating Income before Operating Transfers Operating Transfers (Out) Street and Bridge Fund Net Income Other Changes in Retained Earnings - Unreserved Depreciation that Reduces Contributed Capital Net Increase in Retained Earnings - Unreserved Retained Earnings - Unreserved May 1 April 30 1988 Budget Actual 1987 Actual $ 91,000 $ 91,181 $ 90,953 29,000 23,182 26,214 62,000 67,999 641739 - 30,698 30,698 62,000 37,301 34,041 (20,000) (20,000) (20,000) $ 42,000 17,301 14,041 See accompanying Notes to the Financial Statements. 27,000 27,000 44,301 41,041 202,668 161,627 $246,969 $202,668 105. VILLAGE OF DEERFIELD, ILLINOIS COMMUTER PARKING LOT FUND SCHEDULE OF OPERATING EXPENSES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30. 1988 Budget Actual Operations Parking Lots - Village and Federal Funds Salaries $ 3,400 $ 3,198 Benefits 250 229 Insurance 400 311 Utility Services 3,500 2,633 ` Repairs and Maintenance 1,000 661 Supplies 500 216 .Aggregates 500 Equipment 500 Property Rentals 7,500 7,440 Materials 800 160 Total 18,350 14,848 Less Nonoperating Items Fixed Assets Capitalized 500 - Total Parking Lots - Village and Federal Funds 17,850 14,84.8 Parking Lots - Village Construction Salaries 3,900 3,347 Overtime 491 Benefits 200 244 Insurance 350 all Utility Services 3,900 3,685 Repairs and Maintenance 1,000 55 Supplies 500 188 Aggregates 200 Materials 1,000 13 Equipment 100 Total Parking Lots - Village Construction 11,150 8,334 Total Operating Expenses $29,000 $.23,182 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Land Parking Lot Parking Lot Net Asset Value VILLAGE OF DEERFIELD, ILLINOIS COMMUTER PARKING LOT FUND SCHEDULE OF FIXED ASSETS AND DEPRECIATION FOR THE YEAR ENDED APRIL 30, 1988 Balances May 1 $ 77,500 613,958 $691,458 Assets Additions Deletions Balances April 30 $ 77,500 613,958 691,458 Accumulated Depreciation Balances Balances May 1 Provisions Deletions April 30 $243,402 $30,698 - $274,100 $243,402 $30,698 - 274,100 $417,358 106 1 Fi 1 1 11 11 I 1 INTERNAL SERVICE FUND H Fund Description Garage Fund Garage Fund - To account for all activity necessary to maintain the efficient and safe operation of Village vehicles and equipment. The Garage is operated and maintained by the Village of Deerfield and the various departments are billed according to the services rendered. C] 1 I I. IDYI 1 1 1 1 1 1 y' i 1 E 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS GARAGE FUND BALANCE SHEET APRIL 30. 1988 ASSETS Receivables - Accounts Due from Other Funds Inventories Total Assets LIABILITIES AND FUND EQUITY Liabilities Cash Overdrafts Accounts Payable Compensated Absences Payable Other Payables Total Liabilities Fund Equity Retained Earnings - Unreserved Total Liabilities and Fund Equity See accompanying Notes to the Financial Statements. 1988 1987 $ 1,618 12,675 $13,281 34,091 33,010 $ 48,384 $46,291 $ 67,268 $40,200 3,693 5,224 9,255 8,028 1,470 1,144 81,686 54,596 (33,302) (8,305) $ 48,384 $46,291 108 VILLAGE OF DEERFIELD, ILLINOIS GARAGE FUND STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30. 1988 Operating Revenues Charges for Services Billings Operating Expenses Operations Net Income (Loss) Retained Earnings May 1 April 30 1988 1987 Budget Actual Actual $148,300 $151,354 $125,369 148,990 176,351 150,335 $ (690) (24,997) (24,966) See accompanying Notes to the Financial Statements. (8,305) $(33,302) 16,661 $ (8,305) 109 VILLAGE OF DEERFIELD, ILLINOIS STATEMENT OF CHANGES IN FINANCIAL POSITION FOR THE YEAR ENDED APRIL 30, 1988 Cash Was Provided By Increase in Current Liabilities Cash Was Used To Fund Operations Net Loss Increase Current Assets Decrease Current Liabilities Net Increase (Decrease) Cash and Investments May 1 April 30 See accompanying Notes to the Financial Statements. 1988 1987 $ 22 - 24,997 $ 24,966 2,093 6,429 1,561 27,090 32,956 (27,068) (32,956) (40,200) (7,244) $(67,268) $(40,200) VILLAGE OF DEERFIELD, ILLINOIS GARAGE FUND SCHEDULE OF OPERATING EXPENSES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30. 1988 Budget Actual Operations Public Works Department Salaries $ 62,440 $ 64,419 Overtime 5,300 7,691 Employee.Benefits 8,300 7,630 Apparel 500 360 Travel, Training and Dues 500 161 Printing and Advertising 400 Insurance 6,800 6,379 Miscellaneous 200 527 Professional Services 50 Contractual Services 100 181 Utility Services 1,500 813 Repairs and Maintenance 5,000 5,272 Supplies 51,100 77,056 Motor Vehicle Supplies 800 353 Equipment 2,900 2,872 Communications 1,100 859 Materials 500 348 Small Tools and Equipment 1,500 1,430 Total Operating Expenses $148,990 $176,351 1 1 i 1 I r I i L� 'I i FIDUCIARY FUND TYPES r] I i TRUST AND AGENCY FUNDS r IPolice Pension Fund L I 1 I 1 1 1, 1 F 1 Fund Descriptions Police Pension Fund - To account for the resources necessary to provide retirement and disability benefits to personnel of the Village of Deerfield Police Department. Deposit Fund Deposit Fund - To account for monies on deposit with the Village which are being held on a temporary basis. Deferred Compensation Plan Fund Deferred Compensation Plan Fund - To account for salary deductions held by the Village for certain Village employees. The deferred compensation is available to employees upon termination or retirement. Corporate Purpose Bond Series of 1987 Redemption Fund Is used to Account for Investments held in escrow to pay future prinicipal and interest requirements on the Corporate Purpose Bond Series of 1987. r III t 1 1 1 1 1 1 i 1 1 1 1 1 1 1 00l Ul Ln -7 Cl) a\ N m O% Lr, 000 -7 -t Ln M •-i •--4 01 I� N � 00en �T tl? I Ln t? A M � � 1.0 O O O N O •--I -4 n cn ON Ln Ln 4 I .� � N NN-� 1� O� 0a,ppp t1'1 00 •-+ OMO I� t!l O �7 �O �7 r n O cq n v Ln -t u1 -zt 1-- I0 ��-p-4 co N u 1 8 00 M M 00 Ln 00 ulOn.-ia0 M co cOOLn Lr� •� Im cn � ��pN OONi ONi -It I C' i 1� �7Is -ItG9JL a 1c; Lnp Is 110 ID LO1.4 �O �1 t/> U? V? t/P p M C UO� LJ G O O cn M C" c�7 mM OO NN N 01 rn Lri O LnOMi Nr"0 Lri co can- `n vLrr CC b 8 P. � SO p c CD pp1�. 41 W w cn t � u ❑ - W §I P14 CA in x co � {, co 0 y y G y c0 � QJ (J W •'v-I HO •rU•I O T ca •r1 1+ p S+ ° G �aa >1� � U O u 11 O i0 aS 0 4 112 VILLAGE OF DEERFIELD, ILLINOIS EXPENDABLE TRUST FUND CORPORATE PURPOSE BOND SERIES OF 1987 STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE FOR THE YEAR ENDED APRIL 30, 1988 Revenues - Interest Expenditures - Interest Excess of Revenues over Expenditures Fund Balance May 1 April 30 $421,500 421,500 113 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS TRUST AND AGENCY FUND POLICE PENSION FUND STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1988 Operating Revenues Taxes Property Taxes Replacement Taxes Contributions Employee Contributions Miscellaneous Interest Other Gain on Sale of Investments Total Operating Revenues Operating Expenses Benefits and Refunds Pension Payments Separation Refunds Miscellaneous Filing Fee Total Operating Expenses Income before Operating Transfers Operating Transfers In General Fund Net Income Fund Balances May 1 April 30 1988 1987 Budget Actual Actual $140,000 $ 144,528 $ 174,880 5,500 5,496 5,554 104,000 107,902 99,923 425,000 473,179 381,538 218 77,330 674,500 731,323 739,225 135,000 87,859 83,885 20,000 17,050 500 53 99 155,500 87,912 101,034 519,000 643,411 638,191 — — 900 $519,000 643,411 639,091 See accompanying Notes to the Financial Statements. 4,411,629 3,772,538 es nrIs nAn ca i111 r")o VILLAGE OF DEERFIELD, ILLINOIS TRUST AND AGENCY FUNDS POLICE PENSION FUND STATEMENT OF CHANGES IN FINANCIAL POSITION FOR THE YEAR ENDED APRIL 30, 1988 1988 Cash Was Provided By Operations Net Income $ 643,411 Decrease in Current Assets 25,657 Cash Was Used To Decrease Current Liabilities 1,406 Net Increase 667,662 Cash and Investments May 1 4,171,671 April 30 $4,839,333 See accompanying Notes to the Financial Statements. 1987 $ 639,091 13,419 652,510 122 652,388 3,519,283 Q .1. 1 7 1 c 7 1 115 VILLAGE OF DEERFIELD, ILLINOIS AGENCY FUNDS COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES FOR THE YEAR ENDED APRIL 30, 1988 Balances Balances May 1 Increase Decrease April 30 All Funds ASSETS Cash and Investments $ 73,274 $ 93,187 $166,461 Receivables - Other 31 31 Due from Other Funds 1,214 $ 1,214 Assets Held by Agents for Deferred Compensation Plan (Market Value) 639,889 108,983 32,198 716,674 Total Assets $714,377 $202,201 $33,412 $883,166 LIABILITIES Accounts Payable $ 4,781 $ 4,320 $ 461 Deposits Payable 66,949 $ 88,375 155,324 Due to Other Funds 2,758 7,949 10,707 Due to Participants 639,889 108,983 32,198 716,674 Total Liabilities $714,377 $205,307 $36,518 $883,166 Deposit Fund ASSETS Cash and Investments $ 73,274 $ 93,187 $166,461 Receivables - Other 31 31 Due from Other Funds 1,214 $ 1,214 Total Assets $ 74,488 $ 93,218 $ 1,214 $166,492 LIABILITIES Accounts Payable $ 4,781 $ 4,320 $ 461 Deposits Payable 66,949 $ 88,375 155,324 Due to Other Funds 2,758 7,949 10,707 Total Liabilities $ 74,488 $ 96,324 $ 4,320 $166,492 Deferred Compensation Plan Fund ASSETS Assets Held by Agents for Deferred Compensation Plan (Market Value) $639,889 $108,983 $32,198 $716,674 LIABILITIES Due to Participants $639,889 $108,983 $32,198 $716,674 See accompanying Notes to the Financial Statements. 1 1 1 11 F 11 1 I ACCOUNT GROUPS t 1 . 1 . s GENERAL FIXED ASSETS ACCOUNT GROUP 1 General Fixed Assets Account Group To account for fixed assets not in proprietary fund operations or accounted for in trust funds. U Ul U I I Fl, I 116 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FIXED ASSETS ACCOUNT GROUP SCHEDULE OF GENERAL FIXED ASSETS - BY SOURCE APRIL 30. 1988 GENERAL FIXED ASSETS Land $2,190,722 Buildings and Improvements 1,314,850 Vehicles 490,037 Equipment 1,299,496 $5,295,105 INVESTMENT IN GENERAL FIXED ASSETS General Revenues $3,395,105 General Obligation Bonds 1,500,000 Installment Contracts 400,000 $5,295,105 r 1 1 1 1 1 1 1 1 1 1 1 LTT b O r• H. n rt � � w r• o � w 0 °a 03 x � rn rt (D a a rt p r• rt C P. rt 1.4 N �-• a N N O O H to bGd r-• '� n r• W N o w r+ C p Q. I'll I 00 to v in (D OQ to to to to p m O O O O rt En -to to C %o o r r.- :r o w � �• r• O 1.0 W v N W to 00 O (D v r w O (n �D O � W r• 41 a\ F--• Cr (D O 0o 00 1�t In N )--• H N tC v In O W rt to w to w I ON ON 00 w In D, r 00 118 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FIXED ASSETS ACCOUNT GROUP SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS - BY FUNCTION AND ACTIVITY FOR THE YEAR ENDED APRIL 30. 1988 Balances Function and Activity May 1 Additions General Government $1,144,852 $535,772 Public Safety 2,713,915 82,561 Public Works 834,239 137,727 $4,693,006 $756,060 Balances Deletions April 30 $140,806 $1,539,818 2,805 2,793,671 10,350 961,616 $153,961 $5,295,105 GENERAL LONG TERM DEBT ACCOUNT GROUP 1 1 1 General Long -Term Debt Account Group I To account for the long-term portion of the Village's Bond Issues and Installment Contracts. r 1 < 7 / / � %� � / / ~ S g 2| en ON C4 � $4 \ / � cn p in C6 _ m.$ � \% E 20 / q g 2 V> \ C / O — 6 /0 ® A A m \% 20 2 . q � \ CLQ A-W#\p 3 OCL q / 14 4.4 0 q 7 m � q 7 )r « � a% >33 J �/4-4 o � A w � b S § so, / H / 2 L�4 \ d OWA 7 LA V \ l 0 / \ � 7 (U 2 � 0 119 M, 1 1 1 1 SUPPLEMENTARY DATA 1 120 VILLAGE OF DEERFIELD, ILLINOIS ILLINOIS MUNICIPAL RETIREMENT FUND REQUIRED SUPPLEMENTARY INFORMATION ANALYSIS OF FUNDING PROGRESS APRIL 30, 1988 (1) Net Assets (4) Unfunded (6) Unfunded Pension Available (2) (3) Pension (5) Benefit Obligation for Benefits Pension Percentage Benefit Annual as a Percentage Fiscal (Lower of Cost Benefit Funded Obligation Covered of Covered Payroll Year or Market) Obligation (1) t (2) (2) - (1) Payroll (4) - (5) 1988 $11,785,417 $3,229,435 55.29% $1,444,018 $2,292,114 63.00% I I i (During the implementation transition period all information required is presented for as many years as is available.) Analysis of the dollar amounts of net assets available for benefits, pension ' benefit obligation, and unfunded pension benefit obligation in isolation can be misleading. Expressing the net assets available for benefits as a percentage of the pension benefit obligation provides one indication of funding status on a going -concern basis. Analysis of this percentage over time indicates whether the system is becoming financially stronger or weaker. Generally, the greater this percentage, the stronger the PERS. Trends in unfunded pension benefit obligation and annual covered payroll are both affected by inflation. Expressing the unfunded 1 pension benefit obligation as a percentage of annual covered payroll approximately adjusts for the effects of inflation and aids analysis of progress made in accumulating sufficient assets to pay benefits when due. Generally, the smaller this percentage, the stronger the PERS. 1' 11 VILLAGE OF DEERFIELD, ILLINOIS POLICE PENSION FUND REQUIRED SUPPLEMENTARY INFORMATION ANALYSIS OF FUNDING PROGRESS APRIL 30, 1988 (1) (4) (6) Net Assets Unfunded Unfunded Pension Available (2) (3) Pension (5) Benefit Obligation for Benefits Pension Percentage Benefit Annual as a Percentage Fiscal (Lower of Cost Benefit Funded Obligation Covered of Covered Payroll Year or Market) Obligation (1) - (2) (2) - (1) Payroll (4) - (5) 1988 $4,411,629 $5,250,116 80.03% $838,487 $1,244,967 67.35% (During the implementation transition period all information required is presented for as many years as is available.) Analysis of the dollar amounts of net assets available for benefits, pension benefit obligation, and unfunded pension benefit obligation in isolation can be misleading. Expressing the net assets available for benefits as a percentage of the pension benefit obligation provides one indication of funding status on a going -concern basis. Analysis of this percentage over time indicates whether the system is becoming financially stronger or weaker. Generally, the greater this percentage, the stronger the PERS. Trends in unfunded pension benefit obligation and annual covered payroll are both affected by inflation. Expressing the unfunded pension benefit obligation as a percentage of annual covered payroll approximately adjusts for the effects of inflation and aids analysis of progress made in accumulating sufficient assets to pay benefits when due. Generally, the smaller this percentage, the stronger the PERS. 1 122 VILLAGE OF DEERFIELD, ILLINOIS ILLINOIS MUNICIPAL RETIREMENT FUND REQUIRED SUPPLEMENTARY INFORMATION REVENUES BY SOURCE APRIL 30, 1988 Revenues by Source Fiscal Employee Employer Investment Year Contributions Contributions Income Totals 1979 $ 46,349 $ 72,593 N/A $118,942 1980 51,742 84,897 N/A 136,639 1981 59,013 94,605 N/A 153,618 1982 70,160 93,047 N/A 163,207 1983 73,144 102,696 N/A 175,840 1984 78,651 114,848 N/A 193,499 1985 82,899 127,571 N/A 210,470 1986 89,372 151,116 N/A 240,488 1987 95,745 167,152 N/A 262,897 1988 103,137 179,472 N/A 282,609 123 ' VILLAGE OF DEERFIELD, ILLINOIS POLICE PENSION FUND REQUIRED SUPPLEMENTARY INFORMATION REVENUES BY SOURCE AND EXPENSES BY TYPE APRIL 30, 1988 Revenues by Source Fiscal Employee Employer Investment Year Contributions Contributions Income Totals ' 1979 $ 55,345 $106,082 $ 73,221 $234,648 1980 1981 60,413 67,138 128,163 124,536 86,824 109,761 275,400 301,435 1982 74,509 109,258 111,758 295,525 1983 76,123 127,124 212,511 415,758 1984 83,022 140,265 265,078 488,365 1985 86,623 156,125 315,417 558,165 1986 97,525 173,723 361,378 632,626 1987 99,923 180,434 458,868 739,225 1988 107,902 150,024 473,397 731,323 Expenses by Type Fiscal Administrative Year Benefits Expenses Refunds Totals 1979 $ 25,060 $ 25 $ 20,343 $ 45,428 1980 25,231 55 188 25,474 1981 25,992 25 5,276 31,293 1982 29,413 320 14,281 44,014 1983 29,403 200 23,003 52,606 , 1984 37,455 75 37,530 1985 65,912 25 10,873 76,810 1986 66,736 937 1,137 68,810 1987 83,885 99 17,050 101,034 , 1988 87,859 53 87,912 1 124 t 1 1 1 1 1 1 1 1 1 1 1 1 i A 1 VILLAGE'OF DEERFIELD, ILLINOIS LONG-TERM DEBT REQUIREMENTS SEWERAGE IMPROVEMENT BOND SERIES OF 1973 APRIL 30, 1988 Date of Issue June 1, 1973 Date of Maturity December 1, 1992 Authorized Issue $1,080,000 Actual Issue $1,080,000 Denomination of Bonds $5,000 Interest Rate 4.4%-5.1% Principal Maturity Date December 1 Interest Dates June 1 and December 1 Payable at Belleville National Savings Bank PRINCIPAL AND INTEREST REQUIREMENTS Tax Bond Levy Numbers Year Principal 137-151 1986 152-166 1987 $ 75,000 167-181 1988 75,000 182-196 1989 75,000 197-206 1990 50,000 207-216 1991 50,000 $325,000 Interest Totals $ 8,087 $ 8,087 14,337 89,337 10,625 85,625 6,875 81,875 3,750 53, 750 1,250 51,250 $44,924 $369,924 Coupons Due on Dec. 1 Amount June 1 Amount 1988 $ 8,087 1988 $ 8,087 1989 6,250 1989 6,250 1990 4,375 1990 4,375 1991 2,500 1991 2,500 1992 1,250 1992 1,250 $22,462 $22,462 125 1 VILLAGE OF DEERFIELD, ILLINOIS LONG-TERM DEBT REQUIREMENTS SEWERAGE TREATMENT FACILITIES BOND SERIES OF 1973 APRIL 30, 1988 Date of Issue Date of Maturity Authorized Issue Actual Issue Denomination of Bonds Interest Rate Principal Maturity Date Interest Dates Payable at Tax Bond Levy Numbers Year 241-265 1986 266-296 1987 297-315 1988 316-340 1989 341-370 1990 371-400 1991 June 1, 1973 December 1, 1992 $2,000,000 $2,000,000 $ 5,000 4.4%-6.0% December 1 June 1 and December 1 Belleville National Savings Bank PRINCIPAL AND INTEREST REQUIREMENTS Principal Interest Totals $ 16,812 $ 16,812 $125,000 30,562 155,562 125,000 24,375 149,375 125,000 18,125 143,125 150,000 11,250 161,250 150,000 3,750 153,750 $675,000 $104,874 $779,874 Coupons Due on Dec. 1 Amount June 1 Amount 1988 $16,812 1988 $16,812 1989 13,750 1989 13,750 1990 10,625 1990 10,625 1991 7,500 1991 7,500 1992 3,750 1992 3,750 $52,437 $52,437 1 126 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS LONG-TERM DEBT REQUIREMENTS CORPORATE PURPOSE BOND SERIES OF 1982 APRIL 30, 1988 Date of Issue October 1, 1982 Date of Maturity December 1, 1994 Authorized Issue $500,000 Actual Issue $500,000 Denomination of Bonds $ 5,000 Interest Rate 9.60% - 10.25% Principal Payment Date December 1 Interest Dates June 1 and December 1 Payable at The Northern Trust Company PRINCIPAL AND INTEREST REQUIREMENTS Tax Bond Levy Coupons Due on Numbers Year Principal Interest Totals June 1 Amount Dec. 1 Amount 16-25 1987 $ 50,000 $ 38,400 $ 88,400 1988 $19,200 1988 $19,200 26-35 1988 50,000 34,275 84,275 1989 17,138 1989 17,137 36-45 1989 50,000 30,025 80,025 1990 15,013 1990 15,012 46-55 1990 50,000 25,650 75,650 1991 12,825 1991 12,825 56-70 1991 75,000 21,150 96,150 1992 10,575 1992 10,575 71-85 1992 75,000 14,250 89,250 1993 7,125 1993 7,125 86-100 1993 75,000 7,200 82,200 1994 3,600 1994 3,600 $425,000 $170,950 $595,950 $85,476 $85,474 127 VILLAGE OF DEERFIELD, ILLINOIS LONG-TERM DEBT REQUIREMENTS CORPORATE PURPOSE BOND SERIES OF 1982 - A APRIL 30, 1988 Date of Issue Date of Maturity Authorized Issue Actual Issue Denomination of Bonds Interest Rate Principal Payment Date Interest Dates Payable at December 1, 1982 December 1, 1993 $500,000 $500,000 $ 5,000 7.0% - 8.5% December 1 June 1 and December 1 American Fletcher National Bank, Indianapolis PRINCIPAL AND INTEREST REQUIREMENTS Tax Bond Levy Numbers Year Principal Interest Totals 41-50 1987 $ 50,000 $24,750 $ 74,750 51-60 1988 50,000 20,750 70,750 61-70 1989 50,000 16,750 66,750 71-80 1990 50,000 12,750 62,750 81-90 1991 50,000 8,500 58,500 91-100 1992 50,000 4,250 54,250 Coupons Due on June 1 Amount Dec. 1 Amount 1988 $12,375 1988 $12,375 1989 10,375 1989 10,375 1990 8,375 1990 8,375 1991 6,375 1991 6,375 1992 4,250 1992 4,250 1993 23125 1993 2,125 $300,000 $87,750 $387,750 $43,875 $43,875 128 Date of Issue Date of Maturity Authorized Issue Actual Issue Denomination of Bonds Interest Rate Principal Payment Date Interest Dates Payable at VILLAGE OF DEERFIELD, ILLINOIS LONG-TERM DEBT REQUIREMENTS CORPORATE PURPOSE BOND SERIES OF 1983 APRIL 30, 1988 December 1, 1983 December 1, 1988 $500,000 $500,000 $ 5,000 8.5% December 1 June 1 and December 1 American National Bank & Trust PRINCIPAL AND INTEREST REQUIREMENTS Tax Bond Levy Coupons Due on Numbers Year Principal Interest Totals June 1 Amount Dec. 1 Amount 76-100 1987 $125,000 $9,000 $134,000 1988 $4,500 1988 $4,500 129 , VILLAGE OF DEERFIELD, ILLINOIS LONG-TERM DEBT REQUIREMENTS CORPORATE PURPOSE BOND SERIES OF 1986 APRIL 30. 1988 Date of Issue May 1, 1986 Date of Maturity January 1, 2005 Authorized Issue $11,000,000 Actual Issue $11,000,000 Denomination of Bonds $ 5,000 Interest Rate 6.4% - 7.75% Principal Payment Date January 1 Interest Dates January 1 and July 1 Payable at American National Bank & Trust Co. Chicago, Illinois PRINCIPAL AND INTEREST REQUIREMENTS Tax Levy Coupons Due on Year Principal Interest Totals July 1 Amount Jan. 1 Amount 1987 $ 175,000 $ 749,175 $ 924,175 1988 $ 374,587 1989 $ 374,588 1988 300,000 735,613 1,035,613 1989 367,806 1990 367,807 1989 410,000 712,363 1,122,363 1990 356,181 1991 356,182 1990 445,000 680,588 1,125,588 1991 340,294 1992 340,294 1991 485,000 646,100 1,131,100 1992 323,050 1993 323,050 1992 515,000 608,513 1,123,513 1993 304,256 1994 304,257 1993 545,000 568,600 1*113,600 1994 284,300 1995 284,300 1994 580,000 529,905 1,109,905 1995 264,952 1996 264,953 1995 620,000 492,785 1,112,785 1996 246,392 1997 246,393 1996 660,000 452,485 1,112,485 1997 226,242 1998 226,243 1997 700,000 408,925 1,108,925 1998 204,462 1999 204,463 1998 750,000 362,025 1,112,025 1999 181,012 2000 181,013 1999 800,000 311,025 1,111,025 2000 155,512 2001 155,513 2000 855,000 255,825 1,110,825 2001 127,912 2002 127,913 2001 915,000 198,113 1,113,113 2002 99,056 2003 99,057 2002 975,000 136,350 1,111,350 2003 68,175 2004 68,175 2003 1,045,000 70,538 1,1151-538 2004 35,269 2005 35,269 $10,775,000 $7,918,928 $18,693,928 $3,959,458 $3,959,470 [1 I 130 I Date of Issue Date of Maturity Authorized Issue Actual Issue Denomination of Bonds Interest Rate Interest Dates Payable at VILLAGE OF DEERFIELD, ILLINOIS LONG-TERM DEBT REQUIREMENTS CORPORATE PURPOSE BOND SERIES OF 1987 APRIL 30, 1988 October 8, 1987 October 8, 2002 $10,000,000 $10,000,000 $ 5,000 8.4% - 8.5% October 8 and April 8 Marine CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Tax Levy Requirements Coupons Due on Year Principal Interest Totals Apr. 8 Amount Oct. 8 Amount ' 1987 $ 1,264*500 $ 1,264,500 1989 $ 843,000 1989 421,500 1988 843,000 843,000 1990 421,500 1990 421,500 1989 843,000 843,000 1991 421,500 1991 421,500 ' 1990 843,000 843,000 1992 421,500 1992 421,500 1991 843,000 843,000 1993 421,500 1993 421,500 1992 843,000 843,000 1994 421,500 1994 421,500 1993 843,000 843,000 1995 421,500 1995 421,500 1994 843,000 843,000 1996 421,500 1996 421,500 1995 843,000 843,000 1997 421,500 1997 421,500 1996 1997 843,000 843,000 843,000 843,000 1998 1999 421,500 421,500 1998 1999 421,500 421,500 1998 843,000 843,000 2000 421,500 2000 421,500 1999 $ 7,000,000 843,000 7,843,000 2001 421,500 2001 421,500 2000 3,000,000 255,000 3,255,000 2002 127,500 2002 127,500 $10,000,000 $11,635,500 $21,635,500 $6,028,500* $5,607,000* 131 VILLAGE OF DEERFIELD, ILLINOIS LONG-TERM DEBT REQUIREMENTS WATER REVENUE BOND SERIES OF 1960 APRIL TO, 1 888 Date of Issue January 1, 1960 Date of Maturity May 1, 1989 Actual Issue $125,000 Denomination of Bonds 1-125 @ $1,000 Interest Rates 4.25% - 4.75% Interest Dates November 1, May 1 Principal Maturity Date May 1 Payable at LaSalle National Bank Chicago PRINCIPAL AND INTEREST REQUIREMENTS Year Bond Coupons Due on Ended Numbers Principal Interest Totals Nov. 1 Amount May 1 Amount 1989 116-125 $10,000 $425 $10,425 1988 $212 1989 $213 132 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS LONG-TERM DEBT REQUIREMENTS WATER REVENUE BOND SERIES OF 1959 APRIL 30, 1988 Date of Issue April 1, 1959 Date of Maturity May 1, 1989 Actual Issue $545,000 Denomination of Bonds 1-545 @ $1,000 Interest Rates 4.25% - 5% Interest Dates November 1 - May 1 Principal Maturity Date May 1 Payable at LaSalle National Bank Chicago PRINCIPAL AND INTEREST REQUIREMENTS Year Bond Coupons Due on Ended Numbers Principal Interest Totals Nov. 1 Amount May 1 Amount 1989 511-545 $35,000 $1,488 $36,488 1988 $744 1989 $744 133 1 VILLAGE OF DEERFIELD, ILLINOIS POLICE PENSION FUND SCHEDULE OF OFFICERS' DEPOSITS APRIL 30, 1988 Balance May 1 1050 Kenneth Anderson $ 28,030 1075 Leo Anderson 27,692 1078 Mark Anfenson 10,514 1125 Marcea Ross 21,488 1325 Richard Brandt 42,275 1335 Kurt Bruno 3,881 1350 William Butler 34,256 1355 Louis Cacciatore 6,431 1400 Robert Charles 32,544 1550 Gordon Cooper 26,387 1600 Robert Davenport, Jr. 43,346 1700 David P. Ebert 30,322 1750 John Elofson 27,869 1800 William Ennis 22,298 1853 Dani Beth Firfer ill 1925 Marie Rose Gawne 19,232 2000 Robert Hamilton 39,110 2100 Thomas Hill 35,378 2125 George Hoffman 29,720 2225 Kevin K. Keel 1,187 2250 Larry Kick 31,524 2365 Dave Lemmer 7,154 2430 Eric Lundahl 14,669 2525 Jeffrey McDermott 38,494 2715 Robert Ogden 13,224 2893 Rand J. Roel 9,697 2985 Michael E. Scarry 4,123 3025 John Sebben 26,837 3075 Thomas Sheahan 23,673 3125 Thomas Skrabala 33,886 3150 John Sliozis 23,173 3225 Michael Soler 25,063 3235 Melvin Soltwisch 4,755 3325 Gary Stryker 34,097 3500 Larry Tousignant 39,079 3525 David Turnbaugh 34,770 3675 Richard Weil 14,179 380A George Hall 9,604 380B David J. Petersen 7,287 380C Thomas G. Rogge 9,411 Ross Roel Balance Deposits Withdrawals April 30 $ 3,800 3,729 2,861 2,020 4,996 2,347 2,846 2$29 4,156 2,846 2,847 2,700 2,338 3,437 3,503 2,847 2,107 2,846 2,846 3,589 2,846 2,846 2,358 2,847 2,725 4,160 3,589 2,846 2,394 3,518 3,730 3,536 2,846 125 $ 31,830 31,421 13,375 23,508 47,271 6,228 37,102 8,960 $ 32,544 26,387 47,502 33,168 30,716 . 24,998 111 21,570 42,547 38,881 32,567 3,294 31,524 9,604 7,287 9,411 10,000 17,515 42,083 16,070 12,543 6,481 29,684 26,398 38,046 26,762 27,909 7,149 37,615 42,809 38,306 17,025 125 $886,770 $101,556 $116,868 $871,458 1 1 'J 1 1 1 1 1 1 1 i 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 134 VILLAGE OF DEERFIELD, ILLINOIS SCHEDULE OF INSURANCE IN FORCE APRIL 30, 1988 Insureds Description of Coverage Village of Deerfield Workmens Compensation Statutory/ $30,000,000 Village of Deefield Comprehensive Automobile Liability Bodily Injury and Property $1,000,000 Village of Deerfield General Liability $1,000,000 Village of Deerfield Blanket Building and Contents $30,000,000 Village of Deerfield Boiler and Machinery $10,000 Public Officials Blanket Bond Coverage $10 000/ $1,000,000 The Village of Deerfield is a member of the Municipal Insurance Cooperative Agency. Property, automobile liability, general liability, and workers' compensation are provided under the Agency. The Village of Deerfield is also a member of the High - Level Excess Liability Pool Agency. Excess liability coverage is provided under this agency. 1 1 I Statistical Section d L�� 1 I. q Am $ � ¥ _ r 135 Cli 0 C�l o $ ƒ o o n r 0 � % � Cli Ln . q 2 C14 & r- � » � Ln 0 Ln Ln m _� r m » g � 3 $ J S E 00 o n o ^ - 2 » C o < g r L 2 G ~ 9 9 2 K C 2 M r- r- - 7 % / Ln y $ M S G n M % 00 r � r M/| @ F R 2 $ 2 p ƒ /|$ @ 2 % S $ k _ 00 r � Ul ® % 4 - r- r- Ln S � - -IT r� / o � &| , c k k / M Ln 00 L IS § / / \ / b 7 ƒ /| $ Ln g C / \ / 3 _ M � \ t \ / / � $ � 7 � § 3 m 2 2 p 3 \ \ ' n 1 / . a| o n = q f g � � $ # / r e t - ? \ . S § ) $ o . u 2 ) �-4 00� / \ / \ \ � � / / c \ \ \ \ / @ / 0 k ® \ o k m / Lo / % 7 $ � \ w 2 \ G k / 5 k / w |% / X- / 0 / / G 6 � 3 w C) h / ON o ON � o 0 / ® 2 3 « w o @ 2 / \ k k E / � \ |ƒ n Ln � �D - v / 2 7 / A k Q 6 k S |/ w _ � w q \ $ k 6 |/ C $ u 4 2 o k ƒ / f / Ln|/ ON Ul ON $ 3 E G \ \ ? — w $ / $ / zo 3 |00 ƒ / ± / E G \ k Ln � ? y / $ / / Ln ƒ |/ o w Ln o � w 00 6 w 2 k / w |k $ / b ? y f \ 2 rQ NJ Ln o L G w « a � 14 � g[I ■ 1 ' VILLAGE OF DEERFIELD, ILLINOIS ' PROPERTY TAX ASSESSED VALUATIONS, RATES, EXTENSIONS AND COLLECTIONS LAST TEN FISCAL YEARS APRIL 30, 1988 1 I (See Following Page) 1-1 1 1 1 1 1 1 1 1 1 1 rt G 00 V 00 I F-' O fD C r• I� rrrrGO G • H. �o n rt C C b � rt rt rlb:-. �- b;�, � �;,, -M iA N OW 00 00 W LO O W p� H Lnn CT Ovo O W N Ln r-- �O 0N N 0 W V rt Lnn 000 In 0, In O � o (,� O In In pp Qp Op0 s V jrp��r I � co D El (p co r r jn V �O IUD N O %Q N V � WN p4 r 00 V W V V W rt OWO�.41Ln"0�-r- �O O O"OO NN I� O 601 N IN W N O O N N N r W I pip O Or Nip O W W W O OW O r� ONO V� rt O~O N N W O In m O %C V O N III I��W O O AU, N V OWO W � N rr L ONE O� N V F W pO BOoO 000 N 5 rt ONO O� DD CN I.- In N OO V In O co O N O CT CDI N O W v In 00 N N I coo C* O OVo� W N V V N N V N rr In In I'- — M CO V V N a I11 pp-ppi -4 00 0 N In Cn O 1J M GO vr1 M o0 � O n C�lN �D N �t •--� m co 0000 r+ M � CQ� O O S c0 L�1I OO1�a it1I ^I( H � +� OO 0011iO� 00 cVOOn I-13 I u1 00 !psp cc 1 Ln �1 r- coN� M �O N cn w� M M O Oi I c1T N O1I I�'tt N"D00 m ,t"O-�p7p CD N O --� �Ln O I N pp pppp . N M pN �D N Ln a Ni ^ � C� Obi pip M U'1 co .� 8 cn co oo cNir cC I %D pO 00 ON ^p Ln � H cU SOON G4 � Ln g0 -�,nT00p0 O� N In 1� � M �D N 00 ul O O� I 'D N� O\ O A 27 � pLnp N N v1 M --i 1.0 a I 0 tl} Ln N yytp�� M MN� o�N^��� t? HIco N O SON. -COI rl DII c� OO1:1�C 00 0000 ONO N 8� Ln a� M O Q\ O M M � co w m V> ?C NI -+ M 0000 M t0 VY cGG l� O5 Ln 1� OO �O• l cq F N O ^� CDN CD O V) O O � U 41 b 'd 41 14 w � a o 'o u ci� v o a �O m w H H ° ci: is m t 137 Tax Le vy Year 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 VILLAGE OF DEERFIELD, ILLINOIS ASSESSED AND ESTIMATED VALUE OF TAXABLE PROPERTY APRIL 30, 1988 Assessed Value Real Personal Property Property $167,268,250 $6,900,001 187,888,610 221,339,145 227,433,235 236,918,613 235,899,599 245,799,001 249,312,226 279,339,024 314,961,415 Railroad Estimated Property Totals Value $35,541 $174,203,792 $526,000,000 16,018 187,904,628 564,000,000 18,044 221,357,189 664,000,000 24,051 227,457,286 682,000,000 25,565 236,944,178 711,000,000 31,938 235,931,537 708,000,000 39,522 245,838,523 738,000,000 38,331 249,350,557 748,000,000 47,194 279,386,218 839,000,000 25,614 314,987,029 945,000,000 * No longer assessed due to change in Illinois State Statutes. Office of the County Clerk 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 i ON 0 8cn - moo, rn 0^rn n 139 00 H M N •'-i N 0000 I O N r—.-4 1-4 cn N O h� ON H O1 r- N V t � N --r cc! .-4 O1 %O O h h m N .-4 IO m N 00 %D %O 00 H V1 n M N M N N 9� Ln N N r, LnO M 8 � Obi cn O � V1 �p M N 1-4N N fV M 00 M %O %O N O O -t %O 1D d H h ON �l1 � O O O p--4 M cn h %O %O M n N ONO O� —Ln �t u O .M- N � I N N N N O O r-- '.O O N �o m 00 h � O p0pp0 Ncn O ( O0 Lr� h0 fi°1 �p NO N � N N N ON 'D O �Mp N chi NO p cN1 00 ) O� O I cn h -4 N 1.0 .� pp %.o as 0000 O �o O i h O O -t %O %D O N ��rp4 �O I •--� N N N �) ��D1 M O N p F ��Upp `O pp L�} H 00 CYN t� N 0 0 d O 00 O N IIR r+ N N N p O L � L M • 4 C!)- 'J L 4 �LJL w U CA x V O O U A d Lam+ ,C tip t°� r" ►� i d cn t+ ca 04 }C�- � • 4 JJ r, 1 'ram M v EO x L 7 A o . 14 ��• �� L TM cu F� Q w L cc7 0 '0 N L�� Q C N "d O L .4 U L W U cd CO w .l N �-r 1. .}�.� L*a U .� Ll •4 +J " �-+ � Cn p CJ L Ll ca .� W N ',� L CO L L• 4 ca Wu.+ a. L oa a �oA�cg o ,, b� C J U . a Cam{ (L� a) N Li+ U� US •,T. '"") GL C/] U1 •�' R'+ r+ m 00 (� > bD �u8 Cn C� Sor Z O a L U W CU LW O 140 VILLAGE OF DEERFIELD, ILLINOIS SPECIAL ASSESSMENT COLLECTIONS LAST TEN FISCAL YEARS APRIL 30. 1988 Fiscal Assessments Year Collections 1979 $66,386 1980 19,436 1981 21,919 1982 22,078 1983 30,451 1984 16,248 1985 35,075 1986 2,400 1987 5,465 1988 2,106 Village Records / _ 7� \ \ / m ) 9 J a $ 0 a \ { Ell— ol � \ � � \ ) k ) \ / § \ \ \ \ $ k ) k \ \ f .Ln % / § 2 co \ > & & / ) 7 / § \ \ / / Q . \ [ § ) 2 [ .I 7 \ Ln � \ enen _ / § \ $ / § / $ § � \ , # � ] / / \ \ \ _ / R Q ® / & & ) 29 ° / %c! \ \ ^ all \ Ln / In {� 2/ § > ] y = a = j ic 141 142 ' VILLAGE OF DEERFIELD. ILLINOIS SCHEDULE OF LEGAL DEBT MARGIN APRIL 30. 1988 Article VII, Section 6(k) of the 1970 Illinois Constitution governs computation of the legal debt margin. "The General Assembly may limit by law the amount and require refer- endum approval of debt to be incurred by home rule municipalities, payable from ad valorem property tax receipts, only in excess of the following percentages of the assessed value of its taxable property... (2) if its populations 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 there- after 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. Illustrative Computation of Debt Margin if Village Were Not a Home Rule Municipality Village of Deerfield is a home rule municipality and as such has no debt limitations. If, however, the Village were a non -home rule village its available debt limit would be as follows: Assessed Valuation - Estimated Legal Debt Limit - 8.625 Amount of Debt Applicable to Limit Sewerage Improvement Bonds $ 325,000 Sewerage Treatment Facility Bonds 675,000 Corporate Purpose Bond Series 1982 425,000 Corporate Purpose Bond Series 1982-A 300,000 Corporate Purpose Bond Series 1983 125,000 Corporate Purpose Bond Series 1986 10,775,000 Corporate Purpose Bond Series 1987 10,000,000 Available Funds (11,631,154) Legal Debt Margin $314,987,029 $ 27,167,631 10,993,846 $ 16,173,785 1 7 The Village has available funds in the Debt Service and Expendable Trust Funds , in the amount of $11,631,154. 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS SCHEDULE OF DIRECT AND OVERLAPPING DEBT APRIL 30. 1988 Governmental Unit Village of Deerfield Metropolitan Sanitary District Lake County North Shore Sanitary District Deerfield Park District Northbrook Park District Highland Park District Deerfield Elementary #109 Highland Park Elementary #108 Township High School #113 Junior College #532 Total Gross Debt Less Debt Service and Expendable Trust Funds Village of Deerfield Total Gross Debt Less Available Amount (1) Gross Debt $ 22,625,000 645,943,960 48,160,000 4,674,500 1,160,000 18,132,910 2,940,000 165,708 600,000 6,200,000 5,575,000 756,177,078 11,631,154 $744,545,924 (2) * Percentage of Debt Applicable to the Village 100.000% .081 5.109 .026 96.670 3.680 1.752 72.426 6.614 27.739 6.180 143 ** Village's Share of Debt $22,625,000 523,215 2,460,494 1,215 1,121,372 667,291 51,509 120,016 39,684 1,719,818 344,535 29,674,149 11,631,154 ciu nAl oar, * - Determined by ratio of assessed value of property subject to taxation in overlapping unit to value of property subject to taxation. ** - Amount in column (2) multiplied by amount in column (1). Data Source (1) Office of the County Clerk (2) Office of the County Clerk 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 y H V •� ¢Z C f�. ��Ly y n7J � J Ll K L 7 C N . rUi � U 145 146 VILLAGE OF DEERFIELD, ILLINOIS DEMOGRAPHIC STATISTICS LAST TEN FISCAL YEARS APRIL 30, 1988 (3) Percentage of. People Over (2) 25 Years of (4) (5) Per (2) Age With Four School Unemploy- Fiscal (1) Household Median or More Years Enroll- ment Year Population Income Age of College ment Percentage 1979 17,753 $34,678 32.0 49.2 4,838 1.0% 1980 17,430 35,000 32.7 50.1 4,568 1.8 1981 17,453 37,000 33.3 50.1 4,318 1.7 1982 17,476 39,000 34.0 50.3 4,106 2.2 1983 17,487 41,000 34.7 50.4 35,933 2.1 1984 17,500 45,000 35.4 50.7 3,788 1.9 1985 17,500 45,400 36.1 50.8 3,703 2.0 1986 17,500 46,100 36.5 51.0 3,715 1.7 1987 17,500 47,500 36.8 51.1 3,602 1.3 1988 17,500 48,100 37.2 51.3 3,276 1.1 Data Sources (1) 1980 - Census figure; 1979 estimated by using 1976-1980 Census data; 1981-1988 derived from data from the Department of Commerce and Community Affairs. (2) 1979-1980, Northeastern Illinois Planning Commission figures; 1981-1988 based upon Deerfield Chamber of Commerce figures. (3) Percentage of people over 25 years of age or over with 4 or more years of College education. Northeastern Illinois Planning Commission. (4) Enrollment figures derived from combined enrollement of District 109 (grade school), and District 113 (high school). (5) Unemployment figures based on 1/4 of Lake County figures. 1980 Census data figures show 7.0% unemployment for Lake County and 1.8% for Deerfield. 1 1 1 1 1 1 1 i 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS PROPERTY VALUE, CONSTRUCTION, AND BANK DEPOSITS LAST TEN FISCAL YEARS APRIL 30. 1988 (1) Commercial Construction Fiscal Number Year of Units Value 1979 81 $ 5,994,271 1980 52 1,580,392 1981 59 3,235,868 1982 77 9,758,795 1983 84 20,369,020 1984 52 12,146,201 1985 101 34,504,614 1986 135 37,746,399 1987 79 44,287,589 1988 110 21,705,751 Data Sources (1) Residential (3) Construction (2) Total Number of Units 50 67 85 86 104 46 50 90 86 51 147 Bank Property Value Deposits Value $ 1,176,405 $ 42,531,000 $519,000,000 5,650,240 49,178,000 564,000,000 1,8529788 52,282,000 664,000,000 1,689,832 53,522,000 682,000,000 5,673,638 63,218,000 711,000,000 5,131,160 63,877,000 708,000,000 6,552,552 64,750,000 710,800,000 11,318,142 130,155,000 748,100,000 8,089,179 141,241,000 838,160,000 5,489,656 149,182,000 944,962,000 (1) Construction figures - Village of Deerfield, Building and Zoning Department. (2) Bank Deposits were based on commercial bank deposits. (3) Estimated historical cost data provided by Township's Assessors Office 148 Taxpayers VMC, Inc. Stein and Company Baxter International Lake Cook Plaza Kitchens of Sara Lee Tollway North Deerfield - Saunders Joint.Venture Draper and Kramer LaSalle National Bank Flodstrom Construction Data Source Office of the County Clerk VILLAGE OF DEERFIELD, ILLINOIS PRINCIPAL TAXPAYERS APRIL 30, 1988 Business Deerbrook Shopping Center Lake Cook Office Center Office Buildings Shopping Center Bakery Products Tollway North Office Park Parkway North Office Building Deerfield Business Center Office Buildings Office Building Percentage 1987 of Total Assessed Assessed Valuation Valuation $14,506,467 4.6% 12,459,371 4.0 7,971,938 2.5 5,123,953 1.6 4,924,942 1.6 4,890,295 1.5 4,323,926 1.4 3,689,117 1.2 3,187,230 1.0 2,925,439 .9 $64,002,678 20.3% 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS MISCELLANEOUS STATISTICS APRIL 30. 1988 Date of Incorporation 1903 Form of Government Manager/Council Geographic Location North Suburban Chicago Area Population 1950 3,288 1960 11,748 1970 18,876 1980 17,430 MUNICIPAL SERVICES AND FACILITIES Fire Protection: Number of Stations. 1 Number of Firemen and Officers 29 Police Protection: Number of Stations 1 Number of Policemen and Officers 38 Education Elementary Schools 7 High Schools 1 Municipal Water Department: Number of Consumers 5,646 Average Daily Consumption 2,207,000 gals. Miles of Water Main 70 Sewers Sanitary Sewers 65 Storm Sewers 46 Building Permits Issued 566 Recreation and Culture Number of Parks 131 Acres Number of Libraries 1 Number of Volumes (Approx.) 125,300 Employees Administration 25 149