Mutual Fund Compare

XIRR calculator

Written and reviewed by Omm · Last reviewed · General information, not investment advice

Find the yearly return on money invested at different times, such as a SIP, top-ups or part withdrawals. Enter each amount with its date and what the investment is worth today; the calculator gives the XIRR, the same figure a spreadsheet’s XIRR function returns.

Related: CAGR calculator · SIP calculator

Money you put in and took out
Value today

What it is worth now

Enter 0 if you have already taken everything out and listed it as withdrawals above. The dates and amounts shown at first are an example.

Your money has grown at 15.08% a year (XIRR), counting the date of every investment and withdrawal.

XIRR (yearly return)

15.08%

Total invested

₹3,00,000

Withdrawals + current value

₹4,00,000

Gain or loss

₹1,00,000

Time from first investment

3.0 years (1,096 days)

XIRR is the same measure a spreadsheet’s XIRR function gives. For money held less than a year it shows the yearly pace, which can look very large or very small.

How it works

XIRR is the yearly rate r at which Σ amountₖ ÷ (1 + r)^(daysₖ ÷ 365) = 0 (investments negative, withdrawals and the current value positive; days counted from the first date)

CAGR works for one investment with one start and one end. When money goes in or comes out on several dates, each amount has been invested for a different length of time, so a single start-to-end rate is wrong. XIRR finds the one yearly rate that explains all the cash flows together.

Enter every investment as "Invested" and every redemption or payout you received as "Withdrawn", each with its date. Then enter what the investment is worth now and the date of that value. If you have sold everything, list the sale as a withdrawal and enter 0 as the current value.

The answer is found by trial: the calculator looks for the rate at which the value of everything you put in, grown to today, equals what you took out plus what you still hold. Days are counted over a 365-day year, as spreadsheets do.

Example. You invest ₹1,00,000 on 10 January in 2023, 2024 and 2025, and the investment is worth ₹4,00,000 on 10 January 2026. The gain is ₹1,00,000 on ₹3,00,000, and the XIRR is +15.08% a year.

Read the guide: CAGR vs XIRR vs absolute return: which one to use?.

Frequently asked questions

What is XIRR?

XIRR (extended internal rate of return) is the yearly return on an investment where money was added or taken out on different dates. It is the single yearly rate that makes all those dated cash flows add up to the current value.

What is the difference between XIRR and CAGR?

CAGR measures the growth of one amount between two dates. XIRR handles many amounts on many dates. For a single investment with no additions or withdrawals the two give the same answer; for a SIP, only XIRR is correct.

How do I calculate the XIRR of a SIP?

Add a row for each instalment with its date and amount, marked "Invested", then enter the current value of your units and today’s date. Your fund statement lists the instalment dates. The fund pages on this site also show the SIP return (XIRR) of each fund over 3 and 5 years.

Is this the same as the XIRR function in Excel or Google Sheets?

Yes. It uses the same definition: the rate at which the net present value of the dated cash flows is zero, with days counted over 365. In a spreadsheet, investments are entered as negative numbers and the final value as a positive number; here you choose "Invested" or "Withdrawn" instead.

Why is the XIRR so high or so low for a short period?

XIRR is a yearly rate. A gain of 3% in one month is shown as the rate you would earn if that pace continued for a whole year, which is far above 3%. For periods under a year, look at the gain in rupees as well.

What is a good XIRR?

There is no single number. Compare it with what the same money would have earned elsewhere over the same dates, such as other funds in the same category or a fixed deposit, and remember that a high XIRR over a short or lucky period says little about the future.

Sources

Rules, rates and definitions on this page come from these official sources. Check the current position there before you decide.

Other calculators