A subdivision development pro forma covers three distinct phases in one model: land acquisition and entitlement, lot development (grading, utilities, roads, infrastructure), and vertical homebuilding. Each phase has different cost drivers, different financing, and different timing. Sponsors who model each phase separately and then stitch them together produce cleaner models than those who throw all three into a single line-item sheet. This walkthrough uses a 38-lot single-family residential project to illustrate how the phases connect.
Phase 1: Land acquisition and entitlement#
The land acquisition section of the model captures the purchase price, earnest deposit, closing costs, and the carrying costs during the entitlement period. For a by-right subdivision, entitlement typically runs 4 to 8 months. For a deal requiring a variance or conditional use permit, budget 12 to 18 months. That time has a cost: property taxes, insurance, and the interest reserve on any acquisition financing all accrue during entitlement before a shovel hits the ground.
On a $1.4M land purchase for 38 lots, closing costs run $30K to $50K. If you finance the acquisition at 60 percent LTV with a land loan at SOFR plus 350 bps, the carry on $840K for 8 months of entitlement adds another $45K to $55K to the land cost line. Many sponsors miss this and then wonder why their interest reserve is short at close of construction financing.
Phase 2: Lot development#
Lot development converts raw land into finished, buildable lots. The cost components are grading and earthwork, underground utilities (water, sewer, gas, electric, telecom), roads and curbs, stormwater infrastructure (detention basin, swales, inlets), landscaping of common areas, and off-site improvements required by the municipality.
For a 38-lot subdivision in a Sun Belt market, lot development costs run $40K to $65K per lot in 2026, depending on topography, distance from existing infrastructure, and the extent of off-site improvements required. On a flat site near established utilities, $42K per lot is achievable. On a site with significant grade change or a required off-site sewer extension, $65K per lot is not unusual.
Lot development is typically financed with a construction loan at 65 percent of the appraised finished lot value. The finished lot value is derived from the land comp market in the submarket, supported by a formal appraisal. Budget 3 to 4 percent of the lot development budget for the appraisal, title insurance, and lender fees associated with this tranche of financing.
Phase 3: Vertical homebuilding#
Once finished lots are available, vertical construction begins. For a 38-lot project with 2,100 SF average homes, vertical hard costs in the Sun Belt run $270K to $310K per home in 2026. That breaks into roughly $145 per SF for framing, MEP, finishes, and GC overhead, plus a site work and foundation allowance of $20K to $35K per home.
The absorption schedule determines when revenue flows. At 2 closings per month (a conservative Sun Belt rate for a well-located SFR product in the $550K to $625K range), 38 homes close in 19 months. That absorption schedule drives the monthly revenue line, which drives the interest reserve calculation, which is where most sponsors underestimate by 20 to 30 percent.
How to build the sources and uses#
The sources and uses table for a 38-lot subdivision looks like this at a high level: land at $1.4M, lot development at $1.96M (38 times $51.5K), vertical construction at $10.83M (38 times $285K), soft costs at $1.55M (12 percent of hard costs), carry and interest reserve at $1.12M, sales commissions at $1.09M (5 percent of $21.85M gross revenue), and contingency at $1.02M. Total project cost: $19.97M. Gross revenue at $575K per home: $21.85M. Project profit before financing and GP promote: $1.88M at the base case.
Financing layers: construction loan at 65 percent LTC equals $12.98M. Equity required equals $7.0M. At an 8 percent pref and 70/30 promote, LP equity is $6.65M and GP co-invest is $350K.
The numbers that decide the deal#
Project IRR at the base case absorption assumption: 18.2 percent over a 38-month total hold. LP net IRR after the waterfall: 14.8 percent. LP equity multiple: 1.64x. Residual land value at the 18 percent IRR hurdle: $1.38M. Since the land cost is $1.4M, the deal clears by a thin $20K margin at the base case. The sensitivity analysis on exit price per unit versus land cost will show that a 5 percent downward move in exit price pushes the deal below the hurdle. That is the conversation to have with the seller before signing the LOI.
River builds the full subdivision pro forma, including the phased cash flow, the waterfall, and the sensitivity table, automatically from a parcel description. Try the development analyst on your next land deal.