Internal Rate of Return (IRR)

[geek@smart]

IRR function is unable to determine below cash flows.



0
-868055555.6
-156250000
-156250000
-166666666.7
-90617472.63
-36555725.37
-58386411.54
-21429796.62
-3444609.232
6445840.559
6551374.614
11877191.77
16982555.07
19596053.13

 

[Eduardo]

Hi,
in your case as the return is in more than two years you need to include a
guess

=IRR(C4:C18,-60%)
The result I got with your numbers was -28%

Change C to you range

if this helps please click yes, thanks

 

[Fred Smith]

Help of IRR says when you get this message, you should try a different
guess. IRR can determine the return, you just have to give it a reasonable
starting point, like -25%.

Regards,
Fred