He has also written seven other free e-books on various money management topics. Pattabiraman has co-authored three print books: (1) You can be rich too with goal-based investing (CNBC TV18) for DIY investors. Connect with him via Twitteror Linkedin or YouTube. He has over nine years of experience publishing news analysis, research and financial product development. He is an associate professor at the Indian Institute of Technology, Madras. Pattabiraman(PhD) is the founder, managing editor and primary author of freefincal. Thanks to Sundaram Anathakrishnan for pointing out a bug in the tracker sheet.Įxplore the site! Search among our 2000+ articles for information and insight! Search for: About The Author Dr M. This sheet has 1Y extra in the tracker sheet as requested by Cshipra in the comments section: 1Y-extra-version-Jan-2016 Thankfully Karthikeyan came to my rescue.ĭownload the Aug 2015 Version of the PPF Calculator and Tracker
I post this with apologies to reader Aditya Maheshwari for taking this long to post a PPF calculator. Hey, my new book with Subra(), You can be rich with goal-based investing is now available at Flipkart for Rs. If you take a loan, that amount or the outstanding balance in the loan should be deducted from the withdrawal limit. Note: The calculator only calculates the loan eligibility and the loan amount. Do let me know if additional features or corrections are necessary.ĭownload the latest version (June 2016) of the PPF Calculator and Tracker The tracker incorporates the features of Public Provident Fund (PPF) Extension Rules Upon MaturityĪccounts can either be kept alive with withdrawals (no limit) after 15Y maturity or can be extended with deposits and withdrawals (60%) for 5Y periodsĭo join me in thanking Karthikeyan for this ‘open-source’ calculator. You can then start tracking future deposits, loan, withdrawals and extension. Deposits made since April of the current year.Interest rate announced for each quarter.Balance as on March 31st of the current year.To start using the PPF tracker, all you need is the T he opening dates are key for the new version. Kindly let me know if you think this is incorrect).įeatures of the Excel PPF Calculator and Tracker PPF Calculator – This is the original made by Karthikeyan PPF Goals calculator (requires macros to be enabled) PPF account opening and maturity date with time schedule. (This is based on my understanding of PPF rules. The tracker gives the loan and withdrawals limits for new PPF accounts.
The interest rate and investment limit can be varied each financial year. The tracker can be used for new and existing PPF accounts. Now, the sheet has received major updates. I had created a PPF tracker by making simple modifications to his sheet (Sep 2014). New Tool! => Track your mutual funds and stocks investments with this Google Sheet!