How to calculate the PF Interest rate ? - provident fund Xls Download
CiteHR
 
HOME ANSWERED NEW ABOUT LOGIN
Home > Human Resource Section > Employee Compensation & Benefits

How to calculate the PF Interest rate ?

onlyraja Started The Discussion:

I would like to understand how the interest rate for Provident Fund is being calculated.

For better understanding, let me share my PF slip for 2003 - 2004 on which the below details were printed:
* The opening balance is '0' as i joined the company fresh.
* The yearly contribution was Rs 7760.
* The yearly interest rate was 9.5% and the interest earned was Rs 216.


As per the usual calculation, the interest earned should be some where near Rs 700. But i am wondering how just Rs 216 has been calculated.
It'll be really great, if some one help me to understand the logic behind this.

Thx
Rajaram

tushar.swar - Contributing Member
hi Rajaram,

First thing is that, Interest on PF is not 9.5 %. It is 8.5%.

now lets come to your query, first you understand that, employees contribution (means 12%) directly goes in Provident fund a/c. but,

Employer's contribution (13.61%) is divided in to 5 part as mentioned below..

1) 8.33% goes in Pension Fund
2) 3.67% goes in Provident Fund
3) 0.50 % goes in EDLI (Employees Deposit Link Insurance)

rest 1.61 % divided in Admin Charges
1) 1.10% Admin charges on PF A/c
2) 0.01% Admin charges on EDLI a/c

If you see you annual PF slip carefully, So, you will found that, Provident Fund amount details only mentioned in annual slip, it means not mentioned the Pension amount details.

Interest rate of PF is calculate on employees contribution as well as Employer Contribution. So, you are getting the interest on both contribution.

That the reason, it is wonderfull to you, its showing more than you expection. for your information, your some more money (Other than mentioned in annual PF slip) is safe in Pension Fund.

In further you can withdra you PF as well as Pension amount also. but EDLI amount is not be reimbursment, It can be use only, IF you not register in ESIC, & if you meet any accident in further (Sorry to say that), you will be get the benefit of same. EDLI is like a Insurance.

If you want to know any thing else, Please let me know...

Regards,



Quote:
Originally Posted by onlyraja View Post
I would like to understand how the interest rate for Provident Fund is being calculated.

For better understanding, let me share my PF slip for 2003 - 2004 on which the below details were printed:
* The opening balance is '0' as i joined the company fresh.
* The yearly contribution was Rs 7760.
* The yearly interest rate was 9.5% and the interest earned was Rs 216.


As per the usual calculation, the interest earned should be some where near Rs 700. But i am wondering how just Rs 216 has been calculated.
It'll be really great, if some one help me to understand the logic behind this.

Thx
Rajaram

devaprasad - 
Here is a simple calculator to know your EPF kitty worth for any given year....:)


Attached FilesProvided by community member devaprasad. Join us to learn and grow with your peers.
File Type: xls EPF Calculate your kitty for the FY.xls (23.5 KB, 11143 views)
jishnuvn - 
Dear Rajaram,

I think the EPF Dept has calculated your Interest in the right way. I can show you the calculation statement if you provide the following information

1) Your date of Joining
2) Your monthly salary (Basic + DA ) during the slip period
3) Your monthly EPF deduction ( Normally it must be 12 % of your Basic + Da)

Thanks

Jishnu.V.Nair
Tax & EPF Consultant
Kerala
infomanimangalam@gmail.com

vinayakd - 
Dear Jishnu,

Please provide formula for calculation of Interest on Provident Fund on my contact no-9773447965

My contribution to pf was Rs.4326 & employer contr was Rs.1323 I got Int of Rs.130 & 40 respectively for 2006-2007 dt of joining-27.04.06

My basic was
MonthBasic12%3.67%Apr-063464213May-063000360110Jun-063000360110Jul-063000360110Aug-063000360110Sep-063950474145Oct-063950474145Nov-063950474145Dec-063950474145Jan-073950474145Feb-073950474145 36,046 4,326.00 1,323.00

I will be great help

Regards,
Vinayak

sonam2108 - 
Could anyone plaese tell me the eaxct procedure to calculate interest during the year with the contribution

Thanks Mr. Devaprasad ! Your spreadsheet gave me results matching exactly with my PF statements. The calculation is crystal clear now. Regards, Gaurav

santhan28 - 
Thank you Devaprasad. Very easy to follow your sheet. Thanks. It’s crystal clear to understand the logic and easy to use.

Good afternon sir,


This is kiran and i want to know that how can we calculate the total amount of pf of an employee if he attain the age of 58 and want to leave the job from the employment? could you give me an answer with an example?

jrhrmba - 
Hi Rajaram

THe interest for EPF is computed on a reducing balance method

The attached file will compute the same for you

You may use this for your reference

You can change the year or copy paste the entire sheet to another and rename the year

pls mail me at for any clarification

Regards
Jeeva Rajagopal


Attached FilesProvided by community member jrhrmba. Join us to learn and grow with your peers.
File Type: xls EPF INT CALCULATION.xls (25.0 KB, 3157 views)
Found This Useful? +Vote Up This Page Via Google.  

Why Vote? User validation is extremely important for good content to prosper.


Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network. Add the url of this thread if you want to cite this discussion.






Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


13
LIKES

17887
VIEWS

19
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


3M Users, 100K+ Documents & 450K+ Discussions

Share »

Community Support & Professional Insights. Login or Register.
Email/Username     Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network