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)