PaisaGanit

XIRR Calculator

Find the yearly return on investments and withdrawals made on different dates, such as SIPs and top-ups.

Money invested: minus (−5000). Money received or today's value: plus (10800). Leave unused rows empty.

Cash flow 1
Cash flow 2
Cash flow 3
Cash flow 4
Cash flow 5
Cash flow 6
Cash flow 7
Cash flow 8

XIRR10.71%

Total invested₹10,000
Total received and current value₹10,800
Gain₹800

How it works

XIRR is the yearly rate r that makes the discounted cash flows add up to zero:

Σ Amountk ÷ (1 + r)(Datek − First date) ÷ 365 = 0

  • Invested amounts are negative; amounts received and today's value are positive.
  • Days are counted between actual dates and divided by 365.
  • The calculator narrows r down by repeated halving (bisection) until the sum is zero to many decimal places.

Worked example

You invest ₹1,000 on 1 January 2020 and get ₹1,100 back on 31 December 2020, 365 days later.

  1. −1,000 + 1,100 ÷ (1 + r)365 ÷ 365 = 0, so 1 + r = 1,100 ÷ 1,000 = 1.1
  2. XIRR = 10%
  3. With the three cash flows filled in above (₹5,000 twice, six months apart, and ₹10,800 back a year after the first), XIRR = 10.71%: higher than the 8% total gain divided by the year, because half the money was invested for only six months.

Frequently asked questions

What is XIRR?

XIRR is the yearly return on money that goes in and out on different dates, such as SIP instalments, extra top-ups and withdrawals. It takes into account how long each rupee was invested, which a simple percentage gain does not.

How do I enter my cash flows?

Enter each date and amount. Use a minus sign for money you invested (for example −5000) and a plus amount for money you received, such as a redemption or dividend. For an investment you still hold, add today's date with its current value as a plus amount.

How is XIRR different from CAGR?

CAGR works with one starting amount and one ending value. XIRR handles many amounts on different dates, so it suits SIPs and irregular investing. For a single investment and a single value, both give the same answer.

How does the calculator find the rate?

It looks for the yearly rate at which the value of all your cash flows, each discounted back to the first date by the time since then, adds up to zero. There is no direct formula, so it narrows the rate down step by step. Days are counted actual/365, as spreadsheets do.

Why does it say no rate fits?

You need at least one negative amount (money in) and one positive amount (money out or current value) on different dates. Very unusual patterns of cash flows can also have no single answer.

Can XIRR be negative?

Yes. If you got back less than you put in, XIRR is negative and shows the yearly rate of loss.

Does it match a spreadsheet's XIRR?

It uses the same actual/365 day count, so for the same dates and amounts the result should match to a few decimal places. Small differences can come from rounding.

About these results

Method and timing
Solves for the yearly rate at which all cash flows, discounted by (1 + r)^(days ÷ 365) from the first date, add up to zero (Actual/365), by bisection.
Last verified
Sources
Your data
Runs in your browser; nothing is stored or sent.

This calculator works out the return implied by the cash flows you enter. It is for information only and is not investment advice; past returns do not indicate future returns.