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 is 28%.

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

please solve for the after tax cost using the YTM and approximation formula

Please solve with excel