|
Valoración de DCF de Universal Corporation (UVV)
US | Consumer Defensive | Tobacco | 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
Universal Corporation (UVV) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (UVV)! Equipado con datos de la Corporación Real Universal y suposiciones personalizables, esta herramienta le permite pronosticar, evaluar y valorar Universal Corporation como un inversor experimentado.
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 | 1,910.0 | 1,983.4 | 2,103.6 | 2,569.8 | 2,748.6 | 3,016.7 | 3,311.0 | 3,634.0 | 3,988.6 | 4,377.7 |
| Revenue Growth, % | 0 | 3.84 | 6.06 | 22.16 | 6.96 | 9.76 | 9.76 | 9.76 | 9.76 | 9.76 |
| EBITDA | 173.4 | 188.4 | 214.7 | 250.1 | 283.9 | 294.7 | 323.5 | 355.0 | 389.6 | 427.7 |
| EBITDA, % | 9.08 | 9.5 | 10.21 | 9.73 | 10.33 | 9.77 | 9.77 | 9.77 | 9.77 | 9.77 |
| Depreciation | 39.2 | 44.7 | 52.5 | 57.3 | 58.3 | 67.3 | 73.9 | 81.1 | 89.0 | 97.7 |
| Depreciation, % | 2.05 | 2.26 | 2.5 | 2.23 | 2.12 | 2.23 | 2.23 | 2.23 | 2.23 | 2.23 |
| EBIT | 134.3 | 143.7 | 162.2 | 192.8 | 225.5 | 227.4 | 249.6 | 273.9 | 300.7 | 330.0 |
| EBIT, % | 7.03 | 7.24 | 7.71 | 7.5 | 8.21 | 7.54 | 7.54 | 7.54 | 7.54 | 7.54 |
| Total Cash | 107.4 | 197.2 | 81.6 | 64.7 | 55.6 | 144.7 | 158.9 | 174.4 | 191.4 | 210.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 352.2 | 368.1 | 390.0 | 414.3 | 530.6 | 548.8 | 602.4 | 661.1 | 725.6 | 796.4 |
| Account Receivables, % | 18.44 | 18.56 | 18.54 | 16.12 | 19.31 | 18.19 | 18.19 | 18.19 | 18.19 | 18.19 |
| Inventories | 806.6 | 786.6 | 1,016.7 | 1,036.8 | 1,403.2 | 1,337.1 | 1,467.5 | 1,610.7 | 1,767.9 | 1,940.3 |
| Inventories, % | 42.23 | 39.66 | 48.33 | 40.34 | 51.05 | 44.32 | 44.32 | 44.32 | 44.32 | 44.32 |
| Accounts Payable | 87.3 | 140.8 | 168.5 | 89.0 | 110.3 | 163.8 | 179.8 | 197.4 | 216.6 | 237.8 |
| Accounts Payable, % | 4.57 | 7.1 | 8.01 | 3.46 | 4.01 | 5.43 | 5.43 | 5.43 | 5.43 | 5.43 |
| Capital Expenditure | -35.2 | -66.2 | -53.2 | -54.7 | -66.0 | -73.8 | -81.0 | -88.9 | -97.6 | -107.2 |
| Capital Expenditure, % | -1.84 | -3.34 | -2.53 | -2.13 | -2.4 | -2.45 | -2.45 | -2.45 | -2.45 | -2.45 |
| Tax Rate, % | 27.11 | 27.11 | 27.11 | 27.11 | 27.11 | 27.11 | 27.11 | 27.11 | 27.11 | 27.11 |
| EBITAT | 84.9 | 99.9 | 98.7 | 168.4 | 164.4 | 161.0 | 176.7 | 193.9 | 212.8 | 233.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -982.6 | 136.1 | -126.2 | 47.2 | -304.7 | 255.8 | 1.5 | 1.6 | 1.8 | 2.0 |
| WACC, % | 6.24 | 6.41 | 6.18 | 6.9 | 6.5 | 6.45 | 6.45 | 6.45 | 6.45 | 6.45 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 245.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 2 | |||||||||
| Terminal Value | 45 | |||||||||
| Present Terminal Value | 33 | |||||||||
| Enterprise Value | 279 | |||||||||
| Net Debt | 1,009 | |||||||||
| Equity Value | -730 | |||||||||
| Diluted Shares Outstanding, MM | 25 | |||||||||
| Equity Value Per Share | -29.14 |
What You Will Receive
- Pre-Filled Financial Model: Universal Corporation's (UVV) actual data facilitates accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential metrics.
- Real-Time Calculations: Automatic updates provide immediate feedback as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for versatility, enabling repeated application for in-depth forecasts.
Key Features
- Comprehensive Financial Data: Gain access to precise historical figures and future forecasts for Universal Corporation (UVV).
- Adjustable Forecast Parameters: Modify highlighted fields such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: Utilize clear charts and summaries to effectively visualize your valuation outcomes.
- Designed for All Skill Levels: A user-friendly layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file for Universal Corporation (UVV).
- Step 2: Review Universal's pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment decisions.
Why Choose This Calculator for Universal Corporation (UVV)?
- Accurate Data: Up-to-date Universal Corporation financials provide dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the field.
- User-Friendly: Easy-to-navigate design and comprehensive instructions ensure accessibility for all users.
Who Should Use This Product?
- Investors: Assess Universal Corporation’s (UVV) valuation before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and evaluate financial forecasts.
- Startup Founders: Understand the valuation strategies of established companies like Universal Corporation.
- Consultants: Provide detailed valuation analyses and reports for your clients.
- Students and Educators: Utilize real data from Universal Corporation to enhance learning of valuation principles.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Universal Corporation (UVV) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Universal Corporation (UVV).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.