OKE · NYQ · Energy
ONEOK, Inc.
Also onShortfallConsensus DriftCrosscheck
Implied value per share
USD 85.19
Market price
USD 92.52
Implied upside
-7.9%
10-year forecast · Perpetuity growth terminal value · Mid-year discounting · Base case · Price 2026-11-02 · Accounts to 2025-12-31
Value Per Share
Same forecast, different terminal treatment. Percentages vs price.
Forecast Cashflows
Reporting currency (USD). Outflows negative.
| Line | FY26 | FY27 | FY28 | FY29 | FY30 | FY31 | FY32 | FY33 | FY34 | FY35 | CAGR |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | USD 44.5bn | USD 42.7bn | USD 41.4bn | USD 40.5bn | USD 39.9bn | USD 39.6bn | USD 39.6bn | USD 40.0bn | USD 40.6bn | USD 41.7bn | -0.7% |
| EBIT | USD 8.6bn | USD 8.2bn | USD 8.0bn | USD 7.8bn | USD 7.7bn | USD 7.6bn | USD 7.6bn | USD 7.7bn | USD 7.8bn | USD 8.0bn | -0.7% |
| NOPAT | USD 6.8bn | USD 6.5bn | USD 6.3bn | USD 6.2bn | USD 6.1bn | USD 6.0bn | USD 6.0bn | USD 6.1bn | USD 6.2bn | USD 6.3bn | -0.7% |
| Add depreciation & amortisation | USD 1.9bn | USD 1.8bn | USD 1.7bn | USD 1.7bn | USD 1.7bn | USD 1.7bn | USD 1.7bn | USD 1.7bn | USD 1.7bn | USD 1.8bn | -0.7% |
| Less capital expenditure | USD -3.7bn | USD -3.6bn | USD -3.5bn | USD -3.4bn | USD -3.4bn | USD -3.4bn | USD -3.4bn | USD -3.4bn | USD -3.5bn | USD -3.6bn | -0.2% |
| Capex, % of revenue | 8.3% | 8.3% | 8.4% | 8.4% | 8.5% | 8.5% | 8.5% | 8.6% | 8.6% | 8.7% | - |
| Less increase in working capital | USD -404.3m | USD 64.7m | USD 49.4m | USD 35.5m | USD 22.7m | USD 10.4m | USD -1.5m | USD -13.3m | USD -25.3m | USD -37.9m | -23.1% |
| Free cashflow to firm | USD 4.6bn | USD 4.8bn | USD 4.6bn | USD 4.5bn | USD 4.4bn | USD 4.3bn | USD 4.3bn | USD 4.3bn | USD 4.4bn | USD 4.4bn | -0.3% |
| Discount factor | 0.9666 | 0.9032 | 0.8440 | 0.7886 | 0.7369 | 0.6886 | 0.6434 | 0.6012 | 0.5618 | 0.5249 | - |
| Present value | USD 4.4bn | USD 4.4bn | USD 3.9bn | USD 3.6bn | USD 3.2bn | USD 3.0bn | USD 2.8bn | USD 2.6bn | USD 2.5bn | USD 2.3bn | - |
| Present Value Of The Forecast | USD 32.6bn | ||||||||||
Discount Rate
Source shown per component. All overridable above.
| Risk-free rate | 4.89% | US 10-year Treasury (^TNX), 2026-11-02 |
| Equity risk premium | 4.23% | Damodaran, January 2026 |
| Beta | 0.828 | Reported 0.744, pulled toward 1.0 (Blume) |
| Cost of equity | 8.40% | Risk-free + beta x equity risk premium |
| Cost of debt | 5.78% | Risk-free + 89bp, the spread for a A- rating at 3.3x interest cover. Book interest / average debt was lower, at 5.5%. |
| Market capitalisation | USD 58.3bn | 64.0% of capital |
| Total debt | USD 32.8bn | 36.0% of capital, book value as a proxy |
| Tax rate | 21.0% | Effective, capped at statutory |
| WACC | 7.02% | E/V x Re + D/V x Rd x (1 - t) |
Terminal Value
Perpetuity growth is intrinsic. The exit multiple defaults to the company's current EV/EBITDA, so it answers a different question - what the shares are worth if today's rating holds and EBITDA grows as forecast.
Perpetuity growth at 2.50%
62% of EV
- Forecast FCFF, final year
- USD 4.4bn
- Capex at depreciation, working capital in reinvestment
- USD 6.3bn
- Less reinvestment at g/ROIC (29.3% of NOPAT)
- USD -1.9bn
- Capitalised
- USD 4.5bn
- ROIC (reported)
- 8.5%
- Terminal value, undiscounted
- USD 101.8bn
- Terminal value, discounted
- USD 53.4bn
- Enterprise value
- USD 86.1bn
- Less net debt
- USD 32.7bn
- Equity value
- USD 53.3bn
Exit at 12.4x EBITDA
66% of EV
- Terminal value, undiscounted
- USD 121.5bn
- Terminal value, discounted
- USD 63.8bn
- Enterprise value
- USD 96.4bn
- Less net debt
- USD 32.7bn
- Equity value
- USD 63.7bn
Spread between methods: 18%.
Sensitivity
Value per share (USD) by discount rate and long-run growth.
| Long-run growth | |||||
|---|---|---|---|---|---|
| Discount rate | 1.50% | 2.00% | 2.50% | 3.00% | 3.50% |
| 5.02% | 159.88 | 171.14 | 187.54 | 212.90 | 256.06 |
| 6.02% | 113.65 | 117.04 | 121.86 | 128.81 | 139.16 |
| 7.02% | 84.18 | 84.48 | 85.19 | 86.46 | 88.51 |
| 8.02% | 63.76 | 62.72 | 61.76 | 60.90 | 60.16 |
| 9.02% | 49.60 | 48.31 | 47.02 | 45.72 | 44.43 |
Outlined: this model. Green text: above today's price of 92.52. Shading: distance from this model's own value.
Priced In
What each input would have to be to justify the current price, one at a time.
| Input | Actual | Model | Implied | Gap |
|---|---|---|---|---|
| Revenue growth, a year | 14.5% | 2.2% | 2.8% | |
| EBIT margin | 23.9% | 19.3% | 20.2% | |
| Discount rate | - | 7.0% | 6.8% |
Live formulas, not pasted numbers - edit a driver and the workbook reprices.
Yahoo Finance and RBA data. General information, not advice. Methodology.