Rental Property Insurance Claim vs Deductible Decision in Excel: Price the Claim Before You Call

The water heater in Unit B of your duplex splits at 2 a.m. By noon you have a contractor's estimate for $4,800 and a $2,500 deductible on the policy, and the arithmetic looks finished: file, collect $2,300, accept whatever the premium does. A rental property insurance claim vs deductible decision in Excel exists because that subtraction is wrong twice. The check is smaller than $2,300, and the cost of the claim is written in your carrier's rating manual and your state's insurance code, not in a rumor about rates going up. On the example below, the corrected numbers turn "file" into "absorb" with one carrier and keep it "file" with another, for the same leak.

The duplex, the estimate, the rent and the premium are example figures. The policy wording, the claim history rules and the state statutes are real and cited where they are used.

The $2,300 check that does not exist

A landlord policy on a one-to-four unit building is usually a dwelling policy, and its special form, DP 00 03, carries a sentence that removes the most expensive line from most water heater estimates. After it grants coverage for water that escapes from a plumbing system or household appliance, the form says: "We do not cover loss to the system or appliance from which this water or steam escaped." The tank that split is yours to replace. The drying, the drywall and the floor are covered.

The same policy usually adds something the estimate leaves out. On a tenant-occupied DP-3, Coverage D pays fair rental value while the unit cannot be rented. Sutton National's California dwelling manual, for example, includes Coverage D at 10 percent of the dwelling limit on tenant-occupied DP-3 policies. Twelve days without rent is part of the loss.

The model applies one deductible to the whole covered loss, including rent. Read the deductible clause and the Coverage D section of your own form before you rely on that, because endorsements change both. If the tenant caused the damage, the deductible can be larger too. Sutton's manual makes an endorsement titled Increased Deductible for Loss or Damage Caused by Tenants mandatory on every DP-1 and DP-3, and its notes set that deductible at the greater of $2,500 or the policy deductible on tenant-occupied risks. Price that case with the move-out damage chargeback calculator before you call the carrier.

The cost of a claim is written in the carrier's manual

A claim costs money in three places: a surcharge or a lost discount at renewal, a record that follows you and the property, and a lower tolerance for the next claim. All three are written down somewhere you can read.

The record lasts seven years

Carriers that subscribe to C.L.U.E., the Comprehensive Loss Underwriting Exchange run by LexisNexis, report their property claims to it. The Wisconsin and Tennessee insurance regulators both describe it as holding up to seven years of personal property claims history. Tennessee lists what gets reported: claims the carrier paid, claims for which it set up a file for a possible claim, and claims it formally denied. Wisconsin puts it more bluntly: consumer claims information includes any loss you asked the company to cover, "whether or not the insurance company paid for it." Wisconsin also notes that insurers use C.L.U.E. mostly when writing new policies, because your current carrier already has your loss history in its own files. The record matters most the day you shop for a new policy or the day your carrier decides it no longer wants the building.

The surcharge is a published number

Rating rules are filed with state regulators, and some carriers publish their manuals. Three examples show how different they are:

• Sutton National, California DP-1 and DP-3 manual (02/2021): one or more qualified losses in the past 36 months adds a 15 percent surcharge to the basic premium. Catastrophe claims with an ISO catastrophe number do not count. The same manual will not accept an applicant or dwelling with two or more chargeable losses of at least $500 each in the past 36 months.
• Citizens Property Insurance, Florida: its underwriting review template treats two or more non-weather water losses within 36 months, or three within 60 months, as ineligible on the policy form.
• Texas: the Insurance Code limits what a carrier may do at all, covered in the next section.

Ask your agent for the loss surcharge and eligibility rules that apply to your policy form, in writing. The answer goes into cells B11 to B13 of the sheet below, and it decides more than the size of the loss does.

Texas rewrites the decision by cause of loss

Texas is worth reading even if you own nothing there, because it shows how much the cause of the water changes the cost of a claim.

Section 544.353 of the Texas Insurance Code bars an insurer from using a prior appliance-related claim to set the rate or to decide whether to issue, renew or cancel a policy, if the damage was properly remediated and the remediation was inspected and certified by someone experienced in water damage remediation. Section 544.352 defines an appliance as a household device operated by gas or electric current, including hoses attached to it, and names water heaters, clothes washers, dishwashers, icemakers and refrigerators. The protection stops at three or more appliance-related claims within three years, and it applies to residential fire and allied lines policies, which is where a landlord's dwelling policy sits.

Section 551.107 adds two limits for standard fire, homeowners and farm and ranch policies. A carrier may add a renewal surcharge only if you filed two or more claims in the preceding three policy years, and it may refuse to renew only after three claims in a three-year period, and only if it warned you in writing after the second. Claims from natural causes, claims filed but not paid, and protected appliance claims do not count. Wellington's Texas dwelling fire underwriting guide, which accepts rentals of up to four families, repeats these limits in its renewal claims rules. The same section narrows the word "surcharge": losing a discount, moving to another rating tier and re-rating are not surcharges. A first claim in Texas can still cost you a claim-free credit.

The water heater claim, with a remediation certificate in the file, costs the price of the certificate. The same damage from a cracked supply line under a sink is a plumbing claim under the statute, and it counts toward the two-claim and three-claim lines.

The phone call is the decision

A call to the claims line "just to ask" can make the decision for you. Tennessee's regulator says LexisNexis advises insurers not to report a call that only asks about coverage or the deductible, and Tennessee law bars raising a premium or canceling a homeowner's policy solely because of such inquiries. Texas defines a customer inquiry in Section 551.113 as a communication that does not result in an investigation or claim, and it includes asking whether a policy will cover a loss, "unless the question concerns specific damage that has occurred and that results in an investigation or claim."

