PLEASE ANSWER ALL QUESTIONS

EXCEL USE ALLOWED

A newly issued bond has a maturity of 10 years and pays a 8.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. (Round your answers to 3 decimal places.) Convexity Duration 58.875 6.590 X years b. Find the actual price of the bond assuming that its yield to maturity immediately increases from 8.4% to 9.4% (with maturity still 10 years). Assume a par value of 100. (Round your answer to 2 decimal places.) Actual price of the bond $ 936.94 X c. What price would be predicted by the modified duration rule 48 = -D * Ay? What is the percentage error of that rule? (Negative answers should be indicated by a minus sign. Round your answers to 2 decimal places.) Percentage price change Percentage error (6.59) (6.59) X % % d. What price would be predicted by the modified duration-with-convexity rule 4 = -D * Ay + 1 x Convexity X (Ay)2 ? What is the percentage error of that rule? (Negative answers should be indicated by a minus sign. Round your answers to 2 decimal places.) Percentage price change Percentage error (6.30) (6.30) % %