Difference between revisions of "Excel Practice Problems"

From Exam 6 Canada
Jump to navigation Jump to search
(→‎List of Problem Types)
 
(161 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
==Past CAS Exams==
+
==BattleActs Practice Exams (2023-Fall)==
 +
'''Useful Information''':
 +
 
 +
* The CAS posted a <span style="color: red;">'''NEW'''</span> 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.)''
 +
 
 +
: &rarr;  [https://www.casact.org/exam/exam-6c-regulation-and-financial-reportingcanada CAS Exam 6-Canada]'' &nbsp;&nbsp; &larr; ''This leads you to the original CAS version''
 +
 
 +
{| class='wikitable'
 +
|-
 +
|| Or click below to download the '''BattleActs version''', which has '''additional BA commentary''' to help you better understand the solutions:
 +
<br>
 +
: &rarr; [https://www.battleactsmain.ca/Excel/SampleQuestions_IFRS_17_Commentary_(2025_03_02).xlsx <span style="color: white; font-size: 14px; background-color: green; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 15px 25px 15px 25px; margin: 10px;">'''CAS IFRS 17 Sample Questions WITH ADDITIONAL BATTLEACTS COMMENTARY'''</span>]
 +
<br>
 +
: <span style="color: red;">'''(Last Updated: 2025-03-02)'''</span>
 +
 
 +
|}
 +
 
 +
'''Notes''':
 +
 
 +
* If you find any issues in the NEW practice exam for 2025-Fall, please post here: [https://www.battleactsmain.ca/vanillaforum/categories/practice-exam-2025-fall <span style="font-size: 12px; background-color: lightgrey; border: solid; border-width: 1px; border-radius: 10px; padding: 2px 10px 2px 10px; margin: 0px;">'''Forum'''</span>]
 +
* If you find any typos or errors, please post to the '''PRACTICE EXAM''' category of the forum here: [https://www.battleactsmain.ca/vanillaforum/categories/practice-exam-2018-fall<span style="font-size: 12px; background-color: lightgrey; border: solid; border-width: 1px; border-radius: 10px; padding: 2px 10px 2px 10px; margin: 0px;">'''Forum'''</span>]
 +
* 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.)''
  
 
{| class="wikitable"
 
{| class="wikitable"
Line 5: Line 27:
 
|- style="text-align: center;"
 
|- style="text-align: center;"
 
|| '''Excel Problems'''
 
|| '''Excel Problems'''
−
|| '''Examiner's Report'''
+
|| '''Answer File'''
 +
 
 +
|-
 +
| '''NEW!!!''' [https://www.battleactsmain.ca/Excel/BattleActs_Practice_Exam_6C_Version_A_(2025_Fall)_0010_questions_v02.xlsx <span style="color: white; font-size: 14px; background-color: purple; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Practice Exam for New 2025-Fall Syllabus'''</span>]
 +
|| ''[https://www.battleactsmain.ca/Excel/BattleActs_Practice_Exam_6C_Version_A_(2025_Fall)_0010_answers_v02.xlsx Practice Exam Answers for New 2025-Fall Syllabus]''
 +
 
 +
|-
 +
| '''NEW!!!''' [https://www.battleactsmain.ca/Excel/Challenge_MCT_Questions_v01.xlsx <span style="color: white; font-size: 14px; background-color: purple; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Challenge MCT Question'''</span>]
 +
|| see question file
 +
 
 +
|-
 +
| [https://www.battleactsmain.ca/Excel/BattleActs_Practice_Exam_6C_Version_A_(2023_Fall)_0010_questions_v03.xlsx <span style="color: white; font-size: 14px; background-color: green; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Revised Practice Exam for New 2023-Fall Syllabus'''</span>]
 +
|| ''[https://www.battleactsmain.ca/Excel/BattleActs_Practice_Exam_6C_Version_A_(2023_Fall)_0010_answers_v03.xlsx Revised Practice Exam Answers for New 2023-Fall Syllabus]''  
  
 
|-  
 
|-  
−
|[https://www.battleactsmain.ca/Excel/CBT_Exam_6c_F.19.xlsx <span style="color: white; font-size: 14px; background-color: green; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Exam 6C: 2019.Fall'''</span>]
+
| [https://www.battleactsmain.ca/Excel/IFRS17_Bonus_Question_v3.xlsx <span style="color: white; font-size: 14px; background-color: blue; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Bonus Question on IFRS 17'''</span>]
−
|| ''[https://www.battleactsmain.ca/pdf/Exam_2019_2_final.pdf 2019.Fall Examiner's Report]''
+
|| '''&nbsp;&nbsp;&nbsp;&nbsp;Answer in same file as question'''</span>
  
 
|-  
 
|-  
−
| [https://www.battleactsmain.ca/Excel/CBT_Exam_6c_S.19.xlsx <span style="color: white; font-size: 14px; background-color: green; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Exam 6C: 2019.Spring'''</span>]
+
| [https://battleactsmain.ca/Excel/CAS_IFRS_17_Sample_Problem_7_(4_problems).xlsx <span style="color: white; font-size: 14px; background-color: orangered; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''BA Version of CAS Sample Problem 7 (step-by-step)'''</span>]
−
|| ''[https://www.battleactsmain.ca/pdf/Exam_2019_1_final.pdf 2019.Spring Examiner's Report]''
+
|| '''&nbsp;&nbsp;&nbsp;&nbsp;Answer in same file as question'''</span>
 +
 
 +
|}
  
 +
==List of Problem Types==
 +
 +
Problem types <span style="background-color: lightblue;">highlighted in blue</span> are also available as ''[https://battleactsmain.ca/FC.php?selectString=**&filter=both&sortOrder=natural&colorFlag=allFlag&colorStatus=allStatus&priority=A&prefix=all&suffix=all&section=all&subSection=all&subsetFlag=CP&examRep=all&examYear=all&examTerm=all&quizNum=0&select07=0&select08=0&select09=0 web-based problems]''.
 +
 +
{| class='wikitable'
 
|-
 
|-
−
| [https://www.battleactsmain.ca/Excel/CBT_Exam_6c_F.18.xlsx <span style="color: white; font-size: 14px; background-color: green; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''Exam 6C: 2018.Fall'''</span>]
+
!  Wiki Link !! Problem Type !! Practice Problems
−
|| ''[https://www.battleactsmain.ca/pdf/Exam_2018_2_final.pdf 2018.Fall Examiner's Report]''
 
  
−
|}
+
|-
 +
|| [[OSFI.MCT-IFRS]]
 +
|| <span style="background-color: lightblue;">MCT '''Ratio''' (given all components)</span> <br> MCT '''Capital Available''' (TOTAL) <br> <span style="background-color: lightblue;">MCT Capital Available (Deduction due to Capital Composition)</span> <br> MCT '''Capital Required for Insurance Risk''' (TOTAL) <br> <span style="background-color: lightblue;">MCT Capital Required for Insurance Risk (Earthquakes)</span> <br> MCT Capital Required for Insurance Risk (Deduction from Capital Available for Unregistered Reinsurance) <br> MCT Capital Required for Insurance Risk (Margin Required for Unregistered Reinsurance) <br> <span style="background-color: lightblue;">MCT '''Capital Required for Market Risk'''</span> (TOTAL) <br> <span style="background-color: lightblue;">MCT Capital Required for Market Risk (Interest Rate Risk - easy version)</span> <br> <span style="background-color: lightblue;">MCT Capital Required for Market Risk (Interest Rate Risk - harder version)</span> <br> MCT Capital Required for Market Risk (Duration of Assets & Liabilities) <br> <span style="background-color: lightblue;">MCT '''Capital Required for Operational Risk''' (TOTAL)</span> <br> MCT '''Capital Required for Credit Risk''' (TOTAL)
 +
 
 +
|| [https://www.battleactsmain.ca/Excel/POWER_PACK/MCT_IFRS17_1_v07.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''MCT: Set 1'''</span>]
 +
 
 +
[https://www.battleactsmain.ca/Excel/POWER_PACK/MCT_IFRS17_1_v10_(solutions).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''MCT: Set 1 (Solutions)'''</span>]
 +
 
 +
|-
 +
|| [[CCIR.Instructions]]
 +
|| '''Calculating Equity''' <br> &nbsp;&nbsp;&bull; <span style="background-color: lightblue;">using Fundamental Accounting Equation</span> <br> &nbsp;&nbsp;&bull; using prior year's equity and current year's income <br> &nbsp;&nbsp;&bull; using Statement of Financial Position - Liabilities & Equity, page 20.11) <br> '''Other Financial Statement Quantities''' <br> &nbsp;&nbsp;&bull; <span style="background-color: lightblue;">Net Income / Investment Income / Investment Return</span> <br> &nbsp;&nbsp;&bull; <span style="background-color: lightblue;">Adjusted equity / Investment Yield / ROE (Return on Equity)</span> <br> &nbsp;&nbsp;&bull; <span style="background-color: lightblue;">Claims Development as a % of Adjusted Equity</span> <br> &nbsp;&nbsp;&bull; <span style="background-color: lightblue;">Agents and Brokers Balances Due from Subs and Associates as a % of Adjusted Eq.</span> <br> &nbsp;&nbsp;&bull; <span style="background-color: lightblue;">Insurance Service Result / Total Insurance Revenue / Excess (Deficiency) using page 60.45</span> <br> &nbsp;&nbsp;&bull; <span style="background-color: lightblue;">Excess (Deficiency) Amount (using page 60.35)</span>
 +
 
 +
|| [https://www.battleactsmain.ca/Excel/POWER_PACK/CCIR_1_v04.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''CCIR Instructions: Set 1'''</span>]
 +
 
 +
[https://www.battleactsmain.ca/Excel/POWER_PACK/CCIR_1_v04_(solutions).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''CCIR Instructions: Set 1 (Solutions)'''</span>]
 +
 
 +
|-
 +
|| [[MSA.Ratios]]
 +
|| <span style="background-color: lightblue;">Calculate MSA Ratios (must also know acceptable ranges)</span>
 +
 
 +
|| [https://www.battleactsmain.ca/Excel/POWER_PACK/MSA_1_v02.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''MSA Ratios: Set 1'''</span>]
 +
 
 +
[https://www.battleactsmain.ca/Excel/POWER_PACK/MSA_1_v02_(solutions).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''MSA Ratios: Set 1 (Solutions)'''</span>]
 +
 
 +
|-
 +
|| [[Dutil.FA]]
 +
|| RSP Participation Ratio <br> '''Company Loss Ratio''' <br> &nbsp;&nbsp;&bull; On company's share of RSP <br> &nbsp;&nbsp;&bull; Total including cessions to RSP <br> &nbsp;&nbsp;&bull; Total assuming no cession to RSP
 +
 
 +
|| [https://www.battleactsmain.ca/Excel/POWER_PACK/FA_v02.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''Facility Association: Set 1'''</span>]
 +
 
 +
[https://www.battleactsmain.ca/Excel/POWER_PACK/FA_v02_(solutions).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''Facility Association: Set 1 (Solutions)'''</span>]
 +
 
 +
 
 +
|-
 +
|| [[CIA.FCT-1]]
 +
|| Determine whether insurer is in satisfactory financial condition
 +
 
 +
|| [https://www.battleactsmain.ca/Excel/POWER_PACK/FCT_1_v02.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''FCT: Set 1'''</span>]
 +
 
 +
[https://www.battleactsmain.ca/Excel/POWER_PACK/FCT_1_v02_(solutions).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''FCT: Set 1 (Solutions)'''</span>]
 +
 
 +
|-
 +
|| [[CIA.IFRS17-LRC]]
 +
|| Calculate the CSM using coverage units <br> Calculate LRC under PAA <br> Using basic formulas to calculate LC & LRC (EASY version)
 +
 
 +
|| [https://www.battleactsmain.ca/Excel/POWER_PACK/IFRS17-LRC_1_v01.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''IFRS17-LRC: Set 1'''</span>]
 +
 
 +
[https://www.battleactsmain.ca/Excel/POWER_PACK/IFRS17-LRC_1_v01_(solutions).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''IFRS17-LRC: Set 1 (Solutions)'''</span>]
 +
 
 +
|-
 +
|| [[CIA.IFRS17-DR]]
 +
|| Calculate the IFRS 17 discount rate using a bottom-up and top-down approach <br> Calculate the FCFs for issue years
 +
 
 +
|| [https://www.battleactsmain.ca/Excel/POWER_PACK/IFRS17-DR_1_v01.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''IFRS17-DR: Set 1'''</span>]
  
−
==BattleActs Practice Exams==
+
[https://www.battleactsmain.ca/Excel/POWER_PACK/IFRS17-DR_1_v01_(solutions).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''IFRS17-DR: Set 1 (Solutions)'''</span>]
  
−
{| class='wikitable' style='background-color: navajowhite;'
 
 
|-
 
|-
−
|| A new practice exam will be available by October 1, 2021 or shortly thereafter.
+
|| [[BCAR.Cdn]]
−
|}
+
|| <span style="background-color: lightblue;">Determine the A.M. Best rating</span> <br> <span style="background-color: lightblue;">Calculate B5 for BCAR for each VaR level</span>
 +
 
 +
|| [https://www.battleactsmain.ca/Excel/POWER_PACK/BCAR_v02.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''BCAR: Set 1'''</span>]
  
−
: [https://www.battleactsmain.ca/Excel/practice_exam_01_(2018.Fall)_problems_v03.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: green; padding: 1px 3px 1px 3px; margin: 0px;">'''''Excel Practice Exam 1 (Problems)'''''</span>] &nbsp;&nbsp; <span style="color: red;">&larr; ''based on an earlier syllabus (questions #10, 12, 19, 22(a) are no longer on the current syllabus.)''</span>
+
[https://www.battleactsmain.ca/Excel/POWER_PACK/BCAR_v02_(solutions).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''BCAR: Set 1 (Solutions)'''</span>]
  
−
: [https://www.battleactsmain.ca/Excel/practice_exam_01_(2018.Fall)_solutions_v03.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: green; padding: 1px 3px 1px 3px; margin: 0px;">'''''Excel Practice Exam 1 (Problems & Solutions)'''''</span>]
+
|-
 +
|| [[Odo.FinReg]]
 +
|| <span style="background-color: lightblue;">Regulator action under Solvency II</span> <br> <s>Value of commuted claims</s> <span style="color: red;">&larr; removed</span>
 +
|| [https://www.battleactsmain.ca/Excel/POWER_PACK/Solvency_II_1_v02.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''Solvency II: Set 1'''</span>]
  
−
: [https://www.battleactsmain.ca/pdf/practice_exam_01_(2018.Fall)_Q13_solution.pdf <span style="font-size: 12px; background-color: tan; border: solid; border-width: 1px; border-radius: 10px; padding: 2px 10px 2px 10px; margin: 10px;">'''Complete Solution to #13 (Exam 1)'''</span>]
+
[https://www.battleactsmain.ca/Excel/POWER_PACK/Solvency_II_1_v02_(solutions).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''Solvency II: Set 1 (Solutions)'''</span>]
  
−
<hr>
+
|-
 +
|| [[PACICC.Comp]]
 +
|| <span style="background-color: ;">Calculate PACICC Recovery</span> <br> Calculate Additional Distribution
 +
|| [https://www.battleactsmain.ca/Excel/POWER_PACK/PACICC-Comp_1_v03.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''PACICC Recovery: Set 1'''</span>]
  
−
: [https://www.battleactsmain.ca/Excel/practice_exam_02_(2019.Fall)_problems_v2.xlsm <span style="color: white; font-size: 12px; background-color: indigo; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''''Excel Practice Exam 2 (Problems)'''''</span>] &nbsp;&nbsp; <span style="color: red;">&larr; ''based on an earlier syllabus (questions #9, 10, 19 are no longer on the current syllabus.)''</span>
+
[https://www.battleactsmain.ca/Excel/POWER_PACK/PACICC-Comp_1_v03_(solutions).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 0px; border-color: blue; padding: 5px 15px 5px 15px; margin: 0px;">'''PACICC Recovery: Set 1 (Solutions)'''</span>]
  
−
: [https://www.battleactsmain.ca/Excel/practice_exam_02_(2019.Fall)_solutions_v2.xlsm <span style="color: white; font-size: 12px; background-color: indigo; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''''Excel Practice Exam 2 (Problems & Solutions)'''''</span>]
+
|}
  
−
: [https://www.battleactsmain.ca/pdf/practice_exam_02_(2019.Fall)_Q13_solution.pdf <span style="font-size: 12px; background-color: tan; border: solid; border-width: 1px; border-radius: 10px; padding: 2px 10px 2px 10px; margin: 10px;">'''Complete Solution to #13 (Exam 2)'''</span>]
+
[[Excel Practice Problems - 2024-11-25]]

Latest revision as of 23:58, 7 September 2025

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:


→ CAS IFRS 17 Sample Questions WITH ADDITIONAL BATTLEACTS COMMENTARY


(Last Updated: 2025-03-02)

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

MCT: Set 1 (Solutions)

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

CCIR Instructions: Set 1 (Solutions)

MSA.Ratios Calculate MSA Ratios (must also know acceptable ranges) MSA Ratios: Set 1

MSA Ratios: Set 1 (Solutions)

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

FCT: Set 1 (Solutions)

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

IFRS17-LRC: Set 1 (Solutions)

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

IFRS17-DR: Set 1 (Solutions)

BCAR.Cdn Determine the A.M. Best rating
Calculate B5 for BCAR for each VaR level 		BCAR: Set 1

BCAR: Set 1 (Solutions)

Odo.FinReg Regulator action under Solvency II
Value of commuted claims ← removed 		Solvency II: Set 1

Solvency II: Set 1 (Solutions)

PACICC.Comp Calculate PACICC Recovery
Calculate Additional Distribution 		PACICC Recovery: Set 1

PACICC Recovery: Set 1 (Solutions)

Excel Practice Problems - 2024-11-25

Retrieved from "https://battleactsmain.ca/wiki6c/index.php?title=Excel_Practice_Problems&oldid=5551"