Retirement calculator

Thanks to Excel you can easy calculate things. Here you have free retirement calculator to find out how much will get being senior.

1. Open Excel and make four rows which are periodic deposit, times per year, current age, retirement age, interest rate, no. of years to retirement, and total no. of deposits per year.

data table

2. Enter your data in the cells corresponding the headings: periodic deposit, times per year, current age, retirement age, and interest rate.

enter data

3. Calculate no. of years to retirement and total no. of deposits per year. No. of years to retirement is calculated by deducting current age from retirement age.

number of years formula

4. Total no. of deposit is simply calculated by multiplying times per year and no. of years.

Total no. of deposit formula

5. Now calculate estimated savings using FV function in Excel in the cell corresponding estimated savings. Formula goes as follows:

=PV(interest rate/times per year, total number of deposits per year, periodic deposits)*-1

retirement calculator

Here you can to download the retirement calculator.