What is a cash flow model in a real estate development?

It is a month-by-month projection of inflows (pre-sale, milestone payments, closing, stabilized rent) and outflows (land, hard costs, soft costs, financing, taxes) of a project over its entire cycle — typically 48–96 months from acquisition to exit. It is the basis for calculating IRR, equity multiple, peak equity, and DSCR.

How is cash flow calculated during the pre-sale phase?

Pre-sale inflows = units sold × (down payment typically 10–20% + milestone payments 20–40% during construction + closing balance 40–70% at title transfer). The schedule depends on the construction timeline and the promissory agreement. A project of 60 units with 50% pre-sold and a 15% down payment generates USD $900K–$1.5M cash-in in the first 6–9 months.

What percentage of pre-sales is needed to start construction?

Senior bank lenders typically require 30–50% of inventory placed in pre-sale before the first drawdown of the construction loan. In Mexico, Peru, and Colombia the trust (fideicomiso) also requires funds to be held in escrow. Without that pre-sale floor, the project does not start construction — or the developer must contribute additional equity.

What is the difference between pro forma and actual cash flow?

The pro forma is the pre-execution projection based on assumptions (absorption, costs, rates); actual cash flow is the real flow executed month by month during the project. Professional discipline requires running quarterly variance analysis of pro forma vs. actual, documenting deviations, and recalibrating the forward-looking forecast at each close. Institutional funds require this report as part of LP reporting.

Real Estate Cash Flow by Phase — 2026 Simulator

Q: What are the phases of a real estate project?

Six standard phases: (1) land acquisition + due diligence, (2) permits + architectural design, (3) pre-sale off-plan, (4) construction, (5) deliveries + lease-up if there is a rental component, (6) stabilization + exit (refinancing or sale). Each phase has its own cash flow schedule.

Q: What is included in hard cost and soft cost in construction?

Hard cost: structure, finishes, MEP systems (55–70% of budget, distributed in an S-curve). Soft cost: permits, licenses, architect/engineer fees, marketing, legal, trust (8–15% of total, front-loaded in the first 6 months). Contingency (5–10%) is reserved for hard cost overruns, which in Mexico average 18–25% per AMPI.

Q: How is cash flow projected for a condominium development?

Six steps: (1) define phases with their schedules; (2) distribute hard cost along an S-curve; (3) model soft cost as front-loaded; (4) project pre-sales using an absorption curve × price × payment schedule; (5) subtract commissions, financing costs, and taxes; (6) calculate IRR, NPV, peak equity, DSCR, and equity multiple. The simulator runs all six steps in parallel under base/adverse/severely adverse scenarios.

Q: How much equity does a real estate development require?

Typical equity: 25–35% of total project cost. For USD $18M that is USD $4.5–$6.3M. The remaining 65–75% comes from senior construction debt with LTC of 65–75%. Equity is split between GP (10–20% of total equity, contributing management) and LP (80–90%, contributing passive capital).

Q: How does the bridge loan affect cash flow?

The bridge (construction) loan draws progressively against inspector-verified construction progress, and interest is capitalized during construction — it is not paid monthly but accrues to the principal. Typical capitalized financing cost: 9–12% of the original loan amount for 24-month terms at SOFR+3.5. At completion, the loan converts to a permanent loan (amortizing) or is refinanced with long-term debt.

Q: What is the IRR of a real estate project and how is it calculated?

IRR is the discount rate that makes the project's NPV equal to zero. It is calculated iteratively over the complete cash flow: early outflows (land + soft costs) as negative values, pre-sale/delivery/rental inflows as positive, exit (refi or sale) as a final positive. For LatAm vertical, a healthy project unlevered IRR is 12–16%, levered equity IRR is 16–22%. Distinguish unlevered IRR (project) vs. levered (equity) vs. LP post-waterfall.

Complete guide

Real estate pro forma: from napkin to institutional model without paying for ARGUS

A real estate project from USD 2M to 200M is one of the most complex transactions a developer handles. It is not a one-tab Excel; it is a living system with land acquisition, permits, construction, pre-sales, delivery, lease-up and exit, each phase with its own disbursement schedule, loan covenants, interest-rate sensitivities and equity waterfall structure. In the United States the industry standardized ARGUS Enterprise (USD 6-8K/year per license) and institutional templates like A.CRE and Mergers & Inquisitions, affordable for funds but not for the LatAm mid-market developer running 2-5 simultaneous projects. The real estate cash flow simulator fills that gap: a web tool that runs the development pro forma with the same line-item structure as the institutional model, adapted to LatAm conventions (pre-sale on plans, trust-based escrow, staggered titling, USD), without the Excel learning curve or annual license.

