Pest Control Services Model

Operating Businesses Financial Model (Free Excel Download)

Forecast pest-control growth from customers, recurring routes, service frequency, pricing, technician productivity, retention, chemical costs, hiring, and branch EBITDA.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model is built for a pest-control operator that earns recurring revenue from residential and commercial customers. It shows how new customers, retention, service mix, technician capacity, and branch growth work together to build a larger business.

Use it to test an organic growth plan or a multi-branch acquisition strategy. The model turns those operating assumptions into revenue, profitability, cash flow, and valuation.

What every model includes

Live formulas, no hardcoded values

Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.

All assumptions in one tab

Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.

Statements always balancing

For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.

Distinct schedules for clarity

Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.

No hidden macros or external links

There are no unexplained external workbook links or macros to undermine auditability or portability.

Changes flow through the model

Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.

What's inside the Pest Control Services Model

  • Branch inputs: Year-1 branches, new branches per year, opening customers, adds per branch, customers per technician, support staff per branch
  • Customer base: annual churn rate, an acquisition ramp from a Year-1 input to a practical ceiling
  • Service tiers: residential, commercial, termite-and-wildlife, and specialty shares of the installed base
  • Price indices and gross margins: per-tier price index off the blended annual contract value and a materials gross margin
  • Non-recurring revenue: initial setup fee per new customer, ancillary product income per customer, price escalation
  • Cost structure: technician and support wages, benefits, wage growth; vehicle and fleet, sales and marketing, technology, and corporate SG&A as % of gross profit; depreciation (% of revenue); tax
  • Capital and working capital: maintenance capex %, branch build-out cost, NWC % of revenue growth, base-year revenue
  • Valuation: WACC, terminal growth, net debt, shares outstanding

How the Pest Control Services Financial Model Works

This pest control financial model projects seven years of operations for a multi-branch pest-control operator. It connects customer acquisition, retention, and service mix to revenue, costs, cash flow, and valuation.

The template shows how a recurring customer base compounds and what that means for enterprise value, making it useful for evaluating organic growth or acquisition strategies.

Operating Drivers: Customer Base and Branch Expansion

The model's foundation is the recurring customer base. Each year, closing customers equal opening customers plus gross adds minus churn, with churn defined as a percentage of the opening base.

  • Gross adds depend on the number of branches, adds per branch, an acquisition ramp that seasons new branches, and a density factor that limits growth as a branch approaches a customer-per-branch ceiling. This roll-forward makes the installed base the primary revenue driver, not one-off jobs.
  • Branch count also grows, anchoring route capacity and support staffing.

Calculation Flow: From Customers to Revenue

Average customers—the midpoint of opening and closing—form the billing base. Revenue blends four service lines: residential recurring, commercial recurring, termite & wildlife, and specialty.

  • Each line applies a segment mix, a blended annual contract value, a price index, and annual price escalation. Two non-recurring lines sit on top: initial setup fees charged on each gross add and per-customer ancillary products.
  • Together they produce total revenue, reflecting both recurring contracts and first-visit premiums.

Cost Structure and Profitability

The P&L separates materials from field labour.

  • Cost of materials is calculated per tier using tier-specific gross margins, which run high because technician labour sits below in opex.
  • Gross profit then absorbs a geared overhead stack: technician and support labour (driven by FTE counts and wage escalation), plus vehicle, sales and marketing, technology, and corporate SG&A costs, each as a percentage of gross profit.
  • Depreciation, tax, and net income follow, giving EBITDA and net margins.

Cash Flow, Valuation, and Practical Use

Unlevered free cash flow starts from EBIT, deducts unlevered taxes, adds back depreciation, and subtracts maintenance capex, new-branch build-out capex, and changes in net working capital.

  • Discounting at WACC with a Gordon-growth terminal value yields enterprise value, then equity value and value per share after a net-debt bridge.
  • Practically, you can flex churn, branch openings, service mix, or pricing to see how enterprise value, EBITDA margin, and revenue per customer respond, supporting organic or acquisition scenarios.
income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

