Difference between revisions of "Excel Practice Problems"

From CAS Exam 5
Jump to navigation Jump to search
(→‎BattleActs: Excel Format Pricing Problems)
 
(48 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
These are the 3 most recent published exams for CAS Exam 5 converted into Excel format. See examiner's reports for solutions. You can download the examiner's report from the CAS website <u>or</u> use the ''[[Exam Summaries]]'' wiki article.
+
__TOC__
 +
 
 +
==Past CAS Exams: Excel Format==
 +
 
 +
These are the 3 most recent published exams for CAS Exam 5 converted into Excel format. See examiner's reports for solutions. You can download the examiner's report from the CAS website <u>or</u> use the ''[[Exam Summaries]]'' wiki article to quickly check individual problems & solutions.
  
 
: [https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_F.19_v03.xlsx <span style="color: white; font-size: 12px; background-color: tomato; border: solid; border-width: 2px; border-radius: 10px; border-color: tomato; padding: 1px 3px 1px 3px; margin: 0px;">'''CAS Exam 5: 2019.Fall (Problems)'''</span>]
 
: [https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_F.19_v03.xlsx <span style="color: white; font-size: 12px; background-color: tomato; border: solid; border-width: 2px; border-radius: 10px; border-color: tomato; padding: 1px 3px 1px 3px; margin: 0px;">'''CAS Exam 5: 2019.Fall (Problems)'''</span>]
  
−
: [https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_S.19.xlsx <span style="color: white; font-size: 12px; background-color: tomato; border: solid; border-width: 2px; border-radius: 10px; border-color: tomato; padding: 1px 3px 1px 3px; margin: 0px;">'''CAS Exam 5: 2019.Spring (Problems)'''</span>]
+
: [https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_S.19_v2.xlsx <span style="color: white; font-size: 12px; background-color: tomato; border: solid; border-width: 2px; border-radius: 10px; border-color: tomato; padding: 1px 3px 1px 3px; margin: 0px;">'''CAS Exam 5: 2019.Spring (Problems)'''</span>]
  
−
: [https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_F.18.xlsx <span style="color: white; font-size: 12px; background-color: tomato; border: solid; border-width: 2px; border-radius: 10px; border-color: tomato; padding: 1px 3px 1px 3px; margin: 0px;">'''CAS Exam 5: 2018.Fall (Problems)'''</span>]
+
: [https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_F.18_v2.xlsx <span style="color: white; font-size: 12px; background-color: tomato; border: solid; border-width: 2px; border-radius: 10px; border-color: tomato; padding: 1px 3px 1px 3px; margin: 0px;">'''CAS Exam 5: 2018.Fall (Problems)'''</span>]
  
 
These are both versions (original & makeup) of Technology-Based-Exams (TBE) from 2018.Spring:
 
These are both versions (original & makeup) of Technology-Based-Exams (TBE) from 2018.Spring:
Line 15: Line 19:
 
: [https://www.battleacts5.ca/Excel/TBE/Exam_5_2018.Spring_TBE_version_2.xlsx <span style="color: black; font-size: 12px; background-color: lightgrey; border: solid; border-width: 2px; border-radius: 10px; border-color: grey; padding: 1px 3px 1px 3px; margin: 0px;">'''Exam 5: 2018.Spring (version 2)'''</span>]
 
: [https://www.battleacts5.ca/Excel/TBE/Exam_5_2018.Spring_TBE_version_2.xlsx <span style="color: black; font-size: 12px; background-color: lightgrey; border: solid; border-width: 2px; border-radius: 10px; border-color: grey; padding: 1px 3px 1px 3px; margin: 0px;">'''Exam 5: 2018.Spring (version 2)'''</span>]
  
−
Due to the transition of CAS exams from paper/pencil to CBT for Fall 2020, I am creating problem sets in Excel and will provide links below. ''(Due to the compressed time frame and other events in 2020 and early 2021, I'm still working on these.)''
+
==BattleActs: Excel Format Reserving Problems==
−
 
 
−
BattleActs Practice Problems in Excel Format:
 
  
 
:{| class='wikitable'
 
:{| class='wikitable'
  
 
|-
 
|-
−
! set !! problem types !! Version 01 !! Version 02 !! Version 03 !! Version 04
+
! title !! problem types !! Set 1 !! Set 2 !! Set 3 !! Set 4
  
 
|-
 
|-
 
|| '''Reserving-A'''
 
|| '''Reserving-A'''
−
|| building triangles <br> development method <br> ECR method <br> BF method <br> CC method
+
|| information in triangles <br> building triangles <br> development method <br> BF method <br> CC method
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-A-(n5)-01_problems.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;">'''Reserving-A-01'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-A-01_problems.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;">'''Reserving-A-01'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-A-(n5)-01_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-A-01-Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-A-01_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-A-01-Solns'''</span>]
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-A-(n5)-02_problems.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;">'''Reserving-A-02'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-A-02_problems.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;">'''Reserving-A-02'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-A-(n5)-02_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-A-02-Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-A-02_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-A-02-Solns'''</span>]
−
|| Reserving-A-03 <br> Reserving-A-03-Solns
+
||  
−
|| Reserving-A-04 <br> Reserving-A-04-Solns
+
||  
  
 
|-
 
|-
 
|| '''Reserving-B'''
 
|| '''Reserving-B'''
−
|| FS basic method <br> COS formula method <br> RBS method
+
|| FS basic method <br> case OS formula method <br> reported Berq-Sherm method
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-B-(n3)-01_problems.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;">'''Reserving-B-01'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-B-01_problems.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;">'''Reserving-B-01'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-B-(n3)-01_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-B-01-Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-B-01_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-B-01-Solns'''</span>]
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-B-(n3)-02_problems.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;">'''Reserving-B-02'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-B-02_problems.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;">'''Reserving-B-02'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-B-(n3)-02_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-B-02-Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-B-02_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-B-02-Solns'''</span>]
−
|| Reserving-B-03 <br> Reserving-B-03-Solns
+
||  
−
|| Reserving-B-04 <br> Reserving-B-04-Solns
+
||  
  
 
|-
 
|-
 
|| '''Reserving-C'''
 
|| '''Reserving-C'''
 
|| building triangles <br> development method <br> BF method (tort reform) <br> CC method (adjs)
 
|| building triangles <br> development method <br> BF method (tort reform) <br> CC method (adjs)
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-C-(n4)-01_problems.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;">'''Reserving-C-01'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-C-01_problems.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;">'''Reserving-C-01'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-C-(n4)-01_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-C-01-Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-C-01_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-C-01-Solns'''</span>]
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-C-(n4)-02_problems.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;">'''Reserving-C-02'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-C-02_problems.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;">'''Reserving-C-02'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-C-(n4)-02_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-C-02-Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-C-02_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-C-02-Solns'''</span>]
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-C-(n4)-03_problems.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;">'''Reserving-C-03'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-C-03_problems.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;">'''Reserving-C-03'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-C-(n4)-03_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-C-03-Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-C-03_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-C-03-Solns'''</span>]
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-C-(n4)-04_problems.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;">'''Reserving-C-04'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-C-04_problems.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;">'''Reserving-C-04'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-C-(n4)-04_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-C-04-Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-C-04_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-C-04-Solns'''</span>]
  
 
|-
 
