Auditing a Retrospective Premium Worksheet

Why Audit the Worksheet in Stages?

A retrospective premium worksheet can contain several individually reasonable entries and still produce an incorrect final premium. An effective audit does not start by checking whether the final number “looks right.” It traces every input to its formula component, recomputes each stage independently, and checks that the minimum and maximum apply to the correct amount.

The calculation here is deterministic: the worksheet supplies the plan inputs and loss amount, and the auditor checks the arithmetic and contractual order. No interest rate, mortality assumption, or probability distribution is needed for these calculations. A plan’s actual contract controls; the formula below is the specified structure for the hypothetical worksheets in this tutorial.

Definition: For a worksheet with basic premium $B$, reported losses $L$, loss conversion factor $c$, tax multiplier $t$, minimum premium $P_{\min}$, and maximum premium $P_{\max}$, calculate converted losses as $cL$. The unbounded retrospective premium is $U=(B+cL)t$. When $P_{\min}\leq P_{\max}$, the final premium is $P=\min(\max(U,P_{\min}),P_{\max})$. The minimum and maximum are bounds on the premium after the tax multiplier in this stated formula.

The worksheet may label inputs differently, but the auditor should be able to map every figure to a specific role in the formula. The basic premium is the fixed premium component. Reported losses are converted using the loss conversion factor before being added to the basic premium. The tax multiplier then applies to that combined amount. Finally, the minimum and maximum constrain the unbounded premium.

This order is important. It is not enough to find the same numbers somewhere on the worksheet: a number in the wrong component, or a bound applied to the wrong intermediate amount, can change the result. First establish the contract’s formula and the meaning of each input; then check the arithmetic.

A Trace-and-Recompute Audit

A practical audit separates the worksheet into stages. The independent calculation should use the source inputs, not merely copy a worksheet subtotal into a calculator. That makes it possible to locate a discrepancy rather than only discover that one exists.

Identify the governing formula.
Confirm that the worksheet uses the specified formula and determine whether the minimum and maximum apply to the premium after the multiplier.

Trace the inputs.
Match the basic premium, reported losses, loss conversion factor, tax multiplier, and bounds to their stated sources. Check units and periods as well as values.

Recompute each component.
Calculate converted losses $cL$, add the basic premium, and apply the tax multiplier. Keep the intermediate amounts visible.

Apply and check the bounds.
Compare the unbounded premium $U$ with both limits. Apply the minimum floor and maximum ceiling, then confirm the final amount is between the two limits.

Reconcile the worksheet.
Compare each independently calculated line with the corresponding worksheet line. Identify the first differing component and carry the correction through to the final premium.

\begin{aligned} \text{Converted losses} &= cL,\\ \text{Subtotal before tax} &= B+cL,\\ U &= (B+cL)t,\\ P &= \min\bigl(\max(U,P_{\min}),P_{\max}\bigr). \end{aligned}

The formula’s order follows the stated plan structure. Each dollar of reported loss contributes $c$ dollars of converted loss, so $L$ reported dollars contribute $cL$. The converted losses are added to the basic premium, producing $B+cL$. Since the tax multiplier applies to that combined amount, the unbounded premium is $(B+cL)t$. The contractual bounds then limit this premium, rather than changing the loss conversion or the subtotal.

The final expression also gives a direct check. If $U<P_{\min}$, the final premium must be $P_{\min}$. If $P_{\min}\leq U\leq P_{\max}$, it must be $U$. If $U>P_{\max}$, it must be $P_{\max}$. Provided $P_{\min}\leq P_{\max}$, the result must always satisfy $P_{\min}\leq P\leq P_{\max}$.

Worked Worksheet Audits

Worked Example: Recomputing a Worksheet Within the Bounds

