Kimberly-Clark Corporation (KMB) 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
Kimberly-Clark Corporation (KMB) Bundle
Gain insight into your Kimberly-Clark Corporation (KMB) valuation analysis using our state-of-the-art DCF Calculator! This Excel template comes preloaded with real (KMB) data, enabling you to adjust forecasts and assumptions for an accurate calculation of Kimberly-Clark's intrinsic value.
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 | 18,450.0 | 19,140.0 | 19,440.0 | 20,175.0 | 20,431.0 | 20,960.0 | 21,502.7 | 22,059.5 | 22,630.7 | 23,216.6 |
| Revenue Growth, % | 0 | 3.74 | 1.57 | 3.78 | 1.27 | 2.59 | 2.59 | 2.59 | 2.59 | 2.59 |
| EBITDA | 3,828.0 | 3,978.0 | 3,247.0 | 3,376.0 | 3,067.0 | 3,771.9 | 3,869.6 | 3,969.8 | 4,072.6 | 4,178.0 |
| EBITDA, % | 20.75 | 20.78 | 16.7 | 16.73 | 15.01 | 18 | 18 | 18 | 18 | 18 |
| Depreciation | 917.0 | 796.0 | 766.0 | 754.0 | 753.0 | 859.0 | 881.3 | 904.1 | 927.5 | 951.5 |
| Depreciation, % | 4.97 | 4.16 | 3.94 | 3.74 | 3.69 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 |
| EBIT | 2,911.0 | 3,182.0 | 2,481.0 | 2,622.0 | 2,314.0 | 2,912.9 | 2,988.3 | 3,065.7 | 3,145.1 | 3,226.5 |
| EBIT, % | 15.78 | 16.62 | 12.76 | 13 | 11.33 | 13.9 | 13.9 | 13.9 | 13.9 | 13.9 |
| Total Cash | 442.0 | 303.0 | 270.0 | 427.0 | 1,093.0 | 538.0 | 551.9 | 566.2 | 580.9 | 595.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2,263.0 | 2,235.0 | 2,207.0 | 2,280.0 | 2,135.0 | 2,391.4 | 2,453.3 | 2,516.8 | 2,582.0 | 2,648.9 |
| Account Receivables, % | 12.27 | 11.68 | 11.35 | 11.3 | 10.45 | 11.41 | 11.41 | 11.41 | 11.41 | 11.41 |
| Inventories | 1,790.0 | 1,903.0 | 2,239.0 | 2,269.0 | 1,955.0 | 2,178.9 | 2,235.3 | 2,293.2 | 2,352.6 | 2,413.5 |
| Inventories, % | 9.7 | 9.94 | 11.52 | 11.25 | 9.57 | 10.4 | 10.4 | 10.4 | 10.4 | 10.4 |
| Accounts Payable | 3,055.0 | 3,336.0 | 3,840.0 | 3,813.0 | 3,653.0 | 3,794.6 | 3,892.9 | 3,993.7 | 4,097.1 | 4,203.1 |
| Accounts Payable, % | 16.56 | 17.43 | 19.75 | 18.9 | 17.88 | 18.1 | 18.1 | 18.1 | 18.1 | 18.1 |
| Capital Expenditure | -1,209.0 | -1,217.0 | -1,007.0 | -876.0 | -766.0 | -1,097.6 | -1,126.0 | -1,155.1 | -1,185.1 | -1,215.7 |
| Capital Expenditure, % | -6.55 | -6.36 | -5.18 | -4.34 | -3.75 | -5.24 | -5.24 | -5.24 | -5.24 | -5.24 |
| Tax Rate, % | 12.72 | 12.72 | 12.72 | 12.72 | 12.72 | 12.72 | 12.72 | 12.72 | 12.72 | 12.72 |
| EBITAT | 2,369.4 | 2,554.3 | 2,022.7 | 2,167.1 | 2,019.7 | 2,406.8 | 2,469.1 | 2,533.1 | 2,598.7 | 2,665.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,079.4 | 2,329.3 | 1,977.7 | 1,915.1 | 2,305.7 | 1,829.6 | 2,204.3 | 2,261.4 | 2,320.0 | 2,380.0 |
| WACC, % | 5.97 | 5.96 | 5.97 | 5.98 | 6.01 | 5.98 | 5.98 | 5.98 | 5.98 | 5.98 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 9,208.8 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 2,451 | |||||||||
| Terminal Value | 82,353 | |||||||||
| Present Terminal Value | 61,607 | |||||||||
| Enterprise Value | 70,816 | |||||||||
| Net Debt | 7,021 | |||||||||
| Equity Value | 63,795 | |||||||||
| Diluted Shares Outstanding, MM | 339 | |||||||||
| Equity Value Per Share | 188.30 |
What You Will Receive
- Adjustable Forecast Inputs: Modify key assumptions (growth %, margins, WACC) to generate various scenarios.
- Comprehensive Data: Kimberly-Clark Corporation’s (KMB) financial data pre-loaded to facilitate your analysis.
- Instant DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Tailored and Professional: A sleek Excel model that caters to your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive Financial Data: Kimberly-Clark's historical financial statements and pre-filled projections.
- Customizable Assumptions: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Valuation: Observe Kimberly-Clark's intrinsic value recalculating instantly.
- Intuitive Visualizations: Dashboard graphs illustrate valuation outcomes and essential metrics clearly.
- Designed for Precision: A professional-grade tool tailored for analysts, investors, and finance professionals.
How It Works
- Download: Obtain the pre-prepared Excel file containing Kimberly-Clark Corporation’s (KMB) financial data.
- Customize: Modify forecasts, such as revenue growth, EBITDA %, and WACC according to your analysis.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time as you make changes.
- Test Scenarios: Generate various projections and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment choices.
Why Choose Kimberly-Clark Corporation (KMB)?
- Commitment to Quality: Renowned for delivering high-quality products that meet consumer needs.
- Innovative Solutions: Continually develops new products to enhance everyday life.
- Sustainability Focus: Dedicated to environmentally friendly practices and sustainable sourcing.
- Global Reach: Operates in numerous countries, providing trusted brands worldwide.
- Strong Financial Performance: Proven track record of delivering value to shareholders.
Who Should Use Kimberly-Clark Corporation (KMB)?
- Investors: Gain insights into consumer goods investments with a trusted brand in the market.
- Financial Analysts: Utilize comprehensive data to enhance your analysis of market trends and performance.
- Consultants: Tailor presentations for clients by leveraging Kimberly-Clark's extensive portfolio of products.
- Business Students: Explore case studies and real-world applications of business strategies in the consumer goods sector.
- Industry Researchers: Access valuable information for in-depth studies on market dynamics and consumer behavior.
What the Template Contains
- Historical Data: Includes Kimberly-Clark’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Kimberly-Clark’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 Kimberly-Clark’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.