|TWTR.xlsx
|
MainModel
ABCDEFGHIJKLMNOPQR
1Main
2Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q42220202021
3DAU190.9197.6204209.3214.7229237.8
4
5
6Revenue936.2331289.0411036.0181190.4271283.8171567.221200.9841176.663716.3495077.482
7COGS361.388432.924381.008416.932484.479515.091507.45540.6761366.3881797.51
8Gross Margin574.845856.117655.01773.4949999999999799.3381052.129693.5339999999999635.9842349.96100000000023279.9719999999998
9R&D208.877247.94250.709299.859324.252371.884371.695454.859873.0111246.704
10S&M215.285244.002234.592301.902301.078338.398299.809308.301887.861175.97
11G&A94.576112.251117.527141.482150.855174.472149.863216.586562.432584.336
12OpEx518.738604.193602.8280000000001743.2429999999999776.185884.754821.367979.7462323.3033007.01
13OpInc56.10699999999997251.9239999999999852.181999999999930.25199999999995323.15300000000002167.3749999999999-127.83300000000008-343.7619999999999426.658000000000357272.96199999999953
14Interest-22.446999999999996-27.064999999999998-2.184000000000001-4.691000000000001-5.159000000000001-3.4689999999999994-7.48200000000000131.211-126.21999999999998-15.503
15Pretax496.29100000000005577.1279999999999600.6440000000001738.551999999999917.99400000000002163.9059999999999-135.31500000000008-312.55099999999993-99.56199999999963257.45899999999955
16Taxes1.0241.903015.65102.9710000
17Net Income495.26700000000005575.2249999999999600.6440000000001722.90117.99400000000002160.9349999999999-135.31500000000008-312.55099999999993-99.56199999999963257.45899999999955
18EPS0.61418333471811780.7046148305666070.68866424287452130.83170459513564510.022549296039399260.18604557067384933-0.16136014023539522-0.40758466271189303-0.12637000689207820.3228030537643571
19Shares806.383816.368872.187869.18797.985865.03838.59766.837787.861797.573
20
21Revenue Growth0.37125800949122720.215803066000228140.15923082417486945-0.011564757855794472
22DAU Growth0.124672603457307350.15890688259109310.165686274509804
23Gross Margin0.66415032570725060.63223804991805150.64976264819262330.62262612194728680.67133459246308750.57747147339181860.5404993795998844