T
Trevor
Member
Hi,
I found the April 2021 paper particularly challenging, given the complexity of the modelling requirements. This paper had flagged up two major questions I have:
1. Is it necessary to build the Excel model exactly in the same order as the questions asked?
For example, part(iv) asked us to model the cumulative battery charge level, allowing for increase or decreases calculated in the previous parts.
To do this, I needed to understand (and visualise) the entire process. So I modelled the source of electricity from:
In this process, I answered the next question (1 part(v) ) without realizing it, asking for the amount of electricity purchased.
Do I have to duplicate another column just to show the result for part(v) specifically?
This will be clear to the examiner, but it doesn't make sense when anyone reviews the model - what is this extra column for?
Reading the model solution, I see how they completed part(iv) without first doing part(v). However I find it difficult to follow their model although it is technically correct, I find my version more intuitive.
There are other instances where I built the model independently, without referring to the guide in question 1, to arrive to the final result asked for in the "Background" document (ie: what the client asked for).
Will I be penalised for not following the instructions exactly, even if my model contained everything asked for in the guide?
2. NPV & IRR calculation
In most past paper questions, the model solutions calculate NPV and IRR using the first principles - iteratively calculate: NPV[t] = CF[t] + NPV[t+1]/(1+r).
I know the existence of the NPV() and IRR() function in Excel, but I thought we are not allowed to use them in CP2 exams.
Part 1(viii) and (ix) awards 6 marks in total for the NPV and IRR calculation. I thought NPV() and IRR() formulas are forbidden (it won't be worth 6 marks just to type the formula).
In fact, part (ix) quotes "...by determining the discount rate that equates the net present value...". I thought they are expecting the use of Goal-Seek including checks for it to be worth 3 marks.
Therefore I went through the full process of re-projecting the NPV with a different dummy rate & build the goal seek checks. This costed me a lot of time, which affected the quality of my audit trail.
In general, is there any rule specifically forbids us to use the NPV() and IRR() function?
If allowed, is it okay to mention in the paper 2 summary:
"The net present value of the cashflow is calculated" without stating the calculation formula?
3. Use of standard Microsoft Office functions
We are told not to use any functions only available in Microsoft Office 2013 and after.
Is there a complete list anywhere stating which functions falls under this category?
I can find the new function list for each Excel release from the official documentation, but I might miss out some versions that I am not aware of.
A few examples I used in CP2 practices:
Thanks,
Trevor
I found the April 2021 paper particularly challenging, given the complexity of the modelling requirements. This paper had flagged up two major questions I have:
1. Is it necessary to build the Excel model exactly in the same order as the questions asked?
For example, part(iv) asked us to model the cumulative battery charge level, allowing for increase or decreases calculated in the previous parts.
To do this, I needed to understand (and visualise) the entire process. So I modelled the source of electricity from:
- Generated from solar
- From battery
- Purchased from provider,
In this process, I answered the next question (1 part(v) ) without realizing it, asking for the amount of electricity purchased.
Do I have to duplicate another column just to show the result for part(v) specifically?
This will be clear to the examiner, but it doesn't make sense when anyone reviews the model - what is this extra column for?
Reading the model solution, I see how they completed part(iv) without first doing part(v). However I find it difficult to follow their model although it is technically correct, I find my version more intuitive.
There are other instances where I built the model independently, without referring to the guide in question 1, to arrive to the final result asked for in the "Background" document (ie: what the client asked for).
Will I be penalised for not following the instructions exactly, even if my model contained everything asked for in the guide?
2. NPV & IRR calculation
In most past paper questions, the model solutions calculate NPV and IRR using the first principles - iteratively calculate: NPV[t] = CF[t] + NPV[t+1]/(1+r).
I know the existence of the NPV() and IRR() function in Excel, but I thought we are not allowed to use them in CP2 exams.
Part 1(viii) and (ix) awards 6 marks in total for the NPV and IRR calculation. I thought NPV() and IRR() formulas are forbidden (it won't be worth 6 marks just to type the formula).
In fact, part (ix) quotes "...by determining the discount rate that equates the net present value...". I thought they are expecting the use of Goal-Seek including checks for it to be worth 3 marks.
Therefore I went through the full process of re-projecting the NPV with a different dummy rate & build the goal seek checks. This costed me a lot of time, which affected the quality of my audit trail.
In general, is there any rule specifically forbids us to use the NPV() and IRR() function?
If allowed, is it okay to mention in the paper 2 summary:
"The net present value of the cashflow is calculated" without stating the calculation formula?
3. Use of standard Microsoft Office functions
We are told not to use any functions only available in Microsoft Office 2013 and after.
Is there a complete list anywhere stating which functions falls under this category?
I can find the new function list for each Excel release from the official documentation, but I might miss out some versions that I am not aware of.
A few examples I used in CP2 practices:
- DATEDIF() - Not included in the suggestion in Excel, but documented in Microsoft webpage.
- VLOOKUP(value,table,column, TRUE) - I think this is a very efficient way to find values that fall within an interval (non-exact match). However this is not commonly done in practice. Is this considered non-standard?
Thanks,
Trevor