How to Build a Real Estate Development Pro Forma

A real estate development pro forma is the financial model for a project that does not exist yet. It estimates what the project will cost to build — land, construction, fees, financing — when that money will be spent, how the finished property will perform once it is leased, and what it will be worth at completion. The output that matters is the spread between total development cost and completed value: the development profit that compensates you for taking construction risk.

This guide walks through building one from scratch: the cost categories, the timeline, construction financing and the interest reserve, stabilization, yield on cost, exit value, and returns — with a worked example you can follow line by line. It supports the broader real estate development guide, which covers the concepts; this article is about actually building the model.

What Is a Real Estate Development Pro Forma?

A development pro forma is a projection of everything a ground-up project costs, everything it will earn once complete, and the profit between the two. It answers four questions: What will this cost to build, all-in? How much of that is debt and how much is equity? What is the finished, stabilized property worth? And is the spread between cost and value large enough to justify the risk of building instead of buying?

It is a fundamentally different model from underwriting an existing property. An operating property has income from the first day of ownership, expenses you can verify from actual statements, and financing that funds at closing. A development has only costs until lease-up, a budget and a schedule instead of a T12, and a construction loan that funds in stages as work is completed. Applying an operating model to a project with no operations is the most common way a development deal gets analyzed wrong.

What Goes Into a Development Pro Forma

Every development pro forma, whatever the asset type, is built from the same components:

• Land and acquisition costs — what it takes to control the site
• Hard costs — the physical construction
• Soft costs — design, permits, legal, insurance, fees and other non-construction costs
• Contingency — the budget line for what you cannot yet see
• Construction financing — the loan, its fees, and the interest carried during the build
• The schedule — how long acquisition, permitting, construction and lease-up each take
• Lease-up and stabilization — the ramp from empty building to normal operations
• Operating assumptions — rents or sale revenue, vacancy, operating expenses
• Exit assumptions — sale, refinance, or hold, and the value at that point
• Returns — development profit, return on cost, and time-weighted measures like IRR

The rest of this guide takes them in the order you would actually build the model.

Step 1: Model the Land Acquisition

Land basis is more than the purchase price. It includes closing costs, legal and title work, the due diligence that proves the site can support the project — surveys, environmental assessments, geotechnical reports — and any carrying costs between closing on the land and starting construction: property taxes, insurance, and interest on a land loan if there is one.

That last category is easy to miss. If entitlements or permits take a year, the land carries for a year before a shovel moves, and that carry is part of total project cost whether the model admits it or not. The due diligence discipline that applies to buying an existing property applies double to land, because you are also verifying what you are allowed to build on it — zoning, density, setbacks, utilities and access.

Step 2: Estimate Hard Costs

Hard costs are the physical construction: site work and infrastructure, the vertical structure, materials, labor, the general contractor’s costs and fee, and interior build-out — unit finishes for residential, tenant improvements for commercial. They are usually the largest bucket in the budget, and they are typically estimated per buildable square foot: buildable area times cost per square foot.

Where that cost-per-foot number comes from matters more than the arithmetic. Early in a project it is a placeholder from comparable projects; as design advances it should be replaced by contractor estimates and eventually by actual bids. A pro forma carrying a placeholder cost into a committed deal is carrying the project’s largest number on its weakest evidence.

Step 3: Estimate Soft Costs

Soft costs are everything the project requires that is not physical construction:

• Architecture and engineering
• Permits, impact fees and municipal charges
• Legal, accounting and title work
• Insurance during construction
• Developer fees, where the structure includes them
• Inspections and testing
• Marketing and leasing costs for the lease-up
• Financing fees — often broken out with the financing costs instead

Categorization varies between models — some put financing fees and marketing in their own buckets, some fold them into soft costs. The categorization matters less than the completeness: soft costs are the bucket beginners underestimate, because every line in it is invisible on a construction site. For a deeper treatment of what belongs in each bucket — and the items that legitimately move between them — see hard costs vs soft costs in real estate development.

Step 4: Add Contingency

