Waterfall modeling for co-investments turns a simple partnership agreement into a clear map of who gets paid when, and how much, once a New York deal produces cash. A supply and demand scorecard sharpens that map by ranking how much capital is chasing similar opportunities and how eager sponsors and limited partners are to commit. Together they give any adult investor a practical way to judge fairness before signing. This piece walks through both tools with New York examples, plain language, and the exact links you can follow for deeper reading on foundation-newyork.com.
Reading Waterfall Tiers Inside New York Co-Investments
A waterfall is simply the order in which money flows out of a deal after expenses and debt service. In a typical New York co-investment the first tier returns capital to everyone who put equity in. The second tier often pays a preferred return, commonly six to eight percent annualized. Later tiers split remaining profit between the sponsor and the co-investors according to a promote schedule. Understanding each tier prevents surprises when an office recapitalization or multifamily sale finally closes.
New York structures frequently add catch-up language that lets the sponsor receive a larger share once the preferred return is met. Co-investors need to model that catch-up carefully because it can shift tens of millions of dollars on a Midtown tower sale. Modeling software is helpful, yet the logic itself can be sketched on paper: list every cash event, apply the waterfall sequence, and watch who ends up with what percentage of total profit.
Local custom also matters. Many Manhattan partnerships insert a look-back provision that recalculates the promote at final exit if earlier distributions were uneven. Reading the actual limited partnership agreement side by side with your model keeps the numbers honest. For further context on how capital providers screen similar deals, see How Family Offices Evaluate Manhattan Off-Market Opportunities.
Mapping Supply Factors That Feed Co-Invest Capital
Supply in this scorecard means the volume of capital ready to co-invest in New York real estate at any moment. Family offices, pension funds, and foreign pools all contribute. When dry powder is high, sponsors can demand more favorable promote terms. When dry powder is scarce, co-investors gain leverage to negotiate better preferred returns or lower catch-up hurdles.
Track public signals first. The Federal Reserve Bank of New York publishes regional credit conditions that hint at bank willingness to finance acquisitions. Softening loan standards often free equity capital for co-invest slots. Private market surveys and Foundation research both show that air-rights assemblages and large office recaps absorb the bulk of available co-invest dollars in Midtown. Compare those absorption rates with your own pipeline to judge whether supply is tight or loose.
Foreign capital adds another layer. Recent rule changes affect how overseas buyers participate, so the practical reading is available at What New York's Latest Foreign Investment Rules Mean for Overseas Buyers. Factor those constraints into your supply score: a sudden drop in inbound equity can tighten overall co-invest supply even if domestic funds remain flush.
Tracking Demand Pressures Across Asset Classes
Demand measures how eagerly sponsors and existing investors want co-invest partners for specific New York opportunities. High demand appears when a sponsor opens a co-invest window on a well-located trophy asset and receives more interest than it can accept. Low demand shows up when a secondary office building struggles to fill its equity stack despite aggressive terms.
Tenant quality drives much of that demand. Strong credit tenants support higher leverage and more predictable cash flow, which in turn attracts co-investors who value stability. Modeling approaches that scale for tenant analysis are outlined at Tenant Credit Analysis in Office Recaps: Modeling Approaches That Scale. Use those techniques to score demand: a building with long-term investment-grade leases scores higher than one facing near-term rollover risk.
Macro backdrop also shapes demand. When the US Federal Reserve signals rate cuts, refinancing becomes easier and more sponsors launch co-invest vehicles. Conversely, tighter policy can cool enthusiasm. Keep a simple demand ledger that records open co-invest offers, oversubscription ratios if disclosed, and the speed at which equity closes. Over several quarters the ledger reveals whether demand is rising or falling for the asset types you care about.
Building the Combined Supply-Demand Scorecard
The scorecard itself is a one-page grid. List five to seven supply indicators down the left column: total dry powder estimates, foreign capital availability, bank lending standards, competing fund launches, and recent co-invest pricing. Across the top place demand indicators: number of open co-invest slots, average oversubscription, tenant credit strength, and sponsor reputation. Score each cell from one to five, then average the columns.
A high supply score paired with low demand score suggests co-investors hold negotiating power; press for higher preferred returns or reduced promote. The reverse pairing warns that sponsors can dictate terms and that your model should stress-test aggressive catch-up language. Equal scores imply balanced markets where standard waterfall terms are likely fair. Update the grid quarterly so it remains a living tool rather than a one-time exercise.
Weighting can be tailored. If your mandate focuses on Midtown air rights, give extra weight to supply indicators tied to land and development capital. Guidance on that niche appears in Air Rights Assembly in Midtown: 2026 Data and Macro Context. The scorecard stays flexible enough for any New York sub-market once you choose the right weights.
Stress-Testing Waterfall Outcomes with Scorecard Inputs
Once the scorecard produces a market tone, feed that tone back into the waterfall model. In a high-demand environment assume the sponsor will capture a larger promote share and model the cash flows accordingly. In a high-supply environment insert more favorable preferred returns for co-investors and watch how the internal rate of return improves. Running both base and stress cases side by side shows the range of possible outcomes before you commit capital.
Default scenarios deserve special attention. Limited partners sometimes fail to fund capital calls, which can reorder the waterfall or force forced sales. Practical forecast inputs for those events are collected at LP Default Resolution Frameworks: Forecast Inputs the Market Uses. Incorporate those inputs so your model does not assume perfect funding behavior.
Sensitivity tables help non-experts see the impact quickly. Change one waterfall tier at a time, hold everything else constant, and record the change in co-investor equity multiple. The table reveals which clauses matter most and which can be accepted as written. Keep the table simple: five rows for key waterfall terms and three columns for base, optimistic, and conservative market tones drawn from the scorecard.
Local Data Sources That Keep Scores Honest
New York data is abundant yet uneven. The City of New York releases property tax assessments, zoning updates, and building permits that signal future supply of investable assets. Pair those public files with private co-invest term sheets to calibrate your scorecard. When permit volume rises sharply, expect more development co-invest opportunities and adjust the supply column upward.
Regulatory filings add another check. The US Securities and Exchange Commission hosts private fund reports that reveal how large managers are deploying capital into real estate. Cross-reference those reports with Foundation market notes to avoid double-counting the same dry powder. Global macro context is equally useful; browse recent IMF publications for capital-flow trends that eventually reach New York co-invest markets.
Internal Foundation resources round out the picture. Browse the full Investor Tips Insights archive for prior modeling case studies, and check the FAQ (frequently asked questions) for quick definitions of promote, catch-up, and preferred return. Regular reading of the Blog keeps the scorecard current without requiring paid data feeds.
Turning Scorecard Results into Clear Deal Choices
Numbers alone do not decide. After the model and scorecard agree, write a one-paragraph recommendation that states whether the waterfall terms are attractive relative to current supply and demand. Share that paragraph with partners or advisors so everyone sees the same logic. If the scorecard flags elevated demand, walk away from terms that give the sponsor an outsized promote unless the asset quality is exceptional.
Document every assumption so the analysis can be revisited after closing. Markets shift, and a deal that looked balanced in a high-supply quarter may look generous to the sponsor once capital dries up. Re-running the model with updated scores six months later provides a reality check and builds institutional memory for the next opportunity.
Finally, remember that waterfall modeling and the supply-demand scorecard are living tools. They improve with practice and with each new New York transaction. Start simple, stay consistent, and let the numbers guide judgment rather than replace it. The result is clearer co-investment decisions and fewer post-closing regrets.
Related Foundation reading: Our approach.
Timeless Value. Perpetual Legacy.
