I'm trying to calculate the IRR. Below is the information

Date of IRR
Investment Date Amounts

1/27/2004 1/31/2004 (9,706,580)
2/17/2004 2/29/2004 (4,888,941)
6/30/2004 6/30/2004 (5,000,000)
7/19/2004 7/31/2004 (6,000,000)
(25,595,521)

here is my formula: =XIRR(Dates(C7:C10), Amount (D7:D10), Guess=0) What
am I doing wrong?

As per the XIRR help topic in Excel help:

XIRR expects at least one positive cash flow and one negative cash flow;
otherwise, XIRR returns the #NUM! error value.

Since you have only negative values and no positives, there would appear to
be no return, only investments going out. What is it you are trying to
achieve?

"cs" wrote in message
...
I'm trying to calculate the IRR. Below is the information

Date of IRR
Investment Date Amounts

1/27/2004 1/31/2004 (9,706,580)
2/17/2004 2/29/2004 (4,888,941)
6/30/2004 6/30/2004 (5,000,000)
7/19/2004 7/31/2004 (6,000,000)
(25,595,521)

here is my formula: =XIRR(Dates(C7:C10), Amount (D7:D10), Guess=0) What
am I doing wrong?