MGMT 332
S.p
MGMT332_Excel_Template_6.xlsTransactions
| Transactions | |||||
| EPS | EBITDA | Premium | |||
| Values for past transactions: | |||||
| - Average | |||||
| EPS | Last 4Q | ||||
| Aerial EPS | Average price per share using 3 references | ||||
| Average EPS Multiple | |||||
| Equity Value per Share | |||||
| EBITDA | |||||
| Aerial EBITDA (in M$, last 4Q) | |||||
| Average EBITDA Multiple | |||||
| Firm Value | |||||
| Debt Value | |||||
| Equity Value | |||||
| Equity Value per Share | |||||
| Premium | |||||
| Pre-Merger Announcement Stock Price | |||||
| Average Premium Multiple | |||||
| # of shares outstanding (M) | 90.50 |
Cost of Equity
| Cost of Equity | ||||
| Rf | Beta | Market Premium | Equity Cost | |
| Eastern | ||||
| Western | ||||
| Northern | ||||
| Cost of Debt | ||||
| Rd | Debt/Assets | |||
| Eastern | ||||
| Western | ||||
| Northern | ||||
| Weighed Average Cost of Capital | ||||
| WACC | ||||
| Eastern | ||||
| Western | ||||
| Northern | ||||
| Tax rate |
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 |
