A business owner asks, “What will health insurance cost us?” It sounds like a request for a number, but it is really a request for a model. Two businesses with the same headcount can have different bills because their employees live in different places, enroll in different tiers, choose different plans, and receive different employer contributions. Even one business can see its cost change without changing carriers: a hire, a dependent added midyear, or an employee moving between plans changes the arithmetic. A useful answer therefore starts with a ledger rather than an average.
Begin with three numbers, not one
For each plan and coverage tier, distinguish the carrier's monthly premium, the portion the employer pays, and the portion withheld from the employee's pay. These numbers must add up at the tier level. A $900 monthly total premium with a $600 employer share leaves $300 for the employee in a simple illustration. That does not mean every employee owes $300: employee-only, employee-plus-child, employee-plus-spouse, and family elections can have different prices and employer shares. Nor does it tell you when the carrier bill or payroll deduction is processed.
The carrier's invoice generally reflects enrolled coverage. Your accounting system may initially record the whole carrier payment and then offset part through payroll deductions. Finance needs to know both gross premium and net employer spending. Otherwise, a presentation of a $900 carrier rate can be mistaken for a $900 employer obligation, or a $600 contribution can be mistaken for the full bill. Keep both columns visible, with employee deductions on their own line.
Build the Tier-and-Mix Ledger
Use a separate row for every offered plan and coverage tier. Put the effective date and the source of each rate at the top of the worksheet. The ledger should be reproducible by someone who did not attend the quote meeting. For every row record the following fields:
- Plan name and coverage tier; confirm whether a child-only or spouse tier actually exists rather than assuming it does.
- Number of enrolled employees in that tier, and whether the count is current, projected, or a scenario.
- Carrier monthly total premium per election and any billed fee not already included in that rate.
- Employer monthly contribution per election; employee monthly balance equals total premium minus employer contribution.
- Monthly employer subtotal: enrollment count multiplied by employer contribution. Repeat for total carrier premium.
- Expected enrollment changes, their assumed effective months, and the person responsible for updating the model.
The worksheet's first result is a monthly snapshot. Its second result is a plan-year forecast. Do not automatically multiply the snapshot by twelve if you know ten hires will enter during the year. Model those people in the months when coverage is expected to begin. Likewise, do not treat eligible headcount as enrolled headcount: people can decline coverage or elect a different tier, subject to applicable eligibility and enrollment rules.
A hypothetical census, worked all the way through
Hypothetical example only, not a market quote: a Florida employer has 30 enrolled employees, split into 18 employee-only elections, 8 employee-plus-child elections, and 4 family elections. Assume monthly total premiums of $600, $900, and $1,400, respectively. Assume the employer contributes $450, $600, and $800 per election. All figures are invented solely to demonstrate the calculation.
Employee-only premium is 18 × $600 = $10,800 monthly; employer share is 18 × $450 = $8,100. Employee-plus-child premium is 8 × $900 = $7,200; employer share is 8 × $600 = $4,800. Family premium is 4 × $1,400 = $5,600; employer share is 4 × $800 = $3,200. The carrier premium totals $23,600 monthly. The employer portion totals $16,100 monthly, while employees collectively pay $7,500 through the assumed contribution arrangement. If that exact mix lasted twelve months without any other charges, the hypothetical employer share would be $193,200 and the gross carrier premium $283,200.
Now assume, still hypothetically, two additional employees elect employee-only coverage for six months each at the same rates. Their added employer share is 2 × 6 × $450 = $5,400, bringing the illustrated employer forecast to $198,600. Their added gross premium is 2 × 6 × $600 = $7,200, bringing the illustrated gross premium to $290,400. This is not a prediction: eligibility, enrollment dates, rate terms, and actual elections would need verification. The useful point is that a headcount forecast belongs in the same document as the quote.
Which costs are fixed, and which move?
A fully insured monthly carrier rate for an enrolled tier is generally a known price for the relevant contract period, subject to policy terms and changes. The invoice total is variable because the number and mix of enrolled people can change. Implementation charges, technology fees, or administrative costs, if any, should be identified by the written proposal rather than presumed to be included. A broker should clarify which amounts are carrier charges, which belong to another vendor, and which are optional services. Different funding arrangements can have different cost components and risk; a lower displayed monthly figure is not necessarily a lower total obligation.
For a budgeting meeting, group charges into four buckets: recurring premium or funding payments; separately billed administration or technology; one-time setup or transition items actually documented in the proposal; and internal time needed for enrollment and payroll changes. Do not invent a dollar amount for internal time if it is not measured. Label it as an operational consideration. A medical plan quote also does not automatically include dental, vision, life, or disability coverage. Put those programs on separate lines so a “benefits total” does not quietly become a “medical-only total.”
The levers an employer actually controls
An employer can discuss plan choices, the number of options offered, contribution design, and whether a proposed network or deductible is acceptable to employees. It cannot simply decree the carrier's final quoted price. Changing the employer share may lower the company's projected cost while raising employee paycheck deductions. Changing the plan may move risk to employees through cost sharing or change which providers participate. A different funding structure introduces a separate set of contract questions. Show every lever with an employer-cost column and an employee-impact column before presenting it as a saving.
A useful decision example: in the hypothetical census above, reducing the employer share for eight employee-plus-child elections by $50 per month changes company expense by 8 × $50 × 12 = $4,800 over a stable twelve-month enrollment year. Those eight employees would each pay $50 more per month, or $600 more annually under the same assumptions. That arithmetic is clear; whether the decision is acceptable, lawful, affordable, or good for retention is not settled by the spreadsheet. Review the actual plan, employee classifications, and applicable requirements before adopting a contribution change.
Request quotes on the same facts
An actionable quote request starts with a dated, securely handled eligible census and the proposed effective date. Ask what employee and dependent data a carrier needs and share only what is necessary through appropriate channels. Include current enrollment by tier, the existing plan summary and rates if available, employee work and residence locations relevant to quoting, and the employer's intended contribution approach. Ask the adviser to state which assumptions are verified and which are provisional. Employees' health information should not be casually collected in a budgeting spreadsheet.
Require responses that separate carrier premium from employer contribution, identify plan and network differences, and show any separately billed items. If a quote assumes a different census or coverage tier mix, recalculate it before ranking options. Ask when rates can change and what remains contingent on enrollment or underwriting under the particular arrangement. That is a more honest comparison than lining up three first-page totals with different assumptions.
Budget beyond the first invoice
Have payroll and benefits administration reconcile the first carrier invoice against elections and employee deductions. Then check actual versus projected enrolled counts monthly, noting the reason for changes rather than quietly overwriting the forecast. If recruiting plans accelerate, make a new forecast. If fewer families enroll than expected, retain the original scenario as a record of the decision rather than claiming the quote was wrong. Keep a modest scenario range for uncertainty without presenting any arbitrary contingency percentage as a market standard.
For a 20-to-300-person employer, the most useful output is a one-page annual view: total premium, employer share, employee share, separately documented fees, and a low/base/high enrollment scenario. Underneath it, preserve the tier ledger and proposal evidence. That lets a finance leader approve a budget and lets an HR leader explain what employees will see. If you want an independent review, bring Northbridge your current census, plan summary, and contribution policy; ask us to help organize the questions before you choose a direction. We cannot promise a quoted rate or a specific result.
General information only, not insurance, legal, tax, or medical advice. Coverage and obligations depend on actual contracts, employer facts, and applicable law; consult appropriately qualified insurance, legal, and tax professionals before acting.