Mutual Fund Calculator

XIRR Calculator

Measure the annualised return on a SIP, staggered investment or portfolio with withdrawals by respecting the exact date of every cash flow.

XIRR CalculatorExact dates · money-weighted return · no sign-up

MONEY MOVES ON DIFFERENT DATESTurn every investment and receipt into one annualised rate

Only one start and one end? Use CAGR →

MONEY-TIME MAPSee how exact dates shape the annualised result

—

Annualised XIRR—Money-weighted return across all entered cash flows

PROPORTIONAL DATE SPACINGFocus a marker for amount and date

Total invested—all investment rows

Received + ending value—all positive receipt rows

Net cash gain or loss——

Simple cash return—ignores when each cash flow occurred

First-to-last span—

Cash flows included—

XNPV verification—should be approximately zero

—

XIRR measures your cash-flow history—not investment risk

The same XIRR can come from a smooth or highly volatile journey. It is sensitive to entered dates and amounts, can produce multiple mathematical solutions for unusual sign patterns, and does not predict future returns. Include fees, taxes and distributions only through the cash flows you actually paid or received.

Measurement tool only. Compare like-for-like periods and portfolios, and do not double-count an unsold holding as both a withdrawal and an ending value.

Exact dates, one comparable rate

How the XIRR Calculator works

A SIP or portfolio rarely has only one purchase and one sale. XIRR measures a money-weighted annualised return by discounting each investment, withdrawal, dividend and ending value for the exact number of days it was part of the investment.

Build dated cash flows

Investment = negative · Receipt = positive

The interface applies the sign automatically. Add every relevant transaction once and use the portfolio’s current value as the final positive cash flow if it has not been redeemed.

Discount by exact days

Cash flow ÷ (1 + rate)^{Days ÷ 365}

A later SIP instalment influences the result for less time than an earlier instalment. That timing difference is exactly what a simple average or ordinary CAGR misses.

Solve where XNPV is zero

Σ discounted cash flows = 0

The calculator searches across a broad rate range, brackets valid solutions and refines the selected root. The displayed XNPV should therefore be approximately zero.

Worked staggered-investment example

Why ₹45,000 gain is not simply divided by three years

Suppose ₹1,00,000 is invested three years ago, ₹30,000 two years ago and ₹25,000 one year ago. If the holding is worth ₹2,00,000 today, the net cash gain is ₹45,000 and the simple cash return is 29.03%. Because the later amounts were invested for less time, XIRR is approximately 10.67% a year—not 9.68% from merely dividing the simple return by three.

Total invested₹1,55,000three dated contributions

Ending value₹2,00,000positive final cash flow

Money-weighted result10.67%annualised XIRR

Avoid double counting: if you enter the current portfolio value as an ending value, do not also treat the same unsold holdings as a withdrawal. Dividends should be entered only when they were actually paid out rather than reinvested within the quoted ending value.

Formula and investor resourcesMicrosoft Support: XIRR definition ↗SEBI Investor: Return-promise warning ↗

Frequently asked questions

What is XIRR?

XIRR is the annualised money-weighted rate of return for cash flows that occur on different dates. It finds the rate at which the present value of all dated investments and receipts equals zero.

When should I use XIRR instead of CAGR?

Use CAGR for one beginning value and one ending value with no cash flows in between. Use XIRR for SIP instalments, additional purchases, withdrawals, dividends or any portfolio where the timing and size of cash flows differ.

Which cash flows should I enter?

Enter every amount that moved between you and the investment: purchases or SIP instalments as Investment, and withdrawals, dividends or the current ending value as positive receipt types. Do not enter the same ending value twice.

Why can XIRR have more than one answer?

When the sign of cash flows changes more than once, the XNPV curve can cross zero at multiple rates. The calculator detects bracketed solutions and shows the one closest to the conventional 10% starting estimate while displaying a warning.

Can XIRR be negative?

Yes. A negative XIRR means the dated cash flows are equivalent to an annualised loss over the measured period. Check every amount and date before interpreting a surprisingly large positive or negative result.

How should I enter the current portfolio value?

Add the portfolio value as one positive Ending Value cash flow on the valuation date. Do not also enter the same unsold holding as a withdrawal. Separate ending-value rows are appropriate only for distinct holdings valued on the same date.

Should dividends, fees and taxes be included?

Include cash dividends only when they were paid out to you. Reinvested dividends are normally already reflected in the ending value. To measure a net return, enter fees and taxes as additional Investment cash flows when they were actually paid.

Why may this result differ slightly from Excel or another calculator?

Differences usually come from date interpretation, omitted cash flows, rounding, the selected mathematical root or whether a 365-day convention is used. This calculator follows the standard dated XNPV equation and shows the XNPV verification value.

Is XIRR the same as a time-weighted return?

No. XIRR is money-weighted, so larger cash flows have more influence on the result. A time-weighted return separates portfolio performance from the timing and size of investor contributions and withdrawals.