kind send me the excel file containing formulas for calculation of EPF etc

Originally Posted by madhavi47 DEAR TIWARI IAM SENDING U THE FORMAT OF EPF CALCULATION IF U DONT UNDERSTAND THAT BE IN TOUCH WITH |

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

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)

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

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

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 |

M bhushan mutalik from pune. I want to know detail about PF rates chart, how to calculate. Will be very much thankful to you if u can send me on my id , u r free to call also 09730490839. Thanks in advance for ur help.

Bye

TC

Bhushan

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

__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.