XIRR Calculator
XIRR gives the true annual return when money goes in and out on different dates, as with monthly SIPs, top-ups and partial withdrawals. Enter each dated cash flow, ending with the current value as a positive amount.
Results
XIRR (annual)
13.36%
- Total invested
- ₹1,50,000
- Total received
- ₹2,10,000
- Net gain
- ₹60,000
- Days between first and last flow
- 1,096
3 cash flows over 1,096 days give an XIRR of 13.36% a year.
Show the calculation steps
- Take the first date as day 0 and convert every date to years: (date − first date) ÷ 365.
- Find the rate r where the sum of amount ÷ (1 + r)^years equals zero (solved numerically). Result: r = 13.3605%.
- Money invested = ₹1,50,000.00; money received = ₹2,10,000.00; net gain = ₹60,000.00.
- XIRR assumes a 365-day year, like the spreadsheet function of the same name. Negative amounts are investments; positive amounts are returns or the final value.
Why XIRR instead of CAGR
CAGR only works for one investment and one final value. If you invested at several dates, some money has been invested longer than other money, and only a date-weighted measure like XIRR reflects that.
How to enter the data
Enter every instalment as a negative amount on its date, and the current market value (or the amount you received) as a positive amount on the valuation date. The order of lines does not matter.
Formula
Find r so that Σ amountᵢ ÷ (1 + r)^((dateᵢ − date₀) ÷ 365) = 0
Where:
- r
- = The annual return (XIRR)
- amountᵢ
- = Cash flow on date i (negative = invested, positive = received)
- date₀
- = The earliest date
Example calculation
Two investments and one final value
Inputs
Result
- XIRR (annual)
- 13.36%
- Total invested
- ₹1,50,000
- Total received
- ₹2,10,000
- Net gain
- ₹60,000
- Days between first and last flow
- 1,096
Step-by-step
- Take the first date as day 0 and convert every date to years: (date − first date) ÷ 365.
- Find the rate r where the sum of amount ÷ (1 + r)^years equals zero (solved numerically). Result: r = 13.3605%.
- Money invested = ₹1,50,000.00; money received = ₹2,10,000.00; net gain = ₹60,000.00.
Important notes
- Use the ISO date format YYYY-MM-DD. XIRR assumes a 365-day year, like the spreadsheet function of the same name.
Disclaimer: This calculator provides estimates for informational purposes and should not be considered financial advice. Actual figures from lenders, banks and investment products can differ because of fees, taxes, rounding rules and changing rates. Consult a qualified professional before making financial decisions.
Frequently asked questions
What is XIRR?
The extended internal rate of return: the annualised return implied by cash flows on specific dates.
Why does my mutual fund show a different XIRR?
Fund statements may use slightly different dates (such as NAV dates) or include exit loads and taxes.
Why does the calculator need a positive and a negative flow?
A return only exists if money goes both in and out. With only one sign there is no rate that balances them.
Related calculators
- SIP CalculatorEstimate the future value of a monthly SIP. See the amount invested, the estimated returns and how your investment could grow year by year.
- Step-Up SIP CalculatorEstimate the value of a SIP that rises by a fixed percentage every year, compared with a flat SIP.
- IRR CalculatorCalculate the internal rate of return (IRR) for a series of evenly spaced cash flows, per period and annualised.
- CAGR CalculatorFind the compound annual growth rate (CAGR) from a starting value, an ending value and the number of years.
Explore more in Investment Calculators.