Companion files · The Private Markets Career Guides
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 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.
Chapters 6 to 10, 12, 13 and 16, and Appendix A
An Inputs sheet holds every assumption of the case, and one sheet follows each step of the book: Operations, Renovation, Sources and Uses, Debt, Rate Shock, Waterfall, Returns, Sensitivity. A Checks sheet puts the figures printed in the book beside the cells that compute them, and the 14 exercises of Appendix A run on it.
Download the workbook79 KBAppendix B
Before the first investor conversation: 506(b) or 506(c); The accredited investor verification file; Form D and state notice filings calendar; Underwriting the rent roll and the T12; The renovation program; The floating-rate loan and rate cap term sheet; Operating agreement and PPM review; The quarterly investor report and the capital call protocol.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| The NOI | 240 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 investors | An LP IRR of 10.82 percent and an equity multiple of 1.62x after all fees and the promote, before tax |
| The shock | SOFR 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.