Last minute Formulas Flashcards
LER (Loss elimination Ratio)
Total Capped amount / Total expected amount
Calculate the premium for a policy with a $500 deductible.
- Calculate LER (500)
- Deductible Relativity = 1- LER(500)
- Calculate the new Loss (LR* deductible relativity)
- Usual Premium indicated steps
Indicated rate = (New Loss *(1+ALAE ratio) + Fixed expenses )/ 1- V-Q
Steps
Calculate the total amount of premium discount for a policy with premium of $180,000.
2011 Q16
- premium in range (Upper - Lower) until max 180 000$ as upper limit
- total Expense percentage = (Prod+ General+ Taxes + Profit)
- Expense reduction = 1st row of Total expense - your row of total expense
- Discount % = Expense reduction / (1- %Tax - % Profit)
- $ Discount = Prem in range * %discount
- Total $ Discount is your answer !
An insured purchases a $400,000 policy on a property valued at $500,000.
- The coinsurance requirement for the policy is 90% of property value.
- No deductible applies.
a.
Calculate the coinsurance penalty for a $300,000 loss and maximum penalty
- a = min(AOI/(Required coinsurance amount , 1)
a = min(400/(500*90%);1) = 0.889 - Indemnity (I) = min(a * Loss; AOI)
I = min(0.889 x 300 000 ; 400 000) = 266 667 - Penalty (P) = min(L, AOI) - I
P = min( 300 000, 400 000) - 266 667 = 33 333 - Maximum Penalty
* Maximum Loss is AOI, so the new L = 400 000
Max indemnity = a* 400000 = 355 556
P = min( New loss ; AOI) - I
P = min( 400 000; 400 000) - 355 556 = 44 444
Loss constant Steps
For each Range of premiums
- Premium Shortfall = (Rept Loss/Target Loss ratio)-Premium
- Loss Constant = Premium Shortfall/ # risks
Harwayne Cred as complement of cred for State A class 1
We have State B and C et Class 2
Spring 2017 Q9
- State A PP
- Adjusted PP for B and C with exposures of A
* (PP B1 x Exposure A1 + PP B2 x Exposure A2 ) / Total Exposures A - Adjustment factor for B and C
PP A / Adjusted PP B - Adjustment factor x PP B class 1
Same for C - Complement = (Exposure B1 x Adjusted PP B1 + Exposure C1 x Adjusted PP C1 ) / Sum of Exposures B1 and C1
- Cred Wtd PP = Z * A1 x (1-Z) * Complement
Complement of credibility Trended present rates
PP complement
PP Complement = Present rate x Loss trend Factor/Premium trend x (Prior indicated Loss Cost / Prior implementated loss cost)
Period for trend : From last indication effective to new indication effective
Complement of credibility Trended present rates
LR complement
Fall 2019 Q3
LR Complement = Loss trend Factor/Premium trend factor x (Prior indicated Rate change / Prior implemented indicated Rate change) -1
Period for trend : From last indication effective to new indication effective
Credibility Bulhman
Z = N / (N + K)
K = EVPV / VHM
= Expected Process Variance / Variance of Hypothetical Mean
Overall indication section
WC Indication steps
Practice Problem 1 B7 overall indication
The main formula is
*(Med LR + Indem LR) x (1+ LAE Ratio)
*
**Step 1 : Projected Loss cost premium **
1a *Trend period *= AAD for latest available year to AAD for effective period)
* *Trend factor *= (1+ Projected annual wage) ^ trend period
1b Projected loss cost for each year and total
Projected loss cost = Industry LC prem x Factor to current (last year is 1.00 and each year accumulates the wage changes) x Trend factor x Experience mod factor
* Experience mod factor = Expected exp mod (EEM) / Hist exp mod (HEM)
**-> Sum of all projected losses :) **
Step 2 Indemnity Loss ratio for each year
2a. Projected Ult Indem losses
= Rept indem losses x Indem CDF x Factor to adjust indem to current x Trend factor
* Trend factor = (1+Future benefit level chg)^Trend period
* factor to adjust = (last year is 1.00 and each year accumulates (1+ benefit level chg) x (1+ inflation chg))
-> Suggestion : Create a column with the combined effect of benefit change and inflation
2b. Indemnity Loss Ratio for each year and total
Proj ult indem losses /Projected Loss Cost (from step1)
Step 3 Medical Loss ratio for each year and total
3a. Projected ultimate medical loss = Rept med loss x CDF x factor to adjust current med level x Trend Factor
* Trend factor = (1+Future combined fees)^Trend period
* Factor to adjust current = (last year is 1.00 and each year accumulates (1+ combined effect from previous year)
-> Suggestion : Create a column with the combined effect because you may have weights for schedule fees and other fees
3b. Medical Loss Ratio for each year and total
Projected ultimate medical loss /Projected Loss Cost (from step1)
**Step 4 Industry and company changes **
- Indicated rate change = (Med LR + Indem LR) x (1+ LAE Ratio) -1
- Proposed deviation from industry =( 1/(1-V-Q) ) x (1 + expected loss cost difference)
- Company indicated rate change = Proposed deviation / Current deviation x (1+ industry chg) - 1
btw 1/(1-v-q) = Expenses and Profit Adj Factor (In case you this instead)
Overall indication
Homewowner indication steps
Battleacts Powerpack p103
Projected Ult non cat PP + Projected non-modeled cat PP + Projected modeled cat PP + Projected net reinsurance PP + Projected Fixed Expenses
- Projected Ult non cat PP trended
a. Trend periods
-> Hist = From CY to last year of experience AAD(07-01 to 07-01)
-> Future = From last year of experience AAD to Effective AAD
b. Non Cat ultimate Loss
= Non Cat rept loss & ALAE x ULAE x Trends
c. Non Cat ult PP
=Non Cat ultimate Loss /EE take the avg (in general) - Non-modeled Cat PP trended (Use the most recent year only)
= CAT-to-AIY-Ratio x AIY-to-EE x ULAE Factor
a. choose the correct AIY to EE
If your AAD Effective is 2027-04-01
You have to put a weight on the 2026 year and 2027 (both have AAD 07-01)
This must be 0.25 x AIY to EE 2026 + 0,75 x AIY to EE 2027
- if the trend is not given, you must find it with % of change along the AIY to EE
3. Net reinsurance cost per exposure = (most recent CY Reinsurance cost (which is ceded premium) - most recent CY reinsurance recoveries) / EE for most recent EE
- Trend fixed expenses
* Trend period : From AWD of most recent year to AWD (eff period) since most expenses are incurred when policy is written - Modeled cat PP is usually given, but if not
= Projected Avg AIY per exposure x Modeled CAT Loss and ALAE to AIY ratio x ULAE
Large deductible polices premium (100 000$) for example
TIA #4 Q14
Premium = (Losses above the Deductible + ALAE + FE + Credit Risk + Risk Margin ) / (1-V-Q)
Notes :
1. Losses above deductible = Ground up losses x Excess Ratio or (1-LER)
2. Do not multiply your losses above deductible by (1+ ALAE %)… deductible does not affect ALAE so you must multiply ALAE by Ground up losses !
3. Credit risk % of expected deductible payments is applied to losses beloew deductible
ISO Experience Modication (Mod)
STEPS
2006 Q49
MOD = ((AER - EER) / EER) x Z
Z: Credibility
EER = Expected experience ratio (usually given, put this =1 if MSL is not given)
AER = Basic limit losses + Expected unrept losses / CLSC
CLSC : Company’s subject to basic limit loss…
- Basic Limit losses = Follow this order
a.Limit on Loss
b. Add ALAE
c. Limit MSL on Loss + ALAE - Basic limit expected loss and LAE = Prem x LR
- CLSC (if not given) = Basic limit expected loss and LAE x detrend factor
- Expected unrept losses = CLSC x %unrept x EER
- Standard premium = Experience Mod x Manual Premium so If they ask you for Premium write down that you assume that they ask for Manual premium and find the answer
NCCI Experience Plan
Fall 2016 Q15
2 formulas
- M = (Ap + w* Ae +(1-w) * Ee + B ) / (E + B)
or - (Zp x Ap + (1-zp) x Ep + Ze x Ae + (1-Ze) x Ee) / E
Ap = Actual Primary (Primary = losses capped)
Ae = Actual excess
Same logic for Expected (Ep and Ee) and Z credibility
E = Ee + Ep
w=Excess loss weighting = Excess cred (Ze) / Primary Cred (Zp)
B = Ballast value = E/ (E+B)
You may have also D-ratio = LER (Loss elim ratio for expected losses) so if you want Ee = (1-D Ratio) * rept losses
NOTE
Standard premium = Experience Mod x Manual Premium so If they ask you for Premium write down that you assume that they ask for Manual premium and find the answer
Retrospective Rating steps
Spring 2018 Q15
Retrospective premium = (Basic Premium + Converted Losses )
- Converted Losses = Rept losses x Loss conversion factor (LCF)
- Basic Premium = Standard Premium x (Expense Allowance - LCF expenses + Net insurance charge)
*Standard premium = Manual Premium x M (modification factor) - LCF Expense = LR *(LCF-1)
*Net insurance = (Insurance Charge - Insurance savings) * LR * LCF
You may need to compare you retro premium with min and max retro prem
* min and max retro = Standard prem x min and max factor
You want you retro prem to be between these boundaries !