IRR: Best way to calculate SIP returns | IRR vs XIRR vs CAGR | Money-Minded Mandeep | LLA

[@LabourLawAdvisor]

💸Start Investing, DEMAT Zerodha: link.lla.in/zerodha SIP Calculator: labourlawadvisor.in/calculators/sip-calculator/ Hax to Save Tax: www.taxplanningforsalariedemployees.com

[@MoumitaDas-fz3gp]

Which app is this??

[@pratikshabhatt9426]

Where can I access to app,.

[@abhisheknaik2685]

I had opened demat account before watching your videos, can i still join that group ?

[@WorldgeopoliticsbyPrashant]

Sir Can you plz provide this Excel with Formula? Because it's not accepting.

[@bigbullwar3939]

Nice video mandeep bro. Enjoyed it.

[@namaskarprasad]

Wah Wah Mandeep Bhai Zor Shor se janta jagruk karrahe ho!! Intresting🔥👌

[@AjayKumar-dj7lp]

👍👍

[@mmdhs300]

Arey ap bhi yhaan comment krre o

[@dilipmehtabilu]

Are aap bhi kafi jagruk krte ho logo ko🙏🙏🙏

[@shubhamnimje419]

everywhere i go i see his face (#convey fan)

[@shubhamnimje419]

@@AjayKumar-dj7lp ungli kisko dikha rha hai be

[@shubhambangad1011]

XIRR and IRR both are annualized, this is the pro tip from this video. I never came through this tip. And yes, thanks for explaining with best examples.

[@iamyash9057]

Your channel is growing at 100% CAGR

[@LabourLawAdvisor]

Haha 😀

[@omkarmhaske8120]

@@LabourLawAdvisor sir plz make a video on how to become financial free starting investing or trading from 18 and also make video on how to gain capital for trading and also how to use credit card to trade without money

[@ankith1316]

😂😂😂

[@sanket5856]

XIRR kitna

[@kumarrinkuvlogs9016]

Rt77.,

[@Ethicalhackerabhi]

The most genuine, humble, and informative channel on youtube. You guys are certainly going to go a long way. Wish you a lot of success keep going guys!

[@tejaspawar5182]

Kal hi manga aur aaj mil bhi gya❤️ You guys are giving the most valuable education. Thanks for such a rare but most important education. Great fan of yours

[@MandhanAcademy]

well done Maths !!! Respect for u bhai ... u can use NAV column for exact returns

[@ajithpr8357]

One of the clear cut explanations for XIRR I have ever watched👌👌👌

[@nagarathnanagaraju1909]

I had no clue what XIRR was. I thought it was something that only accounting/ commerce background people can understand. Your explanation was so precise and simple, now this is a parameter I will surely watch out for in future. Thank you.

[@sarathanilkumar1339]

No use of seeing XIRR… as your actual return wt u realism is absolutely return

[@cashcraftinsider]

If Mandeep ever started teaching in school or college's, I'm 100% sure that students will gonna win every event they participate and Score full marks in his papers.. Well done lad 🙌 Hats off to the content you provide. You're amongst that very few gems left on KZbin ❤❤❤

[@LabourLawAdvisor]

Thanks brother I was a home tuition teacher for many people (including friends) before becoming a KZbinr. All of them scored great 😀 Didn't pursue a career there, though

[@cashcraftinsider]

@@LabourLawAdvisor I wish, I could have been one of your students to pursue career in your path. One shouldn't pursue Master's degree, they should master the skills like how you did.

[@Common.Gyaani]

Exactly.. There should be finance education in school as well

[@acharyachaanakya]

@@LabourLawAdvisor ig everyone saw your podcast. So everyone knows it

[@saikatmukherjee609]

Better practical explanation than many Ph.D holder commerce teacher. I am a commerce student and did cap. Budgeting in 3rd year Financial management without knowing its practical use. You are great. Thanks a lot.

[@anittas224]

Only professionals like CA or CMA can teach hard core accounting not any Phd holder

[@thuylamson-z7t]

The market trend can turn around very quickly. In fact, the indexes often switch from a bear market to a bull market when the news is at its worst and the mood of investors is at its lowest point. I read an article of people that grossed profits up to $150k during this crash, what are the best stocks to buy now or put on a watchlist?

[@myrle-v4g]

In particular, amid inflation, investors should exercise caution when it comes to their exposure and new purchases. It is only feasible to get such high yields during a recession with the guidance of a qualified specialist or reliable counsel.

[@shizue-w7n]

True, initially I wasn't quite impressed with my gains, opposed to my previous performances, I was doing so badly, figured I needed to diverssify into better assets, I touched base with a portfolio-advisor and that same year, I pulled a net gain of 550k...that's like 7times more than I average on my own.

[@jeanlaudato]

This aligns perfectly with my desire to organize my finances prior to retirement. Could you provide me with access to your advisor?

[@shizue-w7n]

“Angela Lynn Schilling’’ is the licensed fiduciary I use. Just research the name. You’d find necessary details to work with a correspondence to set up an appointment.

[@jeanlaudato]

She appears to be well-educated and well-read. I ran an online search on her name and came across her website; thank you for sharing.

[@abhishekmittal5440]

awesome video. .i claculated xirr of my LIC, its 7.5 % over 25 years.....not bad, beating inflation and more than the FDs 👍👍

[@divyanshjaju7939]

And giving life insurance 😊

[@rajeshmenezes6792]

Yehi MFs mey 12/15% sey grow hote karlo calculation and see if u would have become a crorepati by now😂

[@YashSharma0605]

Honestly had no idea about this, saw xirr a couple of days ago against one of my Mf investment and was wondering what it was. Now everything is clear, thanks for the video great work 👌👌👌

[@mathurshishir]

I have seen few videos explaining XIRR. But honestly, this is the best. The way you have highlighted minute details about is commendable.

[@LabourLawAdvisor]

Glad it helped!

[@siddharthison1982198]

You guys are real life savers for middle class, Thank you and God bless

[@manishrakundla8205]

Very true

[@krunalshukla7314]

I already knew this as I also follow Rachana mam...... But thought let me check your feed too.... Man it was explained nicely.... Great job bro

[@dharavionly2411]

Who is rachna mam

[@gopalsarda2158]

As expected!! XIRR ka aa hi gaya video!! Bahoot khoob! Very well explained sir ji 😇

[@jff555]

Groww app show karta he

[@ivy0912]

Thank you mandeep bhai!! Itna easy se kabhi nahi samajh aaya ye concept!! Even more with the examples which are really really helpful! Bhagwan tumhara bhala kare!

[@RishabhAwasthi007]

Thanks Mandeep....I'm overwhelmed by the thought that my feedback was heard and you made video on this so quick. More power and love to you. ♥️

[@rishav2ky]

You guys are really doing very good job... Nahi to ye banks, RMs and insurance agents to saari investment 15-20-30 saal ke liye block karwa de wo bhi 5-6% returns ke liye... 👍

[@Trumpbhai18]

Thank you for explaining this nicely, I always wondered how the xirr was calculated.

[@LabourLawAdvisor]

Glad it was helpful!

[@drprashantdash]

Super awesome explanation. I have watched this video 4 times in the last 2 years and keep coming back to it for help.

[@njaypee1]

One of the best videos I have come across, especially the part wherein you explained using google sheets / excel. Thank you !

[@AbhinavKumarbagiboys]

mandeep although i am not a finance student , but at this age i am able to understand concepts , you are a great teacher...

[@AnamEjaz]

Earlier I used to calculate absolute returns now I know I need to calculate XIRR. Kuvera pe mene XIRR hi laga rakha hai. And Even I do irregular investments Maza agya video dkh k. 🔥

[@BrijMohanKaushik-k8v]

Ek baat batau I am 35, and these gusy are giving knowledge to audience worths rs crores, the best financial knowledge channel ever, no faltu bakwas, no topic diversion

[@InvestBeast]

best video to understand how calculate SIP. great brother

[@kayamali7897]

Truly speaking these Valuable content deserves alot of appreciation ❤❤

[@shuklabhanuprakash]

Bohot sahi Mandeep bhai …literally the way you make us understand the very critical concept in such a layman’s way …majaa aagyee

[@vaibhavsouveer]

Thank you so much. This is exactly what I was looking for. A mathematical way to evaluate a life insurance. But can you also tell what is an ideal IRR for such a plan, a benchmark number that we should compare it with?

[@sakkharb]

This is gem of an explanation. I still recommend this video to friends who are starting their investment journey! Thank you MMM and LLA 🙏

[@sumedhdeshpande5243]

I can't even express how amazing the content stream is, while I was watching I was continuously thinking of you should've also been featured in the article highlighting the finance educators on KZbin platform. Truly your content is amazing. Huge fan. More power to you 🌻

[@Eivyk]

Bhai 25 saal mein itti knowledge aur paune 2 million subscriber!! Gazab hai sir

[@ankitparmar9641]

Bhai time knowledge me invest kro😅 google h. Jisko self learning krni h wo kahi se bi sikh lega

[@rajanchauhan8140]

Thanks a lot Brother for this concepts, they look simple but in actually they are not 😇 But after yours explanation they became the easiest thing in the world🙏👍

[@mohamedimzath9443]

This is what I searched long time in Google but today I got it. Thanks

[@lurlwdvis1587]

Appreciate your feed back and thanks for watching for more guidance W~H~A~T~S~A~P~P 🔥 + 44 (7868) 6= 9= 2= 4= 6= 3

[@sayandeepjana2987]

Thanks Mandeep for keeping the request.. Please keep it up and bring something like this.👍👍👍👍👍 Great effort bro....

[@sangramdange]

Great this was so important for investors to understand XIRR. Never came across any channel which covered this...only some financial blogs with not clear explanation.

[@parthadebnath701]

Everyone wants in mutual fund "21 din me paisa double" 🙂

[@hemantwadhwa91]

Awesome bhai, apki wajah se pta lga, sirf paisa dpuble hona jaroori nahin hai, kitne time mein ho rha hai, woh bhi jaroori hai

[@Mayur7Garg]

IRR gives the rate of return for periodic intervals. It doesn't matter what they are (days, months, years, decades) and hence it doesn't require dates. The result you get is the rate of return over the same period that your values were invested apart. That is, if the values you provided were periodic per month, the rate of return is also month over month. Since in the video, the dates he provided were a year apart each, the IRR given (5%) is year over year. The actual dates don't matter.

[@SuperNimbus]

Yes, i thought so as well.. However, why does XIRR value not match the IRR even when the cash flows are at periodic intervals.. ?

[@Ranjithbhat444]

Thanks to LLA and team; Now especially the youth is getting financially educated. God bless.

[@babadook4107]

8% is the IRR when you calculate the IRR of 1000 investment for 6 months. Amazing video man. Thank you so much brother learnt a lot.

[@bhavinparmar608]

No body, like no body explains it better than you 👏

[@deepakputge2391]

Thank you for this video. You saved me from purchasing an endowment LIC plan which had just 5% XIRR. I was excited looking at its Absolute interest. I have been investing in mutual fund and stocks never bothered to check about XIRR and IRR. It helped lot 👍

[@tarands]

Mera ch**ia kat chuka tha pehle ...thanks to lockdown and mandeep i got time to view his videos and be jagruk..thanks mandeep ji

[@sumitagarwal7584]

I think 5% return is ok as FD returns are almost similar. For higher return, ulips are the only option in insurance plans. But that cost you risk

[@backpacker4342]

5% XIRR + Life Insurance + Tax Benefit .

[@religionofpeace782]

​@@backpacker4342Chal bhaag faltu agent 😂. Logo ko hutiya banake rakhe ho 50 saal se.

[@kalyug420]

Ur return?

[@99vihar]

What a detailed explanation!. Thank you for the video. Great part is this is without any sponsorship or promotion and so simply explained in Hindi, I can share with my family members and educate them using your videos 🙏

[@ganeshshetty625]

This video was very well made bro. I have bookmarked it! I was back testing my own strategies but was making mistakes in the calculation of returns. This video should help!

[@sunnybarnwal8092]

Ur channel deserves much more....subscribers. Grand salute sir.

[@Yashwanth_KN]

Thanks! I already know everything you explained about XIRR but didn't know about IRR because @CARachanaRanade said that both are the same, just MS Excell used different names for them. I saw so many videos about the share market and mutual funds everyone said that our investment would be compounded, so I had doubts about that because as per my knowledge of Mathematics that is not called compounding. You are the only person who said compounding will not happen.

[@mohitsomaiya]

Assume, you have invested in TATA motors 1 year ago, Assume share purchase price 250. Now after a year, assume it yesterday it closed at 450. And in today's market it increases by 1% only.... I.e. 454.5 now how much is 4.5 to your 250 purchase price is 1.8% .... Now tell me is it compounding or not?

[@Yashwanth_KN]

@@mohitsomaiya thats not how the compounding works. Compounding means, lets assume you took 10,000 loan from bank with 10% compound interest. After 1st year interest will be 1000(total=11000), after 2nd year interest will be calculated to 1100 so final interest will be 1100. But in share market or MFs it is just number of shares or MF units you have & unit price matters. It is just difference between share price at the beginning & the end.

[@mohitsomaiya]

@@Yashwanth_KN Dear, I know, I am a banker by profession. I just explained what they mean when they say compounding....

[@Yashwanth_KN]

@@mohitsomaiya ok, means according to them compounding will happen on daily basis in share market right?

[@Yashwanth_KN]

@@mohitsomaiya according to you, does compounding happen in share market?

[@RGchutiyahai]

I gained more practical knowledge from this video than portfolio management class in my college.

[@amarsharma739]

Bahut badia Bawa... Retirement tak videos dalte rehna tum... To meri retirement planning bhi tension free ho jaegi 😛

[@ankitparmar9641]

😂😂😂

[@Chair.dreamer]

When information is free to access, then whats the point in educational institutions commercialising this. A Ton of salute to the crew members behind this channel.

[@jayrana2225]

IRR is 100 %. Same as your channel growing 🤟👍

[@parmarhitesh8703]

It's 50%

[@ankushbudhiraja9475]

@@parmarhitesh8703 it's 100perc

[@evm6177]

Arrey Super Thanks yaar Mandeep Bhai.. Great XIRR demo using just Google sheets, Hats Off bro! 😎👍👍💵

[@AnamEjaz]

"The Best Explanation from The Best Person" This video had all the answers to my questions. Though I read on Google yet Now I understood everything clearly. Money Minded Mandeep is better than Most IITians I can Bet.😎 Editing on this channel have gone to next level. The ending was cool and the part where calculation was done too good editing.

[@PrinceSogani]

Thank you bro :)

[@pranawaryan]

Mandeep ji, agar annual mode hai to IRR and XIRR dono same hi aata hai.... aap IRR wale cell me percentage me decimal places 3 lijiye, dono same hi aayega

[@ankitburman2980]

hi Mandeep! Just wanted to know the pros & cons on investing in mutual fund for a complete one year rather than going for monthly SIP.

[@akashgope6332]

Cons average return

[@learnearnngrowww]

My all doubts are cleared after watching this video. thnx bro...

[@parmarhitesh8703]

Great. Thank you. I was confused before to calculate my CAGR return in my stock investment in last 4 years. Now can I consider XIRR as Cagr return ?

[@LabourLawAdvisor]

Yes

[@utube4bibek]

Really informative 1000 invest in 1st month and get 1500 after 6th month i.e on 7th month then IRR is 7% But XIRR is is 126.517%

[@JigneshBhavani]

Mandeep can you make a video on Tax harvesting option on Kuvera?

[@LabourLawAdvisor]

I plan to ❤️

[@JigneshBhavani]

Thank you 🙏

[@vandergrift5557]

Bahut kaam ka video hai, aise aur bhi funds related videos chahiye

[@sanjaysagar1509]

Just put ctrl+shift+# and if date will not come thn there is some problem in date format

[@ArjunGupta1201]

