excel formula please!!!!

onces 2 3 A Japanese company has a bond outstanding that sells for 91.53 percent of its $100,000 par value. The bond has a coupon rate of 3.4 percent paid annually and matures in 16 years. What is the yield to maturity of this bond? 4 $ 6 1/1/2000 1/1/2016 3.4% 7 8 1 Settlement date Maturity date Annual coupon rate Coupons per year Face value (% of par) Bond price (% of par) Face value 9 10 11 12 13 100 91.530 V 100.000 14 Complete the following analysis. Do not hard code values in your calculations. Iasva the "Raele Innu hande in the function Vous mettre the hun Erral 15 8 1/1/2016 3.4% 9 Maturity date Annual coupon rate Coupons per year Face value (% of par) Bond price (% of par) Face value 1 10 11 12 13 14 100 91.530 100,000 15 Complete the following analysis. Do not hard code values in your calculations. Leave the "Basis" input blank in the function. You must use the built-in Excel function to answer this question. 16 17 Yield to maturity 18