All payments occur at the end of the period unless stated otherwise.
Interest is compounded annually unless stated otherwise.
Face value of all bonds is $1000.
Starbucks has one debt issue outstanding. The debt matures on August 15, 2017, and has a 6.25% coupon. Coupons are paid semiannually. The bond is priced to yield 1.61% compound semiannually. The bond has a face value of $1000.
a. Estimate the price of the bond on February 15, 2013, immediately after that coupon is paid.
b. You buy the bond on February 15, 2013 for your estimated price from part a. You sell the bond 1 year later for $1160. What was your return? Why is it different from the original yield to maturity? Assume you collect 2 coupon payments.© BrainMass Inc. brainmass.com October 25, 2018, 7:37 am ad1c9bdddf
Please refer attached file for better understanding of formulas in MS Excel.
Position at February 15, 2013
Face Value of bond=FV=$1,000
Coupon Payment=PMT=1000*6.25%/2=$31.25 Per semi annual
Number of coupon Payments ...
Solution describes the steps to calculate the current price and return of the given investment. Calculations are carried out with the help of suitable built-in functions in MS Excel.
Rates of Return on Convertible Bond Investments
Fondren Exploration, Ltd., has 1,000 convertible bonds ($1,000 par value) outstanding, each of which may be converted to 50 shares. The $1 million worth of bonds has 25 years to maturity. The current price of the stock is $26 per share. The firm's net income in the most recent fiscal year was $270,000. The bonds pay 12 percent interest. The corporation has 150,000 shares of common stock outstanding. Current market rates on long-term nonconvertible bonds of equal quality are 14 percent. A 35 percent tax rate is assumed.
a.Compute diluted earnings per share.
b.Assume the bonds currently sell at a 5 percent conversion premium over conversion value (based on a stock price of $26). However, as the price of the stock increases from $26 to $37 due to new events, there will be an increase in the bond price, and a zero conversion premium. Under these circumstances, determine the rate of return on a convertible bond investment that is part of this price change, based on the appreciation in value.
c.Now assume the stock price is $16 per share because a competitor introduced a new product. Would the conversion value be greater than the pure bond value, based on the interest rates stated above? (See Table 16-3 in Chapter 16 to get the bond value without having to go through the actual computation.)
d.Referring to part c, if the convertible traded at a 15 percent premium over the conversion value, would the convertible be priced above the pure bond value?
e. If long-term interest rates in the market go down to 10 percent while the stock price is at $23, with a 6 percent conversion premium, what would the difference be between the market price of the convertible bond and the pure bond value? Assume 25 years to maturity, and once again use Table 16-3 for part of your answer.
Interest Rates and Bond Prices (the bond pays 12% interest)
Rate in the Market (%) - Yield to Maturity*
Years to Maturity 8% 10% 12% 14% 16%
1 1038.16 1018.54 1000 981.48 963.98
15 1345.52 1153.32 1000 875.54 774.48
25 1429.92 1182.36 1000 862.06 754.98
Please also aid in filling out the spreadsheet.View Full Posting Details