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

[@NamanSaklecha]

Very nicely explained !

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

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

[@parthaghosh5642]

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

[@Anand-rl4pk]

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

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

[@upcurvemotivation]

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

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

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

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

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

[@naveenchandakothe4648]

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

[@mohammedshareef6379]

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

[@jammuk1]

Thank you Rachana! Great learning on CAGR and XIRR!

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

[@rupaliagrawal1471]

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

[@PFulwade]

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

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

[@pik0_2004]

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

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

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

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

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

[@sudhanshukpradhan]

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

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

[@shorttravelvlogs]

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

[@shwetakale1288]

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

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

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

[@Khairnarsk]

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

[@asadarshad3505]

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

[@nikhilkachhawaha]

Wow btw bro stock exchange waha konsa?

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

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

[@JaykishanLathigara]

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

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

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

[@sanjibpramanik9268]

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

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

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

[@mohammadfiroz5085]

All the concepts are very clearly explained...

[@valenciancountry]

thanx ❤️

[@mayank1200]

Every video explained with example. Easy to understand 👍

[@powerofcompounding123]

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

[@phani8591]

Beautifully & Simply Explained. It was Fun. Thanks.

[@mathersandi7622]

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

[@aknakn5187]

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

[@robdavidowitz6428]

Outstanding explanation. Crystal clear🙂

[@alokpatel437]

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

[@Shorts-fw6jm]

Excellent, your teaching skill is next level.

[@shakeelahmed-nl4jr]

First time learn on this channel absolutely amazing

[@PowerofMoney-s4d]

Great content as always.....

[@subramanianc6190]

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

[@rajatchakraborty5237]

Your style of explanation is too good.

[@yomi001]

Great explanations and clear examples. Thanks!!

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

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

[@pankajgandhi3419]

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

[@vivekgupta1124]

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

[@mehrotrashikha]

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

[@sanjeevpro]

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

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

[@SaurabhGupta-er8xu]

Nicely explained in a simple manner. Uncomplicated!

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

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

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

[@rg5806]

Very Good Video. Excel spreadsheet way of explanation is excellent

[@swapnilbapat4889]

Amazing way of teaching.. Hats off to you

[@sailendrasincerely7245]

Superb way of teaching this is amazing DON Rachana

[@rohanr221]

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

[@sukumars2384]

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

[@DeepakMishradj]

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

[@domudalaarjun]

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

[@kavithap5594]

That was the best ever class for XIRR. Thank you

[@SK-bh4ni]

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

[@surukansurameen1605]

Simply super.. very good explanation in very simple way interesting.. keep going...

[@ashwiniranbhare5468]

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

[@kamleshbhayani9723]

amazing way of teaching and style of explaining.... very well understood madam..... please update with more knowledge if any other financial formula available....

[@ankitGrover-LTD]

Thanks Rachana for the clear explanation.

[@Thani-1234]

Nice and clean explanation....My best wishes mam

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

[@arunkul6889]

very well explained by giving examples to calculate return on sips ,it's so simple which we know after seeing this video ,many thanks rachana

[@xxl00nii3xx4]

Thanks ma'am! A fan from Singapore 🇸🇬

[@nidhi9026]

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

[@surekhasakharkar8910]

Thank you madam . Your presentions are always not only informative but are easy to understand also.

[@tanusreehalder3057]

Very informative. So proud of you ma'am.

[@niharranjanpal4959]

What a gr8 simple process ....

[@bhushanlokhande911]

Ma'am the answer is 8.42. Thank you for Video.

[@pcheulwar]

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

[@chiragbarmecha4031]

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

[@rsmani5792]

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

[@rajeshvijaywargi4636]

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

[@adelzaidan6204]

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

[@Owaismh54]

Very well explained!! Brilliant!!

[@pareshrpanchal]

Thanks for clarity about XIRR & CAGR