Free Excel templates

A free urgent care break-even calculator in Excel

Visits, payer mix, amounts per visit, denials, the provider schedule and costs in; net revenue per visit, contribution per visit, patients per provider hour, EBITDA, the debt service coverage ratio and break-even visits a day out. No macros.

The file comes prefilled with Quillfield Urgent Care, the fictional clinic of the book, for 2025: 17,885 visits across five payers, net revenue of $2,264,605 or $126.62 a visit, a contribution of $107.13 per visit, 2.97 patients per provider hour, payroll of $1,179,676, EBITDA of $313,462 and a DSCR of 1.21, with a break-even of 41.0 visits a day against 49.2 needed for the covenant.

Get the calculator

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

Urgent_Care_Break_Even_Calculator.xlsx (20 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 calculator

This file is the one-page summary of The Urgent Care Center Owner. The book explains every line: why visits and payers come before dollars, what a provider who is not yet credentialed costs, why a denial is earned revenue at risk, why the schedule is the largest cost decision of the year, and how the year is planned to the bank covenant.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is in the file

Four sheets. Blue type is an input; black type is a formula.

Inputs
Visits a year and their monthly shares; the payer mix and the amount per visit for five payers; the Medicare physician amount and the 85 percent rule; denial and recovery rates; the patient's share and the part never collected; the self-pay price and collection rate; supplies, tests, X-ray reads and card fees; open hours, physician hours and double coverage by month; pay rates and support ratios; salaries, payroll taxes, fixed costs, debt service and distributions.
Calculator
Monthly visits, provider hours and patients per provider hour; net revenue by payer and per visit; variable cost and contribution per visit; payroll built from the schedule; EBITDA, the DSCR, break-even visits a day and the visits a day needed for a DSCR of 1.25, each with a one-line definition beside it.
Read Me
How to replace the case with your own clinic, and which inputs to check with your advisers.
Checks
The calculator compared with the figures printed in the book for the case.

Three things to try

Put the 2024 denials back. Change the denial rate from 11 to 6 percent and the recovery rate from 60 to 70 percent, and watch net revenue per visit, EBITDA and the covenant line move without a single extra patient.

Change the winter schedule. Add or remove an hour of double coverage in the busiest months. Patients per provider hour, payroll and the break-even line all move together.

Replace the case. Type your own visits, payer amounts and costs over the blue cells. If a line does not make sense, the definition beside it says what it measures.

Related reading