Suppose you purchase $1000 face-value of each of the following two bonds.

Bond A: 3% Coupon rate, Treasury Bond, with semi-annual coupon payments, 30-year maturity and yield to maturity 4% quoted as an APR with semi-annual compounding.

Bond B: Ford Motor 6% Coupon, with semi-annual coupon payments, 10-year maturity and a spread of 2% over the 30-year Treasury Bond yield, quoted as an APR with semi-annual compounding.

1. Compute the price of Bond A and Bond B.

2. Draw a graph that illustrates how the price of each of the bonds will change until maturity assuming no change in their yields to maturity.

3. If the yield to maturity of both bonds increase by 1% right after the purchase, by what percentage do Bond A and Bond B prices change? Which bond price is more sensitive to interest rate changes and why?

Please show work and calculations. I am trying to learn the material and I am struggling, I cannot learn if one just uses excel. Thank you for your help!