Question

In: Finance

A firm has determined its optimal capital structure, which is composed of the following sources and...

A firm has determined its optimal capital structure, which is composed of the following sources and target market value proportions: Source of Capital Target Market Proportions Long-term debt 60% Preferred stock 5% Common stock equity 35% Debt: The firm can sell a 15 year bond, compounded monthly, with a $1000 par value and 6.8% coupon rate for $1254. A flotation cost of 1.15% of the face value would also be required. Preferred Stock: The firm has determined that it can issue preferred stock at $125 per share par value. The preferred stock wil pay a $6.75 per share annual dividend. The cost of issuing and selling the preferred will be $3.28 per share. Common Stock: The firm's common stock is currently selling for $23.75per share. The firm will be paying a dividend of $5.25 at the end of the year. Its dividend payments have been growing at a constant rate for the last five years. Five years ago, the dividend was $3.25. For a new issue of common stock to sell, it has been determined that the new issue would need to be underpriced at $1.50 per share and that the firm must pay $1.20per share in flotation costs. The firm's marginal tax rate is 21%, plus 4% for state and local taxes. (ISTR = 25%) To determine the firm’s WACC, please complete the following steps, entering your formulas in the blue cells: A. Calculate the rate for the bond, notice is has monthly compounding. B. Calculate the after-tax cost of the bond. C. Calculate the cost of the new issue of preferred stock. D. Calculate the growth rate of the common stock dividends. E. Calculate the cost of the new common stock issue. F. Finally, calculate the firm's weighted average cost of capital assuming the firm has exhausted all retained earnings. Standard formats for your calculations: Common Stock Preferred Stock Inputs Debt Growth Rate Price NPER NPER New Issue Costs Coupon Price PV Adjusted Price Coupon Rate FV Dividend PMT RATE = Mkt Price Formula Inputs WACC Market Rate Price Proportions Costs Amount FV New Issue Costs Compounding periods Adjusted Price RATE= D1 g TOTAL >> PART 1 B- CAPITAL BUDGETING The same firm as in Part 1 is considering the investment of two independent projects, X and Y, which are described below. Please do not assume anything. Use the firm's WACC which you just calculated to evaluate the projects. Cost of Capital>> Year PROJECT X PROJECT Y A. Calculate Payback Period for both projects For the Payback Period Calculation Cash Inflows B. Calculate NPV for both projects Cash End of Year Balances Initial Investment ($11,050,000) ($11,250,000) 0 C. Calculate PI for both projects PROJECT X PROJECT Y 1 $3,500,000 $5,500,000 1 D. Calculate IRR for both projects 2 $3,500,000 $5,800,000 2 E. Which project should the firm accept? Why? 3 $5,800,000 $2,900,000 3 4 $5,800,000 $1,950,000 4 Please enter your formulas in the blue cells: A. Payback B. NPV C. IRR D. MIRR E. Accept projects>>> Yes or No Yes or No Why?:

Solutions

Expert Solution

You have asked multiple unrelated questions in the same post. As if it was not enough, each of your questions has multiple sub parts. I have addressed all the sub parts of the first one. Please post the balance questions separately one by one

.A. Calculate the rate for the bond, notice is has monthly compounding.

Debt: The firm can sell a 15 year bond, compounded monthly, with a $1000 par value and 6.8% coupon rate for $1254. A flotation cost of 1.15% of the face value would also be required.

Nper = 12 x 15 = 180; PMT = Coupon rate / 12 x Par value = 6.8%/12 x 1,000 = 5.6667; PV = -(Price of the bond - flotation cost) = -(1,254 - 1.15% x 1,000) = -1,242.50; FV = Par value = 1,000

Hence, yield per month = RATE (Nper, PMT, PV, FV) = RATE (180, 5.6667, -1242.50, 1000) = 0.3804%

Hence, the rate for the bond = 12 x yield per month = 12 x 0.3804% = 4.56%

B. Calculate the after-tax cost of the bond.

the after-tax cost of the bond, Kd = pre tax cost x (1 - tax rate) = 4.56% x (1 - 25%) = 3.42%

C. Calculate the cost of the new issue of preferred stock.

Preferred Stock: The firm has determined that it can issue preferred stock at $125 per share par value. The preferred stock wil pay a $6.75 per share annual dividend. The cost of issuing and selling the preferred will be $3.28 per share.

The cost of the new issue of preferred stock, Ks = Annual dividend / Price net of flotation cost = 6.75 / (125 - 3.28) = 5.55%

D. Calculate the growth rate of the common stock dividends.

Common Stock: The firm's common stock is currently selling for $23.75per share. The firm will be paying a dividend of $5.25 at the end of the year. Its dividend payments have been growing at a constant rate for the last five years. Five years ago, the dividend was $3.25.

the growth rate of the common stock dividends = (Dive 5 years ago/Current dividend)1/5 - 1 = (5.25 / 3.25)(!/5) - 1 = 10.07%

E. Calculate the cost of the new common stock issue.

For a new issue of common stock to sell, it has been determined that the new issue would need to be underpriced at $1.50 per share and that the firm must pay $1.20per share in flotation costs.

