Esports Entertainment Group, Inc. (GMBL) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Esports Entertainment Group, Inc. (GMBL) Bundle
Looking to determine the intrinsic value of Esports Entertainment Group, Inc.? Our (GMBL) DCF Calculator integrates real-world data with extensive customization options, allowing you to refine your forecasts and make more informed investment choices.
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 | .0 | .0 | 16.8 | 58.4 | 23.0 | 25.2 | 27.7 | 30.4 | 33.4 | 36.7 |
| Revenue Growth, % | 0 | 0 | 0 | 247.66 | -60.64 | 9.84 | 9.84 | 9.84 | 9.84 | 9.84 |
| EBITDA | -3.0 | -4.0 | -18.7 | -43.4 | -23.3 | -3.8 | -4.1 | -4.5 | -5.0 | -5.5 |
| EBITDA, % | 100 | 100 | -111.48 | -74.46 | -101.36 | -14.89 | -14.89 | -14.89 | -14.89 | -14.89 |
| Depreciation | .3 | .0 | 3.6 | 12.4 | 6.5 | 13.7 | 15.0 | 16.5 | 18.1 | 19.9 |
| Depreciation, % | 100 | 100 | 21.32 | 21.21 | 28.4 | 54.19 | 54.19 | 54.19 | 54.19 | 54.19 |
| EBIT | -3.3 | -4.0 | -22.3 | -55.8 | -29.8 | -4.8 | -5.3 | -5.8 | -6.4 | -7.0 |
| EBIT, % | 100 | 100 | -132.8 | -95.67 | -129.76 | -19.13 | -19.13 | -19.13 | -19.13 | -19.13 |
| Total Cash | .0 | 12.4 | 19.9 | 2.5 | 1.7 | 15.7 | 17.3 | 19.0 | 20.9 | 22.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | 3.1 | 3.2 | 1.4 | 11.6 | 12.8 | 14.0 | 15.4 | 16.9 |
| Account Receivables, % | 100 | 100 | 18.38 | 5.56 | 6.2 | 46.03 | 46.03 | 46.03 | 46.03 | 46.03 |
| Inventories | .0 | .0 | -2.3 | 3.5 | .0 | 9.7 | 10.7 | 11.7 | 12.9 | 14.1 |
| Inventories, % | 100 | 100 | -13.64 | 6.01 | 0 | 38.47 | 38.47 | 38.47 | 38.47 | 38.47 |
| Accounts Payable | .6 | .5 | 2.6 | 5.1 | 4.5 | 12.3 | 13.5 | 14.8 | 16.3 | 17.9 |
| Accounts Payable, % | 100 | 100 | 15.55 | 8.69 | 19.46 | 48.74 | 48.74 | 48.74 | 48.74 | 48.74 |
| Capital Expenditure | .0 | .0 | -.1 | -.1 | .0 | .0 | .0 | .0 | .0 | .0 |
| Capital Expenditure, % | 100 | 100 | -0.3717 | -0.23603 | -0.01446063 | -0.12444 | -0.12444 | -0.12444 | -0.12444 | -0.12444 |
| Tax Rate, % | -0.00116462 | -0.00116462 | -0.00116462 | -0.00116462 | -0.00116462 | -0.00116462 | -0.00116462 | -0.00116462 | -0.00116462 | -0.00116462 |
| EBITAT | -3.3 | -4.1 | -19.5 | -52.9 | -29.8 | -4.7 | -5.1 | -5.6 | -6.2 | -6.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -2.4 | -4.1 | -14.6 | -44.1 | -18.6 | -3.1 | 9.0 | 9.9 | 10.8 | 11.9 |
| WACC, % | 2557.81 | 2557.81 | 2234.84 | 2423.31 | 2557.81 | 2466.31 | 2466.31 | 2466.31 | 2466.31 | 2466.31 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 12 | |||||||||
| Terminal Value | 0 | |||||||||
| Present Terminal Value | 0 | |||||||||
| Enterprise Value | 0 | |||||||||
| Net Debt | -2 | |||||||||
| Equity Value | 2 | |||||||||
| Diluted Shares Outstanding, MM | 0 | |||||||||
| Equity Value Per Share | 360.28 |
What You Will Get
- Real Esports Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Esports Entertainment Group, Inc. (GMBL).
- Full Customization: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates to fit your analysis needs.
- Instant Valuation Updates: Automatic recalculations to evaluate the impact of changes on GMBL’s fair value.
- Versatile Excel Template: Designed for quick modifications, scenario testing, and comprehensive projections.
- Time-Saving and Accurate: Avoid building models from the ground up while ensuring precision and adaptability.
Key Features
- 🔍 Real-Life GMBL Financials: Pre-filled historical and projected data for Esports Entertainment Group, Inc. (GMBL).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Esports Entertainment Group’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Esports Entertainment Group’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Template: Download and open the Excel file containing Esports Entertainment Group, Inc.'s (GMBL) preloaded data.
- 2. Adjust Key Inputs: Modify essential parameters such as growth projections, WACC, and capital expenditures.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Different Scenarios: Evaluate various forecasts to investigate a range of valuation possibilities.
- 5. Present with Assurance: Deliver expert valuation insights to back your strategic decisions.
Why Choose This Calculator for Esports Entertainment Group, Inc. (GMBL)?
- Accuracy: Up-to-date financial data ensures precise calculations.
- Flexibility: Users can easily adjust and test various input scenarios.
- Time-Saving: Eliminate the need to create a financial model from the ground up.
- Professional-Grade: Crafted with the expertise and standards expected at the CFO level.
- User-Friendly: Intuitive interface suitable for all users, regardless of financial modeling background.
Who Should Use This Product?
- Esports Enthusiasts: Stay updated on the latest trends and opportunities in the esports market.
- Investors: Make informed decisions about buying or selling Esports Entertainment Group, Inc. (GMBL) stock.
- Market Analysts: Utilize comprehensive data to analyze the growth potential of the esports industry.
- Gaming Professionals: Gain insights into how companies like Esports Entertainment Group, Inc. (GMBL) position themselves in the competitive landscape.
- Students of Business: Explore the dynamics of the esports sector through real-world case studies and financial analysis.
What the Template Contains
- Pre-Filled DCF Model: Esports Entertainment Group’s (GMBL) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Esports Entertainment Group’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.