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

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Anaplan Report page issue in the UX
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
ADO - S3 incremental load vs. full replace
I want to create an S3 connection that will have monthly data stored in individual csv files that is connected to ADO. Around month end, data will be uploaded multiple times, replacing existing csvs. When this happens I want to replace the existing data for that month with the new file. I don't want to have to create a…