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!)