Revenue & Calc
Set route days, daily slots, utilization, seasonal multipliers, tank-size shares, and prices. Calc turns these drivers into monthly and annual revenue.
Septic Pumping Service Financial Model Template for Excel and Google Sheets
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description
The Septic Pumping Service Financial Model is an Excel template for a one-truck residential pump-out business. It calculates monthly volumes and sales from route capacity, utilization, seasonality, tank-size mix, and prices, then links operating costs and financial reports.
The 2026–2030 Central Illinois case uses one roughly 3,000-gallon vacuum truck for 750- to 2,000-gallon residential pump-outs. Installation, excavation, confined-space entry, and repairs are excluded.
- Vacuum trucks
- 1shared route capacity
- Daily route slots
- 3pump-outs per workday
- Tank sizes
- 5priced service categories
- Forecast
- 5annual forecast periods
WORKBOOK CONTENTS
What Is Included in the Excel Model?
The linked worksheets turn service assumptions into monthly operating projections and management reports rather than treating revenue as an unsupported growth percentage.
COGS & OPEX
Keep disposal, diesel, maintenance, and consumables separate from processing fees, advertising, claims, and fixed overhead.
Payroll & CAPEX
Plan staff compensation by FTE and truck and equipment purchases separately from recurring costs.
Dashboard & Scenarios
Review KPIs and Low, Base, or High revenue and expense multipliers, not guaranteed outcomes.
IS, CF & BS
Review profit, cash movement, working capital, and funding on the linked financial statements.
Returns & Valuation
Explore break-even, payback, ROIC, DCF valuation, and sensitivities without equating EBITDA to investment return.
REVENUE PLANNING
How Are Septic Pumping Sales Forecast?
Sold pump-outs come from one truck’s shared monthly route capacity, not five independent pools of service capacity.
The model has 22 route days per month × 3 daily slots, or 66 potential pump-outs before utilization and seasonality. Booked utilization rises from 55% in 2026 to 80% in 2030.
Seasonal factors range from 0.70 in January and February to 1.20 in May and June, averaging 1.00 annually. The January 31, 2026 launch setting counts January as a full month, with one visit pool allocated across all tank sizes.
Revenue Forecast
The Revenue Forecast links route capacity, booked utilization, monthly seasonality, tank-size shares, and job prices to service volumes and sales. Its shared route-slot constraint prevents the five price categories from generating overlapping truck capacity.
| Tank size | Share of visits | Price per job |
|---|---|---|
| 750 gallons | 10% | $350 |
| 1,000 gallons | 40% | $400 |
| 1,250 gallons | 20% | $537.50 |
| 1,500 gallons | 20% | $625 |
| 2,000 gallons | 10% | $800 |
The 2,000-gallon share is the estimated residual. The mix implies a $507.50 weighted job price; listed prices remain constant in the illustrative forecast.
2026 base-case revenue example
22 days/month × 3 slots/day × 12 months × 55% utilization × $507.50 weighted fee = $221,067 in forecast revenue.
The model uses unrounded expected job volumes. Edit seasonality, route utilization, mix, or prices without adding truck capacity.
OPERATING COSTS
How Are Disposal, Truck Costs and Payroll Modeled?
The model charges service-related costs as percentages of revenue, fixed overhead by month, and staff salaries on a separate payroll schedule.
Direct COGS equal 29% of revenue: disposal 14%, diesel and fluids 9%, maintenance 5%, and consumables/PPE 1%. Variable costs add 5.5% for card processing, advertising, and rework or claims.
Fixed overhead includes yard rent, insurance, dispatch, accounting, compliance, and security. Yard rent is $1,200 monthly; total fixed expenses are $30,600 annually.
COGS and Operating Expenses
The COGS and Operating Expenses forecast separates disposal and truck expenses, variable selling costs, and monthly overhead. Compare their effect on EBITDA as route utilization changes.
Base salaries are separate from other operating expenses: one owner-operator at $65,000 annually and 0.35 dispatcher FTE at a $42,000 full-time-equivalent salary.
Payroll Forecast by Staff Role
The Payroll Forecast tracks roles, FTE, and salaries. The 1.35 total FTE produces $79,700 in annual base payroll; employer taxes, benefits, and personal taxes are excluded.
STARTUP FUNDING
How Are Truck Purchases and Opening Funding Planned?
Initial equipment investment and opening cash requirements are scheduled separately from annual septic pumping operating expenses.
Startup assets total $116,000: $105,000 for a used vacuum truck, $6,000 for hoses and field equipment, $3,000 for locating tools, and $2,000 for office computers.
Capital Expenditure Plan
The Capital Expenditure Plan schedules truck and equipment purchases outside operating costs, then tracks depreciation for eligible assets in accounting reports below EBITDA.
Opening owner funding is $172,553, with no outside commitment assumed. It covers assets, preopening permits, yard deposit, launch marketing, setup, working capital, and a three-month recurring cash reserve.
Sources and Uses of Funds
The Sources and Uses of Funds report tracks owner contributions, entered financing, operating uses, and investments. It clarifies how equipment, preopening expenses, and cash reserves are financed.
Working-capital controls are three receivable days, zero payable days, and one inventory day. They affect cash timing, not EBITDA or proof of cash sufficiency.
ILLUSTRATIVE PROJECTIONS
What Does the Five-Year Forecast Show?
The base-case example projects rising pump-out volume and EBITDA as utilization increases while service prices and fixed payroll remain unchanged.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $221,067 | $186,568 | $34,499 |
| 2027 | $261,261 | $200,435 | $60,826 |
| 2028 | $281,358 | $207,369 | $73,989 |
| 2029 | $301,455 | $214,302 | $87,153 |
| 2030 | $321,552 | $221,235 | $100,317 |
The projections are illustrative planning outputs, not observed industry results. Amounts are rounded to whole dollars; display rounding may create small differences.
In 2026, $221,067 of forecast revenue yields approximately $34,499 EBITDA after $186,568 of operating expenses. By 2030, revenue reaches $321,552 and EBITDA approximately $100,317 as truck utilization rises.
The illustrated operating case ends at EBITDA. Although the workbook includes linked financial statements, these example outputs do not establish net profit, closing cash, or borrowing outcomes.
Cash Flow Forecast
The Cash Flow Forecast analyzes monthly receipts and payments across operating, investing, and financing activities. Review it alongside the three-day receivable assumption, truck purchases, equity contributions, and any debt entries when judging liquidity.
DECISION ANALYSIS
Can You Evaluate Break-Even, Payback and Scenarios?
The workbook separately examines break-even, investment recovery, returns, scenarios, and valuation.
Returns separates sales break-even from cash break-even, cumulative payback, and annual ROIC. Covering route operating costs does not repay the truck investment.
Dashboard Low, Base, and High controls vary revenue and expense categories. Valuation explores DCF and terminal assumptions; no payback date, ROIC, IRR, or valuation amount is established by the supplied case.
Break-Even, Payback and ROIC
The Returns analysis distinguishes sales break-even, cash break-even timing, investment payback, and annual ROIC. It supports questions about whether additional booked routes justify the startup investment without treating EBITDA as a cash return.
USE CASE
Who Can Adapt This Septic Pumping Model?
The model fits planning for an owner-operated residential septic pump-out route using one vacuum truck and shared daily service capacity.
Compare route schedules, fees, staffing, disposal, and funding. Replace estimated Central Illinois inputs with verified quotes and local operating data.
Installation, excavation, repairs, and confined-space work are not included. Apply the template where its pump-out scope and one-truck capacity fit.
FREQUENTLY ASKED QUESTIONS
Questions About the Septic Pumping Financial Model
These answers clarify how to adapt the included operating assumptions and interpret the linked reports.
Can I change pump-out prices and tank-size mix?
Yes. The Revenue inputs include separate job prices and volume shares for 750-, 1,000-, 1,250-, 1,500-, and 2,000-gallon pump-outs.
Does each tank size get separate truck capacity?
No. All five categories share one truck’s route slots; monthly visits are allocated by the selected tank-size mix.
Can I edit utilization and winter seasonality?
Yes. Monthly route capacity, annual utilization assumptions, and repeating January–December seasonality control forecast service volume.
Are driver and dispatcher salaries included?
Yes. The selected case includes one owner-operator and 0.35 dispatcher FTE; their base salaries are recorded in Payroll, not duplicated in operating expenses.
Does the model include buying the vacuum truck?
Yes. The CAPEX plan includes a $105,000 used truck and other startup equipment, separate from recurring operating costs.
Can it forecast cash flow and borrowing?
Yes. The workbook includes monthly cash-flow reports and debt controls; the illustrative case assumes owner funding and does not establish an actual loan.
Is the projected EBITDA the same as take-home profit?
No. EBITDA excludes depreciation, interest, taxes, and other items, and it is different from net profit and cash flow.
Does this include septic installation or repair sales?
No. The operating case models standard residential pump-outs only; installation, excavation, confined-space entry, and repair services are outside scope.
What Does the Septic Pumping Financial Model Contain?
Financial Dashboard
KPIs, forecasts, and cash flow at a glance.
Revenue Engine
Key assumptions and calculations driving revenue forecasts.
Sources & Uses
Funding sources, spending, and closing cash.
Returns & Break-Even
Cash break-even, payback, and ROIC.
Business Valuation
DCF valuation and sensitivity analysis.
Expense Breakdown
Largest costs and spending trends.
Financial Summary
Annual and monthly financial performance.
KPI Benchmarks
Compare margins and returns to benchmarks.
Trusted by 25,000+ startup founders, investors and CPAs
Clear Investor Structure
This template gave me the exact sections I needed, so I stopped guessing what investors wanted. I built the deck faster and had a clean model ready for the next meeting.
One Clean Reporting Pack
My statements and charts were all over the place before this. Now everything sits in one file, and I cut about 4 hours from monthly reporting.
Better Cash-Flow Planning
I could finally see runway and shortfalls without manually piecing together cash flow every time. That made planning a lot clearer and saved me from a few bad assumptions.