1.375% 10-Year Treasury Inflation Protected Security (TIPS) due July 15, 2018
Auction Prices, OID, Cash Flows, & YTM for $1,000 Purchase on 07/15/08 Held to Maturity
Description | Series D-2018 | Dated Date | July 15, 2008 |
CUSIP Number | 912828JE1 | Ref CPI on Dated Date | 215.63997 |
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 |
07/10/08 | 07/15/08 | 215.63997 | 8,000,041 | 98.981282 | 1.00000 | 98.981282 | 1.485 | 3.008 |
10/08/08 | 10/15/08 | 219.56748 | 6,974,013 | 87.517484 | 1.01821 | 89.111177 | 2.850 | 4.222 |
Total Auctioned | 14,974,054 |
OID for Purchase on 07/15/08 | ||||
---|---|---|---|---|
Click Year for Daily Index Ratios | ||||
Year | Date | Ref CPI | Index Ratio | OID per $1,000 |
07/15/08 | 215.63997 | 1.00000 | ||
2008 | 01/01/09 | 216.57300 | 1.00433 | 4.33 |
2009 | 01/01/10 | 216.17700 | 1.00249 | -1.84 |
2010 | 01/01/11 | 218.71100 | 1.01424 | 11.75 |
2011 | 01/01/12 | 226.42100 | 1.05000 | 35.76 |
2012 | 01/01/13 | 231.31700 | 1.07270 | 22.70 |
2013 | 01/01/14 | 233.54600 | 1.08304 | 10.34 |
2014 | 01/01/15 | 237.43300 | 1.10106 | 18.02 |
2015 | 01/01/16 | 237.83800 | 1.10294 | 1.88 |
2016 | 01/01/17 | 241.72900 | 1.12098 | 18.04 |
2017 | 01/01/18 | 246.66300 | 1.14386 | 22.88 |
2018 | 07/15/18 | 251.01658 | 1.16405 | 20.19 |
Total | 164.05 |
Cash Flows per $1,000 Purchased on 07/15/08 | ||||||
---|---|---|---|---|---|---|
Click Year in Date Column for After Market Accrued Interest | ||||||
Date | Ref CPI | Index Ratio | Principal | Interest | Total Cash Flow | Discounted @ 3.008% YTM |
07/15/08 | 215.63997 | 1.00000 | -989.81282 | 0.00000000 | -989.81282000 | -989.81282000 |
01/15/09 | 214.69971 | 0.99564 | 6.84502500 | 6.84502500 | 6.74359747 | |
07/15/09 | 213.51819 | 0.99016 | 6.80735000 | 6.80735000 | 6.60710610 | |
01/15/10 | 216.24610 | 1.00281 | 6.89431875 | 6.89431875 | 6.59236370 | |
07/15/10 | 218.08532 | 1.01134 | 6.95296250 | 6.95296250 | 6.54992441 | |
01/15/11 | 218.75255 | 1.01443 | 6.97420625 | 6.97420625 | 6.47258538 | |
07/15/11 | 225.38381 | 1.04519 | 7.18568125 | 7.18568125 | 6.57003298 | |
01/15/12 | 226.33474 | 1.04960 | 7.21600000 | 7.21600000 | 6.49999056 | |
07/15/12 | 229.96306 | 1.06642 | 7.33163750 | 7.33163750 | 6.50629552 | |
01/15/13 | 230.82203 | 1.07040 | 7.35900000 | 7.35900000 | 6.43380960 | |
07/15/13 | 232.71797 | 1.07920 | 7.41950000 | 7.41950000 | 6.39058537 | |
01/15/14 | 233.33058 | 1.08204 | 7.43902500 | 7.43902500 | 6.31245972 | |
07/15/14 | 237.44594 | 1.10112 | 7.57020000 | 7.57020000 | 6.32858410 | |
01/15/15 | 236.85403 | 1.09838 | 7.55136250 | 7.55136250 | 6.21929448 | |
07/15/15 | 237.14365 | 1.09972 | 7.56057500 | 7.56057500 | 6.13461382 | |
01/15/16 | 237.61129 | 1.10189 | 7.57549375 | 7.57549375 | 6.05563858 | |
07/15/16 | 239.70132 | 1.11158 | 7.64211250 | 7.64211250 | 6.01837202 | |
01/15/17 | 241.55919 | 1.12020 | 7.70137500 | 7.70137500 | 5.97517286 | |
07/15/17 | 244.61839 | 1.13438 | 7.79886250 | 7.79886250 | 5.96115023 | |
01/15/18 | 246.66571 | 1.14388 | 7.86417500 | 7.86417500 | 5.92200231 | |
07/15/18 | 251.01658 | 1.16405 | 1,164.05000 | 8.00284375 | 1,172.05284375 | 869.51924065 |
Total | 174.23718 | 147.69170625 | 321.92888625 | -0.00000016 | ||
OID | 164.05000 | |||||
Purchase Discount | 10.18718 |