A free carpet cleaning business model in Excel, with a full worked case
Crew hours and jobs, home prices by the room with the minimum and the add-ons, revenue for standard and restorative homes, apartment turnovers and offices, the customer file and quote requests, a management P&L with adjusted EBITDA and SDE, a calculator for one job, break-even, price, workers' compensation, breakdown and scheduling tests, seasons and working capital, a three-year plan with a fourth truck and two offers for the company. Twelve sheets, no macros.
The file follows Larkfield Carpet Care, a fictional company with 3 trucks and two-person crews, 31 property management accounts and 59 office accounts. Revenue is $835,356 from 2,343 jobs, adjusted EBITDA $138,419 (16.6%), and the company breaks even at 1,873 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.
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 Carpet Cleaning Business Owner. The book explains every assumption and every sheet: why the crew hour is the unit of production, how the price per room, the restorative rate and the minimum fit together, why the first visit to a new household barely pays and the second pays well, what back claims and truck-mount breakdowns cost, what the customer file is worth, why apartment turnovers are a game of density, why the first quarter is thin, and how two different buyers value the same company.
Twelve sheets. Blue type on a yellow fill is an input; black type is a formula.
Inputs
Trucks, crew size, lead technician and helper wages, burden and paid hours; working days, days lost per truck, hours per day and the share of hours spent on jobs; share, crew hours and chemicals by kind of job; rooms per home and the size mix; price per room for standard and restorative cleaning; the minimum; stairs, upholstery and protector; turnover and office prices and frequencies; commercial extras and fuel; truck costs; the customer file, cleaning cycle and reminder response; close rate and cost per request; overhead and owner pay; terms; test, plan, offer and seasonality assumptions.
Crews
Truck-days and crew hours available, average crew hours per job (2.07 in the case), jobs a year, jobs per truck-day, capacity, and crew 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, chemicals and revenue per crew hour; property management and office accounts.
Funnel
Households due, jobs from the customer file (854), jobs from new customers, quote requests (1,010), lead spend, and reminder and close rate tests.
P&L
Revenue, crews, chemicals, commercial extras, fuel and trucks, gross margin (45.8%), overhead, adjusted EBITDA, the EBITDA in the owner's books and SDE ($218,419).
Job
Six jobs from the book: a five-room restorative cleaning with stairs, the same home on its next visit, a two-room apartment at the minimum, a turnover day in one community, a dental office visit and a large office night, with contribution and contribution per crew hour.
Break-Even
Contribution per job ($294.42) and per crew hour, fixed costs, break-even in jobs and revenue, margin of safety, and the jobs that pay the office manager, the insurance and one crew.
Tests
A price increase against lost jobs, a higher workers' compensation burden after back and slip claims, a year of truck-mount breakdowns, and more crew hours on jobs.
Cash
Quarterly revenue and EBITDA with commercial work spread evenly; commercial receivables, payables and the December cash cushion.
Plan
2027 to 2029: trucks, a new truck's first year, jobs, property management accounts, revenue, quote requests, EBITDA and margin.
Valuation
A regional cleaning and restoration 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 crew hours and the chemicals; the Job sheet returns the contribution per crew hour, so you can compare a home, a turnover day and an office on the same footing.
Raise every residential job $20. The model shows $27,181 more profit a year if the same jobs book, and that up to 5.7% of those jobs could be lost before the increase stops paying.
Take away 10 working days per truck. The breakdown test shows $28,390 of lost contribution, 20.5% of adjusted EBITDA, and the Cash sheet shows why a repair float matters.
Questions
Can it price a carpet cleaning job?
Yes. In the case, a five-room home with pet urine, cleaned at the restorative rate with one staircase, is priced at $485 and contributes $162.21 after chemicals, crew time, fuel, card fee and lead cost; a two-room apartment at the $195 minimum contributes $30.83.
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 carpet cleaning company?
Yes: replace every blue input, starting with your crew hours per job, your wages and your price list. Larkfield and every figure in it are fictional case assumptions, not market data.