This is an update to the Excel PPF calculator and Tracker posted yesterday.
Thanks to suggestions from Sundaram Anathakrishnan, Hemanth Chandra, Basavaraj Tonagatti and Deepak Rao the following changes have been incorporated.
1) The logic associated with withdrawal limits and loan availability has been checked and updated. They are now in sync with this resource sent by Mr. Sundaram Anathakrishnan.
2) The user now has an option to input whether the investment was made before or after the 5th of the month. I forgot all about this earlier!
3) The user can now input the exact month in which the withdrawal is made
4) An extension tracker for a user who has extended the tenure by 5 years. Two extension blocks are covered.
Please check the sheets and let me know if there are errors and if any more features need to be included. I would like to thank Karthikeyan Chellappa for making the original calculator (included) from which the tracker was made. It would not have been possible without his effort.
Here is a screenshot of the tracker
Download the updated PPF Calculator and Tracker (.xlsx file) (macros to be enabled for goal calculator)
Subscribe to get posts via email
|You Can Be Rich Too With Goal-based Investing A book that can help you ask the right questions about money and find simple solutions. Comes with nine online calculator modules. Read more about the book and order now!|
GameChanger - Forget Startups, Join Corporate & Still Live The Rich Live You want Take that international trip at 50% lower costs! Optimise credit card usage! Set money management on auto-pilot! Read more about the book and order now!