Revenue Limit executable workbook

2012-2013 Revenue Limit Worksheets

Please note: This is the DPI School Finance Team’s interpretation of the revenue limit contained in the Act 32, the 2011-2013 Wisconsin State Budget, signed by Governor Walker on June 26, 2011. As information or interpretation changes, the SFS Team will update the worksheet as necessary.

The SFS Team has prepared a blank executable revenue limit worksheet for the 2012-13 school year for district use in budget forecasting. This worksheet includes the calculated estimate of the Per Pupil Adjustment Aid, a categorical aid for 2012-13 only. Questions about this worksheet may be directed to a school finance consultant.

Summary of Changes to 12-13 Revenue Limit Worksheet:

Allowable per pupil increase of +$50/member
Includes a Hold Harmless (Line 7A) equal to the amount the district was eligible for in 10-11 IF the district also received no equalization aid in 2010-11
Includes a calculation of the Per Pupil Adiustment Aid, a categorical aid, on line 21.
2012-13 Per Pupil Adjustment Aid Information

2012-13 Revenue Limit Worksheet - Blank executable (Current Law)

2012-13 Pre-Populated Revenue Limit Worksheet (Data as of 1/13/2012, 1:53 p.m.)

Pre-populated Worksheet includes:

Line 1, Base Revenues
Line 2, Base Membership
Line 7B, Hold Harmless
Line 8A, Prior Year Carry-Over
Line 12B, High Poverty Aid

2011-2012 Revenue Limit Worksheets

The Pre-Populated worksheet for 2011-12 has been updated as of November 11 to include the current data reported to the Department for:

District Certified Property Tax Levy Amounts
October 14 General Aid Certification Amounts
October 1 Certified Property Values provided by the State Department of Revenue
September 2011 and Summer School 2011 Membership
Reported or proposed referenda to exceed the revenue limits
Reported school board resolutions for energy efficiency exemptions to the revenue limits
Transfer of Service
Transfer of Territory
Loss of Federal Impact Aid
Adjustments for Refunded/Rescinded Taxes

2011-12 Revenue Limit Worksheet - Blank executable – (Current Law)

2011-12 Pre-Populated Revenue Limit Worksheet - 11/11/2011 – (updated as of 1/13/12, with self-reported membership changes)

Summary of Changes to 11-12 Revenue Limit Worksheet:

Reduces allowable per pupil amount by 5.5% from base
Includes a Hold Harmless (Line 7A) equal to the amount the district was eligible for in 10-11
Adds a non-recurring exemption for an adjustment for refunded or rescinded taxes
Maintains the Low Revenue Ceiling at $9,000
Creates a one-year Low Revenue Ceiling general aid program that would be provided to each district that qualifies for the Low Revenue Ceiling in an amount equal to 40% of the amount of the low revenue adjustments between $8900 and $9000 that the district utilizes
Removes exemptions for Nurse Compensation Costs, School Safety Costs, and Above-Average Transportation Costs
2011-12 Low Revenue Ceiling Aid Information

Multi-Year Revenue Limit Excel Projection Tool

The Multi-Year Revenue Limit Projection Tool is currently unavailable at this time.

This tool was developed to assist districts in ascertaining the effect of the revenue limit computation on their district, given district-chosen assumptions and future courses of action. For example, a district could create a scenario in which they observe what a recurring referendum, if passed, might do to their future resources. Or, another scenario could be created to display the effects of underlevying in any specific year. Districts are advised that this workbook assumes the current-law arithmetical computation will continue into the future, and to the extent that does not hold true, the results will not be accurate.

Please read the instruction page before using the tool. Data elements will need to be projected and entered by the district into the data entry area on the first tab. Then, users will need to enter into each succeeding individual yearly spreadsheet their actual anticipated levy amounts in Lines 14 & 15. (This configuration was selected so that users can get immediate feedback for each and every year their numbers exceed their allowable limit.)

Any changes to the input data AFTER levies have been entered will necessitate the user to review all yearly spreadsheets for subsequent overlevy/underlevy and possible revisions.

CAUTION: While every effort has been taken to ensure this workbook works correctly, DPI is not responsible for results nor the subsequent actions taken by districts. Just as the Revenue Limit is a district responsibility, users must analyze and validate any and all results of this workbook.

8/18/2010 - ERRATA - It was discovered that the carryover amount in Line 8A in the 2013-14 spreadsheet might be computing incorrectly. If you are using a spreadsheet created prior to this date, please check your 2013-14 carryover carefully.

Please call a finance consultant should you have questions.

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

Last updated on 1/23/2012 9:49:15 AM

Revenue Limit Worksheets for Budget Planning

2012-2013 Revenue Limit Worksheets

2011-2012 Revenue Limit Worksheets

Multi-Year Revenue Limit Excel Projection Tool