Update: Political Calculations has mapped the extremes in market performance for the S&P 500 too!
Compared to determining the effective return that an average "investor" can expect to earn from their "investment" in Social Security, working out the best and worst case investment returns from investing in the stock market turned out to be a breeze!
It turns out that there are whole bodies of scholarly work that have been done in this area with results that have been posted on the Internet. There are two sources I recommend. The first is an excerpt from mutual fund pioneer John Bogle's book, Bogle on Mutual Funds that shows the general trend between investment holding period and the best and worst case performance of the stock market between 1926 and 1992.
The second source, an interactive example provided by the Foundation for Investor Education, takes inflation-adjusted stock market performance data for a variety of holding periods from work done by Wharton School professor Jeremy Siegel, whose book, Stocks for the Long Run covers his research into the history of U.S. stock market returns since 1802. The following table shows Siegel's best and worst case historical stock market returns, which have been adjusted for inflation:
| Inflation Adjusted Stock Market Annual Rates of Return | ||
|---|---|---|
| Holding Period (years) | Worst Case (%) | Best Case (%) |
| 1 | -38.6 | +66.6 |
| 5 | -11.0 | +26.7 |
| 10 | - 4.1 | +16.9 |
| 20 | + 1.0 | +12.6 |
| 30 | + 2.6 | +10.6 |
I used Siegel's data to create the best and worst case, inflation-adjusted, stock market performance formulas below, using various regression techniques available in Microsoft Excel (and some other mathematical manipulation) to come up with the equations:
In these equations, "Holding Period" represents the number of years that the stock market investment is held. Investors should note that Siegel's work is based on the performance of the entire U.S. stock market, which today may be best be tracked through the performance of the diversified Wilshire 5000 stock index. I've provided a simple calculator that performs this math below for reference:
Additional Note: Since the formulas are based on a limited number of data points, the results calculated will only approximate historical inflation-adjusted rates of return over time, with greater differences between historical and calculated results at very short holding periods, a result of the regression method. For long term results, the formulas also deviate from what would be expected due to the limited number of data points used to create the formulas (after 93 years, the worst case calculated return is higher than the best case calculated return!) As a result of this long term conflict with reality, I arbitrarily placed the effective long-term useful limit of the formulas at a holding period of 75 years for the Social Security versus Private Retirement Accounts comparison calculator, which should provide reasonably good approximations of returns without too great a discrepancy with what would actually occur in real market performance.
Update: Want to see what the future value of a fully diversified stock market investment might look like if you consecutively kept having the best or worst market performance over time? Take the Lemony Snicket vs. King Midas challenge today!
Update 30 July 2007: We've gone way beyond this tool! For the most recent analysis we've done, see our following posts:
- The Worst Returns of the S&P 500 vs The Safest Investments on Earth
- The S&P 500's Golden Years - Did you ever wonder about the best bull years the stock market ever had? We find the best 1 through 50 year periods ever!
- The Worst Returns Ever for the S&P 500 - We identify the dates that go along with the worst returns ever (after inflation) for the S&P 500!
- The S&P 500 at Your Fingertips - Our signature tool provides historical market data for the S&P 500 going all the way back to January 1871, and finds the rates of return between any two months both before and after inflation and with or without dividend reinvestment!
- Lemony Snicket and the S&P 500 - Our tool that takes the best, worst and most average investment returns ever from the S&P 500, and asks what if your investments had these returns?
- Mapping S&P 500 Performance, Since 1871 - our analysis that lead to our model of the best and worst case performance ever for the S&P 500.
- S&P 500: Best, Average and Worst Returns - our tool approximates the best, worst and average returns for investments of any length in the S&P 500 stock market index.