|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 16th, 2009, 03:41 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Internal Rate of Return (IRR)
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 
|
|
#2
June 16th, 2009, 04:32 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Internal Rate of Return (IRR)
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 "geek@smart" wrote: 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
|
|
#3
June 16th, 2009, 10:58 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Internal Rate of Return (IRR)
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 "geek@smart" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
