|
Valoración de DCF de Carvana Co. (CVNA)
US | Consumer Cyclical | Specialty Retail | 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
Carvana Co. (CVNA) Bundle
¡Descubra el verdadero valor de Carvana Co. (CVNA) con nuestra calculadora DCF avanzada! Ajuste los supuestos esenciales, explore varios escenarios y evalúe cómo los diferentes cambios afectan la valoración de Carvana Co. (CVNA), todo dentro de una sola plantilla de Excel.
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 | 3,939.9 | 5,586.6 | 12,814.0 | 13,604.0 | 10,771.0 | 14,194.4 | 18,706.0 | 24,651.4 | 32,486.6 | 42,812.0 |
| Revenue Growth, % | 0 | 41.79 | 129.37 | 6.17 | -20.82 | 31.78 | 31.78 | 31.78 | 31.78 | 31.78 |
| EBITDA | -242.8 | -257.2 | -5.0 | -2,146.0 | 1,159.0 | -449.1 | -591.8 | -779.9 | -1,027.8 | -1,354.4 |
| EBITDA, % | -6.16 | -4.6 | -0.03901982 | -15.77 | 10.76 | -3.16 | -3.16 | -3.16 | -3.16 | -3.16 |
| Depreciation | 41.3 | 73.8 | 105.0 | 261.0 | 352.0 | 237.7 | 313.3 | 412.9 | 544.1 | 717.0 |
| Depreciation, % | 1.05 | 1.32 | 0.81942 | 1.92 | 3.27 | 1.67 | 1.67 | 1.67 | 1.67 | 1.67 |
| EBIT | -284.0 | -330.9 | -110.0 | -2,407.0 | 807.0 | -686.8 | -905.1 | -1,192.8 | -1,571.9 | -2,071.5 |
| EBIT, % | -7.21 | -5.92 | -0.85844 | -17.69 | 7.49 | -4.84 | -4.84 | -4.84 | -4.84 | -4.84 |
| Total Cash | 76.0 | 300.8 | 403.0 | 434.0 | 896.0 | 623.6 | 821.9 | 1,083.1 | 1,427.3 | 1,881.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 39.9 | 78.6 | 206.0 | 253.0 | 266.0 | 237.2 | 312.6 | 411.9 | 542.9 | 715.4 |
| Account Receivables, % | 1.01 | 1.41 | 1.61 | 1.86 | 2.47 | 1.67 | 1.67 | 1.67 | 1.67 | 1.67 |
| Inventories | 762.7 | 1,036.2 | 3,149.0 | 1,876.0 | 1,150.0 | 2,468.4 | 3,252.9 | 4,286.8 | 5,649.3 | 7,444.9 |
| Inventories, % | 19.36 | 18.55 | 24.57 | 13.79 | 10.68 | 17.39 | 17.39 | 17.39 | 17.39 | 17.39 |
| Accounts Payable | 54.0 | 67.0 | 141.0 | 216.0 | 231.0 | 210.2 | 277.0 | 365.0 | 481.0 | 633.9 |
| Accounts Payable, % | 1.37 | 1.2 | 1.1 | 1.59 | 2.14 | 1.48 | 1.48 | 1.48 | 1.48 | 1.48 |
| Capital Expenditure | -230.5 | -360.0 | -557.0 | -512.0 | -87.0 | -602.2 | -793.6 | -1,045.9 | -1,378.3 | -1,816.4 |
| Capital Expenditure, % | -5.85 | -6.44 | -4.35 | -3.76 | -0.80772 | -4.24 | -4.24 | -4.24 | -4.24 | -4.24 |
| Tax Rate, % | -157.14 | -157.14 | -157.14 | -157.14 | -157.14 | -157.14 | -157.14 | -157.14 | -157.14 | -157.14 |
| EBITAT | -149.2 | -330.8 | -110.4 | -2,407.8 | 2,075.1 | -621.5 | -819.1 | -1,079.4 | -1,422.5 | -1,874.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,087.0 | -916.2 | -2,728.6 | -1,357.8 | 3,068.1 | -2,296.4 | -2,092.5 | -2,757.6 | -3,634.1 | -4,789.1 |
| WACC, % | 18.32 | 18.92 | 18.92 | 18.92 | 18.92 | 18.8 | 18.8 | 18.8 | 18.8 | 18.8 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -8,908.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -4,885 | |||||||||
| Terminal Value | -29,073 | |||||||||
| Present Terminal Value | -12,285 | |||||||||
| Enterprise Value | -21,193 | |||||||||
| Net Debt | 6,176 | |||||||||
| Equity Value | -27,369 | |||||||||
| Diluted Shares Outstanding, MM | 201 | |||||||||
| Equity Value Per Share | -136.45 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real Carvana Co. (CVNA) financials.
- Real-World Data: Historical data and forward-looking estimates (as highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the impact of your inputs on Carvana's valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Carvana Co. (CVNA).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs for precise calculations.
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to fit Carvana’s financial outlook.
- Integrated Financial Ratios: Assess profitability, leverage, and efficiency ratios specific to Carvana Co. (CVNA).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Carvana Co. (CVNA) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Carvana Co.'s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Carvana Co. (CVNA)?
- Accurate Data: Up-to-date Carvana financials provide trustworthy valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Ready-made calculations save you from having to start from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants focused on the automotive industry.
- User-Friendly: Easy-to-navigate design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Carvana Co. (CVNA) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Carvana Co. (CVNA).
- Consultants: Deliver professional valuation insights about Carvana Co. (CVNA) to clients quickly and accurately.
- Business Owners: Understand how companies like Carvana Co. (CVNA) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Carvana Co. (CVNA).
What the Template Contains
- Pre-Filled Data: Includes Carvana Co.’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Carvana Co.’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.