PPF (Public Provident Fund) is one of the most popular investment in India and rightly so. It’s safe, backed by Government and gives tax free returns. We have designed this Excel based calculator for PPF Withdrawal, Loan and Maturity which you can download.
This PPF calculator can calculate the maximum loan eligibility, partial withdrawal eligibility and the maturity value at the end of 15 years.
It takes the historical interest rates automatically depending on the financial year. The future years where the interest rates have not been declared takes the value of last declared rates.
You can download Excel based calculator below.
The PPF Calculator Excel looks like the figure below. You can change the values in Orange cells only.
You can input the account opening year. The year here is financial year. For e.g. 2001-02 means account opened between 1 April 2001 and 31 march 2002.
Next input is Annual contribution. If you contribute same amount every year as in the example below, it will automatically take those values across years. However if your contribution has varied over the years, you can change that in the “Amount Deposited” cells for each year.
Next editable field is “PPF Interest Rate” fields each year. The PPF Calculator Excel picks up values itself for years the interest rate is declared but you can give your own assumed values for future years. A point to remember the interest rate is declared every quarter now – so you can take the average of all 4 values and feed it against the financial year. This will give you approximate maturity amount, loan that you take against PPF and if you are eligible for Partial PPF withdrawal.
Following are the rules for Loan against PPF:
Small saving scheme sponsored by Government of India like Sukanya Samriddhi Account, PPF, Senior Citizens’ Savings Scheme are quite popular and rightly so because of the safety, higher interest rate offered among other things. We have built calculator for each of them where you can check the maturity amount, loan eligibility, partial withdrawal and more. Click on the links to get the relevant calculator
Sukanya Samriddhi Yojana Calculator
Senior Citizens’ Savings Scheme Calculator
Post Office Fixed Deposit (Time Deposit) Calculator
Do you know how much tax you need to pay for the year? Have you taken benefit of all tax saving rules and investments? Should you use the “NEW” tax regime or continue with the old one? In case you have all these questions just Download the Free Excel Income Tax Calculator for FY 2021-22 (AY 2022-23) and get your answers.
PPF stands for Public Provident Fund and is part of small savings scheme by Government of India. This instrument was designed for everyone to save for their long term goals like retirement.
The PPF calculator is excel based and is easy to use. You need to input the investment year, annual contribution amount and the calculator gives you the maturity amount. In case you do not have equal contribution across all years, you can manually edit each year’s contribution. Also you need to provide interest rate for future years as the calculator assumes the last declared interest rate for all future computations.
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. So yes interest rate on PPF changes even after you have opened your PPF account.
Everyone hates paying taxes and always are on lookout for Options to Save Tax. However…
Are you worried and confused about Lien amount in SBI? Well you are not alone.…
Get details of latest Sovereign Gold Bond Price, Issue details, taxation and how to invest.…
Download the Excel based Income Tax Calculator India for FY 2020-21 (AY 2021-22). This compares…
Piramal Capital & Housing Finance, has come out with Piramal Capital & Housing Finance Ltd…
IIFL Home Loan, the Housing Finance company from IIFL Group has come out with IIFL…
View Comments
SBI ppf only allows for 5 year extension from the 15 yrs that we are to be invested in.. How and where are the 30 years plans coming from in here. can you please guide us in this.
Nice information you shared on retirement planing.
Sir i want to know that how can we calculate the ppf amount for one financial year if interest rate is 7.10 and amount invested is in variable scheme of investment. I invested amount 25 then 75 and tgen 50 thoysand in three months total 150 for one financial year 2020
My ppf account oppen date 10/09/1990 & Extension 5 years
Whot my Maturity date?
Your service is commendable. Your advice and utilities are very useful.Thank you
sir,
kindly suggest...custmer made withdrawl 25/2/16- Rs27000/-, 06/02/2015- Rs 25000/-, 02/02/2015-Rs 25000/-...... and his bal is for FY-(15-16)=177741/-, FY(14-15) =156369/-, FY(13-14)=124954/-....NOW PL TELL what amt can be permissionable for this current financial year...
HOW TO WITHDROWAL PPF FOR NEW HOME?
You can withdraw PPF depending on the years invested. You can find more details on PPF withdrawal here.
Dear Sir, I also 29-03-2016 start to PPF account interest rate 8.7%, but 01-04-2016 PPF interest rate 8.1%. 15 years after which interest belong.
Dear Sir, I opened PPF account on 04-04-2016 & the same day i deposited Rs. 500/- Kindly Let me Know that when account will be mature.
The PPF account would mature after 15 years i.e. April 2031
Dear Amit Ji, The bank has given me one statement copy where it has been mentioned that account maturity Date as 01-04-2032, request you to Kindly explain.
Sorry for the goofup - your bank is correct. The maturity is after completion of 15 years - so effectively its 16 years
Hi i want to open ppf acc. Now in December. is it the good time to invest
You can open PPF account anytime with just Rs 500. Then you can make any amount of deposits anytime you want. So take your call. Anytime is good for PPF account.