Companion files · The Private Markets Career Guides
Physical Therapy Practice Management by the Numbers: Visits, Payers, Medicare Rules, Cancellations, Collections, Overhead, Hiring, a Second Site and What Your Practice Is Worth.
DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample
These are the companion files of the book. Seven workbooks follow Tollivane Physical Therapy, the fictional outpatient practice of the case, across two fiscal years: visits and collections, the payer decision, overhead and breakeven, the schedule and timed units, one clinician’s contribution, a second site and the valuation bridge. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the seven workbooks, the toolkit and 00_START_HERE.md. No macros, no date functions, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapters 2 and 11
Visits, charges, contractual adjustments, net revenue and collections, and the receivables rolled forward to the year end. Sheets: Inputs, Revenue, Receivables Roll. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 113 KBChapter 8
Per 100 of a plan’s visits, in network and out of network, and the share of freed visits that must be refilled for the exit to pay. Sheets: Inputs, Per 100 Visits, Breakeven Refill. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 213 KBChapter 3
The case’s overhead ratio and the breakeven collections, with the unrounded share carried through. Sheets: Inputs, Overhead Ratio, Breakeven. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 313 KBChapter 9
Scheduled and arrived visits after late cancellations and no-shows, and timed minutes read against the 15-minute unit table. Sheets: Inputs, Arrived Visits, Units. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 413 KBChapters 12 and 13
One clinician’s contribution: net revenue less pay, payroll taxes and benefits, and supplies. Sheets: Inputs, Contribution. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 511 KBChapter 14
A month of a second site, from revenue to contribution, and the equipment loan’s payment, written out one operation per line. Sheets: Inputs, Monthly Contribution, Loan Payment. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 613 KBChapter 16
A buyer’s letter of intent: net income to EBITDA to adjusted EBITDA, the price, the cash, the equity and the loans repaid. Sheets: Inputs, Bridge, Offer. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 713 KBAppendix B
The monthly numbers review; The Medicare plan-of-care file; Before signing or renewing a plan agreement; Leaving a payer; Hiring a physical therapist; Opening a site; The compliance calendar; Preparing for a sale.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and how to use the workbooks on your own practice.
Download the read-me4 KB| Revenue, not charges | FY2026 charges $2,281,244 less contractual adjustments $1,042,993: net revenue $1,238,251 |
| The breakeven | FY2026 fixed costs over one minus the variable share: $1,041,052 of collections |
| The adjusted EBITDA | EBITDA $144,377, the owner’s salary added back, a clinic director’s pay deducted: $191,577 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Tollivane Physical Therapy, Davrenhill, Harlowmede and every party are fictional, and the fees, allowed amounts, payer shares, cancellation rates, pay terms, loan rates, prices and multiples are the book’s assumptions, not market terms or the practice of any real therapist, plan, bank or buyer. Rules change: check the current texts, the Medicare manuals, your state’s rules, your outside CPA and counsel in your state.