Formatted to IB standards

Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.

Alex Tapio, ex-Deloitte financial modelling expert

Created by ex-finance professionals

Hey, I’m Alex and I created Finamodel.

Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.

Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.

I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.

Having a template library on hand cuts a first build from hours to minutes.

Need help finding your model? You’ll find me in the Finamodel app!

Frequently asked

What is a pest-control model?+

A pest-control model captures the seven-year operating economics and intrinsic value of a multi-branch pest-control services operator (recurring residential and commercial contracts plus termite-and-wildlife and specialty work). It rolls a branch count forward, rolls a recurring customer base forward through gross adds on an acquisition ramp and annual churn, ties technicians to the base through a route-density ratio, splits the average base across a residential, commercial, termite-and-wildlife, and specialty mix priced off a blended annual contract value and a per-tier price index, layers one-time setup fees and ancillary income, nets materials cost into gross profit, runs the cost stack to EBITDA, and discounts an unlevered free-cash-flow stream to enterprise value, equity value, and value per share.

Why does the recurring base matter so much?+

Because most pest-control revenue comes from customers on auto-renewing service contracts, so the size of the installed base, not a one-off volume of jobs, is what drives the top line. The base rolls forward as opening customers plus gross adds less annual churn, and since churn scales with the base while adds scale with the branch network, the retention rate and the net-add curve are the key compounding levers. The model carries churn, adds per branch, and the acquisition ramp as explicit inputs so an analyst can stress retention and acquisition and watch revenue, gross profit, and the EBITDA margin move.

How is pest-control revenue built?+

Revenue starts with the base: closing customers equal opening customers plus gross adds less churn, and average customers are the mean of opening and closing. Recurring service revenue is then the sum across tiers of average customers times each tier share times a blended annual contract value times its price index, escalated at a step-up rate. One-time initial setup fees and per-customer ancillary product income layer on top to total revenue.

Why an unlevered DCF for a pest-control operator?+

A pest-control book is sticky and cash-generative, but growth is part de-novo and part acquired while contracts and receivables tie up some cash, so build-out capex and the change in working capital are real calls on cash and EBITDA overstates free cash flow in expansion years. The model bridges to unlevered free cash flow, NOPAT plus depreciation, less maintenance and new-branch build-out capex, less the change in working capital, and discounts it at a WACC with a Gordon-growth terminal value. The implied EV/EBITDA falls out as a sanity check rather than as the valuation input.

Can I model a single branch or a commercial-only operator?+

Yes. For a single branch, set the group to one branch and size the opening customers, adds, tier mix, and headcount to that route; for a commercial-only operator, lift the commercial tier share and its annual contract value and let the residential and specialty lines run light. The net-debt line already bridges enterprise value to equity value, so a financing layer slots in cleanly.

How does the customer-base roll-forward work?+

Opening customers plus gross adds (closing branches x adds-per-branch x acquisition ramp) minus annual churn (opening customers x churn rate) equals closing customers. Average customers is the mean of opening and closing and is the billing base for revenue and labour. Year 1 opening customers are an input; in subsequent years they carry from the prior closing.

What is the acquisition ramp and why is it included?+

New branches take time to fill their routes. The ramp is a utilisation factor that starts below the mature adds-per-branch rate in Year 1 (88% base case) and seasons to a ceiling (96%) over time, so gross adds from new branches are suppressed until they mature. This prevents the model from overstating adds and understating the early-year cash drag of branch expansion.

How is technician headcount calculated?+

Technicians equal average customers divided by the customers-per-technician route-density input (1,650 in the base case). This ties field labour directly to the recurring customer book rather than to branch count, which is how route-based operators actually staff. Support staff are separate and scale with closing branches at 6 staff per branch.

What are realistic EBITDA margins for a pest-control operator?+

Listed benchmarks such as Rollins and Rentokil run EBITDA margins in the 18-24% range at scale. Independent operators and younger platforms typically run 12-18%. The model base case reflects a maturing multi-branch platform; flex the route density, churn rate, and overhead ratios to calibrate to a specific operator.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview