Please show work in excel.

2. You have been asked to calculate the cost of equity for three firms- Eastern, Western, and Northern. You know the following: Firm Beta Cost of Debt Debt/Assets Eastern 1.10 3.8% 50% Western 1.20 4.35% 65% Northern 1.15 4.1% 57% You know the following: 10-year Treasury yield = 3.20% Market Premium = 5.0% Average Tax Rate = 21% What are the expected returns on equity and WACCs for each of these firms? B D E 1 D Cost of Equity Beta Market Premium 2 RE Equity Cost 3 Eastern 4 Western 5 Northern 6 7 Cost of Debt 8 R. Debt/Assets 9 Eastern 10 Western 11 Northern 12 13 Weighed Average Cost of Capital WACC 14 15 Eastern 16 Western 17 Northern 18 19 Tax rate