PF and pension Calculator Xls Download.. CiteHR
CiteHRCiteHR
 
HOME RISE NEW TEAM →|
Home > Country Specific > India
avay shankar Started The Discussion:

Hello Please arrange and provide us the PF and pension with interest calculator on my email id

PRAKIRNG - Member Since: Apr 2010
Please send me the PF & Fund calculator on my e mail ID prakirng@yahoo.co.in. Till today it is not recvd by me.

abbasiti - Member Since: May 2010
There is no upper limit for Eps-95 pension. For pension calculation, the service will be taken into 2 parts. Service before 16.11.95 and service w.e.f 16.11.95. The first one is called as past service and latter one as pensionable service. Past service is divided into 4 slabs. Service upto 11 years, 12 to 15 years, 16 to 19 years and 20 & above. If the salary on 16.11.95 is below Rs. 2500, the monthly compensation will be Rs. 80, 95, 120 & 150 respectively. For Rs. 2500 & above this will be Rs. 85, 105, 135 & 170. This amount is for those who attain 58 years on 16.11.95. In the case of those attain 58 years after 16.11.95, the above compensation will be multiplied by a factor stipulated in table B, according to the difference between 16.11.95 and the date of completion of 58 years.

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 :
EPFO

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.

ABBAS.P.S
Secretary,
ITI Employees' Association,
ITI LTD, PALAKKAD - 678 623,
KERALA, INDIA.
Ph. +91 9447 467 667


Attached FilesProvided by community member abbasiti. Join us to learn and grow with your peers.
File Type: xls EPF Pension.xls (27.5 KB, 800 views)
bimanroy - Member Since: Sep 2010
One pop up is coming up , no download takes place. Only time killing!!
Please provide easy access & user friendly download. I have a log in id, but unable to download it.
bimanroy,

abbasiti - Member Since: May 2010
Dear Bimon Roy,

I don't know what happend to your computer and web connection. To my experience, there is no complication to download. Many of the viewers are making comments after down load. However I shall send it through Email.

Abbas

Found This Useful? +Vote Up This Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. 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.


PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE



3M Users, 100K+ Documents & 450K+ Discussions

Share »


Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
Community Support & Professional Insights. Login or Register.
Email/Username    
Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network