Here is a simple EPF corpus calculator derived out of the retirement calculator sheets. The corpus calculation is the same as any SIP calculator. Just that we need to factor in increasing contributions due to a salary increase and the correct total EPF contribution from salary.
The formula used for total contribution (employee+employer) has been taken from
The threshold has been increased from 6500 to 15000.
Thanks to Praveen, Suresh Narula, Ashish, Krishna Chandrashekar and Ramakrishna Sripathy for pointing out mistakes.
The formula used for corpus calculation:
The formula will ‘blow up’ if the salary increases at exactly 8.5% (the denominator will become zero). A simple workaround for this is to add 0.00001% to the denominator. Thanks to Chenthil Iyer for point out that it is better to assume that investments are made at the end of each year for a conservative estimate.
Thanks to AIFW members who clarified that only the basic salary is used for contributions in the private sector.
Here is a screenshot
Updated version: EPF Corpus Calculator with Contribution Schedule