Written by: Andrew Cohen, CFA, CPA, Managing Partner, Condesa Financial Group

Key Takeaways

• A real-estate fundraising model is a multi-tab Excel file that projects property cash flows, maps every dollar of sources to uses, allocates returns through a GP/LP waterfall, aggregates fund-level fees and carried interest, and delivers an LP-facing dashboard of net IRR, DPI, RVPI, and TVPI.
• The five-layer architecture of deal underwriting, sources and uses, GP/LP waterfall, fund-level aggregation, and LP dashboard must operate as one integrated system. Institutional LPs in 2026 will not back a sponsor whose model skips any layer.
• Four model types (Acquisition/Core, Value-Add, Development, Fund/Portfolio) match distinct risk-return profiles and require different underwriting focus and waterfall terms.
• Institutional LPs expect LP-facing reporting to lead with net IRR, supported by gross-to-net reconciliation, DPI, RVPI, TVPI, and sensitivity tables for exit cap, rent growth, and construction-cost stresses.
• Condesa Financial Group has delivered this complete five-layer stack for $100 million in closed equity raises and can help sponsors build or audit models that meet 2026 institutional standards. Schedule a free model review to benchmark your current stack.

Institutional limited partners commit capital only when they see a clear bridge from property-level cash flows to their own net returns. Sponsors need a five-layer modeling stack that tells this story without gaps, hardcodes, or reconciliation issues. The sections below walk through each layer, show how they connect, and outline the supporting schedules LPs expect to see in every real-estate fundraising model.

The Five-Layer Stack Explained

1. Deal Underwriting: Property-level cash flow projections covering revenue, operating expenses, debt service, and net operating income across the full hold period.
2. Sources & Uses: A capitalization map that ties every dollar of project cost to a named funding source, with zero tolerance for rounding gaps.
3. GP/LP Waterfall: A tiered distribution schedule encoding return of capital, preferred return, catch-up, and promote splits in exact LPA sequence.
4. Fund-Level Aggregation: A portfolio roll-up that applies management fees, carried interest, and fee offsets across all deals to produce fund-level economics.
5. LP Dashboard: A single-page output showing net IRR, DPI, RVPI, and TVPI reconciled to the waterfall and sources and uses tabs.

The next sections move through these layers in order, then cover supporting elements such as model types, sensitivity tables, and Excel tab architecture that help sponsors pass institutional review.

Layer 1: Deal Underwriting and Core Schedules

A real estate development financial model integrates five interconnected schedules: a sources and uses statement, a development budget with phased cost tracking, a construction draw and interest reserve schedule, a revenue and stabilization projection, and a return waterfall that translates project-level cash flows into investor-level returns under the applicable capital structure.

Property cash flows form the foundation, and the revenue schedule is where that foundation begins. The revenue schedule must break out unit mix, average rents, concessions, vacancy, ancillary income, and lease assumptions, with every line formula-driven and traceable to a defensible market assumption. Once revenue is projected, the operating expense schedule must mirror that same rigor. It separates controllable costs from non-controllable costs, applies an explicit inflation rate to each category, and matches the operating expense line in the cash flow tab exactly.

Capital structure then sits above the cash flows. The capital stack on an LP-facing summary should present senior construction loan, mezzanine or preferred equity if applicable, LP equity, and GP equity in order of seniority, with amounts or percentages, enabling reviewers to verify leverage and equity split without opening the debt schedule tab.

Waterfall tiers and return metrics complete the picture for this first layer. Institutional LPs expect LP-facing reporting to lead with net IRR as the primary performance metric, accompanied by a separate gross-to-net reconciliation that shows the impact of management fees, carried interest, and fund expenses.

Request a deal-underwriting audit to confirm your revenue, expense, and capital stack schedules support institutional diligence.

Model Types and When They Matter

Four model types correspond to distinct risk-return profiles, and each one places different weight on the five layers.

Acquisition / Core: Stabilized assets with predictable cash flows rely on clean in-place NOI and debt sizing. The model centers on in-place NOI, debt service coverage, and exit cap rate sensitivity. Preferred returns typically run 7–8% with 10–15% GP carry, consistent with core and core-plus open-end fund structures in 2026.

Value-Add: Partially stabilized assets requiring capital improvements depend on accurate timing. The model layers a renovation budget, phased lease-up schedule, and post-renovation rent assumptions on top of in-place cash flows. Institutional JV structures for value-add deals often feature an 8% to 9% preferred return and a promote above a 15% IRR hurdle.

Development: Ground-up construction requires precise cost and draw tracking. The model includes a construction draw schedule, interest reserve calculation, lease-up ramp, and contingency logic. Construction draw schedules and interest reserve calculations are frequently underbuilt in developer pro formas, creating construction loan covenant risk and liquidity shortfalls.

