Projected Income Statement: Colgate-Palmolive Company

Forecast Balance Sheet: Colgate-Palmolive Company

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
Net Debt 1 6,713 6,413 7,991 7,583 6,853 7,167 7,091 6,909
Change - -4.47% 24.61% -5.11% -9.63% 4.58% -1.06% -2.57%
Announcement Date 29/01/21 28/01/22 27/01/23 26/01/24 31/01/25 - - -
1USD in Million
Estimates

Cash Flow Forecast: Colgate-Palmolive Company

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
CAPEX 1 410 567 696 705 561 579.2 617.9 642.7
Change - 38.29% 22.75% 1.29% -20.43% 3.24% 6.68% 4.02%
Free Cash Flow (FCF) 1 3,309 2,758 1,860 3,040 3,546 3,402 3,322 3,485
Change - -16.65% -32.56% 63.44% 16.64% -4.06% -2.36% 4.92%
Announcement Date 29/01/21 28/01/22 27/01/23 26/01/24 31/01/25 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Colgate-Palmolive Company

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027

Profitability

        
EBITDA Margin (%) 26.8% 25.45% 23.52% 23.66% 24.67% 24.36% 24.4% 24.78%
EBIT Margin (%) 23.53% 22.25% 20.49% 20.74% 21.66% 21.33% 21.42% 21.85%
EBT Margin (%) 22.14% 17.72% 14.8% 17.43% 19.68% 19.58% 20.11% 20.77%
Net margin (%) 16.36% 12.43% 9.93% 11.82% 14.37% 14.42% 14.78% 15.33%
FCF margin (%) 20.09% 15.83% 10.35% 15.62% 17.64% 16.78% 15.82% 16.06%
FCF / Net Income (%) 122.78% 127.33% 104.2% 132.17% 122.74% 116.33% 107% 104.75%

Profitability

        
ROA 17% 17.56% 11.6% 14.32% 17.81% 18.05% 18.26% 19.02%
ROE 626.7% 402.22% 493.66% 957.33% 703.78% 409.28% 303.19% 260.68%

Financial Health

        
Leverage (Debt/EBITDA) 1.52x 1.45x 1.89x 1.65x 1.38x 1.45x 1.38x 1.28x
Debt / Free cash flow 2.03x 2.33x 4.3x 2.49x 1.93x 2.11x 2.13x 1.98x

Capital Intensity

        
CAPEX / Current Assets (%) 2.49% 3.25% 3.87% 3.62% 2.79% 2.86% 2.94% 2.96%
CAPEX / EBITDA (%) 9.29% 12.79% 16.47% 15.32% 11.32% 11.72% 12.06% 11.95%
CAPEX / FCF (%) 12.39% 20.56% 37.42% 23.19% 15.82% 17.03% 18.6% 18.44%

Items per share

        
Cash flow per share 1 4.328 3.92 3.047 4.516 4.989 4.616 4.656 5.044
Change - -9.43% -22.26% 48.2% 10.48% -7.47% 0.87% 8.32%
Dividend per Share 1 1.75 1.79 1.86 1.91 1.98 2.088 2.153 2.251
Change - 2.29% 3.91% 2.69% 3.66% 5.47% 3.09% 4.56%
Book Value Per Share 1 0.87 0.7207 0.4794 0.736 0.2575 1.099 1.38 1.699
Change - -17.16% -33.48% 53.53% -65.01% 326.94% 25.5% 23.17%
EPS 1 3.14 2.55 2.13 2.77 3.51 3.579 3.854 4.158
Change - -18.79% -16.47% 30.05% 26.71% 1.96% 7.7% 7.89%
Nbr of stocks (in thousands) 857,169 842,849 835,214 823,372 817,011 806,065 806,065 806,065
Announcement Date 29/01/21 28/01/22 27/01/23 26/01/24 31/01/25 - - -
1USD
Estimates
2025 *2026 *
P/E ratio 23.6x 21.9x
PBR 76.9x 61.3x
EV / Sales 3.71x 3.58x
Yield 2.47% 2.55%
More valuation ratios * Estimated data

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
AA
More Ratings
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
21
Last Close Price
84.52USD
Average target price
88.79USD
Spread / Average Target
+5.05%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. CL Stock
  4. Financials Colgate-Palmolive Company