Free Excel templates

A free speech therapy practice break-even calculator in Excel

Your clinicians and their schedules, cancellations, payer mix and net rates, clinician cost and fixed costs. The margin per session, the margin a month and the break-even in sessions a week, every step shown.

A practice with three speech-language pathologists and one clinical fellow schedules 132 sessions a week and loses 10 percent of them to cancellations. Each rendered session nets $93.20 and leaves $25.41 once the clinicians are paid. Against $11,500 of fixed costs a month, that is $574.83 of margin a month, just above a break-even of 113.1 rendered sessions a week. Five more points of cancellation would turn it into a loss of $1,838.13 a month. The calculator lays it out, ready for your own figures.

Get the calculator

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

Speech_Therapy_Practice_Calculator.xlsx (8 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 calculator

This calculator uses the same cells as Workbook 3 of The Speech Therapy Practice Owner, which follows one pediatric practice through two fiscal years: sessions at five levels, six sources of payment, authorizations, cancellations, a clinical fellow, home visits and teletherapy, a school contract, a second site and its loan, and what the practice is worth.

Paperback PDF edition, $19.99

What is in the file

Three tabs. Inputs are blue; everything else is a formula; the Checks tab adds up the controls that fail.

1. Inputs
Clinicians (speech-language pathologists and clinical fellows), sessions scheduled a week for each, the cancellation rate, the payer mix in three groups (Medicaid plans, commercial plans, families paying directly), the net rate of each group and the share of billed dollars it never pays, the loaded cost per paid hour, paid hours a week, the length of a session, open weeks a year, the variable cost per session and fixed costs a month.
2. Calc
Scheduled and rendered sessions, net revenue and clinician cost per rendered session, the margin per session and a month, the break-even in rendered and scheduled sessions a week, and the same month with five more points of cancellation.
3. Checks
Payer mix adding up to 100 percent, a cancellation rate between 0 and 1, sessions that fit in the paid hours, the break-even reinjected to the cent, and no negative rate or cost.

What the worked example returns

MeasureExample
Scheduled sessions a week132
Rendered sessions a week118.8
Net revenue per rendered session$93.20
Clinician cost per rendered session$65.99
Margin per rendered session$25.41
Net revenue a month$44,288.64
Margin a month after fixed costs$574.83
Break-even, rendered sessions a week113.1
Break-even, scheduled sessions a week at this cancellation rate125.7
Margin a month with 5 more points of cancellation-$1,838.13
Effect of 5 more points of cancellation-$2,412.96

The example practice is fictional and separate from the book's case: 3 speech-language pathologists scheduled for 34 sessions a week and 1 clinical fellow for 30; 10 percent cancellations; a payer mix of 45 percent Medicaid plans at $70.00, 40 percent commercial plans at $110.00 and 15 percent families paying directly at $136.00, with 3 percent and 4 percent of the plans' billed dollars never collected; a loaded cost of $52.00 an hour for each speech-language pathologist and $40.00 for the fellow, 40 paid hours a week, 45-minute sessions, 48 open weeks; $1.80 of variable cost per session and $11,500 of fixed costs a month. Every input is a teaching assumption.

How to use it on your own practice

  1. Enter the sessions each clinician is scheduled for, not the sessions rendered: the calculator applies your cancellation rate.
  2. Set the payer mix on scheduled sessions and the net rate of each group from your contracts and your own price.
  3. Use each clinician's fully loaded cost per paid hour: wages for every paid hour, payroll taxes and benefits.
  4. Read the Checks tab before any figure: a count above zero means a cell to fix.

Education only, not legal, billing or financial advice: your payers' contracts and your own books govern, and your advisers decide.

Questions people ask

What does the break-even calculator do?

From your clinicians, the sessions each is scheduled for a week, your cancellation rate, payer mix, net rates, the share of billed dollars never collected, the clinicians' loaded cost and your fixed costs, it computes the net revenue and margin per rendered session, the margin a month, the break-even in rendered and in scheduled sessions a week, and what five more points of cancellation would cost a month.

Which break-even does it compute?

The book's one definition, in its simplest form: the rendered sessions a week at which each session's contribution (net revenue minus the pay of the clinicians other than a salaried owner and the variable costs, per rendered session) covers the month's fixed costs, the owner's pay included. It is a break-even of EBITDA, not of cash: loan payments are not in it.

What does it leave out?

Authorizations, denials month by month, recoveries, a school contract, travel between homes, a clinical fellow's supervision hours and loan payments. The book's five workbooks cover them on one practice.

Can I rely on it for a business plan?

Use it for a first pass and to learn the mechanics. Your rates come from your payers' contracts and your costs from your own books, and the conclusions belong to you and your advisers.

Is this calculator really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The five free workbooks of The Speech Therapy Practice Owner go further: sessions at five levels with authorizations, denials and recoveries; a clinician's productivity and margin per paid hour with travel between homes; a second site and its SBA loan; SDE, adjusted EBITDA and cash at closing.

See the book and its free files →

Related reading