Finance

A new release (Release 4 dated 6/9/17) is now available for download.  This new release pertains to only certain districts (see Notes tab).  Those districts not affected by this Release do not have to run it, as it will produce the same results as Release 3.  As always, please stay tuned for any new developments.


A new release (Release 3 dated 5/30/17) is now available for download.  This new release incorporates the few school finance provisions enacted by the 85th Legislative Session, as far as what is known as of this date (see the Notes tab).  The Effective M&O Tax Rate/Notice calculations are now incorporated into this release as well.  As always, please stay tuned for any new developments.


A new release (Release 2 dated 2/3/17) is now available that incorporates the recent TEA ruling regarding the local optional homestead exemption.
Please keep in mind that the calculations are subject to change after TEA generates a 2016-17 Summary of Finances incorporating the necessary changes.


This new release (Release 1, dated 1/23/17) incorporates the proposed changes to the “golden” penny yield as reflected in both the House and Senate current versions of an Appropriations bill (see Notes tab) for 2017-18 and 2018-19.  It is not final by any means, so as always, stay tuned.


A new template (release 6 dated 1/4/17) is now available for download. Please read the ‘Notes’ tab carefully for the changes made and stay tuned.


A new template (release 5 dated 8/2/16) is now available for download. A few corrections have been made to the Effective M&O Tax Rate and Notice calculations. Please read the ‘Notes’ tab carefully for other changes and stay tuned.


A new template (release 4 dated 6/24/16) is now available for download. The per capita rate has been changed and a correction has been made to the M&O hold harmless calculations. Please read the ‘Notes’ tab carefully for other changes and stay tuned.


A new template (release 3 dated 5/2/16) is now available for download. The M&O hold harmless calculations have been updated but should not significantly change the results produced in Release 2.  Please read the ‘Notes’ tab carefully for other changes and stay tuned.


A new template (release 2 dated 3/8/16) is now available for download. The eligible debt as of 9/1/15 that is used in I&S hold harmless calculations now loads automatically. Please read the ‘Notes’ tab carefully for other changes and stay tuned.


A new template (release 1 dated 12/8/15) is now available for download. The 2013-14 school year has been dropped and the 2020-21 year has been added. Also, the tax year 2014 $25K and $15K values used in 2015-16 now load automatically. The I&S hold harmless calculations related to the additional $10,000 homestead exemption have been updated as well. Please read the ‘Notes’ tab carefully and stay tuned.


A new template (release 4 dated 8/10/15) is now available for download. The hold harmless provisions related to the additional $10,000 homestead exemption have been updated. Please read the ‘Notes1’ tab carefully and stay tuned – the calculations are still preliminary and are subject to change.


A new template (release 3 dated 8/5/15) is now available for download. The hold harmless provisions related to the additional $10,000 homestead exemption have now been factored into this release. Please read the ‘Notes1’ tab carefully and stay tuned – the calculations are preliminary and are subject to change.


A new template (release 2 dated 6/3/15) is now available for download. This version makes some necessary corrections to Release 1 and reflects the changes made by the 84th Legislative Session as I understand them as of the date of this new release. Please read the ‘Notes1’ tab and stay tuned in case I am further enlightened. The hold harmless provisions related to the additional $10,000 homestead exemption have not been factored into this release and will require another release once the methodology for the calculations have been determined.


A new template (release 6C dated 5/7/15) is now available for download. This version just drops off the 2012-13 school year and adds years thru 2019-20. On the Assumptions' tab, you will see the change to the Tier II "golden penny" yield currently proposed for 2015-16 and 2016-17. If you wish to see the impact, just change the current $61.86 to the proposed rate and compare before and after. There probably won't be another release until after the Session(s), unless of course someone finds a problem with this one.


A new template (release 5 dated 5/22/14) is now available for download. This template is basically the same as the previous Release except that the estimated allotment rate for the TRS employer contribution assistance has been changed from $67.55 to $67.43 and the per capita rate for 2014-15 has been changed from $375 to $258.


