can you show me each cell in excel how it was done. thank you

213 G J L M N 0 P14-22 Modified (changes from the text are in bold) The target capital structure for QM Industries is 55 percent common stock, 5 percent preferred stock, and 40 percent debt. If the cost of common equity for the firm is 12.5 percent, the cost of preferred stock is 7 percent, and the before-tax cost of debt is 4.5 percent, and the firm's tax rate is 25 percent, what is QM's wieghted average cost of capital? Hint: seo Figure 14.1 on page 449 Tax Rato Weight Before Tax Costs After Tax Costs WC Source of Capital Common Stock Preferred Stock Debt