Understanding XIRR

Your Complete Guide to Portfolio Returns

What is XIRR?

XIRR (Extended Internal Rate of Return) calculates the annualized rate of return for investments with irregular cash flows (purchases and redemptions at different dates).

Unlike simple returns which assume a lump-sum investment, XIRR accounts for:

✅ Multiple investments over time (SIPs, lump sums)
✅ Exact timing of each transaction
✅ Partial redemptions and dividends
✅ Compounding effect

Think of it as: "What annual interest rate would give me the same returns?"

Example: SIP Investment

Your Transactions:

Jan 2024: Invested ₹5,000
Feb 2024: Invested ₹5,000
Mar 2024: Invested ₹5,000
Dec 2024: Current Value ₹16,500

Simple Return vs XIRR:

Method	Calculation	Result
Simple Return	(16,500 - 15,000) / 15,000	10% (over 11 months)
XIRR	Annualized using NPV formula	25.84% (per year)

Why different? XIRR converts your 10% gain over 11 months into an annualized rate, making it comparable across different time periods.

The XIRR Formula

XIRR finds the rate r that satisfies:

NPV = Σ(CF_i / (1 + r)^{(days_i / 365)}) = 0

Where:

CF_i = Cash flow at transaction i (negative for investments, positive for redemptions)
days_i = Number of days from first transaction to transaction i
r = XIRR (the rate we're solving for)
NPV = Net Present Value (must equal zero)

Solution Method: Newton-Raphson iterative method (same as Excel's XIRR function)

Understanding XIRR Columns in Your Report

Column	Meaning	When to Use
XIRR (Inception)	Returns since first investment	✅ Best for overall performance
XIRR (5Y)	Last 5 years	✅ Long-term trend
XIRR (3Y)	Last 3 years	✅ Medium-term performance
XIRR (1Y)	Last 1 year	⚠️ Often N/A (see below)

Why Do I See "N/A"?

1. No Recent Transactions (Most Common)

Your holding: Axis Bluechip Fund
Last investment: January 2023
XIRR (1Y): N/A ← No transactions in last 12 months
XIRR (3Y): 15.20% ✓ Has transactions in 3-year period

This is normal for buy-and-hold investors!

2. Equity Holdings from NSDL/CDSL

Holding: 100 shares of Reliance Industries
Problem: Statement shows units (100) but not purchase price (₹)
XIRR: N/A (needs money amounts, not just units)

Why? NSDL/CDSL statements don't include transaction amounts.

3. No Transactions at All

Holding transferred from another account with no purchase/redemption history available.

📊 Calculate Your Portfolio XIRR

Upload your CAMS/NSDL/CDSL statement and get a comprehensive Excel report with fund-level and portfolio XIRR analysis.

Try Portfolio Parser Now →

What Should I Focus On?

✅ Recommended Metrics

1. XIRR (Inception) - Your overall performance

Shows how well the investment has done since you started
Most reliable metric

2. XIRR (3Y or 5Y) - Long-term trend

Smooths out short-term volatility
Better for comparison with benchmarks

3. Portfolio XIRR - Overall performance

Single number for entire portfolio
Accounts for timing across all investments

⚠️ Use Carefully: XIRR (1Y)

Usually "N/A" for holdings without recent activity
Can show extreme values (300%+) for small recent transactions
Too short to be meaningful

Interpreting Your Results

Positive XIRR

XIRR: +18.5%
Meaning: Your investments grew at 18.5% per year ✅
Status: Good performance (above inflation + market avg)

Negative XIRR

XIRR: -5.2%
Meaning: Your investments lost 5.2% per year ❌
Possible reasons: Market downturn, poor fund selection, wrong timing

Very High XIRR (>50%)

XIRR: 98.6%
⚠️ Check: Recent small transaction? Short time period?
Usually: Not sustainable long-term

XIRR vs Simple Returns

Simple Return (What Fund Houses Show)

Formula: (Current Value - Invested) / Invested

Example: (₹6.5L - ₹5L) / ₹5L = 30%

Problem: Doesn't account for when you invested. Treats 36 monthly SIPs same as 1 lump sum.

XIRR (What We Calculate)

Formula: Finds rate 'r' where NPV = 0

Considers: Every SIP date, every redemption, every dividend

Example: 18.52% per year (annualized)

Benefit: True time-weighted return. Comparable across funds, time periods, investment patterns.

Common Questions

Q: Should I worry if 1Y is N/A?

A: No! It just means no transactions in the last year. Completely normal for long-term investors.

Q: Why is my XIRR lower than my fund's NAV return?

A: You likely invested via SIP (rupee-cost averaging). NAV returns assume lump-sum investment at the start, which is different from your actual cash flows.

Example:

NAV return (fund house): 45% (Jan 2022 to Dec 2024)
Your XIRR: 18% per year
Why: You didn't invest ₹1.8L in Jan 2022. You invested ₹5K every month.

Q: Which XIRR column should I trust most?

A: XIRR (Inception) and XIRR (3Y/5Y). Avoid 1Y.

Q: Can I compare XIRR across different funds?

A: Yes! That's the point. XIRR is annualized and comparable across:

Different funds
Different time periods
Different investment patterns (SIP vs lump sum)

Technical Details

Calculation Method	Newton-Raphson numerical method
Validation	Verified against Excel's =XIRR() function
Accuracy	±0.01% margin of error
Tolerance	1e-6, Max iterations: 100

Portfolio-Level XIRR

Your report includes a single XIRR for your entire portfolio by combining all transactions:

Example:

Holding	Transactions	Current Value
Fund A	-₹10,000 (Jan), -₹10,000 (Jun)	₹22,000
Fund B	-₹5,000 (Mar), -₹5,000 (Sep)	₹11,000

Portfolio Cash Flows:

Jan: -10,000 (Fund A)
Mar: -5,000 (Fund B)
Jun: -10,000 (Fund A)
Sep: -5,000 (Fund B)
Dec: +33,000 (Total current value)

Portfolio XIRR: Calculated on combined cash flows = Single annualized return for entire portfolio

Need Help?

If you see unexpected results:

Check if transactions have valid dates and amounts
Verify at least 2 cash flows exist (investment + return)
Review transaction history for data quality issues
For equity holdings: XIRR requires purchase amounts (often not available in NSDL/CDSL)

Last Updated: February 21, 2026

Version: 1.0 (XIRR Report MVP)