Recurring plans are the backbone of a pest route. Add the initial service to the follow-up visits times their rate and you have each plan's yearly value — the number routes are built on.
A quarterly plan — $150 initial plus three $110 visits — is worth $480 a year per door.
The example
Three plan types, each with an initial fee, follow-up count, and per-visit rate.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Plan | Initial | Follow-ups | $ / visit | Annual value |
| 2 | Quarterly plan | $150 | 3 | $110 | $480 |
| 3 | Bimonthly plan | $150 | 5 | $95 | $625 |
| 4 | Monthly plan | $125 | 11 | $55 | $730 |
The formula
One add, one multiply:
How it works
Year one is the initial plus the rest of the schedule:
B2is the initial service — usually priced higher for the first-visit work.C2is the number of follow-up visits in the first year (3 for quarterly).C2*D2values those visits; adding the initial gives the annual contract value.
Renewal-year value drops the initial: just Visits*Rate with a full visit count.
Try it: interactive demo
Enter the initial fee, follow-up visits, and per-visit rate.
Variations
Renewal-year value
After year one there is no initial — a full year of regular visits.
Route value
SUM the annual-value column across every account on a route.
Pitfalls & errors
Count follow-ups, not total visits — a quarterly plan is 1 initial + 3 follow-ups, and double-counting the initial inflates the value 20%+.
Track year-one and renewal-year value separately; renewal value is what an acquirer actually pays for.
Practice workbook
Frequently asked questions
Why is the initial priced higher?
What is a route worth?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class