Docstoc

Simplified Percentage Method of Calculating Equalization Aid Worksheet - Excel

Document Sample
Simplified Percentage Method of Calculating Equalization Aid Worksheet - Excel Powered By Docstoc
					                                     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