Excel Practice Problems
Jump to navigation
Jump to search
BattleActs Practice Exams (2023-Fall)
Useful Information:
- The CAS posted a NEW Excel file with sample IFRS 17 questions on the Exam 6-Canada page. This is not listed as being part of the required readings but it looks like something you should definitely look at. You can download it from this page: (You have to scroll down to find it.)
- → CAS Exam 6-Canada ← This leads you to the original CAS version
| Or click below to download the BattleActs version, which has additional BA commentary to help you better understand the solutions:
|
Notes:
- If you find any issues in the NEW practice exam for 2025-Fall, please post here: Forum
- If you find any typos or errors, please post to the PRACTICE EXAM category of the forum here: Forum
- For the IFRS 17 Bonus Question, you will need to refer to the source text for the CIA.IFRS17-LRC wiki article.
- We no longer publish Excel versions of past CAS exams because the majority of calculation problems from past exams are out-of-date. (And there is no advantage in having the short-answer questions in Excel format.)
| Excel Problems | Answer File |
| NEW!!! Practice Exam for New 2025-Fall Syllabus | Practice Exam Answers for New 2025-Fall Syllabus |
| NEW!!! Challenge MCT Question | see question file |
| Revised Practice Exam for New 2023-Fall Syllabus | Revised Practice Exam Answers for New 2023-Fall Syllabus |
| Bonus Question on IFRS 17 | Answer in same file as question |
| BA Version of CAS Sample Problem 7 (step-by-step) | Answer in same file as question |
List of Problem Types
Problem types highlighted in blue are also available as web-based problems.
| Wiki Link | Problem Type | Practice Problems |
|---|---|---|
| OSFI.MCT-IFRS | MCT Ratio (given all components) MCT Capital Available (TOTAL) MCT Capital Available (Deduction due to Capital Composition) MCT Capital Required for Insurance Risk (TOTAL) MCT Capital Required for Insurance Risk (Earthquakes) MCT Capital Required for Insurance Risk (Deduction from Capital Available for Unregistered Reinsurance) MCT Capital Required for Insurance Risk (Margin Required for Unregistered Reinsurance) MCT Capital Required for Market Risk (TOTAL) MCT Capital Required for Market Risk (Interest Rate Risk - easy version) MCT Capital Required for Market Risk (Interest Rate Risk - harder version) MCT Capital Required for Market Risk (Duration of Assets & Liabilities) MCT Capital Required for Operational Risk (TOTAL) MCT Capital Required for Credit Risk (TOTAL) |
MCT: Set 1 |
| CCIR.Instructions | Calculating Equity • using Fundamental Accounting Equation • using prior year's equity and current year's income • using Statement of Financial Position - Liabilities & Equity, page 20.11) Other Financial Statement Quantities • Net Income / Investment Income / Investment Return • Adjusted equity / Investment Yield / ROE (Return on Equity) • Claims Development as a % of Adjusted Equity • Agents and Brokers Balances Due from Subs and Associates as a % of Adjusted Eq. • Insurance Service Result / Total Insurance Revenue / Excess (Deficiency) using page 60.45 • Excess (Deficiency) Amount (using page 60.35) |
CCIR Instructions: Set 1 |
| MSA.Ratios | Calculate MSA Ratios (must also know acceptable ranges) | MSA Ratios: Set 1 |
| Dutil.FA | RSP Participation Ratio Company Loss Ratio • On company's share of RSP • Total including cessions to RSP • Total assuming no cession to RSP |
Facility Association: Set 1
Facility Association: Set 1 (Solutions)
|
| CIA.FCT-1 | Determine whether insurer is in satisfactory financial condition | FCT: Set 1 |
| CIA.IFRS17-LRC | Calculate the CSM using coverage units Calculate LRC under PAA Using basic formulas to calculate LC & LRC (EASY version) |
IFRS17-LRC: Set 1 |
| CIA.IFRS17-DR | Calculate the IFRS 17 discount rate using a bottom-up and top-down approach Calculate the FCFs for issue years |
IFRS17-DR: Set 1 |
| BCAR.Cdn | Determine the A.M. Best rating Calculate B5 for BCAR for each VaR level |
BCAR: Set 1 |
| Odo.FinReg | Regulator action under Solvency II |
Solvency II: Set 1 |
| PACICC.Comp | Calculate PACICC Recovery Calculate Additional Distribution |
PACICC Recovery: Set 1 |
