| Bond Forward Rate |
|
|
|
|
| Copyright: Explore Bonds |
|
|
|
|
| |
|
|
|
|
|
| This spreadsheet calculates the forward rate between several bonds. |
|
|
| For more information, see |
|
|
|
|
| Which TIPS to Buy On the Secondary Market |
|
|
|
| |
|
|
|
|
|
| |
Maturity Date |
Yield |
Maturity Years |
Forward Rate |
|
| Bond 1 |
01/15/2015 |
0.91% |
5.2 |
|
|
| Bond 2 |
01/15/2016 |
1.09% |
6.2 |
2.06% |
|
| Bond 3 |
01/15/2017 |
1.20% |
7.2 |
1.86% |
|
| Bond 4 |
01/15/2018 |
1.28% |
8.2 |
1.84% |
|
| Bond 5 |
01/15/2019 |
1.34% |
9.2 |
1.89% |
|
| |
|
|
|
|
|
| Cells in blue are input cells. Feel free to overwrite with your own data. |
|
|
| |
|
|
|
|
|
|