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, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Paint Stores Group 22.01% 22.28% 19.63% 20.56% 22.09%
Consumer Brands Group 7.01% 3.60% 3.65% 5.53% 8.60%
Performance Coatings Group 15.00% 14.08% 10.50% 7.90% 9.88%

Based on: 10-K (reporting date: 2024-12-31), 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).

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

Segment Profit Margin: Paint Stores Group

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

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in thousands)
Income before income taxes 2,902,600 2,860,800 2,348,100 2,182,200 2,294,100
Net sales and intersegment transfers 13,188,000 12,839,500 11,963,300 10,616,200 10,383,200
Segment Profitability Ratio
Segment profit margin1 22.01% 22.28% 19.63% 20.56% 22.09%

Based on: 10-K (reporting date: 2024-12-31), 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).

1 2024 Calculation
Segment profit margin = 100 × Income before income taxes ÷ Net sales and intersegment transfers
= 100 × 2,902,600 ÷ 13,188,000 = 22.01%

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

Segment Profit Margin: Consumer Brands Group

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

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in thousands)
Income before income taxes 589,900 309,300 314,200 415,300 579,600
Net sales and intersegment transfers 8,412,300 8,599,600 8,603,200 7,506,000 6,741,800
Segment Profitability Ratio
Segment profit margin1 7.01% 3.60% 3.65% 5.53% 8.60%

Based on: 10-K (reporting date: 2024-12-31), 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).

1 2024 Calculation
Segment profit margin = 100 × Income before income taxes ÷ Net sales and intersegment transfers
= 100 × 589,900 ÷ 8,412,300 = 7.01%

Segment profitability ratio Reportable segment The company
Segment profit margin Consumer Brands Group Consumer Brands Group segment profit margin ratio deteriorated from 2022 to 2023 but then improved from 2023 to 2024 exceeding 2022 level.

Segment Profit Margin: Performance Coatings Group

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

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in thousands)
Income before income taxes 1,027,900 991,600 734,900 486,200 500,100
Net sales and intersegment transfers 6,854,100 7,040,900 6,997,200 6,153,500 5,059,500
Segment Profitability Ratio
Segment profit margin1 15.00% 14.08% 10.50% 7.90% 9.88%

Based on: 10-K (reporting date: 2024-12-31), 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).

1 2024 Calculation
Segment profit margin = 100 × Income before income taxes ÷ Net sales and intersegment transfers
= 100 × 1,027,900 ÷ 6,854,100 = 15.00%

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

Segment Return on Assets (Segment ROA)

Sherwin-Williams Co., ROA by reportable segment

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Paint Stores Group 49.38% 49.79% 39.98% 39.67% 42.59%
Consumer Brands Group 8.61% 4.66% 4.66% 7.85% 10.76%
Performance Coatings Group 13.10% 12.00% 8.86% 5.80% 6.20%

Based on: 10-K (reporting date: 2024-12-31), 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).

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

Segment ROA: Paint Stores Group

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

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in thousands)
Income before income taxes 2,902,600 2,860,800 2,348,100 2,182,200 2,294,100
Identifiable assets 5,878,000 5,745,300 5,873,600 5,501,300 5,386,600
Segment Profitability Ratio
Segment ROA1 49.38% 49.79% 39.98% 39.67% 42.59%

Based on: 10-K (reporting date: 2024-12-31), 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).

1 2024 Calculation
Segment ROA = 100 × Income before income taxes ÷ Identifiable assets
= 100 × 2,902,600 ÷ 5,878,000 = 49.38%

Segment profitability ratio Reportable segment The company
Segment ROA Paint Stores Group Paint Stores Group segment ROA improved from 2022 to 2023 but then slightly deteriorated from 2023 to 2024.

Segment ROA: Consumer Brands Group

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

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in thousands)
Income before income taxes 589,900 309,300 314,200 415,300 579,600
Identifiable assets 6,854,700 6,631,800 6,749,600 5,287,700 5,387,400
Segment Profitability Ratio
Segment ROA1 8.61% 4.66% 4.66% 7.85% 10.76%

Based on: 10-K (reporting date: 2024-12-31), 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).

1 2024 Calculation
Segment ROA = 100 × Income before income taxes ÷ Identifiable assets
= 100 × 589,900 ÷ 6,854,700 = 8.61%

Segment profitability ratio Reportable segment The company
Segment ROA Consumer Brands Group Consumer Brands Group segment ROA improved from 2022 to 2023 and from 2023 to 2024.

Segment ROA: Performance Coatings Group

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

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Selected Financial Data (US$ in thousands)
Income before income taxes 1,027,900 991,600 734,900 486,200 500,100
Identifiable assets 7,847,400 8,266,600 8,296,800 8,388,600 8,071,100
Segment Profitability Ratio
Segment ROA1 13.10% 12.00% 8.86% 5.80% 6.20%

Based on: 10-K (reporting date: 2024-12-31), 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).

