Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

Analysis of Reportable Segments 

Microsoft Excel

Segment Profit Margin

Sherwin-Williams Co., profit margin by reportable segment

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Paint Stores Group 22.28% 19.63% 20.56% 22.09% 20.22%
Consumer Brands Group 3.60% 3.65% 5.53% 8.60% 5.94%
Performance Coatings Group 14.08% 10.50% 7.90% 9.88% 7.34%

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

Segment profitability ratio Reportable segment The company
Segment profit margin Paint Stores Group Paint Stores Group segment profit margin ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.
Consumer Brands Group Consumer Brands Group segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023.
Performance Coatings Group Performance Coatings Group segment profit margin ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Profit Margin: Paint Stores Group

Sherwin-Williams Co.; Paint Stores Group; segment profit margin calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in thousands)
Segment profit 2,860,800 2,348,100 2,182,200 2,294,100 2,056,500
Net sales and intersegment transfers 12,839,500 11,963,300 10,616,200 10,383,200 10,171,900
Segment Profitability Ratio
Segment profit margin1 22.28% 19.63% 20.56% 22.09% 20.22%

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

1 2023 Calculation
Segment profit margin = 100 × Segment profit ÷ Net sales and intersegment transfers
= 100 × 2,860,800 ÷ 12,839,500 = 22.28%

Segment profitability ratio Reportable segment The company
Segment profit margin Paint Stores Group Paint Stores Group segment profit margin ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

Segment Profit Margin: Consumer Brands Group

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

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in thousands)
Segment profit 309,300 314,200 415,300 579,600 373,200
Net sales and intersegment transfers 8,599,600 8,603,200 7,506,000 6,741,800 6,283,800
Segment Profitability Ratio
Segment profit margin1 3.60% 3.65% 5.53% 8.60% 5.94%

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

1 2023 Calculation
Segment profit margin = 100 × Segment profit ÷ Net sales and intersegment transfers
= 100 × 309,300 ÷ 8,599,600 = 3.60%

Segment profitability ratio Reportable segment The company
Segment profit margin Consumer Brands Group Consumer Brands Group segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Profit Margin: Performance Coatings Group

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

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in thousands)
Segment profit 991,600 734,900 486,200 500,100 379,100
Net sales and intersegment transfers 7,040,900 6,997,200 6,153,500 5,059,500 5,165,400
Segment Profitability Ratio
Segment profit margin1 14.08% 10.50% 7.90% 9.88% 7.34%

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

1 2023 Calculation
Segment profit margin = 100 × Segment profit ÷ Net sales and intersegment transfers
= 100 × 991,600 ÷ 7,040,900 = 14.08%

Segment profitability ratio Reportable segment The company
Segment profit margin Performance Coatings Group Performance Coatings Group segment profit margin ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Return on Assets (Segment ROA)

Sherwin-Williams Co., ROA by reportable segment

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Paint Stores Group 49.79% 39.98% 39.67% 42.59% 38.09%
Consumer Brands Group 4.66% 4.66% 7.85% 10.76% 6.66%
Performance Coatings Group 12.00% 8.86% 5.80% 6.20% 4.64%

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

Segment profitability ratio Reportable segment The company
Segment ROA Paint Stores Group Paint Stores Group segment ROA improved from 2021 to 2022 and from 2022 to 2023.
Consumer Brands Group Consumer Brands Group segment ROA deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.
Performance Coatings Group Performance Coatings Group segment ROA improved from 2021 to 2022 and from 2022 to 2023.

Segment ROA: Paint Stores Group

Sherwin-Williams Co.; Paint Stores Group; segment ROA calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in thousands)
Segment profit 2,860,800 2,348,100 2,182,200 2,294,100 2,056,500
Identifiable assets 5,745,300 5,873,600 5,501,300 5,386,600 5,399,100
Segment Profitability Ratio
Segment ROA1 49.79% 39.98% 39.67% 42.59% 38.09%

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

1 2023 Calculation
Segment ROA = 100 × Segment profit ÷ Identifiable assets
= 100 × 2,860,800 ÷ 5,745,300 = 49.79%

