SphinxRisk

Sherwin Williams Co

SHW · Consumer discretionary (retail-building materials, hardware, garden supply) · 10 years of annual accounts filed with the SEC · latest fiscal year ended 2025-12-31

Sherwin Williams Co reported revenue of $23.6 billion in fiscal 2025, after growing 7.9% a year over the previous 9 years. Its operating margin narrowed from 18.3% in 2016 to 15.8%, and it earned 20.1% on its invested capital in the latest year. Of the $25.2 billion its operations generated over 10 years, 46.3% went to acquisitions and 20.7% to dividends; the share count fell 11.7%. On the accounting screens, it passes 6 of 9 Piotroski tests, its Altman Z'' of 1.09 is in the distress zone and its Beneish M-score is below the -1.78 line; none of the six cross-checks between its statements fires.

Revenue, fiscal 2025 23.6B +7.9% a year over 9 years
Operating margin 15.8% gross margin 48.8%
Return on invested capital 20.1% 22.1% on average over 5 years
Free cash flow after stock pay 2.5B 10.7% of revenue
Net debt ÷ EBITDA 2.3× net debt 9.5B
Piotroski F-score 6/9 tests of improvement passed

Share counts are in today's shares. The SEC's filings restate only recent years after a split, so these jumps were read as splits and the older years scaled to match — otherwise per-share figures would compare different units: 3-for-1 before fiscal 2019.

Is it growing?

Revenue and the operating income it turns into. Growth that does not reach operating income is growth bought with margin.

RevenueOperating income
Compound growth a year
3 yrs5 yrs9 yrs
Revenue+2.1%+5.1%+7.9%
Operating income+3.2%+2.1%+6.3%
Net income+8.3%+4.8%+9.5%
Earnings per share+10.0%+6.9%+11.0%
Free cash flow per share+29.6%-1.2%+12.2%
Dividend per share+10.1%+12.3%+12.4%
Shares-1.5%-1.9%-1.4%

Falling shares are buybacks: each remaining share owns more of the company.

Does it earn more than its capital costs?

Margins say how much of each sale is kept; return on invested capital says how much the business earns on the money it needs to operate. Growth only creates value when that return is above the cost of the capital.

GrossOperatingNetFree cash flow

Return on invested capital

Return on invested capital Cost of capital today · 6.0%

Economic profit

Economic profit

(return on capital − cost of capital) × capital invested: the profit left after paying for the money used. Today's cost of capital is applied to every year, since a past one cannot be rebuilt honestly.

Return on equity
55.9%
Return on assets
9.9%
Asset turnover
0.91×
Overheads (SG&A)
32.6% of revenue

Is the profit cash, and where does the cash go?

Net income is an accounting opinion; free cash flow is what was left in the bank after investing. Stock-based pay does not leave the bank — shareholders pay it through dilution — so it is shown taken off as well.

Net incomeFree cash flowAfter stock-based pay

Where 10 years of operating cash went, 2016–2025

25.2B generated by the business. Each band is its share of that total.

  • Reinvested in the business 20% 5.1B
  • Acquisitions 46% 11.7B
  • Dividends 21% 5.2B
  • Share buybacks 0% 0
  • Kept, or used to pay down debt 13% 3.2B

Over the same years it paid 1.0B in stock. The share count fell 11.7%.

Per share

Earnings per shareFree cash flow per shareDividend per share

Shares outstanding

Diluted shares

How strong is the balance sheet?

Debt is not bad in itself; debt the business cannot service in a bad year is. Net debt is debt minus cash, and below zero the company holds more cash than it owes.

Net debt
Net debt ÷ EBITDA
2.3×
Interest coverage
9× operating income ÷ interest
Current ratio
0.87 current assets ÷ current liabilities
Cash conversion cycle
42 days collects in 43d, stock 70d, pays in 71d

Three classic screens of the accounts

Each asks a different question of the same statements — is it improving, does it look like a company heading for distress, do the accounts resemble ones that were manipulated. None is a verdict; each shows what moves it.

