Building an Actual Loss Ratio from Experience Data

Introduction

An actual loss ratio summarizes the relationship between selected losses and the earned premium associated with an insurance experience. Its arithmetic is simple; constructing a meaningful ratio requires more care. A numerator for one coverage or period cannot be meaningfully divided by a denominator for a different coverage or period.

The task here is to build that ratio from experience data: identify the intended book of business, state the loss measure being used, aggregate the corresponding losses and earned premium, and check that the two totals describe a consistent experience. The ratio calculated in this tutorial is a descriptive ratio of the selected experience inputs. It is not, by itself, a rate indication.

Definition: For a stated experience scope and basis, the actual loss ratio is the selected loss amount divided by the earned premium for that same scope and basis. If $L$ denotes the selected losses and $EP$ denotes earned premium, then $$ \text{Actual loss ratio}=\frac{L}{EP}. $$ The result is commonly reported as a percentage. The loss measure must be specified—for example, paid losses or incurred losses, and whether allocated loss adjustment expense (ALAE) and recoveries are included.

Specify the Measure Before Adding the Data

“Losses” is not a complete description of a numerator. Paid losses generally refer to claim payments made by the valuation date. Incurred losses generally reflect amounts paid plus outstanding claim estimates, with applicable recoveries treated according to the chosen basis. These measures can differ materially. A ratio calculated using one should not be described as though it used the other.

The loss definition also needs to say whether ALAE is included. ALAE is claim-specific expense, such as an expense associated with handling a particular claim. A numerator that includes indemnity losses and ALAE must be built from both components consistently. If the selected measure excludes ALAE, do not add ALAE for only some records. Likewise, apply the stated treatment of salvage and subrogation recoveries consistently; do not subtract them from some losses but not others.

The denominator is earned premium, not written premium. Earned premium represents the portion of premium attributable to insurance coverage provided during the experience being measured. This tutorial uses the earned premium supplied for the intended experience basis; adjustments to put premiums on a different rate level are separate calculations.

Input question	What to specify	Why it matters
Which business?	Coverage, territory, class, or other selected scope	Losses and premium must refer to the same book
Which loss measure?	Paid, incurred, or another explicitly selected measure	Different measures can produce different numerators
What is in the loss amount?	Indemnity, ALAE, and treatment of recoveries	Partial or inconsistent inclusion distorts the ratio
Which premium?	Earned premium for the stated experience basis and scope	Written premium or unrelated earned premium is not the corresponding denominator

A reliable calculation starts with a specification, not a division. For example, “selected incurred indemnity and ALAE, net of stated recoveries, divided by earned premium for the same selected coverage” is more informative than “losses over premium.” The experience period and scope must also be compatible. The detailed task of matching period boundaries is treated separately; here, a mismatch is a reason to stop and verify the inputs rather than calculate an apparently precise ratio.

Building the Ratio From Records

Suppose each record $j$ has selected losses $L_j$ and earned premium $EP_j$. For a selected group of records, first sum each quantity across the same records, then divide the totals:

\text{Actual loss ratio} = \frac{\sum_j L_j}{\sum_j EP_j}.

The summation is important. In general, the overall ratio is not the simple average of the individual record ratios. A record with more earned premium contributes more weight to the aggregate result.

Key result: If $r_j=L_j/EP_j$ and each $EP_j$ is positive, then $$ \frac{\sum_j L_j}{\sum_j EP_j} = \frac{\sum_j EP_j r_j}{\sum_j EP_j}. $$ Thus, the aggregate loss ratio is the earned-premium-weighted average of the record-level ratios. It equals the simple average only in special cases, such as when all records have equal earned premium or their ratios happen to produce the same average.

To verify the result, substitute $L_j=EP_jr_j$ into the aggregate numerator. This gives $\sum_j L_j=\sum_j EP_jr_j$. Dividing both sides by the total earned premium gives the stated weighted-average formula. Because the weights $EP_j/\sum_jEP_j$ add to one, records with larger earned premium have larger influence on the aggregate ratio.

Define the intended scope.
Identify which coverage, class, or other business is included. Use the same selected records for losses and premium.

State the loss basis.
Specify paid or incurred losses and the treatment of indemnity, ALAE, and recoveries. Use that definition throughout the data.

Aggregate both quantities.
Sum the selected losses and the earned premium over the records in scope. Do not average record ratios unless the question specifically asks for that statistic.

Divide and check.
Divide total losses by total earned premium, report the result as a percentage, and confirm the numerator and denominator describe the same experience.

Worked Examples

Worked Example: Aggregating Selected Losses Across Period Records

A hypothetical insurer selects three quarterly records for one coverage. Each record uses the same selected incurred-loss definition and the corresponding earned premium. The data, in thousands of dollars, are:

Record	Earned premium	Selected incurred losses
Quarter 1	420	294
Quarter 2	380	304
Quarter 3	500	425

Calculate the actual loss ratio for the three records combined. Method: aggregate the selected losses and earned premium separately, then divide. This avoids averaging ratios without regard to premium size.

Step 1: Sum earned premium. $420+380+500=1{,}300$ thousand dollars.

Step 2: Sum selected losses. $294+304+425=1{,}023$ thousand dollars.

Step 3: Divide. $\frac{1{,}023}{1{,}300}=0.786923\ldots$, so the actual loss ratio is $78.69\%$, rounded to two decimal places.

Check: The losses and premium were summed over the same three records and are both in thousands of dollars, so the units cancel. The ratio is below 100%, consistent with selected losses of 1,023 against earned premium of 1,300.

Worked Example: Applying a Defined Incurred-Loss Basis