Segment profitability ratio Reportable segment The company
Segment ROA Paint Stores Group Paint Stores Group segment ROA improved from 2021 to 2022 and from 2022 to 2023.

Segment ROA: Consumer Brands Group

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

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in thousands)
Segment profit 309,300 314,200 415,300 579,600 373,200
Identifiable assets 6,631,800 6,749,600 5,287,700 5,387,400 5,600,800
Segment Profitability Ratio
Segment ROA1 4.66% 4.66% 7.85% 10.76% 6.66%

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

1 2023 Calculation
Segment ROA = 100 × Segment profit ÷ Identifiable assets
= 100 × 309,300 ÷ 6,631,800 = 4.66%

Segment profitability ratio Reportable segment The company
Segment ROA Consumer Brands Group Consumer Brands Group segment ROA deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.

Segment ROA: Performance Coatings Group

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

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in thousands)
Segment profit 991,600 734,900 486,200 500,100 379,100
Identifiable assets 8,266,600 8,296,800 8,388,600 8,071,100 8,175,600
Segment Profitability Ratio
Segment ROA1 12.00% 8.86% 5.80% 6.20% 4.64%

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

1 2023 Calculation
Segment ROA = 100 × Segment profit ÷ Identifiable assets
= 100 × 991,600 ÷ 8,266,600 = 12.00%

Segment profitability ratio Reportable segment The company
Segment ROA Performance Coatings Group Performance Coatings Group segment ROA improved from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover

Sherwin-Williams Co., asset turnover by reportable segment

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Paint Stores Group 2.23 2.04 1.93 1.93 1.88
Consumer Brands Group 1.30 1.27 1.42 1.25 1.12
Performance Coatings Group 0.85 0.84 0.73 0.63 0.63

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

Segment activity ratio Reportable segment The company
Segment asset turnover Paint Stores Group Paint Stores Group segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.
Consumer Brands Group Consumer Brands Group segment asset turnover ratio deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.
Performance Coatings Group Performance Coatings Group segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover: Paint Stores Group

Sherwin-Williams Co.; Paint Stores Group; segment asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in thousands)
Net sales and intersegment transfers 12,839,500 11,963,300 10,616,200 10,383,200 10,171,900
Identifiable assets 5,745,300 5,873,600 5,501,300 5,386,600 5,399,100
Segment Activity Ratio
Segment asset turnover1 2.23 2.04 1.93 1.93 1.88

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

1 2023 Calculation
Segment asset turnover = Net sales and intersegment transfers ÷ Identifiable assets
= 12,839,500 ÷ 5,745,300 = 2.23

Segment activity ratio Reportable segment The company
Segment asset turnover Paint Stores Group Paint Stores Group segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover: Consumer Brands Group

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

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in thousands)
Net sales and intersegment transfers 8,599,600 8,603,200 7,506,000 6,741,800 6,283,800
Identifiable assets 6,631,800 6,749,600 5,287,700 5,387,400 5,600,800
Segment Activity Ratio
Segment asset turnover1 1.30 1.27 1.42 1.25 1.12

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

1 2023 Calculation
Segment asset turnover = Net sales and intersegment transfers ÷ Identifiable assets
= 8,599,600 ÷ 6,631,800 = 1.30

Segment activity ratio Reportable segment The company
Segment asset turnover Consumer Brands Group Consumer Brands Group segment asset turnover ratio deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.

Segment Asset Turnover: Performance Coatings Group

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

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in thousands)
Net sales and intersegment transfers 7,040,900 6,997,200 6,153,500 5,059,500 5,165,400
Identifiable assets 8,266,600 8,296,800 8,388,600 8,071,100 8,175,600
Segment Activity Ratio
Segment asset turnover1 0.85 0.84 0.73 0.63 0.63

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

1 2023 Calculation
Segment asset turnover = Net sales and intersegment transfers ÷ Identifiable assets
= 7,040,900 ÷ 8,266,600 = 0.85

