• Home
  • EPF Balance
  • Activation
  • Help Desk
  • PF claims
  • epf payment

Epfo guidelines

epfo login, epf balance, uan login member portal, pf claim status

EPF Calculator epf interest pension calculator excel formula format download

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

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,




Calculators

  • Bike EMI calculator
  • Car loan emi calculator
  • compound interest calculator
  • EPF Calculator epf interest pension calculator excel formula format download
  • Fixed deposit FD calculator
  • home loan emi calculator
  • Personal loan emi calculator
  • Recurring deposit RD calculator
  • SIP Calculator

Useful topics

  • EPFO uan portal
  • uan passbook
  • epf withdrawal
  • uan employer unified

Saving Schemes

  • Post office RD
  • post office FIxed deposit
  • POMIS
  • NSC National Savings Certificate
  • sukanya samriddhi yojana
  • NPS
  • PPF Account
  • Senior Citizen Savings Scheme (SCSS)

Disclaimer

Note: We are not affiliated with EPFO. created this sole purpose of helping people & awareness about pf.

All the questions answered in the Articles, ask your questions in the comment.

 

epf claim status shows payment under process epfo

  • Contact
  • About us
  • Disclaimer & Privacy Policy



Recent Articles

  • EPFO Latest News & PF Rules | budget 2020 7.5 lakh limit |covid-19 75% withdraw | Regulatory updates
  • PPF Account Application process Interest rate, return calculation Tax Benefits
  • E aadhar card update /download/ correction status details
  • EPF Balance Enquiry download passbook with uan & mobile 3+ ways to know
  • UAN Activation & Registration status at epfo portal (3+Steps process)

Copyright © 2023 · All rights Reserved epfo help