XIRR Calculator
Calculate returns on multiple investments made at different dates. Perfect for SIP tracking and mutual fund portfolio analysis.
| Date | Amount (₹) | Action |
|---|---|---|
Investment | ||
Investment | ||
Investment | ||
Withdrawal |
Ready to Calculate
Add your transactions and click "Calculate XIRR" to see your investment returns.
Irregular Timing
XIRR calculates returns for investments made at different dates and amounts, unlike regular IRR which assumes equal intervals.
Annualized Returns
It provides an annualized rate of return, making it easy to compare with other investment options and benchmarks.
Real Performance
XIRR considers the actual timing of cash flows, giving you the true performance of your investment strategy.
Perfect for:
💡 Example Scenario:
You invest ₹10,000 monthly in a mutual fund for 12 months, then withdraw ₹1,50,000 at the end. XIRR will calculate your exact annualized return considering the timing of each investment and the final withdrawal.
XIRR Formula
- • CFi = Cash flow at time i
- • r = XIRR (rate we're solving for)
- • ti = Time period (in years)
- • Σ = Sum of all cash flows
Calculation Method
Newton-Raphson Iteration
Uses iterative method to solve for the rate 'r' that makes NPV = 0
Time Calculation
Converts dates to time periods in years from the first transaction date
Convergence
Continues iteration until the result converges to a stable value
Step-by-Step Example
10,000/(1+r)^0 + 10,000/(1+r)^0.084 + 10,000/(1+r)^0.167 - 35,000/(1+r)^1 = 0