Discounted Cash Flow
National Grid Plc. ADR
—
—
Average annual growth rates
| Metric | 10-Year | 5-Year | 3-Year |
|---|---|---|---|
| Sales | — | — | — |
| Free Cash Flow | — | — | — |
| Average (FCF & NI) | — | — | — |
| Net Income | — | — | — |
| Dividends | — | — | — |
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 | $15.0b | $2.2b | $-2.4b | 14.5% | $2.07 |
| 2018 | $15.2b (1.4%) | $3.5b (62.5%) | $-1.2b (48.7%) | 23.3% (60.3%) | $1.03 (-50.5%) |
| 2019 | $14.9b (-2.1%) | $1.5b (-57.4%) | $-71.0m (94.2%) | 10.1% (-56.5%) | $0.45 (-56.5%) |
| 2020 | $14.5b (-2.6%) | $1.3b (-16.3%) | $-97.0m (-36.6%) | 8.7% (-14.1%) | $0.36 (-18.2%) |
| 2021 | $14.8b (1.6%) | $1.6b (29.7%) | $-4.4b (-4396.9%) | 11.1% (27.6%) | $0.47 (27.7%) |
| 2022 | $18.4b (24.8%) | $2.4b (43.5%) | $-4.3b (1.1%) | 12.8% (14.9%) | $0.65 (40.3%) |
| 2023 | $21.7b (17.4%) | $7.8b (231.4%) | $-5.8b (-33.7%) | 36.0% (182.3%) | $2.13 (225.8%) |
| 2024 | $19.9b (-8.4%) | $2.3b (-70.6%) | $-6.9b (-19.7%) | 11.5% (-68.0%) | $0.62 (-70.9%) |
| 2025 | $18.4b (-7.4%) | $2.9b (26.7%) | $-8.8b (-27.2%) | 15.8% (36.9%) | $0.62 (-0.6%) |
| 2026 | $17.7b (-3.8%) | $4.2b (44.1%) | $-2.2b (75.4%) | 23.6% (49.7%) | $0.66 (6.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.