# The Audiology Practice Owner: companion files

Julian R. Sterling

## What is here

- **Audiology_1_Revenue.xlsx** (Chapter 5; Workbook 1 of Appendix A): tabs Inputs, Revenue, Checks. One binaural patient sold bundled, unbundled or at a third-party contract price, devices apart from services, after the devices' cost and card fees ($3,372.60, $2,890.47 and $1,100.00 before staff pay in the case).
- **Audiology_2_Devices.xlsx** (Chapter 6; Workbook 2): tabs Inputs, Devices, Checks. What added points of conversion bring in a year at one site (58 more fitted patients, 96 more devices kept and $129,934 of contribution for five points).
- **Audiology_3_Pay.xlsx** (Chapter 8; Workbook 3): tabs Inputs, Pay, Checks. One associate's year under three pay plans, pay only before burden, and the net hearing aid revenue at which plans A and B cost the same ($384,000).
- **Audiology_4_Equipment.xlsx** (Chapter 10; Workbook 4): tabs Inputs, Equipment, Checks. Total cash paid under a lease and under a loan for the same equipment, with no discounting ($151,201 against $144,960).
- **Audiology_5_BreakEven.xlsx** (Chapter 12; Workbook 5): tabs Inputs, BreakEven, Checks. Fixed costs a month turned into hearing aids kept a month ($57,405 over $1,494.89 a device kept: 39 devices, rounded up; 48 after the loan payments).
- **Audiology_6_Purchase.xlsx** (Chapter 13; Workbook 6): tabs Inputs, Purchase, Checks. The purchase with an SBA 7(a) loan: project, equity injection, seller note limit and loan ($1,018,000, $101,800, $50,900, $916,200).
- **Audiology_7_Offer.xlsx** (Chapter 16; Workbook 7): tabs Inputs, Offer, Checks. The letter of intent from the buyer's adjusted EBITDA to the owner's cash at closing ($2,846,520 of enterprise value, $1,213,799 at closing before taxes).
- **Audiology_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); Insurers, administrators and billing (chapters 4 and 11); Prices, conversion and returns (chapters 5 and 6); OTC devices and the front desk (chapter 7); Hiring and paying an associate (chapter 8); Equipment, the manufacturer and a second site (chapters 10 and 14); Before answering an offer (chapters 15 and 16)).
- The free Hearing Care Practice Revenue per Patient and Break-Even Calculator (revenue per fitted patient and per appointment, hearing aid gross margin, break-even devices kept a month and five more points of conversion) 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. Cell A1 of every tab says in one sentence what the tab does. 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 (one pay plan beside another, the lower of two totals, actual devices beside break-even) 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 cell holds a date and no payment function is used anywhere: where a loan or a lease enters, the quoted payment is an input. Devices, which carry a cost of goods, are always kept apart from services (diagnostic fees, fitting fees, follow-up visits), which carry none. Rates are percentage cells: typing 2.6% stores the fraction the formulas need. Every division by an input that can be zero sits inside IF and shows an empty-looking cell instead of an error. SUM and plain arithmetic read an empty cell as zero, while MIN and MAX skip it: scan the Inputs tab for blanks, and type a zero you mean as 0. 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 price list, the manufacturer's invoices and credits, insurer and administrator remittances, 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 (the contribution per device from workbook 2 into workbook 5, the loan payment from workbook 6 into workbook 5) is typed again where it is used.

## A word of caution

Pellastone Hearing Care, PLLC, Morvaine Community Bank, Hemmersley Equipment Finance, Vardolin Properties, the manufacturer, the buyer and every party in the case are fictional. Volumes, conversion rates, binaural shares, prices, contract prices, unit costs, return rates, fees, allowed amounts, 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 a hearing care practice and sell hearing aids, scope of practice, trial periods and how a provider 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.
