Evaluate a plumbing Excel model with customer, hour and pricing inputs, then test a one-van repair case against paid labor, route capacity and opening cash.
The planning decision is whether collected service work can support a licensed working owner, a supervised helper and one service van after parts and nonbillable time. The documented Excel model uses customer cohorts, billable hours and hourly rates. The worked StartFigures job case below supplies a separate capacity check and shows what must be reconciled before the file fits a residential repair route.
Editable Excel workbook; native file and compatibility were not inspected.
Documented horizon
Five-year projections with monthly detail.
Documented outputs
Income statement, cash flow, balance sheet, scenario analysis and management reporting.
Input evidence
Current Revenue image shows online/offline acquisition, customer lifetime, service hours and hourly prices.
Scope bridge
A separate collected-job view checks parts, associated visits, travel and one-van capacity.
The current exact product description and readable Revenue image were inspected. The service rows include emergency repair, new installation, maintenance and diagnostics. This confirms a customer-hour engine, not job-level dispatch, stock accounting, formula accuracy, software compatibility or paid delivery. The website case narrows the offer and requires the stated adaptations. Product documentation and case sources · checked .
How the plumbing business model builds revenue
The documented engine obtains new clients from marketing spend divided by acquisition cost, allocates them to service cohorts, keeps them active for the entered lifetime, and multiplies monthly billable hours by service hourly prices.
Establish customer acquisition
Enter marketing budgets, launch timing and channel acquisition costs. Distinguish a lead from an acquired paying client; repeat customers do not count as new acquisition again.
Define real service activity
Starting clients and retained cohorts create the active base by service. Replace the sample lifetime and allocation with evidence of actual repair repeat behavior. A household with no work in a month has no billable service hours merely because it remains on a customer list.
Translate hours into retained revenue
Use actual billed service hours and realized hourly rates. Reconcile invoiced parts, fixed job prices and diagnostics separately so an all-in job invoice is not also added as hourly revenue.
Check the paid route independently
Map each completed job to hands-on work, travel, access, returns and supervision. Paid owner/helper hours and one-van elapsed capacity constrain saleable work even when a cohort forecast produces more demand.
This documented hourly planning engine is not a dispatch optimizer or proof of recurring repair demand. The website uses collected jobs including parts, with returns counted once. Flat-rate invoice and materials mapping requires inspection/adaptation of the actual file; if it cannot be reconciled, use a job-based custom structure before relying on the financial outputs.
What to edit and what to look for
Read these planning areas together: extra sales only help when the retained margin, staffing and funding can support them.
Customer acquisition, hours and revenue
Builds service revenue from acquired customers, their retained activity, billable hours and rates. The website worked case separately counts completed jobs.
Inputs to replace
Marketing budget and acquisition cost
Starting customers and service allocation
Customer lifetime and monthly hours
Hourly price by service
Outputs to review
New and active customers
Billable service hours
Monthly and annual revenue
How to interpret the result
A repair customer must not be billed repeatedly merely because the lifetime input keeps that customer active.
Customer hours do not enforce a route or supervised-helper schedule. Map collected jobs to labor hours, parts and associated visits before relying on the forecast.
Parts and operating costs
Connects service-linked costs and recurring overhead to the selected operating case.
Inputs to replace
Parts and consumables
Payment and route-fuel costs
Recurring insurance, storage and software
Marketing and upkeep
Outputs to review
Direct costs and contribution
Fixed operating costs
Operating margin
How to interpret the result
The web case includes parts revenue and cost consistently in each net invoice; a material-heavy installation mix needs its own cost evidence.
Percentage costs cannot substitute for supplier invoices, callback records or a written insurance quote.
Payroll and supervision
Schedules the licensed owner, helper, pay and employer costs against actual service coverage.
Inputs to replace
Role and employment status
Hours, pay and start dates
Employer costs and leave cover
Licensed and supervised duties
Outputs to review
Paid labor cost
Hiring/ramp cost timing
Staffing assumptions for the forecast
How to interpret the result
One helper and one van do not create a second independent revenue resource.
The roster must cover travel, estimates, purchasing, documentation and administration as well as hands-on work.
Capital and funding
Times the van, equipment, setup, inventory and financing against opening cash.
Inputs to replace
Van and tool purchases
Opening stock and deposits
Reserve and funding sources
Debt and replacement assumptions
Outputs to review
Opening uses of funds
Cash flow and funding requirements
Balance-sheet effects
How to interpret the result
An opening allocation is not a delivered quote or minimum cash guarantee.
Collections, inventory payment, tax and debt timing need a local dated schedule.
Scenarios and operating threshold
Compares demand, hours, rates and cost cases before adding field capacity.
Inputs to replace
Low, base and high assumptions
Realized rate and service mix
Contribution and fixed costs
Owner and helper coverage
Outputs to review
Scenario revenue and EBITDA
Operating break-even
Sensitivity comparisons
How to interpret the result
A numerical threshold beyond the route clock is not operationally attainable.
The shared website calculator is a simpler completed-job sensitivity and does not reproduce native cohort formulas.
Statements and management views
Brings the operating and funding assumptions into financial statements and reporting.
Inputs to replace
Selected operating case
Working capital
Financing and tax settings
Reporting period
Outputs to review
Income statement
Cash flow and balance sheet
Dashboard and management reports
How to interpret the result
Seller documentation and visible inputs establish these planning areas; the native file was not audited.
Positive EBITDA does not establish owner cash, investment recovery, lending approval or successful transactions.
StartFigures worked case · U.S. · illustrative assumptions
From sales assumptions to operating break-even
This website example combines a realized sales amount per sold unit with daily throughput. It makes the operating threshold easy to inspect; the purchased workbook uses the more detailed revenue structure described above.
Volume-only sensitivity · same $410.00 per completed plumbing job, 75.0% contribution and trading calendar
Volume case
Completed plumbing jobs/day
Mature monthly operating surplus
First operating break-even month
Lower volume
1
−$8,343
Not reached within 12 months
Base volume
3
$4,972
Month 7
Higher volume
4
$11,630
Month 5
At 75.0% contribution, $15,000 of monthly fixed costs requires $20,000 in monthly realized sales: at least 3 completed plumbing jobs per trading day at $410.00 per completed plumbing job. The assumed ramp first covers those monthly operating costs in month 7.
The shared example links one net completed-job invoice and a feasible one-van workload to contribution before paid owner/helper labor and recurring overhead. Parts, travel and callbacks remain part of that same completed outcome.
The annual path sums the same monthly startup ramp and uses paid owner/helper work and overhead from launch. The first three years reconcile with the shared 4.33-week convention within whole-dollar rounding. Later selected pay and price changes are separate annual assumptions.
A lower retained invoice can make the threshold exceed sustainable field time before it exceeds the slider maximum. Price changes, lower parts retention or a longer route need a revised mix and paid schedule before an extra daily job is assumed.
The cash reserve is available for the opening ramp, not an extra expense deducted again from EBITDA. Confirm actual collections, parts purchases, tax, debt and replacement timing before relying on available cash.
Year 1 operating EBITDA is −$12,234; Year 3 is $59,665 on $319,554 of revenue (18.7% margin). The opening allocation is $125,000. Operating break-even does not recover that investment, and EBITDA does not establish cash available to distribute.
Plumbing Business income statement · annual USD
Income statement
Year 1
Year 2
Year 3
Year 4
Year 5
Revenue
$223,688
$319,554
$319,554
$335,142
$350,730
Parts, payment fees, route fuel and job-linked rework
−$55,922
−$79,889
−$79,889
−$83,786
−$87,683
Paid working owner, helper and employer costs
−$135,000
−$135,000
−$135,000
−$141,000
−$147,000
Van, insurance, storage, dispatch, marketing and administration
A plumbing operator whose acquisition, active clients and hourly service economics can be represented by the documented inputs.
An advisor comparing paid staffing, ordinary overhead, funding and slower demand under a consistent service scope.
A residential repair team prepared to reconcile completed invoices, parts and associated visits to native billable hours.
Adapt the structure when
Remove unsupported commercial, recurring maintenance, round-the-clock and smart-monitoring assumptions.
Set actual customer retention and repeat service frequency; lifetime is not permission to invoice every customer each month.
Keep job-level scheduling, permits, parts records and callback tracking separately unless their actual native handling is verified.
A construction backlog, fixed membership, sewer fleet or material-heavy project operation needs a separately supported structure.
Start with these edits
Start with the permitted service menu
List work the owner and helper may lawfully and safely perform. Remove unsupported gas, excavation, root, commercial and emergency coverage before entering sales.
Reconcile invoices to hours
Record labor, parts, discounts, credits, diagnostic-only work and return visits for each closed job. Translate that ledger into customer-hour inputs without inventing repeat billing.
Build a paid weekly roster
Reserve time for travel, supervision, parts, estimates, records and administration. Test the selected mix against the same owner and helper hours paid in payroll.
Stress the field constraint and cash
Test a lower invoice, more parts, longer routing and callback days while keeping paid roles visible. Add actual collections, taxes, debt and replacement spending before presenting returns.
Both products in one cart
Model + Business Plan
Write the strategy and test the assumptions for your plumbing business together. Update the narrative when you change the forecast.
The Business Plan uses Word and the Financial Model uses Excel. The online illustrations use this website's scenario data and may differ from the purchased files.
Listed file format
XLSX
Editor
Microsoft Excel
Editing
Adapt forecast assumptions in Excel. Check the selected version's forecast length, worksheets and formula permissions; the online illustrations use a separate scenario.
Other software
Compatibility with alternative editors has not been verified.
Delivery and terms
Review the product description, delivery details, license and final total in Shopify before paying.
Its documented Revenue inputs use customer acquisition, active cohorts, monthly billable hours and hourly prices. The website completed-job calculator is a separate simplified sensitivity. Do not copy the daily job count into a customer lifetime or hour field.
Can I use it for flat-rate repairs?
Only after reconciling each retained repair invoice to the actual workbook structure. Parts and fixed diagnostic charges need consistent treatment, and repeated trips must not create repeated revenue. A material mismatch requires adapting the structure.
Will active customers automatically create recurring monthly income?
The template multiplies active customers by the entered monthly hours. Ordinary repair clients do not necessarily buy monthly work. Replace sample lifetime and hours with actual frequency and keep months without billable work at zero.
Does hiring a helper double capacity?
No. The one-van case keeps the owner on technical and supervisory work. The helper can assist and restock within local rules; an independent additional route requires licensed cover, another vehicle, more costs and its own paid demand.
What is included in the worked contribution?
The scenario subtracts parts/consumables, payments, route fuel and job-linked rework before fixed paid owner/helper labor and overhead. Its contribution is not net income or a withdrawal amount.
What was checked about the file?
Current product documentation and readable Revenue inputs were checked. Native formulas, exact file inventory, software compatibility and paid delivery were not audited. The StartFigures figures are independently authored assumptions to replace with local evidence.
