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 Release:
Release Date: R5, SS#2 (Release 5, Special Session #2) 08/01/2023
The link above takes you to the new R5 file dated 08/01/2023 that fixes issues related to the Rate to Maintain and the Notice tabs. As always, stay tuned for any further developments.
Previous Versions:
R4, SS#2 (Release 4, Special Session #2) 07/24/2023 fixes various issues that have cropped up since Release 2 dated 07/18/2023 was posted. Please read the ‘Notes’ tab to see the types of changes that were made and note the pending issue that relates to certain 22-23 recapture districts. As always, stay tuned for any further developments.
R3, SS#2 (Release 3, Special Session #2) dated 07/20/2023 Please disregard this version – the wrong file was linked for that posting.
R2, SS#2, (Release 2, Special Session #2) dated 07/18/2023 reflects provisions in SB 2, as adopted by the 88th Texas Legislature, Second Called Session, and incorporates the required tax compression, the increase in the homestead exemption, and the M&O and I&S hold harmless provisions as I currently understand them. As always, stay tuned for any further developments.
SR#2 (Special Release #2) dated 06/15/2023 is current law, and fixes the problems with the Rate to Maintain tab. As always, stay tuned for any further developments.
SR#1 (Special Release #1) dated 6/12/2023 is current law, and includes the increase in the golden penny yield from $98.56 to $126.21 that was also adopted in the General Appropriations Act. For you 7/1 districts, that is all you have to go on right now. As always, stay tuned for any further developments.
Archive:
Archived versions are available on the Template for Estimating State Aid Historical Archive page.