Stock Analysis on Net
Stock Analysis on Net

Ecolab Inc. (NYSE:ECL)

This company has been moved to the archive! The financial data has not been updated since February 25, 2022.

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Current Assets

Ecolab Inc., adjusted current assets

US$ in thousands

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
As Reported
Current assets 4,687,100 5,117,400 4,828,400 4,677,700 4,596,400
Adjustments
Add: Allowance for expected credit losses 52,800 68,400 62,000 60,600 71,500
Add: LIFO cost to FIFO cost difference1 114,900 15,600 (9,300) (3,900) (32,900)
After Adjustment
Adjusted current assets 4,854,800 5,201,400 4,881,100 4,734,400 4,635,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).

1 LIFO cost to FIFO cost difference. See details »

Adjustments to Total Assets

Ecolab Inc., adjusted total assets

US$ in thousands

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
As Reported
Total assets 21,206,400 18,126,000 20,869,100 20,074,500 19,962,400
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 — — — 574,702 552,978
Add: Allowance for expected credit losses 52,800 68,400 62,000 60,600 71,500
Add: LIFO cost to FIFO cost difference2 114,900 15,600 (9,300) (3,900) (32,900)
Less: Deferred tax assets3 120,600 163,200 155,600 105,100 102,200
After Adjustment
Adjusted total assets 21,253,500 18,046,800 20,766,200 20,600,802 20,451,778

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 Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »

2 LIFO cost to FIFO cost difference. See details »

3 Deferred tax assets. See details »

Adjustments to Current Liabilities

Ecolab Inc., adjusted current liabilities

US$ in thousands

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
As Reported
Current liabilities 3,553,200 2,932,200 3,630,600 3,685,600 3,431,800
Adjustments
Less: Current restructuring liability 39,100 98,100 107,100 73,700 36,000
After Adjustment
Adjusted current liabilities 3,514,100 2,834,100 3,523,500 3,611,900 3,395,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).

Adjustments to Total Liabilities

Ecolab Inc., adjusted total liabilities

US$ in thousands

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
As Reported
Total liabilities 13,953,300 11,924,500 12,143,300 12,020,900 12,273,700
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1 — — — 574,702 552,978
Less: Deferred tax liabilities2 622,000 483,900 740,400 764,600 642,800
Less: Restructuring liability 42,400 102,400 111,700 78,800 41,500
After Adjustment
Adjusted total liabilities 13,288,900 11,338,200 11,291,200 11,752,202 12,142,378

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 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Deferred tax liabilities. See details »

Adjustments to Stockholders’ Equity

Ecolab Inc., adjusted total Ecolab shareholders’ equity

US$ in thousands

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
As Reported
Total Ecolab shareholders’ equity 7,224,200 6,166,500 8,685,300 8,003,200 7,618,500
Adjustments
Less: Net deferred tax assets (liabilities) balance1 (501,400) (320,700) (584,800) (659,500) (540,500)
Add: Allowance for expected credit losses 52,800 68,400 62,000 60,600 71,500
Add: LIFO cost to FIFO cost difference2 114,900 15,600 (9,300) (3,900) (32,900)
Add: Restructuring liability 42,400 102,400 111,700 78,800 41,500
Add: Noncontrolling interest 28,900 35,000 40,500 50,400 70,200
After Adjustment
Adjusted total equity 7,964,600 6,708,600 9,475,000 8,848,600 8,309,300

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 Net deferred tax assets (liabilities) balance. See details »

2 LIFO cost to FIFO cost difference. See details »

Adjustments to Capitalization Table

Ecolab Inc., adjusted capitalization table

US$ in thousands

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
As Reported
Short-term debt 411,000 17,300 380,600 743,600 564,400
Long-term debt, excluding current maturities 8,347,200 6,669,300 5,973,500 6,301,600 6,758,300
Total reported debt 8,758,200 6,686,600 6,354,100 7,045,200 7,322,700
Total Ecolab shareholders’ equity 7,224,200 6,166,500 8,685,300 8,003,200 7,618,500
Total reported capital 15,982,400 12,853,100 15,039,400 15,048,400 14,941,200
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1 — — — 574,702 552,978
Add: Current operating lease liabilities2 115,100 125,600 153,200 — —
Add: Noncurrent operating lease liabilities3 282,600 300,500 425,200 — —
Adjusted total debt 9,155,900 7,112,700 6,932,500 7,619,902 7,875,678
Adjustments to Equity
Less: Net deferred tax assets (liabilities) balance4 (501,400) (320,700) (584,800) (659,500) (540,500)
Add: Allowance for expected credit losses 52,800 68,400 62,000 60,600 71,500
Add: LIFO cost to FIFO cost difference5 114,900 15,600 (9,300) (3,900) (32,900)
Add: Restructuring liability 42,400 102,400 111,700 78,800 41,500
Add: Noncontrolling interest 28,900 35,000 40,500 50,400 70,200
Adjusted total equity 7,964,600 6,708,600 9,475,000 8,848,600 8,309,300
After Adjustment
Adjusted total capital 17,120,500 13,821,300 16,407,500 16,468,502 16,184,978

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 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Current operating lease liabilities. See details »

3 Noncurrent operating lease liabilities. See details »

4 Net deferred tax assets (liabilities) balance. See details »

5 LIFO cost to FIFO cost difference. See details »

Adjustments to Reported Income

Ecolab Inc., adjusted net income (loss) attributable to Ecolab

US$ in thousands

Microsoft Excel
12 months ended: Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018 Dec 31, 2017
As Reported
Net income (loss) attributable to Ecolab 1,129,900 (1,205,100) 1,558,900 1,429,100 1,508,400
Adjustments
Add: Deferred income tax expense (benefit)1 (900) (39,300) (37,700) 85,100 (354,500)
Add: Increase (decrease) in allowance for expected credit losses (15,600) 29,600 1,400 (10,900) 3,900
Add: Increase (decrease) in LIFO reserve2 99,300 (9,200) (5,400) 29,000 18,100
Add: Increase (decrease) in restructuring liability (60,000) (800) 32,900 37,300 1,900
Less: Net loss from discontinued operations, net of tax — (2,172,500) — — —
Add: Other comprehensive income (loss), net of tax 356,400 97,100 (268,700) (119,400) 72,300
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest 10,900 21,400 15,400 10,100 15,700
After Adjustment
Adjusted net income (loss) including noncontrolling interest 1,520,000 1,066,200 1,296,800 1,460,300 1,265,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).

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

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