Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

This company has been moved to the archive! The financial data has not been updated since July 27, 2022.

Common Stock Valuation Ratios (Price Multiples)
Quarterly Data

Microsoft Excel

Valuation ratios measure the quantity of an asset or flaw (e.g., earnings) associated with ownership of a specified claim (e.g., a share of ownership of the enterprise).


Historical Valuation Ratios (Summary)

Sherwin-Williams Co., historical price multiples (quarterly data)

Microsoft Excel
Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017
Price to earnings (P/E) 34.26 38.67 37.32 42.12 34.90 33.77 31.64 32.67 33.10 30.24 34.31 37.55 39.47 37.74 36.79 18.09 21.86 19.55 21.12
Price to operating profit (P/OP) 24.24 27.85 27.19 30.17 25.17 24.24 22.45 23.35 23.53 20.60 23.12 23.94 22.65 21.86 21.72 16.97 21.57 19.12 21.19
Price to sales (P/S) 2.89 3.48 3.49 4.21 3.86 3.79 3.50 3.40 3.25 2.72 2.95 2.93 2.61 2.37 2.33 1.97 2.37 2.15 2.50
Price to book value (P/BV) 27.03 31.59 28.55 30.80 26.67 23.23 17.79 14.54 14.91 14.88 12.82 13.01 12.34 12.04 10.93 8.67 10.90 9.45 10.14 13.39 13.70 14.64

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).

Valuation ratio Description The company
P/E ratio The P/E ratio tells analyst how much an investor in common stock pays per dollar of current earnings. Sherwin-Williams Co. P/E ratio increased from Q4 2021 to Q1 2022 but then decreased significantly from Q1 2022 to Q2 2022.
P/OP ratio Because P/E ratio is calculated using net income, the ratio can be sensitive to nonrecurring earnings and capital structure, analysts may use price to operating profit. Sherwin-Williams Co. P/OP ratio increased from Q4 2021 to Q1 2022 but then decreased significantly from Q1 2022 to Q2 2022.
P/S ratio An rationale for the P/S ratio is that sales, as the top line in an income statement, are generally less subject to distortion or manipulation than other fundamentals such as EPS or book value. Sales are also more stable than earnings and never negative. Sherwin-Williams Co. P/S ratio decreased from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022.
P/BV ratio The P/BV ratio is interpreted as an indicator of market judgment about the relationship between a company required rate of return and its actual rate of return. Sherwin-Williams Co. P/BV ratio increased from Q4 2021 to Q1 2022 but then decreased significantly from Q1 2022 to Q2 2022.

Price to Earnings (P/E)

Sherwin-Williams Co., historical P/E calculation (quarterly data)

Microsoft Excel
Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017
No. shares of common stock outstanding1 259,183,053 260,131,306 260,373,774 262,196,196 263,302,451 265,949,600 268,805,607 272,473,518 273,148,974 272,400,000 276,683,112 276,927,720 276,769,044 276,948,606 278,154,810 280,878,951 280,143,066 280,637,067 281,981,373 280,541,748 280,230,507 279,384,912
Selected Financial Data (US$)
Net income (in thousands) 577,900 370,800 304,000 502,200 648,600 409,600 407,000 705,800 595,900 321,700 248,622 576,438 471,003 245,237 100,988 354,027 403,604 250,127 897,393 316,606 319,111 239,152
Earnings per share (EPS)2 6.77 7.02 7.16 7.50 8.25 7.97 7.55 6.87 6.38 5.94 5.57 5.03 4.23 3.99 3.99 6.78 6.67 6.35 6.29 0.00 0.00 0.00
Share price1, 3 231.97 271.37 267.22 316.02 287.72 268.96 238.97 224.49 211.18 179.62 191.11 188.96 167.04 150.43 146.63 122.67 145.76 124.24 132.73 130.85 116.87 108.20
Valuation Ratio
P/E ratio4 34.26 38.67 37.32 42.12 34.90 33.77 31.64 32.67 33.10 30.24 34.31 37.55 39.47 37.74 36.79 18.09 21.86 19.55 21.12
Benchmarks
P/E Ratio, Competitors5
Linde plc 41.67 39.22 38.92 45.83 48.23 53.02 52.57 58.47 56.55 41.46 46.22

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).

1 Data adjusted for splits and stock dividends.

2 Q2 2022 Calculation
EPS = (Net incomeQ2 2022 + Net incomeQ1 2022 + Net incomeQ4 2021 + Net incomeQ3 2021) ÷ No. shares of common stock outstanding
= (577,900,000 + 370,800,000 + 304,000,000 + 502,200,000) ÷ 259,183,053 = 6.77

