Home Care Agency Startup Cost Calculator Excel Google Sheets, Pricing and Break Even Spreadsheet, Caregiver Bill Rate, Non Medical Business
Item highlights
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.
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
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 typeDigital download
-
Digital file type(s)1 PDF, 1 other file
If something goes wrong with an order, we've got your back on all eligible purchases. View program terms
Meet your seller
More from this shop
-
Digital download
Med Spa Operations and Safety Bundle, Aesthetic Clinic Policy Manual, OSHA Safety Manual, Intake Forms, Privacy Kit, Handbook, Excel
Sale Price $111.75
Original Price $149.00
-
Digital download
Med Spa Employee Handbook and Hiring Packet, Aesthetic Clinic Job Descriptions, Job Application, Offer Letter, Onboarding Forms, Word
Sale Price $29.25
Original Price $39.00
-
Digital download
Med Spa Privacy Kit, Notice of Privacy Practices Template, HIPAA Worksheet, Breach Log, Aesthetic Clinic Privacy Forms and Policies, Word
Sale Price $29.25
Original Price $39.00
-
Digital download
Med Spa Intake Forms, Health History Questionnaire, General Consent Form, Aesthetic Clinic Client Forms, Financial Policy, Editable Word
Sale Price $29.25
Original Price $39.00
-
Digital download
Med Spa Policy and Procedure Manual, Aesthetic Clinic Operations Policies Template, 49 Policies, Medical Spa Business, Editable Word PDF
Sale Price $44.25
Original Price $59.00
-
Digital download
Med Spa OSHA Safety Manual, Bloodborne Pathogens Exposure Control Plan, Hazard Communication Program, Aesthetic Clinic Template, Word
Sale Price $44.25
Original Price $59.00