2% 5-Year Treasury Inflation Protected Security (TIPS) due April 15, 2012
Auction Prices, OID, Cash Flows, & YTM for $1,000 Purchase on 04/30/07 Held to Maturity
Description | Series J-2012 | Dated Date | April 15, 2007 |
CUSIP Number | 912828GN4 | Ref CPI on Dated Date | 202.92140 |
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 |
04/24/07 | 04/30/07 | 203.46290 | 10,123,198 | 99.465161 | 1.00267 | 99.730733 | 2.114 | 4.383 |
10/23/07 | 10/31/07 | 207.92932 | 7,157,942 | 100.194641 | 1.02468 | 102.667445 | 1.954 | 3.968 |
Total Auctioned | 17,281,140 |
OID for Purchase on 04/30/07 | ||||
---|---|---|---|---|
Click Year for Daily Index Ratios | ||||
Year | Date | Ref CPI | Index Ratio | OID per $1,000 |
04/30/07 | 203.46290 | 1.00267 | ||
2007 | 01/01/08 | 208.93600 | 1.02964 | 26.97 |
2008 | 01/01/09 | 216.57300 | 1.06728 | 37.64 |
2009 | 01/01/10 | 216.17700 | 1.06532 | -1.96 |
2010 | 01/01/11 | 218.71100 | 1.07781 | 12.49 |
2011 | 01/01/12 | 226.42100 | 1.11581 | 38.00 |
2012 | 04/15/12 | 227.13073 | 1.11930 | 3.49 |
Total | 116.63 |
Cash Flows per $1,000 Purchased on 04/30/07 | ||||||
---|---|---|---|---|---|---|
Click Year in Date Column for After Market Accrued Interest | ||||||
Date | Ref CPI | Index Ratio | Principal | Interest | Total Cash Flow | Discounted @ 4.383% YTM |
04/30/07 | 203.46290 | 1.00267 | -997.30733 | -0.82186066 | -998.12919066 | -998.12919066 |
10/15/07 | 208.12648 | 1.02565 | 10.25650000 | 10.25650000 | 10.05441503 | |
04/15/08 | 211.36607 | 1.04162 | 10.41620000 | 10.41620000 | 9.99201132 | |
10/15/08 | 219.56748 | 1.08203 | 10.82030000 | 10.82030000 | 10.15708046 | |
04/15/09 | 211.63300 | 1.04293 | 10.42930000 | 10.42930000 | 9.58011526 | |
10/15/09 | 215.56913 | 1.06233 | 10.62330000 | 10.62330000 | 9.54906838 | |
04/15/10 | 216.71220 | 1.06796 | 10.67960000 | 10.67960000 | 9.39382633 | |
10/15/10 | 218.14694 | 1.07503 | 10.75030000 | 10.75030000 | 9.25324599 | |
04/15/11 | 220.72980 | 1.08776 | 10.87760000 | 10.87760000 | 9.16204861 | |
10/15/11 | 226.20335 | 1.11473 | 11.14730000 | 11.14730000 | 9.18787714 | |
04/15/12 | 227.13073 | 1.11930 | 1,119.30000 | 11.19300000 | 1,130.49300000 | 911.79950262 |
Total | 121.99267 | 106.37153934 | 228.36420934 | 0.00000047 | ||
OID | 116.63000 | |||||
Purchase Discount | 5.36267 |