Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Intelligence

Authors: Income Mastery

1st Edition

1647773210, 978-1647773212

More Books

Students also viewed these Finance questions

Question

Language in Context?

Answered: 1 week ago