Valley View School District 365U September 25 th , 2017 Overall - - PowerPoint PPT Presentation

▶

Jul 04, 2023 48 likes •168 views

Valley View School District 365U September 25 th , 2017 Overall budget $286,030,475 (Increase of 2.6% of prior years actuals) (excludes $60.5M for TRS On-Behalf payment) Operating funds $241,244,100 (increase of $9.5M or 4.12% from FY17

SLIDE 1

Valley View School District 365U

September 25th, 2017

SLIDE 2

Overall budget $286,030,475 (Increase of 2.6% of prior year’s actuals)

(excludes $60.5M for TRS On-Behalf payment)

Operating funds $241,244,100 (increase of $9.5M or 4.12% from FY17 budget)

SLIDE 3

Changes for 2017-2018

Revenue  Corporate Personal Property Replacement Tax (CPPRT) projected decrease - $2.44M or 23.4% due to:

Replacement tax revenues are expected to decrease approximately 2% due to weak domestic

profits

The business income tax refund fund percentage has increased from 17.25% in FY17 to 17.5%

in FY18.

Public Act 100-0021 authorized $297 million in expenditures out of the PPRT fund for FY-18.

 2. General State Aid estimated to increase $1.6 million due to the new funding formula  3. Property tax levy increase of $2.9 million, 50% of which applies to FY18, limited by the Tax cap to 2.1% of the prior year’s extension

SLIDE 4

Changes for 2017-2018

Expenditures

Increase in salary costs of 3.6% per labor agreements, and the increase in the

instructional technology coach positions that were covered via our tech lease last year, as well as the additional staff for the expanded Early Childhood Center, and the associated bus drivers and monitors for the expected enrollment increase at ECC

Benefits are budgeted for an increase of 4.5% in claims costs and fixed costs
Outside placement tuition budget has increased $410K
Increase of $2.4 million in our scheduled debt service payment
Addition of $75,000 to replace three driver’s education cars
Addition of $68K for 75% of the cost for crossing guards in Bolingbrook that were paid

for by the Village in the past

The continuation of our 1:1 technology initiative utilizing a lease-purchase as we have in

the past to procure chromebooks and a new SIS for the coming school year

SLIDE 5

Budget Revisions Since Tentative Budget was Put on Display

Reduced the amount of Mandated Categorical (MCAT) funding to be

received in FY18 by $3.3M due to distribution by the State of that amount of reimbursement in August

Reduce budgeted Corporate Personal Property Replacement Tax

(CPPRT) by over $448K to reflect the estimate to be distributed for FY18 (see Slide 9)

Added $303K for Solar Renewable Energy Credits (SRECs) to be

received by the Illinois Power Agency from installation of the solar panels at 5 of our schools

Reduced budget for contracted speech by $200K due to review of

needed staffing

SLIDE 6

2017-18 Sources of Revenue

Local State* Federal TOTALS FUND Educational $ 127,565,462 $ 112,159,129 $ 18,548,581 $ 258,273,172 Operations and Maintenance $ 17,488,760 $ 303,200 $ 17,791,960 Debt Service $ 30,913,103 $ 30,913,103 Transportation $ 6,396,917 $ 8,504,210 $ 14,901,127 IMRF $ 7,803,650 $ 7,803,650 Capital Projects $ 359,814 $ 359,814 Working Cash $ 198,745 $ 198,745 Tort $ 2,316,300 $ 2,316,300 Fire Prevention and Safety $ 18,424 $ 18,424 $ - TOTALS $ 193,061,175 $ 120,966,539 $ 18,548,581 $ 332,576,295 58% 36% 6% 100%

* Includes $60.54 million in TRS on-behalf payment in book entry only

Percentages change if On-Behalf is NOT included $ 193,061,175 $ 60,428,239 $ 18,548,581 $ 272,037,995 71% 22% 7%

SLIDE 7

Source of Funding Five Year Average

Local State* Federal 2013-14 76% 18% 6% 2014-15 74% 20% 6% 2015-16 73% 21% 6% 2016-17 72% 22% 6% 2017-18 (est.) 71% 22% 7% 5 Year Average 73.2% 20.6% 6.2%

Does not include TRS On-Behalf Payment

SLIDE 8

General State Aid History

Year Amount Difference % Change

2008-09 $ 26,850,995 $ (735,858)

2.7%

2009-10 $ 24,256,950 $ (2,594,045)

9.7%

2010-11 $ 22,943,888 $ (1,313,062)

5.4%

Prorated

2011-12 $ 20,444,408 $ (2,499,480)

10.9%

Prorated

2012-13 $ 18,741,728 $ (1,702,680)

8.3%

Prorated

2013-14 $ 25,518,329 $ 6,776,601 36.2%

Prorated

2014-15 $ 30,497,460 $ 4,979,131 19.5%

Prorated

2015-16 $ 34,346,586 $ 3,849,126 12.6% 2016-17 $ 35,706,727 $ 1,360,141 3.96%

estimated

2017-18 $ 37,306,000 $ 1,599,273 4.48%

SLIDE 9

Corporate Personal Property Replace Tax Historical Distribution

Year CPPRT Accrual Basis % Year over Year Change $ change 2018* $ 7,969,643 76% ($2,442,295) 2017 $ 10,411,938 110% $984,958 2016 $ 9,426,980 92% ($870,242) 2015 $ 10,297,222 108% $722,521 2014 $ 9,574,701 101% $109,985 2013 $ 9,464,716 102% $201,417 2012 $ 9,263,299 92% ($806,284) 2011 $ 10,069,583 130% $2,304,748 2010 $ 7,764,835 81% ($1,833,326) 2009 $ 9,598,161 87% ($1,374,045) * estimated

SLIDE 10

Year to Year Budget Comparison Expenditure Object Report Summary

2017-18 2016-17 ALL FUNDS Object Budget Percent Actual Percent Salaries $ 148,45,932 52.0% 3.61% $ 143,657,236 51.6% Benefits $ 40,141,098 14.0% 5.6% $ 38,002,682 13.6% Purchased Services $ 25,948,966 9.1% 13.9% $ 22,780,221 8.2% Supplies and Materials $ 13,605,099 4.8% 4.0% $ 13,077,380 4.7% Capital Outlay $ 13,028,101 4.6%

30.0%

$ 18,620,627 6.7% Other Objects $ 43,896,885 15.3% 7.3% $ 40,923,828 14.7% Non-Capitalized Equip. $ 406,644 0.1%

73.5%

$ 1,532,917 0.6% Post Employment Benefits $ 157,750 0.1% 108.2% $ 75,763 0.0% Total $ 286,030,475 100.0% 2.6% $ 278,670,654 100.0% Education Fund Object Budget Percent Actual Percent Salaries $ 135,900,852 68.2% 4.3% $ 130,305,802 69.4% Benefits $ 30,066,148 15.1% 6.7% $ 28,189,438 15.0% Purchased Services $ 14,069,636 7.1% 29.7% $ 10,849,676 5.8% Supplies and Materials $ 7,850,928 3.9% 14.1% $ 6,879,369 3.7% Capital Outlay $ 496,500 0.2%

54.9%

$ 1,101,218 0.6% Other Objects $ 10,381,310 5.2% 3.4% $ 10,039,120 5.3% Non-Capitalized Equip. $ 352,444 0.2%

17.7%

$ 428,001 0.2% Post Employment Benefits $ 95,000 0.0% 55.8% $ 60,964 0.0% Total $ 199,212,818 100% 6.0% $ 187,853,588 100%

SLIDE 11

Projected Revenues, Expenditures and Fund Balances for Fiscal Year Ending June 30th, 2018

Beginning Fund Balance Education Operations & Maint Transportation IMRF/FICA Tort Working Cash Total 1 **As of June 30, 2017 $ 34,543,341 $ 4,266,031 $ 1,324,353 $ 2,388,765 $ 912,130 $ 19,482,258 $ 62,916,878 2 Revenues: $ 197,734,872 $ 17,791,960 $ 14,901,127 $ 7,803,650 $ 2,316,300 $ 198,745 $240,746,654 3 Expenses: $ 199,212,818 $ 18,449,862 $ 13,461,470 $ 7,803,650 $ 2,316,300 $ - $241,244,100 Note: excludes TRS On Behalf of $60.54M 4 Estimated Ending Balance:

$ 33,065,395 $ 3,608,129 $ 2,764,010 $ 2,388,765 $ 912,130 $ 19,681,003 $ 62,419,432

5 Difference $ (1,477,946) $ (657,902) $ 1,439,657 $ - $ - $ 198,745 $ (497,446) % change in fund balance

4.28%
15.42%

108.71% 0.00% 0.00% 1.02%

0.79%

6 # Days cash on hand 6/30/18

61 71 75 112 144 94

Fund balance divided by (expenses/365)

NOTE: District owed $5.5M in categorical grants from FY17

SLIDE 12

5 YEAR FUND BALANCE HISTORY

As of July 1, 20XX Fund **2017 *2016 2015 2014 2013 Education $ 24,948,991 $ 24,947,873 $22,158,242 $19,977,432 $ 25,095,504 Food Service $ 9,594,350 $ 8,818,009 $ 8,127,080 $ 7,273,850 $ 6,825,818 Subtotal $ 34,543,341 $ 33,765,882 $30,285,322 $27,251,282 $ 31,921,322 Operations and Maintenance $ 4,266,031 $ 4,763,688 $ 7,643,950 $ 8,561,168 $ 9,341,110 Transportation $ 1,324,353 $ 1,227,408 $ 4,345,579 $ 4,950,799 $ 4,892,918 IMRF/Social Security $ 2,388,765 $ 2,132,731 $ 2,219,185 $ 2,087,742 $ 2,165,106 Working Cash $ 19,482,258 $ 18,867,555 $17,804,277 $17,231,057 $ 17,173,009 Tort $ 912,130 $ 1,682,692 $ 1,816,940 $ 1,095,362 $ 953,321 Life Safety $ 4,117 $ 887,653 $ 412,892 $ 406,636 $ 378,854 $ 62,920,995 $ 63,327,609 $64,528,145 $61,584,046 $ 66,825,640 NOTE: *District owed $4.2M in categorical grants from FY16 **District owed $5.5M in categorical grants from FY17