Skip to main content
Calcimator

Rate Filing Calculator

Calculate indicated rate changes for insurance rate filings using loss ratio and expense analysis.

About this calculator

This calculator applies the loss ratio method of insurance ratemaking, one of the standard techniques actuaries use to determine whether a book of business's rates need to change, following the treatment set out in the Casualty Actuarial Society's own Basic Ratemaking text (Werner & Modlin). Actual Loss Ratio is Ultimate Losses divided by Earned Premium -- what the insurer actually paid out (or expects to, including IBNR) relative to what it collected. Permissible Loss Ratio is 1 minus Variable Expense Ratio minus Profit Target: the loss ratio the insurer can afford while still covering its variable (premium-scaling) expenses and hitting its profit target. Indicated Rate Change compares the two, but with a twist that trips people up: Fixed Expense Ratio is added to Actual Loss Ratio in the numerator, not subtracted from Permissible Loss Ratio in the denominator.

That's because fixed expenses (overhead, salaries) don't scale with premium the way variable expenses (commissions, premium taxes) do -- they need to be covered dollar-for-dollar like losses, not treated as a percentage carve-out of future rate. So Indicated Rate Change = [(Actual Loss Ratio + Fixed Expense Ratio) / Permissible Loss Ratio] - 1, and Required Premium follows the same logic: (Ultimate Losses + Fixed Expense dollars) divided by Permissible Loss Ratio. This is one real, standard ratemaking formula among several an actuary might use (the pure premium method is another common alternative) -- actual insurance rate filings involve trend, development, and credibility adjustments this simplified calculator does not model, and are reviewed and approved by state insurance regulators before taking effect.

Inputs

$
$

Results

Indicated Rate Change

7.1%

Required Premium

$10,714,286.00

Actual Loss Ratio65%
Permissible Loss Ratio70%
Profit Provision$500,000.00

Figures current as of 2016. Source: Werner, G., and Modlin, C., Basic Ratemaking, 5th ed., Casualty Actuarial Society

How to Use This Calculator
  1. Enter the earned premium and ultimate losses for the experience period.
  2. Enter the fixed and variable expense ratios as a percentage of premium.
  3. Set the target underwriting profit percentage.
  4. Review the actual and permissible loss ratios along with the indicated rate change.
  5. Check the required premium and profit provision needed to meet the target loss ratio.

How the result changes with Earned Premium

Earned PremiumIndicated Rate ChangeRequired Premium
$5,000,000.00100%$10,000,000.00
$7,500,000.0038.1%$10,357,143.00
$15,000,000.00-23.9%$11,428,571.00
$25,000,000.00-48.6%$12,857,143.00

What each input means

Earned Premium
Total earned premium at current rate level
Ultimate Losses
Projected ultimate losses including IBNR and development
Fixed Expense Ratio (%)
Fixed expenses as a percentage of premium (overhead, salaries)
Variable Expense Ratio (%)
Variable expenses as a percentage of premium (commissions, taxes)
Profit Target (%)
Target underwriting profit as a percentage of premium

How this is calculated

Worked example, using the default values

  1. Identify Input Parameters
    5 parameters
    Earned Premium = 10000000, Ultimate Losses = 6500000, Fixed Expense Ratio (%) = 10, Variable Expense Ratio (%) = 25, Profit Target (%) = 5 = 5 input(s) provided
  2. Calculate Indicated Rate Change
    Indicated Rate Change
    7.1 = 7.1%
  3. Calculate Required Premium
    Required Premium
    10714286 = $10,714,286
  4. Calculate Actual Loss Ratio
    Actual Loss Ratio
    65 = 65%
  5. Calculate Permissible Loss Ratio
    Permissible Loss Ratio
    70 = 70%

Figures and sources

Engine last updated . Checked against 2 independently-derived tests — how we verify calculators. Built by Paul Gunder, a software engineer, not a licensed financial, medical, or legal professional.

Frequently Asked Questions

Why is Fixed Expense Ratio added to the loss ratio instead of subtracted from the permissible ratio, like Variable Expense Ratio?

Because the two expense types behave differently as rates change. Variable expenses (agent commissions, premium taxes) are set as a percentage of premium, so they scale automatically with any rate change -- that's why they reduce the Permissible Loss Ratio denominator. Fixed expenses (rent, salaries) are a roughly constant dollar amount regardless of the premium rate charged, so -- once expressed as a ratio to CURRENT premium -- they need to be covered in full, the same way losses do. Standard actuarial ratemaking (the loss ratio method, as laid out in the CAS's Basic Ratemaking text by Werner & Modlin) adds them to the loss side of the calculation for this reason.

What does a 0% Indicated Rate Change mean?

It means current rates are exactly adequate -- the loss ratio plus fixed expense ratio exactly matches what's permissible given the variable expense ratio and profit target, so Required Premium equals current Earned Premium. A positive Indicated Rate Change means rates are inadequate and need to increase to hit the profit target; a negative one means rates could decrease while still meeting it.

Is this the only method actuaries use to calculate rate indications?

No. The loss ratio method used here is one of the two most common approaches -- the other is the pure premium method, which works from loss and expense amounts per exposure unit rather than as ratios to premium. Real rate filings also typically apply loss trend (projecting losses forward to the future policy period) and loss development (accounting for claims not yet fully reported or settled), which this simplified calculator doesn't include.

Does a real insurance rate filing just submit this number to regulators?

No -- an actual rate filing is a much more detailed regulatory submission including trended and developed loss data, expense studies, credibility weighting against industry data, supporting actuarial exhibits, and often an actuary's signed statement of opinion. Most U.S. states require rate filings to be reviewed and approved (or at least filed and not disapproved) before new rates take effect. This calculator illustrates the core loss-ratio-method mechanics, not a filing-ready indication.

Why do Ultimate Losses matter more than reported losses?

Ultimate Losses are meant to represent the fully-developed cost of claims from the experience period, including losses reported but not yet fully paid and losses incurred but not yet reported (IBNR). Using only currently-reported losses would understate the true loss ratio for a still-developing accident period, since claims often take months or years to fully report and settle -- this calculator assumes you're providing an already-developed ultimate figure.

The questions that sit next to this one — chosen by subject, including calculators filed under a different category.

More in Insurance.