Entry 1
₹
Entry 2
₹
Entry 3
₹
Entry 4
₹
Yearly return (XIRR)
9.3883%

Investing ₹3,00,000 and getting back ₹3,60,000 on these dates works out to about 9.3883% a year.

Money in and out
Total invested₹3,00,000
Total received or value today₹3,60,000
Gain₹60,000
XIRR finds the yearly rate at which all the amounts, each discounted by its date, add up to zero. It uses 365-day years, like spreadsheet XIRR. Past returns do not promise future ones.

What is XIRR?

XIRR (extended internal rate of return) is a financial metric that calculates the annualized rate of return for irregular or non-periodic cash inflows and outflows. This calculator works out the effective annual growth rate of an investment portfolio containing multiple dated contributions, partial withdrawals, and the current residual asset valuation.

How it's calculated

Σ amountₖ ÷ (1 + r)^(daysₖ ÷ 365) = 0

Invested amounts count as negative and amounts received, or the value today, as positive. daysₖ is the number of days from the first entry. r is found by trying rates until the sum is zero.

Assumptions

  • Years are 365 days, as in spreadsheet XIRR.
  • Each entry happens on its date; taxes and charges are whatever you include in the amounts.
  • XIRR describes past cash flows. It does not predict future returns.

Worked example

Investing 10,000 on 1 January in 2023, 2024 and 2025, with a value of 36,000 on 1 January 2026, is an XIRR of about 9.39% a year.

Common scenarios

Illustrative worked scenarios in rupees. Rates and growth are assumptions; actual outcomes can differ.

  • The dated cash flows -₹10,000 on 1 January 2023, ₹11,000 on 1 January 2024 have an annualised XIRR of 10%. This describes the entered cash flows, not a future return. Try these inputs

  • The dated cash flows -₹1,00,000 on 1 January 2023, -₹50,000 on 1 January 2024, ₹1,85,000 on 1 January 2026 have an annualised XIRR of 8.15%. This describes the entered cash flows, not a future return. Try these inputs

  • The dated cash flows -₹5,00,000 on 1 January 2024, ₹4,50,000 on 1 July 2025 have an annualised XIRR of -6.79%. This describes the entered cash flows, not a future return. Try these inputs

  • The dated cash flows -₹10,00,000 on 1 January 2020, -₹2,50,000 on 1 January 2022, ₹20,00,000 on 1 January 2026 have an annualised XIRR of 8.71%. This describes the entered cash flows, not a future return. Try these inputs

Questions

Can I use the XIRR calculator for SIP or lumpsum cash flows?

Yes. Enter each amount above zero with its date. Select Invested for contributions and Received, or value today for withdrawals or the final value. The calculator assigns cash-flow signs and finds a yearly rate matching the dated amounts; at least one invested and one received entry are needed.

How is XIRR different from CAGR?

CAGR fits one amount in and one out. XIRR handles many amounts on different dates, such as monthly SIP instalments.

What do I enter as the last entry?

The value of the investment today, marked as received, as if you sold it today.

Why does it say no return could be found?

There must be at least one amount invested and one received. Very unusual patterns of entries can also have no single rate.

Sources

Add it to your site

Show this calculator on your own website or blog, free. It keeps working as we update it.

Add ?theme=light to the address for a light background. Change the height to fit your page.

Reviewed