A hypothetical account’s worksheet lists a basic premium of $80,000.00, reported losses of $120,000.00, a loss conversion factor of 1.10, a tax multiplier of 1.05, a minimum premium of $200,000.00, and a maximum premium of $350,000.00. The worksheet shows converted losses of $120,000.00 and an unbounded premium of $210,000.00. Audit the result.

Method and assumptions. Use the stated retrospective premium formula $U=(B+cL)t$, followed by the minimum and maximum bounds. These are hypothetical worksheet inputs; no interest rate, mortality assumption, or probability distribution enters the arithmetic.

1. Trace and recalculate converted losses. The reported loss amount is $L=\$120{,}000.00$, and the loss conversion factor is $c=1.10$. Therefore,

cL=1.10(\$120{,}000.00)=\$132{,}000.00.

The worksheet’s converted-loss entry of $120,000.00 does not match the formula. It appears to omit the conversion factor. The corrected converted losses are $132,000.00.

2. Recalculate the subtotal. Add the basic premium:

B+cL=\$80{,}000.00+\$132{,}000.00=\$212{,}000.00.

3. Apply the tax multiplier.

U=\$212{,}000.00(1.05)=\$222{,}600.00.

4. Apply the bounds. The unbounded premium is above the $200,000.00 minimum and below the $350,000.00 maximum. Neither bound changes it, so the final premium is $222,600.00.

Check. The corrected result is between $200,000.00 and $350,000.00. The worksheet’s $210,000.00 unbounded amount is inconsistent with its stated loss conversion factor; correcting the converted losses increases the premium by $12,600.00. The common mistake avoided is accepting a displayed component without verifying how it was calculated.

Worked Example: Applying the Maximum to the Premium, Not the Subtotal

A hypothetical worksheet lists a basic premium of $160,000.00, reported losses of $280,000.00, a loss conversion factor of 1.25, a tax multiplier of 1.04, a minimum premium of $320,000.00, and a maximum premium of $500,000.00. An analyst caps the pre-tax subtotal at $500,000.00 and then applies the multiplier, reporting $520,000.00. Audit the calculation.

Method and assumptions. The contractual maximum applies to the final premium after the tax multiplier. The data are deterministic worksheet inputs; interest, mortality, and distribution assumptions are not applicable.

1. Convert the losses.

cL=1.25(\$280{,}000.00)=\$350{,}000.00.

2. Add the basic premium.

B+cL=\$160{,}000.00+\$350{,}000.00=\$510{,}000.00.

3. Apply the multiplier before considering the bounds.

U=\$510{,}000.00(1.04)=\$530{,}400.00.

4. Apply the contractual limits. Since $530,400.00 exceeds the $500,000.00 maximum, the final premium is $500,000.00. It is also above the $320,000.00 minimum.

Why the reported result is wrong. The analyst applies the maximum to the $510,000.00 subtotal, then multiplies that capped amount:

\$500{,}000.00(1.04)=\$520{,}000.00.

That amount exceeds the contractual maximum, which is a direct check that the calculation is inconsistent with the stated formula. The correct calculation applies the tax multiplier first and caps the resulting $530,400.00 at $500,000.00.

Check. The corrected premium satisfies $320,000.00 $\leq$ $500,000.00 $\leq$ $500,000.00, where the middle amount is the final premium and the outside amounts are the minimum and maximum. The common mistake avoided is applying a premium bound to an intermediate subtotal rather than to the premium specified by the contract.

Worked Example: Verifying a Minimum-Premium Floor

A hypothetical worksheet shows a basic premium of $70,000.00, reported losses of $60,000.00, a loss conversion factor of 1.10, a tax multiplier of 1.05, a minimum premium of $180,000.00, and a maximum premium of $260,000.00. The worksheet’s final premium is $180,000.00. Verify the calculation and determine whether the floor is actually binding.

Method and assumptions. Recompute the unbounded premium independently, then apply the minimum and maximum. No interest rate, mortality assumption, or probability distribution is required for this hypothetical arithmetic.

1. Convert the reported losses.

