Understanding Mutual Fund NAV and Returns

If you've ever looked at a mutual fund and felt confused by terms like NAV, expense ratio, or XIRR, you're not alone. This comprehensive guide will demystify these concepts and show you how to calculate your actual returns—not just what the fund house claims.

What is NAV?

The Basics

NAV (Net Asset Value) is the per-unit price of a mutual fund. It's calculated as:

NAV = (Total Assets - Total Liabilities) / Total Units Outstanding

Example:

• Fund's total assets: ₹1,000 crores
• Total liabilities: ₹10 crores
• Units outstanding: 10 crore
• NAV = (₹1,000 - ₹10) / 10 = ₹99

When is NAV Calculated?

NAV is calculated once daily after market closes (around 9 PM). The NAV you see today reflects yesterday's closing prices.

Common Misconceptions

Myth 1: "Lower NAV means cheaper fund"

Reality: NAV is irrelevant for returns. A fund with ₹10 NAV isn't "cheaper" than one with ₹100 NAV.

Example:

• Fund A: NAV ₹10, grows to ₹11 = 10% return
• Fund B: NAV ₹100, grows to ₹110 = 10% return

Both give the same return!

Myth 2: "High NAV funds are expensive"

Reality: NAV only reflects the fund's history. An older fund naturally has higher NAV due to compounding.

Myth 3: "Buy when NAV is low"

Reality: NAV doesn't work like stock prices. There's no "low" or "high" NAV. Focus on fund quality, not NAV.

How Mutual Fund Returns Work

Types of Returns

1. Absolute Return

Simple return over any period.

Formula:

Absolute Return = [(Current NAV - Purchase NAV) / Purchase NAV] × 100

Example:

• Bought at NAV: ₹50
• Current NAV: ₹65
• Absolute Return = [(65-50)/50] × 100 = 30%

Use case: Comparing returns over the same time period.

2. Annualized Return (CAGR)

Return per year, accounting for compounding.

Formula:

CAGR = [(Ending Value / Beginning Value)^(1/Years)] - 1

Example:

• Invested: ₹1 lakh
• Current value: ₹1.5 lakhs
• Period: 3 years
• CAGR = [(1.5/1)^(1/3)] - 1 = 14.47% per year

Use case: Comparing funds with different time periods.

3. XIRR (Extended Internal Rate of Return)

Most accurate for SIPs and irregular investments.

Why XIRR?

• Accounts for multiple investments
• Considers exact dates
• Handles irregular cash flows

Example:

• Jan 2023: Invested ₹10,000
• Jul 2023: Invested ₹10,000
• Jan 2024: Invested ₹10,000
• Current value: ₹33,500

CAGR won't work here. Use XIRR in Excel:

=XIRR(values, dates)

Result: XIRR = 12.5%

Understanding Expense Ratio

What is Expense Ratio?

The annual fee charged by the fund house for managing your money.

Components:

• Fund manager's fee
• Administrative costs
• Marketing expenses
• Registrar fees
• Custodian charges

How It Affects Returns

Example:

Fund's gross return: 15% Expense ratio: 2% Your actual return: 13%

Over 20 years on ₹10 lakhs:

• At 15%: ₹1.64 crores
• At 13%: ₹1.15 crores
• Difference: ₹49 lakhs!

Expense Ratio Limits (SEBI)

Equity Funds:

• First ₹500 crores: 2.25%
• Next ₹250 crores: 2%
• Beyond ₹1,250 crores: 1.75%

Debt Funds:

• First ₹500 crores: 2%
• Next ₹250 crores: 1.75%
• Beyond ₹1,250 crores: 1.5%

Direct vs Regular Plans

Regular Plan:

• Bought through distributor/advisor
• Higher expense ratio (0.5-1% extra)
• Includes distributor commission

Direct Plan:

• Bought directly from AMC/online platforms
• Lower expense ratio
• No middleman commission

Example over 20 years:

Investment: ₹10,000/month Regular plan (13% return): ₹1.02 crores Direct plan (14% return): ₹1.16 crores Difference: ₹14 lakhs!

Recommendation: Always choose Direct plans.

Exit Load

What is Exit Load?

A penalty for redeeming units before a specified period.

Typical structure:

• Equity funds: 1% if redeemed before 1 year
• Debt funds: 0.25-0.5% if redeemed before 3-6 months
• Liquid funds: Usually nil

How It Affects Returns

Example:

• Invested: ₹1 lakh
• Current value: ₹1.2 lakhs
• Exit load: 1%

Without exit load: ₹1.2 lakhs With exit load: ₹1.2 lakhs - (1% of ₹1.2 lakhs) = ₹1.188 lakhs

Loss: ₹1,200

Strategy: Hold equity funds for at least 1 year to avoid exit load.

Calculating Your Real Returns

Step-by-Step Process

Step 1: Gather Data

• All investment dates and amounts
• Current portfolio value
• Dividends received (if any)

Step 2: Use XIRR

In Excel/Google Sheets:

Date	Cash Flow
01-Jan-2023	-10000
01-Feb-2023	-10000
01-Mar-2023	-10000
...	...
31-Dec-2024	135000

Formula: =XIRR(B2:B26, A2:A26)

Step 3: Compare with Benchmark

Your return: 12% Nifty 50 return: 15%

