|
La valoración DCF de Kraft Heinz Company (KHC)
US | Consumer Defensive | Packaged Foods | NASDAQ
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
The Kraft Heinz Company (KHC) Bundle
Ya sea que sea un inversor o analista, esta calculadora DCF (KHC) es su herramienta esencial para una valoración precisa. Con datos reales de la compañía Kraft Heinz cargada, puede ajustar los pronósticos e inmediatamente observar los efectos.
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 | 24,977.0 | 26,185.0 | 26,042.0 | 26,485.0 | 26,640.0 | 27,078.0 | 27,523.2 | 27,975.7 | 28,435.7 | 28,903.2 |
| Revenue Growth, % | 0 | 4.84 | -0.54611 | 1.7 | 0.58524 | 1.64 | 1.64 | 1.64 | 1.64 | 1.64 |
| EBITDA | 5,041.0 | 3,403.0 | 4,680.0 | 4,827.0 | 5,514.0 | 4,878.0 | 4,958.2 | 5,039.7 | 5,122.6 | 5,206.8 |
| EBITDA, % | 20.18 | 13 | 17.97 | 18.23 | 20.7 | 18.01 | 18.01 | 18.01 | 18.01 | 18.01 |
| Depreciation | 994.0 | 969.0 | 910.0 | 933.0 | 961.0 | 991.3 | 1,007.6 | 1,024.2 | 1,041.0 | 1,058.1 |
| Depreciation, % | 3.98 | 3.7 | 3.49 | 3.52 | 3.61 | 3.66 | 3.66 | 3.66 | 3.66 | 3.66 |
| EBIT | 4,047.0 | 2,434.0 | 3,770.0 | 3,894.0 | 4,553.0 | 3,886.7 | 3,950.6 | 4,015.5 | 4,081.6 | 4,148.7 |
| EBIT, % | 16.2 | 9.3 | 14.48 | 14.7 | 17.09 | 14.35 | 14.35 | 14.35 | 14.35 | 14.35 |
| Total Cash | 2,279.0 | 3,417.0 | 3,445.0 | 1,040.0 | 1,400.0 | 2,414.5 | 2,454.2 | 2,494.6 | 2,535.6 | 2,577.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,973.0 | 2,063.0 | 1,957.0 | 2,120.0 | 2,112.0 | 2,124.3 | 2,159.2 | 2,194.7 | 2,230.8 | 2,267.5 |
| Account Receivables, % | 7.9 | 7.88 | 7.51 | 8 | 7.93 | 7.85 | 7.85 | 7.85 | 7.85 | 7.85 |
| Inventories | 2,721.0 | 2,554.0 | 2,729.0 | 3,651.0 | 3,614.0 | 3,166.9 | 3,219.0 | 3,271.9 | 3,325.7 | 3,380.4 |
| Inventories, % | 10.89 | 9.75 | 10.48 | 13.79 | 13.57 | 11.7 | 11.7 | 11.7 | 11.7 | 11.7 |
| Accounts Payable | 4,003.0 | 4,304.0 | 4,753.0 | 4,848.0 | 4,627.0 | 4,678.4 | 4,755.4 | 4,833.6 | 4,913.0 | 4,993.8 |
| Accounts Payable, % | 16.03 | 16.44 | 18.25 | 18.3 | 17.37 | 17.28 | 17.28 | 17.28 | 17.28 | 17.28 |
| Capital Expenditure | -768.0 | -596.0 | -905.0 | -916.0 | -1,013.0 | -871.2 | -885.5 | -900.1 | -914.9 | -929.9 |
| Capital Expenditure, % | -3.07 | -2.28 | -3.48 | -3.46 | -3.8 | -3.22 | -3.22 | -3.22 | -3.22 | -3.22 |
| Tax Rate, % | 21.41 | 21.41 | 21.41 | 21.41 | 21.41 | 21.41 | 21.41 | 21.41 | 21.41 | 21.41 |
| EBITAT | 2,942.9 | 841.3 | 2,233.7 | 3,102.3 | 3,578.0 | 2,524.7 | 2,566.2 | 2,608.4 | 2,651.3 | 2,694.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 2,477.9 | 1,592.3 | 2,618.7 | 2,129.3 | 3,350.0 | 3,131.0 | 2,678.2 | 2,722.2 | 2,767.0 | 2,812.5 |
| WACC, % | 5.47 | 4.87 | 5.26 | 5.58 | 5.57 | 5.35 | 5.35 | 5.35 | 5.35 | 5.35 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 12,126.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 2,869 | |||||||||
| Terminal Value | 85,606 | |||||||||
| Present Terminal Value | 65,964 | |||||||||
| Enterprise Value | 78,090 | |||||||||
| Net Debt | 19,246 | |||||||||
| Equity Value | 58,844 | |||||||||
| Diluted Shares Outstanding, MM | 1,235 | |||||||||
| Equity Value Per Share | 47.65 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring real KHC financials.
- Actual Data: Historical performance and future projections (highlighted in the yellow cells).
- Flexible Forecasting: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Kraft Heinz’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Interface: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- Comprehensive Kraft Heinz Financials: Gain access to precise pre-loaded historical data and forward-looking projections for The Kraft Heinz Company (KHC).
- Adjustable Forecast Parameters: Modify highlighted cells for metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic recalculations for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
- Designed for All Skill Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based KHC DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other factors.
- Instant Calculations: The model automatically recalculates Kraft Heinz’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation impacts.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for The Kraft Heinz Company (KHC)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for KHC.
- Flexible Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes KHC’s intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable starting points.
- Expert-Level Tool: Perfect for financial analysts, investors, and business consultants focused on KHC.
Who Should Use This Product?
- Investors: Accurately assess The Kraft Heinz Company's (KHC) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis of KHC.
- Consultants: Efficiently modify the template for valuation reports tailored to KHC clients.
- Entrepreneurs: Acquire insights into financial modeling practices used by major corporations like KHC.
- Educators: Employ it as a teaching resource to illustrate valuation methodologies relevant to KHC.
What the Template Contains
- Pre-Filled DCF Model: The Kraft Heinz Company's (KHC) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to (KHC).
- Financial Ratios: Assess (KHC)’s profitability, leverage, and efficiency metrics.
- Editable Inputs: Modify assumptions such as growth rates, margins, and CAPEX to suit your analysis.
- Financial Statements: Access annual and quarterly reports for comprehensive evaluation.
- Interactive Dashboard: Visualize key valuation metrics and outcomes with ease.