| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want the PMT function to calculate using 360 days not 365 | Excel Worksheet Functions | |||
| 2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
| Not able to calculate. | Excel Worksheet Functions | |||
| "Calculate" note at bottom of my screen? | Excel Worksheet Functions | |||
| How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions | |||
Threaded Mode
