Grufity logoGrufity logo

Sherwin-Williams Co Stock Research

SHW

220.35USD+3.80(+1.75%)Market Closed

Market Summary

USD220.35+3.80
Market Closed
1.75%

SHW Alerts

SHW Stock Price

SHW RSI Chart

SHW Valuation

Market Cap

57.0B

Price/Earnings (Trailing)

28.24

Price/Sales (Trailing)

2.58

EV/EBITDA

20.58

Price/Free Cashflow

29.71

SHW Price/Sales (Trailing)

SHW Profitability

EBT Margin

11.62%

Return on Equity

65.12%

Return on Assets

8.94%

Free Cashflow Yield

3.37%

SHW Fundamentals

SHW Revenue

Revenue (TTM)

22.1B

Revenue Y/Y

9.84%

Revenue Q/Q

-13.51%

SHW Earnings

Earnings (TTM)

2.0B

Earnings Y/Y

27.07%

Earnings Q/Q

-43.61%

Price Action

52 Week Range

194.75282.96
(Low)(High)

Last 7 days

-1.6%

Last 30 days

-7.1%

Last 90 days

-11.3%

Trailing 12 Months

-10.0%

SHW Financial Health

Current Ratio

0.99

Debt/Equity

3.09

Debt/Cashflow

0.2

SHW Investor Care

Dividend Yield

1.09%

Dividend/Share (TTM)

2.4

Buy Backs (1Y)

0.84%

Diluted EPS (TTM)

7.72

Peers (Alternatives to Sherwin-Williams)

View All Peers In Detail
NameMkt Capsorted ascendingRevenuePrice %, 1MReturns, 1YP/EP/SRev 1-YrInc 1-Yr
LARGE-CAP
57.0B
22.1B
-7.09% -10.03%
28.24
2.58
11.05% 8.35%
45.2B
14.2B
7.67% -4.79%
41.38
3.18
11.42% -3.38%
27.7B
50.5B
-16.68% -7.27%
7.12
0.55
9.27% -30.76%
26.8B
17.7B
-2.11% 3.18%
24.98
1.52
5.06% -28.70%
21.3B
12.4B
-14.07% -30.43%
-11.45
1.72
6.73% -768.10%
MID-CAP
6.9B
9.4B
-19.85% 0.94%
5.18
0.73
5.23% 2.33%
5.7B
2.4B
-9.04% 5.36%
6.27
2.75
11.60% 331.46%
5.3B
4.9B
-4.95% 17.14%
26.11
1.1
10.60% -27.40%
5.1B
8.0B
-12.87% -28.62%
11.13
0.64
4.60% -55.98%
2.2B
2.8B
-13.57% -2.08%
14.94
0.79
18.21% 6.78%
SMALL-CAP
960.2M
353.5M
7.02% 16.57%
23.04
2.72
17.39% -4.89%
889.5M
929.9M
2.50% -7.95%
15.07
0.96
30.14% 17.90%
232.0M
-
0.72% 17.91%
25.81
0.77
- -
158.5M
169.3M
- 50.51%
-6.94
0.94
4.53% -109.31%
143.5M
377.4M
9.13% 64.39%
11.76
0.38
22.73% 161.25%

Financials for Sherwin-Williams

Income Statement (Last 12 Months)
(In Millions)
* denotes actual numbers (not divided by Millions)
Description(%) Q/Q2022Q42022Q32022Q22022Q12021Q4
Revenue2.2%22,14921,68120,78020,28719,945
Gross Profit3.9%9,3258,9718,5218,4848,543
  S&GA Expenses2.0%6,0155,8955,7355,6545,573
EBITDA7.1%3,2283,0132,7282,804-
EBITDA Margin4.9%0.15*0.14*0.13*0.14*-
Earnings Before Taxes7.8%2,5732,3872,1212,2012,249
EBT Margin5.5%0.12*0.11*0.10*0.11*-
Interest Expenses6.4%391367349340335
Net Income4.2%2,0201,9381,7551,8261,864
Net Income Margin2.0%0.09*0.09*0.08*0.09*-
Free Cahsflow30.4%1,9201,4731,6832,075-
Balance Sheet
(In Millions)
* denotes actual numbers (not divided by Millions)
Description(%) Q/Q2022Q42022Q32022Q22022Q12021Q4
Assets1.6%22,59422,24622,05321,73020,667
  Current Assets-3.4%5,9086,1176,2606,0865,054
    Cash Equivalents52.3%199131313401166
  Inventory3.1%2,6272,5482,4122,3291,927
  Net PPE8.1%2,2072,0411,9621,9071,867
  Goodwill3.6%7,5837,3187,1067,0597,135
  Current Liabilities-2.2%5,9616,0967,1986,9535,720
