Companion files · The Private Markets Career Guides
Veterinary Practice Management by the Numbers: Transactions, Fees, Pharmacy, Wellness Plans, Associate Pay, Overhead, Controlled Substances, Hiring and What Your Hospital Is Worth.
DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample
These are the companion files of the book. Seven workbooks follow Tarvelyn Animal Hospital, the fictional general companion-animal practice of the case, across two fiscal years: transactions and revenue, production pay, wellness plans, the pharmacy move, overhead and breakeven, a new associate and the valuation. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the seven workbooks, the toolkit and 00_START_HERE.md. No macros, no date functions, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapters 2 and 3
Transactions, the four invoiced lines, revenue with plan fees and commissions, the average transaction, and client accounts rolled forward to the year end. Sheets: Inputs, Revenue, Client Accounts. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 113 KBChapter 5
One veterinarian’s month: production at list, the percentage against the monthly guarantee, and the pay, written out cell by cell. Sheets: Inputs, Production, Pay. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 213 KBChapter 13
A wellness plan’s year of fees against the list value of its covered visits, and the year’s plan fees beside the covered visits. Sheets: Inputs, Per Plan, Year. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 313 KBChapter 11
Refills moved to an online pharmacy: the in-house margin, the commission, the margin given up and the breakeven commission rate. Sheets: Inputs, Margin, Breakeven Rate. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 412 KBChapter 7
The case’s overhead ratio and the breakeven collections, with the unrounded share carried through. Sheets: Inputs, Overhead Ratio, Breakeven. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 513 KBChapter 14
A month of a new associate’s schedule, from revenue to contribution, and the equipment loan’s payment, written out one operation per line. Sheets: Inputs, Monthly Contribution, Loan Payment. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 613 KBChapters 15 and 16
Net income to EBITDA to adjusted EBITDA, a group’s letter of intent, and a sale to an associate with its loan and coverage. Sheets: Inputs, Bridge, Letter, Associate Sketch. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 715 KBAppendix B
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.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and how to use the workbooks on your own practice.
Download the read-me5 KB| The average | FY2026 invoiced revenue $3,018,855 over 13,545 transactions: $222.88, lower than FY2025’s $224.00 although prices rose |
| The breakeven | FY2026 fixed costs over one minus the variable share: $2,399,574 of collections |
| The adjusted EBITDA | EBITDA $542,265, the owner’s salary added back, the pay of a veterinarian doing the owner’s clinical work deducted: $596,428 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Tarvelyn Animal Hospital, Quorrisdale and every party are fictional, and the tickets, cost rates, plan terms, commissions, pay terms, loan rates, prices and multiples are the book’s assumptions, not market terms or the practice of any real veterinarian, laboratory, pharmacy, bank or buyer. Rules change: check the current texts, your state’s rules, your outside CPA and counsel in your state.