10-Step Subdivision Underwriting Workflow Example

A subdivision can look profitable on a broker flyer and still lose money once off-site sewer, export, stormwater, and a slow absorption schedule enter the model. This subdivision underwriting workflow example shows how an acquisition or development team can move from a raw parcel to a defensible go, no-go, or renegotiate decision before spending heavily on engineering.

The point is not to create a perfect model during the first pass. It is to identify the assumptions that can kill the deal, quantify them early, and make the next dollar of diligence intentional. A credible underwriting workflow connects GIS research, civil feasibility, sitework costs, and returns in one sequence. If those pieces stay disconnected, the proforma will usually be optimistic by default.

1. Set the deal frame before mapping the site

Start with the investment question, not the acreage. Define the intended product, target lot count, expected lot width and depth, preliminary density, acquisition basis, and planned hold period. For a 62-acre property, the working concept might be 145 detached lots on 50-foot widths, with a target finished-lot price of $58,000 and a 36-month development schedule.

That concept is not a layout. It is a testable starting position. The underwriting team should also establish the return thresholds that govern the decision: minimum levered IRR, minimum margin on cost, maximum land basis per finished lot, and a contingency policy. Without these guardrails, teams can spend weeks refining a plan that never met the investment mandate.

2. Confirm control, boundaries, and usable acreage

Pull parcel boundaries, acreage, owner information, tax data, deed references, and adjacent ownership. Then verify whether the marketed tract is actually the tract being priced. Access strips, excluded parcels, split ownership, and boundary discrepancies can materially alter a subdivision plan.

Gross acreage is only a headline number. Underwriting needs an early estimate of usable acreage after removing or accounting for floodplain, wetlands, steep terrain, utility easements, stream buffers, road setbacks, and irregular property edges. A 62-acre site with 14 constrained acres does not necessarily yield 48 buildable acres, but it certainly should not be modeled as 62.

This step also identifies assemblage risk. If a necessary entrance, utility route, or second access depends on a neighboring owner, model that dependency as a cost and schedule exposure rather than treating it as a future courtesy.

3. Screen the constraints that change density or cost

Run the site through the layers that affect the subdivision concept: FEMA flood zones, wetlands indicators, hydrology, contours, soils, existing utilities, road classifications, zoning, and known environmental conditions. This is where a visually attractive tract often starts telling the real story.

For example, a creek corridor may reduce lot count, but the larger impact may be the stormwater strategy and the amount of grading required to maintain road grades around it. A public sewer main near the boundary may look favorable until invert elevations show the site cannot gravity-flow without a lift station. The underwriter should distinguish between a constraint that is manageable and one that changes the business plan.

Do not treat preliminary GIS findings as final environmental or engineering conclusions. Treat them as underwriting inputs that determine which questions must be answered before closing. A desktop wetlands indication may require field delineation. A mapped utility line may still require capacity confirmation from the provider.

4. Build a yield range, not a single lot count

Use the usable-area screen and local development pattern to establish low, base, and high yield cases. In the example, the team may underwrite 128 lots as the downside case, 138 lots as the base case, and 145 lots as the upside case.

The base case should be the number you can defend without relying on every favorable assumption. If yield depends on a variance, an unconfirmed off-site connection, or unusually small stormwater acreage, it belongs in the upside case until proven otherwise.

This is also where absorption and product fit enter the conversation. A site may support 145 lots physically but only justify 120 lots economically if competing inventory is deep, household formation is slowing, or the market favors a different lot size. Density is a revenue input, but it is also a sales-rate decision.

5. Turn terrain into a preliminary civil scope

Topography should not be a screenshot attached to the file. Use elevation data to estimate cut and fill, identify likely retaining conditions, trace drainage paths, and understand where roads and utility corridors can realistically run. Then translate those conditions into scope assumptions.

For this example, the preliminary concept may indicate 42,000 cubic yards of cut, 30,000 cubic yards of fill, 12,000 cubic yards of export, two retaining-wall zones, and a stormwater pond occupying four acres. The exact quantities will change with engineering. The underwriting question is whether the site is generally balanced, export-heavy, or structurally expensive before the first civil proposal arrives.

Earthwork is especially sensitive to bad early assumptions. Haul distance, disposal availability, unsuitable soils, rock, and weather can move the cost quickly. Use a clear contingency tied to the level of uncertainty, not a generic percentage applied because the spreadsheet needs one.

