| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows
My investment has an initial cash outflow of $1000 followed by series of losses on this investment thus all remaining cash flows are negative.
I was interested in knowing my loss in terms of internal rate of return for this investment so I tried using Excel IRR function with my data listed below but I was given a #NUM! error in Excel 2010 using the IRR function. My cash flows are as follows -1000 -644.89 -338.33 -87.34 I did try an alternative IRR function that is part of tadXL Excel add-in which is no longer available online and it reported a correct IRR for this investment. So what makes tadXL report an IRR for all negative cash flows and Excel IRR function is unable to find the internal rate of investment where investment makes no money and there are all losses. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating quarterly investment returns---XIRR or another function?? | Excel Worksheet Functions | |||
| IRR function when the cash flows are not in array? | Excel Worksheet Functions | |||
| IRR for 2 cash flows | Excel Worksheet Functions | |||
| Future Value function with differenct cash flows | Excel Discussion (Misc queries) | |||
| NPV Calc appears incorrect with a large # of negative cash flows | Excel Worksheet Functions | |||
Threaded Mode
