MINSTER LOCAL SCHOOL DISTRICT - - AUGLAIZE COUNTY IRN: 45948 Schedule of Revenues, Expenditures and Changes in Fund Balances ACTUAL AND FORECASTED OPERATING FUND
Actual
Forecasted
Fiscal Year 2015
Fiscal Year 2014
Fiscal Year 2016
3yr Avg Change
Fiscal Year 2017
Fiscal Year 2018
Fiscal Year 2019
Fiscal Year 2020
Fiscal Year 2021
1.010 1.020 1.030 1.035 1.040 1.045 1.050 1.060 1.070
Revenues General Property Tax (Real Estate) Tangible Personal Property Tax Income Tax Unrestricted State Grants-in-Aid Restricted State Grants-in-Aid Restricted Federal Grants-in-Aid - SFSF Property Tax Allocation All Other Revenues Total Revenues
3,308,782 54,569 1,653,639 2,567,481 44,780 0 1,225,068 228,926 9,083,245
3,332,169 55,920 1,543,743 2,786,505 63,441 0 1,224,755 235,236 9,241,769
3,405,329 55,682 1,615,419 3,390,317 44,626 0 1,067,336 281,463 9,860,172
1.7% -3.8% 15.9% 13.8% 5.7% 0.0% -4.2% 12.5% 6.5%
3,409,513 58,218 1,479,391 3,546,205 41,440 0 978,855 315,059 9,828,681
3,416,677 58,218 390,712 3,404,682 42,925 0 894,190 299,616 8,507,021
3,478,428 58,218 0 3,427,924 44,560 0 809,563 294,020 8,112,713
3,504,328 58,218 0 3,567,692 44,559 0 725,434 288,027 8,188,259
3,531,548 62,218 0 3,616,002 44,553 0 641,475 257,423 8,153,219
2.010 2.020 2.040 2.050 2.060 2.070 2.080
Other Financing Sources Proceeds from Sale of Notes State Emergency Loans and Advancements (Approved) Operating Transfers-In Advances-In All Other Financing Sources Total Other Financing Sources Total Revenues and Other Financing Sources
0 0 173,029 0 37,944 210,973 9,294,218
0 0 52,979 0 46,054 99,033 9,340,802
0 0 3,700 112,000 55,509 171,209 10,031,381
0.0% 0.0% -102.0% 0.0% 119.5% -44.9% 9.1%
0 0 119,000 0 0 119,000 9,947,681
0 0 119,000 0 0 119,000 8,626,021
0 0 119,000 0 0 119,000 8,231,713
0 0 119,000 0 0 119,000 8,307,259
0 0 119,000 0 0 119,000 8,272,219
4,283,368 1,755,950 1,473,815 232,688 137,291 0
4,414,301 1,814,722 1,452,960 226,070 868,782 0
4,430,186 1,836,091 1,334,823 166,396 385,237 0
1.6% 2.9% -1.4% 5.7% 169.3% 0.0%
4,545,280 1,849,191 1,316,836 189,001 373,867 0
4,700,244 1,926,086 1,270,339 216,051 239,000 0
4,849,400 1,977,034 1,285,008 219,133 239,000 0
4,970,396 2,045,299 1,299,528 202,247 239,000 0
5,117,192 2,123,450 1,303,613 205,394 148,000 0
0 0 0 0 0 0 0 137,054 8,020,166
0 0 0 0 0 0 0 109,948 8,886,783
0 0 0 0 0 0 0 128,485 8,281,218
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 5.6% 2.8%
0 0 0 0 0 0 0 111,451 8,385,626
0 0 0 0 0 0 0 125,500 8,477,220
0 0 0 0 0 0 0 116,000 8,685,575
0 0 0 0 0 0 0 130,500 8,886,969
0 0 0 0 0 0 0 121,000 9,018,648
4.010 4.020 4.030 4.040 4.050 4.055 4.060 4.300 4.500
Expenditures Personal Services Employees' Retirement/Insurance Benefits Purchased Services Supplies and Materials Capital Outlay Intergovernmental Debt Service: Principal-All (Historical Only) Principal-Notes Principal-State Loans Principal-State Advancements Principal-HB 264 Loans Principal-Other Interest and Fiscal Charges Other Objects Total Expenditures
5.010 5.020 5.030 5.040 5.050
Other Financing Uses Operating Transfers-Out Advances-Out All Other Financing Uses Total Other Financing Uses Total Expenditures and Other Financing Uses
231,327 0 0 231,327 8,251,493
54,147 134,371 0 188,518 9,075,301
164,619 0 0 164,619 8,445,837
-19.6% -100.0% 0.0% -72.5% 4.8%
155,000 0 0 155,000 8,540,626
155,000 0 0 155,000 8,632,220
171,395 0 0 171,395 8,856,970
279,072 0 0 279,072 9,166,041
155,000 0 0 155,000 9,173,648
6.010
Excess of Revenues and Other Financing Sources over (under) Expenditures and Other Financing Uses
1,042,725
265,501
1,585,544
199.9%
1,407,055
-6,199
-625,257
-858,782
-901,429
7.010
Cash Balance July 1 - Excluding Proposed Renewal/Replacement and New Levies
7.020
Cash Balance June 30
8.010
Estimated Encumbrances June 30
9.010 9.020 9.030 9.040 9.045 9.050 9.060 9.070 9.080
Reservation of Fund Balance Textbooks and Instructional Materials Capital Improvements Budget Reserve DPIA Fiscal Stabilization Debt Service Property Tax Advances Bus Purchases Subtotal
3.010 3.020 3.030 3.040 3.050 3.060
847,575
1,890,300
2,155,801
72.3%
3,741,345
5,148,400
5,142,201
4,516,944
3,658,162
1,890,300
2,155,801
3,741,345
70.2%
5,148,400
5,142,201
4,516,944
3,658,162
2,756,733
20,000
20,000
20,000
20,000
20,000
20,000
20,000
20,000
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 65,313 65,313
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
0 0 0 0
1,804,987
2,135,801
3,721,345
5,128,400
5,122,201
4,496,944
3,638,162
2,736,733
Revenue from Replacement/Renewal Levies 11.010 Income Tax - Renewal 11.020 Property Tax - Renewal or Replacement
94,429 0
1,204,031 0
1,616,085 0
1,637,854 0
1,660,058 0
11.300 Cumulative Balance of Replacement/Renewal Levies
94,429
1,298,460
2,914,545
4,552,399
6,212,457
5,222,829
6,420,661
7,411,489
8,190,561
8,949,190
0 0
0 0
0 0
0 0
0 0
13.030 Cumulative Balance of New Levies
0
0
0
0
0
14.010 Revenue from Future State Advancements
0
0
0
0
0
5,222,829
6,420,661
7,411,489
8,190,561
8,949,190
10.010 Fund Balance June 30 for Certification of Appropriations
12.010
13.010 13.020
Fund Balance June 30 for Certification of Contracts, Salary Schedules and Other Obligations
1,804,987
2,135,801
3,721,345
Revenue from New Levies Income Tax - New Property Tax - New
15.010 Unreserved Fund Balance June 30
1,804,987
2,135,801
3,721,345
State Fiscal Stabilization Funds 21.010 Personal Services SFSF 21.020 Employees Retirement/Insurance Benefits SFSF 21.030 Purchased Services SFSF 21.040 Supplies and Materials SFSF 21.050 Capital Outlay SFSF 21.060 Total Expenditures - SFSF
See accompanying summary of significant forecast assumptions and accounting policies Includes: General fund, Emergency Levy fund, DPIA fund, Textbook fund and any portion of Debt Service fund related to General fund debt