How Employers Use Claims Utilization Data to Evaluate Self-Funded Health Plan Readiness

Every employer who has received a renewal increase of 20 percent or more on a fully insured or level-funded health plan has asked the same question: why is this happening when my employees barely used their benefits? The answer is often structural. Fully insured premiums are pooled by the carrier, which means healthy workforces subsidize the claims costs of less healthy groups in the same risk pool. If your workforce has low utilization, you may be significantly overpaying relative to your actual cost of care.

The decision to evaluate self-funded coverage is ultimately a data decision. Self-funding transfers the risk of actual claims costs from the insurance carrier to the employer, which creates the opportunity to capture savings when claims are low and the exposure to higher costs when claims are high. Understanding your claims utilization data is how you determine which side of that equation your workforce is on, and whether self-funding is an appropriate strategy for your organization right now.

Understanding the Medical Loss Ratio

The medical loss ratio is the ratio of claims paid to premiums collected. If your carrier collected $1,000,000 in premiums from your group last year and paid $700,000 in medical claims, your loss ratio is 70 percent. The remaining 30 percent covers administrative costs, broker commissions, and the carrier's margin.

For fully insured plans, the carrier assumes the risk that your loss ratio could exceed 100 percent in any given year. If your group has a catastrophic claim year, the carrier absorbs the excess. The cost of that protection is built into the premium, and it is priced based on the carrier's assessment of your group's risk profile, not your specific claims history in any single year. This pooling is the fundamental value proposition of fully insured coverage, and it is also the reason healthy workforces tend to overpay relative to their actual cost of care.

Why Low Loss Ratios Signal Potential Overpayment

A loss ratio consistently below 60 to 70 percent across two or more plan years suggests your group is paying for risk protection it is statistically unlikely to need at the level priced into the premium. In a self-funded arrangement, the savings from a low-utilization year flow back to the employer rather than to the carrier's margin. Over a three-year period, an employer with a 55 percent loss ratio on a $500,000 annual premium is effectively paying roughly $225,000 per year for risk pooling and administrative overhead that a self-funded structure could provide for significantly less.

This is not a guaranteed outcome. Self-funded coverage carries volatility risk that fully insured coverage does not. A group with a consistently low loss ratio can have a catastrophic claim year, and without adequate stop-loss protection, the employer bears that cost directly. The analysis is about probability and structure, not certainty.

What a High Loss Ratio Means for Funding Strategy

A loss ratio consistently above 85 to 90 percent suggests your group has higher-than-average claims relative to the premiums you pay. In this case, fully insured or level-funded coverage may be the right structure because the pooled risk arrangement protects you from the full cost of your claims. The carrier is absorbing losses on your behalf. Switching to self-funded coverage in this scenario transfers that loss exposure back to the employer, which could result in higher net costs even if the administrative overhead of the plan structure is lower.

The loss ratio is a starting point, not a conclusion. The more important question is whether the pattern is stable or volatile. A group with a 90 percent loss ratio driven by a single catastrophic claim in one year looks very different over a five-year period than a group with a 90 percent loss ratio driven by consistently high utilization across a broad population. Stop-loss coverage can protect against the former but not the latter. This distinction matters significantly for how you structure a self-funded plan if you choose to move in that direction.

Claims Utilization by Category

Total loss ratio is one data point. A more complete picture comes from breaking claims utilization down by category: inpatient facility (hospital admissions), outpatient services (surgeries, imaging, specialist visits), emergency department visits, prescription drugs, and behavioral health. Each category has a different cost profile and a different set of management levers available to an employer who controls their own plan design.

Inpatient and Outpatient Patterns

Inpatient claims tend to be the highest-cost and lowest-frequency category for mid-market employers. A single inpatient admission can range from $15,000 for a routine procedure to $500,000 or more for a complex surgical case or extended ICU stay. If your inpatient category is driving a high loss ratio, the relevant question is whether that reflects one or two individual events or a pattern of high utilization across multiple members across multiple years.

