Safe withdrawal backtest on supplied annual returns · Calculation guide

Test inflation-adjusted withdrawals against your own sequence of annual returns.

Calculation guide

Withdraw at the beginning of each year, then apply its nominal return and increase next year’s request by inflation. A depleted account cannot go negative. A historical path gives no guarantee for another period.

End balance = (opening balance − funded beginning-of-year withdrawal) × (1 + annual return).

Inputs

Starting portfolio

Example entry 10000 (in the selected currency).

First annual withdrawal

Example entry 1000 (in the selected currency).

Annual spending inflation

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

Annual return

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

Worked example

InputValue
Starting portfolio10,000
First annual withdrawal1,000
Annual spending inflation0%

Annual nominal returns in order

Annual return
10%
-10%
ResultValue
Ending portfolio8,010
Total withdrawals funded2,000
Total spending unfunded0

How each input affects this example

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

InputOriginal inputNew inputAffected resultOriginal resultNew result
Starting portfolio10,00011,000Ending portfolio8,0109,000
First annual withdrawal1,0001,100Ending portfolio8,0107,821
Annual spending inflation0%1%Ending portfolio8,0108,001
Annual return (row 1)10%11%Ending portfolio8,0108,091
Safe withdrawal backtest on supplied annual returns →

Sources