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.

Analysis of Long-term (Investment) Activity Ratios 
Quarterly Data

Microsoft Excel

Long-term Activity Ratios (Summary)

Sherwin-Williams Co., long-term (investment) activity ratios (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
Net fixed asset turnover 10.59 10.64 10.68 10.77 10.88 10.60 10.01 10.11 9.86 9.84 9.75 9.93 9.99 9.99 9.87 9.88 9.70 8.80 7.98
Net fixed asset turnover (including operating lease, right-of-use asset) 5.46 5.42 5.41 5.46 5.50 5.38 5.11 5.11 5.07 5.13 5.08 5.16 5.15 5.14 9.87 9.88 9.70 8.80 7.98
Total asset turnover 0.94 0.93 0.97 0.95 0.96 0.92 0.90 0.86 0.87 0.88 0.87 0.86 0.84 0.84 0.92 0.87 0.85 0.79 0.75
Equity turnover 9.34 9.08 8.18 7.31 6.92 6.13 5.09 4.28 4.58 5.47 4.34 4.44 4.73 5.09 4.70 4.39 4.60 4.39 4.06

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).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Sherwin-Williams Co. net fixed asset turnover ratio deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Sherwin-Williams Co. net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Sherwin-Williams Co. total asset turnover ratio deteriorated from Q4 2021 to Q1 2022 but then slightly improved from Q1 2022 to Q2 2022.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Sherwin-Williams Co. equity turnover ratio improved from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022.

Net Fixed Asset Turnover

Sherwin-Williams Co., net fixed asset turnover 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
Selected Financial Data (US$ in thousands)
Net sales 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
Property, plant and equipment, net 1,961,900 1,907,300 1,867,300 1,827,200 1,806,300 1,780,400 1,834,500 1,780,000 1,798,600 1,829,500 1,835,200 1,798,301 1,773,586 1,762,998 1,776,839 1,766,354 1,776,378 1,840,005 1,877,115 1,895,549 1,889,917 1,063,095
Long-term Activity Ratio
Net fixed asset turnover1 10.59 10.64 10.68 10.77 10.88 10.60 10.01 10.11 9.86 9.84 9.75 9.93 9.99 9.99 9.87 9.88 9.70 8.80 7.98
Benchmarks
Net Fixed Asset Turnover, Competitors2
Linde plc 1.36 1.24 1.18 1.14 1.08 1.03 0.95 0.97 0.98 1.02 0.97

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 Q2 2022 Calculation
Net fixed asset turnover = (Net salesQ2 2022 + Net salesQ1 2022 + Net salesQ4 2021 + Net salesQ3 2021) ÷ Property, plant and equipment, net
= (5,872,300 + 4,998,700 + 4,762,100 + 5,146,700) ÷ 1,961,900 = 10.59

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Sherwin-Williams Co. net fixed asset turnover ratio deteriorated from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

Sherwin-Williams Co., net fixed asset turnover (including operating lease, right-of-use asset) 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
Selected Financial Data (US$ in thousands)
Net sales 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
 
Property, plant and equipment, net 1,961,900 1,907,300 1,867,300 1,827,200 1,806,300 1,780,400 1,834,500 1,780,000 1,798,600 1,829,500 1,835,200 1,798,301 1,773,586 1,762,998 1,776,839 1,766,354 1,776,378 1,840,005 1,877,115 1,895,549 1,889,917 1,063,095
Operating lease right-of-use assets 1,842,400 1,837,900 1,820,600 1,774,400 1,764,200 1,728,800 1,761,100 1,738,600 1,696,600 1,683,400 1,685,600 1,659,010 1,667,517 1,663,444
Property, plant and equipment, net (including operating lease, right-of-use asset) 3,804,300 3,745,200 3,687,900 3,601,600 3,570,500 3,509,200 3,595,600 3,518,600 3,495,200 3,512,900 3,520,800 3,457,311 3,441,103 3,426,442 1,776,839 1,766,354 1,776,378 1,840,005 1,877,115 1,895,549 1,889,917 1,063,095
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 5.46 5.42 5.41 5.46 5.50 5.38 5.11 5.11 5.07 5.13 5.08 5.16 5.15 5.14 9.87 9.88 9.70 8.80 7.98

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 Q2 2022 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (Net salesQ2 2022 + Net salesQ1 2022 + Net salesQ4 2021 + Net salesQ3 2021) ÷ Property, plant and equipment, net (including operating lease, right-of-use asset)
= (5,872,300 + 4,998,700 + 4,762,100 + 5,146,700) ÷ 3,804,300 = 5.46

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Sherwin-Williams Co. net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022.

Total Asset Turnover

Sherwin-Williams Co., total asset turnover 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
Selected Financial Data (US$ in thousands)
Net sales 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
Total assets 22,052,800 21,730,400 20,666,700 20,736,600 20,519,600 20,435,000 20,401,600 20,809,700 20,494,500 20,570,300 20,496,200 20,864,339 21,186,136 20,961,641 19,134,279 19,980,696 20,154,732 20,367,686 19,958,427 20,779,657 20,717,398 6,988,903
Long-term Activity Ratio
Total asset turnover1 0.94 0.93 0.97 0.95 0.96 0.92 0.90 0.86 0.87 0.88 0.87 0.86 0.84 0.84 0.92 0.87 0.85 0.79 0.75
Benchmarks
Total Asset Turnover, Competitors2
Linde plc 0.42 0.38 0.38 0.35 0.34 0.33 0.31 0.31 0.32 0.33 0.33

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 Q2 2022 Calculation
Total asset turnover = (Net salesQ2 2022 + Net salesQ1 2022 + Net salesQ4 2021 + Net salesQ3 2021) ÷ Total assets
= (5,872,300 + 4,998,700 + 4,762,100 + 5,146,700) ÷ 22,052,800 = 0.94

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Sherwin-Williams Co. total asset turnover ratio deteriorated from Q4 2021 to Q1 2022 but then slightly improved from Q1 2022 to Q2 2022.

Equity Turnover

Sherwin-Williams Co., equity turnover 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
Selected Financial Data (US$ in thousands)
Net sales 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
Shareholders’ equity 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
Long-term Activity Ratio
Equity turnover1 9.34 9.08 8.18 7.31 6.92 6.13 5.09 4.28 4.58 5.47 4.34 4.44 4.73 5.09 4.70 4.39 4.60 4.39 4.06
Benchmarks
Equity Turnover, Competitors2
Linde plc 0.82 0.74 0.70 0.67 0.63 0.60 0.58 0.59 0.60 0.63 0.58

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 Q2 2022 Calculation
Equity turnover = (Net salesQ2 2022 + Net salesQ1 2022 + Net salesQ4 2021 + Net salesQ3 2021) ÷ Shareholders’ equity
= (5,872,300 + 4,998,700 + 4,762,100 + 5,146,700) ÷ 2,224,600 = 9.34

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Sherwin-Williams Co. equity turnover ratio improved from Q4 2021 to Q1 2022 and from Q1 2022 to Q2 2022.