The output is a month-by-month cashflow over 60-96 months, with revenue from pre-sales and delivery, expenses per phase (hard cost on an S-curve, front-loaded soft cost, financing, contingencies), and the key metrics any investment committee demands: equity IRR, project IRR, equity multiple, cash-on-cash return, peak equity, minimum DSCR, development yield on cost and exit cap rate spread.

Capital structure: GP/LP equity waterfall and preferred return

A typical LatAm USD 18M development is capitalized: 30% equity (USD 5.4M) and 70% senior construction debt (USD 12.6M). Equity is split between the GP (General Partner) — the operating developer who contributes 10%-20% of equity and management — and the LP (Limited Partner) — passive fund or angel capital contributing 80%-90%. Profit distribution is not proportional but by waterfall, a cascade with IRR hurdles:

Tier 1 — Preferred return: LP receives 100% of cash flow up to an 8% annualized IRR on invested capital. It is the floor the LP negotiates before putting in a dollar.
Tier 2 — Return of capital: once preferred is covered, both parties recover their principal pari-passu.
Tier 3 — First promote (12% IRR hurdle): from cash flow above 8% up to 12% IRR, distribution splits 80% LP / 20% GP. The 20% to GP is the promote or carried interest, the operator's performance incentive.
Tier 4 — Second hurdle (12%-15% IRR): between 12% and 15% IRR the split moves to 70% LP / 30% GP.
Tier 5 — Super promote (>20% IRR): above 20%, distribution reaches 50/50 or even 40% LP / 60% GP in aggressive operations.

The simulator models each tier explicitly. The LP sees net IRR after waterfall, the GP sees projected promote in each scenario. A project with 18% total IRR can yield 13% to the LP and 38% to the GP — an asymmetry only visible with a well-calibrated waterfall.

Senior debt: construction-to-perm financing and draw schedule

Senior construction debt is construction-to-perm — a progressive draw line during construction that converts to a permanent mortgage upon completion and reaching an occupancy/stabilization threshold. Critical points:

Loan-to-cost (LTC) typical: 65%-75% of total project cost. LTV (loan-to-value) post-stabilization: 60%-70% of stabilized market value.
Construction draw schedule: draws are not linear monthly but tied to construction progress, validated by a third-party inspector. The simulator lets you load the real S-curve or use a standard curve (initial 8%, peak in months 12-14 at 15% monthly, final tail 3%).
Capitalized interest during construction: added to the principal, inflating the balance at completion. For SOFR+3.5 (approx 8%-9% in USD, 2024) on a 24-month construction loan, the capitalized financial cost reaches 9%-12% of the original loan.
Key covenants: minimum DSCR post-stabilization (1.20-1.35x), minimum pre-sale rate before first draw (30%-50% of inventory), completion guaranty by the GP.

DSCR: the metric the bank watches every quarter

DSCR (Debt Service Coverage Ratio) = NOI ÷ Annual debt service

A DSCR of 1.25x means project NOI covers 1.25 times the annual principal + interest payment. Banks require a minimum DSCR of 1.20x for stabilized residential and 1.30-1.35x for office/retail (higher rent volatility). Below the covenant, the loan enters technical default — the bank can demand prepayment, raise the rate or require additional capital. The simulator computes DSCR quarter by quarter from the post-delivery NOI projection and alerts when it falls below 1.25x.

Hard cost, soft cost and contingency: anatomy of the budget

Total project cost breaks down:

Land cost: land acquisition + due diligence. 15%-25% of total cost in urban vertical LatAm; 8%-15% in peri-urban.
Hard cost: construction — structure, finishes, installations. 55%-70% of total. Distributed on the S-curve: slow at the start (foundation), peak in months 10-18 (structure + finishes), final tail (punch-list).
Soft cost: permits, licenses, architect/engineer fees, marketing, legal, trust. 8%-15% of total. Front-loaded: 40%-50% is paid in the first 6 months (before first loan draw).
Contingency: 5%-10% of hard cost as reserve for overruns. In Mexico, AMPI documents average overruns of 18%-25% from initial underestimation. The simulator lets you model contingency by phase and validate whether the buffer is sufficient.
Financial costs: capitalized interest, bank fees, structuring fees. 8%-12% of senior debt.

