PLEASE PROVIDE STEP-BY-STEP DETAILS TO SOLVE USING EXCEL

Consider a 20-year bond issued three years back. Coupons are paid semiannually. The coupon rate is 5.73%, the YTM is 6.25% and the par value is $1,000. Compute Macaulay's Duration and Modified Duration for this bond using the Excel PV function. Verify your computations using the Excel formulae for Macaulay's Duration and Modified Duration. Next, compute the Convexity of this bond.

ABC fx , Insert Page Layout Formulas Data Review View A4 X fx A B D E F G H 1 Consider a 20-year bond issued three years back. Coupons are paid semiannually. The coupon rate is 5.73%, the YTM is 6.25% and the par value is $1,000. Compute Macaulay's Duration and Modified Duration for this bond using the Excel PV function. Verify your computations using 2 the Excel formulae for Macaulay's Duration and Modified Duration. Next, compute the Convexity of this bond. 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 DAD Home Ready Duration and Convexity Drill + I O J K O O O L M N Duration and Convexity Class Drill (1) O P Q R S Q Search Sheet T U V W + Share X + 100% ABC fx , Insert Page Layout Formulas Data Review View A4 X fx A B D E F G H 1 Consider a 20-year bond issued three years back. Coupons are paid semiannually. The coupon rate is 5.73%, the YTM is 6.25% and the par value is $1,000. Compute Macaulay's Duration and Modified Duration for this bond using the Excel PV function. Verify your computations using 2 the Excel formulae for Macaulay's Duration and Modified Duration. Next, compute the Convexity of this bond. 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 DAD Home Ready Duration and Convexity Drill + I O J K O O O L M N Duration and Convexity Class Drill (1) O P Q R S Q Search Sheet T U V W + Share X + 100%