Spec Home Pro Forma: How to Analyze a Deal in Minutes
A spec home pro forma is a one-page financial projection that answers one question: if I buy this lot and build this house, how much money is left when it sells? You add up land, hard costs, soft costs, financing, and selling costs, subtract the total from a realistic sales price, and see whether the profit is worth the risk. A good one takes minutes, not days, and it should give you a clear yes or no.
The spreadsheet is the easy part. The discipline to put honest numbers in it is where builders get into trouble.
What goes into a spec home pro forma?
Six buckets. If a cost doesn’t land in one of these, you’re probably forgetting it.
Land. Purchase price, closing costs, survey, title, and any feasibility work.
Hard costs. Everything it takes to physically build the house, including site work, utilities, and landscaping.
Soft costs. Architecture, engineering, permits, impact fees, insurance, and property taxes during the build.
Financing costs. Loan origination, interest carry, and any investor preferred return.
Selling costs. Realtor commissions, seller closing costs, staging, concessions, and the title policy.
Contingency. A line for the things you don’t know yet. Because there are always things you don’t know yet.
How do you calculate profit on a spec home?
The math is simple:
Net profit = sales price − total project cost (all six buckets above)
Profit margin = net profit ÷ sales price
Return on cost = net profit ÷ total project cost
Return on equity = net profit ÷ cash actually invested
Look at more than one of these. A deal can show a healthy margin and still be a poor use of cash if it ties up equity for two years. Time is a cost, and the pro forma should show how many months the money is out.
What costs do builders forget?
These are the usual suspects when the actual profit lands well below the projected one:
Carry after completion. The house doesn’t sell the day you finish. Budget interest, taxes, insurance, utilities, and lawn care for the months it sits on the market.
Your own overhead. If the pro forma doesn’t include a builder fee or overhead allocation, the “profit” is partly just your salary.
Buyer concessions and repairs. Rate buydowns, closing cost help, and the inspection punch list.
Utility and site surprises. Tap fees, tree mitigation, retaining walls, and bad soil.
The full selling cost stack. Commissions are the obvious one. The rest adds up quietly.
What is a good profit margin on a spec home?
There isn’t one number, because it depends on your market, your price point, and how long the money is tied up. What I can tell you is that the margin has to be big enough to absorb a bad day. If a 5% drop in sales price or three extra months of carry wipes out the deal, you don’t have a deal. You have a hope.
So set your minimum before you look at the lot, not after you’ve fallen in love with it.
How do you stress-test a spec home deal?
Run three versions of the same pro forma:
Base case. Your honest expectation, using closed comparable sales rather than active listings or your gut.
Downside case. Sales price down 5–10%, hard costs up 5–10%, and three to six more months to sell.
Ugly case. All of those at once. You want to know whether you survive it, not whether you like it.
If the downside case still pays everyone back, you can sleep. If it doesn’t, pass or restructure. I covered the ways this goes wrong in Episode 107: How to go Bankrupt Building Spec Homes.
How do you use a pro forma with investors and banks?
A clean, one-page pro forma is also your best sales document. Lenders and investors want to see the deal economics in one place: total cost, sources of funds, projected sale, and what’s left for each party. When they can see it, you spend less time explaining and more time closing. For how to split the upside fairly once the numbers are on the page, read Value Buckets for Better Deal Structuring.
Frequently asked questions
What is a pro forma in home building?
It’s a forward-looking estimate of a project’s costs, revenue, and profit, built before you commit money. It’s a projection, not a guarantee.
How detailed should a first-pass pro forma be?
Not very. The first pass is a filter. Use cost per square foot and percentage rules of thumb to kill bad deals fast, then build a detailed budget only for the ones that survive.
Should my builder fee be in the pro forma?
Yes. Your company’s overhead and fee are real costs of the project. Leaving them out makes every deal look better than it is.
How often should I update it?
At land closing, at permit, at dry-in, and at listing. Comparing each version to the original is how you get better at the next one.
BTW, if you want the same one I use to give a yes/no on a deal in a hurry (and to show investors and banks), grab our Spec Home Pro Forma Template over at the Building Optimal Shop, where you can check out the rest of our swag to build a better business. Proceeds go to benefit, Exponencialistas, my non-profit investing in entrepreneurs transforming their communities in Latin America.