ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCLCMCNCOCPCQCRCSCTCUCVCWCXCYCZDADBDCDDDEDFDGDHDIDJDKDLDMDNDODPDQDRDSDTDUDVDWDXDYDZEAEBECEDEEEFEGEHEIEJEKELEMENEOEPEQERESETEUEVEWEXEYEZFAFBFCFDFEFFFGFHFIFJFKFLFMFNFOFPFQFRFSFTFUFVFWFXFYFZGAGBGCGDGEGFGGGHGIGJGKGLGMGNGOGPGQGRGSGTGUGVGWGXGYGZHAHBHCHDHEHFHGHHHIHJHKHLHMHNHOHPHQHRHSHTHUHVHWHXHYHZIAIBICIDIEIFIGIH
1Main
2Q101Q201Q301Q401Q102Q202Q302Q402Q103Q203Q303Q403Q104Q204Q304Q404Q105Q205Q305Q405Q106Q206Q306Q406Q107Q207Q307Q407Q108Q208Q308Q408Q109Q209Q309Q409Q110Q210Q310Q410Q111Q211Q311Q411Q112Q212Q312Q412Q113Q213Q313Q413Q114Q214Q314Q414Q115Q215Q315Q415Q116Q216Q316Q416Q117Q217Q317Q417Q118Q218Q318Q418Q119Q219Q319Q419Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q422Q123Q223Q323Q42320012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035
3Keytruda45083110159214249314356483584881104712971464166718892151226926343070311132843388371539933899417645344577480952525426545057956302.46511.26540545661402380971711108414380171862093725148.625400.08625654.0868625910.627728626169.73400588626431.4313459448623788.28821135037719030.63056908030213321.441398356217992.8648390137264795.7189034082362877.4313420449411726.4588052269646
4Lynparza5163344496279111123132145178196206228248246268266275284292275302.5312.40000000000003321.200000000000052118844572599011171211.10000000000011089.9900000000002544.9950000000001272.49750000000006136.2487500000000368.1243750000000134.0621875000000117.0310937500000048.5155468750000024.2577734375000012.12888671875000051.06444335937500020.5322216796875001
5Lenvima3543717497109124128151142158130181188206227231202216232254.10000000000002222.20000000000002237.60000000000002149404579705876945.9000000000001993.19500000000021042.8547500000002521.4273750000001260.71368750000005130.3568437500000265.1784218750000132.58921093750000616.2946054687500038.1473027343750024.0736513671875012.03682568359375041.0184128417968752
6Reblozyl175233394143638310317165292379.6493.48641.524833.9812000000001875.6802600000001919.4642730000002965.43748665000021013.70936098250021064.39482903162521117.61457048320651173.49529900736681232.1700639577352
7Welireg1827384042434445123174224274282.22290.68660000000006299.40719800000005308.38941394000005317.64109635820006327.1703292489461336.98543912641446347.0950023002069173.5475011501034486.77375057505172
8Lagevrio95232471177436825392274.4192.07999999999998134.4569525685992.936496.468248.234124.11762.058531.0292515.5146257.75731253.878656251.9393281250.96966406250.484832031250.242416015625
9Gardasil (vaccine)10701553653584184503903264014112622683112772332193162212142774452742843245814423903836653943834095903563594276254973783938605425324696756336606081048835838886132069310976561187998917123419931528146016742294147019721841.42523.41617.0000000000002---002351591152811189891210163118321738190821732309315137373938567268987953.88033.3380000000018113.6713800000018194.80809388276.7561747388359.523736485388443.1189738502348527.5501635887388612.8256652246258698.9539218768718785.943461095648873.8028957065968962.540924663663
10Januvia (2022)428714418520027233437941146249155851160060067573977984696091910589751134884107292711218581058933108288410441014921906106410069328399481012938880949927930824908807943774854821857809784852878779756717561551523.4499999999999497.2774999999999472.4136249999999---0042616985192223863324408640043931386339083737368634823306332328132044.14112499999961430.89878749999961144.7190299999997915.7752239999999183.1550447999999836.6310089599999967.3262017919999991.46524035840.293048071680.058609614336000010.0117219228672000020.00234438457344000050.0004688769146880001
11Janumet (2022)2419305872101128155173202201218247288305321350386392411405452409474442503476519505570509554562526506569548577496563513586544585563535530533503475503490506472486477487514454476417353329312.55296.9225282.076375-----0732316589541362166018282070215122002158222720411971196417001220.548875610.2744375305.13721875152.56860937530.5137218756.1027443751.22054887500000020.244109775000000060.0488219550000000140.0097643910000000040.00195287820000000080.00039057564000000020.00007811512800000005
12Viral Vaccines (vaccine)117135167135133144186134161181248231246344428428226318430430252322462333319340434285244291391276255316396306272339421273280326421366348358390409357383496405355399519403392426525455496675623481435378576488449516661509470578668526528578668526--5345545978211446140413691378120212731305139315051641167617982275187721352242230022772254.232231.68772209.37082299999972187.27711476999962165.40434362229962143.75030018607642122.31279718421552101.08966921237332080.07877252024952059.2779847950472038.6852049470965
13Bridion414752605860687563697582738290958587899290113139139148163185209204240217256255278284313299224320355340387369436395426423441487468.6465.3485.1200261289340353481705917113011981532168519061944.12000000000011983.0024991.5012495.7506247.8753123.9376561.96882530.984412515.492206257.7461031253.87305156251.93652578125
14Isentress (2023)----4777107117148172197234232267278313292337343387337398399381362412427442390453412418385375377374340338372337305282310308281305275280255247250223245196205211209192189178158147161167123132.3144.9150.3-------348751109013591515164316731511138712051141975857768633550.5275.25137.62568.812534.4062517.2031258.60156254.300781252.1503906251.07519531250.537597656250.2687988281250.1343994140625
15Belsomra4252566054716669677680837984818379788180696962595662.155.80000000000000453.1210260306327318259227204.3183.87165.483148.93470000000002134.04123120.63710700000001108.5733963000000197.7160566700000187.9444510030000179.1500059027000271.2350053124300264.11150478118702
16Vaxneuvance51216138106111116121171454590.2708.24814.476895.9236000000001922.8013080000001950.4853472400001978.99990765720021008.36990488691621038.62100203352361069.77963209452921101.87302105736511134.929211689086
17Rotateq316269851191711901901781341441341261271359313911916912514818419514214215016816214420112916914717416919289160169188130171162224123179160193156191188211172180227222168210196158208227213216173256139297190.3281.6152.9---00162565646522520652602636659610651686728790796806784921.8000000000001940.2360000000001959.0407200000001978.2215344000001997.78596508800011017.74168438976021038.09651807755541058.85844843910651080.03561740788861101.63632975604631123.66905635116721146.14243747819071169.0652862277545
18Simponi5475746174768695108120126146157174170188158169178185188199193186184199219217231233210220208214203205215191209223214202203206186181173166180162.9155.70000000000002149.4264331500689690766819894830838825706648583.2524.8800000000001472.3920000000001425.1528000000001382.6375200000001344.3737680000001309.9363912000001278.9427520800001251.0484768720001225.9436291848001203.3492662663201183.01433963968807
19Prevymis323845506063778082939610094103114118129134139144165280371429546491.40000000000003442.26000000000005398.03400000000005358.23060000000004322.40754000000004290.16678600000006261.1501074000001235.03509666000008211.53158699400007190.37842829460007171.34058546514007154.20652691862605
20Dificid273454605266776765667767175262275247.5222.75200.475180.4275162.38475000000003146.14627500000003131.53164750000002118.37848275000002106.5406344750000295.8865710275000386.2979139247500277.66812253227502
21Zerbaxa2627353237324319-8-1-2103046434950505050120131-1168200180162145.8131.22000000000003118.09800000000003106.2882000000000395.6593800000000386.0934420000000277.4840978000000369.7356880200000362.76211921800002456.485907296200025
22Remicade (biologic)45550755756449151856560843167466966171075384256151151951849054954952757462060460760455750145544239634933931126922920821418616715713512312398101898873828885757367615349445147.744.139.62,1192,2992714266720762270237217941268837582411331300207182.4164.16147.744132.9696119.67264000000002107.7053760000000296.9348384000000287.2413545600000278.5172191040000270.6654971936000263.5989474742400257.2390527268160251.51514745413442
23Pneumovax4147130128515911015679641332221121011602081111081932411011021973461101061381881071201752381631662292631791932143221851702373342561173753391711522772921731531311459686.477.7669.984000000000013764985816537465426408219089261087892602330.144313.6368297.95495999999997283.05721199999994268.90435139999994255.45913382999993242.68617713849991230.5518682815749219.02427486749616208.07306112412135197.66940806791527187.7859376645195178.3966407812935
24Vaqta4758627160285131345648413635643940404040238170179174160152144.4137.18130.321123.80494999999999117.61470249999999111.73396737499999106.14726900624999100.8399055559374895.797910278140691.0080147642335686.45761402602189
25Primaxin15015316217618518118219117017218218119718618618620320118818816516016819615915813515813613612411988104109838485887971819186658875867381776662717374726872535971776751647462656070655864635480797877--629641739705755780689610515384336329314297280265274251260239314298.3283.385269.21574999999996255.75496249999995242.96721437499994230.81885365624993219.27791097343743208.31401542476556197.89831465352728188.0033989208509178.60322897480836169.67306752606794
26Adempas Alliance42515060537983657474100947298888299100101102203280342340402381.9362.80499999999995344.6647499999999327.4315124999999311.0599368749999295.5069400312499280.73159302968736266.695013378203253.3602627092928240.69224957382815228.65763709513672217.22475524037986
27Adempas84677079687594914853575756575553557459636163575759606162300328215221251238242229.89999999999998218.40499999999997207.48474999999996197.11051249999994187.25498687499993177.89223753124992168.99762565468743160.54774437195306152.5203571533554144.89433929568762137.64962233090324130.76714121435808
28Noxafil5556615959666668657175987498107122111117132128145143147161141155162179176188188191190193177103947379826766646257606258605754.1551.442499999999995231259309401488596637743663328259237222.5925200.33325180.299925162.2699325146.04293925000002131.438645325118.2947807925106.4653027132500195.81877244192586.2368951977325177.6132056779592669.8518851101633462.866696599147005
29sotatercept5050010001250130013131326.131339.39130000000021352.78521300000031366.31306513000031379.97619578130021393.77595773911321407.7137173165042
30Cosopt/Trusopt131133138157140153156167152175191179186192197197201217209209121125123134115123114131114122124117124105102113105103104103991003425--484559616697772836503483477444415258
31Zepatier5011216422937851746829613111310410811410883665539284500005551659456371139
32Temodar (2013/2014)23423625127324224725627818827427125426624823422323023722522722921621916211183938886748083756673786766656873575646561,0021,0641065935918708350312284272215
33Zocor1106.94661106.9451348.011791559.52561105117514401723117512181404.751213.74129613701221131111061151105010741063990371379258178218195179177157125.60000000000001137141141139116117114121127107110111103968698827465796469616449635649465054375121519843812803849638.6558468455383300258217187
34Victrelis12131871111261491151101161218159462721140501428153
35Clarinex (2010?)17421324017616017422616410117420213714615520912812913414064566164545562694952659621394234232
36Cancidas8810110913213014014215714612412713313412313513514916114814813914915517515315013517415816815016414516616314516216315118316615618317516313413913713313114215212111294959187796961676258554350655754564553424336--276430569530527606618612640619659680573558422326248213212174
37PEG-INTRON (Biologic)2392252292352252162151982161861851681981661541631751621831651431261421041241121038481914827737658653496380
38Cubicin18729332532229235732011996103919298949580886752504632393611271088382367257114
39Follistim (biologic)57145162142127131145122961341371191381331431291261161251111161221341241011101029710282111959594731018781797266677060705763625841445057528531468481411383355298267240142
40Implanon374345535151647160818074768593948410296120102119158123137124176151134164148160170178155183174174186169199183199206195132189165237295348402502588606686703787492
41Dulera13252237395052676879829510210312413213012013315311312197105826959775742506597208324461536436287214
42Zostavax11027434761807466111627542847695182310724122108787614820222516814118526414215618128517514917924612514919022115416023412165445454---0038231313277243332651758764749685669217
43Nuvaring (device)45961161181101151291318813514513414514215415916814615715616415117117019316817818619116618219019317520019520716019921418821623623421621924024117963635853559623623685723731777761902879179
44Arcoxia3062617757505655596666747989767693104979681889098959594115114100108110112117109115121121112131128141132118123115123110111117114108103898091838483867575726770656854--70230218265320390357399432453485519471450363336289189
45Fosamax394.74103394.74152000000004419.2469441.19976359338057515586451691795544687.25650.2575979277883177285377778975482177178974278672573047041135431426127727628523024122023420822121521118418615215413714414013912312111411294968682757368686166536255594550000000001649.929922323539422502677316031913135298315491099925855676560470358284242209
46Emend69141817192228233241364847494960656869697782898293911108712098114102145111131116135123134122144136151122134141139126143137144133143137143125148123126117121985343333931--274786132193262317376419489508553536550556522389107
47Invanz121616192022252728343741424650505571717162717388758391113871031071101011101181161101201301281141341411391321391531441141431521521361501591571511491375972785757644351535748534552465040--376394140188268294362407445488528568561602496264211203188
48Zetia (2017)190242293328332314356391414.8476501.9536.1544577.5607610581.7560.4534.351055656361453456457162958259261464061463264567662965066271661171766066256863563369161270267157533436732032330522616516214015614714614513710398-25469105313931928.79999999999972338.51676.3999999999999224322982428256726572650252725601344858589380
49Vytorin (2017)055276179193274355378.4497.4526.6552.9623.8686.4693600651.2592.1567.2577.247753252557747749048556248045946947544444542343539441739643636141736937032032030230827729327329924118214218616715592839776575453394743---13310011955.30000000000022603.22387.700000000000321112014188317471643151712501142751497284135
50Atozet49635954731018489949297108122115111105225347391342
51Nasonex (2017, sued)271307311258280306321266165319338259303373323266325375293292308385325297327312258261268289215121231229101941121398542120122817110296725867714941571,1561,15912191219126813341099856536386376293177
52Cozaar/Hyzaar430.718430.718508.7876454.802816085299474225255496816335416226906297257067647197857517827017848138657988478148008479418888938399068619557824854234154264064044273363372953152672552382462052141951921851891501431261321311211121191281251201251031051031091161131029891941825219024862824303731633259356935612105166312831006806667510484453441294
53Propecia (2013)636567767069678675858910395989999105108108108103106109123991131091241061121121171081001041126867717774586667--239271292352391429441445447424283265
54Remeron505074385159506260576559576652575253445650404756222241232205193
55Proscar17518518019417518818619218818312712012511390908586817972796772585658446053585251555556--606734741618418331290216223217
56Avelox (2011)109717011810659599210661599573443055316321202
57Crixivan/Stocrin6464656279899190827483898275727275796968495649525248495845--29125534932830129120620745
58Rebetol66676457565555545322053
59Maxalt56798491788492949397105111107109125125122130136136133141144156135133133149173131156178156154166165--324310348406466524574550638641
60Singulair (8/3/2012)315.91790000000003315.91802315.00424999999996324.61241835208943417222342508464422615.75507.7462364362673173573069281980195086896010021092101810201104108210291060105712571085126011651258121513491328135413361461134014316024803372812802982712842183192452122012732372292392101862031611821751851611871911601521951551008212412711505202526232976357941324275465949875479385311961092931915732708698379
61Claritin RX931281118799132969571124938112212065557487484763420314245
62Vasotec/Vaseretic (EU only)1731951701821581641491521361401341361221271191199694828077767385596369645759575853494248--765720623546487352311255231192
63Integrilin76737446707063636456535753604851266230212
64Caelyx6168674774667075285
65Subutex50525336525171111
66Asmanex (2012-2018)49545358515648536047425748514244208206185
67Intron-A54675638545150544920949
68Cerazette39464953554956495966746967726468268268271
69Other Vaccines52468210455578811156679713492969797736981815653138--2812843113543823040
70Hepatitis Vaccines6043484736466548545969677280686834383636352946--2411981952492881440
71Timoptic3739384332373535303331332931282829323030282728--1601571391271161210
72Proventil54565956575543554221042
73Aggrastat22211922232321212223221924202121-----115968488868600
74Zolinza123334344545----01111514
75Animal75962167266475970973168781575880282686882186581589884085180087181387288588583184282783282990086588493995510009811065109010211036102511241122112212141101122011681418147214171261148214671371123014911540.35000000000011439.551291.529423254339933623455333234783875421243934703556855505762.4000000000015877.6480000000015995.2009600000016115.1049792000016237.4070787840016362.1552203596816489.3983247668756619.1862912622136751.5700170874576886.6014174292067024.333445777797164.8201146933467308.116516987213
76Consumer3843812832323794222912515175414213615545524513955714904433905465834011613431840195218941546
77Prinivil/Prinzide48011547
78Daxas EU
79Pepcid5537
80Mevacor11056
81Vioxx554.3148554.3154999999999731.2098000000001510.7211550909743598788756386521814529.25754.256616531752350.5626944231763253025691489
82MK-0524A
83Elonva
84Other-2217-2365-2202-2512-2259-2552-2410-2465-2521.2-2713.3999999999996-3932-3726-3875.5999999999985-4092.7999999999993-4262-4062.800000000001-4036-3689-2307.60000000000041388115915171403153616071189151214361374128713181370147317301789166417331629160113621385156316531619165614721395145215611305128011211210104211461095119412101379132913961382119552112075254627597548098101135927859932.75963.4375920.546875-9296-9686-12892.599999999999-12230.399999999998-14095.400000000001254760635511544869165977649158804916447753144305250036813675.7343753308.16093750000032977.344843752679.61035937500042411.64932343750022170.484391093751953.43595198437521758.09235678593771582.2831211073441424.05480899660961281.64932809694871153.48439528725381038.1359557585286
85Revenue4895.85287.85443.75571.6306032762902292928392796286731992905.00000000000132011392.519091656.20000000000161675.1000000000004146056401465.09999999999852265.51500.52488.271558095817511147114231134811125120941158112153120221229811731123101148811741106711101011032113191026410934105571048294259785100731021593129844105361011594349930103251043310037104651079410998108161176012397118681205710872109291251410627114021315413521159011459314959138301448714815.19999999999915694.77749999999814305.619375211990012214117019407.510431.3000000000036960.299999999999280094604947986472704403242237394983980740122422944684146372487045928359352.5968750000157817.0952125000157006.616047555064.0057982553515.3448432585152956.08418940841549925.4132214234644976.745038566339185.8990449861433846.63904220267430690.69172735823728671.16190423759727540.841424083443
86COGS862.8886917.3958.7864.2942.1973.21125.71046.8988.51083.41228.31147.81164.21364.21283.61271.41160.61238.81301.81137.71277.71544.11504.81525.81552.31517.71223.19999999999981396.51477.914701311.81306.91430.32595.82811.72662.52796.231292690257227392487268430563411465436983434336133523703.79999999999933923.6943749999993576.40484375000053624.83907.143474959.7999999999994972.65464.34595.85567.612044.485999999997472704403242237394983980740122422944684146372116381514714555.89921874999911563.41904249999811401.32320949999811012.8011596510703.068968651710591.2168378816799985.0826442846888995.349007713267837.1798089972256769.3278084405326138.1383454716455734.2323808475195508.168284816686
87Gross Profit#ERROR_#REF!#ERROR_#REF!8551.28611.383579775814087181009810110112471089511525104691113511111.411771.08312510729.2145312517574.235941.514000000000370664413644796.6976562500146253.6761700000145605.29283844051.204638642812.2758746068142364.8673515267439940.33057713877535981.39603085304431348.71923598891227077.31123376214224552.5533818865922936.92952339007822032.673139266757
88SG&A1362.531478.331438.641421.11343.31362.91407.61538.41547.31589.91463.61794.11577.41595.21752.91761.80000000000021613.31755.31661.21844171517342370.62222.818022083.71951.41814.41930.21730.31862.11625.91660.51725.53190.23166.73127.93023.734063083202025672174225422702594225224202472262824582444.22496.722654.285700.65652.1999999999996394.96687.36873.88042.4000000000015837.173378202.09999999999912724.313292.12200000000112999.25000000000211976.70400000000211403.99000000000210664.46000000000110747.89000000000110832.9411419.38000000000112647.07000000000212647.0700000000029292977210053.210053.210053.210053.213378.83621081462713239.02104735210412481.35330535586611244.1862596415769796.4747612465348461.6597605506697672.6729318395597167.7904760593996885.210356020861
89R&D547.4602.4590.3716.4530.3631.2676.9838.8720.3786.4776.5894.9871.3866884.31108.6846.6946.8942.61093887876.7945.41256.710301030.51115.41078.31169.31171.11386.61136.21287.3125419841993.82007.21944.1217718112007.21944.12177222925952387429924762681254727643496303542662791.643530.963065.352456.42677.23178.13730.238293965.83175.94805.2999999999995661.58122.17939.299999999999118431184213653.949999999999
90Operating Expenses2772.732966.732946.243096.20000000000032737.82936.23057.70000000000033502.90000000000053314.39999999999963364.83323.53917.29999999999972448.72461.22637.22870.42459.92702.12603.8293726022610.733163479.528323114.23066.82892.73099.52901.39999999999963248.72762.10000000000042947.82979.55174.25160.55135.14967.79999999999955834894424951624561655347465275479951845968566367245235.846027.685719.6381578329.399999999998957310417.510702.812008.2901312142.313863.59999999999920846.421231.42212999.25000000000211976.70400000000211403.99000000000210664.46000000000110747.89000000000110832.9411419.38000000000112647.07000000000212647.070000000002211352161423707.1510053.210053.210053.213378.83621081462713239.02104735210412481.35330535586611244.1862596415769796.4747612465348461.6597605506697672.6729318395597167.7904760593996885.210356020861
91Operating Income2123.072321.072497.462475.4-2737.8-2936.2-3057.7000000000003-3502.9000000000005-3314.3999999999996-3364.8-3323.5-3917.2999999999997#ERROR_#REF!#ERROR_#REF!-2637.2-2870.4-2459.9-2702.1-2603.8-2937-2602-2610.7-3316-3479.5-2832-3114.2-3066.8-2892.7-3099.5-2901.3999999999996-3248.7-2762.1000000000004-2947.8-2979.53377.0000000000013450.7999999999993-5135.1-4967.799999999999-5583-4894410846133579216553524835644857115557480644115875.55999999999955743.4031249999995009.584531259417.2-8329.399999999998-9573-10417.5-10702.8-12008.2-9013-12142.3-13863.599999999999-20846.414710.092000000004-12999.250000000002-11976.704000000002-11403.990000000002-10664.460000000001-10747.890000000001-10832.94-11419.380000000001-12647.070000000002-12647.070000000002159312252221089.5476562500136200.4761700000135552.09283833998.004638629433.4396637921829125.84630417463327458.9772717829124737.2097712114721552.2444747423818615.65147321147416879.88045004703215769.13904733067815147.462783245897
92Interest Income-96.4-105.5-106.5-107.3-87.5-82.1-66.9-72.265.768.575.790.293.898.7122.3166181.7187.9195199.7181.7172.3186.981.961.8-415.7-308.7300.09999999999997480.8764.3540.9143.7-7039.80069000000003-57.395179824999980000000
93Interest Expense95.3000000000000197.599.998.194.994.981.18072.871.672.47784.593.199.6108.298.291.987.797.2102.4103.391.5-35-100-134-38-244-51-139-202-1058670-37.753.312530.390625390.80000000000007350.9293.79999999999995385.4375297.2-467-36065.95312549.381743359375015-221.75146484042978-490.05529711173295-748.7157466295711-975.0819122077343-1200.838873830602-1415.7874949227034-1611.9349744187098-1785.6663202874179-1938.6762037386598-2079.8153786420526-2213.682536836848
94Foreign Exchange-2.69999999999999975.38.3-18.7-7.2-16.2-1.7-3.3-7.8-14.9-2.828.30.78.47.4-0.40.4-7.411.520.519.6128.3-7.799999999999999-28.42.800000000000000716.12539.900000000000006
95Minority Interests50.69999999999999659.959.144.551.740.739.137.2-39.6-36.8-37.6-40.3-30.4-30.3-30.9-30.2-29.9-30-30.7-29.9-30.6-30.8-30.6214.2168.7-154.3-121.8-120.5-92
96Equity (Income)/Loss-185.9-185.9-185.9-128.2-171.8-190.2-188.7-94-97.3-187.4-183.4-6194.7220.5307.1285.9316.3334.1480.1586.6503.4611.3595584.2652.6759.1768.5652.1523665.6-685.9000000000001-644.7-474.11008.19999999999991717.12293.89999999999962180.21840.69999999999980
97Other, net29.4729.4729.4766.6-23.54.600000000000001-14.00000000000001453.786.29999999999998-159.10000000000002-38.9-86.8022.145.9107.1-6.12.325.599.146.611.546.6-16187.733.8107.8155.0120.79999999999999-198.50000000000006175.1120.888.7329.3
98Total Other Deductions-156.43-156.43-156.43-61.599999999999994-148.4-128.4-141.89999999999998-23.70000000000000340.89999999999999-309.20000000000005-170.70000000000002-51.099999999999994140.2187.8315.9394.19999999999993289.8320.1504.8712.9000000000001604681.4729.7661.3000000000001908.5999999999999843.1949.4652.1604.9727.4746.8665633.5688.2281.8-22.9-109.978.1-138-118-530.8900000000001-1224-1191.91038.11827.62676.39999999999962701.11984.39999999999990-192.70000000000002-7039.80069000000003-57.395179824999980000000467360-65.953125-49.381743359375015221.75146484042978490.05529711173295748.7157466295711975.08191220773431200.8388738306021415.78749492270341611.93497441870981785.66632028741791938.67620373865982079.81537864205262213.682536836848
99Earnings Before Taxes2279.52477.52653.892537-2589.4-2807.7999999999997-2915.8-3479.2000000000007-3355.2999999999997-3055.6000000000004-3152.8-3866.2#ERROR_#REF!#ERROR_#REF!-2321.2999999999997-2476.2000000000003-2170.1-2382-2099-2224.1-1998-1929.2999999999997-2586.3-2818.2-1923.4-2271.1-2117.4-2240.6-2494.6-2173.9999999999995-2501.8999999999996-2097.1000000000004-2314.3-2291.33658.8000000000013427.899999999999-5245-4889.699999999999-5721-5012407345133445212751084784630955095452489244815837.80999999999955746.7156249999995039.975156258886.310000000001-9553.399999999998-10764.9-9379.4-8875.199999999999-9331.800000000001-6311.9-10157.9-13863.599999999999-21039.10000000000214640.092000000004-12959.449310000002-12034.099179825002-11403.990000000002-10664.460000000001-10747.890000000001-10832.94-11419.380000000001-12647.070000000002-12647.070000000002163982288221023.5945312500136151.0944266406435773.8443028404334488.0599357117430182.15541042175430100.92821638236628659.81614561351326152.99726613417423164.1794491610920401.31779349889318818.55665378569417848.9544259727317361.145320082745
100Taxes663.3721772.3738.3655.1696.1743763.3671.2685.3739.8365.7724.3670.7487.4278.7550.6564577.5400.3450.4609290.2438550.1555.8539.1-560.15290.2318.2312.6358491-730.9247429.6819.6999999999999731.0999999999999794.4488989585452494567665205883761749762913875.6714999999999862.0073437499998755.99627343749992894.89999999999962856.924622161.12092.41787.60000000000011645-2539.475-3465.89999999999962833.23660.023000000001-3239.8623275000004-3008.5247949562504-2850.9975000000004-2666.1150000000002-2686.9725000000003-2708.235-2854.8450000000003-3161.7675000000004-3161.7675000000004193131553406.67511718759037.773606660168943.4610757101078622.0149839279357545.53885260543857525.2320540955927164.9540364033786538.2493165335445791.0448622902725100.3294483747234704.63916344642354462.23860649318254340.286330020686
101Net Income1616.21756.51881.591798.7-3244.5-3503.8999999999996-3658.8-4242.500000000001-4026.5-3740.9000000000005-3892.6000000000004-4231.9#ERROR_#REF!#ERROR_#REF!-2808.7-2754.9-2720.7-2946-2676.5-2624.4-2448.4-2538.2999999999997-2876.5-3256.2-2473.5-2826.8999999999996-2656.5-1680.4499999999998-2784.7999999999997-2492.1999999999994-2814.4999999999995-2455.1000000000004-2805.3-1560.37530000000023229.2000000000012608.1999999999994-5976.1-5684.0999999999985-6209-6001348840612951156044434579542647484703413035684962.1384999999994884.7082812499994283.97888281255991.410000000002-12410.299999999997-13226.9-11540.5-10967.599999999999-11119.400000000001-7956.9-7618.424999999999-10397.699999999999-23872.30000000000310980.069000000003-9719.5869825-9025.57438486875-8552.9925-7998.345000000001-8060.917500000001-8124.705-8564.535-9485.302500000002-9485.302500000002144671972717616.9194140625127113.3208199804826830.3832271303225866.04495178380622636.61655781631622575.69616228677521494.86210921013519614.7479496006317373.13458687081615300.9883451241714113.9174903392713386.71581947954813020.8589900620612890.65040016143812761.74389615982412634.12645719822512507.78519262624312382.7073406999812258.88026729298112136.29146462005212014.9285499738511894.77926447411311775.83147182937111658.07315711107711541.49242553996611426.07750128456611311.8167262717211198.69855900900311086.71157341891210975.84445768472310866.08601310787510757.42515297679710649.8509014470310543.35239243255810437.91886850823210333.53967982314910230.20428302491710127.90224019466810026.6232177927219926.3569856147939827.0934157586459728.8224816010599631.5342567850489535.2189142171979439.8667250750269345.4680578242759252.0133772460329159.4932434735719067.8983110388348977.2193279284468887.4471346491618798.572663302678710.5869366696428623.4810673029468537.2462566299168451.8737940636178367.355056122988283.681505561758200.8446905061328118.836243601078037.64788116505957957.2714023534097877.6986883298757798.9217014465777720.9324844321117643.7231595877897567.2859279919117491.6130687119927416.6969380248727342.5299686446237269.1046689581777196.4136222685967124.449486045917053.2049911854516982.6729412735976912.846211860866843.7177497422526775.2805722448296707.5277665223816640.4524888571586574.0479639685866508.30748432890056443.2244094856116378.7921653907556315.00424373684756251.85420129947856189.3356592864846127.4423026936196066.1678796666836005.5062008700165945.45113886131555885.9966274727025827.1366611979755768.8652945859955711.1766416401355654.0648752237345597.5242264714965541.5489842067815486.1334943647135431.2721594210665376.9594378268565323.1898434485875269.9579450141025217.2583655639615165.0857819083215113.4349240892385062.3005748483465011.6775690998624961.5607934088634911.9451854747744862.8257336200264814.1974762838254766.05550152098754718.3949465057784671.210997040724624.4988870703134578.25389819960954532.4713592176134487.1466456254374442.2751791691834397.8524273774914353.8739031037164310.335164072679
102EPS0.68894667291870930.75444549437333560.81369572738280570.781703607127336-1.41-1.53-1.61-1.87-1.78-1.65-1.73-1.89#ERROR_#REF!#ERROR_#REF!-1.26-1.24-1.23-1.34-1.22-1.2-1.12-1.16-1.3160543532964268-1.4905245811590222-1.1346330275229357-1.2912936232413665-1.21146479387085-0.7727272727272727-1.2926704730074732-1.1669788349878252-1.3333175422805437-1.1639958278020106-1.329526066350711-0.7382198514453331.1730601569311250.830372492836676-1.9120460726283797-1.8326347691514053-1.9990341274951706-1.9333118556701031.37431048069345941.598189689098781.16135379771743420.61417322834645671.75197160883280771.80631163708086782.1387465510445411.86929133858267731.85011801730920531.6208791208791211.39866718933751471.94517385339082671.91482096481771841.67933315672775393.0387915018021863-5.45-5.87-5.18-4.98-5.085.77.766.9110.6310.5210.148.878.858.437.696.8165.535.255.1
103Shares2345.92328.22312.423012294.82282.82265.92264.12262.12261.12253.92236.62232.52230.12226.22217.52210.42206.121972188.72190.52187.72185.72184.621802189.22192.82174.72154.32135.62110.92109.221102113.72752.831413125.53101.631063104253825412541254025362535253725402542254825512551255125512321.87522772253.1252226.5752200.552187.12525382541.752551255125512551255125512551255125512551255125512551
104
105Gross Margin0.76466282368011710.78112513984337540.76597346381857530.76460270128047710.76767523186863310.74772575992899940.70731400540846490.74659083122044810.77043920048131560.75697758496023140.7686201421964520.750.750.75#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!00.7490.7444967359951420.75475547852766140.80.80.80.80.80.80.80.80.80.80.80.8000000000000002ROIC0.01
106SG&A#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!0.184829353097264170.205130254115390760.204573256798720240.197684616733906330.172571081039987830.191849715257747220.141626312810515050.165832933598300560.165251687947055280.190021691973969620.169669358735417970.164979210540525940.159079668380134740.185541075183261680.268908910797679150.5475110528901261#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!0.276320875589046440.2770.2750.2720.270.270.270.270.270.27Mat-0.01
107R&D#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!0.203952786165248420.207367748122103230.224616542768420050.37703911594457110.188231716588110080.198284150580578360.16017860511917490.189405879531282130.23370546159502640.219450469992769350.294470904949264870.188430800799179230.224976747838572440.214275937283561340.115873390254257270.30540363517275254#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!0.176379508784121260.190.1850.180.180.1750.1750.170.170.17Dis0.07
108Operating Margin#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!0.37588068441760450.36862713760588140.3367836642514350.189878968601999650.40687243424053520.357591894090673770.40550908747877490.39135201809086550.37148205093923390.34750542299349240.304479878511769160.39658998866029480.36594358378129280.350182987533176950.44422850134440306-0.8529146880628786-0.9146910520468335#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!-0.452700384373167730.30654966031759273-0.275-0.272-0.27-0.27-0.27-0.27-0.27-0.27NPV237299.65519157378
109EBT Margin#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!0.41918533893108173-0.767922056656296#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!-0.456885057221655230.3050909015129414-0.27415801375079335-0.2733034879139036-0.27-0.27-0.27-0.27-0.27-0.27Share93.53553614173188
110Net Margin#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!0.31915088297190960.324516541473549640.277688905617766050.13681810208735310.33776797932187930.33865838325567640.341236400226400840.325361474679640940.314392673307039240.298626174981923340.246289777041485470.334935640423348950.311231445061900370.299461265570858950.28262701070805235-0.9448583592598657#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!-0.51841082325349090.228818176134706-0.205618510313095-0.20497761593542765-0.2025-0.20250000000000004-0.20250000000000004-0.20249999999999999-0.20249999999999999-0.20250000000000004
111Tax Rate-0.15541835213966362-0.2860039513361755-0.24472722469288008-0.25460470388211960.25-0.11633127555519923-0.146366145354185850.26-0.17071193553001762-0.212159184202566630.3190.117415546080682160.2391259955074536-0.13938989513822686-0.16246395484385548-0.08529977276699878-0.197326416600159620.14362877485882640.100155107467316640.143396226415094340.266572637517630440.13018794048551290.042851170568561870.139958789031542240.138137593029587950.137380777696258250.155764513491414540.20374916313322920.150.150.150.3257707642429759-0.2990453660476899-0.22870625830244593-0.2304091946179926-0.23575806742383273-0.19156004200690113-0.260618831096817160.250.25-0.13466355499997620.250.250.250.250.250.250.250.250.25
112
113
114Revenue Y/Y3.47994534201430830.5965059399021664#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!0.11473742603550297-0.07551020408163267-0.11841574574493830.05443208628244012-0.118603300986978470.0487490802060337460.203586787446244030.080469873741409570.49628305260186310.27986318189791270.13722061730272150.022853339250055393-0.088925224828627080.0152264784485711680.049186275820576110.034390410339840916
115CC Y/Y0.08
116Keytruda y/y0.447333627148523540.28625664388762330.210097719869706930.28351012536162010.187271619975639460.232585596221959840.2204576043068640.146255947908840560.233393177737881490.25766283524904220.19673577415086020.190736290146384050.205032231233104540.199999999999999960.199999999999999960.19999999999999996
117Gardasil Y/Y1.9032258064516130.06849315068493156-0.08938547486033521-0.04066985645933019-0.08666666666666667-0.32820512820512826-0.17791411042944782-0.22443890274314215-0.3260340632603407-0.11068702290076338-0.182835820895522420.016077170418006492-0.20216606498194944-0.081545064377682390.26484018264840190.40822784810126580.239819004524886910.3090692124105012-0.2595936794582393-0.100757575757575710.4401154401154401-0.164083865086599780.88109756097560980.67902274641954510.5310621242484970.59214830970556150.356564019448946560.15102860010035113-0.03795811518324610.35068493150684920.100000000000000090.100000000000000090.10000000000000009
118Viral Vaccines Y/Y0.8528138528138529-0.08130081300813008-0.075581395348837230.0046728971962617380.0046728971962617380.115044247787610580.0125786163522012550.07441860465116279-0.225581395348837250.26587301587301580.05590062111801242-0.06060606060606055-0.14414414414414412-0.23510971786833856-0.14411764705882357-0.09907834101382484-0.03157894736842104
119
120Cash-7000-70003980.069000000003-5739.517982499998
121Net Cash-2129700-19069-14106.8615-9222.153218750002-4938.174335937501-4938.17433593750122175.14648404297649005.52971117329474871.5746629571197508.19122077343120083.88738306021141578.74949227035161193.49744187098178566.6320287418193867.62037386597207981.53786420525221368.2536836848234389.11267374686
122Cash1036611677
123AR964310415
124Inventories55355863
125OCA68106737
126PP&E2005921758
127Goodwill4371041066
128OA1097210280
129Assets107095107796
130
131Debt3166330746
132AP34823680
133AL1350113000
134Taxes44123314
135Dividends17681907
136ONCL89518244
137S/E4331846905
138L+SE107095107796
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167Revenue Consensus/Actual5822.15943.96032.45385.25899.96049.71009311422.2461364496743298439064500750091
168
169Januvia Y/Y---3.7619047619047622.12643678160919561.31944444444444461.0486486486486486-10.51102941176470580.383233532934131650.29551451187335087#ERROR_#DIV/0!0.243309002433089950.29870129870129870.221995926680244480.209677419354838750.44618395303326810.298333333333333340.40999999999999990.4222222222222223-0.06067961165048541-0.059471365638766540.017348203221809078-0.091198303287380660.04521963824289399-0.081967213114754080.0377588306942753250.02450408401400228-0.037082818294190356-0.0357142857142857-0.15845070422535212-0.3610478359908884-0.29268292682926833-0.30760582010582016-0.30644700139470027-0.15790797682709468
170Janumet Y/Y-----24.315789473684211-11.2068965517241381.15277777777777770.7128712871287128#ERROR_#DIV/0!0.57031250.406451612903225850.42774566473988430.42574257425742570.51741293532338320.472477064220183430.4170040485829960.3402777777777777-0.05094339622641508-0.080675422138836830.005964214711729587-0.0063157894736841635-0.03379721669980118-0.026530612244897944-0.037549407114624510.08898305084745761-0.06584362139917699-0.002096436058700246-0.14373716632443534-0.3132295719844358-0.27533039647577096-0.34338235294117647-0.28795563549160663-0.2009167847025496
171Remicade Y/Y----0.079120879120879060.0216962524654833460.0143626570915620370.07801418439716312-0.122199592668024490.30115830115830120.18407079646017710.087171052631578980.64733178654292330.11721068249258160.2585949177877429-0.15128593040847205-0.28028169014084503
172Vytorin Y/Y0.08518719479110160.04392433472266766-0.13738344988344986-0.18152958152958143-0.03799999999999992-0.2675061425061426-0.10150312447221754-0.07440056417489427-0.00034650034650041130-0.07894736842105265-0.07619047619047614-0.0259965337954939370.0062893081761006275-0.06326530612244896-0.03298969072164948-0.15480427046263345
173Zetia Y/Y0.137847416526767350.06930147058823533-0.029610389610389642-0.11976935749588147-1-0.12325941206807645-0.0078515346181298180.05371514130638233#ERROR_#DIV/0!0.047058823529411820.0143884892086330040.0142095914742450540.024429967426710110.08988764044943820.0496453900709219460.075306479859895030.01748807631160565
174
175
176
177
178Merck/Schering-Plough JV65.564.582.585.5116135.1180.225211.605298642.93
179Other Equity (Income)/Loss-260.2-285-389.6-371.4200195195195-1306.2785
180Equity (Income)/Loss-194.7-220.5-307.1-285.9-316.3330.1375.225406.605-1008.2795.6300000000001
181
182Other Income Statement data
183Depreciation and Amort. Quart.326.1479.8187.7320.6#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!00#ERROR_#REF!1314.2
184Depreciation#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!00#ERROR_#REF!
185Amortization31.336.936.136.537.337.237.237.20000140.8148.9
186Period End Shares2243.1192240.41005199999972231.8942221.7642222.5672220.0962214.90402205.40392202.59609999999932201.20389999999902221.764
187Weighted Average Shares2244.32241.422372226.82899999999972222.62221.42217.52208.82207.22203.99999999999952201.8999999999992206.7999999999984
188EPS Basic-1.79-1.67-1.74-1.9#ERROR_#REF!#ERROR_#REF!-1.27-1.25-1.23-1.34-1.22-1.19
189Capex#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!00
190EBITDA-3021.7999999999997-2563-2950.9000000000005-3537.7999999999997#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!#ERROR_#REF!-2190.2000000000003-1877.1000000000001-9408.5-8785.5-8008.999999999999
191
192One-time charges
193Restructuring000195352134161951060.17784746140269703
194Vioxx charges - COGS00000093.20093.20.6015555919436711
195Vioxx charges - SG&A000000141.46040745.4
196Vioxx charges - Taxes000000-173.600-173.6
197SG&A excluding charges1547.31589.91463.61599.11542.41574.21577.51141.80000000000020.0459673236514521740.115042561300978230.053058637083993610.61499386932912936199.95835.900000000001
198Cost of Sales excluding charges1046.8988.51083.41228.31147.81164.212711283.643474866.6
199
200
201Consensus0.753.30-3.40
202
203Small Molecule25281265262489220004189451653715768129321181910003
204Small Molecule % of sales0.54900214988381950.5527862293168840.52659191876454410.45430595930232560.44854037928830170.418679426806420560.39611123671716030.32231693335327250.27944862155388470.2135522298840759