suppose collumn C contains the returns for each year. put =log10(1+C5) in collumn, say, N. =10^(average(N5:N14)-1 computes the average compound return of those 10 years.
e.g., ndx96-05 correct return is 10.91% per year, not 19.69% as shown in the spreadsheet.
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.