SWP Calculator – Systematic Withdrawal Plan

How to use this systematic withdrawal plan calculator

What this calculator does

This calculator estimates the opening investment needed to support a planned sequence of withdrawals. It discounts each future withdrawal using your expected return and increases withdrawals using your inflation assumption. It is useful for retirement-income planning, education funding, recurring household spending, and comparing withdrawal frequencies. It is a deterministic projection, not a forecast of actual market performance or personalized investment advice.

How to calculate

1. The calculator opens with a ready-to-use example: a $1,000 monthly withdrawal for 10 years, a 5% nominal annual return, 0% withdrawal inflation, and a first withdrawal on August 1, 2026. Results and a validated Excel workbook are immediately available.
2. Replace the sample values with your own assumptions. Results update as you type. Use a period and dot for decimals; commas may be used only as standard thousands separators.
3. Review the required opening investment, total withdrawals, estimated investment return, last withdrawal date, and the period-by-period schedule.
4. Select Download Excel to save the current assumptions and schedule as a real .xlsx workbook. Reset clears the demonstration data and may disable the download until a complete valid plan is entered again.

Input guide

Withdrawal amount is required and accepts a positive U.S.-dollar amount such as 1,000. A higher amount raises the opening investment nearly proportionally. Do not enter a percent or a negative value. Withdrawal frequency is required and can be yearly, semi-annually, quarterly, or monthly. More frequent withdrawals change both the number of cash flows and the periodic return applied between them. Plan length is required, measured in years, and accepts 0.25 through 100; for example, 10 means ten years. The product of years and frequency must produce a whole number of withdrawals.

Expected annual return is required, entered as a nominal annual percentage from 0 to 100, such as 5 for 5%. The model divides this rate by the selected number of periods per year, matching a common periodic planning convention. A higher assumed return usually lowers the opening investment, but actual returns can differ materially. Annual withdrawal inflation is required and accepts 0 to 100. It increases each withdrawal by a periodic rate derived from the annual assumption, so a higher inflation rate raises both later withdrawals and the required opening investment. First withdrawal date is required and must be a valid calendar date. The first withdrawal occurs immediately on that date, making the cash-flow pattern an annuity due.

Output guide

Required opening investment is the present value of all scheduled withdrawals. First withdrawal restates the initial cash flow. Total withdrawals adds all nominal withdrawals, including inflation increases. Total investment return is total withdrawals minus the opening investment; it is an estimate implied by the assumed smooth return, not a guaranteed gain. Last withdrawal date is the date of the final scheduled cash flow. The schedule columns show the period number, date, opening balance before the period's withdrawal, growth earned after that withdrawal, the withdrawal itself, and the closing balance carried into the next period.

Worked example

With $1,000 withdrawn monthly for 10 years, 120 withdrawals are scheduled. At a 5% nominal annual return, the monthly rate is 5% ÷ 12. Because the first withdrawal occurs immediately, the present value is the ordinary-annuity value multiplied by one monthly growth factor: $1,000 × [1 – (1 + 0.05/12) ^{– 120}] ÷ (0.05/12) × (1 + 0.05/12) = $94,674.19. Total withdrawals are $120,000.00, so the smooth-return model attributes $25,325.81 to investment growth.

Learn more

The U.S. Securities and Exchange Commission explains how saving and investing differ and why investment risk matters. Investor.gov also describes compound interest and the effect of time and return. For retirement income context, the U.S. Department of Labor provides a practical guide to retirement planning and income needs.