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

[@SteveWillisACCA]

🚀Hey guys, my APM Revision Course is live! Check it out: rb.gy/livnsu 🚀

[@rhyspowell9426]

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!

[@SteveWillisACCA]

Glad it helped :)

[@nayangupta3890]

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 KZbin videos for my Fm, pm examination that helped me. Thank you so much 😊

[@SteveWillisACCA]

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

[@allyalexander5725]

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

[@SteveWillisACCA]

Glad it was helpful!

[@karenmurray4608]

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

[@SteveWillisACCA]

Glad it helped--good luck on Friday!

[@AyoubAmellal-ys6dj]

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.

[@SteveWillisACCA]

Yes, absolutely

[@sashilall739]

Excellent presentation. Thank you.

[@SteveWillisACCA]

Glad it was helpful!

[@qiongwang4856]

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

[@sunitakhan3050]

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?

[@SteveWillisACCA]

Great question! Yes, it works fine.

[@leesheridan5685]

Love these videos. 👍

[@SteveWillisACCA]

Glad to hear it!

[@shikhasankhla6089]

Sir do you have any lectures for AFM?

[@SteveWillisACCA]

I'm sorry, I don't.

[@Ammar-nb7sm]

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

[@SteveWillisACCA]

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]

Oh Okay, thank you very much

[@SteveWillisACCA]

my pleasure.

[@maykz2127]

@@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]

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

[@SteveWillisACCA]

Sorry about that! Link fixed!

[@calvinpoon1988]

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

[@Hania2323]

Are those formulas allowed on the exam platform?

[@SteveWillisACCA]

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

[@samuellakoroma446]

Thank you

[@SteveWillisACCA]

You're welcome

[@mohsinalikhan4791]

NPV. 55,475 also calculated in exam ki

[@SteveWillisACCA]

Yes, that is the correct answer.

[@muhumuzabernadette1122]

Thank you

[@SteveWillisACCA]

You're welcome