Companion files · The Private Markets Career Guides
Dental Practice Management by the Numbers: Production, Collections, PPO Write-Offs, Overhead, Chair Time, Hygiene, Hiring an Associate and What Your Practice 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 Morrowgate Family Dentistry, the fictional general practice of the case, across two fiscal years: production and collections, the PPO decision, overhead and breakeven, chair occupancy, the associate’s pay, the operatory payback and the valuation bridge. 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 7
Gross production, write-offs, net production and collections, and the receivables rolled forward to the year end. Sheets: Inputs, Three Numbers, Receivables Roll. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 113 KBChapters 5 and 6
$100 of office fees with one carrier, in network and out of network, and the share of production that must stay for leaving to pay. Sheets: Inputs, Per 100 Dollars, Breakeven Share. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 213 KBChapters 3 and 4
The case's overhead ratio and the breakeven collections, with the unrounded ratio carried through. Sheets: Inputs, Overhead Ratio, Breakeven. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 313 KBChapters 9 and 10
Operatory occupancy by structure and by hours, before and after a sixth operatory. Sheets: Inputs, Occupancy. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 412 KBChapter 13
An associate's pay month by month: the percentage of net production, the minimum, and the higher of the two. Sheets: Inputs, Monthly Pay. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 512 KBChapter 14
The payback of a new operatory and the equipment loan's payment, written out one operation per line. Sheets: Inputs, Payback, Loan Payment. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 613 KBChapter 16
A buyer's letter of intent: net income to EBITDA to adjusted EBITDA, the price, the cash, the equity and the loans repaid. Sheets: Inputs, Bridge, Offer. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 713 KBAppendix B
The monthly numbers review; Before signing or renewing a carrier agreement; Leaving a carrier; Hiring an associate; Adding an operatory; The compliance calendar; Preparing for a sale; Before an associate buy-in.
Download the toolkit42 KBRead first
What each file holds, which workbook answers which chapter, and and how to use the workbooks on your own practice.
Download the read-me4 KB| Net, not gross | FY2026 gross production $2,398,736 less write-offs $568,722: net production $1,830,014 |
| The breakeven | FY2026 fixed costs over one minus the variable share: $1,413,161 of collections |
| The adjusted EBITDA | EBITDA $313,181, the owner’s salary added back, a replacement dentist’s pay deducted: $200,056 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Morrowgate Family Dentistry, Thistlebury and every party are fictional, and the fees, write-off rates, payer shares, pay terms, loan rates, prices and multiples are the book’s assumptions, not market terms or the practice of any real dentist, carrier, bank or buyer. Rules change: check the current texts, your state’s rules, your outside CPA and counsel in your state.