CL DCF Model
| Dec'20 Actual | Dec'21 Actual | Dec'22 Actual | Dec'23 Actual | Dec'24 Actual | Dec'25 Estimate | Dec'26 Estimate | Dec'27 Estimate | Dec'28 Estimate | Dec'29 Estimate | Dec'30 Estimate | Dec'31 Estimate | Dec'32 Estimate | Dec'33 Estimate | Dec'34 Estimate | Dec'35 Terminal | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
% growth | 16,471.0 5.0% | 17,421.0 5.8% | 17,967.0 3.1% | 19,457.0 8.3% | 20,101.0 3.3% | 20,431.0 1.6% | 21,248.8 4.0% | 22,076.7 3.9% | 22,511.4 2.0% | 22,955.6 2.0% | 23,409.7 2.0% | 23,873.7 2.0% | 24,348.0 2.0% | 24,832.8 2.0% | 25,328.4 2.0% | 25,834.9 2.0% |
% margin | 3,885.0 23.6% | 4,474.0 25.7% | 4,335.0 24.1% | 3,984.0 20.5% | 4,268.0 21.2% | 4,370.2 21.4% | 4,545.2 21.4% | 4,722.2 21.4% | 4,815.2 21.4% | 4,910.2 21.4% | 5,007.4 21.4% | 5,106.6 21.4% | 5,208.1 21.4% | 5,311.8 21.4% | 5,417.8 21.4% | 5,526.1 21.4% |
NOPAT % effective tax rate | 3,046.6 18.5% | 3,388.5 19.5% | 3,205.6 17.8% | 2,883.5 14.8% | 3,289.5 16.4% | 3,368.3 16.5% | 3,503.1 16.5% | 3,639.6 16.5% | 3,711.2 16.5% | 3,784.5 16.5% | 3,859.3 16.5% | 3,935.8 16.5% | 4,014.0 16.5% | 4,093.9 16.5% | 4,175.6 16.5% | 4,259.1 16.5% |
% of revenue | 539.0 3.3% | 556.0 3.2% | 545.0 3.0% | 567.0 2.9% | 0.0 0.0% | 405.0 2.0% | 421.3 2.0% | 437.7 2.0% | 446.3 2.0% | 455.1 2.0% | 464.1 2.0% | 473.3 2.0% | 482.7 2.0% | 492.3 2.0% | 502.1 2.0% | 512.2 2.0% |
% of revenue | (410.0) (2.5%) | (567.0) (3.3%) | (696.0) (3.9%) | (705.0) (3.6%) | (561.0) (2.8%) | (700.7) (3.4%) | (728.7) (3.4%) | (757.1) (3.4%) | (772.0) (3.4%) | (787.2) (3.4%) | (802.8) (3.4%) | (818.7) (3.4%) | (835.0) (3.4%) | (851.6) (3.4%) | (868.6) (3.4%) | (886.0) (3.4%) |
% of revenue | 381.0 2.3% | (197.0) (1.1%) | (726.0) (4.0%) | 455.0 2.3% | 344.0 1.7% | 0.6 0.0% | 0.6 0.0% | 0.7 0.0% | 0.7 0.0% | 0.7 0.0% | 0.7 0.0% | 0.7 0.0% | 0.7 0.0% | 0.8 0.0% | 0.8 0.0% | 0.8 0.0% |
Free Cash Flow to Firm (FCFF) % of revenue | 3,556.6 21.6% | 3,180.5 18.3% | 2,328.6 13.0% | 3,200.5 16.4% | 3,072.5 15.3% | 3,073.3 15.0% | 3,196.3 15.0% | 3,320.8 15.0% | 3,386.2 15.0% | 3,453.0 15.0% | 3,521.3 15.0% | 3,591.1 15.0% | 3,662.5 15.0% | 3,735.4 15.0% | 3,809.9 15.0% | 3,886.1 15.0% |
% of FCFF used in calculation | 83.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | 100.0% | ||||||
Discount period | 0.50 | 1.50 | 2.50 | 3.50 | 4.50 | 5.50 | 6.50 | 7.50 | 8.50 | 9.50 | ||||||
Discount factor | 0.97 | 0.91 | 0.85 | 0.80 | 0.75 | 0.70 | 0.66 | 0.62 | 0.58 | 0.54 | ||||||
Discounted FCFF (DFCFF) | 2,470.6 | 2,902.8 | 2,828.4 | 2,704.8 | 2,586.6 | 2,473.8 | 2,366.0 | 2,262.9 | 2,164.5 | 2,070.4 |
Best stock ideas on the market right now
With Value Sense, you can find undervalued stocks list with intrinsic value. Discover more stock market investment ideas.
Undervalued stocks right now
Discover the top 20 best undervalued stocks to buy for Mar 2025, listed on the Nasdaq or NYSE.
Low P/E stocks
Explore the best low P/E stocks to buy in 2025, featuring top companies trading at low P/E ratios.
Undervalued dividend stocks
Discover the top 20 best undervalued high-yield dividend stock that offers both growth potential and attractive dividend returns for Mar 2025.
CL DCF Value
DCF Value Calculation
Equity Value Bridge
CL DCF Financials
CL DCF sensitivity
Explore more intrinsic value tools hub for CL
FAQ
What is Colgate-Palmolive Company DCF (discounted cash flow) valuation?
As of Mar 03, 2025, Colgate-Palmolive Company's Discounted Cash Flow (DCF) valuation estimates its share price at $79.2. This suggests it may be overvalued by (14.7%) compared to its current price of around $92.8, using a WACC of 6.6% and growth rates of 2.0%.
What is Colgate-Palmolive Company WACC?
As of Mar 03, 2025, Colgate-Palmolive Company's Weighted Average Cost of Capital (WACC) is approximately 6.6%.
What is Colgate-Palmolive Company Enterprise Value?
As of Mar 03, 2025, Colgate-Palmolive Company's Enterprise Value (EV) is approximately $70.4B. This value reflects the company's total market capitalization plus debt, minus cash and cash equivalents, providing a comprehensive measure of its overall value in the market.