Calculating XIRR

[fmbug]

Dear All,

I just want to know, how to calculate XIRR using FileMaker.

XIRR is a function in excel which returns the internal rate of return for a schedule of cash flows.

02-01-2006 200

01-02-2006 100

01-03-2006 100

03-04-2006 100

01-05-2006 50

01-06-2006 100

03-07-2006 100

01-08-2006 100

01-09-2006 150

02-10-2006 100

18-10-2006 -1247

0.3229227 (XIRR result)

This is the result of excel file.

Please help me its on urgent basis.

[fmbug]

I am happy to say that, I have completed this task successfully.. Now it is working fluently. I have done it using custom function.

...

[comment]

Thank you for sharing.

[David Nelson]

So Mr. Khan could you tell me what the custom function would look like?

[fmbug]

please visit briandunning.com

[Lee Smith]

Any particular CF you have in mind? :hair:

[fmbug]

In Briandunning, you will find a CF for IRR.

In IRR, you need to make a very small changed in that function, then it will work for XIRR.