XIRR Calculator
Enter each investment and withdrawal with its date, and get the annual return, even if the amounts and dates are uneven.
| Date | Type | Amount (₹) | Remove |
|---|---|---|---|
4 entries. Count your current holding as a "Received" entry dated today.
- Total invested
- ₹1.25 lakh
- Total received
- ₹1.60 lakh
- Gain or loss
- ₹35,000
- XIRR (per year)
- 8.29%
Dates are counted in days over a 365-day year, the same way as the XIRR function in spreadsheets.
For illustration only, not a recommendation or personal advice. Returns are not guaranteed, and the results depend entirely on the numbers you enter. Investments in securities markets, including stocks and mutual funds, are subject to market risks. Read all related documents carefully before investing.
How it’s calculated
XIRR finds the yearly rate at which all your dated cash flows add up to zero. Money you put in counts as negative; money you take out, and the value of what you still hold today, count as positive.
0 = Σ amountₖ ÷ (1 + r)^(daysₖ ÷ 365) daysₖ = days from the first cash flow to flow k r is found by repeated search (the same method as the XIRR function in spreadsheets)
Assumptions and limits
- Add the current value of your holding as a final 'received' entry dated today, if you still hold it.
- It needs at least one amount invested and one received. If every entry is the same kind, there is no return to compute.
- Dates are counted as actual days over a 365-day year. Costs and tax count only if you include them in the amounts.
Frequently asked questions
When should I use XIRR instead of CAGR?
When money went in or out on more than two dates: SIPs, top-ups, partial withdrawals, or a portfolio built over time. CAGR assumes one start and one end.
How do I enter a SIP?
Add one 'Invested' row for each instalment with its date, and one 'Received' row for the current value, dated today. Your fund app's statement lists the dates.
Why does it say it cannot compute a rate?
Usually because there is no 'Received' entry, no 'Invested' entry, or a date is missing or invalid.
Is XIRR the same as the return shown in my app?
Often it is the same method, but apps may treat dividends, charges or dates differently. Small differences are normal.
Does a very high XIRR mean much?
Over a short period, a small gain is scaled up to a yearly rate and can look huge. Read it together with the amount and the period.
Reviewed by Rachit Tripathi, Principal Officer, Blacklitt Technologies Private Limited (SEBI Registered Investment Adviser, INA000022428). Last reviewed .
For illustration only, not a recommendation or personal advice. Returns are not guaranteed, and the results depend entirely on the numbers you enter. Investments in securities markets, including stocks and mutual funds, are subject to market risks. Read all related documents carefully before investing.
