Spec Home Pro Forma: How to Analyze a Deal Before You Build
A spec home pro forma is the document that tells you whether a deal is worth doing before you spend a dollar on it. It takes the projected sale price, subtracts every cost you will incur to get there, and shows you whether the margin justifies the risk. Without one, you are not analyzing a deal. You are guessing.
Most first-time spec builders skip the pro forma or run such a rough version of it that they miss costs that add up to $40,000 or $50,000 by the time the home sells. The builders who make consistent money on spec homes are the ones who run the numbers before they commit to any lot, any plan, or any lender conversation. This post walks through exactly how to build a spec home pro forma, what every line needs to include, and how to use it to make go or no-go decisions on deals before you are too far in to walk away.
What Is a Spec Home Pro Forma?
A spec home pro forma is a financial model that projects the total revenue, total costs, and estimated profit on a residential new construction project built for sale. It is the builder’s equivalent of an investor’s deal analysis. You plug in your numbers, and the model tells you whether the deal pencils out.
The pro forma is used at two points in the process. First, before you commit to the lot, as a go or no-go filter. If the deal does not show at least 10% to 15% profit margin at this stage, you do not pursue it. Second, as the project progresses, as a living document that updates with real costs and flags when the deal is drifting from the original projection.
A spec home pro forma is different from a construction estimate. The estimate covers the detailed line-item breakdown of construction costs. The pro forma sits above that. It takes the total from the estimate and combines it with land costs, financing costs, and selling costs to give you the all-in picture. Both documents are necessary. Neither one replaces the other.
What Does a Spec Home Pro Forma Include?
A complete spec home pro forma has four sections: revenue, costs, profit calculation, and return metrics. Here is what belongs in each one.
Section 1: Revenue
Projected sale price. The estimated market value of the finished home based on comparable sales of similar new construction in the same area, at the same finish level, over the last six months. This is the most important number in the entire pro forma because every other calculation flows from it. Use the median of your comps, not the high end. Pricing to the optimistic outlier is how builders end up holding a home for six months after completion.
Sale price adjustments. If comparable homes have features yours does not (larger lot, three-car garage, finished basement), adjust your projected sale price down. If yours has features the comps lack, adjust up conservatively. Appraisers will make these adjustments when the lender orders the appraisal, so you should make them in your pro forma first.
Section 2: Costs
This is where most pro formas fall short. Every cost category needs a line item. Missing any of them overstates your margin and leads to a deal decision based on incomplete data. The full breakdown of what falls into hard costs versus soft costs is covered in detail in a separate post, but here is the complete list of what your pro forma must capture.
Land costs. Purchase price of the lot, closing costs on the lot purchase (typically 2% to 3% of purchase price), and any carrying costs between closing on the lot and starting construction (property taxes, insurance on the vacant lot).
Pre-construction costs. Architectural plans and design, structural and civil engineering, geotechnical report if required, survey and staking, and any pre-construction consulting or due diligence costs.
Permits and fees. Building permit, plan review, impact fees, utility connection fees (water tap, sewer tap, gas, electric), school fees, park fees, and any other jurisdiction-specific charges. This line item is highly variable. In some jurisdictions permits and fees total $5,000. In others they exceed $25,000. Verify the actual numbers for the specific lot before you finalize the pro forma.
Hard construction costs. The total from your line-item construction estimate: site work, foundation, framing, roofing, exterior, mechanical systems, insulation, drywall, interior finishes, cabinets and countertops, appliances, flatwork, and landscaping. If you do not have a detailed estimate yet, use a conservative cost-per-square-foot number for your market and finish level as a placeholder. But replace it with a real estimate before you commit to the lot. A cost-per-square-foot number is a filter, not a budget. The full framework for building that estimate is in the construction budget template guide.
Contingency. 10% to 15% of hard construction costs. On a first build, use 15%. This is real money that you should expect to spend at least partially on every project. Do not run the pro forma without it.
Construction loan costs. Loan origination fees (typically 1% to 2% of loan amount), appraisal fees, title insurance, and other closing costs. On a $350,000 loan, these run $5,000 to $10,000.
Construction loan interest. The interest you pay on drawn funds during the build. Calculate this based on your expected draw schedule and build timeline. A reasonable approximation for a back-of-envelope pro forma: average loan balance over the build period times the interest rate times the number of months. On a $350,000 loan at 7.5% over 10 months, with draws phased evenly, average balance is roughly $175,000, and total interest runs approximately $11,000. The draw schedule affects this calculation, so build a realistic timeline before you finalize it.
Carrying costs during sale period. The home does not sell the day you get your certificate of occupancy. Budget for 2 to 4 months of carrying costs after completion: loan interest on the full balance, property taxes, utilities, and homeowner’s insurance on the finished home. On a fully drawn $350,000 loan at 7.5%, two months of interest is roughly $4,400. Four months is $8,750. This is money most first-time builders forget to include.
Selling costs. Listing agent commission (typically 2.5% to 3% of sale price), buyer’s agent commission (negotiable but budget 2.5% to 3% as a baseline), seller closing costs (title insurance, recording fees, transfer taxes where applicable), professional photography ($400 to $800), staging ($2,000 to $5,000), and any price reductions or buyer concessions you anticipate. On a $500,000 home, selling costs typically run $28,000 to $35,000. This is the line item that most dramatically shrinks the margin on paper versus what builders expect in their heads.
Builder overhead. Your time managing the project, your vehicle, your phone, your office expenses. If you are acting as the general contractor, this is a real cost even if you are not writing yourself a separate check. Budget 3% to 5% of hard construction costs as a starting point.
Section 3: Profit Calculation
Gross profit. Projected sale price minus total costs. This is the dollar amount of profit before taxes.
Profit margin. Gross profit divided by projected sale price, expressed as a percentage. This is the number you evaluate the deal against. A margin below 10% on a spec home does not have enough cushion to absorb the things that will go wrong. A margin of 15% to 20% is a solid deal. Above 20% is exceptional and worth moving on quickly.
Return on equity. Gross profit divided by your total cash invested (down payment, carrying costs paid out of pocket, any soft costs not covered by the loan). This tells you how efficiently your capital is working. A $60,000 profit on $120,000 of invested equity is a 50% return. Compare that to what that capital would earn elsewhere and you have a real sense of whether the deal is worth doing.
Section 4: Return Metrics
Annualized return. Return on equity divided by the project duration in years. A 50% return on equity over 18 months is a 33% annualized return. This matters for comparing spec home projects to other uses of your capital.
Break-even sale price. The minimum sale price at which the project returns zero profit. This tells you how much the market can soften before you lose money. If your projected sale price is $500,000 and your break-even is $458,000, you have $42,000 of downside protection. If your break-even is $492,000, you have almost no margin for error on pricing.
Sensitivity analysis. What happens to your profit if sale price drops 5%? What if construction costs run 10% over? What if the build takes two extra months? Running these scenarios before you commit tells you whether the deal is robust to realistic downside scenarios or whether it only works if everything goes perfectly.
How to Run a Spec Home Pro Forma: A Real Example
Here is a worked example of a spec home pro forma for a 2,200 square foot home in a mid-range US market.
Projected sale price: $520,000 (based on six comparable sales in the past 90 days)
Land cost: $85,000 purchase price plus $2,500 closing costs = $87,500
Pre-construction: Plans $6,000, engineering $5,000, survey $2,500 = $13,500
Permits and fees: $14,000 (verified with the building department)
Hard construction costs: $298,000 (detailed line-item estimate)
Contingency (10%): $29,800
Construction loan costs: $7,200 (origination, appraisal, title)
Construction loan interest: $13,500 (10-month build, 7.5% rate)
Carrying costs during sale (3 months): $6,800
Selling costs (6% commission plus closing): $34,000
Builder overhead (4%): $11,900
Total costs: $516,200
Gross profit: $3,800
Profit margin: 0.7%
This deal does not work. A $3,800 profit on a $520,000 sale after 12 to 14 months of risk and capital deployment is not a business. It is a break-even exercise. The pro forma caught it before any money was committed.
Now adjust one variable: the lot price. If the same lot could be acquired for $65,000 instead of $85,000, the total costs drop to $496,200, gross profit rises to $23,800, and the margin becomes 4.6%. Still thin. Adjust the hard costs down $15,000 by value-engineering the floor plan, and the margin reaches 7.5%. Getting closer but still below the 10% threshold. This deal needs either a cheaper lot, a higher sale price supported by the comps, or lower construction costs to pencil out.
That is exactly what a pro forma is for. It shows you which variables to pressure-test and how sensitive the deal is to each one. Without it, you are making a $500,000 decision based on gut feel.
When Should You Run the Pro Forma?
Run a preliminary pro forma before you make an offer on any lot. Use placeholder numbers for construction costs based on your market knowledge, and focus on whether the basic deal structure makes sense: is there enough spread between the land cost plus estimated build cost and the projected sale price to potentially generate a 10% to 15% margin?
If the preliminary pro forma shows potential, tighten the numbers. Get a real construction estimate. Verify permit fees with the building department. Confirm comparable sales with a local listing agent. Replace every placeholder with a real number before you go under contract.
Run the final pro forma with firm numbers before you close on the lot. This is your last chance to walk away without major financial consequence. If the numbers do not work at closing, they will not work during construction when costs only go in one direction.
If you are still in the planning phase and have not yet identified a specific lot, the free pre-construction checklist walks through the full lot evaluation and deal analysis process, including a companion spreadsheet with a built-in deal analyzer tab.
What Makes a Spec Home Deal Work?
After running the numbers on enough deals, patterns emerge. The deals that work reliably have these characteristics.
Land cost is 15% to 20% of projected sale price. If you are paying 25% or more of the sale price for the lot, you need a very low build cost or a premium market to make the margin work. In most mid-range markets, lot cost above 20% of projected sale price is a warning sign.
Hard construction costs are 55% to 65% of projected sale price. Above 65%, the soft costs and selling costs compress your margin below sustainable levels. This is the range where the all-in cost breakdown starts to work.
The home is designed for the median buyer in the target market. Overbuilding for a neighborhood or designing for personal taste rather than market demand is how builders end up with extended days on market and price reductions that destroy the margin they planned for.
The timeline is realistic. Every pro forma has a build timeline and a sale timeline. Builders who underestimate both consistently find that the additional carrying costs eat their projected margin. Build in buffer. A 10-month build that runs 12 months costs you two months of interest on the full loan balance.
Comparable sales support the projected price. The sale price assumption is not what you want the home to sell for. It is what similar homes have actually sold for in the past 90 days. Not 180 days. Not what a listing agent thinks you could get. Closed comps from the past 90 days in the same neighborhood at the same finish level.
How to Compare Multiple Lots with a Pro Forma
One of the most useful applications of a spec home pro forma is comparing multiple lots side by side. When you have two or three lots under consideration, running the same pro forma for each one with lot-specific numbers immediately shows which deal has the best margin, which has the most downside protection, and which one you should pursue first.
A side-by-side comparison also surfaces non-obvious differences between deals. Two lots priced the same might have dramatically different permit and fee structures, different site work costs based on topography, or different comparable sales based on school district or neighborhood. The pro forma captures all of it in a way that a gut comparison never can.
The Deal Analyzer in the Residential Construction Estimating System is built specifically for this. It runs a full pro forma for up to five lots simultaneously, includes a sensitivity analysis matrix showing how profit changes across a range of sale prices and construction costs, and produces a clean summary you can share with a lender or equity partner. It connects directly to the construction estimate so your hard cost assumptions are always based on your actual line-item budget, not a placeholder.
Frequently Asked Questions
What is a spec home pro forma?
A spec home pro forma is a financial model that projects the total revenue, total costs, and estimated profit on a residential new construction project built for sale. It combines land costs, construction costs, financing costs, and selling costs against the projected sale price to determine whether a deal generates enough margin to justify the risk.
What profit margin should a spec home pro forma show?
A minimum of 10% to 15% of the projected sale price. On a $500,000 home, that is $50,000 to $75,000 in gross profit. Deals below 10% margin do not have enough cushion to absorb cost overruns, delays, or market softening. Experienced spec builders typically target 15% to 20% and walk away from anything below 12%.
What costs do most builders miss in a spec home pro forma?
The most commonly missed costs are construction loan interest during the sale period (after the CO is issued but before the home closes), impact fees and utility connection fees, builder overhead, and the full cost of selling including both sides of the agent commission. Together these can add $40,000 to $60,000 to the total cost on a mid-range spec home.
How is a spec home pro forma different from a construction estimate?
A construction estimate is a line-item breakdown of every hard and soft cost in the build. A pro forma sits above that. It takes the total from the estimate and combines it with land costs, financing costs, and selling costs to produce a complete deal analysis showing projected profit, profit margin, and return on equity.
When should I run a spec home pro forma?
Run a preliminary pro forma before making an offer on any lot, using placeholder construction costs based on market knowledge. Tighten the numbers with real estimates before going under contract. Run the final version with firm numbers before closing on the lot. If the deal does not work at closing with real numbers, it will not work during construction.
FREE RESOURCE
Get the Pre-Construction Planning Checklist
A 16-page guide plus companion spreadsheet covering everything from lot evaluation to budget planning. Built for builders going from trades to ground-up new construction.
Download the Free Checklist