|EA.xlsx
|
MainModel
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCVCWCXCYCZDADBDCDDDEDFDGDHDIDJDKDLDMDNDODPDQDRDSDTDUDVDWDXDYDZEAEBECEDEEEFEGEHEIEJEKELEMENEOEPEQERESETEUEVEWEXEYEZFAFBFCFDFEFFFGFHFIFJFKFLFMFNFOFPFQFRFSFTFU
1Main
26/30/20209/30/202012/31/20203/31/20216/30/20219/30/202112/31/20213/31/20226/30/20223/31/20163/31/20173/31/20183/31/20193/31/20203/31/20213/31/20223/31/2023
3FQ121FQ221FQ321FQ421FQ122FQ222FQ322FQ422FQ123FQ223FQ323FQ423FY2016FY2017FY2018FY2019FY2020FY2021FY2022FY2023FY2024FY2025FY2026FY2027FY2028FY2029FY2030FY2031FY2032FY2033
4Net Bookings910133618511299
5
6Console71497211981042377437164400
7PC249361377402103611951532
8Mobile1882182513237277181059
9
10Extra Content282630683910
11North America578778227024743039
12International5731048326731553952
13
14Download1632333372378119181282
15Packaged119892801041076695711
16Full Game282322617341188716131993
17Live Services869109612291209117313871426365040164998
18Revenue14591151167313461551182617891825176718501967.92007.50000000000024396484551504950553756296991780080348275.028523.27068778.9687189042.3377795400019313.6079129262029593.016150313988
19COGS288286601319315494631419314499.5531.3330000000001542.025000000000113541298127713221369149418592106
20Gross profit117186510721027123613321158140614531350.51436.5671465.4750000000001304235473873362841684135513256945904.996123.51486349.83659699999956584.22653856781.7533346550016985.2059346946527194.7621127354905
21R&D438421451468515553539579572558.53544.39584.7911091205132014331559177821862404.60000000000042428.6462452.932462477.46178462502.23640244600032527.258766470462552.53135413516472578.0566676765166
22M&S121156216196190233293245234235.33295.93247.456226736417026316899611057.10000000000011067.6711078.347711089.13118711100.0224989711111.022723960711122.13295120031721133.3542807123204
23G&A136133149174169176163165167177.76164.63166.65406439469460506592673740.3000000000001747.7030000000001755.1800300000001762.7318303000001770.3591486030001778.0627400890302785.8433674899205793.7018011648197
24OpEx695710816838874962995989973971.621004.9499999999999998.8921372317243025952696305938204202.0000000000014244.024286.46024329.3248024372.6180500200014416.34423052024460.5076728254034505.112749553657
25OpInc476155256189362370163417480378.88431.6170000000001466.585000000000159051230144310331472107613121491.9999999999991660.96999999999931837.05459999999952020.51179499999942211.60848847999932365.4091041348012524.6982618692492689.649363181834
26Interest-3-10-6-10-14-14-11-9-5-21-14158363-29-48-4815.59665600000000329.00918924843.9376995619839960.4532955184798678.629789790467798.18210094186985119.1651438443588
27Pretax473145250179348356152408475378.88431.6170000000001466.585000000000158841216145811161535104712641443.9999999999991676.56665599999931866.06378924799952064.44949456198362272.06178399847932444.0388939252692622.8803628111192808.8145070261926
28Taxes103-463489104322513112575.77686.3234000000000293.317000000000040243406600180292288.79999999999984335.3133311999999373.21275784959994412.88989891239675454.4123567996959488.8077787850538524.5760725622239561.7629014052385
29Net Income37019121690244324127277350303.104345.2936000000001373.268000000000148849731052105615358679721155.19999999999941341.25332479999951492.85103139839951651.55959564958681817.64942719878351955.2311151402152098.3042902488952247.0516056209542224.58108956474462202.3352786690972180.31192588240632158.5088066235822136.9237185573462115.55448137177252094.39893655805462073.45494719247432052.72039772054952032.1931937433442011.87126180591051991.75254918785141971.8350236959731952.1166734590131932.59550672442291913.26955165717871894.13685614060681875.19548757920071856.44353270340871837.87909737637461819.5003064026111801.30530333858471783.29225030519891765.45932780214681747.80473452412531730.3266871788841713.02342030709521695.89318610402421678.93425424298381662.14491170055381645.52346258354831629.06822795771271612.77754567813551596.64977022135421580.68327251914071564.87643979394921549.22767539600981533.73539864204961518.3980446556291503.21406420907281488.1819235669821473.30010433131221458.5671032879991443.9814322551191429.54161793256781415.2462017532421401.09373973570971387.08280233835261373.2119743149691359.47985457181931345.8850560261011332.426205465841319.10194341118151305.91092397706961292.85181473729881279.92329658992571267.12406362402631254.4528229877861241.90829475790821229.48921181032921217.1943196922261205.02237649530371192.97215273035071181.0424312030471169.23200689101651157.53968682210621145.9642899538851134.50464705434621123.15960058380281111.92800457796471100.8087245321851089.8006372868631078.90263091399451068.11360460485461057.4324685588061046.85814387321781036.38956243448571026.02566681014081015.76541014203941005.607756040619995.5516784802129985.5961616954107975.7402000784566965.982798077672956.3229700968952946.7597403959263937.292142991967927.9192215620474918.6400293464269909.4536290529626900.359092762433891.3555018348086882.4419468164605873.6175273482959864.8813520748129856.2325385540647847.670213168524839.1935110368388830.8015759264704822.4935601672057814.2686245655336806.1259383198783798.0646789366795790.0840321473127782.1831918258396774.3613599075811766.6177463085053758.9515688454202751.362053156966743.8484326253963736.4099482991423729.045848816151721.7553903279894714.5378364247096707.3924580604624700.3185334798578693.3153481450593686.3821946636086679.5183727169725672.7231889898028665.9959570999048659.3359975289058652.7426375536166646.2152111780805639.7530590662997633.3555284756367627.0219731908803620.7517534589715614.5442359243818608.398793565138602.3148056294866596.2916575731917590.3287409974598584.4254535874852578.5811990516104572.7953870610943567.0674331904834561.3967588585786555.7827912699928550.2249633572928544.72271372372539.2754865864828533.8827317206179528.5439044034117523.2584653593776518.0258807057838512.845621898726
30EPS1.26712328767123280.65187713310580210.73972602739726020.31034482758620690.84429065743944631.12891986062717780.44561403508771930.97879858657243811.24555160142348751.0786619217081851.22880284697508931.32835587188612152.67878787878787873.09872611464968143.3717948717948723.4509803921568635.2033898305084752.9691780821917813.39860139860139884.0391608391608374.6896969398601385.2197588510433555.7746839008726816.3554175776181246.83647243056019257.3367282875835497.856823795877461
31Shares292293292290289287285283281281281281330314312306295292286286286286286286286286286
32
33Revenue y/y0.063056888279643620.58644656820156380.06933652121936640.355869242199108540.139264990328820120.102138307552320340.06295149638802888-0.038834951456310660.118585858585858570.016615495755824440.241961271984366680.115720211700758080.0300000000000000270.0300000000000000270.0300000000000000270.0300000000000000270.0300000000000000270.0300000000000000270.030000000000000027
34Gross Margin0.79690522243713740.72946330777656080.64728898826159860.77041095890410960.82229767968307870.69199272065514110.73209494324045410.75203883495145630.73292929292929290.75275419902474260.73458873689820570.7340866828779860.730.7350.740.7450.750.750.750.75Terminal-0.01
35Operating Margin0.233397807865892980.202628696604600230.091112353269983240.22849315068493150.271646859083191860.205868971792538690.253869969040247670.280194174757281530.20868686868686870.265847932093191240.191152957896606860.18766986125017880.191282051282051170.20674259397560360.22200001933530060.237058271387042390.251921217573701730.26159265024217370.271076288101548930.2803757776529751Discount0.06
36ROIC0.01
37Net Cash18429511381184538841.1041186.39760000000021559.66560000000031559.66560000000032900.91892484393.7699561983996045.3295518479867862.9789790467699818.21009418698511916.51438443587914163.565990056833NPV30863.201228005775
38Cash37191972301630622416Share109.83345632742268
39AR5571031965650579Upside-0.17844673253479926
40OCA401387377439522
41PP&E510516522550545
42Goodwill51656539644163496275
43DT19602139213022432327
44Other422435479507528
45Assets1273413019139301380013192
46
47AP731368610170
48AL10931119144313881215
49DR13051322210120241548
50Debt18771877187818781878
51Taxes345386401387439
52Other313323404397401
53L+SE77287856761776257641
54SE1273413019139301380013192
55
56Model NI244324127277350
57Reported NI20429466225311
58D&A10594146141114
59SBC125149129125125
60AR12-4585631370
61OA-7423-24-82-15
62AP-1961-512-16
63AL-30252433-14-105
64DT28-1680-189-86
65DR-22217779-77-476
66CFFO-143641534444-7814651578169215471797193418991650
67
68CapEx-44-43-48-53-59-93-123-107-119-140-124-188
69Investments222537-420-6
70Acquisitions-1989-1405300
71CFFI-1811-911-49-33-65
72
73Buybacks-325-284-322-292-319
74Dividend-49-48-48-48-53
75ESOP-105-16-72-11-104
76CFFF-479-348-442-351-476
77FX11-13-32-31
78CIC-2422-1208104062-650
79
80FCF1372145515851428165718101711
810.060495626822157480.08934707903780059-0.09905362776025240.16036414565826340.09233554616777306-0.05469613259668504
820.0374869668152718