Money Planning

XIRR Calculator India

Instant calculations with transparent assumptions. No login required.

XIRR Calculator
Find your true annualised return across irregular investments, top-ups and withdrawals on different dates.
Add every cash flow: each investment, top-up, or partial withdrawal on its actual date, plus the current value as your final positive entry.
๐Ÿ“Š XIRR Summary
XIRR
โ€”
Total Investedโ€”
Total Received / Current Valueโ€”
Absolute Gainโ€”
Number of Cash Flowsโ€”
Illustrative estimate โ€” not investment advice. Disclosure.
Invested vs Current Value

What is XIRR?

XIRR (Extended Internal Rate of Return) is the annualised return of an investment when money moves in and out on irregular dates โ€” multiple purchases, top-ups, partial withdrawals, or a SIP with gaps. Unlike CAGR, which needs just one start and one end value, XIRR correctly weights each cash flow by exactly how long it was invested for.

Why XIRR matters for mutual funds and SIPs

Most real portfolios are not a single lump sum โ€” they are built from a SIP, occasional lump-sum top-ups, and sometimes partial redemptions. A simple return calculation would be misleading here, since your first instalment and your last instalment have been invested for very different lengths of time. XIRR is the standard way fund houses and portfolio trackers report your actual personal return.

XIRR vs CAGR

If you invested a single amount once and want the annualised growth to a single ending value, use the CAGR Calculator โ€” it is simpler and sufficient. Use XIRR whenever there is more than one cash flow on more than one date.

XIRR calculation example

You invest โ‚น1,00,000 on 1 Jan 2022, add โ‚น50,000 on 1 Jan 2023, and the investment is worth โ‚น2,00,000 on 1 Jan 2025:

XIRR solves for the single annual rate that discounts all three cash flows (โˆ’1,00,000, โˆ’50,000, and +2,00,000, each on its own date) to zero net present value โ€” typically landing in the mid-teens for this example, and differing meaningfully from a naive average return calculation.

How to use this XIRR calculator

Add one row per cash flow: enter the date and amount, using a negative number for money you invested and a positive number for money you received (including your current holding value as of today). Add as many rows as you need, then the calculator solves for your XIRR instantly.

Frequently asked questions

Why do I need at least one negative and one positive cash flow?

XIRR solves for the rate that balances money going out (investments, shown as negative) against money coming in (redemptions or current value, shown as positive). Without at least one of each, there is nothing to solve for.

What date should I use for my current holdings?

Use today's date and enter your fund or portfolio's current market value as a positive cash flow โ€” this is standard practice and is exactly what mutual fund platforms do when they show your personal XIRR.

Is XIRR the same as the fund's published return?

No. A fund's published CAGR reflects the fund's performance for a lump-sum investor over that exact period. Your personal XIRR reflects your own actual cash flows and timing, which usually differs from the fund's headline number.

Simply Wealth Creation
Simply Wealth Creation
Wealth Building ยท Investing ยท Financial Freedom
SIP Calculator Report
* This report is for informational purposes only and does not constitute financial advice. Returns are estimated and not guaranteed. Past performance is not indicative of future results. Please consult a SEBI-registered financial advisor before investing.