# The Podiatry Practice Owner: companion files

Julian R. Sterling

## What is here

- **Podiatry_1_Visits_Revenue.xlsx** (Chapters 5 and 6; Workbook 1 of Appendix A): tabs Inputs, Visits, Revenue, Checks. The first office from clinic days to visits scheduled (1,500.0 a month), honored (1,395.0) and billable (1,339.2), and from allowed amounts by payer to $123.49 allowed per billable visit at the payer mix, $113.81 net collected per honored visit, $158,763 a month and a gross collection rate of 43.9 percent.
- **Podiatry_2_Associate.xlsx** (Chapter 9; Workbook 2 of Appendix A): tabs Inputs, Associate, Checks. An associate DPM paid a base plus a share of personal net collections: $654,101 of personal net collections a year at full volume, $243,807 of pay with burden, $410,294 kept by the practice, and $159,059 kept in the first six months while the schedule fills.
- **Podiatry_3_BreakEven.xlsx** (Chapter 12; Workbook 3 of Appendix A): tabs Inputs, Visit, BreakEven, Checks. The honored visit against the office's $111,337 of fixed costs a month: $100.93 of contribution per honored visit, 1,104 honored visits a month to break even (22.1 per DPM clinic day), 1,322 after the purchase loan's payment (26.4), and $60,558 a year for one more honored visit per DPM clinic day.
- **Podiatry_4_Ancillary_Wound.xlsx** (Chapter 8; Workbook 4 of Appendix A): tabs Inputs, Ancillary, Wound, Checks. Custom orthotics and diabetic shoes: $8.82 of ancillary revenue and $5.47 of margin per honored visit; skin substitutes: $27,360 of margin a year, $13,680 lost if the margin per application fell by half.
- **Podiatry_5_SecondOffice.xlsx** (Chapter 14; Workbook 5 of Appendix A): tabs Inputs, Budget, Checks. A second office's investment ($257,058), the practice's own cash beyond the loan ($17,058) and the simple payback (3.5 years).
- **Podiatry_6_Purchase.xlsx** (Chapter 13; Workbook 6 of Appendix A): tabs Inputs, Purchase, Checks. The purchase: project $1,835,000, equity injection $183,500, SBA loan $1,651,500, first-year coverage 1.70 times, and $46,322 of collections lost while the plans credentialed the buyer.
- **Podiatry_7_Offer.xlsx** (Chapter 16; Workbook 7 of Appendix A): tabs Inputs, Bridge, Checks. The platform's letter from EBITDA to SDE ($833,155), adjusted EBITDA ($585,768), enterprise value ($3,807,492) and the owner's cash at closing ($1,193,049, before taxes).
- **Podiatry_Practice_Owner_Toolkit.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (The monthly numbers; The payer file; Traditional Medicare's foot care rules (scope kept); The supplier file for diabetic shoes; Documentation and reviews; Hiring an associate DPM; Buying a practice; Reading a letter of intent).
- The free Podiatry Practice Revenue per Visit and Break-Even Calculator (the cells of workbook 3 on their own: net collected and contribution per honored visit, the break-even in honored visits a month and per DPM clinic day, before and after the purchase loan's payment, and one more honored visit per DPM a day) 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.

Each level of visits has its own base: the no-show and late cancellation rate is taken on visits scheduled, the global period share on honored visits, the payer mix on honored visits, the net collection rate on the allowed amount. Shares are percentage cells: type 7% (or 0.07), never 7. 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 schedule, your fee schedules and remittances, payroll, the lease, the lender's quote, the statements, a letter of intent), keep every check at OK, and compare a result only with the same office'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 collected per honored visit from workbook 1 into workbook 2) is typed again where it is used.

## A word of caution

Bellcastor Foot and Ankle, PLLC, Tamsford Community Bank, Pennickwood Properties, the payers, the platform and every party in the case are fictional. Visits, no-show rates, payer mix, charges, allowed amounts, collection rates, surgical cases, ancillary sales, wound care, wages, salaries, rents, loans, prices, escrows, multiples and fees are teaching assumptions, not market norms, benchmarks or recommendations, and nothing in the files is a clinical, coding or billing guide. Who may own a practice, scope of practice, licensure and payer contracts are for counsel in the practice's state; coverage is for the Medicare contractor and the plans; taxes are for the outside CPA. The files are provided as they are, without warranty of any kind.
