Investments

Link copied!

XIRR Calculator

This XIRR (Extended Internal Rate of Return) calculator finds the annualised return for cash flows that happen at irregular dates. Add every investment and withdrawal and your XIRR updates instantly.

Your transactions

Transaction 1

Transaction 2

Transaction 3

Transaction 4

How these compare

vs. typical India long-term ranges

Your XIRR: 15.1%

India long-term equity avg: 10–13%

Conservative

These are example numbers. Edit any input on the left to see your own.

Your annualised return (XIRR) is

15.1%

₹1.50 L → ₹2.00 L

Total invested

₹1.50 L

Total received

₹2.00 L

Cash flow timeline

1 Apr 2021

-₹50,000

1 Apr 2022

-₹50,000

1 Apr 2023

-₹50,000

1 Apr 2024

+₹2.00 L

Timing sensitivity

See how much moving your last transaction's date would change your XIRR.

Your actual timeline

4 transactions

15.1%

XIRR

Baseline

Last transaction 1y earlier

2 Apr 2023

30.2%

XIRR

+15.1pp

Last transaction 1y later

1 Apr 2025

9.9%

XIRR

-5.1pp

Worked example, using your numbers

A step-by-step walkthrough of how your transactions become your XIRR.

Step 1 · Total invested

Across every "Invested" transaction, you've put in

₹1.50 L

Step 2 · Total received

Across every "Redeemed" transaction, that grew to

₹2.00 L

Step 3 · Solving for the rate

The rate that makes every dated cash flow balance to zero is

15.1%

✓

Your cash flows annualise to 15.1%, the constant yearly rate that explains your exact transaction history.

Personalised insights

What your numbers reveal, and what changing them would do.

Your money grew from ₹1.50 L to ₹2.00 L

Across 4 transactions, that's a net gain of ₹50,000, annualising to a 15.1% XIRR.

Your XIRR beats the long-term Nifty 50 average by 3.1pp

The Nifty 50 has historically averaged around a 12% long-term CAGR. Your actual cash flows annualise to 15.1%.

At this rate, your money roughly doubles every 4.8 years

Using the Rule of 72, a 15.1% XIRR implies a doubling time of about 4.8 years.

Holding your last transaction 1 year later moves your XIRR to 9.9%

Shifting only the date of your most recent transaction (1 Apr 2024) by a year changes your annualised return by -5.1pp.

How this is calculated

Every step of the math behind your result, shown in the open.

Setting up the equation

CF_i = cash flow i (negative if invested, positive if received), d_i = days since the first cash flow

Every cash flow is discounted back to the date of the first one, using its exact day count. The XIRR (r) is the rate that makes all of these sum to exactly zero.

Example: 4 cash flows from ₹1.50 L invested to ₹2.00 L received → solved for r

Solving it iteratively

r_n = rate guess at step n, f = the equation above

Since there's no algebraic solution, this calculator starts from a 10% guess and repeatedly refines it (Newton-Raphson) until the equation's result is close enough to zero.

Example: Starting guess 10% → refined to 15.07%

Estimating doubling time

XIRR = annualised return as a percentage

The Rule of 72 gives a quick estimate of how long it would take your money to double if it kept compounding at your calculated XIRR.

Example: 72 ÷ 15.1 → ~4.8 years to double

Assumptions

Every cash flow uses its exact date, not whole years. Days are counted precisely.
Needs at least one investment and one withdrawal or current value to solve.
Figures are indicative and pre-tax, not financial advice.

Understanding XIRR

The concept, the motivation, and what to watch out for.

What is XIRR?

XIRR (Extended Internal Rate of Return) is the annualised return for a series of cash flows that happen on irregular dates and in irregular amounts, like ad-hoc SIP top-ups, partial withdrawals, or a mix of investments over time.

Unlike CAGR, which only works for a single beginning and ending value, XIRR handles any number of cash flows on any dates, making it the right measure for real-world portfolios that rarely grow through one clean lump sum.

Every rupee is dated exactly

XIRR accounts for the exact number of days each cash flow was invested, not just whole years: money invested for 400 days is treated differently from money invested for 365.

There's no simple formula

XIRR is solved iteratively (this calculator uses Newton-Raphson) rather than computed directly, since there's no algebraic way to isolate the rate when cash flows are irregular.

How this XIRR calculator helps

Add every investment and withdrawal with its date, and your XIRR updates instantly, with the underlying equation and a visual timeline shown alongside it.

Did you know?

A few facts behind XIRR and irregular cash flows.

The Rule of 72

Divide 72 by your XIRR to estimate doubling time, the same way you would with CAGR or any other annualised rate.

Excel

XIRR started as a spreadsheet function

The XIRR formula is a long-standing built-in function in Excel and Google Sheets, used for exactly this kind of irregular cash flow analysis.

Mutual fund XIRR is what most apps show you

Most Indian mutual fund and portfolio-tracking apps use XIRR under the hood to show your annualised return once you've made more than one investment.

≠

Not the same as absolute return

A 50% absolute return over 5 years is very different from a 50% absolute return over 1 year; XIRR annualises both so they can be fairly compared.

Frequently asked questions

Straight answers to the questions we hear most about this XIRR calculator.

What is XIRR?

XIRR (Extended Internal Rate of Return) is the annualised return for a series of cash flows that occur on irregular dates and in irregular amounts, such as multiple investments and withdrawals over time.

What is the XIRR full form?

The XIRR full form is Extended Internal Rate of Return. It's an extension of IRR built to handle cash flows on irregular dates rather than a fixed schedule.

What does XIRR mean, and what's the XIRR meaning in mutual fund investing?

XIRR means the single annualised rate that, if applied to every cash flow on its actual date, would produce your exact final outcome — the standard way to measure returns when money goes in and out at different times, especially in mutual funds.

What is XIRR in mutual funds, and how is mutual fund XIRR different from a simple return?

It's the standard way to measure returns on SIPs, top-ups, or any mutual fund investment made in multiple instalments rather than one lump sum, since it correctly weights each instalment by how long it's actually been invested.

How is XIRR different from CAGR, and when does CAGR vs XIRR actually matter?

CAGR only works for a single beginning and ending value over a whole number of years. XIRR handles any number of cash flows on any dates, which is why it's the standard measure for SIPs, top-ups, and partial withdrawals.

What do I need to calculate my XIRR?

Every cash flow in and out of the investment, with its date and amount: every investment (money going in) and every withdrawal or current value (money coming out or what it's worth today).

Can XIRR be negative?

Yes. If your total received is less than what you invested, your XIRR will be negative, reflecting an average annual loss.

Why might this calculator show 'unable to solve'?

XIRR needs at least one negative cash flow (an investment) and one positive cash flow (a withdrawal or current value) to find a rate. With only one direction of cash flow, there's no rate that solves the equation.

Is this financial advice?

No. This tool provides indicative estimates based on your assumptions. Consult a certified financial advisor before making investment decisions.