Contingency is a budget line for costs you cannot itemize yet: change orders, unforeseen site conditions, material price movements, redesigns. It is typically set as a percentage of construction costs, sized to the project’s risk — a simple build on a clean site needs less than a complex one on a constrained site or unproven ground.

Two rules keep contingency honest. First, it is part of total project cost from day one — it raises the equity requirement and the loan sizing, and every return the model reports should already be net of it. Second, it is not deferred profit. A contingency that goes unspent is a pleasant surprise at the end; a model that counts on it being unspent has quietly removed the project’s margin for error and called the result upside.

Step 5: Build the Development Timeline

A development pro forma is a schedule as much as a budget. The typical stages: land acquisition, predevelopment and design, permitting and entitlements, construction, completion, lease-up, stabilization, and then sale or refinance. Each stage has a duration, and the durations drive costs.

This is why a dollar spent in the second month of a project is financially different from a dollar spent in the twentieth. The early dollar is borrowed or invested for the entire remaining timeline — it accrues interest, ties up equity, and delays nothing. The late dollar carries for only a few months. Timing determines how much interest the project pays, how long equity is locked up, and — because time-weighted returns reward money that comes back sooner — what the same profit is worth as a return. A pro forma without a timeline is a shopping list, not a model.

Step 6: Model the Construction Financing

Construction debt behaves differently from a permanent mortgage, and the model has to reflect three differences.

First, sizing. A construction loan is sized by loan-to-cost (LTC): the loan amount divided by total project cost. This is the development analogue of loan-to-value — LTV compares a loan to what a property is worth, LTC compares it to what the project costs to create. The two can differ substantially: a project costing $16 million that will be worth $20 million finished has very different LTC and LTV on the same loan. LTC sets the equity requirement directly — whatever the loan does not cover, the equity must.

Second, funding. A construction loan does not fund at closing. It funds in draws — periodic disbursements against completed work, verified by inspections. Early in the project little of the loan is outstanding; the balance builds as construction progresses.

Third, cost. Because the balance builds over time, interest accrues on the drawn balance, not the full commitment — and it accrues during a period when the project produces no income to pay it, which is what the interest reserve in the next step exists for. Loan fees, typically charged on the full commitment, belong in the budget as well. Construction loans are also commonly floating-rate, priced off a benchmark, so the rate assumption deserves the same scrutiny as any other input — benchmark rates move underwriting math between the day you model and the day you close. Bank supervisors treat construction lending as its own risk discipline for exactly these reasons; the OCC’s Comptroller’s Handbook on commercial real estate lending covers acquisition, development and construction financing as a distinct category from income-property lending.

Step 7: Size the Interest Reserve

The interest reserve is the part of the budget set aside to pay the construction loan’s interest during the build, while the project has no income. It is usually funded by the loan itself: each month’s interest is added to the drawn balance rather than paid from the developer’s pocket.

How much interest the project pays depends on four things: how much is drawn, when it is drawn, the interest rate, and how long construction takes. It is not a fixed percentage of anything. A common approximation early in modeling is to assume the loan is drawn evenly across the build, so the average outstanding balance is about half the full loan:

Estimated Construction Interest ≈ Loan Amount × Interest Rate × Construction Period (years) × Average % of Loan Outstanding

A detailed model replaces that approximation with a month-by-month draw schedule, and iterates — because the interest reserve is part of the budget, and the budget determines the loan, which determines the interest. For a first-pass pro forma, the average-balance estimate is honest as long as you label it an estimate. What is not honest is charging interest on the full loan from day one (which overstates cost) or forgetting the reserve entirely (which understates it — and understating it is worse, because running out of interest reserve mid-project is a genuine emergency). The full financing machinery — LTC, draws, funding sequences and reserve sizing — gets its own treatment in construction financing: LTC, draws and the interest reserve.

Step 8: Model Completion, Lease-Up and Stabilization

“Construction complete” and “stabilized” are different events, often many months apart, and the gap between them costs money.

At completion you have delivered units or rentable area — and, usually, an empty building. Lease-up is the period of marketing, concessions and operating losses while occupancy climbs. Stabilization is the point where occupancy and rents reach normal operating levels for the market. Only then does the property earn its stabilized net operating income — revenue at stabilized occupancy, minus normal operating expenses.

