Assume ABC Corporation is a multinational company with the following financial

information:

Market value of equity $($E$)$: $$500$ million

Market value of debt $($D$)$: $$300$ million

Market value of preferred stock $($PS$)$: $$50$ million

Cost of equity $($Re$)$: $10\%$

Cost of debt $($BTrd$)$: $5\%$

Corporate tax rate $($Tc$)$: $25\%$

Cost of preferred stock $($Rps$)$: $8\%$

a$.$ Calculate the WACC for ABC Corporation.

Needs to be done in Excel