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: R3 Dated 04/24/2025

This release 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.


Current Law Only: R1 Dated 04/23/2025

This release only reflects 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.