The Plumbing and HVAC Financial Model is an Excel template for a US residential and light-commercial repair and replacement contractor. It turns technician-hour capacity, utilization, seasonality, service mix and realized revenue per field labor-hour into monthly sales projections and linked reports.
The illustrative contractor expands from four field technicians in 2026 to eight in 2030. It excludes new construction, storefront retail and franchise fees; the figures are editable planning estimates, not historical results.
The template combines editable job economics, expense and hiring plans, capital spending, financing controls, and management reports.
Revenue inputs set capacity, utilization, monthly seasonality, service-hour allocation and realized prices. Calc applies those assumptions month by month, assigning the sold hour pool across six services once rather than multiplying it by six.
Cost schedules separate parts, subcontractors, variable charges and monthly overhead from role-based staffing. Payroll plans technician, owner-manager and dispatch FTE and salary costs without adding those salaries again to direct costs.
CAPEX schedules vehicles, tools and depreciation, while CapTable records owner contributions. Dashboard debt controls feed financing schedules, but the illustrative funding amount does not imply a confirmed external loan.
Income Statement, Cash Flow, Balance Sheet and Summary provide connected financial reporting. Checks identifies reconciliation or input issues; the source example supplies operating results through EBITDA, not specific net profit or cash balances.
One pool of billable field labor-hours is allocated among six plumbing and HVAC services, then multiplied by each service’s realized revenue per hour.
For 2026, the plan starts with 640 available field labor-hours per month and 55% billable utilization, or 352 sold hours before seasonality. Annual capacity increases to 1,280 monthly available hours and utilization rises to 70% by 2030.
The seasonal multipliers lift or reduce monthly work, including stronger summer demand and softer spring or fall periods. Service shares sum to 100% of sold hours, so plumbing repairs, installations and HVAC work compete for the same available technician capacity.
The Revenue Forecast links the shared technician-hour pool, billable utilization, monthly seasonality, service mix and realized price per hour. Adjusting a repair or replacement mix changes projected revenue without creating extra available field hours.
| Service | Hour mix | Revenue / hour |
|---|---|---|
| Plumbing repairs | 28% | $180 |
| Drain services | 12% | $170 |
| Water heater installation | 10% | $375 |
| HVAC repairs | 22% | $210 |
| HVAC maintenance | 10% | $150 |
| HVAC replacement | 18% | $500 |
These are estimated realized revenues per field labor-hour, not employee hourly wages or separate technician-hour pools.
352 base sold hours/month × $259.50 weighted realized revenue/hour × 12 total seasonal-factor months = $1,096,128.
The forecast separates parts and subcontracting, revenue-linked job costs, fixed overhead, and salaried staffing to calculate operating EBITDA.
COGS assume parts and equipment at 30% of revenue and specialist subcontracting at 2.5%. Variable expenses include collection charges at 2%, fuel at 1.8%, lead generation at 2.5%, and warranties and callbacks at 1.2%.
Fixed monthly expenses cover rent, utilities, insurance, vehicle maintenance, software, communications, professional services, training, marketing and expansion leases. Illustrative rent grows from $2,500 to $2,900 per month by 2030.
The COGS and Operating Expenses forecast separates revenue-based parts, subcontracting and variable service charges from recurring fixed overhead. This allows the operator to examine which costs rise with job volume and which need separate monthly budgets.
Technician FTE grow from four to eight at $70,000 annual base pay per FTE. The owner-manager remains one FTE at $80,000; dispatch increases from one to 1.5 FTE at $48,000 per FTE.
Payroll totals $408,000 in 2026 and $712,000 in 2030 without duplicating listed COGS. Employer taxes, benefits and personal taxes are outside this case’s assumptions.
The Payroll Forecast organizes technicians, the owner-manager and dispatch personnel by staffing level and annual base salary. Hiring dates, annual FTE plans and available payroll controls connect staff expansion to monthly personnel expenses and operating margins.
Opening vehicles, tools, prelaunch cash needs and working-capital assumptions are modeled separately from the annual operating expense forecast.
Opening assets include four used service vans for $140,000, tools for $30,000, drain equipment for $16,000, and shop storage and security for $8,000. Computers and dispatch hardware are also planned without a specified amount.
Prelaunch cash covers permits, shop deposit, marketing, preopening pay, setup and insurance. Working-capital controls assume eight receivable days, 22 payable days and 13 inventory days, feeding funding and liquidity schedules.
The Capital Expenditure Plan schedules van purchases, equipment, other assets and applicable depreciation. It helps distinguish investment in service capacity from the recurring payments included in operating expenses.
Estimated owner funding is $481,227 for assets, opening cash, net working capital and three months of first-year recurring outflows. No confirmed outside funding is deducted; equity is not revenue or EBITDA.
The Sources and Uses of Funds report examines where cash comes from and how it is allocated to operating needs, assets, debt payments and retained cash. Owner funding and optional debt schedules can be evaluated without treating equity contributions as sales.
This case illustrates how rising field-hour availability, utilization and realized service prices flow through the operating expense plan from 2026 to 2030.
| Year | Revenue | Operating expenses | EBITDA |
|---|---|---|---|
| 2026 | $1,096,128 | $938,851 | $157,277 |
| 2027 | $1,539,562 | $1,205,305 | $334,257 |
| 2028 | $2,061,466 | $1,515,146 | $546,320 |
| 2029 | $2,591,517 | $1,828,967 | $762,550 |
| 2030 | $3,140,339 | $2,138,296 | $1,002,043 |
Illustrative estimates rounded to whole dollars. EBITDA equals revenue less the documented direct, variable, fixed and payroll operating expenses; displayed rounding can create small differences.
Illustrative revenue rises from $1,096,128 in 2026 to $3,140,339 in 2030 with more available field hours, utilization and realized revenue per hour. Parts, job costs, payroll and overhead also increase.
EBITDA rises from $157,277 to $1,002,043, but excludes depreciation, interest and taxes. It is neither net profit nor free cash flow and does not establish cash sufficiency.
The Cash Flow Forecast tracks collections, operating payments, capital investment, equity contributions, borrowing, repayments and opening-to-closing cash. It is the appropriate place to test liquidity separately from the illustrated EBITDA path.
The workbook includes distinct methods to assess operating break-even, cash recovery, invested capital returns and scenario sensitivity.
Returns separately evaluates sales break-even, cash break-even, investment payback and annual return on invested capital. None can be calculated directly from the illustrative EBITDA figures alone.
Dashboard scenarios adjust revenue, COGS, variable expenses, fixed costs and payroll in Low, Base and High cases. Debt Controls support four facilities and alternative repayment structures; no borrowing approval is assumed.
The Returns analysis compares sales break-even, cash break-even, investment payback and annual ROIC using their respective schedules. Review these measures after entering actual funding, capital expenditures and working-capital assumptions rather than treating projected EBITDA as an investment return.
Valuation supports discounted cash flow sensitivity, and Benchmarks and Ratios compare selected indicators. No project valuation, borrowing eligibility, payback date or return percentage is established here.
This model fits repair-and-replacement contractors constrained by a shared field technician-hour pool, not new construction.
Test technician hiring, utilization, service mix, realized revenue per hour and overhead across plumbing repairs, drains, water heaters, HVAC repairs, maintenance and replacements.
This national, mixed-climate US case is not a city-specific quote. Verify local wages, pricing, insurance, rules and demand before relying on projections.
Key details about editing, calculations and interpretation of the plumbing and HVAC financial model.
No. All six services share billable field hours, allocated by service mix and priced separately.
Yes. Edit available field hours, utilization and twelve monthly seasonal factors.
No. Technicians are in Payroll; direct costs include parts, equipment and specialist subcontracting.
Yes. Opening assets include four service vans, tools, drain equipment and storage.
No. It represents estimated initial owner equity, not sales, operating income or confirmed debt.
No. Review Cash Flow and Debt for working capital, capital spending and financing effects.
Yes. Returns calculates payback and break-even; the example establishes no payback date.
KPIs, forecasts, and cash flow at a glance.
Key assumptions and calculations driving revenue forecasts.
Funding sources, spending, and closing cash.
Cash break-even, payback, and ROIC.
DCF valuation and sensitivity analysis.
Largest costs and spending trends.
Annual and monthly financial performance.
Compare margins and returns to benchmarks.
The runway and shortfalls were finally easy to see, so I could spot a funding gap months earlier and plan a meeting with my lender before cash got tight.
I used to spend days building projections by hand, but this template cut that down to one afternoon and saved me at least 12 hours on our first pass.
The break-even view made our labor and service margins clear right away, and it gave me a cleaner way to talk through pricing with my partner.
