Discounted Cash Flow (DCF) Analysis Unlevered

Discovery Communications Inc. (DISCK)
Operating Data
Year A/P | 2014 Actual | 2015 Actual | 2016 Actual | 2017 Actual | 2018 Actual | 2019 Projected | 2020 Projected | 2021 Projected | 2022 Projected | 2023 Projected |
Revenue | 6,265.00 | 6,394.06 | 6,497.00 | 6,873.18 | 10,553.08 | 12,215.19 | 14,139.08 | 16,365.99 | 18,943.63 | 21,927.25 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
EBITDA | 3,960.73 | 3,927.87 | 4,119.10 | 2,578.13 | 6,437.38 | 7,000.53 | 8,103.11 | 9,379.35 | 10,856.60 | 12,566.51 |
EBITDA (%) | ||||||||||
EBIT | 2,074.97 | 1,888.81 | 2,023.82 | 338.16 | 1,751.81 | 2,816.82 | 3,260.47 | 3,774.00 | 4,368.40 | 5,056.42 |
EBIT (%) | ||||||||||
Depreciation | 1,885.77 | 2,039.07 | 2,095.28 | 2,239.97 | 4,685.57 | 4,183.70 | 4,842.64 | 5,605.35 | 6,488.19 | 7,510.08 |
Depreciation (%) |
Balance Sheet Data
Year A/P | 2014 Projected | 2015 Projected | 2016 Projected | 2017 Projected | 2018 Projected | 2019 Projected | 2020 Projected | 2021 Projected | 2022 Projected | 2023 Projected |
Total Cash | - | - | - | - | - | - | - | - | - | - |
---|---|---|---|---|---|---|---|---|---|---|
Total Cash (%) | ||||||||||
Account Receivables | 1,432.81 | 1,478.95 | 1,494.96 | 1,837.89 | 2,620.33 | 2,946.30 | 3,410.35 | 3,947.48 | 4,569.20 | 5,288.85 |
Account Receivables (%) | ||||||||||
Inventories | - | - | - | - | - | - | - | - | - | - |
Inventories (%) | ||||||||||
Accounts Payable | 224.91 | 281.98 | 241.04 | 276.99 | 325.03 | 459.29 | 531.63 | 615.36 | 712.28 | 824.46 |
Accounts Payable (%) | ||||||||||
Capital Expenditure | -120.29 | -102.94 | -87.71 | -134.71 | -146.69 | -201.55 | -233.29 | -270.04 | -312.57 | -361.80 |
Capital Expenditure (%) |
Weighted Average Cost Of Capital
Share price | $ 30.14 |
---|---|
Diluted Shares Outstanding | 688.00 |
Cost of Debt | |
Tax Rate | 39.92 |
After-tax Cost of Debt | -1.95 |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 11.05 |
Total Debt | 15,185.00 |
Total Equity | 20,736.32 |
Total Capital | 35,921.32 |
Debt Weighting | 42.27 |
Equity Weighting | 57.73 |
Wacc |
Build Up Free Cash
Year A/P | 2014 Actual | 2015 Actual | 2016 Actual | 2017 Actual | 2018 Actual | 2019 Projected | 2020 Projected | 2021 Projected | 2022 Projected | 2023 Projected |
Revenue | 6,265.00 | 6,394.06 | 6,497.00 | 6,873.18 | 10,553.08 | 12,215.19 | 14,139.08 | 16,365.99 | 18,943.63 | 21,927.25 |
---|---|---|---|---|---|---|---|---|---|---|
EBITDA | 3,960.73 | 3,927.87 | 4,119.10 | 2,578.13 | 6,437.38 | 7,000.53 | 8,103.11 | 9,379.35 | 10,856.60 | 12,566.51 |
EBIT | 2,074.97 | 1,888.81 | 2,023.82 | 338.16 | 1,751.81 | 2,816.82 | 3,260.47 | 3,774.00 | 4,368.40 | 5,056.42 |
Tax Rate | 35.03% | 32.84% | 27.17% | -128.47% | 39.92% | 1.30% | 1.30% | 1.30% | 1.30% | 1.30% |
EBIAT | 1,348.08 | 1,268.49 | 1,473.96 | 772.59 | 1,052.46 | 2,780.22 | 3,218.11 | 3,724.96 | 4,311.64 | 4,990.72 |
Depreciation | 1,885.77 | 2,039.07 | 2,095.28 | 2,239.97 | 4,685.57 | 4,183.70 | 4,842.64 | 5,605.35 | 6,488.19 | 7,510.08 |
Accounts Receivable | - | -46.14 | -16.01 | -342.93 | -782.44 | -325.97 | -464.04 | -537.13 | -621.73 | -719.65 |
Inventories | - | - | - | - | - | - | - | - | - | - |
Accounts Payable | - | 57.06 | -40.94 | 35.95 | 48.05 | 134.26 | 72.34 | 83.73 | 96.92 | 112.18 |
Capital Expenditure | - | -17.34 | -15.23 | 47.00 | 11.97 | 54.86 | 31.74 | 36.74 | 42.53 | 49.23 |
UFCF | 3,233.84 | 3,301.14 | 3,497.05 | 2,752.58 | 5,015.60 | 6,827.07 | 7,700.78 | 8,913.65 | 10,317.56 | 11,942.57 |
WACC | ||||||||||
PV UFCF | 6,827.07 | 7,153.54 | 7,691.80 | 8,270.56 | 8,892.86 | |||||
SUM PV UFCF | - |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 7.65 |
Free cash flow (t + 1) | 12,420.27 |
Terminal Value | 340,281.46 |
Present Value of Terminal Value | 235,379.22 |
Intrinsic Value
Enterprise Value | - |
---|---|
Net Debt | 15,185.00 |
Equity Value | - |
Shares Outstanding | 688.00 |
Equity Value Per Share | - |