Electrical Financial Model Template

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.

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.