A 20-year, 6% quarterly coupon bond with a par value of $10,000 may be called in 5 years at a call price of $10,200. The bond sells for $10.500. (Assume that the bond has just been issued.) Basic Input Data: Years to maturity:

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question
9
10
11 Periods per year:
12 Periods to maturity:
13 Coupon rate:
14 Par value:
15 Periodic payment
16 Current price
17 Call price:
18 Years till callable:
19 Periods till callable:
Paste
F17
888588RFN
66
Basic Input Data:
Years to maturity:
67
68
A
E
G
H
6 A 20-year, 6% quarterly coupon bond with a par value of $10,000 may be called in 5 years at a call price of $10,200. The bond
7 sells for $10.500. (Assume that the bond has just been issued.).
8
69
70
20
21 a. What is the bond's yield to maturity?
22
23
24
25
26
27 b. What is the bond's current yield?
28
29
30
31
32
33
34 c. What is the bond's capital gain or loss yield?
35
36
37
38
39
40 Note that this is an economic loss, not a loss for tax purposes.
41
71
42 d. What is the bond's yield to call?
43
72
X
B
Cap. Gain/loss yield =
Cap. Gain/loss yield =
Cap. Gain/loss yield =
Arial
Current yield =
Current yield
Current yield =
BIU E
Rate, r
✓
53 NOW ANSWER THE FOLLOWING NEW QUESTIONS:
54
Ready
▸
Peridodic YTM=
Annualized Nominal YTM
0%
1%
3%
Š
fix
Peridodic YTC =
Annualized Nominal YTC
D
44 Here we can again use the Rate function, but with data related to the call.
45
46
47
This is a nominal rate, not the effective rate. Nominal rates are generally quoted.
48
49 The YTC is lower than the YTM because if the bond is called, the buyer will lose the difference between the call price and the current
50 price in just 4 years, and that loss will offset much of the interest imcome. Note too that the bond is likely to be called and replaced,
51 hence that the YTC will probably be earned.
52
Value of Bond If:
Not called
$0.00
Called
$0.00
1
55 e. How would the price of the bond be affected by changing the going market interest rate? Assume Norminal Market rate
56 is 6%. (Hint: Conduct a sensitivity analysis of price to changes in the going market interest rate for the bond. Assume that
57 the bond will be called if and only if the going rate of interest falls below the coupon rate. That is an oversimplification, but
58 assume it anyway for purposes of this problem.)
59
60 Nominal market rate, r
61 Value of bond if it's not called:
62 Value of bond if it's called:
63
Build a Model
64 We can use the two valuation formulas to find values under different r's, in a 2-output data table, and then use an IF
65 statement to determine which value is appropriate:
>
0%
10
V
Actual value,
considering
call likehood:
+
Accessibility: Investigate
A A
A
F
|||
Hint: Write formula in words.
Hint: Cell formulas should refer to Input Section
(Answer)
Hint: Write formula in words.
Hint: Cell formulas should refer to Input Section
(Answer)
Hint: This is a nominal rate, not the effective rate. Nominal rates are generally quoted.
I
The bond would not be called unless r<coupon.
81
K
Transcribed Image Text:9 10 11 Periods per year: 12 Periods to maturity: 13 Coupon rate: 14 Par value: 15 Periodic payment 16 Current price 17 Call price: 18 Years till callable: 19 Periods till callable: Paste F17 888588RFN 66 Basic Input Data: Years to maturity: 67 68 A E G H 6 A 20-year, 6% quarterly coupon bond with a par value of $10,000 may be called in 5 years at a call price of $10,200. The bond 7 sells for $10.500. (Assume that the bond has just been issued.). 8 69 70 20 21 a. What is the bond's yield to maturity? 22 23 24 25 26 27 b. What is the bond's current yield? 28 29 30 31 32 33 34 c. What is the bond's capital gain or loss yield? 35 36 37 38 39 40 Note that this is an economic loss, not a loss for tax purposes. 41 71 42 d. What is the bond's yield to call? 43 72 X B Cap. Gain/loss yield = Cap. Gain/loss yield = Cap. Gain/loss yield = Arial Current yield = Current yield Current yield = BIU E Rate, r ✓ 53 NOW ANSWER THE FOLLOWING NEW QUESTIONS: 54 Ready ▸ Peridodic YTM= Annualized Nominal YTM 0% 1% 3% Š fix Peridodic YTC = Annualized Nominal YTC D 44 Here we can again use the Rate function, but with data related to the call. 45 46 47 This is a nominal rate, not the effective rate. Nominal rates are generally quoted. 48 49 The YTC is lower than the YTM because if the bond is called, the buyer will lose the difference between the call price and the current 50 price in just 4 years, and that loss will offset much of the interest imcome. Note too that the bond is likely to be called and replaced, 51 hence that the YTC will probably be earned. 52 Value of Bond If: Not called $0.00 Called $0.00 1 55 e. How would the price of the bond be affected by changing the going market interest rate? Assume Norminal Market rate 56 is 6%. (Hint: Conduct a sensitivity analysis of price to changes in the going market interest rate for the bond. Assume that 57 the bond will be called if and only if the going rate of interest falls below the coupon rate. That is an oversimplification, but 58 assume it anyway for purposes of this problem.) 59 60 Nominal market rate, r 61 Value of bond if it's not called: 62 Value of bond if it's called: 63 Build a Model 64 We can use the two valuation formulas to find values under different r's, in a 2-output data table, and then use an IF 65 statement to determine which value is appropriate: > 0% 10 V Actual value, considering call likehood: + Accessibility: Investigate A A A F ||| Hint: Write formula in words. Hint: Cell formulas should refer to Input Section (Answer) Hint: Write formula in words. Hint: Cell formulas should refer to Input Section (Answer) Hint: This is a nominal rate, not the effective rate. Nominal rates are generally quoted. I The bond would not be called unless r<coupon. 81 K
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Rate Of Return
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
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education