FP&A & Financial Modeling

A plan, not a wish with formatting.

Most financial projections for treatment centers are built on the quiet assumption that every claim pays in full, on time. That projection isn’t a plan. Revenue Logic builds the other kind — from what your payers actually pay, when they pay it, and what it costs you to keep the doors open while you wait.

• We've built 24-month, bottoms-up operating models for treatment centers — bed-level revenue, payroll by role, opex line by line, aging-bucket cash, bad-debt reality.

A wish with formatting 

Somebody hands you a financial projection for your facility. Beautiful spreadsheet. Revenue line goes up and to the right. And it’s built on the quiet assumption that every claim pays in full, on time — which is the one thing that has never once happened in behavioral health. That projection isn’t a plan. It’s a wish with formatting.

A real operating model starts somewhere else: with what your payers actually pay, when they pay it, and what it costs you to keep the doors open while you wait. That’s the gap between a finance consultant’s spreadsheet and a model built by people who’ve watched the cash come in, EOB by EOB. We build the second kind.

Most RCM firms stop at the billing report. We go further — because the same data discipline that produces clean posting also produces something a CFO can plan against. If we already know your collection percentages, your aging buckets, and your payer mix down to the level of care, we have the honest inputs that make a financial model true instead of optimistic.

Wrong inputs, wrong timing

Why do standard financial projections fail treatment centers? 

Three compounding errors

Because they’re built by people who don’t live in the reimbursement. A general FP&A consultant models revenue off billed charges or a flat collection assumption, and both are wrong for behavioral health in ways that compound across 24 months. Net allowed on out-of-network behavioral health claims can land around 24% of gross. If your model assumed 60%, every downstream number — payroll headroom, financing capacity, runway — is fiction.
Then there’s timing. Cash doesn’t arrive when you bill; it arrives across aging buckets, and the shape of that curve decides whether you make payroll in month four. A model that books revenue the month it’s billed is lying to you about your cash position by 30 to 90 days. And almost nobody bakes in bad debt — the slice that simply never collects, no matter how clean the claim. Leave it out and you’ve overstated annual cash by a full segment of your AR. The fixes aren’t exotic. They’re just specific to this industry, and you only know them if you’ve sat inside the billing.

From the field

“A finance consultant will model a treatment center at 100% collections because that’s what the spreadsheet defaults to. We model it at what the payers actually pay, aging bucket by aging bucket, because we’re the ones who watched the cash come in.”

Model anatomy

What does a Revenue Logic operating model actually contain?

We’ve built exactly this for a detox and residential client — a fully-linked, 24-month, bottoms-up operating model. Not a pitch deck. The artifact a treatment-center CFO uses to make real decisions.

Interactive — Month-1 operating model Based on a real detox / residential build
Licensed beds24
860
Census / occupancy70%
40%95%
Detox / residential mix50 / 50
All RTCAll detox
Net allowed (% of gross)24%
15%60%
  $0
Net allowed 24% of gross $0
Collectible 90% of net $0
Cash collected, month 1 $0
Where the cash actually lands
$0
0–30 · 25%
$0
30–60 · 60%
$0
60–90 · 5%
$0
Bad debt · 10%

Illustrative model using real client assumptions: billing rates $4,514/day detox and $4,128/day residential, net allowed ~24% of gross, ~90% collections on net allowed, aging spread 25% / 60% / 5% with 10% never collected. The full build links revenue to payroll, opex, and loan service across 24 months.

Interactive — Month-1 operating model Based on a real detox / residential build
Licensed beds24
860
Census / occupancy70%
40%95%
Detox / residential mix50 / 50
All RTCAll detox
Net allowed (% of gross)24%
15%60%
  $0
Net allowed 24% of gross $0
Collectible 90% of net $0
Cash collected, month 1 $0
Where the cash actually lands
$0
0–30 · 25%
$0
30–60 · 60%
$0
60–90 · 5%
$0
Bad debt · 10%

Illustrative model using real client assumptions: billing rates $4,514/day detox and $4,128/day residential, net allowed ~24% of gross, ~90% collections on net allowed, aging spread 25% / 60% / 5% with 10% never collected. The full build links revenue to payroll, opex, and loan service across 24 months.

Key Assumptions

Single source of truth: bed count, 50/50 detox-to-residential mix at 70% max usage, billing rates ($4,514/day detox, $4,128/day residential), net allowed ~24% of gross, collections ~90% of net allowed, plus loan terms and opex unit costs. Change one number and the whole model re-flows.

Revenue

Walks gross billed → net allowed → total collectible → cash collected. Spread across aging buckets: 25% in 0–30 days, 60% in 30–60, 5% in 60–90, 10% embedded bad debt never collected. This aging curve is the part generic projections skip. It traces back to our adjudicated-claims reimbursement benchmark.

Patients

Projects census by month, split detox vs. residential, on a growth curve.

Staffing

