India version. Amounts in rupees with lakh grouping and the XIRR measure Indian fund statements (CAS) report, worked through SIP instalments and part-redemptions. US version

XIRR and Portfolio Return Calculator

Find the XIRR of your mutual fund SIP or share portfolio in rupees from dated instalments and current value, alongside absolute return and time-weighted return.

The interactive tool loads here when JavaScript runs.

About this tool

What is the Time-Weighted Return Calculator?

A mutual fund statement in India usually shows two numbers for an SIP: the absolute return and the XIRR. Absolute return ignores time; XIRR is the yearly rate that matches each dated instalment to today's value. A 36-month SIP of ₹10,000 from November 2023 worth ₹4,30,000 on 6 November 2026 has an absolute return of 19.44% but an XIRR of 11.84%, because most of the money was invested for much less than three years.

Enter each instalment as a buy with its date and amount, redemptions or SWP payouts as sells, and the current value from your statement. The tool gives total invested, net investment, absolute return and XIRR. Add the number of units to each transaction and it also gives the time-weighted return, which is how fund factsheets report scheme performance.

Your transactions are saved only in this browser. Nothing is sent anywhere.

  • True time-weighted return chained from per-share prices
  • Money-weighted return (XIRR) on actual days / 365
  • Buys and sells with dates, shares and prices
  • Four sample portfolios to explore
  • Text report download, copy and share
  • Data saved locally in your browser, nothing uploaded
Read the guide: Time-Weighted vs Money-Weighted Return (TWR vs XIRR)

Updated

How to use the Time-Weighted Return Calculator

  1. Clear the sample data, then add each SIP instalment or lump sum as a Buy with its date and amount in rupees.
  2. Add redemptions, switches out or SWP withdrawals as Sell transactions on their dates.
  3. Enter the current value from your CAS or the fund house app.
  4. Compare XIRR with the scheme's own return: a large gap shows how much the timing of your instalments helped or hurt.

Worked examples

36-month SIP of ₹10,000

Input

₹10,000 on the 5th of each month from November 2023 to October 2026; value ₹4,30,000 on 6 November 2026

Output

Invested ₹3,60,000; gain ₹70,000; absolute return 19.44%; XIRR 11.84%

Dividing the gain by the total invested overstates the yearly return of an SIP, since the average instalment was invested for about 18 months. XIRR accounts for each date.

Same SIP after a weak market

Input

Same instalments; value ₹3,90,000 on 6 November 2026

Output

Gain ₹30,000; absolute return 8.33%; XIRR 5.25%

A fall of ₹40,000 in value halves the XIRR. Below the rate of a bank FD, it is a prompt to check the fund against its benchmark rather than to stop the SIP on one reading.

Lump sum with a later top-up

Input

₹5,00,000 on 15 March 2022 and ₹2,00,000 on 10 June 2024; value ₹9,60,000 on 6 November 2026

Output

Gain ₹2,60,000; absolute return 37.14%; XIRR 8.12%

A 37% gain sounds large, but spread over four and a half years on most of the money it is about 8% a year.

Background and insight

Time-weighted return (TWR) splits the history at each deposit or withdrawal, measures the return of each sub-period, and links them geometrically: (1 + r1)(1 + r2)...(1 + rn) − 1. Averaging the sub-period returns would be wrong: +50% followed by −50% is a 25% loss, not zero. Because each sub-period is measured on its own, the size and timing of your deposits drop out, which is why the GIPS standards use TWR as the default measure for comparing fund managers.

For a single holding the price per share is the valuation, so each sub-period return is simply the price at the next transaction divided by the price at this one, minus one. The tool takes the price from Price per Share or derives it as amount / shares, and the final price is today's value divided by the shares you still hold.

Money-weighted return (MWR) is the internal rate of return of your actual cash flows: the annual rate at which buys, sells and today's value have a net present value of zero, using actual days / 365 like spreadsheet XIRR. It reflects your timing. If MWR is well below TWR, your deposits arrived before poor periods; if it is above, you added money before good ones.

Common use cases

  • Judging a fund, not your timing

    Use TWR to compare a fund with its benchmark when your own deposits were irregular.

  • Measuring your own results

    Use XIRR to see the annual return your actual money earned, including the effect of when you bought and sold.

  • Checking a SIP

    Log monthly instalments with units allotted to see both the fund's return and your rupee-cost result.

  • Reviewing a broker statement

    Re-enter trades from a statement to verify the XIRR the platform reports.

Tips and limitations

  • XIRR changes with the valuation date, so note the date you checked it, as the examples above do.
  • Reinvested dividends (IDCW reinvestment) are new units, not new money; leave them out of buys or the XIRR will understate the return.
  • Use growth options or include payouts as sells; otherwise income paid out is missing from the return.
  • Past returns are for your own review and do not predict future returns.

Sources and further reading

  1. Investor awareness: mutual funds, Securities and Exchange Board of India
  2. Mutual fund investor education, Association of Mutual Funds in India
  3. Global Investment Performance Standards, CFA Institute. Time-weighted and money-weighted return definitions.

Frequently asked questions

What is XIRR in mutual funds?

XIRR is the annual rate at which all your dated investments and withdrawals, plus today's value, net to zero. It is the right measure for SIPs because each instalment is invested for a different length of time.

Why is my SIP XIRR lower than the absolute return?

Absolute return is total gain over total invested, with no time in it, so it is a cumulative figure rather than a yearly one. XIRR turns the same gain into a rate per year, weighted by how long each instalment was invested. After two or three years of SIP the absolute percentage is usually larger than the XIRR; in the first few months it can be smaller.

What is the difference between XIRR and CAGR?

CAGR fits one investment made at one date. XIRR handles many investments and withdrawals on different dates. For a single lump sum with no other flows, the two are the same.

Is XIRR in my CAS the same as this calculator?

It should be close if you enter the same transaction dates, amounts and current value. Differences come from stamp duty and other deductions on purchase amounts, and from the exact NAV date used for the current value.

Is a good XIRR enough to judge a fund?

No. Compare the fund's own time-weighted return with its benchmark index and category over the same period. XIRR mixes the fund's performance with your timing.

Is there an in-depth guide to the Time-Weighted Return Calculator?

Yes. “Time-Weighted vs Money-Weighted Return (TWR vs XIRR)” covers the background, how it works, common pitfalls and worked examples. Read the full guide.