Difference between revisions of "BattleActs PowerPack"

From CAS Exam 5
Jump to navigation Jump to search
(Pricing Problems (Excel Format))
(Pricing Problems (Excel Format))
 
(64 intermediate revisions by the same user not shown)
Line 1: Line 1:
=='''<span style="color:red;">Breaking News:</span>''' The ''BattleActs PowerPack'' is online!==
+
=='''<span style="color:red;">How to Use the PowerPack</span>'''==
Super-charge your learning with our '''<span style="color:red;">4 Power Stations:</span>'''
 
* '''<span style="color:red;">Past exams</span>''': Quick and easy access at your fingertips
 
* '''<span style="color:red;">One-stop PDF</span>''' of core problems and solutions.
 
* '''<span style="color:red;">Infinite and Interactive</span>''': Generate infinite versions of a problem with our web-based platform and crush it in Excel.
 
* '''<span style="color:red;">Power Core</span>''': Practice multiple versions of core excel problems in a CBT-like environment.
 
  
Battleacts is here to help you prepare for both the syllabus content and the exam environment. With the CAS move to Computer Based Testing (CBT) with Pearson VUE we're providing Excel files which resemble your exam day experience. As more information is made available about the testing experience we'll update the files accordingly.
+
'''Step 1. Build a solid understanding of how to solve exam problems'''  
 +
* Our PDFs contain the core problems with step-by-step detailed solutions
  
=='''<span style="color:red;">Station 1: </span>'''Power through Past Exams==
+
'''Step 2. Drill to crush problems on exam day'''
 +
* Use our web-based templates to generate an infinite number of problems
 +
* With practice, you'll become more efficient and accurate on exam day
  
