FY2017 Career Tech Payment Report Calculator

School Finance Payment Report (SFPR) Calculator Assumptions: 
Simulation Calculator for JVS School Districts

Version 3/18/2016

The link below will allow you to download an excel spreadsheet containing a simulation 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, 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. 64, the FY16-17 budget bill.


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.

Calculator Directions

  1. To view the calculator for a single JVS 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


  • 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
  • Economic disadvantaged ADM

Graduation Bonus

  • Number of graduates and four (4) years adjusted graduation rate

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

  • Formula ADM is based on FY2016 data used in FY2016 March payment.
  • Special education students in categories one to six are based on FY2016 data used in FY2016 March payment.
  • Career tech students in categories one to five are based on FY2015 data used in FY2016 March payment.
  • LEP students in categories one to three are based on FY2016 data used in FY2016 March payment.
  • Economic disadvantaged students are based on FY2016 data used in FY2016 March payment.


  • The default valuation values are based on FY2016 March payment.

Graduation Bonus

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

Transfers and Adjustments

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

Last Modified: 5/18/2018 4:07:49 PM