How do I calculate EPF in Excel?
Download (FREE) Employee Provident Fund Excel Calculator (2022)
- Current Age.
- Retirement Age.
- Your Monthly Salary (Basic Pay + Dearness Allowance)
- Expected Increase in Salary every year (in percentage)
- EPF Interest Rate: Current EPF Interest rate is 8.65%.
- Employee’s EPF Contribution (as a % of Salary) – Generally 12%
How EPF amount is calculated?
To calculate your provident fund contribution, add both employer and employee contributions. The employer contributes 12% towards the PF balance, whereas the employee contributes 3.67% towards the PF balance. The employer’s contribution of 12% towards the PF balance depends on the employee’s basic pay.
How PF and ESI is calculated?
Just like the ESI scheme, the Employees Provident Fund (EPF) is a Contributory fund with contributions from both the employee and their employers.
…
Details of EPF.
| Employee | Employer> | |
|---|---|---|
| Total Contribution | 12,000 * 12% = Rs 1,440 | 12,000 * 12% = Rs 1,440 |
| EPS | 0 | 12,000 * 8.33% = Rs 999.60 |
| EPF | Rs 1,440 | 12,000 * 3.67% = Rs 440.40 |
What is the percentage of PF?
You and your employer need to transfer 10% or 12% of your basic salary to contribute towards EPF. However, if you are a woman, you only need to contribute 8% of your basic salary for the first three years. During this period, your employer’s EPF contribution will remain 12%.
What is the PF for 18000 salary?
If Employee wants Contribute Under Voluntary PF Contribution
| Basic Salary + DA | Employee Contribution on : 18000 Rs Employer contribution on : 15000 Rs | |
|---|---|---|
| Employee PF Contribution | 12% | 2160 Rs |
| Employer PF contribution | 3.67% | 550 |
| Employer Pension contribution | 8.33% | 1250 |
How is PF calculated on 25000 salary?
Your contribution towards EPF is 12% of Rs. 25,000, which amounts to Rs. 3,000 each month. Your employer’s contribution towards EPF is 3.67% of Rs.
Is employer contribution 13% in PF?
Contribution by an employer: The contribution made by the employer is 13% of the basic salary and PF applicable allowances of the employee. However this 13% is further subdivided into: 3.67% of contribution towards Employees’ Provident Fund. 0.5% of contribution towards EPF Administration Charges.
What is the PF salary limit?
The wage ceiling for mandatory EPF benefits is currently set at ₹ 15,000. The move would bring EPF in line with other social security nets like Employees State Insurance Corporation (ESIC), which also have a limit of ₹ 21,000.
How much PF will I get on 15000 salary?
So, for every employee receiving a basic pay equal to Rs 15,000 or more, Rs 1,250 each month is diverted into EPS. However, if the basic pay is less than Rs 15,000 then 8.33% of that full amount is directed into EPS. The balance apart from this 8.33% is retained within the EPF scheme.
How much PF is cut in salary?
Employee contribution to EPF: 12% of salary. Employer contribution to EPF: 3.67% of salary.
How is PF calculated on 20000 salary?
67%must be paid towards the EPF. Thus 3.67% of ₹20,000 is ₹734. So, the contribution to an EPF account each month for someone earning ₹20,000 in salary is the employee contribution plus the employer contribution, which is ₹2400 + ₹734 = ₹3134 in this instance.
Is PF always 12 of basic salary?
Employee Contribution to EPF
The employee contributes 12 percent of his or her basic salary along with the Dearness Allowance every month to the EPF account. For example: If the basic salary is Rs. 15,000 per month, the employee contribution shall be 12 % of 15000, which comes to Rs 1800/-.
Is PF mandatory for salary above 21000?
While the EPF benefit is only mandatorily extended to employees earning up to ₹ 15,000, many companies voluntarily extend benefits to those earning higher salaries.
What is minimum salary for PF?
According to the Employee Provident Fund Act, contribution towards EPF is mandatory only for those whose basic salary is up to Rs 6,500. Tax and EPF experts say the guideline was issued in the interest of those whose monthly basic salary is within this range.
What is minimum PF?
Employer’s Contribution towards EPF
The minimum amount of contribution to be made by the employer is set at a rate of 12% of Rs. 15,000 (although they can voluntarily contribute more). This amount equals Rs. 1,800 per month.
Why PF is 12 of basic salary?
Can an employee contribute more than 12% of basic salary towards EPF. Employees’ Provident Fund (EPF) is a retirement investment plan that every salaried individual opts for. Employee usually contributes 12% of their basic pay and employer contributes 13.61% towards the EPF.
What is the maximum limit for EPF?
The EPF contribution is either 12% of Rs. 15,000 or 12% of (Basic Salary + Dearness Allowance, if applicable). The upper limit of EPF contribution every month is 12% of Rs. 15,000.
What is the salary limit for PF?
All employees drawing a salary are eligible for EPF. Moreover, it is compulsory for all employees earning less than ₹15,000 to register for the EPF. However, employees earning more than ₹15,000 can also voluntarily stay in the EPF scheme.
What is the maximum PF limit?
In Union Budget 2021-22, the finance minister announced capping of tax-free annual PF contributions to ₹2.5 lakh to avail tax-free interest income, but later raised this limit to ₹5 lakh for such funds where employers do not contribute, a move that benefited only government employees, the two said on condition of …
What is PF limit?
How is PF calculated from CTC?
Provident Fund-A portion of the salary gets deposited in the PF account of the employee. Employer and employee together contribute to the contribution. The contribution to the PF account is 12 per cent of the basic pay.
What is the salary limit for PF 2022?
Monthly basic and dearness allowance of up to a maximum of Rs. 15,000.
What is new EPF rules?
Employers must mandatorily provide EPF contributions for employees whose monthly income is up to ₹ 15,000. Taxes withheld in such a manner need to be reported by employees as “Income from other sources.” The EPFO has reduced the interest rate to a four-decade low of 8.1 per cent for FY 2021-22.
How much PF is 40000 salary?
PF calculated salary is 40,000 x 12% = 4800 for employee and 1800 from employer (restricted to 15000).
What is in hand salary for 10 LPA?
So for a person earning 10 LPA will get around 72000 in hand. Basic thumb rule to calculate in-hand is to divide the CTC by 14 . As it works in most of the cases for the approx value. In-hand = CTC/14.