Pf Withdraw Calculator - Xls Download

Hi
Could Please provide me the PF Withdraw Calculator in an excel Formet by providing input salary data which will helps me to know the previous company PF amount.
or How can i corss verify the bank Credit amount of PF With the intrest ( Break-up for Credited amount)
Hope i will receive the favourable repay
Please revert me back
regards
Umesh

PF Withdraw Calculator
Hi
Could Please provide me the PF Withdraw Calculator in an excel Formet by providing input salary data which will helps me to know the previous company PF amount.
or How can i corss verify the bank Credit amount of PF With the intrest ( Break-up for Credited amount)
Hope i will receive the favourable repay
Please revert me back
regards
Umesh

Dear Umesh,
Normally 12% will be credited as employees contribution and 12% as employers contribution. Out of employers contribution 8.33% will go to pension fund, subject to a ceiling of Rs. 541. Rest of the full amount will go the individual PF account. Interest will be monthly compounded to and round to nearest rupee seperately for employee and employer contribution.
I shall insert an excel sheet. This is applicable w.e.f 16.11.95
The interest applicable there after as follows.
16.11.95 to 31.3.2000 - 12%
1.4.2000 to 31.3.2001 - 11%
1.4.2001 to 31.3.2005 - 9.5%
1.4.2005 to 31.3.2010 - 8.5%
1.4.2010 onwards - 9.5%
The ceiling limit applicable are
16.11.95 to 31.5.2001 - 5000
1.6.2001 onwards - 6500
Kindly entry the salary details, ceiling limit & annual interest applicale in the corresponding columns.
Abbas.P.S, ITI LTD, PALAKKAD - 678 623.
Ph. +91 9447 467 667