Dave & Buster's Entertainment, Inc. (PLAY) 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
Dave & Buster's Entertainment, Inc. (PLAY) Bundle
Designed for accuracy, our (PLAY) DCF Calculator enables you to evaluate Dave & Buster's Entertainment, Inc. valuation using real-world financial data, offering complete flexibility to modify all essential parameters for improved projections.
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 | 1,354.7 | 436.5 | 1,304.1 | 1,964.4 | 2,205.3 | 2,729.7 | 3,378.9 | 4,182.4 | 5,177.1 | 6,408.2 |
| Revenue Growth, % | 0 | -67.78 | 198.74 | 50.64 | 12.26 | 23.78 | 23.78 | 23.78 | 23.78 | 23.78 |
| EBITDA | 280.5 | -116.9 | 312.3 | 426.9 | 499.0 | 339.8 | 420.6 | 520.6 | 644.4 | 797.7 |
| EBITDA, % | 20.71 | -26.78 | 23.95 | 21.73 | 22.63 | 12.45 | 12.45 | 12.45 | 12.45 | 12.45 |
| Depreciation | 132.5 | 138.8 | 138.3 | 169.3 | 208.5 | 383.5 | 474.8 | 587.7 | 727.4 | 900.4 |
| Depreciation, % | 9.78 | 31.8 | 10.61 | 8.62 | 9.45 | 14.05 | 14.05 | 14.05 | 14.05 | 14.05 |
| EBIT | 148.1 | -255.7 | 174.0 | 257.6 | 290.5 | -43.7 | -54.2 | -67.0 | -83.0 | -102.7 |
| EBIT, % | 10.93 | -58.57 | 13.34 | 13.11 | 13.17 | -1.6 | -1.6 | -1.6 | -1.6 | -1.6 |
| Total Cash | 24.7 | 11.9 | 25.9 | 181.6 | 37.3 | 95.4 | 118.0 | 146.1 | 180.8 | 223.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | 70.1 | 64.9 | 25.5 | 44.8 | 133.0 | 164.6 | 203.8 | 252.2 | 312.2 |
| Account Receivables, % | 0 | 16.05 | 4.98 | 1.3 | 2.03 | 4.87 | 4.87 | 4.87 | 4.87 | 4.87 |
| Inventories | 34.5 | 23.8 | 40.3 | 45.4 | 37.2 | 82.4 | 102.0 | 126.2 | 156.2 | 193.4 |
| Inventories, % | 2.55 | 5.45 | 3.09 | 2.31 | 1.69 | 3.02 | 3.02 | 3.02 | 3.02 | 3.02 |
| Accounts Payable | 65.4 | 36.4 | 62.5 | 84.7 | 118.6 | 150.9 | 186.8 | 231.2 | 286.2 | 354.3 |
| Accounts Payable, % | 4.82 | 8.34 | 4.79 | 4.31 | 5.38 | 5.53 | 5.53 | 5.53 | 5.53 | 5.53 |
| Capital Expenditure | -228.1 | -83.0 | -92.2 | -234.2 | -330.2 | -381.2 | -471.8 | -584.0 | -722.9 | -894.9 |
| Capital Expenditure, % | -16.84 | -19.02 | -7.07 | -11.92 | -14.97 | -13.96 | -13.96 | -13.96 | -13.96 | -13.96 |
| Tax Rate, % | 22.19 | 22.19 | 22.19 | 22.19 | 22.19 | 22.19 | 22.19 | 22.19 | 22.19 | 22.19 |
| EBITAT | 116.8 | -182.2 | 148.2 | 203.3 | 226.0 | -34.3 | -42.5 | -52.6 | -65.1 | -80.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 52.0 | -214.8 | 209.0 | 194.9 | 127.2 | -133.0 | -54.9 | -67.9 | -84.1 | -104.1 |
| WACC, % | 6.82 | 6.58 | 7.01 | 6.82 | 6.78 | 6.8 | 6.8 | 6.8 | 6.8 | 6.8 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -367.9 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | -107 | |||||||||
| Terminal Value | -2,818 | |||||||||
| Present Terminal Value | -2,028 | |||||||||
| Enterprise Value | -2,396 | |||||||||
| Net Debt | 2,961 | |||||||||
| Equity Value | -5,357 | |||||||||
| Diluted Shares Outstanding, MM | 44 | |||||||||
| Equity Value Per Share | -121.56 |
What You Will Get
- Editable Forecast Inputs: Easily modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Dave & Buster's financial data pre-filled to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Pre-Loaded Data: Dave & Buster's historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Edit WACC, tax rates, revenue growth, and EBITDA margins.
- Instant Results: See Dave & Buster's intrinsic value recalculate in real time.
- Clear Visual Outputs: Dashboard charts display valuation results and key metrics.
- Built for Accuracy: A professional tool for analysts, investors, and finance experts.
How It Works
- Download the Template: Gain immediate access to the Excel-based Dave & Buster's (PLAY) DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other key factors.
- Instant Calculations: The model automatically refreshes Dave & Buster's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Dave & Buster's Entertainment, Inc. (PLAY)?
- Comprehensive Tool: Integrates DCF, WACC, and financial ratio analyses tailored for the entertainment sector.
- Customizable Inputs: Modify highlighted cells to explore different financial scenarios for Dave & Buster's.
- Detailed Insights: Automatically computes intrinsic value and Net Present Value specific to Dave & Buster's operations.
- Preloaded Data: Historical and projected data provide a reliable foundation for analysis.
- Professional Quality: Perfect for financial analysts, investors, and consultants focused on the entertainment industry.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for analyzing Dave & Buster's (PLAY) portfolio.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Dave & Buster's (PLAY) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Entertainment Industry Analysts: Gain insights into how entertainment companies like Dave & Buster's (PLAY) are valued in the market.
What the Template Contains
- Pre-Filled DCF Model: Dave & Buster's financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Dave & Buster'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.