If you describe the split tank, the date and the address, you have reported a loss, and Tennessee's list of what carriers report includes claims for which they set up a file. Ask the general questions first, about the surcharge rule and how the deductible applies to fair rental value, and give no address or date of loss. Run the sheet. Then call with a decision.

Do not let the sheet slow down the drying. DP 00 03 lists your duties after a loss: give prompt notice, protect the property from further damage, make reasonable and necessary repairs, and keep an accurate record of repair expenses. It also excludes "constant or repeated seepage or leakage of water or steam over a period of weeks, months or years." The $950 for drying is spent whichever way you decide, so book the drying crew the same morning, photograph everything before tear-out, keep every invoice, and make the filing decision within days.

Build the claim decision sheet in Excel

The sheet has two tabs. The Loss tab lists the estimate: item in column A, amount in column B, and Y or N in column C for covered or not. Rows 4 to 7 hold the four estimate lines from the table above.

• B8, estimate total: =SUM(B4:B7) returns $4,800.
• B9, covered repair: =SUMIFS(B4:B7,C4:C7,"Y") returns $3,150. The water heater row carries N.

The Claim tab does the decision:

Where B17 comes from: ISO data published by the Insurance Information Institute put homeowners property damage claims at 5.53 per 100 house-years on average over 2019 to 2023, of which 2.80 were wind and hail. Sutton's rule leaves out catastrophe-coded claims and Texas leaves out natural causes, so the sheet drops wind and hail and uses the other 2.73: water damage and freezing 1.50, fire 0.23, theft 0.12, all other 0.88. Those figures cover homeowners policies (HO-2, HO-3 and HO-5), not dwelling policies on rentals, and exclude Texas. If you own enough buildings to have ten years of your own claim history, use that instead.

B20 is the cost of being the landlord with two losses in the window: with Sutton's rule, that applicant is unacceptable as new business, so if the carrier walks away you are shopping at carriers that take two losses. The example prices that at $1,200 a year more for three years. Replace it with a real quote if your agent can get one.

B24 is the line to watch. Under this rulebook, the claim pays for itself only when the covered loss passes $3,866.86, about 1.5 times the deductible. This loss is $125.08 short. Had the unit been down 15 days instead of 12, the lost rent alone would have crossed it.

One leak, four rulebooks

Change B11 to B14, B17 and B20 and the same $1,241.78 check produces four answers.

Notes on the rows. In the Texas supply line row, the second-claim cost is the surcharge a second claim would permit under Section 551.107, priced at the same 15 percent as the first row, so B20 is $1,080 and B19 stays at 7.97 percent. In the Citizens-type row, only another non-weather water loss triggers the rule, so B17 is the water and freezing frequency alone, 1.50 per 100, and B19 falls to 4.43 percent. The $240 credit and the $350 certificate are example figures; ask for the real ones.

Put the quick math back into the first row and the error shows. With a $2,300 check, filing under the Sutton rule nets $933.14 and looks obvious. With the real $1,241.78 check, it loses $125.08. A wrong estimate of the payout leads straight to the wrong decision.

When to file without running the sheet

The model is for the losses that sit between one and two deductibles. Outside that band the answer is fast.

• Any liability claim. A tenant or guest injured on the property goes to the carrier the day you hear of it. ISO puts the average homeowners bodily injury and property damage liability claim at $37,174 over 2019 to 2023. Late notice on a liability loss is a risk no surcharge justifies.
• Large property losses. Under the Sutton rule, a $12,000 covered loss nets $8,133.14 after every cost in the sheet. ISO's average water damage and freezing claim was $15,400, and fire and lightning $88,170. The policy is there for those.
• Catastrophe losses. Wind, hail and wildfire claims with an ISO catastrophe number are outside Sutton's surcharge, and Texas excludes losses from natural causes from both its surcharge and its nonrenewal counts.
• Texas appliance losses. Get the remediation certificate, then file, unless you already have three appliance claims in three years.

When the answer is "absorb," book it as a cost. The $3,741.78 of covered loss stays with you: $3,150 of repairs paid from the operating reserve and $591.78 of rent you do not collect. The $1,650 water heater is yours either way, and it belongs in your capital reserve schedule with a fresh install date. If the flooring has to come out anyway, the interior upgrade rent premium calculator tells you whether to put back the same plank or something that earns more rent.

Get three numbers before the next leak

Before the next leak, get three numbers from your agent in writing: the claim surcharge rate and how many renewals carry it, the claim-free credit you would lose, and the loss count that makes the building ineligible. Put them in B11 to B13 and B18. Your break-even covered loss in B24 then exists before anything breaks, and the 2 a.m. decision becomes a lookup: dry the unit the same day, price the covered loss without the failed appliance and with the lost rent, compare it to B24, and only then call the claims line. Review the inputs at each renewal alongside the premium in your insurance cost tracker, because a carrier change rewrites every one of them.

The SheetCraft Rental Property Analyzer is where that decision lands. Its operating expense analysis gives insurance, maintenance reserve and vacancy their own lines, its deal summary shows what a $1,080 surcharge or $3,150 of absorbed repairs does to monthly cash flow and cash-on-cash return, and its 10-year projection carries a higher premium forward with expense growth. It does not read your policy or price a claim: build the two-tab sheet above next to it, then enter the surcharged premium or the absorbed repair in the Analyzer to see what the building returns either way.