Piotroski F-score

Is the business improving? Nine yes-or-no tests, this year against last.

6of 9 tests passed
  • ProfitableReturn on assets above zero passed
  • Cash from operationsOperating cash flow above zero passed
  • Profitability improvedReturn on assets higher than a year before failed
  • Profit backed by cashOperating cash flow above net income (low accruals) passed
  • Less long-term debtLong-term debt as a share of assets fell failed
  • More liquidCurrent ratio higher than a year before passed
  • No new sharesShare count did not grow passed
  • Better gross marginGross margin higher than a year before passed
  • Sells more per assetAsset turnover higher than a year before failed

Where it misleads: it measures change, not level. An excellent business that stood still for a year scores low; a poor one recovering from a disaster scores high.

Altman Z''-score

Does the balance sheet look like those of companies that went bankrupt?

1.09distress zone
  • Working capital ÷ assets -0.04 × 6.56-0.23
  • Retained earnings ÷ assets 0.04 × 3.26+0.13
  • Operating income ÷ assets 0.14 × 6.72+0.97
  • Equity ÷ liabilities 0.22 × 1.05+0.23

Where it misleads: buybacks. A company that returns so much cash that its equity turns small or negative sinks the last two ratios without being anywhere near bankruptcy. Banks and insurers do not fit the model at all.

Beneish M-score

Do the accounts resemble those of companies that manipulated their earnings?

-2.50below the -1.78 line
  • Receivables vs sales 1.14+1.05
  • Gross margin slipping 0.99+0.52
  • Soft assets 0.98+0.40
  • Sales growth 1.02+0.91
  • Slower depreciation 1.02+0.12
  • Overheads vs sales 1.02-0.17
  • Profit not in cash -0.03-0.16
  • Leverage rising 0.99-0.32

Where it misleads: fast growth and acquisitions. Sales growth carries a heavy weight, so a company growing 50% a year scores like a suspect without having done anything. It is a screen from a 1999 study, not an accusation.

Where the statements disagree

Cross-checks between the income statement, the balance sheet and the cash flow for the latest year, each with the benign reading and the worrying one.

None of the six cross-checks fires for the latest year: receivables and inventory move with revenue, profit turns into cash, investment keeps up with depreciation, the tax rate is ordinary and debt is moderate.

What is it worth, under which assumptions?

A company is worth the cash it will generate, brought back to today. This model projects revenue with growth that fades over the years, applies a free cash flow margin, and discounts the result at the cost of capital. Every assumption says where it came from, and all of them can be changed.

Revenue
M $

revenue of fiscal 2025

%

revenue grew +5.1% a year over the last 5 years; it fades to the terminal rate by the last year

yrs

ten years for growth to fade to the terminal rate

Cash from each sale
%

free cash flow to the firm after stock-based pay ÷ revenue, last 3 fiscal years together

%

the margin in year ten; by default the business keeps today's

The long run
%

growth forever after year ten, below the risk-free rate: no company outgrows the economy forever

The discount rate
%

10-year US Treasury yield (FRED, DGS10), 2026-09-24

not measured on this public page, which uses only public filings: 1.0 assumes it moves like the market. Sign in to measure it from prices

%

the extra return demanded for holding shares; it cannot be measured, and 4–6% is the common range

%

interest expense ÷ debt = 4.1%, kept between the risk-free rate and +8 points

%

effective rate in the last fiscal year, 23.1%, kept within 0–35%

The price
$

Type the price you see at your broker. It is used only for the reverse questions: what that price implies.

Back to the defaults

SEC from the filings Treasury the 10-year yield measured from prices assumption cannot be measured yours you changed it

Value per share, with these assumptions $265.26 discounted at 6.0% a year · 72% of it from after year 10
$156.1780% of 4,923 simulations$485.09
Cautious $120.80 1.0% growth · 8.3% margin · 7.0% discount · 2.0% forever
Your assumptions $265.26 5.0% growth · 9.8% margin · 6.0% discount · 2.5% forever
Generous $678.34 9.0% growth · 11.3% margin · 5.0% discount · 3.0% forever

