|
Colgate-Palmolive Company (CL) DCF Valuation
US | Consumer Defensive | Household & Personal Products | NYSE
|
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Colgate-Palmolive Company (CL) Bundle
Looking to determine the intrinsic value of Colgate-Palmolive Company? Our (CL) DCF Calculator integrates real-world data with extensive customization features, allowing you to refine your forecasts and enhance your investment choices.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 15,693.0 | 16,471.0 | 17,421.0 | 17,967.0 | 19,457.0 | 20,534.9 | 21,672.5 | 22,873.2 | 24,140.4 | 25,477.8 |
Revenue Growth, % | 0.00 | 4.96 | 5.77 | 3.13 | 8.29 | 5.54 | 5.54 | 5.54 | 5.54 | 5.54 |
EBITDA | 4,163.0 | 4,327.0 | 4,369.0 | 4,127.0 | 4,246.0 | 5,037.2 | 5,316.3 | 5,610.8 | 5,921.6 | 6,249.7 |
EBITDA, % | 26.53 | 26.27 | 25.08 | 22.97 | 21.82 | 24.53 | 24.53 | 24.53 | 24.53 | 24.53 |
Depreciation | 519.0 | 539.0 | 556.0 | 545.0 | 567.0 | 644.8 | 680.5 | 718.2 | 758.0 | 800.0 |
Depreciation, % | 3.31 | 3.27 | 3.19 | 3.03 | 2.91 | 3.14 | 3.14 | 3.14 | 3.14 | 3.14 |
EBIT | 3,644.0 | 3,788.0 | 3,813.0 | 3,582.0 | 3,679.0 | 4,392.4 | 4,635.8 | 4,892.6 | 5,163.6 | 5,449.7 |
EBIT, % | 23.22 | 23.00 | 21.89 | 19.94 | 18.91 | 21.39 | 21.39 | 21.39 | 21.39 | 21.39 |
Total Cash | 883.0 | 888.0 | 832.0 | 775.0 | 1,145.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,440.0 | 1,264.0 | 1,297.0 | 1,504.0 | 1,586.0 | 1,675.6 | 1,768.5 | 1,866.4 | 1,969.9 | 2,079.0 |
Account Receivables, % | 9.18 | 7.67 | 7.45 | 8.37 | 8.15 | 8.16 | 8.16 | 8.16 | 8.16 | 8.16 |
Inventories | 1,400.0 | 1,673.0 | 1,692.0 | 2,074.0 | 1,934.0 | 2,063.8 | 2,178.1 | 2,298.8 | 2,426.1 | 2,560.5 |
Inventories, % | 8.92 | 10.16 | 9.71 | 11.54 | 9.94 | 10.05 | 10.05 | 10.05 | 10.05 | 10.05 |
Accounts Payable | 1,237.0 | 1,393.0 | 1,479.0 | 1,551.0 | 1,698.0 | 1,733.1 | 1,829.2 | 1,930.5 | 2,037.4 | 2,150.3 |
Accounts Payable, % | 7.88 | 8.46 | 8.49 | 8.63 | 8.73 | 8.44 | 8.44 | 8.44 | 8.44 | 8.44 |
Capital Expenditure | -335.0 | -410.0 | -567.0 | -696.0 | -705.0 | -632.5 | -667.5 | -704.5 | -743.5 | -784.7 |
Capital Expenditure, % | -2.13 | -2.49 | -3.25 | -3.87 | -3.62 | -3.08 | -3.08 | -3.08 | -3.08 | -3.08 |
Tax Rate, % | 28.29 | 26.10 | 29.83 | 32.90 | 32.19 | 29.86 | 29.86 | 29.86 | 29.86 | 29.86 |
EBITAT | 2,613.0 | 2,799.2 | 2,675.4 | 2,403.7 | 2,494.6 | 3,080.8 | 3,251.5 | 3,431.6 | 3,621.8 | 3,822.4 |
Depreciation | 519.0 | 539.0 | 556.0 | 545.0 | 567.0 | 644.8 | 680.5 | 718.2 | 758.0 | 800.0 |
Changes in Account Receivables | -89.6 | -92.9 | -97.9 | -103.5 | -109.1 | |||||
Changes in Inventories | -129.8 | -114.3 | -120.7 | -127.3 | -134.4 | |||||
Changes in Accounts Payable | 35.1 | 96.1 | 101.3 | 106.9 | 112.9 | |||||
Capital Expenditure | -335.0 | -410.0 | -567.0 | -696.0 | -705.0 | -632.5 | -667.5 | -704.5 | -743.5 | -784.7 |
UFCF | 1,194.0 | 2,987.2 | 2,698.4 | 1,735.7 | 2,561.6 | 2,908.9 | 3,153.4 | 3,328.1 | 3,512.4 | 3,707.1 |
WACC, % | 6.07 | 6.08 | 6.06 | 6.04 | 6.05 | 6.06 | 6.06 | 6.06 | 6.06 | 6.06 |
PV UFCF | 2,742.7 | 2,803.4 | 2,789.6 | 2,775.9 | 2,762.4 | |||||
SUM PV UFCF | 13,873.9 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 3,818.3 | |||||||||
Terminal Value | 124,781.5 | |||||||||
Present Terminal Value | 92,980.5 | |||||||||
Enterprise Value | 106,854.4 | |||||||||
Net Debt | 8,098.0 | |||||||||
Equity Value | 98,756.4 | |||||||||
Diluted Shares Outstanding, MM | 829.0 | |||||||||
Equity Value Per Share | 119.13 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to create various scenarios for Colgate-Palmolive Company (CL).
- Real-World Data: Colgate-Palmolive’s financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for assessing projections, validating strategies, and enhancing efficiency.
Key Features
- 🔍 Real-Life CL Financials: Pre-filled historical and projected data for Colgate-Palmolive Company.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Colgate-Palmolive’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Colgate-Palmolive’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the prebuilt Excel template featuring Colgate-Palmolive Company’s (CL) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view updated results, including Colgate-Palmolive Company’s (CL) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Financial Data: Colgate-Palmolive's historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Investors: Evaluate Colgate-Palmolive's valuation before making stock transactions.
- CFOs and Financial Analysts: Optimize valuation workflows and assess financial forecasts.
- Startup Founders: Discover how leading consumer goods companies like Colgate-Palmolive are appraised.
- Consultants: Provide detailed valuation analyses for clients in need.
- Students and Educators: Utilize actual market data to learn and instruct on valuation methodologies.
What the Template Contains
- Historical Data: Includes Colgate-Palmolive's past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Colgate-Palmolive's intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Colgate-Palmolive's financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.