Outpatient claims are typically higher frequency but lower individual cost. High outpatient utilization often reflects a workforce that actively uses preventive care and manages chronic conditions, which is generally a positive indicator for long-term cost control even if it pushes the current-year loss ratio higher. Preventive care utilization tends to reduce high-cost inpatient admissions over time, so the relationship between the two categories matters as much as either number in isolation.

Pharmacy Spend as a Leading Indicator

Prescription drug claims are often the most predictive indicator of future medical costs. Members on specialty medications for conditions like rheumatoid arthritis, multiple sclerosis, or certain cancers are likely to have recurring high-cost claims. If your pharmacy spend is concentrated in a small number of members on specialty drugs, your loss ratio is partially driven by a few high-cost individuals whose claims are predictable but will not decrease significantly with plan design changes alone.

Employers evaluating self-funding should look at pharmacy utilization data specifically to understand how much of their total claims cost comes from specialty drug spend versus general pharmacy utilization. This affects stop-loss structuring, formulary design, and whether specialty carve-out programs make sense for your specific plan population. Specialty drug costs are also one of the categories most likely to increase year over year regardless of overall workforce health trends.

Workforce Characteristics That Interact With Utilization Data

Utilization data tells you what happened in the past. Workforce demographics help you project what is likely to happen in the future. The most relevant demographic factors for self-funding analysis are age distribution, family composition, and the prevalence of known chronic conditions in your enrolled population.

Age Distribution and Actuarial Risk

Healthcare costs increase with age. A workforce with an average age of 28 has a fundamentally different risk profile than a workforce with an average age of 46, even if both groups have similar loss ratios in any single year. Younger workforces tend to have lower baseline utilization but higher volatility risk, meaning a single bad claim year can swing the loss ratio significantly. Older workforces tend to have more predictable but higher baseline costs that are less sensitive to individual claim events.

When modeling self-funded readiness, underwriters typically look at the three oldest and highest-risk enrolled members of your group as a proxy for the tail risk on individual claims. If your oldest enrolled member is 61 with a known complex condition, stop-loss structuring needs to account for that specific risk profile rather than just the aggregate loss ratio. The aggregate number is an average. What matters for stop-loss is the tail.

Family Composition and Dependent Coverage

Employee-only coverage has a different cost profile than coverage that includes spouses and dependents. Groups with high dependent enrollment tend to have higher per-member claims costs because families use more healthcare in aggregate. Maternity claims, pediatric visits, and the accumulated utilization of a spouse with their own health history all flow through the group plan.

Some employers find that analyzing claims by tier (employee only, employee plus spouse, employee plus children, employee plus family) reveals significant cost variation that is not visible in aggregate loss ratio data. If a small percentage of your enrolled population is driving a disproportionate share of claims through dependent coverage, that pattern is likely to persist regardless of which funding structure you use. Understanding it changes the stop-loss structuring conversation and may influence plan design decisions regardless of your funding choice.

How to Request and Read Your Claims Experience Data

Most carriers provide claims experience data to employers with 50 or more enrolled members, though some extend this to smaller groups. The data is not typically sent proactively. You need to request it in writing, usually through your broker, and specify the format and time period you want.

A standard experience report should include the following: total premium collected, total claims paid, administrative fees, broker commissions, the resulting loss ratio, and a claims breakdown by category. Ask for at least 24 months of data, and 36 months if your group has been with the same carrier for that period. A single plan year is not sufficient because healthcare costs fluctuate significantly year to year. A single anomalous year in either direction can misrepresent your group's actual risk profile if viewed in isolation.

Reading the Report for Self-Funding Signals

Look at the trend line, not just the most recent year. Is your loss ratio improving, deteriorating, or stable across the period? Are the same members driving high claims across multiple years, which suggests chronic condition management is a factor, or are high-cost claims coming from different members each year, which suggests more random volatility? Has prescription drug spend increased as a percentage of total claims over the period, which may predict higher costs regardless of funding structure?

