Loading Display Please Wait
+7 Others
Dear Madhvai,
thanks for the reply. What i exactly need is some formula by which we can caculate how much amount will be accumulated at the year's end at a fixed epf rate (say 8.5%) on the combined monthly EPF shares of Employee and Employer (i.e 12% + 3.67% of {basic+DA})
i have sent the scenario in excel file (sheet2) at your email id.
thanks again
30th December 2007 From India, New Delhi
thanks for the reply. What i exactly need is some formula by which we can caculate how much amount will be accumulated at the year's end at a fixed epf rate (say 8.5%) on the combined monthly EPF shares of Employee and Employer (i.e 12% + 3.67% of {basic+DA})
i have sent the scenario in excel file (sheet2) at your email id.
thanks again
30th December 2007 From India, New Delhi
Dear Sir,
Thanks for the formula sheet, but i suggest that the formula sheet provided by you have to be changed such as if an employees basic salary is more than 6500 then the maximum deduction to the pension should be Rs. 541 but as per you formula it is diffeerent .
Sir just change the formulla and get your statement revised.
Regards
Chandrakant V.
9820592842
(PF, ESI, COntract Labour and other labour law Consultant)
30th December 2007 From India, New Delhi
Thanks for the formula sheet, but i suggest that the formula sheet provided by you have to be changed such as if an employees basic salary is more than 6500 then the maximum deduction to the pension should be Rs. 541 but as per you formula it is diffeerent .
Sir just change the formulla and get your statement revised.
Regards
Chandrakant V.
9820592842
(PF, ESI, COntract Labour and other labour law Consultant)
30th December 2007 From India, New Delhi
hi dear chandrakanth i forgot to mention about the wage limit i
if the wages is less than 6500 then the formula will be calculated as (basic+da)*12% and if it is greater than 6500 it will be fixed as 780 apart from that employer provident fund wii be 780*3.67/12 and family pension fund is 780*8.33/12
madhavi
30th December 2007 From India, Hyderabad
if the wages is less than 6500 then the formula will be calculated as (basic+da)*12% and if it is greater than 6500 it will be fixed as 780 apart from that employer provident fund wii be 780*3.67/12 and family pension fund is 780*8.33/12
madhavi
30th December 2007 From India, Hyderabad
usha HR 
1
1
Thanks a lot
I am in the process of calcualating the PF amoutn for our employees I know the %s but I don't have the format. I was planning toprepare the formula format for PF but You made my work easy.
It helped me a lot.
Thanks
usha
11th July 2008 From India, Hyderabad
I am in the process of calcualating the PF amoutn for our employees I know the %s but I don't have the format. I was planning toprepare the formula format for PF but You made my work easy.
It helped me a lot.
Thanks
usha
11th July 2008 From India, Hyderabad
ghosal 1
1
please give a revised excel calculation sheet for pf with salary more than Rs.6500/- per month.
23rd December 2008 From India, Calcutta
23rd December 2008 From India, Calcutta
sepl 1
1
hi Im new to this site really very useful site. Im looking for Design Engineers who have experience in Manufacturing firm especially ciombatore based motors/pump industry . could anybody can help me how to start my hunt
20th June 2009 From India, Bangalore
20th June 2009 From India, Bangalore
Discuss problems openly with your peers around the world without getting into company specifics. Access to years of such problem discussion data and business material is at your finger tips.
All resources created by our members are available to everyone at no cost.
New Formula.xls
The-Winning-for mula.ppsDisclaimer: This network and the advice provided in good faith by our members only facilitates as a direction. 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.
