Stackrows
Construction 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

Construction Pro Forma Template

Project a construction company's revenue, job costs, overhead, and net income across 5 years — with pre-built formulas for backlog, bid-to-win ratio, gross margin by project type, and break-even analysis.

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

What's Inside This Construction Pro Forma Template

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

1

Assumptions

The control panel for the entire model. Enter your company profile here — number of active projects at any one time, average contract size by project type (residential, commercial, industrial, specialty), target bid-to-win ratio, and crew headcount by trade. A revenue ramp schedule lets you model gradual growth during the first 12–24 months for startups or companies entering a new market segment, reflecting the reality that backlog builds slowly as you establish relationships and win bids. Overhead rate, bonding capacity, retainage percentage, and average project duration are all set on this sheet and flow through to the downstream projections automatically.

2

Revenue Projections

Projects total construction revenue by month for year one and annually through year five. Revenue is broken out by project type — residential new construction, commercial tenant improvement, industrial/warehouse, civil/site work, and specialty trades — so you can model the mix that matches your business or target market. Each category has a weighted average contract value and a project count input, and the sheet calculates total annual revenue from those two inputs plus your ramp-up adjustment. Change order revenue is projected separately as a percentage of base contract value (typically 5–15% for most contractor types), which is a meaningful revenue line that generic pro formas often omit entirely.

3

Job Cost Model

Breaks out direct project costs by the four main categories that determine job gross margin: materials, direct labor (field crew wages, burden, and benefits), subcontractor costs, and equipment rental. Each cost category is entered as a percentage of the contract value, and the sheet calculates your gross profit and gross margin percentage for each project type separately. This matters because residential framing work has a very different cost structure than commercial mechanical or specialty finishes — blending everything together obscures which project types are profitable and which are margin-thin. The bottom of the sheet shows blended gross margin across your revenue mix, which feeds directly into the 5-Year P&L.

4

Overhead & G&A

Covers all costs that don't get allocated to a specific job: office rent and utilities, project management and estimating salaries, office administration staff, vehicles and fuel (for non-billable trucks and company vehicles), insurance (general liability, workers' comp, builder's risk), bonding premiums, accounting and legal fees, software subscriptions, and marketing. These costs are separated into fixed overhead (costs that don't change regardless of revenue volume) and variable overhead (costs that scale with revenue), which is the correct way to model contractor overhead for break-even and scenario analysis. Total overhead as a percentage of revenue is calculated automatically — most healthy construction companies keep this under 15–18% of revenue.

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. Key ratios — gross margin, overhead as a percent of revenue, and net margin — are shown next to dollar figures so you can see how the business scales as revenue grows and overhead becomes a smaller percentage of the top line. This sheet is designed to be the primary output for SBA lenders, bank financing applications, surety bond underwriters, and equity investors evaluating the business. All figures pull automatically from the Revenue, Job Cost, and Overhead sheets.

6

Cash Flow Projection

A monthly cash flow model for year one and an annual summary through year five, built specifically for the way construction companies get paid. Revenue is adjusted for billing cycle timing — construction companies typically bill monthly on progress, but payment terms of net-30 to net-60 mean cash lags revenue by one to two months. Retainage is tracked separately as a receivable that gets released at project completion, which is a significant cash flow item that most generic financial models miss entirely. The sheet shows operating cash flow, capital expenditures (equipment purchases and vehicle replacements), debt service on equipment financing, and net monthly cash position — the single most important number for a growing contractor to track.

7

Break-Even Analysis

Calculates the annual revenue a construction company needs to cover all fixed and variable costs. Fixed costs (overhead salaries, rent, insurance, bonding, equipment loan payments) are separated from variable costs (direct labor burden, materials, subs, variable overhead) to calculate the contribution margin on each dollar of revenue and the revenue break-even point. A secondary table shows break-even sensitivity under different gross margin assumptions — because margin varies by project type, knowing how break-even shifts when you win more lower-margin commercial work versus higher-margin residential work is an important planning input. The sheet also projects how many months at projected revenue levels it takes to cover cumulative startup or ramp costs.

Construction Pro Forma Template Features

  • Revenue model by project type (residential, commercial, industrial, specialty) with average contract size
  • Job cost breakdown by materials, direct labor, subcontractors, and equipment as % of contract value
  • Overhead model separating fixed and variable costs with overhead-as-percent-of-revenue calculation
  • Monthly cash flow with retainage tracking and payment timing adjustments for contractor billing cycles
  • 5-year annual P&L summary with gross margin, EBITDA, and net margin by year
  • Break-even analysis by annual revenue under variable gross margin scenarios

