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

Key Takeaways

• Financial models for real estate fundraising work when they answer four LP underwriting questions: how much capital is required, when it is needed, what can go wrong, and what LPs earn after the waterfall.
• The seven core components of an LP-ready model – property pro forma, sources and uses, debt schedule with DSCR, GP/LP waterfall, net LP IRR and equity multiple outputs, downside sensitivity, and a one-page investor dashboard – must be formula-driven and fully reconciled.
• Sources and uses schedules are the first diligence checkpoint. They must balance exactly, reconcile to the waterfall, and match the equity raise stated in the executive summary.
• Net LP IRR and equity multiple are calculated after the waterfall runs at the LP level. Sophisticated LPs expect net LP IRR, equity multiple, and DSCR at both project and LP levels.

What Financial Models Are Used In Real Estate Fundraising?

A real estate fundraising financial model is a structured set of interconnected components, each answering a specific LP underwriting question. Institutional-grade capital raise models include at least ten supporting schedules grouped into five functional categories. The seven fundraising-critical components are:

1. Property-Level Cash Flow Pro Forma: The monthly or quarterly operating model that projects revenue, expenses, net operating income, and debt service from acquisition through exit.
2. Sources And Uses Schedule: The two-sided table that maps every dollar of project cost to its funding source, with total sources required to equal total uses exactly.
3. Debt Schedule And DSCR: The schedule showing loan draw mechanics, interest reserve logic, amortization, maturity timing, and debt service coverage ratio at stabilization.
4. GP/LP Waterfall: The tiered distribution model that allocates cash flows between the general partner and limited partners through return of capital, preferred return, catch-up, and promote tiers.
5. Net LP IRR And Equity Multiple Outputs: The return metrics calculated after the waterfall, showing what the LP actually earns after fees and promote.
6. Downside Sensitivity Analysis: Stress tests across exit cap rate, rent growth, construction cost, and timing that show LP returns and preferred return coverage under adverse conditions.
7. One-Page Investor Dashboard: The single-page summary that consolidates sources and uses, waterfall outputs, net LP IRR, equity multiple, and the downside case into a format an LP can evaluate in minutes.

A single-asset syndication model and a fund-level model differ structurally, not functionally. The syndication runs the waterfall against one property’s cash flows, while the fund aggregates across a portfolio. Because the LP’s four underwriting questions are identical in both cases, the seven components above apply equally to syndications and funds.

Institutional reviewers treat missing, hardcoded, or disconnected schedules as signals about the quality of the underwriting process. A missing schedule suggests headline outputs were manually assembled rather than systematically derived.

Sources And Uses: The Fundraising Core

The sources and uses schedule is the bridge between the property model and the investor story. It identifies every dollar going into the project and maps each to its funding source. LPs look here first to test whether the equity need is coherent.

Uses are grouped into six decision-relevant categories:

• Land or acquisition cost
• Hard construction costs
• Soft costs (architecture, engineering, permits, legal)
• Financing costs (origination fees, interest reserve, lender fees)
• Developer fee and overhead if capitalized
• Contingency and reserves

Sources are organized by capital layer in seniority order: senior construction loan, mezzanine or preferred equity if applicable, LP equity, and GP equity or co-invest. Total sources must always equal total uses, and the sponsor’s equity contribution is the line that makes the two sides balance.

The interest reserve line connects the debt schedule to the project budget. The OCC Comptroller’s Handbook on commercial real estate lending confirms that interest expense is a core project budget element that must be carefully estimated and tied to verified draw timing assumptions. A mis-sized interest reserve is one of the most common errors in early-draft models. A six-month entitlement slip on a $20M project can add $300,000–$500,000 of carry that eliminates the developer fee entirely.

The LP equity line in the sources and uses schedule must match both the equity raise stated in the executive summary and the capital stack tab; any gap between those figures stops an investment committee reviewer before they read further. A sources and uses schedule built for a real estate fundraising financial model must reconcile to the waterfall and to net LP IRR. If that schedule is wrong, every downstream output – debt coverage ratios, projected IRR, equity multiple – is wrong by definition.

See how Condesa reconciles sources and uses to the waterfall before your next LP review.

How The GP/LP Waterfall Changes Investor Returns

The GP/LP waterfall is the contractual mechanism that allocates cash distributions between limited partners and the general partner. It is described as the single most important economic term in any syndication agreement, and it explains why net LP IRR diverges from project IRR. The classic four-tier structure applies almost universally in commercial real estate syndications, with variations in hurdle rates and promote percentages rather than in the underlying architecture.

