Insurance financial modeling: premiums, claims and costs

Insurance financial modeling links earned premiums, incurred claims and operating expenses on a consistent basis. Build those schedules in a workbook, reconcile them to approved finance records, and then compare the effect of changed assumptions. Keep actuarial reserve decisions with the specialists who own them.

Start with the reporting boundary

Choose one insurance carrier, one reporting period and one accounting basis. The example below is an illustrative US property and casualty carrier's annual operating plan in USD. It measures underwriting contribution before investment income, financing items and income taxes.

Use retained premium and claim figures on the same basis after applicable reinsurance effects. Do not subtract ceded premiums from an already net premium export or subtract recoveries from claims that are already net. Record the source basis beside each schedule.

This is carrier finance. An agency earning commissions needs a different revenue schedule; the insurance agency monthly finance pack covers that job. For a wider planning structure, use the guide to financial modeling.

The IRS instructions for Form 1120-PC separately identify schedules for premiums earned and losses incurred. That separation is useful context, but this management workbook does not reproduce tax-return adjustments or replace statutory reporting.

Assemble the export and assumption rows

Bring the premium ledger, opening and closing unearned premium balances, an approved incurred-claim schedule, and operating expense records. Use monthly rows by line of business when available. Keep the annual rollup tied to the same underlying months.

Each row should identify period, business line, account, amount, reporting basis and source reference. Store assumptions separately from actual amounts. A claim ratio supplied by the responsible specialists is an assumption; a settled claim payment is a cash transaction. They answer different questions.

The timing distinction matters. IRS Publication 538 describes accrual reporting as recognizing income when earned and expenses when incurred, rather than when money changes hands. Its tax guidance is not an insurer accounting policy, but it illustrates why a cash export cannot simply stand in for an underwriting schedule.

Use approved unearned premium balances rather than estimating earning patterns from one annual total. Product terms and coverage timing can make a simple spread unsuitable.

Calculate the base operating plan

For this example, assume no unearned premium movements other than the opening balance, written premiums and closing balance shown below. All premium figures use the same retained basis. Claim costs include the loss adjustment expenses specified by the supplied assumption.

Earned premiums = Opening unearned premiums + Written premiums - Closing unearned premiums

Underwriting contribution = Earned premiums - Incurred claims - Defined operating expenses

Put the following labels in column A and their values or formulas in column B. The first data row is spreadsheet row 2.

These spreadsheet formulas rebuild the calculated lines:

B5 = B2+B3-B4
B7 = B5*B6
B11 = SUM(B8:B10)
B12 = B5-B7-B11

The expense amounts are recognized operating expenses, not necessarily cash paid. Acquisition-cost recognition must follow the chosen accounting basis. Do not replace that amount with commission checks issued during the year.

Divide claims and expenses by earned premiums for an internal view of the cost burden:

Claim share = B7/B5
Expense share = B11/B5
Total underwriting cost share = (B7+B11)/B5

The results are 65.0%, 20.0% and 85.0%, respectively. These are explicitly defined management ratios with an earned-premium denominator. Do not label the last figure a published combined ratio without checking the required expense denominator and reporting convention.

Change one assumption and explain the difference

Keep earned premiums and expenses fixed and increase the supplied claim assumption from 65.0% to 70.0%. This is a sensitivity, not a recommendation about pricing or reserves.

Contribution falls by $580,000. The complete bridge is earned premiums multiplied by the five percentage point change: $11,600,000 times 5.0%. Calculate using unrounded values; percentages here are displayed to one decimal place and dollar amounts to whole dollars.

Finance can now ask which expense commitments remain affordable under the supplied stress. It cannot infer that claim severity, frequency or reserve adequacy changed without separate evidence. Keep the broader AI financial modeling discussion separate from the specialist assumptions behind this workbook.

Prove the schedules before reviewing them

The premium rollforward must return the closing balance:

Premium balance check = B2+B3-B5-B4
Contribution check = B5-B7-B11-B12

Both checks must be zero. The first proves that $1,800,000 plus $12,000,000 less $11,600,000 equals the supplied $2,200,000 closing balance. The second proves that the result includes every cost in the defined scope.

Also reconcile earned premiums and operating expenses to the approved planning schedules. Compare actual periods using actual incurred-claim figures supplied on the same basis. Keep claim payment timing, premium collection timing and investment cash flows in a separate cash schedule.

Where it goes wrong

• Written premiums treated as earned. Growth in unearned premiums makes the revenue timing difference material.
• Paid claims mixed with incurred claims. Cash settlements do not describe all claim costs attributable to the period.
• Gross and net figures combined. Reinsurance can be counted twice or omitted when source bases differ.
• Expense recognition changes between scenarios. A change in accounting treatment can look like an operating improvement.
• One ratio presented as a regulatory conclusion. Internal operating sensitivities do not establish solvency, reserve adequacy or policy prices.

Compare your prepared results in Covirage

Bring your prepared premium, claim and expense workbook to Covirage; its tools map the columns, compute and check the supplied figures, and the external AI model explains the scenario differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data; account creation takes about a minute.

See Covirage for financial services for the supporting business context.