|
Valoración de DCF de Gan Limited (GaN)
US | Consumer Cyclical | Gambling, Resorts & Casinos | 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
GAN Limited (GAN) Bundle
¡Descubra el verdadero valor de Gan Limited (GaN) con nuestra calculadora DCF avanzada! Ajuste los supuestos esenciales, explore varios escenarios y examine cómo las alteraciones afectan la valoración de GaN Limited (GaN), todo dentro de una plantilla de Excel conveniente.
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 | 30.0 | 35.2 | 125.4 | 141.5 | 129.4 | 168.8 | 220.1 | 286.9 | 374.2 | 487.9 |
Revenue Growth, % | 0 | 17.31 | 256.76 | 12.83 | -8.56 | 30.4 | 30.4 | 30.4 | 30.4 | 30.4 |
EBITDA | 6.9 | -16.2 | -10.9 | -7.6 | -13.2 | -15.9 | -20.8 | -27.1 | -35.4 | -46.1 |
EBITDA, % | 23.1 | -46.11 | -8.69 | -5.38 | -10.16 | -9.45 | -9.45 | -9.45 | -9.45 | -9.45 |
Depreciation | 4.3 | 3.3 | 16.8 | 23.3 | 17.2 | 22.5 | 29.4 | 38.3 | 50.0 | 65.2 |
Depreciation, % | 14.4 | 9.26 | 13.4 | 16.45 | 13.26 | 13.35 | 13.35 | 13.35 | 13.35 | 13.35 |
EBIT | 2.6 | -19.5 | -27.7 | -30.9 | -30.3 | -38.5 | -50.2 | -65.4 | -85.3 | -111.3 |
EBIT, % | 8.7 | -55.37 | -22.09 | -21.83 | -23.42 | -22.8 | -22.8 | -22.8 | -22.8 | -22.8 |
Total Cash | 10.1 | 152.7 | 39.5 | 45.9 | 38.6 | 76.8 | 100.1 | 130.5 | 170.2 | 221.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 5.0 | 8.1 | 8.1 | 13.8 | 11.4 | 21.8 | 28.4 | 37.1 | 48.3 | 63.0 |
Account Receivables, % | 16.63 | 22.91 | 6.47 | 9.76 | 8.82 | 12.92 | 12.92 | 12.92 | 12.92 | 12.92 |
Inventories | .9 | 1.9 | 3.5 | 4.9 | .0 | 4.9 | 6.4 | 8.4 | 10.9 | 14.3 |
Inventories, % | 2.95 | 5.44 | 2.79 | 3.43 | 0 | 2.92 | 2.92 | 2.92 | 2.92 | 2.92 |
Accounts Payable | 2.6 | 4.7 | 5.3 | 6.4 | 7.0 | 12.3 | 16.0 | 20.9 | 27.2 | 35.5 |
Accounts Payable, % | 8.83 | 13.39 | 4.2 | 4.55 | 5.39 | 7.27 | 7.27 | 7.27 | 7.27 | 7.27 |
Capital Expenditure | -2.9 | -5.9 | -14.0 | -19.1 | -6.8 | -19.1 | -24.8 | -32.4 | -42.2 | -55.1 |
Capital Expenditure, % | -9.73 | -16.83 | -11.12 | -13.5 | -5.27 | -11.29 | -11.29 | -11.29 | -11.29 | -11.29 |
Tax Rate, % | -0.40226 | -0.40226 | -0.40226 | -0.40226 | -0.40226 | -0.40226 | -0.40226 | -0.40226 | -0.40226 | -0.40226 |
EBITAT | 2.0 | -19.8 | -27.5 | -31.5 | -30.4 | -36.6 | -47.7 | -62.1 | -81.0 | -105.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | .2 | -24.5 | -25.7 | -33.2 | -12.3 | -43.1 | -47.5 | -62.0 | -80.8 | -105.3 |
WACC, % | 11.67 | 12.57 | 12.54 | 12.57 | 12.57 | 12.39 | 12.39 | 12.39 | 12.39 | 12.39 |
PV UFCF | ||||||||||
SUM PV UFCF | -229.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -107 | |||||||||
Terminal Value | -1,034 | |||||||||
Present Terminal Value | -577 | |||||||||
Enterprise Value | -806 | |||||||||
Net Debt | 8 | |||||||||
Equity Value | -814 | |||||||||
Diluted Shares Outstanding, MM | 44 | |||||||||
Equity Value Per Share | -18.42 |
What You Will Receive
- Comprehensive Financial Model: GAN Limited’s (GAN) actual data facilitates accurate DCF valuation.
- Complete Forecasting Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Real-Time Calculations: Automatic updates provide immediate insights as you adjust variables.
- Professional-Grade Template: An expertly crafted Excel file suitable for high-quality valuations.
- Flexible and Reusable: Designed for adaptability, enabling repeated applications for in-depth forecasts.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for GAN Limited (GAN).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with customizable parameters specific to GAN.
- Adjustable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to fit GAN's financial outlook.
- Integrated Financial Ratios: Assess profitability, leverage, and efficiency ratios relevant to GAN Limited (GAN).
- Interactive Dashboard and Charts: Visual representations summarize key valuation metrics for straightforward analysis of GAN.
How It Works
- Step 1: Download the prebuilt Excel template featuring GAN Limited’s (GAN) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including GAN Limited’s (GAN) intrinsic value.
- Step 5: Make well-informed investment choices or create reports based on the outputs.
Why Choose This Calculator for GAN Limited (GAN)?
- Accurate Data: Up-to-date GAN financials provide trustworthy valuation outcomes.
- Customizable: Tailor essential parameters like growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Built-in calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants alike.
- User-Friendly: Simple design and clear instructions make it accessible for all users.
Who Should Use GAN Limited (GAN)?
- Finance Students: Explore the intricacies of gaming and online betting markets using real data.
- Academics: Integrate advanced gaming models into your research or teaching materials.
- Investors: Evaluate your investment strategies and assess the performance of GAN Limited (GAN) in the market.
- Analysts: Enhance your analysis with a customizable financial model tailored for the gaming industry.
- Small Business Owners: Understand how leading gaming companies like GAN Limited (GAN) are evaluated and operated.
What the GAN Template Contains
- Operating and Balance Sheet Data: Pre-filled GAN Limited historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for GAN Limited (GAN).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.