Skip to content
The Best Interest » Sequence of Returns Risk – A Simple Example You Can Play With

Sequence of Returns Risk – A Simple Example You Can Play With

Don’t miss an episode of our podcast, Personal Finance for Long-Term Investors. Available on all podcast players.

Here’s the latest episode:


Sequence of returns risk is a great topic for retirement. I’ve discussed it a few different times:

But the only point of this blog post is to share a very simple spreadsheet example that illustrates exactly how it works.

Here’s the spreadsheet. If you’d like your own copy to play with, go to File –> Make a Copy.

Here’s what to look at.

  • You’ll see two examples. A “Good” sequence and a “Bad” sequence.
  • The two examples are identical except for the portfolio returns. They have the same starting values and the same annual withdrawal amounts.
  • The sequences themselves are identical-but-opposite. The “Good” sequence starts at 10% and decays down to (-10%). The “Bad” sequence does the opposite, growing from (-10%) up to 10%. When averaged, these two sequences are IDENTICAL!

So if you have two identical investors with two identical AVERAGE returns, shouldn’t their results be the same?

No!

Because the sequence really matters.

We see here that the “GOOD” investor ends with ~$700K, while the “BAD” investor runs out of money.

By the time the “BAD” investor had any positive returns, their balance was so low that the positive growth still could not keep up with the annual withdrawals.

This is the sequence of returns risk at play.

Thank you for reading! Here are three quick notes for you:

First – If you enjoyed this article, join 1000’s of subscribers who read Jesse’s free weekly email, where he send you links to the smartest financial content I find online every week. 100% free, unsubscribe anytime.

Second – Jesse’s podcast “Personal Finance for Long-Term Investors” has grown ~10x over the past couple years, now helping ~10,000 people per month. Tune in and check it out.

Last – Jesse works full-time for a fiduciary wealth management firm in Upstate NY. Jesse and his colleagues help families solve the expensive problems he writes and podcasts about. Schedule a free call with Jesse to see if you’re a good fit for his practice.

We’ll talk to you soon!

Leave a Reply

Your email address will not be published. Required fields are marked *