The Health Funding Projector can help you model what your premium equivalent would look like under a self-funded structure using your actual loss ratio and claims history as inputs. The model accounts for stop-loss costs, third-party administrator fees, and expected claims run-out to give you a more complete comparison than premium-only analysis can provide.

Running the Numbers: Modeling a Transition to Self-Funded Coverage

Before evaluating self-funded coverage in earnest, employers should build a model that compares three scenarios: staying fully insured at the current renewal, moving to level-funded coverage, and moving to a fully self-funded arrangement with appropriate stop-loss protection. Each scenario has a different cost structure, risk profile, and cash flow impact that needs to be understood before a decision is made.

Level-Funded as the Intermediate Step

Level-funded coverage occupies the middle ground between fully insured and self-funded. Employers pay a fixed monthly amount that covers expected claims, a stop-loss premium, and administrative fees. If claims come in below projections, the employer receives a surplus refund at year end. If claims exceed projections, the stop-loss coverage absorbs the excess up to the aggregate limit.

Level-funded coverage is often the right first step for employers who have never analyzed their claims data and want to test the self-funded model without full exposure to claims volatility. The fixed monthly payment maintains cash flow predictability while beginning to create the claims data history that makes a future move to full self-funding more informed and less speculative.

Use the Premium Renewal Stress Test to model how your current fully insured premiums would change under a level-funded structure at different aggregate attachment point thresholds. The difference between a 110 percent attachment point and a 125 percent attachment point significantly changes the risk transfer characteristics of the plan and has a material impact on what your renewal looks like in a high-claims year.

Stop-Loss Structure and Its Impact on Risk Exposure

Self-funded plans use stop-loss insurance to cap the employer's exposure on individual high-cost claims (specific stop-loss) and on the group's aggregate claims costs (aggregate stop-loss). The specific stop-loss deductible is the threshold above which the stop-loss carrier begins paying claims for an individual member. It is sometimes called the laser or the attachment point.

A specific stop-loss deductible of $75,000 means the employer pays the first $75,000 of any individual member's claims in the plan year before the stop-loss carrier takes over. If a member has a $400,000 surgery, the employer's net exposure is $75,000. If the deductible were $150,000, the employer's exposure on the same event doubles. Selecting the right specific deductible requires balancing premium cost against the employer's actual appetite for individual claim risk.

The structure of your stop-loss coverage is as consequential as your historical loss ratio when evaluating self-funded readiness. An employer with a low historical loss ratio but no high-cost claimant history may be comfortable with a $100,000 specific deductible. An employer whose historical data shows recurring six-figure claims should carefully evaluate whether a lower specific deductible, or a captive structure that provides contractual laser protection, is more appropriate than a standard self-funded arrangement.

When the Data Suggests Not Pursuing Self-Funded Coverage

Self-funded coverage is not appropriate for every employer, and recognizing the conditions where it creates net risk rather than net savings is as important as knowing when to pursue it. A disciplined evaluation process includes explicit criteria for disqualifying scenarios, not just qualifying ones.

Employers with fewer than 20 enrolled members face significant volatility risk in self-funded arrangements. With a small group, a single high-cost claimant can drive the loss ratio from 40 percent to 200 percent in a single plan year, even with stop-loss coverage in place. The stop-loss premium required to adequately protect a very small group often eliminates the cost advantage of the self-funded structure by making the overall economics unfavorable compared to a fully insured or level-funded alternative.

Employers with known high-cost claimants should evaluate whether stop-loss underwriters will exclude those specific members from coverage or impose a laser provision, which sets a higher specific deductible for that member in the upcoming plan year. A laser provision can leave an employer with a theoretically self-funded plan that retains full exposure on its highest-cost member, which may be worse than the fully insured alternative for that specific population configuration.

