XIRR Calculator

Compute the true annualized return (XIRR) on SIPs, lump sums, and any set of dated cash flows — the right way to measure SIP returns.

Enter each cash flow with its date. Use negative for money invested (out) and positive for money received (in), including your final/current value.

DateAmount (₹, − invested / + received)

Frequently Asked Questions

What is XIRR?

XIRR (Extended Internal Rate of Return) is the annualized return on a series of cash flows that occur on different dates — ideal for SIPs, top-ups, and partial redemptions.

How do I enter cash flows?

Each investment is a negative amount on its date; money received (including your current/final value) is positive. You need at least one of each sign.

Why use XIRR over CAGR?

CAGR assumes a single investment and withdrawal. XIRR handles multiple, irregularly timed cash flows, so it is the correct measure for SIPs.

Understanding the XIRR Calculator

This XIRR Calculator finds the annualized return on a series of irregular cash flows with different dates, such as a SIP with varying contribution dates, lumpsum top-ups, and partial redemptions. Unlike a simple CAGR, XIRR (Extended Internal Rate of Return) accounts for the exact timing and size of every inflow and outflow, making it the standard for measuring mutual fund and portfolio returns. Enter your dated investments (negative) and redemptions or current value (positive). Results are educational estimates of past return and do not predict future performance or constitute investment advice.

How it works

List each cash flow with its date: money you invest is negative, money you receive (or your current portfolio value) is positive. XIRR finds the single annual rate r that makes the net present value of all those dated cash flows equal zero, discounting each by the exact number of days between its date and the first cash flow. Because it weights every flow by precise timing, XIRR handles SIPs, irregular top-ups, and withdrawals correctly where CAGR cannot. The result is an annualized percentage. It is solved iteratively (no closed-form answer), the same method Excel's XIRR function uses.

Solve for r in: sum of [ C_i / (1 + r)^((d_i - d_0)/365) ] = 0, where C_i is each cash flow, d_i its date, and d_0 the first date

Worked example

You invest Rs 10,000 on 1 Jan 2024, Rs 10,000 on 1 Jul 2024, and the holding is worth Rs 22,000 on 1 Jan 2025. Cash flows: -10,000 (day 0), -10,000 (day 182), +22,000 (day 366). Solving the NPV-equals-zero equation gives an XIRR of roughly 13.6% per year. A plain CAGR on total invested would mislead, because the second Rs 10,000 was deployed for only half the period; XIRR correctly time-weights each contribution.

Tips & common mistakes

Use negative values for money paid in and positive for money received or current value.
Include the latest portfolio value as a positive final cash flow to measure return to date.
Dates must be exact; XIRR weights every flow by the precise day gap, not by month count.
Prefer XIRR over CAGR whenever contributions or withdrawals are irregular, as with SIPs.
A single very recent large cash flow can swing XIRR sharply, so review the whole flow list.

Sources & methodology

• Microsoft — XIRR function documentation (https://support.microsoft.com/en-us/office/xirr-function-de1242ec-6477-445b-b11b-a303ad9adc9d)
• AMFI / Mutual Funds Sahi Hai — Understanding returns (https://www.mutualfundssahihai.com/en/calculators)

Reviewed by the TopOpenTools editorial team · Last updated June 2026. These tools provide general estimates for educational purposes only and are not financial, tax, insurance, investment, or medical advice. Verify important decisions with a qualified professional.