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