School Revenue Limits and State Aid Systems

Revenue Limit, State General Aid, and Tax Levy Ben Kopitzke, Finance Consultant Jennifer Buros, Assistant Director School Financial Services WASBO New School Administrator & Support Staff Conference September 4, 2024

Agenda Basic Formula Revenue Limits Property Tax Levy State Aids Questions 2/32

Revenue Limits, School Aids, and Property Tax Levies Revenue Limit Property TaxLevy State Aid (General + Computer + Exempt Personal Property) 3/32

Revenue Limit History and Overview Revenue limits: Implemented in 1993-94. Designed to restrict the amount of revenue a school district can raise through local property taxes and state general school aids annually on a per pupil basis. Do not include state categorical aids, federal aids, local receipts, and most debt service tax levies. Set to annually increase by $325 per member for foreseeable future. Calculated based upon a school district s three-year rolling membership average. Not dependent on changes in other districts. Allow for multiple adjustments for certain purposes. Can be exceeded if approved through local referendum. 4/32

State Totals - School District Revenues CONTROLLED Although the mix of aid and taxes is different across districts, the Revenue Limit can control 70-90% of the General Fund budget! Other Sources* 22% State General Aids^ 37% Local Property Taxes 41% ^ State General Aids includes: equalization aid, special adjustment aid, inter-district & intra-district aids (i.e., state aids received under the districts revenue limit caps). * Other Sources include: state categorical aids, federal aid, and non-property tax local revenue (i.e., revenue received outside of the districts revenue limit caps). 5/32

What is within Revenue Limits? Regulates Revenues for Funds 10, 38 and 41 General Fund (10) Property Tax Levy General State Aid Computer Aid Non-Referendum Debt Service Fund (38) Property Tax Levy Capital Projects Fund (41) Property Tax Levy 6/32

What is outside the Revenue Limit? Categorical Aids (Special Education, Per Pupil Aid, Library, Transportation, SAGE/AGR, Sparsity, etc.) State and Federal Grants Student Fees, Gate Receipts, and Donations Tax Levy for Referendum Approved Debt Service Fund (39) Tax Levy for Community Service Fund (80) 7/32

RL: Per Pupil Adjustment History $275 $300 $257 $241 $325 $230 $220 $209 $206 $200 $194 $179 $175 $200 $75 $100 $50 $0 $0 $- $(100) $(200) $(300) * Under the 2011-13 budget act, the per pupil adjustment in 2011-12 was set at a 5.5% reduction, The statewide average reduction was $554 per pupil. $(400) $(500) $(554) $(600) 8/32

