Please solve in an excel spread sheet format and please show the formulas used to solve the questions. Thank you

fx 2 B C E F H K M N Q R un T U V w X Y N AA 1 2 10-8 3 4 5 6 COST OF COMMON EQUITY AND WACC Palencia Paints Corporation has a target capital structure of 35% debt and 65% common equity, with no preferred stock. Its before-tax cost of debt is 8%, and its marginal tax rate is 40%. The current stock price is P. $22.00. The last dividend was D. = $2.25, and it is expected to grow at a 5% constant rate. What is its cost of common equity and its WACC? = 7 8 9 10 11 12 12