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,
First of all your current period should be updated - it is blank.
Second if your year of current period falls under FY18 and you don't want to calculate it for FY18 then adjust the formula and add +1 in the formula - depends whatever your requirement is. Basically solution is right in front of you - just customize it as per your needs.