Analysis of Long-term (Investment) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Long-term Activity Ratios (Summary)
Ecolab Inc., long-term (investment) activity ratios (quarterly data)
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).
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Ecolab Inc. net fixed asset turnover ratio improved from Q2 2021 to Q3 2021 but then deteriorated significantly from Q3 2021 to Q4 2021. |
| Net fixed asset turnover (including operating lease, right-of-use asset) | An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). | Ecolab Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q2 2021 to Q3 2021 but then deteriorated significantly from Q3 2021 to Q4 2021. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Ecolab Inc. total asset turnover ratio improved from Q2 2021 to Q3 2021 but then deteriorated significantly from Q3 2021 to Q4 2021. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Ecolab Inc. equity turnover ratio deteriorated from Q2 2021 to Q3 2021 and from Q3 2021 to Q4 2021. |
Net Fixed Asset Turnover
Ecolab Inc., net fixed asset turnover calculation (quarterly data)
| 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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||||||||||||||||||||||
| Net sales | 3,364,600) | 3,320,800) | 3,162,700) | 2,885,000) | 3,065,300) | 3,018,600) | 2,685,700) | 3,020,600) | 3,823,600) | 3,817,900) | 3,759,400) | 3,505,400) | 3,760,500) | 3,747,200) | 3,689,600) | 3,470,900) | 3,650,700) | 3,563,300) | 3,462,700) | 3,161,600) | ||||||
| Property, plant and equipment, net | 3,288,500) | 3,069,600) | 3,077,900) | 3,078,700) | 3,124,900) | 3,146,200) | 3,138,900) | 3,920,700) | 3,954,900) | 3,861,500) | 3,866,900) | 3,878,600) | 3,836,000) | 3,778,000) | 3,758,700) | 3,779,900) | 3,707,100) | 3,617,200) | 3,497,400) | 3,424,900) | ||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||
| Net fixed asset turnover1 | 3.87 | 4.05 | 3.94 | 3.79 | 3.77 | 3.99 | 4.25 | 3.68 | 3.77 | 3.84 | 3.82 | 3.79 | 3.82 | 3.85 | 3.82 | 3.74 | 3.73 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Net Fixed Asset Turnover, Competitors2 | ||||||||||||||||||||||||||
| Linde plc | 1.18 | 1.14 | 1.08 | 1.03 | 0.95 | 0.97 | 0.98 | 1.02 | 0.97 | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Sherwin-Williams Co. | 10.68 | 10.77 | 10.88 | 10.60 | 10.01 | 10.11 | 9.86 | 9.84 | 9.75 | — | — | — | — | — | — | — | — | — | — | — | ||||||
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).
1 Q4 2021 Calculation
Net fixed asset turnover
= (Net salesQ4 2021
+ Net salesQ3 2021
+ Net salesQ2 2021
+ Net salesQ1 2021)
÷ Property, plant and equipment, net
= (3,364,600 + 3,320,800 + 3,162,700 + 2,885,000)
÷ 3,288,500 = 3.87
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover | An activity ratio calculated as total revenue divided by net fixed assets. | Ecolab Inc. net fixed asset turnover ratio improved from Q2 2021 to Q3 2021 but then deteriorated significantly from Q3 2021 to Q4 2021. |
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)
Ecolab Inc., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)
| 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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||||||||||||||||||||||
| Net sales | 3,364,600) | 3,320,800) | 3,162,700) | 2,885,000) | 3,065,300) | 3,018,600) | 2,685,700) | 3,020,600) | 3,823,600) | 3,817,900) | 3,759,400) | 3,505,400) | 3,760,500) | 3,747,200) | 3,689,600) | 3,470,900) | 3,650,700) | 3,563,300) | 3,462,700) | 3,161,600) | ||||||
| Property, plant and equipment, net | 3,288,500) | 3,069,600) | 3,077,900) | 3,078,700) | 3,124,900) | 3,146,200) | 3,138,900) | 3,920,700) | 3,954,900) | 3,861,500) | 3,866,900) | 3,878,600) | 3,836,000) | 3,778,000) | 3,758,700) | 3,779,900) | 3,707,100) | 3,617,200) | 3,497,400) | 3,424,900) | ||||||
| Operating lease assets | 396,800) | 377,400) | 391,500) | 412,500) | 423,800) | 433,900) | 439,900) | 558,500) | 577,500) | 570,300) | 549,800) | 570,900) | —) | —) | —) | —) | —) | —) | —) | —) | ||||||
| Property, plant and equipment, net (including operating lease, right-of-use asset) | 3,685,300) | 3,447,000) | 3,469,400) | 3,491,200) | 3,548,700) | 3,580,100) | 3,578,800) | 4,479,200) | 4,532,400) | 4,431,800) | 4,416,700) | 4,449,500) | 3,836,000) | 3,778,000) | 3,758,700) | 3,779,900) | 3,707,100) | 3,617,200) | 3,497,400) | 3,424,900) | ||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||
| Net fixed asset turnover (including operating lease, right-of-use asset)1 | 3.46 | 3.61 | 3.50 | 3.34 | 3.32 | 3.51 | 3.73 | 3.22 | 3.29 | 3.35 | 3.34 | 3.30 | 3.82 | 3.85 | 3.82 | 3.74 | 3.73 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2 | ||||||||||||||||||||||||||
| Sherwin-Williams Co. | 5.41 | 5.46 | 5.50 | 5.38 | 5.11 | 5.11 | 5.07 | 5.13 | 5.08 | — | — | — | — | — | — | — | — | — | — | — | ||||||
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).
1 Q4 2021 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset)
= (Net salesQ4 2021
+ Net salesQ3 2021
+ Net salesQ2 2021
+ Net salesQ1 2021)
÷ Property, plant and equipment, net (including operating lease, right-of-use asset)
= (3,364,600 + 3,320,800 + 3,162,700 + 2,885,000)
÷ 3,685,300 = 3.46
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Net fixed asset turnover (including operating lease, right-of-use asset) | An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). | Ecolab Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q2 2021 to Q3 2021 but then deteriorated significantly from Q3 2021 to Q4 2021. |
Total Asset Turnover
Ecolab Inc., total asset turnover calculation (quarterly data)
| 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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||||||||||||||||||||||
| Net sales | 3,364,600) | 3,320,800) | 3,162,700) | 2,885,000) | 3,065,300) | 3,018,600) | 2,685,700) | 3,020,600) | 3,823,600) | 3,817,900) | 3,759,400) | 3,505,400) | 3,760,500) | 3,747,200) | 3,689,600) | 3,470,900) | 3,650,700) | 3,563,300) | 3,462,700) | 3,161,600) | ||||||
| Total assets | 21,206,400) | 17,926,200) | 18,533,700) | 18,208,100) | 18,126,000) | 18,097,100) | 18,082,400) | 22,339,600) | 20,869,100) | 20,835,600) | 20,827,600) | 20,927,600) | 20,074,500) | 19,962,600) | 19,951,600) | 20,184,300) | 19,962,400) | 19,856,700) | 19,523,400) | 19,223,000) | ||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||
| Total asset turnover1 | 0.60 | 0.69 | 0.65 | 0.64 | 0.65 | 0.69 | 0.74 | 0.65 | 0.71 | 0.71 | 0.71 | 0.70 | 0.73 | 0.73 | 0.72 | 0.70 | 0.69 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Total Asset Turnover, Competitors2 | ||||||||||||||||||||||||||
| Linde plc | 0.38 | 0.35 | 0.34 | 0.33 | 0.31 | 0.31 | 0.32 | 0.33 | 0.33 | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Sherwin-Williams Co. | 0.97 | 0.95 | 0.96 | 0.92 | 0.90 | 0.86 | 0.87 | 0.88 | 0.87 | — | — | — | — | — | — | — | — | — | — | — | ||||||
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).
1 Q4 2021 Calculation
Total asset turnover
= (Net salesQ4 2021
+ Net salesQ3 2021
+ Net salesQ2 2021
+ Net salesQ1 2021)
÷ Total assets
= (3,364,600 + 3,320,800 + 3,162,700 + 2,885,000)
÷ 21,206,400 = 0.60
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Ecolab Inc. total asset turnover ratio improved from Q2 2021 to Q3 2021 but then deteriorated significantly from Q3 2021 to Q4 2021. |
Equity Turnover
Ecolab Inc., equity turnover calculation (quarterly data)
| 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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Selected Financial Data (US$ in thousands) | ||||||||||||||||||||||||||
| Net sales | 3,364,600) | 3,320,800) | 3,162,700) | 2,885,000) | 3,065,300) | 3,018,600) | 2,685,700) | 3,020,600) | 3,823,600) | 3,817,900) | 3,759,400) | 3,505,400) | 3,760,500) | 3,747,200) | 3,689,600) | 3,470,900) | 3,650,700) | 3,563,300) | 3,462,700) | 3,161,600) | ||||||
| Total Ecolab shareholders’ equity | 7,224,200) | 6,933,500) | 6,709,100) | 6,292,300) | 6,166,500) | 6,014,700) | 5,855,200) | 8,822,100) | 8,685,300) | 8,567,700) | 8,225,400) | 8,220,700) | 8,003,200) | 7,929,400) | 7,849,500) | 7,601,000) | 7,618,500) | 7,222,300) | 6,919,700) | 6,809,400) | ||||||
| Long-term Activity Ratio | ||||||||||||||||||||||||||
| Equity turnover1 | 1.76 | 1.79 | 1.81 | 1.85 | 1.91 | 2.09 | 2.28 | 1.63 | 1.72 | 1.73 | 1.80 | 1.79 | 1.83 | 1.84 | 1.83 | 1.86 | 1.82 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Equity Turnover, Competitors2 | ||||||||||||||||||||||||||
| Linde plc | 0.70 | 0.67 | 0.63 | 0.60 | 0.58 | 0.59 | 0.60 | 0.63 | 0.58 | — | — | — | — | — | — | — | — | — | — | — | ||||||
| Sherwin-Williams Co. | 8.18 | 7.31 | 6.92 | 6.13 | 5.09 | 4.28 | 4.58 | 5.47 | 4.34 | — | — | — | — | — | — | — | — | — | — | — | ||||||
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).
1 Q4 2021 Calculation
Equity turnover
= (Net salesQ4 2021
+ Net salesQ3 2021
+ Net salesQ2 2021
+ Net salesQ1 2021)
÷ Total Ecolab shareholders’ equity
= (3,364,600 + 3,320,800 + 3,162,700 + 2,885,000)
÷ 7,224,200 = 1.76
2 Click competitor name to see calculations.
| Long-term activity ratio | Description | The company |
|---|---|---|
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders’ equity. | Ecolab Inc. equity turnover ratio deteriorated from Q2 2021 to Q3 2021 and from Q3 2021 to Q4 2021. |