One of the best video of xirr over internet ❤❤❤❤

[@pulkitjain8135]

And people say maths is not used in real life.

[@suchAdrag]

Maths kaha use kari 😅

[@Rajat1293]

God bless you 🙏 ​@@suchAdrag

[@sushobhanpaul6216]

Itna acha toh MBA ne bhi nhi sikhaya tha ... ❤❤❤❤ Totally loved it!

[@RaviMishra-or2st]

MBA 😂😂

[@heyhemant]

1000/- rupees in 6 month gives 50% return than IRR will be 100% (50%*2)

[@rajneeshgarg5912]

Well explained , first time i have understood xirr... Thanx bro

[@VineetKumarX]

Answer to question = 8%

[@Dr.Sunnydhanani_official]

World class explanation. I have already attended the XIRR and IRR lecture from IIM Bangalore but this explanation is on another level. Thank you for your teaching with simplicity. Here is the Answer for your Question posted at the end: XIRR = 164.76% IRR = 8%

[@avnishbadoni1393]

Can you please tell me how bro? I was thinking, since the funds are not compounding, it would be plain 500 rs in 6 month, and hence 1000 rs in a year. Hence x internal rr = 100% for an amount invested for 1 year

[@sunil_mewada_]

U also 👍Awesome

[@basavarajchiniwal5286]

