Are you looking for a simple retirement calculator? I got swamped as I began looking for retirement planning calculators and software. What I really wanted was a Microsoft Excel ® spreadsheet for calculating a simple annuity (interest earned plus annual payments), comparing the total amount invested up until retirement to the amount earned in interest. I couldn't find what I wanted, so I went ahead and created my own, which you can download for free below. This page also provides links to other retirement calculators and software. For calculating how much you may need saved at retirement, try the Annuity Calculator.


Retirement Savings Calculator

for Excel
Retirement Calculator
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



Estimate the future value of your retirement savings, based on a starting balance, expected interest rate, and annual investments. Compare total payments to interest earned. Run simulations with random annual interest rates and a variable number of annual payments.

More Retirement Calculators

  • 401(k) Savings Calculator - - This is our new 401k spreadsheet that estimates your 401(k) savings after a number of years of contributions.
  • Retirement Budget - - This template has you estimate your retirement budget by entering housing costs, personal expenses, living expenses, medical expenses, and retirement income. A good place to start to figure out how your retirement income is going to last.
  • Lifetime Savings Calculator - - This calculator estimates the amount of savings accumulated through retirement by reducing a single monthly expense and investing the amount saved.
  • Retirement Checklist - - A checklist for use by financial advisors to help clients plan for life after retirement.
  • Retire Early Calculators - - John P. Greaney, P.E. has created a variety of Excel spreadsheets for calculating safe withdrawal rates and the Generation-X Retirement Planner calculates how much money you'll need to retire early. These calculators are quite extensive.
  • Simple Savings Calculator - - Similar to the 401k Calculator and Retirement Planning Spreadsheet, but it gives you more flexibility to include extra regular or annual deposits.


Disclaimer: This retirement calculator is meant for educational purposes only. Please consult a professional financial advisor before making any final financial decisions.


Follow Us On ...

Master Excel - Spreadsheet Tips Workbook