Can you provide the excel formulas?

4 6 7 8 g 10 12 14 16 17 18 20 26 27 30 Currant price of common stock, Po Last years dividend on common stock, Growth rate of common dividend, g Flotation cost for common stock Currant price of preferred stock, P Preferred dividend, DPS Flotation cost for preferred stock Bond's years to maturity Number of coupon payment par year Annual coupon rate Par value Bond price Tax rate Market risk premium, RPM Risk-free rate, rRF aeta Weight of long-term debt Weight of preferred stock, w Weight of common stock, w sso_oo $2.83 6% 11% $21.61 $2.60 7% 26 2 Sl , ooo_oo $908.72 1.3 46 % Formulas 23 a. Calculating the cost of each capital component Annual before-tax cost of debt After-tax cost of debt Cost of preferred stock (including iotation costs) Cost of common equity, dividend growth approach (ignoring iotation costs) 28 Cost of common equity, CAPM b. Calculating the cost of new stock using the dividend growth approach Cost of new stock, dividend growth approach 3 c. Calculating the company's WACC if Gao will not issue new equity and will continue to use the same target capital structure 34 WACC