Numeric example: USD 18M mixed-use in LatAm

60-unit vertical residential + ground-floor retail project in a premium corridor of Mexico City/Monterrey/Santiago. Land USD 3M, hard cost USD 11M, soft cost USD 1.5M, contingency USD 1.1M, financial costs USD 1.4M. Total USD 18M.

Capital structure: equity USD 5.4M (30%), senior debt USD 12.6M (70%) at SOFR+3.5 for 24 months construction + 60 months perm. LTC 70%.

Schedule: acquisition month 0, permits and pre-sale months 1-6 (absorption 3 units/month in pre-sale with discount), construction months 6-30, retail lease-up months 30-42, stabilization month 42. Exit: refinancing into perm debt at month 42 or stabilized sale at month 60.

Revenue assumptions: average unit price USD 280K, delivery-sheet price USD 310K, retail exit cap rate 7.0%, stabilized retail NOI USD 180K/year.

The simulator runs the full cashflow and returns:

Peak equity required: USD 5.4M in month 18 (point of maximum capital frozen before pre-sale deposits start unloading).
Project IRR (unlevered): 13.8%.
Equity IRR (levered): 19.2% to the GP, 14.5% to the LP after waterfall.
Equity multiple: 1.87x to LP, 2.35x to GP.
Cash-on-cash year 5: 11.2%.
Development yield on cost: 7.8%.
Exit cap rate spread: 80 bps (7.8% YoC − 7.0% exit cap).
Minimum DSCR post-stabilization: 1.28x (year 4, before rent step-ups).

The metrics together say: viable project but with tight margin. A 15% construction overrun (inside the AMPI range) pushes LP IRR below 8% — it breaks preferred return. A 4-month delay in retail lease-up depresses DSCR below covenant. These sensitivities are visible in the simulator when moving the overrun, delay and rate levers.

Peak equity and when to refinance

Peak equity is the maximum capital simultaneously exposed, typically at the point where you have already invested land + soft cost + construction progress but have not yet started collecting the bulk of deliveries. Identifying the exact peak month is critical: it defines how much capital to reserve, when to negotiate loan extensions and when it is safe to commit equity to another project. The simulator returns the accumulated equity curve month by month and marks the peak with a visual alert.

Scenarios: base, adverse, severely adverse

A pro forma that only runs a base scenario is marketing, not analysis. The simulator forces three parallel scenarios:

Base: central assumptions from the commercial and technical team.
Adverse: absorption −25%, overrun +15%, rate +200 bps, 3-month construction delay.
Severely adverse: absorption −45%, overrun +25%, rate +400 bps, +6-month delay, +12-month lease-up.

If the project yields equity IRR >15% base, >8% adverse and >0% severely adverse, it is robust. If under adverse it breaks the LP preferred return (<8%), the structure is under-capitalized or product pricing is aggressive. This is the real investment-committee conversation — not "what is the return?" but "what is the return and how robust is it under stress?".

Pre-sale as a cash flow engine — and its risk

In LatAm, pre-sale on plans significantly reduces peak equity: down payments (typically 10%-20%) and staggered payments during construction (30%-40% of price distributed over 18-24 months) contribute cash before delivery, lowering the need for own construction capital. A project with 50% of inventory pre-sold before breaking ground can reduce peak equity by 30%-40%. But it carries risks: (1) cancellations — in LatAm the cancellation rate runs 10%-25%; if your model assumes 0% you are underestimating negative cash flow; (2) price adjustment at delivery sheet — if the market cools and the finished-construction price does not support the increment over pre-sale, buyers demand a discount; (3) trust is mandatory — in Mexico, Peru and Colombia pre-sale requires a guaranty trust, adding 1.5%-3% to project cost but protecting both buyer and developer.

Differentiation vs institutional Excel (A.CRE, M&I)

A.CRE/M&I Excel is superior in parametric depth (configurable to nearly any structure), but has a weeks-long learning curve and requires manual validation of every formula. For a LatAm mid-market developer with 1-5 projects, the value is speed: load assumptions in a web interface, see scenarios in minutes, share a link with the committee instead of mailing an .xlsx. The simulator does NOT substitute ARGUS or A.CRE for an institutional fund with 50 projects and 200M under management; it DOES substitute a poorly calibrated homebrew Excel for a developer with USD 5M-50M in annual pipeline. The honest positioning is first-pass feasibility or quick napkin pro forma with a handoff to a detailed model when the decision goes to the credit committee.

