A staffed medical practice can collect more revenue without generating enough contribution to support its payroll, rent and other overhead. Unit economics helps owners separate those questions: what does a completed encounter collect, what costs change with that encounter, and what remains to support the practice?
The five calculators below are no-cost spreadsheet layouts, not rankings of external products. Copy the labels, inputs and formulas into a spreadsheet you already use. No paid calculator or specialized software is required.
Each calculator answers a different management question. Start with the one that matches your decision, rather than building an elaborate patient lifetime-value model.
| Calculator | Best question to answer | Main limitation |
|---|---|---|
| Collected revenue per completed encounter | What are comparable encounters actually collecting? | Recent encounters may still have unpaid balances |
| Variable cost per encounter | What costs change with the work performed? | Some labor and supply costs are fixed or mixed |
| Contribution per encounter | What remains before fixed overhead? | Contribution is not net profit |
| Attributed acquisition cost per new patient | What did a defined campaign spend per attributed new patient? | Attribution does not prove the campaign caused the visit |
| Acquisition-spend payback | When did collected cohort contribution recover acquisition spending? | Recovery may not occur within the observation window |
Set the measurement rules first
Use the same encounter definition, location, service group and observation window wherever you compare results. A completed office encounter should not be mixed indiscriminately with a procedure, canceled appointment or administrative contact.
For revenue calculations, select a service-date cohort: encounters completed during a defined period. Then measure collections attributable to those encounters through a stated cutoff date. Include payer receipts and patient payments, net of related refunds and recoupments. Do not treat unpaid patient balances, billed charges or contractual adjustments as cash collected.
This is different from dividing all deposits received this month by all visits completed this month. Deposits may relate to older care, while recent encounters may not yet have collected. Compare cohorts at similar collection ages and revisit immature results.
Use aggregate financial inputs whenever possible. Keep any patient-level matching in an appropriately governed system; do not place patient-identifiable information in ordinary Slack or a general-purpose AI tool. The HHS minimum necessary guidance provides context for limiting access and disclosure where the standard applies.
1. Collected revenue per completed encounter
Choose this calculator when: you need to compare realized receipts across locations, service groups or periods before deciding whether a revenue difference needs investigation.
Formula: net collections attributable to the encounter cohort ÷ completed encounters in that cohort.
On a blank worksheet, enter labels in column A and the following values or formulas in column B. All numeric inputs below are an illustrative example, not a practice benchmark.
| Cell | Input or output | Example value or formula |
|---|---|---|
| B2 | Completed encounters in the selected service-date cohort | 400 |
| B3 | Payer receipts attributable to those encounters through cutoff | 60000 |
| B4 | Patient payments attributable to those encounters through cutoff | 13000 |
| B5 | Related refunds and recoupments, entered as a positive amount | 1000 |
| B6 | Net collected revenue | =B3+B4-B5 |
| B7 | Collected revenue per completed encounter | =IF(B2>0,B6/B2,"") |
Illustrative result: $72,000 ÷ 400 = $180 per completed encounter.
Record the service period and collection cutoff beside the table. If some payments cannot yet be matched to the cohort, flag the result as incomplete rather than assigning them arbitrarily.
Interpretation limits: A lower result can reflect payer mix, service mix, collection timing, refunds or collection problems. It does not establish that a provider is less productive or that a payer contract is unfavorable. Compare like services at similar collection ages before drawing conclusions.
2. Variable cost per encounter
Choose this calculator when: you want to understand the costs that change with encounter volume, such as consumed supplies or genuinely encounter-linked compensation.
Formula: total variable costs attributable to the encounter cohort ÷ completed encounters.
Use a separate worksheet. The following is an illustrative example using the same 400-encounter cohort.
| Cell | Input or output | Example value or formula |
|---|---|---|
| B2 | Completed encounters | 400 |
| B3 | Supplies consumed for those encounters | 8000 |
| B4 | Provider compensation and associated employer costs that vary with those encounters | 12000 |
| B5 | Other encounter-linked variable costs, excluding acquisition spending | 4000 |
| B6 | Total variable cost | =SUM(B3:B5) |
| B7 | Variable cost per completed encounter | =IF(B2>0,B6/B2,"") |
Illustrative result: $24,000 ÷ 400 = $60 per encounter.
Use consumed supplies rather than simply the month's inventory purchases. Other variable costs might include outsourced services or collection-related fees when their cost actually varies with the selected activity.
Provider and administrative payroll require judgment. A salaried employee's pay generally does not change with one additional encounter within existing capacity. A per-encounter payment may change directly. Overtime or an additional staffing shift may be a step cost rather than a smoothly variable cost. Document the classification and the decision horizon.
Interpretation limits: Excluding fixed salaries does not make those salaries irrelevant. This calculator measures a defined variable-cost layer, not the full cost of running the practice. Avoid allocating all payroll into this figure merely to make it look comprehensive.
3. Contribution per encounter
Choose this calculator when: you need to determine what comparable encounters leave to support fixed payroll, occupancy and other overhead.
Formulas:
- Contribution = net collected revenue − variable costs.
- Contribution per encounter = contribution ÷ completed encounters.
- Contribution margin = contribution ÷ net collected revenue.
Use the totals from calculators 1 and 2 only if they cover the same encounters and scope. On another worksheet, enter the following illustrative example.
| Cell | Input or output | Example value or formula |
|---|---|---|
| B2 | Completed encounters | 400 |
| B3 | Net collected revenue from calculator 1 | 72000 |
| B4 | Total variable cost from calculator 2 | 24000 |
| B5 | Collected contribution | =B3-B4 |
| B6 | Contribution per encounter | =IF(B2>0,B5/B2,"") |
| B7 | Contribution margin; format as a percentage | =IF(B3>0,B5/B3,"") |
Illustrative result: contribution is $48,000, or $120 per encounter, with a 66.7% contribution margin.
Call this a collected-contribution measure because revenue reflects receipts through a cutoff while variable costs relate to the completed work. It is not a substitute for an accrual P&L or a cash-flow statement.
Interpretation limits: Positive contribution is not net profit. Rent, fixed provider/admin payroll, insurance and other overhead still need coverage. A proposed schedule expansion may also require additional staffing or space, making historical contribution an incomplete guide to the decision.
sbb-itb-17e8ec9
4. Attributed acquisition cost per new patient
Choose this calculator when: you are comparing a defined outreach campaign's spending with new patients attributed to that campaign who completed their first encounter.
Formula: defined acquisition spending ÷ attributed new patients with a completed first encounter.
Agree on the attribution rule before reviewing results—for example, a documented intake source combined with a campaign response record. Define “new patient” consistently and deduplicate the count. Leads, appointment requests and canceled first visits are not completed new-patient encounters.
Use a separate worksheet. These inputs are an illustrative example.
| Cell | Input or output | Example value or formula |
|---|---|---|
| B2 | Direct campaign spending | 3000 |
| B3 | Campaign-specific creative or vendor costs | 1000 |
| B4 | Allocated acquisition staff cost for the campaign | 500 |
| B5 | Total defined acquisition spending | =SUM(B2:B4) |
| B6 | Deduplicated attributed new patients completing a first encounter | 30 |
| B7 | Attributed acquisition cost per new patient | =IF(B6>0,B5/B6,"") |
Illustrative result: $4,500 ÷ 30 = $150 per attributed new patient.
Allow a documented response window after spending ends so that campaign activity and completed first encounters have time to connect. Keep direct-spend-only and staff-inclusive calculations separately labeled if you use both.
Interpretation limits: Patients may encounter multiple messages, receive a referral and later search for the practice. Attribution assigns credit; it does not establish incremental demand. As an illustrative sensitivity test, the same $4,500 spend divided by 20 attributed patients produces $225, while division by 40 produces $112.50. That range shows how denominator uncertainty changes the conclusion.
5. Acquisition-spend payback on collected contribution
Choose this calculator when: you want to know whether a defined acquisition cohort has generated enough collected contribution to recover its acquisition spending.
Formula: cumulative cohort contribution = cumulative net collections − cumulative variable costs attributable to the cohort's completed care. Payback is the first observation period when that cumulative contribution reaches acquisition spending.
Use the same acquired-patient cohort from calculator 4. Count each collection and variable cost once. Include costs for completed care even if its associated receipts have not yet arrived. Do not subtract acquisition spending within the monthly variable costs: it is the recovery target.
The following illustrative example uses $4,500 of acquisition spending. On a new worksheet, put that amount in B2. Enter the table headers in row 4, then place each row below in the specified cells.
| Spreadsheet row | A: Month since campaign start | B: Net cohort collections | C: Cohort variable costs | D: Period contribution | E: Cumulative contribution | F: First recovery month |
|---|---|---|---|---|---|---|
| 5 | 1 |
3000 |
1200 |
=B5-C5 |
=D5 |
=IF(E5>=$B$2,A5,"") |
| 6 | 2 |
3500 |
1400 |
=B6-C6 |
=E5+D6 |
=IF(AND(E6>=$B$2,COUNT($F$5:F5)=0),A6,"") |
| 7 | 3 |
1500 |
600 |
=B7-C7 |
=E6+D7 |
=IF(AND(E7>=$B$2,COUNT($F$5:F6)=0),A7,"") |
For the summary result, enter this formula in B9: =IF(COUNT(F5:F7)=0,"Not recovered within observation window",MIN(F5:F7)).
Illustrative result: cumulative contribution is $1,800 after month 1, $3,900 after month 2 and $4,800 after month 3. The first observed recovery month is month 3. To extend the observation window, copy row 7's formulas downward, enter actual monthly inputs and extend the summary range.
Interpretation limits: This is month-end observed recovery, not an exact recovery date or a forecast. Later refunds, recoupments or costs can reduce cumulative contribution after the first crossing. Payback also does not mean the cohort covered allocated overhead. Do not substitute a practice-wide average contribution for tracked cohort results without labeling that substitution as an estimate.
Keep shared costs and entity boundaries visible
For multi-location practices, show contribution before shared overhead and operating results after allocation as separate layers.
| Cost or receipt | Practical treatment |
|---|---|
| Location-specific rent | Assign directly to that location's P&L |
| Shared administrative payroll | Allocate using documented work time or another supportable activity measure |
| Central occupancy costs | Consider space usage where it reflects the benefit received |
| Shared acquisition spending | Use a consistent campaign allocation rule; disclose uncertain attribution |
| Transfers between practice entities | Reconcile separately; do not count transfers as patient collections |
Allocation makes shared costs visible; it does not turn them into variable encounter costs. Retain each entity's books and reconcile consolidated reporting so internal charges are not counted twice. The IRS business recordkeeping guidance supports complete records, separate business accounts and bank reconciliation—the foundation for dependable calculator inputs.
Why SaaS lifetime-value assumptions do not transfer directly
Patients are not subscription customers. Scheduled visits are not recurring subscription revenue, and an absence of visits is not necessarily customer churn. Future care depends on clinical need, patient choice, coverage and other uncertainties.
A SaaS-style lifetime-value formula based on recurring revenue and churn would require substantial adaptation: defined care cohorts, observed collections, service-specific costs, collection timing and explicit uncertainty. These five calculators instead emphasize completed care and observed receipts. Never use a payback target to encourage unnecessary care.
Choose the next action, not just a metric
Start with revenue and variable cost if the question concerns encounter economics. Add contribution when evaluating capacity or service mix. Use acquisition cost and payback only when campaign spending and cohort attribution are sufficiently documented.
Review the result alongside a location/entity P&L and cash forecast before committing to hiring, expansion or additional acquisition spending. 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/CPA team. Clean books and location/entity visibility support these decisions; the spreadsheet arithmetic is only the final step.
FAQs
Are these calculators free?
The layouts and formulas above are free to copy into a spreadsheet. They are not claims about any vendor's free plan, integrations or software features. Use a spreadsheet environment appropriate for your data and existing requirements.
What if collections are still arriving?
Label the cohort as immature, record its collection cutoff and update it later. Compare cohorts at similar collection ages. Do not treat unpaid balances as collected revenue or interpret an early result as final performance.
Can positive contribution justify hiring another employee?
Not by itself. Model the proposed employee's total compensation cost, available capacity, expected completed encounters and collection timing. A hiring decision changes the cost structure; historical contribution does not automatically cover the new fixed or step cost.