|
Valoración de DCF Diageo PLC (DEO)
GB | Consumer Defensive | Beverages - Wineries & Distilleries | NYSE
|
- ✓ 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
Diageo plc (DEO) Bundle
¡Mejore sus opciones de inversión con la calculadora DCF (DEO)! Explore los datos financieros genuinos de Diageo, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estas modificaciones afectan el valor intrínseco de (DEO).
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 14,713.4 | 15,941.6 | 19,345.7 | 21,425.3 | 20,158.6 | 21,899.2 | 23,790.1 | 25,844.3 | 28,075.9 | 30,500.2 |
| Revenue Growth, % | 0 | 8.35 | 21.35 | 10.75 | -5.91 | 8.63 | 8.63 | 8.63 | 8.63 | 8.63 |
| EBITDA | 5,603.9 | 5,255.8 | 6,178.6 | 7,048.7 | 6,769.9 | 7,422.8 | 8,063.7 | 8,760.0 | 9,516.4 | 10,338.1 |
| EBITDA, % | 38.09 | 32.97 | 31.94 | 32.9 | 33.58 | 33.9 | 33.9 | 33.9 | 33.9 | 33.9 |
| Depreciation | 601.0 | 559.6 | 612.2 | 621.0 | 673.3 | 744.5 | 808.8 | 878.6 | 954.5 | 1,036.9 |
| Depreciation, % | 4.08 | 3.51 | 3.16 | 2.9 | 3.34 | 3.4 | 3.4 | 3.4 | 3.4 | 3.4 |
| EBIT | 5,002.9 | 4,696.2 | 5,566.3 | 6,427.7 | 6,096.6 | 6,678.3 | 7,255.0 | 7,881.4 | 8,561.9 | 9,301.2 |
| EBIT, % | 34 | 29.46 | 28.77 | 30 | 30.24 | 30.5 | 30.5 | 30.5 | 30.5 | 30.5 |
| Total Cash | 4,254.3 | 3,593.2 | 3,175.0 | 2,236.0 | 1,391.5 | 3,731.9 | 4,054.1 | 4,404.2 | 4,784.5 | 5,197.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,875.5 | 2,274.9 | 3,495.5 | 2,498.2 | 2,648.4 | 3,060.8 | 3,325.1 | 3,612.2 | 3,924.1 | 4,262.9 |
| Account Receivables, % | 12.75 | 14.27 | 18.07 | 11.66 | 13.14 | 13.98 | 13.98 | 13.98 | 13.98 | 13.98 |
| Inventories | 7,226.5 | 7,568.3 | 8,881.6 | 9,591.5 | 9,626.9 | 10,293.6 | 11,182.4 | 12,148.0 | 13,197.0 | 14,336.5 |
| Inventories, % | 49.12 | 47.48 | 45.91 | 44.77 | 47.76 | 47 | 47 | 47 | 47 | 47 |
| Accounts Payable | 1,668.9 | 2,521.5 | 1,107.0 | 3,329.0 | 7,955.1 | 3,849.1 | 4,181.5 | 4,542.5 | 4,934.8 | 5,360.9 |
| Accounts Payable, % | 11.34 | 15.82 | 5.72 | 15.54 | 39.46 | 17.58 | 17.58 | 17.58 | 17.58 | 17.58 |
| Capital Expenditure | -876.4 | -783.7 | -1,373.4 | -1,477.3 | -1,495.5 | -1,414.1 | -1,536.2 | -1,668.8 | -1,812.9 | -1,969.5 |
| Capital Expenditure, % | -5.96 | -4.92 | -7.1 | -6.9 | -7.42 | -6.46 | -6.46 | -6.46 | -6.46 | -6.46 |
| Tax Rate, % | 3.45 | 3.45 | 3.45 | 3.45 | 3.45 | 3.45 | 3.45 | 3.45 | 3.45 | 3.45 |
| EBITAT | 4,247.1 | 3,370.7 | 5,000.0 | 6,032.8 | 5,886.1 | 5,835.4 | 6,339.3 | 6,886.7 | 7,481.3 | 8,127.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -3,461.4 | 3,258.0 | 290.3 | 7,686.0 | 9,504.3 | -19.3 | 4,791.1 | 5,204.8 | 5,654.3 | 6,142.5 |
| WACC, % | 6.21 | 6.15 | 6.23 | 6.25 | 6.26 | 6.22 | 6.22 | 6.22 | 6.22 | 6.22 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 17,554.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 6,265 | |||||||||
| Terminal Value | 148,405 | |||||||||
| Present Terminal Value | 109,744 | |||||||||
| Enterprise Value | 127,298 | |||||||||
| Net Debt | 21,892 | |||||||||
| Equity Value | 105,406 | |||||||||
| Diluted Shares Outstanding, MM | 2,239 | |||||||||
| Equity Value Per Share | 47.08 |
What You Will Get
- Real DEO Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Automated Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess Diageo’s future performance.
- User-Friendly Design: Designed for professionals while remaining easy for newcomers.
Key Features
- Real-Life DEO Data: Pre-filled with Diageo’s historical financial metrics and future growth expectations.
- Fully Customizable Inputs: Modify revenue growth rates, profit margins, WACC, tax percentages, and capital expenditures.
- Dynamic Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Testing: Develop various forecast scenarios to evaluate different valuation results.
- User-Friendly Design: Intuitive, organized, and suitable for both professionals and novices.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Diageo plc's pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you tweak assumptions.
- Step 5: Analyze the outputs and use the results for investment decisions.
Why Choose This Calculator for Diageo plc (DEO)?
- Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
- Accurate Financial Data: Diageo’s historical and projected financials are preloaded for precise calculations.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance makes navigation simple and straightforward.
Who Should Use Diageo plc (DEO)?
- Investors: Make informed decisions with insights from a leading global beverage company.
- Market Analysts: Access detailed reports and data on Diageo's performance and market trends.
- Consultants: Utilize Diageo’s brand portfolio for strategic recommendations and presentations.
- Beverage Enthusiasts: Explore the diverse range of products and learn about their heritage and production.
- Students and Educators: Incorporate real-world case studies from Diageo into business and finance curricula.
What the Template Contains
- Preloaded DEO Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.