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, 1986
COMPREHENSIVE ANNUAL FINANCIAL REPORT VILLAGE OF D IELD, ILLINOIS 1 I COMPREHENSIVE ANNUAL I FINANCIAL REPORT I P H FOR THE FISCAL YEAR ENDED APRIL 30, 1986 PREPARED BY GEORGE VALENTINE FINANCE DIRECTOR I VILLAGE OF DEERFIELD 1 t 1 1 1 f 1 1 1 1 1 1 1 1 1 1 1 1 1 TABLE OF CONTENTS PAGE INTRODUCTORY SECTION Principal Officials i Organizational Chart ii Certificate of Achievement for Excellence in Financial Reporting iii Letter of Transmittal iv -ix FINANCIAL SECTION AUDITORS' REPORT ON THE FINANCIAL STATEMENTS 1-2 COMBINED STATEMENTS - OVERVIEW ("Liftable" 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 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-33 FINANCIAL STATEMENTS OF INDIVIDUAL FUNDS GOVERNMENTAL FUND TYPES GENERAL FUND General Fund Financial Statements Balance Sheet 34 Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual 35 TABLE OF CONTENTS (CONT.) PAGE FINANCIAL SECTION (CONT.) GOVERNMENTAL FUND TYPES (CONT.) GENERAL FUND (CONT.) Supplemental Statements Statement of Revenues - Budget and Actual 36 Statement of Expenditures - Budget and Actual 37-39 SPECIAL REVENUE FUNDS All Funds Financial Statements Combining Balance Sheet 40 Combining Statement of Revenues, Expenditures, and Changes in Fund Balances 41 Municipal Audit Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual 42 Emergency Services Disaster Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual 43 Youth Bound Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual 44 Library Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual 45 Supplemental Statements Statement of Expenditures - Budget and Actual 46 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 Statements Statement 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 Program Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual PAGE 47 48-52 53 54 55 56 57 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 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 Revenues, Expenses, and Changes in Retained Earnings - Unreserved Combining Statement of Changes in Financial Position PAGE 58 59 60 61 62 63 64 65 66 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 TABLE OF CONTENTS (CONT.) PAGE FINANCIAL SECTION (CONT.) PROPRIETARY FUND TYPES (CONT.) ENTERPRISE FUNDS (CONT.) Water Fund Financial Statements Balance Sheet 67 Statement of Revenues, Expenses, and Changes in Retained Earnings - Unreserved - Budget and Actual 68 Supplemental Statements Statement of Operating Expenses - Budget and Actual 69-70 Statement of Fixed Assets and Depreciation 71 Sewerage Fund Financial Statements Balance Sheet 72 Statement of Revenues, Expenses, and Changes in Retained Earnings - Unreserved - Budget and Actual 73 Supplemental Statements Statement of Operating Expenses - Budget and Actual 74-75 Statement of Fixed Assets and Depreciation 76 Refuse Fund Financial Statements Balance Sheet 77 Statement of Revenues, Expenses, and Changes in Retained Earnings - Budget and Actual 78 Commuter Parking Lot Fund Financial Statements Balance Sheet 79 Statement of Revenues, Expenses, and Changes in Retained Earnings - Budget and Actual 80 Supplemental Statements Statement of Operating Expenses - Budget and Actual 81 Statement of Fixed Assets and Depreciation 82 n TABLE OF CONTENTS (CONT.) FINANCIAL SECTION (CONT.) PROPRIETARY FUND TYPES (CONT.) INTERNAL SERVICE FUND Garage Fund Financial Statements Balance Sheet Statement of Revenues, Expenses, and Changes in Retained Earnings - Budget and Actual Statement of Changes in Financial Position Supplemental Statements Statement of Operating Expenses - Budget and Actual FIDUCIARY FUND TYPES TRUST AND AGENCY FUNDS All Funds Financial Statements Combining Balance Sheet Statement of Revenues, Expenses, and Changes in Fund Balance - Budget and Actual (Pension Trust Fund) Statement of Changes in Financial Position (Pension Trust Fund) Agency Fund Deposit Fund Financial Statements Statement of Changes in Assets and Liabilities PAGE 83 84 85 m 87 88 89 90 ACCOUNT GROUPS GENERAL FIXED ASSETS ACCOUNT GROUP Financial Statements Statement of General Fixed Assets 91 Supplemental Statements . Statement of General Fixed Assets - By Function and Activity 92 Statement of Changes in General Fixed Assets By Function and Activity 93 TABLE OF CONTENTS (CONT.) PAGE FINANCIAL SECTION (CONT.) ACCOUNTS GROUPS (CONT.) GENERAL LONG-TERM DEBT ACCOUNT GROUP Financial Statements Statement of General Long -Term Debt 94 SUPPLEMENTAL DATA Combined Statement of Cash and Investments 95 Combined Statement of Investments 96-100 Long -Term Debt Requirements Sewerage Improvement Bond Series'of 1973 101 Sewerage Treatment Facilities Bond Series of 1973 102 Corporate Purpose Bond Series of 1983 103 Corporate Purpose Bond Series of 1982 104 Corporate Purpose Bond Series of 1982-A 105 General Obligation Variable Rate Demand Bond Series of 1984 and 1985 106 Police Addition Installment Contract of 1979 107 Water Revenue Bond Series of 1960 108 Water Revenue Bond Series of 1959 109 Statement of Officer's Deposits (Police Pension Fund) 110 Statement of Insurance in Force ill STATISTICAL SECTION General Governmental Expenditures by Function - Last Ten Fiscal Years 112 General Governmental Revenues By Source - Last Ten Fiscal Years 113 Property Tax Assessed Valuations, Rates, Extensions and Collections - Last Ten Fiscal Years 114 Assessed and Estimated Actual Values of Taxable Property - Last Ten Fiscal Years 115 Property Tax Rates - All Overlapping Governments - Last Ten Fiscal Years 116 TABLE OF CONTENTS (CONT.) STATISTICAL SECTION (CONT.) Special Assessment Collections - Last Ten Fiscal Years Ratio of Net General Bonded Debt to Assessed Value and Net Bonded Debt Per Capita - Last Ten Fiscal Years Statement of Legal Debt Margin Statement of Direct and Overlapping Debt Ratio of Annual Debt Service Expenditures for General Bonded Debt to Total General Governmental Expenditures - Last Ten Fiscal Years Statement of Revenue Bond Coverage - Water and Sewer Bonds - Last Ten Fiscal Years Demographic Statistics - Last Ten Fiscal Years Property Value, Construction, and Bank Deposits - Last Ten Fiscal Years Principal Taxpayers Miscellaneous Statistics PAGE 117 118 119 120 121 122 123 124 125 126 1 1 1 1 1 1 1 1 I 1 1 1 0 1 1 1 1 VILLAGE.OF DEERFIELD, ILLINOIS PRINCIPAL OFFICIALS APRIL 30, 1986 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 co z �O ww C)Z CC J o 02 to 0 Q U 0 �cn Qw U Ow WLU r J m co O C9 m °d m J Q cr Q J Q a. a ~ > o z u ZO Z Z W V R N — U w CY-0> Z W W W W W Z p > mw wR ZZ U. Z p m =O z J fL Z J O w a g w n. V V W VW N z Z V Z ~ Z Z Z W w 0u W �Z JO W m a NUp m <C.ZW Y x wY F- W z cn w U w w z V � Vg w UZ ceQ F- F- Q F- w _Q = w O Z to w U Q O � 3 Q N� w N F- F- Q j Z N m F- Q O Q a 72 W O z O W F- O Z Q J Q¢ > Q w F- F- p F- Q W Z 2 -1 m OW U0: O Q Q V W Z V Z F. > W w Z_ -� Z U F- ?� Z J N z w z W Q z m Q z IL p O U W �Z Ul w >- F- U w m Q H< CL =i a=. L N Z O Z O H Ww LU 0 Q r Q N a rg W f.. V O u a:U O a w O w CL a v~i O LUi w W G^ w > Z p �G '— U ii 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, 1985 A Certificate of Achievement for Excellence in Financial Reporting is presented by the Government Finance Officers Association of the United States and Canada to governmental units and public employee retirement systems whose comprehensive annual financial reports (CAFR's) are judged to substantially conform to program standards. NIIED STA1ES ND President CORPORATIN s Executive Director 1 1 1 945.5000 ILLINOIS 850 WAUKEGAN ROAD DEERFIELD, ILLINOIS 60015 September 8, 1986 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, 1986, is submitted herein. 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 Government 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 are designed to provide reasonable, but not absolute, assurance regarding: (1) the safeguarding of assets 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 safeguard assets and provide reasonable assurance of proper recording of financial transactions. iv Budgetary control is maintained at the departmental and subdepartmental level through a system of purchase orders and a monthly reporting system which reports against 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 - NCGA Statement 3". 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, highways and streets, sanitation, health and social services, cultural, 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. ' General Governmental Functions Revenues for the General Fund, Special Revenue, and Debt Service Funds ' totaled $6,538,035. This is an increase of .88% over 1985. However, 1985 revenues included a sale of property for $487,798. Excluding this sale, revenues increase 9.1%. Taxes produced 63.4% of general revenues compared to 59.9% last year. Of the amount that is listed as taxes,. $2,107,649 was property tax revenue. The prior property tax extension was $1,935,486 for an increase of 8.9%. Sales tax is also included in the general category of taxes, in the amount of $1,569,780, an increase 1 of 4.3% over the prior year. ' 1986 REVENUE Increase Percent (Decrease) Revenue Source Amount of Total from 1985 ' Taxes $4,1�812 3-. 26 F,3 Licenses and Permits 536,390 8.2 56,802 Intergovernmental Rev. 551,928 8.4 36,210 Charges for Services 144,040 2.2 (2,088) Fines and Forfeits 389,552 6.0 79,400 Miscellaneous Revenues 772,313 11.8 (373,374) ' TOTAL $6,538,035 100 $ 57,274 The current year (1984) tax levy collections were approximately 99.5%. Property taxes which are delinquent more than one year are written off; subsequent collections of such taxes are reflected as 'prior year 1 ' revenues' in the year collected. Allocation of property tax levy by o purpose for 1985 and the preceding three levy years is as follows: 1985 1984 1983 1982 , Purpose Tax Rate* Tax Rate* Tax Rate* Tax Rate * 'General Fund .168 .183 .191 .191 Special Revenue Funds .483 .446 .427 .414 ' General Obligation Debt .458 .232 .207 .153 Pension Trust Funds .066 .062 .060 .052 Enterprise Funds .156 .151 .148 .140 , TOTAL TAX RATE* 1.331 1.074 1.033 .950 *Rate per $100 of equalized assessed valuation ' Expenditures for General, Special Revenue, and Debt Service Fund purposes totaled $6,627,747; an" increase of 8.0% over the prior year. ' 1986 EXPENDITURES Increase Percent (Decrease) Function Amount of Total from 1984 Genera —Government $ 995,330 16.1 $ 286,6 2 Public Safety 2,026,305 32.7 242,783 Highways & Street 942,366 15.2 29,766 Culture & Recreation 857,226 13.9 161,440 Misc. Expenditures 315,080 5.1 21,148 Debt Service 1,050,250 17.0 289,437 TOTAL $6,186,557 100 $457,952 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 1986 fiscal year is as follows: I Outstanding General Obligation Bonds by Issue ' Sewerage Improvement Bonds Series of 1973 $ 525,000 Sewerage Treatment Facility Bonds Series of 1973 925,000 Corporate Purpose Bond Series of 1982-A 400,000 ' Capital Improvements - Series A 1984 4,100,000 Capital Improvements - Series B 1985 6,900,000 TOTAL $12,850,000 ' Other Debt to be Abated from T.I.F. District Corporate Purpose 1982 Bond Series of 1982 $ 475,000 ' Corporate Purpose 1983 Bond Series of 1983 350,000 TOTAL $ 825,060 , vi _. ' ' GRAND TOTAL BONDED DEBT $13,675,000 Less: DEBT SERVICE FUNDS 1,423,337 ' NET BONDED DEBT $12,251,663 Ratio of Net Debt to Net Debt Amount Assessed Value Per Capita ' Net Bonded Debt $12,251,663 4.92% $700 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 April 24, 1986. Cash Management ' Cash temporarily idle during the year was invested in repurchase agreements, certificates of deposit, and treasury bills. Funds held for the Police Pension Fund are invested in treasury bonds and notes, ' treasury strip coupons, and repurchase agreements. As of April 30, 1986, the total amount invested by the Village was 99.9% of available funds. The total interest earnings for the year for all ' funds, including the pension funds, was $1,099,146. For the prior fiscal year, the total amount earned was $1,200,891. General Fixed Assets The General Fixed Assets of the Village are those fixed assets used on the performance of general governmental functions, excluding the fixed ' assets of the Enterprise funds. As of April 30, 1986, the general fixed assets of the Village amounted to $4,546,620. 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,420,580 and operating expenses of $1,203,500, or a total operating income of ' $217,080. Revenue bond coverage for the year ending April 30, 1986, was 4.57. ' The Sewerage Fund had operating revenues of $1,014,219, operating ex- penses of $854,717, for an operating income of $159,502. The Refuse Fund had operating revenues of $439,028 and operating expenses of $810,235, for an operating loss of $371,207. However, there was a ' property tax levy for $399,219 for refuse purposes. This revenue source more than adequately covers the operating loss. The commuter parking lots' revenues were $90,731, with operating expenses of $25,439, for an 1 operating income of $65,292. vii Prospects for the Future The Village is planning to issue long term debt to redeem the short term demand notes currently outstanding. The $11,000,000 bond issue will be dated May 1, 1986. The date of redemption will be May 15, 1986. This will reduce the Village's tax levies by $1,455,992, with a net present value savings of $943,867. The Village's Tax Incremental Financing District (TIF) 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. This growth has been faster than had been anticipated. Fund Balance -Designations The Village is establishing several designations of general fund balances. The desi nation for the replacement of machinery and equipment 600,000 . This designation will, in future years, establish a separate equipment and vehicle replacement fund for the replacement of Public Works' operating equipment and vehicles. Area improvements: Brick ards ($322,000). This design is for the improvements to the area described as the Brickyards. Area Im rovements: Downtown ($500,000). These funds will be utilized to enable the Village to encourage development/redevelopment in the central business district. Independent Audit 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 Canada (GFOA) awards Financial Reporting to its financial report. Officers Association of the United States and ' � Certificate of Achievement for Excellence in units of government for the comprehensiveness of 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 standards. Such reports must satisfy both generally accepted accounting principles .and applicable legal requirements. 11 11 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. I ' believe our current report substantially conforms to Certificate of Conformance Program requirements. We are submitting this report to GFOA to determine its continuing eligibility for a certificate. ' Acknowledgements 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. Respectfully submitted, George J. Va enti e ' -Finance Director Village of Deerfield u 11 1 L� I Financial Section 71 L� fl I [l 1 I ' Certified Public Accountants The Honorable Bernard Forrest, Mayor Members of the Board of Trustees. Village of Deerfield Deerfield, Illinois We have examined the .combined 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, 1986 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 combined financial statements referred to above, present fairly the financial position of the Village of Deerfield, Illinois at April 30, 1986, 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, 1986, 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 I I Our examination was made for the purpose of forming an opinion on the combined financial statements taken as a whole and on the combining, individual fund, and account group financial statements. The accompany- ing 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 combined 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 combined 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. a _ Karrison & Byrne July 18, 1986 I COMBINED STATEMENTS -OVERVIEW d 1 1 1 f 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS, ALL FUND TYPES AND ACCOUNT GROUPS COMBINED BALANCE SHEET APRIL 30, 1986 (See Following Page) 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 N(a N W Z Gg '1 m ry y 2 yv 9 n N " ? $ �' r � w � Zo w `ono y. `p co v Li rpi. o�o vOl W vi OD N N � N r+ V pp y0 O O O 0 W V O � 'O W g c$ W O F F V p 00 O Oo p 0 to a VO O N_ W W- O N N W W T V CD OD o o a; F N N co y N W W F CO N F F O� O p V 4+ V N •-O lA O OD F 00 � pN O` W pNp O� O W rip F V p4' OD OD N' O% �O O W V m W F N'D F F O V V N F O �D V N O In Vt vi Qp •+ O N pp W OD W�'o V O p D O% p 1 1 1 1 1 1 1 1 t 00 N J 00 In O H1 01 .-' 00I '0 .r 00 O� m I'- I� �rp� vp� 8 �+1 J �n ion O O� �n C •�-� J~ cn N 10 N V1 Cn •--� .n-� O 3 N �A N 19 V1 .N-� � N n l'�1 O ti 7 t? o0pp Vl pN Vs N �Np (R C�n8 (A (A N t8? 91 CPI F .pp �7n J O iR��0OO O.700� O O U1 N O e^�10lVr, .fir N �p `ppOpp N 'O N' en V 'T V1 pp /'�1 O N V pppp n I� ap I f�1 N N C1 , o� T .fir n f"1 00 .�-I \ J O In t'1 N In N J .�-I O �o J •-� d .•• 00 O t+1 in V 4 � :O•I �p �O � In N N Olf N N N N t0 1•I VJ00 lyl NIIcI NI Ic;I cn III �p •yp� yq •.ya N O .N7Ifs OI a,In In IR J O c� M ell r- N J N N c�1 r J N N In {a.7 V} N � N r••1 N 4J a, N cn N N 00PI y 6 CO O r� In •--i .. --i .•-I �O 00 ru(,� lO %C v 01 V1 In en In In In In O N O N I I O O, T O, C11 N g N N N N N f? & I=, �, o ? a a ? lc cn (.IOQpi��, � I O� IIfA1 In v1 In O � ^ ppCpp ^ 1 ^ O N In J-I N N J 0000 V�1 T a, C 000 N N N~ N N In N yy O Ol G N �+ m 0 �>. rn C •.Oi ',a' N y N w C •.-. �� t�w•S� VH�i r•cpC�y!$ 0�1•�O�� �� � c��, Z c�0'�'�t°� � b � c� � � a •• O N al W In O L •7 � 7 1�•I N t0 7 � � � � d m � y B Ol 5�°io � 3 tom° � [S � r� w 0! 3 rn W a 0 E. H O z W W w a U W d .d V] CO O zz wo W W W a z N W O O H u z z W L) F U d0 F z O d G] w z F4 00 O V �7 ap 00 a0 N NN N NOO OM1O 10 V1 O O tp M V\00 OOOO d N 00 .--i N �/•� M V1 N O 00 M N O .-� N N N O O N V1 n M V1 n r 01 v\ 1D O1 01 O O •--� N 1p V1 01 O+ v\ 10 ^ OOI M T V\ O O 10 .-. •-+ M N V1 vl Vl V1 Vl Vl 10 M M 01 01 vl O N n O O n N W.. D1 D\ CDn00 Ma, V1M Vl n n 10 V1 O O1 O1 O w -r v1 ti M M N N n 01 1D N 10 .7 N M 00 1D 10 O v O 01 1D v 1D .r .-� v •D V1 1p 44 d M M M 00 Of •O ++ C O W H 0 O O10 0 NN M 0 10 (71dVII M 0ID.N 001 C) M U 'M 01 O M � J M CO) M N N �7 01 01 01 n n n 10 10 10 .4t OOI 01 1D •-, '7 01 00 01 V1 1p N n 10 00 O O 10 10 O O V1 u•1 00 N N N .--i � M V1 d 00 N 01 N .t V\ Oi M N M O 00 10 '7 .7 %0 n 00 00 00 10 1D v\ .•-i M N 00 00 O1 O 01 00 10 00 V1 V1 V1 1D 10 OO OO N V1 v1 v\ OO V1 .•� 00 N N 01 v ... %D 10 10 00 00 00 :1 (? V} V). 'Al V) V} V> Vi V} r C d d n n n 00 v\ 00 rl N 40 OD T 01 00 00 V\ V1 V1 1p 00 00 T 01 01 O .1 v) V N 1p 1D M M N I N M M M U U a N N N N N V1 N Vf VT VY V? Vl Vf Vi Vi VT Vi d 1D V1 .•+ V1 N n 10 O M O1 N N N .r N r-i L v1 01 M Ili V1 u, 01 C1 V1 n O Vl M M N v\ Ut n N N 1p O '7 n '7 n .1 n 1p co u u O1 01. noO 2 O1 v\O d O O O N .+. 12. N In V1 n nM N M 00 � N 01 10 d 00 n M M O M O M O M M n co0 .. u, u a ri ri o f ,0 10 v; s -4r O+ O C O 10 10 0 0 0 d O O 1D n W V a0 N 10 V1 01 O V1 O N 1n N T N T 01 10 N n N n N n M M :J •'1 .+ •0 > 00 O o0 O CD .7 M 01 01 01 M of d! w Cl ^-� O N M V1 d M M 01 N N N N CA �N vl �. n v1 V1 O v 10 10 N .-. .-. .•., .T a C >r OJ O V M J N 00 M O M 10 10 .-, G)l N N 1p 00 nr N 10 N o0 a` O oo a0 OO n 1 �tl 7 c m M 1p V1 n �7 n V1 M N O Vl O M M Op Op OO Op 01 U N V1 10 00 •••� M V1 M N n V1 00 n 10 N _ T n n n V1 N D M n n n p a u) a 01 co 00 a0 ao n �+ N N N VT VY VY V} VT VT V> V} V? VY try 01 10 1p N N 01 O N N n O O n N N N 01 .. 10 N 1p O n v1 .7 N n d N 10 M M o0 M n -+ v1 N O O O u•1 O N v1 M v1 M u1 M O 10 H O1 O 01 M N wM v1 N 00 11 1D .D 01 O0 00 a0 n C ^-� 10 N n oo a0 .--i a0 N 10 v v1 T 01 OT V1 O) V �? N M V1 10 m O O 10 1p N N N T N M N M N N N N tll •o l� > sL• D C u Vl 01 O 0 D0 v O ^ 07 L � w 7 N �a H v C L > N^ v > w m .� u m PUGC> 7� w L L N U L :.J C •••� N O N N �••� v O O m N :J N N U N L W O O1 W O u C C :J U C U a)u e 0 U W 1, U Vi u O N v L V m N .� WWWM O m U •O cc co ul L 1+ F. �0 •w N > C In0! ••� W 'O T �++ N p w w w t+ N •� N U L N U F+ T W m a�+ C u 01 u fn •n 0) r u 7 •p V T T a C w 4, 7 W V] m C :, •O C T y •C Ol > C O > N b O a C a C A �+ U 7 C C V 00 U n7 V C O O N V) U d C u u 01 ..+ ..+ 'O E 0 7 U o O w N C U w N nl X ..+ m F ..+ •p 7 7 C C I.. k. O> V O C :� u .-+ W V U V) .0 F '++ V 7 m O O' v' �O �+ O U y •O n 0) V7 m N 77 •5 O L T a ..+ 4 7 O w O) ., CO W W o •4+ Ol W C C ai > C Of O1 •� y •a O> u! N N u N �+ .r t, •.+ U cc w DO U ++ C C 00 00 C C C 0 W i •.+ U :� •O u C al 'O .� ..+ O U O 0 O ^+ -+ 7 +� N ..+ 3 7 U -+ w u u +•+ C •�+ .. C ••+ .- •O L] O C of a v �O ro M N 0 00 U .--i A :.+ C N .--i i u V of V) C N O v •p u .+ :.! :-J Ol ..i 01 ,� u C 7 U m. C �+ 00 m U- .,� U C p 00 •-+ N :J ..+ :J F C C W U O w •O 6 n7 -� �. N •d 'O .-i 7 U U w w U u O •O 1+ N 7 •., 7 .+ :.+ 1. C •cap. N w 10 4 w u N C X IQ •+ •+ C X V +-' LL C y F > H rC, U t+.- E -- C 5+ (7 a x v tyy� a N U U O ry� 0. C O 1+ U1 a)11 O Pam. 0 t0 W u >— ••p-1 N 0 4 .] a w u W W t O C E a 6 12 W 6 a w 0 c w N 0 co ONMin O.n 10100 OOr 00 Ov1 v1 M r O O, N In .--1 M M p 10 N 00 O co N O co T C ODM C� O•nIli 0 MMM NO ON V1 d TM V1 O 00 OO O 7 M �p .•r O+ 'D .-. O .•� O� "'� V� �D M 1n w r M O, N .7 Ln M 0 N �D r 00 d O d U .•+ v1 u'� •-+ M r V� O. O C', co M Ln vi .•-i M 00 M .--� m m t/s vY H H Vs fI? K N w O Na0O^-�OO••+O _ 'D O N 00 co o•--io WN0 00 T.1O 0 r 0-+.1 r opO O.DO n C i ri --i v. O O N r � O. �D m C O C n O M 0 0 0 O O d 10 ^+ O. d oD •--� nM n ON NM 1n M �• O N Ln0 d O O O M V1 D 0 N eq d N N W O F 3 �D t? t? •� N N N N to N t? O lD C. O O d O_ r CD v1 C,V1 V1 Cn N M r. N �0 O� N N O N 0 O� �D r M C 7I 00 O O0 0 0 0 .•+ d .t M C, M N M Ln d M M O, N W u C� N _Ni d u us ur .n as ar us N N as m O -� 0-•--� -+ O EnO in O �D O u M O M C, G O O D .Aw V 1 u m A aD � 1 J O 00 00 r 2O n O 00 in K).�r M M , .. H N fA N N N i? v). M J N 00 M O M %D .D O �n m •--� N N %D CO .-� N %D N 00 O 0 co •p .-1 M lD to r .•► r V1 M N O .••� .n O M Ili 00 CO O� C m _ _ .. _ _ _ _ _ _ _ _ _ _ 7 7 in �p 00 .•r M In M N r � 00 r '0 Y'\ m W u Map 2 4 i g N N�DM N v1 .••i C, co ^ 2 v 00 r Ol d 0 N N N N N N f? N N N {? > N a rOOO -. a0 OO nO .n M 000 r 000 OHO M r OOO N .••� u cc w .n c N lG 0 0 0 M •.• 00 CO O M r J N V1 Jlo �-•� r u1 lD a,M n u •O N %D N r M N r O N O .••� N CI. r V1 m N N v1 M �0 N N .r N N t? m %D '0 N N 'llol O N r 0 0 r N D. r-1 fV '0 O n .n "7 bD N r N .n .r M M 00 M r .N-� •--1 vY N O O O O N M �D 0 u OM N C� M _ 00 ,0 N r co 00 Ln N D� N 0 •--� w �D l0 %0 O , to 00 O� r V1 C d N M N O. N N W Vcn f t/> q) V., t? N N N m � w O O •--� 0 0 0 ••-� O •--� •--i O O O O o 0 N OON OOO N O n r C 0 0 N OO M n O O 00 r OOO O O O N N u OOP �D l0 O8 M O uY lD N MAD r � O .-. O, .••� M v N .y N M N M t? t? N N N VT N N w m a m O1 mt � C O m C t 11 >>y w .. m .0 u m 01 OG O N w m m m u (V of w m w w Q) p O A ••+ U m +.. u 01 /+ w 4! m u C w m> ..+ m Enu •.w. W •C T m N 0) u w N 01 w T m u C u 'C 0 •pN u w U > CL mC u7 0 C CW pw0 Cda 0C + 0> W U •0 y Cow O d m W m mu—w C m> m w • a 0) cc W Ol 00 0 tom y Q m 00 N •-+ m u C O1 �. t u u vi C m 0 W u 0) m C L 00 m y u .. O) C A 00 .-. m •.. u F C 0 w w m w w u 0 C X u u m C m F •0 w C w OO77 7• 0 w C u iL w u Z A W r•1 m w m m m C O) m C L ••' .. N 7 W O! > ••• > H .a �••� C� w T a u C u O w W W m m _ C O d U m m w w w 0 m m 0-- �+ N m m C C 00 m m C+ E-4 F a C C C ,..� W m m w w w 61 N r O O O' 5 Z VILLAGE OF DEERFIELD, ILLOIS ALL PROPRIETARY AND FIDUCIARY PENSIN ION TRUST) FUND TYPES COMBINED STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - UNRESERVED FUND BALANCE FOR THE YEAR ENDED APRIL 30, 1986 Operating Revenues Taxes Charges for Services Contributions Miscellaneous Total Revenues Operating Expenses Administration Operations Depreciation Benefits and Refunds Other Total Expenses Operating Income (Loss) Nonoperating Revenues (Expenses) Interest Income Property Taxes Interest Expense Net Income (Loss) before Other Financing (Uses) Other Financing (Uses) Operating Transfers (Out) Net Income (Loss) and Other Financing (Uses) Retained Earnings - Unreserved/ Fund Balance May 1 April 30 Proprietary Fiduciary Fund Types Fund Types Totals Internal Pension (Memorandum Only) Enterprise Service Trust 1986 1985 $ 173,723 $ 173,723 $ 156,125 $2,758,312 $128,562 2,886,874 2,526,987 97,525 97,525 75,750 206,246 361,378 567,624 497,277 $2,964,558 $128,562 $ 632,626 $3,725,746 $3,256,139 $ .251,314 $ 251,314 $ 227,184 2,642,577 $143,129 2,785,706 2,473,308 282,857 282,857 266,147 $ 67,873 67,873 65,912 937 937 25 3,176,748 $143,129 $ 68,810 $3,388,687 $3,032,576 $ (212,190) $0 4,567) $ 563,816 $ 337,059 $ 223,563 $ 953084 $ 95,084 $ 97,177 399,219 399,219 364,382 (7,438) (7,438) (91000) $ 486,865 - - $ 496,865 $ 452,559 $ 274,675 $(14,567) $ 563,816 $ 823,924 $ 676,122 $ (20,000) - - $ (20,000) $ (20,000) $ 254,675 $0 4,567) $ 563,816 $ 803,924 $ 656,122. $1,274,172 $ 31,228 $3,208,722 $4,514,122 $3,858,000 $1,528,847 $ 16,661 $3,772,538 $5,318,046 $4,514,122 See accompanying Notes to the Financial Statements. 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 fn h-r O z F-1 a a H A a W H w oc w w A w O w a a H N r\ OI, r\ n M n r\ O %�D O CO) ON N N V1 r\ 00 V1 N M N O N r-I -4 V1 r\ -- rl OO O� �O V1 M r` C �D 00 10 .T O �D r` M M --r a-, r` r` V1 O O 00 O CA ON V1 It O N N O ON Cn Cn r, u•1 r\ N 4 ND N ON C% N (n V1 M O% O f+1 M 0) < r vs cis <r, vs vs vs fC C b E4 «1 r`.4n.4 011 000N000Ln N %D w N V1 00 n 01% It V1 n O V1 ON V1 r` N 0 ON 00 n ON m r` N 00 O n 00 00 m w 001 M N N r .f N O - o0 0p C� 00 Z m O 00 00 r- .D .t O .t N O V1 N 00 00 N O -4 N m m 00 Vi C? N Vs Vi Vs t? m �o %D 00 r� r- r- �D M >+ () G r, .-r N V1 fn 00 T 00 w In. o 4 00 00 V) M ON M O N fv .4 fn •.d E•+ U) C M cl rr Lr 1t O 00 rn o E '^ cn vi u, ON in •o a N w w vs vs vs vs vs vs <rj- ca (D n n •-4 %D O G u %D %.D -,t N O O N 00 It w .14 Ln Ln N M N N V1 N N a) > r: r: w a) HM v co G. vs vs vs vs cis vs vs a) E- .,4 w b a) a G w V1 n N 00 —q —4 •-+ m O 00 00 M It O O •.a r- V1MOmc) OnO V%cn m 011 00 w w w %D 00 V, N as n .-4 00 O n r` ON N N a a w f` N N N V1 N O -4 C% N M �D a) 61% 00Mr, .4 N00 N Ln n :J N N Ln --r m cn W <fk Vr m a) L y w •d a) r. ..f W a) .0 a) •.+ •d w a co w fn r+ .0 to , 1 co 00 L L N •.f M G fn C C w a ro m CG m •.a n1 N V N JJ � C r01 G O w C G u N G ." O a) •b a) aJ O C O U F+ w a) w A 1J •.� a) •.•r z fo w m 0 w v w > 8 w .+ G C ^O ••+ •d a) O W O �d u •.•r •.a a) U w U a) > 0 $4 oGo P. G a) fu0 a) w w w 92 w co H O •4 H= CO a w w w m rn On.J . m :J a) CO m w CO fd a) co 'd 3 w w w 9 w u •.+ w C f0 .a Z U V u w l.j u H 'T a G w = G O w w s fn a CA O H A fn H a x A 41 w Z ro U Z U 7 1. 8 ' VILLAGE OF DEERFIELD, ILLINOIS , NOTES TO THE FINANCIAL STATEMENTS ' APRIL 30, 1986 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 - NCGA Statement 3". In accordance with NCGA'Statements 3 and 7, 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 and others. The Village considered the following entities when implementing NCGA , Statements 3 and 7. The criteria in Statements 3 and 7 did not require the inclusion of these entities in the Village's financial statements principally because the Village does not exercise oversight responsibility over such entities. Listed below are the entities that were considered: Deerfield Bannockburn Fire Protection District Highland Park Mosquito Abatement District �. North Shore Sanitary District 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, 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO. THE FINANCIAL STATEMENTS APRIL 30, 1986 1. Summary of Significant Accounting Policies (Cont.) B. Basis of Presentation - Fund Accounting (Cont.) revenues, and expenditures, or expenses, as appropriate. Government ' resources are allocated to and accounted for in individual funds based upon the purposes for which they are to be spent and the means by which spending activities are controlled. The various funds are grouped, in the financial statements in this report, into eight generic fund types and three 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. ' Debt Service Funds - 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. IPROPRIETARY 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. EJ 10 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 1. Summary of Significant Accounting Policies (Cont.) B. Basis of Presentation - Fund Accounting (Cont.) PROPRIETARY FUNDS (CONT.) 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. 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 using the modified accrual basis 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 ' 11 VILLAGE OF DEERFIELD, ILLINOIS . ' NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 Summary of Significant Accounting Policies (Cont.) ' C. Basis of Accounting (Cont.) 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 Federal Revenue Sharing Entitlements Income Expenditures are generally recognized under the modified accrual. basis of ' accounting when the related fund liability is incurred. All Proprietary Funds and Pension Trust Funds are accounted for using the accrual basis of accounting. Their revenues are recognized when they are earned, and their expenses are recognized when they are incurred. Unbil.led Waterworks and Sewerage Fund utility service receivables are recorded at year end. iAgency Fund assets and liabilities are accounted for on the modified accrual basis. 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). I 12 , VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 1. Summary of Significant Accounting Policies (Cont.) D. Budgets and Budgetary Accounting (Cont.) The level of control (level at which expenditures may not exceed budget) is the Fund. Budget lapses at year end. The Village also prepares budgets for Enterprise and Pension Trust Funds. Such budgets are included in the Village's financial report. The Village passed a Budget Amendment during fiscal__1986 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. 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 Motor Fuel Transportation Program Debt Service Debt Service Enterprise Water Sewerage Refuse Commuter Parking Lot Internal Service Garage Trust Police Pension 11 Budgetary Basis of Accounting , Modified Accrual Modified Accrual Modified Accrual Modified Accrual Modified Accrual Modified Accrual Modified Accrual , Modified Accrual Modified Accrual Modified Accrual Modified Accrual Modified Accrual I Accrual Accrual. Accrual Accrual Accrual Accrual 13 VILLAGE OF DEERFIELD, ILLINOIS ' NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 1 1. Summary of Significant Accounting Policies (Cont.) E. Assets, Liabilities, and Fund Equity Investments Investments are stated at cost or amortized cost, which approximates market. _ 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 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 than in governmental for in the General Fixed Assets Account Group, rather 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 general fixed assets. 14 , VILLAGE OF DEERFIELD, ILLINOIS ' NOTES TO THE FINANCIAL STATEMENTS ' APRIL 30, 1986 1. Summary of Significant Accounting Policies (Cont.) E. Assets, Liabilities, and Fund Equity (Cont.) ' Fixed Assets and Long -Term Liabilities (Cont.) All fixed assets are valued at historical cost or estimated historical cost if actual historical cost is not available. Donated fixed assets are valued at their estimated fair -value on the date donated. Long-term liabilities expected to be financed from governmental funds are accounted for in the General Long -Term Debt Account Group, not in the governmental funds. The 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. 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 1 15 VILLAGE OF DEERFIELD. ILLINOIS I NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 1. Summary of Significant Accounting Policies (Cont.) ' F. Revenues, Expenditures, and Expenses ' Property Tax Revenue Recognition Property taxes attach as an enforceable lien on January 1. 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 March 1 and August 1, and are payable in two installments, on or about June 1 and on or about September 1. The County collects such taxes and remits ' them periodically. Property tax revenues are recognized when they become both measurable and available in accordance with NCGA Interpretation 3. 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 accrued vacation pay and sick leave at April 30, 1986: Fund General $231,513 ' Special Revenue Street and Bridge $ 19,544 Enterprise Water $ 15,881 Sewerage 42,178 Commuter Parking Lot 967 $ 59,026 Internal Service Garage $ 7,000 Total $317,083 16 ' 1. VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30. 1986 Summary of Significant Accounting Policies (Cont.) F. Revenues, Expenditures, and Expenses (Cont.) Accumulated Unpaid Compensated Absences (Cont.) Accumulated unpaid compensated absences 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 Combined Statements - Overview Total columns on the Combined Statements - Overview are captioned "Memorandum Only" to indicate that they are presented only to facilitate financial analysis. Data in these columns do not present financial position, results of operations, or changes in financial position in conformity with generally accepted accounting principles. Neither is such data comparable to a consolidation. Interfund eliminations have not been made in the aggregation of this data. 17 1 1 L VILLAGE OF DEERFIELD, ILLINOIS . NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 1. Summary of Significant Accounting Policies (Cont.) G. Financial Reporting (Cont.) Total Columns on Combined Statements - Overview (Cont.) Budgetary Data The Village operates under the Budget Act. 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 National Council on Governmental Accounting, and are detailed in their publications entitled "Governmental Accounting and Financial Reporting Principles - NCGA Statement 1", and subsequent NCGA Statements and Interpretations. The Governmental Accounting Standards Board, successor to the NCGA, has issued GASB Statement 1, which establishes the authoritative status of NCGA Pronouncements and the AICPA Industry Audit Guide, 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, 1986: Illinois Municipal Retirement $0 5,058) Brickyards Development (26,141) Special Assessments 3-84 (76,549) Commuter Parking Lot (31,373) 18 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 2. Stewardship, Compliance and Accountability (Cont.) 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, 1986: Fund Excess Youth Bound $ 1,376 Transportation Program 2,892 Garage 11,279 3. Detail Notes on All Funds and Account Groups A. Assets 1. Pooling of Cash and Investments Except for cash and investments in certain restricted and special accounts, the Village pools the cash of various funds to maximize interest earnings. Interest income is allocated to the various funds based upon their respective participation. Investments are stated at cost or amortized cost, which approximates market. 2. Property Taxes (See Note 1, F.) 19 1 1 1 1 1 1 1 1 i 1 1 i 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 3. Detail Notes on All Funds and Account Groups (Cont.) A. Assets (Cont.) 3. Fixed Assets a. Changes in General Fixed Assets Balances Balances May 1, 1985 Additions Deletions April 30, 1986 Land $1,913,027 $ 2,283 $1,915,310 Building and Improvements 1,237,500 1,237,500 Vehicles 441,397 116,703 $187,000 371,100 Equipment 922,516 135,728 35,534 1,022,710 $4,514,440 $254,714 $222,534 $4,546,620 b. Summary of Proprietary Fixed Assets at April. 30, 1986 Enterprise Commuter Water Sewerage Parking Lot Land $ 77,500 Systems Equipment and Vehicles Parking Lot Less Accumulated Depreciation 4. Loans Receivable $ 785,215 $5,953,497 289,548 208,065 613,958 $1,074,763 $6,161,562 $691,458 588,166 1,199,841 212,704 $ 486,597 $4,961,721 $478,754 The Village has advanced funds for the Union Drainage District Number 1 to alleviate emergency flooding conditions. The balance at April. 30, 1986 amounted to $121,464 plus interest of $3,551. These receivables are recorded in the Capital Projects Fund and are considered current by the Village. 20 ' VILLAGE OF DEERFIELD. ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 3. Detail Notes on All Funds and Account Groups (Cont.) B. Liabilities (Cont.) 1. Retirement Fund Commitments (Cont.) a. Illinois Municipal Retirement Fund 1) The Village is a participating member of the Illinois Municipal Retirement Fund (IMRF) which covers all of its employees who: a.) occupy a job normally requiring 1,000 hours or more per year; b.) are paid on a regular payroll from Village funds; c.) were under age sixty when first entering employment; and d.) are not covered by another state created retirement system for the same service. 2) The Illinois Municipal Retirement Fund's (Chicago) actuary estimated that as of December 31, 1985, the present value of currently accrued retirement obligations of the Village was $3,200,625. The Village had accumulated assets of $933,515 on the same date. Therefore, the balance of $2,267,110 remains to be financed by future contributions payable by the municipality on behalf of its present employees. The normal cost portion of the Village's contribution rate is expected to provide $453,234 of this amount and the prior service portion of the rate is expected to provide $1,813,876. The latter amount is consi- dered to be unfunded at this time; it is sometimes referred to as the "actuarial deficiency". As required by Section 7-172, Chapter 108-1/2, Illinois Revised Statutes, contribution rates are fixed at levels, certified by the Fund actuary, sufficient to meet the entire cost of benefit payments ultimately to be made. Actual contributions this year totaled $286,670. This is a statewide plan, administered by IMRF. The Village has no further liability to this plan. 21 VILLAGE OF DEERFIELD, ILLINOIS ' NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 1 3. Detail Notes on All Funds and Account Groups (Cont.) ' B. Liabilities (Cont.) 1. Retirement Fund Commitments (Cont.) ' b. Police Pension Fund ' 1) Chapter 108-1/2, Sections 3-125 and -127 of the Illinois Revised Statutes, provide that municipalities shall establish and maintain a reserve fund of not less than $10,000 for each ' policeman and each beneficiary; provided that the. accumulated reserve shall not exceed the estimated total actuarial requirements of the Fund. In municipalities having less than the actuarial requirements of the Fund, the Board of Trustees of the Fund shall designate the proportionate amount needed annually to insure the ' accumulation of such actuarial reserve over a 40 year period ending in 2020. The total actuarial requirements at April 30, 1985 (the date of the latest computation) amounted to $4,007,843 as determined by the Village Actuary. Net present assets $3,150,123 Unfunded accrued liability 857,720 $4,007,843 Actual contributions this year totaled $173,723. This is a single -employer plan administered by the Village. 22 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 3. Detail Notes on All Funds and Account Groups (Cont B. Liabilities (Cont.) 1. Retirement Fund Commitments (Cont.) b. Police Pension Fund (Cont.) 2) Changes in Fund Balance Reserved for Employee Retirement Total Unreserved System Balances - May 1, 1985 $3,208,722 $0 ,207,241) $4,415,963 Additions Employer Contributions (Taxes) 173,723 173,723 Employee Contributions 97,525 97,525 Interest 361,378 361,378 Total Balances and Additions $3,841,348 $0 ,207,241) $5,048,589 Actuarial Adjustments (Increase) Decrease in Unfunded Accrued Liability - 349,521 349,521 Total Revised Balances $3,841,348 $ (857,720) $4,699,068- Deductions Pension Payments $ 67,873 $ 67,873 Miscellaneous 937 937 Total Deductions $ 68,810 - $ 68,810 Balances - April 30, 1986 $3,772,538 $ (857,720) $4,630,258 23 ' VILLAGE OF DEERFIELD, ILLINOIS t NOTES TO THE FINANCIAL STATEMENTS APRIL 301, 1986 1 3. Detail Notes on All Funds and Account Groups (Cont.) ' B. Liabilities (Cont.) 1. Retirement Fund Commitments (Cont.) ' b. Police Pension Fund (Cont.) 3) Municipal Contribution Requirements Per the Village's updated actuarial report dated April 30, 1985 the Village's contributin to the Police Pension Fund should be $135,876 for the year ending April 30, 1985. This contribution includes the amount necessary to provide the normal cost based ' on the annual payroll of active participants as of April 30, 1985 and the amount necessary to amortize the unfunded accrued liability of $857,720. 2. Commitments The following contractual commitments existed at April 30, 1986: Description Street Rehab ' Lake/Cook Sewer Sewer Repairs Manhole Rehab ' Sanitary Sewer Sewerage Treatment Plant Clarifier Expended Required Project Through Future Authorization April 30, 1986 Committed Financing $1,446,007 $1,287,638 $1,446,007 - 479,161 412,969 479,161 - 160,000 103,125 160,000 - 103,842 64,123 103,842 - 250,000 218,000 250,000 - 295,200 130,086 295,200 — 3. Claims and Judgments Liabilities resulting from claims and judgments, if any, have been reflected in the financial statements in accordance with NCGA Statement 4 and SFAS 5 provisions. 24 VTiT. m OF DOMFIEID, ILLIMIS NUMS TO ME FINANCIAL STATEhIIUS APRIL 30, 1986 3. Detail Notes on All Fiords and Account Groups ((bnt.) B. Liabilities (Cant.) 4. long -Term Debt a. Charges in Ingg-Tear Debt Adjust - Rind Debt Balances nent s/ Balance s Retired By May 1, 1985 Issuances Retirements April 30, 1986 General Cbligation Bonds Sewerage Improvement Bonn Series of 1973 Sewer gea tm ent Fac ili ty Boni Series of 1973 Corporate Purpose Bond Series of 1983 (brporate Purpose Bond Series of 1982 Corporate Purpose Bond Series of 1982 A General Cbligation Vari- able Rate Demand Bond Series A General Cbligation Vari- able Demand Bond Series B Installment Contract Pblice Addition Installment Note Revenue Bonds Water Revenue Bond Series of 1960 %ter Revenue Bond Series of 1959 Special Asses scent Bonds Debt Service $ 550,000 Debt Service 1,050,000 Debt Service 450,000 Debt Service 500,000 Debt Service 4503,000 Debt Service 4,100,000 $ 25,000 $ 525,000 125,000 925,000 100,000 350,000 25,000 475,000 50,000 400,000 $6,900,000 6,900,000 17,100,000 16,900,000 $325,000 $13,675,000 Debt Service $ 300,000 - $145,000 $ 155,000 Water $ 40,000 $ 10,000 $ 30,000 Water 135,000 30,000 105,000 $ 175,000 - $ 40,000 $ 135,000 $ 102,863 - $ 20,000 $ 82,863 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 3. Detail Notes on All Funds and Account Groups (Cont.) B. Liabilities (Cont.) 5. Long -Term Debt b. Debt Service Requirements to Maturity Fiscal Year End ing April 30 1987 1988 1989 1990 1991 1992 1993 1994 1995 25 ANNUAL PRINCIPAL AND INTEREST REQUIREMENTS General Special Obligation Installment Revenue Assessment Bonds** Contract Bonds Bonds* Total $11,652,825 $165,385 $ 50,737 $102,863 $11,971,810 550,364 48,826 599,190 542,548 46,913 589,461 395,025 395,025 376,775 376,775 358,400 358,400 365,550 365,550 143,500 143,500 82,200 82,200 $14,467,187 $165,385 $146,476 $102,863 $14,881,911 * These bonds are callable and have been allocated to the most current year ** The Village called the $6,900,000 and $4,100,000 Bond issue as of May 15, 1986 using proceeds of the new $11,000,000 General Obligation Issue dated' May 1, 1986. 26 P VILLAGE OF DEERFIELD, ILLINOIS ' NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 E 3. Detail Notes on All Funds and Account Groups (Cont.) B. Liabilities (Cont.) 5. Long -Term Debt 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. r 27 1 1 t 1 1 1 11 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 - 3. Detail Notes on All Funds and Account Groups (Cont.) B. Liabilities (Cont.) 5. 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 28 ' VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 3. Detail Notes on All Funds and Account Groups (Cont.) B. Liabilities (Cont.) 5. 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,539 Unmetered Customers 0 Hydrants 734 Gallons Pumped 834,495,460 Gallons Billed 740,817,750 Connecting Properties 5,498 6. Industrial Revenue Bonds The Village entered into agreements with Chi-Chi's, Inc., Teradyne, Inc., and Industrialplex Limited Partnership in which the Vill.age has authorized the issuance of Industrial Revenue bonds in the following amounts: Chi-Chi's, Inc. $1,615,000 Teradyne, Inc. $1,000,000 Industrialplex Limited Partnership $4,500,000 Trustee - The Citizens Fidelity Bank and Trust of Kentucky Trustee - State Bank and Trust of Boston Trustee - American National. Bank and Trust Company of Chicago The Village has no liability under these bond issues. 7. General Obligation Variable Rate Demand Bonds The Village issued $4,100,000 and $6,900,000 of General Obligation Variable Rate Demand Bonds to provide financing for Storm Sewer, Sanitary Sewer and General Street Rehabilitation Programs. These bonds have been reported as General Long -Term Debt under the provisions of Governmental Accounting Standards Board Interpretation No. l - "Demand Bonds issued by State and Local Governmental Entities." These bonds were called as of May 15, 1986 using the proceeds of a General Obligation Bond issue dated May 1, 1986.. I r r I 29 1 1 1 1 1 1 1 1 1 1 1 1 1 r r VILLAGE OF DEERFIELD, ILLINOIS. NOTES TO THE FINANCIAL STATEMENTS APRIL 30. 1986 3. Detail Notes on All Funds and Account Groups (Cont.) C. Interfund Receivables and Payables Due Due From To General General Debt Service $ 3,900 Special Assessment 44,018 Garage 2,283 Sewer $ 354 Deposit 1,214 Total General $ 354 $51,415 Special Revenue Municipal Audit Debt Service $ 160 Emergency Services Disaster Debt Service $ 77 Youthbound Garage $ 628 Street and Bridge Debt Service $ 7,130 Garage 5,786 $12,916 Illinois Municipal Retirement Debt Service $ 2,751 Total Special Revenue $16,532 Debt Service Debt Service General $ 3,900 Street and Bridge 7,130 Illinois Municipal Retirement 2,751 Refuse 3,559 Police Pension 1,528 Municipal Audit 160 Emergency Services Disaster 77 Tax Incremental Finance District 4,564 Capital Projects 11,176 Total Debt Service $34,845 30 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30. 1986 3. Detail Notes on All Funds and Account Groups (Cont.) C. Interfund Receivables and Payables (Cont.) Due Due From To Capital Projects Tax Incremental Finance District Debt Service $ 4,564 Fund for Capital Improvement - Series B 11,176 $15,740 Special Assessment Special Assessment General $44,018 Enterprise Water Garage $ 917 Sewer General $ 354 Garage 1,147 $ 1,501 Refuse Debt Service $ 3,559 Total Enterprise $ 5,977 Internal Service Garage General $ 2,283 Youthbound 628 Street 5,786 Water 917 Sewer 1,147 Total Internal Service $10,761 Trust and Agency Police Pension Debt Service $ 1,528 Deposit General $ 1,214 Total All Funds $91,192 $91,192 1 31 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 3. Detail Notes on All Funds and Account Groups (Cont. ) t D. Fund Equity (Cont.) 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. 11 1 32 Vni" OF DEERFIELD, ILLINOIS NOTES TO IM FINANCIAL STATENIIM APRIL 30, 1986 4. Segment Information fior Certain Individual Enterprise Fluids The Village maintains 4 Enterprise Fluids which provide water, sewerage, refuse and parking services. Segment information for the year ended April 30, 1986 is as follows: Commuter khter Sewerage Defuse Parking lot Fund Fund Fund Fund Total Operating Revenues $1,42 0,580 . $1,014,219 $ 439,028 $ 90,731 $2,964,55 8 Depreciation, Depletion, and Amortization Expense 49,931 202,228 30,698 282,857 Operating Income or (Doss) 167,149 (42,726) (371,207) 34,594 (212,190) Operating Transfers Out (20,000) (20,000) Tax Revenues 399,219 399,219 (Loss) 192,345 8,207 39,529 14,594 254,675 Net Incare Plant, Property and Equipment Additions 56,725 54,418 111,143 Deletions 8,264 89264 Total Assets 1,420,234 5,879,482 530,892 5%,957 8,427,565 Net Tbrking Capital 708,096 695,812 459,755 116,113 1,97 9,776 Bonds and Other Ivmg-Term Liabilities Payable fran Operating Revenues 1355000 135,000 Total Equity 1,148,401 5,773,878 459,755 594,867 7,976,901 33 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS 1 APRIL 30, 1986 5. 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. W B. Contingent Liabilities 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, 1986 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. 6. Subsequent Events The Village issued $11,000,000 of General Obligation Bonds dated May 1, 1986. The proceeds were used to call the $4,100,000 and $6,900,000 variable rate demand bonds. 1 a 1 1 Il L� I GOVERNMENTAL FUND TYPES 1 1 1 1 P GENERAL FUND I General Fund Fund Description The General Fund, also referred to as the Corporate Fund, is used to account for resources traditionally associated with governmental services not required to be accounted for in another fund. P 1 1 I t 34 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND BALANCE SHEET APRIL 30, 1986 1986 1985 ASSETS Cash and Investments $3,147,158 $2,308,177 Receivables Property Taxes - Current - (Net) 387,765 396,287 Accrued Interest 59,135 29,162 Due from Other Governments Sales Tax 115,419 101,043 State Income Tax 42,217 43,958 Court Fines 26,372 35,203 Due from Other Funds 354 140,380 Other Assets 58,282 27,479 Total Assets $3,836,702 $3,081,689 LIABILITIES AND FUND BALANCE Liabilities Accounts Payable $ 143,792 $ 58,417 Accrued Payroll 26,772 18,674 Compensated. Absences Payable 231,513 223,639 Due to Other Funds 51,416 47,716 Other Payables 5,600 14,891 Deferred Property Taxes 420,000 420,000 Total Liabilities $ 879,093 $ 783,337 Fund Balance Unreserved Designated for Capital Improvements $1,422,000 - Undesignated 1,535,609 $2,298,352 Total Fund Balance $2,957,609 $2,298,352 Total. Liabilities and Fund Balance $3.836.702 93.091_6R9 See accompanying Notes to the. Financial Statements. 35 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Revenues 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 Transportation Program Fund Excess of Revenues and Other Sources over Expenditures and Other Uses Fund Balance May 1 Apr i 1 30 1986 Budget Actual $3,183,221 $3,683,369 1985 Actual $3,845,420 3,196,001 3,018,112 3,061,490 $ (12,780) $ 665,257 $ 783,930 $ (4,000) $ (4,000) $ (4,000) 33,000 (2,000) (2,000) (2,000) $ 27,000 $ 6,000) $ 6,000) $ 14,220 $ 659,257 $ 777,930 See accompanying Notes to the -Financial Statements. 2,298,352 1,520,422 $2,957,609 $2,298,352 36 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND STATEMENT OF REVENUES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Budget Actual Taxes Property Taxes - General - Current - (Net) $ 420,000 $ 430,755 Sales Tax 1,600,000 1,569,780 Income Tax 375,000 390,520 Hotel Motel Tax 25,000 19,174 $2,420,000 $2,410,229 Licenses and Permits Beer/Liquor Licenses $ 35,000 $ 34,900 Food Licenses 3,000 3,648 Other Business Licenses 9,000 6,701 Building Permits 95,000 188,536 Animal Licenses 7,500 6,030 Non -Business Licenses and Permits 20,000 29,951 $ 169,500 $ 269,766 Intergovernmental State Grants $ 26,721 $ 23,406 Charges for Services Special Police Services $ 40,000 $ 33,704 Transfer Charges 36,000 36,000 Engineering Charges 10,000 2,568 $ 86,000 $ 72,272 Fines and Forfeits $ 180,000 $ 389,552 Miscellaneous False Alarms $ 20,000 $ 39,270 Sale of Materials 1,809 Sale of Automobiles 24,000 Rentals 30,000 39,206 Interest 175,000 289,781 Miscellaneous 6,000 31,697 Franchise Fees 70,000 92,381 $ 301,000 $ 518,144 $3,183,221 $3,683,369 37 VILLAGE OF DEERFIELD, ILLINOIS V/GENERAL FUND STATEMENT OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Budget Actual General Government Administration Department Salaries $ 560,000 $546,565 Overtime 8,000 6,564 Part -Time 83,000 57,253 Employee Benefits 61,000 52,738 Professional Services 119,000 107,778 Travel, Training and Dues 15,000 14,795 Printing and Advertising 16,000 11,694 Communications 22,000 16,482 Insurance 20,000 32,758 Contractual Services 39,000 33,353 Utility Services 3,000 1,076 Motor Vehicle Maintenance 8,000 3,656 Repairs and Maintenance 15,000 8,859 Equipment Rental 500 1,184 Miscellaneous 9,000 14,778 Supplies 20,000 24,356 Motor Vehicle Supplies 2,500 1,079 Dog Pound 5,000 3,712 Housing Assistance 10,000 7,800 Apparel 300 293 Equipment 33,000 25,553 Land Acquisition 4,000 2,283 Advisory Boards 10,000 7,859 Motor Vehicles 7,000 12,862 Total General Government $1,070,300 $995,330 /38 ' VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND STATEMENT OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Budget Actual Public Safety Police Department Administrative Service 1 Salaries $330,368 $328,211 Overtime 5,000 1,637 Part -Time 20,811 19,318 ' Employee Benefits - 27,845 27,861 Professional Services 2,950 1,374 Travel, Training and Dues 5,200 3,753 Printing and Advertising 7,100 4,227 Communications 25,000 21,147 Insurance 59,131 83,128 Contractual Services 31,966 18,477 Motor Vehicle Maintenance 1,000 1,335 Repairs and Maintenance 9,500 16,250 Supplies 10,050 10,530 Motor Vehicle Supplies 800 1,125 Apparel 3,750 2,771 Equipment -33,100 11,001 ' Advisory Boards Miscellaneous 6,700 1,857 1,960 $580,271 $555,962 Investigations Salaries $102,942 $ 989882 Overtime 12,997 9,298 Employee Benefits 8,990 8,825 Travel, Training and Dues 1,200 622 Contractual Services 12,875 12,449 Motor Vehicle Maintenance 2,500 2,719 Repairs and Maintenance 500 154 Supplies 5,000 2,504 Motor Vehicle Supplies 1,500 735 Apparel 1,200 1,356 Equipment 250 117 Motor Vehicles 8,000 7,500 $157,954 $145,161 Patrol Salaries $855,696 $849,685 Overtime 47,542 42,115 Part -Time 40,391 .32,771 Employee Benefits 80,450 72,492 Travel, Training and Dues 22,800 10,212 1 39 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND STATEMENT OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Public Safety (Cont.) Police Department (Cont.) Patrol (Cont.) Motor Vehicle Maintenance Repairs and Maintenance Supplies Motor Vehicle Supplies Apparel Equipment Motor Vehicles Special Services Salaries Youth Services Salaries Overtime Employee Benefits Travel, Training and Dues Printing and Advertising Contractual Motor Vehicle Maintenance Repairs and Maintenance Supplies Motor Vehicle Supplies Apparel Equipment Total Public Safety Total Expenditures Budget Actual $ 20,718 $ 18,562 2,000 1,159 8,420 5,833 24,904 221767 12,900 12,304 5,395 998 65,000 76,404 $1,186,216 $1,145,302 $ 28,091 $ 21,604 $ 132,754 $ 120,926 6,000 6,332 11,472 10,377 3,043 749 500 500 1,100 2,000 11266 500 127 1,200 755 2,000 1,670 800 554 11,800 11,497 $ 173,169 $ 154,753 $22125,701 $2,022,782 cz log nni cz nin il) 1 SPECIAL REVENUE FUNDS 1 IFund Descriptions ' Municipal Audit Fund The Municipal Audit is an independent, outside audit 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. Emergency Services and Disaster Agency 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. Youthbound Fund ' The Youthbound Fund accounts for the revenues collected and the expenditures incurred for this unique and very successful youth project of the Deerfield Police Department. Library Fund The Library Fund is used to account for the resources necessary to provide the educational, cultural and recreational activities of the Deerfield Public Library. Street and Bridge Fund The Street and Bridge Fund accounts for the revenues and resources used in main- taining approximately 10 miles of street and the Railroad Station in the Village of Deerfield. Illinois Municipal Retirement Fund The Illinois Municipal Retirement Fund is used to account for the revenues and expenditures associated with providing disability and pension benefits for Deerfield employees. This fund also provides the employer with a portion of F.I.C.A. Contributions. Public Benefit Fund The Public Benefit portion of local improvements installed under the special assessment procedure of financing is paid from this fund. Fund Descriptions Federal Revenue Sharing Fund The Federal Revenue Sharing Fund provides accountability for Federal Revenue Sharing revenues received under Title I of the State and Local Fiscal -Assis- tance Act of 1972. Motor Fuel Tax Fund The Motor Fuel Tax Fund is used 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 requires 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 con- trols; (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 The Transportation Fund is a Taxi Subsidy Program established for senior citi- zens and the handicapped. 40 1 1 1 1 1 1 1 1 1 i 1 i 1 1 1 cn Z5- 04 - U1O N .7Np�mp V� n V1 N OD0 O � 00 C1 V1 1A f\ m N ti Y1 0pp N ~ 00 y y y fNA F � prp 102 D ��Npp P 1 N N Y} � y O� N N 9R O w Os O V^1 �l1 v1 �n O O rn�O ri O n P1 ... N c�Op aD cn d .�i �O n N •-� O n GOVNf eN�1 C O y ~ y ~ y y N g •l+ �p OOI en cn N N 0co I I ��0! ^ y �ppp ��pp W en N N N N t? y ar t? N WI N I �I � I 1 I I N yl N yl � Nm O D .�•V � N III N N N �INI til � %. PG N W N N d cl + O O O ... .a N � ..-1 p 00 N Ed p 00 I I II lyl Y� oc 0 y yl KI ' 00 8 N epp'npp1I VI co 00 y � � u m I m ve .82 J 41 •U7 � N O L � y�p � 1y.� ..�y- ..py (�� u9�� pC� A� A u RF ITO 8n ~ V r� f� ~ !t 1w9 (D w fY [ E r• �+ iD "4 IG fD 'Q � eKj tD � � C r• m r• � r .-'tp'I �Q7 n � r• r m g fD m 5j55 �°' "`°�'• ��. ID �`°"• Edo .� 3�,�� m m r r N N N N o-N-• N 15� ���apQ' �O r• r �O �O �rp o-p�-p• � i� R I I� IO •p III I`p I�'I� IFI F ^ �• II00 W �� F III IF IWI W INI N m m 04 I'Fo�I� I�7 � � pO oo WV QQ Ir+• v rn "a, SOD N�appo y�N. ��I v� � F C O O �-•• OD F N J N N N N N N T N N 07 ^ N N N N N N IIir ID Ig wlw IO 00 7 a .cry IIN IW III I I III I I I I� P co IQ O III O N is N F V N N N OD m P V II I� ICI Iv I00 OD NIN I�I �$ N N N N N N Epp N N N-• pp co w ~ W� lW�/� p� V OD 1ppl� N� yN� W lF/� pW OND O� I T � W W S �O 00 N N IV-' OD N N fW-• . FF F v v V� l!� OO O� O TT W O W OD N F W OH ff w N N N N N N N N �N•. m r °°IJO,N F pp1010 RCV�S��1 V F ppW�� �QOOO pVp01 O� N (pT.� W pVp� QQN� �pWpD �O ppND� Epp--0�• V pQODDD OppD�� I V� 10 v V 117 42 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 BALANCES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Revenues Property Taxes - Current - (Net) Expenditures Contractual Excess of Revenues over Expenditures Fund Balance May 1 April 30 1986 1985 Budget Actual Actual $10,500 $11,784 $11,136 10,500 9,875 9,000 - . $ 1,909 $ 2,136 See accompanying Notes to the. Financial Statements. 9,970 $11,879 7,834 $ 9,970 J 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, 1986 Revenues Property Taxes - Current - (Net) Expenditures Travel, Training and Dues Communications Insurance Contractual Utility Services Motor Vehicle Maintenance Motor Vehicle Supplies Repairs and Maintenance Supplies Equipment Excess of Revenues over Expenditures Fund Balance May 1 April 30 1986 Budget Actual $5,000 $ 5,237 1985 Actual $ 5,078 $ 600 $ 513 $ 582 400 1,240 1,334 600 264 490 300 183 100 79 90 1,000 277 324 200 28 47 500 237 388 600 275 327 700 427 402 $5,000 $ 3,523 $ 3,984 See accompanying Notes to the Financial Statements. $ 1,714 $ 1,094 15,869 14,775 $17,583 $15,869 43 1 1 1 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, 1986 Revenues Project Income Expenditures Salaries Benefits Travel, Training and Dues Insurance Motor Vehicle Maintenance Motor Vehicle Supplies Repairs and Maintenance Supplies Lodgings Equipment Communications Contractual Excess (Deficiency) of Revenues over Expenditures before Other Financing Sources Other Financing Sources Operating Transfers In Excess of Revenues and Other Sources over Expenditures Fund Balance May 1 April 30 1986 1985 Budget Actual Actual $ 7,000 $ 8,648 $ 4,310 $ 1,000 100 400 $ 324 $ 336 660 291 619 800 1,932 1,454 900 760 518 600 187 3,800 4,518 1,261 2,548 1,500 200 62 1,400 1,718 1,766 1,100 183 $10,960 $12,336 $ 7,641 $(3,960) $(3,688) 4,000 $ 40 See accompanying Notes to the Financial Statements. 4,000 $ 312 7,186 $ 7,498 $(3,331) 4,000 $ 669 6,517 $ 7,186 44 45 VILLAGE OF DEERFIELD, ILLINOIS LIBRARY FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Revenues Property Taxes - Current - (Net) Replacement Tax Grants Non -Resident Fees Fees, Fines, Penalties Gifts Reciprocal Borrowing Xerox Interest Monies Allocated Reserve for Repairs and Replacement Expenditures Excess (Deficiency) of Revenues over Expenditures Fund Balance May 1 April 30 1986 1985 Budget Actual Actual $672,017 $ 593,893 087,720 7,000 14,604 15,046 9,300 17,432 9,314 6,000 7,510 7,820 30,000 45,614 34,432 500 1,215 3,572 2,000 3,943 2,032 20,000 19,276 20,271 10,000 35,324 41,215 95,000 143,368 $995,185 $ 738,211 $721,422 995,185 844,890 688,145 See accompanying Notes to the Financial Statements. - $(106,679) $ 33,277 385,770 352,493 $ 279,091 $385,770 1 1 i 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS LIBRARY FUND STATEMENT OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Salaries - Professional Salaries - Non -Professional Employee Benefits Professional Services Education, Travel and Dues Communication Insurance Contractual Services Utilities Repairs, Maintenance of Building and Equipment Building Supplies Carpet Supplies - Library and Office Books Periodicals Audio -Visual Binding Special Library Programs Data Base New Equipment Computer Service Cataloging Service Miscellaneous Automation Project Roof Budget $181,487 241,848 13,000 5,000 4,000 8,000 6,000 17,000 600 39,000 50,000 22,000 100,000 20,000 13,000 1,500 2,300 2,000 50,000 1,050 22,000 400 95,000 100,000 $995,185 Actual $171,319 218,147 21,181 10,501 4,232 6,276 7,019 8,406 527 23,376 18,526 79,122 19,351 15,423 872 1,437 1,085 16,076 634 6;521 1,224 74,645 138.990 $844,890 46 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, 1986 Revenues Property Taxes - Current - (Net) Property Taxes - Prior Vehicle Licenses Other Taxes State Highway Maintenance 50/50 Sidewalk and Curb Miscellaneous Train Station Maintenance Interest Expenditures - Public Works 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 1986 Budget Actual $220,000 $231,940 8,000 260,000 266,624 150,000 146,000 16,000 8,187 25,000 11,057 5,000 4,299 1,500 1,500 10,000 5,741 $695,500 $675,348 $ 79,820 29,465 40,410 80,440 45,650 14,230 96,945 71,365 128,340 13,840 11,265 24,265 12,470 34,085 $682,590 $ 93,165 35,748 37,698 81,199 43,667 15,162 106,883 51,823 113,153 13,592 16,102 22,817 8,446 22,984 $662,439 Excess (Deficiency) of Revenues over Expenditures before Other Financing Sources (Uses) $ 12,910 $ 12,909 Other Financing Sources (Uses) Operating Transfers In (Out) Parking Lot Fund $ 20,000 $ 20,000 General Fund (33,000) $03,000) $ 20,000 47 ' 1985 , Actual $170,163 258,884 140,000 15,884 13,553 5,858 1,500 9,346 $615,188 $ 85,679 26,753 36,438 97,834 36,626 15,435 102,948 71,202 138,067 9,260 8,403 14,479 13,090 19,154 $675,368 $(60,180) $ 20,000 .$ 20,000 Excess (Deficiency) of Revenues and Other Sources ' over Expenditures and Other Uses $ (90) $ 32,909 $(40,180) Fund Balance May 1 (1,770) 38,410 ' April 30 _ $ 31,139 $ (1,770) See accompanying Notes to the Financial Statements. 1 48 U VILLAGE OF DEERFIELD, ILLINOIS STREET AND BRIDGE FUND STATEMENT OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Public Works Administration Salaries Overtime Employee Benefits Professional Services Travel, Training and Dues Printing and Advertising Communications Insurance Motor Vehicle Maintenance Miscellaneous Supplies Motor Vehicle Supplies Apparel Repairs and Maintenance Contractual Small Tools and Equipment Cleaning Salaries Overtime Employee Benefits Small Tools and Equipment Contractual Motor Vehicle Maintenance Repairs and Maintenance Equipment Rental Motor Vehicle Supplies Supplies Traffic Marking Salaries Overtime Part -Time Employee Benefits Motor Vehicle Maintenance Repairs and Maintenance Motor Vehicle Supplies Materials Street Signs Contractual Budget $30,540 700 2,400 2,200 800 4,400 3,900 22,240 2,000 2,200 3,000 1,200 1,540 1,500 1,200 $79,820 $11,025 500 1,440 500 3,500 4,000 5,500 500 1,500 1,000 $29,465 $13,350 300 2,520 1,440 1,000 800 500 4,000 6,500 10,000 $40 , 410 Actual $35,882 3,328 4,185 267 988 874 1,644 31,396 3,664 2,909 4,191 1,102 1,321 81 720 613 $93,165 $11,102 1,032 1,152 70 3, 689- 1,775 13,803 1,496 1,629 $35,748 $ 8,913 67 2,391 945 262 1,270 73 4,681 5,353 13,743 $37 ,698 VILLAGE OF DEERFIELD, ILLINOIS STREET AND BRIDGE FUND STATEMENT OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Public Works (Cont.) Pavement Patching Salaries Overtime Employee Benefits Motor Vehicle Maintenance Repairs and Maintenance Supplies Motor Vehicle Supplies Aggregates Materials Tarring Cracks Salaries Overtime Part -Time Employee Benefits Motor Vehicle Maintenance Repairs and Maintenance Motor Vehicle Supplies Aggregates Materials Equipment Rental Drainage Structures Salaries Overtime Employee Benefits Motor Vehicle Maintenance Repairs and Maintenance Motor Vehicle Supplies Aggregates Materials Street Lights and Traffic Signals Salaries Overtime Employee Benefits Budget Actual $30,540 $31,701 1,200 134 3,600 3,278 5,000 5,388 5,500 1,402 600 7 2,000 1,642 30,000 36,258 2,000 1,389 $80,440 $81,199 $16,870 $17,944 500 729 2,520 2,259 2,160 1,537 1,400 1,625 1,200 1,936 3,000 1,632 500 9 15,000 13,045 2,500 2,951 $45,650 $43;66-7 $ 5,500 $ 7,664 400 814 730 774 2,000 1,349 2,300 927 300 76 1,000 370 2,000 3,188 $14,230 $15,162 $ 5,845 $ 9,697 1,000 1,046 720 1,288 49 50 ' VILLAGE OF DEERFIELD, ILLINOIS STREET AND BRIDGE FUND STATEMENT OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Budget Actual ' Public Works Cont.) Street Lights and Traffic Signals Cont.) Contractual $ 27,000 $ 17,559 ' Utility Services 47,780 58,309 Motor Vehicle Maintenance 1,500 2,885 Repairs and Maintenance 1,000 290 Equipment Rental 1,000 ' Motor Vehicle Supplies 800 1,052 Aggregates 300 ' Materials 10,000 $ 96,945 14,757 $106,883 Miscellaneous Maintenance ' Salaries $ 5,845 $ 7,116 Overtime 1,000 1,955 Employee Benefits 720 703 Contractual 53,700 32,388 Motor Vehicle Maintenance 1,000 1,013 Repairs and Maintenance 2,500 2,845 ' Small Tools and Equipment Miscellaneous 300 500 517 742 Motor Vehicle Supplies 600 1,010 Aggregates 1,000 59 ' Materials 2,200 3,475 Equipment Rental 2,000 $ 71,365 $ 51,823 ' Snow and Ice Control Salaries $ 31,750 $ 9,465 Overtime 9,000 12,852 ' Employee Benefits 2,870 1,097 Communications 720 Motor Vehicle Maintenance 6,000 9,841 Repairs and Maintenance 11,000 17,112 ' Equipment Rental 1,000 Supplies 2,500 592 ' Motor Vehicle Supplies Salt 5,300 32,000 2,758 35,552 Aggregates 4,000 3,558 Materials 2,000 1,572 ' Equipment 4,200 3,950 Motor Vehicles 16,000 14,804 $128,340 $113,153 , 51. VILLAGE OF DEERFIELD, ILLINOIS , STREET AND BRIDGE FUND STATEMENT OF EXPENDITURES - BUDGET AND ACTUAL I FOR THE YEAR ENDED APRIL 30, 1986 ' Budget Actual Public Works Cont.) Weed Control Salaries $ 5,500 $ 1,128 ' Overtime 100 15 Part -Time 2,520 1,288 Employee Benefits 720 253 ' Motor Vehicle Maintenance 1,000 643 Repairs and Maintenance 1,500 6,500 Motor Vehicle Supplies 500 551 Materials 2,000 3,214 , Equipment $13,840 $13,592 Leaf Removal Salaries $ 5,845 $ 8,841 Overtime 900 2,168 ' Employee Benefits 720 996 Motor Vehicle Maintenance 1,000 1,484 Repairs and Maintenance 2,500 1,790 ' Motor Vehicle Supplies 300 823 $11,265 $16,102 Tree Removal Salaries $ 5,845 $ 6,295 Overtime 600 285 Part -Time 4,050 3,885 Employee Benefits 720 732 Contractual 9,000 9,649 Motor Vehicle Maintenance 450 933 Repairs and Maintenance 500 647 , Motor Vehicle Supplies 400 112 Materials 2,200 279 Equipment Rental 500 ' $24,265 $22,817 Tree Planting Salaries $ 5,500 $ 2,505 . Overtime 400 125 Employee Benefits 720 622 Contractual 4,200 ' 3,953 Motor Vehicle Maintenance 450 587 Repairs and Maintenance 300 71 Motor Vehicle Supplies 400 334 ' Materials 500 249 $12,470 $ 8,446 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS STREET AND BRIDGE FUND STATEMENT OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30. 1986 Public Works (Cont.) Railroad Station Maintenance Salaries Overtime Part -Time Employee Benefits Repairs and Maintenance Supplies Aggregates Total Expenditures /52 Budget Actual $ 5,845 $ 5,427 900 130 3,600 3,546 720 618 2,400 3,426 1,500 61 7,900 7,900 8,300 1,876 2,420 500 $ 34,085 $ 22,984 $682,590 $662,439 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, 1986 Revenues Property Taxes - Current - (Net) Replacement Taxes Interest Earnings Expenditures Illinois Municipal Retirement Payments - Employer Excess (Deficiency) of Revenues over Expenditures 1986 Budget Actual $300,000 $271,808 6,000 6,047 8,000 8,815 $314,000 $286,670 1985 Actual $233,152 6,230 18,637 $258,019 305,000 296,313 261,325 $ 9,000 $ (9,643) $ (3,306) Fund Balance May 1 (5,415) (2,109) April 30 $05,058) $ (5,415) See accompanying Notes to the Financial Statements. 54 1 1 1 1 1 1 1 1 1 I 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. 1986 1986 Budget Actual Revenues Property Taxes - Current - (Net) Expenditures Contractual Excess (Deficiency) of Revenues over Expenditures Fund Balance May 1 April 30 See accompanying Notes to the Financial Statements. $61,273 $61,273 1985 Actual $10,143 18,945 $(8,802) 70,075 $61,273 55 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, 1986 Revenues Entitlements Interest Expenditures Excess of Revenues over Expenditures before Other Financing (Uses) Other Financing (Uses) Operating Transfer (Out) Debt Service Fund Excess (Deficiency) of Revenues over Expenditures and Other Uses Fund Balance May 1 April 30 1986 1985 Budget Actual Actual $ 74,000 $ 74,176 $ 79,314 12,000 30,636 31,681 $ 86,000 $ 104,812 $ 110,995 $ 86,000 $ 104,812 $ 110,995 (166,000) (165,385) (165,088) $ (80,000) $ (60,573) $ (54,093) See accompanying Notes to the Financial Statements. 172,513 226,606 $ 111,940 $ 172,513 56 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 Revenues Allotments Earned Interest Other Expenditures FOR THE YEAR ENDED APRIL 30, 1986 1986 1985 Budget Actual Actual $290,000 $290,914 $278,503 15,723 16,418 17,834 16,429 $305,723 $307,332 $312,766 Street Maintenance $150,000 Street Resurfacing and Renovation Program 105,000 Reconstruction Wilmot Road - Lake Cook to Deerfield 15,000 Other - Resurfacing Deerfield Road 22,000 $292,000 Excess (Deficiency) of Revenues over Expenditures $ 13,723 Fund Balance May 1 April 30 See accompanying Notes to the Financial Statements. $146,001 $195,776 52,394 81,532 16,183 25,273 $279,927 $237,232 $ 27,405 $ 75,534 228,940 $256,345 153,406 $228,940 VILLAGE OF DEERFIELD, ILLINOIS. STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Revenues Village Contribution Grant Expenditures Transportation Expense Excess (Deficiency) of Revenues over Expenditures before Other Financing Sources Other Financing Sources Operating Transfer In General Fund Excess (Deficiency) of Revenues and Other Sources over Expenditures Fund Balance May 1 April 30 1986 1985 Budget Actual Actual $ 3,668 $ 4,000 4,000 $ 4,000 $ 7,668 - 6,000 8,892 $ 4,662 $(2,000) $0 ,224) $(4,662) See accompanying Notes to the Financial Statements. 2,000 2,000 2,000 $ 776 $(2,662) 3,478 6,140 $ 4,254 $ 3,478 1 1 DEBT SERVICE FUNDS . I Fund Description Debt. Service Fund The Debt Service Fund is used to account for the accumulation of resources for the payment of General Long -Term Debt. 1 i t 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 d VILLAGE OF DEERFIELD, ILLINOIS DEBT SERVICE FUND BALANCE SHEET APRIL 30, 1986 1986 1985 ASSETS Cash and Investments $1,037,488 $ 992,556 Cash with Fiscal Agent 472,917 205,905 Receivables Property Taxes - Current - (Net) 1,049,386 511,529 Accrued Interest 31,160 27,570 Due from Other Funds 34,845 Total Assets $2,625,796 $1,737,560 LIABILITIES AND FUND BALANCES Liabilities Cash Overdraft $ 31,437 Notes Payable $ 5,000 Interest Payable 34,400 39,100 Deferred Property Taxes 1,136,622 542,147 Due to Other Funds 21,592 Total Liabilities $1,202,459 $ 607,839 Fund Balance 1,423,337 1,129,721 Total Liabilities and Fund Balance $2,625,796 $1,737,560 See accompanying Notes to the Financial Statements. 59 VILLAGE OF DEERFIELD, ILLINOIS DEBT SERVICE FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30. 1986 1986 1985 Budget Actual Actual Revenues Taxes Property Taxes - Current - (Net) $ 739,351 $ 556,185 $ 470,506 Replacement Tax 29,000 42,085 43,358 Miscellaneous Interest 45,000 110,686 72,420 Total Revenues $ 813,351 $ 708,956 $ 586,284 Expenditures Sewerage Improvement Bond Series of 1973 Principal $ 75,000 $ 15,000 Interest 25,062 28,550 Sewerage Treatment Facility Bond Series of 1973 Principal 125,000 125,000 Interest 48,436 54,250 Corporate Purpose Bond Series of 1983 Principal 100,000 50,000 Interest 31,75b 35,500 Corporate Purpose Bond Series 1982 Principal 25,000 Interest 46,086, 46,088 Corporate Purpose Bond Series 1982-A Principal 50,000 50,000' Interest 35,750, 39,250. General Obligation Variable Rate Demand Bond Series of 1984 Interest 217,556 54,095, General Obligation Variable Rate Demand Bond Series of 1985 Interest 105,185 Land Acquisition Bond Series of 1974 .- Principal 150,000 Interest 4,275. Police Addition Installment Contract of 1979 Principal 145,000 25,000 . Interest 20,423 21,751 Other - Miscellaneous 2,054 Total Expenditures $1,154,011 $1,050,250 $ 760,8.13 Excess (Deficiency) of Revenues over Expenditures before Other Financing Sources $ (340,660) $ (341,294) $ (174,529) Other Financing Sources Operating Transfers In Capital Improvements Fund $ 276,750 $ 260,000 Federal Revenue Sharing Fund $ 358,160 165,385 165,088 Tax Incremental Finance District Fund 192,775 202,837 $ 358,160 $ 634,910 $ 627,925 Excess of Revenues and Other Sources over Expenditures $ 17,500 $ 293,616 $ 453,396 Fund Balance May 1 $1,129,721 $ 442,736 Prior Period Adjustment 42,669 Adjusted Balance $1,129,721 $ 485,405 Residual Equity Transfers In Sewerage Treatment Facilities Fund 10,081 Storm Sewer Improvements Fund 180,839 $1,129,721 $ 676,325 April 30 $1,423,337 $1,129,721 See accompanying Notes to the Financial Statements. 1 u 1 1 1 CAPITAL PROJECT FUNDS ' Fund Descriptions Capital Projects Funds 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 - Established in 1982 to provide funds for land acquisition and improvements to the Village of Deerfield Tax Increment Financing District. ' Fund for Capital Improvements Series A - Established in December, 1984, to pro- vide funds.for Storm Sewer Improvements, Sanitary Improvements and a Street Rehabilitation Program. Bond Issue B - Established in December, 1985, to provide funds for major renovation to the Storm and Sanitary Sewers and a Street Rehabilitation Program. ' Brickyards Development - 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. 1 60 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 TIli OnD n ��pp pp a0 pn �O ti l PN7 N 00 n f�1 �O N N O N N O p In O ..i ...i N N f0 V F M en In cn O+I O .nr .N+ O N O N n O 41 fA /r Wr-1 N 1p O� eV eT N _ u N M N 10 10 N v a W pmNp N N O N N ep N eb OIL d N N N �O N (? N N N _ f�1 GGG���111 �Iri pNp cl Lr d � aN O p ���0777 6 S CC H G u .7 vM1 � ITO e p c'1 �7 fn N Nr4 K to yy N ~ N N N v N N N N eJ t? V? N Vf v u W N 1� N � ep0 � u O � O 10+ e� .••� eA9 ❑❑ ._. •.4ry�i O ( V,� en 1 1 1 1 1 1 1 1 1 1 1 1 1 1 n nPI 2 .�' � � �' �.7 S r• e fs R Nryp ., Cg � JG ? N O ^ n Np N fD p (D R M N (6 r st v� {U A N A N N N r r r vNi vNi Y. . vNi PP't N �N � N N in in W W W In 1 l.n I In In ryO• �• n ♦b ~ N 4,0 N ems.. ram•+ O N WWp p re) R lJ N yN� F FN W lVn N ppP �O CVO �pOD VNi „• 6l B W. n 'hJM ll77WDD % F lVn W F OC r iA iff iR ^ N N fff M 'rtl� r W W N N N N 'O• I W N r• ` �D ODD N nj N�VO N �vQNi F tOo N M -rl co w rn m rn �n mWp in in 4A La I Wrn O� pprnpp In OVA N OD . _ 8QQ V�n W - a, O N O� OVA l�rD j(�Q W W �V�/J11 V O O v V v N ►' i-•' V� V1 R Nm 1 I T I F v F v F v F F r ^ N V�WWi �_ W N N wpF WpF pjO�p� co w �-• N N �O N v v V N N �-- O 1J� � a Oy 0 r y N •fn W W r N N N Vf {pyppl Go �pF,1 r N pNp� O �QpVO� O ol LnnL. �yD,� �pbpp O V W 8� W N ��Fp-• co N V1 V1 O F l%A �D p, 19 I 1 1 1 1 1 SPECIAL ASSESSMENT FUNDS ' Fund Descriptions Special Assessment Funds. Special Assessments 3-84 - This group of special assessments was issued prior to 1930 for various municipal projects. Special Assessment 111 - This fund set up in 1974 to account for the collec- tion and disbursement of funds for the improvement of portions of Wilmot Road i 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 — This fund set up in 1975 to account for the collec- tion and disbursement of funds for the construction of concrete pavement, curb 1 and gutter, sidewalks and a drainage system where necessary along portions of Gordon Terrace and Kenmore. Special Assessment 113 - 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 - This fund set up in 1978 to account.for the collec- tion and disbursement of funds for the improvement of Kates Road by con- struction of concrete pavement, curb and gutter, storm sewer and other work necessary and incidental to the improvement. 11 11 f 1 1 1 1 1 i 1 1 1 1 1 1 1 1 i 1 1 1 62 N CT 00 CT M • -� g �!1 CT to .M-iO u 000C900�00�/� rn V�1 01% I 00 � 0 Ln -4 N r-I r4 V} V? V> V} o w O H 00 m Cl pO 0^0 O 0o0^ 0o0 I C� O 000 00 ^ O N ONO M N N O Vi V} 1 v N ClON l C � V} V> V> V> V> M o . .--100 I Vi N V>. V} . . FO1 N O O O O -i </ � Vi g o g O Qi Vi N Vi i? Vi 0c0 0000 cn CT 0000 O O 00 n R. � O ONO M N t? V? V} V> y JJ L r-I fA G4 Q o !y y �-4 (A NNN y Q) JJ QQ •� ���y ri-�1 � •.•I Qi zi 42 J7 a O R) rl Cc to 0 n1 � 1J O cd cti u rT Ch m O R rr w N �I �I. 1 £9 o � r rrr ►1 ~ (p .. O l�roD � pP�J. ID M co N C y v O P rt GC ED ED -U" -U" � W VNi %..n ON v -4 In va in -coCD to � w w "V> rD rG ^ gu> 00 as In � v v N W V�i N 00 Ch W -mI /> �-' ;O N 1.-1 I~ r N I- W O R w W co Pig IQ En 1 F, PROPRIETARY FUND TYPES 1 1 1 1 i 1 1 1 ENTERPRISE FUNDS I it 1 11 Fund Descriptions Water Fund The Water Fund accounts 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 The Sewerage Fund is used 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 operation of the Sewage Treatment Plant. Refuse Fund The Refuse Fund accounts for all revenues and expenditures necessary to pro- vide the residents of the Village of Deerfield with refuse service. Commuter Parking Lot Fund The Commuter Parking Lot Fund accounts for all activity necessary to construct, operate, and maintain the commuter parking facilities within the Village. 64 11 1 ASSETS Ourrent Assets Cash and Investments Iece ivables Accounts Property Tams Accrued Interest Other Due fran Other Funds Inventory Restricted Assets Cash and Investments Fixed Assets - I;k!t Total Assets LIABILITIES AND FUND EO= Current Liabilities Accounts Payable Compensated Absences Payable We to Other Rands Other Payables long arm Liabilities Bonds Payable 1btal Liabilities Find Fquity Contributed Capital Retained Earnings VILLAGE OF DMWIELD, ILLINOIS MERPRISE FUNDS COMBINING BALANCE SHEET APRIL 30, 1986 meter Parkigg Water Sewerage Refuse Lot Totals 1986 1985 $ 521,276 $ 656,939 $ 79,869 $118,203 $1,376,287 $ 953,294 248,904 139,730 90,243 478,877 501,478 360,067 360,067 339,674 _ 4,747 713 _5,460 14,656 .. 33,536 33,536 2,587 4,760 41,213 41,213 33,887 $ 844,929 $ 801,416 $530,892 $118,203 $2,295,440 $1,850,336 $ 88,708 $ 116,345 $ 205,053 $ 205,053 $ 486,597 $4,961,721 $478,754 $5,927,072 $6,107,051 $1,420,234 $5,879,482 $530,892 $596,957 $8,427,565 $8,162,440 $ 88,622 $ 54,412 $ 67,578 $ 623 $ 211,235 $ 177,400 15,881 42,178 967 59,026 49,538 917 1,501 3,559 5,977- 32,680 31,413 7,513 500 39,426 5,596 $ 136,833 $ 105,604 $ 71,137 $ 2,090 $ 315,664 $ 265,214 135,000 _ 135,000 175,000 $ 271,833 $ 105,604 $ 71,137 $ 2,090 $ 450,664 $ 440,214 $5,616,761 $626,240 $6,243,001 $6,243,001 Reserved - Restricted Accounts $ 88,708 $ 116,345 $ 205,053 $ 205,053 ihreserved 1,059,693 40,772 $459,755 $ 01,373) 1,528,847 1,274,172 Total Retained Earnings $1,148,401 $ 157,117 $459,755 $$ 3�) $1,733,900 $1,479,225 Total Fled Equity $1,148,401 $5,773,878 $459,755 $594,867 $7,976,901 $7,722,226 Total Liabilties and Rnd Equity $1,420,234 $5,879,482 $530,892 $596,957 $8,427,565 $8,162,440 See accompanying totes to the Financial Statenents. ynL4m OF DEERFIE1D, ILLMIS ENTERPRISE FUNDS OOMBMING SPA.Tr2' M OF REVENUES, EXPENSES, AND CNANC£S IN REfAME D EARNINGS - UNRESERVED Operating Revenues Charges for Services Water Sales Sewer Charges Refuse Billings Slmcharges Miscellaneous Total Operating Revenues Operating Expenses Excluding Depreciation Administration Operations Total Operating Expenses Operating Incone (loss) before Depreciation Depreciation Operating Income (Loss) Noroperating Revenues (Expenses) Interest Earned Property Taxes Interest Expense Net Income Before Other Financing (Uses) Other Financing (Uses) Operating Transfers (Clot) Street and Bridge Fled Net Income and Other Financing Uses Retained Earnings - Unreserved May 1 April 30 See accompanying Notes to the Financial Statements. FOR THE YEAR ENDED APRIL 30, 1986 Commuter Parking Water Sewerage Refuse Lot $1,360,193 $ 880,600 $ 439,028 78,491 60,387 55,128 $ 90,731 $1,420,580 $1,014,219 $ 439,028 $ 90,731 $ 103,619 $ 134,594 $ 13,101 1,099,881 720,123 797,134 $ 25,439 $1,203,500 $ 854,717 $ 810,235 $ 25,439 $ 217,080 $ 159,502 $(371,207) $ 65,292 49,931 202,228 30,698 $ 167,149 $ (42,726) $(371,207) $ 34,594 $ 32,634 $ 50,933 $ 11,517 399,219 (7,438) $ 25,196 $ 50,933 $ 410,736 - $ 192,345 $ 8,207 $ 39,529 $ 34,594 $(20,000) $ 192,345 $ 8,207 $ 39,529 $ 14,594 867,348 32,565 420,226 (45,967) $1,059,693 $ 40,772 $ 459,755 $(31,373) 65 Totals 1986 1985 $1,360,193 $1,231,009 880,600 627,984 439,028 433,645 78,491 94,650 206,246 181,860 $2,964,558 $2,569,148 $ 251,314 $ 227,184 2,642,577 2,329,577 $2,893,891 $2,556,761 $ 70,667 $ 12,387 , 282,857 266,147 $ (212,190) $ (253,760) ' $ 95,084 $ 97,177 399,219 364,382 (7,438) (91000) $ 486,865 $ 452,559 $ 274,675 $ 198,799 $ (20,000) (20,000) $ 254,675 $ 178,799 1,274,172 1,095,373 $1,528,847 $1,274,172 66 rn i M n � 00 d w- 00 n IO m O N � N %DOMO�N n N n N N N N N a% N N .fir MLn .7 d � N � O� C7� O% LnC4 1P1 a a a •Nou�io§I .Mc u1 O N as N N N O 00 N 00 00 w Ln t u'i --� -� M N N N �t �t Oppp ui u1 Ot�• 01 00 M v r- Oo '` V*i U.., cn t\ 00 � u, u1i o rn rn 00 N O �o r., M M �O N �n O Ln f? N G7 t/)• V} Vi % � N Oli00 N O� N O� N �• $4 r-1 L � �a o 1 IWI co 0 E• � �Kl lcmlt O V>t? Z% L rn E9 a�w A v 67 VILLAGE OF DEERFIELD, ILLINOIS WATER FUND BALANCE.SHEET APRIL 30, 1986 i 1986 1985 ASSETS Current Assets Cash and Investments $ 521,276 $ 314,921 Receivables Accounts - Billed 75,209 58,251 - Unbilled 173,695 231,918 Inventory 41,213 33,887 Other 33,536 2,.587 $ 844,929 $ 641,564 Restricted Assets Cash and Investments $ 88,708 $ 88,708 Fixed Assets Cost $1,074,763 $1,026,302 Accumulated Depreciation 588,166 538,234 $ 486,597 $ 488,068 Total Assets I $1,420,234 $1,218,3.40 i LIABILITIES AND FUND EQUITY Current Liabilities I Accounts Payable $ 88,622 $ 59,044 Other Payables 31,413 1,314 Compensated Absences Payable 15,881 24,710 Due to Other Funds 917 2,216 $ 136,833 $ 87,284 Long -Term Liabilities Bonds Payable I 135,000 175,000 Total Liabilities $ 271,833 $ 262,284 Fund Equity Retained Earnings Reserved - Restricted Accounts $ 88,708 $ 88,708 Unreserved 1,059,693 867,348 Total Retained Earnings $1,148,401 $ 956,056 Total Liabilities and Fund Equity $1,420,234 $1,218,340 See accompanying Notes to the Financial Statements. 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, 1986 1 1986 1985 Budget Actual Actual ' Operating Revenues Charges for Services Water Sales $1,080,000 $1,360,193 $1_,231,009 Permits and Fees 20,000 36,868 31,146 Penalties 13,000 18,005 15,714 Miscellaneous 1,000 5,514 32 ' $1,114,000 $1,420,580 $1,277,901 Operating Expenses Excluding Depreciation ' Administration $ 100,430 $ 103,619 $ 108,897 Operations Distribution 1,236,990 958,026 737,818 Maintenance - Mains and Fire Hydrants 120,030 99,138 110,572 Maintenance - Meters 52,380 42,717 46,879 $1,509,830 $1,203,500 $1,004,166 1 Operating Income (Loss) before Depreciation Depreciation Operating Income (Loss) Nonoperating Revenues (Expenses) Interest Earned Interest Expense - Revenue Bonds Net Income (Loss) Retained Earnings - Unreserved May 1 April 30 $ (395,830) $ 217,080 $ 273,735 49,931 39,557 $ (395,830) $ 167,149 $ 234,178 $ 16,000 $ 32,634 $ 28,198 (9,000) (7,438) (9,000) $ 7,000 $ 25,196 $ 19,198 $ (388,830) $ 1929345 $ 253,376 See accompanying Notes to the Financial Statements. 867,348 613,972 $1,059,693 $ 867,348 68 69 VILLAGE OF DEERFIELD, ILLINOIS WATER FUND STATEMENT OF OPERATING EXPENSES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Administration Salaries Employee Benefits Professional Services i Travel, Training and Dues Printing and Advertising Communications Contractual Insurance Motor Vehicle Maintenance Miscellaneous Supplies Motor Vehicle Supplies Ij Occupancy ` Apparel Bond Principal Repairs and Maintenance Less Bond Principal Payments Operations Distribution Salaries Overtime Part -Time Employee Benefits Professional Services Printing and Advertising Contractual Services Utility Serices Motor Vehicle Maintenance j Repairs and Maintenance Miscellaneous Purchase of Water Supplies Motor Vehicle Supplies Chlorine Materials Equipment Less Amount' Capitalized i i - i Budget Actual $ 47,400 $ 48,588 3,900 5,467 2,200 145 300 376 700 5,630 6,309 500 147 22,970 23,606 1,200 1,491 300 2,155 500 754 600 1,207 12,000 12,000 1,430 1,374 35,000 40,000 800 $ 135,430 $143,619 35,000 40,000 $ 100,430 $103,619 $ 26,550 $ 26,440 1,050 3,912 308 2,870 2,777 1,300 405 1,050 9,100 8,846 76,870 61,491 1,200 3,341 3,000 3,705 1,300 1,416 1,110,000 841,064 500 1,457 600 1,188 400 427 1,200 1,249 1,500 1,576 $1,238,490 $959,602 1,500 1,576 $1,236,990 $958,026 ' 70 ' VILLAGE OF DEERFIELD, ILLINOIS WATER FUND ' STATEMENT OF OPERATING EXPENSES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 ' Budget Actual ' Main and Fire Hydrant Maintenance Salaries $ 34,500 $ 19,318 Overtime 10,980 5,438 Part -Time 17,910 13,087 Employee Benefits 4,350 2,077 Communications 390 Contractual Services 8.,400 19,370 Motor Vehicle Maintenance 3,000 3,174' Repairs and Maintenance 10,500 3,527 Equipment Rental 1,000 Miscellaneous 400 970 Motor Vehicle Supplies 1,800 2,318 Small Tools and Equipment 300 304 Aggregates 6,000 7,143 Materials 20,500 22,412 Equipment 900 1,000 Motor Vehicles 15,000 14,084 $ 135,930 $ 114', 222 Less Amount Capitalized 15,900 15,084 $ 120,030 $ 99,138 Meter Maintenance Salaries $ 33, 700 $ 30,104 Overtime 730 6 Part -Time 900 746 Employee Benefits 4,300 3,767 Professional 1,500 770 Travel, Training and Dues 300 71 Printing and Advertising 1,000 76 Communications 250 Contractual 1,500 1,216 Motor Vehicle Maintenance 2,000 2,209 Repairs and Maintenance 1,400 Miscellaneous 300 152 Supplies 300 250 ' Motor Vehicle Supplies 900 199 Materials 3,000 2,897 Small Tools and Equipment 300 254 Equipment 16,500 26,'037 Motor Vehicles 16,000 14,028 $ 84,880 $ 82,782 Less Amount Capitalized 32,500 40,065 $ 52,380 $ 42,717 ' Total Expenses $1,509,830 $1,203,500 71 VILLAGE OF DEERFIELD, ILLINOIS WATER FUND STATEMENT OF FIXED ASSETS AND DEPRECIATION FOR THE YEAR ENDED APRIL 30, 1986 Assets Balances Balances May 1, 1985 Additions Deletions April 30, 1986 Water System $ 785,215 $ 785,215 Equipment and Automotive 241,087 $56,725 $8,264 289,548 $1,026,302 $56,725 $8,264 $1,074,763 Accumulated Depreciation Balances Balances May 1, 1985 Provisions Deletions April 30, 1986 Water System $445,288 $19,630 $464,918 Equipment and Automotive 92,946 30,302 123,248 $538,234 $49,932 - $588,166 Net Asset Value $486,597 72 1 1 1 1 1 1 1 i 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS SEWERAGE FUND BALANCE SHEET APRIL 30, 1986 ASSETS Current Assets Cash and Investments Receivables Accounts - Billed - Unbilled Accrued Interest Restricted Assets Cash and Investments Fixed Assets Cost Accumulated Depreciation Total Assets LIABILITIES AND FUND EQUITY Current Liabilities Accounts Payable Other Payables Compensated Absences Payable Due to Other Funds 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. 1986 1985 $ 656,939 $ 503,844 24,569 29,622 115,161 92,532 4,747 2,696 $ 801,416 $ 628,694 $ 116,345 $ 116,345 $6,161,562 $6,107,144 1,199,841 997,613 $4,961,721 $5,109,531 $5,879,482 $5,854,570 $ 54,412 $ 49,782 7,513 3,969 42,178 24,828 1,501 10,320 $ 105,604 $ 88,899 $5,616,761 $5,616,761 $ 116,345 40,772 $ 157,117 $5,773,878 $5,879,482 $ 116,345 32,565 $ 148,910 $5,765,671 fir, Ar'A r,7n VILLAGE OF DEERFIELD, ILLINOIS STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - UNRESERVED - BUDGET AND -ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 1986 1985 Budget Actual Actual Operating Revenues Charges for Services Sewer Charges $810,000 $ 880,600 $ 627,984 Permits and Fees 20,000 40,670 59,110 Penalties 8,000 10,673 8,714 Construction Surcharges 43,424 43,260 Sara Lee Surcharges 45,000 35,067 51,390 Miscellaneous 1,000 545 Other 500 3,785 4,000 $884,500 $1,014,219 $ 795,003 Operating Expenses Excluding Depreciation Administration $107,150 $ 134,594 $ 105,275 Operations Treatment Plant 569,250 490,298 434,439 Cleaning and Maintenance 107,690 106,053 113,026 Construction Department 124,890 123,772 97,002 $908,980 $ 854,717 $ 749,742 Operating Income (Loss) before Depreciation $(24,480) $ 159,502 $ 45,261 Depreciation - 202,228 195,892 Operating Income (Loss) $(24,480) $ (42,726) $0 50,631) Nonoperating Revenues Interest Earned 45,000 50,933 52,285 Net Income (Loss) $ 20,520 $ 8,207 $ (98,346) Other Changes in Retained Earnings - Unreserved Intrafund Transfers In Retained Earnings - Reserved - Restricted Accounts $ 64,000 - - Net Increase (Decrease) in Retained Earnings - Unreserved $ 84,520 $ 8,207 $ (98,346) Retained Earnings - Unreserved May 1 32,565 130,911 April 30 $ 40,772 $ 32,565 See accompanying Notes to the Financial Statements. 74 ' VILLAGE OF DEERFIELD, ILLINOIS SEWERAGE FUND STATEMENT OF OPERATING EXPENSES - FOR THE YEAR ENDED APRIL BUDGET AND ACTUAL 30, 1986 Budget Actual ' Administration Salaries $ 47,400 $ 56,580 Overtime 200 61 Employee Benefits 3,900 5,667 ' Professional Services 2,200 Travel, Training and Dues 200 308 ' Printing and Advertising Communications 100 1,580 2,673 Insurance 32,990 52,618 Motor Vehicle Maintenance 900 _ Repairs and Maintenance 1,300 ' Miscellaneous, 700 1,458 Supplies 400 764 Motor Vehicle Supplies 650 880 ' Occupancy 12,000 12,000 Apparel 1,430 890 Contractual 1,200 695 $107,150 $134,594 Operations Treatment Plant Salaries $190,810 $175,817 ' Overtime 5,200 7,659 Part -Time 4,050 4,037 Employee Benefits 21,600 17,515 Professional Services 8,500 Travel, Training and Dues 900 371 Printing and Advertising 1,000 6 Communications 3,300 2,745 Contractual Services 34,500 36,211 Utility Services 174,900 165,032 Motor Vehicle Maintenance 3,000 1,601 ' Repairs and Maintenance. 28,000 39,839 Equipment Rental 1,000 1,210 Supplies 6,000 10,219 ' Motor Vehicle Supplies 1,000 6,878 Chlorine 5,000 930 Aggregates 2,500 6,022 ' Materials 4,000 10,498 Street Signs 300 Small Tools and Equipment 500 952 Apparel 1,690 1,236 ' Miscellaneous 3,000 1,514 Equipment 3,000 3,186 Improvements - Not Buildings 64,000 22,512 ' Depreciation 68,500 202,228 $636,250 $718,224 Less Amount Capitalized 67,000 227,926 $569,250 $490,2.98 75 , VILLAGE OF DEERFIELD, ILLINOIS , SEWERAGE FUND STATEMENT OF OPERATING EXPENSES - BUDGET AND ACTUAL ' FOR THE YEAR ENDED APRIL 30, 1986 Budget Actual ' Operations (Cont.) Cleaning and Maintenance Salaries $ 45,530 $ 61,300 ' Overtime 4,200 3,071 Part -Time 2,340 2,304 Employee Benefits 5,720 6,123 Contractual Services 10,000 6,088 Motor Vehicle Maintenance 4,000 3,246 Repairs and Maintenance 5,000 1,079 , Equipment Rental 3,000 Miscellaneous 2,000 413 Supplies 16,100 5,192 ' Motor Vehicle Supplies 1,500 1,736 Aggregates 1,000 334 Materials 7,000 14,700 Equipment 3,000 ' Small Tools and Equipment 300 467 $110,690 $106,053 Less Amount Capitalized 3,000 - , $107,690 $106,053 Construction Salaries $ 70,890 $ 77,324 ' Overtime 2,000 1,175 Part -Time 1,170 1,245 Employee Benefits 8,630 7,791 ' Contractual Services 5,000 11,685 Motor Vehicle Maintenance 5,500 4,125 Repairs and Maintenance 7,500 1,076 Equipment Rental 1,000 ' Supplies 2,000 Motor Vehicle Supplies 2,000 2,383 Aggregates 5,000 5,511 ' Materials 14,000 11,359 Small Tools and Equipment 200 98 Motor Vehicles 16,000 14,804 ' $140,890 $138,576 Less Amount Capitalized 16,000 14,804 $124,890 $123,772 Total Expenses $908,980 $854,717 1 1 1 1 1 1 1 76 VILLAGE OF DEERFIELD, ILLINOIS SEWERAGE FUND STATEMENT OF FIXED ASSETS AND DEPRECIATION FOR THE YEAR ENDED APRIL 30, 1986 Sewer System and Plant Equipment and Automotive Sewer System and Plant Equipment and Automotive Net Asset Value Assets Balances Balances May 1, 1985 Additions Deletions April 30, 1986 $5,917,062 $ 36,435 $5,953,497 190,082 17,983 208,065 $6,107,144 $ 54,418 - $6,161,562 Accumulated Depreciation Balances Balances May 1, 1985 Provisions Deletions April 30, 1986 $ 930,615 66,998 c 007 All $172,064 30,164 $202,228 $1,102,679 97,162 $1,199,841 $4.,961,721 77 VILLAGE OF DEERFIELD, ILLINOIS BALANCE SHEET ASSETS Current Assets Cash and Investments Receivables Accounts - Billed - Unbilled Property Taxes - Current - (Net) Accrued Interest Due from Other Funds .Total Assets LIABILITIES AND FUND EQUITY Current Liabilities Account Payable Due to Other Funds Total Liabilities Fund Equity Retained Earnings Total Liabilities and Fund Equity See accompanying Notes to the Financial Statements. 1986 1985 $ 79,869 $ 39,860 19,445 19,743 70,798 69,412 360,067 339,674 713 11,960 4,760 $530,892 $485,409 $ 67,578 $ 65,039 3,559 144 $ 71,137 $ 65,183 459,755 420,226 $530,892 $485,409 78 VILLAGE OF DEERFIELD, ILLINOIS STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Operating Revenues Charges for Services Refuse Billing Operating Expenses Administration Intergovernmental Billing Other Operations Contractual Services Operating Income (Loss) Nonoperating Revenues (Expenses) Interest Earned Property Taxes - Current - (Net) Property Taxes - Prior Net Income Retained Earnings May 1 April 30 1986 1985 Budget Actual Actual $ 432,000 $ 439,028 $ 433,645 $ 12,000 $ 12,000 $ 12,000 3,000 1,101 1,012 815,000 797,134 765,376 $ 830,000 $ 810,235 $ 778,388 $(398,000) $(371,207) $(344,743) $ 9,000 $ 11,517 $ 16,694 390,000 390,000 3.60,000 9,219 4,382 $ 399,000 $ 410,736 $ 381,076 $ 1,000 $ 39,529 $ 36,333 See accompanying Notes to the Financial Statements. 420,226 383,893 $ 459,755 $ 420,226 VILLAGE OF DEERFIELD, ILLINOIS COMMUTER PARKING LOT FUND BALANCE SHEET ASSETS Current Assets Cash and Investments Fixed Assets Cost Accumulated Depreciation Total Assets LIABILITIES AND FUND EQUITY Current Liabilities Accounts Payable Other Payables Compensated Absences Payable Due to Other Funds Total Liabilities Fund Equity Contributed. Capital. Retained Earnings Total Fund Equity Total Liabilities and Fund Equity 1986 1985 $ 118,203 $ 94,669 $ 691,458 $691,458 (212,704) (182,006) $ 478,754 $509,452 $ 596,957 $604,121 See accompanying Notes to the. Financial Statements. $ 623 $ 3,535 500 313 967 20,000 $ 2,090 $ 23,848 $ 626,240 $626,240 (31,373) (45,967) $ 594,867 $580,273 $ 596,957 $604,121 m 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS COMMUTER PARKING LOT FUND STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Operating Revenues Parking Lot Revenue Operating Expenses Excluding Depreciation Operating Income before Depreciation Depreciation Operating Income before Other Financing (Uses) Other Financing (Uses) Operating Transfers (Out) Street and Bridge Fund Net Operating Income (Loss) and Other Financing Uses Retained Earnings May 1 April 30 1986 1985 Budget Actual Actual $ 35,000 $ 90,731 $ 62,599 26,130 25,439 24,465 $ 8,870 $ 65,292 $ 38,134 30,698 30,698 $ 8,870 $ 34;594 $ 7,436 (10,000) (20,000) (20,000) $ (1,130) $ 14,594 $0 2,564) See accompanying Notes to the Financial Statements. (45,967) (33,403) $(31,373) $(45,967) 81 VILLAGE OF DEERFIELD, ILLINOIS COMMUTER PARKING LOT FUND STATEMENT OF OPERATING EXPENSES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Budget Actual Operations Parking Lots - Village and Federal Funds Salaries $ 3,170 $ 4,504 Benefits 700 161 Insurance 140 195 Ut.il ity Services 2,000 2,665 Repairs and Maintenance 1,000 109 Supplies 500 215 Aggregates 500 Equipment 500 89 Property Rentals 7,500 7,440 Materials 800 1,353 $16,810 $16,731 Less Amount Capitalized 500 $16,310 $16,731 Parking Lot - Village Construction Salaries $ 3,380 $ 4,737 Benefits 700 169 Insurance 140 202 Utility Services 2,800 2,169 Repairs and Maintenance 1,000 301 Supplies 500 233 Aggregates 200 Materials 1,000 897 Equipment 100 $ 9,820 $ 8,708 Total Expenses $26,130 $25,439 82 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 STATEMENT OF FIXED ASSETS AND DEPRECIATION FOR THE YEAR ENDED APRIL 30, 198 Assets Balances Balances May 1, 1985 Additions Deletions April 30, 1986 $ 77,500 $ 77,500 613,958 613,958 $691,458 Accumulated Depreciation Balances Balances May 1, 1985 Provisions Deletions April 30, 1985 $182,006 $30,698 $212,704 $182,006 $30,698 - $212,704 $478,754 r � INTERNAL SERVICE FUNDS 1 Fund Description Garage Fund The Garage Fund is used 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. 11 u 83 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS GARAGE FUND BALANCE SHEET APRIL 30, 1986 ASSETS Cash and Investments Due from Other Funds Inventory Total Assets LIABILITIES AND FUND EQUITY Liabilities Cash Overdraft Accounts Payable Compensated Absences Payable Total Liabilities Fund Equity Retained Earnings Total Liabilities and Fund Equity See accompanying Notes to the Financial Statements. 1986 1985 $ 7,282 $10,761 12,518. 29,101 23;144 $39,862 $42,944 $ 7,244 8,957 $ 5,499 7,000 6,217 $23,201 $11,716 16,661 31,228 $39,862 $42,944 VILLAGE OF DEERFIELD, ILLINOIS STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30. 1986 Operating Revenues Charges for Services Billings ' Operating Expenses Operations Net Operating Income (Loss) Retained Earnings May 1 April 30 1986 Budget Actual $148,300 $128,562 131,850 143,129 $ 16,450 $04,567) See accompanying Notes to the Financial Statements. 31,228 $ 16,661 84 1985 Actual $139,699 , 143,731 $ (4,032) 35,260 $ 31,228 1 85 VILLAGE OF DEERFIELD, ILLINOIS GARAGE FUND STATEMENT OF CHANGES IN FINANCIAL POSITION FOR THE YEAR ENDED APRIL 30, 1986 Cash Was Provided By Increase in Current Liabilities Cash Was Used To Increase Current Assets Fund Operating Loss Net Decrease Cash and Investments May 1 April 30 See accompanying Notes to the Financial Statements. Totals 1986 1985 $ 4,241 $ 1,657 $ 4,200 $ 3,312 14,567 4,032 $ 18,767 $ 7,344 $0 4,526) $(5,687) 7,282 12,969 $ (7,244) $ 7,282 86 VILLAGE OF DEERFIELD, ILLINOIS GARAGE FUND STATEMENT OF OPERATING EXPENSES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Operations Public Works Department Salaries Overtime Employee Benefits Apparel Travel, Training and Dues Printing and Advertising Insurance Miscellaneous Professional Services Utility Services Repairs and Maintenance Supplies Motor Vehicle Supplies Equipment Communications Materials Small Tools and Equipment Budget Actual $ 56,900 $ 59,513 5,000 5,811 5,740 6,277 450 334 500 98 350 54 3,090 4,081 200 48 50 1,300 800 5,000 4,095 45,100 54,381 800 445 5,000 4,404 370 801 500 333 1,500 1,654 $131,850 $143,129 1 1 p I FIDUCIARY FUND TYPES ' TRUST AND AGENCY FUNDS Fund Descriptions ' Police Pension Fund The Police Pension Fund is used to account for the resources necessary to provide retirement and disability benefits to personnel of the Village of Deerfield Police Department. ' Deposit Fund The Deposit Fund is used to account for monies on deposit with the Village which are being held on a temporary basis. I. 87 ' �t 00 M V1 r 00 N 00 O. .--i -4 O O• -r C. M r--i �•+ r, .. M .--4 .D -It N O M V1 �t 't 00 n -- M V\ O. O. N r` r` 00 rn •-� t �t M O. •-r �t rn O n 00 O. � ON -4 N N M M M v —4 co .61 E-r 00 .O 00 n 00 M 00 O. 00 coo n N M V1 O. 4 M .O O N O. rn N M cn .-r M M �-+ N i r -i O. V1 L' N r, U _ 00 O% n 00 N .--i N - V1 O r~ 00 -4 -4 n O r- N Cl) V1 n 't It 1-4 V1 00 .0 00 r� 00 M M VY t? Vi t? N N vj- • rr --t r\ "00 r - t` u 0 00 O N O .� m O O ► ' r pp r-i p p 00 N d A � yr yr vs cn 1-a O � z F M .o 00 O. .0 00 00 00 O 00 .o 1--� (A W 00 M V1 00 .o N N V1 N M .O a A W C 0 C C,1 cn cnO O V-, CV r- Ln O a z pC O aJ u 0 F-1 A W • 4 M 4 •rr C N— O 1 N �t fX4 .0 is C —4 cn Cn V1 r� r- w-r `n -' • • r\ .O 00 r- r, A �+ CwJ rn N Ea N a c� z w a C+ M � M M w z C4 yr yr ur yr yr yr yr oncn wA c�a Az zH -< Hx O .CC L W io u W. O a .6J a ca :J W fA —4 cn U C 4 " a `° z �- w 4 b v ► z a2 44 .6J 1J 1� d d y � H co w N V N V1 U V1 A y 0 :J 'd z 'd ..4 r♦ CO • rl 0 cn d o w 1 —4r4 o•r4 F y (u W m •a, 0 OW —4 W o0 � 00 W aJ N w 1J A ca co —4 .+ C CA (1) of a al y ca ca w N y O C cc >> d > EH C ►W n. X 4 al w b 7 ra C 0) N :� y :., a u 0) LXA a cCa F-+ W6J O W N y a, 0 C O ' b a w v 6 ca F :j C ..O co •—r > CU 01 Ca o Lri co Q O w O :J H rr O m 1J }J to w 0 lJ :J u > a. w w O a ra o 0 O as w W o o u .+ O v w E-r H • 4 u 0. a) H rn w F F ra - 0) N 00 A u u O b 01 ' C V) uw o v Rf-IC4AA u a c o av a a w � 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, 1986 Operating Revenues Employer Contributions Property Taxes - Current - (Net) Property Taxes - Prior Replacement Taxes Interest Payroll Deductions Operating Expenses Pension Payments Filing Fee Net Income Fund Balances May 1 April 30 Budget $165,000 4,000 $169,000 340,000 95,000 $604,000 $ 70,000 500 $ 70,500 $533,500 See accompanying Notes to the Financial Statements. 1986 m 1985 Actual Actual $ 165,000 $ 150,000 1 1 1 1 1 3,972 1,230 4,751 4,895 $ 173,723 $ 156,125 361,378 315,417 97,525 75,750 $ 632,626 $ 547,292 $ 67,873 $ 65,912 937 25 $ 68,810 $ 65,937 ' $ 563,816 r $ 481,355 ' 3,208,722 2,727,367 $3,772,538 $3,208',722 ' 1 . 1 89 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS TRUST AND AGENCY FUNDS POLICE PENSION FUND STATEMENT OF CHANGES IN FINANCIAL POSITION FOR THE YEAR ENDED APRIL 30, 1986 Cash Was Provided By Operations Net Income Increase Current Liabilities Cash Was Used To Increase Current Assets Net Increase Cash and Investments May 1 April 30 See accompanying Notes to the Financial Statements. Total 1986 1985 $ 563,816 $ 481,355 1,528 ' $ 565,344 .$ 481,355 14,957 28,490 $ 550,387 $ 452,865 2,968,896 2,516,031 $3,519,283 $2,968,896 90 VILLAGE OF DEERFIELD, ILLINOIS DEPOSIT FUND STATEMENT OF CHANGES IN ASSETS AND LIABILITIES FOR THE YEAR ENDED APRIL 30, 1986 ASSETS Cash and Investments Other Assets Due from Other Funds Total Assets Balances May 1, 1985 $ 6,488 44,491 $50,979 Increase Decrease $61,357 1,214 $62,571 $43,479 $43,479 Balances April 30, 1986 $67,845 1,012 .1,214 $70,071 Deposits Payable $44,311 $24,592 $68,903 Accounts Payable 1,149 19 1,168 Due to Other Funds 5,519 $ 5,519 Total Liabilities $50,979 $24,611 $ 5,519 $70,071 See accompanying Notes to the Financial Statements. 1 ACCOUNT GROUPS 1 GENERAL FIXED ASSETS ACCOUNT GROUP 1 1 GENERAL FIXED ASSETS ACCOUNT GROUP To account for fixed assets not used in proprietary fund operations or accounted for in trust funds. I. 91 1 1 1 '1 1 1 1 1 1 i 1 1 1 i 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FIXED ASSETS ACCOUNT GROUP STATEMENT OF GENERAL FIXED ASSETS APRIL 30, 1986 Land Buildings and Improvements Vehicles Equipment General Revenues General Obligation Bonds Installment Contracts GENERAL FIXED ASSETS INVESTMENT IN GENERAL FIXED ASSETS ti See accompanying Notes to the Financial Statements. $1,915,310 1,237,500 371,100 1,022,710 th v.c c1)n $2,646,620 1,500,000 400,000 $4,546,b20 b pil r- S G p• h'• rf R r p rS M O 03 x O C O R cD a �C n fD R � r• R C w V o w In V r p� O a ►' 4- N O N O 00 N <n H •tiy G W .o ►N O W r C 00, a !p r• El G O o Wn m uo O O O O O w R w to to C W N f9 to � V N ?• W 00 t-n 00 W. n - 00 %D w r N V 4- O fD W N -Z N CO) [sJ m o �c q 00 w %D ON m V W J R H ,n V V O O N� V R r ON w v vi cn N w O V O W r r u G 0 0 07 H a H z H O c� rl z m ri] H cy i a cn i w H cn �I da re c z 0 H h-I O z a z d a n H H C H rC c� r� r tra '=J Cj7 x O t=f sJ Cl C7 a� cn r� cn pa ril H r•� cn [� a d ny o �+ cr z r~ H 0-4 z 00 pa 1•-0 O m C b Z6 93 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FIXED ASSETS ACCOUNT GROUP STATEMENT OF CHANGES IN GENERAL FIXED ASSETS - BY FUNCTION AND ACTIVITY FOR THE YEAR ENDED APRIL 30, 1986 Balances Balance s Function and Activity May 1, 1985 Additions Deletions April 30, 1986 General Government $1,011,973 $ 97,073 $ 36,503 $1,072,543 Public Safety 2,669,367 133,894 85,531 2,717,730 Public Works 833,100 23,747 100,500 756,347 $4,514,440 $254,714 $222,534 $4,546,620 ti 1 E I F, L �I GENERAL LONG TERM DEBT ACCOUNT GROUP General Long -Term Debt ' Account Group To account for the long-term portion of the Village's Bond Issues and Installment Contracts. r 94 1 1 1 1 1 1 1 1 1 i 1 1 1 1 1 1 CN N N Ln co 8� QOBO 8O N (% v, I). O g g co SO ^�+ Mn u In pppp ��pp 8 VT 8 N 8 VV �•C u Cw 6 C O F� VY v Vr VY V~f m co •VJ ~ la oQ oQ 00 � OD C~1 0�0 C •fpA .�-� ep .-1 8v 8� 8v CO 0 O� O� O� O 0p7 � • � �7 •� 0.�-D 1� 04 N O v v , O N ONO In V} N H co $ �T O en `QUO `QUO y V1 ~ a 8 8 8 O O O W O � gQr� g g �•• {7� N .� to gyp^ b O O u ty+ n •C O O F•' W V1 �F Vim? VAT O04 04 u's Ln Lr) ••Va •u H i� .agl m sy�y acc u C7 Q W u C7 O O •--� •O) l0 G m to A 1 SUPPLEMENTARY DATA 1 1 1 1 1 1 1 1 ppp �aoao-"z; c�N NI N m u p} ��pp W N N o0 d .�i C N 011,011 Vim, Q� 00 I 40 OD 'D O, m �O O, en d mm Cn0 f+1 VppT N M N 0, N 1 N u 0� aN0 8 m N C P'1 CO d O n m V1 n ll n O� _O 0, %O O, N ~ u 100 P1 � V} N tlY y � �J ti .N•. S •u O m n JJ111 I�1 � F. p 1+ � 0Id d �i o •1n o.� ME co 00 �t 00 � �D � � d u P'1 cl 00 00 I w N f+1 m 6qF H U v} N v d v1 GI 10 ICI m C O �I V�I II 95 ��y n N n C O, f+1 �T�pp ,O .2 00 �O N 00 P1 %D0 N cn 00 O O C7, n 00 'O V1 0 p. cn 1 N N (A�?p M ON N N 0 c0 N f0+1 Vni " O O, A w o0 t+1 n 00 n M 00 " 00 m n O� n Qnp 'o �Np — IO .r O, wr C 1+1 O N N V} N t? N (A f? ��ppc°3 n ennc� v, cn O N N � 00 .mow N1 O, 00 Q NNN pN n N 00 en N i? pppp N ,8 s N _ co V1 M 'O P to N N co O C,4 ti r 4f N N N (/Y 1'�1 N Vryyl u 'l$ u m m y e tQ3' m C� �yY �m O •O y OS•�•°� 4Jc�". u Y E �II 8 H N �O O _ n O n u -�l -!l Q> m Z•9 ( t?I 7.�W 7 O N e �II y A m u O O SN ro III Vs mm ro u 7C3 �y m m C d C 9 ; 96 Fund General Fund Money Market Deerfield State Bank U.S. Treasury Bills VILLAGE OF DEERFIELD, ILLINOIS COMBINED STATEMENT OF INVESTMENTS APRIL 30, 1986 Interest Maturity Rate Date National Bank of North America 7.760 National Westminster Bank 9.150 5.915 7.210 Certificate of Deposit Cragin Federal Savings and Loan 7.275 Deerfield State Bank 8.125 7.600 8.400 Deerfield Federal Savings and Loan 7.500 Northern Trust Company 6.300 Total General Special Revenue Library Savings Account First National Bank of Deerfield Certificate of Deposit First National Bank of Deerfield 6.000 6.750 Street Money Market Deerfield State Bank Certificate of Deposit First National Bank of Deerfield Federal Revenue Sharing Money Market Deerfield State Bank U.S. Treasury Bills National Westminster Bank 2/15/87 5/15/86 10/09/86 7/24/86 6/ 19/86 3/18/87 7/26/86 7/29/86 10/27/86 10/10/86 6/26/86 5/10/86 7.500 10/27/86 5.915 10/09/86 9.150 5/15/86 $310,107 905,580 170,688 241,068 207,487 165,000 210,000 200,000 300,000 125,000 122,000 $ 18,109 100,000 175,000 $138,836 125,000 $ 79,138 60,267 150,000 $2,956,930 $ 293,109 263,836 97 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS COMBINED STATEMENT OF INVESTMENTS APRIL 30, 1986 Fund Special Revenue (Cont.) Federal Revenue Sharing (Cont.) Certificate of Deposit Deerfield State Bank Motor Fuel Tax Certificate of Deposit Northern Trust Company IMRF U.S. Treasury Bills. National Westminster Bank Total Special Revenue Debt Service U.S. Treasury Bill National Westminster Bank U.S. Treasury Note Certificate of Deposit First National Bank of Chicago LaSalle National Bank Citicorp Savings and Loan Total Debt Service Capital Projects Capital Improvements Money Market Continental U.S. Treasury Bill National Westminster Bank Certificate of Deposit Continental Capital Projects Money Market Continental Interest Maturity Rate Date 7.600 7/26/86 $ 100,000 $ 389,405 6.800 5/27/86 $ 105,000 6.350 6/27/86 105,000 210,000 7.160 8/15/86 87,428 $1,347,487 7.160 8/15/86 $ 174,856 6.920 5/01/86 211,304 8.580 10/31/87 251,328 7.550 6/18/86 200,000 6.500 5/01/86. 274,788 6.500 5/01/86 198,129 8.500 10/31/86 200,000 $1,510,405 $ 262,688 7.300 7/24/86 1,084,960 6.400 5/06/86 400,000 $1,747,648 101,692 98 VILLAGE OF DEERFIELD, ILLINOIS COMBINED STATEMENT OF INVESTMENTS APRIL 30, 1986 Fund Capital Projects (Cont.) Bond Issue B Money Market Continental U.S. Treasury Bills National Westminster Bank Certificate of Deposit Continental Deerfield Federal Savings and Loan Tax Incremental Finance District Certificate of Deposit Deerfield Federal Savings and Loan Cragin Federal Savings and Loan Citicorp Savings and Loan Deerfield State Bank Total Capital Projects Enterprise Water Money Market Deerfield State Bank Certificate of Deposit Deerfield State Bank Interest Maturity Rate Date 7.585 6.875 8.050 7.375 8.625 8.625 7.750 7.175 7.175 8.500 8.200 7.125 7.650 6.750 $ 161,754 12/26/86 1,000,581 5/07/86 300,000 10/02/86 2,000,000 7/07/86 1,000,000 1/06/88 1,000,000 1/06/87 1,000,000 $6,462,335 10/30/86 $ 200,000 10/27/86 200,000 11/10/86 250,000 10/30/86 300,000 3/23/87 400,000 1,350,000 $ 98,433 10/14/86 175,000 9/09/86 100,000 6/27/86 200,000 $9,661;675 $ 573,433 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS COMBINED STATEMENT OF INVESTMENTS APRIL 30, 1986 Interest Maturity Fund Rate Date Enterprise Sewerage Money Market Deerfield State Bank $.55,306 Certificate of Deposit Cragin Federal Savings and Loan 7.175 10/27/86 125,000 Deerfield State Bank 6.375 7/22/86 150,000 7.125 10/27/86 175,000 Deerfield Federal Savings and Loan 8.125 7/21/86 200,000 Refuse U.S. Treasury Bill National Westminster Bank 7.160 8/15/86 Total Enterprise Trust and Agency Police Pension Savings Account Deerfield Savings and Loan $ 5,000 U.S. Treasury Notes Deerfield State Bank 8.250 5/15/88 89,866 15.375 10/15/88 119,313 8.750 11/15/88 99,062 9.250 5/15/89 51,704 U.S. Treasury Bonds Deerfield State Bank 8.250 5/15/90 76,535 8.250 5/15/90 59,698 6.750 2/15/93 34,759 7.500 8/15/93 30,173 7.500 8/15/93 81,584 12.625 8/15/93 142,350 12.625 5/15/95 84,138 12.625 5/15/95 121,575 11.500 11/15/95 112,287 8.500 5/94/99 57,758 $ 705,306 87,428 $1,366,167 99 100 VILLAGE OF DEERFIELD, ILLINOIS COMBINED STATEMENT OF INVESTMENTS APRIL 30, 1986 Fund Trust and Agency (Cont.) Police Pension (Cont.) U.S. Treasury Bonds (Cont.) Deerfield State Bank (Cont.) Continental Bank Stripped Coupons Continental Bank Interest Maturity Rate Date 8.500 5/94/99 66,996 8.500 5/94/99 58,119 8.375 8/15/00 59,931 13.375 8/15/01 95,000 13.375 9/15/01 96,033 14.000 11/15 - 11/06 110,000 14.000 11/15 - 11/06 105,187 11.750 2/15/10 103,875 13.875 5/15/11 153,187 11.875 11/15/03 144,987 12.000 8/15/13 142,828 12.550 2/15/96 121,415 11.700 8/15/01 140,181 12.450 11/15/03 199,266 12.250 11/15/04 28,044 12.300 5/15/05 106,399 11.720 2/15/96 111,639 9.750 11/15/03 157,294 Certificate of Deposit Cragin Federal Savings and Loan 8.250 Deposit Money Market Deerfield State Bank Total Trust and Agency Total All Funds 7/21/86 250,000 $ 3,416,183 23,077 $ 3,439,260 101 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 SEWERAGE IMPROVEMENT BOND SERIES OF 1973 APRIL 30, 1986 Date of Issue Date of Maturity Authorized Issue Actual Issue Denomination of Bonds Interest Rate Principal Maturity Date Interest Dates Payable at June 1, 1973 December 1, 1992 $1,080,000 $1,080,000 $5,000 4.4y-5.1% December 1 June 1 and December 1 Belleville National Savings Bank PRINCIPAL AND INTEREST REQUIREMENTS Tax Bond Levy Numbers Year Principal Interest Total 107-121 1984 $11,650 $ 11,650 122-136 1985 $ 75,000 21,538 96,538 137-151 1986 75,000 17,975 92,975 152-166 1987 75,000 14,337 89,337 167-181 1988 75,000 10,625 85,625 182-196 1989 75,000 6,875 81,875 197-206 1990 50,000 3,750 53,750 207-216 1991 50,000 1,250 51,250 $475,000 $88,000 $563,000 Coupons Due on Dec. 1 Amount June 1 Amount 1985 1986 $11,650 1986 $11,650 1987 9,888 1987 9,888 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 $44,000 $44,000 102 ' VILLAGE OF DEERFIELD, ILLINOIS LONG-TERM DEBT REQUIREMENTS SEWERAGE TREATMENT FACILITIES BOND SERIES OF 1973 APRIL 30, 1986 Date of Issue Date of Maturity Authorized Issue Actual Issue Denomination of Bonds Interest Rate Principal Maturity Date Interest Dates Payable at 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 Tax Bond Levy Numbers Year Principal Interest Total 191-215 1984 $ 22,750 $ 22,750 216-240 1985 $ 125,000 42,563 167,563 241-265 1986 125,000 36,625 161,625 266-296 1987 125,000 30,562 155,562 297-315 1988 125,000 24,375 149,375 316-340 1989 125,000 18,125 143,125 341-370 1990 150,000 11,250 161,250 371-400 1991. 150,000 3,750 153,750 Coupons Due on Dec. 1 Amount June 1 Amount 1985 1986 $ 22,750 1986 $ 22,750 1987 19,813 1987 19,813 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 $ 925,000 $190,000 $1,115,000 $ 95,000 $ 95,000 1 I 103 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 i VILLAGE OF DEERFIELD, ILLINOIS LONG-TERM DEBT REQUIREMENTS CORPORATE PURPOSE BOND SERIES OF 1983 APRIL 30, 1986 Date of Issue December 1, 1983 Date of Maturity December 1, 1988 Authorized Issue $500,000 Actual Issue $500,000 Denomination of Bonds $ 5,000 Interest Rate 8.5% Principal Payment Date December 1 Interest Dates June 1 and December 1 Payable at American National Bank & Trust PRINCIPAL AND INTEREST REQUIREMENTS Tax Bond Levy Numbers Year Principal 31- 50 1985 $100,000 51- 75 1986 125,000 76-100 1987 125,000 $350,000 Interest Total $24,250 $124,250 17,750 142,750 9,000 134,000 $51,000 $401,000 Coupons Due on June 1 Amount Dec. 1 Amount 1986 $12,125 1986 $12,125 1987 8,875 1987 8,875 1988 4,500 1988 4,500 $25,500 $25,500 104 VILLAGE OF_DEERFIELD, ILLINOIS LONG-TERM DEBT REQUIREMENTS CORPORATE PURPOSE BOND SERIES OF 1982 APRIL 30, 1986 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 10.25% - 9.60% Principal Payment Date December 1 Interest Dates June 1 and December 1 Payable at The Northern Trust Company PRINCIPAL AND INTEREST REQUIREMENTS Tax Levy Coupons Due on Year Principal Interest Total June 1 Amount Dec. 1 Amount 1985 $ 25,000 $ 43,525 $ 68,525 1986 $ 21,763 1986 $ 21,762 1986 25,000 40,962 65,962 1987 20,481 1987 20,481 1987 50,000 38,400 88,400 1988 19,200 1988 19,200 1988 50,000 34,275 84,275 1989 17,138 1989 17,137 1989 50,000 30,025 80,025 1990 15,013 1990 15,012 1990 50,000 25,650 75,650 1991 12,825 1991 12,825 1991 75,000 21,150 96,150 1992 10,575 1992 10,575 1992 75,000 14,250 89,250 1993 7,125 1993 7,125 1993 75,000 7,200 82,200 1994 3,600 1994 3,600 $475,000 $255,437 $730,437 $127,720 $127,717 105 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 - A APRIL 30, 1986 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 Levy Coupons Due on Year Principal Interest Total June 1 Amount Dec. 1 Amount 1985 $ 50,000 $ 32,250 $ 82,250 1986 $ 16,125 1986 $ 16,125 1986 50,000 28,750 78,750 1987 14,375 1987 14,375 1987 50,000 24,750 74,750 1988 12,375 1988 12,375 1988 50,000 20,750 70,750 1989 10,375 1989 10,375 1989 50,000 16,750 66,750 1990 8,375 1990 8,375 1990 50,000 12,750 62,750 1991 6,375 1991 6,375 1991 50,000 8,500 58,500 1992 4,250 1992 4,250 1992 50,000 4,250 54,250 1993 2$125 1993 2 X5 $400,000 $148,750 $548,750 $ 74,375 $ 74,375 106 Date of Issue Authorized Issue Actual Issue Denomination Interest Rate Payable at Fiscal Year Ended April 30 1987 Fiscal Year Ended April 30 1987 VILLAGE OF DEERFIELD, ILLINOIS LONG—TERM DEBT REQUIREMENTS GENERAL OBLIGATION VARIABLE RATE DEMAND BONDS APRIL 30, 1986 December 17, 1984 $4,100,000 $4,100,000 $ 100,000 Variable LaSalle National Bank SERIES OF 1984 PRINCIPAL AND INTEREST REQUIREMENTS December 30, 1985 $6,900,000 $6,900,000 $ 100,000 Variable LaSalle National Bank Available For Principal Interest Total $4,100,000 $24,000 $4,140,000 SERIES OF 1985 PRINCIPAL AND INTEREST REQUIREMENTS Principal cA onn nnn Available For Interest $40,873 Total $6,969,000 The $4,100,000 and $6,900,000 Variable Rate Demand Bond Issues were called on May 15, 1986. 107 VILLAGE OF DEERFIELD, ILLINOIS LONG-TERM DEBT REQUIREMENTS POLICE ADDITION INSTALLMENT CONTRACT OF 1979 APRIL 30, 1986 Date of Issue October 16, 1979 Date of Maturity October 15, 1986 Actual Issue $400,000 Payable to Northern Trust Company PRINCIPAL AND INTEREST REQUIREMENTS Tax Levy Year Principal Interest Total 1985 $155,000 $10,385 $165,385 108 VILLAGE OF DEERFIELD, ILLINOIS LONG-TERM DEBT REQUIREMENTS WATER REVENUE BOND SERIES OF 1960 APRIL 30, 1986 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.75% - 4.25% 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 Total Nov. 1 Amount May 1 Amount 1987 96-105 $10,000 $1,275 $11,275 1986 $ 637 1987 $ 638 1988 106-115 10,000 850 10,850 1987 425 1988 425 1989 116-125 10,000 425 10,425 1988 212 1989 213 $30,000 $2,550 $32,550 $1,274 $1,276 1 1 1 1 1 1 I 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, 1986 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 5% - 4.25% Interest Dates November 1 - May 1 Principal Maturity Date May 1 Payable at LaSalle National Bank Chicago PRINCIPAL AND INTEREST REQUIREMENTS Year Bond Ended Numbers Principal Interest 1987 441-475 $ 351000 $ 4,462 1988 476-510 35,000 2,976 1989 511-545 35,000 1,488 $105,000 $ 8,926 109 Coupons Due on Total Nov. 1 Amount May 1 Amount $ 39,462 1986 $2,231 1987 $2,231 37,976 1987 1,488 1988 1,488 36,488 1988 744 1989 744 $113,926 $4,463 $4,463 110 i� VILLAGE OF DEERFIELD, ILLINOIS POLICE PENSION FUND STATEMENT OF OFFICERS' DEPOSITS APRIL 30, 1986 Balance Balance April 30, 1985 Deposits Withdrawals April 30, 1986 1050 Kenneth Anderson $ 21,225 $ 3,079.41 $ 24,304.41 1075 Leo Anderson 20,557 3,443.90 24,000.90 1078 Mark Anfenson 5,164 2,524.34 7,688.34 1125 Marcea Ross 16,019 2,653.07 18,672.07 1325 Richard Brandt 32,675 4:656.77 37,331.77 1350 William Butler 28,786 2,653.07 31,439.07 1355 Louis Cacciatore 2,000 2,081.26 4,081.26 1400 Robert Charles 32,545 32,545.00 1550 Gordon Cooper 26,387 26,387.00 1600 Robert Davenport, Jr. 35,447 3,820.54 39,267.54 1700 David P. Ebert 24,853 2,653.07 27,506.07 1750 John Elofson 22,400 2,653.07 25,053.07 1800 William Ennis 16,804 2,667.78 19,471.78 1925 Marie Rose Gawne 14,144 2,653.07 16,797.07 2000 Robert Hamilton 32,443 3,234.32 35,677.32 2100 Thomas Hill 28,583 3,295.92 31,878.92 2125 George Hoffman 24,251 29653.07 26,904.07 2163 Hilary Jenkins 2250 Larry Kick 28,691 21*653.07 31,344.07 2365 Dave Lemmer 2,386 2,224.39 4,610.39 2430 Eric Lundahl 9,200 2,653.07 11,853.07 2525 Jeffrey McDermott 31,630 3:312.62 34,942.62. 2715 Robert Ogden 7,755 22653.07 10,408.07 2773 Drew R. Pranke 2893 Rand J. Roel. 4,757 2,270.18 7,027.18 2985 Michael E. Scarry_ 48 1,879.37 1,927.37 3025 John Sebben 21,368 2,653.07 24,021.07 3075 Thomas Sheahan 18,204 2:653.07 20,857.07 3125 Thomas Skrabala 25,963 32830.54 29,793.54 3150 John Sliozis 16,561 3,14 8.32 19,709.32 3225 Michael Soler 19,593 2,653.07 22,246.07 3235 Melvin Soltwisch 579 1:936.55 2,515.55 3325 Gary Stryker 27,586 32141.92 30,727.92 3500 Larry Tousignant 32,044 3,378.38 35,422.38 3525 David Turnbaugh 27,975 3,295.92 31,270.92 3650 Glenn E. Webb 14,569 2,289.35 16,858.35 3675 Richard Weil 8,709 2,653.07 11,362.07 380A George Hall 9,604 9,604.00 380B David J. Petersen 7,287 7,287.00 380C Thomas G. Rogge 9,411 9,411.00 133S Kurt Bruno 1,701.90 1,701.90 3260 Daniel J. Moylan 1,137.11 $1,137.11 $708,203 $96,840.70 $1,137.11 $803,906.59 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS STATEMENT OF INSURANCE IN FORCE APRIL 30, 1986 Insureds Description of Coverage Village of Deerfield Workmens Compensation Village of Deefield Comprehensive Automobile Liability Bodily Injury and Property Village of Deerfield General Liability Village of Deerfield Blanket Building and Contents Village of Deerfield Boiler and Machinery Public Officials Blanket Bond Coverage ill Statutory/ $10,000,000 $1,000,000 $1,000,000 $30,000,000 $10,000 $10,000/ $1,000,000 Statistical Section 112 o m o LM ._| p r R %D $ C14 q rl E r o � %0 00 3 $ 7 a� 2 2 0 -4 O - 2 . @ C 2 r 7 $ q cn g 0104 ON| K $ 7 a, al$ q / - <rj-. <rj- £) \ r 8 / %D CO) f oll p 2 / � \ cn L^ o 2ON Cf) � C - v)- cn �| 00 / 00 00 R � k_ / 2 k $ Ln ® � � g - - G C c - $ - # �| E 2 k J cl $ � � m 3 2| 3 cn I Ln J CD 2 � q r r al - � � $ q \ / / � cn � / & q � # 2 cli $ « g V ® � � 9 % m � q $ q E 1-4 2 k r r 3 C <rj- <ri- . $| 3 .� cn $ r 00 g ƒ 00 q / 8 n � c M 3 q � � G & C � 7 ® <rj- <f)- � \ � / \ � � / | $ 10 ON # 00 cn � p r S r- � 7 3 / ■ ° u f -- . w g u 2 � \ / % k k / R � . rr \ / / M. . \ t ) . , . / § � 2 � ■ \ \ / \ ƒ ° » cn 2 - 0 00 Un |\ / q \ w � / / o w / Lp � |\ $ $ w $ — G \ b. / w a ' w M . . .� 2 . 2 % . $ � _. � \ / ƒ k W \ k _ 8 |% $ S $ @ co S S A w � b $ / w to 2 ¥ 6 $ -4 0 £ � A w A k \ 3 0 v IC* A w co / v / � to |% � ' ƒ w � � w � ON G k k $ J $ a% � -M w 89 |/ w R k $ % 00 co � k A ¥ � w |k . ' b G k co � (II COk 2 VILLAGE OF DEERFIELD, ILLINOIS PROPERTY TAX ASSESSED VALUATIONS, RATES, EXTENSIONS AND COLLECTIONS APRIL 30, 1986 ( See Following Page) t 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 r fAD r Crn Cr rt p m r• (D N 91 (rr) f) Rlb.+ a � N y t7 � � G F• fD � f� C ►C 'U• n• � v �• G M N (aD � C m m r R '8r• O ri t� N R (I O I WD�7iGG . �J iA Vi iA � �O 1-- 1--• (�D Gr w W_ W_ w N 00 14 w 00 �O O O �r-• IF v %0 N O � Vp p W _w _W V_ 7R r .0 W W q0 O O l r 8 OpO � N� w O I V� W l�l� V1 NJ � N C, 00 W fl.) � N G I`Ow R O w wN 0000�%DO pp� CO CO N I m �O W V,i �C t- to — O v 00 co w 1 w co O- �G�Oww4.O N a, vi V O R r I I O pp V (7s %.n o CDO co w %.A Qn to I R W fD va co + %Q + �00 iCC V — Ham-• V �O w r FOOD In O� WN OOC•00� l �p I O r-• r r� 0 0 N w N O O I I fD N N N w pro 00 lcoo N N W O000 V O O 2S�Ct5t5t5 o�Z5Z5. C', �, 000g"' �m %Lr%D � Lri N cn %O rl M .--4 cn L I1 00 pCY% cn � �pOp p0pp p pp N O •�-� I P4 III Ln � M m ' �' i 1. N N Ln Ln c -i N c'1 ON 00cn V} Vi Vi 00 O g N C*4 � O CRII 88 QoNCaC� MppOpp N 00 O JJ 00O� NO GNO C4 I I en OM�7c��1.M-i-i M r+N <& a % � Lr pg C> OII CD c 1 N r� 00 r- %0 -4 . 4 Ln Ln L � p 't " Ln n N N 00 QQ Ln � N 0000 � cn N o� Q Ln M M N rnc4 t� E+c�O ONE.=iOLn Oil N O O co E 00 N O�%O N pp msm �O cn Ln8� N Q� 5 cn � 'A 0^0 ^I( 00 ONLn c+�1 N ) cR oy QI 0) 0% CO L s . ; � $ ° p 14 C0. o Q 13 kwb 5(13 4w �u�� vw � � � 0 . '�� a r 114 115 VILLAGE OF ILLINOIS DEERFIELD, ASSESSED AND ESTIMATED VALUE OF TAXABLE PROPERTY LAST TEN FISCAL YEARS , APRIL 30, 1986 ' Tax Assessed Value Levy Real Personal Railroad Estimated Year Property Property* Property Total Value ' 1976 $135,719,691 $4,323,321 $75,099 $140,118,111 $420,000,000 1977 151,516,439 4,847,432 34,815 156,398,686 469,000,000 1978 167,268,250 6,900,001 35,541 174,203,792 526,000,000 1979 187,888,610 16,018 187,904,628 564,000,000 1980 221,339,145 18,044 221,357,189 664,000,000 , 1981 227,433,235 24.,051 227,457,286 682,000,000 1982 236,918,613 25,565 236,944,178 711,000,000 1983 235,899,599 31,938 235,931,537 708,000,000 , 1984 245,799,001 39,522 245,838,523 738,000,000 1985 249,312,226 38,331 249,350,557 748,000,000 , * No longer assessed due to change in Illinois State Statutes. Data Source Office of the County Clerk 116 .t 0T I- p %0 1� s .� 00 1n u's 00 Op.tcn M U MN .t -� N N N ' M 1!'1 N 'O N N O •--� %0 .t S O p tn %p O-p mM, %0%0 N tn OOI CT ~r .t .7 O M -- N � O O ^ O 00C14 00 N 01 co 00 V1 U1 .t O M ON -4 N N N N .-� p� cq N M cn * N C -- M I CT �j c 1 1- I- N �o .-� N N N Z 1'� N .t a% 'O Q% 00 p %0 O N pO.tcn�O .t S nnON a%cn �pp ' W M %D r- n Ln O0 00 t+ A o^p OpLnu�r� .t O I •-a N N N L to 44 4 ♦.1 c+p1 p M M O, .t 0 n I ^+ p N 00 00 1 LnO cn N m 0 N 00 h 0) ' � � •-'� N N N � L O ��osao O c 00 A ON N r--1 M IN co pOp� M V" M O N M .-1 •--� N N N y 1 � L U to _ L • u mow{ }.� ❑ N 0 O 41 A • � � L CJ 3C 7 i� Jam! w H � m (4 u pvp C o� O C7 w w fs+ 1� Aj O 14 C vLi f� cs UCw a' y GJ n) 4 C 10 It C� � 4 1 14 � p to 00 2 0�� w N co�8 �U u �oD "4 .�C1 -4 8 0 k�e y N-,400 N f n1 �0 u w H H A 0 117 VILLAGE OF DEERFIELD, ILLINOIS SPECIAL ASSESSMENT COLLECTIONS LAST TEN FISCAL YEARS APRIL 30, 1986 Fiscal Assessments Year Collections 1977 $72,003 1978 64,952 1979 66,386. 1980 19,436 1981 21,919 1982 22,078 1983 30,451 1984 16,248 1985 35,075 1986 2,400 Village Records 118 co A S q $ � � � c4 � \ ) § / § 2 ~ ¢ 8 — - \ / co co ƒ 2 § f J § # � / � / \ 2 ] § \ \ 2of § § \ fn e n o © q ~ §� a % / . / . ^ .f k f ecl�n \ \ §� \ In\cn \lc. | ) ) \ co k 0� } k � a I ) 119 ' VILLAGE OF DEERFIELD, ILLINOIS STATEMENT OF LEGAL DEBT MARGIN APRIL 30, 1986 11 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 $249,350,557 Legal Debt Limit - 8.625 $ 21,506,500 Amount of Debt Applicable to Limit Sewerage Improvement Bonds $ 525,000 Sewerage Treatment Facility Bonds 925,000 Corporate Purpose Bond Series 1982 350,000 Corporate Purpose Bond Series 1982-A 475,000 Corporate Purpose Bond Series 1983 400,000 General Obligation Variable Rate 4,100,000 Demand Bond Series of 1984 6,900,000 Police Addition Installment 1985 Contract 155,000 $ 13,830,000 Legal Debt Margin $ 7,676,500 ' 120 IVILLAGE OF DEERFIELD, ILLINOIS STATEMENT OF DIRECT AND OVERLAPPING DEBT APRIL 30, 1986 (1) (2) * Percentage of Debt Applicable ** Village's ' Governmental Unit Gross Debt to the Village Share of Debt ' Village of Deerfield Cook County $ 13,830,000 399,300,000 100.000 .081 $13,830,000 314,919 Metropolitan Sanitary District 663,750,000 .083 541,821 Lake County 49,175,000 5.034., 2,475,470 North Shore Sanitary District 12,908,000 .025 2,881' Deerfield Park District 1,290,000 94.712 1,221,785 Northbrook Park District 10,240,000 3.716 357,466 Highland Park District 2,300,000 1.801 41,423 Deerfield Elementary #109 750,000 73.284 520,445 Highland Park Elementary #108 100,000 5.873 5,752 Junior College #532 3,555,000 6.025 214,189 Total $19.526.151 ' * - Determined by ratio of assessed value o.f 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 / KPI / ( \fR 7 ° § \ . � c f § � * � � � b � ||a $ (k # - § { |§ $ - ||\ \ |§ w # - � ||\ \ \ |§ $ _ |$ ||} § J 3 !zi 122 f §�) � 2 � ~ � \ kcn 2 \ \ In 7� [ \en C, ) § 2 f co \|| \ 2 \ \ §|| / § 7� § � I + \ Sl� fr, § §/ § _ � § B . § P §| \ � cn lo Z © J 123 VILLAGE OF DEERFIELD, ILLINOIS ' DEMOGRAPHIC STATISTICS LAST TEN FISCAL YEARS ' APRIL 30, 1986 1 (3) Percentage of People Over , (2) 25 Years of (4) Per (2) Age With Four School (5) Fiscal (1) Capita Median or More Years Enroll- Unemploy- ' Year Population Income Age of College ment ment 1977 17,862 $34,034 31.0 26.8 5,383 1.2 1978 17,717 34,356 31.2 27.0 5,123 1.1 ' 1979 17,753 34,678 32.0 28.0 4,838 1.0 1980 17,430 35,000 32.7 29.0 4,568 1.8 1981 17,453 373000 33.3 29.6 4,318 1.7 ' 1982 17,476 39,000 34.0 29.7 4,106 2.2 1983 17,487 411000 34.7 29.8 3,933 2.1 1984 17,500 45,000 35.4 30.0 3,788 1.9 ' 1985 17,500 45,400 36.1 30.0 3,703 2.0 1986 17,500 46,100 36.5 30.0 3,715 1.7 Data Sources (1) 1980 - Census figure; 1977-79 estimated by using 1977-1980 Census data; 1981-1985 derived from data from the Department of Commerce and Community Affairs. (2) 1977-1980, Northeastern Illinois Planning Commission figures; 1981-1984 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. 124 VILLAGE OF DEERFIELD, ILLINOIS PROPERTY VALUE, CONSTRUCTION, AND BANK DEPOSITS LAST TEN FISCAL YEARS APRIL 30, 1986 (1) (1) Commercial Residential (3) Construction Construction (2) Total ' Fiscal Number Number Bank Property Year of Units Value of Units Value Deposits Value 1977 37 $ 5,336,939 144 $5,443,453 $ 40,789,000 $417,000,000 1978 66 9,175,438 121 3,649,126 40,288,000 465,000,000 1979 81 5,994,271 50 1,176,405 42,531,000 519,000,000 1980 52 1580,392 67 5,650,240 49,178,000 564,000,000 ' 1981 59 3:235,868 85 1,852,788 52,282,000 664,000,000 1982 77 9,758,795 86 1,689,832 53,522,000 682,000,000 1983 1984 84 52 20,369,020 12,146,201 104 46 5,673,638 5,131,160 63,218,000 63,877,000 711,000,000 708,000,000 1985 101 34,504,614 50 6,552,552 64,750,000 710,800,000 1986 135 37,746,399 90 11,318,142 130,155,000 748,100,000 Data Sources ' (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 1 125 Taxpayers Deerbrook Partnership American National Bank and Trust #51702 Travenol Labs, Inc. Kitchens of Sara Lee Lake Cook Plaza Teradyne Central, Inc. Draper & Kramer, Inc. Flodstrom Construction United Conveyor Whitehall Nursing Home Office of the County Clerk VILLAGE OF DEERFIELD, ILLINOIS PRINCIPAL TAXPAYERS APRIL 30, 1986 Percentage 1985 of Total Assessed Assessed Business Valuation Valuation Deerbrook Shopping Center $14,028,727 5.7% Lake Cook Office Center 8,156,440 3.3 Office Building 6,328,472 2.6 Bakery Products 5,196,310 2.1 Shopping Center 4,177,196 1.7 Electronic Test Equipment 3,918,226 1.6 Deerfield Business Center 2,113,874 .9 Office Building 2,057,435 .8 Testing Devices 1,782,990 .7 Skilled Nursing Home 1,604,310 .7 $49,363,980 20.1% 1 I 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Date of Incorporation Form of Government Geographic Location Area Population 1950 1960 1970 1980 VILLAGE OF DEERFIELD, ILLINOIS MISCELLANEOUS STATISTICS APRIL 30, 1986 MUNICIPAL SERVICES AND FACILITIES Fire Protection: Number of Stations Number of Firemen and Officers Police Protection: Number of Stations Number of Policemen and Officers Education Elementary Schools High Schools Municipal Water Department: Number of Consumers Average Daily Consumption Miles of Water Main Sewers Sanitary Sewers Storm Sewers Building Permits Issued Recreation and Culture Number of Parks Number of Libraries Number of Volumes (Approx.) Employees Administration 126 1903 Manager/Council North Suburban Chicago 3,288 11,748 18,876 17,430 1 27 1 35 5,446 2,200,000 gal. 70 Miles 60 Miles 60 Miles (5/l/85 to 4/30/86) 620 commercial & residential 131 acres 1 117,000 12