Ecolab Financial Statements Trends

Ecolab Inc -- USA Stock  

USD 139.75  1.4  1.01%

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 8.5 B or Earning Before Interest and Taxes EBIT of 1.8 B, but also many exotic indicators such as Interest Coverage of 7.5403, Long Term Debt to Equity of 0.7253 or Calculated Tax Rate of 26.8293. 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.7 B)(1.4 B)(672.6 M)
Decreasing
Slightly volatile
Total Assets2.9 B18.6 B12 B
Increasing
Slightly volatile
Current Assets1 B4.4 B3.2 B
Increasing
Slightly volatile
Assets Non Current16.7 B14.2 B9.9 B
Increasing
Slightly volatile
Cash and Equivalents209.1 M92.8 M353.8 M
Decreasing
Very volatile
Cash and Equivalents USD109.2 M92.8 M346.1 M
Decreasing
Very volatile
Total Debt7.6 B6.5 B4.6 B
Increasing
Slightly volatile
Debt Current2.6 B2.2 B1.1 B
Increasing
Slightly volatile
Debt Non Current5 B4.3 B3.4 B
Increasing
Slightly volatile
Total Debt USD7.6 B6.5 B4.6 B
Increasing
Slightly volatile
Shareholders Equity8.1 B6.9 B4.9 B
Increasing
Slightly volatile
Shareholders Equity USD8.1 B6.9 B4.9 B
Increasing
Slightly volatile
Goodwill and Intangible Assets12.5 B10.6 B7.3 B
Increasing
Slightly volatile
Inventory1.6 B1.4 B991 M
Increasing
Slightly volatile
Investments147.1 M125.1 M126.8 M
Increasing
Slightly volatile
Investments Current147.1 M125.1 M126.8 M
Increasing
Slightly volatile
Total Liabilities13.7 B11.7 B8.5 B
Increasing
Slightly volatile
Current Liabilities853.8 M4.8 B2.7 B
Increasing
Slightly volatile
Liabilities Non Current8.1 B6.9 B5.4 B
Increasing
Slightly volatile
Trade and Non Trade Payables1.2 B1 B759.7 M
Increasing
Slightly volatile
Property Plant and Equipment Net3.8 B3.2 B2.3 B
Increasing
Slightly volatile
Trade and Non Trade Receivables2.8 B2.4 B1.8 B
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit7.2 B6.2 B4.4 B
Increasing
Slightly volatile
Tax Assets294.1 M250 M166.2 M
Increasing
Slightly volatile
Tax Liabilities1.6 B1.3 B465.3 M
Increasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income1.2 B1 B740.3 M
Increasing
Slightly volatile
Cost of Revenue8.5 B7.2 B5.2 B
Increasing
Slightly volatile
Earning Before Interest and Taxes EBIT1.8 B1.5 B1.2 B
Increasing
Slightly volatile
Earning Before Interest and Taxes USD1.8 B1.5 B1.2 B
Increasing
Slightly volatile
Gross Profit6.2 B6.3 B4.6 B
Increasing
Slightly volatile
Interest Expense286.6 M243.6 M165.3 M
Increasing
Slightly volatile
Net Income1.3 B1 B743.4 M
Increasing
Slightly volatile
Net Income Common Stock1.2 B1 B733.3 M
Increasing
Slightly volatile
Net Income Common Stock USD1.2 B1 B733.3 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 Interests17.8 M15.1 M7.2 M
Increasing
Slightly volatile
Operating Expenses5.6 B4.8 B3.5 B
Increasing
Slightly volatile
Operating Income1.8 B1.6 B1.2 B
Increasing
Slightly volatile
Revenues13.5 B13.5 B9.7 B
Increasing
Slightly volatile
Revenues USD15.9 B13.5 B9.9 B
Increasing
Slightly volatile
Selling General and Administrative Expense5.1 B4.3 B3.3 B
Increasing
Slightly volatile
Weighted Average Shares288.9 M296.4 M271.1 M
Increasing
Slightly volatile
Weighted Average Shares Diluted354.6 M301.4 M280.8 M
Increasing
Slightly volatile
Income Tax Expense353.5 M300.5 M270.1 M
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(941.4 M)(800.2 M)(551.7 M)
Decreasing
Slightly volatile
Depreciation Amortization and Accretion1 B859.5 M604.6 M
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents(137.4 M)(116.8 M)(58.8 M)
Decreasing
Stable
Net Cash Flow Business Acquisitions and Disposals(263.5 M)(224 M)(384.9 M)
Increasing
Very volatile
Issuance Purchase of Equity Shares(888.4 M)(755.1 M)(457.5 M)
Decreasing
Slightly volatile
Issuance Repayment of Debt Securities (144.8 M)(123.1 M)155.2 M
Decreasing
Stable
Payment of Dividends and Other Cash Distributions (471.4 M)(400.7 M)(253.3 M)
Decreasing
Slightly volatile
Net Cash Flow from Financing(1.4 B)(1.2 B)(457.7 M)
Decreasing
Slightly volatile
Net Cash Flow from Investing(1.1 B)(915.8 M)(903.5 M)
Decreasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals127.5 M108.4 M91.9 M
Increasing
Slightly volatile
Net Cash Flow from Operations1.9 B2 B1.3 B
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (58.7 M)(49.9 M)(18.9 M)
Decreasing
Slightly volatile
Share Based Compensation24 M20.4 M22.1 M
Decreasing
Stable
Cash Beginning of Year246.6 M209.6 M438.8 M
Decreasing
Very volatile
Cash End of Year109.2 M92.8 M353.5 M
Decreasing
Very volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover0.83880.7130.9244
Decreasing
Slightly volatile
Book Value per Share27.427123.31317.3999
Increasing
Slightly volatile
Current Ratio1.230.9331.2372
Decreasing
Slightly volatile
Debt to Equity Ratio1041.6889.5446
Increasing
Slightly volatile
Share Dilution Ratio1.19631.01691.0316
Increasing
Slightly volatile
Dividend Yield0.01410.0120.0122
Decreasing
Very volatile
Dividends per Basic Common Share1.57651.340.9043
Increasing
Slightly volatile
EBITDA Margin0.20940.1780.183
Increasing
Very volatile
Earnings per Basic Share3.97653.382.619
Increasing
Slightly volatile
Earnings per Diluted Share4.433.322.61
Increasing
Slightly volatile
EPS Diluted Growth(0.1826)(0.1552)0.0652
Decreasing
Slightly volatile
EPS Growth(0.1848)(0.1571)0.0643
Decreasing
Slightly volatile
Earnings per Basic Share USD3.97653.382.619
Increasing
Slightly volatile
Enterprise Value over EBIT30.588226.020.6606
Increasing
Slightly volatile
Enterprise Value over EBITDA19.735316.77513.9736
Increasing
Slightly volatile
Free Cash Flow per Share0.724.0472.4287
Increasing
Slightly volatile
Gross Margin0.54940.4670.4873
Decreasing
Stable
Financial Leverage0.99110.84250.8821
Decreasing
Stable
Leverage Ratio3.26592.7762.7207
Increasing
Slightly volatile
NCFO Growth0.11940.10150.1628
Decreasing
Very volatile
Net Income Growth(0.1963)(0.1669)0.0805
Decreasing
Slightly volatile
Profit Margin0.09670.0740.0764
Increasing
Stable
Payout Ratio0.46590.3960.3448
Increasing
Slightly volatile
Price to Book Value5.594.8884.8724
Decreasing
Stable
Price to Earnings Ratio31.5333.8428.8018
Increasing
Slightly volatile
Price to Sales Ratio2.982.5032.1908
Increasing
Slightly volatile
Revenue Growth(0.0606)(0.0515)0.0906
Decreasing
Stable
Return on Average Assets0.06640.0530.0702
Decreasing
Slightly volatile
Return on Average Equity0.18580.1460.1839
Decreasing
Slightly volatile
Return on Invested Capital0.16820.1430.1917
Decreasing
Slightly volatile
Return on Sales0.13410.1140.1214
Decreasing
Stable
Weighted Average Share Growth(0.0145)(0.0123)0.0118
Increasing
Very volatile
Sales per Share53.763545.69935.3162
Increasing
Slightly volatile
Tax Efficiency0.90510.76930.7245
Increasing
Slightly volatile
Tangible Assets Book Value per Share31.918827.13122.1309
Increasing
Slightly volatile
Total Assets Per Share74.100862.985747.3746
Increasing
Slightly volatile
Cash Flow Per Share7.94926.75684.8124
Increasing
Slightly volatile
Return on Investment13.47611.454616.5915
Decreasing
Slightly volatile
Operating Margin15.011.526712.1331
Increasing
Stable
Calculated Tax Rate26.829322.804928.064
Decreasing
Slightly volatile
Receivables Turnover6.35275.39985.6611
Decreasing
Stable
Inventory Turnover5.9535.06015.8377
Decreasing
Slightly volatile
PPandE Turnover5.07594.31454.8788
Decreasing
Slightly volatile
Cash and Equivalents Turnover10589.58452.0102
Increasing
Slightly volatile
Accounts Payable Turnover14.408112.246914.3946
Decreasing
Slightly volatile
Accrued Expenses Turnover18.875216.043916.5407
Decreasing
Stable
Interest Coverage7.54036.40939.0442
Decreasing
Slightly volatile
Long Term Debt to Equity0.72530.61650.6188
Increasing
Slightly volatile
Quick Ratio0.61120.51960.766
Decreasing
Slightly volatile
Net Current Assets as percentage of Total Assets(1.9999)(1.7)4.6406
Decreasing
Slightly volatile
Revenue to Assets0.85480.72660.8862
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets22.4 B19 B12.7 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA2.9 B2.4 B1.8 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD2.8 B2.4 B1.8 B
Increasing
Slightly volatile
Earnings before Tax1.5 B1.3 B1 B
Increasing
Slightly volatile
Average Equity8.1 B6.8 B4.6 B
Increasing
Slightly volatile
Enterprise Value47.3 B40.4 B26 B
Increasing
Slightly volatile
Free Cash Flow1.4 B1.2 B769.6 M
Increasing
Slightly volatile
Invested Capital11.4 B9.7 B7.3 B
Increasing
Slightly volatile
Invested Capital Average12.7 B10.8 B7.2 B
Increasing
Slightly volatile
Market Capitalization40.4 B33.8 B22.1 B
Increasing
Slightly volatile
Tangible Asset Value9.5 B8 B6.2 B
Increasing
Slightly volatile
Working Capital162.1 M(316.9 M)510.3 M
Decreasing
Stable
Revenue Per Employee339.1 K288.2 K258.7 K
Increasing
Slightly volatile
Net Income Per Employee25.1 K21.3 K19.2 K
Increasing
Slightly volatile