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

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

[@ninadiyer5242]

I'm an MBA in Finance and I wish someone taught me things so simply, I learnt more from this 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 :)

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

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

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

[@SuperAbhishek333]

Simplest video ever seen for finance,🙂 Thanks

[@siddhantshrivastava1690]

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

[@manishrakundla8205]

Sir - your explaining method and style is simply awesome !!!!!! Marvelous to say the least !!!!! 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!

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

[@MrABHINAV128]

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

[@jagdish0788]

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

[@SantoshNCR86]

The way you explain is fabulous.

[@pranavraj8317]

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

[@coolmafia_jennie]

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

[@shantirawat5973]

Kya khoob presentation hai dada.

[@prabhattiwari5089]

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

[@ETMONEY]

You're very welcome!

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

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

[@sachin_2601]

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

[@ramamoorthyganga]

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

[@ETMONEY]

Thank you

[@SrinivasanPMP]

Resourceful information - Thanks a lot for sharing

[@mohanlaltejwani6114]

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

[@Timeless_films]

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

[@ashutoshsingh9895]

Best and the most layman explanation regarding this topic

[@ETMONEY]

Thank you very much, Ashutosh Singh

[@piyushvalechha6534]

This is so clear and crisp explaination. Thank you !

[@ETMONEY]

Most welcome

[@anirudhsasank]

Your videos are awesome and very clear

[@poojagupta5448]

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

[@alokpatra4210]

Thank you Sir for your clear information

[@shubhamsrivastava1972]

Very crisp and to the point video :) Beautifully explained

[@ETMONEY]

Thanks a lot 😊

[@abhijeetkarmakar9623]

Absolute information. Thanks

[@vijaykumarsingh1190]

Plain and simple Great

[@karuneshchaturvedi6500]

Gajjab..kya samjhaye hai 👍

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

[@vicckypedia2581]

Sir Your way of explanation is really very good ❣️

[@jayprakashchandrawanshi8445]

One of the best video sirji, ❤❤

[@rajeeshravi1839]

Excellent explanation ... Well done ..

[@gunasmurali20]

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

[@ETMONEY]

Most welcome

[@62Nayan]

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

[@ETMONEY]

Most welcome

[@deewanraidumi5906]

Thank you 🙏, great post 🙏

[@mithilesh4014]

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

[@ETMONEY]

Thanks

[@Mansanone]

Excellent presentation

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

[@anishvarghese8169]

Very nicely presented. Thanks for clearing the doubts.

[@ETMONEY]

Most welcome

[@sudhakarramnawalmishra9531]

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

[@ETMONEY]

Thank you

[@barunchatterjee1223]

Clear message.

[@reverbedify]

Very simple explanation ❤

[@Sonawanes_]

Very well explained sir.

[@rrentertainment1539]

Best video in simple and short no bakwas Thanks bro

[@ETMONEY]

Thanks

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

[@bholugop6248]

Thanks for simplifying tricky concepts 🙏

[@ETMONEY]

Most welcome

[@sachinkamboj8551]

Best explaination

[@khajaazharuddin327]

Good information video

[@rajeshsuri7411]

Good information thank you

[@utpalbhadra8985]

Nice and simplified. Great !

[@ETMONEY]

Glad you liked it!

[@Szczecincrazyshit]

You sound like Vikrant Massey. Great video as always.

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

[@ravindrapillai5061]

Excellent

[@rajanidaftari2652]

Excellent!!!

[@manojmanna-jz2vy]

Looking nice sir

[@dheerajpandey07]

Well explained...easy to undersrand , great job

[@ETMONEY]

Glad it was helpful!

[@biswanathpradhan7549]

Very informative. Thanks.

[@ETMONEY]

Thanks for watching! Glad you liked it

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

[@ashishbaranwalechannel4843]

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

[@ETMONEY]

So nice of you. Thx

[@sanjiv144]

Mr. Vedant is smart

[@arinlittlebunny3516]

He looks so great 😎

[@meghasahu9109]

Ur voice, presention is just awesome

[@ETMONEY]

Thanks

[@mahesh7012]

Hello Sir and ET money, thanks for valuable information this is really helpful but can you tell us if there is any mutual fund present which havent yet completed 1 year from the day its available for investment?

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

[@shikhapriyadarshini2623]

well explained

[@jagdishparihar5900]

very nice sir

[@kinacute2010]

Super clear explanation wonderful

[@ETMONEY]

Glad it was helpful! Thanks!

[@deepaksengar4023]

Please review the two focus fund IIFL focus fund and mirae asset focus fund. Actually I want to stop axis multi cap fund and invest to any one which is best.

[@papususant]

Nice explanation. I have one question. A lumpsum amount invested in a fund and showing xirr more than 100. It is good or bad

[@AtulSharma-gk9xk]

Excellent and very informative

[@ETMONEY]

Thanks. Glad you liked it

[@niteshgoel3755]

Very helpful video Sir 🙏👏👏

[@ETMONEY]

Thanks and welcome Nitesh Goel.

[@ajayrahane2746]

Thanks.

[@davidjonson303]

Thanks

[@emdramanga1808]

Excellent Explanation.

[@ETMONEY]

Glad you liked it

[@vikramsinghmaran5089]

Great simplified video

[@ETMONEY]

Glad it was helpful!

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

[@anandvamsi5141]

Excellent video ET team

[@ETMONEY]

Thanks

[@Gandhilgvg]

Useful!

[@akshayyadav7539]

Clear Information...👏👏👏👌👌👌

[@ETMONEY]

Thank you so much 🙂

[@akshayyadav7539]

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

[@symbiosis4093]

Thank u sir...its great

[@ETMONEY]

Most welcome

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

[@arnabtechlover]

Great content thanks.

[@ETMONEY]

Thanks for watching!

[@the_anuragsrivastava]

Thanks sir

[@StudyAcademy1.0]

Thanks Broo 😊

[@khushisnaqvi6729]

Superb

[@ShubhamMishra-pf2kk]

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

[@ETMONEY]

Thanks!

[@SanidhyaSharma21]

very nicely explained

[@ETMONEY]

Thanks for liking

[@vivekkumarsinha3743]

Thank you very much sir

[@ETMONEY]

Most welcome

[@CTheMishra]

Quite informative.

[@ETMONEY]

Thanks