USE EXCEL FUNCTIONS PLEASE

CHAPTER SIXTEEN Convertible Bonds and Convertible Preferred Stock 1. Given the following information concerning a convertible bond: Principal $1,000 Coupon Maturity Call price Conversion price Market price of the common stock Market price of the bond 5% 15 years $1,050 $37 (i.e., 27 shares) $32 $1,040 615 a) What is the current yield of this bond? b) c) What is the value of the bond based on the market price of the common stock? What is the value of the common stock based on the market price of the bond? What is the premium in terms of stock that the investor pays when he or she purchases the convertible bond instead of the stock? d) e) Nonconvertible bonds are selling with a yield to maturity of 7 percent. If this bond lacked the conversion feature, what would the approximate price of the bond be? What is the premium in terms of debt that the investor pays when he or she purchases the convertible bond instead of a nonconvertible bond? f) g) If the price of the common stock should double, would the price of the convert- ible bond double? Briefly explain your answer. h) If the price of the common stock should decline by 50 percent, would the price of the convertible bond decline by the same percentage? Briefly explain your answer. What is the probability that the corporation will call this bond? i) Why are investors willing to pay the premiums mentioned in parts (d) and (f)?

Given the following information concerning a convertible bond: a) What is the current yield of this bond? b) What is the value of the bond based on the market price of the common stock? c) What is the value of the common stock based on the market price of the bond? d) What is the premium in terms of stock that the investor pays when he or she purchases the convertible bond instead of the stock? e) Nonconvertible bonds are selling with a yield to maturity of 7 percent. If this bond lacked the conversion feature, what would the approximate price of the bond be? f) What is the premium in terms of debt that the investor pays when he or she purchases the convertible bond instead of a nonconvertible bond? g) If the price of the common stock should double, would the price of the convertible bond double? Briefly explain your answer. h) If the price of the common stock should decline by 50 percent, would the price of the convertible bond decline by the same percentage? Bricfly explain your answer. 1) What is the probability that the corporation will call this bond? 1) Why are investors willing to pay the premiums mentioned in parts (d) and (f)