How long will your retirement nest egg last? That is what this new spreadsheet-based calculator can help you figure out. It simulates the case where a person makes regular withdrawals from an account that is also earning interest. The spreadsheet gives you much more control over your savings withdrawal plan than most online calculators. For example, in the payout schedule, you can enter additional withdrawal amounts to either add to or reduce the amount of a withdrawal for a specific period. And of course, because it is a spreadsheet, you can delve deep to figure out exactly how the formulas work.


Retirement Withdrawal Calculator

for Excel
Retirement Withdrawal Calculator Screenshot
For: Excel 2007 or later & Excel for iPad/iPhone

Other Versions

Template Details

License: Personal Use
View Agreement
(not for distribution or resale)
Visit Support Page

"No installation, no macros - just a simple spreadsheet" - by



- Enter the amount you expect to withdraw in today's dollars. The initial withdrawal will be adjusted for inflation based on the number of years until your retirement.

- Enter an annual inflation rate to automatically increase the amount withdrawn each period. This is an important part of any retirement planning calculation.

- Create a monthly or annual payout schedule. You are more likely to make monthly withdrawals, but for a quick analysis and a more concise payout schedule, the annual option is handy.

- Make adjustments to the normal scheduled withdrawal by entering an Additional Withdrawal amount within the Payout Schedule, either positive or negative. For example, you could use this feature to see what a huge one-time medical bill might do to the plan.

- Choose whether the withdrawal is made at the beginning or end of a month or year. Choosing "beginning" means the first withdrawal is made before any interest is earned.

- View a graph of the balance over time.

Taxes: This spreadsheet doesn't include any tax calculations. The main assumption with regard to taxes is that the interest is earned tax free within the retirement account. That is usually a pretty good assumption, but if you want to take taxes into account, you can use a tax-adjusted interest rate. For example, if interest is taxed at the rate of 15%, you can calculate a tax-adjusted interest rate as =(1-rate)*15%

Early Withdrawal Fees: This is another thing that the spreadsheet does not take into account. However, because you can add Additional Withdrawal amounts, you could make adjustments to the first few payouts if you needed to withdraw more to cover these types of fees.

How much should I withdraw? To answer that question, you'll need to create a budget. We have many free budget spreadsheets you can use.

How much should I save for retirement? To answer that, you'll need to figure out (1) How many years you want the nest egg to last, (2) How much you need to withdraw each period, and (3) How much you are willing to work and save to reach that goal. You can use this calculator to help with (1) and (2): Just change the Investment at Retirement value until the Age at Last Payout is what you want it to be. You can use one of our other savings calculators to help with (3).

More Retirement Calculators

  • Annuity Calculator - Like the Retirement Withdrawal Calculator except that you enter the years you want the nest egg to last and it calculates the withdrawal amount.
  • 401k Calculator - Estimate how your 401(k) account will grow over time.
  • Retirement Savings Calculator - Estimate how much you can save by the time you retire.
Disclaimer: This spreadsheet and the information on this page is for illustrative and educational purposes only. We do not guarantee the results or the applicability to your unique financial situation. You should seek the advice of qualified professionals regarding financial decisions.