| TIPS Pricing Calculation - Reopening |
| Copyright: Explore Bonds |
|
|
| |
|
|
| This spreadsheet calculates TIPS pricing at auction. See blog post below for more info. Cells in blue are data inputs. Other cells are calculated. |
| TIPS Auction Step By Step: (2) Read the Announcement |
|
| |
|
|
| This worksheet calculates pricing for reopenings. Click on the New Issue tab at the bottom for new issues. |
| Gather input data from auction announcements at |
| http://treasurydirect.gov/instit/annceresult/press/press_secannpr.htm |
| |
|
|
| From Auction Announcement |
|
|
| Issue Date |
7/31/2009 |
|
| Maturity Date |
1/15/2029 |
|
| Dated Date |
7/15/2009 |
|
| Interest Rate |
2.500% |
|
| Index Ratio |
0.99598 |
|
| |
|
|
| Your Own Estimate |
|
|
| Yield Estimate (i) |
2.360% |
|
| |
|
|
| Calculated Fields |
|
|
| Next Interest Date |
1/15/2010 |
|
| Days until next interest (r) |
168 |
|
| Days in semiannual period (s) |
184 |
|
| Coupon per $100 (C) |
2.5 |
|
| Number of Full Coupon Period (n) |
38 |
|
| Price + Accrued Interest |
102.281675 |
|
| Adjusted Price + Accrued Interest |
101.870503 |
|
| Per Bond |
$1,018.71 |
|
| |
|
|