Revenue Limits Membership September Pupil Count FTE + 40% Summer School FTE (3YRA) Four-Step Process Step 1: Build the Base Revenue Per Member (Worksheet lines 1-3) Step 2: Calculate New Revenue Per Member (Worksheet lines 4-7) Step 3: Determine Allowable Exemptions (Worksheet lines 8-11) Step 4: Determine Levy (Worksheet lines 13-16) The revenue limit does not include all revenues and it is not a spending limit. 9/32

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 98,423,124 3. 2023-24 Base Revenue Per Member (Ln 1 / Ln 2) 0 4. 2023-24 Per Member Change (A+B) 663,541 464,288 A. Allowed Per-Member Change for 23-24 54,283,224 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) 2,460,000 5. 2023-24 Maximum Revenue / Member (Ln 3 + Ln 4) 0 6. Current Membership Avg (2021+.4ss, 2022+.4ss, 2023+.4ss)/3 11,423,267 7. 2023-24 Rev Limit, No Exemptions (Ln 7A + Ln 7B) 144,870,910 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) 14,105 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) 14,063 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) 144,870,910 14,105 10,270.89 729.11 FINAL DATA AS OF 6/25/24 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) + + + + + + + - - = 2023-24 Low Revenue Ceiling per s.121.905(1): 11,000.00 325.00 404.11 0.00 11,000.00 14,063 154,693,000 (from left) (rounded) 154,693,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) 5,686,106 0 686,106 0 0 5,000,000 September & Summer FTE Membership Averages Count Ch. 220 Inter-District Resident Transfer Pupils @ 75%. 160,379,106 8,053,171 0 Line 2: Base Avg:((20+.4ss)+(21+.4ss)+(22+.4ss)) / 3 = 462,000 2020 101 40 14,150 0.00 2021 336 134 13,962 0.00 2022 330 132 13,898 0.00 Summer FTE: % (40,40,40) Sept FTE: New ICS - Independent Charter Schools FTE 0 8,742 121,322 0 0 Total FTE 14,190 14,096 14,030 6,564,100 897,007 168,432,277 105,685,877 Line 6: Curr Avg:((21+.4ss)+(22+.4ss)+(23+.4ss)) / 3 = 104,558,048 2021 336 134 13,962 0.00 2022 330 132 13,898 0.00 2023 324 130 13,932 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 663,541 464,288 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 42 15. Total Revenue from Other Levies (A+B+C+D) 11,000.00 A. Referendum Approved Debt (Fund 39 Debt-Src 211) 462,000 B. Community Services (Fund 80 Src 211) C. Prior Year Levy Chargeback for Uncollectible Taxes (Src 212) D. Other Levy Revenue - Milwaukee & Kenosha Only 11,972,391,961 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. 62,746,400 Total FTE 14,096 14,030 14,062 Not >line 13 62,746,400 14,063 60,286,400 (Proposed Fund 10) 0 (to Budget Rpt) 2,460,000 (to Budget Rpt) Line 10B: Declining Enrollment Exemption = Average FTE Loss (Line 2 - Line 6, if > 0) 462,000 42 15,438,009 X 1.00 = 12,768,252 2,655,278 14,479 X (Line 5, Maximum 2023-2024 Revenue per Memb) = Non-Recurring Exemption Amount: (to Budget Rpt) (to Budget Rpt) (to Budget Rpt) 78,184,409 0.00653039 0 Fall 2023 Property Values 2023 TIF-Out Tax Apportionment Equalized Valuation Levy Rate = CELL COLOR KEY: Worksheet is available at: http://dpi.wi.gov/sfs/limits/worksheets/revenue Auto-Calc DPI Data 10/3 Calculation Revised: 8/5/2020. Rounding in Total FTE buckets.

Revenue Limits & Budget-Building Watch Change Across Time Line 11 Year 3 Year 1 Year 2 Total Revenue Limit with Exemptions Total Revenue Limit with Exemptions Total Revenue Limit with Exemptions Line 11 represents the total amount of resource your district will get from property tax, state general aids, and exempt computer aid. This will equal about 85-95% of general fund revenues. For budgeting purposes, it s very important to compare Line 11 with the previous year s Line 11. Major decreases in Line 11 from year to year can have serious implications for your budget. Watch for exemptions. 11/3

Know the Difference Line 10 Line 8 Non-Recurring Exemptions One Year Only Recurring Exemptions Permanently in Your Base This Year Next Year This Year Next Year Recurring Non-Recurring Base Base Base Base 12/3

