Mutual Funds

What is XIRR in Mutual Funds?

Created on 05 Jul 2021

Wraps up in 4 Min

Read by 6.7k people

Updated on 10 Aug 2022

For all good reasons, SIPs have been people’s favorite for years now. But, here’s an important thing most people don’t know - How do you calculate returns from SIPs? Well, let's discover.

You can build wealth little by little, SIP by SIP. There's no denying it. For most of us, we don't have big pockets to set aside a lump sum amount for investing, all at once. Add to it the benefits of cost averaging, and you'll know why SIPs are considered a great investment technique. But the easier these SIPs look, the more complicated is the calculation of returns in that case.

As there is a stark difference in the way lump-sum investments and SIPs are made, the metrics for comparing their returns are also quite different. 
Yes, CAGR (Compounded Annual Growth rate) is beneficial when calculating with a lump sum. But it may not be a sound way, especially when multiple cash flows spread over an unequal amount of time.

That sounds like a serious problem, isn’t it? But not without an answer. And that is XIRR.

XIRR (Extended Internal Rate of Return)

XIRR is a tool used to calculate the returns on periodic investment transactions made at different times. Let's look at a scenario to understand this better. Mr. P is a person who is investing in a fund ABC through SIP. His investment has several cash inflows and a significant amount of withdrawals happening side by side. This is causing serious confusion, and Mr. P cannot land at an accurate rate of return.

Under such a case, the calculation of returns becomes easier when you are using XIRR.  So whenever multiple transactions occur either via SIP, STP(Systematic Transfer Plan), or SWP (Systematic withdrawal plan), XIRR will be an efficient approach in calculating the returns. This helps you figure out the actual amount you will be getting at the end of the period… just peanuts or some real returns. Further, having an idea of the same becomes significant in:

  • Evaluating the performance of your fund

  • Arriving at the right decisions on your portfolio.

  • Rebalancing and re-evaluating your investment plans and strategy and finally

  • To plan for your future.

So should you undergo tedious data crunching and searching to arrive at the right answer? Not at all. Further, you will not need some serious app or software to make this calculation. You can calculate the same at your own comfort using an excel sheet.

But before we jump to the entire process of calculating the XIRR, let’s broadly look into the difference between CAGR and XIRR.


The below-mentioned pointers are some of the crucial differences that exist between both methods of return calculation:





CAGR helps an investor to gain insights into the growth of his corpus over time.

XIRR helps an investor to find out the average return of all the cash flows into his investment.


Mostly used for a lump sum.

It takes into account the multiple inflow and outflow occurring in an investment. In short, calculation of returns when SIP and SWP plans are opted becomes easier.  

Return calculation

It measures the annualized return for lump sum investment.

It measures the annualized return for periodic investments (regular as well as irregular).

How to calculate XIRR?

Now comes the part we all have been waiting for. Let’s imagine a scene where the following are the details of investment & the investor now wants to know his xirr to determine his future investment plans.

Details of investment

Investment start date

21 - 9 - 2018

Investment end date

21 – 6 – 2019

Redemption amount


SIPs of the investment

5000, 6000, 5000, 5000, 7000, 7000, 7000, 7000, 7000



 We will see how exactly he can arrive at his xirr using the excel sheet in 4 easy steps.

Step 1: Enter the date of investment in one column. For instance, we have taken dates from 21/9/2018 to 21/5/2019, as given in the above example.

Step 2: Now, in the next column, enter your activity, whether it is a withdrawal or investment. In case of an investment, add (-) before the amount. Whereas, in the case of inflow, we simply write the positive value as it is. In the case presented, a different amount and action have been performed. And the entries are done accordingly

Step 3: Then, finally, enter the redemption amount in the last column. Which is, in this case, 50000 (assumed amount).

Step 4: Here comes the crucial part. Use the below-mentioned formula to arrive at the XIRR:

=XIRR(B2:B11, A2:A11)*100

We have got the xirr for our assumed example to be approximately 25%

Thus, you can get the number you want in no time and with little effort. Further, we have assumed that the installment or withdrawal to be equally spread over periods. But the same may not be applicable in your case. In such a scenario, you can consider the time of each interval into your consideration as well.

And the result of the same looks like this:

 The Bottom Line

These little tricks and strategies might help you differentiate yourself from many others and help you fast-track your financial goals. It enables you to look deeper into your investment and interpret them better. Having offered the right methods and tools, it always drives your ability to decide logically and not be carried by sentiment. So, ensure you do that part of yours right and leave the rest aside.

Always have your spreadsheets ready and do the maths before investing.

Invest wisely!

comment on this article
share this article
Photo of Deb P Samaddar

An Article By -

Deb P Samaddar

265 Posts


482 Post Likes


If people could be named after idioms, Deb would be called "I'm all ears." His brain is a storehouse, ever overflowing with derelict information. So, while most things he talks about are as useless as occasion-less greeting cards, everything he writes has the potential of bagging you multiple diplomas!

Topics under this Article

Share your thoughts

We showed you ours, now you show us yours (opinions 😉)

no comments on this article yet

Why not start a conversation?

Looks like nobody has said anything yet. Would you take this as an opportunity to start a discussion or a chat fight may be.

Under Mutual Funds

"A few" articles ain't enough! Explore more under this category.

Share this post
share on facebook


share on twitter


share on whatsapp


share on linkedin


Or copy the link to this post -

copy url to this post