Average annual growth rate s&p 500
S&P 500 earnings growth rate per year. Annual current dollars percentage change in 12 month earnings per share, (not inflation adjusted). Average all annual growth rate with entering below formula into Cell F4, and press the Enter key. =AVERAGE(D4:D12) Up to now, Average Annual Growth Rate has been calculated and shown in the Cell C12. Demo: calculate average/compound annual growth rate in Excel. One of the major problems for an investor hoping to regularly recreate that 10% average return is inflation. Adjusted for inflation, the historical average annual return is only around 7%.