0.125% 5-Year Treasury Inflation Protected Security (TIPS) due April 15, 2018
Auction Prices, OID, Cash Flows, & YTM for $1,000 Purchase on 12/31/13 Held to Maturity
Description | Series X-2018 | Dated Date | April 15, 2013 |
CUSIP Number | 912828UX6 | Ref CPI on Dated Date | 231.16013 |
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 |
04/18/13 | 04/30/13 | 232.10313 | 18,000,010 | 107.382589 | 1.00408 | 107.820710 | -1.311 | 0.052 |
08/22/13 | 08/30/13 | 233.46794 | 16,000,013 | 101.169475 | 1.00998 | 102.179146 | -0.127 | 1.215 |
12/19/13 | 12/31/13 | 233.56545 | 16,000,012 | 102.163581 | 1.01041 | 103.227104 | -0.375 | 1.062 |
Total Auctioned | 50,000,035 |
OID for Purchase on 12/31/13 | ||||
---|---|---|---|---|
Click Year for Daily Index Ratios | ||||
Year | Date | Ref CPI | Index Ratio | OID per $1,000 |
12/31/13 | 233.56545 | 1.01041 | ||
2013 | 01/01/14 | 233.54600 | 1.01032 | -0.09 |
2014 | 01/01/15 | 237.43300 | 1.02714 | 16.82 |
2015 | 01/01/16 | 237.83800 | 1.02889 | 1.75 |
2016 | 01/01/17 | 241.72900 | 1.04572 | 16.83 |
2017 | 01/01/18 | 246.66300 | 1.06707 | 21.35 |
2018 | 04/15/18 | 248.39153 | 1.07454 | 7.47 |
Total | 64.13 |
Cash Flows per $1,000 Purchased on 12/31/13 | ||||||
---|---|---|---|---|---|---|
Click Year in Date Column for After Market Accrued Interest | ||||||
Date | Ref CPI | Index Ratio | Principal | Interest | Total Cash Flow | Discounted @ 1.062% YTM |
12/31/13 | 233.56545 | 1.01041 | -1,032.27104 | -0.26717572 | -1,032.53821572 | -1,032.53821572 |
04/15/14 | 234.31967 | 1.01367 | 0.63354375 | 0.63354375 | 0.63161170 | |
10/15/14 | 238.07026 | 1.02989 | 0.64368125 | 0.64368125 | 0.63832998 | |
04/15/15 | 234.18067 | 1.01307 | 0.63316875 | 0.63316875 | 0.62458951 | |
10/15/15 | 238.50135 | 1.03176 | 0.64485000 | 0.64485000 | 0.63275378 | |
04/15/16 | 237.00700 | 1.02529 | 0.64080625 | 0.64080625 | 0.62546587 | |
10/15/16 | 240.74003 | 1.04144 | 0.65090000 | 0.65090000 | 0.63196347 | |
04/15/17 | 243.19553 | 1.05207 | 0.65754375 | 0.65754375 | 0.63504308 | |
10/15/17 | 245.11703 | 1.06038 | 0.66273750 | 0.66273750 | 0.63667956 | |
04/15/18 | 248.39153 | 1.07454 | 1,074.54000 | 0.67158750 | 1,075.21158750 | 1,027.48177926 |
Total | 42.26896 | 5.57164303 | 47.84060303 | 0.00000049 | ||
OID | 64.13000 | |||||
Purchase Premium | -21.86104 |