|-
 
|| '''Reserving-D'''
 
|| '''Reserving-D'''
−
|| disposal rate method <br> PBS method <br> case O/S hard method <br> evaluation
+
|| disposal rate method <br> paid Berq-Sherm method <br> case O/S hard method <br> evaluation
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-D-(n4)-01_problems.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;">'''Reserving-D-01'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-D-01_problems.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;">'''Reserving-D-01'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-D-(n4)-01_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-D-01-Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-D-01_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-D-01-Solns'''</span>]
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-D-(n4)-02_problems_v02.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;">'''Reserving-D-02'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-D-02_problems.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;">'''Reserving-D-02'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-D-(n4)-02_solutions_v02.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-D-02-Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-D-02_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-D-02-Solns'''</span>]
−
||Reserving-D-03 <br> Reserving-D-03-Solns
+
||
−
||Reserving-D-04 <br> Reserving-D-04-Solns
+
||
  
 
|-
 
|-
 
|| '''Reserving-E'''
 
|| '''Reserving-E'''
 
|| S/S multiplicative <br> reinsurance net unpaid <br> ALAE additive/mult. <br> ULAE - classical/Kittel <br> ULAE - Conger/Nolibos
 
|| S/S multiplicative <br> reinsurance net unpaid <br> ALAE additive/mult. <br> ULAE - classical/Kittel <br> ULAE - Conger/Nolibos
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-E-(n5)-01_problems.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;">'''Reserving-E-01'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-E-01_problems.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;">'''Reserving-E-01'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-E-(n5)-01_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-E-01-Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-E-01_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-E-01-Solns'''</span>]
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-E-(n5)-02_problems.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;">'''Reserving-E-02'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Reserving-E-02_problems.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;">'''Reserving-E-02'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-E-(n5)-02_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-E-02-Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Reserving-E-02_solutions.xlsm <span style="color: white; font-size: 12px; background-color: green; border: solid; border-width: 2px; border-radius: 10px; border-color: indigo; padding: 1px 3px 1px 3px; margin: 0px;">'''Reserving-E-02-Solns'''</span>]
−
||Reserving-E-03 <br> Reserving-E-03-Solns
+
||
−
||Reserving-E-04 <br> Reserving-E-04-Solns
+
||
  
 
|}
 
|}
  
−
<br>
+
==BattleActs: Excel Format Pricing Problems==
  
 
:{| class='wikitable'
 
:{| class='wikitable'
  
 
|-
 
|-
−
! set !! problem types !! Version 01 !! Version 02
+
! chapter !! problem types !! Set 1 !! Set 2
  
 
|-
 
|-
 
|| '''Pricing-01-03-04'''
 
|| '''Pricing-01-03-04'''
 
|| basic formulas <br> AY & CY losses <br> exposure aggregation
 
|| basic formulas <br> AY & CY losses <br> exposure aggregation
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(01-03-04)_problems_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (01-03-04)'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(01-03-04)_problems_(Set1)_v4.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (01-03-04)'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(01-03-04)_solutions_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (01-03-04) Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(01-03-04)_solutions_(Set1)_v4.xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (01-03-04) Solns'''</span>]
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(01-03-04)_problems_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (01-03-04)'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(01-03-04)_problems_(Set2)_v4.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (01-03-04)'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(01-03-04)_solutions_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (01-03-04) Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(01-03-04)_solutions_(Set2)_v4.xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (01-03-04) Solns'''</span>]
  
 
|-
 
|-
 
|| '''Pricing-05a'''
 
|| '''Pricing-05a'''
 
|| EP @ CRL: annual, 1 rt chg  <br> EP @ CRL: annual, 2 rt chgs <br> EP @ CRL: 6-month <br> EP @ CRL: policy years <br> EP @ CRL: law change
 
|| EP @ CRL: annual, 1 rt chg  <br> EP @ CRL: annual, 2 rt chgs <br> EP @ CRL: 6-month <br> EP @ CRL: policy years <br> EP @ CRL: law change
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05a)_problems_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (05a)'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05a)_problems_(Set1)_v3.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (05a)'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05a)_solutions_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (05a) Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05a)_solutions_(Set1)_v3.xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (05a) Solns'''</span>]
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05a)_problems_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (05a)'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05a)_problems_(Set2)_v3.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (05a)'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05a)_solutions_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (05a) Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05a)_solutions_(Set2)_v3.xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (05a) Solns'''</span>]
  
 
|-
 
|-
 
|| '''Pricing-05b'''
 
|| '''Pricing-05b'''
−
|| 1-step trending  <br> 2-step trending <br> premium trend
+
|| 1-step premium trending  <br> 2-step premium trending <br> premium development
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05b)_problems_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (05b)'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05b)_problems_(Set1)_v2.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (05b)'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05b)_solutions_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (05b) Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05b)_solutions_(Set1)_v2.xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (05b) Solns'''</span>]
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05b)_problems_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (05b)'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05b)_problems_(Set2)_v3.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (05b)'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05b)_solutions_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (05b) Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05b)_solutions_(Set2)_v3.xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (05b) Solns'''</span>]
  
 
|-
 
|-
Line 114: Line 116:
 
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(06)_problems_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (06)'''</span>]  
 
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(06)_problems_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (06)'''</span>]  
 
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(06)_solutions_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (06) Solns'''</span>]
 
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(06)_solutions_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (06) Solns'''</span>]
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(06)_problems_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (06)'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(06)_problems_(Set2)_v2.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (06)'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(06)_solutions_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (06) Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(06)_solutions_(Set2)_v2.xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (06) Solns'''</span>]
  
 
|-
 
