Subdivision Proforma Case: Underwrite Before You Buy

A subdivision proforma case is not a polished spreadsheet prepared after the deal is effectively decided. It is the acquisition test that tells you whether a tract can carry its land basis, sitework, financing, and sales timeline before you spend serious money on earnest money, engineering, or options.

For a residential developer, the difference between a good-looking site and a viable subdivision often comes down to a few connected assumptions: net lot yield, earthwork, off-site utility extensions, stormwater requirements, and absorption. Miss one of them, and a deal that clears a quick residual land-value calculation can become a capital trap.

The objective is straightforward: turn what the ground can actually support into a defensible return model. That requires more than multiplying gross acreage by a familiar density number.

What a subdivision proforma case must prove

A credible proforma should answer four questions before the acquisition team recommends a land price. First, how many saleable lots can the tract reasonably deliver? Second, what will it cost to entitle, develop, and carry those lots? Third, how quickly can the market absorb finished lots or homes? Finally, after debt, timing, contingency, and risk are accounted for, does the project still meet the required return?

Those questions sound basic. The problem is that each one affects the others. A lower yield raises land cost per lot. More cut and fill can increase sitework cost and extend the development schedule. A longer schedule increases interest carry and may push revenue into a weaker sales period. Treating those inputs as isolated line items is how early underwriting becomes falsely optimistic.

A useful model is detailed enough to expose the drivers but simple enough to update as new diligence arrives. At the early stage, precision should be honest rather than theatrical. A model with 47 perfectly formatted assumptions is not better if its lot count is still based on a broker flyer.

Start with a net-lot view, not gross acreage

Gross acreage is a starting point, not the yield. The real question is how much land remains after roads, open space, buffers, stormwater, easements, wetlands, floodplain, steep terrain, and required frontage are addressed.

A 100-acre tract in a favorable zoning district may appear capable of 300 lots at three units per acre. But if 18 acres are constrained, another 16 acres go to streets and stormwater, and the site needs a substantial utility corridor, the workable layout may be materially lower. Even a 15-lot reduction can change land basis by thousands of dollars per lot.

Use a preliminary concept plan whenever possible. If one is not available, build a transparent yield range rather than presenting a single number as fact. For example, an acquisition team may underwrite a base case of 210 lots, a downside case of 190, and an upside case of 225. The range is not indecision. It is a disciplined way to price incomplete information.

Check the constraints that move yield

Constraint review should happen before the proforma is treated as decision-ready. FEMA flood zones, wetlands indicators, topography, drainage paths, utility availability, access geometry, and jurisdictional setbacks all deserve attention. So do less obvious issues such as downstream capacity, required turn lanes, off-site water upgrades, sewer lift stations, and rock.

The key is to convert each finding into a business consequence. A creek buffer is not just a GIS layer. It may reduce lots, relocate a road, expand a pond, or create a more expensive crossing. A utility main shown near the property is not utility service. Confirm size, capacity, ownership, elevation, connection point, and extension requirements.

Build development costs from the terrain outward

Subdivision costs should be grounded in quantities and scope, not copied from a prior project with a similar lot count. Two 200-lot projects can have dramatically different economics because one is flat with nearby utilities and the other requires mass grading, import, retaining, a lift station, and a long off-site road improvement.

Start with the site conditions that drive hard cost: clearing, stripping, cut and fill, export or import, rock, erosion control, roads, curb and gutter, water, sewer, stormwater, dry utilities, and landscaping. Then include soft costs, permits, impact fees, bonds, legal, engineering, marketing, financing, and contingency.

For early underwriting, use a line-item estimate that makes assumptions visible. If earthwork is carrying the budget, show estimated cut, fill, balance, hauling, and any assumed disposal or import. If utilities are uncertain, separate on-site installation from off-site extensions and municipal participation. That makes it easier to revise the model without burying changes inside one broad "site development" allowance.

Land Takeoffs is built for this sequence: assess terrain and constraints, turn the site into a detailed estimate, and carry those costs directly into the development proforma. The value is not a prettier budget. It is knowing which field conditions are driving the deal before the purchase contract hardens.

Use contingency as a risk allowance, not a plug

Contingency should reflect what is unknown. A site with preliminary engineering, confirmed utility letters, and a balanced earthwork plan may justify a lower allowance than a site being evaluated from conceptual GIS data. Early-stage contingency often needs to cover items such as unsuitable soils, off-site requirements, permitting conditions, escalation, and incomplete design.

Do not use contingency to rescue an overbid land price. If the deal only works after contingency is reduced below a reasonable level, the deal does not work yet.

Match revenue timing to the actual exit

The revenue side of a subdivision proforma case depends on the business plan. A developer selling finished lots to builders will model a different cash flow than a merchant builder delivering homes to retail buyers. The distinction affects revenue timing, closing costs, working capital, construction exposure, and return metrics.

For finished-lot sales, model lot takedowns by builder, deposit structure, closing cadence, price escalations, and any required model-home or first-phase delivery commitments. For a build-for-sale strategy, model starts, construction duration, closings, incentives, commissions, and sales velocity. In both cases, the monthly or quarterly curve matters more than a single annual revenue number.

Absorption deserves a defensible local view. Comparable communities, competing inventory, price points, builder appetite, school zones, and infrastructure timing all matter. A market may support 60 lots per year at one price and only 35 at a higher price. Underwriting should test both, especially when projected price growth is doing too much work in the return calculation.

Stress the assumptions that can break the deal

A base case is only useful when paired with downside cases. The strongest acquisition teams do not ask whether the model can produce a target levered IRR. They ask what would have to go wrong for the investment to miss, and whether the land price still leaves room for that risk.

Test changes in lot yield, sales price, absorption, development cost, horizontal schedule, interest rate, and land closing timing. Then identify the break-even point for each. If a 5% cost increase eliminates the margin, the project is highly sensitive and should be priced accordingly. If the project remains acceptable with 10 fewer lots and six months of delay, the team has more room to proceed.

Sensitivity analysis also improves negotiations. Rather than saying the seller's price feels high, the buyer can show that the property supports a specific range based on a 195-lot downside case, verified utility scope, and a realistic carry period.

Keep the model tied to diligence, not hope

The proforma should evolve as the deal advances. Early screening may rely on parcel data, topography, market assumptions, and order-of-magnitude costs. During diligence, replace those assumptions with survey information, preliminary engineering, utility confirmations, geotechnical findings, agency feedback, and contractor pricing.

Maintain an assumptions log beside the financial model. Record the source, date, owner, and confidence level for major inputs. This reduces the common failure mode where a changed utility assumption is updated in one worksheet but not in the acquisition memo, estimate, or investment committee package.

The best time to find a weak assumption is while the property is still under evaluation. A subdivision proforma case should create productive friction early: challenge yield, quantify site risk, and make the land price earn its place in the deal. That discipline gives the team a clearer answer when the only question that matters arrives: buy, renegotiate, or walk away.