SmartHelping / Plumbing Business / Excel
Plumbing Business Financial Model
Turn service demand into a 10-year financial plan. Forecast jobs, revenue, plumber headcount, truck requirements, and operating costs, then review monthly and annual financial statements and investment returns.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
Walk through the plumbing business forecast.
See how service tiers, job growth, staffing, truck costs, and overhead connect to the financial statements and return analysis.
Service demand and workforce planning
Build revenue from jobs, ticket values, and capacity.
Up to three service tiers
Configure three service lines with different skill requirements and services. Set revenue assumptions, variable costs, wages, and benefits for each tier.
Starting jobs and monthly growth
Enter starting monthly job completions for each tier. Define monthly job growth and adjust that growth rate by year.
Average ticket value
Set the average amount charged per job for each tier to connect service volume with revenue.
Hours required per job
Define the average hours needed to complete a job. This assumption drives wage costs and helps you assess the implied workload.
Jobs per plumber per month
Define how many jobs a plumber in each tier can complete monthly. This capacity assumption drives the required plumber headcount and truck count.
Connected scaling assumptions
Review job volume, labor time, and monthly job capacity together so the staffing and truck requirements reflect your operating plan.
Labor, trucks, and overhead
Separate costs per job, per plumber, and per truck.
Combine these operating assumptions with the CapEx and debt schedules to plan truck purchases and funding.
Hourly wages by service tier
Set the hourly wage for plumbers in each tier. Combine the wage assumption with the hours required per job.
Payroll taxes and benefits
Configure taxes and benefits separately for each service tier.
Equipment and materials per job
Enter the average equipment and material costs associated with completing a job.
Other monthly variable costs
Define other costs that scale with plumber headcount or truck count.
Truck insurance and maintenance
Set monthly insurance and maintenance costs per truck so fleet-related expenses grow with the operation.
Credit-card processing
Define the share of revenue paid by credit card and the applicable processing fee assumptions.
Sales and marketing
Use the fixed-cost schedule to plan sales and marketing overhead.
General and administrative costs
Plan fixed administrative expenses separately from job-level and workforce-related costs.
Sanity-check the operating plan
See what the job assumptions imply for each plumber.
The Revenue Assumptions area brings the resulting operating metrics together, making it easier to spot unrealistic job volumes or workloads as you configure the forecast.
Hours per plumber
Review average hours worked per plumber to understand the workload implied by the job assumptions.
Monthly earnings
Review average monthly earnings per plumber alongside the wage and hours assumptions.
Annual jobs completed
Check the annual job volume produced by the starting job count and growth rates.
Year-end headcount and trucks
See the plumber and truck counts required as the business scales.
Hours per workday
Review average hours worked per workday per plumber as a practical check on the service-capacity assumptions.
Up to 10 years of financial reporting
Follow operating assumptions through cash flow and returns.
Three financial statements
Review monthly and annual income statements, balance sheets, and cash-flow statements.
Detailed pro forma
Review the monthly and annual forecast detail behind the financial reports.
DCF and investment returns
Review annual discounted cash-flow analysis for the investor, owner, or investor group, along with IRR and return on invested capital.
Annual executive summary
Bring the main annual financial results together for review.
Key metric visualizations
Use the included charts to review and communicate the financial forecast.
Cap table
Review the capitalization table alongside the investment and return analysis.
CapEx schedule
Plan capital expenditures, including the truck purchases needed for the business.
Debt schedule
Review the debt schedule alongside the operating forecast and cash-flow statements.
Make the forecast your own
Start with the clearly marked input areas.
Review the workbook’s operating and financial outputs as you enter assumptions to keep the forecast consistent with your scaling plan.
Find the light-yellow tabs
Tabs containing input cells are light yellow, and the input cells are clearly marked.
Replace the example assumptions
Enter your own assumptions in every relevant area and zero out anything that does not apply to your plumbing business.
How to use the model
Move from job assumptions to a complete business forecast.
Define the service mix and demand
Configure up to three service tiers. Enter starting monthly job counts, growth rates, and average ticket values.
Set labor time and service capacity
Enter hours per job and jobs per plumber per month, then define wages, payroll taxes, and benefits by tier.
Plan operating costs and funding
Enter materials, other variable costs, truck insurance and maintenance, credit-card fees, and fixed overheads. Review the CapEx and debt assumptions.
Check capacity and review the forecast
Review hours, earnings, annual job volume, and year-end plumber and truck counts. Then examine the monthly and annual statements, cash flow, and return analysis.
Who this model is for
Plan a plumbing business at different stages of growth.
Plumbing owners, operators, and planners
Model how service demand translates into revenue, plumbers, trucks, operating costs, and financial performance.
Similar service businesses
The structure may also fit an electrician business closely. Adapt the service tiers, job capacity, wages, and costs to the operation you are planning.
Also available in these bundles
Need more templates for service-business planning?
The Plumbing Business Financial Model is included in the Industry-Specific and Service Business bundles, as well as the complete Super Smart collection.
Industry-Specific Spreadsheet Bundle
Explore financial models built around the operating drivers of different industries.
View the Industry-Specific bundleService Business Template Bundle
Explore financial models for plumbing and other service businesses.
View the Service Business bundleSuper Smart Bundle
Explore the complete public SmartHelping financial model collection.
View the Super Smart BundleAdditional SmartHelping resources
Explore the supporting tools and explanations.
These links lead to separate templates or articles for further planning and analysis.
Excel Accounting System
Explore a separate accounting-system template for financial-statement reporting.
View the resourceHR and Headcount Planner
Explore a separate human-resources planning and tracking tool.
View the resourcePayroll Tracker and Calculator
Explore a separate template for payroll calculation and budgeting.
View the resourceUnderstanding Cap Tables
Read how a capitalization table represents ownership and investment.
View the resourceCustomer Spend and Retention
Explore a separate model for customer spending and retention patterns.
View the resourceQuestions before you start
A few useful details.
How long is the forecast?
The model supports up to 10 years of monthly and annual financial reporting.
How many service tiers can I configure?
You can configure up to three service tiers, each with its own revenue assumptions, variable costs, plumber wages, and benefits.
What drives plumber headcount and truck count?
The average jobs a plumber can complete each month, together with the projected job volume, drives the required headcount and truck count. Average hours per job drives wage costs and the implied workload.
Can I check whether the workload is realistic?
Yes. The Revenue Assumptions area shows resulting metrics including hours worked, monthly earnings per plumber, annual job completions, year-end headcount and truck count, and hours per workday.
Which financial reports are included?
The workbook includes monthly and annual financial statements and pro forma detail, annual DCF and return analysis, an annual executive summary, charts, a cap table, and CapEx and debt schedules.
Could this work for an electrician business?
The model’s service-business structure may fit an electrician operation closely. Adjust the service tiers, job assumptions, wage rates, costs, and capacity assumptions to reflect that business.
How do I start entering assumptions?
Use the light-yellow tabs to locate input areas. Replace the relevant assumptions with your own and zero out unused inputs.
How is the spreadsheet delivered?
The model costs $45 as a one-time purchase and is available for immediate Excel download after purchase.
Plan the next stage of your plumbing business
Connect jobs, people, trucks, and cash flow.
Plumbing Business Financial Model — $45, one-time purchase.
