Equalization Aid Formula Overview
This content delves into the Equalization Aid formula, exploring factors affecting aid amounts, shared costs, membership considerations, and property value assessments. Learn about the State's role in leveling the playing field for districts with lower property values through aid distribution.
Uploaded on Apr 04, 2025 | 0 Views
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.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
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.
E N D
Presentation Transcript
WASBO Fall Conference 3 October 2024 Equalization Aid: A Line-by-Line Exploration Jennifer Buros, Assistant Director School Financial Services Team Ben Kopitzke, Finance Consultant School Financial Services Team
The Big Picture State Aid (General + High Poverty + Computer + Exempt Personal Property) Revenue Limit Property TaxLevy 2/30
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. reasonable tax burden 3/30
Equalization Aid Factors What affects the amount of a district s Equalization Aid? District Factors (Prior Year Audited) Shared cost Most control Membership (Average of 3rd Friday in September + 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 4/30
What is Shared Cost? Shared Cost was developed to be used in the Equalization Aid computation and captures ONLY certain elements of the General (10) and Debt Service (38 and 39) Funds. Shared Cost can be defined as the district expenditures for which the district has no other revenues except for local Property Tax and Equalization Aid. Determine Shared Cost for the General Fund by starting with the total General Fund expenditures and remove from those expenditures the dollar amount of all the revenues EXCEPT for Property Tax and Equalization Aid. 5/30
Membership: Revenue Limit vs Aid Revenue Limit Three-year rolling average Equalization Aid Prior year audited data 100% of 3rd Friday in September FTE Average of 3rd Friday in September and 2nd Friday in January FTE 40% of Summer School FTE 100% of Summer School FTE New Independent Charter School FTE New Independent Charter School FTE and voucher students, including SNSP Group and Foster + Part-Time Non-Resident 6/30
Property Value Assessed valuation is property value as determined by the local municipal assessor on January 1 in any given year. Equalized valuation results when the Department of Revenue applies an adjustment factor to assessed value. The adjustment factor is meant to ensure each type of property has comparable value regardless of local assessment practices. Most state computations use equalized value, also known as "fair market" value. The October 1 Tax Apportionment Value Certification is used to apportion levies and set municipal tax bills. A "final" version is issued the following May (i.e., almost 1.5 years after the original assessment). This final version is known as the School Aid Value Certification and will be used in the FOLLOWING year's Equalization Aid formula, e.g., property value as of January 1, 2024, will eventually be used in the 2025-26 Equalization Aid computation. 7/30
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 Source: Department of Public Instruction 8/30
Property Value Per Member 2023-24 October 15 data Source: Department of Public Instruction 9/30
Shared Cost Per Member 2023-24 October 15 data Source: Department of Public Instruction 10/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) Appleton Area 0147 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) 186,739,076.92 13,933.00 13,935.00 27,868.00 13,934.00 324.00 1,000 14,943,000.00 14,943,000.00 11,959 178,703,337.00 163,760,337.00 0.55 0.50 621.00 63.00 0.00 14,943 8,035,739.92 SHARED COST PER MEMBER = $12,497 PART F: EQUALIZED PROPERTY VALUE F1 2023 TIFOUT VALUE (CERT MAY 24) + EXEMPT COMPUTER VALUE (CERT MAY 17) 12,116,687,131 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) + - - - - - - - = 208,145,608.10 61,428,708.00 104,558,048.00 VALUE PER MEMBER = 810,860 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 July 1 Aid Estimate Worksheet 28,839,990,000 0.00051813 16,723,302,869 8,664,844.92 2,218,770 33,155,080,110 0.00493922 21,038,392,979 103,913,251.37 977,295 14,603,719,185 0.00055025 2,487,032,054 1,368,489.39 14,479.00 42,144,373.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) + - - - + - + = 214,272,604.10 0.00 0.00 50,000.00 214,222,604.10 42,144,373.10 0.00 172,078,231.00 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) 113,946,585.68 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) + - - - - - + + - - = 12,968,252.00 0.00 0.00 0.00 0.00 12,768,252.00 0.00 0.00 1,016,582.00 0.00 0.00 200,000.00 13,718,252.00 1,142,593.92 114,963,168 *** 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 14,660,845.92 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) + - - = 186,739,076.92 0.00 0.00 11/3 *I5 2024-25 JULY 1 ESTIMATE OF GENERAL AID (H6+I3) 114,963,168 186,739,076.92
Ceilings and Guarantees Tertiary Guarantee State Average Value Per Member Tertiary Aid Negative Tertiary Aid Secondary Ceiling 90% of PY costs GUARANTEES FOR JULY 1 ESTIMATE K-12 UHS K-8 PRIMARY (G1) 1,930,000 Negative Secondary Aid 5,790,000 2,895,000 SECONDARY (G6) 2,218,770 6,656,310 3,328,155 Secondary Aid TERTIARY (G11) Secondary Guarantee Based on $$ in appropriation 977,295 2,931,885 1,465,942 Primary Ceiling Set in statute E9 SECONDARY COST CEILING PER MEMBER 11,959 Primary Aid No Equalization Aid Primary Guarantee In statute 12/3
Part A: Prior Year Audited Membership 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%. FTE 13,933.00 13,935.00 27,868.00 13,934.00 324.00 0.55 0.50 621.00 63.00 0.00 14,943 13/3
Part B: Deductible Receipts 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 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) + - - - - - - - = 208,145,608.10 61,428,708.00 104,558,048.00 0.00 0.00 0.00 0.00 14,479.00 42,144,373.10 14/3
Part C: Net Cost of General Fund 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) + - - - + - + = 214,272,604.10 0.00 0.00 50,000.00 214,222,604.10 42,144,373.10 0.00 172,078,231.00 15/3
Part D: Net Cost of Debt Service 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) + - - - - - + + - - = 12,968,252.00 0.00 12,768,252.00 0.00 0.00 200,000.00 13,718,252.00 1,142,593.92 0.00 0.00 14,660,845.92 16/3
Part E: Shared Cost 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) + - - = 186,739,076.92 0.00 0.00 186,739,076.92 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) 1,000 14,943,000.00 14,943,000.00 11,959 178,703,337.00 163,760,337.00 8,035,739.92 SHARED COST PER MEMBER = $12,497 17/3
Part E: Shared Cost & Part F: EQ Property Value 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) 1,000 14,943,000.00 14,943,000.00 11,959 178,703,337.00 163,760,337.00 8,035,739.92 SHARED COST PER MEMBER = $12,497 PART F: EQUALIZED PROPERTY VALUE F1 2023 TIFOUT VALUE (CERT MAY 24) + EXEMPT COMPUTER VALUE (CERT MAY 17) 12,116,687,131 VALUE PER MEMBER = 810,860 TERTIARY (G11) 977,295 High Spending & Low Value = POSITIVE TERTIARY AID 18/3
Part G: Equalization Aid by Tier 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) 1,930,000 28,839,990,000 0.00051813 16,723,302,869 8,664,844.92 2,218,770 33,155,080,110 0.00493922 21,038,392,979 103,913,251.37 977,295 14,603,719,185 0.00055025 2,487,032,054 1,368,489.39 Primary (G5) + Secondary (G10) + Tertiary (G15) = $113,946,585.68 19/3
How the Formula Works in Theory Primary Tier & Aid GUARANTEES FOR JULY 1 ESTIMATE K-12 UHS K-8 100% minus ($810,860 / $1,930,000) = 58.0% PRIMARY (G1) 1,930,000 5,790,000 2,895,000 SECONDARY (G6) 2,218,770 6,656,310 3,328,155 Primary Aid: 58.0% * $14,943,000 = $8,664,927 TERTIARY (G11) 977,295 2,931,885 1,465,942 2024-25 JULY 1 ESTIMATE E4 = 186,739,076.92 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) Secondary Tier & Aid 1,000 14,943,000.00 14,943,000.00 11,959 100% minus ($810,860 / $2,218,770) = 63.5% 178,703,337.00 163,760,337.00 Secondary Aid: 63.5% * $163,760,337 = 8,035,739.92 $103,913,347 Tertiary Tier & Aid SHARED COST PER MEMBER = $12,497 PART F: EQUALIZED PROPERTY VALUE F1 2023 TIFOUT VALUE (CERT MAY 24) + EXEMPT COMPUTER VALUE (CERT MAY 17) VALUE PER MEMBER = 12,116,687,131 810,860 100% minus ($810,860 / $977,295) = 17.0% Tertiary Aid: 17.0% * $8,035,740 = $1,368,500 20/3
Ceilings and Guarantees Tertiary Aid Negative Tertiary Aid Negative Secondary Aid Secondary Aid Primary Aid No Equalization Aid 21/3
Part H: EQ Aid & Part I: SA, Inter, and Intra 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) 113,946,585.68 0.00 0.00 0.00 1,016,582.00 0.00 0.00 114,963,168 *** PART I: 2024-25 SPECIAL ADJUSTMENT, INTER, AND INTRA AID SUMMARY - JULY 1 EST *** 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 *I5 2024-25 JULY 1 ESTIMATE OF GENERAL AID (H6+I3) 114,963,168 22/3
Special Adjustment Arrowhead UHS SPECIAL ADJUSTMENT COMPUTATION (NEW INFORMATION NOT FOUND ON PAGE 1) 1 EQUALIZATION AID ELIGIBILITY (LINE H1) FROM 23-24 FINAL AID 2 SPEC ADJ+INTER+INTRA ELIGIBILITY (LINE I1) FROM 23-24 FINAL AID 3 2023-24 REV LIMIT PENALTY FROM FINAL REV LIM RUN JUNE 2024 4 23-24 FINAL GEN AID ELIGIBILITY (1 + 2 - 3) (NOT < 0) 5 23-24 FINAL GEN AID ELIGIBILITY * 85% ("HOLD HARMLESS" THRESHOLD) 6 2024-25 EQUALIZATION AID ELIGIBILITY (LINE H1, PAGE 1) 7 2024-25 INTER + INTRA ELIGIBILITY 8 TOTAL GENERAL AID SO FAR IN THIS AID RUN (6+7) 9 2024-25 AID RUN SPEC ADJ (NON-CONSOLIDATION) AID COMPUTED (5 - 8)* (EXTRA NEEDED TO GET TO THE 85% HOLD HARMLESS THRESHOLD*) 10 2024-25 ADDITIONAL SPECIAL ADJUSTMENT FOR CONSOLIDATED DISTS (121.105(3)) 11 TOTAL 2024-25 JULY 1 EST SPECIAL ADJUSTMENT AID ELIGIBILITY 6,497,372.50 0.00 0.00 6,497,372.50 5,522,766.63 5,190,765.52 0.00 5,190,765.52 332,001.11 0.00 332,001.11 23/3
WISCONSIN DEPARTMENT OF PUBLIC INSTRUCTION ANALYSIS OF GENERAL AID AND EQUALIZATION AID FORMULA COMPONENTS* ** ANALYSIS OF GENERAL AID AND EQUALIZATION AID FORMULA COMPONENTS* ** ANALYSIS OF GENERAL AID AND EQUALIZATION AID FORMULA COMPONENTS* ** ANALYSIS OF GENERAL AID AND EQUALIZATION AID FORMULA COMPONENTS* ** WISCONSIN DEPARTMENT OF PUBLIC INSTRUCTION WISCONSIN DEPARTMENT OF PUBLIC INSTRUCTION WISCONSIN DEPARTMENT OF PUBLIC INSTRUCTION Appleton Area Kenosha Madison Metropolitan Elkhart Lake-Glenbeulah 2015-16 FINAL AID FINAL AID FINAL AID FINAL AID Longitudinal EQ Aid 2015-16 2015-16 2015-16 2016-17 FINAL AID FINAL AID FINAL AID FINAL AID 2016-17 2016-17 2016-17 2017-18 FINAL AID FINAL AID FINAL AID FINAL AID 2017-18 2017-18 2017-18 2018-19 FINAL AID FINAL AID FINAL AID FINAL AID 2018-19 2018-19 2018-19 2019-20 FINAL AID FINAL AID FINAL AID FINAL AID 2019-20 2019-20 2019-20 2020-21 FINAL AID FINAL AID FINAL AID FINAL AID 2020-21 2020-21 2020-21 2021-22 FINAL AID FINAL AID FINAL AID FINAL AID 2021-22 2021-22 2021-22 2022-23 FINAL AID FINAL AID FINAL AID FINAL AID 2022-23 2022-23 2022-23 2023-24 FINAL AID FINAL AID FINAL AID FINAL AID 2023-24 2023-24 2023-24 2024-25 2024-25 2024-25 2024-25 JULY 1 ESTIMATE JULY 1 ESTIMATE JULY 1 ESTIMATE JULY 1 ESTIMATE (2014-15 DATA) 4,475,960,500 4,475,960,500 4,475,960,500 4,475,960,500 (2014-15 DATA) (2014-15 DATA) (2014-15 DATA) (2015-16 DATA) 4,584,098,000 108,137,500 108,137,500 108,137,500 108,137,500 (2015-16 DATA) 4,584,098,000 4,584,098,000 4,584,098,000 (2015-16 DATA) (2015-16 DATA) (2016-17 DATA) (2016-17 DATA) (2016-17 DATA) (2016-17 DATA) 4,584,098,000 4,584,098,000 4,584,098,000 4,584,098,000 (2017-18 DATA) 4,656,848,000 4,656,848,000 4,656,848,000 (2017-18 DATA) (2017-18 DATA) (2017-18 DATA) 4,656,848,000 72,750,000 72,750,000 72,750,000 72,750,000 (2018-19 DATA) (2018-19 DATA) (2018-19 DATA) 4,740,048,000 83,200,000 83,200,000 83,200,000 83,200,000 (2018-19 DATA) 4,740,048,000 4,740,048,000 4,740,048,000 (2019-20 DATA) 4,903,590,000 4,903,590,000 4,903,590,000 (2019-20 DATA) (2019-20 DATA) (2019-20 DATA) 4,903,590,000 163,542,000 163,542,000 163,542,000 163,542,000 (2020-21 DATA) 5,013,590,000 5,013,590,000 5,013,590,000 (2020-21 DATA) 5,013,590,000 110,000,000 110,000,000 110,000,000 110,000,000 (2020-21 DATA) (2020-21 DATA) (2021-22 DATA) 5,201,590,000 188,000,000 188,000,000 188,000,000 188,000,000 (2021-22 DATA) 5,201,590,000 5,201,590,000 5,201,590,000 (2021-22 DATA) (2021-22 DATA) (2022-23 DATA) (23-24 BUDGET DATA) 5,356,290,000 154,700,000 154,700,000 154,700,000 154,700,000 (2022-23 DATA) (23-24 BUDGET DATA) (2022-23 DATA) (23-24 BUDGET DATA) (2022-23 DATA) (23-24 BUDGET DATA) 5,356,290,000 5,356,290,000 5,356,290,000 GENERAL AID APPROPRIATION GENERAL AID APPROPRIATION GENERAL AID APPROPRIATION GENERAL AID APPROPRIATION YEAR OVER YEAR APPRO CHANGE YEAR OVER YEAR APPRO CHANGE YEAR OVER YEAR APPRO CHANGE YEAR OVER YEAR APPRO CHANGE 5,581,190,000 224,900,000 224,900,000 224,900,000 224,900,000 5,581,190,000 5,581,190,000 5,581,190,000 0 0 0 0 0 0 0 0 1,930,000 1,930,000 1,930,000 1,101,520 546,173 546,173 546,173 546,173 1,930,000 1,101,520 1,101,520 1,101,520 1,930,000 1,930,000 1,930,000 1,146,928 558,545 558,545 558,545 558,545 1,930,000 1,146,928 1,146,928 1,146,928 1,930,000 1,173,281 1,173,281 1,173,281 1,930,000 1,930,000 1,930,000 1,173,281 573,441 573,441 573,441 573,441 1,930,000 1,930,000 1,930,000 1,241,277 594,939 594,939 594,939 594,939 1,930,000 1,241,277 1,241,277 1,241,277 1,930,000 1,329,871 621,431 621,431 621,431 621,431 1,930,000 1,930,000 1,930,000 1,329,871 1,329,871 1,329,871 1,930,000 1,451,991 656,434 656,434 656,434 656,434 1,930,000 1,930,000 1,930,000 1,451,991 1,451,991 1,451,991 1,930,000 1,567,708 715,267 715,267 715,267 715,267 1,930,000 1,930,000 1,930,000 1,567,708 1,567,708 1,567,708 1,930,000 1,681,045 754,860 754,860 754,860 754,860 1,930,000 1,930,000 1,930,000 1,681,045 1,681,045 1,681,045 1,930,000 2,031,841 2,031,841 2,031,841 1,930,000 1,930,000 1,930,000 2,031,841 861,640 861,640 861,640 861,640 1,930,000 2,218,770 2,218,770 2,218,770 1,930,000 1,930,000 1,930,000 2,218,770 977,295 977,295 977,295 977,295 STATE PRIMARY GUARANTEE STATE SECONDARY GUARANTEE STATE TERTIARY GUARANTEE STATE TERTIARY GUARANTEE STATE TERTIARY GUARANTEE STATE TERTIARY GUARANTEE STATE PRIMARY GUARANTEE STATE PRIMARY GUARANTEE STATE PRIMARY GUARANTEE STATE SECONDARY GUARANTEE STATE SECONDARY GUARANTEE STATE SECONDARY GUARANTEE 1,000 9,401 9,401 9,401 9,401 1,000 1,000 1,000 1,000 1,000 1,000 1,000 9,538 9,538 9,538 9,538 1,000 1,000 1,000 1,000 9,618 9,618 9,618 9,618 1,000 9,729 9,729 9,729 9,729 1,000 1,000 1,000 1,000 1,000 1,000 1,000 9,781 9,781 9,781 9,781 1,000 10,030 10,030 10,030 10,030 1,000 1,000 1,000 1,000 10,760 10,760 10,760 10,760 1,000 1,000 1,000 1,000 10,951 10,951 10,951 10,951 1,000 1,000 1,000 1,000 11,103 11,103 11,103 11,103 1,000 1,000 1,000 1,000 11,959 11,959 11,959 11,959 1,000 1,000 1,000 PRIMARY COST CEILING SECONDARY COST CEILING SECONDARY COST CEILING SECONDARY COST CEILING SECONDARY COST CEILING PRIMARY COST CEILING PRIMARY COST CEILING PRIMARY COST CEILING 1. 22,501 27,884 516 15,099 0.6% 0.0% 0.7% -0.8% 15,397 2.0% -0.1% 0.2% -5.8% 22,471 27,942 486 22,117 27,755 467 15,497 0.6% -1.6% -0.7% -3.9% 21,837 27,778 463 15,434 -0.4% -1.3% 0.1% -0.9% 15,486 0.3% -1.2% 0.6% 0.0% 21,566 27,941 463 15,477 -0.1% -2.2% 0.0% -2.8% 21,092 27,929 450 20,051 26,962 430 14,581 -5.8% -4.9% -3.5% -4.4% 14,825 1.7% -0.6% -0.3% -2.1% 19,924 26,882 421 19,974 26,904 424 14,841 0.1% 0.3% 0.1% 0.7% 19,671 26,906 448 14,943 0.7% -1.5% 0.0% 5.7% DISTRICT MEMBERSHIP % CHANGE IN MEMBERSHIP % CHANGE IN MEMBERSHIP % CHANGE IN MEMBERSHIP % CHANGE IN MEMBERSHIP DISTRICT MEMBERSHIP DISTRICT MEMBERSHIP DISTRICT MEMBERSHIP 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 DISTRICT INTER MEMBERS DISTRICT INTRA MEMBERS DISTRICT INTRA MEMBERS DISTRICT INTRA MEMBERS DISTRICT INTRA MEMBERS DISTRICT INTER MEMBERS DISTRICT INTER MEMBERS DISTRICT INTER MEMBERS 263 163 124 90 60 35 24 15,099,000 126,846,699 2,352,284 144,297,983 235,943,081 313,053,088 5,623,275 22,501,000 189,030,901 24,411,180 50,915,604 772,359 27,884,000 234,253,484 4,334,916 516,000 15,397,000 129,499,258 191,857,398 25,200,422 239,528,820 316,197,253 5,970,668 22,471,000 27,942,000 238,568,796 49,686,457 1,335,200 486,000 4,149,468 15,497,000 130,927,686 190,604,306 24,573,371 237,294,677 320,379,043 5,569,451 22,117,000 27,755,000 239,192,590 53,431,453 1,077,845 467,000 4,024,606 21,837,000 27,778,000 242,474,162 58,216,005 957,187 15,434,000 133,540,960 190,615,173 22,956,886 235,409,059 328,468,167 5,461,714 463,000 4,041,527 21,566,000 189,371,046 28,230,267 60,384,835 793,727 15,486,000 135,982,566 1,934,530 153,403,096 239,167,313 333,675,756 5,322,330 27,941,000 245,349,921 4,065,603 463,000 15,477,000 135,861,782 190,460,760 22,228,887 233,781,647 343,677,333 5,815,709 21,092,000 27,929,000 252,198,870 63,549,463 1,302,209 450,000 4,063,500 20,051,000 26,962,000 263,149,120 59,310,998 1,254,509 14,581,000 141,471,044 195,697,760 22,644,311 238,393,071 349,422,118 5,881,309 430,000 4,196,800 14,825,000 141,295,899 198,263,724 12,483,751 230,671,475 385,977,552 10.5% 19,924,000 26,882,000 267,502,782 91,592,770 1,231,655 421,000 4,189,371 26,904,000 271,811,112 4,283,672 19,974,000 201,797,322 7,201,389 98,657,481 761,889 14,841,000 149,938,623 525,817 165,305,440 228,972,711 397,372,593 5,469,561 424,000 19,671,000 215,574,489 1,812,853 237,058,342 422,114,079 6,823,921 26,906,000 294,862,854 100,345,225 1,466,289 14,943,000 163,760,337 8,035,740 186,739,077 13.0% 24.8% 448,000 4,909,632 DISTRICT PRIMARY COST DISTRICT SECONDARY COST DISTRICT TERTIARY COST DISTRICT TOTAL SHARED COST % CHANGE IN SHARED COST % CHANGE IN SHARED COST % CHANGE IN SHARED COST % CHANGE IN SHARED COST DISTRICT PRIMARY COST DISTRICT SECONDARY COST DISTRICT TERTIARY COST DISTRICT TOTAL SHARED COST DISTRICT TOTAL SHARED COST DISTRICT TOTAL SHARED COST DISTRICT PRIMARY COST DISTRICT SECONDARY COST DISTRICT PRIMARY COST DISTRICT SECONDARY COST DISTRICT TERTIARY COST DISTRICT TERTIARY COST 0 0 0 0 0 0 144,896,258 146,424,686 148,974,960 151,338,782 156,052,044 156,120,899 5,842,026 3.8% 3.4% 2.1% 0.8% 0.4% 1.5% 1.0% 6.2% 1.1% -0.9% 1.3% -6.7% 1.7% -0.8% 2.5% -1.9% 3.0% 1.6% 1.6% -2.6% -1.3% -2.3% 3.0% 9.3% 3.1% 2.0% 1.7% 1.1% 0.0% -3.2% -0.7% 5.9% -0.7% 3.0% -6.4% 3.5% 6.2% 9,557 9,401 101.7% 111.5% 119.4% 115.9% 10,486 9,401 9,401 9,401 11,227 10,898 9,411 9,538 98.7% 111.8% 118.6% 128.8% 10,659 9,538 9,538 9,538 11,316 12,285 9,449 9,618 98.2% 111.6% 120.0% 124.0% 11,543 11,926 10,729 9,618 9,618 9,618 9,652 9,729 99.2% 110.8% 121.5% 121.2% 11,825 11,796 10,780 9,729 9,729 9,729 9,906 9,781 101.3% 113.4% 122.1% 117.5% 11,942 11,495 11,090 9,781 9,781 9,781 9,778 10,030 97.5% 110.5% 122.7% 128.9% 12,305 12,924 11,084 10,030 10,030 10,030 10,702 10,760 99.5% 110.5% 120.4% 127.1% 12,960 13,677 11,889 10,760 10,760 10,760 10,531 10,951 96.2% 105.7% 131.1% 126.7% 14,358 13,877 11,578 10,951 10,951 10,951 11,138 11,103 100.3% 103.2% 133.0% 116.2% 14,770 12,900 11,464 11,103 11,103 11,103 12,497 11,959 104.5% 100.8% 131.2% 127.4% 15,688 15,232 12,051 11,959 11,959 11,959 DISTRICT SHARED COST/MEMBER DISTRICT SHARED COST/MEMBER SECONDARY CEILING DISTRICT SHARED COST/MEMBER DISTRICT SHARED COST/MEMBER DISTRICT SHARED COST/MEMBER DISTRICT SHARED COST/MEMBER SECONDARY CEILING SECONDARY CEILING DISTRICT SHARED COST/MEMBER SECONDARY CEILING DISTRICT SHARED COST/MEMBER AS % OF SECONDARY CEILING AS % OF SECONDARY CEILING AS % OF SECONDARY CEILING AS % OF SECONDARY CEILING 2. 22,653,787,457 642,455,881 6,976,418,444 462,045 546,173 546,173 546,173 148.7% 228.0% 7,985,836,624 354,910 812,430 1,245,070 546,173 23,447,480,065 647,846,518 7,139,496,228 463,694 558,546 558,546 558,546 150.2% 238.7% 8,253,953,961 367,316 839,148 1,333,018 558,546 24,222,574,258 654,271,422 8,616,332,759 389,580 872,728 1,401,009 573,441 7,322,246,995 472,494 573,441 573,441 573,441 152.2% 244.3% 25,714,368,614 670,928,993 7,719,182,109 500,141 594,939 594,939 594,939 155.6% 243.6% 8,920,730,694 408,514 925,710 1,449,091 594,939 27,971,395,410 703,423,564 9,438,283,690 437,646 1,001,088 1,519,273 621,431 7,947,275,550 513,191 621,431 621,431 621,431 161.1% 244.5% 29,852,660,916 738,658,956 10,186,945,404 482,977 1,068,877 1,641,464 656,434 8,471,652,607 547,370 656,434 656,434 656,434 162.8% 250.1% 31,473,939,990 778,834,799 10,744,250,194 535,846 1,167,344 1,811,244 715,267 9,069,257,856 621,991 715,267 715,267 715,267 163.2% 253.2% 31,381,733,220 821,772,208 11,548,587,737 579,632 1,167,388 1,951,953 754,860 9,559,191,236 644,802 754,860 754,860 754,860 154.6% 258.6% 36,486,785,574 895,700,725 13,435,841,367 672,667 1,356,184 2,112,502 10,561,477,636 711,642 861,640 861,640 861,640 861,640 12,116,687,131 810,860 977,295 977,295 977,295 977,295 40,212,783,775 1,029,525,560 14,748,891,540 749,778 1,494,566 2,298,048 DISTRICT EQUALIZED VALUE DISTRICT EQ VALUE/MEMBER DISTRICT EQUALIZED VALUE DISTRICT EQ VALUE/MEMBER AVERAGE VALUE PER MEMBER DISTRICT EQUALIZED VALUE/MEM DISTRICT EQUALIZED VALUE/MEM DISTRICT EQUALIZED VALUE/MEM DISTRICT EQUALIZED VALUE DISTRICT EQ VALUE/MEMBER AVERAGE VALUE PER MEMBER DISTRICT EQUALIZED VALUE/MEM AS % OF STATE AVERAGE AS % OF STATE AVERAGE AS % OF STATE AVERAGE AS % OF STATE AVERAGE DISTRICT EQUALIZED VALUE DISTRICT EQ VALUE/MEMBER AVERAGE VALUE PER MEMBER AVERAGE VALUE PER MEMBER 3. 84.6% 65.0% 83.0% 65.8% 82.4% 67.9% 84.1% 68.7% 82.6% 70.4% 83.4% 73.6% 87.0% 74.9% 85.4% 76.8% 82.6% 78.1% 157.4% 245.2% 83.0% 76.7% 152.9% 235.1% 11,484,171 73,639,373 362,325 85,485,870 155,036,537 52,804,114 183,120 18,363,094 128,124,983 8,548,460 -24,821,067 -988,330 16,146,139 61,479,042 -564,924 183,120 11,697,673 77,143,777 130,412,973 8,627,868 157,235,015 54,851,528 150,327 18,194,174 15,792,903 64,020,245 -24,961,619 -1,851,375 150,327 -673,253 11,702,983 78,201,544 127,315,429 7,878,932 152,846,780 48,590,217 127,998 17,652,418 15,204,305 61,272,566 -27,886,654 -1,555,506 127,998 -781,157 11,434,320 79,733,940 127,882,077 7,193,535 152,290,316 43,731,354 115,367 17,214,703 14,454,361 61,643,640 -32,366,647 -1,374,230 115,367 -676,629 11,368,137 83,507,581 336,951 95,212,669 152,075,610 37,214,148 98,531 16,675,546 127,051,115 8,348,948 -36,891,519 -1,146,774 13,447,927 60,657,740 -579,030 98,531 11,087,442 84,644,710 127,107,735 5,873,782 148,795,163 39,076,399 67,275 15,813,646 12,461,187 66,543,808 -39,928,596 -1,954,066 67,275 -530,255 9,881,813 85,342,066 128,807,845 5,680,201 148,971,945 40,370,709 26,458 14,483,899 10,654,162 67,203,421 -37,486,874 -1,922,235 26,458 -651,952 9,871,961 87,098,716 129,901,439 2,897,906 146,739,494 42,304,331 13,940,149 10,621,938 81,737,572 -50,055,178 -1,953,220 0 9,368,647 97,423,429 91,538 106,883,613 149,581,529 41,760,214 13,012,306 134,989,836 1,579,387 -56,625,166 -1,106,050 7,998,857 90,386,524 -170,055 0 12,028,978 142,726,334 422,038 -53,111,554 -1,981,601 8,664,845 103,913,251 1,368,489 113,946,586 155,177,350 49,201,635 6,070,306 96,242,884 -175,424 0 DISTRICT PRIMARY AID DISTRICT SECONDARY AID DISTRICT SECONDARY AID DISTRICT PRIMARY AID DISTRICT PRIMARY AID DISTRICT SECONDARY AID DISTRICT TERTIARY AID DISTRICT TERTIARY AID DISTRICT TERTIARY AID DISTRICT PRIMARY AID DISTRICT SECONDARY AID DISTRICT TERTIARY AID DISTRICT TOTAL EQUALIZATION AID DISTRICT TOTAL EQUALIZATION AID DISTRICT TOTAL EQUALIZATION AID DISTRICT TOTAL EQUALIZATION AID -675,136 0 0 0 0 0 0 0 88,841,450 89,904,527 91,168,260 95,732,152 95,223,879 96,970,677 0 0 81.6% 67.8% 35.0% -48.7% -128.0% 57.9% 26.2% -13.0% 35.5% 76.1% 58.1% 15.4% 59.2% 65.7% 16.9% 3.3% 81.0% 68.0% 34.2% -50.2% -138.7% 56.5% 26.8% -16.2% 30.9% 76.0% 59.6% 0.0% 61.3% 65.6% 17.3% 2.5% 79.8% 66.8% 32.1% -52.2% -144.3% 54.8% 25.6% -19.4% 27.4% 75.5% 59.7% 0.0% 61.4% 64.4% 15.2% 2.3% 78.8% 67.1% 31.3% -55.6% -143.6% 52.0% 25.4% -16.7% 74.1% 59.7% 0.0% 61.2% 64.7% 13.3% 2.1% 24.9% 77.3% 67.1% 29.6% -61.1% -144.5% 48.1% 24.7% -14.2% 73.4% 61.4% 17.4% 62.1% 63.6% 11.2% 1.9% 21.3% 75.0% 66.7% 26.4% -62.8% -150.1% 44.6% 26.4% -13.0% 14.9% 71.6% 62.3% 0.0% 63.3% 63.6% 11.4% 1.2% 72.2% 65.8% 25.1% -63.2% -153.2% 39.5% 25.5% -15.5% 67.8% 60.3% 0.0% 61.0% 62.5% 11.6% 0.4% 6.2% 70.0% 65.5% 23.2% -54.6% -158.6% 39.5% 30.6% -16.1% 66.6% 61.6% 0.0% 62.1% 63.6% 11.0% 0.0% 0.0% 65.1% 66.9% 21.9% -57.4% -145.2% 63.1% 65.0% 17.4% 64.7% 65.3% 10.5% 0.0% 29.7% 33.3% -4.0% 0.0% 61.2% 66.2% 23.3% -52.9% -135.1% 58.0% 63.5% 17.0% 61.0% 65.5% 11.7% 0.0% 22.6% 32.6% -3.6% 0.0% PRIMARY TIER AID/COST RATIO SECOND TIER AID/COST RATIO TERTIARY TIER AID/COST RATIO TERTIARY TIER AID/COST RATIO TERTIARY TIER AID/COST RATIO PRIMARY TIER AID/COST RATIO SECOND TIER AID/COST RATIO SECOND TIER AID/COST RATIO PRIMARY TIER AID/COST RATIO PRIMARY TIER AID/COST RATIO SECOND TIER AID/COST RATIO TERTIARY TIER AID/COST RATIO TOTAL AID/COST RATIO TOTAL AID/COST RATIO TOTAL AID/COST RATIO TOTAL AID/COST RATIO 231,867 0 0 0 0 0 0 0 0 0 0 0 0 202,412 0 0 0 0 0 0 0 0 0 0 0 0 171,830 0 0 0 0 0 0 0 0 0 0 0 0 139,486 0 0 0 0 0 0 0 0 0 0 0 0 118,095 0 0 0 0 0 0 0 0 0 0 0 0 116,857 0 0 0 0 0 0 0 0 0 0 0 0 130,053 0 0 0 0 0 0 0 0 0 0 0 0 133,035 0 0 0 0 0 0 0 0 0 0 0 0 113,080 0 0 0 0 0 0 0 0 0 0 0 0 0 0 96,118 0 0 0 0 0 0 0 0 0 0 0 0 0 0 DISTRICT SPECIAL ADJUSTMENT AID DISTRICT SPECIAL ADJUSTMENT AID DISTRICT INTER AID (CHAP 220) DISTRICT INTRA AID (CHAP 220) DISTRICT SPEC ADJ+CHAP 220 AID DISTRICT SPEC ADJ+CHAP 220 AID DISTRICT SPEC ADJ+CHAP 220 AID DISTRICT SPEC ADJ+CHAP 220 AID DISTRICT SPECIAL ADJUSTMENT AID DISTRICT INTER AID (CHAP 220) DISTRICT INTRA AID (CHAP 220) DISTRICT INTRA AID (CHAP 220) DISTRICT INTRA AID (CHAP 220) DISTRICT SPECIAL ADJUSTMENT AID DISTRICT INTER AID (CHAP 220) DISTRICT INTER AID (CHAP 220) 498,046 498,046 231,867 384,021 384,021 202,412 320,017 320,017 171,830 256,014 256,014 139,486 192,010 192,010 118,095 128,007 128,007 116,857 64,003 64,003 130,053 6,295 6,295 133,035 113,080 96,118 24/3 DISTRICT GENERAL AID TOTAL % CHANGE IN GROSS GENERAL AID % CHANGE IN GROSS GENERAL AID % CHANGE IN GROSS GENERAL AID % CHANGE IN GROSS GENERAL AID DISTRICT GENERAL AID TOTAL DISTRICT GENERAL AID TOTAL DISTRICT GENERAL AID TOTAL 85,485,870 155,036,537 53,302,160 414,986 -15.0% 88,841,450 157,235,015 55,235,549 352,738 -15.0% 89,904,527 152,846,780 48,910,235 -11.5% -15.0% 299,828 91,168,260 152,290,316 43,987,368 -10.1% -15.0% 254,853 95,212,669 152,075,610 37,406,158 -15.0% -15.0% 216,625 95,732,152 148,795,163 39,204,406 184,132 -15.0% 148,971,945 40,434,712 156,512 95,223,879 -0.5% -15.0% 96,970,677 146,739,494 42,310,626 133,035 -15.0% 149,581,529 41,760,214 113,080 106,883,613 10.2% -15.0% 113,946,586 155,177,350 49,201,635 17.8% -15.0% 96,118 2.4% 1.3% -3.5% 3.9% 1.4% 3.6% 1.2% -2.8% 1.4% -0.4% 4.4% -0.1% 0.5% -2.2% 4.8% 0.1% 3.1% 1.8% -1.5% 4.6% 1.9% -1.3% 6.6% 3.7%
Value Per Member Over Time Alma West Allis Source: Department of Public Instruction 25/3
Final 2023-24 EQ Aid Tertiary Aid Negative Tertiary Aid 113 202 Negative Secondary Aid Secondary Aid 62 Source: Department of Public Instruction Primary Aid No Equalization Aid 12 32 26/3
Finance Maps Equalization Aid Revenue Limits Mill Rates dpi.wi.gov/sfs/statistical/finance-maps/overview 27/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 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). 28/3
Aid Worksheets How can I predict future aid amounts? SFS Home Current and historical July 1, October 15, and Final Aid worksheets (and Final Aid adjustments) Longitudinal Aid Data 29/3
Questions? DPI School Financial Services Team https://dpi.wi.gov/sfs dpifin@dpi.wi.gov 608-267-9114 Jennifer Buros, Assistant Director Ben Kopitzke, Finance Consultant 608-266-1966 608-267-9279 30/3
