| Title | : | What Is XIRR? XIRR Vs IRR Vs CAGR | XIRR In Excel Explained By CA Rachana Ranade |
| Lasting | : | 17.19 |
| Date of publication | : | |
| Views | : | 643 rb |
 |
As promised, I am posting the correct answer of the question asked at the end of this video and The correct answer is 842 Comment from : @CARachanaRanade |
 |
Excellent Explanation 👍 Comment from : @ManaOoru-lr5lk |
 |
hindi Comment from : @mittalsam04 |
 |
If my transfer to my demat account on different date but buy shares on different dates, which date to use for xirr? Comment from : @mandirjain3211 |
 |
How to calculate the experience return amount?? You are taking final payment Direct Comment from : @NeerajLodhi-h7d |
 |
Good 👍 Comment from : @dipakkavar6893 |
 |
is XIRR formula true for less than a year as well Comment from : @hemantmallick7859 |
 |
Excellent explanation 🙂👍 Comment from : @RAJAT14677 |
 |
Simple explanation madam easy understanding thanks Comment from : @rameshbgaeo8711 |
 |
This teaching is incorrectbrXIRR (Extended Internal Rate of Return) is not used to measure the profitability of investments with regular cash flows Saying XIRR as MS's IRR is wrong Comment from : @kokeri1 |
|
|
Madam, you said that IRR and XIRR are the same, and XIRR is only the microsoft version of IRRbrBut Google says as belowbrThe main difference between IRR (Internal Rate of Return) and XIRR (Extended Internal Rate of Return) is that IRR assumes cash flows occur at regular intervals, while XIRR can handle cash flows that occur at irregular intervals Comment from : @kokeri1 |
 |
842 Comment from : @sundarrajan4724 |
 |
Great content as always Comment from : @PowerofMoney-s4d |
 |
How do I calculate inflow? Comment from : @ratuldutta6030 |
 |
2020: This video was helpful for some class presentations in my MBAbr2024: This video is helpful for a job interview brbrThank you so much Rachana Ma'am Comment from : @9kaustav |
 |
Does mam still give stock of the month for 399rs community members? Comment from : @akshaychoudhary8271 |
 |
Thanks Rachana for the clear explanation Comment from : @ankitGrover-LTD |
 |
Excellent ❤ Comment from : @ARJINDERSINGHAJMANI |
 |
842 Comment from : @nishantshrivastava8525 |
 |
What is ytm and when to use ytm when to use xirr Comment from : @sandeeptalwar3463 |
 |
2756 Amaya Garden Comment from : @RuskinDoreen |
 |
571 Nienow Isle Comment from : @BerkeleyIvan-n1n |
 |
878 Sawayn Land Comment from : @CampCeleste |
 |
IRR doesn't take into account when the actual cash flow takes place, so it rolls them up into annual periods By contrast, the XIRR formula considers the dates when the cash flow actually happens Because of this, XIRR is a more accurate way to evaluate an investment Comment from : @prasadreni |
 |
928 Gene Knoll Comment from : @MonroeIan |
 |
KYA YE CORRECT XIRR HAI MAM Comment from : @entertainment-lg6vp |
|
|
01-08-2023 -7000
br01-09-2023 -3000
br01-10-2023 -13100
br01-11-2023 -24900
br01-12-2023 0
br01-01-2024 -13000
br01-02-2024 -31000
br01-03-2024 -34500
br01-04-2024 -30000
br01-05-2024 -23000
br01-06-2024 -51200
br01-07-2024 -15400
br01-08-2024 301893 246100
br
brXIRR 6061 Comment from : @entertainment-lg6vp |
 |
Please reply 🙏🏻brThis xirr shows overall return of 198 or annualized return of 198 Comment from : @manishgirdhar4881 |
 |
does XIRR assumes compunding rate of return i;e does the monthly returns / yearly returns gets compounded? Comment from : @muralidharks7039 |
 |
debenture interest calculation or maturity se related koi healpful vide nhi hai please mam Comment from : @ravikumarshakya5983 |
|
|
Hello good evening mam, mam debentures mai interest calculation par ek video banaiye Comment from : @ravikumarshakya5983 |
 |
Exactly this video I am looking to understand XIRR Comment from : @1979arijitpaul |
 |
XIRR will be 842 Comment from : @UPmash |
 |
Hi can you please tell me what is that Rs14500? Is it the current value at the time of redemption which we have to enter? Comment from : @ratheeshsureshan7978 |
 |
