Calculation guide
Use a policy requiring full value insurance. Multiply loss by the insured-to-required value ratio, capped at 100%. Deduct the excess after proportional adjustment and cap the payout at the sum insured. Other policy wordings can differ.
Inputs
Sum insured
Example entry 80000 (in the selected currency).
Required insured value
Example entry 100000 (in the selected currency). Minimum 0.01.
Eligible property loss
Example entry 20000 (in the selected currency).
Policy excess
Example entry 1000 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Sum insured | 80,000 |
| Required insured value | 100,000 |
| Eligible property loss | 20,000 |
| Policy excess | 1,000 |
| Result | Value |
|---|---|
| Estimated claim payout | 15,000 |
| Coverage ratio applied | 80% |
| Unrecovered loss | 5,000 |
Calculation steps
Estimated claim payout = min(Sum insured, max(0, ((Eligible property loss × min(1, (Sum insured ÷ Required insured value))) − Policy excess)))
min(80,000, max(0, ((20,000 × min(1, (80,000 ÷ 100,000))) − 1,000))) = 15,000
Coverage ratio applied = (100 × min(1, (Sum insured ÷ Required insured value)))
(100 × min(1, (80,000 ÷ 100,000))) = 80%
Unrecovered loss = (Eligible property loss − Estimated claim payout)
(20,000 − 15,000) = 5,000
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 |
|---|---|---|---|---|---|
| Sum insured | 80,000 | 88,000 | Estimated claim payout | 15,000 | 16,600 |
| Required insured value | 100,000 | 110,000 | Estimated claim payout | 15,000 | 13,545.454545 |
| Eligible property loss | 20,000 | 22,000 | Estimated claim payout | 15,000 | 16,600 |
| Policy excess | 1,000 | 1,100 | Estimated claim payout | 15,000 | 14,900 |
