1) Create a model based on the tables below to estimate core operating profit and operating free cash flow for pharmaceuticals under two scenarios: best case, increase of 9% in sales and improved margins of 6% more than the 2021 results for both core operating profit and operating free cash flows. Worst case: sales grow by 1% and the margins improve only 2% for both core operating profit and operating free cash flows. Make improvements to the model above based on your critique (i.e. show good Excel "hygiene" for the ease of understanding, using, and passing this to other staff)

3 We work with Excel models extensively. Often, these models are created by our FP&A team and provided to our business units for their ongoing use and refinements. There are several "poor practices" in the following model. Pharmaceuticals 45 041,0 Diagnostics 2021 actuals Revenues Core Operating profit Operating Free Cash Flow 41,2% 36,9% Management estimates sales growth rate of 15% for Pharmaceuticals and 20% for Diagnostics, with Operating Profit Margin improving by 6% for Pharmaceuticals and 8% for diagnostics, and Operating Free Cash Flows improving by 2% for Pharmaceuticals and 3% for Diagnostics. 2022 Revenues 51 797,2 24 448,3 projections Core Operating profit Operating Free Cash Flow 20 149,1 17 760,0 What is the expected growth rate for Pharmaceuticals in 2022? 22,1% 16,2% What is the expected growth rate for diagnostics in 2022? What is the core operating margin in 2022 for pharmaceuticals? 21 312,0 What is the core free cash flow as a percent of revenues in 2022 for pharmaceuticals? 6 414,9 4 091,9 What is the core free cash flow as a percent of revenues in 2022 for diagnostics? 3 We work with Excel models extensively. Often, these models are created by our FP&A team and provided to our business units for their ongoing use and refinements. There are several "poor practices" in the following model. Pharmaceuticals 45 041,0 Diagnostics 2021 actuals Revenues Core Operating profit Operating Free Cash Flow 41,2% 36,9% Management estimates sales growth rate of 15% for Pharmaceuticals and 20% for Diagnostics, with Operating Profit Margin improving by 6% for Pharmaceuticals and 8% for diagnostics, and Operating Free Cash Flows improving by 2% for Pharmaceuticals and 3% for Diagnostics. 2022 Revenues 51 797,2 24 448,3 projections Core Operating profit Operating Free Cash Flow 20 149,1 17 760,0 What is the expected growth rate for Pharmaceuticals in 2022? 22,1% 16,2% What is the expected growth rate for diagnostics in 2022? What is the core operating margin in 2022 for pharmaceuticals? 21 312,0 What is the core free cash flow as a percent of revenues in 2022 for pharmaceuticals? 6 414,9 4 091,9 What is the core free cash flow as a percent of revenues in 2022 for diagnostics