Aerial shot of a suburban neighborhood with houses and lush greenery, captured during the day.

Most residential land deals look fine on a spreadsheet.

The numbers balance. The margin clears a target threshold. The sensitivity tabs show tolerable downside. On paper, the deal works.

And yet many of these same deals under-perform, stall, or quietly fail once capital is committed.

The problem is not the math. The problem is what the math does not capture.

A pro forma is a useful tool, but it is not an evaluation. It translates assumptions into outputs, but it does not test whether those assumptions reflect how residential development actually behaves. Evaluating land beyond the pro forma requires shifting focus away from returns and toward structure, sequencing, and risk concentration.

What the Pro Forma is Good At

A well built pro forma does several things well.

It forces discipline around inputs. It exposes obvious inconsistencies. It allows comparison across opportunities using a common framework. It shows how changes in pricing, costs, or leverage affect projected returns.

Used correctly, it helps answer a narrow question: If the assumptions hold, what does the project produce?

That question is necessary, but it is not sufficient.

What the Pro Forma Cannot Test

The most important drivers of outcome in residential land and spec development tend to sit outside the spreadsheet.

Assumption Fragility

Most pro formas rely on point estimates that feel conservative but are rarely stress tested as systems.

Sale price, construction cost, and timeline are often treated as independent variables. In practice, they move together. A delay rarely shows up alone. It increases interest carry, invites cost escalation, and often coincides with softer exit conditions.

A spreadsheet can show what happens if one assumption changes. It does not show how small misses compound.

Timeline Behavior

Time is usually modeled as a fixed input. Twelve months becomes twelve rows of interest and holding costs.

In reality, residential development timelines behave in bursts. Permits stall. Reviews trigger follow up requirements. Builder schedules slip. Weather compresses sequencing. These delays are not evenly distributed, and they rarely resolve cleanly.

The pro forma treats time as linear. Real projects do not.

Execution Variability

Spreadsheets assume execution quality without measuring it.

They assume builders perform to plan, consultants coordinate effectively, decisions are made quickly, and capital remains available when needed.

None of this is guaranteed, and none of it is captured in a cell.

Two developers can underwrite the same parcel and produce identical pro formas, then experience dramatically different outcomes based on execution alone.

The Difference between Underwriting and Evaluation

Underwriting asks whether a deal works numerically.

Evaluation asks whether the structure of the deal is resilient to how projects actually unfold.

That distinction matters most in land, where early decisions lock in risk long before revenue is visible.

Evaluating beyond the pro forma means questioning the input assumptions.

Where Risk is Really Concentrated

Residential land risk tends to cluster in a few places that do not announce themselves in headline returns.

Entry Price Relative to Uncertainty

A land price that leaves little room for error can look fine under base case assumptions while being extremely fragile in practice.

Evaluation asks whether the purchase price reflects the amount of uncertainty that still exists, not just whether it fits within a residual calculation.

Dependency on Perfect Sequencing

Some deals require everything to go right in order to work. Permits must move quickly. Financing must remain available. Construction must proceed without interruption. The exit must arrive on schedule.

These deals often look strong in a pro forma and weak in reality.

A resilient deal can absorb missteps. A brittle one cannot.

Capital Structure Sensitivity

Leverage amplifies both returns and mistakes. The tighter the capital stack, the less room there is for delay, overrun, or rework.

Evaluation looks at where stress shows up first when assumptions slip, not just where returns peak if they hold.

Why Comparable Deals Can Be Misleading

Investors often point to nearby successes as validation. The problem is that outcomes are not transferable without context.

Two parcels can sit side by side and behave very differently once development begins. Soil, access, regulatory interpretation, builder capacity, and timing all matter. None of these are visible in a finished sale price.

A pro forma can replicate someone else’s outcome. Evaluation asks whether you are exposed to the same risks they absorbed, avoided, or simply got lucky with.

What a Better Evaluation Emphasizes

Looking beyond the pro forma does not mean discarding it. It means reframing its role.

A stronger evaluation process emphasizes:

  • How many assumptions must hold for the deal to work
  • Which risks are binary versus degradational
  • Where uncertainty remains after feasibility
  • How delays change both cost and exit conditions
  • Whether the margin compensates for how risk is distributed

The goal is not to eliminate risk. It is to understand where it lives and whether it is priced appropriately.

The Quiet Failure Mode

Many underperforming land deals are not obvious failures.

They close. They build. They sell.

They simply take longer, cost more, and return less than expected.

From the outside, they look fine. From the inside, they consume attention, capital, and optionality that could have been deployed elsewhere.

These outcomes are rarely caused by a single bad assumption. They are caused by a collection of small ones that were never evaluated together.

The Bottom Line

A pro forma is a translation tool, not a decision tool.

It tells you what the deal produces if the assumptions hold. It does not tell you whether those assumptions are fragile, interdependent, or mispriced.

Evaluating a residential land deal beyond the pro forma requires shifting focus away from projected returns and toward how risk behaves once real people, real timelines, and real capital are involved.

Good deals are not defined by clean spreadsheets. They are defined by structures that can tolerate how projects actually unfold.



If you’re evaluating a specific land or spec-home opportunity and want an independent second set of eyes, I offer Comprehensive Deal Reviews focused on assumptions, timelines, and downside risk. Details are available here.

About the author: Jonathan Kennedy is a real estate broker, Accredited Land Consultant (ALC), and active spec home developer. He helps private-capital investors make smarter investment decisions through a practical, data-driven approach to land evaluation, feasibility and risk analysis.