enclosed please find a PENSIONABLE SALRY CALCULATOR. I have tried to develop this calculator and in the process some mistakes u may find, so i request u all to please help me if u can prepare a better PENSIONABLE SALRY CALCULATOR, it will be very helpful.
Suggestiona are welcome.
For pensionable service there is a formula to calculate pension. It is Pensionable Salary x Pensionable Service / 70. Pensionable salary can be categorised in to 3. 1) Below Rs. 6500. 2) Rs. 6500 & above, but contribution on statutory celing of Rs. 6500. 3) Above Rs. 6500 & opted to contribute on actual salary. In case of 2nd, pensionable salary is Rs. 6500. In other two cases, pensionable salary will be the average of last twelve months. Also if pensionable service is 20 years & above 2 year's bonus will be given.
For details please see the web site :
One example I shall quote.
Date of Birth - 2.1.1961
Date of join - 23.2.1987
Salary on 16.11.95 - Rs. 2500 & above
Salary on completion of 58 years on 1.1.2019 - Rs. 6500 (Statutory Ceiling)
Past Service - 8 yr 9 m (approx) rounded to 9 years
Compensation - Rs. 85
Factor as per Table B (for less than 24 years, i.e the difference between 16.11.95 & 1.1.2019) - 6.102
(This can be calculated as 1.08 to the power of 24 - 0.5, correct to 3 decimals)
Past Service Benefit - 85 x 6.102 = Rs. 519 - (A)
Pensionable Service - 23 years
Bonus (Service is 20 & above) - 2
Pensionable Salary - Rs. 6500
Pensionable Benefit - 6500 x 25 / 70 = 2321 - (B)
Total Pension - (A) + (B) = Rs. 2840
I shall insert Excel work sheet to calculate pension. Enter Date of Birth, Date of Join, Date of Seperation from Service, Salary on 16.11.95, Salary on Seperation from Service ( in compliance with the contribution to pension fund) and break in service before and after 16.11.95, if any in green colour column. The results will appear in yellow colour column. The red colour is for static information.
In case of any error or suggestion, please notice to me.
ITI Employees' Association,
ITI LTD, PALAKKAD - 678 623,
Ph. +91 9447 467 667
Please include in the calculation method those who are not completed 10 years of service How much they will get pension
For Best Calculation of PENSION & WITHDRAWAL BENEFIT Please visit this link:
Those who have not completed 10 years in EPF are not eligible for PF pension and hence there is no room to raise such a question.
In the above excel sheet I have included all details including the nearest date for pension entitlement, which I didn't experienced from any other site. Even then you have quoted the best calculation is from "epfkerala".
Piease go thoroughly through my excel sheet.
Why Vote? User validation is extremely important for good content to prosper.