6. Price the sitework from quantities, not allowances

A subdivision estimate should reflect the actual work needed to create finished lots. Break the budget into practical categories: mobilization and clearing, earthwork, erosion control, stormwater, sanitary sewer, water, dry utilities, roads, curbs, sidewalks, retaining, landscaping, and off-site improvements.

Within those categories, use measurable line items. A 45-line-item estimate is far more useful than a single site-development allowance because it reveals what is driving the number. If sanitary sewer is unusually high, the team can test a gravity alternative, revise the lot layout, or negotiate the land price. If road cost is high because of frontage improvements, that burden can be addressed directly in the deal structure.

Southeast cost defaults can speed the first pass, but local calibration still matters. Unit costs in a fast-growing metro, a rural county with limited subcontractor capacity, and a mountainous market should not be treated as interchangeable. Underwrite with current local bids or contractor intelligence whenever the deal advances beyond screening.

7. Add soft costs, financing, and timing with discipline

Hard costs alone do not buy the project. Add engineering, entitlement, legal, surveying, geotechnical work, permits, impact fees, insurance, project management, marketing, brokerage, and developer overhead. Then map when those costs hit.

Timing is often where a healthy margin becomes a thin one. A four-month utility approval delay can increase interest carry, postpone lot deliveries, and shift sales into a weaker period. Model acquisition closing, entitlement, construction start, horizontal completion, lot takedowns or home sales, and final closeout month by month.

Financing assumptions should match the likely capital structure, including loan-to-cost, interest rate, fees, interest reserve, equity contribution timing, and lender-required contingency. If the project only works with aggressive leverage and no schedule slippage, that is not a base case. It is a warning.

Subdivision underwriting workflow example: testing revenue

In the 138-lot base case, assume finished-lot revenue of $58,000 per lot. That produces $8.004 million in gross revenue before commissions, incentives, and any builder-specific concessions. The underwriting should test whether that lot price is supported by current new-home pricing, builder margins, competing communities, and the pace at which builders can absorb deliveries.

Run at least three revenue cases. The downside may use 128 lots at $54,000 per lot with slower deliveries. The base case uses 138 lots at $58,000. The upside uses 145 lots at $61,000, but only if comparable sales and builder demand support it. Do not offset an uncertain yield with an aggressive lot price to force the IRR.

8. Make the proforma show the decision, not hide it

Bring land cost, horizontal costs, soft costs, financing, revenue, timing, and taxes into one integrated proforma. The output should show total development cost, cost per finished lot, gross margin, margin on cost, equity requirement, levered IRR, and sensitivity to the assumptions that matter most.

For the example, the key sensitivity may be a combination of lot count and sewer cost. A loss of 10 lots reduces revenue materially, while an added lift station may raise both hard cost and ongoing approval risk. Displaying these variables together is more useful than arguing over which single number is “correct.”

A good model also separates known costs from allowances and flags every unverified condition. This protects the acquisition team from presenting a false level of certainty to an investment committee.

9. Convert uncertainty into diligence actions

The underwriting output should end with a short, assigned risk register. For this site, the highest-priority actions might be confirming sewer capacity and invert elevations, ordering wetlands field work, obtaining a preliminary geotechnical opinion, validating the road-improvement requirement, and requesting a concept-level civil review.

Each action needs an owner, a budget, and a deadline tied to the purchase agreement. If a risk cannot be resolved during the feasibility period, decide whether to price it, extend diligence, seek a contingency, or walk away. Hope is not a mitigation strategy.

10. Package the decision for fast review

The final first-pass package should be easy to review without rebuilding the analysis. Include a site map with constraint overlays, a yield summary, the preliminary sitework estimate, the integrated proforma, key sensitivities, and the open-risk register. A branded PDF report and an Excel export can give the investment committee both the decision view and the audit trail.

Land Takeoffs helps teams keep this sequence in one GIS-centered workspace, so terrain, constraints, estimating, and financial outputs stay connected as assumptions change. That matters when a revised utility route or new floodplain finding needs to flow through cost and returns the same day.

The best underwriting does not pretend that a raw-land deal is fully known before engineering. It makes uncertainty visible, puts a price and a schedule around it, and gives the team a clear reason to proceed, renegotiate, or preserve capital for the next tract.