Customers, churn and revenue by line, technician capacity and utilization, a management P&L with adjusted EBITDA and SDE, what a customer is worth, a three-year plan and two offers for the company. Eight sheets, no macros.
The file follows Copperline Pest Solutions, a fictional company with 7 technicians and 2,407 residential customers on quarterly plans. Revenue is $2,014,752, adjusted EBITDA $500,750 (24.9%), and each residential customer contributes $312.48 a year. The team runs at 80.7% of capacity, with room for 931 more customers before the next hire.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
Pest_Control_Business_Model_Copperline.xlsx (21 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 Pest Control Business Owner. The book explains every assumption and every sheet: how to price a plan and test an increase, why churn moves the value more than sales, how density changes the cost of a stop, when to hire, and how two different buyers value the same company.
DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide
Eight sheets, in the order the calculation runs. Blue type on a yellow fill is an input; black type is a formula.
Lower churn. Set churn to 17%: average customer life rises from 4.76 years to 5.88 years and lifetime contribution from $1,488 to $1,838, with no change in price or cost.
Test a price increase. At 5%, the increase brings $57,497 a year; the model shows that about 170 customers would have to cancel because of it before it stops paying.
Add customers in or out of your routes. 400 customers inside existing routes contribute $186,792 a year; if they need a new technician and truck, $102,992.
Adjusted EBITDA counts the owner's role at a market manager's pay and gives $500,750 for Copperline. SDE adds back the owner's whole pay and personal expenses and gives $595,750. Consolidators value the first; owner-operators the second.
No macros and no circular reference. It recalculates in Excel, LibreOffice or Google Sheets.
Yes: replace every blue input. Copperline and every figure in it are fictional case assumptions, not market data.