IRR & XIRR Calculator

Find the rate of return on any series of cash flows — a property, a business, an insurance policy or a SIP. Use IRR for yearly cash flows and XIRR when each cash flow has its own date.

Also called rate of return calculator, XIRR calculator for SIP or property IRR calculator.

Cash flows are
DateYearAmount (₹)

Invested or paid = negative (−). Received = positive.

Quick answer

What is IRR and XIRR?

IRR is the yearly rate at which all money paid out and received balances to zero. Enter money invested as negative and money received as positive. Use XIRR when cash flows fall on irregular dates, such as SIPs.

How the calculation works

IRR is the rate at which the present value of all money going out equals the present value of all money coming in — the rate that makes the net present value zero.

Enter money you invest or pay as a negative number and money you receive as a positive number. XIRR does the same using the exact dates, so it suits SIPs, part-payments and irregular returns.

How to use this calculator

  1. 1Choose yearly (IRR) or dated (XIRR) cash flows.
  2. 2Enter each amount — negative for money paid, positive for money received.
  3. 3Read the rate of return.

Good to know

  • You need at least one negative and one positive cash flow.
  • IRR assumes the money received is reinvested at the same rate.

Frequently asked questions

When should I use XIRR instead of IRR?

Use XIRR when the gaps between cash flows are not equal — monthly SIPs, a flat bought in instalments or rent received on different dates.

Why is my IRR negative?

You received back less than you put in, after allowing for time.

These calculators give estimates for planning. They are not tax, legal or investment advice. Rates and rules were checked on 14 November 2026.