All posts
Underwriting

Diligence for Multi-Location Platforms: What to Model Pre-Close

Most pre-close models over-invest in top-line growth assumptions and under-invest in branch-level variance, covenant stress-tests, and working-capital rhythm. Here is what to model instead.

aziell.com — Plan · Driver treeREVENUE$4.82MCAPACITY38 chairs × 260 daysOwner: Ops leadUTILIZATION72% chair-hr fillOwner: Ops leadAVG TICKET$248 per visitOwner: Ops leadChairs38Op days260Booked hr68%No-show4%Service mix7 linesDiscount−2.1%

Illustration of the Aziell product surface referenced throughout this article.

After thirty-plus pre-close diligence engagements on multi-location service platforms — dental DSOs, HVAC roll-ups, childcare academies, fitness — I can tell you the predictive difference between the deals that worked and the deals that didn’t isn’t top-line growth assumptions. It’s how well the model treats branch-level heterogeneity, the second derivative of performance most funds underweight because it’s easier to build a top-down growth number than to understand why branch 7 under-earns branch 3 by 400 bps.

A good pre-close model for a multi-location platform answers four questions honestly. Most models answer one well and the rest poorly. Here are all four.

Question 1: Is the top quartile the real operating benchmark, or an outlier?

Every multi-location target has at least one branch that makes the group look great. The question is whether that branch is a reproducible operating model or a local anomaly — a flagship with a charismatic GM, a grandfathered lease, or a market position that doesn’t replicate.

The test: segment the top-quartile branch performance by variables you can control (service mix, labor composition, pricing structure) and by variables you can’t (market size, demographics, lease economics). If the top-quartile performance is dominated by controllable drivers, it’s a real benchmark. If it’s dominated by uncontrollables, your thesis that the bottom quartile can converge to it is weaker than the deck implies.

aziell.com — Plan · Driver treeREVENUE$4.82MCAPACITY38 chairs × 260 daysOwner: Ops leadUTILIZATION72% chair-hr fillOwner: Ops leadAVG TICKET$248 per visitOwner: Ops leadChairs38Op days260Booked hr68%No-show4%Service mix7 linesDiscount−2.1%
The driver tree the diligence model should decompose every branch through. Convergence thesis only works when the gaps are in controllable sub-drivers, not in the structural ones.Aziell

Question 2: How brittle is the labor model?

In service platforms, labor is 50–75% of cost. Diligence models that express labor as a flat % of revenue miss the variability that actually drives misses post-close. The right expression: labor as step-function against utilization, with explicit handling of overtime thresholds and benefit-load curves.

Three specific tests:

  • Overtime sensitivity. What happens to EBITDA if overtime rises from current 4% to 7% of base? (Answer: at typical prime-cost ratios, roughly −250 bps of EBITDA margin.)
  • Step thresholds. Where in the utilization curve does the model add a new FTE? The deal-case assumes utilization rises 300 bps; does that trip any step-cost thresholds?
  • Wage inflation. What’s the model’s wage escalator? If your market is tight, 2.5% isn’t the right number — 4–5% is.

Question 3: Do the covenants survive the downside scenario?

Most platform acquisitions are lendered with senior debt at 3.5× to 4.5× EBITDA with a DSCR covenant at 1.20 to 1.35 and a leverage covenant stepping down annually. Your model probably shows comfortable compliance in the base case. That’s not the question.

The question is: in a downside where revenue drops 12% and labor inflation runs 4.5%, does DSCR hold above the covenant floor? What about minimum liquidity? What about the step-down covenant in year two?

If the answer is “no” in any downside scenario with plausible probability, you need either different debt structuring pre-close (looser covenants, larger cushion) or different cushion in the model.

60 bps
Average covenant cushion in deals that later needed waivers
Across the 30+ platforms our contributor network has reviewed post-hoc, the deals that breached covenants in years 2–3 had DSCR cushions averaging 60 bps at close. The deals that never breached averaged 180 bps. Cushion is underwriting, not slack.

Question 4: What’s the working-capital rhythm you’re inheriting?

Multi-location service platforms usually have some form of unearned-revenue mechanic (memberships, deposits, prepaid services) that makes the GAAP EBITDA look better than the cash EBITDA in a growth period and worse in a shrink period. Diligence models that treat GAAP EBITDA as distributable cash will consistently over-estimate post-close cash flow.

Three adjustments that matter:

  • Unearned revenue reversal. If growth stalls, the deferred revenue balance stops growing — EBITDA flattens and cash flattens harder.
  • AR aging. If the platform has grown rapidly, AR has grown with it. What happens to cash if you normalize AR days back to the pre-growth rate? For many platforms, $300k–$800k of one-time cash release.
  • Cap-ex catch-up. Has the platform under-invested in maintenance cap-ex during the growth period? If so, budget for a catch-up in year one, which the lender won’t.

