Colgate Palmolive Financial Statements Trends

CL -- USA Stock  

USD 65.95  0.20  0.30%

This module enables investors to look at Colgate Palmolive 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.8 B, Cost of Revenue of 7.8 B or Earning Before Interest and Taxes EBIT of 3.1 B, but also many exotic indicators such as Interest Coverage of 117, Long Term Debt to Equity of 5.7991 or Calculated Tax Rate of 51.8843. This module is a perfect complement to use when analyzing Colgate Palmolive Valuation or Volatility. It can also complement various Colgate Palmolive Technical models. Check also analysis of Colgate Palmolive Correlation with competitors.

Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Total Assets7.1 B11.9 B11.3 B
Increasing
Stable
Cash and Equivalents906 M970 M787.2 M
Increasing
Slightly volatile
Inventory1.4 B1.2 B1.2 B
Increasing
Slightly volatile
Tax Assets78.8 M67 M91.7 M
Decreasing
Slightly volatile
Trade and Non Trade Receivables1.7 B1.4 B1.5 B
Increasing
Stable
Trade and Non Trade Payables1.3 B1.1 B1.2 B
Increasing
Slightly volatile
Goodwill and Intangible Assets4.1 B3.4 B3.4 B
Increasing
Slightly volatile
Total Liabilities14.1 B12 B10.4 B
Increasing
Slightly volatile
Shareholders Equity(351.8 M)(299 M)1.4 B
Decreasing
Slightly volatile
Accumulated Retained Earnings Deficit22.2 B18.9 B16.1 B
Increasing
Slightly volatile
Accumulated Other Comprehensive Income(4.6 B)(4 B)(3 B)
Decreasing
Slightly volatile
Current Assets2.2 B4.4 B4 B
Increasing
Stable
Assets Non Current8.9 B7.6 B7.7 B
Increasing
Slightly volatile
Current Liabilities2.1 B3.5 B3.4 B
Increasing
Very volatile
Liabilities Non Current9.9 B8.4 B6.8 B
Increasing
Slightly volatile
Tax Liabilities600 M510 M536.5 M
Increasing
Stable
Total Debt6.7 B6.5 B5.2 B
Increasing
Slightly volatile
Debt Current355.3 M302 M412.7 M
Decreasing
Very volatile
Debt Non Current7.3 B6.2 B4.8 B
Increasing
Slightly volatile
Shareholders Equity USD(351.8 M)(299 M)1.4 B
Decreasing
Slightly volatile
Cash and Equivalents USD1.1 B970 M806.8 M
Increasing
Slightly volatile
Total Debt USD7.7 B6.5 B5.2 B
Increasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Revenues15.7 B16 B15.6 B
Increasing
Slightly volatile
Cost of Revenue7.8 B6.6 B6.7 B
Increasing
Slightly volatile
Operating Expenses7.8 B6.6 B6 B
Increasing
Slightly volatile
Interest Expense30.6 M26 M49.1 M
Decreasing
Slightly volatile
Income Tax Expense1.4 B1.2 B1.1 B
Increasing
Slightly volatile
Consolidated Income1.8 B1.5 B2 B
Decreasing
Stable
Net Income to Non Controlling Interests192.9 M164 M143.6 M
Increasing
Slightly volatile
Net Income2.1 B1.4 B1.9 B
Decreasing
Stable
Net Income Common Stock1.6 B1.4 B1.9 B
Decreasing
Stable
Weighted Average Shares872.3 M896.9 M948.8 M
Decreasing
Slightly volatile
Weighted Average Shares Diluted1.1 B909.7 M986.3 M
Decreasing
Slightly volatile
Earning Before Interest and Taxes EBIT3.1 B2.6 B3.1 B
Decreasing
Very volatile
Revenues USD18.9 B16 B15.9 B
Increasing
Slightly volatile
Net Income Common Stock USD1.6 B1.4 B1.9 B
Decreasing
Stable
Earning Before Interest and Taxes USD3.1 B2.6 B3.1 B
Decreasing
Very volatile
Gross Profit9.4 B9.4 B9.1 B
Increasing
Slightly volatile
Operating Income3.3 B2.8 B3.2 B
Increasing
Very volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(812.9 M)(691 M)(630.3 M)
Decreasing
Slightly volatile
Net Cash Flow Business Acquisitions and Disposals255.3 M217 M27.1 M
Increasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals(168.2 M)(143 M)(137.5 M)
Decreasing
Stable
Net Cash Flow from Financing(2.7 B)(2.3 B)(2.1 B)
Decreasing
Slightly volatile
Issuance Repayment of Debt Securities 495.3 M421 M393.9 M
Increasing
Stable
Issuance Purchase of Equity Shares(1.4 B)(1.2 B)(1.2 B)
Decreasing
Stable
Payment of Dividends and Other Cash Distributions (1.8 B)(1.5 B)(1.2 B)
Decreasing
Slightly volatile
Net Cash Flow from Investing(805.9 M)(685 M)(760.3 M)
Decreasing
Stable
Net Cash Flow from Operations2.2 B2.9 B2.8 B
Increasing
Stable
Effect of Exchange Rate Changes on Cash (125.9 M)(107 M)(79.7 M)
Decreasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents(140 M)(119 M)10.8 M
Decreasing
Slightly volatile
Share Based Compensation147.1 M125 M123.2 M
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Earnings per Basic Share1.81.531.9742
Decreasing
Very volatile
Earnings per Diluted Share2.361.521.9842
Increasing
Very volatile
Earnings per Basic Share USD1.81.531.9742
Decreasing
Very volatile
Dividends per Basic Common Share1.76471.51.1971
Increasing
Slightly volatile
Return on Average Equity3.64473.0981.7304
Increasing
Slightly volatile
Return on Average Assets0.19380.1060.1644
Decreasing
Slightly volatile
Return on Invested Capital0.28120.2390.3478
Decreasing
Slightly volatile
Gross Margin0.68940.5860.5874
Increasing
Slightly volatile
Profit Margin0.1330.0860.1234
Decreasing
Slightly volatile
EBITDA Margin0.22590.1920.2238
Decreasing
Slightly volatile
Return on Sales0.19290.1640.1967
Decreasing
Slightly volatile
Asset Turnover1.44241.2261.3186
Decreasing
Slightly volatile
Payout Ratio1.15290.980.6455
Increasing
Slightly volatile
Enterprise Value over EBITDA24.914121.17716.4394
Increasing
Slightly volatile
Enterprise Value over EBIT28.235324.018.3529
Increasing
Slightly volatile
Price to Earnings Ratio27.8743.54227.9939
Increasing
Slightly volatile
Sales per Share21.031817.87716.8976
Increasing
Slightly volatile
Price to Sales Ratio3.653.7273.2024
Increasing
Slightly volatile
Price to Book Value233(200)(14.035)
Decreasing
Stable
Debt to Equity Ratio(47.1341)(40.064)(10.5948)
Decreasing
Slightly volatile
Dividend Yield0.02710.0230.0221
Increasing
Slightly volatile
Current Ratio1.081.2411.1559
Increasing
Slightly volatile
Free Cash Flow per Share1.042.5172.2892
Increasing
Very volatile
Book Value per Share(0.3918)(0.333)1.3954
Decreasing
Slightly volatile
Tangible Assets Book Value per Share11.13069.4618.9862
Increasing
Slightly volatile
Total Assets Per Share15.758513.394712.9896
Increasing
Slightly volatile
Cash Flow Per Share3.88633.30333.1921
Increasing
Slightly volatile
Return on Investment44.994738.245548.2195
Decreasing
Slightly volatile
Operating Margin28.4316.178120.6222
Decreasing
Very volatile
Calculated Tax Rate51.884344.101636.8412
Increasing
Slightly volatile
Receivables Turnover12.664310.764710.3183
Increasing
Slightly volatile
Inventory Turnover6.09365.17955.3771
Decreasing
Very volatile
PPandE Turnover4.79014.07164.4558
Decreasing
Slightly volatile
Cash and Equivalents Turnover18.32315.574621.7329
Decreasing
Slightly volatile
Accounts Payable Turnover16.115813.698413.8094
Increasing
Slightly volatile
Accrued Expenses Turnover8.72717.4188.0568
Decreasing
Slightly volatile
Interest Coverage11799.769299.6339
Increasing
Slightly volatile
Long Term Debt to Equity5.79914.92933.077
Increasing
Slightly volatile
Quick Ratio0.79540.67610.6669
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets8.36267.10825.3795
Increasing
Slightly volatile
Revenue to Assets1.57751.34091.3666
Decreasing
Very volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Earnings before Tax3.1 B2.6 B3 B
Increasing
Very volatile
Market Capitalization57.4 B59.8 B50 B
Increasing
Slightly volatile
Enterprise Value62.7 B65.1 B54.2 B
Increasing
Slightly volatile
Invested Capital12.4 B10.6 B9.3 B
Increasing
Slightly volatile
Average Equity525.6 M446.8 M1.7 B
Decreasing
Slightly volatile
Average Assets15.4 B13.1 B12.3 B
Increasing
Slightly volatile
Invested Capital Average12.9 B11 B9.3 B
Increasing
Slightly volatile
Tangible Asset Value10 B8.5 B8.4 B
Increasing
Slightly volatile
Free Cash Flow2.7 B2.3 B2.3 B
Increasing
Slightly volatile
Working Capital79.4 M850 M537.9 M
Increasing
Slightly volatile
Revenue Per Employee497.7 K423.1 K431.4 K
Increasing
Slightly volatile
Net Income Per Employee43 K36.5 K51.4 K
Decreasing
Slightly volatile

Thematic Opportunities

Explore Investment Opportunities
Build portfolios using Macroaxis predefined set of investing ideas. Many of Macroaxis investing ideas can easily outperform a given market. Ideas can also be optimized per your risk profile before portfolio origination is invoked.
Explore Thematic Ideas
Explore Investing Ideas  

Colgate Palmolive Upcoming Company Events

Upcoming Quarterly ReportApril 27, 2017
Next Earnings ReportJuly 27, 2017
Check also analysis of Colgate Palmolive Correlation with competitors. Please also try Analyst Recommendations module to analyst recommendations and target price estimates broken down by several categories.
vendors/bower_components/jquery.easy-pie-chart/dist/jquery.easypiechart.min.js">