Preferred Equity & Cap-Stack Model
Syndication / Fund

Preferred Equity & Cap-Stack Model

Model a full real estate capital stack — senior debt, mezzanine, preferred equity (PIK and cash pay), and common equity — with waterfall distribution by tranche, preferred return calculation, and sensitivity analysis on exit cap rate and leverage.

zip70 KBVersion 1.0.0 · Updated July 2026Instant download · Secure checkout

What's included

  • Fully unlocked Excel (.xlsx) — no formula protection
  • Capital stack model with senior debt, mezzanine, preferred equity, and common equity
  • Preferred equity return calculation with PIK and cash pay options
  • Waterfall distribution by tranche
  • Methodology documentation PDF + model walkthrough guide

Coming in 2027

YieldSheets is building a cloud underwriting tool — the same models, in your browser, with collaboration. Join the waitlist