|
ACV Auctions Inc. (ACVA) DCF Valoración
US | Consumer Cyclical | Auto - Dealerships | 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
ACV Auctions Inc. (ACVA) Bundle
¿Busca determinar el valor intrínseco de ACV Auctions Inc.? Nuestra calculadora ACVA DCF integra datos del mundo real con características integrales de personalización, lo que le permite refinar sus pronósticos y mejorar sus estrategias de inversión.
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 | 106.8 | 208.4 | 358.4 | 421.5 | 481.2 | 720.4 | 1,078.5 | 1,614.4 | 2,416.8 | 3,618.0 |
| Revenue Growth, % | 0 | 95.01 | 72.03 | 17.6 | 14.16 | 49.7 | 49.7 | 49.7 | 49.7 | 49.7 |
| EBITDA | -75.3 | -32.7 | -67.9 | -89.7 | -53.9 | -198.2 | -296.7 | -444.2 | -665.0 | -995.5 |
| EBITDA, % | -70.46 | -15.67 | -18.95 | -21.29 | -11.2 | -27.51 | -27.51 | -27.51 | -27.51 | -27.51 |
| Depreciation | 1.9 | 7.2 | 8.8 | 11.4 | 19.3 | 20.8 | 31.1 | 46.5 | 69.6 | 104.2 |
| Depreciation, % | 1.78 | 3.48 | 2.44 | 2.7 | 4.01 | 2.88 | 2.88 | 2.88 | 2.88 | 2.88 |
| EBIT | -77.2 | -39.9 | -76.7 | -101.1 | -73.2 | -219.0 | -327.8 | -490.7 | -734.6 | -1,099.7 |
| EBIT, % | -72.24 | -19.15 | -21.39 | -23.99 | -15.2 | -30.4 | -30.4 | -30.4 | -30.4 | -30.4 |
| Total Cash | 182.3 | 233.7 | 579.8 | 496.7 | 411.3 | 699.5 | 1,047.1 | 1,567.5 | 2,346.6 | 3,512.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 83.3 | 112.6 | 267.0 | 246.8 | 283.0 | 466.6 | 698.5 | 1,045.7 | 1,565.4 | 2,343.4 |
| Account Receivables, % | 77.94 | 54.06 | 74.5 | 58.54 | 58.82 | 64.77 | 64.77 | 64.77 | 64.77 | 64.77 |
| Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | 0 | 0.00000048 | 0.000000279 | 0 | 0 | 0.000000152 | 0.000000152 | 0.000000152 | 0.000000152 | 0.000000152 |
| Accounts Payable | 85.8 | 152.0 | 396.0 | 323.7 | 305.8 | 567.1 | 849.0 | 1,270.9 | 1,902.5 | 2,848.1 |
| Accounts Payable, % | 80.33 | 72.94 | 110.47 | 76.78 | 63.55 | 78.72 | 78.72 | 78.72 | 78.72 | 78.72 |
| Capital Expenditure | -6.6 | -8.9 | -14.0 | -23.4 | -28.2 | -37.1 | -55.5 | -83.2 | -124.5 | -186.3 |
| Capital Expenditure, % | -6.17 | -4.26 | -3.91 | -5.55 | -5.85 | -5.15 | -5.15 | -5.15 | -5.15 | -5.15 |
| Tax Rate, % | -0.70382 | -0.70382 | -0.70382 | -0.70382 | -0.70382 | -0.70382 | -0.70382 | -0.70382 | -0.70382 | -0.70382 |
| EBITAT | -77.2 | -40.4 | -77.4 | -101.2 | -73.7 | -219.0 | -327.8 | -490.7 | -734.6 | -1,099.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -79.4 | -5.2 | 6.9 | -165.3 | -136.6 | -157.6 | -302.3 | -452.6 | -677.5 | -1,014.3 |
| WACC, % | 11.68 | 11.68 | 11.68 | 11.68 | 11.68 | 11.68 | 11.68 | 11.68 | 11.68 | 11.68 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1,727.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -1,035 | |||||||||
| Terminal Value | -10,684 | |||||||||
| Present Terminal Value | -6,149 | |||||||||
| Enterprise Value | -7,877 | |||||||||
| Net Debt | -67 | |||||||||
| Equity Value | -7,810 | |||||||||
| Diluted Shares Outstanding, MM | 160 | |||||||||
| Equity Value Per Share | -48.83 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled financial data for ACV Auctions Inc. (ACVA).
- Actual Market Data: Historical performance metrics and forward-looking projections (highlighted in the yellow cells).
- Forecasting Options: Modify forecast assumptions such as revenue growth rates, EBITDA margins, and WACC.
- Instant Calculations: Quickly observe how your inputs affect the valuation of ACV Auctions Inc. (ACVA).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for easy navigation and clarity, complete with step-by-step guidance.
Key Features
- Customizable Auction Parameters: Adjust essential metrics such as bidding increments, reserve prices, and auction durations.
- Instant Auction Valuation: Provides real-time estimates of asset values and potential sale outcomes.
- Industry-Leading Precision: Leverages ACV Auctions' extensive market data for accurate valuation results.
- Effortless Scenario Testing: Easily explore various auction strategies and evaluate their impacts.
- Efficiency Booster: Streamline the auction process, eliminating the need for manual calculations and complex setups.
How It Works
- Download the Template: Gain immediate access to the Excel-based ACV Auctions Inc. DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other key metrics.
- Instant Calculations: The model automatically recalculates the intrinsic value of ACV Auctions Inc. (ACVA).
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment strategies or financial assessments.
Why Choose ACV Auctions Inc. (ACVA) Calculator?
- All-in-One Solution: Combines auction analytics, market trends, and valuation metrics seamlessly.
- Flexible Parameters: Modify highlighted fields to explore different auction scenarios.
- In-Depth Analysis: Automatically computes ACV Auctions’ market value and projected returns.
- Integrated Data: Access to historical auction results and future forecasts for precise evaluations.
- Expert-Level Features: Perfect for auctioneers, investors, and market analysts.
Who Should Use ACV Auctions Inc. (ACVA)?
- Automotive Dealers: Leverage data-driven insights to enhance vehicle auction strategies.
- Investors: Analyze market trends and performance metrics for informed investment decisions.
- Market Analysts: Evaluate auction dynamics to provide comprehensive reports on the automotive sector.
- Students and Educators: Explore real-time auction data for hands-on learning in business and finance.
- Tech Savvy Users: Gain an understanding of how innovative auction technologies are reshaping the automotive market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled ACV Auctions Inc. (ACVA) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models detailing intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for ACV Auctions Inc. (ACVA).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy result analysis.