Projected Income Statement: Colgate-Palmolive Company

Forecast Balance Sheet: Colgate-Palmolive Company

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 6,413 7,991 7,583 6,853 6,700 6,573 6,356 6,030
Change - 24.61% -5.11% -9.63% -2.23% -1.9% -3.3% -5.13%
Announcement Date 28/01/22 27/01/23 26/01/24 31/01/25 30/01/26 - - -
1USD in Million
Estimates

Cash Flow Forecast: Colgate-Palmolive Company

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 567 696 705 561 564 596.6 636 674.7
Change - 22.75% 1.29% -20.43% 0.53% 5.77% 6.61% 6.09%
Free Cash Flow (FCF) 1 2,758 1,860 3,040 3,546 3,634 2,784 3,407 3,703
Change - -32.56% 63.44% 16.64% 2.48% -23.4% 22.38% 8.71%
Announcement Date 28/01/22 27/01/23 26/01/24 31/01/25 30/01/26 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Colgate-Palmolive Company

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

Profitability

        
EBITDA Margin (%) 25.45% 23.52% 23.66% 24.67% 24.42% 23.79% 23.99% 24.4%
EBIT Margin (%) 22.25% 20.49% 20.74% 21.66% 21.33% 20.62% 20.98% 21.45%
EBT Margin (%) 17.72% 14.8% 17.43% 19.68% 15.01% 18.51% 19.73% 20.43%
Net margin (%) 12.43% 9.93% 11.82% 14.37% 10.46% 14.19% 14.1% 15.28%
FCF margin (%) 15.83% 10.35% 15.62% 17.64% 17.83% 12.99% 15.39% 16.18%
FCF / Net Income (%) 127.33% 104.2% 132.17% 122.74% 170.45% 91.53% 109.1% 105.91%

Profitability

        
ROA 17.56% 11.6% 14.32% 17.81% 18.51% 18.81% 19.83% 20.16%
ROE 402.22% 493.66% 957.33% 703.78% 659.19% 668.38% 359.39% 272.06%

Financial Health

        
Leverage (Debt/EBITDA) 1.45x 1.89x 1.65x 1.38x 1.35x 1.29x 1.2x 1.08x
Debt / Free cash flow 2.33x 4.3x 2.49x 1.93x 1.84x 2.36x 1.87x 1.63x

Capital Intensity

        
CAPEX / Current Assets (%) 3.25% 3.87% 3.62% 2.79% 2.77% 2.78% 2.87% 2.95%
CAPEX / EBITDA (%) 12.79% 16.47% 15.32% 11.32% 11.33% 11.7% 11.97% 12.08%
CAPEX / FCF (%) 20.56% 37.42% 23.19% 15.82% 15.52% 21.43% 18.67% 18.22%

Items per share

        
Cash flow per share 1 3.92 3.047 4.516 4.989 5.176 4.644 4.954 5.32
Change - -22.26% 48.2% 10.48% 3.74% -10.28% 6.68% 7.39%
Dividend per Share 1 1.79 1.86 1.91 1.98 2.06 2.109 2.211 2.293
Change - 3.91% 2.69% 3.66% 4.04% 2.36% 4.86% 3.72%
Book Value Per Share 1 0.7207 0.4794 0.736 0.2575 0.0666 0.8967 1.221 1.618
Change - -33.48% 53.53% -65.01% -74.14% 1,246.46% 36.18% 32.5%
EPS 1 2.55 2.13 2.77 3.51 2.63 3.719 3.897 4.346
Change - -16.47% 30.05% 26.71% -25.07% 41.42% 4.77% 11.53%
Nbr of stocks (in thousands) 8,42,849 8,35,214 8,23,372 8,17,011 8,06,065 8,00,189 8,00,189 8,00,189
Announcement Date 28/01/22 27/01/23 26/01/24 31/01/25 30/01/26 - - -
1USD
Estimates
2026 *2027 *
P/E ratio 23.9x 22.8x
PBR 99.1x 72.7x
EV / Sales 3.62x 3.5x
Yield 2.37% 2.49%

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
AAA
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
20
Last Close Price
88.84USD
Average target price
95.84USD
Spread / Average Target
+7.88%

Quarterly revenue - Rate of surprise

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