Debt Fund Model
Syndication / Fund

Debt Fund Model

Model a CRE debt fund from origination through repayment. Input your loan origination pipeline, interest income schedule, management fees, and fund expenses — output fund-level IRR, equity multiple, and LP distribution waterfall with preferred return.

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

What's included

  • Fully unlocked Excel (.xlsx) — no formula protection
  • Debt fund cash flow model with loan origination and repayment schedule
  • Fund-level IRR and equity multiple
  • LP distribution waterfall with preferred return
  • 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