1 2024 Calculation
Segment ROA = 100 × Income before income taxes ÷ Identifiable assets
= 100 × 1,027,900 ÷ 7,847,400 = 13.10%

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

Segment Asset Turnover

Sherwin-Williams Co., asset turnover by reportable segment

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Paint Stores Group 2.24 2.23 2.04 1.93 1.93
Consumer Brands Group 1.23 1.30 1.27 1.42 1.25
Performance Coatings Group 0.87 0.85 0.84 0.73 0.63

Based on: 10-K (reporting date: 2024-12-31), 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).

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

Segment Asset Turnover: Paint Stores Group

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

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

Based on: 10-K (reporting date: 2024-12-31), 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).

1 2024 Calculation
Segment asset turnover = Net sales and intersegment transfers ÷ Identifiable assets
= 13,188,000 ÷ 5,878,000 = 2.24

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

Segment Asset Turnover: Consumer Brands Group

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

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

Based on: 10-K (reporting date: 2024-12-31), 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).

1 2024 Calculation
Segment asset turnover = Net sales and intersegment transfers ÷ Identifiable assets
= 8,412,300 ÷ 6,854,700 = 1.23

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

Segment Asset Turnover: Performance Coatings Group

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

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

Based on: 10-K (reporting date: 2024-12-31), 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).

1 2024 Calculation
Segment asset turnover = Net sales and intersegment transfers ÷ Identifiable assets
= 6,854,100 ÷ 7,847,400 = 0.87

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

Segment Capital Expenditures to Depreciation

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

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Paint Stores Group 1.57 1.41 1.18 1.09 0.88
Consumer Brands Group 1.78 2.04 2.34 1.41 1.03
Performance Coatings Group 0.84 1.25 1.33 1.37 0.62

Based on: 10-K (reporting date: 2024-12-31), 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).

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 2022 to 2023 and from 2023 to 2024.
Consumer Brands Group Consumer Brands Group segment capital expenditures to depreciation ratio deteriorated from 2022 to 2023 and from 2023 to 2024.
Performance Coatings Group Performance Coatings Group segment capital expenditures to depreciation ratio deteriorated from 2022 to 2023 and from 2023 to 2024.

Segment Capital Expenditures to Depreciation: Paint Stores Group

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

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

Based on: 10-K (reporting date: 2024-12-31), 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).

1 2024 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation
= 141,300 ÷ 89,900 = 1.57

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

Segment Capital Expenditures to Depreciation: Consumer Brands Group

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

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

Based on: 10-K (reporting date: 2024-12-31), 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).

1 2024 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation
= 290,300 ÷ 162,700 = 1.78

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

Segment Capital Expenditures to Depreciation: Performance Coatings Group

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

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

Based on: 10-K (reporting date: 2024-12-31), 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).

1 2024 Calculation
Segment capital expenditures to depreciation = Capital expenditures ÷ Depreciation
= 15,200 ÷ 18,000 = 0.84

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

Net sales and intersegment transfers

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

US$ in thousands

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

Based on: 10-K (reporting date: 2024-12-31), 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).


Income before income taxes

Sherwin-Williams Co., income before income taxes by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Paint Stores Group 2,902,600 2,860,800 2,348,100 2,182,200 2,294,100
Consumer Brands Group 589,900 309,300 314,200 415,300 579,600
Performance Coatings Group 1,027,900 991,600 734,900 486,200 500,100
Administrative (1,068,600) (1,051,800) (824,100)
Consolidated totals 3,451,800 3,109,900 2,573,100 3,083,700 3,373,800

Based on: 10-K (reporting date: 2024-12-31), 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).


Identifiable assets

Sherwin-Williams Co., identifiable assets by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Paint Stores Group 5,878,000 5,745,300 5,873,600 5,501,300 5,386,600
Consumer Brands Group 6,854,700 6,631,800 6,749,600 5,287,700 5,387,400
Performance Coatings Group 7,847,400 8,266,600 8,296,800 8,388,600 8,071,100
Administrative 3,052,500 2,310,700 1,674,000 1,489,100 1,556,500
Consolidated totals 23,632,600 22,954,400 22,594,000 20,666,700 20,401,600

Based on: 10-K (reporting date: 2024-12-31), 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).


Capital expenditures

Sherwin-Williams Co., capital expenditures by reportable segment

US$ in thousands

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

Based on: 10-K (reporting date: 2024-12-31), 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).


Depreciation

Sherwin-Williams Co., depreciation by reportable segment

US$ in thousands

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Paint Stores Group 89,900 79,000 73,900 71,300 73,000
Consumer Brands Group 162,700 151,400 126,200 88,800 87,600
Performance Coatings Group 18,000 26,000 29,100 66,200 69,100
Administrative 26,800 35,900 34,800 36,800 38,300
Consolidated totals 297,400 292,300 264,000 263,100 268,000

Based on: 10-K (reporting date: 2024-12-31), 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).