Kerala Pension Formula 2021: Calculate Pension Instantly in Excel
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.
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:
- 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:
- Open a new Excel sheet and enter the variables (P, T, F, R, I) in distinct cells.
- Enter the formula =T/(P*(1+I)^-F) in a new cell where you want the result to appear.
- 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).
- 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.
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.
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.
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.
Application Process
The application process involves a few simple steps:
- Visit the official Life Insurance Corporation of India (LIC) website or the Pradhan Mantri Vaya Vandana Yojana (PMVVY) portal.
- 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.
- Enter the desired pension amount, the frequency of installments, and the amount you want to invest.
- Review the details and submit the application.
- 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!