Building Expense Provisions from Ledger Data

From Ledger Accounts to Rate Provisions

A ledger records amounts by accounting account or department; a rate provision must represent the costs expected to be funded by the rates. Those are related but not identical tasks. A ledger label such as “operations” does not, by itself, reveal whether a cost belongs in a rate, whether it varies with premium or policy count, or how it should be allocated across exposures.

The practical task is to make an explicit bridge from each eligible ledger amount to a provision with a defined basis. A provision can be a dollar amount per exposure, a percentage of premium, a percentage of losses, or another unit-based amount when that unit is the appropriate cost driver. The ledger period and the denominators used to calculate the loads must be suitable for the same portfolio and period.

Definition: An expense provision is the amount or rate component included to fund an eligible operating cost. An expense’s cost driver is the measured activity or financial base that best explains how that cost is incurred. A fixed expense per exposure is a dollar provision calculated by dividing eligible fixed expenses by the applicable exposure count. A percentage expense load is a ratio of eligible expenses to a specified base, such as premium or losses.

This tutorial is aligned with the CAS Exam 5 (Basic Ratemaking and Estimated Claim Liabilities) syllabus. The focus is the mapping and calculation process, not a full accounting reconciliation or the selection of a final rate level.

Classify the Cost Before Calculating a Load

Start with the nature of the cost and the activity that generates it. Common categories include the following. These are behavioral descriptions, not rules based solely on account names: the same named account can contain costs with different drivers.

Fixed or per-policy expenses: costs that do not vary directly with premium or losses over the relevant range, such as policy issuance or routine account administration. A policy-count or exposure-count basis may be appropriate.
Premium-variable expenses: costs that change with written or collected premium, such as commissions set as a percentage of premium. Calculate the percentage against the premium base to which the provision will apply.
Loss-related expenses: costs that vary with losses or claim payments, if the underlying expense process supports that relationship. A loss-related ratio is expenses divided by the corresponding loss base.
Activity-driven expenses: costs generated by a measurable activity, such as claim handling driven by claim counts or billing work driven by transaction counts. These may first be expressed per activity unit and then translated to the rate basis.

Do not treat every ledger debit as a ratemaking expense. For example, an investment expense or income tax generally does not belong in an underwriting expense provision simply because it appears in the ledger. A one-time system conversion may also be unsuitable as a recurring provision without a reasoned adjustment. Conversely, a cost should not be excluded merely because its account title sounds general; its purpose and treatment matter.

Keep the boundaries between components clear. Claim losses belong in the loss provision; eligible claim-handling expenses can belong in an expense provision, using the selected expense basis. A ledger amount already represented elsewhere must not be added again. That check is important even when the arithmetic for each individual load is correct.

A Consistent Mapping and Calculation Process

A useful workflow is to record, for each ledger item, its amount, eligibility, behavior, allocation driver, and final rate basis. When an account includes more than one type of cost, split it if the underlying data support a split rather than forcing the entire amount into one category.

Identify eligible costs.
Review the purpose and recurring nature of each item. Set aside amounts that do not belong in the underwriting expense provision, and document any adjustment.

Classify behavior and driver.
Determine whether the cost is fixed, premium-variable, loss-related, or driven by an activity such as policies, claims, or transactions.

Allocate shared amounts.
For a shared cost, use a driver that reflects the service consumed. A claim-processing cost may be allocated by claim counts; a policy-service cost may be allocated by policies or exposures.

Calculate the provision and check it.
Divide the eligible amount by its selected base, then verify that the resulting provision, applied to that base, reproduces the amount being funded.

The basic calculations follow directly from the selected drivers. Let $E_F$ be eligible fixed expenses and $N$ be the relevant number of exposures. Let $E_P$ be premium-variable expenses and $P$ their matching premium base. Let $E_L$ be loss-related expenses and $L$ their matching loss base.

\text{Fixed expense per exposure}=\frac{E_F}{N}, \qquad \text{Premium expense ratio}=\frac{E_P}{P}, \qquad \text{Loss expense ratio}=\frac{E_L}{L}.

These ratios are not interchangeable. Dividing commissions by exposure count produces a dollar amount per exposure for the observed portfolio, but it does not preserve a commission rate when premium per exposure changes. Likewise, dividing claim-handling expense by losses yields a loss-related percentage only when losses are the selected and appropriate driver.

Why the Denominator Determines the Provision