Revenue Limit Takeaways The Revenue Limit controls revenue from general state aid (including high poverty aid) and most of your local property tax revenues. Revenue Limits are calculated by multiplying the three-year rolling membership average times a per member dollar amount and adding on any exemptions. Most districts are not restrained by their initial calculation but are eligible for various exemptions to increase their Revenue Limit. Exemptions result in additional taxation authority. Know the difference between recurring and non-recurring exemptions, especially when planning a referendum. Calculating the property tax levy is a direct result of completing the Revenue Limit calculation. 13/3

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 / Ln 2) 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 (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 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) 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) 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) DISTRICTS MUST USE THE OCT 15 AID CERT WHEN SETTING THE DISTRICT LEVY. (from left) (from left) (with cents) 144,870,910 14,105 10,270.89 729.11 Setting the Levy 11,000.00 325.00 404.11 0.00 11,000.00 14,063 154,693,000 (from left) (rounded) 154,693,000 0 (rounded) 5,686,106 0 686,106 0 0 5,000,000 160,379,106 8,053,171 0 Page 2 of the Revenue Limit Worksheet 462,000 0 8,742 121,322 0 0 6,564,100 897,007 168,432,277 105,685,877 104,558,048 0 663,541 464,288 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 Approved 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, 2023 REPORTED All Fund Tax Levy (14A + 14B + 14C + 15) Line 16 is the total levy to be apportioned in the PI-401. 62,746,400 Not >line 13 62,746,400 60,286,400 (Proposed Fund 10) 0 (to Budget Rpt) 2,460,000 (to Budget Rpt) 15,438,009 12,768,252 2,655,278 14,479 (to Budget Rpt) (to Budget Rpt) (to Budget Rpt) 78,184,409 0.00653039 0 Levy Rate = Districts are responsible for the integrity of their revenue limit data & computation. Data appearing here reflects information submitted to DPI and is unaudited. 14/3

The Basic Formula Line 11 Total Revenue Limit (minus) Line 12 State General Aid (equals) Line 13 Allowable Limited Tax Levy 11. 2023-24 Revenue Limit With All Exemptions (Ln 9 + Ln 10) 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) DISTRICTS MUST USE THE OCT 15 AID CERT WHEN SETTING THE DISTRICT LEVY. 168,432,277 105,685,877 104,558,048 0 663,541 464,288 13. Allowable Limited Revenue: (Line 11 - Line 12) (10, 38, 41 Levies) 62,746,400 15/3

State Aid for Exempt Computers and Personal Property Line 12C and Line 12D State aid from the Department of Revenue. Replaces the tax revenue the District would have received if this property was still included on the taxable rolls. Calculation was changed as part of the 2017-19 Biennial Budget. Available around October 15th and paid directly by DOR 16/3

Avoid the Over-Levy Line 14 CANNOT exceed Line 13. If it does, the worksheet will let you know. 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 62,746,400 EXCEEDS LIMIT !! Not >line 13 63,286,400 60,286,400 (Proposed Fund 10) 0 (to Budget Rpt) 3,000,000 (to Budget Rpt) 17/3

Revenue Limits POP QUIZ ! What funds are regulated by the revenue limit? Funds 10, 38, and 41 Funds 39, 80, and the prior year levy chargeback for uncollectible taxes are outside the revenue limit. 18/3

Revenue Limits How can I predict future limits? SFS Home Revenue Limits Overview 2024-25 Pre-Populated Revenue Limit Worksheet Historical Revenue Limit Worksheets Longitudinal Revenue Limit Worksheet 19/3

State General Aids The fundamental purpose of the Equalization Aid formula is to level the playing field by providing assistance (distributing aid) to poorer districts (those with lower property value) to make up for what they can t get from their property tax base. 20/3

Basic Equalization Aid Concepts Aid is inversely related to district property value per member. One pot of money is split over 421 school districts based on district values, membership, and shared costs. Changes in individual district data affect every other district s aid. Depending on district value-per-member, some districts aid is increased by increasing expenses, while others aid is decreased by increasing expenses. Know where your district is in the formula and be aware of what is happening to your district over time. Three runs per year: July 1, October 15, and Final 21/3

Equalization Aid Factors What affects the amount of a district s Equalization Aid? District Factors (Prior Year Audited) Shared cost Membership (Average of 3rd Friday in Sept + 2nd Friday in January FTE, plus 100% of Summer FTE, plus other adjustments) Equalized property value State Factors Cost ceilings Guaranteed valuations per member Amount of funding the State puts into the formula 22/3

Property Value vs Shared Cost For every additional dollar spent Low Property Value High Property Value Highly aided Positively aided Low Spending High Spending Positively aided Negatively aided 23/3

