Forums › Ask ACCA Tutor Forums › Ask the Tutor ACCA AFM Exams › Cbe tips
- This topic has 5 replies, 2 voices, and was last updated 2 years ago by John Moffat.
- AuthorPosts
- August 28, 2022 at 6:12 am #664489
Hi sir,I just wanted to how relevant it is to use the excel in the exam,I do understand it will be necessary for npv,apv,debt capacity.For these using calculator to calculate inflation or other anomalies and plotting the figures in excel cell and towards the end use npv,irr,mirr functions would gain full marks?With regards to business valuation, hedging since tabular calculation is not necessary required at least how its done in the bpp kit (unless netting matrix comes),is it okay to do the working in the word processor itself to save time?Excel is not my strong suit.
August 28, 2022 at 8:46 am #664499The marker is able to se what functions you have used in the spreadsheet and assuming that you have used them correctly you get full marks.
The software presents you with either the spreadsheet or the word processor for each part of the question, so it is not usually your choice as to which to use.
August 28, 2022 at 10:23 am #664507Sir my question is, calculating figures for example sales revenue inflated using a physical calculator and plotting them on the excel instead of using functions would gain full marks? And also sir could you clarify on your second point please?in the cbe platform for example for a hedging question or valuation qs both response options are given, just using the word process would gain full marks?since the workings does not require tabular calculations.
August 28, 2022 at 3:24 pm #664521Yes. Using a calculator would still get you the full marks (although it does take longer).
If you are given the choice (which is not usual – have you practiced using the exams on the ACCA practice platform?) then it does not matter which you use.
August 28, 2022 at 9:12 pm #664545Yes sir,I have went thru cbe practice platform for example,the specimen paper, response option of both spreadsheet and word processor is given for every question, system does not appear to segregate based on sections of question like u suggested , its basically a question and exhibits given along with response options of both word processor or spreadsheet or even sometimes the bsop calculator given (in the case of blank practice).My question is would it matter if u do not utilize excel for section b questions,mainly hedging or/and business valuation comes?
August 29, 2022 at 7:20 am #664563As I wrote in my previous reply, if you have the choice then it does not matter which you use!!
- AuthorPosts
- The topic ‘Cbe tips’ is closed to new replies.