The pro forma needs assumptions for market rents or sale prices, vacancy at stabilization, operating expenses, and — critically — how long lease-up takes. A model that flips from construction directly to full occupancy has skipped the months when the finished building carries full expenses, full debt, and partial income.

Step 9: Calculate Yield on Cost

Yield on cost is the development world’s core profitability metric:

Yield on Cost = Stabilized NOI ÷ Total Project Cost

It answers: what does the finished project earn on everything it took to create it? A project with $1,200,000 of stabilized NOI on $16,000,000 of total development cost has a 7.5% yield on cost.

The number means little alone. It is judged against the market capitalization rate the same finished property would trade at — the return you could buy without construction risk. The gap between yield on cost and the market cap rate is the development spread, and it is the entire financial argument for building: if the project yields 7.5% on cost and comparable stabilized properties trade at a 6% cap rate, the spread is 1.5 percentage points. What spread is “enough” depends on the project’s risk, the market, and your alternatives — there is no universal threshold, and anyone quoting one is describing their own risk appetite, not a rule. The metric, its comparisons and its blind spots get a full treatment in yield on cost in real estate development.

Step 10: Estimate the Exit Value

For a property you will operate or sell as an income asset, the standard estimate of completed value is:

Estimated Stabilized Value = Stabilized NOI ÷ Exit Cap Rate

For a for-sale project — homes, condos — value is sale revenue instead: units times expected price, net of selling costs.

Three cautions. The exit cap rate is the most powerful single assumption in the model, and it describes a market condition at a future date you cannot know — small movements produce large value swings, which is why the sensitivity section below exists. Selling costs — brokerage, transfer taxes, legal — come out of the proceeds and belong in the model. And a refinance-and-hold exit replaces the sale assumption with a different one: the loan proceeds a permanent lender would advance against the stabilized property. Either way, exit value is an assumption you are making today about a transaction that happens years from now. Treat it as the hypothesis it is, not a fact.

Step 11: Calculate Investor Returns

With costs, financing, stabilization and exit modeled, the returns fall out:

• Development profit — completed value (net of selling costs) minus total project cost
• Return on cost — that profit divided by total project cost
• Equity multiple — total cash returned to equity divided by total equity invested
• IRR — the time-weighted return, which accounts for when each dollar goes out and comes back
• Cash flow — for a hold, the annual income after stabilization and permanent debt service

IRR deserves a specific warning in development. Because all the equity goes in early and nearly all the return arrives at the end, development IRR is extremely sensitive to timing: the same dollar profit earned in three years instead of four is a dramatically higher IRR. That makes schedule slip a returns problem, not just a budget problem — and it makes an IRR quoted without its timeline assumptions close to meaningless.

A Worked Development Pro Forma Example

Here is a deliberately simplified example with round, hypothetical numbers — they are chosen for arithmetic clarity, not as market benchmarks. Assume a 50,000-buildable-square-foot project.

Walking through the calculations:

1. Base costs: $2,000,000 land + $10,000,000 hard + $2,150,000 soft + $1,000,000 contingency = $15,150,000.
2. Construction interest: a $10,000,000 loan at a 9% example rate over a 20-month build, drawn evenly so the average outstanding balance is about 50% of the loan: $10,000,000 × 9% × (20 ÷ 12) × 0.5 = $750,000. Loan fees at 1% add $100,000.
3. Total project cost: $15,150,000 + $850,000 of financing costs = $16,000,000.
4. Equity: the $10,000,000 loan is 62.5% of the $16,000,000 total, leaving $6,000,000 of equity (37.5%).
5. Yield on cost: $1,200,000 stabilized NOI ÷ $16,000,000 = 7.5%.
6. Exit value: $1,200,000 ÷ 6.0% exit cap = $20,000,000. Selling costs at 2% ($400,000) leave net proceeds of $19,600,000.
7. Development profit: $19,600,000 − $16,000,000 = $3,600,000 — a 22.5% return on cost.
8. Equity outcome: net proceeds of $19,600,000 repay the $10,000,000 loan, returning $9,600,000 to the $6,000,000 of equity — a 1.60× gross multiple, before lease-up cash flows, loan amortization, and any promote structure, all of which a full model would carry.

