Discounted Cash Flow (DCF) Analysis Levered
Grupo Televisa, S.A.B. (TV)
$5.085
-0.06 (-1.07%)
All numbers are in Millions, Currency in USD
Free Cash Flow
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Revenue | 101,282.33 | 101,757.18 | 97,361.63 | 103,521.80 | 75,526.60 | 70,888.04 | 66,534.36 | 62,448.06 | 58,612.73 | 55,012.96 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
Operating Cash Flow | 33,714.50 | 27,269.08 | 33,160.92 | 29,396.06 | 6,876.33 | 18,664.24 | 17,517.95 | 16,442.06 | 15,432.25 | 14,484.46 |
Operating Cash Flow (%) | ||||||||||
Capital Expenditure | -26,273.94 | -21,215.03 | -21,366.92 | -25,167.25 | -19,182.39 | -16,792.69 | -15,761.34 | -14,793.34 | -13,884.79 | -13,032.04 |
Capital Expenditure (%) | ||||||||||
Free Cash Flow | 7,440.55 | 6,054.05 | 11,794 | 4,228.81 | -12,306.06 | 1,871.55 | 1,756.60 | 1,648.72 | 1,547.46 | 1,452.42 |
Weighted Average Cost Of Capital
Share price | $ 5.085 |
---|---|
Beta | 0.937 |
Diluted Shares Outstanding | 557.25 |
Cost of Debt | |
Tax Rate | 425.40 |
After-tax Cost of Debt | -27.07% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 8.198 |
Total Debt | 113,609.70 |
Total Equity | 2,833.63 |
Total Capital | 116,443.33 |
Debt Weighting | 97.57 |
Equity Weighting | 2.43 |
Wacc |
Build Up Free Cash Flow
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Revenue | 101,282.33 | 101,757.18 | 97,361.63 | 103,521.80 | 75,526.60 | 70,888.04 | 66,534.36 | 62,448.06 | 58,612.73 | 55,012.96 |
---|---|---|---|---|---|---|---|---|---|---|
Operating Cash Flow | 33,714.50 | 27,269.08 | 33,160.92 | 29,396.06 | 6,876.33 | 18,664.24 | 17,517.95 | 16,442.06 | 15,432.25 | 14,484.46 |
Capital Expenditure | -26,273.94 | -21,215.03 | -21,366.92 | -25,167.25 | -19,182.39 | -16,792.69 | -15,761.34 | -14,793.34 | -13,884.79 | -13,032.04 |
Free Cash Flow | 7,440.55 | 6,054.05 | 11,794 | 4,228.81 | -12,306.06 | 1,871.55 | 1,756.60 | 1,648.72 | 1,547.46 | 1,452.42 |
WACC | ||||||||||
PV LFCF | 2,536.32 | 3,226.11 | 4,103.50 | 5,219.51 | 6,639.04 | |||||
SUM PV LFCF | 21,724.49 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | -26.21 |
Free cash flow (t + 1) | 1,481.47 |
Terminal Value | -5,251.58 |
Present Value of Terminal Value | -24,005.05 |
Intrinsic Value
Enterprise Value | -2,280.57 |
---|---|
Net Debt | 62,478.70 |
Equity Value | -64,759.27 |
Shares Outstanding | 557.25 |
Equity Value Per Share | -116.21 |