# The Healthcare Private Equity Investor: companion files

Julian R. Sterling

## What is here

- **Healthcare_PE_Model.xlsx**: the workbook that rebuilds the Fenwold case and reproduces the figures of the book with live formulas. Sheets: Inputs, Platform, QoE, MSO and PC, Add-ons, Projection, Debt, Returns, Scenarios, Physicians, Checks.
- **Healthcare_PE_Toolkit.docx**: the 8 checklists of Appendix 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), in editable form.

## Which sheet answers which chapter

- Chapters 6 and 7: Platform (2026 revenue $69.00 million, pro forma EBITDA $13.53 million after a scale-back of $4.80 million)
- Chapter 8: QoE (seller's adjusted EBITDA $14.53 million, underwritten $13.63 million; the coding audit; the price as a multiple of each EBITDA)
- Chapters 3 and 5: MSO and PC (who owns what, a management fee of $43.20 million, the HSR test)
- Chapter 12: Add-ons (one add-on, the schedule of six, the paper arbitrage and the value at exit)
- Chapter 13: Projection (2027 to 2031, platform and add-ons, MSO build-out, free cash flow)
- Chapter 11: Debt (unitranche term loan, delayed draw term loan, leverage against the covenant)
- Chapter 15: Returns (unlevered 13.71 percent, levered 15.76 percent, 2.03x; the value bridge; the grid by price and exit multiple)
- Chapter 15: Scenarios (Medicare rate cut, exit at a lower multiple, dearer add-ons, no add-ons at 7.36 percent, and all three combined)
- Chapters 7 and 14: Physicians (pay as a share of collections, the founders' cash of $150.00 million and their rollover)
- Appendix A: 10 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Inputs, set the dermatologists' pay to 50 percent of collections: 2031 EBITDA falls and the levered IRR drops by five points. The scale-back is sold at the multiple, so any slippage is lost at the multiple too.
2. On Inputs, set every add-on count to 0: watch the Projection, the Debt and the Returns sheets; the Scenarios sheet runs the same case side by side. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. Every input is on the Inputs sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Wexcombe Capital Partners, its Fund, Fenwold Dermatology Partners, its MSO and PC, the founding physicians and the add-ons are fictional; collections, pay shares, costs, prices, multiples, rates and dates are teaching assumptions, not the terms of any real practice, payer or lender, the quote of any real market or a forecast. Provided as is, without warranty. Not legal, regulatory, tax, accounting or investment advice.
