XIRR Formula

CommunityMember113484

Hi,

I am trying to use the IRR function in Anaplan. I have a dummy list of cashflows, with the following dates and net cashflows. In excel, I would just use the XIRR formula on cashflow date and net cashflow, but in Anaplan, what is the best way to add the redemption value in the current period and perform the XIRR calculation?

Thanks for your help,

HimanshuRaj

Hi @CommunityMember113484

In Anaplan, you can use IRR function to calculate XIRR as well by taking into account the date field as parameter.

https://help.anaplan.com/irr-3e65abd3-a8d8-4cb7-af34-937232ae79c5

Cheers!!

CommunityMember113484

I saw this earlier, but it doesn't quite work?

HimanshuRaj

Hi @CommunityMember113484

In your IRR Formula, after entering your 2 parameters, 3rd parameter needs to be list name, and then 4th parameter should be estimate (0.1 in your case)

Cheers!!

CommunityMember113484

Thanks - so I'm getting a NAN? I've seen some threads on this, but can't seem to figure it out.

Ashutosh

Hi @CommunityMember113484

Do u want to calculate IRR by QTR?

CommunityMember113484

Yes please