Question

In: Finance

EXCEL TEMPLATE) Watchstone Concrete Products issued 30-year maturity bonds 15 years ago with a coupon rate...

EXCEL TEMPLATE) Watchstone Concrete Products issued 30-year maturity bonds 15 years ago with a coupon rate of 10.75%. The principal amount was $15,000,000. Interest rates have steadily decreased and the company could issue new bonds today at a coupon rate of 9.50%. The new issue would be used to pay off the old bonds and would have a maturity of 15 years. The original issue had flotation costs of $375,000 which were set up on an amortization schedule over 30 years with equal amounts each year. The old bonds are callable with a premium of 4.5%. An investment banking firm would charge a flotation fee of $225,000 on the new issue that would be amortized over the life of the new bonds. Rover’s marginal tax rate is 25%. Calculate the NPV of the bond refund

a.Old and nwe Bond Principal?

b.Old and new Bond Interest Rate?

c.Old and new Bond Flotation Cost?

d.Old and new Bond Maturity (Years)?

e.Tax Rate?

f.Call Premium Rate?

Solutions

Expert Solution

Step 1: Incremental Initial flow

Raise the fund 15,000,000
Repay the old bond      (15,000,000)
Floatation cost on new bond (225,000)
Call Premium (15,000,000*4.5%) (675,000)
Tax saved on call premium (675,000*25%) 168,750
Tax saved on unamortised portion of floatation cost of old bond (WN 1) 46,875

Sum (684,375)

Step 2: Incremental inbetween flows

Payment of interest in new bond (15,000,000*9.5%)        (1,425,000)
Tax saved on above @25% 356,250
old interest saved (15,000,000*10.75%)          1,612,500
Tax lost on old interest @25% (403,125)
Tax saved on floatation cost of new bond (WN 2) 3,750
Tax lost on floatation cost of old bond (12,500*25%) (3,125)

sum 141,250

Step 3: Incremental terminal flow

Repayment of new bond      (15,000,000)
Savings in repayment of old bond        15,000,000

Sum 0

Step 4: Calculation of NPV

In the absence of discount rate being given, the coupon rate associated with new bond is the pre tax discount rate. So post tax discount rate=9.5%(no tax here)

Year Cashflow [email protected]% Cashflow*PVF
0 (684,375) 1 -684375.00
1-15              141,250 7.8282 1105733.25
15                         -   0.2563 0.00

NPV = PV of Inflows - PV of outflows

= 1105733.25-684375

= 421358.25

Decision: Since the NPV is positive, refund the bonds.


Related Solutions

Smith Corporation issued convertible bonds 5 years ago with an original maturity of 30 years, coupon...
Smith Corporation issued convertible bonds 5 years ago with an original maturity of 30 years, coupon of 4.5%, and annual payment. They were sold at their par value of $1,000 and with a conversion price of $28.57. Common stock at the time was selling for $14 per share. During the last 5 years, the stock price has not exceeded $22 per share. Straight nonconvertible debentures issued at approximately the same time had a coupon rate of 7.2%. During the next...
Northern Corp. issued 15-year bonds two years ago at a coupon rate of 6.25 percent.
Northern Corp. issued 15-year bonds two years ago at a coupon rate of 6.25 percent. The bonds make semiannual payments. If these bonds currently sell for 102.50 percent of par value, what is the YTM?
Cavu Air Inc., issued 15 Year bonds 2 years ago at a coupon rate of 7.30%...
Cavu Air Inc., issued 15 Year bonds 2 years ago at a coupon rate of 7.30% percent. The bonds make semi annual payments. If these bonds currently sell for 103 percent of par value, what is the YTM? Settlement date 1/1/2000 Maturity date 1/1/2013 Annual coupon rate 7.30% Coupons per year 2 Face value (% of par) 100 Bond price (% of par) 103
Skolits Corp. issued 15 year bonds two years ago at a coupon rate of 5.1 percent....
Skolits Corp. issued 15 year bonds two years ago at a coupon rate of 5.1 percent. The bonds make semiannual payments. If these bonds currently sell for 105 percent of par value, what is the YTM?
Newco issued 30-year bonds 12 years ago at a coupon rate of 7.5% payable quarterly. If...
Newco issued 30-year bonds 12 years ago at a coupon rate of 7.5% payable quarterly. If the bonds currently sell for 110% of par value, what is their YTM? (Full percent, Use two decimals i.e 8.00) Blank 1%
Question 1: Six years ago the Templeton Company issued 30-year bonds with a 15% annual coupon...
Question 1: Six years ago the Templeton Company issued 30-year bonds with a 15% annual coupon rate at their $1,000 par value. The bonds had a 9% call premium, with 5 years of call protection. Today Templeton called the bonds. Compute the realized rate of return for an investor who purchased the bonds when they were issued and held them until they were called. Round your answer to two decimal places. Why should or should not the investor be happy...
Three years ago, JKL Co. issued bonds with a 18-year maturity then and at a coupon...
Three years ago, JKL Co. issued bonds with a 18-year maturity then and at a coupon rate of 6.1 percent. The bonds make semiannual payments. If the YTM on these bonds is 7.5 percent, what is the current bond price? (Do not include the dollar sign ($). Enter rounded answer as directed, but do not use the rounded numbers in intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).)
eBook Six years ago the Templeton Company issued 15-year bonds with a 14% annual coupon rate...
eBook Six years ago the Templeton Company issued 15-year bonds with a 14% annual coupon rate at their $1,000 par value. The bonds had a 9% call premium, with 5 years of call protection. Today Templeton called the bonds. Compute the realized rate of return for an investor who purchased the bonds when they were issued and held them until they were called. Round your answer to two decimal places. % Why the investor should or should not be happy...
Ten years ago, a firm issued $1,000 par value, 30-year bonds with an 6.5% coupon rate...
Ten years ago, a firm issued $1,000 par value, 30-year bonds with an 6.5% coupon rate and a 7% call premium. These bonds currently trade for $1,325 and are callable beginning 20 years from date of issuance. Assume semi-annual compounding. a. Calculate the yield-to-maturity of these bonds today? b. Calculate the yield-to-call on these bonds today? Please show work!
One year ago, ShopFast issued 15-year annual bonds at par. The bonds had a coupon rate...
One year ago, ShopFast issued 15-year annual bonds at par. The bonds had a coupon rate of 6.5 percent and had a face value of $1,000. Today, applicable yield to maturity to ShopFast’s bonds is 7%. What was the change in price in ShopFast’s bonds from last year to today? A) -55.56t B) 51.94 C) -$43.73 D) 58.71 E) The bond price did not change. WallStores needs to raise $2.8 million for expansion. The firm wants to raise this money...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT