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 Reportable Segments

Microsoft Excel

Segment Profit Margin

Sherwin-Williams Co., profit margin by reportable segment

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
The Americas Group 19.96% 22.09% 20.22% 19.72% 19.39%
Consumer Brands Group 5.02% 8.60% 5.94% 4.21% 4.25%
Performance Coatings Group 7.90% 9.88% 7.34% 8.71% 8.02%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

Segment profitability ratio Reportable segment The company
Segment profit margin The Americas Group The Americas Group segment profit margin ratio improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.
Consumer Brands Group Consumer Brands Group segment profit margin ratio improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.
Performance Coatings Group Performance Coatings Group segment profit margin ratio improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021 not reaching 2019 level.

Segment Profit Margin: The Americas Group

Sherwin-Williams Co.; The Americas Group; segment profit margin calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Segment profit 2,239,100 2,294,100 2,056,500 1,898,400 1,769,000
Net sales and intersegment transfers 11,217,000 10,383,200 10,171,900 9,625,600 9,123,300
Segment Profitability Ratio
Segment profit margin1 19.96% 22.09% 20.22% 19.72% 19.39%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment profit margin = 100 × Segment profit ÷ Net sales and intersegment transfers
= 100 × 2,239,100 ÷ 11,217,000 = 19.96%

Segment profitability ratio Reportable segment The company
Segment profit margin The Americas Group The Americas Group segment profit margin ratio improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.

Segment Profit Margin: Consumer Brands Group

Sherwin-Williams Co.; Consumer Brands Group; segment profit margin calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Segment profit 358,400 579,600 373,200 261,100 226,000
Net sales and intersegment transfers 7,133,400 6,741,800 6,283,800 6,199,300 5,316,800
Segment Profitability Ratio
Segment profit margin1 5.02% 8.60% 5.94% 4.21% 4.25%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment profit margin = 100 × Segment profit ÷ Net sales and intersegment transfers
= 100 × 358,400 ÷ 7,133,400 = 5.02%

Segment profitability ratio Reportable segment The company
Segment profit margin Consumer Brands Group Consumer Brands Group segment profit margin ratio improved from 2019 to 2020 but then deteriorated significantly from 2020 to 2021.

Segment Profit Margin: Performance Coatings Group

Sherwin-Williams Co.; Performance Coatings Group; segment profit margin calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Segment profit 486,200 500,100 379,100 452,100 299,000
Net sales and intersegment transfers 6,153,500 5,059,500 5,165,400 5,188,800 3,728,500
Segment Profitability Ratio
Segment profit margin1 7.90% 9.88% 7.34% 8.71% 8.02%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment profit margin = 100 × Segment profit ÷ Net sales and intersegment transfers
= 100 × 486,200 ÷ 6,153,500 = 7.90%

Segment profitability ratio Reportable segment The company
Segment profit margin Performance Coatings Group Performance Coatings Group segment profit margin ratio improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021 not reaching 2019 level.

Segment Return on Assets (Segment ROA)

Sherwin-Williams Co., ROA by reportable segment

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
The Americas Group 39.79% 42.59% 38.09% 46.63% 40.58%
Consumer Brands Group 6.94% 10.76% 6.66% 4.85% 3.87%
Performance Coatings Group 5.80% 6.20% 4.64% 5.30% 3.60%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

Segment profitability ratio Reportable segment The company
Segment ROA The Americas Group The Americas Group segment ROA improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021 not reaching 2019 level.
Consumer Brands Group Consumer Brands Group segment ROA improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021 not reaching 2019 level.
Performance Coatings Group Performance Coatings Group segment ROA improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021.

Segment ROA: The Americas Group

Sherwin-Williams Co.; The Americas Group; segment ROA calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Segment profit 2,239,100 2,294,100 2,056,500 1,898,400 1,769,000
Identifiable assets 5,627,900 5,386,600 5,399,100 4,070,900 4,359,000
Segment Profitability Ratio
Segment ROA1 39.79% 42.59% 38.09% 46.63% 40.58%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment ROA = 100 × Segment profit ÷ Identifiable assets
= 100 × 2,239,100 ÷ 5,627,900 = 39.79%

Segment profitability ratio Reportable segment The company
Segment ROA The Americas Group The Americas Group segment ROA improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021 not reaching 2019 level.

Segment ROA: Consumer Brands Group

Sherwin-Williams Co.; Consumer Brands Group; segment ROA calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Segment profit 358,400 579,600 373,200 261,100 226,000
Identifiable assets 5,161,100 5,387,400 5,600,800 5,385,300 5,839,000
Segment Profitability Ratio
Segment ROA1 6.94% 10.76% 6.66% 4.85% 3.87%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment ROA = 100 × Segment profit ÷ Identifiable assets
= 100 × 358,400 ÷ 5,161,100 = 6.94%

Segment profitability ratio Reportable segment The company
Segment ROA Consumer Brands Group Consumer Brands Group segment ROA improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021 not reaching 2019 level.

Segment ROA: Performance Coatings Group

Sherwin-Williams Co.; Performance Coatings Group; segment ROA calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Segment profit 486,200 500,100 379,100 452,100 299,000
Identifiable assets 8,388,600 8,071,100 8,175,600 8,535,200 8,300,000
Segment Profitability Ratio
Segment ROA1 5.80% 6.20% 4.64% 5.30% 3.60%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment ROA = 100 × Segment profit ÷ Identifiable assets
= 100 × 486,200 ÷ 8,388,600 = 5.80%

Segment profitability ratio Reportable segment The company
Segment ROA Performance Coatings Group Performance Coatings Group segment ROA improved from 2019 to 2020 but then slightly deteriorated from 2020 to 2021.

Segment Asset Turnover

Sherwin-Williams Co., asset turnover by reportable segment

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
The Americas Group 1.99 1.93 1.88 2.36 2.09
Consumer Brands Group 1.38 1.25 1.12 1.15 0.91
Performance Coatings Group 0.73 0.63 0.63 0.61 0.45

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

Segment activity ratio Reportable segment The company
Segment asset turnover The Americas Group The Americas Group segment asset turnover ratio improved from 2019 to 2020 and from 2020 to 2021.
Consumer Brands Group Consumer Brands Group segment asset turnover ratio improved from 2019 to 2020 and from 2020 to 2021.
Performance Coatings Group Performance Coatings Group segment asset turnover ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.

Segment Asset Turnover: The Americas Group

Sherwin-Williams Co.; The Americas Group; segment asset turnover calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Net sales and intersegment transfers 11,217,000 10,383,200 10,171,900 9,625,600 9,123,300
Identifiable assets 5,627,900 5,386,600 5,399,100 4,070,900 4,359,000
Segment Activity Ratio
Segment asset turnover1 1.99 1.93 1.88 2.36 2.09

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment asset turnover = Net sales and intersegment transfers ÷ Identifiable assets
= 11,217,000 ÷ 5,627,900 = 1.99

Segment activity ratio Reportable segment The company
Segment asset turnover The Americas Group The Americas Group segment asset turnover ratio improved from 2019 to 2020 and from 2020 to 2021.

Segment Asset Turnover: Consumer Brands Group

Sherwin-Williams Co.; Consumer Brands Group; segment asset turnover calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Net sales and intersegment transfers 7,133,400 6,741,800 6,283,800 6,199,300 5,316,800
Identifiable assets 5,161,100 5,387,400 5,600,800 5,385,300 5,839,000
Segment Activity Ratio
Segment asset turnover1 1.38 1.25 1.12 1.15 0.91

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment asset turnover = Net sales and intersegment transfers ÷ Identifiable assets
= 7,133,400 ÷ 5,161,100 = 1.38

Segment activity ratio Reportable segment The company
Segment asset turnover Consumer Brands Group Consumer Brands Group segment asset turnover ratio improved from 2019 to 2020 and from 2020 to 2021.

Segment Asset Turnover: Performance Coatings Group

Sherwin-Williams Co.; Performance Coatings Group; segment asset turnover calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Net sales and intersegment transfers 6,153,500 5,059,500 5,165,400 5,188,800 3,728,500
Identifiable assets 8,388,600 8,071,100 8,175,600 8,535,200 8,300,000
Segment Activity Ratio
Segment asset turnover1 0.73 0.63 0.63 0.61 0.45

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment asset turnover = Net sales and intersegment transfers ÷ Identifiable assets
= 6,153,500 ÷ 8,388,600 = 0.73

Segment activity ratio Reportable segment The company
Segment asset turnover Performance Coatings Group Performance Coatings Group segment asset turnover ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.

Segment Capital Expenditures to Depreciation

Sherwin-Williams Co., capital expenditures to depreciation by reportable segment

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
The Americas Group 1.08 0.88 1.02 0.96 0.92
Consumer Brands Group 1.43 1.03 1.64 1.08 1.04
Performance Coatings Group 1.37 0.62 1.19 0.78 0.53

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation The Americas Group The Americas Group segment capital expenditures to depreciation ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.
Consumer Brands Group Consumer Brands Group segment capital expenditures to depreciation ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 not reaching 2019 level.
Performance Coatings Group Performance Coatings Group segment capital expenditures to depreciation ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.

Segment Capital Expenditures to Depreciation: The Americas Group

Sherwin-Williams Co.; The Americas Group; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Capital expenditures 79,200 63,900 73,300 69,500 69,200
Depreciation 73,400 73,000 72,200 72,300 75,000
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.08 0.88 1.02 0.96 0.92

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation
= 79,200 ÷ 73,400 = 1.08

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation The Americas Group The Americas Group segment capital expenditures to depreciation ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.

Segment Capital Expenditures to Depreciation: Consumer Brands Group

Sherwin-Williams Co.; Consumer Brands Group; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Capital expenditures 123,900 89,800 133,400 95,700 95,100
Depreciation 86,700 87,600 81,100 88,800 91,800
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.43 1.03 1.64 1.08 1.04

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation
= 123,900 ÷ 86,700 = 1.43

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Consumer Brands Group Consumer Brands Group segment capital expenditures to depreciation ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 not reaching 2019 level.

Segment Capital Expenditures to Depreciation: Performance Coatings Group

Sherwin-Williams Co.; Performance Coatings Group; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
Selected Financial Data (US$ in thousands)
Capital expenditures 90,800 43,000 84,200 60,800 36,800
Depreciation 66,200 69,100 70,900 77,600 69,000
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.37 0.62 1.19 0.78 0.53

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).

1 2021 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation
= 90,800 ÷ 66,200 = 1.37

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Performance Coatings Group Performance Coatings Group segment capital expenditures to depreciation ratio deteriorated from 2019 to 2020 but then improved from 2020 to 2021 exceeding 2019 level.

Net sales and intersegment transfers

Sherwin-Williams Co., net sales and intersegment transfers by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
The Americas Group 11,217,000 10,383,200 10,171,900 9,625,600 9,123,300
Consumer Brands Group 7,133,400 6,741,800 6,283,800 6,199,300 5,316,800
Performance Coatings Group 6,153,500 5,059,500 5,165,400 5,188,800 3,728,500
Administrative (4,559,300) (3,822,800) (3,720,300) (3,479,200) (3,184,800)
Consolidated totals 19,944,600 18,361,700 17,900,800 17,534,500 14,983,800

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Segment profit

Sherwin-Williams Co., segment profit by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
The Americas Group 2,239,100 2,294,100 2,056,500 1,898,400 1,769,000
Consumer Brands Group 358,400 579,600 373,200 261,100 226,000
Performance Coatings Group 486,200 500,100 379,100 452,100 299,000
Consolidated totals 3,083,700 3,373,800 2,808,800 2,611,600 2,294,000

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Identifiable assets

Sherwin-Williams Co., identifiable assets by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
The Americas Group 5,627,900 5,386,600 5,399,100 4,070,900 4,359,000
Consumer Brands Group 5,161,100 5,387,400 5,600,800 5,385,300 5,839,000
Performance Coatings Group 8,388,600 8,071,100 8,175,600 8,535,200 8,300,000
Administrative 1,489,100 1,556,500 1,320,700 1,142,900 1,460,000
Consolidated totals 20,666,700 20,401,600 20,496,200 19,134,300 19,958,000

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Capital expenditures

Sherwin-Williams Co., capital expenditures by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
The Americas Group 79,200 63,900 73,300 69,500 69,200
Consumer Brands Group 123,900 89,800 133,400 95,700 95,100
Performance Coatings Group 90,800 43,000 84,200 60,800 36,800
Administrative 78,100 107,100 38,000 25,000 21,700
Consolidated totals 372,000 303,800 328,900 251,000 222,800

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).


Depreciation

Sherwin-Williams Co., depreciation by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
The Americas Group 73,400 73,000 72,200 72,300 75,000
Consumer Brands Group 86,700 87,600 81,100 88,800 91,800
Performance Coatings Group 66,200 69,100 70,900 77,600 69,000
Administrative 36,800 38,300 37,900 39,500 49,200
Consolidated totals 263,100 268,000 262,100 278,200 285,000

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31), 10-K (reporting date: 2017-12-31).