A japanese comapny 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?

Settlement date = 1/1/2000

Maturity date = 1/1/2016

Annual coupon rate = 3.4%

Coupons per year = 1

Face value (% of par) = 100

Bond price (% of par) = 91.530

Face value = 100,000

Please answer in exel format: =Yeild(settlement, matruity, rate, pr, redemption, frequency)