Real estate development model
Development and acquisition underwriting built monthly, financed properly and waterfalled correctly — the version that goes to credit committee and investment committee once.
- Starting at
- from $3,500
- Typical timeline
- 2–4 weeks
- Engagement shape
- Fixed scope, fixed fee, weekly check-ins, recorded handover and 30 days of support.
Development underwriting fails on timing far more often than on assumptions. Annual models hide the months where cash goes out and nothing comes in. Interest modelled as a flat percentage of the loan understates the real cost of a drawn facility. Absorption modelled as a straight line makes a lease-up look financeable when it is not. Everything here is built monthly for that reason.
The development cash flow
Land, hard costs, soft costs, contingency and fees are laid out month by month against a construction programme, not spread evenly across a period. An S-curve draw reflects how construction actually spends. Contingency is drawn as a separate visible line, so the day it starts being consumed early is the day you can see it.
Revenue follows the asset class. For-sale schemes are modelled on a unit-level absorption curve with deposits, completions and sales costs. Rental schemes run on lease-up by unit type with free rent, concessions and a stabilised operating statement behind them. Mixed-use schemes get both, kept separate, then consolidated.
Debt that behaves like debt
The senior facility draws against the cost schedule, with interest capitalised during construction and commitment fees on the undrawn balance. Mezzanine sits behind it with its own rate and exit fee. Covenant tests — loan-to-cost, loan-to-value, debt yield and DSCR — run every month and flag the period where they break rather than the year.
Refinance at stabilisation is modelled explicitly, sized off the stabilised net operating income and the takeout lender's constraints, because for many holds the refinance proceeds are the return.
The waterfall, tested every period
This is where sponsor models most often break in review. Preferred return accrues and compounds on the correct unreturned-capital base. The catch-up is tested each period rather than assumed satisfied. Promote crystallises only once the tier above is truly met, and where the documents provide for clawback, the clawback is modelled.
A waterfall that pays promote before the preferred return is caught up will be found by investor counsel, and the cost of that discovery is the deal rather than a correction.
Sensitivity that reflects real risk
Four variables decide most development outcomes: exit cap rate, achieved rent or sales price, cost overrun and programme delay. Each is run one-way and in a two-way grid, and a combined downside case applies them together — because in a bad market they do arrive together. The output is the spread of levered IRR, equity multiple and peak equity across that range, presented the way an investment committee reads it.
Timing and fee
Two to four weeks, from $3,500, scaling with phasing, unit mix, debt structure and waterfall complexity. If underwriting already exists, a model audit is usually the faster route to committee, and a valuation adds an independent view of the stabilised asset.
Who it's for
- Developers underwriting a scheme before land commitment
- Sponsors raising project equity or a JV partner
- Borrowers preparing a lender submission
- Funds reviewing a sponsor's underwriting
- Owners testing a hold, refinance or exit decision
Deliverables
What you receive
- Monthly development cash flow: land, hard, soft, contingency
- Construction draw schedule and interest capitalisation
- Debt module: senior, mezzanine, covenant tests
- Equity waterfall with promote tiers and hurdles
- Levered and unlevered IRR, equity multiple, peak equity
- Sensitivity on exit cap rate, rent, cost overrun and delay
Process
How the engagement runs
- 01
Send the brief
The contact form takes the situation: what exists, what it needs to do, and who has to be convinced. No pitch deck.
- 02
Fixed-scope proposal in 24h
Written scope, deliverables, timeline and a fixed fee. You know the number before anything starts.
- 03
Build or audit, weekly check-ins
Working sessions each week against a visible milestone list. No four-week silence followed by a surprise.
- 04
Handover and 30 days support
A recorded walkthrough of every tab and driver, plus thirty days of questions answered at no extra cost.
FAQ
Questions about real estate models
Mixed-use development: equity waterfall rebuilt, IC approval in one pass
A 120-unit mixed-use scheme where the sponsor's waterfall paid promote before the preferred return was fully caught up.
Read it →DCF calculator
Test how a discount rate and terminal assumption move value before committing to a full underwriting build.
Open the tool →Related guides

Real estate development pro forma: 7 errors that kill deals
Seven recurring modelling errors found in development underwriting, each of which has cost a sponsor a deal or a promote.
11 min read · Updated 2026-10-18

Real estate equity waterfalls: preferred return, catch-up and promote
An equity waterfall allocates distributable cash under the partnership agreement.
6 min read · Updated 2026-10-18

Construction funding and loan draws: modeling the equity gap
Build construction funding monthly, linking eligible spending to loan draws, interest, fees and equity contributions.
6 min read · Updated 2026-10-18
Related services
Two ways to start
Get a quote, or start with the checklist.
If you know what you need, request a quote — a fixed-scope proposal follows within 24 hours. If you are still deciding, take the checklist investors effectively run your model against and see where it stands.
Get a quote
Send the brief — what exists, what it needs to do, and who has to be convinced. A fixed-scope proposal with the exact fee follows within 24 hours.