Discounted Cash Flow
QXO Insulation, LLC
—
—
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) |
|---|---|---|---|---|---|
| 2016 | $1.7b | $72.6m | $62.6m | 4.2% | $1.93 |
| 2017 | $1.9b (9.4%) | $158.1m (117.8%) | $87.9m (40.3%) | 8.3% (99.1%) | $4.41 (128.5%) |
| 2018 | $2.4b (25.1%) | $134.8m (-14.8%) | $114.7m (30.5%) | 5.7% (-31.9%) | $3.86 (-12.5%) |
| 2019 | $2.6b (10.1%) | $191.0m (41.7%) | $226.2m (97.3%) | 7.3% (28.8%) | $5.65 (46.4%) |
| 2020 | $2.7b (3.6%) | $247.0m (29.3%) | $316.9m (40.1%) | 9.1% (24.9%) | $7.50 (32.7%) |
| 2021 | $3.5b (28.3%) | $324.0m (31.2%) | $347.5m (9.6%) | 9.3% (2.3%) | $9.88 (31.7%) |
| 2022 | $5.0b (43.7%) | $556.0m (71.6%) | $419.4m (20.7%) | 11.1% (19.4%) | $17.26 (74.7%) |
| 2023 | $5.2b (3.7%) | $614.3m (10.5%) | $785.4m (87.3%) | 11.8% (6.5%) | $19.44 (12.6%) |
| 2024 | $5.3b (2.6%) | $622.6m (1.4%) | $706.7m (-10.0%) | 11.7% (-1.2%) | $20.41 (5.0%) |
| 2025 | $5.4b (1.5%) | $521.7m (-16.2%) | $696.9m (-1.4%) | 9.6% (-17.4%) | $18.41 (-9.8%) |
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.