Adjustments to Current Assets
Adjustments to Total Assets
Adjustments to Total Liabilities
Adjustments to Stockholders’ Equity
Adjustments to Capitalization Table
Adjustments to Reported Income

Sherwin-Williams Co., adjusted current assets

US$ in thousands

	Dec 31, 2023	Dec 31, 2022	Dec 31, 2021	Dec 31, 2020	Dec 31, 2019
As Reported
Current assets	5,512,900)	5,907,700)	5,053,700)	4,591,400)	4,631,700)
Adjustments
Add: Allowance for current expected credit losses	59,600)	56,600)	48,900)	53,500)	36,500)
Add: Excess of FIFO over LIFO¹	668,000)	792,700)	593,000)	312,100)	339,800)
After Adjustment
Adjusted current assets	6,240,500)	6,757,000)	5,695,600)	4,957,000)	5,008,000)

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

¹ Excess of FIFO over LIFO. See details »

Download chart

Sherwin-Williams Co., adjusted total assets

US$ in thousands

	Dec 31, 2023	Dec 31, 2022	Dec 31, 2021	Dec 31, 2020	Dec 31, 2019
As Reported
Total assets	22,954,400)	22,594,000)	20,666,700)	20,401,600)	20,496,200)
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)¹	—)	—)	—)	—)	—)
Add: Allowance for current expected credit losses	59,600)	56,600)	48,900)	53,500)	36,500)
Add: Excess of FIFO over LIFO²	668,000)	792,700)	593,000)	312,100)	339,800)
Less: Deferred tax assets³	77,000)	77,000)	62,800)	67,600)	58,300)
After Adjustment
Adjusted total assets	23,605,000)	23,366,300)	21,245,800)	20,699,600)	20,814,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).

¹ Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »

² Excess of FIFO over LIFO. See details »

³ Deferred tax assets. See details »

Download chart

Sherwin-Williams Co., adjusted total liabilities

US$ in thousands

	Dec 31, 2023	Dec 31, 2022	Dec 31, 2021	Dec 31, 2020	Dec 31, 2019
As Reported
Total liabilities	19,238,600)	19,491,900)	18,229,500)	16,790,800)	16,372,900)
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)¹	—)	—)	—)	—)	—)
Less: Deferred tax liabilities²	683,100)	681,600)	768,200)	846,100)	969,900)
Less: Accrual for product warranty claims	40,400)	36,200)	35,200)	43,300)	42,300)
Less: Restructuring Plan	—)	41,700)	—)	—)	—)
After Adjustment
Adjusted total liabilities	18,515,100)	18,732,400)	17,426,100)	15,901,400)	15,360,700)

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

¹ Operating lease liability (before adoption of FASB Topic 842). See details »

² Deferred tax liabilities. See details »

Download chart

Sherwin-Williams Co., adjusted shareholders’ equity

US$ in thousands

	Dec 31, 2023	Dec 31, 2022	Dec 31, 2021	Dec 31, 2020	Dec 31, 2019
As Reported
Shareholders’ equity	3,715,800)	3,102,100)	2,437,200)	3,610,800)	4,123,300)
Adjustments
Less: Net deferred tax assets (liabilities)¹	(606,100)	(604,600)	(705,400)	(778,500)	(911,600)
Add: Allowance for current expected credit losses	59,600)	56,600)	48,900)	53,500)	36,500)
Add: Excess of FIFO over LIFO²	668,000)	792,700)	593,000)	312,100)	339,800)
Add: Accrual for product warranty claims	40,400)	36,200)	35,200)	43,300)	42,300)
Add: Restructuring Plan	—)	41,700)	—)	—)	—)
After Adjustment
Adjusted shareholders’ equity	5,089,900)	4,633,900)	3,819,700)	4,798,200)	5,453,500)

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

¹ Net deferred tax assets (liabilities). See details »

² Excess of FIFO over LIFO. See details »

Download chart

Sherwin-Williams Co., adjusted capitalization table

