# Simplified Percentage Method of Calculating Equalization Aid Worksheet - Excel

Document Sample

```					                                     Worksheet: www.dpi.state.wi.us/dpi/dfm/sfms/xls/simaid00.xls
1999-2000 ESTIMATE             (Based on Conference Committee Action)               October 15, 1999
SIMPLIFIED PERCENTAGE METHOD OF CALCULATING EQUALIZED AID
State Factors used in the October aid certification are based on Conference Committee action.
Place numbers in colored spaces only. All totals are automatically calculated.
UHS / K8, enter 2 / 3
1=K-12; 2=UHS; 3=K-8                           1
Local Factors:                                           State Factors:
A7: 98-99 Aid Membership                                         Primary cost ceiling:               \$1,000
E5: 98-99 Total Shared Cost                                    Secondary cost ceiling:               \$6,430
F1: 1998 TIF-Out Valuation                                         Primary guarantee:              \$2,000,000
Cost per Pupil                               #DIV/0!            Secondary guarantee:                \$765,441
Equalized Value Per Pupil                    #DIV/0!               Tertiary guarantee:              \$280,880

Primary Level            Secondary Level Tertiary Level
District Shared Cost per Pupil              #DIV/0!                   #DIV/0!           #DIV/0!
District Value Per Pupil                    #DIV/0!                   #DIV/0!           #DIV/0!
Guaranteed Value Per Pupil                   \$2,000,000                   \$765,441         \$280,880
Percent Local Share*                        #DIV/0!                   #DIV/0!           #DIV/0!
Local Share Per Pupil**                     #DIV/0!                   #DIV/0!           #DIV/0!
State Share Per Pupil                       #DIV/0!                   #DIV/0!           #DIV/0!
Percent State Share                         #DIV/0!                   #DIV/0!           #DIV/0!
Total Equal Aid (G5,G10,G15)                #DIV/0!                   #DIV/0!           #DIV/0!

H3:   Calculated Aid (not < than G5)         #DIV/0!
H4:   Prior Year Eq Adjustment                                 (final 98-99 eq aid eligibility vs. oct est)
H5:   Calculated Eq Aids (H3 + H4)                 #DIV/0!
H6:   MPCP Reduction (-.00619 * H5)                #DIV/0!
H7:   MCP Reduction (-.00032 * H5)                 #DIV/0!
H8: Est Eq Aid Payment                             #DIV/0!
(H5 + H6 + H7)
Aid per Pupil                                #DIV/0!
Total Equal Aid Percent                      #DIV/0!

* Percent Local Share is District Value per Pupil divided by State Guaranteed Value per Pupil.
** Local Cost per Pupil is Percent Local Share multiplied by District Shared Cost per Pupil.
JFC K-12 Guarantees      District Type Multiplier
2000000                1
765441                1
280880                1

Page 1

```
DOCUMENT INFO
Shared By:
Categories:
Stats:
 views: 10 posted: 3/25/2010 language: English pages: 1
How are you planning on using Docstoc?