Paper 1 - Audit Trail

Discussion in 'CP2' started by Viki2010, Apr 13, 2019.

  1. Viki2010

    Viki2010 Member

    "avoidance of excessive reproduction of Excel formulae"

    does this mean that we should always express the mathematical formulae in mathematical language or in words?

    but also make note on the excel functions used?
     
  2. Dar_Shan0209

    Dar_Shan0209 Ton up Member

    Hello,

    According to me, the following is a "Not to do" in the audit trail:

    The relavant annuity factors have been derived from the "Parameters" Worksheet using VLOOKUP($C2, Parameters!A3:C3, 3, FALSE).

    This one i believe is what is required:
    The relavant annuity factors have been derived from the "Parameters" Worksheet using the "VLOOKUP" function.

    This is because a senior actuary and a fellow colleague would have the background in Excel so you shouldn't go in much details in the excel formulae but HOW you arrived at the calculations so that if they need to change anything, they will know how this has been done.

    I hope you get my point.
     
    pyuille_1609 likes this.
  3. Viki2010

    Viki2010 Member

    Hi, thank you. This makes perfect sense. However, if we are in the METHODOLOGY section, we should be describing all formulae exactly, correct?
     
  4. Dar_Shan0209

    Dar_Shan0209 Ton up Member

    Hello, yeah, you just need what has been done. Include any mathematical formulae/Excel function you used.
     
  5. David Hopkins

    David Hopkins Member

    A good way to approach this is to pretend you're explaining your calculations to another student who is sitting next to you. You would describe it in WORDS, not just read out the Excel formula. So, you might say something like "The High Earners (Males) and (Females) cells use the COUNTIFS function to count the number of employees of each sex whose income exceeds the threshold for the top rate of tax".
     
    pyuille_1609 likes this.
  6. pyuille_1609

    pyuille_1609 Member

    Indeed, we ought to avoid listing every single detail/input in our formulae.. as @Dar_Shan0209 has rightly indicated.... and as Mr @David Hopkins has also noted... describe calculations in words as much as possible...

    I agree that this might be confusing since a LOT of the sample solutions have shown intricate formulae.... these might have perhaps been more present in the "older" past paper solutions.... HOWEVER, I think it depends on the "complication" of the formula altogether... so it may be wise to try to avoid having to use 100 words to explain a formula/methodology when you can simply use an algorithm (perhaps already provided in the additional guidance sheet) to describe it!! (by the way, do we still get additional guidance sheets?)
     
  7. Viki2010

    Viki2010 Member

    I don't recalling getting the guidance sheets in Sept 2018 sitting.
     
  8. pyuille_1609

    pyuille_1609 Member

    Me either that's why I asked.
     
  9. Viki2010

    Viki2010 Member

    I prefer papers without guidance - means these are less complex? :)
     
  10. pyuille_1609

    pyuille_1609 Member

    Perhaps, but not necessarily true....
     

Share This Page