Please show how to solve/formulas in excel, thank you so much!!!

Paste B I A1 x fc 8.18 Interest Rate Risk Laurel, Inc., and Hardy Corp. both have 6.5 percent coupon bonds outstanding, with semiar 8.18 Interest Rate Risk Laurel, Inc., and Hardy Corp. both have 6.5 percent coupon bonds outstanding, with semiannual interest payments, and both are priced at par value. The Laurel, Inc., bond has 3 years to maturity whereas the Hardy Corp. bond has 20 years to maturity. If interest rates suddenly rise by 2 percent, what is the percentage change in the price of these bonds? If interest rates were to suddenly fall by 2 percent instead, what would the percentage change in the price of these bonds be then? Illustrate your answers by graphing bond prices 1 versus YTM. What does this problem tell you about the interest rate risk of longer-term bonds? Laurel, Inc. Hardy Corp 4 Face Value Coupon Rate YTM Coupon Frequency Face Value Coupon Rate YTM Coupon Frequency Yield to Maturity Price Yield to Maturity Price 10 12 13