Calculation of individual costs and WACC Dillon Labs has asked its financial manager to measure the cost of each specific type of capital as well as the weighted average cost of capital. The weighted average cost is to be measured by using the following weights 35% long-term debt, 10% preferred stock, and 55% common stock equity (retained earnings, new common stock, or both). The firm's tax rate is29%.

Debt The firm can sell for $1005a 17-year, $1, 000-par-value bond paying annual interest at a8.00% coupon rate. A flotation cost of 4%of the par value is required.

Preferred stock 10.00%(annual dividend) preferred stock having a par value of $100can be sold for $88. An additional fee of $5per share must be paid to the underwriters.

Common stock The firm's common stock is currently selling for $90 per share. The stock has paid a dividend that has gradually increased for many years, rising from$2.00 ten years ago to the$3.93 dividend payment, Do, that the company just recently made. If the company wants to issue new common stock, it will sell them $3.50 below the current market price to attract investors, and the company will pay $4.00 per share in flotation costs.

a.Calculate the after-tax cost of debt. Using the bonds yield to maturity YTM % (Round two decimal places)

The after-tax cost of debt using the approximation formula % (Round Two decimal places)

b.Calculate the cost of preferred stock. % (Round Two decimal places)

c.Calculate the cost of common stock (both retained earnings and new common stock). %Round two decimal places

d.Calculate the WACC for Dillon Labs.

Please show me how to do this in Excel with Rate! Thank you for all your help you are the best