Internal Rate of Return (IRR)

Question

Hi,&nbsp;everyone,&nbsp;&nbsp;is there anyone who knows source algorithm for IRR function? I am trying to implement IRR function&nbsp;within Power Apps. Did not find any official documentation for IRR excel function tho. I would like to reverse engineer it to PowerFX because there is no native fx nor library which I could use. Is there any documents where I could find precise definition?&nbsp;Thanks in advance for any feedback.&nbsp;CheersKrystof

sergeibaklan · Answer

KrystofP&nbsp;
Afraid such documentation doesn't exist, Microsoft doesn't share concrete algorithms.
Some guesses are here
algorithm - Implementing Excel and VB's IRR function - Stack Overflow
Internal Rate of Return Calculation
&nbsp;

krystofp · Answer

Hello @Sergei,&nbsp;Thank you for your feedback. After all I was not able to reproduce the IRR function but I was able to use OfficeScripts in Power Automate to achieve IRR. I am sending array of values which are then processed via "Run script" action.&nbsp;Best regardsKrystof

Forum Discussion

Internal Rate of Return (IRR)

Share

Resources