Saturday, August 17, 2019

112-Tool-to-calculate-VRS-amount-for MTNL-BSNL-Employees

Important Notes:

1) Please click on the following links for a detailed video. Watch it till the end to get the working of the VRS tool and details of each calculation.
    a) For English ------ here
    b) For Hindi ---------here
    c) For Marathi-------here


2) In the new version of a software tool, leave encashment and the total amount of gratuity amount after the age of 60 years with interest is updated.

As per the VRS schemes for MTNL and BSNL, the following steps will help us to calculate our VRS amount.

Keep the following data ready.

1) Basic pay
2) IDA rate
3) Date of joining in the department
4) Date of actual retirement
5) Date of VRS option
6) Total numbers of EL
7) Total numbers of HPL

Enter the above data in the yellow-colored portion of an excel sheet.

The following results will be available

1) Estimated VRS Amount
2) If, not opted for VRS, the total salary for the remaining period of service
3) Monthly Pension After VRS
4) So, the pension amount received after VRS till remaining service
5) Total amount received along with monthly pension
6) Opt for VRS or not
7) Gratuity Amount
8) Gratuity Amount with 8 % interest after the age of 60 years.
9) Leave encashment.

In this model, an amount equivalent to 35 days of salary for each completed year of service, and 25 days of salary for each year of service left till retirement is considered.

In this VRS calculation for MTNL and BSNL employees, pension amount for the remaining period of service is the most important factor taken into consideration, so that everyone will get an idea about the receivable total amount if opted for VRS along with the receivable amount if not opted.

Now see how to download the software link of VRS calculator for MTNL and BSNL employees:

1) Step 1: Click here for the VRS calculator for MTNL and BSNL employees.
2) Step 2: The following window will be seen. Enter the date using the calendar by double-clicking on the DATE cells or simply Enter it in "MM/DD/YYYY" format


3) After opening the software, the following diagram will be seen

4) Step 4: Enter all the details marked in yellow-colored portion:
5) Step 5: All calculated information will be available.

Please write your valuable comments/suggestions to improve this software tool.

Tag: MTNL, BSNL, VRS, VRS Scheme for MTNL and BSNL Staff, VRS Calculator for MTNL, BSNL Employees, VRS tool for MTNL, VRS tool for BSNL