Real Estate Development Pro Forma: A Small Builder's Guide
A real estate development pro forma is a financial projection of a project before it’s built: what it will cost, what it will bring in, how it will be funded, and what profit and return are left at the end. For a small builder doing infill or a few units, it’s usually a single spreadsheet that totals land, hard costs, soft costs, financing, and selling costs, then compares that total with projected sales or rental income. Its job is to tell you whether to do the deal, and at what land price.
I’ve seen more builders hurt by deals they shouldn’t have started than by houses they built badly. A pro forma is the cheapest way to lose money, because you only lose it on paper.
What does pro forma mean in real estate?
“Pro forma” is Latin for “as a matter of form.” In real estate it means a forward-looking set of numbers based on assumptions, as opposed to actual historical results. It’s a model of what you expect to happen.
That last part matters. Every figure in a pro forma is an assumption until the project closes out. The quality of the pro forma is the quality of the assumptions, so the work is in testing them, not in formatting the spreadsheet.
What goes into a pro forma for new construction?
A pro forma for new construction has five parts. The detail scales with the project, but the skeleton is the same for one house or forty units.
Revenue. For-sale projects: number of units times projected price, less selling costs. Rental projects: projected rents, less vacancy and operating expenses, which gives you net operating income.
Land. Purchase price, closing costs, and the cost of making the site buildable: demolition, utilities, tree work, subdivision or replatting.
Hard costs. Site work and vertical construction, plus a contingency. I covered sizing one in construction contingency.
Soft costs. Architecture, engineering, surveys, permits, impact and utility fees, legal, insurance, property taxes during the project, and your own overhead or development fee.
Financing. Loan fees and interest over the whole timeline, and how the cost is split between debt and equity.
At the bottom, it produces the outputs you make decisions with:
Profit: net revenue minus total cost
Profit margin: profit divided by gross revenue
Return on cost: profit divided by total cost
Return on equity: profit divided by the cash invested
Yield on cost, for rentals: net operating income divided by total project cost
What does a real estate development pro forma example look like?
Here’s a real estate development pro forma example for a small infill project. Every number is hypothetical and rounded to keep the math visible. None of it is a benchmark.
Say you’re looking at a lot where four townhomes can be built, and you believe each would sell for $800,000.
Gross revenue: 4 × $800,000 = $3,200,000
Land and site preparation: $600,000
Hard costs, including contingency: $1,600,000
Soft costs: $200,000
Financing costs: $150,000
Selling costs: $150,000
Total cost: $2,700,000
Profit is $3,200,000 minus $2,700,000, or $500,000. Profit margin is $500,000 ÷ $3,200,000, about 15.6%. Return on cost is $500,000 ÷ $2,700,000, about 18.5%.
Now the useful question: what’s the most you could pay for the land? If you need a minimum profit of $480,000 to take the risk, and everything else holds, the land can go up by only $20,000. That’s how a pro forma turns into a negotiating position.
How is a small development pro forma different from a single spec home pro forma?
The concept is identical. The difference is that more units and more time add layers a single house doesn’t have. If you’re doing one house, start with my article on the spec home pro forma, which stays on that case. For infill and multi-unit, add these:
Entitlement time and cost. Rezoning, replatting, site plan approval, or variances can add months and real money before you break ground. Model that period, with interest and taxes running.
Shared site costs. Utilities, drainage, driveways, and common areas that have to be spread across the units.
Absorption. Four units rarely sell on the same day. The pro forma should assume a sales pace, and the carrying cost of the units that sell last.
Phasing and cash flow. When money goes out and comes in by month. Total profit can look fine while month eleven runs out of cash.
Exit choice. Sell, hold as rentals, or some of each. A hold changes the outputs to net operating income, yield on cost, and the loan you could refinance into.
More complex capital. Bigger projects more often involve investors, which means splits and reporting. See how to find investors and structure the deal.
How do you build a construction pro forma template?
A construction pro forma template is a spreadsheet you reuse on every deal, with your assumptions in one place and the math flowing from them. To build one:
Create an assumptions section. Unit count, sizes, sale prices or rents, cost per unit, timeline in months, loan terms, selling cost percentage.
Build the cost side in the five buckets: land, hard, soft, financing, selling.
Build the revenue side from the assumptions, never typed in by hand.
Add a simple timeline. Even a rough monthly layout of spending and sales will show you peak cash needs.
Calculate the outputs. Profit, margin, return on cost, return on equity.
Add scenarios. Expected, conservative, and bad. Change price, cost, and time.
Save actuals next to projections when each project finishes. Your next pro forma gets better every time you do.
For single houses, we’ve already built this. Our Spec Home Pro Forma Template is a quick pro forma designed to give you a yes or no on a spec deal and to share with investors and banks. It’s also a reasonable starting skeleton if you’re working up to something larger.
What are the most common pro forma mistakes?
Optimistic sale prices. Using the best comp instead of the typical one.
Short timelines. Leaving out permitting, weather, and the months it takes to sell.
Missing soft costs. Fees, taxes, insurance, and legal add up quietly.
No contingency. Something will cost more. You just don’t know which thing yet.
Ignoring your own overhead. Your time and your office are costs of the project.
Running one scenario. A single set of numbers is a wish with decimal places.
Underestimating interest. Financing terms change the result more than most builders expect. I went through the options in spec home financing.
Frequently asked questions
What does pro forma mean in real estate, in simple terms?
It means projected numbers. A pro forma is an estimate of a project’s costs, income, and profit based on assumptions, prepared before the project happens.
How accurate is a real estate development pro forma?
Only as accurate as its assumptions. That’s why builders run conservative and worst-case scenarios alongside the expected one, and update the model as real bids and prices come in.
Is a pro forma the same as a construction budget?
No. The budget covers the cost to build, while the pro forma includes the budget plus land, financing, selling costs, revenue, and returns.
Do banks and investors require a pro forma for new construction?
Most will ask for one in some form, along with a budget, plans, and comparable sales. Requirements vary by lender, so ask yours what they want to see.
BTW, if you want to start with the single-house version before modeling a bigger project, 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.