How do I calculate IRR?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 (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?
 
Back
Top