FY15 Community School Payment Report Calculator

School Finance Payment Report (SFPR) Simulation Assumptions:

                        Simulation Calculator for Community School, STEM, and E-School

Version 05/16/14

The link below will allow you to download an excel spreadsheet providing a community school, STEM and E-School simulation calculator” for FY2015. The purpose of this calculator is to generate estimates of state foundation funding by allowing the user to enter the user’s own estimates of student enrollment including, total student full time equivalents (FTE), special education student categories 1-6, economic disadvantaged students, limited English proficiency   (LEP) categories 1-3, K-3 FTE, and career tech categories 1-5. 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 calculations are estimates only. The actual state funding that schools will receive in FY2015 depends on a number of variables.

To view the simulation for a single school, please save the simulation calculator on your computer before changing FTE figures. Then, enter the IRN for the district in the highlighted IRN field (cell C7) on the work sheet “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


Schools and Statewide IRN (highlighted cell)

ADM Details FY15

Total student FTE, special education student categories one to six, LEP categories one to three, career tech categories one to five, K-3 FTE, economically disadvantaged ADM

ESC Deduction

Schools may change the ESC deduction amount.


To download the calculator, please click on the link below

The worksheet includes pre-populated variables that are changeable. The source for these variables is 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 FY2015 foundation payments will be based on actual data.

Data Sources for pre-populated variables:

Student Data:

  • Total student FTE is based on FY2014 May payment.
  • Special education students in categories one to six are based on FY2014 May payment.
  • Career tech students in categories one to five are based on FY2014 May payment.
  • Limited English Proficiency (LEP) students in categories one to three are based on FY2014 May payment.
  • Economically disadvantaged and K-3 FTE are based on FY2014 May payment.


  • Economically disadvantaged index and targeted assistance per-pupil amount are based on FY2015 simulation.


Additional Items:

  • ESC deduction is based on FY2014 May payment.








Last Modified: 10/9/2015 12:01:54 PM