Discounted Cash Flow
Take TWO Interactive Software Inc.
—
—
Average annual growth rates
| Metric | 10-Year | 5-Year | 3-Year |
|---|---|---|---|
| Sales | — | — | — |
| Free Cash Flow | — | — | — |
| Average (FCF & NI) | — | — | — |
| Net Income | — | — | — |
Endpoint CAGR (better for long term trend)
| Metric | 10-Year | 5-Year | 3-Year |
|---|---|---|---|
| Sales | — | — | — |
| Free Cash Flow | — | — | — |
| Average (FCF & NI) | — | — | — |
| Net Income | — | — | — |
Projected growth rate
—
—
%
%
Historical inputs (10 fiscal years)
| YEAR | Sales | Net Income | Free Cash Flow | Net Margin | EPS (diluted) |
|---|---|---|---|---|---|
| 2017 | $1.8b | $67.3m | $310.3m | 3.8% | $0.73 |
| 2018 | $1.8b (0.7%) | $173.5m (157.8%) | $332.4m (7.1%) | 9.7% (155.9%) | $1.57 (115.1%) |
| 2019 | $2.7b (48.8%) | $333.8m (92.4%) | $776.5m (133.6%) | 12.5% (29.3%) | $2.95 (87.9%) |
| 2020 | $3.1b (15.8%) | $404.5m (21.2%) | $632.3m (-18.6%) | 13.1% (4.7%) | $3.58 (21.4%) |
| 2021 | $3.4b (9.2%) | $588.9m (45.6%) | $843.4m (33.4%) | 17.5% (33.3%) | $5.14 (43.6%) |
| 2022 | $3.5b (3.9%) | $418.0m (-29.0%) | $99.3m (-88.2%) | 11.9% (-31.7%) | $3.62 (-29.6%) |
| 2023 | $5.3b (52.6%) | $-1.1b (-369.1%) | $-203.1m (-304.4%) | -21.0% (-276.3%) | $-7.03 (-294.2%) |
| 2024 | $5.3b (-0.0%) | $-3.7b (-232.9%) | $-157.8m (22.3%) | -70.0% (-232.9%) | $-22.01 (-213.1%) |
| 2025 | $5.6b (5.3%) | $-4.5b (-19.6%) | $-214.6m (-36.0%) | -79.5% (-13.6%) | $-25.58 (-16.2%) |
| 2026 | $6.7b (18.2%) | $-298.2m (93.3%) | $461.5m (315.1%) | -4.5% (94.4%) | $-1.62 (93.7%) |
Base FCF: — (latest fiscal year)
Discount rate: % —
Terminal growth: —
Projection period: — years
Alt A decline yrs:
Alt B total yrs:
Values abbreviated: b = billions, m = millions, k = thousands.
Projected cash flows
| Year | Projected cash flow | Discount Factor | Present Value |
|---|
PV of projected FCF: —
Terminal FCF: —
Terminal value: —
PV of terminal value: —
Enterprise value (DCF): —
Current price: —
—Alternative DCF Models
| Model | Fair Value | Upside | PV(FCFs) | PV(Terminal) | Total Years |
|---|---|---|---|---|---|
| Standard (10yr→TV) | — | — | — | — | 10 + TV |
| Alt A (Gradual Decline) | — | — | — | — | — |
| Alt B (30yr Hard Stop) | — | — | — | N/A | — |
This is a simplified DCF model for illustration. It uses reported free cash flow, a single growth assumption, fixed WACC, and a Gordon Growth terminal value. It is not investment advice.