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.
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.
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
Twelve sheets, in the order the calculation runs. Blue type on a yellow fill is an input; black type is a formula.
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.
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.
No macros and no circular reference. It recalculates in Excel, LibreOffice or Google Sheets.
Yes: replace every blue input. Clearwater and every figure in it are fictional case assumptions, not market data.