Please show all Excel formulas.

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 4.35% 65% Northern 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? 1.20 1.15 Transactions Cost of Equity DDM Cost of Equity Beta Market Premium Equity Cost RE Eastem Western Northern Cost of Debt Rd Debt/Assets Eastem Western Northern Weighed Average Cost of Capital WACC Eastern Western Northern Tax rate