# The Surgery Center Owner: companion files

Julian R. Sterling

## What is here

- **SurgeryCenter_1_Cases_Revenue.xlsx** (Chapters 5, 7 and 8; Workbook 1 of Appendix A): tabs Inputs, Cases, Revenue, Checks. From rooms and operating days to cases scheduled (468.8 a month) and performed (445.3), and from each payer's allowed facility fee to $2,349.82 allowed per performed case at the payer mix, $2,279.33 of net revenue per performed case, $1,015,013 a month and a gross collection rate of 42.8 percent.
- **SurgeryCenter_2_CaseMix_RoomTime.xlsx** (Chapters 5 and 9; Workbook 2 of Appendix A): tabs Inputs, Mix, RoomTime, Checks. The mix of six specialties: 46.60 minutes in the room per case, room utilization of 73.2 percent, $654.40 of supplies and implants per case, and what each specialty leaves per room hour at traditional Medicare's rate.
- **SurgeryCenter_3_BreakEven.xlsx** (Chapter 11; Workbook 3 of Appendix A): tabs Inputs, Case, BreakEven, Checks. The performed case against the center's $277,538 of fixed costs a month: $1,342.88 of contribution per performed case, 207 cases a month to break even (3.31 per room per day), 253 after debt service (4.05), and $1,007,160 a year for one more case per room per day.
- **SurgeryCenter_4_Syndication.xlsx** (Chapter 14; Workbook 4 of Appendix A): tabs Inputs, NewUnits, Buyout, Checks. A unit for a new physician at $6,570.89 after both discounts ($657,089 paid to the center), a founding holder diluted from 12.0 to 10.9 percent, and the operating agreement's buyout at $6,016.33 a unit.
- **SurgeryCenter_5_FourthRoom.xlsx** (Chapter 15; Workbook 5 of Appendix A): tabs Inputs, Room, Checks. A fourth room: $1,100,000 of investment, 1,187.5 cases performed a year, $1,020,350 of EBITDA added a year and a simple payback of 1.1 years.
- **SurgeryCenter_6_DeNovo.xlsx** (Chapter 13; Workbook 6 of Appendix A): tabs Inputs, Budget, Checks. The de novo budget: project $7,600,000, equity $3,000,000, bank debt $4,600,000 (60.5 percent of the project), debt service $61,536 a month and coverage of 4.86 times in FY2026.
- **SurgeryCenter_7_Offer.xlsx** (Chapter 16; Workbook 7 of Appendix A): tabs Inputs, Bridge, AfterSale, Checks. The operator's letter from EBITDA to adjusted EBITDA ($3,546,929), enterprise value ($24,828,503), the price of the units sold ($12,612,780) and the cash at closing ($11,832,141 before taxes, $19,333.56 per unit sold), then what the buyer's fee does after the sale.
- **Surgery_Center_Owner_Toolkit.docx**: the 6 check-lists of Appendix B, editable, with a box to tick before each item (The monthly numbers; Medicare's payment rules, scope kept; The payer contracts file; Compliance for physician owners; New members and departing members; Reading a letter of intent).
- The free Surgery Center Case Volume and Break-Even Calculator (the cells of workbook 3 on their own: net revenue and contribution per performed case, the break-even in cases a month and per room per day, before and after debt service, and one more case per room per day) is offered on the book's page, against an e-mail address.

## How to use the workbooks

Every workbook opens on its Inputs tab: blue type on a light blue background is an input, and nothing else is typed by hand. Each input carries a short cell name, its label (the label Appendix A uses) and its unit. Cell A1 of every tab says in one sentence what the tab does. The calculation tabs are read top to bottom, one result per line, each with its cell name and label. The Checks tab tests one condition per line and reads OK or CHECK; a single CHECK means the outputs are not to be used until the input behind it is fixed. The last line of the Checks tab only sums them up.

Each rate has its own base: the cancellation and reschedule rate is taken on cases scheduled, the payer mix on cases performed, the net collection rate on the allowed amount, the gross collection rate on gross charges, the management fee on net revenue. Shares are percentage cells: type 5% (or 0.05), never 5. The only functions are ROUND, ROUNDUP, MIN, MAX, IF and AND; no cell holds a date and no payment function is used: where a loan enters, the bank's quoted payment is an input. An empty cell reads as zero: fill every cell, even with a zero you chose. Every workbook counts the center's facility revenue only: no surgeon's or anesthesiologist's professional fee is in any cell. The last section of Appendix A lists the wrong inputs the checks do not catch.

To use a workbook on your own center, start with a copy, replace every blue input from the record that owns each figure (the schedule, the payer contracts and remittances, payroll, the lease, the bank's quote, the operating agreement, the statements, a letter of intent), keep every check at OK, and compare a result only with the same center's own earlier months. Never edit a formula to turn a CHECK into OK.

The workbooks are separate files with no link between them: a figure two workbooks share (net revenue per performed case by payer from workbook 1 into workbook 3, the contribution per performed case from workbook 3 into workbook 5) is typed again where it is used.

## A word of caution

Sablecrest Surgery Center, LLC, Quenthorpe Surgical Management, Tarnwellow Bank, Ostmere Ridge Properties, the members, the payers, the operator and every party in the case are fictional. Cases, cancellation rates, minutes, payer mix, charges, allowed amounts, collection rates, supplies and implants, wages, rents, loans, unit prices, discounts, distributions, escrows, multiples and fees are teaching assumptions, not market norms, benchmarks or recommendations, and nothing in the files is a clinical, coding or billing guide. Ownership, licensure, certificates of need, the operating agreement and payer contracts are for counsel in the center's state; coverage is for the Medicare contractor and the plans; taxes are for the outside CPA. The files are provided as they are, without warranty of any kind.
