Been struggling with this and can’t explain it.
I need to compute the revenue per store and the implied growth rate of the revenue per store. What I can’t understand is why the overall CAGR (highlighted in green) of 5.49% can be lower than any of the components that make it up (highlighted in yellow). Shouldn’t it fall between the range of its components ie between 7.18% and 17.87%. I have triple checked it and do not find any mistakes in my computation.