The formulas are consequences of how the provision is intended to fund costs. Suppose a premium-variable expense is expected to remain a proportion $r_P$ of premium $P$. Then the funded expense is $E_P=r_P P$. Solving for the proportion gives $r_P=E_P/P$. Applied to a different premium amount $P'$, the provision becomes $r_P P'$, so it changes in proportion to premium.

For a fixed expense per exposure, suppose the expected cost is $c_F$ for each of $N$ exposures. The total is $E_F=c_F N$, so $c_F=E_F/N$. If the rate basis produces $N'$ exposures, the corresponding funded amount is $c_F N'$. Thus the calculation represents a different cost assumption from a premium percentage: it funds a fixed dollar amount per exposure rather than a fixed fraction of premium.

This justification also states the limits of the formulas. They do not establish that a cost truly varies with the chosen base, nor do they make mismatched periods or populations comparable. The analyst must choose the driver from the expense’s behavior and use a denominator consistent with the ledger amount and intended application.

Worked Example: Separating Eligible Ledger Items by Behavior

A hypothetical small-commercial portfolio has 12,000 exposures, $1,500,000 of the specified premium base, and $900,000 of losses. Its ledger includes $180,000 of policy administration, $48,000 of policy-document mailing, $120,000 of commissions, and $18,000 of claim handling. The ledger also includes $35,000 of investment expense and a one-time $20,000 system conversion. Calculate the expense provisions from the eligible items.

Method. Classify the costs by behavior and use the corresponding exposure, premium, or loss base. The investment expense and one-time conversion are not included in this hypothetical underwriting expense provision.

Fixed costs. Policy administration and policy-document mailing are specified as per-policy costs. Their combined eligible amount is $180{,}000+48{,}000=\$228{,}000$. Therefore:

\frac{\$228{,}000}{12{,}000\text{ exposures}}=\$19.00\text{ per exposure}.

Premium-variable costs. Commissions are specified as proportional to premium. Their percentage load is:

\frac{\$120{,}000}{\$1{,}500{,}000}=0.08=8.00\%.

Loss-related costs. Claim handling is specified as proportional to losses for this example. Its loss-related ratio is:

\frac{\$18{,}000}{\$900{,}000}=0.02=2.00\%.

Check. Applying each provision to its stated base gives $228,000 fixed, $8\%\times\$1{,}500{,}000=\$120{,}000$ premium-variable, and $2\%\times\$900{,}000=\$18{,}000$ loss-related. The total eligible expense is $\$228{,}000+\$120{,}000+\$18{,}000=\$366{,}000$, matching the included ledger items. The common mistake avoided is placing every ledger item in a single expense ratio; the excluded items have not been treated as recurring underwriting provisions.

Allocate Shared Costs Through Their Drivers

Some ledger expenses serve multiple groups or coverages. Allocation should follow the activity that generates the cost as closely as the available data permit. An allocation based only on convenience can shift costs between groups and distort their provisions. Once the shared amount is allocated, calculate each group’s provision using its own matching base.

Worked Example: Allocating Shared Administration and Claim Service

A hypothetical insurer has two policy groups. Group A has 10,000 exposures and 4,800 claims; Group B has 15,000 exposures and 3,200 claims. A shared policy-administration ledger amount of $120,000 is assigned by exposure count. A $72,000 claim-service amount is assigned by claim count. Find the resulting expense per exposure for each group.

Policy administration. Total exposures are $10{,}000+15{,}000=25{,}000$. The common cost per exposure is $\$120{,}000/25{,}000=\$4.80$. Group A receives $10{,}000\times\$4.80=\$48{,}000$; Group B receives $15{,}000\times\$4.80=\$72{,}000$. Each group therefore has a policy-administration provision of $4.80 per exposure.

Claim service. Total claims are $4{,}800+3{,}200=8{,}000$. The service cost per claim is $\$72{,}000/8{,}000=\$9.00$. Group A receives $4{,}800\times\$9.00=\$43{,}200$, or $\$43{,}200/10{,}000=\$4.32$ per exposure. Group B receives $3{,}200\times\$9.00=\$28{,}800$, or $\$28{,}800/15{,}000=\$1.92$ per exposure.

Combined result and check. Group A’s two expense provisions total $\$4.80+\$4.32=\$9.12$ per exposure. Group B’s total $\$4.80+\$1.92=\$6.72$ per exposure. Across the portfolio, the provisions fund $\$48{,}000+\$72{,}000+\$43{,}200+\$28{,}800=\$192{,}000$, exactly the two ledger amounts. The common mistake avoided is allocating claim service by exposures alone: the stipulated driver is claim count, so groups with different claim counts per exposure receive different claim-service loads per exposure.

