Commercial Property Insurance, Risk Management, Underinsurance Audits & CPCU Claims
Commercial Property Coinsurance Penalty ("Did/Should") Formula
Calculate Required Coinsurance Limit ("Should Have"), Coinsurance Compliance Ratio MIN(1, Did/Should), Net Insurer Claim Recovery After Deductible, and Uninsured Coinsurance Penalty Haircut.
Underinsuring a $2M warehouse with a $1.2M limit doesn’t cover a $400k partial fire in full—coinsurance slashes recovery by $100,000!
Most commercial property losses are partial rather than total, tempting building owners to buy a policy limit far below full Replacement Cost Value (`RCV`) while still expecting 100% reimbursement on partial fires! To enforce actuarial rate equity, ISO CP 00 10 commercial property policies include an `80%`, `90%`, or `100%` Coinsurance Clause (`C_pct`): at the date of loss, Required Insurance ("Should Have") equals `L_should = RCV * (C_pct / 100)`. If Policy Limit Carried ("Did Have", `L_did`) falls short of `L_should`, the insurer prorates EVERY partial loss by the Coinsurance Factor `f_coins = MIN(1, L_did / L_should)` BEFORE subtracting the policy deductible `D` (and capping at `L_did`): `Payout = MIN(L_did, MAX(0, Loss * MIN(1, L_did / L_should) - D))`!
Test a Warehouse Post-Inflation Underinsurance Claim—Replacement_Cost_At_Loss `RCV` = $2,000,000 (B2), Coinsurance_Clause = 80.0% (B3 -> "Should Carry" = `$1,600,000` in E2), Policy_Limit_Carried `L_did` = $1,200,000 (B4 -> `Did / Should = 0.7500` in E3), Partial_Roof_Fire_Loss = $400,000 (B5), and Policy_Deductible `D` = $10,000 (B6): instead of `$390,000` (`$400k - $10k`), the insurer pays `$400,000 * 0.75 - $10,000 = $290,000.00` (E4)—imposing a `$100,000.00` Coinsurance Penalty self-insured out of the owner’s pocket (E5)!
| ISO CP 00 10 Coinsurance KPI ($2.0M RCV, 80% Clause, $1.2M Limit, $400k Loss, $10k Ded.) | Formula | Verified Output |
|---|---|---|
| Required "Should Have" Limit ($) | Replacement_Value * (Coins_Pct / 100) | $1,600,000.00 |
| "Did / Should" Compliance Factor | MIN(1, Limit_Carried / Should_Carry) | 0.7500 (1.0000 @ $1.6M limit) |
| Net Insurer Claim Payout ($) | MIN(Did, MAX(0, Loss * Factor - Ded)) | $290,000.00 ($390,000 @ $1.6M limit) |
| Uninsured Coinsurance Penalty ($) | Full_Unpenalized_Payout - Insurer_Pay | $100,000.00 ($0.00 @ $1.6M limit!) |
ISO CP 00 10 "Did Over Should" Coinsurance Recovery & Penalty Formula
Validate `Replacement_Value > 0`, `Coinsurance_Pct` in `[50%, 100%]`, `Limit_Carried > 0`, `Covered_Loss >= 0`, and `Deductible >= 0`. Notice ISO CP 00 10 applies the coinsurance ratio to `Loss` FIRST and subtracts `Deductible` SECOND (`Loss * Ratio - Ded`), rather than `(Loss - Ded) * Ratio`!
=LET(rc_v, B2, cp_c, B3, ld_d, B4, ls_a, B5, dd_a, B6, IF(OR(rc_v <= 0, cp_c < 50, cp_c > 100, ld_d <= 0, ls_a < 0, dd_a < 0), "Invalid Policy Input", LET(ls_h, rc_v * (cp_c / 100), fc_r, MIN(1, ld_d / ls_h), py_i, MIN(ld_d, MAX(0, ls_a * fc_r - dd_a)), py_f, MIN(ld_d, MAX(0, ls_a - dd_a)), ROUND(MAX(0, py_f - py_i), 2))))Inflation-Adjusted $1,600,000 Limit Full-Compliance Check (Set Limit Carried B4 = $1,600,000)
Update annual building schedules to carry the full `80%` threshold (`B4 = 1,600,000`): Compliance Ratio E3 reaches `1.0000`, Net Insurer Payout E4 rises `$100,000` to the full `$390,000.00` (`$400,000 - $10,000`), and Coinsurance Penalty E5 drops to `$0.00`!
=IF(ISTEXT(E5), E5, LET(ls_h, B2 * (B3 / 100), fc_r, MIN(1, B4 / ls_h), ROUND(MIN(B4, MAX(0, B5 * fc_r - B6)), 2)))Try the example
Use the original values or change them to test your understanding.