|-
Line 135: Line 137:
 
|-
 
|-
 
|| '''Pricing-11'''
 
|| '''Pricing-11'''
−
|| ILFs: uncensored data <br> ILFs: censored data <br> deductible relativities: ground-up losses <br> deductible relativities: net losses <br> WC: premium discount <br> WC: loss constant <br> ITV: premium rate per $1,000 <br> ITV: coninsurance
+
|| ILFs: uncensored data <br> ILFs: censored data <br> deductible relativities: ground-up losses <br> deductible relativities: net losses <br> WC: premium discount <br> WC: loss constant <br> ITV: premium rate per $1,000 <br> ITV: co-insurance
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(11)_problems_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (11)'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(11)_problems_(Set1)_v2.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (11)'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(11)_solutions_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (11) Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(11)_solutions_(Set1)_v2.xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (11) Solns'''</span>]
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(11)_problems_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (11)'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(11)_problems_(Set2)_v2.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (11)'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(11)_solutions_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (11) Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(11)_solutions_(Set2)_v2.xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (11) Solns'''</span>]
  
 
|-
 
|-
 
|| '''Pricing-12-13'''
 
|| '''Pricing-12-13'''
 
|| C of C: Harwayne's method <br> C of C: increased limits analysis <br> C of C: lower limits analysis <br> C of C: limits analysis <br> lifetime value analysis
 
