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	Diagnostics
2021	Revenues		45 041,0	17 760,0	What is the expected growth rate for Pharmaceuticals in 2022?
actuals	Core Operating profit		41,2%	22,1%
	Operating Free Cash Flow		36,9%	16,2%	What is the expected growth rate for diagnostics in 2022?
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.					What is the core operating margin in 2022 for pharmaceuticals?
2022	Revenues		51 797,2	21 312,0	What is the core free cash flow as a percent of revenues in 2022 for pharmaceuticals?
projections	Core Operating profit		24 448,3	6 414,9
	Operating Free Cash Flow		20 149,1	4 091,9	What is the core free cash flow as a percent of revenues in 2022 for diagnostics?