School Financial Services - Executable Worksheets

The worksheets on this page are Microsoft Excel files containing pre-written formulas that calculate school finance computations. Users enter district-specific data elements, the worksheet computes the results. Some recent years' Excel files contain a second, non-executable spreadsheet that can be printed and filled in by hand.

State Tuition Claim Eligibility for Certain Group Home Residents

State Tuition Claim Eligibility for Certain Group Home Residents

Equalization Aid

2009-10 Equalization Aid Worksheet - Oct 15, 2009 Guarantees
2008-09 Equalization Aid Worksheet - Oct 15, 2008 Guarantees
2007-08 Equalization Aid Worksheet - Oct 15, 2007 Guarantees
2006-07 Equalization Aid Worksheet - Oct 15, 2006 Guarantees
2005-06 Equalization Aid Worksheet - Oct 15, 2005 Guarantees
2004-05 Equalization Aid Worksheet - Oct 15, 2004 Guarantees
2003-04 Equalization Aid Worksheet - Oct 15, 2003 Guarantees
2002-03 Equalization Aid Worksheet - Oct 15, 2002 Guarantees
2001-02 Equalization Aid Worksheet - Oct 15, 2001 Guarantees
2000-01 Equalization Aid Worksheet - Oct 15, 2000 Guarantees
1999-00 Equalization Aid Worksheet - Oct 15, 1999 Guarantees
1998-99 Equalization Aid Worksheet - Oct 15, 1998 Guarantees
1997-98 Equalization Aid Worksheet - Oct 15, 1997 Guarantees
1996-97 Equalization Aid Worksheet - Oct 15, 1996 Guarantees

2009-10 Percentage Method Equalization Aid Worksheet - Oct 15, 2009 Guarantees
2008-09 Percentage Method Equalization Aid Worksheet - Oct 15, 2008 Guarantees
2007-08 Percentage Method Equalization Aid Worksheet - Oct 15, 2007 Guarantees
2006-07 Percentage Method Equalization Aid Worksheet - Oct 15, 2006 Guarantees
2005-06 Percentage Method Equalization Aid Worksheet - Oct 15, 2005 Guarantees
2004-05 Percentage Method Equalization Aid Worksheet - Oct 15, 2004 Guarantees
2003-04 Percentage Method Equalization Aid Worksheet - Oct 15, 2003 Guarantees
2002-03 Percentage Method Equalization Aid Worksheet - Oct 15, 2002 Guarantees
2001-02 Percentage Method Equalization Aid Worksheet - Oct 15, 2001 Guarantees
2000-01 Percentage Method Equalization Aid Worksheet - Oct 15, 2000 Guarantees
1999-00 Percentage Method Equalization Aid Worksheet - Oct 15, 1999 Guarantees
1998-99 Percentage Method Equalization Aid Worksheet - Oct 15, 1998 Guarantees
1997-98 Percentage Method Equalization Aid Worksheet - Oct 15, 1997 Guarantees

Shared Cost

2008-09 Shared Cost Worksheet (use 2008-09 shared cost for 2009-10 aid computation)
2007-08 Shared Cost Worksheet (use 2007-08 shared cost for 2008-09 aid computation)
2006-07 Shared Cost Worksheet (use 2006-07 shared cost for 2007-08 aid computation)
2005-06 Shared Cost Worksheet (use 2005-06 shared cost for 2006-07 aid computation)
2003-04 Shared Cost Worksheet (use 2003-04 shared cost for 2004-05 aid computation)
2002-03 Shared Cost Worksheet (use 2002-03 shared cost for 2003-04 aid computation)
2001-02 Shared Cost Worksheet (use 2001-02 shared cost for 2002-03 aid computation)
2000-01 Shared Cost Worksheet (use 2000-01 shared cost for 2001-02 aid computation)
1999-00 Shared Cost Worksheet (use 1999-00 shared cost for 2000-01 aid computation)
1998-99 Shared Cost Worksheet (use 1998-99 shared cost for 1999-00 aid computation)

Membership

2008-09 Membership Worksheet (use 2008-09 membership for 2009-10 aid computation)
2007-08 Membership Worksheet (use 2007-08 membership for 2008-09 aid computation)
2006-07 Membership Worksheet (use 2006-07 membership for 2007-08 aid computation)
2005-06 Membership Worksheet (use 2005-06 membership for 2006-07 aid computation)
2002-03 Membership Worksheet (use 2002-03 membership for 2003-04 aid computation)
2001-02 Membership Worksheet (use 2001-02 membership for 2002-03 aid computation)
2000-01 Membership Worksheet (use 2000-01 membership for 2001-02 aid computation)
1999-00 Membership Worksheet (use 1999-00 membership for 2000-01 aid computation)
1998-99 Membership Worksheet (use 1998-99 membership for 1999-00 aid computation)

Calculate 75% Chapter 220 Resident (Sender) Membership

Revenue Limits

2009-10 Revenue Limit Worksheet
2008-09 Revenue Limit Worksheet
2007-08 Revenue Limit Worksheet
2006-07 Revenue Limit Worksheet
2005-06 Revenue Limit Worksheet
2004-05 Revenue Limit Worksheet
2003-04 Revenue Limit Worksheet
2002-03 Revenue Limit Worksheet
2001-02 Revenue Limit Worksheet
2000-01 Revenue Limit Worksheet
1999-00 Revenue Limit Worksheet
1998-99 Revenue Limit Worksheet
1997-98 Revenue Limit Worksheet
1996-97 Revenue Limit Worksheet

Special Adjustment Aid

2009-10 Special Adjustment Aid Worksheet
2008-09 Special Adjustment Aid Worksheet
2007-08 Special Adjustment Aid Worksheet
2006-07 Special Adjustment Aid Worksheet
2004-05 Special Adjustment Aid Worksheet
2003-04 Special Adjustment Aid Worksheet
2002-03 Special Adjustment Aid Worksheet
2001-02 Special Adjustment Aid Worksheet
2000-01 Special Adjustment Aid Worksheet
1999-00 Special Adjustment Aid Worksheet
1998-99 Special Adjustment Aid Worksheet
1997-98 Special Adjustment Aid Worksheet

Ch. 220 Integration Aid Worksheets

Inter-District Integration Aid Worksheet
Intra-District Integration Aid Worksheet

Common School Fund Aid (Library Aid)

1999-00 Common School Fund Worksheet
1998-99 Common School Fund Worksheet
1997-98 Common School Fund Worksheet

Transportation Aid

2009 Transportation Aid Worksheet
2008 Transportation Aid Worksheet
2007 Transportation Aid Worksheet
2006 Transportation Aid Worksheet

If you have questions about a specific worksheet or need additional information or clarification, please contact Department of Public Instruction, School Financial Services, P.O. Box 7841, Madison, Wisconsin 53707-7841, (608) 266-6968.

For questions about this information, contact dpifin@dpi.wi.gov (608) 267-9114

Last updated on 10/14/2009 2:42:19 PM