|SNAP.xlsx
|
MainModel
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1Main
2Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q422Q123Q223Q323Q4232016201720182019202020212022202320242025
3DAU238249265280293306319332347363375375375375375
4US DAU909092939596979899100100100100100100
5EU DAU717274777880828486889292929292
6ROW DAU778799111120130140150162175183183183183183
7
8US ARPU8.1970520833333349.6090412371134027.7373571428571427.9361717171717178.1160199999999998.803099999999999
9
10EU Revenue153.121208.912162.132170.097161.396218.552
11US Revenue786.917932.077758.261785.681811.602880.31
12Revenue678.668911.322769.584982.1081067.4711297.8851062.7271110.9091128.47613001073.354271122.018091139.76076000000011313404.482824.9491180.4461715.5342506.6264117.0484602.1120000000014648.13312
13COGS293.095385.546412.601445.021443.473449.151420.897446.377466.757481.311895.8381182.5051750.2461815.3419999999999
14Gross Margin385.573525.7760000000001356.98299999999995537.087623.998848.7339999999999641.8300000000002664.5320000000002661.719818.6890000000001676.2131901706.8713967718.0492788827.19819.69600000000011324.1212366.80199999999972786.7700000000013
15R&D283.639318.446348.58370.671412.021434.195455.563505.037564.258584.942883.5091101.5611565.46699999999992109.8
16S&M143.511157.634150.286179.724217.526245.228241.886311.374270.336295.15217.6974280.2366243.3024265.635458.598555.468792.76400000000011118.746
17G&A126.287146.932161.723179.204175.275194.438215.908249.061262.367225.929580.917529.164710.64953.265
18OpEx553.437623.0120000000001660.5889999999999729.5989999999999804.822873.861913.3571065.4721096.9611106.021217.6974280.2366243.3024265.6351923.0242186.1933068.87099999999964181.811000000001
19OpInc-167.86400000000003-97.23599999999999-303.606-192.51199999999994-180.82399999999996-25.127000000000066-271.5269999999998-400.9399999999998-435.24199999999996-287.3319999999999458.5157901426.6347967474.7468788561.5550000000001-1103.3279999999997-862.0720000000001-702.069-1395.0409999999993
20Interest-25.411-27.206999999999997-3.8939999999999997-3.313-2.774-2.4959999999999996-2.052.78199999999999913.0223.38611.048000000000002-79.101-12.47737.138
21Pretax-193.27500000000003-124.44299999999998-307.5-195.82499999999993-183.59799999999996-27.623000000000065-273.5769999999998-398.15799999999984-422.222-263.94599999999986458.5157901426.6347967474.7468788561.5550000000001-1092.2799999999997-941.1730000000001-714.5459999999999-1357.9029999999993
22Taxes0.90918.1271.44-1.8790.99213.0318.516.9999.2414.20645.8515790142.6634796747.47468788000000556.155500000000010.39318.65413.58428.956
23Net Income-194.18400000000003-142.57-308.94-193.94599999999994-184.58999999999995-40.65400000000007-282.0869999999998-405.15699999999987-431.46299999999997-268.1519999999999412.66421109383.97131702999997427.27219091999996505.39950000000005-1092.6729999999998-959.8270000000001-728.1299999999999-1386.8589999999992
24EPS-0.1324204525306529-0.09605349944787933-0.20573561102690666-0.12535014096122496-0.11675772913522489-0.024360064450448516-0.1742231703407976-0.248236670873822-0.26823551792545086-0.170376069885753820.262194973254047450.243964333454265630.271476463574484240.3211163091538571-0.79440435286471-0.659360867985214-0.46705028938477744-0.8622521025749107
25Shares1466.421484.2771501.6361547.2341580.9661668.8791619.1131632.141608.5231573.8831573.8831573.8831573.8831573.8831375.4621455.6931558.9971608.41475
26
27Revenue Growth0.57289131062610890.424178281661147240.380910985675378070.13114749090731380.0571490935116738540.00162957426890675271.03951968196359750.43093209398399180.45329307736228520.46113455052479280.64246600809215230.11781839803665184
28DAU Growth0.231092436974789980.228915662650602370.203773584905660330.185714285714285720.18430034129692840.186274509803921570.17554858934169282
29Gross Margin0.57693767954685620.46386489324102370.54687162715302180.58455733223666030.65393621160580470.60394626277491780.59818761032631840.58638287389364060.62976076923076930.630.630.630.63
30
31CFFO185.528-124.081125.291
32CapEx-24.565-23.37-46.925
33FCF160.963-147.45178.366
34
35Headcount40434667519056616131644657065288
360.51644818204303730.38118705806728090.09942196531791914-0.06588941883059529