Companion files · The Private Markets Career Guides
How to Start a Medical Billing Business and Grow a Billing Company That Pays: Fees on Collections, Claims, Denials, HIPAA, Coding, Staff, Cash and Valuation.
These are the companion files of the book. Five workbooks follow Halvercott Medical Billing, the fictional company of the case, across two fiscal years: fees and pricing, claims and capacity, takeover and coding, invoices and cash, and earnings and sale. Each keeps the case’s figures in one column, an empty column for yours, and a cell that chooses which one the formulas read. A toolkit holds the checklists of Appendix B in editable form.
The archive holds the five workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapters 5 and 7
A practice’s monthly fee as a percentage of net collections and as a price per claim, side by side, with the percentage a price per claim equals, and one practice’s month from claims and denials to production hours, loaded labor, clearinghouse fees and what is left. Sheets: Inputs, Fee basis, Practice margin. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 117 KBChapters 9 and 10
Hours needed for a year’s claims and denials against the production staff’s productive hours, claims a month per staff member, the first-pass denial rate and the share of denials paid after rework. Sheets: Inputs, Capacity, Denials. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 215 KBChapters 6 and 8
Open claims taken over, the part past a filing limit, what is collected and the takeover fee; a coder’s loaded cost, the outside audits, the coding fee from one practice and the gap. Sheets: Inputs, Takeover, Coding. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 315 KBChapters 13 and 14
The company’s own fee invoices owed in days of revenue, a register for your open invoices, fixed costs added from their lines on Inputs and break-even revenue with staff treated as fixed. Sheets: Inputs, Fees owed, Break-even. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 415 KBChapters 14 to 16
Seller’s discretionary earnings with each add-back on its own line, net income per owner hour, a buyer’s indication with its earnout and the largest practice, and transferable earnings. Sheets: Inputs, SDE, Indication, Transferable. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 518 KBAppendix B
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.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to try first.
Download the read-me5 KB| One practice’s fee | 2,100 claims x $84 x 5.5 percent = $9,702 a month |
| Capacity | 102,700 x 4.5 / 60 + 9,654 x 14 / 60 = 9,955 hours needed; 9,955 / 11,045 = 90.1 percent of productive hours |
| The indication | $167,298 of FY2026 SDE x 2.6 to 3.3 = $434,975 to $552,083 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Halvercott Medical Billing, Halvercott, Moorhatch, Ildenmore, Saffrenby, Lisgarran, the buyer and every party are fictional, and the fees, rates, wages, minutes, counts, payment patterns and multiples are the book’s assumptions, not market terms, payer rules or the practice of any real company. Rules change and differ by State and by payer: check the current texts, your signed agreements, your insurance broker, your outside accountant and your counsel.