USE THE EXCEL YIELD FUNCTION (PLEASE SHOW EXCEL FUNCTIONS)

PIVIL II VJLI UL L UIVVI ULOJ UNIN IL VIL VV wiyar11 Arial E- Paste B I U A- A Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard Font D17 A B C D E F G H I J K | 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? 1/1/2000 1/1/2016 3.4% Settlement date Maturity date Annual coupon rate Coupons per year Face value (% of par) Bond price (% of par) Face value 100 91.530 100,000 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 ... Sheet1 ... + @ U -- + READY Attempt(s) 100% Hint 3/3