I am looking for a formula that will calculate annualized return.
Specifically, I have the annual returns for the S&P 500 from 1976 through
2005. I would like to be able to calculate the annualized (compounded or CAGR)
rate of return over various time frames. There is no formula listed under
tools for Annualized return or CAGR in excel. Geo metric mean (GEOMEAN) is
the closest option but it will not take negative numbers. Can anybody help?

thanks,

evanolsen[at]msn[dot]com