Insurance loss ratio and combined ratio calculator

Enter your quarter’s earned premium, incurred claims and expenses by line to see each combined ratio and underwriting result.

Lines of business
LineEarned premium, €Incurred claims, €Expenses, €

A line with no earned premium is left out, so you can use fewer than five lines.

This book and its five lines are made up.

Combined ratio

96.3%
Loss ratio67.0%
Expense ratio29.3%
Underwriting result€1,007,000

Across all lines, the combined ratio is 96.3%, with an underwriting profit of €1,007,000.

The combined ratio is above 100% for 2 lines, Motor, Liability, which lose money on underwriting.

Combined ratio by line of business

Ratios by line

LineLoss ratioExpense ratioCombined ratioUnderwriting result
Motor74.0%27.0%101.0%−€120,000
Home56.0%32.0%88.0%€780,000
Commercial property57.0%30.0%87.0%€546,000
Liability87.0%26.0%113.0%−€403,000
Travel40.0%43.0%83.0%€204,000
Total67.0%29.3%96.3%€1,007,000

Get the result by email

Change the rating factors, referral limits and underwriting rules for lines above 100% in your own rules, then test them before they go live. Start your trial

How the combined ratio is calculated

The loss ratio is incurred claims divided by earned premium, and the expense ratio is expenses divided by earned premium. The combined ratio adds the two, and above 100% a line pays out more than it earns.

Loss ratio = Incurred claims ÷ Earned premium
Expense ratio = Expenses ÷ Earned premium
Combined ratio = Loss ratio + Expense ratio
Underwriting result = Earned premium − Incurred claims − Expenses

The figures below work through each line and all lines using the numbers above.

Motor: 8,880,000 ÷ 12,000,000 = 74.0%; 3,240,000 ÷ 12,000,000 = 27.0%; 74.0% + 27.0% = 101.0%; 12,000,000 − 8,880,000 − 3,240,000 = −€120,000
Home: 3,640,000 ÷ 6,500,000 = 56.0%; 2,080,000 ÷ 6,500,000 = 32.0%; 56.0% + 32.0% = 88.0%; 6,500,000 − 3,640,000 − 2,080,000 = €780,000
Commercial property: 2,394,000 ÷ 4,200,000 = 57.0%; 1,260,000 ÷ 4,200,000 = 30.0%; 57.0% + 30.0% = 87.0%; 4,200,000 − 2,394,000 − 1,260,000 = €546,000
Liability: 2,697,000 ÷ 3,100,000 = 87.0%; 806,000 ÷ 3,100,000 = 26.0%; 87.0% + 26.0% = 113.0%; 3,100,000 − 2,697,000 − 806,000 = −€403,000
Travel: 480,000 ÷ 1,200,000 = 40.0%; 516,000 ÷ 1,200,000 = 43.0%; 40.0% + 43.0% = 83.0%; 1,200,000 − 480,000 − 516,000 = €204,000
All lines: 18,091,000 ÷ 27,000,000 = 67.0%; 7,902,000 ÷ 27,000,000 = 29.3%; Combined ratio = 96.3%; Underwriting result = €1,007,000

Investment income, reinsurance and taxes are not included. The expense ratio is calculated on earned premium.

Insurance loss and combined ratio calculator

The combined ratio adds the loss ratio and expense ratio. This calculator uses incurred claims, expenses and earned premium to work out each line’s ratios and underwriting result.

The whole-book result can show an underwriting profit even when individual lines lose money. Review each line’s combined ratio and underwriting result before the next pricing or underwriting review.

Common questions

How do you calculate an insurance loss ratio?

Divide incurred claims by earned premium to calculate the loss ratio. The calculator works it out for each line and for the whole book.

How do you calculate an insurance combined ratio?

Add the loss ratio and expense ratio. The loss ratio is incurred claims divided by earned premium, and the expense ratio is expenses divided by earned premium.

How is the expense ratio calculated in insurance?

Divide expenses by earned premium to calculate the expense ratio. The expenses in this calculator are commission and administration together.

What does a combined ratio above 100% mean?

The line pays out more than it earns from earned premium, claims and expenses. Its underwriting result is a loss.

How do you calculate underwriting profit by line of business?

Subtract incurred claims and expenses from earned premium for each line. A positive underwriting result is a profit, and a negative result is a loss.