IRR function does not match Excel

[juleshartley]

Hi,

I am trying to do a simple IRR function that you feed some monthly cashflows in date order. I am comparing this to Excel and the results are quite different.

The function that I'm using is :

pow

((1+IRR(IRR.Cashflow)),12)-1

in Qlik and

= (1+IRR(D2:D481, 0))^(12)-1

In Excel.

Can anyone advise why I might be getting different answers? FYI, it seems that Excel is CORRECT!

Thanks.

[#2]

I am not getting different results between excel and qlikview, could it be a rounding error?

Only time I've had issue cropping up with IRR has been when the first value hasn't been a negative

[juleshartley · Accepted solution]

Turns out that the cashflows needed to be loaded into the app in the correct order (rather than just sorted once in)... values seem to match now! Thanks everyone.