XIRR
XIRR tells you the annualised return of an investment when money goes in or comes out at different times, not just at regular monthly intervals.
Start the lessonIntroduction
The real return for irregular cash flows
When you invest money in a mutual fund, the dates of your contributions and withdrawals may not be perfectly regular. XIRR is a method that calculates your annualised return while taking these different dates into account.
It is especially useful for SIPs, extra top-ups, or investments where you contributed at different points in time. Instead of looking only at the final value, XIRR considers the actual cash-flow timeline.
Why it matters
Why XIRR is important
Realistic return
It reflects actual investing dates instead of assuming everything happened on a single date.
Best for SIPs
For monthly SIPs or one-off additional investments, XIRR gives a cleaner annual return estimate.
Portfolio comparison
You can compare different investments even when the cash flows were not the same each month.
Planning tool
It helps you understand whether your investment is really growing the way you expect.
₹ example
A quick XIRR example
Suppose you invest ₹1,50,000 upfront, add ₹15,000 every month for 5 years, and your portfolio is worth ₹14,50,000 at the end.
Investment timeline
₹1,50,000 + ₹15,000 monthly
Regular contributions are recorded on each cash-flow date and counted in the return calculation.
Estimated annualised result
11.52%
This is the implied annualised return, based on the pattern of cash flows and final value.
What this means
XIRR helps you understand the effective annual return on a portfolio where cash flows happened on different dates, not just a fixed-end sum.
Here, the result is about 11.52% annually, which is a useful way to compare your investment progress with benchmarks or other portfolios.
Common mistakes
What beginners often get wrong
- • Comparing XIRR across different timelines without checking the real dates of cash flows.
- • Ignoring that a portfolio value alone does not show the actual return if contributions were uneven.
- • Assuming any high final value automatically means a great return.
- • Forgetting that XIRR is a measure, not a guarantee of future returns.
Key points
What to remember
- XIRR measures annualised return when investments happen on different dates.
- It is useful for SIPs, top-ups, partial investments, and irregular cash flows.
- It gives a more realistic picture than simply looking at the final value.
- The dates of each cash flow matter almost as much as the amounts.
- XIRR is a helpful comparison tool, not a promise of future performance.
- It works best when you understand your full investment timeline.
This lesson is educational and not financial advice. XIRR is a calculation tool that helps evaluate investment performance, not a prediction of future gains.
Quiz