Real Estate Development Pro Forma: Land to Stabilization

Real Estate Development Pro Forma: Land to Stabilization

An acquisition pro forma starts with a property that exists; a development pro forma starts with one that doesn't. That single difference reorganizes the entire model: before any rent is collected, the pro forma must build the asset — land, budget, construction financing, and time — and only then hand off to the operating analysis every other pro forma begins with. The development model is really two models welded together, and the weld — where cost meets income — is where the deal's one decisive metric lives.

This pillar walks the full structure, land to stabilization, with one illustrative project carried through every stage: the cost build to total development cost, the construction financing and its carry, the lease-up bridge, the two exits, and the return framework built around yield on cost. All figures are illustrative examples, not market data or cost estimates.

The project: a small ground-up rental building on a $1,200,000 land parcel, with $6,000,000 of hard costs, targeting roughly $700,000 of stabilized NOI in a submarket where stabilized product trades near a 6.25% cap.

Stage 1: Land and Basis

The model opens with the land — price, closing costs, and any carry between land close and construction start — and one discipline that pays for itself later: keep land as its own line forever. Land is the component that doesn't depreciate, the basis piece with its own tax treatment, and the number every "what did you pay for the dirt" conversation needs. Folding it into a blended cost figure loses information the model will want back.

Land is also where the pro forma's first honest question gets asked: is the price residual-consistent? Working the model backward — stabilized value, minus required margin, minus all costs — produces the land value the project can afford, and comparing it to the asking price is the fastest feasibility screen in development. That inversion, the residual land value analysis, is its own tool with its own uses; the development feasibility guide covers it. This pillar runs the model forward.

Stage 2: The Budget — Building to TDC

The cost side assembles into total development cost (TDC), and the assembly has a standard anatomy:

• Hard costs — the physical construction, built by trade (sitework, structure, envelope, MEP, finishes), not as one number. Trade-level detail is what makes the budget challengeable, comparable to contractor bids, and trackable against draws later. Our project: $6,000,000.
• Soft costs — everything non-physical: architecture and engineering, permits and fees, legal, taxes and insurance during construction, marketing, developer fee. Commonly estimated as a percentage of hard costs in early passes and built bottom-up thereafter. Illustratively at 20%: $1,200,000.
• Contingency — the budget's admission that demolition and ground reveal things. A hard-cost contingency (illustratively 5%: $300,000) is not padding; a development budget without one is not a budget, it is an opening bid.
• Financing costs and the interest reserve — the construction loan's fees plus the interest that accrues during the build, capitalized into the budget because the project has no income to pay it. Illustratively: $500,000. This line is computed, not guessed — it depends on the loan size, the rate, and the draw pattern, which is the subject of the construction draw schedule guide.

TDC: $9,200,000. Every downstream metric measures against this number, which is why the budget block earns more model discipline than any other: line items referenced, contingency explicit, nothing netted or hidden.

Stage 2.5: Pre-Development — the Money at Full Risk

Between land control and construction start sits a phase the budget must carry and beginner models compress to zero: pre-development. Entitlements, zoning, design development, environmental and geotechnical work, permits — months to years of spend before a shovel is justified, and capital of a fundamentally different character than everything after it. Construction-phase dollars buy a building; pre-development dollars buy the right to decide whether to build one, and if the answer is no, they are largely unrecoverable.

Two modeling consequences. First, the pursuit budget gets its own block with its own contingency — entitlement timelines are the least controllable schedule in the model, and every month of them accrues land carry. Second, the phase's option-like character belongs in the return framing: a project that spends $250,000 (illustrative) proving out a site before committing $9 million has bought information cheaply, and the model should make the go/no-go gate explicit — the point at which the feasibility question gets asked with real numbers and sunk pursuit costs are deliberately excluded from the answer. The gate analysis is the natural handoff to the feasibility framework.

The Developer Fee Question

One soft-cost line deserves its own paragraph, because it is the one where the money's identity gets contested: the developer fee — the developer's compensation for running the project, commonly a percentage of cost, sitting in the soft-cost block. Three clarities keep it honest in the model. It is a cost of the project, not profit: the margin is computed after it, and omitting it to flatter the spread is the development version of the missing management fee. It is frequently deferred or partially deferred in capital-constrained deals — paid at stabilization or from the capital event — in which case the model carries it as accrued, and its deferral is, economically, additional developer equity that the return framework should credit. And in syndicated developments it is the fee-versus-promote distinction all over again: the fee compensates the work, the promote compensates the performance, and the model reports both so investors can see the mix.

Stage 3: The Construction Loan

Development debt is sized differently — to loan-to-cost (LTC), a percentage of TDC, rather than to the value of an asset that does not yet exist (lenders will also test the eventual stabilized value and often a yield-on-cost or coverage view of the finished project, but LTC is the headline constraint). At an illustrative 65% LTC, our project borrows $5,980,000, leaving $3,220,000 of equity.

Two mechanics distinguish construction debt in the model:

• Draws, not proceeds. The loan funds as costs are incurred, with the standard convention that equity funds first and debt draws after — so interest accrues on a rising balance, not the full commitment.
• Capitalized interest. With no operating income, interest accrues into the loan (or draws from the interest reserve line in the budget), compounding the cost of every month the schedule slips. The carry math, the S-curve draw pattern, and the reserve sizing get their full treatment in the draw schedule and construction loan calculator guides; the pillar-level point is that the interest reserve is an output of the draw model, and a pro forma that hardcodes it has an unpriced schedule risk.

Stage 4: Lease-Up — the Bridge to Stabilization

