XIRR

[gellersj]

1990 4.9
1991 5.3
1992 6
1993 5.5
1994 5.2
1995 5.4
1996 6.2
1997 7.2
1998 8.2
1999 9.5
2000 11
2001 12.9
2002 15
2003 17.4
2004 19.7
2005 23.3
2006 27.2
2007 30.1
2008 32.8
2009 35
2010 37.7
2011 40.8
2012 44.4
2013 48.6


I've been using this data set to find the XIRR from 2000 to 2010 and a number error continues to be returned. A colleague and I have no idea what went wrong as we've used the exact data before for a model. What is going wrong?

[vitoch]

Feel free to send me your spreadsheet and I'll take a look at it. I would need to see the formulas

joet at newyorkinteractivemedia.com