Thread: XIRR Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marc Marc is offline
external usenet poster
 
Posts: 70
Default XIRR Error

I have the following:

1 Jan 2007 , -10000
1 Jan 2008 , 2000

I get XIRR as -80%. I understand that.

If I have the following:
1 Jan 2007 , -10000
1 Feb 2007, -10000
1 Jan 2008 , 2000

I get -91%. I understand this as well.

But, when I have the following:
1 Jan 2007 , -10000
1 Feb 2007, -10000
1 March 2007, -10000
1 Jan 2008 , 2000

I get 0%. Why?