Analysis: Your fund underperformed. Consider switching.

Common Calculation Mistakes

Mistake 1: Using Simple Average

Wrong: (10% + 20% + 5%) / 3 = 11.67%

Right: Use CAGR or XIRR

Mistake 2: Ignoring Dividends

If you received dividends, add them to your returns calculation.

Mistake 3: Not Accounting for Taxes

Your actual return is post-tax. Factor in:

• LTCG: 12.5% above ₹1.25 lakhs
• STCG: 20%

Mistake 4: Comparing Different Time Periods

Don't compare 1-year return with 3-year return. Annualize both.

Tax Impact on Returns

Equity Mutual Funds

Long-term (>1 year):

• First ₹1.25 lakhs: Tax-free
• Above ₹1.25 lakhs: 12.5% LTCG tax

Short-term (<1 year):

• 20% STCG tax

Example:

Gain: ₹2 lakhs (held >1 year) Tax: (₹2L - ₹1.25L) × 12.5% = ₹9,375

Post-tax gain: ₹1,90,625

Debt Mutual Funds

All gains taxed as per income tax slab

If you're in 30% bracket:

• Gain: ₹1 lakh
• Tax: ₹30,000
• Post-tax gain: ₹70,000

Benchmark Comparison

Why Compare?

To know if your fund is doing better than the market.

Common Benchmarks

Large-cap funds: Nifty 50, Sensex Mid-cap funds: Nifty Midcap 150 Small-cap funds: Nifty Smallcap 250 Flexi-cap funds: Nifty 500

How to Compare

Step 1: Find your fund's benchmark (in factsheet)

Step 2: Compare returns over 3, 5, 10 years

Step 3: Check consistency

Good fund: Beats benchmark in 7 out of 10 years

Average fund: Matches benchmark

Poor fund: Underperforms consistently

Alpha and Beta

Alpha: Excess return over benchmark

• Fund return: 15%
• Benchmark return: 12%
• Alpha: 3% (Good!)

Beta: Volatility compared to market

• Beta < 1: Less volatile than market
• Beta = 1: Same as market
• Beta > 1: More volatile

Ideal: High alpha, low beta

Rolling Returns

What Are Rolling Returns?

Returns calculated over overlapping periods.

Example: 3-year rolling returns

• Jan 2020 - Jan 2023: 12%
• Feb 2020 - Feb 2023: 13%
• Mar 2020 - Mar 2023: 11%
• ...

Average rolling return: 12.5%

Why They Matter

• More accurate than point-to-point returns
• Show consistency
• Reduce timing bias

Good fund: Positive rolling returns in 80%+ periods

Practical Tips

1. Track Your Portfolio

Use apps like:

• Groww
• Zerodha Coin
• ET Money
• Google Sheets (manual)

2. Review Quarterly

Check:

• ✅ Portfolio value
• ✅ XIRR
• ✅ Benchmark comparison
• ✅ Asset allocation

3. Rebalance Annually

If equity allocation exceeds target by 10%, rebalance.

Example:

• Target: 70% equity, 30% debt
• Current: 80% equity, 20% debt
• Action: Sell some equity, buy debt

4. Don't Chase Returns

Last year's top performer is rarely next year's winner.

Focus on:

• Consistent performance
• Low expense ratio
• Experienced fund manager
• Clear investment philosophy

5. Use Direct Plans

Save 0.5-1% annually. Over 20 years, this is lakhs!

Red Flags to Watch

🚩 Frequent fund manager changes Shows instability

🚩 Consistently underperforming benchmark For 3+ years = time to exit

🚩 Very high expense ratio Above 2% for equity, 1.5% for debt

🚩 Huge AUM Above ₹50,000 crores may reduce flexibility

🚩 Style drift Large-cap fund buying small-caps

Case Study: Calculating Real Returns

Rahul's SIP Journey:

Month	Investment	NAV	Units
Jan 2023	₹10,000	₹50	200
Feb 2023	₹10,000	₹48	208.33
Mar 2023	₹10,000	₹52	192.31
...	...	...	...
Dec 2024	₹10,000	₹65	153.85

Total invested: ₹2.4 lakhs Total units: 4,500 Current NAV: ₹65 Current value: 4,500 × ₹65 = ₹2,92,500

XIRR calculation: 14.2%

Benchmark (Nifty 50): 12.8%

Analysis: Rahul's fund outperformed by 1.4%. Good choice!

Final Checklist

✅ Understand NAV is just a price, not a value indicator ✅ Use XIRR for SIP returns ✅ Always choose Direct plans ✅ Compare with benchmark ✅ Account for taxes in return calculations ✅ Review portfolio quarterly ✅ Don't chase last year's winners ✅ Focus on rolling returns for consistency

Conclusion

Understanding NAV and returns isn't rocket science—it's just about knowing the right metrics and avoiding common pitfalls.

Remember:

• NAV doesn't indicate if a fund is cheap or expensive
• Use XIRR for accurate SIP returns
• Expense ratio matters more than you think
• Always compare with benchmark
• Direct plans save lakhs over time

Action item: Calculate your current portfolio's XIRR today. If it's below 12% for equity funds, it's time to review your choices.

---

Disclaimer: This article is for educational purposes. Past performance doesn't guarantee future returns. Consult a SEBI-registered advisor before making investment decisions.