kerala pension calculation formula excel 2021

Kerala Pension Formula 2021: Calculate Pension Instantly in Excel

By Matthew Garcia
AD

Kerala, a coastal state in southern India, offers a popular pension scheme designed to provide financial security to its residents in their twilight years. If you're a resident of Kerala seeking to calculate your pension, you might be wondering about the Kerala Pension Scheme calculation formula. In 2021, the government has simplified the process, making it easier for you to estimate your pension using Excel. Let's delve into the formula and step-by-step process.

The Kerala Pension Scheme, also known as the 'Pradhan Mantri Vaya Vandana Yojana,' is a pension scheme designed especially for senior citizens. The scheme offers a guaranteed pension, making it a great way to secure your future. To calculate your pension using an Excel sheet, you'll need to understand the calculation formula.

Understanding the Kerala Pension Scheme Calculation Formula

The Kerala Pension Scheme calculation formula is based on the proposed pension amount, the number of installments, the rate of interest, and other variables. The formula takes into account the total amount you would like to receive as a pension, the frequency of installments, and the interest rate offered by the scheme.

AD
Pension and commutation Calculator in Excel For Retired Employees
Pension and commutation Calculator in Excel For Retired Employees
How to Calculation of Average Pension Earnings in Excel
How to Calculation of Average Pension Earnings in Excel
FERS Retirement Calculator - 6 Simple Steps to Estimate Your Federal Pension
FERS Retirement Calculator - 6 Simple Steps to Estimate Your Federal Pension

The formula can be complex, but using Excel can simplify the process. Here's a breakdown of the formula and how to apply it in Excel.

Components of the Calculation Formula

The Kerala Pension Scheme calculation formula consists of several components:

Retirement Financial Planner Template In Excel (Download.xlsx)
Retirement Financial Planner Template In Excel (Download.xlsx)
Pension Contribution Calculator Excel Template : HR Benefits Administration Employer Match Tracking
Pension Contribution Calculator Excel Template : HR Benefits Administration Employer Match Tracking
Retirement Withdrawal Calculator
Retirement Withdrawal Calculator
  • P: Proposed pension amount
  • T: Total amount payable (subscription)
  • F: Frequency of installments (monthly, quarterly, half-yearly, yearly)
  • R: Rate of interest per annum
  • I: Inflation factor

Using these variables, the formula calculates the total amount you need to invest to receive the desired pension.

Applying the Formula in Excel

To calculate your pension using the Kerala Pension Scheme formula in Excel, follow these steps:

AD
  1. Open a new Excel sheet and enter the variables (P, T, F, R, I) in distinct cells.
  2. Enter the formula =T/(P*(1+I)^-F) in a new cell where you want the result to appear.
  3. Enter the respective cell references for the variables in the formula (e.g., if you've entered P in cell A1, enter A1 in the formula).
  4. Press Enter. The Excel sheet will now calculate the total amount you need to invest to receive your desired pension.

For instance, if you propose a pension of 10,000 INR per month, want to pay an annual subscription of 100,000 INR, the frequency of installments is 12 (monthly), the annual interest rate is 8%, and the inflation factor is 2%, the Excel sheet should calculate the total amount you need to invest.

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,
Free FERS Pension Calculator | Federal Retirement Income
Free FERS Pension Calculator | Federal Retirement Income
pension calculator
pension calculator
Monthly Retirement Calculator Excel Template
Monthly Retirement Calculator Excel Template
The FERS Pension Calculation is Simple - Here's Why
The FERS Pension Calculation is Simple - Here's Why
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

The Kerala Pension Scheme calculation formula, when properly applied in Excel, can help you plan your financial future with confidence. So, what are you waiting for? Start calculating your pension today and secure your golden years!

Remember, it's always a good idea to consult with a financial advisor or planner when making significant financial decisions. They can provide personalized advice tailored to your unique financial situation.

AD

Joining the Kerala Pension Scheme in 2021

If you're convinced that the Kerala Pension Scheme is right for you, the next step is to join the scheme. In 2021, the application process has been streamlined to make it easier for you to participate.

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

Here's a brief overview of the application process:

Eligibility Criteria

Before you apply, ensure you meet the eligibility criteria. In 2021, the scheme is open to Indian citizens who are above 60 years of age. You must also have a valid Aadhaar or PAN card to apply online.

AD

Application Process

The application process involves a few simple steps:

  1. Visit the official Life Insurance Corporation of India (LIC) website or the Pradhan Mantri Vaya Vandana Yojana (PMVVY) portal.
  2. Click on the 'Apply Online' option and fill in the necessary details, such as your name, date of birth, contact details, and Aadhaar/PAN number.
  3. Enter the desired pension amount, the frequency of installments, and the amount you want to invest.
  4. Review the details and submit the application.
  5. You will receive a confirmation on your registered email ID, and your application will be processed.

Once your application is approved, you will receive your pension as per the schedule you've selected. Regularly review your pension installments to ensure you're receiving the correct amount.

In today's uncertain world, planning for the future becomes increasingly important. The Kerala Pension Scheme, with its guaranteed returns and flexibility in installment frequency, offers a viable solution for senior citizens looking to secure their future. So, why wait? Start planning your financial future today with the Kerala Pension Scheme!

AD