Colgate-Palmolive Company (CL) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
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.6 | 21,671.8 | 22,872.0 | 24,138.7 | 25,475.5 |
| Revenue Growth, % | 0 | 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.9 | 5,316.9 | 5,611.4 | 5,922.2 | 6,250.1 |
| 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 | 645.6 | 681.3 | 719.0 | 758.9 | 800.9 |
| 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.6 | 4,892.4 | 5,163.3 | 5,449.3 |
| EBIT, % | 23.22 | 23 | 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 | 1,067.5 | 1,126.6 | 1,189.0 | 1,254.8 | 1,324.3 |
| 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,676.3 | 1,769.2 | 1,867.2 | 1,970.6 | 2,079.7 |
| 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,064.7 | 2,179.1 | 2,299.7 | 2,427.1 | 2,561.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,732.7 | 1,828.6 | 1,929.9 | 2,036.8 | 2,149.6 |
| 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 | -631.5 | -666.4 | -703.3 | -742.3 | -783.4 |
| Capital Expenditure, % | -2.13 | -2.49 | -3.25 | -3.87 | -3.62 | -3.08 | -3.08 | -3.08 | -3.08 | -3.08 |
| Tax Rate, % | 32.19 | 32.19 | 32.19 | 32.19 | 32.19 | 32.19 | 32.19 | 32.19 | 32.19 | 32.19 |
| EBITAT | 2,613.0 | 2,799.2 | 2,675.4 | 2,403.7 | 2,494.6 | 3,080.6 | 3,251.2 | 3,431.3 | 3,621.3 | 3,821.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,194.0 | 2,987.2 | 2,698.4 | 1,735.7 | 2,561.6 | 2,908.3 | 3,154.9 | 3,329.6 | 3,514.0 | 3,708.6 |
| WACC, % | 6.07 | 6.08 | 6.06 | 6.04 | 6.05 | 6.06 | 6.06 | 6.06 | 6.06 | 6.06 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 13,878.6 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 3,820 | |||||||||
| Terminal Value | 124,873 | |||||||||
| Present Terminal Value | 93,053 | |||||||||
| Enterprise Value | 106,931 | |||||||||
| Net Debt | 8,098 | |||||||||
| Equity Value | 98,833 | |||||||||
| Diluted Shares Outstanding, MM | 829 | |||||||||
| Equity Value Per Share | 119.19 |
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.