Here is a simple yet effective PPF return/interest calculator for Financial Year 2013-14, that I developed to know the return I would be getting from my PPF account.
To use it, all you need to do is download the Excel file (linked below), input your previous year’s PPF Balance (if any, else leave it blank) and then input whatever amount you are investing each month and this will not only show accumulated interest and return at the end of month, but also at the end of year.
Click here to download FY 2013-14 PPF Calculator (right click and then choose save as).
Of course the key to maximizing your profit in a PPF account is to invest heavily during the initial months, so that your invested money receives interest for the maximum duration possible. And in case you wish to know, how to open your own PPF account in a nationalized bank like SBI, then see my earlier blog post, How to open a PPF account in SBI.
Click here to download FY 2012-13 PPF Calculator, if you would like to know, how the PPF department arrived at the interest they have given you during the last financial year.
In case you have any question regarding the PPF Calculator, then please leave a comment below and I will get back to you as soon as possible.
Update: Interest Rate for PPF has been reduced to 8.7% with effect from 1st April 2013, PPF Calculator has been updated to reflect the same.