A real model refines every one of these lines — a monthly draw schedule instead of an average balance, lease-up cash flows instead of a jump to stabilization, and an iterated interest reserve. But the skeleton is exactly this.

Stress-Test the Pro Forma Before You Trust It

A development pro forma has more assumptions than an acquisition model and a longer runway for them to go wrong, so a single base case is not underwriting. The assumptions that most deserve stress: hard costs, construction duration, interest rates, rents, lease-up pace, stabilized occupancy, and the exit cap rate. The last one, plus costs, usually dominates.

Using the worked example, here is what single-assumption changes do to the $3,600,000 base profit (each case changes one input, holds the rest, and ignores the additional interest a costlier or slower project would actually accrue — the real damage would be modestly worse):

Notice the last row: a moderate cost overrun and a half-point of cap-rate softening — neither remotely extreme — together remove about seventy percent of the profit. Overruns and soft exits also tend to arrive in the same market conditions, which is why running the downside as an explicit scenario, rather than as a mental note, is the single highest-value habit in development underwriting.

Common Development Pro Forma Mistakes

• Forgetting soft costs, or carrying them as a token line — they are invisible on site and very visible in the budget
• Underestimating contingency, or treating an unspent contingency as guaranteed profit
• Assuming all construction costs are spent on day one — which overstates interest — or ignoring timing entirely, which understates it
• Calculating interest on the full loan amount from inception instead of the drawn balance
• Confusing LTC and LTV, and sizing equity off the wrong one
• Treating construction completion as stabilization, skipping the lease-up months of full expenses and partial income
• Omitting lease-up costs: marketing, concessions, and the operating shortfall before break-even
• Underwriting rents above what comparable properties actually achieve, because the pro forma needed them
• Compressing the exit cap rate below today’s market to make the value work
• Omitting selling or refinance costs from the exit
• Never stress-testing the schedule — a delay costs interest, carry, and IRR simultaneously

None of these is exotic. Every one is an ordinary modeling choice that quietly moves the answer in the flattering direction — which is exactly why they persist.

Development Pro Forma vs. Acquisition Underwriting

If you already underwrite existing properties, the development model will feel familiar in its metrics and alien in its structure:

The evidence standard differs too. An acquisition underwrite starts from documents — a T12, a rent roll — and argues with them. A development pro forma starts from estimates and has to earn its credibility another way: bids instead of placeholders, comps for the rent assumptions, and stress tests in place of operating history.

How DealWorthIt Handles New Construction Analysis

DealWorthIt’s new construction workflow is a development pro forma of exactly this shape. You enter the land and acquisition cost, buildable square feet, hard cost per square foot, soft costs, and contingency as separate inputs; a construction loan sized by loan-to-cost with a rate and term, with interest carried on an average drawn balance across the build period; the build duration; and the exit assumptions. It covers residential single-family and multifamily, retail, office, mixed-use and industrial building types in one workflow.

The model returns total development cost broken into land, hard, soft and contingency, the interest carried over the build, the equity required and loan-to-cost, completed value, development profit, and return on cost. Every assumption stays editable, so the stress cases from this article — a hard-cost overrun, a softer exit — are a re-run, not a rebuilt spreadsheet.

Analyze a new construction deal — or start with the concepts in the real estate development guide.

Final Takeaway

A development pro forma is a budget, a schedule, and an exit hypothesis in one model. Build it in order: land, hard costs, soft costs, contingency, the timeline, the construction loan and its interest reserve, lease-up to stabilization, then yield on cost and exit value. Judge the project on the development spread — what building earns over buying — and never on the base case alone, because the two assumptions most likely to move against you, costs and the exit, are also the two the model is most sensitive to.

The pro forma will not make the project succeed. What it will do, built honestly, is tell you before you commit whether the project deserves the risk — and exactly how much has to go right for the answer to stay yes.