Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinancePersonal FinanceInsurance Quote Comparison

SpreadsheetPersonal FinanceFree

Insurance Quote Comparison

Compare quotes on what you would really pay in a year: premium, deductible, coinsurance and out-of-pocket maximum.

Shown with sample data

Colour

Insurance Quote Comparison

Compare quotes on what you would really pay in a year: premium, deductible, coinsurance and out-of-pocket maximum.

Lowest expected cost
$6,176
Lowest annual premium
$4,776
Lowest worst-case year
$11,276
Spread between quotes
$5,251
Expected cost, best vs worst
Cheapest with no claims
Bronze HDHP (HSA-eligible)
Cheapest at $10,000 of costs
Silver HMO
Cheapest at $60,000 of costs
Bronze HDHP (HSA-eligible)
Expected annual cost by quote
  • Platinum HMO$11,427
  • Gold PPO$10,115
  • Silver PPO$8,464
  • Silver HMO$7,556
  • Bronze EPO$6,452
  • Bronze HDHP (HSA-eligible)$6,176
Worst-case year by quote
  • Silver PPO$14,844
  • Gold PPO$14,660
  • Silver HMO$14,576
  • Bronze EPO$14,252
  • Platinum HMO$14,208
  • Bronze HDHP (HSA-eligible)$11,276

How to use it

  1. 1On Settings, type the size of a typical claim for you and your chance of needing one this year.
  2. 2Add each quote with its monthly premium, deductible, coinsurance and out-of-pocket maximum.
  3. 3For auto, home or renters quotes, set coinsurance to 0% and the out-of-pocket maximum equal to the deductible.
  4. 4Compare Expected cost first, then check the Worst-case year is affordable from savings.
  5. 5Use the Scenarios sheet to see which quote is cheapest at each level of yearly costs.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

The cheapest premium is often the most expensive plan once you need it. Enter each quote’s premium, deductible, coinsurance and out-of-pocket maximum; the sheet works out your annual cost in a quiet year, with one typical claim and in a worst case, gives an expected cost based on your chance of a claim, and charts total cost across a range of medical bills.

Who it’s for

  • Open enrollment and marketplace health plans
  • Auto and home quotes with different deductibles
  • Deciding whether a high-deductible plan with an HSA is worth it

What’s included

  • Quotes sheet: One row per quote with the yearly cost in each scenario.
  • Scenarios sheet: Total yearly cost of each quote at different levels of covered costs.
  • Settings sheet: The claim size and likelihood used for one-claim and expected costs.

How to use it

  1. 1On Settings, type the size of a typical claim for you and your chance of needing one this year.
  2. 2Add each quote with its monthly premium, deductible, coinsurance and out-of-pocket maximum.
  3. 3For auto, home or renters quotes, set coinsurance to 0% and the out-of-pocket maximum equal to the deductible.
  4. 4Compare Expected cost first, then check the Worst-case year is affordable from savings.
  5. 5Use the Scenarios sheet to see which quote is cheapest at each level of yearly costs.

Tips

  • Check the network and drug formulary before price. A cheap plan your doctors are not in is not cheap.
  • Employer HSA contributions effectively reduce a high-deductible plan’s cost: note them and subtract them mentally from that plan’s figures.
  • Pick a deductible you could pay tomorrow from your emergency fund.

Questions

Is a higher deductible better?

A higher deductible lowers your premium but raises what you pay before cover starts. It usually wins if you are healthy, rarely claim and have savings to cover the deductible. The Scenarios sheet shows the break-even point.

What is the difference between a deductible and an out-of-pocket maximum?

The deductible is what you pay before the insurer starts sharing costs. The out-of-pocket maximum caps your total spending on covered care for the year, including the deductible and coinsurance. Premiums do not count toward it.

How is the one-claim cost calculated?

You pay the claim up to the deductible, then your coinsurance share of the rest, capped at the out-of-pocket maximum. The premium for the year is added on top.

Does this work for car insurance?

Yes. Enter coinsurance as 0% and the out-of-pocket maximum equal to the deductible, and use a typical repair cost as the claim size.

Related searchesinsurance quote comparisoncompare health insurance plansdeductible vs premium calculatorinsurance comparison spreadsheetout of pocket maximumcompare insurance quotes

Details

Format
Spreadsheet
Category
Personal Finance
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetPersonal FinanceFree

Insurance Quote Comparison

Compare quotes on what you would really pay in a year: premium, deductible, coinsurance and out-of-pocket maximum.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Personal Finance
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More personal finance templates

View all
Savings Goals Tracker2 sheets

Total saved

$29,175

Overall progress

40%

Needed each month

$2,342

Progress by goal
88%
67%
67%
35%
33%
Christmas giftsEmergency fundNew laptopSummer holidayHouse deposit
SpreadsheetPersonal Finance

Savings Goals Tracker

Track several goals with a deposit log, monthly amount needed, projected finish date and on-track status.

10 min setupPreview
Bill Payment Tracker2 sheets

Bills per month

$2,510

Bills per year

$30,117

Due in the next 7 days

$216

ABCD
1BillCategoryFrequencyDue day
2RentHousingMonthly1
3ElectricityUtilitiesMonthly12
4WaterUtilitiesQuarterly18
5Home insuranceInsuranceYearly20
Bills
SpreadsheetPersonal Finance

Bill Payment Tracker

Every recurring bill with its next due date, days left, autopay and what bills really cost you each month.

10 min setupPreview
Emergency Fund Planner2 sheets

Essential costs per month

$2,970

Fund target

$11,880

Months covered today

1.1

ABC
1Essential costCategoryMonthly amount
2Rent or mortgageHousing$1,350
3Energy, water, internetUtilities$230.00
4GroceriesFood$480.00
5Fuel and transportTransport$190.00
Essentials
SpreadsheetSavings Goals

Emergency Fund Planner

Work out your essential monthly costs, the fund you need for three to six months and how long it will take to build.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