Fund / Portfolio: Multi-asset aggregation shifts focus to fund-level economics. The model consolidates deal-level outputs into a fund-level NAV, applies management fees and carried interest, and produces LP-level cash flows across the full fund life. Fund-level reported IRR can differ from project-level gross economics on the same assets because of fees, carry, and capital timing.

Discuss which model type fits your raise and how to align its structure with institutional expectations.

Layer 3: GP/LP Waterfall Terms and Alignment

In real estate private equity, a distribution waterfall determines the order and priority in which returns flow to LPs and GPs and serves as one of the most direct expressions of GP/LP alignment in the entire fund structure.

A standard 2026 waterfall distributes in this sequence, and each tier protects LP capital before the GP participates in profits:

1. Return of Capital: 100% of LP contributions returned before any profit sharing begins. This step ensures LPs recover principal before the GP earns any promote.
2. Preferred Return: Once capital is returned, LPs receive a preferred return, commonly 8% per annum on a cumulative basis, before the GP participates in profits.
3. GP Catch-Up: After the preferred return is met, the GP catches up through a 50/50 split until the GP has earned 20% of total profits, aligning the GP share with the promote tier that follows.
4. Promote Tiers: An 80/20 LP/GP split thereafter, with a second tier of 70/30 above a 15% IRR hurdle for value-add, and 65/35 above 15% IRR for development deals.

The following table compares LP net IRR against GP promote economics under 2026 market-standard terms for a value-add deal:

Waterfall modeling must be stress-tested before any LP presentation because changes in exit cap rates can significantly affect promote tiers and GP distributions.

Have our ex-Big 4 team audit your waterfall tab against 2026 institutional standards.

Layer 2: Sources and Uses That Tie Out

Uses on the LP-facing sources and uses block should be grouped into six decision-relevant categories: land or acquisition cost, hard construction costs, soft costs (architecture, engineering, permits, legal), financing costs (origination, interest reserve, lender fees), developer fee and overhead if capitalized, and contingency and reserves.

On the sources side, the capital stack must show senior construction loan, mezzanine or preferred equity, LP equity, and GP co-invest in seniority order. The sources-and-uses statement must tie exactly to the financial model outputs, with any preferred equity, mezzanine debt, or GP co-invest structures visible and clearly labeled in the capital stack.

The sources-and-uses schedule must tie exactly to the summary tab total capitalization figure, with every line item appearing as a named row with a formula-driven total, and the LP equity line must match the equity raise in the executive summary and capital stack tab.

Institutional LP reviewers follow a predictable five-step sequence when opening an LP-facing model summary: first confirming sources equal uses, then checking that return metrics are clearly labeled as project-level versus LP-level, reconciling waterfall outputs to the full model, testing assumption coherence against return outputs, and scanning for friction signals such as inconsistent labels or untraceable figures.

Have Condesa build a sources and uses schedule that passes institutional LP first-pass review without a single reconciliation request.

Layer 4: Fund-Level Aggregation and Fees

Fund-level modeling translates deal outcomes into LP net performance. Value-add real estate funds typically charge management fees on committed capital during the investment period, then step down during the harvest period.

A typical institutional value-add real estate fund compresses gross-to-net IRR across management fees, carried interest, and other expenses. A fund generating an 18% gross IRR typically delivers an LP net IRR of roughly 10–14% after fees and carry, with real-estate examples often near 14%.

Fee offsets now sit at the center of LP negotiations. The 2025 ILPA Reporting Template v. 2.0 is a reporting standard for private equity funds that requires disclosure of fees before and after any offsets but does not mandate specific offset percentages for transaction or monitoring fees. GPs who offer only limited offsets may face pushback from institutional allocators.

The fee and promote schedule must tie each sponsor fee (development, acquisition, asset management, disposition) to a defined calculation basis, timing, and cash flow impact, with promote mechanics linking directly to the waterfall tab hurdle thresholds and distribution logic.

Build a fund-fee model that meets ILPA 2.0 and clearly shows LPs how gross returns translate to net IRR.

Layer 5: LP Return Dashboard and Reporting

Institutional LPs expect real estate fund quarterly reports to include gross IRR (since inception, annualized), net IRR (after fees and carry, since inception), equity multiple (MOIC / total value to paid-in capital), DPI, RVPI, TVPI, and current NAV.

DPI has become the first question many LPs ask in re-up decisions because it directly measures realized cash returned; a fund with 1.3x DPI has distributed $1.30 for every $1.00 of invested capital. McKinsey’s 2025 Global Private Markets Report found that 2.5× as many LPs ranked DPI as their most critical performance metric compared with three years earlier.