Industry-wide preferred returns commonly range from 6% to 10%, depending on the asset strategy and broader market conditions, with 8% appearing in roughly 40% of multifamily syndications. In the 2026 environment, preferred return rates are drifting from 8% toward 9% in newer LPAs, particularly in opportunistic and value-add vehicles. LPs argue that 8% no longer represents a meaningful preferred return over Treasury-plus-credit-spread in a higher base-rate environment.

Net LP IRR and equity multiple must be calculated after the waterfall runs, at the LP level. With a typical 8% preferred return and a 70/30 promote, LP net IRR usually lands 3–5 percentage points below project IRR. A real estate fundraising financial model that presents only project-level returns fails to show LPs what they actually earn.

Deal-By-Deal Vs. Whole-Fund Waterfall

The waterfall structure, deal-by-deal (American) or whole-fund (European), is one of the most consequential LP-protection decisions in a raise.

Under an American (deal-by-deal) waterfall, the GP earns carried interest on each realized investment independently, so a profitable Deal A can trigger promote even if Deal B and Deal C remain unresolved or underwater. Under a European (whole-fund) waterfall, no carried interest is paid until the entire fund has returned all contributed capital plus the preferred return to LPs.

The LP-protection rationale for the whole-fund structure is straightforward. Individual successful deals do not trigger sponsor compensation until losses on unsuccessful deals are absorbed and the LP’s overall preferred return is satisfied. ILPA explicitly endorsed the European waterfall as the preferred structure in its Private Equity Principles, calling whole-fund distribution “the fairest method” for aligning GP and LP interests.

For single-asset real estate syndications, the deal-by-deal waterfall is the native convention, as syndications are often single-asset vehicles where per-deal economics are the natural unit. The LP-protection mechanism in that context is the preferred return hurdle and, where applicable, a clawback provision. Mitigants that LPs should look for in American waterfall structures include carry escrows holding back a portion until fund-level tests are met, interim clawback triggers, and netting of realized losses against subsequent carry calculations.

What Return Metrics LPs Actually Underwrite

LPs underwrite three return metrics together: net LP IRR, equity multiple, and DSCR. None of the three alone tells the full story, and a real estate fundraising financial model must present all three at both the project level and the net-to-LP level.

Net LP IRR is the internal rate of return on LP equity only, calculated after the preferred return and GP promote have been paid through the waterfall. Project IRR is the return on total equity, GP and LP combined, computed from the monthly cash flow before the waterfall, while LP net IRR is the return on LP equity only, after the preferred return and GP promote have been paid. LPs underwrite the net figure. Presenting gross or project-level IRR without a net LP IRR signals the model has not been run through the waterfall.

Equity Multiple is total distributions to LP equity divided by total LP equity invested. Equity multiple is time-insensitive, so a 1.8x multiple over 3 years is superior to the same multiple over 7 years, and it must be read alongside IRR rather than instead of it. IRR captures the timing of cash flows. Equity multiple captures total return magnitude. Together they answer the LP’s fourth question, what they make, more completely than either metric alone.

DSCR (debt service coverage ratio) at stabilization tells LPs how much cushion exists between net operating income and debt service obligations. The LP needs debt information at summary level in the appendix: loan-to-cost ratio, interest rate assumption, and DSCR at stabilization. A DSCR that breaks under the downside case is a structural problem.

Project-level and LP-level returns must be presented in separate rows and never blended into a single “projected return” line, because a reviewer needs to see the spread between project economics and LP economics to evaluate whether the promote and fee structure is reasonable relative to the return profile.

Review LP-ready return outputs with Condesa before you finalize your model.

Downside Sensitivity: What Sophisticated LPs Challenge First

Sensitivity analysis is functionally required, not optional, for any sponsor raising $10M or more from institutional LPs, even if no LP has explicitly demanded it in writing, because an LP who cannot see a stress case will build one internally, typically more conservatively, and the sponsor will not be in the room to contextualize it at investment committee.

The stress tests that matter in a raise are:

• Exit Cap Rate Expansion: Institutional convention in 2026 calls for an exit cap rate that is 25 to 75 basis points above the current going-in cap rate for the asset class and submarket. A model that exits at or below the going-in cap signals the sponsor is underwriting to a best-case scenario. The sensitivity table should test 50–100 basis point widening.
• Rent Growth Shortfalls: Rent growth variance of 10% to 15% lower than the base case is the standard stress threshold institutional LPs apply.
• Construction Cost Overruns: A downside scenario must include at minimum a 10–15% construction cost overrun.
• Construction And Lease-Up Delays: The LP return sensitivity table should cover lease-up timing delays of 3 to 12 months.

