please attach excel formulas

- PART Ving Securities a. Assume the market interest rate is 6%. What is the price of a bond? b. Make a table comparing the bond prices when the market interest varies from 0%, 1%, ..., 5%, 6%..... 20%. Use the template below which may be found on the companion website. Make sure that when the market interest rate is 5%, both bonds are valued at $1,000. c. Can you conclude that "the longer-term bond's price is more sensi tive to changes in the market interest rate?"" Explain using a graph. A B C 2 3 Coupon rate 4 Maturity 5 Face value 6% Bond A 5% 10 1,000.00 D COMPARING TWO BONDS Section a, Market interest rate Price of Bond A Price of Bond B Bond B 5% 20 1.000.00 Year - Section b. Effect of market interest rate on bond prices Interest rate Bond A price Bond B price 0% 1% 2% 3% 4% N 5% 6% 7% Bond A Bond B 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 1,050.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 50.00 1,050.00 8% 9% 16 10% 11% 12% 14% 16% 18% 20% 17 18 20