How Aziell supports diligence work

While Aziell is primarily a post-close operating platform, we have a diligence mode where a target’s books can be imported into the driver-based model in a read-only sandbox. This lets you segment branch-level performance the way a post-close operator would, stress the labor model, and run downside scenarios against real covenants. The value is less the diligence artifact itself (your QofE provider delivers that) and more the continuity — the same driver model you use to evaluate the target pre-close becomes the operating plan post-close, with no rebuild.

For the full post-close operating framework, see value creation plans that actually move EBITDA.

The pattern across the losers

Every platform deal our desk has seen go sideways within two years traced back to one of these four questions being answered wishfully at close. Top quartile turned out to be a flagship. The labor model was too variable. The covenant cushion was 60 bps. The working-capital rhythm inverted. Any one of these is survivable; two together usually is not.

Ninety minutes spent hardening the pre-close model against these four questions is the single highest-leverage diligence activity a fund can do on a multi-location platform.

Written by
Aziell CFO Desk
Fractional-CFO contributor group

The Aziell CFO Desk is a collective byline for posts covering driver-based planning, capital-stack optimization, and operating-level scenario work. Posts under this byline draw on the day-to-day practice of fractional CFOs serving multi-location operators; every post is reviewed by at least one practicing CFO and one member of Aziell's product team before it ships. Individual contributor names appear on posts they specifically authored when that contributor is a public voice.

Driver-based planningDebt structuring + refinancingScenario modelingMulti-location P&L
More posts by Aziell

See the math run on your own books.

Connect QuickBooks, map your branches, and let the CFO Copilot surface your first recommendation set overnight.

Up next
Product how-to·8 min read·April 10, 2026

From Books to Board Pack in 30 Minutes: Getting Started with Aziell

The fastest way to understand Aziell is to stand one up. Here is the full setup path — connect QuickBooks, map your branches, import your COA, build a driver-based plan, and export your first board pack — in under 30 minutes.

Aziell Product DeskRead next
aziell.com — Onboarding · 5 steps≈ 30 minutes total1Connect QuickBooksOAuth · 24mo history~5 MIN2Map branchesLocation → branch~5 MIN3Review COAAuto-classified~5 MIN4Build planDriver-based~5 MIN5Export board packPDF · branded~5 MINNEXT MORNINGCFO Copilot surfaces your first recommendation set — $212k of annual EBITDA opportunity.

More to read

All posts
aziell.com — DashboardQ2 2026EBITDA$1.84M+12.4%PRIME COST58.6%-180 bpsLEASE COV.11.2×+0.4×DSCR1.42MONTHLY EBITDA · 12MCFO COPILOTRefinance SBASave $32k/yrRaise Tier-2 priceSave $120k/yrShift consolid.Save $48k/yrSee math
Platform overview · 9 min

What is Aziell? A Prescriptive FP&A Platform for Multi-Location Operators

Most finance tools describe your P&L. Aziell prescribes what to do about it — and quantifies every recommendation in enterprise-value dollars. Here is what the platform is, who it is for, and why it exists.

aziell.com — Budget_FINAL_v7.xlsxlast edited 23 days agoBranch 1Branch 2Branch 3Branch 4CONSOLBranch 7 v2 USEOLD_DO_NOTAccountJanFebMarAprMayJunRevenue$10k$11k$12k$13k$14k$15kCOGS$13k$14k$15k$16k$17k$18kLabor$16k$17k$18k#REF!$20k$21kRent$19k$20k$21k$22k$23k$24kUtil.$22k$23k$24k$25k$26k$27kSupplies$25k$26k$27k$28k$29k$30kMktg$28k$29k$30k$31k$32k$33kMgmt$31k$32k$33k$34k$35k$36kOther$34k$35k$36k$37k$38k$39kWhich one is right??Ops has $42k gap onBranch 7 — CFO filesays $38k. Third copyin Google Drive says$46k. HELP.
FP&A strategy · 10 min

The Hidden Cost of Spreadsheet Budgeting for Multi-Location Businesses

Your budget workbook looks cheap. It isn’t. Between version drift, formula errors, and stale actuals, most multi-location operators burn a mid-five-figure sum every year keeping a spreadsheet alive.

aziell.com — Plan · Driver treeREVENUE$4.82MCAPACITY38 chairs × 260 daysOwner: Ops leadUTILIZATION72% chair-hr fillOwner: Ops leadAVG TICKET$248 per visitOwner: Ops leadChairs38Op days260Booked hr68%No-show4%Service mix7 linesDiscount−2.1%
Planning · 12 min

Driver-Based Budgeting for Service Businesses: A Complete Framework

Driver-based budgeting replaces guesswork with math. Here is the complete framework we use with multi-location service operators, from picking the three drivers that actually matter to keeping the model honest.