|META.xlsx
|
MainModelIP
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCVCWCXCYCZDA
1Main
2Q118Q218Q318Q418Q119Q219Q319Q419Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q422Q123Q223Q323Q423Q124Q224Q324Q424201320142015201620172018201920202021202220232024202520262027202820292030
3Family DAP22602360247025402600272027602810282028702880293029603020307031403190
4Family MAP28902990314032103300345035103580359036403650371037403810388039503980
5Facebook DAU15601590162016601734178518201845187819081930192919601968198420002040206020902110
6US/CA195198196195195195196195196197197
7US/CA ARPU42.9692307692307745.7525252525252550.9591836734693967.4358974358974361.0102564102564168.5435897435897566.806122448979677.2410256410256461.346938775510264.9137055837563464.80203045685279
8Facebook MAU23802410245025002603270127402797285328952910291229362934295829602990303030503070
9US/CA253256255258259259261262263264266
10
11Global ARPP5.9321070234113715.9512738853503196.6884735202492228.5066666666666667.5857971014492758.2840455840455848.1033519553072639.3791086350974937.6670329670329677.8964383561643837.4700808625336938.6002673796791447.518372703412074
122Q MA5.9416904543808456.319873702799777.5975700934579448.046231884057977.934921342747438.1936987696764238.7412302952023788.523070801065237.7817356615986767.6832596093490388.0351741211064198.05932004154561
13y/y0.335465286128624030.296497233172006160.150529733543255830.05926238814370022-0.019305255154011935-0.06229654941873619-0.0807730891706947-0.054411229279200723
14Family MARPU5.8327759197324415.8347133757961786.6109034267912778.2384848484848487.3736231884057978.1424501424501437.8983240223463699.0916434540389987.4170329670329677.7128767123287677.3415094339622648.356684491978617.375590551181102
15Family DARPU7.3898305084745767.4174089068825918.35472440944881910.4565384615384619.35257352941176610.35507246376811510.06263345195729511.5741134751773049.4069686411149829.7759.29590443686006810.5587837837837859.30496688741722
162Q MA7.4036197076785837.8860666581657059.4056314354936399.9045559954751149.8538229965899410.20885295786270510.818373463567310.4905410581461429.5909843205574929.5354522184300349.9273441103219269.931875335600502
17y/y0.33094667009573110.294543072025881040.150201720933105460.05916318338133841-0.02667377688064898-0.0659624291007177-0.08236259879972396-0.05325423345174596
18
19ROW Ads16541539198025122434285729633220294931693047
20APAC Ads32363312420247034735515253986183566158355717
21EU Ads41714411505168226373720568218174636463605707
22USCA Ads8379905999881315011897133661309415062120241278812766
23Other171193188274165262269346297168198192176155215218192184205225293334825541657721
24Reality717534305558877695452285727339276210107150111392274
25Ads117951303813539166401491216624173832073617440183212122127187254392858028276326392699828152272373125428101314983364338706787212466179282763840653550136965584169114934
26Revenue1196613231137271691415077168861765221082177371868721470280722617129077290103367127908288222771432165286453199934146401110000787212466179282763840653558387069785965117929116609110778.54999999999105239.62249999998115763.58475121551.7639875125198.316907125128954.26641433875132822.89440676893136807.581238972
27COGS192722142418279628163307315534923459382941945210513153995771634860055192571683366015.450000000001594562107695935512770166922264922155.70999999999221047.92449999999419995.5282749999921995.08110249998623094.83515762523787.6802123537524501.31061872435425236.34993728608225993.44043540467
28Gross Margin100391101711309141181226113579144971759014278148581727622862210402367823239273232190323630219982382922629.55260542793631687.6900000000024648357927692739528094453.2900000000189730.625585244.09422593768.5036475000198456.928829875101410.63669477125104452.9557956144107586.54446948285110814.14080356732
29R&D223825232657285528603315354838774015446247635208519760966316704677078690917097716936.393449241105171027313600184472465522189.519970.5517973.49516176.14549999999914558.53094999999813102.67785499999811792.41006949999810613.1690625499989551.852156294999
30M&S159518551928246720202414241630262787284026833280284332593554438733123595378045742980.8315428773226784698761159114043140431404314043140431404314043140431404314043
31G&A757776943976106412241348182915831593179015991622195629463305236029873384308521242294207022893451546565649829982998299829982998299829982998299829
32Operating Expenses459051545528629859446953731287328385889592361008796621131112816147381337915272163341743012041.11479214188160322157028941366024852746061.543842.5541845.49499999999540048.145538430.5309536974.67785535664.41006949999434485.1690625533423.852156295
33Operating Income544958635781782063176626718588585893596380401277511378123671042312585852483585664639910588.449999999999112621374815655.6900000000022491328986326714675348391.7900000000145888.0754999999943398.59922553720.3581475000160026.39787987564435.9588397712568788.545726114473101.3754069328477390.28864727233
34Interest Income1615131151206206144311-3216893280125146142117384-172-88-250-250-992724244488265095311059.12000000000011829.05400622570.787519191683493.9623081254244535.6962152086315666.8313581103026887.8995422915878199.723651458868
35Pretax Income561058685912797165236832732991695861613181331305511503125131056512702890881865576614910338.449999999999111631402016079.6900000000022536129812331804728448391.7900000000146947.19549999999445227.653231256291.1456666916963520.3601880004368971.6550549798874455.377084224779989.2749492244385590.0122987312
36Taxes623762775108922162216123818209599532871836200621191371241714431499118114971964.305499999999715052437279132506327403479148710.5222000000018450.4951899999988140.97758161599910132.40622000450511433.66483384007712414.8979098963813401.96787516044614398.06949086039815406.202213771616
37Net Income498751065137688243074616609173494902517878461121994971039491941028574656687439546528374.14449999999996581158313288.6900000000022211123485291463937039681.2678000000138496.7003137086.67564958446158.7394466871952086.6953541603556556.7571450835161053.4092090642665591.2054583640470183.810084959666674.6195807116263340.8886016760360173.8441715922257165.1519630126154306.8943648619851591.5496466188849011.9721642879346561.3735560735344233.3048782698542021.6396343563639920.5576526385437924.52977000661536028.3032815062834226.88811743096432515.54371155941430889.76652598144229345.2781996823727878.0142896982526484.11357521333825159.9078964526723901.91250163003522706.8168765485321571.47603272110420492.9022310850519468.25711953079418494.84426355425217570.1020503765416691.5969478577115857.01710046482415064.16624544158214310.95793316950213595.41003651102612915.63953468547512269.85755795120211656.3646800536411073.54644605095710519.8691237484099993.8756675609879494.1818841829379019.472789973798568.49915047518140.0741929513447733.0704833037777346.4169591385886979.0961111816596630.1413056225766298.63424034144655983.7025283243745684.5174019081555400.2915318127475130.276955222114873.7631074610044630.0749520879544398.5712044835564178.6426442593783969.7105120464093
38EPS1.69337860780984721.74266211604095571.7634740817027122.38461538461538461.49808695652173921.60556521739130442.1193458594293672.5597352838732151.7092050209205021.79854116012504342.7139398132134213.8820069204152253.29528105482303963.61279110184219653.21580972367960843.67452661664880332.7224653537563822.46479911537043871.63565314477112021.76212121212121223.1720244318181813.69754977029096484.38583869746308255.05273384030418357.5696679219445398.16585535465924810.09210526315789613.77054914305701214.72130135410870414.28184021888332513.75873702451641717.12437004143468419.32357460736796620.98191695235893722.65012398778121424.3335950504040226.037399400838282
39Shares2945293029132886287528752874287128682879289128902882287728592799274227132687264026402612264126302905.00075829212876288828592695.52695.52695.52695.52695.52695.52695.52695.52695.5
40
41Revenue y/y0.259986628781547770.27624518177008550.28593283310264450.24642308147097070.176427671287391340.106656401752931450.216292771357353250.331562470353856440.475503185431583650.55600149836784940.351187703772706030.199451410658307180.06637117420045091-0.008769818069264357-0.044674250258531556-0.0447269163375011440.026408198366060010.1102282978280480.23208486685429740.24703870666873940.58358739837398370.438151772822076070.54161088799643010.47090961719371880.373527168966619970.266109101328844130.215963902287225730.3718257430349561-0.011193175554782941-0.050000000000000044-0.0500000000000000440.100000000000000090.0500000000000000440.0300000000000000270.0300000000000000270.0300000000000000270.030000000000000027
42US Revenue y/y0.41985917173887090.47543879015343850.310973167801361640.145399239543726240.010674960073968176-0.043244052072422545-0.025049641056972605
43Ad Volume y/y0.150.150.17
44Ad Pricing y/y-0.08-0.14-0.18-0.22
45Reality y/y0.223152022315202150.301498127340823930.4819672131147541-0.489247311827957-0.17103762827822122-0.5122302158273382-0.3893805309734514-0.263157894736842150.47317744154057761.27345309381237510.9964881474978051-1
46OpEx y/y0.387613685578172440.46108852979081980.38470296004967920.350190080452656760.274500624219725430.1826570769439544-0.09999999999999998-0.03143006809848092-0.13138239255540585-0.0802065404475043
47
48Gross Margin0.83896038776533510.83266570931902350.82385080498288040.83469315360056760.8132254427273330.80415729006277390.82126671198731030.83436106631249410.80498393189378140.79509819660726710.80465766185374940.81440581362211460.80394329601467270.81432059703545760.8010685970355050.81146981081642950.78482872294682530.81985982929706470.79375045103557770.74083631276231930.78999999999999990.81421294415450480.81813389562467050.790.83246176438984210.81936998741106410.80582795323678240.80794376277251570.810.810.810.81000000000000020.810.810.810.810.81
49Operating Margin0.455373558415510640.44312599198851180.421140817367232470.46233889085964290.41898255621144790.392396067748430670.407036029911624740.42016886443411440.33224333314540230.31909883876491680.374476013041453170.455079794813337160.434756027664208460.425318980637617360.359289900034470870.373763772979715470.305432134155080970.28998681562695160.2043732409612470.198942950411938440.369643916913946550.35194849839057470.40262402624026240.39030914213058770.44616569361366810.410003253320508630.38005002035712210.396450406600581730.41499189599430580.41423249807837340.412378894888187240.46405230335181040.49383403342503470.51467112682969470.53343365550304610.55036728218751610.5656871347801183NPV572407.4983602049
50Tax Rate0.111051693404634580.129856850715746430.13108930987821380.136620248400451640.339720987275793360.324355971896955530.16891799699822620.198494928563638350.163623954956492070.155439569401402720.035288331488995450.140635771734967440.174389289750499860.169343882362343160.12976810222432560.190284994489056840.16198922317018410.183117517713168840.211800573888091810.243454220198406230.190.134820388784376970.17382310984308130.173572997986901460.128149520917944880.212229974506909970.121579264617239310.167371626765925040.180.179999999999999970.180.180.180.180.180.180.18Discount0.08
51Terminal-0.05
52Net Cash64833547735066547025383824303451408.14449999999561066.14449999999572649.144585937.8345ROIC0.02
53Cash68188705617047364833547735066547025483045295661330.14449999999570988.144582571.144595859.8345547735295691452.70031128539.375959584174698.1154062712226784.81076043154283341.5679055151344394.97711457935409986.1825729434480169.992657903Share215.87667010339968
54AR1133510276116981208814039113901152511227Upside0.02798414334952226
55Prepaids23812827491952584629398539735312
56PPE4563347720509095372657809615826758873738
57Lease ROU934810202105251106312155122411413013641
58Intangibles1967319561197331943019831208332119421143
59Other27582376235231872751352243445529
60Assets159316163523170609169585165987164218169779178894
61
62AP133187897321954083324640083871
63Partners Payable109310069499091052935982975
64Leases1065411614120071264013873140531606715978
65AE111529411115101315814312152261542016036
66DR382382391464561520532514
67Debt992299229922992299229922
68OL64146575655268597227701070037504
69PIC5001851160528455433455811575125992962092
70AOCL927154285-207-693-1996-3411-5054
71Retained7734582343850977923369761677126924967056
72L+SE159316163523170609169585165987164218169779178894
73
74Model NI949710394919410285746566874395
75Reported NI949710395919310285746566874395
76D&A1972198619952014215619792175
77SBC1830254923782406249833513135
78DT418229-786748-563-453-1097
79Other-66-22-7334-221189516
80WC-1409-1890138326172741444567
81CFFO1224213247140901810414076121979691
82
83CapEx-4272-4612-4314-5370-5315-7528-9355
84Investing-602-33244055117201389932-311
85Acquisitions0-259-71-521-853-363-35
86CFFI-4874-8195-3305829-4779-6959-9701
87
88SBC Taxes-1077-1355-1575-1507-925-1002-1011
89Buybacks-3939-7079-13458-20063-9506-5233-6354
90Debt009921
91Other-169-115-219-172-229-328-409
92CFFF-5185-8549-15252-21742-10660-65632147
93FX-246117-215-130-149-550-364
94CIC1937-3380-17072061-1512-18751773
95
96Headcount4303044942719707780583553873148600077114714696618567317
97Change q/q583557483761-1314-8886-5645-52841132
98
99FCF7970863597761273487614669336
100FCF TTM39115399063594026500
101
102Reality Labs OI-2631-3672
103Reality Labs 6mo y/y1.00139470013946990.256594724220623460.36710369487485095-0.14600231749710313
104
105Family OI130549336
106Family OM%0.33686945226239445
107
108Stock Price (period end)