Electrical Financial Model Template

Start with the Assumptions sheet — that's where you input your business's core operating parameters. Enter your number of crews, average weekly billable hours, blended labor rate, and material markup percentage. If you're not sure about some inputs, use last year's actual numbers as your baseline. These inputs flow automatically to every other sheet in the model, so getting the Assumptions right is the most important first step. Most electrical contractors can fill this out in about 20 minutes.

Once your assumptions are set, move to the Revenue Projections sheet and enter your expected job volume and average ticket by category for each month. Use your backlog and pipeline to populate the near-term months, and your historical averages for months further out. The Job Costing sheet will calculate your expected gross margin by category automatically. Review that sheet closely — it's often where contractors discover that one job type is quietly underperforming when the numbers are this explicit.

Run the model monthly as an operational tool, not just a planning exercise. After each month closes, update the P&L and Cash Flow sheets with your actual numbers. The variance between projected and actual shows you where your estimates were off — whether materials ran over on a project, whether commercial receivables are stretching longer than modeled, or whether a particular job category is consistently underperforming its projected margin. Electrical contractors who review this monthly can catch margin compression early, before it shows up as a cash problem three months later.

Most electrical contractors run the business off their bank balance — money in the account feels like profit, and a slow week feels like a crisis. The problem is that contractor cash flow doesn't match profitability. A large commercial job might represent $80,000 in earned revenue, but if the GC pays in 60 days, your bank account won't show it for two months. Meanwhile, you've paid your crew, bought materials, and fueled your trucks. A financial model makes this gap visible before it becomes a problem.

The two numbers that determine whether an electrical contracting business is actually healthy are revenue per man-hour and gross margin by job type. Revenue per man-hour — total billings divided by total crew hours — benchmarks your pricing and productivity together. Most established electrical contractors target $85–$115 per man-hour depending on their market and job mix. Gross margin by job type tells you whether residential service calls, commercial projects, and new construction are each contributing adequately to cover overhead. It's common to find that new construction work is priced too low because it was won on competitive bids without fully accounting for labor burden and overhead allocation.

The material markup conversation is where a lot of electrical contractors leave money on the table. If you're buying materials at cost and marking up 15%, but your competitors in the same market are marking up 25–30%, you're subsidizing your customers' material costs. This model lets you see exactly what a 5% change in material markup does to your annual net income — for a contractor doing $1.5M in revenue, it can be $15,000–$25,000 per year. That kind of clarity is hard to get from a bank statement or a basic P&L, but it changes how you think about pricing.