Please find attached an Excel File for calculating the payouts from NPS and UPS. This can be used for comparing the benefits of both NPS/UPS and can be used as a guide before deciding which option is to be given to select either NPS or UPS.
- Comparison ==> Know and compare NPS/UPS values in brief
- DataFull ==> Detailed Calculation sheet
- Example ==> show a real time calculation of 2 persons for comparison
- PayLevel ==> check BP hike
Some of the assumptions used for calculations are:
- Salary hike as per coming 8th CPC assumed to be w.e.f Jan-2026
- Return rate from NPS annuity is taken as 6% p.a.
- It doesn’t consider the salary hike due to promotion or another pay Commission or for any other reasons.
Hope everyone will benefit from this excel sheet and wisely choose NPS/UPS.
