You own two bonds. Bond A is a 5% semi annual coupon bond with a face value of $1000 and has 5 years to maturity. Its current market yield is 7%. Bond B is a 3% semi annual coupon bond with a face value of $1000 and 10 years to maturity. It has a current market yield of 2%. A. Calculate the price of each of these bonds on the coupon payment dates over the next 5 years. Use a line graph to present your results. (10 Marks) B. Now imagine that after 3 years the yield on both bonds increases by 2%. Redo all calculations form A as well as the line graph. Which bond experienced a bigger change in value due to the yield change?

B. Now imagine that after 3 years the yield on both bonds increases by 2%. Redo all calculations form A as well as the line graph. Which bond experienced a bigger change in value due to the yield change?

please show all the working in excel thanks