XEL · Nasdaq · Financial statements
XCEL ENERGY INC: cash-flow calculator
A discounted cash flow model turns assumptions about future free cash flow into a single amount today. Here the assumptions are yours: the page shows what they add up to, and, the other way round, what yearly growth a share price takes for granted.
- Free cash flow
- -$835M
- FY 2018
- 5-year average
- -$456M
- FY 2014–2018
- Net debt
- $17.1B
- FY 2018
- Diluted shares
- 511.0M
- FY 2018
A cash-flow model does not fit these figures well
- Free cash flow was negative in 2018. Growing a negative number gives a negative value, so the latest year is no base for this model.
You can still enter your own starting free cash flow below, for example what you expect once heavy investment ends. That is your assumption, not a figure from the reports.
Your assumptions
money in USDGrowth usually slows as a company gets bigger.
For ever, so it is usually kept at or below long-run growth of the economy, often 0–3%.
The yearly return you require: a risk-free rate plus a premium for risk. Higher means later cash counts for less.
From the FY 2018 balance sheet. Negative means more cash than debt.
Weighted average, diluted, FY 2018.
EdgeScore has no licensed price feed for US shares yet. Type the current share price yourself.
Growing a starting free cash flow of zero or less only gives zero or less, so the model has no meaningful answer here. Pick a positive base above, or type your own starting figure under “My own”.
What the price implies
Enter a share price to see the growth it implies.
- Your assumption, years 1–55.0%
- Revenue, FY 2013–20181.1%
- Revenue, FY 2015–20181.5%
Where the starting figures come from
Operating cash flow and free cash flow
| FY | Revenue | Op. cash flow | Capex | Free cash flow |
|---|---|---|---|---|
| 2018 | $11.5B | $3.1B | $4.0B | -$835M |
| 2017 | $11.4B | $3.1B | $3.2B | -$118M |
| 2016 | $11.1B | $3.1B | $3.2B | -$143M |
| 2015 | $11.0B | $3.0B | $3.7B | -$645M |
| 2014 | $11.7B | $2.7B | $3.2B | -$540M |
| 2013 | $10.9B | $2.6B | $3.4B | -$811M |
| 2012 | $10.1B | $2.0B | $0 | $2.0B |
| 2011 | $10.7B | $2.4B | $0 | $2.4B |
| 2010 | $10.3B | $1.9B | $732M | $1.2B |
| 2009 | $9.6B | $1.9B | $0 | $1.9B |
Free cash flow = operating cash flow − capital expenditure. Source: SEC EDGAR, annual reports.
How it works: free cash flow (operating cash flow minus capital expenditure) grows at your stage 1 rate for years 1–5 and your stage 2 rate for years 6–10; after that, a terminal value assumes your terminal growth for ever. Each year is discounted at your rate, net debt (financial debt minus cash, latest balance sheet) is subtracted and the total is divided by diluted shares. The reverse calculation finds, by bisection, the stage 1 growth at which this equals the share price. Operating cash flow is after interest, so subtracting net debt as well is a simplification you can switch off.
The output is arithmetic on your inputs. It is not an EdgeScore estimate of what the shares are worth and not a price target. Figures: SEC EDGAR, annual reports, with the fiscal year shown next to each one.
For information and education only, not investment advice. Data may contain errors.