Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381

Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381

Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381
Pension Details - Xls Download - CiteHR

No Tags Found!

SH

Shai89308

Executive Hr

AS

Ammu Shanvi

Human Resource

GS

G SHASHI KRISHNA

Senior Manager - Hr

AH

Aizant HR

Human Resources

MA

MARSHAL

Safety Officer

AK

Anish Katoch

Hr Executive

PR

PranjalR

Hr Recruiter

AP

Alka Pal

Hr Executive

Karthikeyan8195

Management Consultant

MK

Mohit Kumar Puri

Head Marketing

AU

Austex

Accounts Manager


Kavita Gupta777
Dear Seniors,
Greetings of the Day!!
Hope you all are doing good. I am working in a software company as an Executive HR and i need your kind assistance. Please provide the complete details on pension and my quires are as follows:-
1. What are the criteria or who are eligible for pension
2. How many years of service required and how much for this.
3. What are the types of pension provided by PF office and how to calculate the pension amount.
Again my humble request to all my seniors please share the complete details on this please please
Thanks & Regards
Kavita Gupta
guptakavita777@gmail.com

From India, Hyderabad
abbasiti
517

Dear Kavita Gupta,

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.

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

Besides the above method calculation there will be a minimum for those who have service before 16.11.95. In the EPS-95, they are categorised into three.

1. Date of commencement of Pension before 16.11.2000

2. Date of commencement of Pension between 16.11.2000 & 16.11.2005

3. Date of commencement of Pension after 16.11.2005

As the first two categories are already over, I shall a give a brief on third.

Pensionable benefit (minimum) of Rs. 635 and Past service benefit as mentioned above, subject to a minimum of Rs. 800. This amount is for 24 yrs or more service. If it is less than 24 yrs, this will be reduced in proportionate (amount x actual service / 24). However this amount will be subject to a minimun of Rs. 450.

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, ITI Ltd, PALAKKAD - 678 623

From India, Bangalore
Attached Files (Download Requires Membership)
File Type: xls EPF Pension.xls (29.0 KB, 39 views)

Kavita Gupta777
Dear Abbas,
Greetings of the Day!!
Trust you are doing good. Thanks a ton of your kind support. I don't have any words to appraise this . If i will be any doubt i will approach you. Please be in touch.
Thanks & Regards
Kavita Gupta

From India, Hyderabad
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.




About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.