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

Answers