Free Excel templates

A free dental practice valuation calculator in Excel

A practice owner's letter of intent from a dental group, worked through: the bridge from net income to EBITDA and to adjusted EBITDA, the price at the letter's multiple, the cash and equity split, and what is left after the practice loans are repaid.

Net income of $196,768 becomes $313,181 of EBITDA, but only $200,056 of adjusted EBITDA once a replacement dentist is paid. At 6x the price is $1,200,336, of which $840,235 is cash at closing, and $418,416 is 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.

Dental_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 Dental 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$196,768
EBITDA$313,181
Replacement dentist's pay deducted$275,063
Adjusted EBITDA$200,056
Multiple of adjusted EBITDA6x
Price$1,200,336
Cash at closing$840,235
Equity in the buyer's group$360,101
Loans repaid at closing$421,819
Cash left after the loans$418,416

The owner's salary is added back, but a buyer then deducts what a dentist would cost to do the owner's clinical work, as a share of the owner's net production. That replacement cost is usually the largest single adjustment in a dental practice sale, and the multiple applies to what is left.

How to use it on your own case

  1. Enter net income, interest, depreciation, amortization and the owner's salary and benefits on Inputs.
  2. Enter the owner's net production and the replacement percentage a buyer would pay an associate.
  3. Enter the multiple and the cash share from the letter of intent, and the practice loans.
  4. Read adjusted EBITDA on Bridge and the price, cash, equity and net cash on Offer.

Questions people ask about it

How are dental practices valued?

Most buyers, especially dental service organizations, value a practice at a multiple of adjusted EBITDA: earnings before interest, taxes, depreciation and amortization, with the owner's pay replaced by the cost of a dentist doing the same clinical work.

What is a replacement dentist adjustment?

The buyer adds back the owner's salary and benefits, then deducts the pay of an associate dentist producing the same dentistry, typically a percentage of the owner's net production, plus payroll taxes and benefits on that pay.

Why is the cash at closing lower than the price?

Group buyers often pay part of the price in equity in their own company, and the practice's loans are repaid from the cash at closing.

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 Dental 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 Dental Practice Owner. See the book.