Skip to main content

NYVO Calculator

XIRR Calculator – Mutual Fund & SIP Returns India

Calculate XIRR – the annualised return on dated cash flows. The right measure for SIPs, top-ups and redemptions that happen on different dates.

Last reviewed: · Methodology: India-first (FY 2026-27 · Budget 2024 LTCG).

₹10,000

36 instalments of ₹10,000₹3,60,000 invested in total. Your current value is on your fund statement or app.

XIRR (annualised return)
21.42%
Total invested
₹3,60,000
Value today / received
₹5,00,000
Gain
₹1,40,000

Your money grew at 21.42% a year. The simple “total gain” of 38.9% looks different because most of these rupees were invested for far less than the full period — that gap is exactly what XIRR corrects for.

Now live

Get the NYVO app

Plan, invest and track your family's money in one place. SEBI-registered.

Download NYVO Money on the App StoreGet NYVO Money on Google Play

How to use the XIRR calculator

Calculate XIRR – the annualised return across cash flows on different dates. The correct measure for SIPs, top-ups and partial redemptions.

  1. Enter each investmentOne row per SIP instalment or lumpsum, with its date and the amount as a negative number.
  2. Enter what came backRedemptions as positive numbers on their dates – or one positive row with today's date and the current value of your holding.
  3. Read the XIRRThe annualised rate that makes all the dated flows consistent. Compare it to a fixed deposit or the fund's own stated CAGR.

What is XIRR?

XIRR (Extended Internal Rate of Return) is the annualised return across cash flows that happen on arbitrary dates. Where IRR assumes evenly spaced periods, XIRR reads the calendar: a SIP on the 3rd of every month, a Diwali top-up, and an emergency redemption in March all enter the maths from their actual dates.

It answers one question precisely: given exactly when my money went in and came out, what constant annual rate explains the result?

Why your MF statement uses XIRR

A SIP is 60 or 120 separate investments, each with a different holding period. The rupee you invested five years ago has compounded through two corrections and a rally; the rupee from last month has barely lived. Any single "return %" that ignores this timing is wrong in one direction or the other:

  • Absolute return ("₹12 L became ₹18 L, so 50%") ignores time entirely — 50% over four years is unremarkable; over ten it is poor.
  • The fund's advertised CAGR describes one lumpsum held the whole period — nobody's SIP experience.
  • XIRR weights every rupee by its actual time in the market. That is why CAMS, KFintech and every fund statement report it.

Reading the number honestly

A few things worth knowing before you act on an XIRR figure:

  • Young SIPs swing wildly. Six months of instalments through a correction can show a −20% XIRR that means almost nothing about the decade ahead. XIRR stabilises as history accumulates.
  • It is portfolio-specific, not fund-specific. Your XIRR in a fund can be better or worse than the fund's own CAGR purely because of when you happened to invest. Neither number is "wrong".
  • Compare like with like. Comparing your equity XIRR to an FD rate is fair; comparing a 9-month XIRR to a 10-year FD rate is not.

XIRR vs IRR, in one line

Use XIRR when the dates matter (real MF portfolios); use IRR when cash flows come in clean yearly steps (a business plan, a rental property model).

Frequently asked questions

What is XIRR in mutual funds?

XIRR (Extended Internal Rate of Return) is the annualised return on cash flows that happen on arbitrary dates. Every SIP instalment enters the maths from its own date, so ₹10,000 invested last month isn't treated the same as ₹10,000 invested five years ago. It is the standard your MF statement uses.

Why is my XIRR different from the fund's advertised CAGR?

The fund's CAGR describes one lumpsum held for the whole period. Your money went in on many dates – some of it caught rallies, some caught corrections. XIRR reflects YOUR timing; the fund's CAGR reflects the fund's whole journey. Both are correct answers to different questions.

What is the difference between XIRR and absolute return?

Absolute return ignores time: ₹1 lakh becoming ₹1.2 lakh is '20%' whether it took one year or six. XIRR annualises it – 20% over one year, but only about 3.1% a year over six. For anything held over a year, or drip-fed via SIP, absolute return flatters; XIRR tells the truth.

Can XIRR be negative, and what does that mean?

Yes. A negative XIRR means your investment is currently worth less than what you put in, weighted by time. Common for young SIPs during a correction – a few bad months dominate when the history is short. It says little about the next ten years.

How is XIRR different from IRR?

IRR assumes evenly spaced periods (annual or monthly). XIRR takes actual calendar dates, so it handles a 3rd-of-the-month SIP, a festival-week top-up, and an emergency redemption in the same calculation. For real MF portfolios, XIRR is the one to use – our IRR calculator remains handy for year-spaced business or property cash flows.

Related tools

Other investing calculators that pair with this one.

See all calculators