A hypothetical specialty policy group has earned premium of $360,000. For the selected experience, paid indemnity is $180,000, outstanding indemnity case reserves are $70,000, and salvage and subrogation recoveries are $10,000. Paid ALAE is $24,000 and outstanding ALAE reserves are $6,000. The stated numerator is incurred indemnity plus incurred ALAE, net of the listed recoveries. Calculate the actual loss ratio. Method: construct each incurred component using the stated definition before dividing. This avoids omitting reserves or counting only part of the loss measure.

Step 1: Calculate incurred indemnity net of recoveries. Paid indemnity plus case reserves is $180{,}000+70{,}000=250{,}000$. Subtract the specified recoveries: $250{,}000-10{,}000=240{,}000$.

Step 2: Calculate incurred ALAE. $24{,}000+6{,}000=30{,}000$.

Step 3: Combine the components required by the definition. Selected losses are $240{,}000+30{,}000=270{,}000$.

Step 4: Divide by earned premium. $\frac{270{,}000}{360{,}000}=0.75$, so the actual loss ratio is $75.00\%$.

Check: The numerator includes both incurred indemnity and incurred ALAE, with the listed recoveries subtracted once. It is divided by the earned premium for the specified group.

Worked Example: Combining Classes Without Taking a Simple Average

A hypothetical insurer reviews two classes using the same selected loss definition. Class A has earned premium of $240,000 and selected losses of $216,000. Class B has earned premium of $760,000 and selected losses of $532,000. Find each class’s actual loss ratio and the combined ratio. Method: calculate the class ratios for comparison, then use aggregate losses divided by aggregate premium for the combined ratio. This avoids treating the two classes as equally sized.

Step 1: Calculate Class A’s ratio. $\frac{216{,}000}{240{,}000}=0.90=90.00\%$.

Step 2: Calculate Class B’s ratio. $\frac{532{,}000}{760{,}000}=0.70=70.00\%$.

Step 3: Aggregate the amounts. Total selected losses are $216{,}000+532{,}000=748{,}000$. Total earned premium is $240{,}000+760{,}000=1{,}000{,}000$.

Step 4: Calculate the combined ratio. $\frac{748{,}000}{1{,}000{,}000}=0.748=74.80\%$.

Check: The premium-weighted calculation gives $\frac{240{,}000(90\%)+760{,}000(70\%)}{1{,}000{,}000}=74.80\%$. The simple average, $(90\%+70\%)/2=80\%$, is not the combined ratio because the classes have different earned premiums.

Common Traps and Interpretation

A plausible-looking percentage can still be wrong if one input does not correspond to the other. A common error is to include losses for a wider coverage scope than the premium—for example, adding losses from two coverages while dividing by earned premium for only one. Another is to mix loss definitions, such as combining paid losses from some records with incurred losses from others without an explicitly defined and consistently applied selection basis.

A further trap is to confuse the arithmetic with subsequent adjustments. This tutorial calculates the actual ratio from the selected losses and earned premium as given. It does not develop losses to ultimate, trend losses, or adjust earned premium to a different rate level. Those changes would create a different numerator or denominator and should be identified separately rather than silently folded into an “actual” ratio.

Common mistake: Suppose losses for two classes are $216,000 and $532,000, while their earned premiums are $240,000 and $760,000. An incorrect calculation is the simple average of the class ratios: $(90\%+70\%)/2=80\%$. The correction is to aggregate the matching amounts: $(216{,}000+532{,}000)/(240{,}000+760{,}000)=74.80\%$. The incorrect calculation gives equal weight to classes of unequal premium size.

The actual loss ratio is a compact summary, not a complete description of the experience. Always retain the underlying specification: the selected business, the loss basis, the treatment of expenses and recoveries, and the earned-premium amount. This makes the result interpretable and helps reveal a mismatch before it affects a later rate analysis. The construction principles here are aligned with the CAS Exam 5 (Basic Ratemaking and Estimated Claim Liabilities) syllabus.

Check Your Understanding

For each problem, state or follow the specified loss basis, aggregate the matching amounts, and report the requested ratio. Answers are rounded to two decimal places where needed.

A hypothetical account has earned premium of $125,000 in one selected record and $175,000 in another. Selected losses under the same definition are $82,500 and $105,000. Find the combined actual loss ratio. (Answer: 62.50%)
Two hypothetical coverage groups have earned premium of $400,000 and $250,000, with selected losses of $264,000 and $187,500, respectively. Both use the same loss definition. Calculate the combined actual loss ratio. (Answer: 69.46%)
Class A has earned premium of $180,000 and selected losses of $153,000; Class B has earned premium of $420,000 and selected losses of $294,000. Find both class ratios and the combined ratio. (Answer: Class A 85.00%; Class B 70.00%; combined 74.50%)
A hypothetical group has earned premium of $280,000. Paid indemnity is $140,000, case reserves are $60,000, recoveries are $8,000, paid ALAE is $18,000, and ALAE reserves are $4,000. The selected loss definition is incurred indemnity plus incurred ALAE, net of the stated recoveries. Calculate the actual loss ratio. (Answer: 76.43%)
A hypothetical analysis is limited to two territories. Territory A has earned premium of $240,000 and selected losses of $162,000; Territory B has earned premium of $160,000 and selected losses of $104,000. A third territory has earned premium of $300,000 and selected losses of $195,000, but is outside the requested scope. Calculate the actual loss ratio for the two selected territories and identify the result if the third territory is mistakenly included. (Answer: Correct scope 66.50%; incorrectly including the third territory gives 65.86%)

What You'll Learn