Free Excel templates

A free surgery center case volume and break-even calculator in Excel

Enter your rooms, operating days, cases scheduled, cancellations, payer mix, net revenue per case by payer, supplies and implants, variable pay, the management fee, the center's fixed costs and its debt service, and read net revenue and contribution per performed case, the break-even in cases a month and per room per day, and what one more case per room per day is worth.

With the worked case's inputs, each performed case brings in $2,279.33 of net revenue at the payer mix and leaves $1,342.88 after supplies and implants, variable pay and the management fee; the center needs 207 cases performed a month, 3.31 per room per day, to cover $277,538 of fixed costs, 253 once both loans' payments are added, and one more case per room per day would add $1,007,160 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 191 free models.

SurgeryCenter_Calculator.xlsx (13 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 Surgery Center 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 192 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
Rooms, operating days, cases scheduled, cancellation rate, payer mix, net revenue per case by payer, supplies and implants, variable pay, management fee, fixed costs and debt service.
Case
Cases performed a month, net revenue per performed case at the payer mix and contribution per performed case.
BreakEven
Fixed costs, break-even of EBITDA and after debt service a month and per room per day, one more case per room per day and EBITDA a month.
Checks
Payer mix, cancellation rate and management fee, contribution above zero and cases above the break-even after debt service.

What the worked case returns

MeasureValue
Cases performed a month445.3
Net revenue per performed case at the payer mix$2,279.33
Contribution per performed case$1,342.88
Fixed costs a month$277,538
Break-even of EBITDA, cases performed a month207
Break-even of EBITDA, cases per room per day3.31
Break-even after debt service, cases performed a month253
Break-even after debt service, cases per room per day4.05
One more case per room per day, a year$1,007,160
EBITDA a month at this volume$320,463

The figures come from a fictional center and are teaching assumptions, not benchmarks, coding advice or a clinical guide. The break-even is one of EBITDA (it leaves out depreciation, interest and loan payments) and counts the center's facility revenue only, never a surgeon's or anesthesiologist's professional fee; a separate line adds the monthly payments of the loans. Each rate has its own base: cancellations on cases scheduled, the payer mix on cases performed, net revenue per case as the allowed amount times the net collection rate, the management fee on net revenue.

How to use it on your own case

  1. Type your operating rooms, operating days a year, cases scheduled per room per day and the cancellation rate on Inputs.
  2. Type your payer mix in performed cases and the net revenue per performed case of each payer (allowed times the net collection rate).
  3. Type supplies and implants and variable pay with burden per case, the management fee, the eight fixed lines of a month, then the debt service.
  4. Read the case on Case and the break-even on BreakEven; keep every line of Checks at OK.

Questions people ask about it

How much does a surgery center make per case?

It depends on the payer mix, the facility fee each payer allows and the collection rate. In the worked case each performed case brings in $2,279.33 of net revenue; the calculator rebuilds it from your own inputs.

What is the contribution per case?

Net revenue per performed case less supplies and implants, variable nursing and technician pay with burden, and the management fee: $1,342.88 in the worked case. It is before fixed costs and debt service.

How many cases does a surgery center need to break even?

Fixed costs a month divided by the contribution per performed case, rounded up, then spread over the rooms and their operating days: 207 cases a month, 3.31 per room per day in the worked case, and 253 once the loans' payments are added.

What is one more case a day worth?

The contribution per performed case times the rooms and the operating days of a year: $1,007,160 in the worked case, before any added staff.

Go further

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