complete the problems using excel formula

P-19: Weighted average cost of capital (LO11-1) Global TechnologY's capital structure is as follows: The aftertax cost of debt is 6.5 percent; the cost of preferred stock is 10 percent; and the cost of common equity (in the form of retained eamings) is 13.5 percent. Calculate Global Technology's weighted average cost of capital. P.20: Weighted average cost of capital (LO11-1) Evans Technology has the following capital structure. Debt Common equity 40% 60 The aftertax cost of debt is 6 percent; and the cost of common equity (in the form of retained earnings) is 13 percent. a) What is the firm's weighted average cost of capital? b) An outside consultant has suggested that because debt is cheaper than equity, the firm should switch to a capital structure that is 50 percent debt and 50 percent equity. Under this new and more debt-oriented arrangement, the aftertax cost of debt is 7 percent, and the cost of common equity (in the form of retained earnings) is 15 percent. Recalculate the firm's weighted average cost of capital. c) Which plan is optimal in terms of minimizing the weighted average cost of capital