I get 61.62% using your data.



On Tue, 24 Jan 2006 04:49:02 -0800, "bdyer30"
wrote:

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

--ron