How this instrument works
Some withdrawal problems have no end date — a retirement of unknown length draws against a portfolio for as long as somebody lives, with no way to know in advance when the money needs to run out. This one is different: the balance has to last a chosen, known number of years, and it is allowed to hit zero right on schedule. That is the shape of an early retiree bridging the gap between quitting work and a pension or Social Security start date, a parent budgeting a college fund across four specific years, or anyone told a lump sum has to stand in for income until a fixed date arrives. Starting balance, $ and Years the balance should last set that fixed target; the instrument solves for Maximum monthly withdrawal, $ — the largest level amount that can come out every month and still leave the account at exactly zero on the last one.
The formula is the same closed-form used to size a level loan payment, pointed at savings instead of debt: it treats the balance the way a lender treats principal, spreads it across Years the balance should last converted to months, and prices in Annual return during withdrawal, % compounding monthly on whatever is still sitting in the account. That ongoing compounding is why the answer beats a plain arithmetic average. On the golden sheet an unweighted share of $500,000 over 240 draws works out to $2,083.33, yet Maximum monthly withdrawal, $ reports $3,299.78 — well over a thousand dollars higher, because the account keeps crediting 5% a year to whatever balance is left standing.
Two properties fall straight out of the algebra. Double Starting balance, $ to $1,000,000 at the same rate and term and Maximum monthly withdrawal, $ exactly doubles, to $6,599.56 — the output scales linearly with the balance. Stretch Years the balance should last from 20 to 30 instead, and the withdrawal falls to $2,684.11, a drop of well under a third even though the horizon grew by half, because the extra years also give the remaining balance more time to keep earning the assumed return. The figure assumes that return holds steady every single month, arrives with no fees or taxes taken out, and stops the instant the schedule says it should — a real account's actual return moves with markets, and this arithmetic builds in no cushion for a run of bad years; it only shows what one steady, chosen rate would support.
- Enter the amount you are drawing from into Starting balance, $.
- Set Annual return during withdrawal, % to the yearly rate you expect the balance to keep earning while it is spent down.
- Enter Years the balance should last for the exact horizon the money needs to cover.
- Read Maximum monthly withdrawal, $ — the level draw that carries the account to zero right on schedule, not sooner.
- Change Years the balance should last on its own to see how much a longer or shorter horizon moves the monthly figure.
Worked example — spending $500,000 down over 20 years
Take the golden sheet: Starting balance, $ at $500,000, Annual return during withdrawal, % at 5, and Years the balance should last at 20. Converting to monthly terms gives a rate of 5 divided by 1200 and 240 total withdrawals, and solving the formula for the level payment returns Maximum monthly withdrawal, $ of $3,299.78 — the one figure that brings the balance to rest at zero right as the 240th check goes out, no sooner and no later.
Compare that against ignoring the return entirely: $500,000 apportioned in equal crumbs across 240 months works out to only $2,083.33, because a plain share assumes the money just sits there instead of continuing to earn anything. Push Years the balance should last from 20 to 30 while holding the rate and starting balance fixed, and the sustainable draw drops to $2,684.11 — smaller, but nowhere near the one-third cut a longer horizon would imply if growth played no part, since the extra decade also gives the balance more time to keep earning.
Questions
Why does the withdrawal come out higher than a simple monthly share of the balance?
Because Annual return during withdrawal, % keeps crediting the money that has not been paid out yet, every single month it sits in the account. An unweighted share of $500,000 over 240 months, with no growth assumed, only reaches $2,083.33, but the formula credits the ongoing return on whatever remains, which is why Maximum monthly withdrawal, $ comes out to $3,299.78 on the same starting numbers — more than a thousand dollars higher.
How is this different from a percentage-of-balance retirement withdrawal rule?
A percentage rule takes a fixed share of whatever the account holds today and has no target end date built in — the balance could support withdrawals for longer than expected or run out sooner, depending on returns. This instrument works the opposite way: it fixes the end date first, at Years the balance should last, and solves for the one level withdrawal that reaches zero on that date, assuming a single steady return the whole way.
How is this different from an insurer's immediate annuity quote?
An insurer selling a real annuity spreads longevity risk across a large pool of buyers, so its contract can keep sending checks no matter how long any one policyholder survives, and its price folds in overhead and profit most buyers never see itemized. Nothing here does that pooling — the sheet assumes a single, self-managed rate of return and stops paying the moment Years the balance should last runs out, showing the arithmetic under a payout quote rather than replacing one.
What happens if the account earns less than the assumed return?
The account runs dry before Years the balance should last is up, because a lower real return offsets less of the monthly draw than the calculation assumed. The instrument cannot detect that in advance — it only reports what one constant, chosen rate supports. Entering a couple of different rates side by side shows how much a shortfall in return would have cost the schedule.
Does Maximum monthly withdrawal, $ already account for taxes or fees?
No. It is the pre-tax, pre-fee amount that empties the balance according to the formula alone. Account fees quietly lower the return actually earned, and tax treatment on withdrawals depends on account type — a traditional IRA or 401(k) draw is typically taxed as ordinary income, while a Roth draw often is not — and neither is built into this arithmetic.
Why does a longer horizon lower the monthly withdrawal by less than expected?
Because the extra years do not just add more withdrawals to cover — they also give the balance more time to keep earning the assumed return before any of it is paid out. Stretching the golden sheet's Years the balance should last from 20 to 30 cuts Maximum monthly withdrawal, $ by about a fifth, from $3,299.78 to $2,684.11, not the roughly one-third a flat division across more months would suggest.
References
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.