Template for Estimating State Aid

This Excel template is designed to help develop annual budgets, monitor over/under state aid payments during the year, and for long-range planning, as it typically gives users the ability to project state aid for at least four subsequent school years. Developed and maintained by Omar Garcia of BOK Financial Securities, Inc., we are the sole source provider of this template and have been granted permission to share exclusively.
Current Releases
Current Law Plus HB 2: R4 Dated 05/01/2025
This release corrects a cell reference error that pertained to the calculation of ASAHE for 25-26 and was causing it to be significantly overstated in some instances (see Notes tab). Again, please be advised that all the calculations are subject to change and final school finance provisions will not be known until after a school finance bill is signed into law.
Current Law Only: R2 Dated 05/01/2025
This release only reflects current law for all years and corrects a couple of errors found in Release 1 (see Notes tab).
Previous Releases
Previous releases from the 2024-2025 fiscal year will be available until March 2026.
R3 Dated 04/24/2025, Current Law Plus HB 2, corrects cell references that were inadvertently changed on some of the 25-26 calculations (see Notes tab). Again, please be advised that all the calculations are subject to change and final school finance provisions will not be known until after a school finance bill is signed into law.
R1 Dated 04/23/2025, Current Law Only, eflects current law for all years, as we won’t know what the school finance provisions will look like beginning with the 25-26 school year until a school finance bill is passed and signed into law.