THE SHERWIN-WILLIAMS COMPANY (SHW)

Every figure this model derived for SHW, the value it took, and the element in the company's own XBRL it was read from — so any of it can be checked against the filing rather than taken on trust. As at 2026-06-30.

The figures, and where each came from

This is the part no other screener shows. Each figure below names the XBRL element it was read from, so it can be checked against the filing itself.

FigureValueXBRL tagAs at
capex 673,500,000 PaymentsToAcquireProductiveAssets 2026-06-30
cash 293,500,000 CashAndCashEquivalentsAtCarryingValue 2026-06-30
current assets 6,999,200,000 AssetsCurrent 2026-06-30
current liabilities 9,627,000,000 LiabilitiesCurrent 2026-06-30
equity 3,854,700,000 StockholdersEquity 2026-06-30
interest expense 516,300,000 InterestExpenseNonoperating 2026-06-30
ocf 3,886,700,000 NetCashProvidedByUsedInOperatingActivities 2026-06-30
revenue 24,410,300,000 RevenueFromContractWithCustomerExcludingAssessedTax 2026-06-30
sbc 120,200,000 ShareBasedCompensation 2026-06-30

The ratios

The figures themselves rather than their scores — what somebody looking up SHW on one particular measure came for.

RatioValue
cash operating margin18.4
current ratio0.76
current ratio reported0.73
deferred revenue growth21.02
dilution pct-1.46
ev ebit23.98
ev owner earnings30.97
ev sales3.92
fcf margin13.16
growth cv0.78
interest cover7.74
net debt ebitda2.74
operating margin16.36
owner earnings margin12.67
revenue growth5.76
revenue growth per share7.33
roic19.93
rule of 4022.13
sbc pct revenue0.49

What to be careful about

What this model itself distrusts about SHW's figures. Written by the derivation as it ran, not added afterwards.