|
#8
| |||
| |||
| Greg Hennessy wrote: - quote - > > You're right, using Shiller's spreadsheet, the average annual return for
Using Shiller's data it's a little over 2% per year. But given my> > the period 1871 - 2004, including dividends, is 10.7%, which nicely > > matches the things I've read. > Do you have any idea of the inflation rate for that time? recent track record, you better check my math. -Will |
|
#7
| |||
| |||
| In article <42AB67F0.8060709[at]paragondynamics.com> , Will Trice <wwtrice[at]paragondynamics.com> wrote: - quote - > You're right, using Shiller's spreadsheet, the average annual return for
Do you have any idea of the inflation rate for that time?> the period 1871 - 2004, including dividends, is 10.7%, which nicely > matches the things I've read. |
|
#6
| |||
| |||
| beliavsky[at]aol.com wrote: - quote - > I get a considerably higher number for the compound annual returns over
You're correct, I bungled the reinvestment of dividends (I forgot to> the period 1871 to 6/2004. I compute monthly log returns including > dividends using > monthly_log_return = log(new_price + annual_dividend/12)/old_price > Then, the compound annual return is > exp(12*mean_monthly_log_return) - 1 > = exp(12*0.007277) - 1 > = 9.12% > The "variance drain" due to fluctuating returns is 0.5*volatility^2, > which for annualized volatility of 15% (an approximate number) works > out to about 1.1%. The annual differential should be considerably less > than the you are getting. grow the amount of dividend received with the result of the dividend reinvestment). This also puts the geometric average since 1932 at 12.5%. I'll just be quiet now and let you grown-ups carry on your conversation... Thanks again, B. |
|
#5
| |||
| |||
| - quote - > So is the 11% number an urban legend?
No.- quote - > Or am I just looking for answers
Yes, for Pete's sake, don't use the DJIA. It is a mathematically and> in the wrong places? statistically meaningless index. It is also very difficult to calculate dividends properly into the calculation, so it is likely that you did not calculate them the same way. - quote - > What time period (and benchmark) is it necessary
Go to the library and find the book Ibbotson Stocks, Bonds, Bills, and> to look over to reveal an average 11% return? Inflation. Almost all financial articles quote from this reference book. It uses the S&P 500 (and equivalent) indexes. Their data starts from 1926. Annual total returns for large cap stocks: 1926-1999 11.35% 1926-2002 10.20% 1926-2004 10.43% 1930-2004 9.98% Since many of the articles that we read were around 1999, the annual return rate was over 11% at that time. After the bust, it dipped to as low as 10.20% in 2002. Another reason was that in 1926-1928, there was a big boom, so if you start counting in 1930, that lowers the historical rate as well. |
|
#4
| |||
| |||
| Will Trice wrote: - quote - > beliavsky[at]aol.com wrote:
I get a considerably higher number for the compound annual returns over> > > Robert Shiller makes available at > > http://www.irrationalexuberance.com/ie_data.xls a useful spreadsheet > > with monthly data on stocks, bonds, and inflation, including the S&P > > 500 price level and dividend level. Using his data, I find that the > > average MONTHLY total return on stocks from 1927 to 2004 is about > > 0.93%, using the formula > > > monthly_total_return = (new_price + annual_dividend/12)/old_price - 1 > > > Annualizing the 0.93% monthly return gives an annual return close to > > 11%. > > You're right, using Shiller's spreadsheet, the average annual return for > the period 1871 - 2004, including dividends, is 10.7%, which nicely > matches the things I've read. Going back to the Yahoo DJIA data I > noticed that the "Adjusted Close" column, which is supposed to include > dividends, is identical to the "Close" column, so it must not be > adjusted. That was the problem with my calculations (thanks, B). But... > Just for fun, I looked at the annualized return for the entire period on > Shiller's spreasheet, reinvesting dividends. The annualized return is > only 5.7%! This is astounding that the geometric average would be so > much less than the arithmetic average. the period 1871 to 6/2004. I compute monthly log returns including dividends using monthly_log_return = log(new_price + annual_dividend/12)/old_price Then, the compound annual return is exp(12*mean_monthly_log_return) - 1 = exp(12*0.007277) - 1 = 9.12% The "variance drain" due to fluctuating returns is 0.5*volatility^2, which for annualized volatility of 15% (an approximate number) works out to about 1.1%. The annual differential should be considerably less than the you are getting. |
|
#3
| |||
| |||
| beliavsky[at]aol.com wrote: - quote - > Robert Shiller makes available at
You're right, using Shiller's spreadsheet, the average annual return for> http://www.irrationalexuberance.com/ie_data.xls a useful spreadsheet > with monthly data on stocks, bonds, and inflation, including the S&P > 500 price level and dividend level. Using his data, I find that the > average MONTHLY total return on stocks from 1927 to 2004 is about > 0.93%, using the formula > monthly_total_return = (new_price + annual_dividend/12)/old_price - 1 > Annualizing the 0.93% monthly return gives an annual return close to > 11%. the period 1871 - 2004, including dividends, is 10.7%, which nicely matches the things I've read. Going back to the Yahoo DJIA data I noticed that the "Adjusted Close" column, which is supposed to include dividends, is identical to the "Close" column, so it must not be adjusted. That was the problem with my calculations (thanks, B). But... Just for fun, I looked at the annualized return for the entire period on Shiller's spreasheet, reinvesting dividends. The annualized return is only 5.7%! This is astounding that the geometric average would be so much less than the arithmetic average. I know that in the presence of volatility the arithmetic average is going to be higher than the geometric, but this is a BIG difference. Using data from 1932 on (since the Crash bottom) gives an annualized return of 8.8%, which is better, but not close to 11%. This leads to the question, how did Shiller come up with his benchmark data prior to WWII? The actual S&P benchmark didn't start until after WWII, right? If this data is accurate, and if future stock price increases will be something like the past, I think many investors are going to be overestimating their returns, even if the returns do average ~11%. Yikes! So another question, why isn't the geometric average annual return used more often for forecasting the price growth of an asset rather than the arithmetic average? After all, it seems that the geometric average builds in volatility which the arithmetic average does not. -Will |
|
#2
| |||
| |||
| Will Trice wrote: - quote - > While reading anoop's thread, "understanding risk," I took the data
Will,> behind his chart (DJIA) and played with it in a spreadsheet. He > mentioned that the average annual return for stocks is 11%, a number > I've heard myself. But playing with the spreadsheet, I'm not seeing > that average. > So is the 11% number an urban legend? The 10%-11% figures you've seen reflect not only dividends but also reinvestment of dividends - did you include that? With the high dividend rates that were present during much of that time period, there's a lot of additional money in the system...representing additional shares that both gained in value and earned additional dividends. -Tad |
|
#1
| |||
| |||
| "Will Trice" <wwtrice[at]paragondynamics.com> wrote in message news:42AA72E6.9030003[at]paragondynamics.com... Further, the *maximum* 30 year average - quote - > annual return is 10.4% (for the period of 1970 - 2000), still short
I'd always heard 10.8% for the last 30 years, very close to what you've> (barely) of the often quoted 11%. Maybe this is an artifact of the > DJIA, but checking the Wilshire 5000 reveals similar results. found in your research. I've only heard 11% on this newsgroup and that looks to be rounding up, probably for simplicity's sake. Elizabeth Richardson |
| | |||
| |||
| Will Trice wrote: - quote - > While reading anoop's thread, "understanding risk," I took the data
<snip> behind his chart (DJIA) and played with it in a spreadsheet. He > mentioned that the average annual return for stocks is 11%, a number > I've heard myself. But playing with the spreadsheet, I'm not seeing > that average. - quote - > So is the 11% number an urban legend? Or am I just looking for answers
Robert Shiller makes available at> in the wrong places? What time period (and benchmark) is it necessary > to look over to reveal an average 11% return? http://www.irrationalexuberance.com/ie_data.xls a useful spreadsheet with monthly data on stocks, bonds, and inflation, including the S&P 500 price level and dividend level. Using his data, I find that the average MONTHLY total return on stocks from 1927 to 2004 is about 0.93%, using the formula monthly_total_return = (new_price + annual_dividend/12)/old_price - 1 Annualizing the 0.93% monthly return gives an annual return close to 11%. |
|
#-1
| |||
| |||
| While reading anoop's thread, "understanding risk," I took the data behind his chart (DJIA) and played with it in a spreadsheet. He mentioned that the average annual return for stocks is 11%, a number I've heard myself. But playing with the spreadsheet, I'm not seeing that average. Looking at the data, using monthly closes and including dividends, it seems that the average annual return for the period of 1930 through 2004 is only 7.4%. Further, the *maximum* 30 year average annual return is 10.4% (for the period of 1970 - 2000), still short (barely) of the often quoted 11%. Maybe this is an artifact of the DJIA, but checking the Wilshire 5000 reveals similar results. So is the 11% number an urban legend? Or am I just looking for answers in the wrong places? What time period (and benchmark) is it necessary to look over to reveal an average 11% return? -Will |
| Tags |
| annual, average, returns, stock |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| Annual Returns Calculation AnotherBogie: Money states the following: An annualized percentage return is the annual profit on an investment as a percentage of the amount invested. Money... | Microsoft Money | 2 | 01-02-2006 04:56 PM | |
| Displaying ACTUAL stock purchase prices not AVERAGE stock prices. Rocker: Hello, Money 2004 is displaying the average purchase price of a security instead of displaying the actual cost of the security. The problem is... | Microsoft Money | 4 | 04-30-2004 02:18 PM | |
| Stock quote returns -99.900 Jim Jacobs: After working just fine for several months, I am now getting a bogus stock quote for just one of my investments. The Last Price returned is... | Microsoft Money | 1 | 09-11-2003 08:09 AM | |
| Thread Tools | |
| Display Modes | |
| |