Using proper excel functions

1. Calculate the WACC. ? Taxes and WACC - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign In Calibri BIU- AR Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Clipboard Font 41 C D E F H Sixx AM Manufacturing has a target debt-equity ratio of .45. Its cost of equity is 13 percent, and its cost of debt is 6 percent. If the tax rate is 35 percent, what is the company's WACC? Debt-equity ratio Cost of equity Cost of debt Tax rate 0.45 13% 6% 35% 5 0 1 2 3 Complete the following analysis. Do not hard code values in your calculations. Weight of debt Weight of equity S Aftertax cost of debt 7 s WACC 0 1