Free Excel templates

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

Enter your exams per day, payer mix, fees, capture rate, eyeglass sales, contact lenses, cost of goods, doctor pay and fixed costs, and read revenue per patient, the optical's margin, the encounters a month that cover the fixed costs and what ten more points of capture are worth.

With the worked case's inputs, the practice brings in $254.10 per patient seen, its optical keeps a gross margin of 54.3%, it needs 363 encounters a month to cover $65,568 of fixed costs, and ten more points of capture would add $77,961 a year before staff pay.

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 129 free models.

Optometry_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 Optometry 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 130 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
Exams per day, clinic days, payer mix, fees by payer, capture rates, eyeglass sales, contact lenses, cost of goods, card fees, doctor pay and monthly fixed costs.
Calculator
Revenue per patient seen, optical gross margin, contribution per encounter, fixed costs, break-even encounters a month before and after loan payments, and ten more points of capture.
Checks
Volumes filled, shares and rates between 0 and 100 percent, fees and sales above zero, contribution positive, no negative fixed cost.

What the worked case returns

MeasureValue
Encounters a month544
Revenue a month$138,228
Revenue per patient seen$254.10
Optical sales a month$75,961
Optical gross margin54.3%
Contribution per encounter$180.70
Fixed costs a month$65,568
Break-even encounters a month363
Break-even after the loan payments entered363
Ten more points of capture, contribution a year$77,961

The figures come from a fictional practice and are teaching assumptions, not benchmarks. The break-even is before depreciation, interest and loan payments; a separate line adds the loan and lease payments you enter (with the worked case's $15,010 a month on its first site, 446 encounters instead of 363), and the capture effect is before the pay of any extra optician the added eyeglass jobs might need.

How to use it on your own case

  1. Type your exams per day per optometrist, clinic days a month and the employed optometrists' days on Inputs.
  2. Type your payer mix, exam fees by payer, revenue per medical visit, capture rates, eyeglass sales and contact lens figures.
  3. Type your cost of goods rates, card fee rate, doctor pay and monthly fixed costs line by line, then your loan payments on their own line.
  4. Read revenue per patient, optical gross margin, break-even and the capture effect on Calculator; keep every check at OK.

Questions people ask about it

How much revenue per patient does an optometry practice make?

It depends on the payer mix, the exam fees, the medical share of encounters and how many patients buy eyeglasses and contact lenses in the office. In the worked case it is $254.10 per patient seen; the calculator rebuilds it from your own inputs.

What is a good optical gross margin?

There is no single norm: it follows the payer mix, the frames and lenses sold, the laboratory and the remakes. The calculator measures yours as optical sales less their cost of goods, over optical sales.

How many patients a month does an optometry practice need to break even?

Fixed costs a month divided by the contribution per encounter, rounded up. Staff on salary and the base pay of employed optometrists belong in the fixed costs; cost of goods (laboratory included), card fees and a percentage of production are variable. That break-even leaves out loan payments: in the worked case it is 363 encounters a month, and 446 once the first site's $15,010 of monthly loan payments are added.

What are ten more points of capture worth?

The added eyeglass jobs, per payer, times the sale, less cost of goods and card fees: $77,961 a year in the worked case, before the pay of any extra optician.

Go further

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