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.
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.
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
Four sheets. Blue type is an input; black type is a formula.
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.