View source for Werner08.Indication

'''Reading''': BASIC RATEMAKING, Fifth Edition, May 2016, Geoff Werner, FCAS, MAAA & Claudine Modlin, FCAS, MAAA
Willis Towers Watson

'''Chapter 8''':  Overall Indication

==Pop Quiz==

What is the formula for the pure premium method for calculating an average rate? <span style="background-color: lightblue; border-radius: 5px;"> ''[[Werner08.Indication#POP_QUIZ_ANSWERS |Click for Answer]]''&nbsp;</span>

==Study Tips==

[[File: Franklin.png|100px|thumb|left]] [https://www.battleacts5.ca/video/video_W-08_(001)_Overall_Indication.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: W-08 (001) Overall Indications &rarr; 6:00'''</span>] [https://www.battleactsmain.ca/battleacts5.ca/forum5/index.php?p=/categories/w-08-indication<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>]
Franklin has a tip to brighten your day! There is very little new material in chapter 8. You did all the hard work in earlier chapters and chapter 8 just ties everything together into an overall rate indication. There are 2 basic formulas:

&nbsp;&nbsp;&nbsp;&nbsp; &bull; pure premium formula ''(we actually already covered this [[Werner07.OtherExpenses#A_Simple_Example | here in chapter 7]].)''
<br>&nbsp;&nbsp;&nbsp;&nbsp; &bull; loss ratio formula ''(provides the <u>change</u> in rates rather than a specific dollar-value as in the pure premium formula)''

You'll need to know where each method can and can't be used but that's easy. Most of your time will be spent doing '''practice problems'''. The source text also shows how each formula is derived starting with the Fundamental Insurance Equation but I believe this is outdated for an Excel-based exam. ''(Some very old exam problems asked you to reproduce these derivations but this isn't feasible in Excel.)''<br clear=all>

'''Estimated study time''': 3 days ''(not including subsequent review time)''

==BattleTable==

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

* <span style="color: green;">'''loss ratio method'''</span> - ''calculating an indicated rate <u>change</u>''
* <span style="color: blue;">'''pure premium method'''</span> - ''calculating an indicated <u>rate</u>''
* miscellaneous information - ''situations where each method is appropriate and where it isn't'' 

: {| class='wikitable' style='width: '

|-
! style='width: 175px;' | reference !! style='width: 200px;' | part (a) !! style='width: 200px;' | part (b) !! style='width: 200px;' | part (c) !! style='width: 200px;' | part (d)

|-
|| [https://www.battleacts5.ca/pdf/Exam_(2019_2-Fall)/(2019_2-Fall)_(07).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 #7)'''</span>
|| <span style="color: green;">'''loss ratio method'''</span> <br> - with BF method
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 

|- style="border-bottom: solid 2px;"
|| [https://www.battleacts5.ca/pdf/Exam_(2019_1-Spring)/(2019_1-Spring)_(07).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 #7)'''</span>
|| '''ultimate L+LAE''' <br> - with BF method
|| [[Werner12.Credibility]]
|| [[Werner12.Credibility]]
| style="background-color: lightgrey;" | 

|- style="border-bottom: solid 2px;"
|| [https://www.battleacts5.ca/pdf/Exam_(2018_2-Fall)/(2018_2-Fall)_(07).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.Fall #7)'''</span>
|| '''reinsurance cost''' <br> - 12 month term
|| '''ultimate L+LAE''' <br> - with Freq/Sev method
|| '''projected pure premium''' <br> - all years
|| <span style="color: blue;">'''pure premium method'''</span> <br> - new rate & rate change

|-
|| [https://www.battleacts5.ca/pdf/Exam_(2017_2-Fall)/(2017_2-Fall)_(15).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 #15)'''</span>
|| '''ultimate L+LAE''' <br> - with development method
|| '''ultimate L+LAE''' <br> - with BF method
|| '''ultimate L+LAE''' <br> - make final selection
|| <span style="color: green;">'''loss ratio method'''</span> <br> - assume full credibility

|-
|| [https://www.battleacts5.ca/pdf/Exam_(2017_1-Spring)/(2017_1-Spring)_(05).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 #5)'''</span>
|| <span style="color: green;">'''loss ratio method'''</span> <br> - rate change
|| <span style="color: blue;">'''pure premium method'''</span> <br> - new rate
|| '''inappropriate uses for''': <br> - LR method, PP method
| style="background-color: lightgrey;" | 

|- style="border-bottom: solid 2px;"
|| [https://www.battleacts5.ca/pdf/Exam_(2017_1-Spring)/(2017_1-Spring)_(13).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 #13)'''</span>
|| '''ultimate loss''' <br> - capped at 100K
|| <span style="color: green;">'''loss ratio method'''</span> <br> - assume full credibility
|| '''not taking full change''' <br> - reasons for
| style="background-color: lightgrey;" | 

|-
|| [https://www.battleacts5.ca/pdf/Exam_(2016_2-Fall)/(2016_2-Fall)_(07).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 #7)'''</span>
|| '''U/W profit provision''' <br> - for each company
|| '''U/W profit provision''' <br> - reasons for variations
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 

|-
|| [https://www.battleacts5.ca/pdf/Exam_(2016_2-Fall)/(2016_2-Fall)_(08).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 #8)'''</span>
|| <span style="color: green;">'''loss ratio method'''</span> <br> - assume full credibility
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 

|-
|| [https://www.battleacts5.ca/pdf/Exam_(2016_2-Fall)/(2016_2-Fall)_(09).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 #9)'''</span>
|| <span style="color: green;">'''loss ratio method'''</span> <br> - assume full credibility
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 

|-
|| [https://www.battleacts5.ca/pdf/Exam_(2016_1-Spring)/(2016_1-Spring)_(01).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 #1)'''</span>
|| '''on-level loss ratio''' <br> - rate & benefit changes
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 

|-
|| [https://www.battleacts5.ca/pdf/Exam_(2016_1-Spring)/(2016_1-Spring)_(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;'>'''(2016.Spring #6)'''</span>
|| '''using credibility''' <br> - rate change
|| '''profit provision''' <br> - negative value
|| '''compare methods:''' <br> - pure premium vs loss ratio
| style="background-color: lightgrey;" | 

|- style="border-bottom: solid 2px;"
|| [https://www.battleacts5.ca/pdf/Exam_(2016_1-Spring)/(2016_1-Spring)_(08).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 #8)'''</span>
|| <span style="color: green;">'''loss ratio method'''</span> <u>or</u> <br> <span style="color: blue;">'''pure premium method'''</span>
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 

|- style="border-bottom: solid 2px;"
|| [https://www.battleacts5.ca/pdf/Exam_(2015_1-Spring)/(2015_1-Spring)_(09).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 #9)'''</span>
|| <span style="color: blue;">'''pure premium method'''</span> <br> - new rate
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 

|-
|| [https://www.battleacts5.ca/pdf/Exam_(2014_2-Fall)/(2014_2-Fall)_(07).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 #7)'''</span>
|| <span style="color: blue;">'''pure premium method'''</span> <br> - new rate
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 

|- style="border-bottom: solid 2px;"
|| [https://www.battleacts5.ca/pdf/Exam_(2014_1-Spring)/(2014_1-Spring)_(05).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 #5)'''</span>
|| <span style="color: green;">'''loss ratio method'''</span> <br> - assume full credibility
|| '''complement of credibility''' <br> - assess appropriateness
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 

|-
|| [https://www.battleacts5.ca/pdf/Exam_(2013_2-Fall)/(2013_2-Fall)_(04).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 #4)'''</span>
|| <span style="color: green;">'''loss ratio method'''</span> <br> - with 2-step trending
|| '''EP @ CRL''': <br> - alternative methods
|| '''impact on indication''': <br> - uniform premium earning
| style="background-color: lightgrey;" | 

|-
|| [https://www.battleacts5.ca/pdf/Exam_(2013_1-Spring)/(2013_1-Spring)_(03).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 #3)'''</span>
|| '''recommend improvements:''' <br> - to rate indication
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 

|-
|| [https://www.battleacts5.ca/pdf/Exam_(2013_1-Spring)/(2013_1-Spring)_(05).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 #5)'''</span>
|| <span style="color: green;">'''loss ratio method'''</span> <br> - assume full credibility
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" | 
| style="background-color: lightgrey;" |  

|}

[https://www.battleacts5.ca/FC.php?selectString=**&filter=both&sortOrder=natural&colorFlag=allFlag&colorStatus=allStatus&priority=importance-high&subsetFlag=miniQuiz&prefix=Werner08&suffix=Indication&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!==

===Intro===

Alice gave Ian-the-Intern this quiz when he arrived at work, and he got the right answer on only his second try. Exactly one of the following statements is true. Can you tell Alice which one it is?

# The goal of ratemaking is to set rates too low so that premium charged does not cover losses & expenses. The losses can then be written off the company's corporate taxes.
# The goal of ratemaking is to set rates too HIGH so that premium charged greatly exceeds losses & expenses and generates a huge profit. We can then finally get that ''[https://www.battleacts5.ca/images/espresso_maker.webp espresso maker]'' for the break room.
# The goal of a ratemaking analysis is to set rates so that premium charged covers losses & expenses <u>and</u> achieves the targeted profit for policies written during a future period

The correct answer is #3. Memorize it. It's just another way of saying the ''[[Werner01.Intro#Fundamental_Insurance_Equation | Fundamental Insurance Equation]]'' should be balanced. ''(Ian's first guess was #2 because he desperately needs his caffeine fix when he gets to work in the morning.)''

===Pure Premium Method===

We covered the pure premium method ''[[Werner07.OtherExpenses#A_Simple_Example | here in chapter 7]]'', and the first quiz in that section had a web-based problem for practice. You can review it briefly if necessary. The mathematical derivation of the formula was provided but I don't believe you'll be tested on that. I included it so you could see how the rate indication formula follows from the Fundamental Insurance Equation. '''Mini Battle-Quiz #1 below has a web-based infinite calculation problem which is a harder version of the pure premium method.'''

Note that the pure premium method requires exposure data, and gives you the dollar-value of the indicated rate. The loss ratio method discussed in the next section works a little differently. The loss ratio method requires <u>premium</u> data, and gives you the <u>percent change</u> from the previous rate.

[https://www.battleacts5.ca/FC.php?selectString=**&filter=both&sortOrder=natural&colorFlag=allFlag&colorStatus=allStatus&priority=importance-high&subsetFlag=miniQuiz&prefix=Werner08&suffix=Indication&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>

===Loss Ratio Method===

The source text does a nice job of explaining the loss ratio method in a simple way. Here's the formula:

: [[File: Werner08_(051)_indicated_rate_change_symbols.png]]

Remember you can always use the link in the sidebar under ''Miscellaneous Battle Reports'' to review pricing notation. ''(You might have to scroll up to see the sidebar links.)'' Or use the direct link ''[[Notation - Pricing]]''. But just to save you a little time, here's the notation used in the above formula:

* '''''L''''' &rarr; Losses
* '''''E<sub>L</sub>''''' &rarr; Loss Adjustment <u>E</u>xpense (LAE)
* '''''P<sub>c</sub>'''''  &rarr; Premium at current rates
* '''''F''''' &rarr; Fixed U/W <u>E</u>xpense ratio
* '''''V''''' &rarr; Variable Expense Provision
* '''''Q<sub>T</sub>''''' &rarr; Target profit percentage

The text provides a nice simple example to show you how the formula works. Note they don't actually provide the values for '''''L''''', '''''E<sub>L</sub>''''', '''''P<sub>c</sub>'''''. Instead they give you '''''(L + E<sub>L</sub>)'''''/'''''P<sub>c</sub>''''' directly, which you can just toss into the numerator. They saved you like 5 seconds. :-)

: [[File: Werner08_(055)_indicated_rate_change_example.png]]

Remember the key difference between the pure premium method and loss ratio method: The pure premium method gives you the <u>dollar-value</u> of the indicated rate whereas the loss ratio method gives the <u>percent change</u> from the previous rate. If you think about that for a moment, you'll see that the loss ratio method cannot be used for a brand new line of business because a new line of business wouldn't have a previous rate. In that scenario, you would have to use the pure premium method.

The source text also shows how the loss ratio formula is derived starting with the Fundamental Insurance Equation, and that it's algebraically equivalent to the pure premium method. That means if you have the necessary input data, both methods should give the same result. ''(If you have both the indicated rate from the pure premium method as well as the prior rate, you can calculate the rate <u>change</u> and compare it to the result from the loss ratio method.)'' The quiz has slightly harder version of this example for practice.

[https://www.battleacts5.ca/FC.php?selectString=**&filter=both&sortOrder=natural&colorFlag=allFlag&colorStatus=allStatus&priority=importance-high&subsetFlag=miniQuiz&prefix=Werner08&suffix=Indication&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>

===ULAE Provision===

The ULAE Provision is a quantity that appears in many rate indication problems and it's a very simple concept. It's generally expressed as follows:

* ULAE provision = x% of loss & <u>A</u>LAE

The percentage might typically be in the 5-8% range. The way to incorporate this into your solution is by multiplying ultimate trended loss & ALAE by (1 + x%). As an extremely simple example, suppose you have:

:{| class='wikitable'
|-
|| ultimate loss & <u>A</u>LAE for AY 2020 || style="text-align: right;" | 4711
|-
|| trend factor to bring AY 2020 to the effective period || style="text-align: right;" | (1.04)<sup>4.5</sup>
|-
|| ULAE provision || style="text-align: right;" | 7% of loss & ALAE
|}

Then the ultimate trended loss and LAE ''(including both ALAE & ULAE)'' &nbsp; = &nbsp; 4711 x (1.04)<sup>4.5</sup> x 1.07 &nbsp; = &nbsp; <u>6014</u>.

''(Sometimes the ALAE provision is expressed as a ratio in a similar way.)''

===Credibility===

Credibility is discussed in detail in ''[[Werner12.Credibility | Chapter 12 - Credibility]]''. For problems in this chapter, you're often told simply to assume full credibility. If so, you don't have to do anything special &ndash; just use the data as given. If you're told the data is <u>not</u> fully credible, you most likely need something called a ''complement of credibility'' and you'll have to return to the problem after covering ''[[Werner12.Credibility | Chapter 12 - Credibility]]''.

As an example, part (a) of the following problem requires you to calculate credibility then use a complement of credibility to calculate the indicated rate change. It's a very easy problem and you can probably figure it out just by looking at the solution even if you haven't covered the credibility chapter yet. The credibility-weighted indication is a weighted average of:

* the rate change calculated using company data
* the given countrywide indicated rate change

The weights come from the square root formula for credibility.

: [https://www.battleacts5.ca/pdf/Exam_(2016_1-Spring)/(2016_1-Spring)_(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;'>'''(2016.Spring #6)'''</span>

===Exam: 2019.Fall #7===

Let's start with the most recently available exam problem. Below is the link to the problem and solution and I'd suggest either printing or opening it in a separate tab so you can follow along with Alice's explanation.

: [https://www.battleacts5.ca/pdf/Exam_(2019_2-Fall)/(2019_2-Fall)_(07).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 #7)'''</span>

It may not seem like it at first but these rate change problems all follow a similar pattern. When you look at the problem, you have to "see" the information as it falls into the categories listed below. Take a moment to make sure you can do this. Note that this problem asks for the indicated rate change and that's usually a clue to use the loss ratio method. ''(If the problem had provided exposures then that would be a clue to use the pure premium method instead.)''

* '''general rate change information'''
:: - ''effective date, policy term, period that rates are expected to be in effect''
* '''losses and LAE'''
:: ''raw data, loss trends, ULAE percentage (ALAE is often just included with losses)''
* '''counts'''
:: - ''most problems do <u>not</u> provide count information''
* '''premiums'''
:: - ''EP, WP, EE, WE, historical rate changes''
* '''expenses''':
:: - ''V, Q<sub>T</sub>, F, E<sub>F </sub>, PLR
:: - ''C&B, OthAcq, TLF, Gen, %fixed''
* '''miscellaneous information'''
:: - ''sometimes there's a trick or sometimes you're given the information in a slightly different way''
:: - ''you have to recognize when you're given something "weird" and figure out how to incorporate it into your solution''

This problem is actually pretty straightforward provided you stay organized. After you've wrapped you head around the given data, you should '''write down''' the loss ratio formula on your scrap paper. This will help you keep track of what you're doing. Even though your submitted solution is entirely in Excel, it will very helpful to use pen and paper for certain steps like calculating trend periods for losses and premiums and doing the current rate level calculations for premiums.

You're now ready to start calculating and here is a step-by-step guide. I'm going to assume you can do the details of each step. You can refer to the examiner's report for assistance.

: '''Step 1''': calculate trended ultimate (L + E<sub>L</sub>) using the Bornhuetter-Ferguson method ''(you'll need to calculate development factors as well as the loss trend period here)''
: '''Step 2''': calculate trended, on-level EP ''(you'll need CRL factors and the premium trend period here)''

At this point, you have the first half of the numerator. Here's the other piece of the numerator:

: '''Step 3''': calculate F for each CY separately ''(recall F = E<sub>F</sub> / P<sub>c</sub> where E<sub>F</sub> is fixed expenses)''

And finally, the denominator of the loss ratio formula:

: '''Step 4''': substitute everything into the rate change formula ''(you were given V and Q<sub>T</sub> directly so the denominator is easy)''

Note the "weird" piece of information given here: In 2017, the company implemented a new policy issuance system. So where does that fit in? Well, you probably noticed that the fixed expenses for 2017 were much higher than for 2016 and 2018. This was due to the new issuance system and is likely a one-time charge. That means 2017 should be excluded when calculating an overall value for F. The examiner's report says a common error was including 2017. This would make the fixed expense ratio F too high which in turn would make the indicated rate change too high and you would probably lose customers.

:{| class='wikitable'
|-
|| '''Alice's Pro Tip''': Pay attention to <u>all</u> the given information!
|}

{| class="wikitable"
|-
| style="background-color: darkslategrey; color: white; border: solid; border-width: 2px; border-radius: 10px;" | '''Pop Quiz A! &nbsp;&nbsp; :-o'''
|}

* There was one other "weird" piece of information in this problem. What was it? <span style="background-color: lightblue; border-radius: 5px;"> ''[[Werner08.Indication#Pop_Quiz_A_-_Answer |Click for Answer]]''&nbsp;</span>

===Exam: 2017.Spring #13===

Let's try the same sort of analysis with another problem:

[https://www.battleacts5.ca/pdf/Exam_(2017_1-Spring)/(2017_1-Spring)_(13).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 #13)'''</span>

First we have to organize the information:

* '''general rate change information''' - ''this is provided in the long list of bullet points under the data tables and in the statement of the question for part (b)''
:: &rarr; effective date: July 1, 2017
:: &rarr; policy term: annual
:: &rarr; rates in effect for: 1 year

* '''losses & LAE'''
:: &rarr; 3<sup>rd</sup> and 4<sup>th</sup> tables show reported losses (capped at 100K), and excess loss information
:: &rarr; loss trends ''(frequency and severity)'' and ULAE provision are shown in the bullet points

* '''counts''' - ''no count information provided''

* '''premiums'''
:: &rarr; the 1<sup>st</sup> and 2<sup>nd</sup> tables show EP and rate changes ''(use this to calculate EP @ CRL)''
:: &rarr; premium trend is shown in the bullet points

* '''expenses'''
:: &rarr; '''''F''''', '''''V''''', '''''Q<sub>T</sub>''''' are shown in the bullet points

* '''miscellaneous information'''
:: &rarr; capped losses and excess loss information

The "weird" information in this problem is the excess loss information. We covered how to calculate ''[[Werner06.LossLAE#Adjustments_to_Losses:_Extraordinary_Losses | Excess Loss Factors]]'' in chapter 6. You can review that material and the associated web-based practice problem if necessary. The calculation in the above exam problem is actually easier than the version of the excess loss factor problem in chapter 6. Just as a reminder, here's the basic formula:

* excess loss factor &nbsp; = &nbsp; (excess losses) / (non-excess losses) 

Note that "non-excess losses" is the same thing as "capped losses".

So give the problem a try. Remember to '''write down''' on your scrap paper the formula for the indicated rate change. Then just methodically calculate each component of that formula.

===Remaining Exam Problems===

You should make sure you understand the 2 problems discussed above then try a few more from the quizzes. Since this has traditionally been the most heavily tested topic across the whole Exam 5 syllabus it will helpful to return to it from time to time. By exam day I recommend you have completed all the old exam problems multiple times. Note that some of these problems have a step that uses material we haven't covered yet but don't worry too much about that. When this happens, make a note and return to it later. It's sometimes hard to assign these exam rate indication problems to specific chapters because they cover material from many different chapters.

A selection of problems using the loss ratio method:

[https://www.battleacts5.ca/FC.php?selectString=**&filter=both&sortOrder=natural&colorFlag=allFlag&colorStatus=allStatus&priority=importance-high&subsetFlag=miniQuiz&prefix=Werner08&suffix=Indication&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>

A selection of problems using the pure premium method:

[https://www.battleacts5.ca/FC.php?selectString=**&filter=both&sortOrder=natural&colorFlag=allFlag&colorStatus=allStatus&priority=importance-high&subsetFlag=miniQuiz&prefix=Werner08&suffix=Indication&section=all&subSection=all&examRep=all&examYear=all&examTerm=all&quizNum=4<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 4]'''</span>

A few miscellaneous problems:

[https://www.battleacts5.ca/FC.php?selectString=**&filter=both&sortOrder=natural&colorFlag=allFlag&colorStatus=allStatus&priority=importance-high&subsetFlag=miniQuiz&prefix=Werner08&suffix=Indication&section=all&subSection=all&examRep=all&examYear=all&examTerm=all&quizNum=5<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 5]'''</span>

[https://www.battleacts5.ca/FC.php?selectString=**&filter=both&sortOrder=natural&colorFlag=allFlag&colorStatus=allStatus&priority=importance-high&subsetFlag=miniQuiz&prefix=Werner08&suffix=Indication&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==

Pure Premium method formula for average rate: &nbsp; <span style="text-decoration: overline;">P</span> &nbsp; = &nbsp; (<span style="text-decoration: overline;">L</span> + <span style="text-decoration: overline;">E</span><sub>L</sub> + <span style="text-decoration: overline;">E</span><sub>F</sub>) / (1.0 &ndash; V &ndash; Q<sub>T</sub>)

<html><a href="javascript:history.go(-1)">Go back</a></html>

==Pop Quiz A - Answer==

The other piece of "weird" information in this problem was the 36-ultimate tail factor. The examiner's report mentioned that forgetting to use it was another common mistake. The given reported loss triangle only has 3 AYs and there is almost almost always development past 36 months. Without using the tail factor, your ultimate losses would be too low which means your indicated rate change would also be too low. Since you're now underpriced, you would probably see lots of growth in exposures! Unfortunately it would all be unprofitable. :-(

<html><a href="javascript:history.go(-1)">Go back</a></html>