Here is a National Pension Scheme NPS Calculator for government, corporate, and individual subscribers in Excel to enable better understanding of how the scheme works.
For government subscribers, the asset allocation is fixed: 15% in equity (E) and rest in fixed income (allocation to G – government bonds and C – corporate bonds is not known)
The tax on lump sum corpus withdrawn is assumed to be zero. Some argue that the NPS corpus is the same as gratuity for a government employee and is tax-free. Personally, I
do not agree with this and shall await official confirmation (update see below). In the sheet, I have assumed that the gratuity is tax-free. Do not assume that this is true.
For corporate and individual subscribers, the asset allocation among E, G and C can be varied each year in the NPS calculator.
Also, only 40% of the corpus at the time of retirement is tax-free.
Despite this change, I still believe that one should not Invest Rs. 50,000 in NPS For Saving Tax!
Even if above gratuity interpretation is true for government employees, it makes no sense for them to invest that 50K. In any case, as of now they cannot invest on their own in tier 1. That rule has to be changed first!
Besides, the E component is invested in a large cap index. I think one can do much better than that!
For government subscribers, 40% of the corpus is to be annuitized. Remaining is assumed to be tax-free. This is a screenshot of the memorandum from Budget 2016
For corporate subscribers, 40% of total corpus at retirement is tax-free. Forty percent of the remaining corpus is assumed to be annuitized. The remaining corpus is taxable as per slab.
Here is a screenshot for the NPS calculator for corporates and individuals (click to enlarge).
Kindly note that this is not a recommendation for NPS. In fact you can use this calculator to understand why one should stay away from Corporate NPS, if You Wish to Retire ASAP!
Update 2: NPS: Partial Withdrawal Rules 2016 are just awful! Beware.
Get GameChanger (my second book) + Pranav's Travel Training Kit GameChanger (hardcopy is now available for ₹279 (249 +30 for shipping) and the Travel Training Kit is available for immediate download for ₹150.
Get free, yet comprehensive calculators, tools and analysis delivered to your mailbox! Subscribe to get posts via email
Buy our New Book!You Can Be Rich With Goal-based Investing A book by P V Subramanyam (subramoney.com) & M Pattabiraman. Read more about the book and pre-order now!