Companion files · The Private Markets Career Guides
Physician Practice Roll-Ups, MSO Structures, Stark and Anti-Kickback Rules, State Transaction Laws, Due Diligence and Returns.
These are the companion files of the book. One workbook rebuilds Fenwold Dermatology Partners, the fictional platform of the case: 18 clinics, 30 dermatologists and 16 advanced practice providers, studied by Wexcombe Capital Partners at $170.00 million. It follows the practice accounts and the compensation scale-back, the quality of earnings, the MSO and the professional corporation, six add-ons, the projection from 2027 to 2031, the debt and its covenant, the returns, the downside cases and the physicians' proceeds. A toolkit holds the checklists of Appendix B in an editable form.
The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.
Chapters 3, 5 to 8, 10 to 15, and Appendix A
An Inputs sheet holds every assumption of the case, and one sheet follows each step of the book: Platform, QoE, MSO and PC, Add-ons, Projection, Debt, Returns, Scenarios, Physicians. A Checks sheet puts the figures printed in the book beside the cells that compute them, and the 10 exercises of Appendix A run on it.
Download the workbook63 KBAppendix B
Sub-sector screen; Structure and the corporate practice of medicine; Fraud and abuse; Coding and overpayments; Payer contracts and reimbursement; Providers and compensation; Transaction notices and antitrust; Integration and the first 100 days.
Download the toolkit41 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| The scale-back | The dermatologists' pay falls from 55 to 45 percent of their collections: $4.80 million a year becomes EBITDA, $59.87 million of value at the entry multiple |
| The price | $170.00 million: 12.47x underwritten EBITDA of $13.63 million; unlevered IRR 13.71 percent, levered 15.76 percent and 2.03x on the equity |
| The add-ons | Six practices bought at 7.0x for $51.90 million of cash; without them the same platform returns 7.36 percent |
The files are provided as they are, without warranty of any kind. The model is illustrative: Wexcombe Capital Partners, its Fund, Fenwold Dermatology Partners, the founding physicians and the add-ons are fictional, and collections, pay shares, costs, prices, multiples, rates and dates are the book’s assumptions, not the terms of any real practice, payer or lender, the quote of any real market or a forecast. Nothing here is legal, regulatory, tax, accounting or investment advice.