|TMO.xlsx
|
MainModel
ABCDEFGHIJKLMNOPQR
1Main
2
3Q120Q220Q320Q420Q121Q221Q321Q421Q122Q222Q322Q422Q123Q223Q323Q423
4US4892435560975846
5North America5101452963236032
6Europe2785269530502551
7China7757949101001
8Asia-Pac1709174920642042
9Other311300381345
10
11Life Sciences4203329242313292
12Analytical Instruments1387160715181607
13Diagnostics1615110114821101
14Lab Products & Biopharma Services3597553754425537
15
16Consumables5964537261104993
17Instruments1892184219072010
18Product46307856721480177003
19Services16002050205938013967
20Revenue6230990692731181810970
21COP23403327335235553516
22COS11501370139727992855
23COGS34904697474963546371
24Gross Margin27405209452454644599
25SG&A15511826189922772209
26R&D245320343364365
27Operating Expenses17962146224226412574
28Operating Income9443063228228232025
29Interest Income-78-296-114-281-84
30Pretax Income866276721680025421941
31MI+Taxes40416221325253
32Net Income826235119470022171688
33EPS2.0655.921914357682624.9166666666666675.6126582278481014.284263959390863
34Shares400397396395394
35
36
37Product y/y0.020493890020366612-0.02924868311616302
38Services y/y0.85414634146341470.9266634288489557
39Revenue y/y0.193014334746618220.18300442143858509
40Product GM%0.57650203665987780.53534793457166620.55656729449918920.49792945880337
41Services GM%0.331707317073170750.321515298688683840.263614838200473540.28031257877489285
42Gross Margin0.52584292348071870.48786800388223880.462345574547300740.41923427529626256
43
44
45Net Debt-13062-11754-30503-28372
46Cash5583702327521888
47AR5554547678897445
48Inventories4342462554835668
49Contract78380410641147
50OCA1423133215881652
51PP&E6133656084488529
52Goodwill39654392946109959644
53Other2459258444244306
54Assets65931676989274790279
55
56Debt18645187773325530260
57AP2146209826672586
58Employees1314149216341722
59Contract1396147028712722
60OA2135186130322957
61DT1885163234933327
62OLTL3352351446644534
63MI00113117
64SE35058368544101842354
65L+SE65931676989274790579
66
67Model NI2351194722171688
68Reported NI2337182922201668
69Depreciation198211250236
70Intangibles423449609600
71DT24-331-339-262
72Early Debt1970260
73SBC51517877
74Non-Cash6914423358
75WC-1321-126-875-849
76CFFO1978222722021528
77
78Acquisitions-1343-82-400
79CapEx-628-540-640-506
80Sale of PPE50212
81Other-32-4875
82CFFI-1998-626-670-419
83
84Debt-28030-1008-1825
85Buyback-20000-20000
86Dividends-87-103-103-117
87ESOP2052249
88Other20-25-36-12
89CFFF-4850-76-3145-1905
90
91FX137-93-99-78
92CIC-47331432-1712-874
93
94FCF1350168715621022