|TMO.xlsx
|
MainModel
ABCDEFGHI
1
2% of revMarginPrice541.28
3Life Sciences0.30009115770282590.4030984204131227Shares391.788962Q222
4Instruments0.146490428441203270.21406347230864967MC212067.52935136
5Diagnostics0.100364630811303550.22070844686648503Cash1888Q222
6Services0.50474020054694620.12479682138342063Debt30260Q222
7EV240439.52935136
8
9
10
11
12
13Acquisitions
14Novasep viral - 1/15/21, $830m
15Mesa Biotech - 2/25/21, $410m
16CSL facility - 9/30/21, $560m guaranteed lease payments
17PPD - 12/8/21, $16B
18PeproTech - 12/30/21, $1.86B