?? Work at Pickup Points � Flexible schedule

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

CA Rachana Phadke Ranade 643 views

Download Video

Comments

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