What Is XIRR? XIRR Vs IRR Vs CAGR | XIRR In Excel Explained By CA Rachana Ranade

[@CARachanaRanade]

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%.

[@gauravchoudhary4218]

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.

[@gauravchoudhary4218]

This video is one of the reasons why to subscribe and press bell icon. And conversation in English is a 🍒 on the cake.

[@rohansarda2696]

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.

[@gauravchoudhary4218]

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

[@rohansarda2696]

@@gauravchoudhary4218 I know this bro.. But just for knowledge purpose..

[@PrakashPatel-ch7rw]

Financial knowledge+Sense of humor+ Speaking ability+ Confidence+ Expression+...=Rachana Madam

[@meenakshisaxena5214]

And beauty all in one...

[@harshadjoshi1160]

So true

[@berealistic8170]

+ बदमाशी वाली मुस्कान 🙃

[@sksiva8740]

Nothing but "Beauty With Brain" 😀

[@vgupta4760]

Don't agree. The explanation is unstructured, childish and not targeted for adults.

[@prasantdara]

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

[@gokuvegeta9500]

The Norway part was to show off

[@samarthgupta1849]

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.

[@abirchatterjee8131]

you are right, she is saying random things lol

[@rahulagarwal6339]

ABSOLUTELY CORRECT

[@vinodkothari6821]

Xirr gives the return rate considering days for which you remained invested

[@nitinkavade1684]

Damn, this woman really needs to go back to her CA notes, commerce notes, or school 😮. I cannot believe this woman said this..

[@Stoicprof]

Thanks for restoring my faith! Some sanity finally.

[@kottamorevenkatesh2921]

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

[@55soman]

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.

[@DrDChandramohan]

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.

[@Anand-rl4pk]

रचना मैडम बहोत धन्यवाद आपका इतनी आसानी से समझाने के लिये युट्युबपर एक बुढ्ढा है मनोज कुमार जैैन नाम से वो यही बात बताने के लिये ऐसे अकडता था जैसे हमने कभी ऐक्सेल के फॉर्मुले देखे नहीं आज आपने इतनी सरलता से समझाया बहोत अच्छा लगा, बोझ हलका हुआ और मैंने अभी अभी मेरी ऐक्सेल में बनाकर देखा बहोत मस्त 🙏

[@narayanasamyp8584]

Madam, Excellent explanation. Your act of wearing specks is stylish as like introducing hero in Cinema I am Professor, likes your style of delivering.

[@upcurvemotivation]

One of the best explanation of XIRR among all the videos in youtube. Thanks a lot madam for the great work.

[@sreenathputluru1405]

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 🙂👍

[@puneet4ever]

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.

[@rohitmahali]

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.

[@the.zen.investor]

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

[@arjunkishtwaria]

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.

[@smileplease0326]

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.

[@naveenchandakothe4648]

Mam you have got a really great sense of humor, which makes your videos even better.🙂

[@aknakn5187]

Saw this video during studying MAGIC OF MUTUAL FUND...understood the return concept..thank you madam

[@parthaghosh5642]

2 seconds ka wait 😆 your sense of humour is amazzzzzingggg 🤘

[@uturgreat]

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.

[@joysaha8943]

10:28min you have written DD-MM-YYY but you said MM-DD-YYY... Nice video Thank you..

[@alimehran9540]

It all depends on settings in excel

[@joysaha8943]

@@alimehran9540 yeah I was just referring to what she has mentioned on the screen and what she was saying was different... Thanks

[@alimehran9540]

@@joysaha8943 always welcome

[@ExcelSquad]

Bro it depends on windows regional settings.

[@alimehran9540]

@@ExcelSquad yes settings. Not the format.

[@mohammedshareef6379]

Fantastic way of teaching I just got it clear after 30 years

[@jammuk1]

Thank you Rachana! Great learning on CAGR and XIRR!

[@pik0_2004]

I invest like the 4th option , uneven Dates and Uneven Amounts , Very Knowledgable VID

[@donfrancis1246]

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.

[@priyamakani]

Agree with this. That will give a greater conceptual clarity.

[@imtp70]

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.

[@shivrajzalaki5339]

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

[@JaykishanLathigara]

after wonderful calculation of CAGR, learned this new thing today XIRR. it will help me to analyze my returns better, thanks a lot