US$ in thousands

	Dec 31, 2023	Dec 31, 2022	Dec 31, 2021	Dec 31, 2020	Dec 31, 2019
As Reported
Short-term borrowings	374,200)	978,100)	763,500)	100)	204,700)
Current portion of long-term debt	1,098,800)	600)	260,600)	25,100)	429,800)
Long-term debt, excluding current portion	8,377,900)	9,591,000)	8,590,900)	8,266,900)	8,050,700)
Total reported debt	9,850,900)	10,569,700)	9,615,000)	8,292,100)	8,685,200)
Shareholders’ equity	3,715,800)	3,102,100)	2,437,200)	3,610,800)	4,123,300)
Total reported capital	13,566,700)	13,671,800)	12,052,200)	11,902,900)	12,808,500)
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)¹	—)	—)	—)	—)	—)
Add: Current portion of operating lease liabilities²	449,300)	425,300)	409,700)	387,300)	371,600)
Add: Long-term operating lease liabilities, excluding current portion³	1,509,500)	1,512,900)	1,470,700)	1,434,100)	1,370,700)
Adjusted total debt	11,809,700)	12,507,900)	11,495,400)	10,113,500)	10,427,500)
Adjustments to Equity
Less: Net deferred tax assets (liabilities)⁴	(606,100)	(604,600)	(705,400)	(778,500)	(911,600)
Add: Allowance for current expected credit losses	59,600)	56,600)	48,900)	53,500)	36,500)
Add: Excess of FIFO over LIFO⁵	668,000)	792,700)	593,000)	312,100)	339,800)
Add: Accrual for product warranty claims	40,400)	36,200)	35,200)	43,300)	42,300)
Add: Restructuring Plan	—)	41,700)	—)	—)	—)
Adjusted shareholders’ equity	5,089,900)	4,633,900)	3,819,700)	4,798,200)	5,453,500)
After Adjustment
Adjusted total capital	16,899,600)	17,141,800)	15,315,100)	14,911,700)	15,881,000)

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

¹ Operating lease liability (before adoption of FASB Topic 842). See details »

² Current portion of operating lease liabilities. See details »

³ Long-term operating lease liabilities, excluding current portion. See details »

⁴ Net deferred tax assets (liabilities). See details »

⁵ Excess of FIFO over LIFO. See details »

Download chart

Sherwin-Williams Co., adjusted net income

US$ in thousands

12 months ended:	Dec 31, 2023	Dec 31, 2022	Dec 31, 2021	Dec 31, 2020	Dec 31, 2019
As Reported
Net income	2,388,800)	2,020,100)	1,864,400)	2,030,400)	1,541,300)
Adjustments
Add: Deferred income tax expense (benefit)¹	(88,900)	(144,800)	(80,300)	(145,300)	(131,100)
Add: Increase (decrease) in allowance for current expected credit losses	3,000)	7,700)	(4,600)	17,000)	(9,400)
Add: Increase (decrease) in LIFO reserve²	(124,700)	199,700)	280,900)	(27,700)	(37,300)
Add: Increase (decrease) in accrual for product warranty claims	4,200)	1,000)	(8,100)	1,000)	(14,800)
Add: Increase (decrease) in restructuring Plan	(41,700)	41,700)	—)	—)	—)
Add: Other comprehensive income (loss), net of tax	76,300)	(2,200)	19,900)	(38,800)	(41,300)
After Adjustment
Adjusted net income	2,217,000)	2,123,200)	2,072,200)	1,836,600)	1,307,400)

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

¹ Deferred income tax expense (benefit). See details »

² Increase (decrease) in LIFO reserve. See details »

Download chart

Sherwin-Williams Co. (NYSE:SHW)

Adjustments to Financial Statements

Adjustments to Current Assets

Adjustments to Total Assets

Adjustments to Total Liabilities

Adjustments to Stockholders’ Equity

Adjustments to Capitalization Table

Adjustments to Reported Income