# The Chiropractic Practice Owner: companion files

Julian R. Sterling

## What is here

- **Chiro_1_Visit_and_New_Patient_Planner.xlsx** (Chapters 3 and 4; Workbook 1 of Appendix A): tabs Inputs, Visits, Checks. Scheduled visits by payer row become kept visits once the phase's cancellation and no-show rate is taken out (the first office's week 80: 271 kept visits of 292 scheduled).
- **Chiro_2_Charges_Collections_and_Payer_Mix.xlsx** (Chapters 5 and 7; Workbook 2): tabs Inputs, Collections, Checks. One week's charges at the single fee schedule, revenue by payer row, adjustments, the collection ratio and who pays (week 80: charges $22,287, revenue $16,637, collection ratio 74.6 percent).
- **Chiro_3_Care_Plan_and_Good_Faith_Estimate.xlsx** (Chapter 6; Workbook 3): tabs Inputs, Care Plan, Checks. A prepaid care plan's price per visit, revenue recognized, refund of unused visits and the good faith estimate's dispute threshold (FY2026 terms: $1,152 for 24 visits, refund $96).
- **Chiro_4_Associate_Pay_and_Yield.xlsx** (Chapter 10; Workbook 4): tabs Inputs, Associate, Checks. An associate's quarterly bonus above a threshold and the year's total cost against collections (the first associate: Q4 bonus $4,994, FY2026 cost $116,463, 38.2 percent of collections).
- **Chiro_5_Break_Even_Visits_a_Week.xlsx** (Chapter 11; Workbook 5): tabs Inputs, Break-Even, Checks. Contribution per kept visit and break-even kept visits a week against the actual, with a rent change (the first office in FY2026: 59.04 dollars a visit, 208.5 kept visits a week against 233.2; 210.5 with the renewal rent).
- **Chiro_6_Second_Office_and_Equipment_Payback.xlsx** (Chapters 11 and 12; Workbook 6): tabs Inputs, Payback, Checks. Investment, run-rate and payback of the second office, and the payback of a decompression table ($170,639, $96,640 a year, 21.2 months; table 11.7 months).
- **Chiro_7_Offer_and_Valuation.xlsx** (Chapter 16; Workbook 7): tabs Inputs, Offer, Checks. The letter of intent from EBITDA to the cash paid at closing (enterprise value $843,289, paid at closing $582,043 before taxes and fees; enterprise value over SDE 3.03).
- **Chiropractic_Practice_Owner_Check_Lists.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (The license, scope of practice and privacy file (chapter 2); The weekly schedule and new patient review (chapters 3 and 4); The fee schedule and self-pay prices (chapter 5); Care plans and good faith estimates (chapter 6); Payers, auto injury claims and Medicare (chapters 7 and 8); Hiring staff and an associate (chapters 9 and 10); The lease, equipment and a second office (chapters 11 and 12); Before answering an offer (chapters 15 and 16)).

Every workbook opens pre-filled with the exercise of Appendix A, so you can check each result against the book before typing your own figures.

## How to use the workbooks

Every workbook opens on its Inputs tab: blue type on a light yellow background is an input, and nothing else is typed by hand. The subject tab holds formulas only and is protected against overtyping, with no password. The Checks tab holds the three tests of Appendix A: each one shows OK or CHECK, and the cell All checks shows OK only when every test below it does. A comparison line informs and carries no OK or CHECK.

The arithmetic is plain: the only functions are SUM, ROUND, MIN, MAX, IF and AND. No cell holds a date: a week or a fiscal year is a label. Percentages are typed as percent (8 percent shows as 8%), and every division by an input that can be zero is wrapped in IF and shows 0 instead of an error. An empty input reads as zero in a sum, a product or a comparison, but a MIN or a MAX over a range skips it. The last section of Appendix A lists, workbook by workbook, what 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 schedule, the fee schedule, the remittances and payer contracts, the care plan terms, the associate agreement, the payroll register, the statements, the lease, the bank's schedule, the letter itself), keep every check at OK, and 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 kept visits of workbook 1, an input of workbook 2) is typed again where it is used.

## A word of caution

Harrowvale Chiropractic, P.C., the town of Pendarrow, Quistmoor Properties, Ellsmarden Realty, Tullingford Savings Bank and every party in the case are fictional. New patient counts, visit patterns, cancellation rates, fees, allowed amounts, copays, prices, wages, pay formulas, rents, costs, loan terms, prices and multiples are teaching assumptions, not market norms, not the terms of any payer, not the rule of any state and not recommendations. Nothing here says what care any patient needs. What a state allows is for its board and counsel; billing rules are for the payer and the Medicare contractor; taxes are for the outside CPA. The files are provided as they are, without warranty of any kind.
