kerala pension calculation formula excel 2020

Kerala Pension Calculation Formula Excel 2020

By Nicole Clark
AD

In the backdrop of Kerala's thriving job market and growing economy, understanding the Kerala Pension Calculation Formula has become increasingly important for both employees and retirees. As we step into 2020, let's delve into the world of pensions in Kerala and explore how to calculate them using Microsoft Excel.

The Kerala Pension Scheme, managed by the Kerala State Government, ensures a regular income to retired employees. The calculation of these pensions involves a few key components, and Excel, with its robust calculation capabilities, simplifies the process. Let's break down the Kerala Pension Calculation Formula and how to apply it in Excel 2020.

Understanding the Kerala Pension Calculation

The Kerala Pension Calculation Formula is based on the following variables:

AD
Pension and commutation Calculator in Excel For Retired Employees
Pension and commutation Calculator in Excel For Retired Employees
Retirement Financial Planner Template In Excel (Download.xlsx)
Retirement Financial Planner Template In Excel (Download.xlsx)
How to Calculation of Average Pension Earnings in Excel
How to Calculation of Average Pension Earnings in Excel

- Total Service (T.S.)

- Basic Pay (B.P.) at the time of retirement

Pension Contribution Calculator Excel Template : HR Benefits Administration Employer Match Tracking
Pension Contribution Calculator Excel Template : HR Benefits Administration Employer Match Tracking
FERS Retirement Calculator - 6 Simple Steps to Estimate Your Federal Pension
FERS Retirement Calculator - 6 Simple Steps to Estimate Your Federal Pension
The Best Retirement Calculator - The Retirement Manifesto
The Best Retirement Calculator - The Retirement Manifesto

- Pension Good Conduct Pay (GC Pay)

Total Service (T.S.)

Total Service is the total number of years an employee has served, calculated from the date of joining to the date of retirement. In Excel, this can be computed using the DATEDIF function:

AD

T.S. = DATEDIF(Start Date, End Date, "y")

Free FERS Pension Calculator | Federal Retirement Income
Free FERS Pension Calculator | Federal Retirement Income
Retirement Withdrawal Calculator
Retirement Withdrawal Calculator
an image of a table with numbers and times for each person in the city,
an image of a table with numbers and times for each person in the city,
The FERS Pension Calculation is Simple - Here's Why
The FERS Pension Calculation is Simple - Here's Why
pension calculator
pension calculator
a bar chart with the words will pensions cover my retirement? and an image of a man
a bar chart with the words will pensions cover my retirement? and an image of a man

Basic Pay (B.P.)

Basic Pay is the salary an employee draws before any deductions or allowances. In Excel, this can be a simple cell with the value of the retiree's basic pay at the time of retirement.

Calculating Kerala Pension in Excel

Once we have the Total Service and Basic Pay, we can calculate the Kerala Pension. The formula for calculating Kerala Pension is:

AD

Pension = (Total Service * Basic Pay * Pension Good Conduct Pay) / 26

How to Calculation of Average Pension Earnings in Excel
How to Calculation of Average Pension Earnings in Excel

Pension Good Conduct Pay (GC Pay)

Pension Good Conduct Pay, or GC Pay, varies based on the service period and is typically a percentage of the Basic Pay. The government of Kerala provides a table for determining GC Pay for different service periods. For example, for services between 10 to 20 years, GC Pay is 50%.

Applying the Formula in Excel

Now that we have all the necessary variables, we can apply the Kerala Pension Calculation Formula in Excel:

AD

Kerala Pension = (T.S. * B.P. * GC Pay) / 26

Remember, all values should be inserted in the correct units. Total Service (T.S.) and Basic Pay (B.P.) should be in years and currency units respectively, and GC Pay should be a decimal (like 0.50 for 50%).

Regularly reviewing and updating the Kerala Pension Calculation Formula in Excel is essential, especially as the government updates its pension policies. This not only helps employees and retirees plan their finances but also contributes towards the broader understanding of Kerala's economic landscape.

AD