Discounted Cash Flow
Celestica 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) |
|---|---|---|---|---|---|
| 2016 | $6.0b | $136.3m | $173.3m | 2.3% | $0.96 |
| 2017 | $6.1b (1.6%) | $105.0m (-23.0%) | $24.4m (-85.9%) | 1.7% (-24.1%) | $0.73 (-24.0%) |
| 2018 | $6.6b (8.6%) | $98.9m (-5.8%) | $-49.1m (-301.2%) | 1.5% (-13.2%) | $0.71 (-2.7%) |
| 2019 | $5.9b (-11.2%) | $70.3m (-28.9%) | $264.5m (638.7%) | 1.2% (-19.9%) | $0.54 (-23.9%) |
| 2020 | $5.7b (-2.4%) | $60.6m (-13.8%) | $186.8m (-29.4%) | 1.1% (-11.7%) | $0.47 (-13.0%) |
| 2021 | $5.6b (-2.0%) | $103.9m (71.5%) | $174.6m (-6.5%) | 1.8% (74.9%) | $0.82 (74.5%) |
| 2022 | $7.2b (28.7%) | $145.5m (40.0%) | $102.1m (-41.5%) | 2.0% (8.8%) | $1.18 (43.9%) |
| 2023 | $8.0b (9.8%) | $244.6m (68.1%) | $201.1m (97.0%) | 3.1% (53.1%) | $2.04 (72.9%) |
| 2024 | $9.6b (21.2%) | $428.0m (75.0%) | $303.0m (50.7%) | 4.4% (44.4%) | $3.62 (77.5%) |
| 2025 | $12.4b (28.5%) | $832.5m (94.5%) | $458.3m (51.3%) | 6.7% (51.4%) | $7.22 (99.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.