The ILPA Performance Template v2.0 standardizes disclosure of key performance metrics such as net IRR, gross IRR, TVPI, DPI, and RVPI, and addresses subscription line effects so LPs can view performance with and without credit facility impact.

Have Condesa design an LP dashboard that meets ILPA Performance Template v2.0 requirements and reconciles to your waterfall and sources and uses tabs.

Supporting Element: Sensitivity Tables LPs Trust

Real estate investors commonly require a three-case sensitivity framework (downside, base, and upside) rather than single-point pro formas when evaluating deals, because a 10% rent miss or 50 bps exit-cap shift can swing IRR by 200–400 bps.

The following table illustrates a representative base, downside, and upside LP IRR output for a value-add deal, with stresses applied to the four dominant variables:

IRR ranges reflect typical gross-to-net compression for institutional value-add funds. Sophisticated LPs screen for sponsors who present named base, downside, and severe cases with every changed assumption explicitly listed rather than vague “conservative case” labels.

Beyond the three-case table, a clean LP return sensitivity table must cover at minimum exit cap rate variance (typically plus or minus 50 to 100 basis points), construction cost overrun scenarios (typically 5% to 15% above budget), lease-up timing delays (typically 3 to 12 months), and leverage assumption changes.

Have Condesa build a linked sensitivity suite that answers LP risk questions before they are asked.

Supporting Element: Exact Excel Tab Architecture

Institutional LPs review supporting schedules in this fixed order: sources and uses, construction draws, capital calls and equity funding, lease-up or operating ramp, revenue, operating expenses, debt, fees and promote, exit, and sensitivity support. The Excel tab architecture should mirror that review sequence so LPs can follow the logic without hunting for inputs.

The recommended tab order for an institutional-grade real estate fundraising model is:

1. Cover: Version date, deal name, contact information. The updated financial model must display a clear version date and deal name on the cover tab, open cleanly without macros or passwords, and contain no broken links, hidden tabs, or unexplained overrides.
2. Assumptions: All inputs isolated in a single tab, with a scenario toggle for Base, Downside, and Upside.
3. Sources & Uses: Formula-driven capitalization map tied to the Assumptions tab.
4. Construction Draws: Monthly or quarterly phasing of hard costs, soft costs, and contingency release.
5. Capital Calls: LP contributions, GP co-invest, and preferred equity draws by period.
6. Revenue: Unit mix, rents, concessions, vacancy, and ancillary income.
7. Operating Expenses: Controllable and non-controllable costs with explicit inflation rates.
8. Debt Schedule: Draw mechanics, interest reserve, amortization, and covenant visibility.
9. Cash Flow: Consolidated NOI, debt service, and net cash flow feeding the waterfall.
10. Waterfall: Tiered distribution logic encoding the LPA exactly, using XIRR for IRR calculations. Real estate waterfall models should use the XIRR function rather than standard IRR when calculating returns against actual transaction dates because IRR assumes equal periods.
11. Fees & Promote: Management fees, acquisition fees, disposition fees, and carried interest with 100% offset logic.
12. Exit: Terminal cap rate, gross sale proceeds, disposition costs, debt payoff, and net proceeds bridging to the waterfall.
13. Sensitivity: Two-way IRR grids (exit cap versus rent growth) and three-case scenario outputs.
14. LP Dashboard: Net IRR, DPI, RVPI, TVPI, and capital account summary reconciled to the waterfall tab.

Missing, hardcoded, or disconnected supporting schedules signal to institutional allocators that headline outputs were manually assembled rather than systematically underwritten, which triggers diligence pauses and reconciliation requests.

Get a tab-architecture consultation on how Condesa Financial Group designs and quality-controls each worksheet for institutional delivery.

Case Study: Ecuador $20M and $80M Closed Raises

Ecuador’s largest real estate developer engaged Condesa Financial Group to build financial models for two large-scale real estate projects requiring $20 million and $80 million in equity, respectively. Both rounds closed successfully.

Condesa deployed the complete five-layer stack for each raise: deal-level underwriting with phased construction draws and lease-up ramps, a sources and uses statement reconciled to the LP equity ask, a GP/LP waterfall encoding the preferred return and promote tiers, a fund-level fee and carried interest schedule, and an LP-facing dashboard presenting net IRR, DPI, RVPI, and TVPI. The models opened cleanly, contained no broken links or hardcoded overrides, and passed institutional LP first-pass review without reconciliation requests.

The Ecuador engagements show that the five-layer architecture operates in live capital raises. It supported $100 million in real equity across two separate raises, delivered by an ex-Big 4 nearshore team at a price point accessible to emerging managers and SME sponsors in high-cost U.S. markets.

Explore how Condesa can support your next raise with the same five-layer stack.

Frequently Asked Questions

What financial models are used in real estate?

