Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started