Outstanding explanationbrCrystal clear🙂 Comment from : @robdavidowitz6428 |
 |
I miss mam's calming voice I miss her pure educational content Nowaday its 50 content 50 promotion Also too loud Comment from : @vedantvichare2911 |
 |
4 Comment from : @VenkatMadhesan |
 |
You said MM DD Yyyy in recap Comment from : @shubhamkokadwar7716 |
 |
Thank you ❤ Comment from : @snikhilchakrvarthy6001 |
 |
Very nicely explained Comment from : @harishchander3050 |
 |
Wao you will a hell lot of video on this topic But no one is near to this 😮 Comment from : @tabassum_alam |
 |
Answer is 4 Comment from : @vedsingh6777 |
 |
what if there are multiple fund inflows in the same month let's say 1 in the beginning and 2 inflows by the end of the month, how do we calculate that now ? Comment from : @soulsoothers9548 |
 |
Misguide for irr & xirr Comment from : @ravindragupta1886 |
 |
Plss share this excel sheet Comment from : @Akhil44448_ |
 |
My query to Mam RachanabrThanks for your tutorial on xirrbrWhat if the dates are not in order or not in ascending say sporadic The result will be accurate or not? Please explain Comment from : @abumohsin123 |
 |
Thanks for this video, I'm seeing this after 4yrs from the date it was posted 😅 Comment from : @priya_manocha |
 |
very useful and educative Comment from : @ravichandranv6344 |
 |
You are a great teacher Comment from : @utubesanjay |
 |
What is the problem if i consider absolute returns for my fund? Wjy should i go for xirr when absolute return is there to measure the returns Kindly let me know Comment from : @surajk508 |
 |
Whether this will include the inflation part Or How we can add the inflation on this calculation Comment from : @ajikrishnanag5400 |
 |
842 Comment from : @pasupuletisivakoteswararao2473 |
 |
🎉 Comment from : @mahaalingam87 |
 |
Well explained Comment from : @veerendrasingh7538 |
 |
Thanks for simple language examng XIRR Comment from : @shrinivaskulkarni1565 |
 |
Thank you! Wonderfully explained Comment from : @IshanRaj-ue2lu |
 |
MADAM JI, MAZAA NAHI AYAAbrSHIR KE UPAR SE GAYAbrRASHTRA BHASHA HINDI ME EXPLAIN KIJIYE NA Comment from : @jyotirmoysaha302 |
 |
It’s coming 856 for me Comment from : @kuntaladhikary8792 |
 |
How much xirr consider good for various categories of Equity mutual fund or say Equity mutual fund pls reply Comment from : @Cricket-Central-Criket-Ka-Kida |
 |
Great Comment from : @Blues-Blue |
 |
Will it also work if them monthly amount changes everytime? Comment from : @vraipurkar24 |
 |
Excellent explaination Even an novice can understand Comment from : @mohammedzafar8011 |
 |
very informative video even in 2024 ! Comment from : @RohiGupta |
 |
3rd standard me profit and loss kaha padha rahe bhai 😢😢 Comment from : @ranveersr8080 |
 |
XIRR and IRR in excel are different functions XIRR returns the internal rate of return for a schedule of cash flows that is not necessarily periodic IRR returns the internal rate of return for a series of cash flows at regular intervals Comment from : @ShivdevSingh |
 |
Thanks mam😊 Comment from : @JaiShreeRam-nz3en |
 |
So, Will it be right if I calculate the IRR for car loan amount as my return and EMIs as my Investment per month Comment from : @dineshgoud432 |
 |
I am literally clapping in the middle of the home by seeing ur videos❤ Comment from : @gosys05 |
 |
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 Comment from : @kulvindersinghseehra9673 |
 |
Appreciate the efforts but it is important people are aware of the real definitions Please do not use the two interchangeablybrbrIRR and XIRR are definitely NOT the same thing Similar in some ways, but not the samebrbrThe main difference is IRR assumes all cashflows happen at the end of the period while XIRR considers each date into its computation Comment from : @Stoicprof |
 |
You are hella funny 😂 Comment from : @lokeshis |
 |
Superb way of teaching this is amazing DON Rachana Comment from : @sailendrasincerely7245 |
 |
कुठली शाळा? तिसरीत percentage होते??? I doubt 🙄🙄🙄 Comment from : @ace3178 |
 |
MS Excel has both IRR and XIRR in their list of formulas There are 2 different formulas given because there is a difference between the two IRR has some limitations and XIRR overcomes these limitations Hence XIRR is used Comment from : @rahool953 |
 |
