Free Excel templates

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

Seven revenue lines, the calendar by month, supplies and energy per piece, plant hours from production standards and the machine’s capacity, the route and commercial accounts, staffing and payroll, a P&L with adjusted EBITDA and SDE, break-even and four stresses, the quarters and the line of credit, a purchase and an opening, a second drop store and two offers for the business.

The file follows Wexcombe Cleaners & Tailoring, a fictional independent dry cleaner with a plant store of 3,400 sq ft, a drop store, a pickup and delivery route and 12 commercial accounts. It earns revenue of $1,465,468 and EBITDA of $188,131 (12.8%) and breaks even at 78.3% of its volumes. Every figure in the book comes from this model; replace the inputs with yours and the whole case recalculates.

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.

Dry_Cleaning_Model_Wexcombe.xlsx (93 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 Dry Cleaning Business Owner. The book explains every assumption and every tab: why a suit and a shirt cannot be priced by one rule, what a garment never collected costs, how the plant is staffed from its standards, why the counters cost the same on a quiet morning, what the route fee does and does not pay for, which trips a 17-year-old may not drive, why the insurance bill draws the line in the first quarter, what a second drop store costs, and how two buyers would value the business.

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

What is in the file

Fourteen tabs, in the order of the book’s appendix A. Every input is a blue cell on the first tab; every other cell is a formula.

Assumptions
Opening hours, units and prices, channels, commercial accounts and the route, the share never collected, costs per piece and rates, card terms, production standards and the machine, payroll, occupancy and other costs, the loan and the line, distributions, the month shares, the 2022 purchase and an opening budget, the plan and the new drop store, the stresses and the two offers.
Revenue
Units times average price for each stream, commercial pieces and route fees, tickets and the average garment ticket ($1,465,468 in the case).
Calendar
Revenue by month and by quarter, from 7.0% of the year in August to 9.3% in May.
Supplies and Energy
Pieces processed, sold plus never collected, times the cost per piece of each kind of work ($139,478), supplies on hand and purchases.
Production and Capacity
Plant hours from the production standards, station by station, and the machine’s hours against its capacity (75% in the case).
Route and Commercial
Route orders, fees and driver hours, the shuttle, the average cost of a route order ($11.08), commercial receivables, bad debts and the card fee base.
Schedule and Payroll
Counter hours from the opening hours, hours worked and paid with sick leave, pay with burden and the count toward fifty.
P&L
Revenue, variable costs, contribution, fixed costs, EBITDA, adjusted EBITDA and SDE ($278,039).
Break-Even and Stresses
The share of 2026 volumes at which EBITDA is zero (78.3%), and the year rerun with lower volumes, dearer supplies and energy, higher wages and fewer commercial pieces.
Cash by Quarter
Four quarters: the insurance premium paid in the first, loan payments, tax distributions on the tax calendar, the line and the cash floor, and the volume stress.
Purchase and Opening
The 2022 purchase, sources equal to uses, and a new cleaner’s first year with receivables built from zero, at two levels of volume.
Plan and Drop Store
2027 to 2029 with and without the second drop store: EBITDA, coverage, working capital, the line quarter by quarter, the store’s own EBITDA and its reserve.
Valuation
A cleaner’s offer on adjusted EBITDA and an individual buyer’s offer on SDE, supplies at cost added once, the cash the seller keeps, the buyer’s coverage test and the buyer’s whole project.
Checks
Internal checks, the tests of the case (the line, reserves, distributions, the machine, the buyer’s coverage) and a comparison with every figure printed in the book.

Three things to try

Make supplies and energy dearer. Set the per-piece cost stress: fifteen percent more for supplies, packaging and energy, at unchanged prices, takes EBITDA from $188,131 to $167,209 in the case.

Lose a third of the commercial pieces. The commercial stress takes EBITDA to $169,817: one lost account matters less than a quiet year.

Cut the volumes. Set the volume stress and read the line of credit: in the case it would go $29,387 past its limit, while distributions cut to the tax and deferred capital spending keep it within.

Questions

Does it count garments that are never collected?

Yes. They carry supplies, packaging and energy but bring no revenue and no cash.

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 cleaner?

Yes: replace every blue input, starting with your pieces, prices, costs per piece, standards and opening hours. Wexcombe and every figure in it are fictional case assumptions, not market data.

Related reading