Drawdown Recovery Calculator

Purpose and model boundary

This calculator looks at a fall from a peak in three ways. First, the gain needed to get back: a balance that falls 35% needs a 53.85% gain to return to its high, and one that falls 50% needs 100%. Second, how long the recovery takes: the number of months until the balance is back at its peak at three yearly returns you choose, with any amount you add each month. Third, why the timing of a fall matters to someone drawing an income: the same fall, once in the first year and once in the tenth year of a plan that withdraws a fixed amount each year, against the same plan with no fall. The main result is the gain needed.

Here a drawdown means a fall from a previous high, not a withdrawal from savings; for a plan that draws an income from a balance, use the Retirement Drawdown Withdrawal Calculator. The Monte Carlo Retirement Success Calculator simulates the order of returns over many possible futures, the Kelly Criterion Position Sizing Calculator simulates falls from a peak for repeated bets, and the Compound Interest Growth Calculator grows a balance at a steady rate.

Every figure on this page is computed by the spreadsheet; the page adds nothing to it. Nothing here is simulated: each result follows from the figures you enter. The model is educational. It is not a forecast of market returns, and it is not financial, investment, tax or legal advice.

Inputs and units

• Fall from the peak, from 1% to 95%: how far the balance has fallen from its highest value, as a share of that high. A fall from $500,000 to $325,000 is 35%.
• Balance at the peak, in dollars, up to 1 trillion: the highest value before the fall. The withdrawal plan also starts from this balance.
• Lower yearly return, your expected yearly return and higher yearly return, each from -20% to 30%: steady compound rates to compare. The withdrawal plan earns your expected return in every year without the fall.
• Amount added each month, in dollars, optional: money added at the end of every month while the balance recovers. Leave it blank to add nothing.
• Yearly withdrawal in the plan, in dollars, the same in every year and taken at the start of each year; 0 shows the plan with no withdrawals.
• Years of withdrawals, a whole number from 10 to 50. The late fall comes in year 10, so the plan is at least 10 years long.

Money is in US dollars; falls, gains and returns are percentages.

Governing relationships

A fall L from the peak leaves (1 − L) of the balance, so the gain needed to get back is

gain = L ÷ (1 − L)

Each yearly return r is applied monthly as the factor F = (1 + r)^(1/12), and an amount c is added at the end of each month. Starting from the balance after the fall, B(0) = peak × (1 − L), the balance after month m is

B(m) = B(m − 1) × F + c

The spreadsheet steps this balance month by month for up to 1,200 months, 100 years, at each of the three returns. The months to get back are the first month in which the balance is at or above the peak. A balance within one part in a billion of the peak counts as back, so that a recovery landing exactly on the peak reads the same month on every engine. If the balance is not back within 100 years, which happens when the return is 0 or below and too little is added, the months read 1,200. With nothing added, the months are the logarithm of 1 ÷ (1 − L) divided by the logarithm of F, rounded up; the table shows these months beside yours, so you can see what the money you add is worth. Money added counts toward getting back: the balance is back at its previous high, counting the amounts added.

The withdrawal plan starts at the balance at the peak. Each year it takes the withdrawal at the start of the year, or what is left if the balance is smaller, and then earns that year's return:

S(t) = (S(t − 1) − min(W, S(t − 1))) × (1 + g(t))

where g(t) is your expected return in every year except the year of the fall, which loses L. One plan has the fall in year 1, one in year 10 and one has no fall. The two plans with a fall hold the same set of yearly returns in a different order, so without withdrawals they end at exactly the same balance. With withdrawals they do not: money taken out after an early fall leaves less to share in the later growth. A year counts as lasted when the plan paid the full withdrawal.

Calculation sequence

The spreadsheet first checks every input. It then computes the gain needed, steps the three monthly balances for 1,200 months and counts the months to get back, computes the months with nothing added, builds the table of falls from 10% to 60% with your own fall, runs the three withdrawal plans year by year, and reads the results. A block of consistency checks confirms the arithmetic, including that the month count agrees with the closed form above, before the status is returned.

Outputs and interpretation

The headline is the gain needed to get back to the peak. The cards show the months to get back at the lower return, your expected return and the higher return, and the plan balance at the end with the fall in year 1 and with the fall in year 10. The recovery table gives each return's months and years, the months with nothing added and a note; the table of falls shows the gain each fall from 10% to 60% needs, and yours; the plan table gives the three plan balances year by year. The balance after the fall, the plan balance with no fall, the cost of the fall coming in year 1 instead of year 10, the years of full withdrawals in each plan and the workbook's self-check are returned to the API and MCP.

Under the default inputs, a 35% fall on $500,000 with nothing added, the balance needs a 53.85% gain: 106 months at 5% a year, 77 at 7% and 60 at 9%, about 8.8, 6.4 and 5.0 years. A plan withdrawing $20,000 a year for 30 years at 7% ends with $739,781.18 when the fall comes in year 10 but only $350,432.47 when it comes in year 1, against $1,784,666.69 with no fall. The fall is the same size in both; only its timing differs.

The first chart pairs each fall, in red below zero, with the gain needed to undo it, in blue. The second draws the balance as a share of the peak at the three returns, with a dashed line at 100%; its window grows in steps of 10 years until it holds the slowest return that gets back within 100 years. The third draws the three plans year by year.

Validation and status logic

The workbook evaluates the conditions below from top to bottom and returns the first matching status.

NOT VALID is a refusal, not a numeric answer: every number reads zero and the tables are empty. CHECK accompanies a computed result but calls for the stated review; returns out of order still give correct figures for each return. A plan that runs out of money is a result, not a check. The self-check is reported separately as arithmetic-integrity evidence; it does not replace this ordered status chain.

Assumptions and limitations

Each return is a steady compound rate with no ups and downs, so the recovery times are what a smooth path gives, not what any market will do. The amount added and the withdrawal are fixed in dollars, with no allowance for inflation, fees or taxes. In the plan the fall comes either in year 1 or in year 10 and every other year earns your expected return. Amounts are nominal. The search for a recovery stops at 100 years.

Restrictions and non-computing states

This calculator enforces its numeric limits before it accepts a result. A balance at the peak of 0 is accepted by the input but refused by the workbook, because there is nothing to recover. The plan runs at least 10 years so that the late fall always falls inside it.

Errors and warnings

A request rejected by the page's input limits is not a computed result. A transport or service failure cannot establish a fresh workbook answer. Review the workbook's References and Disclaimer, and check any plan with a qualified professional before using a result for a real decision.

Sources and further reading

The fall, the balance, the returns, the amounts and the plan come from the inputs, not market data. The workbook's References sheet identifies the calculation sources. The model is elementary algebra and compound growth: the gain needed to undo a fall, a balance compounded month by month, and a withdrawal plan stepped year by year. The methodology states every relationship it uses, so no outside source supplies its figures. The links below describe the workbook functions it relies on; they do not endorse this calculator.

• Microsoft Support's SUMPRODUCT documentation describes the function the workbook uses to count the months the balance stays below the peak.
• Microsoft Support's LN and ROUNDUP documentation describe the functions behind the months with nothing added, the logarithm of the gain over the logarithm of the monthly growth, rounded up to a whole month.
• Microsoft Support's INDEX documentation describes the function that reads each plan's balance in its last year and the chart's points from the monthly balances.

This is an educational estimate, not financial, investment, tax or legal advice. Real returns vary from year to year; check any plan with a qualified professional.