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.

Image_2_54918.png

image1_54918.PNG

Accepted answers

ArunManickam

Check your current period setting in Time settings.

Check your dimensions on **** scenario module and your calculation module.

Adjust the formula accordingly.

Thanks

Arun

Misbah

@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

All comments

ArunManickam

@akprasa1

This should work for you

Formula

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

Thanks

Arun

akprasa1

Hi Arun,

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

See results in the image.

image3_54928.PNG

ArunManickam

Check your current period setting in Time settings.

Check your dimensions on **** scenario module and your calculation module.

Adjust the formula accordingly.

Thanks

Arun

Misbah

@akprasa1

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

akprasa1

Hi Misab,

Attached are my time settings.Please comment.

Capture2_54948.PNG

Capture1_54948.PNG

ArunManickam

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

Thanks

Arun

akprasa1

i am getting stimulated values for 2018 also..

Misbah

@akprasa1

First of all your current period should be updated - it is blank.

Happy Planning!

Thanks,

Misbah

Quick Links

Can you help?

Unanswered questions

L2 Import DEM01
Hi all, i'm trying to import the file DEM01 csv but i don't know how to do it How do i select th evalue of DEM01 if the time value is on column? thanks a lot Andrea
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…