A free septic service business model in Excel, with a full worked case
Truck hours and jobs, revenue and gallons by kind of job, the aerobic contract and repair line, the reminder list and new requests, a management P&L with adjusted EBITDA and SDE, a calculator for one truck job, break-even with and without the service line, price, disposal fee, plant distance and routing tests, seasons and working capital, a three-year plan with a fourth truck and two offers for the company. Thirteen sheets, no macros.
The file follows Hollis Creek Septic, a fictional company with 3 pump trucks and 620 aerobic service contracts. Revenue is $1,881,491 from 2,809 truck jobs and the service line, adjusted EBITDA $422,515 (22.5%), and the company breaks even at 1,547 truck jobs a year. Every figure in the book is computed here, and every input can be replaced with your own.
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.
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 Septic Service Business Owner. The book explains every assumption and every sheet: why the truck hour is the unit of production, how the price by tank size and the digging fee fit together, why the plant's fee and distance matter, why a riser makes the next pump-out cheaper, what the reminder list is worth, how the aerobic contracts lower the break-even, why the first quarter barely breaks even, and how two different buyers value the same company.
Thirteen sheets. Blue type on a yellow fill is an input; black type is a formula.
Inputs
Trucks, operator wage, burden and paid hours; operating days, shop days, hours per truck-day and the share of hours spent on jobs; truck hours and share by kind of job; tank mix and prices; digging, filter and riser fees; inspection fee; grease trap price and gallons; disposal fees per 1,000 gallons; diesel; truck costs; the technician, aerobic contracts and repairs; the customer file, pumping cycle and reminder response; close rate and cost per request; overhead and owner pay; terms; test, plan, offer and seasonality assumptions.
Trucks
Truck-days and truck hours available, average truck hours per job (1.88 in the case), truck jobs a year, jobs per truck-day, capacity, tanks per truckload, the average pump-out price and extras, and operator time and fuel per job.
Jobs
For residential pump-outs, inspections and grease traps: jobs, revenue per job, revenue, gallons and disposal.
Service
Contract and repair revenue, technician hours and technicians needed, contribution per contract and per repair, service gross margin (48.6%) and contribution.
Funnel
Households due, jobs from the reminder list (924), jobs from new customers, new requests (1,970), lead spend and a reminder response test.
P&L
Revenue, operators, disposal, fuel, trucks, risers and the service line, gross margin (41.6%), overhead, adjusted EBITDA, the EBITDA in the owner's books and SDE ($517,515).
Job
Three truck jobs from the book: a routine pump-out, a real estate inspection and a restaurant grease trap, with contribution and contribution per truck hour.
Break-Even
Contribution per truck job ($334.76) and per truck hour, fixed costs, the service line's share, break-even with and without it, margin of safety, and the jobs that pay the office manager and the insurance.
Tests
A price increase against lost jobs, a disposal fee increase, a longer trip to the plant, and more truck hours on jobs.
Cash
Quarterly revenue and EBITDA; receivables on inspections and grease accounts, the disposal payable, prepaid contracts and a cash cushion.
Plan
2027 to 2029: trucks, a new truck's first year, contracts, technicians, truck jobs, revenue, new requests, EBITDA and margin.
Valuation
A regional environmental services company's offer on adjusted EBITDA with an earnout, an individual buyer's offer on SDE with an SBA loan and a seller note, the loan payment and its coverage, and the equipment value.
Checks
Shares add up, gross profit ties, quarters tie, SDE ties, and a comparison with the figures printed in the book.
Three things to try
Price your next job. Enter the tank, the digging, the gallons and the hours; the Job sheet returns the contribution per truck hour, so you can compare a pump-out, an inspection and a grease trap on the same footing.
Raise every residential and inspection job $25. The model shows $57,581 more profit a year if the same jobs book, and that up to 6.1% of those jobs could be lost before the increase stops paying.
Change the disposal fee or the distance to the plant. Add $15 per 1,000 gallons or 20 minutes per unload and watch the break-even move.
Questions
Can it price a septic pump-out?
Yes. In the case, a routine pump-out of a 1,000-gallon tank with the lids dug is priced at $480 and contributes $225.70 after disposal, operator time, fuel, card fee and lead cost; a real estate inspection on a 1,500-gallon tank is priced at $960 and contributes $604.01.
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 septic company?
Yes: replace every blue input, starting with your disposal fee, your truck hours per job and your prices by tank size. Hollis Creek and every figure in it are fictional case assumptions, not market data.