Copyright Notice:
This template is the property of BOSC, Inc. and Region 13 and is subject to
the Terms, Conditions, and Privacy provisions as stated on Region 13's website:
http://www5.esc13.net/terms.html
Exceptions:
1) Texas public schools, Education Service Centers, charter schools, and any other non-profit entity
may reproduce or copy this template without the express written permission of BOSC, Inc.
This template is being provided by BOSC, Inc. to Region XIII ESC as a service to all school districts. It reflects
my understanding of the school finance provisions contained in SB 1 as passed by the 82nd Legislature, 1st Called
Session, and provisions contained in prior law (HB 1 and HB 3646).
It template does not necessarily reflect the way the TEA will implement the provisions of SB 1 However, the results
should be similar to the results that the Agency will produce when a 2011-13 Summary of Finances is generated.
The 2009-10 year is still applicable, since it is the starting point for SB 1.
THIS IS A PRELIMINARY RELEASE….MY UNDERSTANDING OF SB 1 IS ABSOLUTELY SUBJECT TO CHANGE UPON
FURTHER ENLIGHTENMENT, SO STAY TUNED.
Omar Garcia
BOSC, Inc.
Release 1: July 3, 2011
This is my 1st shot at a template that reflects the provisions of SB 1 as I understand them to date. As usual, stay tuned in
case further updates become necessary.
ps: you may find the 'Graph-SB1' tab useful in depicting your current state - remember, according to some over at the
Capitol, if you have to lay off folks and cut programs, it's not their fault, it's yours. Best of luck….and by the way, don't
forget to vote in future elections.
Funding Elements:
2009-10 HB 3646
Basic Allotment 4,765
Level 1 Guaranteed Yield
Level 2 Guaranteed Yield 59.02
Level 3 Guaranteed Yield 31.95
Level 1 Equalized Wealth Level 476,500
Level 2 Equalized Wealth Level 319,500
2010-11 HB 3646
Basic Allotment 4,765
Level 1 Guaranteed Yield
Level 2 Guaranteed Yield 59.97
Level 3 Guaranteed Yield 31.95
Level 1 Equalized Wealth Level 476,500
Level 2 Equalized Wealth Level 319,500
2011-12 HB 3646
Basic Allotment 4,765
Level 1 Guaranteed Yield
Level 2 Guaranteed Yield 59.97
Level 3 Guaranteed Yield 31.95
Level 3 Guaranteed Yield if @$1.17 in 10-11 33.95
Level 1 Equalized Wealth Level 476,500
Level 2 Equalized Wealth Level 319,500
Level 2 Equalized Wealth Level if @ $1.17 339,500
2012-13 HB 3646
Basic Allotment 4,765
Level 1 Guaranteed Yield
Level 2 Guaranteed Yield 59.97
Level 3 Guaranteed Yield 31.95
Level 1 Equalized Wealth Level 476,500
Level 2 Equalized Wealth Level 319,500
* NOTE: The Basic Allotment indicated pertains to districts that have a $1.00 compressed rate. If a district's
compressed rate is less than $1.00, the Basic Allotment is reduced proportionally.
ed rate. If a district's
A B C D E F J M N O P Q
1 District Name: 0 SB 1: 2011-12 & 2012-13
2 County-District No.: >>>>>>>>>>>>
Calculation of EDTR Limit:
10. Rate Used to Determine Maximum Limit 0.0000 0.0000 0.0000 0.0000
If all debt is being covered by IFA, Line 10=0, ELSE,
[(Line 2 + Line 4) / (Line 8 / 100)]
11. Rate Needed for All Eligible Debt 0.0000 0.0000 0.0000 0.0000
If all debt is being covered by IFA, Line 11=0, ELSE,
[(Line 5 - Line 6) / $35 / Line 7 / 100]
12. Allowed Rate (Lesser of Line 10 or Line 11, or $.29) 0.0000 0.0000 0.0000 0.0000
Calculation of Allotment:
13. State/Local Share of Allotment ($35 x Line 7 x Line 12 x 100) 0 0 0 0
14. Local Share of Allotment (Line 12 x (Line 9 / 100)) 0 0 0 0
NOTE: The district must budget ** (see ** below) and collect I&S taxes
in the amount of Line 14 in order to receive the full state's share.
15. Maximum State's Share of Allotment (Line 13 - Line 14) 0 0 0 0
16. EDA Entitlement - NOTE: If Line 16 is less than Line 15, the district has 0 0 0 0
not met its local share requirements. The I&S taxes entered in Row 93
of the 'Data Entry - SOF' tab, for the applicable year, must be equal to
or greater than Line 14.
District Name: 0 SB 1: 2011-12 & 2012-13
Co-Dist #: 000-000 Release 1
Run Date: 25-Nov-11 7/3/2011
* Bonds are eligible if (1) the district made payments on the bonds during the second year of each biennium
(2008-09 school year for 2009-10 and 2010-11; 2010-11 school year for 2011-12 and 2012-13) or taxes levied to
pay the principal of and interest on the bonds were included in the district's audited debt service collections
for the applicable second year of each biennium; and (2) the district does not receive IFA assistance for these bonds.
** The amount budgeted may include (1) I&S taxes collected for the applicable year,
(2) I&S taxes collected beginning with the 1999-00 school year that were in excess of the amounts
necessary to pay the district's share of actual debt service payments on bonds in those years
and were not used to generate other state aid, and (3) M&O taxes collected beginning with
the 1999-00 school year that were excess of the amount eligible to be used to generate state aid.
The Division of State Funding maintains the (2) and (3) amounts.
District Name: 0 SB 1: 2011-12 & 2012-13
Co-Dist #: 000-000 Release 1
Run Date: 25-Nov-11 7/3/2011
District Name: 0 SB 1: 2011-12 & 2012-13 0
Co-Dist #: 000-000 Release 1 0
Run Date: 25-Nov-11 7/3/2011 1/0/1900
Worksheet for Estimating Instructional Facilities Allotment
2009-10 thru 2012-13 School Years
The following IFA data (Notice of Allotment Amount and eligible debt payment) may not
reflect the latest information available from the Division of State Funding.
If this IFA data is incorrect, please contact TEA at (512) 463-9238.
EDA Eligible (based on 08-09 eligibility)
(bonded debt only)
Bonds Lease-Purchase
1.a Award #1: y
Notice of Allotment Amount 0 0
Eligible Debt Payment 0 0
Limitation (lesser amt) 0 0
1.b Award #2: y
Notice of Allotment Amount 0 0
Eligible Debt Payment 0 0
Limitation (lesser amt) 0 0
1.c Award #3: y
Notice of Allotment Amount 0 0
Eligible Debt Payment 0 0
Limitation (lesser amt) 0 0
1.d Award #4: y
Notice of Allotment Amount 0 0
Eligible Debt Payment 0 0
Limitation (lesser amt) 0 0
1.e Award #5: y
Notice of Allotment Amount 0 0
Eligible Debt Payment 0 0
Limitation (lesser amt) 0 0
1.f Award #6 y
Notice of Allotment Amount 0 0
Eligible Debt Payment 0 0
Limitation (lesser amt) 0 0
1.g Award #7 y
Notice of Allotment Amount 0 0
Eligible Debt Payment 0 0
Limitation (lesser amt) 0 0
1.h Award #8 y
Notice of Allotment Amount 0 0
Eligible Debt Payment 0 0
Limitation (lesser amt) 0 0
1.i Award #9 y
Notice of Allotment Amount 0 0
Eligible Debt Payment 0 0
Limitation (lesser amt) 0 0
District Name: 0 SB 1: 2011-12 & 2012-13 0
Co-Dist #: 000-000 Release 1 0
Run Date: 25-Nov-11 7/3/2011 1/0/1900
2009-10 2009-10 2010-11 2010-11 2011-12 2011-12 2012-13
BONDS LEASE-PURCHASE BONDS LEASE-PURCHASE BONDS LEASE-PURCHASE BONDS
ACTUAL DATA ACTUAL DATA ACTUAL DATA ACTUAL DATA YOUR DATA YOUR DATA YOUR DATA
2. Estimated ADA (400 minimum) 400.0000 400.0000 400.0000 400.0000 400.0000 400.0000 400.0000
3. CPTD Value for Applicable Year 0 0 0 0 0 0 0
Calculation of Allotment:
4. Limitation on Assistance (sum of "Limitations" above) 0 0 0 0 0 0 0
5. Local Revenue Generated by $.01 tax rate (Line 3 / 10,000) 0 0 0 0 0 0 0
6. Local Revenue per $.01 per ADA (Line 5 / Line 2) 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
7. State's Share of $35 per ADA Yield ($35 - Line 6) 35.0000 35.0000 35.0000 35.0000 35.0000 35.0000 35.0000
8. State's Share Expressed as Percentage (Line 7 / 35) 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000
9. Maximum State Share of IFA (Line 8 x Line 4) 0 0 0 0 0 0 0
NOTE: The state's share on Line 9 must be taken into
account when setting the district's I&S tax rate.
10. Local share of IFA (Line 4 - Line 9) 0 0 0 0 0 0 0
The district must budget (see * below) and collect I&S taxes in the
amount of the Line 10 (for bonds) in order to receive the full state share.
11. IFA Entitlement - NOTE: For Bonds, if Line 11 is less than 0 0 0 0 0 0 0
Line 10, the district has not met its local share requirements.
The I&S taxes entered in Row 93 of the 'Data Entry - SOF' tab, for the applicable year,
must be equal to or greater than the sum of Line 14 of the 'ExistingDebt' tab and Line 10 of this tab.
* The amount budgeted may include (1) I&S taxes collected for the applicable year,
(2) I&S taxes collected beginning with the 1999-00 school year that were in excess of the amounts
necessary to pay the district's share of actual debt service payments on bonds in those years
and were not used to generate other state aid, and (3) M&O taxes collected beginning with
the 1999-00 school year that were excess of the amount eligible to be used to generate state aid.
The Division of State Funding maintains the (2) and (3) amounts.
2012-13
LEASE-PURCHASE
YOUR DATA
400.0000
0
0
0
0.0000
35.0000
1.0000
0
0
0
CHAPTER 41 WADA CALCULATIONS:
2008-09 2008-09 HB 1
Adjustments for Non-resident Students: LPE YOURS 2009-10 2010-11
WADA-to-Enrollment Ratio 0.0000 0.0000 0.0000 0.0000
Tuition-paying Non-Residents Converted to WADA 0.0000 0.0000 0.0000 0.0000
Chapter 41 WADA = 0.0000 1,297.8323 0.0000
This sheet estimates the district's recapture costs (both Option 3 SB 1: 2011-12 & 2012-13
and Option 4) for the 2009-10 school year. Release 1
7/3/2011
HB 3646 HB 3646 HB 3646 HB 3646 HB 3646 HB 3646 HB 3646 HB 3646 HB 3646 HB 3646 HB 3646 HB 3646
2010-11 2010-11 2010-11 2010-11 2011-12 2011-12 2011-12 2011-12 2012-13 2012-13 2012-13 2012-13
OPTION 3 COST OPTION 4 COST OPTION 3 COST OPTION 4 COST OPTION 3 COST OPTION 3 COST OPTION 3 COST OPTION 4 COST OPTION 3 COST OPTION 3 COST OPTION 3 COST OPTION 4 COST
476,500 476,500 319,500 319,500 476,500 476,500 319,500 319,500 476,500 476,500 319,500 319,500
Hold Harmless Tax Rate: ACTUAL DATA ACTUAL DATA ACTUAL DATA ACTUAL DATA EST DATA EST DATA EST DATA EST DATA EST DATA EST DATA EST DATA EST DATA
1992-93 Total M&O Revenue 0 0 0 0 0 0 0 0 0 0 0 0
1992-93 WADA 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
Chapter 41 WADA #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
WADA Ratio (YEAR to 1992-93) 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
1992-93 Total M&O Rev Adj for WADA change 0 0 0 0 0 0 0 0 0 0 0 0
ASF Distribution 0 0 0 0 0 0 0 0 0 0 0 0
1992-93 Adjusted Revenue Less ASF 0 0 0 0 0 0 0 0 0 0 0 0
1992-93 M&O Effective Rate 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
Hold Harmless Effective Rate 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150
Tax Base at Equalized Level:
Tax Base at Equalized Level #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Tax Base at Hold Harmless Level:
1992-93 Hold Harmless Tax Base 0 N/A 0 N/A 0 N/A 0 N/A 0 N/A 0 N/A
Hold Harmless Tax Base per WADA #DIV/0! N/A #DIV/0! N/A #DIV/0! N/A #DIV/0! N/A #DIV/0! N/A #DIV/0! N/A
Adjusted Hold Harmless Tax Base per WADA #DIV/0! N/A #DIV/0! N/A #DIV/0! N/A #DIV/0! N/A #DIV/0! N/A #DIV/0! N/A
Adjusted Tax Base Retained at HH Level #DIV/0! N/A #DIV/0! N/A #DIV/0! N/A #DIV/0! N/A #DIV/0! N/A #DIV/0! N/A
Tax Base Reduction:
Tax Base Retained #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Excess Tax Base #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Proportional Tax Base Reduction #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Tax Base Retained per WADA #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Cost of Buying WADA:
M&O Taxes Collected Up to Compressed Rate #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
M&O Taxes Collected Beyond Compressed Rate + $.06 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Total M&O Taxes Subject to Recapture #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Initial Cost of Buying WADA #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
WADA Needed to Equalize Wealth * #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Initial Cost per WADA #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
WADA Credit for Tuition Paid #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
WADA Credit for New Instr. Facilities Allot. 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
WADA Needed to be Purchased #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Adjusted Cost After WADA Credits #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Credits Against Initial Cost:
Early Agreement/Efficiency Credit #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Credit for Appraisal Costs #DIV/0! 0 0 0 #DIV/0! 0 0 0 #DIV/0! 0 0 0
Discounted Cost #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Discounted Cost per WADA #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Was the Option chosen the least expensive? n n n n n n
(if it was not, change the Y to N for the applicable year)
This sheet estimates the district's recapture costs (both Option 3
and Option 4) for the 2009-10 school year.
@ Adj Reg Prog @ Adj Reg Prog @ Adj Reg Prog @ Adj Reg Prog @ Adj Reg Prog @ Adj Reg Prog @ Adj Reg Prog @ Adj Reg Prog
SB 1 SB 1 SB 1 SB 1 SB 1 SB 1 SB 1 SB 1
2011-12 2011-12 2011-12 2011-12 2012-13 2012-13 2012-13 2012-13
OPTION 3 COST OPTION 4 COST OPTION 3 COST OPTION 4 COST OPTION 3 COST OPTION 4 COST OPTION 3 COST OPTION 4 COST
476,500 476,500 319,500 319,500 476,500 476,500 319,500 319,500
339,500 @ $1.17
Hold Harmless Tax Rate: YOUR DATA YOUR DATA YOUR DATA YOUR DATA YOUR DATA YOUR DATA YOUR DATA YOUR DATA
1992-93 Total M&O Revenue 0 0 0 0 0 0 0 0
1992-93 WADA 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
Chapter 41 WADA #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
WADA Ratio (YEAR to 1992-93) 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
1992-93 Total M&O Rev Adj for WADA change 0 0 0 0 0 0 0 0
ASF Distribution 0 0 0 0 0 0 0 0
1992-93 Adjusted Revenue Less ASF 0 0 0 0 0 0 0 0
1992-93 M&O Effective Rate 0.0000 0.0000 0.0000 0.0000 0 0.0000 0.0000 0.0000
Hold Harmless Effective Rate 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150 0.0150
Tax Base at Equalized Level:
Tax Base at Equalized Level #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Tax Base at Hold Harmless Level:
1992-93 Hold Harmless Tax Base 0 N/A 0 N/A 0 N/A 0 N/A
Hold Harmless Tax Base per WADA #DIV/0! N/A #DIV/0! N/A #DIV/0! N/A #DIV/0! N/A
Adjusted Hold Harmless Tax Base per WADA #DIV/0! N/A #DIV/0! N/A #DIV/0! N/A #DIV/0! N/A
Adjusted Tax Base Retained at HH Level #DIV/0! N/A #DIV/0! N/A #DIV/0! N/A #DIV/0! N/A
Tax Base Reduction:
Tax Base Retained #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Excess Tax Base #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Proportional Tax Base Reduction #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Tax Base Retained per WADA #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Cost of Buying WADA:
M&O Taxes Collected Up to Compressed Rate #DIV/0! #DIV/0! #DIV/0! #DIV/0!
M&O Taxes Collected Beyond Compressed Rate + $.06 #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Total M&O Taxes Subject to Recapture #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Initial Cost of Buying WADA #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
WADA Needed to Equalize Wealth * #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Initial Cost per WADA #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
WADA Credit for Tuition Paid #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0.0000 #DIV/0! #DIV/0!
WADA Credit for New Instr. Facilities Allot. 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
WADA Needed to be Purchased #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Adjusted Cost After WADA Credits #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Credits Against Initial Cost:
Early Agreement/Efficiency Credit #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Credit for Appraisal Costs #DIV/0! 0 0 0 #DIV/0! 0 0 0
Discounted Cost #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Discounted Cost per WADA #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Was the Option chosen the least expensive? n n n n
(if it was not, change the Y to N for the applicable year)
SB 1 Graph 1:
Comparison of Total Operating Revenue
HB 3646 vs SB 1
1
1
1
1
1
1
0
0
0
0
0
2011-12 2012-13
HB 3646 Total State/Local Revenue SB 1 Total State/Local Revenue
SB 1 Graph 2:
Target Revenue: HB 3646 vs SB 1
1
1
1
1
1
1
0
0
0
0
0
2011-12 HB3646 Target Revenue 2011-12 SB 1 Target Revenue 2012-13 SB 1 Target Revenue
SB 1 Graph 3:
2011-12 SB 1 Total Operating Revenue
Target Revenue
Golden Penny Revenue
Silver Penny Revenue
Staff Allotment
SB 1 Graph 4:
2012-13 SB 1 Total Operating Revenue
Target Revenue
Golden Penny Revenue
Silver Penny Revenue
Staff Allotment