View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dick in SL
 
Posts: n/a
Default How to calculate CAGR for mutual fund performance using XIRR

Using Excel 2003. I am getting results that does not seem correct. I am
entering the beginning fund balance with a negative sign in cell A2 and the
increase in fund values each year in cells A3 to A5. Dates are all 12/31/xx
using DATE in cells B2 to B5.

Values are -8580, 2004, 619, 464 and the result is 46.82%

Using CAGR calculation in Investopedia.com I get 10.78%

What am I doing wrong in ExceL?

Thanks