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 also 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?

Please answer and show formulas in this excel format