DOW · NYQ · Basic Materials
Dow Inc.
Also onShortfallConsensus DriftCrosscheck
Implied value per share
USD 13.61
Market price
USD 34.18
Implied upside
-60.2%
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 43.9bn | USD 43.0bn | USD 42.4bn | USD 42.1bn | USD 41.9bn | USD 42.1bn | USD 42.4bn | USD 43.0bn | USD 43.8bn | USD 44.9bn | +0.3% |
| EBIT | USD 2.1bn | USD 2.1bn | USD 2.1bn | USD 2.1bn | USD 2.1bn | USD 2.1bn | USD 2.1bn | USD 2.1bn | USD 2.1bn | USD 2.2bn | +0.3% |
| NOPAT | USD 1.7bn | USD 1.7bn | USD 1.6bn | USD 1.6bn | USD 1.6bn | USD 1.6bn | USD 1.6bn | USD 1.7bn | USD 1.7bn | USD 1.7bn | +0.3% |
| Add depreciation & amortisation | USD 2.7bn | USD 2.6bn | USD 2.6bn | USD 2.6bn | USD 2.6bn | USD 2.6bn | USD 2.6bn | USD 2.6bn | USD 2.7bn | USD 2.8bn | +0.3% |
| Less capital expenditure | USD -2.5bn | USD -2.5bn | USD -2.6bn | USD -2.6bn | USD -2.7bn | USD -2.8bn | USD -2.9bn | USD -3.1bn | USD -3.2bn | USD -3.4bn | +3.7% |
| Capex, % of revenue | 5.6% | 5.8% | 6.1% | 6.3% | 6.5% | 6.7% | 6.9% | 7.2% | 7.4% | 7.6% | - |
| Less increase in working capital | USD -569.3m | USD 124.8m | USD 87.5m | USD 51.9m | USD 17.5m | USD -16.6m | USD -50.6m | USD -85.4m | USD -121.4m | USD -159.2m | -13.2% |
| Free cashflow to firm | USD 1.3bn | USD 1.9bn | USD 1.8bn | USD 1.6bn | USD 1.5bn | USD 1.4bn | USD 1.2bn | USD 1.1bn | USD 1.0bn | USD 911.5m | -4.3% |
| Discount factor | 0.9689 | 0.9095 | 0.8538 | 0.8015 | 0.7524 | 0.7063 | 0.6630 | 0.6224 | 0.5842 | 0.5484 | - |
| Present value | USD 1.3bn | USD 1.7bn | USD 1.5bn | USD 1.3bn | USD 1.1bn | USD 958.2m | USD 822.5m | USD 702.6m | USD 595.8m | USD 499.9m | - |
| Present Value Of The Forecast | USD 10.5bn | ||||||||||
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.589 | Reported 0.386, pulled toward 1.0 (Blume) |
| Cost of equity | 7.38% | Risk-free + beta x equity risk premium |
| Cost of debt | 6.89% | Risk-free + 200bp, the spread for a D rating at 0.2x interest cover, capped at 200bp because one year's cover is too noisy to charge more. Book interest / average debt was lower, at 4.6%. |
| Market capitalisation | USD 24.7bn | 55.8% of capital |
| Total debt | USD 19.6bn | 44.2% of capital, book value as a proxy |
| Tax rate | 21.0% | Effective, capped at statutory |
| WACC | 6.53% | 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%
59% of EV
- Forecast FCFF, final year
- USD 911.5m
- Capex at depreciation, working capital in reinvestment
- USD 1.7bn
- Less reinvestment at g/ROIC (38.3% of NOPAT)
- USD -664.6m
- Capitalised
- USD 1.1bn
- ROIC (WACC floor)
- 6.5%
- Terminal value, undiscounted
- USD 27.2bn
- Terminal value, discounted
- USD 14.9bn
- Enterprise value
- USD 25.5bn
- Less net debt
- USD 15.8bn
- Equity value
- USD 9.7bn
Exit at 13.5x EBITDA
78% of EV
- Terminal value, undiscounted
- USD 67.1bn
- Terminal value, discounted
- USD 36.8bn
- Enterprise value
- USD 47.3bn
- Less net debt
- USD 15.8bn
- Equity value
- USD 31.5bn
Spread between methods: 106%.
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% |
| 4.53% | 31.41 | 31.35 | 31.63 | 32.55 | 35.10 |
| 5.53% | 20.95 | 20.35 | 19.74 | 19.14 | 18.53 |
| 6.53% | 14.58 | 14.09 | 13.61 | 13.12 | 12.64 |
| 7.53% | 9.89 | 9.50 | 9.10 | 8.70 | 8.30 |
| 8.53% | 6.31 | 5.97 | 5.64 | 5.31 | 4.98 |
Outlined: this model. Green text: above today's price of 34.18. 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 | -11.1% | 1.2% | 7.9% | |
| EBIT margin | 10.0% | 4.9% | 7.7% | |
| Discount rate | - | 6.5% | 4.4% |
Live formulas, not pasted numbers - edit a driver and the workbook reprices.
Yahoo Finance and RBA data. General information, not advice. Methodology.