Part 2 - IRR How to Calculate Internal Rate of Return Explained (new)

แชร์
ฝัง
  • เผยแพร่เมื่อ 23 ธ.ค. 2024

ความคิดเห็น • 410

  • @VicSMeIsTeR
    @VicSMeIsTeR 6 ปีที่แล้ว +6

    Hello,
    I can't thank you enough for the great support and detailed explanation. I've been trying to understand it for hours, until I saw your publication.
    Cheers!

  • @monicazhang8915
    @monicazhang8915 10 ปีที่แล้ว +2

    We need more videos like this. The uni lecturers cover too much content within just 2 hours and the weekly tutorial tutors are not good quality teachers. We get confused about the lecture materials all the time but no one gives clear explanations. Thank you for doing this for us and well done!!

    • @MBAbullshit
      @MBAbullshit  10 ปีที่แล้ว +1

      Monica Zhang thanks for sharing the video!

  • @ElvisVasquez-z2o
    @ElvisVasquez-z2o 10 หลายเดือนก่อน +7

    r = 1/10 (sqrt(69) - 7) = 0.130662 = 13.0662%
    Simplify the equation: The term (1+r)^0 equals 1 because any number raised to the power of 0 is 1. So, the equation simplifies to -100 + 60/(1+r) + 60/(1+r)^2 = 0.
    Combine like terms: To make the equation easier to solve, we combine the terms over a common denominator, which in this case is (1+r)^2, leading to -100*(1+r)^2 + 60*(1+r) + 60 = 0.
    Expand and simplify: We then expand the equation to get rid of the parentheses and combine like terms: -100*(1 + 2r + r^2) + 60 + 60r = 0, which simplifies to -100 - 200r - 100r^2 + 60 + 60r = 0, and further simplifies to -100r^2 - 140r - 40 = 0.
    Solve the quadratic equation: This is a quadratic equation in the form ar^2 + br + c = 0, where a = -100, b = -140, and c = -40. We use the quadratic formula to solve for r: r = (-b ± sqrt(b^2 - 4ac))/(2a), substituting the values of a, b, and c, we get: r = (140 ± sqrt((-140)^2 - 4*(-100)*(-40)))/(-200).
    Calculate the solutions: We calculate the discriminant sqrt((-140)^2 - 4*(-100)*(-40)) and then find the two values for r by adding and subtracting the square root of the discriminant from -b and dividing by 2a.
    Wolfram Alpha confirms the solutions to the equation as:
    r = 1/10 (-7 - sqrt(69))
    r = 1/10 (sqrt(69) - 7) = 0.130662 = 13.0662%

  • @iyalmelan
    @iyalmelan 3 หลายเดือนก่อน +2

    the most patience professor.... thx a lot Sir, now i understand IRR

    • @MBAbullshit
      @MBAbullshit  2 หลายเดือนก่อน

      Glad you understand internal rate of return irr better now!

  • @ericlogan7704
    @ericlogan7704 9 ปีที่แล้ว +1

    Thank You sooooo much!! This was way better to understand than my class last night. Now, I don't have to be sitting there confused and lost.

    • @MBAbullshit
      @MBAbullshit  9 ปีที่แล้ว

      Eric Logan you're wellllllllcome! glad you're not confused anymore

  • @darkelfdemon5189
    @darkelfdemon5189 7 ปีที่แล้ว +1

    Easier than I thought, very well explained. You are a life saver, cheers.

    • @MBAbullshit
      @MBAbullshit  7 ปีที่แล้ว

      Glad you're still alive!

  • @juwairiyajabeen3092
    @juwairiyajabeen3092 หลายเดือนก่อน

    Now that is the kind of explanation that I didn’t think I needed. That went straight into my head.👏

  • @zerotrace000
    @zerotrace000 11 ปีที่แล้ว

    Outstanding videos. Your teaching style is amazingly thorough yet clear, concise, and articulate. I wish all professors taught the way you do. Thank you again

  • @MBAbullshit
    @MBAbullshit  11 ปีที่แล้ว

    I'm here for the difficult learners, Ritul; as I too was one in the past.

  • @MBAbullshit
    @MBAbullshit  11 ปีที่แล้ว

    @Serkan the very simple quadratic root equation will not work if the cashflows are different every year, it only works under uniform consistent cashflows

  • @yourfarooq
    @yourfarooq 5 ปีที่แล้ว +3

    Wounder full. Very simple and easy to learn. Thanks a lot and keep doing this.

    • @MBAbullshit
      @MBAbullshit  4 ปีที่แล้ว

      Glad you find it wonderful!

  • @aniket141989
    @aniket141989 11 ปีที่แล้ว +1

    You are far better than my french professor!!!

  • @AhmedMohammed-sp1rh
    @AhmedMohammed-sp1rh 8 ปีที่แล้ว +2

    man I'm a mechanical engineering student but I had to take this business subject , I was really suffering with this topic,,, but thanks to your video , you made it so much easier for me to get it, thank you so much , it really helped me out !

    • @MBAbullshit
      @MBAbullshit  8 ปีที่แล้ว +1

      glad you're not suffering as much anymore!

  • @MBAbullshit
    @MBAbullshit  13 ปีที่แล้ว

    @rodshockin The exponents show which year the cashflow comes. And secondly, which numbers that small?

  • @KelleyGrl5758
    @KelleyGrl5758 9 ปีที่แล้ว

    Why can't all professors explain things this clearly? Thanks for helping us find our way through the bullshit! :)

  • @onlyjazztoday
    @onlyjazztoday 12 ปีที่แล้ว

    Thanks man!
    I just feel that I am ready to get a CFA sertificate after such great lessons!

  • @maged779
    @maged779 10 หลายเดือนก่อน +1

    Great video, thank you.
    You can solve the equation quadratically. Pretend 1+r is x, and solve for x. You will get 2 solutions. one is impractical as a negative rate, and the other is the correct one. In this example, the solutions are 1.13 and 0.53. remember those are still 1+r. so solving for r will yield -0.47 and 0.13 (-47% and 13%). The correct answer is obviously +13%. Else, use excel's formula for IRR.

  • @houdapurple
    @houdapurple 13 ปีที่แล้ว

    thanks a million , much appreciated !! you are doing an amazing job , i'm a finance student from algeria and my professors suck big time they only give us the formulas without really explaining them .. your videos are extremely helpful

  • @Goyalaaddy8798
    @Goyalaaddy8798 ปีที่แล้ว +3

    This is Best explanation of IRR…., don’t waste time on other videos

    • @MBAbullshit
      @MBAbullshit  ปีที่แล้ว

      Glad you liked the explanation!

  • @vikramrajagopal5735
    @vikramrajagopal5735 7 ปีที่แล้ว +2

    I was wondering what this IRR even though i could calculate using excel sheet, but this video along with the previous one explains IRR in practical term.Thank you.

    • @MBAbullshit
      @MBAbullshit  7 ปีที่แล้ว

      Glad you found it practical!

  • @floraniyigena7
    @floraniyigena7 11 ปีที่แล้ว

    what would do without you.... Because of you i love finance ....
    Thanx alot ...

  • @MBAbullshit
    @MBAbullshit  12 ปีที่แล้ว

    Good luck in your exam tomorrow, Neo! There's actually a formula to 'approximate' it instead of guessing, but I don't recommend it coz it only works in "uniform" situations where the cash flow is consistent... cheers!

  • @MBAbullshit
    @MBAbullshit  11 ปีที่แล้ว

    @Karim thanks! Although for the other stuff, not anytime soon; got too many requests for different stuff, cheers

  • @saifullahsaifi5764
    @saifullahsaifi5764 7 ปีที่แล้ว +2

    Best of lecture I have ever watched regarding IRR

    • @MBAbullshit
      @MBAbullshit  7 ปีที่แล้ว

      Glad you find it the best!

  • @MBAbullshit
    @MBAbullshit  11 ปีที่แล้ว

    @Anastasis you're very welcome and glad you understand

  • @mynameisbille
    @mynameisbille 12 ปีที่แล้ว

    I have an exam tommorow on Finance and I want to take the time to thank you, because youve probably enabled me to gain an extra 20 marks.

  • @JayBLesseD__
    @JayBLesseD__ 7 ปีที่แล้ว +2

    i'm preparing for my exam and this guy is helping me a lot, thank you

    • @MBAbullshit
      @MBAbullshit  7 ปีที่แล้ว

      Hope it helped in your exam!

  • @jalwa55
    @jalwa55 11 ปีที่แล้ว +1

    brilliant man.. you definitely explain better then my Irish professor.. thanks alot

    • @MBAbullshit
      @MBAbullshit  11 ปีที่แล้ว

      Umair Hussain glad you like the explanation!

  • @ltlondon1585
    @ltlondon1585 10 ปีที่แล้ว +1

    What a great job you've done! Thanks, man... your explanations are awesome.

    • @MBAbullshit
      @MBAbullshit  10 ปีที่แล้ว

      A great thanks Mauricio Londoño Restrepo !

  • @Nineonenineone
    @Nineonenineone 8 ปีที่แล้ว +1

    Highly advice using a calculator with functions for cash flow and irr. Took me about 4 seconds to find the answer. Thanks for the video anyway, was really wondering why it was called INTERNAL!

    • @MBAbullshit
      @MBAbullshit  8 ปีที่แล้ว

      So now you know! But it's actually just my take on in...

  • @mdell-t4655
    @mdell-t4655 4 ปีที่แล้ว +4

    There’s a way you can solve part of interest rate with quadratic formula, but thanks for making this topic simpler to understand.

  • @HH-nw4gr
    @HH-nw4gr 7 ปีที่แล้ว +2

    Thank you! You're uplifting me to love this financial subject! :D

    • @MBAbullshit
      @MBAbullshit  7 ปีที่แล้ว

      Glad you feel uplifted!

  • @luizmartinssouza7867
    @luizmartinssouza7867 9 ปีที่แล้ว +1

    Very! Very clear, tks so much!!!! I suggest explaining the method by interpolation too.

    • @MBAbullshit
      @MBAbullshit  9 ปีที่แล้ว

      Luiz Martins Souza thanks too!

  • @SP-zg1go
    @SP-zg1go 5 ปีที่แล้ว +12

    Too much rubbing in second video, flow need to be little faster. Material is excellent.

  • @MBAbullshit
    @MBAbullshit  13 ปีที่แล้ว

    @MissRocknRollCatt Hi! Which equations?

  • @nathanjohnoreilly2741
    @nathanjohnoreilly2741 6 ปีที่แล้ว +1

    Gift for explaining clearly. Very helpful - thank you!

    • @MBAbullshit
      @MBAbullshit  6 ปีที่แล้ว

      Happy you find it helpful!

  • @aniket141989
    @aniket141989 11 ปีที่แล้ว

    Excellent!!!! Management made easy keep it up!!

  • @MBAbullshit
    @MBAbullshit  12 ปีที่แล้ว

    Thanks for the input in your reply to Vibes! Interesting....

  • @abdul.wellserv4311
    @abdul.wellserv4311 10 ปีที่แล้ว +2

    Your videos really helped me a lot, Thanks for sharing with us :D

    • @MBAbullshit
      @MBAbullshit  10 ปีที่แล้ว

      Abdul. wellserv happy to have shared!

  • @rajmusale2729
    @rajmusale2729 7 ปีที่แล้ว +1

    superb....
    this guy is making economics very easy...

  • @deniselynonil
    @deniselynonil 11 ปีที่แล้ว

    Thank you so much :-) im really having hard time analyzing how to calculate IRR but because of ths i understand nw. Ths s really a big help to my report .

  • @robertrantz3612
    @robertrantz3612 10 ปีที่แล้ว +3

    This helped me out a lot! Thank you very much!

    • @MBAbullshit
      @MBAbullshit  10 ปีที่แล้ว

      Robert Rantz glad it helped you!

  • @jingkunouyang8100
    @jingkunouyang8100 10 ปีที่แล้ว +1

    thanks! it is much simple to be understand than the complex explanation of the book

    • @MBAbullshit
      @MBAbullshit  10 ปีที่แล้ว

      Jingkun Ouyang glad you find it easier than your textbook!

  • @emberupneet
    @emberupneet 9 ปีที่แล้ว +2

    never gonna forget how to calculate IRR...awesome....

    • @MBAbullshit
      @MBAbullshit  9 ปีที่แล้ว +1

      +upneet kaur wow, "unforgetable" how romantic! :p

  • @MBAbullshit
    @MBAbullshit  13 ปีที่แล้ว

    Thanks mukunify and dilnawaz! good luck to ya!

  • @MBAbullshit
    @MBAbullshit  11 ปีที่แล้ว

    @Antoinette glad you find it awesome!

  • @faredbaderneh1231
    @faredbaderneh1231 9 ปีที่แล้ว

    it's very clear and it helps for better understanding. .. also appreciate if you can explain other items in shorter time

  • @TheMegakwan123
    @TheMegakwan123 9 ปีที่แล้ว +2

    You are a life saver👏🏾👏🏾

    • @MBAbullshit
      @MBAbullshit  8 ปีที่แล้ว +1

      +Kwanele Mamba glad you're still alive!

  • @MBAbullshit
    @MBAbullshit  11 ปีที่แล้ว

    @sherns glad you found it!

  • @petertonks2288
    @petertonks2288 2 ปีที่แล้ว +2

    Can you tell me how you got -1.2 (Third row of calculation @09:32)
    I know you calculated the line above but I am getting a different figure to you.
    Likewise for 1.4 and 0.09 later on in the video
    Can you do a step by step in the comments please :) Thanks

  • @rabishrestha804
    @rabishrestha804 8 ปีที่แล้ว

    your lec are simple.. great to have u in youtube

  • @investmentanalyst9980
    @investmentanalyst9980 4 ปีที่แล้ว

    Thank you so much for this. Best video I have seen so far

  • @MBAbullshit
    @MBAbullshit  12 ปีที่แล้ว

    hey Bozz, can you show your calculation?

  • @goodlife7138
    @goodlife7138 7 ปีที่แล้ว +3

    THIS IS A+. THANK YOU SO MUCH.

    • @MBAbullshit
      @MBAbullshit  7 ปีที่แล้ว

      An A+ THANKS to you too!

  • @MBAbullshit
    @MBAbullshit  11 ปีที่แล้ว

    @katy glad it's now easy for you!

  • @MBAbullshit
    @MBAbullshit  12 ปีที่แล้ว

    yes you can, but a financial calculator can only be used if the cash flows are the same and consistent.. cheers!

  • @josephabraham5148
    @josephabraham5148 12 ปีที่แล้ว

    I had stand in our gaps, Allelulia! God bless ya

  • @joeysalomon4137
    @joeysalomon4137 3 ปีที่แล้ว

    thank you. i subscribed to pay for your professional service. please keep it coming.

    • @MBAbullshit
      @MBAbullshit  3 ปีที่แล้ว

      Thanks for subscribing!

  • @MBAbullshit
    @MBAbullshit  11 ปีที่แล้ว

    @Lesle hope ur headache is cured now!

  • @elisebillington3710
    @elisebillington3710 10 ปีที่แล้ว

    Best explanation ever!!! Thank you so much MBAbullshit! I was trying to figure this out for my exam tomorrow and was thinking omg this is bull!!! then ur you tube example came up, thank you so much, i get it now! :)

  • @wollstonecraft51
    @wollstonecraft51 10 ปีที่แล้ว

    Thanks for the easy step by step explanation, very much helpful

    • @MBAbullshit
      @MBAbullshit  10 ปีที่แล้ว

      wollstonecraft51 glad you find it helpful, cheers

  • @absmith
    @absmith 12 ปีที่แล้ว

    OMG, this was an awesome lesson. Thank you so very much and to think I could have turned it away because of the bad word used.

  • @89naja
    @89naja 10 ปีที่แล้ว

    This is super easy and useful, but unfortunately not the formula/equation my professor's asking for. Still, THANK YOU, for other videos, you're superb!

  • @MBAbullshit
    @MBAbullshit  13 ปีที่แล้ว

    @bagio69 I don't know how to use your specific calculator but in mine, yes, I press yX first and then do the -1 or -2. Cheers!

  • @graceli9671
    @graceli9671 9 ปีที่แล้ว +1

    Very clear and helpful, thank you!

  • @vincentlim9031
    @vincentlim9031 10 ปีที่แล้ว +1

    this helped me alot.... love ya man

    • @MBAbullshit
      @MBAbullshit  10 ปีที่แล้ว +1

      Ivan Lim glad it helped, love ya guys too!

  • @saraqazi5107
    @saraqazi5107 4 ปีที่แล้ว

    I am so glad I found you guys!

  • @MBAbullshit
    @MBAbullshit  11 ปีที่แล้ว

    @Kaychaos glad you find it easy now :)

  • @anastasistsagaris1259
    @anastasistsagaris1259 11 ปีที่แล้ว

    Thank you so much! now I understand how to calculate IRR!

  • @easteagle73
    @easteagle73 5 ปีที่แล้ว +2

    u r fantastic . so easy and understandable instructing

    • @MBAbullshit
      @MBAbullshit  5 ปีที่แล้ว

      A fantastic thanks to you!

  • @sharanbc
    @sharanbc 9 ปีที่แล้ว +1

    This is helped me so much for better understanding the concepts

    • @MBAbullshit
      @MBAbullshit  9 ปีที่แล้ว

      Sharan BC Glad you understand it better!

  • @maxman4864
    @maxman4864 11 ปีที่แล้ว

    my professor must just be terrible, this is so simple! Thanks!

  • @moniquevandermerwe2776
    @moniquevandermerwe2776 8 ปีที่แล้ว

    Excellent explanation! Although, my calculator does most of the calculations but this helped me to understand the underlining process. I am looking forward to watching how you calculate the NPV with a formula. I am struggling a bit with what formula to use in order to compare two lease agreements. Do you have anything that I can look at for this? Maybe I can email you the questions containing Lease A and Lease B details?

  • @franceswilliams2421
    @franceswilliams2421 2 ปีที่แล้ว +1

    Thank you so much, really clear explanation, feeling confident now 👍🏻

  • @manishkarki2585
    @manishkarki2585 6 ปีที่แล้ว +3

    Its a long one, for me..
    Here's.
    Just find NPV of cash flow. One from positive amount and one from negative amount. With high difference in hitting IRR%. Then again Interpolate the values.
    IRR= LR + [NPV(LR)/NPV (LR)- NPV (HR) { look here the npv from HR was negative. It will add to the npv lr} ] ×(HR - LR)
    and you get the little or more difference in answer. But take that value of irr say 25%. Just go little down to 22% for LR and go 27 for HR. And find NPV at those values. And do it again.
    You will get. 99% correct answer.
    (Problem with this was the direction. We dont know where to check irr. Get the direction first. Then you will catchup speed).
    If the cost is given. Take the reference from it. And see how much you have to decrease from it to get near the zero value.

  • @margaritanavarro6491
    @margaritanavarro6491 4 ปีที่แล้ว +1

    If you are already given the rate of return would I use the same technique to calculate IRR?

  • @MBAbullshit
    @MBAbullshit  13 ปีที่แล้ว

    @tazer1989 Hey Tazer. Putting negative sign in an exponent is just a shortcut to the conventional way where they put the positive exponent in a denominator. So the only difference is that it's faster. Cheers!

  • @leslieflores5174
    @leslieflores5174 9 ปีที่แล้ว

    Now I understand it so much better thanks a lot! Can you explain it by calculating IRR with a financial calculator?

  • @gigi8692
    @gigi8692 11 ปีที่แล้ว +2

    Thanks! It took me 1 sem and I still couldn't understand this concept. Our finals is tomorrow and I finally get it. I hope I pass.

    • @MBAbullshit
      @MBAbullshit  11 ปีที่แล้ว +1

      Maggie G good luck in your exam tomorrow!

  • @smabrarjahin7258
    @smabrarjahin7258 9 ปีที่แล้ว +1

    Thank you very much.. this was easy to understand..

  • @rocknrolllady8130
    @rocknrolllady8130 10 ปีที่แล้ว

    Unfortunately it did not work out for my calculation given by the professor.
    Is there any difference if it is not an investment but a loan?!
    We have to calculate it with fluctuating interests; so does the IRR fluctuate as well?

  • @christinamoody4988
    @christinamoody4988 7 ปีที่แล้ว +1

    Thanks for all of your videos, they are the best around because even I can understand them (and I haven't done this kind of maths since I left school which was over 30 years ago!)!!!
    Can you explain how you reached the answer "-1.2=0" when r=14% (i.e. Can you break down the calculation because i can't get to that number please?)
    Thank so much!

  • @loveinramessur8683
    @loveinramessur8683 7 ปีที่แล้ว +2

    How did you get -1.2 in the left part ,@ 9:34 i've got 19.8
    Need help
    Am stuck🙏

  • @bilal008
    @bilal008 12 ปีที่แล้ว

    Thanks alot man.. Really appreciate your hard work.

  • @jessicaapassier7297
    @jessicaapassier7297 2 ปีที่แล้ว +1

    Excellent thank you so much. I'm finally getting it. 😊

  • @Jordan-tx4xb
    @Jordan-tx4xb 2 ปีที่แล้ว +2

    Does this mean that it'll take 2 years to breakeven the cost of $100?

  • @kristinejacalne8439
    @kristinejacalne8439 9 ปีที่แล้ว +2

    The video is really helpful but the shorter the video, the more attractive it would be. There are times that you give too much explanation like obviously, zero is not equal to 1.2 and the algebra thing. Anyway, your topic is great :) I'm sure I'm gonna need it in my course.

  • @AlexanderWDI
    @AlexanderWDI 11 ปีที่แล้ว +1

    I wish my professors would explain these concepts like this.
    I agree that you have to guess and check to find the rate. Very time consuming especially during an exam. And when not aloud to use electronic devices that do it for you (Like what every professional does).

    • @MBAbullshit
      @MBAbullshit  11 ปีที่แล้ว

      @Alexander thanks and have a great day!

  • @tazer1989
    @tazer1989 13 ปีที่แล้ว

    your explainations are always great.. I hate accounts but it feels nice n easy to learn from your videos... I want to ask u one fing. in the rest of the vids or on net, I have seen only you putting the negative signs in the years on the PV formula... does it make any difference? thank you so much... :)

  • @MBAbullshit
    @MBAbullshit  13 ปีที่แล้ว

    @choddopice Hi, as of now, nope, sorry. Maybe in the future, yet. I'm actually very good at explaining sensitivity analysis, but I don't have time right now. The videos look simple to make but they actually take a VERY long time to think of how to explain them in a simple way. Cheers.

  • @MBAbullshit
    @MBAbullshit  11 ปีที่แล้ว

    @ZeroTrace Thanks too and you're welcome again

  • @MBAbullshit
    @MBAbullshit  11 ปีที่แล้ว

    @DMDMD hey man, I'm hear for the slow learners like myself in the past, cheers

  • @MBAbullshit
    @MBAbullshit  11 ปีที่แล้ว

    @liee superrrrr thank you and God bless you too

  • @sameenajahangir
    @sameenajahangir 11 ปีที่แล้ว

    awesome...gr8 wrk....woow
    made simple

  • @yoyouno
    @yoyouno 11 ปีที่แล้ว

    yo, this is bullshit for real. thanks a lot man...I feel dumb, but I'll feel smart getting those marks. you're too cool for doing this man...thanks again.

  • @YxZMyself
    @YxZMyself 9 ปีที่แล้ว +1

    You're the absolute boss

    • @MBAbullshit
      @MBAbullshit  8 ปีที่แล้ว

      +Olass Gafaru thanks, boss!

  • @MBAbullshit
    @MBAbullshit  11 ปีที่แล้ว

    @Abhiraj haha I'm glad you kinda like math now

  • @Sajjad1970S
    @Sajjad1970S 5 ปีที่แล้ว +1

    Thank You so much for this, this was very helpful.

    • @MBAbullshit
      @MBAbullshit  5 ปีที่แล้ว

      Welcome, and glad you found it helpful!

  • @chremefraiche12
    @chremefraiche12 12 ปีที่แล้ว

    This guy should get the nobel peace prize for bringing peace between students and their books

  • @alexlok8406
    @alexlok8406 9 ปีที่แล้ว +1

    how do you type all the negative years onto the calculator?

    • @MBAbullshit
      @MBAbullshit  8 ปีที่แล้ว

      +alex lokk you mean a negative exponent? Usually 10 raised to the negative 2 is = 10^-2