A Japanese company has a bond outstanding that sells for 96.318 percent ¥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? Input area: 5 Settlement date 7 Maturity date 8 Annual coupon rate 9 Coupons per year 10 Redemption value (% of par) 11 Bond price (% of par) 12 1/1/2020 1/1/2036 3.40% 1 100 96.318 13 (Use cells A6 to B11 from the given information to complete this question. You must use the built- 14 answer this question. Leave the "Basis" input blank in the function.) 15 16 Output area: 17 18 Yield to maturity 19

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter8: Analysis Of Risk And Return
Section: Chapter Questions
Problem 9P
icon
Related questions
Question
need formula in excel
A Japanese company has a bond outstanding that sells for 96.318 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?
3
4 Input area:
5
6 Settlement date
7
Maturity date
8
Annual coupon rate
9 Coupons per year
10 Redemption value (% of par)
1/1/2020
1/1/2036
3.40%
1
100
96.318
O
11 Bond price (% of par)
12
13 (Use cells A6 to B11 from the given information to complete this question. You must use the built-in Excel funct
14 answer this question. Leave the "Basis" input blank in the function.)
15
16 Output area:
17
18 Yield to maturity
19
20
Transcribed Image Text:A Japanese company has a bond outstanding that sells for 96.318 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? 3 4 Input area: 5 6 Settlement date 7 Maturity date 8 Annual coupon rate 9 Coupons per year 10 Redemption value (% of par) 1/1/2020 1/1/2036 3.40% 1 100 96.318 O 11 Bond price (% of par) 12 13 (Use cells A6 to B11 from the given information to complete this question. You must use the built-in Excel funct 14 answer this question. Leave the "Basis" input blank in the function.) 15 16 Output area: 17 18 Yield to maturity 19 20
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Bond Valuation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT