Home
Workspace / Financial planning tools

Investment analysis

XIRR Calculator

Estimate annualized investment returns from cash flows that happen on different dates. Enter investments as negative amounts and receipts or current value as positive amounts.

Dated cash flows

Use actual transaction dates for a more meaningful estimate.

1
2

Example: enter an investment as -10000 and a later receipt as 12000. For an investment you still hold, include its current value as a positive cash flow on the valuation date.

Your results

Estimated yearly return (XIRR)9.13%This is the estimated rate per year, accounting for when each amount went in or came out. It is not your total profit.
Total money invested₹1,00,000Adds together every dated amount entered as negative—in other words, money you put into the investment.
Money received or value remaining₹1,30,000Adds together all positive amounts you entered, such as money taken out or the investment’s value on the final date. Include the final value if you still own it.
Simple net result₹30,000Money received or value remaining minus all money invested. This simple difference does not account for timing, so it is not the same as XIRR and is not a tax calculation.

How to read this summary: XIRR estimates the yearly rate of return based on the dates and amounts you entered. The other figures show the total money put in, the total positive amounts entered, and the simple difference between those totals. For an investment you still hold, enter its current value as a positive amount on the valuation date; otherwise, the summary may leave out what the investment is worth today. These figures describe only the cash flows you entered and do not predict future performance.

XIRR guide

How to use an XIRR calculator

XIRR helps answer a practical question: what yearly rate of return did my investment earn, given the dates I put money in and took money out? It is especially useful when you invest more than once, add money at irregular intervals, withdraw part of a portfolio, or need to include the value of an investment you still own. The timing matters because money invested earlier has longer to grow than money invested later.

1. Enter every investment, withdrawal and receipt

Add one row for every cash flow that affects the investment, and use the date the transaction actually happened—not an approximate month or today’s date for every row. Each contribution is a separate entry, even if you make several contributions to the same fund. Enter withdrawals, dividends or other money paid out on their actual dates if you want those amounts included in the return.

If you still own the investment at the end of the period, add its market value as a final positive cash flow dated on the day you value it. This tells the calculator what the investment is worth at the end of the measurement period. Without that final value, the calculation may treat the money you invested as though no value remains, and the result can be misleading.

Using an XIRR calculator for SIP and mutual fund returns

You can use XIRR to estimate the annualized return of a mutual fund investment funded through a SIP or irregular top-ups. Enter every instalment separately as a negative amount on the date it was invested; do not combine all contributions under the first investment date. Add withdrawals or distributions on their actual dates, then enter the portfolio value as a positive amount on the final valuation date if you still own the units. This makes the calculation reflect the timing of each cash flow rather than treating the full contribution total as if it had been invested from the beginning.

2. Use the correct sign for each amount

Think about the cash flow from your point of view. Money leaving your pocket to buy or add to an investment is negative. Money coming back to you—such as a withdrawal or dividend—is positive. The final value of an investment you still hold is also entered as positive because it represents value at the end of the period, even though you have not sold it.

  • −100,000: you invest 100,000.
  • −20,000: you add another 20,000 later.
  • +5,000: you receive a 5,000 distribution or withdrawal.
  • +145,000: on the final date, the investment you still hold is valued at 145,000.

Do not enter the current value as a negative amount, and do not omit additional contributions just because they were made to the same investment. A missing or reversed entry changes the cash-flow pattern that XIRR is measuring.

3. Worked example: two contributions and an ending value

Imagine you invest 100,000 on 1 January, add 20,000 on 1 July, and on 1 January the following year your investment is worth 130,000. You have not sold it; 130,000 is the value you are using to measure performance on that final date. Enter the rows like this:

DateCash flowWhat it means
1 January, Year 1−100,000Initial investment
1 July, Year 1−20,000Additional contribution
1 January, Year 2+130,000Value remaining at the end

Across these entries, you put in 120,000 and the ending value is 130,000, so the simple difference is a gain of 10,000 before considering any cash flows or costs not entered. XIRR answers a different question: it estimates the annualized rate that fits all three amounts and their dates. The second contribution was invested for less time than the first, so treating the full 120,000 as though it had been invested from day one would misrepresent the timing.

4. Understand the result: yearly return is not total profit

The percentage shown as XIRR is an annualized rate. It is the yearly rate that makes the net present value of the dated cash flows approximately zero, using the calculator’s 365-day-year convention. In plain language, it is the yearly rate that best balances the money you put in against the money you received or the value remaining, while accounting for when each amount occurred.

Do not read an XIRR of, for example, 8% as meaning you made exactly 8% in total over the whole period. It means the cash-flow pattern corresponds to an annualized rate of about 8%; your total gain or loss depends on the amounts, dates and length of time involved. XIRR is based on the entries you provide. It does not predict what the investment will earn next year, and it does not guarantee that the same rate will continue.

5. XIRR vs. ROI and CAGR

ROI describes the gain or loss relative to the amount invested, but a simple ROI percentage does not by itself explain how long the money was invested. CAGR expresses growth as an annualized rate between a beginning value and an ending value, and is usually easiest to use when there is one starting amount and no additional contributions or withdrawals. XIRR is designed for dated cash flows that occur at different times, so it is generally more useful for recurring investments, irregular top-ups and partial withdrawals.

These measures can tell different stories because they answer different questions. When comparing investments, use the same measurement period, include equivalent types of cash flows, use consistent valuation dates and compare values in the same currency. Otherwise, a higher figure may reflect different inputs rather than better investment performance.

6. Common mistakes that can distort XIRR

  • Leaving out the ending value: if you still own the investment, enter its value on the date you are measuring.
  • Using the wrong sign: contributions should be negative; money received and the final value should be positive.
  • Entering estimated dates: use actual transaction dates where possible, because the time between cash flows affects the annualized rate.
  • Forgetting a contribution or withdrawal: include every relevant cash flow in the period, not only the first investment and final value.
  • Mixing unlike figures: do not compare one result that includes fees, distributions or a final valuation with another that leaves them out.
  • Assuming taxes and fees are automatically included: only cash flows you enter are reflected. Decide whether you want a before-cost or after-cost view, then enter the relevant amounts consistently.

Important limitations

XIRR is only as reliable as the cash-flow history and final valuation supplied. It does not independently verify transactions, market prices, fees, taxes or currency conversions. If you want an after-fee or after-tax return, make sure the entries reflect the costs or payments relevant to that view; this calculator is not a tax calculation.

Some unusual patterns—such as cash flows that change between positive and negative several times—can produce no valid solution or more than one mathematical solution. In those cases, a single displayed result may not tell the whole story. Check the entries and use the result as a measurement of the cash flows entered, not as investment advice, a forecast or a promise of future performance.

Frequently asked questions

XIRR Calculator FAQs

Common questions about cash-flow dates, signs and interpreting annualized returns.

What is XIRR?

XIRR estimates an annualized return when investments and receipts occur on different dates. It solves for the rate that makes the dated cash flows' net present value approximately zero.

Can I use this XIRR calculator for SIP returns?

Yes. Enter each SIP instalment as a separate negative cash flow using its actual investment date. Add withdrawals or distributions as positive cash flows, and include the current portfolio value as a final positive cash flow if you still hold the investment. The result is an annualized estimate based on those dates and amounts.

How should I enter investments and withdrawals?

Enter money you invest as a negative amount and money you receive or withdraw as a positive amount. Use the actual transaction dates and include the current portfolio value as a positive cash flow on the valuation date if you are measuring an investment you still hold.

Why might XIRR be unavailable?

XIRR needs at least one negative and one positive cash flow and a rate that solves the equation. Unusual cash-flow patterns can have no solution or more than one possible solution; this calculator reports a result only when its numerical method finds a solution.

Is XIRR guaranteed or a prediction?

No. XIRR summarizes the dated cash flows you enter. It does not predict future returns and can be misleading if transactions or current valuation are missing.