IRR & NPV Calculations with Initial/Start Date

Options
Vinaygvk7
Vinaygvk7 Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

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

 

Tagged:

Comments

Categories