Stackrows
Electrical Pro Forma Template
A
B
C
D
E
F
G
1
Category
Budget
Actual
2
3
4
5
6
7
8
Assumptions
Revenue Projections
Job Cost Model
Overhead & G&A
5-Year P&L Summary
Cash Flow Projection
Break-Even Analysis

Electrical Pro Forma Template

Project an electrical contracting business's revenue, job costs, overhead, and net income across 5 years — with pre-built formulas for service vs. project mix, material markup, revenue per man-hour, and break-even analysis.

$29Save 6+ hours vs. building an electrical contractor pro forma from scratch
Instant download after purchase
Works in Excel & Google Sheets
30-day money-back guarantee
.xlsx265 KB7 sheetsUpdated 2026-03-23

What's Inside This Electrical Contractor Pro Forma Template

This template includes 7 worksheets, each designed for a specific part of your electrical financial workflow:

1

Assumptions

The control panel for the entire model. Enter your company profile here — number of field technicians (journeymen and apprentices separately), your target service vs. project revenue split, average service ticket value, average commercial contract size, and material markup percentage. A revenue ramp schedule lets you model gradual growth during the first 12–24 months, which matters for startups or shops expanding into new market segments like commercial service agreements or new construction. License and bond requirements, target billable hours per technician per week, and vehicle count all feed into the downstream cost calculations automatically, so the model stays internally consistent as you adjust your growth assumptions.

2

Revenue Projections

Projects total revenue by month for year one and annually through year five, broken out by five work types: residential service calls, commercial project contracts, new construction installs, panel upgrades and specialty work, and maintenance and service agreements. Each category has a separate volume input (call count or project count) and an average revenue per job, so you can model the actual mix of your business rather than a single revenue line. Service agreement recurring revenue is modeled separately as a predictable monthly annuity that builds over time — this is the revenue stream that most electrical shops undervalue but that contributes meaningfully to stable cash flow in slow months. Material markup revenue is calculated as a percentage of material cost and reported as a separate line.

3

Job Cost Model

