Question

In: Finance

can you use excel Rollins Corporation is estimating its WACC.  Its only bond issue has a 6.07...

can you use excel

Rollins Corporation is estimating its WACC.  Its only bond issue has a 6.07 percent annual yield to maturity, par value of $1,000, mature in 20 years, and has a 5.2% coupon paid semiannually (2.6%).  There is $100 million total par value of debt outstanding.  The firm currently has a $100 par preferred stock that pays a 7.5 percent annual dividend and currently yields 6 percent.  Flotation costs of 5 percent must be incurred on any new issue of preferred.  Current outstanding preferred stock has a total book value of $8 million.  Rollins' beta is 1.25, the risk-free rate is 4.5 percent, and the market risk premium is 6 percent. Rollins is a constant-growth firm that just paid a dividend of $0.47 last year.  Its common stock sells for $10.00 per share, has a dividend growth rate of 7 percent, and there are 10 million shares outstanding.  The CFO estimates that internally generated cash will be sufficient to supply additional equity funding.  The firm's policy is to use a risk premium of 6 percentage points when using the bond-yield-plus-risk-premium method to find rs.  The firm's marginal tax rate is 40 percent.  Please show all work and place answers in the space provided.  If you get stuck on an answer, assume a number, tell me, and continue onward to receive credit on other answers.

  1. What is Rollins' cost of debt?____________
  1. What is Rollins' cost of preferred stock?________
  1. What is Rollins' cost of common stock (rs) using the CAPM approach?_______

  1. What is the firm's cost of common stock (rs) using the DCF approach?_______
  1. What is Rollins' cost of common stock using the bond-yield-plus-risk-premium approach?_______
  1. Given your answers to the three previous questions, provide and explain your estimate of the cost of equity?________
  1. What are the appropriate weights for debt, preferred stock, and common stock?

            Debt weight                           _______

            Preferred stock weight         _______

            Common equity weight        _______

  1. What is Rollins' WACC?_______

Solutions

Expert Solution


Related Solutions

What is the company’s after-tax cost of debt?     Rollins Corporation is estimating its WACC. Its target...
What is the company’s after-tax cost of debt?     Rollins Corporation is estimating its WACC. Its target capital structure What is the company’s cost of preferred equity? premium is 5 percent. The firm's marginal tax rate is 40 percent. What is the company’s cost of common equity?
Rollins Corporation is estimating its WACC. Its target capital structure is 20 percent debt, 20 percent...
Rollins Corporation is estimating its WACC. Its target capital structure is 20 percent debt, 20 percent preferred stock, and 60 percent common equity. Its bonds have a 7.5 percent coupon, paid semiannually, a current maturity of 20 years, and sell for $1,105.78. The firm could sell, at par, $100 preferred stock which pays a 8 percent annual dividend, but flotation costs of 5 percent would be incurred. Rollins' beta is 1.8, the risk-free rate is 2.45 percent, and the market...
1.Rollins Corporation is estimating its WACC. Its target capital structure is 20 percent debt, 20 percent...
1.Rollins Corporation is estimating its WACC. Its target capital structure is 20 percent debt, 20 percent preferred stock, and 60 percent common equity. Rollins' beta is 1.6 , the risk-free rate is 3 percent, and the market risk premium is 5 percent. Rollins is a constant-growth firm which just paid a dividend of $2.00, sells for $ 29 per share, and has a growth rate of 4 percent. The firm's policy is to use a risk premium of 3 percentage...
Answer in excel please LUVFINANCE, Inc. is estimating its WACC. It is operating at its optimal...
Answer in excel please LUVFINANCE, Inc. is estimating its WACC. It is operating at its optimal capital structure. Its outstanding bonds have a 12 percent coupon, paid semiannually, a current maturity of 17 years, and sell for $1,162.   It has 100,000 bonds outstanding. The firm can issue new 20-year maturity semiannual bonds at par but will incur flotation costs of $50 per bond (Hint: the coupon rate on the new bonds = the YTM on existing bonds). The firm could...
Sandoz Corporation is estimating its WACC. The company has 50,000 semi-annual bonds outstanding with a 7.5%...
Sandoz Corporation is estimating its WACC. The company has 50,000 semi-annual bonds outstanding with a 7.5% coupon rate, $1,000 par value, 15 years to maturity, selling for 98.1 percent of par. Sandoz has 1 million common shares outstanding, currently selling for $50 per share with a beta of 1.08. In addition, there are 150,000 shares of 8% preferred stock outstanding, currently trading for $100 per share. The risk-free rate is 3% and the market risk premium is 11%. The marginal...
Sandoz Corporation is estimating its WACC. The company has 50,000 semi-annual bonds outstanding with a 7.5%...
Sandoz Corporation is estimating its WACC. The company has 50,000 semi-annual bonds outstanding with a 7.5% coupon rate, $1,000 par value, 15 years to maturity, selling for 98.1 percent of par. Sandoz has 1 million common shares outstanding, currently selling for $50 per share with a beta of 1.08. In addition, there are 150,000 shares of 8% preferred stock outstanding, currently trading for $100 per share. The risk-free rate is 3% and the market risk premium is 11%. The marginal...
Sandoz Corporation is estimating its WACC. The company has 50,000 semi-annual bonds outstanding with a 7.5%...
Sandoz Corporation is estimating its WACC. The company has 50,000 semi-annual bonds outstanding with a 7.5% coupon rate, $1,000 par value, 15 years to maturity, selling for 98.1 percent of par. Sandoz has 1 million common shares outstanding, currently selling for $50 per share with a beta of 1.08. In addition, there are 150,000 shares of 8% preferred stock outstanding, currently trading for $100 per share. The risk-free rate is 3% and the market risk premium is 11%. The marginal...
Lipscomb Corporation is estimating its WACC. Its target capital structure is 20 percent debt, 20 percent...
Lipscomb Corporation is estimating its WACC. Its target capital structure is 20 percent debt, 20 percent preferred stock, and 60 percent common equity. Its bonds have a 12 percent coupon, paid semiannually, a current maturity of 20 years, and sell for 1,000 USD. The firm could sell, at par, 100 USD preferred stock which pays a 12 percent annual dividend, but flotation costs of 5 percent would be incurred. Libscomb is a constant-growth firm which just paid a dividend of...
Resources Corporation is estimating its WACC. Its target capital structure is 40% debt, 10% preferred stock,...
Resources Corporation is estimating its WACC. Its target capital structure is 40% debt, 10% preferred stock, and 50% common equity. Its bonds have an 8% coupon rate, paid semi-annually, a current maturity of 12 years, and sell for $1,080.29. The firm could sell, at par, $100 preferred stock which pays a 6.75% annual dividend (assume no flotation costs). Resources’ beta is 1.6, the risk-free rate [rRF] is 3%, and the market risk premium [RPM] is 5%. Resources is a constant-growth...
CSM Corporation has a bond issue outstanding at the end of the year. The bond has...
CSM Corporation has a bond issue outstanding at the end of the year. The bond has 15 years remaining to maturity and carries a coupon interest rate of 6%. Interest on the bond is compounded on a semiannual basis. The par value of the CSM bond is $1,000 and it is currently selling for $874.42. a. Solve for the yield to maturity. Show your work. b. Solve for the price of the bond if the yield to maturity is 2%...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT