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

A.)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?

B.)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 bonddefaults with no chance of paying you anything more.What annual, compound rate of return have you earned over this 3 year period?

Please show/explain using excel