Companion files · The Private Markets Career Guides
How to Source, Underwrite and Close Commercial Property Deals: Screening, Cash Flow Models, Value-Add Business Plans, Debt, Investment Committee Memos, LOIs, Due Diligence and the Career in Real Estate Private Equity.
These are the companion files of the book. One workbook rebuilds the fictional files of the Brightwater acquisitions team: Larkspur Commons, a 312-unit value-add apartment purchase at $62.4 million, with its cash flows, returns, five sensitivities and maximum bid; Route 9 Logistics Center, a single-tenant warehouse priced at the ask, the LOI and the retrade after a roof turned up in due diligence; and the year of deal flow behind Brightwater Fund IV. 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 4, 6 to 10, 12, 14 and 15
One Inputs sheet holds every assumption: rents, renovations, vacancy, expenses, the loan, exit cap rates, lease rollover, prices and the pipeline. One sheet per analysis, a maximum bid solved in closed form, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook43 KBAppendix B
Screening checklist, underwriting checklist, investment committee memo outline, LOI terms checklist, due diligence checklist, closing checklist and handoff checklist.
Download the toolkit39 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me2 KB| Returns | Larkspur Commons earns a levered IRR of 14.1 percent and an equity multiple of 1.90 times over a five-year hold |
| Maximum bid | The price that earns exactly the 14 percent target, with the loan resized at 60 percent, is $62.5 million; Brightwater paid $62.4 million |
| Retrade | A $2.1 million roof cut the Route 9 price by $1.5 million, to $54.0 million: the seller bore 71 percent of the roof |
The files are provided as they are, without warranty of any kind. Brightwater Real Estate Partners, Brightwater Fund IV, Larkspur Commons and Route 9 Logistics Center are fictional, the models are simplified teaching models, and the figures are the book’s assumptions, not market terms or forecasts. Nothing here is investment advice.
More in real estate, with free companion files. The full list of titles is on the author page.
Optional: join the reader list to get an email when a workbook is corrected or a new title goes up.
Also available as a standalone free template: commercial real estate underwriting model.