Full House Resorts, Inc. (FLL) DCF Valuation
- ✓ 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
Full House Resorts, Inc. (FLL) Bundle
Gain insight into your Full House Resorts, Inc. (FLL) valuation analysis using our cutting-edge DCF Calculator! This Excel template comes preloaded with real (FLL) data, enabling you to adjust forecasts and assumptions to accurately determine the intrinsic value of Full House Resorts, Inc.
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 | 165.4 | 125.6 | 180.2 | 163.3 | 241.1 | 275.8 | 315.5 | 361.0 | 413.0 | 472.5 |
| Revenue Growth, % | 0 | -24.08 | 43.45 | -9.37 | 47.64 | 14.41 | 14.41 | 14.41 | 14.41 | 14.41 |
| EBITDA | 14.6 | 18.8 | 45.4 | 20.7 | 29.9 | 40.9 | 46.8 | 53.5 | 61.2 | 70.0 |
| EBITDA, % | 8.8 | 14.99 | 25.23 | 12.65 | 12.42 | 14.82 | 14.82 | 14.82 | 14.82 | 14.82 |
| Depreciation | 8.3 | 7.7 | 7.2 | 11.3 | 31.1 | 19.3 | 22.1 | 25.3 | 28.9 | 33.1 |
| Depreciation, % | 5.04 | 6.1 | 4.01 | 6.94 | 12.9 | 7 | 7 | 7 | 7 | 7 |
| EBIT | 6.2 | 11.2 | 38.2 | 9.3 | -1.2 | 21.6 | 24.7 | 28.2 | 32.3 | 37.0 |
| EBIT, % | 3.76 | 8.89 | 21.22 | 5.71 | -0.47913 | 7.82 | 7.82 | 7.82 | 7.82 | 7.82 |
| Total Cash | 28.9 | 37.7 | 88.7 | 56.6 | 36.2 | 80.7 | 92.4 | 105.7 | 120.9 | 138.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2.2 | 4.9 | 4.7 | 4.1 | 5.3 | 6.9 | 7.9 | 9.1 | 10.4 | 11.9 |
| Account Receivables, % | 1.33 | 3.9 | 2.6 | 2.5 | 2.21 | 2.51 | 2.51 | 2.51 | 2.51 | 2.51 |
| Inventories | 2.3 | 1.5 | 1.7 | 1.5 | 1.8 | 2.9 | 3.3 | 3.7 | 4.3 | 4.9 |
| Inventories, % | 1.39 | 1.2 | 0.92141 | 0.9058 | 0.76288 | 1.04 | 1.04 | 1.04 | 1.04 | 1.04 |
| Accounts Payable | 5.2 | 4.2 | 8.4 | 4.6 | 12.8 | 10.6 | 12.2 | 13.9 | 15.9 | 18.2 |
| Accounts Payable, % | 3.15 | 3.34 | 4.67 | 2.82 | 5.31 | 3.86 | 3.86 | 3.86 | 3.86 | 3.86 |
| Capital Expenditure | -8.1 | -2.6 | -37.0 | -170.9 | -199.1 | -115.9 | -132.6 | -151.7 | -173.6 | -198.6 |
| Capital Expenditure, % | -4.89 | -2.1 | -20.53 | -104.69 | -82.6 | -42.02 | -42.02 | -42.02 | -42.02 | -42.02 |
| Tax Rate, % | -4.84 | -4.84 | -4.84 | -4.84 | -4.84 | -4.84 | -4.84 | -4.84 | -4.84 | -4.84 |
| EBITAT | 6.3 | 29.8 | 36.9 | 9.3 | -1.2 | 21.4 | 24.5 | 28.0 | 32.1 | 36.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 7.3 | 31.9 | 11.4 | -153.3 | -162.6 | -80.0 | -85.9 | -98.3 | -112.5 | -128.7 |
| WACC, % | 6.99 | 6.99 | 6.85 | 6.98 | 6.99 | 6.96 | 6.96 | 6.96 | 6.96 | 6.96 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -408.0 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | -134 | |||||||||
| Terminal Value | -4,518 | |||||||||
| Present Terminal Value | -3,227 | |||||||||
| Enterprise Value | -3,635 | |||||||||
| Net Debt | 479 | |||||||||
| Equity Value | -4,114 | |||||||||
| Diluted Shares Outstanding, MM | 35 | |||||||||
| Equity Value Per Share | -119.16 |
What You Will Receive
- Pre-Filled Financial Model: Full House Resorts, Inc.’s (FLL) actual data facilitates accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates provide instant results as you adjust inputs.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
- Flexible and Reusable: Designed for adaptability, allowing for repeated use in detailed projections.
Key Features
- Real-Life FLL Data: Pre-filled with Full House Resorts' historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based FLL DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically refreshes Full House Resorts' intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation fluctuations.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose Full House Resorts, Inc. (FLL) Calculator?
- Save Time: Skip the hassle of building a financial model from the ground up – it’s immediately available.
- Enhance Accuracy: Dependable financial metrics and calculations minimize valuation mistakes.
- Completely Customizable: Adjust the model to align with your unique assumptions and forecasts.
- User-Friendly: Intuitive graphs and outputs simplify the analysis of results.
- Endorsed by Industry Professionals: Crafted for experts who prioritize precision and functionality.
Who Should Use This Product?
- Casino Management Students: Understand operational strategies and apply them using real-world data from Full House Resorts, Inc. (FLL).
- Researchers: Integrate industry-specific models into academic studies or publications.
- Investors: Evaluate your investment hypotheses and assess the financial performance of Full House Resorts, Inc. (FLL).
- Market Analysts: Enhance your analysis with a tailored, ready-to-use financial model for Full House Resorts, Inc. (FLL).
- Entrepreneurs: Discover how established gaming companies like Full House Resorts, Inc. (FLL) are evaluated in the market.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations specific to Full House Resorts, Inc. (FLL).
- Real-World Data: Full House Resorts, Inc. (FLL)’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios for Full House Resorts, Inc. (FLL).
- Financial Statements: Complete annual and quarterly breakdowns for deeper insights into Full House Resorts, Inc. (FLL).
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage tailored to Full House Resorts, Inc. (FLL).
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results related to Full House Resorts, Inc. (FLL).