Colgate Palmolive Financial Statements Trends

Colgate Palmolive Company -- USA Stock  

USD 73.24  0.81  1.09%

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 2 B, Cost of Revenue of 7.3 B or Earning Before Interest and Taxes EBIT of 3.2 B, but also many exotic indicators such as Interest Coverage of 130, Long Term Debt to Equity of 5.7991 or Calculated Tax Rate of 41.0339. 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
Accumulated Other Comprehensive Income(3.9 B)(4 B)(2.7 B)
Decreasing
Slightly volatile
Total Assets7.1 B11.9 B11.2 B
Increasing
Stable
Current Assets2.2 B4.4 B3.9 B
Increasing
Stable
Assets Non Current8.5 B7.6 B7.6 B
Increasing
Slightly volatile
Cash and Equivalents1.6 B970 M800 M
Increasing
Slightly volatile
Cash and Equivalents USD1.1 B970 M756.9 M
Increasing
Slightly volatile
Total Debt6.5 B6.5 B4.9 B
Increasing
Slightly volatile
Debt Current424.2 M302 M417.8 M
Increasing
Stable
Debt Non Current6.3 B6.2 B4.5 B
Increasing
Slightly volatile
Total Debt USD6.7 B6.5 B4.9 B
Increasing
Slightly volatile
Shareholders Equity445.3 M(299 M)1.6 B
Decreasing
Slightly volatile
Shareholders Equity USD445.3 M(299 M)1.6 B
Decreasing
Slightly volatile
Goodwill and Intangible Assets3.8 B3.4 B3.4 B
Increasing
Slightly volatile
Inventory1.3 B1.2 B1.2 B
Increasing
Slightly volatile
Total Liabilities12.7 B12 B10 B
Increasing
Slightly volatile
Current Liabilities2.1 B3.5 B3.4 B
Increasing
Stable
Liabilities Non Current8.7 B8.4 B6.4 B
Increasing
Slightly volatile
Trade and Non Trade Payables1.2 B1.1 B1.1 B
Increasing
Slightly volatile
Property Plant and Equipment Net4.1 B3.8 B3.6 B
Increasing
Slightly volatile
Trade and Non Trade Receivables1.6 B1.4 B1.5 B
Increasing
Very volatile
Accumulated Retained Earnings Deficit19.8 B18.9 B15.2 B
Increasing
Slightly volatile
Tax Assets75.3 M67 M95.4 M
Decreasing
Slightly volatile
Tax Liabilities560.5 M510 M534.6 M
Increasing
Very volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income2 B1.5 B2.1 B
Increasing
Very volatile
Cost of Revenue7.3 B6.6 B6.6 B
Increasing
Slightly volatile
Earning Before Interest and Taxes EBIT3.2 B2.6 B3.1 B
Increasing
Stable
Earning Before Interest and Taxes USD3.2 B2.6 B3.1 B
Increasing
Stable
Gross Profit9.1 B9.4 B8.9 B
Increasing
Slightly volatile
Interest Expense26.3 M26 M59.6 M
Decreasing
Slightly volatile
Net Income2.3 B1.4 B2 B
Increasing
Stable
Net Income Common Stock1.9 B1.4 B1.9 B
Increasing
Very volatile
Net Income Common Stock USD1.9 B1.4 B1.9 B
Increasing
Very volatile
Net Income to Non Controlling Interests170 M164 M136.8 M
Increasing
Slightly volatile
Operating Expenses6.9 B6.6 B5.8 B
Increasing
Slightly volatile
Operating Income3.3 B2.8 B3.2 B
Increasing
Stable
Revenues15.3 B16 B15.4 B
Increasing
Slightly volatile
Revenues USD17.5 B16 B15.6 B
Increasing
Slightly volatile
Selling General and Administrative Expense6 B5.5 B5.4 B
Increasing
Slightly volatile
Weighted Average Shares878.1 M896.9 M959.5 M
Decreasing
Slightly volatile
Weighted Average Shares Diluted965.3 M909.7 M992.4 M
Decreasing
Slightly volatile
Income Tax Expense1.3 B1.2 B1.1 B
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(762.1 M)(691 M)(617.1 M)
Decreasing
Slightly volatile
Depreciation Amortization and Accretion468.9 M449 M403.3 M
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents4.2 M(119 M)27.6 M
Decreasing
Very volatile
Net Cash Flow Business Acquisitions and Disposals81.1 M217 M1.4 M
Increasing
Stable
Issuance Purchase of Equity Shares(1.2 B)(1.2 B)(1.2 B)
Decreasing
Stable
Issuance Repayment of Debt Securities 450.5 M421 M336.4 M
Increasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (1.5 B)(1.5 B)(1.2 B)
Decreasing
Slightly volatile
Net Cash Flow from Financing(2.3 B)(2.3 B)(2 B)
Decreasing
Slightly volatile
Net Cash Flow from Investing(812.6 M)(685 M)(747.8 M)
Decreasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals(105.3 M)(143 M)(121.2 M)
Decreasing
Stable
Net Cash Flow from Operations3.1 B2.9 B2.8 B
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (131.1 M)(107 M)(69.7 M)
Decreasing
Slightly volatile
Share Based Compensation134.7 M125 M120.9 M
Increasing
Slightly volatile
Cash Beginning of Year1.1 B1.1 B752.8 M
Increasing
Slightly volatile
Cash End of Year1.1 B970 M778.2 M
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover1.31.2261.3217
Decreasing
Slightly volatile
Book Value per Share0.4858(0.333)1.6831
Decreasing
Slightly volatile
Current Ratio1.231.2411.1603
Increasing
Slightly volatile
Debt to Equity Ratio(15.5363)(40.064)(4.3377)
Decreasing
Slightly volatile
Dividend Yield0.02320.0230.0213
Increasing
Slightly volatile
Dividends per Basic Common Share1.53681.51.1114
Increasing
Slightly volatile
EBITDA Margin0.21790.1920.2252
Decreasing
Slightly volatile
Earnings per Basic Share2.05791.532.0082
Increasing
Stable
Earnings per Diluted Share2.591.522.01
Increasing
Slightly volatile
EPS Diluted Growth(0.1918)(0.3559)(0.0037)
Decreasing
Slightly volatile
EPS Growth(0.1945)(0.3571)(0.0085)
Decreasing
Slightly volatile
Earnings per Basic Share USD2.05791.532.0082
Increasing
Stable
Enterprise Value over EBIT22.631624.017.2193
Increasing
Slightly volatile
Enterprise Value over EBITDA20.433221.17715.4929
Increasing
Slightly volatile
Free Cash Flow per Share1.822.5172.2808
Increasing
Slightly volatile
Gross Margin0.61630.5860.5793
Increasing
Slightly volatile
Financial Leverage1.04370.99010.9834
Increasing
Slightly volatile
Leverage Ratio19.532329.287611.0735
Increasing
Slightly volatile
NCFO Growth(0.0403)(0.1058)0.046
Decreasing
Slightly volatile
Net Income Growth(0.2065)(0.3651)(0.0243)
Decreasing
Slightly volatile
Profit Margin0.15090.0860.1282
Decreasing
Stable
Payout Ratio0.830.980.5717
Increasing
Slightly volatile
Price to Book Value233(200)4.0672
Decreasing
Very volatile
Price to Earnings Ratio28.5943.54226.3589
Increasing
Slightly volatile
Price to Sales Ratio4.253.7273.182
Increasing
Slightly volatile
Revenue Growth(0.0422)(0.0719)0.0201
Decreasing
Slightly volatile
Return on Average Assets0.19380.1060.1703
Decreasing
Slightly volatile
Return on Average Equity9.89493.0982.0703
Increasing
Slightly volatile
Return on Invested Capital0.29420.2390.3639
Decreasing
Slightly volatile
Return on Sales0.190.1640.1988
Decreasing
Slightly volatile
Weighted Average Share Growth(0.0151)(0.0158)(0.0148)
Decreasing
Stable
Sales per Share19.386317.87716.3979
Increasing
Slightly volatile
Tax Efficiency0.62030.53250.6421
Decreasing
Slightly volatile
Tangible Assets Book Value per Share10.60379.4618.7256
Increasing
Slightly volatile
Total Assets Per Share14.862413.394712.6264
Increasing
Slightly volatile
Cash Flow Per Share3.6533.30333.0778
Increasing
Slightly volatile
Return on Investment44.625138.245549.0868
Decreasing
Slightly volatile
Operating Margin25.7716.178120.6646
Decreasing
Very volatile
Calculated Tax Rate41.033944.101634.7329
Increasing
Slightly volatile
Receivables Turnover11.370210.764710.0308
Increasing
Slightly volatile
Inventory Turnover5.41415.17955.3509
Decreasing
Slightly volatile
PPandE Turnover4.37084.07164.4839
Decreasing
Slightly volatile
Cash and Equivalents Turnover17.064215.574622.8331
Decreasing
Slightly volatile
Accounts Payable Turnover14.275113.698413.6055
Increasing
Slightly volatile
Accrued Expenses Turnover8.02447.4188.0807
Decreasing
Slightly volatile
Interest Coverage13099.769293.8216
Increasing
Slightly volatile
Long Term Debt to Equity5.79914.92932.7837
Increasing
Slightly volatile
Quick Ratio0.70710.67610.6586
Increasing
Stable
Net Current Assets as percentage of Total Assets7.32717.10825.0765
Increasing
Slightly volatile
Revenue to Assets1.38131.34091.3522
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets14.2 B13.1 B11.9 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA4.4 B3.1 B3.6 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD3.6 B3.1 B3.5 B
Increasing
Stable
Earnings before Tax3.1 B2.6 B3 B
Increasing
Stable
Average Equity1.1 B446.8 M1.8 B
Decreasing
Slightly volatile
Enterprise Value69.4 B65.1 B52.9 B
Increasing
Slightly volatile
Free Cash Flow2.5 B2.3 B2.2 B
Increasing
Slightly volatile
Invested Capital11.3 B10.6 B8.9 B
Increasing
Slightly volatile
Invested Capital Average11.4 B11 B8.8 B
Increasing
Slightly volatile
Market Capitalization65 B59.8 B49 B
Increasing
Slightly volatile
Tangible Asset Value9.6 B8.5 B8.3 B
Increasing
Slightly volatile
Working Capital79.4 M850 M505.1 M
Increasing
Stable
Revenue Per Employee463.9 K423.1 K425.2 K
Increasing
Slightly volatile
Net Income Per Employee49.7 K36.5 K52.9 K
Decreasing
Stable