Calculating WACC Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEWVIEW Sign In Calibri .111 ,la" A Alignment Number Conditional Formatas Cell- Cells Paste u Formatting Table" Styles Styles Clipboard Font A1 Mullineaux Corporation has a target capital structure of 70 percent common stock, 5 percent preferred stock, and 25 percent debt. Its cost of equity is 11 percent, the cost of preferred stock is 5 percent, and the pretax cost of debt is 7 percent. The relevant tax rate is 23 percent. What is the company's WACC? 4 Common stock Preferred stock Debt Cost of equity Cost of preferred stock Cost of debt Tax rate 70% 5% 25% 11% 5% 7% 22% 10 12 13 15 16 17 18 19 20 21 Complete the following analysis. Do not hard code values in your calculations. WACC