|ATVI.xlsx
|
MainModel
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ
1Main
2Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q422Q123Q223Q323Q42320152016201720182019202020212022202320242025202620272028202920302031
3Product675568423645386304231651.451975235023111572.45
4Subscription16001728164715171382134015511532.174514573664925805.17
5Revenue22752296207021621768164417822183.626489808688037377.62
6COGS578555527657479485502611.4136000000001209422602317
7Gross Profit16971741154315051289115912801572.2063999999998439558266486
8R&D353335329320346311277323.299811501337
9S&M237245244299252263287301.9992610641025
10G&A282189143174214250229175.74732784788
11OpEx872769716793812824793800.9300000000001265629983150
12OpInc825972827712477335487771.2763999999997173928283336
13Interest-30-43-6543-14171526-87-95
14Pretax795929762755463352502771.2763999999997176527413241
15Taxes14612612073704165115.69145999999995130419465
16Net Income649803642682393311437655.5849399999997163523222776
17EPS0.82886334610472551.02554278416347390.81992337164750960.86989795918367350.50.39467005076142130.55386565272496830.8309061343472747
18Shares783783783784786788789789771778783.25
19
20Revenue y/y-0.22285714285714286-0.28397212543554007-0.139130434782608670.0100000000000000090.246108799506857820.08867177838238938-0.16191980006815865
21Gross Margin0.7459340659340660.75827526132404180.74541062801932370.69611470860314530.72907239819004520.70498783454987830.71829405162738490.720.67730004623208510.7205045758100420.7367942746790866
22
23
24Model NI649803642393311437
25Reported NI619877639395280435
26CFFO844388521642198257
27CapEx221423153715
28FCF822374498627161242