Bottoms up retirement planning

Sometimes it pays to go back to basics. With retirement planning it’s no different. The common, top down approach with retirement planning starts with total net worth and then uses a safe withdrawal rate (SWR), most commonly 4%, to figure out how much one can spend per year in retirement adjusted for inflation. See this series of posts if you’re new to this topic. But starting from the bottom, looking at spending first, can add a lot of insight into what investment returns a retiree needs during retirement and allows for the planning of various scenarios. In this post I’ll take you through a simple process that I use to think about various retirement scenarios and what impact those scenarios have on investment returns.

First thing to do is to come up with a simple starting retirement model. For this exercise I’m assuming a 62 year old couple, just retired, with a basic spending requirement of approximately $4K/month, or $48K per year. The couple has $1M in total assets. They also would like to delay taking social security until age 70 to maximize their payouts. At age 70 they would start receiving a total of $2K/month or $24K per year.

To make this basic scenario more flexible and realistic, to the base spending of $48K per year I add a 10% buffer for unforeseen circumstances and factor in a 15% average tax. With these two additions now we’re looking at withdrawing $62.75K per year from the portfolio. If using a 4% SWR from a tops down approach the $62.75K would be way too much. But it may not be necessary to give up on their retirement plans. In 8 years the couple starts receiving $2K/month from social security which needs to be taken into account. In order to do this we need to do a basic spending projection over time. This also allows for other changes in spending later in life. In fact research shows that spending for retirees decreases significantly as they get older.

The data are striking, suggesting that those in the later half of retirement (age 75+ by the BLS data) spend an average of almost 30% less than early retirees (those aged 65-74). In fact, Bernicke shows that this gap has been remarkably persistent over time; the difference is almost the same (on a relative basis) whether you look at the data from 2004, or 1984. The BLS data – along with data from the Health and Retirement Study conducted by the National Institute on Aging that show a smaller but similar decline – have also been widely examined in analysis by the Bogleheads community.

This changing income and spending over time is not part of a tops down model and yet can change the retirement equation entirely. So lets take the basic model and incorporate social security income starting at age 70 and two possible scenarios starting at age 85, no spending reduction and a 20% spending reduction. We’ll take the yearly spending forecasts and come up with an range of investment returns required to make the portfolio last for different longevity periods. I know, it sounds complicated in words but its just a simple excel spreadsheet. To make these models easier to understand I use constant dollars, ignoring inflation for the time being. Below is an example model for a life expectancy of 85.

bottoms up lifetime spending forecast july 2013

For a life expectancy of 85, $62.5K per year spending until age 85, $24K in social security income starting at age 70, and a $1M portfolio these retirees need real investment returns of 1.31% per year. We can then run through various scenarios and come up with a range of real investment returns needed to achieve those various goals. In the table below I modeled I show some results.

bottoms up range of investment returns required july 2013

For those interested I have out the basic spreadsheet model online at Google docs. (see here). I’m pretty sure some of you will add to it and make it better than mine.

The range of annual real returns required varies from 1.31% per year for an life expectancy of 85 to 3.79% per year for a life expectancy of 100 with no spending reduction at age 85. I think this approach gives the retirees a lot more information and confidence than just using a top down 4% SWR and not taking into account potential future spending changes. Armed with this information a retiree can now look at what the investment environment is offering. Once you build this basic model you can run through all kinds of possible life scenarios and think about your plans if those scenarios happen.

On the investment side, lets say this particular couple is very risk averse. A good first place to look for a conservative investment is what 30 year inflation protected bonds are paying. As of this Friday, the 30 year TIP was yielding 1.39%. That is a real yield. In a very risk averse scenario this couple could fund their retirement with 30 year TIPs. On the other end of the spectrum, in the most aggressive retirement scenario this couple could easily fund their retirement plans with a conservative portfolio of dividend stocks yielding 3.79% or higher, achievable even in today’s environment. The point is this range of required real returns allows more flexibility in investment choices, especially considering risk tolerance, than using a tops down SWR model. I’ll come back to the topic of real investment returns in future posts – there is a lot that can be learned from them.

On a personal note, in my plans I have always have a back door, escape scenario. In this scenario, the plan would be for the portfolio to completely run out by age 62, 17 years away for me, when my wife and I would begin living on our social security only. In order to make this work more easily the plan involves moving overseas in order to cut living expenses. Most likely we would move to Southeast Asia, possibly Thailand, where we could live on our social security and still maintain a very nice lifestyle. Maybe even Argentina so my wife, Nina, could finally learn Spanish. We’ve done this type of thing before for several months at a time and its highly do-able. For us having this plan gives us a huge sense of comfort, peace of mind, and freedom.

In summary, some simple bottoms up retirement scenario planning is easy to do and can give you some valuable insight. Most importantly it allows you to plan future changes in your retirement spending and income. It also allows you to figure out what investment returns you need to fund your retirement goals instead of taking for a given what the historical market portfolio has allowed in withdrawals. You may not need as much as you think.

