Free Excel templates

A free hospice cap and break-even calculator in Excel

Per diem rates, the cap amount, patient groups, stays, admissions and costs in; revenue per stay, payments per beneficiary against the cap, an estimated liability, the census and the break-even census out. No macros.

At the national routine home care rates of fiscal year 2026, $230.83 a day for days 1 to 60 and $181.94 from day 61, a stay of 90 days pays $19,308.00, a stay of 150 days $30,224.40 and a stay of 210 days $41,140.80, against an aggregate cap amount of $35,361.44 per beneficiary. A stay longer than 178.2 days pays more than the cap amount. The calculator turns that arithmetic into a quick estimate for a whole patient mix.

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.

Hospice_Cap_and_Break_Even_Calculator.xlsx (16 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 Hospice Agency Owner. The book explains every line: why patient-days and length of stay come before dollars, how the proportional method counts beneficiaries, why a census that outruns admissions is a question, how the cap is estimated every month and paid back months later, 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
Routine home care rates for days 1 to 60 and from day 61; the cap amount per beneficiary; up to five patient groups with their share of admissions and length of stay; admissions a year; the Medicare share; clinical payroll and other costs per patient-day; fixed costs a year.
Calculator
Revenue of one stay for each group; weighted revenue per admission; payments per beneficiary against the cap amount, with the headroom or the estimated liability; the cap break-even stay; the average daily census; revenue and contribution per patient-day; the break-even census; revenue per stay from 30 to 365 days. Each line has a one-line definition beside it.
Read Me
How to replace the case with your own figures, and why the result is an estimate, not a cap determination.
Checks
The calculator compared with the figures printed in the book.

Three things to try

Lengthen one group's stay. Move the dementia and general decline group from 330 to 450 days and watch payments per beneficiary climb toward the cap amount.

Change the mix, not the volume. Shift five points of admissions from short stays to long stays: the census rises and so does the cap exposure, with the same number of admissions.

Replace the case. Type your own wage-adjusted rates, groups and costs over the blue cells. If a line does not make sense, the definition beside it says what it measures.

Related reading