Saturday, April 07, 2007

Connecting Bottoms of S&P 500

There were 3 major bottoms in the S&P 500 in the last 35 years. These bottoms occured in 1974 at 63.54, in 1987 at 230.30 and in 2002 at 815.28. I am considering month-end prices instead of intra-day prices because we are looking at the history of 30+ years. Assuming that these were indeed bottoms and believing that we would not break below these (especially, 2002) bottoms again; one can start to do some analysis and project where the future bottoms may be found.

Before we start doing any analysis of the numbers, I would like to point out that all 3 major month-end bottoms occurred in month of September and November. So, September 1974, November 1987 and September 2002 had prices listed above for the S&P 500 index.

Let's start our analysis. I want to know which rate of return connects bottoms of 1974 and 1987. That is, if someone bought S&P 500 index at the 1974 bottom of 63.54 and sold the investment at 230.3 in 1987, what would be the price performance of this investment excluding the dividends? The answer is approximately 10.5%. See the table below.

Let's connect the bottoms of 1987 and 2002 with a rate of return. If someone bought S&P 500 index at the 1987 bottom of 230.30 and sold it at the 2002 bottom of 815.28, what would be the price performance of this investment excluding the dividends? The answer is approximately 8.7%. See the table below.

Since the price of S&P 500 index over the long period of time rises by the average GDP + average inflation over that long period, I am assuming that S&P 500 index will rise by 6% in the future. (3% future GDP + 3% future inflation). With this assumption in place, one could see that the 2002 bottom would also move forward at the rate of 6% in the future. This progress at 6% is also calculated in the table below. So, based on this calculation if we were to hit real hard bottom in 2007, the S&P 500 would decline to about 1100, which is somewhere around 20% below today's level.

YearS&P 500 PricePrice Growth RateRate
197463.5410.5%
197570.2110.5%
197677.5810.5%
197785.7310.5%
197894.7310.5%
1979104.6810.5%
1980115.6710.5%
1981127.8210.5%
1982141.2410.5%
1983156.0710.5%
1984172.4510.5%
1985190.5610.5%
1986210.5710.5%
1987232.688.7%
1988252.928.7%
1989274.938.7%
1990298.848.7%
1991324.848.7%
1992353.118.7%
1993383.838.7%
1994417.228.7%
1995453.528.7%
1996492.978.7%
1997535.868.7%
1998582.488.7%
1999633.168.7%
2000688.248.7%
2001748.128.7%
2002813.206%
2003862.006%
2004913.726%
2005968.546%
20061026.656%
20071088.256%
20081153.556%
20091222.766%
20101296.136%
20111373.896%
20121456.336%
20131543.716%
20141636.336%
20151734.516%
20161838.586%
20171948.896%
20182065.836%
20192189.786%
20202321.166%
20212460.436%
20222608.066%
20232764.546%
20242930.416%
20253106.246%

Notes:

  • Table lists estimated bottoms for the S&P 500 price for all years except years 1974, 1987 and 2002.
  • The prices calculated from 2007 to 2025 are estimated bottoms, if they ever occur. You are always welcome to double check my calculations and send comments to me.

Data source: Historical quotes from Yahoo finance.

1 comment:

Paul Chen said...

Looks like right now the S&P500 at 1100 is close to your prediction for 2008 bottom.