[@shwetakale1288]

Excellent and easy explanation ❤️ wish we would have 10 years ago, my life would have been financially much more abundant ❤️❤️

[@madhulearn8023]

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.

[@rupaliagrawal1471]

Mam you're amazing 😊 blessed to be your KZbin student!!

[@sudhanshukpradhan]

After seeing multiple videos finally my concepts on xirr is clear.Thanks to u mam.Much appreciated.

[@BhaveshAgarwal]

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.

[@praveenpai1060]

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.

[@PFulwade]

No one has explained in such a detailed & easy way about the XIRR..Hats off to you mam..👍👍👍👍👍👍👍👍👍👍

[@asadarshad3505]

I m the 2nd one 😂 Mam u r doing great job .. Love & respect from Pakistan 😊😊

[@nikhilkachhawaha]

Wow btw bro stock exchange waha konsa?

[@sheetalbiswas9225]

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.

[@myselfnaveenkumar]

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.

[@VinayKumarT1302]

XIRR is 2.1796

[@simrandeepsinghbhatia7791]

I have same question, getting value error while calculating this

[@raogaru306]

Chits has a separate fanbase 😂

[@Khairnarsk]

Rachana mam is really genius. A complex topic but enjoying due to way of teaching.

[@travelindiablog]

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?

[@rohanr221]

8.42%. Such a wonderful video. So interactive. Makes you want to take the effort and do things.

[@HimanshuSharma-hl5mf]

Ma'am, could you pls clarify whether the SIP calculators take XIRR or absolute returns into account ?

[@dushyantswarnkar1652]

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.

[@d3g305]

If you use Paytm money, then under each sip investment, you can see it mentions XIRR investment return in percentage.

[@indrajit0072]

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?

[@Manishsharmaseven9]

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

[@alanperks3011]

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

[@alanperks3011]

3. Both or just one world do getting the idea of the market. More commonly used and referred to market is Nifty

[@shivanshupande4992]

That's why I like ppl like her she can explain complicated topics (not this one but many others) in her vedios in v.simple language that even a layman can understand and learn ... however there are ppl how complicate simple things "Can fool can complicate simple things but it takes a genius to simplify complicated work"- Albert Einstein

[@sanjibpramanik9268]

Mam, excel me percentage format krne k liye shortcut:- Cell ya range ko select kr k cntl+shift+5(key board wala) 🙏

[@etianand24]

Learning so much from your videos in 1 month that I couldn't understood in last 5 years

[@XploreDworld]

Me too

[@valenciancountry]

thanx ❤️

[@APSPZP]

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

[@powerofcompounding123]

Don't learn only when to buy, also learn when to sell.

[@subbum8303]

It's so clear. The way you explain is very easy and comforting. How come i didn't spot this channel so long..!! Thanks 🙏

[@alokpatel437]

Nice to learn a new thing. Very helpful. Thank you mam Ans is option 1 ...8.42%

[@bhanupadhmajamaddula9761]

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.

[@cckumarroy1980]

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.

[@shriidharkulkarni6648]

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

[@Arjunad-2024]

Ma'm, after listening to ur videos.. its like subscribing to channel for lifetime

[@SK-bh4ni]

One of the clearest way to explain both the concept as well as the formula to the newbies.

[@samok5423]

I have completed bcom at 2006 .. then all my memory fade away.but from last one week i am investing in share market and learning it from rachna man . It's like my colleague day back . I really learn from rachan mam . Wish i had teacher like her in my colleague time . thanks mam .may god bless you .

[@vivekgupta1124]

8.42 percent... Thanks for such an informative video...you are our modern age guru 🙏🙏🙏😊

[@deepankersrivastava2346]

Most simple way I ever understood the Financial concept ..you are awesome

[@abhik2111]

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

[@nidhi9026]

Im a CA too, your videos are SFM revison for me!! :D

[@alhaddandekar6541]

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

[@pankajgandhi3419]

Excellent video after a very long time I can now understand about xirr . Thanks Madam for this video.

[@kulvindersinghseehra9673]

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.

[@prathamrevankar2398]

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

[@pcheulwar]

Best thing about your videos is that you speak english is very easy to understand ..Thank you keep it up

[@TruthSeeker10250]

