Sheet1
| | Let Face Value(F) | 1000 |
| | Required yield,r | Price,P(17Year) | Price,P(12 Year) | Price,P(5 Year) |
| | 0 | 1000.00 | 1000 | 1000 |
| | 1 | 741.92 | 861.35 | 905.29 |
| | 2 | 552.07 | 743.01 | 820.35 |
| | 3 | 411.99 | 641.86 | 744.09 |
| | 4 | 308.32 | 555.26 | 675.56 |
| | 5 | 231.38 | 481.02 | 613.91 |
| | 6 | 174.11 | 417.27 | 558.39 |
| | 7 | 131.37 | 362.45 | 508.35 |
| | 8 | 99.38 | 315.24 | 463.19 |
| | 9 | 75.37 | 274.54 | 422.41 |
| | 10 | 57.31 | 239.39 | 385.54 |
| | 11 | 43.68 | 209.00 | 352.18 |
| | 12 | 33.38 | 182.70 | 321.97 |
| | 13 | 25.57 | 159.89 | 294.59 |
| | 14 | 19.63 | 140.10 | 269.74 |
| | 15 | 15.10 | 122.89 | 247.18 |
| | 16 | 11.65 | 107.93 | 226.68 |
| | 17 | 9.00 | 94.89 | 208.04 |
17Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 1000 741.92291778712388 552.07088897991196 411.9867595159069 308.3186679734203 231.37744865585813 174.11013091063427 131.36711715458981 99.377332549801224 75.371136128043148 57.308553301167962 43.682816918726573 33.377923879916558 25.565052886950578 19.6270242881541 15.103054493884668 11.648240347074143 9.0037649234647326 12 year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 1000 861.34947482837902 743.01472998851932 641.86194739671771 555.26450271327485 481.01709809097019 417.26506073554037 362.44601964235966 315.24170496588994 274.53804131311779 239.3920493691634 209.00434665031869 182.69626126419928 159.89075297511917 140.0964820691587 122.89448520533649 107.92701398201538 94.888170619233321