Free Excel templates

A free veterinary practice valuation calculator in Excel

A veterinary practice owner compares two exits: a corporate group's letter of intent at a multiple of adjusted EBITDA, and a sale to an associate financed by a ten-year loan, with the coverage ratio the bank will check.

Net income of $479,790 becomes $596,428 of adjusted EBITDA after a replacement veterinarian. The group's letter at 7x prices the practice at $4,174,996, $2,738,498 of cash after the loans; an associate buyout at 5x prices it at $2,982,140, with debt service covered 1.46x.

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.

Veterinary_Practice_Valuation_Calculator.xlsx (15 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 Veterinary 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

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

Bridge
Letter
Associate Sketch
Checks

What the worked case returns

MeasureValue
Net income$479,790
EBITDA$542,265
Adjusted EBITDA$596,428
Group letter: price$4,174,996
Group letter: cash at closing$3,131,247
Group letter: cash left after the loans$2,738,498
Associate buyout: price$2,982,140
Associate buyout: monthly loan payment$33,999
Associate buyout: a year of payments$407,988
Associate buyout: debt service coverage1.46x

The owner's pay is added back and a veterinarian's pay at the associates' production percentage is deducted. The same adjusted EBITDA drives both exits; the multiple and the structure make the difference.

How to use it on your own case

  1. Enter net income, interest, depreciation and the owner's pay and production on Inputs.
  2. Enter the replacement percentage and the payroll burden rate.
  3. Enter the group's multiple and cash share, and the associate's multiple, injection and loan terms.
  4. Compare the Letter and Associate Sketch sheets.

Questions people ask about it

How are veterinary practices valued?

Corporate buyers price a practice at a multiple of adjusted EBITDA, with the owner's pay replaced by what an associate veterinarian would earn for the same production.

Why would an associate pay less than a corporate group?

An associate buyer is limited by what a lender will finance and by debt service coverage, so the multiple is usually lower, though the seller may keep more control of the outcome.

What is debt service coverage?

Adjusted EBITDA divided by a year of loan payments. Lenders generally want it comfortably above 1.

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