AnsweredAssumed Answered

IRR calculation

Question asked by Eva_1 on Oct 20, 2008
Latest reply on Nov 21, 2009 by maybemoe

Title

IRR calculation

Post

Hi,

 

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 ) ) 

)

 

(From: http://www.briandunning.com/cf/844

 

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.

 http://www.techonthenet.com/excel/formulas/irr.php 

 

Please help to solve this problem. Thank you very much! 

Outcomes