A $1,000 maturity value bond currently has 15 years left to maturity. The bond has an 8.5% coupon rate and pays interest annually.

a. If you want to earn a 7% rate of return, how much would you be willing

to pay today for this bond?

b. Suppose you buy the bond for the value you calculated in part a. After

holding the bond for 2 years and receiving 2 interest payments, you sell the bond for $1,032.43. What annual, compound rate of return have you earned over this 2

year period?

Please show/explain using excel