One thing that has always bugged me about retirement calculations is the lack of detail in most of the retirement data and recommendations. Take for example, the 4% safe withdrawal rate that I’ve discussed here many times in the past. The 4% rule says that 4% is the maximum amount you can withdraw from your portfolio (based on a 60% stock, 40% bond), inflation adjusted, and be relatively assured that you won’t outlive your assets. Great, but what about the trade-offs? What about different allocations to stocks and bonds? How much risk should you expect? Hmmm, no real answers to those questions unless you sit down with an adviser  pay them some money usually, and even then won’t get very good answers. At least not for me. So, I’ve spent the last few months building my own database of investment returns going back to 1929 to answer some of these questions. Lets take a look at what I’ve found so far.

I had four big questions going into my analysis. For what investment allocation is the SWR the highest (is it really 60% stocks, 40% bonds)? How does a changing investment allocation impact the SWR? What risk am I taking for a given investment allocation? And what is the average end value of the retirement portfolio? I constructed a database of stock market returns (SP500), bond returns (US 10 year bond), and inflation (CPI) going back to 1929 and built annually re-balanced portfolios. Here are the results.

Investment allocation vs SWR vs avg end wealth 1929 to 2011 dec 2012

 

OK, lets take each question one by one. At what allocation is the SWR the highest? The answer is 70% stocks, 30% bonds which gives an SWR of 4.39%. How does a changing allocation impact the SWR? As the table shows, the investment allocation vs SWR relationship is a curve starting at a low of 2.5% for a 100% bond portfolio, climbing to a max of 4.39% at 70% stocks, and declining again to 3.66% at 100% stocks. More risk doesn’t always buy you more reward in retirement and vice versa. Next, lets look at risk. I like to look at risk in terms of max drawdown, i.e. what was the maximum peak to trough decline in the value of the portfolio during the retirement period. As you can see drawdown is pretty much directly correlated to how much you have allocated to stocks. For example, for the 70% stock portfolio, at one point during a 30 year retirement period the initial portfolio value declined by 47%. This was for the 1929 retiree. Lastly, even though by definition all the retirees had enough assets for a 30 year retirement, the average end values of the portfolios varied considerably. Again, via example, for a 70%/30% portfolio, the 4.39% SWR was solely determined by the 1966 retiree who ended up at the end of 30 years with $10,000 in assets, just making it through retirement. But on average, across all 54 30 year retirement periods studied, the average end value of the portfolios was $5.72 million. These are the assets that could be passed on to heirs, charities, etc… So, great you might say, now what?

Armed with more data now you can make better informed retirement planning decisions. While 70%/30% may give you the highest SWR, will you be able to emotionally withstand a potential drawdown of 47% in your portfolio? Or would you be able to sleep better at night with a 40%/60% allocation with a lower SWR of 4.15%, a drawdown of less than 20% but an average ending wealth of less than half of the 70%/30% portfolio. These are highly personal decisions and there is no one answer but I think they are critical parameters in deciding what’s best for your retirement assets.

Armed with more detailed investment allocation data and its impact on retirement can help retirees make better informed decisions more tailored to their individual desires and circumstances. Now that I’ve created my own personal database of historical returns I have reams of data the I hope to bring to bear on investing during retirement. Stay tuned for more. Please let me know if their are any particulars you’d like to see.


6 Comments

douglas knight · December 18, 2012 at 4:58 am

Congratulations on completing your excellent database and analysis. I completed a 15 year review of 9 asset classes based on market index returns and plan to publish a calculator after receiving permission from the index providers. My interest is in designing index fund portfolios. You are asking a very important question about the SWR that is useful to all of us. Do you plan to publish a calculator?

    libertatemamo · December 18, 2012 at 9:43 am

    Hi Doug, Thanks for the comment. Yes, I am thinking about doing a calculator at some point. Right now its just very big excel spreadsheets. My interests lie in helping retirees pick the an SWR that’s right for their situation and also to help them maximize their SWR by choosing ‘better’ portfolios.

    Paul

Greg · December 20, 2012 at 11:45 am

Given that the 10-year treasury rate is less than 2% today and that average bond returns going forward will be less than the historical average, how should this impact everyone’s asset allocation?

    libertatemamo · December 21, 2012 at 7:56 am

    Hi Greg, I agree that bond returns going forward will be lower than the historical avg. The SWRs from the historical data going back to 1929 should hold up. After all these SWRs held up during the biggest bear bond market in history as well, basically the 30 year period ending in 1981. In 1940 the 10yr bond was yielding 2.01% and it ended 1981 at 13.7%. These SWRs held up for every retiree in those periods. It turns out that SWRs are more sensitive to equity returns than bond returns – bond mainly serve to reduce drawdowns.

    This is one big reason I like to see data going back as far as possible. You want to see many cycles in the data not just a big bull market or a big bear market.

    Paul

How life-cycle retirement models impact your retirement « Investing For A Living · December 26, 2012 at 10:46 am

[…] up with friends, and just having an overall relaxing time. Today I wanted to follow up on my last post on investing allocation during retirement. Here I want to take a look at the traditionally […]

An IVY Buy & Hold Portfolio for the Skeptical & Emotional Investor | Investing For A Living · September 20, 2013 at 9:59 am

[…] an overall allocation of 70% stocks and 30% bonds because that’s the allocation that has the highest SWR historically. I also used the IVY 13 portfolio as a basic model which I’ve discussed previously. For […]

Comments are closed.