Calculation of CAGR based on a baseline percentage
I am trying to run a stimulation based on a business scenerio wherein i take in the baseline % and apply a CAGR (in %,can be negative or positive) to the baseline % to get my year on year growth.(image 1 shows the input module for stimulation)
Image 2 is where i am doing the calculation.
i am using a time range for 10 years,
i am expecting the resultant % as ; baseline *CAGR% for FY19,
'FY19'*CAGR for FY20 and so on...
Can someone suggest me a way to do this.