.    Short Term Borrowings3.5%9789452,0121,740764
  Long Term Debt11.6%9,5908,5948,8538,852-
    LT Debt, Current0%1.001.001.00261261
    LT Debt, Non Current0.0%9,5919,5898,5948,5928,591
Shareholder's Equity19.4%3,1022,5982,2252,2342,437
  Retained Earnings7.0%3,5233,2932,7632,3422,122
  Additional Paid-In Capital1.1%3,9643,9203,8803,8433,793
Shares Outstanding-0.1%259259259260261
Cashflow (Last 12 Months)
(In Millions)
Description(%) Q/Q2022Q42022Q32022Q22022Q12021Q4
Cashflow From Operations30.4%1,9201,4731,6832,0752,245
  Share Based Compensation-11.6%10011311211198.00
Cashflow From Investing-23.6%-1,607-1,300-877-665-476
Cashflow From Financing21.5%-282-359-716-1,323-1,834
  Dividend Payments1.9%619607597586587
  Buy Backs-38.1%8831,4271,8102,3842,752

Risks for SHW

What is the probability of a big loss on SHW?

60%


Probability that Sherwin-Williams stock will be more than 20% underwater in next one year

34.2%


Probability that Sherwin-Williams stock will be more than 30% underwater in next one year.

5%


Probability that Sherwin-Williams stock will be more than 40% underwater in next one year.
*Calculated based on probability distribution of losses observed in actual data in the last 5 years.

How does SHW drawdown profile look like?

Y-axis is the maximum loss one would have experienced if Sherwin-Williams was unfortunately bought at previous high price.

Drawdowns

Returns for SHW

Cumulative Returns on SHW

15.5%


10-Year Cumulative Returns

13.4%


7-Year Cumulative Returns

10.6%


5-Year Cumulative Returns

10.0%


3-Year Cumulative Returns

What are the long-term rolling returns for SHW?

FIve years rolling returns for Sherwin-Williams.

Annualized Returns

Which funds bought or sold SHW recently?

View All Details
Datesorted ascendingFund NameType% Chg$ Change$ Held% Portfolio
2023-03-15
B. Riley Wealth Advisors, Inc.
reduced
-0.07
390,157
2,859,160
0.08%
2023-03-13
Claro Advisors LLC
new
-
519,045
519,045
0.17%
2023-03-10
BAILLIE GIFFORD & CO
reduced
-3.96
1,030,570
10,132,600
0.01%
2023-03-10
MATHER GROUP, LLC.
added
4.12
70,908
413,908
0.01%
2023-03-10
VICTORY CAPITAL MANAGEMENT INC
reduced
-12.85
344,048
34,189,000
0.04%
2023-03-06
Rockefeller Capital Management L.P.
reduced
-5.5
999,000
11,487,000
0.06%
2023-03-03
TIAA, FSB
added
764
8,764,280
9,735,280
0.04%
2023-03-02
LORING WOLCOTT & COOLIDGE FIDUCIARY ADVISORS LLP/MA
new
-
855,338
855,338
0.01%
2023-03-02
OLIVER LAGORE VANVALIN INVESTMENT GROUP
reduced
-50.95
-325,050
427,950
0.24%
2023-03-01
SMITHBRIDGE ASSET MANAGEMENT INC/DE
new
-
3,676,000
3,676,000
0.98%

1–10 of 49

Latest Funds Activity

Are funds buying SHW calls or puts?
Calls
Puts
Are funds bullish or bearish(Calls - Puts)?
Net Call Options
No. of funds that own SHW
No. of Funds

Sherwin-Williams News

MarketBeat

UMB Bank n.a. Has $2.60 Million Stock Holdings in The Sherwin ....

MarketBeat,
22 hours ago

Nasdaq

DirectorsTalk Interviews

Yahoo Finance

