Loading…
Grinding the numbersCompounding your returnsBrewing your plan
Find the true annualized return of a recurring investment, accounting for the date of every installment.
Total Invested
₹6,00,000
Net Gain / Loss
₹2,50,000
Value at Maturity
₹8,50,000
Value at Maturity
₹8,50,000
XIRR (per year)
13.88%
Time Period
5 yrs 0 mos
60 installments totalling ₹6,00,000 that grew to ₹8,50,000 earned an annualized return (XIRR) of 13.88%.
| Year | Total Invested | Net Gain / Loss | Value |
|---|---|---|---|
| 1 | ₹1,20,000 | ₹8,871 | ₹1,28,871 |
| 2 | ₹2,40,000 | ₹35,631 | ₹2,75,631 |
| 3 | ₹3,60,000 | ₹82,888 | ₹4,42,888 |
| 4 | ₹4,80,000 | ₹1,53,234 | ₹6,33,234 |
| 5 | ₹6,00,000 | ₹2,50,000 | ₹8,50,000 |
XIRR, short for extended internal rate of return, is the single yearly rate that explains how a series of investments made on different dates grew into what you have today. Each installment is treated as if it earned that rate from the day it went in, and the rate is chosen so that everything adds up exactly to the final value.
That makes XIRR the natural way to measure the return on a SIP. Your first installment has been invested for years, while last month's has barely started working. A simple return on the total amount invested ignores that difference; XIRR gives each installment credit only for the time it was actually invested.
Because the answer is an annual rate, you can compare it directly with a fixed deposit rate, inflation, a fund's benchmark or the CAGR of a one-time investment.
The XIRR of a monthly SIP whose current value is 1.25, 1.5 or 2 times the total invested, by how long it has been running:
| Years | Worth 1.25× invested | Worth 1.5× | Worth 2× |
|---|---|---|---|
| 3 years | 15.0% | 28.1% | 50.4% |
| 5 years | 8.8% | 16.2% | 28.1% |
| 10 years | 4.4% | 7.9% | 13.3% |
| 15 years | 2.9% | 5.2% | 8.7% |
Growth on the total invested understates a SIP’s return, because most installments were invested for much less than the full period. A 5-year SIP worth 1.5 times what went in has an XIRR of 16.2%; treating it as one lumpsum gives only 8.4%.
For a single investment with a start and end value, the CAGR Calculator gives the same answer more simply. To project a SIP forward, use the SIP Calculator.
Every scenario below runs for exactly five years, with installments starting on the first day of the first year and the investment valued on the same day five years later. The rows change the ending value, the frequency and the step-up, so you can see how each one moves the XIRR. All figures come from the same formula this calculator uses.
| Scenario | XIRR | Total invested | Net gain / loss | Maturity value |
|---|---|---|---|---|
| ₹10,000 a month, worth ₹7,50,000 after 5 years | 8.84% | ₹6,00,000 | ₹1,50,000 | ₹7,50,000 |
| ₹10,000 a month, worth ₹8,50,000 after 5 years | 13.87% | ₹6,00,000 | ₹2,50,000 | ₹8,50,000 |
| ₹10,000 a month, worth ₹10,00,000 after 5 years | 20.50% | ₹6,00,000 | ₹4,00,000 | ₹10,00,000 |
| ₹1,20,000 once a year, worth ₹8,50,000 after 5 years | 11.83% | ₹6,00,000 | ₹2,50,000 | ₹8,50,000 |
| ₹10,000 a month stepped up 10% a year, worth ₹8,50,000 after 5 years | 6.33% | ₹7,32,612 | ₹1,17,388 | ₹8,50,000 |
| ₹10,000 a month, worth only ₹5,50,000 after 5 years | -3.41% | ₹6,00,000 | -₹50,000 | ₹5,50,000 |
The first three rows invest the same amount on the same dates. Raising the ending value lifts the XIRR from about 8.8% to about 13.9% and then to about 20.5% a year.
Timing matters as much as the totals. Investing once a year instead of every month puts in the same total and ends at the same value, yet the XIRR drops from about 13.9% to about 11.8%, because the yearly installments were invested earlier and had longer to earn that gain.
A step-up puts more money in, mostly in later years. Reaching the same ending value with a 10% yearly step-up means a smaller net gain on a larger total, and an XIRR of only about 6.3%.
If the ending value falls below the total invested, XIRR turns negative: about −3.4% a year in the last row.
Compare this with CAGR. Treating the monthly SIP that grew to the middle value as if the whole amount had been invested on day one gives just over 7% a year — roughly half its true XIRR of about 13.9%.
Different return measures answer different questions. Picking the right one avoids comparing numbers that don't mean the same thing.
| Measure | What it tells you | Best used for |
|---|---|---|
| Absolute return | Total gain as a percentage of the amount invested, ignoring time | A quick look at short holdings |
| CAGR | Steady yearly rate between one starting and one ending value | A single lump sum held without additions |
| IRR | Rate at which evenly spaced cash flows net to zero | Flows at regular, equal intervals |
| XIRR | Yearly rate that accounts for the exact date of every cash flow | SIPs, top-ups, withdrawals and irregular dates |
| Time-weighted return | Fund performance with the effect of your own deposits removed | Comparing funds or fund managers |
XIRR measures your own experience, including when you chose to invest. A fund's published return measures the fund itself. Both are useful, but they answer different questions.
Enter the installment, how often you invest, the start date and what the SIP is worth today. For example, 10,000 a month for 5 years:
XIRR is the yearly rate at which every installment, growing from its own date, adds up to today’s value.
It depends on how long it took. A monthly SIP worth 1.5 times what you put in has an XIRR of:
The same gain over a longer time is a lower return, so compare SIPs by XIRR, not by absolute gain.
XIRR (Extended Internal Rate of Return) is the single annual rate of return that makes the value of all your investments, each compounded from its own date, equal to what you have at the end. It is the standard way to measure returns on a SIP or any investment made in several installments.
CAGR assumes all the money was invested on day one. In a SIP, later installments have been invested for much less time, so CAGR on the total amount understates the real return. XIRR gives each installment credit only for the time it was actually invested.
A step-up puts more money in later, when it has less time to grow. For the same maturity value, a larger step-up means more of your money was invested recently, so the XIRR comes out higher.
Yes. If the maturity value is less than the total amount invested, the investment lost money and XIRR shows the annualized rate of that loss.
It uses the same method as Excel's XIRR function (actual days between dates, 365-day years). Small differences can appear if your real installments fell on slightly different dates, for example after weekends or holidays.
Judge it against what the money could have earned elsewhere over the same dates: inflation, a bank deposit and the fund's own benchmark. Because XIRR is already an annual rate, you can compare it directly with those figures. A high XIRR over one or two years says much less than a similar figure held over a full market cycle.
Both find the rate at which a set of cash flows nets to zero. IRR assumes the flows are evenly spaced, such as exactly one per period. XIRR uses the actual date of each flow, so it copes with uneven gaps, missed months and partial periods — which is how real investments behave.
XIRR is annualized. If most of your money went in only a few months ago and the market has risen, even a modest gain turns into a large yearly rate. Treat XIRR over less than a year or two with caution; it becomes more meaningful the longer you have been investing.
This calculator models a regular schedule — the same installment on every bi-weekly, monthly, quarterly or yearly date, optionally stepped up once a year — ending in a single maturity value. For one-off top-ups, skipped installments or partial withdrawals, use a spreadsheet's XIRR function with your actual dated cash flows.
Enter the maturity value you actually hold or received. If dividends were reinvested, they are already part of that value. Fund expenses are usually already reflected in the fund's price, but exit loads or taxes paid on redemption should be deducted if you want the XIRR of the money you really keep.
Starting from the start date, an installment is placed on every bi-weekly, monthly, quarterly or yearly date before the maturity date. Each installment is increased by the step-up percentage once for every full year that has passed since the start date. The maturity value is treated as a single amount received on the maturity date.
XIRR is the annual rate r at which all these dated cash flows net to zero. It is found numerically: because every investment comes before the single maturity value, there is exactly one such rate, and the calculator narrows in on it by bisection. The chart and table then show what the installments made so far would be worth at the end of each year, growing at that rate.
Installment in year y
Pᵧ = P × (1 + s)^y
XIRR condition
Σ CFᵢ / (1 + r)^((dᵢ − d₀) / 365) = 0
Net gain / loss
Net Gain = Maturity Value − Σ Installments
SIPCafe's calculators and guides are for education and planning only and are not investment, tax or legal advice. Results are estimates based on the assumptions you enter; actual returns vary and are not guaranteed. Consider speaking with a qualified financial adviser before making investment decisions. SIPCafe is not a registered investment adviser and does not recommend any specific security, fund or scheme. All investments carry market risk; read a fund's or scheme's official documents carefully before investing.