Loss Study Guide With Examples

How Loss Studies Actually Work in Practice

A loss study is a statistical analysis of historical loss data used to determine appropriate rates for an insurance line of business. In workers' comp and commercial property especially, every bureau filing or rate change rests on one. Most people treat it like a template exercise where you plug numbers into a spreadsheet and hope the output looks right. It isn't that simple, and treating it like one will get you fired or audited. I need to explain the mechanics first because the definition comes after you understand what you're actually building. You start by gathering exposure units and loss payments across multiple accident years. Then you calculate incurred losses per unit of exposure, adjust for inflation and trend, and derive a pure premium. That pure premium feeds directly into rate making. The whole thing collapses if your data is dirty, which is most of the time.

Loss Study Guide With Examples

Here is the practical flow. You pull your GL data for the years you are studying. Say you have five accident years: 2018 through 2022. You group by class code, say all general office workers' comp, and sum the incurred losses. You also need your earned premium or payroll exposure for those same years and classes. Then you compute the loss ratio by dividing total incurred losses by total earned premium. Let me give you a real example. Company A writes commercial auto. Their data looks like this: Year 2019: Earned premium $2,400,000. Incurred losses $960,000. Loss ratio 40 percent.

Year 2020: Earned premium $2,650,000. Incursed losses $1,113,000. Loss ratio 42 percent. Year 2021: Earned premium $2,900,000. Incurred losses $1,305,000. Loss ratio 45 percent. Year 2022: Earned premium $3,100,000. Incurred losses $1,550,000. Loss ratio 50 percent.

The trend is moving upward. You cannot just average those loss ratios and call it a day. The 2022 figure dominates and it is the most development-ready year. You need to trend those losses forward to the valuation date. Multiply each year's loss by a trend factor. If your loss cost trend for commercial auto is six percent annually, you'd compound from each accident year to the target date. That alone shifts your picture significantly. Then there is the credibility question. If a class has only $3 million in premium across five years, your manual or bureau rate might actually be more credible than your own experience. That is a common blind spot. Beginners always trust their own data first. It is not automatic. You calculate credibility using the Limited Fluctuation method or Buhlmann approach, depending on what your actuarial standard says. The rule of thumb for workers' comp is roughly $100,000 to $150,000 in expected losses for full credibility. Below that, you are blending with industry data until you have enough volume. Another step most people gloss over is the loss development factor application. Your incurred losses are not final. You need to project ultimate losses using a development triangle. Take your paid and incurred losses by development year, compute the cumulative development factors, and apply them to your latest diagonal. This turns reported losses into estimated ultimate losses, which is what you actually need for rate setting.

I ran into a problem last year with a mid-sized transportation client. Their loss history was full of large individual claims that looked like outliers. One claim in 2020 was $420,000 for a single tractor trailer total loss. Another in 2021 was $380,000 for a fleet collision. Together they skewed the average severity by nearly thirty percent. The instinct is to trim extreme claims, but that is dangerous. You cannot just delete large losses because they feel weird. Instead, I segmented the data by fleet size. Small fleets under five units had a completely different loss pattern than mid-size fleets of five to twenty units. The large claims belonged to the bigger fleets. By splitting the exposure groups, the anomalous losses stopped looking anomalous. They were just properly categorized. That workaround took about forty minutes but saved me from filing a rate that would have been rejected on review. The downsides of loss studies are not subtle. They are expensive to do right and they require clean data that very few companies actually have. Your accounting system may lump multiple class codes into a single premium code. Your claims system may record the accident date differently than your policy binding date. These mismatches will silently corrupt your results. You will spend more time cleaning data than analyzing it. Budget two to three weeks for a proper loss study on a standard commercial line if you are doing it in-house. Outsource it and you are looking at four to six weeks with a $15,000 to $40,000 price tag depending on complexity. A common pitfall is ignoring catastrophe exposure in your loss study. If your portfolio had a hurricane year or a pandemic year, the loss ratio from that period is not representative of normal experience. You either exclude that year entirely with a written justification, or you apply a catastrophe modification factor. Both approaches are defensible. Doing neither is not.

Another advanced nuance is the difference between retrospective and prospective loss studies. A retrospective study looks backward at what happened. A prospective study incorporates expected future changes like new safety technology, regulatory shifts, or changes in litigation environment. Most ratemakers want prospective. If you only deliver retrospective, your rates will be stale the moment they are filed. Software options exist. Guidewire, Applied Epic, and standalone actuarial platforms like Prophet or AXIS can automate parts of this. But none of them will save you from bad input. Garbage in is still garbage out regardless of what the software charges you per seat. If you want a simpler starting point, some state workers' compensation bureaus publish their own loss studies for free. Iowa, Texas, and Pennsylvania all have downloadable datasets. They are not perfect but they give you a benchmark to compare your own experience against. That comparison alone catches a lot of errors before you file anything.

The bottom line is that a loss study is only as good as your data hygiene and your willingness to challenge your own assumptions. The formula is straightforward. The execution is where people fail.