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.
2 Comments
Yogesh,
The current interest rate effective from 1 April 2013 is 8.70% Per Annum. Your calculator for 2013-14 should have to be amended accordingly.
Despite this decimal point decrease, Interest rate in PPF Account is still very much lucrative. The Maximum interest rate available in Banks is 9.3% (Max). After Income Tax deduction, this comes down to nearabout 8.3%, a four decimal notch below. Add to this, the security issue.
At this age of Stock Market volatility, the PPF Account is an excellent option for future savings.
Indranil
Wasn’t aware about the reduction in the PPF Interest Rate. Thanks for the heads up, updating the calculator right now.