Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

CL Stock Forecast, Price Targets, Chart, Dividends & Analysis

Colgate-Palmolive Company logo

Colgate-Palmolive Company

Sector: Consumer Defensive   

Industry: Household & Personal Products

99.04
 
USD
  
-0.93
  
(-0.93%)
Previous close: 99.97  Open: 99.25  Bid: 99.0  Ask: 100.01
52 week range    
68.45   
   109.30
Mkt Cap: 83,613 M  Avg Vol (90 Days): 4,094,915
Peers   
CLX / 
CHD / 
PG / 
UL / 
Last updated: Monday 7th October 2024

Stock Rankings

59
MarketXLS Rank
75
Value
38
Technical
65
Quality
How are these ranks calculated?
Ad slot not ready
Search for a stock

Metrics

Peers

StockDividendMarket Cap (B)PEPrice ($)

CHD

0.011226 B31.36101.04

CLX

0.030220 B72.07161.57

KMB

0.034648 B20.95140.89

PG

0.0238407 B27.94168.88

UL

Financials

CL Income Statement

Annual
Dec-14Dec-15Dec-16Dec-17Dec-18Dec-19Dec-20Dec-21Dec-22Dec-23
AcquisitionExpense6,072 M6,313 M20 M8,131 M
Amortization of intangibles2,307 M2,103 M2,107 M2,218 M2,530 M3,508 M3,824 M3,284 M3,352 M3,410 M
Basic EPS from continuing operations2.381.532.742.32.762.763.152.562.132.78
Basic EPS total2.381.532.742.32.762.763.152.562.132.78
Basic weighted shares outstanding915 M902 M892 M882 M871 M859 M857 M845 M836 M827 M
Cost of sales1,326 M1,235 M1,140 M6,174 M6,313 M6,368 M6,454 M7,046 M7,719 M8,131 M
Depletion102 M
Depreciation442 M449 M443 M475 M511 M519 M539 M556 M545 M567 M
Depreciation unreconciled26 M102 M7,046 M
DepreciationAndAmortization442 M449 M443 M475 M511 M519 M539 M7,046 M545 M567 M
Diluted EPS total2.361.522.722.282.752.753.142.552.132.77
Diluted normalized net income/share2.361.522.722.282.752.753.142.552.132.77
Diluted weighted shares outstanding924 M910 M898 M888 M873 M861 M859 M848 M839 M829 M
Dividends paid per share1.661.711.751.791.861.92
Earnings from equity interest8 M10 M11 M10 M9 M12 M12 M12 M17 M
EarningsFromEquityInterestNetOfTax8 M10 M11 M10 M9 M12 M12 M12 M17 M
GainOnSaleOfBusiness187 M
GainOnSaleOfPPE97 M47 M
GainOnSaleOfSecurity-18 M
GeneralAndAdministrativeExpense5,982 M5,464 M5,249 M5,400 M5,389 M5,575 M12,473 M6,407 M6,565 M7,151 M
Gross operating profit10,109 M9,399 M9,123 M9,280 M9,231 M9,325 M10,017 M10,375 M10,248 M11,326 M
ImpairmentOfCapitalAssets571 M721 M
Income before tax3,533 M2,763 M3,738 M3,487 M3,464 M3,301 M3,647 M3,087 M2,660 M3,392 M
Income restructuring and M&A170 M105 M152 M88 M57 M-13 M24 M
Income taxes1,194 M1,215 M1,152 M1,313 M906 M7,142 M787 M749 M693 M937 M
InsuranceAndClaims99 M6,454 M
Interest income106 M107 M50 M51 M50 M47 M19 M17 M14 M55 M
InterestExpenseNonOperating134 M139 M155 M156 M195 M193 M183 M117 M167 M287 M
InterestExpenseOperating-4 M-6 M-6 M-3 M-2 M-1000000.0-1000000.0-3 M-5 M-12 M
LossAndLossAdjustmentExpectedIncurred24 M
MinorityInterests-159 M-164 M-145 M-150 M-158 M-160 M-165 M-172 M-182 M-155 M
MiscOtherSpecialCharges-118 M-87 M-108 M-74 M-70 M-80 M-360 M
Net income from total operations2,180 M1,384 M2,441 M2,024 M2,400 M2,367 M2,695 M2,166 M1,785 M2,300 M
NetIncomeCommonStockholders2,204 M3,578 M2,540 M2,126 M2,543 M2,512 M2,695 M2,166 M1,785 M2,300 M
NetIncomeContinuousOperations2,180 M1,384 M2,441 M2,024 M2,400 M2,367 M2,695 M2,166 M1,967 M2,455 M
NetNonOperatingInterestIncomeExpense-28 M-32 M-105 M-105 M-145 M-146 M-165 M-103 M153 M232 M
NonRecurringOperationExpense7,168 M6,313 M267 M
Normalized income2,665 M2,868 M11,102 M
Operating income3,557 M2,789 M3,837 M3,707 M3,694 M3,554 M3,885 M3,332 M2,893 M3,984 M
Operating income before depreciation (EBITDA)4,105 M3,345 M4,330 M4,115 M4,168 M4,012 M4,369 M3,760 M3,372 M4,246 M
OperatingExpense6,552 M4,442 M11,358 M5,573 M11,850 M5,771 M12,586 M13,518 M6,631 M7,241 M
Other income net6,635 M-107 M118 M87 M108 M74 M70 M-804 M-461 M
OtherGandA5,982 M5,464 M5,249 M5,400 M5,389 M5,575 M12,473 M6,407 M6,565 M7,151 M
OtherOperatingExpenses570 M62 M37 M173 M148 M196 M113 M65 M69 M191 M
OtherTaxes7,719 M
PromotionAndAdvertising1,784 M1,491 M1,428 M1,573 M1,590 M1,694 M1,948 M2,021 M1,997 M2,371 M
RentAndLandingFees234 M214 M204 M211 M213 M
Research & development expense277 M274 M289 M285 M277 M281 M290 M307 M320 M343 M
ResearchExpense277 M274 M289 M285 M277 M281 M290 M307 M320 M343 M
RestructringAndMnAIncome170 M105 M152 M88 M57 M-13 M24 M
Revenue per share2,307 M2,103 M2,107 M2,218 M2,530 M3,508 M3,824 M7,046 M3,352 M3,410 M
SalariesAndWages-42 M-1,084 M-40 M-42 M-25 M-20 M-20 M-25 M-25 M-22 M
Selling Gen & administrative expense5,982 M5,464 M5,249 M5,400 M5,389 M5,575 M12,473 M6,407 M6,565 M7,151 M
SellingAndMarketingExpense1,784 M1,491 M1,428 M1,573 M1,590 M1,694 M1,948 M2,021 M1,997 M2,371 M
SellingExpense5,982 M5,464 M5,249 M5,497 M
Special income/charges-7,168 M-170 M-105 M-152 M-88 M-57 M13 M-571 M-721 M-291 M
Total Income available for interest expense (EBIT)3,663 M2,896 M3,887 M3,640 M3,657 M3,493 M3,830 M3,204 M2,827 M3,679 M
Total common shares outstanding907 M893 M883 M875 M862 M855 M849 M840 M830 M823 M
Total net income2,180 M1,384 M2,441 M2,024 M2,400 M2,367 M2,695 M2,166 M1,785 M2,300 M
Total ordinary shares817 M817 M817 M817 M817 M817 M817 M817 M817 M817 M
Total revenues17,277 M16,034 M15,195 M15,454 M15,544 M15,693 M16,471 M17,421 M17,967 M19,457 M
TotalExpenses7,878 M5,677 M12,498 M11,967 M18,163 M12,139 M19,040 M20,564 M14,350 M15,372 M
TotalRevenue17,277 M16,034 M15,195 M15,454 M15,544 M15,693 M16,471 M17,421 M17,967 M19,457 M
WriteDown6,368 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