Embed
Email

Debt Service Estimator-CP

Document Sample

Shared by: cuiliqing
Categories
Tags
Stats
views:
0
posted:
10/31/2011
language:
English
pages:
2
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

FY2012 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

TEXAS PUBLIC FINANCE AUTHORITY

GENERAL OBLIGATION COMMERCIAL PAPER

DEBT SERVICE ESTIMATE



Level Principal Payments



Fiscal Year Principal Interest Total Interest Rate



2012 - 45,123 45,123 4.50%

2013 50,000 42,935 92,935 4.50%

2014 50,000 40,685 90,685 4.50%

2015 50,000 38,435 88,435 4.50%

2016 50,000 36,284 86,284 4.50%

2017 50,000 33,935 83,935 4.50%

2018 50,000 31,685 81,685 4.50%

2019 50,000 29,435 79,435 4.50%

2020 50,000 27,259 77,259 4.50%

2021 50,000 24,935 74,935 4.50%

2022 50,000 22,685 72,685 4.50%

2023 50,000 20,435 70,435 4.50%

2024 50,000 18,234 68,234 4.50%

2025 50,000 15,935 65,935 4.50%

2026 50,000 13,685 63,685 4.50%

2027 50,000 11,435 61,435 4.50%

2028 50,000 9,210 59,210 4.50%

2029 50,000 6,935 56,935 4.50%

2030 50,000 4,685 54,685 4.50%

2031 50,000 2,065 52,065 4.50%

2032 50,000 185 50,185 4.50%



Total 1,000,000 476,199 1,476,199



Related docs
Other docs by cuiliqing
7 Recipes from Joe A.
Views: 2  |  Downloads: 0
Re-installingXPMode
Views: 3  |  Downloads: 0
telefonica_en
Views: 4  |  Downloads: 0
3220 Chap 6 demos
Views: 2  |  Downloads: 0
chap history.docx
Views: 3  |  Downloads: 0
Subcontractor Bid Form - The Fountains
Views: 1  |  Downloads: 0
English
Views: 1  |  Downloads: 0
DESIGNER'S SCHEDULE USE
Views: 1  |  Downloads: 0
Security Service Providers
Views: 45  |  Downloads: 0
By registering with docstoc.com you agree to our
privacy policy

You are almost ready to download!

You are almost ready to download!