Companion files · The Private Markets Career Guides

The Real Estate Capital Markets Advisor

How to Place Debt, Raise Equity and Sell Commercial Property: Loan Sizing, Lender Quotes, Joint Venture Waterfalls, Investment Sales and the Career.

These are the companion files of the book. One workbook rebuilds the three fictional deals of the Halsted Capital Advisors team: Marlowe Gardens, an apartment portfolio refinanced after five lender quotes sized against loan-to-value, debt service coverage and debt yield; Wexford Yards, an industrial development whose joint venture equity runs through a three-tier waterfall; and Calder Logistics Park, an industrial park sold through a best and final round. A toolkit holds the checklists of Appendix B in an editable form.

The workbook, the toolkit and the read-me, in one archive57 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

Loan sizingThe agency loan on Marlowe Gardens is $214.1 million, set by its 1.20x coverage test, not by its 65 percent loan-to-value limit
WaterfallTamsin earns a 21.9 percent IRR on Wexford Yards and Oakvale 46.8 percent, with $5.8 million of promote
Investment saleCalder Logistics Park sells for $231.0 million, a 5.19 percent cap rate, $2.4 million above the best first-round bid

The files are provided as they are, without warranty of any kind. The models are illustrative: Halsted Capital Advisors, Selwyn Residential, Oakvale Development, Tamsin Investment Management, Ferrand Industrial Trust and Lowry Logistics Partners are fictional, the models are simplified, and the figures are the book’s assumptions, not market terms, ratings or forecasts. Nothing here is investment, legal, tax or accounting advice.

Also by Julian R. Sterling

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.