Difference between revisions of "Excel Practice Problems"

From CAS Exam 5
Jump to navigation Jump to search
(→‎BattleActs: Excel Format Pricing Problems)
(→‎BattleActs: Excel Format Pricing Problems)
 
(13 intermediate revisions by the same user not shown)
Line 7: Line 7:
 
: [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 18: Line 18:
 
: [https://www.battleacts5.ca/Excel/TBE/Exam_5_2018.Spring_TBE_version_2_(questions_only).xlsm <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) - QUESTIONS ONLY'''</span>]
 
: [https://www.battleacts5.ca/Excel/TBE/Exam_5_2018.Spring_TBE_version_2_(questions_only).xlsm <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) - QUESTIONS ONLY'''</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>]
 
: [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: Excel Format Reserving Problems==
Line 30: Line 28:
 
|-
 
|-
 
|| '''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>]
 
||  
 
||  
 
||  
 
||  
Line 41: Line 39:
 
|| '''Reserving-B'''
 
|| '''Reserving-B'''
 
|| FS basic method <br> case OS formula method <br> reported Berq-Sherm 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>]
 
||  
 
||  
 
||  
 
||  
Line 51: Line 49:
 
|| '''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> paid Berq-Sherm 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>]
 
||
 
||
 
||
 
||
Line 73: Line 71:
 
|| '''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>]
 
||
 
||
 
||
 
||
Line 110: Line 108:
 
|| [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)_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)_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)_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)_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 (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)_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 (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 118: 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 139: 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)_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)_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)_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)_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>]

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"