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

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

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

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

[@MandhanAcademy]

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

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

[@Advaithsnair10]

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

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

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

[@anittaPapi]

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

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

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

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

[@ajithpr8357]

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

[@gopalsarda2158]

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

[@jff555]

Groww app show karta he

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

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

[@drprashantdash]

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

[@siddharthison1982198]

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

[@manishrakundla8205]

Very true

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

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

[@shuklabhanuprakash]

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

[@njaypee1]

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

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

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

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

[@kayamali7897]

Truly speaking these Valuable content deserves alot of appreciation ❤❤

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

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

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

[@Incognito38dhf]

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

[@LabourLawAdvisor]

Glad it was helpful!

[@sunnybarnwal8092]

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

[@InvestBeast]

best video to understand how calculate SIP. great brother

[@AbhinavKumarbagiboys]

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

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

[@ashwathprabhu]

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

[@sayandeepjana2987]

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

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

[@parthadebnath701]

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

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

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

[@vandergrift5557]

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

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

[@rajneeshgarg5912]

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

[@amarsharma739]

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

[@ankitparmar9641]

😂😂😂

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

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

[@learnearnngrowww]

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

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

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

[@jayrana2225]

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

[@parmarhitesh8703]

It's 50%

[@ankushbudhiraja9475]

@@parmarhitesh8703 it's 100perc

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

[@dr.manojpatil8289]

Clarity of voice, deep knowledge with due conference!

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

[@basavarajchiniwal5286]

Aap genuine information dethe ho sir

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

[@trustingcyber]

Fantastic Mandeep.....just loved the way you are explaining........excellent.....

[@sunil_mewada_]

U also 👍Awesome

[@ArjunGupta1201]

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

[@JigneshBhavani]

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

[@LabourLawAdvisor]

I plan to ❤️

[@JigneshBhavani]

Thank you 🙏

[@evm6177]

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

[@shrenikbadjate2074]

Why you dont make a video about the taxes on mutual funds ??? Its hard to understand whether go with mf or ppf as seen in your shorts please help

[@89ulfr]

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

[@pulkitjain8135]

And people say maths is not used in real life.

[@suchAdrag]

Maths kaha use kari 😅

[@Rajat1293]

God bless you 🙏 ​@@suchAdrag

[@ps36936]

Not all maths like logarithms, differentiation integration 😢

[@bhavinparmar608]

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

[@sanjaysagar1509]

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

[@PranavPatil-t2t]

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

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

[@TGlife-l5e]

Best Video over XIRR... Thanks buddy

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

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

[@heyhemant]

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

[@rsn5]

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

[@VineetKumarX]

Answer to question = 8%

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

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

[@bikramjit15]

Thank you Mandeep Sir 👍👍👍👍👍

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

[@digvijayrana2716]

Best video...Aapne mausam badal diya😂👍

[@surajkala]

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

[@milind1612]

Bohat badhiya samjhaya.... Kudos!

[@lakshyaagarwal3536]

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

[@DeepakGautam-kj6ls]

I am 29 now and I love & like only 2-3 channel for investment & knowledge. This LLA & SMKC & STFL... I WANT FROM U TO RUN THIS CHANNEL FOR MANY MANY DECADES SO MY SON CAN GET THE KNOWLEDGE TOO.... TYSM LLA

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

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

[@darkhorse2584]

This guy is simply genius.!

[@sushobhanpaul6216]

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

[@RaviMishra-or2st]

MBA 😂😂

[@sayanighosh6514]

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

[@noorhaque91]

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

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

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

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

[@itendrakumar8546]

Best explained.

[@chandrashekharanarayanarao3600]

Beautifully narrated. Thank you very much.

[@prathameshpande9040]

Great value addition ❤

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

[@balamuralikrishnakajuluri9236]

All doubts cleared in one video.Good work.

[@tushar5426]

Thank you so much Mandeep sir . This video is really helpful! Your way of explanation is awesome!!🥰

[@shivamagrawal162]

Loved it!!! Crisp and clear. Love your videos and shorts.