Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Generalized IRR (aka Becker IRR) Calculation

aaronindm
8 - Asteroid

Curious if anyone out there has built a workflow that can calculate a Generalized  / Becker IRR as outlined in this paper?

 

https://www.soa.org/globalassets/assets/library/newsletters/compact/2008/april/com-2008-iss27-rozar....

 

The author of the above paper has written a custom Visual Basic "solve for" function that works well in Excel, but is quite slow and therefore ineffective when performing this calculation on tens of thousands of individual cash flow streams.

 

Any ideas on this?  It is likely that an iterative macro is needed for this - an area I have not ventured into.

 

Note this is (I believe) different than any IRR calculation that is currently available in the summarize tool or formula tool.

5 REPLIES 5
PhilippK
Alteryx Alumni (Retired)

Hello @aaronindm ,

 

please check out this solution and let me know whether this helps you:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Calculate-IRR-in-Alteryx/td-p/182350

 

Best regards

Phil

aaronindm
8 - Asteroid

@PhilAnthony 

 

Thank you for responding- unfortunately it does not.  The method outlined in the paper is iterative in nature and designed to handle future negative cash flows

PhilippK
Alteryx Alumni (Retired)

ok thanks for your reply.

I think it is important to set the expectation management here: reviewing such a paper and customize formula accordingly is probably too much for a community post unfortunately.

 

I hope the following interactive lesson gives you a starting point regarding using and creating formula:

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20...

In case this requires a Machine Learning approach, I recommend the Data Science Learning Path:

https://community.alteryx.com/t5/Learning-Paths/Data-Science-Learning-Path/ta-p/504157

 

Best regards

Phil

aaronindm
8 - Asteroid

Understood - was just trying to track someone down who may have been familiar with the concept.

 

Time to dig in and learn macros!

 

Thanks again.

PhilippK
Alteryx Alumni (Retired)

You are welcome - have fun with Alteryx macros! 🙂

Labels
Top Solution Authors