IRR & NPV Calculations with Initial/Start Date

Vinaygvk7

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.    

 

 

 

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!