Free Excel templates

A free house cleaning business model in Excel, with a full worked case

Team hours and jobs, home prices per bedroom and bath with the minimum and the add-ons, revenue for recurring visits, deep cleans, move-outs and rental turnovers, the recurring client file and churn, quote requests, a management P&L with adjusted EBITDA and SDE, a calculator for one job, break-even, price, workers' compensation, call-out and scheduling tests, seasons and working capital, a three-year plan with a seventh and an eighth team and two offers for the company. Twelve sheets, no macros.

The file follows Brightwell Home Cleaning, a fictional company with 6 two-person teams, 146 recurring clients, 33 property manager and agent accounts and 7 vacation rentals. Revenue is $1,038,041 from 4,235 jobs, adjusted EBITDA $176,577 (17.0%), and the company breaks even at 3,407 jobs a year. Every figure in the book is computed here, and every input can be replaced with your own.

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

House_Cleaning_Business_Model_Brightwell.xlsx (33 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 file is the worked case of The House Cleaning Business Owner. The book explains every assumption and every sheet: why the team hour is the unit of production, how the price per bedroom and bath, the deep clean rate and the minimum fit together, why the first deep clean barely pays and the recurring visit pays well, what churn costs, why drive time is paid and how to cut it, what injury claims and call-outs cost, why rental turnovers are a game of density, and how two different buyers value the same company.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is in the file

Twelve sheets. Blue type on a yellow fill is an input; black type is a formula.

Inputs
Teams, team size, team lead and cleaner wages, burden and paid hours; working days, days lost per team, hours per day and the share of hours spent on jobs; share, team hours and products by kind of job; units per home and the size mix; price per unit for recurring visits and deep cleans; the minimum; oven, refrigerator and interior window add-ons; move-out and turnover prices and frequencies; linen handling and fuel; car costs; visits per recurring client and churn; close rate and cost per request; overhead and owner pay; terms; test, plan, offer and seasonality assumptions.
Teams
Team-days and team hours available, average team hours per job (2.30 in the case), jobs a year, jobs per team-day, capacity, and team time and fuel per job.
Jobs
Home prices by size with the minimum applied, add-ons, and for each kind of work: jobs, revenue per job, revenue, products and revenue per team hour; accounts and rental properties.
Clients
Recurring clients (146), clients lost at the churn, the share of deep cleans that must turn recurring, quote requests (770), lead spend, and churn and close rate tests.
P&L
Revenue, teams, products, linen handling, fuel and cars, gross margin (40.4%), overhead, adjusted EBITDA, the EBITDA in the owner's books and SDE ($251,577).
Job
Six jobs from the book: a first deep clean, the same home on its first recurring visit, a one-bedroom apartment at the minimum, a turnover day in one resort community, a move-out of an empty house and a construction clean, with contribution and contribution per team hour.
Break-Even
Contribution per job ($213.23) and per team hour, fixed costs, break-even in jobs and revenue, margin of safety, and the jobs that pay the office manager, the insurance and one team.
Tests
A price increase against lost visits, a higher workers' compensation burden after injury claims, a bad year of call-outs, and more team hours on jobs.
Cash
Quarterly revenue and EBITDA with account work spread evenly; receivables, payables and the December cash cushion with a payroll float.
Plan
2027 to 2029: teams, a new team's first year, jobs, recurring clients, revenue, quote requests, EBITDA and margin.
Valuation
A regional home services company's offer on adjusted EBITDA with an earnout, an individual buyer's offer on SDE with an SBA loan and a seller note, the loan payment and its coverage, and the equipment value.
Checks
Shares add up, gross profit ties, quarters tie, SDE ties, and a comparison with the figures printed in the book.

Three things to try

Price your next home. Enter the price, the team hours and the products; the Job sheet returns the contribution per team hour, so you can compare a deep clean, a recurring visit, a move-out and a turnover day on the same footing.

Raise every recurring visit $10. The model shows $32,186 more profit a year if the same visits stay, and that up to 5.2% of those visits could be lost before the increase stops paying.

Lower churn from 30% to 22%. The Clients sheet shows 12 more recurring clients kept each year and 129 visits kept in the first year alone, before the gain compounds.

Questions

Can it price a house cleaning job?

Yes. In the case, the first deep clean of a three-bedroom, two-bath home with the oven and the refrigerator is priced at $460 and contributes $121.59 after products, team time, fuel, card fee and lead cost; a one-bedroom apartment at the $150 minimum contributes $73.54.

Does it use macros?

No macros and no circular reference. It recalculates in Excel, LibreOffice or Google Sheets.

Can I use it for my own cleaning company?

Yes: replace every blue input, starting with your team hours per home, your wages and your price list. Brightwell and every figure in it are fictional case assumptions, not market data.

Related reading