Career Tech Financial Payment Report Calculator

School Finance Payment Report (SFPR) Simulation Assumptions:

Simulation Calculator for JVS School Districts

Version 5/6/2014

The link below will allow you to download an excel spreadsheet containing a simulation of the SFPR for FY2015.  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, special education students, career tech students, limited English proficiency (LEP) students, and economic disadvantaged 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 estimates only. The actual state funding that districts will receive in FY2015 depends on a number of variables. Some of these variables can be adjusted in the simulation calculator (see list below) but others cannot (such as open enrollment and associated services).

To view the simulation for a single JVS 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 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


JVS Districts and Statewide IRN (highlighted cell)

ADM Details

Formula ADM, special education student categories one to six, LEP categories one to six, career tech categories one to five, and  economic disadvantaged ADM


To download the calculator, please click on the link below

Download simulation calculator

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, which will include a new method of counting students for funding purposes.  Rather than an October count, each district will be funded based on annualized FTE enrollment.

Data Sources for pre-populated variables:

Student Data:

  • Formula ADM is based on FY2014 April payment.
  • Special education students in categories one to six are based on FY2014 April payment.
  • Career tech students in categories one to five are based on FY2014 April payment.
  • LEP students in categories one to three are based on FY2014 April payment.
  • Economic disadvantaged students are based on FY2014 April payment.


  • The default valuation values are based on FY2014 April payment.

Transfers and Adjustments:

  • The ESC transfer, open enrollment adjustment, associated services, and other adjustments are based on FY2014 April payment.


Last Modified: 5/22/2014 11:50:14 AM