Current Year Calculation Resources

• Current Year Section 20 Calculation

An Excel spreadsheet allowing you to input data and calculate Section 20 amounts for the current year

• How to Calculate your State Aid Payment

An Adobe .pdf document based upon a State Aid Status Report, which provides formulas for many State Aid calculations.

Calculation of adjustments to Sections 22a, 22b, and 51c for FY 2001-2006

• FY 07 Sections 22a,22b,51c,Prior Year Adjustments
• FY 06 Sections 22a,22b,51c,Prior Year Adjustments
• FY 05 Sections 22a,22b,51c,Prior Year Adjustments
• FY 04 Sections 22a,22b,51c,Prior Year Adjustments
• FY 03 Sections 22a,22b,51c,Prior Year Adjustments
• FY 02 Sections 22a,22b,51c,Prior Year Adjustments
• FY 01 Sections 22a,22b,51c,Prior Year Adjustments

These Excel workbooks demonstrate the calculation of prior year adjustments using pre-loaded current district information.  The use of these spreadsheets require that macro security be set to Medium or Low in Excel.  (Tools, Options, Security, Macro Security)

Calculation of adjustments to Section 20 for FY 1995-2000

• Calc. Worksheet for 1995-2000 prior year Section 20 adj.
  
  This Excel spreadsheet can be used in conjunction with previous State Aid Status Reports and the "Original" and "Current" documents below in order to calculate prior year Section 20 adjustments.

Section 20 Original Data

• Fiscal Year 2000 Section 20 Original
• Fiscal Year 1999 Section 20 Original
• Fiscal Year 1998 Section 20 Original
• Fiscal Year 1997 Section 20 Original
• Fiscal Year 1996 Section 20 Original
• Fiscal Year 1995 Section 20 Original

Section 20 Current Data

• Fiscal Year 2000 Section 20 Current
• Fiscal Year 1999 Section 20 Current
• Fiscal Year 1998 Section 20 Current
• Fiscal Year 1997 Section 20 Current
• Fiscal Year 1996 Section 20 Current
• Fiscal Year 1995 Section 20 Current