A free pressure washing business model in Excel, with a full worked case
Rig hours and jobs, revenue and chemicals for house washes, flatwork, roofs and commercial visits, the customer file and quote requests, a management P&L with adjusted EBITDA and SDE, a calculator for one job, break-even, price, chemical, wet-year and scheduling tests, seasons and working capital, a three-year plan with a fourth rig and two offers for the company. Twelve sheets, no macros.
The file follows Larkspur Exterior Cleaning, a fictional company with 3 wash rigs and 58 commercial accounts. Revenue is $998,474 from 2,101 jobs, adjusted EBITDA $208,472 (20.9%), and the company breaks even at 1,559 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 Pressure Washing Business Owner. The book explains every assumption and every sheet: why the rig hour is the unit of production, how size bands and add-ons fit together, why the small driveway needs a minimum, why chemicals matter more for the damage they do than for what they cost, what the customer file is worth, why commercial accounts belong in the mix, 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
Rigs, crew size, lead and helper wages, burden and paid hours; workable days, shop days, hours per rig-day and the share of hours spent on jobs; share, rig hours and chemicals by kind of job; house wash prices by size band; add-ons; flatwork and roof rates; commercial price and frequency; recovery and fuel; rig costs; the customer file, washing cycle and reminder response; close rate and cost per request; overhead and owner pay; terms; test, plan, offer and seasonality assumptions.
Rigs
Rig-days and rig hours available, average rig hours per job (2.20 in the case), jobs a year, jobs per rig-day, capacity, the average house wash at the size mix, add-ons, and crew time and fuel per job.
Jobs
For house washes, flatwork, roofs and commercial visits: jobs, revenue per job, revenue, chemicals and revenue per rig hour; commercial accounts.
Funnel
Households due, jobs from the customer file (850), jobs from new customers, quote requests (1,643), lead spend, and reminder and close rate tests.
P&L
Revenue, crews, chemicals, water recovery, fuel and rigs, gross margin (50.5%), overhead, adjusted EBITDA, the EBITDA in the owner's books and SDE ($293,472).
Job
Five jobs from the book: a two-story house wash, the same house on its repeat wash, a small driveway at the minimum, a roof soft wash and a gas station at night, with contribution and contribution per rig hour.
Break-Even
Contribution per job ($384.83) and per rig 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 chemical price increase, a wet year, and more rig 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: rigs, a new rig's first year, jobs, commercial accounts, revenue, quote requests, EBITDA and margin.
Valuation
A regional exterior 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 job. Enter the price, the rig hours and the chemicals; the Job sheet returns the contribution per rig hour, so you can compare a house, a driveway, a roof and a commercial visit on the same footing.
Raise every residential job $25. The model shows $40,961 more profit a year if the same jobs book, and that up to 5.5% of those jobs could be lost before the increase stops paying.
Take away 10 workable days. The wet-year test shows $35,927 of lost contribution, 17.2% of adjusted EBITDA, and the Cash sheet shows why a December cushion matters.
Questions
Can it price a house wash?
Yes. In the case, a 2,400-square-foot two-story house with gutter brightening is priced at $599 and contributes $315.70 after chemicals, crew time, fuel, card fee and lead cost; a 2,800-square-foot roof soft wash is priced at $1,176 and contributes $749.76.
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 pressure washing company?
Yes: replace every blue input, starting with your rig hours per job, your crew wages and your price list. Larkspur and every figure in it are fictional case assumptions, not market data.