Co-Investment Analysis for Family Offices: Evaluating Syndication Opportunities
Family offices have emerged as one of the most active capital sources in real estate syndication, deploying $500K-$5M per deal across multiple sponsor relationships. But family office capital is earned, not given. The due diligence process for a family office investment allocation typically involves an independent underwriting audit, sensitivity stress-testing, operational due diligence on the sponsor, and comparison against the family's broader portfolio allocation targets. This guide covers the evaluation framework that family offices use — and how GPs can prepare for it.
The Family Office Investment Framework
Most family offices evaluate syndication opportunities through a four-lens framework: market thesis (does the macro environment support this investment type), sponsor quality (does the GP have the track record and operational capability to execute), deal economics (do the projected returns justify the risk and illiquidity), and portfolio fit (does this investment complement the family's existing allocations). A deal can be attractive on three dimensions and still fail on the fourth. GPs who understand this framework tailor their materials to address all four evaluation criteria — not just projected returns.
The Model Audit Process
When a family office receives a syndication pitch, their investment team (or external advisor) conducts an independent model audit. This process involves opening the GP's Excel model, tracing every formula from assumptions through cash flow to returns, substituting the family office's own assumptions for key variables, running sensitivity analysis to identify breakeven points, and comparing projected returns against the family's hurdle rates. The audit typically takes 4-8 hours per deal — which is why the model must be provided as a live-formula Excel workbook. Deals presented as PDFs are either rejected outright or significantly delayed while the family office builds their own model from scratch.
Key Metrics Family Offices Evaluate
Beyond headline IRR and equity multiple, family offices focus on metrics that reveal the risk-return profile of the investment. Cash-on-cash return by year shows the income profile during the hold period — many family offices have a minimum annual cash yield requirement (often 5-7%) that must be met regardless of total return. DSCR trajectory through the hold period reveals financing risk. The preferred return and waterfall structure determines downside protection and upside participation. Total fees as a percentage of projected profits reveals GP alignment. The ratio of cash flow returns to appreciation returns indicates how much of the projected return depends on an optimistic exit assumption.
Stress-Testing Through the Family Office Lens
Family offices stress-test differently than GPs. Where a GP might show a base case, optimistic case, and conservative case, a family office runs a "what breaks the deal" analysis: At what vacancy rate does cash-on-cash drop below our minimum yield requirement? At what exit cap rate does the equity multiple fall below 1.5x? What combination of rent growth slowdown and expense inflation eliminates the preferred return? How much of a renovation cost overrun can the deal absorb before requiring a capital call? This analysis does not assume the worst case — it maps the boundaries of acceptable performance. Deals that fail only under extreme scenarios pass this test. Deals with thin margins in moderate scenarios get rejected.
Portfolio Construction Considerations
Family offices evaluate each syndication opportunity within the context of their broader real estate allocation. They consider geographic diversification (avoiding overconcentration in one market), strategy diversification (balancing core, core-plus, value-add, and opportunistic investments), vintage year diversification (spreading investments across economic cycles), and sponsor diversification (not overallocating to any single GP). A GP whose deal is the family office's fifth multifamily value-add in the same market faces a higher bar than one offering a differentiated risk profile. Understanding where your deal fits in a family office's portfolio context helps you position it more effectively.
Key Takeaways
- Family offices evaluate deals through four lenses: market thesis, sponsor quality, deal economics, and portfolio fit
- The model audit process requires live-formula Excel workbooks — PDFs are disqualifying
- Family offices apply a 200-300 basis point haircut to GP-projected returns
- Stress-testing focuses on "what breaks the deal" rather than base/best/worst scenarios
- Portfolio context matters — your deal is evaluated against the family's entire allocation strategy
- Address all four evaluation criteria in your materials, not just projected returns
Related Glossary Terms
Limited Partner (LP)
A passive investor who contributes capital to a syndication but does not participate in day-to-day management.
Internal Rate of Return (IRR)
The annualized rate of return that makes the net present value of all cash flows equal to zero.
Equity Multiple
The total cash distributions received divided by the total equity invested, expressed as a multiple (e.g., 2.0x).
Preferred Return (Pref)
The minimum annualized return that must be paid to LPs before the GP participates in any profit distributions.
Related Articles
Live-Formula Excel Exports: Why Your LPs and Lenders Demand Auditable Workbooks
Why static PDF reports fail institutional due diligence. Learn how live-formula Excel exports with traceable calculations meet the standard that sophisticated investors expect.
Deal StructuringA/B/C Investor Classes in Syndication: When and How to Use Multi-Class Equity Structures
Multi-class equity structures let you attract different investor profiles with tailored risk-return profiles. Learn when to use Class A/B/C investors and how to model them correctly.
AnalysisSensitivity Analysis for Syndication Deals: Stress-Testing Your Underwriting
How to run sensitivity analysis on syndication deals. Covers the key variables to stress-test, scenario planning for LP presentations, and what lenders actually want to see.
Ready to Model This in Your Deals?
Syndication Analyzer handles platform with institutional-grade accuracy — no spreadsheet errors, no broken formulas.
Get Early Access