# The Direct Primary Care Practice Owner: companion files

Julian R. Sterling

## What is here

- **DPC_1_Membership_Revenue.xlsx** (Chapter 5; Workbook 1 of Appendix A): tabs Inputs, Fees, Checks. From the members of each age tier (996 active paying members and 72 contract members, a panel of 1,068) to $92,280.00 of individual fees billed a month, $350.66 unpaid, $96,969.34 of membership fees collected with the employer's, $90.80 per panel member, and $3,000.00 of enrollment fees a month.
- **DPC_2_Labs_Medicines_Cost.xlsx** (Chapters 11 and 15; Workbook 2 of Appendix A): tabs Inputs, Sales, Costs, Checks. Labs and medicines sold at posted prices ($8,010.00 a month, a markup of 36.4 percent over cost), $10,694.64 of variable costs, revenue of $98.30 and a contribution of $88.28 per panel member a month; insurer payments only as an exercise.
- **DPC_3_BreakEven_Panel.xlsx** (Chapters 6, 7 and 13; Workbook 3 of Appendix A): tabs Inputs, PerMember, BreakEven, Growth, Checks. The member against $64,770 of fixed costs a month, both physicians at market pay with burden: 734 panel members to break even, 763 after debt service, a capacity of 1,500 and a fill rate of 71.2 percent, 30 net members added a month and the months to the break-even.
- **DPC_4_Employer_Contract.xlsx** (Chapter 8; Workbook 4 of Appendix A): tabs Inputs, Contract, Checks. The employer contract: $5,040.00 of fees a month, $181,440.00 over its term, $5,038.74 of contribution a month, and 58 individual members to replace it.
- **DPC_5_Launch_Financing.xlsx** (Chapter 13; Workbook 5 of Appendix A): tabs Inputs, Budget, Checks. The launch budget of $320,000, 50.0 percent of it borrowed, $132,588 of cash consumed by the ramp, $70,412 above the floor at the lowest month end, and debt service covered 6.49 times by FY2026 EBITDA.
- **DPC_6_Second_Physician_Units.xlsx** (Chapter 14; Workbook 6 of Appendix A): tabs Inputs, NewUnits, Distributions, Checks. New units for the second physician at $410.35 after the minority discount ($205,175 paid to the practice), the founding physician diluted from 100.0 to 66.7 percent, and each physician's FY2026 distributions by units beside his market pay.
- **DPC_7_Sale_to_Associate.xlsx** (Chapter 16; Workbook 7 of Appendix A): tabs Inputs, Value, Bridge, Checks. The partner's offer from EBITDA after market pay to adjusted EBITDA ($211,378), enterprise value ($845,512) and its control by price per panel member, the price of the units sold ($495,148) and the cash at closing ($427,633 before taxes, $427.63 per unit sold), and the members to keep for the escrow's release.
- **Direct_Primary_Care_Practice_Owner_Toolkit.docx**: the 6 check-lists of Appendix B, editable, with a box to tick before each item (The monthly numbers; The Medicare opt-out file; The HSA questions; Opening and state law; A partner joining; Reading an offer to buy).
- The free Direct Primary Care Membership and Break-Even Calculator (the cells of workbook 3 on their own: revenue and contribution per panel member, the break-even panel before and after debt service, capacity, fill rate and growth) 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 unpaid share is taken on individual fees billed, attrition on active paying members at the start of the month, card processing on payments collected by card from members, the fill rate on capacity. Shares are percentage cells: type 1% (or 0.01), never 1. The only functions are ROUND, ROUNDUP, IF, AND, OR and LN; 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 practice's own revenue only: no insurer, Medicare or Medicaid payment is in any cell, except the hybrid input of workbook 2, zero in the case. Each physician's market pay with burden is a fixed cost, so every break-even and every value is after it. The last section of Appendix A lists the wrong inputs the checks do not catch.

To use a workbook on your own practice, start with a copy, replace every blue input from the record that owns each figure (the membership roll, the fee schedule, the employer contract, payroll, the lease, the bank's quote, the operating agreement, the statements, an offer), keep every check at OK, and compare a result only with the same practice'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 (the panel and the fees collected from workbook 1 into workbooks 2 and 4, the contribution per panel member from workbook 3 into workbook 4) is typed again where it is used.

## A word of caution

Calvenridge Direct Care, PLLC, Wrexbury Fabrication, Saltendale Community Bank, Pelkington Properties, the physicians, the members and every party in the case are fictional. Members, fees, attrition, labs and medicines, supplies, wages, rents, loans, unit prices, discounts, distributions, escrows and multiples are teaching assumptions, not market norms, benchmarks or recommendations, and nothing in the files is a clinical guide. Whether a membership agreement is insurance, professional entities, dispensing and the operating agreement are for counsel in the practice's state; Medicare's opt-out and the HSA rules are to be checked against the current texts; taxes are for the outside CPA. The files are provided as they are, without warranty of any kind.
