Discounted Cash Flow (DCF) Analysis Unlevered
The Liberty Braves Group (BATRK)
$28.25
+0.44 (+1.58%)
All numbers are in Millions, Currency in USD
Operating Data
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
| Revenue | 386 | 442 | 476 | 178 | 568 | 821.75 | 1,188.86 | 1,719.97 | 2,488.35 | 3,599.99 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | ||||||||||
| EBITDA | 21 | 92 | 6 | -21 | 93 | 52.74 | 76.30 | 110.39 | 159.71 | 231.05 |
| EBITDA (%) | ||||||||||
| EBIT | -46 | 16 | -65 | -90 | 21 | -113.10 | -163.63 | -236.73 | -342.48 | -495.48 |
| EBIT (%) | ||||||||||
| Depreciation | 67 | 76 | 71 | 69 | 72 | 165.84 | 239.93 | 347.12 | 502.19 | 726.54 |
| Depreciation (%) |
Balance Sheet Data
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
| Total Cash | 132 | 107 | 142 | 152.02 | 2,814 | 1,099.60 | 1,590.84 | 2,301.53 | 3,329.72 | 4,817.24 |
|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | ||||||||||
| Account Receivables | 32 | 21 | 28 | 30 | 828 | 298.38 | 431.68 | 624.53 | 903.53 | 1,307.17 |
| Account Receivables (%) | ||||||||||
| Inventories | - | - | - | - | - | - | - | - | - | - |
| Inventories (%) | ||||||||||
| Accounts Payable | 58 | 29 | 63 | 53 | 1,832 | 636.25 | 920.49 | 1,331.71 | 1,926.64 | 2,787.35 |
| Accounts Payable (%) | ||||||||||
| Capital Expenditure | -219 | -33 | -103 | -81 | -35 | -225.99 | -326.95 | -473.02 | -684.34 | -990.06 |
| Capital Expenditure (%) |
Weighted Average Cost Of Capital
| Share price | $ 28.25 |
|---|---|
| Beta | 0.924 |
| Diluted Shares Outstanding | 60 |
| Cost of Debt | |
| Tax Rate | -266.67 |
| After-tax Cost of Debt | 0.13% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | 7.979 |
| Total Debt | 18,590 |
| Total Equity | 1,695 |
| Total Capital | 20,285 |
| Debt Weighting | 91.64 |
| Equity Weighting | 8.36 |
| Wacc |
Build Up Free Cash
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
| Revenue | 386 | 442 | 476 | 178 | 568 | 821.75 | 1,188.86 | 1,719.97 | 2,488.35 | 3,599.99 |
|---|---|---|---|---|---|---|---|---|---|---|
| EBITDA | 21 | 92 | 6 | -21 | 93 | 52.74 | 76.30 | 110.39 | 159.71 | 231.05 |
| EBIT | -46 | 16 | -65 | -90 | 21 | -113.10 | -163.63 | -236.73 | -342.48 | -495.48 |
| Tax Rate | 59.68% | 225.00% | 16.30% | 32.76% | -266.67% | 13.41% | 13.41% | 13.41% | 13.41% | 13.41% |
| EBIAT | -18.55 | -20 | -54.40 | -60.52 | 77 | -97.93 | -141.68 | -204.97 | -296.54 | -429.02 |
| Depreciation | 67 | 76 | 71 | 69 | 72 | 165.84 | 239.93 | 347.12 | 502.19 | 726.54 |
| Accounts Receivable | - | 11 | -7 | -2 | -798 | 529.62 | -133.30 | -192.85 | -279 | -403.64 |
| Inventories | - | - | - | - | - | - | - | - | - | - |
| Accounts Payable | - | -29 | 34 | -10 | 1,779 | -1,195.75 | 284.24 | 411.22 | 594.93 | 860.71 |
| Capital Expenditure | -219 | -33 | -103 | -81 | -35 | -225.99 | -326.95 | -473.02 | -684.34 | -990.06 |
| UFCF | -170.55 | 5 | -59.40 | -84.52 | 1,095 | -824.21 | -77.76 | -112.50 | -162.76 | -235.47 |
| WACC | ||||||||||
| PV UFCF | -817.75 | -76.55 | -109.88 | -157.72 | -226.38 | |||||
| SUM PV UFCF | -1,388.27 |
Terminal Value
| Growth in perpetuity method: | |
|---|---|
| Long-term growth rate | |
| WACC (%) | 0.79 |
| Free cash flow (t + 1) | -240.18 |
| Terminal Value | 19,849.44 |
| Present Value of Terminal Value | 19,083.63 |
Intrinsic Value
| Enterprise Value | 17,695.36 |
|---|---|
| Net Debt | 15,776 |
| Equity Value | 1,919.36 |
| Shares Outstanding | 60 |
| Equity Value Per Share | 31.99 |