Please solve for required in images. Show work. Using Excel for the answer would be preferred.

Problem 16-16 A 30-year maturity bond making annual coupon payments with a coupon rate of 9.5% has duration of 13.53 years and convexity of 258.03. The bond currently sells at a yield to maturity of 6%. a. Find the price of the bond if its yield to maturity falls to 5%. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Price of the bond b. What price would be predicted by the duration rule? (Do not round intermediate calculations. Round your answers to 2 decimal places.) Predicted new price (duration rule) c. What price would be predicted by the duration-with-convexity rule? (Do not round intermediate calculations. Round your answers to 2 decimal places.) Predicted new price (duration-with-convexity rule) d-1. What is the percent error for each rule? (Negative answers should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.) Duration Rule Duration-with- Convexity Rule Percentage error e-1. Find the price of the bond if its yield to maturity increases to 7%. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Price of the bond e-2. What price would be predicted by the duration rule? (Do not round intermediate calculations. Round your answers to 2 decimal places.) Predicted new price (duration rule) e-3. What price would be predicted by the duration-with-convexity rule? (Do not round intermediate calculations. Round your answers to 2 decimal places.) Predicted new price (duration-with-convexity rule) e-4. What is the percent error for each rule? (Negative answers should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to 2 decimal places.) Duration Rule Duration-with- Convexity Rule Percentage error