A single-asset waterfall is a solved problem: capital back, pref, promote tiers, everyone understands the machine. Stretch the same machine across a portfolio, one investor group funding four assets that close on different dates, perform differently, and sell in different years, and the machine sprouts structural questions that the single-asset version never had to answer. The questions get settled in the operating agreement, before closing, and the sponsors who have modeled them arrive at that negotiation knowing what each answer costs.
The first question is when distributions fire. Asset two sells in year three at a strong price while the rest of the portfolio holds. Does that capital flow through the waterfall now, returning capital and possibly starting the promote, or does it wait for the portfolio's story to finish? Early flow rewards the investors' IRR and hands the sponsor a promote earned on one asset's success before the others have proven anything, which is exactly the scenario that produces the second question: what happens if asset four later underperforms? Deal-by-deal treatment with no lookback can leave the sponsor promoted on the winner while investors absorb the loser, and the standard repair, a clawback or a crossed structure where all assets vouch for each other, is precisely the clause nobody reads until they need it.
The third question is whether the pref accrues on committed capital or deployed capital, which staggered closings turn from pedantry into money: capital called in tranches means the pref clock starts at different times on different dollars, and the difference across a long deployment is real. The fourth is measurement: promote hurdles computed at the portfolio level, on the merged cash flow schedule, behave differently from hurdles computed per asset and summed, and the two constructions can promote the sponsor at different times off identical performance. None of these questions has a universally right answer. All of them have a price, and the price should be computed rather than discovered.
Computed means modeled on the real timeline. A portfolio waterfall cannot be checked on intuition or on a single-asset template, because its behavior is exactly the interaction of asset-level timing with structure-level rules: distributions firing as each asset performs, capital called as deployed, hurdles measured on the combined stream. This is the analysis that lives in a custom spreadsheet at institutional shops, built per deal, by someone whose whole job is that spreadsheet.
Portfolio Deal Underwriting in PropCalc™ runs the consolidated waterfall natively, one structure across every asset, distributions firing as each asset sells or refinances, promote tiers measured on the merged schedule, so both sides of the table can watch the machine run before anyone signs the document that builds it. A waterfall is a promise about sequencing. Across a portfolio, the sequencing is the negotiation, and the model is how you negotiate it with your eyes open.