Question

7. David Ortiz Motors has a target capital structure of 20% debt and 80% equity. The yield to maturity on the company’s outstanding bonds is 5.7%, and the company’s tax rate is 23%. Ortiz’s CFO has calculated the company’s WACC as 10.45%. What is the company’s cost of equity capital?

8. On January 1, the total market value of the Tysseland Company was $60 million. During the year, the company plans to raise and invest $30 million in new projects. The firm’s present market value capital structure, shown here, is considered to be optimal. There is no short-term debt.

Debt​​​$30,000,000

Common equity​​ 30,000,000

Total capital​​$60,000,000

New bonds will have an 8% coupon rate, and they will be sold at par. Common stock is currently selling at $30 a share. The stock holders’ required rate of return is estimated to be 12%, consisting of a dividend yield of 4% and an expected constant growth rate of 8%. The next expected dividend is $1.20, so the dividend yield is $1.20/$30 = 4%. The marginal tax rate is 40%.

a. In order to maintain the present capital structure, how much of the new investment must be financed by common equity?

b. Assuming there is sufficient cash flow for Tysseland to maintain its target capital structure without issuing additional shares of equity, what is its WACC?

c. Suppose now that there is not enough internal cash flow and the firm must issue new shares of stock. Qualitatively speaking, what will happen to the WACC? No numbers are required to answer this question.

please complete in excel

Answer 1

if you need in excel with cell references, let me know. As no format was provided, i have prepared in own way. Happy to help you