Ceilings and Guarantees Tertiary Guarantee State Average Value Per Member Tertiary Aid Negative Tertiary Aid Secondary Ceiling 90% of PY costs Negative Secondary Aid Secondary Aid Secondary Guarantee Based on $$ in appropriation Primary Ceiling Set in statute Primary Aid No Equalization Aid Primary Guarantee In statute 24/3

WISCONSIN DEPARTMENT OF PUBLIC INSTRUCTION JULY 1 ESTIMATE OF 2024-25 GENERAL AID GUARANTEES FOR JULY 1 ESTIMATE K-12 UHS K-8 PRIMARY (G1) 1,930,000 5,790,000 2,895,000 SECONDARY (G6) 2,218,770 6,656,310 3,328,155 USING 2023-24 BUDGET REPORT DATA, 2023-24 AUDITED MEMBERSHIP TERTIARY (G11) 977,295 2,931,885 2024-25 JULY 1 ESTIMATE E4 = 1,465,942 2023 TIFOUT SCHOOL AID VALUE (CERT MAY 2024) & 2016 COMPUTER VALUE (CERT MAY 2017) Madison Metropolitan 3269 PART A: 2023-24 AUDITED MEMBERSHIP A1 3RD FRI SEPT 2023 MEMBERSHIP* (include Challenge Academy) A2 2ND FRI JAN 2024 MEMBERSHIP* (include Challenge Academy) A3 TOTAL (A1 + A2) A4 AVERAGE (A3/2) (ROUNDED) A5 SUMMER 2023 FTE EQUIVALENT* (ROUNDED) A6A FOSTER GROUP + PARTTIME RESIDENT FTE EQUIVALENT (AVE SEPT+JAN) A6B PARTTIME NON-RESIDENT FTE EQUIVALENT (AVE SEPT+JAN) A6C STATEWIDE CHOICE & RACINE PUPILS STARTING IN FALL 15 & AFTER A6D STATEWIDE SPECIAL NEEDS SCHOLARSHIP PROGRAM PUPILS A6E INDEPENDENT CHARTER SCHOOLS (ICS) NEW AUTHORIZERS STUDENTS A7 AID MEMBERSHIP (A4+A5+A6A+A6B+A6C+A6D+A6E) (ROUNDED) * Ch 220 Resident Inter FTE counts only 75%. PART B: 2023-24 GENERAL FUND DEDUCTIBLE RECEIPTS (BUDGET REPORT) B1 TOTAL REVENUE & TRNSF IN B2 PROP TAX + EXEMPT AIDS FROM DOR B3 GENERAL STATE AID B4 IMPACT AID DISTS: NON-DED IMPACT AID B5 REORG SETTLEMENT B6 LONG TERM OP BORR, NOTE B7 LONG TERM OP BORR, STF B8 PROPERTY TAX/EQUAL AID REFUND B9 DEDUCTIBLE RECEIPTS FTE PART E: 2023-24 SHARED COST - CONTINUED E6 PRIMARY COST CEILING PER MEMBER E7 PRIMARY CEILING (A7 * E6) E8 PRIMARY SHARED COST (LESSER OF E5 OR E7) E9 SECONDARY COST CEILING PER MEMBER E10 SECONDARY CEILING (A7 * E9) E11 SECONDARY SHARED COST ((LESSER OF E5 OR E10) - E8) E12 TERTIARY SHARED COST (GREATER OF (E5 - E8 - E11) OR 0) 422,114,079.11 25,565.00 25,682.00 51,247.00 25,624.00 300.00 1,000 26,906,000.00 26,906,000.00 11,959 321,768,854.00 294,862,854.00 1.74 0.00 447.00 36.00 497.00 26,906 100,345,225.11 SHARED COST PER MEMBER = $15,688 PART F: EQUALIZED PROPERTY VALUE F1 2023 TIFOUT VALUE (CERT MAY 24) + EXEMPT COMPUTER VALUE (CERT MAY 17) 40,212,783,775 10R 000000 000 10R 210 + 691 10R 000000 620 (DPI AMOUNT) 10R 000000 850 10R 000000 873 10R 000000 874 10R 000000 972 (TO LINE C6) + - - - - - - - = 478,239,581.10 342,275,380.00 37,894,952.00 VALUE PER MEMBER = 1,494,566 PART G: 2024-25 EQUAL AID BY TIER - JULY 1 ESTIMATE G1 PRIMARY GUARANTEED VALUE PER MEMBER G2 PRIMARY GUARANTEED VALUATION (A7 * G1) G3 PRIMARY REQUIRED RATE (E8 / G2) G4 PRIMARY NET GUARANTEED VALUE (G2 - F1) G5 PRIMARY EQUALIZATION AID (G3 * G4) (NOT LESS THAN 0) G6 SECONDARY GUARANTEED VALUE PER MEMB G7 SECONDARY GUARANTEED VALUATION (A7 * G6) G8 SECONDARY REQUIRED RATE (E11 / G7) G9 SECONDARY NET GUARANTEED VALUE (G7 - F1) G10 SECONDARY EQUALIZATION AID (G8 * G9) G11 TERTIARY GUARANTEED VALUE PER MEMB G12 TERTIARY GUARANTEED VALUATION (A7 * G11) G13 TERTIARY REQUIRED RATE (E12 / G12) G14 TERTIARY NET GUARANTEED VALUE (G12 - F1) G15 TERTIARY EQUALIZATION AID (G13 * G14) 0.00 0.00 0.00 0.00 1,930,000 51,928,580,000 0.00051813 11,715,796,225 6,070,305.50 2,218,770 59,698,225,620 0.00493922 19,485,441,845 96,242,884.07 977,295 26,295,099,270 0.00381612 -13,917,684,505 -53,111,554.19 July 1 Aid Estimate Worksheet 5,000.00 98,064,249.10 PART C: 2023-24 NET COST OF GENERAL FUND (BUDGET REPORT) C1 TOTAL GF EXPENDITURES C2 DEBT SRVC TRANSFER C3 REORG SETTLEMENT C4 REFUND PRIOR YEAR REV C5 GROSS COST GEN FUND C6 DEDUCTIBLE RECEIPTS C7 OPERATIONAL DEBT, INTEREST C8 NET COST GENERAL FUND 10E 000000 000 10E 411000 838+839 10E 491000 950 10E 492000 972 (C1 - C2 - C3 - C4) (FROM LINE B9) 38E+39E 283000 680 (NOT LESS THAN 0) + - - - + - + = 490,610,452.50 0.00 0.00 200,000.00 490,410,452.50 98,064,249.10 0.00 392,346,203.40 PART H: 2024-25 EQUALIZATION AID - JULY 1 ESTIMATE H1 2024-25 EQUALIZATION AID - JULY 1 EST (G5+G10+G15) NOT< 0 H2 PARENTAL CHOICE DEDUCT, EQUALIZATION AID (MPS only) H2A PAYMENT TO MILWAUKEE SCHOOL DISTRICT FROM CITY OF MILWAUKEE H3 MILWAUKEE CHARTER PGM DEDUCT, EQUALIZATION AID (Revised to 0 by JFC, 6/2021) H4A 2023-24 OCT-TO-FINAL ADJUSTMENT, EQUALIZATION AID H4B 2023-24 OCT-TO-FINAL ADJ, CHOICE/CHARTER DEDUCTION (previously Line I4) H5 PRIOR YEAR (2023-24) DATA ERROR ADJ/OR FEE PENALTY H6 2024-25 EQUALIZATION AID - JULY 1 EST (ROUND) (H1+H2+H2A+H3+H4A+H4B+H5) 49,201,635.38 PART D: 2023-24 NET COST OF DEBT SERVICE FUNDS (BUDGET REPORT) D1 TOTAL REVENUE & TRNSF IN D2 TRNSF FROM GEN FUND D3 PROPERTY TAXES D4 PAYMENT IN LIEU OF TAX D5 NON-REV RECEIPTS D6 DEDUCTIBLE RECEIPTS D7 TOTAL EXPENDITURES D8 AIDABLE FUND 41 EXP D9 REFINANCING D10 OPERATIONAL DEBT PAYMENT D11 NET COST DEBT SERVICE FUNDS 38R + 39R 000 10E 411000 838 + 839 38R + 39R 210 38R + 39R 220 38R + 39R 800 (D1-D2-D3-D4-D5) 38E + 39E 000 (DPI AMOUNT) 38E + 39E 282000 38E + 39E 283000 (CAN BE NEGATIVE) + - - - - - + + - - = 26,943,092.00 0.00 0.00 0.00 0.00 26,943,092.00 0.00 0.00 0.00 2,164,839.00 0.00 0.00 28,530,413.28 3,321,452.07 51,366,474 *** PART I: 2024-25 SPECIAL ADJUSTMENT, INTER, AND INTRA AID SUMMARY - JULY 1 EST *** 0.00 0.00 I1 2024-25 SPECIAL ADJUSTMENT AID and/or CHAPTER 220 - JULY 1 EST I2A PARENTAL CHOICE DEDUCT, SPEC ADJ AID and/or CHAPTER 220 AID (MPS only) I2B MILW CHARTER DEDUCT, SPEC ADJ AID and/or CHAP. 220 AID (Removed by JFC, 6/2021) I2C 2023-24 OCT-TO-FINAL ADJUSTMENT, SPEC ADJ AID and/or CHAPTER 220 AID I3 2024-25 SPEC ADJ AID and/or CHAP 220 - JULY 1 EST (ROUND) (I1+I2A+I2B+I2C) 0.00 0.00 0.00 0.00 0.00 31,851,865.35 PART E: 2023-24 SHARED COST (BUDGET REPORT) E1 NET COSTS: GEN + DEBT SERV FUNDS E2 TRANSP OF INDIGENT PUPILS, REG 3K PGMS, AND/OR OTHER E3 IMPACT AID DISTS: IMPACT AID NON-DEDUCTIBLE REMOVED E4 TOTAL SHARED COST FOR EQUALIZATION AID (C8 + D11) + - - = 424,198,068.75 2,083,989.64 *I5 2024-25 JULY 1 ESTIMATE OF GENERAL AID (H6+I3) 51,366,474 0.00 422,114,079.11 25/3

What to Look For A7 AID MEMBERSHIP (A4+A5+A6A+A6B+A6C+A6D+A6E) (ROUNDED) 26,906 E9 SECONDARY COST CEILING PER MEMBER 11,959 SHARED COST PER MEMBER = $15,688 GUARANTEES FOR JULY 1 ESTIMATE K-12 PRIMARY (G1) 1,930,000 SECONDARY (G6) 2,218,770 TERTIARY (G11) 977,295 VALUE PER MEMBER = 1,494,566 *I5 2024-25 JULY 1 ESTIMATE OF GENERAL AID (H6+I3) 51,366,474 26/3

WISCONSIN DEPARTMENT OF PUBLIC INSTRUCTION ANALYSIS OF GENERAL AID AND EQUALIZATION AID FORMULA COMPONENTS* ** Madison Metropolitan 2015-16 FINAL AID 2016-17 FINAL AID 2017-18 FINAL AID 2018-19 FINAL AID 2019-20 FINAL AID 2020-21 FINAL AID 2021-22 FINAL AID 2022-23 FINAL AID 2023-24 FINAL AID 2024-25 JULY 1 ESTIMATE (2014-15 DATA) 4,475,960,500 (2015-16 DATA) 4,584,098,000 108,137,500 (2016-17 DATA) 4,584,098,000 (2017-18 DATA) 4,656,848,000 72,750,000 (2018-19 DATA) 4,740,048,000 83,200,000 (2019-20 DATA) 4,903,590,000 163,542,000 (2020-21 DATA) 5,013,590,000 110,000,000 (2021-22 DATA) 5,201,590,000 188,000,000 (2022-23 DATA) (23-24 BUDGET DATA) 5,356,290,000 154,700,000 GENERAL AID APPROPRIATION YEAR OVER YEAR APPRO CHANGE 5,581,190,000 224,900,000 0 0 1,930,000 1,101,520 546,173 1,930,000 1,146,928 558,545 1,930,000 1,173,281 573,441 1,930,000 1,241,277 594,939 1,930,000 1,329,871 621,431 1,930,000 1,451,991 656,434 1,930,000 1,567,708 715,267 1,930,000 1,681,045 754,860 1,930,000 2,031,841 861,640 1,930,000 2,218,770 977,295 STATE PRIMARY GUARANTEE STATE SECONDARY GUARANTEE STATE TERTIARY GUARANTEE 1,000 9,401 1,000 9,538 1,000 9,618 1,000 9,729 1,000 9,781 1,000 10,030 1,000 10,760 1,000 10,951 1,000 11,103 1,000 11,959 PRIMARY COST CEILING SECONDARY COST CEILING 27,884 0.7% 27,942 0.2% 27,755 -0.7% 27,778 0.1% 27,941 0.6% 27,929 0.0% 26,962 -3.5% 26,882 -0.3% 26,904 0.1% 26,906 0.0% DISTRICT MEMBERSHIP % CHANGE IN MEMBERSHIP 0 0 0 0 0 0 0 0 4 0 0 0 0 DISTRICT INTER MEMBERS DISTRICT INTRA MEMBERS 263 163 124 90 60 35 24 27,884,000 234,253,484 50,915,604 313,053,088 27,942,000 238,568,796 49,686,457 316,197,253 27,755,000 239,192,590 53,431,453 320,379,043 27,778,000 242,474,162 58,216,005 328,468,167 27,941,000 245,349,921 60,384,835 333,675,756 27,929,000 252,198,870 63,549,463 343,677,333 26,962,000 263,149,120 59,310,998 349,422,118 26,882,000 267,502,782 91,592,770 385,977,552 10.5% 26,904,000 271,811,112 98,657,481 397,372,593 26,906,000 294,862,854 100,345,225 422,114,079 DISTRICT PRIMARY COST DISTRICT SECONDARY COST DISTRICT TERTIARY COST DISTRICT TOTAL SHARED COST % CHANGE IN SHARED COST Longitudinal Aid Worksheet Link 2.1% 1.0% 1.3% 2.5% 1.6% 3.0% 1.7% 3.0% 6.2% 11,227 9,401 119.4% 11,316 9,538 118.6% 11,543 9,618 120.0% 11,825 9,729 121.5% 11,942 9,781 122.1% 12,305 10,030 122.7% 12,960 10,760 120.4% 14,358 10,951 131.1% 14,770 11,103 133.0% 15,688 11,959 131.2% DISTRICT SHARED COST/MEMBER SECONDARY CEILING DISTRICT SHARED COST/MEMBER AS % OF SECONDARY CEILING 22,653,787,457 812,430 546,173 23,447,480,065 839,148 558,546 24,222,574,258 872,728 573,441 25,714,368,614 925,710 594,939 27,971,395,410 1,001,088 621,431 29,852,660,916 1,068,877 656,434 31,473,939,990 1,167,344 715,267 31,381,733,220 1,167,388 754,860 36,486,785,574 1,356,184 861,640 40,212,783,775 1,494,566 977,295 DISTRICT EQUALIZED VALUE DISTRICT EQ VALUE/MEMBER AVERAGE VALUE PER MEMBER DISTRICT EQUALIZED VALUE/MEM AS % OF STATE AVERAGE 148.7% 150.2% 152.2% 155.6% 161.1% 162.8% 163.2% 154.6% 157.4% 152.9% 16,146,139 61,479,042 -24,821,067 52,804,114 15,792,903 64,020,245 -24,961,619 54,851,528 15,204,305 61,272,566 -27,886,654 48,590,217 14,454,361 61,643,640 -32,366,647 43,731,354 13,447,927 60,657,740 -36,891,519 37,214,148 12,461,187 66,543,808 -39,928,596 39,076,399 10,654,162 67,203,421 -37,486,874 40,370,709 10,621,938 81,737,572 -50,055,178 42,304,331 7,998,857 90,386,524 -56,625,166 41,760,214 6,070,306 96,242,884 -53,111,554 49,201,635 DISTRICT PRIMARY AID DISTRICT SECONDARY AID DISTRICT TERTIARY AID DISTRICT TOTAL EQUALIZATION AID 57.9% 26.2% -48.7% 16.9% 56.5% 26.8% -50.2% 17.3% 54.8% 25.6% -52.2% 15.2% 52.0% 25.4% -55.6% 13.3% 48.1% 24.7% -61.1% 11.2% 44.6% 26.4% -62.8% 11.4% 39.5% 25.5% -63.2% 11.6% 39.5% 30.6% -54.6% 11.0% 29.7% 33.3% -57.4% 10.5% 22.6% 32.6% -52.9% 11.7% PRIMARY TIER AID/COST RATIO SECOND TIER AID/COST RATIO TERTIARY TIER AID/COST RATIO TOTAL AID/COST RATIO 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 DISTRICT SPECIAL ADJUSTMENT AID DISTRICT INTER AID (CHAP 220) DISTRICT INTRA AID (CHAP 220) DISTRICT SPEC ADJ+CHAP 220 AID 498,046 498,046 384,021 384,021 320,017 320,017 256,014 256,014 192,010 192,010 128,007 128,007 64,003 64,003 6,295 6,295 DISTRICT GENERAL AID TOTAL % CHANGE IN GROSS GENERAL AID 53,302,160 -3.5% 55,235,549 48,910,235 -11.5% 43,987,368 -10.1% 37,406,158 -15.0% 39,204,406 40,434,712 42,310,626 41,760,214 -1.3% 49,201,635 17.8% 27/3 3.6% 4.8% 3.1% 4.6%

