Excel Practice Problems

BattleActs Practice Exams (2022.Fall)

Late-Breaking News: (Oct 22, 2022)

• The CAS appears to have posted an Excel file with sample IFRS 17 on the Exam 6-Canada page. This file was not on the website when the 2022-Fall syllabus was published and it 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

Notes:

• 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.
• For all calculation problems in the practice exam (except #14 and #18) you can change the input values and the answers will automatically update. In other words, you can create your own practice problems.

Shout-outs!

• adipelino! (question #17 had duplicate information for insurance risk which has now been removed)
• a225khan! (question #16 had a minor typo in the solution - see this forum post)
• BA_Fall_2022! (question #19 had the correct calculations but the wrong conclusion about whether the insurer is in satisfactory financial condition)
• m6daniel (typos in question #25)

Excel Problems	Answer File
BA Practice Exam 1 (2022-Fall)	BA Practice Exam 1 (2022-Fall) (with answers)
Bonus Question on IFRS 17	Answer in same file as question

Past CAS Exams (Many Problems are Now Outdated)

Excel Problems	Examiner's Report
Exam 6C: 2019.Fall	2019.Fall Examiner's Report
Exam 6C: 2019.Spring	2019.Spring Examiner's Report
Exam 6C: 2018.Fall	2018.Fall Examiner's Report

Excel Format Problems

Wiki Link	Problem Type	Practice Problems
OSFI.MCT-IFRS	MCT Ratio (given all components) MCT Capital Available 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)	Excel files coming...
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   • Excess (Deficiency) Amount	Excel files coming...
MSA.Ratios	Calculate MSA Ratios (must also know acceptable ranges)	Excel files coming...
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	Excel files coming...
CIA.FCT-1	Determine whether insurer is in satisfactory financial condition	Excel files coming...
...more to come...	...more to come...	Excel files coming...

BattleActs Practice Exams for 2022.Spring (Many Problems are Now Outdated)

Practice exam 1: Total points = 70.0, difficulty = moderate, pass mark = 49.0 pts or 70.0% Practice exam 2: Total points = 75.0, difficulty = HIGH, pass mark = 52.5 pts or 70.0%

Excel Problems	Examiner's Report
BA Practice Exam 1	BA Practice Exam 1 (with answers)
BA Practice Exam 2	BA Practice Exam 2 (with answers)