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

ACCA CBE spreadsheet help, tips, and guidance for APM students. f you're sitting APM (Advanced Performance Management), make sure you know how to use the NPV and MIRR functions in the spreadsheet tool--this will save you a lot of time. This video takes you through the technique step-by-step in CBE, using Question Metis from June 2012 as an example.
Download the question here: tinyurl.com/2x...
*****
Steve Willis ACCA
www.stevewillistraining.com
How to pass ACCA exams
For more help with NPV, IRR, and MIRR, check out Open Tuition: • ACCA P5 Discounted Cas...
Find many other helpful videos on James Wright ACCA / jameswrightacca

[@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!

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

[@karenmurray4608]

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

[@SteveWillisACCA]

Glad it helped--good luck on Friday!

[@sashilall739]

Excellent presentation. Thank you.

[@SteveWillisACCA]

Glad it was helpful!

[@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.

[@qiongwang4856]

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

[@muhumuzabernadette1122]

Thank you

[@SteveWillisACCA]

You're welcome

[@leesheridan5685]

Love these videos. 👍

[@SteveWillisACCA]

Glad to hear it!

[@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.

[@mohsinalikhan4791]

NPV. 55,475 also calculated in exam ki

[@SteveWillisACCA]

Yes, that is the correct answer.

[@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.

[@shikhasankhla6089]

Sir do you have any lectures for AFM?

[@SteveWillisACCA]

I'm sorry, I don't.

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