Paying users zone. Data is hidden behind hidden.

We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Verified by Visa MasterCard SecureCode American Express SafeKey
Unlock

This is a one-time payment. There is no automatic renewal.

Microsoft Excel LibreOffice Calc

Ecolab Inc. (NYSE:ECL)

Adjustments to Financial Statements

Advanced level

Adjustments to Current Assets

Ecolab Inc., adjusted current assets

US$ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
As Reported
Current assets
Adjustments
Add: Allowance for doubtful accounts
Add: LIFO cost to FIFO cost difference1
Less: Current deferred tax assets2
After Adjustment
Adjusted current assets

Based on: 10-K (filing date: 2020-02-28), 10-K (filing date: 2019-03-01), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26).

1 LIFO cost to FIFO cost difference. See details »

2 Current deferred tax assets. See details »

Adjustments to Total Assets

Ecolab Inc., adjusted total assets

US$ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
As Reported
Total assets
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1
Add: Allowance for doubtful accounts
Add: LIFO cost to FIFO cost difference2
Less: Current deferred tax assets3
Less: Noncurrent deferred tax assets4
After Adjustment
Adjusted total assets

Based on: 10-K (filing date: 2020-02-28), 10-K (filing date: 2019-03-01), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26).

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 Current deferred tax assets. See details »

4 Noncurrent deferred tax assets. See details »

Adjustments to Current Liabilities

Ecolab Inc., adjusted current liabilities

US$ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
As Reported
Current liabilities
Adjustments
Less: Current deferred tax liabilities (included in Other current liabilities)1
Less: Current restructuring liability
After Adjustment
Adjusted current liabilities

Based on: 10-K (filing date: 2020-02-28), 10-K (filing date: 2019-03-01), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26).

1 Current deferred tax liabilities (included in Other current liabilities). See details »

Adjustments to Total Liabilities

Ecolab Inc., adjusted total liabilities

US$ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
As Reported
Total liabilities
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1
Less: Current deferred tax liabilities (included in Other current liabilities)2
Less: Noncurrent deferred tax liabilities3
Less: Restructuring liability
After Adjustment
Adjusted total liabilities

Based on: 10-K (filing date: 2020-02-28), 10-K (filing date: 2019-03-01), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26).

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

2 Current deferred tax liabilities (included in Other current liabilities). See details »

3 Noncurrent deferred tax liabilities. See details »

Adjustments to Stockholders’ Equity

Ecolab Inc., adjusted total Ecolab shareholders’ equity

US$ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
As Reported
Total Ecolab shareholders’ equity
Adjustments
Less: Net deferred tax assets (liabilities) balance1
Add: Allowance for doubtful accounts
Add: LIFO cost to FIFO cost difference2
Add: Restructuring liability
Add: Noncontrolling interest
After Adjustment
Adjusted total equity

Based on: 10-K (filing date: 2020-02-28), 10-K (filing date: 2019-03-01), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26).

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 LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
As Reported
Short-term debt
Long-term debt, excluding current maturities
Total reported debt
Total Ecolab shareholders’ equity
Total reported capital
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1
Add: Current operating lease liabilities2
Add: Noncurrent operating lease liabilities3
Adjusted total debt
Adjustments to Equity
Less: Net deferred tax assets (liabilities) balance4
Add: Allowance for doubtful accounts
Add: LIFO cost to FIFO cost difference5
Add: Restructuring liability
Add: Noncontrolling interest
Adjusted total equity
After Adjustment
Adjusted total capital

Based on: 10-K (filing date: 2020-02-28), 10-K (filing date: 2019-03-01), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26).

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 attributable to Ecolab

US$ in thousands

Microsoft Excel LibreOffice Calc
12 months ended Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
As Reported
Net income attributable to Ecolab
Adjustments
Add: Deferred income tax expense (benefit)1
Add: Increase (decrease) in allowance for doubtful accounts
Add: Increase (decrease) in LIFO reserve2
Add: Increase (decrease) in restructuring liability
Add: Other comprehensive income (loss), net of tax
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest
After Adjustment
Adjusted net income including noncontrolling interest

Based on: 10-K (filing date: 2020-02-28), 10-K (filing date: 2019-03-01), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-26).

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

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