A customer pays for a yearly pest plan, but you bill per visit. Divide the annual price by the number of treatments and you instantly see what each service call is really worth.
A $320 quarterly plan with 4 visits works out to $80 per treatment — the number you use to check margins and quote one-off calls.
The example
Four plan tiers, each with a yearly price and a visit count.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Plan | Annual price | Treatments / yr | Cost / treatment |
| 2 | Monthly | $540 | 12 | $45.00 |
| 3 | Bi-monthly | $360 | 6 | $60.00 |
| 4 | Quarterly | $320 | 4 | $80.00 |
| 5 | One-time | $150 | 1 | $150.00 |
The formula
Drag this down the table:
How it works
It is a single division, but it answers a real pricing question:
B2is the full price the customer pays for the year.C2is how many treatments that plan includes.- Dividing the two gives the revenue earned on each visit — compare it to your cost per stop to see the margin.
Quoting a single visit? Price it at or above your highest per-treatment figure so one-off calls never undercut the plans.
Try it: interactive demo
Enter an annual plan price and the number of visits.
Variations
Add a per-visit chemical cost
Subtract your material cost per stop to see true margin per visit.
Pitfalls & errors
A blank or zero in the treatments column returns #DIV/0!. Wrap it: =IF(C2=0,"",B2/C2).
Mixing taxable add-ons into the annual price inflates the per-visit number — divide only the recurring service charge.
Practice workbook
Frequently asked questions
How do I price a one-time visit?
What if a plan has variable visit counts?
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