|
GameStop Corp. (GME) DCF Valuation
US | Consumer Cyclical | Specialty Retail | NYSE
|
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
GameStop Corp. (GME) Bundle
Explore GameStop Corp.'s (GME) financial future with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and costs to calculate GameStop Corp.'s (GME) intrinsic value and refine your investment strategy.
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 | 6,466.0 | 5,089.8 | 6,010.7 | 5,927.2 | 5,272.8 | 5,066.9 | 4,869.0 | 4,678.9 | 4,496.2 | 4,320.6 |
| Revenue Growth, % | 0 | -21.28 | 18.09 | -1.39 | -11.04 | -3.91 | -3.91 | -3.91 | -3.91 | -3.91 |
| EBITDA | -292.1 | -214.6 | -291.3 | -240.4 | 24.5 | -174.0 | -167.2 | -160.7 | -154.4 | -148.4 |
| EBITDA, % | -4.52 | -4.22 | -4.85 | -4.06 | 0.46465 | -3.43 | -3.43 | -3.43 | -3.43 | -3.43 |
| Depreciation | 96.2 | 80.8 | 77.2 | 61.7 | 56.2 | 65.5 | 63.0 | 60.5 | 58.1 | 55.9 |
| Depreciation, % | 1.49 | 1.59 | 1.28 | 1.04 | 1.07 | 1.29 | 1.29 | 1.29 | 1.29 | 1.29 |
| EBIT | -388.3 | -295.4 | -368.5 | -302.1 | -31.7 | -239.5 | -230.2 | -221.2 | -212.6 | -204.3 |
| EBIT, % | -6.01 | -5.8 | -6.13 | -5.1 | -0.6012 | -4.73 | -4.73 | -4.73 | -4.73 | -4.73 |
| Total Cash | 499.4 | 508.5 | 1,271.4 | 1,390.6 | 1,199.3 | 862.1 | 828.4 | 796.1 | 765.0 | 735.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 141.9 | 105.3 | 141.1 | 153.9 | 91.0 | 110.8 | 106.5 | 102.3 | 98.3 | 94.5 |
| Account Receivables, % | 2.19 | 2.07 | 2.35 | 2.6 | 1.73 | 2.19 | 2.19 | 2.19 | 2.19 | 2.19 |
| Inventories | 859.7 | 602.5 | 915.0 | 682.9 | 632.5 | 647.3 | 622.0 | 597.7 | 574.4 | 551.9 |
| Inventories, % | 13.3 | 11.84 | 15.22 | 11.52 | 12 | 12.77 | 12.77 | 12.77 | 12.77 | 12.77 |
| Accounts Payable | 380.8 | 341.8 | 471.0 | 531.3 | 324.0 | 360.2 | 346.2 | 332.7 | 319.7 | 307.2 |
| Accounts Payable, % | 5.89 | 6.72 | 7.84 | 8.96 | 6.14 | 7.11 | 7.11 | 7.11 | 7.11 | 7.11 |
| Capital Expenditure | -78.5 | -60.0 | -62.0 | -55.9 | -34.9 | -51.0 | -49.0 | -47.1 | -45.2 | -43.5 |
| Capital Expenditure, % | -1.21 | -1.18 | -1.03 | -0.94311 | -0.66189 | -1.01 | -1.01 | -1.01 | -1.01 | -1.01 |
| Tax Rate, % | 48.85 | 48.85 | 48.85 | 48.85 | 48.85 | 48.85 | 48.85 | 48.85 | 48.85 | 48.85 |
| EBITAT | -428.4 | -234.9 | -355.4 | -313.1 | -16.2 | -204.6 | -196.6 | -188.9 | -181.6 | -174.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,031.5 | 40.7 | -559.3 | -27.7 | -88.9 | -188.4 | -167.1 | -160.6 | -154.3 | -148.3 |
| WACC, % | 5.34 | 5.29 | 5.33 | 5.34 | 5.21 | 5.3 | 5.3 | 5.3 | 5.3 | 5.3 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -707.1 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | -153 | |||||||||
| Terminal Value | -6,634 | |||||||||
| Present Terminal Value | -5,124 | |||||||||
| Enterprise Value | -5,831 | |||||||||
| Net Debt | -319 | |||||||||
| Equity Value | -5,512 | |||||||||
| Diluted Shares Outstanding, MM | 305 | |||||||||
| Equity Value Per Share | -18.06 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real GME financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the highlighted cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effects of your inputs on GameStop's valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive DCF Calculator: Offers in-depth unlevered and levered DCF valuation models tailored for GameStop Corp. (GME).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to the gaming industry.
- Customizable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates to fit GameStop's market dynamics.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to GameStop Corp. (GME).
- Interactive Dashboard and Charts: Visual representations highlight key valuation metrics for straightforward analysis.
How It Works
- Download the Template: Gain immediate access to the Excel-based GME DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates GameStop’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to see how they affect the valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator?
- Accurate Data: Real GameStop Corp. (GME) financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to align with your projections.
- Time-Saving: Pre-built calculations streamline the process, eliminating the need to start from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the gaming industry.
- User-Friendly: Intuitive design and clear step-by-step instructions make it accessible for all users.
Who Should Use GameStop Corp. (GME)?
- Investors: Make informed investment choices with insights into the gaming retail market.
- Financial Analysts: Utilize detailed financial reports to enhance your analysis of GME's performance.
- Consultants: Tailor your strategies and recommendations based on GameStop's unique market position.
- Gaming Enthusiasts: Stay updated on trends and developments that impact GameStop's business model.
- Educators and Students: Explore case studies and discussions surrounding GameStop's role in the retail sector.
What the Template Contains
- Pre-Filled DCF Model: GameStop Corp.’s (GME) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate GameStop Corp.’s (GME) 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.