Spreadsheet: 1450fa48-2af4-480c-9435-d1334fa2c11f
Sheet: SFPR FY2015

Note: This tool is only for simulation purposes based on the district ADM change; it will not affect district payments
Ohio Department of Education
School Finance - Policy and Payment Services
School Finace Payment Report (SFPR) Simulation for JVS - Fiscal Year 2015
Version -1 Date: 5/05/2014
 |  |  |  |  |  |  |  |  |  |  |  | To change the Value, Go to:
JVS IRN: |  | 0
Name: |  |  |  |  | ─
Statewide Factors and Parameters: |  |  |  |  |  |  |  |  |  | Calculated Funding | State Funding | [NAME] | Column
s - | Statewide Economic Disadvantaged Percentage:   ………………………………………………………………….…………...………………..
District Factors and Parameters:
a - | Formula ADM:   ………………………………………………………………………………………………………………….…..………………………….. |  |  |  |  |  |  |  |  |  |  | ADM Detail | D
b - | Special Education ADM Data
 | b1 - | Category 1 Special Education ADM:   ……………………………………………………………………………………….………………… |  |  |  |  |  |  |  |  |  | ADM Detail | E
 | b2 - | Category 2 Special Education ADM:   …………………………………………………………………………………….…………………… |  |  |  |  |  |  |  |  |  | ADM Detail | F
 | b3 - | Category 3 Special Education ADM:   …………………………………………………………………………………….…………………… |  |  |  |  |  |  |  |  |  | ADM Detail | G
 | b4 - | Category 4 Special Education ADM:   …………………………………………………………………………………..…………………….. |  |  |  |  |  |  |  |  |  | ADM Detail | H
 | [NAME] | Category 5 Special Education ADM:   …………………………………………………………………………………….…………………… |  |  |  |  |  |  |  |  |  | ADM Detail | I
 | b6 - | Category 6 Special Education ADM:   ……………………………………………………………………………………..………………….. |  |  |  |  |  |  |  |  |  | ADM Detail | J
c - | Career Tech FTE
 | c1 - | Category 1 Career Tech FTE:   ……………………………………………………………………………………….………………………….. |  |  |  |  |  |  |  |  |  | ADM Detail | K
 | c2 - | Category 2 Career Tech FTE:   ……………………………………………………………………………….…………………………………… |  |  |  |  |  |  |  |  |  | ADM Detail | L
 | c3 - | Category 3 Career Tech FTE:   …………………………………………………………………………….……………………………………… |  |  |  |  |  |  |  |  |  | ADM Detail | M
 | c4 - | Category 4 Career Tech FTE:   …………………………………………………………………………….……………………………………… |  |  |  |  |  |  |  |  |  | ADM Detail | N
 | c5 - | Category 5 Career Tech FTE:   ……………………………………………………………………………….…………………………………… |  |  |  |  |  |  |  |  |  | ADM Detail | O
d - | Limited English Proficient ADM
 | d1 - | Category 1 LEP ADM:   ……………………………………………………………………………………………………………...……………… |  |  |  |  |  |  |  |  |  | ADM Detail | Q
 | d2 - | Category 2 LEP ADM:   ……………………………………………………………………………………………………………………………... |  |  |  |  |  |  |  |  |  | ADM Detail | R
 | d3 - | Category 3 LEP ADM:   ……………………………………………………………………………………………………………………….…….. |  |  |  |  |  |  |  |  |  | ADM Detail | S
e - | Economic Disadvantaged data
 | e1 - | Economic Disadvantaged ADM:   ……………………………………………………………………………………………………………….. |  |  |  |  |  |  |  |  |  | ADM Detail | T
 | e2 - | Economic Disadvantaged Percentage:   ………………………………………………………………………………………………………
 | e3 - | Economic Disadvantaged Index [(e2/s)^2]:   …………………………………………………….……………………………………….…
Detailed Calculation of Funding Components of the Formula:
A - | Opportunity Grant [($5,800*a)-(f*0.0005) if <0 then set equal to 0]:  …………………………………….
B - | State Share Percent [A/($5,800*a)]:  ……………………………………………………………………………….…..
C - | Economic Disadvantaged Funding [$272*e1*e3]:  ………………………………………………………………..
D - | Limited English Proficiency Funding [D1+D2+D3]: ………………………………….……………………………….
 | D1 - | Category 1 Funding [$1,515*d1*B]:   …..……………………………………….…………………………..
 | D2 - | Category 2 Funding [$1,136*d2*B]:  ….…..………………………….……………………………………..
 | D3 - | Category 3 Funding [$758*d3*B]:   ……………………………………….…………………………………..
E - | Special Education Additional Funding [E1+E2+E3+E4+E5+E6]:   …………………….……………………….
 | E1 - | Category 1 Funding [b1*$1,517*B]:  ....……………………………………………………………………..
 | E2 - | Category 2 Funding [b2*$3,849*B]:  ………………..……………………………………………………….
 | E3 - | Category 3 Funding [b3*$9,248*B]:  ………………………………………………………………………….
 | E4 - | Category 4 Funding [b4*$12,342*B]:  ………………………………………………………………………..
 | E5 - | Category 5 Funding [b5*$16,715*B]:   ………….……………………………………………………………
 | E6 - | Category 6 Funding [b6*$24,641*B]:   ……………………………………………………………………….
F - | Career Technical Education Funding [F1+F2+I3+F4+F5+F6]:    ………..………………………………………
 | F1 - | Category 1 Funding [c1*$4,800*B]:   ……………………………………………………………..…………..
 | F2 - | Category 2 Funding [c2*$4,550*B]:   ……………………………………………………………………..……
 | F3 - | Category 3 Funding [c3*$1,660*B]:   …………………………………………………………………………..
 | F4 - | Category 4 Funding [c4*$1,410*B]:   …………………………………………………………………………..
 | F5 - | Category 5 Funding [c5*$1,210*B]:   …………………………………………………………………………..
 | F6 - | Associated Services Funding [(c1+c2+c3+c4+c5)*$225*B]:   ………………………………………….
G - | Total Foundation Funding Before Guarantee [A+C+D+E+F]:    ………………………………………………...
H - | Funding Guarantee Base [FY13 Calculated Funding (Line '6' of the FY13 payment report]:   .……
I - | Transitional Aid Guarantee [if H>G then H-G else 0]:   ……………………………………………………………….…….….…………………….
J - | Total Calculated Funding [G+I]:  ………….………………………………………….……………………………………
J1 | [NAME] for FY2015 [FY2014 Total State Funding (Line-'H' of JVS SFPR Summary Report)] ……..
K - | [NAME] [J1*1.105]:   …………………………………………………………………………………………………………
L - | Total State Funding [if K>J then J else K]:   …………………………………………………………………………………………….…………………
Transfers and Adjustments
M | Education Service Center Transfer:  …………………………………………………………………………………………….………………………...
N | Open Enrollment Adjustment:  ………………………………………………………………………….………………….………………….…..……...
O | Associated Services (Member):  ……………………………………..………………………………………………………………………….…….
P | Other Adjustments:  ……………………………………………………………………………………….………………………….…………………………
Q | Total Transfers and Adjustments(M+N+O+P):  ………………………………………………………………………………………………………..
R | Net State Foundation Funding ([NAME]):  …………………………………………………………………………………………….….……………
Note: Districts are allowed to change highlighted line items variables