Maps every role — Medical Director, Clinical Director, therapists, case managers, BHT pool with named techs, compliance — and scales headcount with census. Payroll grows when the beds fill, not before.

Opex

Line by line: EMR platform, compliance software, groceries per patient, vehicles, insurance, pest control. No rolled-up categories.

Loan Service

Real debt service: $542,025.95 principal at 8.25%, $12,237.75/month.

Output

Month 1: ~$225,000 revenue, ~$51,000 net. 17 staff, scaling with census. 5% monthly growth target.

From the field

“We built a detox client a 24-month model down to the food delivery line. and the BHT pool that scales with census — and the number that made the CFO sit up wasn’t the revenue. It was the cash curve. Once you spread collections across the real aging buckets and bake in the 10% that never comes, the month you actually run tight jumps off the page.”

The bridge argument

How does RCM data make the model honest?

Inputs from the source

Because the inputs come from the same place the billing does. The collection percentage isn’t a guess — it’s what we watch adjudicate. The aging buckets aren’t a textbook default — they’re how this payer mix actually pays. The 24%-of-gross net allowed reflects real OON economics on residential and detox, not a number borrowed from a hospital model. PayerLenz gives the revenue assumptions a spine built from adjudicated claims, so the top line traces back to evidence instead of optimism. A finance-only firm doesn’t have the reimbursement reality. A billing-only firm doesn’t build the model. We do both — as part of our behavioral health revenue cycle management services.

Side by side

Generic financial projection vs.  Revenue Logic operating model.

Financial modeling element

Generic FP&A consultant

Revenue Logic operating model

Revenue basis

Billed charges or flat collection assumption

Net allowed from real adjudicated data (~24% of gross), PayerLenz-backed

Cash timing

Booked when billed

Spread across aging buckets (25% / 60% / 5%, 10% bad debt)

Staffing logic

Fixed headcount or generic ratio

Every role mapped; BHT pool scaled to monthly census

Opex detail

Rolled-up categories

Line by line — EMR, groceries per patient, vehicles, insurance, loan service

Bad debt

Usually omitted

Embedded 10% never-collected assumption

Built by

Finance generalists

RCM operators who live in the collection percentages

Financial Modeling Element Generic FP&A Consultant Revenue Logic Operating Model
Revenue Basis Billed charges or flat collection assumption Net allowed from real adjudicated data (~24% of gross), PayerLenz-backed
Cash Timing Booked when billed Spread across aging buckets (25% / 60% / 5%, 10% bad debt)
Staffing Logic Fixed headcount or generic ratio Every role mapped; BHT pool scaled to monthly census
Opex Detail Rolled-up categories Line by line — EMR, groceries per patient, vehicles, insurance, loan service
Bad Debt Usually omitted Embedded 10% never-collected assumption
Built By Finance generalists RCM operators who live in the collection percentages
From the field

“The same data discipline that produces clean posting also produces something a CFO can plan against. A finance-only firm doesn’t have the reimbursement reality; a billing-only firm doesn’t build the model. We do both — which is the whole point of an RCM-backed operating model.”

Investment triggers

When should a treatment center invest in a real FP&A model?

01

Before financing or taking on a loan — lenders want a cash curve, not a revenue wish.

02

Before a major hire or expansion — so payroll scales with census, not ahead of it.

03

When deciding bed mix — detox versus residential changes the economics materially.

04

When in-network versus OON decisions hinge on real collected dollars, not billed charges.

05

When the existing projection assumes collections that have never happened in your AR.

FAQ

Frequently asked questions.

How is this different from the financial projection my accountant already builds?

Most projections model revenue off billed charges or a flat collection rate, and they book cash the month it’s billed. Both are wrong for behavioral health. Our model starts from net allowed — around 24% of gross on OON work — spreads cash across real aging buckets, and bakes in the 10% that never collects. The difference is that we live in those numbers daily, so the model reflects what your payers actually do.

The model is strongest when we’re already running your billing, because then the collection percentages, aging buckets, and payer mix come straight from your adjudicated data instead of estimates. We can build off your historicals if we’re not your biller yet, but the FP&A and the RCM reinforce each other — clean posting feeds an honest model, and the model tells you where the billing is leaking.
Down to the line. Bed-level revenue split by detox and residential, payroll by individual role with the BHT pool scaling on census, opex itemized from the EMR subscription to groceries per patient to pest control, and loan service with real principal and rate. It’s the artifact a CFO uses to decide whether to hire, whether to finance, and how many beds the payer mix can support.

It’s the same logic. The model scales a client’s BHT pool with patient census, and we apply that exact ratio thinking to our own team against your bed count — we stay perpetually ratio’d to the volume we service. So the staffing discipline you see in the model is the discipline we run our own shop on.

A model that tells the truth.

If your current financial projection assumes collections you’ve never actually seen, it’s not a plan — it’s a hope. Bring us your real payer mix and AR, and we’ll build you the model that tells the truth: bed-level revenue, real aging-bucket cash, every opex line.