Calculate IRR in Excel (Formula, Examples) | IRR Calculation in Excel

[@88KeysIdaho]

Thank goodness for captions! I'm guessing this was for use by an Indian audience? I appreciate you sharing your knowledge.

[@rosejames9838]

The best video out there about IRR in Excel. Easy to follow and understand the values.

[@alfredotoscano4770]

Thank you so much for making this so easy to understand..

[@wallstreetmojo]

My pleasure!

[@trisviel7777]

thank you so much for explaining it, in a simple and understandable way !!

[@wallstreetmojo]

You're very welcome!

[@th3bastion952]

Thanks for this video, but if there are two IRR (two times the NPV equals 0 ) how can we display the both and not only the smallest one ?

[@gauravmohan9271]

Thank you brother…

[@snehagupte7396]

very well explained

[@walesthinker8806]

I am trying to create a dynamic range based on the number of months eclipsed to an IRR function. I would like to get your input on how to do that.
Example:
[Cell A1] Beg Balance = -20000
[Cell A2] Monthly Contribution = -200
[Cell A3] End Balance = 25000
[Cell A4] IRR % after 5 months of contributions =IRR((A1,A2,A2,A2,A2,A2,A3),0.01)
I am wanting to avoid adding another A2 after each new month.

[@biswadeeproy4986]

what happens when there is income generated at 1st year and then all are cash outflows. How to calculate in those cases through excel?

[@lucymaynard6798]

How do we do these calculation manually? Without using excel

[@dr.prasadjoshi9710]

Refer this video for doing IRR without excel
ua-cam.com/video/R1U7YwaZccs/v-deo.html

[@scolson18]

What if we have an initial investment of 10,000 and do not collect anything for 5 years but the end return payment is 20,000. The IRR doesn't seem correct.....

[@mzonkenhlapo8944]

Do we use gross or net income values?

[@HexxuSz]

you need to us free cashflow generated

[@jithendaradupa6814]

IRR calulation format in Excel required

[@anusuyaparida3808]

Very easy

[@wallstreetmojo]

Thanks!