Note: Please contact TPFA for interest only amounts if deferring principal payments.
TEXAS PUBLIC FINANCE AUTHORITY
GENERAL OBLIGATION COMMERCIAL PAPER
Future Debt Service Estimation calculation
FY2012 Enter Issuance Enter Issuance FY 2012
Date in Cell A11 Amount in Cell E11 Interest to be paid $ 45,123.29
Principal to be paid $ -
09/01/11 09/01/12 $ 1,000,000.00 4.50% 366.00 $45,123.29 Total Debt Service $45,123.29
FY2013 FY 2013
09/01/12 10/01/12 $ 1,000,000.00 4.50% 30.00 $3,698.63 Interest to be paid $ 42,934.93
10/01/12 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/12 09/01/13 $ 950,000.00 4.50% 335.00 $39,236.30 Total Debt Service $92,934.93
FY2014 FY 2014
09/01/13 10/01/13 $ 950,000.00 4.50% 30.00 $3,513.70 Interest to be paid $ 40,684.93
10/01/13 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/13 09/01/14 $ 900,000.00 4.50% 335.00 $37,171.23 Total Debt Service $90,684.93
FY2015 FY 2015
09/01/14 10/01/14 $ 900,000.00 4.50% 30.00 $3,328.77 Interest to be paid $ 38,434.93
10/01/14 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/14 09/01/15 $ 850,000.00 4.50% 335.00 $35,106.16 Total Debt Service $88,434.93
FY2016 FY 2016
09/01/15 10/01/15 $ 850,000.00 4.50% 30.00 $3,143.84 Interest to be paid $ 36,283.56
10/01/15 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/15 09/01/16 $ 800,000.00 4.50% 336.00 $33,139.73 Total Debt Service $86,283.56
FY2017 FY 2017
09/01/16 10/01/16 $ 800,000.00 4.50% 30.00 $2,958.90 Interest to be paid $ 33,934.93
10/01/16 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/16 09/01/17 $ 750,000.00 4.50% 335.00 $30,976.03 Total Debt Service $83,934.93
FY2018 FY 2018
09/01/17 10/01/17 $ 750,000.00 4.50% 30.00 $2,773.97 Interest to be paid $ 31,684.93
10/01/17 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/17 09/01/18 $ 700,000.00 4.50% 335.00 $28,910.96 Total Debt Service $81,684.93
FY2019 FY 2019
09/01/18 10/01/18 $ 700,000.00 4.50% 30.00 $2,589.04 Interest to be paid $ 29,434.93
10/01/18 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/18 09/01/19 $ 650,000.00 4.50% 335.00 $26,845.89 Total Debt Service $79,434.93
FY2020 FY 2020
09/01/19 10/01/19 $ 650,000.00 4.50% 30.00 $2,404.11 Interest to be paid $ 27,258.90
10/01/19 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/19 09/01/20 $ 600,000.00 4.50% 336.00 $24,854.79 Total Debt Service $77,258.90
FY2021 FY 2021
09/01/20 10/01/20 $ 600,000.00 4.50% 30.00 $2,219.18 Interest to be paid $ 24,934.93
10/01/20 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/20 09/01/21 $ 550,000.00 4.50% 335.00 $22,715.75 Total Debt Service $74,934.93
FY2022 FY 2022
09/01/21 10/01/21 $ 550,000.00 4.50% 30.00 $2,034.25 Interest to be paid $ 22,684.93
10/01/21 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/21 09/01/22 $ 500,000.00 4.50% 335.00 $20,650.68 Total Debt Service $72,684.93
FY2023 FY 2023
09/01/22 10/01/22 $ 500,000.00 4.50% 30.00 $1,849.32 Interest to be paid $ 20,434.93
10/01/22 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/22 09/01/23 $ 450,000.00 4.50% 335.00 $18,585.62 Total Debt Service $70,434.93
FY2024 FY 2024
09/01/23 10/01/23 $ 450,000.00 4.50% 30.00 $1,664.38 Interest to be paid $ 18,234.25
10/01/23 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/23 09/01/24 $ 400,000.00 4.50% 336.00 $16,569.86 Total Debt Service $68,234.25
FY2025 FY 2025
09/01/24 10/01/24 $ 400,000.00 4.50% 30.00 $1,479.45 Interest to be paid $ 15,934.93
10/01/24 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/24 09/01/25 $ 350,000.00 4.50% 335.00 $14,455.48 Total Debt Service $65,934.93
FY2026 FY 2026
09/01/25 10/01/25 $ 350,000.00 4.50% 30.00 $1,294.52 Interest to be paid $ 13,684.93
10/01/25 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/25 09/01/26 $ 300,000.00 4.50% 335.00 $12,390.41 Total Debt Service $63,684.93
FY2027 FY 2027
09/01/26 10/01/26 $ 300,000.00 4.50% 30.00 $1,109.59 Interest to be paid $ 11,434.93
10/01/26 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/26 09/01/27 $ 250,000.00 4.50% 335.00 $10,325.34 Total Debt Service $61,434.93
FY2028 FY 2028
09/01/27 10/01/27 $ 250,000.00 4.50% 30.00 $924.66 Interest to be paid $ 9,209.59
10/01/27 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/27 09/01/28 $ 200,000.00 4.50% 336.00 $8,284.93 Total Debt Service $59,209.59
FY2029 FY 2029
09/01/28 10/01/28 $ 200,000.00 4.50% 30.00 $739.73 Interest to be paid $ 6,934.93
10/01/28 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/28 09/01/29 $ 150,000.00 4.50% 335.00 $6,195.21 Total Debt Service $56,934.93
FY2030 FY 2030
09/01/29 10/01/29 $ 150,000.00 4.50% 30.00 $554.79 Interest to be paid $ 4,684.93
10/01/29 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/29 09/01/30 $ 100,000.00 4.50% 335.00 $4,130.14 Total Debt Service $54,684.93
FY2031 FY 2031
10/01/30 10/01/30 $ 100,000.00 4.50% 0.00 $0.00 Interest to be paid $ 2,065.07
10/01/30 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/30 09/01/31 $ 50,000.00 4.50% 335.00 $2,065.07 Total Debt Service $52,065.07
FY2032 FY 2032
09/01/31 10/01/31 $ 50,000.00 4.50% 30.00 $184.93 Interest to be paid $ 184.93
10/01/31 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/31 09/01/32 $ - 4.50% 336.00 $0.00 Total Debt Service $50,184.93
Outstanding Principal Outstanding Interest
$ 1,000,000.00 $476,198.63 Est Total DS Pmts $1,476,198.63
Note: Please contact TPFA for interest only amounts if deferring principal payments.
TEXAS PUBLIC FINANCE AUTHORITY
GENERAL OBLIGATION COMMERCIAL PAPER
Future Debt Service Estimation calculation
Enter Issuance Enter Issuance
FY2013 FY 2013
Date in Cell A12 Amount in Cell E12 Interest to be paid $ 45,000.00
Principal to be paid $ -
09/01/12 09/01/13 $ 1,000,000.00 4.50% 365.00 $45,000.00 Total Debt Service $45,000.00
FY2014 FY 2014
09/01/13 10/01/13 $ 1,000,000.00 4.50% 30.00 $3,698.63 Interest to be paid $ 42,934.93
10/01/13 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/13 09/01/14 $ 950,000.00 4.50% 335.00 $39,236.30 Total Debt Service $92,934.93
FY2015 FY 2015
09/01/14 10/01/14 $ 950,000.00 4.50% 30.00 $3,513.70 Interest to be paid $ 40,684.93
10/01/14 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/14 09/01/15 $ 900,000.00 4.50% 335.00 $37,171.23 Total Debt Service $90,684.93
FY2016 FY 2016
09/01/15 10/01/15 $ 900,000.00 4.50% 30.00 $3,328.77 Interest to be paid $ 38,539.73
10/01/15 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/15 09/01/16 $ 850,000.00 4.50% 336.00 $35,210.96 Total Debt Service $88,539.73
FY2017 FY 2017
09/01/16 10/01/16 $ 850,000.00 4.50% 30.00 $3,143.84 Interest to be paid $ 36,184.93
10/01/16 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/16 09/01/17 $ 800,000.00 4.50% 335.00 $33,041.10 Total Debt Service $86,184.93
FY2018 FY 2018
09/01/17 10/01/17 $ 800,000.00 4.50% 30.00 $2,958.90 Interest to be paid $ 33,934.93
10/01/17 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/17 09/01/18 $ 750,000.00 4.50% 335.00 $30,976.03 Total Debt Service $83,934.93
FY2019 FY 2019
09/01/18 10/01/18 $ 750,000.00 4.50% 30.00 $2,773.97 Interest to be paid $ 31,684.93
10/01/18 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/18 09/01/19 $ 700,000.00 4.50% 335.00 $28,910.96 Total Debt Service $81,684.93
FY2020 FY 2020
09/01/19 10/01/19 $ 700,000.00 4.50% 30.00 $2,589.04 Interest to be paid $ 29,515.07
10/01/19 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/19 09/01/20 $ 650,000.00 4.50% 336.00 $26,926.03 Total Debt Service $79,515.07
FY2021 FY 2021
09/01/20 10/01/20 $ 650,000.00 4.50% 30.00 $2,404.11 Interest to be paid $ 27,184.93
10/01/20 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/20 09/01/21 $ 600,000.00 4.50% 335.00 $24,780.82 Total Debt Service $77,184.93
FY2022 FY 2022
09/01/21 10/01/21 $ 600,000.00 4.50% 30.00 $2,219.18 Interest to be paid $ 24,934.93
10/01/21 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/21 09/01/22 $ 550,000.00 4.50% 335.00 $22,715.75 Total Debt Service $74,934.93
FY2023 FY 2023
09/01/22 10/01/22 $ 550,000.00 4.50% 30.00 $2,034.25 Interest to be paid $ 22,684.93
10/01/22 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/22 09/01/23 $ 500,000.00 4.50% 335.00 $20,650.68 Total Debt Service $72,684.93
FY2024 FY 2024
09/01/23 10/01/23 $ 500,000.00 4.50% 30.00 $1,849.32 Interest to be paid $ 20,490.41
10/01/23 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/23 09/01/24 $ 450,000.00 4.50% 336.00 $18,641.10 Total Debt Service $70,490.41
FY2025 FY 2025
09/01/24 10/01/24 $ 450,000.00 4.50% 30.00 $1,664.38 Interest to be paid $ 18,184.93
10/01/24 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/24 09/01/25 $ 400,000.00 4.50% 335.00 $16,520.55 Total Debt Service $68,184.93
FY2026 FY 2026
09/01/25 10/01/25 $ 400,000.00 4.50% 30.00 $1,479.45 Interest to be paid $ 15,934.93
10/01/25 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/25 09/01/26 $ 350,000.00 4.50% 335.00 $14,455.48 Total Debt Service $65,934.93
FY2027 FY 2027
09/01/26 10/01/26 $ 350,000.00 4.50% 30.00 $1,294.52 Interest to be paid $ 13,684.93
10/01/26 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/26 09/01/27 $ 300,000.00 4.50% 335.00 $12,390.41 Total Debt Service $63,684.93
FY2028 FY 2028
09/01/27 10/01/27 $ 300,000.00 4.50% 30.00 $1,109.59 Interest to be paid $ 11,465.75
10/01/27 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/27 09/01/28 $ 250,000.00 4.50% 336.00 $10,356.16 Total Debt Service $61,465.75
FY2029 FY 2029
09/01/28 10/01/28 $ 250,000.00 4.50% 30.00 $924.66 Interest to be paid $ 9,184.93
10/01/28 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/28 09/01/29 $ 200,000.00 4.50% 335.00 $8,260.27 Total Debt Service $59,184.93
FY2030 FY 2030
09/01/29 10/01/29 $ 200,000.00 4.50% 30.00 $739.73 Interest to be paid $ 6,934.93
10/01/29 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/29 09/01/30 $ 150,000.00 4.50% 335.00 $6,195.21 Total Debt Service $56,934.93
FY2031 FY 2031
10/01/30 10/01/30 $ 150,000.00 4.50% 0.00 $0.00 Interest to be paid $ 4,130.14
10/01/30 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/30 09/01/31 $ 100,000.00 4.50% 335.00 $4,130.14 Total Debt Service $54,130.14
FY2032 FY 2032
09/01/31 10/01/31 $ 100,000.00 4.50% 30.00 $369.86 Interest to be paid $ 2,441.10
10/01/31 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/31 09/01/32 $ 50,000.00 4.50% 336.00 $2,071.23 Total Debt Service $52,441.10
FY2033 FY 2033
09/01/32 10/01/32 $ 50,000.00 4.50% 30.00 $184.93 Interest to be paid $ 184.93
10/01/32 $ (50,000.00) Principal to be paid $ 50,000.00
10/01/32 09/01/33 $ - 4.50% 335.00 $0.00 Total Debt Service $50,184.93
Outstanding Principal Outstanding Interest
$ 1,000,000.00 $475,921.23 Est Total DS Pmts $1,475,921.23
TEXAS PUBLIC FINANCE AUTHORITY
GENERAL OBLIGATION COMMERCIAL PAPER DEBT SERVICE
DEBT SERVICE ESTIMATE
Level Principal Payments
Fiscal Year Principal Interest Total Interest Rate
2012 $ - $ 45,123.29 $ 45,123.29 4.50%
2013 $ 50,000.00 $ 87,934.93 $ 137,934.93 4.50%
2014 $ 100,000.00 $ 83,619.86 $ 183,619.86 4.50%
2015 $ 100,000.00 $ 79,119.86 $ 179,119.86 4.50%
2016 $ 100,000.00 $ 74,823.29 $ 174,823.29 4.50%
2017 $ 100,000.00 $ 70,119.86 $ 170,119.86 4.50%
2018 $ 100,000.00 $ 65,619.86 $ 165,619.86 4.50%
2019 $ 100,000.00 $ 61,119.86 $ 161,119.86 4.50%
2020 $ 100,000.00 $ 56,773.97 $ 156,773.97 4.50%
2021 $ 100,000.00 $ 52,119.86 $ 152,119.86 4.50%
2022 $ 100,000.00 $ 47,619.86 $ 147,619.86 4.50%
2023 $ 100,000.00 $ 43,119.86 $ 143,119.86 4.50%
2024 $ 100,000.00 $ 38,724.66 $ 138,724.66 4.50%
2025 $ 100,000.00 $ 34,119.86 $ 134,119.86 4.50%
2026 $ 100,000.00 $ 29,619.86 $ 129,619.86 4.50%
2027 $ 100,000.00 $ 25,119.86 $ 125,119.86 4.50%
2028 $ 100,000.00 $ 20,675.34 $ 120,675.34 4.50%
2029 $ 100,000.00 $ 16,119.86 $ 116,119.86 4.50%
2030 $ 100,000.00 $ 11,619.86 $ 111,619.86 4.50%
2031 $ 100,000.00 $ 6,195.21 $ 106,195.21 4.50%
2032 $ 100,000.00 $ 2,626.03 $ 102,626.03 4.50%
2033 $ 50,000.00 $ 184.93 $ 50,184.93 4.50%
Total $ 2,000,000.00 $ 952,119.86 $ 2,952,119.86
Note: Enter issuance assumptions on calculation tab
Assumptions:Assumptions:
FY 2012 $ 1,000,000.00
FY 2013 $ 1,000,000.00
$ 2,000,000.00