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

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 [phone] 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 KZbin 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...

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

[@Anand-rl4pk]

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

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

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

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

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

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

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

[@PFulwade]

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

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

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

[@naveenchandakothe4648]

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

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

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

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

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

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

[@upcurvemotivation]

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

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

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

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

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

[@aknakn5187]

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

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

[@shwetakale1288]

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

[@sudhanshukpradhan]

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

[@rupaliagrawal1471]

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

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

[@parthaghosh5642]

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

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

[@jammuk1]

Thank you Rachana! Great learning on CAGR and XIRR!

[@shorttravelvlogs]

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

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

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

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

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

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

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

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

[@sanjibpramanik9268]

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

[@mohammedshareef6379]

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

[@valenciancountry]

thanx ❤️

[@vivekgupta1124]

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

[@powerofcompounding123]

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

[@rohanr221]

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

[@Khairnarsk]

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

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

[@pcheulwar]

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

[@SK-bh4ni]

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

[@pankajgandhi3419]

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

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

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

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

[@Arjunad-2024]

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

[@etianand24]

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

[@XploreDworld]

Me too

[@deepankersrivastava2346]

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

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

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

[@maheshshinde6101]

You are very good CA knowledge sharing to everyone from basic level 💰💰💰nice video keep it going 👩👩

[@kottamorevenkatesh2921]

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

[@pik0_2004]

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

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

[@sukumars2384]

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

[@sonamtshogyel9637]

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

[@harshshaw1056]

Ap itni acche se padhate hai ki time ka pata hi nhi chaltaa or bina bore hue pura padhlete hai

[@sanjeevpro]

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

[@mayank1200]

Every video explained with example. Easy to understand 👍

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

[@subramanianc6190]

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

[@ashwiniranbhare5468]

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

[@rajeshvijaywargi4636]

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

[@pktsam2000]

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

[@vjain3971]

Nice feedback

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

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

[@rahulbagul5147]

I like your simple language. Actually due to English Language not understand properly i found some hindi videos. but when i see your Videos I feel, english is not so hard to understand. I like your video most.

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

[@DeepakMishradj]

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

[@muthu695]

😎 pakka video to learn MF and stock. xirr calculation is very easy to understand

[@mathersandi7622]

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

[@MrsSunena]

I m in lv with ur Simplycity n the way U make things easy for us. I watched a lot of vedios on KZbin regarding stocks urs are the one tht attracts me a lot. Your Honest opinions just make me lv U N ur vedios more N more. God bless you always. I hope I learn something from. You. 😍🥰😘

[@kamleshbhayani9723]

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

[@adelzaidan6204]

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

[@gkps2068]

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

[@abhijeetw2405]

I never had maths teacher like Rachna Ma’am 😅😅😅 extreme good teaching skills

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

[@surukansurameen1605]

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

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

[@rg5806]

Very Good Video. Excel spreadsheet way of explanation is excellent

[@alokpatel437]

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

[@rsmani5792]

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

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

[@chiragbarmecha4031]

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

[@sushikarthik5640]

The Video was great, Very Good explanation given with so many examples, was able to understand better. Thank you Rachana mam from Bangalore, Susheel

[@shakeelahmed-nl4jr]

First time learn on this channel absolutely amazing