A free window cleaning business model in Excel, with a full worked case
Crew hours and jobs, house prices by the window with the minimum and the add-ons, revenue for houses, storefront routes and low-rise buildings, 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, wet-year and scheduling tests, seasons and working capital, a three-year plan with a fourth crew and two offers for the company. Twelve sheets, no macros.
The file follows Ashgrove Window Company, a fictional company with 3 two-person crews, 100 storefront accounts and 52 low-rise buildings. Revenue is $774,921 from 2,618 jobs, adjusted EBITDA $133,379 (17.2%), and the company breaks even at 2,087 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 Window Cleaning Business Owner. The book explains every assumption and every sheet: why the crew hour is the unit of production, how the price per window and the minimum fit together, why inside work earns less per hour and is still worth selling, what a ladder claim does to payroll, what the customer file is worth, why storefront routes are a game of density, why the first quarter loses money, 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
Crews, crew size, lead and technician wages, burden and paid hours; workable days, days lost, hours per crew-day and the share of hours spent on jobs; share, crew hours and supplies by kind of job; windows per house and the size mix; price per window outside only and inside and out; the minimum; add-ons; route and building prices and frequencies; lift rentals and fuel; van 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
Crew-days and crew hours available, average crew hours per job (1.78 in the case), jobs a year, jobs per crew-day, capacity, and crew time and fuel per job.
Jobs
House prices by size with the minimum applied, add-ons, and for each kind of work: jobs, revenue per job, revenue, supplies and revenue per crew hour; route and low-rise accounts.
Funnel
Households due, jobs from the customer file (600), jobs from new customers, quote requests (1,343), lead spend, and reminder and close rate tests.
P&L
Revenue, crews, supplies, lift rentals, fuel and vans, gross margin (48.6%), overhead, adjusted EBITDA, the EBITDA in the owner's books and SDE ($213,379).
Job
Six jobs from the book: a two-story house inside and out, the same house a year later, a small ranch at the minimum, a dense route day, a medical office and an atrium that needs a lift, with contribution and contribution per crew hour.
Break-Even
Contribution per job ($251.49) 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 a ladder claim, a wet year, 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: crews, a new crew's first year, jobs, route accounts, revenue, quote requests, EBITDA and margin.
Valuation
A regional building 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 house. Enter the price, the crew hours and the supplies; the Job sheet returns the contribution per crew hour, so you can compare a house, a route day and a building on the same footing.
Raise every residential job $20. The model shows $24,083 more profit a year if the same jobs book, and that up to 4.3% of those jobs could be lost before the increase stops paying.
Take away 10 workable days. The wet-year test shows $28,133 of lost contribution, 21.1% of adjusted EBITDA, and the Cash sheet shows why a December cushion matters.
Questions
Can it price a house cleaning?
Yes. In the case, a two-story house with 34 windows cleaned inside and out, with screens and tracks, is priced at $629 and contributes $275.02 after supplies, crew time, fuel, card fee and lead cost; a small ranch at the $225 minimum contributes $59.80.
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 window cleaning company?
Yes: replace every blue input, starting with your crew hours per job, your wages and your price list. Ashgrove and every figure in it are fictional case assumptions, not market data.