Aap genuine information dethe ho sir

[@priyansh1210]

Mandeep, thanks for the awesome material. I had a doubt. You said that there is no compounding in Mutual Funds. Isn't it the case (at least in Growth MFs) that the earnings from stock dividends/bond intrest payments and capital gains resulting from trading of the holdings are reinvested back into the MF making it kind of a compounding scheme?

[@LabourLawAdvisor]

Kind of compounding, yes Exactly compounding, no Still doesn't change the fact that equity investing has the power make enormous wealth.

[@LabourLawAdvisor]

Kind of compounding, yes Exactly compounding, no Still doesn't change the fact that equity investing has the power make enormous wealth.

[@ashwathprabhu]

You got one more subscriber today. Great video, very good explanation. Keep up good work! 👍🏻

[@samaksh89]

@labour law advisor: In response to the question asked in the end of the video, XIRR= 126.52% and IRR=5000%. Is it correct ?

[@anukoolthapa]

no the answer is 22%

[@beyondsumit8052]

@@anukoolthapa could you plz elaborate the calculation Y've done?

[@arjun.impulse]

The best part in ur videos is not only knowledge and information but also language. Being a Karnataka guy, I can understand ur Hindi very clearly, sir. May be u don't use Urdu or complicated Hindi words in it. Thank you.

