5. Schdule P Flashcards
Functions of Schedule P dt-rapid
- Rsv Development
- Freq-sev Trends
- Calc RBC loss sensitive discount
- Rsv Adequacy
- Pmt patterns for discounting rsvs
- IBNR & case rsv split
- Disclosures for SAO
Data shortcomings of Schedule P (6)
Triangles are L & LAE combined (can’t separate)
Triangles inc pooling (distorts data)
Triangles only go back 10AY (not enough for long tail LOB
Frequency trends don’t use EP @CRL
EP is CY & losses are AY
Clm counts are reported (not ultimate)
losses in are net or gross of reinsurance?
Net of reinsurance
Discounts in Schedule P
Part 1
parts 2,3,4
balance sheet
Part 1 is net of tabular discounts & gross of non-tabular discounts
Part 2,3,4 are gross of both tabular & non-tabular discounts
Balance sheet is net of both tabular & non-tabular discounts
Reconcile unpaid in part 1 to part 2 and 3
- Part 1 (unpaid loss ex A&O) + tabular discount from notes to financial statements = Part 2 (net incurred loss & DCC) - part 3 (net paid loss & DCC)




Stuff we can do in schedule p part 1
Formula for Reported Claim Frequency on
- direct basis
- net basis
- # of clms reported direct & assumed / direct EP
- # of clms reported direct & assumed /net EP
Stuff we can do in schedule p part 1
Formula for avg reported claims on…
- direct basis
- net basis
- [Direct and assumed paid losses + direct and assumed paid DCC + direct and assumed case unpaid losses + direct and assumed case unpaid DCC] / # of reptd clms
- [Numertor from item 1 – ceded paid loss –ceded paid DCC – ceded case unpaid loss – ceded case unpaid DCC] /# reptd clms
Stuff we can do in schedule p part 1
Formula for Avg Case Outstanding on…
- direct
- net basis
- [Direct and assumed case unpaid loss + direct and assumed case unpaid DCC] / open clms
- [numerator from 1 – ceded case unpaid loss – ceded case unpaid DCC] / open clms


Ultimate Incurred Loss Formula
incurred = reported + unpaid =
reported =
unpaid =
Incurred = Paid + case + IBNR
Reported = paid + case
Unpaid = case + IBNR
Part 2, 3, 4 defined
Part 2 = incurred net loss & DCC
Part 3 = cumulative paid net loss & DCC
Part 4 = IBNR net loss & DCC
Part 2, 3, 4 formulas
unpaid =
case =
case incurred =
Unpaid = part 2 – part 3
Case =part 2 – part 3 – part 4
Case incurred = paid + case = part 3 + case OR part 2 – part 4








Part 5 – 3 sections
section 1
section 2
section 3
- Cumulative # of CWP claims w/ loss pmt direct & assumed at year end
- Cumulative # of outstanding claims w/ loss pmt direct & assumed at year end
- Cumulative # of reported claims w/ loss pmt direct & assumed at year end
Stuff we can do w/ schedule P part 5
- Claim closure rate =
- CWP rate =
- Avg closed claim severity =
- Avg case outstanding severity =
- Avg reported claim severity =
- Clm frequency =
- Claim closure rate = closed ÷ reported = (section 3 – section 2) ÷ section 3
- CWP rate= CWP ÷ closed = section 1 ÷ (section 3 – section 2)
- Avg closed clm severity = net paid loss & DCC ÷ total claims closed = P3 / (P5 section 3 – P5 section 2)
- Avg case outstanding severity = net case outstanding loss & DCC ÷ total open clms = (P2-P3-P4) / P5 section 2
- Avg reported claim severity = net reported loss & DCC ÷ total reported clms= (P2-P4) / P5 section 3
- Clm frequency = claim counts ÷ Earned Premium
Why claim closure rate change? (3)
- cats –> claims ↑
- ∆in staffing
- PIF growth–> claims↑
Why severities change?(4)
- inflation
- cats
- law change
- claims practice to settle certain size clm first






Purpose of part 6 – cumulative EP for 10 CYs (2)
- Develop EP to ultimate
- Show prior 9 CYs EP adjusted up (for premium audits, lags, retrospectively rated policies) so surplus is not understated








Schedule P interrogatories (4)
most important one
- ***Changes or anything special that user should be aware of to assess reserve adequacy? Disclose if yes
- How LAE reported? (DCC or A&O)
- Rsvs net or gross of non-tabular discount
- reported claims counts per claim or claimant
Adverse development reasons (2)
- PIF growth
- Large clm from old AY
Yearly reporting convention
- Accident yr (occurrence policy)
- Report yrr (claims-made policies)
- Policy yr (tail policies)
- Discovery yr (fidelity /surety policies)
2 categories of LAE
DCC – defense ligation & medical cost containment expenses
A&O –fees, salaries, expense of employees working in claim adjusting capacity
Schedule P intercompany pooling formulas for prem or rsvs
Gross rsvs co A
net rsvs co A
Gross rsvs co A
- Total direct L&LAE * pool % A
net rsvs co A
- Total net L&LAE * pool % A


Non-Schedule P intercompany pooling formulas for prem or rsvs
Gross rsvs (or prem) lead A
Gross rsvs (or prem) non-lead B
net rsvs (or prem) co A
Gross rsvs lead A & gross rsvs non-lead B
- Gross rsvs for lead A = A direct rsvs + B net rsvs +C net rsvs
- Gross rsvs for non-lead B = B direct rsvs + toal net rsvs* B pool%
net rsvs co A
- Same as schedule P: Total net L&LAE * pool % A



