Reference no: EM133114713
USING EXCEL
Land'o'Toys is a profitable, medium-sized, retail company. Several years ago it issued a 7 percent coupon bond, which pays interest quarterly. (Par Value is $1,000) The bond will mature in 6 years and is currently priced in the market as $1,039.44. The average yields to maturity for 6-year corporate bonds are reported in the following table by bond rating.
|
Bond Rating
|
Yield
|
|
AAA
|
5.40%
|
|
AA
|
5.70%
|
|
A
|
6%
|
|
BBB
|
6.50%
|
|
BB
|
7.30%
|
|
B
|
8.20%
|
|
CCC
|
9.20%
|
|
CC
|
10.50%
|
|
C
|
12%
|
|
D
|
14.50%
|
Periodically, one company will purchase another by buying all of the target firm's stock. The bonds of the target firm continue to exist. The debt obligation is assumed by the new firm. The credit risk of the bonds often changes because of this type of an event.
Suppose that the firm Treasure Toys makes an announcement that it is purchasing Land'o'Toys. Due to Treasure Toys' projected financial structure after the purchase, Standard & Poor's states that the bond rating for Land'o'Toys bonds will change to BB.
a. Compute the yield to maturity, duration and modified duration of Land'o'Toys bonds before the purchase announcement and find the likely bond rating.
b. Assume the bond's price changes to reflect the new credit rating. What is the new price? Did the price increase or decrease?
c. What is the dollar change and percentage change in the bond price?
d. How do the bond investors feel about the announcement?