Answer must be using excel formula

F18 1 NP 2 3 4 5 6 7 8 00 9 10 11 NP 12 13 14 15 16 17 18 19 A READY Attempt(s) B X fx Settlement date Maturity date Annual coupon rate Sheet1 Coupons per year Face value (% of par) Bond price (% of par) Face value D 1/1/2000 1/1/2016 3.4% 1 100 E 91.530 100,000 F G 1 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? H 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. Yield to maturity I 8 J EI K + Hint }