3 Closing price as at the filing date of Sherwin-Williams Co. Quarterly or Annual Report.

4 Q2 2022 Calculation
P/E ratio = Share price ÷ EPS
= 231.97 ÷ 6.77 = 34.26

5 Click competitor name to see calculations.

Valuation ratio Description The company
P/E ratio The P/E ratio tells analyst how much an investor in common stock pays per dollar of current earnings. Sherwin-Williams Co. P/E ratio increased from Q4 2021 to Q1 2022 but then decreased significantly from Q1 2022 to Q2 2022.

Price to Operating Profit (P/OP)

Sherwin-Williams Co., historical P/OP calculation (quarterly data)

Microsoft Excel
Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017
No. shares of common stock outstanding1 259,183,053 260,131,306 260,373,774 262,196,196 263,302,451 265,949,600 268,805,607 272,473,518 273,148,974 272,400,000 276,683,112 276,927,720 276,769,044 276,948,606 278,154,810 280,878,951 280,143,066 280,637,067 281,981,373 280,541,748 280,230,507 279,384,912
Selected Financial Data (US$)
Operating income (in thousands) 847,000 564,900 372,900 695,600 901,000 589,400 560,400 959,300 841,300 500,300 318,706 790,803 764,944 412,747 217,675 645,735 629,895 384,243 370,420 508,201 560,871 326,653
Operating profit per share2 9.57 9.74 9.83 10.47 11.43 11.09 10.64 9.61 8.97 8.72 8.27 7.89 7.37 6.88 6.75 7.23 6.76 6.50 6.26 0.00 0.00 0.00
Share price1, 3 231.97 271.37 267.22 316.02 287.72 268.96 238.97 224.49 211.18 179.62 191.11 188.96 167.04 150.43 146.63 122.67 145.76 124.24 132.73 130.85 116.87 108.20
Valuation Ratio
P/OP ratio4 24.24 27.85 27.19 30.17 25.17 24.24 22.45 23.35 23.53 20.60 23.12 23.94 22.65 21.86 21.72 16.97 21.57 19.12 21.19
Benchmarks
P/OP Ratio, Competitors5
Linde plc 31.50 30.03 29.87 34.99 36.47 40.55 39.58 44.47 43.23 31.75 36.01

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).

1 Data adjusted for splits and stock dividends.

2 Q2 2022 Calculation
Operating profit per share = (Operating incomeQ2 2022 + Operating incomeQ1 2022 + Operating incomeQ4 2021 + Operating incomeQ3 2021) ÷ No. shares of common stock outstanding
= (847,000,000 + 564,900,000 + 372,900,000 + 695,600,000) ÷ 259,183,053 = 9.57

3 Closing price as at the filing date of Sherwin-Williams Co. Quarterly or Annual Report.

4 Q2 2022 Calculation
P/OP ratio = Share price ÷ Operating profit per share
= 231.97 ÷ 9.57 = 24.24

5 Click competitor name to see calculations.

Valuation ratio Description The company
P/OP ratio Because P/E ratio is calculated using net income, the ratio can be sensitive to nonrecurring earnings and capital structure, analysts may use price to operating profit. Sherwin-Williams Co. P/OP ratio increased from Q4 2021 to Q1 2022 but then decreased significantly from Q1 2022 to Q2 2022.

Price to Sales (P/S)

Sherwin-Williams Co., historical P/S calculation (quarterly data)

Microsoft Excel
Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017
No. shares of common stock outstanding1 259,183,053 260,131,306 260,373,774 262,196,196 263,302,451 265,949,600 268,805,607 272,473,518 273,148,974 272,400,000 276,683,112 276,927,720 276,769,044 276,948,606 278,154,810 280,878,951 280,143,066 280,637,067 281,981,373 280,541,748 280,230,507 279,384,912
Selected Financial Data (US$)
Net sales (in thousands) 5,872,300 4,998,700 4,762,100 5,146,700 5,379,800 4,656,000 4,488,800 5,122,200 4,604,000 4,146,700 4,114,429 4,867,650 4,877,860 4,040,861 4,064,221 4,731,470 4,773,796 3,965,006 3,979,564 4,507,020 3,735,817 2,761,387
Sales per share2 80.17 77.99 76.60 75.03 74.62 70.96 68.31 66.01 64.92 66.10 64.70 64.46 64.00 63.59 63.04 62.13 61.49 57.68 53.14 0.00 0.00 0.00
Share price1, 3 231.97 271.37 267.22 316.02 287.72 268.96 238.97 224.49 211.18 179.62 191.11 188.96 167.04 150.43 146.63 122.67 145.76 124.24 132.73 130.85 116.87 108.20
Valuation Ratio
P/S ratio4 2.89 3.48 3.49 4.21 3.86 3.79 3.50 3.40 3.25 2.72 2.95 2.93 2.61 2.37 2.33 1.97 2.37 2.15 2.50
Benchmarks
P/S Ratio, Competitors5
Linde plc 4.53 4.96 4.84 5.50 5.48 5.56 4.83 4.85 4.73 3.46 3.74

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).

