LandoToys 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 firms 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 LandoToys. Due to Treasure Toys projected financial structure after the purchase, Standard & Poors states that the bond rating for LandoToys bonds will change to BB.

a. Compute the yield to maturity, duration and modified duration of LandoToys bonds before the purchase announcement and find the likely bond rating.

b. Assume the bonds 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. d. How do the bond investors feel about the announcement?

Please use excel to finished it !! and please provide formulas in the excel sheet thanks!