Excel Practice Problems

BattleActs Practice Exams (2022.Fall)

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)

Excel Problems	Answer File
BA Practice Exam 1 (2022-Fall)	BA Practice Exam 1 (2022-Fall) (with answers)
Bonus Question on IFRS 17 is being edited. Check back soon!	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)