Internal Rate of Return (IRR)

  • Thread starter Thread starter geek@smart
  • Start date Start date
G

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
 
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
 
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
 
Back
Top