PropCalc™ LearnStart
Portfolio

Portfolio deal underwriting: multiple properties, one offer

Every so often the market offers a package: several properties, one seller, one price, take it together or not at all. The opportunity in these deals is real and structural, since the buyer pool that can underwrite and finance a package is a fraction of the pool for any single asset in it, and thinner competition is the oldest source of price advantage there is. The difficulty is equally structural: a portfolio is not a big property, and underwriting it as one, or as several small deals stapled together, both fail in ways worth understanding before the offer, not after.

The core discipline is two truths held simultaneously. Each asset keeps its own: its own rent roll and rollover schedule, its own price allocation, its own loan or its share of a blanket loan, its own exit timing and cap. The deal keeps one: one offer, one consolidated capital stack, one set of blended returns, one waterfall paying one group of investors. Collapse the first truth and you have averaged away the fact that asset three is carrying a rollover cliff the package price should reflect. Collapse the second and you cannot answer the only questions the seller, the lender, and the investors will actually ask, which are all about the whole.

Price allocation is where the two truths first collide, and it is not an accounting formality. The allocation across assets drives the basis in each, which drives per-asset loan sizing, release prices if the debt is blanket, tax treatment, and the economics of selling any asset early. A package price that pencils in aggregate can hide one asset priced well above its standalone worth, subsidized by the others, and the buyer who allocates honestly discovers that before closing, while the buyer who spreads the price pro-rata by revenue discovers it at the first partial sale.

The consolidation math is the other collision, and it is genuinely unforgiving of shortcuts. Portfolio returns are computed from the combined cash flow schedule, every asset's flows, on their actual dates, merged, not from averaging the per-asset return metrics, which produces confidently wrong numbers for reasons a companion page on this site covers in detail. Staggered closings, assets selling in different years, capital called as deployed: the timeline is the model, and institutional shops build a custom spreadsheet for every one of these deals precisely because generic models cannot hold the timeline.

That custom-spreadsheet barrier is what Portfolio Deal Underwriting in PropCalc™ removes: every asset underwritten fully on its own merits, consolidated into one offer, one stack, one waterfall, with blended returns computed from the real combined schedule. The package deal is where preparation gets paid best, because so few buyers show up prepared. The next few pages in this library take the portfolio machinery apart piece by piece.

Get the full institutional underwriting package
The complete Crossroads Commons demo deal: lease-by-lease rent roll, 10-year pro forma, LP/GP waterfall, and stress tests in one institutional Excel package. Built in PropCalc™, the commercial real estate underwriting simulator. Free, delivered to your inbox.
See the concept inside a real underwriting simulator
Open a fully worked, fictional deal, or start underwriting your own. 7-day free trial.
View a live deal Start your 7-day free trial
PropCalc is an institutional-grade CRE underwriting simulator. Worked examples use fictional demo deals. Not investment advice.