[@surajkala]

Now i can flaunt terms like XIRR IRR with my CA friends 😂😂👍

[@rodeopriya]

Learned lot many new things.. Answer for your question.. as you said IRR can be calculated year wise..so IRR cannot be calculated for 6 months duration.

[@digvijayrana2716]

Best video...Aapne mausam badal diya😂👍

[@rsn5]

Excellent video. Answer to your question at the end is IRR = 100%.

[@89ulfr]

Finally i saw a video where i really learnt the stuff...quality content brother..thanks

[@PranavPatil-t2t]

This is the best explanation I ever seen for XIRR :)

[@darkhorse2584]

This guy is simply genius.!

[@superclasher5838]

Mandeep trust me you're a awesome teacher, lots of love from mumbai and best wishes to you, Rishab and the whole LLA team.

[@bhavna3940]

Best channel for financial education

[@TGlife-l5e]

Best Video over XIRR... Thanks buddy

[@SandeepMankar-xj2wf]

Mandeep Bhai, I want you to know that you are helping in creating wealth by controlling the blunders and common sense mistakes by creating awareness... Thankyou and I am really proud of your research sharing attitude... thanks a ton brother

[@rahuljain1888]

Very useful,,, but aapse pahle MUKUL sir ne bhi bnaya hua h. Both are best😊❤

[@computerenthusiast007]

Man kar rha is channel ko char account se subscribe kr lu😍

[@lakshyaagarwal3536]

Wow, I loved the video. First time, I understood what an IRR or XIRR is!

[@bhavishyarathore3632]

6month me 1000 se 1500 ho gya matlab 50 percentage growth hui...agar yahi ham aage bhi expect kre jesa XIRR me hota h to next six months me fir se 50% return milega Jo 1500 ka 50% 750 Banta h to tatal value ho jayegi....2250 To XIRR yha se nikl ke aayega 125% Or is case me CAGR hoga 100%

[@lakshyakumar-tx8cf]

cagr kse 100 percent hoga bhai, vo bhi to 125 percent he hoga na...

[@anujsarvaiya1587]

This channel must got more than 30 M subscribers... Hatsoff to your content ❤️

[@noorhaque91]

Very Informative Video, Sach kahu to chakshu khol diye sir aapne.

[@rishabhagarwal2476]

amazing content Demag ki batti khul gayi

[@shahnawaztinwala8045]

Amazing explanation. Finally after so many years of investing in LIC, now i get to know k chindi returns deta hai LIC sala.

[@LabourLawAdvisor]

:) Also watch my video on "Endowment plans". I talked about plans like LIC offers

[@shahnawaztinwala8045]

For sure. Ab toh dekhna hi padega

[@sayanighosh6514]

Mandeep you are now my personal investment trainer... love the way u explain...

[@balamuralikrishnakajuluri9236]

All doubts cleared in one video.Good work.

[@vikrantmakwana]

Perfect explanation. Much appreciated if you could also include the usage of the CAGR, IRR and XIRR, particularly, with examples of your SIP calculator and show which % you are using in the calculator, and how using CAGR, IRR and XIIR needs to be interpreted.

[@ashleshdevdare31]

Thanks Mandeep for accepting the request and making the video. This is really helpful for calculating interval investments. Which we were not aware earlier.

[@tabishkazi6139]

Hey brother. Do you think an app. Where u can u put date and investment amount and gives xirr will be useful?

[@parvejsolkar123]

Double click on date wala trick nahi pata tha excel ka...thanks 🙏