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)

On a separate sheet, write out your answer for the WACC based on the following assumptions. (10 points)

Weight of Debt Marginal Tax Rate Weight of Preferred Stock Cost of Preferred Stock Weight of Equity Cost of Equity WACC 0.00%