|MRK GR.xlsx
|
MainModel
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCGCHCICJCKCL
1Main
2Q109Q209Q309Q409Q110Q210Q310Q410Q111Q211Q311Q411Q112Q212Q312Q412Q113Q213Q313Q413Q114Q214Q314Q414Q115Q215Q315Q415Q116Q216Q316Q416Q117Q217Q317Q417Q118Q218Q318Q418Q119Q219Q319Q419Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q422Q123Q223Q323Q42320052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030
3Neurology/Immunology0010-1101-0.950.9500.95-0.902500
4Other Oncology16141012159111314.258.54999999999999910.4512.3513.53756951
5Other403542334732384944.6530.436.146.5542.4175197157
6Saizen595766616461686960.857.94999999999999664.665.5557.76234248
7CV118108110109108107109129102.6101.64999999999999103.55122.5597.46999999999998464435
8Euthyrox115107112123128128139143134.4134.4145.95000000000002150.15141.12455470
9Concor127126127133137138147152143.85144.9154.35159.6151.0425529523
10Other Fertility122134143148145141153152152.25148.05160.65159.6159.8625449570
11Bavencio426287104120128146166156166.4189.8215.8202.8156373
12Mavenclad148147157197192189212234201.60000000000002198.45000000000002222.60000000000002245.70000000000002211.68000000000004531693
13Gonal-F192186200191190200198221171180178.20000000000002198.9153.9630767
14Rebif279227247234244201217249219.6180.9195.3224.1197.641131952
15Glucophage226217213209225218228237202.5196.20000000000002205.20000000000002213.3182.25903864
16Erbitux217219273233262242258274235.8217.8232.20000000000002246.6212.22000000000003891987
17Merck Serono1318.61336.31450.51393.51573.71344.91450.51393.51573.70000001701016391788178718761795192420891838.351766.61898.95000000000032061.70000000000031822.797557545762.5999999999994417.72967.21573.70000066397090000000000
18Consumer Health122.9106.9113.9125126.19999999999999116.2119.59500000000001131.25132.51472499.555
19
20Applied41341843244945449850617051833
21Research50156664663160862768822152512
22Services178266244.4244.4244.4244.4244.4244.4
23Science & Lab108612331246.41246.41246.41246.41246.41246.4
24Process8929261053962118612611251.3114911901324.051313.8651206.451249.51390.252535954645
25Life Science226.7228.2283.7573.7595.3999999999999608.4613.4618.4623.40000018061910021312226224823862445.326482680.82814.85000000000042804.6652697.252740.32881.05250000000021680.99999999999982463.60000000075158990000000000
26
27Surface871111049699115111106.4108.9126.50000000000001122.10000000000001117.04000000000002119.79000000000002371410
28Display279274253267252262233200.4277.20000000000005288.20000000000005256.3220.44000000000003304.920000000000111151046
29Semis469475500573603581653729783.9755.3000000000001848.9947.71019.0718942151
30Electronics281.8351.4359.9345.7327408395.89380.27000000000004359.7000000000000500000083508608579369529589971035.8117011701227.31285.181443.780000000000213841543.86000000000010000000033803607000000000
31
32Royalties76.186.276.186.2
33Revenue19502098.922082437.89999999999962545.80000000000062563.72579.38499999999982523.422689.31000000000043745.83971.44053.74380.84369.74119.14447.14598.546304871497152145198.355695805.65823.2000000000015741.2649999999995823.56087.186147.63929110355.815
34COGS521.9486.6517.2619.7761.9639.6644.84625630.855672.327500000000113401410.71433.91633.51596.81553.11727.69999999999981747.51666.699999999999817641807.89999999999991958.81936.72055.421412154.58400000000032124.26804999999972154.6952252.25662274.62312385.42587.62875
35Gross Profit1428.11612.30000000000021690.81818.19999999999961783.90000000000051924.11934.53874999999971892.5652016.98250000000032405.82560.72619.79999999999972747.32772.89999999999962566.00000000000052719.400000000000528512963.331073163.10000000000043255.23261.60000000000043513.63664.60000000000043668.61600000000043616.99694999999973668.8053834.92343873.00690000000036905.67768.186250000001
36Selling446.2468.2540.2573.3652.8591.6590.2598.3677.8868.1999999999999931.9000000000001882.8000000000001971.0000000000001899.9000000000001869.7833.3968.4861.4889.7921.59999999999991042.4942.40000000000011039.89999999999991063.61094.5200000000002989.52000000000011091.8951116.781149.24600000000032234.52457.9
37Royalties105.2122.2117.3115.8121.69999999999997111.3117.3115.8121.69999999999997477466.09999999999997
38Administration102104.4115.2128130.6124.9130130130283269.1267.5334.3288.5298.3279.7321.6270.8301.1304.9350.3287.2330.5297367.81500000000005301.56347.02500000000003311.85386.2057500000001478.20000000000005514.9
39Other76.8134.9109.49155.09999999999996697.1109.49155.099999999999966390.4352.59999999999997
40R&D332.8347.2338.8348.6362.50000000000006379.5380380380526.6553.2558.3630.1579.2520531658576.3591.1666.5591.9585.5599.6620621.495614.775629.58651652.569751397.11519.5
41Operating Expenses10631176.89999999999991220.91256.69999999999981322.69999999999981304.41326.91315.11364.61677.79999999999971754.21708.60000000000011935.41767.60000000000011688164419481708.51781.918931984.61815.100000000000119701980.62083.83000000000041905.8552068.52079.632188.02150000000034977.25311
42Operating Income365.0999999999999435.4000000000003469.89999999999986561.4999999999998461.2000000000007619.6999999999998607.6387499999996577.4650000000001652.3825000000004728.0000000000005806.4999999999998911.1999999999996811.90000000000011005.2999999999995878.00000000000051075.40000000000059031254.80000000000021325.11270.10000000000041270.61446.50000000000021543.61684.00000000000051584.7861711.14194999999971600.30499999999981755.29341684.98541928.40000000000052457.1862500000007
43Interest Expense31.738.678.374.260.4999999999999868.3686867-112.6-61.1-134.9-76.1-98.5-102.3-101.6-52-59.1-94.8-54.2-46.8-34.3-55.1-47-45.8-45.55-48.3625-46.678124999999994-46.59765624999999251.6271.3
44Pretax Income333.3999999999999396.8000000000003391.59999999999985487.2999999999998400.7000000000007551.3999999999999539.6387499999996509.46500000000015585.3825000000004615.4000000000004745.3999999999997776.2999999999996735.8000000000001906.7999999999995775.7000000000005973.80000000000058511195.70000000000031230.31215.90000000000031223.81412.20000000000031488.51637.00000000000051538.9861665.59194999999981551.94249999999991708.6152751638.387743751676.80000000000062185.8862500000005
45Taxes42.364.659.974.820.30000000000001120.1120.1120.1120.167.2136.2133.7102.6159.499.9258.5118.8236.2207.8229.4185.4255.4251.7264230.8479249.83879249999995232.79137499999996256.29229125245.7581615625219.60000000000002480.4
46Net Income291.0999999999999332.2000000000003331.6999999999999412.4999999999998380.4000000000007431.29999999999984419.5387499999996389.3650000000001465.28250000000037548.2000000000004609.1999999999998642.5999999999997633.2747.3999999999995675.8000000000005715.3000000000005732.2959.50000000000021022.5986.50000000000031038.39999999999991156.80000000000021236.81373.00000000000051308.13810000000011415.75315749999981319.15112499999991452.322983751392.62958218751457.20000000000071705.4862500000004
47EPS1.26080956761729611.4011039558417661.47792088316467261.45630174793008281.71895124195032081.55427782888684571.64512419503221.68399264029438832.2067617295308192.35165593376264952.26885924563017572.38822447102115862.6605335786568542.84452621895124173.1577736890524393.0085972861085563.25610201816927263.03392623045078173.340209254254833.202919922234361
48Shares434.8434.8434.8434.8434.8434.8434.8434.8434.8434.8434.8434.8434.8434.8434.8434.8434.8434.8434.8434.8
49
50Gross Margin0.73235897435897430.76816427652579930.76576086956521740.74580581648139790.70072275905412840.75051683114248930.750.750.750.64226600459180950.64478521428211710.6462737745763130.6271228999269540.63457445591230510.62295161564419420.61149962897168950.61998477764488420.64002159827213820.63785670293574210.63631060148863420.6243191407748370.62743589250331840.63092117076674450.63121813421524050.630.630.630.630.630.7432569152943710.7501279474382267
51Revenue Growth0.221449330601743540.168199728260869370.035079371590303280.056371278183674930.166559880399380630.037190915042554230.097047142117078430.0496941197954710.059569306817401690.182539875215459670.117807110251624490.133847993911057950.122742980561555190.14329706425785260.167893783946892140.116839278864595550.104450493430544360.04569940743400980.048501446878875590.0557133534826210750.11460714670110872
52Serono Growth0.006435680610641370.095179987797437530.076062639821029120.16899832120872982-0.020069296375266554-0.015821727019498688-0.01301975051975035-0.013068453805648472-0.008460032093997372
53Consumer Growth0.0869971936389149
54Millipore Growth1.66608238387379480.147489441576724720.189577717879604760.19252669039145910.179735959765297660.146961518014149470.0185989425981873960.022194867203819690.02351901522283595
55Materials Growth0.161070005691519750.113953488372092960.163360560093348980.106623931623931470.228991596638655540.221294363256784980.230992978936810370.240760764626375860.2340000000000002
56
57Cash1539.91951
58A/R2269.64346
59Inventories16874860
60OCA337.61785
61Tax Receivables79.90
62Intangibles12082.327614
63PP&E3173.57946
64Equity4.80
65Non-Current Assets159.22431
66Pension216.60
67Other Non Current60.20
68Tax Assets607.10
69Assets22217.69999999999750933
70
71Debt5281.511050
72A/P1066.73413
73OCL1056.13652
74Taxes392.70
75Provisions404.3562
76ONCL31.81664
77NCP486.92255
78Pension1590.60
79Tax Liabilities1328.10
80Liabilities11638.69999999999922596
81S/E10579.128337
82L+S/E22217.850933
83
84CFFO278.7284.9
85CapEx64.774.9
86FCF214209.99999999999997