How to Calculate NPS Returns? Method, Formula, and Examples

How Do NPS Returns Work?

The NPS is designed to follow a unit-based investment structure like the mutual funds, so when contributions are made to the NPS, this method is followed:

• The contribution made is invested in the chosen asset classes of the subscriber
• The units are allotted based on the NAV (Net Asset Value), or the net asset value
• The NAV is subject to change as per the market performance
• The subscribers' corpus grows as the NAV increases

Here is what your returns are dependent on:

• Your asset allocation (Equity, corporate bonds, and government securities)
• Market performance
• Fund manager performance
• Investment duration
• Contribution frequency

Absolute Return (For Lump Sum Investment)

Absolute return is used to calculate when you invest in a single lump-sum method.

Formula: (Final Value − Amount Invested) ÷ Amount Invested × 100

Example: You invest ₹1,00,000. After 5 years, it becomes ₹1,50,000. Absolute Return = (1,50,000 − 1,00,000) ÷ 1,00,000 × 100 = 50%

This calculation means that your investment has grown by 50% over the course of 5 years. But this method does not show annual return and only shows the total return over a set course of a period.

CAGR (Compound Annual Growth Rate)

CAGR is used to measure the annual growth of the investment over time.

Formula: (Final Value ÷ Amount Invested)^(1/years) − 1

Same example: ₹1,00,000 grows to ₹1,50,000 in 5 years. CAGR = (1,50,000 ÷ 1,00,000)^(1/5) − 1 ≈ 8.45% per year

The CAGR method is ideal for single investments but not multiple contributions.

XIRR (Extended Internal Rate of Return)

For the NPS investors who contribute monthly or annually, CAGR cannot be used to accurately measure the performance, as the contributions happen at various intervals. For these situations, XIRR is the most accurate method to calculate NPS returns if the investor makes multiple contributions. Here is what the XIRR considers:

• Different dates of contribution
• Varying amounts
• Final corpus value

XIRR is used to calculate the annual returns on all the above-mentioned cash flows.

Why XIRR Is Most Accurate for NPS

The NPS involves multiple contributions, different dates and a changing NAV. The XIRR method accounts for the real investment timing. It is worth noting that even professional financial planners use the XIRR to evaluate portfolio performance.

How to Calculate NPS Returns Using XIRR in Excel

Given below is the method to calculate NPS returns using the XIRR approach in Excel:

Step 1:

Create a table:

The negative values are your investments, and the positive value is your final corpus.

Step 2:

Use the following Excel formula: =XIRR(values, dates)

The result will show the annualised return generated from all your contributions. This method is ideal for calculating the NPS performance.

Example: Monthly Contribution Scenario

Let's understand the monthly contribution scenario with an example.

Assume:

• ₹5,000 invested every month
• Investment period: 10 years

Total contribution = ₹6,00,000 This brings the corpus to ≈ ₹10,30,000 after a period of 10 years

Using the XIRR formula, the returns would be closer to 10% returns. This method shows how the compounding works over a long period.

3 Ways to Calculate NPS Returns (And Why They Differ)

Given below is a refresher on how you can calculate the NPS returns and how and why they differ:

How Asset Allocation Impacts NPS Returns

The NPS returns differ according to the allocation:

• Equity (E) - Higher risk with higher long-term return potential
• Corporate Bonds (C) - Moderate risk with relatively stable returns
• Government Securities (G) - Lower risk with more stable returns
• Alternative Investments (A) - Limited exposure to instruments such as REITs (Real Estate Investment Trust) or infrastructure funds (maximum 5% allocation under PFRDA rules)

1. Aggressive Allocation

   More equity means higher volatility, but it can lead to potentially higher long-term returns

2. Conservative Allocation

   More debt means lower volatility, but provides stable but lower returns

   The investors should invest in balance to moderate growth and control the risk.

How to Check Your Actual NPS Returns

Here is how you can calculate the returns:

• Using the CRA (Central Recordkeeping Agency) portal - Check transaction statements
• By checking the NAV (Net Asset Value) history from the PFRDA website
• Download the statement and apply XIRR in Excel
• Use financial calculators

Factors That Influence NPS Returns

The NPS returns are affected by several factors; here are a few of them that influence them:

1. Market Conditions

   The portfolios that focus on equity tend to perform better in the bullish markets

2. Fund Manager Performance

   Different fund managers also affect the returns, and can affect them slightly

3. Expense Ratio

   The NPS charges very low fees for fund management

4. Investment Duration

   If you invest for longer periods, it compounds your interest and leads to better gains

5. Timing of Contributions

   The investors need to invest consistently to ensure they can smooth out the market volatility

Why Is Calculating NPS Returns Confusing?

Example: Retirement Calculation

Here is the method to calculate the retirement returns:

• Age: 30
• Retirement age: 60
• Monthly contribution: ₹10,000

Total contribution made over 30 years = ₹36,00,000

Estimated corpus ≈ ₹2 crore (approx.)

This is an example to show how compounding can lead to strong gains, but they are subject to varying market situations and risk.

Mistakes to Avoid While Calculating NPS Returns

The investors are likely to make mistakes when calculating the returns, and knowing the mistakes can help you avoid them.

• Using the simple average return instead of CAGR
• Ignoring the timing of contributions when the market conditions are unfavourable
• Not considering the XIRR method of calculation
• Comparing short-term returns
• Forgetting to pay the fund management charges (though minimal in NPS)

Conclusion

The process of calculating the NPS returns begins with the type of contributions you make; for example, if you make lump-sum investments, the CAGR method is suitable. But if you are a regular contributor, then XIRR is the most accurate method.

The NPS is designed to be a long-term retirement corpus accumulation product which focuses on annualised growth instead of short-term changes in the market. The calculation over these periods gives the investor clarity of performance and adjustments. It is important for the investor to understand how to calculate the returns, and monitoring the corpus after calculating allows them to make better allocation-based decisions.