How to Build a Retirement Calculator in Excel

Thanks to Excel, you can easily calculate. Here you have a free retirement calculator to find out how much you will get as a senior.

Preparation of data for calculating the pension

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

retirement data table

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

enter data

Calculating the pension

3. Calculate the number of years to retirement and the total number of deposits per year. The number of years to retirement is calculated by deducting the current age from the retirement age.

number of years formula

4. To calculate the total amount of deposit, simply multiply the number of times per year by the number of years.

Total no. of deposit formula

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

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

retirement calculator

The full formula of the retirement calculator is:

=FV(B8/2,B11,B4)*-1

Here you can to download the retirement calculator.

See also  How to calculate GST?