Land Development Proforma in Excel: How to Build the Model

Most land deals die in pencil, not at the closing table. The buyer who walked away from a 40-lot subdivision because their land development proforma Excel model showed a 6% IRR is the buyer who keeps capital intact. The buyer who closes on a "great location" without modeling the absorption schedule is the buyer who finds out, 28 months in, that the bank wants their personal guarantee called.

A land development proforma in Excel is the document that decides this. Done right, it tells you the maximum land price you can pay, how much soft cost float you need before the first lot sells, and exactly which month carry costs will eat your contingency. Done wrong, it is a vanity exhibit for a pitch deck.

This article walks through how to build a land development proforma Excel model from scratch, with the inputs, formulas, and exit math that real underwriters run before they sign a term sheet.

The Real Cost of a Bad Pro Forma

A 50-lot subdivision in a Sun Belt suburb pencils to roughly $4.5 million in hard costs and $700K in soft costs. The land itself might be $1.8 million. Total project cost: $7 million. Gross lot revenue at $90,000 per lot: $4.5 million. Wait. That does not work.

That is the problem. Buyers run gross lot revenue against hard costs, see a "spread", and skip the dozen line items that turn a 22% projected margin into a 4% actual margin. The fix is not better intuition. The fix is a proforma that forces every line item into a cell, every timing assumption into a column, and every dependency into a formula.

Here is what a missed line item costs in real dollars on a 100-lot deal:

An 11% miss on a deal you underwrote at 18% margin is the difference between a profitable subdivision and a personal guarantee being called.

The Five Buckets Every Land Development Proforma Needs

Forget the 80-tab models you find on consulting decks. A working land development proforma Excel file has five logical sections, each tied to the next by formula references. Build them in this order:

1. Acquisition: land price, closing costs, due diligence, broker fees
2. Soft costs: engineering, entitlements, legal, financing fees, marketing
3. Hard costs: site work and infrastructure delivered to the "finished lot" stage
4. Carry: interest, property tax, insurance, HOA setup, contingency draw schedule
5. Sales: absorption schedule, lot pricing by phase, commissions, closing costs

Each bucket maps to a contiguous block of cells. Acquisition lives in rows 5 to 15. Soft costs in rows 18 to 35. Hard costs in 38 to 60. Carry in 62 to 75. Sales absorption gets its own monthly grid in columns C through AZ. The discipline of fixed regions matters because every formula downstream references these ranges.

Inputs and Assumptions Tab

Before you write a single sum, build a dedicated Assumptions tab. This is not optional. The whole point of a proforma is sensitivity. If "land price" is hardcoded inside a formula deep in the cash flow tab, you cannot run "what if the seller comes off another $200K" in 30 seconds. Your model is dead.

Here is a minimal assumptions block for a 60-lot subdivision:

Lock B6 as a calculated cell using =ROUNDDOWN(B4B5,0) because lot count is a function of net density, not a guess. Total land cost in B8 is =B4B7. Every downstream formula references these cells, never the raw numbers.

Hard Cost Build-Up

The most common proforma sin: rolling all hard costs into "$60,000 per lot" and moving on. That works for a back-of-envelope. It does not work when the bank's third-party engineer reviews your loan request. Build the hard cost line items individually:

The contingency line uses =B12*SUM(D5:D15) where B12 is the contingency percentage and D5:D15 holds the line item totals. Every off-site allowance, every bond, every dry utility tap fee belongs as its own line. If you cannot point to the cell that holds "stormwater detention", the underwriter will not believe your number.

Soft Costs and Pre-Development Float

Soft costs typically run 12% to 18% of hard costs in a normal suburban subdivision, higher if the project requires extensive entitlement work. The mistake is treating them as one bucket. Break them out:

• Civil engineering and surveying: 4% to 6% of hard costs
• Environmental, geotech, traffic studies: $25K to $80K depending on jurisdiction
• Legal and entitlement (rezoning, plat approval): $40K to $150K
• Financing fees (origination, appraisal, title): 1.5% to 2.5% of total loan
• Market study and marketing setup: $15K to $35K
• Property tax during hold (pre-sale): assessed value times mill rate times months divided by 12

