Calculators · Investing

XIRR calculator

Use this XIRR calculator to find the annualised return on investments made on different dates, such as SIP instalments, lumpsums and partial withdrawals. Enter each cash flow with its date and today's value.

WorthOS Technologies Pvt. Ltd.  SEBI Registered Investment Adviser  ·  INA000022695  ·  These calculators are for educational purposes only and do not constitute investment advice. Assumptions can change; actual returns may vary.

Worth · Planning Tools

Seven calculators for the money questions people actually ask

Educational tools built on standard formulas. Every figure below is illustrative, computed from the inputs you enter — not a projection, recommendation or guarantee.

SIP Calculator

The future value of a monthly SIP over your chosen horizon, assuming a constant expected rate of return. Instalments are treated as invested at the start of each month.

Your inputs

Future value —
Total invested
—
Wealth gained
—
Absolute return
—
Instalments paid
—
Invested Wealth gained

Mandatory disclaimerThis calculator uses an assumed constant return rate for illustration. Actual mutual fund returns vary with market conditions and are not guaranteed. Past performance is not indicative of future results.

WorthOS Technologies Private Limited · SEBI Registered Investment Adviser · Registration No. INA000022695 (Non-Individual)

Investments in the securities market are subject to market risks. Read all the related documents carefully before investing. Registration granted by SEBI, enlistment with BSE, and certification from NISM in no way guarantee the performance of the intermediary or provide any assurance of returns to investors.

The method

How the XIRR calculator works

XIRR finds the single annual rate at which the present value of all your cash flows is zero. Money you invest is entered as a negative amount and money you receive, or today's value, as a positive amount.

Σ Cₖ / (1 + XIRR)^(dₖ / 365) = 0
  • Cₖ is each cash flow
  • dₖ is the number of days from the first cash flow

The rate is found numerically, so the calculator tells you if it cannot converge on a set of cash flows.

Worked example

1 Jan 2025: invested
−₹1,00,000
1 Jul 2025: invested
−₹1,00,000
1 Jan 2026: current value
+₹2,20,000
Absolute gain
₹20,000
XIRR
13.44% a year

The gain is 10% of the money invested, but the second ₹1,00,000 was invested for only half the year, so the annualised rate is higher.

The essentials

XIRR meaning, formula and how it compares with CAGR

What is XIRR?

XIRR stands for extended internal rate of return. It is the annualised return on a series of cash flows that happen on irregular dates. For mutual fund investors it is the standard way to measure SIP returns, because each instalment is invested on a different date and stays invested for a different length of time.

XIRR vs CAGR

CAGR suits a single investment with one start value and one end value. XIRR handles many cash flows, so it is the right measure for a SIP, a mix of lumpsums, or a portfolio with withdrawals. Using CAGR on a SIP understates or overstates the return, because it ignores when each rupee went in.

How to calculate XIRR in Excel

List each cash flow in one column, with investments as negative numbers and the current value as a positive number, and the matching dates in the next column. Then use =XIRR(values, dates). This calculator does the same calculation without a spreadsheet. To project a SIP before you invest, use the SIP calculator.

Common questions

XIRR Calculator: frequently asked questions

Still have questions? Contact us
What is XIRR in mutual funds?
XIRR is the annualised return on your mutual fund investments when money goes in or comes out on different dates, such as SIP instalments. It accounts for how long each amount was invested.
What is the difference between XIRR and CAGR?
CAGR suits a single investment with one start and one end value. XIRR handles many cash flows on different dates, which is why it is the standard measure for SIPs.
How is XIRR calculated?
XIRR is the rate at which the present value of all cash flows equals zero. It is solved numerically. In Excel the function is =XIRR(values, dates).
Why are investments entered as negative numbers?
XIRR follows cash-flow signs: money leaving your pocket is negative and money coming back to you is positive. You need at least one of each for the calculation to work.
Can XIRR be negative?
Yes. If your current value plus withdrawals is less than what you invested, the XIRR will be negative.
Reviewed by Tanish Sadh, Principal OfficerWorthOS Technologies Private Limited · SEBI RIA INA000022695 · Last reviewed
SEBI disclaimerInvestment in securities market are subject to market risks. Read all the related documents carefully before investing. Registration granted by SEBI, enlistment with BSE, and certification from NISM in no way guarantee the performance of the intermediary or provide any assurance of returns to investors.

For grievance redressal, contact tanish@worthostech.com or visit our Grievance Redressal page. If unresolved, escalate through SEBI SCORES or SMART ODR.