Free Excel templates

A free hearing care practice revenue per patient and break-even calculator in Excel

Enter your appointments, mix, conversion, hearing aid prices, fitting and follow-up fees, returns, unit cost, commission and fixed costs, and read revenue per fitted patient and per appointment, the hearing aid gross margin, the devices kept a month that cover the fixed costs and what five more points of conversion are worth.

With the worked case's inputs, the practice brings in $3,663.97 per fitted patient and $492.88 per appointment, its hearing aids keep a gross margin of 66.0%, it needs 39 devices kept a month to cover $57,405 of fixed costs, and five more points of conversion would add $129,532 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 147 free models.

Hearing_Care_Practice_Revenue_per_Patient_and_Break_Even_Calculator.xlsx (14 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 Audiology 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 148 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

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

Inputs
Appointments, clinic days, the diagnostic mix, conversion, binaural share, ways of selling, prices per device, fitting, follow-up and diagnostic fees, returns, unit cost, accessories, card fees, commission and monthly fixed costs.
Calculator
Revenue per fitted patient and per appointment, hearing aid gross margin, contribution per device kept, fixed costs, break-even devices kept a month before and after loan payments, and five more points of conversion.
Checks
Volumes filled, shares and rates between 0 and 1, the ways of selling adding up to 100 percent, unit cost below each price, contribution positive.

What the worked case returns

MeasureValue
Appointments a month320
Revenue a month$157,723
Revenue per fitted patient$3,663.97
Revenue per appointment$492.88
Hearing aid gross margin66.0%
Contribution per device kept$1,505.47
Fixed costs a month$57,405
Break-even devices kept a month39
Break-even after the loan payments entered39
Five more points of conversion, a year$129,532

The figures come from a fictional practice and are teaching assumptions, not benchmarks or a clinical guide. The break-even is before depreciation, interest and loan payments; a separate line adds the loan payments you enter (with the worked case's $13,873 a month on its first site, 48 devices kept instead of 39), and the effect of conversion is before any added staff pay. A hearing aid and the exam to fit it are never billed to Medicare, so the calculator has no cell for it.

How to use it on your own case

  1. Type your appointments per clinic day, clinic days a month and the share of diagnostic evaluations on Inputs.
  2. Type your conversion rate, binaural share, ways of selling and the prices per device, apart from the fitting, follow-up and diagnostic fees.
  3. Type your return rate and fee, unit cost, accessories, card fee rate, commission and monthly fixed costs, then your loan payments on their own line.
  4. Read revenue per fitted patient, the hearing aid gross margin, the break-even and the effect of conversion on Calculator; keep every check at OK.

Questions people ask about it

How much revenue does a hearing care practice make per patient?

It depends on the conversion rate, the binaural share, the mix of bundled, unbundled and third-party sales and the fees for services sold apart. In the worked case it is $3,663.97 per fitted patient and $492.88 per appointment; the calculator rebuilds both from your own inputs.

What is a hearing aid gross margin?

Hearing aid revenue after trial returns, less the unit cost of the devices kept and the return fees, over hearing aid revenue. There is no single norm: it follows the prices, the mix and the unit cost the manufacturer charges.

How many hearing aids a month does a practice need to break even?

Fixed costs a month divided by what one device kept leaves after its variable costs, rounded up. That break-even leaves out loan payments: in the worked case it is 39 devices kept a month, and 48 once the first site's $13,873 of monthly loan payments are added.

What are five more points of conversion worth?

The added fitted patients a year times what one fitted patient leaves after the devices' cost, accessories, card fees and the commission: $129,532 a year in the worked case, before any added staff pay.

Go further

The free workbooks of The Audiology 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 Audiology Practice Owner. See the book.