How do I calculate IRR?

[Guest]

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 (D710), Guess=0) What
am I doing wrong?

 

[Michael Malinsky]

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?