Schedule 13G FIlings of Sherwin-Williams

Date FiledName of FilerPercent of ClassNo. of SharesForm Type
Feb 09, 2023
vanguard group inc
8.14%
21,083,709
SC 13G/A
Feb 01, 2023
blackrock inc.
6.5%
16,754,718
SC 13G/A
Feb 10, 2022
vanguard group inc
7.86%
20,613,398
SC 13G/A
Feb 01, 2022
blackrock inc.
6.5%
17,169,250
SC 13G/A
Feb 10, 2021
vanguard group inc
7.74%
7,030,205
SC 13G/A
Feb 01, 2021
blackrock inc.
6.5%
5,921,534
SC 13G/A
Feb 12, 2020
vanguard group inc
7.91%
7,306,533
SC 13G/A
Feb 06, 2020
blackrock inc.
6.8%
6,254,233
SC 13G/A

SHW Fair Value

Sherwin-Williams fair value in different scenarios

The table shows the Fair Value estimates for Sherwin-Williams for various scenarios. Disclaimer: These are just estimations from a model. None of the models are good at predicting the future. Please dont buy or sell stocks based on these outputs.
Fair ValueVery PessimisticPessimisticBase CaseOptimisticVery Optimistic
Very Low Inflation

111.72

-49.30%

138.14

-37.31%

192.47

-12.65%

256.14

16.24%

339.88

54.25%
Current Inflation

101.90

-53.76%

124.23

-43.62%

169.66

-23.00%

222.71

1.07%

292.60

32.79%
Very High Inflation

89.85

-59.22%

107.48

-51.22%

142.91

-35.14%

184.13

-16.44%

238.62

8.29%

Historical Sherwin-Williams Fair Value Estimates


Very Pessimistic Case
Pessimistic Case
Fair Value
Optimistic Case
Very Optimistic Case
Closing Stock Price

Recent SEC filings of Sherwin-Williams

View All Filings
Date Filed Form Type Document
Mar 08, 2023
DEF 14A
DEF 14A
Mar 08, 2023
DEFA14A
DEFA14A
Mar 08, 2023
ARS
ARS
Feb 28, 2023
8-K
Current Report
Feb 27, 2023
4
Insider Trading
Feb 22, 2023
4
Insider Trading
Feb 22, 2023
4
Insider Trading
Feb 22, 2023
4
Insider Trading
Feb 22, 2023
4
Insider Trading
Feb 22, 2023
4
Insider Trading

Latest Insider Trading transactions for SHW

Filter Transactions
Datesorted ascendingNameBuy/Sell$ ValueAvg. Price# SharesTitle
2023-02-23
Young Bryan J
sold
-607,090
220
-2,750
svp - corp strategy & devel.
2023-02-17
Young Bryan J
sold (taxes)
-361,968
226
-1,600
svp - corp strategy & devel.
2023-02-17
GARCEAU MARY L
sold (taxes)
-852,208
226
-3,767
svp, gen. counsel & secretary
2023-02-17
Rea Todd D
acquired
-
-
1,080
president, consumer brands grp
2023-02-17
Petz Heidi G
sold (taxes)
-331,653
226
-1,466
president & coo
2023-02-17
Young Bryan J
acquired
-
-
4,500
svp - corp strategy & devel.
2023-02-17
Sofish Gregory P.
acquired
-
-
1,260
svp - human resources
2023-02-17
Sladek Joseph F
sold (taxes)
-86,646
226
-383
pres. & gm, glob. supply chain
2023-02-17
Jorgenrud Karl J
sold (taxes)
-496,122
226
-2,193
president, perf coatings group
2023-02-17
Sofish Gregory P.
sold (taxes)
-86,646
226
-383
svp - human resources

1–10 of 50

