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.
Connect with us on social media
- Twitter @freefincal
- Subscribe to our Youtube Videos
- Posts feed via: Feedburner
- We are also on Google Plus and Pinterest
Do check out my books
My first book is now available at a 35% discount for Rs. 258. It comes with nine online calculators. Get it now . The Kindle edition is only Rs. 199.
Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You WantMy second book is now only Rs 199 (Kindle Rs. 99) Get it or gift it to a young earner
The ultimate guide to travel by Pranav SuryaThis is a deep dive analysis into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, how travelling slowly is better financially and psychologically with links to the web pages and hand-holding at every step. Get the pdf for ₹199 (instant download)
Free Apps for your Android PhoneAll calculators from our book, “You can be Rich Too” are now available on Google Play!
Install Financial Freedom App! (Google Play Store)
Install Freefincal Retirement Planner App! (Google Play Store)
Find out if you have enough to say "FU" to your employer (Google Play Store)