Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Ecolab Inc. logo

Ecolab Inc.

Sector: Basic Materials   

Industry: Specialty Chemicals

219.25
 
USD
  
-1.13
  
(-0.51%)
Optionable: Yes  Market Cap: 62,921 M  90-day average vol: 1,265,062

Previous close: 220.38  Open: 221.2  Bid: 191.0  Ask: 225.51
52 week range    
156.72   
   231.86
Peers   
ROL / 
IFF / 
PG / 
CLX / 
CHD / 
PPG / 
MOS / 
DD / 
NEU / 
Last updated: Thursday 18th April 2024
47
MarketXLS Rank
55
Value
23
Technical
63
Quality

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock

🎉 Exciting news! 🎉

You are invited to join our Discord Channel.

Interact, learn, and grow with experts in the markets!

Join our Discord

Financials

ECL Balance Sheet

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
"""debtc"""1,705 M2,205 M541 M564 M744 M503 M143 M526 M505 M630 M
Accounts payable1,162 M1,050 M983 M1,177 M1,256 M1,075 M1,161 M1,384 M1,728 M1,566 M
Accounts receivable2,627 M2,390 M2,341 M2,571 M2,663 M2,382 M2,274 M2,478 M2,698 M2,834 M
Accrued expenses1,492 M1,340 M1,320 M1,660 M1,650 M1,492 M1,597 M1,837 M1,926 M1,725 M
Accumulated depreciation & depletion-2,491 M-2,727 M-3,078 M-3,429 M-3,603 M-3,439 M-3,656 M-3,891 M-3,962 M-4,180 M
Additional paid in capital4,875 M5,086 M5,271 M5,436 M5,633 M5,907 M6,235 M6,465 M6,580 M6,767 M
Building & improvements760 M996 M1,121 M1,207 M1,279 M966 M1,060 M1,134 M1,127 M1,171 M
Cash and equivalents210 M93 M327 M211 M115 M119 M1,260 M360 M599 M920 M
CashCashEquivalentsAndShortTermInvestments210 M93 M327 M211 M115 M119 M1,260 M360 M599 M920 M
CommercialPaper888 M605 M165 M55 M400 M
Common par348 M350 M353 M355 M357 M360 M363 M364 M365 M366 M
Common stock equity7,316 M6,910 M6,901 M7,584 M8,003 M8,685 M6,167 M7,224 M7,236 M8,045 M
CommonStock348 M350 M353 M355 M357 M360 M363 M364 M365 M366 M
Construction in progress278 M371 M344 M439 M400 M348 M220 M325 M404 M470 M
Cost in excess6,717 M6,491 M6,383 M7,167 M7,078 M5,569 M6,007 M8,064 M8,013 M8,148 M
CurrentAccruedExpenses19 M24 M37 M51 M45 M41 M52 M48 M
CurrentCapitalLeaseObligation122 M126 M115 M108 M126 M
CurrentDeferredAssets183 M250 M
CurrentDeferredRevenue79 M76 M77 M80 M92 M
CurrentDeferredTaxesAssets183 M250 M720 M832 M
CurrentDeferredTaxesLiabilities-1,117 M-1,131 M
Deferred revenues79 M76 M77 M80 M92 M
DefinedPensionBenefit16 M28 M27 M42 M39 M31 M33 M115 M118 M118 M
DividendsPayable99 M104 M108 M119 M132 M136 M137 M146 M-607 M-629 M
EmployeeBenefits1,189 M1,117 M1,019 M1,026 M944 M1,084 M1,226 M894 M670 M652 M
FinancialAssets43 M22 M12 M25 M29 M
Finished goods1,044 M887 M860 M975 M1,017 M669 M790 M1,011 M1,123 M911 M
Float term debt4,843 M4,260 M6,146 M6,758 M6,302 M5,973 M6,669 M8,347 M8,075 M7,551 M
GoodwillAndOtherIntangibleAssets11,174 M10,600 M10,201 M11,185 M10,876 M8,497 M8,984 M12,288 M11,693 M11,642 M
Gross fixed assets (Plant Property & Equipment)5,541 M5,956 M6,443 M7,136 M7,440 M7,134 M7,205 M7,577 M7,704 M8,208 M
IncomeTaxPayable89 M52 M87 M184 M101 M137 M96 M104 M198 M159 M
Intangibles4,457 M4,109 M3,818 M4,018 M3,798 M2,928 M2,977 M4,224 M3,681 M3,494 M
InterestPayable19 M24 M37 M51 M45 M41 M52 M48 M252 M349 M
Inventories1,467 M1,388 M1,319 M1,447 M1,546 M1,082 M1,285 M1,492 M1,793 M1,497 M
InventoriesAdjustmentsAllowances-24 M61 M51 M33 M4 M-25 M-16 M-115 M
Invested capital17,003 M15,430 M19,193 M21,100 M20,606 M20,632 M19,505 M23,919 M23,387 M23,148 M
Land & improvements200 M224 M211 M224 M215 M159 M160 M159 M161 M156 M
Leases85 M81 M
LongTermCapitalLeaseObligation346 M301 M283 M503 M632 M
LongTermDebtAndCapitalLeaseObligation4,843 M4,260 M6,146 M6,758 M6,302 M6,319 M6,970 M8,630 M8,075 M7,551 M
LongTermProvisions338 M426 M
Machinery furniture & equipment4,220 M4,365 M2,567 M2,867 M2,980 M2,452 M2,651 M2,853 M1,966 M2,114 M
Minority interest66 M71 M70 M70 M50 M41 M35 M29 M23 M28 M
Net fixed assets (net PP&E)3,051 M3,228 M3,365 M3,707 M3,836 M3,695 M3,549 M3,685 M3,742 M4,028 M
NetOtherUnrealizedGainLoss-467 M-535 M
NetUnrealizedGainLossForeignCurrency-1,263 M-1,312 M
Non-current deferred income taxes1,416 M1,281 M970 M635 M765 M537 M484 M622 M506 M418 M
NonCurrentDeferredAssets72 M58 M92 M105 M105 M136 M163 M121 M
NonCurrentDeferredLiabilities1,416 M1,281 M970 M635 M765 M537 M484 M622 M506 M418 M
NonCurrentDeferredTaxesAssets72 M58 M92 M105 M105 M136 M163 M121 M130 M181 M
NonCurrentPensionAndOtherPostretirementBenefitPlans1,189 M1,117 M1,019 M1,026 M944 M1,084 M1,226 M894 M670 M652 M
Notes payable62 M31 M30 M15 M177 M25 M16 M9 M
Number of employees47000.047000.047000.047000.047000.047000.047000.047000.047000.047000.0
Other current assets72 M35 M42 M54 M35 M33 M27 M23 M405 M393 M
Other equity adjustments-952 M-1,423 M-1,713 M-1,643 M-1,762 M-2,090 M-1,994 M-1,635 M
Other fixed assets2,199 M2,399 M2,566 M3,210 M3,115 M3,105 M3,742 M4,028 M
Other non-current assets263 M237 M344 M330 M529 M3,656 M280 M281 M535 M533 M
Other non-current liabilities143 M238 M205 M415 M325 M270 M312 M254 M406 M382 M
Other receivable14,188 M15,320 M
OtherCurrentBorrowings755 M1,569 M511 M550 M401 M301 M2 M3 M505 M630 M
OtherCurrentLiabilities611 M710 M642 M623 M637 M994 M642 M589 M1,780 M1,990 M
OtherEquityInterest553 M487 M511 M556 M-519 M-824 M-935 M-633 M
OtherInventories1,793 M1,497 M
Payables1,473 M1,316 M1,282 M1,609 M1,606 M1,451 M1,546 M1,789 M1,926 M1,725 M
Prepaid expenses105 M95 M98 M154 M132 M102 M99 M121 M124 M144 M
Raw materials447 M441 M408 M439 M526 M438 M511 M596 M849 M705 M
RecievablesAdjustmentsAllowances-77 M-75 M-68 M-71 M-61 M-55 M-68 M-53 M-72 M-77 M
Retained earnings5,555 M6,160 M6,975 M8,012 M8,910 M9,994 M8,243 M8,815 M7,592 M8,225 M
Short term debt1,705 M2,205 M541 M564 M744 M381 M17 M411 M505 M630 M
TaxesReceivable133 M138 M105 M129 M144 M107 M169 M151 M184 M187 M
Total assets19,427 M18,642 M18,330 M19,964 M20,075 M20,869 M18,126 M21,206 M21,464 M21,847 M
Total current assets4,853 M4,448 M4,279 M4,594 M4,678 M4,828 M5,117 M4,687 M5,494 M5,644 M
Total current liabilities4,368 M4,764 M3,019 M3,475 M3,686 M3,631 M2,932 M3,553 M4,210 M4,346 M
Total equity7,316 M6,910 M6,901 M7,584 M8,003 M8,685 M6,167 M7,224 M7,236 M8,045 M
Total liabilities12,045 M11,661 M11,359 M12,310 M12,021 M12,143 M11,925 M13,953 M14,206 M13,774 M
Total non-current assets14,574 M14,194 M14,051 M15,369 M15,397 M16,041 M13,009 M16,519 M15,970 M16,203 M
Total non-current liabilities7,677 M6,897 M8,340 M8,835 M8,335 M8,513 M8,992 M10,400 M9,995 M9,429 M
TotalEquityGrossMinority7,259 M8,072 M
TotalEquityGrossMinorityInterest7,259 M8,072 M
TotalLiabilitiesAndTotalEquityGrossMinorityInterest19,611 M18,892 M18,330 M19,964 M20,075 M20,869 M18,126 M21,206 M21,464 M21,847 M
TotalNonCurrentLiabilitiesNetMinorityInteres7,677 M6,897 M8,340 M8,835 M8,335 M8,513 M8,992 M10,400 M9,995 M9,429 M
TotalTaxPayable211 M163 M191 M314 M218 M240 M248 M259 M198 M159 M
Treasury stock-2,509 M-3,263 M-3,984 M-4,575 M-5,135 M-5,485 M-6,680 M-6,784 M-7,301 M-7,313 M
Working capital119 M-817 M1,260 M1,119 M992 M1,198 M2,185 M1,134 M1,284 M1,298 M
Call: 1-877-778-8358
Ankur Mohan MarketXLS
Welcome! I'm Ankur, the founder and CEO of MarketXLS. With more than ten years of experience, I have assisted over 2,500 customers in developing personalized investment research strategies and monitoring systems using Excel.

I invite you to book a demo with me or my team to save time, enhance your investment research, and streamline your workflows.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and templates.

MarketXLS is a complete Excel stock solution

Kevin Hsu

StockKevin.com

I have used lots of stock and option information services. This is the only one which gives me what I need inside Excel

Lloyd Lenase

Option Day Trader

MarketXLS is a data junkie’s dream. It gives me the flexibility to mine for hidden treasures.

Dave

Swing trader since 2011

I like to access historical closing prices on a particular date. That makes tracking performance easy.

Patrick Cusatis, Ph.D., CFA

Associate Professor of Finance - Penn State University