Please use Excel to solve and show working

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? Common stock Preferred stock Debt Cost of equity Cost of preferred stock Cost of debt Tax rate 70% 5% 25% 11% 5% 796 23% Complete the following analysis. Do not hard code values in your calculations. VW