# The Medical Billing Business Owner: companion files

Julian R. Sterling

## What is here

- MBBO_1_Fees_and_Pricing.xlsx (Chapters 5 and 7; Fees and Pricing workbook of Appendix A): sheets Inputs, Fee basis, Practice margin, then Checks. A practice's monthly fee as a percentage of net collections and as a price per claim, side by side (Moorhatch: 2,100 x $84 x 5.5 percent = $9,702; Saffrenby: $8,125 per claim against $7,436 at 6.5 percent after a payer's cut), the loaded production hour ($25.80 then $27.00), and one practice's month to what it leaves, with the four named practices of January 2026 side by side.
- MBBO_2_Claims_and_Capacity.xlsx (Chapters 9 and 10; Claims and Capacity workbook): sheets Inputs, Capacity, Denials, then Checks. Hours needed for a year's claims and denials against the production staff's productive hours (90.1 then 81.5 percent used), claims a month per production staff member, the first-pass denial rate (9.4 then 6.8 percent), the share of denials paid after rework, and a run of denials at one practice.
- MBBO_3_Takeover_and_Coding.xlsx (Chapters 6 and 8; Takeover and Coding workbook): sheets Inputs, Takeover, Coding, then Checks. Open claims taken over, the part already past a filing limit, what was collected and the takeover fee ($11,057), then a coder's loaded cost, the outside audits and the coding fee from one practice ($15,000 a year that its coding alone does not pay).
- MBBO_4_Invoices_and_Cash.xlsx (Chapters 13 and 14; Invoices and Cash workbook): sheets Inputs, Fees owed, Break-even, then Checks. The company's own fee invoices owed in days of revenue (37.2 then 39.1), a register for your open invoices, fixed costs added from their lines on Inputs and break-even revenue with staff treated as fixed ($608,199 then $834,503).
- MBBO_5_Earnings_and_Sale.xlsx (Chapters 14 to 16; Earnings and Sale workbook): sheets Inputs, SDE, Indication, Transferable, then Checks. Seller's discretionary earnings ($132,870 then $167,298) with each add-back on its own line, net income per owner hour, the fictional buyer's indication with its earnout and the weight of the largest practice, and transferable earnings ($73,698).
- MBBO_Medical_Billing_Checklists.docx: the 13 checklists of Appendix B, editable (A new service agreement; Taking on a practice and its open claims; The business associate agreement and subcontractors; Before a claims batch; Remittances and payment posting; Denial work; Follow-up and filing deadlines; Coding controls; A security incident; Hiring and access; The month-end close and the fee invoice; Losing a practice; The monthly review of the company).

## How to use the workbooks

The first tab of each workbook, Inputs, holds every input in two columns side by side: Case, with the case's figures in blue on a light blue background, and Your company, an empty yellow column for yours. A cell at the top of the sheet chooses which column the formulas read; the Used column applies that choice (a blank yellow cell falls back to the case figure), and every other sheet reads the Used column. The Note column is yours: write the date and the document of each input. Black type is a formula, green type a link to another sheet. Rebuild the case first: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the top cell reads Case. Each of the 12 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. When a figure is rounded, the note at the top of the sheet says how.

Two inputs to try first:

1. In MBBO_1_Fees_and_Pricing.xlsx, on Inputs, type the net collected per claim of one of your practices after a payer's rate change: the percentage that a price per claim equals moves, and the fee on a percentage moves with it.
2. In MBBO_2_Claims_and_Capacity.xlsx, on Inputs, type the minutes you timed on your own staff for a claim and for a denial: the hours needed and the use percentage follow.

To use a workbook on your own company, set the top cell to Your company and fill the yellow column from your claim log and denial log, your remittances, your payroll, your fee invoices and your income statement, in the order Appendix A gives, and keep a dated copy at each year end. The workbooks are separate files with no link between them.

## A word of caution

Halvercott Medical Billing, LLC, the town of Halvercott, Moorhatch Family Medicine, Ildenmore Orthopedics, Saffrenby Behavioral Health, Lisgarran Dermatology and the regional revenue cycle company that gave an indication are fictional. Fees, rates, wages, minutes, hours, counts, payment patterns, premiums, draws and multiples are teaching assumptions, not market norms, payer rules or recommendations. Federal and State rules on privacy and security, claims, filing limits, Medicare and Medicaid billing agents, overpayments, licensing and collections change and may or may not reach a given company: read them in their current text, with your outside accountant, your insurance broker and your counsel. No company, payer, clearinghouse, software or vendor is described or recommended. Nothing here is legal, tax, compliance or insurance advice.
