|AMZN.xlsx
|
MainModel
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCVCWCXCYCZDADBDCDDDEDFDGDHDIDJDKDLDMDNDODPDQDRDS
1Main
2Q418Q119Q219Q319Q419Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q422Q123Q223Q323Q4231995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040
3NorthAmerica44124358123865342638536704612755436593737534664366675506555782360692447443078843933637688182546508346370879785106110141366170773236282279833
4Media115671248313580
5Electronics/General385175040164887
6International4187316192163701834823813191062266825171374673064930721291453727228759270652772034463291232969733510354184398310327313409974723104412127787
7Media109381002610631
8Electronics/General223692519633107
9AWS74307696838189959954102191080811601127421350314809161101778018441197392053821378213542214024645.625653.6464478801221917459256553502645370622028009693793.20000000001121931.16000000002158510.50800000003206063.66040000005267882.7585200001321459.3102240001385751.1722688001462901.4067225601
10
11Online Stores39822294983105335039456573665245896483506645152901531574994266075511295085553489645315109652380.6555093.6766466.93000000001122987141247197349222075220004225037.25236289.11250000002248103.56812500002260508.74653125004273534.18385781255287210.89305070316301571.43770323833316650.00958840025
12Physical Stores44014307433041924363464037743788402239204198426946884591472146944957489547214694495717224171921622417075189631926720230.35000000000221241.86750000000422303.96087500000423419.15891875000724590.1168646875125819.62270792188427110.60384331798
13Third-party13383111411196213212174461447918195204362732723709250852425230320253352737628666363392982028197.28000000000229525.9837429.17427455376180437103366117716124972.43131221.0515137782.104075144671.20927875003151904.76974268752159500.00822982192167475.00864131303175848.7590733787
14Subscription3959434246764957523555566018657270617580791781488123841087168903918996579413.289615.249924.12141671921025207317683521838609.6442470.60446717.664451389.4308400000156528.37392400001459354.79262020001662322.5322512100265438.65886377052
15Ads33882716300235864782390642215398735063817451761297167877875795481155795099632.710502.80000000000112712.7101081408620875311603773942357.246592.9251252.21256377.4332000000162015.17652000001565115.9353460000268371.7321133000271790.31871896502
16Other0000000602524463479710661107012631253102710701263125306022176424746134843.6500000000015085.83255340.1241255607.130331255887.4868478125016181.8611902031266490.9542497132825
17
18Product44700342833585639726505424184150244527747105657491580045487671416564555657559340705315698159032118573141915160407215915241787
19Services276832541727548302553689533611386684337154499510275507655936659965998964659677617867370377753515929390972120115170149228035
20Revenue7238359700634046998187437754528891296145125555108518113080110812137412116444121234127101149204127358134383135340.28999999998158396.520000000020.51115.746147.787609.8191639.8392761.9833122.4333932.9365263.69969218490107111483519166245093420448077610937445288988107006135987177866232887280522386064469822513983548649.72603578.8480000001668693.7566746654.5652500001840891.5518145001923118.54318322521017493.36687598661126230.7110601058
21Cost of Sales4478633920363374130253977442575266057106792846240364176629308283566499664247026885640677916937373056.08286846.908000000012323.8752940.3184006.531627527165188265111934139156165536233307272344288831297066.99395544.2232436659.3873600001486231.6956280001546604.4209794002602062.3316729702665918.6758301387739718.4827098695
22Fulfillment10028860192711016712192115311380614705184741653017638184982244520271203422058323103209052130521154.912525974.025798.558392.467477.03210766134101761925249340274023158516751118429989338.937536751.016438588.56722000000440517.9955810000142543.8953600500144671.09012805251446904.64463445514449249.876866177896
23Gross Margin1756917179177961851221268196642244624334277972958531266293843213229674344683625040461386624370541129.29549999998645575.587000000010600.151780.135999999999715470219453010340683597047475594241122367140853162243.79249999998171283.6084000001193445.80201999986219904.87404100003251743.23547504994276385.1213822025304670.0464113927337262.3514840584
24Technology7669792790659200974093251038810976120491248813871143801531314842180721948520814204502193121433.522895.4241.165215.617207.8099275125401608522620288373593242738560527321386709.989311.19791990.5329100000194750.2488973000197592.75636421902100520.5390551456103536.15522679997106642.23988360396
25S&M491136644291475261724828434554347403620775248010108108320100861101412818101721074511564.713458.900000000001138.283125.383122.78743325254723310069138141887922010325514223845940.60000000000647318.8180000000148738.38254000000650200.5340162000151706.5500366860153257.7465377865954855.4789339201956501.143301937795
26G&A11171173127013481412145215801668196819872158215325252594290330613333304332023214.053499.6589.86279.04988.302155217472432367443365203666888231189112958.69999999999913347.46113747.88482999999914160.32137489999914585.13101614715022.68494663140915473.36549503035215937.566459881262
27OpEx1369712764146261530017324156051631318078214202068223553245432864825756310613356036965336653587836212.2539853.950000000004469.30999999999995420.049418.8981515919541257503636346987600147141697426127342145609.2149977.47600000002154476.80028000002159111.10428840003163884.43741705202168800.9705395636173864.99965575052179080.949645423
28OpInc38724415317032123944405961336256637789037713484134843918340726903496499778274917.0454999999865721.637000000002-469.30999999999995180.10199999999998361.2379999999997311240443534320127171474122825249411351116634.5924999999721306.1324000000938969.0017399998360793.769752687858.79805799792107584.15084263889130805.04675564216158181.40183863541
29Interest Expense-522-14-281-580109-6768855313881365921-52611450-9183-425254-249-878-264-110.12899999999999-119.23800000000001-108.02400000000002-422-836-461-514-1456-766135313210-9603-114299.2088012499999281.15420146062564614.78052696303951136.75320433932531893.2153900691922823.77300304721083959.61797099607
30Pretax335044012889263240533383622168097765102688634431514934-5265298229443247411975634917.0454999999865721.637000000002-579.43960.86399999999996253.21399999999971-11115683892380611261139752417838151390815492.5924999999721405.3412012500939250.15594146045661408.5502795630488995.55126233725109477.36623270808133628.81975868938162141.01980963149
31Taxes32384026449878584897847854321618561159611-14210720947813737.5568249999978858.245550000000300013097215217731188238728474787-13493355.80237499999843210.8011801875135887.5233912190689211.28254193445513349.33268935058716421.60493490621220044.32296380340624321.15297144472
32Net Income30273561262521343268253552436331722281077778315614323-3844298228723247317267504179.4886749999884863.391450000002-579.43960.86399999999996253.21399999999971-2415962371303310073115882133133364525712136.7901249999718194.54002106257433362.6325502413952197.2677376285975646.2185729866693055.76129780187113584.49679488597137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678137819.86683818678
33EPS6.0419161676646717.09362549800796855.218687872763424.2341269841269846.4712871287128725.00988142292490110.30058939096267212.36523437514.07797270955165715.8031189083820660.7561734396266776.1281553398058251.387349864393646-7.5520628683693520.29307125307125310.277998257671087050.314998059759410140.30656228858606360.64599483204134370.399989345870417070.46544085079911973-1.59094316206814160.16086139500955420.6038220874110526-0.52164502164502171.2494758909853254.8987603305785126.15212981744421920.14623.01489572989076441.8254901960784346.1676679914964410.51665847665847661.16436802657456421.74553077383437173.20071305705774335.0076526826525247.25727620981308258.92749664678868610.8969632843944913.222033562448964
34Shares501502503504505506509512513513102865151032450910175103311030810347104491044910449161.096869364.211378.363419.352462477484493500503.55105409.51017510423.510423.510423.510423.510423.510423.510423.510423.5
35
36Revenue y/y0.207977011176657460.26385259631490790.402309002586587640.373872908360840750.43594816839553040.43823888034777080.271819326974986450.152550834676790310.094436701047349690.073038574245747330.072108241952600020.146996715157203140.085814921549791870.09372745697502660.108459673029018160.064824745674699540.061610412589474973.12633722857896771.6890585567192890.68430132470321790.13050406175562990.25957418461821290.33836375674559660.314854819775978840.226701343736454230.26160188457008250.385024740920548950.291944725311762630.278774913910049050.395568974662368960.40559583674424050.27073236682821310.218666623017367060.19523988610111220.202476738436643040.27083528026465810.30796326119408480.30933961521594910.204541258206769830.376234306043732760.216953665713456760.093995172639850910.067447211289089370.100116934352942220.107881362668295290.116586715339462630.12621229541795810.09778548873667870.102234782726089660.10686786540729587
37Product y/y0.220459119680308070.401271753681392340.328449881689573560.40588025800324480.374035037403503750.15444630204601540.039830219426232550.005066426480522468-0.018020211859247515-0.024636231984001110.08134703695604628-0.0123921810238601940.0093171552563988680.04342907644719407
38Service y/y0.322382657276625960.403659067808915360.433515121467526130.4771378235533270.51816369640891380.424330195510499660.28970971386410270.210957999229343550.175632508279930160.173995932892730080.211402316933638530.192087399236317460.17316508026471510.1653598106992067
39Online Stores y/y0.14652704535181550.242524916943521520.47798924419540790.379890978623819150.455439472589088230.443331878205827760.158205508105281560.03292657704239921-0.005658304615430931-0.033496531256497986-0.043305679402524610.07102238596772259-0.023367385546727237-0.00064542627471686490.0300000000000000270.0300000000000000270.0300000000000000270.14847097660728360.397190736794409860.12529072860769497-0.0093256782618484910.022877993127397690.0500000000000000440.0500000000000000440.0500000000000000440.0500000000000000440.0500000000000000440.0500000000000000440.050000000000000044
40Third-party y/y0.30359411193304940.299614038237142170.52106671125229890.54677565849227980.56637624670411560.63747496374058990.378675460291288730.186729301233117930.109525377831448670.068581551309629290.091329479768786030.182005607784925030.198515831134564720.1770278271166370.0300000000000000270.0300000000000000270.0300000000000000270.25771435255585450.49619612730417950.285055384959657760.138827080471334960.061643531890312130.0500000000000000440.0500000000000000440.0500000000000000440.0500000000000000440.0500000000000000440.0500000000000000440.050000000000000044
41Subscription y/y0.32230361202323810.27959465684016570.28699743370402040.325801896308250960.34880611270296090.364290856731461550.315553339980059850.23980523432744970.150403625548789050.109498680738786320.100922066439307790.092660775650466260.131232303336205720.148275862068965480.080000000000000070.080000000000000070.080000000000000070.35596809486835610.31218115564810.260284841512278260.10859984890455810.096304162644102350.100000000000000090.100000000000000090.100000000000000090.100000000000000090.0500000000000000440.0500000000000000440.050000000000000044
42Ads y/y0.411452184179456950.43814432989690720.40606262491672230.50529838259899610.53701380175658730.63364055299539170.76522151149016810.41015190811411630.32190476190476190.234446011596928460.175278486109247120.254335260115607030.189481268011527430.207185476704329070.100000000000000090.100000000000000090.100000000000000090.39354966363276620.48196791140139150.49269461077844310.211136071887034760.122372081931158670.100000000000000090.100000000000000090.100000000000000090.100000000000000090.0500000000000000440.0500000000000000440.050000000000000044
43AWS y/y0.339703903095558650.327832640332640370.28958358191146650.289716509171762170.280088406670685240.321362168509638830.37018874907475950.38867339022498060.39538533982106430.36569651188624740.33290566547369840.274860335195530770.202362204724409360.1579632340979340.121637367647803750.199999999999999960.199999999999999960.69681309216192930.55063451776649750.42884033063262140.469442694312389050.365269927889300350.295323473990749760.370994048931011730.287675637439310570.17100978825409530.300000000000000040.300000000000000040.300000000000000040.300000000000000040.199999999999999960.199999999999999960.19999999999999996
44Gross Margin0.242722738764627050.287755443886097140.280676298025361150.26452894357039770.243237988494573230.260616020781423930.25245186251574590.253096884913412030.221393015013340770.27262758252087210.276494517155995770.26516983720174710.233836928361424030.25483494211809970.28430968210238050.285206253294623960.27117905686174630.303569465600904530.325227149267392430.30389542906993910.287730986766628450.173843664314289580.205081958021045540.221366748292116170.228728368547108480.25636467471348770.26648533804835270.244107194662024960.260453959159000660.274042137580425840.295714709377779330.283780004828797560.28928908055547390.294520229669217870.299376578266045250.29940371518172850.29943197305238680.29946115673457163Discount0.08
45ROIC0.01
46Net Cash5258041402396152893347305188292657-2572876-26798785057.4886749999889920.88012499998928769920.88012499998928115.42014606256361478.05269630395113675.32043393253189321.5390069192282377.30030472105395961.797099607533781.6639377938Terminal0
47Cash8439673270898947898896049663856071058662700266440563970NPV1265156.9732669257
48AR2379523849241193093332640349873815336647344053417036587122.46219855453738
49Inventories2454224289268352861032891325043480436154423603764639925
50PP&E113114121461133502147152160281168468173706177195186715190754193784
51Leases3755339328433465215156082561615843062033661236826270332
52Goodwill1501715220153501534515371202292019520168202882274922785
53OA2277825660272732922727235320333373037503427584639250224
54Assets321195323077360319382406420549410767419728428362462675464378477607
55
56AP7253963926660907147478664685477121967760796006690769481
57AE4413840939410074154651775581415625459974625666638264235
58DR970810539106951097411827128201281812629132271428114522
59Leases5257353067562976384867651657316652469332729687426775822
60Debt3181631868502795005548744475565805358919671506708463092
61OLTL1701719418211482394523643239712345822259211212093121853
62SE93404103320114803120564138245134001131402137489146043154526168602
63L+SE321195323077360319382406420549410767419728428362462675464378477607
64
65Model NI722281077778315614323-384429822872324731726750
66Reported NI722281077778315614323-3844-2028287227831726750
67D&A761875088038894898028978959410204126851112311589
68SBC25622306359131803680325052095556560647487127
69Other-48730182465215122123344553447
70Other-1327-1456-1258340-1193286896104-1272000
71DT-16361703701909-3623-2001-1955-825-3367-472-2744
72WC16478-13985-6153-92449771-18077-8081-525410526-14317-6293
73CFFO30430421312715731322086-279089651140429173478816476-119.782174.291392.022
74
75CapEx-14824-12082-14288-15748-18935-14951-15724-16378-16592-14207-11455
76Sale of CapEx16298951300997246512091626133711521137
77Acquisitions-380-630-320-654-381-6341-259-885-831-3513
78Investments-34633151-877257742712098922793185450777
79CFFI-17038-8666-22080-14828-12580906-12078-15608-10821-15806
80
81Buybacks00000-2666-3334000
82Debt-1816-347615643-2776-3100465679603016866354
83CFFF-1816-347615643-2776-3100199046263016866354
84FX599-293234-199-10616-412-1334637145
85CIC12175-82226512-1049063001221101-252219075-4519
86
87Headcount12981271133514681608162215231544154114652.1
88
89North America OI1900131221412252294634503147880-206-1568-627-412-240898
90International OI-617-3983454073631252362-911-1627-1281-1771-2466-2228-1247
91AWS OI25963075335735353564416341934883529365185715540352055123
92
93FCF17235-6974-273-74385616-16532-5133-363713733-8282
94FCF TTM-9069-18627-23487-19686-11569-3319
95
96
97
98
99
100Stock Price7.2528.7371.35458355804543