Discounted Cash Flow (DCF) Analysis Unlevered
GameStop Corp. (GME)
$ 191.24
1.10 0.58%
Operating Data
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected | 2028 Projected | 2029 Projected | 2030 Projected | 2031 Projected | 2032 Projected | 2033 Projected | 2034 Projected | 2035 Projected | 2036 Projected |
| Revenue | 8,547.10 | 8,285.30 | 6,466 | 5,089.80 | 4,304.19 | 3,639.84 | 3,078.03 | 2,602.94 | 2,201.18 | 1,861.43 | 1,574.12 | 1,331.15 | 1,125.69 | 951.94 | 805.01 | 680.76 | 575.68 | 486.83 | 411.68 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | |||||||||||||||||||
| EBITDA | 289 | -468.90 | -298.60 | -155.90 | -107.17 | -90.62 | -76.64 | -64.81 | -54.80 | -46.35 | -39.19 | -33.14 | -28.03 | -23.70 | -20.04 | -16.95 | -14.33 | -12.12 | -10.25 |
| EBITDA (%) | |||||||||||||||||||
| EBIT | 137.10 | -595.80 | -394.80 | -236.60 | -175.84 | -148.70 | -125.75 | -106.34 | -89.93 | -76.05 | -64.31 | -54.38 | -45.99 | -38.89 | -32.89 | -27.81 | -23.52 | -19.89 | -16.82 |
| EBIT (%) | |||||||||||||||||||
| Depreciation | 151.90 | 126.90 | 96.20 | 80.70 | 68.67 | 58.07 | 49.11 | 41.53 | 35.12 | 29.70 | 25.12 | 21.24 | 17.96 | 15.19 | 12.84 | 10.86 | 9.19 | 7.77 | 6.57 |
| Depreciation (%) |
Balance Sheet Data
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected | 2028 Projected | 2029 Projected | 2030 Projected | 2031 Actual | 2032 Projected | 2033 Projected | 2034 Projected | 2035 Projected | 2036 Projected |
| Total Cash | 854.20 | 1,624.40 | 499.40 | 508.50 | 509.12 | 430.54 | 364.08 | 307.89 | 260.37 | 220.18 | 186.19 | 157.46 | 133.15 | 112.60 | 95.22 | 80.52 | 68.09 | 57.58 | 48.70 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | |||||||||||||||||||
| Account Receivables | 138.60 | 134.20 | 141.90 | 105.30 | 80.75 | 68.29 | 57.75 | 48.84 | 41.30 | 34.92 | 29.53 | 24.97 | 21.12 | 17.86 | 15.10 | 12.77 | 10.80 | 9.13 | 7.72 |
| Account Receivables (%) | |||||||||||||||||||
| Inventories | 1,250.30 | 1,250.50 | 859.70 | 602.50 | 590.26 | 499.15 | 422.11 | 356.96 | 301.86 | 255.27 | 215.87 | 182.55 | 154.37 | 130.55 | 110.40 | 93.36 | 78.95 | 66.76 | 56.46 |
| Inventories (%) | |||||||||||||||||||
| Accounts Payable | 892.30 | 1,051.90 | 380.80 | 341.80 | 384.58 | 325.22 | 275.03 | 232.58 | 196.68 | 166.32 | 140.65 | 118.94 | 100.58 | 85.06 | 71.93 | 60.83 | 51.44 | 43.50 | 36.78 |
| Accounts Payable (%) | |||||||||||||||||||
| Capital Expenditure | -113.40 | -93.70 | -78 | -60 | -52.11 | -44.07 | -37.27 | -31.51 | -26.65 | -22.54 | -19.06 | -16.12 | -13.63 | -11.53 | -9.75 | -8.24 | -6.97 | -5.89 | -4.98 |
| Capital Expenditure (%) |
Weighted Average Cost Of Capital
| Share price | $ 191.24 |
|---|---|
| Beta | -2.072 |
| Diluted Shares Outstanding | 65 |
| Cost of Debt | |
| Tax Rate | 20.23 |
| After-tax Cost of Debt | 3.99% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | -14.029 |
| Total Debt | 921 |
| Total Equity | 12,430.60 |
| Total Capital | 13,351.60 |
| Debt Weighting | 6.90 |
| Equity Weighting | 93.10 |
| Wacc |
Build Up Free Cash
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected | 2028 Projected | 2029 Projected | 2030 Projected | 2031 Projected | 2032 Projected | 2033 Projected | 2034 Projected | 2035 Projected | 2036 Projected |
| Revenue | 8,547.10 | 8,285.30 | 6,466 | 5,089.80 | 4,304.19 | 3,639.84 | 3,078.03 | 2,602.94 | 2,201.18 | 1,861.43 | 1,574.12 | 1,331.15 | 1,125.69 | 951.94 | 805.01 | 680.76 | 575.68 | 486.83 | 411.68 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EBITDA | 289 | -468.90 | -298.60 | -155.90 | -107.17 | -90.62 | -76.64 | -64.81 | -54.80 | -46.35 | -39.19 | -33.14 | -28.03 | -23.70 | -20.04 | -16.95 | -14.33 | -12.12 | -10.25 |
| EBIT | 137.10 | -595.80 | -394.80 | -236.60 | -175.84 | -148.70 | -125.75 | -106.34 | -89.93 | -76.05 | -64.31 | -54.38 | -45.99 | -38.89 | -32.89 | -27.81 | -23.52 | -19.89 | -16.82 |
| Tax Rate | 90.96% | 10.64% | -10.33% | 20.23% | 27.87% | 27.87% | 27.87% | 27.87% | 27.87% | 27.87% | 27.87% | 27.87% | 27.87% | 27.87% | 27.87% | 27.87% | 27.87% | 27.87% | 27.87% |
| EBIAT | 12.39 | -532.43 | -435.59 | -188.74 | -126.83 | -107.25 | -90.70 | -76.70 | -64.86 | -54.85 | -46.38 | -39.22 | -33.17 | -28.05 | -23.72 | -20.06 | -16.96 | -14.34 | -12.13 |
| Depreciation | 151.90 | 126.90 | 96.20 | 80.70 | 68.67 | 58.07 | 49.11 | 41.53 | 35.12 | 29.70 | 25.12 | 21.24 | 17.96 | 15.19 | 12.84 | 10.86 | 9.19 | 7.77 | 6.57 |
| Accounts Receivable | - | 4.40 | -7.70 | 36.60 | 24.55 | 12.46 | 10.54 | 8.91 | 7.54 | 6.37 | 5.39 | 4.56 | 3.85 | 3.26 | 2.76 | 2.33 | 1.97 | 1.67 | 1.41 |
| Inventories | - | -0.20 | 390.80 | 257.20 | 12.24 | 91.11 | 77.04 | 65.15 | 55.10 | 46.59 | 39.40 | 33.32 | 28.18 | 23.83 | 20.15 | 17.04 | 14.41 | 12.19 | 10.30 |
| Accounts Payable | - | 159.60 | -671.10 | -39 | 42.78 | -59.36 | -50.20 | -42.45 | -35.90 | -30.36 | -25.67 | -21.71 | -18.36 | -15.52 | -13.13 | -11.10 | -9.39 | -7.94 | -6.71 |
| Capital Expenditure | -113.40 | -93.70 | -78 | -60 | -52.11 | -44.07 | -37.27 | -31.51 | -26.65 | -22.54 | -19.06 | -16.12 | -13.63 | -11.53 | -9.75 | -8.24 | -6.97 | -5.89 | -4.98 |
| UFCF | 50.89 | -335.43 | -705.39 | 86.76 | -30.69 | -49.03 | -41.47 | -35.07 | -29.65 | -25.08 | -21.21 | -17.93 | -15.16 | -12.82 | -10.84 | -9.17 | -7.76 | -6.56 | -5.55 |
| WACC | |||||||||||||||||||
| PV UFCF | -23.34 | -42.76 | -41.47 | -40.21 | -38.99 | -37.81 | -36.66 | -35.55 | -34.47 | -33.42 | -32.41 | -31.43 | -30.47 | -29.55 | -28.65 | ||||
| SUM PV UFCF | -58.52 |
Terminal Value
| Growth in perpetuity method: | |
|---|---|
| Long-term growth rate | |
| WACC (%) | -12.79 |
| Free cash flow (t + 1) | -5.77 |
| Terminal Value | 34.35 |
| Present Value of Terminal Value | 68.10 |
Intrinsic Value
| Enterprise Value | 9.58 |
|---|---|
| Net Debt | -799 |
| Equity Value | 808.58 |
| Shares Outstanding | 65 |
| Equity Value Per Share | 12.44 |