0.125% 5-Year Treasury Inflation Protected Security (TIPS) due April 15, 2017
Auction Prices, OID, Cash Flows, & YTM for $1,000 Purchase on 04/30/12 Held to Maturity
| Description | Series X-2017 | Dated Date | April 15, 2012 |
| CUSIP Number | 912828SQ4 | Ref CPI on Dated Date | 227.13073 |
| 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/19/12 | 04/30/12 | 227.62973 | 16,429,892 | 106.155509 | 1.00220 | 106.389051 | -1.080 | 0.251 |
| 08/23/12 | 08/31/12 | 229.48887 | 14,000,044 | 106.742763 | 1.01038 | 107.850753 | -1.286 | -0.035 |
| 12/20/12 | 12/31/12 | 231.31990 | 14,000,034 | 107.206617 | 1.01844 | 109.183507 | -1.496 | -0.334 |
| Total Auctioned | 44,429,971 | |||||||
| OID for Purchase on 04/30/12 | ||||
|---|---|---|---|---|
| Click Year for Daily Index Ratios | ||||
| Year | Date | Ref CPI | Index Ratio | OID per $1,000 |
| 04/30/12 | 227.62973 | 1.00220 | ||
| 2012 | 01/01/13 | 231.31700 | 1.01843 | 16.23 |
| 2013 | 01/01/14 | 233.54600 | 1.02824 | 9.81 |
| 2014 | 01/01/15 | 237.43300 | 1.04536 | 17.12 |
| 2015 | 01/01/16 | 237.83800 | 1.04714 | 1.78 |
| 2016 | 01/01/17 | 241.72900 | 1.06427 | 17.13 |
| 2017 | 04/15/17 | 243.19553 | 1.07073 | 6.46 |
| Total | 68.53 | |||
| Cash Flows per $1,000 Purchased on 04/30/12 | ||||||
|---|---|---|---|---|---|---|
| Click Year in Date Column for After Market Accrued Interest | ||||||
| Date | Ref CPI | Index Ratio | Principal | Interest | Total Cash Flow | Discounted @ 0.251% YTM |
| 04/30/12 | 227.62973 | 1.00220 | -1,063.89051 | -0.05134221 | -1,063.94185221 | -1,063.94185221 |
| 10/15/12 | 229.67981 | 1.01122 | 0.63201250 | 0.63201250 | 0.63128506 | |
| 04/15/13 | 231.16013 | 1.01774 | 0.63608750 | 0.63608750 | 0.63455883 | |
| 10/15/13 | 233.72290 | 1.02902 | 0.64313750 | 0.64313750 | 0.64078753 | |
| 04/15/14 | 234.31967 | 1.03165 | 0.64478125 | 0.64478125 | 0.64161987 | |
| 10/15/14 | 238.07026 | 1.04816 | 0.65510000 | 0.65510000 | 0.65107075 | |
| 04/15/15 | 234.18067 | 1.03104 | 0.64440000 | 0.64440000 | 0.63963365 | |
| 10/15/15 | 238.50135 | 1.05006 | 0.65628750 | 0.65628750 | 0.65061653 | |
| 04/15/16 | 237.00700 | 1.04348 | 0.65217500 | 0.65217500 | 0.64572900 | |
| 10/15/16 | 240.74003 | 1.05992 | 0.66245000 | 0.66245000 | 0.65508015 | |
| 04/15/17 | 243.19553 | 1.07073 | 1,070.73000 | 0.66920625 | 1,071.39920625 | 1,058.15147160 |
| Total | 6.83949 | 6.44429529 | 13.28378529 | 0.00000076 | ||
| OID | 68.53000 | |||||
| Purchase Premium | -61.69051 | |||||