1 Good Video Comment from : @ranjitkamath2417 |
 |
U r really a good teacher Comment from : @ShrutikaVeer-pk6vt |
 |
Explained in simple language! Comment from : @shashikantlagwankar6756 |
 |
Hi XIRR used 365 day basis how to calculate for 360 days basi Comment from : @yogijanakiraman2716 |
 |
@CARachanaRanade, Can you please calculate IRR in the same example, you're saying IRR and XIRR are same??? Comment from : @AmitKumar-dz5qk |
 |
Returns from my folio since 2008 is 18 xirr Gud? Bad? Pls tell Comment from : @rameshk5157 |
 |
For stock return, holding a stock over a period of time Will CAGR give me absolute return? Brokerage sites shows simple return calculation which shows more than FD return age, but while using CAGR the return is very less So wanted to know, using CAGR is the current calculation for calculating stock returns Comment from : @vijayakumarpichumani48 |
 |
Rachna, you're the only one who says there's no difference between XIRR and IRR Comment from : @ashishbarick |
 |
Fantastic way of teachingbrI just got it clear after 30 years Comment from : @mohammedshareef6379 |
 |
Madam, With respect to long term corpus clarity, can you please do a long term XIRR/ IRR for some popular Mutual Funds and the deviation with respect to the long term CAGR for them? Comment from : @amitavabose8610 |
 |
Superb brThanks Comment from : @maithrilive |
 |
very knowledgeable Comment from : @meghagutgutia2223 |
 |
Plz u this do in Marathi video Comment from : @laxmiughade480 |
 |
No one has explained in such a detailed & easy way about the XIRRHats off to you mam👍👍👍👍👍👍👍👍👍👍 Comment from : @PFulwade |
 |
Thank you Comment from : @buttonsbowsindia1736 |
 |
❤ Thanks for this video Comment from : @sachinzope151 |
 |
Is IRR, or XIRR calculated in per annum manner? Comment from : @turbulantarchitect5286 |
 |
Madam I beg to differ IRR can only be used when the dates are same ex first of each month , while XIRR can be used at any dates and excel has both the functions Comment from : @mayankgalav9124 |
 |
Jai bhim Comment from : @ajaysahare30 |
 |
What an explanation! Crystal clear, detailed, yet so simple :) Comment from : @chiragbarmecha4031 |
 |
Calculate Internal Rates of Return with IRR and XIRR Functions in Excel РѕС‚ : Six Minutes. Smarter. Download Full Episodes | The Most Watched videos of all time |
 |
What is Short Selling Explained by CA Rachana Ranade РѕС‚ : CA Rachana Phadke Ranade Download Full Episodes | The Most Watched videos of all time |
 |
What Is P/E Ratio? Price / Earnings Ratio Of Stocks And Nifty Index Explained By CA Rachana Ranade РѕС‚ : CA Rachana Phadke Ranade Download Full Episodes | The Most Watched videos of all time |
 |
Top 3 Parameters for Company Analysis | CA Rachana Ranade РѕС‚ : CA Rachana Phadke Ranade Download Full Episodes | The Most Watched videos of all time |
 |
Basics of Stock Market For Beginners Lecture 1 By CA Rachana Phadke Ranade РѕС‚ : CA Rachana Phadke Ranade Download Full Episodes | The Most Watched videos of all time |
 |
Budget 2025: Income above ₹12 Lakhs? | Capital Gains | Taxation on Cryptos | CA Rachana Ranade РѕС‚ : CA Rachana Phadke Ranade Download Full Episodes | The Most Watched videos of all time |
 |
How to Start Investing in your 20s | CA Rachana Ranade РѕС‚ : CA Rachana Phadke Ranade Download Full Episodes | The Most Watched videos of all time |
 |
How To Pick Stocks Under 1 Min? | CA Rachana Ranade | #shorts РѕС‚ : CA Rachana Phadke Ranade Download Full Episodes | The Most Watched videos of all time |
 |
Excel for fresher Excel tutoring Excel for beginners Job interview questions РѕС‚ : Professional Inc. Download Full Episodes | The Most Watched videos of all time |
 |
How To Use VLOOKUP Formula in Microsoft Excel | VLOOKUP in Excel | Excel VLOOKUP #exceltutorial РѕС‚ : TECH-IELA SHAH Download Full Episodes | The Most Watched videos of all time |