How to Use This Construction Pro Forma Spreadsheet

Start with the Assumptions sheet. Enter your company's current project mix, average contract sizes for each project type, and your typical bid-to-win ratio — this ratio is the most important driver of projected revenue because it determines how much estimating volume you need to generate your target backlog. If you're starting a new company, use industry benchmarks as a baseline: general contractors typically win 1 in 5 to 1 in 8 bids; specialty trades with established relationships can win 1 in 3 to 1 in 4. Set a 12–24 month ramp schedule that reflects how long it takes to build backlog in your market.

Once assumptions are set, review the Job Cost Model sheet and adjust the cost percentages for each project type to match your actual experience. This is the most important customization step — the default percentages are industry averages, but your actual material and labor costs depend heavily on your market, your crew structure, and how you use subcontractors. Verify that the gross margins in the Job Cost Model match what you actually see on your best and worst jobs before using the model for any financial presentation. Then review the Overhead & G&A sheet and enter your actual or projected overhead line items.

Use the 5-Year P&L Summary and Cash Flow Projection sheets when presenting to SBA lenders, surety bond underwriters, or bank loan officers. Lenders evaluating construction companies focus on gross margin trends (is it stable or eroding?), overhead as a percentage of revenue (does it drop as the company grows?), and the cash flow model — especially how retainage and payment timing affect liquidity. Run the Break-Even Analysis under a pessimistic gross margin scenario before any financing meeting to show you've stress-tested the model and understand your downside.

From download to lender-ready projections in under an hour

Enter your project mix, contract sizes, and cost structure — the model builds your 5-year revenue, gross margin, overhead, and cash flow analysis automatically.

Why Every Construction Company Needs a Pro Forma

Construction is one of the most cash-intensive industries to finance because of how payment works. Contractors spend money on materials and labor weeks before the owner pays, retainage holds back 5–10% of every invoice until project completion, and payment terms of 30–60 days are standard. A construction company can show strong gross margins on paper and still run out of cash because it's growing faster than its billing cycle allows. That's the specific problem a construction pro forma is built to solve — projecting not just profitability but the cash timing that determines whether a company can fund its own growth or needs a line of credit to bridge the gap.

The two numbers that define construction financial health are gross margin per project (20–35% is typical for general contractors; specialty trades can run higher) and overhead as a percentage of revenue (healthy companies keep this at 10–18%). A contractor with a 28% gross margin and 15% overhead runs at 13% EBITDA — a solid business. A contractor with the same 28% gross margin but 22% overhead is barely breaking even. Overhead percentage almost always improves as revenue grows, because most overhead costs are fixed — the project manager, the office rent, the insurance premiums don't double when revenue doubles. This is the core scaling logic that makes a construction pro forma useful: it shows at what revenue level the business becomes meaningfully profitable.

For lenders and surety bond underwriters, a construction pro forma needs to demonstrate three things: that you understand your job cost structure, that you've modeled cash timing realistically (including retainage), and that the revenue projections are grounded in actual backlog or a defensible bid pipeline, not wishful thinking. SBA lenders for construction businesses specifically look for historical bid-to-win ratios, owner experience, and whether projected revenue is consistent with your bonding capacity. This template is structured to give you the numbers for all three conversations — the P&L for the lender, the cash flow for the line of credit discussion, and the break-even for the bond underwriter who wants to know your minimum viable revenue.

Construction Industry at a Glance

Financial templates built for construction companies — from general contractors to specialty trades. Pre-loaded with job costing categories, bid tracking, and project-based financials.

Revenue Drivers

  • Project contracts
  • Change orders
  • Service & maintenance
  • Material markups

Key Cost Categories

  • Materials
  • Labor (direct)
  • Subcontractors
  • Equipment rental
  • Permits & insurance
  • Overhead

Typical Margins

Gross: 20-35% · Net: 2-7%

Seasonality

Peak activity spring through fall; winter slowdown in northern climates. Year-end push to close projects.

Key Performance Indicators

Gross margin per jobBacklog ratioBid-to-win ratioCost variance per projectRevenue per employee

Construction Pro Forma Template FAQ

Construction Pro Forma Template

$29