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.
👉 To invest in Direct Plans of top Mutual Funds for free, download the ETMONEY app: etmoney.onelink.me/unJQ/5ca1ae3b
👉 Read article: www.etmoney.com/learn/mutual-...
👉 Follow us on:
► Facebook: / etmoney
► Twitter: / etmoney
► Instagram: / etmoney_official
► Linkedin: / et_money

[@ETMONEY]

Portfolio returns shown on the ETMONEY app are calculated on an XIRR basis 👍 .. and hence reflects the accurate returns on your mutual fund portfolio. Here's a blog we wrote on XIRR vs CAGR vs Absolute Returns : www.etmoney.com/blog/understanding-your-mutual-fund-returns-a-peek-into-cagr-xirr-and-absolute-returns/

[@wolverine008]

Very true

[@anirudhsasank]

Suppose if I invest in June 2021, then till June 2022 it is an year right. Or is it only till that financial year completion? How will my returns be calculated?

[@NaveenPrabuSelvaraj]

ETMoney, do you have this video in english?

[@ETMONEY]

@@NaveenPrabuSelvaraj Not yet

[@nishimahanty5132]

Like

[@ninadiyer5242]

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

[@26411bapul]

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

[@akashagrawal8948]

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

[@ETMONEY]

Thanks! 😃 .. do invite your friends and colleagues to subscribe to the ETMONEY channel.

[@piyushchavan3608]

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

[@ETMONEY]

Thank you Piyush Chavan. Clear hai :)

[@devenderkumar2902]

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

[@ETMONEY]

Glad you liked it!

[@rahulbhatt119]

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.

[@ETMONEY]

Thanks for the appreciation, Rahul!
Looking forward to helping you invest intelligently.

[@kaptansingh8646]

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

[@ETMONEY]

Thanks a ton Kaptan Singh 👍. Do subscribe and share this video with your friends and family so that they too can take advantage of this learning

[@ashutoshsingh9895]

Best and the most layman explanation regarding this topic

[@ETMONEY]

Thank you very much, Ashutosh Singh

[@SuperAbhishek333]

Simplest video ever seen for finance,🙂 Thanks

[@MrABHINAV128]

Respected Sir!
Your way of explanation is superb.
Thank You

[@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!

[@ETMONEY]

Wow, thanks!

[@manishrakundla8205]

Sir - your explaining method and style is simply awesome !!!!!!
Marvelous to say the least !!!!!
Thank you

[@pranavraj8317]

Sir, Who so ever you are. you look great and your voice reaches our heart. god bless you!

[@jeononjo_blinke]

So simply yet so effectively explained the terms.your videos are so simple and impact ful.the language, the presentation so great to watch.thanks again.

[@ishobhitkumar]

Gazab samjhaya ek baar me pura samjh aa gya bhai

[@jagdish0788]

बहुत ही अच्छा समझाया गया 👍👍

[@htrhtr8528]

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.

[@ETMONEY]

Thank you HTR. Sincerely appreciate the warm words. We'll certainly up the ante over the coming weeks and months. Glad to have you onboard

[@shantirawat5973]

Kya khoob presentation hai dada.

[@SantoshNCR86]

The way you explain is fabulous.

[@vishalsinhrathod2391]

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

[@siddhantshrivastava1690]

Love this guy and ET money's videos. Truly helpful.

[@karuneshchaturvedi6500]

Gajjab..kya samjhaye hai 👍

[@ramamoorthyganga]

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

[@ETMONEY]

Thank you

[@poojagupta5448]

great video, content, presentation, simple explanations. Great job ET Money!!

[@MrRejishankar]

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

[@prabhattiwari5089]

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

[@ETMONEY]

You're very welcome!

[@dheerajpandey07]

Well explained...easy to undersrand , great job

[@ETMONEY]

Glad it was helpful!

[@sachin_2601]

Very well explained and presented. Good job👌🙋🏻‍♂️

[@gunasmurali20]

Wow... Pakkka.... pakka clear.... thank you ET....

[@ETMONEY]

Most welcome

[@jayprakashchandrawanshi8445]

One of the best video sirji, ❤❤

[@mohanlaltejwani6114]

Very useful video. Informative. Thanks for sharing 🙏👍😊

[@SrinivasanPMP]

Resourceful information - Thanks a lot for sharing

[@piyushvalechha6534]

This is so clear and crisp explaination. Thank you !

[@ETMONEY]

Most welcome

[@vijaykumarsingh1190]

Plain and simple
Great

[@MayankVerma19]

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!!! ❤️

[@ETMONEY]

Much appreciated Mayank Verma 👍 Glad we are able to add value to everyone's financial journey. We have a lot more lined up next month. Do invite your friends and colleagues to subscribe to the ETMONEY channel.

[@Timeless_films]

Sir You are great. I watch only your video at your channel

[@alokpatra4210]

Thank you Sir for your clear information

[@vicckypedia2581]

Sir Your way of explanation is really very good ❣️

[@Szczecincrazyshit]

You sound like Vikrant Massey. Great video as always.

[@shubhamsrivastava1972]

Very crisp and to the point video :) Beautifully explained

[@ETMONEY]

Thanks a lot 😊

[@anirudhsasank]

Your videos are awesome and very clear

[@sanjiv144]

Mr. Vedant is smart

[@Rishi-xl3ro]

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

[@ETMONEY]

Glad it was helpful! Thank you and do invite your friends and family to subscribe to our channel

[@abhijeetkarmakar9623]

Absolute information. Thanks

[@meghasahu9109]

Ur voice, presention is just awesome

[@ETMONEY]

Thanks

[@rrentertainment1539]

