economics investment

Investment Returns Spreadsheet

I compiled from a few different sources a set of historical investment index returns from the late 1800s to the early 2000s. To be clear, the amount of work I put into this was only a couple hours. If you want a convenient way to see this data, click here.

I found three estimates of typical stock returns that included annual data from at least 1891 until at least 2012. The three overall averages were 6.2%, 6.4%, and 6.5%, showing a broad level of agreement between the three datasources.

Because CPI is biased upwards. If we use the GDP deflator methodology, for instance, these estimates increase by by about 0.5%. This still leaves other forms of bias unaccounted for. Altogether, then, it seems likely that true inflation-adjusted returns have averaged around 7%, maybe a smidge higher.

After accounting for risk aversion, the risk-adjusted estimate is about 0.5pp lower: probably around 6.5%. Assuming you don't use various tax avoidance strategies, the after-tax, risk-adjusted estimate falls by another ~1.4pp (assuming 2% inflation) to a smidge over 5%.

TODO:

  • I need to include international financial markets in the analysis. I recall seeing a dataset that cost a lot of money that had international returns going back about a century. I'm not willing to drop thousands of dollars on this, but this suggests that international returns also go back a long time - I just need to find them.
  • See also Damodaran
  • This paper Fundamental Credit Special has a table of decade-based US corporate bond returns back to 1900 on page 10. They also have a graph that strongly suggests the authors have access to annual returns, but I can't find them on the internet. They claim corporate bonds have averaged 2.2% real annual returns sine 1900. This is barely better than treasury bonds (1.5%), so I doubt non high-yield "junk" bonds are a sensible investment. As a sanity check on their data, they suggest equities have averaged 6.0% real returns, which is virtually identical from the returns given by Macrohistory. The other data I found on the topic was a graph of overall bond yields going back to 1926 When will we get back to average market returns. I've included that data (transcribed to numeric form) in the aforementioned spreadsheet. It generally also finds quite low returns (~2.5%), which confirms my general feeling that bonds are a poor investment.
Shiller, J. Online Data Robert Shiller. http://www.econ.yale.edu/~shiller/data.htm Karsten. (2018). EarlyRetirementNow SWR Toolbox v2.0 - save your own copy before editing! https://docs.google.com/spreadsheets/d/1QGrMm6XSGWBVLI8I_DOAeJV5whoCnSdmaR8toQB2Jz8/edit#gid=1084562995 (see also https://earlyretirementnow.com/2018/08/29/google-sheet-updates-swr-series-part-28/) Compound Annual Growth Rate (Annualized Return). http://www.moneychimp.com/features/market_cagr.htm Jordà, Ò., Schularick, M., and Taylor, A. Jordà-Schularick-Taylor Macrohistory Database. Macrofinance & Macrohistory Lab. http://www.macrohistory.net/data/ Reid, J., Burns, N., Ademakinwa, A. (2008). Fundamental Credit Special: 100 Years of Corporate Bond Returns Revisited. Deutschce Bank. https://www.wertpapier-forum.de/applications/core/interface/file/attachment.php?id=115609 When will we get back to average market returns?. (2018). Vanguard. http://www.bairdfinancialadvisor.com/thebeckgroup/mediahandler/media/155669/21%20When%20Avg%20Mkt%20Returns%20_Vanguard_.pdf Damodaran, A. (2020). Historical returns: Stocks, Bonds & T.Bills with premiums. http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/histretSP.html