Sequence-of-returns withdrawal comparison · Calculation guide

Compare the same annual returns in the entered order and in reverse.

Calculation guide

Apply each return and then withdraw a fixed annual amount or the remaining balance, whichever is smaller. Once depleted, the account stays at zero. No deposits, fees or inflation adjustments.

Bₜ = max(0, Bₜ₋₁ × (1+rₜ) − W); paidₜ = min(W, Bₜ₋₁ × (1+rₜ))

Inputs

Opening savings

Example entry 1000 (in the selected currency).

Planned year-end withdrawal

Example entry 200 (in the selected currency).

Annual return (%)

Example entry 0 %. Allowed range -100.0 to 1000.0.

Worked example

InputValue
Opening savings1,000
Planned year-end withdrawal200

Annual returns in order

Annual return (%)
100%
-50%
ResultValue
Closing balance in entered order700
Closing balance in reverse order400
Withdrawals paid in entered order400
Withdrawals paid in reverse order400

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Opening savings1,0001,100Closing balance in entered order700800
Planned year-end withdrawal200220Closing balance in entered order700670
Annual return (%) (row 1)100%110%Closing balance in entered order700750
Sequence-of-returns withdrawal comparison →