# The ABA Therapy Practice Owner: companion files

Julian R. Sterling

## What is here

- **ABA_1_Hours.xlsx** (Chapters 5 and 6; Workbook 1 of Appendix A): tabs Inputs, Hours, Revenue, Checks. One active client a month, from the hours a payer authorized (97.92) to the hours rendered and billed (79.31), and from rates per unit to net revenue: $5,472.31 for a Medicaid client, $6,725.55 for a commercial client, $6,036.27 at the payer mix.
- **ABA_2_Staff.xlsx** (Chapter 8; Workbook 2 of Appendix A): tabs Inputs, Staff, Margin, Checks. What the same client's hours cost: RBT hours paid (85.56), BCBA hours (19.69), the certifier's supervision, direct costs of $3,223.66 and a contribution of $2,812.61, $35.46 per billed hour.
- **ABA_3_BreakEven.xlsx** (Chapters 7 and 12; Workbook 3 of Appendix A): tabs Inputs, Client, BreakEven, Checks. The whole client against the center's $57,435 of fixed costs a month: 21 active clients to break even (28 after the purchase loan's payment), and $85,114 a year for five more points of utilization.
- **ABA_4_Turnover.xlsx** (Chapter 10; Workbook 4 of Appendix A): tabs Inputs, Turnover, Checks. The cost of replacing one RBT ($2,144) and of the year's turnover ($27,658).
- **ABA_5_SecondCenter.xlsx** (Chapter 14; Workbook 5 of Appendix A): tabs Inputs, Budget, Checks. A second center's investment ($313,286), the practice's own cash beyond the loan ($73,286) and the simple payback (4.2 years).
- **ABA_6_Purchase.xlsx** (Chapter 13; Workbook 6 of Appendix A): tabs Inputs, Purchase, Checks. The purchase: project $1,668,000, equity injection $166,800, SBA loan $1,501,200, first-year coverage 1.28 times, and $72,129 of revenue lost while the payers credentialed the buyer.
- **ABA_7_Offer.xlsx** (Chapter 16; Workbook 7 of Appendix A): tabs Inputs, Bridge, Checks. The platform's letter from EBITDA to SDE ($667,322), adjusted EBITDA ($557,855), enterprise value ($3,347,130) and the owner's cash at closing ($1,061,372, before taxes).
- **ABA_Practice_Owner_Toolkit.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (Authorizations and the five levels of hours; Billing, denials and documentation; Supervision, hiring and turnover; Intake, referrals, reviews and privacy; The monthly numbers review and the break-even; Buying a practice; Opening a second center; Preparing for a sale).
- The free ABA Practice Utilization, Revenue per Client and Break-Even Calculator (the cells of workbook 3 on their own: net revenue and contribution per client, margin per billed hour, break-even in active clients and five more points of utilization) 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. Each input carries its cell name (the name Appendix A uses), its label and its unit. Cell A1 of every tab says in one sentence what the tab does. The calculation tabs are read top to bottom, one result per line, each with its cell name and label. The Checks tab tests one condition per line and reads OK or CHECK; a single CHECK means the outputs are not to be used until the input behind it is fixed. The last line of the Checks tab only sums them up.

Every timed code is billed in 15-minute units, four units an hour: rates are typed per unit, and where a workbook shows an hourly rate it multiplies the unit rate by four itself. Shares are percentage cells: typing 81% stores the fraction the formulas need, and typing 81 is what the utilization check catches. The only functions are ROUND, ROUNDUP, MIN, MAX, IF and AND; no cell holds a date and no payment function is used: where a loan enters, the lender's quoted payment is an input. An empty cell reads as zero: fill every cell, even with a zero you chose. 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 (your authorizations, your payer contracts and remittances, payroll, the lender's quote, the statements, a letter of intent), keep every check at OK, and compare a result only with the same center's own earlier months. 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 net revenue per client from workbook 1 into workbook 2) is typed again where it is used.

## A word of caution

Tamberwick Autism Therapy, PLLC, Ollendrake Community Bank, Liskerran Properties, the payers, the platform and every party in the case are fictional. Authorized hours, utilization, cancellation rates, rates per unit, payer mix, denial and recovery rates, family shares, wages, salaries, caseloads, rents, loans, prices, escrows, multiples and fees are teaching assumptions, not market norms, benchmarks or recommendations, and nothing in the files is a clinical guide. Authorized hours are the BCBA's request and the payer's decision. Who may own a practice, licensure and payer contracts 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.
