ToolHub

XIRR & IRR Calculator

Calculate the annualised XIRR and IRR of any investment — mutual fund SIPs, lumpsums, stocks, or bank schemes — from your dated cash flows, and see the absolute profit.

XIRR is simply the real annual return (%) of an investment when you add or withdraw money on different dates — the honest way to judge a mutual-fund SIP, where every instalment goes in on a different day. Enter what you invested and what it's worth now, and you get one comparable yearly figure. New to XIRR? Read this first.

Enter money you invest as a negative amount and money you receive (redemptions, dividends, or the current value today) as a positive amount. XIRR annualises returns across irregular dates — ideal for mutual-fund SIPs, lumpsum investments, stocks, and bank schemes. IRR assumes cash flows at equal intervals (e.g. one per month or year).

Cash flows

Interval:
—

= per

Invested
Received / value
Net profit
Absolute return

Absolute return is the plain profit ÷ invested. is the annualised rate that accounts for when each rupee went in or came out — the number to compare across investments.

What is XIRR — and when do you use it?

Imagine a bank account that would have to pay you a certain interest rate to turn your investments into exactly what you have today. XIRR is that yearly rate — your investment's true annual return. What makes it special is that it accounts for when each amount went in or came out, so it works even when your investing is irregular (like a monthly SIP). It's normally shown as "% per year".

Where an XIRR calculator is used:

  • Mutual fund SIP returns — each instalment is invested on a different date, so XIRR is the only fair way to state the return. It's the same number your fund app or Groww/Zerodha shows as "XIRR".
  • Lumpsum + SIP together — a one-time investment plus regular top-ups in the same fund.
  • Stocks or ETFs bought on different dates and partly or fully sold.
  • Comparing two investments fairly — e.g. a mutual fund vs an FD or PPF — on the same annual basis.
  • Insurance / ULIP / bank schemes with irregular premiums and payouts, to find their real yield.
  • Any project (even real estate) where money goes in and out at different times.
Why not just "profit %"? A plain absolute return (profit ÷ invested) ignores time — ₹5,000 profit in 1 year is far better than ₹5,000 profit in 5 years. XIRR turns everything into one yearly rate so you can actually compare. And unlike CAGR (which only works for a single lumpsum), XIRR handles many cash flows on many dates.

How XIRR is calculated

XIRR (Extended Internal Rate of Return) is the annual rate r that makes the present value of all dated cash flows sum to zero:

Σ  Ci ÷ (1 + r)(di − d0) ÷ 365 = 0

where Ci is each cash flow (negative when invested, positive when received), di its date and d0 the first date. Because the exact gaps between dates are used, XIRR is the correct measure for a SIP or any irregular investment — a plain absolute return can't do this. It is solved numerically (there is no closed form). Plain IRR is the same idea when every cash flow is one equal period apart: Σ Ci ÷ (1 + r)i = 0.

Example: investing ₹10,000 on the 1st of Jan, Apr, Jul and Oct (₹40,000 total) and holding a value of ₹45,000 the next 1st of Jan is a 12.5% absolute return, but an XIRR of about 20.4% per year, because the later instalments were invested for less time.

Planning future SIP contributions instead? Use the SIP Calculator. For fixed-return schemes, compare with the PPF, FD and RD calculators.

About XIRR & IRR Calculator

Find the true annualised return of an investment with irregular cash flows — mutual fund SIPs, lumpsum purchases, stocks, or bank schemes. XIRR (Extended Internal Rate of Return) accounts for exactly when each rupee was invested or withdrawn, and the calculator also shows your absolute profit. Everything runs in your browser.

How to Use

  1. Choose XIRR for dated cash flows (the usual choice) or IRR for equal periods.
  2. Add a row for every transaction — enter its date and amount.
  3. Enter money invested as a negative number and money received (including today's current value) as a positive number.
  4. Read your annualised XIRR/IRR, net profit, and absolute return.

Why Use This Tool?

Frequently Asked Questions

What is XIRR in mutual funds?

XIRR is the single annualised rate of return that accounts for the exact dates and sizes of every investment and withdrawal. Because SIP instalments go in on different dates, a simple average or absolute return is misleading — XIRR is the standard way to measure real SIP or portfolio performance.

What is the difference between XIRR and CAGR?

CAGR assumes a single lumpsum invested for one period, so it only works for a single buy-and-sell. XIRR handles many cash flows on different dates, like a SIP. For a single lumpsum held for a whole number of years, XIRR and CAGR give the same answer.

What is the difference between XIRR and IRR?

IRR assumes cash flows arrive at equal intervals (say, once a month). XIRR is the same idea but uses the actual calendar dates, so it is accurate when your investments and withdrawals are irregular. Use XIRR for real-world mutual-fund and stock investing.

How do I calculate XIRR for my SIP?

List every SIP instalment as a negative amount on its date, then add today's fund value (or the redemption amount) as a positive amount on its date. XIRR is the rate r that makes the discounted sum of all cash flows zero: Σ Cᵢ ÷ (1 + r)^((dᵢ − d₀)/365) = 0. This tool solves it for you.

What is a good XIRR?

It depends on the asset. For Indian equity mutual funds over the long term an XIRR of roughly 10–14% is typical; debt funds and fixed schemes are usually lower. Compare an investment's XIRR against a relevant benchmark rather than a fixed target.

Why is my XIRR negative or blank?

A negative XIRR means you have received less than you invested so far. A blank result usually means you have not entered at least one negative (investment) and one positive (redemption or current value) amount, which XIRR needs to find a rate.

When should I use an XIRR calculator?

Use XIRR whenever money went in or out on different dates: mutual-fund SIPs, a lumpsum plus top-ups, stocks or ETFs bought over time, insurance/ULIP or bank schemes with irregular premiums, or to compare two investments (say a fund vs an FD) on the same yearly basis. A SIP calculator only projects a future value at a fixed assumed return — XIRR measures the actual return you really earned.

Related tools

CAGR & Lumpsum Calculator Find the compound annual growth rate (CAGR) of an investment from its start and end value, or project what a one-time lumpsum will grow to at an expected rate. FD Calculator Calculate maturity amount and interest earned on Fixed Deposits with our free FD calculator. SIP Calculator Calculate returns on your Systematic Investment Plan (SIP). PPF Calculator Calculate the maturity amount and interest earned on your Public Provident Fund (PPF) account. RD Calculator Calculate maturity amount and interest earned on Recurring Deposits with our free RD calculator. GST Calculator Free GST calculator to add or remove GST. Calculate GST inclusive and exclusive prices with 5%, 12%, 18% and 28% GST rates.
Browse all tools in this category