Skip to content

Mutual funds

XIRR calculator

Find your yearly return when the money went in on many different dates.

List every time money went in and every time it came back, with the date. Add a row for each SIP instalment, and one for the current value if you still hold it.

Counting when each rupee went in and came out, ₹30,000 put in and ₹36,000 received works out to about 9.4% a year.

Total put in
₹30,0003 payments
Total got back
₹36,0001 receipt
Yearly return (XIRR)
9.4% a yearThe steady yearly rate that matches your dated cash flows.

What next

  • CAGR

    Turn a starting value and an ending value into a smooth yearly growth rate.

  • SIP

    See what a fixed monthly investment in a mutual fund could grow to, for a return you assume.

  • Lumpsum

    See what a one-time investment could grow to over the years, for a return you assume.

  • Goal

    Find the monthly amount that gets you to a target by a date, such as a down payment or school fees.

How it works

XIRR finds the yearly rate that makes all your money in and money out balance, with each amount counted on its own date. It is the right measure when you invested several times, such as through a SIP, or took money out in between.

Find r so that the sum of Amount / (1 + r)^(days / 365) is zero

Money you put in counts as negative and money you got back as positive. Days are counted from the earliest date in the list.

A worked example

Three yearly instalments of ₹10,000 on 3 April 2023, 1 April 2024 and 1 April 2025, and ₹36,000 received on 1 April 2026. You put in ₹30,000, and the rate that balances those dates is 9.4% a year.

What it leaves out

  • Tax, exit load and charges, unless they are in the amounts you enter.
  • Inflation.
  • Any sign that the same rate will repeat. It describes the dates you entered, not the future.

Questions people ask

When should I use XIRR instead of CAGR?

Use XIRR when money goes in or out on several dates. CAGR needs one start and one end value, so it cannot handle a SIP.

What do I enter for the current value of an investment I still hold?

Add a row marked Got back, dated today, with the current value. XIRR then treats it as if you sold everything that day.

Why does another tool show a slightly different XIRR?

Tools differ in how they count days (365 or 365.25), in how they treat dates close together, and in the solver they use. This page uses a 365-day year, as spreadsheets do.

Why does it say it needs money in and money out?

A yearly rate only exists if some money went in and some came back. If every row is the same type, there is nothing to balance.

Can the rate be negative?

Yes. If you got back less than you put in, the rate is negative, and the plain-English line under the result says so.