Discounted Cash Flow
Equitable Holdings, 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 | $12.5b | $834.0m | $-243.0m | 6.7% | $2.24 |
| 2018 | $12.1b (-3.1%) | $1.8b (118.2%) | $61.0m (125.1%) | 15.1% (125.1%) | $3.87 (72.8%) |
| 2019 | $9.6b (-20.6%) | $-1.7b (-195.2%) | $-216.0m (-454.1%) | -18.1% (-219.9%) | $-2.91 (-175.1%) |
| 2020 | $12.4b (29.4%) | $-648.0m (62.6%) | $-61.0m (71.8%) | -5.2% (71.1%) | $-0.77 (73.4%) |
| 2021 | $11.0b (-11.1%) | $-439.0m (32.3%) | $-756.0m (-1139.3%) | -4.0% (23.8%) | $-0.06 (92.6%) |
| 2022 | $14.0b (27.0%) | $1.8b (506.6%) | $-1.0b (-34.7%) | 12.7% (420.1%) | $5.37 (9431.4%) |
| 2023 | $10.5b (-24.9%) | $1.3b (-27.1%) | $-325.0m (68.1%) | 12.4% (-2.9%) | $4.69 (-12.5%) |
| 2024 | $12.4b (18.1%) | $1.3b (0.4%) | $1.9b (670.2%) | 10.5% (-15.0%) | $5.68 (20.9%) |
| 2025 | $11.7b (-6.2%) | $-1.4b (-205.6%) | $680.0m (-63.3%) | -11.8% (-212.6%) | $-3.48 (-161.3%) |
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.