Conclusion

For the LatAm developer operating between Excel and ARGUS, the web simulator is the middle ground that was missing. It runs the same pro forma a fund analyst models in 3 hours, in 15 minutes, with LatAm assumptions by default (USD, trust, staggered titling, pre-sale on plans). The equity waterfall with 8/12/15/20 hurdles and progressive promote is visible, not implicit. Peak equity, DSCR, cash-on-cash, IRR, equity multiple and cap rate spread show up together — the dashboard the investment committee expected to see. Developments will still be won or lost on absorption and overrun assumptions, but at least the calculation stops being a black box.

Illustrative case

Composite case for instructional purposes: combines sector dynamics with realistic figures. Names are fictional and do not represent a specific company.

Case: Mixed-use project in Valle Oriente, Monterrey — USD 22M development, 48 months

Inversora Praxis alongside local operator Grupo Altara structured in 2024 a mixed-use development of 48 residential units (80-140 m²) + 1,100 m² of ground-floor retail + 3 parking levels, in Valle Oriente, Monterrey. Total projected cost USD 22M: land USD 4.2M, hard cost USD 13M, soft cost USD 1.8M, contingency USD 1.3M, financial costs USD 1.7M.

Capital structure: equity USD 6.6M (30%), senior debt USD 15.4M (70%) at SOFR+3.75 (approx 9% USD) for 30 months construction + 72 months perm. Waterfall: LP 80% of equity (USD 5.28M), GP 20% (USD 1.32M). Hurdles 8% pref / 12% first promote 80-20 / 15% second 70-30 / 20% super 50-50.

Praxis's financial analyst loaded the assumptions into the simulator:

Pre-sale absorption: 2.5 units/month at USD 295K average with 15% down + 20% staggered during construction + 65% at closing.
Hard cost S-curve: 8% months 6-9, 14% peak month 18, 3% tail month 30.
Retail: 12-month post-delivery lease-up, stabilized NOI USD 220K/year at 7.2% exit cap.
Scenarios: base, adverse (absorption −25%, overrun +15%, rate +200 bps), severely adverse (−45%, +25%, +400 bps).

Simulator output:

Base scenario: project IRR 14.2%, GP equity IRR 21.8%, LP equity IRR 15.1%, LP EM 1.94x, peak equity USD 6.4M month 20, min DSCR 1.31x, development yield on cost 8.1%, cap rate spread 90 bps. Waterfall: LP receives 8% preferred + 80% of excess up to 12% + 70% between 12-15% = 15.1% net LP IRR. GP receives 20% first promote + 30% second = USD 1.48M carried interest on capital contribution of 1.32M.
Adverse scenario: project IRR 9.4%, LP equity IRR 8.2% (barely covers preferred), GP promote collapses to USD 180K. The project survives but the GP earns no carry.
Severely adverse scenario: project IRR 3.1%, LP does not hit preferred, capital recovered pari-passu but no pref. Technical DSCR default (1.08x) in month 48 triggers the bank covenant.

Committee read: project viable in base, tight in adverse, broken in severe. Decision: (1) raise contingency from 6% to 9% of hard cost (absorbs USD 400K), (2) close a rate hedge (SOFR cap at 5.5%, cost USD 180K upfront), (3) pre-commit 15 units with institutional investors before starting construction to set an absorption floor. These mitigations moved base IRR from 14.2% to 13.5% but adverse IRR rose from 9.4% to 11.8% — the LP approved because risk-adjusted return improved even though central return fell. The project closed its first construction draw in January 2025 and is on track.

From theory to calculation

When you need more than a quick calculation, our advanced simulators model full scenarios with your data.

See advanced simulators

Sector reference ranges

Indicative ranges based on public sector literature and operational observation. Your business may differ — use the numbers as a starting point, not as a target.

