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.)

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

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)