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?

C.) 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. What price must you receive (at time 2) to earn your desired 7% rate of return?

D.) Suppose you buy the bond for the value you calculated in part a. After holding the bond for 3 years and receiving 3 interest payments, the bond defaults with no chance of paying you anything more. What annual, compound rate of return have you earned over this 3 year period?

Please showing using excel function/formulas