Retirement Withdrawal Calculator
Project a portfolio under constant annual investment returns and inflation-linked withdrawals for one to one hundred years. The annual table separates planned spending, payments actually funded, and shortfalls, so an exhausted portfolio never silently pays money it does not have.
By Dr. Hassan Khames EliwaLast updated
Result
- First-year planned withdrawal
- $40,000.00
- Portfolio exhaustionExhaustion is a zero balance, not necessarily a spending shortfall. No claim is made beyond the selected horizon.
- Not exhausted within selected duration
- Total unfunded withdrawals
- $0.00
- Portfolio
Annual nominal projection: growth first, withdrawal at year end
| Year | Opening | Growth | Planned | Paid | Unfunded | Closing |
|---|---|---|---|---|---|---|
| 1 | $1,000,000.00 | $50,000.00 | $40,000.00 | $40,000.00 | $0.00 | $1,010,000.00 |
| 2 | $1,010,000.00 | $50,500.00 | $40,800.00 | $40,800.00 | $0.00 | $1,019,700.00 |
| 3 | $1,019,700.00 | $50,985.00 | $41,616.00 | $41,616.00 | $0.00 | $1,029,069.00 |
| 4 | $1,029,069.00 | $51,453.45 | $42,448.32 | $42,448.32 | $0.00 | $1,038,074.13 |
| 5 | $1,038,074.13 | $51,903.71 | $43,297.29 | $43,297.29 | $0.00 | $1,046,680.55 |
| 6 | $1,046,680.55 | $52,334.03 | $44,163.23 | $44,163.23 | $0.00 | $1,054,851.35 |
| 7 | $1,054,851.35 | $52,742.57 | $45,046.50 | $45,046.50 | $0.00 | $1,062,547.42 |
| 8 | $1,062,547.42 | $53,127.37 | $45,947.43 | $45,947.43 | $0.00 | $1,069,727.36 |
| 9 | $1,069,727.36 | $53,486.37 | $46,866.38 | $46,866.38 | $0.00 | $1,076,347.35 |
| 10 | $1,076,347.35 | $53,817.37 | $47,803.70 | $47,803.70 | $0.00 | $1,082,361.02 |
| 11 | $1,082,361.02 | $54,118.05 | $48,759.78 | $48,759.78 | $0.00 | $1,087,719.29 |
| 12 | $1,087,719.29 | $54,385.96 | $49,734.97 | $49,734.97 | $0.00 | $1,092,370.28 |
| 13 | $1,092,370.28 | $54,618.51 | $50,729.67 | $50,729.67 | $0.00 | $1,096,259.13 |
| 14 | $1,096,259.13 | $54,812.96 | $51,744.27 | $51,744.27 | $0.00 | $1,099,327.82 |
| 15 | $1,099,327.82 | $54,966.39 | $52,779.15 | $52,779.15 | $0.00 | $1,101,515.06 |
| 16 | $1,101,515.06 | $55,075.75 | $53,834.73 | $53,834.73 | $0.00 | $1,102,756.08 |
| 17 | $1,102,756.08 | $55,137.80 | $54,911.43 | $54,911.43 | $0.00 | $1,102,982.45 |
| 18 | $1,102,982.45 | $55,149.12 | $56,009.66 | $56,009.66 | $0.00 | $1,102,121.92 |
| 19 | $1,102,121.92 | $55,106.10 | $57,129.85 | $57,129.85 | $0.00 | $1,100,098.16 |
| 20 | $1,100,098.16 | $55,004.91 | $58,272.45 | $58,272.45 | $0.00 | $1,096,830.63 |
| 21 | $1,096,830.63 | $54,841.53 | $59,437.90 | $59,437.90 | $0.00 | $1,092,234.26 |
| 22 | $1,092,234.26 | $54,611.71 | $60,626.65 | $60,626.65 | $0.00 | $1,086,219.32 |
| 23 | $1,086,219.32 | $54,310.97 | $61,839.19 | $61,839.19 | $0.00 | $1,078,691.10 |
| 24 | $1,078,691.10 | $53,934.56 | $63,075.97 | $63,075.97 | $0.00 | $1,069,549.68 |
| 25 | $1,069,549.68 | $53,477.48 | $64,337.49 | $64,337.49 | $0.00 | $1,058,689.68 |
| 26 | $1,058,689.68 | $52,934.48 | $65,624.24 | $65,624.24 | $0.00 | $1,045,999.92 |
| 27 | $1,045,999.92 | $52,300.00 | $66,936.72 | $66,936.72 | $0.00 | $1,031,363.19 |
| 28 | $1,031,363.19 | $51,568.16 | $68,275.46 | $68,275.46 | $0.00 | $1,014,655.90 |
| 29 | $1,014,655.90 | $50,732.79 | $69,640.97 | $69,640.97 | $0.00 | $995,747.72 |
| 30 | $995,747.72 | $49,787.39 | $71,033.79 | $71,033.79 | $0.00 | $974,501.32 |
How it works
Fix the timing before interpreting the projection
The starting portfolio is invested at the beginning of year one. Each year receives the entered nominal return first; the planned withdrawal is then made at year end. First-year spending equals the starting portfolio multiplied by the withdrawal percentage. Later planned withdrawals increase or decrease with the entered inflation rate, independently of the remaining portfolio balance.
For opening balance B and return r, available funds = B × (1 + r). Actual withdrawal is the smaller of available funds and planned spending. Closing balance is available funds minus the actual withdrawal, floored at zero. Unfunded withdrawal is planned spending minus the actual payment. The next year's opening balance is the previous closing balance; no new contributions, borrowing, pension income, or outside cash are assumed.
Read every column as nominal money
Year one spending is not increased by inflation before it is paid. In year t, requested spending = initial withdrawal × (1 + inflation)^(t − 1). Thus inflation changes spending from year two onward. The annual table shows opening value, investment growth or loss, planned withdrawal, actual withdrawal, unfunded amount, and closing value. The chart follows nominal closing balances rather than purchasing power.
The initial rate is applied once to the original portfolio. This is not a strategy that withdraws the same percentage of each year's changing balance. A constant-percentage strategy behaves differently, particularly after losses. Returns are also constant here: the projection is deterministic, not a historical backtest, Monte Carlo model, or estimate of survival probability.
Distinguish exhaustion from a funding shortfall
Exhaustion means the balance first reaches zero. Exactly spending the final available dollar counts as exhaustion even if that year's planned withdrawal is fully paid. An initially empty portfolio is labeled empty at start. If a positive portfolio stays above zero throughout the selected period, the result says it was not exhausted within that duration; it does not invent a later exhaustion date or claim lifetime sustainability.
All selected years remain in the table after exhaustion, making later shortfalls visible. A portfolio at zero cannot regrow without contributions. The horizon is limited to a whole number of years from one to one hundred, keeping the calculation bounded and the output readable. Returns and inflation can range from −100% to 100%; these broad mathematical limits are not realistic planning recommendations.
Worked example
Example 1: two years with inflation
Start with $100,000, a 4% withdrawal rate, 5% annual return, 2% spending inflation, and two years. Year one earns $5,000, pays $4,000, and closes at $101,000. Year two earns $5,050 and pays $4,080, closing at $101,970. Both planned withdrawals are fully funded, total unfunded spending is $0, and the portfolio is not exhausted within two years.
Example 2: a transparent shortfall
Start with $10,000, a 60% initial withdrawal rate, zero return, zero inflation, and three years. Planned spending is $6,000 annually. Year one pays $6,000 and closes at $4,000. Year two pays only $4,000, leaves $2,000 unfunded, and exhausts the portfolio. Year three pays $0 and leaves $6,000 unfunded. Ending balance is $0 and total unfunded withdrawals are $8,000.
Expert tips
Common mistakes
- Reading a positive nominal ending balance as unchanged purchasing power ignores inflation across the full horizon.
- Assuming year-end spending is equivalent to monthly or beginning-of-year withdrawals overlooks the extra time invested in this model.
- Calling no exhaustion within thirty years a guarantee of a safe withdrawal rate goes beyond what a deterministic calculation can establish.
For education, not financial advice. Results are estimates based on the inputs you give. Lenders, tax authorities and advisers may use different rules, fees and rounding. Check the numbers with a qualified professional before you commit to anything.
Frequently asked questions
Does the withdrawal percentage reset annually?
No. It sets first-year spending from the original portfolio. Subsequent planned amounts follow inflation, not the current portfolio value.
What happens after exhaustion?
The annual rows continue through the selected horizon. Actual payments remain zero and planned amounts appear as unfunded spending, unless planned spending itself has fallen to zero.
Can negative returns be entered?
Yes, down to −100% annually. A −100% return wipes out the opening portfolio before that year’s withdrawal. More negative values are rejected because they imply losses beyond this unleveraged portfolio.
What does negative inflation mean?
It decreases planned spending each following year. At −100%, planned spending becomes zero from year two onward. This mathematical endpoint is not a normal long-term economic assumption.
Does zero ending balance always mean a shortfall?
No. The final withdrawal may exactly equal available funds. Exhaustion records the zero balance, while the unfunded column separately records whether planned spending went unpaid.
Does the tool include investment risk?
Only through the constant return you choose. It does not model volatility, sequence effects, changing allocations, longevity, or emergency costs. Review those risks separately before making retirement decisions.
Related calculators
Related guides
FinancialRetirement Withdrawal Rates: Beyond the 4% ShortcutUnderstand initial withdrawal rates, inflation adjustments, sequence risk, and the historical assumptions behind the 4% rule.17 November 2026 · 7 min read
FinancialCompound interest: three real savings scenariosThree practical savings examples show what comes from your deposits, what comes from growth, and which assumptions deserve scrutiny.14 November 2026 · 7 min read
FinancialPresent and future value: move money through timeUnderstand discounting and compounding, compare dated cash flows, and keep nominal rates, inflation and payment timing consistent.14 November 2026 · 8 min readSources and standards
About the author
Dr. Hassan Khames Eliwa holds a PhD in Construction & Built Environment and has more than 20 years of international project controls experience. He is Director of Eliwa Project Controls Limited in Auckland and founder of PMMilestone.org and PMMilestone.com.
Buy me a coffee