WASDA - GETTING IT RIGHT
The WASDA event on October 16th and 17th, 2023, will cover topics from preparing revenue limits to understanding aid certification, levy processes, and budget finalization. The DPI School Finance Team offers assistance and resources to help districts navigate financial processes effectively.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
WASDA - GETTING IT RIGHT FROM THE BUDGET TO THE LEVY AND BEYOND OCTOBER 16 and 17, 2023 School Financial Services Team, DPI
Todays Today s Goals Goals For you to be able to: 1. Accurately prepare (and be able to explain) your district s Revenue Limit 2. Understand your October 15 Aid Certification 3. Understand how the Revenue Limit information fits into your fiscal year budget 4. Compute your final Fall levy 5. Complete your Tax Levy Report (PI-401) 6. Finalize your fiscal year budget 7. Learn a few other things about school finance 2
Agenda Agenda WASDA Introduction SFS Introduction Membership Revenue Limit Consequences of Under Levying Levy Process Equalization Aid Referenda 3
Documents to reference 1. Your district s fiscal years final revenue limit worksheet can be found at Revenue Limit Worksheets 2. Your District-Specific Equalization Aid Formula Components Longitudinal spreadsheet found at Longitudinal Equalization-aid 3. Your district's Oct. 15thCertification of General Aid from DPI Equalization Aid 4. Your district's September membership count, including summer school in the DPI SFS Reporting Portal, under non-financial data 5. Your district s current year Equalized Values received October 1 from Department of Revenue 4
DPI Finance Team.How Can We Help You? The budget and most finance-related processes rely a great deal on the exchange of information between the district and the Department of Public Instruction (DPI) throughout the year. School Finance Team at DPI provides an extensive finance website, resource materials, and phone consultation to assist districts Information Data Support 5
DPI Finance Team.How We Can Help You DPI Finance Team .How We Can Help You Become familiar with our website at: School Financial Services School Financial Services Staff Contacts Don t hesitate to call or e-mail one of us for answers or guidance! See SFS Team Staff Directory We recommend you subscribe by clicking on School Finance Bulletins on the right side of our website, under Latest Information . 6
Budget/Revenue Limit Roadmap Budget/Revenue Limit Roadmap Certify Levies via PI-401 (in WiSFiP) Late Oct WISEdata & WiSFiP Summer Count, 3rd Friday Sept Count, Oct 1 Tax Values, October 15 Aid Cert. Original Budget Revenue Limit Calculation Send tax bills. PI-1508 Early Nov Budget Adjustments to BOE 7
Revenue Limits Limitation imposed by State Law in the Fall of 1993 on the revenues that public school districts in Wisconsin can raise from local Property Taxes & State General Aid. each district has their own computation not an expenditure control A district s Revenue Limit will determine approximately 80-90 % of a school district s General Fund Revenue Budget. General Fund (10), Non-Referendum Debt Service (38), Capital Projects Funds (41) 9
Comparative Revenue Under the Limits Comparative Revenue Under the Limits Statewide Data General Fund 10
Revenue Limits The Revenue Limit controls the following revenues: General Aid - Equalization Aid (for most districts), Chapter 220 Programs, and Special Adjustment Aids High Poverty Aid [12.B.] Now set to $0 Computer Aid (vouchered by the Department of Revenue in July) [12.C.] State Aid for Exempt Personal Property (vouchered by the Department of Revenue in May) [12.D.] General Fund (Fund 10), Non-Referendum Debt (Fund 38) & Capital Projects (Fund 41) Levies [14. A. B. C.] 11
Revenue Limits Revenues Outside The Revenue Limit does not control the following revenues: Per-Pupil Aid set to $742 for 2023-24 and thereafter per current law School Fees Categorical Aids (Per-Pupil Aid, Special Education, Library, Transportation, Sparsity, AGR, etc.) State and Federal Grants Gate Receipts / Donations Referendum-Approved Debt (Fund 39) & Community Service Fund (Fund 80) Levies 12
Revenue Limit Important Data Pieces Revenue Limit Important Data Pieces DISTRICT: 2023-2024 Revenue Limit Worksheet 1. 2023-24 Base Revenue (Funds 10, 38, 41) 2. Base Sept Membership Avg (2020+.4ss, 2021+.4ss, 2022+.4ss)/3 7,725,024 3. 2023-24 Base Revenue Per Member (Ln 1 / Ln2) 42,563 4. 2023-24 Per Member Change (A+B) 7,591 2023-24 Low Revenue Ceiling per s.121.905(1): 19,610 A. Allowed Per-Member Change for 23-24 570,545 B. Low Rev Incr ((Low Rev Ceiling-(3+4A))-4C) NOT<0 0 C. Value of the CCDEB (23-24 DPI Computed-CCDEB Dists only) 0 5. 2023-24 Maximum Revenue / Member (Ln 3 + Ln 4) 0 6. Current Membership Avg (2021+.4ss, 2022+.4ss, 2023+.4ss)/3 30,459 7. 2023-24 Rev Limit, No Exemptions (Ln7A + Ln 7B) 8,334,874 A. Max Rev/Memb x Cur Memb Avg (Ln 5 x Ln 6) B. Hold Harmless Non-Recurring Exemption 8. Total 2023-24 Recurring Exemptions (A+B+C+D+E) A. Prior Year Carryover B. Transfer of Service C. Transfer of Territory/Other Reorg (if negative, include sign) D. Federal Impact Aid Loss (2021-22 to 2022-23) E. Recurring Referenda to Exceed (If 2023-24 is first year) 9. 2023-24 Limit with Recurring Exemptions (Ln 7 + Ln 8) 10. Total 2023-24 Non-Recurring Exemptions (A+B+C+D+E+F+G+H+I) 786 A. Non-Recurring Referenda to Exceed 2023-24 Limit B. Declining Enrollment Exemption for 2023-24 (from left) C. Energy Efficiency Net Exemption for 2023-24 (see pg 4 for details) D. Adjustment for Refunded or Rescinded Taxes, 2023-24 E. Prior Year Open Enrollment (uncounted pupil[s]) F. Reduction for Ineligible Fund 80 Expenditures (enter as negative) G. Other Adjustments (Fund 39 Bal Transfer) H. WPCP and RPCP Private School Voucher Aid Deduction I. SNSP Private School Voucher Aid Deduction 11. 2023-24 Revenue Limit With All Exemptions (Ln 9 + Ln 10) 795 12. Total Aid to be Used in Computation (12A + 12B + 12C + 12D) A. 2023-24 OCT 15 CERT OF GENERAL AID B. State Aid to High Poverty Districts ($0 per 2023 Act 19) C. State Aid for Exempt Computers (Source 691) D. State Aid for Exempt Personal Property (Source 691) average used for Per Pupil Aid does not include "New ICS - Independent Charter Schools FTE." The PPA average appears below after data is entered for 2023: (from left) (from left) (with cents) 8,334,874 DATA AS OF 10/12/2023 Line 1 Amount May Not Exceed (Line 11 - (Line 7B+Line 10)) of Final 22-23 Revenue Limit 786 2022-23 General Aid Certification (22-23 Line 12A, src 621) 2022-23 Hi Pov Aid (22-23 Line 12B, Src 628) 2022-23 Computer Aid Received (22-23 Line 12C, Src 691) 2022-23 Aid for Exempt Personal Property (22-23 Line 12D, Src 691) 2022-23 Fnd 10 Levy Cert (22-23 Line 14A, Levy 10 Src 211) 2022-23 Fnd 38 Levy Cert (22-23 Line 14B, Levy 38 Src 211) 2022-23 Fnd 41 Levy Cert (22-23 Line 14C, Levy 41 Src 211) 2022-23 Aid Penalty for Over Levy (22-23 FINAL Rev Lim, June 2023) 2022-23 Total Levy for All Levied Non-Recurring Exemptions* NET 2023-24 Base Revenue Built from 2022-23 Data (Line 1) + + + + + + + - - = 10,604.17 395.83 Membership (Counting Students) 11,000.00 325.00 70.83 Property Values (Oct 1) 0.00 11,000.00 (from left) (rounded) 795 8,745,000 8,745,000 0 *For the Non-Recurring Exemptions Levy Amount, enter actual amount for which district levied; (7B Hold Harmless, Non- Recurring Referenda, Declining Enrollment, Energy Efficiency Exemption, Refunded/Rescinded Taxes, Prior Year Open Enrollment Pupils, Reduction for Ineligible Fund 80 Expends, Other Adjustments, Private School Voucher Aid Deduction, Private School Special Needs Voucher Aid Deduction) (rounded) 74,146 0 74,146 0 0 0 Recurring Exemptions September & Summer FTE Membership Averages Count Ch. 220 Inter-District Resident Transfer Pupils @ 75%. 8,819,146 97,786 0 Line 2: Base Avg:((20+.4ss)+(21+.4ss)+(22+.4ss)) / 3 = 2020 29 12 765 0.00 2021 34 14 766 0.00 2022 39 16 785 0.00 Summer FTE: % (40,40,40) Sept FTE: New ICS - Independent Charter Schools FTE 0 0 Other Levies 18,642 0 0 Total FTE 777 780 801 79,144 Non-Recurring Exemptions 0 8,916,932 7,965,260 Line 6: Curr Avg:((20+.4ss)+(21+.4ss)+(22+.4ss)) / 3 = 7,938,059 2021 34 14 766 0.00 2022 39 16 785 0.00 2023 35 14 791 0.00 Summer FTE: % (40,40,40) Sept FTE: New ICS - Independent Charter Schools FTE 0 The Line 6 "Current Average" shown above is used for Revenue Limits. The 7,591 19,610 DISTRICTS MUST USE THE OCT 15 AID CERT WHEN SETTING THE DISTRICT LEVY. 13. Allowable Limited Revenue: (Line 11 - Line 12) (10, 38, 41 Levies) 14. Total Limited Revenue To Be Used (A+B+C) Entries Required Below: Enter amnts needed by purpose and fund: A. Gen Operations: Fnd 10 Src 211 B. Non-Referendum Debt (inside limit) Fund 38 Src 211 C. Capital Exp, Annual Meeting Approved: Fund 41 Src 211 15. Total Revenue from Other Levies (A+B+C+D) A. Referendum Apprvd Debt (Fund 39 Debt-Src 211) B. Community Services (Fund 80 Src 211) C. Prior Year Levy Chargeback for Uncollectible Taxes (Src 212) D. Other Levy Revenue - Milwaukee & Kenosha Only 277,206,780 16. Total Fall, 2023 REPORTED All Fund Tax Levy (14A + 14B + 14C + 15) Line 16 is the total levy to be apportioned in the PI-401. District-Entered Districts are responsible for the integrity of their revenue limit data & computation. Data appearing here reflects information submitted to DPI and is unaudited. 951,672 Total FTE 780 801 805 Not >line 13 0 Chargeback Levy 795 0 (Proposed Fund 10) 0 (to Budget Rpt) 0 (to Budget Rpt) Equalization Aid (Oct 15) Line 10B: Declining Enrollment Exemption = Average FTE Loss (Line 2 - Line 6, if > 0) 0 X 1.00 = 0 0 0 0 X (Line 5, Maximum 2023-2024 Revenue per Memb) = Non-Recurring Exemption Amount: (to Budget Rpt) (to Budget Rpt) (to Budget Rpt) Fall 2023 Property Values 2023 TIF-Out Tax Apportionment Equalized Valuation 0 Levy Rate = 0.00000000 CELL COLOR KEY: Worksheet is available at: http://dpi.wi.gov/sfs/limits/worksheets/revenue Auto-Calc DPI Data Calculation Revised: 8/5/2020. Rounding in Total FTE buckets. Debt Levies High Poverty Aid 13
Revenue Limits We ll walk through a sample revenue limit calculation worksheet, explaining line-by-line and giving you some time to work on your district s numbers . .please ask questions as we go. 14
Quiz Time! Name 3 revenues at your district that the Revenue Limit formula controls Name 3 revenues at your district that the Revenue Limit formula does not control 15
Revenue Limit A 4-Step Process Step 1: Build the Base Revenue Per Member. (Worksheet lines 1-3) Step 2: Calculate a New Revenue Per Member. (prior to exemptions) (Worksheet lines 4-7) Step 3: Determine Allowable Exemptions. (Worksheet lines 8-11) 16
Revenue Limit Step 4: Determine Levy Amounts. Controlled Amounts Levies for Funds 10, 38, 41 (Worksheet lines 12-14) Non-Controlled Amounts Levies for Funds 39 & 80 and Prior-Year Chargeback (Worksheet line 15) 17
Revenue Limit Worksheet (Located in at the bottom of the left page) Green cells are formula cells and will auto calculate the amount for that cell based on the values entered in other cells. Yellow cells pull data on file with DPI and loaded on the Data tab of the worksheet. Pink cells require district entry. Note: as DPI receives additional data and loads into the spreadsheet, we will change the pink cells to yellow cells. 18
Step 1: Build the Base Revenue Line 1 DISTRICT: 2022-2023 Revenue Limit Worksheet 1. 2022-23 Base Revenue (Funds 10, 38, 41) 2. Base Sept Membership Avg (2019+.4ss, 2020+.4ss, 2021+.4ss)/3 3. 2022-23 Base Revenue Per Member (Ln 1 / Ln 2) 4. 2022-23 Per Member Change (A+B) 2022-23 Low Revenue Ceiling per s.121.905(1): A. Allowed Per-Member Change for 22-23 B. Low Rev Incr ((Low Rev Ceiling-(3+4A))-4C) NOT<0 C. Value of the CCDEB (22-23 DPI Computed-CCDEB Dists only) 5. 2022-23 Maximum Revenue / Member (Ln 3 + Ln 4) 6. Current Membership Avg (2020+.4ss, 2021+.4ss, 2022+.4ss)/3 7. 2022-23 Rev Limit, No Exemptions (Ln 7A + Ln 7B) A. Max Rev/Memb x Cur Memb Avg (Ln 5 x Ln 6) B. Hold Harmless Non-Recurring Exemption 8. Total 2022-23 Recurring Exemptions (A+B+C+D+E) A. Prior Year Carryover B. Transfer of Service C. Transfer of Territory/Other Reorg (if negative, include sign) D. Federal Impact Aid Loss (2020-21 to 2021-22) E. Recurring Referenda to Exceed (If 2022-23 is first year) 9. 2022-23 Limit with Recurring Exemptions (Ln 7 + Ln 8) 10. Total 2022-23 Non-Recurring Exemptions (A+B+C+D+E+F+G+H+I) A. Non-Recurring Referenda to Exceed 2022-23 Limit B. Declining Enrollment Exemption for 2022-23 (from left) C. Energy Efficiency Net Exemption for 2022-23 (see pg 4 for details) D. Adjustment for Refunded or Rescinded Taxes, 2022-23 E. Prior Year Open Enrollment (uncounted pupil[s]) F. Reduction for Ineligible Fund 80 Expenditures (enter as negative) G. Other Adjustments (Fund 39 Bal Transfer) H. WPCP and RPCP Private School Voucher Aid Deduction I. SNSP Private School Voucher Aid Deduction 11. 2022-23 Revenue Limit With All Exemptions (Ln 9 + Ln 10) 12. Total Aid to be Used in Computation (12A + 12B + 12C + 12D) A. 2022-23 OCT 15 CERT OF GENERAL AID B. State Aid to High Poverty Districts (not all districts) C. State Aid for Exempt Computers (Source 691) D. State Aid for Exempt Personal Property (Source 691) DISTRICTS MUST USE THE OCT 15 AID CERT WHEN SETTING THE DISTRICT LEVY. (from left) (from left) (with cents) 357,102,812 26,732 13,358.63 DATA AS OF 10/12/2023 Aid Penalty comes from page 3 RLW Line 1 Amount May Not Exceed (Line 11 - (Line 7B+Line 10)) of Final 22-23 Revenue Limit 2022-23 General Aid Certification (22-23 Line 12A, src 621) 2022-23 Hi Pov Aid (22-23 Line 12B, Src 628) 2022-23 Computer Aid Received (22-23 Line 12C, Src 691) 2022-23 Aid for Exempt Personal Property (22-23 Line 12D, Src 691) 2022-23 Fnd 10 Levy Cert (22-23 Line 14A, Levy 10 Src 211) 2022-23 Fnd 38 Levy Cert (22-23 Line 14B, Levy 38 Src 211) 2022-23 Fnd 41 Levy Cert (22-23 Line 14C, Levy 41 Src 211) 2022-23 Aid Penalty for Over Levy (22-23 FINAL Rev Lim, June 2023) 2022-23 Total Levy for All Levied Non-Recurring Exemptions* NET 2023-24 Base Revenue Built from 2022-23 Data (Line 1) + + + + + + + - - = 44,249,363 1,443,569 1,754,226 1,225,048 321,896,486 0.00 10,000.00 0.00 0.00 0.00 0 13,358.63 26,330 357,102,812 5,000,000 (from left) (rounded) 351,732,728 5,370,084 (rounded) 0 14,835,964 360,732,728 9,000,000 *For the Non-Recurring Exemptions Levy Amount, enter actual amount for which district levied; (7B Hold Harmless, Non- Recurring Referenda, Declining Enrollment, Energy Efficiency Exemption, Refunded/Rescinded Taxes, Prior Year Open Enrollment Pupils, Reduction for Ineligible Fund 80 Expends, Other Adjustments, Private School Voucher Aid Deduction, Private School Special Needs Voucher Aid Deduction) 0 0 0 0 Total levied NRE comes from page 3 RLW 9,000,000 September & Summer FTE Membership Averages 366,102,812 9,719,694 Count Ch. 220 Inter-District Resident Transfer Pupils @ 75%. 0 Line 2: Base Avg:((20+.4ss)+(21+.4ss)+(22+.4ss)) / 3 = 26,330 5,370,169 2020 208 83 26,188 299.20 2021 412 165 25,678 345.40 2022 338 135 25,547 551.00 0 Summer FTE: % (40,40,40) Sept FTE: New ICS - Independent Charter Schools FTE 203,736 431,960 0 0 3,305,795 408,034 Total FTE 26,570 26,188 26,233 375,822,506 48,672,206 Line 6: Curr Avg:((20+.4ss)+(21+.4ss)+(22+.4ss)) / 3 = 26,211 44,249,363 1,443,569 1,754,226 1,225,048 2021 412 165 25,678 345.40 2022 338 135 25,547 551.00 2023 300 120 25,582 509.00 Summer FTE: % (40,40,40) Sept FTE: New ICS - Independent Charter Schools FTE The Line 6 "Current Average" shown above is used for Revenue Limits. The average used for Per Pupil Aid does not include "New ICS - Independent Charter Schools FTE." The PPA average appears below after data is entered for 2023: 13. Allowable Limited Revenue: (Line 11 - Line 12) (10, 38, 41 Levies) 14. Total Limited Revenue To Be Used (A+B+C) Entries Required Below: Enter amnts needed by purpose and fund: A. Gen Operations: Fnd 10 Src 211 B. Non-Referendum Debt (inside limit) Fund 38 Src 211 C. Capital Exp, Annual Meeting Approved: Fund 41 Src 211 15. Total Revenue from Other Levies (A+B+C+D) A. Referendum Apprvd Debt (Fund 39 Debt-Src 211) B. Community Services (Fund 80 Src 211) C. Prior Year Levy Chargeback for Uncollectible Taxes (Src 212) D. Other Levy Revenue - Milwaukee & Kenosha Only 16. Total Fall, 2022 REPORTED All Fund Tax Levy (14A + 14B + 14C + 15) Line 16 is the total levy to be apportioned in the PI-401. Di 327,150,300 Total FTE 26,188 26,233 26,211 Not >line 13 326,896,486 25,742 321,896,486 (Proposed Fund 10) 0 (to Budget Rpt) 5,000,000 (to Budget Rpt) Line 10B: Declining Enrollment Exemption = Average FTE Loss (Line 2 - Line 6, if > 0) 1,669,028 119 119 35,639,713 X 1.00 = 19,926,000 15,470,204 243,509 14,025.45 1,669,028 X (Line 5, Maximum 2023-2024 Revenue per Memb) = Non-Recurring Exemption Amount: (to Budget Rpt) (to Budget Rpt) (to Budget Rpt) 362,536,199 0.00997017 19 0 Fall 2023 Property Values 2023 TIF-Out Tax Apportionment Equalized Valuation 39,987,660,925 Levy Rate = CELL COLOR KEY: Auto-Calc DPI Data District-Entered
Step 1: Build the Base Revenue - Line 1 DISTRICT: DATA AS OF 10/12/2023 Line 1 Amount May Not Exceed (Line 11 - (Line 7B+Line 10)) of Final 22-23 Revenue Limit 2022-23 General Aid Certification (22-23 Line 12A, src 621) 2022-23 Hi Pov Aid (22-23 Line 12B, Src 628) 2022-23 Computer Aid Received (22-23 Line 12C, Src 691) 2022-23 Aid for Exempt Personal Property (22-23 Line 12D, Src 691) 2022-23 Fnd 10 Levy Cert (22-23 Line 14A, Levy 10 Src 211) 2022-23 Fnd 38 Levy Cert (22-23 Line 14B, Levy 38 Src 211) 2022-23 Fnd 41 Levy Cert (22-23 Line 14C, Levy 41 Src 211) 2022-23 Aid Penalty for Over Levy (22-23 FINAL Rev Lim, June 2023) 2022-23 Total Levy for All Levied Non-Recurring Exemptions* NET 2023-24 Base Revenue Built from 2022-23 Data (Line 1) + + + + + + + - - = 44,249,363 1,443,569 1,754,226 1,225,048 321,896,486 0 5,000,000 0 14,835,964 360,732,728 20
MEMBERSHIP Membership directly impacts the Revenue Limit. 21
Lets Talk a Bit About Membership Your district membership is used in both of your district Revenue Limit and Equalization Aid computations. 3 Questions for Guidance Who can you count for membership? Who is a resident and enrolled? Who is incurring the cost for the education? 22
Membership Reporting Portals SAFR Membership Report 23
Pupil FTE data (used in the Revenue Limit!) FY 2023-24 FTE Conversion for Revenue Limit Calculation includes Challenge Academy students and Independent Charter Schools (ICS) New Authorizers FTE 24
Pupil FTE Conversion (used in the Revenue Limit!) FTE Conversion for Revenue Limit Calculation includes Challenge Academy students and Independent Charter Schools (ICS) New Authorizers FTE 25
Pupil Count - Words to Know Full time Full time Pre Pre- -School School- -Special Education Special Education Challenge Academy Challenge Academy Summer ADM Equivalent Summer ADM Equivalent Minutes Minutes Withdrawal Withdrawal Age Requirements Age Requirements Part Part- -time time Pupil Pupil Resident Resident Receiving Instruction Receiving Instruction Head Count Head Count 4 4- -year year- -old Kindergarten old Kindergarten Membership Membership Enrollment Enrollment Open OpenEnrollment Enrollment Thayer Thayer Student Student 3 3- -year year Programs Programs Hours of Instruction Hours of Instruction Revenue Limit Membership Revenue Limit Membership Attendance Attendance Count Date Count Date Present Present Non Non- -Resident Resident 5 5- -year year- -old Kindergarten old Kindergarten Full Time Equivalency (FTE) Full Time Equivalency (FTE) Special Education Special Education State Schools State Schools General Aid Membership General Aid Membership 26 26
Which terms are you most familiar with, least familiar with? Turn and talk with your colleagues at your table 27 This Photo by Unknown Author is licensed under CC BY-NC-ND
Pupil Count Resources Pupil Count Resources School Financial Services Web pages for everything concerning membership. Pupil Count - PI-1563 General Count Instructions for the PI-1563 Workbook PI-1563 Pupil Count Workbook Form for Draft Use Membership Information and Reporting Excel worksheet for converting the count to FTE can be found under additional resources 28
Back to the Revenue Limit Formula Step 1: Build the Base Revenue - Line 2 September & Summer FTE Membership Averages Count Ch. 220 Inter-District Resident Transfer Pupils @ 75%. Line 2: Base Avg:((20+.4ss)+(21+.4ss)+(22+.4ss)) / 3 = 26,330 2020 208 83 26,188 299.20 2021 412 165 25,678 345.40 2022 338 135 25,547 551.00 Summer FTE: % (40,40,40) Sept FTE: New ICS - Independent Charter Schools FTE Total FTE 26,570 26,188 26,233 29
Revenue Limit Formula Step 1: Build the Base Revenue Line 6 Line 6: Curr Avg:((21+.4ss)+(22+.4ss)+(23+.4ss)) / 3 = 26,211 2021 412 165 25,678 345.40 2022 338 135 25,547 551.00 2023 300 120 25,582 509.00 Summer FTE: % (40,40,40) Sept FTE: New ICS - Independent Charter Schools FTE The Line 6 "Current Average" shown above is used for Revenue Limits. The average used for Per Pupil Aid does not include "New ICS - Independent Charter Schools FTE." The PPA average appears below after data is entered for 2023: Total FTE 26,188 26,233 26,211 25,742 Add the 3 previous years FTEs and divide by 3. 30
Step 1: Build the Base Revenue Per Member 2023-2024 Revenue Limit Worksheet 1. 2023-24 Base Revenue (Funds 10, 38, 41) 2. Base Sept Membership Avg (2020+.4ss, 2021+.4ss, 2022+.4ss)/3 3. 2023-24 Base Revenue Per Member (Ln 1 / Ln2) 4. 2023-24 Per Member Change (A+B) (from left) (from left) (with cents) 360,732,728 26,330 13,700.45 325.00 Base Revenue Per Member (second page of worksheet) 31
Step 2: Calculate a New Revenue per Member Line 4A Line 4A: Each year, under current law, each district s per member revenue limit may change. Historically was an inflationary increase. For 2023-24 and onward it will be $325. If your base revenue per member is less than $11,000, you will not see the full $325 reflected in line 5. 32
Step 2: Calculate a New Revenue Per Member Lines 4B & 4C Under 2019 Wisconsin Act 19, most districts had a low revenue ceiling of $10,000 per member. Per 2023 Act 11, most districts are now up to $11,000 per member for their low revenue ceiling. Per s. 121.905(1), the Low Revenue Ceiling to be used in a district's "low revenue" computation (provided here for reference) can vary from district to district depending on the results of referenda. Please consult this statute and the district's specific referenda results to explain the number seen here. 33
Step 2: Calculate New Revenue Per Member Step 2: Calculate New Revenue Per Member Line 5 is the sum of Lines 3 and 4 (auto-calculates). 3. 2023-24 Base Revenue Per Member (Ln 1 / Ln2) 4. 2023-24 Per Member Change (A+B) (with cents) 13,700.45 325.00 2023-24 Low Revenue Ceiling per s.121.905(1): 11,000.00 325.00 A. Allowed Per-Member Change for 23-24 B. Low Rev Incr ((Low Rev Ceiling-(3+4A))-4C) NOT<0 C. Value of the CCDEB (23-24 DPI Computed-CCDEB Dists only) 5. 2023-24 Maximum Revenue / Member (Ln 3 + Ln 4) 0.00 0.00 * * 14,025.45 * *If your district received an additional increase to reach the $11,000 low revenue ceiling. 34
Step 2: Calculate New Revenue Per Member Step 2: Calculate New Revenue Per Member DISTRICT: DATA AS OF 10/12/2023 Line 1 Amount May Not Exceed (Line 11 - (Line 7B+Line 10)) of Final 22-23 Revenue Limit Line 6: Curr Avg:((20+.4ss)+(21+.4ss)+(22+.4ss)) / 3 = 2021 Summer FTE: 412 % (40,40,40) 165 Sept FTE: 25,678 345.40 New ICS - Independent Charter Schools FTE 26,211 2022-23 General Aid Certification (22-23 Line 12A, src 621) 2022-23 Hi Pov Aid (22-23 Line 12B, Src 628) 2022-23 Computer Aid Received (22-23 Line 12C, Src 691) 2022-23 Aid for Exempt Personal Property (22-23 Line 12D, Src 691) 2022-23 Fnd 10 Levy Cert (22-23 Line 14A, Levy 10 Src 211) 2022-23 Fnd 38 Levy Cert (22-23 Line 14B, Levy 38 Src 211) 2022-23 Fnd 41 Levy Cert (22-23 Line 14C, Levy 41 Src 211) 2022-23 Aid Penalty for Over Levy (22-23 FINAL Rev Lim, June 2023) 2022-23 Total Levy for All Levied Non-Recurring Exemptions* NET 2023-24 Base Revenue Built from 2022-23 Data (Line 1) + + + + + + + - - = 44,249,363 1,443,569 1,754,226 1,225,048 321,896,486 2022 338 135 25,547 551.00 2023 300 120 25,582 509.00 The Line 6 "Current Average" shown above is used for Revenue Limits. The average used for Per Pupil Aid does not include "New ICS - Independent Charter Schools FTE." The PPA average appears below after data is entered for 2023: 0 5,000,000 Total FTE 26,188 26,233 26,211 0 14,835,964 360,732,728 25,742 Pay attention to date stamp in red. Always use the newest sheet! Worksheet will be updated daily through early November. Enrollment Pupils, Reduction for Ineligible Fund 80 Expends, Other Adjustments, Private School Voucher Aid Deduction, Private School Special Needs Voucher Aid Deduction) *For the Non-Recurring Exemptions Levy Amount, enter actual amount for which district levied; (7B Hold Harmless, Non- Recurring Referenda, Declining Enrollment, Energy Efficiency Exemption, Refunded/Rescinded Taxes, Prior Year Open September & Summer FTE Membership Averages 35 Count Ch. 220 Inter-District Resident Transfer Pupils @ 75%. Line 2: Base Avg:((20+.4ss)+(21+.4ss)+(22+.4ss)) / 3 = 26,330 2020 208 83 26,188 299.20 2021 412 165 25,678 345.40 2022 338 135 25,547 551.00 Summer FTE: % (40,40,40) Sept FTE: New ICS - Independent Charter Schools FTE Total FTE 26,570 26,188 26,233 Line 6: Curr Avg:((20+.4ss)+(21+.4ss)+(22+.4ss)) / 3 = 26,211 2021 412 165 25,678 345.40 2022 338 135 25,547 551.00 2023 300 120 25,582 509.00 Summer FTE: % (40,40,40) Sept FTE: New ICS - Independent Charter Schools FTE The Line 6 "Current Average" shown above is used for Revenue Limits. The average used for Per Pupil Aid does not include "New ICS - Independent Charter Schools FTE." The PPA average appears below after data is entered for 2023: Total FTE 26,188 26,233 26,211 25,742 Line 10B: Declining Enrollment Exemption = Average FTE Loss (Line 2 - Line 6, if > 0) 1,669,028 119 119 X 1.00 = 14,025.45 1,669,028 X (Line 5, Maximum 2023-2024 Revenue per Memb) = Non-Recurring Exemption Amount: Fall 2023 Property Values 2023 TIF-Out Tax Apportionment Equalized Valuation 39,987,660,925 CELL COLOR KEY: Auto-Calc DPI Data District-Entered
New ICS New ICS - - Independent Charter Schools FTE Independent Charter Schools FTE Residents of your school district that are attending an Independent Charter School (ICS) authorized by new authorizers (i.e., UW System or certain tribal colleges). On Lines 2 and 6 under New ICS DPI will enter your resident students. To the right is the comment for this location. In June, the school district aid will receive an aid deduction to pay for the new ICS. 36
Step 2: Calculate New Revenue Per Member Step 2: Calculate New Revenue Per Member 2023-2024 Revenue Limit Worksheet 1. 2023-24 Base Revenue (Funds 10, 38, 41) 2. Base Sept Membership Avg (2020+.4ss, 2021+.4ss, 2022+.4ss)/3 3. 2023-24 Base Revenue Per Member (Ln 1 / Ln2) 4. 2023-24 Per Member Change (A+B) 2023-24 Low Revenue Ceiling per s.121.905(1): A. Allowed Per-Member Change for 23-24 B. Low Rev Incr ((Low Rev Ceiling-(3+4A))-4C) NOT<0 C. Value of the CCDEB (23-24 DPI Computed-CCDEB Dists only) 5. 2023-24 Maximum Revenue / Member (Ln 3 + Ln 4) 6. Current Membership Avg (2021+.4ss, 2022+.4ss, 2023+.4ss)/3 7. 2023-24 Rev Limit, No Exemptions (Ln7A + Ln 7B) A. Max Rev/Memb x Cur Memb Avg (Ln 5 x Ln 6) B. Hold Harmless Non-Recurring Exemption (from left) (from left) (with cents) 360,732,728 26,330 13,700.45 325.00 11,000.00 325.00 0.00 0.00 14,025.45 26,211 367,620,950 (from left) (rounded) 367,620,950 0 Additional Low Revenue authority automatically increases the district's per member revenue limit amount. Eligible districts need not do anything special to receive this increase - if the district is eligible an amount will be populated in the cell by DPI 37
Step 3: Determine Allowable Exemptions Step 3: Determine Allowable Exemptions Exemptions to the Revenue Limit allow districts to levy additional amounts above the amount generated by the computation up to this point. Line 8 tracks Recurring Exemptions. Line 10 tracks Non-Recurring Exemptions. It s important to understand the distinction between the two. 38
Step 3: Determine Recurring Exemptions Step 3: Determine Recurring Exemptions Recurring Exemptions (Lines 8A-E) are base-building; if the district taxes for any of this additional authority, the levy amount is automatically included in the succeeding year s base. 8. Total 2023-24 Recurring Exemptions (A+B+C+D+E) A. Prior Year Carryover B. Transfer of Service C. Transfer of Territory/Other Reorg (if negative, include sign) D. Federal Impact Aid Loss (2021-22 to 2022-23) E. Recurring Referenda to Exceed (If 2023-24 is first year) 9. 2023-24 Limit with Recurring Exemptions (Ln 7 + Ln 8) (rounded) 10,236,728 0 236,728 0 0 10,000,000 377,857,678 39
Step 3: Determine Recurring Exemptions Step 3: Determine Recurring Exemptions Line 8A Prior Year Carryover unused levy authority from prior year allowed to be used in current year. (DPI provides) Line 8B Transfer of Service - a school district which assumes responsibility for a program or service from another governmental unit may request and be granted an exemption to the district revenue limit equal to the increased cost due to that program or service. (special education or ESL services) Line 8E Recurring Referenda to Exceed referenda amount (normally, if 2023-24 is the first year). Call DPI if you have questions. 40
Step 3: Determine Non Step 3: Determine Non- -Recurring Exemptions Recurring Exemptions Non-Recurring Exemptions (Lines 10A-I) are not base-building; if a district taxes for any of these exemptions, the amount is not included in the succeeding year s base. 10. Total 2023-24 Non-Recurring Exemptions (A+B+C+D+E+F+G+H+I) A. Non-Recurring Referenda to Exceed 2023-24 Limit B. Declining Enrollment Exemption for 2023-24 (from left) C. Energy Efficiency Net Exemption for 2023-24 (see pg 4 for details) D. Adjustment for Refunded or Rescinded Taxes, 2023-24 E. Prior Year Open Enrollment (uncounted pupil[s]) F. Reduction for Ineligible Fund 80 Expenditures (enter as negative) G. Other Adjustments (Fund 39 Bal Transfer) H. WPCP and RPCP Private School Voucher Aid Deduction I. SNSP Private School Voucher Aid Deduction 11. 2023-24 Revenue Limit With All Exemptions (Ln 9 + Ln 10) 7,247,654 0 1,669,028 0 11,884 380,927 0 0 4,643,161 542,654 385,105,332 41
Know the Difference ! Know the Difference ! Recurring Exemptions Rolling forward in Your Base This Year Recurring Next Year Line 8 Base Non-Recurring Exemptions One Year Only This Year Next Year Non-Recurring Line 10 Base Base 42
Non Non- -Recurring Exemptions Recurring Exemptions The exemption is only valid for a limited period of time usually one Revenue Limit cycle. Prior Year Revenue Limit Current Year Revenue Limit Hold Harmless (Line 7B) Declining Enrollment Energy Efficiency Adjustment for new Choice Students Aid + Levy Base Will Include Only Levied Recurring Authority from the Prior Year Base 43
Step 3: Determine Non-Recurring Exemptions Line 10A Non-Recurring Referenda district has a successful referendum. Line 10B Declining Enrollment Line Line 10B: Declining Enrollment Exemption = Average FTE Loss (Line 2 - Line 6, if > 0) 1,669,028 119 119 X 1.00 = Page 1 14,025.45 1,669,028 X (Line 5, Maximum 2023-2024 Revenue per Memb) = Non-Recurring Exemption Amount: 7,247,654 Page 2 10. Total 2023-24 Non-Recurring Exemptions (A+B+C+D+E+F+G+H+I) A. Non-Recurring Referenda to Exceed 2023-24 Limit B. Declining Enrollment Exemption for 2023-24 (from left) C. Energy Efficiency Net Exemption for 2023-24 (see pg 4 for details) D. Adjustment for Refunded or Rescinded Taxes, 2023-24 E. Prior Year Open Enrollment (uncounted pupil[s]) F. Reduction for Ineligible Fund 80 Expenditures (enter as negative) G. Other Adjustments (Fund 39 Bal Transfer) H. WPCP and RPCP Private School Voucher Aid Deduction I. SNSP Private School Voucher Aid Deduction 11. 2023-24 Revenue Limit With All Exemptions (Ln 9 + Ln 10) 0 1,669,028 0 11,884 380,927 44 0 0 4,643,161 542,654 385,105,332
Step 3: Line 10C Line 10C Energy Efficiency exemption to fund a project to implement energy efficiency measures or to purchase energy efficiency products. See DPI Rule and information at: Exemptions Districts are no longer able to pass/amend resolutions after December 31, 2017. Multi-year reconciliation is located on page 4 of the worksheet. 45
Step 3: Line 10C 2023-24 ENERGY EFFICIENCY EXEMPTION NET TOTAL - LINE 10C. (Carry bright yellow box amount to Line 10C. on page 1. See detail computation boxes below.) ENTER ALL NUMBERS AS POSITIVE EXCEPT WHERE INDICATED. FORMULAS WILL AUTO-CALC. 1.) 2021-22 Adjustment for Unspent Energy Exemption (see box below) 2.) 2022-23 Adjustment for Unspent Energy Exemption (see box below) 3.) 2023-24 EE Expenses for Non-Debt (1-Year Project) per Board Resolution 4.) 2023-24 EE Expenses for Debt per Board Resolution 5.) Measured Utility Savings Applied in 2023-24 (entered as a negative) 0 0 0 0 0 $0 6. Total 2023-24 Energy Efficiency Exemption (carry to Line 10 C. on page 2) (Amount can be < 0.) The 2023-24 Net EE exemption will include adjustments for unspent Fall 2021 Levy (DEBT) and Fall 2022 Levy (NON- DEBT) BOE resolutions. Actual expenditures will be reported to DPI by your auditor in September 2023 via the PI-1506- AC. Until then, districts are to enter their estimates of expenditures made related to the respective EE BOE resolutions. If, after you enter your anticipated expenditures, negative numbers appear in Line 1 (cells X40 and X49) in either or both the 2020-21 or 2021-22 tables below, this indicates the estimated expenditures entered are less than the amount of the exemption that year. Call a finance consultant if you have questions. 2021-22 Energy Efficiency Reconciliation - Debt 0 1.) 2021-22 Adjustment for Unspent Energy Exemption (-A+B+C, can be < 0) A. 2021-22 EE Debt Amount Levied (per 21-22 PI-1506-AC, entered as a negative) B. Jan-Jun 2022 Debt Service Payment (per 21-22 PI-1506AC) C. Jul-Dec 2022 Debt Service Payment (per 22-23 PI-1506AC, Aug 2023) (If Line 1 in this box is < 0, see 2021-22 Adjustment in "2023-24 Net Energy Efficiency Exemption" box above.) -967,958 10,000 957,958 2022-23 Energy Efficiency Reconciliation - Non-Debt 1.) 2022-23 Adjustment for Unspent Energy Exemption (-A+B, can be < 0) A. 2022-23 EE Non-Debt Amount Levied (per 22-23 PI-1506-AC, entered as a negative) B. 2022-23 Actual EE Expenses (per 22-23 PI-1506AC, Aug 2023) (If Line 1 in this box is < 0, see 2022-23 Adjustment in "2023-24 Net Energy Efficiency Exemption" box above.) 0 0 0 46
Step 3: Determine Recurring Exemptions Line 10D Adjustment for Rescinded Taxes exemption to recover the funds refunded to a taxpayer whose property value had subsequently been reduced by a court action and/or a reviewing authority (Letter from DOR is the basis for amount). DOR provides amounts. Line 10E - Prior Year Open Enrollment (uncounted pupils) exemption to compensate for not counting Open Enrollment pupils from the prior year. Line 10F Reduction for Ineligible Fund 80 Expenditures Fund 80 Community Service Overview 10H WPCP and RPCP Private School Voucher Aid Deduction allows a district to levy for the aid deduction related to these private school programs. 10I SNSP Private School Voucher Aid Deduction allows a district to levy for the aid deduction related to this special needs scholarship program for private schools. Remember, any unused Non-Recurring authority is not eligible for carryover in the next year districts have one, and only one, opportunity to use Non-Recurring exemptions 47
Line 10D vs Line 15C Line 10D: Adjustment for Refunded or Rescinded Taxes Property taxpayer contests assessment and value of property is reduced Districts allowed to increase RL by the amount refunded as a result of a valuation re-determination under s. 74.41 DOR computes amounts each fall and sends letters in mid-November; DPI pre-populates this field based on certified amounts provided by DOR Statutes do not permit RL exemption for any other kind of chargeback Line 15C: Prior Year Levy Chargeback for Uncollectible Taxes Municipality unable to collect full amount from property taxpayer after full levied amount provided to district Municipality asks the district to return the uncollectible amount under s. 74.42 District recovers the amount returned to municipality through an outside of the RL chargeback levy instead of an adjustment 48
Step 3: Line 10H Step 3: Line 10H 10H Adjustment for private school voucher students allows a district to levy for the aid deduction related to these programs. Amount unknown until October 15. H. WPCP and RPCP Private School Voucher Aid Deduction I. SNSP Private School Voucher Aid Deduction 4,643,161 542,654 49
Step 3: Line 10I Line 10.I., SNSP Private School Voucher Aid Deduction Per Act 36 (2017), s. 115.7915, districts are allowed to increase their revenue limit through a non-recurring exemption for Special Needs Scholarship Program pupils. Districts do not learn this amount until October 15. Choice, SNSP, and New ICS fiscal impacts. H. WPCP and RPCP Private School Voucher Aid Deduction I. SNSP Private School Voucher Aid Deduction 4,643,161 542,654 50