The float matters because soft costs hit BEFORE the development loan funds. You are paying engineers and lawyers out of equity for 8 to 14 months before the first dirt moves. Model this in a monthly cash flow column. The formula for cumulative pre-development equity outlay:

=SUMPRODUCT((Month_Range<=Current_Month)*Soft_Cost_Range)

This tells you, at any month in the hold, how much equity is already locked in. If your investor expects a $500K capital call and your model shows $720K outlaid by month 9, you have a margin call coming.

Carry Costs and the Interest Calculation

Land development carry costs are the silent killer of margin. A 30-month hold on a $5 million development loan at 10.5% is roughly $1.3 million in interest, even with a paydown structure. Most proformas underestimate this because they apply the rate to the full loan balance for the full term, when reality is interest accruing on drawn-down balances over time.

The right way to model interest: build a monthly draw schedule that mirrors the construction sequence (clearing in months 8 to 9, sewer in 10 to 12, paving in 14 to 15), then calculate interest as:

=Cumulative_Drawn_Balance*(Annual_Rate/12)

For a screening view, use average outstanding balance:

=((Total_Loan/2)Annual_Rate)(Hold_Months/12)

The simplified version is fine for a screening proforma. For a bank submission, build the full draw-by-draw schedule. The difference between the two methods on a $4M loan over 24 months can be $60K to $120K, which is the difference between an approved deal and a re-trade at the term sheet stage.

The Sales Absorption Engine

Lot sales are not a single line item. They are a schedule. You will not sell 60 lots on day one of certificate of occupancy. You will sell 2 to 4 per month if your market is healthy, slower if it is not. The proforma needs a column for each month showing lots sold, gross revenue, commissions, and net to project.

Use =IF(SUM($C$15:C15)>=$B$6,0,Absorption_Rate) to cap lots sold at total inventory. Net revenue per month becomes =Lots_SoldAvg_Price(1-Commission_Pct-Closing_Pct). These monthly nets feed the cumulative cash flow waterfall, which feeds the IRR calculation at the bottom of the model.

The Exit Math: IRR, Margin, and Max Land Price

The output that matters: what IRR does the project deliver, and what is the maximum I can pay for the land to hit my hurdle rate?

Build a monthly net cash flow row across the timeline. Acquisition equity goes negative in month 0. Soft cost outlays are negative through month 14. Hard cost outlays are negative in months 8 to 14, offset by loan draws. Sales revenue is positive starting month 15. Loan payoff happens at the end. The formula for project IRR:

=IRR(Net_Cash_Flow_Range,0.15)

Equity multiple is simpler:

=Total_Distributions/Total_Equity_Invested

Project margin on cost:

=(Gross_Revenue-Total_Cost)/Total_Cost

To solve for max land price at a target IRR, use Goal Seek. Set the cell containing project IRR to your hurdle (say 22%), and let Excel change the land price per acre cell. The output is the most you can pay and still clear your hurdle. This single calculation is the difference between an offer letter that wins the deal and one that buries you.

What Most Models Get Wrong

Three errors recur in nearly every land development proforma I review:

• Single-period accounting: Treating the project as one big inflow versus one big outflow, ignoring the timing. A 22% margin over 36 months is a 6.8% annualized return. That is worse than a Treasury bill.
• No phasing: Assuming all 60 lots get developed and sold in one push when reality is two or three phases over four years. Phasing changes interest expense, marketing cost, and absorption. Model it.
• Missing the residual: Land that does not sell becomes the residual. If 8 of 60 lots sit unsold at month 36, the model needs a discounted residual value. Hard-coding "all lots sell at price" is a fairytale.

Build Faster With a Working Template

Constructing the proforma from scratch teaches you the model, but it costs 12 to 20 hours of Excel work the first time. If you are evaluating your third land deal this quarter, you should not be rebuilding the assumptions tab from a blank sheet. Start from a structure that already has the absorption engine, the draw schedule, and the IRR plumbing wired up. Plug in the numbers from your specific deal, run sensitivities, and ship the analysis to your investor before the seller signs an offer from someone else.

The SheetCraft Flip and BRRRR Calculator shares the same DNA as a land development model: timed cash flows, equity in versus distributions out, IRR and equity multiple at exit. If you are running both fix-and-flip deals and small subdivisions, that template gives you the underwriting muscle without rebuilding it for every parcel.