Google Sheets + Excel spreadsheet

Home Care Pricing and Break-Even Calculator

Plan a non-medical home care agency with real numbers. List what it costs to open, work out what one caregiver hour really costs you after payroll taxes, workers' comp and premium pay, set bill rates that reach your target margin, and see how many billable hours and clients it takes to break even, month by month.

  • Start Here + 4 tabs
  • 2-page PDF guide
  • Formulas only, no macros
$29Buy on Etsy: Pricing and Break-Even Calculator

Price shown on Etsy at checkout may differ during a sale.

Instant download from Etsy.

Who it is for

Anyone planning a non-medical home care agency, or running one, who wants to check start-up funds, prices, margins and break-even with their own numbers, and see a month-by-month cash forecast.

What it does

  • Start-up costs: one-time items with planned and actual amounts, a working capital reserve (the months of overhead you choose) and a funding check against your cash and loans
  • Cost per caregiver hour from the pay rate, the share of hours paid at a premium, employer payroll taxes, workers' comp, benefits and other costs per hour such as mileage and supplies
  • Gross margin per hour and percent for each service type: companion care, personal care, memory care support, overnight, weekend, holiday and more (12 rows)
  • The bill rate that reaches your target margin, and how far each current rate is from it
  • Break-even: billable hours per month and per week, and the clients and caregivers needed at your blended margin, plus net profit at other weekly hours
  • 12-month forecast: weekly billable hours by month give revenue, direct labor, gross profit, overhead, net profit and a cash balance that allows for clients who pay the following month, with charts
  • Lowest cash point and first profitable month, so you can see whether your start-up funds are enough

Tabs

  • Start-Up Costs: One-time costs, planned and actual, plus a cash reserve and a funding check.
  • Pricing: Cost per caregiver hour, margin by service and the bill rate for your target margin.
  • Break-Even: Monthly overhead, and the billable hours, clients and caregivers you need.
  • 12-Month Forecast: Weekly hours by month: revenue, labor, profit and your cash balance.

What you get

Instant download, 2 files.

  • UnitAndLedger-Home-Care-Pricing-and-Break-Even-Calculator.xlsx: one spreadsheet file for Google Sheets and Excel. Formulas only, no macros, no add-ons, no subscription.
  • UnitAndLedger-Home-Care-Pricing-Calculator-Quick-Start-Guide.pdf: PDF quick-start guide (2 pages): how to open it in Google Sheets or Excel, the three steps to set up, and what each tab does.

What it is not

  • Not payroll, tax, legal or financial advice. Confirm your rates with your payroll provider, insurance agent and accountant.
  • Premium (overtime) pay is a planning setting, not a rule built into the file. Check the current federal and state wage and overtime rules for your agency before you set it.
  • Not affiliated with any software company, franchise, payer or state agency.
  • Built for Google Sheets and Excel on a computer; not tested in Apple Numbers.

Good to know

  • Room for 30 start-up items, 12 service types, 20 monthly overhead lines and a 12-month forecast.
  • Every rate is yours to set: payroll taxes, workers' comp, benefits, other cost per hour, premium hours and multiplier, and target margin. The sample numbers are invented for illustration; pay and bill rates vary widely by area.

How it works

  1. Buy and download instantly (Etsy emails a link; the files are also under Purchases and Reviews on etsy.com, not in the app).
  2. Google Sheets: upload the .xlsx file to Google Drive, open it, then choose File > Save as Google Sheets. Excel: open it in Excel 2016 or newer on Windows or Mac.
  3. Follow the Start Here tab or the PDF quick-start guide. The file opens with sample data so you can see how it works; clear it and type your own.

License

For use in your own business. Not for resale or redistribution. Because this is a digital item, returns are not accepted; if something does not work, message the shop on Etsy.

A look inside

Free tools and guides

Works with

Price shown on Etsy at checkout may differ during a sale.

Complete Start-Up Bundle

All ten products in one download

Seven document packs (263 pages of Word and PDF) and three spreadsheets, in one ZIP. The same files as the ten products sold separately. Bought one by one, the ten products are $350.

Price shown on Etsy at checkout may differ during a sale.