Pension Lump Sum Withdrawal Schedule Planner

The Pension Lump Sum Withdrawal Schedule Planner estimates a level annual withdrawal that can spread a pension lump sum across a chosen number of years while reflecting an assumed net investment return. It is useful when you are comparing a lump-sum pension election with a self-managed retirement income plan and want a consistent starting point for annual cash flow.

The result is a planning estimate, not a guarantee that a portfolio will earn the same return every year. Actual withdrawals may need to change as markets, fees, taxes, inflation, and spending needs change.

Inputs

$
%
%
years
Result
Estimated level annual withdrawal
Monthly equivalent
Total scheduled withdrawals
Net annual return
Schedule length

1. Enter the lump sum
Use the amount you expect to have available for the withdrawal plan before future investment gains.

2. Set a return assumption
Enter an average annual return for the invested balance. This is a planning assumption, not a forecast.

3. Account for ongoing fees
Enter an annual fee rate so the calculator can use return after fees.

4. Choose the schedule length
Enter the number of years over which you want the lump sum to support level withdrawals.

5. Review the level withdrawal
Compare the annual and monthly equivalents with your expected spending needs and revisit the assumptions if needed.

Formula:

Net rate = (Expected return − Annual fees) / 100 Annual withdrawal = P × r / (1 − (1 + r)^−n)

Where P is the starting pension lump sum, r is the annual net return as a decimal, and n is the number of annual withdrawals. If the net rate is 0%, the calculator uses P / n.

What the result means

The main result is the constant annual withdrawal that would mathematically amortize the starting lump sum over the selected term under the assumed steady net return.

Real investment returns are uneven, so an actual portfolio can run out sooner or retain money longer than this level-return model suggests.

Given: a $500,000 lump sum, 4.0% expected return, 0.5% annual fees, and a 25-year schedule.

Calculation: net return = 3.5%, so annual withdrawal = 500,000 × 0.035 / (1 − 1.035−25) ≈ $30,363.

Result: the level withdrawal is about $30,363 per year, or $2,530 per month.

This amount is a modeled withdrawal rate designed to exhaust the balance near the end of year 25 if the net return assumption is achieved every year.

Does this planner include inflation?

No. It calculates a level nominal withdrawal. If you expect withdrawals to rise with inflation, use a shorter review cycle or a model specifically built for growing withdrawals.

Why subtract fees from the return?

Investment and account fees reduce the return available to support withdrawals. Entering them separately makes the net-return assumption easier to review.

Can I use a negative expected return?

Yes, within the input range. A negative assumption produces a lower sustainable level withdrawal because the balance is expected to shrink from both losses and distributions.

What if I want money left at the end?

This version targets a balance near zero at the end of the selected term. To preserve a reserve, subtract the desired reserve from the starting lump sum before planning withdrawals.

How is this different from an annuity quote?

This planner models withdrawals from an invested lump sum using your return assumption. An annuity quote reflects insurer pricing, contract features, guarantees, and mortality assumptions.