Net price on issuance, P = P0 - underpricing - flotation cost = 23.75 - 1.50 - 1.20 = 21.05

Hence, the cost of the new common stock issue, Ke = D1/P + g = 3.25 / 21.05 + 10.07% = 25.51%

F. Finally, calculate the firm's weighted average cost of capital assuming the firm has exhausted all retained earnings.

WACC - Wd x kdpost tax + Ws x Ks + We x Ke = 60% x 3.42% + 5% x 5.55% + 35% x 25.51% = 11.26%


Related Solutions

A firm has determined its optimal capital structure which is composed of the following sources and...
A firm has determined its optimal capital structure which is composed of the following sources and target market value proportions. Additionally, the firm's marginal tax rate is 40 percent                                             Source of Capital      Market Proportions Long- term debt                       20% Preferred stock                        10 Common stock equity              70              Debt: The firm can sell a 12- year, $1,000 par value, 7 percent annual bond for $880. Preferred Stock: The firm has determined it can issue preferred stock at $75 per share par value. The stock will pay a...
HD Ltd has determined its optimal capital structure, which is composed of the following sources and...
HD Ltd has determined its optimal capital structure, which is composed of the following sources and target market value proportions: Source of Capital Long-term debt 30% Preferred stock 5% Common stock equity 65% Target Market Proportions (i) Debt: The firm can sell a 10-year, $1,000 par value, 6 percent bond for $1,000. (ii) Preferred Stock: The firm has determined it can issue preferred stock at $65 per share par value. The stock will pay an $8.00 annual dividend. (iii) Common...
A firm has determined its cost of each source of capital and optimal capital structure, which...
A firm has determined its cost of each source of capital and optimal capital structure, which is composed of the following sources and target market value proportions: Source of capital / Taget Market Proportions / After-Tax Cost Long-term Debt/ 40% / 6% Preferred Stock / 10% / 11 Common Stock Equity / 50 / 15 The weighted average cost of capital is
A firm has determined its cost of each source of capital and optimal capital structure, which...
A firm has determined its cost of each source of capital and optimal capital structure, which is composed of the following sources and target market value proportions. To get the cost of equity, the following is provided, Risk free rate of return is 5%, the stock has a Beta of 1.25x and the Market Return is expected to be 11.5%. The firms existing debt has a 8.5% coupon 9 year maturity and trades at 93.75%. The firm is in the...
A firm has determined its cost of each source of capital and optimal capital structure, which...
A firm has determined its cost of each source of capital and optimal capital structure, which is composed of the following sources and target market value proportions. To get the cost of equity, the following is provided, Risk free rate of return is 5%, the stock has a Beta of 1.25x and the Market Return is expected to be 11.5%. The firms existing debt has a 8.5% coupon 9 year maturity and trades at 93.75%. The firm is in the...
A firm is planning next year's capital budget. It is at its optimal capital structure, which...
A firm is planning next year's capital budget. It is at its optimal capital structure, which is 32% debit and 68%, common equity, and the company’s earnings in dividends are growing at a constant rate of 4%. The last dividends, D0, was $1.50, and the company’s stock currently sells at a price of $36 per share. The firm can raise debt at a 6% before-tax cost and is projecting net income to be $8,500,000 with a dividend payout ratio of...
Which of the following statements best describes the optimal capital structure? a. The optimal capital structure...
Which of the following statements best describes the optimal capital structure? a. The optimal capital structure is the mix of debt, equity, and preferred stock that maximizes the company's earnings per share (EPS). b. The optimal capital structure is the mix of debt, equity, and preferred stock that minimizes the company's cost of preferred stock. c. The optimal capital structure is the mix of debt, equity, and preferred stock that minimizes the company's cost of debt. d. The optimal capital...
A company has determined that its optimal capital structure consists of 40 percent debt and 60...
A company has determined that its optimal capital structure consists of 40 percent debt and 60 percent equity. Given the following information, calculate the firm's weighted average cost of capital. Cost of Debt = 7.0%, Tax rate = 40%, Current Stock Price = $27.15, Long Run Growth rate = 4.4%, Next Year's Dividend = $1.88. Show your answer to the nearest .1%. Do not use the % sign in your answer. Enter your answer as a whole number, thus 9.2%...
A company has determined that its optimal capital structure consists of 40 percent debt and 60...
A company has determined that its optimal capital structure consists of 40 percent debt and 60 percent equity. Given the following information, calculate the firm's weighted average cost of capital. Cost of Debt = 7.0%, Tax rate = 40%, Current Stock Price = $23.72, Long Run Growth rate = 3.8%, Next Year's Dividend = $2.26. Show your answer to the nearest .1%. Do not use the % sign in your answer. Enter your answer as a whole number, thus 9.2%...
Badmmans Firearms Company has the following capital structure, which it considers to be optimal: debt =...
Badmmans Firearms Company has the following capital structure, which it considers to be optimal: debt = 17%, preferred stock = 12%, and common equity = 71%. Badman’s tax rate is 35%, and investors expect earnings and dividends to grow at a constant rate of 8% in the future. Badman's expected net income this year is $395,840, and its established dividend payout ratio is 24%. Badmans paid a dividend of $6.75 per share last year (D 0 ), and its stock...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT