Ecolab Financial Statements Trends

Ecolab Inc -- USA Stock  

USD 132.8  1.06  0.8%

This module enables investors to look at Ecolab various fundamental indicators over time in order to gain insight into the company future performance. Macroaxis historical fundamental analysis tools allow evaluation of not only typical financial statement drivers such as Consolidated Income of 1.2 B, Cost of Revenue of 7.8 B or Earning Before Interest and Taxes EBIT of 1.8 B, but also many exotic indicators such as Interest Coverage of 7.3832, Long Term Debt to Equity of 0.6744 or Calculated Tax Rate of 26.7595. This module is a perfect complement to use when analyzing Ecolab Valuation or Volatility. It can also complement various Ecolab Technical models. Additionally see analysis of Ecolab Correlation with competitors.

Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Accumulated Other Comprehensive Income(1.3 B)(1.4 B)(574.7 M)
Decreasing
Slightly volatile
Total Assets2.9 B18.6 B11.4 B
Increasing
Slightly volatile
Current Assets1 B4.4 B3.1 B
Increasing
Slightly volatile
Assets Non Current15.1 B14.2 B9.4 B
Increasing
Slightly volatile
Cash and Equivalents260.7 M92.8 M379.9 M
Increasing
Very volatile
Cash and Equivalents USD159.2 M92.8 M371.4 M
Increasing
Very volatile
Total Debt7.7 B6.5 B4.4 B
Increasing
Slightly volatile
Debt Current2.1 B2.2 B1 B
Increasing
Slightly volatile
Debt Non Current4.8 B4.3 B3.3 B
Increasing
Slightly volatile
Total Debt USD6.8 B6.5 B4.3 B
Increasing
Slightly volatile
Shareholders Equity7.5 B6.9 B4.7 B
Increasing
Slightly volatile
Shareholders Equity USD7.5 B6.9 B4.7 B
Increasing
Slightly volatile
Goodwill and Intangible Assets11.5 B10.6 B6.9 B
Increasing
Slightly volatile
Inventory1.5 B1.4 B947 M
Increasing
Slightly volatile
Investments147.1 M125.1 M126.9 M
Increasing
Slightly volatile
Investments Current147.1 M125.1 M126.9 M
Increasing
Slightly volatile
Total Liabilities12.5 B11.7 B8.1 B
Increasing
Slightly volatile
Current Liabilities853.8 M4.8 B2.6 B
Increasing
Slightly volatile
Liabilities Non Current7.7 B6.9 B5.2 B
Increasing
Slightly volatile
Trade and Non Trade Payables1.2 B1 B729.7 M
Increasing
Slightly volatile
Property Plant and Equipment Net3.3 B3.2 B2.1 B
Increasing
Slightly volatile
Trade and Non Trade Receivables2.6 B2.4 B1.8 B
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit6.2 B6.2 B4.1 B
Increasing
Slightly volatile
Tax Assets228 M250 M153.7 M
Increasing
Slightly volatile
Tax Liabilities748.4 M1.3 B324.6 M
Increasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income1.2 B1 B715.7 M
Increasing
Slightly volatile
Cost of Revenue7.8 B7.2 B5 B
Increasing
Slightly volatile
Earning Before Interest and Taxes EBIT1.8 B1.5 B1.1 B
Increasing
Slightly volatile
Earning Before Interest and Taxes USD1.8 B1.5 B1.1 B
Increasing
Slightly volatile
Gross Profit6.2 B6.3 B4.4 B
Increasing
Slightly volatile
Interest Expense263.3 M243.6 M156.8 M
Increasing
Slightly volatile
Net Income1.3 B1 B720.2 M
Increasing
Slightly volatile
Net Income Common Stock1.2 B1 B709.4 M
Increasing
Slightly volatile
Net Income Common Stock USD1.2 B1 B709.4 M
Increasing
Slightly volatile
Net Income from Discontinued Operations(2.2 M)(1.9 M)(1.9 M)
Decreasing
Slightly volatile
Net Income to Non Controlling Interests18.2 M15.1 M6.5 M
Increasing
Slightly volatile
Operating Expenses5 B4.8 B3.3 B
Increasing
Slightly volatile
Operating Income1.9 B1.6 B1.1 B
Increasing
Slightly volatile
Revenues13.4 B13.5 B9.4 B
Increasing
Slightly volatile
Revenues USD14.6 B13.5 B9.5 B
Increasing
Slightly volatile
Selling General and Administrative Expense4.7 B4.3 B3.2 B
Increasing
Slightly volatile
Weighted Average Shares289.4 M296.4 M269.1 M
Increasing
Slightly volatile
Weighted Average Shares Diluted319.6 M301.4 M276.1 M
Increasing
Slightly volatile
Income Tax Expense408.8 M300.5 M272.1 M
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(833.3 M)(800.2 M)(521.9 M)
Decreasing
Slightly volatile
Depreciation Amortization and Accretion911.3 M859.5 M575 M
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents(129.7 M)(116.8 M)(53.3 M)
Decreasing
Very volatile
Net Cash Flow Business Acquisitions and Disposals(156.3 M)(224 M)(389.4 M)
Increasing
Very volatile
Issuance Purchase of Equity Shares(623 M)(755.1 M)(410.6 M)
Decreasing
Slightly volatile
Issuance Repayment of Debt Securities (227 M)(123.1 M)171.6 M
Decreasing
Stable
Payment of Dividends and Other Cash Distributions (392.2 M)(400.7 M)(234.4 M)
Decreasing
Slightly volatile
Net Cash Flow from Financing(1.2 B)(1.2 B)(384.6 M)
Decreasing
Slightly volatile
Net Cash Flow from Investing(928.5 M)(915.8 M)(890 M)
Decreasing
Stable
Net Cash Flow Investment Acquisitions and Disposals127.5 M108.4 M90.5 M
Increasing
Slightly volatile
Net Cash Flow from Operations1.9 B2 B1.2 B
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (39.9 M)(49.9 M)(14.7 M)
Decreasing
Slightly volatile
Share Based Compensation18.7 M20.4 M21.8 M
Decreasing
Stable
Cash Beginning of Year288.8 M209.6 M461.4 M
Increasing
Very volatile
Cash End of Year159.2 M92.8 M379.4 M
Increasing
Very volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover0.75950.7130.9354
Decreasing
Slightly volatile
Book Value per Share25.100523.31316.7133
Increasing
Slightly volatile
Current Ratio1.050.9331.2475
Decreasing
Stable
Debt to Equity Ratio1101.68810.7243
Increasing
Slightly volatile
Share Dilution Ratio1.07171.01691.0225
Increasing
Slightly volatile
Dividend Yield0.01210.0120.012
Decreasing
Stable
Dividends per Basic Common Share1.31581.340.8463
Increasing
Slightly volatile
EBITDA Margin0.19740.1780.1824
Decreasing
Very volatile
Earnings per Basic Share3.88953.382.5483
Increasing
Slightly volatile
Earnings per Diluted Share4.373.322.5458
Increasing
Slightly volatile
EPS Diluted Growth0.0466(0.1552)0.1027
Decreasing
Slightly volatile
EPS Growth0.0444(0.1571)0.1018
Decreasing
Slightly volatile
Earnings per Basic Share USD3.88953.382.5483
Increasing
Slightly volatile
Enterprise Value over EBIT23.684226.019.6404
Increasing
Slightly volatile
Enterprise Value over EBITDA15.946316.77513.4244
Increasing
Slightly volatile
Free Cash Flow per Share0.94.0472.3088
Increasing
Slightly volatile
Gross Margin0.48890.4670.484
Decreasing
Slightly volatile
Financial Leverage0.89990.84250.8778
Decreasing
Slightly volatile
Leverage Ratio2.85252.7762.6817
Increasing
Slightly volatile
NCFO Growth0.13970.10150.1696
Increasing
Very volatile
Net Income Growth0.04(0.1669)0.1208
Decreasing
Stable
Profit Margin0.09660.0740.0765
Increasing
Stable
Payout Ratio0.36050.3960.3318
Increasing
Slightly volatile
Price to Book Value5.554.8884.8677
Decreasing
Slightly volatile
Price to Earnings Ratio30.3633.8428.2844
Increasing
Slightly volatile
Price to Sales Ratio2.882.5032.1564
Increasing
Slightly volatile
Revenue Growth0.0137(0.0515)0.1086
Decreasing
Stable
Return on Average Assets0.0670.0530.0717
Decreasing
Slightly volatile
Return on Average Equity0.19130.1460.1875
Decreasing
Slightly volatile
Return on Invested Capital0.17050.1430.196
Decreasing
Slightly volatile
Return on Sales0.13160.1140.1218
Decreasing
Stable
Weighted Average Share Growth(0.0061)(0.0123)0.0145
Increasing
Very volatile
Sales per Share49.097445.69934.0621
Increasing
Slightly volatile
Tax Efficiency0.78190.76930.7105
Increasing
Slightly volatile
Tangible Assets Book Value per Share28.754727.13121.4506
Increasing
Slightly volatile
Total Assets Per Share67.319362.985745.5086
Increasing
Slightly volatile
Cash Flow Per Share6.74316.75684.5498
Increasing
Slightly volatile
Return on Investment13.343311.454617.0085
Decreasing
Slightly volatile
Operating Margin15.1411.526712.1953
Increasing
Slightly volatile
Calculated Tax Rate26.759522.804928.4965
Decreasing
Slightly volatile
Receivables Turnover5.73575.39985.6315
Decreasing
Slightly volatile
Inventory Turnover5.56175.06015.8699
Decreasing
Slightly volatile
PPandE Turnover4.80464.31454.9033
Decreasing
Slightly volatile
Cash and Equivalents Turnover74.540389.58446.308
Increasing
Slightly volatile
Accounts Payable Turnover13.327612.246914.4836
Decreasing
Slightly volatile
Accrued Expenses Turnover17.161516.043916.4393
Decreasing
Stable
Interest Coverage7.38326.40939.2507
Decreasing
Slightly volatile
Long Term Debt to Equity0.67440.61650.6148
Increasing
Slightly volatile
Quick Ratio0.61280.51960.7867
Decreasing
Slightly volatile
Net Current Assets as percentage of Total Assets0.4152(1.7)5.3702
Decreasing
Slightly volatile
Revenue to Assets0.76850.72660.8924
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets20.3 B19 B12 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA2.9 B2.4 B1.7 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD2.7 B2.4 B1.7 B
Increasing
Slightly volatile
Earnings before Tax1.6 B1.3 B981.5 M
Increasing
Slightly volatile
Average Equity7.5 B6.8 B4.4 B
Increasing
Slightly volatile
Enterprise Value45.9 B40.4 B24.7 B
Increasing
Slightly volatile
Free Cash Flow1.2 B1.2 B714.1 M
Increasing
Slightly volatile
Invested Capital10.5 B9.7 B7 B
Increasing
Slightly volatile
Invested Capital Average11.3 B10.8 B6.8 B
Increasing
Slightly volatile
Market Capitalization38.4 B33.8 B21 B
Increasing
Slightly volatile
Tangible Asset Value8.6 B8 B5.9 B
Increasing
Slightly volatile
Working Capital162.1 M(316.9 M)579.3 M
Decreasing
Very volatile
Revenue Per Employee310.1 K288.2 K253.8 K
Increasing
Slightly volatile
Net Income Per Employee24.6 K21.3 K19 K
Increasing
Slightly volatile