Difference between revisions of "Friedland13.BerqSherm"

From CAS Exam 5
Jump to navigation Jump to search
(BattleTable)
(Example C: Exponential Interpolation)
 
(300 intermediate revisions by 3 users not shown)
Line 5: Line 5:
 
==Pop Quiz==
 
==Pop Quiz==
  
 +
'''Given:'''
 +
* Suppose you have paid & reported claim ''(loss)'' triangles, and paid & reported count triangles.
  
==Keywords==
+
'''Questions:'''
 +
* What are the <u>best</u> 3 diagnostic triangles to look at for evidence of changes in case reserve adequacy. (Hint: See ''[[Friedland06.Diagnostics#Changes_in_Case_Reserve_Adequacy | Chapter 6 (Diagnostics) - Changes in Case Reserve Adequacy]]'')
 +
* What are the <u>best</u> 3 diagnostic triangles to look at for evidence of changes in claim settlement rate. (Hint: See ''[[Friedland06.Diagnostics#Changes_in_Settlement_Rate | Chapter 6 (Diagnostics) - Changes in Settlement Rate]]'')
 +
 
 +
'''BONUS:'''
 +
* For an <u>increase</u> in case reserve adequacy, do the diagnostics show <span style="color: green;">'''increases'''</span> or <span style="color: red;">'''decreases'''</span> down columns?
 +
* For an <u>increase</u> in claim settlement rate, do the diagnostics show <span style="color: green;">'''increases'''</span> or <span style="color: red;">'''decreases'''</span> down columns?
 +
 
 +
<span style="background-color: lightblue; border-radius: 5px;"> ''[[Friedland13.BerqSherm#POP_QUIZ_ANSWERS |Click for Answer]]''&nbsp;</span>
 +
 
 +
==Study Tips==
 +
 
 +
[https://www.battleacts5.ca/video_playback.php?video=video_F-13_(001)_Berquist_Sherman_Method.mp4 <span style="color: black; font-size: 12px; background-color: aqua; border: solid; border-width: 2px; border-radius: 10px; border-color: aqua; padding: 5px 10px 5px 10px; margin-top:;">'''VIDEO: F-13 (001) Berquist-Sherman Methods &rarr; 6:00'''</span>] [https://www.battleactsmain.ca/battleacts5.ca/forum5/index.php?p=/categories/f-13-berqsherm<span style="font-size: 12px; background-color: lightgrey; border: solid; border-width: 1px; border-radius: 10px; padding: 2px 10px 2px 10px; margin: 0px;">'''Forum'''</span>]
 +
 
 +
There are 2 versions of the Berquist-Sherman method:
 +
 
 +
: '''reported method''' - adjusts for changes in case reserve adequacy ''(full method <u>is</u> frequently asked on exam)''
 +
: '''paid method''' - adjusts for changes in settlement rate of claims ''(full method <u>is not</u> frequently asked on exam)''
 +
 
 +
Both methods have time-consuming calculations but the reported method is easier and is asked more often. The paid method has one particular step ''(the interpolation step)'' that is very confusing and you are not often asked to do the calculations form start to finish. For the paid method you're more likely to be asked concept questions or to perform only a portion of the calculations.
 +
 
 +
There's also a short section at the beginning of the chapter on ''Data Selection & Rearrangement''. The idea is you should first just try to select "good" data before going to the trouble of making complicated adjustments as in the Berquist-Sherman methods.
 +
 
 +
It might help to first take 30 minutes to review some of the ''[[Videos#Friedland_PART_2.2C_Chapters_3-6 | videos from chapter 6 & 7]]''.
 +
 
 +
'''Estimated study time''': 1 week ''(not including subsequent review time)''
  
 
==BattleTable==
 
==BattleTable==
Line 12: Line 39:
 
Based on past exams, the '''main things''' you need to know ''(in rough order of importance)'' are:
 
Based on past exams, the '''main things''' you need to know ''(in rough order of importance)'' are:
  
* fact A...
+
* <span style="color: green;">'''reported Berquist-Sherman method'''</span> - ''calculate ultimate / unpaid / IBNR''
* fact B...
+
* <span style="color: blue;">'''paid Berquist-Sherman method'''</span> - ''calculate ultimate / unpaid / IBNR''
  
 
: {| class='wikitable' style='width: 1000px;'
 
: {| class='wikitable' style='width: 1000px;'
Line 22: Line 49:
 
|-
 
|-
 
|| [https://www.battleacts5.ca/pdf/Exam_(2019_2-Fall)/(2019_2-Fall)_(21).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style="color: red;">'''(2019.Fall #21)'''</span>
 
|| [https://www.battleacts5.ca/pdf/Exam_(2019_2-Fall)/(2019_2-Fall)_(21).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style="color: red;">'''(2019.Fall #21)'''</span>
|| '''unpaid''': <br> - reported Berq-Sherm
+
|| <span style="color: green;">'''reported BS:'''</span> <br> - calc unpaid
 
| style="background-color: lightgrey;" |
 
| style="background-color: lightgrey;" |
 
| style="background-color: lightgrey;" |
 
| style="background-color: lightgrey;" |
Line 34: Line 61:
 
| style="background-color: lightgrey;" |
 
| style="background-color: lightgrey;" |
  
|-
+
|- style='border-bottom: 2px solid;'
 
|| [https://www.battleacts5.ca/pdf/Exam_(2019_1-Spring)/(2019_1-Spring)_(22).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2019.Spring #22)'''</span>
 
|| [https://www.battleacts5.ca/pdf/Exam_(2019_1-Spring)/(2019_1-Spring)_(22).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2019.Spring #22)'''</span>
|| '''ultimate''': <br> - reported Berq-Sherm
+
|| <span style="color: green;">'''reported BS:'''</span> <br> - calc ultimate
 
| style='background-color: lightgrey;' |
 
| style='background-color: lightgrey;' |
 
| style='background-color: lightgrey;' |
 
| style='background-color: lightgrey;' |
 
| style='background-color: lightgrey;' |
 
| style='background-color: lightgrey;' |
  
|-
+
|- style='border-bottom: 2px solid;' style='text-align: center;'
|| [https://www.battleacts5.ca/pdf/Exam_(2018_1-Spring)/(2018_1-Spring)_(21).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2018.Spring #21)'''</span>
+
|| <span style='color: red;'>'''(2018.Spring #21)'''</span>
||  
+
|| [[BattleActs PowerPack]]
 
||  
 
||  
 
||
 
||
Line 50: Line 77:
 
|-
 
|-
 
|| [https://www.battleacts5.ca/pdf/Exam_(2017_2-Fall)/(2017_2-Fall)_(24).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2017.Fall #24)'''</span>
 
|| [https://www.battleacts5.ca/pdf/Exam_(2017_2-Fall)/(2017_2-Fall)_(24).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2017.Fall #24)'''</span>
|| '''IBNR''': <br> - reported Berq-Sherm
+
|| <span style="color: green;">'''reported BS:'''</span> <br> - calc IBNR
 
|| '''alternate method''': <br> - propose & justify
 
|| '''alternate method''': <br> - propose & justify
 
| style='background-color: lightgrey;' |
 
| style='background-color: lightgrey;' |
 
| style='background-color: lightgrey;' |
 
| style='background-color: lightgrey;' |
  
|-
+
|- style='border-bottom: 2px solid;'
 
|| [https://www.battleacts5.ca/pdf/Exam_(2017_1-Spring)/(2017_1-Spring)_(22).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2017.Spring #22)'''</span>
 
|| [https://www.battleacts5.ca/pdf/Exam_(2017_1-Spring)/(2017_1-Spring)_(22).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2017.Spring #22)'''</span>
|| '''claim count adjustment''': <br> - under paid Berq-Sherm
+
|| <span style="color: blue;">'''paid BS'''</span> <br> - claim count adjustment
 
| style='background-color: lightgrey;' |
 
| style='background-color: lightgrey;' |
 
| style='background-color: lightgrey;' |
 
| style='background-color: lightgrey;' |
Line 64: Line 91:
 
|-
 
|-
 
|| [https://www.battleacts5.ca/pdf/Exam_(2016_2-Fall)/(2016_2-Fall)_(23).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2016.Fall #23)'''</span>
 
|| [https://www.battleacts5.ca/pdf/Exam_(2016_2-Fall)/(2016_2-Fall)_(23).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2016.Fall #23)'''</span>
||  
+
|| <span style="color: green;">'''reported BS'''</span>, '''BF''' <br> - calc unpaid
||  
+
| style='background-color: lightgrey;' |
||
+
| style='background-color: lightgrey;' |
||
+
| style='background-color: lightgrey;' |
  
 
|-
 
|-
 
|| [https://www.battleacts5.ca/pdf/Exam_(2016_1-Spring)/(2016_1-Spring)_(20).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2016.Spring #20)'''</span>
 
|| [https://www.battleacts5.ca/pdf/Exam_(2016_1-Spring)/(2016_1-Spring)_(20).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2016.Spring #20)'''</span>
||  
+
|| <span style="color: blue;">'''paid BS'''</span> <br> - calc ultimate
||  
+
| style='background-color: lightgrey;' |
||
+
| style='background-color: lightgrey;' |
||
+
| style='background-color: lightgrey;' |
  
|-
+
|- style='border-bottom: 2px solid;'
 
|| [https://www.battleacts5.ca/pdf/Exam_(2016_1-Spring)/(2016_1-Spring)_(21).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2016.Spring #21)'''</span>
 
|| [https://www.battleacts5.ca/pdf/Exam_(2016_1-Spring)/(2016_1-Spring)_(21).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2016.Spring #21)'''</span>
 
|| [[Friedland06.Diagnostics]]
 
|| [[Friedland06.Diagnostics]]
||  
+
|| '''ultimate''': <br> - suggest method
 
| style='background-color: lightgrey;' |
 
| style='background-color: lightgrey;' |
 
| style='background-color: lightgrey;' |
 
| style='background-color: lightgrey;' |
Line 85: Line 112:
 
|-
 
|-
 
|| [https://www.battleacts5.ca/pdf/Exam_(2015_2-Fall)/(2015_2-Fall)_(21).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2015.Fall #21)'''</span>
 
|| [https://www.battleacts5.ca/pdf/Exam_(2015_2-Fall)/(2015_2-Fall)_(21).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2015.Fall #21)'''</span>
||  
+
|| <span style="color: blue;">'''paid BS'''</span> <br> - disposal rate
||  
+
|| <span style="color: blue;">'''paid BS'''</span> <br> - distortion
||
+
| style='background-color: lightgrey;' |
||
+
| style='background-color: lightgrey;' |
  
 
|-
 
|-
Line 94: Line 121:
 
|| '''impact''': <br> - settlement rate change
 
|| '''impact''': <br> - settlement rate change
 
|| '''response''': <br> - to settlement rate change
 
|| '''response''': <br> - to settlement rate change
||
+
|| '''related methods''': <br> - rptd B-S, rptd devlpt
||
+
| style='background-color: lightgrey;' |
  
|-
+
|- style='border-bottom: 2px solid;'
 
|| [https://www.battleacts5.ca/pdf/Exam_(2015_1-Spring)/(2015_1-Spring)_(23).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2015.Spring #23)'''</span>
 
|| [https://www.battleacts5.ca/pdf/Exam_(2015_1-Spring)/(2015_1-Spring)_(23).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2015.Spring #23)'''</span>
||  
+
|| '''evaluate methods''': <br> - paid & rptd devlpt
||  
+
|| '''adjustment to method''': <br> - propose & justify
||
+
| style='background-color: lightgrey;' |
||
+
| style='background-color: lightgrey;' |
  
 
|-
 
|-
 
|| [https://www.battleacts5.ca/pdf/Exam_(2014_2-Fall)/(2014_2-Fall)_(20).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2014.Fall #20)'''</span>
 
|| [https://www.battleacts5.ca/pdf/Exam_(2014_2-Fall)/(2014_2-Fall)_(20).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2014.Fall #20)'''</span>
||  
+
|| <span style="color: green;">'''reported BS'''</span>, <span style="color: blue;">'''paid BS'''</span> <br> - calc ultimate
||  
+
| style='background-color: lightgrey;' |
||
+
| style='background-color: lightgrey;' |
||
+
| style='background-color: lightgrey;' |
  
|-
+
|- style='border-bottom: 2px solid;'
 
|| [https://www.battleacts5.ca/pdf/Exam_(2014_1-Spring)/(2014_1-Spring)_(18).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2014.Spring #18)'''</span>
 
|| [https://www.battleacts5.ca/pdf/Exam_(2014_1-Spring)/(2014_1-Spring)_(18).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2014.Spring #18)'''</span>
||  
+
|| '''ultimate''': <br> - select & apply 2 methods
||  
+
| style='background-color: lightgrey;' |
||
+
| style='background-color: lightgrey;' |
||
+
| style='background-color: lightgrey;' |
  
 
|-
 
|-
 
|| [https://www.battleacts5.ca/pdf/Exam_(2013_2-Fall)/(2013_2-Fall)_(06).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2013.Fall #6)'''</span>
 
|| [https://www.battleacts5.ca/pdf/Exam_(2013_2-Fall)/(2013_2-Fall)_(06).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2013.Fall #6)'''</span>
||  
+
|| <span style="color: green;">'''reported BS:'''</span> <br> - calc ultimate <span style="color: red;"><sup>'''1'''</sup></span>
||  
+
| style='background-color: lightgrey;' |
||
+
| style='background-color: lightgrey;' |
||
+
| style='background-color: lightgrey;' |
  
 
|-
 
|-
 
|| [https://www.battleacts5.ca/pdf/Exam_(2013_2-Fall)/(2013_2-Fall)_(21).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2013.Fall #21)'''</span>
 
|| [https://www.battleacts5.ca/pdf/Exam_(2013_2-Fall)/(2013_2-Fall)_(21).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2013.Fall #21)'''</span>
||  
+
|| <span style="color: blue;">'''paid BS'''</span> <br> - calc ultimate
||  
+
| style='background-color: lightgrey;' |
||
+
| style='background-color: lightgrey;' |
||
+
| style='background-color: lightgrey;' |
  
 
|-
 
|-
 
|| [https://www.battleacts5.ca/pdf/Exam_(2013_2-Fall)/(2013_2-Fall)_(23).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2013.Fall #23)'''</span>
 
|| [https://www.battleacts5.ca/pdf/Exam_(2013_2-Fall)/(2013_2-Fall)_(23).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2013.Fall #23)'''</span>
||  
+
|| '''operational change''': <br> - explain
||  
+
|| '''investigating the change''': <br> - questions for clms mgmt <span style="color: red;"><sup>'''2'''</sup></span>
||
+
|| '''diagnostics''': <br> - to check results <span style="color: red;"><sup>'''3'''</sup></span>
||
+
| style='background-color: lightgrey;' |
  
 
|-
 
|-
 
|| [https://www.battleacts5.ca/pdf/Exam_(2013_1-Spring)/(2013_1-Spring)_(23).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2013.Spring #23)'''</span>
 
|| [https://www.battleacts5.ca/pdf/Exam_(2013_1-Spring)/(2013_1-Spring)_(23).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2013.Spring #23)'''</span>
||  
+
|| <span style="color: green;">'''reported BS:'''</span> <br> - adjust rptd triangle
||  
+
|| '''compare IBNR''': <br> adjusted vs unadjusted
||
+
| style='background-color: lightgrey;' |
||
+
| style='background-color: lightgrey;' |
  
 
|}
 
|}
 +
 +
: <span style="color: red;"><sup>'''1'''</sup></span> This question requires knowledge of pricing. You may need to come back to it later if you haven't covered the pricing material yet.
 +
: <span style="color: red;"><sup>'''2'''</sup></span> See ''[[Friedland04.Meetings#In_Plain_English.21 | Chapter 4 - Meetings]]'' for potential questions.
 +
: <span style="color: red;"><sup>'''3'''</sup></span> Review ''[[Friedland06.Diagnostics#Diagnostics | Chapter 6 - Diagnostics]]'' but note that valid answers can include diagnostics other than those specifically discussed in chapter 6. You may also find ''[[Friedland15.Evaluation | Chapter 15 - Evaluating Methods]]'' helpful.
 +
 +
[https://www.battleacts5.ca/FC.php?selectString=**&filter=both&sortOrder=natural&colorFlag=allFlag&colorStatus=allStatus&priority=importance-high&subsetFlag=miniQuiz&prefix=Friedland13&suffix=BerqSherm&section=all&subSection=all&examRep=all&examYear=all&examTerm=all&quizNum=all<span style="font-size: 20px; background-color: lightgreen; border: solid; border-width: 1px; border-radius: 10px; padding: 2px 10px 2px 10px; margin: 10px;">'''Full BattleQuiz]'''</span> <span style="color: red;">'''You must be <u>logged in</u> or this will not work.'''</span>
  
 
==In Plain English!==
 
==In Plain English!==
  
 +
===Data Selection and Rearrangement===
 +
 +
In ''[[Friedland06.Diagnostics#Background_Information | Chapter 6]]'', we discussed the effects of changes in case reserve strength and claim settlement rate on diagnostic triangles. In ''[[Friedland07.Development#Influence_of_a_Changing_Environment_-_Scenario_1_.28Base_Case.29 | Chapter 7]]'', we investigated how changes in case reserve strength affect the development method. Here are 2 facts, you absolutely must know:
 +
 +
* a change in case reserve strength affects '''reported''' data ''(paid data <u>is not</u> affected)''
 +
* a change in settlement rate affects '''paid''' data ''(reported data <u>is not</u> affected)''
 +
 +
So, if I gave you a paid loss triangle and a reported loss triangle and told you there had been a change in case reserve strength, which triangle would you rather use to develop estimates of ultimates? It's easy: use the '''paid''' triangle because it is not affected by changes in case strength. The reported loss triangle could have distortions that cause the reported development method to either over or under-estimate the true ultimate.
 +
 +
But what if I told you there had been a change in the settlement rate of claims, then which triangle would you rather use? Again, it's easy: use the '''reported''' triangle because it is not affected by changes in settlement rate. In this situation, it's the paid triangle that's distorted so the paid development method is less likely to be accurate.
 +
 +
What we did above is called '''data selection'''. In other words, select data that's more likely to be free of distortions and try not to use data that you know may lead to inaccurate results.
 +
 +
Here are a few other examples...
 +
 +
:{| class='wikitable'
 +
|-
 +
! situation !! data selection
 +
|-
 +
|| &bull; change in definition of <u>counts</u> ''(claim versus claimant)'' <br> &bull; see ''[[Friedland11.FreqSev#FS_Method_Concepts | Chapter 11 - FS Method Key Assumptions]]'' for a simple example || &bull; use <span style="color: green;">'''exposures'''</span> in place of claim counts
 +
|-
 +
|| &bull; change in policy <u>limits</u> between policy years || &bull; use <span style="color: green;">'''policy year data '''</span> in place of accident year data
 +
|-
 +
|| &bull; <u>court decisions</u> that correlate with report date <br> &bull; see ''[[Friedland11.FreqSev#Example_D:_Method_.233_-_Disposal_Rate_Method | Chapter 11 - Disposal Rate Method]]'' for an exam problem involving a court decision || &bull; use <span style="color: green;">'''report year data'''</span> in place of accident year data
 +
|-
 +
|| &bull; significant growth or shrinkage causing a <u>shift</u> in average accident date || &bull; use <span style="color: green;">'''accident quarters'''</span> in place of accident years
 +
|-
 +
|| &bull; change in <u>mix of business</u> <br> &bull; see ''[[Friedland07.Development#Influence_of_a_Changing_Environment_-_Scenarios_5.2C6 | Chapter 7 - Scenario 6 (Change in Product Mix)]]'' for an example of a change in mix || &bull; <span style="color: green;">'''subdivide data'''</span> into more homogeneous groups
 +
|}
 +
 +
[https://www.battleacts5.ca/FC.php?selectString=**&filter=both&sortOrder=natural&colorFlag=allFlag&colorStatus=allStatus&priority=importance-high&subsetFlag=miniQuiz&prefix=Friedland13&suffix=BerqSherm&section=all&subSection=all&examRep=all&examYear=all&examTerm=all&quizNum=1<span style="font-size: 20px; background-color: aqua; border: solid; border-width: 1px; border-radius: 10px; padding: 2px 10px 2px 10px; margin: 10px;">'''mini BattleQuiz 1]'''</span> <span style="color: red;">'''You must be <u>logged in</u> or this will not work.'''</span>
 +
 +
===Berquist-Sherman Reported Method===
 +
 +
====Description of Method====
 +
 +
Here's the first fact you have to memorize:
 +
 +
:{| class='wikitable'
 +
|-
 +
|| '''Purpose of Berquist-Sherman <u>Reported</u> Method:''' &nbsp;&nbsp; Adjust reported data for distortions caused by changes in case reserve adequacy ''(case strength)''.
 +
|}
 +
 +
In practice, the first thing you should do in a reserve analysis is check for things like changes in case reserve adequacy. If there have not been changes, then you don't need the Berquist-Sherman reported adjustment. In the Pop Quiz at the top of this wiki article, we reviewed diagnostics for <u>increases</u> in case reserve adequacy:
 +
 +
: &rarr; '''<span style="color: red;">paid/reported loss</span>''', '''<span style="color: green;">average reported loss</span>''', '''<span style="color: green;">average case O/S loss</span>'''
 +
 +
Notice that the average paid loss ''(also called paid severity)'' is not listed &ndash; we learned in chapter 6 that a change in case strength does not affect paid data. But in '''step 1b''' further down, the overall severity trend is calculated from the average paid loss triangle. That might not seem right but here's the explanation:
 +
 +
* <u>Without</u> any change in case strength, there is still probably an underlying severity trend, often just due to inflation.
 +
* This severity trend would show up in <u>both</u> the paid severity and outstanding severity triangles and would be roughly the <u>same</u> in each.
 +
* Then if there <u>is</u> a change in case strength, the paid severity trend <u>would not change</u> but the outstanding severity trend <u>would change</u>
 +
* The paid severity trend is the <u>true</u> trend but the outstanding severity trend is now <u>distorted</u> due to the change in case strength
 +
* The Berquist-Sherman reported adjustment <u>removes</u> this distortion from the reported data
 +
 +
For example suppose both the paid and outstanding severity trends were 3% before any change in case strength. Then after the change in case strength, the paid severity trend is still 3%, but the outstanding severity trend is 5%. The Berquist-Sherman reported adjustment <u>removes</u> the 5% trend and <u>restates</u> or <u>detrends</u> the outstanding severity triangle back to a 3% trend.
 +
 +
Below is an exam problem that demonstrates the method. The solution in the examiner's report is very good because they write out all the intermediate steps. Note that this problem provides the severity trend of 5%. ''(You don't have to estimate it yourself.)'' Alice's solution has an extra step in case you're <u>not</u> given the severity trend and have to come up with it yourself.
 +
 +
: [https://www.battleacts5.ca/pdf/Exam_(2019_2-Fall)/(2019_2-Fall)_(21).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style="color: red;">'''(2019.Fall #21)'''</span>
 +
 +
: [https://www.battleacts5.ca/pdf/F-13_(010)_RBS_2019_Fall_Q21.pdf <span style="color: white; font-size: 12px; background-color: orchid; border: solid; border-width: 2px; border-radius: 10px; border-color: orchid; padding: 1px 3px 1px 3px; margin: 0px;">'''''Solution: 2019.Fall #21'''''</span>]
 +
 +
{| class='wikitable'
 +
|-
 +
|| For reference, here's the step-by-step procedure from Alice's solution:
 +
|}
 +
 +
* Normally you're given '''CPL''', '''CRL''', '''CPC''', '''CRC'''
 +
: ''(For a review of these abbreviations, see [[Friedland11.FreqSev#Example_D:_Method_.233_-_Disposal_Rate_Method | Chapter 11 - Disposal Rate Method]].)''
 +
 +
<span style="color: purple;>'''<u>Step 1</u>'''</span>
 +
 +
: '''Step 1a:''' calculate APL, ACOS ''(APL = Average Paid Loss or Paid Severity, ACOS = Average Case Outstanding or Outstanding Severity)''
 +
:: &rarr; APL = CPL / CPC
 +
:: &rarr; ACOS = (CRL - CPL) / (CRC - CPC)
 +
 +
: '''Step 1b:''' calculate and select severity trend using APL ''(if severity trend is not given)'', check for evidence of change in case strength using ACOS
 +
:: &rarr; calculate APL trends down columns and make selections
 +
:: &rarr; calculate ACOS trends down columns and look for changes that might indicate a change in case strength
 +
 +
<span style="color: purple;>'''<u>Step 2</u>'''</span>
 +
: '''Step 2a:''' restate ACOS by detrending backwards from latest diagonal
 +
: '''Step 2b:''' restate CRL as (restated ACOS) x (open counts) + (original CPL)
 +
:: &rarr; ''note that open counts = CRC - CPC = (cumulative reported counts) - (cumulative paid counts)''
 +
 +
<span style="color: purple;>'''<u>Step 3</u>'''</span>
 +
* apply the development method to the restated CRL triangle
 +
: ''(Just apply the standard development to the restated triangle of cumulative reported losses. Easy! Theoretically, this restated CRL is now <u>corrected</u> for any changes in case strength. All AYs should be at the same level and the development method applied to this triangle shouldn't be distorted.)''
 +
 +
====Practice Problems====
 +
 +
A couple of random practice problems where you have to select the severity trend yourself:
 +
 +
: [https://www.battleacts5.ca/pdf/F-13_(010)_RBS.pdf <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;">'''''Practice: 2 problems on the Berquist-Sherman REPORTED method'''''</span>]
 +
 +
And the quiz with a selection of old exam problems:
 +
 +
[https://www.battleacts5.ca/FC.php?selectString=**&filter=both&sortOrder=natural&colorFlag=allFlag&colorStatus=allStatus&priority=importance-high&subsetFlag=miniQuiz&prefix=Friedland13&suffix=BerqSherm&section=all&subSection=all&examRep=all&examYear=all&examTerm=all&quizNum=2<span style="font-size: 20px; background-color: aqua; border: solid; border-width: 1px; border-radius: 10px; padding: 2px 10px 2px 10px; margin: 10px;">'''mini BattleQuiz 2]'''</span> <span style="color: red;">'''You must be <u>logged in</u> or this will not work.'''</span>
 +
 +
===Berquist-Sherman Paid Method===
 +
 +
====Description of Method====
 +
 +
Here's the first fact you have to memorize:
 +
 +
:{| class='wikitable'
 +
|-
 +
|| '''Purpose of Berquist-Sherman <u>Paid</u> Method:''' &nbsp;&nbsp; Adjust paid data for distortions caused by changes in claim settlement rate.
 +
|}
 +
 +
In practice, the first thing you should do in a reserve analysis is check for things like changes in the claim settlement rate. If there have not been changes, then you don't need the Berquist-Sherman paid adjustment. In the Pop Quiz at the top of this wiki article, we reviewed diagnostics for <u>increases</u> in settlement rate:
 +
 +
: &rarr; '''<span style="color: green;">paid/reported loss</span>''', '''<span style="color: green;">paid/reported counts</span>''' or '''<span style="color: red;">average case O/S loss</span>'''
 +
 +
But there's another very useful diagnostic if you also know '''UC''' ''(Ultimate counts)'', It's called the '''CDR''' ''(Claims Disposal Rate)''.
 +
 +
:{| class='wikitable'
 +
|-
 +
|| '''CDR''' &nbsp; = &nbsp; CPC / UC
 +
|}
 +
 +
Recall CPC is Cumulative Paid Counts. And very often in exam problems on the BS Paid Method, you will be given ultimate counts. That's the case in the first BS Paid exam problem we're going to look at below. So if the ultimate counts for AY 2020 is 100, and at 12 months development you have 50 paid counts, then CDR<sub>12</sub> = 50/100 = 0.5. If at 24 months the paid counts is 80 then CDR<sub>24</sub> = 80/100 = 0.8, and so on.
 +
 +
This problem is an example of the full Berquist-Sherman paid method. <u>Don't bother</u> trying to figure out the solution in the examiner's report because Alice's solution is much clearer. It looks complicated but don't be alarmed. It's all quite easy except for the interpolation step, but don't worry if you don't completely understand the interpolation the first time through. We'll cover that in much more detail in the next section.
 +
 +
: [https://www.battleacts5.ca/pdf/Exam_(2016_1-Spring)/(2016_1-Spring)_(20).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2016.Spring #20)'''</span>
 +
 +
: [https://www.battleacts5.ca/pdf/F-13_(020)_PBS_2016_Spring_Q20.pdf <span style="color: white; font-size: 12px; background-color: orchid; border: solid; border-width: 2px; border-radius: 10px; border-color: orchid; padding: 1px 3px 1px 3px; margin: 0px;">'''''Solution: 2016.Spring #20'''''</span>]
 +
 +
{| class='wikitable'
 +
|-
 +
|| For reference, here's the step-by-step procedure from Alice's solution:
 +
|}
 +
 +
* Normally you're given '''CPC''', '''UC''', '''CPL'''
 +
: ''(For a review of these abbreviations, see [[Friedland11.FreqSev#Example_D:_Method_.233_-_Disposal_Rate_Method | Chapter 11 - Disposal Rate Method]].)''
 +
 +
<span style="color: brown;>'''<u>Step 1</u>'''</span>
 +
 +
: '''Step 1a:''' calculate CDR
 +
:: &rarr; This is to check for changes in claim settlement rate. Increases down columns generally indicate an increase in settlement rate.
 +
:: &rarr; Make CDR selections for each column. <u>Do not</u> select the average. <u>Do</u> select the most recent diagonal.
 +
 +
: '''Step 1b:''' restate CPC using the CDR from step 1a
 +
:: &rarr; This is done by multiplying the '''UC''' for each AY by the vector of selected '''CDRs'''
 +
 +
<span style="color: brown;>'''<u>Step 2</u>'''</span>
 +
* restate CPL using either linear or exponential interpolation
 +
: ''(Many students find this step confusing. We'll discuss it in detail further down. Don't worry if you don't follow it the first time through.)''
 +
 +
<span style="color: brown;>'''<u>Step 3</u>'''</span>
 +
* apply the development method to the restated CPL triangle
 +
: ''(Just apply the standard development to the restated triangle of cumulative paid losses. This should be easy for you! Theoretically, this restated CPL is now <u>corrected</u> for any changes in the claim settlement rate. All AYs should be at the same level and the development method applied to this triangle shouldn't be distorted.)''
 +
 +
====Interpolation Step in BS Paid Method====
 +
 +
If you've read the Chapter 13 in the Friedland source text, you may have noticed that linear interpolation is not discussed. The source text only explains exponential interpolation, but here's an exam problem that specifically asks you to use linear interpolation. Don't do it now. I just wanted to point that out.
 +
 +
: [https://www.battleacts5.ca/pdf/Exam_(2013_2-Fall)/(2013_2-Fall)_(21).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2013.Fall #21)'''</span>
 +
 +
We're going to isolate and study the interpolation step of the Berquist-Sherman paid method in detail. Then when you attempt a full BS paid problem, it should go smoothly.
 +
 +
=====Example A: Linear Interpolation=====
 +
 +
Suppose you're given 2 points on the real plane:
 +
 +
* (x<sub>0</sub>, y<sub>0</sub>) = (10,500)
 +
* (x<sub>1</sub>, y<sub>1</sub>) = (20,600)
 +
 +
'''Question 1''': Use linear interpolation to find the y-value corresponding to x = 16.
 +
 +
'''Answer''':
 +
* y &nbsp;= &nbsp; [(16 - 10) / (20 - 10)] * (600 - 500) + 500 &nbsp; = &nbsp; <u>560</u>
 +
 +
Actually, the formula makes it harder to see what's going on. Because the numbers are so simple, you can easily see that x = 16 is 60% of the way between 10 and 20. ''(That's the quantity inside the square brackets.)'' Then the corresponding y-value must also be 60% of the way between 500 and 600 which is obviously 560.
 +
 +
Of course, if the numbers aren't so simple you might not be able to do the calculation in your head. Suppose you're now given:
 +
 +
* (x<sub>0</sub>, y<sub>0</sub>) = (21.2, 378.6)
 +
* (x<sub>1</sub>, y<sub>1</sub>) = (64.7, 982.0)
 +
 +
'''Question 2''': Use linear interpolation to find the y-value corresponding to x = 31.2.
 +
 +
'''Answer''':
 +
* y = [(31.2 - 21.2) / (64.7 - 21.2)] * (982.0 - 378.6) + 378.6 = <u>517.3</u>
 +
 +
You can write out the formula as shown below, but I don't think this is the most helpful way to think about it:
 +
 +
* y &nbsp; = &nbsp; [ (x - x<sub>0</sub>) / (x<sub>1</sub> - x<sub>0</sub>) ] &nbsp; * &nbsp; (y<sub>1</sub> - y<sub>0</sub>) + y<sub>0</sub>
 +
 +
Think about it like this instead:
 +
 +
:{| class='wikitable'
 +
|-
 +
|| '''linear interpolation:''' &nbsp; y &nbsp;= &nbsp; [ proportional distance of x from x<sub>0</sub> ] &nbsp; * &nbsp; (y<sub>1</sub> - y<sub>0</sub>) &nbsp; + &nbsp; y<sub>0</sub>
 +
|}
 +
 +
In terms of high school algebra, you're basically just fitting a linear equation ''y = mx + b'' to the given points and then using that equation to get the ''new y-value'' corresponding to the ''given x-value.'' But you don't actually have to find ''m'' and ''b''. That would take too long. If you understand how interpolation works intuitively, you can do it much quicker.
 +
 +
=====Example B: Linear Interpolation Applied to Paid Data=====
 +
 +
Instead of ''x-values'' and ''y-values'' we're now going to use ''paid counts'' and ''paid losses'' which is what you have in the Berquist-Sherman paid method. Suppose you're given the following data for AY 2020.
 +
 +
:{| class='wikitable' style='text-align: center;'
 +
|-
 +
! data type !! 12-months !! 24-months !! 36-months !! 48-months
 +
|-
 +
|| '''CPC''' || 10 || 20  || 25  || 28
 +
|-
 +
|| '''CPL''' || 500 || 600 || 640 || 670
 +
|}
 +
 +
Remember the first step of the BS paid method is to calculate CDR ''(Claims Disposal Rate)'' then use it to restate CPC ''(Cumulative Paid Counts)''. Let's suppose you did that and found the restated CPC values to be:
 +
 +
:{| class='wikitable' style='text-align: center;'
 +
|-
 +
! data type !! 12-months !! age 24-months !! age 36-months !! age 48-months
 +
|-
 +
|| '''restated CPC''' || <span style="color: green;">'''15'''</span> || <span style="color: green;">'''18'''</span>  || <span style="color: green;">'''24'''</span>  || <span style="color: green;">'''28'''</span>
 +
|-
 +
|| '''restated CPL''' || <span style="color: red;">'''?'''</span> || <span style="color: red;">'''?'''</span> || <span style="color: red;">'''?'''</span> || <span style="color: red;">'''?'''</span>
 +
|}
 +
 +
The '''interpolation step''' is finding the corresponding restated CPL-values in the above table. Let's do them one by one:
 +
 +
: '''12-months''':
 +
:: &rarr; since restated CPC<sub>12</sub> = 15 is within the 12-24 interval of the <u>original</u> CPC-values, we do the interpolation using original CPC and CPL values as follows:
 +
::* (x<sub>0</sub>, y<sub>0</sub>) &nbsp; = &nbsp; (CPC<sub>12</sub>, CPL<sub>12</sub>) &nbsp; = &nbsp; (10, 500)
 +
::* (x<sub>1</sub>, y<sub>1</sub>) &nbsp; = &nbsp; (CPC<sub>24</sub>, CPL<sub>24</sub>) &nbsp; = &nbsp; (20, 600)
 +
 +
:: &rarr; restated CPL<sub>12</sub> &nbsp; = &nbsp; [ (15 - 10) / (20 - 10) ] * (600 - 500) + 500 &nbsp; = &nbsp; <u>550</u>
 +
 +
: '''24-months''':
 +
:: &rarr; since restated CPC<sub>24</sub> = 18 is '''still''' within the 12-24 interval of the <u>original</u> CPC-values, we do the interpolation using the same original CPC and CPL values as before:
 +
::* (CPC<sub>12</sub>, CPL<sub>12</sub>) &nbsp; = &nbsp; (10, 500)
 +
::* (CPC<sub>24</sub>, CPL<sub>24</sub>) &nbsp; = &nbsp; (20, 600)
 +
 +
:: &rarr; restated CPL<sub>24</sub> &nbsp; = &nbsp; [ (18 - 10) / (20 - 10) ] * (600 - 500) + 500 &nbsp; = &nbsp; <u>580</u>
 +
 +
: '''36-months''':
 +
:: &rarr; since restated CPC<sub>36</sub> = 24 is within the 24-36 interval of the <u>original</u> CPC-values, we do the interpolation using original CPC and CPL values as follows:
 +
::* (CPC<sub>24</sub>, CPL<sub>24</sub>) &nbsp; = &nbsp; (20, 600)
 +
::* (CPC<sub>36</sub>, CPL<sub>36</sub>) &nbsp; = &nbsp; (25, 640)
 +
 +
:: &rarr; restated CPL<sub>36</sub> &nbsp; = &nbsp; [ (24 - 20) / (25 - 20) ] * (640 - 600) + 600 &nbsp; = &nbsp; <u>632</u>
 +
 +
: '''48-months''':
 +
:: &rarr; if we assume the 48-month value is the lastest diagonal then the restated CPC and CPL values are the same as the orignal values and <u>no calculation</u> is necessary
 +
:: &rarr; restated CPL<sub>48</sub> &nbsp; = &nbsp;  original CPL<sub>48</sub> &nbsp; = &nbsp; <u>670</u>
 +
 +
: '''Bonus Question 1:''' what if restated CPC<sub>36</sub> = 26 ''(instead of 24)''
 +
:: &rarr; if restated CPC<sub>36</sub> = 26 then you have to use a different interval '''and this is the part that confuses people'''. You have to notice that 26 is in the original 36-48 CPC-interval and then use the original CPC and CPL values corresponding to that interval:
 +
::* (CPC<sub>36</sub>, CPL<sub>36</sub>) &nbsp; = &nbsp; (25, 640)
 +
::* (CPC<sub>48</sub>, CPL<sub>48</sub>) &nbsp; = &nbsp; (28, 670)
 +
 +
:: &rarr; restated CPL<sub>36</sub> &nbsp; = &nbsp; [ (26 - 25) / (28 - 25) ] * (670 - 640) + 640 &nbsp; = &nbsp; <u>650</u>
 +
 +
: '''Bonus Question 2:''' what if restated CPC<sub>12</sub> = 9 ''(instead of 15)''
 +
:: &rarr; if restated CPC<sub>12</sub> = 9 then you have a '''choice'''. You '''could''' use the same interval as we did for interpolating the paid value of 15 and you would get:
 +
::* CPL<sub>12</sub> = [ (9 - 10) / (20 - 10) ] * (600-500) + 500 = <u>490</u>
 +
:: &rarr; '''Or''', use the origin (0,0) as your other interpolation point as follows, which I think makes more sense because if CPC = 0 then CPL = 0 also. ''(Note you may get a different answer but the source text doesn't specify a method so either should be acceptable.)''
 +
::* (CPC<sub>0</sub>, CPL<sub>0</sub>) &nbsp; = &nbsp; (0, 0)
 +
::* (CPC<sub>12</sub>, CPL<sub>12</sub>) &nbsp; = &nbsp; (10, 500)
 +
 +
:: &rarr; restated CPL<sub>12</sub> &nbsp; = &nbsp; [ (9 - 0) / (10 - 0) ] * (500 - 0) + 0 &nbsp; = &nbsp; <u>450</u>
 +
 +
Now you can attempt <span style='color: red;'>'''(2013.Fall #21)'''</span>. The examiner's report performs their linear interpolation using '''selected disposal rates''' without explicitly calculating the restated paid counts. This is potentially quicker than my method but it's easier to make a mistake. You can decide for yourself how you'd rather do it but the more steps you write out, the more partial credit you'll get if your final answer isn't exactly right.
 +
 +
Alice's solution below shows both linear and exponential interpolation even though the official problem asked only for linear interpolation. ''(If you're asked to perform exponential interpolation on the exam, you should always be given the parameters for the exponential regression.)''
 +
 +
: [https://www.battleacts5.ca/pdf/Exam_(2013_2-Fall)/(2013_2-Fall)_(21).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2013.Fall #21)'''</span>
 +
: [https://www.battleacts5.ca/pdf/F-13_(020)_PBS_2013_Fall_Q21.pdf <span style="color: white; font-size: 12px; background-color: orchid; border: solid; border-width: 2px; border-radius: 10px; border-color: orchid; padding: 1px 3px 1px 3px; margin: 0px;">'''''Solution: 2013.Fall #21'''''</span>]
 +
 +
And here's the solution to <span style='color: red;'>'''(2016.Spring #20)'''</span> using both linear and exponential interpolation. ''(The question asked only for exponential interpolation.)''
 +
 +
: [https://www.battleacts5.ca/pdf/Exam_(2016_1-Spring)/(2016_1-Spring)_(20).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2016.Spring #20)'''</span>
 +
: [https://www.battleacts5.ca/pdf/F-13_(020)_PBS_2016_Spring_Q20.pdf <span style="color: white; font-size: 12px; background-color: orchid; border: solid; border-width: 2px; border-radius: 10px; border-color: orchid; padding: 1px 3px 1px 3px; margin: 0px;">'''''Solution: 2016.Spring #20'''''</span>]
 +
 +
=====Example C: Exponential Interpolation=====
 +
 +
Let's revisit the first problem from ''[[Friedland13.BerqSherm#Example_A:_Linear_Interpolation | Example A: Linear Interpolation]]'' but this time we're going to use exponential intepolation. Suppose you're given 2 points on the real plane:
 +
 +
* (x<sub>0</sub>, y<sub>0</sub>) = (10,500)
 +
* (x<sub>1</sub>, y<sub>1</sub>) = (20,600)
 +
 +
Suppose you're also given the regression parameters ''a = 417'' and ''b = 0.01840'' for the exponential regression ''y = ae<sup>bx</sup>.
 +
 +
'''Question 1''': Use <u>exponential</u> interpolation to find the y-value corresponding to x = 16.
 +
 +
'''Answer''': All you have to do is substitute x = 16.
 +
* y &nbsp; = &nbsp; 417 * e<sup>(0.01840 * 16)</sup> &nbsp; = &nbsp; <u>559.7</u>
 +
 +
This is very close to the answer of 560 you get with linear interpolation. Exponential interpolation in a Berquist-Sherman problem is generally easier than linear interpolation because you will be given the exponential regression parameters.
 +
 +
Let's now do a problem that's closer to what you'll have to do on the exam using ''paid counts'' and ''paid losses''. We did this exact problem earlier using linear interpolation but here you are also given the exponential regression parameters for each successive pair of (count, loss) values.
 +
 +
:{| class='wikitable' style='text-align: center;'
 +
|-
 +
 +
|-
 +
! data type !! 12-months !! 24-months !! 36-months !! 48-months
 +
|-
 +
|| '''CPC''' || 10 || 20  || 25  || 28
 +
|-
 +
|| '''CPL''' || 500 || 600 || 640 || 670
 +
|}
 +
 +
:{| class='wikitable' style='text-align: center;'
 +
|-
 +
! rowspan="3" | <br> AY 2020|| colspan="2" | 0-12  || colspan="2" | 12-24 || colspan="2" | 24-36 || colspan="2" | 36-48
 +
|-
 +
| style="width: 110px; background-color: lightgreen;" | a || style="width: 110px; background-color: aqua;" | b || style="width: 110px; background-color: lightgreen;" | a || style="width: 110px; background-color: aqua" | b || style="width: 110px; background-color: lightgreen;" | a || style="width: 110px; background-color: aqua" | b || style="width: 110px; background-color: lightgreen;" | a || style="width: 110px; background-color: aqua" | b
 +
|-
 +
|| ''use 12-24 values'' || ''use 12-24 values'' || 417  || 0.01840 || 463  || 0.01299 || 437  || 0.01539
 +
|}
 +
 +
The regression parameters for each interval are based on these pairs of given values:
 +
 +
: '''12-24:''' uses (10, 500) & (20, 600)
 +
: '''24-36:''' uses (20, 600) & (25, 640)
 +
: '''36-48:''' uses (25, 640) & (28, 670)
 +
 +
Remember the first step of the BS paid method is to calculate CDR ''(Claims Disposal Rate)'' then use it to restate CPC ''(Cumulative Paid Counts)''. Let's suppose you did that and found the restated CPC values to be:
 +
 +
:{| class='wikitable' style='text-align: center;'
 +
|-
 +
! data type !! 12-months !! age 24-months !! age 36-months !! age 48-months
 +
|-
 +
|| '''restated CPC''' || <span style="color: green;">'''15'''</span> || <span style="color: green;">'''18'''</span>  || <span style="color: green;">'''24'''</span>  || <span style="color: green;">'''28'''</span>
 +
|-
 +
|| '''restated CPL''' || <span style="color: red;">'''?'''</span> || <span style="color: red;">'''?'''</span> || <span style="color: red;">'''?'''</span> || <span style="color: red;">'''?'''</span>
 +
|}
 +
 +
The '''interpolation step''' is finding the corresponding restated CPL-values in the above table. Let's do them one by one:
 +
 +
: '''12-months''':
 +
:: &rarr; since restated CPC<sub>12</sub> = 15 is within the 12-24 interval of the <u>original</u> CPC-values, we use the ''a'' and ''b'' for the 12-24 range:
 +
:: &rarr; restated CPL<sub>12</sub> &nbsp; = &nbsp; 417 * e<sup>(0.01840 * 15)</sup> &nbsp; = &nbsp; <u>549.5</u>
 +
 +
: '''24-months''':
 +
:: &rarr; since restated CPC<sub>24</sub> = 18 is '''still''' within the 12-24 interval of the <u>original</u> CPC-values, we use the ''a'' and ''b'' for the 12-24 range as before:
 +
:: &rarr; restated CPL<sub>24</sub> &nbsp; = &nbsp; 417 * e<sup>(0.01840 * 18)</sup> &nbsp; = &nbsp; <u>580.7</u>
 +
 +
: '''36-months''':
 +
:: &rarr; since restated CPC<sub>36</sub> = 24 is within the 24-36 interval of the <u>original</u> CPC-values, we use the ''a'' and ''b'' for the 24-36 range:
 +
:: &rarr; restated CPL<sub>36</sub> &nbsp; = &nbsp; 463 * e<sup>(0.01299 * 24)</sup> &nbsp; = &nbsp; <u>632.4</u>
 +
 +
: '''48-months''':
 +
:: &rarr; if we assume the 48-month value is the lastest diagonal then the restated CPC and CPL values are the same as the orignal values and <u>no calculation</u> is necessary
 +
:: &rarr; restated CPL<sub>48</sub> &nbsp; = &nbsp;  original CPL<sub>48</sub> &nbsp; = &nbsp; <u>670</u>
 +
 +
: '''Bonus Question 1:''' what if restated CPC<sub>36</sub> = 26 ''(instead of 24)''
 +
:: &rarr; if restated CPC<sub>36</sub> = 26 then you have to use a different interval '''and this is the part that confuses people'''. You have to notice that 26 is in the original 36-48 CPC-interval and then use the ''a'' and ''b'' for the 36-48 range:
 +
:: &rarr; restaed CPL<sub>36</sub> &nbsp; = &nbsp; 437 * e<sup>(0.01539 * 26)</sup> &nbsp; = &nbsp; <u>652.0</u>
 +
 +
: '''Bonus Question 2:''' what if restated CPC<sub>12</sub> = 9 ''(instead of 15)''
 +
:: &rarr; if restated CPC<sub>12</sub> = 9 then unlike with linear interpolation you have <span style="color: red;>'''no choice'''</span>. You <span style="color: red;>'''must'''</span> use the '''12-24''' parameters. You cannot perform a regression on the '''0-12''' interval because an exponential curve cannot pass through the origin and there is no other logical left endpoint for the '''0-12''' interval.
 +
::* CPL<sub>12</sub> &nbsp; = &nbsp; 417 * e<sup>(0.01840 * 9)</sup> &nbsp; = &nbsp; <u>492.1</u>
 +
 +
====Practice Problems====
 +
 +
Here are 2 problems that deal only with the <u>interpolation step</u> of the Berquist-Sherman paid method. If you're confident with interpolation, you can skip these.
 +
 +
: [https://www.battleacts5.ca/pdf/F-13_(022)_PBS_Interpolation_v2.pdf <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;">'''''Practice: 2 problems on Berquist-Sherman Interpolation'''''</span>]
 +
 +
And here are 2 <u>full practice problems</u> on the Berquist-Sherman paid method:
 +
 +
: [https://www.battleacts5.ca/pdf/F-13_(020)_PBS_v3.pdf <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;">'''''Practice: 2 problems on the Berquist-Sherman PAID method'''''</span>]
 +
 +
And finally, here's the quiz with old exam problems:
 +
 +
[https://www.battleacts5.ca/FC.php?selectString=**&filter=both&sortOrder=natural&colorFlag=allFlag&colorStatus=allStatus&priority=importance-high&subsetFlag=miniQuiz&prefix=Friedland13&suffix=BerqSherm&section=all&subSection=all&examRep=all&examYear=all&examTerm=all&quizNum=3<span style="font-size: 20px; background-color: aqua; border: solid; border-width: 1px; border-radius: 10px; padding: 2px 10px 2px 10px; margin: 10px;">'''mini BattleQuiz 3]'''</span> <span style="color: red;">'''You must be <u>logged in</u> or this will not work.'''</span>
 +
 +
===BS Methods Combined===
 +
 +
Sometimes you have a situation where there's been both a change in claim settlement rate <u>and</u> and change in case reserve adequacy. In this case you might want to apply both Berquist-Sherman methods to your data. Recall that for the BS Reported Method, you'd typically be given:
 +
 +
* '''CPL''', '''CRL''', '''CPC''', '''CRC'''
 +
 +
For the BS Paid Method, you'd have:
 +
 +
* '''CPC''', '''UC''', '''CPL'''
 +
 +
So the only extra piece of information you need for the paid method is '''UC'''. Putting this all together, your starting point for applying both Berquist-Sherman methods is these 5 items:
 +
 +
:{| class='wikitable'
 +
|-
 +
|| '''Data Needed for Both BS Methods:''' &nbsp;&nbsp; <span style="color: red;">'''CPL'''</span>, <span style="color: red;">'''CRL'''</span>, <span style="color: red;">'''CPC'''</span>, <span style="color: red;">'''CRC'''</span>, <span style="color: red;">'''UC'''</span>
 +
|}
 +
 +
You <u>must</u> do the BS paid adjustment first to obtain:
 +
 +
* restated CPC, restated CPL
 +
 +
Then feed these into the BS reported adjustment. That means you use the following data as your starting point for the BS reported adjustment:
 +
 +
* <span style="color: red;">'''restated CPL'''</span>, '''CRL''', <span style="color: red;">'''restated CPC'''</span>, '''CRC'''
 +
 +
Here's an exam problem where you have to do this. It looks harder than it really is. You just need to keep your work organized. They help you out by giving you the interpolated values for the BS paid method so you don't have to stop and calculate them yourself.
 +
 +
: [https://www.battleacts5.ca/pdf/Exam_(2014_2-Fall)/(2014_2-Fall)_(20).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2014.Fall #20)'''</span>
 +
 +
:{| class='wikitable'
 +
|- style='background-color: lightgreen;'
 +
|| '''Alice's BS Combined Hint:''' &nbsp; Do the paid adjustment <u>first</u>. &nbsp; Do the reported adjustment <u>second</u>. &nbsp; ''Simple!'' &nbsp; :-)
 +
|}
 +
 +
===BS Method Concepts===
 +
 +
Memorize the answers to these next 2 items:
 +
 +
:{| class='wikitable'
 +
|-
 +
|| '''Question''': identify <u>advantages</u> of the Berquist-Sherman methods
 +
|}
 +
 +
:: '''B-S Paid method''':
 +
::* corrects for changes in claim settlement rate so the ''[[Friedland07.Development#Development_Method_-_The_Key_Assumption | Key Assumption]]'' of the development method holds
 +
 +
:: '''B-S Reported method''':
 +
::* corrects for changes in case reserve adequacy so the ''[[Friedland07.Development#Development_Method_-_The_Key_Assumption | Key Assumption]]'' of the development method holds
 +
 +
:{| class='wikitable'
 +
|-
 +
|| '''Question''': identify <u>disadvantages</u> of the Berquist-Sherman methods
 +
|}
 +
 +
:: '''B-S Paid method''':
 +
::* assumes changes in settlement rate apply to all claims uniformly ''(paid losses are proportional to closed counts)''
 +
::: ''(won't be true if small claims settle faster and large claims settle more slowly)''
 +
 +
:: '''B-S Reported method''':
 +
::* very sensitive to the selected trend
 +
 +
Here's a great exam problem that tests whether you really understand what the Berquist-Sherman methods are doing and/or not doing. You're told that an insurer began prioritizing small claims so that small claims are now being settled faster. You're then asked to explain why neither the paid nor reported development method will work. ''(See discussion below.)''
 +
 +
: [https://www.battleacts5.ca/pdf/Exam_(2015_1-Spring)/(2015_1-Spring)_(23).pdf <span style='font-size: 12px; background-color: yellow; border: solid; border-width: 1px; border-radius: 5px; padding: 2px 5px 2px 5px; margin: 5px;'>E</span>] <span style='color: red;'>'''(2015.Spring #23)'''</span>
 +
 +
Part (a.i), explaining why paid development won't work is easy:
 +
 +
* an increase in settlement rate violates the ''[[Friedland07.Development#Development_Method_-_The_Key_Assumption | Key Assumption]]'' of the development method, that future loss development is similar to development in prior years
 +
 +
Part (a.ii), explaining why reported development won't work is a little trickier and you should read the 3 sample answers in the examiner's report which I've paraphrased below. Note that for sample answer 2, the conclusion is that reported development <u>will</u> work:
 +
 +
# if small claims are prioritized then large claims may be given less attention and will develop differently than in the past ''(so the [[Friedland07.Development#Development_Method_-_The_Key_Assumption | Key Assumption]] of the development method is violated)''
 +
# if case reserves for small claims are accurate then settling them more quickly has no effect on reported losses ''(you may have to think about that for a minute &ndash; if case reserves were <u>deficient</u>/<u>redundant</u>, then as soon as a claim is paid and closed for the higher/lower amount the reported loss would immediately get bumped up/down to reflect that '''but''' if the case reserves were <u>correct</u> the reported losses would not require adjustment and the reported development method would work)''
 +
# if case reserves for small claims are <u>deficient</u>/<u>redundant</u> then reported losses would be distorted as explained in the previous bullet point
 +
 +
Part (b) of this problem goes deeper and many candidates did not answer correctly. When we talk in general about an increase in settlement rate, we're usually assuming the settlement rate increases '''for all claims'''. In other words, both small claims and large claims are settled faster. What often happens however is that '''only small claims''' are settled faster. This is the situation in this exam problem and this has a couple of knock-on effects:
 +
 +
* paid severity will <span style="color: red;">'''decrease'''</span> at earlier development periods
 +
* outstanding severity will <span style="color: green;">'''increase'''</span> at later development periods
 +
 +
If only small claims are settled faster then the Berquist-Sherman adjustments '''will not work'''. The paid BS adjustment won't work because the key assumption is violated:
 +
 +
:{| class='wikitable'
 +
|-
 +
|| '''Key Assumption (Paid Berquist-Sherman):''' &nbsp;&nbsp; Paid losses are proportional to closed counts
 +
|}
 +
 +
:* paid losses will be smaller relative to closed counts at early development periods ''(because small claims are settled faster)''
 +
:* future paid losses will be larger relative to closed counts at later development periods ''(because large claims are all that's left)''
 +
 +
In other words, the proportionality is destroyed by settling some but not all claims faster. Fortunately there's an alternate strategy that's more likely to work:
 +
 +
:{| class='wikitable'
 +
|-
 +
|| '''Alternate Strategy:''' &nbsp;&nbsp; Separate small claims and large claims into different triangles and analyze each individually
 +
|}
 +
 +
That's what you had to notice to get credit in part (b) of this exam problem. You can then apply the paid B-S adjustment separately to the small claims data and the large claims data because the key assumption is more likely to hold for each individually.
 +
 +
An interesting side note is that the reported Berquist-Sherman adjust <u>will not work either</u>. If you're not careful, you might interpret the increase in outstanding severity as increase in case reserve strength. We learned in ''[[Friedland06.Diagnostics#Changes_in_Case_Reserve_Adequacy | Chapter 6 - Changes in Case Reserve Adequacy]]'' that an increase in case reserve strength <u>will cause</u> an increase in outstanding severity, but the reverse is <u>not</u> true. An increase in outstanding severity could have other causes and if it isn't due to an increase in case reserve strength, then the reported Berquist-Sherman adjustment won't work. ''(The reported B-S adjustment is specifically to correct for changes in case strength.)''
 +
 +
===Extra Exam Problems===
 +
 +
[https://www.battleacts5.ca/FC.php?selectString=**&filter=both&sortOrder=natural&colorFlag=allFlag&colorStatus=allStatus&priority=importance-high&subsetFlag=miniQuiz&prefix=Friedland13&suffix=BerqSherm&section=all&subSection=all&examRep=all&examYear=all&examTerm=all&quizNum=all<span style="font-size: 20px; background-color: lightgreen; border: solid; border-width: 1px; border-radius: 10px; padding: 2px 10px 2px 10px; margin: 10px;">'''Full BattleQuiz]'''</span> <span style="color: red;">'''You must be <u>logged in</u> or this will not work.'''</span>
  
 
==POP QUIZ ANSWERS==
 
==POP QUIZ ANSWERS==
 +
 +
* To detect changes in case reserve adequacy the best 3 diagnostics to look at are:
 +
: &rarr; '''<span style="color: red;">paid/reported loss</span>''', '''<span style="color: green;">average reported loss</span>''', '''<span style="color: green;">average case O/S loss</span>'''
 +
 +
* To detect changes in claim settlement rate the best 3 diagnostics to look at are:
 +
: &rarr; '''<span style="color: green;">paid/reported loss</span>''', '''<span style="color: green;">paid/reported counts</span>''' or '''<span style="color: red;">average case O/S loss</span>'''
 +
 +
* '''BONUS:''' For an <u>increase</u> in case reserve adequacy and an <u>increase</u> in claim settlement rate, '''<span style="color: green;">green font</span>''' indicates an <u>increase</u> down columns in the diagnostic triangles and '''<span style="color: red;">red font</span>''' indicates a <u>decrease</u>.
 +
 +
<html><a href="javascript:history.go(-1)">Go back</a></html>

Latest revision as of 20:50, 31 July 2024

Reading: Friedland, J.F., Estimating Unpaid Claims Using Basic Techniques, Casualty Actuarial Society, Third Version, July 2010. The Appendices are excluded.

Chapter 13: Berquist-Sherman Methods

Pop Quiz

Given:

  • Suppose you have paid & reported claim (loss) triangles, and paid & reported count triangles.

Questions:

BONUS:

  • For an increase in case reserve adequacy, do the diagnostics show increases or decreases down columns?
  • For an increase in claim settlement rate, do the diagnostics show increases or decreases down columns?

Click for Answer 

Study Tips

VIDEO: F-13 (001) Berquist-Sherman Methods → 6:00 Forum

There are 2 versions of the Berquist-Sherman method:

reported method - adjusts for changes in case reserve adequacy (full method is frequently asked on exam)
paid method - adjusts for changes in settlement rate of claims (full method is not frequently asked on exam)

Both methods have time-consuming calculations but the reported method is easier and is asked more often. The paid method has one particular step (the interpolation step) that is very confusing and you are not often asked to do the calculations form start to finish. For the paid method you're more likely to be asked concept questions or to perform only a portion of the calculations.

There's also a short section at the beginning of the chapter on Data Selection & Rearrangement. The idea is you should first just try to select "good" data before going to the trouble of making complicated adjustments as in the Berquist-Sherman methods.

It might help to first take 30 minutes to review some of the videos from chapter 6 & 7.

Estimated study time: 1 week (not including subsequent review time)

BattleTable

Based on past exams, the main things you need to know (in rough order of importance) are:

  • reported Berquist-Sherman method - calculate ultimate / unpaid / IBNR
  • paid Berquist-Sherman method - calculate ultimate / unpaid / IBNR
reference part (a) part (b) part (c) part (d)
E (2019.Fall #21) reported BS:
- calc unpaid
E (2019.Spring #14) accuracy of paid devlpt:
- evaluate
E (2019.Spring #22) reported BS:
- calc ultimate
(2018.Spring #21) BattleActs PowerPack
E (2017.Fall #24) reported BS:
- calc IBNR
alternate method:
- propose & justify
E (2017.Spring #22) paid BS
- claim count adjustment
E (2016.Fall #23) reported BS, BF
- calc unpaid
E (2016.Spring #20) paid BS
- calc ultimate
E (2016.Spring #21) Friedland06.Diagnostics ultimate:
- suggest method
E (2015.Fall #21) paid BS
- disposal rate
paid BS
- distortion
E (2015.Spring #22) impact:
- settlement rate change
response:
- to settlement rate change
related methods:
- rptd B-S, rptd devlpt
E (2015.Spring #23) evaluate methods:
- paid & rptd devlpt
adjustment to method:
- propose & justify
E (2014.Fall #20) reported BS, paid BS
- calc ultimate
E (2014.Spring #18) ultimate:
- select & apply 2 methods
E (2013.Fall #6) reported BS:
- calc ultimate 1
E (2013.Fall #21) paid BS
- calc ultimate
E (2013.Fall #23) operational change:
- explain
investigating the change:
- questions for clms mgmt 2
diagnostics:
- to check results 3
E (2013.Spring #23) reported BS:
- adjust rptd triangle
compare IBNR:
adjusted vs unadjusted
1 This question requires knowledge of pricing. You may need to come back to it later if you haven't covered the pricing material yet.
2 See Chapter 4 - Meetings for potential questions.
3 Review Chapter 6 - Diagnostics but note that valid answers can include diagnostics other than those specifically discussed in chapter 6. You may also find Chapter 15 - Evaluating Methods helpful.

Full BattleQuiz You must be logged in or this will not work.

In Plain English!

Data Selection and Rearrangement

In Chapter 6, we discussed the effects of changes in case reserve strength and claim settlement rate on diagnostic triangles. In Chapter 7, we investigated how changes in case reserve strength affect the development method. Here are 2 facts, you absolutely must know:

  • a change in case reserve strength affects reported data (paid data is not affected)
  • a change in settlement rate affects paid data (reported data is not affected)

So, if I gave you a paid loss triangle and a reported loss triangle and told you there had been a change in case reserve strength, which triangle would you rather use to develop estimates of ultimates? It's easy: use the paid triangle because it is not affected by changes in case strength. The reported loss triangle could have distortions that cause the reported development method to either over or under-estimate the true ultimate.

But what if I told you there had been a change in the settlement rate of claims, then which triangle would you rather use? Again, it's easy: use the reported triangle because it is not affected by changes in settlement rate. In this situation, it's the paid triangle that's distorted so the paid development method is less likely to be accurate.

What we did above is called data selection. In other words, select data that's more likely to be free of distortions and try not to use data that you know may lead to inaccurate results.

Here are a few other examples...

situation data selection
• change in definition of counts (claim versus claimant)
• see Chapter 11 - FS Method Key Assumptions for a simple example
• use exposures in place of claim counts
• change in policy limits between policy years • use policy year data in place of accident year data
court decisions that correlate with report date
• see Chapter 11 - Disposal Rate Method for an exam problem involving a court decision
• use report year data in place of accident year data
• significant growth or shrinkage causing a shift in average accident date • use accident quarters in place of accident years
• change in mix of business
• see Chapter 7 - Scenario 6 (Change in Product Mix) for an example of a change in mix
subdivide data into more homogeneous groups

mini BattleQuiz 1 You must be logged in or this will not work.

Berquist-Sherman Reported Method

Description of Method

Here's the first fact you have to memorize:

Purpose of Berquist-Sherman Reported Method:    Adjust reported data for distortions caused by changes in case reserve adequacy (case strength).

In practice, the first thing you should do in a reserve analysis is check for things like changes in case reserve adequacy. If there have not been changes, then you don't need the Berquist-Sherman reported adjustment. In the Pop Quiz at the top of this wiki article, we reviewed diagnostics for increases in case reserve adequacy:

paid/reported loss, average reported loss, average case O/S loss

Notice that the average paid loss (also called paid severity) is not listed – we learned in chapter 6 that a change in case strength does not affect paid data. But in step 1b further down, the overall severity trend is calculated from the average paid loss triangle. That might not seem right but here's the explanation:

  • Without any change in case strength, there is still probably an underlying severity trend, often just due to inflation.
  • This severity trend would show up in both the paid severity and outstanding severity triangles and would be roughly the same in each.
  • Then if there is a change in case strength, the paid severity trend would not change but the outstanding severity trend would change
  • The paid severity trend is the true trend but the outstanding severity trend is now distorted due to the change in case strength
  • The Berquist-Sherman reported adjustment removes this distortion from the reported data

For example suppose both the paid and outstanding severity trends were 3% before any change in case strength. Then after the change in case strength, the paid severity trend is still 3%, but the outstanding severity trend is 5%. The Berquist-Sherman reported adjustment removes the 5% trend and restates or detrends the outstanding severity triangle back to a 3% trend.

Below is an exam problem that demonstrates the method. The solution in the examiner's report is very good because they write out all the intermediate steps. Note that this problem provides the severity trend of 5%. (You don't have to estimate it yourself.) Alice's solution has an extra step in case you're not given the severity trend and have to come up with it yourself.

E (2019.Fall #21)
Solution: 2019.Fall #21
For reference, here's the step-by-step procedure from Alice's solution:
  • Normally you're given CPL, CRL, CPC, CRC
(For a review of these abbreviations, see Chapter 11 - Disposal Rate Method.)

Step 1

Step 1a: calculate APL, ACOS (APL = Average Paid Loss or Paid Severity, ACOS = Average Case Outstanding or Outstanding Severity)
→ APL = CPL / CPC
→ ACOS = (CRL - CPL) / (CRC - CPC)
Step 1b: calculate and select severity trend using APL (if severity trend is not given), check for evidence of change in case strength using ACOS
→ calculate APL trends down columns and make selections
→ calculate ACOS trends down columns and look for changes that might indicate a change in case strength

Step 2

Step 2a: restate ACOS by detrending backwards from latest diagonal
Step 2b: restate CRL as (restated ACOS) x (open counts) + (original CPL)
note that open counts = CRC - CPC = (cumulative reported counts) - (cumulative paid counts)

Step 3

  • apply the development method to the restated CRL triangle
(Just apply the standard development to the restated triangle of cumulative reported losses. Easy! Theoretically, this restated CRL is now corrected for any changes in case strength. All AYs should be at the same level and the development method applied to this triangle shouldn't be distorted.)

Practice Problems

A couple of random practice problems where you have to select the severity trend yourself:

Practice: 2 problems on the Berquist-Sherman REPORTED method

And the quiz with a selection of old exam problems:

mini BattleQuiz 2 You must be logged in or this will not work.

Berquist-Sherman Paid Method

Description of Method

Here's the first fact you have to memorize:

Purpose of Berquist-Sherman Paid Method:    Adjust paid data for distortions caused by changes in claim settlement rate.

In practice, the first thing you should do in a reserve analysis is check for things like changes in the claim settlement rate. If there have not been changes, then you don't need the Berquist-Sherman paid adjustment. In the Pop Quiz at the top of this wiki article, we reviewed diagnostics for increases in settlement rate:

paid/reported loss, paid/reported counts or average case O/S loss

But there's another very useful diagnostic if you also know UC (Ultimate counts), It's called the CDR (Claims Disposal Rate).

CDR   =   CPC / UC

Recall CPC is Cumulative Paid Counts. And very often in exam problems on the BS Paid Method, you will be given ultimate counts. That's the case in the first BS Paid exam problem we're going to look at below. So if the ultimate counts for AY 2020 is 100, and at 12 months development you have 50 paid counts, then CDR12 = 50/100 = 0.5. If at 24 months the paid counts is 80 then CDR24 = 80/100 = 0.8, and so on.

This problem is an example of the full Berquist-Sherman paid method. Don't bother trying to figure out the solution in the examiner's report because Alice's solution is much clearer. It looks complicated but don't be alarmed. It's all quite easy except for the interpolation step, but don't worry if you don't completely understand the interpolation the first time through. We'll cover that in much more detail in the next section.

E (2016.Spring #20)
Solution: 2016.Spring #20
For reference, here's the step-by-step procedure from Alice's solution:
  • Normally you're given CPC, UC, CPL
(For a review of these abbreviations, see Chapter 11 - Disposal Rate Method.)

Step 1

Step 1a: calculate CDR
→ This is to check for changes in claim settlement rate. Increases down columns generally indicate an increase in settlement rate.
→ Make CDR selections for each column. Do not select the average. Do select the most recent diagonal.
Step 1b: restate CPC using the CDR from step 1a
→ This is done by multiplying the UC for each AY by the vector of selected CDRs

Step 2

  • restate CPL using either linear or exponential interpolation
(Many students find this step confusing. We'll discuss it in detail further down. Don't worry if you don't follow it the first time through.)

Step 3

  • apply the development method to the restated CPL triangle
(Just apply the standard development to the restated triangle of cumulative paid losses. This should be easy for you! Theoretically, this restated CPL is now corrected for any changes in the claim settlement rate. All AYs should be at the same level and the development method applied to this triangle shouldn't be distorted.)

Interpolation Step in BS Paid Method

If you've read the Chapter 13 in the Friedland source text, you may have noticed that linear interpolation is not discussed. The source text only explains exponential interpolation, but here's an exam problem that specifically asks you to use linear interpolation. Don't do it now. I just wanted to point that out.

E (2013.Fall #21)

We're going to isolate and study the interpolation step of the Berquist-Sherman paid method in detail. Then when you attempt a full BS paid problem, it should go smoothly.

Example A: Linear Interpolation

Suppose you're given 2 points on the real plane:

  • (x0, y0) = (10,500)
  • (x1, y1) = (20,600)

Question 1: Use linear interpolation to find the y-value corresponding to x = 16.

Answer:

  • y  =   [(16 - 10) / (20 - 10)] * (600 - 500) + 500   =   560

Actually, the formula makes it harder to see what's going on. Because the numbers are so simple, you can easily see that x = 16 is 60% of the way between 10 and 20. (That's the quantity inside the square brackets.) Then the corresponding y-value must also be 60% of the way between 500 and 600 which is obviously 560.

Of course, if the numbers aren't so simple you might not be able to do the calculation in your head. Suppose you're now given:

  • (x0, y0) = (21.2, 378.6)
  • (x1, y1) = (64.7, 982.0)

Question 2: Use linear interpolation to find the y-value corresponding to x = 31.2.

Answer:

  • y = [(31.2 - 21.2) / (64.7 - 21.2)] * (982.0 - 378.6) + 378.6 = 517.3

You can write out the formula as shown below, but I don't think this is the most helpful way to think about it:

  • y   =   [ (x - x0) / (x1 - x0) ]   *   (y1 - y0) + y0

Think about it like this instead:

linear interpolation:   y  =   [ proportional distance of x from x0 ]   *   (y1 - y0)   +   y0

In terms of high school algebra, you're basically just fitting a linear equation y = mx + b to the given points and then using that equation to get the new y-value corresponding to the given x-value. But you don't actually have to find m and b. That would take too long. If you understand how interpolation works intuitively, you can do it much quicker.

Example B: Linear Interpolation Applied to Paid Data

Instead of x-values and y-values we're now going to use paid counts and paid losses which is what you have in the Berquist-Sherman paid method. Suppose you're given the following data for AY 2020.

data type 12-months 24-months 36-months 48-months
CPC 10 20 25 28
CPL 500 600 640 670

Remember the first step of the BS paid method is to calculate CDR (Claims Disposal Rate) then use it to restate CPC (Cumulative Paid Counts). Let's suppose you did that and found the restated CPC values to be:

data type 12-months age 24-months age 36-months age 48-months
restated CPC 15 18 24 28
restated CPL ? ? ? ?

The interpolation step is finding the corresponding restated CPL-values in the above table. Let's do them one by one:

12-months:
→ since restated CPC12 = 15 is within the 12-24 interval of the original CPC-values, we do the interpolation using original CPC and CPL values as follows:
  • (x0, y0)   =   (CPC12, CPL12)   =   (10, 500)
  • (x1, y1)   =   (CPC24, CPL24)   =   (20, 600)
→ restated CPL12   =   [ (15 - 10) / (20 - 10) ] * (600 - 500) + 500   =   550
24-months:
→ since restated CPC24 = 18 is still within the 12-24 interval of the original CPC-values, we do the interpolation using the same original CPC and CPL values as before:
  • (CPC12, CPL12)   =   (10, 500)
  • (CPC24, CPL24)   =   (20, 600)
→ restated CPL24   =   [ (18 - 10) / (20 - 10) ] * (600 - 500) + 500   =   580
36-months:
→ since restated CPC36 = 24 is within the 24-36 interval of the original CPC-values, we do the interpolation using original CPC and CPL values as follows:
  • (CPC24, CPL24)   =   (20, 600)
  • (CPC36, CPL36)   =   (25, 640)
→ restated CPL36   =   [ (24 - 20) / (25 - 20) ] * (640 - 600) + 600   =   632
48-months:
→ if we assume the 48-month value is the lastest diagonal then the restated CPC and CPL values are the same as the orignal values and no calculation is necessary
→ restated CPL48   =   original CPL48   =   670
Bonus Question 1: what if restated CPC36 = 26 (instead of 24)
→ if restated CPC36 = 26 then you have to use a different interval and this is the part that confuses people. You have to notice that 26 is in the original 36-48 CPC-interval and then use the original CPC and CPL values corresponding to that interval:
  • (CPC36, CPL36)   =   (25, 640)
  • (CPC48, CPL48)   =   (28, 670)
→ restated CPL36   =   [ (26 - 25) / (28 - 25) ] * (670 - 640) + 640   =   650
Bonus Question 2: what if restated CPC12 = 9 (instead of 15)
→ if restated CPC12 = 9 then you have a choice. You could use the same interval as we did for interpolating the paid value of 15 and you would get:
  • CPL12 = [ (9 - 10) / (20 - 10) ] * (600-500) + 500 = 490
Or, use the origin (0,0) as your other interpolation point as follows, which I think makes more sense because if CPC = 0 then CPL = 0 also. (Note you may get a different answer but the source text doesn't specify a method so either should be acceptable.)
  • (CPC0, CPL0)   =   (0, 0)
  • (CPC12, CPL12)   =   (10, 500)
→ restated CPL12   =   [ (9 - 0) / (10 - 0) ] * (500 - 0) + 0   =   450

Now you can attempt (2013.Fall #21). The examiner's report performs their linear interpolation using selected disposal rates without explicitly calculating the restated paid counts. This is potentially quicker than my method but it's easier to make a mistake. You can decide for yourself how you'd rather do it but the more steps you write out, the more partial credit you'll get if your final answer isn't exactly right.

Alice's solution below shows both linear and exponential interpolation even though the official problem asked only for linear interpolation. (If you're asked to perform exponential interpolation on the exam, you should always be given the parameters for the exponential regression.)

E (2013.Fall #21)
Solution: 2013.Fall #21

And here's the solution to (2016.Spring #20) using both linear and exponential interpolation. (The question asked only for exponential interpolation.)

E (2016.Spring #20)
Solution: 2016.Spring #20
Example C: Exponential Interpolation

Let's revisit the first problem from Example A: Linear Interpolation but this time we're going to use exponential intepolation. Suppose you're given 2 points on the real plane:

  • (x0, y0) = (10,500)
  • (x1, y1) = (20,600)

Suppose you're also given the regression parameters a = 417 and b = 0.01840 for the exponential regression y = aebx.

Question 1: Use exponential interpolation to find the y-value corresponding to x = 16.

Answer: All you have to do is substitute x = 16.

  • y   =   417 * e(0.01840 * 16)   =   559.7

This is very close to the answer of 560 you get with linear interpolation. Exponential interpolation in a Berquist-Sherman problem is generally easier than linear interpolation because you will be given the exponential regression parameters.

Let's now do a problem that's closer to what you'll have to do on the exam using paid counts and paid losses. We did this exact problem earlier using linear interpolation but here you are also given the exponential regression parameters for each successive pair of (count, loss) values.

data type 12-months 24-months 36-months 48-months
CPC 10 20 25 28
CPL 500 600 640 670

AY 2020
0-12 12-24 24-36 36-48
a b a b a b a b
use 12-24 values use 12-24 values 417 0.01840 463 0.01299 437 0.01539

The regression parameters for each interval are based on these pairs of given values:

12-24: uses (10, 500) & (20, 600)
24-36: uses (20, 600) & (25, 640)
36-48: uses (25, 640) & (28, 670)

Remember the first step of the BS paid method is to calculate CDR (Claims Disposal Rate) then use it to restate CPC (Cumulative Paid Counts). Let's suppose you did that and found the restated CPC values to be:

data type 12-months age 24-months age 36-months age 48-months
restated CPC 15 18 24 28
restated CPL ? ? ? ?

The interpolation step is finding the corresponding restated CPL-values in the above table. Let's do them one by one:

12-months:
→ since restated CPC12 = 15 is within the 12-24 interval of the original CPC-values, we use the a and b for the 12-24 range:
→ restated CPL12   =   417 * e(0.01840 * 15)   =   549.5
24-months:
→ since restated CPC24 = 18 is still within the 12-24 interval of the original CPC-values, we use the a and b for the 12-24 range as before:
→ restated CPL24   =   417 * e(0.01840 * 18)   =   580.7
36-months:
→ since restated CPC36 = 24 is within the 24-36 interval of the original CPC-values, we use the a and b for the 24-36 range:
→ restated CPL36   =   463 * e(0.01299 * 24)   =   632.4
48-months:
→ if we assume the 48-month value is the lastest diagonal then the restated CPC and CPL values are the same as the orignal values and no calculation is necessary
→ restated CPL48   =   original CPL48   =   670
Bonus Question 1: what if restated CPC36 = 26 (instead of 24)
→ if restated CPC36 = 26 then you have to use a different interval and this is the part that confuses people. You have to notice that 26 is in the original 36-48 CPC-interval and then use the a and b for the 36-48 range:
→ restaed CPL36   =   437 * e(0.01539 * 26)   =   652.0
Bonus Question 2: what if restated CPC12 = 9 (instead of 15)
→ if restated CPC12 = 9 then unlike with linear interpolation you have no choice. You must use the 12-24 parameters. You cannot perform a regression on the 0-12 interval because an exponential curve cannot pass through the origin and there is no other logical left endpoint for the 0-12 interval.
  • CPL12   =   417 * e(0.01840 * 9)   =   492.1

Practice Problems

Here are 2 problems that deal only with the interpolation step of the Berquist-Sherman paid method. If you're confident with interpolation, you can skip these.

Practice: 2 problems on Berquist-Sherman Interpolation

And here are 2 full practice problems on the Berquist-Sherman paid method:

Practice: 2 problems on the Berquist-Sherman PAID method

And finally, here's the quiz with old exam problems:

mini BattleQuiz 3 You must be logged in or this will not work.

BS Methods Combined

Sometimes you have a situation where there's been both a change in claim settlement rate and and change in case reserve adequacy. In this case you might want to apply both Berquist-Sherman methods to your data. Recall that for the BS Reported Method, you'd typically be given:

  • CPL, CRL, CPC, CRC

For the BS Paid Method, you'd have:

  • CPC, UC, CPL

So the only extra piece of information you need for the paid method is UC. Putting this all together, your starting point for applying both Berquist-Sherman methods is these 5 items:

Data Needed for Both BS Methods:    CPL, CRL, CPC, CRC, UC

You must do the BS paid adjustment first to obtain:

  • restated CPC, restated CPL

Then feed these into the BS reported adjustment. That means you use the following data as your starting point for the BS reported adjustment:

  • restated CPL, CRL, restated CPC, CRC

Here's an exam problem where you have to do this. It looks harder than it really is. You just need to keep your work organized. They help you out by giving you the interpolated values for the BS paid method so you don't have to stop and calculate them yourself.

E (2014.Fall #20)
Alice's BS Combined Hint:   Do the paid adjustment first.   Do the reported adjustment second.   Simple!   :-)

BS Method Concepts

Memorize the answers to these next 2 items:

Question: identify advantages of the Berquist-Sherman methods
B-S Paid method:
  • corrects for changes in claim settlement rate so the Key Assumption of the development method holds
B-S Reported method:
  • corrects for changes in case reserve adequacy so the Key Assumption of the development method holds
Question: identify disadvantages of the Berquist-Sherman methods
B-S Paid method:
  • assumes changes in settlement rate apply to all claims uniformly (paid losses are proportional to closed counts)
(won't be true if small claims settle faster and large claims settle more slowly)
B-S Reported method:
  • very sensitive to the selected trend

Here's a great exam problem that tests whether you really understand what the Berquist-Sherman methods are doing and/or not doing. You're told that an insurer began prioritizing small claims so that small claims are now being settled faster. You're then asked to explain why neither the paid nor reported development method will work. (See discussion below.)

E (2015.Spring #23)

Part (a.i), explaining why paid development won't work is easy:

  • an increase in settlement rate violates the Key Assumption of the development method, that future loss development is similar to development in prior years

Part (a.ii), explaining why reported development won't work is a little trickier and you should read the 3 sample answers in the examiner's report which I've paraphrased below. Note that for sample answer 2, the conclusion is that reported development will work:

  1. if small claims are prioritized then large claims may be given less attention and will develop differently than in the past (so the Key Assumption of the development method is violated)
  2. if case reserves for small claims are accurate then settling them more quickly has no effect on reported losses (you may have to think about that for a minute – if case reserves were deficient/redundant, then as soon as a claim is paid and closed for the higher/lower amount the reported loss would immediately get bumped up/down to reflect that but if the case reserves were correct the reported losses would not require adjustment and the reported development method would work)
  3. if case reserves for small claims are deficient/redundant then reported losses would be distorted as explained in the previous bullet point

Part (b) of this problem goes deeper and many candidates did not answer correctly. When we talk in general about an increase in settlement rate, we're usually assuming the settlement rate increases for all claims. In other words, both small claims and large claims are settled faster. What often happens however is that only small claims are settled faster. This is the situation in this exam problem and this has a couple of knock-on effects:

  • paid severity will decrease at earlier development periods
  • outstanding severity will increase at later development periods

If only small claims are settled faster then the Berquist-Sherman adjustments will not work. The paid BS adjustment won't work because the key assumption is violated:

Key Assumption (Paid Berquist-Sherman):    Paid losses are proportional to closed counts
  • paid losses will be smaller relative to closed counts at early development periods (because small claims are settled faster)
  • future paid losses will be larger relative to closed counts at later development periods (because large claims are all that's left)

In other words, the proportionality is destroyed by settling some but not all claims faster. Fortunately there's an alternate strategy that's more likely to work:

Alternate Strategy:    Separate small claims and large claims into different triangles and analyze each individually

That's what you had to notice to get credit in part (b) of this exam problem. You can then apply the paid B-S adjustment separately to the small claims data and the large claims data because the key assumption is more likely to hold for each individually.

An interesting side note is that the reported Berquist-Sherman adjust will not work either. If you're not careful, you might interpret the increase in outstanding severity as increase in case reserve strength. We learned in Chapter 6 - Changes in Case Reserve Adequacy that an increase in case reserve strength will cause an increase in outstanding severity, but the reverse is not true. An increase in outstanding severity could have other causes and if it isn't due to an increase in case reserve strength, then the reported Berquist-Sherman adjustment won't work. (The reported B-S adjustment is specifically to correct for changes in case strength.)

Extra Exam Problems

Full BattleQuiz You must be logged in or this will not work.

POP QUIZ ANSWERS

  • To detect changes in case reserve adequacy the best 3 diagnostics to look at are:
paid/reported loss, average reported loss, average case O/S loss
  • To detect changes in claim settlement rate the best 3 diagnostics to look at are:
paid/reported loss, paid/reported counts or average case O/S loss
  • BONUS: For an increase in case reserve adequacy and an increase in claim settlement rate, green font indicates an increase down columns in the diagnostic triangles and red font indicates a decrease.

Go back