NPV made EASY | ACCA FM / F9 | Question Vyxyn | Spreadsheet help

[@dripside2102]

its really unfair ACCA doesn't provide these technical knowlege, we self study studens are left to hang dry. but thank you Steve this is helpful

[@SteveWillisACCA]

Glad it was helpful!

[@user-ku4hj7ht6q]

Steve willis. Where were you all the time? Man you are a Godsend and may God bless you. Thank you so much for this!!!

[@SteveWillisACCA]

Glad you found it helpful--tell your colleagues :)

[@Champingcom]

So helpful.You are such a blessing for ACCA students.

[@SteveWillisACCA]

Glad you think so!

[@amirahkomaruddin5125]

very helpful and simple way for acca students❤️❤️

[@SteveWillisACCA]

Glad you think so! Good luck this week.

[@requiem4floyd]

Sir just one question why is inflation fixed for all the years in variable cost column?

[@vv-hz4hb]

how are you doing the dragging bit, any keys to press after you drag? 4:11

[@SteveWillisACCA]

To select a range of cells you drag from the little black box in the corner of the cell--it's tricky to do sometimes.

[@vv-hz4hb]

@@SteveWillisACCA hey Steve. Thanks for the reply. I just wanted to let you know that both the NPV and the IRR function weren't working in F9 on 10th June..which is weird since you said they would and the webinar by ACCA also told the same..any info on that?

[@SteveWillisACCA]

@@vv-hz4hb I suggest you make an immediate complaint about that. It works in the practice platform and the examiner's reports say to use them.

[@vv-hz4hb]

@@SteveWillisACCA I firstly thought it was just me but the person next to me also said the same and so did my friend. Btw where do I make this compliant? Bc they gave us a review for both in paper format after we exited are exam and on the website two days later too. I filled the compliant in on those

[@SteveWillisACCA]

www.accaglobal.com/hk/en/footer-toolbar/contact-us/unhappy.html you should also message your local ACCA representative. Where did you take the exam?

[@semalkhan14]

at 3:58 i was asking that question , that can we use year numbers as power ... because spreadsheet gives us alot of flexibility.. you already answer it so I don't need to ask 🙂🙂

[@SteveWillisACCA]

Glad it you found it useful :)

[@semalkhan14]

9:03 its much easier to write like this as we are writing in scientific calculator that is 1.1^-(year cells)

[@areejatta3338]

thankyouu so much, i didn't know about this relative formula thing, it took me forever to do calculations in spreadsheet, saw it merely 10 days before exam, can't thank youu enough :)

[@SteveWillisACCA]

My pleasure :) Glad the video helped

[@amalfaize5930]

I have a doubt ,can I assume numbers for sales figure and variable cost in the format by doing the correct working for each of the item

[@SteveWillisACCA]

Hi, I don't follow your question: if you do the correct working the numbers, they aren't assumed--they are calculated. 'Assumed' is when you just plug a random number into a cell, for example "labour cost per unit: $10 (assumed)" you won't get any credit for that assumed figure, but if you use it later in your answer, e.g. total cost per unit, it will be assumed correct and you can get full credit for any working you do with it.

[@amalfaize5930]

for instance ,incomputstion of npv the marks are for all the working right ? So for instance,let’s consider the scenario where ,Sales -Variable =contribution ,So whst i intend to do is In the format. Yr. 1. 2. 3 Sales (w.N1). (W.N1) Variable cost (wn2). (W.n2) Profit (assumed) 100. 200 300 In working Note 1 and 2 I calculated all the values for sales and variable cost correctly ,but instead of carrying forward in NPV format ,I just put a note in it,then i assumed the Profit figure , then Calculated Tax on that Profit Figure Assumed

[@bellamohd4010]

Always comeback for your video for revision but can you do Copper Co next on the joint probabilities ? Thank you, it will be so helpful !

[@SteveWillisACCA]

Great suggestion! That will be next for FM.

[@bellamohd4010]

@@SteveWillisACCA great ! looking forward for it !

[@giseleteghen4247]

I don’t need to use calculator again in section c wow am so happy

[@SteveWillisACCA]

Actually, you might! If you get the word processor tool, and they ask you to "assess" performance, you will need to use your calculator, and show your workings.

[@mohafzal2790]

Wow, amazing video

[@SteveWillisACCA]

Thank you very much!

[@mohafzal2790]

ACCA Exam Help I’m attempting AFM CBE, any tips for calculating MM2 formula on spreadsheet?

[@SteveWillisACCA]

@@mohafzal2790 great question let me add that video shortly

[@mohafzal2790]

ACCA Exam Help thank you, I appreciate it, we have remote CBE this September and and we aren’t allowed a scrap paper, I learnt how to do MIRR,IRR, NPV formulas on spreadsheet but I’ve come unstuck at MM2 formula for calculating ungeared cost of equity

[@deckpheno]

Can we use npv formula directly rather than writing DF of each year?

[@SteveWillisACCA]

Yes you can :)

[@Chappati]

Hi Sir, are we allowed to use the NPV and IRR formulas in the exam?

[@SteveWillisACCA]

Yes, you can

[@saireddy4460]

Where I do working notes in CBE format exam

[@SteveWillisACCA]

Applied Skills exam: you get either a spreadsheet or a word processor for your response. You don't pick. So, do your working in what they give you. gIf you are doing ratios, and they give you a word processor, make a table with 4 columns "RATIO, WORKING, RESULT, DISCUSSION" and show your working. If you are doing the same thing in spreadsheet, the marker looks in your cell to see what you are doing. If you are doing a quick working e.g. "sales increased 20% (120/100) this is a good sign because..." show the working as i did, in parenthesis.

[@SteveWillisACCA]

Strategic Professional Exams: you can use either the spreadsheet or WP tool, it's your choice--so you can do any working in the spreadsheet and reference it in the word processor.

[@bikashkc9023]

can you explain me how did you calculate that the variable cost per unit will have a 80% chance that it will be 12 or lower?

[@SteveWillisACCA]

45% that it will be $10.80, 35% that it will be $12.00, so 45% + 35%=80% that it will be $12 OR $10.8 (12 or lower)

[@amberwalker3544]

Hi - the question states 3.5% inflation for sales and 4% inflation for variable costs, so how comes in the VC calc you used inflation which was only 3.5%? Thansk

[@SteveWillisACCA]

In the original question, June 2017, the inflation rates are the other way around--sales 4%, VC 3.5%

[@giseleteghen4247]

Wow thanks so much for this

[@SteveWillisACCA]

Any time!

[@unaismuhammed7332]

Useful👍👍

[@SteveWillisACCA]

Thanks a lot

[@priyankajaiswal7756]

What if I don’t represent my cash outflow with negative sign (-) and still I do proper calculation and my answer is correct will they deduct marks for it?

[@SteveWillisACCA]

You will get full credit if you row is labeled and the marker can follow what your are doing

[@ghostof3am]

How do we know that there is a 80% chance of it being 12?

[@SteveWillisACCA]

Hi there, 80% chance of 12 or lower. The high option is 20%, so the other 2 options come to 80% in total. 1-0.2=0.8

[@shawnsmith8487]

Are you related to Bruce Willis 😅

[@SteveWillisACCA]

Hehehe nope :)