Combining Provisions Without Mixing Their Bases

A rate calculation may use more than one expense basis at the same time. Keep each component in its own units until it is applied: a dollar amount per exposure is not a percentage of premium, and a percentage of losses is not a percentage of premium. An equivalent dollar total can be calculated for a stated portfolio only after the relevant per-exposure premium and loss amounts are known.

Worked Example: Translating Ledger Loads to a Per-Exposure Amount

A hypothetical book has 9,000 exposures, a premium base of $4,500,000, and losses of $1,800,000. Eligible ledger items are $54,000 of fixed policy service, $270,000 of commissions, $90,000 of premium taxes, and $27,000 of loss-related claim support. Calculate each provision and the combined expense amount per exposure for this portfolio.

Fixed provision. Divide fixed policy service by exposures: $\$54{,}000/9{,}000=\$6.00$ per exposure.

Premium-variable provision. Combine the two costs specified as proportional to premium: $\$270{,}000+\$90{,}000=\$360{,}000$. The premium expense ratio is $\$360{,}000/\$4{,}500{,}000=0.08=8.00\%$. Average premium per exposure is $\$4{,}500{,}000/9{,}000=\$500$, so the portfolio-equivalent premium load is $8\%\times\$500=\$40.00$ per exposure.

Loss-related provision. The loss expense ratio is $\$27{,}000/\$1{,}800{,}000=0.015=1.50\%$. Losses per exposure are $\$1{,}800{,}000/9{,}000=\$200$, so the equivalent load is $1.5\%\times\$200=\$3.00$ per exposure.

Combined result and check. The equivalent expense amount is $\$6.00+\$40.00+\$3.00=\$49.00$ per exposure. Across 9,000 exposures, that is $\$49.00\times9{,}000=\$441{,}000$. The ledger total is $\$54{,}000+\$360{,}000+\$27{,}000=\$441{,}000$, so the calculation checks. The common mistake avoided is adding the 8.00% and 1.50% ratios as though they had the same denominator; they apply to different bases.

Common Mistakes and Practical Checks

Classifying by account title alone. Determine what activity caused the cost. A “service” account might contain per-policy work, claim-count-driven work, or both.
Choosing a denominator for convenience. Use exposure count, premium, losses, or another activity measure only when it matches the expense behavior and the intended provision.
Including nonrecurring or unrelated costs without review. Evaluate whether an item belongs in the underwriting provision and whether it represents an ongoing cost.
Mixing percentage bases. State whether each ratio is a percentage of premium, losses, or another base; do not add percentages with different denominators as if they were equivalent.
Failing to check the totals. Multiply each provision by its selected base. Allocated amounts should add back to the eligible ledger total, subject to any explicitly documented adjustment or rounding.
Counting the same cost twice. Verify that an expense is not already included in another component before adding a separate ledger-based load.

Key takeaway: A ledger amount becomes a useful rate provision only after its eligibility, behavior, allocation driver, and denominator are stated. Calculate each load on its own basis, then verify that applying the loads funds the intended eligible costs.

Check Your Understanding

For each problem, identify the relevant driver and calculate the requested provision.

A hypothetical portfolio has 10,000 exposures and $250,000 in eligible fixed policy expenses. What is the fixed expense provision per exposure? (Answer: $25.00 per exposure)
A service unit incurs $24,000 of claim-processing expense for 1,200 claims in a book with 6,000 exposures. If claim count is the selected driver, what is the claim cost per claim and its equivalent per exposure? (Answer: $20.00 per claim and $4.00 per exposure)
A book has $800,000 of premium, 4,000 exposures, and $48,000 of commission expense specified as proportional to premium. It also has $36,000 of fixed expenses. Find the commission ratio and combined equivalent expense per exposure. (Answer: 6.00% of premium; $21.00 per exposure, using $200 average premium per exposure)
A hypothetical insurer allocates $90,000 of shared policy service by exposure count. Group A has 6,000 of the portfolio’s 15,000 exposures. How much is allocated to A, and what is its provision per exposure? (Answer: $36,000 allocated to A; $6.00 per exposure)
A book has $1,200,000 of losses and $18,000 of eligible loss-related expense. Separately, its premium-variable expense is $40,000 on a $1,000,000 premium base. State both ratios with their bases; should the two percentages be added as one load? (Answer: 1.50% of losses and 4.00% of premium; no, they have different bases.)

What You'll Learn