View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
via sarpi via sarpi is offline
external usenet poster
 
Posts: 10
Default IRR formula: weird pattern

I found some older post, so it is known that the IRR of +10, +10 and
-15 is -18%
while if I have the -15 as first number instead, IRR is +22%

Why is that? my understanding of IRR is that the later the negative
outflow, the better the IRR should be.

-18% 10 10 -15
22% -15 10 10