Segment activity ratio Reportable segment The company
Segment asset turnover Performance Coatings Group Performance Coatings Group segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Capital Expenditures to Depreciation

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

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Paint Stores Group 1.41 1.18 1.09 0.88 1.02
Consumer Brands Group 2.04 2.34 1.41 1.03 1.64
Performance Coatings Group 1.25 1.33 1.37 0.62 1.19

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

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Paint Stores Group Paint Stores Group segment capital expenditures to depreciation ratio improved from 2021 to 2022 and from 2022 to 2023.
Consumer Brands Group Consumer Brands Group segment capital expenditures to depreciation ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.
Performance Coatings Group Performance Coatings Group segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Capital Expenditures to Depreciation: Paint Stores Group

Sherwin-Williams Co.; Paint Stores Group; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in thousands)
Capital expenditures 111,400 87,300 77,600 63,900 73,300
Depreciation 79,000 73,900 71,300 73,000 72,200
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.41 1.18 1.09 0.88 1.02

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

1 2023 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation
= 111,400 ÷ 79,000 = 1.41

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Paint Stores Group Paint Stores Group segment capital expenditures to depreciation ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Capital Expenditures to Depreciation: Consumer Brands Group

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

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in thousands)
Capital expenditures 309,600 295,000 125,500 89,800 133,400
Depreciation 151,400 126,200 88,800 87,600 81,100
Segment Financial Ratio
Segment capital expenditures to depreciation1 2.04 2.34 1.41 1.03 1.64

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

1 2023 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation
= 309,600 ÷ 151,400 = 2.04

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Consumer Brands Group Consumer Brands Group segment capital expenditures to depreciation ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Segment Capital Expenditures to Depreciation: Performance Coatings Group

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

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in thousands)
Capital expenditures 32,600 38,700 90,800 43,000 84,200
Depreciation 26,000 29,100 66,200 69,100 70,900
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.25 1.33 1.37 0.62 1.19

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

1 2023 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation
= 32,600 ÷ 26,000 = 1.25

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 2021 to 2022 and from 2022 to 2023.

Net sales and intersegment transfers

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

US$ in thousands

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Paint Stores Group 12,839,500 11,963,300 10,616,200 10,383,200 10,171,900
Consumer Brands Group 8,599,600 8,603,200 7,506,000 6,741,800 6,283,800
Performance Coatings Group 7,040,900 6,997,200 6,153,500 5,059,500 5,165,400
Administrative (5,428,100) (5,414,800) (4,331,100) (3,822,800) (3,720,300)
Consolidated totals 23,051,900 22,148,900 19,944,600 18,361,700 17,900,800

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


Segment profit

Sherwin-Williams Co., segment profit by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Paint Stores Group 2,860,800 2,348,100 2,182,200 2,294,100 2,056,500
Consumer Brands Group 309,300 314,200 415,300 579,600 373,200
Performance Coatings Group 991,600 734,900 486,200 500,100 379,100
Consolidated totals 4,161,700 3,397,200 3,083,700 3,373,800 2,808,800

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


Identifiable assets

Sherwin-Williams Co., identifiable assets by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Paint Stores Group 5,745,300 5,873,600 5,501,300 5,386,600 5,399,100
Consumer Brands Group 6,631,800 6,749,600 5,287,700 5,387,400 5,600,800
Performance Coatings Group 8,266,600 8,296,800 8,388,600 8,071,100 8,175,600
Administrative 2,310,700 1,674,000 1,489,100 1,556,500 1,320,700
Consolidated totals 22,954,400 22,594,000 20,666,700 20,401,600 20,496,200

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


Capital expenditures

Sherwin-Williams Co., capital expenditures by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Paint Stores Group 111,400 87,300 77,600 63,900 73,300
Consumer Brands Group 309,600 295,000 125,500 89,800 133,400
Performance Coatings Group 32,600 38,700 90,800 43,000 84,200
Administrative 434,800 223,500 78,100 107,100 38,000
Consolidated totals 888,400 644,500 372,000 303,800 328,900

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


Depreciation

Sherwin-Williams Co., depreciation by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Paint Stores Group 79,000 73,900 71,300 73,000 72,200
Consumer Brands Group 151,400 126,200 88,800 87,600 81,100
Performance Coatings Group 26,000 29,100 66,200 69,100 70,900
Administrative 35,900 34,800 36,800 38,300 37,900
Consolidated totals 292,300 264,000 263,100 268,000 262,100

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