XIRR Calculator

A mutual fund SIP running for three years, a stock bought and sold at odd dates, a PPF account with irregular deposits — none of these fit neatly into a simple annual return formula. Cash flows happen on different dates and in different amounts, and comparing them fairly needs a return measure that accounts for time.

XIRR, or Extended Internal Rate of Return, solves exactly this problem. It calculates the annualised return of an investment where money moves in and out at irregular intervals, making it the standard way Indian investors compare SIPs, staggered lumpsum investments and portfolio performance.

The XIRR Calculator on FinToolkit simplifies this for the common case of a single investment and a single exit, giving you a quick annualised return without building a cash flow spreadsheet.

What is the XIRR Calculator?

It is a tool that computes the annualised rate of return on an investment given the amount invested, its current or redemption value, and the exact holding period in years and months. For a single inflow and single outflow, this figure is mathematically identical to CAGR.

Fund houses and portfolio trackers use full XIRR to handle multiple, irregular cash flows such as monthly SIP instalments — this calculator handles the simpler but very common two-cash-flow scenario.

How the calculator works

You provide the amount you invested, its current value (or the amount you received on redemption), and how long you held the investment, split into years and months for precision. The calculator converts the holding period into a decimal number of years and solves for the compounding rate that turns your invested amount into the current value over that time.

It also shows the absolute return percentage and total rupee gain, so you can see both the raw gain and its time-adjusted, annualised equivalent side by side.

Formula

Calculation method (step by step)

1. Enter the total amount you originally invested.
2. Enter the current market value or the amount you actually received on exit.
3. Enter the holding period in completed years and remaining months.
4. The calculator converts this to a decimal year figure and raises the value ratio to the power of one divided by that figure.
5. It subtracts 1 and converts the result to a percentage to show your annualised XIRR.

Real-life example

Say you invested ₹5,00,000 in an equity mutual fund and, after 4 years exactly, it is worth ₹8,50,000.

Note how the 70% absolute gain compresses to about 14.2% per year once time is factored in — this is the number you should compare against other investment options, not the headline 70%.

Benefits

• Puts returns on a fair, annualised, comparable footing regardless of holding period.
• Prevents the common mistake of comparing absolute returns across investments held for different durations.
• Useful for tax planning discussions where holding period thresholds matter.
• Quick to use without building a full cash flow model.

Limitations

• Only handles a single investment and single exit; SIPs with multiple instalments need full XIRR calculation, typically done by a fund's own tracker.
• Does not account for taxes, exit loads or transaction charges on the redemption amount.
• Assumes reinvestment at the same rate, which is a theoretical construct rather than a guarantee.
• Figures are educational estimates and actual portfolio-level XIRR from your broker may differ slightly due to intermediate cash flows.

Who should use it

Mutual fund and stock investors comparing a single lumpsum investment's performance, anyone verifying the XIRR shown on their portfolio statement for a single holding, and investors deciding between two investment options with different holding periods should use this tool.

Common mistakes to avoid

• Comparing absolute return of a 2-year investment with the annualised return of a 5-year one.
• Ignoring partial years and months, which can meaningfully change the annualised figure for shorter holdings.
• Assuming XIRR and CAGR are different concepts — for a single cash flow pair they are the same number.
• Forgetting to net off exit load or STT before entering the "current value" figure.

Expert tips

• Always compare XIRR figures, not absolute returns, when judging fund or stock performance across different tenures.
• Use your actual redemption value after taxes and charges for a realistic, take-home XIRR.
• For SIPs with several instalments, use a dedicated multi-cash-flow XIRR function rather than this two-point estimate.
• Track XIRR periodically, not just at redemption, to catch underperformance early.

Frequently asked questions

What is the difference between XIRR and CAGR?

CAGR assumes a single lumpsum investment held for a whole number of years, while XIRR extends the same logic to handle multiple cash flows on different dates. For one investment and one exit, both give identical results.

Can XIRR be negative?

Yes, if your current value is lower than your invested amount, XIRR will be negative, showing the annualised rate at which your investment has lost value. This is common in volatile equity investments during market downturns.

Is XIRR the same as the return shown by my mutual fund app?

It is close but may not match exactly if you made multiple SIP instalments, since apps calculate true XIRR across every cash flow date. This calculator is best suited to a single lumpsum investment and a single redemption.

Why does a shorter holding period give a higher XIRR for the same gain?

XIRR annualises the return, so the same total gain earned faster implies a higher compounding rate. A 30% gain in one year is a much stronger XIRR than the same 30% gain spread over five years.

Does XIRR account for dividends received?

Not automatically in this simplified two-point version — you should add any dividends or payouts received to the current value input to get an XIRR that reflects your total return, including income.

What holding period should I use for an ongoing SIP?

This calculator is not ideal for ongoing SIPs since it treats the investment as a single lumpsum; use a full XIRR tool or your fund statement, which accounts for every monthly instalment's own holding period.

Related calculators

• CAGR Calculator — find the annualised return between two values for a lumpsum investment.
• SIP Calculator — project the maturity value of a monthly SIP before you start one.
• Portfolio Return Calculator — measure overall returns including dividends across your holdings.
• Capital Gains Tax Calculator — estimate the tax due once you know your gain.