IRR & NPV Calculations with Initial/Start Date

vinaygvk07
New Contributor

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.    

SS01.PNG

SS02 IRR.PNG

SS03 NPV.PNG

2 REPLIES 2
JaredDolich
Moderator

Re: IRR & NPV Calculations with Initial/Start Date

@vinaygvk07 

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!


Jared Dolich
vinaygvk07
New Contributor

Re: IRR & NPV Calculations with Initial/Start Date

@JaredDolich Thanks!