Calculation guide
Use a policy that bases its deductible on insured value. Apply the higher of the percentage amount and the contractual minimum, subtract it from eligible loss, then apply the payout limit.
Inputs
Insured value
Example entry 200000 (in the selected currency).
Deductible percentage
Example entry 2 %. Allowed range 0 to 100.
Minimum deductible
Example entry 1000 (in the selected currency).
Eligible flood loss
Example entry 15000 (in the selected currency).
Remaining payout limit
Example entry 200000 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Insured value | 200,000 |
| Deductible percentage | 2% |
| Minimum deductible | 1,000 |
| Eligible flood loss | 15,000 |
| Remaining payout limit | 200,000 |
| Result | Value |
|---|---|
| Estimated payout | 11,000 |
| Contractual deductible | 4,000 |
| Loss retained | 4,000 |
Calculation steps
Estimated payout = min(Remaining payout limit, max(0, (Eligible flood loss − max(Minimum deductible, ((Insured value × Deductible percentage) ÷ 100)))))
min(200,000, max(0, (15,000 − max(1,000, ((200,000 × 2) ÷ 100))))) = 11,000
Contractual deductible = max(Minimum deductible, ((Insured value × Deductible percentage) ÷ 100))
max(1,000, ((200,000 × 2) ÷ 100)) = 4,000
Loss retained = (Eligible flood loss − Estimated payout)
(15,000 − 11,000) = 4,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 |
|---|---|---|---|---|---|
| Insured value | 200,000 | 220,000 | Estimated payout | 11,000 | 10,600 |
| Deductible percentage | 2% | 3% | Estimated payout | 11,000 | 9,000 |
| Eligible flood loss | 15,000 | 16,500 | Estimated payout | 11,000 | 12,500 |
| Remaining payout limit | 200,000 | 0 | Estimated payout | 11,000 | 0 |
