Stock Analysis on Net

Ecolab Inc. (NYSE:ECL)

$22.49

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

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
Quarterly Data

Microsoft Excel

Paying user area


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Two-Component Disaggregation of ROE

Ecolab Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = ROA × Financial Leverage
Dec 31, 2021 = ×
Sep 30, 2021 = ×
Jun 30, 2021 = ×
Mar 31, 2021 = ×
Dec 31, 2020 = ×
Sep 30, 2020 = ×
Jun 30, 2020 = ×
Mar 31, 2020 = ×
Dec 31, 2019 = ×
Sep 30, 2019 = ×
Jun 30, 2019 = ×
Mar 31, 2019 = ×
Dec 31, 2018 = ×
Sep 30, 2018 = ×
Jun 30, 2018 = ×
Mar 31, 2018 = ×
Dec 31, 2017 = ×
Sep 30, 2017 = ×
Jun 30, 2017 = ×
Mar 31, 2017 = ×

Based on: 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).


Return on Assets (ROA)
The ROA exhibited an upward trend from March 31, 2017, through December 31, 2018, peaking around 8.01%. This was followed by a slight decline throughout 2019, maintaining values slightly above 7%. In 2020, there was a pronounced negative shift with ROA dropping sharply to lows between -4.74% and -7.11%. A recovery trend commenced in 2021, with ROA climbing back to positive territory, reaching approximately 6.3% by mid-year before a slight decline at the end of 2021.
Financial Leverage
The financial leverage ratio started at 2.82 in early 2017 and showed a moderate downward trend through 2018 and 2019, reaching a low around 2.4 by the end of 2019. In 2020, financial leverage increased significantly, reaching a peak of 3.09 in mid-2020. Subsequently, it declined gradually through 2021, ending near 2.94 by the last quarter. Overall, leverage was relatively stable with fluctuations primarily concentrated in the pandemic-affected year 2020.
Return on Equity (ROE)
The ROE displayed strong performance from March 31, 2017, through 2018, with values consistently around 19.8% to 20.18%. During 2019, ROE decreased moderately, stabilizing around 17.5% to 18.2%. In 2020, a steep decline occurred, with negative values reaching as low as -20.58%, reflecting substantial profitability challenges. Recovery began in 2021, with ROE improving to the mid-teens range, approximately 15.66% to 16.29%, though still below pre-2020 levels.
General Observations
The data indicates a period of strong asset efficiency and profitability before 2020, followed by a significant downturn in both profitability metrics during 2020, coinciding with increased financial leverage. This downturn was likely associated with adverse economic conditions. The subsequent recovery phase in 2021 shows a return toward pre-2020 financial performance, although full recovery to earlier peak levels had not yet been achieved by the end of 2021.

Three-Component Disaggregation of ROE

Ecolab Inc., decomposition of ROE (quarterly data)

Microsoft Excel
ROE = Net Profit Margin × Asset Turnover × Financial Leverage
Dec 31, 2021 = × ×
Sep 30, 2021 = × ×
Jun 30, 2021 = × ×
Mar 31, 2021 = × ×
Dec 31, 2020 = × ×
Sep 30, 2020 = × ×
Jun 30, 2020 = × ×
Mar 31, 2020 = × ×
Dec 31, 2019 = × ×
Sep 30, 2019 = × ×
Jun 30, 2019 = × ×
Mar 31, 2019 = × ×
Dec 31, 2018 = × ×
Sep 30, 2018 = × ×
Jun 30, 2018 = × ×
Mar 31, 2018 = × ×
Dec 31, 2017 = × ×
Sep 30, 2017 = × ×
Jun 30, 2017 = × ×
Mar 31, 2017 = × ×

Based on: 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).


The financial data reveals several noteworthy trends over the reported periods:

Net Profit Margin
The net profit margin shows a relatively stable positive trend from early 2018 through to early 2020, maintaining values around 10 to 11%. However, a pronounced decline occurs beginning in the first quarter of 2020, with margins turning sharply negative and reaching a low point near -11.11% by the end of 2020. Recovery is evident in 2021, with margins returning to positive territory and stabilizing around 8.7 to 9.1%.
Asset Turnover
Asset turnover ratios exhibit minor fluctuations, ranging generally between 0.6 and 0.74. Starting from around 0.69 in early 2018, a slight increase is noted mid-year, peaking near 0.74 in mid-2020. This is followed by a downward adjustment toward the end of 2020 and into 2021, with a dip to 0.6 before modestly recovering toward 0.69.
Financial Leverage
Financial leverage ratios show a modest decline from 2.82 in early 2017 towards approximately 2.4-2.5 between late 2018 and early 2019. A marked increase occurs in mid-2020, peaking at over 3.0, before gradually decreasing again into 2021, settling near 2.6 to 2.9 by year-end.
Return on Equity (ROE)
ROE follows a trajectory similar to the net profit margin. From early 2018 through early 2020, ROE remains in the range of approximately 17.5% to 20.2%, indicating consistent profitability and equity efficiency. This is interrupted by a significant downturn in 2020, with ROE turning negative and bottoming near -20.6%. A recovery phase unfolds throughout 2021, with ROE improving but not fully returning to the pre-2020 peak levels, stabilizing around 15.6% to 16.3% by the end of the year.

Overall, the data indicates that the company maintained solid profitability and operational efficiency through 2018 and 2019, experienced a severe financial impact during 2020 likely due to external disruptions, and demonstrated a recovery trend in 2021 with gradual improvement in profitability, asset use, and leverage management.


Two-Component Disaggregation of ROA

Ecolab Inc., decomposition of ROA (quarterly data)

Microsoft Excel
ROA = Net Profit Margin × Asset Turnover
Dec 31, 2021 = ×
Sep 30, 2021 = ×
Jun 30, 2021 = ×
Mar 31, 2021 = ×
Dec 31, 2020 = ×
Sep 30, 2020 = ×
Jun 30, 2020 = ×
Mar 31, 2020 = ×
Dec 31, 2019 = ×
Sep 30, 2019 = ×
Jun 30, 2019 = ×
Mar 31, 2019 = ×
Dec 31, 2018 = ×
Sep 30, 2018 = ×
Jun 30, 2018 = ×
Mar 31, 2018 = ×
Dec 31, 2017 = ×
Sep 30, 2017 = ×
Jun 30, 2017 = ×
Mar 31, 2017 = ×

Based on: 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).


Net Profit Margin
The net profit margin exhibits a generally stable trend from March 2018 through March 2020, remaining slightly above 10% with minor fluctuations between 9.74% and 10.99%. However, a significant decline is observed from March 2020 to December 2020, with values turning negative and reaching a low of -11.11% in the last quarter of 2020. This negative trend reverses starting in March 2021, with a recovery to positive margins around 8.66% to 9.08% by the end of 2021.
Asset Turnover
Asset turnover ratios show modest variability but remain relatively consistent from March 2018 through December 2019, fluctuating around 0.69 to 0.73. In 2020, there is a noticeable decline, particularly from March to September, where the ratio falls to as low as 0.64, before slightly recovering to 0.69 by the end of 2021. The overall trend indicates a temporary reduction in the efficiency of asset utilization during 2020, with partial recovery in 2021.
Return on Assets (ROA)
ROA follows a pattern similar to the net profit margin. It maintains steady levels between 6.9% and 8.01% until the end of 2019. A sharp decrease occurs during 2020, with negative values peaking at -7.11% in December 2020. Starting in March 2021, the ROA improves back to positive territory but remains lower than pre-2020 levels, fluctuating between 5.33% and 6.3% by the end of 2021.