case study, ethics assignment
Sheet 1 - DCF Example
| DCF Example | ||||||
| $ Millions | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 |
| EBITDA: Sports | 1 | 13.6 | 27.8 | 34.4 | 39.7 | 56.5 |
| Discount Rate | ||||||
| 0% | 1 | 13.6 | 27.8 | 34.4 | 39.7 | 56.5 |
| 15% | ||||||
| 20.0% | ||||||
| 30.0% | ||||||
| 40.0% | ||||||
| EBIDTA: Military | -1.4 | 1.3 | 8.4 | 24.8 | 49.9 | 72.4 |
| Discount Rate | ||||||
| 0% | -1.4 | 1.3 | 8.4 | 24.8 | 49.9 | 72.4 |
| 15% | ||||||
| 20.0% | ||||||
| 30.0% | ||||||
| 40.0% | ||||||
&"Helvetica Neue,Regular"&12&K000000&P