pls use excel formuals thank you!! :-)

Saved as Calculating the WACC - Excel 6 7 N. FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in * Calibri - 11 A A Paste BIU- A % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font A1 ++ B D E F G H 1 Market value of debt 33 34 35 36 37 Market value of equity 38 39 40 41 Market value of preferred Market value of firm 42 43 Market value weight of debt 44 Market value of weight equity Market value of weight preferred Pretax cost of debt 45 46 47 48 49 50 51 52 53 54 55 Aftertax cost of debt Cost of equity Cost of preferred Sheet1 READY Attempt(s) 100% Styles A1 fa B D E F G H I 39 40 41 Market value of firm Market value weight of debt Market value of weight equity 42 43 44 45 46 47 48 49 Market value of weight preferred Pretax cost of debt Aftertax cost of debt Cost of equity Cost of preferred SO 51 52 53 54 55 56 57 58 59 60 WACC Sheet1 READY Attempt(s) 100% Saved as Calculating the WACC - Excel 6 7 N. FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in * Calibri - 11 A A Paste BIU- A % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font A1 ++ B D E F G H 1 Market value of debt 33 34 35 36 37 Market value of equity 38 39 40 41 Market value of preferred Market value of firm 42 43 Market value weight of debt 44 Market value of weight equity Market value of weight preferred Pretax cost of debt 45 46 47 48 49 50 51 52 53 54 55 Aftertax cost of debt Cost of equity Cost of preferred Sheet1 READY Attempt(s) 100% Styles A1 fa B D E F G H I 39 40 41 Market value of firm Market value weight of debt Market value of weight equity 42 43 44 45 46 47 48 49 Market value of weight preferred Pretax cost of debt Aftertax cost of debt Cost of equity Cost of preferred SO 51 52 53 54 55 56 57 58 59 60 WACC Sheet1 READY Attempt(s) 100%