PLEASE SOLVE IN EXCEL WITH FORMULAS

Consider the following two semi-annual coupon payment bonds: Bond A - Term to maturity: 10 years from 7/1/2023 (issuance date) - Face value: $1,000 - Coupon rate: 6% - Coupon paid at 1/1 and 7/1 each year Bond B - Term to maturity: 20 years from 7/1/2023 (issuance date) - Face value: $1,000 - Coupon rate: 6% - Coupon paid at 1/1 and 7/1 each year Today's date is 11/1/2023. 1) Assume the market rate is 5%. What is the price of each bond today? 2) Make a data table showing the bond price when the market rate changes from 0%, 1%,,20%. 3) Which bond's price is more sensitive to changes in the market interest rate? Using a graph to explain