View Single Post
  #1   Report Post  
cs
 
Posts: n/a
Default How do I calculate IRR?

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?