In: Finance
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)