Best video in simple and short no bakwas
Thanks bro

[@ETMONEY]

Thanks

[@Mansanone]

Excellent presentation

[@sudhakarramnawalmishra9531]

Namaste Ji
Information are very clear and helpfull.
I love the way you explain.
Thank you.

[@ETMONEY]

Thank you

[@mithilesh4014]

Very Nice video. Nothing more to say , many gentlemen already posted good reviews
Thanks

[@ETMONEY]

Thanks

[@rajeeshravi1839]

Excellent explanation ... Well done ..

[@deewanraidumi5906]

Thank you 🙏, great post 🙏

[@anishvarghese8169]

Very nicely presented. Thanks for clearing the doubts.

[@ETMONEY]

Most welcome

[@akshayyadav7539]

Clear Information...👏👏👏👌👌👌

[@ETMONEY]

Thank you so much 🙂

[@akshayyadav7539]

@@ETMONEY You are Welcome...🙂🙂🙂

[@wolverine008]

I subscribed this and will recommend others also . very excellent examples he gave and explained very nice ...thanks

[@ETMONEY]

Thanks for the sub! Much appreciated

[@bholugop6248]

Thanks for simplifying tricky concepts 🙏

[@ETMONEY]

Most welcome

[@62Nayan]

Thank you. very nice explanation, was searching for.Thank you.

[@ETMONEY]

Most welcome

[@anandvamsi5141]

Excellent video ET team

[@ETMONEY]

Thanks

[@sachinkamboj8551]

Best explaination

[@vivekjoshi937]

Thanks for providing the valuable info. Good job 🙏

[@ETMONEY]

Glad it was helpful!

[@ramansharma8585]

Beautiful,well explained, simple,easy, subscribed, ringed the bell, ! :)

[@ETMONEY]

Awesome, thank you!

[@barunchatterjee1223]

Clear message.

[@utpalbhadra8985]

Nice and simplified. Great !

[@ETMONEY]

Glad you liked it!

[@ashishbaranwalechannel4843]

Explanation is too good n knowledge alb video, great sr👍

[@ETMONEY]

So nice of you. Thx

[@rajeshsuri7411]

Good information thank you

[@rajanidaftari2652]

Excellent!!!

[@khajaazharuddin327]

Good information video

[@janardhannair7732]

Thanks for the information Sirji.

[@ETMONEY]

Always welcome Janardhan Nair. Glad your liked it!

[@rajatsanyal6308]

I really enjoy your's and Shankar Nath's presentation. Nicely explained! Thanks.
Can you share a video on how to use the ETmoney app to evaluate a fund?

[@kinacute2010]

Super clear explanation wonderful

[@ETMONEY]

Glad it was helpful! Thanks!

[@sanukurien2752]

The quality of ETMoney videos are the best ones around. Keep it up gals and guys, good on you!

[@ETMONEY]

Thank you! Will do!

[@manojmanna-jz2vy]

Looking nice sir

[@biswanathpradhan7549]

Very informative. Thanks.

[@ETMONEY]

Thanks for watching! Glad you liked it

[@AtulSharma-gk9xk]

Excellent and very informative

[@ETMONEY]

Thanks. Glad you liked it

[@Dhananjuly]

What a coincidence. Before watching this video, I was searching for CAGR etc n ETF Vs mutual funds etc.

[@ETMONEY]

Generally, we never time the market. Atleast we got this right :) .. thanks!

[@ravindrapillai5061]

Excellent

[@shikhapriyadarshini2623]

well explained

[@emdramanga1808]

Excellent Explanation.

[@ETMONEY]

Glad you liked it

[@niteshgoel3755]

Very helpful video Sir 🙏👏👏

[@ETMONEY]

Thanks and welcome Nitesh Goel.

[@StudyAcademy1.0]

Thanks Broo 😊

[@vikramsinghmaran5089]

Great simplified video

[@ETMONEY]

Glad it was helpful!

[@symbiosis4093]

Thank u sir...its great

[@ETMONEY]

Most welcome

[@CTheMishra]

Quite informative.

[@ETMONEY]

Thanks

[@Gandhilgvg]

Useful!

[@jagdishparihar5900]

very nice sir

[@arinlittlebunny3516]

He looks so great 😎

[@sagarhas]

Great job 👏

[@ETMONEY]

Thank you! 😃

[@eknayisoch850]

Great job sir👏👏👍👍

[@ETMONEY]

So nice of you Thank you

[@arnabtechlover]

Great content thanks.

[@ETMONEY]

Thanks for watching!

[@healthwealthandhappiness51]

Great video Sir 👍👍👍👍👍👍👍❤️❤️❤️❤️❤️❤️❤️❤️ love you sir thanks u

[@ETMONEY]

So nice of you. Thank you very much. Please dont forget to subscribe to the ETMONEY channel and share this video with your friends.

[@the_anuragsrivastava]

Thanks sir

[@SanidhyaSharma21]

very nicely explained

[@ETMONEY]

Thanks for liking

[@vivekkumarsinha3743]

Thank you very much sir

[@ETMONEY]

Most welcome

[@khushisnaqvi6729]

Superb

[@xplorewithmosh1295]

Beautiful

[@ShubhamMishra-pf2kk]

you explained it really well... Mind-blowing🙏👍.
Can you please make more related videos.😌
Thanks in advance

[@ETMONEY]

Thanks!

[@soumennath3447]

Very nice! Plz create more

[@ETMONEY]

Thanks!

[@callbikram]

Good explanation

[@ETMONEY]

Thanks for liking

[@ajayrahane2746]

Thanks.

[@amolmore5466]

Superb !!!

[@ETMONEY]

Thanks