This Epf Calculator helps you to know your accumulated epf balance with interest rate, for a certain time or retirement age. you just have to select current age & Monthly pf contribution to pf (which 12% of Basic salary +DA).
How do EPF Calculators work?
Government Adds interest rate every year.
Your Contribution 12% (minimum)
Maximum 100% also Under VPF (Volunteer PF but govt indicated tax on VPF but not on EPF).
Employer Contribution: 3.67%
Pension amount: 12% by Employer not added here. the separate calculation for EPS Pension scheme.
Present EPF Interest Rate Ay 2019-20: 8.65%
You may also check epf balance by downloading epf passbook
how to calculate epf pension
the pension contribution is 8.33% of your basic salary but it is limited to 1250/month. This amount is 8.33% of 15,000.
minimum pension of ₹1000/month
if you don’t complete 10 years in the service or epf subscription, you would not be able to get the monthly pension.
but you get pension benefits but, you must have completed at least 6 months.
Deemed Pension /Reduced Pension
age of 50
reduced by 4% for every lost year
defer /Enhanced Pension
the pension would increase by 4%. You can defer pension up to the age of 60.
epf pension calculator excel
you can download the free epf calculator excel format from below, also available with google sheets.
make sure to modify the cells in excel to get the appropriate values. hire a expert to modify the excel format for epf calculator incase any customization needed make sure follow the excel tutorials especially formulas.
| Particulars | Date | Month | Year | |
| Date of Birth | 31 | 10 | 1952 | |
| Date of Join | 1 | 12 | 1981 | |
| Break in Service before 16.11.95 | 0 | 0 | 0 | |
| Break in Service w.e.f 16.11.95 | 0 | 0 | 0 | |
| Date of Employees’ Pension Scheme | 11 | 1995 | ||
| Date of Retirement | 31 | 10 | 2010 | |
| Salary on 16.11.1995 | 2000 | |||
| Salary on Separation from Service | 10450 | |||
| Total Pension (subject to minimum) | 1,706.00 | |||
epf calculator excel free download
EXCEL GOOGLE SHEETS OPEN OFFICE CALC
VPF impact on epf contribution
VPF earns same interest as epf, you can add VPF+EPF = full epf + interest= maturity.
VPF = 100% Basic pay (80C tax deduction allowed)
Tax on VPF: just like epf you withdraw before 5 years it attracts tax but the limits 30,000 -50,000
check of withdrawal rules & tax
Why pf withdrawal not a good idea loss of 15 lakhs for 5 lakh withdrawal?
Maximum Wage Ceiling Is Rs.15,000)
salary 20000
monthly contribution: 12%. 3.67%
1800+550.5=2350.5
Retirement Age 55
present age 25
interest rate 8.65%*
EPF Balance at Maturity ₹ 39,14,768 25 years to 55
EPF Balance at Maturity ₹ 24,65,259 3o to 55 years
3914768-2465259=14,49,509
first five year EPF balance will be Rs 6,27,101.
PF maturity amount of Rs 18,12,619.
Epf pension calculator EPS
will be added soon.
epf pension calculator,
epf interest calculator,
epf calculator excel,
how to calculate epf pension,
epf interest rate calculator,