Difference between revisions of "Excel Practice Problems"

Revision as of 01:17, 9 October 2022

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)

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)

@@ Line 10: / Line 10: @@
 * <span style="color: green;">'''adipelino!'''</span> (question #17 had duplicate information for insurance risk which has now been removed)
-* <span style="color: green;">'''a225khan!'''</span> (question #16 had a typo in the solution - see ''[https://www.battleactsmain.ca/vanillaforum/discussion/1048/ba-practice-exam-1-fall-2022-qs-16 this forum post]'')
+* <span style="color: green;">'''a225khan!'''</span> (question #16 had a minor typo in the solution - see ''[https://www.battleactsmain.ca/vanillaforum/discussion/1048/ba-practice-exam-1-fall-2022-qs-16 this forum post]'')
 {| class="wikitable"