Back to SHW Overview
NYQ · Valuation Lab
SHW
The Sherwin-Williams Company
Last$369.68
Market cap89.7B
EV/EBITDA21.3x
Intrinsic value
$153.57
MoS -140.7% · Overvalued
Assuming 10.3% FCF margin and 7.5% Y1–5 growth.
Upside to price
EV (DCF)52B
Terminal share57%
Expected IV$167.17
Probability weights
Projected free cash flows
Stage FCF path with present values · terminal 57% of EV
PV of stage FCFs22.3B
PV of terminal value29.7B
Enterprise value52B
Net cash / (debt)-14.7B
Equity value37.3B
Intrinsic value / share$153.57
| Year | Revenue | FCF | PV | DF |
|---|---|---|---|---|
| Y1 | 26.2B | 2.7B | 2.5B | 91.8% |
| Y2 | 28.2B | 2.9B | 2.5B | 84.3% |
| Y3 | 30.3B | 3.1B | 2.4B | 77.4% |
| Y4 | 32.6B | 3.4B | 2.4B | 71.1% |
| Y5 | 35B | 3.6B | 2.4B | 65.3% |
| Y6 | 36.4B | 3.7B | 2.2B | 60.0% |
| Y7 | 37.8B | 3.9B | 2.1B | 55.1% |
| Y8 | 39.2B | 4B | 2B | 50.6% |
| Y9 | 40.7B | 4.2B | 1.9B | 46.4% |
| Y10 | 42.2B | 4.3B | 1.9B | 42.6% |
| Terminal | — | — | 29.7B | — |
Educational DCF model only — not financial advice. Terminal value and assumptions dominate results; verify filings and run your own diligence.