Download the Excel file by clicking Download ( ) tab below
Version date 21-12-15
Read instructions to use the calculator in the excel file. If the computer date is correct the calculator will take figures from previous year to arrive at current year's results. If the values are put then it will calculate the results as per input values.
Only yellow background cells accept values.
Change the interest rate if not equal to default value 8.7%.
Adjust the correct interest rate if changed against the relevant month / year. There may be variation of few rupees in results due to different rounding method.
Single sheet calculator , use side slider to move up / down.
GPF calculator takes contribution every month automatically as per last entry.
PPF calculator takes only individual contribution value against month / year.