Companion files · The Private Markets Career Guides

The Real Estate Syndicator

A Practitioner's Guide to Real Estate Syndication: Regulation D, Multifamily Underwriting, Debt and Rate Caps, Waterfalls, Sponsor Fees and Investor Reporting.

DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample

These are the companion files of the book. One workbook rebuilds the Tarrowmere case: Quellbrook Residential Partners, a fictional sponsor, buys a fictional 240-unit apartment community for $35.00 million, renovates 180 units, finances the deal with a floating-rate loan and a rate cap, raises $15.22 million of equity and sells after five years. Every line runs by live formula, from the operating statement to the waterfall, with a rate shock switch, a cap switch and a sensitivity grid. A toolkit holds the checklists of Appendix B in an editable form.

The workbook, the toolkit and the read-me, in one archive113 KB

The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.

The files

Three numbers to reproduce first

The NOI240 units at $1,450 a month, less vacancy, downtime and expenses: a 2027 NOI of $2,232,105, a going-in cap rate of 6.38 percent on a $35.00 million price
The investorsAn LP IRR of 10.82 percent and an equity multiple of 1.62x after all fees and the promote, before tax
The shockSOFR from 3.75 percent to 6.25 percent and an exit cap rate of 7.00 percent: an LP IRR of 7.30 percent with the rate cap, 6.64 percent without it

The files are provided as they are, without warranty of any kind. The model is illustrative: Quellbrook Residential Partners, Tarrowmere Apartments, their lender and their investors are fictional, and rents, costs, prices, rates, fees and waterfall terms are the book’s assumptions, not market data and not the terms of any real offering. Rule texts change. Nothing here is legal, tax or investment advice, or an offer of any security.