As you see I already uploaded a number of calculation sheets for Pension and Commute. These sheets were affective upto 30-06-2015. Now the pay scales have been revised and also there is increase in pension. So I am uploading the Revised Pension & Commute Calculation Sheet 2015. The main features of this sheet are as under:
- You have to just enter the following information in the cells mentioned in the sheet:
- Basic Pay (Last Drawn)
- Total Length of Service (Maximum 30 years)
- Age Rate: That is given in the calculation sheet
- There are two separate sheets for calculation of pension and commute:
- Pension and commute sheet for the employees retired prior to 01-07-2015
- Pension and commute for the pensioners retired or would retire after 01-07-2015
- These sheets calculate Commuted Amount
- These sheets also calculate Net pension including all increases in pension during the previous years of 2010, 2011, 2012, 2013, 2014 and 2015.
Note: These sheets calculate the pension and commute accurately for the pensioners who got 10% increase in pension in 2013 and 7.5% increase in pension in 2015. For the other pensioners I shall soon amend the sheets and upload at this post.