AT&T 10:31 PM * 79%@ ? Done Case 3 WACC.docx 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 Maginal Tax Rate Weight of Prefensed Stock Cost of Prefersed Stock Weight ofEquity Cost of Equity WACC On a separate sheet, write out your answer for the WACC based on the following assumptions. (10 points) Weigt of Debe Cost of Dele 30 Wright of Premed Stock 10 Cost of Preffered Stock 12 Weight of Equity Cot of Eqity