| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE error with XIRR
The XIRR function returns #VALUE with the following data (no guess). Excel
help says that #VALUE is returned when dates are not valid, but when I use more simple cash flows with the same dates, I get a valid result. I have troubleshooted this a fair amount and am at a loss. Any suggestions would be much appreciated. Here are the data: 6/30/2004 (ぎ 100,000) 9/30/2004 (ぎ 2,102,139) 12/31/2004 (ぎ 112,500) 3/31/2005 (ぎ 112,500) 6/30/2005 (ぎ 112,500) 9/30/2005 (ぎ 112,500) 12/31/2005 (ぎ 112,500) 3/31/2006 ぎ 387,500 6/30/2006 (ぎ 112,500) 9/30/2006 (ぎ 112,500) 12/31/2006 (ぎ 112,500) 3/31/2007 (ぎ 112,500) 6/30/2007 (ぎ 112,500) 9/30/2007 (ぎ 112,500) 12/31/2007 (ぎ 112,500) 3/31/2008 (ぎ 112,500) 6/30/2008 (ぎ 112,500) 9/30/2008 ぎ 2,607,420 12/31/2008 (ぎ 112,500) 3/31/2009 (ぎ 112,500) 6/30/2009 (ぎ 112,500) 9/30/2009 ぎ 2,834,940 12/31/2009 (ぎ 46,260) 3/31/2010 ぎ 3,753,428 6/30/2010 ぎ 3,756,240 9/30/2010 ぎ 3,759,053 12/31/2010 ぎ 6,971,788 3/31/2011 ぎ 4,276,859 6/30/2011 ぎ 5,581,281 9/30/2011 ぎ 5,586,469 12/31/2011 ぎ 5,591,658 3/31/2012 ぎ 2,556,534 6/30/2012 ぎ 2,558,909 9/30/2012 ぎ 2,561,285 12/31/2012 ぎ 2,563,661 3/31/2013 ぎ 2,566,037 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| irr, xirr, npv frustrations | Excel Worksheet Functions | |||
| IRR, XIRR and NPV - a very frustrating problem | Excel Discussion (Misc queries) | |||
| XIRR function | Excel Worksheet Functions | |||
| Problem with XIRR function returning #NUM! | Excel Worksheet Functions | |||
| XIRR and IRR | Excel Worksheet Functions | |||
Threaded Mode
