- This topic has 3 replies, 2 voices, and was last updated 4 years ago by
.
- Posts
Dear John,
could you please advise me on how to proceed with formulas in the exam tajing into account this excel in the C task that is not excel at all. The study text said to use IRR formula in excel, for instance. But it doesn’t work in this half-excel.
Solving tasks at home I used a normal excel and it was convenient to calculate IRR, inflate costs, sales, ect. But in this blank for the answer these functions don’t work at all.
Thank you in advance!
You should be able to do the things you are mentioning in the exam spreadsheet.
There are two links on the ACCA website that might help you.
The first one goes through the basic functions of the spreadsheet (although strangely does not mention the NPV and IRR functions).
https://www.accaglobal.com/us/en/student/exam-support-resources/further-learning-support.html
The NPV and IRR functions are available, and if you go to the link below and then choose “Strategic Professional CBE Platform Guidance Document” you will get a booklet which lists all the functions available, and how to use them (although it is only the NPV and IRR functions that are relevant for Paper FM).
I hope that helps 🙂
Thank you, John!
I have studied the ACCA materials you sent me. But still, when I try to use this formula as described by ACCA on the CBE practice platform, I don’t get the right answer. I don’t know what I am doing wrong (in normal excel I’ve successfully used the formula many times).
Do you know – anyone else complaining about this issue?
It did work for me when I tried it.
To be safe make sure you can calculate the NPV in the normal way – it doesn’t take much longer. The time taken and the marks are all for arriving at the net cash flows – the discounting is only likely to be 1 mark.
For IRR’s obviously the formula does make it faster, but again just in case for formula does not work in the exam then make sure you can do it the normal way (and IRR’s are not so often in Section C).
- You must be logged in to reply to this topic.