IRR & NPV Calculations with Initial/Start Date

Hi All,

I have tried a workaround for IRR, NPV calculations with initial Date i.e. similar to excel in Anaplan. It worked for me and Hoping that it will be helpful for others too

I hope below Screenshots are in-detail to understand the logic.

SS02 IRR.PNG

SS03 NPV.PNG

SS01_99038.PNG

SS02_IRR_99038.PNG

SS03_NPV_99038.PNG

Accepted answers

All comments

JaredDolich

@Vinaygvk7

Yes. Thanks for sharing this. I added this to my own list of best practices. I had a feeling there was a good solution.

Nicely handled!

Vinaygvk7

@JaredDolich Thanks!

Quick Links

Can you help?

Unanswered questions

Anaplan NUX Waterfall Chart - Ending Totals from 0
Is there any way to have the last item of the waterfall be a running total that starts from 0 and shows the net of the previous waterfall components? I'm using line items here, would just want the Ending NAV to always start at 0
Issue with Anaplan tab in Salesforce
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Data Integration to Fluence workspace
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…