Free Excel templates

A free pool service business model in Excel, with a full worked case

The pool-month, route capacity and density, a management P&L with adjusted EBITDA and SDE, churn and lifetime value, break-even in accounts, pricing tests, a route purchase, seasons and working capital, a three-year plan and three offers for the company. Twelve sheets, no macros.

The file follows Clearwater Route Pool Service, a fictional company with 6 route technicians and 420 weekly residential accounts. Revenue is $1,483,370, adjusted EBITDA $242,445 (16.3%), and the average account leaves $57.76 of gross profit a month. The company breaks even at just under 200 accounts. 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.

Pool_Service_Business_Model_Clearwater.xlsx (28 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 Pool Service Business Owner. The book explains every assumption and every sheet: what a pool-month really costs, how to price an account, why density matters, how to control chemicals, how repairs carry the overhead, what churn costs, what a route is worth, and how three different buyers value the same company.

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

What is in the file

Twelve sheets, in the order the calculation runs. Blue type on a yellow fill is an input; black type is a formula.

Inputs
Accounts, price and chemicals; technicians, wages, burden and trucks; stops and minutes; commercial pools, repairs, filter cleans and green pools; churn and marketing; overhead and owner pay; working capital days; route purchase, plan, offer and seasonality assumptions.
Pool-Month
Price, chemicals, technician and truck per pool per month: $107.24 of direct cost and $57.76 of gross profit, and the same per weekly stop.
Routes
Capacity (450 weekly stops), route fill (95.1%) and the density test.
P&L
Revenue and direct costs by line, gross margin (38.2%), overhead, adjusted EBITDA, the EBITDA in the owner's books and SDE ($337,445).
Customers
New accounts needed, account life (5.6 years), lifetime value ($6,777 including repairs and filter cleans) and a churn target.
Break-even
Contribution per account after card fees and replacement marketing, and the accounts needed to cover overhead.
Pricing
A monthly price increase and a chlorine price rise, tested.
Route Purchase
Price, kept accounts, payback (3.4 years in the case), yield and price per kept account.
Cash
Quarterly revenue and EBITDA with seasonal chemicals and repairs; working capital (-$31,444).
Plan
2027 to 2029: accounts, technicians, new accounts to sign, revenue, EBITDA and margin.
Valuation
A consolidator's offer on adjusted EBITDA with an earnout, an individual buyer's offer on SDE with an SBA loan and a seller note, and a route sale.
Checks
Revenue ties, gross profit ties, quarters tie, SDE ties to EBITDA, and a comparison with the figures printed in the book.

Three things to try

Raise the price $10 a month. The model shows $48,888 more gross profit a year, and how many accounts (60 in the case) can leave before the increase stops paying.

Cut driving time. Lower the driving minutes per stop and see the weekly stops the same technicians can carry.

Price a route you are offered. Enter its accounts, the months of billing asked and your expected first-year loss, and compare the price per kept account with your own marketing cost per account.

Questions

Can it value a pool route I am offered?

Yes. In the case, 60 accounts at 12 months of billing cost $118,800; after a first-year loss of 15%, they pay back in 3.4 years of gross profit.

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 pool company?

Yes: replace every blue input. Clearwater and every figure in it are fictional case assumptions, not market data.

Related reading