DC89
Novice

Calculating IRR (Internal Rate of Return) in Nintex or Calculated columns

Hey everyone

 

Long-time lurker (thank you for everyone on this community that has solved many mini-queries for me over the last year or so!).

 

I have a loan cashflow in a Sharepoint List (one column per payment) and am hoping to find a way to calculate the IRR. In Excel this is simply IRR(<range>,<accuracy>) but this isn't available in Sharepoint OOTB - i expect because it's not a simple calculation and the "range" isn't as defined in columns.

 

Is anyone aware of a way i can calculate this using Nintex?

0 Kudos
Reply
2 Replies
kunalpatel
Collaborator

Re: Calculating IRR (Internal Rate of Return) in Nintex or Calculated columns

@DC89 .....I think you can do it with Nintex workflow. Using for loop/while loop you can build the formula.

0 Kudos
Reply
DC89
Novice

Re: Calculating IRR (Internal Rate of Return) in Nintex or Calculated columns

Thanks Kunal. I thought there might be a way. I'll do some digging into how to create a "manual" IRR and then replicate it into a Nintex loop.

0 Kudos
Reply