12acbf867ee728420f1d8f758dd503cc1cf8da4d.xlsx
Problem 1
N
7
coupon
9%
Price0
$1,240.00
1 yr later:
YTM
7%
PVFA
4.76653965976411
Price1
$1,095.33
cap gain
-11.67% This is the Percent Change in price
cy
7.26%
Total return
-4.41% 1-year return = coupon pmt+price1/Price0-1
Problem 2
Nonconstant growth
0
$1.8000
1
$2.0700
15%
1
$2.0700
$1.82
2
$2.3805
15%
2
$2.3805
$1.83
3
$2.7376
15%
3
$2.7376
$1.85
4
$3.0113
10%
4
$34.3292
$20.33
5
$3.1318
4% constant
$25.82
Terminal
p4
$31.32
r
14%
P0
$25.8209
P1
$27.37
Problem 3
Cap Gains rate= G
DY
6.50% . = D1/ P0
Div Yield = D1/P0
r
15%
r = Div Yield + Cap Gains rate
P3
$85.00
P1=P0 * (1+g)
g
8.50%
P2=P1 * (1+g)
P2
$78.3410
P1
$72.2037
P0
$66.5472
Problem 4
TIPS
coupon
5%
Year
PMT
infl1
6%
1
$50.0000
infl2
3%
2
$1,050.0000
PMT in Y2
$1,146.39
Problem 5
N
10
coupon
9%
YTM
7%
PVFA
7.02
Price 0
$1,140.4716
If YTM is:
8%
9%
11%
PVFA =
6.25
5.53
4.71
Price 1
$1,062.4689
$1,000.0000
$905.7561
return
1.05%
-4.43%
-12.69%
Problem 6
D1
1.2
D1
1.2
DY
6%
Div Yield = D1/P0
P0
$20.0000
Problem 7
Problem 1
. 1 year ago you purchased a 7 year, 9% coupon bond for $1,240.
Today, you sell the bond when the YTM is 7%.
(a) What is your percent capital gain on this investment?
(b) What is the current yield on the bond when you purchase it?
(c) What is your total return on the investment over the year?
BDS Corp. just paid a dividend of $1.80 per share. You expect dividends to grow 15% per year
for the next 3 years, 10% per year the year after that, and then grow at 4% per forever.
(a) If the required return on this stock is 14%, what is the price today?
(b) What is the expected price next year?
You estimate that the growth rate in dividends for a company will be constant for
the foreseeable future. How much should you pay for a share of the stock TODAY if
the dividend yield is 6.50%, the required return is 15%, and you think the stock will
sell for $85 three years from now?
Suppose you purchase a 2 year TIPS bond with a coupon rate of 5%
and a Par value of $1,000. If inflation in the first year is 6% and
inflation in the second year is 3%, how much will the bond pay you in
the second year?
Suppose you buy an 10 year, 9% coupon bond when the YTM is 7%. What is your rate of
return if you sell the bond next year when the YTM is: (a) 8% (b) 9% (c) 11%?
Consider the following stock investment: A stock is expected to pay a
dividend of $1.20 next year, and its dividend yield is 6%. What is the
price of the stock?
The growth rate in the dividend payments of a manufacturing company is constant at -4%
per year (The dividends are getting smaller). The stock just paid a dividend of $4.50 per
share. Investors require a return of 18% to invest in the company.
(a) What is the price of a share of the stock today?
(b) What is the expected price next year?
(c) What is your rate of return for a 1 year investment in this stock?