# The Physical Therapy Practice Owner: companion files

Julian R. Sterling

## What is here

- **PT_Practice_1_Visits_and_Collections.xlsx** (Chapters 2 and 11; Visits and Collections workbook of Appendix A): sheets Inputs, Revenue, Receivables Roll, then Checks. FY2026 charges $2,281,244, net revenue $1,238,251, collections $1,193,175 (a collection ratio of 96.4 percent), and the receivables rolled forward to $113,733.
- **PT_Practice_2_Payer_Decision.xlsx** (Chapter 8; Payer Decision workbook): sheets Inputs, Per 100 Visits, Breakeven Refill, then Checks. Per 100 Payer C visits: $8,400 in network, $9,184.05 out of network, and the breakeven refill share (64.7 percent).
- **PT_Practice_3_Overhead_and_Breakeven.xlsx** (Chapter 3; Overhead and Breakeven workbook): sheets Inputs, Overhead Ratio, Breakeven, then Checks. The case's overhead ratio (71.8 percent in FY2026) and the breakeven collections ($1,041,052).
- **PT_Practice_4_Schedule_and_Units.xlsx** (Chapter 9; Schedule and Units workbook): sheets Inputs, Arrived Visits, Units, then Checks. Scheduled and arrived visits for one clinician's month, and the timed units of three example visits against the 15-minute unit table.
- **PT_Practice_5_Clinician.xlsx** (Chapters 12 and 13; Clinician workbook): sheets Inputs, Contribution, then Checks. One staff physical therapist's FY2026 contribution ($170,407), and the net revenue per visit shown beside the practice average.
- **PT_Practice_6_Second_Site.xlsx** (Chapter 14; Second Site workbook): sheets Inputs, Monthly Contribution, Loan Payment, then Checks. A month of the Harlowmede site, from revenue to contribution ($1,598 in June 2026), and the equipment loan's payment written out ($1,723 a month).
- **PT_Practice_7_Valuation.xlsx** (Chapter 16; Valuation workbook): sheets Inputs, Bridge, Offer, then Checks. The bridge of the letter of intent, from net income to an adjusted EBITDA of $191,577, the price ($1,053,674, rounded to the dollar), the cash, the equity and the loans repaid.
- **PT_Practice_Toolkit.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (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).

## How to use the workbooks

Every workbook opens on its Inputs sheet: blue type on a light blue background is an input, and nothing else is typed by hand. Each subject has its own sheet, read top to bottom, one line per step. Black type is a formula, green type a figure read from another sheet of the same workbook. The Checks sheet tests the controls of Appendix A: OK on green when a check holds, red with the line to look at when it fails. In the Clinician workbook, the Contribution sheet also shows a reading aid, the clinician's net revenue per visit beside the practice average, which is read, not tested. The default inputs are the case figures, so a workbook opened for the first time shows the numbers of the chapter it serves, and each of the 7 exercises of Appendix A is done in its own workbook.

The arithmetic is plain: add, subtract, multiply, divide, round and, in the loan payment, one power. No date function, workday count or lookup formula is used; months are typed labels, and every count of days, visits or months is an input.

To use a workbook on your own practice, replace every blue input, all of them, from the report that owns each figure, keep the checks green, and compare the result only with the same practice's earlier years, built the same way.

The workbooks are separate files with no link between them: a figure two workbooks share (collections, the equipment loan) is typed again where it is used.

## A word of caution

Tollivane Physical Therapy, PLLC, the towns of Davrenhill and Harlowmede, Orlenbury Savings Bank, Quenmarsh Rehab Partners, Payers A to D and every party in the case are fictional. Fees, allowed amounts, payer shares, cancellation rates, collection patterns, wages, overhead lines, loan rates, prices and multiples are teaching assumptions, not market norms or recommendations. Federal rules change: read them in their current text, with the Medicare manuals, your state's rules, your outside CPA and counsel in your state. No software, bank, plan or real company is described or recommended. Nothing here is legal, tax, billing-compliance, accounting or clinical advice.