Type a share price on the left to ask the reverse questions: what growth, what margin or what discount rate that price implies.

What the value implies, in the usual multiples

At this model's value
Price ÷ earnings25.9×
Enterprise value ÷ EBITDA18.6×
Enterprise value ÷ revenue3.2×
Free cash flow yield3.8%

From cash flows to a value per share

10 years of cash flow, today21.0B
Everything after, today54.9B
The whole business75.9B
Minus net debt-9.5B
What belongs to shareholders66.4B

Divided among 250.4M shares: <strong>$265.26</strong> each.

The projection next to its history

Reported free cash flow after stock pay, then the model's. A projection that looks nothing like the past needs a reason.

ReportedProjected
Year by year
2026202720282029203020312032203320342035
Revenue24.8B25.9B27.1B28.2B29.3B30.4B31.4B32.3B33.2B34.1B
Growth5.0%4.7%4.4%4.2%3.9%3.6%3.3%3.1%2.8%2.5%
Cash margin9.8%9.8%9.8%9.8%9.8%9.8%9.8%9.8%9.8%9.8%
Free cash flow2.4B2.5B2.6B2.8B2.9B3.0B3.1B3.2B3.3B3.3B
Worth today2.3B2.3B2.2B2.2B2.1B2.1B2.0B2.0B1.9B1.9B

If the least-known inputs move

Value per share as two inputs change at a time. Neighbouring cells that differ a lot are the conclusion: the value depends on numbers nobody knows to a point.

The discount rate and growth forever

discount ↓ · forever →1.5%2.0%2.5%3.0%3.5%
5.0% 276 323 389 487 653
5.5% 236 271 317 381 478
6.0% 205 232 265 310 373
6.5% 181 201 227 260 304
7.0% 160 177 197 222 255

Year-one growth and the final margin

margin ↓ · growth →1.0%3.0%5.0%7.0%9.0%
7.8% 172 192 213 235 260
8.8% 194 216 239 264 292
9.8% 216 240 265 293 323
10.8% 237 263 292 322 355
11.7% 259 287 318 351 387

All the inputs moving at once

4,923 valuations, each with growth, final margin, discount rate and growth forever drawn at random around the values on the left (spreads of 3.0%, 2.0%, 1.0% and 0.5%). Not a probability — the spreads are assumptions too — but an honest picture of how wide the answer is.

Half of the simulations land between <b>$200.22</b> and <b>$358.94</b>; one in ten below $156.17, one in ten above $485.09.

Does the long run make sense?

  • 16.7×The terminal value prices the business in year 10 at 16.7 times that year's EBITDA.
  • 13%To grow 2.5% forever while reinvesting 20% of its after-tax operating profit, the business must earn 13% on the new capital — it has earned 22% on average over the last five years.
  • 72%of the value comes from after year 10. The more of it, the more the answer depends on the part nobody can see.
The discount rate, taken apart
  1. What shareholders demand (CAPM): 5.18% risk-free + 1.00 beta × 5.0% premium = <strong>10.18%</strong>.
  2. What lenders charge, after the tax saving on interest: 5.18% × (1 − 23.1%) = <strong>3.99%</strong>.
  3. Weighted by how much of each the company uses (book value (no price given)): <strong>5.98%</strong>, the rate every future cash flow is discounted at.

What it has filed lately

The last twelve months at the SEC, most important first: annual and quarterly reports, events, large holders and insiders.

Companies like this one

Same SEC industry (retail-building materials, hardware, garden supply) first, then the rest of consumer discretionary.

Every figure, year by year

