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
Renewal & Quote Comparison Tracker
$9.99Your renewal increase measured against your state's published change, then four quotes on identical rows — because carriers quote different limits and deductibles, so the cheapest premium is routinely the least coverage. Converts each percentage wind deductible into real dollars, adds the extra deductible exposure a cheaper premium bought you, and says outright when the lowest premium is not the lowest cost. Closes with a decision log and a lapse check on the two policy dates.
Format: Excel (.xlsx)
Look inside
Preview only — scroll to read it. The file you download is fully editable.
| Renewal & Quote Comparison Tracker | |||||
| Your renewal went up and you are about to shop. The trap is that quotes are not comparable as they arrive - carriers quote different limits, different deductibles, and different endorsements, so the cheapest premium is very often the least coverage. This puts every quote on the same rows, then adds… | |||||
| Part 1 - The policy you have now | |||||
| Annual premium, expiring policy | 2400 | ||||
| Annual premium, renewal offer | 3100 | ||||
| Increase in dollars | ƒx | ||||
| Increase as a percentage | ƒx | ||||
| Your state's published year-over-year change (%) | 11.4 | From the Renewal Increase Check on calculatorbystate.com. Arkansas has none; leave it at 0 and skip row 11. | |||
| What the renewal would be at the state's change | ƒx | ||||
| You are being asked for this much more than the state's move | ƒx | Not proof of anything by itself - a single policy can move further than the state average for real reasons. It tells you there is a specific reason to ask about. | |||
| Reason the carrier gave for the increase | Ask, in writing. A rate filing, a reinspection, a claim, a roof-age threshold, a change to your territory's rating. 'Rates went up' is not an answer. | ||||
| Part 2 - Quotes side by side | |||||
| Carrier | Renewal (current carrier) | Quote 2 | Quote 3 | Quote 4 | Why this line matters |
| Annual premium | 3100 | 2870 | 2650 | 3010 | The whole reason you are shopping - and on its own, not enough to decide. |
| Coverage A - Dwelling | 400000 | 400000 | 400000 | 400000 | If this differs between quotes, the premiums are not comparable. Make them match before you look at price. |
| Coverage C - Personal property | 200000 | 200000 | 140000 | 200000 | |
| Coverage D - Loss of use | 80000 | 80000 | 60000 | 80000 | |
| Coverage E - Personal liability | 300000 | 300000 | 100000 | 500000 | Cheap to raise and the one most worth raising. A quote that saves $80 by cutting this in half is not a saving. |
| All-perils deductible | 1000 | 1000 | 2500 | 1000 | The commonest way a quote gets cheap. Row 27 prices the difference. |
| Wind / hail / hurricane deductible (%) | 2 | 2 | 5 | 2 | A percentage of Coverage A, not a dollar figure. In a catastrophe state this is the deductible you would actually meet. |
| Replacement cost on contents? (Y/N) | Yes | Yes | No | Yes | Without it, contents settle at depreciated value. This single endorsement can matter more than the premium difference. |
| Extended / guaranteed replacement cost? (Y/N) | No | Yes | No | Yes | |
| Ordinance or law - % of Coverage A | 10 | 25 | 10 | 25 | The base policy gives 10%. On an older house that is often not enough to rebuild to current code. |
| Water backup limit | 5000 | 10000 | 0 | 10000 | |
| Part 3 - What each one actually costs | |||||
| Wind/hail deductible in dollars | ƒx | ƒx | ƒx | ƒx | Your percentage deductible, converted. A 2% deductible on $400,000 is $8,000, not the figure printed next to 'deductible'. |
| Extra deductible exposure vs. the cheapest quote here | ƒx | ƒx | ƒx | ƒx | What a higher deductible costs you the first time you claim - money the lower premium quietly traded away. |
| Premium + that extra exposure, first claim | ƒx | ƒx | ƒx | ƒx | The honest comparison. A quote $200 cheaper with a $2,500 higher deductible is $2,300 worse the first time you use it. |
| Coverage E per premium dollar | ƒx | ƒx | ƒx | ƒx | Dollars of liability cover per dollar of premium. A rough but revealing way to see which carrier is selling protection and which is selling a price. |
| Cheapest premium | ƒx | ||||
| Cheapest on premium plus first-claim exposure | ƒx | ||||
| Do those two point at the same quote? | ƒx | ||||
| Part 4 - Decision log | |||||
| Date you asked the current carrier for the reason | |||||
| Date you asked about raising the deductible | |||||
| Date you re-priced at matched coverage | |||||
| Quotes received (count) | |||||
| Decision | |||||
| Date the new policy starts | |||||
| Date the old policy ends | |||||
| Gap between the two dates | ƒx | This must be zero or negative - the new policy has to start on or before the old one ends. A one-day lapse is the most expensive mistake available in this whole process. | |||
| Shop BEFORE you cancel, never after. A lapse in coverage is far more expensive than any increase this sheet will show you, and a gap on your record makes the next carrier harder to get. Use one independent agent rather than eight direct applications. Every declination builds a paper trail that the… | |||||
| Notes | |||||
This template is general information, not financial, legal, or tax advice.