Employers in industries with high workforce turnover face a different kind of risk. High turnover means constant new member onboarding, which creates unpredictability in claims patterns and makes historical loss ratio data less predictive of future costs. If your workforce turns over 40 to 60 percent annually, the members generating claims in year three may look nothing like the members who generated claims in year one. Self-funding works best when the enrolled population is relatively stable and the historical data is therefore predictive of near-term experience.

The Benefits ROI Calculator includes a self-funded readiness module that evaluates these factors against your current workforce profile and produces a readiness assessment. The assessment organizes the relevant variables in a way that supports a productive conversation with a benefits strategist about whether the timing is right for your specific situation and what structure would be most appropriate if you do pursue a transition.

Related Reading

For additional context on self-funded coverage and employer health plan strategy, explore these related Benefitra articles:

• Level-Funded Aggregate Attachment: The Employer's Guide to Managing Renewal Risk
• Self-Funded Captive Health Plans for Mid-Market Employers: Structure, Savings, and Risk
• Stop-Loss Coverage in Self-Funded Health Plans: What Employers Need to Know

Frequently Asked Questions

How many years of claims data do I need before evaluating self-funded coverage?

Most underwriters and benefits strategists recommend at least 24 months of claims experience data before making a self-funded transition decision. Thirty-six months is preferable because it provides a more stable view of your group's utilization patterns and reduces the distortion of any single anomalous year. If you have been with the same carrier for fewer than two years, you may need to rely on industry benchmarks and workforce demographic data to supplement limited claims history, which introduces more uncertainty into the modeling. A benefits strategist can help you understand how much weight to put on limited historical data in that scenario.

Can a small employer with 25 to 35 employees realistically self-fund?

Yes, but the structure matters significantly. At 25 to 35 employees, a pure self-funded arrangement carries substantial volatility risk. The more appropriate structure for this size range is typically level-funded coverage, which provides many of the economic benefits of self-funding (claims surplus refunds, access to claims data, fixed monthly premiums) with the protection of a fully insured aggregate stop-loss backing. Some captive arrangements are also designed to serve employers in this size range, offering an additional layer of pooled risk protection that standard stop-loss coverage does not provide. The specific deductible on a captive plan in this size range is often contractually capped, which eliminates the laser risk that can make a standard self-funded plan problematic for small groups with high-cost members.

What happens to a self-funded plan when a member is diagnosed with a high-cost condition mid-year?

The specific stop-loss coverage activates once that individual member's claims exceed the specific deductible threshold in the plan year. For example, if your specific deductible is $75,000 and a member incurs $300,000 in claims during the plan year, your plan pays the first $75,000 and the stop-loss carrier pays the remaining $225,000. The more complex question is what happens at renewal. Stop-loss carriers review individual claims history during renewal underwriting, and they may impose a higher specific deductible for that member in the next plan year, which increases your exposure going forward. Captive structures with contractual hard laser caps are specifically designed to address this risk by limiting how much the individual member deductible can be increased at renewal.

How do I get my claims data from my current carrier if I am considering switching funding structures?

Request the data in writing through your broker, citing your right to your own plan's experience data. Carriers may be slow to provide this data for groups they know are evaluating alternatives, but they are generally required to produce it within a reasonable period after a formal written request. Specify the format you need: a structured spreadsheet is more useful than a PDF summary. Include in your request the data fields you need: total premium, total claims, claims by category, member count by month, and dependent breakdown if available. Your broker should be familiar with this process and can help draft the request if you have not submitted one before.

Is there a calculator that can help me estimate what self-funded coverage would cost for my company?

Yes. The Health Funding Projector models the cost difference between fully insured, level-funded, and self-funded structures using inputs specific to your group. You will need your current premium, an estimate of your loss ratio or total claims for the most recent plan year, your employee count and demographic mix, and your primary state of coverage. The tool produces a scenario comparison showing the expected cost under each structure and the conditions under which each option generates savings or increases risk. It is a starting point for the analysis, not a replacement for an underwriting review, but it helps frame the conversation with a benefits strategist before you commit time and effort to a formal quoting process.