FY2017 Traditional Public School Payment Report Calculator

School Funding Payment Report (SFPR) Calculator Assumptions: Calculator for Local, City, and Exempted Village School Districts

Version 3/18/2016

The link below will allow you to download an excel spreadsheet containing a calculator for the FY2017 SFPR. The purpose of this tool is to generate estimates of state foundation funding by allowing the user to enter the user’s own estimates of student enrollment including typical students, preschool special education students, and open enrollment students. The foundation aid is calculated using formula established in Am. Sub. H.B. 64, the FY16-17 budget bill.

IMPORTANT DISCLAIMER

Please note that any projections generated by the calculators and simulations are estimates only. All schools should exercise caution when using these tools to make personnel, budget, and planning decisions for the FY17 school year. Schools will be able to use the calculators to project estimated FY17 payments under various scenarios. The calculators and simulations are not guarantees of FY17 funding levels as actual enrollment data will be different.  

The calculators and simulations will be based on the most up-to-date data used in March FY16 payments. It is important to note the March payments use FY16 data, and in some cases, FY15 data. The default data in the calculators will also be based on FY16 data and some FY15 data. Actual FY17 payments will be based on FY17 data and will change throughout FY17 as data is updated, corrected, etc.

There may be differences between the FY17 simulations and default FY17 calculator calculations. The differences are due to rounding errors produced by Excel and the simulation program. The simulations and calculators use the same formulas, factors, and assumptions. Again, these are estimates of FY17 payments using FY16 data and assumptions of how payments, deductions, and transfers may change. Actual FY17 payments will be different. Some of these variables can be adjusted in the calculator (see list below) but others cannot (such as special education transportation funding).

Calculator Directions

  1. To view the calculator for a single district, please save the calculator spreadsheet on your computer before changing ADM figures.
  2. Then, enter the IRN for the district in the highlighted IRN field (cell C7) on the work sheet “SFPR FY2017.”
  3. To change the factors used in the calculator, open the worksheets according to the chart below.
  4. The calculator contains additional detailed instructions. Please read the instructions sheet before changing any factors.

Calculator Factors Subject to Change

Excel Worksheet Tab

Factors that May Be Changed

SFPR FY2017

  • Districts and Statewide IRN (highlighted cell)

ADM Details

  • Districts total ADM
  • jointure JVS ADM
  • Special education student categories one to six
  • LEP categories one to six
  • Career Tech categories one to five
  • K-3 ADM
  • Preschool autism scholarship ADM
  • K-3 E-school formula ADM
  • Economic disadvantaged ADM
  • EdChoice total ADM
  • Contract CTE FTE
  • Tuition KDG FTE
  • Brick & mortar community and STEM school formula ADM
  • E-school formula ADM
  • Jon Peterson scholarship ADM
  • Autism scholarship ADM.

PSE ADM

  • Districts preschool special education student categories one to six

Graduation and Third Grade Bonus

  • District number of graduates
  • 3rd grade number of students scoring proficient
  • 4 years adjusted graduation rate
  • 3rd grade reading proficiency rate

OE ADM Details

  • Districts open enrollment student entering & leaving

Click on the link below to download the calculator

Data Sources for Pre-Populated Variables

Please note that most default pre-populated data variables are based on FY16 data; however, some are still based on FY15 data. 

The worksheet includes pre-populated variables that are changeable. The source for these variables are explained in detail below. You will need to enter your own estimates of the factors for the calculator to generate your estimate of state foundation aid. The actual FY2017 foundation payments for school districts will be based on actual data. It is anticipated that actual FY2017 data will first be used in payments by November 2016.

Student Data

  • Total Average Daily Membership (ADM) is based on FY2016 data used in FY2016 March # 2 payment.
  • Special education students in categories one to six are based on FY2016 data used in FY2016 March # 2 payment.
  • Career tech students in categories one to five are based on FY2015 data used in FY2016 March # 2 payment.
  • Limited English Proficiency (LEP) students in categories one to three are based on FY2016 data used in FY2016 March # 2 payment.
  • Economic disadvantaged students are based on FY2016 data used in FY2016 March # 2 payment.

Valuation

  • The default valuation values are the actual values that will be used for FY17 foundation aid and should not change.
  • Agriculture real, total real property and assessed valuation for FY 2015, 2016 and 2017 are based on certified valuation provided by the Ohio Department of Taxation (ODT) for the Tax Years 2013, 2014, 2015
  • Federal Adjusted Gross Income for FY 2014, 2015 and 2015 are based on certified valuation provided by the Ohio Department of Taxation for Tax Years 2012, 2013, 2013

Graduation Bonus

  • Four year adjusted graduation rate and number of graduates are based on FY2015 Report Card data used in FY2016 March # 2 payment

Third Grade Reading Bonus

  • Third grade reading proficiency rate and the number of students scoring proficient or higher on third grade reading test are based on FY2015 Report Card data used in FY2016 March # 2 payment.

Additional Items

  • Preschool special education students in categories one to six are based on FY2015 data used in FY2016 March #2 payment.
  • Special education transportation funding is based on the FY2015 data used in FY2016 March # 2 payment.

Transfers and Adjustments

  • The ESC deduction based on FY2016 March # 2 payment
  • Community school and STEM school transfers are based on the FY2016 March # 2 payment. The transfer amount for FY17 is increased by 3.8% to account of increases in many of the per pupil amounts. The actual deduction may be more or less depending on changes in participation and specific student enrollment demographics.
  • Scholarship transfers use the March #2 amount without any increase. The amount of the EdChoice scholarship for high school students will increase from $5,900 to $6,000 in FY17. Actual deductions may be more or less depending on participation in the scholarship programs.   
  • Open Enrollment and Other adjustments are based on the FY2016 March # 2 payment and increased based on FY2017 formula and factors.

Last Modified: 6/20/2016 3:07:31 PM