2023-24 Equalization Aid Data (From July 1 Aid Estimate) 2023-24 Property Wealth Data 2023-24 Shared Cost Data Highest Property Value District Highest Overall District North Lakeland: $22,181,140 per pupil Gibraltar Area: $31,903 per pupil Equalization aid: $0 per pupil Lowest Property Value District* Lowest Overall District* Neillsville: $9,674 per pupil Abbotsford: $333,068 per pupil Equalization aid: $10,392 per pupil Statewide Average $13,287 per pupil Statewide Average $977,295 per pupil Equalization aid: $6,703 per pupil * Excluding Norris 28/3

Value Per Member Over Time 29/3

Equalization Aid Recap One pot of money is split over 421 school districts based on district membership, shared costs and values; changes in individual district data affect every other district s aid. October 15th! Aid Membership = Average of 3rd Friday in Sept + 2nd Friday in January FTE, plus 100% of Summer FTE, plus other adjustments This differs from Revenue Limit Membership. Depending on district value per member, some districts increase their aid by increasing expenses, while others decrease their aid by increasing expenses (negative vs positive tertiary aid). 30/3

Equalization Aid How can I find out where my district is in the aid formula? SFS Home General Aid Worksheets Current and Historical State and Federal Aid Overview General Aid Overview Equalization Aid Overview 31/3

Questions? DPI School Financial Services Team Jennifer Buros, Assistant Director Ben Kopitzke, Finance Consultant 608-266-1966 608-267-9279 32/3