Discounted Cash Flow
Pinnacle West Capital Corp.
—
—
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) |
|---|---|---|---|---|---|
| 2016 | $3.5b | $433.8m | $-252.1m | 12.4% | $3.97 |
| 2017 | $3.6b (1.9%) | $478.5m (10.3%) | $-290.7m (-15.3%) | 13.4% (8.2%) | $4.37 (10.1%) |
| 2018 | $3.7b (3.5%) | $421.5m (-11.9%) | $99.0m (134.0%) | 11.4% (-14.9%) | $4.56 (4.3%) |
| 2019 | $3.5b (-6.0%) | $439.5m (4.3%) | $-234.7m (-337.2%) | 12.7% (10.9%) | $4.79 (5.0%) |
| 2020 | $3.6b (3.3%) | $481.0m (9.5%) | $-360.2m (-53.5%) | 13.4% (5.9%) | $4.89 (2.1%) |
| 2021 | $3.8b (6.0%) | $462.0m (-4.0%) | $-613.5m (-70.3%) | 12.1% (-9.4%) | $5.48 (12.1%) |
| 2022 | $4.3b (13.7%) | $401.5m (-13.1%) | $-466.0m (24.0%) | 9.3% (-23.5%) | $4.27 (-22.1%) |
| 2023 | $4.7b (8.6%) | $416.4m (3.7%) | $-638.7m (-37.0%) | 8.9% (-4.5%) | $4.42 (3.5%) |
| 2024 | $5.1b (9.1%) | $524.1m (25.9%) | $-639.4m (-0.1%) | 10.2% (15.3%) | $5.35 (21.0%) |
| 2025 | $5.3b (4.2%) | $631.6m (20.5%) | $-819.5m (-28.2%) | 11.8% (15.7%) | $5.15 (-3.7%) |
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.