Companion files · The Private Markets Career Guides

The Medical Billing Business Owner

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 five workbooks, the toolkit and the read-me, in one archive117 KB

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.

The files

Three numbers to reproduce first

One practice’s fee2,100 claims x $84 x 5.5 percent = $9,702 a month
Capacity102,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.