Loading...
Village CAFR For Year Ended April 30, 1990� FINANCIAL REPORT for the year ended April. 30, 1990 i . w 1� t � I 6 REPORT for the year ended April. 30, 1990 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 -TA 'T'Ifi FOR THE FISCAL YEAR ENDED APRIL 30, 1990 PREPARED BY GEORGE J: VALENTINE FINANCE DIRECTOR VILLAGE OF DEERFIELD, ILLINOIS ..1 r - .� 1. t r «s C > tr ' ' ti �,. ; a �' t 1t [ g.` f , t / i lll�'�::�:, Y •6 n ) tt v S 1 < t I -, 1 '. A' 1 l r Y T( -1- I , , .' '. , - , . - . � , , ' — �� - ' " , ' . ,':.. '; __ � - � - ' 11 I In - "' , , - �' - I , , . I , � i d' h y a, • r t, y' I. < t .r f F ji. d [ - b- , .N L f �... z { .. 'r 9 F h 5 t y s" r ?,t t',.L- }a y. •hi r lL ^�` ^ i ,i ` 1 ` r t' r F ~ i � t -" y .. C ,, a `cX t t r fi ', VILLAGE DF I)EERF.IELD; - ILLINOIS" � ^r- f- ' ' , $ ' COMPREHENSIVE ;ti. r a .t .. r ANNUAL: � FINANCIAL REPORT t • r'' , r _,FOR -THE YEAR;ENDED, 11 . �� x s ; " APRIL`30 !1990 .. '1 j lr i 4{ I I ,, .. - 1; 1 v. Z -1 t­." . . - _�'. '�,- .' " I ':-"�"­,'.­":�""..� .. .._�;" . . '. . ". � �- ."'. � '..­%'., .;;� - -' ­ W'.'�' :' ..". i- o. y 4r C 1r,y - r t, - , :F. a ' r t+ ti, < e , j +' c, .11 _ S S ` t , `� I. h T - 1 1 t ` - V'y C �' . * „ v ' v ' `� i 6 p x .J, . r; s• ti '. 4 I t" ' Y ` 1 Y 1. 'r. S i� rr , 1 t ° t .t t �1 ..t ; -"' I . I — , I -' . '; . . , , I .1 . , 1. , I , ,j F .`, t `.., J ` ;5 r { 1 J, •` , `( . �� 1 f `t+ { f�, ` r1 v .v 11 s` z �Y. a ;� F t ` `s j +R� C '.r _ t '- 1 .Y -r V - 1. �, } ', ., J J- F , 5. 7 Ir r• ( / C ti YG;� ' ! -!. "r .� .tom _ C� (. 3 ti ;Prepared =by^ Finance = Department'•: i F 1 ..; t - 5 F .1 4l -( j n t a ', l L 1 f T t l r 1 r ;George 1J :Valentine --, _ 1. -e Finance Du�ector! IL; t (, � J, _ , , ' — - " - .1 � - -1. * , ' . " . - I . � I - . . c>, < _r , a ` y. a , a 9.• y'. . L }. 1. ! - _1 1. , �. , G } J ;. 1. 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 TABLE OF CONTENTS INTRODUCTORY SECTION Principal Officials Organization Chart Certificate of Achievement for Excellence in Financial Reporting Letter of Transmittal FINANCIAL SECTION INDEPENDENT AUDITOR'S REPORT GENERAL PURPOSE FINANCIAL STATEMENTS Combined Balance Sheet - All Fund Types and Account Groups Combined Statement of Revenues, Expenditures, and Changes in Fund Balances - All Governmental and Fiduciary (Expendable Trust) Fund Types Combined Statement of Revenues, Expenditures, and Changes in Fund Balances - Budget and Actual - General, Special Revenue, and Debt Service Fund .Types Combined Statement of Revenues., Expenses, and Changes in Retained Earnings /Fund Balances - All Proprietary and Fiduciary (Pension Trust) Fund Types Combined Statement of Changes in Financial Position - All Proprietary and Fiduciary (Pension Trust) Fund Types Notes to the Financial Statements PAGE i ii iv -xi 1 -2 3 4 5 6 7 8 -45 TABLE OF CONTENTS (CONT.) PAGE FINANCIAL SECTION (CONT.) COMBINING. INDIVIDUAL FUND, AND ACCOUNT GROUP STATEMENTS AND SCHEDULES GOVERNMENTAL FUND TYPES GENERAL FUND General Fund. Financial Statements Balance Sheet 46 Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual 47 Supplemental Schedules Schedule of Revenues - Budget and Actual 48 Schedule of Expenditures - Budget and Actual 49 -51 SPECIAL REVENUE FUNDS All Funds Financial Statements Combining Balance Sheet 52 Combining Statement of Revenues, Expenditures, and Changes in Fund Balances 53 Municipal Audit Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual 54 Emergency Services /Disaster Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual 55 Youth Bound Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual 56 1 TABLE OF CONTENTS (CONT.) FINANCIAL SECTION (CONT.) GOVERNMENTAL FUND TYPES (CONT.) SPECIAL REVENUE FUNDS (CONT.) 1'. 1 PAGE 57 58 59. 60 -64 65 66 67 68 Library Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual Supplemental Schedules Schedule of Expenditures - Budget and Actual Street and Bridge Fund Financial Statements Statement of Revenues, Expenditures, and 1 Changes in Fund Balance -.Budget and Actual Supplemental Schedules Schedule of Expenditures - Budget and Actual Illinois Municipal Retirement Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual ' Public Benefit Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual ' Motor Fuel Tax Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance - Budget and Actual Transportation Fund Financial Statements Statement of Revenues, Expenditures, and ' Changes in Fund Balance - Budget and Actual 1'. 1 PAGE 57 58 59. 60 -64 65 66 67 68 TABLE OF CONTENTS (CONT.) PAGE FINANCIAL SECTION;(CONT.) GOVERNMENTAL FUND TYPES (CONT.) SPECIAL REVENUE FUNDS (CONT.) Enhanced 911 Fund Financial Statements Statement of Revenues, Expenditures, and Changes in Fund Balance.- Budget and Actual 69 DEBT SERVICE FUND Debt Service Fund Financial Statements Balance Sheet 70 Statement.of Revenues, Expenditures, and Changes in Fund Balance - .Budget and Actual 71 Supplemental Schedules Schedule of Expenditures - Budget and Actual 72 CAPITAL PROJECTS FUNDS A11 Funds Financial Statements Combining Balance Sheet 73 Combining Statement of Revenues, Expenditures, and Changes in Fund Balances 74 PROPRIETARY FUND TYPES ENTERPRISE FUNDS . All Funds Financial Statements Combining Balance Sheet 75 Combining Statement of Revenues, Expenses, and Changes in Retained Earnings - Unreserved 76 Combining Statement of Changes in Financial Position 77 1 1 1 1 1 1 1 it TABLE OF CONTENTS (CONT.) PAGE FINANCIAL SECTION (CONT.) PROPRIETARY FUND TYPES (CONT.) ENTERPRISE FUNDS (CONT.) Water Fund Financial Statements Balance Sheet .78 Statement of Changes in Retained Earnings - Reserved - Restricted Accounts 79 Statement of Revenues, Expenses, and Changes in Retained Earnings - Unreserved - Budget and Actual 80 Supplemental Schedules Schedule of Operating Expenses - Budget and Actual 81 -83 Schedule of Fixed Assets and Depreciation 84 Sewerage Fund Financial Statements Balance Sheet 85 Statement of Revenues, Expenses, and Changes in Retained Earnings - Unreserved - Budget and Actual 86 Supplemental Schedules Schedule of Operating Expenses - Budget and Actual 87 -89 Schedule of Fixed Assets and Depreciation 90 Refuse Fund Financial Statements Balance Sheet 91 Statement of Revenues, Expenses, and Changes in Retained Earnings - Unreserved - Budget and Actual 92 Commuter Parking Lot Fund Financial Statements Balance Sheet 93 Statement of Revenues, Expenses, and Changes in Retained Earnings - Unreserved - Budget and Actual 94 Supplemental Schedules Schedule of Operating Expenses - Budget and Actual 95 Schedule of Fixed Assets and Depreciation 96 TABLE OF CONTENTS (CONT.) PAGE FINANCIAL SECTION (CONT. PROPRIETARY FUND TYPES (CONT.) INTERNAL SERVICE FUND Garage Fund Financial Statements Balance Sheet 97 Statement of Revenues, Expenses, and Changes in Retained Earnings - Budget and Actual 98 Statement of Changes in Financial Position 99 Supplemental Schedules Schedule of Operating Expenses - Budget and Actual 100 FIDUCIARY FUND TYPES TRUST AND AGENCY FUNDS All Funds Financial Statements Combining Balance Sheet 101 Statement of Revenues, Expenditures, and Changes in Fund Balance (Expendable Trust Fund) 102 Statement of Revenues, Expenses, and Changes in Fund Balance - Budget and Actual (Pension Trust Fund) 103 Statement of Changes in.Financial Position (Pension Trust Fund) 104 Combining Statement of Changes in Assets and Liabilities (Agency Funds) 105 -106 ACCOUNT GROUPS GENERAL FIXED ASSETS ACCOUNT GROUP Supplemental Schedules Schedule of General Fixed Assets - By Source 107 Schedule of General Fixed Assets - By Function and Activity 108 Schedule of Changes in General Fixed Assets By Function and Activity 109 GENERAL LONG -TERM DEBT ACCOUNT GROUP Supplemental Schedules Schedule of General Long -Term Debt 110 1 1 1 1 1 1 1 1 1 1 1 1 TABLE OF CONTENTS (CONT.) PAGE FINANCIAL SECTION (CONT.) SUPPLEMENTAL DATA Required Supplementary Information 124 Analysis of Funding Progress Illinois Municipal Retirement Fund 111 Police Pension Fund 112 Revenues by Source 126 . Illinois Municipal Retirement Fund 113 Revenues by Source and Expenses by Type 127 Police Pension Fund 114 Schedule of Officers' Deposits (Police Pension Fund) 115 Schedule of Insurance in Force 116 Long -Term Debt Requirements Sewerage Improvement Bond Series of 1973 117 Sewerage Treatment Facilities Bond Series of 1973 118 Corporate Purpose Bond Series of 1982 119 Corporate Purpose Bond Series of 1982 -A 120 Corporate Purpose Bond Series of 1986 121 Corporate Purpose Bond Series of 1987 122 General Obligation Bond Series of 1988 123 STATISTICAL SECTION General Governmental Revenues by Source - Last Ten Fiscal. Years 124 General Governmental Expenditures by Function - Last Ten Fiscal Years 125 Property Tax Assessed Valuations, Rates, Extensions, and Collections - Last Ten Fiscal Years 126 Assessed and Estimated Actual Value of Taxable Property - Last Ten Fiscal Years 127 Property Tax Rates - Direct and Overlapping Governments - Last Ten Fiscal Years 128 Ratio of Net General Obligation Bonded Debt to Assessed Value and Net General Obligation Bonded Debt Per Capita - Last Ten Fiscal Years 129 Schedule of Direct and Overlapping Bonded Debt 130 TABLE OF CONTENTS (CONT.) STATISTICAL SECTION (CONT.) Schedule of Legal Debt Margin Ratio of.Annual Debt Service Expenditures for General Bonded Debt to Total General. Governmental Expenditures - Last Ten Fiscal Years Demographic Statistics - Last Ten Fiscal Years Property Value, Construction, and Bank Deposits - Last Ten Fiscal years Principal Taxpayers Miscellaneous Statistics PAGE 131 132 133 134 135 136 -137 1 1 1 1 1 1 1 L� J 1 Introductory Section 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 i 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, 1990 LEGISLATIVE VILLAGE BOARD OF TRUSTEES. Bernard Forrest, Mayor Robert D. Franz, Clerk ADMINISTRATIVE Robert D. Franz, Village Manager FINANCE DEPARTMENT George J. Valentine Director of Finance /Treasurer i Edwin B. Seidman Vernon E. Swanson J. Robert York 1 1 m0 N Z N N Z Z Z _) Z O p } W F Z YZ Z W C7. J O 4 W F- O Z� O N z W. �- Z r Q¢ O Q J UJ N Y W W W F- N y v W Z LLI C) . �¢ UJ W .p 31. W m0 O J •.. CD �'• Z) U' O U = Z 0 W rW-� ►0� _Z 3 F-- WLU a ,V., W W p rZ.. © a i W a N J� W CD V ;.n W N J =. Q'I a 3 ~ Z O o 2 4� V m IV J ¢ LW.. CW7 W Q� a m �. �U U Z Q a m 2 O '- J Z < Q o O rWn V p J ` Y LLJ W J F- U LU F- N N Q N Q 1 1 m0 N Z CD N Z Z Z _) 0 p F Z YZ Z Cl C7. J O 4 W F- O Z� O N z W. �- Z r Q¢ O Q J UJ N Y W W W O N y v W Z LLI C) . Z3 UJ W .p 31. W 3 J •.. CD W Z) U' O W = Z 0 W rW-� ►0� _Z 3 F-- WLU W ,V., W W p rZ.. © a i W a N J� W CD LU F- ;.n W N =. Q'I �W 3 ~ W a¢ as L� 0 N Z CD N Z Z Z _) 0 p F Z Z Cl C7. J O 4 W F- O Z� O N z W. �- Z r Z" Q J UJ Z W uj C O N y Z C) . UJ W .p U .Z-n J •.. CD W Z) U' O W = Z -� W Z ►0� m a Z © a a N Q W CD m N W CD W a =. N Z N Z Z _) p F Cl ui J O 4 C7 F- O U •-• O U � O z F- N �- Z r ui Q J UJ W N y C) . UJ W .p U .Z-n V •.. W W -� Z Z ~ Z Z m N Q W CD m N W CD a =. Z 0 W U 2 F- CC ¢ a �. p N Z N Z Z _) p F Cl ui J O 4 C7 F- O U •-• O U � O Q. Cl. F- N �- Z r V Q J UJ W N y C) . UJ W .p V ii 1 1 1 1 I I i 1 1 1 1 Certificate of Achievement for Excellence in Financial Reporting. Presented to Village of Deerfield, Illinois For its Comprehensive Annual Financial. Report for the Fiscal Year Ended April 30, 1989 A Certificate of Achievement for Excellence in Financial Reporting is presented by the Government Finance Officers Association of the United States and .Canada to government units and public employee retirement systems whose comprehensive annual financial reports (CAFR's) achieve the highest standards in .government accounting and financial reporting. President Y�� G!t Executive Director iii VILLAGE OF DEERFIELD 1 October 23, 1990 Dear Mr. Franz: The comprehensive annual financial report of the Village of Deerfield for the fiscal year ended April 30, 1990, is hereby submitted. Responsibility for both the accuracy of the data and the completeness and fairness of the presentation, including all disclosures, rests with the Village. To the best of our knowledge and belief,. the enclosed data are accurate in all material respects and are reported in a manner designed to present fairly the financial position and results of operations of the various funds and account groups of the Village. All disclosures necessary to enable the reader to gain an understanding of the Village's financial activities have been included. ' The comprehensive annual financial report is presented in three sections: introductory, financial, and statistical. The introductory section includes this transmittal letter, the Village's organizational chart and a list of principal officials. The financial section includes the general purpose financial statements, the combining, individual fund, and account group financial statements and schedules, as well as the independent auditors' report on the financial statements and schedules. The statistical section includes selected financial and demographic information, generally presented on a multiyear basis. This report includes all funds and account groups of the Village. The Village provides a full range of services. These services include police protection; sanitation services; the construction and maintenance of highways, streets, sanitary sewers, waste water treatment infrastructure; and cultural events. In addition to general Village activities, the Village Board exercises, or has the ability to exercise, oversight of the Village of Deerfield Police Pension Retirement System and the Deerfield Public Library. These activities are included in the reporting entity; however, the West Deerfield Township, Highland Park Mosquito Abatement District, Deerfield Park District and Deerfield Bannockburn Fire Protection District have not met the established criteria for inclusion in the reporting entity, and, accordingly, are excluded from this report. t iv 1 1 850 WAUKEGAN ROAD DEERFIELD, ILLINOIS 60015 TELEPHONE 708.945.5000 ECONOMIC CONDITION AND OUTLOOK The Village has experienced significant growth on its southern boundary. A large portion of. the growth has been in Cook County. The Cook County area now encompasses 12.1% of the Village's equalized assessment valuation, and, according to the 1980 census, the Village has no residences in that area. A further indication of the Village's financial growth is the Village's current inventory of 1050 hotel /motel rooms. In 1985 the Village had none. This is important to the Village in that the Village levies a 5% occupancy tax on rooms which yielded $674,367 for the year ending 4/30/90. ' Sara Lee, a bakery products company, has indicated to the Village that they will be closing down their bakery operations in early 1991. The Village does not believe that this will have a significant impact on Village revenues in that Sara Lee's assessed valuation is approximately 1.2% of the Village's total. This site has little retail sales to the public; therefore, the only sales tax generated by this facility is through an outlet store. It is estimated to be less than $10,000 per year. There are approximately 400 employees involved; however, their hiring area is spread throughout Lake and Cook Counties, and relatively few employees are residents of Deerfield. Therefore, any economic dislocations involved will be spread over a broad area, and direct impact on the Village of Deerfield will be minimal. Recent real estate economic reports have indicated an overbuilding in office properties throughout the Chicago metro area; however, the same reports have recently indicated that the offices in Deerfield have about an 85% occupancy rate. The Village considers this to be a very optimistic ' sign that the commercial real estate in the Village is being well received by the market. 1 1 1 f 1 1 1 The Northern Cook County and Southern Lake County area has undergone a rapid economic development. The major portion of this development is centered on the Lake Cook corridor. Recently completed were entrance and exit ramps for the Illinois toll road at Lake Cook Road. This will provide improved access to Lake Cook Road and reduce dependency on the crowded Deerfield Road entrance. Unemployment in Lake County in August 1989 was 3.2% compared with 5.8% in the state of Illinois and an estimated lY in Deerfield. All of these factors indicate that Deerfield will continue to be a financially vibrant community. MAJOR INITIATIVES For the Year. The Village has continued its storm and sanitary sewer renovation project by continuing Phase III of its renovation project. This phase was financed with a $3,000,000 bond issue sold in October 1988. This renovation project was started in 1982. The Village has provided a total capital funding of $14,000,000 for this project. Any additional phase will be smaller and will depend on specific demand. v L The Village has continued its operations in the Central Business District Tax Incremental Financing District. For the year, the Village.has had expenditures totalling $1,159,750 including $310,000 for the aquisition of property, and the remainder for the completion of the Marathon parking lot, and Stage 1 and Stage 2 of the Streetscape design. For the Future In October 1986, the Village of Deerfield developed a plan to upgrade the overall quality and economic vitality of its Village Center (downtown). Located in the geographic center of the community, this six -block area exhibits many of the typical problems common to aging commercial districts throughout the country. Diverse ownership of inadequately sized and , ill- arranged parcels has resulted in incompatible development, causing both visual and functional problems. After approving a redevelopment plan, the Village began acquiring key parcels of property, budgeted for public improvements essential to the area, and developed a Streetscape Program for the two major streets which intersect within the Village Center. Experience has clearly shown that economic revitalization generally occurs in areas where there is a joint venture effort between the public and private sectors. Deerfield, in recognizing the importance of that philosophy, has begun a redevelopment program that commits substantial public funds to its Village Center. As might be expected, preference must be given to acquisition of property and basic capital improvements which will promote private investment in the area. At the same time, better pedestrian access and improvement of the general appearance of a downtown contribute significantly to its economic well- being. The Deerfield Police Department is currently in the process of implementing an enhanced 9 -1 -1 system. This system will allow public access to police, , fire and emergency medical services by dialing-9 -1 -1 rather than the current 7 digit phone number. The caller's phone number and address will automatically appear on a computer screen in the dispatch center with each ' call. Recycling /Scavenger Service. In response to growing environmental awareness and concern for decreasing landfill capacity, Deerfield initiated the weekly collection of recyclable newspapers, glass and cans from residences within the Village in September 1989. This service, combined with the 24 -hour drop -off center operating i since 1980, has diverted nearly 20% from the monthly landfilled waste stream. The curbside program, as well as other scavenger services, is administered through a negotiated contract with Laidlaw Waste Systems , extended through December 31, 1991. The Public Works Department is currently making final preparations for the weekly collection of leaves from residential areas of the Village. Previously gathered only once each fall, the weekly pick -up during November is an increase in service due to the state ban on landfilling yard wastes I and resident requests for additional service. Leaves are recycled-into vi , 1 compost at a Lake•County site operated by the Lake County Forest Preserve through a grant from the Illinois Department of Energy and Natural Resources. Lake County is hopeful that successful operation of this facility will lead to implementation of the County's Solid Waste Management Plan adopted in September of 1989. FINANCIAL INFORMATION Management of the Village is responsible for establishing and maintaining an internal control structure designed to ensure that the assets of the Village are protected from loss, theft or misuse and to ensure that 1 adequate accounting data are compiled to allow for the preparation of financial statements in conformity with generally accepted accounting principles. The internal control structure is designed to provide reasonable, but not absolute, assurance that these objectives are met. The concept of reasonable assurance recognizes that: (1) the cost of a control should not exceed the benefits likely to be derived; and (2) the valuation of costs and benefits requires estimates and judgments by management. Budgeting Controls. In addition, the Village maintains budgetary controls. The objective of these budgetary controls is to ensure compliance with legal provisions embodied in the annual appropriated budget approved by the Village's governing body. Activities of the general fund, special revenue funds, debt service fund, internal service fund, enterprise fund and pension trust funds are included in the annual appropriate budget. Project - length financial plans are adopted for the capital projects funds. The level of budgetary control (that is, the level at which expenditures cannot legally exceed the appropriated amount) is established at the fund level. The Village also maintains an encumbrance accounting system as one technique of accomplishing budgetary control. Encumbered amounts lapse at year end. However, encumbrances generally are reappropriated as part of the following year's budget. As demonstrated by the statements and schedules included in the financial section of this report, the Village continues to meet its responsibility for sound financial management. General Government Functions. The following schedule presents a summary of general fund, special revenue funds, and debt service funds revenues for the fiscal year ended April 30, 1990, and the amount and percentage of 1 increases and decreases in relation to prior year revenues. Increase Percent Percent (Decrease) of Increase Revenues Amount of Total from 88/89 (Decrease) Taxes 6,596,043 69.0 639,390 10.7 Licenses and Permits 521,286 5.4 (225,167) -3.8 Intergovernmental 360,970 3.8 29,153 .5 Charges for Services 328,625 3.4 110,463 1.9 ' Fines 254,610 2.7 47,708 .8 Interest 597,971 6.3 135,395 2.3 Miscellaneous 909,107 9.5 658,916 11.0 Total 9,568,612 100.0 1,395,858 23.4 I vii Taxes. The general heading of taxes encompasses several different types of taxes, the largest of which is the property tax. Property tax makes up 49% of taxes, or $3,214,534. This is an increase of $405,000 over the prior year, or an increase 14.4 %. Of that, $390,000 is for debt service, primarily from the 1988 bond issue, which was used to fund the continuing implementation of the Village sanitary sewer programs. Another substantial portion of the category is sales tax. This is a 1% tax on the exchange of tangible personal property. This tax is collected by the state of Illinois and remitted to the Village. For the year ending April 30, 1990, this was $2,012,188 or 31% of the total taxes. This is an increase over the previous year of approximately $34,000 or 1.7 %. It is the Village's belief that returns would have been significantly larger, but sales tax was by impacted by the loss of a major retailer, and a subsequent vacancy. Another significant revenue item is the hotel tax. This is a 5% tax on the occupation of rooms. This is a relatively new tax for the Village. The Village had no hotel rooms in 1985, but now has an excess of 1000. This tax brought in $675,000 which is 10% of .the total in the category of taxes. This is a 20% increase over the previous year. It is the Village's belief that this tax will continue to increase at a rate to exceed the cost of living. Licenses and Permits. Building permits have decreased to $93,818, a reduction of $266,625. This is due to a reduction in building activity in the Village. Miscellaneous. The increase in Miscellaneous Revenue is due to the Gain on Sale of Village property at $589,821. The following schedule presents a summary of general fund, special revenue funds, and debt service funds expenditures for the fiscal year ended April 30, 1990, and the percentage of increases and decreases in relation to prior year amounts. Expenditures Current General Government Public Safety Highways and Streets Culture and Recreation Miscellaneous Debt Service Principal Interest Total Increase Percent Percent (Decrease) of Increase Amount of Total from 1989 (Decrease) 1,377,270 16.2 -7,262 -.5 2,752,370 32.3 386,698 27.9 1,188,257 14.0 165,750 12.0 917,982 10.8 35,109 2.5 516,484 6.1 80,135 5.8 700,000 8.2 100,000 7.2 1,060,310 12.5 191,347 13.8 8,512,673 100.0 951,777 12.6 General Government. The decreased expenditure in General Government is due to a reduction in expenses for Village Hall remodelling. The major renovation took place in 1988 -89 at a cost of $136,270. viii 1 1 1 1 1 J 1 t 1 1 u 1 L� 1 1 1 1 fl L� 1 1 1 1 Police increases were due to general increases in salaries and expenditures, including an expansion of five sworn officers. General Fund Balance. The undesignated fund balance has decreased to $352,460 from $2,269,712. The reason for this reduction in balance is the Village's intent to fund a.large portion of the downtown TIF by advances from the General Fund. At this point, the Village has advanced $820,000 and has an additional $3,500,000 designated for this project. The Village's undesignated fund balance of $1,917,252 is the equivalent of 124 working days of expenditures. Enterprise Operations. The Village's enterprise operations are comprised of four separate and distinct activities: the Water Fund and Sewerage Funds, the Refuse Fund, and the Commuter Parking Lot Fund. The $144,000 or 14.2% increase in sewerage fund operating fund expenses was largely due to an increase in the cost of operating the waste water reclamation facility, primarily $50,000 for utility service and $60,000 for plant maintenance and repair. The other significant increase in the Enterprise Operations was in the refuse fund. The increase of $200,000 or 19% is due to the commencement of the recycling operation. Pension Trust Fund Operations. The operations of the Village of Deerfield Police Pension Fund (PERS) remained relatively stable in 1990. For the year ending April 30, 1990; the pension benefit obligation increased to 123 %, from 118% the prior year. While this standardized actuarial method differs from the Illinois Department of Insurance funding requirement, it does demonstrate actuarial stability in the police pension fund. Debt Administration. At April 30, 1990, the Village had a number of debt issues outstanding. These issues included $13,262,076 of net general obligation bonded debt and no revenue bonds. This total excludes a fully defeased $10,000,000 debt issue. The Village issued no debt during the fiscal year ended 4/30/90. The Village has maintained its AA from Moody's Investors Service on general obligation bond issues. The 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 - 1989 375,899,309 Legal Debt Limit - 8.625 32,421,315 Legal Debt Margin 19,159,236 Cash Management. Cash temporarily idle during the year was invested in demand deposits, certificates of deposit, obligations of the U.S. Treasury, and commercial paper. The pension's trust funds investment portfolio also includes insurance company separate accounts and a 1 guaranteed investment contract. The average yield on investments, except for the Trust and Agency fund group, was 8.65 %. The pension trust fund achieved a yield rate of 10.48% on cash and investments exclusive of separate accounts which are similar to mutual funds accounts and therefore ix I 1 carried at the lower of cost or market until sold. The separate accounts as reported by the management have a market value of $630,469 and a book value .of $470,000. The higher rate of return on pension fund investments , is attributable to the long -term nature of most holdings in its portfolio. The Village's investment performance ranks favorably when compared to , average yield rates of 8.099; for 90 day U.S. Treasury bills and 8.35% for 10 year U.S. Treasury notes. The Village earned interest revenue of $1,603,199 on all investments except the Trust and Agency fund group and $562,558 in the Police Pension Fund. The Village's investment policy is to minimize credit and market risks while maintaining a competitive yield on its portfolio. The Village only utilizes banks and savings institutions which have a Shoshunoff rating of , 911 or better. The Village believes that the criteria allow the Village to obtain competitive quotes on certificates of deposit without the need for costly collateral. Village deposits which are uninsured and uncollateralized total $1,037,602 or 4.3% of cash and investment. The Village's investments total $34,990,639. Of these, $24,345,092 are , Category 1. Category 1 includes investments that are insured or registered or for which the securities are held by the government or its agent in the government's name. An additional $8,889,571 is invested in the Illinois Public Treasury Pool, $1,035,976 is in a deferred compensation plan asset account, and the remaining $720,000 is in life insurance company contracts. Risk Management. The Village participates in the Municipal Insurance Cooperative Agency, MICA. MICA is a proprietary joint venture whose*' members are Illinois municipalities. MICA manages and funds first party property losses, third party liability claims, Workers' Compensation claims, and Public Officials Liability claims of its member municipalities. The Village's payments to MICA are displayed on the financial statements as expenditures /expenses in the appropriate funds. The Village also participates in the High -Level Excess Liability Pool Illinois to provide excess liability coverage ($5,000,000 of coverage after a $1,000,000 self- insurance retention). The Village's payments to HELP are displayed on the financial statements as expenditures /expenses in appropriate funds. 1 OTHER INFORMATION Independent Audit. State statutes require an annual audit by independent certified public accountants. The accounting firm of Karrison, Byrne, Jansey and Trimarco, Ltd. CPA's was selected by the Village's audit , committee. The auditor's report on the general purpose financial statements and combining and individual fund statements and schedules is included in the financial section of this report. Awards., The Government Finance Officers Association (GFOA) awarded a Certificate of Achievement for Excellence in Financial Reporting to the Village for its comprehensive annual financial report for the fiscal year ended April 30, 1989. The was the sixth consecutive year that the Village has received this prestigious award. In order to be awarded a Certificate of Achievement, the Village published an easily readable and efficiently organized comprehensive annual financial report. This report satisfied both generally accepted accounting principles and applicable legal requirements. X , 1 A Certificate of Achievement is valid for a period of one year only. We believe that our current comprehensive annual financial report continues ' to meet the Certificate of Achievement Program's requirements, and we are submitting it to the GFOA to determine its eligibility for another certificate. Acknowledgments. The preparation of the Comprehensive Annual Financial Report on'a timely basis was made possible by the dedicated service of the entire staff of the finance department. Each member of the department has our sincere appreciation for the contributions made in the preparation of this report. In closing, without the leadership and support of the Village Board, preparation of this report would not have been possible. Respectfully submitted, Finance Director 1 1 1 u 1 I 1 I 1 1 i1, xi 1 1 t 1 1 1 tJ t 1 I Financial Section 1 1 1 1 t 11 1 1 I - 1 1 1 1 1 1 1 1 1 1 1 t i 1 1 i 1 1 1 AUDITOR'S. OPINION 0 �a r . I 4�� on, B me, • 750 EAST DIEHL ROAD • NAPERVILLE, ILLINOIS 60563 Jansey&Y...c®, ltdo (708) 505 -1900 FAX: (708) 505 -1908 CERTIFIED PUBLIC ACCOUNTANTS 1 INDEPENDENT AUDITOR'S REPORT 1 .The Honorable Mayor. Members..of the Board.of Trustees Village of Deerfield, Illinois. We have audited the general purpose financial statements and the combining, individual fund, and account group financial, statements of the Village of ' Deerfield, Illinois, as of and for the year ended April 30, 1990,, as listed in the accompanying table - of contents. These financial statements are the responsibility of the Village of Deerfield, Illinois' management. ' Our responsibility is to express.an opinion on these financial statements based on ' our audit. We conducted our audit in accordance with generally accepted auditing standards. ' Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free of material misstate - ment. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements. An audit also.includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall financial statement..presentation.. We believe that our audit provides a reasonable basis for our opinion. '. In our opinion, the general purpose financial" statements referred to above present fairly,. in all material respects, the financial position of the Village ' of Deerfield, Illinois, as of April 30, 1990, and the results of its operations and.the.changes in financial position of its proprietary and similar trust fund . types for the 'year then ended in conformity with generally accepted accounting principles. Also,.in our opinion; the combining, individual,fund, and account. ' group financial, statements referred to above present fairly, in all material respects, the financial position of each of the individual funds and account groups of the Village of Deerfield, Illinois, as of April 30, 1990, and the ' results of operations of such funds and the changes in financial position..of. individual proprietary and similar trust funds for the year then ended in conformity with generally accepted accounting principles. Our audit was made for the purpose of forming an opinion on the general purpose financial statements and on the combining, individual fund, and account group . financial statements taken as a whole. The accompanying financial information listed as supplemental and schedules in the accompanying table of contents is presented for purposes of additional analysis and is not a required part of the general purpose financial statements of the Village of Deerfield, Illinois. Such ' information has been subjected to the auditing procedures applied in the 1 1 ' audit of the general purpose, combining, individual fund, and account group financial statements and, in our opinion, is fairly stated in all material respects in relation to the general purpose financial statements and each of the combining, individual fund, and account group financial statements taken as a ' whole. ' The statistical information us and, accordingly, we do listed in the not express an table of contents was not audited by opinion thereon. 1 1 1 1 1 F 1 d 1 1 1 August 15, 1990 2 �G1/iJito on � �r�2�r�C� 1 1 1 1 1 1 1 1 1 1 1 i 1 1 1 1 1 GENERAL PURPOSE FINANCIAL STATEMENTS 0 d ' VILLAGE OF DEERFIELD, ILLINOIS ALL FUND TYPES AND ACCOUNT GROUPS I COMBINED BALANCE SHEET APRIL 30, 1990 1 1 I(See Following Page) 1 1 1 1 1 1 1 1 1 1 1 1 43 C, ha ONNM0a O Co N n m co ANA m o v� o a n m" 0 %o m O m OD H h +1 a1 m co in N N ri h m O m n %0 O. O o 0 co o h n at H A O q m C H O y > N 8°` �+ O mnmo,00m10 n N N N O n W 0 rn .-I .n O -n 0% a N W N - W N q 8,0 a N 0 m n rl a0 m o a H t9W O'�ma0 a m 0 m Z h .i m in Nro - - .iU4H w-4i .4 0.4 N ~ O H m O 04� b 0 3 >. N .-1 O J A b O 3 00 V v +i a N N 0 � p m 43 ' O N .- r1 41 W U 08 0 a -A N 0 N > 0 H m H H m -4C H m s0 a0 LD O O +� 0 0 0 A 02 0 W H U U 43 W W g m W H N b P. 0 N N 0 N O N F r1 a CD 01 OD N O a h m A in 10 W H 0 0 0 N a 10 m 0UPC H O hn Cr) OD r, o% N n O, o N n O 11 O, ma) a a.- r�oOO�naa. v0 %o N N m 1 .1 Oa davlm 0 m O 10 %0 .-I .-I n N n N N N .-I .-I .-I O O O N N V1 O. m 14 .-I aD a %O O N n O 7 N N N 00 O N m a .i Cl) a 1.4 q p O O rn h U H U in c V1 �W6 OD m o� o� m '0 m � 4 O N co '0 0 N ° h a O.1 m of oh 0 b 1A tn TJi H In .1 o OD W r124: F o W m V %n O in In O O N OD p rZ Ri a0 m m a W bq m 10 v0 C-4 O% m v0 O O o� m Q W N n 1 NC OYI OOm O O (� U U 7 W a -I N.1 nOH N a U rl m 43 o .-I -n a .-I n a s YO n .-I m N .-I m A W m m W O 4:4 cn W W I] N m N n n In Cl) tn N h W° Z W 4J m aN0 O H Q,' ro O rn v' U H W N o� w A n In Cl) Q W U a p a ao a a F +' A C N a m N m Qi rn 14 H N 43 r T O O .4 m m p �D n .i0 mn n n n a C vi m �o iiiCCC1.1.1• N N nn c%m m Oti a m m N .i co rl H N .-I CD �O YO m o aD h . H O OOOO n OT %n CO OD O1O Nn ]IOCD' m O 1O N N H 1O N OD VO N 43 mm m aWW ANA m H Ai p7 +UO +1 a1 I N N m 0 O R a 0 0 p w at H A O q m C H O y > N q 'd 0 O F N ."l. F: -1 17 H a0 a0 4) r. W H N 0 b W g W N - W N q 8,0 a N +i F m +� a0 0 r a0 m o a H t9W O'�ma0 a m 0 m Z m .4 H O w N OA G - - .iU4H w-4i .4 0.4 N ~ O H m O 04� b 0 3 >. N .-1 O J A b O 3 00 V v +i a N N 0 � p m 43 ' O N .- r1 41 W U 08 0 a -A N 0 N > 0 H m H H m -4C H m s0 a0 LD O O +� 0 0 0 A 02 0 W H U U 43 W W g m W H N b P. 0 N N 0 N q H E,y U 3 O W C C O W a N ♦7 0) (D O N > to a N U K q W H 0 0 0 N qq HH N N +I m 0UPC c a W 93 O V1 a1 G m .) a1 ro N m .•1 ro ro G w CD A a1 O A N m 0 O z bD G T N H O m m to CY) h m n O m O n N d a o 01 O 0• N O O O al O r1 n n O J 01 O, ,aD MOIDOCnmNOO1001noo O 0 CI 0 o NO n ohm s h all N �D O O N CD. 1O J h 11 m C 0 n O O 1 r1 O O N O N O O V1 m O O m a N 0 h rl O� O O. N a0 O Ul 01 cD n CO n tn O O m m O n J a J "'1 a, �+ J 01 O N CO J n O Ul n 10 N W 10 N rl m m O m 00 O N N h r1 O OD m N h �O N J n N OD O 0 O N 00 O N C1 v1 0n a N N 4 rl rl n Y1 n N m a0 h J J .� J .-1 H t0 n V1 G O F fro1 c0 a J N a m J J n 1D O 10 'O+ O, CO O, O, O O O a m O 10 H n m p ON Ul m n N O, r1 O, n o U•1 H o m m O co h N N o 0 01 h '+ O O m m C 10 r1 1O a T 11 O 01 m h H rt O n 01 O. 10 O n Cn 01 Cn ' m O,I £ n N H CO N1 N m n o h V1 Cn W O h 00, H tn m a m Ln a J O N n N N O h H m m m m N m 1O 10 H m J m .-1 n 0 m O m m m n n 0 0 N 11 10 a s co O N 00 H h a H n m r1 N rl co 11 J n t0 01 4'1 h H v1 m O rt a N N m 1-1 N s O H ra w o 0 O O 0 O N ro m 11 0 0 O 7 N f1 w U1 to Ln O G to in N N 1 N C7 m m O 17 �. J J J � rl rl rl G 'o 0 ID 07 .4' N O N O V7 O V1 U H m m 1 6 G •./ Ul U1 U'I m G N N n 10 o n m o m m o w ro� .+ n rt n o n C*4 ro O N 10 01 o aD O F +0 m - Ob u1 N c0 01 h o v1 In O O N N u1 vl O m o O s N H J s ro +�i a w ' W W F .•� O r1 Ln .•+ �D �O n � � H rr m n J 01 h U1 00 O U1 m U N co 10 O 0 N N N v1 N 10 O �D n Vl h N O LGI > m w m a1 m 01 1G m rt O O . c C �D 1D V) 10 D J J m M N J7 m +1 H m N w 01 CO N n 10 O N H.aN NN.t 41 01 rr O1 O) Y1 aD n O m 0 N 7 N a0 1 h rl n N co m 10 �D cD T co ' G11 W w 10C; 0 n.W 01 C1 J 00 J s m a m H .O .4 m m J a n .+ N s m .-1 .-1 J m W CD h h m co m 10 - J O 01 N O O O N ' H w to J 'D 01 O w n n r1 10 O O 1D 10 %D CO a0 ID O m N y1 U CD O% %n O m O a J s H •.1 m 00 n O 01 00 s 10 10 %D H P.. roa m r1 J m V1 h m m m O L) a 1n n 10 10 10 . . 4) 1n O en N N N U 14 01 0 0.-1 n C'O 1 0�O Hp.1 V 'O m t ❑ N 1D 4 tn U 10 O ' t w rl H 1 ♦ rD rD a1 ' G m" m O4 m 10 J a J O m a 0 NH r W) 1 W) 01 H •� G m v1 Dh n o m w U 'm > m N 00 Orn 10 m N H .-1 r• m ' m rt 01 -C H sh N rre4 as J O ova 0 rc 1-1 N rl m co m 0% O O O c0 O N O O O r4 o an O �D 10 an O co to O N T T c0 m N W) co Nmm. m I=t r\ 01 ONT Cn m (D :. O - 10 14 O O N 10 O n n n a0 a, m H a a, r, Nm.ti a) N tonmm M n m '4 10 10 V1 N 1 N ID a1 rl N 41 > N 11 l u U � Am W m °o a o M m v) �tl 19 K 000 6 G +- ro v +1 m >H� G 57 >1 w m .4 mm O N >4 W W m U) W m H L m A 0 H 1 m ami 41 "F-1 O A 41 .4 ro 41 ro H m 41 a1 N >1 H •.1 N •.mi A 5 m m w q m F N N -A b .4 $4 o w •.0 �> G m m O m 00 +1 m m w a 4 10 ro a +1 0 •.ro F W H ❑ U N +1 G m m O + G O >+ G U m.m.4 a, A m A w" m G m w N 1 m u1 WG >> O ,p a. O U G G +1 m >1 , a m H �i U W + a.>1 rA •� 1 l q ro ❑ U 1 .- .- m .1 ❑43 Can H Gm kB 14 1 v m O � z a < rt A A ro ,q al W m •.1 m 0 .-1 w 0 •.4 a c9 $4 H w 'J w $4 a1 'O a1 7 � •.1 '� 6 U w O ro ro >, m a U .4 00 .+ m U G G a1 U1 0 0 0 0 O O G m ro W W a a1 rn a mb w'>1 ro 4 w 0•"A+c w 'd A +1 w m m w 44wa1 W 44 4) -0 41 G •� W w w to (a 0) w 41 10 .4 a m 04 04 AC >t A1 41 y O 1 G H m a > to e0 rc G+1 ca r1 m .-a w m w 1 m J 1 1a1 +1 G - �wb-0 ID m O H 1 a1 W H H m m m N00 CC CO 0 'O P1 04 b 7 m 'a > m m -1 > m >> 0 >> •.1 m +1 m 0 O O H O H❑. A w b m 41 ro U1 111 m .-1 .4 mac m m m •a G G O w O m ro m G A m •.1 m w 0 +1 OW m 0 ro w i1 w w w w i1 N fA m G m m G m m m m U1 b F m G H F A 7 w W •.1 m w a1 w 4.1 41 w 41 w N +1 U1 w H U) H Ia W .4 U) U1 C4 11 ❑ a m .4 ,[ U w m 0 ro a m m ro m 0 m to m G 'O m m m m m G 7 U,1 p, i1 HA mw mA c:H a1 p > 4J 11' GPC ad a: OGC>; a 1-7 A m O U G m m 0 a1 7 m a m m co 3;> ❑aU0❑❑❑a0 +1 O G m 7 +1 a w V1 a1 G m .) a1 ro N m .•1 ro ro G w CD A a1 O A N m 0 O z bD G T N H O m m to CY) N w P4 H A Z �I w H ,O H O ~O H W W .�-� � m O � - C+1 CG w A04 �ZAa w w�� (Y4 zA w '�¢ A H O v] w oA z�� AA ra Q H 1=1 �i H z w z z w O W U O 0 F-1 r4 10 m n N N .•, .••II N O, In H w O n Y) V1 n J WHO-0 %D IN NNnm 01 .7 3 0) 0 all O cD 10 r•1 m 10 111 J N co N NJm.•,O01nm N N .nmNN0% -1 14 10 an ,01000 n n O ON 1 10 1 10 co Yl 10 Vl to m m O J n '•1 vi - 10 .••1 O V V1 0 .d 4 n O 0 01 0 ro b J V1 N N 10 J O N c co 1 +3 G .T - -1 a o ro m 10 1 10 1 F %'1 co 10 N "O mN O.-1 i O, 10 O" O N O, a O ON m . F w n N .••1 m N O N O m m 0 00 J N 10 n O 10 N 01 10 10 n O n Eal O m m 1 H140O -Z cn10 0 1 10 N a, 10 m 10 N 10 N 0 J O n m 1 11 m J N m m N N a V1 F N N n v . m .4 1 1-1 1 '.-1 NNnm 01 .7 3 0) 0 0 O O n nn0o c co N Nco N N N N a mn0nJm. O,Om n n , ,01000 n n O ON 1 10 1 10 co Yl 10 Vl to m m O J n n J J - - 10 .••1 O V V1 0 01 n n O 0 01 0 01 01 J V1 N N 10 J O N c co 1 10 . .T - -1 a a m m 10 1 10 1 10 .r co 10 N "O mN O.-1 i in N N n nm O O ON m m J J.••1N N N T m m 0 00 J N 10 n O O. J J O O O O O O m m 1 10 0 0 1 10 N co 1-1 1 10 m m m m N m m m 1 11 m m' m m m .•1 v v . .4 1 1-1 1 1 r1 00 O J J a O a a IT 0 IT co N n v1 OD 00 N O 1-1 O O 10 N J a c0 CO O CO N N m N O, 01m Om In N nO n O, O, 01OQ` 01 N N co n m m O m 10 O vl .-1 a a 14 .-1 O 11 10 n v1 co ., r1 01 0 a m ., v1 10 O, m 0, O T co mn.- 10.v10, n0 m N O n , m N N O N 0 r1 N '•1 n .•, n m m m m ,•, a a H v N 11 1-1 N O O O O pm 11 _ m m m m I I I I 1 SC H O O aJO aJO W ,4 m 10 a N N n . n In 0, ;1 4 r1 O O 01 .•, O ro a1 n 1D N 0` N N m a n n 10 a a N N 10 a7 U n n o m m N 10 m N 0, O O N aD CO +� m .. p. W) Jaln m m Co ma 0, co 0 0 0m a ro O 10 O 01 10 O, 01 N N m co m .q 1.1 O 10 U H m co a .-1 O+ 01 c0 n 10 n Ltl J rc n n n m m n n T 10 OOO n N N N n n*N 10 a m .a m v7 O .••1 .a v1 n n O co co ., O N Ao 10 O m m 10 m m N 01 m N N O, m 1>1 to O IOfI 0 100 O c0 .n-1 n n b m Q o n o n o 0 0 0 I t o N m J a V1 01 n N J N m S O J n a a n n a .-1 m m O 10 O 01 N 0 n vl co O O O N O N N N N T n n e•c .-1 O 10 11 N. O, O, N J m O m n o o U m 10 01 .-1 m N u'1 O, N O n m �D m m m O m co co m> m N W1 N N 10 o OD .••1 r•1 N J O 10 a tb n n N V1 J 0 a) n m m N 14 n .••1 .-1 O+ V1 n - .-1 .. O,. 01 m O M N O O m J 01-4 If O, 01 O N rl J co N n O, 10 m .�-1 Q m %00 m m 01 to m m ro O J N n 1 .••1 N m N m 10 10 J 10 N J T O 1c1 v1 D W m J .-1 O, to J N m 0 n 10 m 10 J m O, n m On O F 11 N 7 P v a o NN cn a 1 11 1 rq N V1 r, N a 1; ., J J .-1 v1 10 N al G m 6 m ro at rn U1 .-1 m ro "J UUC m N 00 a1 A b m G G m N m m O U W m m n U m 00 7 N O 7 U, G m (a CD to _ A G m H G m G M O 6 m ... a > H W N $4 7 .0 m 0 N O a M a +1 43 m A m W 43 (D CD G ID m U W m H 0 O U Dl m O 00 ,B 1 ,4 4 M 41 m F ro � N m W N N G G O 0 N a1 m F a v a F - � % .� � g gW 'M m m . X U 7m 11, Al 10 41 '• U H U a m W 7 m, p y >, m V G $4 ro G to G +1 CU m 0ro I L 0 m "' "a m > Cv m ° m 0 m o W ro M .•.4 Hm ., ., N v .4 `" m m ` '' �W FF OW o m m 5p w F m 'O G W -1 >. m -1 0. m 4 W m 0 G 0 A W H ° > W � q m m 7 U H G 41 G a) .4 0 0 0 m 4 .1 7 1 m U $4 43 Q X , -4 1 Q +, IV pa m 0 2 1 I m 0 14 , ro 7 O N 00 m m .1 E .A ,m V1 00 m N m m -r7 m m M 1 al m b , G X O + U 4 m 7 c U s1 (o G N F S M 0 m N •n N N m , G + -1 m y ro m > m Lv Tr4 k U U Q o E a a m a m Ir. w w o w w Cn O O O O pm 11 _ m m m m I I I I 1 SC H O O aJO aJO W ,4 m 10 a N N n . n In 0, ;1 4 r1 O O 01 .•, O ro a1 n 1D N 0` N N m a n n 10 a a N N 10 a7 U n n o m m N 10 m N 0, O O N aD CO +� m .. p. W) Jaln m m Co ma 0, co 0 0 0m a ro O 10 O 01 10 O, 01 N N m co m .q 1.1 O 10 U H m co a .-1 O+ 01 c0 n 10 n Ltl J rc n n n m m n n T 10 OOO n N N N n n*N 10 a m .a m v7 O .••1 .a v1 n n O co co ., O N Ao 10 O m m 10 m m N 01 m N N O, m 1>1 to O IOfI 0 100 O c0 .n-1 n n b m Q o n o n o 0 0 0 I t o N m J a V1 01 n N J N m S O J n a a n n a .-1 m m O 10 O 01 N 0 n vl co O O O N O N N N N T n n e•c .-1 O 10 11 N. O, O, N J m O m n o o U m 10 01 .-1 m N u'1 O, N O n m �D m m m O m co co m> m N W1 N N 10 o OD .••1 r•1 N J O 10 a tb n n N V1 J 0 a) n m m N 14 n .••1 .-1 O+ V1 n - .-1 .. O,. 01 m O M N O O m J 01-4 If O, 01 O N rl J co N n O, 10 m .�-1 Q m %00 m m 01 to m m ro O J N n 1 .••1 N m N m 10 10 J 10 N J T O 1c1 v1 D W m J .-1 O, to J N m 0 n 10 m 10 J m O, n m On O F 11 N 7 P v a o NN cn a 1 11 1 rq N V1 r, N a 1; ., J J .-1 v1 10 N al G m 6 m ro at rn U1 .-1 m ro "J UUC m N 00 a1 A b m G G m N m m O U W m m n U m 00 7 N O 7 U, G m (a CD to _ A G m H G m G M O 6 m ... a > H W N $4 7 .0 m 0 N O a M a +1 43 m A m W 43 (D CD G ID m U W m H 0 O U Dl m O 00 ,B 1 ,4 4 M 41 m F ro � N m W N N G G O 0 N a1 m F a v a F - � % .� � g gW 'M m m . X U 7m 11, Al 10 41 '• U H U a m W 7 m, p y >, m V G $4 ro G to G +1 CU m 0ro I L 0 m "' "a m > Cv m ° m 0 m o W ro M .•.4 Hm ., ., N v .4 `" m m ` '' �W FF OW o m m 5p w F m 'O G W -1 >. m -1 0. m 4 W m 0 G 0 A W H ° > W � q m m 7 U H G 41 G a) .4 0 0 0 m 4 .1 7 1 m U $4 43 Q X , -4 1 Q +, IV pa m 0 2 1 I m 0 14 , ro 7 O N 00 m m .1 E .A ,m V1 00 m N m m -r7 m m M 1 al m b , G X O + U 4 m 7 c U s1 (o G N F S M 0 m N •n N N m , G + -1 m y ro m > m Lv Tr4 k U U Q o E a a m a m Ir. w w o w w Cn ,4 m 10 a N N n . n In 0, ;1 4 r1 O O 01 .•, O ro a1 n 1D N 0` N N m a n n 10 a a N N 10 a7 U n n o m m N 10 m N 0, O O N aD CO +� m .. p. W) Jaln m m Co ma 0, co 0 0 0m a ro O 10 O 01 10 O, 01 N N m co m .q 1.1 O 10 U H m co a .-1 O+ 01 c0 n 10 n Ltl J rc n n n m m n n T 10 OOO n N N N n n*N 10 a m .a m v7 O .••1 .a v1 n n O co co ., O N Ao 10 O m m 10 m m N 01 m N N O, m 1>1 to O IOfI 0 100 O c0 .n-1 n n b m Q o n o n o 0 0 0 I t o N m J a V1 01 n N J N m S O J n a a n n a .-1 m m O 10 O 01 N 0 n vl co O O O N O N N N N T n n e•c .-1 O 10 11 N. O, O, N J m O m n o o U m 10 01 .-1 m N u'1 O, N O n m �D m m m O m co co m> m N W1 N N 10 o OD .••1 r•1 N J O 10 a tb n n N V1 J 0 a) n m m N 14 n .••1 .-1 O+ V1 n - .-1 .. O,. 01 m O M N O O m J 01-4 If O, 01 O N rl J co N n O, 10 m .�-1 Q m %00 m m 01 to m m ro O J N n 1 .••1 N m N m 10 10 J 10 N J T O 1c1 v1 D W m J .-1 O, to J N m 0 n 10 m 10 J m O, n m On O F 11 N 7 P v a o NN cn a 1 11 1 rq N V1 r, N a 1; ., J J .-1 v1 10 N al G m 6 m ro at rn U1 .-1 m ro "J UUC m N 00 a1 A b m G G m N m m O U W m m n U m 00 7 N O 7 U, G m (a CD to _ A G m H G m G M O 6 m ... a > H W N $4 7 .0 m 0 N O a M a +1 43 m A m W 43 (D CD G ID m U W m H 0 O U Dl m O 00 ,B 1 ,4 4 M 41 m F ro � N m W N N G G O 0 N a1 m F a v a F - � % .� � g gW 'M m m . X U 7m 11, Al 10 41 '• U H U a m W 7 m, p y >, m V G $4 ro G to G +1 CU m 0ro I L 0 m "' "a m > Cv m ° m 0 m o W ro M .•.4 Hm ., ., N v .4 `" m m ` '' �W FF OW o m m 5p w F m 'O G W -1 >. m -1 0. m 4 W m 0 G 0 A W H ° > W � q m m 7 U H G 41 G a) .4 0 0 0 m 4 .1 7 1 m U $4 43 Q X , -4 1 Q +, IV pa m 0 2 1 I m 0 14 , ro 7 O N 00 m m .1 E .A ,m V1 00 m N m m -r7 m m M 1 al m b , G X O + U 4 m 7 c U s1 (o G N F S M 0 m N •n N N m , G + -1 m y ro m > m Lv Tr4 k U U Q o E a a m a m Ir. w w o w w Cn I t o N m J a V1 01 n N J N m S O J n a a n n a .-1 m m O 10 O 01 N 0 n vl co O O O N O N N N N T n n e•c .-1 O 10 11 N. O, O, N J m O m n o o U m 10 01 .-1 m N u'1 O, N O n m �D m m m O m co co m> m N W1 N N 10 o OD .••1 r•1 N J O 10 a tb n n N V1 J 0 a) n m m N 14 n .••1 .-1 O+ V1 n - .-1 .. O,. 01 m O M N O O m J 01-4 If O, 01 O N rl J co N n O, 10 m .�-1 Q m %00 m m 01 to m m ro O J N n 1 .••1 N m N m 10 10 J 10 N J T O 1c1 v1 D W m J .-1 O, to J N m 0 n 10 m 10 J m O, n m On O F 11 N 7 P v a o NN cn a 1 11 1 rq N V1 r, N a 1; ., J J .-1 v1 10 N al G m 6 m ro at rn U1 .-1 m ro "J UUC m N 00 a1 A b m G G m N m m O U W m m n U m 00 7 N O 7 U, G m (a CD to _ A G m H G m G M O 6 m ... a > H W N $4 7 .0 m 0 N O a M a +1 43 m A m W 43 (D CD G ID m U W m H 0 O U Dl m O 00 ,B 1 ,4 4 M 41 m F ro � N m W N N G G O 0 N a1 m F a v a F - � % .� � g gW 'M m m . X U 7m 11, Al 10 41 '• U H U a m W 7 m, p y >, m V G $4 ro G to G +1 CU m 0ro I L 0 m "' "a m > Cv m ° m 0 m o W ro M .•.4 Hm ., ., N v .4 `" m m ` '' �W FF OW o m m 5p w F m 'O G W -1 >. m -1 0. m 4 W m 0 G 0 A W H ° > W � q m m 7 U H G 41 G a) .4 0 0 0 m 4 .1 7 1 m U $4 43 Q X , -4 1 Q +, IV pa m 0 2 1 I m 0 14 , ro 7 O N 00 m m .1 E .A ,m V1 00 m N m m -r7 m m M 1 al m b , G X O + U 4 m 7 c U s1 (o G N F S M 0 m N •n N N m , G + -1 m y ro m > m Lv Tr4 k U U Q o E a a m a m Ir. w w o w w Cn m O M N O O m J 01-4 If O, 01 O N rl J co N n O, 10 m .�-1 Q m %00 m m 01 to m m ro O J N n 1 .••1 N m N m 10 10 J 10 N J T O 1c1 v1 D W m J .-1 O, to J N m 0 n 10 m 10 J m O, n m On O F 11 N 7 P v a o NN cn a 1 11 1 rq N V1 r, N a 1; ., J J .-1 v1 10 N al G m 6 m ro at rn U1 .-1 m ro "J UUC m N 00 a1 A b m G G m N m m O U W m m n U m 00 7 N O 7 U, G m (a CD to _ A G m H G m G M O 6 m ... a > H W N $4 7 .0 m 0 N O a M a +1 43 m A m W 43 (D CD G ID m U W m H 0 O U Dl m O 00 ,B 1 ,4 4 M 41 m F ro � N m W N N G G O 0 N a1 m F a v a F - � % .� � g gW 'M m m . X U 7m 11, Al 10 41 '• U H U a m W 7 m, p y >, m V G $4 ro G to G +1 CU m 0ro I L 0 m "' "a m > Cv m ° m 0 m o W ro M .•.4 Hm ., ., N v .4 `" m m ` '' �W FF OW o m m 5p w F m 'O G W -1 >. m -1 0. m 4 W m 0 G 0 A W H ° > W � q m m 7 U H G 41 G a) .4 0 0 0 m 4 .1 7 1 m U $4 43 Q X , -4 1 Q +, IV pa m 0 2 1 I m 0 14 , ro 7 O N 00 m m .1 E .A ,m V1 00 m N m m -r7 m m M 1 al m b , G X O + U 4 m 7 c U s1 (o G N F S M 0 m N •n N N m , G + -1 m y ro m > m Lv Tr4 k U U Q o E a a m a m Ir. w w o w w Cn N al G m 6 m ro at rn U1 .-1 m ro "J UUC m N 00 a1 A b m G G m N m m O U W m m n U m 00 7 N O 7 U, G m (a CD to _ A G m H G m G M O 6 m ... a > H W N $4 7 .0 m 0 N O a M a +1 43 m A m W 43 (D CD G ID m U W m H 0 O U Dl m O 00 ,B 1 ,4 4 M 41 m F ro � N m W N N G G O 0 N a1 m F a v a F - � % .� � g gW 'M m m . X U 7m 11, Al 10 41 '• U H U a m W 7 m, p y >, m V G $4 ro G to G +1 CU m 0ro I L 0 m "' "a m > Cv m ° m 0 m o W ro M .•.4 Hm ., ., N v .4 `" m m ` '' �W FF OW o m m 5p w F m 'O G W -1 >. m -1 0. m 4 W m 0 G 0 A W H ° > W � q m m 7 U H G 41 G a) .4 0 0 0 m 4 .1 7 1 m U $4 43 Q X , -4 1 Q +, IV pa m 0 2 1 I m 0 14 , ro 7 O N 00 m m .1 E .A ,m V1 00 m N m m -r7 m m M 1 al m b , G X O + U 4 m 7 c U s1 (o G N F S M 0 m N •n N N m , G + -1 m y ro m > m Lv Tr4 k U U Q o E a a m a m Ir. w w o w w Cn 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 MID OV10.4nN 00 ln Na OMM P 1nP�O Vl •?P/� O � a1DnN 1-In C' 11 nnh 00 lD Onn M .4a�D �D C1 oNP -%D 10 0% 14 0 Cl) NN PP 0 14 J rl 1DJ P PN F o �D .-�OCDdn P W nNO nM OOO O cq"o M 14 N .p4 O PN�ONhPO10 nhOD•.4 If Orl rq 11'1 0% M Go N 06 h1nMMN1nP1n Mn.-1P1n 1. in v1 o rlri .� .ro.1 M .-ml b P rl N 11 CD CD .� .-1 �D .ti n CO m � F0 H OO n0000h MNO0a 001 VI I V1OV1 h 6 0 �OO�OO OOOin Y1nJNO 000D Non N m Y1 O P h O O Y1 h a N J �D O O 10 �O Ob rl N d P O N N Y1 10 P 1D M P O N n 10 M rl N n n r1 to a CD M O O a n N M M N M M O a o A F h n / P rl M •i - ri P ,41 „1 n M 03 C F r n O O M n n v l V N n CnPO O C PrN l �OO N CO D D N J n O O O O 00 l O- O M M U � 1 V > J P O F WM 1yPL4j 41 O M O O O YI Yl Yl O w 0 O O O N N N O O �0 0 O O O O N 1 O N N n O O n A W V Q 7 M O n o Ri �O n n ri O .Mi W h H� z o O ~ W 1i 0.1 aCDNM Ja1n PnNd N M JOJ n dnn d z tz1 .a M c0 O P NI O n in (O OD O O N O N N N P N in H W () O CD �0 P N P P N d M O M VI W A M 43 �PrIM NvP Y1 OD �O Cl) MMO M COOn '1 m O M N" C9 N �D O OD rl 'I N a O �O d o n N in a f-{ H > Ci n M M N .-1 n .-1 �-1 P h n rl P .i OD P CA W 1 H w 'i N F N P4 0 W p FW-1 A � rno�o oo� n.°- aca�to s � OooOO aMo CD m POPYI C Y NNd%Dc Y'1 Yl Ct 'n �dl W W b kn o %D a n 1n P to n �o M 0 rl .� %0 M n ao O 10 M N N P �0 O %0 0 O M O W A O 1D M M N' rl O rl r 'i in O A W 0 GZ M r1 F M �H1 W W !`y ✓' M co c0 N O O M a O .i .i M ID P Co O M n O O Ur 4 W .-1 P P O N .4 d c0 Yl n P �O P rl d M %0 M P M P m O d N in b ri N M N M D 0 d O N d P 1n v1 P 1z'i rx y01 C M n 10 M 10 d Cl) P n P O O n d1 H H U oP olnnoa n d f j N r1 in d �D N N Yl N H V1 .-1 Ji M `4 1-1 N Cl) P .-1 M %D O rl O .i .-1 N M F'1 V W M Y1 rl C d ei ri d e-1 1n �D W A W 0 m P4 W w m 00 000000 O N N 1b co N Z i U) 00 O O O O O o O %D d Y1 O O J f.{ m O O 0 0 0 0 0 0 -1 M 1n a O O Yl oc Yl Y'1 to h 0 0 n 0 '4 N M 10 rl N d O U 7 caiN PNNNPOi MCPD N '"1 CID GO �0 W V N d rl N d H 00 CD O O W O U 14 M 43 O U m v 8 m 7 w m CI 111 -1 p . m~ N � 'am at m J1 m m m m H w 6 U U a0 13 O to N m H 11 m N 7 0 N H g Og s1 q [.i a iCd N O al a mrn w w mm p pvrx m N m w m W 'A ' .0 --4 , >m uov o " m m W � r F F w H w cq ui 14 m U m O m m y m ca m W i N pU q w > 0 44 Q . • m m r r m m y .4 .0 43 O m : i 3 O m m U 11 " O . i G 40 M N N CO .� m 41 .- C 41 U N R m O . C 41 N 4 y m m 1a to N + 1.0 +H O N b1/ m 0 0 b r N N m m .1 yiF �O D7UE maH m H pm,pm, mb p,m A 1n H �Fr7MUwHE �11U Q u O X00 kWp ctl W w o w w 62 m a N to .4 a U w m J O 43 O m 0 zo m a 8 O U U D m m N 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, 1990 See accompanying Notes to the Financial Statements. 6 Proprietary Fiduciary Fund Types Fund Tyne Totals Internal Pension (Memorandum Only) Enterprise Service Trust 1990 1989 Operating Revenues Taxes 160,461 160,461 155,430 Charges for Services $4,049,648 176,262 4,225,910 4,174,799 Contributions 127,777 127,777 83,619 Interest 562,558 562,558 488,746 Miscellaneous 91,416 91,416 136,388 Total Operating Revenues 4,141,064 176,262 850,796 5,168,122 5,038,982 Operating Expenses Administration 350,152 350,152 361,473 Operations 4,006,035 197,726 4,203,761 3,859,799 Depreciation 376,057 376,057 378,631 Benefits and Refunds 117,720 117,720 88,660 Miscellaneous 568 568 1,620 Total Operating Expenses 4,732,244 197,726 118,288 5,048,258 4,690,183 Operating Income (Loss) (591,180) 2( 1,464) 732,508 119,864 348 :799 Nonoperating Revenues (Expenses) Interest Income 200,464 200,464 189,685 Property Taxes 621,687 621,687 541,018 Interest Expense (1,913) 822,151 - - 822,151 728,790 Net Income (Loss) before Operating Transfers 230,971 (21,464) 732,508 942,015 1,077,589 Operating Transfers (Out) (103,000) - - (103,000) (91,500) Net Income (Loss) 127,971 2( 1.464) 732,508 839,015 986,089 Other Changes in Retained Earnings - Unreserved /Fund Balance Depreciation that Reduces Contributed Capital 191,764 191,764 194,373 Transfer from Restricted Accounts 88,708 88,708 280,472 - - 280,472 194,373 Net Increase (Decrease) in Retained Earnings/ Fund Balance 408,443 2( 1,464) 732,508 1,119,487 1,180,462 Retained Earnings - Unreserved/ - Fund Balance May 1 4,582,216 (45,056) 5,692,555 10,229,715 9,049,253 Prior Period Adjustment 150,000 - - 150,000 - Adjusted Balance 4,732,216 4( 5,056) 5,692,555 .10,379,715 9,049,253 April 30 11,1jO 659 66,520) 6,425,063 11,4® 10,229,715 See accompanying Notes to the Financial Statements. 6 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 N W 04 F-� A R F Z. Ra O F H Z F O. H H � O z w w a a O � a, H Q H O4 O U r-I z '-' z o ra F w M rA H � ra - H 1z-1 W W � Ri AC9 W A A 04 W oz O wzz z� U (4 w H H E-4 O CA W Q A H W w z �Ay H ai 0 O > U F H a Lei a a 4 ON 00 O� r-4 r4 O ul r4 co 'O u C O (d F )4 J E o �" ON r--1 M It 00 n n O� �D M 0 r-1 O It ° O � o-4 %D It M 01 )1Otl--� 00 lD N O� 00 M M M 't �t r-1 1 r-1 r H -40 O I1 N r-4MO O 4 00 00 1on )1Otl--� �M ID N O� 00 u1 %.D M 't l r-1 1 r-1 It In O r- OI %Dl . 0 LnIt Ln%D0r -+ O I- In N %D O N Ln r-1 N I'D M lf1 ON n r4 N H r-1 OI It 00 O r 1 O+ -t u1 n ON I'- GN M ON r4 M 1* 00 r41,MN ON N I- 00 M O� O r4 N 't r4 O O M M 1- N 00 I\ �D � 00 O & O M I N o � N 00 co N O O O O rn a` u'1 ON O O -4 - Ul M M N 00 O 00 O 41 u1 u1 M 00 H %D 'D r4 %D 00 - r-I I O� N N v 00 b .,4 oN H n n -4 11 r-I � U i-I "4 . 4) N H N •A F p O ww U) •r1 >'a >r W %.D Ln 00 n N 7e I-M e4N00It r-1 r- I'O. v1 r-I %D %D 4 r4 u'1 ON 1� I- 1� %D 00 ON, �D N 00 00 ON �O U1 N %D 'D r4 %D 00 - r-I I O� N N v 00 I-M e4N00It r-1 r- I'O. v1 r-I r-1 r-1 O It 0 ON 00 %D 1- O 'D M N M 00 ON, 1l- to u1 U'1 00 �t M �O 00 u'1 M 00 O kD 00 00 00 r-1 M N n ON r-1 M N 1 f- r-1 It I- M lf1 ON r-I N It M r` r-1 r- I'O. N %D O N 41 N M Cd 11. r` r-1 ' co .,4 11 Cd •rl O W U W � 4) y � •al O 4)Ab "4 4) Qi ra U 4) ul .0 r--1 a, "4 cn 41 cd Cd a) v, G 4 f a .A. Cd . � ( <c 0 w a z° d N )d w o i ul q •r1 U 4) 4) ca p :s O C+ 4) b 4) 34 4) q h0 b U O U U 0 F O Sa (1) W Pa A 41 � rl 4) 0 -A O •r1 } I x w %-� U) > O U) f3 O O z 41 Cd �4 •rI -A W b 41 4) CO 0 -A O b U W U 4) )-1 C: U •r1 U) is U1 O W Cd 04 0 � 1 U 41 N �+ , � 4) 0 4) 4) 4) Gq co H O p. rl H U IU (n Ul 4) " ra U1 U) U) 4) M 8 Cd p Cd Cd 4.4 ca o w 0 0 0 o co Cd 41 oq a 4) 4) U) Cd 41 4) f. 4) ).1 U t~ r-+ r•i U 3 w Q) 4) p w 9 3 b 4) p U p •r1 Cd r1 U 4) z b A U U ca G z U )-1 U a.) H � p cd a b 4) GS w ro :j 0 0 4) 4) co ul ¢ AHH roGv En 4) H04QCY, U U z u W r` 1 1 VILLAGE OF DEERFIELD, ILLINOIS ' NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 ' Summary of Significant Accounting Policies ' The financial statements of the Village of Deerfield, Illinois (government) , , have been prepared in conformity with generally accepted accounting principles (GAAP) as applied to government units. The Governmental Accounting Standards Board (GASB) is the accepted standard - setting body for establishing governmental accounting and financial reporting principles. '. The more significant of the government's accounting policies are described below. A. Reporting Entity In.evaluating how to define the government, for financial reporting purposes, management has considered all potential component units. The '. decision to include a potential component unit.in the reporting entity was made by applying the criteria set forth in GAAP. The basic - -but not the only -- criterion for including a potential component unit within the , reporting entity is the governing body's ability -to exercise oversight responsibility. The most significant manifestation of this ability is financial interdependency. Other, manifestations of the ability to , exercise oversight responsibility include, but are not limited to, the selection of governing authority, the designation of management, the ability to significantly influence operations, and accountability for fiscal matters. A second criterion used in evaluating potential t component units is the scope of public service. Application of this criterion involves considering whether the activity is conducted within the geographic boundaries of the government and is generally available ' to its citizens. A third criterion used to.evaluate potential component units for .inclusion or exclusion from the reporting entity is the existence of special financing relationships, regardless of whether the government.is able to exercise,oversight responsibilities. Based upon. ' the application of these criteria, the following is a brief review of. each potential component unit addressed in defining the government's reporting entity. ' Included within the Reporting Entity: Police Pension Employees Retirement System The government's police employees participate in the Police Pension t Employees Retirement System ( PPERS). PPERS functions for the benefit of these employees and is governed by a five - member pension board. Two members appointed by the government's Mayor, one elected pension beneficiary, and two elected police employees constitute the pension t board. the government and PPERS participants are obligated to fund all PPERS costs based upon actuarial valuations. The state of Illinois is authorized to establish benefit levels and the government is ' 8 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 1. Summary of Significant Accounting Policies (Cont.) A. Reporting Entity (Cont.) Included within the Reporting Entity (Cont.): authorized to approve the actuarial assumptions used in the determination of contribution levels. ' Excluded from the Reporting Entity: West Deerfield Township t Highland Park Mosquito Abatement District Deerfield Park District Deerfield Bannockburn Fire Protection District These potential component units have separate elected boards and provide services to residents, generally within the geographic boundaries of the government. These potential component units are excluded from the t reporting entity because the government does not have the ability to exercise influence over their daily operations, approve budgets or provide funding. 1 Municipal Insurance Cooperative Agency (MICA) ' MICA is an agency established to administer general liability insurance programs for. local governments. Management consists of a Board of Directors comprised of an appointed representative from each member. ' The government does not exercise any control over the activities of the Agency beyond its representation on the Board of Directors. MICA is reported as a governmental joint venture. ' High -Level Excess Liability Pool(HELP) HELP is a proprietary venture established for the purpose of seeking the prevention or lessening of liability claims made against its member municipalities. Management consists of a Board of Directors comprised of one appointed representative from each member. The government does not exercise any control over the activities of the Agency beyond its ' representation on the Board of Directors. HELP is reported as a proprietary joint venture. ' B. Fund Accounting The government uses funds and account groups to report on its financial position and the results of its operations. Fund accounting is designed 9 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL.STATEMENTS APRIL 30, 1990 1. Summary of Significant Accounting Policies (Cont.) B. Fund Accounting (Cont.) to demonstrate legal compliance and to aid financial management by segregating transactions related to certain government functions or activities. A fund is a separate accounting entity with a self - balancing, set of accounts. An account group, on the other hand, is a financial reporting device designed. to provide accountability for: certain assets and liabilities that are not recorded in the funds because they do not directly affect net expendable available financial resources. Funds are classified into the following categories: governmental, proprietary, and fiduciary. Each category, in turn, is divided into separate "fund types ". Governmental funds are used to account for all or most of a government's general activities, including the collection and disbursement of ear- marked monies (special revenue funds), the acquisition or construction of general fixed assets (capital projects funds), and the servicing of general long -term debt (debt service funds). The general fund is used to account for all activities of the general government not accounted for in some other fund. Proprietary funds are used to account for activities. similar to those found in the private sector, where the determination of net income is necessary or useful to sound financial administration. Goods or services from such activities can be provided either to outside parties (enterprise funds) or to other departments or agencies primarily within the government (internal service funds). Fiduciary funds are used to account for assets held on behalf of outside parties, including other governments, or on behalf of other funds within the government. When these assets are held under the terms of a formal trust agreement, either a pension trust fund, or an expendable trust fund is used. The term "expendable" refers to whether or not the government is under an obligation to maintain the trust principal. Agency funds generally are used to account for assets that the government holds on behalf of others as their agent. C. Basis of Accounting The accounting and financial reporting treatment applied to a fund is determined by its measurement focus. All governmental funds and 10 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30,1990 Summary of Significant Accounting Policies (Cont.) C. Basis of Accounting (Cont.) expendable trust funds are accounted for using a current financial resources measurement focus. With this measurement focus, only current assets and current liabilities generally are included on the balance sheet. Operating statements of these funds present increases (i.e., revenues and other financing sources) and decreases (i.e., expenditures and other financing uses) in net current assets. All proprietary funds and pension trust funds are accounted for on a flow of economic resources measurement focus. With this measurement focus, all assets and all liabilities associated with the operation of these funds are included on the balance sheet. Fund equity (i.e., net total assets) is segregated into contributed capital and retained earnings components. Proprietary fund -type operating statements present increases (e.g., revenues) and decreases (e.g., expenses) in net total assets. The modified accrual basis of accounting is used by all governmental fund types, expendable trust funds, and agency funds. Under the modified accrual basis of accounting, revenues are recognized when susceptible to accrual (i.e., when they become both measurable and available). "Measurable" means the amount of the transaction can be determined and "available" means collectible within the current period. The government recognizes property taxes when they become both measurable and available in accordance with GASB Codification Section P70. A one -year availability period is used for revenue recognition for all other governmental fund revenues. Expenditures are recorded when the related fund liability is incurred. Principal and interest on general long -term debt are recorded as fund liabilities when due or when amounts have been accumulated in the debt service fund for payments to be made early in the following year. Those revenues susceptible to accrual are property taxes, franchise taxes, licenses, interest revenue, and charges for services. Sales and income taxes collected and held by the state at year end on behalf of the government also are recognized as revenue. Fines and permits revenues are not susceptible to accrual because generally they are not measurable until received in cash. The accrual basis of accounting is utilized by proprietary fund types, pension trust funds, and nonexpendable trust funds. Under this method, revenues are recorded when earned and expenses are recorded at the time liabilities are incurred. 11 1 1 VILLAGE OF DEERFIELD, ILLINOIS ' NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 Summary of Significant Accounting Policies (Cont.) I C. Basis of Accounting (Cont.) ' The government reports deferred revenue on its combined balance sheet. Deferred revenues arise when a potential revenue does not meet both the "measurable" and "available" criteria for recognition in the current �. period. Deferred revenues also arise when resources are received by the government before it has a legal claim to them, as when grant monies are received prior to the incurrence of qualifying expenditures. In subsequent periods, when both revenue recognition criteria are met, or when the government has a legal claim to the resources, the liability for deferred revenue is removed from the combined balance sheet and revenue is recognized. D. Budgets Budgets are adopted on a basis consistent with generally accepted accounting principles. Annual appropriated budgets are adopted for all of the General, Special Revenue, Debt Service, Enterprise, Internal ' Service and Pension Trust Funds. All annual appropriations lapse at fiscal year. end. Encumbrances represent commitments related to unperformed contracts for goods or services. Encumbrance accounting - -under which purchase orders, contracts and other commitments for the expenditure of resources are recorded to reserve that portion of the applicable appropriation - -is utilized in the governmental funds. Material encumbrances outstanding at year end, if any, are reported as reservations of fund balances and do not constitute expenditures or liabilities because the commitments will be honored during the subsequent year. E. Investments Investments are stated at cost or amortized cost, subject to adjustment J for market declines judged to be other than temporary (lower of cost or market), except for investments in the deferred compensation agency fund I which are reported at market value. F. Short -term Interfund Receivables / Payables During the course of operations, numerous transactions occur between individual funds for goods provided or services rendered. These receiv- ables and payables are classified as "due from other funds" or "due to ' other funds" on the balance sheet. Short -term interfund loans, if any, are classified as "interfund receivables /payables ". 1 12 ' VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS ' APRIL 30, 1990 1. Summary of Significant Accounting Policies (Cont.) G. Inventories Inventories are valued at cost, which approximates market, using the first -in /first -out (FIFO) method. ' H. Fixed Assets and at an estimated historical cost where no historical records exist. Donated fixed assets are valued at their estimated fair market value on the date received. The costs of normal maintenance and repairs that do not add to the value of the asset .or materially extend asset lives are not capitalized. Improvements are capitalized and depreciated over the remaining useful lives of the related fixed assets, as applicable. Depreciation on fixed assets acquired through intergovernmental grants, entitlements, or shared revenues externally restricted to capital acqui- sitions is closed to contributed capital. Public domain ( "infrastructure ") general fixed assets consisting of roads, bridges, curbs and gutters, streets and sidewalks, drainage systems and lighting systems are not capitalized, as these assets are immovable and of value only to the government. Assets in the general fixed assets account group are not depreciated. Depreciation of buildings, equipment, water /sewer systems,. and vehicles in the proprietary fund types is computed using the straight -line method. ' I. Compensated Absences Vested or accumulated vacation leave that is expected to be liquidated ' with expendable available financial resources is reported as an expendi- ture and a fund liability of the governmental fund that will pay it. Amounts of vested or accumulated vacation leave that are not expected to be liquidated with expendable available financial resources are reported in the general long -term debt account group. Vested or accumulated vacation leave of proprietary funds is recorded as an expense and liability of those funds as the benefits accrue to employees. 13 General fixed assets are not construct them. Instead, capitalized in the funds used to acquire or capital acquisition and construction are reflected as expenditures in governmental funds, and the related assets are reported in the general fixed assets account group. All purchased fixed assets are valued at cost where historical records are available and at an estimated historical cost where no historical records exist. Donated fixed assets are valued at their estimated fair market value on the date received. The costs of normal maintenance and repairs that do not add to the value of the asset .or materially extend asset lives are not capitalized. Improvements are capitalized and depreciated over the remaining useful lives of the related fixed assets, as applicable. Depreciation on fixed assets acquired through intergovernmental grants, entitlements, or shared revenues externally restricted to capital acqui- sitions is closed to contributed capital. Public domain ( "infrastructure ") general fixed assets consisting of roads, bridges, curbs and gutters, streets and sidewalks, drainage systems and lighting systems are not capitalized, as these assets are immovable and of value only to the government. Assets in the general fixed assets account group are not depreciated. Depreciation of buildings, equipment, water /sewer systems,. and vehicles in the proprietary fund types is computed using the straight -line method. ' I. Compensated Absences Vested or accumulated vacation leave that is expected to be liquidated ' with expendable available financial resources is reported as an expendi- ture and a fund liability of the governmental fund that will pay it. Amounts of vested or accumulated vacation leave that are not expected to be liquidated with expendable available financial resources are reported in the general long -term debt account group. Vested or accumulated vacation leave of proprietary funds is recorded as an expense and liability of those funds as the benefits accrue to employees. 13 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 1. Summary of Significant Accounting Policies (Cont.) J. Long -Term Obligations Long -term debt is recognized as a liability of a governmental fund when due, or when. resources have been accumulated, in the debt service fund . for payment early in the following year. For other long -term obli- gations, only, that portion expected to be financed from expendable available financial resources is reported as a fund liability of a governmental fund. The remaining portion of such obligations is report- ed in the general long -term debt account group. Long -term liabilities expected to.be financed from proprietary fund.operations are accounted for.in those funds. K. Fund Equity 1 1 1 11. Contributed capital is recorded in proprietary funds that have received capital grants or contributions from developers, customers, or other ' funds. Reserves represent those portions of fund equity not appropri- able for expenditure or legally segregated for a specific future use. Retained Earnings - Reserved.- Restricted Accounts represents amounts required to be segregated by bond ordinance provisions. Designated fund balances represent tentative plans for future use of financial resources. ■i L. Interfund Transactions Quasi - external transactions are accounted for as revenues, expenditures, or expenses. Transactions that constitute reimbursements:to . a fund for expenditures /expenses initially made from it that are properly applic- able to another fund, are recorded as expenditures /expenses in the , reimbursing fund and as reductions of expenditures /expenses in the fund that is reimbursed. All other interfund transactions, except quasi - external transactions and reimbursements, are reported as transfers. Nonrecurring or nonroutine permanent transfers of equity are reported as residual equity transfers. All other interfund transfers are reported as operating.transfers. ' M. Memorandum Only - Total Columns Total columns on the general purpose financial statements are captioned , "memorandum only" to indicate that they are presented only to facilitate financial analysis. Data in these columns do not present financial position, results of operations, or changes in financial position in conformity with generally accepted accounting principles. Neither are such data comparable to a consolidation. Interfund eliminations have not been made in the aggregation of this data. ' 14 1 1 1 1 1 1 1 .11 1 1 r 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 1. Summary of Significant Accounting Policies (Cont.) N. 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 government's financial position and operations. However, comparative data have not been presented in all statements because their inclusion would make certain statements unduly complex and difficult to understand. 2. Legal Compliance and Accountability A. Budgets All departments of the government submit requests for appropriation to the government's manager so that a budget may be prepared. The budget is prepared by fund, function, and activity, and includes information on the past year, current year estimates, and requested appropriations for the next fiscal year. The proposed budget is presented to the governing body for review. The governing body holds public hearings and may add to, subtract from, or change appropriations, but may not change the form of the budget. Any amendments to the budget must be approved by the governing body. Expenditures may not legally exceed budgeted appropriations at the fund level. During the year no supplementary appropriations were necessary. B. Deficit Fund Balances /Retained Earnings of Individual Funds The following funds had a deficit in fund balance /retained earnings as of the date of this report: Fund Illinois Municipal Retirement Fund Tax Incremental Finance District 2 Fund Capital Improvements Series B Fund Garage Fund 15 Deficit Balance $ 157,790 1,099,855 428,389 $ 66,520 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 2. Legal Compliance and Accountability (Cont.) C. Excess of Actual Expenditures /Expenses over Budget in Individual Funds The following funds had an excess of actual expenditures /expenses (exclusive of depreciation and amortization) over budget for the fiscal year: Fund Excess Street and Bridge Fund $ 3,963 Illinois Municipal Retirement Fund 5,740 Refuse Fund 78,550 Garage Fund $20,206 3. Deposits and Investments Permitted Deposits and Investments - Statutes authorize the government to make deposits /invest in commercial banks, savings and loan institutions, obligations.of the U.S. Treasury and U.S. Agencies, obligations of States and their political subdivisions, credit union shares, repurchase agree- ments, commercial paper rated within the three highest classifications by at least two standard rating services, and the Illinois Public Treasurer's Investment Pool. Pension funds may also invest in certain non -U.S. obligations, mortgages, veteran's loans, and life insurance company contracts. 16 1 1 A 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 3. Deposits and Investments (Cont.) A. Deposits At.year -end the carrying amount of the government's deposits totaled $1,122,880,.and the bank balances totaled $1,405,830. 17 Bank Balances Category 1 Deposits covered by federal depository insurance, or by collateral held by the government, or its agent, in the government's name. $ 368,228 Category 2 Deposits covered by collateral held by the pledging financial institution's trust department, or by its agent, in the government's name. Category 3 Deposits covered by collateral held by the pledging financial institution, or its trust department, or its agent but not in the government's name, and de- posits which are uninsured and uncol- lateralized. 1.037.602 Total Deposits $1.4_ 0 Deposits classified as Category 3 are entirely composed of deposits which are uninsured and uncollateralized. For pension trust funds there are no deposits classified as Category 3. 17 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 3. Deposits and Investments (Cont.) B. Investments 1 1 1 The government's investments are categorized to give an indication of the' level of risk assumed by the entity at year -end. Category 1 includes investments. that are insured or registered or for which the securities are held by the government or its agent in the government's name. Category 2 ' includes uninsured and unregistered investments for which the securities are held by the counterparty's trust department or agent in the government's name. Category 3 includes uninsured and unregistered investments for. which �. the securities are held by the broker or dealer, or by its trust department or agent but not in the government's name, and uninsured, unregistered and uncollateralized investments. U,S. Government Securities Life Insurance Co. Contract GNMA Dade County Florida Aviation Reserve Bonds Carrying Amount Category Market 1 2 2 Totals Value $10,711,265 10,711,265 12,576,,655 1,604,556 10,000,000 470,000 470,000 630,469 1,604,556 1,604,556 Guaranteed Investment Contract 250,000 Commercial Paper 2,029,271. $24,345,092 720,000 * Deferred Compensation Plan Assets * Illinois Public Treasurer's Investment Pool Total Investments * (Not Subject to Risk Categorization) 18 10,000,000 10,728,280 250,000 250,961 2,029,271 2.029.536, 25,065,092 27,820,457 1,035,976 1,035,976 8,889.571 8.889,571 ' 34,990.639 37,746,004 1 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 3. Deposits and Investments (Cont.) B. Investments (Cont.) The pension trust fund owns approximately 21 percent of the investments in Category 1 and 100 percent of the investments in Category 3. 4. Receivables - Taxes Property taxes for 1989 attach as an enforceable lien on January 1,, 1919, on property values assessed as of the same date. Taxes are levied by December of the subsequent fiscal year (by passage of a Tax Levy Ordinance) . Tax bills are prepared by the County and issued on or about.April 30, 1990, and are payable in two installments, on or about June 1, 1990, and September 1, 1990. The County collects.such taxes and remits them periodically, 5. Fixed Assets 1 A. General Fixed Assets Account Group ' The government has restated the beginning asset balances in the General Fixed Assets Account Group to reflect land previously purchased by the government but not included in the Account Group. $6,817,860 4,26® 1,228,480 9,853,508 19 As Reported Charges due to As Restated April 30, 1989 Restatement April 30, 1989 Land $2,609,522 1,000,000 3,609,522 Building and Improvements 1,314,850 1,314,850 Vehicles 521,237 521,237 Equipment 1,372,251 1,372,251. 55,8®17,860 1,00 6,817 860 The following g is a summary umma y of changes in the general fixed assets account group during the fiscal year: Balances Balances May 1 Additions Retirements April 30 Land $3,609,522 310,081 1,000,000 2,919,603 Building and 1 Improvements Vehicles 1,314,850 521,237 3,562,008 72,000 271,510 134,897 4,804,858 657,850 Equipment 1,372,251 120,529 21,583 1,471,197 . $6,817,860 4,26® 1,228,480 9,853,508 19 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 5. Fixed Assets (Cont.) B. Proprietary Fixed Assets The following is a summary of proprietary fund -type fixed assets as of the date of this report: Warwick Road Pumping Station Access Avenue 3 Brickyard Park Development 'Brickyard Park Grading $1,561,764 1,333,558 215,442 - Enterprise 353,400 - - 32,500 Funds Land $ 77,500 Systems 11,358,625 Equipment and Vehicles 623,163 Parking Lot 613,958 12,673,246 Less Accumulated Depreciation 3,440,352 S 9,232,894 In proprietary funds, the following estimated useful lives are used to compute depreciation: Buildings 40 -50 years Machinery and Equipment 10 -20 years Vehicles 4 -5 years Water /Sewer System 50 -60 years C. Construction Contracts The government has entered into contracts for the construction or renovation of various facilities as follows: Required Project Expended Further. Authorization To Date Commitment Financing Warwick Road Pumping Station Access Avenue 3 Brickyard Park Development 'Brickyard Park Grading $1,561,764 1,333,558 215,442 - 353,400 353,400 - - 32,500 32,500 - - $ 14,100 14,100 - - 1 1 1 1 1 1 l 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 5. Fixed Assets (Cont.) C. Construction Contracts (Cont.) Project Expended Authorization To Date Commuter Parking Lot $ 111,897 111,897 Pedestrian Bridge Improvements 1989 Street Rehab- ilitation Pfingsten /Kates Road Extension Phase 2B Sanitary Sewer 6. Risk Management Required Further Commitment Financing 187,160 - 187,160 - 70,938 70,938 - - 816,009 816,009 - - $3,496,464 3,399,253 97,211 - A. The government has purchased medical- insurance from private insurance companies. Premiums have been displayed as expenditures /expenses in appropriate funds. B. Municipal Insurance Cooperative Agency (MICA) The government participates in the Municipal Insurance Cooperative Agency. MICA is a governmental joint venture whose members are Illinois municipalities. MICA manages and funds first party property losses, third party liability claims. workers' compensation claims, and public officials liability claims of its members. The government's payments to MICA are displayed on the financial statements as expenditures /expenses in appropriate funds. C. High -Level Excess Liability Pool (HELP) The government participates in the High -Level Excess Liability Pool (HELP). HELP is a joint venture established by certain municipalities in Illinois to provide excess liability coverage ($5,000,000 of coverage after a $1,000,000 self - insurance retention). The government's payments to HELP are displayed on the financial statements as expenditures /expenses in appropriate funds. 21 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 7. Lease Obligations i No material capital or operating leases were in effect as of the date of this report. 8. Long -Term Debt A. General Obligation Bonds The government issues general obligation bonds to provide funds for the acquisition and construction of major capital facilities. General obligation bonds are direct obligations and pledge the full faith and credit of the government. General obligation bonds currently outstanding are as follows: Fund Debt Balances Balances Issue Retired by May 1 Issuances Retirements. April 30 Sewerage Improvement Bond Series of 1973 ($1,080,000 dated June 1, 1973; mat- uring December 1, 1992; payable in annual installments; interest rates from Debt 4.4% to 5.1%) Service $250,000 75,000 175,000 Sewer Treatment Facility Bond Series of 1973; ($2,000,000 dated June 1, 1973; maturing December 1, - 1992; payable in annual installments; interest rates from Debt 4.41 to 6.0%) Service 550,000 125,000 425,000 Corporate Purpose Bond Series of 1982; ($500,000 dated Oct- t ober 1, 1982; matur- ing December 1, 1994; payable in annual in- stallments; interest ' rates from 4.4X to Debt 6.0%) Service 375,000 50,000 325,000 Corporate Purpose Bond Series of 1982 -A; ($500,000 dated Dec- ember 1, 1982; matur- ing December 1, 1993; payable in annual in- stallments; interest rates from 7.0% to Debt 8.5%) Service $250,000 50,000 200,000 i 22 t 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 8. Long -Term Debt (Cont.) A. General Obligation Bonds (Cont.) Issue Corporate Purpose Bond Series of 1986; ($11,000,000 dated May 1, 1986; maturing January 1, 2005; payable in annual installments; interest rates from 6.40% to 7.75%) Corporate Purpose Bond Series of 1987; ($10,000,000 dated October 8, 1987; mat- uring October.8, 2002; interest rate from 8.4% to 8.5%) General Obligation Bond Series of 1988; ($3,000,000 dated Nov- ember 1, 1988; maturing January 1, 2004; payable in annual installments; interest rates from 6.7% Fund Debt Balances Balances Retired By May 1 Issuances Retirements April 30 Debt Service $10,600,000 300,000 10,300,000 *Expendable Trust 10,000,000 10,000,000 Debt. to 8.0%) Service 3,000,000 100,000 2,900,000. $25,025,000 - 700,000 24,325,000 * These bonds were issued in Fiscal 1988 with the proceeds used to purchase $10,000,000 of Dade County Florida Aviation Reserve Bonds. These bonds are carried as an investment in the Expendable Trust Fund with the interest on these bonds paying the interest on the G.O. bonds. 23 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 8. Long -Term Debt (Cont.) B. Debt Service Requirements to Maturity Annual debt service requirements to maturity are as follows: Fiscal Year Ending April 30 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 Total Principal and Interest Interest.Portion General Obligation Bonds General. Expendable Long -Term Trust Debt Totals $ 843,000 1,817,600 2,660,600 843,000 1,827,450 2,670,450 843,000 1,827,212 2,670,212 843,000 .1,586,475 2,429,475 843,000 1,528,262 2,371,262 843,000 1,430,993 2,273,993 843,000 1,447,497 2,290,497 843,000 1,443,997 2,286,997 843,000 1,442,037 2,285,037 843,000 1,429,950 2,272,950 843,000 1,438,650 2,281,650 7,549,000 1,446,200 8,995,200 3,127,500 11454,513 4,.582,013 . 1,432,050 1,432,050 1,115,538 1,115,538 _19,949,500 22,6® 42,6® 4 $ 9,949,500 8,343,424 18,2® 9 ®24 24 1 VILLAGE OF DEERFIELD,. ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 M 8. Long -Term Debt (Cont.) C. Changes in Long -Term Liabilities During the fiscal year the following changes occurred in liabilities reported in the general long -term debt account group: Balances Balances May Additions Reductions April 30 Sewerage Improvement Bond Series of 1973 $ 250,000 75,000 175,000 Sewerage Treatment Facility Bond Series of 1973 550,000 125,000 425,000 Corporate Purpose Bond Series of 1982 375,000 50,000 325,000 Corporate Purpose Bond Series of 1982 -A 250,000 50,000 200,000 Corporate Purpose Bond Series of 1986 10,600,000 300,000 10,300,000 Corporate Purpose Bond Series of 1988 3,000,000 100,000 2,900,000 $15,025,000 - 700,000 14,325,000 f t 1 1 D. Legal Debt Margin The government 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. 25 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 8. Long -Term Debt (Cont.) E. Noncommitment Debt Industrial Development Revenue Bonds The government qualifies as a Home Rule Unit under Section 6(a) of Article VII of the 1970 Constitution of Illinois and, under the powers granted by this section, can exercise any power and perform any function pertaining to its government and affairs which is not prohibited by the Illinois Revised Statutes. The issuance of Industrial Development Revenue Bonds by the government is to finance in whole or in part the cost of the acquisition, purchase, construction, reconstruction,. improvement, equipping, betterment or extension of any economic development project in order to encourage economic development within or near the government. Industrial development Revenue.Bonds are not a debt of the government. The entity using the bond proceeds to finance a construction or improvement project is liable for the bonds. Since the government does not act' as an agent for Industrial Development Revenue Bonds, the transactions relating to the bonds and property do not appear in the government's financial statements. The government has authorized the issuance of the following such bonds: Date Issued Type of Bond Amount Debtor 12/20/82 Industrial Revenue $1,615,000 Chi -Chi's Inc. 4/16/84 Industrial Revenue 1,000,000 Teradyne, Inc. 12/17/84 Industrial Revenue 4,500,000 Industrialplex Limited Partnership F. Operating Transfers Operating transfers do not tie out due to the $4,416 transferred to the General Fund and $57,324 transferred to the Public Benefit Fund from the Special Assessment Fund (Agency Fund). 26 1 1 f 1 1 1 1 1 1 1 1 1 f 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 9. Interfund Assets /Liabilities Due From /To Other Funds Receivable Fund Payable Fund Amount General Tax Increment Finance District #2 $ 820,000 Municipal Audit Street and Bridge 59 Illinois Municipal Retirement Library 4,102 Illinois Municipal Retirement Street and Bridge 6,691 Illinois Municipal Retirement Debt Service 2,521 Tax Increment. Finance District #1 Municipal Audit 2,650 Tax Increment Finance District #1 Emergency Services Disaster 2,239 Tax Increment Finance District #1 Library 989 Tax Increment Finance District #1 Street and Bridge 16,394 Tax Increment Finance District #1 Illinois Municipal Retirement 9,364 Tax Increment Finance District #1 Debt Service 60,608 Tax Increment Finance District #1 Refuse 19,240 Tax Increment Finance District #1 Police Pension 8,571 Brickyards Development Tax Increment Finance District #1 170,000 Sewerage General 5,441 Refuse Emergency Services/ Disaster 42 Refuse Street and Bridge 529 Refuse Police Pension 1,046 Deposit General 6,928 27 $1,137,414 � VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 10. Commitments High -Level Excess liability Pool (HELP) The government has committed to purchase excess liability insurance from the High -Level Excess Liability Pool (Agency), a joint venture of Illinois municipalities. The government expects to pay the following minimum amounts (these amounts represent the government's share of the principal and interest - "fixed costs" - of the Agency): Year Ending Amount 1991 $24,398 1992 25,352 1993 25,263 1994 25,094 1995 25,744 1996. 26,258 1997 25,731 1998 $26,024 These amounts have been calculated using the government's current allocation percentage of 3.61 %. In future years this allocation percentage will be subject to change, because the Agency's Agreement provides that each year Members will be assessed based upon a formula which specifies the following four criteria for allocating premium costs: Miles of Streets Full -Time Equivalent Employees Number of Motor Vehicles Operating Revenues 28 1 1 1 1 1 1 1 1 1 1 1 1 1 f r a i VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 11. Segment Information - Enterprise Funds The government maintains the following enterprise funds which are intended to be self- supporting through user fees charged for services to the public. Financial segment information as of the date of this report and for the fiscal year is as follows: Operating Revenues Depreciation, and Amortization Expense Operating Income (Loss) Operating Grants, Entitlements, and Shared Revenues Operating Transfers In Operating Transfers Out Tax Revenues Net Income (Loss) Current Capital Contributions Current Capital Transfers Plant, Property, and Equipment Additions Deletions Total Assets Net Working Capital Bonds and Other Long -Term Liabilities Payable from Operating Revenues Payable from Other Sources Total-Equity 09 Commuter Water Sewerage Refuse Parking Lot Fund Fund Fund Fund Totals $2,174,819 1,239,397 601,450 125,398 4,141,064 104,125 241,234 - 30,698 376,057 181,001 (163,706) (673,450) 64,975. (591,180) 33,000 30,000 - 40,000 103,000 - - 621,687 - 621,687 252,881 (103,059) (46,826) 24,975 127,971 229,510 3,669 - - 233,179 4,512,098 8,056,423 677,079 669,230 13,914,830 1,953,317 1,476,050 500,769 311,948 4,242,084 $4,377,903 7,928,396 500,769 667,910 13,474,978 09 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 12. Contributed Capital During the year contributed capital increased /decreased by the following amounts: 13. Fund Equity A. Prior Period Adjustments During the fiscal year prior period adjustments were made as follows: Amount Water Fund To correct for prior year's error in accounting for accounts receivable. 150 000 B. Residual Equity Transfer During the fiscal year the General Fund received a residual equity transfer from the General Fixed Assets Account Group in the amount of $1,000,000. Therefore, the residual equity transfers do not "net" tc zero since Account Groups do not present transfers for financial reporting purposes. 30 Commuter Water Sewerage Parking Lot Fund Fund Fund Increases - - - Decreases Depreciation $ 45,929 118.807 27,027 Net Increase (Decrease) (45,929) (118,807) (27,027) Contributed. Capital May 1 1,913,458 6,260,411 352,213 . April 30 $1,8® 6,141,604 325,186 13. Fund Equity A. Prior Period Adjustments During the fiscal year prior period adjustments were made as follows: Amount Water Fund To correct for prior year's error in accounting for accounts receivable. 150 000 B. Residual Equity Transfer During the fiscal year the General Fund received a residual equity transfer from the General Fixed Assets Account Group in the amount of $1,000,000. Therefore, the residual equity transfers do not "net" tc zero since Account Groups do not present transfers for financial reporting purposes. 30 i1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 14. Contingent Liabilities A. Litigation The government is a defendant in various lawsuits. Although the out- come of these lawsuits is not presently determinable, in the opinion of the government's attorney the resolution of these matters will not have a material adverse effect on the financial condition of the government. B. Grants Amounts received or receivable from grantor agencies are subject to audit and adjustment by grantor agencies, principally the federal government. Any disallowed claims, including amounts already col- lected, may constitute a liability of the applicable funds. The amount, if any, of expenditures which may be disallowed by the grantor cannot be determined at this time although the government expects such amounts, if any, to be immaterial. C. High -Level Excess Liability Pool (HELP) The government's agreement with the High -Level Excess Liability Pool provides that each member is liable for its proportionate share of any costs arising from defaults in payment obligations by other members. 15. Subsequent Events There were no material subsequent events. ' 16. Joint Ventures 1 1 A. Municipal Insurance Cooperative Association (MICA) Description of Joint Venture The Municipal Insurance Cooperative Association (MICA) is a governmental joint venture established by certain units of local government in Illinois to administer some or all of their general liability insurance programs. Management consists of a Board of Directors comprised of one appointed representative from each member. In addition, there are three officers, a Benefit Administrator and a Treasurer. The government does not exercise any control over activities of MICA beyond its representation on the Board of Directors. MICA functions solely as an administrative agent for each member. 31 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 16. Joint Ventures (Cont.) A. Municipal Insurance Cooperative Association (MICA) (Cont.) Summary Financial Information of Joint Venture The latest available financial statements of the Cooperative, dated April 30, 1989, show the following: Total Total Assets $1,3.. 6 Total Liabilities 568,138 Total Equity 792,002 Total Liabilities and Equity X$1,36® B. High -Level Excess Liability Pool (HELP) Description of Joint Venture Government's Share 315,586 131,822 183.764 315,586 The High -Level Excess Liability Pool (the "Agency ") is a proprietary joint venture and was organized on April 1, 1987, The purpose of the Agency is to act as a joint self- insurance pool for the purpose of seeking the prevention or lessening of liability claims for injuries to persons or property or claims for errors and omissions made against the Members and other parties included within the scope of coverage of the Agency. 32 1 1 1 1 1 11 1 1 t 1 n VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 16. Joint Ventures (Cont.) B. High -Level Excess Liability Pool (HELP) Description of Joint Venture (Cont.) At the date of this report, the following municipalities were members of the Agency: Share Share Village of Arlington Heights 11..78$ Village of Mt. Prospect 7.50% Village of Chicago Ridge 2.17 Village of Oak Lawn 9.79 Village of Deerfield 3.61 City of Park Ridge 5.83 City of Des Plaines 10.92 Village of Skokie 10.32 Village of Elk Grove Village 7.74 Village of Streamwood 4.29. Village of Glenview 6.35 City of Wheaton 7.15 Village of Hoffman Estates 6.78 Village of Winnetka 4.41 Village of Lincolnshire 1.36 100.00% These percentage shares are subject to change in future years based upon a formula specified in the Agency Agreement. The Agency is governed by a Board of Directors which consists of one appointed representative from each member municipality. Each Director has an equal vote. The officers of the Agency are appointed by the Board of Directors. The Board of Directors determines the general policy of the Agency, makes all appropriations, approves contracts, adopts resolutions providing for the issuance of debt by the Agency, adopts by -laws, rules and regulations, and exercises such powers and performs such duties as may be prescribed in the Agency Agreement or the by -laws. The government does not exercise any control over the activities of the Agency beyond its representation on the Board of Directors. 33 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 i 16. Joint Ventures (Cont.) i B. High -Level Excess Liability Pool (HELP) (Cont.) Summary Financial Information of Joint Venture Summary of Financial Position as of April 30, 1990: i Assets Liabilities and Fund Equity Current Assets Current Liabilities ;Cash and Investments Accounts Payable 16,301 Unrestricted $2,326,749 Due to Village of Escrow Agreement 5.635.173 Elk Grove Village 400,000 7,961,922 Accrued Interest Payable 126,437 ,Receivables Deferred Revenues 529.455 Accounts 107,875 1,072,193 Long -Term Liabil- ities Rebate Payable 96,078 Due to Village of Elk Grove Village 3..875.000 3,971,078 Total Liabil- ities� 5,043,271 Fund Equity Retained Earnings 3,026,526 Total Liabil- ities and Total Assets S8,0® Fund:Equity 8,069,797 34 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 16. Joint Ventures (Cont.) B. High -Level Excess Liability Pool (HELP) (Cont.) Summary Financial Information of Joint Venture (Cont.) Summary of Revenues, Expenses, and Changes in Retained Earnings for the year ended April 30, 1990: Operating Revenues $ 964,059 Operating Expenses 33375 Operating Income 930,684 Nonoperating Revenues (Expenses) Interest Income 510,632 Interest Expense (287,542) Claims Adjustments 50,000 273,090 Net Income 1,203,774 Retained Earnings May 1 1,822,752 April 30 $3,0 35 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 I i I I 16. Joint!Ventures (Cont.) B. High -Level Excess Liability Pool (HELP) (Cont.) Summary Financial Information of Joint Venture (Copt.) Government's Share of Assets, Liabilities, Fund Equity and Changes !for the year ended April 30, 1990: I Balances Increases Balances May 1 (Decreases) AARril 30 I Total Assets $255,752 3® 29 0 !Total Liabilities 191,088 (9,026) 182,062 1,Fund Equity Retained Earnings 64.664 44.594 109.258 Total Liabilities ! i and Fund Equity $255,752 3® 29 Government's Share of Net Income 44,594 J I oint Venture Debt - Changes in Long -Term Debt Balances Balances May 1 Issuances Retirements April 30 Due to Village of (Elk Grove Village Retirement of !General Obligation (Bonds S4,6® 375,000 4,24,2® i I 36 �1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 16. Joint Ventures (Cont.) It B. High -Level Excess Liability Pool (HELP) (Cont.) Joint Venture Debt - Security for the Debt The Village of Elk Grove Village, Illinois (the initial Host Member) issued $5,000,000 of general obligation bonds in 1987 to provide initial funding for the Agency. The bond proceeds were put into escrow with LaSalle National Bank as escrow agent. An intergovernmental agreement among the Agency, the Village of Elk Grove Village, and the Members provides that the Agency and its Members are obligated to the Village of Elk Grove Village for payment of principal and interest on the bonds until such bonds have been retired. Additionally each Member is liable for its proportionate share of any default by other Members. The obligations of the Agency and its Members are unconditional. 17. Deferred Compensation Plan The government offers its employees a deferred compensation plan created in accordance with Internal Revenue Code Section 457. The plan, available to all government employees, permits them to defer a portion of their salary until future years. Participation in the plan is optional. The deferred compensation is not available to employees until termination, retirement, death or unforeseeable emergency. All amounts of compensation deferred under the plan, all property and rights purchased with those amounts, and all income attributable to those amounts, property, or rights are (until paid or made available to the employee or other beneficiary) solely the property and rights of the government subject only to the claims of the government's general creditors. Participants' rights under the plan are equal to those of general creditors of the government in an amount equal to the fair market value of the deferred account for each participant. It is the opinion of the government's legal counsel that the government has no liability for losses under the plan but does have the duty of due care that would be required of an ordinary prudent investor. The government believes that it is unlikely that it will use the assets to satisfy the claims of general creditors in the future. 18. Post - Employment Health Care Benefits In addition to providing pension benefits, the government provides certain health care and life insurance benefits for all retired employees. Substantially all of the government's employees may become eligible for those benefits if they reach normal retirement age while working for the government. The cost of retiree health care and life insurance benefits is recognized as an expenditure as claims are paid. For the fiscal year those 37 r7 LI 19. VILLAGE OF,DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 Employee Retirement Systems (Cont.) B. Summary of Significant Accounting Policies and Plan Asset Matters Basis of Accounting The financial statements are prepared using the accrual basis of accounting. Employee and employer contributions are recognized as revenues in the period in which employee services are performed. Method Used to Value Investments Fixed - income securities are reported at amortized cost with discounts or premiums amortized using the effective interest rate method, subject to adjustment for market declines judged to be other than temporary (lower of cost or market). Investment income is recognized as earned. Gains and losses on sales and exchanges of fixed - income securities are recognized on the transaction date. Equity securities are reported at cost subject to adjustment for market declines judged to be other than temporary (lower of cost or market). Significant Investments There are no investments (other than U.S. government and U.S. government- guaranteed obligations) in any one organization that represent 5 percent or more of net assets available for benefits. Related Party Transactions There are no securities of the employer or any other related parties included in plan assets, including any loans. C. Funding Status and Progress The amount shown below as the "pension benefit obligation" is a standardized disclosure measure of the present value of pension benefits, adjusted for the effects of projected salary increases and step -rate benefits, estimated to be payable in the future as a result of employee service to date. The measure is intended to help users assess the funding status of the system on a going- concern basis, assess progress made in accumulating sufficient assets to pay benefits when due, and make comparisons among employers. The measure is the actuarial present value of credited protected benefits and is independent of the funding method used to determine contributions to the System. 40 1 i 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 i 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 19. Employee Retirement Systems (Cont.) C. Funding Status and Progress (Cont.) Illinois Municipal Retirement December 31, Actuarial Valuation Date 1989 Significant Actuarial Assumptions a) Rate of Return on Invest- 7.008 ment of Present and compounded Future Assets annually b) Projected Salary 3.75% Increases - Attribut- compounded able to Inflation annually c) Additional Projected Salary Increases - Attributable.to Seniority /Merit 1.008 d) Postretirement Benefit 3.008 Increases 41 Police Pension April 30, 1990 9.00% compounded annually 6.50% compounded annually (Note - separate information for b) and c) not available 3.008 simple interest annually VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 19. Employee Retirement Systems (Cont.) C. Funding Status and Progress (Cont.) Pension Benefit Obligation Retirees and Beneficiaries Currently Receiving Benefits and Terminated Employees not yet Receiving Benefits Current Employees Accumulated Employee Contributions Including Allocated Investment Earnings Employer - Financed Vested Employer - Financed Nonvested Total Pension Benefit Obligation Net Assets Available for Benefits, at Lower of Cost or Market (Market Values) (IMRF - $1,940,684) (Police - 6.765,847) (Totals $8,7) Unfunded (Assets in Excess of) Pension Benefit Obligation Illinois Municipal Retirement (Note) $ 61,615 Police Pension Totals 1,969,842 2,031,457 984,960 908,740 1,893,700 2,191,472 2,309,251 4,500,723 251.460 54.790 306.250 3,489,507 5,242,623 8,732,130 1,770.910 6.425,063 8.195.973 $1,718,597 (1,182,440) 536,157 (Note) The pension benefit obligation applicable to retirees and beneficiaries currently receiving benefits is not included in the above schedule due to the fact that this obligation was transferred from the government to IMRF as a whole when the annuity became payable. 42 1 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 19. Employee Retirement Systems (Cont.) C. Funding Status and Progress (Cont.) Effects on the Pension Benefit Obligation of Current -Year Changes Illinois Municipal Retirement 1 r 43 Current -year changes in the actuarial assumptions, benefit provisions and methodology are reflected in the pension benefit obligation shown above. This amount has been calculated by the System's actuary using the measure described above. The dollar effect of these changes on the pension benefit obligation was not economically determinable on an individual employer basis by IMRF. ' Police Pension There have been no current -year changes in the actuarial assumptions and benefit provisions. D. Contributions Required and Contributions Made Illinois Municipal Retirement and Police Pension The Systems' funding policy provides for actuarially determined peri- odic contributions at rates that, for individual employees, accumulate assets gradually over time so that sufficient assets will be available to pay benefits when due. The rate for the government's employee group as a whole has tended to remain level as a percentage of annual covered payroll. The contributions rate for normal cost is determined using the entry age normal actuarial funding method. The IMRF System used the level percentage of payroll method, while the Police Pension System used a level dollar amount method to amortize the unfunded liability over a 40 year period. The significant actuarial assumptions used to compute the actuarially determined contribution requirements are the same as those used to compute the pension benefit obligation as described in C. above. 1 r 43 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 19. Employee Retirement Systems (Cont.) D. Contributions Required and Contributions Made (Cont.) Illinois Municipal Police Retirement Pension December 31, April 30, Actuarial Valuation date 1989 1990 Actuarially Determined Contri- bution Requirement - Employer As a Dollar Amount Normal Cost Amortization of Unfunded Actu- arial Accrued Liability Death and Disability Cost As a % of Current Covered Payroll Normal Cost Amortization of Unfunded Actu- arial Accrued Liability Death and Disability Cost Contribution Made As a Dollar Amount Employer Employee As a % of Current Covered Payroll Totals $182,969 89,776 272,745 64,856 43,837 108,693 18.455 18.455 26 133,613 399,®893 6.94% 6.2% 2.46 3.0 .70 10.10% _% 266,280 160,461 426,741 118,539 127,777 246,316 $384,819 288,238 673,057 Employer 10.10% 11.00% Employee 4.50 9.00 1_% 19.75% Effects on the Contribution Requirements of Current -Year Changes Illinois Municipal Retirement Current -year changes in the actuarial assumptions, benefit provisions, and methodology, are incorporated in the 1990 to 1991 employer contribution rates. Separate dollar effects of each change were not economically determinable on an individual employer basis by IMRF. 44 1 1 45 VILLAGE OF DEERFIELD, ILLINOIS NOTES TO THE FINANCIAL STATEMENTS APRIL 30, 1990 19. Employee Retirement Systems (Cont.) Y Y D. Contributions Required and Contributions Made (Cont.) Police Pension ' There have been no current -year changes in the actuarial assumptions, actuarial funding method, or benefit provisions. E. Trend Information Trend information gives an indication of the progress made in accumulating sufficient assets to pay benefits when due. Ten -year trend information may be found in the supplemental section of the government's annual financial report. ' Illinois Municipal Police Year Retirement Pension Totals Net Assets Available for Bene- 1988 55.29% 118.00% fits As a % of the Pension 1989 47.44% 118.00% Benefit Obligation (PBO) 1990 50.75% 123.00% Unfunded (Assets in Excess of) PBO As a % of Annual Covered Payroll (Expressing the unfunded pension benefit obligation as a percentage of annual covered payroll approximately adjusts 1988 63.00% (62.00)$ for the effects of inflation 1989 65.21% (63.00)$ for analysis purposes) 1990 65.19% (81.00)% Employer Contributions As a % of Annual Covered 1988 8.21% 12.05% Payroll 1989 8.08% 11.26% 1 1990 10.10% 11.00% Required 1988 $179,472 139,841 319,313 1989 204,352 142,707 347,059 1990 266,280 133,613 399,893 Made 1988 179,472 150,024 329,496 1989 204,352 155,430 358,752 1990 $266,280 160,461 426,741 1 45 1 1 1 1 1 1 1 J I 1 1 1 1 1 1 1 GOVERNMENTAL FUND TYPES 1 I 1 1 1 1 1 1 Ll 1 1 1 L� 1 L1 I 1 1 I 1 h L I 1 1 1 1 1 1 1 1 F-J, 1 1 1 GENERAL FUND 1 1 1 1 1 1 1 GENERAL FUND fl General Fund - (also referred to as the Corporate Fund) To account for resources traditionally associated with governmental services not required to be accounted for in another fund. n 1 1 C 1 1 1 1 1 1 1 1 1 1 1 LA 1 1 1 1 1 1 1 t 1 1 Ll 1 1 t 1 1 1 1 1 1 1 1 1 1 C 1 t 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND BALANCE SHEET APRIL 30, 1990 ASSETS Cash and Investments Receivables Accrued Interest Other Due from Other Governments Sales Tax State Income Tax Court Fines Due from Other Funds Inventory Investment in Joint Venture - HELP Total Assets LIABILITIES AND FUND BALANCE Liabilities Accounts Payable Accrued Payroll Contracts Payable Compensated Absences Payable Other Payables Due to Other Funds Total Liabilities Fund Balance Reserved for Long -Term Interfund Receivable Reserved for Inventory Reserved for Investment in Joint Venture - HELP Unreserved Designated - Capital Improvements Undesignated Total Fund Balance Total Liabilities and Fund Balance 46 1990 1989 $5,535,886 3,418,096 63,064 9,778 68,855 98,225 129,962 123,218 78,752 69,770 21,123 13,144 820,000 828,188 12,780 4,6 67.958 40.221 6,798,380 _ 4.600 95,551 109,721 70,899 54,008 67,958 892 295,208 297,917 6,363 6,390 12.369 1.779 480.390 470.707 820,000 820,000 12,780 67,958 40,221 3,500,000 1,000,000 1.917.252 2.269.712 6.317.990 4.129.933 $6,798,380 4,6 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 Expenditures General Government 1990 1,377,270 1989 Public Safety Budget Actual Actual Revenues 4,283,542 4,023,661 3,743,910 Taxes $3,345,000 3,304,093 3,277,477 Licenses and Permits 225,000 191,498 467,923 Intergovernmental 8,000 9,208 7,164 Charges for Services 95,000 105,522 100,539 Fines and Forfeits 220,000 254,610 206,902 Interest 200,000 372,140 246,984 Miscellaneous 207,000 903.283 242,720 Total Revenues 4,300,000 5,140,354 4,549,709 Expenditures General Government 1,391,180 1,377,270 .1,384,532 Public Safety 2,892,362 2,646,391 2,359,378 Total Expenditures 4,283,542 4,023,661 3,743,910 Excess (Deficiency) of Revenues over Expenditures 16,458 1,116,693 805,759 Other Financial Sources (Uses) Operating Transfers In (Out) Youth Bound Fund (4,000) (4,000) (4,000) Motor Fuel Tax Fund (6,213) Transportation Fund (2,000) (2,000) (2,000) Tax Incremental Finance District 2 Fund (75,000) (47,649) (50,922) Special Assessment Fund 4,416 (81,000) (49,233) (63,135) Excess (Deficiency) of Revenues and Other Financing Sources over Expen- ditures and Other Financing Uses $$ (64,542) 1,067,460 742,624 Fund Balance May 1 4,129,933 3,406,585 Prior Period Adjustments (19,276) Residual Equity Transfer In 1,120,597 Adjusted Balance 5,250,530 3,387,309 April 30 6,317,990 4,129,933 See accompanying Notes to the Financial Statements. 47 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 A 1 1 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND SCHEDULE OF REVENUES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 Budget Actual Taxes Property Taxes - General Sales Tax $2,160,000 2,012,188 Income Tax 560,000 587,918 Hotel Motel Tax 625,000 674,367 Photofinishing Tax 29.620 3.345.000 3.304.093 Licenses and Permits Beer /Liquor Licenses 48,000 47,625 Food Licenses 4,500 4,202 Other Business Licenses 9,000 9,760 Building Permits 125,000 93,818 Animal Licenses 6,500 6,687 Non - Business Licenses and Permits 32.000 29.406 225.000 191.498 Intergovernmental State Grants 8.000 9.208 Charges for Services Special Police Services 44,000 55,748 Transfer Charges 45,000 45,000 Engineering Charges 6.000 4.774 95.000 105.522 Fines and Forfeits 220.000 254.610 Interest 200.000 372.140 Miscellaneous False Alarms 28,000 53,420 Sale of Materials 2,018 Rentals 33,500 45,827 Miscellaneous 20,500 4,630 Franchise Fees 125,000 142,962 Income from Joint Venture 27,737 Sale of Land 589,821 Sale of Fixed Assets 36.868 207.000 903.283 Total Revenues $4,300,000 5.14 —_ 48 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 General Government Administration Department Salaries Overtime Part -Time Employee Benefits Professional Services Travel, Training and Dues Printing and Advertising Communications Insurance Contractual Services Utility Services Motor Vehicle Maintenance Repairs and Maintenance Equipment Rental Rental Property Repairs Miscellaneous Supplies Materials Motor Vehicle Supplies Housing Assistance Apparel Small Tools and Equipment Equipment Office Furniture Total General Government Public Safety Police Department Administrative Service Salaries Overtime Part -Time Employee Benefits Professional Services Travel, Training and Dues Printing and Advertising Communications Insurance Contractual Services Motor Vehicle Maintenance Repairs and Maintenance 49 Budget Actual $ 683,280 677,734 11,000 14,386 95,000 74,092 110,400 82,781 154,000 175,803 19,500 19,828 12,000 16,458 24,700 19,737 71,600 61,094 60,000 73,866 2,500 3,062 6,000 5,386 25,500 6,814 588 4,000 1,391 35,000 41,572 23,500 29,597 2,000 66 2,000 793. 38,000 27,200 200 288 1,000 10,000 42,583 2,151 1,391.180 1,377,270 439,700 416,761 3,500 3,261 28,500 12,204 63,800 37,937 5,500 3,253 5,800 2,677 6,400 7,988 32,100 25,562 141,300 112,278 45,400 28,750 2,000 1,111 $ 12,000 12,137 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL (CONT.) FOR THE YEAR ENDED APRIL 30, 1990 Budget Actual Public Safety (Cont.) Police Department (Cont.) Administrative Service Supplies $ 12,200 10,254 Apparel 4,500 5,180 Equipment 13,800 7,229 Motor Vehicles 9.000 13,596 Miscellaneous 837.800 703.179 Investigations Salaries 138,000 124,920 Overtime 8,000 7,876 Employee Benefits 16,700 14,500 Travel, Training and Dues 1,100 292 Contractual Services 27,550 26,635 Motor Vehicle Maintenance 4,000 1,415 Repairs and Maintenance 1,000 2,841 Supplies 5,000 2,459 Motor Vehicle Supplies 13,000 522 Apparel 1,800 2,086 Equipment 1,500 812 Motor Vehicles 70,000 13.516 217.650 195,033 Patrol Salaries 1,151,682 1,171,159 Overtime 56,000 36,806 Part -Time 42,110 30,679 Employee Benefits 168,920 122,045 Travel, Training and Dues 24,050 23,647 Motor Vehicle Maintenance 29,900 19,205 Repairs and Maintenance 2,000 2,841 Supplies 8,600 5,674 Motor Vehicle Supplies 25,000 11,895 Apparel 22,400 15,628 Equipment 3,940 4,931 Motor Vehicles 70,000 93,955 1,604,602 1,538,465 Special Services Salaries $ 26,820 28,403 50 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL (CONT.) FOR THE YEAR ENDED APRIL 30, 1990 Public Safety (Cont.) Police Department (Cont.) Youth Services Salaries Overtime Employee Benefits Travel, Training and Dues Motor Vehicle Maintenance Repairs and Maintenance Supplies Motor Vehicle Supplies Apparel Equipment Total Public Safety Total Expenditures 51 Budget Actual $ 152,240 146,937 5,600 1,436 21,420 17,409 1,600 1,521 3,500 7,926 15,500 2,295 930 215 2,000 434 1,200 1,810 1.500 1.328 205.490 181.311 2,892,362 2,646,391 $4,283,542 4,023,661 1 F-� 1 1 1 1 1 1 u 1 1 1 1 1 1 1 1 SPECIAL REVENUE FUNDS 1 1 i 1 1 r 1 1 C� 1 1 1 1 it I SPECIAL REVENUE FUNDS Municipal Audit Fund Municipal Audit Fund - An independent, outside audit, is conducted by a firm engaged by the Mayor and Board of Trustees on an annual basis as required by State law. These are earmarked funds that can only be expended for audit purposes. Emergency Services /Disaster Fund Emergency Services and Disaster Fund - The Emergency Services and Disaster Agency supersedes the Civil Defense Agency and now basically relates to natural disasters caused by floods and tornadoes. The Agency also prepares a plan of action to be taken if man -made disasters occur. Youth Bound Fund Youth Bound Fund - Accounts for the revenues collected and the expenditures incurred for this unique and very successful youth project of the Deerfield Police Department. Library Fund Library Fund - To account for the resources necessary to provide the educational, cultural and recreational activities of the Deerfield Public Library. Street and Bridge Fund Street and Bridge Fund - Accounts for the revenues and resources used in main- taining approximately 70 miles of street and the Railroad Station in the Village of Deerfield. Illinois Municipal Retirement Fund Illinois Municipal Retirement Fund - To account for the revenues and expenditures associated with providing disability and pension benefits for Deerfield employees. The fund also provides the employer with a portion of F.I.C.A. Contributions. Public Benefit Fund Public Benefit Fund - To account for the public benefit portion of local improvements installed under the special assessment procedure of financing is paid from this fund. 1 1 1 II U 1 I 1 1 1 I 1 J 1 1 1 t 1 1 SPECIAL REVENUES FUNDS (CONY.) IMotor Fuel Tax Fund Motor Fuel Tax Fund - To account for the activities involved with street maintenance and construction. Financing is provided by the Village's share of ' State gasoline taxes. State law required these gasoline taxes to be used for the following purposes: (1) Street construction or reconstruction to improve traffic capacity; (2) Installation of traffic signs, signals, and controls; (3) Sidewalk repair and replacement; and (4) The public benefit share of new street improvements when certain criteria are met in connection with a special assessment project. 1 Transportation Fund Transportation Fund - To account for the Taxi Subsidy Program established for senior citizens and the handicapped. Enhanced 911 Fund To account for the 911 calling telephone system activity. r 1 1 1 1 1 1 1 I77 1, 1 1 1 1 I 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 i 1 i 1 1 1 1 1 1 1 1 1 1 1 1 1 1 N 43 G W ro W N -4 ro G ro G ..I W at A O a1 N Gl O z e0 G G ro a E O N CV .-1 10 0%0 .-1 n n �o N r•1 o n m s n a� O �-1 J s n i a J Y1 a r1 V1 N n 4O ` MI lr 1 J .� ri v1 O O m O m O� Cl) N Cl) Cl) rl h O Cl) n 61 N O% n O u1 ei n N Cl) m J r1 rf 14 14 h v1 n m N m �O -4 .-4 14 'i N ei rl N ro 43 O of 'a co rl mm O O`mm O'a, m'a J O H 10 n .d O m n n O N 14 1-1 Ln 0%11-4 v1 n n ns GO V1m O mV1 Oi hoI Ir r1 0 of N N n n a, m m N co a, %0 m O, m O N H D rl O rl m v1 H Il rl rl N b m UH n m a0 _ co IV rn rnN 11 n rn ao m ao G 1 GO 10 s s W F N N O I +1 J O J O cc Hy 1 F O m co m s v1 v1 rn s %1 FK co � m m s a m m 43 4 Go a %n ao of a+ m o o F. O� n C O N N n n co 7+ 7 W O r•1 a N a U y w AG I I 1 HW pq O z H A W m a .-1 h H x •.l 0 a� n m o Cl) a .-Im .a o morn f o+ n v1 o I O t1 m o a m o 010 n m� W .0 s rn N a 10 s W O ro m ID m co co a, 10 n s o .1 0, m ol m a n .-i J .-1 n o 1a O a v1 o v1 s O W �l1 r7 m-H o o 10 n con %oMO10 o n A l-•1 z H CO N Cl) v1 14 .-I N m T O T m m N V1 �1 H z A4 En O U " W w Oq p•1 M z O ID a m m N �4 m N n m m n n n m U ro Oi 11 a+ vO a C W) O O N In s m 14 F q O a a n vl -1 co CIO ocl GD c0 10 O OD J a� P, O OI h � T\ a O N ei •i N\ 10 J I � iN \i U) E m J N N YO n D01 W V1 A ro A 43 Go O a+ O n 1n n m o 0 1 a n n N 1n O V1 GD m N •,�I y N N ` N a rn .N•I .-1 E b m GGi yyO�� G pq ul d co ul U1 [] U N m G1 d , ; G G H m 7 $4 G U W . r+Ai 4 to >< d 11 14 m O (a Atl N 14 0 A l A w m ro +� ro d N N T T b m H ro n ro m - � $4a 924 a m ",a I g. m y ro i oo bm ° to 4 43 10 .4 W iG 1 'd N A ra l H n v N ro m G ro GL 4l d o p PO i0i +V 4 W W H .-7 .-1 .0 O H CL N U V E ro G) O pa W 62 m $4 O H co H M U o a a o ro 6 U a s F a v a W N 43 G W ro W N -4 ro G ro G ..I W at A O a1 N Gl O z e0 G G ro a E O N CV p T �O O� .1 m N Cf) O� V1 CO n m �O m m m 0 m O o CT m N h N N �D O CO 4 .-1 N N V) J r-1 n m m N r/ n .-� rl O� Y') n 'i a, ,•� O O, N 0 C u a, r, 0 O �o n �o m m rn N m N N a a o aD aD W n n O O N N N e-1 e i y w O I Oh � am l dOD � m O I m m m W O 1 m N 10 ] FO q I O N F N O 1 cqj u'1 N N CD O p OD �o O m O IO n OD O O f O O O tO m 1 n S W m m N W m n a "4 W C N u�'� H m i CA Z w in uni uni 0 H W v] O W Ww a y n O J N (a T CT 1 n h o n h 1 rn .7 v 1 V 4 S a O O Oa , a h J O O 4 m V Cr m m Q O i � N � o m m a W p4 O O haD 0C', Jn m m a 000 O O O J z CYi 0) m rt W S O 1 O n m�OOCO J 1 a O O O v) O O v1 Qm O ao O V1 n (n O to O m m J vi u1 O A H W $4 (Oi to m h m (T H.] N N N O u W U rn U W W 10 N C7 a' [-4 U C S a 1 n O O O O� CT CO aD n H A H ui n co p m W) a fn zQ, a n .-4 00 a N F In N N co 1� z H H o 7I a I a o o rnN I 102-1 'il 1 J V1 EH W N Wv�q 1 1 E v ro a) .a rn Pa) o 11 '+ O o .I 'o o n a cq _�j O O O V 1-0 a y W N y w 11 0 e T a o CO . F a r r. 0 0 ~ 4) o b N y y W C 0 y O D 7 4 -4 m m U m m — 4 y H t0 0 p y N z d y) m 41 p' On N rA .A ,dOj pG O. 'dH a a y 41 43 (D .00 m i a mCH H F O ° i 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS MUNICIPAL AUDIT FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 Revenues Taxes Property Taxes Interest Total Revenues Expenditures Miscellaneous Contractual Excess (Deficiency) of Revenues Over Expenditures Fund Balance May 1 April 30 1990 1989 Budget Actual Actual $12,500 12,370 10,419 41 34 12,500 12,411 10,453 $12,500 12,400 11,600 (11) (1,147) 11,076 12,223 11,087 111 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, 1990 Revenues Taxes Property Taxes Interest Total Revenues Expenditures Public Safety Travel, Training and Dues Communications Insurance Contractual Utility Services Motor Vehicle Maintenance Repairs and Maintenance Supplies Equipment Total Expenditures Excess (Deficiency) of Revenues over Expenditures Fund Balance May 1 April 30 1990 1989 Budget Actual Actual $ 5,000 5,166 4,948 20 12 5,000 5,186 4,960 700 433 572 1,500 1,846 1,563 600 263 69 300 194 100 86 109 1,300 325 798 1,000 1,015 323 700 348 346 500 2,514 6,700 4,510 6,294 $(1.700) 676 (1,334) 17,384 18,718 18,060 17,384 See accompanying Notes to the Financial Statements. 55 1 1 1 1 1 1 i 1 t 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS YOUTH BOUND FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 Revenues Charges for Services Project Income Expenditures Culture and Recreation Travel, Training and Dues Insurance Motor Vehicle Maintenance Motor Vehicle Supplies Repairs and Maintenance Supplies Equipment Communications Contractual Total Expenditures Excess (Deficiency) of Revenues over Expenditures Other Financing Sources Operating Transfers In General Fund Excess (Deficiency) of Revenues and Other Financing Sources over Expendi- tures Fund Balance May 1 April 30 1990 1989 Budget Actual Actual $13,500 - - 600 110 1,071 69 2,500 165 1,140 900 8 400 6,700 150 1,200 1,300 1,318 794 5,950 194 128 19,660 2,898 2,139 (6,160) (2,898) (2,139) 4,000 4,000 4,000 $(2,160) 1,102 1,861 See accompanying Notes to the Financial Statements. 56 4,310 2,449 _4,310 VILLAGE OF DEERFIELD, ILLINOIS LIBRARY FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 1990 Budget Actual Revenues Taxes Property Taxes $ 814,493 757,954 Replacement Taxes 16,000 18,022 Intergovernmental Grants 17,467 17,432 Charges for Services Non - Resident Fees 15,000 14,400 Fees, Fines, Penalties 23,000 30,953 Reciprocal Borrowing 3,500 2,088 Xerox 15,000 10,954 Videos 24,000 30,069 Interest 25,000 40,449 Miscellaneous Gifts 500 165 Reserve for Repairs and Replacement 160.000 575 Total Revenues 1,113,960 923,061 Expenditures Culture and Recreation Excess (Deficiency) of Revenues over Expenditures Fund Balance May 1 April 30 $1.113.960 915.084 See accompanying Notes to the Financial Statements. 57 7,977 255.819 263,796 1989 Actual 716,732 20,326 17,432 13,499 26,999 4,087 11,131 28,029 34,416 753 873,404 880.734 (7,330) 263.149 255,819 1 I VILLAGE OF DEERFIELD, ILLINOIS LIBRARY FUND I SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 1 1 1 1 1 58 1 Budget Actual Culture and Recreation Salaries - Professional Salaries - Non - Professional $ 229,837 323,373 209,935 294,643 Employee Benefits 41,500 25,927 Professional Services 6,000 1,925 ' Education, Travel and Dues 10,000 3,847 Communication 9,500 8,819 Insurance 20,000 11,755 Contractual Services 17,000 8,346 ' Utilities 1,000 727 Repairs, Maintenance of Building and ' Equipment Building Supplies Supplies - Library and Office 95,000 23,000 .55,437 28,902 Books 96,000 89,013 Periodicals 33,000 24,773 ' Audio - Visual 25,000 23,921 Binding 2,500 1,360 Special Library Programs 6,500 3,647 ' Data Base New Equipment 2,000 22,000 466 12,843 Printing 7,000 5,722 Computer Service 96,587 ' Cataloging Service 7,000 4,552 Miscellaneous 1,000 1,937 Automation Project 85,750 ' Improvements - Other than Building 50.000 Total Expenditures $1,113,960 915,084 1 1 1 1 58 1 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, 1990 Revenues Taxes Property Taxes Other Taxes Licenses and Permits Vehicle Licenses Charges for Services State Highway Maintenance 50/50 Sidewalk and Curb 50/50 Tree Train Station Maintenance Interest Miscellaneous Other Total Revenues Expenditures Highways and Streets Administration Cleaning Traffic Marking Pavement Patching Tarring Cracks Drainage Structure Street Lights and Traffic Signals Miscellaneous Maintenance Snow and Ice Control Weed Control Leaf Removal Tree Removal Tree Planting Railroad Station Maintenance Total Expenditures Excess (Deficiency) of Revenues over Expenditures Other Financing Sources (Uses) Operating Transfers In (Out) Commuter Parking Lot Fund Replacement Fund Excess (Deficiency) of Revenues and Other Financing Sources over Expenditures and Other Financing Uses Fund Balance May 1 April 30 1990 1989 Budget Actual Actual $330,000 344,015 233,835 190,000 190,000 180,000 330,000 329,788 278,530 21,000 22,492 20,765 25,000 19,978 9,208 5,000 9,863 3,905 1,500 6,007 22,000 30,620 42,172 5.000 5.084 6.718 929.500 957.847 775.133 129,460 138,443 129,876 44,060 35,557 30,324 53,850 49,100 39,548 105,110 96,288 86,050 54,720 37,257 49,335 21,930 24,107 24,937 126,530 105,687 89,468 84,940 89,283 97,398 145,380 212,295 108,166 21,770 15,425 19,002 33,510 41,383 22,998 46,820 38,597 27,960 33,840 26,118 12,906 33.520 29.863 27.961 935.440 939.403 765.929 (5.940) 18.444 9.204 40,000 40,000 30,000 (63,000) 63 000) (61,000) (23,000) 23 000) (31,000) $(28.940) (4,556) (21,796) 205.060 226.856 200,504 205,060 See accompanying Notes to the Financial Statements. 59 1 VILLAGE OF DEERFIELD, ILLINOIS STREET AND BRIDGE FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 tBudget Actual Highways and Streets ' Public Works Administration Salaries $ 44,410 43,970 ' Repairs and Maintenance 5,500 5,480 Equipment Rental 1,500 1,760 Motor Vehicle Supplies 1,500 2,006 Supplies 1,800 893 44,060 35.557 ' Traffic Marking Salaries 23,870 22,721 Overtime 320 791 ' Part -Time 2,730 2,704 Employee Benefits 4,130 2,913 Motor Vehicle Maintenance 1,000 556 ' Repairs and Maintenance 800 1,072 Motor Vehicle Supplies $ 500 55 1 60 1 Overtime 3,900 4,192 ' Employee Benefits 5,450 6,839 Professional Services 500 Travel, Training and Dues 2,200 1,736 ' Printing and Advertising 4,600 3,635 Communications 6,100 4,892 Other 48,600 54,617 Motor Vehicle Maintenance 2,500 3,181 1 Miscellaneous 2,200 3,792 Supplies 3,000 5,628 ' Motor Vehicle Supplies Apparel 1,500 1,800 1,428 1,268 Repairs and Maintenance 1,500 167 Contractual 1,200 3,098 ' 129,460 138,443 Cleaning Salaries 20,790 16,098 Overtime 1,200 1,473 ' Employee Benefits Small Tools and Equipment 3,570 500 2,171 113 Contractual 3,700 2,320 Motor Vehicle Maintenance 4,000 3,243 ' Repairs and Maintenance 5,500 5,480 Equipment Rental 1,500 1,760 Motor Vehicle Supplies 1,500 2,006 Supplies 1,800 893 44,060 35.557 ' Traffic Marking Salaries 23,870 22,721 Overtime 320 791 ' Part -Time 2,730 2,704 Employee Benefits 4,130 2,913 Motor Vehicle Maintenance 1,000 556 ' Repairs and Maintenance 800 1,072 Motor Vehicle Supplies $ 500 55 1 60 1 VILLAGE OF DEERFIELD, ILLINOIS STREET AND BRIDGE FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL (CONT.) FOR THE YEAR ENDED APRIL 30, 1990 Budget Actual Highways and Streets (Cont.) Public Works (Cont.) Traffic Marketing (Cont.) Materials $ 4,000 1,353 Street Signs 6,500 6,935 Contractual 10,000 10,000 53,850 49,100 Pavement Patching Salaries 43,950 40,879 Overtime 1,260 1,648 Employee Benefits 7,600 5,174 Motor Vehicle Maintenance 5,000 6,984 Repairs and Maintenance 5,500 3,138 Supplies 600 3,078 Motor Vehicle Supplies 2,000 814 Aggregates 33,900 33,954 Materials 2,000 1,599 Equipment 3,300 2,098 105,110 96,288 Tarring Cracks Salaries 22,980 14,608 Overtime 630 647 Part -Time 2,730 2,729 Employee Benefits 3,980 1,889 Motor Vehicle Maintenance 1,400 3,602 Repairs and Maintenance 1,900 3,078 Motor Vehicle Supplies 3,000 1,051 Aggregates 600 419 Materials 15,000 9,234 Equipment Rental 2,500 54,720 37,257 Drainage Structures Salaries 11,230 15,648 Overtime 950 405 Employee Benefits 1,950 1,940 Motor Vehicle Maintenance 2,000 2,492 Repairs and Maintenance 2,300 1,438 Motor Vehicle Supplies 300 73 Aggregates 1,200 1,895 Materials 2,000 216 21,930 24,107 61 1 I VILLAGE OF DEERFIELD, ILLINOIS STREET AND BRIDGE FUND I SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL (CONT.) FOR THE YEAR ENDED APRIL 30, 1990 7 I Budget Actual 1 C*A 1 Highways and Streets (Cont.) Public Works (Cont.) Street Lights and Traffic Signals Salaries Overtime $ 11,280 1,200 13,156 4,376 Employee Benefits 1,950 1,729 Contractual 31,000 15,675 ' Utility Services 65,400 58,148 Motor Vehicle Maintenance 1,500 1,076 Repairs and Maintenance 2,000 1,627 Equipment Rental 1,000 60 ' Motor Vehicle Supplies 800 1,070 Aggregates 400 167 ' Materials 10,000 126,530 8,603 105,687 Miscellaneous Maintenance Salaries 10,000 2,784 ' Overtime 2,200 5,396 Employee Benefits 1,740 1,370 Contractual 55,700 60,165 ' Motor Vehicle Maintenance 1,000 645 Repairs and Maintenance 3,000 5,744 Small Tools and Equipment 400 300 ' Miscellaneous 1,300 1,377 Motor Vehicle Supplies 600 496 Aggregates 2,000 4,560 Materials 5,000 6,356 Equipment Rental 2,000 90 84,940 89,283 Snow and Ice Control Salaries 24,620 21,940 Overtime 9,900 37,549 Employee Benefits 4,260 2,711 Communications 1,800 485 Motor Vehicle Maintenance 7,000 19,430 Repairs and Maintenance 18,000 26,623 t Equipment Rental 1,000 Supplies 2,500 1,790 ' Motor Vehicle Supplies Salt 5,300 $ 32,500 3,597 61,792 1 C*A 1 VILLAGE OF DEERFIELD, ILLINOIS STREET AND BRIDGE FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL (CONT.) FOR THE YEAR ENDED APRIL 30, 1990 Budget Actual Highways and Streets (Cont.) Public Works (Cont.) Snow and Ice Control (Cont.) Aggregates $ 5,000 4,073 Materials 2,000 1,543 Equipment 9,000 9,448 Motor Vehicles 22.500 21.314 145.380 212.295 Weed Control Salaries 8,890 4,401 Overtime 110 458 Part -Time 2,730 2,726 Employee Benefits 1,540 652 Motor Vehicle Maintenance 1,000 1,405 Repairs and Maintenance 3,500 4,730 Motor Vehicle Supplies 500 581 Materials 3,000 11.250 Equipment 500 472 Equipment 21.770 15.425 Leaf Removal Salaries 1,830 15,135 Overtime 10,000 4,709 Employee Benefits 330 1,775 Motor Vehicle Maintenance 1,500 1,954 Repairs and Maintenance 8,000 5,738 Motor Vehicle Supplies 500 776 Supplies 100 46 Motor Vehicles 11.250 11.250 Materials 33.510 41.383 Tree Removal Salaries 14,230 13,173 Overtime 630 1,003 Part -Time 2,460 3,829 Employee Benefits 4,300 1,729 Contractual 21,000 17,101 Motor Vehicle Maintenance 700 533 Repairs and Maintenance 1,000 659 Motor Vehicle Supplies 400 280 Materials 1,100 290 Equipment 500 Equipment Rental 500 46,820 38,597 63 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS STREET AND BRIDGE FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL (CONT.) FOR THE YEAR ENDED APRIL 30, 1990 Highways and Streets (Cont.) Public Works (Cont.) Tree Planting Salaries Overtime Employee Benefits Contractual Motor Vehicle Maintenance Repairs and Maintenance Motor Vehicle Supplies Materials Railroad Station Maintenance Salaries Overtime Part -Time Employee Benefits Contractual Services Repairs and Maintenance Supplies Aggregates Materials Total Expenditures 64 Budget Actual $ 9,990 6,149 420 1,090 1,730 848 20,000 16,955 500 245 300 174 400 287 500 370 33,840 26,118 9,070 12,505 1,000 291 3,780 3,579 1,570 1,745 3,300 517 4,800 3,105 1,500 1,117 600 7.900 7,004 33,520 29,863 935 440 93® 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, 1990 Revenues Taxes Property Taxes Replacement Taxes Interest Total Revenues Expenditures Miscellaneous Illinois Municipal Retirement Payments - Employer FICA Payments - Employer Excess (Deficiency) of Revenues over Expenditures Fund Balance May 1 April 30 1990 1989 Budget Actual Actual $490,000 401,945 335,923 81000 7,462 8,416 10.000 3.992 13.425 508.000 413.399 357.764 275,000 288,342 418,510 215.000 207.398 490.000 495.740 418.510 18,000 (82,341) (60,746) See accompanying Notes to the Financial Statements. 65 75 449) 1( 4,703) (157,790) (75,449) 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS PUBLIC BENEFIT FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 Revenues Interest Miscellaneous Other Total Revenues Expenditures General Government Contractual Excess (Deficiency) of Revenues over Expenditures Other Financing Sources Operating Transfer In Special Assessment Agency Fund Excess of Revenues and Other Financing Sources over Expenditures Fund Balance May 1 Residual Equity Transfer Out April 30 66 1990 Budget Actual 65,273 - 65 273) - 57,324 57,324 63,273 (120,597) (57,324) 1989 Actual 63,273 63,273 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, 1990 1990 Budget Actual Revenues Intergovernmental Allotments Earned $305,000 330,823 Interest 40,000 46,800 Total Revenues 345,000 377,623 Expenditures Highways and Streets Street Maintenance 190,000 190,000 Street Resurfacing and Renovation Program 61,000 58,854 Total Expenditures 251,000 248,854 Excess of Revenues over Expenditures 94,000 128,769 Operating Transfer In General Fund Excess of Revenues and Other Sources over Expenditures Fund Balance May 1 April 30 94,000 128,769 See accompanying Notes to the Financial Statements. 67 490,120 61® 1989 Actual 303,551 35,084 338,635 180,000 76,578 256,578 82,057 6,213 88,270 401,850 490,120 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS TRANSPORTATION FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 Revenues Intergovernmental Grant Expenditures Miscellaneous Transportation Excess (Deficiency) of Revenues over Expenditures Other Financing Sources Operating Transfers In General Fund Excess (Deficiency) of Revenues and Other Financing Sources over Expenditures Fund Balance May 1 April 30 1990 1989 Budget Actual Actual $ 4,500 3,507 3,670 6.500 5.844 6.239 (2,000) (2,337) (2,569) 2,000 2.000 2.000 See accompanying Notes to the Financial Statements. 68 (337) (569) 6.431 7.000 6,094 6.431 VILLAGE OF DEERFIELD, ILLINOIS ENHANCED 911 FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 Revenues Charges for Services Other Charges Interest Total Revenues Expenditures Public Safety Contractual Repairs and Maintenance Equipment Improvements Other than Buildings Miscellaneous Total Expenditures Excess (Deficiency) of Revenues over Expenditures Fund Balance May 1 April 30 1990 1989 Budget Actual Actual $ 78,000 76,299 272 78,000 76,571 - 13,000 9,110 104,000 22,400 2,000 150,510 3,251 23 60,455 37,740 101,469 72 510) (24,898) - 2.4,8_) - See accompanying Notes to the Financial Statements, 69 1 I 1 1 1 1 1 J 1 1 1 1 1 1 1 1 DEBT SERVICE FUND 1 1 1 I 1 I 1 1 1 1 1 I 1 I 1 1 1 1 1 1 1 1 1 1 1 1 Debt Fund DEBT SERVICE FUND ' Debt Service Fund - To account for the accumulation of resources for the payment of General Long -Term Debt. 1 1 1 1 1 L7 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS DEBT SERVICE FUND BALANCE SHEET APRIL 30, 1990 ASSETS Cash and Investments Receivables Property Taxes Accrued Interest Due from Other Funds Total Assets LIABILITIES AND FUND BALANCE Liabilities Interest Payable Due to Other Funds Deferred Property Taxes Total Liabilities Fund Balance Reserved for Debt Service Total Liabilities and Fund Balance See accompanying Notes to the Financial Statements. 70 1990 1989 $1,253,434 1,182,676 1,376,350 1,314,290 12,204 22,713 5,371 2,64®1,988 2,525,050 20,000 63,129 1,515,935 1,431,063 1,579,064 1,451,063 1,062,924 1.073,987 $2,641.988 2,525,050 VILLAGE OF DEERFIELD, ILLINOIS DEBT SERVICE FUND STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 Revenues Taxes Property Taxes Replacement Taxes Interest Total Revenues Expenditures Debt Service Principal Retirement Interest Fiscal Charges Total Expenditures Excess (Deficiency) of Revenues over Expenditures Other Financing Sources Operating Transfers In Tax Incremental Finance District #1 Fund Excess (Deficiency) of Revenues and Other Financing Sources over Expenditures Fund Balance May 1 Residual Equity Transfer April 30 1990 1989 Bind et Actual Actual $1,585,575 1,503,082 1,110,004 45,000 51,934 58,573 75,000 103,637 90,489 1,705,575 1,658,653 1,259,066 700,000 700,000 600,000 1,122,600 1,057,344 866,226 20,000 2,966 2,737 1,842,600 1,760,310 1,468,963 (137,025) (101,657) (209,897) 80:025 84,375 84,280 (57,000) (17,282) (125,617) See accompanying Notes to the Financial Statements. 71 1,073,987 6,219 1,080,206 1,062,924 1,199,604 1,199,604 1,073,987 1 u r 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS DEBT SERVICE FUND SCHEDULE OF EXPENDITURES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 Debt Service Sewerage Improvement Bond Series of 1973 Principal Interest Sewerage Treatment Facility Bond Series of 1973 Principal Interest Corporate Purpose Bond Series of 1982 Principal Interest Corporate Purpose Bond Series 1982 -A Principal Interest Corporate Purpose Bond Series of 1986 Principal Interest General Obligation Bond Series of 1988 Principal Interest Fiscal Charges Total Expenditures 72 Budget $1,8 Actual 75,000 6,250 125,000 13,750 50,000 34,275 50,000 20,750 300,000 735,613 100,000 246,706 2.966 1.76® 1 F� 1 1 1 1 1 1 1 1 I 1 1 1 1 r 1 i I U 1 1 1 1 1 r7 LJ 1 1 1 1 1 1 1 1 1 CAPITAL PROJECT FUNDS 1 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. 1, Tax Incremental Finance District 1 Fund I Established in 1982 to provide funds for land acquisition and improvements to the Village of Deerfield Tax Increment Financing District. ' Tax Incremental Finance District 2 Fund Established in 1987 to provide funds for land acquisition and improvements to the Village of Deerfield Tax Increment Financing District. 1 Capital Improvement Series A Fund Established in December, 1984, to provide funds for Storm Sewer Improvements, Sanitary Improvements and Street Rehabilitation Program. Capital Improvements Series B Fund ' Established in December, 1985, to provide funds for major renovation to the Storm and Sanitary Sewers and a Street Rehabilitation Program. Brickyards Development Fund i Established for the purpose of providing improvements to the area known as The Brickyards property. This includes construction of Culverts, Creek Realignment, and the extension of Pfingsten Road, which includes a bridge at Lake -Cook and an overpass at Kates Road. Vehicle Replacement Fund Established to account for the funds annually set aside for the eventual replacement of certain vehicles. it U �il 1 r 1 u 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Fund Descriptions (Cont.) 1 ' Capital Improvements Series 1987 Fund Established in December, 1987 to provide funds for the maintenance and repairs of the Village's streets. Brickyard Park Fund Established in 1988 to account for the construction and engineering of a park for Deerfield Park District located within the area known as The Brickyards. ' Capital Improvements Series 1988 Fund Established in 1988 to provide funds for the acquisition of right -of -way for the Access Avenue Project: traffic signal modification; sanitary sewer and street rehabilitation; the installment of a new 16 inch water main, and storm ' drainage improvements. 1 1 1 1 1 1 Ij 1 n 1 1 1 1 1 1 1 [l 1 1 1 1 1 f 1 1 1 1 pi 1 1 1 1 1 1 1 1 11 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS CAPITAL PROJECTS FUNDS COMBINING BALANCE SHEET APRIL 30, 1990 (See Following Page) W H O H W az W H� x o W� rA-1H U� R O O cn w C4 W Pr H o W Qi H Qi H H 0 U U r-i H a A V y 01 O O 01 01 T O 1� O� 0 0 O O rl O d J 1i ri c0 rl O � O \ -1 d O J d \ U N U \ +1 > N \> N y a Ri p m a U m � a N M 1d a m w c0 c0 h In m Vl N N 00 m c0 m (01 O 0 14 cn m � w 14 N V LIB (n m 14 d d 8 M a y7 ) 0 N a � a -1 M q � ,4 (.' 6 w 0 u 2 w P 14 a N o 1 -.4 41 0 ID 01 01 m N a 0 14 0 10 .1 0 s w H 10 i� Co $4 W a 0) 14 a > F qA \T O b a Aa+4 4) �+ N N o w H m O 'O 1.a m cl a eo 0 b V 14 N N N .d 4 N N m a 0> A. 14 w O H 0-A .4 A O 0 0 0 w 0 O H -4 O U W F 1 a .+ a U 43 m W F w F 1-1 A 10 U m 7 m log 0 0 C-4 A 0 co tb m h n O co m N co G U m m v1 co 1-4 O m 01 1n m m U s W ao u o 10 d o 0 F N N GN cn co o " m a N V W N W 14 O N m O N 14 a 10 1-1 m %n In O O 1.1 'A J 0 10 m O /n m O O m 1-1 N o IT n N o1 m 10 0 c0 0 N If 0 01 d 1l N \/\ F N h m M S A m '.4 w 1^-1 A co U k1 ,•aj 0 In o h h m a0 H p N ,4 a a U � O U W 0 .a .a U c a m U m � w w m .0 'o ) 0 N a � a -1 M q � En W w 0 u 2 w P 14 0 o 1 -.4 41 0 1 a 0 14 0 10 .1 0 0 a w H 10 i� Co $4 W a 0) 14 a > F qA F b a Aa+4 4) �+ H a w GI 4.1 H m O 'O 1.a m cl a eo 0 b C A H 1-1 47 8 b> 0 0 .d 4 H +/ 43 10 m .4 -44 ° w� m a 0> A. 14 w O H 0-A .4 A O 0 0 0 w 0 O -4 O U W F 1 a .+ a U 43 m W F w F ,G 0 w U A 10 U m 7 m log 0 �UCPGpp o ul a U or p .a W 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 O, N n s W o1 0 10 o a co o a ko o 10 O co 11 co O O% %o n m o cO In J m o,) o onno 1-4 10 O o1 aD a, m N -r coO co In OOONO o co 1-4 co -.O O It n m m O .t O, %D N 14 m Y') m .7.A H N 'n co m O,s.c I-1 N m m a v a n n v .a m m F ro m m O n N O O O w h h F' m nn In N m'ovOmN o N ri N m h m J 10 0% O 10 n 10 m oI N o a O h n r1 lG O O 1O aD Vl Ol 10 co %O O 11 co O, In O m ,O s e-1 N m Vl O, rl co n O O, O.r 10 1� a0i U E of 1O N oI m .-1 J of In wl m oI n vl m In n D m °0o rl e4 O, N /1p n vl I D Vl y 1-4 10 0 o aD Y') 1cl m 1 m m m m m O n 00 O O w h h h Vl a m m a0i U E m O a n °0o $ 4 0 y ,.4 m vl O rn O� Ip m Vl a) ao aU a N 07 .0 co co a a, n v m . b 0.m m o n s ` � pro > n N CD co cN o m ro u te vl e H N b rl ri O F r1 6 W tn N W, N 14 v 14 d O n N . O ro 110 -4 W 11 O N 1 C co A 0% N ~ I 1 1 I > �ww M y a7 O1 01 O kn O tn V1 m Vl m h m U N DD If Q Q d I 0� ., v h N h a m U 9 1 A w OII U y b W at N 43 b 5 6 W F w 60 ul 4 m m O4 9 N 43 .0 w U, 4 A 4 w 0 14 W 03 o .1 Q aS m N al In >A, a +i +i 91 9 m 0 A>, A H O ro � I 41 > F C A k a O w v a A a .+ w m b q rn M a3 <. F 1 m w m it 0 ..� 1 - m >, O m m 00 O b > Cro t ° m w m a 0 N p] 8 1 N 43 w N > a w m w O f+ 1 43 d .0 O A 0 0 D7 m O +1 O U A a +1 N U a3 0 W F w F A m w U A A U m 7 m 'o N U 04 -4 O m A U Q oC O Q C O A U OS a {.Oi C d w ro N .-1 ro C A C W N A a) O a� O Z 00 r li 8 U A W M r- Ol 43 b m co V) m V) V) N 0 O CIO CID O O O N J H 10 %o in H O, O, N N m O O O O 10 co O% Ol Cn Cn Ol T n co n O) n n co O O m m m n A6 n a0 V1 h u) O% O O 0 O 10 10 10 m .-OI U O N m rl rl n O O N v O� O� N +� m m H H m m H Cl) m A W 0 0 O m Cl) m m J a a T ,4 0 4) OD O O N N a J in V) V) c0 0 N V1 n m m in ul H H H m "� > +4 O N n .4 OD in N n H H OD OD N O I N O J n J a n n co N H H O 10 ID J :.% W e H H .� M W an d N O o n n n n 0 O N N N +, m 4) VO O m O N V) W) 1 Y0 $4 •l � N 04 L) Ell 0.n N N N W 8 M Hn- O m N 3 V) J O n O% 11 O m O, ch J H rl H V) If m f-1 n n m co r1 a. h rr �o co V) eon W a a .-I a a a V1 oW r4 j� W Vi of of N of O O, n N n O, 0% 0% F 4) 0% ri .4 N a r1 V) m a a O o O o Ol z rr, r4� ; 7 VV ^ 14 N r1 a OD m. 4 n �o J a o Is^ W rA a A M H r-1 H W H v) o 10 0% m h Vt o m h co .o .o %D IT A H A a V M O N � 10 N a, � cnn m V) V) n U W z Qi 0 0 m m 10 H o 01 n N O: o o %D co a J m m N in %n 0 h h 0 o W) r14 N 14 w r4 N m 1-1 14 N %D 10 10 n n n m 14 60 M w J a J v Cl) N N N m w 0 �I H A p W w 0 z w 41 H O z .d yqj eJ-1 N rJ/ ra/ eOi in .Oi N eJ-1 kn H 43 U n n n n N n W W y+ a co U v HAW Z w 1 n b � 10 %0 H to I I I I I I I to kn U 1 a v mp, to m m W m 0 to a -� m U 0 H ID v b m O) 0 1e) m H W 0 ~' W W N x.01 7 O U 10 1D 0 7 W a7 ttl W N 01 O W W .1 >, m •n m m O) (y' U H N N N a.) U 604 K 0 a 0 D. 103 R O m O R a) O CW a) to pm, .i a1 Si +/ -A r. N H •4 "i U K td O > >� N H ma H a1 a) w w U U V R 0 ++ F H .-I UU .-0 p 60 60 O U .4 4'O to 0 O 0 b' 4 W W N CD ) N H 43 0) R R N p 0 'O .4 O - 0 W .I .I 7 r4 N N a) O V .1 4 .I W W 0 0 m N a 0 0 0 r) O a) 03 N 0 O W + a) 43 0 m -4 a) V 0 W O r4 U N m 13 .i i) j.' A F W N 2 N N 0 .4 N N .d a 0 $4 O r m U 0 b +1 O N N N O) O 0 7 Ri O 0 +/ 11 G K W N H aD 0 H C. a U O to m N or 0 0 a ,C a) >, «i +7 to N m 0 R +1 0) 0 m> 0 0 d a) +l v A N v m a HE pV 0 0 r. EC4<cc c mH A Ko'O a w w O w w 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 CSI co O) 4 0 4) 0 O F OI o) rn .-I rn N 41 U m O H a m y r E H U N CO W .4 44 m py r M to 43 O .4 r O 43 m u aw H rn V H co >+ JC H N pq 4) y E ol U W H em H )n 4 m E Q U m +i U m .4 D m P4 10 r In 000 Oaa %D aNON o a r4ma 0 a O O Cl) o. 1D O� O m m m n m O a % OD h m Cl) a O .-I O O1 O1 �0 n m m rl O O rl ri n a N N O ID 1D O, m v1 O m a 00 OD O) O C % Cn 10 N T Ol O N N co N H Cl) N v1 m a v1 O w a V1 )n kn rl Y1 rl 10 ri V1 O In V1 O O) 40 O O 0� O O O rl Cl) a OD 00 a N N m m O m co n N N u 1 n h O v1 a n n N %D � v m _ a q m h a Vi rl O O a m N �mO m N O O N H OmM -q n a O O G O a O 10 q w N Cl) H w w 0 0) CA w H gmg C a l m OD h O 0 D 0 0 n rl rl a 11r-li n II I MC I I I n In I1 ,D to v1 v1 0 o v1 O O 0 v1 00 m u1 O O O O I a 40 h --01 In O O v1 h O w 1 I m 1 M rmi in voi amo amo to 4 in v1 n b i id 4 v1 O) m N N h M I I m a .-I v1 V1 m m m '' 1141 m m a a rl O O O O O O 0 nOn m m u1 .� OD V1 m m m O� I a a v) a m N N N '' 1141 m m a a rl O O O O O O 0 O O rI .� ri � ri rl o I a a v) a m N N N � I ril I I I rll I I N N a , *) O o 0% YY 0 O O rI .� O n n O Yl m.n v) a m O N O w m N m dID D 1 0a o N m , N T D 0 I n 0 m m o m O O O n �D m m m 0 Yl O O O a a n n n n O Yl in v) a �D O O O a n N N I n rlb 110 � I I m N N N In o a a a a 0 40 40 dD dD m co n n h O O O V1 000 m a0o n0 n N N I n rlb 110 � I I m N N N In m o 0 o m o a a a a O n n n n h O O O V1 m 6i a w w o w w w G m d W U q m R W m x 0 N m a1 O z ho a e 0 U U m m w r` H m O w m b H to 4 b i id 4 4) + +i m _ q m N G G > v _ N > r6w�i m N N H w p G q 0 R g g H m q q w H w w 0 0) CA w w > a g gmg C 0 O O 0 0 0 a7 N a) H H H Hr� a +� w w O O 7 11 m O m N 4w ) m m H m r H E Ell w w U m b U w w O In m m 41 p Q H 6 4 F m 7 q '4 +1 43 � �4 +4 r m +4 O +4 . >� F 4) m w a) 41 N W U U T1 + +i F F .4 U U to w W W O 0 44 0 ) 41 40 H U . m w e w r4 .4 0 0 .4 H a) 0 0 -•4 +4 14 L L C W 4 w a) 4) w m 0 + G +I a) a) m O a) . .4 a) y m w 0 4 U H m a) + +4 a) V 4 F W W 40 0 H O O m m H w V 0 m $4 4) ( m 0 0 ' 'O +/ O a) t to H H H H 4) p pq O O .A .i m m 04U3H ��F m m m m K m mO m K H Kw IQ � �EaCPG P. o w G m d W U q m R W m x 0 N m a1 O z ho a e 0 U U m m w r` 1 1 1 1 1 1 t 1 1 1 1 I 1 1 �l 1 1 1 1 1 1 1 1 1 1 r 1 1 1 1 1 n 1 PROPRIETARY FUND TYPES 1 1 1 1 1 1 1 1 1 1 1 1 1 1 I F1 1 1 1 ENTERPRISE FUNDS t Water Fund 1 1 1 1 1 e 1 1 1 1 1 u 1 1 ENTERPRISE FUNDS Water Fund - To account for all activity necessary to provide water to the residents of the Village of Deerfield including administration, operation, maintenance, financing and related Debt Service. Sewerage Fund Sewerage Fund - To account for the provision of sewer service to the residents of the Village of Deerfield. All activity necessary to provide such services is accounted for in this fund including, but not limited to, administration, construction, maintenance, and operations of the Sewerage Treatment Plant. Refuse Fund Refuse Fund - To account for all revenues and expenses necessary to provide the residents of the Village of Deerfield with refuse service. Commuter Parking Lot Fund Commuter Parking Lot Fund - To account for all activity necessary to construct, operate, and maintain the commuter parking facilities within the Village. 1 t 1 1 1 1 11 1 1 1 1 1 I 1 1 1 1 1 1 1 1 1 1 1 1 1 1 i 1 1 1 i 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS ENTERPRISE FUNDS COMBINING BALANCE SHEET APRIL 30, 1990 See accompanying Notes to the Financial Statements. 75 Commuter Parking Totals Water Sewerage Refuse Lot 1990 1989 ASSETS Current Assets Cash and Investments $1,513,915 1,282,583 313,268 3,109,766 2,671,199 Receivables Property Taxes 550,354 550,354 500,538 Accrued Interest 12,695 12,695 13,598 Accounts 358,953 259,689 122,582 741,224 775,970 Other 161,467 7,541 2,526 171,534 39,474 Due from Other Funds 5,441 1,617 7,058 2,480 Inventories 41,268 6,737 48,005 46,635 Investment in Joint Venture - Help 11.909 29,391 41,300 24,443 2,087,512 1,604,077 677,079 313,268 4,681,936 4,074,337 Restricted Assets Cash and Investments - - - - - 88,708 Fixed Assets (Net of Accumulated Depreciation) 2,424,586 6,452,346 - 355.962 9.232,894 9.375,772 Total Assets 4,512,098 8 056 423 67179 669,230 13,914,830 13 5® LIABILITIES AND FUND EQUITY - Current Liabilities Cash Overdrafts 46,819 46,819 Accounts Payable 112,735 66,516 110,251 916 290,418 268,490 Accrued Payroll 10,522 10,522 11,717 Compensated Absences Payable 16,138 50,989 67,127 55,503 Other Payables 5,322 404 5,726 656 Due to Other Funds 19,240 19,240 5.445 Total Liabilities 134,195 128.027 176,310 1.320 439,852 341.811 Fund Equity Contributed Capital 1,867,529 6,141.604 - 325,186 8,334,319 8.526,082 Retained Earnings Reserved - Restricted Accounts 88,708 Unreserved 2,510,374 1,786,792 500,769 342,724 5,140,659 4,582,216 Total Retained Earnings 2,510,374 1.786.792 500.769 342,724 5,140,659 4,670,924 Total Fund Equity 4,377,903 7,928.396 500,769 667,910 13,474,978 13,197,006 Total Liabilities and Fund Equity $4.512.098 8,056,423 677,079 669,,2`30 13,914,830 13,538,817 See accompanying Notes to the Financial Statements. 75 VILLAGE OF DEERFIELD, ILLINOIS ENTERPRISE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - UNRESERVED FOR THE YEAR ENDED APRIL 30, 1990 Net Increase in Retained Earnings Unreserved 387,518 15,749 (46,826) 52,002 408,443 554,701 Retained Earnings - Unreserved May 1 1,972,856 1,771,043 547,595 290,722 4,582,216 4,027,515 Prior Period Adjustment 150,000 150,000 Adjusted Balance 2,122,856 1,771,043 547,595 290,722 4,732,216 4,027,515 April 30 $2,510,374 1,786,792 500,769 342,724 5,140,659 4,582,216 See accompanying Notes to the Financial Statements. 76 Commuter Parking Totals Water Sewerage Refuse Lot 1990 1989 Operating Revenues Charges for Services Water Sales $2,134,436 2,134,436 2,239,905 Sewer Charges 1,110,646 1,110,646 1,047,364 Refuse Billings 597,100 597,100 526,758 Parking Lot Fees 125,398 125,398 117,207 Surcharges 82,068 82,068 88,885 Miscellaneous 40,383 46,683 4,350 91,416 136,388 Total Operating Revenues 2,174,819 1,239,397 601,450 125,398 4,141,064 4,156,507 Operating Expenses Excluding Depreciation Administration 169,699 165,435 15,018 350,152 361,473 Operations 1,719,994 996,434 1,259,882 29,725 4,006,035• 3,693,865 Total Operating Expenses - Excluding Depreciation 1,889,693 1,161,869 1,274,900 29,725 4,356,187 4,055,338 Operating Income (Loss) before Depreciation 285,126 77,528 (673,450) 95,673 (215,123) 101,169 Depreciation 104,125 241,234 30,698 (376,057) 378,631 Operating Income (Loss) 181,001 (163,706) (673,450) 64,975 (591,180) (277,462) Nonoperating Revenues (Expenses) Interest Income 104,880 90,647 4,937 200,464 189,685 Property Taxes 621,687 621,687 541,018 Interest Expense (1,913) 104,880 90,647 626,624 - 822,151 728,790 Net Income (Loss) before Operating Transfers 285,881 (73,059) (46,826) 64,975 230,971 451,328 Operating Transfers (Out) (33,000) (30,000) - 4( 0,000) (103,000) (91,000) Net Income (Loss) 252,881 (103,059) (46,826) 24,975 127,971 360,328 Other Changes in Retained Earnings - Unreserved Depreciation that Reduces Contributed Capital 45,929 118,808 27,027 191,764 194,373 Transfer from Restricted Accounts 88,708 88,708 134,637 118,808 - 27,027 280,472 194,373 Net Increase in Retained Earnings Unreserved 387,518 15,749 (46,826) 52,002 408,443 554,701 Retained Earnings - Unreserved May 1 1,972,856 1,771,043 547,595 290,722 4,582,216 4,027,515 Prior Period Adjustment 150,000 150,000 Adjusted Balance 2,122,856 1,771,043 547,595 290,722 4,732,216 4,027,515 April 30 $2,510,374 1,786,792 500,769 342,724 5,140,659 4,582,216 See accompanying Notes to the Financial Statements. 76 1 e i i i i i i i n 00 r-I ON M N r-I O r- O 00 .t Ln m N M Ln O �0 r-q in 1�0 O N M %O m M %0 m %0 • Ul r-I N -.0 O O Ul %0 r4 00 O 00 00 00 r� �0 %0 M Ln, r-1 �O .t rl � %0 r M M rl- N It It N to rl M M r r" ra N Ln ra %0 N N to "4 N 41 O M N r-1 00 .t Ln M 00 O %0 00 m fl- Ln Ln rA r 4 rl O .t 00 It rl% O\ 0% It O\ It 00 0 rn%000 r0 Oo0or -1M N r\ r-+ m D\ r, 110 M M N 00 D\ O; H M N t\ rl .-4. N 0% n r- En Ln Ln 00 It It r" M En O\ rl 110 rl N M 00 r-1 N .t M %0 O N M r- r- r- o o c-o � z 4) 000. O u ,4 Q\ t\ Ul N H ro a° N p `n M rui M U') cri Lr) r+ O U 04 N M as aC) � � H H U n n r4 U) N N 00 N O 00 O 00 Hz O M ra W 4, Lr L� 1 ra 00 N 1O �O H A z a ) M M .t w04 H W U 44 A Ra H A -1 -1 -1 as 0 00 0 r- r- �D M w r4 .� (v M M M to 00 10 m ON M .t 00 WW 04 U W N N N O M \.O M �O En O t!1 Ed W W �4 r♦ r-♦ r I M O M N m rl r-1 N H O 4) .t .t .t O N N rl r- 00 O W W N N N rl H r4 H N W F z rn r4 H � F O H M�rnH00.t O O .t rd u'1 6 W w 00 N O O r-1 O M rl r-4 N 01% r4 4) 00 r-i O M 00 r 00 Ln V) M En O\ 1 z N .t r, 00 N 00 M 41 H ct Ln O M rl Ln 00 r-i N N 00 N r-1 fn .3 N rl M M N N N N Ln H r--I pq r 4 H ri O U U y G 0 a L=a u U to U) •ri U 4) r-4 u G � a) b •ur 4) cd N d UI r-1 Q >C r4 Qi U 4) U) A r 4 n N a) •,a G. U) a) u ►a pq U) a) 4) ca U) U N 1.) O z b U O )4 �4 oG N G G •rGl U a) 4) G •rl :j :j O G 4) b a) ) l (1) H bA b O u U U F O W 4) )4 LL A 1.) G rI d z co O •r1 S4 X N u U) •rl 5 •r) G G p u ::l •rl G 10 0 rn 0 U •ra -A 44 4) cd cn U 44 U G w G U U N En }4 En O rn G ca as O G co p 4) (1) 34 p 0 0 0 4) 4) m cd H O 0. •ra H PQ G. En En N LL ra U) m En N M E N 41 U 0 a1 44 En o ni cd 0 U F+ d O co co u b A 4) 4) 0 0 0 w U G r4 rr U 3 :4 U b p p G 3 10 d 3 a U W •rl G cd •,4 U 4) z 6 U U cd G z U p U u H w co a G a) �4 G G 4) a) .[ Cd a. Eno HAH En G. 1- la4ACa a cn U U `Ud U z cn n VILLAGE OF DEERFIELD, ILLINOIS WATER FUND BALANCE SHEET APRIL 30, 1990 ASSETS Current Assets Cash and Investments Receivables Accrued Interest Accounts - Billed - Unbilled Other Inventories Investment in Joint Venture = HELP Restricted Assets Cash and Investments Fixed Assets Cost Accumulated Depreciation Total Assets LIABILITIES AND FUND EQUITY Current Liabilities Accounts Payable Compensated Absences Payable Other Payables Fund Equity Contributed Capital Retained Earnings Reserved - Restricted Accounts Unreserved Total Retained Earnings Total Fund Equity Total Liabilities and Fund Equity See accompanying Notes to the Financial Statements, 78 1990 1989 $1,513,915 1,226,591 3,824 80,146 119,722 278,807 286,241 161,467 19,653 41,268 39,907 11.909 7.061 2,087,512 1,702,999 - 88.708 3,388,664 3,159,154 (964,078) (859,953) 2,424,586 2,299,201 _4,512,098 4,090,908 112,735 97,953 16,138 14,295 5,322 3,638 134,195 115,886 1,867,529 1,913,458 88,708 2,510,374 1,972,856 2,510,374 2,061,564 4,377,903 3,975,022 $4,512,098 4,090,908 i VILLAGE OF DEERFIELD, ILLINOIS WATER FUND STATEMENT OF CHANGES IN RETAINED EARNINGS - RESERVED - RESTRICTED ACCOUNTS FOR THE YEAR ENDED APRIL 30, 1990 Principal and Bond Interest DeRreciation Reserve Totals Increases - - - - Decreases Transfer to Operations and Maintenance Account $(21,708) 15 000) 5( 2.000) 8( 8.708) Net Increase (Decrease) (21,708) (15,000) (52,000) (88,708) Account Balances May 1 21,708 15.000 52.000 88.708 April 30 - - - - See accompanying Notes to the Financial Statements. 79 VILLAGE OF DEERFIELD, ILLINOIS WATER FUND STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - UNRESERVED - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 Net Increase in Retained Earnings Unreserved __387,518 376.113 Retained Earnings - Unreserved May 1 1,972,856 1,596,743 Prior Period Adjustment 150.000 Adjusted Balance 2.122.856 1.596.743 April 30 2,510,374 1.972,856 See accompanying Notes to the Financial Statement. 80 1990 1989 Budget Actual Actual Operating Revenues Charges for Services Water Sales $1,925,000 2,134,436 2,239,905 Miscellaneous Permits and Fees 20,000 14,316 56,713 Penalties 25,000 20,457 22,672 Other 5.610 Total Operating Revenues 1.970.000 2.174.819 2,319.290 Operating Expenses Excluding Depreciation Administration 170,470 169,699 154,316 Operations Distribution 1,506,600 1,428,462 1,540,757 Maintenance - Mains and Fire Hydrants 174,570 237,016 162,391 Maintenance - Meters 62.450 54.516 69.446 Total Operating Expenses Excluding Depreciation 1.914.090 1.889.693 1.926.910 Operating Income before Depreciation 55,910 285,126 392,380 Depreciation - 104.125 104.219 Operating Income 55.910 181.001 288.161 Nonoperating Revenues (Expenses) Interest Income 65,000 104,880 71,476 Interest Expense - Revenue Bonds (1.000) - (1.913) 64.000 104.880 69.563 Net Income before Operating Transfers 119,910 285,881 357,724 Operating Transfers (Out) Replacement Fund (33.000) (33.000) (30.000) Net Income 8 86.910 252.881 327.724 Other Changes in Retained Earnings - Unreserved Depreciation that Reduces Contributed Capital 45,929 48,389 Transfer from Restricted Accounts 88.708 134.637 48.389 Net Increase in Retained Earnings Unreserved __387,518 376.113 Retained Earnings - Unreserved May 1 1,972,856 1,596,743 Prior Period Adjustment 150.000 Adjusted Balance 2.122.856 1.596.743 April 30 2,510,374 1.972,856 See accompanying Notes to the Financial Statement. 80 1 1 81 VILLAGE OF DEERFIELD, ILLINOIS WATER FUND SCHEDULE OF OPERATING EXPENSES - BUDGET AND ACTUAL ' FOR THE YEAR ENDED APRIL 30, 1990 Budget Actual ' Administration Salaries $ 67,780 62,697 Employee Benefits 8,240 7,833 Professional Services 23,200 19,800 Travel, Training and Dues 1,100 1,007 . Printing and Advertising 700 1,767 Communications 10,050 9,862 Contractual Services 1,000 2,606 Insurance 36,900 43,088 Motor Vehicle Maintenance 1,200 1,008 ' Miscellaneous 1,000 1,403 Supplies 1,000 1,589 ' Motor Vehicle Supplies Occupancy 700 15,000 329 15,000 Apparel 1,800 1,307 Bond Principal 45,000 Repairs and Maintenance 800 403 Total 215,470 169,699 ' Less Nonoperating Items Bond Principal 45.000 - Total Administration 170.470 169.699 ' Operations Distribution Salaries 79,130 46,760 Overtime Employee Benefits 6,300 12,820 7,546 5,656 Professional Services 3,000 1,525 Printing and Advertising 1,100 ' Contractual Services 8,600 7,388 Utility Services 85,500 69,862 Motor Vehicle Maintenance 2,150 2,604 Repairs and Maintenance 3,000 1 X 216 ' Miscellaneous 1,300 959 Purchase of Water 1,300,000 1,280,635 Supplies $ 500 1,157 1 81 VILLAGE OF DEERFIELD, ILLINOIS WATER FUND SCHEDULE OF OPERATING EXPENSES - BUDGET AND ACTUAL (CONT.) FOR THE YEAR ENDED APRIL 30, 1990 Budget Actual Operations (Cont.) Distribution (Cont.) Motor Vehicle Supplies $ 1,000 1,039 Chlorine 1,000 Materials 1.200 2.115 Total Distribution 1,506,600 1.428,462 Maintenance - Main and Fire Hydrants Salaries 37,630 52,897 Overtime 12,100 22,131 Part -Time 22,400 19,129 Employee Benefits 6,940 7,017 Contractual Services 40,900 46,205 Motor Vehicle Maintenance 5,000 8,910 Repairs and Maintenance 10,500 8,262 Equipment Rental 1,000 Miscellaneous 2,900 36 Motor Vehicle Supplies 1,900 2,499 Small Tools and Equipment 300 196 Aggregates 7,000 11,235 Materials 26,000 42,941 Equipment 6,100 4,522 Improvements - Not Buildings 187,000 205,549 Motor Vehicles 11.250 11.250 Total 378,920 442,779 Less Nonoperating Items Fixed Assets Capitalized 204.350 205.763 Total Maintenance - Main and Fire Hydrants $ 174,570 237.016 82 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 i i VILLAGE OF DEERFIELD, ILLINOIS WATER FUND SCHEDULE OF OPERATING EXPENSES - BUDGET AND ACTUAL (CONT.) FOR THE YEAR ENDED APRIL 30, 1990 Operations (Cont.) Maintenance - Meters Salaries Overtime Part -Time Employee Benefits Professional Services Travel, Training and Dues Printing and Advertising Contractual Services Motor Vehicle Maintenance Repairs and Maintenance Miscellaneous Supplies Motor Vehicle Supplies Materials Small Tools and Equipment Equipment Total Less Nonoperating Items Fixed Assets Capitalized Total Maintenance - Meters Total Expenses M.] Budget Actual $ 37,830 42,369 840 519 950 840 6,980 5,577 3,000 317 600 1,000 317 2,200 795 2,700 2,000 1,400 63 300 25 350 12 1,000 890 3,000 248 300 14 16.500 24.277 78,950 78,263 16.500 23.747 62.450 54.516 $1,914,090 1.889 , 693 VILLAGE OF DEERFIELD, ILLINOIS WATER FUND SCHEDULE OF FIXED ASSETS AND DEPRECIATION FOR THE YEAR ENDED APRIL 30, 1990 Water System Equipment and Auto- motive Water System Equipment and Auto- motive Net Asset Value Assets Balances Balances May 1 Additions Retirements April 30 $2,825,273 189,992 3,015,265 333,881 39,518 3,159,154 229,510 373,399 33338 Accumulated Depreciation Balances Balances May 1 Additions Retirements April 30 626,738 74,299 701,037 233,215 29,826 $859,953 104,125 84 263,041 964,078 2,424,586 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 i i 1 i VILLAGE OF DEERFIELD, ILLINOIS SEWERAGE FUND BALANCE SHEET APRIL 30, 1990 ASSETS Current Assets Cash and Investments Receivables Accrued Interest Accounts - Billed - Unbilled Other Due From Other Funds Inventories Investment in Joint Venture - HELP Fixed Assets Cost Accumulated Depreciation Total Assets LIABILITIES AND FUND EQUITY Current Liabilities Accounts Payable Accrued Payroll Compensated Absences Payable Due to Other Funds Total Liabilities Fund Equity Contributed Capital Retained Earnings - Unreserved Total Fund Equity Total Liabilities and Fund Equity See accompanying Notes to the Financial Statements. 85 1990 1989 $ 1,282,583 1,171,046 12,695 9,774 78,528 73,927 181,161 176,264 7,541 16,839 5,441 6,737 6,728 29,391 17.382 1.604,077 1,471,960 8,593,124 8,589,455 _(2,140,778) (1,899,544) 6,452,346 6,689,911 8,056,423 8,161,871 66,516 75,685 10,522 8,079 50,989 41,208 5,445 128.027 130.417 6,141,604 6,260,411 1,786,792 1,771,043 7,928,396 8,031,454 $ 8,056,423 8,161,871 VILLAGE OF DEERFIELD, ILLINOIS SEWERAGE FUND STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - UNRESERVED - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 Operating Revenues Charges for Services Sewer Charges Surcharges - Construction Surcharges - Sara Lee Miscellaneous Permits and Fees Penalties Other Total Operating Revenues Operating Expenses Excluding Depreciation Administration Operations Treatment Plant Cleaning and Maintenance Construction Total Operating Expenses Excluding Depreciation Operating Income (Loss) before Depreciation Depreciation Operating Incase (Loss) Nonoperating Revenues Interest Income Net Income (Loss) before Operating Transfers Operating Transfers (Out) Replacement Fund Net Income (Loss) Other Changes in Retained Earnings - Unreserved Depreciation that Reduces Contributed Capital Net Increase in Retained Earnings - Unreserved Retained Earnings - Unreserved May 1 April 30 See accompanying Notes to the Financial Statements. 86 1990 1989 Budget Actual Actual $1,150,000 1,110,646 1,047,364 50,000 47,370 46,964 34,698 41,921 20,000 7,830 45,260 11,000 11,378 10,606 1.000 27.475 1.137 1.232.000 1.239,397 1.193.252 194,430 165,435 191,986 803,920 780,599 629,158 125,510 96,719 98,674 144.180 119.116 97.667 1.268.040 1.161.869 1.017.485 (36,040) 77,528 175,767 68.500 241.234 243.714 (104,540) (163,706) (67,947) 70.000 90.647 69.032 (34,540) (73,059) 1,085 (30.000) (30.000) (31.000) (64,540) (103,059) (29,915) 118.808 118.957 15,749 89,042 1.771.043 1.682.001 1,786,792 1,771.043 1 1 I 1 1 F_ J VILLAGE OF DEERFIELD, ILLINOIS SEWERAGE FUND SCHEDULE OF OPERATING EXPENSES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 Administration Salaries Overtime Employee Benefits Professional Services Travel, Training and Dues Printing and Advertising Communications Insurance Motor Vehicle Maintenance Repairs and Maintenance Miscellaneous Supplies Motor Vehicle Supplies Occupancy Apparel Contractual Services 87 1 Budget $ 67,780 530 8,240 200 550 100 4,430 90,300 900 1,300 700 700 1,000 15,000 1,500 1.200 194.430 282,260 7,880 4,300 44,830 6,000 1,550 1,000 8,100 34,500 209,300 3,000 159,000 1,000 12,900 7,000 8,000 2,800 5,000 $ 300 Actual 60,347 945 7,738 585 118 3,814 70,074 759 30 1,583 1,780 734 15,000 1,128 800 165.435 294,849 12,109 4,281 37,934 1,859 109 8,785 1,000 214,127 4,189 151,254 800 13,360 3,127 12,371 3,645 5,754 Total Administration Operations ' Treatment Plant Salaries Overtime Part -Time t Employee Benefits Professional Services Travel, Training and Dues Printing and Advertising Communications Contractual Services t Utility Services Motor Vehicle Maintenance Repairs and Maintenance Equipment Rental ' Supplies Motor Vehicle Supplies Chlorine Aggregates Materials Street Signs 87 1 Budget $ 67,780 530 8,240 200 550 100 4,430 90,300 900 1,300 700 700 1,000 15,000 1,500 1.200 194.430 282,260 7,880 4,300 44,830 6,000 1,550 1,000 8,100 34,500 209,300 3,000 159,000 1,000 12,900 7,000 8,000 2,800 5,000 $ 300 Actual 60,347 945 7,738 585 118 3,814 70,074 759 30 1,583 1,780 734 15,000 1,128 800 165.435 294,849 12,109 4,281 37,934 1,859 109 8,785 1,000 214,127 4,189 151,254 800 13,360 3,127 12,371 3,645 5,754 VILLAGE OF DEERFIELD, ILLINOIS SEWERAGE FUND SCHEDULE OF OPERATING EXPENSES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 Budget Actual Operations (Cont.) Treatment Plant (Cont.) Small Tools and Equipment $ 500 1,094 Apparel 1,700 1,393 Equipment 34,700 6,065 Miscellaneous 3,000 4,065 Total 838,620 782,170 Less Nonoperating Items Fixed Assets Capitalized 34,700 1,571 Total Treatment Plant 803,920 780.599 Cleaning and Maintenance Salaries 54,600 52,268 Overtime 4,620 4,047 Part -Time 2,520 2,516 Employee Benefits 10,070 6,801 Contractual Services 10,000 5,272 Motor Vehicle Maintenance 4,000 4,337 Repairs and Maintenance 5,000 4,891 Equipment Rental 3,000 255 Miscellaneous 2,000 1,055 Supplies 20,100 7,563 Motor Vehicle Supplies 1,500 1,134 Aggregates 1,100 2,086 Materials 7,000 4,204 Equipment 6,300 2,098 Small Tools and Equipment 300 290 Total 132,110 98,817 Less Nonoperating Items Fixed Assets Capitalized 6,600 2,098 Total Cleaning and Maintenance $125,510 96,719 X.I. 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS SEWERAGE FUND SCHEDULE OF OPERATING EXPENSES - BUDGET AND ACTUAL (CONT.) FOR THE YEAR ENDED APRIL 30, 1990 .. Budget Actual Operations (Cont.) Construction Salaries $ 82,760 71,748 Overtime 2,200 359 Part -Time 1,260 1,226 Employee Benefits 15,260 8,781 Contractual Services 5,000 3,750 Motor Vehicle Maintenance 5,500 6,151 Repairs and Maintenance 7,500 3,149 Equipment Rental 1,000 Supplies 2,000 97 Motor Vehicle Supplies 2,000 2,289 Aggregates 5,500 4,521 Materials 14,000 17,045 Small Tools and Equipment 200 Total Construction 144,180 119,116 Total Expenses 51,26 .. VILLAGE OF DEERFIELD, ILLINOIS SEWERAGE FUND SCHEDULE OF FIXED ASSETS AND DEPRECIATION FOR THE YEAR ENDED APRIL 30, 1990 Sewer System Equipment and Auto- motive Assets Balances Balances May 1 Additions Retirements April 30 $8,343,360 246,095 3,669 +8,555 8,343,360 249,764 8,593,124 Accumulated Depreciation Balances Balances May 1 Additions Retirements April 30 Sewer System and Plant 1,709,229 216,330 1,925,559 Equipment and Auto- motive 190,315 24,904 215,219 $1,8_ 9 241,234 2,140,778 Net Asset Value 6,452,346 .I 1 1 1 1 1 1 1 1 1 1 i 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS REFUSE FUND BALANCE SHEET APRIL 30, 1990 ASSETS Current Assets Cash and Investments Receivables Property Taxes Accounts - Billed - Unbilled Other Due from Other Funds Total Assets LIABILITIES AND FUND EQUITY Current Liabilities Cash Overdrafts Accounts Payable Due to Other Funds Total Liabilities Fund Equity Retained Earnings - Unreserved Total Liabilities and Fund Equity See accompanying Notes to the Financial Statements. 91 1990 1989 16,044 $550,354 500,538 26,395 28,337 96,187 91,479 2,526 2,982 1,617 2.480 6779 64® 46,819 110,251 94,265 19.240 176,310 94,265 500,769 547,595 $677,079 641,860 VILLAGE OF DEERFIELD, ILLINOIS REFUSE FUND STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - UNRESERVED - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 See accompanying Notes to the Financial Statements. 92 1990 1989 Budget Actual Actual Operating Revenues Charges for Services Refuse Billing $ 612,000 597,100 526,758 Miscellaneous 4,350 Total Operating Revenues 612,000 601,450 526,758 Operating Expenses Administration 16,350 15,018 15,171 Operations Contractual Services 1,180,000 1,259,882 1,055,989 Total Operating Expenses 1,196,350 1,274,900 1,071,160 Operating Income (Loss) (584,350) (673,450) (544,402) Nonoperating Revenues (Expenses) Interest Income 15,000 4,937 49,177 Property Taxes 545,000 621,687 541,018 560,000 626,624 590,195 Net Income (Loss) $ (24,350) (46,826) 45,793 Retained Earnings - Unreserved May 1 547,595 501,802 April 30 500,769 547,595 See accompanying Notes to the Financial Statements. 92 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS COMMUTER PARKING LOT FUND BALANCE SHEET APRIL 30, 1990 ASSETS Current Assets Cash and Investments Fixed Assets Cost Accumulated Depreciation Total Assets LIABILITIES AND FUND EQUITY Current Liabilities Accounts Payable Other Payables Total Liabilities Fund Equity Contributed Capital Retained Earnings - Unreserved Total Fund Equity Total Liabilities and Fund Equity See accompanying Notes to the Financial Statements. 93 1990 1989 $ 313.268 257.518 691,458 691,458 (335,496) (304.798) 355.962 386.660 669.230 644.178 916 587 404 656 1.320 1,243 325,186 352,213 342.724 290.722 667.910 642.935 669 230 644.178 VILLAGE OF DEERFIELD, ILLINOIS COMMUTER PARKING LOT FUND STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - UNRESERVED - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 Operating Revenues Parking Lot Fees Operating Expenses Excluding Depreciation Operations Operating Income before Depreciation Depreciation Operating Income before Operating Transfers Operating Transfers (Out) Street and Bridge Fund Net Income Other Changes in Retained Earnings - Unreserved Depreciation that Reduces Contributed Capital Net Increase in Retained Earnings - Unreserved Retained Earnings - Unreserved May 1 April 30 1990 1989 Budget Actual Actual $130,000 125,398 117,207 39.440 29.725 39.783 90,560 95,673 77,424 - 30.698 30.698 90,560 64,975 46,726 4( 0.000) 4( 0.000) 3( 0.000) 50,560 24,975 16,726 See accompanying Notes to the Financial Statements. 94 27.027 27.027 52,002 43,753 290.722 246.969 342.724 290.722 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS COMMUTER PARKING LOT FUND SCHEDULE OF OPERATING EXPENSES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 Operations Parking Lots - Village and Federal Funds Salaries Benefits Insurance Utility Service Repairs and Maintenance Supplies Aggregates Equipment Property Rentals Materials Contractual Total Less Nonoperating Items Fixed Assets Capitalized Total Parking Lots - Village and Federal Funds Parking Lots - Village Construction Salaries Contractual Benefits Insurance Utility Services Repairs and Maintenance Supplies Aggregates Materials Equipment Total Parking Lots - Village Construction Total Operating Expenses 95 Budget Actual $4,200 4,319 600 660 40 269 2,300 4,133 2,500 65 500 322 500 245 500 7,500 7,440 800 45 2.500 12.472 21,940 17,253 500 21.440 17.253 4,300 4,401 2,500 710 748 340 333 6,800 6,332 1,000 368 500 245 250 1,500 45 100 18.000 12.472 $39,440 29,725 VILLAGE OF DEERFIELD, ILLINOIS COMMUTER PARKING LOT FUND SCHEDULE OF FIXED ASSETS AND DEPRECIATION FOR THE YEAR ENDED APRIL 30, 1990 Assets Balances Balances May 1 _ Additions Retirements April 30 Land $ 77,500 77,500 Parking Lot 613,958 613.958 691.458 Accumulated Depreciation Balances Balances May 1 Additions Retirements April 30 Parking Lot $304,798 30.698 335.496 Net Asset Value 355,962 96 1 1 1 1 fl 1 1 1 1 1 1 1 1 1 1 r 1 1 INTERNAL SERVICE FUND 1 I 1 i 1 1 1 Garage Fund INTERNAL SERVICE FUNDS 1 1 i 1 r 1 Garage Fund - To account for all activity necessary to maintain the efficient and ' safe operation of Village vehicles and equipment. The Garage is operated and maintained by the Village of Deerfield and the various departments are billed according to the services rendered. 1 1 i 1 r 1 1 1 1 i J 1 1 C 1 t 1 11 i r 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Y 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS GARAGE FUND BALANCE SHEET APRIL 30, 1990 ASSETS Receivables - Accounts Inventories Total Assets LIABILITIES AND FUND EQUITY Liabilities Cash Overdrafts Accounts Payable Compensated Absences Payable Other Payables Total Liabilities Fund Equity Retained Earnings - Unreserved Total Liabilities and Fund Equity See accompanying Notes to the Financial Statements. 97 1990 $ 255 43.810 44,065 89,227 6,684 13,069 1.605 110,585 6�6,520) 44,065 V 1989 334 36.750 3_ 67,658 2,470 10,656 1.356 82,140 (45,056) 37.084 VILLAGE OF DEERFIELD, ILLINOIS GARAGE FUND STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN RETAINED EARNINGS - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 Operating Revenues Charges for Services Billings Operating Expenses Operations Net Income (Loss) before Operating Transfers Operating Transfers (Out) Replacement Fund Net Income (Loss) Retained Earnings May 1 April 30 1990 1989 Budget Actual Actual $169,200 176,262 154,680 177,520 197,726 165,934 (8,320) (21,464) (11,254) (500) (8,320) (21,464) (11,754) See accompanying Notes to the Financial Statements. 98 45 056) 3( 3,302) 6( 6 , 520) 45,0, 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS GARAGE FUND STATEMENT OF CHANGES IN FINANCIAL POSITION FOR THE YEAR ENDED APRIL 30, 1990 Cash Was Provided By Decrease in Current Assets Increase in Current Liabilities Cash Was Used To Fund Operations Net Loss Increase in Current Assets Net Increase (Decrease) Cash and Investments May 1 April 30 See accompanying Notes to the Financial Statements. 99 1990 1989 11,300 6,876 64 6.876 11.364 21,464 11,754 6.981 28.445 11.754 (21,569) (390) (67,658) (67.268) $(89,227) 67 658) VILLAGE OF DEERFIELD, ILLINOIS GARAGE FUND SCHEDULE OF OPERATING EXPENSES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 100 Budget Actual Operations Public Works Department Salaries $ 74,500 79,260 Overtime 5,500 13,812 Employee Benefits 10,770 10,058 Apparel 500 413 Travel, Training and Dues 700 187 Printing and Advertising 400 51 Insurance 6,800 6,545 Miscellaneous 200 497 Professional Services 50 Contractual Services 100 49 Utility Services 1,900 1,676 Repairs and Maintenance 5,000 1,453 Supplies 56,400 72,486 Motor Vehicle Supplies 800 395 Equipment 9,200 6,747 Communications 2,600 2,317 Materials 600 321 Small Tools and Equipment 1,500 1,459 Total Operating Expenses $177,520 197,726 100 1 1 F, 1 1 1 1 1 1 1 1 1 1 1 1 1 FIDUCIARY FUND TYPES I I 1 1 I 1 J 1 1 1 1 1 1 1 1 1 1 TRUST AND AGENCY FUNDS 1 C 1 1 TRUST AND AGENCY FUNDS iExpendable Trust Fund Corporate Purpose Bond Series of 1987 Redemption Fund - to account for investments held in escrow to pay future principal and interest requirements on the Corporate Purpose Bond Series of 1987. IPension Trust Fund Deposit Fund - to account for monies on deposit with the village which are being held on a temporary basis. Deferred Compensation Plan Fund - to account for salary deductions held by the government for certain employees. The deferred compensation is available to employees upon termination or retirement. Special Assessment Fund - to account for the collection of assessments levied to retire special assessments.for which the Village has no obligation. Deerfield Cemetery Association Fund - to account for the monies on deposit with the Village which are being held for the Deerfield Cemetery Association. 1 1 1 1 I 1 Police Pension.Fund - to costs. Resources are account for the contributed by accumulation of resources to pay pension police force members at rates fixed by state statutes and by the government through an annual property tax levy. Agency Fund Deposit Fund - to account for monies on deposit with the village which are being held on a temporary basis. Deferred Compensation Plan Fund - to account for salary deductions held by the government for certain employees. The deferred compensation is available to employees upon termination or retirement. Special Assessment Fund - to account for the collection of assessments levied to retire special assessments.for which the Village has no obligation. Deerfield Cemetery Association Fund - to account for the monies on deposit with the Village which are being held for the Deerfield Cemetery Association. 1 1 1 1 I 1 1 1 1 1 1 1 n 1 L 1 1 1 1 I 1 O H O naa O, O s N 0 0%0 ON nco Y'1 J .1 Vl N a n m m .t 0 0 0% n n n n n u1 m m n 4o 14 n m N 10 N O m O N %0 N N V1 N O I N n .; 40 V1 h O 40 40 N m T N u•1 0` N m 40 n N aD O n 10 m N 10 0 N 14 n .-1 co 4O .•1 O co r•1 O O 10 40 Y1 10 O 11 Q V1 10 to r1 N ei rl rl ,4 a O 0 m .-ION4D rn O NNOPc nn mom o F n v1NO,N n v rin On .-an NO1O .t h J O 14 0+ ai 01 O N O 0+ 10 O %O .7 O O� O 0` %0 10 .1 �0 V1 O N co O h Ol h N N V1 O 0, V1 mrn Cl) m V1Om O �40N m Vl 'I O 4D m O O o N .r s O 10 rl n O r4 11 Vl 10 n rl r•1 rl r1 ni C O in to O O kn II I � IiI I!I $4 N N N E O N� m U a q a d .d 1 a a U 41 4) a a) E W C U C. w G O mA n n H C m T � Om W V m 1 H 0 N O m o 0 q i 2 0 .n `a az w 1 j o ap a n n N.. a � o s N O a o� o� 40 0+ m aO I ro Wa', O N to m n U oa m m m m m Wz H W C7 �i 01 .•40 o nn o m��n0 m0 O O v N N c�s O O M z F/ U) m %0 N In m O O m O, N 04 s rT+ a pH z o 0 H V :3 a °° . ., a w w E4 4 a m O o O 0 O 0 O o O O E .4 E o 0 0 o O m N 14 4) O 0 0 0 0 0 1 0 ,vtnaa) 0 0 0 0 b 40) A) 0 ano °.1 ° ° X O4o� N .oi ,°� W U a a.1 C 41 e d e � +� N a Cn m a U +/ V 4) 4 a d w W pq �4 a)i U w a •4 v �¢ w c" a4 43 ao N b O `� w° z. m a a W a a T 0 a 4) y aO R F b 5 O q .a+ .°I ° .ai x W 4 � � a � ro -Ai rn to a a) r.4 a A A -+ m w -+ 4 W + m 6' 4) w 43 N a a 4) u .4 .4 'O .4 Q a k 0 w >� v 4) to 43 0 O 4) .4 -H A 14 A 4 w +� 9 > .i F a 'W , w w w A 4W '0 .4 43 d N a >1 a s 44 .a U 41 O r1 a .-7 4) a a a w a. 0 C b > a .a b 4) a .4 HI .1 +1 A PI .4 to 4) w '•1 .-1 b A w 4) E m r a a) w O () a 44 R -, O O a -1 4a 1 1 7 > a w 4) w a a 43 O aw a a .0 .1 41 aa -1 O O U a O aa W m 0 J U u O •. O u A +) W F .4 .1 U a 0 4 A 4) F a tI F F d 4) w a7 d 0 A O 4) 0 7 w 7 •O a q a ua d0 4) ulu a dgaagP m Gam a U Ix 0 . i W fn O H VILLAGE OF DEERFIELD, ILLINOIS EXPENDABLE TRUST FUND CORPORATE PURPOSE BOND SERIES OF 1987 STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE FOR THE YEAR ENDED APRIL 30, 1990 Revenues Interest Expenditures Interest Excess of Revenues over Expenditures Fund Balance May 1 April 30 See accompanying Notes to the Financial Statements. 102 $843,000 $843,000 1 1 1 i 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS TRUST AND AGENCY FUNDS POLICE PENSION FUND STATEMENT OF REVENUES, EXPENSES, AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL FOR THE YEAR ENDED APRIL 30, 1990 Operating Revenues Taxes Property Taxes Replacement Taxes Contributions Employee Contributions Interest Total Revenues Operating Expenses Benefits and Refunds Pension Payments Separation Refunds Miscellaneous Filing Fee Total Operating Expenses Net Income Fund Balances May 1 April 30 1990 1989 Budget Actual Actual $150,000 154,598 148,818 6,000 5,863 6,612 115,000 127,777 83,619 550.000 562.558 488,746 821.000 850,796 727.795 188,000 117,720 88,660 20,000 1.000 568 1,620 209,000 118,288 90.280 612 000 732,508 637,515 5,692,555 5,055,040 6,425,063 5,692,555 See accompanying Notes to the Financial Statements. 103 VILLAGE OF DEERFIELD, ILLINOIS TRUST AND AGENCY FUNDS POLICE PENSION FUND STATEMENT OF CHANGES IN FINANCIAL POSITION FOR THE YEAR ENDED APRIL 30, 1990 Cash Was Provided By Operations Net Income Increase in Current Liabilities Cash Was Used To Increase Current Assets Net Increase (Decrease) Cash and Investments May 1 April 30 See accompanying Notes to the Financial Statements. 104 1990 $ 732,508 9.342 741,850 1989 637,515 275 637,790 9.130 6,434 732,720 631,356 5.470,689 4,839,333 $6,20®3 409 5.4 1 1 1 1 1 1 1 1 1 1 1 i 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS AGENCY FUNDS COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES FOR THE YEAR ENDED APRIL 30, 1990 Balances May 1 All Funds 2,012 ASSETS 358,272 Cash and Investments $ 251,651 Receivables 68.079 Other 584 Due from Other Funds 1,779 Assets Held by Agents for Deferred Compensation Plan (Market Value) 878,390 Total Assets 1,132,404 LIABILITIES Accounts Payable 642 Deposits Payable 185,293 Due to Participants 878,390 Rebate Payable 68,079 Total Liabilities 132,404 Deposit Fund ASSETS Cash and Investments 166,953 Receivables - Other 165 Due from Other Funds 1,779 Total Assets 168,897 LIABILITIES Accounts Payable 642 Deposits Payable 168.255 Total Liabilities 168,897 Deferred Compensation Plan Fund ASSETS Assets Held by Agents for Deferred Plan (Market Value) 818,390 LIABILITIES Due to Participants 878,390 See accompanying Notes to the Financial Statements. 105 Balances Additions Deductions April 30 169,592 68,079 353,164 392 192 5,149 6,928 157,586 1,035,976 332,327 68,471 1,396,260 1,370 2,012 172,979 358,272 157,586 1,035,976 68.079 331 935 6 1,396,260 159,963 326,916 165 5.149 6.928 165112 165 333,844 1,285 1,927 163.662 331.917 164,947 - 333,844 157,586 - 1,035,976 157,586 1,035,976 VILLAGE OF DEERFIELD, ILLINOIS AGENCY FUNDS COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES (CONT.) FOR THE YEAR ENDED APRIL 30, 1990 See accompanying Notes to the Financial Statements. 106 Balances Balances May 1 Additions Deductions April 30 Special Assessment ASSETS Cash and Investments $68,079 68.079 - Total Assets _68,079 61a079 LIABILITIES Rebate Payable 68.079 61,019 Deerfield Cemetery Association ASSETS Cash and Investments 16,619 9,629 26,248 Receivables - Other 419 227 192 Total Assets 17.038 96629 227 26,440 LIABILITIES Accounts Payable 85 85 Deposits Payable 17.038 9.317 26.355 Total Liabilities 17 038 9-6412 26.440 See accompanying Notes to the Financial Statements. 106 1 I i 1 t 1 1 1 I P-� I 1 1 1 1 1 t L� 1 ACCOUNT GROUPS 1 1 1 1 1 1 I 1 f rl J 1 I I GENERAL FIXED ASSETS ACCOUNT GROUP Fixed assets used in operations are not accounted for in governmental funds. General fixed assets include all fixed assets not accounted for in Proprietary Funds or in Trust Funds. 1 1 1 1 1 1 1 1 1 1 1 1 1 r� 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FIXED ASSETS ACCOUNT GROUP SCHEDULE OF GENERAL FIXED ASSETS - BY SOURCE APRIL 30, 1990 GENERAL FIXED ASSETS Land $2,919,603 Buildings and Improvements 4,804,858 Vehicles 657,850 Equipment 1,471,197 9,8® INVESTMENT IN GENERAL FIXED ASSETS General Revenues 7,953,508 General Obligation Bonds 1,500,000 Installment Contracts 400,000 $9,853,508 107 H 7 H H U A Pa z H pa O O U U H O U O QQ- U ON rW+ H N W W �j 0 CL' v1 M A� dH A A � O>CPL4 W W H �a a W z C7 W C9 W O D A W U W 1 1 tr) r i N 00 > N %D � %.o ao O J-i O 00 Ir1 O Ln ca M 00 r-i M O 0 O O u'1 �4 C9 H O M ON %.D 00 0 r4 N N � O� 11 Ln O 00 N r- r- O'N M \D rl r-i w U a a � 00 1 r-i r-I W '4 O r-4 M 0 %D u1 M Ln U U1 00 00 N u1 r-4 �D y (n M O Ln 00 O F E N ON �-D 00 7 O r4 Cdd M r 4 m ,4 0 N m Ul 00 9Q M 4 0 C14 ce) 00 0 .b O0 It I ' �) N H m r-1 r 1 N 1 •.i > J-i O ca O 44 �4 C9 cd O 0 w 3 0 r4 -A cd U U ' w U a a 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS GENERAL FIXED ASSETS ACCOUNT GROUP SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS - BY FUNCTION AND ACTIVITY FOR THE YEAR ENDED APRIL 30, 1990 817, 860 wivej Additions 346,914 180,040 3,737,174 4,2® Retirements 1,021,583 95,897 111,000 1,228,480 Balances April 30 2,343,865 2,908,561 4,601,082 9,853,508 Balances Function and Activity May General Government $3,018,534 Public Safety 2,824,418 Public Works 974.908 817, 860 wivej Additions 346,914 180,040 3,737,174 4,2® Retirements 1,021,583 95,897 111,000 1,228,480 Balances April 30 2,343,865 2,908,561 4,601,082 9,853,508 1 rl 1 1 1 1 1 Fj� -1 L-A 1 �ri 1 1 1 1 1 1 1 1 1 1 1 I 1 J 1 1 1 1 1 1 GENERAL FIXED ASSETS ACCOUNT GROUP i 1 1 1 1t L 1 1 1 I 1 1 I 1 1 1 1 1 1 1 1 1 1 1 I 1 GENERAL LONG -TERM DEBT ACCOUNT GROUP ITo account for the noncurrent portion of the government's Bond Issue liabilities. 1 1 1 1 r 1 t I u r' 1 1 1 1 1 1 1 1 Fl, L 1 C 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 O r4 r--I W m Q a co a o 0 0 E. +� W n h N N rn xA O woi� O pq C LI 0 O rl p"' ° h h g F R H Q O H 01 9.1 po H 43 O CO w -. F W 01 F a ro o O W a3 14 N n O O 01 .10 O O, O O O 0 C O� a0 43 m a] .a iq a .�i N 10 10 N O 01 [aHj W 8 O N M l7 C7 U' .i rl rl 0 ,4 O '3 ri OD O O O N 00 LI y0 O O N n O O 01 00 to H m �O N O O +1 .d W C9 .d R O aD O O O N N N at 0) A O 'W CO N O o O O M n N O H 0 0 of o P. U3 4 y� a O N 14 p o 4.4 N o m m P4 w 0 0 1 O W m �i W H ° a vi r1 0 0 Z H 43 . "4 t0 W $4 N co %n D J O O O O �..� 31 0 01 00 H1-4 o 0 w tn a N N H a u O U C7 O m° z rn qq- r7 H w pq PO4 r3,4 at we a7 01 +/ N a N n O O H m m N o 0 0 of N o 0 LL4 A O N1 a N w r' a .n n v7 r7 W $4 4 0 N m M L) °a w� 00 w� ° a� wo ���mrl � o 0 $" O ,d w cn r J y H W r. o F ra H A W a00 �w q m Ln ma vNi H � 'a ln 3 N .d w 10 v1 n h n tai pOq N O r4 r--I W m Q dt 8 E. +� W rn xA a woi� m pq C LI 0 01 '44 p"' ° Q g F R H Q O H 01 9.1 po H Q CO w -. F W 01 0 00 0 O W U' ,4 N a W a3 14 P, F O 01 .10 F A N 'Z. •-I F 0 C a0 O a0 43 m a] .a iq a W N O 01 [aHj W 8 6 C7 U' O r4 r--I l� 1 1 1 1 1 1 1 1 L� I �I 1 1 t I C 1 J 1 1 1 1 1 1 1 1 I 1 1 C J 1 1 1 1 SUPPLEMENTARY DATA 1 VILLAGE OF DEERFIELD, ILLINOIS ILLINOIS MUNICIPAL RETIREMENT FUND REQUIRED SUPPLEMENTARY INFORMATION ANALYSIS OF FUNDING PROGRESS ' APRIL 30, 1990 ' (1) (4) (6) Net Assets Unfunded Unfunded Pension Available (2) (3) Pension (5) Benefit Obligation ' Calendar for Benefits (Lower of Cost Pension Benefit Percentage Funded Benefit Obligation Annual Covered as a Percentage of Covered Payroll Year or Market) Obligation (1) _ (2) (2) - (1) Payroll (4) _ (5) 1987 11,185,411 3,229,435 55.291 1,444,018 2,292,114 63.001 ' 1988 1,488,727 3,137,943 47.44 1,649,216 2,529,121 65.21 1989 $1,770,910 3,489,507 50.751 1,718,597 2,636,443 65.191 1 1 1 1 1 1 (During the implementation transition period all information required is presented for as many years as is available.) Analysis of the dollar amounts of net assets available for benefits pension y � P benefit obligation, and unfunded pension benefit obligation in isolation can be misleading. Expressing the net assets available for benefits as a percentage of the pension benefit obligation provides one indication of funding status on a going- concern basis. Analysis of this percentage over time indicates whether the system is becoming financially stronger or weaker. Generally, the greater this percentage, the stronger the PERS. Trends in unfunded pension benefit obligation and annual covered payroll are both affected by inflation. Expressing the unfunded pension benefit obligation as a percentage of annual covered payroll approximately adjusts for the effects of inflation and aids analysis of progress made in accumulating sufficient assets to pay benefits when due. Generally, the smaller this percentage, the stronger the PERS. 111 VILLAGE OF DEERFIELD, ILLINOIS POLICE PENSION FUND REQUIRED SUPPLEMENTARY INFORMATION ANALYSIS OF FUNDING PROGRESS APRIL 30, 1990 (6) Unfunded (Assets in Excess of) Pension Benefit Obligation as a Percentage of Covered Payroll (4) _ (5) (62.00)% (63.00) (81.00)% (During the implementation transition period all information required is presented for as many years as is available.) Analysis of the dollar amounts of net assets available for benefits, pension benefit obligation, and unfunded pension benefit obligation in isolation can be misleading. Expressing the net assets available for benefits as a percentage of the pension benefit obligation provides one indication of funding status on a going- concern basis. Analysis of this percentage over time indicates whether the system is becoming financially stronger or weaker. Generally, the greater this percentage, the stronger the PERS. Trends in unfunded pension benefit obligation and annual covered payroll are both affected by inflation. Expressing the unfunded pension benefit obligation as a percentage of annual covered payroll approximately adjusts for the effects of inflation and aids analysis of progress made in accumulating sufficient assets to pay benefits when due. Generally, the smaller this percentage, the stronger the PERS. 112 (4) Unfunded (1) (Assets in Net Assets Excess of) Available (2) (3) Pension (5) for Benefits Pension Percentage Benefit Annual Fiscal (Lower of Cost Benefit Funded Obligation Covered Year or Market) Obligation (1) _ (2) _(2) - (1) Payroll 1988 $5,055,040 4,290,531 118.00% (764,509) 1,237,594 1989 5,692,830 4,823,277 118.00 (869,278) 1,380,114 1990 $6,425,063 5,242,623 123.00% (1,182,440) 1,460,008 (6) Unfunded (Assets in Excess of) Pension Benefit Obligation as a Percentage of Covered Payroll (4) _ (5) (62.00)% (63.00) (81.00)% (During the implementation transition period all information required is presented for as many years as is available.) Analysis of the dollar amounts of net assets available for benefits, pension benefit obligation, and unfunded pension benefit obligation in isolation can be misleading. Expressing the net assets available for benefits as a percentage of the pension benefit obligation provides one indication of funding status on a going- concern basis. Analysis of this percentage over time indicates whether the system is becoming financially stronger or weaker. Generally, the greater this percentage, the stronger the PERS. Trends in unfunded pension benefit obligation and annual covered payroll are both affected by inflation. Expressing the unfunded pension benefit obligation as a percentage of annual covered payroll approximately adjusts for the effects of inflation and aids analysis of progress made in accumulating sufficient assets to pay benefits when due. Generally, the smaller this percentage, the stronger the PERS. 112 1 1 1 1 t I 1 1 113 VILLAGE OF DEERFIELD, ILLINOIS ' ILLINOIS MUNICIPAL RETIREMENT FUND REQUIRED SUPPLEMENTARY INFORMATION ' REVENUES BY SOURCE APRIL 30, 1990 Employer Revenues by Source Contributions as Calendar Employee Employer Investment a Percentage of ' Year Contributions Contributions Income Totals Payroll 1980 $ 59,013 94,605 N/A 153,618 8.35% ' 1981 70,160 93,047 N/A 163,207 8.35 1982 73,144 102,696 N/A 175,840 8.32 ' 1983 78,651 114,848 N/A 193,499 8.32 1984 82,899 127,571 N/A 210,470 8.30 1985 89,372 151,116 11/A 240,488 8.30 1986 95,745 167,152 N/A 262,897 8.27 1987 103,137 179,472 N/A 282,609 8.21 1988 113,907 204,352 N/A 318,259 8.08 1989 $118,539 266,280 N/A 384,819 10.10% 1 1 1 t I 1 1 113 VILLAGE OF DEERFIELD, ILLINOIS POLICE PENSION FUND REQUIRED SUPPLEMENTARY INFORMATION REVENUES BY SOURCE AND EXPENSES BY TYPE APRIL 30, 1990 114 Expenses by Tyne Employer Administrative Revenues by Source Year Contributions as Fiscal Employee Employer Investment $ 25,992 a Percentage of Year Contributions Contributions Income Totals Payroll 1981 $ 67,138 124,536 109,761 301,435 14.20% 1982 74,509 109,258 111,758 295,525 14.35 1983 76,123 127,124 212,511 415,758 14.40 1984 83,022 140,265 265,078 488,365 14.56 1985 86,623 156,125 315,417 558,165 14.53 1986 97,525 173,723 361,378 632,626 14.52 1987 99,923 180,434 458,868 739,225 15.08 1988 107,902 150,024 473,397 731,323 12.08 1989 83,619 155,430 488,746 727,795 11.26 1990 $127,777 160,461 562,558 850,796 11.00% 114 Expenses by Tyne Fiscal Administrative Year Benefits Expenses Refunds Totals 1981 $ 25,992 25 5,276 31,293 1982 29,413 320 14,281 44,014 1983 29,403 200 23,003 52,606 1984 37,455 75 37,530 1985 65,912 25 10,873 76,810 1986 66,736 937 1,137 68,810 1987 83,885 99 17,050 101,034 1988 87,859 53 87,912 1989 88,660 1,620 90,280 1990 $117,720 568 118,288 114 1 I VILLAGE OF DEERFIELD, ILLINOIS POLICE PENSION FUND SCHEDULE OF OFFICERS' DEPOSITS I APRIL 30, 1990 Balance Balance May 1 Deposits Withdrawals April 30 ' Kenneth Anderson $ 36,492 4,703 41,195 Leo Anderson 35,959 4,545 40,504 Mark Anfeson Marcea Ross 16,837 26,946 3,436 3,437 20,273 30,383 Richard Brandt 53,348 6,033 59,381 William Butler 40,564 3,704 44,268 ' Louis Cacciatore 12,400 3,437 15,837 Robert Davenport, Jr. 52,558 2,240 54,798 John Elofson 34,178 3,487 37,665 t William Ennis Marie Rose Gawne 28,112 23,976 3,200 3,123 31,312 27,099 Robert Hamilton 46,728 1,218 47,946 Thomas Hill 43,179 3,536 46,715 ' George Hoffman 36,029 3,585 39,614 Kevin K. Keel 6,084 2,940 9,024 Dave Lemmer 13,463 3,436 16,899 Eric Lundahl 20,977 3,437 24,414 ' Jeffrey McDermot 46,449 4,376 50,825 Robert Ogden 19,531 3,437 22,968 tMichael Rand J. Roel E. Scarry 16,005 9,513 3,437 3,437 19,442 12,950 John Sebben 33,146 3,436 36,582 Thomas Skrabala 43,102 5,018 48,120 ' John Sliozis 31,168 4,418 35,586 Michael Soler 31,371 3,410 34,781 Melvin Soltwisch 10,313 3,436 13,749 Gary Stryker 42,055 4,460 46,515 ' Larry Tousignant 47,346 4,544 51,890 David Turnbaugh 42,607 4,269 46,876 Richard Weil 20,487 3,437 23,924 ' Ross Roel 2,467 2,685 5,152 Brian Budny 1,884 2,639 4,523 Tim Foley 136 2,486 2,622 Geoffrey Ruther 87 2,491 2,578 Karen Stachowicz 136 2,496 2,632 Richard Wilk 1,292 2,590 3,882 Walter Trillhaase Paul Obrzut 1,296 2,011 1,296 2,011 Thomas Keane 671 671 Michael Greisz 1,296 1,296 Thomas Best 456 456 926 925 131.729 456 _1,0� 58,1 8 115 VILLAGE OF DEERFIELD, ILLINOIS SCHEDULE OF INSURANCE IN FORCE APRIL 30, 1990 Insureds Description of Coverage Village of Deerfield Workmens Compensation Village of Deerfield Village of Deerfield Village of Deerfield Village of Deerfield Public Officials Comprehensive Automobile Liability Bodily Injury and Property General Liability Blanket Building and Contents Boiler and Machinery Blanket Bond Coverage Village of Deerfield Excess Coverage Amount of Coverage Statutory/ $30,000,000 1,000,000 1,000,000 30,000,000 10,000 10,000/ 1,000,000 5,000,000 The Village of Deerfield is a member of the Municipal Insurance Cooperative Agency. Property, automobile liability, general liability, and workers' compensation are provided under the Agency. The Village of Deerfield is also a member of the High -Level Excess Liability Pool Agency. Excess liability coverage is provided under this agency. 116 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS LONG -TERM DEBT REQUIREMENTS SEWERAGE IMPROVEMENT BOND SERIES OF 1973 APRIL 30, 1990 Date of Issue Date of Maturity Authorized Issue Actual Issue Denomination of Bonds Interest Rates 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 Levy Bond Interest Due on Year Numbers Principal Interest Totals Dec. 1 Amount June 1 Amount 1988 167-181 4,375 4,375 1990 4,375 1989 182 -196 $ 75,000 6,875 81,875 1990 4,375 1991 2,500 1990 197 -206 50,000 3,750 53,750 1991 2,500 1992 1,250 1991 207 -216 50.000 1.250 51.250 1992 1.250 175 000 16,250 191,250 8,125 86125 117 VILLAGE OF DEERFIELD, ILLINOIS LONG -TERM DEBT REQUIREMENTS SEWERAGE TREATMENT FACILITIES BOND SERIES OF 1973 APRIL 30, 1990 Date of Issue Date of Maturity Authorized Issue Actual Issue Denomination of Bonds Interest Rates Principal Maturity Date Interest Dates Payable at June 1, 1973 December 1, 1992 $2,000,000 $2,000,000 $ 5,000 4.4%-6.0% December 1 June 1 and December 1 Belleville National Savings Bank PRINCIPAL AND INTEREST REQUIREMENTS Tax Amount 1990 10,625 1990 10,625 1991 Levy Bond 3,750 Tax Levy Year Numbers Principal Interest Totals 10,625 10,625 1989 316-340 $125,000 18,125 143,125 1990 341-370 150,000 11,250 161,250 1991 371-400 150.000 3.750 153.750 $425,000 436750 468 750 118 Interest Due on Dec. 1 Amount June 1 Amount 1990 10,625 1990 10,625 1991 7,500 1991 7,500 1992 3,750 1992 3.750 21.875 2e 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS LONG -TERM DEBT REQUIREMENTS CORPORATE PURPOSE BOND SERIES OF 1982 APRIL 30, 1990 Date of Issue Date of Maturity Authorized Issue Actual Issue Denomination of Bonds Interest Rates Principal Maturity Date Interest Dates Payable at October 1, 1982 December 1, 1994 $500,000 $500,000 $ 5,000 9.60% - 10.25% December 1 June 1 and December 1 The Northern Trust Company PRINCIPAL AND INTEREST REQUIREMENTS Tax Interest Due on June 1 Levy Bond Amount Tax Lew 15,013 Year Numbers Principal Interest Totals 1989 36 -45 $ 50,000 30,025 80,025 1990 46 -55 50,000 25,650 75,650 1991 56 -70 75,000 21,150 96,150 1992 71 -85 75,000 14,250 89,250 1993 86 -100 75.000 7.200 82.200 325 000 98,275 423,275 119 49,138 49,137 Interest Due on June 1 Amount Dec. 1 Amount 1990 15,013 1990 15,012 1991 12,825 1991 12,825 1992 10,575 1992 10,575 1993 7,125 1993 7,125 1994 3.600 3.600 49,138 49,137 VILLAGE OF DEERFIELD, ILLINOIS LONG -TERM DEBT REQUIREMENTS CORPORATE PURPOSE BOND SERIES OF 1982 - A APRIL 30, 1990 Date of Issue Date of Maturity Authorized Issue Actual Issue Denomination of Bonds Interest Rates Principal Maturity Date Interest Dates Payable at December 1, 1982 December 1, 1993 $500,000 $500,000 $ 5,000 7.0% - 8.5% December 1 June 1 and December 1 American Fletcher National Bank, Indianapolis PRINCIPAL AND INTEREST REQUIREMENTS Tax Interest Due on June 1 Amount Levy Bond 1990 Tax Lew 1990 Year Numbers Principal Interest Totals 1989 61-70 $ 50,000 16,750 66,750 1990 71-80 50,000 12,750 62,750 1991 81 -90 50,000 8,500 58,500 1992 91-100 50.000 4.250 54,250 $200,000 42,250 .6_ 120 2® 21,125 Interest Due on June 1 Amount Dec. 1 Amount 1990 8,375 1990 8,375 1991 6,375 1991 6,375 1992 4,250 1992 4,250 1993 2,125 1993 2.125 2® 21,125 1 1 1 1 1 1 1 1 1 1 1 n 1 1 1 1 1 IJ ■ VILLAGE OF DEERFIELD, ILLINOIS LONG -TERM DEBT REQUIREMENTS CORPORATE PURPOSE BOND SERIES OF 1986 APRIL 30, 1990 Date of Issue Date of Maturity Authorized Issue Actual Issue Denomination of Bonds Interest Rates Principal Maturity Date Interest Dates Payable at May 1, 1986 January 1, 2005 $11,000,000 $11,000,000 $ 5,000 6.4% - 7.75% January 1 January 1 and July 1 American National Bank & Trust Co. Chicago, Illinois PRINCIPAL AND INTEREST REQUIREMENTS Tax Levy Interest Due on Year Principal Interest Totals July 1 Amount Jan. 1 Amount 1989 $ 410,000 712,363 1,122,363 1990 356,181 1991 356,182 1990 445,000 680,588 1,125,588 1991 340,294 1992 340,294 1991 485,000 646,100 1,131,100 1992 323,050 1993 323,050 1992 515,000 608,513 1,123,513 1993 304,256 1994 304,257 1993 545,000 568,600 1,113,600 1994 284,300 1995 284,300 1994 580,000 529,905 1,109,905 1995 264,952 1996 264,953 1995 620,000 492,785 1,112,785 1996 246,392 1997 246,393 1996 660,000 452,485 1,112,485 1997 226,242 1998 226,243 1997 700,000 408,925 1,108,925 1998 204,462 1999 204,463 1998 750,000 362,025 1,112,025 1999 181,012 2000 181,013 1999 800,000 311,025 1,111,025 2000 155,512 2001 155,513 2000 855,000 255,825 1,110,825 2001 127,912 2002 127,913 2001 915,000 198,113 1,113,113 2002 99,056 2003 99,057 2002 975,000 136,350 1,111,350 2003 68,175 2004 68,175 2003 1.045.000 70.538 1.115.538 2004 35.269 2005 35.269 $10.300,000 6,434,140 16,734,140 3,217,065 3,217.075 121 VILLAGE OF DEERFIELD, ILLINOIS LONG -TERM DEBT REQUIREMENTS CORPORATE PURPOSE BOND SERIES OF 1987 APRIL 30, 1990 Date of Issue Date of Maturity Authorized Issue Actual Issue Denomination of Bonds Interest Rates Interest Dates Payable at October 8, 1987 October 8, 2002 $10,000,000 $10,000,000 $ 5,000 8.4% - 8.5% October 8 and April 8 Marine National Bank CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Tax Interest Due on Levy Amount Requirements Amount Year Principal Interest Totals 1988 421,500 421,500 421,500 1989 421,500 843,000 843,000 1990 421,500 843,000 843,000 1991 421,500 843,000 843,000 1992 421,500 843,000 843,000 1993 421,500 843,000 843,000 1994 421,500 843,000 843,000 1995 421,500 843,000 843,000 1996 421,500 843,000 843,000 1997 421,500 843,000 843,000 1998 421,500 843,000 843,000 1999 $ 7,000,000 843,000 7,843,000 2000 3,000,000 255,000 3,255,000 $10,000,000 9,949,500 19,9 122 4,764,000 5,1 Interest Due on April 8 Amount Oct. 8 Amount 1990 421,500 1991 421,500 1991 421,500 1992 421,500 1992 421,500 1993 421,500 1993 421,500 1994 421,500 1994 421,500 1995 421,500 1995 421,500 1996 421,500 1996 421,500 1997 421,500 1997 421,500 1998 421,500 1998 421,500 1999 421,500 1999 421,500 2000 421,500 2000 421,500 2001 421,500 2001 421,500 2002 127.500 2002 127.500 4,764,000 5,1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 f 1 1 1 1 VILLAGE OF DEERFIELD, ILLINOIS LONG -TERM DEBT REQUIREMENTS GENERAL OBLIGATION BOND, SERIES OF 1988 APRIL 30, 1990 Date of Issue Date of Maturity Authorized Issue Denomination of Bonds Interest Rates Interest Dates Principal Maturity Date Payable at Tax Levy Year 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 November 1, 1988 January 1, 2004 $3,000,000 $ 5,000 6.50 %, 6.60 %, 6.70% - 6.75 %, 6.80 %, 6.90 %, and 8.0% January 1 - July 1 January 1 American National Bank and Trust Company of Chicago CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Tax Le Principal Interest Totals $ 125,000 203,462 328,462 150,000 193,462 343,462 150,000 181,462 331,462 150,000 169,462 319,462 175,000 157,462 332,462 175,000 146,088 321,088 200,000 134,712 334,712 200,000 121,512 321,512 225,000 108,112 333,112 225,000 92,925 317,925 250,000 77,625 327,625 275,000 60,375 335,375 300,000 41,400 341,400 300,000 20.700 320,700 $2.900.000 1 708,759 4,60 123 854,378 854,381 Interest Due on July 1 Amount Jan 1 Amount 1990 101,731 1991 101,731 1991 96,731 1992 96,731 1992 90,731 1993 90,731 1993 84,731 1994 84,731 1994 78,731 1995 78,731 1995 73,044 1996 73,044 1996 67,356 1997 67,356 1997 60,756 1998 60,756 1998 54,056 1999 54,056 1999 46,462 2000 46,463 2000 38,812 2001 38,813 2001 30,187 2002 30,188 2002 20,700 2003 20,700 2003 10.350 2004 10.350 854,378 854,381 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 � Statistical Section 1 1 11 1 1 1 1 1 1 1 1 r 1 d 1 J 1 1 C L 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 It N r4 m a 10 co O n V1 N O 14 n n O N p O N a o 10 a, 01 al 1; a, N M VQ a, g %o C, 0 of V1 n 1-4 N 10 N O n 'o o a m I O n 00 �a �o H O 'o N I o, n m N N n Vl n 14 11 &n a cq in o co a, O P 10 n O V1 N N O a, r1 a, O w n ri n o O a a m i a o M N N Oo D &n V1 a O a O N a O m N a VI 10 O n V1 n a N n rn vt a n n a co uni a n in n O N s h c, m W 0 O M T O h N O O a, M a m 10 M 14 V7 in a 1 a0 co N n O M _ � H O OD h H w 1Z-1 N co a r, h -4 o n ti a,I ai 0 h 1; kn o fa{ W aoo a A � � >- O O� ri o jW d' H 0000 0 .1i 10 s v"' n H 4 U a n a '+ N .� n n U, Ri c) � a h s w zza H w.' 0 4 a, � N o a a a n in m o W 0 rn a N n m aa a i '; + m 14 N a I C m v > 11 �a o O N n -4 N '0 o -W a -+o N r, n Z w O-D ) 1N m n M O M n 14 in j b O a N m G a Vl 0o ri n N a a o in a m n a .1 a r OD V1 O V) N co ri %o ],Nn N m r cn > m a M O m n a o 40 q YI m O ar a, w m m m W a7 m fA m w m w W Yl b Vl M A CD O P4 0 .i 14 O CD U 0 m m 44 V p 3 5m 12 H 0 in m O 14 . 10 O1 02 m 0 1 > •. O m W O m 0 m 43 w m S N O 'A J y 1 .d w H +1 a r. H Ei +Oi w 4. +r E s z o > It N r4 w U H � O z H H A � � e- w U -1 w N W H O cn w zHa w� a � H �Ja! W z w C9 O O n N s O a. n n h co co .i N m N o. .7 m m p m m C. n N CO n b O I o, n v1 CD .-1 .-1 .o a, m n .-1 0. h n w .i N .� m .-1 Itl N N n m a m o m n o n a o a In to In o m a 0 o 0 Ae0 4 a W) C9 r4 m 111 W 0 2 w OD E O CD e .� Cl) m o ao T s 1n .-1 N F n n CD co N V1 N N S O co 1-1 .O r1 m CD 10 10 %a 1-1 .7 n m ol a v1 m o. 10 m m N C o• 0 m n a 14 N 'i n a o O N m v1 a -T 10 0, a o n vi N co o a 'o 0 a m m o• o. m .+ o " co 0 .-1 H 11 a CO m m o N N n .-1 H O vl 10 %o O o n m O .o N CO h - m m m N O N In NO CD h �O N n h O .O O� T N ? h .-1 V1 CD O o. CO m O .-1 N .-1 �O N 0 10 N O co M N O ao •o CD .-1 m N h co O aD O. co CO H P O. �D N 1-1 N n O. 10 N n n ri 1; V1 cn O O m N h m VI o n 10 a n a o 0 O 10 10 .- 1 CO r1 Y 1 N h a n W n N a a N Q m m O. m N n N CO m h d N .O m �O m n O s O 0% 0 � 14 CGD YI w VN l N .7 -n F Y1 .-1 N n co .-1 a H F n in O .-1 O m .i CO m n eq CDI W n F .-1 'O r1 CO d CO •? N •It N 0 m n o n a a. N O% N O .0 m 0 +1 F1 43 m a p m m co m O v1 O to h h W m N a, ..-1 OD M -W d w .� m W Itl m N •>4 U2 r. 0 N LL B m .d m N m 8 �l O O m O 00 0 ao b N a .� a0 U Q C +� m � o O � aD a tOA 0 � A m W A O n m o. 'r It N w m ?U N A m 4 •o m R CD Q Q a .d ro a 0 m Q N .-i CI N m Q m a m b 4 O R F W F zz ul .d 0 O m U a C V] OO co a > Q O M +1 +1 F1 43 m C7 p m m H N N m a, a pp m W Itl +Oi •>4 U2 W .d b O H r1 N 0 0 Ae0 4 a r4 m 111 W 0 2 w U E O r. 0 N LL B m .d m N m 8 �l O O m O 00 0 ao b N a .� a0 U Q C +� m � o O � aD a tOA 0 � A m W A O n m o. 'r It N w m ?U N A m 4 •o m R CD Q Q a .d ro a 0 m Q N .-i CI N m Q m a m b 4 O R F W F zz ul .d 0 O m U a C V] OO co a > 1 VILLAGE OF DEERFIELD, ILLINOIS ' PROPERTY TAX ASSESSED VALUATIONS, RATES, EXTENSIONS, AND COLLECTIONS LAST TEN FISCAL YEARS APRIL 30, 1990 1 �I 1 J I,I-1 1 1 1 1 J 1 1 1 1 1 (See Following Page) VI O O�o Oao "'r O%O N O. V1 O COa o m Y.+ 1 O O nOa� d �nYO Nol ' N 1 s N N vO m O N N CD °D a m e-1 tp h s N # k ml moNHNI al ed+� aoa.iaomvi10 n F+a � o.INO N.-to 0 .1 �I O V1 N O o ao a� m m rI N o a0 N o O rn a �O .O o m 0 a, z 4 A N hH a m� v s 0 Cl) N N W a in N 11 co O m1 n a ol O" N 'o o 0 'o m' e1 O'I N O N l O l O N a Im U A 43 m N n n �o e-I rl 10 N N V1NN.1 Y1 n V1 n r 0 O N '? Y1 n N a� N N 7 QO@ N r1 h -n ,a c rl m O n COI W O r a a Aci &n mm. - � H H NI N N O N s ra N k m �+aoinnamoNI o H E 1 1 of al O al �400N0 via°' (ZI �j 'o O h n c0 N h rl �o tp OI O H a7 C.I 10 N tp O a� J J tp rl N O N O N v �o V1 C W M W EoE N a o10ma,rl0 a �Na H OD a mN.4 a a A z r4 O H a .� .� w OD in O F4 Q N 43 anOn.00MNI N nI ar1 O O N O 'i O (O 'H Q � W 0 n0%0 co WOm N N N Go W 43 w n ao .4 .o m o m 10 Cl) n N omNviOoa�in n o: N p a 0% O al .-4 N a. a1 �o in .-i o . i m O 10 OD �E W •qN r mm.4 o O co ]In N N o N h %n W Fal NOOr010 �.d 01 III al 914 O C4 a m e m M O a .4 mM a to a o v -1 d 0 02 U +/ m m N 4 i 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 �D N Pi P, cD 4 O O .O N V1 k yll n rl 0� d d 0` .1 0 N h �O CO n O� O O rl n %O E r1 O Go m to m N C n N d m in rl .t m .� m 00 O I in OI a OO-! I m rl Ol OiI +� o .d i N d�O md O z mH vm .1 r'4111 vm .d 0 N O 0 N n D c l N 146Oh Ma w O s d 1omm ancooi m O m m m 0o .1 m A OI d N co .l n N O, N� n M Ha 00 0% OHO Od d O� o a� ail h m o d m ^ m ao o m n .I 7 %0 m r1 O 0 W N 10 d o O d CO T O� d O N `�1 .-1 .-1 m m ZO O %0 m n m o N 10 N CO rl d .� �1 N co n ri m m co m t 14 ml m d N o in d 0% ao -r mO m %OOO Nn�1 .tdd F4 A o 0 o N o H m H 0 l H yl Nin000N coon O co OI p 7 N O N 1-4 an d co co n N O Vi m O n .r O o� O rn 0 co H N rl co d m in m n aND n N m %0Nm rid rt m m �I r+ m m 00 o O N %0 co O, d 0 dl OI n 3 HOOdaoH 14 10 .ti N (y •i O O N O r/ d ri O N is co rim Yldd omn n V1 O ,�.. O d r4 N Vl Yl d m co H H N O. N rl N N m 10 10 o 3 n O Nn c0O C0 W con m HH W) I 10NN m jo W! dH rlm� m O col o, m V! m d m N %O 0 0 %D 00 N 10 U1 .O d W H a rl O O N O ei d rl O m W W N � O O O N Q � m O a W H 11 d6 W y1 H m 0 a A a a U 93 0 m 0 m m W 43 3 � H 0 Do a W $4 H b N O � b O 43 N -4 +Ai U m 43 0 .4 O b C. -H 0 .-WI A + �W� 00 a o a > m R q .1 iL R � O U H H W V 0-H m 43 O 0 N 0 0 -H 0 m 7 O 0 y H 0 to 41 m Q +1 W 0 41 43 W H O .-7 W W C. 0 .0 H.4 Awry � �aw m m H w 7 U CO v H aviH n �� a H . 44 H C H U a t s q p �D N Pi VILLAGE OF DEERFIELD, ILLINOIS ASSESSED AND ESTIMATED VALUE OF TAXABLE PROPERTY LAST TEN FISCAL YEARS APRIL 30, 1990 Tax Assessed Value Levy Real Railroad Estimated Year Property Property Totals Value 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 1986 279,339,024 47,194 279,386,218 839,000,000 1987 314,936,632 50,397 314,987,029 945,000,000 1988 331,640,352 53,070 331,693,422 995,000,000 1989 $375,839,166 60,143 375,899,309 1,127,000,000 Data Source Office of the County Clerk 127 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 co m O, rl N co h d oil 'o 0, a "d "o n NNa O� N D% O� O �D 1D .O d O 1 0! r1 N N � � N N N 00 N -4 ,l ����� 4O "a' 0, w h O O, N 1D N N N co O. n OD 0% O�O1010 e1 d O 11! fO m0N N 'i N N N n ONS do 0 m 011014 10 Go MM14 In O O 11n O1" o 01 o O n P 1 d O d d N N M N N N Vi 1OI o ao n 11 o O 0 o" n N .-i OD .i O 14 tO d s o n M d IT 11 z NOn1O OO s O d1l1NN M 11 N N N V1I It a, %0 On n O. NH%O O1 N O co d d 11 h M V1 0 11 N 11.11 M a, 0! C! CD d o Y1 1n 01 N m 11 N N N z H O ~ z a H a s 01 n o (D n 01 in in 11 o h Vl Go n in co Oh 0 O O d 10 �D d O 11 01 /+1 N h 1D /'7 N N s H W N N N A W Mu1dc4 o N 01 dN 00 .� F,Lq co M %D h 10 N 10 O o O O 11 d N 10 H O Ch O1I n N N n H NNN w ca a O �I O o O 1D d .-/ O, mO n 1D 10 N 1f1 11 V1 s 01 OD 11 V1 M d M 11 N W T 11 d 10 d O fO n .1 N 10 N N N N W LW�i H N d O o n 10 O N OD 10 0 Go C. co nd11 o 10 n N 10 OD N O N O 01 OO o h n vl d O PO 1D N N 1D .i N N N 0 `yam; t� 7 V W QI 0 11 o CO N 10 01 s OD o 01 N m o a, 1-1 N 10 N 0� O11 m o d 'D V1 d N d N 0 m n 11 N 0) %D 0 m a N N N W O O 43 O m U 11 to V 11 11 N r4 43 H O m o m m w -4 O co 01 A H C +1 +1 0 ON m m m C W -4 43 A U gq +i O 24 H W A [i N 41 i1 W a1 M W H 0 0 0 0 0 0 43 43 U 0 +1 m +1 m a�1 N W M O +1 i, 00 O 41 +1 +1 O 60 14 91 CC d 4.0 G 1 4-1 .i W O ?4 0 0 m +1 43 43 .-I .4 V] m N O Q m m H\ m M M a m 0 14 (� +1 W m RO0ro .3 .1 +1 m N W W MD+ � 00L 40 LO) H m as O H b 0 'O N m +1 O O a� �aO m m 1-1 b 7 .4 W 'O Q 0 .4 .1 V N .0 m .1 74 C C0 M m m0 O +1 U +1 m 4 O O 4 43 H W to .4 a0 H A m H q a U O t4 4 m 0 m -4 .0 Q $X 11 m m OD m W 60 m .0 Vl V) w h a0 m W V] m r7 +i m +i m , �D3amaa p7 U N O z O $4 v w ami * s A o 00 N -4 H H Pa d4 U W 914 H H oq A Q A A W C WA O z O Gq H oq z w H E-4 Qi � C7 W 0, �OUr-I w0 4 H M Q W H W Z P, O WCW9H� W UEi� W iZ4 z Cl H w O H A W N W N O O >K n O O N h 40 O h o. m O tn 0� O m h n .r-4 rh4 a N � 10 40 m O N in a Cl) n N .4 r♦ m O N O n aK m ,4 O N O t0 rl N n 0� Vl .t O 0, O 0� O tn Cl) n 4 44 a N h 10 O O 4T 14 h 14 m m N 14 rt Cl) O of O .t 0 0 h O O N 00 r�i w ? 4o m n n h ri m m o N r4 00 N m P J N r4 O r+ .4 m N O Ip O .t %0 O It 0 10 m m o nl V1 N O 0 O O 40 - 10 0. h If r4 %0 40 O h O 40 Q. %0 .0 l0 0� 0% m ri N n H 4 N 44 O O n O n m N a O in o m 40 4r o to 10 v1 h O m 'o O •.4 ao - - a n w 0. h O kn Cl) rr 0 .-� r♦ h n N in VI m %0 .t N '0 4r m rr N 0 N PO a w4 ?o 4D o Cl) o 00 %4 co a a Vi Vi o C 1 N � & e aol n t0 0 .-4 40 0, r4 m O r4 co .4 40 14 O o .4 4n n ri .o u j s N w w O O m O M 10 0 U N N .t Vl h O h n U G 0 h - r4 O N 4; h m p tp ri r4 m h a o a ar a o 4 m h m Cl) U O N @ 43 8 m P, o H co m V 14 a ml O N h 10 m 4N Go 14 43 O P. F rA •+ a M . 4 43 N an0 f3 .0 m m N c Itl N y4 m m A n O 14 p ago coo n .A'i O s N' O n N m cool rl � 34 y) a 10 1.4 d �y N N W 4H m 0 O %0 a 43 N %n O O If co N O O r, a r+ o -0 h o O O - .a .4 0. h 71, h n h m 8 .4 r+ .O .O 0. 0 m 4r '4 n m r4 N N W N N O b to U .> N a .4 4p M ID I4 ?4 as w w ra tll d m a .+ ro 4.t U y +4 a '0 a1 A O. O M .Np 7 O U m to y w b +4 O H w m W U 4ai 7 p N_ 43 -44 m '0 .-I 04 O O m > �• to O awi p c00 A .,aj v b m Q N Q I O w a� '0 a o m O ' (Ny Z m O N GGo U m m 14 .4 a b O 0, -4 0 O o ° w .4 a C o o m m I O 0 .7 ID a N +4 O O 40 a 4 a O a 4.1 14 �) 43 r♦ 4.t .4 O a w m 0 0 0 N A r4 N w a c a a z a z 44 a �- •- 1 iVILLAGE OF DEERFIELD, ILLINOIS SCHEDULE OF DIRECT AND OVERLAPPING BONDED DEBT iAPRIL 30, 1990 i(1> (2) * Percentage of Debt Applicable ** Village's Gross Debt to the Village Share of Debt I Total Gross Debt Less Available Amount $1,396,253,076 25,9® 1 * - 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). IData Source ' (1) Office of the County Clerk (2) Office of the County Clerk I� 1 130 Governmental Unit Village of Deerfield $ 24,325,000 100.00% 24,325,000 Metropolitan Sanitary District 682,065,000 .10 682,065 i Lake County 135,916,000 5.02 6,827,061 Cook County 523,905,000 .09 513,427 North Shore Sanitary District 3,000,000 .03 780 Deerfield Park District Northbrook Park District 1,560,000 16,400,000 97.443 4.67 1,520,111 765,060 Highland Park Park District 1,200,000 1.66 19,968 Highland Park Elementary #108 375,000 6.34 23,790 i Township High School #113 4,920,000 27.62 1,358,658 Junior College #532 12,855,000 6.12 786,855 Lake County Special Service Area #5 795,000 27.27% 216.820 ' Total Gross Debt 1,407,316,000 37,039,595 Less Debt Service and Expendable Trust Funds Village of Deerfield 11,062,924 11,062.924 I Total Gross Debt Less Available Amount $1,396,253,076 25,9® 1 * - 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). IData Source ' (1) Office of the County Clerk (2) Office of the County Clerk I� 1 130 VILLAGE OF DEERFIELD, ILLINOIS SCHEDULE OF LEGAL DEBT MARGIN APRIL 30, 1990 The government 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 per cent:.., 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. Illustrative Computation of Debt Margin if Village Were Not a Home Rule Municipality Village of Deerfiled 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 - 1989 Legal Debt Limit - 8.625 Amount of Debt Applicable to Limit Sewerage Improvement Bonds $ 175,000 Sewerage Treatment Facility Bonds 425,000 Corporate Purpose Bond Series 1982 325,000 Corporate Purpose Bond Series 1982 -A 200,000 Corporate Purpose Bond Series 1986 10,300,000 Corporate Purpose Bond Series 1987 10,000,000 General Obligation Bond Series 1988 2,900,000 Available Funds (11,062,924) Legal Debt Margin 375,899,309 32,421,315 1 1 1 1 F 1 1 1 1 1 1 1 13.262,076 ' 19,159,239 ' The Village has available fund in the Debt Service and Expendable Trust Funds in the amount of $11,062,924. 131 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 N M r-1 01 m of o T rl O �O N rl N ^ 1/1 N O co o a M M 10 m w %0 w co o a ml m s 1n O N N m � h m "Oil H ° N v m v 0 H kn m hl Y1 N A N N ^ z rl O H OI o In N ^ h O o o: H �4 O rl V1 7D ID O rl a rl �D O V)l ing c0 H ° I m z awzH � N w 0 I ° a w � a °° 1 W U h m H o a v W z � v C', N W r� z H m �I 44 z W H ° Ia4 c7 cn W c� .a NI m ^ I 'O W U �4 y v m a 11 m 10 o U3 H aD N y a ,) �W a a D b ) m m M b CD � m 43 F m m O m r4 to a O .4 O v 43 O -t O O F-1 to H m O m P. b W O O d m > O m h N q a > > u m N W .4 4 (a J.7 GN N A> O W 0 m O J b O m G'i m q '[1 O N .4 H U aO t0 m 10 > Q Od .j G �y O 1 ^ A Co .-. -.i W H O H OG . 4 O .�. N M r-1 Fiscal (1) Year Population Percentage of 1981 17,453 1982 17,476 1983 17,487 1984 17,500 1985 17,500 1986 17,500 1987 17,500 1988 17,500 1989 17,500 1990 17,500 VILLAGE OF DEERFIELD, ILLINOIS DEMOGRAPHIC STATISTICS LAST TEN FISCAL YEARS APRIL 30, 1990 (4) School Enroll- ment 4,318 4,106 3,933 3,788 3,703 3,715 3,602 3,276 3,238 3,106 (5) Unemploy- ment Percentage 1.7% 2.2 2.1 1.9 2.0 1.7 1.3 1.1. .9 1.0% Data Sources (1) 1981 -1990 were derived from data from the Department of Commerce and Community Affairs (2) The 1981 - 1990 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 enrollment of District 109 (grade school), and District 113 (high school). (5) Unemployment figures based on 1/4 of Lake County figures. 133 (3) Percentage of People Over (2) 25 Years of Per (2) Age With Four Household Median or More Years Income Age of College $37,000 33.3 50.1 39,000 34.0 50.3 41,000 34.7 50.4 45,000 35.4 50.7 45,400 36.1 50.8 46,100 36.5 51.0 47,500 36.8 51.1 48,100 37.2 51.3 50,900 37.4 51.5 $53,600 37.5 51.8 (4) School Enroll- ment 4,318 4,106 3,933 3,788 3,703 3,715 3,602 3,276 3,238 3,106 (5) Unemploy- ment Percentage 1.7% 2.2 2.1 1.9 2.0 1.7 1.3 1.1. .9 1.0% Data Sources (1) 1981 -1990 were derived from data from the Department of Commerce and Community Affairs (2) The 1981 - 1990 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 enrollment of District 109 (grade school), and District 113 (high school). (5) Unemployment figures based on 1/4 of Lake County figures. 133 1 1 1 1 1 I 1 1 L VILLAGE OF DEERFIELD, ILLINOIS PROPERTY VALUE, CONSTRUCTION, AND BANK DEPOSITS LAST TEN FISCAL YEARS APRIL 30, 1990 (1) (1) Construction Commercial Construction Fiscal Number 1,852,788 Year of Units Value 1981 59 $ 3,235,868 1982 77 9,758,795 1983- 84 20,369,020 1984 52 12,146,201 1985 101 34,504,614 1986 135 37,746,399 1987 79 44,287,589 1988 110 21,705,751 1989 222 75,592,000 1990 150 $33,113,366 (1) Residential Construction Number of Units Value 85 1,852,788 86 1,689,832 104 5,673,638 46 5,131,160 50 6,552,552 90 11,318,142 86 8,089,179 51 5,489,656 72 12,463,000 77 12,085,690 (2) Bank Deposits 52,282,000 53,522,000 63,218,000 63,877,000 64,750,000 130,155,000 141,241,000 149,182,000 163,472,790 187,961,000 (3) Total Property Value 664,000,000 682,000,000 711,000,000 708,000,000 710,800,000 748,100,000 838,160,000 944,962,000 995,080,000 1,127,700,000 ' Data Sources (1) Construction figures - Village of Deerfield, Building and Zoning Department. ' (2) Bank Deposits were based on commercial bank deposits. (3) Estimated historical cost data provided by Township's Assessors Office. 1 L I 1 1 1 134 VILLAGE OF DEERFIELD, ILLINOIS PRINCIPAL TAXPAYERS APRIL 30, 1990 Percentage Data Source Office of the County Clerk 135 1989 of Total Assessed Assessed Taxpayers Type of Business Valuation Valuation Stein and Company Lake Cook Office Center $14,264,807 3.33% VMC, Inc. Deerbrook Shopping Center 12,633,123 2.95 Arbor Lake Center Office Building 9,562,776 2.23 Matas Corporation Corporate 500 Center 7,322,429 1.71 Deerfield - Saunders Parkway North Office Joint Venture Building 7,131,456 1.67 Baxter International Office Buildings 6,370,219 1.49 Lake - Cook Plaza Shopping Center 6,091,864 1.42 Hyatt - Deerfield Hotel 6,000,000 1.40 Tollway North Tollway North Office Park 5,475,076 1.28 Sara Lee Bakery Products 5.188.084 1.21 $80,039,834 1,8._70% Data Source Office of the County Clerk 135 i 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Date of Incorporation Form of Government Geographic Location Population 1950 1960 1970 1980 VILLAGE OF DEERFIELD, ILLINOIS MISCELLANEOUS STATISTICS APRIL 30, 1990 Municipal Services & Facilities Number of Full -Time Employees Miles of Streets Miles of Alleys Miles of Sewers Building Inspection Number of Permits Issued in 1990 Fire Protection Number of Firemen and Officers Number of Stations 136 1903 Manager /Council North Suburban Chicago 3,288 11,748 18,876 17,430 97 70 4 140 856 29 1 VILLAGE OF DEERFIELD, ILLINOIS MISCELLANEOUS STATISTICS (CONT.) APRIL 30, 1990 Police Protection Number of Stations Number of Policemen and Officers Library Services Number of Branch Libraries Number of Books (Approx.) Recreation Facilities Number of Parks and Playgrounds Park Area in Acres Municipal Water Utility Population Serviced Average Daily Pumpage Miles of Water Mains Data Source Village Records 137 1 38 1 130,000 19 262 5,797 2,652,005 gals. 70