This calculator provides financial projections based on a set of predefined assumptions and calculation rules. The results are for illustrative purposes only and should not be considered financial advice.
I. General & Core Assumptions
- Calculation Start Date: All projections begin from the current date.
- Retirement Age: The age of superannuation is assumed to be 60 years. The calculation runs up to the last day of the month in which the user turns 60.
- Annual Increment: A standard annual increment is applied automatically in the month of January each year. This moves the Basic Pay to the next higher stage within the current Pay Level.
- Dearness Allowance (DA) Cycle:
- The initial DA percentage at the start of the calculation is assumed to be 55%.
- DA is revised semi-annually, in January and July of each year.
- The DA percentage increases by the user-defined value at each revision.
- Rounding: All monetary calculations (salary, contributions, etc.) are rounded to the nearest whole Rupee.
II. Salary Projection Methodology
- Pay Matrix: The calculator uses the 7th CPC Pay Matrix for all calculations. The user's initial Basic Pay must be a valid stage in the selected Pay Level.
- Annual Increment: As mentioned, the Basic Pay progresses to the next stage in the same Pay Level every January.
- Promotion / MACP: When a promotion is added for a specific year:
- The employee moves to the next higher Pay Level.
- The new Basic Pay is determined by finding the next immediate higher value in the new Pay Level, and then granting two additional increments in that new level.
- This event is processed in January of the selected year.
- Pay Revision: When a pay revision is added for a specific year:
- The entire Pay Matrix is updated by multiplying every value by the user-defined fitment factor.
- The employee's current Basic Pay is also multiplied by this factor.
- The DA percentage is reset to 0% immediately following a pay revision, and then grows again from the next DA cycle.
- Total Salary: Calculated monthly as (Basic Pay + Dearness Allowance).
III. Investment & Corpus Calculation
- Contribution Calculation:
- NPS (National Pension System):
- Employee Contribution: 10% of (Basic Pay + DA).
- Government Contribution: 14% of (Basic Pay + DA).
- UPS (Unified Pension Scheme):
- Employee Contribution: 10% of (Basic Pay + DA).
- Government Contribution: 10% of (Basic Pay + DA).
- Investment Allocation (Asset Mix):
- NPS & UPS (LC50): Follows the Auto Choice - Lifecycle Fund (LC50) model, which automatically adjusts the asset mix based on the employee's age:
- Up to age 35: 50% Equity (E), 30% Corporate Debt (C), 20% Government Bonds (G).
- From age 36 to 55: The allocation to Equity (E) decreases by 2% and Corporate Debt (C) by 1% each year. The remainder is allocated to Government Bonds (G).
- After age 55: The allocation is fixed at 10% Equity (E), 10% Corporate Debt (C), and 80% Government Bonds (G).
- UPS (Benchmark): Uses a fixed conservative allocation for the entire duration:
- 15% Equity (E), 50% Corporate Debt (C), 35% Government Bonds (G).
- Assumed Annual Returns (Compounded Monthly):
- The annual rates of return for Equity (E), Corporate Debt (C), and Government Bonds (G) are defined by the user in the "Basic Data" section of the calculator.
- The default values are set to 12% for Equity, and 7% for both Debt and Bonds.
- Disclaimer: These are assumed constant rates of return and are not guaranteed. Actual market returns will vary.
- Corpus Calculation (Future Value - FV):
- The Current Accumulated NPS amount is first split into E, C, and G based on the allocation model for the current age, and its Future Value at retirement is calculated.
- For every month until retirement, the new contribution is calculated and split into E, C, and G.
- The Future Value of each individual monthly contribution is calculated separately until the date of retirement.
- The Grand Total Corpus is the sum of the Future Value of the initial accumulated amount and the Future Values of all subsequent monthly contributions.
IV. Post-Retirement Scenarios & Analysis (20-Year Flow)
- Gratuity (for UPS Scenarios): Calculated as (Number of completed half-year periods of service) × (10% of last drawn salary [Basic + DA]).
- Surplus Corpus (for UPS Scenarios): Calculated as the difference between the final UPS (LC50) corpus and the final UPS (Benchmark) corpus. This amount is assumed to be withdrawn as a lump-sum.
- Scenario Definitions:
- NPS-1 (100% Annuity): 100% of the NPS corpus is used to purchase an annuity. No lump-sum withdrawal.
- NPS-2 (40% Annuity): 60% of the NPS corpus is withdrawn as a tax-free lump-sum. The remaining 40% purchases an annuity.
- UPS-1 (Full Pension): The user receives a lump-sum (Gratuity + Surplus Corpus). They then receive a monthly pension equal to 50% of the last drawn salary, which increases with post-retirement DA revisions.
- UPS-2 (40% Pension): Similar to UPS-1, but the user also withdraws 60% of the benchmark corpus. The monthly pension is reduced to 40% of the full pension amount.
- NPS (same withdrawal as UPS-1): A comparative scenario where the NPS corpus is used to provide the same initial lump-sum as UPS-1. The remaining corpus purchases an annuity.
- Annuity Payout Assumption:
- The monthly payout from an annuity is calculated at a fixed rate of 5.75% per annum of the principal amount used to purchase it.
- It is assumed that the annuity scheme includes a Return of Purchase Price after the 20-year period.
V. Present Value (PV) of Benefits Calculation
- Purpose: To provide a fair, "apples-to-apples" comparison of all scenarios by calculating the total value of all future benefits (lump-sums and monthly payouts) in today's terms (i.e., at the point of retirement).
- Discount Rate: A 4% per annum discount rate (also known as opportunity cost) is used. This represents a conservative, risk-free rate of return.
- Calculation: The Present Value is the sum of:
- The initial lump-sum withdrawal (if any).
- The discounted value of all 240 future monthly payouts.
- The discounted value of the final "Return of Purchase Price" from annuity schemes.
VI. Internal Rate of Return (IRR) Calculation
- Purpose: To calculate the effective annualized return on only the employee's personal contributions, treating them as a long-term investment.
- Investment Basis (Cash Outflows):
- 50% of the initial "Current Accumulated NPS" amount.
- All monthly "my NPS contributions excluding Govt. contributions" amounts until retirement.
- Returns Basis (Cash Inflows):
- The lump-sum amount received at retirement for each scenario.
- All 240 monthly payouts post-retirement.
- The final "Return of Purchase Price" (for annuity schemes).