Each stress test must flow through the full model and show the impact on LP IRR, equity multiple, and preferred return coverage, not just on headline project returns. A sensitivity table that only adjusts one variable without flowing through to LP return metrics is treated as cosmetic by institutional LPs.

A model reporting a single projected IRR without sensitivity tables for construction cost overruns, rent achievement, lease-up duration, and exit cap rate reads as a sales document rather than an underwriting document, and sophisticated LPs treat it accordingly.

The One-Page Fundraising Dashboard

The one-page investor dashboard is the actual deliverable a GP hands to an LP at first review. It turns a complex model into a concise fundraising tool that an LP can evaluate quickly.

A well-built dashboard contains:

• Sources and uses summary (total capitalization, capital stack by layer, uses by category)
• Waterfall output summary (return of capital, preferred return, catch-up if applicable, residual LP/GP split)
• Net LP IRR and equity multiple at both the project level and the LP level
• DSCR at stabilization and loan-to-cost ratio
• Downside case showing LP IRR and equity multiple under the primary stress scenario
• Key assumption disclosure (exit cap rate, hold period, LTC, hard cost per unit, contingency percentage)

The one-page investor dashboard, containing the five numbers that matter, the sources and uses summary, and a tornado chart of sensitivities, is what an LP reads first, and if well-built, half the LPs decide there.

The dashboard shortens LP evaluation time because it eliminates the reconstruction work that stalls diligence. Experienced LP reviewers follow a five-step sequence when opening a model summary: sources equal uses check, return label check, waterfall reconciliation check, assumption coherence check, and friction signal scan for inconsistent labels, missing timing milestones, unexplained reserves, and untraceable outputs. A dashboard built around that sequence removes friction at every step.

When A Template Fails A Real Raise

Off-the-shelf real estate financial model templates are built for internal analysis, not LP diligence. They rarely handle tiered waterfall mechanics correctly, do not produce net-to-LP outputs, and are not structured around deal-specific debt terms or capital call timing. Hardcoded schedules signal weak version control and assumption drift risk, preventing LPs from confirming internal consistency because there is no formula trail to follow.

The template versus custom model decision comes down to whether the raise is real and the LP is sophisticated. A template may be adequate for a preliminary feasibility check. It is inadequate for a $5M–$50M equity raise targeting family offices, institutional LPs, or high-net-worth investors who run their own stress tests. A sponsor who has built the core tabs but has not yet completed the supporting schedule layer is not ready for institutional outreach.

Why Condesa Financial Group

That gap between template output and LP-ready modeling is exactly what Condesa Financial Group builds for sponsors raising $5M–$50M in equity.

The firm’s most documented outcome comes from Ecuador’s largest real estate developer. Condesa built the financial models used to raise $20M and $80M across two real estate projects, and both rounds closed successfully. That outcome reflects the full modeling stack: sources and uses reconciled to the waterfall, net LP IRR and equity multiple calculated after the promote, downside sensitivity tied to LP return outputs, and a one-page dashboard that gave LPs what they needed to move through diligence.

In a current engagement under NDA, Condesa rebuilt a prior CFO’s financial model from scratch over four weeks for an Austin real estate startup. The team simplified a deliverable produced by a smart but self-taught predecessor into a cohesive model and investor narrative. The startup is going to market with a model that answers the LP’s four questions cleanly.

Condesa’s delivery model focuses on quality-to-price arbitrage in the US market. The firm partners with an accounting firm based in Panama that is highly familiar with US accounting practices and delivers fractional CFO oversight personally from the founder in Mexico City. The team includes ex-Big 4 (EY, PwC) talent, is time zone aligned with US clients, and is English-fluent. The four-layer service stack covers accounting and financial operations, FP&A, financial modeling for fundraising and M&A, and fractional CFO oversight, all relevant to a sponsor preparing for an equity raise.

Condesa is price competitive without competing as the cheapest option. The firm focuses on quality-to-price ratio: Big-4-caliber modeling work at well-below-US-market rates, delivered by a boutique firm that has closed real raises at scale.

Book a free consultation to discuss what an LP-ready model looks like for your raise.

FAQ

What Components Belong In A Real Estate Fundraising Model?

