| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RATE - what is the internal function? | Excel Worksheet Functions | |||
| Rate of Return | Excel Discussion (Misc queries) | |||
| help needed for Internal rate of return | Excel Worksheet Functions | |||
| rate of return | Excel Worksheet Functions | |||
| Real RATE of return using =RATE illusive, inflation adjusted inflo | Excel Worksheet Functions | |||
Hybrid Mode
