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.
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.
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.
Three tabs. Inputs are blue; everything else is a formula; the Checks tab adds up the controls that fail.
| Measure | Example |
|---|---|
| Scheduled sessions a week | 132 |
| Rendered sessions a week | 118.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 week | 113.1 |
| Break-even, scheduled sessions a week at this cancellation rate | 125.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.
Education only, not legal, billing or financial advice: your payers' contracts and your own books govern, and your advisers decide.
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.
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.
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.
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.
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
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.