|ADBE.xlsx
|
MainModel
ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1Main
211/27/20203/5/20216/4/20219/3/202112/3/20213/4/20226/3/20229/2/202211/27/202012/3/202112/3/202212/3/202312/2/202412/2/202512/2/202612/2/202712/1/202812/1/202912/1/2030
3USDQ120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q422FY19FY20FY21FY22FY23FY24FY25FY26FY27FY28FY29FY30
4RPO11610122301263013990138301382014110
5
6Publishing1121109591669510398
7Digital Experience934938981105710951120279531253867
8Digital Media285927873110320032307707923311520
9Creative Cloud23792318254826052630648277369546
10Document Cloud480469562595607122514971974
11
12Americas2224218524462524650674548996
13EMEA1052102611361157297534004252
14APAC629624680705169020142537
15
16Subscription311535843520365738123958407041284193.2000000000019634116261457316349.2
17Product127155153119128145146126140.8648507555557.8
18Services182166162159170159170179187.00000000000003889735657695
19Revenue342439053835393541104262438644334521.00000000000111171128681578517602
20COGS428447444467507512539546542.521673172218652139.52
21Gross Profit299634583391346836033750384738873978.4800000000019498111461392015462.48
22R&D558620612651657701738775689.851930218825402903.85
23S&M94110491073106811311158124712661187.553244359143214858.55
24G&A243290256265274269291319287.788196810851166.7
25Operating Expenses174219591941198420622128227623602165.16055674779468929.1
26Operating Income125414991450148415411622157115271813.3800000000013443439959746533.379999999999
27Interest Expense-27-30-28-23-28-28-29-28-28-157-116-109-113
28Pretax Income122714691422146115131594154214991785.3800000000013286428358656420.379999999999
29Taxes0172270206235277314320357.07600000000025254-10848831268.0760000000002
30Net Income122712971152125512781317122811791428.30400000000083032536749825152.303999999999
31EPS2.53512396694214862.68530020703933752.3950103950103952.60914760914760932.66252.77263157894736832.59619450317124742.5138592750533053.0454243070362496.16260162601626111.06597938144329910.35220779220779310.927474019088015
32Shares484483481481480475473469469492485481.25471.5
33
34Revenue y/y0.20035046728971960.091421254801536510.143676662320730180.126556543837357040.100000000000000310.1519111986393340.226686353745725770.11510928096293949
35Revenue cc0.15
36RPO y/y0.191214470284237770.13000817661488150.11718131433095813
37Gross Margin0.87664233576642340.87986860628812770.8771089831281350.87683284457478010.880.85023722137677920.86617967050046630.88184985745961350.8784501761163503
38Tax Rate0.15532055518836750.17377666248431620.203631647211413750.21347565043362240.200000000000000040.0772976262933658-0.253093625963109970.15055413469735720.19750793566735933
39
40Net Cash84416482042167557611731637
41Cash4963576861645798470152995764
42AR1520147715451878168515881723
43Prepaids901833910993109010211002
44PP&E1530157316291673170317901858
45Lease477458452443435430414
46Goodwill13574135001339514488145381445114304
47DT1262116811901085950882799
48OA758805859883874865880
49Assets24985255822614427241259762632626744
50
51AP254312331312295366316
52AE1243153814501736133316151629
53Debt4119412041224123412541264127
54DR4285428343854878501948764943
55Taxes702645610593627569586
56Lease588573563550540532514
57OL248259269252262257253
58PIC7617787782098428875091029548
59Retained20521215382275023905249612602227158
60AOCI-141-121-131-137-177-195-224
61Treasury-14451-15442-16414-17399-19759-20944-22109
62L+SE24985255822614427241259762632626741
63
64Model NI12971152125512781317122811793032536749825152.303999999999
65Reported NI1261111612121233126611781136295152604822
66D&A196194193205213212216757757788
67SBC2602602802693223523787889091069
68Lease19142020042008773
69DT11793-9063019703-1501183
70Investment0-7-4717106-48-11-4
71Other23-24153-15111014407
72DR471-2102482141-141674972581053
73WC-554317-307-217-343341-209-540-72-761
74CFFO17721988140420661769204017044422572772300
75
76Investments-29-12-38-428-26-2031405-507
77Acquisitions-147000-1212-1348-9-1010-2682
78PPE-59-95-95-99-100-126-125-395-419-348
79CFFI-1558-107-133-1739-260-138-103-456-414-3537
80
81Buyback-863-1000-797-999-2309-1200-1200-2517-2780-3659
82Taxes-391-89-122-117-266-101103-440-681-719
83Other1092038-29513711-2777
84CFFF-1244-1080-899-1078-2604-1250-1060-2946-3488-4301
85FX4-31-28-10-26-36-133-26
86CIC-1026798373-779-110562650510071828-634
87
88CFFO TTM7230722772797579442257277230
89CFFO TTM y/y0.29511533242876520.2624410686223153
90FCF TTM6882683868597129402753086882
910.318102806059101130.29653353428786744