Create a spreadsheet similar in format to the one below. Make sure that the correct values appear where you see 0.00% when values are input in the shaded cells. Format the input cells and the WACC in percentage format to 2 decimal places. (40 points) Weight of Debt Cost of Debt Marginal Tax Rate Weight of Preferred Stock Cost of Preferred Stock Weight of Equity Cost of Equity WACC 0.00% On a separate sheet, write out your answer for the WACC based on the following assumptions. (10 points) Weight of Debt 30.00% Cost of Debt 12.00% Marginal Tax Rate 40.00% Weight of Preferred Stock 20,00% Cost of Preferred Stock 10.00% Weight of Equity 50.00% Cost of Equity 16.00%