CAN YOU PLEASE SHOW INSTRUCTION IN EXCEL

A B E F G H 1 J K L M N 0 Bond # Price Maturity (years) 1 2 3 4 Find the zero rates for the given maturoties in the data. 5 6 7 1 91.8967 2 83.2564 3 76.0000 4 76.2347 5 71.2110 6 67.9672 7 66.0000 8 66.1625 9 65.4881 10 65.7003 11 64.0000 12 66.6158 13 68.0989 8 D Annual coupon rate 2.0% 2.5% 3.0% 3.2% 3.5% 4.0% 4.5% 4.2% 5.0% 5.5% 5.8% 6.0% 6.5% 1 2 2 2 3 4 5 6 6 7 8 8 9 9 9 10 11 12 13 14 15 16 A B E F G H 1 J K L M N 0 Bond # Price Maturity (years) 1 2 3 4 Find the zero rates for the given maturoties in the data. 5 6 7 1 91.8967 2 83.2564 3 76.0000 4 76.2347 5 71.2110 6 67.9672 7 66.0000 8 66.1625 9 65.4881 10 65.7003 11 64.0000 12 66.6158 13 68.0989 8 D Annual coupon rate 2.0% 2.5% 3.0% 3.2% 3.5% 4.0% 4.5% 4.2% 5.0% 5.5% 5.8% 6.0% 6.5% 1 2 2 2 3 4 5 6 6 7 8 8 9 9 9 10 11 12 13 14 15 16