Please show all Excel formulas.

Top WACC = Eastern

Middle WACC = Western

Bottom WACC = Northern

3. You have been asked to calculate the dividend discount model-based price per share for the three airlines shown above. You know the following for 2019: Firm Dividend Growth/year Eastern 2.0% Western 1.50 2.5% Northern 1.20 3.0% 2.00 You already know their WACCs, so you can use them to present value the stream of dividends. Remember that the terminal value uses the perpetuity formula and that it automatically shows the value as of the beginning of the year when it is calculated! WACC 5.851% 5.454% 5.695% Transactions Cost of Equity DDM 2019 Dividends Dividends Growth/yr. Eastern Western Northern Dividend Stream 2020 2021 TV Eastern Western Northern DDM Value of each Firm $/share Eastern Western Northern