Pension Calculator Under Epf Scheme - XLS Download

sir i am employee in national heart institute since august 1981.i am going retirement july 2015, my present basic pay 12700,DA 13589,and total gross salary 34561.
let me know how many i get pension after retirement.
thanks
shyambali yadav

Dear Shyambali Yadav,
Your Past Service Benefit for 14 years (till 16.11.95) - 105
Multiplying factor as per Table B - 4.485
Pension for Past Service - 105 x 4.485 = 471 - (1)
Pension w.e.f 16.11.1995 = pensionable service x pensionable salary / 70 = 19.63 x 7916.67 /70 = 2220 - (2)
Total Pension, (1) + (2) = 471 + 2220 = 2691
Abbas.P.S

this is indeed a great work done abbas. I request you to please share the table b also if you have got as the provided link is not working. this will be very helpful.
thanks

Dear Harpreet Walia,
Table B can be down loaded from EPFO. However I shall reproduce as under :-
51[TABLE B
(See Paragraphs 12 and 14)
FACTOR FOR COMPUTATION OF PAST SERVICE BENEFIT UNDER THE CEASED FAMILY PENSION SCHEME FOR EXISTING MEMBERS ON EXIT FROM THE EMPLOYMENT
YEARS
FACTOR
(1)
(2)
Less than 1
1.039
Less than 2
1.122
Less than 3
1.212
Less than 4
1.309
Less than 5
1.413
Less than 6
1.526
Less than 7
1.649
Less than 8
1.781
Less than 9
1.923
Less than 10
2.077
Less than 11
2.243
Less than 12
2.423
Less than 13
2.616
Less than 14
2.826
Less than 15
3.052
Less than 16
3.296
Less than 17
3.560
Less than 18
3.845
Less than 19
4.152
Less than 20
4.485
Less than 21
4.843
Less than 22
5.231
Less than 23
5.649
Less than 24
6.101
Less than 25
6.589
Less than 26
7.117
Less than 27
7.686
Less than 28
8.301
Less than 29
8.965
Less than 30
9.682
Less than 31
10.457
Less than 32
11.294
Less than 33
12.197
Less than 34
13.173]
51. Subs. by G.S.R. 438(E), dated the 10th June, 2008
Abbas.P.S

Hi, can you give calculation for EPS after recent amendment. My DOB IS 01.01.1963, DATE OF JOINING IS 28.08.1984, Basic as on 1995 was more than 2500 and today is more than 15000. If possible give excel sheet.

Dear Mr. B.K.Roy,
Your past service benefit is 85x7.117 = 605 - (1)
Pension for pensionable service is 15000x27.1224/70 = 5812 - (2)
Total pension (1)+(2) = 6417
Abbas.P.S

Dear Sir, I hv retired from RINL, Vizagsteel on 30-06-2012 as AGM(Personnel). I joined in VSP on 08-06-1977. My contribution for EPFS started from 01-11-1977.I had continuously worked without any breaks in my service till my retirement. Now I would like to know the pension that I should get after my retirement taking into my past service before 1995. Pl send the calculation sheet also. If you need further information, pl let me know, I shall provide the same to you.
Thanking you,
Yours truly
M Gurunadha Rao
mgurunadh@gmail.com
Mobile No.9000828829.

Dear Abbas,
Trust you are doing well.
I want to know that in case a person has withdrawn an amount of PF accumulated and pension fund of his / her service earlier due to unawareness of the rules, can he/she be eligible for continuous service as after leaving that initial job person had joined the new organization and has not completed service of more than 5 years in current organization and at the time of leaving the initial job he / she had about 5 years of service. Is it possible that he / she can be allowed to accumulate both the services that is old one and new one and can he /she be eligible for pension scheme.
Would request you kindly let me know, in-case it is yes then please share the process how should he / she be able to process in this regard.
Regards,
AG

Monthly pension=( Pensionable salary*Pensionable service)/70
Why it is divided by 70? no 80 or 60.
Ashutosh Srivastava

Dear Sir,
Will you please give me an explanation to Salary on separation from service and how it is calculated.