Replace confusing cell references with global constants, local variables, and reusable custom functions.
Another way to value AMCR is to add the dividend, expected growth in earnings, and the expected growth from the multiple ...