Charter Communications Inc
over ten years, 8x exit
| Fiscal year | Operating cash flow | Stock comp | Capex | Free cash flow | Net borrowing | FCFE | Shares (B) | FCF per share | Year-end price | FCF yield |
|---|---|---|---|---|---|---|---|---|---|---|
| 2016 | 8.0 | 0.5 | 33.5 | -26.0 | +24.0 | -2.0 | 0.23 | $-110.66 | $287.92 | -38.4% |
| 2017 | 12.0 | 0.3 | 7.9 | 3.8 | +8.5 | 12.2 | 0.30 | $12.72 | $335.96 | 3.8% |
| 2018 | 11.8 | 0.3 | 9.6 | 1.9 | +1.4 | 3.2 | 0.24 | $8.01 | $284.97 | 2.8% |
| 2019 | 11.7 | 0.3 | 7.1 | 4.3 | +6.0 | 10.3 | 0.22 | $19.18 | $485.08 | 4.0% |
| 2020 | 14.6 | 0.4 | 8.0 | 6.3 | +6.2 | 12.4 | 0.21 | $29.89 | $661.55 | 4.5% |
| 2021 | 16.2 | 0.4 | 7.6 | 8.3 | +6.8 | 15.1 | 0.19 | $42.76 | $651.97 | 6.6% |
| 2022 | 14.9 | 0.5 | 8.8 | 5.6 | +7.5 | 13.2 | 0.16 | $34.25 | $339.10 | 10.1% |
| 2023 | 14.4 | 0.7 | 10.9 | 2.8 | -0.3 | 2.5 | 0.15 | $18.41 | $388.68 | 4.7% |
| 2024 | 14.4 | 0.7 | 11.3 | 2.5 | -2.6 | -0.1 | 0.15 | $17.27 | $342.77 | 5.0% |
| 2025 | 16.1 | 0.7 | 11.7 | 3.7 | +2.2 | 6.0 | 0.14 | $27.19 | $208.75 | 13.0% |
| 9-yr CAGR | 8.0% | 3.5% | -11.1% | n/m | n/a | n/m | -5.8% | n/m | -3.5% | avg 1.6% |
| Fiscal year | Revenue | EBITDA | EBITDA margin | Debt incl. leases | Cash & securities | Market cap | Enterprise value | EV / EBITDA | Net debt / EBITDA |
|---|---|---|---|---|---|---|---|---|---|
| 2016 | 29.0 | 10.3 | 35.7% | 59.7 | 1.5 | 68 | 126 | 12.2x | 5.62x |
| 2017 | 41.6 | 15.0 | 36.2% | 68.2 | 0.6 | 100 | 167 | 11.1x | 4.49x |
| 2018 | 43.6 | 15.8 | 36.2% | 69.5 | 0.6 | 67 | 136 | 8.6x | 4.37x |
| 2019 | 45.8 | 16.5 | 36.1% | 76.8 | 3.5 | 109 | 182 | 11.0x | 4.43x |
| 2020 | 48.1 | 18.2 | 37.8% | 82.0 | 137.8 | 138 | 83 | 4.5x | -3.08x |
| 2021 | 51.7 | 20.2 | 39.1% | 88.8 | 0.6 | 126 | 214 | 10.6x | 4.37x |
| 2022 | 54.0 | 21.1 | 39.1% | 96.4 | 0.6 | 56 | 152 | 7.2x | 4.53x |
| 2023 | 54.6 | 21.2 | 38.8% | 95.8 | 20.5 | 59 | 134 | 6.3x | 3.55x |
| 2024 | 55.1 | 21.9 | 39.8% | 93.2 | 0.5 | 50 | 143 | 6.5x | 4.23x |
| 2025 | 54.8 | 22.1 | 40.3% | 95.5 | 0.5 | 29 | 124 | 5.6x | 4.31x |
| 9-yr CAGR | 7.3% | 8.8% | avg 37.9% | 5.3% | -12.2% | -9.1% | -0.2% | median 7.9x | avg 3.68x |
| Purchase price | 5.5x last FYE | 6.5x | 8x median | 10.5x |
|---|---|---|---|---|
| $82 | 39.7% | 42.2% | 45.2% | 49.1% |
| $99 | 34.8% | 37.5% | 40.6% | 44.6% |
| $110 last close | 32.4% | 35.0% | 38.2% | 42.2% |
| $126 | 29.4% | 32.1% | 35.3% | 39.3% |
| $626 | 4.1% | 6.8% | 10.0% | 13.9% |
Revenue grew 7.3% a year and EBITDA 8.8% a year from FY2016 to FY2025, and free cash flow after stock compensation did not grow from a positive base. The share count fell 5.8% a year through buybacks. Net debt stood at 4.3x EBITDA at the last fiscal year-end. At 6x EBITDA at the last fiscal year-end against a ten-year median of 8x, the model prices the last close of $110 as a 38.3% ten-year return; the grid shows how that changes if the multiple holds.
From the data: The share count moved 132% in FY2016 with no split on record (a merger, offering or buyback), so per-share figures before and after that year are not on one basis. The share count moved 26% in FY2017 with no split on record (a merger, offering or buyback), so per-share figures before and after that year are not on one basis. The share count moved 21% in FY2018 with no split on record (a merger, offering or buyback), so per-share figures before and after that year are not on one basis.
- Free cash flow is operating cash flow less stock-based compensation less capital spending. Stock comp is treated as a real cost.
- Net borrowing is the year's change in long-term debt. FCFE adds it back to free cash flow, the classic one-page definition.
- EBITDA is operating income plus depreciation and amortization. Debt includes lease obligations; cash includes short-term investments.
- Market cap uses the fiscal year-end price as traded, restated for later splits but not for dividends; enterprise value adds debt and subtracts cash.
- Share count is the yearly change in shares outstanding over the period; flat or falling clears. Cash margin is the latest free cash flow margin against its three-year average; within two points clears.
- Hurdle price is the present value, at the hurdle rate, of ten years of modeled free cash flow per share plus a year-10 sale at the exit multiple. It is shown as an exhibit: the 2011 to 2021 back-test found that buying below it did not sort winners from losers, so it is not scored.
- Cleared on a check means the number clears the stated rule; Not cleared means it does not. Durable, Holding and First year say how many fiscal years running the company has cleared all four staying-power checks (four or more, two or three, one); Partial and Not cleared count the checks it clears today. All of it is fact about the filings, not a rating of the stock.