ESC Simulation Calculator

ESC Simulation Calculator for FY2015

School Finance Payment Report (SFPR) Simulation Calculator for Educational Service Center (ESC)

Version -1 Date: 5/09/2014


The link below will allow ESCs to download an excel spreadsheet containing an ESC simulation calculator for FY2015. The purpose of this calculator is to generate estimates of state funding with the user’s own estimates of student enrollment including, total student count, and preschool special education student category 1-6. The simulation funding is calculated using formulas established in Am. Sub. H. B. 59, the FY2014-15 budget Bill.

It is important to understand that the spreadsheet’s revised calculations are estimates only. The actual state funding that ESCs will receive in FY2015 depend on a number of variables. 

To view the simulation for a single ESC, please save the simulation calculator on your computer before changing any factor. Then, enter the IRN for the ESC in the highlighted IRN field (cell C7) on the worksheet tilled “SFPR FY2015.” 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


ESCs IRN (highlighted cell C7)

District Reports

Total student count, preschool special education student categories one to six, district’s per-pupil amounts $6.50/Above, and district’s state share index

Contracts FY15

ESCs may change the school districts deduction amounts.


To download the calculator, please click on the link below:

ESC Simulation Calculator FY2015

The worksheet includes pre-populated 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 FY2015 foundation payments for ESCs will be based on actual data.

Data Sources for pre-populated variables:

  • Preschool special education students in categories one to six are based on FY2014, April # 2 payment.
  • Total student count is based on FY2014, April # 2 Payment.

Other items:

  • District’s per-pupil amount $6.50/Above is based on FY2014, April # 2 payment.
  • District’s state share index is based on FY2015 simulation.
  • Additional contract amounts are based on FY2014 April # 2 payment.




Last Modified: 12/29/2015 10:41:10 AM