Take-Two Interactive Software Inc
over ten years, 27x 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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 2017 | 0.4 | 0.1 | 0.0 | 0.3 | -0.2 | 0.1 | 0.09 | $3.30 | $59.27 | 5.6% |
| 2018 | 0.5 | 0.1 | 0.1 | 0.3 | -0.2 | 0.0 | 0.11 | $2.57 | $97.78 | 2.6% |
| 2019 | 0.8 | 0.2 | 0.1 | 0.5 | -0.0 | 0.5 | 0.12 | $4.59 | $94.37 | 4.9% |
| 2020 | 0.7 | 0.3 | 0.1 | 0.4 | 0.0 | 0.4 | 0.11 | $3.28 | $118.61 | 2.8% |
| 2021 | 0.9 | 0.1 | 0.1 | 0.7 | 0.0 | 0.7 | 0.12 | $6.41 | $176.70 | 3.6% |
| 2022 | 0.3 | 0.1 | 0.2 | -0.0 | 0.0 | -0.0 | 0.12 | $-0.30 | $153.74 | -0.2% |
| 2023 | 0.0 | 0.3 | 0.2 | -0.5 | +1.7 | 1.2 | 0.16 | $-3.32 | $119.30 | -2.8% |
| 2024 | -0.0 | 0.3 | 0.1 | -0.5 | +1.3 | 0.9 | 0.17 | $-2.76 | $148.49 | -1.9% |
| 2025 | -0.0 | 0.3 | 0.2 | -0.5 | -0.5 | -1.1 | 0.18 | $-3.02 | $207.25 | -1.5% |
| 2026 | 0.6 | 0.3 | 0.2 | 0.2 | -0.0 | 0.1 | 0.19 | $0.84 | $197.50 | 0.4% |
| 9-yr CAGR | 4.8% | 15.7% | 25.4% | -7.2% | n/a | 9.4% | 8.0% | -14.1% | 14.3% | avg 1.4% |
| Fiscal year | Revenue | EBITDA | EBITDA margin | Debt incl. leases | Cash & securities | Market cap | Enterprise value | EV / EBITDA | Net debt / EBITDA |
|---|---|---|---|---|---|---|---|---|---|
| 2017 | 1.8 | 0.4 | 19.7% | 0.3 | 1.4 | 5 | 4 | 12.4x | -3.25x |
| 2018 | 1.8 | 0.3 | 15.6% | 0.0 | 1.4 | 11 | 10 | 34.3x | -5.05x |
| 2019 | 2.7 | 0.5 | 17.7% | 0.0 | 1.6 | 11 | 9 | 19.7x | -3.33x |
| 2020 | 3.1 | 0.7 | 21.4% | 0.2 | 2.0 | 14 | 12 | 17.7x | -2.76x |
| 2021 | 3.4 | 0.8 | 24.7% | 0.2 | 2.7 | 20 | 18 | 21.5x | -3.05x |
| 2022 | 3.5 | 0.7 | 20.9% | 0.3 | 2.6 | 18 | 16 | 21.4x | -3.15x |
| 2023 | 5.3 | 0.6 | 11.7% | 2.1 | 1.0 | 19 | 20 | 32.3x | 1.80x |
| 2024 | 5.3 | 0.6 | 11.5% | 3.5 | 0.8 | 25 | 28 | 45.3x | 4.43x |
| 2025 | 5.6 | 0.6 | 10.7% | 3.0 | 1.5 | 36 | 38 | 62.7x | 2.48x |
| 2026 | 6.7 | 1.0 | 15.5% | 2.9 | 2.0 | 37 | 38 | 36.4x | 0.91x |
| 9-yr CAGR | 15.8% | 12.7% | avg 16.9% | 31.3% | 4.0% | 23.5% | 27.1% | median 26.9x | avg -1.10x |
| Purchase price | 18x | 22.5x | 27x median | 30x last FYE | 36x |
|---|---|---|---|---|---|
| $71 | 5.0% | 7.8% | 10.0% | 11.3% | 13.5% |
| $157 | -2.3% | 0.1% | 2.2% | 3.4% | 5.4% |
| $188 | -4.0% | -1.5% | 0.4% | 1.6% | 3.6% |
| $209 last close | -4.9% | -2.5% | -0.6% | 0.6% | 2.6% |
| $241 | -6.2% | -3.8% | -1.9% | -0.8% | 1.2% |
Revenue grew 15.8% a year and EBITDA 12.7% a year from FY2017 to FY2026, and free cash flow after stock compensation grew -7.2% a year. The share count rose 8.0% a year, so per-share figures grew more slowly than the totals. Net debt stood at 0.9x EBITDA at the last fiscal year-end. At 36x EBITDA at the last fiscal year-end against a ten-year median of 27x, the model prices the last close of $209 as a -0.6% ten-year return; the grid shows how that changes if the multiple holds.
From the data: The share count moved 22% 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. The share count moved 37% in FY2023 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.