July 1, 2017 – June 30, 2018 Final Budget July 17, 2017
517 Deerfield Road | Deerfield, Illinois 60015 www.dps109.org
Table of Contents
Section 1 – Introduction Executive Summary 1 Board of Education 20 District Administration 21 Meritorious Budget Award…………………………………………………………………………………………………........ 22 Section 2 – Organizational District Background 23 Map of District 24 Legal and Accounting Structure 25‐29 Organizational Chart 30 High Achieving District and Community……………………………………………………………………………………. 31 Major Goals and Objectives……………………………………………………………………………………………………….31‐33 Allocation of Human and Financial Resources to Achieve Strategic Goals………………………………….33‐34 Demographic and Miscellaneous Statistics 35 Budget Process 36 Budget Calendar 37 Capital Budget……………………………………………………………………………………………………………………………38 Significant Revenue Enhancement Efforts………………………………………………………………………………….39 Section 3 – Financial Introduction to Financial Section……………………………………………………………………………………………….40 Total Governmental Funds All Governmental Funds – Fund Balance Classifications…………………………………………………………….41 Revenue Assumptions……………………………………………………………………………………………………………….42 Expenditure Assumptions………………………………………………………………………………………………………….43 FY2018 Budget Fund Summary – Revenues by Source, Expenditures by Object...........................44 FY2018 Budget Fund Summary – Detailed Revenues by Source, Expenditures by Function……….45 Chart – FY2018 Budget Revenues and Expenditures by Fund…………………………………………………….46 Historical Revenues by Source, Expenditures by Object…………………………………………………………….47 Historical Detailed Revenues by Source, Expenditures by Function…………………………………………..48
Table of Contents Chart – FY2018 Budget Revenue by Source, Expenditures by Object………………………………………..49 Chart – Historical Revenues vs. Expenditures and Fund Balance……………………………………………….50 Educational Fund Historical Revenues by Source, Expenditures by Function…………………………………………………………51 Chart – Historical Revenues vs. Expenditures and Fund Balance……………………………………………….52 Historical Detailed Revenues by Source, Expenditures by Object………………………………………………53 Operation & Maintenance Fund Historical Revenues by Source, Expenditures by Function………………………………………………………….54 Chart – Historical Revenues vs. Expenditures and Fund Balance………………………………………………..55 Historical Detailed Revenues by Source, Expenditures by Object……………………………………………….56 Transportation Fund Historical Revenues by Source, Expenditures by Function Chart – Historical Revenues vs. Expenditures Chart –Transportation Funding Source History Historical Detailed Revenues by Source, Expenditures by Object
57 58 58 59
Municipal Retirement / Social Security Fund Historical Revenues by Source, Expenditures by Function Historical Detailed Revenues by Source, Expenditures by Object
60 61
Debt Service Fund Historical Revenues by Source, Expenditures by Function ……………………………………………………….. 62 Historical Detailed Revenues by Source, Expenditures by Object……………………………………………….63 Bond Amortization Schedule 64 Capital Projects Fund Capital Project Fund narrative……………………………………………………………………………………………………65 Historical Revenues by Source, Expenditures by Function………………………………………………………….66 Historical Detailed Revenues by Source, Expenditures by Object 67 Historical Capital Budget Detail …………………………………………………………………………………………………68
Fire Prevention & Safety Fund Historical Revenues by Source, Expenditures by Function 69 Historical Detailed Revenues by Source, Expenditures by Object 70 Aggregate Fund Balances……………………………………………………………………………………………………………71
Table of Contents Budget Detail Chart – School Budgets 72 Chart – Budget History by School 72 Chart – School Budget by Category 73 Kipling School Budget History 74 South Park School Budget History 75 Walden School Budget History 76 Wilmot School Budget History 77 Shepard School Budget History 78 Caruso School Budget History 79 Executive Administration 80 Business Services, Technology, and Human Resources 81 Learning 82‐83 Student Services 84 Transportation 85 Operations & Maintenance 86‐87 Other Funds……………………………………………………………………………………………………………………………….88 Miscellaneous Salaries……………………………………………………………………………………………………………….89‐90
Table of Contents Section 4 – Informational Property Taxes 91 Tax Levy Process 91 Property Tax Extension Limitation Law (PTELL) 92 Tax Increment Financing (TIF) Districts 92 Property Assessment 93 Historical and Projected Consumer Price Index (CPI) 94 Historical Equalized Assessed Valuation 95‐96 Historical and Projected EAV Growth 97 Historical Tax Rates vs. Other Local Governments and School Districts 98 Historical Tax Rates, Extensions, and Collections 99 Projected Tax Extensions 100 Estimated Drivers of Growth in Property Tax Revenue 101 Impact on Taxpayers………………………………………………………………………………………………………………….102 Total Governmental Funds – 3 Year Projection 103 Chart – Governmental Funds 3 Year Projection of Revenue, Expenditures and Fund Balance 104 Aggregate Fund Balances……………………………………………………………………………………………………………105 Educational Fund – 3 Year Projection 106 Chart – Educational Fund 3 year Projection of Revenue, Expenditures and Fund Balance 107 Operations & Maintenance Fund – 3 Year Projection 108 Chart – Operations & Maintenance Fund 3 Year Projection of Revenue, Expenditures and Fund Balance 109 Transportation Fund – 3 Year Projection 110 Chart – Transportation Fund 3 year Projection of Revenue, Expenditures and Fund Balance 111 Municipal Retirement / Social Security Fund – 3 Year Projection 112 Debt Service Fund – 3 Year projection 113 Historical Legal Bonded Debt Margin 114 Projected Long Term Obligations 115 Capital Projects Fund – 3 Year Projection 116 Fire Prevention & Safety Fund – 3 Year projection 117 Fund Balance 118 Chart – Fund Balance 119 Student Enrollment 120 Chart – Student Enrollment 121‐122 Low Income percentage……………………………………………………………………………………………………………..123 Chronic Truancy rates…………………………………………………………………………………………………………………123 Staffing 124 School District Financial Profile 125‐127 Administrative Cost Worksheet 128 Performance Measurement – Historical Illinois Standards Achievement Test (PARCC) Trends 129‐133 MAP Test Results………………………………………………………………………………………………………………………..134‐136 Stakeholder Satisfaction Survey………………………………………………………………………………………………….137 Section 5 ‐ Glossary 138‐142
Introduction Executive Summary 1 Board of Education 20 District Administration 21 Meritorious Budget Award ………………………………………………………………………………………………………..22
July 17, 2017 Members of the Board of Education Deerfield Public Schools District 109 Deerfield, IL 60015 The 2017-2018 annual budget for Deerfield Public Schools District 109 is submitted for your review. The budget has been prepared to communicate a comprehensive review of the District’s financial plan and the result of operations to the Members of the Board of Education, local citizens, and other constituents. Though we are experiencing a challenging economic environment, the prudent actions of the School Board, Administration, and Staff have positioned the District well to be able to maintain its programs, high academic standards, and results. The District continues to consistently demonstrate its efficiency and effectiveness by delivering superior educational outcomes while maintaining one of the lowest operating cost per student, relative to its peer districts in the surrounding communities. Deerfield Public Schools District 109 is proud to have received an Illinois State Board of Education financial profile designation of Recognition for the 2015 and 2016 school years and is expected to continue this recognition designation for the 2017 and 2018 school years.
The operating budget for FY2017-18 is balanced. Estimated operating revenue of $52.8 million is planned to exceed operating expenditures of $51.7 million by an approximately $1.1 million surplus. This is the thirteenth consecutive surplus after 14 years of deficits. Approximately $1.8 million of the District’s $23 million in reserves is planned to be spent on needed renovations and capital projects at the six school buildings, including new lockers and cabinetry, roof replacement and ADA accessibility modifications. Budget Process The budget is a detailed financial plan for the District and covers the fiscal year beginning July 1st through June 30th. The process of budgeting for the fiscal needs of the district is an ongoing process and consists of five phases – planning, preparation, adoption, implementation, and evaluation. The planning phase began in the fall of 2016 when five year financial projections were presented to
1
the Board of Education. The preparation phase began when the tax levy was approved and filed with the county clerk in November, 2016. The preparation phase continued with administrative conferences at each school where budget guidelines and worksheets were distributed. The information received along with staffing plans for the 2017-2018 school year were used in preparing the budget. The tentative budget was presented to the Finance Committee on April 24, 2017 and to the Board of Education on May 15, 2017. The budget was approved for public display and a hearing was held on July 17, 2017. Following the public hearing, the budget for the 2017-2018 school year was adopted by the School Board and the budget was filed with the Illinois State Board of Education by September 30, 2017. Budgetary controls are maintained at line item levels and are built into administrative responsibility cost centers. All actual activity will be compared to the budget and reported to the District's management and the Board of Education in the form of monthly Treasurer Reports. Any extraordinary variances will be disclosed in full detail. Governmental Fund Summary The budgeted revenues and expenditures by fund are summarized below. The district is projected to end the fiscal year with $23.3 million of reserves. The ending operating fund balance is forecasted to be 26.8% of operating expenditures which is considered to be an appropriate amount by the State Board of Education and independent industry groups.
Educational Operations & Maintenance Transportation Municipal Retirement Operating Funds Subtotal Debt Service Capital Projects Fire Prevention & Safety Non-Operating Funds Subtotal Total Governmental Funds
Beginning Balance July 1, 2017 $ 12,259,760 5,809,950 1,207,108 669,996 $ 19,946,814 828,577 904,882 1,201,427 $ 2,934,886
Revenue $ 43,873,032 6,129,879 1,642,648 1,239,246 $ 52,884,805 1,118,629 1,010,000 25,000 $ 2,153,629
Expenditure $ 42,982,452 5,762,523 1,595,817 1,401,575 $ 51,742,366 1,114,308 1,250,000 1,109,000 $ 3,473,308
$
$ 55,038,434
$ 55,215,673
22,881,700
Excess/(Deficit) $ 890,580 367,356 46,831 (162,329) $ 1,142,439 4,321 (240,000) (1,084,000) $ (1,319,679) $
(177,240)
Other Financing Sources (Uses) $ (3,000,000) (5,000,000)
$ 8,000,000
Ending Balance June 30, 2018 $ 10,150,340 1,177,306 1,253,939 507,667 $ 13,089,253 832,898 8,664,882 117,427 $ 9,615,207
$
$
$ (8,000,000) 0 8,000,000
-
22,704,460
Description of Governmental Funds
Educational Fund – To account for the majority of the instructional and administrative aspects of the District’s operations. Operations & Maintenance Fund – To account for repair and maintenance of district property. Transportation Fund – To account for activity relating to the transportation of students to and from school on a daily basis and for additional interscholastic activities. Municipal Retirement/Social Security Fund – To account for the District’s portion of personnel pension costs. Debt Service Fund – To account for the District’s bond principal and interest payments.
2
Capital Projects Fund – To account for financial resources to be used for the acquisition, construction, or improvement of major capital facilities. Fire Prevention & Safety Fund – To be used for capital improvements identified as necessary to maintain healthy and safe buildings.
Revenue Summary Revenue
Revenue (Projected)
Budget 2016-17 Actual (Unaudited)
Educational Operations & Maintenance Transportation Municipal Retirement Operating Funds Subtotal Debt Service Capital Projects Fire Prevention & Safety Non-Operating Funds Subtotal Total Governmental Funds Local Sources State Sources Federal Sources Total Revenue
Projected
Projected
Projected
% Change
$
43,680,348 6,161,614 1,748,812 1,322,614 52,913,388 1,188,952 1,049,382 27,385 2,265,720
2017-18 $ 43,873,032 6,129,879 1,642,648 1,239,246 $ 52,884,805 1,118,629 1,010,000 25,000 $ 2,153,629
0.44% -0.52% -6.07% -6.30% -0.05% -5.91% -3.75% -8.71% -4.95%
2018-19 $ 46,288,152 4,858,271 1,583,492 1,246,054 $ 53,975,969 1,104,459 1,278,571 62,052 2,445,082
2019-20 $ 46,290,620 4,972,592 1,614,855 1,275,998 $ 54,154,065 1,112,190 1,331,081 62,989 2,506,260
$
55,179,108
$ 55,038,434
-0.25%
$ 56,421,051
$ 56,660,325
$
57,998,848
$
52,153,442 94.52% $ 52,182,534 94.81% 2,254,650 4.09% 2,212,900 4.02% 771,017 1.40% 643,000 1.17% 55,179,108 $ 55,038,434
0.06% -1.85% -16.60% -0.25%
$ 53,513,234 2,223,991 683,826 $ 56,421,051
$ 53,707,562 2,255,260 697,503 $ 56,660,325
$
54,888,550 2,400,373 709,925 57,998,848
$
$
$
$
$
$
2020-21 47,194,952 5,143,610 1,659,715 1,318,009 55,316,286 1,120,918 1,476,194 85,450 2,682,562
The District’s revenue comes from a mixture of Local, State, and Federal sources. Total Revenue is projected to remain stagnant. Revenue from local sources represents approximately 95% of all revenue in the current budget and is comprised primarily of local property taxes. The proportion of local revenue has steadily grown over the last decade as revenue from State sources has declined. Property taxes Each year the Board of Education must determine how much money needs to be raised through taxation to support the operation of the school for the coming year. This request, called the levy, is made to the Lake County Clerk before the last Tuesday in December. Property assessments for the year 2016 are payable in year 2017. The District is located in Lake County, Illinois, where property taxes are payable in June and September. The amount of the 2016 property tax levy is already known, and it is the intention to use the entire 2016 levy during the 2017-2018 fiscal year. Local governments can establish tax increment financing (TIF) districts which redirect property taxes in order to spur economic growth. The Downtown Deerfield TIF expired in 2009 adding $78 million in new property value to the district worth $1.8 million in annual property tax revenue. In 2009-10 the District also received an extraordinary rebate of excess TIF revenue of $2 million which was allocated to the Capital Projects fund. Prior tax rebates from this TIF were $613 thousand in 2006-2007, and $2.0 million in 2005-06.
3
Historical Taxable Property Values, Tax Rates, Extensions, and Collections Tax Levy Year
2012
2013
2014
2015
2016
2017*
2018*
EAV (billions)
$1.50
$1.43
$1.44
$1.55
$1.64
$1.74
$1.79
Tax Rate ($ per $100
3.254
3.424
3.401
3.211
3.095
2.848
2.792
$48.9
$49.1
$48.9
$49.6
$50.4
$49.6
$50.0
99.84%
99.86%
99.81%
99.79%
tbd
tbd
tbd
EAV)
Tax Extension (millions)
% collected * Projected
Local Property tax growth is limited by a tax cap imposed by the County. This cap limits the increase in property tax extensions using a formula tied to the Consumer Price Index (CPI) with an exception for new property. The cap can only be exceeded by approval of the voters. On April 5, 2005 a successful referendum to increase the tax rate by 0.350 was passed with the support of two-thirds of the voters. This increase was phased in over the next 4 years. Projections for new property growth and CPI for tax years 2017 through 2020 are conservative. The budget assumes a 99% collection rate, which is consistent with historical experience.
CPI New Property
2016
2017
2018
2019
2020
0.7%*
0.0%
0.0%
2.00%
2.5%
$13.5 million*
$15 million
$10 million
$10 million
$10 million
*known Note: At the time of this preliminary budget publication, uncertainty remains regarding legislation that would permanently lower the property tax extension limiting rate to zero percent above the previous year - a property tax freeze. This legislation results in a lower amount of revenue generated through a tax levy for the District.
4
Investment income
Investment income is projected to remain depressed in 2017-2018 assuming the current 1% rate of return on investments. Interest earnings reflected in the projections are based upon forecasted monthly fund balances. Student Fees Fees are charged at various levels to subsidize programs and services. The District charges fees for transportation, athletics and clubs. The District will continue to offer an extended day Kindergarten program expected to generate $270,000 to help offset the cost of the program. Fees are expected to account for less than 1% of Education Fund revenue. State Revenue With the exception of Special Education, revenue from State sources has been declining for several years. Given the State’s poor financial condition, the District expects this trend to continue and has budgeted State mandated categorical revenue and State grants accordingly. In 2007-08 the District proactively began allocating General State Aid and, later, replacement taxes (which are a replacement of local revenue collected and disbursed by the state) to the Capital Projects fund instead of the Educational fund. This shift reduced the District’s reliance on these revenue sources in anticipation that they may diminish or be withdrawn in the future. As a result, extra resources have been available for numerous capital improvements in the past five years and the District has minimized its exposure to the worsening state financial crisis.
5
Recent movement in the state’s capitol leads us to further uncertainty about maintaining the state’s share of District revenue. Educational equity continues to be debated by the Illinois General Assembly and would result in the District losing over 70% of state source revenue. Currently, state revenue accounts for 4% of the District’s total revenue. Federal Revenue Federal revenue accounts for approximately 1% of the District’s total revenue.
6
Budget Forecast
The District’s Board of Education philosophy is to adopt balanced operating budgets to assure that adequate balances are maintained to fund current operations. The pursuit of this philosophy is constantly challenged by the desire to continually provide academic excellence while being subject to the Property Tax Extension Limitation Act and the uncertainty of state funding. Expenditure Summary Expenditures
Expenditures (Projected)
Budget
Educational Operations & Maintenance Transportation Municipal Retirement Operating Funds Subtotal Debt Service Capital Projects Fire Prevention & Safety Non-Operating Funds Subtotal Total Governmental Funds
Projected
Projected
6.94% 4.30% 14.38% 33.33% 7.43% -4.08% -49.37% n/a -10.54%
2018-19 $ 46,050,874 5,685,155 1,632,223 1,170,925 $ 54,539,177 $ 1,098,308 435,625 200,000 $ 1,733,933
2019-20 $ 47,619,238 5,033,647 1,673,298 1,217,759 $ 55,543,942 $ 1,120,918 446,516 $ 1,567,434
6.09%
$ 56,273,110
$ 57,111,376
Projected
% Change
2016-17 Actual (Unaudited) $ 40,191,978 5,525,054 1,395,198 1,051,205 $ 48,163,435 1,161,700 2,469,129 251,480 $ 3,882,309
2017-18 $ 42,982,452 5,762,523 1,595,817 1,401,575 $ 51,742,366 1,114,308 1,250,000 1,109,000 $ 3,473,308
52,045,744
55,215,673
$
2020-21 48,659,899 5,066,149 1,715,407 1,260,139 56,701,594 1,479,023 457,679 1,936,702
$
58,638,296
$
$ $
The amount budgeted for 2017-18 has decreased from the amount budgeted for 2016-17 by approximately 6% due primarily to completion of major capital projects. Education is inherently labor intensive, with salaries and benefits accounting for roughly seventy percent of expenditures, even though the district purchases maintenance and transportation services.
7
Staffing and Enrollment FTE
2012-13
2013-14
2014-15
2015-16
2016-17
2017-18
Administration
24
24
24
24
25
25
Teaching Staff
277.2
287.5
279.9
279.5
277.72
283.87
Support Staff
97
101
100
102.6
103.50
104.50
3074
3121
3042
3030
2982
2942
Enrollment
Administration Staff increased by 1 FTE in 2016-17 due to the addition of a technology position, but overall compensation for administrators will increase 7% in part due to 9.6% increase in healthcare costs. Enrollment is expected to remain fairly stable with a 1.34% decrease in number of students. Overall, certified staff is projected to increase 6.15 FTE in part due to addition of a middle school math coach, Team Fusion teacher, and school psychologist and to maintain class size philosophy. Total compensation for certified staff is projected to increase approximately 2.5%. The District is committed to continue the 5-year effort to return special needs students from out-of-District placements to District 109 classrooms. Support staff is expected to decrease by 1 FTE due to decrease of teacher assistant with an overall compensation increase of 6%. Benefit costs are a significant source of expenditure inflation for many districts. Deerfield Public Schools District 109 belongs to an insurance cooperative that expects to see an average 9.6% increase in health insurance costs and a .8% increase in dental premiums. The percentage increase is slightly lower than benchmark districts and national healthcare cost trend. There are additional benefit increases that grow in proportion to salary, as well as marginal increases in some pension contribution rates. Benchmarking The following contains various statistical data about Deerfield Public Schools District 109. For perspective, this data is benchmarked against a peer group of similar districts and state averages where possible. The peer districts chosen for comparison are nineteen other K-8 districts and are geographically neighboring districts with similar demographic and socioeconomic profiles.
8
Enrollment 2014-2015 2015-2016 % Enrollment Enrollment Change 1,248 1,243 -0.40% 1,718 1,780 3.61% 491 460 -6.31% 1,126 1,094 -2.84% 907 885 -2.43% 4,887 4,924 0.76% 1,207 1,215 0.66% 1,807 1,758 -2.71% 713 741 3.93% 497 500 0.60% 3,703 3,732 0.78% 864 887 2.66% 1,877 1,772 -5.59% 2,471 2,402 -2.79% 3,140 3,170 0.96% 2,127 2,276 7.01% 1,647 1,702 3.34% 198 180 -9.09% 3,029 2,960 -2.28% 4,400 4,329 -1.61%
Northbrook School District 27 Northbrook School District 28 Sunset Ridge School District 29 Northbrook/Glenview District 30 West Northfield School District 31 Glenview School District 34 Glencoe School District 35 Winnetka School District 36 Avoca School District 37 Kenilworth School District 38 Wilmette School Distrcit 39 Lake Bluff School District 65 Lake Forest School District 67 Libertyville School District 70 Kildeer Countryside SD 96 Aptakisic School District 102 Lincolnshire-Prairie View SD 103 Bannockburn School District 106 Deerfield School District 109 North Shore School District 112
EAV per Student Illinois real property values are determined annually on a calendar year basis. The total value of all taxable real property within the District is known as the Equalized Assessed Value (EAV). Though Deerfield Public Schools District 109 is situated in the northern suburbs of Chicago, where the EAV per student is high relative to the rest of the state, the District has one of the
9
lowest values of taxable property per student compared to its peer group of neighboring school districts represented by nineteen other K-8 districts.
Operating Expenses per Student The Board of Education and the Administration of Deerfield Public Schools District 109 understand that they have a responsibility to use the community’s tax dollars wisely. We are proud to have one of the lowest operating costs per student relative to our peer districts in the surrounding communities while test scores continue to benchmark far above average.
Sunset Ridge SD 29 Kenilworth SD 38 Norhbrook SD 27 Winnetka SD 36 Northbrook SD 28 Avoc a SD 37 Bannoc kburn SD 106
2016 EAV per Pupil $ 893,427 617,746 661,618 735,528 700,661 647,427 1,072,626
Norhtbrook/Glenview SD 30 Glenc oe SD 35 Lake Bluff ESD 65 Lake Forest SD 67
602,891 627,017 706,686 1,256,208
Linc olnshire- Prairieview SD 103 North Shore SD 112 Deerfield SD 109 West Northfield SD 31 Aptakisic SD 102 Wilmette SD 39 Kildeer SD 96 Glenview CCSD 34 State Avg Libertyville SD 70
550,166 547,833 524,725 608,095 407,504 439,277 385,933 357,824 n/a 340,360 10
CommercialIndustrial EAV% 27% 4% 35% 3% 47% 18%
Op Exp per pupil $24,485 21,703 20,615 20,578 20,051 19,576
30% 44% 3% 11%
19,285 18,288 17,472 17,012
6% 29% 9% 19% 36% 39% 7% 8% 20% 31% 17%
16,809 16,382 16,190 16,054 15,752 15,379 14,804 14,722 13,013 12,821 10,939
Student-Teacher Ratio
11
Average Class Size
12
Average annual Salaries
Capital Expenditures District 109 capital spending priorities are set in collaboration with staff, administration, the Buildings & Grounds Department and its consultants, the Board of Education and its Facilities Development Committee (FDC). The 2017-18 budget includes approximately $1.8 million planned to be spent on needed renovations and capital projects at the six school buildings, including new lockers and cabinetry, roof replacement and ADA accessibility modifications. Changes in Debt The total amount of debt outstanding at July 1, 2017 was $21 million, which consumes 19% of the District’s borrowing capacity. Total principal and interest payments for the fiscal year will be $1,098,308. The total amount of debt outstanding at June 30, 2018 is projected to be $20.7 million. In May of 2015, $7.5 million of bonds were issued to refinance existing debt at historically low interest rates and to finance the completion of middle school science lab renovations. The Board authorized $5 million in Debt Certificates in 2005 and refinanced these in 2010 at historically low rates. Principal and interest payments on the certificates cannot be paid from the Debt Service fund and have a final principal payment scheduled in 2024. The interest payment for fiscal year ending June 30, 2018 is $75,660.
13
Life safety bonds totaling approximately $9 million were issued September 23, 2013 and the proceeds are being used to satisfy state-mandated life safety work on roofs, parking lots and HVAC. Year
Series 1999-B Ltd. Tax School Bonds $10,000,000 - Issued Jan 1, 1999 Ending Partially Refunded: Mar 2010 June 30 Int Rate Principal Interest 2017 6.60% 350,000 66,330 2018 6.60% 390,000 41,910 2019 6.60% 440,000 14,520 2020 2021 2022 2023 2024 Totals
Series 2013 Limited Tax Bonds $8,975,000 - Issued Sept. 23, 2013 Int Rate 3.90% 3.90% 3.90% 3.90% 3.90% 4.00% 4.00% 4.00%
$ 1,180,000 $ 122,760
Principal 825,000 885,000 945,000 1,005,000 1,060,000
Interest 350,750 350,750 350,750 338,375 308,300 271,700 232,700 191,400
Series 2015 Limited Tax Bonds $9,270,000 - Issued May 14, 2015 Int Rate 2.70% 2.70% 2.70% 2.70% 2.70% 2.70% 2.70% 2.70%
$ 8,975,000 $ 2,394,725
Principal -
Interest 315,648 315,648 315,648 315,648 315,648 315,648 315,648 315,648
$ 8,150,000 $ 2,525,184
Total All Issues
Total Principal 350,000 390,000 440,000 825,000 885,000 945,000 1,005,000 1,060,000
Total Total Interest Debt Service 732,728 1,082,728 708,308 1,098,308 680,918 1,120,918 654,023 1,479,023 623,948 1,508,948 587,348 1,532,348 548,348 1,553,348 507,048 1,567,048
18,305,000 $ 5,042,669 $ 23,347,669
Amount Available in Debt Service Fund Amount to be Provided for Payment of General Long-Term Debt
$ 828,577 $ 22,519,092
District Background District 109 is situated 25 miles north of Chicago comprising most of the Village of Deerfield and portions of the Villages of Riverwoods & Bannockburn and the City of Highland Park. It is comprised of four elementary schools (grades K-5) and two middle schools (grades 6-8). Graduates of District 109 attend Deerfield High School of Township High School District 113. District Schools and Enrollment (as of June 30, 2017) Kipling Elementary
South Park Elementary
Walden Elementary
700 Kipling Place Deerfield, IL 60015 Enrollment: 470
1421 Hackberry Road Deerfield, IL 60015 Enrollment: 453
630 Essex Court Deerfield, IL 60015 Enrollment: 459
Wilmot Elementary
Shepard Middle School
Caruso Middle School
795 Wilmot Road Deerfield, IL 60015 Enrollment: 504
440 Grove Place Deerfield, IL 60015 Enrollment: 537
1801 Montgomery Road Deerfield, IL 60015 Enrollment: 559
Major Goals and Objectives The 2017-18 school year will mark the first year of implementation of the 2017 Strategic Plan. The plan was developed with input from more than 1,700 people in our community through interviews, focus groups, surveys, and data analysis and student performance. The plan lays out the mission, vision, portrait of a graduate, guiding principles, goals and objectives. Mission: Provide innovative educational experiences of the highest quality that engage, inspire 14
and empower each student to excel and contribute to improving the world. Vision: To be a premier public school system that provides limitless opportunities for learning, leadership, and growth for all students and staff. Guiding Principles: The principles are accepted guidelines that capture the District’s values and priorities and provide direction for employees as they go about their daily work. We will: Make decisions based on what is best for students considering research, data, and stakeholder input. Provide a safe, respectful, and inclusive learning environment. Ensure that each student is educated by highly qualified and highly effective staff. Ensure each student reaches his or her potential by providing equal access to individualized academic and social-emotional learning opportunities. Provide innovative learning spaces and experiences. Ensure transparency and build trust through effective communication and sound financial stewardship. Inspire students to be lifelong learners who enrich the world. Goals: The three broad goals to which the objectives are aligned clearly share that which we value: Limitless learning experiences for ALL children. Goal 1: Student Success: Inspire and empower each student to grow socially, emotionally, and academically. Objectives: Determine and address each student’s unique learning needs, interests and strengths. Optimize academic growth of each student. Work together with families and staff to address the social-emotional learning needs of each student. Ensure a consistent and balanced assessment system to support the Portrait of a Graduate. Ensure consistent grading and reporting system that provides clear and meaningful feedback on student progress. Increase parent-teacher communication about each student’s educational progress.
15
Goal 2: Teaching, Learning & Innovation: Deliver an engaging learning environment that promotes excellence. Objectives: Establish and communicate clear learning standards in every classroom as the expectation for each student and the limit for no student. Provide full support for successful implementation of new initiatives that improve learning. Integrate current and emerging technologies to enhance pedagogy and student learning. Evaluate at least two District programs annually, developing and implementing a plan to address any areas needing improvement. Increase experiential learning opportunities for each student. Provide relevant professional learning, which targets the needs of each staff member Goal 3: Governance and Operations: Allocate resources in alignment with the strategic goals. Objectives: Provide a positive and safe environment. Attract, develop, and retain high quality staff Evaluate the return on investment of expenditures on educational programs and facility improvements. Ensure the long-term facilities plan supports learning. Provide targeted, relevant and transparent communication to all stakeholders. Build partnerships with the community to support and enhance student learning. Allocation of Human and Financial Resources to Achieve Strategic Goals The District allocates 83%, or $43 million of the $51.7 operating funds budget to the education fund. These funds are further allocated to instructional, support services and non-programmed charges. The District spends 67%, or $28.8 million, of the $43 million education fund budget on instructional program expenditures. The District’s objectives are to educate students to be selfdirected learners, critical thinkers, effective communicators, collaborative team members and responsible members of society. The District provides special education, preschool, gifted programs, modern language instruction, technology, and extensive extracurricular opportunities in addition to its rigorous pre K – 8 curriculum.
16
The District spends 28%, or $11.9 million of its education fund budget on support services from social workers, psychologists, speech pathologists, guidance counselors and instructional coaches. The District spends the remaining 5%, or $2.1 million of its $43 million education fund budget in payment to other local education agencies on programs and residential placements for students who have needs that cannot be served in the District and on capital outlay such as purchases that bring 1:1 technology into the curriculum. Overall, the allocation of Human and Financial resources focuses on providing the best combination of instructional and support services. All children in the Deerfield Public Schools District 109 are entitled to a superior education that enhances their quality of life and maximizes their chances for success. As part of carrying out our mission to provide innovative educational experiences of the highest quality that engage, inspire and empower each student to excel and contribute to improving the world, the District is committed to making sure that all students strive for and achieve personal academic excellence. Academic Results The “School Report Card,” published annually by the State of Illinois, provides comparative data to assess academic effectiveness and resource management. The School Report Card documents Deerfield School District 109’s excellent record in key areas of performance and accountability. Our students significantly outperform the averages for the State of Illinois and they also consistently top the average scores for their local peer districts in surrounding communities. The complete school report card for 2015-16 can be viewed at: http://illinoisreportcard.com/District.aspx?districtid=34049109002 In 2013, the Illinois State Board of Education (ISBE) raised performance expectations on ISAT Reading and Mathematics. These higher expectations raised the “cut scores,” or the thresholds between different performance levels (such as “Below Standards” and “Meets Standards”) which resulted in a downward shift in the ranking of students in meeting or exceeding the new, more rigorous Reading and Math standards. In 2014, the ISAT also included more challenging questions focusing on the rigorous expectations of the new Illinois Learning Standards in English language, arts and math. With the adoption of the new Illinois Learning Standards incorporating the Common Core, the state has retired many of its old tests and replaced them with new, innovative assessments that will provide reliable data to help guide instruction. In March, 2015, the Partnership for Assessment of Readiness for College and Careers (PARCC) test was administered in the District. The Partnership for Assessment of Readiness for College and Career (PARCC) tests are designed to measure performance against rigorous standards. The tests go beyond multiple choice 17
questions and require students to use skills like analyzing, problem solving, and writing effectively. All of these skills are necessary in order for students to be successful in the real world. Students who met or exceeded expectations are likely to be on track for the next grade level and ultimately for college and career readiness.
Source: State of Illinois School Report Card 2015/2016
Awards The Meritorious Budget Award was presented by The Association of School Business Officials International (ASBO) to Deerfield School District 109 for the first time for its Annual Operating
18
Budget presented for the fiscal year beginning July 1, 2010. The District has received the award for the last seven fiscal years. The Board and Staff are proud of this accomplishment as the stringent requirements to obtain the award reflect the commitment of the School Board to preparing and presenting a comprehensive budget. As we believe the current budget meets the requirements of the award program, we are submitting the current year budget to ASBO for consideration. The Government Finance Officers Association of the United States and Canada (GFOA) awarded a Certificate of Achievement for Excellence in Financial Reporting to Deerfield Public Schools District 109 for its comprehensive annual financial report for the fiscal year ended June 30, 2015. The Illinois Chapter of National School Public Relations Association (INSPRA) has awarded numerous Distinguished Service Awards to employees of Deerfield Public Schools District 109 in three of the last four fiscal years. Acknowledgements The proposed budget is a thoughtful plan. It continues the practice of efficient and effective spending, while allowing us to achieve our mission of delivering the highest quality of education possible to every student. We extend our appreciation to the members of the Board of Education for their interest and support in planning and conducting the financial operations of Deerfield Public Schools District 109 in a responsible and progressive manner. Respectfully submitted,
Greg Himebaugh Assistant Superintendent for Finance & Operations
19
Mary Kay Pawlak Business Manager
Deerfield Public Schools District 109 2017-2018 Board of Education
Nick Begley President
Ron Worth Vice President
Sari Montgomery Secretary
Scott Kluge Member
Katie Bittner Member
Jodi Shapira Member
Kenneth J. Ashman Member
Schedules and minutes of Board of Education meetings are available at www.DPS109.org. The public is welcome and encouraged to attend meetings of the Board of Education. 20
District Administration Central Office Administrators Dr. Michael Lubelfeld Anthony McConnell Greg Himebaugh
Superintendent Assistant Superintendent for Teaching, Learning & Innovation Assistant Superintendent for Finance & Operations, CSBO
Dr. Dale Fisher
Assistant Superintendent for Human Resources
Joanna Klopfer
Assistant Superintendent for Student Services
Danielle Arnold
Director for Student Services
Amy Rubin
Director for Learning and Assessment Services
Marcie Faust
Director for Innovative Learning
Charlie Privett
Director of Buildings & Grounds
Mary Kay Pawlak
Business Manager
Adam Levinstein
Coordinator for Technology
Cathy Kedjidjian
Coordinator of Communications and Community Relations
Building Administrators Dr. John Filippi
Principal, Shepard Middle School
Samuel Kurtz
Associate Principal, Shepard Middle School
Allyson Baisden
Assistant Principal for Student Services, Shepard Middle School
Dr. Brian Bullis
Principal, Caruso Middle School
Megan Chin Matthew Milazzo
Associate Principal, Caruso Middle School Assistant Principal for Student Services, Caruso Middle School
Ann Buch
Principal, Kipling Elementary
Svetlana Sutic
Assistant Principal, Kipling Elementary
Dr. Scott Schwartz
Principal, Walden Elementary
Michael Rodrigo
Assistant Principal, Walden Elementary
Eileen Brett
Principal, Wilmot Elementary
Heather Santella
Assistant Principal, Wilmot Elementary
Dr. David Sherman
Principal, South Park Elementary
Melissa Llano
Assistant Principal, South Park Elementary
21
This Meritorious Budget Award is presented to
DEERFIELD PUBLIC SCHOOLS DISTRICT #109 for excellence in the preparation and issuance of its budget for the Fiscal Year 2016-2017. The budget adheres to the principles and standards of ASBO International’s Meritorious Budget Award criteria.
Brenda R. Burkett, CPA, CSBA, SFO President
John D. Musso, CAE, RSBA Executive Director
22
Organizational Section District Background 23 Map of District 24 Legal and Accounting Structure 25‐29 Organizational Chart 30 High Achieving District and Community……………………………………………………………………………………. 31 Major Goals and Objectives……………………………………………………………………………………………………….31‐33 Allocation of Human and Financial Resources to Achieve Strategic Goals………………………………….33‐34 Demographic and Miscellaneous Statistics 35 Budget Process 36 Budget Calendar 37 Capital Budget……………………………………………………………………………………………………………………………38 Significant Revenue Enhancement Efforts………………………………………………………………………………….39
History of District 109 In 1978, Deerfield Public Schools District 109 consolidated with Deerfield-Riverwoods School District 110. District 109 now serves students from the Village of Deerfield and portions of the neighboring Villages of Bannockburn, Riverwoods and the City of Highland Park. Formal education in Deerfield began in 1840 at the Caldwell Farm. Students from the area attended three-month sessions. Parents were required to fund the students’ education; thus, no school taxes were levied. Wilmot School was the first school built within District 110 boundaries in 1847 on the northwest corner of Wilmot and Deerfield Roads. Caldwell School was erected soon thereafter, in 1848, on the southwest corner of Waukegan and Deerfield Roads, as the first school in District 109. Districts 109 and 110 were both organized in 1860 with Caldwell School and Wilmot School as their only respective facilities. Caldwell School later became known as Deerfield Grammar School and was moved in 1903 to the site of the current District 109 administration office at 517 Deerfield Road. In 1913, Deerfield Grammar School was rebuilt after being destroyed by fire. Both districts experienced dramatic growth during the 1950s. After consolidation of the two districts in 1978, several elementary schools were closed. District 109 is now comprised of four elementary schools (grades K-5) and two middle schools (grades 6-8).
Deerfield Grammar School
Schools and Enrollment As of June 30, 2017, 2,982 students attended District 109. Kipling Elementary 700 Kipling Place Deerfield, IL 60015 Enrollment: 470 Wilmot Elementary 795 Wilmot Road Deerfield, IL 60015 Enrollment: 504
South Park Elementary 1421 Hackberry Road Deerfield, IL 60015 Enrollment: 453 Shepard Middle School 440 Grove Place Deerfield, IL 60015 Enrollment: 537
23
Walden Elementary 630 Essex Court Deerfield, IL 60015 Enrollment: 459 Caruso Middle School 1801 Montgomery Road Deerfield, IL 60015 Enrollment: 559
Deerfield School District 109 Deerfield SD 109 Deerfield School District 109
Lake County, Illinois Northern Chicago Suburb
Deerfield School District 109
4,000 Feet Sources: Sources: Esri, HERE, DeLorme, Intermap, increment P Corp., GEBCO, USGS, FAO, NPS, NRCAN, GeoBase, IGN, Kadaster NL, Ordnance Survey, Esri Japan, METI, Esri China (Hong Kong), swisstopo, MapmyIndia, © OpenStreetMap contributors, and the GIS User Community
Geographic Information System Lake County GIS Division 18 N County St Waukegan IL 60085 (847) 377-2388
Elementary School Districts _Query Result
¯
Map Printed on 4/11/2017
Disclaimer:
24
The selected feature may not occur anywhere in the current map extent. A Registered Land Surveyor should be consulted to determine the precise location of property boundaries on the ground. This map does not constitute a regulatory determination and is not a base for engineering design. This map is intended to be viewed and printed in color.
Legal and Accounting Structure Legal Structure The District includes all funds and account groups that are controlled by or dependent on the Board of Education of the District. Board members are elected by the public and have decision making authority, the power to designate management, the ability to significantly influence operations, and the primary accountability for fiscal matters. There are no other entities for which the District operates independently and is not included as a component of any other reporting entity. The district levies its own local property tax, which is filed with the Lake County Clerk. Taxes collected by the County Clerk are extended and disbursed directly to the District. All real property of the District is held in trust for the beneficial interest of the District by the Board of Education which has final authority for the control and disposition of such property. The District has complete responsibility for the preparation and modification of its annual budget and is solely accountable for its fiscal matters, including surpluses and deficits and issuance of debt. Governmental Accounting Structure The district maintains individual funds as prescribed by the Illinois State Board of Education. Funds are individual accounting entities with a self balancing set of accounts. Each fund is set up to limit or restrict spending to the fund’s intended purpose and to preserve the identity of its resources and obligations. The District maintains the following Governmental and Fiduciary funds. Education Fund
General Fund
Operations and Maintenance Fund Transportation Fund
Special Revenue Fund
JJJuJudgement Municipal Fund Retirement/Social Security Fund
Capital Projects Fund
Capital Projects Fund
JJJuJudgement Fire Prevention and Fund Safety Fund JJJuJudgement Debt Service Fund Fund JJJuJudgement Student Activity Fund Fund JJJuJudgement Fund
Debt Service Fund
Fiduciary Fund
25
Governmental Funds General Revenue Funds Educational Fund The Educational Fund, as is the generally accepted practice for Illinois School Districts, is the general operating fund of the District. It is used to account for all financial resources except those that are required to be accounted for in another Fund. It accommodates all activity that relates to the direct instructional, support, and administrative services provided for District students – including Special Education. Special Revenue Funds Operations & Maintenance Fund The Operations and Maintenance Fund accounts for activity relating to the maintenance of District facilities and fixed assets. This fund includes the salaries and benefits of custodial and maintenance personnel and their direct supervisors, and any outsourced custodial services. Transportation Fund The Transportation Fund accounts for activity relating to the transportation of regular and special education students to and from school on a daily basis and for additional interscholastic activities. The revenue for the operation of this fund is derived from local taxes, local transportation fees, State aid for transportation of pupils, and State aide for transportation of pupils with special educational needs. Municipal Retirement/Social Security Fund This fund accounts for activity that relates directly to the District’s share of State and Federal retirement plans. This fund covers employer pension costs such as Illinois Municipal Retirement, as well as Social Security and Medicare. Debt Service Funds Debt Service Fund The Debt Service fund accounts for the accumulation of resources for, and the payment of general long-term debt principal, interest, and related costs. Capital Projects Funds Capital Projects Fund This fund accounts for financial resources to be used for the acquisition, construction, or improvement of major capital facilities. Fire Prevention and Safety Fund A restricted fund to be used by schools to correct Health and Life Safety violations. It may also be used for asbestos abatement, roof repair or replacement, building replacement, energy conservation, security measures, accessibility needs, paving repairs and other projects identified as necessary to maintain healthy and safe buildings.
26
Fiduciary Funds Fiduciary funds account for assets held by the District in a trustee capacity or as an agent for individuals, private organizations, other governments or other funds. The Agency Funds include Student Activity Funds, which account for assets held by the District as an agent for the students and teachers. These funds are custodial in nature and do not involve the measurement of the results of operations. The District’s finances are organized and presented along the following dimensions: Fund – see explanation above Function – the activity or purpose. The activities of a school system are classified into five broad areas: instruction, supporting services, community services, non-programmed charges, and debt services. These functions are further subdivided into sub-functions consisting of activities which have common operational objectives. Instruction - includes the activities dealing directly with the teaching of pupils, or the interaction between teachers and pupils. This function is further subdivided into the following areas: Regular Programs – include instructional activities at both the elementary and middle schools. Special Programs – designed primarily to deal with exceptional pupils. Included under this area are the special education and gifted educational programs. Supporting Services – services that provide administrative, technical, and logistical support to facilitate and enhance instruction. These services exist for the fulfillment of the objectives of instruction. This broad area has been subdivided as follows: Pupil – activities that assess and improve the well being of pupils and supplement the teaching process. These would include guidance and social work services, health services, psychological services and speech services. Instructional – activities that assist the instructional staff in planning, developing, and evaluating the process of providing learning experiences for the pupils, including all teaching and learning resources General Administration – activities concerned with establishing and administering policy in connection with operating the District. Building Administration – activities which are concerned with the overall administrative responsibilities of a single school. Business – activities that are concerned with purchasing, transporting, and maintaining goods and services for the School District. This would include fiscal services, operation of building/plant services, transportation, and food services. Community Services – Services provided for the community as a whole, or some segment of the community, such as community recreation programs, civic organization activities,
27
public libraries, programs of custody and child care, welfare services, nonpublic school pupil services, and home/school services. Non-Programmed Charges – represent conduit-type payments to other school districts in or out of the State. This would include payments to NSSED, the special education cooperative serving District 109. Debt Services – the function or area used for the retirement of bonds for building construction, and other debt services, as needed. Object – describes the service or commodity obtained as a result of a specific expenditure. The object categories are salaries, benefits, purchased services, supplies and materials, capital outlay, and tuition. Salaries – The total amount regularly paid or stipulated to be paid to an individual, before deductions, for personal services rendered while on the payroll of the district. Benefits – Compensation, in addition to regular salary, provided to an employee. This may include health insurance, life insurance, vacation and personal leave, sick leave, social security, and pension contributions. Purchased Services – Personal services rendered by persons not on the payroll of the district and any other services purchased. Supplies – An expendable item that is consumed, worn out, or deteriorated in use. Capital (and equipment) – Any instrument, machine or apparatus which retains its original shape and appearance with use and is not expendable or consumed. Tuition – Money charged to the district for students for instruction by other institutions, for example special education services. Location – Location numbers are used to track budgets by the seven district locations: Kipling Elementary, South Park Elementary, Walden Elementary, Wilmot Elementary, Shepard Middle School, Caruso Middle School, and the Administration Building. Budgetary Basis of Accounting and Classification of Revenues and Expenditures The governmental fund financial statements are reported using the current financial resources measurement focus and modified accrual basis of accounting. Under this method, revenues are recognized when measureable and available. The District considers all revenues reported in the governmental funds to be available if the revenues are collected within sixty days after the end of the fiscal year. Revenue is the receipt of cash without creating a liability or without canceling an asset. For example, tax collections are revenues, but proceeds from general long-term debt, acquisitions under capital leases, and transfers between funds are reported as other financing sources. Expenditures are recorded when the related fund liability is incurred, except for principal and interest on general-long term debt, claims and judgments, and compensated absences which are recognized as expenditures to the extent that they have matured. General capital asset acquisitions are reported as expenditures in governmental funds.
28
District Financial Policies Restricted Resources Under terms of grant agreements, the District funds certain programs by a combination of specific cost reimbursement grants, categorical grants, and general revenues. Thus, when program expenses are incurred, there are both restricted and unrestricted net assets available to finance the program. It is the District’s policy to apply cost-reimbursement grant resources to such programs, followed by categorical grant, and then by general revenues. Encumbrances The District maintains an encumbrance accounting system as one technique of accomplishing budgetary control. Encumbered amounts lapse at year-end. Capitalized Equipment Equipment purchases in excess of a $2,500 threshold require that the District capitalize and depreciate.
29
Deerfield School District 109 Organizational Chart Superintendent
Assistant Superintendent for Teaching , Learning and Innova on
Director for Innova ve Learning
Assistant Superintendent for Student Services
Director for Learning and Assessment Services
Director for Student Services
Assistant Superintendent for Finance & Opera ons, CSBO
Assistant Superintendent for Human Resources
Principals Associate Principals
Business Manager
Assistant Principals
Human Resources Specialist
Coordinator for Technology
Director of Buildings and Grounds
Benefits Specialist
Supervisor of Opera ons
Recep onist
Administra ve Assistant
Payroll Coordinator for Communica ons & Community Rela ons
Administra ve Assistant
Administra ve Assistant
Administra ve Assistant
Business Office Specialist
Harvard Maintenance
Accounts Payable
Administra ve Assistant
Olson Transporta on Net 56 Technology
30
High Achieving District and Community Four of the six schools that make up Deerfield Public Schools District 109 earned the 2011 Academic Excellence Award from the Illinois State Board of Education. In 2016, Shepard and Walden were recognized as National Blue Ribbon Schools. District graduates of District 109 attend Deerfield High School of Township High School District 113, which is proud to have 98% of its graduates enroll in educational institutions of higher learning. The community is comprised of prominent business and corporate leaders who have excelled in their various fields and expect the same of the educational programs of the district. These expectations continue to be met by the District as its students score in the top percentiles of nationally normed standardized achievement tests. In 2015-16, over 75% of students scored ready for the next level on the PARCC assessment, significantly exceeding state averages. District 109 students also consistently top the average scores for their local peer districts in surrounding communities. See pages 129-131 in the Information Section for detailed information on assessments in the District. The District provides special education, preschool, gifted programs, modern language instruction, technology, and extensive extracurricular opportunities in addition to its rigorous curriculum. During the 2017-18 school year, the District will continue to update curriculum to meet Common Core Standards in all grade levels, and will increase science opportunities in the middle schools. Stakeholder satisfactions survey results can be found in the Information Section on page 13.7.
Major Goals and Objectives The 2017-18 school year will mark the first year of implementation of the 2017 Strategic Plan. The plan was developed with input from more than 1,700 people in our community through interviews, focus groups, surveys, and data analysis and student performance. The plan lays out the mission, vision, portrait of a graduate, guiding principles, goals and objectives. Mission: Provide innovative educational experiences of the highest quality that engage, inspire and empower each student to excel and contribute to improving the world. Vision: To be a premier public school system that provides limitless opportunities for learning, leadership, and growth for all students and staff. Guiding Principles: The principles are accepted guidelines that capture the District’s values and priorities and provide direction for employees as they go about their daily work. We will:
31
Make decisions based on what is best for students considering research, data, and stakeholder input. Provide a safe, respectful, and inclusive learning environment. Ensure that each student is educated by highly qualified and highly effective staff. Ensure each student reaches his or her potential by providing equal access to individualized academic and social-emotional learning opportunities. Provide innovative learning spaces and experiences. Ensure transparency and build trust through effective communication and sound financial stewardship. Inspire students to be lifelong learners who enrich the world. Goals: The three broad goals to which the objectives are aligned clearly share that which we value: Limitless learning experiences for ALL children. Goal 1: Student Success: Inspire and empower each student to grow socially, emotionally, and academically. Objectives: Determine and address each student’s unique learning needs, interests and strengths. Optimize academic growth of each student. Work together with families and staff to address the social-emotional learning needs of each student. Ensure a consistent and balanced assessment system to support the Portrait of a Graduate. Ensure consistent grading and reporting system that provides clear and meaningful feedback on student progress. Increase parent-teacher communication about each student’s educational progress. Goal 2: Teaching, Learning & Innovation: Deliver an engaging learning environment that promotes excellence. Objectives: Establish and communicate clear learning standards in every classroom as the expectation for each student and the limit for no student. Provide full support for successful implementation of new initiatives that improve learning.
32
Integrate current and emerging technologies to enhance pedagogy and student learning. Evaluate at least two District programs annually, developing and implementing a plan to address any areas needing improvement. Increase experiential learning opportunities for each student. Provide relevant professional learning, which targets the needs of each staff member Goal 3: Governance and Operations: Allocate resources in alignment with the strategic goals. Objectives: Provide a positive and safe environment. Attract, develop, and retain high quality staff Evaluate the return on investment of expenditures on educational programs and facility improvements. Ensure the long-term facilities plan supports learning. Provide targeted, relevant and transparent communication to all stakeholders. Build partnerships with the community to support and enhance student learning.
Allocation of Human and Financial Resources to Achieve Strategic Goals The District allocates 83%, or $43 million of the $51.7 operating funds budget to the education fund. These funds are further allocated to instructional, support services and non-programmed charges. The District spends 67%, or $28.8 million, of the $43 million education fund budget on instructional program expenditures. The District’s objectives are to educate students to be selfdirected learners, critical thinkers, effective communicators, collaborative team members and responsible members of society. The District provides special education, preschool, gifted programs, modern language instruction, technology, and extensive extracurricular opportunities in addition to its rigorous pre K – 8 curriculum. The District spends 28%, or $11.9 million of its education fund budget on support services from social workers, psychologists, speech pathologists and instructional coaches. The District spends the remaining 5%, or $2.1 million of its $43 million education fund budget in payment to other local education agencies on programs and residential placements for students who have needs that cannot be served in the District and on capital outlay such as purchases that bring 1:1 technology into the curriculum.
33
Overall, the allocation of Human and Financial resources focuses on providing the best combination of instructional and support services. All children in the Deerfield Public Schools District 109 are entitled to a superior education that enhances their quality of life and maximizes their chances for success. As part of carrying out our mission to provide innovative educational experiences of the highest quality that engage, inspire and empower each student to excel and contribute to improving the world, the District is committed to making sure that all students strive for and achieve personal academic excellence.
34
Deerfield Public Schools – District 109 Demographic and Miscellaneous Statistics
Location:
25 miles north of Chicago comprising all of the Village of Deerfield and portions of the Villages of Riverwoods & Bannockburn and the City of Highland Park
Date of Incorporation
1860
Population Served (60015 zip code)
26,800 (2010)
Median Household Income
$131,337 (2015)
Unemployment Rate (Chicago Metro, March, 2017)
4.5%
Number of Schools
2 Middle Schools (grade 6-8) 4 Elementary Schools (grade pre-K – 5)
Student Population
2,979
Teaching Staff
280.66 Full Time Equivalent
Average Class Size
21
Teacher’s holding Master’s degree or higher
73%
Median Housing Value (April 30, 2017)
$473,800
% of Households with children under 18
29.41%
Source: District Records U.S. Census Bureau Illinois Department of Employment Security Village Deerfield Zillow.com
35
Budget Process Budget Development Process The Deerfield Public Schools District 109 budget process is guided by the School Code of Illinois as well as Board of Education policy. Illinois Code mandates that local school districts prepare a budget calendar and seek Board authorization to commence the budgeting process. The fiscal year is to commence July 1 of each year with an end date of June 30, and the Illinois School Code has a statutory deadline for passage of the budget by September 30 of each fiscal year. The administration and staff work in a collaborative manner to arrive at a detailed revenue and expenditure plan for operations on a fiscal year basis. The ultimate goal of this process is to recommend to the Board a balanced budget that will provide continued world class education for all learners of District 109. While one of the Board of Education’s perpetual goals is to adhere to a balanced budget, it is not an official policy of the district. Likewise, the Board of Education and its Board Finance Committee have goals to maintain ninety days cash-on-hand, but it is not an official policy of the District. District 109 Administration seeks authorization from the Board of Education in December of each year to prepare the budget for the year beginning the following July 1. The 2017-18 budget development calendar was passed by the Board at its December 12, 2016. Budgetary Controls Budgetary controls are maintained at line item levels and are built into administrative responsibility cost centers before being combined to form totals by fund. All actual activity compared to the budget is reported to the District's management and the Board of Education in the form of monthly Treasurer Reports. Any extraordinary variances are disclosed in full detail. The objective of these budgetary controls is to ensure compliance with legal provisions embodied in the annual appropriated budget approved by the Board of Education. Activities of all Governmental Fund types are included in the annual appropriated budget. Budget Modification Each spring, the Board’s Finance Committee reviews the budget to determine if amending the budget is necessary. It is the goal of the Finance Committee to avoid notations of overspending in the annual audit, so any unplanned expenditures are reviewed to determine if an amended budget is necessary. Should amendment be necessary, the Board must review the proposed changes, publish notice and hold a public hearing, following the same procedure used for the adoption of the original budget. The Board of Education may make transfers between the various items in any fund not exceeding in the aggregate of 10% of the total of such fund as set forth in the budget. Financial Reporting The Budget for all major Governmental Funds is prepared on the accrual basis of accounting, which is the same basis that is used in financial reporting. This allows for comparability between budget and actual amounts. This is an acceptable method in accordance with Chapter 105, Section 5/17-1 of the Illinois Compiled Statutes.
36
DEERFIELD PUBLIC SCHOOLS – DISTRICT 109
BUDGET PREPARATION, REVIEW AND APPROVAL CALENDAR SCHOOL BUDGET for Fiscal Year Beginning July 1, 2017 DESCRIPTION
DATE
1
5-Year Financial Projections presented to Board of Education
February 22, 2016
2
Tentative Tax Levy for 2016 presented to the Board of Education
October 24, 2016
3
Truth in Taxation Public Hearing Tax Levy for 2016, Levy approved Tax Levy for 2016 filed with the Clerk of Lake County
4 5
Facility Development Committee capital planning meeting 5-Year Financial Projections presented to Board of Education
6
Administrative conferences held to distribute and discuss Budget Guidelines and Worksheets Budget Input received from administrators
7 8 9
Tax Levy for 2016 approved and extended by the Clerk of Lake County Budget Review and Analysis (including Finance Committee)
November 14, 2016 November 16, 2016 February 15, 2017 February 27, 2017 Week of March 6, 2017 March 22, 2017 April 2017 May/June, 2017
12
Tentative Fiscal Year 2018 School Budget presented to Board and approved for public display and inspection Notice of availability of Tentative Fiscal Year 2018 School Budget for public inspection published Public Hearing on Tentative Fiscal Year 2018 School Budget
13
School Budget for Fiscal Year 2018 adopted by the Board
14 15
School Budget for Fiscal Year 2018 filed with the Illinois State Board of Education Tentative Tax Levy for 2017 presented to the Board
16
Multi-year Financial Plan update presented to the Board
November 2017
17
Tax Levy for 2017 approved by the Board
November 2017
18
Tax Levy for 2017 filed with the Clerk of Lake County
December 2017
10 11
37
June 5, 2017 June, 2017 July, 2017 July, 2017 By September 30, 2017 October 2017
Capital Budget
District 109 capital spending priorities are set in collaboration with staff, administration, the Buildings & Grounds Department and its consultants, and the Board of Education and its Facilities Development Committee (FDC). Discussion on capital spending priorities involves a number of criteria, including the impact on learning and achievement, safety and security, energy efficiency, return on investment and aesthetics. The Facilities Development Committee (FDC) is comprised of three Board members and several District administrators. The FDC begins discussing the capital budget in September preceding the new fiscal year and uses a 5-year capital plan that is updated regularly. Administrators and the FDC prepare a “wish list” which is shared with the community, the Board, and District staff. Once consensus is achieved, the FDC directs the Administration to competitively bid projects and reconvenes to consider results in January and February. By March, final projects are sent to the full Board of Education for consideration and the final capital budget for the fiscal year is prepared from this action in May. In 2012, the Board of Education commissioned a Master Facility Plan. As of June 30, 2017, the Plan is complete. The FDC committee and Board will begin the process of creating a new Master Facility Plan during the 2017-2018 school year. A 10-year Life Safety Study completed in 2013 as part of a long range facility plan will see the District continue roof maintenance, casework replacement, concrete repair and tuck pointing. The 2017-18 budget includes approximately $1.8 million planned to be spent on needed renovations and capital projects at the six school buildings, including new lockers and cabinetry, roof replacement and ADA accessibility modifications.
38
Significant Revenue Enhancement Efforts Full-Day Kindergarten – the State of Illinois requires that public schools provide a free half-day kindergarten program for students. For the second half of the kindergarten day, the district offers an optional tuition-based program, priced to compete favorably with other day care options. At an annual tuition of $1,040 per child x 257 children, this program is budgeted to generate approximately $270K in FY18. These proceeds cover the cost of additional teacher positions needed to support the program, along with associated support services. The program is expected to be self-sustaining in future years and no tuition will be charged. Tuition Based Pre-School – District 109 firmly believes and supports the academic, social and emotional growth of all children in the most authentic and rich learning environment. To support this belief, District 109 offers residents the exemplary early childhood program called Helping Hands, which serves a blend of typically developing preschoolers and preschoolers with special needs. Offered at an annual tuition of $4,100, the program is expected to generate $100,000 in FY18.
39
Financial Section Introduction to Financial Section………………………………………………………………………………………………..40 Total Governmental Funds All Governmental Funds – Fund Balance Classifcations………………………………………………………………41 Revenue Assumptions………………………………………………………………………………………………………………..42 Expenditure Assumptions…………………………………………………………………………………………………………..43 FY2018 Budget Fund Summary – Revenues by Source, Expenditures by Object............................44 FY2018 Budget Fund Summary – Detailed Revenues by Source, Expenditures by Function………..45 Chart – FY2018 Budget Revenues and Expenditures by Fund……………………………………………………..46 Historical Revenues by Source, Expenditures by Object……………………………………………………………..47 Historical Detailed Revenues by Source, Expenditures by Function……………………………………………48 Chart – FY2018 Budget Revenue by Source, Expenditures by Object………………………………………….49 Chart – Historical Revenues vs. Expenditures and Fund Balance………………………………………………..50 Educational Fund Historical Revenues by Source, Expenditures by Function………………………………………………………….51 Chart – Historical Revenues vs. Expenditures and Fund Balance………………………………………………..52 Historical Detailed Revenues by Source, Expenditures by Object……………………………………………….53 Operation & Maintenance Fund Historical Revenues by Source, Expenditures by Function………………………………………………………….54 Chart – Historical Revenues vs. Expenditures and Fund Balance………………………………………………..55 Historical Detailed Revenues by Source, Expenditures by Object……………………………………………….56 Transportation Fund Historical Revenues by Source, Expenditures by Function Chart – Historical Revenues vs. Expenditures Chart –Transportation Funding Source History Historical Detailed Revenues by Source, Expenditures by Object
57 58 58 59
Municipal Retirement / Social Security Fund Historical Revenues by Source, Expenditures by Function Historical Detailed Revenues by Source, Expenditures by Object
60 61
Debt Service Fund Historical Revenues by Source, Expenditures by Function ……………………………………………………….. 62 Historical Detailed Revenues by Source, Expenditures by Object……………………………………………… 63 Bond Amortization Schedule 64 Capital Projects Fund Capital Project Fund narrative……………………………………………………………………………………………………65 Historical Revenues by Source, Expenditures by Function………………………………………………………….66 Historical Detailed Revenues by Source, Expenditures by Object 67 Historical Capital Budget Detail …………………………………………………………………………………………………68
Financial Section Fire Prevention & Safety Fund Historical Revenues by Source, Expenditures by Function 69 Historical Detailed Revenues by Source, Expenditures by Object 70 Aggregate Fund Balances……………………………………………………………………………………………………………71 Budget Detail Chart – School Budgets 72 Chart – Budget History by School 72 Chart – School Budget by Category 73 Kipling School Budget History 74 South Park School Budget History 75 Walden School Budget History 76 Wilmot School Budget History 77 Shepard School Budget History 78 Caruso School Budget History 79 Executive Administration 80 Business Services, Technology, and Human Resources 81 Learning 82‐83 Student Services 84 Transportation 85 Operations & Maintenance 86‐87 Other Funds……………………………………………………………………………………………………………………………….88 Miscellaneous Salaries……………………………………………………………………………………………………………….89‐90
Introduction to Financial Section In the spring of 2005, the voters of Deerfield Public Schools District 109 approved a $0.35 operating rate referendum by a margin of two-to-one. As a result of this permanent increase in tax rate, the 2017-18 budget will be the thirteenth consecutive balanced budget following 14 years of deficit budgets. In the years since the referendum, the District has been capable of improving its facilities and building healthier fund balances as demonstrated in the Statement of Revenue, Expenditures and Change in Fund Balance tables. District 109’s revenue sources are property taxes, state and federal grants, tuition and fees, and interest income. The District is entirely dependent on the local property taxes as demonstrated in the Revenue by Source pie chart. In part due to the affluence and exceptional learning outcomes for the District, a mere 4% of revenues come from state and federal grants. Property taxes comprise over 90% of total revenue sources. District 109’s expenditure categories are salaries, benefits, purchased services, supplies, capital outlays, and tuition/other. More than two thirds of the District’s expenditures are for staff salaries and benefits. In 2015, the Board of Education and the Deerfield Education Association (representing Deerfield 109 teachers) reached a new four year collective bargaining agreement. Resulting changes in salaries and benefits can be found in the 75-page agreement on the District’s website: www.dps109.org. The Board also reached a five year agreement with the Deerfield Educational Support Staff Association (representing Deerfield 109 support staff) in the May 2017. Purchased services include costs associated with outsourced transportation, technology, and custodial services. The District is part of a large special education consortium, North Suburban Special Education District (NSSED), and places students in special needs classes with the cooperative and in other out-of-district placements which result in tuition charges. Building and other department administrators are responsible for building, monitoring and adhering to their site budgets and these site budgets can be found commencing on page . The District maintains relatively little bonded debt and received an increased rating in 2013 of Aa1 from Moody’s Investment Services. Information regarding District 109’s debt can be found on the final two pages of the Financial Section.
40
All Governmental Funds – Fund Balance Classifications Fund balances represent the residual financial position of the District after revenues and expenditures are accounted for using Generally Accepted Accounting Principles (GAAP). Thus fund balances are a key indicator of the District’s financial integrity and stability. Governmental Funds – Fund Balance Classifications. The governmental funds present fund balances based on a hierarchy that shows, from highest to lowest, the level or form of constraints on fund balance resources and the extent to which the District is bound to honor them. Nonspendable fund balances represent residual equities (assets) that cannot be spent because of contractual or legal requirements. Restricted fund balances represent residual equities that are available for use but which have external enforceable legal restrictions as to how these resources may be used. The District’s funds that are restricted are: Operations & Maintenance Services, Transportation, Bond Principal & Interest Payments and Capital Projects. Committed fund balances represent resources whose use is constrained by limitations imposed by the District’s Board of Education. The District’s Board of Education is the highest level of decision making authority for committed fund balances. Committed fund balances are established through Board of Education formal budget adoption, formal policy or action item adoption, and/or through formal Board of Education resolution. Any of these actions taken by the Board are considered binding. Assigned fund balances represent resources whose use is constrained by limitations imposed by the District’s administration. The Board of Education delegates authority to the Superintendent and/or Business Administrator to determine specific purposes for these fund balances. Assigned fund balances are approved by the Board through formal budget and/or financial report adoption before annual financial reports are considered official. The Board of Education retains the right to change these assigned fund balances if needed through budget or annual financial report certification and formal approval. Unassigned fund balances represent resources which have not been classified as nonspendable, restricted, committed, or assigned fund balance classifications. A negative unassigned fund balance may be reported in the General Fund or other governmental funds, if expenditures incurred for specific purposes exceeded the amounts restricted, committed, or assigned to those purposes. The District’s Education Fund is designated as unassigned. The Board adopts and certifies annual budgets and annual financial statements each year validating fund balances and their classification.
41
Revenue Assumptions Investment income Investment income is projected to remain depressed in 2017‐2018 assuming the current 1% rate of return on investments. Interest earnings reflected in the projections are based upon forecasted monthly fund balances. Student Fees Fees are charged at various levels designed to subsidize programs and services. The District charges fees for transportation, co‐curricular athletics and clubs. In 2017‐18, the District is offering an extended day Kindergarten program which will generate approximately $250,000 to help offset the cost of the program. Student fees are expected to account for 1.63% of total revenue. State Revenue Revenue from State sources has been declining for several years. Given the State’s poor financial condition, the District expects this trend to continue and has budgeted State mandated categorical revenue and State grants accordingly. In 2007‐08 the District proactively began allocating General State Aid and, later, replacement taxes (which are a replacement of local revenue collected and disbursed by the state) to the Capital Projects fund instead of the Educational fund. This shift reduced the District’s reliance on these revenue sources in anticipation that they may diminish or be withdrawn in the future. As a result, extra resources were available for this year’s extensive capital improvement plan and the District has minimized its exposure to the worsening State financial crisis. Recent movement in the state’s capitol leads us to further uncertainty about maintaining the state’s share of overall Deerfield 109 revenue. Educational equity continues to be debated by the Illinois General Assembly and would result in the District losing over 50% of state source revenue. Federal Revenue Federal revenue is comprised of Title I and Title II grants as well as IDEA grants and is projected to grow at 2% in subsequent years.
42
Expenditure Assumptions
Certified Staff (DEA) Salary Costs Enrollment is expected to remain fairly stable with a 1.34% decrease in number of students. Overall, certified staff is projected to increase 6.15 FTE due in part to addition of a middle school math coach, Team Fusion teacher and school psychologist and to maintain class size philosophy. The average salary increase for teaching staff was 3%. Compensation for certified staff was estimated by advancing returning staff by one step on the existing salary schedule adjusted for known contractual increases, as well as increases for advanced degrees and professional development. The Board of Education and the Deerfield Education Association ratified a collective bargaining agreement which expires at the end of the 2018‐19 school year. Forecasted enrollment changes and average salary increases for similar governmental units were used to project future salary costs. Non‐Certified Staff (DESSA) Salary Costs The salary costs for Deerfield Educational Support Staff Association members are projected based on average salary increases for similar governmental units. In May 2017, The Board of Education and the Deerfield Educational Support Staff Association ratified a collective bargaining agreement which expires at the end of the 2021‐22 school year. The number of support staff is projected to remain steady. Administrative Salary Costs Administration Staff remains the same as in 2017/2018 after an increase in 2016/2017 by 1 FTE due to the addition of a Coordinator for Technology, but overall compensation for administrators will increase 7% in part due to 9.6% increase in healthcare costs. Employee Benefit Costs Benefit costs are a significant source of expenditure inflation for many districts. Deerfield Public Schools District 109 belongs to an insurance cooperative and for the 2013‐14 school year, modified its health insurance plan in an effort to keep costs manageable. For the 2017‐18 school year, PPO premiums will increase 8.5% and HMO premiums will increase 1.1%. In addition, dental plan premiums will increase by .8%. In aggregate, this is in line with industry averages for health insurance costs. Other Expenditures All other expenditures were increased by the tax cap limiting CPI rate plus 50 to 100 basis points.
43
Deerfield Public Schools District 109 Statement of Revenue, Expenditures and Change in Fund Balance (By Object) Total Governmental Funds FY 2017-18 Budget Operating Funds (1) General Fund
Debt Service Fund
Capital Projects Fund
1,402,648 240,000 1,642,648
$ 1,239,246 $ 1,239,246
$ 1,118,629 $ 1,118,629
$
380,000 630,000 $ 1,010,000
$
$
$
$
$
Educational Fund $ 41,887,132 1,342,900 643,000 $ 43,873,032
$ 6,129,879 $ 6,129,879
$
Salaries Employee Benefits Purchased Services Supplies Capital Outlay Tuition Other Total Expenditures
$ 31,001,864 6,077,936 2,540,128 1,335,598 1,290,925 736,000 $ 42,982,452
$
655,101 107,422 1,912,900 1,029,400 1,982,040 75,660 $ 5,762,523
$
$
39,392 7,924 1,548,500 1,595,817
Excess (Deficiency) of Revenue over (under) Expenditures
$
$
$
46,831
Local Sources State Sources Federal Sources Other Total Revenue
Transportation Fund $
Capital Projects Funds
Municipal Retirement / Social Security Fund
Operations & Maintenance Fund
Revenue:
Debt Service Fund
Special Revenue Funds
2016-17 Actual (Unaudited) (6/30/17)
25,000 25,000
$ 52,182,534 2,212,900 643,000 $ 55,038,434
$
Fire Prevention & Safety Fund $
(2)
Total Budget Governmental Funds
$
52,126,490 2,254,650 771,017 55,179,108
Expenditures:
890,580
367,356
1,401,575 $ 1,401,575
1,114,308 $ 1,114,308
500,000 750,000 $ 1,250,000
1,109,000 $ 1,109,000
$ 31,696,357 7,594,858 6,501,528 2,364,998 5,131,965 736,000 1,189,968 $ 55,215,673
$
30,673,236 6,202,897 6,702,951 1,702,959 4,954,493 647,509 1,161,700 52,045,744
$
$
$
$ (1,084,000)
$
$
3,057,704
(162,329)
4,321
(240,000)
(177,240)
$
Other financing Sources (Uses): Proceeds from Bond Issues Bond Issuance Costs Transfers In Transfers Out Other
(3,000,000) -
3,000,000 (8,000,000) -
Change in Fund Balance
$ (2,109,420)
$ (4,632,644)
$
46,831
$
(162,329)
Beginning Fund Balance
$ 12,259,760
$ 5,809,950
$
1,207,108
$
$ 10,150,340
$ 1,177,306
$
1,253,939
$
Projected Ending Fund Balance
-
-
-
8,000,000 -
$
4,321
$ 7,760,000
$ (1,084,000)
$
669,996
$
828,577
$
$ 1,201,427
507,667
$
832,898
$ 8,664,882
$
904,882
-
117,427
(1) Change in Fund Balance for Total Operating Funds is budgeted at $1,142,439. (2) Anticipated 2016-17 actual revenues, expenditures and ending fund balance are expected to be consistent with budgeted amounts.
44
11,000,000 (11,000,000) (177,240)
-
$
3,133,364
$ 22,881,700
$
26,779,536
$ 22,704,460
$
29,912,900
Deerfield Public Schools District 109 Statement of Revenue, Expenditures and Change in Fund Balance (By Function) Total Government Funds FY 2017-18 Budget Operating Funds Debt Service Fund Capital Projects Funds Special Revenue Funds
General Fund
Educational Fund
Operations & Maintenance Fund
Transportation Fund
Municipal Retirement / Social Security Fund
Debt Service Fund
Capital Projects Fund
Fire Prevention & Safety Fund
Total Budget Governmental Funds
2016-17 Actual (Unaudited) (6/30/17)
$ 40,565,632 300,000 500,000 35,000 116,000 345,000 25,500 $ 41,887,132
$ 6,014,879 15,000 100,000 $ 6,129,879
$ 1,320,648 12,000 70,000 $ 1,402,648
$ 1,131,746 100,000 7,500 $ 1,239,246
$ 1,106,629 12,000 $ 1,118,629
$
$
$ 50,139,534 460,000 391,500 500,000 70,000 35,000 116,000 345,000 100,000 25,500 $ 52,182,534
$ 49,534,416 $ 448,947 $ 538,166 $ 819,400 $ 81,309 $ 29,103 $ 376,862 $ 314,109 $ 45,565 $ (34,438) $ 52,153,442
$
$
$
$
$
$
$
$
Revenue: Local Sources Real Estate Taxes Replacement Taxes Earnings on Investments Tuition Transportation Fees Food Service Fees Pupil Activity Fees Textbook Fees Rentals Other Local Total Local Revenue State Sources General State Aid Special Education Bilingual Gifted Free Lunch Reading Improvement Other State Total State Sources Federal Sources Special Ed Food Service Title I - Low Income Title IV - Safe & Drug Free Schools Other Federal Total Federal Sources Total Revenue
$
$
1,340,500 2,400 1,342,900
$
$
$
$
-
$
$
$
$
$
630,000 1,340,500 2,400 $ 2,212,900
$
$
$
$
$ 1,010,000
$
25,000
$ 55,038,434
$ 55,179,108
$ 20,296,096 7,065,310 370,800 1,026,349 101,425 $ 28,859,981
$
$
$
$
$
$
$
-
$ 20,687,325 7,418,679 384,599 1,043,292 107,839 $ 29,641,735
$ 19,474,163 6,833,702 402,223 996,432 129,619 $ 27,836,138
$
$
-
$ 2,865,730 3,373,075 1,821,521 2,298,561 6,969,432 1,139,624 $ 18,467,945 220,721
$
$
507,500 22,500 72,000 41,000 643,000
673,585 1,293,130 287,935 2,254,650
$ 1,118,629
$
-
-
$ 1,239,246
$
-
$
630,000 630,000
$ 1,642,648
$
$
-
$ 6,129,879
$
-
-
$ 43,873,032
$
-
$
240,000
$
25,000 25,000
-
$
507,500 22,500 72,000 41,000 643,000
$
-
$
360,000 20,000 380,000
$
622,668 15,929 59,061 73,359 771,017
Expenditures: Instruction: Regular Programs Special Education Educationally Deprived/Remedial Interscholastic Gifted Summer School Total Instruction Supporting Services Pupils Educational Staff General Administration School Administration Business Central Total Support Services Community Services Nonprogrammed Charges Payments to other Districts Debt Service Principal Interest and Other Charges Capital Outlay Total Expenditures
2,794,824 3,291,824 1,777,618 2,154,982 1,008,448 944,128 $ 11,971,825 220,721
-
3,780,483 $ 3,780,483 -
$
-
$
1,595,817 $ 1,595,817 -
$
$
$
391,229 353,369 13,799 16,943 6,414 781,754
70,906 81,251 43,903 143,579 84,685 195,496 619,821 -
$
$
$
-
-
$
$
$
-
500,000 500,000 -
$
$
$
2,655,326 3,168,174 1,425,205 2,161,804 6,926,624 1,069,157 $ 17,406,291 195,146
639,000
-
-
-
-
-
-
639,000
491,975
1,290,925
1,982,040
-
-
390,000 724,308 -
750,000
1,109,000
390,000 724,308 5,131,965
353,312 808,388 4,954,493
$ 42,982,452
$ 5,762,523
$ 1,595,817
$ 1,401,575
$ 1,114,308
$ 1,250,000
$ 1,109,000
$ 55,215,673
$ 52,045,744
45
FY 2017‐18 Budget Total Governmental Funds 2%
2%
2%
3%
Expenditures
3% 3%
2% 2% 2%
10% 11% Educational O&M Transportation
Revenue
IMRF/SS Debt Service Construction Fire Safety
80%
78%
46
Deerfield Public Schools District 109 Statement of Revenue, Expenditures and Change in Fund Balance Total Governmental Funds FY 2017-18 Budget
Budget 2013-14
Revenue: Local Sources State Sources Federal Sources Other Total Revenue
$
2014-15
50,763,661 2,205,813 640,758 53,610,232
$ 50,905,521 2,295,162 636,969 53,837,652
$ 31,012,283 5,457,678 5,335,122 2,182,829 7,396,372 1,042,897 2,299,877 $ 54,727,058
2015-16
% chg 0% 4% -1% n/a 0%
$ 51,267,935 2,225,832 724,257 54,218,024
% chg 1%
2016-17 Actual (Unaudited) $
2017-18
% chg
52,126,490 2,254,650 771,017 26,952.06 55,179,108
2%
2%
$
30,673,236 6,202,897 6,702,951 1,702,959 4,954,493 647,509 1,161,700 52,045,744
$
3,133,364
$
(177,240)
$
-
$
11,000,000 (11,000,000) -
$
(177,240)
-3% 14% n/a 1%
1% 6% n/a 2%
$ 52,182,534 2,212,900 643,000 55,038,434
% chg 0% -2% -17% -100% 0%
Expenditures: Salaries Employee Benefits Purchased Services Supplies Capital Outlay Tuition Other Total Expenditures
$
$
30,438,637 5,514,488 9,209,082 1,979,153 10,601,541 1,232,655 3,604,688 62,580,244
Excess (Deficiency) of Revenue over (under) Expenditures
$
(8,970,012)
$
$
8,975,000 558,314 15,131,450 (18,200,104) -
$
2% -1% -42% 10% -30% -15% -36% -13%
(889,406)
$ 30,196,122 6,198,036 7,557,567 1,833,791 5,726,645 705,462 1,316,245 $ 53,533,867
$
684,157
$
3,000,000 (203,332)
-3%
$
14% 42% -16% -23% -32% -43% -2%
0% -11% -7% -13% -8% -12% -3%
$ 31,696,357 7,594,858 6,501,528 2,364,998 5,131,965 736,000 1,189,968 $ 55,215,673
3% 22% -3% 39% 4% 14% 2% 6%
Other financing Sources (Uses): Proceeds from Bond Issues Bond Issuance Costs Transfers In Transfers Out Other
10,500,000 15,131,450 (12,331,554) (3,075,660)
-100% 1781% 0% -32%
Change in Fund Balance
$
(2,505,352)
$ 6,534,934
Beginning Fund Balance
$
22,269,129
$ 19,763,777
-11%
$ 26,298,711
Projected Ending Fund Balance $
19,763,777
$ 26,298,711
33%
$ 26,779,536
Fund Balance as % of Expenditures Fund Balance in Months of Expenditures
$
-100% -80% -100% -93%
480,825
-100% -100%
$
3,133,364
33%
$
26,779,536
2%
22,881,700
-15%
2%
$
29,912,900
12%
$ 22,704,460
-24%
32%
48%
50%
57%
41%
3.8
5.8
6.0
6.9
4.9
47
Deerfield Public Schools District 109 Statement of Revenue, Expenditures and Change in Fund Balance Total Government Funds FY 2017-18 Budget
Budget
2013-14
2014-15
$ 48,897,718 540,322 357,097 105,475 66,876 31,876 243,400 375,914 61,960 83,023 $ 50,763,661
$ 49,047,283 527,327 222,387 139,186 63,884 27,225 253,160 349,386 76,731 198,952 $ 50,905,521
$
$
Revenue: Local Sources Real Estate Taxes Replacement Taxes Earnings on Investments Tuition Transportation Fees Food Service Fees Pupil Activity Fees Textbook Fees Rentals Other Local Total Local Revenue State Sources General State Aid Special Education Bilingual Gifted Free Lunch Reading Improvement Other State Total State Sources Federal Sources Special Ed Food Service Title I - Low Income Title IV - Safe & Drug Free Schools Other Federal Total Federal Sources Total Revenue
630,006 1,325,653 250,154 $ 2,205,813
616,096 1,280,298 398,768 $ 2,295,162
$
$
$
417,975 19,401 152,191 51,191 640,758
$
411,292 15,047 128,531 51,191 636,969
2015-16
% chg
0% -2% -38% 32% -4% -15% 4% -7% 24% 140% 0%
$ 48,899,521 482,758 165,985 865,025 70,815 30,525 187,281 327,534 110,610 127,882 $ 51,267,935
618,635 1,300,088 59% 307,109 4% $ 2,225,832 -2%
$
-3%
-2%
$
-22% -16% 0% -1%
$
556,238 23,690 103,663 724,256 724,257
$ 53,610,232
$ 53,837,652
0%
$ 54,218,024
Instruction: $ 21,130,853 Regular Programs Special Education 5,775,632 Educationally Deprived/Remedial Interscholastic 335,358 Gifted 1,012,140 Summer School 101,388 Total Instruction $ 28,355,371
$ 20,854,899 5,939,080 372,567 879,666 112,628 $ 28,158,840
-1%
$ 19,600,995 6,538,902 411,328 973,118 127,276 $ 27,651,619
% chg
2016-17 Actual (Unaudited) (6/30/17)
1%
$ 49,534,416 448,947 538,166 819,400 81,309 29,103 187,281 327,534 45,565 (34,438) $ 52,153,442
0%
$
0% -8% -25% 521% 11% 12% -26% -6% 44% -36%
2%
-23% -3%
$
35%
$
57% -19% 1315% 14%
$
673,585 1,293,130 287,935 2,254,650
622,668 15,929 59,061 73,359 771,017
2017-18
% chg
1% -7% 224% -5% 15% -5% 0% 0% -59% -127% 2%
$ 50,139,534 460,000 391,500 500,000 70,000 35,000 116,000 345,000 100,000 25,500 $ 52,182,534
630,000 1,340,500 -6% 2,400 1% $ 2,212,900 9%
$
-1%
1% 2% -27% -39% -14% 20% -38% 5% 119% -174% 0%
-6% 4%
-99% -2%
-18%
6%
$
507,500 22,500 72,000 41,000 643,000
12%
$
% chg
-33% -43% -90%
41% 22% -44% -17%
1%
$ 55,179,108
2%
$ 55,038,434
0%
-6%
$ 19,474,163 6,833,702 402,223 996,432 129,619 $ 27,836,138
0%
$ 20,687,325 7,418,679 384,599 1,043,292 107,839 $ 29,641,735
6%
Expenditures:
Supporting Services Pupils Educational Staff General Administration School Administration Business Central Total Support Services Community Services Nonprogrammed Charges Payments to other Districts Debt Service Principal Interest and Other Charges Capital Outlay Total Expenditures
$ 2,576,590 2,201,985 1,185,840 1,970,195 9,610,589 1,297,162 $ 18,842,361 133,606 -
$ 2,763,697 2,565,775 1,302,759 1,999,447 6,148,102 1,460,053 $ 15,699,682 160,296
3% 11% -13% 11% -1%
7% 17% 10% 1% -36% 13% -17% 20%
1,011,991
$ 2,632,714 2,946,071 1,492,556 2,142,389 7,497,648 1,374,896 $ 17,829,604 186,349
11% 13% -2%
2,655,326 3,168,174 15% 1,425,205 7% 2,161,804 22% 6,926,624 -6% 1,069,157 14% $ 17,279,036 16% 195,146 -5%
$
15%
-2% 2% 2% 1%
-10%
6%
-22% -3%
-24%
-23%
353,312 808,388 4,954,493
-13%
390,000 724,308 5,131,965
-2%
$ 52,045,744
-3%
$ 55,215,673
-20%
$ 62,580,244
$ 54,727,058
-13%
$ 53,533,867
6%
30%
1% -8%
-73% 42%
5% -17%
639,000
-5%
-13%
462,226 854,018 5,726,645
-4%
5%
8%
491,975
-39%
9%
$ 2,865,730 3,373,075 1,821,521 2,298,561 6,969,432 1,139,624 $ 18,467,945 220,721
1%
-44%
1,696,637 603,240 7,396,372
48
10%
5%
566,734
2,765,390 707,848 9,224,348
-15%
10%
-5%
$ $
8% 6% 28% 6% 1% 7% 7% 13%
10% 4%
Total Governmental Funds 2017‐2018 Budget Revenue by Source Other, 0.2% Interest, 0.7%
State, 4.0%
Expenditures by Object Federal, 1.2%
Tuition, 1%
Other, 2%
Capital Outlay, 9%
Tuition & Fees, 1.9%
Supplies, 4%
Purchased Services, 12%
Employee Benefits, 14%
Salaries, 58%
Taxes, 91.9%
The overwhelming majority of funding for Deerfield Public Schools 109 comes from local property taxes levied upon residential and commercial landowners. Grants and other funds from the State of Illinois and the Federal Government account for only about 5% of District 109 operating revenues.
Approximately two‐thirds of all District 109 expenditures fund employee salaries and benefits. Purchased services include costs associated with outsourced custodial, technology and transportation services. Tuition costs are largely comprised of tuition charged by the regional special education cooperative of which District 109 is a member.
49
Total Governmental Funds Historical Revenues vs. Expenditures $70,000,000
$60,000,000
$50,000,000
$40,000,000
Revenue
$30,000,000
Expenditure Excess / (Deficiency) $20,000,000
Ending Fund Balance
$10,000,000
$‐ 2013‐14
2014‐15
2015‐16
2016‐17 Actual (Unaudited) (6/30/17)
$(10,000,000)
$(20,000,000)
50
2017‐18 Budget
Deerfield Public Schools District 109 Statement of Revenue, Expenditures and Change in Fund Balance Educational Fund by Function FY 2017-18 Budget
Actual
Actual
2013-14
2014-15
Local Sources Real Estate Taxes Replacement Taxes Earnings on Investments Tuition Transportation Fees Food Service Fees Pupil Activity Fees Textbook Fees Rentals Other Local Total Local Revenue
$ 36,425,344 183,995 105,475 31,876 243,400 375,914 83,023 $ 37,449,027
$ 39,306,532 191,078 139,186 27,225 253,160 349,386 46,717 $ 40,313,284
State Sources General State Aid Special Education Bilingual Gifted Free Lunch Reading Improvement Other State Total State Sources
$ $ 1,325,653 $ $ $ 2,278 $ 1,327,931
$ $ 1,280,298 $ $ $ 82,137 $ 1,362,435
$
$
Revenue:
Federal Sources Special Ed Food Service Title I - Low Income Title IV - Safe & Drug Free Schools Other Federal Total Federal Sources Total Revenue
$
417,975 19,401 152,191 51,191 640,758
$
411,292 15,047 128,531 82,099 636,969
Actual 2015-16
% chg
8% 4% 32% -15% 4% -7% -44% 8%
$ 39,737,272 138,234 865,025 30,525 187,281 327,534 52,222 $ 41,338,092
$ $ 1,300,088 $ $ $ 3506% 1,816 3% $ 1,301,905 -3%
-2%
$
-22% -16% 60% -1%
$
556,238 23,690 103,663 724,256 724,257
$ 39,417,716
$ 42,312,688
7%
$ 43,364,254
Instruction: $ 20,861,495 Regular Programs Special Education 5,532,340 Educationally Deprived/Remedia Interscholastic 325,857 Gifted 1,000,475 Summer School 96,972 Total Instruction $ 27,817,139
$ 20,548,530 5,662,359 361,761 866,398 107,605 $ 27,546,653
-2%
$ 19,322,592 6,287,441 401,508 961,061 122,712 $ 27,095,315
Budget % chg
1%
2016-17 Actual (Unaudited)
$
-28% 521% 12% -26% -6% 12% 3%
2%
$
$ $ $ $ $
-98% -4%
$
35%
$
39,787,639 408,286 819,400 29,103 376,862 314,109 (119,198) 41,616,202
1,293,130 1,293,130
2017-18
% chg
0% 195% -5% -5% 101% -4% -328% 1%
$ 40,565,632 300,000 500,000 35,000 116,000 345,000 25,500 $ 41,887,132
$ $ 1,340,500 $ $ $ -100% 2,400 -1% $ 1,342,900 -1%
2% -27% -39% 20% -69% 10% -121% 1%
4%
4%
14%
$
622,668 15,929 59,061 73,359 771,017
2%
$
43,680,348
1%
$ 43,873,032
0%
-6%
$ $
19,173,320 6,561,973 391,612 983,403 124,687 27,234,995
-1%
$ 20,296,096 $ 7,065,310 370,800 1,026,349 101,425 $ 28,859,981
6%
2%
16%
2,603,841 3,109,176 1,393,327 2,057,549 992,685 927,205 11,083,783 195,146
57% -19% 782%
-18%
6%
$
507,500 22,500 72,000 41,000 643,000
12%
$
% chg
-33% -43% -90%
41% 22% -44% -17%
Expenditures:
Supporting Services Pupils Educational Staff General Administration School Administration Business Central Total Support Services Community Services Nonprogrammed Charges Payments to other Districts Debt Service Principal Interest and Other Charges Capital Outlay Total Expenditures
$ 2,530,645 2,149,337 1,157,392 1,877,161 890,690 1,170,487 $ 9,775,712 133,606
$ 2,722,605 2,518,688 1,277,316 1,916,239 918,250 1,346,758 $ 10,699,856 160,296
1,174,127
2% 11% -13% 11% -1%
11% 11% 11% 14% -2%
$
-6%
$
20%
$ 2,557,028 2,859,343 1,445,693 1,989,131 939,112 1,166,221 $ 10,956,527 186,349
1,011,991
-14%
566,734
-44%
1,377,193
610,122
-56%
1,664,111
173%
$ 40,277,777
$ 40,028,918
-1%
$ 40,469,036
1%
8% 17% 10% 2% 3% 15% 9%
51
14% 13% 4% 2% -13% 2%
$
$
4% -2% 2% 2% 1%
8% -5% 4% -19% 6%
5%
$ 2,794,824 3,291,824 1,777,618 2,154,982 1,008,448 944,128 $ 11,971,825 220,721
491,975
-13%
639,000
30%
1,186,079
-29%
1,290,925
9%
40,191,978
-1%
$ 42,982,452
7%
9% -4% 3% 6% -20% 1%
7% 6% 28% 5% 2% 2% 8% 13%
Educational Fund Historical Revenues vs. Expenditures $50,000,000
$40,000,000
$30,000,000 Revenue Expenditures & Transfers $20,000,000
Excess / (Deficiency) Ending Fund Balance
$10,000,000
$‐ 2013‐14 Actual
2014‐15 Actual
2015‐16 Actual
2016‐17 Actual (Unaudited) (6/30/17)
$(10,000,000)
52
2017‐18 Budget
Deerfield Public Schools District 109 Statement of Revenue, Expenditures and Change in Fund Balance Educational Fund by Object FY 2017-18 Budget
Actual
Actual
Actual
2013-14
2014-15
$ 37,449,027 1,327,931 640,758 $ 39,417,716
$ 40,313,284 1,362,435 636,969 $ 42,312,688
Salaries Employee Benefits Purchased Services Supplies Capital Outlay Tuition Other Total Expenditures
$ 29,815,478 4,442,559 2,357,374 1,052,518 1,377,193 1,232,655 $ 40,277,777
$ 30,308,738 4,392,596 2,385,567 1,288,998 610,122 1,042,897 $ 40,028,918
Excess (Deficiency) of Revenue over (under) Expenditures
$
(860,061)
$ 2,283,770
$ 2,895,218
$ 3,488,370
$
$
(6,000,000)
$
$
$
$
Revenue: Local Sources State Sources Federal Sources Other Total Revenue
2015-16
Budget 2016-17 Actual (Unaudited)
% chg 8% 3% -1% 7%
$ 41,338,092 1,301,905 724,257 $ 43,364,254
% chg 3% -4% 14% 2%
$ 41,616,202 1,293,130 771,017 $ 43,680,348
2017-18
% chg 1% -1% 6% 1%
$ 41,887,132 1,342,900 643,000 $ 43,873,032
% chg 1% 4% -17% 0%
Expenditures: 2% -1% 1% 22% -56% -15% -1%
$ 29,525,785 4,894,644 2,604,189 1,074,845 1,664,111 705,462 $ 40,469,036
-3% 11% 9% -17% 173% -32% 1%
$ 30,027,871 5,063,668 2,406,832 860,020 1,186,079 647,509 $ 40,191,978
2% 3% -8% -20% -29% -8% -1%
$ 31,001,864 6,077,936 2,540,128 1,335,598 1,290,925 736,000 $ 42,982,452
3% 20% 6% 55% 9% 14% 7%
890,580
Other financing Sources (Uses): Proceeds from Bond Issues Bond Issuance Costs Transfers In Transfers Out Other
(3,000,000) -
-50%
-
-100%
$
Beginning Fund Balance
$ 17,226,655
$ 10,366,594
-40%
$ 9,650,364
-7%
$ 12,417,910
29%
$ 12,259,760
-1%
Projected Ending Fund Balance
$ 10,366,594
$ 9,650,364
-7%
$ 12,417,910
29%
$ 15,906,280
28%
$ 10,150,340
-36%
26%
24%
31%
40%
24%
3.1
2.9
3.7
4.7
2.8
53
$ 3,488,370
-100%
$ (6,860,061)
Fund Balance in Months of Expenditures
$ 2,767,546
-100%
(3,000,000) -
Change in Fund Balance
Fund Balance as % of Expenditures
(716,230)
(127,672)
$ (2,109,420)
Deerfield Public Schools District 109 Statement of Revenue, Expenditures and Change in Fund Balance Operation & Maintenance Fund by Function FY 2017-18 Budget
Actual
State Sources General State Aid Special Education Bilingual Gifted Free Lunch Reading Improvement Other State Total State Sources Federal Sources Special Ed Food Service Title I - Low Income Title IV - Safe & Drug Free Schools Other Federal Total Federal Sources Total Revenue
Actual
Budget
2013-14
2014-15
$ 7,393,263 53,827
$ 5,629,552 7,979
-24%
61,960 $ 7,509,050
76,731 75 $ 5,714,337
110,610 -24% $ 6,119,902
$
$
Revenue: Local Sources Real Estate Taxes Replacement Taxes Earnings on Investments Tuition Transportation Fees Food Service Fees Pupil Activity Fees Textbook Fees Rentals Other Local Total Local Revenue
Actual
-
$
$
-
$
$ 7,509,050
$
24%
$
$ 5,714,337
6%
$
$
80%
44% -100% 7%
-
$
-
$
% chg
$ 5,994,921 -85% 14,371
-
$
2015-16
% chg
2016-17 Actual (Unaudited)
$
$ 6,014,879 283% 15,000
45,565 6,161,614
-59%
$
$ $
6,161,614
-
$
-
-17% 4,366,008 -17% $ 4,366,008 -
$
-24%
$ 6,119,902
$
7%
1%
100,000 1% $ 6,129,879
-
-
$
% chg
6,060,976 55,073
$
-
2017-18
% chg
$
$
$
$ 1%
-1% -73%
119% -1%
-
-
$ 6,129,879
-1%
Expenditures: Instruction: $ Regular Programs Special Education Educationally Deprived/Remedial Interscholastic Gifted Summer School Total Instruction $ Supporting Services Pupils Educational Staff General Administration School Administration Business Central Total Support Services Community Services Nonprogrammed Charges Payments to other Districts Debt Service Principal Interest and Other Charges Capital Outlay Total Expenditures
-
$
-
$
3,270,665 $ 3,270,665 -
$
$
-
-
$
-
$
2,730,513 $ 2,730,513 -
$
-
-
60% 60%
$
-
1,414,928
3,190,494
125%
1,027,348
$ 4,685,593
$ 5,921,007
26%
$ 5,393,356
54
$
$
4,331,519
-1%
4,331,519
-1%
-
-68% -9%
$
1,193,535 5,525,054
-
3,780,483 $ 3,780,483 -
-13% -13%
-
16%
1,982,040
66%
2%
$ 5,762,523
4%
Operations & Maintenance Fund Historical Revenues vs. Expenditures $12,000,000
$10,000,000
$8,000,000
$6,000,000
Revenue
$4,000,000
Expenditures & Transfers Excess / (Deficiency) $2,000,000
Ending Fund Balance
$‐ 2013‐14 Actual
2014‐15 Actual
2015‐16 Actual
2016‐17 Actual (Unaudited) (6/30/17)
$(2,000,000)
$(4,000,000)
$(6,000,000)
55
2017‐18 Budget
Note: Deficit due to transfer of funds to Capital Projects fund.
92 Deerfield Public Schools District 109 Statement of Revenue, Expenditures and Change in Fund Balance Operation & Maintenance Fund by Object FY 2017-18 Budget
Actual
2013-14
2014-15
$ 7,509,050 $ 7,509,050
$ 5,714,337 $ 5,714,337
$
604,482 129,134 1,480,179 925,420 1,414,928 131,450 $ 4,685,593
$
$ 2,823,457
$
(206,670)
$
$
2,800,000 3,000,000 (3,075,660)
Revenue: Local Sources State Sources Federal Sources Other Total Revenue
Actual
Actual
2015-16
% chg -24%
-24%
Budget
% chg
$ 6,119,902 $ 6,119,902
7%
7%
2016-17 Actual (Unaudited) $ 6,161,614 $ 6,161,614
2017-18
% chg 1%
1%
$ 6,129,879 $ 6,129,879
% chg -1%
-1%
Expenditures: Salaries Employee Benefits Purchased Services Supplies Capital Outlay Tuition Other Total Expenditures
Excess (Deficiency) of Revenue over (under) Expenditures
666,690 87,415 1,082,817 893,591 3,190,494 $ 5,921,007
10% -32% -27% -3% 125% 100% 26%
$
641,089 80,072 2,888,587 756,261 1,027,348 $ 5,393,356
$
-4% -8% 167% -15% -68%
-9%
726,546
$
615,465 85,362 2,787,753 842,939 1,193,535 $ 5,525,054
$
-4% 7% -3% 11% 16%
2%
$
655,101 107,422 1,912,900 1,029,400 1,982,040 75,660 $ 5,762,523
636,560
$
-
$
6% 26% -31% 22% 66%
4%
367,356
Other financing Sources (Uses): Proceeds from Bond Issues Bond Issuance Costs Transfers In Transfers Out Other
6,000,000 (9,000,000)
-100%
-
-50%
-100%
-100%
(75,660) $
Beginning Fund Balance
$ 2,287,924
$ 2,111,381
-8%
$ 4,629,051
119%
$ 5,279,937
14%
$ 5,809,950
10%
Projected Ending Fund Balance
$ 2,111,381
$ 4,629,051
119%
$ 5,279,937
14%
$ 5,916,497
12%
$ 1,177,306
-80%
45%
78%
98%
107%
20%
5.4
9.4
11.7
12.9
2.5
56
650,886
$
-100%
$
Fund Balance in Months of Expenditures
$ 2,517,670
-98%
3,000,000 (8,000,000)
Change in Fund Balance
Fund Balance as % of Expenditures
(176,543)
-
636,560
$ (4,632,644)
Deerfield Public Schools District 109 Statement of Revenue, Expenditures and Change in Fund Balance Transportation Fund by Function FY 2017-18 Budget
Actual
State Sources General State Aid Special Education Bilingual Gifted Free Lunch Reading Improvement Other State Total State Sources Federal Sources Special Ed Food Service Title I - Low Income Title IV - Safe & Drug Free Schools Other Federal Total Federal Sources Total Revenue
Actual
2013-14
2014-15
$ 1,006,806 34,750 66,876 $ 1,108,432
$ 1,002,625 7,400 63,884 $ 1,073,909
$
$
Revenue: Local Sources Real Estate Taxes Replacement Taxes Earnings on Investments Tuition Transportation Fees Food Service Fees Pupil Activity Fees Textbook Fees Rentals Other Local Total Local Revenue
Actual
$
$
$
247,876 247,876
-
$ 1,356,308
$
$
$
2015-16
% chg
316,631 316,631
% chg
$ 1,067,809 -79% 4,025 -4% 70,815 -3% $ 1,142,648 0%
$
28% 28%
-
$ 1,390,540
Budget
$
$
$ 3%
305,293 305,293
7%
$
-46% 11%
6%
$
$
-4% -4%
-
$ 1,447,941
2016-17 Actual (Unaudited)
$
$
4%
1,368,404 11,164 81,309 1,460,877
287,935 287,935
$
-
$
1,748,812
$
-
2017-18
% chg
% chg
$ 1,320,648 177% 12,000 15% 70,000 28% $ 1,402,648 28%
$
-6% -6%
$
$
$ 21%
-3% 7% -14%
-4%
0% -100% 240,000 -17%
-
$ 1,642,648
-6%
Expenditures: Instruction: $ Regular Programs Special Education Educationally Deprived/Remedial Interscholastic Gifted Summer School Total Instruction $ Supporting Services Pupils Educational Staff General Administration School Administration Business Central Total Support Services Community Services Nonprogrammed Charges Payments to other Districts Debt Service Principal Interest and Other Charges Capital Outlay Total Expenditures
-
$
$
$
-
$
$
$
-
$
$
1,461,308 $ 1,461,308 -
9% 1,417,544 9% $ 1,417,544 -
-
-
-
-
-
-
-
-
-
-
$ 1,342,689
$ 1,461,308
57
$ 1,417,544
-3% -3%
-3%
$
$
1,395,198
$
1,395,198 -
1,395,198
$
-
1,342,689 $ 1,342,689 -
9%
$
$
-2% -2%
-2%
1,595,817
$ 1,595,817 -
$ 1,595,817
14% 14%
14%
Transportation Fund Revenues & Expenses 2,000,000
Revenue has declined by almost 25% in the last 5 years, while costs have increased.
1,500,000
Revenue Transportation Cost 1,000,000
500,000 2013‐14 Actual
2014‐15 Actual
2015‐16 Actual
2016‐17 Actual (Unaudited) (6/30/17)
2017‐18 Budget
Transportation Funding Source History 100%
3% 5%
1% 5%
0% 5%
18%
23%
21%
1% 5%
1% 5% 0%
16%
80%
60% Other 94%
Student Fees State Funding
40%
Local Taxes
78%
74%
72%
74%
2013‐14 Actual
2014‐15 Actual
2015‐16 Actual
20%
0% 2016‐17 Actual (Unaudited) (6/30/17)
Declining State Funding has been replaced by Local taxes Student Fees have remained constant at ~6% Source:
Annual Financial Reports 2014 through 2016, 2017 District Records, 2018 Budget
58
2017‐18 Budget
Deerfield Public Schools District 109 Statement of Revenue, Expenditures and Change in Fund Balance Transportation Fund by Object FY 2017-18 Budget
Actual
Actual
2013-14
2014-15
$ 1,108,432 247,876 $ 1,356,308
$ 1,073,909 316,631 $ 1,390,540
$
$
Revenue: Local Sources State Sources Federal Sources Other Total Revenue
Actual
2015-16
% chg -3% 28%
3%
Budget
% chg
$ 1,142,648 305,293 $ 1,447,941
6% -4%
4%
2016-17 Actual (Unaudited) $ 1,460,877 287,935 $ 1,748,812
2017-18
% chg 28% -6%
21%
% chg
$ 1,402,648 240,000 $ 1,642,648
-4% -17%
-6%
Expenditures: Salaries Employee Benefits Purchased Services Supplies Capital Outlay Tuition Other Total Expenditures
18,677 2,940 1,319,857 1,215 $ 1,342,689
36,855 6,277 1,417,936 240 $ 1,461,308
Excess (Deficiency) of Revenue over (under) Expenditures
$
13,619
$
$
-
$
Change in Fund Balance
$
13,619
$
Beginning Fund Balance
$ 1,096,194
$ 1,109,813
1%
$ 1,039,045
-6%
$ 1,069,442
3%
$ 1,207,108
13%
Projected Ending Fund Balance
$ 1,109,813
$ 1,039,045
-6%
$ 1,069,442
3%
$ 1,423,056
33%
$ 1,253,939
-12%
83%
71%
75%
102%
79%
9.9
8.5
9.1
12.2
9.4
97% 114% 7% -80%
9%
(70,768)
$
29,248 5,411 1,380,201 2,685 $ 1,417,544
-21% -14% -3% 1019%
-3%
$
29,900 2,663 1,362,635 $ 1,395,198
2% -51% -1% -100%
-2%
$
39,392 7,924 1,548,500 $ 1,595,817
$
30,397
$
353,614
$
46,831
$
-
$
-
$
-
$
30,397
$
353,614
$
46,831
32% 198% 14%
14%
Other financing Sources (Uses): Proceeds from Bond Issues Bond Issuance Costs Transfers In Transfers Out Other
Fund Balance as % of Expenditures Fund Balance in Months of Expenditures
(70,768)
59
Deerfield Public Schools District 109 Statement of Revenue, Expenditures and Change in Fund Balance Municipal Retirement / Social Security Fund by Function FY 2017-18 Budget
Actual 2013-14
Revenue: Local Sources Real Estate Taxes Replacement Taxes Earnings on Investments Tuition Transportation Fees Food Service Fees Pupil Activity Fees Textbook Fees Rentals Other Local Total Local Revenue State Sources General State Aid Special Education Bilingual Gifted Free Lunch Reading Improvement Other State Total State Sources Federal Sources Special Ed Food Service Title I - Low Income Title IV - Safe & Drug Free Schools Other Federal Total Federal Sources
Actual
$
$
2014-15
886,590 100,000 7,044 993,634
$
-
$
$
$
$
% chg
$ 1,022,050 100,000 -48% 1,627 7% $ 1,123,677 8%
6%
0%
0%
-
$
2015-16
% chg
959,837 100,000 3,691 $ 1,063,528
Budget
$
-
6%
-
$
$
1,215,235 100,000 7,379 1,322,614
$
$
993,634
$ 1,063,528
7%
$ 1,123,677
6%
Instruction: Regular Programs Special Education Educationally Deprived/Remedial Interscholastic Gifted Summer School Total Instruction $
269,358 243,292 9,501 11,665 4,416 538,232
14%
$
278,402 251,461 9,820 12,057 4,564 556,304
-9%
$
306,369 276,721 10,806 13,268 5,023 612,187
-11%
$
75,686 86,728 46,863 153,258 90,393 208,675 661,605
84%
$
41,092 47,087 25,443 83,208 49,077 113,295 359,203
2017-18
% chg
% chg
$ 1,131,746 100,000 353% 7,500 18% $ 1,239,246 19%
-7%
0%
0%
-
$
-
$
$
$
$
$
$
2016-17 Actual (Unaudited)
-56%
-
Total Revenue
$
Actual
$
2%
-6%
-
$
$
-
$
-
$
1,322,614
18%
$ 1,239,246
-6%
0%
$
391,229 353,369 13,799 16,943 6,414 781,754
30%
$
300,842 271,729 10,611 13,029 4,932 601,144
-32%
$
70,906 81,251 43,903 143,579 84,685 195,496 619,821
38%
$
51,486 58,997 31,879 104,255 61,491 141,952 450,061
$
-
$
Expenditures:
Supporting Services Pupils Educational Staff General Administration School Administration Business Central Total Support Services Community Services Nonprogrammed Charges Payments to other Districts Debt Service Principal Interest and Other Charges Capital Outlay Total Expenditures
$
$
45,945 52,648 28,448 93,034 54,873 126,675 401,623
14% 14% 14% 14% 14%
-11% -11% -11% -11% -11% -11%
-9% -9% -9% -9% -9%
84% 84% 84% 84% 84% 84%
-
-
-
-
-
-
-
-
939,855
$
971,390
3%
60
$ 1,217,909
25%
$
1,051,205
8% 8% 8% 8% 8%
-32% -32% -32% -32% -32% -32%
30% 30% 30% 30% 30%
38% 38% 38% 38% 38% 38%
-14%
$ 1,401,575
33%
Deerfield Public Schools District 109 Statement of Revenue, Expenditures and Change in Fund Balance Municipal Retirement / Social Security Fund by Object FY 2017-18 Budget
Actual
Actual
2013-14
Revenue: Local Sources State Sources Federal Sources Other Total Revenue
$
Actual
2014-15
2015-16
% chg
993,634 993,634
$ 1,063,528 $ 1,063,528
$
$
939,855 939,855
$
971,390 971,390
$
53,779
$
92,138
$
$
-
$
-
$
$
7%
7%
Budget
% chg
$ 1,123,677 $ 1,123,677
6%
6%
2016-17 Actual (Unaudited) $ 1,322,614 $ 1,322,614
2017-18
% chg 18%
18%
% chg
$ 1,239,246 $ 1,239,246
-6%
-6%
Expenditures: Salaries Employee Benefits Purchased Services Supplies Capital Outlay Tuition Other Total Expenditures
Excess (Deficiency) of Revenue over (under) Expenditures
$
$
3%
3%
1,217,909 $ 1,217,909
$
25%
25%
(94,232)
1,051,205 $ 1,051,205
$
-14%
-14%
1,401,575 $ 1,401,575
$
271,409
$
$
-
$
$
271,409
$
(162,329)
33%
33%
(162,329)
Other financing Sources (Uses): Proceeds from Bond Issues Bond Issuance Costs Transfers In Transfers Out Other
-
Change in Fund Balance
$
53,779
$
92,138
Beginning Fund Balance
$
473,713
$
527,492
Projected Ending Fund Balance
$
527,492
$
619,630
Fund Balance as % of Expenditures Fund Balance in Months of Expenditures
-
-
$
(94,232)
11%
$
619,630
17%
$
525,398
-15%
$
669,996
28%
17%
$
525,398
-15%
$
796,807
52%
$
507,667
-36%
56%
64%
43%
76%
36%
6.7
7.7
5.2
9.1
4.3
61
Deerfield Public Schools District 109 Statement of Revenue, Expenditures and Change in Fund Balance Debt Service Fund by Function FY 2017-18 Budget
Actual 2013-14
Revenue: Local Sources Real Estate Taxes Replacement Taxes Earnings on Investments Tuition Transportation Fees Food Service Fees Pupil Activity Fees Textbook Fees Rentals Other Local Total Local Revenue State Sources General State Aid Special Education Bilingual Gifted Free Lunch Reading Improvement Other State Total State Sources Federal Sources Special Ed Food Service Title I - Low Income Title IV - Safe & Drug Free Schools Other Federal Total Federal Sources
Actual
$
$
$
$
2014-15
3,185,715 7,824 3,193,539
-
$
-
$
3,193,539
Instruction: $ Regular Programs Special Education Educationally Deprived/Remedia Interscholastic Gifted Summer School Total Instruction $
-
Total Revenue
$
Actual
$
$
$
$
2015-16
% chg
$ 2,148,737 5,134 75,660 $ 2,229,531
% chg
$ 1,077,469 -34% 2,417 75,660 -30% $ 1,155,547 -33%
-
$
$
-
$ 2,229,531
Budget
$
$ -30%
-50%
$
-53%
0% -48%
-
$
$
$
-
$ 1,155,547
2016-17 Actual (Unaudited)
$
-48%
1,102,163 11,130 75,660 1,188,952
$ $
1,188,952
$
-
% chg
$ 1,106,629 360% 12,000 0% 3% $ 1,118,629 2%
-
-
2017-18
% chg
$
$
$
$ 3%
0% 8%
-100% -6%
-
-
$ 1,118,629
-6%
Expenditures:
Supporting Services Pupils Educational Staff General Administration School Administration Business Central Total Support Services Community Services Nonprogrammed Charges Payments to other Districts Debt Service Principal Interest and Other Charges Capital Outlay Total Expenditures
$
$
-
$
$
$
$
-
$
$
-
$
$
-
-
$
-
$
$
-
$
$
-
$
$
-
-
$ $
2,765,390 707,848
$ 1,696,637 $ 603,240
-39%
$ $
462,226 854,018
-73% 42%
$ $
353,312 808,388
-24%
-15%
$
3,473,238
$ 2,299,877
-34%
$ 1,316,245
-43%
$
1,161,700
-12%
62
-
-5%
$ $
390,000 724,308
-10%
$ 1,114,308
-4%
10%
Deerfield Public Schools District 109 Statement of Revenue, Expenditures and Change in Fund Balance Debt Service Fund by Object FY 2017-18 Budget
Actual
Actual
Actual
2013-14
2014-15
$ 3,193,539 $ 3,193,539
$ 2,229,531 $ 2,229,531
$
3,473,238 $ 3,473,238
$
$
(279,699)
$
$ 3,025,000 343,185 131,450 (3,200,104)
$
Change in Fund Balance
$
$
Beginning Fund Balance
$ 1,028,777
$ 1,048,609
$ 1,048,609
$
Revenue: Local Sources State Sources Federal Sources Other Total Revenue
2015-16
% chg -30%
-30%
Budget
% chg
$ 1,155,547 $ 1,155,547
-48%
-48%
2016-17 Actual (Unaudited) $ 1,188,952 $ 1,188,952
2017-18
% chg 3%
3%
% chg
$ 1,118,629 $ 1,118,629
-6%
-6%
Expenditures: Salaries Employee Benefits Purchased Services Supplies Capital Outlay Tuition Other Total Expenditures
Excess (Deficiency) of Revenue over (under) Expenditures
2,299,877 $ 2,299,877
$
-34% -34%
(70,346)
1,316,245 $ 1,316,245
$
$
-43% -43%
(160,698)
1,161,700 $ 1,161,700
$
-12% -12%
1,114,308 $ 1,114,308
$
27,253
$
4,321
$
-
$
-
$
27,253
$
4,321
-4% -4%
Other financing Sources (Uses): Proceeds from Bond Issues Bond Issuance Costs Transfers In Transfers Out
Projected Ending Fund Balance Fund Balance as % of Expenditures Fund Balance in Months of Expenditures
19,832
-
-100%
$
-
-100% -100% -100%
(70,346)
978,263
$
(160,698)
2%
$
978,263
-7%
$
817,565
-16%
$
828,577
1%
-7%
$
817,565
-16%
$
844,818
3%
$
832,898
-1%
30%
43%
62%
73%
75%
3.6
5.1
7.5
8.7
9.0
63
Millions
Outstanding Bonded Debt $25.0
$20.0
$15.0 Series 2015 Series 2013
$10.0
Series 1999‐B
$5.0
$0.0 2017
2018
2019
2020
2021
2022
2023
2024
Year Ending June 30
Year
Ending June 30 2017 2018 2019 2020 2021 2022 2023 2024 Totals
Series 1999-B Ltd. Tax School Bonds $10,000,000 - Issued Jan 1, 1999 Partially Refunded: Mar 2010 Int Rate Principal Interest 6.60% 350,000 66,330 6.60% 390,000 41,910 6.60% 440,000 14,520 $ 1,180,000
$
122,760
Series 2013 Limited Tax Bonds $8,975,000 - Issued Sept. 23, 2013 Int Rate 3.90% 3.90% 3.90% 3.90% 3.90% 4.00% 4.00% 4.00%
Principal 825,000 885,000 945,000 1,005,000 1,060,000
Interest 350,750 350,750 350,750 338,375 308,300 271,700 232,700 191,400
$ 8,975,000
$ 2,708,225
Series 2015 Limited Tax Bonds $9,270,000 - Issued May 14, 2015
Total All Issues
-
Interest 315,648 315,648 315,648 315,648 315,648 315,648 315,648 315,648
Total Principal 350,000 390,000 440,000 825,000 885,000 945,000 1,005,000 1,060,000
Total Interest 732,728 708,308 680,918 654,023 623,948 587,348 548,348 507,048
Total Debt Service 1,082,728 1,098,308 1,120,918 1,479,023 1,508,948 1,532,348 1,553,348 1,567,048
$ 9,270,000
$ 5,010,018
19,425,000
7,841,003
$ 27,266,003
Amount Available in Debt Service Fund as of July 1, 2017 Amount to be Provided for Payment of General Long-Term Debt
$ 828,577 $ 26,437,426
Int Rate 2.70% 2.70% 2.70% 2.70% 2.70% 2.70% 2.70% 2.70%
Principal
Series 1999‐B were bonds used to finance additions and rennovations District‐wide.
Series 2013 were issued for state‐mandated Life Safety capital projects. Series 2015 partiall refunded 1999 and 2010 and were issued to help defray the cost of middle school science lab renovations. Note : During the fiscal years 1999,2001, and 2003, the District defeased certain bond issues by placing proceeds of the new bond issue in an irrevocable trust to provide for all future debt service payments on the old bonds. Accordingly, the trust account assets and the liability for the defeased bonds are not included above. On June 30, 2009 $11,715,000 of bonds outstanding are considered defeased.
64
Capital Project Fund The capital project fund is a non‐operating fund and maintained to pool financial resources for major capital projects. In FY18, no taxes will be levied to contribute to the capital projects fund balance. In 2007‐08 the District proactively began allocating General State Aid and, later, replacement taxes (which are a replacement of local revenue collected and disbursed by the state) to the Capital Projects fund instead of the Educational fund. This shift reduced the District’s reliance on these revenue sources in anticipation that they may diminish or be withdrawn in the future. As a result, extra resources have been available for numerous capital improvements in the past ten years and the District has minimized its exposure to the worsening state financial crisis. In fiscal years 2014 and 2015, the district replaced the entirety of the building HVAC systems and provided air conditioning to all instructional spaces at a cost of $15.41 million. Other projects completed during 2015 and 2016 amounted to $6.4 million and include items from the master facility plan and state‐mandated life safety work: roof replacement, automated lighting, improved casework, parking lot repairs, new playground, restroom renovations, generator installation at all buildings, new middle school science, technology, engineering and mathematics (STEM), and Creative Media Arts labs (CMA). In fiscal year 2017, projects included the renovation of middle school fine arts classrooms and renovations at the four elementary Library Media Centers which include space for Parent Teacher Organization (PTO) funded Creative Learning Systems SMART labs and roof replacement at Caruso Middle School. The 2018 fiscal year budget includes approximately $2 million to be spent on needed renovations and capital projects at the six school buildings, including new lockers and cabinetry, roof replacement and ADA accessibility modifications.
65
Deerfield Public Schools District 109 Statement of Revenue, Expenditures and Change in Fund Balance Capital Projects Fund by Function FY 2017-18 Budget
Actual 2013-14
Revenue: Local Sources Real Estate Taxes Replacement Taxes (1) Earnings on Investments Tuition Transportation Fees Food Service Fees Pupil Activity Fees Textbook Fees Rentals Other Local Total Local Revenue State Sources General State Aid (1) Special Education Bilingual Gifted Free Lunch Reading Improvement Other State Total State Sources Federal Sources Special Ed Food Service Title I - Low Income Title IV - Safe & Drug Free Schools Other Federal Total Federal Sources Total Revenue
Actual
$
$
$
$
$
$
Actual
2014-15
440,322 18,669 458,991
$
630,006 630,006
$
-
$
$ 1,088,997
$
$
$
2015-16
% chg
427,327 6,672 76,500 510,499
616,096 616,096
$ -3% -64%
11%
$
-2%
$
-2%
$
-
$ 1,126,595
$
$ 3%
Budget % chg
382,758 5,101 387,859
618,635 618,635
2016-17 Actual (Unaudited)
$ -10% -24%
-100% -24%
$
0%
$
0%
$
-
673,585 673,585
$ -9% 248%
-3%
$
9%
$
9%
$
$
-
$
1,049,382
-
$
-
$
684,591 684,591 -
$
145,731 145,731 -
$
$ 1,006,494
$
348,947 17,750 9,100 375,797
2017-18
% chg
-11%
$
$ 4%
% chg
360,000 20,000 380,000
630,000 630,000
3% 13%
-100% 1%
-6%
-6%
-
$ 1,010,000
-4%
Expenditures: Instruction: Regular Programs $ Special Education Educationally Deprived/Remedia Interscholastic Gifted Summer School Total Instruction $ Supporting Services Pupils Educational Staff General Administration School Administration Business Central Total Support Services Community Services Nonprogrammed Charges Payments to other Districts Debt Service Principal Interest and Other Charges Capital Outlay Total Expenditures (1)
-
$
4,051,672 $ 4,051,672 -
$
$
$
$
-
$
448,802 448,802 -
$
$
100% -89%
$
$
53% 53%
$
$
-79% -79%
$
-
500,000 500,000 -
243% 243%
-
-
-
-
-
$ 6,760,582
$ 1,742,172
-74%
$ 2,922,208
68%
$
2,323,398
-20%
$
750,000
-68%
$ 10,812,254
$ 2,190,974
-80%
$ 3,606,799
65%
$
2,469,129
-32%
$ 1,250,000
-49%
General State Aid and Replacement Taxes were proactively shifted to this fund from the Education Fund to reduced the District’s reliance on these revenue sources in anticipation that they may diminish or be withdrawn in the future.
66
Deerfield Public Schools District 109 Statement of Revenue, Expenditures and Change in Fund Balance Capital Projects Fund by Object FY 2017-18 Budget
Actual
Actual
2013-14
Revenue: Local Sources State Sources Federal Sources Other Total Revenue
$
Actual
2014-15
2015-16
% chg
$
Budget
% chg
458,991 630,006 $ 1,088,997
510,499 616,096 $ 1,126,595
$
4,051,672 6,760,582 $ 10,812,254
$
$ (9,723,257)
$ (1,064,379)
$ (2,600,305)
$
$
$
11% -2%
3%
$
387,859 618,635 $ 1,006,494
-24% 0%
-11%
2016-17 Actual (Unaudited) $
375,797 673,585 $ 1,049,382
2017-18
% chg -3%
$
9%
4%
$
380,000 630,000 1,010,000
% chg 1% -6%
-4%
Expenditures: Salaries Employee Benefits Purchased Services Supplies Capital Outlay Tuition Other Total Expenditures
Excess (Deficiency) of Revenue over (under) Expenditures
448,802 1,742,172 $ 2,190,974
$ -89% -74%
-80%
684,591 2,922,208 $ 3,606,799
$ 53% 68%
65%
145,731 2,323,398 $ 2,469,129
$ -79% -20%
-32%
$
500,000 750,000 1,250,000
$ (1,419,747)
$
$
$
8,000,000 -
$
7,760,000
243% -68%
-49%
(240,000)
Other financing Sources (Uses): Proceeds from Bond Issues Bond Issuance Costs Transfers In Transfers Out
9,000,000 -
Change in Fund Balance
$
(723,257)
Beginning Fund Balance
$
158,298
$
(564,959)
Projected Ending Fund Balance
7,700,000
-
-100%
$ 6,635,621 $
(564,959)
-
-100%
$ (2,600,305)
$ (1,419,747)
-457%
$ 6,070,662
-1175%
$ 3,470,357
-43%
$
904,882
-74%
$ 6,070,662
-1175%
$ 3,470,357
-43%
$ 2,050,611
-41%
$
8,664,882
323%
-5403%
96%
83%
693%
11.5
10.0
83.2
Fund Balance as % of Expenditures
-5%
277%
Fund Balance in Months of Expenditures
-0.6
33.2
67
Deerfield Public School District #109
Capital Budget Summary FY 2017-2018
By Spending Category Actual 2011-2012 ADA accessibility
$
Building Additions
-
Actual 2012-2013 $
-
Actual 2013-2014 $
-
Actual 2014-2015 $
-
Actual 2015-2016 $
Actual 2016-2017
-
Projected 2017-2018 $
-
Projected 2018-2019 $
-
Projected 2019-2020 $
-
Projected 2020-2021 $
-
1,090,975
-
-
-
-
-
-
-
-
-
165,206
35,090
63,405
120,714
-
18,000
121,970
52,400
25,000
25,000
Furniture & Equipment
-
42,905
219,506
210,500
304,200
477,900
-
250,000
275,000
250,000
Grounds
-
211,387
40,330
-
95,000
28,000
25,000
25,000
25,000
25,000
19,805
64,888
12,495,200
2,950,000
-
30,470
-
-
HVAC Equipment
-
-
-
-
-
-
-
1,005,000
-
Interior Renovations
-
-
695,650
1,026,600
240,000
3,392,100
1,000,000
750,000
-
-
Lighting/Electrical
-
45,869
-
193,000
-
35,000
150,000
125,000
-
-
Lockers/Cabinetry
-
-
-
415,000
31,100
1,000,000
Parking Lot/ Walks
336,833
596,106
-
397,959
12,500
543,000
20,000
20,000
20,000
-
-
-
-
-
-
50,000
-
-
391,100
-
-
906,294
46,000
500,000
459,000
150,000
-
-
Security
-
-
-
81,478
-
-
363,000
-
-
-
Middle School Sci Lab Rennov
-
-
-
2,676,000
5,200,000
-
-
-
-
-
237,570
332,803
-
517,992
-
450,000
-
125,000
-
425,000
30,209
-
-
-
25,000
25,000
25,000
25,000
25,000
-
-
46,620
-
27,000
-
85,000
-
-
$ 5,897,000
$ 5,109,287
Flooring
HVAC
Plumbing Roof
Technology/Communications Tuckpointing Vehicles Windows/Doors Total
109,305
-
-
$ 2,381,003
$ 1,329,048
$ 13,560,711
11,800
82,217 $ 9,495,537
$
-
75,000
47,500
47,500
47,500
3,734,470
$ 1,704,900
$ 1,422,500
47,500 $
892,500
* Vehicles are on a 5 year replacement cycle By Location Actual 2011-2012 Kipling
$
336,100
Actual 2012-2013 $
346,836
Budget 2013-2014 $
Projected 2014-2015
105,209
$ 2,807,778
Projected 2015-2016 $
268,725
Projected 2016-2017 $
506,265
Projected 2017-2018 $
464,555
Projected 2018-2019 $
399,000
Projected 2019-2020 $
122,620
Projected 2019-2020 $
305,600
South Park
112,504
151,749
4,606,250
307,300
144,705
407,752
494,760
180,500
336,980
98,050
Walden
117,603
140,480
203,641
1,705,905
46,625
402,100
470,370
190,000
176,360
89,650
Wilmot
226,805
90,480
3,863,905
32,500
92,925
588,300
967,985
368,500
92,040
135,000
Caruso
105,916
467,250
301,504
950,300
4,216,400
1,687,070
525,900
135,900
270,000
68,500
Shepard
391,100
95,480
4,433,582
2,933,920
1,090,050
1,402,300
654,000
169,100
424,500
125,700
District Wide Total
1,090,975
36,773
46,620
757,834
37,570
115,500
$ 2,381,003
$ 1,329,048
$ 13,560,711
$ 9,495,537
$ 5,897,000
$ 5,109,287
68
$
156,900
261,900
-
3,734,470
$ 1,704,900
$ 1,422,500
70,000 $
892,500
Deerfield Public Schools District 109 Statement of Revenue, Expenditures and Change in Fund Balance Fire Prevention & Safety Fund By Function FY 2017-18 Budget
Actual 2013-14
Revenue: Local Sources Real Estate Taxes Replacement Taxes Earnings on Investments Tuition Transportation Fees Food Service Fees Pupil Activity Fees Textbook Fees Rentals Other Local Total Local Revenue State Sources General State Aid Special Education Bilingual Gifted Food Service Reading Improvement Other State Total State Sources Federal Sources Special Ed Food Service Title I - Low Income Title IV - Safe & Drug Free Schools Other Federal Total Federal Sources
Actual
$
$
$
$
2014-15
50,988 50,988
-
$
$
$
$
$
433 433
$ -99%
-99%
-
$
$
-
$
50,988
$
433
Instruction: $ Regular Programs Special Education Educationally Deprived/Remedia Interscholastic Gifted Summer School Total Instruction $
-
$
-
$
Budget
2015-16
% chg
-
Total Revenue
$
Actual
$
$
$
$
% chg
210 210
$ $
210
-
$
-
$
-99%
$ -52%
-52%
-
-
2016-17 Actual (Unaudited)
$
$
$
$
27,385 27,385
$ $
27,385
-
$
-
$
-52%
$ 12964%
12964%
-
-
2017-18
% chg
$
$
$
$
% chg
25,000 25,000
-9%
-
$
-
$
25,000
-
$
-
-
$
12964%
-9%
-9%
Expenditures:
Suporting Services Pupils Educational Staff General Administration School Administration Business Central Total Support Services Community Services Nonprogrammed Charges Payments to other Districts Debt Service Principal Interest and Other Charges Capital Outliay Total Expenditures
$
$
$
$
$
$
$
$
$
$
-
-
-
-
-
-
1,048,838
1,853,584
77%
112,979
-94%
251,480
123%
1,109,000
341%
$ 1,048,838
$ 1,853,584
77%
112,979
-94%
251,480
123%
$ 1,109,000
341%
69
$
$
Deerfield Public Schools District 109 Statement of Revenue, Expenditures and Change in Fund Balance Fire Prevention & Safety Fund by Object FY 2017-18 Budget
Actual
2013-14
Revenue: Local Sources State Sources Federal Sources Other Total Revenue
Actual
$
Actual
2014-15 $
1,048,838 $ 1,048,838
$
1,853,584 $ 1,853,584
$
$ (1,853,151)
$
$
2015-16
% chg
50,988 50,988
433 433
Budget
-99%
$
-99%
$
% chg
210 210
2016-17 Actual (Unaudited)
-52%
$
-52%
$
433 26,952 27,385
2017-18
% chg 107%
$
12964%
$
% chg
25,000 25,000
5674%
-100% -9%
Expenditures: Salaries Employee Benefits Purchased Services Supplies Capital Outlay Tuition Other Total Expenditures
Excess (Deficiency) of Revenue over (under) Expenditures
$
(997,850)
$
$
112,979 112,979
$
(112,769)
77%
77%
$
$
251,480 251,480
$
(224,095)
-94%
-94%
$
123%
123%
1,109,000 $ 1,109,000
$ (1,084,000)
Other financing Sources (Uses): Proceeds from Bond Issues Bond Issuance Costs Transfers In Transfers Out
$ 5,950,000 215,129 -
$
Change in Fund Balance
$ 5,167,279
$ (1,853,151)
$
Beginning Fund Balance
$
$ 5,164,847
$ 3,311,696
$ 3,198,927
$ 1,201,427
$ 3,311,696
$ 3,198,927
$ 2,974,832
$
Projected Ending Fund Balance
(2,432)
$ 5,164,847
-
-100%
$
-100%
70
-
(112,769)
$
$
(224,095)
$
-
$ (1,084,000)
117,427
341%
341%
The FY18 budget contains transfers in the amount of $3 million form the Education fund and $5 million from the Operations and Maintenance fund to the Capital Projects fund to fund future facility projects. In general, the district budget is in balance and is forecast to remain in balance over the next several years, as evidenced by the relative stability of fund balance in the years beyond FY18.
71
Deerfield Public Schools District 109 School Budgets
Education Fund 2017‐18 Budget ($ Thousand)
Caruso, $296 Shepard, $287
School Budgets
District Budget
$41,891
$1,049
Kipling, $111 Wilmot, $120 Walden, $115
South Park, $119
School budgets, under Principal control, account for less than 3% of total Education Fund budget
School Budget History by School $350,000
105%
106%
102%
$300,000
99% 93% 88%
$250,000
2014‐15 Actual
$200,000
2015‐16 Actual 2016‐17 Actual $150,000
$100,000
100%
111% 137%
103% 119%
130% 100% 94%
2017‐18 Budget
97% 107% 107%
Actual % of Budget
95%
$50,000
$‐ Kipling
South Park
Walden
Wilmot
Source: District Records
72
Shepard
Caruso
2017‐2018 School Budgets $1,048,653 100%
2
2
2
7
10
7
2 7
51
90%
80%
3 39
5 36
20
26
23
69
27
70%
60% Technology Support Services
50%
83
81
83
85
196
186
40%
Stipends / Subs
Amounts in $ thousands
30%
20%
10%
0%
Instruction Services
100% Kipling South Walden Wilmot Shepard Caruso 0 2 4 6 8 101214161820222426283032343638404244464850525456586062646668707274767880828486889092949698100
Park
Source: District Records 73
Deerfield Public School District #109 FY 2017-18 School Budget Kipling
Account Number
10 10 10 10 10 10
110 110 110 110 110 110
1110 1110 1110 1110 1110 1110
3118 4101 4105 4113 4115 4133
Description
00 00 00 00 00 00
00 00 00 00 00 00
2015-16 Actual
Budget
Budget
% of Budget
2016-17 Actual (Unaudited)
2017-18 Budget
% of Budget
6/30/17
Instruction Services PROFESSIONAL GROWTH/MTG EXP INSTRUCTIONAL SUPPLIES-GENERAL ART SUPPLIES PHYS. EDUC. SUPPLIES MUSIC SUPPLIES COPIER SUPPLIES
1,500 13,400 500 500 500 4,000
310 15,827 420 489 392 4,030
21% 118% 84% 98% 78% 101%
1,500 14,050 750 500 4,000
820 13,943 750 498 260 3,584
55% 99% 100% 100% 90%
1,500 12,000 1,000 800 500 4,000
20,400
21,468
105%
20,800
19,855
95%
19,800
Support Services 10 110 2220 4300 00 00 LIBR BOOKS/PERIODICALS 10 110 2410 3118 00 00 PROFESSIONAL GROWTH/MTG EXP 10 110 2410 4135 00 00 GENERAL SUPPLIES
2,500 4,000 400
2,593 3,996 238
104% 100% 60%
2,500 4,000 -
2,207 4,444 -
88% 111%
2,500 4,000
Subtotal
6,900
6,827
99%
6,500
6,651
102%
6,500
500 1,000
231 5,926
46% 593%
500 1,000
583 996
117% 100%
500 1,000
1,500
6,157
410%
1,500
1,579
105%
1,500
28,800
34,452
120%
28,800
28,085
98%
27,800
5,700 9,000 50,500
11,243 13,144 63,736
197% 146% 126%
5,700 9,000 66,216
5,808 10,142 66,141
102% 113% 100%
5,700 9,000 68,352
122,575
130%
110,176
100%
Subtotal
Technology 10 110 1110 3232 00 00 COMPUTER REPAIR 10 110 1110 4144 00 00 SUPPLIES
Subtotal Kipling Total Stipends/Subs 10 110 1110 1220 00 00 IN-SCHOOL SUBSTITUTES 10 110 1500 1321 00 00 STIPENDS 10 110 2560 1155 00 00 LUNCH SUPERVISION
Principal Total
$
94,000
$
74
$
109,716
$
$
110,852
Deerfield Public School District #109 FY 2017-18 School Budget South Park
Account Number
10 10 10 10 10 10 10 10 10 10
120 120 120 120 120 120 120 120 120 120
1110 1110 1110 1110 1110 1110 1110 1110 1110 1110
3118 3231 4101 4102 4103 4105 4113 4115 4133 5410
Description
00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00
120 120 120 120 120
2220 2220 2220 2410 2410
4141 4300 5410 3118 4135
00 00 00 00 00
00 00 00 00 00
Support Services GEN LIBRARY/MEDIA SUPPLIES LIBR BOOKS/PERIODICALS EQUIPMENT-NEW PROFESSIONAL GROWTH/MTG EXP GENERAL SUPPLIES Subtotal
Technology 10 120 1110 3232 00 00 COMPUTER REPAIR 10 120 1110 4144 00 00 SUPPLIES Subtotal South Park Total Stipends/Subs 10 120 1110 1220 00 00 IN-SCHOOL SUBSTITUTES 10 120 1500 1321 00 00 STIPENDS 10 120 2560 1155 00 00 LUNCH SUPERVISION Principal Total
Budget
% of Budget
2016-17 Actual (Unaudited)
2017-18 Budget
% of Budget
6/30/17
Instruction Services PROFESSIONAL GROWTH/MTG EXP REPAIRS/GENERAL EQUIPMENT INSTRUCTIONAL SUPPLIES-GENERAL SUPPLIES - TEACHERS HELPING HANDS PRESCHOOL-SUPPLIES ART SUPPLIES PHYS. EDUC. SUPPLIES MUSIC SUPPLIES COPIER SUPPLIES EQUIPMENT-NEW Subtotal
10 10 10 10 10
2015-16 Actual
Budget
$
1,500 250 14,000 2,650 560 1,200 400 400 5,000 -
1,833 15,424 2,969 253 1,370 399 290 4,653 -
122% 0% 110% 112% 45% 114% 100% 73% 93%
1,500 250 14,000 2,650 560 1,200 400 400 5,000 -
1,308 123 13,955 2,101 1,021 1,187 200 519 4,747 -
87% 49% 100% 79% 182% 99% 50% 130% 95%
1,500 250 14,000 2,650 560 1,200 400 400 5,000 -
25,960
27,191
105%
25,960
25,161
97%
25,960
300 3,500 4,000 480
251 3,463 5,371 897
384 3,539 3,831 240
128% 101%
134% 187%
300 3,500 6,000 480
64% 50%
300 3,500 6,000 480
8,280
9,982
121%
10,280
7,994
78%
10,280
500 1,000
278 7,123
56% 712%
500 1,000
398
0% 40%
500 1,000
1,500
7,401
493%
1,500
398
27%
1,500
35,740
44,574
125%
37,740
33,553
89%
37,740
4,820 10,000 48,500
4,570 14,336 54,095
95% 143% 112%
4,820 8,000 66,216
10,050 15,342 61,582
209% 192% 93%
4,820 8,000 68,352
117,575
119%
120,527
103%
99,060
$
75
84% 99%
$
116,776
$
$
118,912
Deerfield Public School District #109 FY 2017-18 School Budget Walden
Account Number
10 10 10 10 10 10 10
130 130 130 130 130 130 130
1110 1110 1110 1110 1110 1110 1110
3118 4101 4102 4105 4113 4115 4133
Description
00 00 00 00 00 00 00
00 00 00 00 00 00 00
Budget
130 130 130 130
2220 2220 2410 2410
4141 4300 3118 4135
00 00 00 00
00 00 00 00
Support Services GEN LIBRARY/MEDIA SUPPLIES LIBR BOOKS/PERIODICALS PROFESSIONAL GROWTH/MTG EXP GENERAL SUPPLIES
Subtotal Technology 10 130 1110 3232 00 00 COMPUTER REPAIR 10 130 1110 4144 00 00 SUPPLIES
Subtotal Walden Total Stipends/Subs 10 130 1110 1220 00 00 IN-SCHOOL SUBSTITUTES 10 130 1500 1321 00 00 STIPENDS 10 130 2560 1155 00 00 LUNCH SUPERVISION
Principal Total
% of Budget
Budget
2016-17 Actual (Unaudited)
2017-18 Budget
% of Budget
6/30/17
Instruction Services PROFESSIONAL GROWTH/MTG EXP INSTRUCTIONAL SUPPLIES-GENERAL SUPPLIES - TEACHERS ART SUPPLIES PHYS. EDUC. SUPPLIES MUSIC SUPPLIES COPIER SUPPLIES
Subtotal
10 10 10 10
2015-16 Actual
$
1,500 12,000 1,000 1,200 705 800 4,500
3,983 24,774 2,281 1,229 687 803 4,613
266% 206% 228% 102% 97% 100% 103%
1,500 16,000 1,000 1,200 700 800 4,500
6,737 22,050 1,296 1,448 698 206 4,528
449% 138% 130% 121% 100% 26% 101%
1,500 14,000 1,000 1,200 500 500 4,500
21,705
38,370
177%
25,700
36,963
144%
23,200
500 2,000 4,000 -
790 1,514 3,351 -
158% 76% 84%
980 2,000 4,000 -
783 1,035 2,826 -
80% 52% 71%
980 2,000 4,000 -
6,500
5,655
87%
6,980
4,644
67%
6,980
1,000 1,000
940 9,741
94% 974%
1,000 1,000
2,073
0% 207%
1,000 1,000
2,000
10,681
534%
2,000
2,073
104%
2,000
30,205
54,706
181%
34,680
43,680
126%
32,180
5,795 9,000 44,500
6,950 10,521 50,551
120% 117% 114%
5,795 9,000 66,216
7,920 9,928 67,441
137% 110% 102%
5,795 9,000 68,352
89,500
$ 122,728
137%
$ 115,691
$ 128,969
111%
76
$
115,327
Deerfield Public School District #109 FY 2017-18 School Budget Wilmot
Account Number
10 10 10 10 10 10
140 140 140 140 140 140
1110 1110 1110 1110 1110 1110
3118 4101 4105 4113 4115 4133
Description
00 00 00 00 00 00
00 00 00 00 00 00
140 140 140 140 140
2220 2220 2220 2410 2410
4141 4144 4300 3118 4135
00 00 00 00 00
00 00 00 00 00
Support Services GEN LIBRARY/MEDIA SUPPLIES AV/COMPUTER SOFTWARE LIBR BOOKS/PERIODICALS PROFESSIONAL GROWTH/MTG EXP GENERAL SUPPLIES
Subtotal Technology 10 140 1110 3232 00 00 COMPUTER REPAIR 10 140 1110 4144 00 00 SUPPLIES
Subtotal Wilmot Total Stipends/Subs 10 140 1110 1220 00 00 IN-SCHOOL SUBSTITUTES 10 140 1500 1321 00 00 STIPENDS 10 140 2560 1155 00 00 LUNCH SUPERVISION
Principal Total
Budget
% of Budget
2016-17 Actual (Unaudited)
2017-18 Budget
% of Budget
6/30/17
Instruction Services PROFESSIONAL GROWTH/MTG EXP INSTRUCTIONAL SUPPLIES-GENERAL ART SUPPLIES PHYS. EDUC. SUPPLIES MUSIC SUPPLIES COPIER SUPPLIES
Subtotal
10 10 10 10 10
2015-16 Actual
Budget
$
1,500 14,200 1,700 1,600 1,100 7,000
224 18,661 1,755 1,582 412 4,613
15% 131% 103% 99% 37% 66%
1,500 14,200 1,700 1,600 1,100 7,000
2,398 12,069 1,451 996 800 4,520
160% 85% 85% 62% 73% 65%
1,500 15,400 1,400 1,000 800 7,000
27,100
27,247
101%
27,100
22,234
82%
27,100
200 2,540 4,000 -
200 2,432 3,693 -
100%
200 2,540 4,000 -
3,079 3,158 4,397 -
1540%
200
124% 110%
2,540 4,000 -
6,740
6,325
94%
6,740
10,634
158%
6,740
1,000 1,000
6,900
0% 690%
1,000 1,000
568
0% 57%
1,000 1,000
2,000
6,900
345%
2,000
568
28%
2,000
35,840
40,472
113%
35,840
33,436
93%
35,840
6,270 10,000 55,500
5,733 9,777 58,652
91% 98% 106%
6,270 10,000 66,216
6,545 9,241 66,061
104% 92% 100%
6,270 10,000 68,352
114,634
107%
115,283
97%
107,610
$
77
96% 92%
$
118,326
$
$
120,462
Deerfield Public School District #109 FY 2017-18 School Budget Shepard
Account Number
10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10
250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250
1120 1120 1120 1120 1120 1120 1120 1120 1120 1120 1120 1120 1120 1120 1120 1120 1120 1560 1560
3118 4101 4101 4101 4101 4101 4101 4101 4105 4106 4107 4110 4113 4115 4117 4120 4133 3194 4114
Description
00 00 06 06 07 07 08 08 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
Instruction Services PROFESSIONAL GROWTH/MTG EXP INSTRUCTIONAL SUPPLIES-GENERAL 6th White Supplies 6th Red Supplies 7th White Supplies 7th Red Supplies 8th White Supplies 8th Red Supplies ART SUPPLIES STEM Supplies CMA Supplies SCIENCE SUPPLIES PHYS. EDUC. SUPPLIES MUSIC SUPPLIES WORLD LANGUAGE SUPPLIES MUSICAL SUPPLIES COPIER SUPPLIES OFFICIALS & JUDGES ATHLETIC SUPPLIES
Subtotal
10 10 10 10
250 250 250 250
2220 2220 2410 2410
4300 5410 3118 4135
00 00 00 00
00 00 00 00
Support Services LIBR BOOKS/PERIODICALS EQUIPMENT-NEW PROFESSIONAL GROWTH/MTG EXP GENERAL SUPPLIES
Subtotal Technology 10 250 1120 3232 00 00 COMPUTER REPAIR 10 250 1120 4144 00 00 SUPPLIES 10 250 1120 5432 00 00 COMPUTER-EQUIPMENT NEW
Subtotal Shepard Total
10 10 10 40
250 250 250 250
1120 1500 2560 2550
1220 1321 1155 3315
00 00 00 00
00 00 00 00
Stipends/Subs IN-SCHOOL SUBSTITUTES STIPENDS LUNCH SUPERVISION CO-CURRICULAR TRANSPORTATION
Principal Total
Budget
2015-16 Actual
% of Budget
Budget
2016-17 Actual (Unaudited)
2017-18 Budget
% of Budget
6/30/17
5,000 6,000 1,500 1,500 1,500 1,500 1,500 1,500 3,750 1,500 1,500 2,000 3,000 1,750
4,926 7,760 1,458 1,458 854 854 1,281 1,281 3,733 4,082 1,439 9,285 3,220 1,692
99% 129%
115% 81% 48%
5,500 6,000 1,500 1,500 1,500 1,500 1,500 1,500 3,750 1,500 1,500 3,500 3,000 1,750 1,500 2,000 4,000 7,000 3,000
5,844 4,586 1,320 1,320 1,464 1,464 852 852 3,749 1,478 1,191 3,522 3,115 1,580 1,402 1,972 2,486 6,010 1,758
106% 76% 88% 88% 98% 98% 57% 57% 100% 99% 79% 101% 104% 90% 93% 99% 62% 86% 59%
5,500 5,000 1,500 1,500 1,500 1,500 1,500 1,500 3,750 1,500 1,500 3,500 3,000 1,750 1,500 2,000 4,000 7,000 2,000
4,000 7,000 3,000
4,613 5,635 1,442
47,500
55,010
116%
53,000
45,964
87%
51,000
8,000 50,000 7,500 2,000
8,063 46,608 5,611 2,166
101% 93% 75% 108%
8,000 46,500 5,500 2,000
8,200 38,010 4,182 3,235
103% 82% 76% 162%
8,000 20,000 5,500 2,000
67,500
62,448
93%
62,000
53,627
86%
35,500
1,000 1,500 5,000
2,253 6,220
0% 150% 124%
1,000 1,500 5,000
135 1,687 3,862
14% 112% 77%
1,500 3,000
7,500
8,473
113%
7,500
5,684
76%
4,500
122,500
125,931
103%
122,500
105,275
86%
91,000
2,500 130,000 22,000 10,000
4,260 141,770 18,461 9,651
170% 109% 84% 97%
2,500 130,000 22,000 10,000
6,098 157,587 18,399 6,484
244% 121% 84% 65%
2,500 161,500 22,000 10,000
$ 287,000
$ 300,073
105%
$ 287,000
$ 293,843
102%
78
100% 272% 96% 464% 107% 97%
$
287,000
Deerfield Public School District #109 FY 2017-18 School Budget Caruso
Account Number
10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10
260 260 260 260 260 260 260 260 260 260 260 260 260 260 260 260
1120 1120 1120 1120 1120 1120 1120 1120 1120 1120 1120 1120 1120 1120 1560 1560
3118 3231 4101 4101 4101 4101 4105 4106 4109 4110 4115 4117 4119 4133 3194 4114
Description
00 00 00 06 07 08 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
260 260 260 260 260
2220 2220 2410 2410 2410
4300 5410 3118 4135 4135
00 00 00 00 00
00 00 00 00 00
110% 120% 49% 101% 95% 168% 100% 100% 195% 83% 68% 83% 0% 58% 103% 100%
11,000 1,320 8,500 3,000 3,000 3,000 4,000 1,500 1,500 3,500 1,200 1,500 23,000 6,000 8,000 3,000
4,048 272 5,518 1,835 2,312 2,128 3,849 1,488 3,197 4,425 870 1,272 17,912 4,689 8,767 2,739
37% 21% 65% 61% 77% 71% 96% 99% 213% 126% 73% 85% 78% 78% 110% 91%
5,500 1,320 8,800 3,000 3,000 3,000 4,000 1,500 1,500 3,500 1,200 1,500 12,000 6,000 9,900 3,000
53,920
44,576
83%
83,020
65,321
79%
68,720
8,500 8,000 2,000
7,866
93%
4,598 2,107
57% 105%
8,500 23,000 5,500 2,000
8,537 21,422 5,807 2,242
100% 93% 106% 112%
8,500 23,000 5,500 2,000 -
18,500
14,571
79%
39,000
38,008
97%
39,000
1,000 1,500
968 358
97% 24%
1,000 1,500
135 775
14% 52%
1,000 1,500
2,500
1,326
53%
2,500
910
36%
2,500
Caruso Total
74,920
60,473
81%
124,520
104,239
84%
110,220
Stipends/Subs IN-SCHOOL SUBSTITUTES STIPENDS LUNCH SUPERVISION CO-CURRICULAR TRANSPORTATION
5,880 179,700 21,000 10,000
4,485 189,959 23,382 9,937
76% 106% 111% 99%
5,880 134,700 21,000 10,000
5,527 166,010 24,165 13,955
94% 123% 115% 140%
5,880 147,000 23,000 10,000
288,236
99%
313,896
106%
Support Services LIBR BOOKS/PERIODICALS EQUIPMENT PROFESSIONAL GROWTH/MTG EXP GENERAL SUPPLIES EQUIPMENT
Subtotal
1120 1500 2560 2550
1220 1321 1155 3315
00 00 00 00
00 00 00 00
2017-18 Budget
% of Budget
3,303 1,465 7,963 2,424 2,281 4,028 3,998 500 976 2,647 679 249 3,460 8,203 2,400
Technology 10 260 1120 3232 00 00 COMPUTER REPAIR 10 260 1120 4144 00 00 SUPPLIES
260 260 260 260
2016-17 Actual (Unaudited)
3,000 1,220 16,100 2,400 2,400 2,400 4,000 500 500 3,200 1,000 300 500 6,000 8,000 2,400
Subtotal
10 10 10 40
Budget
% of Budget
6/30/17
Instruction Services PROFESSIONAL GROWTH/MTG EXP REPAIRS/GENERAL EQUIPMENT INSTRUCTIONAL SUPPLIES-GENERAL 6TH GRADE SUPPLIES 7TH GRADE SUPPLIES 8TH GRADE SUPPLIES ART SUPPLIES STEM SUPPLIES CMA SUPPLIES SCIENCE SUPPLIES MUSIC SUPPLIES WORLD LANGUAGE SUPPLIES SCHOOL IMPROVE SUPPLIES COPIER SUPPLIES OFFICIALS & JUDGES ATHLETIC SUPPLIES
Subtotal
10 10 10 10 10
2015-16 Actual
Budget
Principal Total
$
291,500
$
79
$
296,100
$
$
296,100
Deerfield Public School District #109 FY 2017-18 Budget Detail Executive Administration
Account Number
10 10 10 10 10 10 10 10 10 10 10
050 050 050 050 050 050 050 050 050 050 050
2310 2310 2310 2310 2310 2310 2310 2310 2310 2310 2320
3119 3170 3180 3420 3450 3550 3610 3820 3830 3840 4133
Description
00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 01 01 01 00
BOE Services SERVICES AUDITING SERVICES LEGAL SERVICES COMMUNICATIONS POSTAGE ADVERTISING PRINTING SERVICE LIABILITY INS UNEMPLOYMENT INSU WORKMENS' COMP INSURANCE COPIER SUPPLIES
Subtotal
10 10 10 10 10 10 10 10
050 050 050 050 050 050 050 050
2210 2310 2310 2320 2320 2320 2320 2320
3116 3115 3950 3111 3118 3231 4135 5410
00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00
Superintendent Accounts ADMIN STAFF DEVELOPMENT RESEARCH & INSERVICE MISCELLANEOUS BUS/DUES ADMINISTRATIVE SERVICES PROFESSIONAL GROWTH/MTG EXP REPAIRS/GENERAL EQUIPMENT GENERAL SUPPLIES EQUIPMENT-NEW
Subtotal
Budget
2015-16 Actual
% of Budget
Budget
2016-17 Actual (Unaudited)
% of Budget
2017-18 Budget
6/30/17
90,000 25,000 50,000 10,000 20,000 1,500 5,000 170,250 15,000 175,000 5,000
97,668 13,445 127,259 13,984 20,811 2,725 (48) 166,897 2,679 174,983 2,287
109% 54% 255% 140% 104% 182% -1% 98% 18% 100% 46%
94,500 25,000 50,000 5,000 20,000 1,575 2,500 170,250 15,000 206,275 5,000
125,428 18,915 97,526 1,676 15,365 1,153 793 155,432 (1,036) 203,788 739
133% 76% 195% 34% 77% 73% 32% 91% -7% 99% 15%
133,250 25,000 75,000 5,000 20,000 1,575 1,500 175,000 5,000 235,601 5,000
104%
681,926
566,750
622,690
110%
595,100
619,779
55,000 25,000 20,000 15,000 750 3,000 -
5,637 82,320 5,548 19,125 14,590 2,034 2,875 -
150% 22% 96% 97% 271% 96%
58,750 26,250 21,000 15,000 750 3,150 -
36,807 8,626 17,792 10,547 2,070 -
63% 33% 85% 70% 0% 66%
67,000 26,250 68,000 15,000 500 3,000 -
118,750
132,129
111%
124,900
75,842
61%
179,750
685,500
754,819
110%
720,000
695,621
97%
861,676
80
Deerfield Public School District #109 FY 2017-18 Budget Detail Business Services, Technology, and Human Resources
Account Number
10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10
000 000 000 000 000 000 000 050 060 060 060 060 060 060 060 060 060 090
1110 1110 1110 1110 1110 1110 1110 2320 2510 2510 2510 2510 1110 2510 2510 2560 1110 2400
1100 1102 1103 1104 1105 1325 2150 2225 3118 3160 3231 3321 3933 4135 5410 4170 2221 1200
Description
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 84 00 00
Technology Services 10 040 2634 3160 00 00 DATA PROCESSING S 10 040 2634 4144 00 00 AV/COMPUTER SOFTW 10 040 2634 5432 00 00 COMPUTER-EQUIPMEN
Technology Total
000 000 090 090 090 090 090 090 090 090 090 090 090
1110 1120 2210 2210 2210 2320 2210 2210 2320 2320 2320 2320 2320
2300 2400 3118 3117 3231 3118 3120 3550 3109 3110 3121 4135 4136
00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00
Human Resources TUITION REIMBURSEMENT-DEA EMPLOYEE ASSISTANCE PROGRAM TUITION REIMBURSEMENT-ESP STAFF EVALUATION TOOLS ONLINE APP/RECRUIT/JOB FAIR PROFESSIONAL GROWTH HUMANEX ADVERTISING BACKGROUND CHECKS/FINGERPRINTS AED/CPR/SAFETY TRAINING SUB CALLING/AESOP GENERAL SUPPLIES NEW TEACHER/MENTOR MATERIALS
Subtotal
10 10 10 10
090 090 090 090
1110 1110 1120 2210
3192 1220 1220 1321
00 00 00 00
94 00 00 00
OUTDOOR EDUCATION SERVICES SUBS - SICK & PERSONAL TIME, LEAVES SUBS - SICK & PERSONAL TIME, LEAVES NBCT STIPENDS/TEACHER MENTOR
Human Resources Total
2016-17 Actual (Unaudited)
Budget
% of Budget
2017-18 Budget
% of Budget
6/30/17
Business Services SALARY CONTINGENCY MERIT CONTINGENCY STEP/LANE CONTINGENCY RETIREMENT INCREASE CONT'G EDUC INCREMENTS SEVERANCE/RETIREMENT EARLY RETIREMENT TUITION REIMBURSEMENT MEETING EXP DATA PROCESSING SERVICES REPAIRS/GENERAL EQUIPMENT INTERNAL TRAVEL & MEETING EXPENSE SERVICE AGREEMENT-COPIERS GENERAL SUPPLIES EQUIPMENT-NEW MILK PURCHASES TRIP RETIREES INS TEMPORARY SALARIES
Business Services Total
10 10 10 10 10 10 10 10 10 10 10 10 10
2015-16 Actual
Budget
300,000 20,000 85,000 740,000 95,000 737,267 100,000 45,000 16,000 6,000 2,000 12,500 121,905 10,000 1,500 35,000 161,345 8,000
25,491 19,000 17,290 275,407 105,782 386,676 34,529 18,855 2,704 17,806 146,062 7,146 16,462 113,198 -
8% 95% 20% 37% 111% 52% 0% 77% 118% 45% 0% 142% 120% 71% 0% 47% 70% 0%
300,000 20,000 85,000 740,000 110,000 737,267 100,000 45,000 16,000 2,000 2,000 12,500 121,905 10,000 1,500 35,000 161,345 8,000
29,000 13,866 250,689 155,845 253,067 23,396 12,732 1,568 809 20,022 28,030 4,512 110 29,566 95,550 15,075
0% 145% 16% 34% 142% 34% 0% 52% 80% 78% 40% 160% 23% 45% 7% 84% 59% 188%
150,000 22,950 40,000 250,000 175,000 246,000 45,000 16,000 2,000 2,000 12,500 135,000 8,000 1,000 25,000 85,000 8,000
2,496,517
1,186,408
48%
2,507,517
933,837
37%
1,223,450
744,280 1,105,000 1,027,500
815,777 334,944 1,595,371
110% 30% 155%
419,366 477,100 1,600,000
792,863 111,780 1,088,633
189% 23% 68%
440,100 489,028 1,200,000
2,876,780
2,746,092
95%
2,496,466
1,993,276
80%
2,129,128
155,000 5,000 60,000
118%
114% 181% 49% 282% 63% 0% 100% 57% 93%
155,000 5,000 50,000 22,000 11,250 2,500 20,000 4,000 4,000 2,500 10,000 2,000 5,000
169,333 15,575 10,009 49,053 2,556 16,353 3,000 6,648 1,052 2,623 3,366
109%
2,000 2,500 30,000 1,500 7,000 2,500 9,500 2,000 3,700
182,395 53,093 27,560 2,271 4,535 14,661 4,233 4,410 9,454 1,140 3,458
31% 45% 436% 102% 2% 75% 166% 42% 0% 131% 67%
150,000 5,000 45,000 18,000 38,500 3,000 20,000 3,000 4,500 2,500 10,500 3,000 3,500
280,700
307,210
109%
293,250
279,568
95%
306,500
20,000 360,000 140,000 35,500
$
836,200
18,087 499,188 122,412 36,710
$
81
983,607
88%
20,000 360,000 140,000 35,500
90% 139% 87% 103%
118%
$
848,750
13,043 387,144 121,066 42,809
$
843,630
20,000 360,000 140,000 35,500
65% 108% 86% 121%
99%
$
862,000
Deerfield Public School District #109 FY 2017-18 Budget Detail Learning 2015-16
Account Number
Description
Budget
2017-18 Budget
2016-17
Actual
Budget
% of Budget
Actual
% of Budget
(Unaudited)
10 10 10 10 10 10 10 10 10 10 10
070 070 070 070 070 070 070 070 070 070 070
2210 2210 2220 2220 2230 2230 2290 2290 2290 2320 2320
3113 3115 3231 4144 3152 4152 3117 3320 4130 4135 5410
00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00
6/30/17
Non-Categorical LCESC SERVICES RESEARCH & INSERVICE REPAIRS/GENERAL EQUIPMENT AV/COMPUTER SOFTWARE TESTING/ASSESS SERVICES TESTING/ASSESS SUPPLIES CURRICULUM DEVELOPMENT TRAVEL-STAFF SUPPORT SVCS SUPPLIES GENERAL SUPPLIES EQUIPMENT-NEW
1,771 500 2,000 100,000 5,000 19,000 9,000 2,000 2,000 20,000
3,271 11,028 65,960 434 16,014 3 724 629
185%
161,271
98,063
Summer School TEACHER SALARIES SECRETARY SALARIES AIDES SALARIES INSTRUCTIONAL SUP EQUIPMENT - NEW
80,000 10,000 6,000 925
Subtotal
Subtotal
10 10 10 10 10
070 070 070 070 070
1600 1600 1600 1600 1600
1120 1152 1155 4101 5410
00 00 00 00 00
06 06 06 06 06
Professional Development 10 070 2210 1322 00 18 CURRICULUM WORK/INSERV/STIPENDS 10 070 2210 3116 00 18 STAFF DEVELOPMENT SERVICES 10 070 2210 4135 00 18 GENERAL SUPPLIES
Subtotal
10 10 10 10 10
070 070 070 070 070
1650 1650 2210 2230 2320
3117 4101 3115 4152 4101
00 00 00 00 00
25 25 25 25 25
Gifted Education CURRICULUM DEVELOPMENT INSTRUCTIONAL SUPPLIES - GENERAL RESEARCH & INSERVICE TESTING/ASSESS SUPPLIES SUPPLIES - GENERAL
30 30 30 30 30 30
ESEA-Title I INSTRUCTIONAL SUPPLIES - GENERAL RESEARCH & INSERVICE SUPPLIES RESEARCH & INSERVICE LCESC SERVICES LCESC SERVICES
Subtotal
10 10 10 10 10 10
070 070 070 070 070 070
1200 2210 2210 3700 4100 4120
4101 3115 4101 3115 3113 3113
00 00 00 00 00 00
Subtotal
$
0% 551% 66% 9% 0% 178% 0% 36% 3%
2,700 500 2,000 100,000 5,000 19,000 12,500 2,000 2,000 7,000
3,271 13,883 108,482 13,058 690 -
0% 694% 108% 0% 0% 104% 0% 35% 0%
2,700 90,000 500 2,000 100,000 5,000 19,000 7,500 2,000 2,000 7,000
61%
152,700
139,384
91%
237,700
103,057 14,871 1,202 -
20% 0%
80,000 10,000 6,000 925
104,597 15,545 2,195 -
37% 0%
80,000 10,000 10,000 925
96,925
119,130
123%
96,925
122,337
126%
100,925
20,000 34,000 15,300
116,202 35,275 5,437
581% 104% 36%
20,000 25,000 5,000
60,679 50,070 2,330
303% 200% 47%
20,000 25,000 5,000
156,914
226%
113,079
226%
260 4,388 8,655 -
13% 176% 0% 108% 0%
13,303
92%
5,089
0% 12%
1,131 -
0%
6,220
8%
69,300
$
2,000 2,500 1,500 8,000 525
$
14,525
$
31,260 41,500 3,000 -
$
75,760
$
82
$
50,000
$
750 2,500 3,000 -
$
$
6,250
260 591 7,799 -
$
121%
$
750 2,500 3,000 -
35% 24% 260%
8,650
138%
31,260 41,500 3,000 -
1,105 -
0% 0%
75,760 $
1,105
1%
50,000
$
6,250
31,260 41,500 3,000
0% $
75,760
Deerfield Public School District #109 FY 2017-18 Budget Detail Learning 2015-16
Account Number
Description
Budget
State Library Grant 10 070 2220 4141 00 31 PROFESSIONAL GROWTH/MTG EXP
-
2017-18 Budget
2016-17
Actual
Budget
% of Budget
2,095
Actual
-
% of Budget
1,813
-
Subtotal
$
Drug Free School - Title IV 10 070 1110 4101 00 65 INSTRUCTIONAL SUPPLIES - GENERAL
Subtotal
10 10 10 10 10 10 10 10 10 10
070 070 070 070 070 070 070 070 070 070
1110 1110 1110 1110 1120 1120 1120 1120 1120 1120
1321 3190 3231 4116 3118 3190 3194 3231 4116 5410
00 00 00 00 00 00 00 00 00 00
95 95 95 95 95 95 95 95 95 95
$
10 10 10 10 10 10
070 070 070 070 070 070
1110 1110 1110 1120 1120 2210
4100 4101 4200 4101 4200 4135
15 00 00 00 00 00
96 96 96 96 96 96
$
$
$
52,657
-
29,400
$
457,500
$
972,338
$
18% 0% 8%
5,598
11%
20,685 210 1,292 3,358 1,840 300 4,844 14,059 4,775
138% 53% 108% 336% 0% 184% 100% 161% 288% 191%
51,363
175%
31,820 11,000 187,826 9,195 87,574 6,205
159% 16% 64%
$
333,620
73%
30,030
200%
$
816,336
84%
$
$
15,000
83
-
$
-
4,066 1,532
20,000 70,000 295,000 70,000 2,500
10 070 2210 1220 00 18 SUBS-INSERVICES
Learning Total
-
$
-
15,000 400 1,200 1,000 125 1,000 300 3,000 4,875 2,500
Textbooks INSTRUCTIONAL SUP INSTRUCTIONAL SUPPLIES-GENERAL TEXTBOOKS INSTRUCTIONAL SUPPLIES-GENERAL TEXTBOOKS GENERAL SUPPLIES
Subtotal
2,095
22,657 10,000 20,000
Instrumental Music INSTRUMENTAL MUSIC STIPENDS OTHER PROF/TECH SERVICES REPAIRS/GENERAL EQUIPMENT INSTRUMENTAL MUSIC SUPPLIES PROFESSIONAL GROWTH/MTG EXP OTHER PROF/TECH SERVICES OTHER PROF/TECH SERVICES REPAIRS/GENERAL EQUIPMENT INSTRUMENTAL MUSIC SUPPLIES EQUIPMENT - NEW
Subtotal
$
-
Math/Science - Title II 10 070 2210 3115 00 66 RESEARCH & INSERVICE 10 070 2210 4135 00 66 GENERAL SUPPLIES 10 070 3700 3115 00 66 RESEARCH & INSERVICE
Subtotal
-
$
-
$
-
-
-
$
-
$
22,657 10,000 20,000 52,657
22,657 10,000 20,000
6,000 1,260
26% 0% 6%
52,657 $
7,260
14%
24,597 400 4,271 785 80 3,392 292 3,425 7,026 735
164% 100% 171% 52% 64% 113% 97% 63% 117% 12%
45,003
112%
208,719 57,293 28,320 13,540 27,034 21,744
1044% 82% 12%
$
356,650
89%
$
402,500 -
$
824,649
94%
$
966,067
40,275
$
20,000 70,000 240,000 70,000 2,500
125% 248%
$
-
15,000 400 2,500 1,500 125 3,000 300 5,450 6,000 6,000
$
1,813
$
402,500
$
877,067
-
15,000 400 2,500 1,500 125 3,000 300 5,450 6,000 6,000 $
40,275
20,000 70,000 240,000 70,000 2,500
39% 870%
29,368
Deerfield Public School District #109 FY 2017-18 Budget Detail Student Services
Account Number
10 10 10 10 10 10 10 10 10 10 10 10 10 10 10
080 080 080 080 080 080 080 080 080 080 080 080 080 080 080
1200 1200 1200 1200 2140 2150 2150 2210 2210 2210 2230 2634 2660 3700 4120
3116 4101 4101 5410 4135 3000 4135 3110 3115 4135 4135 3160 3160 4135 3142
Description
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
49 48 49 49 49 49 49 49 48 49 49 49 49 49 49
I D E A Flow-Through STAFF DEVELOPMENT SERVICES INSTRUCTIONAL SUPPLIES-GENERAL INSTRUCTIONAL SUPPLIES-GENERAL EQUIPMENT-NEW GENERAL SUPPLIES PURCHASED SERVICES GENERAL SUPPLIES PROFESSIONAL SERVICES-ADMIN RESEARCH & INSERVICE GENERAL SUPPLIES GENERAL SUPPLIES DATA PROCESSING SERVICES DATA PROCESSING SERVICES GENERAL SUPPLIES PROFESSIONAL SVCS - PUPILS
Subtotal
10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10
080 080 080 080 080 080 080 080 080 080 080 080 080 080 080 080 080
1200 1200 1200 1200 1200 2100 2130 2140 2150 2150 2210 2310 2320 4120 4120 4120 4120
3180 3190 4101 8020 3148 3320 4135 3142 4135 5410 3116 3180 4135 8000 8008 8014 8016
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
0 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12
Special Education LEGAL SERVICES OTHER PROF/TECH SERVICES INSTRUCTIONAL SUP TUITION-PVT FACIL HOMEBOUND TUTOR TRAVEL-STAFF HEALTH SUPPLIES PROFESSIONAL SVCS GENERAL SUPPLIES STAFF DEVELOPMENT SERVICES LEGAL SERVICES GENERAL SUPPLIES (PPS) TUITION-OTHER LEA LICA SERVICES NSSED/NSSRA - SUM NSSED-CONTRACTUAL
Subtotal 10 080 1200 1220 00 12 IEP SUBSTITUTES 10 080 1200 1321 00 12 SPECIAL EDUCATION STIPENDS
Student Services Total
2015-16 Actual
Budget
$
% of Budget
2017-18 Budget
6/30/17 17,379 8,649
44,246 33,251 13,934 3,035 36,663 2,449 2,818 22,562 243,020
136% 1663%
135%
32,500 2,000 3,000 2,000 3,000 28,000 1,000 4,500 10,000 14,000 260,000
127%
380,000
428,006
113%
475,000
217,958
436%
50,000
115,234
230%
100,000
11,770 484,984 19,653 4,805 8,193 -
59% 97% 131% 80%
16,000 520,000 15,000 6,000 9,000 1,000
7,123 398,553 6,655 10,566 8,869 -
45% 77% 44% 176% 99%
10,000 400,000 15,000 15,000 9,000 1,000
9,407 11,444
32,500 2,000 3,000 2,000 3,000 28,000 1,000 4,500 10,000 14,000 260,000
26,727 9,847 7,069 1,149 44,504 3,619 2,718 15,501 351,615
380,000
483,600
50,000 20,000 500,000 15,000 6,000 5,000 1,000 1,000 20,000 400,000
648 38,422 182,057
1,018,000 15,000 10,000
$
2016-17 Actual (Unaudited)
20,000 -
20,000 -
1,413,000
Budget
% of Budget
82% 492%
159%
0%
0%
131%
0%
93%
0% (1,767) 20,333 15,647 212,975
14,000 47,000 30,000 15,000 12,000 4,000 30,000 2,000 6,000 15,000 300,000
46%
1,000 30,000 370,000
968,490
95%
1,018,000
794,188
78%
888,000
14,753 17,649
98% 176%
15,000 10,000
17,215 12,266
115% 123%
40,000 20,000
1,466,843
104%
1,423,000
$ 1,239,409
87%
$ 1,423,000
84
65% 192%
$
52%
2,000 22,500 25,000
58%
288,500
-177%
-
Deerfield Public School District #109 FY 2017-18 Budget Detail Transportation
Account Number
Description
Budget
2015-16 Actual
% of Budget
Budget
40 000 2550 3312 00 00 HOLY CROSS TRANSPORTATION 40 000 2550 3315 00 00 CO-CURRICULAR TRANSPORTATION 40 000 2550 3317 00 00 BAND & ORCH TRANSPORTATION 40 000 2550 3318 00 00 FIELD TRIP TRANSPORTATION 40 40 40 40
000 000 000 000
2550 2550 2550 8990
3319 3323 4641 6600
00 00 00 00
00 00 00 00
KINDERGARTEN SHUTTLE GIFTED TRANSPORTATION FUEL/SCHOOL BUSES TRANSFER TO O&M FUNDS
Subtotal
2017-18 Budget
% of Budget
6/30/17
District Wide Services 40 000 2550 3311 00 00 REGULAR TRANSPORTATION
2016-17 Actual (Unaudited)
954,489 3,532 892 8,886 6,033 2,685 -
94%
1,046,100
976,517
93%
1,078,000
993,282
92%
1,108,500
400,000 -
368,688 -
92%
400,000 -
328,652 -
82%
400,000 -
400,000
368,688
92%
400,000
328,652
82%
400,000
10,000 10,000
9,651 9,215
97%
10,000 10,000
8,987 8,755
90%
10,000 10,000
20,000
18,866
94%
20,000
17,742
89%
20,000
10,000 10,000
9,937 9,279
10,000 10,000
13,955 9,005
140%
20,000
19,216
96%
20,000
22,960
115%
10,000 10,000 20,000
$ 1,486,100
$ 1,383,287
93%
$ 1,518,000
$ 1,362,636
90%
$ 1,548,500
89% 34%
1,050,000 10,000 18,000 -
972,548 (953) 954 8,625 12,108 -
1,080,500
1,018,100 10,000 18,000 -
93%
. 86% 67%
10,000 18,000 -
Special Education 40 080 2550 3313 00 12 SPECIAL ED TRANSPORTATION 40 080 2550 3318 00 12 FIELD TRIP TRANSPORTATION
Subtotal Shepard Middle School 40 250 2550 3315 00 00 CO-CURRICULAR TRANSPORTATION 40 250 2550 3318 00 00 FIELD TRIP TRANSPORTATION 40 250 2550 3322 00 00 ACTIVITY BUS
Subtotal Caruso Middle School 40 260 2550 3315 00 00 CO-CURRICULAR TRANSPORTATION 40 260 2550 3318 00 00 FIELD TRIP TRANSPORTATION 40 260 2550 3322 00 00 ACTIVITY BUS
Subtotal Transportation Total
85
Deerfield Public School District #109 FY 2017-18 Budget Detail Operations & Maintenance
Account Number
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
20 20 20 20 20 20 20 20 20 20 20
20 20 20 20 20 20 20 20 20 20 20
000 000 000 000 000 000 000 000 000 000 000 000 000 000 000 000 000 000 000 000 000 000
110 110 110 110 110 110 110 110 110 110 110
120 120 120 120 120 120 120 120 120 120 120
2540 2540 2540 2540 2540 2540 2540 2540 2540 2540 2540 2540 2540 2540 2540 2540 2540 2540 2540 2540 5140 5200
2540 2540 2540 2540 2540 2540 2540 2540 2540 2540 2540
2540 2540 2540 2540 2540 2540 2540 2540 2540 2540 2540
1300 1291 3111 3115 3210 3222 3235 3470 3700 3931 3932 4135 4160 4162 4640 4650 4660 5300 5410 5420 6200 6100
3210 3222 3235 3700 3931 4160 4162 4650 4660 5410 5420
3210 3222 3235 3700 3931 4160 4162 4650 4660 5410 5420
Description
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00
2015-16 Actual
Budget
116% 23% 77% 109% 447% 134% 64% 212% 1% 79% 85% 170% 252% 150% 51% 180% 35%
2,408,000
2,311,510
96%
1,858,660
56% 100% 120% 78% 85% 94% 31% 33% 80% 145%
4,500 95,000 25,000 4,000 8,500 10,000 10,000 50,000 58,000 63,400 -
4,934 98,391 60,002 3,162 2,435 8,739 5,836 25,412 41,046 198,908 -
110% 104% 240% 79% 29% 87% 58% 51% 71% 314%
4,500 95,000 25,000 2,500 4,500 9,000 8,000 45,000 54,900 180,000
300,868
92%
328,400
448,865
137%
428,400
2,754 102,133 16,915 3,629 9,332 4,083 11,021 14,503 61,088 (83,023) -
56% 100% 85% 91% 71% 48% 73% 28% 69% -101%
4,500 110,000 30,000 4,000 13,200 8,500 17,000 50,000 89,000 63,900 -
6,579 106,805 72,253 3,563 6,082 8,885 10,542 29,502 54,281 193,110 -
146% 97%
6,000 110,000 40,000 3,500 8,000 8,500 14,000 40,000 80,100 180,000
142,435
37%
25,000 175,000 1,100,000 2,500 6,500 36,000 20,000 30,000 1,000 9,500 80,000 8,000 60,000 17,000 500 20,000 55,000 762,000 -
26,217 190,989 1,671,505 10,658 23,350 39,429 48,152 38,026 634 25,171 162 3,026 10,783 78,264 9,457 427 11,527 105,878 660,579 73 75,660 -
Subtotal
2,408,000
3,029,967
126%
4,900 94,500 20,000 4,000 8,500 8,500 15,000 50,000 58,000 65,000 -
2,754 94,344 23,939 3,104 7,208 8,010 4,582 16,325 46,110 94,492 -
Subtotal
328,400
South Park Elementary School SANITATION SERVICES CUSTODIAL CLEANING SERVICES MAINT/REPAIR SERVICES WATER/SEWER SERVICE SERVICE AGREEMENT-GEN. EQUIP. CUSTODIAL SUPPLIES MAINTENANCE SUPPLIES NATURAL GAS ELECTRICITY EQUIPMENT-NEW EQUIPMENT-REPLACE
4,900 102,500 20,000 4,000 13,200 8,500 15,000 51,000 89,000 82,000 -
Subtotal
$
390,100
$
2017-18 Budget
% of Budget
6/30/17 26,217 190,989 1,278,513 2,336 7,684 39,197 89,366 40,083 637 42,447 680 3,950 6,769 102,173 37,767 1,496 10,261 98,868 256,417 75,660 -
District Wide Services CUSTODIAN OVERTIME SUMMER CUSTIODIAL SALARIES ADMINISTRATIVE SERVICES PROFESSIONAL SERVICES SANITATION SERVICES CUSTODIAL CLEANING SERVICES MAINT/REPAIR SERVICES TELEPHONE SERVICE WATER/SEWER SERVICE SERVICE AGREEMENT-GEN. EQUIP. HVAC SERVICE AGREEMENT GENERAL SUPPLIES CUSTODIAL SUPPLIES MAINTENANCE SUPPLIES GAS-DIST VEHICLES NATURAL GAS ELECTRICITY LANDSCAPING EQUIPMENT-NEW EQUIPMENT-REPLACEMENT PERF CONTRACT - INTEREST PERF CONTRACT - PRINCIPAL
Kipling Elementary School SANITATION SERVICES CUSTODIAL CLEANING SERVICES MAINT/REPAIR SERVICES WATER/SEWER SERVICE SERVICE AGREEMENT-GEN. EQUIP. CUSTODIAL SUPPLIES MAINTENANCE SUPPLIES NATURAL GAS ELECTRICITY EQUIPMENT-NEW EQUIPMENT-REPLACEMENT
2016-17 Actual (Unaudited)
Budget
% of Budget
86
25,000 175,000 1,100,000 10,000 10,000 36,000 20,000 30,000 1,000 20,000 80,000 5,000 8,000 60,000 15,000 1,000 20,000 55,000 737,000 -
152% 426% 359% 110% 241% 127% 63% 265% 0% 135% 130% 56% 85% 58% 193% 87%
-
$
390,100
$
491,602
25,000 150,000 500,000 8,000 12,000 40,000 45,000 34,000 1,000 50,000 75,000 4,000 8,000 75,000 35,000 1,000 18,000 70,000 632,000 75,660
89% 46% 105% 62% 59% 61% 302%
126%
$
490,100
Deerfield Public School District #109 FY 2017-18 Budget Detail Operations & Maintenance
Account Number
20 20 20 20 20 20 20 20 20 20 20
130 130 130 130 130 130 130 130 130 130 130
2540 2540 2540 2540 2540 2540 2540 2540 2540 2540 2540
3210 3222 3235 3700 3931 4160 4162 4650 4660 5410 5420
Description
00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00
Walden Elementary School SANITATION SERVICES CUSTODIAL CLEANING SERVICES MAINT/REPAIR SERVICES WATER/SEWER SERVICE SERVICE AGREEMENT-GEN. EQUIP. CUSTODIAL SUPPLIES MAINTENANCE SUPPLIES NATURAL GAS ELECTRICITY EQUIPMENT-NEW EQUIPMENT-REPLACEMENT
Subtotal 20 20 20 20 20 20 20 20 20 20 20
140 140 140 140 140 140 140 140 140 140 140
2540 2540 2540 2540 2540 2540 2540 2540 2540 2540 2540
3210 3222 3235 3700 3931 4160 4162 4650 4660 5410 5420
00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00
20 20 20 20 20 20 20 20 20 20 20
250 250 250 250 250 250 250 250 250 250 250
2540 2540 2540 2540 2540 2540 2540 2540 2540 2540 2540
3210 3222 3235 3700 3931 4160 4162 4650 4660 5410 5420
00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00
260 260 260 260 260 260 260 260 260 260 260
2540 2540 2540 2540 2540 2540 2540 2540 2540 2540 2540
3210 3222 3235 3700 3931 4160 4162 4650 4660 5410 5420
00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00
$
290,400
$
4,900 109,500 25,000 4,000 10,500 8,500 15,000 55,000 82,000 65,000 $
Shepard Middle School SANITATION SERVICES CUSTODIAL CLEANING SERVICES MAINT/REPAIR SERVICES WATER/SEWER SERVICE SERVICE AGREEMENT-GEN. EQUIP. CUSTODIAL SUPPLIES MAINTENANCE SUPPLIES NATURAL GAS ELECTRICITY EQUIPMENT-NEW EQUIPMENT-REPLACEMENT
Subtotal 20 20 20 20 20 20 20 20 20 20 20
4,900 85,000 20,000 4,000 8,500 8,500 15,000 41,000 55,000 48,500 -
Wilmot Elementary School SANITATION SERVICES CUSTODIAL CLEANING SERVICES MAINT/REPAIR SERVICES WATER/SEWER SERVICE SERVICE AGREEMENT-GEN. EQUIP. CUSTODIAL SUPPLIES MAINTENANCE SUPPLIES NATURAL GAS ELECTRICITY EQUIPMENT-NEW EQUIPMENT-REPLACEMENT
Subtotal
2015-16 Actual
Budget
379,400
$
4,900 148,500 30,000 5,000 21,200 8,500 25,000 66,000 107,000 375,800 $
Caruso Middle School SANITATION SERVICES CUSTODIAL CLEANING SERVICES MAINT/REPAIR SERVICES WATER/SEWER SERVICE SERVICE AGREEMENT-GEN. EQUIP. CUSTODIAL SUPPLIES MAINTENANCE SUPPLIES NATURAL GAS ELECTRICITY EQUIPMENT-NEW EQUIPMENT-REPLACEMENT
791,900
$
4,900 151,500 30,000 5,000 16,000 8,500 25,000 43,000 117,000 309,500 -
2,754 75,651 38,571 2,580 6,779 7,950 4,965 24,255 46,499 1,983 -
56% 89% 193% 65% 80% 94% 33% 59% 85% 4%
211,987
73%
2,754 110,159 54,188 3,021 8,461 7,931 7,096 24,363 75,774 29,171 -
56% 101% 217% 76% 81% 93% 47% 44% 92% 45%
322,918
85%
2,754 155,064 46,080 3,691 17,957 12,224 10,576 21,321 93,650 100,364 -
56% 104% 154% 74% 85% 144% 42% 32% 88% 27%
463,681
59%
2,758 156,572 62,062 4,671 8,861 8,843 15,882 21,067 94,660 117,831 -
56% 103% 207% 93% 55% 104% 64% 49% 81% 38%
2016-17 Actual
Budget
% of Budget
4,500 92,500 32,900 4,000 8,500 10,000 10,000 38,000 55,000 35,000 $
290,400
$
4,500 120,000 40,000 4,000 10,500 10,000 13,000 50,000 82,000 45,400 $
379,400
$
4,500 152,000 42,000 4,500 23,000 12,000 22,000 55,000 107,000 369,900 $
791,900
$
4,500 155,000 45,000 5,000 16,000 12,500 25,000 40,000 117,000 290,400 -
2017-18 Budget
% of Budget
5,801 79,404 35,568 2,688 5,027 8,217 20,174 24,356 45,632 117,217 -
129% 86% 108% 67% 59% 82% 202% 64% 83% 335%
344,084
118%
5,784 114,129 131,853 3,529 6,817 8,745 14,028 30,635 59,315 80,870 -
129% 95% 330% 88% 65% 87% 108% 61% 72% 178%
455,705
120%
5,784 163,078 98,411 3,790 9,665 9,846 21,755 33,741 74,512 68,037 -
129% 107% 234% 84% 42% 82% 99% 61% 70% 18%
488,619
62%
6,073 163,685 68,835 4,186 8,496 9,368 27,584 28,051 80,324 104,450 -
135% 106% 153% 84% 53% 75% 110% 70% 69% 36%
5,000 89,500 32,900 3,000 7,000 9,000 18,000 28,000 48,000 150,000
$
390,400
5,500 120,000 60,000 3,500 9,500 9,000 13,000 40,000 68,900 150,000
$
479,400
7,000 155,000 95,000 4,000 20,000 11,000 30,000 55,000 107,000 300,000
$
784,000
5,000 155,000 60,000 4,500 7,500 10,000 25,000 40,000 117,000 320,040
Subtotal
$
710,400
$
493,207
69%
$
710,400
$
501,052
71%
$
744,040
Operations & Maintenance Total
$
5,298,600
$
4,965,063
94%
$
5,298,600
$
5,041,437
95%
$
5,175,000
87
Deerfield Public School District #109 FY 2017-18 Budget Detail Other Funds
Account Number
Description
Debt Service Fund 30 000 5140 6200 00 00 BOND INTEREST 30 000 5200 6100 00 00 BOND PRINCIPAL 30 000 5200 6400 00 00 DUES & FEES
Subtotal Capital Projects Funds 60 000 2530 3111 00 00 CONSTRUCTION SERVIES 60 000 2530 5234 00 00 CONSTRUCTION MATERIALS
Subtotal
Budget
2015-16 Actual
% of Budget
Budget
2016-17 Actual (Unaudited)
% of Budget
2017-18 Budget
6/30/17
854,018 1,685,000 15,000
854,018 460,000 2,226
100% 27% 15%
732,728 350,000 15,000
808,388 350,000 3,312
110% 100% 22%
708,308 390,000 16,000
2,554,018
1,316,244
52%
1,097,728
1,161,700
106%
1,114,308
636,000 1,764,000
684,591 2,922,208
108% 166%
400,000 3,000,000
145,731 2,323,398
36% 77%
500,000 750,000
2,400,000
3,606,799
150%
3,400,000
2,469,129
73%
1,250,000
1,900,000
112,979
6%
2,000,000
251,480
13%
1,109,000
1,900,000
112,979
6%
2,000,000
251,480
13%
1,109,000
Fire Prevention & Life Safety Fund 90 000 2530 5400 00 00 CONSTRUCTION CAP OUTLAY
88
Deerfield Public School District #109 FY 2017-18 Budget Detail MISCELLANEOUS SALARIES
2015-16 Budget
Account Number
10 10 10 10 10 10 10
110 120 130 140 090 070 000
1110 1110 1110 1110 1110 1110 1110
1220 1220 1220 1220 1220 1321 1325
00 00 00 00 00 00 00
00 00 00 00 00 95 00
Description Education Fund Elementary Salaries IN-SCHOOL SUBSTITUTES IN-SCHOOL SUBSTITUTES IN-SCHOOL SUBSTITUTES IN-SCHOOL SUBSTITUTES SUBS-TEACHERS INSTRUMENTAL MUSIC STIPENDS SEVERANCE/RETIREMENT
Subtotal
10 090 1110 2111 10 000 1110 2150
Elementary Benefits 00 94 TRS - BOARD EXPENSE 00 00 TRS-EARLY RETIREMENT
10 10 10 10 10 10
110 120 130 140 250 260
1500 1500 1500 1500 1500 1500
1321 1321 1321 1321 1321 1321
00 00 00 00 00 00
10 10 10 10 10
110 120 130 140 250 260
070 070 080 070 070
1500 1500 1500 1500 1500 1500
1600 1600 1600 1600 1600
2111 2111 2111 2111 2111 2111
1110 1120 1120 1152 1155
00 00 00 00 00 00
00 00 00 00 00
00 00 00 00 00 00
06 06 12 06 06
38
16,987
15,000 10,000
14,753 17,649
Subtotal
25,000
32,402
Interscholastic Salaries EXTRA-DUTY STIPENDS EXTRA-DUTY STIPENDS EXTRA-DUTY STIPENDS EXTRA-DUTY STIPENDS EXTRA-DUTY STIPENDS EXTRA-DUTY STIPENDS
9,000 10,000 9,000 10,000 130,000 179,700
13,144 14,336 10,521 9,777 141,770 189,959
347,700
379,507
100 100 100 100 2,000 2,000
180 177 120 130 1,505 2,064
Subtotal
4,400
4,176
Summer School Salaries ADMINISTRATION SALARIES TEACHERS SALARIES TEACHERS SALARIES SECRETARIES SALARIES AIDES SALARIES
80,000 10,000
103,057 14,871
90,000
117,928
1,425
1,253
1,425
1,253
15,000 35,500 20,000
30,030 36,710 116,202
Interscholastic Benefits TRS - BOARD EXPENSE TRS - BOARD EXPENSE TRS - BOARD EXPENSE TRS - BOARD EXPENSE TRS - BOARD EXPENSE TRS - BOARD EXPENSE
Summer School Benefits 00 06 TRS - BOARD EXPENSE
Improvement of Instr Salaries 00 18 SUBS-TEACHERS 00 00 NBCT STIPENDS/TEACHER MENTOR 00 18 CURR WORK/INSERV STIPENDS
197% 95% 120% 91% 139% 138% 52%
0% 0%
-
6,200
Subtotal
10 070 2210 1220 10 090 2210 1321 10 070 2210 1322
50,040 100,000
1,216 15,771 -
Subtotal
10 070 1600 2111
935,045
1,200 5,000
Subtotal
10 10 10 10 10 10
1,134,852
131,157
Special Education Salaries 00 12 SUBS-I E P MEETINGS 00 12 SPECIAL EDUC STIPENDS
00 00 00 00 00 00
11,243 4,570 6,950 5,733 499,188 20,685 386,676
148,380
Subtotal
10 080 1200 1220 10 080 1200 1321
5,700 4,820 5,795 6,270 360,000 15,000 737,267
122,412 4,260 4,485
Middle School Benefits 00 00 TRS - BOARD EXPENSE 00 00 TRS-EARLY RETIREMENT 00 00 EMPLOYEE ASSIST PROG
2017-18
Actual
% of Budget
Budget
6/30/17
140,000 2,500 5,880
Middle School Salaries 00 00 SUBS-TEACHERS 00 00 IN-SCHOOL SUBSTITUTES 00 00 IN-SCHOOL SUBSTITUTES
Budget
(Unaudited)
38
Subtotal
10 090 1120 2111 10 000 1120 2150 10 090 1120 2400
% of Budget
150,040
Subtotal
10 090 1120 1220 10 250 1120 1220 10 260 1120 1220
2016-17
Actual
87% 170% 76%
101% 0%
98% 176%
146% 143% 117% 98% 109% 106%
180% 177% 120% 130% 75% 103%
129%
149%
88%
200% 103% 581%
89
5,700 4,820 5,795 6,270 360,000 15,000 737,267
5,808 10,050 7,920 6,545 387,144 24,597 253,067
1,134,852
695,131
50,040 100,000
29 -
102% 209% 137% 104% 108% 164% 34%
5,700 4,820 5,795 6,270 360,000 15,000 246,000 643,585
0% 0%
50,040 -
150,040
29
50,040
140,000 2,500 5,880
121,066 6,098 5,527
148,380
132,691
1,200 5,000
1,262 -
6,200
1,262
15,000 10,000
17,215 12,266
25,000
29,481
9,000 8,000 9,000 10,000 130,000 134,700
10,142 15,342 9,928 9,241 157,587 166,010
300,700
368,250
100 100 100 100 2,000 2,000
144 202 118 131 1,744 1,745
4,400
4,084
80,000 10,000
104,597 15,545
155%
80,000 10,000
90,000
120,142
133%
90,000
1,425
1,659
116%
1,425
1,425
1,659
35,500 20,000
29,368 42,809 60,679
86% 244% 94%
140,000 2,500 5,880 148,380
105% 0%
1,200 5,000 6,200
115% 123%
40,000 20,000 60,000
113% 192% 110% 92% 121% 123%
9,000 8,000 9,000 10,000 161,500 147,000 344,500
144% 202% 118% 131% 87% 87%
100 100 100 100 2,000 2,000 4,400
131%
1,425
121% 303%
35,500 20,000
Deerfield Public School District #109 FY 2017-18 Budget Detail MISCELLANEOUS SALARIES
2015-16 Budget
Account Number
2016-17
Actual
% of Budget
Budget
Description
Subtotal
2017-18
Actual
% of Budget
Budget
(Unaudited)
70,500
182,942
500
1,869 512
500
2,381
150
-
150
-
55,500
132,856
500
1,121 608
500
1,729
150
-
150
-
55,500
Improvement of Instr Benefits
10 070 2210 2111 10 090 2210 2111
00 18 TRS - BOARD EXPENSE 00 00 TRS - BOARD EXPENSE
Subtotal
10 070 2290 2111
Other Instr Support Benefits 00 00 TRS - BOARD EXPENSE
Subtotal
10 000 2320 2225 10 090 2400 1200
School Administration Salaries 00 00 TUITION REIMBURSEMENT 00 00 TEMPORARY SALARIES
Subtotal
10 10 10 10 10 10
110 120 130 140 250 260
2560 2560 2560 2560 2560 2560
1155 1155 1155 1155 1155 1155
00 00 00 00 00 00
00 00 00 00 00 00
Food Services Salaries LUNCH SUPERVISION LUNCH SUPERVISION LUNCH SUPERVISION LUNCH SUPERVISION LUNCH SUPERVISION LUNCH SUPERVISION
Subtotal
10 250 2560 2111 10 260 2560 2111
Food Services Benefits 00 00 TRS - BOARD EXPENSE 00 00 TRS - BOARD EXPENSE
Subtotal
Operations & Maintenance Fund O & M Salaries 20 000 2540 1300 O & M Overtime 20 000 2540 1291 O & M Summer Help
Subtotal
50 070 1110 2140
IMRF Fund Elementary Benefits 00 95 MEDICARE ONLY
Subtotal
51 000 1120 2120
Middle School Benefits 00 00 IMRF
Subtotal
50 110 2220 2140
Media Services Benefits 00 00 MEDICARE ONLY
Subtotal
50 060 2560 2140
Food Services Benefits 00 84 MEDICARE ONLY
Subtotal
45,000 8,000
34,529 -
53,000
34,529
50,500 48,500 44,500 55,500 22,000 21,000
63,736 54,095 50,551 58,652 18,461 23,382
242,000
268,877
275 250
198 251
525
449
25,000 175,000
26,217 190,989
200,525
217,655
2,500
7,019
2,500
102%
0%
77% 0%
122%
650 500 1,150
0%
150 150
45,000 8,000
23,396 15,075
53,000
38,471
66,216 66,216 66,216 66,216 22,000 21,000
66,141 61,582 67,441 66,061 18,399 24,165
307,864
303,789
275 250
188 220
525
408
25,000 175,000
24,481 161,532
200,525
186,421
2,500
7,853
7,019
2,500
7,853
2,500
240,000
-
-
-
-
240,000
-
-
-
-
126% 112% 114% 106% 84% 111%
72% 100%
105% 109%
281%
52% 188%
45,000 8,000 53,000
100% 93% 102% 100% 84% 115%
68,352 68,352 68,352 68,352 22,000 23,000 318,408
68% 88%
275 250 525
98% 92%
25,000 150,000 175,000
314%
59%
2,500
1,793
1,008
2,021
1,187
500
1,793
1,008
2,021
1,187
500
550
-
550
-
550
550
-
550
-
550
90
Section 4 – Informational Property Taxes 91 Tax Levy Process 91 Property Tax Extension Limitation Law (PTELL) 92 Tax Increment Financing (TIF) Districts 92 Property Assessment 93 Historical and Projected Consumer Price Index (CPI) 94 Historical Equalized Assessed Valuation 95‐96 Historical and Projected EAV Growth 97 Historical Tax Rates vs. Other Local Governments and School Districts 98 Historical Tax Rates, Extensions, and Collections 99 Projected Tax Extensions 100 Estimated Drivers of Growth in Property Tax Revenue 101 Impact on Taxpayers……………………………………………………………………………………………………………102 Total Governmental Funds – 3 Year Projection 103 Chart – Governmental Funds 3 Year Projection of Revenue, Expenditures and Fund Balance……………………………………………………………………………………………………………………...104 Aggregate Fund Balances…………………………………………………………………………………………………….105 Educational Fund – 3 Year Projection 106 Chart – Educational Fund 3 year Projection of Revenue, Expenditures and Fund Balance 107 Operations & Maintenance Fund – 3 Year Projection 108 Chart – Operations & Maintenance Fund 3 Year Projection of Revenue, Expenditures and Fund Balance 109 Transportation Fund – 3 Year Projection 110 Chart – Transportation Fund 3 year Projection of Revenue, Expenditures and Fund Balance 111 Municipal Retirement / Social Security Fund – 3 Year Projection 112 Debt Service Fund – 3 Year projection 113 Historical Legal Bonded Debt Margin 114 Projected Long Term Obligations 115 Capital Projects Fund – 3 Year Projection 116 Fire Prevention & Safety Fund – 3 Year projection 117 Fund Balance 118 Chart – Fund Balance 119 Student Enrollment 120 Chart – Student Enrollment 121‐122 Low Income percentage………………………………………………………………………………………………………123 Chronic Truancy rates………………………………………………………………………………………………………….123 Staffing 124 School District Financial Profile 125‐127 Administrative Cost Worksheet 128 Performance Measurement – Historical Illinois Standards Achievement Test (PARCC) Trends…………………………………………………………………………………………………………………………………129‐133 MAP Test Results………….…………………………………………………………………………………………………….134‐136 Stakeholder Satisfaction Survey…………………………………………………………………………………………..137
Property Taxes The primary source of revenue for Deerfield Public Schools District 109 is local property tax. It represents 92% of FY2018 budgeted governmental fund revenue. Illinois real property values are determined annually on a calendar year basis. Property assessments for the year 2016 are payable in year 2017. The District is located in Lake County, Illinois, where property taxes are payable in June and September. It is the intention to use the entire 2016 property tax levy during the 2017‐2018 fiscal year. Tax Levy Process Each year the Board of Education must determine how much money needs to be raised through taxation to support the operation of the school for the coming year. This request, called the levy, is made to the Lake County Clerk before the last Tuesday in December. If the amount of this levy, excluding taxes for debt service payments, is more than a 5% increase over the prior year’s levy, a public hearing must be held prior to its adoption by the Board. The Board of Education has the authority to levy separate taxes for the following purposes: Education, Liability Insurance, Special Education, Operations, Life Safety, Leasing Facilities, Debt Service, Transportation, Municipal Retirement, Social Security, Working Cash, Summer School, and Tort Judgments. The 2016 levy included amounts extended for Education, Special Education, Operations & Maintenance, Debt Service, Transportation, Municipal Retirement, and Social Security funds. Purpose
District Maximum
Education
Legal Maximum
2016 District Rate
$2.730
$3.500
$2.441
Liability Insurance
as needed
as needed
‐
Special Education
0.400
0.400
0.043
Operations & Maintenance
0.370
0.550
.368
Life Safety
0.100
0.100
‐
Leasing Facilities
0.050
0.050
‐
as needed
as needed
0.068
0.120
as needed
0.081
Municipal Retirement
as needed
as needed
0.030
Social Security
as needed
as needed
0.039
0.050
0.050
‐
Debt Service Transportation
Capital Projects
$3.070 The tax rate actually extended is calculated by dividing the tax levy by the total value of all taxable real property within the District, known as the Equalized Assessed Value (EAV). The tax rate is 91
always reported as dollars per $100 of EAV. This extension is subject to State and District maximum tax rates as well as the Property Tax Extension Limitation Law (PTELL), commonly referred to as the tax cap. Property Tax Extension Limitation Law (PTELL)1 PTELL became effective in Lake County on October 1, 1991 for taxes payable in 1992. The law is designed to slow the rate of growth in taxes by reducing tax rates when property values are growing faster than the rate of inflation. PTELL limits the increase in property tax extensions (excluding taxes for Debt Service) to the lesser of 5% or the percent increase in the National Consumer Price Index for All Urban Consumers (CPI‐U) for the previous levy year. The PTELL allows the district to receive a limited inflationary increase on existing property, plus an additional amount for new property just added to the tax base. An increase in taxes in excess of the PTELL must be approved by the voters through a referendum. April 5, 2005 a successful referendum to increase the tax rate by 0.350 was passed with the support of two‐thirds of the voters. This increase was phased in over the next 4 years. Tax Increment Financing (TIF) Districts Illinois law allows local governments the ability to designate areas within their jurisdiction as TIF districts. These specially designated districts are used as a way to spur economic growth with the hope of encouraging new economic development and jobs. When a TIF is created, future tax revenue from the increased site value generated by development (the tax increment) is dedicated to finance the debt issued to pay for the project. When a TIF expires, the taxes begin to flow back to the local governmental units and the full amount of property value is added to the tax base as “new growth”. In tax year 2009 the Downtown Deerfield TIF district expired adding almost $78 million or 4% to the District’s equalized assessed value. This accounted for $1.8 million of the $2.3 million in property tax increase for the district. Some excess tax revenue generated by the TIF district may be rebated from time to time. The District received extraordinary TIF rebates of $612,842 in 2006‐07, and $2,055,435 in 2009‐10. As of 2010‐11, the TIF District was abolished and there are no further TIF rebates.
1 http://www.revenue.state.il.us/LocalGovernment/PropertyTax/ptell.htm 92
Property Assessment Illinois law requires all assessment officials to determine the valuation of property as of January 1 of the tax year using sales data from the prior three years. So values for the 2016 tax year were determined as of January 1, 2016 using sales from 2013, 2014 and 2015. This creates a lag which smoothes the effects of market swings, providing stability to the assessment system, but it means that assessed values will be understated during periods of rising market values and overstated when market values are falling. Every four years the assessor does a general assessment utilizing a combination of the three traditional approaches to value. These three methods are the cost approach (what it would cost to build a house today), the market or sales comparison approach (which analyzes similar properties that have sold recently where both buyer and seller acted without undue pressure in negotiating the price) and the income approach (most often used for commercial/industrial property). The next General Assessment in Lake County, Illinois will be in tax year 2016 for taxes payable in 2017. In years between general assessments, the state and local assessors apply a multiplier, or equalization factor – which is a uniform percentage increase or decrease – to assessed values of various areas or classes of property in order to bring the three‐year average of the median assessment levels in a township to 33.33% of market value, which is our statutory requirement in Illinois. Equalized Assessed Value (EAV) is only used to apportion the total tax extension to individual taxpayers. A taxpayer pays a share of the total tax extension equal to their proportional share of the total EAV. So if EAV falls at the same rate for all households in periods of contracting property values, a taxpayer’s proportional share of EAV remains the same. Falling market values generally do not translate into lower taxes.
93
Historical and Projected Consumer Price Index
Tax Levy Year
CPI Base Year
School Year
CPI Index
PTELL Limiting %
*2019 *2018 *2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003 2002 2001 2000 1999 1998 1997 1996 1995
2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003 2002 2001 2000 1999 1998 1997 1996 1995 1994
2020-21 2019-20 2018-19 2017-18 2016-17 2015-16 2014-15 2013-14 2012-13 2011-12 2010-11 2009-10 2008-09 2007-08 2006-07 2005-06 2004-05 2003-04 2002-03 2001-02 2000-01 1999-00 1998-99 1997-98 1996-97
2.00% 0.00% 0.00% 0.70% 0.80% 1.50% 1.70% 3.00% 1.50% 2.70% 0.10% 4.10% 2.50% 3.40% 3.30% 1.90% 2.40% 1.60% 3.40% 2.70% 1.60% 1.70% 3.30% 2.50% 2.70%
2.00% 0.00% 0.00% 0.70% 0.80% 1.50% 1.70% 3.00% 1.50% 2.70% 0.10% 4.10% 2.50% 3.40% 3.30% 1.90% 2.40% 1.60% 3.40% 2.70% 1.60% 1.70% 3.30% 2.50% 2.70%
* Projected Source:
United States Bureau of Labor Statistics 12 month percentage change - December Consumer Price Index - All Urban Consumers Not Seasonally Adjusted
94
Deerfield Public Shools District 109 Historical Equalized Assessed Valuation (EAV) Tax Levy Year 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005
Equalized Assessed Valuation Chg vs PY $ 1,641,317,738 $ 95,301,498 1,546,016,240 $ 105,685,263 1,440,330,977 $ 5,795,534 1,434,535,443 (70,577,694) 1,505,113,137 (110,286,256) 1,615,399,393 (120,005,338) 1,735,404,731 (85,246,619) 1,820,651,350 12,399,010 1,808,252,340 44,994,443 1,763,257,897 167,236,849 1,596,021,048 153,495,492 1,442,525,556 193,702,233
% chg vs Estimated Market PY Value 6.2% $ 4,923,953,214 7.3% $ 4,638,048,720 0.4% $ 4,320,992,931 -4.7% 4,303,606,329 -6.8% 4,515,339,411 -6.9% 4,846,198,179 -4.7% 5,206,214,193 0.7% 5,461,954,050 2.6% 5,424,757,020 10.5% 5,289,773,691 10.6% 4,788,063,144 15.5% 4,327,576,668
Student Enrollment School Year 2,942 2017-18 2,960 2016-17 3,030 2015-16 3,042 2014-15 3,121 2013-14 3,074 2012-13 3,121 2011-12 3,180 2010-11 3,168 2009-10 3,177 2008-09 3,140 2007-08 3,139 2006-07
EAV/Student $ 557,892 $ 522,303 $ 475,357 471,576 482,253 525,504 556,041 572,532 570,787 555,007 508,287 459,549
* Projected Source: District Annual Financial Audits 2002-2013, Lake County Clerk
Billions
Equalized Assessed Valuation $600,000
$2.0 $1.8
$500,000
$1.6 $1.4
$400,000
$1.2 $1.0
EAV
$300,000
EAV/Student $0.8 $200,000
$0.6 $0.4
$100,000
$0.2 $‐ 2004
2005
2006
2007
2008
2011
2012
2013
2014
$‐ 2015
67 106
Deerfield Public Schools District 109 has one of the lowest taxable property values per student of its peer group.
1,200,000 1,000,000
2010
2016‐17 EAV per Student
1,600,000 1,400,000
2009
29 Deerfield SD109
800,000
36
28
65
Peer Districts 27
37
35
31
38
600,000
30
103
112
109 39
400,000 200,000 0 Source: Annual Financial Reports, Illinois State Board of Education
95
102
96
70
34
Deerfield Public Schools District 109 Historical Equalized Assessed Valuation (EAV)
EAV % by Township
7.5%
12.8%
Moraine
2016
2006
Vernon West Deerfield
79.7%
Source: Lake County Clerk
Total EAV Growth in West Deerfield Township has outpaced Vernon and Moraine Townships by an average of 5 percentage points per year over the last decade.
EAV Breakdown by Property Class 100% 90%
2% 18%
14%
4%
5%
4%
8%
7%
14% 16% 16%
80%
34%
7% 25%
70% 20% 60% Railroad & Other 50% 40% 30%
Farm 81%
84%
Industrial 80%
76% 61%
Commercial 63%
57%
Residential
20% 10% 0% NSSED Peer Lake County* Cook County* Collar Counties* Deerfield Public Average Cook County Clerk, Illinois Department of Revenue Source: Schools District Lake County Clerk, 109
Rest of State*
State of Illinois*
*2015 EAV net of exemptions
Source: Lake County Clerk, Cook County Clerk, Illinois Department of Revenue
Deerfield Public Schools District 109 has an average EAV property class composition for Lake County, IL
96
Historical and Projected EAV Growth
Tax Levy Year 2020 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006
Total Equalized Assessed Value P P p p
Change in value of existing property $ % 55,101,000 3.00% 35,818,000 2.00% 39,822,000 2.29% 84,760,262 5.16% 81,765,041 5.29% 98,133,996 6.81% (1,466,878) -0.10% (78,904,278) -5.24% (119,295,957) -7.38% (131,351,877) -7.57% (100,677,880) -5.53% (79,557,372) -4.40% 21,496,919 1.22% 121,703,142 7.63% 125,824,162 8.72%
1,901,819,000 1,836,718,000 1,790,900,000 1,741,078,000 1,641,317,738 1,546,016,240 1,440,330,977 1,434,535,443 1,505,113,137 1,615,399,393 1,735,404,731 1,820,651,350 1,808,252,340 1,763,257,897 1,596,021,048
Increase due to New Construction $ % 10,000,000 0.54% 10,000,000 0.56% 10,000,000 0.57% 15,000,000 0.91% 13,536,457 0.88% 7,551,267 0.52% 7,262,412 0.51% 8,326,584 0.55% 9,009,701 0.56% 11,346,539 0.65% 15,431,261 0.85% * 91,956,382 5.09% 23,497,524 1.33% 45,533,707 2.85% 27,671,330 1.92%
Total Increase $ 65,101,000 45,818,000 49,822,000 99,760,262 95,301,498 105,685,263 5,795,534 (70,577,694) (110,286,256) (120,005,338) (85,246,619) 12,399,010 44,994,443 167,236,849 153,495,492
% 3.54% 2.56% 2.86% 6.08% 6.16% 7.34% 0.40% -4.69% -6.83% -6.92% -4.68% 0.69% 2.55% 10.48% 10.64%
* Expired Downtown Deerfield Tax Incentive Financing (TIF) District of $77,877,782 ** Expired Lake Cook/Brickyard Tax Incentive Financing (TIF) District of $87,507,870
Annual EAV Growth (Tax Year)
$200,000,000
New Growth Chg in assessment existing property
Actual
Projected $150,000,000
$100,000,000
$50,000,000
$‐ 2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
$(50,000,000)
Decline in existing EAV offset by TIF expiration
$(100,000,000)
$(150,000,000) Source: Lake County Clerk
97
Deerfield Public Schools District 109 Loacl Government Tax Rate Comparison 2006-2016 Tax Years
2016 0.549 0.632 2.187 0.542 0.193 0.285 0.012 0.612 0.034
Village of Deerfield County of Lake High School District #113 Deerfield Park District Lake County Forest Preserve District Community College District#532 South Lake County Mosquito Abatement Dis Deerfield-Bannockburn Fire Protection Distri Township of West Deerfield Total Overlapping Governments
$
5.047
Deerfield Public School District #109
2015 0.893 0.663 2.309 0.552 0.208 0.299 0.012 0.624 0.037 $
$3.070
Total Tax Rate
$
8.117
$
8.117
Dist #109 % of Total
$
$3.211 $
8.808
$
8.808
37.8%
Representative Tax rate
5.598
2014 0.875 $ 0.682 2.421 0.598 0.210 0.306 0.013 0.650 0.039 5.794
$
3.401 $
9.195
$
9.195
36.4%
2013 0.784 $ 0.047 2.364 0.585 0.218 0.296 0.007 0.637 0.041
2012 0.719 $ 0.608 2.178 0.546 0.212 0.272 0.015 0.588 0.038
2011 0.605 $ 0.554 2.167 0.503 0.201 0.240 0.014 0.529 0.033
2010 0.443 $ 0.505 1.921 0.460 0.198 0.218 0.013 0.486 0.033
2009 0.369 $ 0.464 1.748 0.431 0.200 0.200 0.012 0.447 0.031
2008 0.357 $ 0.453 1.660 0.419 0.199 0.196 0.011 0.426 0.029
2007 0.356 $ 0.444 1.619 0.402 0.201 0.192 0.011 0.410 0.028
2006 0.365 0.450 1.635 0.417 0.204 0.195 0.012 0.435 0.029
4.979
5.176
4.846
4.277
3.902
$
3.750
$
3.663
$
3.742
2.455 $
2.346
$
2.286
$
2.366
$
6.096
$
5.949
$
6.108
$
6.096
$
5.949
$
6.108
$
3.424 $
8.403
$
8.403
37.0%
$
3.254 $
8.430
$
8.430
40.7%
$
2.892 $
7.738
$
7.738
38.6%
$
2.665 $
6.942
$
6.942
37.4%
$
6.357
$
6.357
38.4%
38.6%
38.5%
38.4%
38.7%
100% Township of West Deerfield
90%
80%
South Lake County Mosquito Abatement District
70%
60%
50% % of Total Tax Bill
40%
30%
20%
10%
2005
2006
2007
2008
2009
2010
2011
2012
2013
0% 2015
2014
Source: Lake County Clerk
Total 2016 Tax Rate per $100 Assessed Value vs other Local School Districts $4.50 38 $4.00 96 27 $3.50
35
102
36
39 30
28
34
29
$3.00
31
37
109 70
103
112 106 65
$2.50 Peer Districts School District 109 $2.00
$1.50
67
$1.00
$0.50
$‐
Source: Lake County Clerk Office, Cook County Clerk Office
98
Deerfield Public Schools - District 109 Schedule of assessed valuations, tax rates, extensions, and collections Last Ten Tax Levy Years
Assessed valuation
2016
2015
2014
2013
2012
2011
2010
1,641,317,738
1,546,016,240
1,440,330,977
1,434,535,443
1,505,113,137
1,615,399,393
1,735,404,731
2.441 0.043 0.368 0.068 0.081 0.030 0.040 0.000
2.536 0.043 0.393 0.071 0.089 0.034 0.045 0.000
2.725 0.039 0.417 0.075 0.074 0.029 0.042 -
2.707 0.037 0.393 0.150 0.070 0.027 0.04 -
2.392 0.032 0.492 0.212 0.067 0.023 0.036 -
2.265 0.028 0.317 0.157 0.066 0.023 0.036 -
2.070 0.025 0.283 0.175 0.060 0.020 0.032 -
1.945 0.023 0.225 0.165 0.055 0.021 0.021 -
1.854 0.022 0.218 0.159 0.053 0.020 0.020 -
1.732 0.022 0.225 0.160 0.060 0.016 0.016 0.055
1.818 0.022 0.217 0.172 0.058 0.013 0.013 0.053
3.070
3.211
3.401
3.424
3.254
2.892
2.665
2.455
2.346
2.286
2.366
TAX RATES Educational Special Educational Operations & Maintenance Debt Service Transportation Municipal Retirement Social Security Fire Prevention & Safety
TAX EXTENSIONS Educational Special Educational Operations & Maintenance Debt Service Transportation Municipal Retirement Social Security Fire Prevention & Safety
2009
$ 1,820,651,350
2008
$ 1,808,252,340
2007
$ 1,763,257,897
2006
$ 1,596,021,048
$
40,060,610 708,869 6,045,105 1,112,190 1,327,284 488,243 649,190 -
$
39,209,353 661,169 6,073,602 1,104,459 1,371,255 526,233 691,533 -
$
39,247,176 565,488 6,006,295 1,079,514 1,069,835 412,655 611,334 -
$
38,832,874 530,778 5,637,724 2,151,802 1,004,175 387,325 573,814 -
$
36,002,306 481,636 7,405,157 3,190,840 1,008,426 346,176 541,841 -
$
36,588,796 452,312 5,120,816 2,536,177 1,066,164 371,542 581,544 0
$
35,922,878 433,851 4,911,195 3,036,958 1,041,243 347,081 555,330 0
$
35,411,669 418,750 4,096,466 3,004,075 1,001,358 382,337 382,337 -
$
33,524,998 397,816 3,941,990 2,875,121 958,374 361,650 361,650 -
$
30,539,627 387,917 3,967,330 2,821,213 1,057,955 282,121 282,121 969,792
$
29,015,663 351,124 3,463,366 2,745,156 925,692 207,483 207,483 845,891
$
50,391,491
$
49,637,603
$
48,992,296
$
49,118,493
$
48,976,381
$
46,717,350
$
46,248,536
$
44,696,991
$
42,421,599
$
40,308,076
$
37,761,858
$
49,536,090
$
48,898,240
$
49,047,295
$
48,896,914
$
46,707,531
$
46,134,273
$
44,634,683
$
42,364,188
$
40,233,232
$
37,788,179
TAX COLLECTIONS
tbd
PERCENT COLLECTED AS OF JUNE 30
tbd
99.80%
99.81%
99.86%
99.84%
99.75%
The District does not generally receive 100% of the taxes extended. There is generally a loss of .2% to .6% due to uncollected and delinquent taxes. The long‐term historic average tax collection rate of 99.8% of taxes levied is used in projections Source: Lake County Clerk
99
99.75%
99.86%
99.86%
99.81%
100.07%
Deerfield Public Schools District 109 Projected Tax Extensions
School year
2015-16
2016-17
2017-18
2018-19
2019-20
2020-21
2014
2015
2016
2017
2018
2019
Equalized Assessed Value New Growth 12 mo Change in Dec CPI Limiting Rate
$ 1,440,330,977 $ 7,262,412 0.80% $ 3.304
$ 1,546,016,240 $ 7,551,267 0.80% $ 3.139
$ 1,641,317,738 $ 13,536,457 0.70% $ 3.002
$ 1,741,078,000 $ 15,000,000 0.00% $ 2.855
$ 1,790,900,000 $ 10,000,000 0.00% $ 2.791
$ 1,836,718,000 $ 10,000,000 2.00% $ 2.791
Educational Special Education Operations & Management Fire Prev/Cap Proj Transportation IMRF Social Security
$
Total Operating Funds
$
Tax Year
Debt Service Total Levy
$ % chg
Extension 39,247,176 565,488 6,006,295 1,069,835 412,655 611,334
Rate 2.725 0.039 0.417 0.074 0.029 0.042
47,912,783
3.327
1,079,514
0.075
48,992,296
3.401
102.0%
$
39,209,353 661,169 6,073,602 1,371,255 526,233 691,533
2.536 0.043 0.393 0.089 0.034 0.045
$
40,060,610 708,869 6,045,105 1,327,284 488,243 649,190
2.441 0.043 0.368 0.081 0.030 0.040
$
40,408,748 715,029 6,097,638 1,338,819 492,486 654,832
2.321 0.041 0.350 0.077 0.028 0.038
$
40,635,651 719,044 6,131,878 1,346,337 495,251 658,509
2.269 0.040 0.342 0.075 0.028 0.037
$
41,675,268 737,440 6,288,755 1,380,781 507,922 675,356
2.269 0.040 0.342 0.075 0.028 0.037
$
48,533,145
3.139
$
49,279,301
3.002
$
49,707,552
2.855
$
49,986,670
2.791
$
51,265,521
2.791
1,104,459
0.071
1,112,190
0.068
1,120,918
0.064
1,098,308
0.063
1,082,728
0.063
49,637,603
3.211
50,391,491
3.070
50,828,470
2.919
51,084,978
2.854
52,348,249
2.854
$
101.3%
$
101.5%
An approximately 3% increase is used in EAV projections. New growth has been robust in the 2016 tax levy year and is expected to continue into 2017 with a tapering in future years. CPI increase is not being projected for 2017 or 2018 due to pending state legislature that would freeze and increase to EAV due to the CPI. The District does not expect to exceed its legal tax rate.
100
$
100.9%
$
100.6%
$
102.6%
Estimated Drivers of Growth in Property Tax Revenue
Millions
(excluding Debt Service)
$5
$4
$3 New Property CPI $2
$1
$‐ 2010
2011
2012
2013
2014
2015
2016
2017*
2018*
2019*
2020*
Tax Year * projected
101
Impact on Taxpayers
Example Tax Calculation Tax Year Market Value of Home Avg District Chg. In Market Value (existing property)
Appraised % of Market Assessed Value Less Homeowners Exemption Taxable Equalized Value
Property Tax Rate ($ per $100 EAV) Tax paid to School Property Tax Increase vs. PY % increase vs. PY
2010
2011
2012
2013
2014
2015
2016
$486,522
$449,697
$416,488
$394,654
$394,250
$421,111
$443,383
-5.5%
-7.57%
-7.38%
-5.24%
-0.10%
6.81%
33.3% $149,899 ($6,000) $143,899
33.3% $138,829 ($6,000) $132,829
33.3% $131,551 ($6,000) $125,551
33.3% $131,417 ($6,000) $125,417
33.3% $140,370 ($6,000) $134,370
33.3% $147,794 ($6,000) $141,794
$2.665 $4,162 $83 2.2%
$2.892 $4,162 $0 0.0%
$3.254 $4,322 $161 3.9%
$3.424 $4,299 -$23 -0.5%
$3.401 $4,266 -$33 -0.8%
$3.211 $4,314 $48 1.1%
$3.070 $4,353 $39 0.9%
Estimated Property Taxes for a Median Home $600,000
$6,000
$500,000
$5,000 $4,162
$4,162
$4,322
$4,299
$4,266
$4,314
$4,353 $400,000
$4,000
$300,000 Market Value
Taxes $3,000
$2,000
$200,000
$1,000
$100,000
$0
$0 2010
5.29%
33.3% $162,174 ($6,000) $156,174
2011
2012
2013
2014
Tax paid to School
2015
2016
Market Value of Home
Estimated 2016 Tax Levy Deerfield Public Schools District 109
Provided below is the projected impact of the 2016 Tax Levy on a residential home owner based upon the estimated increase in the equalized assessed valuation, the tax rate generated, and an estimated increase in residential property.
2015 Tax Levy
Estimated 2016 Tax Levy
Fair Cash Value of Home
$ 500,000
$ 555,000
Assessable Value (33%) Homestead Exemption
166,667 (6,000)
185,000 (6,000)
Adjusted Assessable Value
$ 160,667
$ 179,000
Total Tax Rate ‐ District 109 Real Estate Taxes Applicable to District 109
3.2106
$ 5,158
Dollar Increase
2.9110
$ 5,211 $ 52
Percent Increase
1.01%
102
(Est. 11% increase to home value)
Deerfield Public School District #109 Statement of Revenue, Expenditures and Change in Fund Balance Total Governmental Funds 3 Year Projection
Actual
Actual
2014-15
2015-16
$ 50,905,521 2,295,162 636,969 $ 53,837,652
$ 51,267,935 2,225,832 724,257 $ 54,218,024
Salaries Employee Benefits Purchased Services Supplies Capital Outlay Tuition Other Total Expenditures
$ 31,012,283 5,457,678 5,335,122 2,182,829 7,396,372 1,042,897 2,299,877 $ 54,727,058
$ 30,196,122 6,198,036 7,557,567 1,833,791 5,726,645 705,462 1,316,245 $ 53,533,867
Excess (Deficiency) of Revenue over (under) Expenditures
$
(889,406)
$
$
10,500,000 3,000,000 (3,000,000) (3,075,660)
$
Revenue: Local Sources State Sources Federal Sources Other Total Revenue
Budget
% chg
2016-17 Actual (Unaudited) $ 52,126,490 2,254,650 771,017 53,904 $ 55,179,108
2%
2%
-2%
$ 30,673,236 6,202,897 6,702,951 1,702,959 4,954,493 647,509 1,161,700 $ 52,045,744
-177%
$ 3,133,364
1% -3% 14% 1%
2017-18
% chg
1% 6% 2%
$ 52,182,534 2,212,900 643,000 $ 55,038,434
Projected
2018-19
% chg 0% -2% -17% -100% 0%
Projected
2019-20
% chg
$ 53,513,234 2,223,991 683,826 $ 56,421,051
3%
$ 34,362,336 7,675,459 5,777,339 2,494,418 3,552,763 1,236,827 1,173,968 $ 56,273,110
7%
1% 6% 3%
Projected
2020-21
% chg
$ 53,707,562 2,255,260 697,503 $ 56,660,325
0%
$ 35,549,446 7,982,474 5,521,771 2,556,776 3,036,583 1,267,748 1,196,578 $ 57,111,376
3%
1% 2% 0%
% chg
$ 54,888,550 2,400,373 709,925 $ 57,998,848
2%
$ 36,342,729 8,159,928 5,659,811 2,609,207 3,012,497 1,299,441 1,554,683 $ 58,638,296
2%
6% 2% 2%
Expenditures:
684,157
-3% 14% 42% -16% -23% -32% -43%
0% -11% -7% -13% -8% -12% -3%
358%
$ 32,062,295 7,297,592 5,450,304 2,071,958 5,240,552 920,000 2,172,972 $ 55,215,673
$
5% 18% -19% 22% 6% 42% 87% 6%
(177,240) -106%
5% 6% 20% -32% 34% -46% 2%
$
147,941
$
-
-100%
147,941
-183%
-183%
4% -4% 2% -15% 3% 2% 1%
$
(451,051) -405%
$
$
-
$
$
(451,051) -405%
$
(639,448)
2% 2% 2% -1% 2% 30% 3%
42%
Other financing Sources (Uses): Proceeds from Bond Issues Bond Issuance Costs Transfers In Transfers Out Other
- -100% - -100% - -100% -93% (203,332)
$
-
$
-100%
11,000,000 (11,000,000) -
-100%
-
Change in Fund Balance
$ 6,534,934
$
480,825
-93%
$ 3,133,364
552%
Beginning Fund Balance
$ 19,763,777
$ 26,298,711
33%
$ 26,779,536
2%
22,881,700
-15%
$ 22,704,460
-1%
$ 22,852,401
1%
$ 22,401,350
-2%
Projected Ending Fund Balance
$ 26,298,711
$ 26,779,536
2%
$ 29,912,900
12%
$ 22,704,460
-24%
$ 22,852,401
1%
$ 22,401,350
-2%
$ 21,761,902
-3%
48%
50%
57%
41%
41%
39%
37%
5.8
6.0
6.9
4.9
4.9
4.7
4.5
Fund Balance as % of Expenditures Fund Balance in Months of Expenditures
103
$
(177,240) -106%
$
(639,448)
42%
Total Governmental Funds Projected Revenues vs. Expenditures $70,000,000
$60,000,000
$50,000,000
$40,000,000 Revenue Expenditure
$30,000,000
Excess / (Deficiency) Ending Fund Balance
$20,000,000
$10,000,000
$‐ 2014‐15
2015‐16
2016‐17 Actual (Unaudited) (6/30/17)
2017‐18 Budget
2018‐19
$(10,000,000)
104
2019‐20
2020‐21
Aggregate Fund Balances Historic, FY18, Projected All Funds
$70,000,000
$60,000,000
$50,000,000
$40,000,000
Revenue $30,000,000
Expenditure Ending Fund Balance
$20,000,000
$10,000,000
$‐
Revenue
2014‐15
2015‐16
2016‐17 Actual (Unaudited) (6/30/17)
2017‐18 Budget
2018‐19
2019‐20
2020‐21
$53,837,652
$54,218,024
$55,179,108
$55,038,434
$56,421,051
$56,660,325
$57,998,848
Expenditure
$54,727,058
$53,533,867
$52,045,744
$55,215,673
$56,273,110
$57,111,376
$58,638,296
Ending Fund Balance
$26,298,711
$26,779,536
$29,912,900
$22,704,460
$22,852,401
$22,401,350
$21,761,902
105
Deerfield Public School District #109 Statement of Revenue, Expenditures and Change in Fund Balance Educational Fund 3 Year Projection
Actual
Actual
2014-15
2015-16
$ 40,313,284 1,362,435 636,969 $ 42,312,688
$ 41,338,092 1,301,905 724,257 $ 43,364,254
Salaries Employee Benefits Purchased Services Supplies Capital Outlay Tuition Other Total Expenditures
$ 30,308,738 4,392,596 2,385,567 1,288,998 610,122 1,042,897 $ 40,028,918
$ 29,525,785 4,894,644 2,604,189 1,074,845 1,664,111 705,462 $ 40,469,036
Excess (Deficiency) of Revenue over (under) Expenditures
$ 2,283,770
$ 2,895,218
$
$
Revenue: Local Sources State Sources Federal Sources Other Total Revenue
Budget
% chg 3% -4% 14% 2%
2016-17 Actual (Unaudited) $ 41,616,202 1,293,130 771,017 26,952 $ 43,680,348
2017-18
% chg 1% -1% 6% 1%
$ 41,887,132 1,342,900 643,000 $ 43,873,032
Projected
2018-19
% chg 1% 4% -17% -100% 0%
Projected
2019-20
% chg
$ 44,261,426 1,342,900 683,826 $ 46,288,152
6% 0% 6% 6%
Projected
2020-21
% chg
$ 44,250,217 1,342,900 697,503 $ 46,290,620
0%
$ 34,797,718 6,663,255 2,002,278 1,420,840 1,467,399 1,267,748 $ 47,619,238
3%
0% 2% 0%
% chg
$ 45,142,127 1,342,900 709,925 $ 47,194,952
2%
$ 35,564,901 6,794,270 2,052,331 1,444,873 1,504,083 1,299,441 $ 48,659,899
2%
0% 2% 2%
Expenditures:
1%
$ 30,027,871 5,063,668 2,406,832 860,020 1,186,079 647,509 $ 40,191,978
27%
$ 3,488,370
-3% 11% 9% -17% 173% -32%
-1%
$ 31,367,802 5,812,669 2,169,323 1,323,520 1,691,925 920,000 (302,787) $ 42,982,452
20%
$
2% 3% -8% -20% -29% -8%
890,580
4% 15% -10% 54% 43% 42% 7%
-74%
$ 33,635,831 6,406,976 1,953,444 1,386,188 1,431,608 1,236,827 $ 46,050,874
$
237,278
$
-
7% 10% -10% 5% -15% 34% -100% 7%
-73%
4% 2% 2% 3% 3% 3%
$ (1,328,618) -660%
$ (1,464,947)
$
$
2% 2% 2% 2% 2% 2%
10%
Other financing Sources (Uses): Proceeds from Bond Issues Bond Issuance Costs Transfers In Transfers Out Other Change in Fund Balance
$
Beginning Fund Balance Projected Ending Fund Balance Fund Balance as % of Expenditures Fund Balance in Months of Expenditures
(3,000,000) (716,230)
- -100% (127,672)
$
-
$
-100%
(3,000,000) -
-
-100%
-
$ 2,767,546
-486%
$ 3,488,370
26%
$ (2,109,420)
$ 10,366,594
$ 9,650,364
-7%
$ 12,417,910
29%
$ 12,259,760
$ 9,650,364
$ 12,417,910
29%
$ 15,906,280
28%
$ 10,150,340
24%
31%
40%
24%
23%
19%
16%
2.9
3.7
4.7
2.8
2.7
2.3
1.9
106
237,278
-111%
-1%
$ 10,150,340
-36%
$ 10,387,618
-160%
$
$ (1,328,618) -660%
$ (1,464,947)
10%
-17%
$ 10,387,618
2%
$ 9,059,000
-13%
2%
$ 9,059,000
-13%
$ 7,594,053
-16%
Educational Fund Projected Revenues vs. Expenditures $55,000,000
$45,000,000
$35,000,000
Revenue Expenditures & Transfers
$25,000,000
Excess / (Deficiency) Ending Fund Balance
$15,000,000
$5,000,000
$(5,000,000)
2014‐15 Actual
2015‐16 Actual
2016‐17 Actual (Unaudited) (6/30/17)
2017‐18 Budget
2018‐19 Projected
107
2019‐20 Projected
2020‐21 Projected
Deerfield Public School District #109 Statement of Revenue, Expenditures and Change in Fund Balance Operation & Maintenance Fund 3 Year Projection
Actual
2014-15
2015-16
$ 5,714,337 $ 5,714,337
$ 6,119,902 $ 6,119,902
$
666,690 87,415 1,082,817 893,591 3,190,494 $ 5,921,007
$
$
(206,670)
$
726,546
$
2,800,000 3,000,000 (3,075,660)
$
(75,660)
Revenue: Local Sources State Sources Federal Sources Other Total Revenue
Actual
Projected
Budget
% chg 7%
7%
2016-17 Actual (Unaudited)
2017-18
% chg
$ 6,161,614 $ 6,161,614
1%
1%
$ 6,129,879 $ 6,129,879
Projected
2018-19
% chg -1%
$
-1%
$
6%
$
2019-20
% chg
4,858,271 4,858,271
Projected
-21%
$
-21%
$
5%
$
2020-21
% chg
4,972,592 4,972,592
2%
$
2%
$
709,649 96,987 1,892,747 1,135,936 1,122,668 75,660 5,033,647
3%
$
% chg
5,143,610 5,143,610
3%
4%
3%
Expenditures: Salaries Employee Benefits Purchased Services Supplies Capital Outlay Tuition Other Total Expenditures Excess (Deficiency) of Revenue over (under) Expenditures
641,089 80,072 2,888,587 756,261 1,027,348 $ 5,393,356
-4% -8% 167% -15% -68%
-9%
-452%
$
615,465 85,362 2,787,753 842,939 1,193,535 $ 5,525,054
-4% 7% -3% 11% 16%
2%
$
655,101 75,424 1,232,481 748,438 1,689,627 1,361,452 $ 5,762,523
$
636,560
$
-
-100%
3,000,000 (8,000,000) -
-12%
$
367,356
-12% -56% -11% 42%
4%
$
-42%
$
685,652 93,257 2,236,826 1,108,230 1,485,530 75,660 5,685,155
(826,884)
24% 81% 48% -12% -94% -1%
$
-325%
$
(61,055)
-11%
$
734,487 100,867 1,940,066 1,164,334 1,050,735 75,660 5,066,149
-93%
$
77,461
$
-
4% -15% 3% -24% 0%
4% 3% 2% -6% 0% 1%
-227%
Other financing Sources (Uses): Proceeds from Bond Issues Bond Issuance Costs Transfers In Transfers Out Other
-100% -100% -98%
$
$
-
$
-
-100% -100%
Change in Fund Balance
$ 2,517,670
$
650,886
-74%
$
636,560
-2%
$ (4,632,644)
Beginning Fund Balance
$ 2,111,381
$ 4,629,051
119%
$ 5,279,937
14%
Projected Ending Fund Balance
$ 4,629,051
$ 5,279,937
14%
$ 5,916,497
12%
78%
98%
107%
20%
6%
6%
7%
9.4
11.7
12.9
2.5
0.7
0.7
0.9
Fund Balance as % of Expenditures Fund Balance in Months of Expenditures
108
-828%
$
$ 5,809,950
10%
$
$ 1,177,306
-80%
$
(826,884)
-82%
$
(61,055)
-93%
$
77,461
-227%
1,177,306
-80%
$
350,422
-70%
$
289,367
-17%
350,422
-70%
$
289,367
-17%
$
366,828
27%
Operation & Maintenance Fund Projected Revenues vs. Expenditures $7,000,000
$6,000,000
$5,000,000
$4,000,000 Revenue
$3,000,000
Expenditures & Transfers Excess / (Deficiency)
$2,000,000
Ending Fund Balance
$1,000,000
$‐ 2014‐15 Actual $(1,000,000)
2015‐16 Actual
2016‐17 Actual (Unaudited) (6/30/17)
2017‐18 Budget
2018‐19 Projected
$(2,000,000)
109
2019‐20 Projected
2020‐21 Projected
Deerfield Public School District #109 Statement of Revenue, Expenditures and Change in Fund Balance Transportation Fund 3 Year Projection
Actual
Budget
2014-15
2015-16
$ 1,073,909 316,631 $ 1,390,540
$ 1,142,648 305,293 $ 1,447,941
$
$
Revenue: Local Sources State Sources Federal Sources Other Total Revenue
Actual
% chg 6% -4%
4%
2016-17 Actual (Unaudited) $ 1,460,877 287,935 $ 1,748,812
2017-18
% chg 28% -6%
21%
Projected
2018-19
% chg
$ 1,402,648 240,000 $ 1,642,648
Projected
2019-20
% chg
-6%
$ 1,343,492 240,000 $ 1,583,492
32%
$
-4% -17%
-4% 0%
-4%
Projected
2020-21
% chg
$ 1,374,855 240,000 $ 1,614,855
2%
$
% chg 3%
2%
$ 1,419,715 240,000 $ 1,659,715
3%
$
3%
0%
0%
3%
Expenditures: Salaries Employee Benefits Purchased Services Supplies Capital Outlay Tuition Other Total Expenditures
36,855 6,277 1,417,936 240 $ 1,461,308
29,248 5,411 1,380,201 2,685 $ 1,417,544
Excess (Deficiency) of Revenue over (under) Expenditures
$
$
30,397
$
-
$
30,397
-143%
(70,768)
-21% -14% -3% 1019%
-3%
-143%
$
29,900 2,663 1,362,635 $ 1,395,198
2% -51% -1% -100%
-2%
$
353,614
$
-
$
353,614
1063%
1063%
$
39,392 7,924 1,548,500 $ 1,595,817
198% 14%
14%
$
46,831
$
-
$
46,831
-87%
-87%
40,853 4,301 1,587,069 $ 1,632,223
$
(48,731)
4% -46% 2%
2%
-204%
42,079 4,473 1,626,746 $ 1,673,298
$
(58,443)
4% 3%
3%
20%
43,341 4,652 1,667,414 $ 1,715,407
$
(55,692)
4% 2%
3%
-5%
Other financing Sources (Uses): Proceeds from Bond Issues Bond Issuance Costs Transfers In Transfers Out Other
$
-
$
-
$
-
$
-
Change in Fund Balance
$
Beginning Fund Balance
$ 1,109,813
$ 1,039,045
-6%
$ 1,069,442
3%
$ 1,207,108
13%
$ 1,253,939
4%
Projected Ending Fund Balance
$ 1,039,045
$ 1,069,442
3%
$ 1,423,056
33%
$ 1,253,939
-12%
$ 1,205,208
-4%
71%
75%
102%
79%
74%
69%
64%
8.5
9.1
12.2
9.4
8.9
8.2
7.6
Fund Balance as % of Expenditures Fund Balance in Months of Expenditures
(70,768)
110
$
(48,731)
-204%
$
(58,443)
20%
$
(55,692)
$ 1,205,208
-4%
$ 1,146,765
-5%
$ 1,146,765
-5%
$ 1,091,073
-5%
-5%
Transportation Fund Projected Revenues vs. Expenditures $2,000,000
$1,600,000
$1,200,000
Revenue Expenditure
$800,000
Excess / (Deficiency) Ending Fund Balance
$400,000
$‐ 2014‐15 Actual
2015‐16 Actual
2016‐17 Actual (Unaudited) (6/30/17)
2017‐18 Budget
2018‐19 Projected
$(400,000)
111
2019‐20 Projected
2020‐21 Projected
Deerfield Public School District #109 Statement of Revenue, Expenditures and Change in Fund Balance Municipal Retirement / Social Security Fund 3 Year Projection
Actual
Budget
2014-15
2015-16
$ 1,063,528 $ 1,063,528
$ 1,123,677 $ 1,123,677
$
$
Revenue: Local Sources State Sources Federal Sources Other Total Revenue
Actual
% chg 6%
6%
2016-17 Actual (Unaudited) $ 1,322,614 $ 1,322,614
2017-18
% chg 18%
18%
Projected
2018-19
% chg
$ 1,239,246 $ 1,239,246
-6%
-6%
Projected
2019-20
% chg
$ 1,246,054 $ 1,246,054
1%
1%
Projected
2020-21
% chg
$ 1,275,998 $ 1,275,998
2%
2%
% chg
$ 1,318,009 $ 1,318,009
3%
3%
Expenditures: Salaries Employee Benefits Purchased Services Supplies Capital Outlay Tuition Other Total Expenditures
$
971,390 971,390
1,217,909 $ 1,217,909
Excess (Deficiency) of Revenue over (under) Expenditures
$
92,138
$
$
-
$
Change in Fund Balance
$
92,138
$
(94,232)
Beginning Fund Balance
$
527,492
$
Projected Ending Fund Balance
$
619,630
$
(94,232)
$
25%
25%
1,051,205 $ 1,051,205
$
-14%
-14%
1,401,575 $ 1,401,575
$
271,409
$
-
-202%
$
271,409
-388%
$
(162,329)
619,630
17%
$
525,398
-15%
$
525,398
-15%
$
796,807
52%
$
-202%
-388%
$
(162,329)
$
33%
33%
1,170,925 $ 1,170,925
$
75,129
$
-
-160%
$
75,129
669,996
28%
$
507,667
-36%
$
-160%
$
-16%
-16%
1,217,759 $ 1,217,759
$
58,239
$
-
-146%
$
58,239
507,667
-24%
$
582,796
15%
$
-146%
$
4%
4%
1,260,139 $ 1,260,139
3%
3%
$
57,870
$
-
-22%
$
57,870
-1%
582,796
15%
$
641,035
10%
641,035
10%
$
698,905
9%
-22%
-1%
Other financing Sources (Uses): Proceeds from Bond Issues Bond Issuance Costs Transfers In Transfers Out Other
Fund Balance as % of Expenditures Fund Balance in Months of Expenditures
-
$
-
64%
43%
76%
36%
50%
53%
55%
7.7
5.2
9.1
4.3
6.0
6.3
6.7
112
Deerfield Public School District #109 Statement of Revenue, Expenditures and Change in Fund Balance Debt Service Fund 3 Year Projection
Actual
Budget
2014-15
2015-16
$ 2,229,531 $ 2,229,531
$ 1,155,547 $ 1,155,547
$
2,299,877 $ 2,299,877
$
$
$
Revenue: Local Sources State Sources Federal Sources Other Total Revenue
Actual
% chg -48%
-48%
2016-17 Actual (Unaudited) $ 1,188,952 $ 1,188,952
2017-18
% chg 3%
3%
Projected
2018-19
% chg
1,118,629 $ 1,118,629
-6%
-6%
Projected
2019-20
% chg
$ 1,104,459 $ 1,104,459
-1%
-1%
Projected
2020-21
% chg
$ 1,112,190 $ 1,112,190
1%
1%
% chg
$ 1,120,918 $ 1,120,918
1%
1%
Expenditures: Salaries Employee Benefits Purchased Services Supplies Capital Outlay Tuition Other Total Expenditures Excess (Deficiency) of Revenue over (under) Expenditures
(70,346)
1,316,245 $ 1,316,245
(160,698)
$
-43%
1,161,700 $ 1,161,700
128%
$
27,253
$
-
128%
$
27,253
-43%
$
-12% -12%
1,114,308 $ 1,114,308
$
4,321
$
-
-117%
$
4,321
-117%
$
-4% -4%
1,098,308 $ 1,098,308
$
-1%
1,120,918 $ 1,120,918
42%
$
-1%
$
6,151
$
-
-84%
$
6,151
42%
$
-84%
(8,728)
$
2% 2%
-242%
1,479,023 $ 1,479,023
$ (358,105)
32% 32%
4003%
Other financing Sources (Uses): Proceeds from Bond Issues Bond Issuance Costs Transfers In Transfers Out Other
$
Change in Fund Balance
$
Beginning Fund Balance Projected Ending Fund Balance Fund Balance as % of Expenditures Fund Balance in Months of Expenditures
(70,346)
$
-
$
-
-
$
(160,698)
$ 1,048,609
$
978,263
-7%
$
817,565
-16%
$
828,577
1%
$
832,898
1%
$
839,049
1%
$
830,321
-1%
$
$
817,565
-16%
$
844,818
3%
$
832,898
-1%
$
839,049
1%
$
830,321
-1%
$
472,216
-43%
978,263
(8,728)
$
-242%
$ (358,105)
43%
62%
73%
75%
76%
74%
32%
5.1
7.5
8.7
9.0
9.2
8.9
3.8
113
4003%
Deerfield Public Schools - District 109 Historical Legal Bonded Debt Margin Fiscal Year Ended June 30
Tax Levy Year
2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007
2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006
Equalized Assessed Valuation
Statutory Debt Limitation* (6.9% of EAV)
1,641,317,738 1,546,016,240 1,440,330,977 1,434,535,443 1,548,129,423 1,615,399,393 1,735,404,731 1,820,651,350 1,808,252,340 1,763,257,897 1,596,021,048
General Bonded Debt
113,250,924 106,675,121 99,382,837 98,982,946 106,820,930 111,462,558 119,742,926 125,624,943 124,769,411 121,664,795 110,125,452
General Bonded Debt % of EAV
% Debt Margin Available
1.28% 1.38% 1.53% 1.11% 0.82% 0.92% 1.01% 1.11% 1.23% 1.43% 1.72%
81% 80% 78% 84% 88% 87% 85% 84% 82% 79% 75%
21,020,000 21,370,000 22,075,000 15,890,000 12,705,000 14,790,000 17,520,000 20,155,000 22,265,000 25,138,961 27,409,261
100% 90%
6%
80%
% Debt Margin Available 5%
70% 60%
4%
50% 3% 40%
General Bonded Debt % of EAV 30%
2%
20% 1% 10% 0% 2007
2008
2009
2010
2011
2012
2013
Source: Equalized Assessed valuation of Taxable Property - Lake County Clerk 2007 - 2016 Financial Audits *School district debt is limited by the Illinois Compiled Statutes.
114
2014
2015
2016
0% 2017
Deerfield Public Schools - District 109 Projected Long Term Obligations
Projected Balance June 30, 2017 Series 1999-B Ltd. Tax School Bonds
$
Series 2010 B-GO Refunding Limited Tax Bonds
830,000
Projected to Add $
-
-
Series 2013 General Obligation Limited School Bonds
8,975,000
Projected to Retire / Defease
Projected Balance June 30, 2018
$
$
390,000
Pincipal Interest Amount due in Amount due in 2017-18 2017-18
440,000
-
41,910
-
-
-
-
0
-
-
8,975,000
-
350,750
Series 2015 General Obligation Limited School Bonds
9,270,000
Series 2010 Debt Certificates
1,945,000
-
-
1,945,000
-
75,660
965,762
-
-
965,762
-
0
-
783,968
Other Post Employment Obligations* $ * Annual OPEB Cost % of Annual Pension Contribution Contributed
21,985,762
9,270,000
$
-
387,914 40.2%
115
$
390,000
$
21,595,762
315,648
$
202 Deerfield Public School District #109 Statement of Revenue, Expenditures and Change in Fund Balance Capital Projects Fund 3 Year Projection
Actual
2014-15
Revenue: Local Sources State Sources Federal Sources Other Total Revenue
Actual
2015-16
$
510,499 616,096 $ 1,126,595
$
$
$
Projected
Budget
% chg
387,859 618,635 $ 1,006,494
-24% 0%
-11%
2016-17 Actual (Unaudited) $
375,797 673,585 $ 1,049,382
2017-18
% chg -3% 9%
4%
$
380,000 630,000 $ 1,010,000
2018-19
% chg 1% -6%
-4%
Projected
2019-20
% chg
$
637,480 641,091 $ 1,278,571
68% 2%
27%
Projected
2020-21
% chg
$
658,721 672,360 $ 1,331,081
3% 5%
4%
% chg
$
658,721 817,473 $ 1,476,194
0% 22%
11%
Expenditures: Salaries Employee Benefits Purchased Services Supplies Capital Outlay Tuition Other Total Expenditures
448,802 1,742,172 $ 2,190,974
684,591 2,922,208 $ 3,606,799
Excess (Deficiency) of Revenue over (under) Expenditures
$ (1,064,379)
$ (2,600,305)
$
$
$
53% 68%
65%
144%
145,731 2,323,398 $ 2,469,129
$ (1,419,747)
$
-32%
500,000 750,000 $ 1,250,000
-45%
$
-79% -20%
$
$
435,625 435,625
$
842,946
8,000,000 -
$
-
-100%
243% -68%
-49%
(240,000)
$
-65%
$
446,516 446,516
-451%
$
884,565
$
-
-100% -42%
$
3%
457,679 457,679
3%
$
5%
$ 1,018,515
3%
3%
15%
Other financing Sources (Uses): Proceeds from Bond Issues Bond Issuance Costs Transfers In Transfers Out
7,700,000 -
-
Change in Fund Balance
$ 6,635,621
$ (2,600,305)
Beginning Fund Balance
$
$ 6,070,662
Projected Ending Fund Balance
$ 6,070,662
Fund Balance as % of Expenditures Fund Balance in Months of Expenditures
(564,959)
277% 33.2
-5403%
$
-
-100%
$
$
-
$ (1,419,747)
-45%
$ 7,760,000
$
842,946
-89%
$
884,565
5%
$ 1,018,515
15%
-1175%
$ 3,470,357
-43%
$
904,882
$ 8,664,882
858%
$ 9,507,828
10%
$ 10,392,393
9%
$ 3,470,357
-43%
$ 2,050,611
-41%
$ 8,664,882
$ 9,507,828
10%
$ 10,392,393
9%
$ 11,410,908
10%
96%
-65%
83%
-14%
693%
-139%
11.5
10.0
83.2
NOTE: Recent movement in the state’s capitol leads us to further uncertainty about maintaining the state’s share of District revenue. Educational equity continues to be debated by the Illinois General
116
735%
220 Deerfield Public School District #109 Statement of Revenue, Expenditures and Change in Fund Balance Fire Prevention & Safety Fund 3 Year Projection
Actual
2014-15
Revenue: Local Sources State Sources Federal Sources Other Total Revenue
Actual
$
$
Budget
2015-16
433 433
$
$
% chg
210 210
2016-17 Actual (Unaudited)
-52%
$
-52%
$
433 26,952 27,385
Projected (1)
2017-18
% chg 107%
$
12964%
$
2018-19
% chg
25,000 25,000
5674%
$
-100% -9%
$
Projected
2019-20
% chg
62,052 62,052
Projected
148%
$
148%
$
2020-21
% chg
62,989 62,989
2%
$
2%
$
% chg
85,450 85,450
36%
36%
Expenditures: Salaries Employee Benefits Purchased Services Supplies Capital Outlay Tuition Other Total Expenditures
$
1,853,584 $ 1,853,584
$
$
112,979 112,979
Excess (Deficiency) of Revenue over (under) Expenditures
$ (1,853,151)
$
(112,769)
$
$
$
-94%
$
251,480 251,480
-94%
$
(224,095)
-94%
$
123%
123%
99%
1,109,000 $ 1,109,000
$ (1,084,000)
$
341%
$
200,000 200,000
384%
$
(137,948)
341%
$
-82%
$
-
-87%
$
62,989
$
62,989
-82%
$
-100%
$
-
-146%
$
85,450
$
-
-146%
$
85,450
36%
(20,521) -117%
$
42,468
-307%
$
127,918
201%
-100%
36%
Other financing Sources (Uses): Proceeds from Bond Issues Bond Issuance Costs Transfers In Transfers Out
-
-
$
-94%
$
$ 3,311,696
-36%
$ 3,198,927
-3%
Change in Fund Balance
$ (1,853,151)
$
Beginning Fund Balance
$ 5,164,847
Projected Ending Fund Balance
$ 3,311,696
(112,769)
(224,095)
$
-
$
-
99%
$ (1,084,000)
384%
$
(137,948)
-87%
$
$ 3,198,927
-3%
$ 1,201,427
-62%
$
117,427
-90%
$
$ 2,974,832
-7%
$
-96%
$
(20,521)
-117%
$
117,427
(1) $900,000 has been included in projections as a result of the updated Life Safety Plan approved by the Illinois State Board of Education in the Fall of 2013.
117
42,468
-307%
Fund Balance Why should districts have reserves? All districts should maintain a reserve fund, or fund balance, to address revenue shortfalls or unanticipated expenditures, to provide liquidity, and to help stabilize tax rates. In good times it is fiscally prudent to use a portion of budget surpluses to help create, sustain or increase the size of a general fund reserves. The Government Finance Officers Association (GFOA) suggests that the following factors influence the need for a fund balance1:
Liquidity – School districts receive the bulk of their revenues through local property taxes, which are only received twice per year, but expenses occur more evenly through the year. Without adequate reserves, a district would have to borrow money (and incur interest costs) to cover expenses through tax anticipation warrants or working cash bonds .
Exposure to significant one-time outlays – A fund balance act as emergency funds in case of a natural disaster, state budget cuts, immediate capital needs, escalating mandates or distress in the local economy.
Predictability of revenue/volatility of expenses – Having an adequate fund balance can allow the district to avoid curtailing programs and staff during tough economic times, delayed tax receipts, and periods of rapid growth. It can also smooth the growth in taxes avoiding the need for referenda.
How big should a fund balance be? The credit rating agencies, which regularly monitor the size of governmental fund balances, prefer large reserves so that there is greater assurance that debt service payments will be made. This can lower borrowing costs and ensure access to capital. However, if a district consistently maintains large reserves, it raises concerns from taxpayers and citizens’ groups about whether the government is taxing too much and hoarding the proceeds.2 The appropriate size of a fund balance varies widely by district according to their sensitivity to the above criteria. However, there are some general guidelines:
The GFOA recommends a minimum of 2 months (or about 16%) of operating revenues or operating expenses.
The Illinois State Board of Education requires districts to maintain a fund balance to revenue (or operating expense assuming a balanced budget) ratio of at least 25% to achieve the highest score on its Financial Strength Profile.
In Districts with late fall distribution of the second installment of property taxes, a balance of 30-35%, about 4 months of expenses, or higher may be necessary to avoid borrowing. 3
Government Finance Officers Association. (2009, October). Retrieved May 2010, 2010, from Best Practice - Appropriate Level of Unrestricted Fund Balance in the General Fund: http://www.gfoa.org/downloads/AppropriateLevelUnrestrictedFundBalanceGeneralFund_BestPractice.pdf 1
The Civic Federation. (2009, December 16). Retrieved May 26, 2010, from The Civic Federation Blog: http://www.civicfed.org/civicfederation/blog/how-much-fund-balance-too-much-not-enough-just-right 2
3
Fritts, J. B. (2008). Essentials of Illinos School Finance (Fourth Edition ed.). Illinois Association of School Boards.
118
Millions
2015‐2016 Operating Fund Balance $80
$70 North Shore 112 Glenview 34 $60
Wilmette 39 Kildeer 96
Operating Exenditures
$50
Deerfield 109
$40 Northbrook 28
Winnetka 36 Aptakisic 102
Libertyville 70 $30
Lake Forest 67
Lincolnshire 103 Northbrook 27 Northbrook/Glenview
$20
Glencoe 35
West Northfield 31 Lake Bluff 65 Sunset Ridge 29
Avoca 37
$10
Kenilworth 38
Bannockburn 106 $0 0%
50%
100%
150%
Ending Operating Fund Balance as % of Operating Expenses
Source: 2015 Annual Financial Reports, Illinois State Board of Education
119
200%
250%
Enrollment
Deerfield Public Schools District 109 is located in an established community with a steady population. The District has experienced relatively stable enrollment, with a decrease in the number of students of 120, or 3.8%, from 3,150 in 2000-01 to 3,030 in 2015-16. The District expects the growth rate to decline between 4%-9% over the next 5 years. District enrollment was projected by Dr. Charles Kofron using a 3-year cohort survival method and live birth data in 2007 with annual updates. This technique determines actual birth data obtained from the Illinois Department of Public Health for the District’s area codes and projects those birth data forward. In 2007, 2008, 2009, and 2010, the District’s Business Office collected other demographic data from incoming kindergarten student’s families and found that cohort survival methods were insufficient for predicting enrollment. Up to 40% more students were found to have moved into the District’s boundaries after birth. Thus, enrollment projections for kindergarten and first grade are calculated using a hybrid formula using live birth date and a 3year cohort average developed by the District and demographer Dr. Kofron. The enrollment for second grade and beyond is forecasted using the proportion method. In this analysis the current enrollment is examined and a proportion (typically, 100%) of students at each grade level are advanced forward. Students that attend a particular middle school (based on feeder school and residence) are projected forward as student’s age.
120
Deerfield Public Schools District #109 Enrollment
Fiscal Years 2004-05 2005-06 2006-07 2007-08 2008-09 2009-10 2010-11 2011-12 2012-13 2013-14 2014-15 2015-16 2016-17 Projected 2017-18 2018-19 2019-20 2020-21 2021-22
Pre School
K
Out-ofDist Total 1st Gr 2nd Gr 3rd Gr 4th Gr 5th Gr 6th Gr 7th Gr 8th Gr Placement Enrollment Change
% Change
31 27 34 39 41 40 39 33 24 43 46 60 55
304 302 331 307 332 328 310 244 266 308 243 262 284
340 327 332 365 343 359 355 337 281 309 336 282 287
317 342 325 336 367 343 360 352 336 285 318 345 296
357 326 340 332 337 367 345 360 359 346 279 328 347
370 357 324 346 336 337 377 351 359 368 347 288 328
336 369 357 322 344 338 344 379 353 354 364 354 289
381 353 369 370 323 344 350 352 378 353 359 370 357
348 376 336 370 375 325 357 353 356 380 354 367 366
383 350 372 341 367 377 332 353 353 355 379 359 359
19 30 19 12 12 10 11 7 9 20 17 15 14
3,186 3,159 3,139 3,140 3,177 3,168 3,180 3,121 3,074 3,121 3,042 3,030 2,982
17 (27) (20) 1 37 (9) 12 (59) (47) 47 (79) (12) (48)
0.54% (0.85%) (0.63%) 0.03% 1.18% (0.28%) 0.38% (1.86%) (3.33%) 1.53% (2.53%) (2.92%) (1.58%)
60 60 60 60 60
312 272 295 289 292
289 315 290 300 301
293 293 315 287 301
307 296 299 319 290
350 313 300 300 320
316 355 314 300 307
291 341 346 302 296
369 328 336 346 302
345 368 327 336 346
10 9 9 7 6
2,942 2,950 2,891 2,846 2,821
(40) 8 (59) (45) (25)
(1.34%) 0.27% (2.00%) (1.56%) (0.88%)
Deerfield Schools District 109 Enrollment 3,500 3,000 2,500 2,000 Actual 1,500
Projected
1,000 500 ‐
Source: District Records
2017‐18 enrollment is projected to decrease by 1.24%.
121
DEERFIELD PUBLIC SCHOOL DISTRICT 109 ENROLLMENT BY SCHOOL
1999-00
Kipling 546
2000-01
554
2001-02 2002-03
South Park 515
Walden 438
Wilmot 561
Shepard 505
Caruso 487
District 3,052
559
454
560
542
481
558
531
477
549
563
520
3,198
543
548
479
542
564
531
3,207
2003-04
536
540
471
537
554
531
3,169
2004-05
534
525
494
515
544
574
3,186
2005-06
517
505
496
550
543
548
3,159
2006-07
507
514
475
557
534
552
3,139
2007-08
516
507
473
557
542
545
3,140
2008-09
524
524
486
570
525
548
3,177
2009-10
521
526
482
587
521
531
3,168
2010-11
516
521
507
591
534
511
3,180
2011-12
496
522
478
563
529
533
3,121
2012-13
471
494
472
546
549
542
3,074
2013-14
499
508
465
550
566
535
3,123
2014-15
493
475
436
534
562
542
3,042
2015-16
480
477
466
497
583
527
3,030
2016-17
470
453
459
504
537
559
2,982
2017-18
495
437
486
512
485
527
2,942
2018-19
485
424
483
514
506
538
2,950
2019-20
475
417
461
522
489
527
2,891
2019-20
462
420
452
522
497
493
2,846
2020-21
479
422
446
524
475
475
2,821
122
3,150
Students ages 3 to 17 meet the low-income criteria if they receive or live in households that receive public aid from SNAP (Supplemental Nutrition Assistance Program) or TANF (Targeted Assistance for Needy Families); are classified as homeless, migrant, runaway, Head Start, or foster children; or live in a household where the household income meets (USDA) guidelines to receive free or reduced-price meals.
Illinois law defines “chronic truant” as a student who misses 5 percent of school days within an academic year without a valid excuse. That’s nine days of an average 180-day school year. The count of chronically truant students does not include students with excused absences, such as doctors’ appointments or students over the age of 16, who are not legally required to attend school. Chronic truants are at risk of academic and behavioral problems. Research shows that chronic truancy has been linked to serious delinquent activity in youth and to significant negative behavior and characteristics in adults.
123
Deerfield Public Schools District 109 Staffing Levels (Full Time Equivalents) 2013-14 Actual pupil ratio 9.0 12.0 2.0 1.0 24.0 130.1
Administrators District Administration School Administration Business Administration Operations & Maintenance
Avg. Total Salary Administrative Salary Per Pupil Avg. Total Comp Administrative Comp Per Pupil
2016-17 Actual pupil ratio 10.0 12.0 2.0 1.0 25.0 119.0
2017-18 Budget pupil ratio 10.0 12.0 2.0 1.0 25.0 117.7
$108,708 $858 $143,917 $1,135
$111,973 $924 $147,862 $1,220
$114,065 $958 $154,246 $1,296
$120,298 $1,022 $165,061 $1,403
124.50 75.60 47.50 16.90 8.60
116.50 74.00 46.10 15.30 9.60
114.60 73.36 46.00 18.30 8.80
112.60 73.36 48.20 15.30 9.80
113.60 74.56 48.2 13.3 10.80
12.40 285.50
Avg. Total Salary Teacher Salary per pupil Avg. Total Comp Teacher Comp per pupil Other Support Staff Elementary School Special Education Health Services Library/Media Services Assessment & Testing District Administration School Administration Business & Community Services Operations & Maintenance
Total District Employees Total District Comp per student Total District Salary per student
2015-16 Actual pupil ratio 10.0 12.0 2.0 1.0 25.0 121.2
$106,577 $ 819 $ 143,714 $ 1,104
Teachers/Certified Staff Elementary School Middle School Special Ed, ELP, Gifted Social Work, Guidance, Speech Health, Psychologists Library, Instructional Improvement, Community Service
Avg. Total Salary Support Staff Salary per pupil Avg. Total Comp Support Staff Comp per pupil
2014-15 Actual pupil ratio 9.0 12.0 2.0 1.0 24.0 126.8
$
18.40 279.90
10.9
18.40 279.46
11.2
19.40 278.66
10.9
20.20 280.66
10.9
$79,530 $7,271 $91,818 $8,394
$79,517 $7,317 $91,793 $8,446
$76,809 $7,084 $89,640 $8,268
$78,754 $7,374 $92,221 $8,635
$80,046 $7,549 $94,118 $8,876
5.00 60.00 4.00 6.00 2.00 2.00 12.00 5.00 5.00 101.00
4.00 60.00 4.00 6.00 2.00 2.00 12.00 5.00 5.00 100.00
4.00 60.60 6.00 6.00 2.00 2.00 12.00 5.00 5.00 102.60
4.00 63.00 6.00 6.00 2.00 2.00 12.00 5.00 5.00 105.00
4.00 62.50 6.00 6.00 2.00 3.00 12.00 5.00 5.00 105.50
30.92
30,399 $983 $44,521 $1,440 410.5 $10,938 $8,121
$
7.6
31.23
33,229 $1,092 $47,288 $1,555 403.9 $11,136 $8,210
$
7.7
29.65
34,264 $1,160 $49,532 $1,677 407.1 $11,165 $8,047
$
7.5
28.86
35,098 $1,238 $52,003 $1,835 408.7 $11,766 $8,376
$ $
7.4
10.5
27.9
37,041 $1,328 54,460 $1,931 411.2 $12,334 $8,706
7.2
Source: District Records
Administration has increased largely as a result of bringing tuition students back to the district. The District now runs six nineclasses classesofofhigh-need high-needspecial specialeducation students. education students. The total compensation The total compensation of administration increase has of averaged administration less than has averaged 1% increase approximatley over five years 2% and overpeaked five years. in 2009-10. The increase It hasindecreased Certified staff sinceaverage that year salary due over to 5 the years retirement includesofincreases highly compensated for advanced employees. degrees and Certified professionals staff average development salary and increase is related is 5%toover the 5 increase years including in FTE asincreases a result of foreducating advancedhighdegrees need students and professionals in District. The development. average teaching The average experience teaching andexperience educationaland level educational of certfiedlevel staffof has certfied increased staffover has increased those same over fivethose yearssame (see five pageyears 111).(see page xxx).
124
School District Financial Profile Deerfield SD 109 Elementary 34-049-1090-02
Financial Indicators : Fund Balance to Revenue Ratio :
Located in : Superintendent:
Deerfield Dr. Michael Lubelfeld
Basis of Accounting: Under Tax Cap:
Lake
Accrual Yes
Historical Data 2012
2013
2014
2015
2016
Score
0.44
0.433
0.282
0.310
0.369
4
Fund Balance to Revenue Ratio 0.52
(Includes Educational, Operations & Maintenance, Transportation, Working Cash, and negative IMRF/FICA Funds)
Weighted Score
1.40 0.48
Total Fund Balance divided by Total Revenue
18,767,293 50,917,453
0.44 0.40
The Fund Balance to Revenue Ratio reflects the impact of additional revenues to the existing fund balances of the district. Fund Balances, to a district, can be viewed as savings or checking account balances to the average citizen. A ratio of .25 or greater scores 4, between .25 and .10 scores 3, between .10 and zero scores 2 and a negative fund balance to revenue ratio scores 1.
0.36
2012
2013
2014
2015
2016
Score
0.96
0.94
0.957
0.960
0.929
4
0.32
(Includes Educational, Operations & Maintenance, Transportation, and Working Cash Funds)
Weighted Score
20 16
20 15
0.98 0.97 0.96
2012
2013
2014
2015
2016
Score
0.95
360
369
301
311
347
4
0.94
0.40
0.93
(Includes Educational, Operations & Maintenance, Transportation, and Working Cash Funds)
Weighted Score
45,545,829
20 16
20 15
131,333
Days Cash on Hand reflects the number of days a school district would be able to pay their average bills without any additional revenues. 180 days or greater scores 4, between 90 and 180 scores 3, between 30 and 90 scores 2 and less than 30 days of cash on hand scores 1.
20 14
0.92 20 12
Cash on Hand divided by Expenditures per Day
20 14
Expenditure to Revenue Ratio
The Expenditure to Revenue Ratio represents how much the school district is spending for every dollar they are bringing in as revenue. Equal to or less than $1.00 has a score of 4, between $1.00 and $1.10 scores 3, between $1.10 and $1.20 scores 2 and spending of greater than $1.20 scores 1. One-time expenditures made by the district, including construction costs, are included in this ratio. Upon review of the remaining fund balance when deficit spending occurs, the indicator score may be adjusted.
Days Cash on Hand :
20 13
1.40
47,279,935 50,917,453
20 13
Total Expenditure divided by Total Revenues
20 12
0.28
Expenditure to Revenue Ratio :
Days Cash on Hand
2012
2013
2014
2015
2016
100.00
100.00
100.00
100.00
100.00
Score
400 380
% of Short-Term Borrowing Max. Remaining :
Tax Anticipation Warrants Short-Term Debt Max. Available
0 39,659,955
Weighted Score
4 0.40
360 340 320
Based on Tax Anticipation Warrants, this represents how much short-term debt the district may incur. 300
Long-Term Debt Amount Represents how much long-term debt the district may incur.
Score
86.73
87.76
83.940
76.37
79.96
4
Weighted Score
21,370,000 125
280
0.40
FY 15 Profile Score 4.00 FY 16 Profile Score 4.00
Recognition
20 16
2016
20 15
2014
20 14
2014
20 13
2013
20 12
% of Long-Term Debt Margin Remaining :
2012
School District Financial Profile Deerfield SD 109
Located in :
Deerfield
Elementary 34-049-1090-02
Superintendent:
Dr. Michael Lubelfeld
Accrual
Under Tax Cap:
Yes
Revenues and Expenditures
2013
2014
2015
2016
19,887,391
19,746,668
20,610,774
13,587,791
15,318,462
52M
45,435,562
47,075,219
48,239,626
49,405,470
50,917,453
50M
43,177,906
44,027,979
46,174,607
47,411,232
47,279,935
48M
2,257,656
3,047,240
2,065,019
1,994,238
3,637,518
46M
(2,398,379)
(2,183,134)
(9,088,002)
(263,567)
(188,687)
13,587,791
15,318,462
18,767,293
0
0
0
0
0
44M 42M
* The Operating Funds include the Educational, Operations and Maintenance, Transportation and Working Cash Funds. For further analysis of the district's ability to levy and transfer monies into the operations of a district, the Working Cash Fund has been pulled separate below. Districts may transfer money from the working cash fund to any of the operating funds as a loan.
126
20 16
20,610,774
Revn. Expnd.
20 15
19,746,668
54M
20 14
Working Cash Ending Fund Balance
2012
Basis of Accounting:
20 13
Beginning Fund Balance + Revenues - Expenditures = Results of Operations + Other Receipts and Adjustments Ending Fund Balance
Historical Data
20 12
*Operating Funds Summary :
Lake
127
ILLINOIS STATE BOARD OF EDUCATION School Business Services Division (N‐330) 100 North First Street Springfield, IL 62777‐0001 LIMITATION OF ADMINISTRATIVE COSTS WORKSHEET (Section 17‐1.5 of the School Code)
Description Funct. No. Executive Administration Services 2320 Special Area Administration Services 2330 Other Support Services ‐ School Administration 2490 Direction of Business Support Services 2510 Internal Services 2570 Direction of Central Support Services 2610 Deduct ‐ Early Retirement or other pension 7. obligations required by state law and included above. 8. Totals 9. Percent Increase (Decrease) for FY2018(Budgeted) over FY2017 (Actual)
1. 2. 3. 4. 5. 6.
School District Name: DEERFIELD PUBLIC SCHOOL DISTRICT NO. 109 RCDT Number: 34‐049‐1090‐02 Actual Expenditures, Fiscal Year 2017 (10) (20) Operations & Maintenance Fund Educational Fund 613,229 0 0 551,094 0 0 0
1,164,324
Budgeted Expenditures, Fiscal Year 2018 (10) (20) Operations & Maintenance Fund Total Educational Fund 613,229 892,699 0 0 551,094 664,376 0 0 0 0
0
0 1,164,324
1,557,075
CERTIFICATION I certify that the amounts shown above as "Actual Expenditures, Fiscal Year 2017" agree with the amounts on the district's Annual Financial Report for Fiscal Year 2017. I also certify that the amounts shown above as "Budgeted Expenditures, Fiscal Year 2018" agree with the amounts on the budget adopted by the Board of Education.
Signature of Superintendent
Date
If line 9 is greater than 5% please check one box below. The District is ranked by ISBE in the lowest 25th percentile of like districts in administration expenditures per student (4th quartile) and will waive the limitation by board actions, subsequent to a public hearing. Waiver resolution must be adopted no later than June 30. The District is unable to waive the limitation by board action and will be requesting a waiver from the General Assembly pursuant to the procedured in Chapter 105 ILCS 5/2‐3.25g. Waiver applications must be postmarked by August 11, 2017 to ensure inclusion in the Fall 2017 report, postmarked by January 14, 2018 to ensure inclusion in the Sprin 2018 reporit, or postmarked by August 10, 2018 to ensure inclusion in the Fall 2019 report. Information on the waiver process can be found at www.isbe.net/isbewaivers/default.htm. The district will amend their budget to become in compliance with the limitation. Budget amendments must be
128
0
Total 892,699 0 0 664,376 0 0
0 1,557,075 TBD at 6/30/17
FY16DeerfieldPublicSchools109PARCCELAandMathResults–AllGrades
129
FY16 Deerfield Public Schools 109 PARCC ELA and Math Results by Grade Level
130
FY16 Deerfield Public Schools 109 PARCC ELA and Math Results by Demographics
131
PARCC Results and Benchmark Districts Comparison 2015-16
2016 PARCC ELA and Math M&E %‐ Overall
2016 PARCC ELA and Math M&E %‐ Grade 3 90 80 70 60 50 40 30 20 10 0
100 80 60 40 ELA
20
MATH
0
MATH
2016 PARCC ELA and Math M&E %‐ Grade 5
2016 PARCC ELA and Math M&E %‐ Grade 4 90 80 70 60 50 40 30 20 10 0
ELA
90 80 70 60 50 40 30 20 10 0
ELA MATH
132
ELA MATH
PARCC Results and Benchmark Districts Comparison 2015-16
2016 PARCC ELA and Math M&E %‐ Grade 7
2016 PARCC ELA and Math M&E %‐ Grade 6 90 80 70 60 50 40 30 20 10 0
90 80 70 60 50 40 30 20 10 0
ELA MATH
2016 PARCC ELA and Math M&E %‐ Grade 8 90 80 70 60 50 40 30 20 10 0
ELA MATH
133
ELA MATH
MAP TEST RESULTS 2016
134
135
136
137
Glossary
21st Century Skills ‐ The essential skills for success in today’s world – such as critical thinking, problem solving, communication and collaboration – taught in a way that builds informational, media, and technology literacy. Accrual Basis – Basis of accounting under which revenues are recorded when levied and expenditures are recorded as soon as the =y result in liabilities regardless of when the revenue is actually received or the payment is actually made. Amortization ‐ The gradual elimination of a liability, such as a debt, in regular payments over a specified period of time. Such payments must be sufficient to cover both principal and interest. Assessed Value – The value placed on property for tax purposes and used as the basis of division of the tax burden. This amount is subject to the State equalization factor and the deduction of exemptions. Benchmarking – A measurement of performance of the District against similarly socioeconomic and demographic districts. Board of Education – An elected board consisting of seven members, created according to State law, and vested with responsibilities for educational activities within a geographic area. The Board establishes policy, hires the Superintendent, and governs the operations of the district. Bond – A written promise to pay a specific sum of money (face value) at a fixed time in the future (maturity) and carrying interest at a fixed rate of interest usually paid periodically. Budget – A plan of financial operation embodying an estimate of proposed expenditures for a given period or purpose and the proposed means of financing them. Budgetary Control – The control or management of the business affairs of the district in accordance with an approved budget with responsibility to keep expenditures within the authorized amount. Capital Budget – A plan of proposed capital spending and the means of financing them for the current fiscal period. It is generally part of the districts overall budget. Capital Projects Fund – The fund that accounts for financial resources to be used for the acquisition, construction, or improvement of major capital facilities. Categorical State Aid – Revenue allocated by the State for various categories of programs administered by the local district. Examples of categorical state aid include special education,
138
special education transportation, bilingual education, gifted education, etc. These funds do not cover the entire program cost but must be supplemented by other district revenue. Consumer Price Index (CPI) – A measure that examines the weighted average of prices of a basket of consumer goods and services, such as transportation, food and medical care. It is calculated by taking price changes for each item in the predetermined basket of goods and averaging them. Corporate Personal Property Replacement Taxes (CPPRT or Replacement Taxes) – Revenue collected by the state of Illinois and paid to local governments to replace money that was lost by local governments when their powers to impose personal property taxes on corporations, partnerships, and other business entities were taken away. Debt – An obligation resulting from borrowing of money or the purchase of goods and services. Debts of local education agencies include bonds, warrants, and notes, etc. Debt Limit – The maximum amount of general obligation debt which is permitted by law. Debt Service – Expenditures for the retirement of debt and the payment of interest. Debt Service Fund – The fund that accounts for the accumulation of resources for, and the payment of general long‐term debt principal, interest, and related costs. Deficit – the excess of an entity’s liabilities over its assets or the excess of expenditures over revenues during a single accounting period. Education Fund – The general operating fund of the District used to account for all financial resources except those that are required to be accounted for in another Fund. Employee Benefits – May include health, dental, vision, life, and long term disability, and workers compensation insurance as well as social security and retirement pension payments. Encumbrance – The commitment of budgeted funds to purchase an item or service. To encumber funds means to set aside or commit funds for future expenditures. Equalization – The application of a uniform percentage increase of decrease of values of various areas or classes of property to bring assessment levels, on average, to a uniform level of market value. Equalization Factor – The factor that must be applied to local assessments to result in an equalized assessed value of taxable property equal to one third of market value.
139
Equalized Assessed Value (EAV) – The assessed value multiplied by the State equalization Factor. This gives the value of the property from which the tax rate is calculated after deducting any applicable exemptions. Exemption – Removal of property from the tax base. Exemption may be partial, as a homestead exemption, or complete as, for example, a church building used exclusively for religious purposes. Expenditure – A charge incurred, whether paid or unpaid, for current costs, capital outlay, or debt service. Extension – the process by which the county clerk determines the tax rate needed to raise the revenue (levy) certified by each school district in the country. 2) The actual dollar amount billed to the taxpayers in a district. Fiduciary Funds – Funds that account for assets held by the District in a trustee capacity or as an agent for individuals, private organizations, other governments or other funds. Fire Prevention and Safety Fund – A restricted fund to be used by schools to correct Health and Life Safety violations. It may also be used for asbestos abatement, roof repair or replacement, building replacement, energy conservation, security measures, accessibility needs, paving repairs and other projects identified as necessary to maintain healthy and safe buildings. Fiscal Year (FY) – The fiscal year for Illinois School districts begins on July 1 and ends on June 30. The fiscal year beginning on July 1, 2017 and ending June 30, 2018 is the 2018 fiscal year or FY2018. Full Time Equivalent (FTE) –An amount of employed time, expressed as a percentage, where 1 FTE represents one full time employee for 1 full year. Function – A group of related activities aimed at accomplishing a major service or program, such as instruction, supporting services, community services, etc. Fund – Funds are individual accounting entities with a self‐balancing set of accounts. Fund Balance – The excess of assets of a fund over its liabilities and reserves. Grants – Contributions or gifts of cash or other assets from another government to be used or expended for a specific purpose, activity, or facility.
140
Instruction – The activities dealing directly with the teaching of students or the improvement of instruction. Levy – The total taxes imposed by a government unit. Municipal Retirement/Social Security Fund – The fund that accounts for activity that relates directly to the District’s share of pension costs associated with maintaining staff. This fund covers employer pension costs such as Illinois Municipal Retirement and Social Security. Object – A category that describes the service or commodity obtained as a result of a specific expenditure. The object categories are salaries, benefits, purchased services, supplies and materials, capital outlay, other transfers, and tuition. Operating Expenses per Student – Includes all costs associated with a district’s operating costs over the regular school year, such as transportation, building maintenance, salaries, etc. Operating Funds – The Funds that account for the resources used to fund the day to day operations of the district. These generally include the Education, Operations & Maintenance, Transportation, Municipal Retirement/Social Security Fund, and Working Cash Funds. Operations and Maintenance Fund – Fund that accounts for activity relating to the maintenance of District facilities and fixed assets. Partnership for Assessment of Readiness for College and Careers (PARCC) – A group of states working together to develop a modern assessment that replaces previous state standardized tests. The test helps ensure that all students have equal access to a world‐class education that will prepare them for success after high school in college and/or careers. Property Tax Extension Limitation Law (PTELL) – A law designed to slow the rate of growth in taxes by limiting the increase in property tax extensions (excluding taxes for Debt Service) to the lesser of 5% or the percent increase in the National Consumer Price Index for All Urban Consumers (CPI‐U) for the previous levy year, plus an additional amount for new property just added to the tax base. Tax Increment Finance (TIF) District ‐ A specially designated districts used as a way to spur economic growth with the hope of encouraging new economic development and jobs. When a TIF is created, future tax revenue from the increased site value generated by development (the tax increment) is dedicated to finance the debt issued to pay for the project. Taxes – Compulsory charges levied by a government for the purpose of financing services performed for the common benefit.
141
Transportation Fund – The fund that accounts for activity that relates to the transportation of students to and from school on a daily basis and for additional interscholastic activities. Working Cash Fund – A reserve fund from which available cash may be loaned to any fund for which taxes are levied. Deerfield Public Schools District 109 does not maintain a Working Cash Fund.
142