All spreadsheet tools

Sequence-of-Returns Risk: Why the Order of Market Returns Matters in Retirement

An average-return calculator hides this risk completely.

Disclosure: Galaxy Forge sells a $39 spreadsheet that implements this method (see the end of the page). This article is complete on its own, and free alternatives exist.

Two retirees with the same savings, the same spending and the same average return can end up in very different places if the bad years come first. This is sequence-of-returns risk. The examples below are hypothetical illustrations, not forecasts, and ignore taxes, fees and changes in spending; discuss your own plan with a qualified fiduciary adviser.

Why the order matters

When you are withdrawing money, a loss early on is taken from a balance you are also spending. The smaller balance then has less to recover with. The same loss twenty years in, on a larger remaining balance, does far less damage to how long the money lasts.

A worked stress test

A $1,000,000 portfolio at age 62, spending $56,000 a year in today's money with 2.5% inflation, Social Security of $26,000 from age 67 and a pension of $8,000 from age 65. The first-year withdrawal is $56,000, a 5.6% rate.

The average return is similar in all three. What changes is when the loss lands.

Levers worth testing

Spending a little less, delaying Social Security, or holding two years of spending in cash through the early years each change the early-crash result. Test them one at a time.

If you would rather not build it yourself

The workbook for this method has the formulas already built and checked, with an example filled in and a PDF guide. It costs $39, one time. View it on Gumroad.

New product, listed 2026-11-05: no sales or reviews yet. Example figures are illustrative. This page is general information, not legal, tax, financial or professional advice.