|| C of C: Harwayne's method <br> C of C: increased limits analysis <br> C of C: lower limits analysis <br> C of C: limits analysis <br> lifetime value analysis
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(12-13)_problems_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (12-13)'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(12-13)_problems_(Set1)_v2.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (12-13)'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(12-13)_solutions_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (12-13) Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(12-13)_solutions_(Set1)_v2.xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (12-13) Solns'''</span>]
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(12-13)_problems_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (12-13)'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(12-13)_problems_(Set2)_v2.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (12-13)'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(12-13)_solutions_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (12-13) Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(12-13)_solutions_(Set2)_v2.xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (12-13) Solns'''</span>]
  
 
|-
 
|-
 
|| '''Pricing-14'''
 
|| '''Pricing-14'''
 
|| additive expense fee <br> extension of exposures <br> AARD method <br> A(&Delta;)ARD method <br> limiting premium effect: non-base level <br> limiting premium effect: base level  
 
|| additive expense fee <br> extension of exposures <br> AARD method <br> A(&Delta;)ARD method <br> limiting premium effect: non-base level <br> limiting premium effect: base level  
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(14)_problems_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (14)'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(14)_problems_(Set1)_v02.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (14)'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(14)_solutions_(Set1).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (14) Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(14)_solutions_(Set1)_v02.xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (14) Solns'''</span>]
−
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(14)_problems_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (14)'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(14)_problems_(Set2)_v02.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (14)'''</span>]  
−
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(14)_solutions_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (14) Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(14)_solutions_(Set2)_v02.xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (14) Solns'''</span>]
  
 
|-
 
|-
Line 164: Line 166:
 
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(15)_problems_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (15)'''</span>]  
 
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(15)_problems_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (15)'''</span>]  
 
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(15)_solutions_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (15) Solns'''</span>]
 
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(15)_solutions_(Set2).xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (15) Solns'''</span>]
 +
 +
|-
 +
|| '''Pricing-App'''
 +
|| HO indication : pure premium method <br> WC indication: loss ratio method
 +
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(App)_problems_(Set1)_v7.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (App)'''</span>]
 +
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(App)_solutions_(Set1)_v7.xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 1 (App) Solns'''</span>]
 +
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(App)_problems_(Set2)_v5.xlsx <span style="color: white; font-size: 12px; background-color: blue; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (App)'''</span>]
 +
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(App)_solutions_(Set2)_v5.xlsx <span style="color: white; font-size: 12px; background-color: chocolate; border: solid; border-width: 2px; border-radius: 10px; border-color: blue; padding: 1px 3px 1px 3px; margin: 0px;">'''Pricing: Set 2 (App) Solns'''</span>]
  
 
|}
 
|}

Latest revision as of 22:00, 21 July 2021

Past CAS Exams: Excel Format

These are the 3 most recent published exams for CAS Exam 5 converted into Excel format. See examiner's reports for solutions. You can download the examiner's report from the CAS website or use the Exam Summaries wiki article to quickly check individual problems & solutions.

CAS Exam 5: 2019.Fall (Problems)
CAS Exam 5: 2019.Spring (Problems)
CAS Exam 5: 2018.Fall (Problems)

These are both versions (original & makeup) of Technology-Based-Exams (TBE) from 2018.Spring:

Exam 5: 2018.Spring (version 1) - QUESTIONS ONLY
Exam 5: 2018.Spring (version 1)
Exam 5: 2018.Spring (version 2) - QUESTIONS ONLY
Exam 5: 2018.Spring (version 2)

BattleActs: Excel Format Reserving Problems

title problem types Set 1 Set 2 Set 3 Set 4
Reserving-A information in triangles
building triangles
development method
BF method
CC method 		Reserving-A-01

Reserving-A-01-Solns

Reserving-A-02

Reserving-A-02-Solns

