XIRR Calculator

By Vishal Jethwani · Last reviewed · How we check our numbers

XIRR is the annual return of an investment with many cash flows on different dates — the right way to measure a SIP. Fill in your SIP amount, start date and number of instalments, add the current value, and the calculator works out your XIRR. You can also add top-ups and withdrawals. The worked example is a ₹5,000 SIP for 36 months now worth ₹2.2 lakh, an XIRR of 13.35%.

Interactive Sandbox

Quick fill for a monthly SIP

XIRR (annualised return)

—

Net amount invested

₹0

Absolute gain

₹0

Cash flows (investments and withdrawals)

DateTypeAmount (₹)

Advertisement

Worked example

A monthly SIP of ₹5,000 from 2023-11-05 (36 instalments), worth ₹2,20,000 on 2026-11-09:

Total invested
₹1,80,000
Absolute return
22.22%
XIRR
13.35%

Change any input in the calculator above to run your own numbers.

Advertisement

What XIRR means

XIRR (extended internal rate of return) is the single yearly rate that, applied to every cash flow from its own date, makes all your investments and withdrawals add up to the current value. It answers: "What yearly return did my money actually earn?"

Why your SIP needs XIRR, not absolute return

In the example, ₹5,000 a month for 36 months adds up to ₹1,80,000, now worth ₹2,20,000. That is a 22.2% absolute return over three years. Dividing by three (7.4% a year) understates the return, because:

  • the first instalment was invested for 3 years,
  • the last instalment for only a few days,
  • on average, your money was invested for about 1.5 years.

XIRR weights each instalment by how long it was invested and gives 13.35% a year. That is the number to compare with an FD rate or a fund's CAGR.

XIRR vs CAGR vs absolute return

MeasureUse it forExample result
Absolute returnA quick look at total gain22.2%
CAGROne lump sum, held for a periodNot valid for a SIP
XIRRSIPs, top-ups, withdrawals, irregular investing13.35% a year

For a single lump sum with no other cash flows, XIRR and CAGR give the same answer.

How to use the calculator

  1. SIP quick fill: enter the SIP amount, the date of the first instalment and the number of instalments, then press Fill cash flows. Each instalment is placed on the same date every month.
  2. Edit the rows if any instalment was missed, changed or bounced, or add a lump-sum top-up with Add row.
  3. Add withdrawals by setting the row type to Withdrawal (for example, a partial redemption).
  4. Enter the current value and the valuation date from your fund statement or app.

How XIRR is calculated

The calculator solves this equation for r:

Σ Cash flowᵢ ÷ (1 + r)^((dateᵢ − first date) ÷ 365) = 0

Investments count as negative cash flows and withdrawals and the current value as positive. There is no direct formula, so it is solved by trial and refinement (the Newton–Raphson method), the same way Excel does it.

In Excel or Google Sheets: list amounts in one column (investments negative, current value positive) and dates in the next, then use =XIRR(amounts, dates).

What is a good XIRR?

Compare your XIRR with what the same money could have earned elsewhere over the same period:

  • Bank FD: about 6.5%–7% a year.
  • PPF: 7.1% a year, tax-free.
  • Inflation: 5.54% (CPI, September 2026).

An equity SIP's XIRR swings a lot in the first few years. A low or negative XIRR after one or two years is common and says little about the long-term outcome. Judge it over five years or more. To plan future SIPs, see the SIP calculator and the step-up SIP calculator.

Frequently asked questions

Is XIRR the same as the return shown in my mutual fund app?

Most apps and the CAS statement show XIRR for SIP portfolios, so the figure should be close if you enter the same cash flows and current value.

Why is my XIRR higher than my absolute return divided by years?

Because much of your money was invested for less than the full period. XIRR accounts for that; dividing by years does not.

Can XIRR be negative?

Yes. If the current value is less than what you put in, XIRR is negative.

Does XIRR include dividends?

Count dividends you received as withdrawals (positive cash flows) on the dates you received them. For growth plans there are no payouts, so just use the current value.

Why does the calculator say XIRR cannot be found?

You need at least one investment and one positive amount (current value or withdrawal), and the dates must be in order. Check for blank dates or a zero current value.

Share:
Disclaimer: This calculator gives estimates from the inputs you enter. Your actual result depends on the rules applied by your bank, employer or the government on the day. sbicalculator.com is an independent site and is not affiliated with State Bank of India. Spotted an error? Tell us and we will correct it.

Advertisement

Advertisement