Please help and show solutions. If possible add excel formula's so I am able to understand which formulas are used. WILL THUMBS UP FOR WORK

with 40% debt, 10% preferred stock, and 50% common equity. your answers to two decimal places. Download spreadsheet Ch11 P18 Build a Model-65902d.xlsx both the CAPM method and the dividend growth approach to find the cost of equity. b. Calculate the cost of new stock using the dividend growth approach. \% c. Assuming that Gao will not issue new equity and will continue to use the same target capital structure, what is the company's WACC? %