# The Dental Practice Owner: companion files

Julian R. Sterling

## What is here

- **Dental_Practice_1_Production_and_Collections.xlsx** (Chapters 2 and 7; Production and Collections workbook of Appendix A): sheets Inputs, Three Numbers, Receivables Roll, then Checks. FY2026 gross production $2,398,736, net production $1,830,014, collections $1,803,380 (a collection ratio of 98.5 percent), and the receivables rolled forward to $76,559.
- **Dental_Practice_2_PPO_Decision.xlsx** (Chapters 5 and 6; PPO Decision workbook): sheets Inputs, Per 100 Dollars, Breakeven Share, then Checks. $100 of FY2026 office fees with Carrier D: $56.31 in network, $70.00 out of network with 70 percent staying, and the breakeven share.
- **Dental_Practice_3_Overhead_and_Breakeven.xlsx** (Chapters 3 and 4; Overhead and Breakeven workbook): sheets Inputs, Overhead Ratio, Breakeven, then Checks. The case's overhead ratio (68.6 percent in FY2026) and the breakeven collections ($1,413,161).
- **Dental_Practice_4_Chair_and_Hygiene.xlsx** (Chapters 9 and 10; Chair and Hygiene workbook): sheets Inputs, Occupancy, then Checks. Occupancy by structure and by hours: 80.0 percent in FY2025, 88.5 percent from January to September 2026 with six operatories.
- **Dental_Practice_5_Associate.xlsx** (Chapter 13; Associate workbook): sheets Inputs, Monthly Pay, then Checks. The associate's pay month by month, the percentage against the minimum, January to September 2026.
- **Dental_Practice_6_Operatory_Payback.xlsx** (Chapter 14; Operatory Payback workbook): sheets Inputs, Payback, Loan Payment, then Checks. The sixth operatory ($72,400), its payback (5.4 months) and the equipment loan's payment written out ($1,298 a month).
- **Dental_Practice_7_Valuation.xlsx** (Chapter 16; Valuation workbook): sheets Inputs, Bridge, Offer, then Checks. The bridge of the letter of intent, from net income to an adjusted EBITDA of $200,056, the price ($1,200,336), the cash, the equity and the loans repaid.
- **Dental_Practice_Toolkit.docx**: the 8 check-lists of Appendix B, editable (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).

## 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. 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 loan payment, one power. No date function, workday count or lookup formula is used; months and fiscal years are typed labels, and every count of days 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 (collections, the equipment loan) is typed again where it is used.

## A word of caution

Morrowgate Family Dentistry, P.C., the town of Thistlebury, Corbelridge Dental Laboratory, Penderly Savings Bank, Garrowmont Dental Partners, Carriers A to D and every party in the case are fictional. Fees, write-off rates, payer shares, collection patterns, wages, overhead lines, pay terms, 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, carrier or real company is described or recommended. Nothing here is legal, tax, accounting or clinical advice.
