Blog
How to add up the real yearly cost of two employer plans side by side
A fill-in worksheet turns two benefit summaries and a payroll quote into one yearly number per plan, with a worked example for a household of three.
Two plan summaries and a payroll rate sheet give you at least a dozen numbers: premiums, deductibles, copays, coinsurance rates, maximums, an employer contribution. None of them is the number you actually want, which is how much each plan will cost your household over the year. This worksheet builds that number in eight lines, once for each plan, so that the two columns can be compared directly.
It works with any two employer plans. The worked example uses invented, round numbers for a household of three, and the blanks are yours to fill in. Nothing here predicts what a real plan costs; it organizes the figures you can get from your own documents.
What you need before you start
Gather four things before you begin, and write down where each came from:
- The payroll rate sheet. It shows what is taken from each paycheck for each plan and each coverage tier (employee only, employee plus spouse, family). Use the tier that matches your household.
- The summary of benefits and coverage for each plan. This standard document lists the deductible, coinsurance, copays, out-of-pocket maximum and examples of common costs. The How to read a Summary of Benefits and Coverage guide explains how to read one.
- Last year's usage for each person. Visits, prescriptions, tests, urgent care or emergency trips, and anything planned for next year such as a surgery, therapy or a pregnancy. Statements from your current plan, or the member portal, usually list them.
- The employer's health account contribution, if any, such as money put into an HSA, and what the contribution depends on.
If any of these is missing, ask the benefits office. The Questions to ask HR about health benefits before I accept a job offer post lists the questions that cover the gaps.
The eight lines
Fill in one column per plan. Where a line needs arithmetic, it is shown.
| Line | What to enter | Plan 1 | Plan 2 |
|---|---|---|---|
| 1 | Cost per paycheck for your coverage tier | $____ | $____ |
| 2 | Number of paychecks the premium is taken from | ____ | ____ |
| 3 | Yearly premium: line 1 x line 2 | $____ | $____ |
| 4 | Expected cost of visits and tests (see below) | $____ | $____ |
| 5 | Expected cost of prescriptions | $____ | $____ |
| 6 | Expected total: line 3 + line 4 + line 5 | $____ | $____ |
| 7 | Employer account money you expect to spend on care | $____ | $____ |
| 8 | Worst-case total: line 3 + the family out-of-pocket maximum | $____ | $____ |
Line 2: count the paychecks that really carry the premium
This is the line people get wrong. An employer that pays every two weeks has 26 paychecks in most years, but it may take the premium from only 24 of them, or from all 26. A twice-monthly payroll has 24, a monthly payroll 12 and a weekly payroll 52. Ask payroll how many deductions the plan year includes. Multiplying by the wrong number can move the yearly premium by hundreds of dollars.
Line 4: price each expected visit under each plan
For each person, list the expected visits and tests, and look up what each plan charges for that kind of care. Plans with copays charge a flat amount, such as a set fee for a visit. Plans with a deductible and coinsurance charge the full allowed amount until the deductible is met, then a percentage. Preventive care, such as an annual physical, is generally free of cost sharing in non-grandfathered plans, so leave those visits out.
When the deductible applies, keep a running total. Add the allowed amounts of the visits in the order they would happen, charge the family the whole allowed amount until the deductible is met, and charge the coinsurance percentage on what is left after that. The premium, deductible, copay and coinsurance explained simply guide has the vocabulary.
Line 5: drugs
Look up each regular prescription on each plan's drug list. Note the tier and whether the deductible applies first, and multiply the cost of one fill by the number of fills in the year.
Line 7: the employer's account money
Only count employer account money you expect to use. An HSA contribution from the employer belongs to you once deposited, and you can spend it on qualified medical costs, so it offsets line 4 and line 5 up to what you actually spend. If the money stays in the account for later years, it still has value but it does not reduce this year's cost. Some contributions are paid in installments or only if you complete a wellness step, so ask when and how it arrives.
Line 8: the worst case
The out-of-pocket maximum caps what you pay in covered, in-network care in a year. Add your premium to the family maximum for a bad-year figure. Premiums do not count toward the maximum, so they are added on top.
A worked example: a household of three
Say Alex (the employee), Sam (spouse) and Jo (child) are paid every two weeks. All figures below are invented for illustration. Both plans take their premium from all 26 paychecks, and Alex has two plans to choose from.
Plan A is a high-deductible plan with an HSA. It costs $150 per paycheck for family coverage, has a family deductible of $3,500, 20% coinsurance after the deductible, an $8,000 family out-of-pocket maximum, and an employer HSA deposit of $750.
Plan B is a copay plan. It costs $260 per paycheck for family coverage. Visits have flat copays: $25 for a sick visit, $50 for a specialist, $75 for urgent care and $10 for a generic drug. Imaging is subject to a $1,000 deductible, and the family out-of-pocket maximum is $5,000.
Step 1: premiums (lines 1 to 3)
Plan A: $150 x 26 = $3,900. Plan B: $260 x 26 = $6,760. The gap in premiums is $6,760 - $3,900 = $2,860 in favor of Plan A.
Step 2: last year's care, priced at invented allowed amounts
- Three annual preventive visits, one per person, free under both plans.
- Seven sick visits to a primary care or pediatric office, at $150 allowed each.
- Five specialist visits at $250 each.
- One imaging scan at $600.
- One urgent care visit at $200.
- Twelve generic prescription fills for Sam at $20 each.
Step 3: Plan A's cost of care (lines 4 and 5)
Everything except preventive care counts toward the deductible. The allowed amounts are 7 x $150 = $1,050 for visits, 5 x $250 = $1,250 for specialists, $600 for imaging, $200 for urgent care and 12 x $20 = $240 for drugs. The total is $1,050 + $1,250 + $600 + $200 + $240 = $3,340. That is less than the $3,500 deductible, so the family pays all $3,340 and the plan pays nothing, as the plan's coinsurance never starts.
Plan A's expected total (line 6) is $3,900 + $3,340 = $7,240. The employer HSA deposit of $750 covers part of the care, so line 7 is $750 and the net is $7,240 - $750 = $6,490.
Step 4: Plan B's cost of care
The copays work out to 7 x $25 = $175 for sick visits, 5 x $50 = $250 for specialists, $75 for urgent care and 12 x $10 = $120 for drugs, a subtotal of $620. The imaging scan is subject to the $1,000 deductible and costs $600, which is below it, so the family pays the full $600. Total care: $620 + $600 = $1,220.
Plan B's expected total is $6,760 + $1,220 = $7,980. There is no employer account money, so the net stays $7,980.
Step 5: the worst case (line 8)
Plan A: $3,900 + $8,000 = $11,900 before the HSA deposit, and $11,900 - $750 = $11,150 after it. Plan B: $6,760 + $5,000 = $11,760.
The result
| Plan A | Plan B | |
|---|---|---|
| Yearly premium | $3,900 | $6,760 |
| Expected care | $3,340 | $1,220 |
| Expected total | $7,240 | $7,980 |
| Expected total after employer HSA money | $6,490 | $7,980 |
| Worst case before HSA money | $11,900 | $11,760 |
| Worst case after HSA money | $11,150 | $11,760 |
On a typical year like last year's, Plan A costs $740 less before the HSA money and $1,490 less after it. In the worst case, Plan A costs $140 more before the HSA money and $610 less after it. The comparison is close, and a different usage pattern would change it. The next section shows how.
Test the result: what if next year looks different
A worksheet's value is that you can change one input and see what happens. Two quick tests on the example:
The break-even. Plan A's premium is $2,860 lower, so Plan A stays ahead as long as the family pays less than $2,860 more out of pocket under Plan A than under Plan B. Last year's extra was $3,340 - $1,220 = $2,120, which leaves the $740 saving. Now suppose a heavier year pushes the family's cost to $5,000 under Plan A and $2,000 under Plan B. The extra is $3,000, which is more than $2,860, so Plan B comes out ahead by $140. Those two figures are invented to show where the line falls. Rerun every line with real prices rather than adjusting one cell, because deductibles interact with every other line.
A quiet year. If the household has only the three preventive visits, Plan A costs $3,900 and Plan B costs $6,760. The difference of $2,860 is the price of Plan B's lower cost sharing in a year when the family did not use it.
For the same arithmetic with real figures, the health plan comparison calculator and the health insurance cost estimator can help. The I have an HMO, a PPO and an HDHP at work, so how do I pick one? post applies the same idea to a three-way choice.
Where each number comes from, and what to do when one is missing
Most lines have a clear source. The paycheck cost and paycheck count come from the payroll rate sheet or the enrollment portal. The deductible, copays, coinsurance and out-of-pocket maximum come from each plan's summary of benefits and coverage. Usage comes from your own explanations of benefits and pharmacy history. Employer account money comes from the benefits guide or an HR email.
When a number is missing, there are workable substitutes:
- No allowed amounts for visits. Many insurers offer a cost estimator on their member site. Employers can sometimes share it before enrollment. If neither exists, use the amount on last year's explanation of benefits for the same service, which shows the allowed amount the plan agreed to count.
- A planned procedure. Ask the surgeon's billing office for the expected billing codes and ask each plan whether the service needs approval and what it would allow. Add the result as its own line.
- A mix of in-network and out-of-network care. Price what is in network, and treat out-of-network care separately, because it may not count toward the maximum.
- No history for one person. A new baby or a new spouse has no claims. Use a reasonable guess, and keep the heavy-year version in mind.
Write the source next to each entry. When you sit down at the benefits office or call the insurer, you can then check each figure against the document it came from, and you will know which ones were estimates.
What the worksheet does not capture
The yearly number leaves out things that can matter more than a few hundred dollars:
- Networks. If a doctor or hospital you rely on is in only one plan's network, the cheaper plan may cost more once an out-of-network bill arrives. Check directories and confirm with the office.
- Tax effects. Employer premiums are usually taken before tax, and HSA contributions you make can be deductible or made before tax. A tax professional can say what these are worth to you.
- Deductible design. Some family deductibles are embedded, so one sick person stops paying deductible early, and some are aggregate, so the whole amount applies. The summary says which.
- Care that is not in last year's history. A new diagnosis or a pregnancy can change next year's usage. Add what you know is coming, and consider the worst-case line seriously for the plan you pick.
Key takeaways
- Convert each plan to one yearly number: premium plus expected care plus drugs, then compare the worst case separately.
- Check how many paychecks carry the premium. The count can move the yearly figure by hundreds of dollars.
- Use last year's care as the baseline and rerun the worksheet with a quiet year and a heavy year.
- Count employer account money only as far as you expect to spend it on care this year.
- The worksheet leaves out networks, taxes and deductible design, so check those before you decide.