What is an XIRR Calculator?
An XIRR calculator measures the true annualised return on investments made on different dates and in different amounts — such as mutual fund SIPs, staggered stock purchases or top-ups. It is the same return measure shown on mutual fund account statements.
Choose Monthly SIP to enter a regular SIP quickly, or Custom to list each investment date and amount, then enter the current value to see your XIRR.
How to use the XIRR Calculator
- 1Choose Monthly SIP or Custom investments.
- 2For a SIP, enter the monthly amount and the first and last SIP dates; for custom, add each date and amount invested.
- 3Enter the current value of the investment and the valuation date.
- 4Read your XIRR, total invested and absolute gain.
XIRR Calculation Formula
- Cᵢ
- — Each cash flow — investments negative, current value positive
- dᵢ
- — Date of each cash flow; d₀ is the first investment date
There is no direct formula, so the calculator solves for the rate numerically — the same approach as Excel's XIRR function.
Example: ₹10,000 monthly SIP for 3 years, now worth ₹4.5 lakh
| SIP period | Jan 2023 – Dec 2025 (36 instalments) |
|---|---|
| Total invested | ₹3,60,000 |
| Value on 1 Jan 2026 | ₹4,50,000 |
| XIRR | ≈ 14.99% |
The absolute return is 25%, but because the average rupee was invested for only about 18 months, the annualised XIRR is close to 15%.
Why XIRR matters for SIP investors
Each SIP instalment stays invested for a different length of time — the first for three years, the last for one month. Simple return or CAGR ignores this and misstates performance. XIRR weighs every rupee by how long it was invested, letting you compare your SIP fairly against an FD rate, a benchmark index or another fund.
Tips for reading XIRR
- XIRR over very short periods (a few months) can look extreme — judge it over a year or more.
- A negative XIRR means your investment is currently below the amount invested.
- Compare your fund's XIRR with the XIRR of an index fund SIP over the same dates.
Related calculators
Results from this calculator are estimates based on the inputs and assumptions you enter. They are for information and education only and are not financial, tax or investment advice.