You are here

Revenue Limit Worksheets for Budget Planning

2019-2020 Revenue Limit Worksheets

(To make this document easier to read, it is now in a four-page layout.)

  • 2019-20 Revenue Limit Worksheet - uploaded December 7, 2018 (blank executable).  
  • 2019-20 Prepopulated Revenue Limit Worksheet - as of April 5, 2019.  
  • 2019-20 Low Revenue Ceiling Eligibility - as of December 6, 2018. This is a preliminary list which could be impacted by referenda passage or failure in Spring 2019. This calculation was done before final CCDEB aid amounts are calculated. If your district is in a CCDEB and eligible for the Low Revenue Ceiling increase, that amount may be offset partially by the CCDEB adjustment in the Revenue Limit calculation (Line 4C).

Remember that the prepopulated Excel spreadsheet is NOT live-linked to a back-end data server. Data changes made in the SAFR applications will not appear here until a revised prepopulated worksheet is uploaded. The "Data as of" indicator will show the time/date the data was last loaded.

THE CALCULATION METHODOLOGY USED IN THE 2019-20 PRE-POPULATED WORKSHEET REFLECTS CURRENT LAW. Note that this calculation may be altered as we move through the upcoming legislative session. Revisit the pre-populated worksheets to check for changes.

The 2019-20 calculation is preliminary and based upon 2018-19 data. Any changes to 2018-19 data may impact the 2019-20 calculation. The SFS Team will update with new information as available and be sure to check both the 2018-19 and 2019-20 worksheets when they are updated.

2018-2019 Revenue Limit Worksheets

(To make this document easier to read, it is now in a four-page layout.)

  • 2018-19 Revenue Limit Worksheet - uploaded September 26, 2018 (blank executable). State Aid for Exempt Personal Property added as Line 12D.  New ICS - Independent Charter Schools FTE has been incorporated into the worksheet on Line 6. 2018-19 is the first year this group of membership will have values and need to be included in the Revenue Limit calculation for the corresponding resident districts. 
  • 2018-19 Prepopulated Revenue Limit Worksheet - as of April 5, 2019.  
    • Updated items include:
      • October 15 General Aid Certification (Line 12A)
      • Wisconsin Parental Choice Program and Racine Parental Choice Program exemption amounts (Line 10H)
      • Special Needs Scholarship Program exemption amounts (Line 10I)
      • State Aid for Exempt Computers (Line 12C)
      • Prior Year Open Enrollment exemption amounts (Line 10E)
      • New Independent Charter Schools (2x) membership additions for Fall 2018 (Line 6)
      • September 2018 and Summer 2018 membership changes since October 3.  
      • Levy information is populating if the PI-401 has been submitted
  • 2018-19 Low Revenue Ceiling Impacted Districts  - as of April 24, 2018.  This calculation was done before final CCDEB aid amounts were calculated.  If your district is in a CCDEB and eligible for the Low Revenue Ceiling increase, that amount may be offset partially by the CCDEB adjustment in the Revenue Limit calculation (Line 4C). 

Remember that the prepopulated Excel spreadsheet is NOT live-linked to a back-end data server. Data changes made in the SAFR applications will not appear here until a revised prepopulated worksheet is uploaded. The "Data as of" indicator will show the time/date the data was last loaded.

THE CALCULATION METHODOLOGY USED IN THE 2018-19 PRE-POPULATED WORKSHEET REFLECTS CURRENT LAW. Note that this calculation may be altered as we move through the upcoming legislative session. Revisit the pre-populated worksheets to check for changes.

The SFS Team will update with new information as available.

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