Calculation of CAGR based on a baseline percentage

Highlighted
Contributor

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.

 

 

 

 

 

8 REPLIES 8
Highlighted
Community Boss

Re: Calculation of CAGR based on a baseline percentage

@akprasa1 

 

This should work for you

 

clipboard_image_0.png

 

Formula

IF YEAR(START()) = YEAR(CURRENTPERIODSTART()) THEN Baseline % * (1 + CAGR %) ELSE PREVIOUS(Simulation Result %) * (1 + CAGR %)

 

Thanks

Arun

Highlighted
Contributor

Re: Calculation of CAGR based on a baseline percentage

Hi Arun,

Thank you for the response.Unfortunately it did not work.

See results in the image.

 

Highlighted
Community Boss

Re: Calculation of CAGR based on a baseline percentage

 

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

Highlighted
Master Anaplanner/Community Boss

Re: Calculation of CAGR based on a baseline percentage

@akprasa1 

 

Arun's solution should work.As far as I can see there is no problem with the dimensionality on you penetration 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

 

clipboard_image_0.png

clipboard_image_1.png

After Setting up the current period

clipboard_image_2.png

clipboard_image_3.png

 

Hope that helps

Thanks,

Misbah

Highlighted
Contributor

Re: Calculation of CAGR based on a baseline percentage

Hi Misab,

 

Attached are my time settings.Please comment.

Highlighted
Community Boss

Re: Calculation of CAGR based on a baseline percentage

Your current period in the screenshot is blank. Set it to appropriate value.

 

Thanks

Arun

Highlighted
Contributor

Re: Calculation of CAGR based on a baseline percentage

i am getting stimulated values for 2018 also..
Highlighted
Master Anaplanner/Community Boss

Re: Calculation of CAGR based on a baseline percentage

@akprasa1 

 

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