Companion files · The Private Markets Career Guides
How to Run a Profitable Counseling Private Practice and Group Practice: Schedules, Missed Sessions, Payers and Self-Pay, Claims, Clinician Pay, Supervision, Telehealth, Cash and Selling the Practice.
These are the companion files of the book. Six workbooks follow Ferrowmont Counseling Group, the fictional group practice of the case, across two fiscal years: schedule and sessions, payers and rates, claims and collections, clinician pay, cash and decisions, and profit and value. Each keeps the case’s figures in one column and an empty column for yours. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the six 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 3, 5 and 6
Weekly slots turned into slots offered each month, the ramp of a new clinician, slots booked, missed sessions and sessions held, and the booked share month by month. Sheets: Inputs, Slots, Ramp, Booking. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 119 KBChapters 4 and 7
Sessions and charges by payer, the payer mix, and net revenue per session after denials and client balances written off. Sheets: Inputs, Charges, Net per session. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 217 KBChapters 6, 7 and 8
Denials, resubmissions and write-offs, the client’s share collected at the session, receivables and days to collect, and the missed-session fee charged and collected. Sheets: Inputs, Claims, Client share, Receivables, Missed fees. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 318 KBChapters 9, 10 and 11
A salary, a per-session pay and a fee split side by side, the split month by month, supervision hours and an associate’s first months, and the cost of a departure. Sheets: Inputs, Pay models, Fee split, Supervision, Departure. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 419 KBChapters 14 and 15
Month-end cash, the line of credit and the rule for distributions, then outsourcing the billing and leaving the lowest-paying panel, each a projection. Sheets: Inputs, Cash, Decisions. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 519 KBChapters 13 and 16
Both income statements and the bridge between them, seller’s discretionary earnings and EBITDA, and the founder’s planning range. Sheets: Inputs, Income statement, SDE, Planning range. A Checks sheet puts the figures printed in the book beside the cells that compute them.
Download workbook 618 KBAppendix B
Hiring and onboarding a clinician; Joining a payer’s panel; The first appointment and the good faith estimate; The monthly billing close; The weekly schedule review; A clinician’s departure; The founder’s monthly review; Preparing a sale.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me5 KB| The schedule | 10,748 slots booked / 11,572 slots offered = 92.9 percent booked in FY2026 |
| A payer’s session | ($122,206 - $3,365 - $674) / 1,247 = $94.76 an Ostermere Mutual session in FY2026, against a rate of $98 |
| The practice’s earnings | $92,788 + $100,000 + $15,000 + $10,000 + $356 = $218,144 of SDE in FY2026 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Ferrowmont Counseling Group, Wendlecross, the clinicians, the health plans, the EAP, the billing company, the landlord and every party are fictional, and the rates, fees, shares, salaries, per-session pay, splits, rents and multiples are the book’s assumptions, not market terms or the practice of any real group. A session here is a slot, a payer, a rate and a date: nothing describes a client or a clinical matter. Licensing, supervision, payer terms and worker classification depend on your state and your contracts: ask counsel and your outside CPA.