XIRR Examples for Beginners (With Calculations)

XIRR becomes intuitive once you see it applied to real Indian investing situations. This reference article works through a series of examples, from a simple lumpsum to a multi-year SIP with a top-up and a withdrawal, so you can recognise the pattern in your own portfolio. Each example uses rupee figures and realistic dates, and you can reproduce any of them with a free XIRR calculator.

Key takeaway: The gap between your absolute return and your XIRR is a direct clue to how long, on average, your money has actually been invested.

Example 1: One-Year Lumpsum

Deepak invests ₹2,00,000 in an equity fund on 1 April 2024. On 1 April 2025 it is worth ₹2,30,000. There is one investment and one final value exactly a year apart, so XIRR equals the simple return: ₹30,000 gain on ₹2,00,000 is 15%, and the XIRR is 15%. This confirms that for a clean one-year lumpsum, XIRR and the ordinary percentage gain are identical.

Example 2: Multi-Year Lumpsum

Now Deepak leaves the money untouched and it grows to ₹3,04,000 by 1 April 2027, three years after the original investment. The absolute gain is 52%, but spread over three years the annualised XIRR is about 15% a year. This shows why absolute return can look impressive while the annual rate is moderate; XIRR strips out the effect of time to reveal the yearly pace of growth.

Example 3: A 12-Month SIP

Meena starts a ₹10,000 monthly SIP on the 1st of each month in 2024. She invests ₹1,20,000 in total, and by 1 January 2025 the folio is worth ₹1,32,000. The absolute gain is 10%, but because the average installment was invested for only about six months, the XIRR is roughly 18.5%. Beginners are often surprised that the XIRR is nearly double the absolute return, but this is exactly what XIRR is designed to reveal.

Example 4: SIP With a Top-Up

Suppose Meena also invests an extra ₹40,000 lumpsum on 1 July 2024 when markets dipped. Her total invested rises to ₹1,60,000, and the final value on 1 January 2025 is ₹1,78,000. XIRR treats the ₹40,000 as one more dated negative cash flow and returns an annualised figure of around 16%, capturing both the disciplined SIP and the opportunistic top-up in a single number.

Example 5: SIP With a Partial Withdrawal

Imagine Arun runs a ₹5,000 monthly SIP for two years but withdraws ₹30,000 in month 15 for an emergency. That withdrawal is a positive cash flow on its date. With his remaining folio worth ₹90,000 at the end, XIRR combines the investments, the withdrawal, and the final value into one annualised return, perhaps around 13%. No other common measure can handle a mid-way withdrawal so cleanly.

Reference: Absolute Return vs XIRR for a 1-Year SIP

This table shows why you should never read a SIP absolute gain as its annual return; the XIRR is markedly higher because each installment averaged only about half a year invested.

Comparing a SIP With a Fixed Deposit

XIRR shines when you compare a mutual fund SIP with a bank fixed deposit. If your SIP shows an XIRR of 13% and a comparable fixed deposit offers around 7%, you can weigh the extra 6 percentage points of return against the higher risk of equities. This apples-to-apples comparison is only possible because XIRR annualises the SIP correctly. When you eventually redeem, remember that gains are taxed, so factor your tax bracket into the comparison too.

Benefits of Learning From Examples

Working through varied examples builds an instinct for what a reasonable XIRR looks like, so you can spot data-entry errors and interpret your statements confidently. It also teaches you that XIRR gracefully absorbs top-ups, withdrawals, and irregular dates, freeing you from worrying that a non-standard investment pattern will break the measure. This intuition makes you a calmer, more informed investor.

Challenges and Limitations

All these examples use illustrative round figures; your real XIRR depends on exact amounts and dates. Early-stage SIPs show very volatile XIRR because a small change in value moves the annualised figure sharply, so do not over-react to a high or low number in the first year. And every XIRR here is a gross, pre-tax figure that ignores exit loads, so your in-hand return is lower.

Common Mistakes to Avoid

• Reading SIP absolute gain as annual return. The XIRR is usually much higher in year one.
• Forgetting to sign withdrawals correctly. A withdrawal is a positive cash flow, like the final value.
• Over-reacting to early XIRR. First-year figures swing widely and settle over time.
• Ignoring top-ups. Every extra investment is a dated cash flow that affects XIRR.
• Comparing XIRR to a non-annualised number. Only compare XIRR with other annual rates.
• Skipping tax. Post-tax XIRR is what you actually keep.

Best Practices and Expert Recommendations

• Recreate a simple example first. Confirm a one-year lumpsum gives XIRR equal to the plain return.
• Log every cash flow. Keep dates and amounts so examples match your reality.
• Benchmark against a fixed deposit. Use XIRR to judge whether the extra risk is paying off.
• Review yearly, not weekly. Annual XIRR is far more meaningful than daily swings.
• Model changes before acting. Test a top-up or withdrawal in a calculator first.
• Adjust for tax. Estimate the post-tax XIRR before redeeming.

Example 6: Two Funds, Same SIP, Different XIRR

To see how XIRR settles a real question, imagine Pooja runs identical ₹6,000 monthly SIPs in Fund A and Fund B for two years, investing ₹1,44,000 in each. At the end, Fund A is worth ₹1,70,000 and Fund B is worth ₹1,62,000. Both have the same investment dates, so a fair comparison is possible. Fund A works out to an XIRR of about 15%, while Fund B lands near 11%. The four-percentage-point gap is the annualised outperformance of Fund A, information you simply cannot read from the raw values at a glance. If Fund A achieved this with similar volatility to Fund B, it is the clear winner; if it took much bigger swings to get there, Pooja must decide whether that extra risk suits her goal and temperament. This is the everyday decision XIRR is built to inform.

Frequently Asked Questions

Why is my SIP XIRR higher than my total gain?
Because XIRR is annualised and your installments were invested for less than a year on average. A 10% absolute gain on a one-year SIP can translate to an XIRR near 18%.

Does a lumpsum always give XIRR equal to CAGR?
For a single lumpsum with one start and one end date, XIRR and CAGR are effectively the same. They diverge only when there are multiple investment or withdrawal dates.

How does a withdrawal affect XIRR?
A withdrawal is entered as a positive cash flow on its date. XIRR then combines your investments, the withdrawal, and the final value into one annualised return, handling the interruption smoothly.

What XIRR should I expect from an equity SIP?
Over the long term, equity mutual fund SIPs in India have often delivered XIRR in the 12–15% range, though returns vary with markets and are never guaranteed.

Can I compare XIRR with a fixed deposit rate?
Yes. Both are annual rates, so you can directly compare a SIP XIRR with an FD interest rate, keeping in mind the higher risk of equity investments.