|GME.xlsx
|
MainModel
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECF
1Main
25/2/20208/1/202010/31/20201/30/20215/1/20217/31/202110/30/20211/29/20224/30/20227/31/202210/30/20221/29/20234/30/20237/31/202310/30/20231/29/20241/29/20131/29/20141/29/20151/29/20161/28/20172/3/20182/2/20192/1/20201/30/20211/29/20221/29/20231/29/20241/29/20251/29/20261/29/20271/29/20281/29/20291/29/20301/29/20311/29/2032
3Q119Q219Q319Q419Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q422Q123Q223Q323Q423FY2013FY2014FY2015FY2016FY2017FY2018FY2019FY2020FY2021FY2022FY2023FY2024FY2025FY2026FY2027FY2028FY2029FY2030FY2031FY2032
4Stores45737535
5US Stores5466
6
7United States966.3795.1995.3793.4
8Canada61.962.876.962.3
9Australia114.8131.1126.7113.9
10Europe133.8194.4179.5166.4
11
12New Hardware1791.81767.8
13New Software25822449.7
14Pre-owned2149.61866.3
15Accessories784.3956.5
16Digital189.2194
17Collectibles175.4220.9636.2707.5
18Other414343.5
19
20Hardware513.1441.6413.41162.7703.5609.6669.91188.7673.8596.46272530.83171.72854.5299999999997
21Software417386.5444.4731.2397.9396.6434.5785.9483.7316.4352.11979.12014.82075.244
22Collectibles90.9113.9146.9228.2175.4177.2192.2279.3220.9223.2207.3335.16265.08267.84248.76402.192636.2707.5737.5579.9824.2906.6200000000001997.28200000000031097.01020000000041206.71122000000061327.38234200000081460.1205762000011606.13263382000131766.74589720200151943.4204869222022137.762535614422
23Revenue10219421004.69999999999992122.11276.80000000000021183.41296.60000000000012253.91378.4113611862366.59500000000031447.32000000000021192.81245.32484.92475000000069039.592969363.88607.98547.0999999999998285.364665089.7999999999996010.76066.9950000000016673.6945000000017341.06395000000258075.1703450000038478.9288622500048902.8753053625049348.019070630639815.42002416216210306.1910253702710821.500576638784
24COGS738.6689.8728.41673.5946.7862.59781875.71079.9853.8894.81845.94410000000021128.9096000000002930.384971.3341938.24130500000056378.46520.16445.55598.66062.25977.24557.33830.34662.94671.5861500000015072.0078200000015579.20860200000156056.3777587500036359.1966466875046588.1277259682536917.5341122666667165.2566176383787523.51944852029657791.480415179924
25Gross Margin282.4252.20000000000005276.29999999999995448.5999999999999330.10000000000014320.9000000000001318.60000000000014378.20000000000005298.5282.20000000000005291.20000000000005520.6509000000001318.4104262.41599999999994273.966546.68344500000012661.10000000000042775.89999999999962918.29999999999933009.29999999999932484.89999999999872308.09999999999951908.69999999999981259.4999999999991347.80000000000021395.40884999999981601.68668000000071761.8553480000012018.79258625000062119.73221556250062314.74757939425132430.48495836396342650.1634065237842782.67157684997353030.0201614588595
26SG&A386.5348.2360.4419.1370.3378.9421.5538.9452.2387.5387.9538.9452.2387.5387.9538.91892.420012108.92252.61909.61994.21922.71514.21709.61692.5041675.57895999999981658.82317039999981642.23493869599971625.81258930903981674.58696698831111724.82457599796041776.56931327789931829.86639267623631884.7623844565235
27Operating Income-104.10000000000002-95.99999999999994-84.1000000000000229.499999999999886-40.199999999999875-57.999999999999886-102.89999999999986-160.69999999999993-153.7-105.29999999999995-96.69999999999993-18.249099999999885-133.7896-125.08400000000006-113.933999999999977.7834450000001425768.7000000000003774.8999999999996809.3999999999992756.6999999999994575.2999999999988313.8999999999994-14.000000000000227-254.70000000000095-361.7999999999997-297.0951500000001-73.89227999999912103.0321776000012376.5576475540008493.9196262534608640.1606124059401705.660382366003873.5940932458848952.80518417373721145.257777002336
28Interest Expense-6.7-7.5-9.7-8.2-24.7-0.5-0.8-0.9-0.70.33.73.73.73.73.73.7-4.7-10-23-53-55.3-51.1-27.2-32.1-26.920.55101815.02013535999999813.84269246720001516.1801898685440424.0349466169949433.3581289286631545.48146627268600657.49973585090502672.3972371164536787.77527343580653
29Pretax Income-110.80000000000003-103.49999999999994-93.8000000000000321.299999999999887-64.89999999999988-58.499999999999886-103.69999999999986-161.59999999999994-154.39999999999998-104.99999999999996-92.99999999999993-14.549099999999886-130.08960000000002-121.38400000000006-110.2339999999999711.483445000000142764.0000000000002764.8999999999996786.3999999999992703.6999999999994519.9999999999989262.7999999999994-41.20000000000023-286.800000000001-388.6999999999997-276.5441320000001-58.87214463999912116.87487006720121392.7378374225449517.9545728704558673.5187413346033751.141848638689931.09382909678981025.20242129019081233.0330504381427
30Taxes50.417.9-53.9-69.71.33.11.7-20.23.51.22.100000214.6215.2222.4151.5153.541.737.6-55.3-14.1000051.7954572870455867.35187413346033150.2283697277378186.21876581935797256.3006053225477308.2582626095357
31Net Income-161.20000000000002-121.39999999999995-39.9000000000000390.99999999999989-66.19999999999987-61.59999999999989-105.39999999999986-141.39999999999995-157.89999999999998-106.19999999999996-95.09999999999992-14.549099999999886-130.08960000000002-121.38400000000006-110.2339999999999711.483445000000142549.4000000000002549.6999999999996563.9999999999992552.1999999999994366.49999999999886221.0999999999994-78.80000000000024-231.50000000000097-374.5999999999997-276.5441320000001-58.87214463999912116.87487006720121392.7378374225449466.1591155834102606.166867201143600.9134789109512744.8750632774319768.9018159676432924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607924.774787828607
32EPS-2.4992248062015507-1.8676923076923069-0.61196319018404941.3421828908554556-1.0030303030303012-0.848484848484847-1.388669301712778-1.862977602108036-2.0803689064558624-0.34911242603550285-0.31262327416173546-0.04782741617356964-0.42764497041420124-0.39902695595003307-0.36237343852728460.037749654832347614.6402027027027044.85600706713780555.2858481724461035.3198458574181053.6108374384236342.1655239960822663-0.9005714285714314-3.5615384615384764-5.159779614325065-3.809147823691462-0.81091108319558031.60984669514051285.4096120857099856.42092445707176658.3494058843132658.2770451640626910.25998709748528810.5909341042375112.737944735931228
33Shares64.56565.267.86672.675.975.975.9304.2304.2304.2304.2304.2304.2304.2118.4113.2106.7103.8101.5102.187.56572.672.672.672.672.672.672.672.672.672.672.6
34
35Revenue y/y0.25053868756121480.256263269639065870.29053448790683810.062108288959050070.07957393483709274-0.04005408146019951-0.085300015424957690.0500000000000000440.0500000000000000440.0500000000000000440.0500000000000000440.0500000000000000440.0283754632446484580.007293459552495607-0.08072577372434264-0.007063279080844476-0.030630272256086832-0.2195816687386093-0.212836374884008750.18093048842783620.0093657976608383380.100000000000000090.100000000000000090.100000000000000090.0500000000000000440.0500000000000000440.0500000000000000440.0500000000000000440.0500000000000000440.050000000000000044
36Hardware y/y0.37107776261937240.380434782608695570.62046444121915820.022361744216048862-0.04221748400852887-0.021653543307086687-0.064039408866995-1-1-1-1#ERROR_#DIV/0!
37Software y/y-0.045803357314148750.02613195342820185-0.0222772277227721860.074808533916848940.21563206835888415-0.20221886031265768-0.18964326812428078-1-1-1-1#ERROR_#DIV/0!
38Collectibles y/y0.92959295929592960.5557506584723440.30837304288631720.22392638036809820.25940706955530210.25959367945823920.078563995837669150.199999999999999960.199999999999999960.199999999999999960.199999999999999960.199999999999999960.112071675573718780.042402826855123754-0.213694915254237340.42127953095361280.100000000000000090.100000000000000090.100000000000000090.100000000000000090.100000000000000090.100000000000000090.100000000000000090.100000000000000090.100000000000000090.10000000000000009
39Gross Margin0.27659157688540640.26772823779193210.275007464914899970.211394373497950120.25853696741854640.27116782153118140.245719574271170830.167798038954700750.21655542658154380.24841549295774650.245531197301855020.220000000000000030.219999999999999970.219999999999999950.220.220.29438575142430450.29861230636833040.31165766035156660.34959746279580380.29073018918697560.27857772198954770.295190225796473860.247455695705135620.224233450346881440.229999999999999930.240000000000000050.240000000000000050.249999999999999970.249999999999999940.260.259999999999999950.270.27000000000000010.28
40Operating Margin-0.10852105778648387-0.10987261146496809-0.093361202348959920.01003722727486918-0.05083020050125303-0.04943383471353716-0.07997840505938597-0.07169794578286523-0.11201392919326754-0.09242957746478869-0.07841483979763907-0.006147693204794181-0.08988309427079015-0.10176391683433943-0.08852003533285150.0046212445668626940.085037889263786750.083358433734939720.086439266109912570.08790761974465310.067309379789636120.0378863770774745-0.0021651716671822188-0.05004125898856556-0.06019265642936759-0.04896907777243925-0.0110721699951951810.0140350470043243760.0466315423038918750.0582525970293837560.07190492851453840.075487691780928110.089002211937481940.092449788852958490.1058316976367116
41Tax Rate-0.45487364620938614-0.17294685990338170.5746268656716417-3.2723004694835858-0.02003081664098617-0.052991452991453095-0.016393442622950840.12500000000000006-0.022668393782383424-0.011428571428571432-0.022580645161290342000000.28089005235602080.28134396653157290.28280773143438480.215290606792667540.295192307692308360.15867579908675838-0.91262135922329590.192817294281728750.0362747620272704200000.10.099999999999999990.20.20.250.25
42
43Cash770.80000000000011775.60000000000011468.11319.91083.6908.91042.11027.5509897.4612999999999776.0772999999999665.8433677.32674500000021319.91027.5509751.0067679999999692.1346233600008809.0094934272021201.7473308497471667.90644643315732274.07331363432874.98679254525133619.8618558226834388.7636717903265313.538459618933
44AR102.168.583.4141.1103.499.6125.3
45Inventory570.9596.41140.9915917.6734.81131.3
46Prepaids232.1235236.3238.2240.3275.9283.1
47PP&E192.6186.6179.6163.6157.4146.8138.5
48Lease654.2645.2615.8586.6568.7554.3523.2
49DT00016.316.716.714.3
50ONCA4038.537.9118.637.862.564.7
51Assets2562.73545.83762.00000000000053499.29999999999973125.52799.53322.5
52
53AP388.6409.7711.5471386.8217.4888.4
54AL561.8563.1608.5668.9533.3512.1504.2
55Lease664.4653.5211.9604.4574.8561.4535.8
56Debt48.147.546.19999999999999644.642.24138.7
57OLTL20.320429107.9137.7124.1110.4
58SE879.518521754.91602.51450.71343.51245
59L+SE2562.73545.837623499.33125.52799.53322.5
60
61Model NI-66.19999999999987-61.59999999999989-105.39999999999986-141.39999999999995-157.89999999999998-106.19999999999996-95.09999999999992366.49999999999886221.0999999999994-78.80000000000024-231.50000000000097-374.5999999999997-276.5441320000001-58.87214463999912116.87487006720121392.7378374225449466.1591155834102606.166867201143600.9134789109512744.8750632774319768.9018159676432924.774787828607
62Reported NI-66.8-61.60000000000001-105.39999999999999-149.5-157.9-108.734.7-673-470.9-215.3-381.3
63D&A18.717.59999999999999816.9000000000000124.00000000000000417.115.3151.9126.996.280.777.2Discount0.1
64Retirement of Debt18.200000000018.2Maturity0
65Impairments0.6006.10000000000000050000006.7ROIC0.02
66Inventory Reserves00000059.157.3000NPV6499.580106616196
67Goodwill000000395.11015.9385.615.50Price21.33961945000241
68SBC5.78.86.1999999999999989.811.17.825.610.78.97.930.5Upside-0.1518434240857548
69DT000-16.300-107.9-4.161.480.3-16.3
70Gain of sale0.40.0999999999999999804.9-6.90-6.4-100.81.9-27.30
71Digital asset impairments000033.72.500000
72Loss on PP&E001.900.41.28.529.105.4
73Other-0.5-0.09999999999999998-0.7999999999999998-2.1-4.8-0.2-34.2-36.24.10.9-3.5
74WC4.923.700000000000003-212.0000000000000912.200000000000093-196.60000000000002-21.299999999999976-91.49999999999999-73.6-510.79999999999984180.99999999999997-171.2
75CFFO-18.799999999999997-11.500000000000014-293.20000000000005-110.8999999999999-303.90000000000003-103.39999999999998434.9000000000001325.0999999999999-414.49999999999983123.69999999999996-434.300000000000070000000000
76
77CapEx-14.7-13.5-12.500000000000004-21.376.9-20.5113.493.778.56062
78Digital Asset Sale0000-10.80.4
79Other0-0.1-0.30000000000000004-2.400
80CFFI-14.7-13.6-12.800000000000004-23.766.10000000000001-20.1
81
82Issuance of Common551.71121.10000
83Debt-332.500-2.899999999999977300
84Stock Awards-49.9-86.699999999999990-0.20000000000002416-1.1-1.9
85CFFF169.300000000000041034.39999999999990-3.1000000000000014-1.1-1.9
86FX0-4.5-1-11.1000000000000012.6-1.2
87CIC135.800000000000071004.7999999999998-307.00000000000006-148.7999999999999-236.30000000000004-126.59999999999998
88
89FCF-33.5-25.000000000000014-305.70000000000005-132.1999999999999-227.00000000000003-123.89999999999998321.5000000000001231.39999999999992-492.9999999999998363.69999999999996-496.30000000000007
90
91Hardware163.1150
92Software590.3525.6
93Pre-owned977.1810.4
94Accessories255312.5
95Digital162.4171.6
96Collectibles208.2233.3
97Other128.8104.7
98Gross Profit2484.92308.1