|
Valoración de DCF de EventBrite, Inc. (EB)
US | Technology | Software - Application | 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
Eventbrite, Inc. (EB) Bundle
¡Descubra el verdadero potencial de EventBrite, Inc. (EB) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y examine cómo los cambios influyen en la valoración de Eventbrite, Inc. (EB), todo dentro de una plantilla de Excel integral.
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 | 326.8 | 106.0 | 187.1 | 260.9 | 326.1 | 386.0 | 456.8 | 540.6 | 639.8 | 757.2 |
Revenue Growth, % | 0 | -67.56 | 76.53 | 39.43 | 24.99 | 18.35 | 18.35 | 18.35 | 18.35 | 18.35 |
EBITDA | -41.6 | -177.6 | -99.9 | -27.9 | 1.4 | -136.1 | -161.1 | -190.7 | -225.7 | -267.1 |
EBITDA, % | -12.74 | -167.54 | -53.36 | -10.71 | 0.44062 | -35.27 | -35.27 | -35.27 | -35.27 | -35.27 |
Depreciation | 35.2 | 31.2 | 21.5 | 16.0 | 14.7 | 48.1 | 57.0 | 67.4 | 79.8 | 94.4 |
Depreciation, % | 10.77 | 29.4 | 11.51 | 6.15 | 4.52 | 12.47 | 12.47 | 12.47 | 12.47 | 12.47 |
EBIT | -76.8 | -208.8 | -121.4 | -44.0 | -13.3 | -161.6 | -191.2 | -226.3 | -267.8 | -317.0 |
EBIT, % | -23.51 | -196.94 | -64.87 | -16.86 | -4.08 | -41.86 | -41.86 | -41.86 | -41.86 | -41.86 |
Total Cash | 420.7 | 505.8 | 634.4 | 623.5 | 642.9 | 386.0 | 456.8 | 540.6 | 639.8 | 757.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 34.8 | 10.8 | 3.2 | 3.6 | 6.3 | 19.9 | 23.6 | 27.9 | 33.0 | 39.1 |
Account Receivables, % | 10.65 | 10.16 | 1.69 | 1.39 | 1.92 | 5.16 | 5.16 | 5.16 | 5.16 | 5.16 |
Inventories | 36.4 | 16.5 | 18.7 | .7 | .0 | 28.5 | 33.8 | 40.0 | 47.3 | 56.0 |
Inventories, % | 11.15 | 15.52 | 10.01 | 0.27632 | 0 | 7.39 | 7.39 | 7.39 | 7.39 | 7.39 |
Accounts Payable | 309.7 | 193.0 | 286.3 | 310.3 | 305.3 | 377.0 | 446.2 | 528.0 | 624.9 | 739.6 |
Accounts Payable, % | 94.78 | 182.1 | 152.99 | 118.94 | 93.6 | 97.68 | 97.68 | 97.68 | 97.68 | 97.68 |
Capital Expenditure | -13.6 | -6.3 | -2.5 | -4.5 | -7.2 | -11.8 | -14.0 | -16.6 | -19.6 | -23.2 |
Capital Expenditure, % | -4.16 | -5.93 | -1.35 | -1.71 | -2.2 | -3.07 | -3.07 | -3.07 | -3.07 | -3.07 |
Tax Rate, % | -8.13 | -8.13 | -8.13 | -8.13 | -8.13 | -8.13 | -8.13 | -8.13 | -8.13 | -8.13 |
EBITAT | -76.6 | -208.7 | -122.6 | -44.1 | -14.4 | -161.5 | -191.1 | -226.2 | -267.7 | -316.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 183.5 | -256.5 | -5.1 | 9.1 | -13.8 | -95.7 | -87.9 | -104.0 | -123.1 | -145.7 |
WACC, % | 9.68 | 9.68 | 9.68 | 9.68 | 9.68 | 9.68 | 9.68 | 9.68 | 9.68 | 9.68 |
PV UFCF | ||||||||||
SUM PV UFCF | -415.9 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | -152 | |||||||||
Terminal Value | -2,667 | |||||||||
Present Terminal Value | -1,681 | |||||||||
Enterprise Value | -2,096 | |||||||||
Net Debt | -128 | |||||||||
Equity Value | -1,968 | |||||||||
Diluted Shares Outstanding, MM | 100 | |||||||||
Equity Value Per Share | -19.62 |
What You Will Get
- Pre-Filled Financial Model: Eventbrite’s actual data allows for accurate DCF valuation.
- Full Forecast Control: Modify ticket sales growth, margins, WACC, and other essential drivers.
- Instant Calculations: Automatic updates provide immediate results as you make adjustments.
- Investor-Ready Template: A polished Excel file crafted for professional-level valuation.
- Customizable and Reusable: Designed for versatility, enabling repeated use for comprehensive forecasts.
Key Features
- Comprehensive Event Data: Gain access to detailed historical performance metrics and future event projections.
- Adjustable Revenue Assumptions: Modify highlighted fields for ticket pricing, growth rates, and market trends.
- Automated Analytics: Instant updates to revenue forecasts, profitability analysis, and customer engagement metrics.
- User-Friendly Interface: Intuitive dashboards and visualizations to easily interpret your event performance insights.
- Suitable for All Skill Levels: Designed for event planners, marketers, and analysts, providing a straightforward and accessible format.
How It Works
- Download: Get the ready-to-use Excel file featuring Eventbrite, Inc.'s (EB) financial data.
- Customize: Modify forecasts, including ticket sales growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop multiple projections and instantly compare the results.
- Make Decisions: Utilize the valuation outcomes to inform your investment strategy.
Why Choose This Calculator?
- Designed for Professionals: A sophisticated tool utilized by event planners, analysts, and financial consultants.
- Comprehensive Data: Eventbrite’s historical and projected financials preloaded for precise analysis.
- Scenario Analysis: Effortlessly simulate various event outcomes and financial assumptions.
- Transparent Results: Automatically calculates intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance to assist you throughout the calculation process.
Who Should Use This Product?
- Event Organizers: Assess Eventbrite’s market position before planning events.
- Financial Analysts: Optimize evaluation methods and validate revenue forecasts.
- Entrepreneurs: Understand how leading event management companies like Eventbrite are valued.
- Consultants: Create detailed valuation reports for clients in the events industry.
- Students and Educators: Utilize current data to learn and teach valuation strategies.
What the Template Contains
- Pre-Filled Data: Includes Eventbrite’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 Eventbrite’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.