How To Calculate Pf With Interest - Xls Download

Dear All,
Can any one tells me how we can calculate FINAL amount of PF?
My last basics was 6000 & 12% of this was PF i e 720.
I worked there for 9 months.
I had also submitted the PF withdrawal form.
But i want to know how to calculate the final amount for PF including interest.
If any one knows this then please let me know.
Dear All,
I hav receined the cheaqe of amount Rs 8970.00 with interest.
Thanks & Regards
Darshan Palkar

[quote=darshan.palkar;487641]Dear All,
:)12% on basic+13.61% on basic its employers contribution+pf office give me a intrest on that final that is 6%, so u get 14659/-Rs:icon1:

PF calculation is as follows
Employee Contribution = 720 * 9 (No of months worked) ---- A
Employer Contribution = 720 * 9 (No of months worked) ---- B
% of interest = Approximately 8% ---- C
Total of all the above (A + B + C) gives u the approximate PF amount.

Sorry fo rthe late reply. Employer puts in the same percentage as that of employee but the remaining 1.61% goes towarsds admin charges.

Dear all,
Please offload this file to citehr. it is easier to get download for every one use.
Regards,
Mahesh

Hi darshan,
The details are given below
Your contribution (6000 x 12 % ie. 720 per month) for 9 months : 9 x 720 = 6480
Employer Contribution ( 6000 x 3.67% ie. 220.20 per month) for 9 moths : 9 x 220.20 = 1981.80
Interest for 9 months : (6480 + 220.20 ) x 8 % x9/12 = 507.71
TOTAL : (6480 + 1981.80 + 507. 71 = 8969.51 ) rounded to 8970
NB: You have still contribution in Employee Pension Fund ( 6000 x 8.33% x 9 months = 4500/-). You can withdraw the same or you can obtain a scheme certificate
with regards,
Jishnu.V.Nair
Tax & EPF consultant
Kerala
[Login to view]

if basic is more than 6500, the p.F will be Rs780????
or it is 12% of basic +780
Can any1 help with this???

Dear Darshan,
I have calculated out your PF for 9 months working with Rs. 6000 basic salary @ 12% on your PF contribution,
for PF Rate of Interest is 8.5% per annum cumulative
Sum Days Interest Cumulative
Aprl 720 364 61 781
May 720 335 117 1618
Jun 720 304 166 2504
July 720 274 206 3429
Aug 720 243 235 4384
Sep 720 212 252 5356
Oct 720 182 258 6334
Nov 720 151 248 7302
Dec 720 121 226 8248
Jan 90 173 8421
Feb 59 116 8536
March 31 62 8598
If you have received the amount immediately after 31 march you are suppose to receive Rs 8598/- considering you have started working from 1st April
any one can correct me,

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