Difference between XIRR, CAGR and Absolute Returns in Hindi | How to Calculate XIRR

If you get confused listening about Mutual fund returns, then, you are not alone. It is a little difficult to understand mutual funds returns. Most people get intimidated listening to heavy words like CAGR, Absolute Reuters, XIRR, etc. But, this will not happen anymore.

In this video, we will tell you about different types of mutual funds returns and will discuss how they are different from each other, and...

There is one important thing. All mutual fund returns - whether it is CAGR or XIRR, tell about the historical aspects meaning older returns of the fund. Through them, you get to know about the performance of the fund during the chosen period. They are not predictions for future returns.

👉 CAGR - Compounded Annual Growth Rate.
CAGR is the return type that is most commonly used while discussing the performance of any fund.CAGR tells you about the compounded growth rate of your mutual fund investments.
CAGR can help you understand this. In order to calculate the Compounded Annual Growth Rate (CAGR) we need - Initial Investment Value (IV), Final Investment Value (FV), and period of investment (n).
The formula to calculate CAGR is:
CAGR = (Final Investment Value/Initial Investment Value)^1/n – 1
In this manner, you can check the CAGR of different funds over 3, 7, and 10 years of different time frames.
So, next time when you hear or know about the CAGR of a fund, then be understood that this is the average annual returns that a fund has generated over a time period.
First, CAGR does not give you a clear picture of volatility. Seeing this, you may feel that your investment has had or had a linear growth. This means that it has grown at a fixed rate every year, however, the reality is that the value of the investment may differ every year.
Second, though CAGR is the most used and popular way to calculate mutual fund returns, it has a limitation, that it doesn’t take into account the periodic investments. In the example given above, if the investment was made on different dates in the year, then, CAGR would not have been able to give a correct picture of the returns. It is ideal for calculating returns from a point-to-point basis. Therefore, CAGR is a correct method to calculate returns for a one-time lump sum investment, but not to calculate the SIP returns.
So, the question arises that if CAGR is not the correct method to measure the returns from SIP investment then what is?

👉 XIRR - Extended Internal Rate of Return
CAGR is fine for lump sum investments, but in places where there are different cash inflows and outflows, like SIPS, CAGR is not a good measure.
That is because every installment of a SIP is a new investment, therefore each amount is invested for different time durations. For example, in a 5-year SIP, your first installment will be invested for 5 years, the second installment for 4 years 11 months, and so on. For this reason, every amount gets compounded for different periods.
The Extended Internal Rate of Return (XIRR) takes this into account. In XIRR, CAGR is calculated for every installment and then the overall Compounded Annual Growth Rate is taken out after adding them all together.
You can calculate the XIRR in excel but we have made it much easier. You can see the SIP returns of every fund for any amount and duration on the scheme page of ETMONEY.
So, till now we have discussed the returns from mutual funds investments held for more than a year. Now, you must be getting the question: how to calculate the returns on investments for a year or less? The answer to it is Absolute returns.

👉 Absolute Returns
Absolute returns or Total returns means how much you have gained or lost in your investment.

Whenever you choose an equity fund, then do not judge the fund with its absolute or one-year returns, but evaluate it on the basis of CAGR or XIRR meaning more than a year (3/5/7/10 year’s returns).

👉 Bottom Line:

At the end of the day, we all invest in mutual funds to grow our money and earn better returns. So by knowing the intricacies related to mutual fund returns, you can pick the best funds for yourself. Once you’re invested, it also helps you gauge whether you got a good return for your money or not. You can use these returns to evaluate your mutual fund investments with other avenues like bank deposits, gold, and more.

👉 Follow us on:

[bapul]

This guy presentation skill is on next level. Great job by ETmoney.

[ninadiyer]

I'm an MBA in Finance and I wish someone taught me things so simply, I learnt more from this channel 🙏

[akashagrawal]

great job! Its seems like you guys are like a financial companion in my life :)

[piyushchavan]

I have been associated with etmoney and it's been amazing experience. And the video is on point, "sidhi baat, no bakwaas"👍👍.

[devenderkumar]

This guy is a top class presenter, loved the way he explained everything with so much clarity. Great job ETMONEY :)

[Rbmnpreact]

Loved the lucid yet on-point presentation by the gentleman!
This is a classic example of hitting the nail on its head.
Keep up the good work, ET Money !
Been associated recently; hope to stay connected for long.

[htrhtr]

Hello ET money, I am associated with ET money from last few days. It is very easy to invest and it is hassle free compared to other platforms. I really appreciate your work and the way everything is explained in every video. I have also made my wife’s portfolio for investments. Good job guys. good luck to you.

[Rishi-xlro]

I have recently invested in Axis blue chip fund, lumpsum, I have planned for 10 yrs, it is so easy to understand with this video..Thanks

[kaptansingh]

This is the best explanation about mutual fund return and also explain in a very simple way. 🎩 hats

[dpacsaml]

Simple but clear and lucid explanation. Everything about this video is really good. From the presenter to the music, graphics and examples used. Kudos to everyone involved!

[ashutoshsingh]

Best and the most layman explanation regarding this topic

[MayankVerma]

You are doing great work, ET money. The guys explains so clearly. The topics are so good. This definately builds trust among the audience.
Keep doing these YT videos!!! ❤️

[ramamoorthyganga]

Oh my god...top shot. Crystal clear explanation. with examples and formulas...thank you so much.

[babulalghosh]

Very very easy word, way, attitude to explain

[ETMONEY]

How to check XIRR, CAGR and Absolute returns on ETMONEY scheme pages?

2. Please go to the section where it says "Investment Returns Calculator". The default calculator is in SIP mode because that how most investors on our platform invest. So what you see is on an XIRR basis.
3. Within that box, you'll see a drop down arrow pointing down where it says Annualized. Tap on that and you'll see the "Absolute" option. That gives us the absolute returns.
4. The last element is CAGR. For this, within the same box, change from "Monthly SIP" to "Lumpsum". That will give the CAGR.

Hope this helps.

[alokpatra]

Thank you Sir for your clear information

[RejishankarM]

I believe this video is for the whole of India and if you can talk in English it would be very helpful for other non-hindi people as well.

Do consider doing videos in english so that it reaches more crowd

[vishalsinhrathod]

Sir
Very good information
I have been investing since 3 year through sip and I am always at puzzle to calculate cagr but now I am clear that to calculate sip return u have to calculate xirr not cagr

[prabhattiwari]

This is no doubt the best explanation video ever.
Thank you for sharing.☺️

[Szczecincrazyshit]

You sound like Vikrant Massey. Great video as always.