2.375% 20.5-Year Treasury Inflation Protected Security (TIPS) due January 15, 2025
Auction Prices, OID, Cash Flows, & YTM for $1,000 Purchase on 07/29/05 Held to Maturity
Description | TIPS of January 2025 | Dated Date | July 15, 2004 |
CUSIP Number | 912810FR4 | Ref CPI on Dated Date | 188.49677 |
Price before & after Applying Index Ratio and Real Yield to Maturity (YTM) & Nominal Return | ||||||||
---|---|---|---|---|---|---|---|---|
Auction | Issued | Ref CPI | Amount in 000's | Price before IR | Index Ratio | Price after IR | Real YTM | Nominal Return |
07/27/04 | 07/30/04 | 189.02903 | 11,000,069 | 98.480286 | 1.00282 | 98.758000 | 2.470 | 4.970 |
01/25/05 | 01/31/05 | 190.99677 | 10,999,930 | 106.144524 | 1.01326 | 107.552000 | 2.000 | 4.508 |
07/26/05 | 07/29/05 | 194.41935 | 6,000,013 | 104.537160 | 1.03142 | 107.821718 | 2.090 | 4.562 |
Total Auctioned | 28,000,012 |
OID for Purchase on 07/29/05 | ||||
---|---|---|---|---|
Click Year for Daily Index Ratios | ||||
Year | Date | Ref CPI | Index Ratio | OID per $1,000 |
07/29/05 | 194.41935 | 1.03142 | ||
2005 | 01/01/06 | 199.20000 | 1.05678 | 25.36 |
2006 | 01/01/07 | 201.80000 | 1.07058 | 13.80 |
2007 | 01/01/08 | 208.93600 | 1.10843 | 37.85 |
2008 | 01/01/09 | 216.57300 | 1.14895 | 40.52 |
2009 | 01/01/10 | 216.17700 | 1.14685 | -2.10 |
2010 | 01/01/11 | 218.71100 | 1.16029 | 13.44 |
2011 | 01/01/12 | 226.42100 | 1.20119 | 40.90 |
2012 | 01/01/13 | 231.31700 | 1.22717 | 25.98 |
2013 | 01/01/14 | 233.54600 | 1.23899 | 11.82 |
2014 | 01/01/15 | 237.43300 | 1.25961 | 20.62 |
2015 | 01/01/16 | 237.83800 | 1.26176 | 2.15 |
2016 | 01/01/17 | 241.72900 | 1.28240 | 20.64 |
2017 | 01/01/18 | 246.66300 | 1.30858 | 26.18 |
2018 | 01/01/19 | 252.88500 | 1.34159 | 33.01 |
2019 | 01/01/20 | 257.34600 | 1.36525 | 23.66 |
2020 | 01/01/21 | 260.38800 | 1.38139 | 16.14 |
2021 | 01/01/22 | 276.58900 | 1.46734 | 85.95 |
2022 | 01/01/23 | 298.01200 | 1.58099 | 113.65 |
2023 | 01/01/24 | 307.67100 | 1.63223 | 51.24 |
2024 | 01/01/25 | 315.66400 | 1.67464 | 42.41 |
2025 | 01/15/25 | 315.58677 | 1.67423 | -0.41 |
Total | 642.81 |
Cash Flows per $1,000 Purchased on 07/29/05 | ||||||
---|---|---|---|---|---|---|
Click Year in Date Column for After Market Accrued Interest | ||||||
Date | Ref CPI | Index Ratio | Principal | Interest | Total Cash Flow | Discounted @ 4.562% YTM |
07/29/05 | 194.41935 | 1.03142 | -1,078.21718 | -0.93192160 | -1,079.14910160 | -1,079.14910160 |
01/15/06 | 198.47742 | 1.05295 | 12.50378125 | 12.50378125 | 12.24592987 | |
07/15/06 | 201.95161 | 1.07138 | 12.72263750 | 12.72263750 | 12.18239547 | |
01/15/07 | 201.66452 | 1.06986 | 12.70458750 | 12.70458750 | 11.89381691 | |
07/15/07 | 207.25639 | 1.09952 | 13.05680000 | 13.05680000 | 11.95095391 | |
01/15/08 | 209.49645 | 1.11141 | 13.19799375 | 13.19799375 | 11.81078810 | |
07/15/08 | 215.63997 | 1.14400 | 13.58500000 | 13.58500000 | 11.88600044 | |
01/15/09 | 214.69971 | 1.13901 | 13.52574375 | 13.52574375 | 11.57024071 | |
07/15/09 | 213.51819 | 1.13274 | 13.45128750 | 13.45128750 | 11.24994071 | |
01/15/10 | 216.24610 | 1.14721 | 13.62311875 | 13.62311875 | 11.13956060 | |
07/15/10 | 218.08532 | 1.15697 | 13.73901875 | 13.73901875 | 10.98379387 | |
01/15/11 | 218.75255 | 1.16051 | 13.78105625 | 13.78105625 | 10.77170133 | |
07/15/11 | 225.38381 | 1.19569 | 14.19881875 | 14.19881875 | 10.85073489 | |
01/15/12 | 226.33474 | 1.20074 | 14.25878750 | 14.25878750 | 10.65355798 | |
07/15/12 | 229.96306 | 1.21998 | 14.48726250 | 14.48726250 | 10.58287206 | |
01/15/13 | 230.82203 | 1.22454 | 14.54141250 | 14.54141250 | 10.38553684 | |
07/15/13 | 232.71797 | 1.23460 | 14.66087500 | 14.66087500 | 10.23734612 | |
01/15/14 | 233.33058 | 1.23785 | 14.69946875 | 14.69946875 | 10.03539046 | |
07/15/14 | 237.44594 | 1.25968 | 14.95870000 | 14.95870000 | 9.98462199 | |
01/15/15 | 236.85403 | 1.25654 | 14.92141250 | 14.92141250 | 9.73762065 | |
07/15/15 | 237.14365 | 1.25808 | 14.93970000 | 14.93970000 | 9.53212944 | |
01/15/16 | 237.61129 | 1.26056 | 14.96915000 | 14.96915000 | 9.33792399 | |
07/15/16 | 239.70132 | 1.27165 | 15.10084375 | 15.10084375 | 9.20999825 | |
01/15/17 | 241.55919 | 1.28150 | 15.21781250 | 15.21781250 | 9.07435368 | |
07/15/17 | 244.61839 | 1.29773 | 15.41054375 | 15.41054375 | 8.98434822 | |
01/15/18 | 246.66571 | 1.30859 | 15.53950625 | 15.53950625 | 8.85749607 | |
07/15/18 | 251.01658 | 1.33168 | 15.81370000 | 15.81370000 | 8.81276903 | |
01/15/19 | 252.50248 | 1.33956 | 15.90727500 | 15.90727500 | 8.66722002 | |
07/15/19 | 255.79368 | 1.35702 | 16.11461250 | 16.11461250 | 8.58438207 | |
01/15/20 | 257.28368 | 1.36492 | 16.20842500 | 16.20842500 | 8.44180133 | |
07/15/20 | 256.39126 | 1.36019 | 16.15225625 | 16.15225625 | 8.22493827 | |
01/15/21 | 260.31619 | 1.38101 | 16.39949375 | 16.39949375 | 8.16460226 | |
07/15/21 | 268.02090 | 1.42189 | 16.88494375 | 16.88494375 | 8.21881773 | |
01/15/22 | 277.20274 | 1.47060 | 17.46337500 | 17.46337500 | 8.31080420 | |
07/15/22 | 290.54829 | 1.54140 | 18.30412500 | 18.30412500 | 8.51665359 | |
01/15/23 | 297.87606 | 1.58027 | 18.76570625 | 18.76570625 | 8.53670086 | |
07/15/23 | 303.70803 | 1.61121 | 19.13311875 | 19.13311875 | 8.50973540 | |
01/15/24 | 307.39100 | 1.63075 | 19.36515625 | 19.36515625 | 8.42085976 | |
07/15/24 | 313.78329 | 1.66466 | 19.76783750 | 19.76783750 | 8.40426487 | |
01/15/25 | 315.58677 | 1.67423 | 1,674.23000 | 19.88148125 | 1,694.11148125 | 704.18649881 |
Total | 596.01282 | 599.02490340 | 1,195.03772340 | -0.00000082 | ||
OID | 642.81000 | |||||
Purchase Premium | -46.79718 |