{| class="wikitable"
+
'''Step 3. Practice in an Excel/CBT like environment'''
|- style="text-align: center;" |
+
* We have a list of all the essential exam formulas from both reserving and pricing in one place
|'''Excel Problems'''||'''Excel Solutions'''||'''Examiner's Report'''
 
  
|-
+
'''Step 4. More Practice'''
|[https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_F.19_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;">'''2019.Fall Exam 5'''</span>]
+
* 4 original exams and past CAS exams are available.
| style="text-align: center;" | ''n/a''
 
|| ''[https://www.battleacts5.ca/pdf/exam_5_(2019-2).pdf 2019.Fall Examiner's Report]''
 
  
|-
+
=='''<span style="color:red;">Step 1.: </span>'''Step-by-Step Solutions==
|[https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_S.19_v2.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;">'''2019.Spring Exam 5'''</span>]
 
| style="text-align: center;" | ''n/a''
 
|| ''[https://www.battleacts5.ca/pdf/exam_5_(2019-1).pdf 2019.Fall Examiner's Report]''
 
  
|-
+
Our PDFs contain the core problems and detailed step-by-step solutions in these 2 files.
|[https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_F.18_v2.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;">'''2018.Fall Exam 5'''</span>]
 
| style="text-align: center;" | ''n/a''
 
|| ''[https://www.battleacts5.ca/pdf/exam_5_(2018-2).pdf 2018.Fall Examiner's Report]''
 
 
 
|-
 
|[https://www.battleacts5.ca/Excel/TBE/Exam_5_2018.Spring_TBE_version_1_(questions_only).xlsm <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;">'''2018.Spring Exam 5 (Original)'''</span>]
 
|| [https://www.battleacts5.ca/Excel/TBE/Exam_5_2018.Spring_TBE_version_1.xlsx <span style="color: black; font-size: 14px; background-color: yellow; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''2018.Spring Solutions (Original)'''</span>]
 
| style="text-align: center;" | ''n/a''
 
 
 
|-
 
|[https://www.battleacts5.ca/Excel/TBE/Exam_5_2018.Spring_TBE_version_2_(questions_only).xlsm <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;">'''2018.Spring Exam 5 (Makeup)'''</span>]
 
|| [https://www.battleacts5.ca/Excel/TBE/Exam_5_2018.Spring_TBE_version_2.xlsx <span style="color: black; font-size: 14px; background-color: yellow; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''2018.Spring Solutions (Makeup)'''</span>]
 
| style="text-align: center;" | ''n/a''
 
 
 
|}
 
 
 
To get the most out of these files you should attempt each exam under timed conditions and then grade yourself strictly.
 
 
 
''Alice: "I've heard the F2 and F4 keys don't work in the Pearson environment. They do work in our Excel files but you've been warned for BattleDay!"''
 
 
 
=='''<span style="color:red;">Station 2: </span>'''One-stop PDFs==
 
 
 
Our one-stop PDFs contain the core problems and detailed solutions in these 2 files so you can quickly refresh your memory on a calculation. Use this in conjunction with the web-based templates or Excel files to help you remember the next step.  
 
  
 
[https://www.battleacts5.ca/pdf/PowerPack_Station2_(Reserving)_(v2).pdf <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 5 One-stop PDF &rarr; RESERVING'''</span>]
 
[https://www.battleacts5.ca/pdf/PowerPack_Station2_(Reserving)_(v2).pdf <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 5 One-stop PDF &rarr; RESERVING'''</span>]
Line 53: Line 22:
 
[https://www.battleacts5.ca/pdf/PowerPack_Station2_(Pricing)_(v2).pdf <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 5 One-stop PDF &rarr; PRICING'''</span>]
 
[https://www.battleacts5.ca/pdf/PowerPack_Station2_(Pricing)_(v2).pdf <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 5 One-stop PDF &rarr; PRICING'''</span>]
  
=='''<span style="color:red;">Station 3: </span>'''Infinite and Interactive==
+
=='''<span style="color:red;">Step 2: </span>'''Drill: Infinite Calculation Problems==
 
 
After practicing problems for a while you can find yourself memorizing the numbers rather than understanding the steps. That's where BattleActs' web-based templates come in &mdash; we generate infinitely many versions of a problem so you focus on the steps involved.
 
 
 
Download the Excel file below to use with the web-based templates. In your browser, navigate to the list of web-based calculation problems you want to study ''(see link below)'' and then open the Excel file to the same problem. Highlight the problem in your browser and copy it before pasting using "Match Destination Formatting" into the highlighted cell within the spreadsheet. Voila! You can now solve the new version of the problem in Excel and then type your answer(s) into the browser to grade it. Repeat as many times as you want to practice the problem.
 
 
 
Click for a [https://www.battleacts5.ca/video/Instructions_PowerPack_Station_3_(Exam_5).webm <span style="color: black; font-size: 12px; background-color: aqua; border: solid; border-width: 2px; border-radius: 10px; border-color: aqua; padding: 3px 5px 3px 5px; margin-top: 100px;">'''video explanation'''</span>] of how to use Station 3:
 
  
And here are the other links you'll need:
+
If you practice on the exact same exam problem several times, you can find yourself memorizing the numbers rather than understanding the steps. To address this, we've recreated many standard problems but with the facility to generate randomized input values. That way, you won't know the answer in advance.
  
* [https://www.battleacts5.ca/Excel/Station3/Exam5_PowerPack_(v5).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 5 Web Template Excel Companion'''</span>]
+
The link below takes you to a list of currently available infinite calculation problems. ''(Note that we develop new ones on an ongoing basis.)'' These problems are presented in a webpage but you can '''copy the input data''' from the web page and '''paste it into an Excel file'''. After you solve the problem in Excel, type or copy your answers back into the webpage to be scored by the computer.
  
 
* [https://www.battleacts5.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<span style="color: black; font-size: 12px; background-color: lightgrey; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''BattleCards - Web-based problems'''</span>]
 
* [https://www.battleacts5.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<span style="color: black; font-size: 12px; background-color: lightgrey; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''BattleCards - Web-based problems'''</span>]
  
=='''<span style="color:red;">Station 4: </span>'''Power Core==
+
=='''<span style="color:red;">Step 3: </span>'''Practice in an Excel/CBT Environment==
  
 
===Reserving Problems (Excel Format)===
 
===Reserving Problems (Excel Format)===
Line 150: Line 113:
 
|| '''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)_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)_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 (05a)'''</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)_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 (05a) Solns'''</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)_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 (05a)'''</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>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(05a)_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 (05a) Solns'''</span>]
  
 
|-
 
|-
Line 159: Line 122:
 
|| 1-step premium trending  <br> 2-step premium trending <br> premium development
 
|| 1-step premium trending  <br> 2-step premium trending <br> premium development
 
|| [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)_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 (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)_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)_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)_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>]
 
[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 166: Line 129:
 
|| '''Pricing-06'''
 
|| '''Pricing-06'''
 
|| excess loss factor  <br> benefit change impact <br> trend selection <br> trend period (losses) <br> leveraged effect of limits
 
|| excess loss factor  <br> benefit change impact <br> trend selection <br> trend period (losses) <br> leveraged effect of limits
|| [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)_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 (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)_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 (06) Solns'''</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)_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)_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>]
 
[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 182: Line 145:
 
|| '''Pricing-09'''
 
|| '''Pricing-09'''
 
|| relativities: pure premium method  <br> relativities: with credibility <br> relativities: loss ratio method <br> relativities: adjusted pure premium method <br> relativities: detecting distortion
 
|| relativities: pure premium method  <br> relativities: with credibility <br> relativities: loss ratio method <br> relativities: adjusted pure premium method <br> relativities: detecting distortion
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(09)_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 (09)'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(09)_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 (09)'''</span>]  
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(09)_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 (09) Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(09)_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 (09) Solns'''</span>]
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(09)_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 (09)'''</span>]  
+
|| [https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(09)_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 (09)'''</span>]  
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(09)_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 (09) Solns'''</span>]
+
[https://www.battleacts5.ca/Excel/ProblemSets/Pricing_(09)_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 (09) Solns'''</span>]
  
 
|-
 
|-
Line 228: Line 191:
  
 
|}
 
|}
 +
 +
=='''<span style="color:red;">Step 4: </span>'''More Practice==
 +
 +
===BattleActs Original Practice Exams===
 +
 +
{| class="wikitable"
 +
 +
|- style="text-align: center;" |
 +
|'''Exam ID || '''Difficulty'''||'''Excel Questions'''||'''Excel Solutions'''||'''Instructor Support'''
 +
 +
|-
 +
| style="text-align: center;" | '''A-01'''
 +
|| <span style="font-size: 24px;">&#128512;</span> Not too hard.
 +
|| [https://www.battleacts5.ca/Excel/BA_Exams/BA_Exam5_PE_A01_(v02).xlsx <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;">'''BA Exam 5 Practice Exam: A-01'''</span>]
 +
|| [https://www.battleacts5.ca/Excel/BA_Exams/BA_Exam5_PE_A01_(v02)_answers.xlsx <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;">'''BA Exam 5 Practice Exam: A-01 (Solutions)'''</span>]
 +
|| [https://www.battleactsmain.ca/battleacts5.ca/forum5/index.php?p=/categories/practice-exam-1<span style="font-size: 12px; background-color: lightgrey; border: solid; border-width: 1px; border-radius: 10px; padding: 2px 10px 2px 10px; margin: 0px;">'''Forum - Practice Exam 1'''</span>]
 +
 +
|-
 +
| style="text-align: center;" | '''A-02'''
 +
|| <span style="font-size: 24px;">&#128513;</span> Not too hard.
 +
|| [https://www.battleacts5.ca/Excel/BA_Exams/BA_Exam5_PE_A02_(v03).xlsx <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;">'''BA Exam 5 Practice Exam: A-02'''</span>]
 +
|| [https://www.battleacts5.ca/Excel/BA_Exams/BA_Exam5_PE_A02_(v03)_answers.xlsx <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;">'''BA Exam 5 Practice Exam: A-02 (Solutions)'''</span>]
 +
|| [https://www.battleactsmain.ca/battleacts5.ca/forum5/index.php?p=/categories/practice-exam-2<span style="font-size: 12px; background-color: lightgrey; border: solid; border-width: 1px; border-radius: 10px; padding: 2px 10px 2px 10px; margin: 0px;">'''Forum - Practice Exam 2'''</span>]
 +
 +
|-
 +
| style="text-align: center;" | '''B-01'''
 +
|| <span style="font-size: 24px;">&#128533;</span> A bit harder.
 +
|| [https://www.battleacts5.ca/Excel/BA_Exams/BA_Exam5_PE_B01_(v04).xlsx <span style="color: black; font-size: 12px; background-color: gold; border: solid; border-width: 2px; border-radius: 10px; border-color: gold; padding: 1px 3px 1px 3px; margin: 0px;">'''BA Exam 5 Practice Exam: B-01'''</span>]
 +
|| [https://www.battleacts5.ca/Excel/BA_Exams/BA_Exam5_PE_B01_(v04)_answers.xlsx <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;">'''BA Exam 5 Practice Exam: B-01 (Solutions)'''</span>]
 +
|| [https://www.battleactsmain.ca/battleacts5.ca/forum5/index.php?p=/categories/practice-exam-3<span style="font-size: 12px; background-color: lightgrey; border: solid; border-width: 1px; border-radius: 10px; padding: 2px 10px 2px 10px; margin: 0px;">'''Forum - Practice Exam 3'''</span>]
 +
 +
|-
 +
| style="text-align: center;" | '''B-02'''
 +
|| <span style="font-size: 24px;">&#128557;</span> A bit harder.
 +
|| [https://www.battleacts5.ca/Excel/BA_Exams/BA_Exam5_PE_B02_(v03).xlsx <span style="color: black; font-size: 12px; background-color: gold; border: solid; border-width: 2px; border-radius: 10px; border-color: gold; padding: 1px 3px 1px 3px; margin: 0px;">'''BA Exam 5 Practice Exam: B-02'''</span>]
 +
|| [https://www.battleacts5.ca/Excel/BA_Exams/BA_Exam5_PE_B02_(v03)_answers.xlsx <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;">'''BA Exam 5 Practice Exam: B-02 (Solutions)'''</span>]
 +
|| [https://www.battleactsmain.ca/battleacts5.ca/forum5/index.php?p=/categories/practice-exam-4<span style="font-size: 12px; background-color: lightgrey; border: solid; border-width: 1px; border-radius: 10px; padding: 2px 10px 2px 10px; margin: 0px;">'''Forum - Practice Exam 4'''</span>]
 +
 +
|}
 +
 +
===CAS Past Exams===
 +
 +
{| class="wikitable"
 +
|- style="text-align: center;" |
 +
|'''Excel Problems'''||'''Excel Solutions'''||'''Examiner's Report'''
 +
 +
|-
 +
|[https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_F.19_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;">'''2019.Fall Exam 5'''</span>]
 +
| style="text-align: center;" | ''n/a''
 +
|| ''[https://www.battleacts5.ca/pdf/exam_5_(2019-2).pdf 2019.Fall Examiner's Report]''
 +
 +
|-
 +
|[https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_S.19_v2.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;">'''2019.Spring Exam 5'''</span>]
 +
| style="text-align: center;" | ''n/a''
 +
|| ''[https://www.battleacts5.ca/pdf/exam_5_(2019-1).pdf 2019.Fall Examiner's Report]''
 +
 +
|-
 +
|[https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_F.18_v2.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;">'''2018.Fall Exam 5'''</span>]
 +
| style="text-align: center;" | ''n/a''
 +
|| ''[https://www.battleacts5.ca/pdf/exam_5_(2018-2).pdf 2018.Fall Examiner's Report]''
 +
 +
|-
 +
|[https://www.battleacts5.ca/Excel/TBE/Exam_5_2018.Spring_TBE_version_1_(questions_only).xlsm <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;">'''2018.Spring Exam 5 (Original)'''</span>]
 +
|| [https://www.battleacts5.ca/Excel/TBE/Exam_5_2018.Spring_TBE_version_1.xlsx <span style="color: black; font-size: 14px; background-color: yellow; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''2018.Spring Solutions (Original)'''</span>]
 +
| style="text-align: center;" | ''n/a''
 +
 +
|- style = "border-bottom: 2px solid;"
 +
|[https://www.battleacts5.ca/Excel/TBE/Exam_5_2018.Spring_TBE_version_2_(questions_only).xlsm <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;">'''2018.Spring Exam 5 (Makeup)'''</span>]
 +
|| [https://www.battleacts5.ca/Excel/TBE/Exam_5_2018.Spring_TBE_version_2.xlsx <span style="color: black; font-size: 14px; background-color: yellow; border: solid; border-width: 1px; border-radius: 10px; margin: 0px; padding: 2px 10px 2px 10px; margin: 10px;">'''2018.Spring Solutions (Makeup)'''</span>]
 +
| style="text-align: center;" | ''n/a''
 +
 +
|-
 +
|[https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_F.17_v01.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;">'''2017.Fall Exam 5'''</span>]
 +
| style="text-align: center;" | ''n/a''
 +
|| ''[https://www.battleacts5.ca/pdf/exam_5_(2017-2).pdf 2017.Fall Examiner's Report]''
 +
 +
|-
 +
|[https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_S.17_v01.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;">'''2017.Spring Exam 5'''</span>]
 +
| style="text-align: center;" | ''n/a''
 +
|| ''[https://www.battleacts5.ca/pdf/exam_5_(2017-1).pdf 2017.Spring Examiner's Report]''
 +
 +
|-
 +
|[https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_F.17_v01.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;">'''2017.Fall Exam 5'''</span>]
 +
| style="text-align: center;" | ''n/a''
 +
|| ''[https://www.battleacts5.ca/pdf/exam_5_(2017-2).pdf 2017.Fall Examiner's Report]''
 +
 +
|- style = "border-bottom: 2px solid;"
 +
|[https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_S.17_v01.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;">'''2017.Spring Exam 5'''</span>]
 +
| style="text-align: center;" | ''n/a''
 +
|| ''[https://www.battleacts5.ca/pdf/exam_5_(2017-1).pdf 2017.Spring Examiner's Report]''
 +
 +
|-
 +
|[https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_F.16_v01.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;">'''2016.Fall Exam 5'''</span>]
 +
| style="text-align: center;" | ''n/a''
 +
|| ''[https://www.battleacts5.ca/pdf/exam_5_(2016-2).pdf 2016.Fall Examiner's Report]''
 +
 +
|-
 +
|[https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_S.16_v01.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;">'''2016.Spring Exam 5'''</span>]
 +
| style="text-align: center;" | ''n/a''
 +
|| ''[https://www.battleacts5.ca/pdf/exam_5_(2016-1).pdf 2016.Spring Examiner's Report]''
 +
 +
|-
 +
|[https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_F.15_v01.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;">'''2015.Fall Exam 5'''</span>]
 +
| style="text-align: center;" | ''n/a''
 +
|| ''[https://www.battleacts5.ca/pdf/exam_5_(2015-2).pdf 2015.Fall Examiner's Report]''
 +
 +
|- style = "border-bottom: 2px solid;"
 +
|[https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_S.15_v01.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;">'''2015.Spring Exam 5'''</span>]
 +
| style="text-align: center;" | ''n/a''
 +
|| ''[https://www.battleacts5.ca/pdf/exam_5_(2015-1).pdf 2015.Spring Examiner's Report]''
 +
 +
|-
 +
|[https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_F.14_v01.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;">'''2014.Fall Exam 5'''</span>]
 +
| style="text-align: center;" | ''n/a''
 +
|| ''[https://www.battleacts5.ca/pdf/exam_5_(2014-2).pdf 2014.Fall Examiner's Report]''
 +
 +
|-
 +
|[https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_S.14_v01.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;">'''2014.Spring Exam 5'''</span>]
 +
| style="text-align: center;" | ''n/a''
 +
|| ''[https://www.battleacts5.ca/pdf/exam_5_(2014-1).pdf 2014.Spring Examiner's Report]''
 +
 +
|-
 +
|[https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_F.13_v01.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;">'''2013.Fall Exam 5'''</span>]
 +
| style="text-align: center;" | ''n/a''
 +
|| ''[https://www.battleacts5.ca/pdf/exam_5_(2013-2).pdf 2013.Fall Examiner's Report]''
 +
 +
|-
 +
|[https://www.battleacts5.ca/Excel/CBT/CBT_Exam_5_S.13_v01.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;">'''2013.Spring Exam 5'''</span>]
 +
| style="text-align: center;" | ''n/a''
 +
|| ''[https://www.battleacts5.ca/pdf/exam_5_(2013-1).pdf 2013.Spring Examiner's Report]''
 +
 +
|}
 +
 +
To get the most out of these files you should attempt each exam under timed conditions and then grade yourself strictly.
 +
 +
''Alice: "I've heard the F2 and F4 keys don't work in the Pearson environment. They do work in our Excel files but you've been warned for BattleDay!"''
 +
 +
[[BattleActs PowerPack - Temp]]

Latest revision as of 11:20, 24 March 2025

How to Use the PowerPack

Step 1. Build a solid understanding of how to solve exam problems

  • Our PDFs contain the core problems with step-by-step detailed solutions

Step 2. Drill to crush problems on exam day

  • Use our web-based templates to generate an infinite number of problems
  • With practice, you'll become more efficient and accurate on exam day

Step 3. Practice in an Excel/CBT like environment

  • We have a list of all the essential exam formulas from both reserving and pricing in one place

Step 4. More Practice

  • 4 original exams and past CAS exams are available.

Step 1.: Step-by-Step Solutions

Our PDFs contain the core problems and detailed step-by-step solutions in these 2 files.

Exam 5 One-stop PDF → RESERVING

Exam 5 One-stop PDF → PRICING

Step 2: Drill: Infinite Calculation Problems

If you practice on the exact same exam problem several times, you can find yourself memorizing the numbers rather than understanding the steps. To address this, we've recreated many standard problems but with the facility to generate randomized input values. That way, you won't know the answer in advance.

The link below takes you to a list of currently available infinite calculation problems. (Note that we develop new ones on an ongoing basis.) These problems are presented in a webpage but you can copy the input data from the web page and paste it into an Excel file. After you solve the problem in Excel, type or copy your answers back into the webpage to be scored by the computer.

Step 3: Practice in an Excel/CBT Environment

Reserving Problems (Excel Format)

These tables provide a listing of all the important types of problems from both reserving and pricing. If you can solve these problems, and have worked through the last several exams, you should be well prepared for anything that may come up.

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

Pricing Problems (Excel Format)

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

Step 4: More Practice

BattleActs Original Practice Exams

Exam ID Difficulty Excel Questions Excel Solutions Instructor Support
A-01 😀 Not too hard. BA Exam 5 Practice Exam: A-01 BA Exam 5 Practice Exam: A-01 (Solutions) Forum - Practice Exam 1
A-02 😁 Not too hard. BA Exam 5 Practice Exam: A-02 BA Exam 5 Practice Exam: A-02 (Solutions) Forum - Practice Exam 2
B-01 😕 A bit harder. BA Exam 5 Practice Exam: B-01 BA Exam 5 Practice Exam: B-01 (Solutions) Forum - Practice Exam 3
B-02 😭 A bit harder. BA Exam 5 Practice Exam: B-02 BA Exam 5 Practice Exam: B-02 (Solutions) Forum - Practice Exam 4

CAS Past Exams

Excel Problems Excel Solutions Examiner's Report
2019.Fall Exam 5 n/a 2019.Fall Examiner's Report
2019.Spring Exam 5 n/a 2019.Fall Examiner's Report
2018.Fall Exam 5 n/a 2018.Fall Examiner's Report
2018.Spring Exam 5 (Original) 2018.Spring Solutions (Original) n/a
2018.Spring Exam 5 (Makeup) 2018.Spring Solutions (Makeup) n/a
2017.Fall Exam 5 n/a 2017.Fall Examiner's Report
2017.Spring Exam 5 n/a 2017.Spring Examiner's Report
2017.Fall Exam 5 n/a 2017.Fall Examiner's Report
2017.Spring Exam 5 n/a 2017.Spring Examiner's Report
2016.Fall Exam 5 n/a 2016.Fall Examiner's Report
2016.Spring Exam 5 n/a 2016.Spring Examiner's Report
2015.Fall Exam 5 n/a 2015.Fall Examiner's Report
2015.Spring Exam 5 n/a 2015.Spring Examiner's Report
2014.Fall Exam 5 n/a 2014.Fall Examiner's Report
2014.Spring Exam 5 n/a 2014.Spring Examiner's Report
2013.Fall Exam 5 n/a 2013.Fall Examiner's Report
2013.Spring Exam 5 n/a 2013.Spring Examiner's Report

To get the most out of these files you should attempt each exam under timed conditions and then grade yourself strictly.

Alice: "I've heard the F2 and F4 keys don't work in the Pearson environment. They do work in our Excel files but you've been warned for BattleDay!"

BattleActs PowerPack - Temp