1 Data adjusted for splits and stock dividends.

2 Q2 2022 Calculation
Sales per share = (Net salesQ2 2022 + Net salesQ1 2022 + Net salesQ4 2021 + Net salesQ3 2021) ÷ No. shares of common stock outstanding
= (5,872,300,000 + 4,998,700,000 + 4,762,100,000 + 5,146,700,000) ÷ 259,183,053 = 80.17

3 Closing price as at the filing date of Sherwin-Williams Co. Quarterly or Annual Report.

4 Q2 2022 Calculation
P/S ratio = Share price ÷ Sales per share
= 231.97 ÷ 80.17 = 2.89

5 Click competitor name to see calculations.

Valuation ratio Description The company
P/S ratio An rationale for the P/S ratio is that sales, as the top line in an income statement, are generally less subject to distortion or manipulation than other fundamentals such as EPS or book value. Sales are also more stable than earnings and never negative. Sherwin-Williams Co. P/S ratio decreased from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022.

Price to Book Value (P/BV)

Sherwin-Williams Co., historical P/BV calculation (quarterly data)

Microsoft Excel
Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017
No. shares of common stock outstanding1 259,183,053 260,131,306 260,373,774 262,196,196 263,302,451 265,949,600 268,805,607 272,473,518 273,148,974 272,400,000 276,683,112 276,927,720 276,769,044 276,948,606 278,154,810 280,878,951 280,143,066 280,637,067 281,981,373 280,541,748 280,230,507 279,384,912
Selected Financial Data (US$)
Shareholders’ equity (in thousands) 2,224,600 2,234,300 2,437,200 2,690,300 2,840,400 3,078,700 3,610,800 4,207,300 3,869,900 3,289,100 4,123,300 4,022,860 3,747,482 3,460,061 3,730,745 3,974,839 3,747,089 3,690,046 3,692,188 2,740,989 2,391,260 2,065,350
Book value per share (BVPS)2 8.58 8.59 9.36 10.26 10.79 11.58 13.43 15.44 14.17 12.07 14.90 14.53 13.54 12.49 13.41 14.15 13.38 13.15 13.09 9.77 8.53 7.39
Share price1, 3 231.97 271.37 267.22 316.02 287.72 268.96 238.97 224.49 211.18 179.62 191.11 188.96 167.04 150.43 146.63 122.67 145.76 124.24 132.73 130.85 116.87 108.20
Valuation Ratio
P/BV ratio4 27.03 31.59 28.55 30.80 26.67 23.23 17.79 14.54 14.91 14.88 12.82 13.01 12.34 12.04 10.93 8.67 10.90 9.45 10.14 13.39 13.70 14.64
Benchmarks
P/BV Ratio, Competitors5
Linde plc 3.73 3.67 3.38 3.69 3.47 3.34 2.78 2.84 2.83 2.17 2.15 2.26 2.05 1.93

Based on: 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).

1 Data adjusted for splits and stock dividends.

2 Q2 2022 Calculation
BVPS = Shareholders’ equity ÷ No. shares of common stock outstanding
= 2,224,600,000 ÷ 259,183,053 = 8.58

3 Closing price as at the filing date of Sherwin-Williams Co. Quarterly or Annual Report.

4 Q2 2022 Calculation
P/BV ratio = Share price ÷ BVPS
= 231.97 ÷ 8.58 = 27.03

5 Click competitor name to see calculations.

Valuation ratio Description The company
P/BV ratio The P/BV ratio is interpreted as an indicator of market judgment about the relationship between a company required rate of return and its actual rate of return. Sherwin-Williams Co. P/BV ratio increased from Q4 2021 to Q1 2022 but then decreased significantly from Q1 2022 to Q2 2022.