Welcome to CP2 Documentation: Mastering the Audit Trail

Hello there! If you’re preparing for the CP2 Modelling Practice exam, you already know that building a great spreadsheet is only half the battle. The other half—and often the part where students lose the most marks—is the Audit Trail.

In this guide, we are focusing on one specific, crucial requirement: creating a document that a Senior Actuary can follow to sign off on your work, and a fellow student can use to fix or update your model. Think of it as writing a high-quality recipe; if you leave out a step or an ingredient, the next person’s cake won't rise!

Don’t worry if this seems daunting. We’re going to break it down into simple, manageable pieces.

What is an Audit Trail?

An audit trail is a step-by-step written record of what you did in your model, how you did it, and—most importantly—why you did it.

The IFoA examiners are looking for two specific perspectives:

1. The Senior Actuary: This person is busy. They want to see the "big picture." They need to be sure your methodology is sound, your assumptions are reasonable, and the results make sense. They aren't going to check every single formula, but they need to trust the logic.

2. The Fellow Student (Peer): This person is your "technical replacement." If you went on holiday tomorrow, could they open your Excel file and your audit trail and understand exactly which cell to change if the interest rate changed? They need the "nitty-gritty" details.

The Core Components of a Clear Audit Trail

To satisfy both the senior actuary and your peer, your documentation should follow a logical flow. A good way to remember the essential sections is the mnemonic D.A.M.R.C.:

1. Data (and Data Corrections)
Explain what data you were given. Did you have to clean it? For example, if you found a negative age in a list of policyholders, did you delete that row or replace it with an average?
Example: "The raw data contained 500 records. Three records were excluded because the 'Date of Birth' field was empty."

2. Assumptions
Every model relies on assumptions. You must state what they are and why they were chosen. Some will be given in the exam paper, and some you might have to decide yourself.
Quick Tip: If you assume a constant inflation rate of 2%, explain that this was provided in the project brief.

3. Methodology (The "How-To" Guide)
This is the heart of your audit trail. You should describe the steps you took in Excel. Don't just say "I calculated the premium." Say "The premium was calculated in Column G by multiplying the sum assured (Column E) by the rate (Column F)."

4. Results
Provide a summary of the final output. Use tables or short descriptions. This allows the senior actuary to see the "answer" without hunting through your spreadsheet.

5. Checks and Controls
This is where you prove your model is reliable. Did you do a reasonableness check? Did you use a reconciliation to ensure the totals match?
Example: "A sample calculation was performed for Policy #001 to verify the Excel formula matched the manual calculation: \( \text{Premium} = 1000 \times 0.05 = 50 \)."

Writing for Your Audience: Tips for Success

The "Why" is as important as the "What"

A common mistake is describing only the actions.
Weak: "I used the VLOOKUP function in cell B5."
Strong: "I used a VLOOKUP function in cell B5 to map the policy type to the corresponding tax rate provided in the 'Assumptions' tab. This ensures that the tax calculation updates automatically if the policy type changes."

Use Clear Signposting

Your fellow student should be able to find things quickly. Use references like "Sheet: Calculations, Range: A1:F50." This acts like a GPS for your spreadsheet.

Did you know?

In the CP2 exam, you don't get marks for how complex your Excel formulas are. You get marks for how well you explain them. A simple model with a perfect audit trail will score much higher than a complex model with no documentation!

Common Mistakes to Avoid

  • Copying the Exam Paper: Don't just rewrite the instructions you were given. The examiners already know what the instructions were; they want to know what you did with them.
  • Being Too Brief: "I built a model to calculate pension benefits" is not enough. You need to explain the steps.
  • Technical Jargon Overload: While you are writing for actuaries, your language should be clear and professional. Avoid "slang" or overly confusing abbreviations.
  • Ignoring Errors: If your model didn't quite work or you ran out of time, document it! Tell the senior actuary where the limitation is. This shows professional integrity.

Quick Review: The Audit Trail Checklist

Before you finish your audit trail, ask yourself these three questions:

1. Is it Sequential? Does the document follow the same order as the spreadsheet?
2. Is it Reproducible? Could a student who hasn't seen the exam paper recreate your model using only your audit trail?
3. Is it Justified? Have I explained the reasoning behind my choices (e.g., why I chose a specific formula or how I handled bad data)?

Summary Key Takeaway

The goal of this chapter is clarity and continuity. Your audit trail bridges the gap between a raw spreadsheet and a professional actuarial product. By focusing on Data, Assumptions, Methodology, Results, and Checks (DAMRC), and writing for both a high-level reviewer (Senior Actuary) and a technical peer (Fellow Student), you ensure that your model is transparent, reliable, and easy to maintain.

Keep practicing! The more you explain your thought process out loud, the easier it becomes to write it down. You've got this!