THE SHERWIN-WILLIAMS COMPANY (SHW) valuation

1 · Enterprise-value target (what the DCF must match)

Market cap   = price × diluted shares
             = $337.70 × 247.7M
             = $83.65B

EV target    = market cap + total debt − cash & equivalents
             = $83.65B + $11.74B − $207.2M
             = $95.18B
            

2 · Starting NOPAT (base year 0)

GAAP EBIT          = $3.34B   (14.2% of revenue)
× (1 − tax rate)  = × (1 − 23.1%) = × 0.7694
= NOPAT₀            = $2.57B
            

3 · Invested capital & starting ROIC

Invested capital = total debt + book equity − cash
                 = $11.74B + $4.60B − $207.2M
                 = $16.13B

Raw ROIC₀        = NOPAT₀ / Invested capital
                 = $2.57B / $16.13B
                 = 15.9%
(no cap applied; raw value is within the 40.0% ceiling)
            

4 · Growth path construction

Source       = analyst consensus: Y1 = 4.5%, Y2 = 4.9%
Clamp        = [2.5%, 60%] (no sub-terminal or 60%+ starts)
Plateau rate = 4.9% (Y2 — held from year 2 through end of plateau)
Tier         = 3 years (rule: plateau rate < 15% → 3y, < 25% → 5y, else 7y)
Plateau      = 3 years
Fade         = linear from effective Y2 to terminal 2.5% across the remaining 7 years

Effective Y1 growth after solver bumps = 6.5%
Effective Y2 growth after solver bumps = 6.9%
Growth by year:
  Y1 = 6.5%
  Y2 = 6.9%
  Y3 = 6.9%
  Y4 = 6.3%
  Y5 = 5.6%
  Y6 = 5.0%
  Y7 = 4.4%
  Y8 = 3.8%
  Y9 = 3.1%
  Y10 = 2.5%
            

5 · Margin path construction

Starting margin (Y0) = 14.2%   (source: latest FY EBIT margin (GAAP))
Target margin (Y10)  = 75.7%   (solver output, widened band)
Year-t margin        = starting + (target − starting) × (t / 10)
Margin by year:
  Y1 = 20.3%
  Y2 = 26.5%
  Y3 = 32.6%
  Y4 = 38.8%
  Y5 = 44.9%
  Y6 = 51.1%
  Y7 = 57.2%
  Y8 = 63.4%
  Y9 = 69.5%
  Y10 = 75.7%
            

6 · ROIC path construction

The capex heuristic compares latest-period CapEx ($797.6M) against the Normalized CapEx (3-yr mean) of $918.7M — mean of the last three annual CapEx values. When the latest is above 1.4× that mean and CapEx is at least 5% of revenue, we treat the filer as capital-intensive and mid-investment, hold ROIC flat for a 5-year harvest phase, and only then fade to terminal ROIC. The 3-yr mean does not feed the DCF directly — it only gates this flag.

Capex-heuristic inactive (latest CapEx 0.87× the 3-yr mean of $918.7M — below the 1.4× / 5%-of-revenue gates).
Fade from Y1: ROIC_t = ROIC₀ + (ROIC_terminal − ROIC₀) × (t / 10)
ROIC₀ = 15.9%; ROIC_terminal = 11.0%

ROIC by year:
  Y1 = 15.4%
  Y2 = 14.9%
  Y3 = 14.4%
  Y4 = 14.0%
  Y5 = 13.5%
  Y6 = 13.0%
  Y7 = 12.5%
  Y8 = 12.0%
  Y9 = 11.5%
  Y10 = 11.0%
            

7 · Solver iterations

Each row is one bisection attempt. The solver sweeps Y1 growth bumps 0pp → +20pp across the plateau ladder inside the normal margin bracket, then — if nothing reconciles — repeats the same sweep in a widened margin band ([-10%, 80%]). The first feasible attempt is the one the page uses. If no combination reconciles, the page shows the attempt whose PV sits closest to the target EV so both levers are balanced.

8 · Terminal value derivation

NOPAT_{N+1}         = NOPAT_{10} × (1 + g_terminal)
                    = $22.55B × (1 + 2.5%)
                    = $23.11B

ΔNOPAT              = NOPAT_{N+1} − NOPAT_{10}
                    = $563.8M
Reinvestment_{N+1}  = ΔNOPAT / ROIC_terminal
                    = $563.8M / 11.0%
                    = $5.13B

FCF_{N+1}           = NOPAT_{N+1} − Reinvestment_{N+1}
                    = $23.11B − $5.13B
                    = $17.99B

Terminal value (TV) = FCF_{N+1} / (WACC − g_terminal)
                    = $17.99B / (9.0% − 2.5%)
                    = $276.76B

PV(TV)              = TV / (1 + WACC)^10
                    = $276.76B / 2.367
                    = $116.91B
            

9 · Reconciliation check (DCF PV vs. the market)

This isn't a fair value — it's the inverse check. The solver built the scenario so that DCF PV reproduces the current enterprise value; if the normal bracket worked the delta below is ~0 by construction. A non-zero delta only appears when the solver fell through to the widened margin band.

Σ PV(FCF_1..10) = -$21.72B
+ PV(TV)          = $116.91B
= Enterprise value = $95.18B   (widened solve — may differ from EV target)
− Total debt      = $11.74B
+ Cash            = $207.2M
= Equity value    = $83.65B
÷ Diluted shares  = 247.7M
= DCF PV / share  = $337.70

Market price      = $337.70
Reconciliation Δ  = −0.0%   (widened band — residual gap the scenario could not close)