CalculationofindividualcostsandWACC. Dillion 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, 25% preferred stock, and 40% common stock equity (retained earnings, new common stock, or both). The firm tax rate is 35%.

Debt: The firm can sell for $955 a 14-year, $1,000-par-value bond paying annual interest at a 9.00% coupon rate. A flotation cost of 2% of the par value is required in addition to the discount of $45 per bond.

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

Common stock. The firm's common stock is currently selling for $70 per share. The dividend expected to be paid at the end of the coming year (2016) is $3.16. Its dividend payments which have been approximately 70% of earnings per share in the past 5 years, are shown in the attached table.

It is expected that to attract buyers, new common stock must be underpriced $8 per share, and the firm must also pay $4.00 per share in flotation costs. Dividend payments are expected to continue at 70% of earnings.

a. Calculate the after-tax cost of debt.

b. Calculate the cost of preferred stock.

c. Calculate the cost of common stock.

d. Calculate the WAAC for Dillion Labs.

e, Display the answers in an Excel Spread Sheet Format.