0.625% 10-Year Treasury Inflation Protected Security (TIPS) due January 15, 2024
Auction Prices, OID, Cash Flows, & YTM for $1,000 Purchase on 01/31/14 Held to Maturity
Description | Series A-2024 | Dated Date | January 15, 2014 |
CUSIP Number | 912828B25 | Ref CPI on Dated Date | 233.33058 |
Price before & after Applying Index Ratio and Yields to Maturity (YTM) - Real & Actual | ||||||||
---|---|---|---|---|---|---|---|---|
Auction | Issued | Ref CPI | Amount in 000's | Price before IR | Index Ratio | Price after IR | Real YTM | Nominal Return |
01/23/14 | 01/31/14 | 233.08439 | 15,000,000 | 99.653598 | 0.99894 | 99.547965 | 0.661 | 3.445 |
03/20/14 | 03/31/14 | 233.88803 | 13,000,005 | 99.677818 | 1.00239 | 99.916048 | 0.659 | 3.454 |
05/22/14 | 05/30/14 | 236.19545 | 13,000,053 | 102.706565 | 1.01228 | 103.967802 | 0.339 | 3.073 |
Total Auctioned | 41,000,058 |
OID for Purchase on 01/31/14 | ||||
---|---|---|---|---|
Click Year for Daily Index Ratios | ||||
Year | Date | Ref CPI | Index Ratio | OID per $1,000 |
01/31/14 | 233.08439 | 0.99894 | ||
2014 | 01/01/15 | 237.43300 | 1.01758 | 18.64 |
2015 | 01/01/16 | 237.83800 | 1.01932 | 1.74 |
2016 | 01/01/17 | 241.72900 | 1.03599 | 16.67 |
2017 | 01/01/18 | 246.66300 | 1.05714 | 21.15 |
2018 | 01/01/19 | 252.88500 | 1.08381 | 26.67 |
2019 | 01/01/20 | 257.34600 | 1.10292 | 19.11 |
2020 | 01/01/21 | 260.38800 | 1.11596 | 13.04 |
2021 | 01/01/22 | 276.58900 | 1.18540 | 69.44 |
2022 | 01/01/23 | 298.01200 | 1.27721 | 91.81 |
2023 | 01/01/24 | 307.67100 | 1.31861 | 41.40 |
2024 | 01/15/24 | 307.39100 | 1.31741 | -1.20 |
Total | 318.47 |
Cash Flows per $1,000 Purchased on 01/31/14 | ||||||
---|---|---|---|---|---|---|
Click Year in Date Column for After Market Accrued Interest | ||||||
Date | Ref CPI | Index Ratio | Principal | Interest | Total Cash Flow | Discounted @ 3.445% YTM |
01/31/14 | 233.08439 | 0.99894 | -995.47965 | -0.27595028 | -995.75560028 | -995.75560028 |
07/15/14 | 237.44594 | 1.01764 | 3.18012500 | 3.18012500 | 3.13099830 | |
01/15/15 | 236.85403 | 1.01510 | 3.17218750 | 3.17218750 | 3.07029768 | |
07/15/15 | 237.14365 | 1.01634 | 3.17606250 | 3.17606250 | 3.02199450 | |
01/15/16 | 237.61129 | 1.01835 | 3.18234375 | 3.18234375 | 2.97669757 | |
07/15/16 | 239.70132 | 1.02730 | 3.21031250 | 3.21031250 | 2.95201071 | |
01/15/17 | 241.55919 | 1.03527 | 3.23521875 | 3.23521875 | 2.92453797 | |
07/15/17 | 244.61839 | 1.04838 | 3.27618750 | 3.27618750 | 2.91142332 | |
01/15/18 | 246.66571 | 1.05715 | 3.30359375 | 3.30359375 | 2.88606586 | |
07/15/18 | 251.01658 | 1.07580 | 3.36187500 | 3.36187500 | 2.88724845 | |
01/15/19 | 252.50248 | 1.08217 | 3.38178125 | 3.38178125 | 2.85516428 | |
07/15/19 | 255.79368 | 1.09627 | 3.42584375 | 3.42584375 | 2.84338806 | |
01/15/20 | 257.28368 | 1.10266 | 3.44581250 | 3.44581250 | 2.81153323 | |
07/15/20 | 256.39126 | 1.09883 | 3.43384375 | 3.43384375 | 2.75432448 | |
01/15/21 | 260.31619 | 1.11565 | 3.48640625 | 3.48640625 | 2.74913178 | |
07/15/21 | 268.02090 | 1.14867 | 3.58959375 | 3.58959375 | 2.78256848 | |
01/15/22 | 277.20274 | 1.18803 | 3.71259375 | 3.71259375 | 2.82918264 | |
07/15/22 | 290.54829 | 1.24522 | 3.89131250 | 3.89131250 | 2.91516177 | |
01/15/23 | 297.87606 | 1.27663 | 3.98946875 | 3.98946875 | 2.93808673 | |
07/15/23 | 303.70803 | 1.30162 | 4.06756250 | 4.06756250 | 2.94487438 | |
01/15/24 | 307.39100 | 1.31741 | 1,317.41000 | 4.11690625 | 1,321.52690625 | 940.57091011 |
Total | 321.93035 | 69.36308097 | 391.29343097 | 0.00000003 | ||
OID | 318.47000 | |||||
Purchase Discount | 3.46035 |