How to calculate MIRR and NPV, for ACCA APM students | How to Pass ACCA APM | Spreadsheet help

Поділитися
Вставка
  • Опубліковано 2 січ 2025

КОМЕНТАРІ • 35

  • @rhyspowell9426
    @rhyspowell9426 2 роки тому +5

    This has just blown my mind.
    I would have spent ages on those formulas and to know you can do a function and have it calculated for you is amazing!

  • @nayangupta3890
    @nayangupta3890 3 роки тому +10

    Sir i like your way of teaching. I am glad to tell you that my Acca status is now 9/13. I used to watch your UA-cam videos for my Fm, pm examination that helped me.
    Thank you so much 😊

    • @SteveWillisACCA
      @SteveWillisACCA  3 роки тому +3

      Nayan, excellent you are moving forward :) Glad the videos are helpful :)

  • @allyalexander5725
    @allyalexander5725 3 роки тому +3

    Very helpful i was actually going through this question earlier today ..thanks for the clarity

  • @karenmurray4608
    @karenmurray4608 2 роки тому +1

    Thank you for this. I was going over this area. It is really helpful.

  • @sashilall739
    @sashilall739 2 роки тому +1

    Excellent presentation. Thank you.

  • @leesheridan5685
    @leesheridan5685 3 роки тому +1

    Love these videos. 👍

  • @qiongwang4856
    @qiongwang4856 3 роки тому

    Very useful thanks Steve, this is in syllabus but Kaplan exam kit doesn’t have any q relates to mirr

  • @AyoubAmellal-ys6dj
    @AyoubAmellal-ys6dj 7 місяців тому +1

    hello, thank you for the amazing video. I was just wondering if we are still able to use these functions when sitting the exam? I understand this video is 3 years old. I was shocked to see these formulas I usually take so much time working them out manually.

  • @sunitakhan3050
    @sunitakhan3050 2 роки тому +3

    One question, if it was a non conventional project and there was a further outflow after year o, would computing mirr like this still work?

  • @shikhasankhla6089
    @shikhasankhla6089 Рік тому +1

    Sir do you have any lectures for AFM?

  • @samuellakoroma446
    @samuellakoroma446 3 роки тому +1

    Thank you

  • @Hania2323
    @Hania2323 3 роки тому +1

    Are those formulas allowed on the exam platform?

    • @SteveWillisACCA
      @SteveWillisACCA  3 роки тому +2

      Yes, all those functions work fine and will save you a lot of time.

  • @Ammar-nb7sm
    @Ammar-nb7sm 2 роки тому +1

    Sir, why didn't we take interest as a cash flow along with as we started with PBIT?

    • @SteveWillisACCA
      @SteveWillisACCA  2 роки тому +1

      Hi there--interest is the finance cost and the internet rate is included in the WACC, so it we deduct the interest payment, and then discount the cash flow, we'd be double counting

    • @Ammar-nb7sm
      @Ammar-nb7sm 2 роки тому +1

      Oh Okay, thank you very much

    • @SteveWillisACCA
      @SteveWillisACCA  2 роки тому +1

      my pleasure.

    • @maykz2127
      @maykz2127 4 місяці тому

      @@SteveWillisACCA Hello Sir. Thank you for the video! May I ask that I think that in NPV cancellation we have to first deduct interest expense (8.4%) and only after that we have to apply 30% tax. You don do that. Will help to understand why? That interest expense is a part of the project cost right? We would not to have these int. expense if we do not launch the project

  • @calvinpoon1988
    @calvinpoon1988 7 місяців тому

    Hi, Sir
    The question download link is not the same question with june 2012, may you check?

    • @SteveWillisACCA
      @SteveWillisACCA  7 місяців тому +1

      Sorry about that! Link fixed!

    • @calvinpoon1988
      @calvinpoon1988 7 місяців тому +1

      @@SteveWillisACCA Thanks for your fast action, really appreciate it. Thanks Sir.

  • @mohsinalikhan4791
    @mohsinalikhan4791 3 роки тому +2

    NPV. 55,475 also calculated in exam ki

  • @muhumuzabernadette1122
    @muhumuzabernadette1122 Рік тому +1

    Thank you