Trusted by 25,000+ startup founders, investors and CPAs
Scenario Planning Made Simple
Daniel Harper, TX
This template made low, base, and high case planning easy to compare without rebuilding the sheet three times. I saved about 4 hours and could talk through each assumption with my team in one meeting.
Cash Flow Is Easier To See
Megan Ellis, FL
I finally had a clear view of runway and shortfalls for the duct cleaning business, month by month. It helped me spot a funding gap early and plan the next 6 months with a lot less guesswork.
Easy To Use Right Away
Brian Collins, AZ
I’m not strong in advanced Excel, so having the formulas and structure already built saved me a lot of stress. I was able to update the model in under an hour without hiring help.
Model review
What is the financial model of sewer cleaning?
It's an editable five-year Excel and Google Sheets workbook that transforms assumptions about customers, billing times, prices, costs, and staff into financial forecast.
Use the workbook to plan how customer acquisition, service demand, billable hours, prices, operating expenses, and employability are shaping the projected financial outcomes of canal cleaning operations.
The editable assumptions provide revenue sources and operational schedules that are linked to the model financial statements, scenario views and management table.
Built around the service economyRevenue results from active customer cohorts, billable hours and hourly rates, not upside-down percentage of sales growth.
revenue engine of the customer cohort
How does the drainage model calculate revenue?
This model converts marketing-focused customer cohorts into active customers, billable hours of service, monthly level-level sales and total revenue across forecast.
01
Get customers
New customers equals marketing expenditure divided by CAC, using monthly seasonality.
02
Building Cohorts
Designate new customers by level and hold each cohort for a certain lifetime.
03
counting hours
Active customers multiply the average monthly billing hours for each service level.
04
Use of rates
Settlement activities are multiplied by the hourly rate to obtain monthly revenue.
05
Total revenue
Revenue are summed at each service level and month in the forecast period.
Basic formulaRevenue = Active clients × hours per client × hourly rate
01 / Revenue
How do revenue build forecasts on the cleanliness of the canals?
The revenue article combines marketing expenditure, CAC, customer cohort, mix of services, customer retention period, billable hours and hourly rates for forecasting sales.
Revenue
The revenue article indicates the customer acquisition, the activity of the cohort, the billable hours and the price of shipments.
02 / COGS & OPEX
What are the cost structures for cleaning the canals?
The COGS & OPEX article organizes direct costs, Variable Costs and Fixed operating expenses which flow to forecast margins and profitability.
COGS & OPEX
The COGS and OPEX articles separate direct costs, Variable Costs and Fixed operating expenses.
03 / Scenarios
What's there to compare in scenario analysis?
The scenario compares low, basic and high cases with respect to revenue, gross margin, contribution margin and EBITDA with respect to forecast.
Scenarios
The scenario charts compare the low, basic and high revenue, margin and EBITDA paths.
04 / Dashboard
What Does the Dashboard Bring Together?
The basic panel combines in a single report administered by configuration controls, scenario multipliers, core finances, a mix of revenue, cash flow, profitability and earnings prospects.
Dashboard
The table summarises scenario controls, financial results, the revenue mix, cash flow and profitability.
Product adjustment
Is the financial model of sewer cleaning right for you?
The template is suitable for channel cleaning enterprises using customer cohort economics and hourly billing; different structural revenue logics, operations or reporting may require individual modelling.
Model ready
It fits perfectly
You get customers through marketing and CAC.
Revenue results from active customer groups, billable hours and hourly rates.
You want an editable allocation of service level, customer lifetime and pricing assumptions.
You're planning costs, salaries, scenarios, reports, and board views.
Order structure
Think about the model
Revenue depend on fixed labour prices, subscriptions, visitation fees or other non-work structures.
Customer retention requires behaviour beyond the specified lifetime of the cohort.
Operations require specialized crew flow, equipment capability or multi-location logic.
The report shall require timetables or results beyond the current workbook structure.
The indicator is the starting point for planning, not a guarantee of performance.
Financial modelling service for orders
Do you need a pattern that meets your requirements?
The Financial Model Laboratory may construct or adapt the model where it needs a different revenue logic, operational timetable or reporting than that provided for in this template.
Once you've made the money, you'll get a downloadable financial model Duct Cleaning with its five-year forecast, scenario analysis and related financial statements.
01
Book to be edited
Work with a fully editable sheet template in Excel or Google Sheets.
02
forecast 5-year
A five-year action plan with monthly trends and annual financial prospects.
03
Analysis of scenarios
Compare the Low, Base and High cases using edited operational assumptions.
04
Financial statements
A review of the related income statement, cash flow and balance sheet reports.
Before purchase
Cleaning up the financial channels FAQ
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does the model calculate the revenue from cleaning the canals?
Revenue start with marketing-based customer acquisition, assign and retain customer cohorts, transform active customers into billable hours and apply hourly rates at service level.
02
Which assumptions can I change?
You can edit the launch date, initial customers, marketing budget and seasonality, CAC, level allocation, customer usage time, billable hours and hourly rates.
03
What can I compare between low, basic and high scenarios?
Alternative revenue, gross margins, contribution margins and EBITDA paths can be compared throughout forecast.
04
What financial results are taken into account?
The product presents the income statement, the cash flow report, the balance sheet, the dashboard, the summary and additional views on the financial analysis.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab offers individual modeling when you need a different revenue logic, operational schedule or reporting.
06
Is the book a prediction or a guarantee?
It's forecast, not a guarantee. The predicted outcomes change as the model assumptions change.
What Does the Duct Cleaning Financial Model Contain?
This downloadable financial template for cleaning services includes everything you need to build a comprehensive financial plan for your duct cleaning business.
All-in-one Dashboard
Core inputs and core outputs
Low/Base/High
Three scenario analysis
Professional Charts
Presentation ready
ROE Components
DuPont analysis
Revenue Inputs
Researched revenue assumptions
Bank-Ready Reports
Lender-friendly financial outputs
Revenue Breakdown
Revenue stream detailed view
KPI Dashboard
Performance metrics benchmark
Choosing a selection results in a full page refresh.
Revenue
COGS & OPEX
Scenarios
Dashboard
