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.
Julian R. Sterling · from The Surgery Center Owner
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)
This form needs JavaScript. Without it: join the reader list here , then open the downloads page .
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
Measure Value
Cases performed a month 445.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 month 207
Break-even of EBITDA, cases per room per day 3.31
Break-even after debt service, cases performed a month 253
Break-even after debt service, cases per room per day 4.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
Type your operating rooms, operating days a year, cases scheduled per room per day and the cancellation rate on Inputs.
Type your payer mix in performed cases and the net revenue per performed case of each payer (allowed times the net collection rate).
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.
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.
Other free templates
Cap table and exit waterfall SAFE, seed and Series A with pool top-ups, then who gets what at five exit values.
LBO model Sources and uses to sponsor IRR, twelve sheets, every figure checked.
Real estate property model Rent roll, cash flow, debt and returns for one asset, empty and ready to fill.
Residual land valuation Development appraisal with the four downside tests and peak debt.
DCF with terminal value Perpetuity growth and exit multiple side by side, with the TV share of value.
Distribution waterfall model Return of capital, pref, catch-up and carry, three catch-up readings, European vs deal-by-deal.
Loan sizing: LTV, LTC, DSCR, debt yield The four lender tests at once, the binding one, and a rate shock.
Direct lending credit model Unitranche underwriting: coverage, leverage, sweep, base, downside and stress.
Data center financial model Turnkey, powered shell and powered land on one campus, levered returns and delay.
13-week cash flow model Liquidity on paper against usable liquidity, a springing covenant and six levers.
Small business acquisition model (SBA loan) SBA 7(a) loan sized in closed form, lender coverage against cash coverage, exit returns.
3-statement financial model Five-year forecast feeding a DCF and an LBO on one case, with a blank build.
Project finance model Solar and storage project, debt sculpted to a 1.35x DSCR, no circularity.
REIT valuation model FFO, AFFO, NAV and the implied cap rate for one REIT, plus an empty template.
Self-storage financial model Cohort rent roll, break-even occupancy, ten-year hold and the bid for one store.
Tax lien certificate yield calculator Bid, minimum charge and redemption month turned into a real annual yield.
Sale and leaseback model Nine buildings, the price split five ways, rent cover on the entity that signs.
PME calculator Kaplan-Schoar PME, PME+, Direct Alpha, IRR and TVPI on one fund's cash flows.
Working capital peg model Five peg definitions, the completion-date effect, locked box against completion accounts.
JV waterfall and promote model Sponsor against capital partner: pref, IRR hurdles and the promote in a two-party JV.
Student housing model A 520-bed scheme from rate card to RevPAB, costs, capex cycle and exit value.
Net effective rent calculator Headline rent to net effective rent after rent-free and incentives, and back again.
VaR and expected shortfall model Parametric VaR and expected shortfall step by step, crisis correlations and a backtest.
Corporate liquidity model Minimum liquidity, revolver headroom and the covenant test that takes the revolver away.
Co-investment fee savings model What an LP co-investment programme saves in fees, its break-even loss rate and deal count.
Accretion and dilution model One deal, four EPS conventions, the twelve-line year-one bridge and the eight charges.
Budget vs actual variance analysis Budget vs actual variance analysis: one quarter against five comparators, with the spread.
Cap rate and exit yield calculator Six entry yields, the one comparable with the exit yield, the sale and the promote.
Comparable company analysis Trading comps and precedent deals, and the control premium turned into synergies.
Fulcrum security recovery model Recovery waterfall that names the fulcrum by arithmetic, across seven enterprise values.
Price volume mix analysis Price volume mix analysis: revenue and gross profit bridge, cross term, margin mix and price.
Private equity fund cash flow model Capital calls, distributions, J-curve, peak capital at work and the over-commitment ratio.
LP secondary pricing model LP interest priced at a discount to NAV: MOIC, IRR, discount against appreciation, stress.
Subscription line IRR calculator Same asset with and without a capital call facility: IRR uplift, multiple drag, cost per point.
Venture capital fund model Fees, carry under five conventions, the J-curve, and gross against net IRR for one fund.
Run-rate EBITDA bridge Reported to adjusted, pro forma and run-rate EBITDA, with the buyer's haircut on every line.
Bank stress test: PPNR, CET1 and MDA Nine quarters of PPNR, provisions and CET1 under base and adverse, against the MDA threshold.
Lease-adjusted leverage calculator EBITDAR, rent multiple and IFRS 16 lease debt, fixed charge cover, and a peer that owns its sites.
Solvency II SCR calculator The standard formula, simplified: modules, correlation matrices, Basic SCR and the ratio.
Implied cap rate calculator The cap rate a REIT share price pays for the buildings, against private market and NAV.
Dimson beta calculator Lagged market regression on smoothed fund returns, against the simple and unsmoothed beta.
Commercial real estate underwriting model Value-add multifamily underwriting, five sensitivities and the maximum bid solved in closed form.
Real estate DCF model Ten-year office DCF, quarter by quarter and lease by lease: the re-letting cycle priced in full.
Borrowing base calculator A borrowing base certificate run live off a 1,880-contract tape, and the advance rate set from stress.
Debt sculpting model A toll road's debt sculpted to a 1.25x DSCR, the binding year, the reserve, and the equity return three ways.
Black-Scholes and binomial option pricing One option priced three ways (closed form, lattice, simulation) and what eight points of volatility are worth.
Safety stock calculator Safety stock at every service level, fill rate solved by bisection, and the three policies priced in euros.
Mortgage note pricing model A non-performing note bid from its foreclosure floor, the workout paths, and an eight-loan tape priced loan by loan.
Forecast bias and accuracy calculator Forecast bias measured against its own noise, the error it removes, and the next forecast corrected.
LCR and NSFR calculator Liquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculator Standardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard model A points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysis List price to pocket price for one account and a whole company: nine leakages, ranked and added up.
Capital call and distribution template Investor register, capital call allocation, distribution and the capital account roll, reconciled.
Value creation bridge Entry equity to exit equity in six buckets with a zero residual, the cross-term and add-ons net of cash.
Aircraft lease model A sale-leaseback priced from the lease rate factor to levered IRR, the residual risk, and the lessor's P&L.
Ship finance model A ship loan with LTV covenants and release prices, a bareboat lease with options, a default, and the fund's waterfall.
Cell tower valuation model One tower with one, two and three tenants, a 1,200-tower portfolio, DCF, debt and returns.
Quality of earnings (QoE) template Reported to diligence-adjusted EBITDA, debt-like items, the NWC peg and the closing statement.
Bond price, DV01 and duration calculator Price, DV01 and modified duration for four Treasuries, roll-down, a DV01-neutral steepener and a hedged client trade.
LTV and CAC unit economics model Customer value by horizon under net revenue retention, the break-even CAC, and the cut test.
ABS, CLO and RMBS waterfall model Three securitisations, monthly or quarterly: auto ABS, a CLO under three default paths, and non-QM RMBS.
Partnership flip tax equity model A solar partnership flip: ITC and bonuses, the flip year, capital accounts, transfer, recapture and HLBV.
Battery storage (BESS) financial model A 200 MW / 800 MWh battery: degradation and augmentation, merchant revenue, three cases, debt and the ITC.
Population stability index (PSI) calculator PSI on fixed score bands from development to out of time, and the applicants a model never saw.
Early payment discount calculator 2/10 net 60 as an annual rate, the cash conversion cycle, supply chain finance and a cash pool.
Discount break-even calculator Volume needed to break even on a price cut, volume a rise can lose, the rebate cliff and payment terms.
NAV facility LTV model Eligible NAV, loan to value, a downside, and the second decline that the first ratio hides.
Reserve-based lending (RBL) model An RBL borrowing base from three reserve reports, the bank price deck, hedges and a deficiency cure.
IPO pricing model An IPO from shares and greenshoe to the discount, the book, the first day and a later block.
Mortgage DTI and underwriting calculator Qualifying income, PITI, housing and debt-to-income ratios, funds to close, the appraisal and FHA and VA files.
Care home valuation model A 70-bed care home from admissions and length of stay to EBITDARM, rent cover and value.
Venture debt model A two-tranche venture loan with fees and warrants, runway, the realized IRR, a recovery and fund economics.
Pro rata and dilution calculator What defending ownership through two rounds costs, when it loses money, and whether a 1:1 reserve binds.
Month-end close and covenant model Close corrections, ASC 606 allocation, budget variances and the covenant certificate.
CMBS deal model A twenty-loan CMBS from the tape to fourteen classes, liquidations, five stresses and surveillance.
Loan amortization schedule Monthly schedule for a fixed-rate loan, with extra payments, payoff date and interest saved.
Rental property calculator Cap rate, cash-on-cash, DSCR and ten-year IRR for one rental bought with a mortgage.
Fix and flip and BRRRR calculator One distressed house run as a flip with hard money and as a BRRRR refinance, with the 70% rule.
XIRR, NPV and IRR calculator Dated cash flows to XIRR and XNPV, beside IRR and NPV, and the classic NPV() error in numbers.
12-month cash flow forecast Month-by-month cash for a small business: collection timing, supplier timing, buffer and credit line.
Startup financial model (SaaS) 24 months of customers, MRR, burn and runway, the month cash runs out and the round needed.
Private credit fund model A levered direct lending fund: income, leverage, losses, fees and an incentive with a hurdle, to net IRR.
Hotel acquisition model Occupancy, ADR and RevPAR to GOP, management fees, NOI and a five-year levered IRR.
WAULT calculator WAULT to expiry and to break, by rent and by area, with the rent that can end by year.
Brinson attribution model Allocation, selection and interaction by segment, Brinson-Fachler and BHB, reconciled.
Should-cost model A supplier quote rebuilt from kilograms, minutes and rates, and the gap split by driver.
Yield maintenance and defeasance calculator Prepayment premium on a fixed-rate loan, yield maintenance against defeasance, with a rate grid.
DPI, TVPI and net IRR template DPI, TVPI and net IRR on one fund, with and without the NAV, plus PME and a subscription line.
Evergreen vs drawdown fund calculator Evergreen net return against a drawdown fund's IRR on committed capital, and where it reverses.
Family office cost calculator Single-family office cost in dollars and basis points, the multi-family fee and the crossover.
Operational due diligence scorecard ODD rating of fund managers on eight domains, and the fatal flaw that averaging approves.
Co-investment follow-on and reserve model What not following on costs a co-investor, pay-to-play, and the reserve that maximises the multiple.
KYC remediation capacity model KYC back book sized in analyst-days, one-year against five-year plans, outreach and exceptions.
ESG value creation model ESG programme from EBITDA to equity, MOIC and IRR, value protected and the exit multiple.
AUM and net flow forecast model 84 months of gross flows, redemptions, net flows and AUM for a fund sold through platforms.
Loan pricing and return on capital calculator Two loans from margin to net spread and return on capital, the PD at which they tie, floor and prepayment.
Reinsurance model: quota share to cat XL Quota share and sliding scale, surplus, stop loss, cat XL layers, reinstatements and burning cost.
Loan workout options model A defaulted loan's four exits as present values, the indifference price and the provisions.
Fundraising funnel and timeline model A first fund raise as a queue: funnel, meetings, committee dates, first close and burn.
Compound interest and fees calculator Starting early against late, the cost of a 1% fee, and the result after inflation.
Debt snowball vs avalanche calculator Five debts paid off three ways, month by month, and what a starter emergency fund costs.
European Defence Fund funding rate calculator EDF blended funding rate, bonuses, partner co-financing, EDIP windows and evaluation scoring.
Real estate capital stack calculator Value-add and development capital stacks, DSCR, debt yield, blended cost and leverage math.
Fund formation model Fund launch budget, fees by close, second-close equalization and the management company P&L.
Litigation finance model Litigation funding returns by outcome, the waterfall, a cross-collateralized portfolio and an award buy.
Industrial development and letting model A speculative warehouse: monthly carry, weighted letting outcomes, expected margin and land value.
SRT investor return model Significant risk transfer from the investor's side: tranche cash flows, IRR, break-even and stress.
Development appraisal and cost headroom Development appraisal, the break-even construction cost and the real cost overrun headroom.
Secondaries discount to NAV calculator The real discount on an LP secondary: unsmoothed NAV, unfunded commitment and fees to term.
Commercial loan and covenant model A bank's acquisition loan: covenants by quarter through a breach, collateral and return on capital.
Laundromat acquisition model Laundromat purchase: SDE, the offer, the SBA injection, the seller note and coverage.
ASC 842 lease accounting model ASC 842 lessee schedules, entries and classification tests.
Med spa treatment margin and break-even calculator Med spa pricing by the unit and the syringe, contribution per room hour and break-even.
Home care bill rate and break-even calculator Home care agency pricing: the cost of an aide's hour, the bill rate and the break-even.
Auto repair shop acquisition model Auto repair shop purchase: SDE, the offer, the SBA injection, the seller note and coverage.
purchase price allocation model ASC 805 purchase price allocation, goodwill and impairment.
Optometry practice revenue per patient and break-even calculator Optometry practice revenue per patient, the optical's margin and break-even.
Pharmacy margin per prescription and break-even calculator Independent pharmacy economics: the margin per prescription, generic against brand, and the break-even.
Liquor store acquisition model Liquor store purchase: SDE, the inventory at closing, the SBA injection, the seller note and coverage.
Debt and equity accounting model Issuer accounting for debt, SAFEs, convertible notes and preferred stock.
Hearing care practice revenue per patient and break-even calculator Hearing care practice revenue per patient, hearing aid margin and break-even.
Lost profits damages calculator Lost profits damages: incremental margin, mitigation, cover, interest and discounting to the trial date.
Assisted living occupancy and break-even calculator Assisted living economics: revenue per occupied unit, Medicaid against private pay, and break-even occupancy.
Indirect method cash flow statement template Indirect method statement of cash flows, bridged and checked.
Restaurant acquisition model Restaurant purchase: SDE, the price, the cash at closing, the SBA injection, the seller note and coverage.
ABA practice utilization, revenue per client and break-even calculator ABA practice revenue per client, margin per billed hour and break-even.
Self-funding cost calculator Self-funded health plan cost: expected cost, maximum cost and break-even against a renewal.
Inventory valuation and reserve model Inventory valuation, LIFO reserve and obsolete stock reserve, checked.
Used car dealer gross per unit and floor plan calculator Used car dealer economics: gross per unit, F&I, floor plan cost and break-even sales.
WIP schedule template The contractor's year-end WIP schedule, cost to cost, with overbillings, underbillings and loss provisions.
Dental practice valuation calculator Dental practice valuation from net income to adjusted EBITDA, price, cash at closing and loans repaid.
HVAC flat rate pricing calculator The HVAC selling rate from labor cost, efficiency and overhead, and a flat-rate price book.
Veterinary practice valuation calculator Vet practice valuation: adjusted EBITDA, a group's letter of intent and an associate buyout.
Property management company valuation calculator Property management business valuation on SDE, with add-backs, a buyer's range and the loan.
Physical therapy practice valuation calculator PT practice valuation from net income to adjusted EBITDA, price, cash at closing and loans repaid.
Real estate commission split and cap calculator Commission splits and caps: GCI per side, the cap point and company dollar by agent.
Buy-sell structure calculator Buy-sell agreement after Connelly: the estate tax gap of a company-owned policy, structure by structure.
Electrical estimating template An electrical bid from takeoff to price, with copper-priced wire and a change order.
Contractor bonding capacity calculator Bonding capacity from working capital: the aggregate program and the single job limit.
Vacation rental management fee calculator Vacation rental management fees: commission plans compared, the meeting point and revenue by home.
Home builder house budget and margin model House budgets, gross margin per house and three years of a production builder's profit and cash.
Podiatry practice revenue per visit and break-even calculator Podiatry practice revenue per visit, contribution and break-even.
Home inspection pricing and attach rate calculator Home inspection pricing: fee, ancillaries, attach rates and the average ticket.
Estate sale commission and minimum fee calculator Estate sale commission and minimum fee: sell-through, the threshold and what the minimum adds.
Wedding venue booking revenue and break-even calculator Wedding venue economics: revenue per event, contribution, break-even events and loan coverage.
Cash balance plan calculator Cash balance plan for a practice: what it costs, what it saves and who pays for it.
NQDC deferral calculator Deferred compensation: should you defer, and how much risk are you taking?
Winery cost per bottle and break-even calculator Winery economics: cost per bottle, channel margins, break-even cases and loan coverage.
This template goes with The Surgery Center Owner . See the book .