Free Excel templates

A free podiatry practice revenue per visit and break-even calculator in Excel

Enter your DPMs, clinic days, visits scheduled, no-shows, payer mix, allowed amounts, collection rate, ancillary sales, supplies, associate pay and the office's fixed costs, and read net collected and contribution per honored visit, the break-even in honored visits a month and per DPM clinic day, and what one more visit per DPM a day is worth.

With the worked case's inputs, each honored visit brings in $113.81 of net collections at the payer mix and leaves $100.93 after ancillary cost, supplies and the associates' share; the office needs 1,104 honored visits a month, 22.1 per DPM clinic day, to cover $111,337 of fixed costs, 1,322 once the purchase loan's payment is added, and one more honored visit per DPM a day would add $60,558 a year.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 164 free models.

Podiatry_Practice_Calculator.xlsx (14 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with The Podiatry Practice Owner, which explains the method behind it, chapter by chapter.

Get the PDF edition → See the book

Want every model at once?

The Financial Model Library: all 165 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

4 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

Inputs
DPMs, clinic days, visits scheduled, no-show and global period rates, payer mix, allowed amounts, collection rate, charge, ancillary revenue and cost, supplies, associate pay, fixed costs and the loan payment.
Visit
Visits scheduled, honored and billable a month, allowed amount at the payer mix, contractual adjustment, net collected per honored visit and a month, gross collection rate.
BreakEven
Associate pay and contribution per honored visit, fixed costs, break-even of EBITDA and after debt service a month and per DPM clinic day, one more visit a day and the office's EBITDA.
Checks
Payer mix, rates, allowed amounts against the charge, associates against DPMs, contribution above zero and visits above the break-even after debt service.

What the worked case returns

MeasureValue
Honored visits a month1,395.0
Allowed amount per billable visit at the payer mix$123.49
Net collected per honored visit$113.81
Contribution per honored visit$100.93
Fixed costs a month$111,337
Break-even of EBITDA, honored visits a month1,104
Break-even of EBITDA, per DPM clinic day22.1
Break-even after debt service, honored visits a month1,322
Break-even after debt service, per DPM clinic day26.4
One more honored visit per DPM clinic day, a year$60,558

The figures come from a fictional practice and are teaching assumptions, not benchmarks, coding advice or a clinical guide. The break-even is one of EBITDA (it leaves out depreciation, interest and loan payments) and counts office visits only, without surgical fees or wound care; a separate line adds the purchase loan's monthly payment. Each rate has its own base: no-shows on visits scheduled, the global period share and the payer mix on honored visits, the collection rate on the allowed amount.

How to use it on your own case

  1. Type your DPMs, clinic days per DPM a year, visits scheduled per clinic day, the no-show rate and the global period share on Inputs.
  2. Type your payer mix in honored visits, the allowed amount per billable visit by payer, the net collection rate and the charge per visit.
  3. Type ancillary revenue and cost and supplies per honored visit, the associates and their pay, the ten fixed lines of a month, then the loan payment.
  4. Read the visit on Visit and the break-even on BreakEven; keep every line of Checks at OK.

Questions people ask about it

How much does a podiatry practice collect per visit?

It depends on the payer mix, the allowed amount each payer pays, the collection rate and the visits paid inside a surgical global period. In the worked case each honored visit brings in $113.81 of net collections; the calculator rebuilds it from your own inputs.

What is the contribution per visit?

Net collected plus ancillary revenue, less ancillary cost, clinical supplies and the associates' share of collections with burden: $100.93 per honored visit in the worked case. It is before fixed costs and the owner's salary.

How many patients a day does a podiatrist need to break even?

Fixed costs a month divided by the contribution per honored visit, rounded up, then spread over the DPMs' clinic days: 1,104 honored visits a month, 22.1 per DPM clinic day in the worked case, and 1,322 once the purchase loan's payment is added.

What is one more visit a day worth?

The contribution per honored visit times the DPMs and their clinic days in a year: $60,558 in the worked case, before any added staff.

Go further

The free workbooks of The Podiatry Practice Owner go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with The Podiatry Practice Owner. See the book.