Most businesses evaluate PEO providers by comparing monthly fees side-by-side. That’s a reasonable starting point, but it misses the bigger picture entirely.
A PEO relationship isn’t a one-month purchase. It’s a multi-year financial commitment with compounding cost dynamics: annual rate escalations, shifting workers’ comp premiums, benefit renewal increases, and administrative costs that only surface once you’re locked in. Comparing Year 1 quotes doesn’t tell you which provider is actually cheaper over three to five years.
Net present value (NPV) gives you a way to collapse all of those future cash flows into a single, comparable number in today’s dollars. It accounts for the time value of money, which matters when you’re weighing a PEO with escalating fees against one with a higher upfront cost but more stable pricing. Those two options can look identical in Year 1 and diverge dramatically by Year 3.
This guide walks you through building a working NPV calculator for PEO comparison. Not an academic exercise. A practical spreadsheet model you can actually use to evaluate proposals on equal footing.
You don’t need a finance degree. You need your PEO quotes, a spreadsheet, and about an hour. By the end, you’ll have a model that accounts for admin fees, insurance cost trajectories, compliance savings, and the real cost of switching providers — all discounted to present value so you’re comparing apples to apples.
Let’s build it.
Step 1: Map Every Cost Category in Your PEO Proposals
Before you build any model, you need a complete picture of what you’re actually paying for. This sounds obvious, but PEO pricing is notoriously opaque, and most businesses work from summary proposals that leave out a significant portion of the real cost.
Start with the direct cost line items every proposal should include:
Admin fees: These are usually structured as a per-employee-per-month (PEPM) flat rate or a percentage of gross payroll. Know which structure you’re being quoted — they behave very differently as your headcount or payroll grows. For a deeper dive into fee structures, see our breakdown of how much a PEO costs across different pricing models.
Workers’ comp premiums: PEOs typically offer workers’ comp through their master policy. Get the actual rate per $100 of payroll by classification code, not just a blended summary number.
Health insurance contributions: What the PEO is charging your company for employer-side health premiums, broken out by plan tier if possible.
Retirement plan admin fees: 401(k) recordkeeping and administration costs, which are sometimes bundled into the overall admin fee and sometimes itemized separately.
Technology platform fees: HRIS access, onboarding software, and reporting tools are occasionally billed separately. Confirm whether they’re included.
Now the part most businesses skip: the indirect costs buried in contract language.
Payroll tax markup differentials: Some PEOs pass through employer payroll taxes at cost; others build in a margin. Read the contract language carefully, not just the proposal summary.
Claims fund deposits: Certain workers’ comp arrangements require upfront reserves or loss fund deposits that affect your cash flow in Year 0 and Year 1.
Mid-year rate adjustment clauses: Some contracts allow the PEO to adjust health insurance or workers’ comp rates mid-year based on claims experience. This is a significant risk variable that most businesses don’t model.
Termination and transition fees: Covered in more detail in Step 6, but flag them now while you’re reading the contract.
The practical move here: request the full fee schedule and all contract addenda, not just the summary proposal. Understanding the details of your PEO service agreement is essential since the addenda are where the variable cost triggers live.
Once you have the full picture from each provider, build a standardized cost taxonomy — a master list of line items that every proposal maps to. If Provider A bundles workers’ comp into their admin fee and Provider B prices it separately, you need to normalize those before you can compare them. This taxonomy is the foundation of your NPV model. Get it wrong here and every downstream calculation is off.
Step 2: Establish Your Projection Timeline and Discount Rate
Two inputs determine the shape of your entire NPV model: how far out you’re projecting, and what discount rate you’re applying. Both require a judgment call, and both are worth thinking through carefully.
Projection horizon: For most small and mid-size businesses, a three to five year window is the right range. Three years is a reasonable minimum — it’s long enough to capture escalation dynamics but short enough that your assumptions stay grounded. Beyond five years, you’re stacking so many estimates on top of each other that the precision becomes illusory. Pick a horizon that reflects how long you realistically expect to stay with a PEO before re-evaluating.
Discount rate: This is where people either overthink it or ignore it entirely. The discount rate represents the opportunity cost of your money — what you could earn if you deployed those dollars elsewhere. Your company’s weighted average cost of capital (WACC) is the technically correct choice. If you don’t have a formal WACC calculation, use your business borrowing rate as a proxy. For most small and mid-size businesses, something in the 8-10% range is a reasonable working assumption.
Here’s why the discount rate choice actually matters in practice, not just in theory.
A higher discount rate shrinks the present value of future costs. That means back-loaded costs — like a PEO contract where fees escalate significantly in Years 3 and 4 — look less painful than they actually are. If you use a high discount rate, you’re inadvertently giving escalating-fee providers a pass.
A lower discount rate does the opposite. Future cost increases hit harder in present-value terms, which more accurately penalizes providers with aggressive escalation clauses.
The practical implication: don’t just pick a number and move on. Run the model at two or three different discount rates (say, 6%, 8%, and 10%) and see if your provider ranking changes. If the same provider wins at all three rates, you have a robust result. If the ranking flips depending on the rate, you have a sensitivity worth understanding before you sign anything.
One common mistake worth flagging: treating the discount rate as an inflation adjustment. They’re related but not the same thing. If you’re projecting costs in nominal dollars (which you should be, since PEO contracts are denominated in nominal dollars), your discount rate should be a nominal rate — don’t try to strip out inflation separately unless you’re also projecting costs in real terms. For more on how PEO costs flow through your books, our guide on PEO financial statement presentation covers the accounting side in detail.
Step 3: Build Your Annual Cash Flow Projections for Each Provider
This is the core of the model. For each PEO option, you’re building a year-by-year cost projection that starts with the quoted figures and extends them forward using realistic escalation assumptions.
Start with Year 1 actuals from your standardized cost taxonomy. Then apply escalation rates by category:
Admin fees: Check the contract for any annual escalation clause. Some PEOs lock in a fixed PEPM or percentage rate for the contract term; others include language allowing increases tied to CPI or at the PEO’s discretion. If there’s a cap, note it. If there’s no cap, that’s a risk variable.
Health insurance: Health premiums typically escalate faster than general inflation. Your actual renewal rate will depend on your group’s claims experience, the plan design, and the carrier. If the PEO can’t give you historical renewal rate data for comparable groups, that’s a red flag. Understanding the PEO impact on insurance expense reporting can help you model these escalations more accurately.
Workers’ comp premiums: These are driven heavily by your experience modification rate (mod rate). If your claims history is clean, your mod rate may improve over time, lowering premiums. If you’ve had claims, the trajectory goes the other way. Model this based on your actual claims history, not a generic assumption. Our guide on calculating PEO workers’ comp premiums walks through the rate mechanics step by step.
Headcount: Per-employee pricing makes headcount a major variable. Your model should let you adjust projected employee count by year. If you’re planning to grow from 25 to 40 employees over three years, that materially changes the cost comparison — especially if one provider has a significantly different PEPM structure than another.
Now build the baseline: what does it cost to handle HR in-house instead?
This step is critical and often skipped. Without an in-house baseline, you’re just comparing PEOs to each other, not answering whether a PEO is worth it at all. Your baseline should include: HR staff salaries and benefits (fully loaded), standalone health insurance premiums, workers’ comp premiums through a standalone carrier, payroll processing fees, benefits broker fees, and compliance consulting costs for areas like ACA reporting and multi-state payroll.
Be honest with this baseline. Businesses often undercount in-house HR costs because they’re distributed across multiple budget lines and some of the work is absorbed by people who have other primary roles. If your office manager spends 15 hours a month on payroll and HR administration, that time has a real cost even if it’s not labeled “HR expense” in your P&L. For a structured approach to this comparison, see our guide on cost accounting methods for internal HR vs PEO expenses.
Set up your spreadsheet with rows for each cost category and columns for each projection year. You should end up with one table per scenario: Provider A, Provider B, and In-House Baseline.
Step 4: Quantify the Non-Fee Value Offsets
PEOs don’t just cost money — they’re supposed to save it in specific, quantifiable ways. The NPV model needs to capture those savings as negative costs (offsets) against the fee structure. But this is also where models get polluted with wishful thinking, so the rule here is conservative or nothing.
Compliance risk reduction: Don’t invent a dollar value for “peace of mind.” Instead, identify specific compliance exposures your business actually faces — multi-state payroll tax administration, ACA reporting requirements, OSHA recordkeeping, state-specific leave law compliance — and estimate the cost of managing each one without a PEO. That might mean a compliance consultant retainer, additional HR software, or staff time. Those are real, quantifiable costs that a PEO eliminates or reduces.
HR time savings: Calculate the hours your team currently spends on benefits administration, onboarding paperwork, payroll processing, and employee inquiries. Multiply by the fully loaded hourly cost of the people doing that work (salary plus benefits plus payroll taxes). That’s a real savings figure you can put in the model. Our guide on PEO operational efficiency savings provides frameworks for quantifying these time reductions without guessing.
Insurance access value: This is often the most significant offset and the most defensible. If a PEO gives you access to large-group health plan rates that you couldn’t negotiate independently as a 30-person company, the premium differential is a concrete, quantifiable number. Get a standalone health insurance quote for your group and compare it to what the PEO is offering. The gap is your offset.
Workers’ comp access: Similarly, some PEOs offer workers’ comp rates through their master policy that are lower than what a small employer can get independently, particularly in high-risk classifications. If that’s true for your business, it belongs in the model.
What doesn’t belong in the model: vague benefits like “improved employee experience,” “better recruiting outcomes,” or “reduced HR stress.” These may be real, but if you can’t attach a specific dollar amount or time savings to them, leave them out of the NPV calculation and note them qualitatively in your stakeholder presentation. Polluting a financial model with unquantified soft benefits undermines the whole exercise.
Step 5: Apply the NPV Formula and Compare Scenarios
With your annual cash flows built out for each scenario, you’re ready to run the actual NPV calculation. Here’s how it works in practice.
For each year in your projection, you have a net cash flow: total PEO costs minus value offsets. To discount that to present value, divide it by (1 + discount rate) raised to the power of the year number. Year 1 costs are divided by (1 + r)^1, Year 2 costs by (1 + r)^2, and so on. Sum all the discounted annual values and you have the NPV for that scenario.
In a spreadsheet, set it up like this:
Rows: Each cost category from your taxonomy, followed by a “Total Annual Cost” row, then a “Value Offsets” row, then a “Net Annual Cash Flow” row, then a “Discounted Cash Flow” row.
Columns: Year 0 (implementation costs, if any), Year 1 through Year N (your projection horizon).
Final row: Sum of all discounted cash flows = NPV for that scenario.
Run this for Provider A, Provider B, and your In-House Baseline. The scenario with the lowest NPV represents the lowest total cost in present-value terms over your projection horizon. That’s your financially optimal choice, before accounting for qualitative factors. If you want to validate your approach against a broader ROI framework, our step-by-step PEO ROI guide covers complementary methods for measuring PEO value.
Now run sensitivity analysis. This is where the model earns its keep.
Toggle your discount rate up and down by two percentage points and see if the provider ranking changes. Adjust your headcount growth assumption — what if you grow faster than expected, or slower? Change your health insurance escalation rate from conservative to aggressive. What happens to workers’ comp premiums if your mod rate worsens? Our guide on PEO mod rate forecasting can help you build more realistic workers’ comp scenarios.
What you’re looking for: which provider wins across the most scenarios? If Provider A has the lowest NPV in 8 out of 10 sensitivity scenarios, that’s a strong signal. If the ranking flips depending on which assumptions you use, you have a genuinely close decision and the qualitative factors matter more.
One practical note on spreadsheet setup: use a single input cell for your discount rate and reference it throughout the model, rather than hardcoding the rate into each formula. That way, sensitivity testing takes five seconds instead of twenty minutes of formula editing.
Step 6: Stress-Test for Switching Costs and Contract Lock-In Risk
This step changes the outcome more often than people expect. A PEO that looks cheaper on a straight cost comparison can become significantly more expensive when you factor in what it costs to leave.
Start by pulling the termination and transition language from each contract. Look for:
Termination fees: Some contracts include flat termination fees or require notice periods of 60-90 days during which you’re still paying. Others have early termination penalties that scale based on remaining contract term.
Data migration costs: Extracting your employee records, payroll history, and benefits data from a PEO’s platform takes real time and sometimes real money. If the PEO uses a proprietary HRIS, confirm what data export options exist and whether there are fees.
Benefits continuity gaps: Transitioning employees off a PEO’s health plan mid-year creates coverage gaps and administrative complexity. Depending on timing, this can mean COBRA obligations, enrollment gaps, or a rushed mid-year benefits transition.
Internal labor costs: The actual work of transitioning off a PEO — communicating changes to employees, setting up new systems, re-establishing standalone payroll and benefits — takes significant staff time. Estimate it honestly. Our comprehensive PEO exit and cancellation guide details every cost category you should account for when modeling a transition.
Model the exit scenario for each provider at Year 2 and Year 3. If you needed to leave at that point — because the relationship isn’t working, because you’re acquiring another company, because the PEO is acquired and the service degrades — what would it actually cost? Add that as a conditional cash flow in your model.
Also treat implementation costs as a Year 0 cash flow. Onboarding fees, system setup time, the internal labor cost of transitioning employees to a new platform, and any parallel-run payroll costs during the transition period are real costs that belong in the model. They’re easy to ignore because they’re one-time, but they affect the NPV calculation, particularly in a shorter projection window.
The practical insight here: a PEO with slightly higher annual costs but clean contract terms, no termination fees, and a straightforward data export process often has a better risk-adjusted NPV than the cheapest quote with aggressive lock-in provisions. Cheap annual fees don’t mean much if you’re trapped in a contract that’s expensive to exit.
Putting Your NPV Results to Work
Once the model is built, the last step is using it well — which means presenting it clearly and keeping it in its proper role as a decision-support tool, not a decision-maker.
When presenting to stakeholders, lead with the total present-value cost comparison across scenarios. Then show the sensitivity ranges so people understand how confident you are in the result. Then note the qualitative factors the model doesn’t capture: service quality differences, provider financial stability, cultural fit, and implementation track record. NPV tells you the financial picture. It doesn’t tell you whether a PEO’s support team actually picks up the phone.
Before you finalize the model, run through this checklist:
Cost categories: All direct and indirect costs mapped for every provider, using a standardized taxonomy.
Discount rate: Justified and documented. Sensitivity tested at ±2%.
Escalation assumptions: Sourced from contract language where possible, not assumed from generic inflation rates.
Value offsets: Conservatively estimated and tied to specific dollar amounts or time savings — no soft benefits included.
In-house baseline: Included as a comparison scenario with fully loaded HR costs.
Switching costs: Modeled for exit at Year 2 and Year 3 for each provider.
Sensitivity analysis: Run across discount rate, headcount, and insurance escalation variables.
The model is only as good as the data going into it. If your PEO quotes are missing variable cost information, or the contracts have ambiguous escalation language, flag those gaps explicitly rather than filling them with optimistic assumptions.
Getting the underlying data right is where most businesses run into trouble. If you want a cleaner starting point — with side-by-side provider comparisons that surface the fee structures, contract terms, and pricing details you need to populate this model accurately — don’t auto-renew. Make an informed, confident decision.
