Free Excel templates

A free home care bill rate and break-even calculator in Excel

Type the aide's wage, your payroll taxes, overtime share, travel, mileage, bill rate and fixed weekly costs: the sheet returns the aide's full cost per billed hour, the margin, the lowest rate for your target and the weekly break-even, with three checks.

The worked example is the book's fictional private pay case: an aide at $17.00 with 0.2 hours of travel per visit, 14.35 percent payroll burden and a small overtime share costs $21.26 per billed hour. At a $36.00 rate the hour leaves $14.74, the lowest rate for a 35 percent margin is $32.71, and fixed costs of $9,944 a week need 675 hours at that margin.

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 129 free models.

Home_Care_Bill_Rate_and_Break_Even_Calculator.xlsx (12 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 Home Care Agency 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 130 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

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

Inputs
The aide's wage, payroll taxes and insurance as one percentage, the overtime share, travel per visit, visits and hours, mileage, the bill rate, fixed weekly costs, billed hours and the target margin.
Results
The aide's full cost per billed hour, the margin in dollars and percent, the lowest rate for the target, the weekly break-even and the contribution.
Checks
Three tests on the wage, the rate against the cost and the target margin, and an All checks cell.

What the worked case returns

MeasureValue
Aide cost per billed hour$21.26
Gross margin per hour$14.74
Gross margin as a share of the rate (percent)40.9
Lowest bill rate for the target margin$32.71
Break-even billed hours per week675
Weekly contribution at the hours entered$32,360

Every figure is a teaching assumption of the book's fictional case, not a market norm. The example prices every hour as a private pay hour; across all payers the case kept $9.69 per billed hour, so its real break-even was about 1,045 hours a week. The wage check tests the federal minimum only; your state's minimum may be higher.

How to use it on your own case

  1. Type the aide's hourly wage and your payroll taxes and insurance as one percentage of pay.
  2. Enter the share of paid hours that are overtime, the travel time per visit, visits and care hours per week, and mileage.
  3. Enter your bill rate, your fixed weekly costs, your billed hours and your target gross margin.
  4. Read the cost per hour, the lowest rate, the break-even and the checks.

Questions people ask about it

How do I calculate the cost of a caregiver hour?

Wage, plus the share of paid travel between visits, times one plus your payroll taxes and workers' compensation, plus the overtime premium and the mileage per care hour.

How do I set my home care bill rate?

Divide the aide's full cost of one hour by one minus the gross margin you need: at 35 percent, a $20.83 hour needs at least $32.05.

How many hours does my agency need to break even?

Fixed weekly costs divided by the margin per billed hour; use the margin across all your payers, not the private pay margin alone.

Is this calculator really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The free workbooks of The Home Care Agency 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 Home Care Agency Owner. See the book.