XIRR Calculator – True Annualised Return on Irregular Investments

Most real portfolios are messy. You invest a lump sum in January, add a bit after a bonus, withdraw some money later and the rest stays put. A simple percentage gain cannot capture that, because each rupee has been invested for a different length of time.

The XIRR calculator solves this. Enter each cash flow with its date, treating investments as negative and withdrawals or the current value as positive, and it returns a single annualised rate. Results are historical and do not forecast future returns.

Enter your details

Results

Calculating…

Formula used

  • Solve for x: Σ [ CFk ÷ (1 + x)^((dk − d0) ÷ 365) ] = 0
  • CFk = cash flow on date k (investments negative, receipts positive)
  • dk − d0 = days elapsed from the first cash flow
  • x = XIRR, the annualised rate, found by iteration
  • At least one negative and one positive cash flow are required

What XIRR measures

XIRR is the extended internal rate of return. It finds the single yearly rate at which the present value of all your investments equals the present value of everything you received or still hold. It gives more weight to money that has been invested longer, which is exactly how real returns work.

This is why fund statements from registrars and most portfolio apps report XIRR for SIPs and multi-purchase holdings.

How the calculation proceeds

There is no direct algebraic answer, so the calculator uses a numerical search.

  • It guesses a rate and discounts each cash flow back to the first date using the actual days elapsed divided by 365.
  • If the discounted total is positive, the guess is too low; if negative, too high.
  • It narrows the guess repeatedly until the total is practically zero.

The result is expressed as a yearly percentage.

Worked example with the default values

The sample entries are three investments and a final value:

DateCash flowDays from start
10 Jan 2022−₹50,0000
15 Jul 2022−₹30,000186
1 Mar 2023−₹20,000415
31 Dec 2025+₹1,35,0001,451

You put in ₹1,00,000 in total and the holding is worth ₹1,35,000, an absolute gain of 35%. The XIRR comes to about 8.69% a year, lower than a simple look at 35% suggests because most of the money was invested for several years.

Who should use it

XIRR is the right tool for anyone whose investments are not a single purchase. That covers SIP investors, people who top up occasionally, investors who redeem partially and those who want to compare a mutual fund portfolio with a fixed deposit or gold.

  • SIP and step-up SIP investors.
  • Investors with dividends, switches or partial withdrawals.
  • Advisers checking a client's portfolio performance.

Tips and common mistakes

  • Enter investments as negative numbers and the final value as a positive number on the valuation date.
  • Use the valuation date, not today's date, if you are reviewing a past statement.
  • Include every cash flow. A missing instalment will skew the result.
  • Do not read the XIRR of a very short period as a yearly expectation; a 20-day gain can annualise to a huge figure.
  • XIRR can give odd answers when the cash flows change sign more than once, so check the result for sense.

India-specific context

Indian investors will see XIRR in consolidated account statements from the registrars and in many broker and fund apps. When you reconcile your numbers, remember that exit load, stamp duty on purchases and capital gains tax affect what actually lands in your account.

If you want an after-tax XIRR, use the post-tax redemption proceeds as the final inflow. Tax rates and exemptions can change, so verify them as per rules at the time of writing from official sources.

Frequently Asked Questions

How is XIRR different from CAGR?

CAGR works for one starting value and one ending value. XIRR takes into account several investments and withdrawals made on different dates, so it measures the annualised return when money goes in or out at irregular intervals.

How do I enter SIP data into the calculator?

List every instalment on its actual date as a negative amount, one per line, and then add the current portfolio value as a positive amount dated on the valuation day. The calculator needs at least one negative and one positive flow.

Why is my XIRR different from the fund's returns?

Fund returns are measured on a one-time investment from a fixed date, while your XIRR reflects the dates and sizes of your own cash flows. Different timing of purchases naturally produces a different personal return.

Can XIRR be negative?

Yes. If the final value plus withdrawals is less than the money you put in, the XIRR is negative, showing an annualised loss. The calculator can solve for negative rates as long as the cash flows are valid.

Does XIRR use 365 days?

Yes. The standard definition counts the actual number of days between each cash flow and the first one, divided by 365, so leap years add a tiny difference. This is the same convention used by spreadsheet XIRR functions.

Disclaimer: This calculator provides estimates for planning and education. Actual figures depend on your lender, insurer or the latest rules. It is not investment, tax or legal advice.

Instant ResultsGet accurate results instantly
100% FreeNo registration required
Easy to UseSimple & user-friendly interface
Made for IndiaWith Indian financial rules & rates
Calculate Smart. Plan Better.