Discounted Cash Flow
Sphere Entertainment Co.
—
—
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) |
|---|---|---|---|---|---|
| 2018 | $989.0m | $6.9m | $135.0m | 0.7% | $0.29 |
| 2019 | $1.0b (6.1%) | $-17.9m (-359.4%) | $59.8m (-55.7%) | -1.7% (-344.6%) | $-0.75 (-358.6%) |
| 2020 | $762.9m (-27.3%) | $17.2m (196.3%) | $17.2m (-71.2%) | 2.3% (232.4%) | $0.72 (196.0%) |
| 2021 | $180.4m (-76.4%) | $-412.1m (-2491.1%) | $-745.5m (-4425.7%) | -228.4% (-10212.2%) | $-17.39 (-2515.3%) |
| 2022 | $1.7b (856.0%) | $-194.4m (52.8%) | $-615.4m (17.5%) | -11.3% (95.1%) | $-5.77 (66.8%) |
| 2023 | $573.8m (-66.7%) | $502.8m (358.6%) | $-905.4m (-47.1%) | 87.6% (877.3%) | $14.51 (351.5%) |
| 2024 | $1.0b (79.0%) | $-200.6m (-139.9%) | $-284.4m (68.6%) | -19.5% (-122.3%) | $-5.68 (-139.1%) |
| 2025 | $1.2b (18.8%) | $33.4m (116.6%) | $191.0m (167.2%) | 2.7% (114.0%) | $0.93 (116.4%) |
Base FCF: — (latest fiscal year)
Discount rate: % —
Terminal growth: —
Projection period: — years
Alt A decline yrs:
Alt B total yrs:
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.