Metric	Value	Source
Typical loan-to-cost — construction loan, LatAm	65-75%	ULI Emerging Trends Real Estate LatAm 2024
LP preferred return — standard development, LatAm	8-10%	JLL Capital Markets Latin America Investor Survey 2024
Minimum DSCR covenant — stabilized residential	1.20-1.35×	CBRE Cap Rate Survey México H2 2024
Average construction cost overrun — Mexico	12-25%	AMPI Reporte Anual Construcción Residencial 2024
Healthy development yield on cost — vertical LatAm	7-10%	Colliers LatAm Residential Development 2024
Minimum viable cap rate spread — development vs stabilized	150-250 bps	RCA Capital Trends Latin America 2024
Hard cost per m² — premium vertical CDMX (construction)	USD 1,300-2,060/m²	Softec Construction Cost Index Mexico 2024
Pre-sale cancellation rate — LatAm average	8-15%	Tinsa LatAm Observatorio de Preventa 2024

Frequently asked questions

1What is cash flow in a real estate development?

It is the month-by-month projection of revenue (pre-sale, staggered payments, closing, stabilized rent) and expenses (land, hard cost, soft cost, financing, taxes) of a project across its full cycle — typically 48-96 months from acquisition to exit. It is the basis for computing IRR, equity multiple, peak equity and DSCR.

2What are the phases of a real estate project?

Six standard phases: (1) land acquisition + due diligence, (2) permits + architectural design, (3) pre-sale on plans, (4) construction, (5) deliveries + lease-up if there is a rental component, (6) stabilization + exit (refinancing or sale). Each phase has its own distinct cash flow schedule.

3How is cash flow calculated during pre-sale?

Pre-sale revenue = units sold × (down payment typically 10%-20% + 20%-40% staggered payments during construction + 40%-70% balance at closing). The schedule depends on construction time and the promise contract. A 60-unit project with 50% pre-sale and 15% down generates USD 900K-1.5M of cash-in in the first 6-9 months.

4What percentage of pre-sale is required to start construction?

Senior banks typically require 30%-50% of inventory placed in pre-sale before the first construction-loan draw. In Mexico, Peru and Colombia the trust additionally requires funds to be deposited in escrow. Without that pre-sale floor, the project does not break ground — or the developer must contribute additional equity.

5What do hard cost and soft cost in construction include?

Hard cost: structure, finishes, installations (55%-70% of budget, distributed on S-curve). Soft cost: permits, licenses, architect/engineer fees, marketing, legal, trust (8%-15% of total, front-loaded in the first 6 months). Contingency (5%-10%) is reserved for hard-cost overruns, which average 18%-25% in Mexico per AMPI.

6How do you project cash flow for a condo project?

Six steps: (1) define phases with their schedule; (2) distribute hard cost on an S-curve; (3) model front-loaded soft cost; (4) project pre-sale with absorption curve × price × payment schedule; (5) subtract commissions, financing and taxes; (6) compute IRR, NPV, peak equity, DSCR and equity multiple. The simulator runs the six steps in parallel with base/adverse/severely adverse scenarios.

7How much equity does a real estate development require?

Typical equity: 25%-35% of total project cost. For USD 18M that is USD 4.5-6.3M. The remaining 65%-75% comes from senior construction debt with 65%-75% LTC. Equity splits between GP (10%-20% of total equity, contributes management) and LP (80%-90%, contributes passive capital).

8How does the bridge loan affect cash flow?

The bridge (construction) loan draws progressively against construction progress validated by an inspector, and interest is capitalized during construction — not paid monthly, added to principal. Typical capitalized financial cost: 9%-12% of the original loan for 24-month terms at SOFR+3.5. At completion, the loan converts to perm (amortizable) or is refinanced with long-term debt.

9What is the IRR of a real estate project and how is it calculated?

IRR is the discount rate that makes project NPV equal to zero. It is calculated iteratively over the full cashflow: initial outflows (land + soft cost) as negatives, revenue from pre-sale/delivery/rent as positives, exit (refi or sale) as a final positive. For LatAm vertical, healthy project IRR 12%-16%, levered equity IRR 16%-22%. A distinction is drawn between unlevered (project) vs levered (equity) vs LP post-waterfall IRR.

10What is the difference between pro forma and real cash flow?

Pro forma is the pre-execution projection based on assumptions (absorption, costs, rates); real cash flow is the actual executed month by month during the project. Professional discipline is running quarterly variance analysis pro forma vs real, documenting deviations and recalibrating the projection at close (forward-looking forecast). Institutional funds require this report as part of LP reporting.

Tools from the same topical cluster. Use them together to close the loop on your analysis.

Last updated: April 30, 2026 · Reviewed by the Simúlalo editorial team. Figures and benchmarks are indicative; verify with your own data before deciding.

View methodology