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 (2)
COMPREHENSIVE ANNUAL FINANCIAL REPORT for the year ended April 30, 1986 VILLAGE OF DEERFIELD, ILLINOIS 1 COMPREHENSIVE � ANNUAL � FINANCIAL REPORT 1 1 ' FOR THE FISCAL YEAR ENDED APRIL 30, 1986 i 1 ' PREPARED BY GEORGE VALENTINE FINANCE DIRECTOR � VILLAGE OF DEERFIELD 1 1 1 1 1 1 t 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 1 ITABLE 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.) PAGE FINANCIAL SECTION (CONT.) GOVERNMENTAL FUND TYPES (CONT.) DEBT SERVICE FUND Debt Service Fund Financial Statements Balance Sheet 58 Statement of Reveues, Expenditures, and Changes in Fund Balance - Budget and Actual 59 CAPITAL PROJECTS FUNDS All Funds Financial Statements Combining Balance Sheet 60 Combining Statement of Revenues, Expenditures, and Changes in Fund Balances 61 SPECIAL ASSESSMENT FUNDS Special Assessment Funds All Funds Financial Statements Combining Balance Sheet 62 Combining Statement of Revenues, Expenditures, and Changes in Fund Balances 63 PROPRIETARY FUND TYPES ENTERPRISE FUNDS All Funds Financial Statements Combining Balance Sheet 64 Combining Statement of Revenues, Expenses, and Changes in Retained Earnings - Unreserved 65 Combining Statement of Changes in Financial Position 66 TABLE OF CONTENTS (CONT.) FINANCIAL SECTION (CONT.) PROPRIETARY FUND TYPES (CONT.) ENTERPRISE FUNDS (CONT.) Water Fund Financial Statements Balance Sheet Statement of Revenues, Expenses, and Changes in Retained Earnings - Unreserved - Budget and Actual Supplemental Statements Statement of Operating Expenses - Budget and Actual Statement of Fixed Assets and Depreciation Sewerage Fund Financial Statements Balance Sheet Statement of Revenues, Expenses, and Changes in Retained Earnings - Unreserved - Budget and Actual Supplemental Statements Statement of Operating Expenses - Budget and Actual Statement of Fixed Assets and Depreciation Refuse Fund Financial Statements Balance Sheet Statement of Revenues, Expenses, and Changes in Retained Earnings - Budget and Actual Commuter Parking Lot Fund Financial Statements Balance Sheet Statement of Revenues, Expenses, and Changes in Retained Earnings - Budget and Actual Supplemental Statements Statement of Operating Expenses - Budget and Actual Statement of Fixed Assets and Depreciation PAGE 67 68 69-70 71 72 73 74-75 76 77 78 79 80 81 82 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 De po s i t Fund Financial Statements Statement of Changes in Assets and Liabilities ACCOUNT GROUPS GENERAL FIXED ASSETS ACCOUNT GROUP Financial Statements Statement of General Fixed Assets Supplemental Statements Statement of General Fixed Assets - By Function and Activity Statement of Changes in General Fixed Assets - By Function and Activity PAGE 83 84 85 87 88 89 90 91 92 93 TABLE OF CONTENTS (CONT.) FINANCIAL SECTION (CONT.) ACCOUNTS GROUPS (CONT.) GENERAL LONG-TERM DEBT ACCOUNT GROUP Financial Statements Statement of General Long -Term Debt SUPPLEMENTAL DATA PAGE M1 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.) PAGE STATISTICAL SECTION (CONT.) Special Assessment Collections - Last Ten Fiscal Years 117 Ratio of Net General Bonded Debt to Assessed Value and Net Bonded Debt Per Capita - Last Ten Fiscal Years 118 Statement of Legal Debt Margin 119 Statement of Direct and Overlapping Debt 120 Ratio of Annual Debt Service Expenditures for General Bonded Debt to Total General Governmental Expenditures - Last Ten Fiscal Years 121 Statement of Revenue Bond Coverage - Water and Sewer Bonds - Last Ten Fiscal Years 122 Demographic Statistics - Last Ten Fiscal Years 123 Property Value, Construction, and Bank Deposits - Last Ten Fiscal Years 124 Principal Taxpayers 125 Miscellaneous Statistics 126 Introductory- .Section 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Harriet E. Rosenthal James L. Marovitz Cynthia J. Marty VILLAGE OF DEERFIELD, ILLINOIS PRINCIPAL OFFICIALS APRIL 30, 1986 LEGISLATIVE VILLAGE BOARD OF TRUSTEES Bernard Forrest, President Edwin B. Seidman Vernon E. Swanson J. Robert York Naomi S. Clampitt, Clerk ADMINISTRATIVE Robert D. Franz, Village Manager FINANCE DEPARTMENT George J. Valentine, Director of Finance/Treasurer i CO od-Z } NO ww 0 z Q--jO Q J 02 > �... MO U 0 U aw Ow w� J m V) O c7 m 06:) �a it cr. O ~_ J Z > a Y cr w J U w C7 Q J J > zz Ul Z w z tzj Z U V)- U w w> z w w w W LU O > m> U. Z p �O Z Z Q J m a J in 0 Z a. Z w a N g W a F' C7 Z v W V w Z > V) F- Z Z caU w lz :3 < ON uO �z w m a, Z n. . a w N Y w a: O F- LU z w (n F- U w } w z � w Y U LU U Z U I- � Q O Q F- � Q w z V) 2 O- w LLjF- F- Q m 3:: -:t Nw N > Z O F' Q LL Q w a z O w QQ �z Z Q C9 W.IX 22 VI > Q wF- VI :DF- !n� VZ Ow � U 0 a a v U z F- Z U z w U z �W w z J - V) z Q w" z O =g w V)U z O m = Z U O V Q¢ � V� w ~ lL m Q z }- a. J Z a Vf z N z F- O O w U J F— U V1 w CL w F- cal F- a: U Q-j O a F- O z U a a w } � La ww ww Z O ad 0 V ii ' � Certificate of � Achievement for Excellence � in Financial � Reporting .1 .1 II 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. _ NEE OFpj�, �,` NITED STATES AND President CANADA lSIWMTDIN s IExecutiveDirector 1 1 1 1 1 1 i 1 1 1 1 i 1 1 1 1 945.5000 ILlIN01S 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 F, L ' 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 Statement 3". "Defining the Governmental Reporting Entity - NCGA 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 ' of 4.3% over the prior year. ' 1986 REVENUE Increase Percent (Decrease) Revenue Source Amount of Total from 1985 Taxes $4,1 3 812 63.4 _260,324 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 revenues' in the year collected. Allocation of property tax levy by ' 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* Genes Fund --.T6-8 .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 BGovernment $ 995,330 16.1 $(286,622) 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: 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,000 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 operating income of $65,292. Ll 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: Brickyards ($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 ' i 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. I 1 1 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 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Financial Section 1 1 AUDITORS OPINION 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. I Bank of Wheaton Building o 211 South Wheaton Avenue ® Wheaton, Illinois 60187 a (312) 665-4510 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 r., 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 � r Karrison & Byrne July 18, 1986 t 1 I 1 ' COMBINED STATEMENTS -OVERVIEW ' VILLAGE OF DEERFIELD, ILLINOIS ALL FUND TYPES AND ACCOUNT GROUPS COMBINED BALANCE SHEET APRIL 30, 1986 I (See Following Page) 11 1 11 -7,� O r. y�RF f0 N a N rF+ y, S �7 GN 2 AD iWyG � N o p ry t- (f3 1(D' N f~D CD8� C n N f(�Q g CCC��� tf 7 O N �H tl P• � '� W n n/ N r� v'e m �• ^I' fl' �np N W v (q fD � 7 R W � Ih W WWW T W O F ZD v v N pppp V r N � OD vWi i %A ODD iA ppND .y r r r W OD o-N-• W iA a 00 W N r C 11 C � N N �O WWN �D 43, V W rN-• g 00$ W N O N F V o c O W O _ O O V O T `4- O to coOo F O N vO V O V N W W or co co V T OD P pp yV F Pa, O O r W co r N W pQ V W � v W W O ��rN-•v OVOr W N 8 rnp� W N O, O W 41 V ZO,� O W w F 0 V N F 1 F �NN O N a,�pp v r ` n V W �--• N w 00 Oo 41 p C, O 'O Oo 'O io W NJ8 OVl Cp�888 opM� p gyp} M8M .Mp ��D p� p p� T O��-+�Ou�••NrOOOO W oO0 a0 O 3 03 d n T 1�M � N O ^>1 co 'D .r O7 O� po p� 1� n n V\ V\ �Y N V\ M V1 V\ O T V\ V\ .pr O� Vp1 .•.! N O O .y r N V1 N f"1 V1 .N-� 1 N n t�1 ��7p1 � Og .•-i M M Co 7 tpmp? p0pp 8 pp �p 8 8 8 8 i? t/r VY t? .••i N (A N N N f? In I�7 O���O000�70�0 ^ pN �ppp �p fn1 pyp� Scn •--' N M Q 8 �O o V1 �A M N O f^'1^ O^+vM1 .�i •!�1 �p N 1� M UY V1 p M O N pp M d 00 N N O� O� V\ 1� M , 00 T �7 O �7 I v I n f+1 � N 1!1 N V1 1� �O .r �O fff+++111 M N m tro+ F if V 1 I aMO cn co 10 us yr u} � pmp pp ccpp cep � W l•+ 1 v en M S r, co r- INI NINI II IcI �I J N 8 g g p •yO •� N O p� H O p�p T v\ Ln d O N M M IO 1� pN N V1 enM-I d N N V1 n n r- m1 N N GNo N N N N N O % N 4} N 4T Vf VY Gco pp O N Ln .-r .••i .r .y �D ..a u r� e� VNi �O 'O �O Zo �c o N O N n n n n C U W+ N N m O, O, Ol N 4* 4} V? Vf Vf Cl M1 r n Ili Q1 .' co 91 f�1 M N S S T Nen V\ V\ p O M V\ V1 y N (A (? Vf 4} N 95. (? V Ien N V1 1� n en n �+N NV1 Md Goo ,d VM1 Ol Ol co N Cl y to •L W P. qq a 0 7 N ai Go J cal c~C a�! �.. A 1+ •u .J m inIJ+ °i •::, •C cL 7 •aJi • a m m °1 4N°. U° N ((pp Gl tll �.! '$ .--1 y .--1 .•-1 •.•1 J] m m IC 1.. QC} N •pV�f O cl it J DL W •�± �p p oC y 1+ w Cy N ..c�co u p• • J �j 01 W N e C7 A H m I 1 1 1 1 x x % m •p ry tD C. Prot 3G W G. N pp� n 't7 'd N r� % N p iL C N �. S 0 — 0 N 03 n w w�.. r•� tom w 0 m m" av w o--0 O•'V 3c�xro�n o HN 0 w rt. n x 7 r• n r r• G O 0. 0. w n W r• w X 7 w •V 0. n n n m 0 0 •4 w m w 7 0 a n �- H rt r• r• r• G r• C n �• rr w F-• pO D' 7 m r• O m m , m m m G n m w 00 n D m m O G G n �' m m r' n r• A 0.^ O m 7 N W n rt T r m 7 �' m �' m OD w w a w w 0 m ro 0 0 0 0. r• r• a r• r• O n n n m r m G 3c r• n n G r r 0, w O m V O W r r 0. m n = n 0. n. — ::r m o o w pO OO 7 a n m OQ G M y m r• n r w •V < —" w n y " O r m. `C r w 0 D < w fp N a O D t+1 mCO W. .D 4 W O m w n. m r• Cn " 0 n Ri H H r• " r• V1 m n n 0) r• � r• n w w En<< rc 7 N W O mW < O, n a 7 r• C C r 0. n r• R R 0 O m r• X N m r m 7 W O m G 0 a 0. a r• r• w m N m 0 W CD 00 G m •V 0 W O 0. o m< P w" N m 00 n n n 9 `C O• rD 0 0 G n m 7 0 7 0 m N n 7 7 I1 m n m 0. 7 n `C G 0. n m W `< n G m m D •V m m" n m Z co PI m rn rn 0 m rn`< 0.� r• N 7 w r• C w" O I H H w C R R w m n v a m " m m G w n n" w 0 n r• r• R n w m n n a R R m rt r• r a w n r• m w W n w O r• w w n i. m 0 G n a m m 7 m n w m s a o h m Oy' M " w m w m n w N ow m n 0 0—"w w o m r D rt n m m n O m m iD r G ^ N? 7D n w w m 00 w n m CD m ^ rr O 7 w G m m n w r• v G m 00 m .f C w w O w w r• 7 n ..i p O m < o. m " Y • m w r N n w n m +n <n O a+ In W N F' m n W 10 %D v� _ D, N 10 00 r• W V N a� �-+ O w V OD OD 00 �D T a� to QO N an W w 10 N W 10 O m " a� W w W N O O N V W W Y• v� N F V N w O V1 �,n �n v� O O to �--• 00 W O O1 N �-•' 10 N N N V O O V N N O 10 �D F N N a1 O1 %p 4A � ' N 4 N r V 00 00 OD r• Y• r•• Y• W OD �D v� N r• m v rn V� V V V V V V w T N �D l!� Q` N V OD • \l1 F N1 V N W F F V N m W �n W Y• 00 D� C m m n 7 r• •D F Oo OD Oo OD w W O 00 0o O �D O N W V1 00 N O• N V F V a� w �- 00 a` N N r C W m i--• F F r A o v� v�o v� 0Cl w ow O0Nrw C m n to to to <n to ilf in to N il) +/> +A a a m _ to V .- m O n N N N N w W F V� W N w O `•-' �D 'o " m m r• n W ' WV V .N .N of CD 000 %D a+ N VOO rnrn o m M m C � v D• to to to va <n to to [n il) to +n m � V W w W F W po F 10 N 00W N V N n w O 'V w O CD W V F O+ F r• W V V 4- a, Oo V F �D In m n n m OD "I— w W V ID U w n �•-' r• F N F N 4-m N 10 N— N In O v ll� v O �D .-• V N Vl �D �n �•-• v� T w to N N N N N w a m m �-•' W W W N 1 N W W T a� w n O 10 10 00 OD — a+ In 00 00 10 10 00 co m r• v v v v F F 7 n N +A N N +n iA [n N [n y to N F OD DD OD a� a� O� _ �D N N 00 r• In 00 O� co 00 00 00 N a+ a, m F F T 00 F O W N 00 a, OD 10 O 10 w 10 vi F N 10 r• N 00 F w W 0\ �D ♦-• N N N 00 O O 00 'D F .- O 'D 00 'D %D %D F N CD V r+ N w W W F O ,O W r• O a w F F F D r• 8 0 0 0 0 �D a� In O • •' 0 0 �D �D N a, O w N N a 1 a, V, 0 V �p vi 4- N ZD a, O N N O O D O O o O " v v 0 0 7 D w G r a w In T r• r a, i. O, �D O O P a+ 00 W N F Cl N a, �O V N N W w r• V1 F 4- r• 00 N O 'D �D O lJ a, V O O V N V V vi w to W �O w OD V O %D %D .- 00 OD w O CD F r•- V V Cl O m V� �D W �D Oo v a, In %D 'D to M vw .N- V�--• vOD� wN V In N N �n F O CD O O O VN FF F OD 00 f W O1 O O a, Ol w O NrnW1D �NWO N NN� N w OD OD F n O 3 W z t+1 O 9 N O 9 cli m$ R it z z Cl) H N O z m '*1 C C t+1 v c W N t9•' . 2t-I X c] '0 w [*1 PC v M H C t+1 V) 17 i 5 1 1 1 u I I w d ^ O O E. 7 a 6 rn W C d 000 O z Ol wE.- — a Cl w W 0 OM 1 ^ m In ^ m W I A7 C Z En a NG1 >Ua w Z W Z n C66 wI W W w 6Z Lc W O m W W Z F. O cd O > Z z W aid F~F 1-1 1-1 V1 !A > W O u 0 V]Z Zd W H m U V .a U Z. W C Z V N Oa0 pNM V� O� �O 100 00 n c0 O ML^ M n O ••+ as N J VY .•a M M CD'O N 00 O N u, n •-gy m N O c0 Ol coM p�O�nMO MMMNO ON O c0 00 MID•-�J O+Nw V1%D N nu 00 •D ^ Jm nM m N J u1••-i NM cO V1 ID no0 J O J M n nO, O m w M u'1 Ln .•� M 'D ^+ J O M J ID N O .4 n V} V). V} V) V} V} Vi V} (? ao n Ooo D O N 00 T c 0 0 0 0% J 0 O J 0 D O 0 O m �nOOOOJ �"�n �.•�� O0N n •-.O••� �O %D ol O MOO rn O O J D+ O J n r n ••-� Nu\�D a0 c0 n(nr N NM V1 M •--�0� N J JLn-+•-�'DJ C .••i mO M u ID lc N J NN J 10 -r N .••� �D v V) V} V} V} N V} N N O 10 .0 O O O n c0 v1 O M LA M N lc O� O N N N Ol c 10 n M co o co 0 0 0 -+ a (n rn n Ol O N M Ln J M M N Vl V} V). V} VY V) V> Vf ti VY O O u1 O N O .•-i -•i �D �0 .p O M O M O o C �0 •r .•-� V1 c0 ul 0 J J O c0 oO n J 2 n o0 u1 '0 M M V} V). H V} V} V} V} VY M J N 0 M O M ID lo O u1 u1 O u1 Ln O J J ^+ N N ID c0 .--i N 'D N aD O� ti O c0 c0 M UY n J n n M N O ••+ u'� O M M OD O G� V1 ID oo M u1 M N n u> 0 n 'D V1 O, •-� n V1 ;r M 'D N n J J J V1 •••� •--� N N n ID �+ N 1n -r .-i O, c0 M .ti v .••� v c0 n VY V} VY N V) V> Vt N V} nOO o .- c0 OO umo 'm M OOO n ^+0O0 OHO Oo:!0 M n Oo0 N �^oMO OCi OLn -In N l0 ` o0o M oD 0M n J N NJID -� n v1 %D chM n CV D N n cn N n 0 N o ^� V4 h N N u 1 M J O O M M N V) V> V) H V} Vl N V) O' D 'D N N J O, N 'D O n in 'I 'D O N M m N .-•� n u1 o o O O n V1 N u> T O N n J N V1 ..-� M M n O O+M M N O`O) u1 N c0 N I0 �0 O1 W n •--� lD N n w w O� N •--� l0 V1 Cl u1 ;. J N M u1 Ic %o %D N O� N M N M N N Vl Vl V} (? V} (? V) V} OO-+00O-. O-. .. 0 Ooo o O o e V 0 0 0 N O o 0 0 0 O O O N o u' i n 0 0 0 N M n O n O O C N O O+�D'D O—M �N 00w ow C.Ni 0 J v y N M N N ti N Vl M V} V) Vf V) V} u m V V) m V C m C m m W m W W W W C O,4) L4bo V v m .� u u u m C.•+ W i>r O W w m C m Nv cL 4 4 W W u m m u W m W m 4 w W 0 W W> .0 m V w N u u O o Qo Go O O • •+ m e -••-+u 1W+ a u u Oel 4.+•+ m m /u + 4 4 C W W O m u 4 m> •.+ m C [n yy •.+ w •o T W W pp u+ w T W •C Z W u 4 W W P. C W W 7 4 T W m W u 'O C L C y •O W V 4 u C 7 4 !A m m C C u u G C 4 m W to 4 m C > W C •d O O'• C 0• W u 7 cp m m W 7 p •O B O O W C C 4 W 0> O w m C W W U m m C u m% -+ W •-+ •-� O u 'O N C 4 4 ..+ F F •.+ O u W W m T M 4 O W ay! 2 m V) m m ..+ m u ..+ C V ••+ 4 W C W w •d G m> C m W 4 •-+ T W -+ > m u m 4 •-+ 4 W m -+ ••a w W 0c G cO Oc W 4 7 yy u m 0. W O m m •-+ .--i D u o ..+ 3 7 W W u w" p k_ C•�— O t •u+ cu M e m m 50 W -+ m u C W .+ F u u W C W O v W V O W m C 4 cp m W u ... W G o c0 -+ m •.+ u F C w m m O O m �. -+ U 7 W W W 4 W u 0 •O L y C ..+ 7— u W 4 C m o m 4 4 m W m ..� F W m ••+ C L w N C1 C 4 G. U 0. x U ,'� ,0 G W �••i m W C u 4 Wp. Wp, m •O %m T 'co 4q. cc >H^a O W 0 0 u m W 6 W W y W W 0 W W VILLAGE OF DEERFIELD, ILLINOIS ALL PROPRIETARY AND FIDUCIARY PENSION TRUST) FUND TYPES COMBINED STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - UNRESERVED FUND BALANCE FOR THE YEAR ENDED APRIL 30, 1986 Proprietary Fiduciary Fund Types Fund Types Totals Internal Pension (Memorandum Only) Enterprise Service Trust 1986 1985 Operating Revenues Taxes Charges for Services $2,758,312 $128,562 $ 173,723 $ 173,723 2,886,874 $ 156,125 2,526,987 Contributions 97,525 97,525 75,750 Miscellaneous 206,246 361,378 567,624 497,277 Total Revenues $2,964,558 $128,562 $ 632,626 $3,725,746 $3,256,139 Operating Expenses Administration $ 251,314 $ 251,314 $ 227,184 Operations 2,642,577 $143,129 2,785,706 2,473,308 Depreciation 282,857 282,857 266,147 Benefits and Refunds $ 67,873 67,873 65,912 Other 937 937 25 Total Expenses 3,176,748 $143,129 $ 68,810 $3,388,687 $3,032,576 Operating Income (Loss) $ (212,190) $0 4,567) $ 563,816 $ 337,059 $ 223,563 Nonoperating Revenues (Expenses) Interest Income $ 95,084 $ 95,084 $ 97,177 Property Taxes 399,219 399,219 364,382 Interest Expense (7,438) (7,438) (9,000) $ 486,865 - - $ 486,865 $ 452,559 Net Income (Loss) before Other Financing (Uses) $ 274,675 $04,567) $ 563,816 $ 823,924 $ 676,122 Other Financing (Uses) Operating Transfers (Out) $ (20,000) - - $ (20,000) $ (20,000) Net Income (Loss) and Other Financing (Uses) $ 254,675 $(14,567) $ 563,816 $ 803,924 $ 656,122 Retained Earnings - Unreserved/ Fund Balance May 1 $1,274,172 $ 31,228 $3,208,722 $4,514,122 $3,858,000 April 30 $1,528,847 $ 16,661 $3,772,538 $5,318,046 $4,514,122 See accompanying Notes to the Financial Statements. G7 W H OH F A H z D O F c cn W H L H O U z E-c Z a z H f a w H1-4 CA zh ^z HL A cn L w z c W H V L O H L L*+ F w z" C9 A L r�4 Qz' W E a F 9 Cd Cd E-4 L W A H W a z LL H O a o a a N r\ 01% r\ n M r- 0 �o O M ON N N Ln r- 00 Ln N Ln N O N -4 -4 V1 r\ un �-• 00 %o r, M m .4 4` r� r— rn O O 00 O c7% O% Ln It O N N O ON M M r- to r\ N .a .-r N as ON N cn cr1 M ON O M C4 Cc o :J 'b [-4 W r` -4 r\ rn 00 C% O co Ln N %o $4 N rn 00 r- ON It rn r- Cl cn M 1f1 r- N O a% 00 r- cS M r- N 00 O r- 00 00 It cn O1 00 ll N %C n N r d N O - 00 00 C� 00 m O 00 00 r- %0 It O N O Ln N 00 .� 00 N O N m ON 00 m %o %0 00 It r\ �+ 0) C 1-1 -4 N It U N Ln 00 m 00 w :y O L 00 00 cn M O% C% M 00 N co .4 m • 4 E-r m C C11 C Lr O 0 O� u C w %o �o �o rn �o C 'G I F cn cn cn cn m cn a N G� tsOi yr yr yr yr vs yr m, —4 .-. ca O) r` n 10 O N �t C u �o t N O O N 00 It .; to Ln N M N N cn N N N �t 1t C r` r: CO im. <? C? N F ,, sa b v a G m In r- N 00 .-r .--4 •-. C,, O Oo 00 M f\ O C r- cnCl) OrnM Or—OrncM m m 00 w ;u 1+ %0 00 cn N ON r\ -4 00 O r- n m N N w a $4 N r- N N N V) N O •-•4 M N cn ID OJ 00 M r\ -4 N O �t N 00 N cn r� L N N Ln 1-4 ^4 -t m M C W yr yr cir yr yr yr m a� m .-+ m •� L m O A N m G 0 k •d ai � m�' • m a�i aCi � •b G O W w N v cU G •"+ 7 0 UU —4 N.0Z CO r ►+ C U W u N Pa w ww •,4 N x ca G. w U) m :J :J (u ro co w 0 b A 3 ( $4 a� z u u 0 o r-4 o U C C O w •O N F �4 k m •b G • � 'b G cuUfs+ CCoU � N NCO OJ m m m m cb cv v co 3 N u $4 U W iJ u 0) m co m CU L la C A 4-1 v m a) cO» C 0 H O u C -4 C Rf • d z U 7 m G v 8 a� cti u C ca C w a� iJ O 4-1 a� iJ O z 00 C C ca 8 O u u co a� 1. 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. 1 i It' 1 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, IVILLAGE OF DEERFIELD, ILLINOIS NOTES TO. THE FINANCIAL STATEMENTS APRIL 30, 1986 1 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 accumulation of resources for, and the payment of, general long-term the debt principal, interest, and related costs. The Debt Service Fund has been treated as a single fund and budgeted in a like manner by the Village. Capital Projects Funds - Capital Projects Funds are used to account for financial resources to be used for the acquisition or construction of major capital facilities (other than those financed by Proprietary Funds, Special Assessment Funds, and Trust Funds). Special Assessment Funds - Special Assessment Funds are used to account for the financing of public improvements or services deemed to benefit the properties against which special assessments are levied. PROPRIETARY FUNDS Enterprise Funds - Enterprise Funds are used to account for operations (a) that are financed and operated in a manner similar to private business enterprises - where the intent of the governing body is that the costs (expenses, including depreciation) of providing goods or services to the general public on a continuing basis be financed or recovered primarily through user charges; or (b) where the governing body has decided that periodic determination of revenues earned, expenses incurred, and/or net income is appropriate for capital maintenance, public policy, management Icontrol, accountability, or other purposes. 11 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/orother 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 VILLAGE OF DEERFIELD, ILLINOIS ' NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 1 1. 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 validity seems certain. of revenue when they are measurable and their 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. Agency 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 accounting principles (GAAP). with generally accepted 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 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. Accrual Accrual Accrual Accrual Accrual Accrual 13 jVILLAGE OF DEERFIELD, ILLINOIS I NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 a, 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. I 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) than in are accounted 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. L� a 14 1 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 LI t 15 VILLAGE OF DEERFIELD, ILLINOIS 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 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. 1 17 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 1. Summary of Significant Accounting Policies (Cont.) iG. 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 1 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.) 1 19 ' 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 Asset s a. Changes in General Fixed Assets Land Building and Improvements Vehicles Equipment Balances Balances May 1, 1985 Additions Deletions April 30, 1986 $1,913,027 $ 2,283 $1,915,310 1,237,500 1,237,500 441,397 116,703 $187,000 371,100 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 $ 785,215 $5,953,497 Equipment and Vehicles 289,548 208,065 Parking Lot 613,958 $1,074,763 $6,161,562 $691,458 Less Accumulated Depreciation 588,166 1,199,841 212,704 $ 486,597 $4,961,721 $478,754 ' 4. Loans Receivable 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. 1 u 1 21 ' VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 3. Detail Notes on All Funds and Account Groups (Copt.) ' 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 I reserve shall not exceed the estimated total actuarial requirements of the Fund. 1 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. 1 I 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 Total Unreserved Retirement 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 $(1,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 11 23 1 I I 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.) 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 ' 3. Claims and Judgments 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 — ' 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 VILLAGE OF DURFIEID, iLLINOIS NOTES TO THE FINANCIAL STATEMMS APRIL 30, 1986 3. Detail NJtes on All Funds and Account Groups (Cbnt.) B. Liabilities ((bnt.) 4. long -Term Debt a. (hanges in Inrg-,Tenn Debt Adjust - Maid Debt Balances went s/ Balance s Retired By May 1, 1985 Issuances Retirements April 30, 1986 General Cbligation Bonds Sewerage Improvement Boni Series of 1973 Sewer TYeatment Facility Bond Series of 1973 (brporate Purpose Bond Series of 1983 (brporate Purpose Hond Series of 1982 (brporate Purpose Ibnd Series of 1982 A General Cbligation Vari- able Rate Demand Bond Series A General Cb 1 ig at ion Vari able Demand Bond Series B Installment (bntract Police Addition Installment Note Revenue Bonds Water Revenue Bond Series of 1960 Water Revenue Bond Series of 1959 Special Assessment Bonds Debt Service $ 550,000 Debt Service 1,050,000 Debt Service 450,000 Debt Service 500,000 Debt Service 450,000 Debt Service 4,100,000 $ 25,000 $ 525,000 125,000 92 5, 000 100,000 350,000 25,000 475,000 50,000 400,000 4,100,000 $6,900,000 6,900,000 $7,100,000 $6,9002000 $325,000 $13,675,000 Debt Service $ 300,000 - $145,000 $ 1552000 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 25 ' 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 ' ANNUAL PRINCIPAL AND INTEREST REQUIREMENTS Fiscal Year General Special Ending Obligation Installment Revenue Assessment April 30 Bonds** Contract Bonds Bonds* Total 1987 $11,652,825 $165,385 $ 50,737 $102,863 $11,971,810 1988 550,364 48,826 599,190 1989 542,548 46,913 589,461 1990 395,025 395,025 ' 1991 376,775 376,775 1992 358,400 358,400 1993 1994 365,550 143,500 365,550 143,500 1995 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 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 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. 7 1 I 27 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 cor corporate purpose r . i 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 Village has authorized the issuance of Industrial Revenue bonds in the following amounts: Chi-Chi's, Inc. $1,615,000 Trustee - The Citizens Fidelity Bank and Trust of Kentucky Teradyne, Inc. $1,000,000 Trustee - State Bank and Trust of Boston Industrialplex Limited Partnership $4,500,000. Trustee - American National Bank and Trust Company of Chicago The Village has no liability under these bond issues. 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. 1 - "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. 29 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 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 31 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 3. Detail Notes on All Funds and Account Groups (Cont.) 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. ' 32 vn Aa ILLINOIS 1 OF Dom, NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 ' 1 4. Segment Information for Gartain Individual Enterprise binds ' The Village maintains 4 Enterprise Funds ,hich provide water, sewerage, refuse and parking services. Segment infounation for the year ended April 30, 1986 is as follows: Caffiuter titer Sewerage Fund Fund Defuse Fund Parldrg lot Fund Total ' Operating Revenues $1,420,580 $1,014,219 $ 439,028 $ 90,731 $2,964,558 Depreciation, Depletion, and ' Amortization Expense 49,931 202,228 30,698 282,857 Operating Income or (loss) 167,149 (42,726) (371,207) 34,594 (212,190) , Operatirg Transfers Out (20,000) (20,000) ' Tax Revenues 399,219 399,219 Net Incase (Loss) 192,345 8,207 392529 14,5% 254,675 ' Plant, Property and Equipment Additions 56,725 54,418 111,143 ' Deletions 8,264 8,264 Total Assets 1,420,234 5,879,482 530,892 5%,957 8,427,565 , Net Fbrking Capital 708,096 695,812 459,755 116,113 1,979,776 Bonds and Other Tarp -Tenor ' liabilities Payable from Operatirg Revenues 1353,000 135,000 ' Total Equity 1,148,401 5,773,878 459,755 594,867 7,976,901 ' r 1 ' 33 IVILLAGE OF DEERFIELD, ILLINOIS ' NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1986 hI L 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. 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 I 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 11 F J F j GOVERNMENTAL FUND TYPES 1 1 GENERAL FUND Fund Description General Fund 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. *L11 1 1 1 1 1 1 1 1 1 1 i VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND BALANCE SHEET ASSETS Cash and Investments Receivables Property Taxes - Current - (Net) Accrued Interest Due from Other Governments Sales Tax State Income Tax Court Fines Due from Other Funds _ Other Assets Total Assets LIABILITIES AND -FUND BALANCE Liabilities Accounts Payable Accrued Payroll Compensated Absences Payable Due to Other Funds Other Payables Deferred Property Taxes Total Liabilities Fund Balance Unreserved Designated for Capital Improvements Undesignated Total Fund Balance Total Liabilities and Fund Balance See accompanying Notes to the Financial Statements. 1986 1985 $3,147,158 $2,308,177 387,765 396,287 59,135 29,162 115,419 101,043 42,217 43,958 26,372 35,203 354 140,380 58,282 27,479 cz QIA 7n1) cq nQ1 400 $ 143,792 $ 58,417 26,772 18,674 231,513 223,639 51,416 47,716 5,600 14,891 420,000 420,000 $ 879,093 $ 783,337 $1,422,000 — 1,535,609 $2,298,352 $2,957,609 $2,298,352 $3,836,702 $3,081,689 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 April 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 r 1 1 1 1 1 1 1 1 1 1 i 1 1 1 1 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 Charges for Services Special Police Services Transfer Charges Engineering Charges Fines and Forfeits Miscellaneous False Alarms Sale of Materials Sale of Automobiles Rentals Interest - Miscellaneous Franchise Fees 0 $ 26,721 $ 23,4061 $ 40,000 $ 33,704 ° 36,000 36,000 10,000 2,568 $ 86,000 $ 72,272 $ 180,000 $ 389,552 $ 20,000 $ 39,27W 1,8091 24,000 • 30,000 39,206- 175,000 289,781- 6,000 31,697% 70,000 92,3810 $ 301,000 $ 518,144 Cl 1RI 991 Al ARI 1AQ 37 VILLAGE OF DEERFIELD, ILLINOIS 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 1 1 38 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND STATEMENT OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30. 1986 BudgetActual Public Safety Police Department Administrative Service 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 Communications 7,100 25,000 4,227 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. 1,857 Miscellaneous 6,700 1,960 $580_,271 $555,962 Investigations Salaries $102,942 $ 98,882 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 22,767 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 1,266 500 127 1,200 755 2,000 1,670 800 554 11,800 111497 $ 173,169 $ 154,753 $2,125,701 $2,022,782 $3,196,001 $3,018,112 ti SPECIAL REVENUE FUNDS 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. tEmergency 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 70 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'Fisca.l 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 gasline 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 S � N O Ln 000 n VN1 N Op 0�0�NI .�i C,4 V1 N N 00 N u � T 00 n a0 T v^i � f+in1 v� O � 0pOpp 4I M ^ N a0 n O N CO O+ O N N1 1� OO Vi O .N rd �D N w L •m n�A O� .N••1 N V1 T N ON N H1 O+JI OVf Vim} N N N N} O 1� S. a0 .r aD .•-� O Op�� O .- F �i o~ c oo a0 cO. � �N( I Ifk OI yyN uN J v L�Od 01 � tl1 � N N tll r A m s m 11 .ID C n rwi n ID 0 M �f 10 A ID P M(D ff�DD v m r• Fn N O ryry n• r Lo M N R• m' cocoV I�I III IF IWI W IVI N � m � ^ N iA Lf N p W r I O OO 10 N O� �Opo e �Opo V v+ F F F-•FN v O O N N N N� r �O F P FW-• O. ^ py r�s to <n <n rip a cn I I I I I I i � � I I IR �• N ^ N Vf iA F+ r� W� �W �ryp OD co OD O, r r. C7C ID N Ll i/f NW Np 'C�1 pvp �p ��NpO O O` O ID 1.11 v V N OD F T N 8N w OD IV -ACI O I� ININ pr• O i. i-. N N N � N ram-• pp V�i v 00 lJ� N W lFn W nV-• ONp N I W OyJ� �qi� T N N r n w pp�p pVp�pi p8N. N OWp� W pv�pi QpN� .pWpD �O pN. �V+ ppOppD ppW�� I s 117 1 1 1 1 1 1 1 1 1 1 1 1 i 1 1 42 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 Budget Actual $10,500 $11,784 10,500 See accompanying Notes to the Financial Statements. 9,875 1985 Actual $11,136 9,000 $ 1,909 $ 2,136 9,970 $11,879 7,834 $ 9,970- 43 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 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 i 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) $0 ,331) 4,000 4,000 4,000 $ 40 $ 312 $ 669 See accompanying Notes to the Financial Statements. 7,186 6,517 $ 7,498 $ 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 1986 1985 Budget Actual Actual Revenues Property Taxes - Current - (Net) $672,017 $ 593,893 $587,720 Replacement Tax 7,000 14,604 15,046 Grants 9,300 17,432 9,314 Non -Resident Fees 6,000 7,510 7,820 Fees, Fines, Penalties 30,000 45,014 34,432 Gifts 500 1,215 3,572 Reciprocal Borrowing 2,000 3,943 2,032 Xerox 20,000 19,276 20,271 Interest 10,000 35,324 41,215 Monies Allocated 95,000 Reserve for Repairs and Replacement 143,368 $995,185 $ 738,211 $721,422 Expenditures 995,185 844,890 688,145 Excess (Deficiency) of Revenues over Expenditures - $(106,679) $ 33,277 Fund Balance May 1 385,770 352,493 April 30 $ 279,091 $385,770 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 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 Actual $181,487' $171,319 241,848 218,147 13,000 21,181 5,000 10,501 4,000 4,232 8,000 6,276 6,000 7,019 17,000 8,406 600 527 39,000 23,376 50,000 22,000 18,526 100,000 79,122 20,000 19,351 13,000 15,423 1,500 872 2,300 1,437 2,000 1,085 50,000 16,076 1,050 634 22,000 6,521 400 1,224 95,000 74,645 100,000 138,990 $995,185 $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 1986 Budget Actual Revenues Property Taxes - Current - (Net) $220,000 $231,940 Property Taxes - Prior 8,000 Vehicle Licenses 260,000 266,624 Other Taxes 150,000 146,000 State Highway Maintenance 16,000 8,187 50/50 Sidewalk and Curb 25,000 11,057 Miscellaneous 5,000 4,299 Train Station Maintenance 1,500 1,500 Interest 10,000 5,741 $695,500 $675,348 Expenditures - Public Works Administration $ 79,820 $ 93,165 Cleaning 29,465 35,748 Traffic Marking 40,410 37,698 Pavement Patching 80,440 81,199 Tarring Cracks 45,650 43,667 Drainage Structure 14,230 15,162 Street Lights and Traffic Signals 96,945 106,883 Miscellaneous Maintenance 71,365 51,823 Snow and Ice Control 128,340 113,153 Weed Control 13,840 13,592 Leaf Removal 11,265 16,102 Tree Removal 24,265 22,817 Tree Planting 12,470 8,446 Railroad Station Maintenance 34,085 22,984 $682,590 $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 Excess (Deficiency) of Revenues and Other Sources over Expenditures and Other Uses $ (90) $ 32,909 Fund Balance May 1 (1,770) April 30 $ 31,139 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 $(40,180) 38,410 $ (1,770) See accompanying Notes to the Financial Statements. 48 ' 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 Administration Salaries $30,540 $35,882 Overtime 700 3,328 Employee Benefits 2,400 4,185 Professional Services 2,200 267 Travel, Training and Dues 800 988 Printing and Advertising 4,400 874 ' Communications 3,900 1,644 Insurance 22,240 31,396 ' Motor Vehicle Maintenance Miscellaneous 2,000 2,200 3,664 2,909 Supplies 3,000 4,191 Motor Vehicle Supplies 1,200 1,102 ' Apparel 1,540 1,321 Repairs and Maintenance 1,500 81 Contractual 1,200 720 Small Tools and Equipment 613 ' $79,820 $931,165 Cleaning Salaries $11,025 $11,102 Overtime 500 1,032 Employee Benefits 1,440 1,152 Small Tools and Equipment 500 70 Contractual 3,500 3,689 Motor Vehicle Maintenance 4,000 1,775 Repairs and Maintenance 5,500 13,803 Equipment Rental 500 Motor Vehicle Supplies 1,500 1,496 Supplies 1,000 1,629 $29,465 $35,748 Traffic Marking ' Salaries $13,350 $ 8,913 Overtime 300 67 Part -Time 2,520 2,391 Employee Benefits 1,440 945 ' Motor Vehicle Maintenance 1,000 262 Repairs and Maintenance 800 1,270 Motor Vehicle Supplies 500 73 Materials 4,000 4,681 Street Signs 6,500 5,353 Contractual 10,000 13,743 $40,410 $37,698 49 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,667 $ 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 1 1 I 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 14,757 $ 96,945 $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 300 517 Miscellaneous 500 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 5,300 2,758 Salt 32,000 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 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 52 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.) Railroad Station Maintenance Salaries $ 5,845 $ 5,427 Overtime 900 130 Part -Time 3,600 3,546 Employee Benefits 720 618 Repairs and Maintenance 2,400 3,426 Supplies 1,500 61 7,900 7,900 8,300 1,876 2,420 Aggregates 500 $ 34,085 $ 22,984 Total Expenditures $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 1986 1985 Budget Actual Actual Revenues Property Taxes - Current - (Net) $300,000 $271,808 $233,152 Replacement Taxes 6,000 6,047 6,230 Interest Earnings 8,000 8,815 18,637 $314,000 $286,670 $258,019 Expenditures Illinois Municipal Retirement Payments - Employer 305,000 296,313 261,325 Excess (Deficiency) of Revenues over Expenditures $ 9,000 $ (9,643) $ (3,306) Fund Balance May 1 (5,415) (2,109) April 30 $(15,058) $ (5,415) See accompanying Notes to the Financial Statements. 54 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 1985 Budget Actual Actual Revenues Property Taxes - Current - (Net) - - $10,143 Expenditures Contractual - - 18,945 Excess (Deficiency) of Revenues over Expenditures - - $(8,802) Fund Balance May 1 $61,273 70,075 April 30 $61,273 $61,273 See accompanying Notes to the Financial Statements. F61 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) (1651088) $ (80,000) $ (60,573) $ (54,093) See accompanying Notes to the Financial Statements. 172,513 226,606 $ 111,940 $ 172,513 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS MOTOR FUEL TAX FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Revenues Allotments Earned Interest Other Expenditures Street Maintenance Street Resurfacing and Renovation Program Reconstruction Wilmot Road - Lake Cook to Deerfield Other - Resurfacing Deerfield Road Excess (Deficiency) of Revenues ,over Expenditures Fund Balance May 1 April 30 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 $150,000 $146,001 $195,'776 105,000 52,394 15,000 81,532 16,183 22,000 25,273 $292,000 $279,927 $237,232 $ 13,723 $ 27,405 $ 75,534 See accompanying Notes to the Financial Statements. 228,940 153,406 $256,345 $228,940 56 VILLAGE OF DEERFIELD, ILLINOIS TRANSPORTATION PROGRAM FUND 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 I 7 DEBT SERVICE FUNDS 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. 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. 1 E CAPITAL PROJECT FUNDS 1 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. I .E 1 1 i 1 1 1 1 1 1 1 1 1 1 1 1 1 1 cn ��CrO N 00 d e�1 �pp Op D r (D 4 N 1N 00� O MAD vl O .•-i ID ..i ...i dl N (? N 0 v cn Inl'1 N O N r O D, N N N N p, Ni N N N eis N m � N .� v r 00 00 N r W uCCcor ..i SRIm 'D in en a0 O .•-� N O� uN .rr " I n O� W ., p yW e+i c N �•i CO N CO 00 d N N N N N N ��pp W q�p, •i+ �D � �D T e�1 ..qy� �D .Q••�i Cppp V1 N r en N UN -co 06 en w G N N (fn? Vl N eN? N V e�1 In N to cn en U W Vf ~ VT to Q> N •C •N �CDp �oDp �aDp loop W v A � � 5 w u � W � •qN W N � � N N �� G m b P+ i W •�. �s N �aIli � N cC5+9 c$�28 � cir 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 19 �'• "' n N •f O N A O r P. 1� 7 11 w bjs�rw^, on�R�N 0 f6'~K o., R�'da� Rrn C fD h•• N 7 In'r c• C N M r• �(pp r� C, G H r �wT S fD n' �•1 � f� GQ n (2p P' N � r• N O• {p~ �Gp N py,{ r, • ^rry�n p rn M (p p � R N m N Ij �n v In r• W vo N OV V I yp� v W O N �p N pp�� � b� yF1 INJ� p m y w 8 Pf N yN�� F yN�� l� OND vVi ppF W n•. fF•. �{Wp� pOypD1 „ n h7M l7ftD iG pi v L� 00 F• -to iA N ^ ^ N N i/f y y r9C� �••' N ❑p pW� OD pW� pN N 1 pN N pN� N W N t2 m' pOrpD � T T T N ip N N iA N T .- W W O O v V N N E VV1 lull Q! ^~ N 1 1 F 1 •`nCF33y. v n.. v v r 4D R N41 O � N P. N �G ram•• F F pp O� NNN V �n W W O �W-• � 10 Oy f� Fw.. N V1 iA W W F N iA N N to y N � T N N O O o-N•. 1.11 1VJ1 �D MW.' pp (vi N ��p � O cr, 8� Li N�� `p W V F N N SPECIAL ASSESSMENT FUNDS I Special Assessment Funds Fund Descriptions 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 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 setup in 1975 to account for the collec- tion and disbursement of funds for the construction of concrete pavement, curb and gutter, sidewalks and a drainage system where necessary along portions of Gordon Terrace and Kenmore. Special Assessment 113 - 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. .1 62 N ON 00 m 8 cn •-i Ln 0, 8 t!1 � O 00 000 000 O Uf1 10 �1 O00 tt N co co H O�' M oO W. O -,CIO'.' �I ^ O N ONO M N N O M N t� C Ln ul to oco �.... o rn (J� o o N N tP1 bl% t!1 0�0 0�0 O 000 O O OO ONO enON n L tb fn N r-I to N y y N -WP4 14 rn 0 a rn ro -4 n (r.-) �rtpp ►t �- O. N 5��y � Pi R CA r N � m O fD i�h R 2 to � Gd ppr • y � A • fA R � {Q G� m .4 ' (D (Q� (nrT a hh O R rt •G7 iD • ' f� w• R w rt y O N N V 00 00 00 C7, V �O11 1 1--• 1�r Fes•+ � O � W W 1--• F-• �ONv N Nj N Iw O� O r• -4 N (�--• N % 00 � N •t/> to �O TWO I w W OO 00 O v O W W W T N � I00 Qr �pNpp v ' O R w -CO -tn r w WN %0 N 00�-- �p £ W LO cr.7vlJ S v ' £9 11 1 1 I PROPRIETARY FUND TYPES 1 �J 1 ENTERPRISE FUNDS li 7— L 1 i . I Fund Descriptions 1,1�+.,- C-A The Water Fund accounts for all activity necessary to providewater to the residents of the Village of Deerfield i.ncluding 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 incl.uding, but not limited to, administration,.construction, maintenance, and operation of the Sewage Treatment Plant. Deface Curd 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 VILLAGE OF DEERFIU D, ILLINOIS ' EM1PRISE FUNDS COMBINING BALANCE SEM APRIL 30, 19% Oamniter ' Parkirg Totals Water Sewerage Refuse Lot 1986 1985 ASSETS Current Assets Cash and Investments $ 521,276 $ 656,939 $ 79,869 $118,203 $1,376,287 $ 953,294 Rece ivables Accounts 248,904 139,730 90,243 478,877 501,478 Property Tawas 360,067 360,067 339,674 Accrued Interest 4,747 713 5,460 14,656 Other 33,536 33,536 2,587 Due fran Other Funds 4,760 Inventory 41,213 41,213 33,887 $ 844,929 $ 801,416 $530,892 $118,203 $2,295,440 $1,850,336 Rbstricted Assets Cash and Investments $ 88,708 $ 116,345 $ 205,053 $ 205,053 Fixed Assets - 1*-�t $ 486,597 $4,961,721 $478,754 $5,927,072 $6,107,051 Total Assets $1,420,234 $5,879,482 $530,892 $596,957 $8,427,565 $81162,440 LIABILITIES AND FUND EQUITY Current Liabilities Accounts Payable $ 88,622 $ 54,412 $ 67,578 $ 623 $ 211,235 $ 177,400 ' Compensated Absences Payable 15,881 42,178 967 59,026 49,538 We to Other Funds 917 1,501 3,559 5,977 32,680 Other Payables 31,413 7,513 500 39,426 5,596 $ 136,833 $ 105,604 $ 71,137 $ 2,090 $ 315,664 $ 265,214 long -Term Liabilities Bonds Payable 135,000 135,000 175,000 Total Liabilities $ 271,833 $ 105,604 $ 71,137 $ 2,090 $ 450,664 $ 440,214 Fund Equity Contributed Capital $5,616,761 $626,240 $6,243,001 $6,243,001 lbtained Earnings Reserved - Restricted Accounts $ 88,708 $ 116,345 $ 205,053 $ 265,053 ' Unreserved 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 Flail Equity $1,148,401 $5,773,878 $459,755 $594,867 $7,976,901 $7,722,226 Total liabilties and Rind Equity $1,420,234 $5,879,482 $530,892 $596,957 $8,427,565 $8,162,440 1 See accompanying lbtes to the Financial Statements. 65 1 V11 AGE OF DEERFIE[D, IlLimIS COMBINING SPAIIIKZT OF REVENUES, EWENSES, AND CHANCES IN RETAINED EARNINGS - UNRESERVED FOR THE YEAR ENDED APRIL 30, 1986 Operating Revenues Onarges for Services Water Sales Sewer Charges Refuse Billings Surcharges Miscellaneous Total Operating Revenues Operating Expenses Excluding Depreciation Administration Operations Total Operating Expenses Operating Incase (loss) before Depreciation Depreciation Operating Income (loss) Ibnoperating Revenues (Expenses) Interest Earned Property Taxes Interest Expense Net Income Before Other Financing (Uses) Other Financing (Uses) Operating ltansfers (Out) Street and Bridge Find Net Incase and Other Financing Uses Retained Earnings - Unreserved . May 1 April 30 See acca%mying Notes to the Financial Statements. Comwter 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) 1 Totals 1986 1985 $1,360,193 $1,231,009 880,600 627,984 439,07.8 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) (9,000) $ 486,865 $ 452,559 $ 274,675 $ 198,799 1 $ (20,000) (20,000) $ 254,675 178,799 $ 1,274,172 1,095,373 $1,528,847 $1,274,172 I� �i 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ON Ln Ln 00 n M OI 00I,%0M OO .r � N " N Ln t/} 00 I CT 0000 Ln N a, n ONO M n N N C.',�O ►1�©Cri`. N N p� N N � A ppMpp V1 � CYN �t w M Ln CltLn w GOON � N OHO N N � U1CY)�OO�ON�O OMi N ON a% 00 0 G 3.s � ..� u i hL r O O r4 'W L y N s� �a � .c +: aa) Z" O i!1 Ln n p0pp M ^ M O% .-i M -4 �.r � pS00c�1 ON -- Lr (6 N T N N C-4 't �0 <rp- V>- 00 u'�Lr% N .-i cl N N N t/r <? t/} t! 1 W) O N of 00 rn rn cn 1- 00 Ln u"1 011 —4 8 O en ENO w 0% n M %0 M ON�w N o0pp �Y�700 �ppp O cn N qC O .4 66 67 VILLAGE OF DEERFIELD, ILLINOIS WATER FUND BALANCE SHEET APRIL 30, 1986 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 $1,420,234 $1,218,340 LIABILITIES AND FUND EOUITY Current Liabilities 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 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. C- 3 1 F 11 t 11 VILLAGE OF DEERFIELD, ILLINOIS STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - UNRESERVED - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Operating Revenues Charges for Services Water Sales Permits and Fees Penalties Miscellaneous Operating Expenses Excluding Depreciation Administration Operations Distribution Maintenance - Mains and Fire Hydrants Maintenance - Meters 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 1986 Budget Actual 1985 Actual $1,080,000 $1,360,193 $1,231,009 20,000 36,868 31,146 13,000 18,005 15,714 1,000 5,514 32 $1;114,000 $1,420,580 $1,277,901 $ 100,430 $ 103,619 $ 108,897 1,236,990 958,026 737,818 120,030 99,138 110,572 52,380 42,717 46,879 $1,509,830 $1,203,500 $1,004,166 $ (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) $ 192,345 $ 253,376 CX=867,=34 613,972 $1,059,693 $ 867048 See accompanying Notes to the Financial Statements. 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 Travel, Training and Dues Printing and Advertising Communications Contractual Insurance Motor Vehicle Maintenance Miscellaneous Supplies Motor Vehicle Supplies 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 Repairs and Maintenance Miscellaneous Purchase of Water Supplies Motor Vehicle Supplies Chlorine Materials. Equipment Less Amount Capitalized Budget $ 47,400 3,900 2,200 300 700 5,630 500 22,970 1,200 300 500 600 12,000 1,430 3 5, 000 800 $ 135,430 35,000 $ 100,430 $ 26,550 1,050 2,870 1,300 1,050 9,100 76,870 1,200 3,000. 1,300 1,110,000 500 600 400 1,200 1,500 $1,238,490 1,500 $1,236,990 , 69 Actual $ 48,588 5,467 145 i 376 6,309 147 23,606 1,491 2,155 754 1,207 12,000 1,374 40,000 $143, 619 40,000 $103,619 $ 26,440 3,912 308 2,777 405 8,846 61,491 3,341 3,705 1,416 841,064 1,457 1,188 427 1,249 1,576 $959,602 1,576 $958,026 i 1 70 1 e r 1 1 vi VILLAGE OF DEERFIELD, ILLINOIS 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 1 71 VILLAGE OF DEERFIELD, ILLINOIS STATEMENT OF FIXED ASSETS AND DEPRECIATION FOR THE YEAR ENDED APRIL 30, 1986 Water System Equipment and Automotive Water System Equipment and Automotive Net Asset Value Assets Balances Balances May 1, 1985 Additions Deletions April 30, 1986 $ 785,215 $ . 785,215 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 $445,288 $19,630 92,946 30,302 $538,234 $49,932 $464,918 123,248 $588,166 $486,597 72 1 1 1 1 1 1 1 1 1 1 1 1 1 1 r VILLAGE OF DEERFIELD, ILLINOIS SEWERAGE FUND BALANCE SHEET APRIL 30, 1986 1986 1985 ASSETS Current Assets Cash and Investments $ 656,939 $ 503,844 Receivables Accounts - Billed 24,569 29,622 - Unbilled 115,161 92,532 Accrued Interest 4,747 2,696 $ 801,416 $ 628,694 Restricted Assets Cash and Investments $ 116,345 $ 116,345 Fixed Assets Cost $6,161,562 $6,107,144 Accumulated Depreciation 1,199,841 997,613 $4,961,721 $5,109,531 Total Assets $5,879,482 $5,854,570 LIABILITIES AND FUND EQUITY Current Liabilities Accounts Payable $ 54,412 $ 49,782 Other Payables 7,513 3,969 Compensated Absences Payable 42,178 24,828 Due to Other Funds 1,501 10,320 Total Liabilities $ 105,604 $ 88,899 Fund Equity Contributed Capital $5,616,761 $5,616,761 Retained Earnings Reserved - Restricted Accounts $ 116,345 $ 116,345 Unreserved 40,772 32,565 Total Retained Earnings $ 157,117 $ 148,910 Total Fund Equity $5,773,878 $5,765,671 Total Liabilities and Fund Equity $5,879,482 $5,854,570 See accompanying Notes to the Financial Statements. 73 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 Sever 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 - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 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 100 Communications 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 $107,150 695 $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,217 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 j 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 Depreciation 64,000 68,500 22,512 202,228 $636,250 $718,224 Less Amount Capitalized 67,000 227,926 $569,250 $490,298 1 VILLAGE OF DEERFIELD, ILLINOIS SEWERAGE FUND STATEMENT OF OPERATING EXPENSES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Operations (Cont.) Cleaning and Maintenance Salaries Overtime Part -Time' Employee Benefits Contractual Services Motor Vehicle Maintenance Repairs and Maintenance Equipment Rental Miscellaneous Supplies Motor Vehicle Supplies Aggregates Materials Equipment Small Tools and Equipment Less Amount Capitalized Construction Salaries Overtime Part -Time Employee Benefits Contractual Services Motor Vehicle Maintenance Repairs and Maintenance Equipment Rental Supplies Motor Vehicle Supplies Aggregates Materials Small Tools and Equipment Motor Vehicles Less Amount Capitalized Total Expenses Budget $ 45,530 4,200 2,340 5,720 10,000 4,000 5,000 3,000 2,000 16,100 1,500 1,000 7,000 3,000 300 $110,690 3,000 $107,690 $ 70,890 2,000 1,170 8,630 5,000 5,500 7,500 1,000 2,000. 2,000 5,000 14,000 200 16,000 $140,890 16,000 $124,890 $908,980 75 Actual $ 61,300 3,071 2,304 6,123 6,088 3,246 1,079 413 5,192 1,736 334 14,700 467 $106,053 $106,053 $ 77,324 1,175 1,245 7,791 11,685 4,125 1,076 2,383 5,511 11,359 98 14,804 $138,576 14,804 $123,772 $854,717 1 1 1 1 1 F I 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 190,082 17,983 $6,107,144 $ 54,418 $5,953,497 208,065 $6,161,562 Accumulated Depreciation Balances Balances May 1, 1985 Provisions Deletions April 30, 1986 $ 930,615 66,998 Q 007 91Z $172,064 30,164 $202,228 $1,102,679 97,162 $1,199,841 $4,961,721 77 VILLAGE OF DEERFIELD, ILLINOIS REFUSE FUND BALANCE SHEET APRIL 30. 1986 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 1 1 1 1 1 1 t 1 1 1 1 1 1 1 1 1 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 Apr i 1 30 1986 Budget Actual $ 432,000 $ 439,028 $ 12,000 3,000 815,000 $ 830,000 $ 12,000 1,101 797,134 $ 810,235 1985 Actual $ 433,645 $ 12,000 1,012 765,376 $ 778,388 $(398,000) $(371,207) $(344,743) $ 91000 $ 11,517 $ 16,694 390,000 390,000 360,000 9,219 4,382 $ 399,000 $ 410,736 $_ 381,076 $ 1,000 $ 39,529 $ 36,333 420,226 383,893 $ 459,755 $ 420,226 See accompanying Notes to the Financial Statements. 79 VILLAGE OF DEERFIELD, ILLINOIS COMMUTER PARKING LOT FUND BALANCE SHEET APRIL 30, 1986 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 See accompanying Notes to the Financial Statements. 1986 1985 $ 118,203 $ 94,669 $ 691,458 $691,458 (212,704) (182,006) $ 478,754 $509,452 $ 5962957 $604,121 $ 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 1 1 1 1 1 1 1 1 1 1 i 1 1 1 1 1 i 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 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 Budget Actual 1985 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 Utility 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 i 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS COMMUTER PARKING LOT 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 Land $ 77,500 $ 77,500 Parking Lot 613,958 613,958 $691,458 - - $691,458 Parking Lot Net Asset Value Accumulated Depreciation Balances Balances May 1, 1985 Provisions Deletions April 30, 1985 $182,006 $30,698 $182,006 $30,698 - $212,704 $212,704 $478,754 IFund 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. ,f: 11 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 83 84 VILLAGE OF DEERFIELD, ILLINOIS GARAGE FUND 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 1985 Actual $148,300 $128,562 $139,699 131,850 143,129 143,731 $ 16,450 $(14,567) $ (4,032) See accompanying Notes to the Financial Statements. 31,228 $ 16,661 35,260 $ 31,228 85 VILLAGE OF DEERFIELD, ILLINOIS 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 $04,526) $0,687) 7,282 12,969 $ (7,244) $ 7,282 VILLAGE OF DEERFIELD, ILLINOIS STATEMENT OF OPERATING EXPENSES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1986 Budget Operations Public Works Department Salaries $ 56,900 Overtime 5,000 .Employee Benefits 5,740 Apparel 450 Travel, Training and Dues 500 Printing and Advertising 350 Insurance 3,090 Miscellaneous 200 Professional Services 50 Utility Services 1,300 Repairs and Maintenance 5,000 Supplies 45,100 Motor Vehicle Supplies 800 Equipment 5,000 Communications 370 Materials 500 Small Tools and Equipment 1,500 $131,850 86 ' Actual , $ 59,513 ' 5,811 6,277 334 ,98 54 4,081 ' 48 800 ; 4,095 54,381 445 4,404 ' 801 333 1,654 , $143,129 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 FIDUCIARY FUND TYPES 1 1 ' TRUST AND AGENCY FUNDS IFund Descriptions ' Police Pension Fund The Police Pension Fund is used to account for the resources necessary to 1 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. 87 t 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 M rn � co O% •-•c O% a\ M •--c N —4 00 N 00 ON —1 O -4 .-1 ..r r\ 10 �t N O M V1 It 00 t` —4 M ul T ON N r\ r` 00 L' - t M C� •-: ; t!•1 O Ln r` 00 C ON I r\ It m 1* U"% cn 00 rn r-c N N N N C 41 ' 0 V>. V} v} V} VT v t/Y t/)- 1J O H 00 Z 00 r` 00 M 00 m 00 O 00 N M to O• 4 CO) 10 O N ON to N M CO) — M M — N •--i O� V1 cn N n Lr 00 N . -4 —4 00 —40 O\ 0000 1 n M V1 f\ u1 00 lO 00 r` 00 cn M It M M y u 1 N --i 00 M . 4 —4 u y 00 O N M O O NO I r` _ •-•, O 0 O O � A v> u} v} Vt v} CA H O .. z E•c M %0 00 m %O tl0 00 co O 00 %0 H CA W 00 M U"� 00 %0 - N N V1 N M %O a A W C N C N cl)MO O tocn Nr- cn O az x O u0 m C H m r+ Ln p n M L1 r, r` m 14 Ln —4 -4 r` aD w A >+ U 0C i H PO+ CCi aU z•4 a a M M .t M M w z Q v> u} v> </s yr v> yr H w a r=a ca Q O a Q on M wA c.7a A z iz i � O H H Q i � A C wU' O O O4 Q H U d a a H a� V1 W rd >+ N cd u •4 L co C .. C co `° z w 14 b 1 w s+ O z w L w L $4 Q N V1 c $4 Um O A rn C N .61 :.j C I .61p O N Cl 0 w 0. .4 u z to N 0 7 rZ- •� .-i C .,4 w PO 0� c co ,4 .tea C O (Ak u H v z co>+ • C/3 O) cc .61 (1)rd Q 0 c0 O 0 cn 0 C cc >, Q > H C .0 w P. 4 •,4 W w b C 4 C C cn H L rn v, � a u v P4 '.a H (, >% o w m rn w o C •C .-4 iW •b -4 1-1 •ra JJ L .-4 Cd Cl W .-4 r4 t7 A w d co E-H .6J C. 4 O cb .-4 > w m cU O C CO C) C ►+ O L H •r4 = rA L .6j 0 L W L :J u cv > a. H w w O a �4 0 0 0 rn u W 0 o u •4 O u .0 w H H •.+ u a. d H rn w H H c0 N w u «+ rn A U N C C Cl C w u04 0 a) Q co gm COGC7 u z c'S a a rZ4 rn 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 1986 1985 Budget Actual Actual $165,000 $ 165,000 $ 150,000 3,972 1,230 4,000 4,751 4,895 $169,000 $ 173,723 $ 156,125 340,000 361,378 315,417 95,000 97,525 75,750 $604,000 $ 632,626 $ 547,292 $ 70,000 $ 67,873 $ 65,912 500 937 25 $ 70,500 $ 68,810 $ 65,937 $533,500 $ 563,816 $ 481,355 See accompanying Notes to the Financial Statements. 3,208,722 2,727,367 $3,772,538 $3,208,722 89 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 Balances Balances May 1, 1985 Increase Decrease April 30, 1986 ASSETS Cash and Investments $ 6,488 $61,357 $67,845 Other Assets 44,491 $43,479 1,012 Due from Other Funds 1,214 1,214 Total Assets $50,979 $62,571 $43,479 $70,071 LIABILITIES 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 1 1 1 1 ACCO UNT GROUPS 1 1 �1 h GENERAL FIXED ASSETS ACCOUNT GROUP 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 GENERAL FIXED ASSETS ACCOUNT GROUP To account for fixed assets not used in proprietary fund operations or accounted for in trust funds. 0 91 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FIXED ASSETS ACCOUNT GROUP STATEMENT OF GENERAL FIXED ASSETS APRIL 30, 1986 GENERAL FIXED ASSETS Land $1,915,310 Buildings and Improvements 1,237,500 Vehicles 371,100 Equipment 1,022,710 $4,546,620 INVESTMENT IN GENERAL FIXED ASSETS General Revenues $2,646,620 General Obligation Bonds 1,500,000 Installment Contracts 400,000 $4,546,620 See accompanying Notes to the Financial Statements. pt G G & � C CJ p r r+ M n r• r• n rt n n w r• r 0 0 w o x co < � m rTa � A fD rt O H. rt C r r In r4 ON O I a to 4- w v, i-• 4.1 N O N O 00 ►" 9 GO 'l7 G N .D N r'1 r• w .o �- N 0 w V .o v+ N CfD a a a• r• O UO O .vie %.n M O O O p p fA rt y -(Al to C W N fp %.n V N w 00 .n 00 r• n oo .o w r N V p m W N .o N !A o N l-I V O r• O. o Q` .o 00 w .o rn co V W W rt H v+ v o O V fT O• O. V N W v �+ a• w v ", W O V p W fi7 CrJ ra r-� xo id arrj En sl En 'Jd Cl7 ml cn t� ad n� O cr zr H H z 00 7d 04 O cn C rd 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 Balances 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 1 1 1 1 1 1 1 1 1 GENERAL LONG TERM DEBT ACCOUNT GROUP 11 ' General Long -Term Debt Account Group ' To account for the long-term portion of the Village's Bond Issues and Installment Contracts. 1 94 1 1 1 1 1 1 1 1 1 1 1 1 n N co 8O 8�80 8O F cn 6 O C O en an v� SO ep ti N cn1 en K en K u K K w o Ll rn ,°� e°R Q 25 5Q� 25 .cc V O 'vC u C 0 10 m. w 00 .N-i co O O O •� C~! to O O O G.7 PG O N K OND en K to VO1 p O 0) N d S 8 8 K O cn 5 5,9I N N W G O tCl If oC g O F+ u u N N Juj 09 11 SUPPLEMENTARY DATA 95 11 .n•� N O 00 T N N A Ol pl 10 Go .r Op fp fp M M n �p (M� 00 0, S 00 V1 O� O M �7 W fT �r N O n .nr v .fir NO N f? f? .r t? .--� f? M N �1 N N f? .•-� N (? m u � .�.� p N � 00 oOCn O� �Dl N f0'1 vn1 M O O� aNO 00 ON •N7 co ti .N-� fD 00 O� M 'O fT M d M Ono N 00 n " v M q0 .-r O N OQ4 M T OD pp h n J M Vpp} f? N .•r f? .n N N7 .� O� all f/i 01, .-� N (? u t+1 pp p M N N O N p�}p N Q� 8 n en co C O� Od M M �O O.O -: �O M M h tT O 00 M O h N O %O O N N n p CO N .r .•-� N ..•1 N �D .•� fT N (? N u ^ co p %D Ti 00 �O N .N•� N V} VY f/} .N.i qY N pp •� hq v .�Ni f/Y 1+1 N M N v (h N N cl� 11 v s N N fd N sod O7 Z .mmL L aO � n I� y A W -E Cd�i M CD �u1Nr- cn tip aO T W u �v�o v v QEE N V N pY .d .Oi 4f a0 N .� Qw6 N n di q C O O � L a 6L1 cn ki'l R.1 1§1 00 O Opp V1 � v� t!� fn %0 (T f? f? N O O_I M N V1jl I u ..Va m u C C C u VI N cPl � 'fpctp � $pp •°' � U PLO fC CJ C3 Ell C 3 fi� C7 N mm"4 �O N S 8I N �O O O n A m u m a~O y •.7 m V}II W O A�I a � c m u 8 N �y u Td � m m C v .� > S 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 i 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 $ 161,754 7.585 12/26/86 1,000,581 6.875 5/07/86 300,000 8.050 10/02/86 2,000,000 7.375 7/07/86 1,000,000 8.625 1/06/88 1,000,000 8.625 1/06/87 1,000,000 $6,462,335 7.750 10/30/86 $ 200,000 7.175 10/27/86 200,000 7.175 11/10/86 250,000 8.500 10/30/86 300,000 8.200 3/23/87 400,000 1,350,000 $9,661,675 $ 98,433 7.125 10/14/86 175,000 7.650 9/09/86 100,000 6.750 6/27/86 200,000 $ 573,433 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 c,)n »u liq 101 11 11 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.4%-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 Bond Numbers 191-215 216-240 241-265 266-296 297-315 316-340 341-370 371-400 Tax Levy 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 Year Principal Interest Total 1984 $ 22,750 $ 22,750 1985 $ 125,000 42,563 167,563 1986 125,000 36,625 161,625 1987 125,000 30,562 155,562 1988 125,000 24,375 149,375 1989 125,000 18,125 143,125 1990 150,000 11,250 161,250 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 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 103 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 45500 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 I PRINCIPAL AND INTEREST REQUIREMENTS 1 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 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 Tax Levy Year 1985 1986 1987 1988 1989 1990 1991 1992 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 Coupons Due on Principal Interest Total June 1 Amount Dec. 1 Amount $ 50,000 $ 32,250 $ 82,250 1986 $ 16,125 1986 $ 16,125 50,000 28,750 78,750 1987 14,375 1987 14,375 50,000 24,750 74,750 1988 12,375 1988 12,375 50,000 20,750 70,750 1989 10,375 1989 10,375 50,000 16,750 66,750 1990 8,375 1990 .8,375 50,000 12,750 62,750 1991 6,375 1991 6,375 50,000 8,500 58,500 1992 4,250 1992 4,250 50,000 4,250 54,250 1993 2,125 1993 2,125 $400,000 $148,750 $548,750 $ 74,375 $ 74,375 106 ' VILLAGE OF DEERFIELD, ILLINOIS ' LONG-TERM DEBT REQUIREMENTS GENERAL OBLIGATION VARIABLE RATE DEMAND BONDS APRIL 30, 1986 Date of Issue December 17, 1984 December 30, 1985 Authorized Issue $4,100,000 $6,900,000 Actual Issue $4,100,000 $6,900,000 Denomination $ 100,000 $ 100,000 Interest Rate Variable Variable Payable at LaSalle National Bank LaSalle National Bank SERIES OF 1984 PRINCIPAL AND INTEREST REQUIREMENTS Fiscal Year Ended Available For April 30 Principal Interest Total 1987 $4,100,000 $24,000 $4,140,000 SERIES OF 1985 PRINCIPAL AND INTEREST REQUIREMENTS Fiscal Year Ended Available For April 30 Principal Interest Total 1987 $6,900,000 $40,873 $6,969,000 The $4,100,000 and $6,900,000 Variable Rate Demand Bond Issues were called on May 15, 1986. 107 1 1 1 1 1 1 l 1 1 1 1 1 1 1 1 1 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 109 Date of Issue Date of Maturity Actual Issue Denomination of Bonds Interest Rates Interest Dates Principal Maturity Date Payable at VILLAGE OF DEERFIELD, ILLINOIS LONG-TERM DEBT REQUIREMENTS WATER REVENUE BOND SERIES OF 1959 APRIL 30, 1986 April 1, 1959 May 1, 1989 $545,000 1-545 @ $1,000 5% - 4.25% November 1 - May 1 May 1 LaSalle National Bank Chicago PRINCIPAL AND INTEREST REQUIREMENTS Year Bond Ended Numbers Principal Interest 1987 441-475 $ 35,000 $ 4,462 1988 476-510 35,000 2,976 1989 511-545 35,000 1,488 $105,000 $ 8,926 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 1 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 42656.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 Rase 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 2,653.07 26,904.07 2163 Hilary Jenkins 2250 Larry Kick 28,691 2,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 2,653.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 39830.54 29,793.54 3150 John Sliozis 16,561 3,148.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 3,141.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 111 VILLAGE OF DEERFIELD, ILLINOIS STATEMENT OF INSURANCE IN FORCE APRIL 30, 1986 Insureds Description of Coverage Village of Deerfield Workmens Compensation Statutory/ $10,000,000 Village of Deefield Comprehensive Automobile Liability Bodily Injury and Property $1,000,000 Village of Deerfield General Liability $1,000,000 Village of Deerfield Blanket Building and Contents $30,000,000 Village of Deerfield Boiler and Machinery $10,000 Public Officials Blanket Bond Coverage $10,000/ $1,000,000 1 I Statistical Section I 112 o r %0 %0 o r- A R $ q q R 01 r le � r o 3 g £ 00 $ & 2 0 g q £ q G g r $ r � � \ \ $ k /| « q r- ® � q /cnp / � E $ $ \ 2 � / 00 �| / CD k 2 k $ Ln g — _ — # — 2 cn — 8 C'! 141 � 3 / q %0 $ k G k 0 3 r r —| m # 4 — R V> / \ / / / 2 $ / & q 2 $ § . — cl � kcn \ � $ k Ln /|00 � E # q 3 k 3 ƒ / � £ a| r 3 � g q n $ q r q o / \ /| 2 % q \ / � g . § ra � � § \ S 3 ® j / \ a / / § 44 � $ 2 gMV CA A $ p10 2 _ 7 ) � k % r 2 7 / mW. I7 R' 2 2 � � � 4j> OD / \ w . /00 / W. q ƒ O i w L.) o w / % |00 00 $ S $ $ — G % � w a » w � 2 G % w k � |/ _. � \ / ƒ k 3 / |� Ij A w -4 -4 7 (� # 8 / 0 $ � 3 0 LI) |K A w A / v |/ w w � k |� � � k k & J $ � � w |/ w R k \ ƒ % . co / / ¥ p w |k / G k / \ k co � EII 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS PROPERTY TAX ASSESSED VALUATIONS, RATES, EXTENSIONS AND COLLECTIONS LAST TEN FISCAL YEARS APRIL 30, 1986 (See Following Page) 2 \ 9 § / f 2 / w $ Q $ k 7 00 / ��&@ i (D R & � § K E � / W. ƒ 2 } $ m2 ¢ § . $ � . � ||/ Iry E_ 2 2 - G G m 3 y3�w����� 41 / % owuUn k $ w$Rw=oo-;l ||\ S2G\EkS2 / M |2 / 2 . � � w a w a o 2 $ |/ / 3 co - E ~ @ -j coc7Co —11 @ a w\�=o-%m IN |%� NO d K / � |m U -CO -1 � 0 _ 2 � -4 a S k//fk/3b w m / d K / |f / 3 2 Q> - ƒ 2 � $ ko ¢ @ + $ $: "IDn _ 2 ¥ / % K |7 / 2Soq |C* / $.��w Un -4 W � � 0aor1aw00 b/�gE@d@ n Lr) 04 Ln 0� Lr fl N N S n M Q) � � Qakiii N M %O M rl M Cn cl m c+1 Vi or V& 41 I OOS.Lr,-i0 ,III Ln M �a III in B � N N in in M .--1 � %O mI co jC v� t� vNs ' Vr oM0 �� 8 -4 n pop 88 SOLO S� N O O 00 Q� M Cl1 p}} M ���'O �N �V1 MI .M-cn pOil V> cn NON UQ M ' Cn Ln N 0 N V^1 N N n n 8I L co Iz en Ln —4 O Ul r` N O% N N �N tnccn(n —I -I N N 00 cc V m m �p .-i 0�00 ^N�+8 a%O0 t O p cn N ONO BN ON � a", Om�O O8I) Ln � t/} a.� y GL JJ v Cd �114 14111'W 1 1 114 115 VILLAGE OF DEERFIELD, ILLINOIS 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 46 9,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 1 1 1 1 1 1 1 1 1 1 1 i 1 1 1 1 1 1 g rn r- O * r- g 00 u, cn o0 Op�tcn 2VIN � �t O v'1%pMen N �7 .ON-c 1-4 N N N MtnN ON N�O --� 00 O`Dp t"DNN can �--� � •--� N N N C% M n %0 ,.p N ONOI V Wt � Wt Z8 Ln O M M ^ ,., .� cn N %O •+ N N N 00 %O O� 00 o I 00 In O^ lr1 O enN N ^� N N N �NONMN� a` �0000N cn N M nN� N ^-� N N N •"� •--� N N N CT O4 0^0 OO %O ppp v1 O pp zrZ4 �] Cli �O I n M p N cn O% O -� Ln a0 . r ( � M rM � 09 00 N n 4+ O � �p op ^� N N � • 4 N N N u u1 �O O% 00 O can n O 1 M p r` 0p L co I .-1 N I y 4 N N N 4 r-1 Vl r` N N ON O% M 00 cn to N ON � t O 10 �O - M M �t t� 4 l . ,n I •-y N N N y L L U y L aL+r co to 1+ � yy CC41 O O U N r0 eNa 7 _0 V >r v N A ."'I 1+ O op C7 rl a cti ww P4 Aj i co u oa c y cn O'+ Ol >a a 01 v a G y���8 o '� `S� o Ln 00 U '� CO)pvp L OT & W ty 14 I i c0 QAJ 4 r 1 cn O W .Y vJ C� N a ^'I� VVUU]] J�J 1v W E 4 E A O 117 VILLAGE OF DEERFIELD, ILLINOIS SPECIAL ASSESSMENT COLLECTIONS LAST TEN FISCAL YEARS APRIL 30, 1986 Fiscal Year 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 Data Source Village Records Assessments $72,003 64,952 66,386 19,436 21,919 22,078 30,451 16,248 35,075 2,400 118 \ Ln § ) « J 0 0 \ Q g A a� � / / \ ~ f| _ / / ƒ / k � � ƒ \ a, E s \ c J § / a 2ƒ 7 \ f b§ 2 § f] f\ 7 \§ %� § \ \ f 2 § \ § r N $ oo ) � § $ \ p ) k \ u'\ j \ § 2 a � o & a 119 ' VILLAGE OF DEERFIELD, ILLINOIS STATEMENT OF LEGAL DEBT MARGIN APRIL 30, 1986 Article VII, Section 6(k) of the 1970 Illinois Constitution governs computation of the legal debt margin. "The General Assembly may limit by law the amount and require refer- endum approval of debt to be incurred by home rule municipalities, payable from ad valorem property tax receipts, only in excess of the following percentages of the assessed value of its taxable property... (2) if its populations is more than 25,000 and less than 500,000 an aggregate of one percent:... indebtedness which is outstanding on the effective date (July 1, 1971) of this constitution or which is there- after approved by referendum. ..shall not be included in the foregoing percentage amounts." To date the General Assembly has set no limits for home rule municipalities. Illustrative Computation of Debt Margin if Village Were Not a Home Rule Municipality Village of Deerfield is a home rule municipality and as such has no debt limitations. If, however, the Village were a non -home rule village its available debt limit would be as follows: Assessed Valuation - Estimated Legal Debt Limit - 8.625 Amount of Debt Applicable to Limit Sewerage Improvement Bonds Sewerage Treatment Facility Bonds Corporate Purpose Bond Series 1982 Corporate Purpose Bond Series 1982-A Corporate Purpose Bond Series 1983 General Obligation Variable Rate Demand Bond Series of 1984 Police Addition Installment 1985 Contract $249,350,557 $ 21,506,500 $ 525,000 925,000 350,000 475,000 400,000 4,100,000 6,900,000 155,000 $ 13,830,000 Legal Debt Margin $ 7,676,500 1 1 1 i 1 1 1 1 1 1 1 1 1 1 1 1 120 VILLAGE 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 $ 13,830,000 100.000 $13,830,000 Cook County 399,300,000 .081 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 of property subject to taxation in overlapping unit to value of property subject to taxation. ** - Amount in column (2) multiplied by amount in column (1). (1) Office of the County Clerk (2) Office of the County Clerk 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 ili 0 r3 r. � o m a s N � r p W N I OVD N y N W N W I v In W N W � F N � IN IIW r �ypp III O N 00 IW N F N ��Fpp I� pp IIw w 00 i 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 &I § § § N N O � pp O 00 Vf Np oN 0 GOB I O O O� 1� t? N N I 1O N ol a n a, a, 0 � s co o to V} t8? 8N 8 O O �I pO J � d t? 8N O ID O JI O M_ (? 84f O O oO dl I O OOI O I. II I O N O NI p ��Npp fn en I ail n n ti .•-1 N N d t? N 122 123 VILLAGE OF DEERFIELD, ILLINOIS DEMOGRAPHIC STATISTICS LAST TEN FISCAL YEARS APRIL 30. 1986 (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 37,000 33.3 29.6 4,318 1.7 1982 17,476 39,000 34.0 29.7 4,106 2.2 1983 17,487 41,000 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 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS PROPERTY VALUE, CONSTRUCTION, AND BANK DEPOSITS LAST TEN FISCAL YEARS APRIL 30, 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 1,580,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 84 20,369,020 104 5,673,638 63,218,000 711,000,000 1984 52 12,146,201 46 5,131,160 63,877,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$18,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 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% 126 1 1 1 1 1 1 i 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 1903 Manager/Council North Suburban Chicago 3,288 11,748 18,876 17,430 1 27 1 35 7 1 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