Workers’ comp premiums through a PEO can feel like a black box. You get a bundled rate, pay monthly, and hope the year-end audit doesn’t hit you with a surprise bill. But here’s the thing: you can actually predict these costs with reasonable accuracy if you understand the moving parts.
This guide walks you through building a forecasting model specifically for PEO workers’ comp—not generic insurance forecasting, but the unique dynamics of how PEOs price, adjust, and reconcile these premiums. Whether you’re budgeting for next year, evaluating a PEO proposal, or trying to understand why your costs keep shifting, this model gives you a framework to work from.
We’ll cover the inputs you need, the calculations that matter, and how to stress-test your projections against real-world scenarios. By the end, you’ll have a working spreadsheet model and the knowledge to use it.
Step 1: Gather Your Baseline Data from Current or Proposed PEO Arrangements
You can’t forecast what you can’t measure. Start by collecting the raw data that drives your workers’ comp costs.
First, pull your current experience modification rate (EMR). This is the multiplier applied to your base premium based on your claims history. If you’re with a PEO, understand that they may use this differently than a standalone policy would. Some PEOs pool your experience with other clients. Others track it individually but apply their master policy’s overall experience factor. You need to know which structure you’re in.
Next, break down your payroll by job classification code. This is critical. PEOs don’t price workers’ comp as a flat percentage across your entire payroll. They price at the classification code level, where a warehouse worker might cost $8 per $100 of payroll while an office administrator costs $0.40. If you’re lumping everyone together in your forecast, you’re already off by potentially thousands of dollars.
Request your loss runs from the PEO covering at least three years. You’re entitled to this information—it’s your claims data. These reports show every workers’ comp claim filed, the amounts paid, and the amounts reserved for future payments. You’ll need this to understand your claims frequency patterns and project future experience modifications.
Document exactly how your PEO currently bills you. Is it a per-employee fee with workers’ comp bundled in? A percentage of payroll? A separate line item? Look for minimum premiums, administrative fees, or contributions to risk pools that might be buried in the agreement. These aren’t always obvious, but they affect your total cost.
If you’re evaluating a new PEO proposal, get this same level of detail from them. Ask specifically how they calculate workers’ comp premiums, what your projected EMR will be in their system, and whether you’ll participate in any loss-sensitive programs where your claims directly impact future costs.
Step 2: Map Your Classification Codes to NCCI Base Rates
Every job in your company falls under a specific NCCI classification code, and each code has its own base rate that varies by state. Getting this mapping right is where most forecasting models either work or fall apart.
Start by identifying each classification code your employees fall under. Common examples: 8810 for clerical office employees, 8742 for outside sales, 5645 for carpentry, 8380 for drivers. Your current workers’ comp policy or PEO agreement should list these. If you can’t find them, ask your PEO directly or review your most recent audit.
Look up the current NCCI base rates for your state and classification codes. NCCI publishes these annually, and they change based on loss experience in each state and industry. A code that costs $2.50 per $100 of payroll in Texas might cost $6.00 in California. These rates are publicly available through NCCI’s website or your state’s insurance department.
Here’s where it gets tricky with PEOs: they operate under master policies with their own negotiated rates. These might be lower than standard NCCI rates because of their volume, or they might be higher because they’re absorbing risk across a diverse client base. Calculate the spread between published NCCI base rates and what your PEO actually charges. That spread tells you their markup and gives you leverage during renewal negotiations.
If you have employees in multiple states, you’ll need to map rates for each location. Some states like Ohio, Washington, and Wyoming operate monopolistic state funds with completely different rate structures. Remote workers add complexity—their classification codes stay the same, but the base rates change based on where they work, not where your headquarters is located. Understanding multi-state payroll compliance becomes essential here.
Build a simple reference table: classification code, description, state, NCCI base rate, PEO actual rate, spread. You’ll use this throughout your forecasting model.
Step 3: Build Your Payroll Projection Engine
Your workers’ comp premium is fundamentally a function of payroll, so your forecast is only as accurate as your payroll projections. But you can’t just estimate total payroll and call it done.
Project payroll by classification code, not as a single aggregate number. If you’re planning to hire three warehouse workers and two office staff, those hires have wildly different workers’ comp costs per dollar of payroll. Break down your hiring plan by role, assign each role to its classification code, and project the payroll impact.
Account for raises, bonuses, and seasonal fluctuations. If you give annual raises in January, your payroll—and therefore your workers’ comp premium—steps up that month. If you’re in retail and hire seasonal workers in Q4, model that spike. Overtime and bonuses typically count toward workers’ comp payroll calculations, so don’t exclude them.
Build three scenarios: conservative, expected, and aggressive growth. Your conservative scenario might assume no new hires and minimal raises. Expected reflects your actual business plan. Aggressive models what happens if you land that big contract and need to staff up fast. This range gives you a planning buffer and helps you understand the cost implications of different growth paths.
Create monthly breakdowns to match how PEOs bill and reconcile. Most PEOs bill estimated premiums monthly based on projected payroll, then reconcile quarterly or annually based on actual payroll. If your payroll projection is annual but your billing is monthly, you’ll have cash flow surprises. Using a structured cost forecasting approach helps you catch variances early.
One detail that trips people up: different states and PEOs have different rules about what payroll counts. Some cap the includable wages per employee. Others exclude certain types of compensation. Check your PEO’s specific calculation methodology and build it into your projections.
Step 4: Calculate Your Experience Modification Impact
Your experience modification rate is the single biggest variable cost driver in workers’ comp, and it changes annually based on a rolling three-year window of claims history. Understanding how it moves is essential for accurate forecasting.
The EMR calculation uses three years of claims data, but excludes the most recent year. So if you’re forecasting for 2027, your EMR will be based on claims from 2023, 2024, and 2025. Claims from 2026 won’t factor in yet. This lag is important—it means a bad claims year doesn’t immediately spike your costs, but it also means a good year doesn’t immediately help you.
Look at your current open claims and model how they’ll age into the calculation. A claim that’s currently open with $50,000 reserved might settle for $30,000, or it might end up at $80,000. The EMR formula weighs actual paid amounts and remaining reserves differently, so the timing of claim closures matters. Build a simple aging schedule: which claims will be fully developed in the next EMR calculation, and which will still be open with reserves?
Project how your EMR changes as old claims drop off the experience period. If you had a terrible claims year in 2023, that will fall out of your 2028 EMR calculation. Your modification should improve, all else being equal. A dedicated mod rate forecasting model can help you project these changes with precision.
With PEOs, this gets more complex. Some PEOs use pooled experience programs where your individual claims don’t directly impact your rate—you’re paying based on the collective experience of all clients in the pool. Others use loss-sensitive programs where your specific claims history drives your costs. Know which structure your PEO uses. If it’s pooled, your EMR forecast is simpler but less controllable. If it’s loss-sensitive, your claims management directly affects your budget.
Run a sensitivity analysis: what happens if you have one significant claim this year? A single $100,000 claim can move your EMR by 0.10 to 0.30 points depending on your payroll size and claims history. On a $500,000 annual premium, that’s $50,000 to $150,000 in additional costs over the next three years. Build this scenario into your model so you’re not blindsided.
Step 5: Layer in PEO-Specific Pricing Variables
PEOs don’t just pass through workers’ comp costs at cost. They add administrative margins, risk charges, and program fees that can significantly impact your total spend. These variables are often opaque, but you can model them if you know where to look.
Start with the administrative markup or risk margin. Most PEOs add 15-30% above the pure workers’ comp premium to cover their overhead, profit, and risk assumption. Some show this as a separate line item. Others bundle it into their per-employee fee or percentage-of-payroll charge. Review your current invoices and PEO agreement to identify where this margin lives. Understanding how cost allocation models work helps you reverse-engineer these hidden fees.
If your PEO uses a loss-sensitive program, you’ll likely have loss fund contributions. These work like a large deductible—you’re essentially self-insuring the first layer of claims up to a threshold, and the PEO covers excess losses. Your monthly contributions go into a fund, and claims are paid from that fund. If claims are low, you might get a refund. If they’re high, you might owe additional contributions. Model these as a separate cost category with best-case and worst-case scenarios.
Factor in annual rate increases. PEO master policies renew annually, and rates change based on NCCI filings, state approvals, and the PEO’s own loss experience. Historically, workers’ comp rates have been relatively stable or declining in many states, but that can shift quickly. Build in a 3-5% annual increase assumption as a baseline, and stress-test with higher increases.
Some PEOs offer participation in return premiums or dividends if overall program performance is strong. If your PEO has this feature, model it conservatively. Don’t count on it as guaranteed savings, but include it as a potential offset in your best-case scenario.
Finally, build in audit adjustment reserves. Most PEO audits result in additional premium owed because actual payroll exceeds estimates, classification codes get corrected, or overtime wasn’t properly accounted for. Set aside 5-10% of your estimated annual premium as a reserve for audit adjustments. If you consistently come in under, great—adjust your assumptions. But planning for it prevents budget surprises.
Step 6: Stress-Test Your Model Against Real Scenarios
A forecasting model that only works under perfect conditions isn’t useful. The value comes from understanding how costs shift when reality doesn’t match your assumptions.
Run a ‘bad claims year’ scenario with one moderate and one severe claim. Let’s say a moderate claim is $25,000 and a severe claim is $150,000. How does that impact your EMR in the following years? How does it affect your loss fund balance if you’re in a loss-sensitive program? This scenario shows you the true cost of claims beyond just the immediate payout—it’s the multi-year EMR impact that often surprises businesses.
Model a hiring surge that changes your classification mix. If you’re planning to double your warehouse staff but keep office staff flat, your overall workers’ comp costs will increase disproportionately to payroll growth because you’re shifting toward higher-rate classification codes. Run this scenario to understand the budget impact before you make hiring decisions.
Test what happens if state NCCI rates increase by 5-10%. Rate increases aren’t common across the board, but they do happen in specific states or industries after adverse loss experience. If your state files for a rate increase, how does that flow through your PEO’s pricing? Some PEOs absorb part of the increase; others pass it through entirely. Conducting a thorough renewal risk analysis helps you anticipate these changes.
Calculate the impact of moving employees between classification codes. Misclassification is one of the most common sources of audit adjustments. If your PEO auditor reclassifies five employees from clerical (low rate) to light manufacturing (higher rate), what does that do to your annual premium? Build a simple sensitivity table showing the cost per employee for each classification code you use.
Finally, validate your model by comparing your forecast against actual bills from the past two or three years. If you’ve been with your PEO for a while, you have real data to test against. Run your model backwards—plug in the actual payroll, actual claims, and actual rates from 2024, and see if your model spits out numbers close to what you actually paid. Knowing how to reconcile your payroll audit ensures you’re comparing apples to apples.
Putting It All Together
Your forecasting model is only as good as the inputs you feed it and your willingness to update it quarterly. The real value isn’t in predicting costs to the penny—it’s in understanding the levers that drive your workers’ comp spend and having early warning when costs are trending in the wrong direction.
Use this model during PEO renewals to pressure-test their proposed rates. When a PEO comes back with a 12% increase, you can break down whether that’s driven by NCCI rate changes, your EMR movement, payroll growth, or just their margin expansion. That specificity gives you negotiating leverage.
Use it during budgeting to set realistic expectations with your CFO. Instead of saying “workers’ comp will be roughly the same as last year,” you can say “based on our hiring plan and current claims trajectory, we’re projecting a 7% increase, with downside risk of 15% if we have a significant claim.”
And use it throughout the year to catch payroll classification errors before they become audit surprises. If your monthly actuals are consistently running higher than your model predicted, investigate. You might have employees misclassified, overtime you didn’t account for, or rate changes you missed.
Quick checklist: baseline data collected, classification codes mapped, payroll projections built, EMR impact calculated, PEO variables layered in, and stress tests completed. Now you’re forecasting, not guessing.
Before you sign that PEO renewal, make sure you’re not leaving money on the table. Many businesses unknowingly overpay because of bundled fees, hidden administrative markups, and contracts designed to limit flexibility. We give you a clear, side-by-side breakdown of pricing, services, and contract terms—so you can see exactly what you’re paying for and choose the option that truly fits your business. Don’t auto-renew. Make an informed, confident decision.
