XIRR calculator
The right way to measure returns when money goes in and out on different dates.
Example result
- XIRR (annualised)
- 18.29%
- Total invested
- ₹40,000
- Total received / value
- ₹44,500
- Gain / loss
- ₹4,500
Cash flows
| Date | Amount |
|---|---|
| 2024-01-05 | -₹10,000 |
| 2024-04-05 | -₹10,000 |
| 2024-07-05 | -₹10,000 |
| 2024-10-05 | -₹10,000 |
| 2025-01-05 | ₹44,500 |
How this is calculated
XIRR is the annual rate r that makes the present value of all cash flows zero:
Σ amountk ÷ (1 + r)daysk ÷ 365 = 0
FID solves it with Newton's method and falls back to bisection when needed. Days are counted from the first cash flow. Results match spreadsheet XIRR functions.
Questions
Why not use CAGR for SIPs?
CAGR assumes all money went in on one date. In a SIP, later instalments have been invested for less time, so CAGR on the total understates the return. XIRR accounts for each date.
How do I enter the current value?
Add a final line with today's date and the current value as a positive amount.
Estimates for educational purposes only. Not financial, tax or investment advice.