please solve using excel

A newly issued bond has a maturity of 10 years and pays a 6.4% coupon rate (with coupon payments coming once annually). The bond sells at par value. a. What are the convexity and the duration of the bond? Use the formula for convexity in footnote 7. b. Find the actual price of the bond assuming that its yield to maturity immediately increases from 6.4% to 7.4% (with maturity still 10 years). Assume a par value of 100. c. What price would be predicted by the modified duration rule PP=Dy ? What is the percentage error of that rule? d. What price would be predicted by the modified duration-with-convexity rule PP=Dy+21 Convexity (y)2 ? What is the percentage error of that rule? Find the actual price of the bond assuming that its yield to maturity immediately increases from {{6.4:#,###.0}}% to {{7.4:#,###.0}}% (with maturity still 10 years). Assume a par value of 100. (Round your answer to 2 decimal places.)