You are trying to decide upon the purchase of 30-year bonds that have a coupon rate of

Fantastic news! We've Found the answer you've been seeking!

Question:

You are trying to decide upon the purchase of 30-year bonds that have a coupon rate of 5.45% (interest paid semi-annually). The bonds are currently selling at par. The required rate for these bonds will rise to 7.25% in 5 years. What’s the value of these bonds 5 years from now (i.e., at the end of year 5 or beginning of year 6)? use excel to solve this question