What Is XIRR? XIRR Vs IRR Vs CAGR | XIRR In Excel Explained By CA Rachana Ranade
ฝัง
- เผยแพร่เมื่อ 4 ต.ค. 2024
- This lecture on #XIRR explains the use of #XIRRinExcel and the difference of #XIRRvsCAGR.
XIRR in Mutual funds is essential for calculating returns on investment. Learn what the XIRR formula and how XIRR calculation is done.
You can get my Stock Market courses on www.rachanaran... It’s an opportunity to learn 65+ concepts relating to Basics of Stock Market in 11 sessions! Feel free to WhatsApp on +91 9022196678 if you have any purchase-related queries.
Android App: bit.ly/CARRAnd...
iOS App: bit.ly/CARRiOSApp
Basics of Stock Market Course: course.rachana...
--------------------------------------------------------------------------------------------------------------------------------
Join my TH-cam Memberships: bit.ly/JoinCAR...
-----------------------------------------------------------------------------------------------------------------------------------
✔️ To Invest in Cryptocurrencies try WazirX► link.rachanara...
--------------------------------------------------------------------------------------------------------------
✔️ If you want to create your demat account then please click here for assistance:
forms.gle/ddA7...
--------------------------------------------------------------------------------------------------------------
Insure your life and health
✔️ Life Insurance► bit.ly/3tYenqr
✔️Term Insurance►bit.ly/3ynVssD
______________________________________________________________________
To invest in themes based portfolios, check out the following Smallcases
✔️ Top 100 stock ► link.smallcase...
✔️ All-Weather Investing ► link.smallcase...
_____________________________________________________________________
Facebook► bit.ly/CARRFac...
Telegram ► t.me/CARachana...
Instagram► bit.ly/CARRIns...
Twitter► bit.ly/CARRTwi...
Linkedin► bit.ly/CARRLin...
------------------------------------------------------------------------------------------------------------------------
Playlist:
Basics of Stock Market For Beginners: link.rachanara...
Books to read: link.rachanara...
As promised, I am posting the correct answer of the question asked at the end of this video.... and.... The correct answer is 8.42%.
Thanks for this video and especially such a detailed manner. I understood. I was one of the best video I had seen on your channel.
This video is one of the reasons why to subscribe and press bell icon. And conversation in English is a 🍒 on the cake.
Ma'am i have a small request..
Can you upload a video on How to calculate a fair value of a companies stock? Or Different ways of calculating the fair value.
@@rohansarda2696 no use of this thing cuz companies in a bull market will always exceed the fair value and trade at discount in bear market. Also fair value will be different for different ways. Above was my experience not theory or speculation.
@@gauravchoudhary4218 I know this bro.. But just for knowledge purpose..
Financial knowledge+Sense of humor+ Speaking ability+ Confidence+ Expression+...=Rachana Madam
And beauty all in one...
So true
+ बदमाशी वाली मुस्कान 🙃
Nothing but "Beauty With Brain" 😀
Don't agree. The explanation is unstructured, childish and not targeted for adults.
I always love your style of presentation - i can imagine the amount of hard work you put in last 15-20 years thru your teaching career. The sense of humor doesn't develop overnight. As usual, great content and to the point explanation. Love you mam from Norway
The Norway part was to show off
The main difference between Excel XIRR and IRR functions is this: IRR assumes that all the periods in a series of cash flows are equal. You use this function to find the internal rate of return for periodic cash flows such as monthly, quarterly or annual. XIRR allows you to assign a date to each individual cash flow.
you are right, she is saying random things lol
ABSOLUTELY CORRECT
Xirr gives the return rate considering days for which you remained invested
Damn, this woman really needs to go back to her CA notes, commerce notes, or school 😮. I cannot believe this woman said this..
Thanks for restoring my faith! Some sanity finally.
Thanks for the excellent presentation...! I joined your channel only today. I am sure I will learn a lot though late as I am only 76 years old.
Best wishes.
One of the best explanation of XIRR among all the videos in youtube. Thanks a lot madam for the great work.
Really Thank you soo much for your contribution towards improving Financial Literacy in India
Me too learnt a lot from your videos and your way of teaching is very beautiful and very easy to understand
Hello !! Learnt CAGR and XIRR from your videos....For the question you asked, answer is 8.42. I have tried all the exercises of xirr you gave in excel and got correct answers. in my computer I am unable to put date as 10-02-2019 ...I can enter date as 10/02/2019 and still got the correct answer. Many thanks for your videos. Excellent, high tech, flaw-less presentations.
Mam you have got a really great sense of humor, which makes your videos even better.🙂
It's so clear. The way you explain is very easy and comforting. How come i didn't spot this channel so long..!! Thanks 🙏
Madam,
Excellent explanation.
Your act of wearing specks is stylish as like introducing hero in Cinema
I am Professor, likes your style of delivering.
Excellent video after a very long time I can now understand about xirr . Thanks Madam for this video.
Answer is 8.42%
BTW, very good video and impressed with your presentation skills Rachana!! Your content and way of explanation is always extraordinary. Keep up the good work and your effort for us is highly appreciated 🙂👍
AMAZING WORK Rachna , This was by far the most confusing method but u made it so easy for us. Keep up the good work , watched this video after 2 years and it Helped !!!!!!
2 seconds ka wait 😆 your sense of humour is amazzzzzingggg 🤘
Mam, u r a very good teacher. I'm respecting u very much. Informative videos in a causal way like walk in a garden. But behind that u r putting so much of hard efforts (in green matt visuals and giving examples) in the making of videos. It's really worth bcoz people like me will get information by that. I appreciate ur work with respect. God bless you and ur family.
Thank you Rachana! Great learning on CAGR and XIRR!
Every video explained with example. Easy to understand 👍
I would like to congratulate you ma'am on your goal of growing financial literacy among our people, I am becoming more and more financially literate after watching more and more of your videos.
Thank you Ma'am for such a simple explanation....please keep posting such videos....
Mam you're amazing
😊 blessed to be your TH-cam student!!
This is the first time I have been watching this for a reason(a reason that i have no idea of these investments and returns stuff) and I totally understand what you mean, you are great in what you want to say. Thank you for great explanation. you are great, great personality.
Nice explanation by providing several scenarios.
One more scenario I wish to consider (Similar to chit fund):
> What if the payout (which happened in mid of the duration) have larger value than so-far invested amount?
> Will XIRR work for that too?
> Should the final row value always be the positive value?
For the following example, XIRR = -17.59%
> Is the chit fund a non-profitable for that person?
Eg:
Persons in chit: 24
Chit amount: 120000
Term months: 24 (Monthly pay-in is 5000 without dividend)
7 April 2018 -3850
10 May 2018 -5000
7 June 2018 -4100
6 July 2018 -4000
6 August 2018 -4200
6 September 2018 -4200
9 October 2018 -4200
6 November 2018 -4250
5 December 2018 -4570
6 January 2019 -4620
6 February 2019 -4810
7 February 2019 115000
6 March 2019 -4710
6 April 2019 -4750
5 May 2019 -4720
5 June 2019 -4800
5 July 2019 -4850
5 August 2019 -4850
7 September 2019 -4850
9 October 2019 -4925
5 November 2019 -4920
8 December 2019 -4920
7 January 2020 -4900
10 February 2020 -4930
7 March 2020 -5000
Thanks in advance.
XIRR is 2.1796
I have same question, getting value error while calculating this
Chits has a separate fanbase 😂
Ma'm, after listening to ur videos.. its like subscribing to channel for lifetime
i got it there was error in format its showing MM-DD-YYYY, I got it correctly 8.42%..Thanking you for the lovely lecture hats of to you Madam..
No one has explained in such a detailed & easy way about the XIRR..Hats off to you mam..👍👍👍👍👍👍👍👍👍👍
Thanks for this helpful post Rachana ji. One slight correction though - Date format need not necessarily be DD-MM-YYYY , it really depends on the default which is there in your excel installed software. In my case (Microsoft Excel on Mac OS) , I had something different and XIRR calculation was giving error. I had to change it to my format ( I opted for DD-MMM-YYY like 12-Jun-2020) and boom, it started working then. So might want to add this disclaimer in the video, may in a caption note.
Also XIRR is the extended IRR. IRR is used for fixed periodic entries, usually multiple outflows and one inflow or vice versa. But, if periods are irregular and there are unequal inflows and outflows (say in a PPF), we use XIRR. That's why specific dates are mentioned.
Thanks maam for providing the concept of cagr and xirr in such a simplied manner. I hope i will be able to invest judiciously. Thanks a ton maam
Thank you Ma'am, Rishta wohi soch nayi!! :-D You, have clarified #XIRR concept with such ease, I was always confused about it. Thanks again.
The XIRR explained is completely wrong. That's not what XIRR is
Your teaching as well as your sense of humour both are mind-blowing.Not a single video of yours ever feel boredom.
You carry an amazing personality.
You have endless qualities so I my fingers are not in my control to stop typing more.
By the way,Thank you Rachna and God bless you.
Excellent and easy explanation ❤️ wish we would have 10 years ago, my life would have been financially much more abundant ❤️❤️
I hv bn in d mkt fr 20 yrs but never bothered to understand all this. Ur video enlightened me. Great going Rachana. Ur doing a wonderful job.
Great content as always. But I feel you should have explained the concept behind calculating IRR manually and then gone for excel.
Request you to do another video on the same topic.
Agree with this. That will give a greater conceptual clarity.
Good way to explain..very nice video.
One liner..Simple way to understand formula and it's use
Absolute Returns: Single investment, One year
CAGR: Single investment , Multiple years
XIRR: Multiple investment, Multiple years.
I m the 2nd one 😂 Mam u r doing great job .. Love & respect from Pakistan 😊😊
Wow btw bro stock exchange waha konsa?
Fantastic way of teaching
I just got it clear after 30 years
10:28min you have written DD-MM-YYY but you said MM-DD-YYY...
Nice video Thank you..
It all depends on settings in excel
@@alimehran9540 yeah I was just referring to what she has mentioned on the screen and what she was saying was different...
Thanks
@@joysaha8943 always welcome
Bro it depends on windows regional settings.
@@rajuar1955 yes settings. Not the format.
This is the first time I'm watching this channel.
Liked the way you teach.
Very few channels I subscribe by watching only one video.
Mam, excel me percentage format krne k liye shortcut:-
Cell ya range ko select kr k cntl+shift+5(key board wala) 🙏
after wonderful calculation of CAGR, learned this new thing today XIRR. it will help me to analyze my returns better, thanks a lot
Nice video, good learning,
At the time of review you say mm-dd-yyy , but I think it is dd-mm-yyyy, what is correct?
After seeing multiple videos finally my concepts on xirr is clear.Thanks to u mam.Much appreciated.
thanx ❤️
Most simple way I ever understood the Financial concept ..you are awesome
Ma'am, could you pls clarify whether the SIP calculators take XIRR or absolute returns into account ?
Well, it depends on what platform you're using. I can tell you with some first-hand experience that, Kuvera and zerodha can show you both.
If you use Paytm money, then under each sip investment, you can see it mentions XIRR investment return in percentage.
First time learn on this channel absolutely amazing
I very much appreciate your efforts and knowledge of wisdom. Would love to see brief vlog on Sensex & Nifty?
1. How they are different from each other?
2. How it valued on index 40k Sensex or 11000 nifty etc. Maths / equation behind ?
3. Which one should be looked more ?
All the best !!!!
Sensex is indicator of BSE whereas Nifty is Indicator of NSE.
Sensex accounts for different number of companies as Nifty, hence the evaluation and price is different
3. Both or just one world do getting the idea of the market.
More commonly used and referred to market is Nifty
Saw this video during studying MAGIC OF MUTUAL FUND...understood the return concept..thank you madam
Don't learn only when to buy, also learn when to sell.
8.42%. Such a wonderful video. So interactive. Makes you want to take the effort and do things.
You are very good CA knowledge sharing to everyone from basic level 💰💰💰nice video keep it going 👩👩
रचना मैडम बहोत धन्यवाद आपका
इतनी आसानी से समझाने के लिये
युट्युबपर एक बुढ्ढा है मनोज कुमार जैैन नाम से वो यही बात बताने के लिये ऐसे अकडता था जैसे हमने कभी ऐक्सेल के फॉर्मुले देखे नहीं
आज आपने इतनी सरलता से समझाया बहोत अच्छा लगा, बोझ हलका हुआ
और मैंने अभी अभी मेरी ऐक्सेल में बनाकर देखा बहोत मस्त
🙏
Simply super.. very good explanation in very simple way interesting.. keep going...
Great explanations and clear examples. Thanks!!
Very Good Video. Excel spreadsheet way of explanation is excellent
Your way of explanation is very simple and easy to understand. Thanks mam. Keep rocking.
This is the first time I viewed your video. I loved your style of presentation with humour and excellent to the point and thorough content. Keep it up, God bless you.
Rachana mam is really genius.
A complex topic but enjoying due to way of teaching.
Outstanding explanation.
Crystal clear🙂
All the concepts are very clearly explained...
One of the clearest way to explain both the concept as well as the formula to the newbies.
Beautifully & Simply Explained. It was Fun. Thanks.
8.42 percent... Thanks for such an informative video...you are our modern age guru 🙏🙏🙏😊
Excellency im term of Guiding with Examples.. Thanks Mam 🙏
@ CA Rachana Ranade Phadke :-
Thank you so much Rachana Madam for making this great video. Till now I was calculating my profits like 3rd Grade (lol😊). Now I understood what are the exact methods for calculating Profits in case of Lumsum Amount and SIP.
Once again, Thank you so much for all your videos. Keep making the Videos.
God bless you 😊😊
Superb way of teaching this is amazing DON Rachana
Excellent video.So far I had only heard or read about these formula but never ever understood it. Thanks to this video clip, it all looks so simple and very interesting.. thanks a lot for uploading it..
Your way of saying is quite impressive and useful. Your depth of knowledge and humour makes learning interesting. Thank you so much mam.
Your style of explanation is too good.
Im a CA too, your videos are SFM revison for me!! :D
I invest like the 4th option , uneven Dates and Uneven Amounts , Very Knowledgable VID
What an explanation! Crystal clear, detailed, yet so simple :)
Yesterday tried to calculate xirr but not succeeded but your video gave a very good perspective of the concept. Going to use it now.
Thanks Mam.
Hope you keep us enlightened like this.
Thanks for clarity about XIRR & CAGR
Nicely explained in a simple manner. Uncomplicated!
Always option 4..whatever rachana ma'm says is correct..what a way of teaching..even a small kid can understand..hoping that our teachers gain something on how to teach just like you..complete lucid way of teaching..but makes you understand like you can also teach other people..but one question ma'm, if on single date there is both inflow and outflow, will it work?
Rachana, you are explaining so easy although I am not belongs to proper English language. You are really very strong in finance. Basically I am the Textile designer but as of now I understood a lot because of only you. Keep it up. May God shower blessings upon you.👍
Thank you madam . Your presentions are always not only informative but are easy to understand also.
Wow... you are awesome, great, amazing, fantastic i don't know what to say more.......I am really very much impressed by you and your way of explaining the most complicated financial calculations in a very simple and easy way. First time I have watched your video. At last tons of thanks to you. Keep posting....keep going
I was trying to workout IRR in excel, and I did not get the results. After researching, I found out that I should use 'negative' values for paying out; and 'positive' value for receiving in. That worked finally..
Nice feedback
Superb way of explaining. Thanks
Nice and clean explanation....My best wishes mam
Nicely presented with no ambiguity. Keep it up. All the very Best.
Nice to learn a new thing.
Very helpful.
Thank you mam
Ans is option 1 ...8.42%
Learning so much from your videos in 1 month that I couldn't understood in last 5 years
Me too
Very unique and simple way if teaching financial concepts.
Thank you mam and please continue to guide us in the same way for our future..
What a gr8 simple process ....
Thank you so much for the XIRR (with uneven times and values) calculation tutorial. this is really helpful for new mutual fund investors to understand.
Very informative. So proud of you ma'am.
😎 pakka video to learn MF and stock. xirr calculation is very easy to understand
Thanks for simple language examng XIRR .
Mam you are too good and perfect. After watching this I will watch your CAGR video
Thank you! Wonderfully explained...
Thanks Rachana for the clear explanation.
Very simple to understand Xirr. Thank you Madam 😊
Very well explained!! Brilliant!!
you are very good at teaching. way better than many others.
Aap itna badhiya explain karti ho....sab samajh mein aa jata hai achchhe se 🥺🥺🥺🥺🥺🥺
Actions speak louder than words, and yours tell an incredible story.
There is absolutely no doubt that ur teaching style and explanation is fantastic madam. Presentation laced with humour is a bonus to the viewer as it makes the lecture very interesting. Keep going Rachana maam. Truly a commendable job.