cL=1.10(\$60{,}000.00)=\$66{,}000.00.

2. Add the basic premium.

B+cL=\$70{,}000.00+\$66{,}000.00=\$136{,}000.00.

3. Apply the tax multiplier.

U=\$136{,}000.00(1.05)=\$142{,}800.00.

4. Apply the floor and ceiling. Since $142,800.00 is below the $180,000.00 minimum, the minimum raises the premium to $180,000.00. The result is less than the $260,000.00 maximum, so the ceiling does not change it.

Check. The worksheet’s final amount is correct, and the minimum is binding because $U<P_{\min}$. The unbounded amount must still be shown in the audit: without it, there is no way to verify that the floor, rather than an arithmetic error, explains the final premium.

Reconciling the Result and Avoiding False Agreement

A useful audit conclusion distinguishes among three results: the worksheet’s displayed components, the independently calculated unbounded premium, and the contractually bounded final premium. A worksheet can show a correct final amount by coincidence while containing an incorrect intermediate entry; conversely, an unbounded amount can be correct while the final amount is wrong because a bound was applied incorrectly.

When the worksheet and independent calculation differ, locate the first line where they diverge. If converted losses are wrong, the subtotal and unbounded premium will also generally be wrong. If those components agree but the unbounded premium does not, check the multiplier arithmetic. If the unbounded premium agrees but the final premium does not, check the minimum, maximum, and contractual order.

A frequent audit trap is to treat the bounds as a general adjustment that can be applied at any convenient point. They are not. In the formula used here, the multiplier produces the unbounded premium, and the limits then act on that premium. Another trap is to report only the bounded result. Reporting the unbounded amount and showing whether either bound binds makes the reconciliation transparent.

Key takeaway: Trace each input to its formula role, independently calculate converted losses and the unbounded premium, and apply the minimum and maximum to the amount specified by the contract. Finish by checking that the final premium lies within the stated bounds.

Check Your Understanding

For each hypothetical worksheet, identify the correct final premium. Use the stated formula $U=(B+cL)t$, with bounds applied to $U$.

A worksheet has $B=\$90{,}000.00$, $L=\$100{,}000.00$, $c=1.15$, $t=1.04$, $P_{\min}=\$190{,}000.00$, and $P_{\max}=\$240{,}000.00$. What is the final premium? (Answer: $213,200.00.)
A worksheet has $B=\$120{,}000.00$, $L=\$300{,}000.00$, $c=1.20$, $t=1.05$, $P_{\min}=\$300{,}000.00$, and $P_{\max}=\$490{,}000.00$. What is the unbounded premium, which bound binds, and what is the final premium? (Answer: Unbounded premium $504,000.00; maximum binds; final premium $490,000.00.)
A worksheet has $B=\$80{,}000.00$, $L=\$140{,}000.00$, $c=1.10$, $t=1.03$, $P_{\min}=\$250{,}000.00$, and $P_{\max}=\$310{,}000.00$. What is the final premium, and does either bound bind? (Answer: $250,000.00; the minimum binds.)
Reported losses are $200,000.00 and the loss conversion factor is 1.15, but the worksheet lists converted losses of $210,000.00. If $B=\$100{,}000.00$, $t=1.04$, $P_{\min}=\$250{,}000.00$, and $P_{\max}=\$400{,}000.00$, what are the corrected converted losses and final premium? (Answer: Corrected converted losses $230,000.00; final premium $343,200.00.)
A worksheet has $B=\$200{,}000.00$, $L=\$200{,}000.00$, $c=1.10$, $t=1.05$, $P_{\min}=\$300{,}000.00$, and $P_{\max}=\$430{,}000.00$. An analyst caps the subtotal before tax. What is the correct final premium, and why is multiplying the capped subtotal incorrect? (Answer: $430,000.00; the maximum applies after the multiplier, so the correct unbounded premium is $441,000.00 and is then capped.)

What You'll Learn