Hi Friends,
I need your help please, I struggle with the IRR function, here is my sql server table:
I want to calculate the the internal rate (IRR) for each Projet. I ve used =RangeIRR($(vinvet),$(repeat(vpayment &',',$(vNumber-of-payment)))) but is not working. I need to get those variable from SQLServer and calculate the IRR. thank you very much
projet | invest | payment | Number-of- payment |
A | -5000 | 200 | 12 |
B | -3000 | 600 | 25 |
C | -7000 | 500 | 36 |