P.S. In a future post I’ll address two real common fear mongering topics – the death of social security and runaway inflation.

Full Disclaimer - Nothing on this site should ever be considered advice, research or the invitation to buy or sell securities. These are my personal opinions only.

This entry was posted in Retirement and tagged , . Bookmark the permalink.

13 Responses to Bottoms up retirement planning

  1. donzidoug says:

    Paul, Its very timely to have received your post today as I just setup an account with Social Security to start tracking my various withdrawal options. At 61 now I will be eligible to begin withdrawals next year. Although we do not need the income now it seems like taking it at the earliest opportunity may be my choice and here is why.

    At 62 Social Security will begin to refund 1700 each month my way. At 70 that number goes up to 3000. At 1700 a month for 20 years the total would be 448800. After 12 years of withdrawals at 3000 a month would put as at 432000. So if I’m looking at this correctly I would have to collect until the age of 82 to be even with the increased refund amount attained by waiting the 8 years.

    Current life expectancy tables show me living another 20 years. I’m healthy, exercise, don’t smoke or drink excessively and keep my weight down I do expect to beat that number. But the calculations do not include gains if I invest the 1700 a month from age 61.

    Anyway I hope this is clear. I threw my back out and the muscle relaxers are making me a bit cloudy but please show me where I’m going wrong here.

    Thanks for all you do Paul!

    • Bob says:

      Since you are married, I assume, look closely at the file and suspend options as they may provide you more total income over your lifetime. These are good options sometimes since you don’t need the money. Good luck to you.

      • libertatemamo says:

        Thanks for the tip Bob. There are a lot of complexities in what on the face of it seems to be a simple decision.


    • libertatemamo says:

      Hi Doug,

      Deciding when to take social security is a pretty complex topic. I’ve been through the process a couple of times with family members. There’s a ton of rules and gotchas in the process. The best thing I’ve read on it is here. This piece of software for $40 is well worth this big decision.
      I had my dad take benefits at 62, then repay them back at 66, and take the higher benefit at 66. But every situation is different.

      The one thing I can say is that it usually pays to wait to take benefits. And here’s why – its not just about the dollars. In a way social security is like buying longevity insurance. It may not be probable that you live way past 82 but its possible. The way actuarial tables work is that as you get older your life expectancy goes up, it does not stay the same. And one of the biggest risks we have as we get older is running out of money. When you delay taking social security you increasing your income ‘for the rest of your life’ adjusted for inflation. And the increase in income by delaying is ‘guaranteed’, no need to worry about market fluctuations and such. They say it works out to be about an 8% a year guaranteed return.

      My 2 cents anyway…


  2. Great tips for those who can and are overwhelmed by retirement planning.

  3. Brian Bishop says:


    Just FYI incase you didn’t know, you could also pay all of your “principle” back to SS @ age 70, keeping the investment returns from the money they “loaned” you, and still collect your increased benefit at age 70 just as if you didn’t start taking benefits until age 70. Just some food for thought. 🙂


  4. wei says:

    hi paul.

    regular reader but 1st time commenter.

    talking about your escaping door of relocating to cheaper countries, what about the medical expenses? In US, we’ll have Medicare. I don’t think we’ll receive similar benefits.

    thanks a lot for keeping the blog going. it helps me a lot.


    • libertatemamo says:

      Hi Wei, thanks for the comment.

      Turns out that insurance is not that big an issue when living overseas. At least we have not found that. There are any international
      insurance options. When we live in Hong Kong we had an international insurance plan, from BUPA International, that cost us about
      $2,500 a year. That was in 2007 so we were a bit younger but I had a 60+ friend who paid about $4,000 a year. All very reasonable.
      I know people in Singapore, Thailand, Philippines who have similar type plans. Many older Americans go to central or south america
      as well.

      Considering Medicare supplemental insurance runs about $200-$250 a month we’re not talking that much in incremental premiums. In particular
      when the rest of your living expenses go down by thousands of dollars. I figure my wife and I could live in Thailand comfortably for $1,500
      a month and like kings for $2,500 a month.


  5. Don says:

    Paul, Thank you for the link to your spreadsheet. Please help me find where the calculation is that results in the 1.31% required return. When I check the cell where this resides I find it was input instead of being the result of a formula.


    • libertatemamo says:

      Don, B3, the Overall Rate of Return, is the main input that is changed in the spreadsheet once you set the spending data.
      So, the way it works is you enter different rates of return in B3 until the value of the portfolio at a certain age gets to zero.
      1.31% is the percentage return where the portfolio gets to zero at 85 years old. If for example you want to see what return you need
      for the portfolio to last to 95, you start entering higher percentage returns until cell J9 gets to zero. You’ll find that number to be
      2.77% as I showed in the highlighted table.


  6. Jeff M says:

    the link below is for a pretty fancy retirement calculator spreadsheet that i thought you would find interesting:

  7. Pingback: Higher Safe Withdrawal Rates from a 100% Bond Portfolio? | Investing For A Living

Comments are closed.