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? |
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? |
All times are GMT +1. The time now is 01:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com