Report this item to Etsy

Home Care Agency Startup Cost Calculator Excel Google Sheets, Pricing and Break Even Spreadsheet, Caregiver Bill Rate, Non Medical Business

Item highlights

  • Digital download
  • Digital file type(s): 1 PDF, 1 other file

Seller's description

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.

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.

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.
- Premium (overtime) pay is a planning setting, not a rule built into the file. Check federal and state wage and overtime rules for your agency before you set it.
- A planning tool for non-medical home care agencies, not payroll, tax, legal or financial advice. Confirm your rates with your payroll provider, insurance agent and accountant.
- Not affiliated with any software company, franchise, payer or state agency.
- Pairs with the Caregiver Timesheet and Payroll Hours Tracker and the Home Care Billing and Receivables Tracker in the shop.

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 AND NOTES
For use in your own business. Not for resale or redistribution. This is a planning and record-keeping tool, not payroll, tax, legal or financial advice. Built for Google Sheets and Excel on a computer; not tested in Apple Numbers. Because this is a digital product, returns are not accepted; if something does not work, message me and I will make it right.

Copyright UnitAndLedger.

View more
Etsy's Purchase Protection

If something goes wrong with an order, we've got your back for all eligible purchases. View program terms

NowPrice:$21.75

Original Price: $29.00

Loading

25% off

•

Sale ends in 6 days

You can only make an offer when buying a single item

Delivery

Instant download

Your files will be available to download once payment is confirmed. Here's how.

Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Seller's description

Specifications

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.

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.

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.
- Premium (overtime) pay is a planning setting, not a rule built into the file. Check federal and state wage and overtime rules for your agency before you set it.
- A planning tool for non-medical home care agencies, not payroll, tax, legal or financial advice. Confirm your rates with your payroll provider, insurance agent and accountant.
- Not affiliated with any software company, franchise, payer or state agency.
- Pairs with the Caregiver Timesheet and Payroll Hours Tracker and the Home Care Billing and Receivables Tracker in the shop.

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 AND NOTES
For use in your own business. Not for resale or redistribution. This is a planning and record-keeping tool, not payroll, tax, legal or financial advice. Built for Google Sheets and Excel on a computer; not tested in Apple Numbers. Because this is a digital product, returns are not accepted; if something does not work, message me and I will make it right.

Copyright UnitAndLedger.

  • Item type
    Digital download
  • Digital file type(s)
    1 PDF, 1 other file
Shop with confidence
Etsy Purchase Protection

If something goes wrong with an order, we've got your back on all eligible purchases. View program terms

Meet your seller

UnitAndLedger ·

Woodbridge, Virginia

No reviews yet
·
1 sale
·
New on Etsy