xirr function

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Hi,
I am using the xirr function and when I enter a large number the result
reverts to 0%. Anyone know why? Any help would be appreciated.
Thanks, Jim
 
Hi,
I am using the xirr function and when I enter a large number the result
reverts to 0%.  Anyone know why?  Any help would be appreciated.
Thanks, Jim
Click to expand...

If the number is negative (the sum of the cashflow) you need to
provide a negative guess in order for the XIRR function to work. But
not sure this is the problem you have encountered.
 
Back
Top