Free Excel templates

A free ABA practice utilization, revenue per client and break-even calculator in Excel

Enter authorized hours, utilization, cancellations, rates per 15-minute unit, denials, the payer mix, RBT and BCBA pay, supervision and the center's fixed costs, and read net revenue and contribution per client, the margin per billed hour, the break-even in active clients and what five more points of utilization are worth.

With the worked case's inputs, one active client brings in $6,036.27 of net revenue a month at the payer mix and leaves $2,812.61 after RBT, BCBA and session costs, $35.46 per billed hour; the center needs 21 active clients to cover $57,435 of fixed costs a month, 28 once the purchase loan's payment is added, and five more points of utilization would add $85,114 a year.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 149 free models.

ABA_Practice_Calculator.xlsx (16 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with The ABA Therapy Practice Owner, which explains the method behind it, chapter by chapter.

Get the PDF edition → See the book

Want every model at once?

The Financial Model Library: all 150 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

4 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

Inputs
Authorized hours, weeks, utilization, cancellations, rates per unit, denial, recovery and family shares, payer mix, RBT and BCBA pay and supervision, active clients, fixed costs and the loan payment.
Client
Hours by level, net revenue by payer and at the mix, RBT and BCBA hours and cost, supervision, contribution and margin per billed hour.
BreakEven
Fixed costs, break-even of EBITDA and after debt service in active clients, the center's EBITDA and five more points of utilization.
Checks
Utilization, cancellations, payer mix, rates, denials, non-billable shares, paid hours, supervision, contribution and active clients.

What the worked case returns

MeasureValue
Authorized hours per client a month97.92
Rendered (billed) hours per client a month79.31
Net revenue per client a month at the payer mix$6,036.27
Direct costs per client a month$3,223.66
Contribution per client a month$2,812.61
Margin on direct costs per billed hour$35.46
Fixed costs a month$57,435
Break-even of EBITDA, active clients21
Break-even after debt service, active clients28
Five more points of utilization, a year$85,114

The figures come from a fictional practice and are teaching assumptions, not benchmarks or a clinical guide. Rates are typed per 15-minute unit; the break-even is one of EBITDA (it leaves out depreciation, interest and loan payments), and a separate line adds the purchase loan's monthly payment. The effect of utilization is before any added BCBA or RBT hire. Authorized hours are the BCBA's request and the payer's decision; the calculator only counts them.

How to use it on your own case

  1. Type one client's authorized hours a week by service, the weeks worked, utilization and the cancellation rate on Inputs.
  2. Type your rates per 15-minute unit by payer, the denial, recovery and family shares and the payer mix in active clients.
  3. Type RBT and BCBA pay, burden, non-billable shares, supervision, session materials, active clients and the nine fixed lines, then the loan payment.
  4. Read the client on Client and the break-even and utilization on BreakEven; keep every line of Checks at OK.

Questions people ask about it

How much does an ABA practice make per client?

It depends on the hours authorized and rendered, the rates per unit, denials and the payer mix. In the worked case one active client brings in $6,036.27 of net revenue a month and leaves $2,812.61 after direct costs; the calculator rebuilds both from your own inputs.

What is the margin per billed hour?

Net revenue less the RBT cost, the BCBA cost and session materials, divided by the hours billed: $35.46 in the worked case. It is before fixed costs and company overhead.

How many clients does an ABA center need to break even?

Fixed costs a month divided by the contribution of one client, rounded up: 21 active clients in the worked case, 28 once the purchase loan's payment is added.

What are five more points of utilization worth?

The contribution at the higher utilization less the contribution today, times the active clients and twelve months: $85,114 a year in the worked case, before any added hire.

Go further

The free workbooks of The ABA Therapy Practice Owner go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with The ABA Therapy Practice Owner. See the book.