Free Excel templates

A free pest control business model in Excel, with a full worked case

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.

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.

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.

The book behind this model

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

What is in the file

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

Inputs
Customers, churn, prices by line, technicians and trucks with their costs, stops per day and the weights for each type of work, overhead, owner pay, plan and offer assumptions.
Customers and Revenue
The residential roll-forward (2,050 at the start, 880 added, 523 cancelled) and revenue by line, with the recurring share (76.8%).
Capacity
Work in residential-equivalent stops (15,596 needed against 19,320 available), utilization, spare capacity and the cost per stop ($38.62).
P&L
Direct costs, gross margin (60.6%), SG&A, adjusted EBITDA, the EBITDA in the owner's books and seller's discretionary earnings ($595,750).
Unit Economics
Contribution per customer, life, lifetime contribution, LTV/CAC (6.2x), payback, the price increase test and the density comparison.
Plan
2027 to 2029: customers, revenue, technicians hired at 85% utilization, EBITDA and margin.
Valuation
A consolidator's offer on EBITDA with a retention holdback, an individual buyer's offer on SDE with an SBA loan and a seller note.
Checks
The roll-forward balances, revenue lines tie, SDE ties to EBITDA, and a comparison with the figures printed in the book.

Three things to try

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.

Questions

What is the difference between adjusted EBITDA and SDE?

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.

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

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

Related reading