Reply to thread

Message

[QUOTE="enneirda, post: 7405412"]
I have two groups of cashflows, that I detail below.  The XIRR is going to be negative, as when the cash flows are viewed in their appropriate groups the XIRRs are -3% and -6%.  When I try to stream all cash flows for an XIRR, I get 0%, but I want the EXACT NEGATIVE RETURN.  It's like Excel can't calculate a greater negative return.
I've had this problem several times in the past, but had a work around methodology consisting of some long manual calculation (I've since lost that spreadsheet).
Any suggestions?
thank you!

CASH FLOWS:
V1	02/21/2006	(100,000.00)		Investment	
05/23/2006	(265,000.00)		Investment	
08/30/2006	(250,000.00)		Investment	
12/11/2006	(65,000.00)		Investment	
03/20/2007	(93,000.00)		Investment	
07/11/2007	20,140.00		Investment	
11/05/2007	(20,140.00)		Investment	
11/05/2007	(45,860.00)		Investment	
02/06/2008	(100,000.00)		Investment	
07/29/2008	(50,000.00)		Investment	
10/17/2008	(31,140.00)		Investment	
11/21/2006	5,100.00		Distribution	
03/27/2007	5,500.00		Distribution	
07/11/2007	26,500.00		Distribution	
10/01/2007	33,800.00		Distribution	
11/05/2007	(20,140.00)		Distribution	
05/14/2008	29,100.00		Distribution	
05/31/2012	770,000.00		Distribution	XIRR -3.18%
	
VII	09/27/2007	(150,000.00)		Investment	
02/22/2008	(180,000.00)		Investment	
08/07/2008	(155,000.00)		Investment	
10/21/2008	(128,000.00)		Investment	
04/03/2009	(40,000.00)		Investment	
09/18/2009	(155,000.00)		Investment	
10/14/2011	(35,400.00)		Investment	
12/04/2008	10,300.00		Distribution	
10/14/2011	131,600.00		Distribution	
05/31/2012	470,000.00		Distribution	XIRR -8.90%
	
XIRR for VI & VII    0% (NOOOO!)
[/QUOTE]

Verification