How can I use FileMaker to realize the IRR function like Excel. I am trying to solve this problem by looking for some resources, but I failed.
What I can find is as following:
Let ( [ IRR1 = GetAsNumber ( IRR1 ); IRR2 = GetAsNumber ( IRR2 ); NPV1 = GetAsNumber ( NPV1 ); NPV2 = GetAsNumber ( NPV2 ) ];IRR1 + ( ( NPV1 / ( NPV1 + NPV2 ) ) * ( IRR2 - IRR1 ) )
But this formula is too simple, and it cannot get the IRR based on a series of cash flows and intervals.
Here is some reference from other forum.
Please help to solve this problem. Thank you very much!