Free Excel templates

A free physical therapy practice valuation calculator in Excel

A physical therapy clinic owner's letter of intent, worked through: EBITDA, the owner's pay replaced by a clinic director who treats and runs the practice, the price at the letter's multiple, the cash and equity split, and the cash left after the loans.

Net income of $109,779 gives $144,377 of EBITDA and $191,577 of adjusted EBITDA once a clinic director replaces the owner. At 5.5x the price is $1,053,674: $842,939 in cash at closing and $686,811 left after the loans.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 181 free models.

Physical_Therapy_Practice_Valuation_Calculator.xlsx (13 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with The Physical Therapy Practice Owner, which explains the method behind it, chapter by chapter.

Get the book on Google Play →

Or the DRM-free PDF, $19.99 →

Want every model at once?

The Financial Model Library: all 182 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

3 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

Bridge
Offer
Checks

What the worked case returns

MeasureValue
Net income$109,779
EBITDA$144,377
Owner's salary and benefits added back$150,000
Clinic director's pay deducted$110,000
Adjusted EBITDA$191,577
Multiple of adjusted EBITDA5.5x
Price$1,053,674
Cash at closing$842,939
Equity in the buyer's group$210,735
Cash left after the loans$686,811

The buyer adds back the owner's salary and benefits, then deducts the pay and benefits of a clinic director who treats patients and runs the clinic. The multiple is the case letter's number, not a market multiple.

How to use it on your own case

  1. Enter net income, interest, depreciation and the owner's salary and benefits on Inputs.
  2. Enter the pay of a clinic director and the payroll burden rate.
  3. Enter the letter's multiple, cash share and the loans repaid at closing.
  4. Read adjusted EBITDA on Bridge and the price and cash on Offer.

Questions people ask about it

How are physical therapy practices valued?

Buyers, especially private equity backed groups, usually apply a multiple to adjusted EBITDA, with the owner's pay replaced by what a clinic director would cost.

Why replace the owner with a clinic director?

Because after the sale someone must treat patients and run the clinic. The buyer values the cash flow left after paying that person.

Why is cash at closing lower than the price?

Part of the price is often rolled into equity in the buyer's group, and the practice's loans are repaid from the cash.

Is this template really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The free workbooks of The Physical Therapy Practice Owner go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with The Physical Therapy Practice Owner. See the book.