Between certificate of occupancy and stabilized operations sits the phase acquisition models never have: lease-up. The model carries it explicitly — an absorption pace (units or square feet leased per month, evidenced from comparable lease-ups, not hoped), concessions typical of a building filling against competitors, and operating expenses that arrive at nearly full strength while revenue ramps from zero. Lease-up is negative-cash-flow territory by construction, and its length is a first-order driver of both the carry cost and the return: the model should treat absorption pace as a stressable input, not a footnote.

At the end of the bridge: stabilized NOI of $700,000 — the number the entire project was built to produce.

Stage 5: Yield on Cost — the Metric the Whole Model Serves

Now the weld. Yield on cost = stabilized NOI ÷ TDC = $700,000 ÷ $9,200,000 = 7.61%.

Read it against the market: stabilized product trades at 6.25%, so the project creates income at 7.61% that the market prices at 6.25%. That gap — the development spread, here about 136 basis points — is the entire economic argument for building instead of buying, and the compensation for everything that can go wrong between land close and stabilization: cost overruns, schedule slips, entitlement risk, lease-up risk, and the market's right to change its mind about the 6.25% while you build.

The spread converts directly to dollars: at the 6.25% market cap, the stabilized building is worth $700,000 ÷ 0.0625 = $11,200,000, against $9,200,000 of cost — a development margin of $2,000,000, or about 21.7% of cost. Spread and margin are the same fact in two units, and both belong on the model's dashboard, because the question every reviewer asks first — is the margin adequate for the risk? — is answered in whichever unit they think in.

Stage 6: The Two Exits

The stabilized project has two harvests, and the model should price both:

The merchant build — sell at stabilization. Net of illustrative 2% selling costs, the sale nets about $10,976,000 against $9,200,000 of cost: ~$1,776,000 of profit on $3,220,000 of equity — roughly a 1.55x multiple over the project's life (call it 30 months land-to-sale), an annualized return in the high teens on this simplified trace. Merchant economics are the development spread, realized and taxed.

The build-to-core hold — refinance and keep. The project refinances against the $11,200,000 stabilized value, retires the construction loan, returns a large share of equity, and holds a new asset at a 7.61% yield on a basis no acquirer can match. The hold converts the development margin from a taxable gain into a durable basis advantage — and the model prices it as a refinance event plus a standard hold-period analysis, which is exactly where the development pro forma hands off to the acquisition framework.

Which exit wins is a capital-and-conviction question, not a modeling one — but only a model that prices both lets the question be asked with numbers.

Stage 7: The Sensitivity That Matters

Development's two-sided exposure defines its sensitivity grid: cost overrun on one axis, exit (market) cap on the other, with yield on cost, margin, and the equity return repriced at each intersection. The grid's diagnostic read on our project: a 10% hard-cost overrun (+$600,000, before its own interest carry) and 50 basis points of cap softening together consume most of the $2,000,000 margin — which is the honest statement of what a 136bp spread is: adequate compensation for one of the big risks arriving, thin against both. Absorption pace deserves the third stress, run separately: months of slower lease-up land on the carry line and the margin simultaneously.

The Development-Specific Mistakes

1. No contingency, or contingency quietly spent in the base case.
2. A hardcoded interest reserve — carry guessed instead of computed from the draw pattern, leaving schedule risk unpriced.
3. Instant stabilization — NOI arriving at certificate of occupancy, with no absorption bridge.
4. Yield on cost computed on partial cost — land or soft costs omitted from the denominator, flattering the spread.
5. Margin without a market check — a 20% margin against an asserted exit cap is an assertion, not a margin; the cap comes from comps, per the direct capitalization discipline.
6. One exit modeled — merchant math only, with the refinance-and-hold path (often the better one) never priced.

Frequently Asked Questions

What is a good yield on cost for development? The metric is only meaningful as a spread over where stabilized product trades — the compensation for development risk. What counts as adequate scales with the project's risk (entitlement status, construction complexity, lease-up depth) and the cycle; the model's job is to compute the spread honestly and stress it, not to bless a universal number.

What is the difference between a development pro forma and a construction budget? The budget is one block of the pro forma — the cost side. The pro forma wraps it with the financing, the time, the lease-up, the stabilized operations, and the exit: the budget says what the building costs; the pro forma says whether building it makes money.

How is a development loan different from a permanent loan in the model? Sized to cost (LTC) rather than value, drawn over time rather than funded at close, with interest capitalized rather than paid from operations — and retired at the exit or refinance rather than amortizing through a hold. Each difference has its own block in the model.

Do I need a different model for condo/for-sale development? The cost side transfers; the revenue side does not — for-sale product replaces stabilized NOI and lease-up with a sellout schedule (units, pricing, absorption) and has no cap-rate exit. Same skeleton, different back half.

What hold period does a development pro forma use? Two clocks: the project clock (land to stabilization — our illustrative 30 months) always, and a hold-period extension only if the build-to-core exit is being priced. Merchant analyses end at the stabilized sale.

The Model, Land to Stabilization

Every stage of this pillar maps onto The Development Sheet: the trade-level development budget with soft costs, contingency, and a computed interest reserve rolling up to TDC; the construction loan sized to LTC; stabilized operations producing NOI and yield on cost; the financing-and-returns block with the development margin, profit, equity multiple, and IRR on the exit; and the cost-overrun × exit-cap sensitivity grid — fully unlocked, formula-transparent, versioned, with a documented methodology PDF. For the earlier-stage work — residual land value, go/no-go screening, and multi-scenario feasibility — the Development Feasibility Suite runs the same conventions upstream of the full pro forma.

This article is for educational purposes only and does not constitute investment, legal, or tax advice. All figures are illustrative examples, not market data or cost estimates. Consult qualified professionals before making investment decisions.