A new template (release 4 dated 2/17/14) is now available for download. This template is basically the same as the previous Release except that the estimated allotment for the TRS employer contribution assistance has been added to the 2014-15 school year.  The allotment can be found on the 2014-15 'Other Programs Detail Report' (to get there, click on the 'Other Programs' link found on Line 44 of the 'Report-SOF1415' tab.


A new template (release 3 dated 11/4/13) is now available for download. This template is basically the same as the previous Release 2 except the 2013-14 per capita rate has been changed to $256.125 in accordance with the latest rate set by the SBOE. The transportation adjustment (can be positive or negative) that is included in the calculation of target revenue has been made applicable to Chapter 41 districts in accordance with the final rules adopted by the commissioner related to Additional State Aid for Tax Reduction. Previously, this adjustment had only applied to Chapter 42 districts.


A new template (release 2 dated 08/1/13) that reflects the new school finance funding elements adopted by the 83rd Legislature, Regular Session, is now available for download. Problems with the 2016-17 and 2017-18 have been corrected and a new tab (HB3646-Comparison) has been added. Please stay tuned for any further developments


A new template (release 1 dated 05/29/13) that reflects the new school finance funding elements adopted by the 83rd Legislature, Regular Session, is now available for download. This is a preliminary version of the template as the applicable bills have not been signed into law. Please stay tuned for any further developments.


A new template (release 3 dated 03/26/13) is now available for download. This template is basically the same as the previous Release 2 except that another year has been added. Also, a new tab labeled "Weights" has been added that will allow the user to run "what-if" scenarios on possible changes to law. The Effective M&O Tax Rate calculations have been updated to the 2013-14 school year as well.


A new template (release 2 dated 01/07/13) is now available for download. This template is basically the same as the previous Release 1 except that another year has been added. Also, a new tab labeled "Weights" has been added that will allow the user to run "what-if" scenarios on possible changes to law. The Effective M&O Tax Rate calculations have been updated to the 2013-14 school year as well.


A new template (release 1 dated 12/10/12) is now available for download. This template is basically the same as the previous Release 9 except that another year has been added. Also, a new tab labeled "Weights" has been added that will allow the user to run "what-if" scenarios on possible changes to law. The Effective M&O Tax Rate calculations have been updated to the 2013-14 school year as well.


A new template (release 9 dated 8/20/12) that includes the calculations for the Effective M&O Tax Rate and the Notice is now available for download. This release is also in a new format designed to more closely mirror the format now being used by TEA on the Summary of Finances. As usual, please check periodically for updates.


A new template (release 8 dated 8/5/12) that includes the calculations for the Effective M&O Tax Rate and the Notice is now available for download. This release is also in a new format designed to more closely mirror the format now being used by TEA on the Summary of Finances. As usual, please check periodically for updates.


A new template (release 7 dated 5/22/12) that includes the calculations for the Effective M&O Tax Rate and the Notice is now available for download. This release is also in a new format designed to more closely mirror the format now being used by TEA on the Summary of Finances. As usual, please check periodically for updates.


A new template (release 6 dated 5/8/12) that includes the calculations for the Effective M&O Tax Rate and the Notice is now available for download. This release is also in a new format designed to more closely mirror the format now being used by TEA on the Summary of Finances. As usual, please check periodically for updates.


A new template (release 5 dated 4/27/12) that includes the calculations for the Effective M&O Tax Rate and the Notice is now available for download. This release is also in a new format designed to more closely mirror the format now being used by TEA on the Summary of Finances. As usual, please check periodically for updates.


Release 4 dated 12/13/11 is still available for download should the district want to reconcile the 2010-11 final Summary of Finance with the template.


A new template that reflects the school finance provisions contained in SB 1 for the 2011-12 and 2012-13 school years is now available (release 4 dated 8/3/11). The template can also be used for the 2010-11 school year as well, as it reflects the latest from TEA for that year (ADA decline adjustment and property value decline adjustment will not be made). As usual, please check periodically for updates.


A new HB 3646 template (release 2 dated 2/10/10) has been developed with new users in mind. It is the same as the HB 3646 template linked in the first paragraph, except that it has been expanded to include descriptions about the data being entered and explanations of some of the calculations


A new manual worksheet that contains the HB 3646 state aid calculations for 2009-10 (Release 1, dated 9/18/09) is now available for download.


A new "reality check - part 3" state aid template (Release 4 dated 4/2/09) that includes the 2009-10 and 2010-11 school years is now available for download. This template is the same as the previous "reality check - part 2" template, except that the 2010-11 school year has been added.


A new "reality check" state aid template (2008-09 only - Release 2 dated 10/6/08) is now available for download. This template will auto-load all the data needed for state aid calculations, using "LPE" data from the Summary of Finances. A column has been added to allow the user to enter the latest, "real" data available, so that a side-by-side comparison can be made between the state aid being used for cash flow purposes and the estimated earned amount of state aid.


Woody Brewton, Region 12, has developed a template designed to assist districts in meeting the recording requirements of HB 3693, which relates to reducing energy consumption.


A version of the 2010-11 Financial Integrity Rating System of Texas (FIRST) template (Release 1 dated 2/10/2011) that uses 2009-29 data is now available for download.


Woody Brewton, a Field Service Agent at Region 13 ESC, has expanded the 2008-09 state aid template to incorporate actual attendance data after each six weeks. The "LPE" amounts are brought in and compared to the amounts currently being earned ("DPE") on the 'SOF0809-HB1' worksheet of the template based on actual student counts. If you have any questions on this template, you can contact Woody Brewton at 254-709-0545 or wbrewton@esc12.net.


A cash flow template is also available for download. This template was developed with the assistance of ESC XII and TEA.


A new Child Nutrition Fund budgeting template has been developed for the 2004-05 school year and is available for download.