Discounted Cash Flow
Stem, 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) |
|---|---|---|---|---|---|
| 2019 | $17.6m | $-10.4k | $-5.4m | -0.1% | $-1.51 |
| 2020 | $36.3m (106.9%) | $-156.1m (-1500226.7%) | $-7.7m (-42.7%) | -430.0% (-725207.4%) | $-4.13 (-173.5%) |
| 2021 | $127.4m (250.8%) | $-101.2m (35.2%) | $-107.2m (-1298.8%) | -79.5% (81.5%) | $-0.96 (76.8%) |
| 2022 | $363.0m (185.0%) | $-124.1m (-22.6%) | $-122.8m (-14.5%) | -34.2% (57.0%) | $-0.81 (15.6%) |
| 2023 | $461.5m (27.1%) | $-140.4m (-13.2%) | $-221.5m (-80.4%) | -30.4% (11.0%) | $-0.90 (-11.1%) |
| 2024 | $144.6m (-68.7%) | $-854.0m (-508.2%) | $-47.9m (78.4%) | -590.7% (-1841.4%) | $-5.29 (-487.8%) |
| 2025 | $156.3m (8.1%) | $137.8m (116.1%) | $259.0k (100.5%) | 88.2% (114.9%) | $16.52 (412.3%) |
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.