Dear Sir, I opened PPF account on 04-04-2016 & the same day i deposited Rs. The calculator provided in this post has embedded PF calculation formula in excel which you can download freely. Now in December. But the rate of interest in PPF account in post offices, banks or anywhere else is the same at a given point of time. Download the latest version (June 2016) of the PPF Calculator and Tracker Note: The calculator only calculates the loan eligibility and the loan amount. I hope you find this Excel PPF interest and maturity calculator useful. PPF Account Excel Calculator is a very easy and effective tool to calculate the PPF Account Maturity amount, Monthly or Yearly payment structure, Maturity after 15, 20, 25, 30 and 35 years that easily determines the amount that you will get after investing the amount. Dear Sir, I also 29-03-2016 start to PPF account interest rate 8.7%, but 01-04-2016 PPF interest rate 8.1%. So, if one chooses to withdraw after five years, and he saves 20%on tax, then he has saved an additional 4% more reach year. A question might arise when presented with an option to deposit the amount on monthly or yearly bases which make you think what is the difference? You can change the values in Orange cells only. How will the investment grow over the years? PPF calculator is a very easy way to calculate PPF interest and PPF maturity amount. And it is among the very few risk-free tax saving investment option for us Indian taxpayers (as it provides tax benefits under the Section 80C). How to Submit LIC Policy Maturity Claim Online. The PPF interest rate is declared on the first day of every quarter of the year on January 1, April 1, July 1 and October 1 and is valid for that quarter. PPF Calculator Excel for Maturity, Loan and Partial Withdrawal. interest. the PPF Account Excel Calculator from the above link. The The loan facility is available from third to sixth financial year of opening the account. The calculation of the final amount is as follows-, The following Calculation table shows us the maturity amount You can download Excel based calculator below. Excel Sheet will open containing a calculation with amount Rs.12,500 for 8.0% How to Activate Post Office Internet Banking, How to Apply for PF Withdrawal using Umang App. Public Provident Fund (PPF) is a financial tool that offers a high interest on the amount deposited in the account with the tax benefit. Monthly Investment – Rs 12,500 per month (Rs 1.5 lakh annually), Maturity Amount (at the end of 20th year) ~ Rs 71 lakh, Maturity Amount (at the end of 30th year) ~ Rs 1.54 crore. per annum is Rs.7,03,783.08/-. However, the total yearly interest is added to the PPF account at the end of the financial year. You can try ELSS, especially the one with closed ended one. Both the PPF account interest rate and annual investment limits can be varied for each financial year. In reality, this will not happen. For e.g. The interest earned in the second year is Rs. 4,083.20 and 3,993.60 for Monthly and yearly respectively. This PPF calculator can calculate the maximum loan eligibility, partial withdrawal eligibility and the maturity value at the end of 15 years. Is it correct? Sorry Niranjan I could not understand the question. The list of banks offering PPF account is as 23 banks that offer PPF Account. Assuming interest rate of 8.7% for every year and maturity period of 15 years you would get approximately Rs 30.5 lakhs on maturity on deposit of Rs 1 lakh every year. All the information in the blog is for educational and informational purpose only. }. Dev Ashish is a SEBI-registered Investment Advisor (RIA Reg. There is a difference of Rs.880/- similarly for the second year, the amount deposited is Rs.2000 and 24,000 for Monthly and yearly respectively. There are monthly PPF Account Calculation visit PPF Account Your email address will not be published. My ppf account oppen date 10/09/1990 & Extension 5 years Whot my Maturity date? Using this calculator, you will easily find answers to questions like how much you can invest in PPF? The current Interest rate as of 2019 offered by the PPF Account is 8% per annum calculated on compound bases. But you can play around with the excel sheet and bypass this restriction yourself. sir I got 3117275 if invested on 1st april in the beginning of every year and 3217275 if invested at the end of every year on 31st march. (PPF Interest Maturity Calculator – Updated 2020). follows-. In this example below, we will provide two PPF Account of the same amount one deposited annually and one deposited the same amount by splitting it into 12 parts with the monthly payment. But as per current PPF account rules, the government has the option of changing PPF rates every quarter now. enter. Withdraw at end of 30th year, Invest in PPF for 20 years. The Scheme is guaranteed by the Central Government that makes it the safest savings instrument to invest the money. So go on… use this PPF calculator excel xlsx xls sheet and see if you are actually using your provident fund investments (PPF or others) to create wealth or not. You can borrow multiple times in the third to sixth financial year, once you fully pay the preceding loan. Extension by 5 years each time is allowed in SBI. If any staff is unaware, which happens with many banks, you can write to its customer care. So naturally, they are concerned about the rate of interest on their PPF accounts and also about estimating the final PPF maturity amount. account is for 15 years. Voluntary Provident Fund – A Good Tax Saving Retirement Option!