# The Optometry Practice Owner: companion files

Julian R. Sterling

## What is here

- **Optometry_1_Revenue.xlsx** (Chapter 5; Workbook 1 of Appendix A): tabs Inputs, Per Exam, Checks. What one routine exam brings in with the optical behind it, for a vision plan patient and a cash patient, after cost of goods and card fees ($176.95 and $307.17 before staff pay in the case).
- **Optometry_2_Optical.xlsx** (Chapter 6; Workbook 2): tabs Inputs, Capture, Checks. What added points of capture are worth in a year, per payer group (435 more eyeglass jobs and $77,961 for ten points).
- **Optometry_3_Pay.xlsx** (Chapter 8; Workbook 3): tabs Inputs, Pay Plans, Checks. The associate's base plan beside a production-only plan and a flat day rate, and the crossover production ($604,800).
- **Optometry_4_OCT.xlsx** (Chapter 10; Workbook 4): tabs Inputs, Buy or Lease, Checks. The OCT's loan against the lessor's quote, and the payback from its scans ($77,220 against $80,400; 17.6 months).
- **Optometry_5_BreakEven.xlsx** (Chapter 12; Workbook 5): tabs Inputs, Break-Even, Checks. Fixed costs a month turned into encounters a month ($65,568 over $180.70: 363 encounters, rounded up).
- **Optometry_6_Purchase.xlsx** (Chapter 13; Workbook 6): tabs Inputs, Sources and Uses, Checks. The purchase with an SBA 7(a) loan: project, equity injection, seller note limit and loan ($1,130,000, $113,000, $1,017,000).
- **Optometry_7_Offer.xlsx** (Chapter 16; Workbook 7): tabs Inputs, Bridge, Checks. The letter of intent from the buyer's adjusted EBITDA to the owner's cash at closing ($2,235,204 of enterprise value, $516,290 at closing before taxes).
- **Optometry_Practice_Owner_Toolkit.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (The monthly numbers review (chapters 5, 6 and 12); Entity, ownership and the purchase (chapters 2 and 13); Plan contracts and medical billing (chapters 4 and 11); The optical and prescription release (chapter 6); Contact lenses and verification requests (chapter 7); Hiring and paying an associate (chapter 8); Equipment and a second site (chapters 10 and 14); Before answering an offer (chapters 15 and 16)).
- The free Optometry Practice Revenue per Patient and Break-Even Calculator (revenue per patient seen, optical gross margin, break-even and ten more points of capture) is offered on the book's page, against an e-mail address.

## How to use the workbooks

Every workbook opens on its Inputs tab: blue type on a light blue background is an input, and nothing else is typed by hand. The subject tab is read top to bottom, one result per line. Black type is a formula, green type a figure read from another tab of the same workbook. The Checks tab holds the three checks of Appendix A: each one is an IF test on your own inputs that reads OK or CHECK, and the cell All checks reads OK only when every check above it does. A comparison (actual encounters beside break-even, one pay plan beside another) stays on the subject tab and never turns a check to CHECK.

The arithmetic is plain: the only functions are SUM, ROUND, MIN, MAX, IF and AND. No date and no payment function is used anywhere: where a loan payment matters, the lender's quoted payment is an input. Rates are percentage cells: typing 2.6% stores the fraction the formulas need. Every division by an input that can be zero is wrapped in IF and shows n/a instead of an error. SUM and plain arithmetic read an empty cell as zero, while MIN and MAX skip it, so each range check sits beside a test that a key input is above zero. The last section of Appendix A lists the wrong inputs the checks do not catch.

To use a workbook on your own practice, start with a copy, replace every blue input from the record that owns each figure (the fee schedule, plan contracts and remittances, the optical's sales and laboratory invoices, the card processor's statements, payroll, the lender's and the lessor's quotes, the statements, a letter of intent), keep every check at OK, and compare a result only with the same site's own earlier months and years. Never edit a formula to turn a CHECK into OK.

The workbooks are separate files with no link between them: a figure two workbooks share is typed again where it is used.

## A word of caution

Orvanell Eye Care, PLLC, Daskerfield Community Bank, Ventholm Equipment Finance, Ossenbrook Properties, the buyer and every party in the case are fictional. Volumes, payer mixes, capture rates, fees, plan reimbursements, allowed amounts, prices, costs, pay plans, wages, terms, quotes and multiples are teaching assumptions, not market norms, benchmarks or recommendations, and nothing in the files is a clinical guide. Who may own an optometry practice, how fees may be shared, scope of practice and how an optometrist may be paid are for counsel in the practice's state; taxes are for the outside CPA. The files are provided as they are, without warranty of any kind.
