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.

Common-Size Income Statement
Quarterly Data

Ecolab Inc., common-size consolidated income statement (quarterly data)

Microsoft Excel
3 months ended: 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
Product and equipment sales 80.00 79.91 79.50 79.49 79.90 80.38 80.69 80.25 82.19 81.66 82.25 82.34 82.62 82.77 82.95 82.39 0.00 0.00 0.00 0.00
Service and lease sales 20.00 20.09 20.50 20.51 20.10 19.62 19.31 19.75 17.81 18.34 17.75 17.66 17.38 17.23 17.05 17.61 0.00 0.00 0.00 0.00
Net sales (legacy) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 100.00 100.00 100.00
Net sales 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Product and equipment cost of sales -48.98 -48.94 -46.32 -47.24 -45.99 -46.56 -48.46 -45.18 -46.84 -46.96 -48.03 -48.98 -48.42 -48.30 -47.47 -48.87 0.00 0.00 0.00 0.00
Service and lease cost of sales -11.74 -11.79 -11.99 -12.10 -12.09 -12.07 -12.44 -11.77 -10.99 -10.86 -10.70 -10.83 -10.53 -10.16 -10.69 -10.84 0.00 0.00 0.00 0.00
Cost of sales, including special charges (legacy) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -53.43 -53.08 -54.05 -53.50
Cost of sales, including special charges -60.72% -60.73% -58.30% -59.34% -58.08% -58.62% -60.90% -56.95% -57.83% -57.82% -58.74% -59.81% -58.95% -58.46% -58.17% -59.70% -53.43% -53.08% -54.05% -53.50%
Gross profit 39.28% 39.27% 41.70% 40.66% 41.92% 41.38% 39.10% 43.05% 42.17% 42.18% 41.26% 40.19% 41.05% 41.54% 41.83% 40.30% 46.57% 46.92% 45.95% 46.50%
Selling, general and administrative expenses -25.80 -25.05 -26.98 -29.91 -26.41 -26.59 -29.36 -30.07 -25.92 -25.21 -26.67 -28.56 -25.23 -25.74 -28.10 -29.34 -30.79 -30.51 -32.21 -34.50
Special gains and (charges) -1.96 -0.19 -0.56 -0.44 -1.93 -1.16 -2.58 -0.53 -1.60 -1.58 -1.33 -1.15 -0.35 -2.02 -0.33 -0.75 1.41 -0.14 -1.06 -0.20
Operating income 11.52% 14.03% 14.16% 10.31% 13.57% 13.63% 7.15% 12.45% 14.66% 15.39% 13.26% 10.48% 15.47% 13.78% 13.41% 10.21% 17.19% 16.27% 12.68% 11.81%
Other income (expense) 0.19 0.39 -0.08 0.59 0.34 0.50 0.56 0.51 0.35 0.54 0.56 0.60 0.53 0.56 0.53 0.56 0.00 0.00 0.00 0.00
Interest expense, net -1.33 -2.30 -1.44 -1.79 -1.58 -4.47 -2.19 -1.60 -1.21 -1.21 -1.32 -1.41 -1.43 -1.49 -1.53 -1.62 -2.13 -1.55 -1.72 -1.98
Income before income taxes 10.39% 12.12% 12.64% 9.10% 12.33% 9.66% 5.53% 11.37% 13.80% 14.73% 12.50% 9.67% 14.57% 12.85% 12.41% 9.14% 15.06% 14.73% 10.96% 9.83%
Provision for income taxes -1.31 -2.22 -2.72 -2.29 -2.38 -1.40 -0.53 -1.56 -2.44 -2.44 -2.60 -1.10 -3.93 -1.15 -2.83 -1.99 0.60 -3.62 -2.35 -1.71
Net income from continuing operations 9.07% 9.90% 9.92% 6.81% 9.95% 8.26% 5.00% 9.81% 11.36% 12.29% 9.90% 8.57% 10.64% 11.70% 9.58% 7.15% 15.66% 11.11% 8.61% 8.12%
Net loss from discontinued operations, net of tax 0.00 0.00 0.00 0.00 0.00 0.00 -80.57 -0.28 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net income (loss) including noncontrolling interest 9.07% 9.90% 9.92% 6.81% 9.95% 8.26% -75.57% 9.52% 11.36% 12.29% 9.90% 8.57% 10.64% 11.70% 9.58% 7.15% 15.66% 11.11% 8.61% 8.12%
Net income attributable to noncontrolling interest -0.13 -0.12 -0.09 -0.10 -0.15 -0.10 -0.20 -0.14 -0.12 -0.13 -0.10 -0.11 -0.14 -0.08 -0.06 -0.03 -0.16 -0.10 -0.04 -0.10
Net income (loss) attributable to Ecolab 8.95% 9.77% 9.83% 6.71% 9.80% 8.16% -75.77% 9.38% 11.24% 12.16% 9.80% 8.46% 10.51% 11.62% 9.52% 7.12% 15.50% 11.01% 8.57% 8.02%

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 analysis of the common-size income statement reveals a transition in revenue composition and a period of margin compression followed by operational stabilization. While net sales serve as the baseline, the underlying cost structures and profit margins exhibit distinct cyclical and structural shifts between 2017 and 2021.

Revenue Mix and Composition
A gradual shift in the revenue stream is observable. Product and equipment sales, which initially represented approximately 82% of net sales in early 2018, declined slightly to 80% by the end of 2021. Conversely, service and lease sales increased from roughly 17% to 20% over the same period, indicating a marginal move toward a more service-oriented revenue model.
Gross Profitability and Cost of Sales
A notable reduction in gross profit margins occurred between 2017 and 2018. Gross profit fell from a range of 45.9% to 46.9% in 2017 to a lower corridor of 39% to 42% from 2018 through 2021. This compression is primarily attributed to an increase in the cost of sales, which rose from approximately 53% of net sales in 2017 to fluctuate between 57% and 61% in subsequent years.
Operating Expense Management
Selling, general, and administrative (SG&A) expenses demonstrate a downward trend as a percentage of net sales. Expenses that averaged 30% to 34% in 2017 were reduced to a range of 25% to 29% between 2018 and 2021. This reduction in overhead suggests an effort to maintain operating efficiency to offset the decline in gross margins.
Operating and Net Income Volatility
Operating income remained relatively resilient, generally fluctuating between 10% and 15% of net sales, despite the gross margin pressure. However, a significant anomaly is present in the second quarter of 2020, where net income attributable to Ecolab plummeted to -75.77%. This outlier was driven by a substantial net loss from discontinued operations, which accounted for -80.57% of net sales in that specific period. Excluding this one-time event, net income attributable to Ecolab remained stable, typically ranging from 6.7% to 12.2% of net sales.
Financial Charges and Tax Provisions
Interest expenses remained relatively stable, typically oscillating between 1.3% and 2.3% of net sales, with a temporary spike to 4.47% in September 2020. The provision for income taxes showed significant variability, impacting the final net income margins across different quarters but generally remaining within a 1% to 3% range of net sales.

AI Ask an analyst for more

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.

How can I help you?