Flood deductible percent of insured value · Calculation guide

Apply a percentage deductible to the insured value and calculate the residual claim.

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.

paid = min(limit,max(0,loss-max(minimum,value*rate/100))) · deductible = max(minimum,value*rate/100) · retained = loss-paid

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

InputValue
Insured value200,000
Deductible percentage2%
Minimum deductible1,000
Eligible flood loss15,000
Remaining payout limit200,000
ResultValue
Estimated payout11,000
Contractual deductible4,000
Loss retained4,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Insured value200,000220,000Estimated payout11,00010,600
Deductible percentage2%3%Estimated payout11,0009,000
Eligible flood loss15,00016,500Estimated payout11,00012,500
Remaining payout limit200,0000Estimated payout11,0000
Flood deductible percent of insured value →