Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
1
2
3
4
5
6
7
8
9
10
11
12
13
14
26
27
28
29
30
31
32
33
34
35
36
37
38
59
60
61
62
63
64
65
66
67
68
A B C D E F G H I J K L M N O P Q R S T
12/9/2012
Situation
Finding the "Fair Value" of a Bond
First, we list the key features of the bond as "model inputs":
Years to Mat: 10
Coupon rate: 10%
Annual Pmt: $100
Par value = FV: $1,000
Going rate, rd:10%
Value of bond = $1,000.00
complete the operation and get the table.
Chapter 5. Mini Case
Sam Strother and Shawna Tibbs are vice-presidents of Mutual of Seattle Insurance Company and co-directors of the
company's pension fund management division. A major new client, the Northwestern Municipal Alliance, has
requested that Mutual of Seattle present an investment seminar to the mayors of the represented cities, and Strother
and Tibbs, who will make the actual presentation, have asked you to help them by answering the following
questions. Because the Boeing Company operates in one of the league's cities, you are to work Boeing into the
presentation.
a. What are the key features of a bond? Answer: See Chapter 5 Mini Case Show
d. How is the value of a bond determined? What is the value of a 10-year, $1,000 par value bond with a 10 percent
annual coupon if its required rate of return is 10 percent?
Thus, this bond sells at its par value. That situation always exists if the going rate is
equal to the coupon rate.
The PV function can only be used if the payments are constant, but that is normally the case for bonds.
b. What are call provisions and sinking fund provisions? Do these provisions make bonds more or less risky?
e. (1.) What would be the value of the bond described in Part d if, just after it had been issued, the expected inflation
rate rose by 3 percentage points, causing investors to require a 13 percent return? Would we now have a discount
or a premium bond?
We could simply go to the input data section shown above, change the value for r from 10% to 13%. You can set up a
79
80
81
82
83
84
85
86
A B C D E F G H I J K L M N O P Q R S T
To make the data table, first type the headings, then type the rates in
cells in the left column. Since the input values are listed down a column,
type the formula in the row above the first value and one cell to the right
of the column of values (this is B73; note that the formula in B73 actually
just refers to the bond pricing formula above in B60). Select the range of
cells that contains the formulas and values you want to substitute
(A73:B78). Then click Data, What-If-Analysis, and then Data Table to get
the menu. The input data are in a column, so put the cursor on "column
input cell" and enter the cell with the value for r (B37), then Click OK to
complete the operation and get the table.
We can use the data table to construct a graph that
shows the bond's sensitivity to changing rates.
$2,500
Interest Rate Sensitivity of a 10-Year Bond
Value at 7%
Value at 13%
99
100
101
102
103
104
112
113
114
115
116
117
118
119
120
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
156
157
158
159
160
161
162
163
164
165
A B C D E F G H I J K L M N O P Q R S T
N7% 10% 13%
0$1,211 $1,000 $837
1$1,195 $1,000 $846
2$1,179 $1,000 $856
3$1,162 $1,000 $867
You pick the rate for a bond:
Your choice:
20%
Resulting bond prices
$581
$597
$616
Yield to Maturity (YTM)
Use the Rate function to solve the problem.
Years to Mat: 10
Coupon rate: 9%
Current and Capital Gains Yields
Par value $1,000.00
Coupon rate: 9%
Current Yield =
10.15%
f. (1.) What is the yield to maturity on a 10-year, 9 percent annual coupon, $1,000 par value bond that sells for
$887.00? That sells for $1,134.20? What does the fact that a bond sells at a discount or at a premium tell you about
the relationship between rd and the bond's coupon rate? What is the yield-to-maturity of the bond?
The current yield is the annual interest payment divided by the bond's current price. The current yield provides
information regarding the amount of cash income that a bond will generate in a given year. However, it does not
account for any capital gains or losses that will be realized if the bond is held to maturity or call.
Simply divide the annual interest payment by the price of the bond. Even if the bond made semiannual payments,
we would still use the annual interest.
If rates fall, the bond goes to a premium, but it moves towards par as maturity approaches. The reverse hold if rates
rise and the bond sells at a discount. If the going rate remains equal to the coupon rate, the bond will continue to
sell at par. Note that the above graph assumes that interest rates stay constant after the initial change. That is most
unlikely--interest rates fluctuate, and so do the prices of outstanding bonds.
Value of Bond in Given Year:
$1,000
$1,200
$1,400
Value of the bond over time Rates fall to 7%
Rates stay the same
Rates increase to 13%
Your choice
180
181
182
183
184
185
186
187
201
202
203
204
205
206
207
208
209
210
211
212
213
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
A B C D E F G H I J K L M N O P Q R S T
Capital Gains Yield = 0.76%
Bonds with Semiannual Coupons
Excel Bond Functions
Suppose today's date is January 1, 2014, and the bond matures on December 31, 2023
Settlement (today) 1/1/2014
Maturity 12/31/2023
Coupon rate 10.00%
Going rate, r 13.00%
Redemption (par value) 100
Frequency (for semiannual) 2
Basis (360 or 365 day year) 0
Basis (360 or 365 day year) 0
Value of bond = $83.6307 or $836.31
Issue date 1/1/2014
First interest date 6/30/2014
Settlement (today) 3/25/2014
Maturity 12/31/2023
Coupon rate 10.00%
Going rate, r 13.00%
Redemption (par value) 100
Frequency (for semiannual) 2
Basis (360 or 365 day year) 0
This is the value of the bond, but it does not include the accrued interest you would pay. The ACCRINT function will
calculate accrued interest, as shown below.
g. How does the equation for valuing a bond change if semiannual payments are made? Find the value of a 10-year,
semiannual payment, 10 percent coupon bond if nominal rd = 13%.
260
261
262
263
264
265
266
267
268
269
280
281
282
283
284
285
286
287
288
289
290
291
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
A B C D E F G H I J K L M N O P Q R S T
Yield to Call
Your Choice of Maturity
Years to Mat: 10 Rate Price Rate Price Rate Price
Coupon rate: 10% $966.65 $946.77 $991.88
Annual Pmt: $100.00 5.0% 1,216.47 5.0% $1,386.09 5.0% $1,047.62
Current price: $946.77 7.0% 1,123.01 7.0% $1,210.71 7.0% $1,028.04
Par value = FV: $1,000.00 10.0% 1,000.00 10.0% $1,000.00 10.0% $1,000.00
YTM = 10.9% 13.0% 894.48 13.0% $837.21 13.0% $973.45
15.0% 832.39 15.0% $749.06 15.0% $956.52
Years to Mat: 1Scratch sheet for Your Choice
Coupon rate: 10% Years to Mat: 5
Annual Pmt: $100.00 Coupon rate: 10%
Current price: $991.88 Annual Pmt: $100.00
Par value = FV: $1,000.00
Current price:
$966.65
YTM = 10.9%
Par value = FV:
$1,000.00
the same maturity, the one with the smaller coupon payment will have more interest rate sensitivity.
h. Suppose a 10-year, 10 percent, semiannual coupon bond with a par value of $1,000 is currently selling for
$1,135.90, producing a nominal yield to maturity of 8 percent. However, the bond can be called after 5 years for a
price of $1,050.
(1.) What is the bond's nominal yield to call (YTC)?
(2.) If you bought this bond, do you think you would be more likely to earn the YTM or the YTC? Why?
k. Describe a way to estimate the inflation premium (IP) for a T-Year bond. Answer: See Chapter 5 Mini Case Show.
1-Yr Maturity
10-Yr Maturity
The yield to call is the rate of return investors will receive if their bonds are called. If the issuer has the right to call
the bonds, and if interest rates fall, then it would be logical for the issuer to call the bonds and replace them with
new bonds that carry a lower coupon. The yield to call (YTC) is found similarly to the YTM. The same formula is
used, but years to maturity is replaced with years to call, and the maturity value is replaced with the call price.
i. Write a general expression for the yield on any debt security (rd) and define these terms: real risk-free rate of
interest (r*), inflation premium (IP), default risk premium (DRP), liquidity premium (LP), and maturity risk premium
(MRP). Answer: See Chapter 5 Mini Case Show.
j. Define the nominal risk-free rate (rRF). What security can be used as an estimate of rRF? Answer: See Chapter 5
Mini Case Show.
$1,300.00
$1,400.00
$1,500.00
10 Yr. versus 1 Yr.
Your Choice
340
341
342
343
344
345
346
347
348
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
387
388
389
390
391
392
393
394
395
4.8% 38.6%
10.0% $1,000 $1,000
4.5% 33.5%
15.0% $957 $749
Hypothetical Inputs See to right for actual date used in graph.
Real risk free rate 3.00%
Expected inflation of 5% for the next 1 years.
Expected inflation of 6% for the next 1 years.
Expected inflation of 8% thereafter.
Now, we want to set up a table that encompasses all of the information for our yield curve.
INPUT DATA
Real risk free rate 3.00%
Expected inflation of 5% for the next 1 years.
Expected inflation of 6% for the next 1 years.
Expected inflation of 8% thereafter.
12 3.00% 7.58% 1.10% 11.68%
13 3.00% 7.62% 1.20% 11.82%
The yield is upward sloping due to increasing expected inflation and an increasing maturity risk premium 14 3.00% 7.64% 1.30% 11.94%
15 3.00% 7.67% 1.40% 12.07%
16 3.00% 7.69% 1.50% 12.19%
17 3.00% 7.71% 1.60% 12.31%
18 3.00% 7.72% 1.70% 12.42%
19 3.00% 7.74% 1.80% 12.54%
20 3.00% 7.75% 1.90% 12.65%
Suppose most investors expect the inflation rate to be 5 percent next year, 6 percent the following year, and 8 percent thereafter. The
real risk-free rate is 3 percent. The maturity risk premium is zero for securities that mature in 1 year or less, 0.1 percent for 2-year
securities, and then the MRP increases by 0.1 percent per year thereafter for 20 years, after which it is stable. What is the interest
rate on 1-year, 10-year, and 20-year Treasury securities? Draw a yield curve with these data. What factors can explain why this
constructed yield curve is upward sloping?
n. What is reinvestment rate risk? Which has more reinvestment rate risk, a 1-year bond or a 10-year bond?
Answer: See Chapter 5 Mini Case Show.
q. Briefly describe bankruptcy law. If a firm were to default on the bonds, would the company be immediately
liquidated? Would the bondholders be assured of receiving all of their promised payments? Answer: See Chapter 5
Mini Case Show.
10.00%
12.00%
14.00%
Hypothetical Treasury Yield Curve
MRP
