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


⤓ Excel (.xlsx)
For: Excel 2007 or later & Excel for iPad/iPhone

Other Versions

License: Personal Use (not for distribution or resale)

"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 Calculator - - This calculator estimates the amount of savings you will accumulate and how long it will last during retirement.
  • Retirement Expenses Worksheet - - This worksheet has you estimate your retirement budget by entering housing costs, personal expenses, living expenses, medical expenses, etc. A good place to start to figure out how long your retirement income is going to last.
  • 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.