lossrx

Getting Started with lossrx

#> ℹ Loading lossrx

Overview

This vignette introduces readers to methods used by actuaries to analyze and model insurance claims data, specifically, how to apply Loss Reserving techniques.

NOTE:

  • This vignette is specific to Loss Reserving (also known as claims reserving) for Property and Casualty (P&C, or general, non-life) insurance products.
  • In particular, this vignette walks through some of the basic, yet essential, analytic tools actuaries use to assess the reserves on a portfolio of P&C insurance products.

Life Cycle of a Claim

Our starting point is the Lifetime of a P&C Insurance Claim.

The figure below pictures the development of such a claim over time and identifies the events of interest:

The insured event or accident occurs at time tocc. This incident is reported to the insurance company at time trep, after some delay. If the filed claim is accepted by the insurance company, payments will follow to reimburse the financial loss of the policyholder. In this example the insurance company compensates the incurred loss with loss payments at times t1, t2 and t3. Eventually, the claim settles or closes at time tset.

Various Events throughout Life of a Claim

The different types of claim transactions over the life of an individual insurance claim could include:

  • Establishment of the initial case outstanding estimate
  • Notification to the reinsurer if the claim is expected to exceed the insurer’s retention
  • A partial claim payment to injured party
  • Expense payment for independent adjuster
  • Change in case outstanding estimate
  • Claim payment (assumed to be final payment)
  • Takedown of case outstanding and closure of claim
  • Reopening of the claim and establishment of a new case outstanding estimate
  • Partial payment for defense litigation
  • Final claim payment
  • Final payment for defense litigation
  • Closure of claim

These events can be summarized in a unified Claim Fact Summary Document:

Table 1: Claim Fact Summary
Policy Period January 1, 2020 to December 31, 2020
Date of Accident February 18, 2020
Date of Claim Report March 3, 2020
Date Transaction Reported Value of Claim to Date Cumulative Paid to Date
March 3, 2020 Case Outstanding Reserve of $15,000 Established for claim. $15,000.00 $0.00
April 1, 2020 Claim Payment of $1,500 - Case reduced to $13,500 (-$1,500) $15,000.00 $1,500.00
May 12, 2020 Expense Payment to IA of $500 - no change in case. $15,500.00 $2,000.00
September 1, 2020 Case increased to $30,000 (+$16,500) $32,000.00 $2,000.00
October 3, 2020 Claim thought to be settled with additional payment of $24,000 - case reduced to $0 (-$30,000) and claim marked as Closed. $26,000.00 $26,000.00
January 15, 2021 Claim Re-Opened with case outstanding set at $10,000 for claim and $10,000 for defense costs. $46,000.00 $26,000.00
February 19, 2021 Final defense cost payment for an additional $6,000 - case for defense costs zeroed out and claim set to Closed. $52,000.00 $52,000.00

As you can see there is quite a lot of detail that a single insurance claim can contain over the course of its lifetime.

It is important to note all the various important Dates associated with each claim:

  • Policy effective date is the date the insurer issues the insurance policy (January 1, 2020)
  • Accident date, or date of loss, is the date the covered injury occurs (February 18, 2020)
  • Report date is the date the insurer receives notice of the claim (March 3, 2020)
  • Transaction date is the date on which either a case outstanding transaction takes place or a payment is made (see all the dates in the preceding table)
  • Closing dates are the dates on which the claim is initially closed (October 3, 2020) and finally closed (February 19, 2021)
  • Reopening date is the date the insurer reopens the claim (January 15, 2021)

Viewing Claim Historical Transactions with lossrx

lossrx provides some convenient helper functions for viewing the timeline and informative details over the course of an individual claim’s lifetime by pulling the specified claim’s transaction data directly from the Actuarial Database:

claims <- claims_transactional

# get a random claim
claim <- claims[round(runif(1, 1, nrow(claims)),0), "claim_id"][[1]]

# gather claim history
claim_history <- view_claim_history(claim, claims_data = claims)

Claim Historical Timeline

Note: Click on a Date to view information about the transaction that occurred.

Claim History Details

Claim Details
Claim ID Claimant State Accident Date Report Date Close Date
claim-2919 Hernandez, Roger TX 2019-09-23 2019-10-15 2020-09-18

Claim Transactional History

Claim Transactional History
Transaction Date Paid Details Case Reserve Details Reported Details Status Change Cumulative Paid Cumulative Case Reserve Cumulative Reported
2019-10-15 Paid: Increased by $104.00 Case Reserve: Increased by $550.00 Reported: Increased by $654.00 NEW -> Open $104 $550 $654
2019-12-07 Paid: Increased by $4,117.00 Case Reserve: Decreased by $-50.00 Reported: Increased by $4,067.00 Open -> Open $4,221 $500 $4,721
2020-01-26 Paid: Increased by $12,641.00 Case Reserve: No Change Reported: Increased by $12,641.00 Open -> Open $16,862 $500 $17,362
2020-04-03 Paid: Increased by $1,103.00 Case Reserve: No Change Reported: Increased by $1,103.00 Open -> Open $17,965 $500 $18,465
2020-06-13 Paid: Increased by $109.00 Case Reserve: Increased by $205.00 Reported: Increased by $314.00 Open -> Open $18,074 $705 $18,779
2020-07-31 Paid: Increased by $1,490.00 Case Reserve: Decreased by $-205.00 Reported: Increased by $1,285.00 Open -> Open $19,564 $500 $20,064
2020-09-18 Paid: Increased by $4,481.00 Case Reserve: Decreased by $-500.00 Reported: Increased by $3,980.00 Open -> Closed $24,044 $0 $24,044

Workflow