Can you show me how to solve on excel

4. Haroldson Inc. common stock is selling for $22 per share. The last dividend was $1.20, and dividends are expected to grow, at a 6% annual rate. Flotation costs on new stock sales are 5% of the selling price, what is the cost of Haroldson Inc.'s new common stock? Kokapeli, Inc. has a target capital structure of 40% debt and 60% common equity, and has a 40% marginal tax rate. If the firm's yield to maturity on bonds is 7.5 and investors require a 15% return on the firm's common stock, what is the firm's WACC? 5