Calculation guide
The unpaid portion of the a priori expected ultimate loss supplements claims already paid.
Estimated unpaid claims = (((Earned premium × Expected loss ratio (%)) ÷ 100) × (1 − (Expected percentage paid to date (%) ÷ 100))). Projected ultimate claims = (Claims paid to date + Estimated unpaid claims)
Inputs
Earned premium
Example entry 1000 (in the selected currency).
Expected loss ratio (%)
Example entry 70 %. Allowed range 0.0 to 1000.0.
Expected percentage paid to date (%)
Example entry 40 %. Allowed range 0 to 100.
Claims paid to date
Example entry 250 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Earned premium | 1,000 |
| Expected loss ratio (%) | 70% |
| Expected percentage paid to date (%) | 40% |
| Claims paid to date | 250 |
| Result | Value |
|---|---|
| Estimated unpaid claims | 420 |
| Projected ultimate claims | 670 |
Calculation steps
Estimated unpaid claims = (((Earned premium × Expected loss ratio (%)) ÷ 100) × (1 − (Expected percentage paid to date (%) ÷ 100)))
(((1,000 × 70) ÷ 100) × (1 − (40 ÷ 100))) = 420
Projected ultimate claims = (Claims paid to date + Estimated unpaid claims)
(250 + 420) = 670
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Earned premium | 1,000 | 1,100 | Estimated unpaid claims | 420 | 462 |
| Expected loss ratio (%) | 70% | 77% | Estimated unpaid claims | 420 | 462 |
| Expected percentage paid to date (%) | 40% | 44% | Estimated unpaid claims | 420 | 392 |
| Claims paid to date | 250 | 275 | Projected ultimate claims | 670 | 695 |