Reserving-B FS basic method
case OS formula method
reported Berq-Sherm method 		Reserving-B-01

Reserving-B-01-Solns

Reserving-B-02

Reserving-B-02-Solns

Reserving-C building triangles
development method
BF method (tort reform)
CC method (adjs) 		Reserving-C-01

Reserving-C-01-Solns

Reserving-C-02

Reserving-C-02-Solns

Reserving-C-03

Reserving-C-03-Solns

Reserving-C-04

Reserving-C-04-Solns

Reserving-D disposal rate method
paid Berq-Sherm method
case O/S hard method
evaluation 		Reserving-D-01

Reserving-D-01-Solns

Reserving-D-02

Reserving-D-02-Solns

Reserving-E S/S multiplicative
reinsurance net unpaid
ALAE additive/mult.
ULAE - classical/Kittel
ULAE - Conger/Nolibos 		Reserving-E-01

Reserving-E-01-Solns

Reserving-E-02

Reserving-E-02-Solns

BattleActs: Excel Format Pricing Problems

chapter problem types Set 1 Set 2
Pricing-01-03-04 basic formulas
AY & CY losses
exposure aggregation 		Pricing: Set 1 (01-03-04)

Pricing: Set 1 (01-03-04) Solns

Pricing: Set 2 (01-03-04)

Pricing: Set 2 (01-03-04) Solns

Pricing-05a EP @ CRL: annual, 1 rt chg
EP @ CRL: annual, 2 rt chgs
EP @ CRL: 6-month
EP @ CRL: policy years
EP @ CRL: law change 		Pricing: Set 1 (05a)

Pricing: Set 1 (05a) Solns

Pricing: Set 2 (05a)

Pricing: Set 2 (05a) Solns

Pricing-05b 1-step premium trending
2-step premium trending
premium development 		Pricing: Set 1 (05b)

Pricing: Set 1 (05b) Solns

Pricing: Set 2 (05b)

Pricing: Set 2 (05b) Solns

Pricing-06 excess loss factor
benefit change impact
trend selection
trend period (losses)
leveraged effect of limits 		Pricing: Set 1 (06)

Pricing: Set 1 (06) Solns

Pricing: Set 2 (06)

Pricing: Set 2 (06) Solns

Pricing-07-08 pure premium method
all-variable expense method
premium-based expense method
exposure-based expense method
loss ratio method 		Pricing: Set 1 (07-08)

Pricing: Set 1 (07-08) Solns

Pricing: Set 2 (07-08)

Pricing: Set 2 (07-08) Solns

Pricing-09 relativities: pure premium method
relativities: with credibility
relativities: loss ratio method
relativities: adjusted pure premium method
relativities: detecting distortion 		Pricing: Set 1 (09)

Pricing: Set 1 (09) Solns

Pricing: Set 2 (09)

Pricing: Set 2 (09) Solns

Pricing-11 ILFs: uncensored data
ILFs: censored data
deductible relativities: ground-up losses
deductible relativities: net losses
WC: premium discount
WC: loss constant
ITV: premium rate per $1,000
ITV: co-insurance 		Pricing: Set 1 (11)

Pricing: Set 1 (11) Solns

Pricing: Set 2 (11)

Pricing: Set 2 (11) Solns

Pricing-12-13 C of C: Harwayne's method
C of C: increased limits analysis
C of C: lower limits analysis
C of C: limits analysis
lifetime value analysis 		Pricing: Set 1 (12-13)

Pricing: Set 1 (12-13) Solns

Pricing: Set 2 (12-13)

Pricing: Set 2 (12-13) Solns

Pricing-14 additive expense fee
extension of exposures
AARD method
A(Δ)ARD method
limiting premium effect: non-base level
limiting premium effect: base level 		Pricing: Set 1 (14)

Pricing: Set 1 (14) Solns

Pricing: Set 2 (14)

Pricing: Set 2 (14) Solns

Pricing-15 experience modification: CGL
experience modification: WC
loss-rated composite rating
large deductible policies
retrospective rating 		Pricing: Set 1 (15)

Pricing: Set 1 (15) Solns

Pricing: Set 2 (15)

Pricing: Set 2 (15) Solns

Pricing-App HO indication : pure premium method
WC indication: loss ratio method 		Pricing: Set 1 (App)

Pricing: Set 1 (App) Solns

Pricing: Set 2 (App)

Pricing: Set 2 (App) Solns

Retrieved from "https://www.battleacts5.ca/wiki5/index.php?title=Excel_Practice_Problems&oldid=11577"