Kerala Pension Calculation Formula Excel 2020
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:
- Total Service (T.S.)
- Basic Pay (B.P.) at the time of retirement
- 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:
T.S. = DATEDIF(Start Date, End Date, "y")
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:
Pension = (Total Service * Basic Pay * Pension Good Conduct Pay) / 26
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:
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.