|INTC.xlsx
|
MainModel
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCVCWCXCYCZDADBDCDDDEDFDGDHDIDJDKDLDMDNDODPDQDRDSDTDUDVDWDX
1Main
2Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q422Q123Q223Q323Q423200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040
3Big Three8961410430512237210641198123103029.15000000001108180.60750000001113589.63787500001119269.11976875002125232.57575718753131494.2045450469138068.91477229926144972.36051091424152220.97853645997159832.02746328298167823.62883644714176214.8102782695
4Intel %0.80305532617671350.74653180576194810.6457686398849410.59255152192912390.50956452615594720.510.520.530.530.540.540.540.550.560.560.560.56
5Nvidia1091816675269142692326923
6AMD67319763164341643421200
7
8Foundry700800900
9AXG700800800
10Mobileye100014001900
11NEX710080008900
12DCAI234002270019200
13CCG - Other450032002300
14CCG - Desktop112001240010700
15CCG - Notebook249002540018800
16Revenue1967319631191922052818353153211533814042110001200013000140003882635382383343758635127436235399953341527085587055355593876276170848719657786779024630545000052544.86650000000456253.9159000000160202.5080737500163212.63347743751467625.5909088812871006.8704543253374557.2139770416179734.7982810028385243.747980417689505.9353794384893981.232148410498680.29375583092
17COGS881984258446951991099734880385426710157771716418430167421556615132202422019021187202612067623196236922711129825342553520936188
18Gross Margin10854112061074611009924455876535550042902304918218199042084419561284913375733151315213560934679361913906943737421404361243815268662250024696.08725527001.87963200000428897.20387540000230974.1904039443833136.5395453518335503.4352271626637278.60698852080540664.7471233114543474.3114700129746543.0863973080148870.2407171734152300.555690590394
19R&D362337153803404943624400430244645145587357555722565365768350101481061111537121281274013098135431336213556151901752818053.8418595.455219153.31885619727.91842168000220319.75597433040520929.3486535603221557.2291131671322203.94598656214322870.06436615900723556.1662971437824262.85128605809224990.73682463983625740.45892937903
20MG&A132815991674194217521800174417065688609654015458793163097670805780888136793083977474695063506180654370027212.067428.4218000000017651.2744540000017880.8126876200018117.2370682486028360.754180296068611.5768057049438869.924109876099136.0218331723749410.1024881675469692.4055628125729983.17772969694910282.673061587857
21Operating Expenses49515314547759916114620060466170000010833119691115611180135841288516020182051869919673200582113720572204931971219736217332453025265.926023.87726804.59331000000427608.73110930000328436.99304257900829290.10283385637730168.80591887207331073.87009643823332006.0861993313832966.26878531132433955.2568488706634973.91455433678536023.13199096689
22Operating Income59035892526950183130-613489-67042900001221662498748966459771560617737149461282215936146211505418497232442242823876220822336-2765.9000000000015-1327.7897450000019197.286321999999931288.47276609999972537.19736136537183846.4367114954515334.629308290596204.7368920825728658.66092398006710508.0426847016512587.82954843735213896.32616283662416277.423699623505
23Interest-156-96-76-154997-119138150-565-1202-793-488-163-109-192-94-15143-105-444-235126484-504-4821166-78.59001302338396-47.69367009591301-4.34079786271665446.50245010988616117.88478977742379205.01739506815218309.91874000489736426.4099482081978
24Pretax57475796519348644127-732627-5201165150477955917658141549717545148521267115979145161461018262233702291223372216003502-2765.9000000000015-1327.7897450000019197.286321999999931288.47276609999972537.19736136537183767.8466984720675286.9356381946776200.39609421985558705.16337408995410625.92747447907312792.84694350550514206.24490284152116703.833647831703
25Taxes54568435571154800039462024219023941335458148393868299140972792262002264301041791835-249-497.86200000000025-239.0021541000003335.511537959999984231.92509789799993456.6955250457669678.2124057249721951.64841487504191116.0712969595741566.92940733619161912.6669454062332302.7124498309912557.12408251147373006.6900566097065
26Net Income52025112515842932579-732627-52077053023576567824479109161270610984968011882117241199018262211061990219193197653751-2268.0380000000014-1088.7875909000015161.774784039999931056.54766820199982080.5018363196053089.6342927470954335.2872233196365084.3247972602817138.2339667537638713.26052907283910490.13449367451411649.12082033004813697.14359122199713834.11502713421813972.4561774055614112.18073917961614253.30254657141314395.83557203712714539.79392775749914685.19186703507314832.04378570542414980.36422356247715130.16786579810315281.46954445608415434.28423990064415588.6270822996515744.51335312264715901.95848665387316060.97807152041216221.58785223561616383.80373075797316547.64176806555416713.1181857462116880.24936760367217049.0518612797117219.54237989250817391.73780369143417565.65518172834717741.3117335456317918.72485088108818097.91209938989818278.89122038379718461.68013258763718646.29693391351218832.7599032526519021.08750228517619211.29837730802719403.41136108110719597.4454746919219793.41992943883819991.35412873322620191.2676700205620393.18034672076520597.1121501879720803.0832716898521011.1141044067521221.2252454508221433.4374979053321647.77187288438321864.2495916132322082.89208752936222303.72100840465622526.75821848870322752.0258006735922979.54605868032423209.34151926712723441.43493445979823675.84928380439723912.60777664244224151.73385440886724393.25119295295724637.18370488248524883.5555419313125132.39109735062425383.71500832413225637.55215840737225893.92767999144826152.86695679136426414.39562635927726678.5395826228726945.32497844909827214.7782282335927486.92601051592627761.79527062108528039.41322332729828319.8073555605728603.00542911617628889.03548340733729177.92583824141229469.70509662382829764.402147590066
27EPS1.270019531251.25171400587659171.26235927557513451.04835164835164840.6279522766009252-0.178536585365853650.152-0.125816598112751031.24716736808028480.51411564625850340.97119272237196761.17988865692414760.79344552701505761.9164325842696632.34817963407872872.12868217054263551.89915636649009212.35007911392405072.39558643236616262.45948717948717953.7770423991726994.4896830461603914.4493628437290414.5352079395085064.8325183374083130.9097744360902256-0.5500941062333256-0.264076543997089850.0392371535386854060.25625701387387820.50460874031520860.74936558155398861.05148853342702791.2331614836915551.73132038970501162.1133302277644532.5442965058633312.82539918028863653.322130388363327
28Shares409640844086409541074100412541336178588059365748564556965411516050975056489448754835470144734232409041234123412341234123412341234123412341234123412341234123
29Discount0.08
30Revenue y/y-0.0670970365475525-0.2195507106107687-0.20081283868278454-0.31595869056897896-0.4006429466572222-0.2167613080086156-0.15243186856174207-0.0029910269192422456-0.088703446144336230.08343225368831608-0.019512704126884772-0.065423295908050850.24186523187291820.2378561767874745-0.01218541084094149-0.0118670441124087980.05999089322304019-0.0092178270986218450.072838948604462050.0568137807937765250.12885390608817570.015766147244805850.082012089210032670.014858669269395275-0.20209050415063778-0.207028895867034660.0508973300000001850.070588235294117620.070192307692307660.0500000000000000440.069811320754717080.049999999999999820.0500000000000002660.069444444444444420.069090909090909310.0500000000000000440.0500000000000000440.050000000000000044ROIC0.01
31GDP y/y0.01670.02260.02920.0229-0.0340.05670.01Terminal0.01
32Gross Margin0.59364858599907280.5148945791645470.5192257525956070.55456819028361630.55686508953226870.65311876762258440.62514120631863560.62149191053786020.59803065948243150.63735457311616250.62648360581699940.60940946671830530.62250442153566710.61733570460704610.58556242617939280.56008321882183720.55445181210771410.4260792336727250.450.46999999999999990.480.480.490.490000000000000050.50.50.510.510.520.520.53NPV92756.22185148197
33Share22.421131702074444
34Net Cash-7801-10069.038-11157.825590900002-10996.050806860001-9939.503138658001-7859.001302338396-4769.367009591301-434.07978627166544650.24501098861611788.4789777423820501.7395068152230991.87400048973442640.9948208197856338.13841204178-0.1695877147379835
35
36
37Model NI77053023576567824479109161270610984968011882117241199018262211061990219193197653751
38Reported NI8664504469765292436911464129421100596201170411420103169601210532104820899198688017
39Depreciation10482995311128
40SBC185420363128
41Restructuring19826261074
42Amortization175718391907
43Equity Investments-1757-1458-4254
44Divestitures-300-1059
45WC2461-5408-4508
46CFFO148511063212625109261117016692209631888420776204181901721808221102943233145358642945615433
47
48CapEx58715860500051974515520752071102710711101057326962511778-15181-16213-14259-18733-24844
49FCF8980477276255729665511485157567857100651031311691121831033214251169322160510723-9411