Create a model based on the above 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)

Pharmaceuticals Diagnostics Revenues 2021 actuals 45 041,0 41,2% 36,9% 17 760,0 What is the expected growth rate for Pharmaceuticals in 2022? 15,0% Core Operating profit Operating Free Cash Flow 22,1% 16,2% What is the expected growth rate for diagnostics in 2022? 20,0% Management estimates sales growth rate of 15% for Pharmaceuticals and 20% for Diagnostics, with Operating What is the core operating margin in 2022 for pharmaceuticals? Profit Margin improving by 6% for Pharmaceuticals and 8% for diagnostics, and Operating Free Cash Flows 47,2% improving by 2% for Pharmaceuticals and 3% for Diagnostics. 2022 Revenues projections Core Operating profit Operating Free Cash Flow 51 797,2 21 312,0 What is the core free cash flow as a percent of revenues in 2022 for pharmaceuticals? 24 448,3 6 414,9 38,9% 20 149,1 4 091,9 What is the core free cash flow as a percent of revenues in 2022 for diagnostics? 19,2% Pharmaceuticals Diagnostics Revenues 2021 actuals 45 041,0 41,2% 36,9% 17 760,0 What is the expected growth rate for Pharmaceuticals in 2022? 15,0% Core Operating profit Operating Free Cash Flow 22,1% 16,2% What is the expected growth rate for diagnostics in 2022? 20,0% Management estimates sales growth rate of 15% for Pharmaceuticals and 20% for Diagnostics, with Operating What is the core operating margin in 2022 for pharmaceuticals? Profit Margin improving by 6% for Pharmaceuticals and 8% for diagnostics, and Operating Free Cash Flows 47,2% improving by 2% for Pharmaceuticals and 3% for Diagnostics. 2022 Revenues projections Core Operating profit Operating Free Cash Flow 51 797,2 21 312,0 What is the core free cash flow as a percent of revenues in 2022 for pharmaceuticals? 24 448,3 6 414,9 38,9% 20 149,1 4 091,9 What is the core free cash flow as a percent of revenues in 2022 for diagnostics? 19,2%