Retirement Calculator In Excel
2. Enter your data in the cells corresponding the headings: periodic deposit, times per year, current age, retirement age, and interest rate.
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.
4. Total no. of deposit is simply calculated by multiplying times per year and no. of years.
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
The full formula of retirement calculator is:
=FV(B8/2,B11,B4)*-1
Here you can to download the retirement calculator.
Template
You can download the Template here – Download
Further reading: Basic concepts Getting started with Excel Cell References
