|
ACV Auctions Inc. (ACVA) DCF Valuation
US | Consumer Cyclical | Auto - Dealerships | NASDAQ
|
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
ACV Auctions Inc. (ACVA) Bundle
Looking to determine the intrinsic value of ACV Auctions Inc.? Our ACVA DCF Calculator integrates real-world data with comprehensive customization features, allowing you to refine your forecasts and enhance your investment strategies.
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.