Real Estate
Land Development Cash Flow Calculator
Stage acquisition, horizontal development, lot absorption, selling costs, and financing carry month by month to reveal peak equity and profit timing.
Horizontal development model
Follow land, infrastructure, lot sales, and financing carry month by month
Development profit and peak equity answer different questions: one measures the completed margin; the other measures the capital required before absorption catches up.Capital timeline
Cumulative project cash and lot absorption
The lowest point of the blue area is peak equity; orange steps show cumulative lots closed.Detailed calculation process
Build costs arrive before sales, so timing determines the financing burden
General symbolic formulas
V = NPCs = NqCsoft = (L + Cs)uCsell = VvIm = max(-Bm-1,0)r/12Bm = Bm-1 + Salesm - Costm - ImLand is paid in month one, site and soft costs are spread across development, and sales begin after completion. Interest is calculated monthly on the prior negative cumulative balance.
Symbols and units
Worked substitution with current inputs
Monthly development ledger
| Month | Lots closed | Sales proceeds | Project outflow | Interest | Cumulative cash |
|---|
Use sequence
- Enter only saleable lots after roads, drainage, and open space.
- Set horizontal cost and entitlement/soft-cost assumptions.
- Stress the absorption rate and financing rate together.
Practical scenarios
Approval delay: extend development from 12 to 18 months.
Slower market: reduce absorption to 1.5 lots/month and observe peak equity.
Limitations
The model uses even construction spending and even post-completion absorption. It omits phased takedowns, taxes, deposits, lender fees, interest reserves, vertical construction, irregular draws, and discounted return metrics.
Land development FAQ
Why is peak equity larger than base cost?
Overhead, selling cost, and interest continue before enough lot proceeds have closed.
When do sales start?
The model starts closings in the month after the entered development period.
Is projected profit the same as present value?
No. It is nominal cumulative profit and does not discount equity contributions by timing.