A medical practice break-even calculator answers a specific question: Can the services your staffed practice can realistically complete generate enough contribution to cover its operating costs?
The calculation starts with fixed costs, net collectible revenue per completed service unit and variable cost per unit. It then compares the required volume with available provider time, rooms and staff support.
Unlike a general break-even planning exercise, this calculator produces a reproducible volume target. Unlike a unit-economics calculator, it goes beyond the margin on one service to test whether total operating costs can be covered.
Below is a spreadsheet specification you can build, an illustrative calculation and checks to make before using the result for a hiring, scheduling or location decision.
Why SaaS Metrics Do Not Transfer to a Medical Practice
Subscriber counts, monthly recurring revenue (MRR) and SaaS churn assumptions describe subscription businesses. They do not describe a typical fee-for-service practice's operating capacity or collections.
A patient is not a subscription customer. One patient may receive several services, while another may not need another appointment during the planning period. Scheduled appointments also do not automatically become completed, collectible services.
For a practice, replace subscription assumptions with:
- Completed service units: Encounters, procedures or another consistently defined unit.
- Net collectible revenue: What the practice reasonably expects to collect from payers and patients for those units, not gross charges.
- Completion assumptions: The portion of offered capacity expected to result in completed services.
- Resource limits: Provider time, room availability, equipment and supporting staff.
This produces a volume threshold under stated assumptions—not an exact date when the practice will become profitable.
Define the Calculator's Inputs
Use one time period throughout, usually a month. Do not divide monthly costs by annual service volume or compare collections from older claims with this month's completed encounters.
| Input | Definition | Practical source or check |
|---|---|---|
| Fixed operating costs | Costs that remain relatively stable within the modeled volume range | Monthly P&L, payroll detail, leases and recurring expenses |
| Completed service unit | A consistently counted encounter or service | Aggregate completed-service reports, excluding cancellations |
| Net collectible revenue per unit | Expected payer and patient receipts attributable to that unit, after contractual adjustments and expected collection losses | Collections analysis for sufficiently mature service periods |
| Variable cost per unit | Costs that increase because an additional unit is completed | Supply usage, external service charges and truly variable compensation |
| Service mix | Each service group's share of completed units | Recent aggregate volume, adjusted for the proposed scenario |
| Available capacity | Schedulable resources that support the modeled service mix | Provider schedules, room limits and staffing plans |
Classify costs by behavior, not account name
Rent, base provider salaries, administrative payroll, insurance and recurring software costs may be fixed within the current staffing configuration. Include relevant employer payroll costs and benefits, not just take-home pay.
Supplies consumed per service, external laboratory charges paid by the practice and compensation that genuinely varies with completed work may be variable. Split mixed compensation into base and variable portions. Never include the same expense in both categories.
Some costs are step-fixed: another administrator, room or provider becomes necessary above a capacity limit. Run a separate scenario with that additional cost rather than assuming the existing cost structure supports unlimited volume.
For this calculator, operating break-even includes operating expenses, including depreciation where applicable, but excludes financing interest, income taxes and owner distributions. If an owner provides clinical work without recorded compensation, show a separate scenario with an explicit compensation allowance so the result does not imply that owner labor is free.
Estimate collectible revenue rather than using charges
Use expected receipts tied to completed services. Gross charges can overstate the revenue available to cover expenses because contractual adjustments and uncollectible balances reduce realizable amounts.
Avoid simply dividing this month's bank deposits by this month's visits. Those deposits may include payments for earlier service periods. Use mature service-period results where available and document uncertainty for newer services or contracts. Do not reduce revenue twice for the same collection loss.
The Break-Even Formula
For one consistent service unit:
Unit contribution = Net collectible revenue per unit − Variable cost per unit
Break-even completed units = Fixed operating costs ÷ Positive unit contribution
Round the result up to a whole completed unit.
If contribution is zero or negative, there is no finite operating break-even volume under those assumptions. Completing more of the same services does not solve the problem.
For several service groups:
Weighted unit contribution = Sum of each group's completed-unit share × its unit contribution
Then divide fixed operating costs by that weighted contribution. The service shares must total 100%. A change in mix requires recalculation.
Build the Spreadsheet
Create a worksheet named BreakEven. Use the cell locations below so the formulas can be reproduced directly.
Input cells
All numbers in the following spreadsheet example are illustrative assumptions, not practice benchmarks.
| Cell | Input | Illustrative value |
|---|---|---|
| B2 | Monthly fixed operating costs | 60000 |
| B3 | Monthly schedulable provider minutes | 12000 |
| B4 | Expected completion factor | 90% |
The illustrative 12,000 minutes could represent two providers, each with 20 working days and 300 schedulable minutes per day. Exclude time already reserved for administration or other unavailable periods.
The completion factor represents the share of offered service capacity expected to become completed work. Do not reduce available minutes for the same cancellations and then apply the factor again.
Enter the service-mix table in rows 8–11:
| Row | Column A: Service group | Column B: Completed-unit share | Column C: Net collectible revenue | Column D: Variable cost | Column E: Provider minutes | Column F: Contribution |
|---|---|---|---|---|---|---|
| 8 | Service group | Share | Revenue/unit | Variable cost/unit | Minutes/unit | Contribution/unit |
| 9 | Service group A | 70% | 160 | 25 | 20 | =C9-D9 |
| 10 | Service group B | 30% | 260 | 70 | 40 | =C10-D10 |
| 11 | Unused group | 0% | 0 | 0 | 0 | =C11-D11 |
Use meaningful service groups that reflect different economics or resource requirements. Where payer differences materially change collectible revenue, consider separate service-and-payer groups. Do not mix encounters with individual billing lines unless the model explicitly accounts for their relationship.
Output formulas
| Cell | Output | Formula |
|---|---|---|
| B14 | Total service-mix share | =SUM(B9:B11) |
| B15 | Weighted contribution per completed unit | =SUMPRODUCT(B9:B11,F9:F11) |
| B16 | Weighted collectible revenue per unit | =SUMPRODUCT(B9:B11,C9:C11) |
| B17 | Weighted provider minutes per unit | =SUMPRODUCT(B9:B11,E9:E11) |
| B18 | Break-even completed units | =IF(OR(ABS(B14-1)>0.000001,B15<=0),"Review inputs",ROUNDUP(B2/B15,0)) |
| B19 | Collectible revenue at break-even volume | =IF(ISNUMBER(B18),B18*B16,"Review inputs") |
| B20 | Estimated completed-unit capacity | =IF(OR(B17<=0,ABS(B14-1)>0.000001),"Review inputs",ROUNDDOWN(B3/B17*B4,0)) |
| B21 | Operating surplus or shortfall at capacity | =IF(ISNUMBER(B20),B20*B15-B2,"Review inputs") |
| B22 | Capacity above or below break-even units | =IF(AND(ISNUMBER(B18),ISNUMBER(B20)),B20-B18,"Review inputs") |
Validate inputs: costs and revenue must be nonnegative; shares must be between zero and one and total one; each active service group must have positive minutes; and the completion factor must be greater than zero and no more than one.
The capacity formula assumes the same completed-service mix and a common completion factor. If completion rates vary materially by service group, model those groups separately.
Read the illustrative result
Service group A contributes $135 per unit; group B contributes $190. The weighted contribution is:
(70% × $135) + (30% × $190) = $151.50
The calculator therefore produces:
- Break-even volume: $60,000 ÷ $151.50, rounded up = 397 completed units.
- Weighted collectible revenue: $190 per unit.
- Collectible revenue at the rounded target: 397 × $190 = $75,430.
- Weighted provider time: 26 minutes per unit.
- Estimated capacity: 12,000 ÷ 26 × 90%, rounded down = 415 completed units.
- Operating surplus at capacity: 415 × $151.50 − $60,000 = $2,872.50.
The illustrative practice has only 18 completed units of capacity above break-even. That is a narrow operating cushion, not evidence that expansion is affordable. When translating weighted results into whole service counts, round the groups and recalculate their actual contribution and time requirements.
sbb-itb-17e8ec9
Check Whether the Target Is Operationally Achievable
Provider minutes alone may overstate usable capacity. Before accepting the target, check:
- Rooms and equipment: Can the required service mix fit within available room and equipment time?
- Staff support: Can current administrative and clinical support staff handle that volume without additional cost?
- Schedule fit: Are the necessary appointment lengths and provider qualifications available in the right sessions?
- Demand: Is there a supportable forecast for completed services, rather than merely open appointment slots?
- Step costs: Would reaching the target trigger overtime, another employee or a larger facility?
Use the tightest resource constraint as the practical limit. Where services use several constrained resources, add separate time requirements for each resource rather than treating all services as interchangeable.
For multiple locations, calculate location-level results using direct expenses plus a documented share of central costs. Also review the consolidated practice result. For multiple entities, keep entity-level accounts distinct and avoid counting intercompany charges as additional consolidated costs.
Test the Owner's Actual Decision
Copy the worksheet for each proposed change. Adjust only the inputs affected, then review both contribution and capacity.
The following scenarios continue the illustrative example above:
| Scenario | Break-even completed units | Completed-unit capacity | Operating result at capacity |
|---|---|---|---|
| Base assumptions | 397 | 415 | $2,872.50 surplus |
| Collectible revenue falls $10 per unit in both groups | 425 | 415 | $1,277.50 shortfall |
| Fixed operating costs increase by $5,000 | 430 | 415 | $2,127.50 shortfall |
A lower collectible amount can make the target unreachable even when the schedule is full. An additional employee raises fixed costs, but may also unlock capacity; model both effects rather than changing payroll alone.
Do not assume a charge increase creates the same increase in collectible revenue. Use supportable payer and patient collection assumptions.
Keep Operating Break-Even Separate From Cash Needs
An operating break-even result does not mean the bank balance will remain stable. Payer receipts may arrive after payroll is due, and patient balances may take longer to collect than expected.
Build a separate cash forecast showing:
- Expected payer and patient receipt timing.
- Payroll, vendor and other operating payment timing.
- Debt principal and interest payments.
- Capital purchases and their financing.
- Tax payments, owner distributions and reserve needs.
Debt principal is not an operating expense. Capital purchases generally should not be inserted as a one-time operating expense in this calculator; depreciation may already be included in fixed operating costs. In a cash forecast, account for noncash expenses and actual capital payments separately to avoid double counting.
A practice can cover operating costs on an earned-revenue basis and still need cash to bridge collections or fund equipment.
Maintain Reliable Inputs
Update the model after the monthly close and when staffing, contracts or service mix change. Keep an assumptions log identifying each input's source, period and owner.
The IRS guidance on business records supports complete records, separate business accounts and bank reconciliation—the foundation for dependable financial inputs.
Use aggregate service and financial data wherever possible. Patient names and other patient-identifiable details are not needed in this calculator and should not be placed in ordinary Slack messages or general-purpose AI tools.
Lucid Financials provides CPA-led bookkeeping, tax and CFO services for staffed US private medical practices, combining AI-assisted financial work with a human finance team. Clean books and location/entity financial visibility can provide a stronger starting point for this analysis.
The final decision should rest on three checks: positive contribution, achievable capacity and sufficient cash. Passing only the break-even formula is not enough.
FAQs
Can I use patient count as the break-even unit?
Usually, completed encounters or defined services are more useful. Patients can receive different numbers and types of services, so patient count alone can conceal differences in revenue, variable costs and time requirements. Choose a unit that can be counted consistently and connected to the costs and collectible revenue being modeled.
What if one service group has a negative contribution?
Keep it visible rather than hiding it inside an average. A positive weighted contribution can still produce a practice-wide break-even result, but increasing the negative-contribution group's share makes that result worse. Verify revenue and cost inputs, then evaluate the service's role and operational constraints separately; the calculator alone does not determine service availability or clinical decisions.
Does the calculator tell me when the practice will break even?
No. It calculates required completed volume for a defined period and set of assumptions. To estimate timing, build a month-by-month forecast of demand, staffing, service mix and expenses. Use a separate cash forecast to test whether available funds cover the path to that volume.