Breaks out direct job costs by the categories that determine gross margin in electrical work: materials and wire (entered as a cost percentage of contract or ticket value), direct labor (journeymen wages, apprentice wages, and burden — FICA, workers' comp, and benefits — modeled separately because burden rates differ by role), subcontractor costs for work outside your trade scope, and permit and inspection fees. The sheet calculates gross profit and gross margin percentage for each work type separately, because the cost structure differs significantly — a residential service call might run 15–20% materials and 50–55% labor, while a commercial wiring project might run 40% materials and 35% labor. Blending these together obscures which parts of your business are profitable. Total blended gross margin feeds directly into the 5-Year P&L.

4

Overhead & G&A

Covers all costs not allocated to a specific job: vehicle fleet (lease or depreciation, insurance, fuel, and maintenance per truck), tools and test equipment (capital purchases and replacements), general liability and commercial auto insurance, workers' comp insurance (modeled as a percentage of direct labor, which is how it's actually priced), electrical contractor license renewal fees and continuing education, accounting and legal fees, software subscriptions (service dispatch, estimating, and accounting tools), and office rent and administrative staff if applicable. Fixed overhead (costs that don't change with revenue) and variable overhead (costs that scale with job volume) are separated, which allows the break-even analysis to calculate your contribution margin correctly. Overhead as a percentage of revenue — the number that determines whether a growing shop is actually building a profitable business — is calculated automatically.

5

5-Year P&L Summary

An annual summary showing total revenue, total job costs, gross profit, gross margin percentage, total overhead, EBITDA, and net income side by side for each of the five projected years. Revenue per man-hour — the single most important productivity metric in electrical contracting — is calculated for each year based on your projected billable hours and total field revenue. This sheet is the primary output for SBA lenders, bank loan officers, investors evaluating a business acquisition, and sellers preparing a company for sale. Key scaling metrics show how gross margin and overhead percentage trend as revenue grows, since overhead as a percent of revenue typically declines meaningfully between $500K and $2M in annual revenue as fixed costs are spread over more jobs.

6

Cash Flow Projection

A monthly cash flow model for year one and an annual summary through year five. Service and residential work is modeled with faster cash conversion (payment typically collected within 7–14 days), while commercial contracts are modeled with standard net-30 to net-60 payment terms that push cash receipt 1–2 months behind invoicing. Large commercial projects may carry retainage of 5–10% that converts to cash only at project completion, and this is tracked separately as a slow-converting receivable. Capital expenditures — new service vehicles, bucket trucks, tools, and equipment — are entered as one-time purchases in the year they occur. The sheet shows operating cash flow, capex, debt service on equipment financing or SBA loans, and net monthly cash position, which is the number that determines whether you can take on a large commercial job without running out of cash.

7

Break-Even Analysis

Calculates the annual revenue required to cover all fixed and variable costs. Fixed costs (overhead salaries, vehicle leases, insurance premiums, license fees, rent) are separated from variable costs (direct labor burden, materials, permits, variable overhead) to calculate the contribution margin on each dollar of revenue and the exact break-even revenue threshold. A sensitivity table shows how break-even changes under different gross margin scenarios — because gross margin varies between service work and project work, knowing how your break-even shifts if you win fewer high-margin service calls and more lower-margin commercial contracts is essential for planning. The sheet also shows how many technicians you need at target utilization rates to reach break-even and at what revenue level each additional technician becomes self-funding.

Electrical Pro Forma Template Features

  • Revenue model by work type (residential service, commercial contracts, new construction, panel upgrades, service agreements) with separate volume and average ticket inputs
  • Job cost breakdown by materials, direct labor (journeymen vs. apprentice), subcontractors, and permits as percentages of revenue by work type
  • Revenue per man-hour calculation across all five projected years — the core productivity metric for electrical contractors
  • Cash flow model with fast-pay service work vs. net-60 commercial billing and optional retainage tracking
  • 5-year annual P&L with gross margin, overhead percentage, EBITDA, and net margin by year
  • Break-even analysis with technician headcount modeling under variable gross margin scenarios

How to Use This Electrical Contractor Pro Forma Spreadsheet

Start with the Assumptions sheet. Enter your current technician count, your service vs. project revenue split, and your average revenue per service call and per commercial contract. If you're projecting for a new business, use industry benchmarks as a starting point: most residential service-focused electrical shops generate $80,000–$120,000 in annual revenue per technician at healthy utilization rates, while commercial contractors often run higher because of larger contract values. Set a realistic ramp schedule for the first 12–24 months — customer acquisition in electrical contracting is driven by relationships and reputation, not advertising, so growth in year one is almost always slower than year two.

Once assumptions are in place, review the Job Cost Model and adjust the cost percentages to match your actual experience. This is the most important customization step — the default percentages are industry averages, but your actual material costs depend on your supplier pricing and the type of work you do, and your labor burden rate depends on your benefits structure and your workers' comp classification. Enter the actual gross margins you see on your best job type and your worst job type. Then review the Overhead & G&A sheet and enter your real overhead costs — vehicle fleet costs and insurance are typically the largest line items for electrical contractors and they vary significantly based on how many trucks you run.

Use the 5-Year P&L Summary and Cash Flow Projection when meeting with SBA lenders, bank loan officers, or equipment financing companies. Lenders evaluating electrical contractors focus on revenue per man-hour trends (is it improving or eroding?), overhead as a percentage of revenue (is the business scalable?), and whether the cash flow model reflects the actual payment timing of your customer base. If you're buying an existing electrical business, run the break-even analysis under a scenario where you lose 15–20% of the seller's customer base in the first year — that's the downside stress test most acquisition lenders will want to see.

From download to lender-ready projections in under an hour

Enter your technician count, work type mix, and cost structure — the model builds your 5-year revenue, job margin, overhead, and cash flow analysis automatically.

Why Every Electrical Contractor Needs a Pro Forma

Electrical contractors face a financial planning challenge that's distinct from most service businesses: the gap between when you spend money and when you get paid grows significantly as you move from residential service work to commercial projects. A residential service call closes and gets paid the same day — material cost plus labor plus markup, collected within a week. A commercial lighting retrofit on a 90-day project has the same cost structure but generates invoices on a net-60 cycle with 10% retainage held until final inspection. For a shop doing $1.5 million a year split between service and commercial work, understanding that cash timing difference — and planning for it — is the difference between a thriving business and one that struggles to make payroll in months when commercial collections are slow.

The two metrics that define electrical contractor financial health are revenue per man-hour and overhead as a percentage of revenue. Revenue per man-hour tells you whether your pricing, efficiency, and technician utilization are producing the returns the business needs — most well-run electrical shops target $75–$120 per man-hour on residential service and $60–$90 on commercial project work (the range reflects regional labor cost differences and market competitiveness). Overhead percentage tells you whether the business is scalable — most profitable electrical contractors keep total overhead under 20% of revenue, and the ratio almost always improves as revenue grows because license fees, insurance minimums, and dispatch software costs don't scale linearly with the number of trucks on the road. A pro forma that models both metrics across five years gives you a clear picture of when the business becomes self-sustaining and at what revenue level each additional technician becomes accretive.

For SBA loans, equipment financing, or line-of-credit applications, lenders evaluating electrical contractors want to see three things in your pro forma: realistic revenue assumptions grounded in actual backlog or service territory analysis, a cost model that reflects your real job cost percentages (not industry averages that assume you're buying at scale), and a cash flow projection that accounts for the timing difference between commercial billings and collections. Surety bond underwriters — who you'll need for commercial work above certain contract thresholds — look specifically at working capital available relative to backlog and whether the cash flow model shows you can fund new projects without straining the business. This template is built to give you all three in a format lenders and underwriters recognize.

Electrical Industry at a Glance

Financial templates built for electrical contractors — from solo electricians to multi-crew commercial shops. Pre-loaded with labor, materials, and overhead categories specific to the electrical trades.

Revenue Drivers

  • Residential service calls
  • Commercial project contracts
  • New construction installs
  • Panel upgrades
  • Maintenance & service agreements
  • Material markups

Key Cost Categories

  • Materials & wire
  • Labor (journeymen & apprentices)
  • Permits & inspection fees
  • Vehicle & fuel
  • Tools & equipment
  • Insurance & bonding
  • Subcontractors
  • Overhead & office

Typical Margins

Gross: 35-50% · Net: 5-12%

Seasonality

Commercial construction peaks spring through fall. Residential service work is relatively steady year-round, with spikes in summer (AC-related) and fall (heating season). Slowest in January–February.

Key Performance Indicators

Revenue per man-hourJob cost varianceMaterial markup percentageBid-to-win ratioBacklog in weeksService call conversion rate

Electrical Contractor Pro Forma Template FAQ

Electrical Pro Forma Template

$29