# The Veterinary Practice Owner: companion files

Julian R. Sterling

## What is here

- **Vet_Practice_1_Transactions_and_Revenue.xlsx** (Chapters 2 and 3; Transactions and Revenue workbook of Appendix A): sheets Inputs, Revenue, Client Accounts, then Checks. FY2026 invoiced revenue $3,018,855 from four lines, revenue $3,108,792 with plan fees and commissions, the average transaction ($222.88), and client accounts rolled forward to $10,724.
- **Vet_Practice_2_Production_Pay.xlsx** (Chapter 5; Production Pay workbook): sheets Inputs, Production, Pay, then Checks. One veterinarian's month: production at list, 21 percent of it against the monthly guarantee, and the pay ($14,368 for associate 1 in June 2026, $10,500 for the new associate).
- **Vet_Practice_3_Wellness_Plan.xlsx** (Chapter 13; Wellness Plan workbook): sheets Inputs, Per Plan, Year, then Checks. A year of fees per plan ($480) against the list value of its covered visits ($362), and FY2026's plan fees ($82,600) beside the list value of the year's covered visits ($62,445).
- **Vet_Practice_4_Pharmacy.xlsx** (Chapter 11; Pharmacy workbook): sheets Inputs, Margin, Breakeven Rate, then Checks. The refills moved online: the in-house margin ($22,622), the commission ($7,337), the margin given up ($15,285) and the breakeven commission rate (37 percent).
- **Vet_Practice_5_Overhead_and_Breakeven.xlsx** (Chapter 7; Overhead and Breakeven workbook): sheets Inputs, Overhead Ratio, Breakeven, then Checks. The case's overhead ratio (75.7 percent in FY2026) and the breakeven collections ($2,399,574).
- **Vet_Practice_6_New_Associate.xlsx** (Chapter 14; New Associate workbook): sheets Inputs, Monthly Contribution, Loan Payment, then Checks. A month of the new associate's schedule, from revenue to contribution ($28,475 in June 2026), and the equipment loan's payment written out ($1,613 a month).
- **Vet_Practice_7_Valuation.xlsx** (Chapters 15 and 16; Valuation workbook): sheets Inputs, Bridge, Letter, Associate Sketch, then Checks. The bridge to an adjusted EBITDA of $596,428, the group's letter ($4,174,996, of which $3,131,247 in cash at closing) and the owner's sketch of a sale to associate 1 ($2,982,140, a case coverage of 1.46).
- **Vet_Practice_Toolkit.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (The monthly numbers review; The controlled substance file; The pharmacy shelf and labels; An associate's agreement; Adding a veterinarian; A plan program review; 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. Every check is a test your own inputs could fail. A comparison set beside a result (plan fees beside list value, the commission rate beside the breakeven rate, collections beside breakeven, the letter beside the sketch) is a reading aid on the subject sheet, never green or red. 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 two loan payments, one power. No date function, workday count or lookup formula is used, and every count of transactions, 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 (the tickets, collections, the payroll taxes and benefits rate) is typed again where it is used.

## A word of caution

Tarvelyn Animal Hospital, P.C., the town of Quorrisdale, Brannockby Savings Bank, Selvermoor Diagnostic Laboratory, Ostrandel Veterinary Partners and every party in the case are fictional. Tickets, cost rates, plan terms, commissions, wages, pay terms, 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 your state's rules, your outside CPA and counsel in your state. No software, bank, laboratory, pharmacy or real company is described or recommended. Nothing here is legal, tax, accounting or clinical advice.
