Calculation of CAGR based on a baseline percentage
Hi AnaPlanners,
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.
Best Answers

Check your current period setting in Time settings.
Check your dimensions on Penetration scenario module and your calculation module.
Adjust the formula accordingly.
Thanks
Arun
0 
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.
Happy Planning!
Thanks,
Misbah
0
Answers

This should work for you
Formula
IF YEAR(START()) = YEAR(CURRENTPERIODSTART()) THEN Baseline % * (1 + CAGR %) ELSE PREVIOUS(Simulation Result %) * (1 + CAGR %)
Thanks
Arun
1 
Hi Arun,
Thank you for the response.Unfortunately it did not work.
See results in the image.
0 
Arun's solution should work.As far as I can see there is no problem with the dimensionality on you **** module
It looks like that your current period on Time Setting Page belongs to FY17 or any other year which is earlier than than FY18 or is not populated at all. Hence not pulling the values
After Setting up the current period
Hope that helps
Thanks,
Misbah
0 

Your current period in the screenshot is blank. Set it to appropriate value.
Thanks
Arun
0 
i am getting stimulated values for 2018 also..0