Real estate sponsors and fund managers use four primary model types, each suited to a distinct investment strategy. Acquisition and core models underwrite stabilized assets using in-place NOI, debt service coverage ratios, and exit cap rate sensitivity. Value-add models layer a capital improvement budget and phased lease-up schedule on top of in-place cash flows to project post-renovation returns. Development models add construction draw schedules, interest reserve calculations, and contingency logic to capture the full cost and timing of ground-up projects. Fund and portfolio models aggregate deal-level outputs across multiple assets, apply management fees and carried interest, and produce LP-level cash flows and return metrics including net IRR, DPI, RVPI, and TVPI.

For institutional equity raises, all four model types must connect into the five-layer stack of deal underwriting, sources and uses, GP/LP waterfall, fund-level aggregation, and LP dashboard. A model that covers only one or two layers will not satisfy institutional LP diligence in 2026.

What are the four types of financial models in real estate?

The four types of real estate financial models correspond to the four primary investment strategies. The acquisition model underwrites existing stabilized or near-stabilized properties and centers on current cash flow, financing terms, and exit assumptions. The value-add model projects the economics of repositioning a property through capital improvements, re-leasing, or operational upgrades, requiring a renovation budget and phased occupancy ramp. The development model covers ground-up construction from land acquisition through stabilization, incorporating construction draws, interest reserves, and lease-up timelines. The fund or portfolio model consolidates multiple deals into a single vehicle, applying fund-level fees, capital call schedules, and waterfall mechanics to produce LP-level return metrics.

Sponsors raising institutional equity need all four model types available because institutional LPs evaluate both the deal-level underwriting and the fund-level economics before committing capital. A deal-level model without a fund-level aggregation layer leaves LPs unable to assess the impact of management fees and carried interest on their net returns.

What is a GP/LP waterfall structure in real estate?

A GP/LP waterfall is the contractual mechanism that determines how investment proceeds are distributed between limited partners and the general partner in a specific sequence. The standard structure distributes cash in four tiers: return of LP capital contributions, payment of the LP’s preferred return (typically 8–9% per annum on unreturned capital), a GP catch-up provision (commonly 50/50 until the GP has received 20% of total profits), and a residual profit split across IRR-based tiers such as 80/20 LP/GP above the preferred return and 70/30 above a 15% IRR hurdle for value-add deals.

The waterfall must be modeled exactly as written in the limited partnership agreement or joint venture operating agreement. Common modeling errors include applying the promote to all profits rather than only profits above the preferred return, using annual cash-flow splits instead of cumulative IRR-based thresholds, and failing to use the XIRR function when calculating returns against actual transaction dates. Any of these errors can misrepresent which promote tier applies and produce LP return figures that do not reconcile to actual distributions.

How do management fees and carried interest affect LP net IRR?

Fund-level fees create a material compression between project-level gross returns and the net IRR that LPs actually receive. As noted earlier, an 18% gross IRR typically compresses to roughly 10–14% net after fees and carry. Management fees charged on committed capital rather than invested capital create additional drag during the early years of a fund when most capital remains undeployed.

Value-add funds commonly charge management fees on committed capital during the investment period with a step-down on invested capital later. Sponsors who do not model the fee step-down accurately will overstate LP net returns in their projections. As discussed in the fund-level aggregation section, the ILPA 2.0 standard requires disclosure of fees before and after offsets, as well as subscription line effects, so LPs can view performance with and without credit facility impact.

Evaluation Framework Recap

A real-estate fundraising model that omits any layer of the five-layer stack will not close institutional capital. The deal underwriting must be formula-driven and traceable. The sources and uses must tie exactly to the model. The GP/LP waterfall must encode the LPA precisely, use XIRR, and survive a 200–300 bps IRR stress test. The fund-level aggregation must apply standard fees with appropriate fee offsets and follow ILPA 2.0 disclosure requirements. The LP dashboard must present net IRR, DPI, RVPI, and TVPI reconciled to the waterfall tab and consistent with NCREIF reporting standards.

Sensitivity tables must cover exit cap rate variance of at least ±50–100 bps, construction cost overruns of 5–15%, lease-up timing delays of 3–12 months, and a named downside case that stresses multiple variables simultaneously. Every tab must open cleanly, contain no broken links or hardcoded overrides, and reconcile to every other tab without manual intervention.

Condesa Financial Group has delivered this complete stack for equity raises totaling $100 million in Ecuador, with both rounds closed. The team is staffed by ex-Big 4 professionals operating nearshore from Panama and Mexico City, providing institutional-grade financial modeling and fractional CFO oversight at a price point accessible to emerging managers and SME sponsors in high-cost U.S. markets.

Book a free five-layer stack review to determine whether your current model is ready for institutional LP diligence.