# The Real Estate Syndicator: companion files

Julian R. Sterling

## What is here

- **Real_Estate_Syndicator_Model.xlsx**: the workbook that rebuilds the Tarrowmere case and reproduces the figures of the book with live formulas. Sheets: Inputs, Operations, Renovation, Sources and Uses, Debt, Rate Shock, Waterfall, Returns, Sensitivity, Checks.
- **Real_Estate_Syndicator_Toolkit.docx**: the 8 checklists of Appendix 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), in editable form.

## Which sheet answers which chapter

- Chapter 6: Operations (the operating statement; a 2027 NOI of $2,232,105, $2,861,924 in 2029)
- Chapter 7: Renovation (180 units at $14,000, a budget of $2.52 million, premiums and downtime)
- Chapter 8: Sources and Uses ($39.72 million in all, a loan of $24.50 million and $15.22 million of equity)
- Chapter 9: Debt (interest, the rate cap, the replacement cap and the extension test; a 2027 DSCR of 1.35x)
- Chapter 10: Rate Shock (LP IRR 7.30 percent with the cap, 6.64 percent without it; the stress, where the operating reserve and a held-back 2029 distribution meet a $667,558 shortfall)
- Chapter 12: Waterfall (the pref, the return of capital and the two promote tiers)
- Chapters 12 and 13: Returns (LP IRR 10.82 percent, equity multiple 1.62x; fees of $1.75 million and a promote of $1.22 million)
- Chapter 16: Sensitivity (LP IRR across three rent growth rates and three exit cap rates)
- Appendix A: 14 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Rate Shock, set the scenario switch to 1: SOFR follows the shock path, the exit cap rate rises to 7.00 percent and the LP IRR falls to 7.30 percent. Then set the cap switch to 0 and watch the DSCR and the LP IRR fall again.
2. On Inputs, move the exit cap rate from 6.50 percent to 7.00 percent: the LPs still earn more than the pref, and the promote almost disappears. Reset the inputs and both switches (0 and 1) afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. The inputs are on the Inputs sheet, except the scenario switches and the shock path (Rate Shock) and the grid headers (Sensitivity). No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Quellbrook Residential Partners, Tarrowmere Apartments, Tarrowmere Holdings LLC, their lender and their investors are fictional; rents, costs, prices, rates, fees, waterfall terms and dates are teaching assumptions, not market data and not the terms of any real offering. Rule texts change: check the current text. Provided as is, without warranty. Not legal, tax or investment advice, and not an offer of any security.
