Membership
One membership: every in-depth guide, plus the Deal Workspace. Templates are sold separately and bought once — see below.
All-Access$9.99/mo
Every in-depth guide across Mortgage, Insurance, Investment, Salary, Rent and Budget, plus the Deal Workspace — our per-property case file for tracking a purchase from pre-approval to closing.
- Every in-depth guide, across every category
- Deal Workspace — per-property case file, multi-deal comparison, and buying-journey checklist
- Unlimited saved calculations
- The full article library, always free
Home Insurance Coverage Audit
$9.99Walk your declarations page line by line, then check Coverage A against a real rebuild estimate — square footage, local cost per square foot, and the extras that estimate misses. Works the 80% coinsurance rule live, so you can see the exact percentage a partial loss would be paid at, converts your percentage catastrophe deductible into the dollars you'd actually have to produce, and closes with a Yes/No gaps checklist for the eight endorsements most often missing from a policy someone believes is full coverage.
Format: Excel (.xlsx)
Look inside
Preview only — scroll to read it. The file you download is fully editable.
| Home Insurance Coverage Audit | |||
| Open your declarations page — the one- or two-page summary at the front of your policy — and copy the numbers into the blue cells. Everything else calculates. The point of this worksheet is the two things a declarations page does not tell you: whether Coverage A would actually rebuild your house, an… | |||
| Part 1 — Your declarations page, line by line | |||
| Coverage A — Dwelling | 320000 | The limit for the house itself. Every other limit below is usually set as a percentage of this one, which is why an inadequate Coverage A quietly shrinks the whole policy. | |
| Coverage B — Other structures | 32000 | Detached garage, shed, fence, driveway gate. Commonly 10% of Coverage A — fine for a fence, not for a detached garage with a workshop in it. | |
| Coverage C — Personal property | 176000 | Your belongings. Commonly 50-70% of Coverage A, with much lower sublimits inside it for jewelry, cash, firearms, and collectibles. | |
| Coverage D — Loss of use / additional living expenses | 64000 | What the policy pays toward living somewhere else while the house is unlivable. Commonly 20-30% of Coverage A, sometimes capped by months as well as dollars. | |
| Coverage E — Personal liability | 300000 | Per occurrence. $100,000 is a common default and is low; $300,000-$500,000 is typical, and an umbrella policy sits above it. | |
| Coverage F — Medical payments to others | 5000 | Small no-fault limit for someone injured on your property. Usually $1,000-$5,000. | |
| Standard (all-perils) deductible | 1000 | The flat dollar deductible printed on the declarations page. Part 5 checks whether it is the one that would actually apply to your most likely claim. | |
| Annual premium | 2450 | ||
| Carrier | Midwest Mutual | ||
| Policy number | HO-4471902 | ||
| Policy period ends | 2027-03-01 | Renewal is the moment you have leverage — audit before it, not after. | |
| Part 2 — Do the secondary limits track Coverage A? | |||
| Coverage B as a % of Coverage A | ƒx | Commonly 10%. If you have a detached garage, barn, or a long run of fence, price the replacement rather than trusting the default. | |
| Coverage C as a % of Coverage A | ƒx | Commonly 50-70%. The inventory in Part 3 of the Claim Log is the honest way to find out whether that is enough. | |
| Coverage D as a % of Coverage A | ƒx | Commonly 20-30%. A full rebuild routinely takes 9-18 months; check for a month cap as well as a dollar one. | |
| Part 3 — What would it actually cost to rebuild? | |||
| Living area (square feet) | 2200 | Finished, above-grade living area — the same figure your county appraiser or your listing uses. Not lot size. | |
| Local rebuild cost per square foot | 185 | Local construction cost, not price per square foot on the market — land value and market premium are not being rebuilt. calculatorbystate.com publishes a sourced figure per state where one exists. | |
| Extra features not captured by square footage | 25000 | Finished basement, custom stonework, a detached garage, difficult site access, debris removal. Add them here rather than inflating the per-square-foot figure. | |
| Estimated cost to rebuild | ƒx | Square feet × cost per square foot, plus extras. A planning figure, not an appraisal — a replacement-cost estimator run by your agent is the next step up in precision. | |
| Coverage A as a % of that estimate | ƒx | ||
| Shortfall to full replacement cost | ƒx | What you would be short if the house were a total loss. Zero is the goal here; Part 4's threshold is the weaker of the two targets. | |
| Part 4 — The 80% coinsurance rule, worked live | |||
| Almost every US homeowners form contains a coinsurance clause: insure the dwelling to at least 80% of its full replacement cost and a PARTIAL loss is paid in full, up to the limit. Fall below 80% and the insurer pays only the proportion you carried — loss × (coverage carried ÷ coverage required). Th… | |||
| Coinsurance threshold your policy specifies (%) | 80 | Yellow because 80 is the near-universal standard, not a fact about YOUR policy. Search your policy form for "coinsurance" and change it if it says otherwise. | |
| Coverage required to meet that threshold | ƒx | The rebuild estimate above × the threshold. This is the number your Coverage A is measured against, not the full rebuild cost. | |
| Shortfall to the coinsurance threshold | ƒx | Dollars of Coverage A you would have to add to stop the penalty applying at all. | |
| Does the coinsurance penalty apply? | ƒx | ||
| Share of a partial loss the insurer would pay (%) | ƒx | This is the number that surprises people. It is not capped by how reasonable your coverage felt when you bought it. | |
| Verdict | ƒx | ||
| A partial loss to illustrate with | 60000 | Pick a realistic partial loss — a kitchen fire, a hail-damaged roof, a burst supply line. Leave at 0 for no illustration. | |
| What the insurer would pay | ƒx | The coinsurance-adjusted amount, capped at your Coverage A limit. Your deductible then comes off this figure separately. | |
| What you would absorb | ƒx | On top of your deductible, purely because of the coverage shortfall. This is the cost of the gap, in one number. | |
| Part 5 — The catastrophe deductible, in dollars | |||
| In wind, hail, hurricane, and named-storm states the policy commonly carries a SEPARATE percentage deductible for the peril you are most likely to claim on — and it is a percentage of Coverage A, not of the loss. A 2% hurricane deductible on a $400,000 dwelling limit is $8,000, not the $1,000 printe… | |||
| Catastrophe deductible (% of Coverage A) | 2 | Enter as a number, e.g. 2 — not 0.02. Enter 0 if your policy has no separate percentage deductible. | |
| Catastrophe deductible in dollars | ƒx | ||
| Your standard deductible, for comparison | ƒx | ||
| How many times larger it is | ƒx | ||
| Extra cash you would need vs. the standard deductible | ƒx | The gap between the deductible you think you have and the one that applies to the claim you are most likely to file. This is the number to hold in savings. | |
| Part 6 — Gaps checklist | |||
| Coverage or endorsement | On your policy today? (Yes/No) | What it is, and who needs it | Worth adding? (Yes/No) |
| Flood | No | Never covered by a homeowners policy — flood is always a separate NFIP or private policy. Roughly a quarter of flood claims come from outside a mapped high-risk zone. | Yes |
Preview shows the first 60 rows. The full worksheet continues for 19 more — the complete worksheet is in the download.
This template is general information, not financial, legal, or tax advice.