10 fiscal years · 30 measures
2016201720182019202020212022202320242025
Size
Revenue11.9B15.0B17.5B17.9B18.4B19.9B22.1B23.1B23.1B23.6B
Revenue growth—+26.4%+17.0%+2.1%+2.6%+8.6%+11.1%+4.1%+0.2%+2.1%
Operating income2.2B2.2B2.6B2.8B3.4B3.1B3.4B4.2B3.8B3.7B
Net income1.1B1.7B1.1B1.5B2.0B1.9B2.0B2.4B2.7B2.6B
Margins
Gross margin49.9%44.8%42.3%44.9%47.3%42.8%42.1%46.7%48.5%48.8%
Operating margin18.3%14.9%14.9%15.7%18.4%15.5%15.3%18.1%16.5%15.8%
Net margin9.6%11.5%6.3%8.6%11.1%9.3%9.1%10.4%11.6%10.9%
Free cash flow margin9.0%11.1%9.7%11.1%16.9%9.4%5.8%11.4%9.0%11.3%
R&D ÷ revenue0.5%0.4%0.3%———————
SG&A ÷ revenue34.9%32.0%28.7%29.5%29.8%29.5%28.6%30.6%32.1%32.6%
Cash
Free cash flow1.1B1.7B1.7B2.0B3.1B1.9B1.3B2.6B2.1B2.7B
Stock-based pay72.1M90.3M82.6M101.7M95.9M97.7M99.7M115.9M138.1M123.5M
Free cash flow after stock pay997.4M1.6B1.6B1.9B3.0B1.8B1.2B2.5B1.9B2.5B
Free cash flow to the firm1.5B1.0B2.2B2.1B3.0B2.3B1.4B2.9B2.2B2.1B
Free cash flow ÷ net income0.9×1.0×1.5×1.3×1.5×1.0×0.6×1.1×0.8×1.0×
Capex ÷ revenue2.0%1.5%1.4%1.8%1.7%1.9%2.9%3.9%4.6%3.4%
Returns
Return on invested capital40.5%13.1%16.7%17.3%22.8%22.6%21.0%24.2%22.3%20.1%
Return on equity60.3%47.4%29.7%37.4%56.2%76.5%65.1%64.3%66.2%55.9%
Return on assets16.8%8.7%5.8%7.5%10.0%9.0%8.9%10.4%11.3%9.9%
Asset turnover1.8×0.8×0.9×0.9×0.9×1.0×1.0×1.0×1.0×0.9×
Economic profit1.3B968.8M1.4B1.4B2.0B1.9B1.9B2.4B2.2B2.0B
Per share
Earnings per share$4.00$6.07$3.89$5.50$7.36$6.98$7.72$9.25$10.55$10.26
Free cash flow per share$3.77$5.83$5.94$7.11$11.26$7.01$4.87$10.20$8.20$10.60
Dividend per share$1.10$1.12$1.13$1.50$1.77$2.20$2.36$2.41$2.85$3.15
Payout ratio27.6%18.5%29.1%27.3%24.0%31.5%30.6%26.1%27.0%30.7%
Book value per share$6.73$12.95$13.36$14.92$13.44$9.33$11.98$14.60$16.12$18.56
Diluted shares283.5M284.8M285.0M280.3M275.8M267.1M261.8M258.3M254.1M250.4M
Balance sheet
Net debt1.0B9.7B8.9B8.3B8.1B8.7B9.4B9.2B9.0B9.5B
Net debt ÷ EBITDA0.4×3.8×3.1×2.7×2.2×2.6×2.6×2.1×2.2×2.3×
Interest coverage14.0×8.5×7.1×8.0×9.9×9.2×8.7×10.0×10.7×9.4×
Current ratio1.3×1.1×1.0×1.0×1.0×0.9×1.0×0.8×0.8×0.9×
Cash conversion cycle (days)40494343292848403942
Scores
Piotroski F-score—358755876
Altman Z''5.292.022.252.391.471.271.671.851.911.09
Beneish M—-1.42-2.65-2.62-2.84-2.43-2.36-2.78-2.61-2.50

Accounts from the company's own SEC filings; lines some companies do not report are shown as a dash rather than estimated. The risk-free rate is the 10-year US Treasury yield. A DCF is a way of making assumptions explicit, not a forecast: it states what the company would be worth if the assumptions held. The scores are screens that point where to look, not verdicts. Nothing here is a recommendation to buy or sell.