John G. Morikis
61000
The Sherwin-Williams Company develops, manufactures, distributes, and sells paints, coatings, and related products to professional, industrial, commercial, and retail customers. It operates through three segments: The Americas Group, Consumer Brands Group, and Performance Coatings Group. The Americas Group segment offers architectural paints and coatings, and protective and marine products, as well as OEM product finishes and related products for architectural and industrial paint contractors, and do-it-yourself homeowners. The Consumer Brands Group segment supplies a portfolio of branded and private-label architectural paints, stains, varnishes, industrial products, wood finishes products, wood preservatives, applicators, corrosion inhibitors, aerosols, caulks, and adhesives to retailers and distributors. The Performance Coatings Group segment develops and sells industrial coatings for wood finishing and general industrial applications, automotive refinish products, protective and marine coatings, coil coatings, packaging coatings, and performance-based resins and colorants. It serves retailers, dealers, jobbers, licensees, and other third-party distributors through its branches and direct sales staff, as well as through outside sales representatives. The company has operations primarily in the North and South America, the Caribbean, Europe, Asia, and Australia. As of February 17, 2022, it operated approximately 5,000 company-operated stores and facilities. The Sherwin-Williams Company was founded in 1866 and is headquartered in Cleveland, Ohio.

SHW Income Statement

2022-12-31
Statements of Consolidated Income - USD ($)
shares in Millions, $ in Millions
12 Months Ended
Dec. 31, 2022
Dec. 31, 2021
Dec. 31, 2020
Income Statement [Abstract]   
Net sales$ 22,148.9$ 19,944.6$ 18,361.7
Cost of goods sold12,823.811,401.99,679.1
Gross profit$ 9,325.1$ 8,542.7$ 8,682.6
Gross profit, percent to net sales42.10%42.80%47.30%
Selling, general and administrative expenses$ 6,014.5$ 5,572.5$ 5,477.9
Selling, general and administrative expenses, percent to net sales27.20%27.90%29.80%
Other general (income) expense - net$ (24.9)$ 101.8$ 27.7
Amortization317.1309.5313.4
Impairment of trademarks15.50.02.3
Interest expense390.8334.7340.4
Interest income(8.0)(4.9)(3.6)
Other expense (income) - net47.0(19.5)5.3
Income before income taxes2,573.12,248.62,519.2
Income tax expense553.0384.2488.8
Net income$ 2,020.1$ 1,864.4$ 2,030.4
Net income per share:   
Basic (in dollars per share)$ 7.83$ 7.10$ 7.48
Diluted (in dollars per share)$ 7.72$ 6.98$ 7.36
Weighted average shares outstanding:   
Basic (in shares)258.0262.5271.3
Diluted (in shares)261.8267.1275.8

SHW Balance Sheet

2022-12-31
Consolidated Balance Sheets - USD ($)
$ in Millions
Dec. 31, 2022
Dec. 31, 2021
Dec. 31, 2020
Current assets:   
Cash and cash equivalents$ 198.8$ 165.7$ 226.6
Accounts receivable, less allowance2,563.62,352.42,078.1
Inventories2,626.51,927.21,804.1
Other current assets518.8608.4482.6
Total current assets5,907.75,053.74,591.4
Property, plant and equipment, net2,207.01,867.31,834.5
Goodwill7,583.27,134.67,049.1
Intangible assets, net4,002.04,001.54,471.2
Operating lease right-of-use assets1,866.81,820.61,761.1
Other assets1,027.3789.0694.3
Total Assets22,594.020,666.720,401.6
Current liabilities:   
Short-term borrowings978.1763.50.1
Accounts payable2,436.52,403.02,117.8
Compensation and taxes withheld784.5716.6752.7
Accrued taxes197.4160.3183.5
Current portion of long-term debt0.6260.625.1
Current portion of operating lease liabilities425.3409.7387.3
Other accruals1,138.31,005.81,127.9
Total current liabilities5,960.75,719.54,594.4
Long-term debt9,591.08,590.98,266.9
Postretirement benefits other than pensions139.3259.4275.6
Deferred income taxes681.6768.2846.1
Long-term operating lease liabilities1,512.91,470.71,434.1
Other long-term liabilities1,606.41,420.81,373.7
Shareholders’ equity:   
Common stock - $0.33-1/3 par value: 258.9, 261.1, and 268.7 million shares outstanding at December 31, 2022, 2021 and 2020, respectively91.290.889.9
Other capital3,963.93,793.03,491.4
Retained earnings3,523.22,121.7844.3
Treasury stock, at cost(3,775.6)(2,869.9)(96.5)
Accumulated other comprehensive loss(700.6)(698.4)(718.3)
Total shareholders’ equity3,102.12,437.23,610.8
Total Liabilities and Shareholders’ Equity$ 22,594.0$ 20,666.7$ 20,401.6