A real estate fundraising financial model includes seven core components: a property-level cash flow pro forma, a sources and uses schedule, a debt schedule with DSCR, a GP/LP waterfall, net LP IRR and equity multiple outputs, downside sensitivity analysis, and a one-page investor dashboard. Each component answers a specific LP underwriting question. The sources and uses schedule answers how much capital and when it is needed. The waterfall and net LP IRR answer what the LP makes. The sensitivity analysis answers what can go wrong. A model missing any of these components is not LP-ready.

How Should A Sources And Uses Schedule Be Structured For Investors?

An LP-facing sources and uses schedule presents two clean side-by-side blocks. The uses side groups costs into six categories: land or acquisition cost, hard construction costs, soft costs, financing costs, developer fee and overhead if capitalized, and contingency and reserves. The sources side lists capital layers in seniority order: senior construction loan, mezzanine or preferred equity if applicable, LP equity, and GP equity or co-invest. Every line item should be formula-driven, labeled in plain English, and reconciled exactly to the summary tab’s total capitalization figure. The LP equity line must match the equity raise stated in the executive summary. Any discrepancy stops the review.

How Does The GP/LP Waterfall Change Investor Returns?

The waterfall distributes cash in four tiers before the LP receives any residual profit: return of capital, preferred return, GP catch-up, and residual promote split. Net LP IRR is calculated after all four tiers have run. As noted earlier, the typical 8% preferred return and 70/30 promote push net LP IRR 3–5 points below project IRR. This spread explains why presenting only project-level returns misleads LPs about what they actually earn. The waterfall structure, deal-by-deal or whole-fund, also affects LP protection. Whole-fund (European) structures delay GP promote until LPs have received their preferred return across the entire portfolio. Deal-by-deal (American) structures pay promote on each profitable exit, with clawback provisions as the LP backstop.

What Return Metrics Do LPs Actually Underwrite?

LPs underwrite net LP IRR, equity multiple, and DSCR together. Net LP IRR captures the timing of cash flows after the waterfall. Equity multiple captures total return magnitude, total LP distributions divided by total LP equity invested, without regard to timing. Neither metric alone tells the full story. A high IRR on a short hold may reflect a small equity multiple, while a strong equity multiple on a long hold may reflect a modest IRR. DSCR at stabilization tells LPs how much cushion exists between net operating income and debt service. All three metrics must be presented at both the project level and the net-to-LP level so LPs can see the effect of the waterfall on their actual returns.

What Is The Difference Between Deal-By-Deal And Whole-Fund Waterfall Structures?

A deal-by-deal (American) waterfall calculates GP promote on each individual deal as it exits, allowing the GP to collect carry on profitable deals before the fund’s overall performance is known. A whole-fund (European) waterfall requires all LP capital plus the preferred return across the entire portfolio to be returned before the GP earns any promote. The LP-protection rationale for the whole-fund structure is that the GP cannot collect promote on early winners while later deals are still underwater. For single-asset real estate syndications, the deal-by-deal waterfall is the native convention, as syndications are often single-asset vehicles where per-deal economics are the natural unit. LP protections in that context include the preferred return hurdle, clawback provisions, and, in institutional structures, carry escrows and interim clawback testing. Sponsors raising from institutional LPs or family offices should be prepared to explain their waterfall structure and its LP-protection mechanics in writing.

Conclusion

A real estate fundraising financial model is the deciding instrument in an equity raise. LPs underwrite four questions, how much capital, when it is needed, what can go wrong, and what they make, and the model either answers those questions with traceable, formula-driven schedules or it does not survive first-pass review. The seven components that determine whether a raise closes are the same seven introduced at the top of this article: the property pro forma, sources and uses, debt schedule with DSCR, GP/LP waterfall, net LP IRR and equity multiple outputs, downside sensitivity, and the one-page dashboard.

Informed, context-specific modeling decisions, rather than templates or manually assembled outputs, determine whether a raise closes. The gap between a project-level pro forma and an LP-ready real estate fundraising financial model is where most raises between $5M and $50M stall. Closing that gap before LP outreach begins is the single highest-leverage action a sponsor can take.

Book a free consultation to discuss what an LP-ready model looks like for your specific raise.

Condesa Financial Group builds financial models for real estate fundraising for sponsors raising $5M–$50M in equity. The firm’s track record includes the financial models used by Ecuador’s largest real estate developer to raise $20M and $80M across two projects, with both rounds closing successfully. If your model was built for internal analysis and needs to be rebuilt as a fundraising instrument, the free consultation is the right starting point.