I was reading about the same topic in investopedia for few days now they made it so complicated. Thanks to you now it's crystal clear with practical example. You rock!

[@Geekmasterproduction]

Those website are the worst. They give you textbook explanations but you walk away not really understanding it.

[@sonamtshogyel9637]

The answer according to my calculation is 8.42%. Really good lesson. From Bhutan

[@sanjeevpro]

Mam you are too good and perfect. After watching this I will watch your CAGR video

[@BangaruBabuPopuri]

Enjoyed watching the video. These XIRR with random dates and random amounts (+/-) were taught by my maths teacher during summer vacation after 4 th class and before 5 th class. I used to verify our account with the fertiliser and pesticides shop where we used to deposit money when ever we have money and take the goods when ever they are required. Interest rate is charged @24% ie.. ₹2/30 per day simple interest. My back of the envelop calculation gave me 19.78 (1500/(( 13*14/2)*10) *12 where the excel answer given for first case is 19.8. With excel people may forget the traditional calculations in the days to come. As the machines become more and more intelligent humans may loose part of their intelligence 😊

[@roeydaz]

Another great video from CA Rachna Ranade!!! I was trying to calculate my return on a ULIP offered to me and had no knowledge of XIRR and was trying to do it manually. I gave up very quickly. Thanks for this.

[@rashmir3944]

Rachna you are truly amazing .You put in so much effort to make us learn effortlessly. This is your 58 year old student/aunt. Bravo! keep up the good work. God bless.

[@MDRahim-zc7pv]

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

[@dushyant_luckmakesurlife]

Teaching Is An Art, You Are An Artist.... :) :)

[@tkw-zf6kt]

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.

[@rajeshvijaywargi4636]

I get correct answer 8.42% Thanks for learning me xirr in very easy way thank you madam

[@sukumars2384]

Your way of saying is quite impressive and useful. Your depth of knowledge and humour makes learning interesting. Thank you so much mam.

[@गढ़वालमंडल-न9ङ]

Actions speak louder than words, and yours tell an incredible story.

[@mehrotrashikha]

Thank you Ma'am for such a simple explanation....please keep posting such videos....

[@akashkulkarni3580]

Amazing!! This is what you call as "finance simplified"!!

[@subramanianc6190]

Your way of explanation is very simple and easy to understand. Thanks mam. Keep rocking.

[@kottamorevenkatesh2921]

Your videos are not only helps in gaining Financial knowledge but also improving English speaking skills

[@chiragbarmecha4031]

What an explanation! Crystal clear, detailed, yet so simple :)

[@shorttravelvlogs]

Aap itna badhiya explain karti ho....sab samajh mein aa jata hai achchhe se 🥺🥺🥺🥺🥺🥺

[@ashwiniranbhare5468]

I m learning so much from your videos about finance...thank u so much..and the answer is 8.42%

[@kalpeshshah6528]

Very nice video ....by surfing just accidently i catch this video i like this video and learn lots of things from this video...i feel like to be your student at the age of 45.....

[@mathersandi7622]

you are very good at teaching. way better than many others.

[@phani8591]

Beautifully & Simply Explained. It was Fun. Thanks.

[@gkps2068]

Amount invested is important than the number of units hold. No use of units hold in xirr calculation. Got your point 👍

[@xxl00nii3xx4]

Thanks ma'am! A fan from Singapore 🇸🇬

[@rsmani5792]

Nicely presented with no ambiguity. Keep it up. All the very Best.

[@sailendrasincerely7245]

Superb way of teaching this is amazing DON Rachana

[@DeepakMishradj]

Excellency im term of Guiding with Examples.. Thanks Mam 🙏

[@Shorts-fw6jm]

Excellent, your teaching skill is next level.

[@kavithap5594]

That was the best ever class for XIRR. Thank you

[@rajatchakraborty5237]

Your style of explanation is too good.

[@maheshmoharir9314]

Your way of explaining is simply amazing.

[@uttamsarnaik6467]

Great explanation ..... Keep it up keep spreading financial terms to whom these terms are necessary while investigating.

[@adelzaidan6204]

Amazing style of teaching and presenting. I am benefiting big time. Wishing you all the best and all the success.

[@yogenshah9470]

How you explain complicated concepts in simple language. Amazing