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.
What's Inside This Construction Pro Forma Template
This template includes 7 worksheets, each designed for a specific part of your construction financial workflow:
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.
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.
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.
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-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.
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.
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
Construction Pro Forma Template FAQ
More Construction Templates
Construction Balance Sheet Template for Excel
$29
Construction Budget Template for Excel
$29
Construction Cash Flow Template for Excel
$29
Construction Expense Tracker Template for Excel
$29
Construction Financial Model Template for Excel
$29
Construction Income Statement Template for Excel
$29
Construction Invoice Template for Excel
$29
Construction KPI Dashboard Template for Excel
$29
Construction P&L Template for Excel
$29
Construction Project Budget Template for Excel
$29
Construction Sales Forecast Template for Excel
$29
Construction Business Valuation Template for Excel
$29
Construction Pro Forma Template
$29