School Finance Payment Report Calculator

School Funding Payment Report (SFPR) Simulation Assumptions:

Simulation Calculator for Local, City, and Exempted Village School Districts

Version 2/03/2014

The link below will allow you to download an excel spreadsheet containing a simulation of the SFPR for FY2014.  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, open enrollment and community school students. The foundation aid is calculated using formula established in AM. Sub. H. B. 59, the FY14-15 Budget bill.

It is important to understand that the spreadsheet’s revised calculations are just estimates. The actual state funding that districts will receive in FY2014 depends on a number of variables. Some of these variables can be adjusted in the simulation calculator (see list below) but others cannot in the current version of the spreadsheet (such as special education transportation funding).

To view the simulation for a single district, please save the simulation calculator on your computer before changing ADM figures. Then, enter the IRN for the district in the highlighted IRN field (cell C7) on the work sheet “SFPR FY2014.” To change the factors used in the simulation, open the worksheets according to the chart below. Please read the instructions sheet before changing any factor.



Factors that May Be Changed


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, Tuition KDG FTE, Brick & Mortar Community and STEM school formula ADM, E-school formula ADM, Jon Peterson, scholarship ADM, and Autism scholarship ADM.


Districts preschool special education student categories one to six

OE ADM Details

Districts Open enrollment student Entering & Leaving

CS ADM Details

Districts Community School enrollment


To download the calculator, please click on the link below

The worksheet includes “default” numbers for the variables that are changeable. You will need to enter your own estimates of the factors for the calculator to generate your estimate of state foundation aid! The actual foundation payment for school districts will use different estimate, and of course the final payments to disticts in FY2014 will be based on actual data, including FY2014 October Count data.

Below is an explanation of the data sources for the “default” numbers:

Student Data:


  • The default valuation values are the actual values that will be used for FY14 foundation aid, and should not change.
  • Three years Agriculture Real, Total Real Property and Assessed valuation for FY 2012, 2013 and 2014 are based on certified valuation provided by the Ohio Department of Taxation (ODT) for the Tax Year 2010, 2011, 2012.
  • Federal Adjusted Gross Income for FY 2011, 2012 and 2013 are based on certified valuation provided by the Ohio Department of Taxation for the Tax Year 2009, 2010, 2011.

Additional Items:

  • Preschool special education students in categories one to six are based on FY2013 data.
  • Special education transportation funding is based on the FY2014, January #2 payment.

Transfers and Adjustments:

  • The ESC deduction, Community School, STEM and Scholarship transfer are taken from the FY2014, December # 1 payment.
  • Open Enrollment and Other adjustments are taken from the FY2014, January #2 payment.


Last Modified: 2/3/2014 3:58:33 PM