{"id":6029,"date":"2021-04-08T08:52:00","date_gmt":"2021-04-08T03:22:00","guid":{"rendered":"http:\/\/www.apnaplan.com\/?p=6029"},"modified":"2021-04-09T17:15:02","modified_gmt":"2021-04-09T11:45:02","slug":"ppf-calculator-excel","status":"publish","type":"post","link":"https:\/\/www.apnaplan.com\/ppf-calculator-excel\/","title":{"rendered":"PPF Calculator Excel 2021 \u2605 Calculate the Maturity, Loan and Partial Withdrawal"},"content":{"rendered":"\n

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<\/strong> which you can download.<\/p>\n\n\n\n

PPF Calculator Excel<\/h2>\n\n\n\n

This PPF calculator can calculate the maximum loan eligibility, partial withdrawal eligibility and the maturity value at the end of 15 years.<\/p>\n\n\n\n

It takes the historical interest rates automatically depending on the financial year<\/strong>. The future years where the interest rates have not been declared takes the value of last declared rates.<\/p>\n\n\n\n

You can download Excel based calculator below.<\/p>\n\n\n\n

\n
Download PPF Calculator Excel<\/strong><\/a><\/div>\n<\/div>\n\n\n\n

How the PPF Calculator Excel Works?<\/h2>\n\n\n\n

The PPF Calculator Excel looks like the figure below. You can change the values in Orange cells only. <\/p>\n\n\n\n

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.<\/p>\n\n\n\n

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.<\/p>\n\n\n\n

Next editable field is “PPF Interest Rate<\/strong>” fields each year. The PPF Calculator Excel<\/strong> 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<\/strong>.<\/p>\n\n\n\n

\"PPF
PPF Calculator Excel \u2013 for Maturity, Loan and Partial Withdrawal<\/figcaption><\/figure><\/div>\n\n\n\n

Loan against PPF Rules<\/h2>\n\n\n\n

Following are the rules for Loan against PPF<\/strong>:<\/p>\n\n\n\n